{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Begin","Kanaalmarketingbudget"],"not_rendered":{"images":1,"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 een 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":70,"n_cols":17,"rows_kept":70,"merged":[[0,1,0,19],[1,16,1,19],[2,16,2,19],[4,16,4,19],[5,16,5,19],[30,16,30,19],[31,16,31,19],[32,16,32,19],[33,16,33,17],[34,16,34,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,17],[48,16,48,17],[61,16,61,17],[67,16,67,17]]}
["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."]
["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. Personeeltotaal 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+D36+D44+D51","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"$f":"F11+F36+F44+F51","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":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. Telemarketingtotaal 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.","ITEMS DIRECT MARKETING","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 Internet marketing in, vanaf de cel rechts. Internetmarketingtotaal voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q27. Sparkline wordt bijgewerkt in cel S27. De volgende aanwijzing staat in cel A28.","INTERNET 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,"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,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM(Kanaalmarketingbudget!$D24:$O24)","v":{"v":600,"d":"600.00"}}]
[null,"Twitter",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM(Kanaalmarketingbudget!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"YouTube",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM(Kanaalmarketingbudget!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Totaal internetmarketing € (000)",null,{"$f":"SUM(D20:D26)","v":635.25},{"$f":"SUM(E20:E26)","v":210.25},110.25,210.25,210.25,110.25,110.25,110.25,210.25,210.25,135.25,{"$f":"SUM(O20:O26)","v":210.25},null,{"$f":"SUM(Q20:Q26)","v":{"v":2473,"d":"2,473.00"}}]
["Voer de gegevens in de tabel Direct Mail in, vanaf de cel rechts. Direct Mail-totaal voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q34. De volgende aanwijzing staat in cel A35.","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!$D30:$O30)","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!$D31:$O31)","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!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Totaal Direct Mail € (000)",null,{"$f":"SUM(D30:D32)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E30:E32)","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(Q30:Q32)","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":1939,"d":"1,939.00"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 2]],InternetMarketing[[#Totals],[Maand 2]],DirectMarketing[[#Totals],[Maand 2]])","v":{"v":1481.85,"d":"1,481.85"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 3]],InternetMarketing[[#Totals],[Maand 3]],DirectMarketing[[#Totals],[Maand 3]])","v":{"v":1411.9375,"d":"1,411.94"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 4]],InternetMarketing[[#Totals],[Maand 4]],DirectMarketing[[#Totals],[Maand 4]])","v":{"v":1482.05,"d":"1,482.05"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 5]],InternetMarketing[[#Totals],[Maand 5]],DirectMarketing[[#Totals],[Maand 5]])","v":{"v":1511.948,"d":"1,511.95"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 6]],InternetMarketing[[#Totals],[Maand 6]],DirectMarketing[[#Totals],[Maand 6]])","v":{"v":1381.9375,"d":"1,381.94"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 7]],InternetMarketing[[#Totals],[Maand 7]],DirectMarketing[[#Totals],[Maand 7]])","v":{"v":1411.9,"d":"1,411.90"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 8]],InternetMarketing[[#Totals],[Maand 8]],DirectMarketing[[#Totals],[Maand 8]])","v":{"v":1381.84,"d":"1,381.84"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 9]],InternetMarketing[[#Totals],[Maand 9]],DirectMarketing[[#Totals],[Maand 9]])","v":{"v":1511.8,"d":"1,511.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 10]],InternetMarketing[[#Totals],[Maand 10]],DirectMarketing[[#Totals],[Maand 10]])","v":{"v":1481.8,"d":"1,481.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 11]],InternetMarketing[[#Totals],[Maand 11]],DirectMarketing[[#Totals],[Maand 11]])","v":{"v":1436.8,"d":"1,436.80"}},{"$f":"SUM(DirectMail[[#Totals],[Maand 12]],InternetMarketing[[#Totals],[Maand 12]],DirectMarketing[[#Totals],[Maand 12]])","v":{"v":1481.8,"d":"1,481.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":18231.613,"d":"18,231.61"}}]
["Voer de gegevens in de tabel Agent en broken in, vanaf de cel rechts. Totaal voor Agent en tussenpersoon voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q42. Sparkline wordt bijgewerkt in cel S42. De volgende aanwijzing staat in cel A43.","AGENT/BROKER 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!$D37:$O37)","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!$D38:$O38)","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!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Kortingen",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$40","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!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Commissie (% van verkopen agent)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$41","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!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Agent/tussenpersoon Totaal € (000)",null,{"$f":"SUM(D37:D41)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E37:E41)","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(Q37:Q41)","v":{"v":11139,"d":"11,139.00"}}]
["Voer de gegevens in de tabel Distributeurs in, vanaf de cel rechts. Distributeurtotaal voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q49. Sparkline wordt bijgewerkt in cel S49. De volgende aanwijzing staat in cel A50.","DISTRIBUTEURS 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!$D45:$O45)","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*D44*$C$48","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(D45:D48)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E45:E48)","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(Q45:Q48)","v":{"v":11466.75,"d":"11,466.75"}}]
["Voer de gegevens in de tabel Detailhandel in, vanaf de cel rechts. Detailhandelarentotaal voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q56. Sparkline wordt bijgewerkt in cel S56. De volgende aanwijzing staat in cel A57.","DETAILHANDEL 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!$D52:$O52)","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!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Commissie/kortingen (% van detailhandelverkoop)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D51*$C$55","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM(Kanaalmarketingbudget!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Totaal Detailhandel € (000)",null,{"$f":"SUM(D52:D55)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E52:E55)","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(Q53:Q55)","v":{"v":4292.9,"d":"4,292.90"}}]
["Voer de gegevens in de tabel Klantacquisitie en -retentie in, vanaf de cel rechts. Totaal voor Klantacquisitie en -retentie voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q62. Sparkline wordt bijgewerkt in cel S62. De volgende aanwijzing staat in cel A63.","KLANTACQUISTIE & RETENTIE (CAR) 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,"KLANTACQUISITIE EN -RETENTIE (CAR)"]
[null,"Personeelszaken",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D59:$O59)","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!$D60:$O60)","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!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Totaal CAR € (000)",null,{"$f":"SUM(D59:D61)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E59:E61)","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(Q59:Q61)","v":{"v":10800,"d":"10,800.00"}}]
["Voer de gegevens in in de tabel Overige uitgaven die begint in de cel rechts. Totaal voor Overige uitgaven voor elke maand wordt automatisch berekend aan het einde van de tabel, en het jaarlijkse totaal in cel Q68. Sparkline wordt bijgewerkt in cel S68. De volgende aanwijzing staat in cel A70.","OVERIGE UITGAVEN 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,"OVERIGE UITGAVEN"]
[null,"Reiskosten",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(Kanaalmarketingbudget!$D65:$O65)","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!$D66:$O66)","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!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Totaal Overige uitgaven € (000)",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","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(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
["Totaal Marketingbudget voor elke maand wordt automatisch berekend in deze rij, van cel D70 tot en met O70, en het jaarlijkse totaal in cel Q70. Sparkline wordt bijgewerkt in cel S70.","TOTAAL MARKETINGBUDGET:",null,{"$f":"SUM(D34,AgentEnMakelaar[[#Totals],[Maand 1]],Distributeurs[[#Totals],[Maand 1]],Verkoper[[#Totals],[Maand 1]],CAR[[#Totals],[Maand 1]],OverigeUitgaven[[#Totals],[Maand 1]])","v":{"v":6454,"d":"6,454.00"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 2]],CAR[[#Totals],[Maand 2]],Verkoper[[#Totals],[Maand 2]],Distributeurs[[#Totals],[Maand 2]],AgentEnMakelaar[[#Totals],[Maand 2]],E34)","v":{"v":5985.85,"d":"5,985.85"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 3]],CAR[[#Totals],[Maand 3]],Verkoper[[#Totals],[Maand 3]],Distributeurs[[#Totals],[Maand 3]],AgentEnMakelaar[[#Totals],[Maand 3]],F34)","v":{"v":5934.4375,"d":"5,934.44"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 4]],CAR[[#Totals],[Maand 4]],Verkoper[[#Totals],[Maand 4]],Distributeurs[[#Totals],[Maand 4]],AgentEnMakelaar[[#Totals],[Maand 4]],G34)","v":{"v":6102.05,"d":"6,102.05"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 5]],CAR[[#Totals],[Maand 5]],Verkoper[[#Totals],[Maand 5]],Distributeurs[[#Totals],[Maand 5]],AgentEnMakelaar[[#Totals],[Maand 5]],H34)","v":{"v":6116.348,"d":"6,116.35"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 6]],CAR[[#Totals],[Maand 6]],Verkoper[[#Totals],[Maand 6]],Distributeurs[[#Totals],[Maand 6]],AgentEnMakelaar[[#Totals],[Maand 6]],I34)","v":{"v":6035.6875,"d":"6,035.69"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 7]],CAR[[#Totals],[Maand 7]],Verkoper[[#Totals],[Maand 7]],Distributeurs[[#Totals],[Maand 7]],AgentEnMakelaar[[#Totals],[Maand 7]],J34)","v":{"v":6076.9,"d":"6,076.90"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 8]],CAR[[#Totals],[Maand 8]],Verkoper[[#Totals],[Maand 8]],Distributeurs[[#Totals],[Maand 8]],AgentEnMakelaar[[#Totals],[Maand 8]],K34)","v":{"v":6115.84,"d":"6,115.84"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 9]],CAR[[#Totals],[Maand 9]],Verkoper[[#Totals],[Maand 9]],Distributeurs[[#Totals],[Maand 9]],AgentEnMakelaar[[#Totals],[Maand 9]],L34)","v":{"v":6231.8,"d":"6,231.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 10]],CAR[[#Totals],[Maand 10]],Verkoper[[#Totals],[Maand 10]],Distributeurs[[#Totals],[Maand 10]],AgentEnMakelaar[[#Totals],[Maand 10]],M34)","v":{"v":6201.8,"d":"6,201.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 11]],CAR[[#Totals],[Maand 11]],Verkoper[[#Totals],[Maand 11]],Distributeurs[[#Totals],[Maand 11]],AgentEnMakelaar[[#Totals],[Maand 11]],N34)","v":{"v":6156.8,"d":"6,156.80"}},{"$f":"SUM(OverigeUitgaven[[#Totals],[Maand 12]],CAR[[#Totals],[Maand 12]],Verkoper[[#Totals],[Maand 12]],Distributeurs[[#Totals],[Maand 12]],AgentEnMakelaar[[#Totals],[Maand 12]],O34)","v":{"v":6201.8,"d":"6,201.80"}},null,{"$f":"SUM(D70:O70)","v":{"v":73613.31300000001,"d":"73,613.31"}}]