{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sample Data","Sample Data 2","Sheet2","Sheet3","Sheet4","Sheet5","Create Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"Sample Data","index":0,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SAMPLE DATA"]
[]
[null,"OrderDate","Region","Rep","Item","Units","Cost","Total"]
[null,"2012-01-06","East","Jones","Pencil",95,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":189.05}]
[null,"2012-01-23","Central","Kivell","Binder",50,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":999.49999999999989}]
[null,"2012-02-09","Central","Jardine","Pencil",36,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":179.64000000000001}]
[null,"2012-02-29","Central","Gill","Pen",27,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":539.7299999999999}]
[null,"2012-03-15","West","Sorvino","Pencil",56,2.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":167.44}]
[null,"2012-04-01","East","Jones","Binder",60,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":299.40000000000003}]
[null,"2012-04-18","Central","Andrews","Pencil",75,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":149.25}]
[null,"2012-05-05","Central","Jardine","Pencil",90,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":449.1}]
[null,"2012-05-22","West","Thompson","Pencil",32,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":63.68}]
[null,"2012-06-08","East","Jones","Binder",60,8.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":539.4}]
[null,"2012-06-25","Central","Morgan","Pencil",90,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":449.1}]
[null,"2012-07-12","East","Howard","Binder",29,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":57.71}]
[null,"2012-07-29","East","Parent","Binder",81,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1619.1899999999998}]
[null,"2012-08-15","East","Jones","Pencil",35,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":174.65}]
[null,"2012-09-01","Central","Smith","Desk",2,125,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":250}]
[null,"2012-09-18","East","Jones","Pen Set",16,15.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":255.84}]
[null,"2012-10-05","Central","Morgan","Binder",28,8.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":251.72}]
[null,"2012-10-22","East","Jones","Pen",64,8.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":575.36}]
[null,"2012-11-08","East","Parent","Pen",15,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":299.84999999999997}]
[null,"2012-11-25","Central","Kivell","Pen Set",96,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":479.04}]
[null,"2012-12-12","Central","Smith","Pencil",67,1.29,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":86.43}]
[null,"2012-12-29","East","Parent","Pen Set",74,15.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1183.26}]
[null,"2013-01-15","Central","Gill","Binder",46,8.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":413.54}]
[null,"2013-02-01","Central","Smith","Binder",87,15,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1305}]
[null,"2013-02-28","East","Jones","Binder",4,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":19.96}]
[null,"2013-03-07","West","Sorvino","Binder",7,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":139.92999999999998}]
[null,"2013-03-24","Central","Jardine","Pen Set",50,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":249.5}]
[null,"2013-04-10","Central","Andrews","Pencil",66,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":131.34}]
[null,"2013-04-27","East","Howard","Pen",96,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":479.04}]
[null,"2013-05-14","Central","Gill","Pencil",53,1.29,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":68.37}]
[null,"2013-05-31","Central","Gill","Binder",80,8.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":719.2}]
[null,"2013-06-17","Central","Kivell","Desk",5,125,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":625}]
[null,"2013-07-04","East","Jones","Pen Set",62,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":309.38}]
[null,"2013-07-21","Central","Morgan","Pen Set",55,12.49,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":686.95}]
[null,"2013-08-07","Central","Kivell","Pen Set",42,23.95,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1005.9}]
[null,"2013-08-24","West","Sorvino","Desk",3,275,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":825}]
[null,"2013-09-10","Central","Gill","Pencil",7,1.29,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":9.0300000000000011}]
[null,"2013-09-27","West","Sorvino","Pen",76,1.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":151.24}]
[null,"2013-10-14","West","Thompson","Binder",57,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1139.4299999999998}]
[null,"2013-10-31","Central","Andrews","Pencil",14,1.29,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":18.060000000000002}]
[null,"2013-11-17","Central","Jardine","Binder",11,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":54.89}]
[null,"2013-12-04","Central","Jardine","Binder",94,19.989999999999998,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":1879.06}]
[null,"2013-12-21","Central","Andrews","Binder",28,4.99,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":139.72}]
[null,"2014-07-30","Central","Howard","Pen Set",100,100,{"$f":"Data[[#This Row],[Cost]]*Data[[#This Row],[Units]]","v":10000}]

{"sheet":"Sample Data 2","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SAMPLE DATA 2"]
[]
[]
[]
[null,"OrderDate","Region","Rep","Item","Units","Cost","Total"]
[null,"2014-07-30","Central","Howard","Pen Set",100,100,{"$f":"Sample2.2[[#This Row],[Units]]*Sample2.2[[#This Row],[Cost]]","v":10000}]
[null,"2013-11-17","Central","Jardine","Binder",11,4.99,{"$f":"Sample2.2[[#This Row],[Units]]*Sample2.2[[#This Row],[Cost]]","v":54.89}]
[null,"2013-12-04","Central","Jardine","Binder",94,19.989999999999998,{"$f":"Sample2.2[[#This Row],[Units]]*Sample2.2[[#This Row],[Cost]]","v":1879.06}]
[null,"2013-12-21","Central","Andrews","Binder",28,4.99,{"$f":"Sample2.2[[#This Row],[Units]]*Sample2.2[[#This Row],[Cost]]","v":139.72}]
[null,"2014-07-30","Central","Howard","Pen Set",100,100,{"$f":"Sample2.2[[#This Row],[Units]]*Sample2.2[[#This Row],[Cost]]","v":10000}]
[]
[]
[null,"OrderDate","Region","Rep","Item","Units","Cost","Total"]
[null,"2014-07-30","Central","Howard","Pen Set",100,100,{"$f":"Sample2.1[[#This Row],[Units]]*Sample2.1[[#This Row],[Cost]]","v":10000}]
[null,"2013-11-17","Central","Jardine","Binder",11,4.99,{"$f":"Sample2.1[[#This Row],[Units]]*Sample2.1[[#This Row],[Cost]]","v":54.89}]
[null,"2013-12-04","Central","Jardine","Binder",94,19.989999999999998,{"$f":"Sample2.1[[#This Row],[Units]]*Sample2.1[[#This Row],[Cost]]","v":1879.06}]
[null,"2013-12-21","Central","Andrews","Binder",28,4.99,{"$f":"Sample2.1[[#This Row],[Units]]*Sample2.1[[#This Row],[Cost]]","v":139.72}]
[null,"2014-07-30","Central","Howard","Pen Set",100,100,{"$f":"Sample2.1[[#This Row],[Units]]*Sample2.1[[#This Row],[Cost]]","v":10000}]

{"sheet":"Sheet2","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"a",1,{"$f":"SUM(C4,D3)","v":1},1]
[null,"b",2,{"$f":"SUM(C5,D4)","v":3},2]
[null,"c",3,{"$f":"SUM(C6,D5)","v":6},3]
[null,"d",4,{"$f":"SUM(C7,D6)","v":10},{"$f":"1","v":1}]
[null,"e",null,{"$f":"SUM(C8,D7)","v":10}]

{"sheet":"Sheet3","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"a","b","c"]
[null,"a",1,{"$f":"SUM(C4,D3)","v":1}]
[null,"b",2,{"$f":"SUM(C5,D4)","v":3}]
[null,"c",3,{"$f":"SUM(C6,D5)","v":6}]
[null,"d",4,{"$f":"SUM(C7,D6)","v":10}]
[null,"Total",null,{"$f":"SUBTOTAL(103,Test3[c])","v":4}]

{"sheet":"Sheet4","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"a","b","c"]
[null,"a",1,{"$f":"SUM(C4,D3)","v":1}]
[null,"b",2,{"$f":"SUM(C5,D4)","v":3}]
[null,"c",3,{"$f":"SUM(C6,D5)","v":6}]
[null,"d",4,{"$f":"SUM(C7,D6)","v":10}]
[null,"Total",null,{"$f":"SUBTOTAL(103,Test4[c])","v":4}]

{"sheet":"Sheet5","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"a","b","c"]
[null,"a",1,{"$f":"SUM(C4,D3)","v":1}]
[null,"b",2,{"$f":"SUM(C5,D4)","v":3}]
[null,"c",3,{"$f":"SUM(C6,D5)","v":6}]
[null,"d",4,{"$f":"SUM(C7,D6)","v":10}]
[null,"Total",null,{"$f":"SUBTOTAL(103,Test5[c])","v":4}]

{"sheet":"Create Table","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"a","b","c"]
[null,"a",1,{"$f":"SUM(C4,D3)","v":1}]
[null,"b",2,{"$f":"SUM(C5,D4)","v":3}]
[null,"c",3,{"$f":"SUM(C6,D5)","v":6}]
[null,"d",4,{"$f":"SUM(C7,D6)","v":10}]