{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["수익성 분석","요약 결과 차트"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"수익성 분석","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[2,3,2,7],[10,1,10,5],[14,1,14,5],[21,1,21,5],[27,1,27,5],[30,1,30,5]]}
[]
[null,"고객 수익성 분석"]
[null,"2013년 1월 20일",null,"회사 이름"]
[]
[]
[null,"고객 활동 내역","고객 1","고객 2","고객 3","합계",null," "]
[null,"활성 고객 수 - 시작 시점",5,8,8,{"$f":"SUM(C7:E7)","v":{"v":21,"d":"21 "}}]
[null,"추가 고객 수",2,4,4,{"$f":"SUM(C8:E8)","v":{"v":10,"d":"10 "}}]
[null,"이탈/계약 종료 고객 수",{"v":-1,"d":"(1)"},{"v":-2,"d":"(2)"},{"v":-2,"d":"(2)"},{"v":-5,"d":"(5)"}]
[null,"활성 고객 수 - 종료 시점",{"$f":"SUBTOTAL(109,'수익성 분석'!$C$7:$C$9)","v":6},{"$f":"SUBTOTAL(109,'수익성 분석'!$D$7:$D$9)","v":10},{"$f":"SUBTOTAL(109,'수익성 분석'!$E$7:$E$9)","v":10},26]
[]
[null,"수익성 분석"," ","  ","   ","    "]
[null,"세그먼트당 수익",{"v":1500000000,"d":"₩1,500,000,000"},{"v":1800000000,"d":"₩1,800,000,000"},{"v":2500000000,"d":"₩2,500,000,000"},{"$f":"SUM('수익성 분석'!$C13:$E13)","v":{"v":5800000000,"d":"₩5,800,000,000"}}]
[null,"가중치",{"$f":"C13/$F$13","v":{"v":0.25862068965517243,"d":"25.9%"}},{"$f":"D13/$F$13","v":{"v":0.3103448275862069,"d":"31.0%"}},{"v":0.43103448275862066,"d":"43.1%"},{"$f":"SUM(C14:E14)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"매출 원가"," ","  ","   ","    "]
[null,"제공 중인 서비스 및 지원 비용",{"v":1000000000,"d":"₩1,000,000,000"},{"v":1400000000,"d":"₩1,400,000,000"},{"v":1400000000,"d":"₩1,400,000,000"},{"$f":"SUM('수익성 분석'!$C17:$E17)","v":{"v":3800000000,"d":"₩3,800,000,000"}}]
[null,"기타 고객 관련 직접비",{"v":200000000,"d":"200,000,000 "},{"v":100000000,"d":"100,000,000 "},{"v":100000000,"d":"100,000,000 "},{"$f":"SUM('수익성 분석'!$C18:$E18)","v":{"v":400000000,"d":"400,000,000 "}}]
[null,"총 매출 원가",{"$f":"SUBTOTAL(109,'수익성 분석'!$C$17:$C$18)","v":{"v":1200000000,"d":"1,200,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$D$17:$D$18)","v":{"v":1500000000,"d":"1,500,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$E$17:$E$18)","v":{"v":1500000000,"d":"1,500,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$F$17:$F$18)","v":{"v":4200000000,"d":"4,200,000,000 "}}]
[null,"총수익",{"$f":"C13-'수익성 분석'!$C$19","v":{"v":300000000,"d":"₩300,000,000"}},{"$f":"D13-'수익성 분석'!$D$19","v":{"v":300000000,"d":"₩300,000,000"}},{"$f":"E13-'수익성 분석'!$E$19","v":{"v":1000000000,"d":"₩1,000,000,000"}},{"$f":"F13-'수익성 분석'!$F$19","v":{"v":1600000000,"d":"₩1,600,000,000"}}]
[null,"가중치",{"$f":"MAX(0,MIN(1,C20/$F$20))","v":{"v":0.1875,"d":"18.8%"}},{"$f":"MAX(0,MIN(1,D20/$F$20))","v":{"v":0.1875,"d":"18.8%"}},{"v":0.625,"d":"62.5%"},{"$f":"SUM('수익성 분석'!$C21:$E21)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"기타 비용"," ","  ","   ","    "]
[null,"고객 계약 체결",{"v":105000000,"d":"₩105,000,000"},{"v":120000000,"d":"₩120,000,000"},{"v":235000000,"d":"₩235,000,000"},{"$f":"SUM('수익성 분석'!$C24:$E24)","v":{"v":460000000,"d":"₩460,000,000"}}]
[null,"고객 마케팅",{"v":150000000,"d":"150,000,000 "},{"v":125000000,"d":"125,000,000 "},{"v":275000000,"d":"275,000,000 "},{"$f":"SUM('수익성 분석'!$C25:$E25)","v":{"v":550000000,"d":"₩550,000,000"}}]
[null,"고객 계약 종료",{"v":80000000,"d":"80,000,000 "},{"v":190000000,"d":"190,000,000 "},{"v":140000000,"d":"140,000,000 "},{"$f":"SUM('수익성 분석'!$C26:$E26)","v":{"v":410000000,"d":"₩410,000,000"}}]
[null,"기타 고객 비용 합계",{"$f":"SUBTOTAL(109,'수익성 분석'!$C$24:$C$26)","v":{"v":335000000,"d":"335,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$D$24:$D$26)","v":{"v":435000000,"d":"435,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$E$24:$E$26)","v":{"v":650000000,"d":"650,000,000 "}},{"$f":"SUBTOTAL(109,'수익성 분석'!$F$24:$F$26)","v":{"v":1420000000,"d":"1,420,000,000 "}}]
[]
[null,"세그먼트당 고객 수익",{"$f":"C20-C27","v":{"v":-35000000,"d":"(₩35,000,000)"}},{"$f":"D20-D27","v":{"v":-135000000,"d":"(₩135,000,000)"}},{"$f":"E20-E27","v":{"v":350000000,"d":"₩350,000,000"}},{"$f":"F20-'수익성 분석'!$F$27","v":{"v":180000000,"d":"₩180,000,000"}}]
[null,"가중치",{"$f":"MAX(0,MIN(1,C29/$F$29))","v":{"v":0,"d":"0.0%"}},{"$f":"MAX(0,MIN(1,D29/$F$29))","v":{"v":0,"d":"0.0%"}},{"v":1,"d":"100.0%"},{"$f":"SUM('수익성 분석'!$C30:$E30)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"요약 결과"]
[null,"계약 체결 고객당 평균 비용",{"$f":"C24/C8","v":{"v":52500000,"d":"₩52,500,000"}},{"$f":"D24/D8","v":{"v":30000000,"d":"₩30,000,000"}},{"$f":"E24/E8","v":{"v":58750000,"d":"₩58,750,000"}}]
[null,"계약 종료 고객당 평균 비용",{"$f":"-C26/C9","v":{"v":80000000,"d":"₩80,000,000"}},{"$f":"-D26/D9","v":{"v":95000000,"d":"₩95,000,000"}},{"$f":"-E26/E9","v":{"v":70000000,"d":"₩70,000,000"}}]
[null,"활성 고객당 평균 마케팅 비용",{"$f":"C25/'수익성 분석'!$C$10","v":{"v":25000000,"d":"₩25,000,000"}},{"$f":"D25/'수익성 분석'!$D$10","v":{"v":12500000,"d":"₩12,500,000"}},{"$f":"E25/'수익성 분석'!$E$10","v":{"v":27500000,"d":"₩27,500,000"}}]
[null,"고객당 평균 손익",{"$f":"C29/'수익성 분석'!$C$10","v":{"v":-5833333.333333333,"d":"(₩5,833,333)"}},{"$f":"D29/'수익성 분석'!$D$10","v":{"v":-13500000,"d":"(₩13,500,000)"}},{"$f":"E29/'수익성 분석'!$E$10","v":{"v":35000000,"d":"₩35,000,000"}}]

{"sheet":"요약 결과 차트","index":1,"n_rows":3,"n_cols":18,"rows_kept":3}
[]
[null,"고객별 요약 결과",{"$nulls":13}," "]
[null,{"$f":"ReportDate","v":"2013년 1월 20일"},{"$nulls":15},{"$f":"CompanyName","v":"회사 이름"}]