{"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":"¥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%"}}]