{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Begin","Kanaalmarketingbudget"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Begin","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"OVER DEZE SJABLOON"]
[null,"Gebruik deze sjabloon om Kanaalmarketingbudget te maken."]
[null,"Voer de verwachte verkoop voor elke maand en andere gegevens in tabellen in."]
[null,"Totalen worden automatisch berekend en sparklines worden bijgewerkt."]
[null,"Opmerking: "]
[null,"Kolom A van het werkblad Kanaalmarketingbudget bevat aanvullende instructies. Deze tekst is opzettelijk verborgen. Als u tekst wilt verwijderen, selecteert u kolom A en drukt u op Delete. Als u de tekst zichtbaar wilt maken, selecteert u kolom A en wijzigt u de tekenkleur."]
[null,"Als u meer wilt weten over tabellen, drukt u in een tabel op Shift en F10 en selecteert u de optie Tabel en vervolgens Alternatieve tekst."]

{"sheet":"Kanaalmarketingbudget","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Maak Kanaalmarketingbudget in dit werkblad. De titel van dit werkblad staat in de cel rechts. Nuttige instructies zijn te vinden in de cellen in deze kolom. Druk op de pijl-omlaag om aan de slag te gaan. De titel van dit werkblad staat in de cel rechts.","KANAALMARKETINGBUDGET"]
["Tarief- en maandlabels staan in deze rij, van cel C2 tot en met O2 en het label Totaal staat in cel Q2."," ","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12",null,"Totaal"]
["Label voor verwacht verkooptotaal staat in cel rechts. Voer verwachte verkoop voor elke maand in cel D3 tot en met O3 in. Totaal wordt automatisch berekend in cel Q3.","VERWACHT VERKOOPTOTAAL € (000)"," ",750,200,500,{"v":1500,"d":"1,500"},{"v":1200,"d":"1,200"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1800,"d":"1,800"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D3:O3)","v":{"v":16950,"d":"16,950"}}]
["Voer de gegevens in de tabel Personeel in, vanaf de cel rechts. Totaal personeel voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q9. Sparkline wordt bijgewerkt in cel S9. De volgende aanwijzing staat in cel A10.","Personeelitems","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"PERSONEEL (% VAN TOTALE VERKOOP)",null,{"$f":"D11+D33+D41+D48","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"}]
[null,"HR - personeelsbezetting",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"HR - kosten",null,{"$f":"$C$6*D6","v":{"v":25,"d":"25.00"}},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Provisie",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$8","v":0.75},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.8,"d":"1.80"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Totaal personeel € (000)",null,{"$f":"SUM(D7:D8)","v":25.75},{"$f":"SUM(E7:E8)","v":{"v":25.2,"d":"25.20"}},{"v":25.5,"d":"25.50"},{"v":26.5,"d":"26.50"},{"v":26.2,"d":"26.20"},{"v":26.5,"d":"26.50"},{"v":26.5,"d":"26.50"},{"v":26.8,"d":"26.80"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},null,{"$f":"SUM(Q7:Q8)","v":316.95}]
["Voer de gegevens in de tabel Direct Marketing in, vanaf de cel rechts. Totaal telemarketing voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijks totaal in cel Q17. Sparkline wordt bijgewerkt in cel S17. De volgende aanwijzing staat in cel A18.","Direct marketing-items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"DIRECT MARKETING (% VAN TOTALE VERKOOP)",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":0.4,"d":"40%"},{"v":0.33,"d":"33%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Telemarketing (% van directe verkoop)",null,{"v":1,"d":"100%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"HR - personeelsbezetting",3,{"$f":"$C$13*D12","v":3},1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,null,{"$f":"SUM(Kanaalmarketingbudget!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Infrastructuurondersteuning",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(Kanaalmarketingbudget!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Provisie",{"v":1E-3,"d":"0.10%"},{"$f":"$C$15*D3*D11*D12","v":0.75},{"v":0.1,"d":"0.10"},{"v":0.1875,"d":"0.19"},{"v":0.30000000000000004,"d":"0.30"},{"v":0.198,"d":"0.20"},{"v":0.1875,"d":"0.19"},{"v":0.15000000000000002,"d":"0.15"},{"v":0.09000000000000001,"d":"0.09"},0.05,0.05,0.05,0.05,null,{"$f":"SUM(Kanaalmarketingbudget!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Training",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(Kanaalmarketingbudget!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Totaal telemarketing € (000)",null,{"$f":"SUM(D13:D16)","v":53.75},{"$f":"SUM(E13:E16)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F13:F16)","v":{"v":51.6875,"d":"51.69"}},{"v":21.8,"d":"21.80"},{"v":51.698,"d":"51.70"},{"v":21.6875,"d":"21.69"},51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(Q13:Q16)","v":{"v":441.663,"d":"441.66"}}]
["Voer de gegevens in de tabel Internetmarketing in, vanaf de cel rechts. Totaal internetmarketing voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q24. Sparkline wordt bijgewerkt in cel S24. De volgende aanwijzing staat in cel A25.","Internetmarketing-items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"Internetmarketing (% van directe verkoop)",null,{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
[null,"HR - personeelsbezetting",1,{"$f":"$C$20*D19","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,{"$f":"SUM(Kanaalmarketingbudget!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Websiteontwikkeling (eenmalige kosten)",null,500,{"$nulls":12},{"$f":"SUM(Kanaalmarketingbudget!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Hosting",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM(Kanaalmarketingbudget!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Ondersteuning en onderhoud",null,25,{"$nulls":9},25,null,null,{"$f":"SUM(Kanaalmarketingbudget!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Totaal internetmarketing € (000)",null,{"$f":"SUM(D20:D23)","v":535.25},{"$f":"SUM(E20:E23)","v":10.25},10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,35.25,10.25,null,{"$f":"SUM(Q20:Q23)","v":{"v":673,"d":"673.00"}}]
["Voer de gegevens in de tabel Direct Mail in, vanaf de cel rechts. Totaal Direct Mail voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q30. De volgende aanwijzing staat in cel A31."," Direct Mail-Items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"Direct Mail (% van directe verkoop)"]
[null,"HR - kosten",{"$nulls":14},{"$f":"SUM(Kanaalmarketingbudget!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Materiaal",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM(Kanaalmarketingbudget!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Portokosten",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(Kanaalmarketingbudget!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Totaal Direct Mail € (000)",null,{"$f":"SUM(D27:D29)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E27:E29)","v":{"v":1250,"d":"1,250.00"}},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},null,{"$f":"SUM(Q27:Q29)","v":{"v":15000,"d":"15,000.00"}}]
["Totaal Direct Marketing wordt automatisch berekend in deze rij, van cel D31 tot en met O31, en het jaarlijkse totaal in cel Q31. Sparkline wordt bijgewerkt in cel S31.","Totaal Direct Marketing € (000)",null,{"$f":"SUM(DirectMail[[#Totals],[Maand 1]],InternetMarketing[[#Totals],[Maand 1]],DirectMarketing[[#Totals],[Maand 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 2]],InternetMarketing[[#Totals],[Maand 2]],DirectMarketing[[#Totals],[Maand 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 3]],InternetMarketing[[#Totals],[Maand 3]],DirectMarketing[[#Totals],[Maand 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 4]],InternetMarketing[[#Totals],[Maand 4]],DirectMarketing[[#Totals],[Maand 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 5]],InternetMarketing[[#Totals],[Maand 5]],DirectMarketing[[#Totals],[Maand 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 6]],InternetMarketing[[#Totals],[Maand 6]],DirectMarketing[[#Totals],[Maand 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 7]],InternetMarketing[[#Totals],[Maand 7]],DirectMarketing[[#Totals],[Maand 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 8]],InternetMarketing[[#Totals],[Maand 8]],DirectMarketing[[#Totals],[Maand 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 9]],InternetMarketing[[#Totals],[Maand 9]],DirectMarketing[[#Totals],[Maand 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 10]],InternetMarketing[[#Totals],[Maand 10]],DirectMarketing[[#Totals],[Maand 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 11]],InternetMarketing[[#Totals],[Maand 11]],DirectMarketing[[#Totals],[Maand 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 12]],InternetMarketing[[#Totals],[Maand 12]],DirectMarketing[[#Totals],[Maand 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Voer de gegevens in de tabel Agent en tussenpersoon in, vanaf de cel rechts. Agent/tussenpersoon-items voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q39. Sparkline wordt bijgewerkt in cel S39. De volgende aanwijzing staat in cel A40.","Agent/tussenpersoon-items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"AGENT/TUSSENPERSOON (% VAN TOTALE VERKOOP)",null,{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
[null,"Communicatie",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Reclame",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Kortingen",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$37","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Commissie (% van verkopen agent)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$38","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Agent/tussenpersoon-items € (000)",null,{"$f":"SUM(D34:D38)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E34:E38)","v":{"v":904,"d":"904.00"}},{"v":910,"d":"910.00"},{"v":930,"d":"930.00"},{"v":924,"d":"924.00"},{"v":930,"d":"930.00"},{"v":930,"d":"930.00"},{"v":936,"d":"936.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},null,{"$f":"SUM(Q34:Q38)","v":{"v":11139,"d":"11,139.00"}}]
["Voer de gegevens in de tabel Distributeurs in, vanaf de cel rechts. Totaal Distributeurs voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q46. Sparkline wordt bijgewerkt in cel S46. De volgende aanwijzing staat in cel A47.","Distributeur-items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"DISTRIBUTEURS (% VAN TOTALE VERKOOP)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Communicatie",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Distributeurs[[#This Row],[Maand 1]:[Maand 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Reclame",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM(Distributeurs[[#This Row],[Maand 1]:[Maand 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Commissie/kortingen (% van verkopen distributeurs)",{"v":0.15,"d":"15.00%"},{"$f":"D3*D41*$C$45","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(Distributeurs[[#This Row],[Maand 1]:[Maand 12]])","v":666.75}]
[null,"Totaal Distributeurs € (000)",null,{"$f":"SUM(D42:D45)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E42:E45)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},933.75,{"v":945,"d":"945.00"},{"v":1008,"d":"1,008.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},null,{"$f":"SUM(Q42:Q45)","v":{"v":11466.75,"d":"11,466.75"}}]
["Voer de gegevens in de tabel Detailhandelaar in, vanaf de cel rechts. Totaal Detailhandel voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q53. Sparkline wordt bijgewerkt in cel S53. De volgende aanwijzing staat in cel A54.","Detailhandelaren-items","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"DETAILHANDELAAR (% VAN TOTALE VERKOOP)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.25,"d":"25%"},{"v":0.6,"d":"60%"},{"v":0.67,"d":"67%"},{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"Communicatie",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Reclame",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Commissie/kortingen (% van detailhandelverkoop)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D48*$C$52","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM(Kanaalmarketingbudget!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Totaal Detailhandel € (000)",null,{"$f":"SUM(D49:D52)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E49:E52)","v":{"v":900,"d":"900.00"}},{"v":912.5,"d":"912.50"},{"v":990,"d":"990.00"},{"v":980.4,"d":"980.40"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},null,{"$f":"SUM(Q50:Q52)","v":{"v":4292.9,"d":"4,292.90"}}]
["Voer de gegevens in de tabel Klantacquisitie en -retentie in, vanaf de cel rechts. Totaal CAR voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q59. Sparkline wordt bijgewerkt in cel S59. De volgende aanwijzing staat in cel A60.","Items voor klantacquisitie en -retentie (CAR)","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"KLANTACQUISITIE EN -RETENTIE (CAR)"]
[null,"Personeelszaken",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Communicatie",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Acties/vouchers",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(Kanaalmarketingbudget!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Totaal CAR € (000)",null,{"$f":"SUM(D56:D58)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E56:E58)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q56:Q58)","v":{"v":10800,"d":"10,800.00"}}]
["Voer de gegevens in de tabel Overige uitgaven in, vanaf de cel rechts. Totaal Overige uitgaven voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q65. Sparkline wordt bijgewerkt in cel S65. De volgende aanwijzing staat in cel A67.","Items Overige uitgaven ","Tarief","Maand 1","Maand 2","Maand 3","Maand 4","Maand 5","Maand 6","Maand 7","Maand 8","Maand 9","Maand 10","Maand 11","Maand 12"]
[null,"OVERIGE UITGAVEN"]
[null,"Reiskosten",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastructuur (computer, telefoon, enzovoort.)",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Kanaalmarketingbudget!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kanaalondersteuning",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(Kanaalmarketingbudget!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Totaal Overige uitgaven € (000)",null,{"$f":"SUM(D62:D64)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E62:E64)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q62:Q64)","v":{"v":10800,"d":"10,800.00"}}]
[]
["Totaal markeringbudget voor elke maand wordt automatisch berekend in deze rij, van cel D67 tot en met O67, en het jaarlijkse totaal in cel Q67. Sparkline wordt bijgewerkt in cel S67.","TOTAAL MARKETINGBUDGET:",null,{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 1]],CAR[[#Totals],[Maand 1]],Verkoper[[#Totals],[Maand 1]],Distributeurs[[#Totals],[Maand 1]],AgentEnMakelaar[[#Totals],[Maand 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 2]],CAR[[#Totals],[Maand 2]],Verkoper[[#Totals],[Maand 2]],Distributeurs[[#Totals],[Maand 2]],AgentEnMakelaar[[#Totals],[Maand 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 3]],CAR[[#Totals],[Maand 3]],Verkoper[[#Totals],[Maand 3]],Distributeurs[[#Totals],[Maand 3]],AgentEnMakelaar[[#Totals],[Maand 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 4]],CAR[[#Totals],[Maand 4]],Verkoper[[#Totals],[Maand 4]],Distributeurs[[#Totals],[Maand 4]],AgentEnMakelaar[[#Totals],[Maand 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 5]],CAR[[#Totals],[Maand 5]],Verkoper[[#Totals],[Maand 5]],Distributeurs[[#Totals],[Maand 5]],AgentEnMakelaar[[#Totals],[Maand 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 6]],CAR[[#Totals],[Maand 6]],Verkoper[[#Totals],[Maand 6]],Distributeurs[[#Totals],[Maand 6]],AgentEnMakelaar[[#Totals],[Maand 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 7]],CAR[[#Totals],[Maand 7]],Verkoper[[#Totals],[Maand 7]],Distributeurs[[#Totals],[Maand 7]],AgentEnMakelaar[[#Totals],[Maand 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 8]],CAR[[#Totals],[Maand 8]],Verkoper[[#Totals],[Maand 8]],Distributeurs[[#Totals],[Maand 8]],AgentEnMakelaar[[#Totals],[Maand 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 9]],CAR[[#Totals],[Maand 9]],Verkoper[[#Totals],[Maand 9]],Distributeurs[[#Totals],[Maand 9]],AgentEnMakelaar[[#Totals],[Maand 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 10]],CAR[[#Totals],[Maand 10]],Verkoper[[#Totals],[Maand 10]],Distributeurs[[#Totals],[Maand 10]],AgentEnMakelaar[[#Totals],[Maand 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 11]],CAR[[#Totals],[Maand 11]],Verkoper[[#Totals],[Maand 11]],Distributeurs[[#Totals],[Maand 11]],AgentEnMakelaar[[#Totals],[Maand 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 12]],CAR[[#Totals],[Maand 12]],Verkoper[[#Totals],[Maand 12]],Distributeurs[[#Totals],[Maand 12]],AgentEnMakelaar[[#Totals],[Maand 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]