{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample Dataset","Using Cell Reference","Using VBA"],"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":"Sample Dataset","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Name","Subject","Marks"]
[null,"Ross","Art",90]
[null,"Ross","Mathematics",95]
[null,"Ross","Music",75]
[null,"Phoebe","Music",85]
[null,"Phoebe","Mathematics",73]
[null,"Phoebe","Art",85]
[null,"Joey","Art",78]
[null,"Joey","Mathematics",70]
[null,"Joey","Music",90]
[null,"Adam","Mathematics",85]
[null,"Adam","History",78]
[null,"Adam","Geography",90]

{"sheet":"Using Cell Reference","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,6],[1,10,1,11],[3,10,3,11]]}
[]
[null,"Using Cell Reference",null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Name","Subject","Marks",null,"Marks of Adam",null,null,null,null,"Marks of Adam"]
[null,{"$f":"'Sample Dataset'!B5","v":"Ross"},{"$f":"'Sample Dataset'!C5","v":"Art"},{"$f":"'Sample Dataset'!D5","v":90},null,"Subject","Marks",null,null,null,"Subject","Marks"]
[null,{"$f":"'Sample Dataset'!B6","v":"Ross"},{"$f":"'Sample Dataset'!C6","v":"Mathematics"},{"$f":"'Sample Dataset'!D6","v":95},null,{"$f":"C14","v":"Mathematics"},{"$f":"D14","v":85}]
[null,{"$f":"'Sample Dataset'!B7","v":"Ross"},{"$f":"'Sample Dataset'!C7","v":"Music"},{"$f":"'Sample Dataset'!D7","v":75},null,{"$f":"C15","v":"History"},{"$f":"D15","v":78}]
[null,{"$f":"'Sample Dataset'!B8","v":"Phoebe"},{"$f":"'Sample Dataset'!C8","v":"Music"},{"$f":"'Sample Dataset'!D8","v":85},null,"Geography",90]
[null,{"$f":"'Sample Dataset'!B9","v":"Phoebe"},{"$f":"'Sample Dataset'!C9","v":"Mathematics"},{"$f":"'Sample Dataset'!D9","v":73}]
[null,{"$f":"'Sample Dataset'!B10","v":"Phoebe"},{"$f":"'Sample Dataset'!C10","v":"Art"},{"$f":"'Sample Dataset'!D10","v":85}]
[null,{"$f":"'Sample Dataset'!B11","v":"Joey"},{"$f":"'Sample Dataset'!C11","v":"Art"},{"$f":"'Sample Dataset'!D11","v":78}]
[null,{"$f":"'Sample Dataset'!B12","v":"Joey"},{"$f":"'Sample Dataset'!C12","v":"Mathematics"},{"$f":"'Sample Dataset'!D12","v":70}]
[null,{"$f":"'Sample Dataset'!B13","v":"Joey"},{"$f":"'Sample Dataset'!C13","v":"Music"},{"$f":"'Sample Dataset'!D13","v":90}]
[null,{"$f":"'Sample Dataset'!B14","v":"Adam"},{"$f":"'Sample Dataset'!C14","v":"Mathematics"},{"$f":"'Sample Dataset'!D14","v":85}]
[null,{"$f":"'Sample Dataset'!B15","v":"Adam"},{"$f":"'Sample Dataset'!C15","v":"History"},{"$f":"'Sample Dataset'!D15","v":78}]
[null,{"$f":"'Sample Dataset'!B16","v":"Adam"},{"$f":"'Sample Dataset'!C16","v":"Geography"},{"$f":"'Sample Dataset'!D16","v":90}]

{"sheet":"Using VBA","index":2,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,6],[3,10,3,11],[1,10,1,11]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Name","Subject","Marks",null,"Marks of Adam",null,null,null,null,"Marks of Adam"]
[null,"Ross","Art",90,null,"Subject","Marks",null,null,null,"Subject","Marks"]
[null,"Ross","Mathematics",95,null,"Mathematics",85]
[null,"Ross","Music",75,null,"History",78]
[null,"Phoebe","Music",85,null,"Geography",90]
[null,"Phoebe","Mathematics",73]
[null,"Phoebe","Art",85]
[null,"Joey","Art",78]
[null,"Joey","Mathematics",70]
[null,"Joey","Music",90]
[null,"Adam","Mathematics",85]
[null,"Adam","History",78]
[null,"Adam","Geography",90]