{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["January","February","March","Cell Ref","3D Ref","Consolidate","PowerQuery","Jan","Feb","Mar","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"January","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Data of January"]
[]
[null,"Products","Qty Produced","Qty Sold"]
[null,"Desktop",746,700]
[null,"Laptop",600,559]
[null,"Smartphone",616,612]
[null,"Table Fan",690,302]
[null,"Telephone",783,487]
[null,"Radio",423,51]
[null,"Television",771,601]
[null,"Bicycle",852,553]
[null,"Motorcycle",554,57]
[null,"Private Car",612,559]
[null,"Table Lamp",478,373]
[null,"Guitar",786,710]
[null,"Violin",766,714]
[null,"Dinner Set",552,433]
[null,"Wrist Watch",609,512]

{"sheet":"February","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Data of February"]
[]
[null,"Products","Qty Produced","Qty Sold"]
[null,"Desktop",813,700]
[null,"Laptop",600,589]
[null,"Smartphone",450,412]
[null,"Table Fan",980,881]
[null,"Telephone",333,227]
[null,"Radio",867,101]
[null,"Television",533,401]
[null,"Bicycle",782,553]
[null,"Motorcycle",992,577]
[null,"Private Car",408,359]
[null,"Table Lamp",564,373]
[null,"Guitar",957,881]
[null,"Violin",538,314]
[null,"Dinner Set",696,513]
[null,"Wrist Watch",627,400]

{"sheet":"March","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Data of March"]
[]
[null,"Products","Qty Produced","Qty Sold"]
[null,"Desktop",983,717]
[null,"Laptop",535,489]
[null,"Smartphone",704,412]
[null,"Table Fan",941,707]
[null,"Telephone",378,247]
[null,"Radio",906,121]
[null,"Television",622,405]
[null,"Bicycle",461,333]
[null,"Motorcycle",877,561]
[null,"Private Car",810,451]
[null,"Table Lamp",469,201]
[null,"Guitar",563,399]
[null,"Violin",712,101]
[null,"Dinner Set",656,490]
[null,"Wrist Watch",997,600]

{"sheet":"Cell Ref","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,5,3,6]]}
[]
[null,"Using Formula"]
[]
[null,"Products","Total Sales",null,null,"Practice Here!"]
[null,"Desktop",{"$f":"January!D5+February!D5+March!D5","v":2117}]
[null,"Laptop",{"$f":"January!D6+February!D6+March!D6","v":1637},null,null,"Products","Total Sales"]
[null,"Smartphone",{"$f":"January!D7+February!D7+March!D7","v":1436},null,null,"Desktop"]
[null,"Table Fan",{"$f":"January!D8+February!D8+March!D8","v":1890},null,null,"Laptop"]
[null,"Telephone",{"$f":"January!D9+February!D9+March!D9","v":961},null,null,"Smartphone"]
[null,"Radio",{"$f":"January!D10+February!D10+March!D10","v":273},null,null,"Table Fan"]
[null,"Television",{"$f":"January!D11+February!D11+March!D11","v":1407},null,null,"Telephone"]
[null,"Bicycle",{"$f":"January!D12+February!D12+March!D12","v":1439},null,null,"Radio"]
[null,"Motorcycle",{"$f":"January!D13+February!D13+March!D13","v":1195},null,null,"Television"]
[null,"Private Car",{"$f":"January!D14+February!D14+March!D14","v":1369},null,null,"Bicycle"]
[null,"Table Lamp",{"$f":"January!D15+February!D15+March!D15","v":947},null,null,"Motorcycle"]
[null,"Guitar",{"$f":"January!D16+February!D16+March!D16","v":1990},null,null,"Private Car"]
[null,"Violin",{"$f":"January!D17+February!D17+March!D17","v":1129},null,null,"Table Lamp"]
[null,"Dinner Set",{"$f":"January!D18+February!D18+March!D18","v":1436},null,null,"Guitar"]
[null,"Wrist Watch",{"$f":"January!D19+February!D19+March!D19","v":1512},null,null,"Violin"]
[null,null,null,null,null,"Dinner Set"]
[null,null,null,null,null,"Wrist Watch"]

{"sheet":"3D Ref","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[5,4,5,5]]}
[]
[null,"Using Formula"]
[]
[null,"Products","Total Sales"]
[null,"Desktop",{"$f":"SUM(January:March!D5)","v":2117}]
[null,"Laptop",{"$f":"SUM(January:March!D6)","v":1637},null,"Practice Here!"]
[null,"Smartphone",{"$f":"SUM(January:March!D7)","v":1436}]
[null,"Table Fan",{"$f":"SUM(January:March!D8)","v":1890},null,"Products","Total Sales"]
[null,"Telephone",{"$f":"SUM(January:March!D9)","v":961},null,"Desktop"]
[null,"Radio",{"$f":"SUM(January:March!D10)","v":273},null,"Laptop"]
[null,"Television",{"$f":"SUM(January:March!D11)","v":1407},null,"Smartphone"]
[null,"Bicycle",{"$f":"SUM(January:March!D12)","v":1439},null,"Table Fan"]
[null,"Motorcycle",{"$f":"SUM(January:March!D13)","v":1195},null,"Telephone"]
[null,"Private Car",{"$f":"SUM(January:March!D14)","v":1369},null,"Radio"]
[null,"Table Lamp",{"$f":"SUM(January:March!D15)","v":947},null,"Television"]
[null,"Guitar",{"$f":"SUM(January:March!D16)","v":1990},null,"Bicycle"]
[null,"Violin",{"$f":"SUM(January:March!D17)","v":1129},null,"Motorcycle"]
[null,"Dinner Set",{"$f":"SUM(January:March!D18)","v":1436},null,"Private Car"]
[null,"Wrist Watch",{"$f":"SUM(January:March!D19)","v":1512},null,"Table Lamp"]
[null,null,null,null,"Guitar"]
[null,null,null,null,"Violin"]
[null,null,null,null,"Dinner Set"]
[null,null,null,null,"Wrist Watch"]

{"sheet":"Consolidate","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,4,3,5]]}
[]
[null,"Using Consolidate Feature"]
[]
[null,"Products","Total Sales",null,"Practice Here!"]
[null,"Desktop",2117]
[null,"Laptop",1637,null,"Products","Total Sales"]
[null,"Smartphone",1436,null,"Desktop"]
[null,"Table Fan",1890,null,"Laptop"]
[null,"Telephone",961,null,"Smartphone"]
[null,"Radio",273,null,"Table Fan"]
[null,"Television",1407,null,"Telephone"]
[null,"Bicycle",1439,null,"Radio"]
[null,"Motorcycle",1195,null,"Television"]
[null,"Private Car",1369,null,"Bicycle"]
[null,"Table Lamp",947,null,"Motorcycle"]
[null,"Guitar",1990,null,"Private Car"]
[null,"Violin",1129,null,"Table Lamp"]
[null,"Dinner Set",1436,null,"Guitar"]
[null,"Wrist Watch",1512,null,"Violin"]
[null,null,null,null,"Dinner Set"]
[null,null,null,null,"Wrist Watch"]

{"sheet":"PowerQuery","index":6,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Content.Products","Content.Qty Produced","Content.Qty Sold","Name"]
["Desktop",746,700,"Table2"]
["Laptop",600,559,"Table2"]
["Smartphone",616,612,"Table2"]
["Table Fan",690,302,"Table2"]
["Telephone",783,487,"Table2"]
["Radio",423,51,"Table2"]
["Television",771,601,"Table2"]
["Bicycle",852,553,"Table2"]
["Motorcycle",554,57,"Table2"]
["Private Car",612,559,"Table2"]
["Table Lamp",478,373,"Table2"]
["Guitar",786,710,"Table2"]
["Violin",766,714,"Table2"]
["Dinner Set",552,433,"Table2"]
["Wrist Watch",609,512,"Table2"]
["Desktop",813,700,"Table3"]
["Laptop",600,589,"Table3"]
["Smartphone",450,412,"Table3"]
["Table Fan",980,881,"Table3"]
["Telephone",333,227,"Table3"]
["Radio",867,101,"Table3"]
["Television",533,401,"Table3"]
["Bicycle",782,553,"Table3"]
["Motorcycle",992,577,"Table3"]
["Private Car",408,359,"Table3"]
["Table Lamp",564,373,"Table3"]
["Guitar",957,881,"Table3"]
["Violin",538,314,"Table3"]
["Dinner Set",696,513,"Table3"]
["Wrist Watch",627,400,"Table3"]
["Desktop",983,717,"Table4"]
["Laptop",535,489,"Table4"]
["Smartphone",704,412,"Table4"]
["Table Fan",941,707,"Table4"]
["Telephone",378,247,"Table4"]
["Radio",906,121,"Table4"]
["Television",622,405,"Table4"]
["Bicycle",461,333,"Table4"]
["Motorcycle",877,561,"Table4"]
["Private Car",810,451,"Table4"]
["Table Lamp",469,201,"Table4"]
["Guitar",563,399,"Table4"]
["Violin",712,101,"Table4"]
["Dinner Set",656,490,"Table4"]
["Wrist Watch",997,600,"Table4"]
[null,null,null,"Query1!ExternalData_1"]

{"sheet":"Jan","index":7,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Record of January"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",547,511]
[null,"Week 2",1142,1001]
[null,"Week 3",882,203]
[null,"Week 4",1160,1154]

{"sheet":"Feb","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Record of February"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",644,643]
[null,"Week 2",1375,1300]
[null,"Week 3",1412,1310]
[null,"Week 4",965,777]

{"sheet":"Mar","index":9,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Record of March"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",644,643]
[null,"Week 2",1375,1300]
[null,"Week 3",1412,1310]
[null,"Week 4",965,777]

{"sheet":"VBA","index":10,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[8,1,8,3],[16,1,16,3]]}
[]
[null,"Sales Record of January"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",547,511]
[null,"Week 2",1142,1001]
[null,"Week 3",882,203]
[null,"Week 4",1160,1154]
[null,"Sales Record of February"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",644,643]
[null,"Week 2",1375,1300]
[null,"Week 3",1412,1310]
[null,"Week 4",965,777]
[]
[null,"Sales Record of March"]
[]
[null,"Week","Items Produced","Qty Sold"]
[null,"Week 1",644,643]
[null,"Week 2",1375,1300]
[null,"Week 3",1412,1310]
[null,"Week 4",965,777]