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

{"sheet":"Anfang","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ÜBER DIESE VORLAGE"]
[null,"Verwenden Sie diese Vorlage zum Erstellen eines Marketingbudget Nach Vertriebskanal."]
[null,"Geben Sie erwartete Umsätze für jeden Monat und weitere Details in den Tabellen ein."]
[null,"Summen werden automatisch berechnet und Sparklines aktualisiert."]
[null,"Anmerkung: "]
[null,"Zusätzliche Anweisungen wurden in Spalte A auf dem Arbeitsblatt MARKETINGBUDGET NACH VERTRIEBSKANAL bereitgestellt. Diese Texte wurden absichtlich ausgeblendet. Um die Texte zu entfernen, wählen Sie Spalte A und dann ENTF aus. Um die Texte einzublenden, wählen Sie Spalte A aus, und ändern Sie die Schriftfarbe."]
[null,"Um mehr über Tabellen zu erfahren, drücken Sie die UMSCHALTTASTE und dann F10 innerhalb einer Tabelle, und wählen Sie die Option TABELLE und dann ALTERNATIVTEXT aus."]

{"sheet":"Marketingbudget Vertriebskanal","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Erstellen Sie auf diesem Arbeitsblatt ein Marketingbudget nach Vertriebskanal. Der Titel dieses Arbeitsblatts befindet sich in der Zelle rechts. Nützliche Anweisungen befinden sich in Zellen in dieser Spalte. Drücken Sie die NACH-UNTEN-TASTE, um anzufangen. Der Titel dieses Arbeitsblatts befindet sich in der Zelle rechts.","MARKETINGBUDGET NACH VERTRIEBSKANAL"]
["Die Beschriftungen für den Satz und die Monate befinden sich in dieser Zeile in den Zellen C2 bis O2, und die Beschriftung \"Ergebnis\" befindet sich in Zelle Q2."," ","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12",null,"Ergebnis"]
["Die Beschriftung \"Ergebnis erwarteter Umsätze\" befindet sich in der Zelle rechts. Geben Sie in den Zellen D3 bis O3 erwartete Umsätze für jeden Monat ein. Die Ergebnis wird in Zelle Q3 automatisch berechnet.","Ergebnis ERWARTETER UMSÄTZE (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"}}]
["Geben Sie Details in der Tabelle \"Personal\" ein, die in der Zelle rechts beginnt. Die Summe Personal für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q9 automatisch berechnet. Die Sparkline wird in Zelle S9 aktualisiert. Die nächste Anweisung finden Sie in Zelle A10.","Personalposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"PERSONAL (% DES GESAMTUMSATZES)",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,"Personal – Mitarbeiterzahl",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Personal – 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('Marketingbudget Vertriebskanal'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Provision",{"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('Marketingbudget Vertriebskanal'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Summe Personal (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}]
["Geben Sie Details in der Tabelle \"Direktmarketing\" ein, die in der Zelle rechts beginnt. Die Summe Telemarketing für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q17 automatisch berechnet. Sparkline wird in Zelle S17 aktualisiert. Die nächste Anweisung finden Sie in Zelle A18.","Direktmarketingposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"DIREKTMARKETING (% DES GESAMTUMSATZES)",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 (% des Direktvertriebs)",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,"Personal – Mitarbeiterzahl",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('Marketingbudget Vertriebskanal'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Infrastrukturunterstützung",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Provision",{"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('Marketingbudget Vertriebskanal'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Schulung",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Summe 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"}}]
["Geben Sie Details in der Tabelle \"Internetmarketing\" ein, die in der Zelle rechts beginnt. Die Summe Internetmarketing für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q24 automatisch berechnet. Die Sparkline wird in Zelle S24 aktualisiert. Die nächste Anweisung finden Sie in Zelle A25.","Internetmarketingposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"Internetmarketing (% des Direktvertriebs)",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,"Personal – Mitarbeiterzahl",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('Marketingbudget Vertriebskanal'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Websiteentwicklung (einmalige Kosten)",null,500,{"$nulls":12},{"$f":"SUM('Marketingbudget Vertriebskanal'!$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('Marketingbudget Vertriebskanal'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Support und Wartung",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Summe 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"}}]
["Geben Sie Details in der Tabelle \"Direktwerbung\" ein, die in der Zelle rechts beginnt. Die Summe Direktwerbung für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q30 automatisch berechnet. Die nächste Anweisung finden Sie in Zelle A31."," Direktwerbungsposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"Direktwerbung (% des Direktvertriebs)"]
[null,"Personal – Kosten",{"$nulls":14},{"$f":"SUM('Marketingbudget Vertriebskanal'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Material",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Porto",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Summe Direktwerbung (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"}}]
["Die Summe Direktmarketing wird in dieser Zeile in den Zellen D31 bis O31 und die jährliche Summe in Zelle Q31 automatisch berechnet. Die Sparkline wird in Zelle S31 aktualisiert.","Summe Direktmarketing (000) €",null,{"$f":"SUM(Direktwerbung[[#Totals],[Monat 1]],Internetmarketing[[#Totals],[Monat 1]],Direktmarketing[[#Totals],[Monat 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 2]],Internetmarketing[[#Totals],[Monat 2]],Direktmarketing[[#Totals],[Monat 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 3]],Internetmarketing[[#Totals],[Monat 3]],Direktmarketing[[#Totals],[Monat 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 4]],Internetmarketing[[#Totals],[Monat 4]],Direktmarketing[[#Totals],[Monat 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 5]],Internetmarketing[[#Totals],[Monat 5]],Direktmarketing[[#Totals],[Monat 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 6]],Internetmarketing[[#Totals],[Monat 6]],Direktmarketing[[#Totals],[Monat 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 7]],Internetmarketing[[#Totals],[Monat 7]],Direktmarketing[[#Totals],[Monat 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 8]],Internetmarketing[[#Totals],[Monat 8]],Direktmarketing[[#Totals],[Monat 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 9]],Internetmarketing[[#Totals],[Monat 9]],Direktmarketing[[#Totals],[Monat 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 10]],Internetmarketing[[#Totals],[Monat 10]],Direktmarketing[[#Totals],[Monat 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 11]],Internetmarketing[[#Totals],[Monat 11]],Direktmarketing[[#Totals],[Monat 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 12]],Internetmarketing[[#Totals],[Monat 12]],Direktmarketing[[#Totals],[Monat 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Geben Sie Details in der Tabelle \"Agent und Makler\" ein, die in der Zelle rechts beginnt. Die Summe Agent und Makler für jeden Monat wird am Tabellenende und die jährliche Summe in Zelle Q39 automatisch berechnet. Die Sparkline wird in Zelle S39 aktualisiert. Die nächste Anweisung finden Sie in Zelle A40.","Agent-/Maklerposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"AGENT/MAKLER (% DES GESAMTUMSATZES)",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,"Kommunikation",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Schulung",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('Marketingbudget Vertriebskanal'!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Werbeaktionen",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('Marketingbudget Vertriebskanal'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Rabatte",{"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('Marketingbudget Vertriebskanal'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Provision (% des Agent-/Maklerumsatzes)",{"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('Marketingbudget Vertriebskanal'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Summe Agent/Makler (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"}}]
["Geben Sie Details in der Tabelle \"Verteiler\" ein, die in der Zelle rechts beginnt. Die Summe Verteiler für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q46 automatisch berechnet. Die Sparkline wird in Zelle S46 aktualisiert. Die nächste Anweisung finden Sie in Zelle A47.","Verteilerposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"VERTEILER (% DES GESAMTUMSATZES)",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,"Kommunikation",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Schulung",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(Verteiler[[#This Row],[Monat 1]:[Monat 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Werbeaktionen",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(Verteiler[[#This Row],[Monat 1]:[Monat 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Provision/Rabatte (% des Verteilerumsatzes)",{"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(Verteiler[[#This Row],[Monat 1]:[Monat 12]])","v":666.75}]
[null,"Summe Verteiler (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"}}]
["Geben Sie Details in der Tabelle \"Einzelhändler\" ein, die in der Zelle rechts beginnt. Die Summe Einzelhändler für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q53 automatisch berechnet. Die Sparkline wird in Zelle S53 aktualisiert. Die nächste Anweisung finden Sie in Zelle A54.","Einzelhändlerposten","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"EINZELHÄNDLER (% DES GESAMTUMSATZES)",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,"Kommunikation",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Schulung",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('Marketingbudget Vertriebskanal'!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Werbeaktionen",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('Marketingbudget Vertriebskanal'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Provision/Rabatte (% des Einzelhändlerumsatzes)",{"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('Marketingbudget Vertriebskanal'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Summe Einzelhändler (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"}}]
["Geben Sie Details in der Tabelle \"Kundengewinnung und -bindung\" ein, die in der Zelle rechts beginnt. Die Summe Kundengewinnung und -bindung für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q59 automatisch berechnet. Die Sparkline wird in Zelle S59 aktualisiert. Die nächste Anweisung finden Sie in Zelle A60.","Posten für Kundengewinnung und -bindung","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"KUNDENGEWINNUNG UND -BINDUNG"]
[null,"Personal",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Kommunikation",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('Marketingbudget Vertriebskanal'!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Werbeaktionen/Gutscheine",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Summe Kundengewinnung und -bindung (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"}}]
["Geben Sie Details in der Tabelle \"Sonstige Ausgaben\" ein, die in der Zelle rechts beginnt. Die Summe sonstige Ausgaben für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q65 automatisch berechnet. Die Sparkline wird in Zelle S65 aktualisiert. Die nächste Anweisung finden Sie in Zelle A67.","Sonstige Ausgabenposten ","Satz","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12"]
[null,"SONSTIGE AUSGABEN"]
[null,"Reise",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastruktur (Computer, Telefon usw.)",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('Marketingbudget Vertriebskanal'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Kanalunterstützung",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Summe sonstige Ausgaben (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"}}]
[]
["Das Marketing-Gesamtbudget für jeden Monat wird in dieser Zeile in den Zellen D67 bis O67 und die jährliche Summe in Zelle Q67 automatisch berechnet. Die Sparkline wird in Zelle S67 automatisch aktualisiert.","MARKETING-GESAMTBUDGET:",null,{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 1]],KundengewinnungUndBindung[[#Totals],[Monat 1]],Einzelhändler[[#Totals],[Monat 1]],Verteiler[[#Totals],[Monat 1]],AgentUndMakler[[#Totals],[Monat 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 2]],KundengewinnungUndBindung[[#Totals],[Monat 2]],Einzelhändler[[#Totals],[Monat 2]],Verteiler[[#Totals],[Monat 2]],AgentUndMakler[[#Totals],[Monat 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 3]],KundengewinnungUndBindung[[#Totals],[Monat 3]],Einzelhändler[[#Totals],[Monat 3]],Verteiler[[#Totals],[Monat 3]],AgentUndMakler[[#Totals],[Monat 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 4]],KundengewinnungUndBindung[[#Totals],[Monat 4]],Einzelhändler[[#Totals],[Monat 4]],Verteiler[[#Totals],[Monat 4]],AgentUndMakler[[#Totals],[Monat 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 5]],KundengewinnungUndBindung[[#Totals],[Monat 5]],Einzelhändler[[#Totals],[Monat 5]],Verteiler[[#Totals],[Monat 5]],AgentUndMakler[[#Totals],[Monat 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 6]],KundengewinnungUndBindung[[#Totals],[Monat 6]],Einzelhändler[[#Totals],[Monat 6]],Verteiler[[#Totals],[Monat 6]],AgentUndMakler[[#Totals],[Monat 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 7]],KundengewinnungUndBindung[[#Totals],[Monat 7]],Einzelhändler[[#Totals],[Monat 7]],Verteiler[[#Totals],[Monat 7]],AgentUndMakler[[#Totals],[Monat 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 8]],KundengewinnungUndBindung[[#Totals],[Monat 8]],Einzelhändler[[#Totals],[Monat 8]],Verteiler[[#Totals],[Monat 8]],AgentUndMakler[[#Totals],[Monat 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 9]],KundengewinnungUndBindung[[#Totals],[Monat 9]],Einzelhändler[[#Totals],[Monat 9]],Verteiler[[#Totals],[Monat 9]],AgentUndMakler[[#Totals],[Monat 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 10]],KundengewinnungUndBindung[[#Totals],[Monat 10]],Einzelhändler[[#Totals],[Monat 10]],Verteiler[[#Totals],[Monat 10]],AgentUndMakler[[#Totals],[Monat 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 11]],KundengewinnungUndBindung[[#Totals],[Monat 11]],Einzelhändler[[#Totals],[Monat 11]],Verteiler[[#Totals],[Monat 11]],AgentUndMakler[[#Totals],[Monat 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 12]],KundengewinnungUndBindung[[#Totals],[Monat 12]],Einzelhändler[[#Totals],[Monat 12]],Verteiler[[#Totals],[Monat 12]],AgentUndMakler[[#Totals],[Monat 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]