{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sample Data Set_1","Sample Data Set_1 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":2},"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":"Sheet1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Showing Final Output "]
[]
[null,"Row Labels","Sum of Sales ","Sum of Profit"]
[null,"Dennis",51234,53795.7]
[null,"Diana",90000,94500]
[null,"John",100000,105000]
[null,"Lisa",85000,89250]
[null,"Mark",122882,129026.1]
[null,"Richard",50000,52500]
[null,"Robert",40000,42000]
[null,"Grand Total",539116,566071.80000000005]

{"sheet":"Sheet2","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Showing Final Output "]
[]
[null,"Row Labels","Sum of Sales ","Sum of Fund"]
[null,"Dennis",51234,54871.613999999994]
[null,"Diana",90000,96390]
[null,"John",100000,107100]
[null,"Lisa",85000,91035]
[null,"Mark",122882,131606.622]
[null,"Richard",50000,53550]
[null,"Robert",40000,42840]
[null,"Grand Total",539116,577393.23600000003]

{"sheet":"Sample Data Set_1","index":2,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null," Altering Value in Source Data Set",null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name ","Seller Name","Sales ","Profit","Fund",null,"Product Name ","Seller Name","Sales ","Profit","Fund"]
[null,"Laptop","John",90000,{"$f":"D5+D5*(5%)","v":94500},{"$f":"E5+E5*(2%)","v":96390},null,"Laptop","John",90000]
[null,"Laptop","Mark",30000,{"$f":"D6+D6*(5%)","v":31500},{"$f":"E6+E6*(2%)","v":32130},null,"Laptop","Mark",30000]
[null,"Laptop","Diana",10000,10500,10710,null,"Laptop","Diana",10000]
[null,"Laptop","Robert",40000,42000,42840,null,"Laptop","Robert",40000]
[null,"Laptop","Lisa",30000,31500,32130,null,"Laptop","Lisa",30000]
[null,"Mouse Pad","Richard",50000,52500,53550,null,"Mouse Pad","Richard",50000]
[null,"Mouse Pad","Dennis",51234,53795.7,54871.613999999994,null,"Mouse Pad","Dennis",51234]
[null,"Microphone","Mark",92882,97526.1,99476.622000000003,null,"Microphone","Mark",92882]
[null,"Microphone","John",10000,10500,10710,null,"Microphone","John",10000]
[null,"Microphone","Lisa",30000,31500,32130,null,"Microphone","Lisa",30000]
[null,"Mouse Pad","Lisa",25000,26250,26775,null,"Mouse Pad","Lisa",25000]
[null,"Mouse Pad","Diana",80000,84000,85680,null,"Mouse Pad","Diana",80000]

{"sheet":"Sample Data Set_1 (2)","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Making Data Set"]
[]
[null,"Product Name ","Seller Name","Sales ","Profit","Fund"]
[null,"Laptop","John",90000]
[null,"Laptop","Mark",30000]
[null,"Laptop","Diana",10000]
[null,"Laptop","Robert",40000]
[null,"Laptop","Lisa",30000]
[null,"Mouse Pad","Richard",50000]
[null,"Mouse Pad","Dennis",51234]
[null,"Microphone","Mark",92882]
[null,"Microphone","John",10000]
[null,"Microphone","Lisa",30000]
[null,"Mouse Pad","Lisa",125412]
[null,"Mouse Pad","Diana",80000]