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