{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anfang","Marketingbudget Vertriebskanal"],"not_rendered":{"images":1,"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 Vertriebskanal."]
[null,"Geben Sie erwartete Umsätze für jeden Monat und weitere Details in die Tabellen ein."]
[null,"Summen werden automatisch berechnet und Sparklines aktualisiert."]
[null,"Anmerkung: "]
[null,"Zusätzliche Anweisungen wurden in Spalte A auf dem Arbeitsblatt MARKETINGBUDGET 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":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]]}
["Erstellen Sie auf diesem Arbeitsblatt ein Marketingbudget 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."]
["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 \"Summe 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 Summe wird in Zelle Q3 automatisch berechnet.","SUMME 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 für das 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+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,"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 Ergebnis für das 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 die Tabelle \"Internetmarketing\" ein, die in der Zelle rechts beginnt. Die Summe für das Internetmarketing für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q27 automatisch berechnet. Die Sparkline wird in Zelle S27 aktualisiert. Die nächste Anweisung finden Sie in Zelle A28.","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,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('Marketingbudget Vertriebskanal'!$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('Marketingbudget Vertriebskanal'!$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('Marketingbudget Vertriebskanal'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Summe 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"}}]
["Geben Sie Details in die Tabelle \"Direktwerbung\" ein, die in der Zelle rechts beginnt. Die Summe für die Direktwerbung für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q34 automatisch berechnet. Die nächste Anweisung finden Sie in Zelle A35.","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'!$D30:$O30)","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'!$D31:$O31)","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'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Summe Direktwerbung (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"}}]
["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":1939,"d":"1,939.00"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 2]],Internetmarketing[[#Totals],[Monat 2]],Direktmarketing[[#Totals],[Monat 2]])","v":{"v":1481.85,"d":"1,481.85"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 3]],Internetmarketing[[#Totals],[Monat 3]],Direktmarketing[[#Totals],[Monat 3]])","v":{"v":1411.9375,"d":"1,411.94"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 4]],Internetmarketing[[#Totals],[Monat 4]],Direktmarketing[[#Totals],[Monat 4]])","v":{"v":1482.05,"d":"1,482.05"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 5]],Internetmarketing[[#Totals],[Monat 5]],Direktmarketing[[#Totals],[Monat 5]])","v":{"v":1511.948,"d":"1,511.95"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 6]],Internetmarketing[[#Totals],[Monat 6]],Direktmarketing[[#Totals],[Monat 6]])","v":{"v":1381.9375,"d":"1,381.94"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 7]],Internetmarketing[[#Totals],[Monat 7]],Direktmarketing[[#Totals],[Monat 7]])","v":{"v":1411.9,"d":"1,411.90"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 8]],Internetmarketing[[#Totals],[Monat 8]],Direktmarketing[[#Totals],[Monat 8]])","v":{"v":1381.84,"d":"1,381.84"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 9]],Internetmarketing[[#Totals],[Monat 9]],Direktmarketing[[#Totals],[Monat 9]])","v":{"v":1511.8,"d":"1,511.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 10]],Internetmarketing[[#Totals],[Monat 10]],Direktmarketing[[#Totals],[Monat 10]])","v":{"v":1481.8,"d":"1,481.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 11]],Internetmarketing[[#Totals],[Monat 11]],Direktmarketing[[#Totals],[Monat 11]])","v":{"v":1436.8,"d":"1,436.80"}},{"$f":"SUM(Direktwerbung[[#Totals],[Monat 12]],Internetmarketing[[#Totals],[Monat 12]],Direktmarketing[[#Totals],[Monat 12]])","v":{"v":1481.8,"d":"1,481.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":18231.613,"d":"18,231.61"}}]
["Geben Sie Details in die Tabelle \"Agenten und Makler\" ein, die in der Zelle rechts beginnt. Die Summe für Agenten und Makler für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q42 automatisch berechnet. Die Sparkline wird in Zelle S42 aktualisiert. Die nächste Anweisung finden Sie in Zelle A43.","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'!$D37:$O37)","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'!$D38:$O38)","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'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Rabatte",{"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('Marketingbudget Vertriebskanal'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Provision (% des Agent-/Maklerumsatzes)",{"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('Marketingbudget Vertriebskanal'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Summe Agent/Makler (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"}}]
["Geben Sie Details in die Tabelle \"Verteiler\" ein, die in der Zelle rechts beginnt. Die Ergebnis für Verteiler für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q49 automatisch berechnet. Die Sparkline wird in Zelle S49 aktualisiert. Die nächste Anweisung finden Sie in Zelle A50.","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'!$D45:$O45)","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*D44*$C$48","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(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"}}]
["Geben Sie Details in die Tabelle \"Einzelhändler\" ein, die in der Zelle rechts beginnt. Die Summe für Einzelhändler für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q56 automatisch berechnet. Die Sparkline wird in Zelle S56 aktualisiert. Die nächste Anweisung finden Sie in Zelle A57.","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'!$D52:$O52)","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'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Provision/Rabatte (% des Einzelhändlerumsatzes)",{"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('Marketingbudget Vertriebskanal'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Summe Einzelhändler (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"}}]
["Geben Sie Details in die Tabelle \"Kundengewinnung und -bindung\" ein, die in der Zelle rechts beginnt. Die Summe für Kundengewinnung und -bindung für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q62 automatisch berechnet. Die Sparkline wird in Zelle S62 aktualisiert. Die nächste Anweisung finden Sie in Zelle A63.","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'!$D59:$O59)","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'!$D60:$O60)","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'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Summe Kundengewinnung und -bindung (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"}}]
["Geben Sie Details in die Tabelle \"Sonstige Ausgaben\" ein, die in der Zelle rechts beginnt. Die Summe für sonstige Ausgaben für jeden Monat wird am Tabellenende und die jährliche Ergebnis in Zelle Q68 automatisch berechnet. Die Sparkline wird in Zelle S68 aktualisiert. Die nächste Anweisung finden Sie in Zelle A70.","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'!$D65:$O65)","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'!$D66:$O66)","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'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Summe sonstige Ausgaben (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"}}]
[]
["Das Marketing-Gesamtbudget für jeden Monat wird in dieser Zeile in den Zellen D70 bis O70 und die jährliche Summe in Zelle Q70 automatisch berechnet. Die Sparkline wird in Zelle S70 automatisch aktualisiert.","MARKETING-GESAMTBUDGET:",null,{"$f":"SUM(D34,AgentenUndMakler[[#Totals],[Monat 1]],Verteiler[[#Totals],[Monat 1]],Einzelhändler[[#Totals],[Monat 1]],KundengewinnungUndBindung[[#Totals],[Monat 1]],SonstigeAusgaben[[#Totals],[Monat 1]])","v":{"v":6454,"d":"6,454.00"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 2]],KundengewinnungUndBindung[[#Totals],[Monat 2]],Einzelhändler[[#Totals],[Monat 2]],Verteiler[[#Totals],[Monat 2]],AgentenUndMakler[[#Totals],[Monat 2]],E34)","v":{"v":5985.85,"d":"5,985.85"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 3]],KundengewinnungUndBindung[[#Totals],[Monat 3]],Einzelhändler[[#Totals],[Monat 3]],Verteiler[[#Totals],[Monat 3]],AgentenUndMakler[[#Totals],[Monat 3]],F34)","v":{"v":5934.4375,"d":"5,934.44"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 4]],KundengewinnungUndBindung[[#Totals],[Monat 4]],Einzelhändler[[#Totals],[Monat 4]],Verteiler[[#Totals],[Monat 4]],AgentenUndMakler[[#Totals],[Monat 4]],G34)","v":{"v":6102.05,"d":"6,102.05"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 5]],KundengewinnungUndBindung[[#Totals],[Monat 5]],Einzelhändler[[#Totals],[Monat 5]],Verteiler[[#Totals],[Monat 5]],AgentenUndMakler[[#Totals],[Monat 5]],H34)","v":{"v":6116.348,"d":"6,116.35"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 6]],KundengewinnungUndBindung[[#Totals],[Monat 6]],Einzelhändler[[#Totals],[Monat 6]],Verteiler[[#Totals],[Monat 6]],AgentenUndMakler[[#Totals],[Monat 6]],I34)","v":{"v":6035.6875,"d":"6,035.69"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 7]],KundengewinnungUndBindung[[#Totals],[Monat 7]],Einzelhändler[[#Totals],[Monat 7]],Verteiler[[#Totals],[Monat 7]],AgentenUndMakler[[#Totals],[Monat 7]],J34)","v":{"v":6076.9,"d":"6,076.90"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 8]],KundengewinnungUndBindung[[#Totals],[Monat 8]],Einzelhändler[[#Totals],[Monat 8]],Verteiler[[#Totals],[Monat 8]],AgentenUndMakler[[#Totals],[Monat 8]],K34)","v":{"v":6115.84,"d":"6,115.84"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 9]],KundengewinnungUndBindung[[#Totals],[Monat 9]],Einzelhändler[[#Totals],[Monat 9]],Verteiler[[#Totals],[Monat 9]],AgentenUndMakler[[#Totals],[Monat 9]],L34)","v":{"v":6231.8,"d":"6,231.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 10]],KundengewinnungUndBindung[[#Totals],[Monat 10]],Einzelhändler[[#Totals],[Monat 10]],Verteiler[[#Totals],[Monat 10]],AgentenUndMakler[[#Totals],[Monat 10]],M34)","v":{"v":6201.8,"d":"6,201.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 11]],KundengewinnungUndBindung[[#Totals],[Monat 11]],Einzelhändler[[#Totals],[Monat 11]],Verteiler[[#Totals],[Monat 11]],AgentenUndMakler[[#Totals],[Monat 11]],N34)","v":{"v":6156.8,"d":"6,156.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 12]],KundengewinnungUndBindung[[#Totals],[Monat 12]],Einzelhändler[[#Totals],[Monat 12]],Verteiler[[#Totals],[Monat 12]],AgentenUndMakler[[#Totals],[Monat 12]],O34)","v":{"v":6201.8,"d":"6,201.80"}},null,{"$f":"SUM(D70:O70)","v":{"v":73613.31300000001,"d":"73,613.31"}}]