{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet4","Data","Pivot"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Sheet4","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Calculated Field"]
["Solve Order","Field","Formula"]
[1,"Field2","=Total > 100"]
[]
["Calculated Item"]
["Solve Order","Item","Formula"]
[]
[]
["Note:","When a cell is updated by more than one formula,"]
[null,"the value is set by the formula with the last solve order."]
[]
[null,"To change the solve order for multiple calculated items or fields,"]
[null,"on the Options tab, in the Calculations group, click Fields, Items, & Sets, and then click Solve Order."]

{"sheet":"Data","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Date","Region","Employee","Item","Units","Unit Cost","Total"]
["2011-01-06","Quebec","Jones","Pencil",95,1.99,{"$f":"F2*E2","v":189.05}]
["2011-01-23","Ontario","Kivell","Binder",50,19.989999999999998,999.49999999999989]
["2011-02-09","Ontario","Howard","Pencil",36,4.99,179.64000000000001]
["2011-02-26","Ontario","Gill","Pen",27,19.989999999999998,539.7299999999999]
["2011-03-15","Alberta","Sorvino","Pencil",56,2.99,167.44]
["2011-04-01","Quebec","Jones","Binder",60,4.99,299.40000000000003]
["2011-04-18","Ontario","Andrews","Pencil",75,1.99,149.25]
["2011-05-05","Ontario","Howard","Pencil",90,4.99,449.1]
["2011-05-22","Alberta","Thompson","Pencil",32,1.99,63.68]
["2011-06-08","Quebec","Jones","Binder",60,8.99,539.4]
["2011-06-25","Ontario","Morgan","Pencil",90,4.99,449.1]
["2011-07-12","Quebec","Howard","Binder",29,1.99,57.71]
["2011-07-29","Quebec","Parent","Binder",81,19.989999999999998,1619.1899999999998]
["2011-08-15","Quebec","Jones","Pencil",35,4.99,174.65]
["2011-09-01","Ontario","Smith","Desk",2,125,250]
["2011-09-18","Quebec","Jones","Pen Set",16,15.99,255.84]
["2011-10-05","Ontario","Morgan","Binder",28,8.99,251.72]
["2011-10-22","Quebec","Jones","Pen",64,8.99,575.36]
["2011-11-08","Quebec","Parent","Pen",15,19.989999999999998,299.84999999999997]
["2011-11-25","Ontario","Kivell","Pen Set",96,4.99,479.04]
["2011-12-12","Ontario","Smith","Pencil",67,1.29,86.43]
["2011-12-29","Quebec","Parent","Pen Set",74,15.99,1183.26]
["2012-01-15","Ontario","Gill","Binder",46,8.99,413.54]
["2012-02-01","Ontario","Smith","Binder",87,15,1305]
["2012-02-18","Quebec","Jones","Binder",4,4.99,19.96]
["2012-03-07","Alberta","Sorvino","Binder",7,19.989999999999998,139.92999999999998]
["2012-03-24","Ontario","Howard","Pen Set",50,4.99,249.5]
["2012-04-10","Ontario","Gill","Pencil",66,1.99,131.34]
["2012-04-27","Quebec","Howard","Pen",96,4.99,479.04]
["2012-05-14","Ontario","Gill","Pencil",53,1.29,68.37]
["2012-05-31","Ontario","Gill","Binder",80,8.99,719.2]
["2012-06-17","Ontario","Kivell","Desk",5,125,625]
["2012-07-04","Quebec","Jones","Pen Set",62,4.99,309.38]
["2012-07-21","Ontario","Morgan","Pen Set",55,12.49,686.95]
["2012-08-07","Ontario","Kivell","Pen Set",42,23.95,1005.9]
["2012-08-24","Alberta","Sorvino","Desk",3,275,825]
["2012-09-10","Ontario","Gill","Pencil",7,1.29,9.0300000000000011]
["2012-09-27","Alberta","Sorvino","Pen",76,1.99,151.24]
["2012-10-14","Alberta","Thompson","Binder",57,19.989999999999998,1139.4299999999998]
["2012-10-31","Ontario","Gill","Pencil",14,1.29,18.060000000000002]
["2012-11-17","Ontario","Howard","Binder",11,4.99,54.89]
["2012-12-04","Ontario","Howard","Binder",94,19.989999999999998,1879.06]
["2012-12-21","Ontario","Gill","Binder",28,4.99,139.72]

{"sheet":"Pivot","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Item","Binder"]
[]
["Region","Employee","Sum of Total"]
["Ontario","Gill",1272.46]
["Ontario","Howard",1933.95]
["Ontario","Kivell",999.49999999999989]
["Ontario","Morgan",251.72]
["Ontario","Smith",1305]