{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Consolidate Option","Use of Pivot Table ","Use of VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Consolidate Option","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Consolidate Option",null,null,"Consolidated Data"]
[]
[null,"Sales Rep","Sales",null,"Sales Rep","Sales"]
[null,"Michael",100,null,"Michael",320]
[null,"Jordan ",200,null,"Jordan ",360]
[null,"Isaac",150,null,"Isaac",230]
[null,"Jordan ",160,null,"Bill",500]
[null,"Michael",220,null,"Edward",600]
[null,"Isaac",80]
[null,"Bill",180]
[null,"Edward",500]
[null,"Bill",320]
[null,"Edward",100]

{"sheet":"Use of Pivot Table ","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Pivot Table Tool"]
[]
[null,"Sales Rep","Sales",null,"Row Labels","Sum of Sales"]
[null,"Michael",100,null,"Bill",500]
[null,"Jordan ",200,null,"Edward",600]
[null,"Isaac",150,null,"Isaac",230]
[null,"Jordan ",160,null,"Jordan ",360]
[null,"Michael",220,null,"Michael",320]
[null,"Isaac",80,null,"Grand Total",2010]
[null,"Bill",180]
[null,"Edward",500]
[null,"Bill",320]
[null,"Edward",100]

{"sheet":"Use of VBA Code","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Sales Rep","Sales"]
[null,"Michael",320]
[null,"Jordan ",360]
[null,"Isaac",230]
[null,"Bill",500]
[null,"Edward",600]