{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Milchrohstoffe Teil1 ","Milchroh. Teil2 ohne BRC IFS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Milchrohstoffe Teil1 ","index":0,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":false,"merged":[[25,2,25,4],[26,2,26,4],[12,2,12,4],[1,0,1,4],[2,1,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],[11,2,11,4],[24,2,24,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],[23,2,23,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[61,0,62,0],[61,1,62,1],[61,2,62,2],[61,3,62,3],[30,2,30,4],[31,2,31,4],[67,2,67,4],[86,0,86,4],[80,0,80,4],[81,0,81,4],[82,0,82,1],[82,2,82,4],[83,0,83,1],[83,2,83,4]]}
[]
["\nManufacturer and supplier Self Assessment Questionnaire for liquid milk raw materials\n             ",null,null,null,null,"X"]
["Nr.",null,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(C5>\"\",CODE(C5)+LEN(C5),0)","v":0}]
["1.2","Name des Unternehmens:\nName of the company:",null,null,null,null,null,{"$f":"IF(C6>\"\",CODE(C6)+LEN(C6),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(H5:H17)","v":0}]
["2.1","Geschäftsleitung (Name, Tel. Fax. E-mail): \nManagement (name, telephone, fax, e-mail):",null,null,null,null,null,{"$f":"IF(C19>\"\",CODE(C19)+LEN(C19),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(H19:H25)","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]
[4,"Informationen zu Produkten und Dienstleistungen / Informations to products and services","Kommentar/ Opinion",null,null,null,null,{"$f":"SUM(H27:H29)","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. Erhitzungsverfahren)?\nWhich production technologies are used (eg heating procedure)?",null,null,null,"max.\nPunkte","Punkte",0]
[null,null,"ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H31:H32)","v":0}]
["4.3","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,5,{"$f":"IF(C34=\"X\",F34,0)","v":0},{"$f":"IF(C34=\"x\",44,IF(D34=\"x\",44*2,0))+IF(E34>\"\",CODE(E34)+LEN(E34),0)","v":0}]
["4.4","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,5,{"$f":"IF(C35=\"X\",F35,0)","v":0},{"$f":"IF(C35=\"x\",45,IF(D35=\"x\",45*2,0))+IF(E35>\"\",CODE(E35)+LEN(E35),0)","v":0}]
[5,"QM &  Zertifizierung/                                \nQuality Management/ Certification","ja/yes","nein/no","Kommentar/ Opinion\nErgebnis / result",null,null,{"$f":"SUM(H34:H35)","v":0}]
["5.1","Zertifizierung nach ISO 9001 oder ISO 22000\nWenn ja, Zertifikat beifügen.\nCertification by ISO 9001 or ISO 22000\nIf yes, add certificate.",null,null,null,3,{"$f":"IF(C37=\"X\",F37,0)","v":0},{"$f":"IF(C37=\"x\",51,IF(D37=\"x\",51*2,0))+IF(E37>\"\",CODE(E37)+LEN(E37),0)","v":0}]
["5.2","Zertifizierung nach FSSC 22000\nCertification by FSSC 22000\nBei ja: nur Punkte 1 - 10 beantworten und Zertifikat beifügen.\nif yes: answer only points 1 - 10 and add certificate\nBei nein: Punkte 1 - 27 beantworten\nif no: answer points 1 - 27",null,null,null,60,null,{"$f":"IF(C38=\"x\",52,IF(D38=\"x\",52*2,0))+IF(E38>\"\",CODE(E38)+LEN(E38),0)","v":0}]
["5.3","Zertifizierung nach IFS/ Ergebnis\nCertification by IFS/ Result\nBei ja: nur Punkte 1 - 10 beantworten und Zertifikat beifügen.\nif yes: answer only points 1 - 10 and add certificate\nBei nein: Punkte 1 - 27 beantworten\nif no: answer points 1 - 27",null,null,null,60,null,{"$f":"IF(C39=\"x\",53,IF(D39=\"x\",53*2,0))+IF(E39>\"\",CODE(E39)+LEN(E39),0)","v":0}]
["5.4","Zertifizierung nach BRC/ Ergebnis\nCertification by BRC/ Result\nBei ja: nur Punkte 1 - 10 beantworten und Zertifikat beifügen.\nif yes: answer only points 1 - 10 and add certificate\nBei nein: Punkte 1 - 27 beantworten\nif no: answer points 1 - 27",null,null,null,60,{"$f":"IF(OR(C38=\"X\",C39=\"X\",C40=\"X\"),60,0)","v":0},{"$f":"IF(C40=\"x\",54,IF(D40=\"x\",54*2,0))+IF(E40>\"\",CODE(E40)+LEN(E40),0)","v":0}]
["5.5","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(C41=\"X\",F41,0)","v":0},{"$f":"IF(C41=\"x\",56,IF(D41=\"x\",56*2,0))+IF(E41>\"\",CODE(E41)+LEN(E41),0)","v":0}]
["5.6","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(C42=\"x\",57,IF(D42=\"x\",57*2,0))+IF(E42>\"\",CODE(E42)+LEN(E42),0)","v":0}]
["5.7","Energiemanagement-Zertifizierung (z.B. nach DIN ISO 50001 oder DIN EN 16247-1) / Ergebnis\nEnergymanagement-certification (e.g. by ISO 50001 or DIN EN 16247-1) / Result",null,null,null,1,0,{"$f":"IF(C43=\"x\",58,IF(D43=\"x\",58*2,0))+IF(E43>\"\",CODE(E43)+LEN(E43),0)","v":0}]
["5.8","Zertifizierung nach QLIP Standard (Weidemilch)\nWenn ja, Zertifikat beifügen.\nCertification by QLIP standard\nIf yes, add certificate.",null,null,null,1,0,{"$f":"IF(C44=\"x\",59,IF(D44=\"x\",59*2,0))+IF(E44>\"\",CODE(E44)+LEN(E44),0)","v":0}]
["5.9","Zertifizierung nach Koscher Vorgaben\nWenn ja, Zertifikat beifügen.\nCertification by Kosher requirements\nIf yes, add certificate.",null,null,null,1,0,{"$f":"IF(C45=\"x\",59,IF(D45=\"x\",59*2,0))+IF(E45>\"\",CODE(E45)+LEN(E45),0)","v":0}]
["5.10","Zertifizierung nach Halal Vorgaben\nWenn ja, Zertifikat beifügen.\nCertification by Halal requirements\nIf yes, add certificate.",null,null,null,1,0,0]
["5.11","Zertifizierung nach VLOG Standard\nWenn ja, Zertifikat beifügen.\nCertification by VLOG standard\nIf yes, add certificate.",null,null,null,3,0,0]
["5.12","Sonstiges System (welches?) / Ergebnis\nOther System (which one?) / Result",null,null,null,1,0,0]
[6,"HACCP","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H37:H48)","v":0}]
["6.1","Sind Gefährdungsanalyse und Risikoabschätzung vorhanden?                                                             \nIs a hazard analysis and risk assessment available?",null,null,null,5,0,{"$f":"IF(C50=\"x\",61,IF(D50=\"x\",61*2,0))+IF(E50>\"\",CODE(E50)+LEN(E50),0)","v":0}]
["6.2","Ist ein HACCP-Konzept vorhanden?                       \nIs a HACCP Plan available?",null,null,null,3,0,{"$f":"IF(C51=\"x\",62,IF(D51=\"x\",62*2,0))+IF(E51>\"\",CODE(E51)+LEN(E51),0)","v":0}]
["6.3","Sind CCP´s identifiziert? Welche?                                       \nAre CCPs identified ? Which?",null,null,null,2,0,{"$f":"IF(C52=\"x\",63,IF(D52=\"x\",63*2,0))+IF(E52>\"\",CODE(E52)+LEN(E52),0)","v":0}]
["6.4","Sind Maßnahmen bei Abweichungen festgelegt?          \nHave measures been stipulated in case of deviations?",null,null,null,2,0,{"$f":"IF(C53=\"x\",64,IF(D53=\"x\",64*2,0))+IF(E53>\"\",CODE(E53)+LEN(E53),0)","v":0}]
["6.5","Sind Fließdiagramme vorhanden?\nAre flow charts available?",null,null,null,1,0,{"$f":"IF(C54=\"x\",65,IF(D54=\"x\",65*2,0))+IF(E54>\"\",CODE(E54)+LEN(E54),0)","v":0}]
["6.6","Wird das Konzept jährlich revidiert?                                            \nIs the plan annually revised?",null,null,null,1,0,{"$f":"IF(C55=\"x\",66,IF(D55=\"x\",66*2,0))+IF(E55>\"\",CODE(E55)+LEN(E55),0)","v":0}]
["6.7","Werden nachweislich alle Mitarbeiter regelmäßig zum HACCP geschult?                          \nAre all employees trained verifiable in HACCP?               ",null,null,null,2,0,{"$f":"IF(C56=\"x\",67,IF(D56=\"x\",67*2,0))+IF(E56>\"\",CODE(E56)+LEN(E56),0)","v":0}]
[7,"Fremdkörperkontrolle /                        \nForeign body check","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H50:H56)","v":0}]
["7.1","Sind alle Beleuchtungskörper mit Splitterschutz versehen?\nAre all lighting fixtures provided with splinter protection?",null,null,null,3,0,{"$f":"IF(C58=\"x\",71,IF(D58=\"x\",71*2,0))+IF(E58>\"\",CODE(E58)+LEN(E58),0)","v":0}]
["7.2","Gibt es ein Glas- und Hartplastikregister?\nIs there a register for glass and duroplastic plastics?",null,null,null,3,0,{"$f":"IF(C59=\"x\",72,IF(D59=\"x\",72*2,0))+IF(E59>\"\",CODE(E59)+LEN(E59),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,3,0,{"$f":"IF(C60=\"x\",73,IF(D60=\"x\",73*2,0))+IF(E60>\"\",CODE(E60)+LEN(E60),0)","v":0}]
["7.4","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,3,0,{"$f":"IF(C61=\"x\",78,IF(D61=\"x\",78*2,0))+IF(E61>\"\",CODE(E61)+LEN(E61),0)","v":0}]
["7.5","Gibt es Siebe und /oder Filter?\nAre there sieves and/ or filters?",null,null,"Maschenweite? mesh size?",3,{"$f":"IF(C62=\"X\",F62,0)","v":0},{"$f":"IF(C62=\"x\",790,IF(D62=\"x\",790*2,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(E63>\"\",CODE(E63)+LEN(E63),0)","v":0}]
[8,"Spezifikationen / \nSpecifications","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H58:H63)","v":0}]
["8.1","Liegen eindeutige und aktuelle Produktspezifikationen vor?                                     \nAre clear and up-to-date product specifications available?",null,null,null,3,0,{"$f":"IF(C65=\"x\",81,IF(D65=\"x\",81*2,0))+IF(E65>\"\",CODE(E65)+LEN(E65),0)","v":0}]
[9,"Rückverfolgbarkeit / Tracibility","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H65)","v":0}]
["9.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,10,0,{"$f":"IF(C67=\"x\",101,IF(D67=\"x\",101*2,0))+IF(E67>\"\",CODE(E67)+LEN(E67),0)","v":0}]
["9.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(C68>\"\",CODE(C68)+LEN(C68),0)","v":0}]
["9.3","Ist sichergestellt, dass der Kunde über ein Rückrufverfahren informiert wird?                         \nIs it ensured that the customer is informed about recall procedures?",null,null,null,1,0,{"$f":"IF(C69=\"x\",103,IF(D69=\"x\",103*2,0))+IF(E69>\"\",CODE(E69)+LEN(E69),0)","v":0}]
[10,"Produktschutz / Product Protection","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H67:H69)","v":0}]
["10.1","Sind Gefahrenanalyse und Bewertung und damit zusammenhängenden Risiken  zum Produktschutz durchgeführt und dokumentiert worden? Sind sicherheitskritische Bereiche identifiziert worden?\nAre risk analysis and assessment with the associated risks for product protection have been put into practise and were documentated ? Are safety-critical areas have been identified?",null,null,null,1,0,{"$f":"IF(C71=\"x\",131,IF(D71=\"x\",131*2,0))+IF(E71>\"\",CODE(E71)+LEN(E71),0)","v":0}]
["10.2","Ist das Werksgelände umzäunt und gesichert?\nAre factory premises fenced in and safeguarded? ",null,null,null,2,0,{"$f":"IF(C72=\"x\",132,IF(D72=\"x\",132*2,0))+IF(E72>\"\",CODE(E72)+LEN(E72),0)","v":0}]
["10.3","Ist der Zugang eingeschränkt und kontrolliert?\nIs entrance limited and supervised?",null,null,null,2,0,{"$f":"IF(C73=\"x\",133,IF(D73=\"x\",133*2,0))+IF(E73>\"\",CODE(E73)+LEN(E73),0)","v":0}]
["10.4","Gibt es Verfahren die Verfälschungen/ Sabotage verhindern und/oder die Identifizierung von Anzeichen für Sabotage ersichtlich machen?\nAre there methods to prevent the adulteration / sabotage and / or make the identification of signs of sabotage visible?",null,null,null,2,0,{"$f":"IF(C74=\"x\",134,IF(D74=\"x\",134*2,0))+IF(E74>\"\",CODE(E74)+LEN(E74),0)","v":0}]
["10.5","Sind Lieferanten und Ladepersonal, die mit dem Produkt in Kontakt kommen, bekannt und ist der Zutritt geregelt?\nAre suppliers and loading personnel who come into contact with the product, known and access is regulated?",null,null,null,1,0,{"$f":"IF(C75=\"x\",135,IF(D75=\"x\",135*2,0))+IF(E75>\"\",CODE(E75)+LEN(E75),0)","v":0}]
["10.6","Wird der Zeitpunkt des Zurtitts von Besucher und externen Dienstleistern registriert? Werden sie über die Richtlinien des Standortes informiert und ihr Zugang entsprechend kontrolliert?\nWill the time of entry of visitors and external service providers registered? Are they aware of the plant guidelines and is the access controlled?",null,null,null,3,0,{"$f":"IF(C76=\"x\",136,IF(D76=\"x\",136*2,0))+IF(E76>\"\",CODE(E76)+LEN(E76),0)","v":0}]
["10.7","Sind im Außenbereich gelagerte Rohstoffe, Gerätschaften und Materialien vor unbefugtem Zugriff geschützt?\nAre raw materials, equipment and materials stored outdoors protected against unauthorized access?",null,null,null,1,0,{"$f":"IF(C77=\"x\",137,IF(D77=\"x\",137*2,0))+IF(E77>\"\",CODE(E77)+LEN(E77),0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F34:F77)-60-60","v":140},{"$f":"SUM(G34:G77)","v":0},{"$f":"SUM(H71:H77)","v":0}]
[null,null,null,null,null,"max.\nPunkte","Punkte"]
[null,null,null,null,null,"Gesamt",{"$f":"IF(AND(D38=\"X\",D39=\"X\",D40=\"X\"),G78+'Milchroh. Teil2 ohne BRC IFS'!G73,G78)","v":0}]
[{"$f":"IF(AND(D38=\"X\",D39=\"X\",D40=\"X\"),\"Bitte füllen Sie auch im 2. Tabellenreiter Punkt 15-36 aus! / Please fill in the 2nd sheet no. 15-36!\",\"\")","v":""}]
["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: \",H18,\" - \",H26,\" - \",H30,\" - \",H33,\" - \",H36,\" - \",H49,\" - \",H57,\" - \",H64,\" - \",H66,\" - \",H70,\" - \",H78)","v":"Prüfsumme: 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0"}]

{"sheet":"Milchroh. Teil2 ohne BRC IFS","index":1,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,0,1,4],[74,0,74,4]]}
[]
["\nManufacturer and supplier Self Asessment Questionnaire Suppliers for liquid milk raw materials\n             ",null,null,null,null,"max.\nPunkte","Punkte","Prüf-summe","X"]
[11,"Prozessteuerung/ \nProcess control","ja/yes","nein/no","Kommentar/ Opinion"]
["11.1","Werden Inprozess-Kontrollen durchgeführt ?\nAre there documented in-process control checks performed?",null,null,null,2,{"$f":"IF(C4=\"X\",F4,0)","v":0},{"$f":"IF(C4=\"x\",161,IF(D4=\"x\",161*2,0))+IF(E4>\"\",CODE(E4)+LEN(E4),0)","v":0}]
["11.2","Gibt es festgelegte Vorgaben für den Produktionsprozess?\nDo guidelines exist for the production process?",null,null,null,1,0,{"$f":"IF(C5=\"x\",162,IF(D5=\"x\",162*2,0))+IF(E5>\"\",CODE(E5)+LEN(E5),0)","v":0}]
[12,"Prüfmittel/ \nTesting equipment","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H4:H5)","v":0}]
["12.1","Sind Prüfmittel festgelegt und identifiziert ?\nIs testing equipment stipulated and identified?",null,null,null,0.5,0,{"$f":"IF(C7=\"x\",171,IF(D7=\"x\",171*2,0))+IF(E7>\"\",CODE(E7)+LEN(E7),0)","v":0}]
["12.2","Werden die verwendeten Prüfmittel verwaltet und regelmäßig überprüft ?\nAre applied testing equipment administered and checked regularly?",null,null,null,1,0,{"$f":"IF(C8=\"x\",172,IF(D8=\"x\",172*2,0))+IF(E8>\"\",CODE(E8)+LEN(E8),0)","v":0}]
[13,"Interne Audits/ \nInternal audits","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H7:H8)","v":0}]
["13.1","Werden interne Audits durchgeführt ?\nAre internal audits carried out?",null,null,null,0.5,0,{"$f":"IF(C10=\"x\",181,IF(D10=\"x\",181*2,0))+IF(E10>\"\",CODE(E10)+LEN(E10),0)","v":0}]
["13.2","Werden die Maßnahmen verfolgt ?\nAre measures tracked?",null,null,null,1,0,{"$f":"IF(C11=\"x\",182,IF(D11=\"x\",182*2,0))+IF(E11>\"\",CODE(E11)+LEN(E11),0)","v":0}]
["13.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(C12=\"x\",183,IF(D12=\"x\",183*2,0))+IF(E12>\"\",CODE(E12)+LEN(E12),0)","v":0}]
[14,"Reklamationsmanagement/                        \nComplaints management","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H10:H12)","v":0}]
["14.1","Ist ein dokumentiertes Verfahren zum Reklamationsmanagement festgelegt ?\nHas a documented process for complaints management been stipulated?",null,null,null,1,0,{"$f":"IF(C14=\"x\",191,IF(D14=\"x\",191*2,0))+IF(E14>\"\",CODE(E14)+LEN(E14),0)","v":0}]
["14.2","Werden die Reklamationen regelmäßig ausgewertet ?\nAre complaints evaluated regularly?",null,null,null,0.5,0,{"$f":"IF(C15=\"x\",192,IF(D15=\"x\",192*2,0))+IF(E15>\"\",CODE(E15)+LEN(E15),0)","v":0}]
["14.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(C16=\"x\",193,IF(D16=\"x\",193*2,0))+IF(E16>\"\",CODE(E16)+LEN(E16),0)","v":0}]
[15,"Qualitätssicherung/                               \nQuality Assurance","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H14:H16)","v":0}]
["15.1","Liegen für die von Ihnen eingesetzten Rohstoffe 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,1,0,{"$f":"IF(C18=\"x\",211,IF(D18=\"x\",211*2,0))+IF(E18>\"\",CODE(E18)+LEN(E18),0)","v":0}]
["15.2","Ist ein Verfahren bei Überschreitung von Grenzwerten festgelegt ?\nIs a process stipulated in case threshold values are exceeded?",null,null,null,1.5,0,{"$f":"IF(C19=\"x\",213,IF(D19=\"x\",213*2,0))+IF(E19>\"\",CODE(E19)+LEN(E19),0)","v":0}]
["15.3","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(C20=\"x\",214,IF(D20=\"x\",214*2,0))+IF(E20>\"\",CODE(E20)+LEN(E20),0)","v":0}]
["15.4","Wird an Ringanalysen teilgenommen?\nDo you participate in intra-laboratory analyses?",null,null,null,0.5,0,{"$f":"IF(C21=\"x\",215,IF(D21=\"x\",215*2,0))+IF(E21>\"\",CODE(E21)+LEN(E21),0)","v":0}]
["15.5","Wird mit externen Laboren zusammengearbeitet?\nDo you work together with external laboratories?",null,null,null,1,0,{"$f":"IF(C22=\"x\",216,IF(D22=\"x\",216*2,0))+IF(E22>\"\",CODE(E22)+LEN(E22),0)","v":0}]
["15.6","Wenn ja, sind diese akkreditiert ?\nIf yes, are these accredited?",null,null,null,0.5,0,{"$f":"IF(C23=\"x\",217,IF(D23=\"x\",217*2,0))+IF(E23>\"\",CODE(E23)+LEN(E23),0)","v":0}]
[16,"Gebäude und Infrastruktur/ \nBuildings and infrastructure","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H18:H23)","v":0}]
["16.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,0.5,0,{"$f":"IF(C25=\"x\",241,IF(D25=\"x\",241*2,0))+IF(E25>\"\",CODE(E25)+LEN(E25),0)","v":0}]
["16.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(C26=\"x\",242,IF(D26=\"x\",242*2,0))+IF(E26>\"\",CODE(E26)+LEN(E26),0)","v":0}]
["16.3","Wird das Eindringen von Schädlingen verhindert? \nIs the infiltration of vermin prevented?   ",null,null,null,0.5,0,{"$f":"IF(C27=\"x\",243,IF(D27=\"x\",243*2,0))+IF(E27>\"\",CODE(E27)+LEN(E27),0)","v":0}]
["17.","Instandhaltung/ \nMaintenance","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H25:H27)","v":0}]
["17.1","Gibt es einen festgelegten Wartungsplan?\nDoes a service plan exist?",null,null,null,2,0,{"$f":"IF(C29=\"x\",251,IF(D29=\"x\",251*2,0))+IF(E29>\"\",CODE(E29)+LEN(E29),0)","v":0}]
["17.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(C30=\"x\",252,IF(D30=\"x\",252*2,0))+IF(E30>\"\",CODE(E30)+LEN(E30),0)","v":0}]
["17.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(C31=\"x\",253,IF(D31=\"x\",253*2,0))+IF(E31>\"\",CODE(E31)+LEN(E31),0)","v":0}]
["17.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(C32=\"x\",254,IF(D32=\"x\",254*2,0))+IF(E32>\"\",CODE(E32)+LEN(E32),0)","v":0}]
["17.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(C33=\"x\",255,IF(D33=\"x\",255*2,0))+IF(E33>\"\",CODE(E33)+LEN(E33),0)","v":0}]
[18,"Reinigung/ \nCleaning","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H29:H33)","v":0}]
["18.1","Gibt es festgelegte Reinigungspläne?\nDo cleaning plans exist?",null,null,null,2,0,{"$f":"IF(C35=\"x\",261,IF(D35=\"x\",261*2,0))+IF(E35>\"\",CODE(E35)+LEN(E35),0)","v":0}]
["18.2","Gibt es schriftliche Reinigungsanweisungen?\nDo written cleaning orders exist?",null,null,null,1,0,{"$f":"IF(C36=\"x\",262,IF(D36=\"x\",262*2,0))+IF(E36>\"\",CODE(E36)+LEN(E36),0)","v":0}]
["18.3","Wird der Reinigungserfolg regelmäßig überprüft?\nIs cleaning success checked regularly?",null,null,null,1,0,{"$f":"IF(C37=\"x\",263,IF(D37=\"x\",263*2,0))+IF(E37>\"\",CODE(E37)+LEN(E37),0)","v":0}]
["18.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(C38=\"x\",264,IF(D38=\"x\",264*2,0))+IF(E38>\"\",CODE(E38)+LEN(E38),0)","v":0}]
[19,"Schädlingsbekämpfung/\nPest control","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H35:H38)","v":0}]
["19.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(C40=\"x\",281,IF(D40=\"x\",281*2,0))+IF(E40>\"\",CODE(E40)+LEN(E40),0)","v":0}]
["19.2","Sind Giftköder im Produktionsbereich untersagt?\nAre toxic bait forbidden in the production area?",null,null,null,1,0,{"$f":"IF(C41=\"x\",282,IF(D41=\"x\",282*2,0))+IF(E41>\"\",CODE(E41)+LEN(E41),0)","v":0}]
["19.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(C42=\"x\",283,IF(D42=\"x\",283*2,0))+IF(E42>\"\",CODE(E42)+LEN(E42),0)","v":0}]
["19.4","Leiten sie aus dem Schädlingsbefall Bekämpfungsmaßnahmen ein?\nDo you introduce pesticide in case of pest infestation?",null,null,null,1,0,{"$f":"IF(C43=\"x\",284,IF(D43=\"x\",284*2,0))+IF(E43>\"\",CODE(E43)+LEN(E43),0)","v":0}]
["19.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(C44=\"x\",285,IF(D44=\"x\",285*2,0))+IF(E44>\"\",CODE(E44)+LEN(E44),0)","v":0}]
[20,"Personal/ \nPersonnel","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H40:H44)","v":0}]
["20.1","Ist im Produktionsbereich das Rauchen untersagt?\nIs smoking prohibited in the production area?",null,null,null,0.5,0,{"$f":"IF(C46=\"x\",301,IF(D46=\"x\",301*2,0))+IF(E46>\"\",CODE(E46)+LEN(E46),0)","v":0}]
["20.2","Ist im Produktionsbereich das Essen und Trinken untersagt?\nAre food and drinks forbidden in production area?",null,null,null,0.5,0,{"$f":"IF(C47=\"x\",302,IF(D47=\"x\",302*2,0))+IF(E47>\"\",CODE(E47)+LEN(E47),0)","v":0}]
[21,"Umkleideräume/ \nChanging room","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H46:H47)","v":0}]
["21.1","Sind getrennte Spinde (Berufs- und Privatkleidung) vorhanden?\nDo separate lockers exist (working clothes and private clothes)?",null,null,null,0.5,{"$f":"IF(C49=\"X\",F49,0)","v":0},{"$f":"IF(C49=\"x\",311,IF(D49=\"x\",311*2,0))+IF(E49>\"\",CODE(E49)+LEN(E49),0)","v":0}]
[22,"Toiletten und Handwaschbecken/ \nToilets and washbasins","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H49)","v":0}]
["22.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(C51=\"X\",F51,0)","v":0},{"$f":"IF(C51=\"x\",321,IF(D51=\"x\",321*2,0))+IF(E51>\"\",CODE(E51)+LEN(E51),0)","v":0}]
["22.2","Sind die Handwaschbecken berührungsfrei ? \nAre the sinks touch-free?",null,null,null,0.5,0,{"$f":"IF(C52=\"x\",322,IF(D52=\"x\",322*2,0))+IF(E52>\"\",CODE(E52)+LEN(E52),0)","v":0}]
[23,"Gesundheitsvorsorge/                      \nHealth precaution","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H51:H52)","v":0}]
["23.1","Gibt es eine Meldepflicht für Infektionskrankheiten?\nIs there a compulsory registration for infectious diseases?",null,null,null,0.5,{"$f":"IF(C54=\"X\",F54,0)","v":0},{"$f":"IF(C54=\"x\",331,IF(D54=\"x\",331*2,0))+IF(E54>\"\",CODE(E54)+LEN(E54),0)","v":0}]
["23.2","Wird eine negative Beeinflussung von Produkten durch erkrankte Mitarbeiter ausgeschlossen?\nIs a negative influence of diseased employees on products impossible?",null,null,null,1,0,{"$f":"IF(C55=\"x\",332,IF(D55=\"x\",332*2,0))+IF(E55>\"\",CODE(E55)+LEN(E55),0)","v":0}]
["23.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(C56=\"x\",333,IF(D56=\"x\",333*2,0))+IF(E56>\"\",CODE(E56)+LEN(E56),0)","v":0}]
["23.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(C57=\"x\",334,IF(D57=\"x\",334*2,0))+IF(E57>\"\",CODE(E57)+LEN(E57),0)","v":0}]
[24,"Hygienemanagement/                      \nhygiene management","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H54:H57)","v":0}]
["24.1","Werden regelmäßig Hygienebegehungen  durchgeführt?                                                                                                \nAre hygiene inspections carried out regularly?",null,null,null,1,{"$f":"IF(C59=\"X\",F59,0)","v":0},{"$f":"IF(C59=\"x\",341,IF(D59=\"x\",341*2,0))+IF(E59>\"\",CODE(E59)+LEN(E59),0)","v":0}]
["24.2","Liegt eine Hygienekonzept vor?\nIs there a hygiene plan?",null,null,null,1,0,{"$f":"IF(C60=\"x\",342,IF(D60=\"x\",342*2,0))+IF(E60>\"\",CODE(E60)+LEN(E60),0)","v":0}]
["24.3","Wird dieses Konzept regelmäßig überprüft?\nIs this plan checked regularly?",null,null,null,1,0,{"$f":"IF(C61=\"x\",343,IF(D61=\"x\",343*2,0))+IF(E61>\"\",CODE(E61)+LEN(E61),0)","v":0}]
["24.4","Werden nachweislich alle Mitarbeiter regelmäßig zu Hygienethemen (gemäß Infektionsschutzgesetz) geschult?                          \nAre all employees trained verifiable in hygiene (in accordance with the infection protection law)?                    ",null,null,null,1,0,{"$f":"IF(C62=\"x\",344,IF(D62=\"x\",344*2,0))+IF(E62>\"\",CODE(E62)+LEN(E62),0)","v":0}]
[25,"Schmuck- und persönliche Gegenstände / \nJewellery and personal objects","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H59:H62)","v":0}]
["25.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(C64=\"X\",F64,0)","v":0},{"$f":"IF(C64=\"x\",351,IF(D64=\"x\",351*2,0))+IF(E64>\"\",CODE(E64)+LEN(E64),0)","v":0}]
[26,"Schutzkleidung/ \nProtective clothes","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H64)","v":0}]
["26.1","Wird eine einheitliche Schutzkleidung verwendet?\nAre uniform protective clothes used?",null,null,null,0.5,{"$f":"IF(C66=\"X\",F66,0)","v":0},{"$f":"IF(C66=\"x\",361,IF(D66=\"x\",361*2,0))+IF(E66>\"\",CODE(E66)+LEN(E66),0)","v":0}]
["26.2","Wird diese Kleidung extern gereinigt?\nAre these clothes cleaned by service providers?",null,null,null,0.5,0,{"$f":"IF(C67=\"x\",362,IF(D67=\"x\",362*2,0))+IF(E67>\"\",CODE(E67)+LEN(E67),0)","v":0}]
["26.3","Werden Haarnetze und ggf. Bartschutz getragen?\nDo employees wear hairnets and if necessary beard protection?",null,null,null,0.5,0,{"$f":"IF(C68=\"x\",363,IF(D68=\"x\",363*2,0))+IF(E68>\"\",CODE(E68)+LEN(E68),0)","v":0}]
[27,"Authentizität/ \nFood Fraud","ja/yes","nein/no","Kommentar/ Opinion",null,null,{"$f":"SUM(H66:H68)","v":0}]
["27.1","Liegt ein System vor, mit dem das Thema \"Food Fraud\" (= Verfälschung von Rohstoffen und Materialien) geregelt wird?\nIs there a system for regulating the issue of \"food fraud\" (= adulteration of raw materials)?",null,null,null,0.5,{"$f":"IF(C70=\"X\",F70,0)","v":0},{"$f":"IF(C70=\"x\",361,IF(D70=\"x\",361*2,0))+IF(E70>\"\",CODE(E70)+LEN(E70),0)","v":0}]
["27.2","Enthält das System eine risikobasierte Schwachstellenbewertung von Rohstoffen und Materialien?\nDoes the system contain a risk-based vulnerability assessment of raw materials and materials?",null,null,null,0.5,0,{"$f":"IF(C71=\"x\",362,IF(D71=\"x\",362*2,0))+IF(E71>\"\",CODE(E71)+LEN(E71),0)","v":0}]
["27.3","Ist ein Maßnahmenplan, um Betrugsmöglichkeiten zu minimieren, vorhanden?\nIs there a plan of action to minimize the possibility of fraud?",null,null,null,0.5,0,{"$f":"IF(C72=\"x\",363,IF(D72=\"x\",363*2,0))+IF(E72>\"\",CODE(E72)+LEN(E72),0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F3:F72)","v":42.5},{"$f":"SUM(G3:G72)","v":0},{"$f":"SUM(H70:H72)","v":0}]
[null,null,null,null,null,"max.\nPunkte","Punkte"]
[{"$f":"CONCATENATE(\"Prüfsumme: \",H6,\" - \",H9,\" - \",H13,\" - \",H17,\"  - \",H24,\" - \",H28,\" - \",H34,\" - \",H39,\" - \",H45,\" - \",H48,\" - \",H50,\" - \",H53,\" - \",H58,\" - \",H63,\" - \",H65,\" - \",H69,\" - \",H73)","v":"Prüfsumme: 0 - 0 - 0 - 0  - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0"}]