{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anfang","Marketingbudget nach vertriebsk"],"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 Marketingbudgets nach 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 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, wählen Sie die Option TABELLE und dann ALTERNATIVTEXT aus."]

{"sheet":"Marketingbudget nach vertriebsk","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],[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]]}
["Erstellen Sie das Kanalmarketingbudget in diesem Arbeitsblatt. Der Titel dieses Arbeitsblatts befindet sich in der Zelle rechts. Hilfreiche Anweisungen befinden sich in Zellen in dieser Spalte. Pfeil nach unten, um zu beginnen. Der Titel dieses Arbeitsblatts befindet sich in der Zelle rechts."]
[null," ","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"]
[null,"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 die Tabelle „Personal“ ein, beginnend in der Zelle rechts. Die Summe für das Personal für jeden Monat wird am Tabellenende und die jährliche Summe in Zelle Q9 automatisch berechnet. Die Sparkline wird in Zelle S9 aktualisiert. Die nächste Anweisung befindet sich 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 nach vertriebsk'!$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"},{"$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('Marketingbudget nach vertriebsk'!$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 „Direct Marketing“ ein, beginnend in der Zelle rechts. „Telemarketing gesamt“ für jeden Monat wird automatisch am Tabellenende und „Jährlich Gesamt“ in Zelle Q17 berechnet. Sparkline wird in Zelle S17 aktualisiert. Die nächste Anweisung befindet sich 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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 die Details in die Tabelle „Internetmarketing“ ein, beginnend in der Zelle auf der rechten Seite. „Internetmarketing Gesamt“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q27. Die Sparkline wird in Zelle S27 aktualisiert. Die nächste Anweisung steht 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 nach vertriebsk'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Websiteentwicklung (einmalige Kosten)",null,500,{"$nulls":12},{"$f":"SUM('Marketingbudget nach vertriebsk'!$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 nach vertriebsk'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Support und Wartung",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Marketingbudget nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Summe Internetmarketing (000) €",null,{"$f":"SUM(D20:D23)","v":535.25},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 die Details in die Tabelle „Direct Mail“ ein, beginnend in der Zelle auf der rechten Seite. „Direct Mail Gesamt“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q34. Die nächste Anweisung steht in Zelle A34.","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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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"}}]
[null,"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(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Geben Sie Details in die Tabelle „Agent und Makler“ ein, beginnend in der Zelle auf der rechten Seite. „Agent und Makler Gesamt“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q42. Die Sparkline wird in Zelle S42 aktualisiert. Die nächste Anweisung steht 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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 „Vertriebspartner“ ein, beginnend in der Zelle rechts. „Summe Vertriebspartner“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q49. Die Sparkline wird in Zelle S49 aktualisiert. Die nächste Anweisung steht 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 nach vertriebsk'!$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(Händler[[#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(Händler[[#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(Händler[[#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 der Tabelle „Einzelhändler“ ein, beginnend in der Zelle rechts. „Summe Einzelhändler“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q56. Die Sparkline wird in Zelle S56 aktualisiert. Die nächste Anweisung steht 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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 der Tabelle „Kundenakquise und -bindung“ ein, beginnend in der Zelle auf der rechten Seite. „Summe CAR“ für jeden Monat wird automatisch am Tabellenende berechnet und „Jährlich Gesamt“ in Zelle Q62. Die Sparkline wird in Zelle S62 aktualisiert. Die nächste Anweisung steht 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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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 „Andere Ausgaben“ ein, beginnend in der Zelle rechts. „Sonstige Ausgaben gesamt“ für jeden Monat wird automatisch am Tabellenende und „Jährlich Gesamt“ in Zelle Q68 berechnet. Sparkline wird in Zelle S68 aktualisiert. Die nächste Anweisung befindet sich 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 nach vertriebsk'!$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 nach vertriebsk'!$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 nach vertriebsk'!$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"}}]
[]
[null,"MARKETING-GESAMTBUDGET:",null,{"$f":"SUM(D34,AgentUndMakler[[#Totals],[Monat 1]],Händler[[#Totals],[Monat 1]],Einzelhändler[[#Totals],[Monat 1]],AUTO[[#Totals],[Monat 1]],SonstigeAusgaben[[#Totals],[Monat 1]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 2]],AUTO[[#Totals],[Monat 2]],Einzelhändler[[#Totals],[Monat 2]],Händler[[#Totals],[Monat 2]],AgentUndMakler[[#Totals],[Monat 2]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 3]],AUTO[[#Totals],[Monat 3]],Einzelhändler[[#Totals],[Monat 3]],Händler[[#Totals],[Monat 3]],AgentUndMakler[[#Totals],[Monat 3]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 4]],AUTO[[#Totals],[Monat 4]],Einzelhändler[[#Totals],[Monat 4]],Händler[[#Totals],[Monat 4]],AgentUndMakler[[#Totals],[Monat 4]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 5]],AUTO[[#Totals],[Monat 5]],Einzelhändler[[#Totals],[Monat 5]],Händler[[#Totals],[Monat 5]],AgentUndMakler[[#Totals],[Monat 5]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 6]],AUTO[[#Totals],[Monat 6]],Einzelhändler[[#Totals],[Monat 6]],Händler[[#Totals],[Monat 6]],AgentUndMakler[[#Totals],[Monat 6]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 7]],AUTO[[#Totals],[Monat 7]],Einzelhändler[[#Totals],[Monat 7]],Händler[[#Totals],[Monat 7]],AgentUndMakler[[#Totals],[Monat 7]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 8]],AUTO[[#Totals],[Monat 8]],Einzelhändler[[#Totals],[Monat 8]],Händler[[#Totals],[Monat 8]],AgentUndMakler[[#Totals],[Monat 8]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 9]],AUTO[[#Totals],[Monat 9]],Einzelhändler[[#Totals],[Monat 9]],Händler[[#Totals],[Monat 9]],AgentUndMakler[[#Totals],[Monat 9]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 10]],AUTO[[#Totals],[Monat 10]],Einzelhändler[[#Totals],[Monat 10]],Händler[[#Totals],[Monat 10]],AgentUndMakler[[#Totals],[Monat 10]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 11]],AUTO[[#Totals],[Monat 11]],Einzelhändler[[#Totals],[Monat 11]],Händler[[#Totals],[Monat 11]],AgentUndMakler[[#Totals],[Monat 11]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(SonstigeAusgaben[[#Totals],[Monat 12]],AUTO[[#Totals],[Monat 12]],Einzelhändler[[#Totals],[Monat 12]],Händler[[#Totals],[Monat 12]],AgentUndMakler[[#Totals],[Monat 12]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]