{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Dynamic Tooltip","Data Validation Option","Excel VBA","Link Option"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Name","Date of Birth","Age"]
[null,"Smith","1998-02-08",{"$f":"DATEDIF(C5,TODAY(),\"y\")","v":25}]
[null,"Johnson","2000-05-12",{"$f":"DATEDIF(C6,TODAY(),\"y\")","v":23}]
[null,"Mary","1999-08-19",23]
[null,"Williams","1996-05-28",27]
[null,"Patricia","2001-06-21",22]
[null,"Robert","1996-04-10",27]

{"sheet":"Dynamic Tooltip","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Dynamic Tooltip"]
[]
[null,"S.L No","Name","Tooltip"]
[null,1,"Williams",{"$f":"IFERROR(VLOOKUP(C5,Dataset!$B$4:$D$10,{2,3},FALSE),\"\")","v":"1996-05-28"},27]
[null,2,"Robert",{"$f":"IFERROR(VLOOKUP(C6,Dataset!$B$4:$D$10,{2,3},FALSE),\"\")","v":"1996-04-10"},27]
[null,3,"Mary",{"$f":"IFERROR(VLOOKUP(C7,Dataset!$B$4:$D$10,{2,3},FALSE),\"\")","v":"1999-08-19"},23]
[null,4,"Smith",{"$f":"IFERROR(VLOOKUP(C8,Dataset!$B$4:$D$10,{2,3},FALSE),\"\")","v":"1998-02-08"},25]

{"sheet":"Data Validation Option","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Validation Feature",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Age",null,null,null,null,null,"Name","Date of Birth","Age"]
[null,"Smith","1998-02-08",{"$f":"DATEDIF(C5,TODAY(),\"y\")","v":25},null,null,null,null,null,"Smith","1998-02-08",{"$f":"DATEDIF(K5,TODAY(),\"y\")","v":25}]
[null,"Johnson","2000-05-12",{"$f":"DATEDIF(C6,TODAY(),\"y\")","v":23},null,null,null,null,null,"Johnson","2000-05-12",{"$f":"DATEDIF(K6,TODAY(),\"y\")","v":23}]
[null,"Mary","1999-08-19",23,null,null,null,null,null,"Mary","1999-08-19",23]
[null,"Williams","1996-05-28",27,null,null,null,null,null,"Williams","1996-05-28",27]
[null,"Patricia","2001-06-21",22,null,null,null,null,null,"Patricia","2001-06-21",22]
[null,"Robert","1996-04-10",27,null,null,null,null,null,"Robert","1996-04-10",27]

{"sheet":"Excel VBA","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,3]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Age",null,null,null,null,null,"Name","Date of Birth","Age"]
[null,"Smith","1998-02-08",{"$f":"DATEDIF(C5,TODAY(),\"y\")","v":25},null,null,null,null,null,"Smith","1998-02-08",{"$f":"DATEDIF(K5,TODAY(),\"y\")","v":25}]
[null,"Johnson","2000-05-12",{"$f":"DATEDIF(C6,TODAY(),\"y\")","v":23},null,null,null,null,null,"Johnson","2000-05-12",{"$f":"DATEDIF(K6,TODAY(),\"y\")","v":23}]
[null,"Mary","1999-08-19",23,null,null,null,null,null,"Mary","1999-08-19",23]
[null,"Williams","1996-05-28",27,null,null,null,null,null,"Williams","1996-05-28",27]
[null,"Patricia","2001-06-21",22,null,null,null,null,null,"Patricia","2001-06-21",22]
[null,"Robert","1996-04-10",27,null,null,null,null,null,"Robert","1996-04-10",27]

{"sheet":"Link Option","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Link Option",null,null,null,null,"Try Yourself"]
[]
[null,"Name","Date of Birth","Age",null,null,"Name","Date of Birth","Age"]
[null,"Smith","1998-02-08",{"$f":"DATEDIF(C5,TODAY(),\"y\")","v":25},null,null,"Smith","1998-02-08",{"$f":"DATEDIF(H5,TODAY(),\"y\")","v":25}]
[null,"Johnson","2000-05-12",{"$f":"DATEDIF(C6,TODAY(),\"y\")","v":23},null,null,"Johnson","2000-05-12",{"$f":"DATEDIF(H6,TODAY(),\"y\")","v":23}]
[null,"Mary","1999-08-19",23,null,null,"Mary","1999-08-19",23]
[null,"Williams","1996-05-28",27,null,null,"Williams","1996-05-28",27]
[null,"Patricia","2001-06-21",22,null,null,"Patricia","2001-06-21",22]
[null,"Robert","1996-04-10",27,null,null,"Robert","1996-04-10",27]