{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["process","SLP_Process","Hilfe - Help","checklist","Cycle time final","ST","DE_SLP","DE","ENG_SLP","Eng","SK_SLP","SK"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":47,"comments":6,"pivot_tables":0},"unopened":[{"sheet":"Cycle time final","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"process","index":0,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,16,0,17],[3,5,3,9],[4,5,4,9],[5,5,5,9],[6,5,6,9],[3,14,3,17],[4,14,4,17],[5,14,5,17],[6,14,6,17],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[51,0,51,4],[51,5,51,17],[50,0,50,17],[53,0,53,4],[53,5,53,17],[52,0,52,17],[9,5,9,7],[10,5,10,7],[7,5,7,6],[7,7,7,9],[49,0,49,17],[7,14,7,17]]}
["Key Information",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!O1,IF($P$1=\"DE\",DE!O1,SK!O1))","v":"Sprache==>"},"DE","Minebea Slovakia s.r.o.             "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peter Luksaj     ","2018-06-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"docu #","1209F"]
[{"$f":"IF($P$1=\"ENG\",Eng!A2,IF($P$1=\"DE\",DE!A2,SK!A2))","v":"PMDM Teilenummer"},{"$f":"IF($P$1=\"eng\",Eng!B2,DE!B2)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C2,DE!C2)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D2,DE!D2)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E2,DE!E2)","v":0},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!K2,IF($P$1=\"DE\",DE!K2,SK!K2))","v":"Lieferanten Kontakt Name"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A3,IF($P$1=\"DE\",DE!A3,SK!A3))","v":"PMDM Teilename"},{"$f":"IF($P$1=\"eng\",Eng!B3,DE!B3)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C3,DE!C3)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D3,DE!D3)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E3,DE!E3)","v":0},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!K3,IF($P$1=\"DE\",DE!K3,SK!K3))","v":"Lieferanten Kontakt Telefon Nummer"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A4,IF($P$1=\"DE\",DE!A4,SK!A4))","v":"Lieferanten Name"},{"$f":"IF($P$1=\"eng\",Eng!B4,DE!B4)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C4,DE!C4)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D4,DE!D4)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E4,DE!E4)","v":0},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!K4,IF($P$1=\"DE\",DE!K4,SK!K4))","v":"Lieferanten Kontakt EMAIL Adresse"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A5,IF($P$1=\"DE\",DE!A5,SK!A5))","v":"Produktionswerk ( Land, Stadt, etc..)"},{"$f":"IF($P$1=\"eng\",Eng!B5,DE!B5)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C5,DE!C5)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D5,DE!D5)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E5,DE!E5)","v":0},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!K5,IF($P$1=\"DE\",DE!K5,SK!K5))","v":"Kunde oder Lieferant beobachtet"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A6,IF($P$1=\"DE\",DE!A6,SK!A6))","v":"Lieferanten Nr.  /  Hersteller Duns Nr."},{"$f":"IF($P$1=\"eng\",Eng!B6,DE!B6)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C6,DE!C6)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D6,DE!D6)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E6,DE!E6)","v":0},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!K6,IF($P$1=\"DE\",DE!K6,SK!K6))","v":"PMDM  verantwortlich EMAIL Adresse"}]
[]
[{"$f":"IF($P$1=\"ENG\",Eng!A8,IF($P$1=\"DE\",DE!A8,SK!A8))","v":"Teile Nummer oder Prozess"},null,null,null,null,"process",null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!L8,IF($P$1=\"DE\",DE!L8,SK!L8))","v":"geplante "},{"$f":"IF($P$1=\"ENG\",Eng!M8,IF($P$1=\"DE\",DE!M8,SK!M8))","v":"Schichtzeit"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A9,IF($P$1=\"DE\",DE!A9,SK!A9))","v":"Teile Name oder Prozessname"},null,null,null,null,"process",null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!L9,IF($P$1=\"DE\",DE!L9,SK!L9))","v":"geplante "},{"$f":"IF($P$1=\"ENG\",Eng!M9,IF($P$1=\"DE\",DE!M9,SK!M9))","v":"Pausenzeit"},null,"min"]
[{"$f":"IF($P$1=\"ENG\",Eng!A10,IF($P$1=\"DE\",DE!A10,SK!A10))","v":"Ideale Zykluszeit [s]"},null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!G10,IF($P$1=\"DE\",DE!G10,SK!G10))","v":"effektive"},{"$f":"F12/F13/F14","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!L10,IF($P$1=\"DE\",DE!L10,SK!L10))","v":"geschätzte ungeplante"},{"$f":"IF($P$1=\"ENG\",Eng!M10,IF($P$1=\"DE\",DE!M10,SK!M10))","v":"Stillstandszeit"},null,"min"]
[{"$f":"IF($P$1=\"ENG\",Eng!A11,IF($P$1=\"DE\",DE!A11,SK!A11))","v":"Anzahl Teile je Zyklus"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!L11,IF($P$1=\"DE\",DE!L11,SK!L11))","v":"Anzahl "},{"$f":"IF($P$1=\"ENG\",Eng!M11,IF($P$1=\"DE\",DE!M11,SK!M11))","v":"Schichten/Tag"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A12,IF($P$1=\"DE\",DE!A12,SK!A12))","v":"Anzahl gleicher Werkzeuge / Maschinen"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!L12,IF($P$1=\"DE\",DE!L12,SK!L12))","v":"Arbeitstage"},{"$f":"IF($P$1=\"ENG\",Eng!M12,IF($P$1=\"DE\",DE!M12,SK!M12))","v":" / Woche"},null,null,{"$f":"IF($P$1=\"ENG\",Eng!P12,IF($P$1=\"DE\",DE!P12,SK!P12))","v":"notwendige Teilesätze"},{"$f":"Q15*(1+F15)","v":0},{"$f":"IF($P$1=\"ENG\",Eng!R12,IF($P$1=\"DE\",DE!R12,SK!R12))","v":"Stück/Woche"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A13,IF($P$1=\"DE\",DE!A13,SK!A13))","v":"Prozentsatz Ausschussteile"},null,null,null,null,null,null,{"$f":"IF($P$1=\"ENG\",Eng!H13,IF($P$1=\"DE\",DE!H13,SK!H13))","v":"Qualitätsrate"},{"$f":"1-F15","v":1},null,null,{"$f":"IF($P$1=\"ENG\",Eng!L13,IF($P$1=\"DE\",DE!L13,SK!L13))","v":"Anteil der Auslastung mit dieser "},{"$f":"IF($P$1=\"ENG\",Eng!M13,IF($P$1=\"DE\",DE!M13,SK!M13))","v":"Teilenummer"},{"$f":"LOOKUP(\"X\",SLP_Process!A12:A31,SLP_Process!H12:H31)","v":""},null,{"$f":"IF($P$1=\"ENG\",Eng!P13,IF($P$1=\"DE\",DE!P13,SK!P13))","v":"Angeforderte Kapazität"},null,{"$f":"IF($P$1=\"ENG\",Eng!R13,IF($P$1=\"DE\",DE!R13,SK!R13))","v":"Stück/Woche"}]
[]
[{"$f":"IF($P$1=\"ENG\",Eng!A15,IF($P$1=\"DE\",DE!A15,SK!A15))","v":"Datum"},{"$f":"IF($P$1=\"ENG\",Eng!B15,IF($P$1=\"DE\",DE!B15,SK!B15))","v":"Start Zeit"},{"$f":"IF($P$1=\"ENG\",Eng!C15,IF($P$1=\"DE\",DE!C15,SK!C15))","v":"Arbeitsende Zeit"},{"$f":"IF($P$1=\"ENG\",Eng!D15,IF($P$1=\"DE\",DE!D15,SK!D15))","v":"Arbeitszeit [min]"},{"$f":"IF($P$1=\"ENG\",Eng!E15,IF($P$1=\"DE\",DE!E15,SK!E15))","v":"Geplanter Stillstand [min] Pausen etc."},{"$f":"IF($P$1=\"ENG\",Eng!F15,IF($P$1=\"DE\",DE!F15,SK!F15))","v":"Hauptpause [min]"},{"$f":"IF($P$1=\"ENG\",Eng!G15,IF($P$1=\"DE\",DE!G15,SK!G15))","v":"Gut-Teile (Stück)"},{"$f":"IF($P$1=\"ENG\",Eng!H15,IF($P$1=\"DE\",DE!H15,SK!H15))","v":"Schlecht-Teile (Stück)"},{"$f":"IF($P$1=\"ENG\",Eng!I15,IF($P$1=\"DE\",DE!I15,SK!I15))","v":"Qualitätsrate"},{"$f":"IF($P$1=\"ENG\",Eng!J15,IF($P$1=\"DE\",DE!J15,SK!J15))","v":"Ungeplanter Stillstand (min)"},{"$f":"IF($P$1=\"ENG\",Eng!K15,IF($P$1=\"DE\",DE!K15,SK!K15))","v":"Umrüstzeiten \n(nur Information)"},{"$f":"IF($P$1=\"ENG\",Eng!L15,IF($P$1=\"DE\",DE!L15,SK!L15))","v":"Netto \nArbeitszeit pro Tag"},{"$f":"IF($P$1=\"ENG\",Eng!M15,IF($P$1=\"DE\",DE!M15,SK!M15))","v":"beobachtete effektive Zykluszeit"},{"$f":"IF($P$1=\"ENG\",Eng!N15,IF($P$1=\"DE\",DE!N15,SK!N15))","v":"errechnete Ausbringung in 0h Schichten/Tag mit Auslastungsfaktor"},{"$f":"IF($P$1=\"ENG\",Eng!O15,IF($P$1=\"DE\",DE!O15,SK!O15))","v":"Leistungs-\nEffizienz"},{"$f":"IF($P$1=\"ENG\",Eng!P15,IF($P$1=\"DE\",DE!P15,SK!P15))","v":"Anlagenverfüg- barkeit"},{"$f":"IF($P$1=\"ENG\",Eng!Q15,IF($P$1=\"DE\",DE!Q15,SK!Q15))","v":"Gesamt Anlagen Effizienz"},{"$f":"IF($P$1=\"ENG\",Eng!R15,IF($P$1=\"DE\",DE!R15,SK!R15))","v":"Vorhergesagte Gut-Teile pro Woche (gesamte Effizienz)"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A16,IF($P$1=\"DE\",DE!A16,SK!A16))","v":"Summe"},null,null,{"$f":"SUM(D19:D49)","v":0},{"$f":"SUM(E19:E49)","v":0},{"$f":"SUM(F19:F49)","v":0},{"$f":"SUM(G19:G49)","v":0},{"$f":"SUM(H19:H49)","v":0},{"$f":"IFERROR(1-(H18/(G18+H18)),\"-\")","v":"-"},{"$f":"SUM(J19:J49)","v":0},{"$f":"SUM(K19:K49)","v":0},{"$f":"SUM(L19:L49)/COUNT(B19:B49)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR((L18*3600)/(G18+H18),\"-\")*COUNT(B19:B49)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(((((($N$10*60)-$N$11-$N$12)*60)/M18)*$N$13)*$N$15,\"-\")","v":"-"},{"$f":"IFERROR(($H$12/M18),\"-\")","v":"-"},{"$f":"IFERROR(1-(J18/(D18-E18-F18)),\"-\")","v":"-"},{"$f":"IFERROR(I18*O18*P18,\"-\")","v":"-"},{"$f":"IFERROR((($N$10*60-$N$11-$N$12)*60/$H$12*Q18)*$N$14*$N$13*$N$15,\"-\")","v":"-"}]
["2015-10-20",null,null,{"$f":"IFERROR(((C19-B19)*24*60),\"-\")","v":0},null,null,null,null,"-",null,null,{"$f":"(D19-E19-F19-J19)/60","v":0},{"$f":"IFERROR((L19*3600)/(G19+H19),\"-\")","v":"-"},{"$f":"IFERROR(((((($N$10*60)-$N$11-$N$12)*60)/M19)*$N$13)*$N$15,\"-\")","v":"-"},{"$f":"IFERROR(($H$12/M19),\"-\")","v":"-"},{"$f":"IFERROR(1-J19/(D19-E19-F19),\"-\")","v":"-"},{"$f":"IFERROR(I19*O19*P19,\"-\")","v":"-"},{"$f":"IFERROR((($N$10*60-$N$11-$N$12)*60/$H$12*Q19)*$N$14*$N$13*$N$15,\"-\")","v":"-"}]
[{"$f":"A19+1","v":"2015-10-21"},null,null,0,null,null,null,null,"-",null,null,{"$f":"(D20-E20-F20-J20)/60","v":0},{"$f":"IFERROR((L20*3600)/(G20+H20),\"-\")","v":"-"},"-","-",{"$f":"IFERROR(1-J20/(D20-E20-F20),\"-\")","v":"-"},"-","-"]
[{"$f":"A20+1","v":"2015-10-22"},null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-23",null,null,0,null,null,null,null,"-",null,null,0,"-","-",{"$f":"IFERROR(($H$12/M22),\"-\")","v":"-"},{"$f":"IFERROR(1-J22/(D22-E22-F22),\"-\")","v":"-"},"-","-"]
["2015-10-24",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-25",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-26",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-27",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-28",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-29",null,null,0,null,null,null,null,{"$f":"IFERROR(1-(H28/(G28+H28)),\"-\")","v":"-"},null,null,0,"-","-","-",{"$f":"IFERROR((L28/(((C28-B28)*24*60-E28-F28)/60)),\"-\")","v":"-"},"-","-"]
["2015-10-30",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-10-31",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-01",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-02",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-03",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-04",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-05",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-06",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-07",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-08",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-09",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-10",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-11",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-12",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-13",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-14",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-15",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-16",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-17",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-18",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
["2015-11-19",null,null,0,null,null,null,null,"-",null,null,0,"-","-","-","-","-","-"]
[]
[{"$f":"IF($P$1=\"ENG\",Eng!A66,IF($P$1=\"DE\",DE!A66,SK!A66))","v":"Lieferant"},{"$f":"IF($P$1=\"eng\",Eng!B66,DE!B66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!C66,DE!C66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!D66,DE!D66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!E66,DE!E66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!F66,DE!F66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!G66,DE!G66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!H66,DE!H66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!I66,DE!I66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!J66,DE!J66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!K66,DE!K66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!L66,DE!L66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!M66,DE!M66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!N66,DE!N66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!O66,DE!O66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!P66,DE!P66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!Q66,DE!Q66)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!R66,DE!R66)","v":"00:00:00"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A67,IF($P$1=\"DE\",DE!A67,SK!A67))","v":"rechtlich verbindliche Unterschrift          "},{"$f":"IF($P$1=\"eng\",Eng!B67,DE!B67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C67,DE!C67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D67,DE!D67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E67,DE!E67)","v":0},{"$f":"IF($P$1=\"ENG\",Eng!F67,IF($P$1=\"DE\",DE!F67,SK!F67))","v":"Datum / Stempel / Unterschrift"},{"$f":"IF($P$1=\"eng\",Eng!G67,DE!G67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!H67,DE!H67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!I67,DE!I67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!J67,DE!J67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!K67,DE!K67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!L67,DE!L67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!M67,DE!M67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!N67,DE!N67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!O67,DE!O67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!P67,DE!P67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!Q67,DE!Q67)","v":0},{"$f":"IF($P$1=\"eng\",Eng!R67,DE!R67)","v":0}]
[{"$f":"IF($P$1=\"ENG\",Eng!A68,IF($P$1=\"DE\",DE!A68,SK!A68))","v":"Run @ Rate Bestätigung"},{"$f":"IF($P$1=\"eng\",Eng!B68,DE!B68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!C68,DE!C68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!D68,DE!D68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!E68,DE!E68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!F68,DE!F68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!G68,DE!G68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!H68,DE!H68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!I68,DE!I68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!J68,DE!J68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!K68,DE!K68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!L68,DE!L68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!M68,DE!M68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!N68,DE!N68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!O68,DE!O68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!P68,DE!P68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!Q68,DE!Q68)","v":"00:00:00"},{"$f":"IF($P$1=\"eng\",Eng!R68,DE!R68)","v":"00:00:00"}]
[{"$f":"IF($P$1=\"ENG\",Eng!A69,IF($P$1=\"DE\",DE!A69,SK!A69))","v":"Unterschrift PMDM SQE oder QA"},{"$f":"IF($P$1=\"eng\",Eng!B69,DE!B69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!C69,DE!C69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!D69,DE!D69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!E69,DE!E69)","v":0},{"$f":"IF($P$1=\"ENG\",Eng!F69,IF($P$1=\"DE\",DE!F69,SK!F69))","v":"Datum / Kostenstelle / Unterschrift"},{"$f":"IF($P$1=\"eng\",Eng!G69,DE!G69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!H69,DE!H69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!I69,DE!I69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!J69,DE!J69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!K69,DE!K69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!L69,DE!L69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!M69,DE!M69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!N69,DE!N69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!O69,DE!O69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!P69,DE!P69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!Q69,DE!Q69)","v":0},{"$f":"IF($P$1=\"eng\",Eng!R69,DE!R69)","v":0}]

{"sheet":"SLP_Process","index":1,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,7],[1,0,8,0],[1,3,1,7],[2,1,2,2],[2,3,2,7],[3,1,3,2],[3,3,3,7],[4,1,4,2],[1,1,1,2],[35,1,35,7],[4,3,4,7],[5,1,5,2],[5,3,5,7],[6,1,6,2],[6,3,6,7],[7,1,7,2],[7,3,7,7],[8,1,8,2],[8,3,8,7],[9,1,9,2],[33,1,33,5],[9,3,9,5]]}
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B1,IF(process!$P$1=\"DE\",DE_SLP!B1,SK_SLP!B1))","v":"Belegungsplan"},null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D1,IF(process!$P$1=\"DE\",DE_SLP!D1,SK_SLP!D1))","v":"process"}]
[{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!A2,IF(process!$P$1=\"DE\",DE_SLP!A2,SK_SLP!A2))","v":"Markiere mit X eine der zwanzig Zeile zur Kennzeichnung welches Produkt analysiert wird mit R @ R"},null,null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D2,IF(process!$P$1=\"DE\",DE_SLP!D2,SK_SLP!D2))","v":"Abteilungszeitmodell"}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B3,IF(process!$P$1=\"DE\",DE_SLP!B3,SK_SLP!B3))","v":"Stunden / Schicht"},null,{"$f":"process!N10","v":0}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B4,IF(process!$P$1=\"DE\",DE_SLP!B4,SK_SLP!B4))","v":"Geplante Unterbrechung -Pausen, Besprechung  etc. (min /Schicht) "},null,{"$f":"process!N11","v":0}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B5,IF(process!$P$1=\"DE\",DE_SLP!B5,SK_SLP!B5))","v":"geschätzte ungeplante Unterbrechung (min / Schicht) "},null,{"$f":"process!N12","v":0}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B6,IF(process!$P$1=\"DE\",DE_SLP!B6,SK_SLP!B6))","v":"Schichten  / Tag"},null,{"$f":"process!N13","v":0}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B7,IF(process!$P$1=\"DE\",DE_SLP!B7,SK_SLP!B7))","v":"Tage / Woche"},null,{"$f":"process!N14","v":0}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B8,IF(process!$P$1=\"DE\",DE_SLP!B8,SK_SLP!B8))","v":"Netto verfügbare Zeit  (NAT)\n (Std / Woche)"},null,{"$f":"IF(D7*D6*D3>0,D7*D6*D3-(D7*D6*(D5+D4)/60),\"\")","v":""}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B9,IF(process!$P$1=\"DE\",DE_SLP!B9,SK_SLP!B9))","v":"Geschätze Anlagen Effizienz (OEE = Overall Equipment Effectiveness): \nEingabe eines Mittelwertes der Effizienz von aktuellen Daten oder historische Produktionsleistung kann für diese Berechnung verwendet werden"},null,0.85]
[{"$f":"IF(COUNTA(A11:A30)=1,\"Part \"&LOOKUP(\"X\",A12:A30,B12:B31)&\" marked for Analysis\",\"Mark one part per process\")","v":"Part 1 marked for Analysis"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B10,IF(process!$P$1=\"DE\",DE_SLP!B10,SK_SLP!B10))","v":"Überlastet"},null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D10,IF(process!$P$1=\"DE\",DE_SLP!D10,SK_SLP!D10))","v":"Auslastungsplan"},null,null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!G10,IF(process!$P$1=\"DE\",DE_SLP!G10,SK_SLP!G10))","v":"Maschine / Anlage \nnur für ein Modell"}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B11,IF(process!$P$1=\"DE\",DE_SLP!B11,SK_SLP!B11))","v":"Part"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C11,IF(process!$P$1=\"DE\",DE_SLP!C11,SK_SLP!C11))","v":"PMDM Teile # oder   \"nicht-PMDM\""},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D11,IF(process!$P$1=\"DE\",DE_SLP!D11,SK_SLP!D11))","v":"geforderte \nGut-Teile / Woche"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!E11,IF(process!$P$1=\"DE\",DE_SLP!E11,SK_SLP!E11))","v":"Netto ideale Zykuszeit (s/Stück) "},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!F11,IF(process!$P$1=\"DE\",DE_SLP!F11,SK_SLP!F11))","v":"geschätze Zeit bei OEE (Std/Woche)"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!G11,IF(process!$P$1=\"DE\",DE_SLP!G11,SK_SLP!G11))","v":"Rüstzeit (min/Woche)"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!H11,IF(process!$P$1=\"DE\",DE_SLP!H11,SK_SLP!H11))","v":"% Verteilung\nMindest- anforderung"}]
["X",1,null,null,null,{"$f":"IF(OR(D12=0,E12=0,D$9=0),\"\",(D12*E12/3600)/D$9)","v":""},null,{"$f":"IF(OR(F12=\"\",D$8=\"\"),\"\",F12/D$8)","v":""}]
[null,2,null,null,null,{"$f":"IF(OR(D13=0,E13=0,D$9=0),\"\",(D13*E13/3600)/D$9)","v":""},null,""]
[null,3,null,null,null,"",null,""]
[null,4,null,null,null,"",null,""]
[null,5,null,null,null,"",null,""]
[null,6,null,null,null,"",null,""]
[null,7,null,null,null,"",null,""]
[null,8,null,null,null,"",null,""]
[null,9,null,null,null,"",null,""]
[null,10,null,null,null,"",null,""]
[null,11,null,null,null,"",null,""]
[null,12,null,null,null,"",null,""]
[null,13,null,null,null,"",null,""]
[null,14,null,null,null,"",null,""]
[null,15,null,null,null,"",null,""]
[null,16,null,null,null,"",null,""]
[null,17,null,null,null,"",null,""]
[null,18,null,null,null,"",null,""]
[null,19,null,null,null,"",null,""]
[null,20,null,null,null,"",null,""]
[null,21,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C32,IF(process!$P$1=\"DE\",DE_SLP!C32,SK_SLP!C32))","v":"Other % Allocation - Description"}]
[null,22,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C33,IF(process!$P$1=\"DE\",DE_SLP!C33,SK_SLP!C33))","v":"Other % Allocation - Description"}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B34,IF(process!$P$1=\"DE\",DE_SLP!B34,SK_SLP!B34))","v":"Prozentsatz von nicht Produktionszeiten aus verfügbarer Zeit (Besprechung etc.)"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C34,DE_SLP!C34)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D34,DE_SLP!D34)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!E34,DE_SLP!E34)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!F34,DE_SLP!F34)","v":0}]
[null,null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C35,IF(process!$P$1=\"DE\",DE_SLP!C35,SK_SLP!C35))","v":"Summe der prozentualen Belegung"},{"$f":"IF(SUM(D$12:D$32)>0,SUM(D$12:D$32),\"\")","v":""},null,{"$f":"IF(SUM(F$12:F$33)>0,SUM(F$12:F$32),\"\")","v":""},{"$f":"IF(SUM(G$12:G$32)>0,SUM(G$12:G$32),\"\")","v":""},{"$f":"IF(SUM(H$12:H$34)>0,SUM(H$12:H$34),\"\")","v":""}]
[null,{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!B36,IF(process!$P$1=\"DE\",DE_SLP!B36,SK_SLP!B36))","v":"Wenn Summe der prozentualen Verteilung > 100% ==>Belegungsplan übersteigt Kapazität"},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!C36,DE_SLP!C36)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!D36,DE_SLP!D36)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!E36,DE_SLP!E36)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!F36,DE_SLP!F36)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!G36,DE_SLP!G36)","v":0},{"$f":"IF(process!$P$1=\"ENG\",ENG_SLP!H36,DE_SLP!H36)","v":0}]

{"sheet":"Hilfe - Help","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
[]
[]
[null,"RUN @ RATE"]
[]
[null,"Links zu den Hilfedateien",null,null,"Links to help files"]
[]
[]
[null,"Handbuch Run@Rate Prozess",null,null,"Manual for Run@Rate process (English behind the German description)"]
[null,"Eingabeanforderungen im Dokument",null,null,"Document entry requirements"]
[null,"Run@Rate Basisinformationen",null,null,"Run@Rate Basic information's"]
[null,"Datenblatt zur erweiterten Datenerfassung",null,null,"Data record sheet for additional data"]
[]
[]
[null,"Bitte unbedingt Makro's activieren. ",null,null,"Please activate the macro function"]
[null,"Um das Dokument zu sichern unbedingt",null,null,"For saving it is absolute necessary to "]
[null,"unter ?????.xlsm speichern",null,null,"use the ?????.xlsm format"]

{"sheet":"checklist","index":3,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,1,17,3],[10,1,10,3],[12,1,12,3],[13,1,13,3],[15,1,15,3],[16,1,16,3],[11,1,11,3],[14,1,14,3],[7,1,7,3],[0,0,0,3],[2,0,2,3],[4,0,4,3],[5,1,5,3],[6,0,6,3],[37,2,37,3],[38,0,38,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[30,2,30,3],[18,1,18,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3]]}
["Kapaztätsüberprüfung \nCapacity check \nKontrolný list\n (Run @ Rate)"]
[]
["Checkliste\nChecklist\nKontrolný list"]
[]
["Teilenummer\nPart number\nČíslo dielu"]
[]
["Lieferant \nSupplier\nDodávateľ"]
[]
[]
["Bewertungsinhalt / content of review/ obsah prehľadu:"]
[null,"Sicherstellung, dass die Ergebnisse des tatsächlichen Herstellungsprozesses den Anforderungen in Bezug auf eine gleichbleibende Qualität entsprechen, die geplante Kapazität vorhanden ist und die Ausbringung erreicht wird."]
[null,"Verification, that the results of the actual manufacturing process meet the requirements for an on-going quality, that the quoted capacity really exists and that the output will be achieved"]
[null,"Overenie, či výsledky aktuálneho výrobného procesu spĺňajú požiadavky na prebiehajúcu kvalitu, či kótovaná kapacita skutočne existuje a či bude výstup dosiahnutý"]
[null,"Sicherstellung, dass der tatsächliche Prozessablauf plangemäß erfolgt, wie in QS 9000 / PPAP oder VDA und der nachfolgend aufgeführten Dokumentation beschrieben."]
[null,"Verification, that the actual process flow is according to plan, as documented in QS 9000 / PPAP or VDA and the documentation listed below"]
[null,"Overenie, či skutočný tok procesu je podľa plánu, ako je dokumentované v QS 9000 / PPAP alebo VDA a dokumentácii uvedenej nižšie"]
[null,"Punkte der Überprüfung sind: Dokumentation, Herstellungsprozesse und Ergebnisse, Anforderungen und Ergebnisse der Teilequalität, die Run @ Rate Ergebnisse von Unterlieferanten sowie die Verpackung."]
[null,"Points of review are: documentation, manufacturing process and results, part quality requirements and results, sub-supplier requirements and Run @ Rate results as well as packaging"]
[null,"Body prehľadu sú: dokumentácia, výrobný proces a výsledky, požiadavky na kvalitu dielu a výsledky, požiadavky subdodávateľov a výsledky Run @ Rate, ako aj balenie"]
[]
["Dokumentation / documentation / dokumentácia"]
["Im Verlauf des Run @ Rate muss folgende Dokumentation fur die Bewertung zur Verfügung stehen: "]
["At the time of the Run @ Rate the following support documentation has to be available for review:"]
["V čase Run @ Rate musí byť k nahliadnutiu k dispozícii nasledovná podporná dokumentácia:"]
[null,null,"Vorhanden* / available* / Dostupné *"]
[null,"n/a","Ja / Yes","Nein / No"]
[null,null,"Ja/Yes/Ano  or  Nein/No/Nie"]
[1,"Bemusterungs-Unterlagen einschließlich\nPPAP package including\nPPAP dokumentácia vrátane"]
[null,"Prozessflussdiagramm\nprocess flow diagram\nprocesná mapa"]
[null,"Prozesskontrollplan mit Reaktionsplan \nprocess control plan with reaction plan\nprocesný plán kontroly s reakčným plánom"]
[null,"PFMEA und DFMEA (sofern Konstruktion nicht von PMDM)\nPFMEA and DFMEA (if design is not made by PMDM)\nPFMEA a DFMEA (ak návrh nie je vytvorený PMDM)"]
[null,"Referenzteil(e)\nmaster part(s)\nvzorové diel(y)"]
[2,"Informationen über Werkzeugkapazitäten\ntool capacity information\ninformácie o kapacite nástroja"]
[3,"Arbeits- -und Prüfanweisungen\noperator and inspection instructions\npokyny pre obsluhu a kontrolu"]
[4,"Unterlagen aus Muster- und Vorserienphase\ndocumentation prototype and pilot production\nprototyp dokumentácie a pilotná výroba"]
[5,"Kontroll-/ Kapazitätsdaten der Unterlieferanten\nsub-contractor control / capacity data\núdaje o kontrole / kapacite subdodávateľov"]
[6,"Verpackungs- und  Etikettierungsplan\npackaging and labeling plan\nplán balenia a označovania"]
[7,"Produktionsanlaufplan\nramp up plan\nplán rozbehu"]
["* Entsprechendes auswählen\nplease select the matching one\nvyberte príslušnú odpoveď"]

{"sheet":"ST","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Name","Index",{"$f":"SUBTOTAL(2,B2:B501)","v":4}]
["SLP_Process_final",1]
["SLP_Process_001",2]
["process_final",3]
["process_001",4]
["Hilfe - Help",5]
["checklist",6]
["Cycle time final",7]
["ST",8]
["DE_SLP",9]
["ENG_SLP",10]
["DE",11]
["Eng",12]

{"sheet":"DE_SLP","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[35,1,35,7],[4,3,4,7],[5,1,5,2],[5,3,5,7],[6,1,6,2],[6,3,6,7],[7,1,7,2],[7,3,7,7],[8,1,8,2],[8,3,8,7],[9,1,9,2],[33,1,33,5],[9,3,9,5],[0,1,0,2],[0,3,0,7],[1,0,8,0],[1,1,1,2],[1,3,1,7],[2,1,2,2],[2,3,2,7],[3,1,3,2],[3,3,3,7],[4,1,4,2]]}
[null,"Belegungsplan",null,{"$f":"process!F10","v":"process"}]
["Markiere mit X eine der zwanzig Zeile zur Kennzeichnung welches Produkt analysiert wird mit R @ R",null,null,"Abteilungszeitmodell"]
[null,"Stunden / Schicht",null,{"$f":"process!N10","v":0}]
[null,"Geplante Unterbrechung -Pausen, Besprechung  etc. (min /Schicht) ",null,{"$f":"process!N11","v":0}]
[null,"geschätzte ungeplante Unterbrechung (min / Schicht) ",null,{"$f":"process!N12","v":0}]
[null,"Schichten  / Tag",null,{"$f":"process!N13","v":0}]
[null,"Tage / Woche",null,{"$f":"process!N14","v":0}]
[null,"Netto verfügbare Zeit  (NAT)\n (Std / Woche)",null,{"$f":"IF(D7*D6*D3>0,D7*D6*D3-(D7*D6*(D5+D4)/60),\"\")","v":""}]
[null,"Geschätze Anlagen Effizienz (OEE = Overall Equipment Effectiveness): \nEingabe eines Mittelwertes der Effizienz von aktuellen Daten oder historische Produktionsleistung kann für diese Berechnung verwendet werden",null,0.85]
[{"$f":"IF(COUNTA(A11:A30)=1,\"Part \"&LOOKUP(\"X\",A11:A30,B12:B31)&\" Kennzeichnung für Analyse  marked for Analysis\",\"Nur ein Teil je Prozess   Mark one part per process\")","v":"Part 5 Kennzeichnung für Analyse  marked for Analysis"},"Überlastet",null,"Auslastungsplan",null,null,"Maschine / Anlage \nnur für ein Modell"]
[null,"Part","PMDM Teile # oder   \"nicht-PMDM\"","geforderte \nGut-Teile / Woche","Netto ideale Zykuszeit (s/Stück) ","geschätze Zeit bei OEE (Std/Woche)","Rüstzeit (min/Woche)","% Verteilung\nMindest- anforderung"]
[null,1]
[null,2]
[null,3]
["X",4]
[null,5]
[null,6]
[null,7,null,null,null,{"$f":"IF(OR(D18=0,E18=0,D$9=0),\"\",(D18*E18/3600)/D$9)","v":""},null,{"$f":"IF(OR(F18=\"\",D$8=\"\"),\"\",F18/D$8)","v":""}]
[null,8,null,null,null,"",null,""]
[null,9,null,null,null,"",null,""]
[null,10,null,null,null,"",null,""]
[null,11,null,null,null,"",null,""]
[null,12,null,null,null,"",null,""]
[null,13,null,null,null,"",null,""]
[null,14,null,null,null,"",null,""]
[null,15,null,null,null,"",null,""]
[null,16,null,null,null,"",null,""]
[null,17,null,null,null,"",null,""]
[null,18,null,null,null,"",null,""]
[null,19,null,null,null,"",null,""]
[null,20,null,null,null,"",null,""]
[null,21,"Other % Allocation - Description"]
[null,22,"Other % Allocation - Description"]
[null,"Prozentsatz von nicht Produktionszeiten aus verfügbarer Zeit (Besprechung etc.)"]
[null,null,"Summe der prozentualen Belegung",{"$f":"IF(SUM(D$12:D$32)>0,SUM(D$12:D$32),\"\")","v":""},null,{"$f":"IF(SUM(F$12:F$32)>0,SUM(F$12:F$32),\"\")","v":""},{"$f":"IF(SUM(G$12:G$32)>0,SUM(G$12:G$32),\"\")","v":""},{"$f":"IF(SUM(H$12:H$32)>0,SUM(H$12:H$34),\"\")","v":""}]
[null,"Wenn Summe der prozentualen Verteilung > 100% ==>Belegungsplan übersteigt Kapazität"]

{"sheet":"DE","index":7,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":true,"merged":[[66,5,66,17],[67,0,67,17],[5,14,5,17],[68,0,68,4],[68,5,68,17],[66,0,66,4],[1,5,1,9],[1,14,1,17],[2,5,2,9],[2,14,2,17],[3,5,3,9],[3,14,3,17],[4,5,4,9],[4,14,4,17],[5,5,5,9],[7,4,7,7],[65,0,65,17]]}
["Key Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprache==>"]
["PMDM Teilenummer",null,null,null,null,null,null,null,null,null,"Lieferanten Kontakt Name"]
["PMDM Teilename",null,null,null,null,null,null,null,null,null,"Lieferanten Kontakt Telefon Nummer"]
["Lieferanten Name",null,null,null,null,null,null,null,null,null,"Lieferanten Kontakt EMAIL Adresse"]
["Produktionswerk ( Land, Stadt, etc..)",null,null,null,null,null,null,null,null,null,"Kunde oder Lieferant beobachtet"]
["Lieferanten Nr.  /  Hersteller Duns Nr.",null,null,null,null,null,null,null,null,null,"PMDM  verantwortlich EMAIL Adresse"]
[]
["Teile Nummer oder Prozess",null,null,null,null,null,null,null,null,null,null,"geplante ","Schichtzeit",{"$f":"process!N10","v":0}]
["Teile Name oder Prozessname",null,null,null,null,null,null,null,null,null,null,"geplante ","Pausenzeit",{"$f":"process!N11","v":0}]
["Ideale Zykluszeit [s]",null,null,null,null,null,"effektive",null,null,null,null,"geschätzte ungeplante","Stillstandszeit",{"$f":"process!N12","v":0}]
["Anzahl Teile je Zyklus",null,null,null,null,null,null,null,null,null,null,"Anzahl ","Schichten/Tag"]
["Anzahl gleicher Werkzeuge / Maschinen",null,null,null,null,null,null,null,null,null,null,"Arbeitstage"," / Woche",null,null,"notwendige Teilesätze",null,"Stück/Woche"]
["Prozentsatz Ausschussteile",null,null,null,null,null,null,"Qualitätsrate",null,null,null,"Anteil der Auslastung mit dieser ","Teilenummer",null,null,"Angeforderte Kapazität",null,"Stück/Woche"]
[]
["Datum","Start Zeit","Arbeitsende Zeit","Arbeitszeit [min]","Geplanter Stillstand [min] Pausen etc.","Hauptpause [min]","Gut-Teile (Stück)","Schlecht-Teile (Stück)","Qualitätsrate","Ungeplanter Stillstand (min)","Umrüstzeiten \n(nur Information)","Netto \nArbeitszeit pro Tag","beobachtete effektive Zykluszeit",{"$f":"\"errechnete Ausbringung in \" &N8& \"h Schichten/Tag mit Auslastungsfaktor\"","v":"errechnete Ausbringung in 0h Schichten/Tag mit Auslastungsfaktor"},"Leistungs-\nEffizienz","Anlagenverfüg- barkeit","Gesamt Anlagen Effizienz","Vorhergesagte Gut-Teile pro Woche (gesamte Effizienz)"]
["Summe"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Lieferant"]
["rechtlich verbindliche Unterschrift          ",null,null,null,null,"Datum / Stempel / Unterschrift"]
["Run @ Rate Bestätigung"]
["Unterschrift PMDM SQE oder QA",null,null,null,null,"Datum / Kostenstelle / Unterschrift"]

{"sheet":"ENG_SLP","index":8,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[35,1,35,7],[4,3,4,7],[5,1,5,2],[5,3,5,7],[6,1,6,2],[6,3,6,7],[7,1,7,2],[7,3,7,7],[8,1,8,2],[8,3,8,7],[9,1,9,2],[33,1,33,5],[9,3,9,5],[0,1,0,2],[0,3,0,7],[1,0,8,0],[1,1,1,2],[1,3,1,7],[2,1,2,2],[2,3,2,7],[3,1,3,2],[3,3,3,7],[4,1,4,2]]}
[null,"Shared Loading Plan",null,{"$f":"process!F10","v":"process"}]
["Type the letter 'X' in one of the twenty cells below to identify the part that is  analyzed during \nR @ R.",null,null,"Departmental Operating Pattern "]
[null,"Total Hours / Shift"]
[null,"Planned Downtime - lunch, breaks, etc. (minutes/shift) "]
[null,"Estimated Unplanned Downtime (minutes/shift) "]
[null,"Shifts / Day"]
[null,"Days / Week"]
[null,"Net Available Time (NAT)\n (hrs/week)",null,{"$f":"IF(D7*D6*D3>0,D7*D6*D3-(D7*D6*(D5+D4)/60),\"\")","v":""}]
[null,"Estimated OEE (Overall Equipment Effectiveness): \nEnter average OEE from most recent production performance data; Historical Mfg Performance may be used for this calculation"]
[{"$f":"IF(COUNTA(A11:A30)=1,\"Part \"&LOOKUP(\"X\",A11:A30,B12:B31)&\" marked for Analysis\",\"Mark one part per process\")","v":"Part 5 marked for Analysis"},"overloaded",null,"Loading Plan ",null,null,"machine /  production line \nonly for one model "]
[null,"Part","PMDM Part # or \"Non-PMDM\"","Req'd Good Parts / Week","Net Ideal Cycle Time (sec/part) ","Time Req'd @ Estimated OEE (hrs/week)","Changeover Time (min/week)","% Allocation\nMinimum Required"]
[null,1,null,null,null,{"$f":"IF(OR(D12=0,E12=0,D$9=0),\"\",(D12*E12/3600)/D$9)","v":""},null,{"$f":"IF(OR(F12=\"\",D$8=\"\"),\"\",F12/D$8)","v":""}]
[null,2,null,null,null,{"$f":"IF(OR(D13=0,E13=0,D$9=0),\"\",(D13*E13/3600)/D$9)","v":""},null,""]
[null,3,null,null,null,"",null,""]
["X",4,null,null,null,"",null,""]
[null,5,null,null,null,"",null,""]
[null,6,null,null,null,"",null,""]
[null,7,null,null,null,"",null,""]
[null,8,null,null,null,"",null,""]
[null,9,null,null,null,"",null,""]
[null,10,null,null,null,"",null,""]
[null,11,null,null,null,"",null,""]
[null,12,null,null,null,"",null,""]
[null,13,null,null,null,"",null,""]
[null,14,null,null,null,"",null,""]
[null,15,null,null,null,"",null,""]
[null,16,null,null,null,"",null,""]
[null,17,null,null,null,"",null,""]
[null,18,null,null,null,"",null,""]
[null,19,null,null,null,"",null,""]
[null,20,null,null,null,"",null,""]
[null,21,"Other % Allocation - Description"]
[null,22,"Other % Allocation - Description"]
[null,"Percentage of Net Available Time not utilized for production (%) {PM, etc.}"]
[null,null,"Total % Allocation",{"$f":"IF(SUM(D$12:D$32)>0,SUM(D$12:D$32),\"\")","v":""},null,{"$f":"IF(SUM(F$12:F$32)>0,SUM(F$12:F$32),\"\")","v":""},{"$f":"IF(SUM(G$12:G$32)>0,SUM(G$12:G$32),\"\")","v":""},{"$f":"IF(SUM(H$12:H$32)>0,SUM(H$12:H$34),\"\")","v":""}]
[null,"If Total % Allocation > 100%, loading plan exceeds capacity"]

{"sheet":"Eng","index":9,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":true,"merged":[[65,0,65,17],[4,5,4,9],[4,14,4,17],[5,5,5,9],[5,14,5,17],[7,4,7,7],[1,5,1,9],[1,14,1,17],[2,5,2,9],[2,14,2,17],[3,5,3,9],[3,14,3,17],[66,0,66,4],[66,5,66,17],[67,0,67,17],[68,0,68,4],[68,5,68,17]]}
["Key Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Language ==>"]
["PMDM Part Number",null,null,null,null,null,null,null,null,null,"Supplier Contact Name"]
["PMDM Part Name",null,null,null,null,null,null,null,null,null,"Supplier Contact Phone #"]
["Supplier Name",null,null,null,null,null,null,null,null,null,"Supplier Contact Email"]
["Plant Location ( Country, City, etc..)",null,null,null,null,null,null,null,null,null,"Customer or Supplier Monitored"]
["Vendor No.  /  Manufacturing Duns No.",null,null,null,null,null,null,null,null,null,"PMDM Representative Name"]
[]
["Part Number or Process",null,null,null,null,null,null,null,null,null,null,"Planned","Shift hours",{"$f":"process!N10","v":0}]
["Part Name or Processname",null,null,null,null,null,null,null,null,null,null,"Planned","Break time",{"$f":"process!N11","v":0}]
["Ideal Cycle Time [sec]",null,null,null,null,null,"effective",null,null,null,null,"Estimated unplanned","downtime",{"$f":"process!N12","v":0}]
["Number of Parts per Cycle",null,null,null,null,null,null,null,null,null,null,"Number","of Shifts/Day"]
["Numbers comparable Tools / Machines",null,null,null,null,null,null,null,null,null,null,"Working days"," / Week",null,null,"Required Incoming Parts",null,"pcs/week"]
["Percent of parts scrapped",null,null,null,null,null,null,"Quality Rate",null,null,null,"Percentage of loading with","this Part Number",null,null,"Required Capacity",null,"pcs/week"]
[]
["Date","Start Time","End Time","Working Time [min]"," Planned Downtime [min] Breaks etc.","lunch Break etc. [min] ","OK Parts\n(pcs)","NG Parts \n(pcs)","Quality Rate [%]","Unplanned Downtime (min)","Changeover times\n(for information)","Net Working Time per Day [h]","Observed Effective Cycle Time",{"$f":"\"Calculated output quantity  \" &N8& \"h shifts/day  with loading factor\"","v":"Calculated output quantity  0h shifts/day  with loading factor"},"Performance Efficiency","Equipment Availability","Overall Equipment \nEffectiveness (OEE)","Predicted Good Parts per week by OEE"]
["total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Supplier"]
["legally binding signature             ",null,null,null,null,"date / stamp / signature"]
["Run @ Rate Confirmation"]
["signature PMDM–SQE or QA",null,null,null,null,"date / costcenter / signature"]

{"sheet":"SK_SLP","index":10,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,3,0,7],[1,0,8,0],[1,1,1,2],[1,3,1,7],[2,1,2,2],[2,3,2,7],[3,1,3,2],[3,3,3,7],[4,1,4,2],[35,1,35,7],[4,3,4,7],[5,1,5,2],[5,3,5,7],[6,1,6,2],[6,3,6,7],[7,1,7,2],[7,3,7,7],[8,1,8,2],[8,3,8,7],[9,1,9,2],[9,3,9,5],[33,1,33,5]]}
[null,"Zdieľaný Plán plnenia",null,{"$f":"process!F10","v":"process"}]
["Zadajte písmeno \"X\" v jednom z dvadsiatich buniek nižšie, aby ste identifikovali časť, ktorá sa analyzuje počas\nR @ R.",null,null,"Pracovný model oddelenia"]
[null,"Total Hodiny / Zmena"]
[null,"Planované prestávky - obed, pauza, atď. (minuty/zmena) "]
[null,"Neplánované prestoje \n(minuty/zmena) "]
[null,"Zmeny / Deň"]
[null,"Dni / Týždeň"]
[null,"Čistý dostupný čas (NAT)\n (hodiny/týždeň)",null,{"$f":"IF(D7*D6*D3>0,D7*D6*D3-(D7*D6*(D5+D4)/60),\"\")","v":""}]
[null,"Odhadované OEE (celková efektívnosť vybavenia):\nZadajte priemerné OEE z najnovších údajov o výkonnosti výroby; Pre tento výpočet možno použiť historický výkon Mfg"]
[{"$f":"IF(COUNTA(A12:A31)=1,\"Diel \"&LOOKUP(\"X\",A12:A31,B12:B31)&\" označený pre Analýzu\",\"Označ jeden diely na proces\")","v":"Diel 4 označený pre Analýzu"},"Preťaženie",null,"Plán plnenia",null,null,"stroj / výrobná linka\nlen pre jeden model"]
[null,"Diel","PMDM Diel # alebo \"Non-PMDM\"","Požadované vyrobené diely / Týždeň","Čistý ideálny čas cyklu (sek/diel) ","Požadovaný čas @ Odhadované OEE (hod/týždeň)","Čas prechodu (min/týždeň)","% Rozdelenie\nMinimálne požadované"]
[null,1,null,null,null,{"$f":"IF(OR(D12=0,E12=0,D$9=0),\"\",(D12*E12/3600)/D$9)","v":""},null,{"$f":"IF(OR(F12=\"\",D$8=\"\"),\"\",F12/D$8)","v":""}]
[null,2,null,null,null,{"$f":"IF(OR(D13=0,E13=0,D$9=0),\"\",(D13*E13/3600)/D$9)","v":""},null,""]
[null,3,null,null,null,"",null,""]
["X",4,null,null,null,"",null,""]
[null,5,null,null,null,"",null,""]
[null,6,null,null,null,"",null,""]
[null,7,null,null,null,"",null,""]
[null,8,null,null,null,"",null,""]
[null,9,null,null,null,"",null,""]
[null,10,null,null,null,"",null,""]
[null,11,null,null,null,"",null,""]
[null,12,null,null,null,"",null,""]
[null,13,null,null,null,"",null,""]
[null,14,null,null,null,"",null,""]
[null,15,null,null,null,"",null,""]
[null,16,null,null,null,"",null,""]
[null,17,null,null,null,"",null,""]
[null,18,null,null,null,"",null,""]
[null,19,null,null,null,"",null,""]
[null,20,null,null,null,"",null,""]
[null,21,"Iné % Rozdelenie - Popis"]
[null,22,"Iné % Rozdelenie - Popis"]
[null,"Percento čistého dostupného času nevyužitého na výrobu (%) {PM, atď.}"]
[null,null,"Total % Rozdelenie",{"$f":"IF(SUM(D$12:D$32)>0,SUM(D$12:D$32),\"\")","v":""},null,{"$f":"IF(SUM(F$12:F$32)>0,SUM(F$12:F$32),\"\")","v":""},{"$f":"IF(SUM(G$12:G$32)>0,SUM(G$12:G$32),\"\")","v":""},{"$f":"IF(SUM(H$12:H$32)>0,SUM(H$12:H$34),\"\")","v":""}]
[null,"Ak celkové % Rozdelenia > 100%, plán plnenia presiahne kapacitu"]

{"sheet":"SK","index":11,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":true,"merged":[[65,0,65,17],[1,5,1,9],[1,14,1,17],[2,5,2,9],[2,14,2,17],[3,5,3,9],[3,14,3,17],[4,5,4,9],[4,14,4,17],[5,5,5,9],[5,14,5,17],[7,4,7,7],[66,0,66,4],[66,5,66,17],[67,0,67,17],[68,0,68,4],[68,5,68,17]]}
["Key Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jazyk==>"]
["PMDM Číslo dielu",null,null,null,null,null,null,null,null,null,"Dodávateľ Kontaktné meno "]
["PMDM Názov dielu",null,null,null,null,null,null,null,null,null,"Dodávateľ  Telefón č."]
["Názov dodávateľa",null,null,null,null,null,null,null,null,null,"Dodávateľ  E-mailová adresa"]
["Výrobný závod (Krajina, Mesto, atď.)",null,null,null,null,null,null,null,null,null,"Monitorovaný Zákazníkom alebo Dodávateľom"]
["Dodávateľ  č. / Výrobca Duns č.",null,null,null,null,null,null,null,null,null,"PMDM Zástupca  E-mailová adresa"]
[]
["Číslo dielu alebo procesu",null,null,null,null,null,null,null,null,null,null,"plánovaná","Zmena",{"$f":"process!N10","v":0}]
["Názov dielu alebo procesu",null,null,null,null,null,null,null,null,null,null,"plánovaná","Prestávka",{"$f":"process!N11","v":0}]
["Ideálny čas Cyklu [s]",null,null,null,null,null,"efektívne",null,null,null,null,"odhad neplánovaný","Prestoj",{"$f":"process!N12","v":0}]
["Počet dielov na Cyklus",null,null,null,null,null,null,null,null,null,null,"Počet","Zmien za deň"]
["Počet porovnávaných Nástrojov / Strojov",null,null,null,null,null,null,null,null,null,null,"Pracovné dni","/ Týždeň",null,null,"Požadované vstupné diely",null,"ks/týždeň"]
["Percento nepodarkov",null,null,null,null,null,null,"Miera kvality",null,null,null,"Percento plnenia s týmto","Číslom dielu",null,null,"Požadovaná kapacita",null,"ks/týždeň"]
[]
["Dátum","Čas spustenia","Čas ukončenia","Pracovný čas [min]","Plánovaná odstávka [min] Pauzy, atď.","Obedná  pauza [min]","OK diely (ks)","NOK diely (ks)","Miera kvality [%]","Neplánované prestoje (min)","Časy výmien \n(pre informáciu)","Čistý pracovný čas za deň [h]","Pozorovaný efektívny čas cyklu",{"$f":"\"Vypočítaný výnos v \" &N8& \"h  zmena/deň s faktorom plnenia\"","v":"Vypočítaný výnos v 0h  zmena/deň s faktorom plnenia"},"Výkonnosť","Dostupnosť vybavenia","celková efektívnosť vybavenia (OEE)","Predpokladané vyrobené diely týždenne (OEE)"]
["Spolu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dodávateľ"]
["právne záväzný podpis ",null,null,null,null,"Dátum / Pečiatka / Podpis"]
["Run @ Rate Potvrdenie"]
["Podpis PMDM SQE alebo QA",null,null,null,null,"Dátum / Pečiatka / Podpis"]