{"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":15000000,"d":"¥15,000,000"},{"v":18000000,"d":"¥18,000,000"},{"v":25000000,"d":"¥25,000,000"},{"$f":"SUM(利润分析!$C13:$E13)","v":{"v":58000000,"d":"¥58,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":10000000,"d":"¥10,000,000"},{"v":14000000,"d":"¥14,000,000"},{"v":14000000,"d":"¥14,000,000"},{"$f":"SUM(利润分析!$C17:$E17)","v":{"v":38000000,"d":"¥38,000,000"}}]
[null,"其他直接客户成本",{"v":2000000,"d":"2,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"$f":"SUM(利润分析!$C18:$E18)","v":{"v":4000000,"d":"4,000,000 "}}]
[null,"总销售成本",{"$f":"SUBTOTAL(109,利润分析!$C$17:$C$18)","v":{"v":12000000,"d":"12,000,000 "}},{"$f":"SUBTOTAL(109,利润分析!$D$17:$D$18)","v":{"v":15000000,"d":"15,000,000 "}},{"$f":"SUBTOTAL(109,利润分析!$E$17:$E$18)","v":{"v":15000000,"d":"15,000,000 "}},{"$f":"SUBTOTAL(109,利润分析!$F$17:$F$18)","v":{"v":42000000,"d":"42,000,000 "}}]
[null,"总利润",{"$f":"C13-利润分析!$C$19","v":{"v":3000000,"d":"¥3,000,000"}},{"$f":"D13-利润分析!$D$19","v":{"v":3000000,"d":"¥3,000,000"}},{"$f":"E13-利润分析!$E$19","v":{"v":10000000,"d":"¥10,000,000"}},{"$f":"F13-利润分析!$F$19","v":{"v":16000000,"d":"¥16,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":1050000,"d":"¥1,050,000"},{"v":1200000,"d":"¥1,200,000"},{"v":2350000,"d":"¥2,350,000"},{"$f":"SUM(利润分析!$C24:$E24)","v":{"v":4600000,"d":"¥4,600,000"}}]
[null,"客户市场营销",{"v":1500000,"d":"1,500,000 "},{"v":1250000,"d":"1,250,000 "},{"v":2750000,"d":"2,750,000 "},{"$f":"SUM(利润分析!$C25:$E25)","v":{"v":5500000,"d":"¥5,500,000"}}]
[null,"客户终止",{"v":800000,"d":"800,000 "},{"v":1900000,"d":"1,900,000 "},{"v":1400000,"d":"1,400,000 "},{"$f":"SUM(利润分析!$C26:$E26)","v":{"v":4100000,"d":"¥4,100,000"}}]
[null,"其他客户总成本",{"$f":"SUBTOTAL(109,利润分析!$C$24:$C$26)","v":{"v":3350000,"d":"3,350,000 "}},{"$f":"SUBTOTAL(109,利润分析!$D$24:$D$26)","v":{"v":4350000,"d":"4,350,000 "}},{"$f":"SUBTOTAL(109,利润分析!$E$24:$E$26)","v":{"v":6500000,"d":"6,500,000 "}},{"$f":"SUBTOTAL(109,利润分析!$F$24:$F$26)","v":{"v":14200000,"d":"14,200,000 "}}]
[]
[null,"按分部列出的客户利润",{"$f":"C20-C27","v":{"v":-350000,"d":"(¥350,000)"}},{"$f":"D20-D27","v":{"v":-1350000,"d":"(¥1,350,000)"}},{"$f":"E20-E27","v":{"v":3500000,"d":"¥3,500,000"}},{"$f":"F20-利润分析!$F$27","v":{"v":1800000,"d":"¥1,800,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":525000,"d":"¥525,000"}},{"$f":"D24/D8","v":{"v":300000,"d":"¥300,000"}},{"$f":"E24/E8","v":{"v":587500,"d":"¥587,500"}}]
[null,"终止的每个客户的平均成本",{"$f":"-C26/C9","v":{"v":800000,"d":"¥800,000"}},{"$f":"-D26/D9","v":{"v":950000,"d":"¥950,000"}},{"$f":"-E26/E9","v":{"v":700000,"d":"¥700,000"}}]
[null,"每个活动客户的平均市场营销成本",{"$f":"C25/利润分析!$C$10","v":{"v":250000,"d":"¥250,000"}},{"$f":"D25/利润分析!$D$10","v":{"v":125000,"d":"¥125,000"}},{"$f":"E25/利润分析!$E$10","v":{"v":275000,"d":"¥275,000"}}]
[null,"每个客户的平均收益或损失",{"$f":"C29/利润分析!$C$10","v":{"v":-58333.333333333336,"d":"(¥58,333.33)"}},{"$f":"D29/利润分析!$D$10","v":{"v":-135000,"d":"(¥135,000.00)"}},{"$f":"E29/利润分析!$E$10","v":{"v":350000,"d":"¥350,000.00"}}]

{"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":"公司名称"}]