{"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 个地区全年 12 个月的销售额。在右侧单元格 N2 中输入备注，在下方的单元格中输入每月的销售数据。",{"$nulls":12},"\n备注：\n北美在八月依然保持着优势，\n但是我们需要仔细观察一下亚洲。"]
["地区","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","汇总","所占百分比","标签"]
["北美洲",{"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(区域销售额!$B4:$M4)","v":{"v":146000,"d":"¥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":"¥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(区域销售额!$B5:$M5)","v":{"v":102000,"d":"¥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":"¥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(区域销售额!$B6:$M6)","v":{"v":98000,"d":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥57,000"}},{"$f":"SUBTOTAL(109,地区[2 月])","v":{"v":55000,"d":"¥55,000"}},{"$f":"SUBTOTAL(109,地区[3 月])","v":{"v":46000,"d":"¥46,000"}},{"$f":"SUBTOTAL(109,地区[4 月])","v":{"v":35000,"d":"¥35,000"}},{"$f":"SUBTOTAL(109,地区[5 月])","v":{"v":43000,"d":"¥43,000"}},{"$f":"SUBTOTAL(109,地区[6 月])","v":{"v":55000,"d":"¥55,000"}},{"$f":"SUBTOTAL(109,地区[7 月])","v":{"v":55000,"d":"¥55,000"}},{"$f":"SUBTOTAL(109,地区[8 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,地区[9 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,地区[10 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,地区[11 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,地区[12 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,地区[汇总])","v":{"v":346000,"d":"¥346,000.00"}},{"$f":"SUBTOTAL(109,地区[所占百分比])","v":{"v":1,"d":"100%"}}]