{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Formularseite 1","Formularseite 2","Formularseite 3"],"not_rendered":{"external_links":1,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Formularseite 1","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"flags":["formulas_cached_only"]}
[]
[null,"Angebotskalkulation"]
[]
[]
[null,"Grunddaten",{"$nulls":6},"Bearbeiter:"]
[null,"Besteller:"]
[{"$nulls":8},"Telefon:"]
[{"$nulls":8},"Fax:"]
[{"$nulls":8},"Anfrage vom:"]
[null,"Objekt:",{"$nulls":6},"Angebot am:"]
[null,"Stückzahl:",{"$nulls":6},"Projektbeginn:"]
[null,"Umfang:",{"$nulls":6},"Projektende:"]
[{"$nulls":8},"Liefertermin:"]
[]
[]
[]
[null,"Zl.","Prozesse/Betriebsmittel",{"$nulls":5},"Kosten"]
[{"$nulls":8},"Euro"]
[]
[null,1,"Akquisitionsphase",{"$nulls":5},0]
[null,2,"Konzeptphase",{"$nulls":5},0]
[null,3,"Projekt-Management",{"$nulls":5},0]
[null,4,"Produktion",{"$nulls":5},0]
[null,5,"Testphase",{"$nulls":5},0]
[null,6,"Rechte/Lizenzen",{"$nulls":5},0]
[null,7,"Sa. Prozesskosten",{"$nulls":5},0]
[null,8,"Fremdleistungskosten",{"$nulls":5},0]
[null,9,"Sa. Prozess- und Fremdleistungskosten",{"$nulls":5},0]
[null,10,"Verwaltungskosten auf Zl. 9",null,null,"Euro",null,"%",0]
[null,11,"Materialkosten",{"$nulls":5},0]
[null,12,"Materialgemeinkostenzuschlag",null,null,"Euro",null,"%",0]
[null,13,"Sa. Herstellkosten",{"$nulls":5},0]
[null,14,"Vertriebskosten auf Zl. 9",null,null,"Euro",null,"%",0]
[null,15,"Sa. Selbstkosten",{"$nulls":5},0]
[null,16,"+ Gewinn % i. H.",{"$nulls":4},"%",0]
[null,17,"Zwischensumme",{"$nulls":5},0]
[null,18,"Provision % i. H.",{"$nulls":4},"%",0]
[null,19,"Versandkosten",{"$nulls":5},0]
[null,20,"Sonstige Vertriebseinzelkosten (Zl. 18 + 19)",{"$nulls":5},0]
[null,21,"Zwischensumme ",{"$nulls":5},0]
[null,22,"Erlösschmälerung % i. H.",{"$nulls":4},"%",0]
[null,23,"Zwischensumme",{"$nulls":5},0]
[null,24,"Gebühren: Rechte, Lizenzen % i. H.",{"$nulls":4},"%",0]
[null,25,"Kalkulierte Preisvorgabe",{"$nulls":5},0]
[]
[]
[null,"Ermittlung von Deckungsbeitrag und Nettoergebnis des Angebots in Euro"]
[null,"Auflage",{"$nulls":6},0]
[null,"Angebotspreisvorschlag",{"$nulls":6},0]
[null,"Bruttoverkaufspreis (realisierter Preis)",{"$nulls":6},0]
[null,"Gebühren: Rechte, Lizenzen ",{"$nulls":4},{"v":0,"d":"0.0"},"%",0]
[null,"Zwischensumme",{"$nulls":6},0]
[null,"Erlösschmälerung",{"$nulls":4},{"v":0,"d":"0.0"},"%",0]
[null,"Zwischensumme",{"$nulls":6},0]
[null,"Provisionen",{"$nulls":4},{"v":0,"d":"0.0"},"%",0]
[null,"Versandkosten",{"$nulls":6},0]
[null,"Verkaufsüberschuss",{"$nulls":6},0]
[null,"Fremdleistungskosten",{"$nulls":6},0]
[null,"Materialeinzelkosten",{"$nulls":6},0]
[null,"Produktionsüberschuss",{"$nulls":6},0]
[null,"Hauptprozesskosten",{"$nulls":6},0]
[null,"Deckungsbeitrag",{"$nulls":6},0]
[null,"Sa. Gemeinkostenzuschläge",{"$nulls":6},0]
[null,"Nettoergebnis des Auftrags/Angebots",{"$nulls":6},0]

{"sheet":"Formularseite 2","index":1,"n_rows":78,"n_cols":17,"rows_kept":78,"merged":[[1,4,1,13],[3,9,3,11]],"flags":["formulas_cached_only"]}
[]
[null,"Ermittlung der Primärkosten",null,"Objekt:","",{"$nulls":9},"Personalkosten:       Euro"]
[{"$nulls":14},"Kapitalkosten:          Euro"]
["Zl.","Hauptprozesse","Teilprozesse","Aktivitäten","Komplexitätsfaktorenprofil",null,null,"Menge","Einheit für","Komplexitätsfaktoren",null,null,"Sa.","Sa. ","Sa.","Pauschal-","Sa. "]
[{"$nulls":4},"I","II","III",null,"Pauschale","I","II","III","Std.","PK","KK","preis","GK"]
[1,"Akquisitionsphase","Konzeptvorschlag","Konzeptvorschlag",{"$nulls":4},"je Auftrag",{"v":1750,"d":"1,750"},{"v":3800,"d":"3,800"},{"v":6000,"d":"6,000"},"Euro"," "," ",0,0]
[2,"(Pauschalpreis)","grobe Kostenkalkulation","grobe Kostenkalkulation"]
[3,null,"Projektplan","Projektplan"]
[4,null,"Screendesign-Scribble","Screendesign-Scribble"]
[5,null,"Prototyperstellung","Prototyperstellung"]
[6,"Sa. Akquisitionsphase",{"$nulls":14},0]
[7,"Konzeptphase","Entwicklung Grobkonzept","Beratung Manager/Projektleiter",{"$nulls":5},1.1,2.1,2.8," ",0,null,null,0]
[8,null,"Definition Zulieferer/Contents","Abgrenzung wer liefert was?",{"$nulls":5},1.1,2.1,2.8," ",0,null,null,0]
[9,null,"Medienredaktion","Medienadäquate Contentaufbereitung",{"$nulls":5},0.8,1.4,2.1," ",0,null,null,0]
[10,null,"Marktanalyse","Primärforschung (Datenerhebung)",{"$nulls":5},0.7,{"v":1,"d":"1.0"},1.4," ",0,null,null,0]
[11,null,null,"Primärforschung (User convenience)",{"$nulls":5},0.7,1.2,1.6," ",0,null,null,0]
[12,null,null,"Sekundärforschung (vorhandene Daten)",{"$nulls":5},0.6,{"v":1,"d":"1.0"},1.4," ",0,null,null,0]
[13,null,"Storyboard","Drehbuch (Feinkonzeption)",{"$nulls":5},0.8,1.4,{"v":2,"d":"2.0"}," ",0,null,null,0]
[14,null,null,"Pädagogisch-didaktisches Konzept",{"$nulls":5},0.9,1.5,2.2," ",0,null,null,0]
[15,null,"Übergeordnete","Intro-/Extroerstellung",{"$nulls":5},0.9,1.5,1.9," ",0,null,null,0]
[16,null,"Programmfunktionen","Demo/Trailer erstellen",{"$nulls":5},0.3,0.5,0.6," ",0,0,null,0]
[17,null,null,"Helpfunktion",{"$nulls":5},0.9,1.5,1.9," ",0,null,null,0]
[18,null,"Marketingkonzept","Konzeption",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[19,null,null,"Umsetzungsplanung Marketing",{"$nulls":5},0.3,0.5,0.6," ",0,0,null,0]
[20,"Sa. Konzeptphase",{"$nulls":14},0]
[21,"Projekt-Management","Projektplanung","Pflichtenhefterstellung",{"$nulls":5},0.8,1.4,2.6," ",0,null,null,0]
[22,null,null,"Ablaufstrukturerstellung",{"$nulls":5},0.3,0.4,0.6," ",0,0,null,0]
[23,null,null,"Zeitpläne erstellen",{"$nulls":5},0.3,0.4,0.6," ",0,0,null,0]
[24,null,null,"Koordination Zulieferer",{"$nulls":5},0.8,1.4,{"v":2,"d":"2.0"}," ",0,null,null,0]
[25,null,null,"Projektmeetings",{"$nulls":5},0.8,1.4,{"v":2,"d":"2.0"}," ",0,null,null,0]
[26,null,"Zwischenpräsentation","Vorbereitung, Anreise, Technik",{"$nulls":5},0.8,1.4,2.1," ",0,null,null,0]
[27,null,"Projekt-Controlling","Monitoring Projektkosten",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[28,null,null,"Monitoring Zeitplan",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[29,null,null,"Abstimmung",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[30,"Sa. Projekt-Management",{"$nulls":14},0]
[31,"Produktion","Grafik/Animation","Bildredaktion",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[32,null,null,"Artredaktion",{"$nulls":5},0.8,1.5,2.1," ",0,0,null,0]
[33,null,null,"Bildbearbeitung digitaler Bilder",{"$nulls":5},0.2,0.3,0.4," ",0,0,null,0]
[34,null,null,"Bildbearbeitung mit Scan",{"$nulls":5},0.3,0.4,0.5," ",0,0,null,0]
[35,null,null,"Bildbearbeitung Grafik/Logo/Icon",{"$nulls":5},0.3,0.4,0.6," ",0,0,null,0]
[36,null,null,"2D-Animation",{"$nulls":5},0.3,0.4,0.6," ",0,0,null,0]
[37,null,null,"3D-Animation",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[38,null,null,"Effektenentwicklung",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[39,null,null,"Illustrationen",{"$nulls":5},0.2,0.3,0.4," ",0,0,null,0]
[40,null,null,"Funktionsdesign",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[41,null,null,"Rendering",{"$nulls":5},0.7,1.3,1.8," ",0,0,null,0]
[42,null,null,"Screendesign",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[43,null,"Text/Daten","Datenübernahme",{"$nulls":5},0.1,0.2,0.3," ",0,0,null,0]
[44,null,null,"Text scannen/Daten erfassen",{"$nulls":5},0.1,0.2,0.3," ",0,0,null,0]
[45,null,null,"Textkorrektur lesen",{"$nulls":5},0.2,0.3,0.4," ",0,0,null,0]
[46,null,null,"Textkorrektur ausführen",{"$nulls":5},0.2,0.3,0.4," ",0,0,null,0]
[47,null,null,"Texte aufbereiten/formatieren",{"$nulls":5},0.2,0.3,0.4," ",0,0,null,0]
[48,null,"Video","Videoproduktion (Aufnahme)",{"$nulls":5},0.8,1.3,2.3," ",0,0,null,0]
[49,null,null,"Einrichtung zur Codierung (pauschal)",{"$nulls":4},"je Sequenz",70,70,70,"Euro"," "," ",0,0]
[50,null,null,"Videodaten digitalisieren",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[51,null,null,"Videoschnitt (Resolution)",{"$nulls":5},0.3,0.5,0.6," ",0,0,null,0]
[52,null,null,"Videoschnitt (Broadcast)",{"$nulls":5},0.3,0.7,0.9," ",0,0,null,0]
[53,null,"Audio","Sprecher",{"$nulls":5},{"v":1,"d":"1.0"},1.4,1.7," ",0,0,null,0]
[54,null,null,"Audioproduktion/Vertonung",{"$nulls":5},0.3,0.5,0.6," ",0,0,null,0]
[55,null,null,"Audiodaten digitalisieren",{"$nulls":5},0.2,0.4,0.5," ",0,0,null,0]
[56,null,"Kompression Audio/Video","MPEG1-Kompression",{"$nulls":4},"je Min.",32,32,32,"Euro"," "," ",0,0]
[57,null,"(pauschal)","AVI-/Quicktime-Kompression",{"$nulls":4},"je Min.",32,32,32,"Euro"," "," ",0,0]
[58,null,"Programmierung","Datenbankprogrammierung",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[59,null,null,"HTML/XML-Programmierung",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[60,null,null,"Programmierung Autorensystem",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[61,null,null,"Programmierung Progr.sprachen",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[62,null,null,"Programmierung Kommunikation",{"$nulls":5},0.3,0.5,0.7," ",0,0,null,0]
[63,null,null,"Anbindung an Datenbank",{"$nulls":5},0.2,0.4,0.6," ",0,0,null,0]
[64,"Sa. Produktion",{"$nulls":14},0]
[65,"Testphase","Usability","Usability",{"$nulls":5},0.5,1.4,2.8," ",0,0,null,0]
[66,null,"Betatesting","Inhouse-Testing",{"$nulls":5},0.4,{"v":1,"d":"1.0"},{"v":2,"d":"2.0"}," ",0,0,null,0]
[67,null,null,"Feldtests (pauschal)",{"$nulls":4},"je Test",{"v":2400,"d":"2,400"},{"v":4900,"d":"4,900"},{"v":8200,"d":"8,200"},"Euro"," "," ",0,0]
[68,null,null,"Einarbeitung der Testergebnisse",{"$nulls":5},0.4,{"v":1,"d":"1.0"},{"v":2,"d":"2.0"}," ",0,0,null,0]
[69,"Sa. Testphase",{"$nulls":14},0]
[70,"Gebühren: Rechte, Lizenzen",{"$nulls":6},"je Einheit",0,0,0,"Euro"," "," ",0,0]
[71,"(Pauschalpreis)",{"$nulls":6},"je Einheit",0,0,0,"Euro"," "," ",0,0]
[72,{"$nulls":7},"je Einheit",0,0,0,"Euro"," "," ",0,0]
[73,"Sa. Gebühren: Rechte, Lizenzen",{"$nulls":14},0]

{"sheet":"Formularseite 3","index":2,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[1,7,1,12],[3,2,3,4],[3,6,3,7],[3,8,3,9],[3,10,3,11],[22,2,22,4],[22,6,22,7],[22,8,22,9],[22,10,22,11]],"flags":["formulas_cached_only"]}
[]
[null,"Ermittlung der Fremdleistungs- und Materialkosten",{"$nulls":4},"Objekt:",""]
[]
["Zl.","Fremdleistungskosten","Gewählte Auflagenhöhe",null,null,"Mengeneinheit","Kosten bei Auflagenhöhe I",null,"Kosten bei Auflagenhöhe II",null,"Kosten bei Auflagenhöhe III",null,"Kosten "]
[null,null,"I","II","III","(pro Stück, pro 1.000, usw.)","Menge","Kosten je Einheit","Menge","Kosten je Einheit","Menge","Kosten je Einheit","gesamt"]
[1,null,"x",null,null,1,{"$nulls":6},0]
[2,null,"x",null,null,1,{"$nulls":6},0]
[3,null,"x",null,null,1,{"$nulls":6},0]
[4,null,"x",null,null,1,{"$nulls":6},0]
[5,null,"x",null,null,1,{"$nulls":6},0]
[6,null,"x",null,null,1,{"$nulls":6},0]
[7,null,"x",null,null,1,{"$nulls":6},0]
[8,null,"x",null,null,1,{"$nulls":6},0]
[9,null,"x",null,null,1,{"$nulls":6},0]
[10,null,"x",null,null,1,{"$nulls":6},0]
[11,null,"x",null,null,1,{"$nulls":6},0]
[12,null,"x",null,null,1,{"$nulls":6},0]
[13,null,"x",null,null,1,{"$nulls":6},0]
[14,null,"x",null,null,1,{"$nulls":6},0]
[15,"Sa. Fremdleistungskosten",{"$nulls":10},0]
[]
[]
["Zl.","Materialkosten","Gewählte Auflagenhöhe",null,null,"Mengeneinheit","Kosten bei Auflagenhöhe I",null,"Kosten bei Auflagenhöhe II",null,"Kosten bei Auflagenhöhe III",null,"Kosten"]
[null,null,"I","II","III","(pro Stück, pro 1.000, usw.)","Menge","Kosten je Einheit","Menge","Kosten je Einheit","Menge","Kosten je Einheit","gesamt"]
[16,null,"x",null,null,1,{"$nulls":6},0]
[17,null,"x",null,null,1,{"$nulls":6},0]
[18,null,"x",null,null,1,{"$nulls":6},0]
[19,null,"x",null,null,1,{"$nulls":6},0]
[20,null,"x",null,null,1,{"$nulls":6},0]
[21,null,"x",null,null,1,{"$nulls":6},0]
[22,"Sa. Materialkosten",{"$nulls":10},0]