{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Angebotsdaten","Drehen_Maschine_1","Drehen_Maschine_2","Hinw_Angeb","Berechn_Rohmaterial_Gew"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Angebotsdaten","index":0,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,3,3,5]],"flags":["formulas_cached_only"]}
["Kunde","Anfrage-Nr. ","Anfragedatum","Maschine 1","Maschine 2","Ansprechpartner\n für Rückfragen","Telefon-/ Fax- Nr.","Abgabe-\ndatum"]
[]
["Kundenanschrift:"]
["Kundenanfrage /\n Referenz-Nr",null,"Teilebezeichnung",null,null,null,"Stückzahl",1]

{"sheet":"Drehen_Maschine_1","index":1,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[0,7,0,8],[1,7,1,8],[2,1,2,5],[3,3,3,5],[78,7,78,8],[48,7,48,8],[2,7,2,8],[3,7,3,8]],"flags":["formulas_cached_only"]}
["Kunde","Anfrage-Nr. ","Anfragedatum","Maschine 1",null,"Ansprechpartner\n für Rückfragen","Telefon-/ Fax- Nr.","Abgabe-\ndatum"]
["","","00:00:00","",null,"","","00:00:00"]
["Kunden-anschrift:",0,{"$nulls":4},"",""]
["Kundenanfrage / Referenz-Nr",0,"Teilebezeichnung",0,null,null,"Stückzahl",1]
[]
[]
["Dimensionen (L x B x H)",null,"1600 X 800 x 600",null,"Max. Dimensionen               (4700 x 2000 x 1700)"]
["Materialstärke",null,3]
["Gewicht",null,48]
["Anzahl Bauteile",null,1]
["Handlingszeit / Stück",null,8,null,"Min"]
[]
["Montage/ Demontage",null,5,null,"Min "]
[]
["Maschinenzeit (pauschal)",{"$nulls":5},"Diagramm / Tabelle einfügen"]
[null,"1. Aufspannung",4]
[null,"2. Aufspannung",0]
[null,null,4]
[null,null,null,1,"Anzahl Chargen"]
["Rüstzeit",null,20,20,"Min / Charge"]
["Aufspannungen",null,26.666666666666664,26.666666666666664,"Kosten / Rüsten Aufspannung"]
[]
["Bearbeitungsschritte",null,null,"Anzahl",null,"Zeit pro Gang"]
["Im Angebotstext berücksichtigen",null,0.4,2,"Schruppen [min/Gang]",0.2,0,"€ / Gang"]
[null,null,0,null,"Einstich [min/Gang]",0.4,0,"€ / Gang"]
[null,null,0,null,"Plandrehen [min/Gang]",0.6,0,"€ / Gang"]
[null,null,0,null,"Gewinde [min/Gew]",0.2,0,"€ / Gewinde"]
["Sonstiges (z.B.Polieren)",null,0,"Min"]
[null,"Summe",0.4,"Min"]
[]
["Materialkosten",null,0,null,"Teilebeschaffung Preis € / Stück"]
[null,null,0,null,"Sonstiges Material / Vorrichtungen Gesamtpreis"]
[null,"Summe",0]
[]
["Auslieferzustand",null,"Eloxiert",null,"verzinkt"]
[{"$nulls":4},"gestrahlt"]
[{"$nulls":4},"chromatiert"]
[{"$nulls":4},"verchromt"]
[{"$nulls":4},"unbehandelt"]
[{"$nulls":4},"KTL / Lackiert"]
[null,null,null,"Eloxiert","Eloxiert"]
[{"$nulls":4},"Foliert"]
[]
["Eigene Vorbehandlung 1",null,null,"Min","Reinigen / Folie entfernen mit"]
["Eigene Vorbehandlung ",null,null,"Min","Sägen"]
[null,null,null,"Min"]
[null,null,null,"Min"]
[null,"Summe",0]
[{"$nulls":7},"Zuschlag Externe Leistungen 20 %"]
[null,null,"Preis € / Stück"]
["Externe Vorbehandlung 1",null,35,null,"Eloxieren"]
["Externe Vorbehandlung 2",null,null,"X","KTL"]
["Externe Vorbehandlung 3",null,null,null,"Verzinken"]
[null,"Summe",35,null,"Lackieren"]
[{"$nulls":4},"Chromatieren"]
[]
["Transporte Vorbehandlung",null,null,"Entfernung in km","Anzahl Fahrten / Transportkosten"]
["Externe Vorbehandlung 1",null,0,0,2,null,"Transportkosten €/km einfach"]
["Externe Vorbehandlung 2",null,0,null,null,null,0.5]
["Externe Vorbehandlung 3",null,0]
[null,"Summe",0,0]
[]
["Verpackung",null,"Standard",0.1,"m² / Stück"]
[null,null,0.012000000000000002,0.1,"Folienkosten € / m","Standard: Wie angeliefert + Schaumfolie"]
[null,null,0,null,"€ / Stück","Gitterbox, Folie / Pappe / Zw-Lagen"]
[null,null,0,null,"€ / Stück","Einzelverp.: Kleinteile / Karton / KLTs/Zusatzpalette"]
[null,"Summe",0.012000000000000002]
[]
["Versand /Transport",null,"Standard","X","Abholung","Kostentabelle einfügen!"]
[{"$nulls":4},"Standard","Pauschale 60 €  Alt-/Festkunden"]
[{"$nulls":4},"Express","Neukunden 60 - 120 €","Transportkosten €/km einfach"]
[null,null,null,"Entfernung in km","Anzahl Fahrten / Transportkosten",null,0.5]
[null,null,0,12,0]
[]
["Prüfanforderungen Kunde",null,"Ausgangsprüfung!",null,"Stichprobe"]
[{"$nulls":4},"Prüfprotokoll",null,"Kostentabelle einfügen"]
[{"$nulls":4},"Maschinenfähigkeit"]
[{"$nulls":4},"Sonstiges"]
[{"$nulls":7},"Nachkalkulation"]
[{"$nulls":5},"Kostensatz € / h",null,"IST-Zeiten","Differenz"]
["Maschinenkosten pausch",null,5.333333333333333,0.06666666666666667,"Summe Maschinenzeit pausch in h",80,"6,2 €/Min"]
["Maschinenkosten einzeln",null,0.43333333333333335,0.006666666666666667,"Summe Maschinenzeit einzeln in h",65]
["Handlingskosten",null,8.666666666666666,0.13333333333333333,"Summe Handlingszeit in h",65]
["De-/Montagekosten",null,5.416666666666666,0.08333333333333333,"Summe De-/Montagezeit in h",65]
["Materialkosten",null,0,0,"Summe Vorbehandlungszeit in h",60]
["Rüstkosten",null,26.666666666666664,0,"Summe Rüsten/Aufspann. in h",60]
["Vorbehandlungskosten (Intern)",null,0]
["Vorbehandlungskosten (extern)",null,42,0.22333333333333333,"Summe Gesamtarbeitsstunden"]
["Verpackung",null,0.012000000000000002,0.22333333333333333,"Stunden / Teil",2149.2537313432836,"max Teile / Monat",3,"Mitarbeiter"]
["Transport",{"$nulls":4},0.18611111111111112,"AuslastungKapazität bei",400,"Teilen"]
["Prüfkosten",{"$nulls":4},33.333333333333336,"Maschinenstunden / Monat bei",null,"Teilen"]
["Gemeinkosten",{"$nulls":4},0.20833333333333334,"Auslastung Maschine"]
["Summe",null,88.52866666666667]
["Kosten/Teil",null,88.52866666666667]
["SKN",null,99.15210666666668]
["Kosten/Teil SKN",null,99.15210666666668]
["SKB",null,111.05035946666669]
["Kosten/Teil SKB",null,111.05035946666669]
["Staffelpreise"]

{"sheet":"Drehen_Maschine_2","index":2,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":false,"merged":[[0,7,0,8],[1,7,1,8],[2,7,2,8],[3,7,3,8],[48,7,48,8],[78,7,78,8],[2,1,2,5],[3,3,3,5],[0,3,0,4],[1,3,1,4]],"flags":["formulas_cached_only"]}
["Kunde","Anfrage-Nr. ","Anfragedatum","Maschine 2",null,"Ansprechpartner\n für Rückfragen","Telefon-/ Fax- Nr.","Abgabe-\ndatum"]
["","","00:00:00","",null,"","","00:00:00"]
["Kunden-anschrift:",0,{"$nulls":4},"",""]
["Kundenanfrage / Referenz-Nr",0,"Teilebezeichnung",0,null,null,"Stückzahl",1]
[]
[]
["Dimensionen (L x B x H)",null,"1600 X 800 x 600",null,"Max. Dimensionen               (4700 x 2000 x 1700)"]
["Materialstärke",null,3]
["Gewicht",null,48]
["Anzahl Bauteile",null,1]
["Handlingszeit / Stück",null,8,null,"Min"]
[]
["Montage/ Demontage",null,5,null,"Min "]
[]
["Maschinenzeit (pauschal)",{"$nulls":5},"Diagramm / Tabelle einfügen"]
[null,"1. Aufspannung",4]
[null,"2. Aufspannung",0]
[null,null,4]
[null,null,null,1,"Anzahl Chargen"]
["Rüstzeit",null,20,20,"Min / Charge"]
["Aufspannungen",null,26.666666666666664,26.666666666666664,"Kosten / Rüsten Aufspannung"]
[]
["Bearbeitungsschritte",null,null,"Anzahl",null,"Zeit pro Gang"]
["Im Angebotstext berücksichtigen",null,0.4,2,"Schruppen [min/Gang]",0.2,0,"€ / Gang"]
[null,null,0,null,"Einstich [min/Gang]",0.4,0,"€ / Gang"]
[null,null,0,null,"Plandrehen [min/Gang]",0.6,0,"€ / Gang"]
[null,null,0,null,"Gewinde [min/Gew]",0.2,0,"€ / Gewinde"]
["Sonstiges (z.B.Polieren)",null,0,"Min"]
[null,"Summe",0.4,"Min"]
[]
["Materialkosten",null,0,null,"Teilebeschaffung Preis € / Stück"]
[null,null,0,null,"Sonstiges Material / Vorrichtungen Gesamtpreis"]
[null,"Summe",0]
[]
["Auslieferzustand",null,"Eloxiert",null,"verzinkt"]
[{"$nulls":4},"gestrahlt"]
[{"$nulls":4},"chromatiert"]
[{"$nulls":4},"verchromt"]
[{"$nulls":4},"unbehandelt"]
[{"$nulls":4},"KTL / Lackiert"]
[null,null,null,"Eloxiert","Eloxiert"]
[{"$nulls":4},"Foliert"]
[]
["Eigene Vorbehandlung 1",null,null,"Min","Reinigen / Folie entfernen mit"]
["Eigene Vorbehandlung ",null,null,"Min","Sägen"]
[null,null,null,"Min"]
[null,null,null,"Min"]
[null,"Summe",0]
[{"$nulls":7},"Zuschlag Externe Leistungen 20 %"]
[null,null,"Preis € / Stück"]
["Externe Vorbehandlung 1",null,35,null,"Eloxieren"]
["Externe Vorbehandlung 2",null,null,"X","KTL"]
["Externe Vorbehandlung 3",null,null,null,"Verzinken"]
[null,"Summe",35,null,"Lackieren"]
[{"$nulls":4},"Chromatieren"]
[]
["Transporte Vorbehandlung",null,null,"Entfernung in km","Anzahl Fahrten / Transportkosten"]
["Externe Vorbehandlung 1",null,0,0,2,null,"Transportkosten €/km einfach"]
["Externe Vorbehandlung 2",null,0,null,null,null,0.5]
["Externe Vorbehandlung 3",null,0]
[null,"Summe",0,0]
[]
["Verpackung",null,"Standard",0.1,"m² / Stück"]
[null,null,0.012000000000000002,0.1,"Folienkosten € / m","Standard: Wie angeliefert + Schaumfolie"]
[null,null,0,null,"€ / Stück","Gitterbox, Folie / Pappe / Zw-Lagen"]
[null,null,0,null,"€ / Stück","Einzelverp.: Kleinteile / Karton / KLTs/Zusatzpalette"]
[null,"Summe",0.012000000000000002]
[]
["Versand /Transport",null,"Standard","X","Abholung","Kostentabelle einfügen!"]
[{"$nulls":4},"Standard","Pauschale 60 €  Alt-/Festkunden"]
[{"$nulls":4},"Express","Neukunden 60 - 120 €","Transportkosten €/km einfach"]
[null,null,null,"Entfernung in km","Anzahl Fahrten / Transportkosten",null,0.5]
[null,null,0,12,0]
[]
["Prüfanforderungen Kunde",null,"Ausgangsprüfung!",null,"Stichprobe"]
[{"$nulls":4},"Prüfprotokoll",null,"Kostentabelle einfügen"]
[{"$nulls":4},"Maschinenfähigkeit"]
[{"$nulls":4},"Sonstiges"]
[{"$nulls":7},"Nachkalkulation"]
[{"$nulls":5},"Kostensatz € / h",null,"IST-Zeiten","Differenz"]
["Maschinenkosten pausch",null,5.333333333333333,0.06666666666666667,"Summe Maschinenzeit pausch in h",80,"6,2 €/Min"]
["Maschinenkosten einzeln",null,0.43333333333333335,0.006666666666666667,"Summe Maschinenzeit einzeln in h",65]
["Handlingskosten",null,8.666666666666666,0.13333333333333333,"Summe Handlingszeit in h",65]
["De-/Montagekosten",null,5.416666666666666,0.08333333333333333,"Summe De-/Montagezeit in h",65]
["Materialkosten",null,0,0,"Summe Vorbehandlungszeit in h",60]
["Rüstkosten",null,26.666666666666664,0,"Summe Rüsten/Aufspann. in h",60]
["Vorbehandlungskosten (Intern)",null,0]
["Vorbehandlungskosten (extern)",null,42,0.22333333333333333,"Summe Gesamtarbeitsstunden"]
["Verpackung",null,0.012000000000000002,0.22333333333333333,"Stunden / Teil",2149.2537313432836,"max Teile / Monat",3,"Mitarbeiter"]
["Transport",{"$nulls":4},0.18611111111111112,"AuslastungKapazität bei",400,"Teilen"]
["Prüfkosten",{"$nulls":4},33.333333333333336,"Maschinenstunden / Monat bei",null,"Teilen"]
["Gemeinkosten",{"$nulls":4},0.20833333333333334,"Auslastung Maschine"]
["Summe",null,88.52866666666667]
["Kosten/Teil",null,88.52866666666667]
["SKN",null,99.15210666666668]
["Kosten/Teil SKN",null,99.15210666666668]
["SKB",null,111.05035946666669]
["Kosten/Teil SKB",null,111.05035946666669]
["Staffelpreise"]

{"sheet":"Hinw_Angeb","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,3,3,5]],"flags":["formulas_cached_only"]}
["Kunde","Anfrage-Nr. ","Anfragedatum","Maschine 1","Maschine 2","Ansprechpartner\n für Rückfragen","Telefon-/ Fax- Nr.","Abgabe-\ndatum"]
["","","","","","","","00:00:00"]
["Kunden-anschrift:",0,{"$nulls":4},""]
["Kundenanfrage /\n Referenz-Nr",0,"Teilebezeichnung",0,null,null,"Stückzahl",1]
[]
[]
["Angebotstext: Wie telefonisch mit XY besprochen freuen wir uns Ihnen nachfolgendes Angebot unterbreiten zu dürfen.  "]
["Angebotsdaten"]
["- Die Lieferzeit beträgt 2 Wochen nach Bestelleingang."]
["- Lieferung ab Werk / EXW"]
["- Verpackung: Wie angeliefert."]
["- Anlieferzustand: Die "]
["- Stückpreis x € / Teil"]
["- Angebotsbindefrist 12 Wochen"]
["- Prüfdokumentation wird auf Wunsch separat erstellt"]
["- Leistungen: Herstellung, Montage, Ausgangsprüfung "]

{"sheet":"Berechn_Rohmaterial_Gew","index":4,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Dichte"]
[null,"Stahl",7.85,"kg/dm³"]
[null,"Aluminium",2.7,"kg/dm³"]
[]
[{"$nulls":7},"Formel kontrollieren",null,null,"Formel kontrollieren"]
[null,"Bauteil:",null,"alles in mm"]
[{"$nulls":6},"Stahl","Alu",null,"Span-Volumen","Verpackung"]
[null,"Länge","Breite","Höhe /\n Blechstärke","Abtragdicke",null,"Masse (kg)","Masse (kg)",null,"(in Liter)","[m²)"]
[null,1170,490,2.5,0.04,null,11.2510125,3.8697750000000006,null,0.022932000000000004,0.5733]
[null,1170,490,2.5,0.04,null,11.2510125,3.8697750000000006,null,0.022932000000000004,0.5733]
[null,1170,380,2.5,0.04,null,8.725275,3.00105,null,0.017784,0.4446]
[null,1170,380,5,0.04,null,17.45055,6.0021,null,0.017784,0.4446]
[null,490,380,2.5,0.04,null,3.654175,1.25685,null,0.007448000000000001,0.1862]
[null,490,380,2.5,0.04,null,3.654175,1.25685,null,0.007448000000000001,0.1862]
[{"$nulls":5},"Summe",55.986200000000004,19.2564,"Summe",0.096328,2.4082]
[null,null,"Durchmesser"]
[{"$nulls":4},0.06,null,0,0,null,0,0]
[{"$nulls":4},0.06,null,0,0,null,0,0]
[{"$nulls":6},0,0,null,0,0]
[{"$nulls":6},0,0,null,0,0]
[{"$nulls":5},"Summe",0,0,"Summe",0,0]