{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Regional sales"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Regional sales","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["  REGIONAL SALES",{"$nulls":15}," "]
[{"$nulls":13},"\nNOTES:\nNorth America continues strong run in Aug. Need to take closer look at Asia."]
["REGION","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","TOTAL","%","Label"]
["North America",{"v":23000,"d":"$23,000"},{"v":25000,"d":"$25,000"},{"v":19000,"d":"$19,000"},{"v":13000,"d":"$13,000"},{"v":18000,"d":"$18,000"},{"v":22000,"d":"$22,000"},{"v":26000,"d":"$26,000"},{"$nulls":5},{"$f":"SUM('Regional sales'!$B4:$M4)","v":{"v":146000,"d":"$146,000.00"}},{"$f":"'Regional sales'!$N4/SUM(Region[TOTAL])","v":{"v":0.42196531791907516,"d":"$0"}},{"$f":"'Regional sales'!$A4 & \" (\" & TEXT('Regional sales'!$O4,\"0%\") & \")\"","v":"North America (42%)"}]
["Asia",{"v":14000,"d":"$14,000"},{"v":18000,"d":"$18,000"},{"v":14000,"d":"$14,000"},{"v":12000,"d":"$12,000"},{"v":14000,"d":"$14,000"},{"v":18000,"d":"$18,000"},{"v":12000,"d":"$12,000"},{"$nulls":5},{"$f":"SUM('Regional sales'!$B5:$M5)","v":{"v":102000,"d":"$102,000.00"}},{"$f":"'Regional sales'!$N5/SUM(Region[TOTAL])","v":{"v":0.2947976878612717,"d":"$0"}},{"$f":"'Regional sales'!$A5 & \" (\" & TEXT('Regional sales'!$O5,\"0%\") & \")\"","v":"Asia (29%)"}]
["Europe",{"v":20000,"d":"$20,000"},{"v":12000,"d":"$12,000"},{"v":13000,"d":"$13,000"},{"v":10000,"d":"$10,000"},{"v":11000,"d":"$11,000"},{"v":15000,"d":"$15,000"},{"v":17000,"d":"$17,000"},{"$nulls":5},{"$f":"SUM('Regional sales'!$B6:$M6)","v":{"v":98000,"d":"$98,000.00"}},{"$f":"'Regional sales'!$N6/SUM(Region[TOTAL])","v":{"v":0.2832369942196532,"d":"$0"}},{"$f":"'Regional sales'!$A6 & \" (\" & TEXT('Regional sales'!$O6,\"0%\") & \")\"","v":"Europe (28%)"}]
[{"$nulls":13},{"$f":"SUM('Regional sales'!$B7:$M7)","v":{"v":0,"d":"$0.00"}},{"$f":"'Regional sales'!$N7/SUM(Region[TOTAL])","v":{"v":0,"d":"$0"}},{"$f":"'Regional sales'!$A7 & \" (\" & TEXT('Regional sales'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regional sales'!$B8:$M8)","v":{"v":0,"d":"$0.00"}},{"$f":"'Regional sales'!$N8/SUM(Region[TOTAL])","v":{"v":0,"d":"$0"}},{"$f":"'Regional sales'!$A8 & \" (\" & TEXT('Regional sales'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regional sales'!$B9:$M9)","v":{"v":0,"d":"$0.00"}},{"$f":"'Regional sales'!$N9/SUM(Region[TOTAL])","v":{"v":0,"d":"$0"}},{"$f":"'Regional sales'!$A9 & \" (\" & TEXT('Regional sales'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regional sales'!$B10:$M10)","v":{"v":0,"d":"$0.00"}},{"$f":"'Regional sales'!$N10/SUM(Region[TOTAL])","v":{"v":0,"d":"$0"}},{"$f":"'Regional sales'!$A10 & \" (\" & TEXT('Regional sales'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Regional sales'!$B11:$M11)","v":{"v":0,"d":"$0.00"}},{"$f":"'Regional sales'!$N11/SUM(Region[TOTAL])","v":{"v":0,"d":"$0"}},{"$f":"'Regional sales'!$A11 & \" (\" & TEXT('Regional sales'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["TOTAL",{"$f":"SUBTOTAL(109,Region[JAN])","v":{"v":57000,"d":"$57,000"}},{"$f":"SUBTOTAL(109,Region[FEB])","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,Region[MAR])","v":{"v":46000,"d":"$46,000"}},{"$f":"SUBTOTAL(109,Region[APR])","v":{"v":35000,"d":"$35,000"}},{"$f":"SUBTOTAL(109,Region[MAY])","v":{"v":43000,"d":"$43,000"}},{"$f":"SUBTOTAL(109,Region[JUN])","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,Region[JUL])","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,Region[AUG])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Region[SEP])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Region[OCT])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Region[NOV])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Region[DEC])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Region[TOTAL])","v":{"v":346000,"d":"$346,000.00"}},{"$f":"SUBTOTAL(109,Region[%])","v":{"v":1,"d":"$1"}}]