{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["地區銷量"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"地區銷量","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["地區銷量",{"$nulls":15}," "]
["繪製最多 8 個地區從 1 月到 12 月銷量的 [地區銷量] 圖表。請在儲存格 N2 輸入備註，並在下方儲存格輸入每個月的銷量資料。",{"$nulls":12},"\n備註：\n北美會在 8 月維持強勢走勢，但我們需要仔細觀察亞洲的情況。"]
["地區","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","總計","%","標籤"]
["北美",{"v":23000,"d":"NT$23,000"},{"v":25000,"d":"NT$25,000"},{"v":19000,"d":"NT$19,000"},{"v":13000,"d":"NT$13,000"},{"v":18000,"d":"NT$18,000"},{"v":22000,"d":"NT$22,000"},{"v":26000,"d":"NT$26,000"},{"$nulls":5},{"$f":"SUM(地區銷量!$B4:$M4)","v":{"v":146000,"d":"NT$146,000.00"}},{"$f":"地區銷量!$N4/SUM(地區銷量!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"42%"}},{"$f":"地區銷量!$A4 & \" (\" & TEXT(地區銷量!$O4,\"0%\") & \")\"","v":"北美 (42%)"}]
["亞洲",{"v":14000,"d":"NT$14,000"},{"v":18000,"d":"NT$18,000"},{"v":14000,"d":"NT$14,000"},{"v":12000,"d":"NT$12,000"},{"v":14000,"d":"NT$14,000"},{"v":18000,"d":"NT$18,000"},{"v":12000,"d":"NT$12,000"},{"$nulls":5},{"$f":"SUM(地區銷量!$B5:$M5)","v":{"v":102000,"d":"NT$102,000.00"}},{"$f":"地區銷量!$N5/SUM(地區銷量!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"29%"}},{"$f":"地區銷量!$A5 & \" (\" & TEXT(地區銷量!$O5,\"0%\") & \")\"","v":"亞洲 (29%)"}]
["歐洲",{"v":20000,"d":"NT$20,000"},{"v":12000,"d":"NT$12,000"},{"v":13000,"d":"NT$13,000"},{"v":10000,"d":"NT$10,000"},{"v":11000,"d":"NT$11,000"},{"v":15000,"d":"NT$15,000"},{"v":17000,"d":"NT$17,000"},{"$nulls":5},{"$f":"SUM(地區銷量!$B6:$M6)","v":{"v":98000,"d":"NT$98,000.00"}},{"$f":"地區銷量!$N6/SUM(地區銷量!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"28%"}},{"$f":"地區銷量!$A6 & \" (\" & TEXT(地區銷量!$O6,\"0%\") & \")\"","v":"歐洲 (28%)"}]
[{"$nulls":13},{"$f":"SUM(地區銷量!$B7:$M7)","v":{"v":0,"d":"NT$0.00"}},{"$f":"地區銷量!$N7/SUM(地區銷量!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"地區銷量!$A7 & \" (\" & TEXT(地區銷量!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM(地區銷量!$B8:$M8)","v":{"v":0,"d":"NT$0.00"}},{"$f":"地區銷量!$N8/SUM(地區銷量!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"地區銷量!$A8 & \" (\" & TEXT(地區銷量!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM(地區銷量!$B9:$M9)","v":{"v":0,"d":"NT$0.00"}},{"$f":"地區銷量!$N9/SUM(地區銷量!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"地區銷量!$A9 & \" (\" & TEXT(地區銷量!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM(地區銷量!$B10:$M10)","v":{"v":0,"d":"NT$0.00"}},{"$f":"地區銷量!$N10/SUM(地區銷量!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"地區銷量!$A10 & \" (\" & TEXT(地區銷量!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM(地區銷量!$B11:$M11)","v":{"v":0,"d":"NT$0.00"}},{"$f":"地區銷量!$N11/SUM(地區銷量!$N$4:$N$11)","v":{"v":0,"d":"0%"}},{"$f":"地區銷量!$A11 & \" (\" & TEXT(地區銷量!$O11,\"0%\") & \")\"","v":" (0%)"}]
["總計",{"$f":"SUBTOTAL(109,地區[1 月])","v":{"v":57000,"d":"NT$57,000"}},{"$f":"SUBTOTAL(109,地區[2 月])","v":{"v":55000,"d":"NT$55,000"}},{"$f":"SUBTOTAL(109,地區[3 月])","v":{"v":46000,"d":"NT$46,000"}},{"$f":"SUBTOTAL(109,地區[4 月])","v":{"v":35000,"d":"NT$35,000"}},{"$f":"SUBTOTAL(109,地區[5 月])","v":{"v":43000,"d":"NT$43,000"}},{"$f":"SUBTOTAL(109,地區[6 月])","v":{"v":55000,"d":"NT$55,000"}},{"$f":"SUBTOTAL(109,地區[7 月])","v":{"v":55000,"d":"NT$55,000"}},{"$f":"SUBTOTAL(109,地區[8 月])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,地區[9 月])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,地區[10 月])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,地區[11 月])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,地區[12 月])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,地區[總計])","v":{"v":346000,"d":"NT$346,000.00"}},{"$f":"SUBTOTAL(109,地區[%])","v":{"v":1,"d":"100%"}}]