{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","客户盈利能力"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"关于此模板"]
[null,"使用这份客户盈利能力分析跟踪客户活动、销售成本和其他成本。"]
[null,"在表中填写公司名称、日期和详细信息等信息。"]
[null,"自动计算包含公式的单元格中的值和摘要度量表中的值，并且图表自动更新。"]
[null,"注意：  "]
[null,"“客户盈利能力”工作表的 A 列中提供了附加说明。此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关该工作表中各表格的详细信息，请在表格内按 Shift+F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"客户盈利能力","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"merged":[[36,1,36,5]]}
["使用该工作表创建客户盈利能力分析。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。"]
["在右侧单元格中输入公司名称。","公司名称"]
["此工作表的标题位于右侧单元格中。","客户盈利能力分析"]
["在右侧单元格输入日期。","日期"]
["提示位于右侧单元格中。","将为你计算灰色单元格。无需在其中输入任何内容。"]
["从右侧单元格开始，在“客户活动”表格中输入详细信息。下一条说明位于单元格 A12 中。","客户活动：","细化名称 1","细化名称 2","细化名称 3","总体"]
[null,"活跃客户数 - 期初",5,8,8,{"$f":"SUM(C7:E7)","v":21}]
[null,"增加的客户数",2,4,4,{"$f":"SUM(C8:E8)","v":10}]
[null,"失去/终止的客户数",{"v":-1,"d":"(1)"},{"v":-2,"d":"(2)"},{"v":-2,"d":"(2)"},{"$f":"SUM(C9:E9)","v":{"v":-5,"d":"(5)"}}]
[null,"活跃客户数 - 期末",{"$f":"SUBTOTAL(109,客户活动[细化名称 1])","v":6},{"$f":"SUBTOTAL(109,客户活动[细化名称 2])","v":10},{"$f":"SUBTOTAL(109,客户活动[细化名称 3])","v":10},{"$f":"SUBTOTAL(109,客户活动[总体])","v":26}]
[]
["从右侧单元格开始，在“盈利能力分析”表格中输入详细信息。下一条说明位于单元格 A16 中。","盈利能力分析：","细化名称 1","细化名称 2","细化名称 3","总体"]
[null,"每个细化的收入",{"v":1500000,"d":"¥1,500,000.00"},{"v":1800000,"d":"¥1,800,000.00"},{"v":2500000,"d":"¥2,500,000.00"},{"$f":"SUM(盈利能力分析[[#This Row],[细化名称 1]:[细化名称 3]])","v":{"v":5800000,"d":"¥5,800,000.00"}}]
[null,"权重",{"$f":"+C13/$F$13","v":{"v":0.25862068965517243,"d":"26%"}},{"$f":"+D13/$F$13","v":{"v":0.3103448275862069,"d":"31%"}},{"$f":"+E13/$F$13","v":{"v":0.43103448275862066,"d":"43%"}},{"$f":"SUM(盈利能力分析[[#This Row],[细化名称 1]:[细化名称 3]])","v":{"v":1,"d":"100%"}}]
[]
["从右侧单元格开始，在“销售成本”表中输入详细信息。下一条指示位于单元格 A23 中。","销售成本：","细化名称 1","细化名称 2","细化名称 3","总体"]
[null,"持续服务和支持成本",{"v":1000000,"d":"¥1,000,000.00"},{"v":1400000,"d":"¥1,400,000.00"},{"v":1400000,"d":"¥1,400,000.00"},{"$f":"SUM(C17:E17)","v":{"v":3800000,"d":"¥3,800,000.00"}}]
[null,"其他直接客户成本",{"v":200000,"d":"¥200,000.00"},{"v":100000,"d":"¥100,000.00"},{"v":100000,"d":"¥100,000.00"},{"$f":"SUM(C18:E18)","v":{"v":400000,"d":"¥400,000.00"}}]
[null,"销售总成本",{"$f":"SUM(C17:C18)","v":{"v":1200000,"d":"¥1,200,000.00"}},{"$f":"SUM(D17:D18)","v":{"v":1500000,"d":"¥1,500,000.00"}},{"$f":"SUM(E17:E18)","v":{"v":1500000,"d":"¥1,500,000.00"}},{"$f":"SUM(F17:F18)","v":{"v":4200000,"d":"¥4,200,000.00"}}]
[null,"毛利率",{"$f":"+C13-C19","v":{"v":300000,"d":"¥300,000.00"}},{"$f":"+D13-D19","v":{"v":300000,"d":"¥300,000.00"}},{"$f":"+E13-E19","v":{"v":1000000,"d":"¥1,000,000.00"}},{"$f":"+F13-F19","v":{"v":1600000,"d":"¥1,600,000.00"}}]
[null,"权重",{"$f":"MAX(0, MIN(1,C20/$F$20))","v":{"v":0.1875,"d":"19%"}},{"$f":"MAX(0, MIN(1,D20/$F$20))","v":{"v":0.1875,"d":"19%"}},{"$f":"MAX(0, MIN(1,E20/$F$20))","v":{"v":0.625,"d":"63%"}},{"$f":"SUM(C21:E21)","v":{"v":1,"d":"100%"}}]
[]
["从右侧单元格开始，在“其他成本”表中输入详细信息。下一条说明位于单元格 A31 中。","其他成本：","细化名称 1","细化名称 2","细化名称 3","总体"]
[null,"客户获取",{"v":105000,"d":"¥105,000.00"},{"v":120000,"d":"¥120,000.00"},{"v":235000,"d":"¥235,000.00"},{"$f":"SUM(其他成本[[#This Row],[细化名称 1]:[细化名称 3]])","v":{"v":460000,"d":"¥460,000.00"}}]
[null,"客户营销",{"v":150000,"d":"¥150,000.00"},{"v":125000,"d":"¥125,000.00"},{"v":275000,"d":"¥275,000.00"},{"$f":"SUM(C25:E25)","v":{"v":550000,"d":"¥550,000.00"}}]
[null,"客户终止",{"v":80000,"d":"¥80,000.00"},{"v":190000,"d":"¥190,000.00"},{"v":140000,"d":"¥140,000.00"},{"$f":"SUM(C26:E26)","v":{"v":410000,"d":"¥410,000.00"}}]
[null,"其他客户总成本",{"$f":"SUM(C24:C26)","v":{"v":335000,"d":"¥335,000.00"}},{"$f":"SUM(D24:D26)","v":{"v":435000,"d":"¥435,000.00"}},{"$f":"SUM(E24:E26)","v":{"v":650000,"d":"¥650,000.00"}},{"$f":"SUM(F24:F26)","v":{"v":1420000,"d":"¥1,420,000.00"}}]
[null,"按细化列出的客户盈利能力",{"$f":"+C20-C27","v":{"v":-35000,"d":"(¥35,000.00)"}},{"$f":"+D20-D27","v":{"v":-135000,"d":"(¥135,000.00)"}},{"$f":"+E20-E27","v":{"v":350000,"d":"¥350,000.00"}},{"$f":"SUM(C28:E28)","v":{"v":180000,"d":"¥180,000.00"}}]
[null,"权重",{"$f":"MAX(0,MIN(1, C28/$F$28))","v":{"v":0,"d":"0%"}},{"$f":"MAX(0,MIN(1, D28/$F$28))","v":{"v":0,"d":"0%"}},{"$f":"MAX(0,MIN(1, E28/$F$28))","v":{"v":1,"d":"100%"}},{"$f":"SUM(C29:E29)","v":{"v":1,"d":"100%"}}]
[]
["从右侧单元格开始的摘要度量会自动更新。下一条说明位于单元格 A37 中。","摘要度量：","细化名称 1","细化名称 2","细化名称 3","趋势"]
[null,"每个获得客户的平均成本",{"$f":"+C24/C8","v":{"v":52500,"d":"¥52,500.00"}},{"$f":"+D24/D8","v":{"v":30000,"d":"¥30,000.00"}},{"$f":"+E24/E8","v":{"v":58750,"d":"¥58,750.00"}}]
[null,"每个终止客户的平均成本",{"$f":"-C26/C9","v":{"v":80000,"d":"¥80,000.00"}},{"$f":"-D26/D9","v":{"v":95000,"d":"¥95,000.00"}},{"$f":"-E26/E9","v":{"v":70000,"d":"¥70,000.00"}}]
[null,"每个活跃客户的平均营销成本",{"$f":"+C26/客户活动[[#Totals],[细化名称 1]]","v":{"v":13333.333333333334,"d":"¥13,333.33"}},{"$f":"+D25/客户活动[[#Totals],[细化名称 2]]","v":{"v":12500,"d":"¥12,500.00"}},{"$f":"+E25/客户活动[[#Totals],[细化名称 3]]","v":{"v":27500,"d":"¥27,500.00"}}]
[null,"每个客户的平均利润（损失）",{"$f":"+C29/客户活动[[#Totals],[细化名称 1]]","v":{"v":0,"d":"¥0.00"}},{"$f":"+D28/客户活动[[#Totals],[细化名称 2]]","v":{"v":-13500,"d":"(¥13,500.00)"}},{"$f":"+E28/客户活动[[#Totals],[细化名称 3]]","v":{"v":35000,"d":"¥35,000.00"}}]
[]
["显示每个客户细分的摘要​​度量的簇状柱形图位于右侧的单元格中。","显示每个客户细分的摘要​​度量的簇状柱形图位于此单元格中。"]