{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["auszufüllen_von_allen ","ohne Zert."],"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":"auszufüllen_von_allen ","index":0,"n_rows":101,"n_cols":8,"rows_kept":101,"cut":false,"hidden":false,"merged":[[11,2,11,4],[0,0,0,4],[1,1,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[23,2,23,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[35,2,35,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[70,0,71,0],[70,1,71,1],[70,2,71,2],[70,3,71,3],[87,2,87,4],[72,0,73,0],[72,1,73,1],[72,2,73,2],[72,3,73,3],[74,0,75,0],[74,1,75,1],[74,2,75,2],[74,3,75,3],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[85,2,85,4],[97,0,97,1],[97,2,97,4],[100,0,100,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[94,0,94,4],[95,0,95,4],[96,0,96,1],[96,2,96,4]]}
["Manufacturer and supplier Self Assessment Questionnaire feed\n             ",null,null,null,null,"X"]
["Nr.","direkte Materialien = (Roh- und Zusatzstoffe, Primär-, Sekundär-, Tertiärverpackungsmaterialien und Bedarfsgegenstände)     \ndirect materials = (row materials, additives, primary-, secondary-, tertiary packaging and food contact materials)",null,null,null,null,null,"Prüf-summe"]
[1,"Unternehmensdaten / Company data","Kommentar/ Opinion"]
["1.1","Gelieferter Artikel:\nDelivered material:",null,null,null,null,null,{"$f":"IF(C4>\"\",CODE(C4)+LEN(C4),0)","v":0}]
["1.2","Name des Unternehmens:\nName of the company:",null,null,null,null,null,{"$f":"IF(C5>\"\",CODE(C5)+LEN(C5),0)","v":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","Zahl der Mitarbeiter gesamt\nTotal number of employees:",null,null,null,null,null,0]
["1.8","Zahl der Mitarbeiter QM/ QS\nNumber of employees QM/ QA:",null,null,null,null,null,0]
["1.9","Zahl der Mitarbeiter F & E\nNumber of employees R & D:",null,null,null,null,null,0]
["1.10","Zahl der Mitarbeiter Produktion\nNumber of employees production:",null,null,null,null,null,0]
["1.11","Jahresumsatz\nAnnual turnover:",null,null,null,null,null,0]
["1.12","Haftungsgrenze (min. 5 Mio. €) bei Produkthaftungsversicherung :\nLimit (min. 5 m. €) of liability in case of product liability insurance:               ",null,null,null,null,null,0]
["1.13","Name der Versicherung\nName of insurance:",null,null,null,null,null,0]
[2,"Ansprechpartner / Contact","Kommentar/ Opinion",null,null,null,null,{"$f":"SUM(H4:H16)","v":0}]
["2.1","Geschäftsleitung (Name, Tel. Fax. E-mail): \nManagement (name, telephone, fax, e-mail):",null,null,null,null,null,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(H18:H24)","v":0}]
["3.1","Gehören sie einem Konzern an (Name)?\nDo you belong to a group (name)?",null,null,null,null,null,0]
["3.2","Verwaltungssitz Konzern (Adresse):\nHead office (address):",null,null,null,null,null,0]
["3.3","Wird alternativ von anderen Standorten als den unter \"Lieferantendaten\" genannten Betrieb beliefert? Wenn ja, von welchem? \nAre the supplies delivered alternatively from other locations than the plant named under \"supplier data\"?",null,null,null,null,null,0]
["3.4","Eigenfertigung (Anteil%)\nown production (percentage):",null,null,null,null,null,0]
["3.5","Auftragsfertigung/Subunternehmer (Anteil %)\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ändern (Anteil in %)\nlow-wage countiers (percentage):",null,null,null,null,null,0]
["3.8","Werden Produkte oder Teile von Produkten durch Dritte (Werklohnhersteller) hergestellt oder bearbeitet?\nAre products or components of products produced or processed by third parties (subcontractors)? ",null,null,null,null,null,0]
["3.9","Wenn ja, liegt das HACCP-Konzept dieses Werklohnherstellers vor? \nIf yes, is the HACCP concept of this subcontractor available?",null,null,null,null,null,0]
["3.10","Ist ein Verantwortlicher für diesen Werklohnhersteller benannt? \nHas a responsible person been appointed for this subcontractor?",null,null,null,null,null,0]
[4,"Informationen zu Produkten und Dienstleistungen / Informations to products and services","Kommentar/ Opinion",null,null,null,null,{"$f":"SUM(H26:H35)","v":0}]
["4.1","Wie sind die Produktionskapazitäten an dem/n Standort/en?\nHow are the production capacities of the location?",null,null,null,null,null,0]
["4.2","Welche Produktionstechnologien werden angewendet (z.B. Druckverfahren)?\nWhich production technologies are used (eg printing)?",null,null,null,null,null,0]
["4.3","Welche Lagerkapazitäten sind gegeben (standortabhängig)?\nWhat storage capacities are present (location dependent)?",null,null,null,"max.\nPunkte","Punkte",{"$f":"IF(C39>\"\",CODE(C39)+LEN(C39),0)","v":0}]
[null,null,"ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H37:H39)","v":0}]
["4.4","Erfolgt unverzüglich eine schriftliche Information an DMK über mögliche Änderungen oder Abweichungen der Produkte? \nTakes place immediately a written statement to DMK on possible changes or variations of the products?",null,null,null,2,{"$f":"IF(C41=\"X\",F41,0)","v":0},{"$f":"IF(C41=\"x\",44,IF(D41=\"x\",44*2,0))+IF(E41>\"\",CODE(E41)+LEN(E41),0)","v":0}]
["4.5","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,2,{"$f":"IF(C42=\"X\",F42,0)","v":0},{"$f":"IF(C42=\"x\",45,IF(D42=\"x\",45*2,0))+IF(E42>\"\",CODE(E42)+LEN(E42),0)","v":0}]
[5,"QM &  Zertifizierung/                                \nQuality Management/ Certification","ja/yes","nein/no","Kommentar/ Opinion\nErgebnis / result",null,null,{"$f":"SUM(H41:H42)","v":0}]
["5.1","Zertifizierung nach ISO 9001\nCertification by ISO 9001",null,null,null,1,{"$f":"IF(C44=\"X\",F44,0)","v":0},{"$f":"IF(C44=\"x\",51,IF(D44=\"x\",51*2,0))+IF(E44>\"\",CODE(E44)+LEN(E44),0)","v":0}]
["5.2","Zertifizierung nach (FSSC) ISO 22000\nCertification by (FSSC) ISO 22000\nBei ja: nur Punkte 1 - 13 beantworten\nBei nein: Punkte 1 - 36 beantworten\nif yes: answer only points 1 - 13\nif no: answer points 1 - 36",null,null,null,60,null,{"$f":"IF(C45=\"x\",52,IF(D45=\"x\",52*2,0))+IF(E45>\"\",CODE(E45)+LEN(E45),0)","v":0}]
["5.3","Zertifizierung nach GMP+/ Ergebnis\nCertification by GMP+/ Result\nBei ja: nur Punkte 1 - 13 beantworten\nBei nein: Punkte 1 - 36 beantworten\nif yes: answer only points 1 - 13\nif no: answer points 1 - 36",null,null,null,60,null,{"$f":"IF(C46=\"x\",53,IF(D46=\"x\",53*2,0))+IF(E46>\"\",CODE(E46)+LEN(E46),0)","v":0}]
["5.4","Zertifizierung nach QS/ Ergebnis\nCertification by QS/ Result\nBei ja: nur Punkte 1 - 13 beantworten\nBei nein: Punkte 1 - 36 beantworten\nif yes: answer only points 1 - 13\nif no: answer points 1 - 36",null,null,null,60,{"$f":"IF(OR(C46=\"X\",C47=\"X\",C48=\"X\",C49=\"X\"),60,0)","v":0},{"$f":"IF(C47=\"x\",54,IF(D47=\"x\",54*2,0))+IF(E47>\"\",CODE(E47)+LEN(E47),0)","v":0}]
["5.5","Zertifizierung nach IFS oder BRC Ergebnis\nCertification by/ Result IFS or BRC\nBei ja: nur Punkte 1 - 13 beantworten\nBei nein: Punkte 1 - 36 beantworten\nif yes: answer only points 1 - 13\nif no: answer points 1 - 36",null,null,null,60,null,{"$f":"IF(C48=\"x\",55,IF(D48=\"x\",55*2,0))+IF(E48>\"\",CODE(E48)+LEN(E48),0)","v":0}]
[null,"Zertifizierung nach Ovocom/ Ergebnis\nCertification by/ Result Ovocom\nBei ja: nur Punkte 1 - 13 beantworten\nBei nein: Punkte 1 - 36 beantworten\nif yes: answer only points 1 - 13\nif no: answer points 1 - 36",null,null,null,60]
["5.6","Umwelt-Zertifizierung (z.B. nach 14001 oder EMAS) / Ergebnis\nEco-Certification (e.g. by ISO 14001 or EMAS) / Result",null,null,null,1,{"$f":"IF(C50=\"X\",F50,0)","v":0},{"$f":"IF(C50=\"x\",56,IF(D50=\"x\",56*2,0))+IF(E50>\"\",CODE(E50)+LEN(E50),0)","v":0}]
["5.7","Arbeitssicherheits-Zertifizierung (z.B. nach OHSAS 18001, 45001 oder SCC) / Ergebnis\nOccupational safety certification (e.g. by OHSAS 18001, 45001 or SCC) / Result",null,null,null,1,0,{"$f":"IF(C51=\"x\",57,IF(D51=\"x\",57*2,0))+IF(E51>\"\",CODE(E51)+LEN(E51),0)","v":0}]
["5.8","Unternehmerische Gesellschaftsverantwortung (z.B. SA 8000, 26000, BSCI oder Sedex/Smeta) / Ergebnis\nCorporate Social Responsibility (for example by SA 8000, 26000, BSCI or Sedex/Smeta) results?",null,null,null,1,0,{"$f":"IF(C52=\"x\",58,IF(D52=\"x\",58*2,0))+IF(E52>\"\",CODE(E52)+LEN(E52),0)","v":0}]
["5.9","Sonstiges System (welches?) / Ergebnis\nOther System (which one?) / Result",null,null,null,1,0,{"$f":"IF(C53=\"x\",59,IF(D53=\"x\",59*2,0))+IF(E53>\"\",CODE(E53)+LEN(E53),0)","v":0}]
[6,"HACCP","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H44:H53)","v":0}]
["6.1","Sind Gefährdungsanalyse und Risikoabschätzung vorhanden?                                                             \nIs a hazard analysis and risk assessment available?",null,null,null,2,0,{"$f":"IF(C55=\"x\",61,IF(D55=\"x\",61*2,0))+IF(E55>\"\",CODE(E55)+LEN(E55),0)","v":0}]
["6.2","Ist ein HACCP-Konzept oder ein anderes System zur Qualitätssicherung vorhanden?                       \nIs a HACCP Plan or any other system of quality assurance available?",null,null,null,1,0,{"$f":"IF(C56=\"x\",62,IF(D56=\"x\",62*2,0))+IF(E56>\"\",CODE(E56)+LEN(E56),0)","v":0}]
["6.3","Sind CCP´s bzw. spezielle Stellen / Punkte zur Prozesssteuerung identifiziert? Welche?                                       \nAre CCPs or places / points of process control identified ? Which?",null,null,null,1,0,{"$f":"IF(C57=\"x\",63,IF(D57=\"x\",63*2,0))+IF(E57>\"\",CODE(E57)+LEN(E57),0)","v":0}]
["6.4","Sind Maßnahmen bei Abweichungen festgelegt?          \nHave measures been stipulated in case of deviations?",null,null,null,1,0,{"$f":"IF(C58=\"x\",64,IF(D58=\"x\",64*2,0))+IF(E58>\"\",CODE(E58)+LEN(E58),0)","v":0}]
["6.5","Sind Fließdiagramme vorhanden?\nAre flow charts available?",null,null,null,1,0,{"$f":"IF(C59=\"x\",65,IF(D59=\"x\",65*2,0))+IF(E59>\"\",CODE(E59)+LEN(E59),0)","v":0}]
["6.6","Wird das Konzept jährlich revidiert?                                            \nIs the plan annually revised?",null,null,null,1,0,{"$f":"IF(C60=\"x\",66,IF(D60=\"x\",66*2,0))+IF(E60>\"\",CODE(E60)+LEN(E60),0)","v":0}]
["6.7","Werden nachweislich alle Mitarbeiter regelmäßig zum HACCP / System geschult?                          \nAre all employees trained verifiable in HACCP / the system?               ",null,null,null,1,0,{"$f":"IF(C61=\"x\",67,IF(D61=\"x\",67*2,0))+IF(E61>\"\",CODE(E61)+LEN(E61),0)","v":0}]
[7,"Fremdkörperkontrolle /                        \nForeign body check","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H55:H61)","v":0}]
["7.1","Sind alle Beleuchtungskörper mit Splitterschutz versehen?\nAre all lighting fixtures provided with splinter protection?",null,null,null,1,0,{"$f":"IF(C63=\"x\",71,IF(D63=\"x\",71*2,0))+IF(E63>\"\",CODE(E63)+LEN(E63),0)","v":0}]
["7.2","Gibt es ein Glas- und Hartplastikregister?\nIs there a register for glass and duroplastic plastics?",null,null,null,1,0,{"$f":"IF(C64=\"x\",72,IF(D64=\"x\",72*2,0))+IF(E64>\"\",CODE(E64)+LEN(E64),0)","v":0}]
["7.3","Werden alle Glas- und Hartplastikflächen regelmäßig kontrolliert?\nAre all surfaces made of glass and duroplastic plastics checked regularly?",null,null,null,2,0,{"$f":"IF(C65=\"x\",73,IF(D65=\"x\",73*2,0))+IF(E65>\"\",CODE(E65)+LEN(E65),0)","v":0}]
["7.4","Sind Heftklammern untersagt (auch bei Verpackungen von Roh- und Zustatzstoffen, Bedarfsgegenständen und Verpackungsmaterial)?\nAre staples forbidden (also with packages of raw materials and additives, commodities and packaging material)?",null,null,null,1,0,{"$f":"IF(C66=\"x\",74,IF(D66=\"x\",74*2,0))+IF(E66>\"\",CODE(E66)+LEN(E66),0)","v":0}]
["7.5","Ist Holz im Produktionsbereich untersagt? \nIs wood forbidden in production area?",null,null,null,1,0,{"$f":"IF(C67=\"x\",75,IF(D67=\"x\",75*2,0))+IF(E67>\"\",CODE(E67)+LEN(E67),0)","v":0}]
["7.6","Werden eingesetze Schneidwerkzeuge regelmäßig kontrolliert?\nAre applied cutting tools checked regularly?",null,null,null,1,0,{"$f":"IF(C68=\"x\",76,IF(D68=\"x\",76*2,0))+IF(E68>\"\",CODE(E68)+LEN(E68),0)","v":0}]
["7.7","Sind Cuttermesser mit Abbruchklingen untersagt?\nAre cutters with blades which can break off prohibited?",null,null,null,1,0,{"$f":"IF(C69=\"x\",77,IF(D69=\"x\",77*2,0))+IF(E69>\"\",CODE(E69)+LEN(E69),0)","v":0}]
["7.8","Sind Glasflaschen und andere Privatgegen-stände in der Produktion untersagt?\nAre glass bottles and other private objects prohibited in the production?",null,null,null,1,0,{"$f":"IF(C70=\"x\",78,IF(D70=\"x\",78*2,0))+IF(E70>\"\",CODE(E70)+LEN(E70),0)","v":0}]
["7.9","Gibt es Siebe und /oder Filter?\nAre there sieves and/ or filters?",null,null,"Maschenweite? mesh size?",1,{"$f":"IF(C71=\"X\",F71,0)","v":0},{"$f":"IF(C71=\"x\",790,IF(D71=\"x\",790*2,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(E72>\"\",CODE(E72)+LEN(E72),0)","v":0}]
["7.10","Gibt es Ferromagneten? \nAre there ferromagnets?",null,null,"Detektionslimit? detection limit?",1,{"$f":"IF(C73=\"X\",F73,0)","v":0},{"$f":"IF(C73=\"x\",791,IF(D73=\"x\",791*2,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(E74>\"\",CODE(E74)+LEN(E74),0)","v":0}]
["7.11","Gibt es Metalldetektoren?\nAre there metal detectors?",null,null,"Detektionslimit? detection limit?",1,{"$f":"IF(C75=\"X\",F75,0)","v":0},{"$f":"IF(C75=\"x\",792,IF(D75=\"x\",792*2,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(E76>\"\",CODE(E76)+LEN(E76),0)","v":0}]
["7.12","Gibt es Röntgendetektoren?\nAre there x-ray detectors?",null,null,"Detektionslimit? detection limit?",1,{"$f":"IF(C77=\"X\",F77,0)","v":0},{"$f":"IF(C77=\"x\",793,IF(D77=\"x\",793*2,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(E78>\"\",CODE(E78)+LEN(E78),0)","v":0}]
[8,"Spezifikationen / \nSpecifications","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H63:H78)","v":0}]
["8.1","Liegen eindeutige und aktuelle Produktspezifikationen (wo zutreffend: +Konformitätserklärungen) für alle eingesetzten Rezepturbestandteile / Materialien vor?                                     \nAre clear and up-to-date product specifications  (if applicable  declaration of compliance)  available for all applied formula components / materials?",null,null,null,2,0,{"$f":"IF(C80=\"x\",81,IF(D80=\"x\",81*2,0))+IF(E80>\"\",CODE(E80)+LEN(E80),0)","v":0}]
["8.3","Liegen eindeutige Produktspezifikationen für das Endprodukt vor?                                                     \nAre clear product specifications available for the final product?",null,null,null,2,0,{"$f":"IF(C81=\"x\",83,IF(D81=\"x\",83*2,0))+IF(E81>\"\",CODE(E81)+LEN(E81),0)","v":0}]
["8.4","Sind alle zutreffenden futtermittelrechtlichen Belange berücksichtigt? \nHave all relevant issues under feed law been taken into account?",null,null,null,1,0,{"$f":"IF(C82=\"x\",84,IF(D82=\"x\",84*2,0))+IF(E82>\"\",CODE(E82)+LEN(E82),0)","v":0}]
["8.5","Wird der Kunde bei Änderungen der Spezifikationen zeitnah verständigt?                                             \nIs the customer informed of specification changes in real time?",null,null,null,1,0,{"$f":"IF(C83=\"x\",85,IF(D83=\"x\",85*2,0))+IF(E83>\"\",CODE(E83)+LEN(E83),0)","v":0}]
[10,"Rückverfolgbarkeit / Tracibility","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H80:H83)","v":0}]
["10.1","Ist aktuell eine Rückverfolgbarkeit in Ihrem Hause anhand der Material- und Lieferangaben von DMK-Unternehmen möglich?\nIs the traceability actually possible in your company on the basis of material and supplier details of the DMK Group?",null,null,null,2,0,{"$f":"IF(C85=\"x\",101,IF(D85=\"x\",101*2,0))+IF(E85>\"\",CODE(E85)+LEN(E85),0)","v":0}]
["10.2","Darstellung der Codierung zur Rückverfolgung (bitte geben Sie die genaue Aufschlüsselung sowie Ausdruckstelle der Codierung an):\nRepresentation of the code to trace (please give the exact breakdown and printing position from the coding):",null,null,null,null,null,{"$f":"IF(C86>\"\",CODE(C86)+LEN(C86),0)","v":0}]
["10.3","Ist sichergestellt, dass der Kunde über ein Rückrufverfahren informiert wird?                         \nIs it ensured that the customer is informed about recall procedures?",null,"x",null,1,{"$f":"IF(C87=\"X\",F87,0)","v":0},{"$f":"IF(C87=\"x\",103,IF(D87=\"x\",103*2,0))+IF(E87>\"\",CODE(E87)+LEN(E87),0)","v":206}]
[11,"Referenzen / References","Kommentar/ Opinion",null,null,null,null,{"$f":"SUM(H85:H87)","v":206}]
["11.1","Bisher wurde vorwiegend für folgende Industrien gearbeitet:\nSo far been mainly worked for the following industries:",null,null,null,null,null,{"$f":"IF(C89>\"\",CODE(C89)+LEN(C89),0)","v":0}]
["11.2","Allgemeine Referenzen (Unternehmen, Jahr):\nGeneral references (company, year) :",null,null,null,null,null,0]
["11.3","Besondere Referenzen aus der Futtermittelindustrie (Unternehmen, Jahr):\nSpecific references from the food industry (company, year):",null,null,null,null,null,0]
[13,"Einkaufsbedingungen / Purchasing Conditions","ja/yes","nein/no",null,{"$f":"SUM(F41:F91)-240","v":99},{"$f":"SUM(G41:G91)","v":0},{"$f":"SUM(H89:H91)","v":0}]
["13.1","Erfolgte die Bekanntmachung der Einkaufsbedingungen durch eine persönliche Aushändigung / Empfang?\nWas the announcement of the conditions of purchase by personal delivery / reception?",null,null,null,"max.\nPunkte","Punkte",{"$f":"IF(C93=\"x\",131,IF(D93=\"x\",131*2,0))+IF(E93>\"\",CODE(E93)+LEN(E93),0)","v":0}]
["13.2","Erfolgte die Bekanntmachung der Einkaufsbedingungen über das Internet?\nWas the announcement of the conditions of purchase over the internet?",null,null,null,"Gesamt",{"$f":"IF(SUM(G47)=60,G92,G92+'ohne Zert.'!G92)","v":0},{"$f":"IF(C94=\"x\",132,IF(D94=\"x\",132*2,0))+IF(E94>\"\",CODE(E94)+LEN(E94),0)","v":0}]
[{"$f":"IF(AND(D45=\"X\",D46=\"X\",D47=\"X\",D48=\"X\"),\"Bitte füllen Sie auch im 2. Tabellenreiter Punkt 14-36 aus! / Please fill in the 2nd sheet no. 14-36!\",\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(H93:H94)","v":0}]
["Alle gemachten Angaben sind wahrheitsgemäß.                                                                                                                                                                                                                                                                                                                     All details provided are the truth.\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 forwarding of information to third parties is impossible.\n\nWir akzeptieren die Einkaufsbedingungen des DMK. \nWe accept the conditions of purchase of DMK.\n"]
[]
["Datum                                                                 Date",null,"Stempel, rechtverbindliche Unterschrift                                   Stamp, legally binding Signature"]
[]
[]
[{"$f":"CONCATENATE(\"Prüfsumme: \",H17,\" - \",H25,\" - \",H36,\" - \",H40,\" - \",H43,\" - \",H54,\" - \",H62,\" - \",H79,\" - \",H84,\" - \",H88,\" - \",H92,\" - \",H95)","v":"Prüfsumme: 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 206 - 0 - 0"}]

{"sheet":"ohne Zert.","index":1,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,0,0,4],[93,0,93,4]]}
["Lieferanten Selbstauditierungsbogen Futtermittel\nManufacturer and supplier Self Asessment Questionnaire Feed\n             ",null,null,null,null,"max.\nPunkte","Punkte","Prüf-summe","X"]
[14,"Rückrufaktionen/ \nRecall actions","ja/yes","nein/no","Kommentar/ Opinion"]
["14.1","Ist ein dokumentiertes Verfahren für einen Rückruf festgelegt ?                                                       \nHas a documented process been stipulated for a recall?",null,null,null,5,{"$f":"IF(C3=\"X\",F3,0)","v":0},{"$f":"IF(C3=\"x\",141,IF(D3=\"x\",141*2,0))+IF(E3>\"\",CODE(E3)+LEN(E3),0)","v":0}]
["14.2","Wird das Rückrufverfahren regelmäßig (mind. 1x jährlich) getestet und ausgewertet?              \nAre recall actions (at least once a year) checked and evaluated regularly (at least once a year)?",null,null,null,1,{"$f":"IF(C4=\"X\",F4,0)","v":0},{"$f":"IF(C4=\"x\",142,IF(D4=\"x\",142*2,0))+IF(E4>\"\",CODE(E4)+LEN(E4),0)","v":0}]
["14.3","Wird die ordnungsgemäße Entsorgung in Abstimmung mit dem Kunden überwacht?                \nIs proper waste disposal monitored by coordination with the client?",null,null,null,1,0,{"$f":"IF(C5=\"x\",143,IF(D5=\"x\",143*2,0))+IF(E5>\"\",CODE(E5)+LEN(E5),0)","v":0}]
[15,"Rückverfolgbarkeit/ \nTraceability","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H3:H5)","v":0}]
["15.1","Ist die Rückverfolgbarkeit von eingesetzten Roh- und Zusatzstoffen gewährleistet ?\nDo you ensure traceability of applied raw material and additives?",null,null,null,10,0,{"$f":"IF(C7=\"x\",151,IF(D7=\"x\",151*2,0))+IF(E7>\"\",CODE(E7)+LEN(E7),0)","v":0}]
["15.2","Ist die Rückverfolgbarkeit von eingesetzten produktberührende Anlagenteilen oder Bedarfs- und Hilfsgegenstände (z.B. Verpackungen) gewährleistet ?\nIs the traceability of applied plant parts or supplies which have contact with products (for example packaging) guaranteed?",null,null,null,1,0,{"$f":"IF(C8=\"x\",152,IF(D8=\"x\",152*2,0))+IF(E8>\"\",CODE(E8)+LEN(E8),0)","v":0}]
["15.3","Können sie die notwendigen Unterlagen innerhalb von 4 Stunden bereitstellen ?\nIs it possible to provide the essential documents within 4 hours?",null,null,null,1,0,{"$f":"IF(C9=\"x\",153,IF(D9=\"x\",153*2,0))+IF(E9>\"\",CODE(E9)+LEN(E9),0)","v":0}]
[16,"Prozessteuerung/ \nProcess control","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H7:H9)","v":0}]
["16.1","Werden Inprozess-Kontrollen durchgeführt ?\nAre there documented in-process control checks performed?",null,null,null,2,0,{"$f":"IF(C11=\"x\",161,IF(D11=\"x\",161*2,0))+IF(E11>\"\",CODE(E11)+LEN(E11),0)","v":0}]
["16.2","Gibt es festgelegte Vorgaben für den Produktionsprozess?\nDo guidelines exist for the production process?",null,null,null,1,0,{"$f":"IF(C12=\"x\",162,IF(D12=\"x\",162*2,0))+IF(E12>\"\",CODE(E12)+LEN(E12),0)","v":0}]
["16.3","Werden qualitätsrelevante Daten bis Ende MHD ihrer Produkte aufbewahrt ?\nAre data which are relevant for quality stored until end of best before date of products?",null,null,null,1,0,{"$f":"IF(C13=\"x\",163,IF(D13=\"x\",163*2,0))+IF(E13>\"\",CODE(E13)+LEN(E13),0)","v":0}]
[17,"Prüfmittel/ \nTesting equipment","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H11:H13)","v":0}]
["17.1","Sind Prüfmittel festgelegt und identifiziert ?\nIs testing equipment stipulated and identified?",null,null,null,0.5,0,{"$f":"IF(C15=\"x\",171,IF(D15=\"x\",171*2,0))+IF(E15>\"\",CODE(E15)+LEN(E15),0)","v":0}]
["17.2","Werden die verwendeten Prüfmittel verwaltet und regelmäßig überprüft ?\nAre applied testing equipment administered and checked regularly?",null,null,null,2,0,{"$f":"IF(C16=\"x\",172,IF(D16=\"x\",172*2,0))+IF(E16>\"\",CODE(E16)+LEN(E16),0)","v":0}]
[18,"Interne Audits/ \nInternal audits","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H15:H16)","v":0}]
["18.1","Werden interne Audits durchgeführt ?\nAre internal audits carried out?",null,null,null,0.5,0,{"$f":"IF(C18=\"x\",181,IF(D18=\"x\",181*2,0))+IF(E18>\"\",CODE(E18)+LEN(E18),0)","v":0}]
["18.2","Werden die Maßnahmen verfolgt ?\nAre measures tracked?",null,null,null,2,0,{"$f":"IF(C19=\"x\",182,IF(D19=\"x\",182*2,0))+IF(E19>\"\",CODE(E19)+LEN(E19),0)","v":0}]
["18.3","Werden die CCP´s mindestens einmal jährlich intern auditiert ?\nAre CCPs audited internally at least once a year? ",null,null,null,0.5,0,{"$f":"IF(C20=\"x\",183,IF(D20=\"x\",183*2,0))+IF(E20>\"\",CODE(E20)+LEN(E20),0)","v":0}]
[19,"Reklamationsmanagement/                        \nComplaints management","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H18:H20)","v":0}]
["19.1","Ist ein dokumentiertes Verfahren zum Reklamationsmanagement festgelegt ?\nHas a documented process for complaints management been stipulated?",null,null,null,5,0,{"$f":"IF(C22=\"x\",191,IF(D22=\"x\",191*2,0))+IF(E22>\"\",CODE(E22)+LEN(E22),0)","v":0}]
["19.2","Werden die Reklamationen regelmäßig ausgewertet ?\nAre complaints evaluated regularly?",null,null,null,0.5,0,{"$f":"IF(C23=\"x\",192,IF(D23=\"x\",192*2,0))+IF(E23>\"\",CODE(E23)+LEN(E23),0)","v":0}]
["19.3","Werden aufgrund von Reklamationen Verbesserungsmaßnahmen eingeleitet ?\nDo you introduce improvements on the basis of complaints?",null,null,null,0.5,0,{"$f":"IF(C24=\"x\",193,IF(D24=\"x\",193*2,0))+IF(E24>\"\",CODE(E24)+LEN(E24),0)","v":0}]
[20,"Lieferantenbewertung/                 \nSupplier assessment","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H22:H24)","v":0}]
["20.1","Findet eine regelmäßige und dokumentierte Lieferantenbewertung statt ?\nDo documented supplier assessments take place regularly?",null,null,null,1,0,{"$f":"IF(C26=\"x\",201,IF(D26=\"x\",201*2,0))+IF(E26>\"\",CODE(E26)+LEN(E26),0)","v":0}]
[21,"Qualitätssicherung/                               \nQuality Assurance","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H26)","v":0}]
["21.1","Liegen für die von Ihnen eingesetzten Roh- und Zusatzstoffe aktuelle Soll- und Grenzwerte vor?\nDo actual reference and threshold values exist for the raw materials and additives used in your company?",null,null,null,3,0,{"$f":"IF(C28=\"x\",211,IF(D28=\"x\",211*2,0))+IF(E28>\"\",CODE(E28)+LEN(E28),0)","v":0}]
["21.2","Liegen sowohl für Halbfertig- als auch für Endprodukte Soll- und Grenzwerte vor ?\nDo reference and threshold values exist for both semi-finished products and final products?",null,null,null,3,0,{"$f":"IF(C29=\"x\",212,IF(D29=\"x\",212*2,0))+IF(E29>\"\",CODE(E29)+LEN(E29),0)","v":0}]
["21.3","Ist ein Verfahren bei Überschreitung von Grenzwerten festgelegt ?\nIs a process stipulated in case threshold values are exceeded?",null,null,null,3,0,{"$f":"IF(C30=\"x\",213,IF(D30=\"x\",213*2,0))+IF(E30>\"\",CODE(E30)+LEN(E30),0)","v":0}]
["21.4","Ist das Laborpersonal für die durchzuführenden Analysen ausreichend qualifiziert?\nDo laboratory assistants have sufficient qualifications for the analyses which are to be conducted?",null,null,null,1,0,{"$f":"IF(C31=\"x\",214,IF(D31=\"x\",214*2,0))+IF(E31>\"\",CODE(E31)+LEN(E31),0)","v":0}]
["21.5","Wird an Ringanalysen teilgenommen?\nDo you participate in intra-laboratory analyses?",null,null,null,1,0,{"$f":"IF(C32=\"x\",215,IF(D32=\"x\",215*2,0))+IF(E32>\"\",CODE(E32)+LEN(E32),0)","v":0}]
["21.6","Wird mit externen Laboren zusammengearbeitet?\nDo you work together with external laboratories?",null,null,null,1,0,{"$f":"IF(C33=\"x\",216,IF(D33=\"x\",216*2,0))+IF(E33>\"\",CODE(E33)+LEN(E33),0)","v":0}]
["21.7","Wenn ja, sind diese akkreditiert ?\nIf yes, are these accredited?",null,null,null,1,0,{"$f":"IF(C34=\"x\",217,IF(D34=\"x\",217*2,0))+IF(E34>\"\",CODE(E34)+LEN(E34),0)","v":0}]
[22,"Werksgrenzen und Gelände/       \nFactory premises","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H28:H34)","v":0}]
["22.1","Ist das Werksgelände umzäunt und gesichert?\nAre factory premises fenced in and safeguarded? ",null,null,null,0.5,0,{"$f":"IF(C36=\"x\",221,IF(D36=\"x\",221*2,0))+IF(E36>\"\",CODE(E36)+LEN(E36),0)","v":0}]
["22.2","Ist der Zugang eingeschränkt und kontrolliert?\nIs entrance limited and supervised?",null,null,null,0.5,0,{"$f":"IF(C37=\"x\",222,IF(D37=\"x\",222*2,0))+IF(E37>\"\",CODE(E37)+LEN(E37),0)","v":0}]
[23,"Werksplanung und Materialfluss/ \nWorkflow and material flow","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H36:H37)","v":0}]
["23.1","Verhindern Personalwege und Materialfluß eine negative Beeinflussung des Produktes (Crosskontamination)?\nDo personnel routes and material flow prevent negative influence of products (cross-contamination)?                                     ",null,null,null,5,0,{"$f":"IF(C39=\"x\",231,IF(D39=\"x\",231*2,0))+IF(E39>\"\",CODE(E39)+LEN(E39),0)","v":0}]
[24,"Gebäude und Infrastruktur/ \nBuildings and infrastructure","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H39)","v":0}]
["24.1","Ist das Gebäude in gutem Zustand (Wände mit intaktem Anstrich ohne Schimmel, Böden intakt ohne Pfützenbildung)?                                          \nIs the state of repair good (walls with intact coat of paint without mould, intact ground without ponding)?",null,null,null,3,0,{"$f":"IF(C41=\"x\",241,IF(D41=\"x\",241*2,0))+IF(E41>\"\",CODE(E41)+LEN(E41),0)","v":0}]
["24.2","Sind die Werkzeuge und Arbeitsplätze in einem guten Zustand?                                                           \nAre tools and workplaces in a good condition?",null,null,null,0.5,0,{"$f":"IF(C42=\"x\",242,IF(D42=\"x\",242*2,0))+IF(E42>\"\",CODE(E42)+LEN(E42),0)","v":0}]
["24.3","Wird das Eindringen von Schädlingen verhindert? \nIs the infiltration of vermin prevented?   ",null,null,null,0.5,0,{"$f":"IF(C43=\"x\",243,IF(D43=\"x\",243*2,0))+IF(E43>\"\",CODE(E43)+LEN(E43),0)","v":0}]
[25,"Instandhaltung/ \nMaintenance","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H41:H43)","v":0}]
["25.1","Gibt es einen festgelegten Wartungsplan?\nDoes a service plan exist?",null,null,null,2,0,{"$f":"IF(C45=\"x\",251,IF(D45=\"x\",251*2,0))+IF(E45>\"\",CODE(E45)+LEN(E45),0)","v":0}]
["25.2","Werden Instandhaltungsmaßnahmen, insbesondere bei produktberührenden Teilen, erfaßt und ausgewertet?\nAre maintenance measures in particular with parts which come into contact with products recorded and evaluated?",null,null,null,0.5,0,{"$f":"IF(C46=\"x\",252,IF(D46=\"x\",252*2,0))+IF(E46>\"\",CODE(E46)+LEN(E46),0)","v":0}]
["25.3","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,0.5,0,{"$f":"IF(C47=\"x\",253,IF(D47=\"x\",253*2,0))+IF(E47>\"\",CODE(E47)+LEN(E47),0)","v":0}]
["25.4","Werden an den relevanten Punkten lebensmitteltaugliche Schmiermittel eingesetzt?     Are food safe lubricants used at relevant spots?",null,null,null,0.5,0,{"$f":"IF(C48=\"x\",254,IF(D48=\"x\",254*2,0))+IF(E48>\"\",CODE(E48)+LEN(E48),0)","v":0}]
["25.5","Wird eine negative Beeinflussung der Produkte durch Schmiermittel ausgeschlossen?\nIs a negative influence of products by lubricants excluded?",null,null,null,0.5,0,{"$f":"IF(C49=\"x\",255,IF(D49=\"x\",255*2,0))+IF(E49>\"\",CODE(E49)+LEN(E49),0)","v":0}]
[26,"Reinigung/ \nCleaning","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H45:H49)","v":0}]
["26.1","Gibt es festgelegte Reinigungspläne?\nDo cleaning plans exist?",null,null,null,3,0,{"$f":"IF(C51=\"x\",261,IF(D51=\"x\",261*2,0))+IF(E51>\"\",CODE(E51)+LEN(E51),0)","v":0}]
["26.2","Gibt es schriftliche Reinigungsanweisungen?\nDo written cleaning orders exist?",null,null,null,2,0,{"$f":"IF(C52=\"x\",262,IF(D52=\"x\",262*2,0))+IF(E52>\"\",CODE(E52)+LEN(E52),0)","v":0}]
["26.3","Wird der Reinigungserfolg regelmäßig überprüft?\nIs cleaning success checked regularly?",null,null,null,1,0,{"$f":"IF(C53=\"x\",263,IF(D53=\"x\",263*2,0))+IF(E53>\"\",CODE(E53)+LEN(E53),0)","v":0}]
["26.4","Werden regelmäßig Überprüfungen auf evtl. Reinigungsmittelreste durchgeführt?\nAre screenings on cleansing agent residues carried out regularly?",null,null,null,1,0,{"$f":"IF(C54=\"x\",264,IF(D54=\"x\",264*2,0))+IF(E54>\"\",CODE(E54)+LEN(E54),0)","v":0}]
["26.5","Werden im Produktionsbereich nur Tagesmengen an Reinigungsmitteln gelagert?  \nAre only daily quantities of cleaning agents stored in the production area?                               ",null,null,null,1,0,{"$f":"IF(C55=\"x\",265,IF(D55=\"x\",265*2,0))+IF(E55>\"\",CODE(E55)+LEN(E55),0)","v":0}]
[27,"Abfall und Entsorgung/                      \nRubbish and waste disposal","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H51:H55)","v":0}]
["27.1","Ist eine negative Beeinflussung von Produkten, Rohstoffen, Zusatzstoffen, Bedarfsgegenständen und Verpackungsmaterial durch Abfälle ausgeschlossen ?\nIs a negative influence of products, raw materials, additives, commodities and packaging by rubbish excluded?",null,null,null,0.5,0,{"$f":"IF(C57=\"x\",271,IF(D57=\"x\",271*2,0))+IF(E57>\"\",CODE(E57)+LEN(E57),0)","v":0}]
["27.2","Werden die Abfälle regelmäßig durch eine zugelassenen Entsorger abgeholt?\nIs rubbish regularly collected by authorized waste disposal companies?                      ",null,null,null,0.5,0,{"$f":"IF(C58=\"x\",272,IF(D58=\"x\",272*2,0))+IF(E58>\"\",CODE(E58)+LEN(E58),0)","v":0}]
[28,"Schädlingsbekämpfung/\nPest control","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H57:H58)","v":0}]
["28.1","Setzen sie zur Schädlingsbekämpfung einen Dienstleister ein?\nDo you use service providers for pest control?   ",null,null,null,1,0,{"$f":"IF(C60=\"x\",281,IF(D60=\"x\",281*2,0))+IF(E60>\"\",CODE(E60)+LEN(E60),0)","v":0}]
["28.2","Sind Giftköder im Produktionsbereich untersagt?\nAre toxic bait forbidden in the production area?",null,null,null,1,0,{"$f":"IF(C61=\"x\",282,IF(D61=\"x\",282*2,0))+IF(E61>\"\",CODE(E61)+LEN(E61),0)","v":0}]
["28.3","Sind die Fluginsektenfallen so positioniert, dass Produkte nicht kontaminiert werden? \nAre the flying insect traps positioned so that products cannot be contaminated? ",null,null,null,1,0,{"$f":"IF(C62=\"x\",283,IF(D62=\"x\",283*2,0))+IF(E62>\"\",CODE(E62)+LEN(E62),0)","v":0}]
["28.4","Leiten sie aus dem Schädlingsbefall Bekämpfungsmaßnahmen ein?\nDo you introduce pesticide in case of pest infestation?",null,null,null,2,0,{"$f":"IF(C63=\"x\",284,IF(D63=\"x\",284*2,0))+IF(E63>\"\",CODE(E63)+LEN(E63),0)","v":0}]
["28.5","Prüfen sie nach einer Schädlingsbekämpfung (z.B. Vernebelung) das Vorhandensein von Wirkstoffrückständen (z.B. PBO´s)?\nDo you check after pest control (for example fumigation) existence of active substance residues (for example PBOs)?",null,null,null,1,0,{"$f":"IF(C64=\"x\",285,IF(D64=\"x\",285*2,0))+IF(E64>\"\",CODE(E64)+LEN(E64),0)","v":0}]
[29,"Lagerung und Transport/                   \nStorage and transport","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H60:H64)","v":0}]
["29.1","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,2,0,{"$f":"IF(C66=\"x\",291,IF(D66=\"x\",291*2,0))+IF(E66>\"\",CODE(E66)+LEN(E66),0)","v":0}]
["29.2","Wird der Kunde bei Störungen während des Transportes verständigt ?\nIs the client notified of disturbances during transport?                          ",null,null,null,0.5,0,{"$f":"IF(C67=\"x\",292,IF(D67=\"x\",292*2,0))+IF(E67>\"\",CODE(E67)+LEN(E67),0)","v":0}]
[30,"Personal/ \nPersonnel","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H66:H67)","v":0}]
["30.1","Ist im Produktionsbereich das Rauchen untersagt?\nIs smoking prohibited in the production area?",null,null,null,0.5,0,{"$f":"IF(C69=\"x\",301,IF(D69=\"x\",301*2,0))+IF(E69>\"\",CODE(E69)+LEN(E69),0)","v":0}]
["30.2","Ist im Produktionsbereich das Essen und Trinken untersagt?\nAre food and drinks forbidden in production area?",null,null,null,0.5,{"$f":"IF(C70=\"X\",F70,0)","v":0},{"$f":"IF(C70=\"x\",302,IF(D70=\"x\",302*2,0))+IF(E70>\"\",CODE(E70)+LEN(E70),0)","v":0}]
[31,"Umkleideräume/ \nChanging room","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H69:H70)","v":0}]
["31.1","Sind getrennte Spinde (Berufs- und Privatkleidung) vorhanden?\nDo separate lockers exist (working clothes and private clothes)?",null,null,null,0.5,{"$f":"IF(C72=\"X\",F72,0)","v":0},{"$f":"IF(C72=\"x\",311,IF(D72=\"x\",311*2,0))+IF(E72>\"\",CODE(E72)+LEN(E72),0)","v":0}]
[32,"Toiletten und Handwaschbecken/ \nToilets and washbasins","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H72)","v":0}]
["32.1","Werden die Toiletten regelmäßig gereinigt (mind. einmal täglich)?\nAre toilets cleaned regularly (at least once a day)?",null,null,null,0.5,{"$f":"IF(C74=\"X\",F74,0)","v":0},{"$f":"IF(C74=\"x\",321,IF(D74=\"x\",321*2,0))+IF(E74>\"\",CODE(E74)+LEN(E74),0)","v":0}]
["32.2","Sind die Handwaschbecken berührungsfrei ? \nAre the sinks touch-free?",null,null,null,0.5,0,{"$f":"IF(C75=\"x\",322,IF(D75=\"x\",322*2,0))+IF(E75>\"\",CODE(E75)+LEN(E75),0)","v":0}]
[33,"Gesundheitsvorsorge/                      \nHealth precaution","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H74:H75)","v":0}]
["33.1","Gibt es eine Meldepflicht für Infektionskrankheiten?\nIs there a compulsory registration for infectious diseases?",null,null,null,0.5,{"$f":"IF(C77=\"X\",F77,0)","v":0},{"$f":"IF(C77=\"x\",331,IF(D77=\"x\",331*2,0))+IF(E77>\"\",CODE(E77)+LEN(E77),0)","v":0}]
["33.2","Wird eine negative Beeinflussung von Produkten durch erkrankte Mitarbeiter ausgeschlossen?\nIs a negative influence of diseased employees on products impossible?",null,null,null,2,0,{"$f":"IF(C78=\"x\",332,IF(D78=\"x\",332*2,0))+IF(E78>\"\",CODE(E78)+LEN(E78),0)","v":0}]
["33.3","Werden Besucher und Monteure auf die Meldepflicht von Infektionskrankheiten aufmerksam gemacht?\nAre visitors and mechanics informed about compulsory registration of infectious diseases?",null,null,null,0.5,0,{"$f":"IF(C79=\"x\",333,IF(D79=\"x\",333*2,0))+IF(E79>\"\",CODE(E79)+LEN(E79),0)","v":0}]
["33.4","Ist eine negative Beeeinflussung von Produkten durch 1.Hilfe-Material ausgeschlossen?\nIs a negative influence of products through first-aid material excluded?",null,null,null,0.5,0,{"$f":"IF(C80=\"x\",334,IF(D80=\"x\",334*2,0))+IF(E80>\"\",CODE(E80)+LEN(E80),0)","v":0}]
[34,"Hygienemanagement/                      \nhygiene management","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H77:H80)","v":0}]
["34.1","Werden regelmäßig Hygienebegehungen  durchgeführt?                                                                                                \nAre hygiene inspections carried out regularly?",null,null,null,2,{"$f":"IF(C82=\"X\",F82,0)","v":0},{"$f":"IF(C82=\"x\",341,IF(D82=\"x\",341*2,0))+IF(E82>\"\",CODE(E82)+LEN(E82),0)","v":0}]
["34.2","Liegt eine Hygienekonzept vor?\nIs there a hygiene plan?",null,null,null,1,0,{"$f":"IF(C83=\"x\",342,IF(D83=\"x\",342*2,0))+IF(E83>\"\",CODE(E83)+LEN(E83),0)","v":0}]
["34.3","Wird dieses Konzept regelmäßig überprüft?\nIs this plan checked regularly?",null,null,null,1,0,{"$f":"IF(C84=\"x\",343,IF(D84=\"x\",343*2,0))+IF(E84>\"\",CODE(E84)+LEN(E84),0)","v":0}]
["34.4","Werden nachweislich alle Mitarbeiter regelmäßig zu Hygienethemen geschult?                          \nAre all employees trained verifiable in hygiene?                    ",null,null,null,1,0,{"$f":"IF(C85=\"x\",344,IF(D85=\"x\",344*2,0))+IF(E85>\"\",CODE(E85)+LEN(E85),0)","v":0}]
[35,"Schmuck- und persönliche Gegenstände / \nJewellery and personal objects","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H82:H85)","v":0}]
["35.1","Sind Uhren, Schmuck und sichtbare Piercings im Produktionsbereich untersagt?\nAre watches, jewellery and visible piercings prohibited in production area?",null,null,null,1,{"$f":"IF(C87=\"X\",F87,0)","v":0},{"$f":"IF(C87=\"x\",351,IF(D87=\"x\",351*2,0))+IF(E87>\"\",CODE(E87)+LEN(E87),0)","v":0}]
[36,"Schutzkleidung/ \nProtective clothes","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H87)","v":0}]
["36.1","Wird eine einheitliche Schutzkleidung verwendet?\nAre uniform protective clothes used?",null,null,null,0.5,{"$f":"IF(C89=\"X\",F89,0)","v":0},{"$f":"IF(C89=\"x\",361,IF(D89=\"x\",361*2,0))+IF(E89>\"\",CODE(E89)+LEN(E89),0)","v":0}]
["36.2","Wird diese Kleidung extern gereinigt?\nAre these clothes cleaned by service providers?",null,null,null,0.5,0,{"$f":"IF(C90=\"x\",362,IF(D90=\"x\",362*2,0))+IF(E90>\"\",CODE(E90)+LEN(E90),0)","v":0}]
["36.3","Werden Haarnetze und ggf. Bartschutz getragen?\nDo employees wear hairnets and if necessary beard protection?",null,null,null,0.5,0,{"$f":"IF(C91=\"x\",363,IF(D91=\"x\",363*2,0))+IF(E91>\"\",CODE(E91)+LEN(E91),0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F91)","v":93.5},{"$f":"SUM(G3:G91)","v":0},{"$f":"SUM(H89:H91)","v":0}]
[null,null,null,null,null,"max.\nPunkte","Punkte"]
[{"$f":"CONCATENATE(\"Prüfsumme: \",H6,\" - \",H10,\" - \",H14,\" - \",H17,\" - \",H21,\" - \",H25,\" - \",H27,\" - \",H35,\" - \",H38,\" - \",H40,\" - \",H44,\" - \",H50,\" - \",H56,\" - \",H59,\" - \",H65,\" - \",H68,\" - \",H71,\" - \",H73,\" - \",H76,\" - \",H81,\" - \",H86,\" - \",H88,\" - \",H92)","v":"Prüfsumme: 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0"}]