{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["QM erstellen","Liste Q-Meldungen","Formulare ausfüllen","Formular Q-Meldung","Formular Mängelrüge","Zuordungstabelle"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":2,"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":"QM erstellen","index":0,"n_rows":30,"n_cols":43,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Ursprung","gemeldet von","Datum","Teilebezeichnung","Artikelschlüssel","Teile-Nr.","Lieferant","Kunde","Kunden-Nr.","Bestell-Nr.","Pos.-Nr","Lieferschein-Nr","Menge","Mengeneinheit","Bearbeiter","Fehlerursache","Fehlerbeschreibung","QS-Entscheid","geschätzter Nacharbeitsaufwand [h]","Materialkosten Nacharbeit / Ausschuß","Kostenübernahme durch","Bemerkung Kostenübernahme","Maßnahme Einkauf","Erledigung bis","Maßnahme AV","Erledigung bis","Maßnahme Konstruktion","Erledigung bis","Maßnahme Fertigung","Erledigung bis","Maßnahme Vertrieb","Erledigung bis","Maßnahme QW","Erledigung bis","Maßnahme Versand","Erledigung bis","Maßnahme Sonstige","Erledigung bis","Postleitzahl","Anlieferung durch",null,"Monat"]
[{"$nulls":24}," "]
[]
[]
[{"$nulls":19}," "]
[{"$nulls":17}," "]
[{"$nulls":17}," "]
[1,"Kundenreklamation","Geers","2011-12-11","Lufteinlass","Artikelgr. 1","0-815","Musterlieferant"," "," ","0-815",null,"0-815",1,"Stück","M. Schröck","Oberflächenfehler","Kratzer an Oberfläche","Neulieferung ohne \nBerechnung"," "," ","Spedition,   "," ","Lieferant informieren, 000","2011-11-14","0   "," ","    "," ","Zur Info , "," ","    "," ","Zur Info,  "," ","  "," ","  "," ",null," ",null,12]
[{"$nulls":21},"Spedition, ",null,"Lieferant informieren, ",null,0,null," ",null,"Zur Info ,",null," ",null,"Zur Info,",null," ",null," ",null,null," "]
[{"$nulls":21}," ",null,0,null," ",null," ",null," ",null," ",null," ",null," ",null," "]
[{"$nulls":21}," ",null,0,null," ",null," ",null,null,null," ",null," "]
[{"$nulls":23},0,null," ",null," ",null,null,null," "]
["Diese Felder nicht löschen oder überschreiben! Bitte aus der vorgegebenen Liste auswählen. "]
[]
["Vorgehensweise erstellen einer QM"]
["1. Q-Meldungs-Nr. um 1 erhöhen und gelb markierte Zeile ausfüllen. Auswahllisten verwenden und in den anderen Feldern Daten eingeben."]
["2. Zeile 7 markieren (auf die Zeilennummerierung klicken) und kopieren (rechte Maustaste oder strg C oder im Menü \"Bearbeiten\")."]
["3. Zu Blatt \"Liste Q-Meldungen\" wechseln und nächste freie Zeile markieren."]
["4. Über rechte Maustaste  oder im Menü \"Bearbeiten\" den Befehl \"Inhalte einfügen\" auswählen."]
["5. Im Auswahlfeld \"Inhalte einfügen\" das Feld \"Werte\" auswählen und bestätigen."]
[{"$nulls":17}," "]
[]
["Vorgehensweise Formulare ausfüllen / drucken / verschicken"]
[]
["1. Betreffende Zeile in der Liste Q-Meldungen markieren (auf die Zeilennummerierung klicken)"]
["2. Zu Blatt \"Formular ausfüllen\" wechseln und Zeile 2 markieren und kopieren (rechte Maustaste oder Strg C oder im Menü \"Bearbeiten\")"]
["3. Über rechte Maustaste  Strg V oder im Menü \"Bearbeiten\" den Befehl \"Einfügen\" auswählen."]
["4. Zum Blatt \"Formular Mängelrüge\" oder \"Formular Q-Meldungen\" wechseln und Inhalt ausdrucken bzw. Tabelle kopieren und in Email einfügen."]
[]
["Rücksetzen \"QM erstellen\": In \"Zuordnungstabelle\" Zeile 25 bis 27 markieren, kopieren und in Zeile 20 einfügen"]

{"sheet":"Liste Q-Meldungen","index":1,"n_rows":306,"n_cols":46,"rows_kept":306,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Q-Meldungs-Nr.","Ursprung","gemeldet von","Datum","Teilebezeichnung","Artikel-schlüssel","Teile-Nr.","Lieferant","Kunde","Kunden-Nr","Bestell-Nr.","Pos.-Nr","Lieferschein-Nr","Menge","Mengeneinheit","Bearbeiter","Fehlerursache","Fehlerbeschreibung","QS-Entscheid","geschätzter Nacharbeitsaufwand\n[h]","Materialkosten Nacharbeit/Ausschuß/Frachtkosten","Kostenübernahme durch","Bermerkung\nKostenübernahme","Maßnahme Einkauf","Erledigung bis","Maßnahme AV","Erledigung bis","Maßnahme Konstruktion","Erledigung bis","Maßnahme Fertigung","Erledigung bis","Maßnahme Vertrieb","Erledigung bis","Maßnahme QW","Erledigung bis","Maßnahme Versand","Erledigung bis","Maßnahme Sonstige","Erledigung bis","Postleitzahl","Anlieferung durch","Maßnahmen erledigt","Monat","Q-Nr"]
[1,"Kundenreklamation Systeme","Geers","2011-12-11","Lufteinlass","Verschlüsse","0-815","Musterlieferant"," "," ","0-815",null,"0-815",1,"Stück","H. Geers","Oberflächenfehler","Kratzer an Oberfläche","Neulieferung ohne \nBerechnung"," "," ","Spedition,   "," ","Lieferant informieren, 000","2011-11-14","0   "," ","    "," ","Zur Info , "," ","    "," ","Zur Info,  "," ","  "," ","  "," ",null," ",null,12]
{"$rows_empty":184}
[{"$nulls":6},"               "]
{"$rows_empty":106}
[{"$nulls":45}," "]
[{"$nulls":45}," "]
[{"$nulls":45}," "]
[{"$nulls":45}," "]
[]
[]
[]
[]
[]
[{"$nulls":45}," "]
[{"$nulls":45}," "]
[{"$nulls":45}," "]
[{"$nulls":45}," "]

{"sheet":"Formulare ausfüllen","index":2,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Q-Meldungs-Nr.","Ursprung","gemeldet von","Datum","Teilebezeichnung","Artikel-schlüssel","Teile-Nr.","Lieferant","Kunde","Kunden-Nr","Bestell-Nr.","Pos.-Nr","Lieferschein-Nr","Menge","Mengeneinheit","Bearbeiter","Fehlerursache","Fehlerbeschreibung","QS-Entscheid","geschätzte Nacharbeitskosten","Materialkosten Nacharbeit / Ausschuß","Kostenübernahme durch","Bemerkung Kostenübernahme","Maßnahme Einkauf","Erledigung bis","Maßnahme AV","Erledigung bis","Maßnahme Konstruktion","Erledigung bis","Maßnahme Fertigung","Erledigung bis","Maßnahme Vertrieb","Erledigung bis","Maßnahme QW","Erledigung bis","Maßnahme Versand","Erledigung bis","Maßnahme Sonstige","Erledigung bis","Postleitzahl","Anlieferung durch","Maßnahmen erledigt","Monat"]
[1,"Kundenreklamation Systeme","Geers","2011-12-11","Lufteinlass","Verschlüsse","0-815","Musterlieferant"," "," ","0-815",null,"0-815",1,"Stück","H. Geers","Oberflächenfehler","Kratzer an Oberfläche","Neulieferung ohne \nBerechnung"," "," ","Spedition,   "," ","Lieferant informieren, 000","2011-11-14","0   "," ","    "," ","Zur Info , "," ","    "," ","Zur Info,  "," ","  "," ","  "," ",null," ",null,12]

{"sheet":"Formular Q-Meldung","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,5,13,6],[13,1,13,2],[13,3,13,4],[17,0,17,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[25,0,25,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[18,0,18,3],[11,1,11,6],[12,1,12,3],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[0,5,0,6],[1,5,1,6],[4,3,4,4],[10,1,10,3],[1,1,1,2],[8,3,8,4],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[1,3,1,4],[7,3,7,4],[6,3,6,4],[3,3,3,4],[2,1,2,4],[12,5,12,6],[5,3,5,4],[7,5,7,6],[8,5,8,6],[6,5,6,6]],"flags":["formulas_cached_only"]}
["gemeldet von","Geers","Datum","2011-12-11","Bearbeiter","H. Geers",{"$error":"#REF!"}]
["Q-Meldungs-Nr.",1,{"$error":"#REF!"},"Ursprung",null,"Kundenreklamation Systeme",{"$error":"#REF!"}]
["Teilebezeichnung","Lufteinlass"]
["Teile-Nr.","0-815",0,"Kunde",null," "]
["Bestell-Nr.","0-815",0,"Lieferant",null,"Musterlieferant"]
["Pos.-Nr",0,0]
["Lieferschein-Nr","0-815",0]
["Menge",1,0]
["Mengeneinheit","Stück",0]
[]
["Fehlerursache","Oberflächenfehler",0,0]
["Fehlerbeschreibung","Kratzer an Oberfläche",0,0,0,0,0]
["QS-Entscheid","Neulieferung ohne \nBerechnung",0,0,"Materialkosten Nacharbeit / Ausschuß"," "]
["Nacharbeitsaufwand\nin Stunden"," ",null,"Kostenübernahme durch",null,"Spedition,   ",0]
["Maßnahme ",null,null,null,"Abteilung","Erledigung bis","Maßnahmen erledigt"]
["Lieferant informieren, 000",0,0,0,"Einkauf","2011-11-14"]
["0   ",0,0,0,"AV"," "]
["    ",0,0,0,"Konstruktion"," "]
["Zur Info , ",0,0,0,"Fertigung W1"," "]
[{"$error":"#REF!"},0,0,0,"Fertigung W2",{"$error":"#REF!"}]
[{"$error":"#REF!"},0,0,0,"Fertigung W3",{"$error":"#REF!"}]
[{"$error":"#REF!"},0,0,0,"Fertigung Luftfahrt",{"$error":"#REF!"}]
["    ",0,0,0,"Vertrieb"," "]
["Zur Info,  ",0,0,0,"QW"," "]
["  ",0,0,0,"Versand"," "]
["  ",0,0,0,"Sonstige"," "]

{"sheet":"Formular Mängelrüge","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,2],[14,1,14,2],[14,3,14,4],[14,5,14,6],[10,1,10,3],[12,1,12,2],[12,3,12,4],[13,1,13,2],[13,3,13,4],[11,1,11,6],[6,5,6,6],[4,5,4,6],[16,0,18,6],[15,0,15,2],[15,3,15,6],[8,5,8,6],[13,5,13,6],[8,3,8,4],[8,1,8,2],[12,5,12,6],[5,3,5,4],[5,1,5,2],[0,5,0,6],[1,5,1,6],[1,1,1,2],[2,5,2,6],[1,3,1,4],[2,3,2,4],[3,3,3,4],[2,1,2,2],[9,1,9,2],[7,3,7,4],[3,5,3,6],[4,3,4,4],[6,1,6,2],[7,5,7,6],[7,1,7,2],[6,3,6,4],[5,5,5,6],[4,1,4,2]],"flags":["formulas_cached_only"]}
["gemeldet von","Geers","Datum","2011-12-11","Bearbeiter","H. Geers",{"$error":"#REF!"}]
["Q-Meldungs-Nr.",1,{"$error":"#REF!"},"Ursprung",null,"Kundenreklamation Systeme",{"$error":"#REF!"}]
["Teilebezeichnung","Lufteinlass",0]
["Teile-Nr.","0-815",0,"Lieferant",null,"Musterlieferant"]
["Bestell-Nr.","0-815",0]
["Pos.-Nr",0,0]
["Lieferschein-Nr","0-815",0]
["Menge",1,0]
["Mengeneinheit","Stück",0]
[]
["Fehlerursache","Oberflächenfehler",0,0]
["Fehlerbeschreibung","Kratzer an Oberfläche",0,0,0,0,0]
["QS-Entscheid","Neulieferung ohne \nBerechnung",null,"Materialkosten Nacharbeit / Ausschuß",null," "]
["geschätzter Nacharbeitsaufwand\nin Stunden"," ",0,"Kostenübernahme durch",null,"Spedition,   ",0]
["Stundensatz für Nacharbeit",55,null,"Bearbeitungsgebühr",null,35]
["Vorabschätzung Gesamtkosten für Nacharbeit"]
["Vom Lieferant ist innerhalb von zwei Arbeitstagen eine Stellungnahme abzugeben! Ausschuss Material steht dem Lieferanten 10 Werktage zu Abholung bereit. Bei Nichtabholung wird die Ware verschrottet."]

{"sheet":"Zuordungstabelle","index":5,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Q-Meldungs-Nr.","Ursprung","gemeldet von","Datum","Teilebezeichnung","Artikelschlüssel","Teile-Nr.","Lieferant","Kunde","Kunden-Nr","Bestell-Nr.","Pos.-Nr","Lieferschein-Nr","Menge","Mengeneinheit","Bearbeiter","Fehlerursache","Fehlerbeschreibung","QS-Entscheid","geschätzte Nacharbeits-\nkosten","Materialkosten Nacharbeit / Ausschuß","Kostenübernahme durch","Maßnahme Einkauf","Erledigung bis","Maßnahme AV","Erledigung bis","Maßnahme Konstruktion","Erledigung bis","Maßnahme Fertigung","Erledigung bis","Maßnahme Vertrieb","Erledigung bis","Maßnahme QW","Erledigung bis","Maßnahme Versand","Erledigung bis","Maßnahme Sonstige","Erledigung bis","Postleitzahl","Anlieferung durch"]
[null,"Kundenreklamation",null,null,null,"Artikelgr. 1",{"$nulls":8},"Stück","H. Geers","Fertigungsfehler",null,"Ausschuss",null,null," ","  ",null," ",null," ",null," ",null," ",null," ",null," ",null," "]
[null,"Kundenreklamation Oberflächentechnik",null,null,null,"Artikelgr. 2",{"$nulls":8},"kg","M. Schröck","Montagefehler",null,"Nacharbeit im Haus",null,null,"Firma","Lieferant informieren, ",null,"FA überarbeiten, ",null,"Zeichnung ändern, ",null,"Nacharbeiten, ",null,"Abholung,",null,"Lieferant sperren, ",null,"Neuversand,",null,"Ware bleibt im Haus,"]
[null,"WE",null,null,null,"Artikelgr. 3",{"$nulls":8},"mm",null,"Schweißfehler",null,"Nacharbeit außer Haus",null,null,"Lieferant, ","Mängelrüge ohne Belastung erstellen, ",null,"neuen FA erstellen, ",null,"Zeichnung sperren, ",null,"Gemäss FA neuanfertigen, ",null,"Preisnachlaß,",null,"Lieferant Auditieren, ",null,"Teil versenden, ",null,"siehe Fehlerbeschreibung,"]
[null,"Fertigung",{"$nulls":12},"m",null,"Zeichnungsfehler",null,"Nacharbeit Lieferant",null,null,"Spedition, ","Mängelrüge mit Belastung erstellen, ",null,"neue BA erstellen, ",null,"Stückliste ändern, ",null,"Zum Versand bereitstellen, ",null,"Gutschrift erstellen, ",null,"Gutachten erstellen, ",null,"Zur Info ,",null,"Zur Info ,"]
[{"$nulls":14},"m²",null,"Planungsfehler",null,"Bauabweichung beantragen",null,null,"Versicherung, ","Neue Bestellung, ",null,"Stammdaten pflegen, ",null,"Stammdaten pflegen, ",null,"Reparatur ",null,"Wiederberechnen, ",null,"Nacharbeit prüfen, ",null," ",null," ",null,null," "]
[{"$nulls":14},"dm³",null,"Lieferantenfehler allgem.",null,"Einmalige Bauabweichung genehmigt",null,null,"Kulanz, ","Freigabe zur Nacharbeit einholen, ",null,"Fertigungsablauf und FA ändern, ",null,"Zur Info, ",null,"Zur Info ,",null,"Kunde informieren, ",null,"8-D-Report, "]
[{"$nulls":5}," ",{"$nulls":10},"Programmierfehler",null,"Neuversand",null,null,"Kunde,","Nacharbeitsaufwand ermitteln, ",null,"Zur Info, ",null," ",null,null,null,"Versicherung informieren, ",null,"Bauabweichung beantragen,"]
[{"$nulls":5}," ",{"$nulls":10},"Falsche Bestellung",null,"Neulieferung ohne \nBerechnung",null,null," ","Kaufmännische Regulierung,  ",null,"Zeichnungsänderung,",null," ",null,null,null,"Angebot erstellen, ",null,"Zur Info,"]
[{"$nulls":16},"Stücklistenfehler",null,"Neulieferung mit \nBerechnung",null,null,null,"Abholung veranlassen, ",null,"Material neu bestellen ,",{"$nulls":5},"Zur Info ,",null," "]
[{"$nulls":16},"Arbeitsplanfehler",null,"Reklamation nicht berechtigt",null,null,null,"Zur Info ,"]
[{"$nulls":16},"Falsche Handhabung",null,"Gesperrt"]
[{"$nulls":16},"Oberflächenfehler"]
[{"$nulls":16},"Transportschaden",{"$nulls":5}," "]
[{"$nulls":16},"Kommisionierfehler",{"$nulls":5}," ",{"$nulls":7},"Änderungen sollten hier nur von autorisierten Personen vorgenommen werden!"]
["Änderungen sollten hier nur von autorisierten Personen vorgenommen werden!",{"$nulls":15},"Eingabefehler",{"$nulls":4},"Änderungen sollten hier nur von autorisierten Personen vorgenommen werden!"]
[{"$nulls":10},"Änderungen sollten hier nur von autorisierten Personen vorgenommen werden!",{"$nulls":5},"Materialfehler"]
["Rücksetzen \"QM erstellen\": Zeile 25 bis 27 markieren, kopieren und in Zeile 20 einfügen"]
[]
[null,1,null,null,null,1,{"$nulls":8},1,2,12,null,8,null,null,4,2,null,10,null,1,null,6,null,1,null,8,null,1,null,1,null,null,5]
[{"$nulls":21},8,11,null,1,null,8,null,1,null,1,null,1,null,1,null,1]
[{"$nulls":21},1,12,null,1,null,1,null,null,null,1,null,1]
[{"$nulls":22},11,null,1,null,1,null,null,null,1]
[{"$nulls":26},"Änderungen sollten hier nur von autorisierten Personen vorgenommen werden!"]
[null,1,{"$nulls":12},7,5,16,null,8,null,null,1,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
[{"$nulls":21},1,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
[{"$nulls":21},1,1,null,1,null,1,null,null,null,1,null,1]
[{"$nulls":22},1,null,1,null,1,null,null,null,1]
[]
["Passwort für gesperrte Bereiche: geers"]