{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["客户生命周期值","列表"],"not_rendered":{"images":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"客户生命周期值","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[25,1,27,5]]}
[{"$nulls":6}," "]
[]
[null,"客户数据"]
[null,"在下面的阴影单元格中输入历史客户数据或您的最佳估算值。"]
[]
[null,null,"平均服务频率",1,"每月"]
[]
[null,null,"每服务平均费用",{"v":500,"d":"¥500.00"}]
[]
[null,null,"平均客户生命",10,"年"]
[]
[null,null,"平均毛利率",{"v":0.1,"d":"10.00%"}]
[]
[null,"购置成本"]
[null,"输入获取新客户的平均成本。"]
[]
[null,null,"平均购置成本",{"v":200,"d":"¥200.00"}]
[]
[null,"客户生命周期值"]
[]
[null,null,"客户生命周期值",{"$f":"(Cost_per_Service*Gross_Margin)*(频率*VLOOKUP(Frequency_Period,Table_Options[],3,FALSE))*(Customer_Life/VLOOKUP(Customer_Life_Period,Table_Options_2,2,FALSE))-购置成本","v":{"v":5800,"d":"¥5,800.00"}}]
[]
[null,null,"盈亏平衡回收期",{"$f":"TEXT(购置成本/(频率*Cost_per_Service*Gross_Margin),\"0.0\") & \" \" & VLOOKUP(Frequency_Period,Table_Options[],2,FALSE)","v":"4.0 月"}]
[]
[null,"备注："]

{"sheet":"列表","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"hidden":true}
["列表选项 1","列表选项 2","年乘数"]
["每天","日",365]
["每周","周",72]
["每月","月",12]
["每年","年",1]