{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Lieferantenselbstauskunft"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"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":"Lieferantenselbstauskunft","index":0,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[[15,2,15,4],[94,5,94,6],[96,0,96,1],[96,2,96,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[22,2,22,4],[97,0,97,1],[97,2,97,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[35,2,35,4],[31,2,31,4],[32,2,32,4],[34,2,34,4],[33,2,33,4],[0,0,0,4],[90,2,90,4],[91,2,91,4],[92,2,92,4],[93,2,93,4],[3,2,3,4],[19,2,19,4],[27,2,27,4],[17,2,17,4],[24,2,24,4],[25,2,25,4],[21,2,21,4],[5,2,5,4],[6,2,6,4],[11,2,11,4],[10,2,10,4],[2,1,2,4],[13,2,13,4],[14,2,14,4],[1,0,1,4],[99,0,99,4],[94,0,95,4],[7,2,7,4],[8,2,8,4],[12,2,12,4],[23,2,23,4],[9,2,9,4],[26,2,26,4],[4,2,4,4],[16,2,16,4],[18,2,18,4],[20,2,20,4]]}
["Manufacturer and Supplier Self-Audit-Questionnaire Indirect Materials\n             ",null,null,null,null,"X"]
[{"$f":"A100","v":"0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0"}]
["Nr.","indirekte Materialien = Anlagen(-teile), Bedarfsgegenstände, technische Hilfsmittel, Hilfs- und Betriebsstoffe\nindirect materials = machines, machine parts, commodities, facilities, auxiliary and operating materials",null,null,null,null,null,"Prüf-summe"]
[1,"Unternehmensdaten / Company data","Kommentar / Opinion"]
["1.1","Gelieferte Artikel\nDelivered material",null,null,null,null,null,{"$f":"IF(C5>\"\",CODE(C5)+LEN(C5),0)","v":0}]
["1.2","Name des Unternehmens\nName of the company",null,null,null,null,null,0]
["1.3","Adresse (PLZ, Ort, Straße, Nummer)\nAddress (postcode, town, street, number)",null,null,null,null,null,0]
["1.4","Homepage / Homepage",null,null,null,null,null,0]
["1.5","Zentrale (Telefon, Fax, E-Mail)\nHeadquarters (telephone, fax, e-mail)",null,null,null,null,null,0]
["1.6","Geschäftsform (AG, KG usw.)                                \nLegal form (public limited company, limited partnership etc.)",null,null,null,null,null,0]
["1.7","Gründungsdatum\nDate of foundation",null,null,null,null,null,0]
["1.8","Anzahl der Mitarbeiter\nNumber of employees",null,null,null,null,null,0]
["1.9","Jahresumsatz der letzten 3 Jahre\nAnnual turnover of last 3 years",null,null,null,null,null,0]
["1.10","Jahresumsatz mit DMK der letzten 3 Jahre\nAnnual turnover with DMK of last 3 years",null,null,null,null,null,0]
["1.11","Gewinn der letzten 3 Jahre\nProfit of last 3 years",null,null,null,null,null,0]
["1.12","Eigenkapitalquote der letzten 3 Jahre\nEquity ratio of last 3 years",null,null,null,null,null,0]
["1.13","Investitionsquote der letzten 3 Jahre\nInvestment ratio of last 3 years",null,null,null,null,null,0]
["1.14","Haftungsgrenze (mind. 10 Mio. €) bei Produkthaftungsversicherung\nLimit of liability (min. 10 m. €) in case of product liability insurance               ",null,null,null,null,null,0]
["1.15","Name der Versicherung\nName of insurance",null,null,null,null,null,0]
[2,"Ansprechpartner / Contact","Kommentar / Opinion",null,null,null,null,{"$f":"SUM(H5:H19)","v":0}]
["2.1","Geschäftsleitung (Name, Tel., Fax, E-Mail) \nManagement (name, telephone, fax, e-mail)",null,null,null,null,null,{"$f":"IF(C21>\"\",CODE(C21)+LEN(C21),0)","v":0}]
["2.2","Vertrieb (Name, Tel., Fax, E-Mail)                      \nSales (name, telephone, fax, e-mail)",null,null,null,null,null,0]
["2.3","Qualitätsmanagement (Name, Tel., Fax, E-Mail)                                                                     \nQuality Management (name, telephone, fax, e-mail)",null,null,null,null,null,0]
["2.4","Qualitätssicherung (Name, Tel., Fax, E-Mail)          \nQuality Assurance (name, telephone, fax, e-mail)",null,null,null,null,null,0]
["2.5","Forschung u. Entwicklung (Name, Tel., Fax, E-Mail)                                                                    \nR & D (name, telephone, fax, e-mail)",null,null,null,null,null,0]
["2.6","Reklamationswesen (Name, Tel., Fax, E-Mail)\nComplaints department (name, telephone, fax, e-mail)",null,null,null,null,null,0]
["2.7","Notfallkontakt (7T/24h) (Name, Tel, Fax, E-Mail)\nEmergency office (7d/24h) (name, telephone, fax, e-mail)",null,null,null,null,null,0]
[3,"Unternehmensangaben / Company information","Kommentar / Opinion",null,null,null,null,{"$f":"SUM(H21:H27)","v":0}]
["3.1","Gehören Sie einem Konzern an? (Name, Anteil in Prozent)  \nDo you belong to a group? (name, stake in per cent)",null,null,null,null,null,{"$f":"IF(C29>\"\",CODE(C29)+LEN(C29),0)","v":0}]
["3.2","Verwaltungssitz Konzern (Adresse)\nHead office (address)",null,null,null,null,null,0]
["3.3","Wird alternativ von anderen Standorten als dem unter \"Unternehmensdaten\" genanntem Betrieb beliefert? Wenn ja, von welchem? \nDo you deliver alternatively from other locations than the plant named under \"company data\"?",null,null,null,null,null,0]
["3.4","Eigenfertigung (Anteil in %)\nown production (percentage)",null,null,null,null,null,0]
["3.5","Auftragsfertigung/Subunternehmer (Anteil in %)\nsubcontractors (percentage)",null,null,null,null,null,0]
["3.6","Fremdbezug (Anteil in %)\nexternal porcurment (percentage)",null,null,null,null,null,0]
["3.7","Niedriglohnländer (Anteil in %)\nlow-wage countries (percentage)",null,null,null,null,null,0]
[4,"Informationen zu Produkten / Information about products","Kommentar / Opinion",null,null,null,null,{"$f":"SUM(H29:H35)","v":0}]
["4.1","Wie sind die Produktionskapazitäten an dem/n Standort/en?\nWhich production capacities do you have at the location?",null,null,null,null,null,{"$f":"IF(C37>\"\",CODE(C37)+LEN(C37),0)","v":0}]
["4.2","Welche Produktionstechnologien werden angewendet (z.B. Druckverfahren)?\nWhich production technologies are used (e.g. printing)?",null,null,null,null,null,{"$f":"IF(C38>\"\",CODE(C38)+LEN(C38),0)","v":0}]
["4.3","Welche Lagerkapazitäten sind gegeben (standortabhängig)?\nWhich storage capacities do you have (location dependent)?",null,null,null,"max.\nPunkte","Punkte",{"$f":"IF(C39>\"\",CODE(C39)+LEN(C39),0)","v":0}]
[5,"QM &  Zertifizierung (bitte die Zertifikate anbei legen!) /                                \nQuality Management/ Certification (please enclose the certificates!)","ja/yes","nein/no","Kommentar / Opinion\nErgebnis / result\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H37:H39)","v":0}]
["5.1","Zertifizierung nach ISO 9001\nCertification by ISO 9001",null,null,null,{"$f":"IF(OR(LEFT(E41,3)=\"n.a\",E41=\"na\",LEFT(E41,4)=\"n. a\",LEFT(E41,3)=\"n/a\",LEFT(E41,3)=\"n a\",LEFT(E41,3)=\"n./\",LEFT(E41,3)=\"na.\",LEFT(E41,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C41=\"X\",F41,0)","v":0},{"$f":"IF(C41=\"x\",51,IF(D41=\"x\",51*2,0))+IF(E41>\"\",CODE(E41)+LEN(E41),0)","v":0}]
["5.2","Umwelt-Zertifizierung (z.B. nach 14001 oder EMAS II/III) / Ergebnis\nEco-Certification (e.g. by ISO 14001 or EMAS II/III) / Result",null,null,null,{"$f":"IF(OR(LEFT(E42,3)=\"n.a\",E42=\"na\",LEFT(E42,4)=\"n. a\",LEFT(E42,3)=\"n/a\",LEFT(E42,3)=\"n a\",LEFT(E42,3)=\"n./\",LEFT(E42,3)=\"na.\",LEFT(E42,3)=\"./.\"),0,2)","v":2},0,{"$f":"IF(C42=\"x\",52,IF(D42=\"x\",52*2,0))+IF(E42>\"\",CODE(E42)+LEN(E42),0)","v":0}]
["5.3","Arbeitssicherheits-Zertifizierung (z.B. nach OHSAS, 18001 oder SCC) / Ergebnis\nOccupational safety certification (e.g. by OHSAS, 18001 or SCC) / Result",null,null,null,{"$f":"IF(OR(LEFT(E43,3)=\"n.a\",E43=\"na\",LEFT(E43,4)=\"n. a\",LEFT(E43,3)=\"n/a\",LEFT(E43,3)=\"n a\",LEFT(E43,3)=\"n./\",LEFT(E43,3)=\"na.\",LEFT(E43,3)=\"./.\"),0,2)","v":2},0,{"$f":"IF(C43=\"x\",53,IF(D43=\"x\",53*2,0))+IF(E43>\"\",CODE(E43)+LEN(E43),0)","v":0}]
["5.4","Energiemanagement-Zertifizierung (z.B. nach DIN ISO 50001) / Ergebnis\nEnergymanagement-certification (e.g. by ISO 50001) / Result",null,null,null,{"$f":"IF(OR(LEFT(E44,3)=\"n.a\",E44=\"na\",LEFT(E44,4)=\"n. a\",LEFT(E44,3)=\"n/a\",LEFT(E44,3)=\"n a\",LEFT(E44,3)=\"n./\",LEFT(E44,3)=\"na.\",LEFT(E44,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C44=\"x\",54,IF(D44=\"x\",54*2,0))+IF(E44>\"\",CODE(E44)+LEN(E44),0)","v":0}]
["5.5","Unternehmerische Gesellschaftsverantwortung (z.B. SA 8000, 26000, BSCI oder Sedex/Smeta) / Ergebnis\nCorporate Social Responsibility (e.g. by SA 8000, 26000, BSCI or Sedex/Smeta) / Result",null,null,null,{"$f":"IF(OR(LEFT(E45,3)=\"n.a\",E45=\"na\",LEFT(E45,4)=\"n. a\",LEFT(E45,3)=\"n/a\",LEFT(E45,3)=\"n a\",LEFT(E45,3)=\"n./\",LEFT(E45,3)=\"na.\",LEFT(E45,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C45=\"x\",55,IF(D45=\"x\",55*2,0))+IF(E45>\"\",CODE(E45)+LEN(E45),0)","v":0}]
["5.6","Sonstiges System (welches?) / Ergebnis\nOther System (which one?) / Result",null,null,null,{"$f":"IF(OR(LEFT(E46,3)=\"n.a\",E46=\"na\",LEFT(E46,4)=\"n. a\",LEFT(E46,3)=\"n/a\",LEFT(E46,3)=\"n a\",LEFT(E46,3)=\"n./\",LEFT(E46,3)=\"na.\",LEFT(E46,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C46=\"x\",56,IF(D46=\"x\",56*2,0))+IF(E46>\"\",CODE(E46)+LEN(E46),0)","v":0}]
[6,"Risikoabschätzung / risk assessment","ja/yes","nein/no","Kommentar/ Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H41:H46)","v":0}]
["6.1","Ist eine Risikoabschätzung für Materialien vorhanden, von denen sich vernünftigerweise voraussagen lässt, dass sie mit Lebensmitteln in Berührung kommen?                                                         \nIs a risk assessment available for materials, which can reasonably be expected to be brought into contact with food?",null,null,null,{"$f":"IF(OR(LEFT(E48,3)=\"n.a\",E48=\"na\",LEFT(E48,4)=\"n. a\",LEFT(E48,3)=\"n/a\",LEFT(E48,3)=\"n a\",LEFT(E48,3)=\"n./\",LEFT(E48,3)=\"na.\",LEFT(E48,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C48=\"X\",F48,0)","v":0},{"$f":"IF(C48=\"x\",61,IF(D48=\"x\",61*2,0))+IF(E48>\"\",CODE(E48)+LEN(E48),0)","v":0}]
["6.2","Sind Maßnahmen bei Abweichungen festgelegt?          \nHave measures been defined in case of deviations?",null,null,null,{"$f":"IF(OR(LEFT(E49,3)=\"n.a\",E49=\"na\",LEFT(E49,4)=\"n. a\",LEFT(E49,3)=\"n/a\",LEFT(E49,3)=\"n a\",LEFT(E49,3)=\"n./\",LEFT(E49,3)=\"na.\",LEFT(E49,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C49=\"X\",F49,0)","v":0},{"$f":"IF(C49=\"x\",62,IF(D49=\"x\",62*2,0))+IF(E49>\"\",CODE(E49)+LEN(E49),0)","v":0}]
[7,"Spezifikationen / \nSpecifications","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H48:H49)","v":0}]
["7.1","Liegen eindeutige und aktuelle Produktspezifikationen (wo zutreffend: +Konformitätserklärungen) für alle eingesetzten Materialien vor?                                     \nAre clear and up-to-date product specifications  (if applicable: +declaration of compliance) available for all applied materials?",null,null,null,{"$f":"IF(OR(LEFT(E51,3)=\"n.a\",E51=\"na\",LEFT(E51,4)=\"n. a\",LEFT(E51,3)=\"n/a\",LEFT(E51,3)=\"n a\",LEFT(E51,3)=\"n./\",LEFT(E51,3)=\"na.\",LEFT(E51,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C51=\"X\",F51,0)","v":0},{"$f":"IF(C51=\"x\",71,IF(D51=\"x\",71*2,0))+IF(E51>\"\",CODE(E51)+LEN(E51),0)","v":0}]
["7.2","Liegen eindeutige Produktspezifikationen für das Endprodukt vor?                                                     \nAre clear product specifications available for the final product?",null,null,null,{"$f":"IF(OR(LEFT(E52,3)=\"n.a\",E52=\"na\",LEFT(E52,4)=\"n. a\",LEFT(E52,3)=\"n/a\",LEFT(E52,3)=\"n a\",LEFT(E52,3)=\"n./\",LEFT(E52,3)=\"na.\",LEFT(E52,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C52=\"X\",F52,0)","v":0},{"$f":"IF(C52=\"x\",72,IF(D52=\"x\",72*2,0))+IF(E52>\"\",CODE(E52)+LEN(E52),0)","v":0}]
["7.3","Wird der Kunde bei Änderungen der Spezifikationen zeitnah verständigt?                                             \nIs the customer informed of specification changes contemporary?",null,null,null,{"$f":"IF(OR(LEFT(E53,3)=\"n.a\",E53=\"na\",LEFT(E53,4)=\"n. a\",LEFT(E53,3)=\"n/a\",LEFT(E53,3)=\"n a\",LEFT(E53,3)=\"n./\",LEFT(E53,3)=\"na.\",LEFT(E53,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C53=\"X\",F53,0)","v":0},{"$f":"IF(C53=\"x\",74,IF(D53=\"x\",74*2,0))+IF(E53>\"\",CODE(E53)+LEN(E53),0)","v":0}]
["7.4","Liegen für alle Bedarfsgegenstände und Anlagenteile, von denen sich vernünftigerweise voraussagen lässt, dass sie mit Lebensmitteln in Berührung kommen, aktuelle und eindeutige Konformitätserklärungen vor?\nAre clear and actual declarations of compliance available for commodities and plant sections, which can reasonably be expected to be brought into contact with food?",null,null,null,{"$f":"IF(OR(LEFT(E54,3)=\"n.a\",E54=\"na\",LEFT(E54,4)=\"n. a\",LEFT(E54,3)=\"n/a\",LEFT(E54,3)=\"n a\",LEFT(E54,3)=\"n./\",LEFT(E54,3)=\"na.\",LEFT(E54,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C54=\"X\",F54,0)","v":0},{"$f":"IF(C54=\"x\",75,IF(D54=\"x\",75*2,0))+IF(E54>\"\",CODE(E54)+LEN(E54),0)","v":0}]
["7.5","Falls Punkt 7.4 zutreffend, werden regelmäßig Migrationstests durchgeführt? \nIf item 7.4 is applicable, are migration tests carried out regularly?",null,null,null,{"$f":"IF(OR(LEFT(E55,3)=\"n.a\",E55=\"na\",LEFT(E55,4)=\"n. a\",LEFT(E55,3)=\"n/a\",LEFT(E55,3)=\"n a\",LEFT(E55,3)=\"n./\",LEFT(E55,3)=\"na.\",LEFT(E55,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C55=\"X\",F55,0)","v":0},{"$f":"IF(C55=\"x\",76,IF(D55=\"x\",76*2,0))+IF(E55>\"\",CODE(E55)+LEN(E55),0)","v":0}]
[8,"Umweltschutz / Arbeitsschutz \nEnvironmental protection / Health and safety protection at the workplace","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H51:H55)","v":0}]
["8.1","Haben Sie einen Umweltbeauftragten benannt?     \nHave you appointed an environmental officer?",null,null,null,{"$f":"IF(OR(LEFT(E57,3)=\"n.a\",E57=\"na\",LEFT(E57,4)=\"n. a\",LEFT(E57,3)=\"n/a\",LEFT(E57,3)=\"n a\",LEFT(E57,3)=\"n./\",LEFT(E57,3)=\"na.\",LEFT(E57,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C57=\"X\",F57,0)","v":0},{"$f":"IF(C57=\"x\",81,IF(D57=\"x\",81*2,0))+IF(E57>\"\",CODE(E57)+LEN(E57),0)","v":0}]
["8.2","Haben Sie eine Umweltpolitik formuliert?              \nDo you have an environmental policy?",null,null,null,{"$f":"IF(OR(LEFT(E58,3)=\"n.a\",E58=\"na\",LEFT(E58,4)=\"n. a\",LEFT(E58,3)=\"n/a\",LEFT(E58,3)=\"n a\",LEFT(E58,3)=\"n./\",LEFT(E58,3)=\"na.\",LEFT(E58,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C58=\"x\",82,IF(D58=\"x\",82*2,0))+IF(E58>\"\",CODE(E58)+LEN(E58),0)","v":0}]
["8.3","Halten Sie alle umweltrelevanten Vorschriften und behördlichen Genehmigungsauflagen nachweislich ein?\nDo you provably comply with all environmentally relevant regulations and official licensing requirements?",null,null,null,{"$f":"IF(OR(LEFT(E59,3)=\"n.a\",E59=\"na\",LEFT(E59,4)=\"n. a\",LEFT(E59,3)=\"n/a\",LEFT(E59,3)=\"n a\",LEFT(E59,3)=\"n./\",LEFT(E59,3)=\"na.\",LEFT(E59,3)=\"./.\"),0,2)","v":2},0,{"$f":"IF(C59=\"x\",83,IF(D59=\"x\",83*2,0))+IF(E59>\"\",CODE(E59)+LEN(E59),0)","v":0}]
["8.4","Haben Sie einen Sicherheitsbeauftragten oder eine Sicherheitsfachkraft benannt?\nDo you have appointed a safety advisor or a safety specialist?",null,null,null,{"$f":"IF(OR(LEFT(E60,3)=\"n.a\",E60=\"na\",LEFT(E60,4)=\"n. a\",LEFT(E60,3)=\"n/a\",LEFT(E60,3)=\"n a\",LEFT(E60,3)=\"n./\",LEFT(E60,3)=\"na.\",LEFT(E60,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C60=\"x\",84,IF(D60=\"x\",84*2,0))+IF(E60>\"\",CODE(E60)+LEN(E60),0)","v":0}]
["8.5","Haben Sie Gefährdungsbeurteilungen gemäß Arbeitsschutzrecht, Betriebssicherheits-verordnung und Gefahrstoffverordnung durchgeführt?\nDid you carry out risk assessments according to labour protection law, ordinance on industrial safety and health and ordinance on hazardous substances?",null,null,null,{"$f":"IF(OR(LEFT(E61,3)=\"n.a\",E61=\"na\",LEFT(E61,4)=\"n. a\",LEFT(E61,3)=\"n/a\",LEFT(E61,3)=\"n a\",LEFT(E61,3)=\"n./\",LEFT(E61,3)=\"na.\",LEFT(E61,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C61=\"x\",85,IF(D61=\"x\",85*2,0))+IF(E61>\"\",CODE(E61)+LEN(E61),0)","v":0}]
["8.6","Besuchen nachweislich alle betroffenen Mitarbeiter jährlich eine Sicherheitsschulung (Arbeitsschutz/Gefahrstoffe)?\nDo all employees concerned verifiably take part in annual safety trainings (health and safety protection at workplace/ hazardous substances)?",null,null,null,{"$f":"IF(OR(LEFT(E62,3)=\"n.a\",E62=\"na\",LEFT(E62,4)=\"n. a\",LEFT(E62,3)=\"n/a\",LEFT(E62,3)=\"n a\",LEFT(E62,3)=\"n./\",LEFT(E62,3)=\"na.\",LEFT(E62,3)=\"./.\"),0,1)","v":1},0,{"$f":"IF(C62=\"x\",86,IF(D62=\"x\",86*2,0))+IF(E62>\"\",CODE(E62)+LEN(E62),0)","v":0}]
["8.7","Werden Aktivitäten im Hinblick auf nachhaltiges Handeln vorgenommen?\nDo you carry out activities in respect of sustainability?",null,null,null,{"$f":"IF(OR(LEFT(E63,3)=\"n.a\",E63=\"na\",LEFT(E63,4)=\"n. a\",LEFT(E63,3)=\"n/a\",LEFT(E63,3)=\"n a\",LEFT(E63,3)=\"n./\",LEFT(E63,3)=\"na.\",LEFT(E63,3)=\"./.\"),0,2)","v":2},0,{"$f":"IF(C63=\"x\",87,IF(D63=\"x\",87*2,0))+IF(E63>\"\",CODE(E63)+LEN(E63),0)","v":0}]
[9,"Rücknahmeaktionen / Withdrawal actions","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H57:H63)","v":0}]
["9.1","Ist ein dokumentiertes Verfahren für eine Rücknahme festgelegt?                                                       \nHas a documented process for a withdrawal been set?",null,null,null,{"$f":"IF(OR(LEFT(E65,3)=\"n.a\",E65=\"na\",LEFT(E65,4)=\"n. a\",LEFT(E65,3)=\"n/a\",LEFT(E65,3)=\"n a\",LEFT(E65,3)=\"n./\",LEFT(E65,3)=\"na.\",LEFT(E65,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C65=\"X\",F65,0)","v":0},{"$f":"IF(C65=\"x\",91,IF(D65=\"x\",91*2,0))+IF(E65>\"\",CODE(E65)+LEN(E65),0)","v":0}]
["9.2","Wird das Rücknahmeverfahren regelmäßig (mind. 1x jährlich) getestet und ausgewertet?              \nAre withdrawal actions checked and evaluated regularly (at least once a year)?",null,null,null,{"$f":"IF(OR(LEFT(E66,3)=\"n.a\",E66=\"na\",LEFT(E66,4)=\"n. a\",LEFT(E66,3)=\"n/a\",LEFT(E66,3)=\"n a\",LEFT(E66,3)=\"n./\",LEFT(E66,3)=\"na.\",LEFT(E66,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C66=\"X\",F66,0)","v":0},{"$f":"IF(C66=\"x\",92,IF(D66=\"x\",92*2,0))+IF(E66>\"\",CODE(E66)+LEN(E66),0)","v":0}]
["10.1","Ist die Rückverfolgbarkeit der eingesetzten Komponenten gewährleistet?\nDo you ensure traceability of the applied components?",null,null,null,{"$f":"IF(OR(LEFT(E67,3)=\"n.a\",E67=\"na\",LEFT(E67,4)=\"n. a\",LEFT(E67,3)=\"n/a\",LEFT(E67,3)=\"n a\",LEFT(E67,3)=\"n./\",LEFT(E67,3)=\"na.\",LEFT(E67,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C67=\"X\",F67,0)","v":0},{"$f":"IF(C67=\"x\",101,IF(D67=\"x\",101*2,0))+IF(E67>\"\",CODE(E67)+LEN(E67),0)","v":0}]
["10.3","Können Sie die notwendigen Unterlagen innerhalb von 4 Stunden bereitstellen?\nIs it possible to provide the necessary documents within 4 hours?",null,null,null,{"$f":"IF(OR(LEFT(E68,3)=\"n.a\",E68=\"na\",LEFT(E68,4)=\"n. a\",LEFT(E68,3)=\"n/a\",LEFT(E68,3)=\"n a\",LEFT(E68,3)=\"n./\",LEFT(E68,3)=\"na.\",LEFT(E68,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C68=\"X\",F68,0)","v":0},{"$f":"IF(C68=\"x\",103,IF(D68=\"x\",103*2,0))+IF(E68>\"\",CODE(E68)+LEN(E68),0)","v":0}]
[11,"Prozessteuerung / Process control","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" /\nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H65:H68)","v":0}]
["11.1","Werden dokumentierte Inprozess-Kontrollen durchgeführt?\nDo you perform documented in-process controls?",null,null,null,{"$f":"IF(OR(LEFT(E70,3)=\"n.a\",E70=\"na\",LEFT(E70,4)=\"n. a\",LEFT(E70,3)=\"n/a\",LEFT(E70,3)=\"n a\",LEFT(E70,3)=\"n./\",LEFT(E70,3)=\"na.\",LEFT(E70,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C70=\"X\",F70,0)","v":0},{"$f":"IF(C70=\"x\",111,IF(D70=\"x\",111*2,0))+IF(E70>\"\",CODE(E70)+LEN(E70),0)","v":0}]
["11.2","Gibt es festgelegte Vorgaben für den Produktionsprozess?\nDo guidelines exist for the production process?",null,null,null,{"$f":"IF(OR(LEFT(E71,3)=\"n.a\",E71=\"na\",LEFT(E71,4)=\"n. a\",LEFT(E71,3)=\"n/a\",LEFT(E71,3)=\"n a\",LEFT(E71,3)=\"n./\",LEFT(E71,3)=\"na.\",LEFT(E71,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C71=\"X\",F71,0)","v":0},{"$f":"IF(C71=\"x\",112,IF(D71=\"x\",112*2,0))+IF(E71>\"\",CODE(E71)+LEN(E71),0)","v":0}]
[12,"Reklamationsmanagement / Complaints management","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H70:H71)","v":0}]
["12.1","Ist ein dokumentiertes Verfahren zum Reklamationsmanagement festgelegt?\nHas a documented process for complaints management been determined?",null,null,null,{"$f":"IF(OR(LEFT(E73,3)=\"n.a\",E73=\"na\",LEFT(E73,4)=\"n. a\",LEFT(E73,3)=\"n/a\",LEFT(E73,3)=\"n a\",LEFT(E73,3)=\"n./\",LEFT(E73,3)=\"na.\",LEFT(E73,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C73=\"X\",F73,0)","v":0},{"$f":"IF(C73=\"x\",121,IF(D73=\"x\",121*2,0))+IF(E73>\"\",CODE(E73)+LEN(E73),0)","v":0}]
["12.2","Werden die Reklamationen regelmäßig ausgewertet?\nAre complaints evaluated regularly?",null,null,null,{"$f":"IF(OR(LEFT(E74,3)=\"n.a\",E74=\"na\",LEFT(E74,4)=\"n. a\",LEFT(E74,3)=\"n/a\",LEFT(E74,3)=\"n a\",LEFT(E74,3)=\"n./\",LEFT(E74,3)=\"na.\",LEFT(E74,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C74=\"X\",F74,0)","v":0},{"$f":"IF(C74=\"x\",122,IF(D74=\"x\",122*2,0))+IF(E74>\"\",CODE(E74)+LEN(E74),0)","v":0}]
["12.3","Werden aufgrund von Reklamationen Verbesserungsmaßnahmen eingeleitet?\nDo you introduce improvements on the basis of complaints?",null,null,null,{"$f":"IF(OR(LEFT(E75,3)=\"n.a\",E75=\"na\",LEFT(E75,4)=\"n. a\",LEFT(E75,3)=\"n/a\",LEFT(E75,3)=\"n a\",LEFT(E75,3)=\"n./\",LEFT(E75,3)=\"na.\",LEFT(E75,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C75=\"X\",F75,0)","v":0},{"$f":"IF(C75=\"x\",123,IF(D75=\"x\",123*2,0))+IF(E75>\"\",CODE(E75)+LEN(E75),0)","v":0}]
[13,"Lieferantenbewertung / \nSupplier assessment","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H73:H75)","v":0}]
["13.1","Liegen für die von Ihnen eingesetzten Rohwaren aktuelle Soll- und Grenzwerte vor?\nDo actual reference and limit values exist for the raw materials used in your company?",null,null,null,{"$f":"IF(OR(LEFT(E77,3)=\"n.a\",E77=\"na\",LEFT(E77,4)=\"n. a\",LEFT(E77,3)=\"n/a\",LEFT(E77,3)=\"n a\",LEFT(E77,3)=\"n./\",LEFT(E77,3)=\"na.\",LEFT(E77,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C77=\"X\",F77,0)","v":0},{"$f":"IF(C77=\"x\",141,IF(D77=\"x\",141*2,0))+IF(E77>\"\",CODE(E77)+LEN(E77),0)","v":0}]
["13.2","Ist ein Verfahren bei Überschreitung von Grenzwerten festgelegt?\nIs a process determined in case of limit values are exceeded?",null,null,null,{"$f":"IF(OR(LEFT(E78,3)=\"n.a\",E78=\"na\",LEFT(E78,4)=\"n. a\",LEFT(E78,3)=\"n/a\",LEFT(E78,3)=\"n a\",LEFT(E78,3)=\"n./\",LEFT(E78,3)=\"na.\",LEFT(E78,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C78=\"X\",F78,0)","v":0},{"$f":"IF(C78=\"x\",143,IF(D78=\"x\",143*2,0))+IF(E78>\"\",CODE(E78)+LEN(E78),0)","v":0}]
[14,"Instandhaltung / \nMaintenance","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H77:H78)","v":0}]
["14.1","Gibt es einen festgelegten Wartungsplan?\nDoes a service plan exist?",null,null,null,{"$f":"IF(OR(LEFT(E80,3)=\"n.a\",E80=\"na\",LEFT(E80,4)=\"n. a\",LEFT(E80,3)=\"n/a\",LEFT(E80,3)=\"n a\",LEFT(E80,3)=\"n./\",LEFT(E80,3)=\"na.\",LEFT(E80,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C80=\"X\",F80,0)","v":0},{"$f":"IF(C80=\"x\",161,IF(D80=\"x\",161*2,0))+IF(E80>\"\",CODE(E80)+LEN(E80),0)","v":0}]
["14.2","Werden Anlagen nach Wartungs- und Instandsetzungsmaßnahmen gereinigt, geprüft und freigegeben?\nAre plants cleaned, checked and released after maintenance and repair service?",null,null,null,1,{"$f":"IF(C81=\"X\",F81,0)","v":0},{"$f":"IF(C81=\"x\",162,IF(D81=\"x\",162*2,0))+IF(E81>\"\",CODE(E81)+LEN(E81),0)","v":0}]
["14.3","Wird eine negative Beeinflussung der Produkte durch Lagerhaltung und Transport verhindert?\nIs a negative influence of products through storage and transport prevented?",null,null,null,{"$f":"IF(OR(LEFT(E82,3)=\"n.a\",E82=\"na\",LEFT(E82,4)=\"n. a\",LEFT(E82,3)=\"n/a\",LEFT(E82,3)=\"n a\",LEFT(E82,3)=\"n./\",LEFT(E82,3)=\"na.\",LEFT(E82,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C82=\"X\",F82,0)","v":0},{"$f":"IF(C82=\"x\",181,IF(D82=\"x\",181*2,0))+IF(E82>\"\",CODE(E82)+LEN(E82),0)","v":0}]
["14.4","Wird der Kunde bei Störungen während des Transportes verständigt?\nIs the client notified of disturbances during transport?                          ",null,null,null,1,{"$f":"IF(C83=\"X\",F83,0)","v":0},{"$f":"IF(C83=\"x\",182,IF(D83=\"x\",182*2,0))+IF(E83>\"\",CODE(E83)+LEN(E83),0)","v":0}]
[15,"Unternehmerische Gesellschaftsverantwortung /\nCorporate Social Responsibility ","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H80:H83)","v":0}]
["15.1","Gibt es in Ihrem Unternehmen Bemühungen um Menschenrechte zu achten? Welche?\nDoes your company do efforts to respect for human rights? Which?",null,null,null,{"$f":"IF(OR(LEFT(E85,3)=\"n.a\",E85=\"na\",LEFT(E85,4)=\"n. a\",LEFT(E85,3)=\"n/a\",LEFT(E85,3)=\"n a\",LEFT(E85,3)=\"n./\",LEFT(E85,3)=\"na.\",LEFT(E85,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C85=\"X\",F85,0)","v":0},{"$f":"IF(C85=\"x\",191,IF(D85=\"x\",191*2,0))+IF(E85>\"\",CODE(E85)+LEN(E85),0)","v":0}]
["15.2","Gibt es in Ihrem Unternehmen Verhaltenscodizes zu Diskriminierung / Belästigung?\nDohou have codes of conduct for discrimination / harassment in your company?",null,null,null,{"$f":"IF(OR(LEFT(E86,3)=\"n.a\",E86=\"na\",LEFT(E86,4)=\"n. a\",LEFT(E86,3)=\"n/a\",LEFT(E86,3)=\"n a\",LEFT(E86,3)=\"n./\",LEFT(E86,3)=\"na.\",LEFT(E86,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C86=\"X\",F86,0)","v":0},{"$f":"IF(C86=\"x\",192,IF(D86=\"x\",192*2,0))+IF(E86>\"\",CODE(E86)+LEN(E86),0)","v":0}]
["15.3","Haben Sie Vorschriften, die Kinderarbeit und Zwangsarbeit ausschließen?\nDo you have provisions that exclude child and forced labor?",null,null,null,{"$f":"IF(OR(LEFT(E87,3)=\"n.a\",E87=\"na\",LEFT(E87,4)=\"n. a\",LEFT(E87,3)=\"n/a\",LEFT(E87,3)=\"n a\",LEFT(E87,3)=\"n./\",LEFT(E87,3)=\"na.\",LEFT(E87,3)=\"./.\"),0,1)","v":1},{"$f":"IF(C87=\"X\",F87,0)","v":0},{"$f":"IF(C87=\"x\",193,IF(D87=\"x\",193*2,0))+IF(E87>\"\",CODE(E87)+LEN(E87),0)","v":0}]
[16,"Sonstiges / \nOther matters","ja/yes","nein/no","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / \nif not applicable: \"n.a.\")",null,null,{"$f":"SUM(H85:H87)","v":0}]
["16.1","Erfolgt unverzüglich eine schriftliche Information an DMK über mögliche Änderungen oder Abweichungen der Produkte? \nDo you inform DMK immediately with a written statement about possible changes or variations of the products?",null,null,null,{"$f":"IF(OR(LEFT(E89,3)=\"n.a\",E89=\"na\",LEFT(E89,4)=\"n. a\",LEFT(E89,3)=\"n/a\",LEFT(E89,3)=\"n a\",LEFT(E89,3)=\"n./\",LEFT(E89,3)=\"na.\",LEFT(E89,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C89=\"X\",F89,0)","v":0},{"$f":"IF(C89=\"x\",201,IF(D89=\"x\",201*2,0))+IF(E89>\"\",CODE(E89)+LEN(E89),0)","v":0}]
["16.2","Sind Sie mit einem Audit / einer Betriebsbesichtigung in Ihrem Hause nach entsprechender Absprache einverstanden?\nDo you agree with an audit / a site visit in your plant after appropriate request?",null,null,null,{"$f":"IF(OR(LEFT(E90,3)=\"n.a\",E90=\"na\",LEFT(E90,4)=\"n. a\",LEFT(E90,3)=\"n/a\",LEFT(E90,3)=\"n a\",LEFT(E90,3)=\"n./\",LEFT(E90,3)=\"na.\",LEFT(E90,3)=\"./.\"),0,2)","v":2},{"$f":"IF(C90=\"X\",F90,0)","v":0},{"$f":"IF(C90=\"x\",202,IF(D90=\"x\",202*2,0))+IF(E90>\"\",CODE(E90)+LEN(E90),0)","v":0}]
[17,"Referenzen / References","Kommentar / Opinion\n(falls nicht zutreffend: \"n.a.\" / if not applicable: \"n.a.\")",null,null,null,null,{"$f":"SUM(H89:H90)","v":0}]
["17.1","Bisher wurde vorwiegend für folgende Industrien gearbeitet:\nSo far been mainly worked for the following industries:",null,null,null,"max.\nPunkte","Punkte",{"$f":"IF(C92>\"\",CODE(C92)+LEN(C92),0)","v":0}]
["17.2","Allgemeine Referenzen (Unternehmen, Jahr):\nGeneral references (company, year) :",null,null,null,{"$f":"SUM(F41:F90)","v":58},{"$f":"SUM(G41:G90)","v":0},{"$f":"IF(C93>\"\",CODE(C93)+LEN(C93),0)","v":0}]
["17.3","Besondere Referenzen aus der Lebensmittelindustrie (Unternehmen, Jahr):\nSpecific references from the food industry (company, year):",null,null,null,"Gesamt",{"$f":"IF(G93>0,G93*100/F93,0)","v":0},{"$f":"IF(C94>\"\",CODE(C94)+LEN(C94),0)","v":0}]
["Alle gemachten Angaben sind wahrheitsgemäß.                                                                                                                                                                                                                                                                                                                     All details provided are truthful.\n\nVertraulichkeitserklärung / Confidentiality statement:\nFür laufende sowie zukünftige Ausschreibungen sichern wir die vertrauliche Behandlung der erhaltenen sowie noch zu erhaltenden Informationen zu. Die Weiterleitung der Informationen an Dritte ist ausgeschlossen.\nFor current and future invitations to tender, we ensure the confidentiality of the obtained information and on information to be received. The information will not be forwarded to third parties.\n\nWir akzeptieren die Einkaufsbedingungen des DMK. \nWe accept the conditions of purchase of DMK.",null,null,null,null,{"$f":"IF(G94<60,\"C-Lieferant\",IF(AND(G94>=60,G94<85),\"B-Lieferant\",\"A-Lieferant\"))","v":"C-Lieferant"},null,{"$f":"SUM(H92:H94)","v":0}]
[]
[]
["Datum\nDate",null,"Stempel, rechtsverbindliche Unterschrift\nStamp, legally binding signature"]
[]
[{"$f":"CONCATENATE(H20,\" - \",H28,\" - \",H36,\" - \",H40,\" - \",H47,\" - \",H50,\" - \",H56,\" - \",H64,\" - \",H69,\" - \",H72,\" - \",H76,\" - \",H79,\" - \",H84,\" - \",H88,\" - \",H91,\" - \",H95)","v":"0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0"}]