{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Design Tool","Remove Grand Total Option","PivotTable Option","VBA Code","Remove Column Grand Total","Remove Row Grand Total"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":6},"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":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Categorized Sales Data",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Item","Category","Sales",null,null,null,null,null,null,null,"Item","Category","Sales"]
[null,"Stove","Kitchen",3595,null,null,null,null,null,null,null,"Stove","Kitchen",3595]
[null,"Oven","Kitchen",8125,null,null,null,null,null,null,null,"Oven","Kitchen",8125]
[null,"Refrigerator","Kitchen",7828,null,null,null,null,null,null,null,"Refrigerator","Kitchen",7828]
[null,"Heater","Drawing Room",5272,null,null,null,null,null,null,null,"Heater","Drawing Room",5272]
[null,"Home Theater","Drawing Room",3377,null,null,null,null,null,null,null,"Home Theater","Drawing Room",3377]
[null,"Laser Printer","Office",4838,null,null,null,null,null,null,null,"Laser Printer","Office",4838]
[null,"PC","Office",7483,null,null,null,null,null,null,null,"PC","Office",7483]
[null,"Playstation","Living Room",5900,null,null,null,null,null,null,null,"Playstation","Living Room",5900]
[null,"TV","Living Room",9219,null,null,null,null,null,null,null,"TV","Living Room",9219]
[null,"AC","Living Room",2514,null,null,null,null,null,null,null,"AC","Living Room",2514]

{"sheet":"Design Tool","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Design Tool"]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Drawing Room",8649]
[null,"Kitchen",19548]
[null,"Living Room",17633]
[null,"Office",12321]

{"sheet":"Remove Grand Total Option","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Remove Grand Total Option"]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Drawing Room",8649]
[null,"Kitchen",19548]
[null,"Living Room",17633]
[null,"Office",12321]

{"sheet":"PivotTable Option","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Pivot Table Option"]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Drawing Room",8649]
[null,"Kitchen",19548]
[null,"Living Room",17633]
[null,"Office",12321]

{"sheet":"VBA Code","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Row Labels","Sum of Sales"]
[null,"Drawing Room",8649]
[null,"Kitchen",19548]
[null,"Living Room",17633]
[null,"Office",12321]

{"sheet":"Remove Column Grand Total","index":5,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Remove Column Grand Total"]
[]
[null,"Sum of Sales","Column Labels"]
[null,"Row Labels","Drawing Room","Kitchen","Living Room","Office","Grand Total"]
[null,"AC",null,null,2514,null,2514]
[null,"Heater",5272,null,null,null,5272]
[null,"Home Theater",3377,null,null,null,3377]
[null,"Laser Printer",null,null,null,4838,4838]
[null,"Oven",null,8125,null,null,8125]
[null,"PC",null,null,null,7483,7483]
[null,"Playstation",null,null,5900,null,5900]
[null,"Refrigerator",null,7828,null,null,7828]
[null,"Stove",null,3595,null,null,3595]
[null,"TV",null,null,9219,null,9219]

{"sheet":"Remove Row Grand Total","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Remove Row Grand Total"]
[]
[null,"Sum of Sales","Column Labels"]
[null,"Row Labels","Drawing Room","Kitchen","Living Room","Office"]
[null,"AC",null,null,2514]
[null,"Heater",5272]
[null,"Home Theater",3377]
[null,"Laser Printer",null,null,null,4838]
[null,"Oven",null,8125]
[null,"PC",null,null,null,7483]
[null,"Playstation",null,null,5900]
[null,"Refrigerator",null,7828]
[null,"Stove",null,3595]
[null,"TV",null,null,9219]
[null,"Grand Total",8649,19548,17633,12321]