{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Overview & Manual","General Information","Quality","Management","Costs &Logistic","Technic","Communication","Environment&Social","Auswertung SARA","Scorecard","Regeln","Revision"],"not_rendered":{"charts":2,"images":2,"defined_names":10,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Overview & Manual","index":0,"n_rows":22,"n_cols":1,"rows_kept":22,"merged":[[0,0,0,8],[2,0,2,3],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[5,0,5,1],[5,2,5,3],[7,0,7,3],[8,0,8,1],[8,2,8,3],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[14,0,18,8],[21,0,26,8],[30,0,30,7]]}
["SARA\nLieferantenselbstauskunft/Risikoanalyse\nSupplier Self Assessement / Riskanalysis"]
[]
["Kübler"]
["Verantworlicher QM responsible QM:"]
["Verantworllicher SP responsible PUR:"]
["Datum Date :"]
[]
["Supplier"]
["Lieferant Name Company Name:"]
["Bearbeitet von Completed by:"]
["Datum Date:"]
[]
[]
["Anleitung:"]
["Sie finden in den folgenden Tabellenblätter verschiedene Kategorien. Füllen Sie die Tabelle Allgemeine Auskünfte (General Information) aus. Bitte beantworten Sie die Fragen zur Selbstauskunft (SA) in den Tabellenblätter:  Quality, Management, Costs&Logistic, Technic,  Communication und Environment&Social aus.  Alle Eingabefelder für den Lieferanten sind blau hinterlegt.\n"]
[]
[]
[]
[]
[]
["Manual:"]
["In the different excel sheets you will find different categories. Please fill in the sheet general information and answer the questions of the sheets: Quality, Management, Costs&Logistic, Technic,  Communication und Environment&Social.\nThe fields for supplier entries are marked blue."]

{"sheet":"General Information","index":1,"n_rows":63,"n_cols":9,"rows_kept":63,"merged":[[0,0,1,10],[2,0,2,1],[2,3,2,10],[3,0,3,1],[3,3,3,10],[4,0,4,1],[4,3,4,10],[5,0,5,1],[5,3,5,10],[6,0,6,1],[6,3,6,10],[7,0,7,1],[7,3,7,10],[8,0,8,1],[8,3,8,10],[9,0,9,1],[9,3,9,10],[10,0,10,1],[10,3,10,10],[11,0,11,1],[11,6,11,7],[11,9,11,10],[12,0,12,1],[12,6,12,7],[12,9,12,10],[13,0,13,1],[13,6,13,7],[13,9,13,10],[14,0,14,10],[15,0,15,1],[15,6,15,10],[16,0,16,10],[17,0,17,10],[18,0,19,1],[18,2,19,2],[18,4,18,10],[19,4,19,5],[19,7,19,10],[20,0,21,1],[20,2,21,2],[20,4,20,5],[20,7,20,10],[21,4,21,5],[21,7,21,10],[22,0,23,1],[22,2,23,2],[22,4,22,5],[22,7,22,10],[23,4,23,5],[23,7,23,10],[24,0,25,1],[24,2,25,2],[24,4,24,5],[24,7,24,10],[25,4,25,5],[25,7,25,10],[26,0,27,1],[26,2,27,2],[26,4,26,5],[26,7,26,10],[27,4,27,5],[27,7,27,10],[28,0,29,1],[28,2,29,2],[28,4,28,5],[28,7,28,10],[29,4,29,5],[29,7,29,10],[32,0,32,1],[32,3,32,4],[32,5,32,7],[32,8,32,10],[33,0,33,1],[33,3,33,4],[33,5,33,7],[33,8,33,10],[34,0,34,1],[34,3,34,4],[34,5,34,7],[34,8,34,10],[35,0,35,1],[35,3,35,4],[35,5,35,7],[35,8,35,10],[35,11,35,12],[36,0,36,1],[36,3,36,4],[36,5,36,7],[36,8,36,10],[37,0,37,1],[37,3,37,4],[37,5,37,7],[37,8,37,10],[38,0,38,1],[38,3,38,4],[38,5,38,7],[38,8,38,10],[39,0,39,1],[39,3,39,4],[39,5,39,7],[39,8,39,10],[40,0,40,1],[40,3,40,4],[40,5,40,7],[40,8,40,10],[41,0,41,1],[41,3,41,4],[41,5,41,7],[41,8,41,10],[42,0,42,1],[42,3,42,4],[42,5,42,7],[42,8,42,10],[43,0,43,1],[43,3,43,4],[43,5,43,7],[43,8,43,10],[44,0,44,1],[44,3,44,4],[44,5,44,7],[44,8,44,10],[45,0,45,1],[45,3,45,4],[45,5,45,7],[45,8,45,10],[48,0,48,10],[49,0,49,1],[49,4,49,10],[50,0,50,1],[50,4,50,10],[51,0,51,1],[51,4,51,10],[52,0,52,1],[52,3,52,10],[53,0,53,1],[53,3,53,10],[54,0,54,1],[54,3,54,10],[55,0,55,1],[55,3,55,10],[56,0,56,2],[56,3,56,10],[57,0,57,2],[57,3,57,10],[58,0,58,1],[58,3,58,10],[60,0,60,1],[60,3,60,10],[61,0,61,1],[62,0,62,1],[62,4,62,5],[62,6,62,7],[62,8,62,10]]}
["Lieferantenselbstauskunft\nSupplier Self Assessement"]
[]
["Firma Company Name",null,"Supplier Name "]
["Anschrift Address",null,"Adress"]
["Homepage",null,"Website"]
["Gründungsjahr                                                       Year of founding",null,"Founding year/legal from"]
["Rechtsform\nLegal form"]
["Bankdaten: BIC,IBAN Bank data swift code",null,"Bank data: BIC, IBAN"]
["Kreditreformauskunft beigefügt                      Credit worthiness information attached",null,"Bank data: BIC, IBAN"]
["Deckungssumme Produkthaftpflichtvers. product liability insurance cover total",null,"Bank data: BIC, IBAN"]
["Umsatzsteuer Id.Nr. VAT number",null,"Turnover tax ID number"]
["Produktionsstandorte Location of production",null,"Production location","Land/Country:                                                     ",null,"Ort/City:",null,null,"Mitarbeiter/ Employees:"]
["Vertriebsstandorte Location of sales dept.",null,"Sales location","Land/Country:                                                     ",null,"Ort/City:",null,null,"Mitarbeiter/ Employees:"]
["Weitere Werke Other locations",null,"Further plants ","Land/Country:                                                     ",null,"Ort/City:",null,null,"Mitarbeiter/ Employees:"]
[]
["Datum der Auskunft/Beurteilung Date of assessement",null,"Date of assesment/judgement","Lieferant/ Supplier:",null,"Kübler:"]
[]
["Lieferantenkontakte und Verantwortliche: Supplier contacts and responsible persons"]
["Geschäftsführung Managing directors:",null,"Contract issues:","Name: "]
[{"$nulls":3},"Tel.:",null,null,"E-Mail:"]
["Vertrieb Außendienst External sales:",null,"Contract issues:","Name:",null,null,"Position:"]
[{"$nulls":3},"Tel.:",null,null,"E-Mail:"]
["Vertrieb Innendienst Internal sales:",null,"Quality issues:","Name:",null,null,"Position:"]
[{"$nulls":3},"Tel.:",null,null,"E-Mail:"]
["Technik Technology:",null,"Operational issues:","Name:",null,null,"Position:"]
[{"$nulls":3},"Tel.:",null,null,"E-Mail:"]
["Qualität Quality:",null,"Technical issues:","Name:",null,null,"Position:"]
[{"$nulls":3},"Tel.: ",null,null,"E-Mail:"]
["Selbstauskunft Selfassessement:",null,"Creator of Self assessment:","Name:",null,null,"Position:"]
[{"$nulls":3},"Tel.:",null,null,"E-Mail:"]
[]
[]
["Kennzahlen des Unternehmens:",null,null,"Aktuelles Jahr                 Actual Year",null,"Nächstes Jahr                    Next Year",null,null,"Vorjahr                      previous year"]
["Umsatz (€) Turnover (€)"]
["Auslastung % Capacity utilization %"]
["Exportanteil (%) Export %"]
["In wievielen Schichten arbeitet die Produktion? How many shifts are working in production?"]
["Eigenkapital Equity"]
["Unternehmensergebnis (EBT) Corporate results"]
["Umsatzrendite (Ergebnis/Umsatz)                              return on sales"]
["Mitarbeiterzahl Gesamt Number of employees"]
["Mitarbeiterzahl Produktion                               Number of employees production"]
["Mitarbeiterzahl  QS \nNumber of employees quality dept."]
["Mitarbeiterzahl Entwicklung                                       Number of employees R&D"]
["Mitarbeiterzahl  Verwaltung                                        Number of employees administration"]
["Krankenstand in %                                              Number of employees`s illness"]
[]
[]
["Allgemeine Auskünfte Generall information:"]
["Welche Sofware ist im Einsatz Software in use:",null,null,"CAD:"]
[{"$nulls":3},"ERP:"]
[{"$nulls":3},"CAQ:"]
["Nennen Sie uns Ihre größten 3 Kunden                   Please state your 3 biggest customers:"]
["Nennen Sie uns Ihre 3 größten europäischen Kunden \nPlease state your 3 biggest european customers:"]
["Gibt es einen Kunden mit mehr als 30% Umsatzanteil? Wenn ja welcher?\nIs there a customer with more than 30% of turnover?"]
["Welche Meßgeräte sind im Einsatz.                           Which measuring devices/tools are in use:"]
["Geben Sie uns einen groben Überblick über Ihren Maschinenpark. \nGive us a rough overview of your machine park."]
["Durchschnittsalter der Maschinen ?\nAverage age of machines?"]
[]
[]
["Welches Fachpersonal ist in der Fertigung eingesetzt?\nWhich skilled worker are working in production."]
["Welche Minimum Produktionslosgröße für Serienproduktion haben Sie?\nMinimum production lot size for  serial production"]
["Wie ist die Standardlieferzeit von Mustern- und Serienteilen. How long are the standard delivery times for samples and serial parts?",null,null,"Muster:\nSamples:",null,null,"Serienteile:\nSerial parts:"]

{"sheet":"Quality","index":2,"n_rows":42,"n_cols":13,"rows_kept":42,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[17,3,17,4],[17,6,17,9],[18,3,18,4],[18,6,18,9],[19,3,19,4],[19,6,19,9],[22,3,22,4],[22,6,22,9],[23,3,23,4],[23,6,23,9],[24,3,24,4],[24,6,24,9],[25,3,25,4],[25,6,25,9],[26,3,26,4],[26,6,26,9],[27,3,27,4],[27,6,27,9],[30,3,30,4],[30,6,30,9],[31,3,31,4],[31,6,31,9],[32,3,32,4],[32,6,32,9],[33,3,33,4],[33,6,33,9],[34,3,34,4],[34,6,34,9],[37,3,37,4],[37,6,37,9],[38,3,38,4],[38,6,38,9],[39,3,39,4],[39,6,39,9],[40,3,40,4],[40,6,40,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Quality",{"$nulls":3},{"$f":"((AVERAGE(M14:M20,M23:M28,M31:M35,M38:M41))*100)/10","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"((AVERAGE(K14:K20,K23:K28,K31:K35,K38:K41))*100)/10","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",{"$nulls":4},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":5},"NA",{"$nulls":4},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Allgemein / General"]
["1.1","Zertifizierung nach ISO 9001:2015 vorhanden?","Supplier is certified according to ISO 9001:2015",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":0}]
["1.2","Zertifizierung nach IATF 16949:2016 vorhanden?","Supplier is certified according to IATF 16949:2016",{"$nulls":9},{"$f":"IF(F15=$F$7,10,IF(F15=$F$8,0,IF(F15=$F$9,\"\",IF(F15=$F$10,0))))","v":0}]
["1.3","Zertifizierung nach ATEX vorhanden?","Supplier is certified according to ATEX",{"$nulls":9},0]
["1.5","Planung für interne Audits vorhanden?","Plan for internal audits avaiable.",{"$nulls":9},0]
["1.6","Welche Werkzeuge der Qualitätssicherung sind in Gebrauch (wenn ja welche. Z.B. FMEA, 8 D Report, QRK, Ishikawa..)?","Quality tools are in use. (If yes, which eg FMEA, 8 D Report, Q-charts, Ishikawa...)",{"$nulls":9},0]
["1.7","Die Kundenzufriedenheit wird regelmäßig ausgewertet und überwacht.","Customer satisfaction is regularly evaluated.",{"$nulls":9},0]
["1.8","Bereitschaft zum Abschluß einer Qualitätssicherungsvereinbarung ist vorhanden.","Supplier is willing to negotiate a QAA.(Quality Assurance Agreement)",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M14:M20)","v":0}]
[2,"Meßmittel / Measuring Equipment"]
["2.1","Alle relevanten Prüfungen und Tests können im Haus durchgeführt werden","All relevant inspections and test can be done in house",{"$nulls":9},0]
["2.2","3D Meßmaschine und trainierte Mitarbeiter vorhanden","3 D measuring equipment available and staff trained",{"$nulls":9},0]
["2.4","Prüf- und Messgeräte werden regelmäßig kalibriert","Test and measuring equipment calibrated",{"$nulls":9},0]
["2.5","Meßraum ist klimatisiert und Luftfeuchte überwacht","Measuring rooms are temperature and humiditiy monitored",{"$nulls":9},0]
["2.6","Meßmittelsystemanalyse wird praktiziert (MSA)","Measurement system analysis performed",{"$nulls":9},0]
["2.7","Kalibrierung der Messmittel wird im Hause durchgeführt","Calibration of the measuring equipment is carried out in house",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M23:M28)","v":0}]
[3,"Teile Qualität / Part Quality"]
["3.1","Wichtige prozessrelevante Maße werden erfasst, überwacht und ausgewertet.","Important process-relevant measures are recorded, monitored and evaluated.",{"$nulls":9},0]
["3.2","Werden Fertigungs bzw. Prüfschritte extern vergeben, wenn ja welche?","Are all production- and inspection steps in house? If no, which are outside.",{"$nulls":9},0]
["3.3","Erstmusterprüfberichte können bereitgestellt werden ","First article inspetion reports can be provided"]
["3.4","Wareneingangsprüfung ist installiert?","Incoming goods inspection installed"]
["3.5","Mögliche Schwachstellen bei qualitätsrelevanten Prozessen werden im Vorfeld untersucht. (FMEA, APQP Advanced Product Quality Planning)","FMEA for important quality-relevant processes are carried out.  (FMEA, APQP Advanced Product Quality Planning)",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M31:M35)","v":0}]
[4,"Reklamationsprozeß / NCM Process"]
["4.1","Schlechte Ware ist markiert und separat gelagert","NCM material marked clearly and stored at separate stock",{"$nulls":9},0]
["4.2","Prozess zur Kundenreklamation vorhanden","Process Customer claims defined",{"$nulls":9},0]
["4.3","8 D Methode installiert","8 D method is practiced ",{"$nulls":9},0]
["4.5","Rücksendeprozess nur über RMA (Return Material Authorization) Nummer möglich.","Return of NCM only possible via RMA (Return Material Authorization) number.",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M38:M40)","v":0}]

{"sheet":"Management","index":3,"n_rows":37,"n_cols":13,"rows_kept":37,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[19,3,19,4],[19,6,19,9],[20,3,20,4],[20,6,20,9],[21,3,21,4],[21,6,21,9],[24,3,24,4],[24,6,24,9],[25,3,25,4],[25,6,25,9],[26,3,26,4],[26,6,26,9],[29,3,29,4],[29,6,29,9],[30,3,30,4],[30,6,30,9],[31,3,31,4],[31,6,31,9],[32,3,32,4],[32,6,32,9],[33,3,33,4],[33,6,33,9],[34,3,34,4],[34,6,34,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Management",{"$nulls":3},{"$f":"(100*(AVERAGE(M14:M17,M20:M22,M25:M27,M30:M35)/10))","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"((AVERAGE(K14:K17,K20:K22,K25:K27,K30:K35))*100)/10","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",10,{"$nulls":3},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":5},"NA",{"$nulls":4},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Personal / Human ressources HR"]
["1.1","Prozess zur Mitarbeiteraus und- Weiterbildung vorhanden","Process for employees training and edjucation in place",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":0}]
["1.2","Mitarbeiterzurfiedenheit  wird regelmäßig ausgewertet und überwacht","Employeesatisfaction is regularly evaluated",{"$nulls":9},0]
["1.3","Mitarbeiterfluktuation und Krankenstand wird regelmäßig ausgewertet und überwacht","Employee fluctuation and sick leave is regularly evaluated and monitored",{"$nulls":9},0]
["1.4","Qualifikationsbedarfe werden regelmäßig ermittelt","Needs of workerqualification determined ",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M14:M17)","v":0}]
[2,"Business"]
["2.1","Produkthaftpflichversicherung vorhanden","Is a supplier a liability insurance in place?",{"$nulls":9},{"$f":"IF(F20=$F$7,10,IF(F20=$F$8,0,IF(F20=$F$9,\"\",IF(F20=$F$10,0))))","v":0}]
["2.2","Produktgarantie min. 12 Monate","Product warranty minimum 12 months",{"$nulls":9},0]
["2.3","Der Lieferant ist bereit, Geschäfte gemäß des lokalen Rechts des Lieferorts zu tätigen","Supplier is willing to do business according to local law of delivery destination.",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M20:M22)","v":0}]
[2,"Datensicherung / Backup"]
["2.1","Regelmäßige Datensicherung  für alle wichtigen  Daten \n(bitte Häufigkeit angeben) ","Backup of all relevant data at regular intervals  (frequency)",{"$nulls":9},{"$f":"IF(F25=$F$7,10,IF(F25=$F$8,0,IF(F25=$F$9,\"\",IF(F25=$F$10,0))))","v":0}]
["2.2","Regelmäßige Datensicherung auf externen Speicherorten","Regular backup to external locations",{"$nulls":9},0]
["2.3","Backup Daten sind feuersicher gelagert.","Backup data are fire proofed stored ",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M25:M27)","v":0}]
[3,"Produktionsstandort / Production side"]
["3.1","Ist ein Sprinklersystem installiert?","Is a sprinkler system installed at the production area ?",{"$nulls":9},{"$f":"IF(F30=$F$7,10,IF(F30=$F$8,0,IF(F30=$F$9,\"\",IF(F30=$F$10,0))))","v":0}]
["3.2","Direkte Verbindung des Feuermeldesystems zur Feuerwehr","Is there a direct alarm line to the fire brigade?",{"$nulls":9},0]
["3.3","Feuersicheres Lager für Produktionswerkzeuge","Fire-proof storage for production tools",{"$nulls":9},0]
["3.4","Gab es irgendwelche Brände die letzten Jahre?","Was there any fire in the past years?",{"$nulls":9},0]
["3.5","Gibt es Risiken bezgl. Naturkatastophen bezgl. Naturkatastrophen. (z.B. Erdbeben, Überschwemmungen, Brände)?","Is there a danger regarding natural desasters. (eg. Earthquake, large scale fire, flood)?",{"$nulls":9},{"$f":"IF(F34=$F$8,10,IF(F34=$F$7,0,IF(F34=$F$9,\"\",IF(F34=$F$10,0))))","v":0}]
["3.6","Gibt es einen Notfallplan?","Is there an emergency plan available?",{"$nulls":9},{"$f":"IF(F35=$F$7,10,IF(F35=$F$8,0,IF(F35=$F$9,\"\",IF(F35=$F$10,0))))","v":0}]
[{"$nulls":12},{"$f":"AVERAGE(M20:M22)","v":0}]
[{"$nulls":12},{"$f":"AVERAGE(M36,M28,M23,M18)","v":0}]

{"sheet":"Costs &Logistic","index":4,"n_rows":32,"n_cols":13,"rows_kept":32,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[17,3,17,4],[17,6,17,9],[18,3,18,4],[18,6,18,9],[19,3,19,4],[19,6,19,9],[20,3,20,4],[20,6,20,9],[21,3,21,4],[21,6,21,9],[24,3,24,4],[24,6,24,9],[25,3,25,4],[25,6,25,9],[26,3,26,4],[26,6,26,9],[27,3,27,4],[27,6,27,9],[28,3,28,4],[28,6,28,9],[29,3,29,4],[29,6,29,9],[30,3,30,4],[30,6,30,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Kosten & Logistik / Costs & Logistic",{"$nulls":3},{"$f":"((AVERAGE(M14:M22,M25:M31))*100)/10","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(((AVERAGE(K14:K22,K25:K31))*100)/10)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",{"$nulls":4},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":10},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Kosten / Costs"]
["1.2","Bereitschaft zur offenen Kalkulationen vorhanden?","Willingness to open calculations available?",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":""}]
["1.3","Nachkalkulationen werden regemäßig durchgeführt?","Post-calculations are carried out on a regular basis?",{"$nulls":9},""]
["1.4","Erfahrung mit Logistikmethoden\n(z.B. Kanban, Konsignationslager)","Experience with logistic methods eg. Kanban, Consigned Stock",{"$nulls":9},""]
["1.5","Methoden zur Preisreduzierung sind installiert?","Methods for price reductions are installed?"]
["1.6","Lieferantenauswahlprozeß vorhanden?","Supplier selection process available?",{"$nulls":9},""]
["1.7","Lieferanten Reklamationsprozeß vorhanden?","NCM process to supplier available?",{"$nulls":9},""]
["1.8","Lieferantenmanagement - und Entwicklungsprozeß vorhanden?","Supplier management process in place?",{"$nulls":9},""]
["1.9","Risiken bei Lieferanten werden regelmäßig analysiert und bewertet?","Risks at suppliers are regularly analyzed and evaluated?",{"$nulls":9},""]
["1.9","Sicherheitsbestände für kritische Teile sind definiert?","Safety stock for critical parts defined?",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M14:M22)","v":{"$error":"#DIV/0!"}}]
[2,"Logistik / Logistics"]
["2.1","Lieferzeiten der Einkaufsteile werden überwacht und gemessen?","Delivery times of the purchased parts are monitored and measured?",{"$nulls":9},{"$f":"IF(F25=$F$7,10,IF(F25=$F$8,0,IF(F25=$F$9,\"\",IF(F25=$F$10,0))))","v":""}]
["2.2","Rückverfolgbarkeit auf Komponentenebene bzw. bis zur Materialcharge möglich?","Traceability back to component or to the material batch possible?",{"$nulls":9},""]
["2.3","Fifo ist durchgängig installiert?","FIFO is installed continiously?",{"$nulls":9},""]
["2.4","Lager ist klimatisiert","Storage areas are air-conditioned",{"$nulls":9},""]
["2.5","Relevante Lagerflächen sind ESD geschützt","Relevant storage areas are ESD protected",{"$nulls":9},""]
["2.6","Bereitschaft einen Sicherheitsbestand an (Vor-)Material vorzuhalten","Willingness to provide a safety stock of (pre-) material",{"$nulls":9},""]
["2.7","Hat der Betrieb über einen längeren Zeitraum eine Betriebsruhe (z.B. Sommer Urlaub)? Wenn ja wann und über welche Dauer?","Is there a longer period were the supplier has vacation or similar?\nIf yes, when and how long?",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M25:M31)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Technic","index":5,"n_rows":33,"n_cols":13,"rows_kept":33,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[17,3,17,4],[17,6,17,9],[18,3,18,4],[18,6,18,9],[19,3,19,4],[19,6,19,9],[20,3,20,4],[20,6,20,9],[21,3,21,4],[21,6,21,9],[22,3,22,4],[22,6,22,9],[23,3,23,4],[23,6,23,9],[26,3,26,4],[26,6,26,9],[27,3,27,4],[27,6,27,9],[28,3,28,4],[28,6,28,9],[29,3,29,4],[29,6,29,9],[30,3,30,4],[30,6,30,9],[31,3,31,4],[31,6,31,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Technik / Technic",{"$nulls":3},{"$f":"(100*(AVERAGE(M14:M24,M27:M32)/10))","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"((AVERAGE(K14:K24,K27:K32))*100)/10","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",{"$nulls":4},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":5},"NA",{"$nulls":4},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Produktion / Production"]
["1.1","Werden Fertigungs bzw. Prüfschritte extern vergeben, wenn ja welche?","Are all production- and inspection steps in house? If no, which are outside?",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":0}]
["1.2","Eigener Musterbau vorhanden","Own model shop available",{"$nulls":9},0]
["1.3","Eigener Werkzeugbau vorhanden","Own tool manufacturing in-house",{"$nulls":9},0]
["1.4","Werkzeuge feuergeschützt gelagert","Fire-proof tool storage available",{"$nulls":9},0]
["1.5","Wichtige Verschleiß-und Ersatzteile definiert und vorhanden","Important spare parts are defined and available",{"$nulls":9},0]
["1.6","Maschinen und Werkzeuge werden regelmäßig gewartet und dokumentiert","Machine and tool maintenance at regular intervals and documented",{"$nulls":9},0]
["1.7","Relevante Prozessschritte sind ESD geschützt","Production floor and equipment are ESD-protected",{"$nulls":9},0]
["1.8","100% Funktionstest bei Baugruppen installiert (z.B. El. Boards und Einzelteile)","100% Functional test installed on assemblies (e.g., electronic boards and parts)",{"$nulls":9},0]
["1.9","Automatische optische Inspection vorhanden ( AOI)","AOI avaiable",{"$nulls":9},0]
["1.10","Produktion ist klimatisiert","Production floors are air-conditioned",{"$nulls":9},0]
["1.11","Lager ist klimatisiert","Storage areas are air-conditioned",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M14:M24)","v":0}]
[2,"Ausstattung /  equipment"]
["2.1","Granulattrockner vorhanden (bei Kunstofffertigung)","Resin dryers available (Plastic production)",{"$nulls":9},0]
["2.2","100% Funktionstest bei Baugruppen installiert (z.B. El. Boards und Einzelteile)","Functional test installed on assemblies (e.g., electronic boards and parts)",{"$nulls":9},0]
["2.3","Eigene Galvanik vorhanden","Own galvanic coatings available",{"$nulls":9},0]
["2.4","Eigene Lackiererei vorhanden","Own spray paint shop available",{"$nulls":9},0]
["2.5","Eigene Pulverbeschichtung vorhanden","Own powder coating line available",{"$nulls":9},0]
["2.6","Eigene CNC Produktion vorhanden","Own CNC production available",{"$nulls":9},0]
[{"$nulls":12},{"$f":"AVERAGE(M27:M32)","v":0}]

{"sheet":"Communication","index":6,"n_rows":60,"n_cols":13,"rows_kept":60,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[19,3,19,4],[19,6,19,9],[20,3,20,4],[20,6,20,9],[21,3,21,4],[21,6,21,9],[22,3,22,4],[22,6,22,9],[25,3,25,4],[25,6,25,9],[26,3,26,4],[26,6,26,9],[27,3,27,4],[27,6,27,9],[30,3,30,4],[30,6,30,9],[31,3,31,4],[31,6,31,9],[32,3,32,4],[32,6,32,9],[33,3,33,4],[33,6,33,9],[34,3,34,4],[34,6,34,9],[35,3,35,4],[35,6,35,9],[36,3,36,4],[36,6,36,9],[37,3,37,4],[37,6,37,9],[40,3,40,4],[40,6,40,9],[41,3,41,4],[41,6,41,9],[42,3,42,4],[42,6,42,9],[43,3,43,4],[43,6,43,9],[44,3,44,4],[44,6,44,9],[45,3,45,4],[45,6,45,9],[46,3,46,4],[46,6,46,9],[47,3,47,4],[47,6,47,9],[50,3,50,4],[50,6,50,9],[51,3,51,4],[51,6,51,9],[52,3,52,4],[52,6,52,9],[53,3,53,4],[53,6,53,9],[54,3,54,4],[54,6,54,9],[55,3,55,4],[55,6,55,9],[56,3,56,4],[56,6,56,9],[57,3,57,4],[57,6,57,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Kommunikation / Communication",{"$nulls":3},{"$f":"100*(AVERAGE(M14:M17,M20:M23,M26:M28))/10","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"((AVERAGE(K14:K17,K20:K23,K26:K28))*100)/10","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",{"$nulls":4},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":10},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Allgemein/ General"]
["1.1","Wichtige Personen sind per Mobiltelefon erreichbar","Important persons can be reached via mobile phone",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":""}]
["1.2","Kommunikationsmatrixen incl. Vertreter für Kunden vorhanden","Communication matrixes incl. replacement for customers available",{"$nulls":9},{"$f":"IF(F15=$F$7,10,IF(F15=$F$8,0,IF(F15=$F$9,\"\",IF(F15=$F$10,0))))","v":""}]
["1.4","Desktopsharing und Videochat möglich (z.B. Skype, Teamviewer)","Desktop sharing and video chat possible (E.g. Skype,Teamviewer)",{"$nulls":9},""]
["1.5","Austausch größerer Dateien über WEB / Cloud möglich"," file sharing  via WEB / Cloud possible",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M14:M17)","v":{"$error":"#DIV/0!"}}]
[2,"Berichte / Reports"]
["2.1","Erste Rückantwort auf 8 D Report mit Sofortmaßnahme innerhalb 24 Stunden möglich","First response to 8 D report with containment action possible within 24 hours",{"$nulls":9},{"$f":"IF(F20=$F$7,10,IF(F20=$F$8,0,IF(F20=$F$9,\"\",IF(F20=$F$10,0))))","v":""}]
["2.2","Fehleranalysereports auf Englisch möglich","Failure analysis reports in English language possible",{"$nulls":9},""]
["2.3","Signifikante Prozessänderungen werden dem Kunden berichtet.","Significant process changes are reported to customer.",{"$nulls":9},""]
["2.4","Mögliches Verbesserungspotential  wird dem Kunden berichtet.","Potential improvements reported to customer ",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M20:M23)","v":{"$error":"#DIV/0!"}}]
[3,"Bestellungen / Orders"]
["3.1","Liefertreue zum Kunden wird ausgewertet und überwacht","Deliveries to customer are evaluated and monitored.",{"$nulls":9},""]
["3.2","Angebote können innerhalb von 3 Arbeitstagen geliefert werden","Quotes can be provided within 3 working days",{"$nulls":9},""]
["3.3","Auftragsbestätigungen mit festem Liefertermin können innerhalb von 3 Arbeitstagen bestätigt werden","Order confirmations with a reliable delivery date can be sent out within 3 business days",{"$nulls":9},""]
[]
[4]
["4.1"]
["4.2"]
["4.3"]
["4.4"]
["4.5"]
["4.6"]
["4.7"]
["4.8"]
[]
[5]
["5.1"]
["5.2"]
["5.3"]
["5.4"]
["5.5"]
["5.6"]
["5.7"]
["5.8"]
[]
[6]
["5.1"]
["5.2"]
["5.3"]
["5.4"]
["5.5"]
["5.6"]
["5.7"]
["5.8"]
[]
[{"$nulls":12},{"$f":"AVERAGE(M26:M28)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Environment&Social","index":7,"n_rows":32,"n_cols":13,"rows_kept":32,"merged":[[1,3,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[3,6,3,9],[12,3,12,4],[12,6,12,9],[13,3,13,4],[13,6,13,9],[14,3,14,4],[14,6,14,9],[15,3,15,4],[15,6,15,9],[16,3,16,4],[16,6,16,9],[17,3,17,4],[17,6,17,9],[18,3,18,4],[18,6,18,9],[19,3,19,4],[19,6,19,9],[22,3,22,4],[22,6,22,9],[23,3,23,4],[23,6,23,9],[24,3,24,4],[24,6,24,9],[27,3,27,4],[27,6,27,9],[28,3,28,4],[28,6,28,9],[29,3,29,4],[29,6,29,9],[30,3,30,4],[30,6,30,9]]}
[]
[{"$nulls":3},"Selbstauskunft/Bemerkungen Lieferant\n Selfassessment/Remarks Supplier",null,"Antwort Lieferant Response Supplier","Kübler Beurteilung / Bemerkungen",{"$nulls":3},"Bewertung/ Rating"]
[]
[null,"Umwelt&Soziales / Environment&Social",{"$nulls":3},{"$f":"((AVERAGE(M14:M20,M23:M25,M28:M31)*100)/10)","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(((AVERAGE(K14:K20,K23:K25,K28:K31))*100)/10)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},10,null,"Berechnungs hilfe SA"]
[{"$nulls":5},"Ja/Yes",{"$nulls":4},8]
[{"$nulls":5},"Nein/No",{"$nulls":4},6]
[{"$nulls":10},4]
[{"$nulls":10},0]
[{"$nulls":10},"nr"]
[]
[1,"Umwelt/Environment"]
["1.1","Umweltschutz verantwortliche Person benannt","Environment responsible person defined",{"$nulls":9},{"$f":"IF(F14=$F$7,10,IF(F14=$F$8,0,IF(F14=$F$9,\"\",IF(F14=$F$10,0))))","v":""}]
["1.2","Unternehmen gemäß ISO 14001 oder ähnlich zertifiziert","Certified regarding ISO 140001 or similar",{"$nulls":9},{"$f":"IF(F15=$F$7,10,IF(F15=$F$8,0,IF(F15=$F$9,\"\",IF(F15=$F$10,0))))","v":""}]
["1.3","Ist der Einfluß des Unternehmens auf die Umwelt bekannt (Verschmutzung, Abwasser..)","Is the impact of the company's activities on the environment known (pollution, waste water...)",{"$nulls":9},""]
["1.4","Unternehmen gemäß DIN EN ISO 50001 oder ähnliches zertifiziert","Certified regarding DIN EN ISO 50001 or similar",{"$nulls":9},""]
["1.5","Maßnahmen zur Senkung des Energieverbrauchs werden definiert und überwacht","Measures to decrease the environmental impact are defined and monitored",{"$nulls":9},""]
["1.6","Sind die REACH und RoHS Richtlinien und Verpflichtungen bekannt und werden diese eingehalten","Are the obligations of the REACH and RoHS standard known and respected",{"$nulls":9},""]
["1.7","Gibt es einen REACH und RoHS Verantwortlichen","REACH and RoHS responsible person defined",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M14:M20)","v":{"$error":"#DIV/0!"}}]
[2,"Soziales/Social"]
["2.1","Mindestalter für Beschäftigte älter 15 Jahre.","No worker younger than 15 years",{"$nulls":9},{"$f":"IF(F23=$F$7,10,IF(F23=$F$8,0,IF(F23=$F$9,\"\",IF(F23=$F$10,0))))","v":""}]
["2.2","Gesetzliche Mindestlöhne werden eingehalten und Überstunden werden entlohnt","All wages are over legal minimum and all overtimes get paid",{"$nulls":9},""]
["2.3","Werden soziale Projekte unterstützt","Support of social projects",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M23:M25)","v":{"$error":"#DIV/0!"}}]
[3,"Arbeitssicherheit/Worksafety"]
["3.1","Gibt es einen Sicherheitsbeautragten","Is a dedicated person responsible for work safety?",{"$nulls":9},""]
["3.2","Unternehmen gemäß OSHAS 18001 oder ähnliches Zertifiziert","Certified regarding OSHAS 18001 or similar",{"$nulls":9},""]
["3.3","Gab es die letzten 3 Jahre einen Arbeitssicherheitsunfall","Was there a work safety accident the past 3 years",{"$nulls":9},""]
["3.3","Sind Gefahrenstellen ausreichend beschildert","Are dangerous spots signposted?",{"$nulls":9},""]
[{"$nulls":12},{"$f":"AVERAGE(M28:M31)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Auswertung SARA","index":8,"n_rows":72,"n_cols":23,"rows_kept":72,"hidden":true,"merged":[[2,0,2,1],[2,2,2,3],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[6,0,6,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[15,3,15,5],[21,0,21,11],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[29,0,29,3],[29,7,29,11],[29,12,29,15],[29,16,29,17],[30,12,30,13],[31,9,31,11],[31,12,31,13],[33,12,33,13],[34,1,34,3],[34,4,34,6],[34,9,34,11],[34,12,34,13],[34,19,36,19],[34,21,36,21],[35,1,35,3],[35,4,35,6],[35,9,35,11],[35,12,35,13],[36,1,36,3],[36,4,36,6],[36,9,36,11],[36,12,36,13],[39,1,39,3],[39,4,39,6],[39,9,39,11],[39,12,39,13],[39,19,44,19],[39,21,44,21],[40,1,40,3],[40,4,40,6],[40,9,40,11],[40,12,40,13],[41,1,41,3],[41,4,41,6],[41,9,41,11],[41,12,41,13],[42,1,42,3],[42,4,42,6],[42,9,42,11],[42,12,42,13],[43,1,43,3],[43,4,43,6],[43,9,43,11],[43,12,43,13],[44,1,44,3],[44,4,44,6],[44,9,44,11],[44,12,44,13],[45,8,45,10],[45,11,45,12],[48,1,48,3],[48,4,48,6],[48,9,48,11],[48,12,48,13],[48,19,52,19],[48,21,52,21],[49,1,49,3],[49,4,49,6],[49,9,49,11],[49,12,49,13],[50,1,50,3],[50,4,50,6],[50,9,50,11],[50,12,50,13],[51,1,51,3],[51,4,51,6],[51,9,51,11],[51,12,51,13],[52,1,52,3],[52,4,52,6],[52,9,52,11],[52,12,52,13],[55,1,55,3],[55,4,55,6],[55,9,55,11],[55,12,55,13],[55,19,57,19],[55,21,57,21],[56,1,56,3],[56,4,56,6],[56,9,56,11],[56,12,56,13],[57,1,57,3],[57,4,57,6],[57,9,57,11],[57,12,57,13],[60,1,60,3],[60,4,60,6],[60,9,60,11],[60,12,60,13],[60,19,61,19],[60,21,61,21],[61,1,61,3],[61,4,61,6],[61,9,61,11],[61,12,61,13],[65,1,65,3],[65,4,65,6],[65,9,65,11],[65,12,65,13],[65,19,67,19],[65,21,67,21],[66,1,66,3],[66,4,66,6],[66,9,66,11],[66,12,66,13],[67,1,67,3],[67,4,67,6],[67,9,67,11],[67,12,67,13],[70,17,70,20],[70,22,71,22],[71,17,71,20]]}
["Lieferantenbewertung / Supplier Scorecard "]
[]
["Name Lieferant / Supplier Name:",null,{"$f":"'Overview & Manual'!C9:D9","v":0}]
["Erstellt von: / Completed by:"]
["Datum / Date:"]
[]
[null,null,"Selbstauskunft  Lieferant  \n\n\nSelfassessement Supplier","Bewertung KüblerSelbstauskunft  Lieferant Ziel 80%\n\nRating Kübler Selfassessement Supplier Target 80%","Jährliche Performance\n\n\n\nYearly Performance","Target"]
["Management Management",null,{"$f":"Management!F4","v":{"v":0,"d":"0.00"}},{"$f":"Management!K4","v":{"$error":"#DIV/0!"}},{"$f":"S38","v":{"v":0,"d":"0.00"}},{"v":80,"d":"80.00"}]
["Technologie Technologie",null,{"$f":"Technic!F4","v":{"v":0,"d":"0.00"}},{"$f":"Technic!K4","v":{"$error":"#DIV/0!"}},{"$f":"S47","v":{"v":0,"d":"0.00"}},{"v":80,"d":"80.00"}]
["Qualität Quality",null,{"$f":"Quality!F4","v":{"v":0,"d":"0.00"}},{"$f":"Quality!K4","v":{"$error":"#DIV/0!"}},{"$f":"S54","v":{"v":0,"d":"0.00"}},{"v":80,"d":"80.00"}]
["Kommunikation Communication",null,{"$f":"Communication!F4","v":{"$error":"#DIV/0!"}},{"$f":"Communication!K4","v":{"$error":"#DIV/0!"}},{"$f":"S59","v":{"v":0,"d":"0.00"}},{"v":80,"d":"80.00"}]
["Kosten&Logistik Costs&Logistic",null,{"$f":"'Costs &Logistic'!F4","v":{"$error":"#DIV/0!"}},{"$f":"'Costs &Logistic'!K4","v":{"$error":"#DIV/0!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"v":80,"d":"80.00"}]
["Umwelt&Soziales Environment&Social",null,{"$f":"'Environment&Social'!F4","v":{"$error":"#DIV/0!"}},{"$f":"'Environment&Social'!K4","v":{"$error":"#DIV/0!"}},{"$f":"S69","v":{"v":0,"d":"0.00"}},{"v":80,"d":"80.00"}]
["Gesamt Total",null,{"$f":"AVERAGE(C8:C13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(E8:E13)","v":{"$error":"#REF!"}},{"$f":"AVERAGE(F8:F13)","v":{"v":80,"d":"80.00"}}]
[]
["Ergebnis Jahr / Year",null,null,2018,null,null,{"$f":"E14","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
["Bewertungsmatrix"]
["10 = Vollständig erfüllt / Exzellent",null,null,10,null,10]
["8 = Überwiegend erfüllt, geringfügige Abweichungen (Verbesserungspotenzial)",null,null,8]
["6 = Teilweise erfüllt, größere Abweichungen",null,null,6]
["4  = Unzureichend erfüllt, schwerwiegende Abweichung",null,null,4]
["0  = Nicht erfüllt, nicht existent - inakzeptabel",null,null,0,null,0]
["nr = nicht relevant / nicht bewertet",null,null,"nr"]
[]
["Jährliche Lieferantenbewertung / Annual Supplier Evaluation ",{"$nulls":6},"Kübler",{"$nulls":4},"Lieferant  supplier",{"$nulls":3},"Kübler "]
[]
[{"$nulls":7},"Bewertung / Rating","Maßnahme Lieferant notwendig?\nAction Supplier nessecary?","Bemerkungen Kübler rating / remarks",null,null,"Maßnahme Action",null,"Zieldatum  Target Date","Verantwortlicher / responsible Person","Bemerkung Remarks","Erledigt  Done","Gewicht-\ntung \nin %","Anteil an Sara","erreichte \nPunktzahl","Ergebnis x Gewichtung"]
[]
[1,null,null,"Management"]
["1.1","Lieferant ist flexibel im Falle von unerwarteten Situationen z.B. kurzfristige Lieferungen, Ersatzlieferungen und unterstützt Fa. Kübler",null,null,"Supplier is flexible in case of unexpected situations e.g. short-term deliveries, replacement deliveries and supports the company Kübler",null,null,10,{"$f":"IF(H35<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},60,10,{"$f":"H35*S35","v":600},{"$f":"U38*0.1","v":100}]
["1.2","Der Lieferant respektiert Kübler als geschätzten Kunden",null,null,"The supplier respects Kübler as valued customer",null,null,10,{"$f":"IF(H36<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},20,null,{"$f":"H36*S36","v":200}]
["1.3","Lieferant war keinen Katastophen wie Bränden, Überschwemmungen, Erdbeben ect. ausgesetzt.",null,null,"No catastophes like fires, flood, earth quake ect. at supplier",null,null,10,"",{"$nulls":9},20,null,{"$f":"H37*S37","v":200}]
[{"$nulls":20},{"$f":"SUM(U35:U37)","v":1000}]
[2,null,null,"Technologie/Technology"]
["2.1","Keine Lieferverzögerungen durch fehlende Fertigungskapazität",null,null,"No delivery delays due to lack of production capacity",null,null,10,{"$f":"IF(H40<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},20,30,{"$f":"H40*20","v":200},{"$f":"U46*0.3","v":300}]
["2.2","Maschinenpark/Fertigungstechnologien erfüllt die Erwartungen von Fa. Kübler",null,null,"Machinery/production technologies meets the expectations of Kübler",null,null,10,"",{"$nulls":9},20,null,{"$f":"H41*S41","v":200}]
["2.3","Gespächspartner sind in der Lage technisch zu unterstützen",null,null,"Partners are able to provide technical support",null,null,10,"",{"$nulls":9},15,null,{"$f":"H42*S42","v":150}]
["2.4","Lieferant unterstützt Kübler während der Entwicklung",null,null,"Supplier supports Kübler during development",null,null,10,"",{"$nulls":9},15,null,{"$f":"H43*S43","v":150}]
["2.5","Lieferant informiert Fa. Kübler  rechtzeitig über Prozeßänderungen",null,null,"Supplier informs Kübler about process changes",null,null,10,"",{"$nulls":9},10,null,{"$f":"H44*S44","v":100}]
["2.6","Änderungen werden in der vereinbarten Zeit eingeführt",null,null,"Product changes are done in the agreed time",null,null,10,"",{"$nulls":9},20,null,{"$f":"H45*S45","v":200}]
[{"$nulls":20},{"$f":"SUM(U40:U45)","v":1000}]
[]
[3,null,null,"Qualität/Quality"]
["3.1","ISO Certificate Iso 9001 / IATF 16949 gültig",null,null,"ISO Certificate / IATF 16949 valid",null,null,0,{"$f":"IF(H49<10,\"ja/yes\",\"\")","v":"ja/yes"},{"$nulls":9},15,30,{"$f":"H49*S49","v":0},{"$f":"U54*0.3","v":0}]
["3.2","8D Reporte sind effektiv (keine Wiederholfehler)",null,null,"8D Reports are effective (no recurrence)",null,null,0,"ja/yes",{"$nulls":9},20,null,{"$f":"H50*S50","v":0}]
["3.3","Qualitätsprobleme in vereinbarter Zeit abgestellt",null,null,"Qualitiy problems are closed in the agreed time",null,null,0,"ja/yes",{"$nulls":9},20,null,{"$f":"H51*S51","v":0}]
["3.4","Keine Produktionsausfälle wegen Qualitätsproblemen",null,null,"No production stops at Kübler caused by quality problems",null,null,0,"ja/yes",{"$nulls":9},30,null,{"$f":"H52*S52","v":0}]
["3.5","Lieferant ist proaktiv um die Qualitätsziele zu erreichen",null,null,"Supplier is proactive to meet the quality targets",null,null,0,"ja/yes",{"$nulls":9},15,null,{"$f":"H53*S53","v":0}]
[{"$nulls":20},{"$f":"SUM(U49:U53)","v":0}]
[4,null,null,"Kommunikation/Communication"]
["4.1","Auftragsbestätigungen werden innerhalb 3 Arbeitstage an Kübler gesendet.",null,null,"Orderconfirmations arrive within 3 buisness days",null,null,10,{"$f":"IF(H56<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},33,10,{"$f":"H56*S56","v":330},{"$f":"U59*0.1","v":99}]
["4.2","Lieferant antwortet auf auf alle anfallenden Fragen (Technik, Lieferzeit,Preise…) innerhalb einer angemessenen Zeit.",null,null,"Supplier answers to all questions that may occur (technology, delivery time, price ...) within a reasonable time.",null,null,10,"",{"$nulls":9},33,null,{"$f":"H57*S57","v":330}]
["4.3","Kontaktpersonen sind gut zu erreichen",null,null,"Partners are are easy to reach",null,null,10,"",{"$nulls":9},33,null,{"$f":"H58*S58","v":330}]
[{"$nulls":20},{"$f":"SUM(U56:U58)","v":990}]
[5,null,null,"Kosten&Logistik/Costs&Logistics"]
["5.1","Bonitätsindex",null,null,"creditworthiness",null,null,10,{"$f":"IF(H61<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},50,10,{"$f":"H61*S61","v":500},{"$f":"U63*0.1","v":100}]
["5.2","Bonitätsindex hat sich verschlechtert",null,null,"creditworthiness decreased",null,null,10,"",{"$nulls":9},50,null,{"$f":"H62*S62","v":500}]
[{"$nulls":20},{"$f":"SUM(U61:U62)","v":1000}]
[]
[6,null,null,"Umwelt&Soziales"]
["5.1","Gab es REACH Abweichungen im letzten Jahr",null,null,"Any REACH findings the past year",null,null,10,{"$f":"IF(H66<10,\"ja/yes\",\"\")","v":""},{"$nulls":9},40,10,{"$f":"H66*S66","v":400},{"$f":"U69*0.1","v":100}]
["5.2","Neue Auflagen von Externen (z.B. Versicherungen, Behörden, Kunden)",null,null,"Any new restrictions of a third party",null,null,10,"",{"$nulls":9},30,null,{"$f":"H67*S67","v":300}]
["5.3","Arbeitsunfälle im letzten Jahr",null,null,"Any big work accidents the past year",null,null,10,"",{"$nulls":9},30,null,{"$f":"H68*S68","v":300}]
[{"$nulls":20},{"$f":"SUM(U64:U68)","v":1000}]
[{"$nulls":21},"Erreichte Punktzahl","Erreichte % Zahl"]
[{"$nulls":17},"Ergebnis SARA \nSARA Result",{"$nulls":3},{"$f":"SUM(V35:V70)","v":699},{"$f":"V71*100/V72","v":{"v":69.96996996996997,"d":"70"}}]
[{"$nulls":17},"max mögliche Punkte",{"$nulls":3},999]

{"sheet":"Scorecard","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"hidden":true,"merged":[[5,0,5,7]]}
[null,"Lieferant",{"$nulls":3},"Datum"]
[null,{"$f":"'Auswertung SARA'!C3:D3","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Ergebnis der jährlichen Lieferantenbewertung der Firma Fritz Kübler GmbH "]
[]
[{"$nulls":3},"Ziel in %","Ergebnis in %","Ergebnis"]
[null,null,"Liefertreue (DKZ)",100,44,{"$f":"IF(E9<=70,\"Anforderungen nicht erfüllt\",IF(E9<=85,\"Anforderungen teilweise erfüllt\",\"Anforderungen erfüllt\"))","v":"Anforderungen nicht erfüllt"}]
[null,null,"Reklamationsquote (QKZ)",100,74,{"$f":"IF(E10<=70,\"Anforderungen nicht erfüllt\",IF(E10<=85,\"Anforderungen teilweise erfüllt\",\"Anforderungen erfüllt\"))","v":"Anforderungen teilweise erfüllt"}]
[null,null,"Kosten",100,88,{"$f":"IF(E11<=70,\"Anforderungen nicht erfüllt\",IF(E11<=85,\"Anforderungen teilweise erfüllt\",\"Anforderungen erfüllt\"))","v":"Anforderungen erfüllt"}]
[null,null,"Auditergebnis (SKZ)",100,67,{"$f":"IF(E12<=70,\"Anforderungen nicht erfüllt\",IF(E12<=85,\"Anforderungen teilweise erfüllt\",\"Anforderungen erfüllt\"))","v":"Anforderungen nicht erfüllt"}]
[null,null,"SARA* Ergebnis",100,{"$f":"'Auswertung SARA'!W71","v":{"v":69.96996996996997,"d":"70"}},{"$f":"IF(E13<=70,\"Anforderungen nicht erfüllt\",IF(E13<=85,\"Anforderungen teilweise erfüllt\",\"Anforderungen erfüllt\"))","v":"Anforderungen nicht erfüllt"}]

{"sheet":"Regeln","index":10,"n_rows":13,"n_cols":1,"rows_kept":13,"hidden":true,"merged":[[10,0,10,6],[12,0,12,6]]}
["Lieferantenqualifizierung Regeln zur Lenkung vom Dokument"]
[]
["1. Dokumentvorlage wurde abgelegt unter:"]
["X:\\VORLAGEN\\MSOFFICE\\SCM"]
[]
[]
["2. Nach und während der Bearbeitung wird das Dokument je Lieferant abgelegt unter: "]
["P:\\SCM\\30_Lieferanten\\\"Lieferantname\"\\02_Standards"]
[]
[]
["3. Dokument wird: \na) von KD (SCM/SCM-QM) vorbereitet\nb) Tabellenblatt Yearly Result, Regeln und Revision werden für die Selbstauskunft ausgeblendet.(Scorecard wird erst zur jährlichen Bewertung wieder eingeblendet). \n    Die einzelnen Blattschutze müssen aktiviert sein.\nb) von Lieferant ausgefüllt und per E-Mail in Excel-Format an KÜBLER (SCM/SCM-QM) übermittelt;"]
[]
["Bewertung (nach VDA-Logik):\n10 Punkte: Technische Vorgaben zu Produkt und Prozess werden eingehalten.\n8 Punkte: Prozessschwächen sind vorhanden, werden jedoch sofort erkannt und beseitigt.\n6 Punkte: Prozessstörungen, Produkte können nicht prozesssicher hergestellt werden.\n4 Punkte: Produkte können nicht prozesssicher hergestellt werden. Prozessfähigkeit nicht erreicht.\n0 Punkte: Maschinen, Anlagen ungeeignet. Reklamationen und Feldausfälle sind zu erwarten.\nnr: nicht relevant => kein Einfluss auf die Bewertung"]

{"sheet":"Revision","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
["Rev.","Datum","wer","Änderung/Ergänzung"]
["01.","2018-08-07","ahu","Erstellen des Dokuments"]
["02.","2018-12-14","ahu","Gewichtung und Formatierung"]
["03.","2019-02-05","ahu","Berechnung der Bewertung Kübler. "]
["04.","2019-03-13","ahu","Druckbereiche angelegt/angepasst"]
["05","2018-04-16","ahu","Redaktionelle Anpassungen"]