{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Base","VLookup","Macro","Macro_Pivot"],"not_rendered":{"charts":1,"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":"Base","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["OrderDate","Region","Rep","Item","Units","Unit Price"]
["2014-07-04","East","Richard","Pen Set",62,4.99]
["2014-07-12","East","Nick","Binder",29,1.99]
["2014-07-21","Central","Morgan","Pen Set",55,12.49]
["2014-07-29","East","Susan","Binder",81,19.989999999999998]
["2014-08-07","Central","Matthew","Pen Set",42,23.95]
["2014-08-15","East","Richard","Pencil",35,4.99]
["2014-08-24","West","James","Desk",3,275]
["2014-09-01","Central","Smith","Desk",2,125]
["2014-09-10","Central","Bill","Pencil",7,1.29]
["2014-09-18","East","Richard","Pen Set",16,15.99]
["2014-09-27","West","James","Pen",76,1.99]
["2014-10-05","Central","Morgan","Binder",28,8.99]
["2014-10-14","West","Thomas","Binder",57,19.989999999999998]
["2014-10-22","East","Richard","Pen",64,8.99]
["2014-10-31","Central","Rachel","Pencil",14,1.29]
["2014-11-08","East","Susan","Pen",15,19.989999999999998]
["2014-11-17","Centrale","Alex","Binder",11,4.99]
["2014-11-25","Central","Matthew","Pen Set",96,4.99]
["2014-12-04","Central","Alex","Binder",94,19.989999999999998]
["2014-12-12","Central","Smith","Pencil",67,1.29]
["2014-12-21","Central","Rachel","Binder",28,4.99]
["2014-12-29","East","Susan","Pen Set",74,15.99]
["2015-01-06","East","Richard","Pencil",95,1.99]
["2015-01-15","Central","Bill","Binder",46,8.99]
["2015-01-23","Central","Matthew","Binder",50,19.989999999999998]
["2015-02-01","Central","Smith","Binder",87,15]
["2015-02-09","Central","Alex","Pencil",36,4.99]
["2015-02-18","East","Richard","Binder",4,4.99]
["2015-02-26","Central","Bill","Pen",27,19.989999999999998]
["2015-03-07","West","James","Binder",7,19.989999999999998]
["2015-03-15","West","James","Pencil",56,2.99]
["2015-03-24","Central","Alex","Pen Set",50,4.99]
["2015-04-01","East","Richard","Binder",60,4.99]
["2015-04-10","Central","Rachel","Pencil",66,1.99]
["2015-04-18","Central","Rachel","Pencil",75,1.99]
["2015-04-27","East","Nick","Pen",96,4.99]
["2015-05-05","Central","Alex","Pencil",90,4.99]
["2015-05-14","Central","Bill","Pencil",53,1.29]
["2015-05-22","West","Thomas","Pencil",32,1.99]
["2015-05-31","Central","Bill","Binder",80,8.99]
["2015-06-08","East","Richard","Binder",60,8.99]
["2015-06-17","Central","Matthew","Desk",5,125]
["2015-06-25","Central","Morgan","Pencil",90,4.99]
["2115-06-25","Central","Matthew","Binder",45,3.99]

{"sheet":"VLookup","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Tier","Hire Date"]
["Alex","Jones",1,"2013-01-10"]
["Bill","Smith",1,"2016-07-06"]
["James","Hammel",2,"2015-06-25"]
["Matthew","Post",3,"2014-08-21"]
["Morgan","Freeman",2,"2015-09-28"]
["Nick","Wilder",3,"2014-12-15"]
["Rachel","Taylor",5,"2015-03-06"]
["Richard","Johnson",5,"2015-03-28"]
["Smith","Smithy",4,"2014-07-16"]
["Susan","Sarandon",4,"2015-09-12"]
["Thomas","Jefferson",1,"2015-02-22"]

{"sheet":"Macro","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["OrderDate","Region","Rep","Item","Units","Unit Price","Total"]
["2014-11-17","Centrale","Alex","Binder",11,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":54.89}]
["2014-12-04","Central","Alex","Binder",94,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1879.06}]
["2015-02-09","Central","Alex","Pencil",36,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":179.64000000000001}]
["2015-03-24","Central","Alex","Pen Set",50,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":249.5}]
["2015-05-05","Central","Alex","Pencil",90,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":449.1}]
["2014-09-10","Central","Bill","Pencil",7,1.29,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":9.0300000000000011}]
["2015-01-15","Central","Bill","Binder",46,8.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":413.54}]
["2015-02-26","Central","Bill","Pen",27,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":539.7299999999999}]
["2015-05-14","Central","Bill","Pencil",53,1.29,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":68.37}]
["2015-05-31","Central","Bill","Binder",80,8.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":719.2}]
["2014-08-24","West","James","Desk",3,275,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":825}]
["2014-09-27","West","James","Pen",76,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":151.24}]
["2015-03-07","West","James","Binder",7,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":139.92999999999998}]
["2015-03-15","West","James","Pencil",56,2.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":167.44}]
["2014-08-07","Central","Matthew","Pen Set",42,23.95,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1005.9}]
["2014-11-25","Central","Matthew","Pen Set",96,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":479.04}]
["2015-01-23","Central","Matthew","Binder",50,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":999.49999999999989}]
["2015-06-17","Central","Matthew","Desk",5,125,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":625}]
["2015-06-25","Central","Matthew","Binder",45,3.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":179.55}]
["2014-07-21","Central","Morgan","Pen Set",55,12.49,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":686.95}]
["2014-10-05","Central","Morgan","Binder",28,8.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":251.72}]
["2015-06-25","Central","Morgan","Pencil",90,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":449.1}]
["2014-07-12","East","Nick","Binder",29,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":57.71}]
["2015-04-27","East","Nick","Pen",96,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":479.04}]
["2014-10-31","Central","Rachel","Pencil",14,1.29,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":18.060000000000002}]
["2014-12-21","Central","Rachel","Binder",28,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":139.72}]
["2015-04-10","Central","Rachel","Pencil",66,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":131.34}]
["2015-04-18","Central","Rachel","Pencil",75,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":149.25}]
["2014-07-04","East","Richard","Pen Set",62,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":309.38}]
["2014-08-15","East","Richard","Pencil",35,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":174.65}]
["2014-09-18","East","Richard","Pen Set",16,15.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":255.84}]
["2014-10-22","East","Richard","Pen",64,8.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":575.36}]
["2015-01-06","East","Richard","Pencil",95,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":189.05}]
["2015-02-18","East","Richard","Binder",4,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":19.96}]
["2015-04-01","East","Richard","Binder",60,4.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":299.40000000000003}]
["2015-06-08","East","Richard","Binder",60,8.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":539.4}]
["2014-09-01","Central","Smith","Desk",2,125,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":250}]
["2014-12-12","Central","Smith","Pencil",67,1.29,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":86.43}]
["2015-02-01","Central","Smith","Binder",87,15,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1305}]
["2014-07-29","East","Susan","Binder",81,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1619.1899999999998}]
["2014-11-08","East","Susan","Pen",15,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":299.84999999999997}]
["2014-12-29","East","Susan","Pen Set",74,15.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1183.26}]
["2014-10-14","West","Thomas","Binder",57,19.989999999999998,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":1139.4299999999998}]
["2015-05-22","West","Thomas","Pencil",32,1.99,{"$f":"Table2[[#This Row],[Units]]*Table2[[#This Row],[Unit Price]]","v":63.68}]

{"sheet":"Macro_Pivot","index":3,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Year To Date Sales Report For: ",null,null,{"$f":"B7","v":"Alex"}]
[]
[]
[null," "]
[null,null,"Binder","Pen Set","Pencil","Grand Total"]
[null,"Alex"]
[null,"2014"]
[null,"Qtr4",1933.95,null,null,1933.95]
[null,"2015"]
[null,"Qtr1",null,249.5,179.64000000000001,429.14]
[null,"Qtr2",null,null,449.1,449.1]
[null,"Grand Total",1933.95,249.5,628.74,2812.19]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-10-19"}]