{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["収益性分析","指標の概要のグラフ"],"not_rendered":{"charts":1,"external_links":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.13",null,"会社名"]
[]
[]
[null,"顧客の動き","顧客 1","顧客 2","顧客 3","全体",null," "]
[null,"現在の顧客数 — 期首",150,240,240,{"$f":"SUM(C7:E7)","v":{"v":630,"d":"630 "}}]
[null,"追加顧客数",60,120,120,{"$f":"SUM(C8:E8)","v":{"v":300,"d":"300 "}}]
[null,"解約顧客数",{"v":-30,"d":"(30)"},{"v":-60,"d":"(60)"},{"v":-60,"d":"(60)"},{"v":-150,"d":"(150)"}]
[null,"現在の顧客数 — 期末",{"$f":"SUBTOTAL(109,収益性分析!$C$7:$C$9)","v":180},{"$f":"SUBTOTAL(109,収益性分析!$D$7:$D$9)","v":300},{"$f":"SUBTOTAL(109,収益性分析!$E$7:$E$9)","v":300},780]
[]
[null,"収益性分析"," ","  ","   ","    "]
[null,"セグメントごとの収益",{"$f":"[1]Sheet1!E7","v":{"v":45000000,"d":"¥45,000,000"}},{"$f":"[1]Sheet1!F7","v":{"v":54000000,"d":"¥54,000,000"}},{"$f":"[1]Sheet1!G7","v":{"v":75000000,"d":"¥75,000,000"}},{"$f":"SUM(収益性分析!$C13:$E13)","v":{"v":174000000,"d":"¥174,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":30000000,"d":"¥30,000,000"},{"v":42000000,"d":"¥42,000,000"},{"v":42000000,"d":"¥42,000,000"},{"$f":"SUM(収益性分析!$C17:$E17)","v":{"v":114000000,"d":"¥114,000,000"}}]
[null,"その他の直接顧客コスト",{"v":6000000,"d":"6,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"$f":"SUM(収益性分析!$C18:$E18)","v":{"v":12000000,"d":"12,000,000 "}}]
[null,"売上原価合計",{"$f":"SUBTOTAL(109,収益性分析!$C$17:$C$18)","v":{"v":36000000,"d":"36,000,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$D$17:$D$18)","v":{"v":45000000,"d":"45,000,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$E$17:$E$18)","v":{"v":45000000,"d":"45,000,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$F$17:$F$18)","v":{"v":126000000,"d":"126,000,000 "}}]
[null,"粗利益",{"$f":"C13-収益性分析!$C$19","v":{"v":9000000,"d":"¥9,000,000"}},{"$f":"D13-収益性分析!$D$19","v":{"v":9000000,"d":"¥9,000,000"}},{"$f":"E13-収益性分析!$E$19","v":{"v":30000000,"d":"¥30,000,000"}},{"$f":"F13-収益性分析!$F$19","v":{"v":48000000,"d":"¥48,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":3150000,"d":"¥3,150,000"},{"v":3600000,"d":"¥3,600,000"},{"v":7050000,"d":"¥7,050,000"},{"$f":"SUM(収益性分析!$C24:$E24)","v":{"v":13800000,"d":"¥13,800,000"}}]
[null,"顧客マーケティング",{"v":4500000,"d":"4,500,000 "},{"v":3750000,"d":"3,750,000 "},{"v":8250000,"d":"8,250,000 "},{"$f":"SUM(収益性分析!$C25:$E25)","v":{"v":16500000,"d":"¥16,500,000"}}]
[null,"顧客の解約",{"v":2400000,"d":"2,400,000 "},{"v":5700000,"d":"5,700,000 "},{"v":4200000,"d":"4,200,000 "},{"$f":"SUM(収益性分析!$C26:$E26)","v":{"v":12300000,"d":"¥12,300,000"}}]
[null,"その他の顧客の総コスト",{"$f":"SUBTOTAL(109,収益性分析!$C$24:$C$26)","v":{"v":10050000,"d":"10,050,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$D$24:$D$26)","v":{"v":13050000,"d":"13,050,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$E$24:$E$26)","v":{"v":19500000,"d":"19,500,000 "}},{"$f":"SUBTOTAL(109,収益性分析!$F$24:$F$26)","v":{"v":42600000,"d":"42,600,000 "}}]
[]
[null,"セグメントごとの顧客利益",{"$f":"C20-C27","v":{"v":-1050000,"d":"-¥1,050,000"}},{"$f":"D20-D27","v":{"v":-4050000,"d":"-¥4,050,000"}},{"$f":"E20-E27","v":{"v":10500000,"d":"¥10,500,000"}},{"$f":"F20-収益性分析!$F$27","v":{"v":5400000,"d":"¥5,400,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":52500,"d":"¥52,500"}},{"$f":"D24/D8","v":{"v":30000,"d":"¥30,000"}},{"$f":"E24/E8","v":{"v":58750,"d":"¥58,750"}}]
[null,"解約顧客ごとの平均コスト",{"$f":"-C26/C9","v":{"v":80000,"d":"¥80,000"}},{"$f":"-D26/D9","v":{"v":95000,"d":"¥95,000"}},{"$f":"-E26/E9","v":{"v":70000,"d":"¥70,000"}}]
[null,"現在の顧客ごとの平均マーケティング コスト",{"$f":"C25/収益性分析!$C$10","v":{"v":25000,"d":"¥25,000"}},{"$f":"D25/収益性分析!$D$10","v":{"v":12500,"d":"¥12,500"}},{"$f":"E25/収益性分析!$E$10","v":{"v":27500,"d":"¥27,500"}}]
[null,"顧客ごとの平均損益",{"$f":"C29/収益性分析!$C$10","v":{"v":-5833.333333333333,"d":"-¥5,833"}},{"$f":"D29/収益性分析!$D$10","v":{"v":-13500,"d":"-¥13,500"}},{"$f":"E29/収益性分析!$E$10","v":{"v":35000,"d":"¥35,000"}}]

{"sheet":"指標の概要のグラフ","index":1,"n_rows":3,"n_cols":18,"rows_kept":3}
[]
[null,"顧客ごとの指標の概要",{"$nulls":13}," "]
[null,{"$f":"ReportDate","v":"2013.1.13"},{"$nulls":15},"会社名"]