{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["report 1","report 2","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"report 1","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Column Labels"]
[null,"Gadget",null,"Widget",null,"Total Sum of Sale Value","Total Sum of Cost"]
["Row Labels","Sum of Sale Value","Sum of Cost","Sum of Sale Value","Sum of Cost"]
["NSW",13739.1,7958,4426.95,2683,18166.05,10641]
["QLD",4988.5,2980,8645.5,5191,13634,8171]
["SA",15643.3,8094,3814.8,2102,19458.099999999999,10196]
["VIC",15405,8457,6138,3069,21543,11526]
["WA",null,null,1674,837,1674,837]
["Grand Total",49775.899999999994,27489,24699.25,13882,74475.149999999994,41371]

{"sheet":"report 2","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Column Labels"]
[null,"Gadget",null,"Widget",null,"Total Sum of Sale Value","Total Sum of Cost"]
["Row Labels","Sum of Sale Value","Sum of Cost","Sum of Sale Value","Sum of Cost"]
["NSW",13739.1,7958,4426.95,2683,18166.05,10641]
["QLD",4988.5,2980,8645.5,5191,13634,8171]
["SA",15643.3,8094,3814.8,2102,19458.099999999999,10196]
["VIC",15405,8457,6138,3069,21543,11526]
["WA",null,null,1674,837,1674,837]
["Grand Total",49775.899999999994,27489,24699.25,13882,74475.149999999994,41371]

{"sheet":"Data","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Date","Invoice","Customer","Customer Category","Sales Rep","State","Product","Colour","Size","Volume","$/unit","Sale Value","Cost","Margin"]
["2012-01-01",12689,"Northern Products Ltd","Wholesale","Kylie Ford","QLD","Widget","White","Medium",12,40.799999999999997,489.6,288,201.6]
["2012-01-01",12690,"XYZ Ltd","Retail","Linda Garland","VIC","Gadget","Black","Medium",16,37.5,600,400,200]
["2012-01-01",12691,"Peabodies","Retail","Shirley Clark","QLD","Widget","Black","Large",19,77.5,1472.5,589,883.5]
["2012-01-01",12692,"XYZ Ltd","Retail","Linda Garland","NSW","Gadget","Blue","Large",20,61.05,1221,740,481]
["2012-01-01",12693,"Consolidated Distributors Ltd","Wholesale","Barry Ellis","SA","Widget","Red","Large",33,60,1980,990,990]
["2012-01-01",12695,"Peabodies","Retail","Shirley Clark","NSW","Widget","Black","Large",45,51.15,2301.75,1395,906.75]
["2012-01-01",12696,"Consolidated Distributors Ltd","Wholesale","Barry Ellis","NSW","Gadget","Blue","Large",45,74,3330,1665,1665]
["2012-01-01",12697,"Zorro Pty Ltd","Wholesale","John Davidson","VIC","Gadget","Black","Medium",47,37.5,1762.5,1175,587.5]
["2012-01-01",12698,"Simpson Brothers","Retail","Linda Garland","NSW","Widget","Blue","Medium",56,37.950000000000003,2125.1999999999998,1288,837.2]
["2012-01-01",12699,"Southern Sales","Wholesale","Barry Ellis","NSW","Gadget","White","Small",57,15.3,872.1,513,359.1]
["2012-01-01",12700,"Department of Energy","Government","Barry Ellis","QLD","Widget","White","Medium",59,39.6,2336.4,1416,920.4]
["2012-01-01",12701,"Northern Products Ltd","Wholesale","Kylie Ford","QLD","Gadget","Black","Medium",62,41.25,2557.5,1550,1007.5]
["2012-01-01",12702,"XYZ Ltd","Retail","Linda Garland","VIC","Gadget","Blue","Large",65,62.9,4088.5,2405,1683.5]
["2012-01-01",12703,"Consolidated Distributors Ltd","Wholesale","Barry Ellis","WA","Widget","Black","Small",93,18,1674,837,837]
["2012-01-01",12704,"Southern Sales","Wholesale","Barry Ellis","VIC","Widget","Black","Large",99,62,6138,3069,3069]
["2012-01-01",12705,"Department of Research","Government","Barry Ellis","NSW","Gadget","Red","Small",100,9.9,990,600,390]
["2012-01-01",12706,"XYZ Ltd","Retail","Linda Garland","NSW","Gadget","Blue","Large",120,61.05,7326,4440,2886]
["2012-01-01",12707,"Western Allied Corp","Retail","Linda Garland","VIC","Gadget","Blue","Large",121,74,8954,4477,4477]
["2012-01-01",12708,"Zorro Pty Ltd","Wholesale","John Davidson","QLD","Widget","Blue","Medium",126,34.5,4347,2898,1449]
["2012-01-01",12709,"Peabodies","Retail","Shirley Clark","SA","Gadget","Red","Medium",136,25,3400,1360,2040]
["2012-01-01",12710,"ABC Ltd","Retail","Kylie Ford","SA","Widget","Red","Small",139,13.2,1834.8,1112,722.8]
["2012-01-01",12711,"Department of Research","Government","Barry Ellis","QLD","Gadget","Red","Medium",143,17,2431,1430,1001]
["2012-01-01",12712,"Western Allied Corp","Retail","Linda Garland","SA","Gadget","Blue","Large",146,61.05,8913.2999999999993,5402,3511.3]
["2012-01-01",12713,"Department of Research","Government","Barry Ellis","SA","Gadget","White","Small",148,22.5,3330,1332,1998]