{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ExampleDataset","Dataset","Dataset(Source)","FillData","DataFillUsingVLOOKUP","MultipleValueFinding"],"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":"ExampleDataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Marksheet"]
[]
[null,"Student ID","Student Name","Marks"]
[null,"S1","Alice",85]
[null,"S2","Bob",70]
[null,"S3","Charlie",92]
[null,"S4","David",78]
[null,"S5","Emily",88]

{"sheet":"Dataset","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Data"]
[]
[null,"Salesperson ID","Salesperson Name","Product","Product ID","Total Sales"]
[null,"SP001","John","Shoes","PI101",100]
[null,"SP001","John","Shirts","PI102",200]
[null,"SP001","John","Hats","PI103",150]
[null,"SP002","Sarah","Shoes","PI101",75]
[null,"SP002","Sarah","Shirts","PI102",300]
[null,"SP002","Sarah","Hats","PI103",50]
[null,"SP003","Tom","Shoes","PI101",150]
[null,"SP003","Tom","Shirts","PI102",100]
[null,"SP003","Tom","Hats","PI103",175]

{"sheet":"Dataset(Source)","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Data"]
[]
[null,"Salesperson ID","Salesperson Name","Product","Product ID","Total Sales"]
[null,"SP001","John","Shoes","PI101",100]
[null,"SP001","John","Shirts","PI102",200]
[null,"SP001","John","Hats","PI103",150]
[null,"SP002","Sarah","Shoes","PI101",75]
[null,"SP002","Sarah","Shirts","PI102",300]
[null,"SP002","Sarah","Hats","PI103",50]
[null,"SP003","Tom","Shoes","PI101",150]
[null,"SP003","Tom","Shirts","PI102",100]
[null,"SP003","Tom","Hats","PI103",175]

{"sheet":"FillData","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Get Data from Different Worksheet"]
[]
[null,"Salesperson ID","Salesperson Name"]
[null,"SP001","John"]
[null,"SP001","John"]
[null,"SP001","John"]
[null,"SP002","Sarah"]
[null,"SP002","Sarah"]
[null,"SP002","Sarah"]
[null,"SP003","Tom"]
[null,"SP003","Tom"]
[null,"SP003","Tom"]

{"sheet":"DataFillUsingVLOOKUP","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Get Data from Same Worksheet"]
[]
[null,"Salesperson Name","Salesperson ID","Product","Product ID","Total Sales","Department",null,"Salesperson ID","Department"]
[null,"John","SP001","Shoes","PI101",100,"Sales",null,"SP001","Sales"]
[null,"John","SP001","Shirts","PI102",200,"Sales",null,"SP002","Marketing"]
[null,"John","SP001","Hats","PI103",150,"Sales",null,"SP003","Promotion"]
[null,"Sarah","SP002","Shoes","PI101",75,"Marketing",null,"SP004","Sales"]
[null,"Sarah","SP002","Shirts","PI102",300,"Marketing",null,"SP005","Marketing"]
[null,"Sarah","SP002","Hats","PI103",50,"Marketing",null,"SP006","Promotion"]
[null,"Tom","SP003","Shoes","PI101",150,"Promotion",null,"SP007","Sales"]
[null,"Tom","SP003","Shirts","PI102",100,"Promotion",null,"SP008","Marketing"]
[null,"Tom","SP003","Hats","PI103",175,"Promotion",null,"SP009","Promotion"]

{"sheet":"MultipleValueFinding","index":5,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Finding Multiple Values with Vlookup"]
[]
[null,"Salesperson ID","Salesperson Name","Product","Product ID","Total Sales",null,"Salesperson Name","Product"]
[null,"SP001","John","Shoes","PI101",100,null,"Sarah"," Shoes, Shirts, Hats"]
[null,"SP001","John","Shirts","PI102",200,null,"John"," Shoes, Shirts, Hats"]
[null,"SP001","John","Hats","PI103",150,null,"Tom"," Shoes, Shirts, Hats"]
[null,"SP002","Sarah","Shoes","PI101",75]
[null,"SP002","Sarah","Shirts","PI102",300]
[null,"SP002","Sarah","Hats","PI103",50]
[null,"SP003","Tom","Shoes","PI101",150]
[null,"SP003","Tom","Shirts","PI102",100]
[null,"SP003","Tom","Hats","PI103",175]