{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Data","index":0,"n_rows":129,"n_cols":17,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
[null,"Table4",null,null,null,"Table5",null,"Table6","Test"]
[null,"Bin1","Bin2",null,null,"Locs",null,"NName"]
[null,"SSum","SSum",null,null,{"$f":"COUNTIFS(Table2[SSum],B4,Table2[SSum],C4)","v":12},null,{"$f":"INDEX(Table1[Column1],RANDBETWEEN(1,3))","v":"Jackson"}]
[null,">=27","<=33"]
[]
[null,"Table2",null,null,null,null,null,"PivotTable1",null,null,null,null,null,"Table3"]
[null,"NName","Place","DDate","Qty","SSum",null,"Sum of Qty",null,"DDate",null,null,null,"NName","Place","DDate","Qty"]
[null,"Anderson","SUI","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52},null,"NName","Place","2009-12-22","2009-12-23","2009-12-24",null,"Jackson","ESP","2009-12-23",6]
[null,"Jackson","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46},null,"Anderson","ESP",24,12,10,null,"Jackson","ESP","2009-12-23",4]
[null,"Thomas","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52},null,null,"RSA",16,18,24,null,"Jackson","ESP","2009-12-23",2]
[null,"Jackson","RSA","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46},null,null,"SUI",36,52,26,null,"Jackson","ESP","2009-12-23",6]
[null,"Anderson","ESP","2009-12-24",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10},null,"Jackson","ESP",22,32,20,null,"Jackson","ESP","2009-12-23",4]
[null,"Thomas","ESP","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32},null,null,"RSA",38,46,10,null,"Jackson","ESP","2009-12-23",2]
[null,"Thomas","SUI","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44},null,null,"SUI",24,10,6,null,"Jackson","ESP","2009-12-23",8]
[null,"Thomas","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24},null,"Thomas","ESP",32,24,42,null,"Thomas","ESP","2009-12-22",2]
[null,"Jackson","SUI","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24},null,null,"RSA",14,24,6,null,"Thomas","ESP","2009-12-22",10]
[null,"Thomas","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44},null,null,"SUI",52,44,16,null,"Thomas","ESP","2009-12-22",2]
[null,"Thomas","SUI","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52},null,null,null,null,null,null,null,"Thomas","ESP","2009-12-22",10]
[null,"Anderson","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":18},null,null,null,null,null,null,null,"Thomas","ESP","2009-12-22",8]
[null,"Jackson","ESP","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":20}]
[null,"Thomas","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44}]
[null,"Anderson","RSA","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Jackson","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","SUI","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Anderson","ESP","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":12}]
[null,"Jackson","ESP","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","RSA","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":6}]
[null,"Jackson","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Anderson","SUI","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","RSA","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Anderson","SUI","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","SUI","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","ESP","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","RSA","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Anderson","ESP","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Jackson","SUI","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10}]
[null,"Anderson","SUI","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":26}]
[null,"Jackson","ESP","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Anderson","RSA","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":18}]
[null,"Anderson","ESP","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":12}]
[null,"Anderson","RSA","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Jackson","SUI","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Anderson","SUI","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Anderson","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Jackson","ESP","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":22}]
[null,"Anderson","SUI","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","ESP","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","SUI","2009-12-24",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Anderson","SUI","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","ESP","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":22}]
[null,"Thomas","RSA","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Anderson","SUI","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":26}]
[null,"Anderson","RSA","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":18}]
[null,"Thomas","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","RSA","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":14}]
[null,"Thomas","ESP","2009-12-24",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Anderson","SUI","2009-12-24",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":26}]
[null,"Jackson","RSA","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Thomas","ESP","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","SUI","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44}]
[null,"Jackson","RSA","2009-12-24",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10}]
[null,"Jackson","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","RSA","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Anderson","SUI","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Thomas","SUI","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Thomas","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","SUI","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Anderson","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Thomas","SUI","2009-12-24",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Jackson","ESP","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":20}]
[null,"Thomas","SUI","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44}]
[null,"Anderson","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","SUI","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Anderson","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":18}]
[null,"Jackson","RSA","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Jackson","RSA","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Thomas","ESP","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Anderson","ESP","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10}]
[null,"Anderson","SUI","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Anderson","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Jackson","RSA","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Jackson","ESP","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","RSA","2009-12-24",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":6}]
[null,"Jackson","RSA","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Jackson","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10}]
[null,"Jackson","ESP","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Thomas","RSA","2009-12-22",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":14}]
[null,"Thomas","ESP","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Jackson","RSA","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Thomas","SUI","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44}]
[null,"Anderson","SUI","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":26}]
[null,"Anderson","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","ESP","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":22}]
[null,"Anderson","RSA","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Anderson","SUI","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","ESP","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Jackson","RSA","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Jackson","RSA","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Anderson","RSA","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","SUI","2009-12-23",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":44}]
[null,"Anderson","ESP","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","ESP","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Thomas","SUI","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","RSA","2009-12-23",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Jackson","SUI","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":10}]
[null,"Anderson","RSA","2009-12-24",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","ESP","2009-12-23",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[null,"Thomas","SUI","2009-12-22",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Jackson","ESP","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":22}]
[null,"Thomas","SUI","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":52}]
[null,"Thomas","ESP","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Jackson","RSA","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":38}]
[null,"Anderson","RSA","2009-12-22",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":16}]
[null,"Jackson","ESP","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":20}]
[null,"Thomas","ESP","2009-12-24",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Thomas","ESP","2009-12-24",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Thomas","ESP","2009-12-24",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":42}]
[null,"Jackson","SUI","2009-12-24",6,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":6}]
[null,"Thomas","ESP","2009-12-22",8,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":32}]
[null,"Jackson","RSA","2009-12-23",10,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":46}]
[null,"Anderson","SUI","2009-12-22",4,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":36}]
[null,"Thomas","RSA","2009-12-23",2,{"$f":"SUMIFS([Qty],[NName],[NName],[Place],[Place],[DDate],[DDate])","v":24}]
[]
[]
[null,{"$f":"INDEX(Table1[Column1],RANDBETWEEN(1,3))","v":"Thomas"},{"$f":"INDEX(Table1[Column2],RANDBETWEEN(1,3))","v":"SUI"},{"$f":"INDEX(Table1[Column3],RANDBETWEEN(1,3))","v":"2009-12-24"},{"$f":"RANDBETWEEN(1,9)","v":4},{"$f":"SUMIFS(Table2[Qty],Table2[NName],Table2[NName],Table2[Place],Table2[Place],Table2[DDate],Table2[DDate])","v":0}]

{"sheet":"Test","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Column1","Column2","Column3"]
[null,"Anderson","SUI","2009-12-22"]
[null,"Thomas","ESP","2009-12-23"]
[null,"Jackson","RSA","2009-12-24"]