{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Waarde klantlevenscyclus","Lijst"],"not_rendered":{"images":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Waarde klantlevenscyclus","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[25,1,27,5]]}
[{"$nulls":6}," "]
[]
[null,"Klantgegevens"]
[null,"Voer in de onderstaande gearceerde cellen de historische klantgegevens of geschatte waarden in."]
[]
[null,null,"Gemiddelde onderhoudsfrequentie",1,"per maand"]
[]
[null,null,"Gemiddelde kosten per onderhoudsbeurt",{"v":500,"d":"€ 500.00"}]
[]
[null,null,"Gemiddelde levensduur klant",10,"jaar"]
[]
[null,null,"Gemiddelde brutomarge",{"v":0.1,"d":"10.00%"}]
[]
[null,"Aanschafkosten"]
[null,"Voer de gemiddelde kosten om nieuwe klanten aan te trekken in."]
[]
[null,null,"Gemiddelde aanschafkosten",{"v":200,"d":"€ 200.00"}]
[]
[null,"Waarde klantlevenscyclus"]
[]
[null,null,"Waarde klantlevenscyclus",{"$f":"(Cost_per_Service*Gross_Margin)*(Frequentie*VLOOKUP(Frequency_Period,Table_Options[],3,FALSE))*(Customer_Life/VLOOKUP(Customer_Life_Period,Table_Options_2,2,FALSE))-Acquisition_Cost","v":{"v":5800,"d":"€ 5,800.00"}}]
[]
[null,null,"Kostendekkende terugverdientijd",{"$f":"TEXT(Acquisition_Cost/(Frequentie*Cost_per_Service*Gross_Margin),\"0,0\") & \" \" & VLOOKUP(Frequency_Period,Table_Options[],2,FALSE)","v":"4,0 maand(en)"}]
[]
[null,"Notities:"]

{"sheet":"Lijst","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"hidden":true}
["Lijstopties 1","Lijstopties 2","Vermenigvuldigingsfactor jaren"]
["per dag","dag(en)",365]
["per week","week/weken",72]
["per maand","maand(en)",12]
["per jaar","jaar",1]