{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["InvoiceDetails_Dataset","PivotTable List","Filtering_PivotTable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":5},"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":"InvoiceDetails_Dataset","index":0,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Region","Unit Price","Quantity","Sales","Payment Method"]
["Northeast",84.69,7,{"$f":"B2*C2","v":592.82999999999993},"Ewallet"]
["Southwest",25.28,5,{"$f":"B3*C3","v":126.4},"Cash"]
["West",56.33,7,394.31,"Credit card"]
["Southeast",68.22,8,545.76,"Ewallet"]
["Midwest",96.31,7,674.17000000000007,"Ewallet"]
["Northeast",95.39,7,667.73,"Ewallet"]
["Southwest",78.84,6,473.04,"Ewallet"]
["West",83.56,10,835.6,"Ewallet"]
["Southeast",46.26,2,92.52,"Credit card"]
["Midwest",64.84,3,194.52,"Credit card"]
["Northeast",24.48,4,97.92,"Ewallet"]
["Southwest",35.510000000000005,4,142.04000000000002,"Cash"]
["West",56.95,5,284.75,"Ewallet"]
["Southeast",53.19,10,531.9,"Ewallet"]
["Midwest",81.38,10,813.8,"Cash"]
["Northeast",103.72,6,622.31999999999994,"Cash"]
["Southwest",78.930000000000007,7,552.51,"Credit card"]
["West",82.61,6,495.65999999999997,"Credit card"]
["Southeast",64.67,3,194.01,"Credit card"]
["Midwest",50.3,2,100.6,"Ewallet"]
["Northeast",96.04,5,480.20000000000005,"Ewallet"]
["Northeast",97.98,3,293.94,"Ewallet"]
["Southwest",43.2,2,86.4,"Credit card"]
["West",44.56,5,222.8,"Ewallet"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"PivotTable List","index":1,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["PivotTable List"]
["PivotTable1"]
["PivotTable2"]
["PivotTable3"]
["PivotTable4"]
["PivotTable5"]

{"sheet":"Filtering_PivotTable","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,3,3,4],[3,6,3,7],[3,9,3,10],[3,12,3,13]]}
[]
["PivotTable4","<< Select PivotTable from drop-down menu"]
[]
["PivotTable1",null,null,"PivotTable2",null,null,"PivotTable3",null,null,"PivotTable4",null,null,"PivotTable5"]
["Payment Method","Credit card",null,"Payment Method","Cash",null,"Payment Method","(All)",null,"Payment Method","(All)",null,"Payment Method","(All)"]
[]
["Region","Sum of Sales",null,"Region","Sum of Sales",null,"Region","Sum of Sales",null,"Region","Sum of Sales",null,"Region","Sum of Sales"]
["Midwest",194.52,null,"Midwest",813.8,null,"Midwest",1783.09,null,"Midwest",1783.09,null,"Midwest",1783.09]
["Southeast",286.52999999999997,null,"Northeast",622.31999999999994,null,"Northeast",2754.94,null,"Northeast",2754.94,null,"Northeast",2754.94]
["Southwest",638.91,null,"Southwest",268.44000000000005,null,"Southeast",1364.1899999999998,null,"Southeast",1364.1899999999998,null,"Southeast",1364.1899999999998]
["West",889.97,null,"Grand Total",1704.56,null,"Southwest",1380.39,null,"Southwest",1380.39,null,"Southwest",1380.39]
["Grand Total",2009.93,null,null,null,null,"West",2233.1200000000003,null,"West",2233.1200000000003,null,"West",2233.1200000000003]
[null,null,null,null,null,null,"(blank)",null,null,"(blank)",null,null,"(blank)"]
[null,null,null,null,null,null,"Grand Total",9515.73,null,"Grand Total",9515.73,null,"Grand Total",9515.73]