{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cycle de vie d’un client","Liste"],"not_rendered":{"images":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Cycle de vie d’un client","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[25,1,27,5]]}
[{"$nulls":6}," "]
[]
[null,"Données client"]
[null,"Entrez les données historiques des clients ou vos estimations dans les cellules ombrées ci-dessous."]
[]
[null,null,"Fréquence de service moyenne",1,"par mois"]
[]
[null,null,"Coût moyen par service",{"v":500,"d":"500.00 €"}]
[]
[null,null,"Durée de vie moyenne des clients",10,"année(s)"]
[]
[null,null,"Marge brute moyenne",{"v":0.1,"d":"10.00%"}]
[]
[null,"Coût d’acquisition"]
[null,"Entrez le coût moyen de l’acquisition de nouveaux clients."]
[]
[null,null,"Coût d’acquisition moyen",{"v":200,"d":"200.00 €"}]
[]
[null,"Cycle de vie d’un client"]
[]
[null,null,"Cycle de vie d’un client",{"$f":"(Cost_per_Service*Gross_Margin)*(Fréquence*VLOOKUP(Frequency_Period,Table_Options[],3,FALSE))*(Customer_Life/VLOOKUP(Customer_Life_Period,Table_Options_2,2,FALSE))-Coût_d’acquisition","v":{"v":5800,"d":"5,800.00 €"}}]
[]
[null,null,"Période avant rentabilité",{"$f":"TEXT(Coût_d’acquisition/(Fréquence*Cost_per_Service*Gross_Margin),\"0,0\") & \" \" & VLOOKUP(Frequency_Period,Table_Options[],2,FALSE)","v":"4,0 mois"}]
[]
[null,"Notes :"]

{"sheet":"Liste","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"hidden":true}
["Options de liste 1","Options de liste 2","Multiplicateur d’année"]
["par jour","jour(s)",365]
["par semaine","semaine(s)",72]
["par mois","mois",12]
["par an","année(s)",1]