{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Démarrer","Budget des canaux marketing"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Démarrer","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"À PROPOS DE CE MODÈLE"]
[null,"Utilisez ce modèle pour créer le Budget des canaux marketing."]
[null,"Entrez les ventes mensuelles prévues et les autres détails dans les tableaux."]
[null,"Le calcul des totaux et la mise à jour des graphiques sparkline sont automatiques."]
[null,"Remarque : "]
[null,"Des instructions supplémentaires sont disponibles dans la colonne A de la feuille de calcul BUDGET DES CANAUX MARKETING. Ce texte a été intentionnellement masqué. Pour supprimer le texte, sélectionnez la colonne A et choisissez SUPPRIMER. Pour afficher le texte, sélectionnez la colonne A et changez la couleur de la police."]
[null,"Pour en savoir plus sur les tableaux, appuyez sur MAJ, puis sur F10 dans un tableau, et sélectionnez les options TABLE et TEXTE DE REMPLACEMENT"]

{"sheet":"Budget des canaux marketing","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Utilisez cette feuille de calcul pour créer le Budget des canaux marketing. Le titre de cette feuille de calcul se trouve dans la cellule de droite. Des instructions utiles sont disponibles dans les cellules de cette colonne. Appuyez sur la flèche Bas pour commencer. Le titre de cette feuille de calcul se trouve dans la cellule de droite.","BUDGET DES CANAUX MARKETING"]
["Les étiquettes Taux et Mois figurent sur cette ligne, dans les cellules C2 à O2, et l’étiquette Total se trouve dans la cellule T2."," ","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12",null,"Total"]
["L’étiquette Total des ventes prévues se trouve dans la cellule de droite. Entrez les ventes mensuelles prévues dans les cellules D3 à O3. Le total est automatiquement calculé dans la cellule Q3.","TOTAL DES VENTES PRÉVUES - (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"}}]
["Entrez les détails dans le tableau Personnel, à partir de la cellule de droite. Le total mensuel relatif au personnel apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q9. Le graphique sparkline est mis à jour dans la cellule F9. L’instruction suivante figure dans la cellule A10.","Personnel","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"PERSONNEL (% DES VENTES TOTALES)",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,"Ressources humaines - Effectifs",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Ressources humaines - Coût",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('Budget des canaux marketing'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Commission",{"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"},{"$f":"G3*$C$8","v":{"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('Budget des canaux marketing'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Total personnel - (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}]
["Entrez les détails dans le tableau Marketing direct, à partir de la cellule de droite. Le total mensuel relatif au télémarketing apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q17. Le graphique sparkline est mis à jour dans la cellule S17. L’instruction suivante figure dans la cellule A18.","Marketing direct","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"MARKETING DIRECT (% DES VENTES TOTALES)",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,"Télémarketing (% des ventes directes)",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,"Ressources humaines - Effectifs",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('Budget des canaux marketing'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Prise en charge de l’infrastructure",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Budget des canaux marketing'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Commission",{"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('Budget des canaux marketing'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Formation",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Budget des canaux marketing'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Total télémarketing - (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"}}]
["Entrez les détails dans le tableau Marketing Internet, à partir de la cellule de droite. Le total mensuel relatif au marketing Internet apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q24. Le graphique sparkline est mis à jour dans la cellule S24. L’instruction suivante figure dans la cellule A25.","Marketing Internet","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"Marketing Internet (% des ventes directes)",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,"Ressources humaines - Effectifs",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('Budget des canaux marketing'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Développement du site Web (coût ponctuel)",null,500,{"$nulls":12},{"$f":"SUM('Budget des canaux marketing'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Hébergement",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Budget des canaux marketing'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Soutien et maintenance",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Budget des canaux marketing'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Total marketing Internet - (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"}}]
["Entrez les détails dans le tableau Publipostage, à partir de la cellule de droite. Le total mensuel relatif au publipostage apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q30. L’instruction suivante figure dans la cellule A31."," Publipostage","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"Publipostage (% des ventes directes)"]
[null,"Ressources humaines - Coût",{"$nulls":14},{"$f":"SUM('Budget des canaux marketing'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Matériel",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Budget des canaux marketing'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Affranchissement",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Budget des canaux marketing'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Total publipostage - (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"}}]
["Le total mensuel relatif au marketing direct apparaît automatiquement sur cette ligne, dans les cellules D31 à O31, et le total annuel dans la cellule Q31. Le graphique sparkline est mis à jour dans la cellule S31.","Total marketing direct - (000) $",null,{"$f":"SUM(Publipostage[[#Totals],[Mois 1]],Marketing_Internet[[#Totals],[Mois 1]],Marketing_direct[[#Totals],[Mois 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 2]],Marketing_Internet[[#Totals],[Mois 2]],Marketing_direct[[#Totals],[Mois 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 3]],Marketing_Internet[[#Totals],[Mois 3]],Marketing_direct[[#Totals],[Mois 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 4]],Marketing_Internet[[#Totals],[Mois 4]],Marketing_direct[[#Totals],[Mois 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 5]],Marketing_Internet[[#Totals],[Mois 5]],Marketing_direct[[#Totals],[Mois 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 6]],Marketing_Internet[[#Totals],[Mois 6]],Marketing_direct[[#Totals],[Mois 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 7]],Marketing_Internet[[#Totals],[Mois 7]],Marketing_direct[[#Totals],[Mois 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 8]],Marketing_Internet[[#Totals],[Mois 8]],Marketing_direct[[#Totals],[Mois 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 9]],Marketing_Internet[[#Totals],[Mois 9]],Marketing_direct[[#Totals],[Mois 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 10]],Marketing_Internet[[#Totals],[Mois 10]],Marketing_direct[[#Totals],[Mois 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 11]],Marketing_Internet[[#Totals],[Mois 11]],Marketing_direct[[#Totals],[Mois 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Publipostage[[#Totals],[Mois 12]],Marketing_Internet[[#Totals],[Mois 12]],Marketing_direct[[#Totals],[Mois 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Entrez les détails dans le tableau Agents et courtiers, à partir de la cellule de droite. Le total mensuel relatif aux agents et courtiers apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q39. Le graphique sparkline est mis à jour dans la cellule S39. L’instruction suivante figure dans la cellule A40.","Agents/Courtiers","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"AGENTS/COURTIERS (% DES VENTES TOTALES)",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,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budget des canaux marketing'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Formation",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('Budget des canaux marketing'!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions",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('Budget des canaux marketing'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Remises",{"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('Budget des canaux marketing'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Commission (% des ventes de l’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('Budget des canaux marketing'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Total agents/courtiers - (000) $",null,{"$f":"SUM(D34:D38)","v":{"v":915,"d":"915.00"}},{"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"}}]
["Entrez les détails dans le tableau Distributeurs, à partir de la cellule de droite. Le total mensuel relatif aux distributeurs apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q46. Le graphique sparkline est mis à jour dans la cellule S46. L’instruction suivante figure dans la cellule A47.","Distributeurs","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"DISTRIBUTEURS (% DES VENTES TOTALES)",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,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budget des canaux marketing'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Formation",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],[Mois 1]:[Mois 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions",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],[Mois 1]:[Mois 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Commission/Remises (% des ventes des 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],[Mois 1]:[Mois 12]])","v":666.75}]
[null,"Total 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"}}]
["Entrez les détails dans le tableau Revendeurs, à partir de la cellule de droite. Le total mensuel relatif aux revendeurs apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q53. Le graphique sparkline est mis à jour dans la cellule S53. L’instruction suivante figure dans la cellule A54.","Revendeurs","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"REVENDEURS (% DES VENTES TOTALES)",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,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Formation",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('Budget des canaux marketing'!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Promotions",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('Budget des canaux marketing'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Commission/Remises (% des ventes au détail)",{"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('Budget des canaux marketing'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Total revendeurs - (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"}}]
["Entrez les détails dans le tableau Acquisition et fidélisation de clients, à partir de la cellule de droite. Le total mensuel relatif à l’acquisition et à la fidélisation de clients apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q59. Le graphique sparkline est mis à jour dans la cellule S59. L’instruction suivante figure dans la cellule A60.","Acquisition et fidélisation de clients","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"ACQUISITION ET FIDÉLISATION DE CLIENTS"]
[null,"Ressources humaines",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budget des canaux marketing'!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Communications",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('Budget des canaux marketing'!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions/Bons",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Budget des canaux marketing'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total acquisition et fidélisation de clients - (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"}}]
["Entrez les détails dans le tableau Autres dépenses, à partir de la cellule de droite. Le total mensuel des autres dépenses apparaît automatiquement à la fin de tableau, et le total annuel dans la cellule Q65. Le graphique sparkline est mis à jour dans la cellule S65. L’instruction suivante figure dans la cellule A67.","Autres dépenses ","Taux","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12"]
[null,"AUTRES DÉPENSES"]
[null,"Déplacements",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Budget des canaux marketing'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastructure (ordinateur, téléphone, etc.)",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('Budget des canaux marketing'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Prise en charge des canaux",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Budget des canaux marketing'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total autres dépenses - (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"}}]
[]
["Le total mensuel du budget marketing apparaît automatiquement sur cette ligne, dans les cellules D67 à O67, et le total annuel dans la cellule Q67. Le graphique sparkline est mis à jour dans la cellule S67.","TOTAL DU BUDGET MARKETING :",null,{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 1]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 1]],Revendeurs[[#Totals],[Mois 1]],Distributeurs[[#Totals],[Mois 1]],Agents_et_courtiers[[#Totals],[Mois 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 2]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 2]],Revendeurs[[#Totals],[Mois 2]],Distributeurs[[#Totals],[Mois 2]],Agents_et_courtiers[[#Totals],[Mois 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 3]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 3]],Revendeurs[[#Totals],[Mois 3]],Distributeurs[[#Totals],[Mois 3]],Agents_et_courtiers[[#Totals],[Mois 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 4]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 4]],Revendeurs[[#Totals],[Mois 4]],Distributeurs[[#Totals],[Mois 4]],Agents_et_courtiers[[#Totals],[Mois 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 5]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 5]],Revendeurs[[#Totals],[Mois 5]],Distributeurs[[#Totals],[Mois 5]],Agents_et_courtiers[[#Totals],[Mois 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 6]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 6]],Revendeurs[[#Totals],[Mois 6]],Distributeurs[[#Totals],[Mois 6]],Agents_et_courtiers[[#Totals],[Mois 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 7]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 7]],Revendeurs[[#Totals],[Mois 7]],Distributeurs[[#Totals],[Mois 7]],Agents_et_courtiers[[#Totals],[Mois 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 8]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 8]],Revendeurs[[#Totals],[Mois 8]],Distributeurs[[#Totals],[Mois 8]],Agents_et_courtiers[[#Totals],[Mois 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 9]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 9]],Revendeurs[[#Totals],[Mois 9]],Distributeurs[[#Totals],[Mois 9]],Agents_et_courtiers[[#Totals],[Mois 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 10]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 10]],Revendeurs[[#Totals],[Mois 10]],Distributeurs[[#Totals],[Mois 10]],Agents_et_courtiers[[#Totals],[Mois 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 11]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 11]],Revendeurs[[#Totals],[Mois 11]],Distributeurs[[#Totals],[Mois 11]],Agents_et_courtiers[[#Totals],[Mois 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(Autres_dépenses[[#Totals],[Mois 12]],Acquisition_et_fidélisation_de_clients[[#Totals],[Mois 12]],Revendeurs[[#Totals],[Mois 12]],Distributeurs[[#Totals],[Mois 12]],Agents_et_courtiers[[#Totals],[Mois 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]