{"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":"NT$1,500,000.00"},{"v":1800000,"d":"NT$1,800,000.00"},{"v":2500000,"d":"NT$2,500,000.00"},{"$f":"SUM(獲利分析[[#This Row],[客群名稱 1]:[客群名稱 3]])","v":{"v":5800000,"d":"NT$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":"NT$1,000,000.00"},{"v":1400000,"d":"NT$1,400,000.00"},{"v":1400000,"d":"NT$1,400,000.00"},{"$f":"SUM(C17:E17)","v":{"v":3800000,"d":"NT$3,800,000.00"}}]
[null,"其他直接客戶成本",{"v":200000,"d":"NT$200,000.00"},{"v":100000,"d":"NT$100,000.00"},{"v":100000,"d":"NT$100,000.00"},{"$f":"SUM(C18:E18)","v":{"v":400000,"d":"NT$400,000.00"}}]
[null,"總銷售成本",{"$f":"SUM(C17:C18)","v":{"v":1200000,"d":"NT$1,200,000.00"}},{"$f":"SUM(D17:D18)","v":{"v":1500000,"d":"NT$1,500,000.00"}},{"$f":"SUM(E17:E18)","v":{"v":1500000,"d":"NT$1,500,000.00"}},{"$f":"SUM(F17:F18)","v":{"v":4200000,"d":"NT$4,200,000.00"}}]
[null,"毛利",{"$f":"+C13-C19","v":{"v":300000,"d":"NT$300,000.00"}},{"$f":"+D13-D19","v":{"v":300000,"d":"NT$300,000.00"}},{"$f":"+E13-E19","v":{"v":1000000,"d":"NT$1,000,000.00"}},{"$f":"+F13-F19","v":{"v":1600000,"d":"NT$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":"NT$105,000.00"},{"v":120000,"d":"NT$120,000.00"},{"v":235000,"d":"NT$235,000.00"},{"$f":"SUM(其他成本[[#This Row],[客群名稱 1]:[客群名稱 3]])","v":{"v":460000,"d":"NT$460,000.00"}}]
[null,"客戶行銷成本",{"v":150000,"d":"NT$150,000.00"},{"v":125000,"d":"NT$125,000.00"},{"v":275000,"d":"NT$275,000.00"},{"$f":"SUM(C25:E25)","v":{"v":550000,"d":"NT$550,000.00"}}]
[null,"客戶終止成本",{"v":80000,"d":"NT$80,000.00"},{"v":190000,"d":"NT$190,000.00"},{"v":140000,"d":"NT$140,000.00"},{"$f":"SUM(C26:E26)","v":{"v":410000,"d":"NT$410,000.00"}}]
[null,"其他客戶總成本",{"$f":"SUM(C24:C26)","v":{"v":335000,"d":"NT$335,000.00"}},{"$f":"SUM(D24:D26)","v":{"v":435000,"d":"NT$435,000.00"}},{"$f":"SUM(E24:E26)","v":{"v":650000,"d":"NT$650,000.00"}},{"$f":"SUM(F24:F26)","v":{"v":1420000,"d":"NT$1,420,000.00"}}]
[null,"各客群客戶獲利",{"$f":"+C20-C27","v":{"v":-35000,"d":"(NT$35,000.00)"}},{"$f":"+D20-D27","v":{"v":-135000,"d":"(NT$135,000.00)"}},{"$f":"+E20-E27","v":{"v":350000,"d":"NT$350,000.00"}},{"$f":"SUM(C28:E28)","v":{"v":180000,"d":"NT$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":"NT$52,500.00"}},{"$f":"+D24/D8","v":{"v":30000,"d":"NT$30,000.00"}},{"$f":"+E24/E8","v":{"v":58750,"d":"NT$58,750.00"}}]
[null,"每終止一位客戶之平均成本",{"$f":"-C26/C9","v":{"v":80000,"d":"NT$80,000.00"}},{"$f":"-D26/D9","v":{"v":95000,"d":"NT$95,000.00"}},{"$f":"-E26/E9","v":{"v":70000,"d":"NT$70,000.00"}}]
[null,"每位活躍客戶之平均行銷成本",{"$f":"+C26/客戶活躍程度[[#Totals],[客群名稱 1]]","v":{"v":13333.333333333334,"d":"NT$13,333.33"}},{"$f":"+D25/客戶活躍程度[[#Totals],[客群名稱 2]]","v":{"v":12500,"d":"NT$12,500.00"}},{"$f":"+E25/客戶活躍程度[[#Totals],[客群名稱 3]]","v":{"v":27500,"d":"NT$27,500.00"}}]
[null,"每位客戶之平均獲益 (損失)",{"$f":"+C29/客戶活躍程度[[#Totals],[客群名稱 1]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"+D28/客戶活躍程度[[#Totals],[客群名稱 2]]","v":{"v":-13500,"d":"(NT$13,500.00)"}},{"$f":"+E28/客戶活躍程度[[#Totals],[客群名稱 3]]","v":{"v":35000,"d":"NT$35,000.00"}}]
[]
["右側儲存格為顯示各客群摘要指標的群組直條圖。","此儲存格為顯示各客群摘要指標的群組直條圖。"]