{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Auditbogen Blatt 1","Spinnendiagramm","ges. Pareto1-5"],"not_rendered":{"charts":2,"images":4,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Auditbogen Blatt 1","index":0,"n_rows":71,"n_cols":33,"rows_kept":71,"merged":[[0,0,1,9],[0,10,0,14],[0,15,0,28],[0,29,7,33],[1,10,1,14],[1,15,1,28],[2,0,4,14],[2,15,5,18],[2,19,5,23],[2,24,5,28],[5,0,7,14],[6,15,7,18],[6,19,7,23],[6,24,7,28],[8,0,10,1],[8,2,10,2],[8,3,10,8],[8,9,10,14],[8,15,8,33],[9,15,10,17],[9,18,9,19],[9,20,9,21],[9,22,9,23],[9,24,9,25],[9,26,9,27],[9,28,9,29],[9,30,9,31],[9,32,9,33],[10,18,10,19],[10,20,10,21],[10,22,10,23],[10,24,10,25],[10,26,10,27],[10,28,10,29],[10,30,10,31],[10,32,10,33],[11,0,16,1],[11,2,13,2],[11,3,13,8],[11,9,13,14],[11,15,11,17],[11,18,11,19],[11,20,11,21],[11,22,11,23],[11,24,11,25],[11,26,11,27],[11,28,11,29],[11,30,11,31],[11,32,11,33],[12,15,13,17],[12,18,13,33],[14,2,16,2],[14,3,16,8],[14,9,16,14],[14,15,14,17],[14,18,14,19],[14,20,14,21],[14,22,14,23],[14,24,14,25],[14,26,14,27],[14,28,14,29],[14,30,14,31],[14,32,14,33],[15,15,16,17],[15,18,16,33],[17,0,17,1],[17,2,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,26,17,27],[17,28,17,29],[17,30,17,31],[17,32,17,33],[18,0,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[18,26,18,27],[18,28,18,29],[18,30,18,31],[18,32,18,33],[19,0,27,1],[19,2,21,2],[19,3,21,8],[19,9,21,14],[19,15,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,15,21,17],[20,18,21,33],[22,2,24,2],[22,3,24,8],[22,9,24,14],[22,15,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,15,24,17],[23,18,24,33],[25,2,27,2],[25,3,27,8],[25,9,27,14],[25,15,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,15,27,17],[26,18,27,33],[28,0,28,1],[28,2,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[28,30,28,31],[28,32,28,33],[29,0,29,17],[29,18,29,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[29,30,29,31],[29,32,29,33],[30,0,35,1],[30,2,32,2],[30,3,32,8],[30,9,32,14],[30,15,30,17],[30,18,30,19],[30,20,30,21],[30,22,30,23],[30,24,30,25],[30,26,30,27],[30,28,30,29],[30,30,30,31],[30,32,30,33],[31,15,32,17],[31,18,32,33],[33,2,35,2],[33,3,35,8],[33,9,35,14],[33,15,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[33,26,33,27],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,15,35,17],[34,18,35,33],[36,0,36,1],[36,2,36,17],[36,18,36,19],[36,20,36,21],[36,22,36,23],[36,24,36,25],[36,26,36,27],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,0,37,17],[37,18,37,19],[37,20,37,21],[37,22,37,23],[37,24,37,25],[37,26,37,27],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,0,46,1],[38,2,40,2],[38,3,40,8],[38,9,40,14],[38,15,38,17],[38,18,38,19],[38,20,38,21],[38,22,38,23],[38,24,38,25],[38,26,38,27],[38,28,38,29],[38,30,38,31],[38,32,38,33],[39,15,40,17],[39,18,40,33],[41,2,43,2],[41,3,43,8],[41,9,43,14],[41,15,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,23],[41,24,41,25],[41,26,41,27],[41,28,41,29],[41,30,41,31],[41,32,41,33],[42,15,43,17],[42,18,43,33],[44,2,46,2],[44,3,46,8],[44,9,46,14],[44,15,44,17],[44,18,44,19],[44,20,44,21],[44,22,44,23],[44,24,44,25],[44,26,44,27],[44,28,44,29],[44,30,44,31],[44,32,44,33],[45,15,46,17],[45,18,46,33],[47,0,47,1],[47,2,47,17],[47,18,47,19],[47,20,47,21],[47,22,47,23],[47,24,47,25],[47,26,47,27],[47,28,47,29],[47,30,47,31],[47,32,47,33],[48,0,48,17],[48,18,48,19],[48,20,48,21],[48,22,48,23],[48,24,48,25],[48,26,48,27],[48,28,48,29],[48,30,48,31],[48,32,48,33],[49,0,66,1],[49,2,51,2],[49,3,51,8],[49,9,51,14],[49,15,49,17],[49,18,49,19],[49,20,49,21],[49,22,49,23],[49,24,49,25],[49,26,49,27],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,15,51,17],[50,18,51,33],[52,2,54,2],[52,3,54,8],[52,9,54,14],[52,15,52,17],[52,18,52,19],[52,20,52,21],[52,22,52,23],[52,24,52,25],[52,26,52,27],[52,28,52,29],[52,30,52,31],[52,32,52,33],[53,15,54,17],[53,18,54,33],[55,2,57,2],[55,3,57,8],[55,9,57,14],[55,15,55,17],[55,18,55,19],[55,20,55,21],[55,22,55,23],[55,24,55,25],[55,26,55,27],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,15,57,17],[56,18,57,33],[58,2,60,2],[58,3,60,8],[58,9,60,14],[58,15,58,17],[58,18,58,19],[58,20,58,21],[58,22,58,23],[58,24,58,25],[58,26,58,27],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,15,60,17],[59,18,60,33],[61,2,63,2],[61,3,63,8],[61,9,63,14],[61,15,61,17],[61,18,61,19],[61,20,61,21],[61,22,61,23],[61,24,61,25],[61,26,61,27],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,15,63,17],[62,18,63,33],[64,2,66,2],[64,3,66,8],[64,9,66,14],[64,15,64,17],[64,18,64,19],[64,20,64,21],[64,22,64,23],[64,24,64,25],[64,26,64,27],[64,28,64,29],[64,30,64,31],[64,32,64,33],[65,15,66,17],[65,18,66,33],[67,0,67,1],[67,2,67,17],[67,18,67,19],[67,20,67,21],[67,22,67,23],[67,24,67,25],[67,26,67,27],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,6,68,17],[68,18,68,19],[68,20,68,21],[68,22,68,23],[68,24,68,25],[68,26,68,27],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,0,69,1],[69,2,69,3],[69,4,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,16,70,17],[69,18,70,19],[69,20,70,21],[69,22,70,23],[69,24,70,25],[69,26,70,27],[69,28,70,29],[69,30,70,31],[69,32,70,33],[70,0,70,1],[70,2,70,3],[70,4,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,11],[70,12,70,13],[70,14,70,15]],"flags":["formulas_cached_only"]}
["5S Lager - Audit PA-MP-TSF-V",{"$nulls":9},"Auditor:",{"$nulls":4},"Unterschrift:"]
[{"$nulls":10},"Klotz",{"$nulls":4},"Auditzyklus ca. 100 Tage"]
["Bereichsverantwortlicher: Wöber Michael"]
[]
[]
["Lager = kein Awardbereich"]
[{"$nulls":15},0,{"$nulls":3},"-",{"$nulls":4},10]
[]
["5S",null,"Nr.","Merkmal",{"$nulls":5},"Beispiel",{"$nulls":5},"Bereiche"]
[{"$nulls":15},"Punktvergabe",null,null,"??.??.??",null,"??.??.??",null,"??.??.??",null,"??.??.??",null,"??.??.??",null,"??.??.??",null,"??.??.??",null,"??.??.??"]
[{"$nulls":18},"Lager 1",null,"Lager 2",null,"Lager 3",null,"Lager 3A",null,"Lager 4",null,"Lager 5",null,"Lager 6",null,"Lager 7"]
["1. Sortieren",null,"1.1","Gibt es im Arbeitsbereich unnötige Materialien",{"$nulls":5},"Verpackungsmaterial, Gefäße, nicht mehr benutzte Einsatzstoffe, Hilfs-/ Betriebsstoffe, Reinigungsmittel",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"1.2","Gibt es im Arbeitsbereich unnötige Einrichtungen?                                               ",{"$nulls":5},"Schränke, Regale, Werkbänke, Stühle, Tische",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[20,null,"gesamt Punkte 1. Sortieren",{"$nulls":15},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["in % 1. Sortieren",{"$nulls":17},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["2. Sichtbare Ordnung",null,"2.1","Sind im Arbeitsbereich Plätze gekennzeichnet. Kann man erkennen, wo etwas fehlt, wohin etwas zurückgelegt werden muß?",{"$nulls":5},"Schränke, Regale, usw.",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"2.2","Gibt es im Arbeitsbereich Kennzeichnungen für Abstellplätze. Ist erkennbar, wo etwas abgestellt werden muss?",{"$nulls":5},"Paletten, Material",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"2.3","Erfolgt im Arbeitsbereich eine Kennzeichnung der defekten und überholten Teile",{"$nulls":5},"Sind alle Teile korrekt gegennzeichnet Stimmen die Angaben?",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[30,null,"gesamt Punkte 2. Sichtbare Ordnung",{"$nulls":15},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["in % 2. Sichtbare Ordnung",{"$nulls":17},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["3. Sauberkeit",null,"3.1","Ist der Lagerbereich gründlich gereinigt und damit frei von Verunreinigungen?",{"$nulls":5},"z. B. durch Öl, Fett, Einsatzstoffe, Abfall, Papier",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"3.2","Gibt es Festlegungen bzw. Regelungen, dass Reinigungen u. Kontrollen durchgeführt werden?",{"$nulls":5},"notwendige Arbeiten einschl. Terminierung, notwendige Hilfsmittel",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[20,null,"gesamt Punkte 3. Sauberkeit",{"$nulls":15},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["in % 3. Sauberkeit",{"$nulls":17},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["4. Standard",null,"4.1","Befindet sich an den gekennzeichneten Stellen das, was dort hingehört?",{"$nulls":5},"Bodenflächen, Arbeitsflächen, Schränken, Schubladen,……",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"4.2","Gibt es einheitliche Lösungen im Arbeitsbereich und werden diese nachweislich genutzt?",{"$nulls":5},"Stellflächen immer gelb umrandet, Ordner einheitlich beschriftet, einheitlich strukturierte Info-Tafel, einheitliche Teilekennzeichnungen",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"4.3","Gibt es Reinigungs-, Inspektions- oder Schmierpläne, sind diese visualisiert und werden sie nachweislich verwendet?",{"$nulls":11},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[30,null,"gesamt Punkte 4. Standard",{"$nulls":15},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["in % 4. Standard",{"$nulls":17},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["5. Ständige Verbesserung u. Selbstdisziplin",null,"5.1","Werden die unter Pkt. 4 beschriebenen Standards nachweislich und flächendeckend eingehalten?",{"$nulls":11},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"5.2","Werden die unter Pkt. 4 beschriebenen Standards gelebt und weiter verbessert / optimiert?",{"$nulls":11},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"5.3","Werden im betreffenden Bereich regelmäßige Audits zu 5S durchgeführt?",{"$nulls":11},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"5.4","Werden im betreffenden Bereich die 5S-Auditergebnisse visuell dargestellt?",{"$nulls":11},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"5.5","Werden im betreffenden Bereich aus den 5S-Audits abgeleitete Maßnahmen in einer Aktivitätenliste verfolgt?",{"$nulls":5},"z. B. Aktions-Maßnahmen-Plan (AMP)",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[null,null,"5.6","Werden im betreffenden Bereich nachweisliche Ergebnisse zu Verbesserungsaktivitäten erzielt?",{"$nulls":5},"ZDF, z.B. Reduzierung der Bestände, Reduzierung der Wege, Reduzierung Fläche",{"$nulls":5},"0 - 10"]
[{"$nulls":15},"Bemerkung:"]
[]
[60,null,"gesamt Punkte 5. Ständige Verbesserung und Selbstdisziplin",{"$nulls":15},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[160,{"$nulls":5},"in % 5. Ständige Verbesserung und Selbstdisziplin",{"$nulls":11},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
["Lager 1           in %",null,"Lager 2             in %",null,"Lager 3               in %",null,"Lager 3A          in %",null,"Lager 4             in %",null,"Lager 5               in %",null,"Lager 6            in %",null,"Lager 7             in %",null,"gesamt         Punkte",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]

{"sheet":"Spinnendiagramm","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[null,"Lager ??","Grenze 1","Grenze 2","Awardbereich"]
["1. Sortieren",null,50,80,100]
["2. Sichtbare Ordnung",null,50,80,100]
["3. Sauberkeit",null,50,80,100]
["4. Standards",null,50,80,100]
["5. Ständige Verbesserung u. Selbstdisziplin",null,50,80,100]

{"sheet":"ges. Pareto1-5","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"flags":["formulas_cached_only"]}
["5S Audit gesamt Ergebnis"]
[null,"Lager ??","sehr ordentlich","super gut","alles Top"]
["Lager - Audit1 Lager ?? Datum",null,80,90,95]
[null,null,80,90,95]
[null,null,80,90,95]
[null,null,80,90,95]
[null,null,80,90,95]