{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Auditbericht","Checkliste","Maßnahmenplan"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Auditbericht","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,27,2],[27,4,27,10],[23,0,23,1],[23,2,23,10],[24,0,24,2],[24,4,24,10],[26,0,26,10],[21,0,21,5],[21,6,21,10],[20,0,20,10],[16,0,16,8],[16,9,16,10],[17,0,17,8],[17,9,17,10],[19,0,19,10],[0,0,0,10],[2,0,2,10],[5,0,5,1],[5,2,5,10],[3,0,3,1],[3,2,3,10],[4,0,4,1],[4,2,4,10],[13,0,13,1],[13,2,13,10],[15,0,15,10],[11,0,11,10],[12,0,12,1],[12,2,12,10],[9,0,9,1],[9,2,9,10],[8,0,8,1],[8,2,8,5],[7,0,7,1],[6,0,6,1],[6,2,6,5],[6,9,6,10],[7,2,7,5],[7,9,7,10]]}
["Eigenkontrollcheckliste für fahrbare Mahl- und Mischanlagen",null,null,null,null,null,null,null,null,null,null,"System"]
[]
["Angaben zum Audit"]
["Systempartner"]
["QS-Identifikationsnummer"]
["Name der Auskunftsperson"]
["Auditdatum (von)",null,null,null,null,null,"Auditdatum (bis)"]
["Auditanfang (hh:mm)",null,null,null,null,null,"Auditende (hh:mm)"]
["Auditdauer (hh:mm)"]
["Nachname, Vorname des Auditors"]
[]
["Angaben zur auditierten Anlage "]
["QS-Standortnummer \n(Amtl. Fahrzeugkennzeichen)"]
["Name des Verantwortlichen"]
[]
["Geltungsbereich - QS-Inspektion für fahrbare Mahl-und Mischanlagen"]
["Produktionsart",null,null,null,null,null,null,null,null,"Produktionsart-Nummer"]
["Fahrbare Mahl- und Mischanlagen",null,null,null,null,null,null,null,null,75]
[]
["Zusatzinformationen - QS-Inspektion für fahrbare Mahl-und Mischanlagen"]
["Angaben zum Dienstleistungsunternehmen"]
["Jahrestonnage (QS-Ware)"]
[]
["Kommentare"]
[]
["Ort, Datum",null,null,null,"Unterschrift/en Auditor/en"]
[]
[]
["Ort, Datum",null,null,null,"Unterschrift Betriebsverantwortlicher"]

{"sheet":"Checkliste","index":1,"n_rows":105,"n_cols":26,"rows_kept":105,"cut":false,"hidden":false,"merged":[[87,1,87,9],[91,1,91,9],[95,1,95,9],[99,1,99,9],[102,1,102,9],[70,1,70,9],[74,1,74,9],[76,1,76,9],[80,1,80,9],[82,1,82,9],[43,1,43,9],[47,1,47,9],[50,1,50,9],[61,1,61,9],[62,1,62,9],[60,1,60,9],[52,1,52,9],[55,1,55,9],[58,1,58,9],[0,1,0,7],[2,1,2,9],[3,1,3,9],[10,1,10,9],[22,1,22,9],[40,1,40,9],[42,1,42,9],[23,1,23,9],[25,1,25,9],[28,1,28,9],[34,1,34,9],[39,1,39,9]]}
["Betrieb:    ","____________________________________________",null,null,null,null,null,null,"Datum:","___________",null,1]
["Anforderung Nr.",null,null,"Checkliste","Kriterium/ Anforderung","Kriterium erfüllt","Kriterium nicht erfüllt","nicht anwendbar ","Bemerkung/Korrektur-maßnahme","Behebungs-frist","As (1)","As (3)","Bs (1)","Bs (3)","Cs (1)","Cs (3)","Ds (1)","Ds (3)","Es (1)","Es (3)","QSGAPs",null,"Es (1) o KO","Es (1) o B","Ds (1) o B","KO"]
["2","Allgemeine Anforderungen",null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K492)","v":{"$error":"#REF!"}},{"$f":"SUM(L4:L492)","v":{"$error":"#REF!"}},{"$f":"SUM(M4:M491)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($U$4:$U$173)","v":0},null,{"$f":"SUM(W4:W491)","v":{"$error":"#REF!"}},{"$f":"SUM(X4:X491)","v":{"$error":"#REF!"}},{"$f":"SUM(Y4:Y491)","v":{"$error":"#REF!"}},{"$f":"SUM(Z4:Z491)","v":{"$error":"#REF!"}}]
["2.1","Allgemeine Systemanforderungen"]
["2.1.1",null,null,null,"[K.O.] Betriebsdaten"]
["2.1.2",null,null,null,"[K.O.] Amtliche Registrierung",null,null,null,null,null,{"$f":"IF(B5=\"1\",IF(TRIM(F5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"3\",IF(TRIM(F5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"1\",IF(TRIM(G5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"3\",IF(TRIM(G5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"1\",IF(TRIM(H5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"3\",IF(TRIM(H5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"1\",IF(TRIM(I5)<>\"\",1,0),0)","v":0},{"$f":"IF(B5=\"3\",IF(TRIM(I5)<>\"\",1,0),0)","v":0},0,"224513311",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A5,8)=\"Stichpr.\",B5=\"1\",D5=\"\"),IF(TRIM(I5)<>\"\",1,0),0),IF(AND(B5=\"1\",D5=\"\"),IF(TRIM(I5)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A5,8)=\"Stichpr.\",LEFT(A5,1)=\"a\",B5=\"1\",D5=\"\"),IF(TRIM(I5)<>\"\",1,0),0),IF(AND(LEFT(A5,1)=\"a\",B5=\"1\",D5=\"\"),IF(TRIM(I5)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B5=\"1\",LEFT(A5,1)=\"a\",D5=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D5<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.1.3",null,null,null,"[K.O.] Ereignis- und Krisenmanagement",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B6=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B6=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513366",0,0,{"$f":"IF(AND(B6=\"1\",LEFT(A6,1)=\"a\",D6=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D6<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.1.4",null,null,null,"[K.O.] Rückverfolgbarkeit ",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B7=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B7=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513313",0,0,{"$f":"IF(AND(B7=\"1\",LEFT(A7,1)=\"a\",D7=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D7<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.1.5",null,null,null,"[K.O.] Durchführung und Dokumentation der Eigenkontrolle",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B8=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B8=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513314",0,0,{"$f":"IF(AND(B8=\"1\",LEFT(A8,1)=\"a\",D8=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D8<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.1.6",null,null,null,"Umsetzung eingeleiteter Maßnahmen aus der Eigenkontrolle",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B9=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B9=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513315",0,0,{"$f":"IF(AND(B9=\"1\",LEFT(A9,1)=\"a\",D9=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D9<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2","HACCP-Konzept",null,null,null,null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B10=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B10=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513312",0,0,{"$f":"IF(AND(B10=\"1\",LEFT(A10,1)=\"a\",D10=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D10<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.1",null,null,null,"[K.O.] HACCP-Konzept"]
["2.2.2",null,null,null,"HACCP-Team",null,null,null,null,null,{"$f":"IF(B12=\"1\",IF(TRIM(F12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"3\",IF(TRIM(F12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"1\",IF(TRIM(G12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"3\",IF(TRIM(G12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"1\",IF(TRIM(H12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"3\",IF(TRIM(H12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"1\",IF(TRIM(I12)<>\"\",1,0),0)","v":0},{"$f":"IF(B12=\"3\",IF(TRIM(I12)<>\"\",1,0),0)","v":0},0,"224513317",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A12,8)=\"Stichpr.\",B12=\"1\",D12=\"\"),IF(TRIM(I12)<>\"\",1,0),0),IF(AND(B12=\"1\",D12=\"\"),IF(TRIM(I12)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A12,8)=\"Stichpr.\",LEFT(A12,1)=\"a\",B12=\"1\",D12=\"\"),IF(TRIM(I12)<>\"\",1,0),0),IF(AND(LEFT(A12,1)=\"a\",B12=\"1\",D12=\"\"),IF(TRIM(I12)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B12=\"1\",LEFT(A12,1)=\"a\",D12=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D12<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.3",null,null,null,"Fließdiagramme",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B13=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B13=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513318",0,0,{"$f":"IF(AND(B13=\"1\",LEFT(A13,1)=\"a\",D13=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D13<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.4",null,null,null,"Gefahrenanalyse",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B14=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B14=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513319",0,0,{"$f":"IF(AND(B14=\"1\",LEFT(A14,1)=\"a\",D14=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D14<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.5",null,null,null,"Kritische Lenkungspunkte (CCP)",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B15=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513362",0,0,{"$f":"IF(AND(B15=\"1\",LEFT(A15,1)=\"a\",D15=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D15<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.6",null,null,null,"Grenzwerte für CCP",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B16=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B16=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513320",0,0,{"$f":"IF(AND(B16=\"1\",LEFT(A16,1)=\"a\",D16=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D16<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.7",null,null,null,"Überwachung und Verifizierung der Grenzwerte für CCP",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B17=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B17=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513321",0,0,{"$f":"IF(AND(B17=\"1\",LEFT(A17,1)=\"a\",D17=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D17<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.8",null,null,null,"Korrekturmaßnahmen für CCP",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B18=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B18=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513322",0,0,{"$f":"IF(AND(B18=\"1\",LEFT(A18,1)=\"a\",D18=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D18<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.9",null,null,null,"Verantwortlichkeiten",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B19=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B19=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513363",0,0,{"$f":"IF(AND(B19=\"1\",LEFT(A19,1)=\"a\",D19=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D19<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.10",null,null,null,"Dokumentationen",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B20=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B20=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513323",0,0,{"$f":"IF(AND(B20=\"1\",LEFT(A20,1)=\"a\",D20=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D20<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.11",null,"",null,"HACCP Verifizierung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B21=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B21=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513324",0,0,{"$f":"IF(AND(B21=\"1\",LEFT(A21,1)=\"a\",D21=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D21<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3","Anforderungen an die Anlagenbetreiber",null,null,null,null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B22=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B22=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513325",0,0,{"$f":"IF(AND(B22=\"1\",LEFT(A22,1)=\"a\",D22=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D22<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.1","Zulassung für die Herstellung von Arzneifuttermitteln"]
["3.1.1",null,null,null,"[K.O.] Einhaltung der Anforderungen für die Herstellung von Arzneifuttermitteln"]
["3.2","Personal",null,null,null,null,null,null,null,null,{"$f":"IF(B25=\"1\",IF(TRIM(F25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"3\",IF(TRIM(F25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"1\",IF(TRIM(G25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"3\",IF(TRIM(G25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"1\",IF(TRIM(H25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"3\",IF(TRIM(H25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"1\",IF(TRIM(I25)<>\"\",1,0),0)","v":0},{"$f":"IF(B25=\"3\",IF(TRIM(I25)<>\"\",1,0),0)","v":0},0,"224513328",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A25,8)=\"Stichpr.\",B25=\"1\",D25=\"\"),IF(TRIM(I25)<>\"\",1,0),0),IF(AND(B25=\"1\",D25=\"\"),IF(TRIM(I25)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A25,8)=\"Stichpr.\",LEFT(A25,1)=\"a\",B25=\"1\",D25=\"\"),IF(TRIM(I25)<>\"\",1,0),0),IF(AND(LEFT(A25,1)=\"a\",B25=\"1\",D25=\"\"),IF(TRIM(I25)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B25=\"1\",LEFT(A25,1)=\"a\",D25=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D25<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.2.1",null,null,null,"Schulungsplan für die Mitarbeiter"]
["3.2.2",null,null,null,"Festlegung eines Qualitätsbeauftragten",null,null,null,null,null,{"$f":"IF(B27=\"1\",IF(TRIM(F27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"3\",IF(TRIM(F27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"1\",IF(TRIM(G27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"3\",IF(TRIM(G27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"1\",IF(TRIM(H27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"3\",IF(TRIM(H27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"1\",IF(TRIM(I27)<>\"\",1,0),0)","v":0},{"$f":"IF(B27=\"3\",IF(TRIM(I27)<>\"\",1,0),0)","v":0},0,"224513329",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A27,8)=\"Stichpr.\",B27=\"1\",D27=\"\"),IF(TRIM(I27)<>\"\",1,0),0),IF(AND(B27=\"1\",D27=\"\"),IF(TRIM(I27)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A27,8)=\"Stichpr.\",LEFT(A27,1)=\"a\",B27=\"1\",D27=\"\"),IF(TRIM(I27)<>\"\",1,0),0),IF(AND(LEFT(A27,1)=\"a\",B27=\"1\",D27=\"\"),IF(TRIM(I27)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B27=\"1\",LEFT(A27,1)=\"a\",D27=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D27<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3","Produktion",null,null,null,null,null,null,null,null,{"$f":"IF(B28=\"1\",IF(TRIM(F28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"3\",IF(TRIM(F28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"1\",IF(TRIM(G28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"3\",IF(TRIM(G28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"1\",IF(TRIM(H28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"3\",IF(TRIM(H28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"1\",IF(TRIM(I28)<>\"\",1,0),0)","v":0},{"$f":"IF(B28=\"3\",IF(TRIM(I28)<>\"\",1,0),0)","v":0},0,"224513330",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A28,8)=\"Stichpr.\",B28=\"1\",D28=\"\"),IF(TRIM(I28)<>\"\",1,0),0),IF(AND(B28=\"1\",D28=\"\"),IF(TRIM(I28)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A28,8)=\"Stichpr.\",LEFT(A28,1)=\"a\",B28=\"1\",D28=\"\"),IF(TRIM(I28)<>\"\",1,0),0),IF(AND(LEFT(A28,1)=\"a\",B28=\"1\",D28=\"\"),IF(TRIM(I28)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B28=\"1\",LEFT(A28,1)=\"a\",D28=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D28<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.1",null,null,null,"[K.O.] Einhaltung einer vollständigen Kontaminationsmatrix "]
["3.3.2",null,null,null,"Prozessplanung, Dokumentation der Produktionsreihenfolge und Spülchargen",null,null,null,null,null,{"$f":"IF(B30=\"1\",IF(TRIM(F30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"3\",IF(TRIM(F30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"1\",IF(TRIM(G30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"3\",IF(TRIM(G30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"1\",IF(TRIM(H30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"3\",IF(TRIM(H30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"1\",IF(TRIM(I30)<>\"\",1,0),0)","v":0},{"$f":"IF(B30=\"3\",IF(TRIM(I30)<>\"\",1,0),0)","v":0},0,"224513332",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A30,8)=\"Stichpr.\",B30=\"1\",D30=\"\"),IF(TRIM(I30)<>\"\",1,0),0),IF(AND(B30=\"1\",D30=\"\"),IF(TRIM(I30)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A30,8)=\"Stichpr.\",LEFT(A30,1)=\"a\",B30=\"1\",D30=\"\"),IF(TRIM(I30)<>\"\",1,0),0),IF(AND(LEFT(A30,1)=\"a\",B30=\"1\",D30=\"\"),IF(TRIM(I30)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B30=\"1\",LEFT(A30,1)=\"a\",D30=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D30<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.3",null,null,null,"Vermeidung von Verunreinigungen der hergestellten Futtermittel",null,null,null,null,null,{"$f":"IF(B31=\"1\",IF(TRIM(F31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"3\",IF(TRIM(F31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"1\",IF(TRIM(G31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"3\",IF(TRIM(G31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"1\",IF(TRIM(H31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"3\",IF(TRIM(H31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"1\",IF(TRIM(I31)<>\"\",1,0),0)","v":0},{"$f":"IF(B31=\"3\",IF(TRIM(I31)<>\"\",1,0),0)","v":0},0,"224513333",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A31,8)=\"Stichpr.\",B31=\"1\",D31=\"\"),IF(TRIM(I31)<>\"\",1,0),0),IF(AND(B31=\"1\",D31=\"\"),IF(TRIM(I31)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A31,8)=\"Stichpr.\",LEFT(A31,1)=\"a\",B31=\"1\",D31=\"\"),IF(TRIM(I31)<>\"\",1,0),0),IF(AND(LEFT(A31,1)=\"a\",B31=\"1\",D31=\"\"),IF(TRIM(I31)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B31=\"1\",LEFT(A31,1)=\"a\",D31=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D31<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.4",null,null,null,"Dokumentation der Vorgehensweise bei Fehlern in der Produktion",null,null,null,null,null,{"$f":"IF(B32=\"1\",IF(TRIM(F32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"3\",IF(TRIM(F32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"1\",IF(TRIM(G32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"3\",IF(TRIM(G32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"1\",IF(TRIM(H32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"3\",IF(TRIM(H32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"1\",IF(TRIM(I32)<>\"\",1,0),0)","v":0},{"$f":"IF(B32=\"3\",IF(TRIM(I32)<>\"\",1,0),0)","v":0},0,"224513334",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A32,8)=\"Stichpr.\",B32=\"1\",D32=\"\"),IF(TRIM(I32)<>\"\",1,0),0),IF(AND(B32=\"1\",D32=\"\"),IF(TRIM(I32)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A32,8)=\"Stichpr.\",LEFT(A32,1)=\"a\",B32=\"1\",D32=\"\"),IF(TRIM(I32)<>\"\",1,0),0),IF(AND(LEFT(A32,1)=\"a\",B32=\"1\",D32=\"\"),IF(TRIM(I32)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B32=\"1\",LEFT(A32,1)=\"a\",D32=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D32<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.5",null,null,null,"Dokumentation im Mischbuch",null,null,null,null,null,{"$f":"IF(B33=\"1\",IF(TRIM(F33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"3\",IF(TRIM(F33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"1\",IF(TRIM(G33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"3\",IF(TRIM(G33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"1\",IF(TRIM(H33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"3\",IF(TRIM(H33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"1\",IF(TRIM(I33)<>\"\",1,0),0)","v":0},{"$f":"IF(B33=\"3\",IF(TRIM(I33)<>\"\",1,0),0)","v":0},0,"224513335",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A33,8)=\"Stichpr.\",B33=\"1\",D33=\"\"),IF(TRIM(I33)<>\"\",1,0),0),IF(AND(B33=\"1\",D33=\"\"),IF(TRIM(I33)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A33,8)=\"Stichpr.\",LEFT(A33,1)=\"a\",B33=\"1\",D33=\"\"),IF(TRIM(I33)<>\"\",1,0),0),IF(AND(LEFT(A33,1)=\"a\",B33=\"1\",D33=\"\"),IF(TRIM(I33)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B33=\"1\",LEFT(A33,1)=\"a\",D33=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D33<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4","Hygiene",null,null,null,null,null,null,null,null,{"$f":"IF(B34=\"1\",IF(TRIM(F34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"3\",IF(TRIM(F34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"1\",IF(TRIM(G34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"3\",IF(TRIM(G34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"1\",IF(TRIM(H34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"3\",IF(TRIM(H34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"1\",IF(TRIM(I34)<>\"\",1,0),0)","v":0},{"$f":"IF(B34=\"3\",IF(TRIM(I34)<>\"\",1,0),0)","v":0},0,"224513336",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A34,8)=\"Stichpr.\",B34=\"1\",D34=\"\"),IF(TRIM(I34)<>\"\",1,0),0),IF(AND(B34=\"1\",D34=\"\"),IF(TRIM(I34)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A34,8)=\"Stichpr.\",LEFT(A34,1)=\"a\",B34=\"1\",D34=\"\"),IF(TRIM(I34)<>\"\",1,0),0),IF(AND(LEFT(A34,1)=\"a\",B34=\"1\",D34=\"\"),IF(TRIM(I34)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B34=\"1\",LEFT(A34,1)=\"a\",D34=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D34<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4.1",null,null,null,"Umsetzung des Wartungsplans"]
["3.4.2",null,null,null,"Umsetzung des Reinigungsplans ",null,null,null,null,null,{"$f":"IF(B36=\"1\",IF(TRIM(F36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"3\",IF(TRIM(F36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"1\",IF(TRIM(G36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"3\",IF(TRIM(G36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"1\",IF(TRIM(H36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"3\",IF(TRIM(H36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"1\",IF(TRIM(I36)<>\"\",1,0),0)","v":0},{"$f":"IF(B36=\"3\",IF(TRIM(I36)<>\"\",1,0),0)","v":0},0,"224513338",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A36,8)=\"Stichpr.\",B36=\"1\",D36=\"\"),IF(TRIM(I36)<>\"\",1,0),0),IF(AND(B36=\"1\",D36=\"\"),IF(TRIM(I36)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A36,8)=\"Stichpr.\",LEFT(A36,1)=\"a\",B36=\"1\",D36=\"\"),IF(TRIM(I36)<>\"\",1,0),0),IF(AND(LEFT(A36,1)=\"a\",B36=\"1\",D36=\"\"),IF(TRIM(I36)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B36=\"1\",LEFT(A36,1)=\"a\",D36=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D36<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4.3",null,null,null,"Sauberkeit der Anlage",null,null,null,null,null,{"$f":"IF(B37=\"1\",IF(TRIM(F37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"3\",IF(TRIM(F37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"1\",IF(TRIM(G37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"3\",IF(TRIM(G37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"1\",IF(TRIM(H37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"3\",IF(TRIM(H37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"1\",IF(TRIM(I37)<>\"\",1,0),0)","v":0},{"$f":"IF(B37=\"3\",IF(TRIM(I37)<>\"\",1,0),0)","v":0},0,"224513339",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A37,8)=\"Stichpr.\",B37=\"1\",D37=\"\"),IF(TRIM(I37)<>\"\",1,0),0),IF(AND(B37=\"1\",D37=\"\"),IF(TRIM(I37)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A37,8)=\"Stichpr.\",LEFT(A37,1)=\"a\",B37=\"1\",D37=\"\"),IF(TRIM(I37)<>\"\",1,0),0),IF(AND(LEFT(A37,1)=\"a\",B37=\"1\",D37=\"\"),IF(TRIM(I37)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B37=\"1\",LEFT(A37,1)=\"a\",D37=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D37<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4.4",null,null,null,"Wasserqualität",null,null,null,null,null,{"$f":"IF(B38=\"1\",IF(TRIM(F38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"3\",IF(TRIM(F38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"1\",IF(TRIM(G38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"3\",IF(TRIM(G38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"1\",IF(TRIM(H38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"3\",IF(TRIM(H38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"1\",IF(TRIM(I38)<>\"\",1,0),0)","v":0},{"$f":"IF(B38=\"3\",IF(TRIM(I38)<>\"\",1,0),0)","v":0},0,"224513340",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A38,8)=\"Stichpr.\",B38=\"1\",D38=\"\"),IF(TRIM(I38)<>\"\",1,0),0),IF(AND(B38=\"1\",D38=\"\"),IF(TRIM(I38)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A38,8)=\"Stichpr.\",LEFT(A38,1)=\"a\",B38=\"1\",D38=\"\"),IF(TRIM(I38)<>\"\",1,0),0),IF(AND(LEFT(A38,1)=\"a\",B38=\"1\",D38=\"\"),IF(TRIM(I38)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B38=\"1\",LEFT(A38,1)=\"a\",D38=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D38<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4","Anforderungen an den Transport mitgebrachter Komponenten",null,null,null,null,null,null,null,null,{"$f":"IF(B39=\"1\",IF(TRIM(F39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"3\",IF(TRIM(F39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"1\",IF(TRIM(G39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"3\",IF(TRIM(G39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"1\",IF(TRIM(H39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"3\",IF(TRIM(H39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"1\",IF(TRIM(I39)<>\"\",1,0),0)","v":0},{"$f":"IF(B39=\"3\",IF(TRIM(I39)<>\"\",1,0),0)","v":0},0,"224513365",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A39,8)=\"Stichpr.\",B39=\"1\",D39=\"\"),IF(TRIM(I39)<>\"\",1,0),0),IF(AND(B39=\"1\",D39=\"\"),IF(TRIM(I39)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A39,8)=\"Stichpr.\",LEFT(A39,1)=\"a\",B39=\"1\",D39=\"\"),IF(TRIM(I39)<>\"\",1,0),0),IF(AND(LEFT(A39,1)=\"a\",B39=\"1\",D39=\"\"),IF(TRIM(I39)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B39=\"1\",LEFT(A39,1)=\"a\",D39=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D39<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.1","Transport"]
["4.1.1",null,"",null,"Einhaltung der Anforderungen an den Transport"]
["5","Anforderungen an den Handel mit Ölen und Fetten",null,null,null,null,null,null,null,null,{"$f":"IF(B42=\"1\",IF(TRIM(F42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"3\",IF(TRIM(F42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"1\",IF(TRIM(G42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"3\",IF(TRIM(G42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"1\",IF(TRIM(H42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"3\",IF(TRIM(H42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"1\",IF(TRIM(I42)<>\"\",1,0),0)","v":0},{"$f":"IF(B42=\"3\",IF(TRIM(I42)<>\"\",1,0),0)","v":0},0,"224513343",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A42,8)=\"Stichpr.\",B42=\"1\",D42=\"\"),IF(TRIM(I42)<>\"\",1,0),0),IF(AND(B42=\"1\",D42=\"\"),IF(TRIM(I42)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A42,8)=\"Stichpr.\",LEFT(A42,1)=\"a\",B42=\"1\",D42=\"\"),IF(TRIM(I42)<>\"\",1,0),0),IF(AND(LEFT(A42,1)=\"a\",B42=\"1\",D42=\"\"),IF(TRIM(I42)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B42=\"1\",LEFT(A42,1)=\"a\",D42=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D42<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.1","Beschaffungsangaben und Futtermittelbezug"]
["5.1.1",null,null,null,"Beschreibung der Futtermittel "]
["5.1.2",null,null,null,"[K.O.] Bezug von Ölen und Fetten und deren Erzeugnissen",null,null,null,null,null,{"$f":"IF(B45=\"1\",IF(TRIM(F45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"3\",IF(TRIM(F45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"1\",IF(TRIM(G45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"3\",IF(TRIM(G45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"1\",IF(TRIM(H45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"3\",IF(TRIM(H45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"1\",IF(TRIM(I45)<>\"\",1,0),0)","v":0},{"$f":"IF(B45=\"3\",IF(TRIM(I45)<>\"\",1,0),0)","v":0},0,"224513347",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A45,8)=\"Stichpr.\",B45=\"1\",D45=\"\"),IF(TRIM(I45)<>\"\",1,0),0),IF(AND(B45=\"1\",D45=\"\"),IF(TRIM(I45)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A45,8)=\"Stichpr.\",LEFT(A45,1)=\"a\",B45=\"1\",D45=\"\"),IF(TRIM(I45)<>\"\",1,0),0),IF(AND(LEFT(A45,1)=\"a\",B45=\"1\",D45=\"\"),IF(TRIM(I45)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B45=\"1\",LEFT(A45,1)=\"a\",D45=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D45<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.1.3",null,null,null,"[K.O.] Lieferberechtigung der Lieferanten ",null,null,null,null,null,{"$f":"IF(B46=\"1\",IF(TRIM(F46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"3\",IF(TRIM(F46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"1\",IF(TRIM(G46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"3\",IF(TRIM(G46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"1\",IF(TRIM(H46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"3\",IF(TRIM(H46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"1\",IF(TRIM(I46)<>\"\",1,0),0)","v":0},{"$f":"IF(B46=\"3\",IF(TRIM(I46)<>\"\",1,0),0)","v":0},0,"224513349",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A46,8)=\"Stichpr.\",B46=\"1\",D46=\"\"),IF(TRIM(I46)<>\"\",1,0),0),IF(AND(B46=\"1\",D46=\"\"),IF(TRIM(I46)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A46,8)=\"Stichpr.\",LEFT(A46,1)=\"a\",B46=\"1\",D46=\"\"),IF(TRIM(I46)<>\"\",1,0),0),IF(AND(LEFT(A46,1)=\"a\",B46=\"1\",D46=\"\"),IF(TRIM(I46)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B46=\"1\",LEFT(A46,1)=\"a\",D46=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D46<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.2","Anforderungen an die Lagerung",null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"1\",IF(TRIM(F47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"3\",IF(TRIM(F47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"1\",IF(TRIM(G47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"3\",IF(TRIM(G47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"1\",IF(TRIM(H47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"3\",IF(TRIM(H47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"1\",IF(TRIM(I47)<>\"\",1,0),0)","v":0},{"$f":"IF(B47=\"3\",IF(TRIM(I47)<>\"\",1,0),0)","v":0},0,"224513348",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A47,8)=\"Stichpr.\",B47=\"1\",D47=\"\"),IF(TRIM(I47)<>\"\",1,0),0),IF(AND(B47=\"1\",D47=\"\"),IF(TRIM(I47)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A47,8)=\"Stichpr.\",LEFT(A47,1)=\"a\",B47=\"1\",D47=\"\"),IF(TRIM(I47)<>\"\",1,0),0),IF(AND(LEFT(A47,1)=\"a\",B47=\"1\",D47=\"\"),IF(TRIM(I47)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B47=\"1\",LEFT(A47,1)=\"a\",D47=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D47<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.2.1",null,null,null,"[K.O.] Gestaltung des Lagers"]
["5.2.2",null,null,null,"[K.O.] Gewährleistung der Warentrennung",null,null,null,null,null,{"$f":"IF(B49=\"1\",IF(TRIM(F49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"3\",IF(TRIM(F49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"1\",IF(TRIM(G49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"3\",IF(TRIM(G49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"1\",IF(TRIM(H49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"3\",IF(TRIM(H49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"1\",IF(TRIM(I49)<>\"\",1,0),0)","v":0},{"$f":"IF(B49=\"3\",IF(TRIM(I49)<>\"\",1,0),0)","v":0},0,"224513351",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A49,8)=\"Stichpr.\",B49=\"1\",D49=\"\"),IF(TRIM(I49)<>\"\",1,0),0),IF(AND(B49=\"1\",D49=\"\"),IF(TRIM(I49)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A49,8)=\"Stichpr.\",LEFT(A49,1)=\"a\",B49=\"1\",D49=\"\"),IF(TRIM(I49)<>\"\",1,0),0),IF(AND(LEFT(A49,1)=\"a\",B49=\"1\",D49=\"\"),IF(TRIM(I49)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B49=\"1\",LEFT(A49,1)=\"a\",D49=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D49<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.3","Schädlingsmonitoring",null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"1\",IF(TRIM(F50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"3\",IF(TRIM(F50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"1\",IF(TRIM(G50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"3\",IF(TRIM(G50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"1\",IF(TRIM(H50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"3\",IF(TRIM(H50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"1\",IF(TRIM(I50)<>\"\",1,0),0)","v":0},{"$f":"IF(B50=\"3\",IF(TRIM(I50)<>\"\",1,0),0)","v":0},0,"224513352",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A50,8)=\"Stichpr.\",B50=\"1\",D50=\"\"),IF(TRIM(I50)<>\"\",1,0),0),IF(AND(B50=\"1\",D50=\"\"),IF(TRIM(I50)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A50,8)=\"Stichpr.\",LEFT(A50,1)=\"a\",B50=\"1\",D50=\"\"),IF(TRIM(I50)<>\"\",1,0),0),IF(AND(LEFT(A50,1)=\"a\",B50=\"1\",D50=\"\"),IF(TRIM(I50)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B50=\"1\",LEFT(A50,1)=\"a\",D50=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D50<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.3.1",null,null,null,"[K.O.] Schädlingsprophylaxe, -monitoring und -bekämpfung "]
["5.4","Kennzeichnung als Futtermittel aus dem QS-System",null,null,null,null,null,null,null,null,{"$f":"IF(B52=\"1\",IF(TRIM(F52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"3\",IF(TRIM(F52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"1\",IF(TRIM(G52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"3\",IF(TRIM(G52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"1\",IF(TRIM(H52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"3\",IF(TRIM(H52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"1\",IF(TRIM(I52)<>\"\",1,0),0)","v":0},{"$f":"IF(B52=\"3\",IF(TRIM(I52)<>\"\",1,0),0)","v":0},0,"224513354",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A52,8)=\"Stichpr.\",B52=\"1\",D52=\"\"),IF(TRIM(I52)<>\"\",1,0),0),IF(AND(B52=\"1\",D52=\"\"),IF(TRIM(I52)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A52,8)=\"Stichpr.\",LEFT(A52,1)=\"a\",B52=\"1\",D52=\"\"),IF(TRIM(I52)<>\"\",1,0),0),IF(AND(LEFT(A52,1)=\"a\",B52=\"1\",D52=\"\"),IF(TRIM(I52)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B52=\"1\",LEFT(A52,1)=\"a\",D52=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D52<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.4.1",null,null,null,"[K.O.] Artikelbezogene Kennzeichnung als Futtermittel aus dem QS-System"]
["5.4.2",null,null,null,"Zuordnung von Handelsware zur Standortnummer (VVVO-Nummer)",null,null,null,null,null,{"$f":"IF(B54=\"1\",IF(TRIM(F54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"3\",IF(TRIM(F54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"1\",IF(TRIM(G54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"3\",IF(TRIM(G54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"1\",IF(TRIM(H54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"3\",IF(TRIM(H54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"1\",IF(TRIM(I54)<>\"\",1,0),0)","v":0},{"$f":"IF(B54=\"3\",IF(TRIM(I54)<>\"\",1,0),0)","v":0},0,"224513356",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A54,8)=\"Stichpr.\",B54=\"1\",D54=\"\"),IF(TRIM(I54)<>\"\",1,0),0),IF(AND(B54=\"1\",D54=\"\"),IF(TRIM(I54)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A54,8)=\"Stichpr.\",LEFT(A54,1)=\"a\",B54=\"1\",D54=\"\"),IF(TRIM(I54)<>\"\",1,0),0),IF(AND(LEFT(A54,1)=\"a\",B54=\"1\",D54=\"\"),IF(TRIM(I54)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B54=\"1\",LEFT(A54,1)=\"a\",D54=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D54<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.5","Futtermittelmonitoring",null,null,null,null,null,null,null,null,{"$f":"IF(B55=\"1\",IF(TRIM(F55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"3\",IF(TRIM(F55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"1\",IF(TRIM(G55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"3\",IF(TRIM(G55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"1\",IF(TRIM(H55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"3\",IF(TRIM(H55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"1\",IF(TRIM(I55)<>\"\",1,0),0)","v":0},{"$f":"IF(B55=\"3\",IF(TRIM(I55)<>\"\",1,0),0)","v":0},0,"224513357",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A55,8)=\"Stichpr.\",B55=\"1\",D55=\"\"),IF(TRIM(I55)<>\"\",1,0),0),IF(AND(B55=\"1\",D55=\"\"),IF(TRIM(I55)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A55,8)=\"Stichpr.\",LEFT(A55,1)=\"a\",B55=\"1\",D55=\"\"),IF(TRIM(I55)<>\"\",1,0),0),IF(AND(LEFT(A55,1)=\"a\",B55=\"1\",D55=\"\"),IF(TRIM(I55)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B55=\"1\",LEFT(A55,1)=\"a\",D55=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D55<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.5.1",null,null,null,"[K.O.] Teilnahme am Futtermittelmonitoring"]
["5.5.2",null,null,null,"[K.O.] Freigabeprüfung: Umsetzung und Dateneingabe",null,null,null,null,null,{"$f":"IF(B57=\"1\",IF(TRIM(F57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"3\",IF(TRIM(F57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"1\",IF(TRIM(G57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"3\",IF(TRIM(G57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"1\",IF(TRIM(H57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"3\",IF(TRIM(H57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"1\",IF(TRIM(I57)<>\"\",1,0),0)","v":0},{"$f":"IF(B57=\"3\",IF(TRIM(I57)<>\"\",1,0),0)","v":0},0,"224513364",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A57,8)=\"Stichpr.\",B57=\"1\",D57=\"\"),IF(TRIM(I57)<>\"\",1,0),0),IF(AND(B57=\"1\",D57=\"\"),IF(TRIM(I57)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A57,8)=\"Stichpr.\",LEFT(A57,1)=\"a\",B57=\"1\",D57=\"\"),IF(TRIM(I57)<>\"\",1,0),0),IF(AND(LEFT(A57,1)=\"a\",B57=\"1\",D57=\"\"),IF(TRIM(I57)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B57=\"1\",LEFT(A57,1)=\"a\",D57=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D57<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.6","Rückstellmuster",null,null,null,null,null,null,null,null,{"$f":"IF(B58=\"1\",IF(TRIM(F58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"3\",IF(TRIM(F58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"1\",IF(TRIM(G58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"3\",IF(TRIM(G58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"1\",IF(TRIM(H58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"3\",IF(TRIM(H58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"1\",IF(TRIM(I58)<>\"\",1,0),0)","v":0},{"$f":"IF(B58=\"3\",IF(TRIM(I58)<>\"\",1,0),0)","v":0},0,"224513359",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A58,8)=\"Stichpr.\",B58=\"1\",D58=\"\"),IF(TRIM(I58)<>\"\",1,0),0),IF(AND(B58=\"1\",D58=\"\"),IF(TRIM(I58)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A58,8)=\"Stichpr.\",LEFT(A58,1)=\"a\",B58=\"1\",D58=\"\"),IF(TRIM(I58)<>\"\",1,0),0),IF(AND(LEFT(A58,1)=\"a\",B58=\"1\",D58=\"\"),IF(TRIM(I58)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B58=\"1\",LEFT(A58,1)=\"a\",D58=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D58<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.6.1",null,null,null,"[K.O.] Bildung von Rückstellmustern"]
["II","Zusatzmodul QS-Sojaplus",null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},0,"224513371",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(#REF!,8)=\"Stichpr.\",#REF!=\"1\",#REF!=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0),IF(AND(#REF!=\"1\",#REF!=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(#REF!,8)=\"Stichpr.\",LEFT(#REF!,1)=\"a\",#REF!=\"1\",#REF!=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0),IF(AND(LEFT(#REF!,1)=\"a\",#REF!=\"1\",#REF!=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0))","v":{"$error":"#REF!"}},{"$f":"IF(AND(#REF!=\"1\",LEFT(#REF!,1)=\"a\",#REF!=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(TRIM(#REF!)<>\"\",#REF!<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["II. 2","Anforderungen QS-Sojaplus\n"]
["II. 2.1","Allgemeine Anforderungen\n"]
["II. 2.1.1",null,null,null,"Verantwortlichkeiten und personelle Ressourcen"]
["II. 2.1.2",null,null,null,"Schulungen"]
["II. 2.1.3",null,null,null,"[K.O.] Dokumentation"]
["II. 2.1.4",null,null,null,"Beauftragung von Dritten"]
["II. 2.1.5",null,null,null,"Lieferantenbewertung"]
["II. 2.1.6",null,null,null,"[K.O.] Rückverfolgbarkeit"]
["II. 2.1.7",null,null,null,"Ereignismanagement"]
["II. 2.2","Auswertungen und Verbesserung"]
["II. 2.2.1",null,null,null,"Beschwerdemanagement"]
["II. 2.2.2",null,null,null,"Interne Audits"]
["II. 2.2.3",null,null,null,"[K.O.] Managementbewertung"]
["II. 2.3","Zertifizierungsstatus der Lieferanten"]
["II. 2.3.1",null,null,null,"[K.O.] QS-Sojaplus Lieferberechtigung der Lieferanten"]
["II. 2.4","Bezug von QS-Sojaplus-konformem Soja (IP, SEG, MB, B&C)"]
["II. 2.4.1",null,null,null,"Bezug von unverarbeiteten Sojabohnen"]
["II. 2.4.2",null,null,null,"Bezug von Verarbeitungserzeugnissen aus Sojabohnen (Einzelfuttermittel)"]
["II. 2.4.3",null,null,null,"Bezug von Mischfuttermitteln"]
["II. 2.5","Bezug von nicht QS-Sojaplus-konformem Soja"]
["II. 2.5.1",null,null,null,"[K.O.] Erwerb von Zertifikaten"]
["II. 2.6","Handhabung von Soja"]
["II. 2.6.1",null,null,null,"Überprüfung der Warenbegleitpapiere im Wareneingang "]
["II. 2.6.2",null,null,null,"Kennzeichnung im Warenausgang"]
["II. 2.6.3",null,null,null,"[K.O.] Erfassung von Mengenzu- und -abgängen"]
["II. 2.6.4",null,null,null,"Umrechnungsfaktoren"]
["II. 2.7","Zentral organisierter Einkauf bei Unternehmen mit mehreren Standorten"]
["II. 2.7.1",null,null,null,"Anforderungen an den zentral organisierten Einkauf"]
["II. 2.7.2",null,null,null,"Darstellung der Zuständigkeiten"]
["II. 2.7.3",null,null,null,"Informationspflicht bei Änderung der QS-Sojaplus Lieferberechtigung"]
["II. 2.8","Identity Preserved (IP)"]
["II. 2.8.1",null,null,null,"Warentrennung Identitätswahrung"]
["II. 2.8.2",null,null,null,"Lagermanagement"]
["II. 2.8.3",null,null,null,"Auslobung von IP-QS-Sojaplus"]
["II. 2.9","Segregation (SEG)"]
["II.  2.9.1",null,null,null,"Warentrennung / Segregation"]
["II.  2.9.2",null,null,null,"Lagermanagement"]
["II. 2.9.3",null,null,null,"Auslobung von segregiertem QS-Sojaplus"]
["II. 2.10","Massenbilanzierung (MB)"]
["II. 2.10.1",null,null,null,"Mengenerfassung"]
["II. 2.10.2",null,null,null,"Auslobung von massenbilanziertem QS-Sojaplus"]
["II. 2.11","Book & Claim (B&C)"]
["II. 2.11.1",null,null,null,"Mengenerfassung"]
["II. 2.11.2",null,null,null,"Auslobung von Book&Claim QS-Sojaplus"]

{"sheet":"Maßnahmenplan","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,1,0,3],[0,7,0,9],[7,9,7,10],[8,9,8,10],[4,0,4,5],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10]]}
["Betrieb:",null,null,null,"Datum:",{"$f":"IF(ISBLANK(Auditbericht!C7),\"\",Auditbericht!C7)","v":""},"Betrieb: ",{"$f":"IF(B1<>\"\",B1,\"\")","v":""},null,null,"Datum:     ",{"$f":"IF(ISBLANK(Auditbericht!C7),\"\",Auditbericht!C7)","v":""}]
[null,null,null,{"$f":"COUNTA(B8:B100)-1","v":0},"Massnahmenplan"]
["Maßnahmenplan zu Korrketur nicht erfüllter Kriterien",null,null,null,null,null,"Überprüfung der Umsetzung der Korrekturmaßnahmen"]
["Hiermit bestätige ich, dass die nachfolgend aufgeführten Korrekturmaßnahmen zwischen mir und dem Auditor vereinbart wurden."]
[]
[]
["Ort, Datum",null,null,"Unterschrift Betriebsverantwortlicher",null,null,"Ort, Datum",null,null,"Unterschrift/en Auditor/en"]
["Lfd. Nr. ","An-forderung Nr.","Beschreibung der Abweichung","Vereinbarte Korrekturmaßnahme","Betriebs-  zweig ","Behebungsfrist","Lfd. Nr. ","Erfüllt","Nicht erfüllt","Ggf. Bemerkungen",null,"Datum"]
[1,null,null,null,null,null,1]
[2,null,null,null,null,null,2]
[3,null,null,null,null,null,3]
[4,null,null,null,null,null,4]
[5,null,null,null,null,null,5]
[6,null,null,null,null,null,6]
[7,null,null,null,null,null,7]
[8,null,null,null,null,null,8]
[9,null,null,null,null,null,9]
[10,null,null,null,null,null,10]