{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Piv","Summary"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Data","Jan","Feb","Mar","Apr"]
["North",57.430999999999997,189.13800000000001,67.831000000000003,{"$f":"B2-3","v":54.430999999999997}]
["South",18.597000000000001,61.082000000000001,290.89800000000002,{"$f":"B3-3","v":15.597000000000001}]
["East",54.284999999999997,122.06699999999999,60.942,51.284999999999997]
["West",33,55,22,30]
["North",63.174100000000003,123,74.614100000000008,60.174100000000003]
["South",20.456700000000001,67.190200000000004,188,17.456700000000001]
["East",59.713500000000003,134.27369999999999,67.036200000000008,56.713500000000003]
["West",36.300000000000004,60.500000000000007,24.200000000000003,33.300000000000004]
["North",54.559449999999998,100,64.439449999999994,51.559449999999998]
["South",17.667149999999999,58.027899999999995,200,14.667149999999999]
["East",51.570749999999997,115.96364999999999,57.8949,48.570749999999997]
["West",31.349999999999998,52.25,20.9,28.349999999999998]
["North",60.559449999999998,185.68109999999999,70.439449999999994,57.559449999999998]
["South",23.667149999999999,64.027899999999988,129,20.667149999999999]
["East",57.570749999999997,121.96364999999999,63.8949,54.570749999999997]
["West",37.349999999999994,58.25,26.9,34.349999999999994]

{"sheet":"Piv","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels"]
["East"]

{"sheet":"Summary","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Data","Jan","Feb","Mar","Apr"]
[null,"North",{"$f":"SUMIF(Data!$A$2:$A$17,$B15,Data!B$2:B$17)","v":235.72399999999999},{"$f":"SUMIF(Data!$A$2:$A$17,$B15,Data!C$2:C$17)","v":597.81910000000005},{"$f":"SUMIF(Data!$A$2:$A$17,$B15,Data!D$2:D$17)","v":277.32400000000001},{"$f":"SUMIF(Data!$A$2:$A$17,$B15,Data!E$2:E$17)","v":223.72399999999999}]
[null,"South",{"$f":"SUMIF(Data!$A$2:$A$17,$B16,Data!B$2:B$17)","v":80.388000000000005},{"$f":"SUMIF(Data!$A$2:$A$17,$B16,Data!C$2:C$17)","v":250.32799999999997},{"$f":"SUMIF(Data!$A$2:$A$17,$B16,Data!D$2:D$17)","v":807.89800000000002},{"$f":"SUMIF(Data!$A$2:$A$17,$B16,Data!E$2:E$17)","v":68.388000000000005}]
[null,"East",{"$f":"SUMIF(Data!$A$2:$A$17,$B17,Data!B$2:B$17)","v":223.14000000000001},{"$f":"SUMIF(Data!$A$2:$A$17,$B17,Data!C$2:C$17)","v":494.26799999999992},{"$f":"SUMIF(Data!$A$2:$A$17,$B17,Data!D$2:D$17)","v":249.76800000000003},{"$f":"SUMIF(Data!$A$2:$A$17,$B17,Data!E$2:E$17)","v":211.14000000000001}]
[null,"West",{"$f":"SUMIF(Data!$A$2:$A$17,$B18,Data!B$2:B$17)","v":138},{"$f":"SUMIF(Data!$A$2:$A$17,$B18,Data!C$2:C$17)","v":226},{"$f":"SUMIF(Data!$A$2:$A$17,$B18,Data!D$2:D$17)","v":94},{"$f":"SUMIF(Data!$A$2:$A$17,$B18,Data!E$2:E$17)","v":126}]
[null,"All",{"$f":"SUM(C15:C18)","v":677.25199999999995},{"$f":"SUM(D15:D18)","v":1568.4150999999999},1428.99,629.25199999999995]
[]
[]
[]
[null,{"$f":"Piv!A4","v":"East"},{"$f":"SUMIF($B$15:$B$19,Piv!$A$4,C$15:C$19)","v":223.14000000000001},{"$f":"SUMIF($B$15:$B$19,Piv!$A$4,D$15:D$19)","v":494.26799999999992},{"$f":"SUMIF($B$15:$B$19,Piv!$A$4,E$15:E$19)","v":249.76800000000003},{"$f":"SUMIF($B$15:$B$19,Piv!$A$4,F$15:F$19)","v":211.14000000000001}]