{"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":30,"n_cols":18,"rows_kept":30,"merged":[[3,14,15,15]]}
[]
["  REGIONAL SALES",{"$nulls":16}," "]
[]
[{"$nulls":14},"\nNOTES:\nNorth America continues its\nstrong run in August, but we need to take\na close look at Asia."]
{"$rows_empty":16}
[null,"REGION","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","TOTAL","%","Label"]
[null,"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'!$C22:$N22)","v":{"v":146000,"d":"$146,000"}},{"$f":"'Regional Sales'!$O22/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0.42196531791907516,"d":"42%"}},{"$f":"'Regional Sales'!$B22 & \" (\" & TEXT('Regional Sales'!$P22,\"0%\") & \")\"","v":"North America (42%)"}]
[null,"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'!$C23:$N23)","v":{"v":102000,"d":"$102,000"}},{"$f":"'Regional Sales'!$O23/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0.2947976878612717,"d":"29%"}},{"$f":"'Regional Sales'!$B23 & \" (\" & TEXT('Regional Sales'!$P23,\"0%\") & \")\"","v":"Asia (29%)"}]
[null,"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'!$C24:$N24)","v":{"v":98000,"d":"$98,000"}},{"$f":"'Regional Sales'!$O24/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0.2832369942196532,"d":"28%"}},{"$f":"'Regional Sales'!$B24 & \" (\" & TEXT('Regional Sales'!$P24,\"0%\") & \")\"","v":"Europe (28%)"}]
[{"$nulls":14},{"$f":"SUM('Regional Sales'!$C25:$N25)","v":{"v":0,"d":"$0"}},{"$f":"'Regional Sales'!$O25/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0,"d":"0%"}},{"$f":"'Regional Sales'!$B25 & \" (\" & TEXT('Regional Sales'!$P25,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":14},{"$f":"SUM('Regional Sales'!$C26:$N26)","v":{"v":0,"d":"$0"}},{"$f":"'Regional Sales'!$O26/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0,"d":"0%"}},{"$f":"'Regional Sales'!$B26 & \" (\" & TEXT('Regional Sales'!$P26,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":14},{"$f":"SUM('Regional Sales'!$C27:$N27)","v":{"v":0,"d":"$0"}},{"$f":"'Regional Sales'!$O27/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0,"d":"0%"}},{"$f":"'Regional Sales'!$B27 & \" (\" & TEXT('Regional Sales'!$P27,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":14},{"$f":"SUM('Regional Sales'!$C28:$N28)","v":{"v":0,"d":"$0"}},{"$f":"'Regional Sales'!$O28/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0,"d":"0%"}},{"$f":"'Regional Sales'!$B28 & \" (\" & TEXT('Regional Sales'!$P28,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":14},{"$f":"SUM('Regional Sales'!$C29:$N29)","v":{"v":0,"d":"$0"}},{"$f":"'Regional Sales'!$O29/SUM('Regional Sales'!$O$22:$O$29)","v":{"v":0,"d":"0%"}},{"$f":"'Regional Sales'!$B29 & \" (\" & TEXT('Regional Sales'!$P29,\"0%\") & \")\"","v":" (0%)"}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,'Regional Sales'!$C$22:$C$29)","v":{"v":57000,"d":"$57,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$D$22:$D$29)","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$E$22:$E$29)","v":{"v":46000,"d":"$46,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$F$22:$F$29)","v":{"v":35000,"d":"$35,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$G$22:$G$29)","v":{"v":43000,"d":"$43,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$H$22:$H$29)","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$I$22:$I$29)","v":{"v":55000,"d":"$55,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$J$22:$J$29)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$K$22:$K$29)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$L$22:$L$29)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$M$22:$M$29)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$N$22:$N$29)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$O$22:$O$29)","v":{"v":346000,"d":"$346,000"}},{"$f":"SUBTOTAL(109,'Regional Sales'!$P$22:$P$29)","v":{"v":1,"d":"100%"}}]