{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Beschreibung","Papierberechnung","Angebotspreis","Materialkosten"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Beschreibung","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
[" Angebotskalkulation",{"$nulls":3},"Nr.:"]
[" Grunddaten",{"$nulls":3},"Bearbeiter:"]
[" Besteller:",{"$nulls":3},"Telefon:"]
[{"$nulls":4},"Fax:"]
[{"$nulls":4},"Anfrage vom:"]
[" Objekt:",{"$nulls":3},"Angebot am:"]
[{"$nulls":4},"Liefertermin:"]
[" Auflage:"]
[" Umfang:"]
[" Endformat:",{"$nulls":3},"offen:"]
[" Papier:"]
[]
[]
[" "]
[" Farben:"]
[]
[" Vorlagen - analog:"]
[" Vorlagen - digital:"]
[]
[" Anmerkungen:"]
[]
[" Technische Daten"]
[" Druckvorstufe:"]
[]
[]
[]
[]
[" Ausschießschema:"]
[]
[" Korrekturabzüge:"]
[" "]
[" Andrucke:"]
[" Druckform (CtP/CtF):"]
[]
[" Druck:"]
[]
[" "]
[" Druckweiterverarbeitung:"]
[]
[" "]
[]
[" Verpackung:"]
[" Fremdleistungen:"]
[]
[]
[" Sonstiges:"]
[]
[" Lieferung:"]

{"sheet":"Papierberechnung","index":1,"n_rows":66,"n_cols":13,"rows_kept":66,"merged":[[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12]],"flags":["formulas_cached_only"]}
["Bogeneinteilung",{"$nulls":8},0,"",0,"Seite 2"]
[]
["Bogenvermaßung in mm"]
[{"$nulls":10}," "]
["Schmalkante"]
["Teilprodukt"]
["Greifer"]
["Beschnitt",{"$nulls":6}," "]
["Nutzen"]
["Beschnitt",null,null," "]
["Nutzen"]
["Beschnitt"]
["Nutzen"]
["Beschnitt"]
["Nutzen",{"$nulls":9}," "]
["Beschnitt",{"$nulls":9}," "]
["Farbkeil",{"$nulls":6}," "]
["Beschnitt"]
["Gesamt",0,0]
[]
[]
["Breitkante"]
["Teilprodukt"]
["Beschnitt"]
["Nutzen",{"$nulls":9}," "]
["Beschnitt"]
["Nutzen"]
["Beschnitt",null," "]
["Nutzen"]
["Beschnitt"]
["Nutzen"]
["Beschnitt"]
["Gesamt",0,0]
{"$rows_empty":10}
["Zuschusswerte je Teilprodukt und Produktionsschritt"]
["Teilprodukt                       "]
["                                                        ",null,null,"fix in Bg.","var. in %","fix in Bg.","var. in %","fix in Bg.","var. in %","fix in Bg.","var. in %","fix in Bg.","var. in %"]
["Zuschuss Druck je Maschine"]
["Zuschuss Druck für Platten"]
["Zuschuss Spez.-Druckarbeiten Buchdruck"]
["Zuschuss Falzen                  "]
["Zuschuss Heften/Sammelheften        "]
["Zuschuss Zusammentragen      "]
["Zuschuss Kleben/Klebebinden",{"$nulls":6}," "]
["Zuschuss Stanzen/Prägen      "]
["Zuschuss gesamt                ",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0.0 "},{"v":0,"d":"0 "},{"v":0,"d":"0.0 "},{"v":0,"d":"0 "},{"v":0,"d":"0.0 "},{"v":0,"d":"0 "},{"v":0,"d":"0.0 "},{"v":0,"d":"0 "},{"v":0,"d":"0.0 "}]
[]
["Papiermengenberechnung"]
["Teil-","Format","Format","Druckbg.","Produkt-","Auflage","Druckbg.","Zuschuss Druck",null,"Druckbogen",null,"Rohbogen"]
["produkt","Rohbg.","Druckbg.","je","nutzen je",null,"netto","und Druckweiterverarb.",null,"brutto",null,"brutto"]
[null,"cm","cm","Rohbg.","Druckbg.",null,null,"fix","var. in %","fix","var.","fix","var."]
["a","b","c","d","e","f","g = f / e","h","i","j","k = g + (g • i%)","l = j / d","m = k / d"]
["",{"$nulls":5},"","","","","","",""]
["",{"$nulls":5},"","","","","","",""]
["",{"$nulls":5},"","","","","","",""]
["",{"$nulls":5},"","","","","","",""]
["",{"$nulls":5},"","","","","","",""]

{"sheet":"Angebotspreis","index":2,"n_rows":55,"n_cols":10,"rows_kept":55,"flags":["formulas_cached_only"]}
["Ermittlung der Selbstkosten/des Preisvorschlags",{"$nulls":5},0,"",0,"Seite 3"]
[{"$nulls":3},"Zeit je Einheit","Menge",null,"Rüstzeit/","Kostensatz","Kosten in Euro"]
["Zl.","Position","Betriebsmittel/Arbeitsvorgang","in Min.","auflagen-","auflagen-","Ausführungs-","Euro/Min.","auflagen-","auflagen-"]
[{"$nulls":3},"(bei Stückkst.=1)","fix","variabel","zeit in Min.","Euro/Einheit","fix","variabel"]
[null,"a","b","c","d","e","f = c • (d od. e)","g","h = f • g","i = f • g"]
[1,{"$nulls":5},"",null,"",""]
[2,{"$nulls":5},"",null,"",""]
[3,{"$nulls":5},"",null,"",""]
[4,{"$nulls":5},"",null,"",""]
[5,{"$nulls":5},"",null,"",""]
[6,{"$nulls":5},"",null,"",""]
[7,{"$nulls":5},"",null,"",""]
[8,{"$nulls":5},"",null,"",""]
[9,{"$nulls":5},"",null,"",""]
[10,{"$nulls":5},"",null,"",""]
[11,{"$nulls":5},"",null,"",""]
[12,{"$nulls":5},"",null,"",""]
[13,{"$nulls":5},"",null,"",""]
[14,{"$nulls":5},"",null,"",""]
[15,{"$nulls":5},"",null,"",""]
[16,{"$nulls":5},"",null,"",""]
[17,{"$nulls":5},"",null,"",""]
[18,{"$nulls":5},"",null,"",""]
[19,{"$nulls":5},"",null,"",""]
[20,{"$nulls":5},"",null,"",""]
[21,{"$nulls":5},"",null,"",""]
[22,{"$nulls":5},"",null,"",""]
[23,{"$nulls":5},"",null,"",""]
[24,{"$nulls":5},"",null,"",""]
[25,{"$nulls":5},"",null,"",""]
[26,{"$nulls":5},"",null,"",""]
[27,{"$nulls":5},"",null,"",""]
[28,{"$nulls":5},"",null,"",""]
[29,{"$nulls":5},"",null,"",""]
[30,{"$nulls":5},"",null,"",""]
[31,{"$nulls":5},"",null,"",""]
[32,{"$nulls":5},"",null,"",""]
[33,{"$nulls":5},"",null,"",""]
[34,{"$nulls":5},"",null,"",""]
[35,{"$nulls":5},"",null,"",""]
[36,{"$nulls":5},"",null,"",""]
[37,{"$nulls":5},"",null,"",""]
[38,{"$nulls":5},"",null,"",""]
[39,"Sa. Fertigungskosten (Zl. 1–38)",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[40,"Sa. Material- und Fremdleistungskosten (S. 4, Zl. 42)",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[41,"Sa. Selbstkosten (Zl. 39 + 40)",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[42,"+ Gewinn % i. H. ",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[43,"Zwischensumme ",null," ",{"$nulls":4},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[44,"+ Provision/Skonto % i. H.",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[45,"Zwischensumme",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[46,"Vertriebseinzelkosten/Versandkosten"]
[47,"Kalkulierte Preisvorgabe",{"$nulls":6},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[48,"Angebotspreisvorschlag (fixe + variable Bestandteile)  ",{"$nulls":6},{"v":0,"d":"0.00 "}]
[49,"Preisvorschlag für 1.000 Stück (1.000er-Stückpreis)",{"$nulls":7},{"v":0,"d":"0.00 "}]
[50,"Preisvorschlag für weitere 1.000 Stück",{"$nulls":7},{"v":0,"d":"0.00 "}]

{"sheet":"Materialkosten","index":3,"n_rows":55,"n_cols":12,"rows_kept":55,"flags":["formulas_cached_only"]}
["Ermittlung der Material- und Fremdleistungskosten",{"$nulls":7},0,"",0,"Seite 4"]
["Zl.","Filme/Druckplatten",{"$nulls":6},"Menge","Kosten je","Kosten in Euro"]
[null," ",{"$nulls":7},"Einheit in Euro","auflagenfix","auflagenvariabel"]
[null,"a",{"$nulls":6},"b","c","d = b • c","e"]
[{"v":1,"d":"1 "},{"$nulls":9},""]
[{"v":2,"d":"2 "},{"$nulls":9},""]
[{"v":3,"d":"3 "},{"$nulls":9},""]
[{"v":4,"d":"4 "},{"$nulls":9},""]
[{"v":5,"d":"5 "},{"$nulls":9},""]
[{"v":6,"d":"6 "},"+ Zuschuss in %",null,null," ",{"$nulls":5},{"v":0,"d":"0.00 "}]
[{"v":7,"d":"7 "},"Sa. Materialkosten der Druckvorlagen und -formherstellung",{"$nulls":8},{"v":0,"d":"0.00 "}]
[null,"Papier",{"$nulls":4},"Format","Bogen-","Anzahl","Preis","Kosten in Euro"]
[{"$nulls":6},"Rohbg.","gewicht","Bruttobogen","je","auflagenfix","auflagenvariabel"]
[{"$nulls":6},"in cm","in g/m²","in 1.000","1.000 Bg."]
[null,"a",{"$nulls":4},"b","c","d","e","f = d • e","g = d • e"]
[{"v":8,"d":"8 "},"fix:",{"$nulls":6},"",null,""]
[{"v":9,"d":"9 "},{"$nulls":7},"",null,""]
[{"v":10,"d":"10 "},{"$nulls":7},"",null,""]
[{"v":11,"d":"11 "},{"$nulls":7},"",null,""]
[{"v":12,"d":"12 "},{"$nulls":7},""]
[{"v":13,"d":"13 "},"variabel:",{"$nulls":6},"",null,null,""]
[{"v":14,"d":"14 "},{"$nulls":7},"",null,null,""]
[{"v":15,"d":"15 "},{"$nulls":7},"",null,null,""]
[{"v":16,"d":"16 "},{"$nulls":7},"",null,null,""]
[{"v":17,"d":"17 "},{"$nulls":7},""]
[{"v":18,"d":"18 "},"Sa. Papierkosten",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Farbe","Bedruckte","Druckdichte","Gedeckte","Farbverbrauch in g",null,"Brutto-","Verbrauch","Preis je kg","Kosten in Euro"]
[null,null,"Fläche des","in %","Fläche","je m² oder","je Expl.","auflage","in kg oder","oder Pauschale","auflagenfix","auflagenvariabel"]
[null,null,"Exemplars",null,"in m²","Pauschale in g",null,"in 1.000","Pauschalver-","je 1.000 Druck"]
[null,null,"in m²",null,null,"je 1.000 Druck",null,"Expl.","brauch in kg","in Euro"]
[null,"a","b","c","d = b • c","e","f = d • e","g","h = f • g","i","j","k = h • i"]
[{"v":19,"d":"19 "},{"$nulls":3},"",null,"",null,"",null,null,""]
[{"v":20,"d":"20 "},{"$nulls":3},"",null,"",null,"",null,null,""]
[{"v":21,"d":"21 "},{"$nulls":3},"",null,"",null,"",null,null,""]
[{"v":22,"d":"22 "},{"$nulls":3},"",null,"",null,"",null,null,""]
[{"v":23,"d":"23 "},{"$nulls":3},"",null,"",null,"",null,null,""]
[{"v":24,"d":"24 "},"Farbverbrauch für Einrichten, Einlaufen lassen der Farbe, Waschverluste"]
[{"v":25,"d":"25 "},null,null,"Anzahl Farben: ",null,null,"Gramm je Farbe: ",null,"",null,""]
[{"v":26,"d":"26 "},"Sa. Farbkosten",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":27,"d":"27 "},"Sonstige Materialeinzelkosten"]
[{"v":28,"d":"28 "}]
[{"v":29,"d":"29 "},"Sa. Sonstige Materialeinzelkosten",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":30,"d":"30 "},"Sa. Materialeinzelkosten (Zl. 7 + 18 + 26 + 29)                                 ",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":31,"d":"31 "},"+ Materialzuschlag in %",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":32,"d":"32 "},"+ Materialzuschlag fix"]
[{"v":33,"d":"33 "},"Sa. Materialkosten (Zl. 30–32)",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":34,"d":"34 "},"Fremdleistungen"]
[{"v":35,"d":"35 "}]
[{"v":36,"d":"36 "}]
[{"v":37,"d":"37 "}]
[{"v":38,"d":"38 "},"Zwischensumme Fremdleistungskosten",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":39,"d":"39 "},"+  Fremdleistungszuschlag in %",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":40,"d":"40 "}]
[{"v":41,"d":"41 "},"Sa. Fremdleistungskosten (Zl. 38–40)",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[{"v":42,"d":"42 "},"Sa. Material- und Fremdleistungskosten (Zl. 33 + 41)",{"$nulls":8},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]