{"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":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,0,28,10],[29,0,29,2],[29,4,29,10],[16,0,16,1],[16,2,16,10],[18,0,18,10],[19,0,19,8],[26,0,26,2],[26,4,26,10],[23,0,23,7],[23,8,23,10],[20,0,20,8],[19,9,19,10],[20,9,20,10],[9,0,9,1],[9,2,9,10],[25,0,25,1],[25,2,25,10],[13,0,13,1],[12,0,12,10],[15,0,15,1],[15,2,15,10],[13,2,13,10],[14,0,14,1],[14,2,14,10],[0,0,0,10],[2,0,2,10],[5,0,5,1],[5,2,5,10],[4,0,4,1],[4,2,4,10],[3,0,3,1],[3,2,3,10],[6,2,6,5],[6,9,6,10],[7,2,7,5],[7,9,7,10],[8,0,8,1],[8,2,8,5],[7,0,7,1],[6,0,6,1]]}
["Eigenkontrollcheckliste für Kleinsterzeuger (Einzelfuttermittelherstellung)",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)",null,{"$f":"IF(ISERROR(TEXT(ABS((VALUE(TEXT(J7,\"TT.MM.JJJJ\")&\" \"&TEXT(J8,\"[hh]:mm\")))-(VALUE(TEXT(C7,\"TT.MM.JJJJ\")&\" \"&TEXT(C8,\"[hh]:mm\")))),\"[h]:mm\")),\"\",TEXT(ABS((VALUE(TEXT(J7,\"TT.MM.JJJJ\")&\" \"&TEXT(J8,\"[hh]:mm\")))-(VALUE(TEXT(C7,\"TT.MM.JJJJ\")&\" \"&TEXT(C8,\"[hh]:mm\")))),\"[h]:mm\"))","v":""}]
["Nachname, Vorname des Auditors"]
[]
[]
["Angaben zum Betrieb - QS-Inspektion für Kleinsterzeuger (Einzelfuttermittelherstellung)"]
["Straße und Hausnummer"]
["Postleitzahl und Ort"]
["QS-Standortnummer"]
["Name des Verantwortlichen"]
[]
["Geltungsbereich - QS-Inspektion für Kleinsterzeuger (Einzelfuttermittelherstellung)"]
["Produktionsart",null,null,null,null,null,null,null,null,"Produktionsart-Nummer"]
["Kleinsterzeuger (Einzelfuttermittelherstellung)",null,null,null,null,null,null,null,null,73]
[]
["Zusatzinformationen - QS-Inspektion für Kleinsterzeuger (Einzelfuttermittelherstellung)"]
["Produktionsmenge Einzelfuttermittel pro Jahr in t Trockenmasse (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":136,"n_cols":26,"rows_kept":136,"cut":false,"hidden":false,"merged":[[130,1,130,9],[133,1,133,9],[111,1,111,9],[113,1,113,9],[118,1,118,9],[122,1,122,9],[126,1,126,9],[92,1,92,9],[93,1,93,9],[101,1,101,9],[105,1,105,9],[107,1,107,9],[0,1,0,7],[2,1,2,9],[3,1,3,9],[13,1,13,9],[25,1,25,9],[26,1,26,9],[28,1,28,9],[30,1,30,9],[43,1,43,9],[84,1,84,9],[91,1,91,9],[86,1,86,9],[89,1,89,9],[51,1,51,9],[55,1,55,9],[68,1,68,9],[70,1,70,9],[71,1,71,9],[73,1,73,9],[75,1,75,9],[77,1,77,9],[81,1,81,9],[83,1,83,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"]
["2.1","Allgemeine Systemanforderungen"]
["2.1.1",null,null,null,"[K.O.] Betriebsdaten",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,"224513066",{"$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.2",null,null,null,"[K.O.] Amtliche Registrierung",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,"224513148",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.3",null,null,null,"[K.O.] Ereignis- und Krisenmanagement",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,"224513067",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.4",null,null,null,"[K.O.] Rückverfolgbarkeit",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,"224513068",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.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(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,"224513069",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.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(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,"224513070",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.1.7",null,null,null,"Lenkung fehlerhafter Produkte",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B11=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B11=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513137",0,0,{"$f":"IF(AND(B11=\"1\",LEFT(A11,1)=\"a\",D11=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D11<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.1.8",null,null,null,"[K.O.] Bildung von Rückstellmustern",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513138",0,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.1.9",null,null,null,"Lieferantenbewertung",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,"224513087",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","HACCP-Konzept"]
["2.2.1",null,null,null,"[K.O.] HACCP-Konzept",null,null,null,null,null,{"$f":"IF(B15=\"1\",IF(TRIM(F15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"3\",IF(TRIM(F15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"1\",IF(TRIM(G15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"3\",IF(TRIM(G15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"1\",IF(TRIM(H15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"3\",IF(TRIM(H15)<>\"\",1,0),0)","v":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},{"$f":"IF(B15=\"1\",IF(TRIM(I15)<>\"\",1,0),0)","v":0},{"$f":"IF(B15=\"3\",IF(TRIM(I15)<>\"\",1,0),0)","v":0},0,"224513072",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A15,8)=\"Stichpr.\",B15=\"1\",D15=\"\"),IF(TRIM(I15)<>\"\",1,0),0),IF(AND(B15=\"1\",D15=\"\"),IF(TRIM(I15)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A15,8)=\"Stichpr.\",LEFT(A15,1)=\"a\",B15=\"1\",D15=\"\"),IF(TRIM(I15)<>\"\",1,0),0),IF(AND(LEFT(A15,1)=\"a\",B15=\"1\",D15=\"\"),IF(TRIM(I15)<>\"\",1,0),0))","v":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.2",null,null,null,"HACCP-Team",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,"224513115",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.3",null,null,null,"Fließdiagramme",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,"224513073",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.4",null,null,null,"Gefahrenanalyse",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,"224513116",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.5",null,null,null,"Kritische Lenkungspunkte (CCP)",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,"224513074",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.6",null,null,null,"Grenzwerte für CCP",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,"224513075",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.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(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,"224513076",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!"}}]
["2.2.8",null,null,null,"Korrekturmaßnahmen für CCP",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,"224513077",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!"}}]
["2.2.9",null,null,null,"Verantwortlichkeiten",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B23=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B23=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513078",0,0,{"$f":"IF(AND(B23=\"1\",LEFT(A23,1)=\"a\",D23=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D23<>\"\"),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(B24=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B24=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513079",0,0,{"$f":"IF(AND(B24=\"1\",LEFT(A24,1)=\"a\",D24=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D24<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["2.2.11",null,null,null,"HACCP Verifizierung",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513080",0,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.","Anforderungen an die Einzelfuttermittelherstellung"]
["3.1","Sachkunde"]
["3.1.1",null,"",null,"Futtermittelsachkunde",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,"224513083",{"$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.2","Deklaration und Kennzeichnung als Futtermittel aus dem QS-System"]
["3.2.1",null,"",null,"[K.O.] Artikelbezogene Kennzeichnung als Futtermittel aus dem QS-System",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,"224513085",{"$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","Produktion"]
["3.3.1",null,null,null,"Produktspezifikation",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,"224513090",{"$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.2",null,null,null,"[K.O.] Einsatz und Herstellung von Einzelfuttermitteln",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513089",0,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.3.3",null,null,null,"Bezug von Erzeugnissen aus pflanzlichen Ölen und Fetten",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513139",0,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.3.4",null,null,null,"Einsatz von Zusatzstoffen",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B35=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B35=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513117",0,0,{"$f":"IF(AND(B35=\"1\",LEFT(A35,1)=\"a\",D35=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D35<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.5",null,null,null,"[K.O.] Ausschlussliste",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513118",0,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.3.6",null,null,null,"[K.O.] Bezug von Nicht-zertifizierten Lieferanten: Gate-Keeper-Regelung",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513121",0,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.3.7",null,null,null,"[K.O.] Wareneingangskontrolle",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513088",0,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!"}}]
["3.3.8",null,null,null,"Gestaltung des Betriebes",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513091",0,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!"}}]
["3.3.9",null,null,null,"[K.O.] Gewährleistung der Warentrennung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B40=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B40=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513092",0,0,{"$f":"IF(AND(B40=\"1\",LEFT(A40,1)=\"a\",D40=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D40<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.10",null,null,null,"Verarbeitungsprozesse",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B41=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B41=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513093",0,0,{"$f":"IF(AND(B41=\"1\",LEFT(A41,1)=\"a\",D41=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D41<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.3.11",null,null,null,"[K.O.] Lagerung",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513094",0,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!"}}]
["3.3.12",null,null,null,"Verpackung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B43=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B43=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513095",0,0,{"$f":"IF(AND(B43=\"1\",LEFT(A43,1)=\"a\",D43=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D43<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4","Zusatzanforderungen an den Bezug von (ehemaligen) Lebensmitteln von einem Lebensmittelhersteller"]
["3.4.1",null,null,null,"Qualitätsfragebogen",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,"224513141",{"$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!"}}]
["3.4.2",null,null,null,"Prozessdiagramm",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513142",0,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!"}}]
["3.4.3",null,null,null,"Lieferantenaudits",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513143",0,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!"}}]
["3.4.4",null,null,null,"Kennzeichnug und Reinigung von Sammelbehältern",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B48=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B48=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513144",0,0,{"$f":"IF(AND(B48=\"1\",LEFT(A48,1)=\"a\",D48=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D48<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.4.5",null,null,null,"Transport der Rohwaren",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513145",0,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!"}}]
["3.4.6",null,null,null,"Direkte Auslieferung an den Kunden",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513146",0,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!"}}]
["3.4.7",null,null,null,"Auswertung der Lieferantenaudits, Qualitätsfragebögen und Prozessdiagramme",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B51=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B51=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513147",0,0,{"$f":"IF(AND(B51=\"1\",LEFT(A51,1)=\"a\",D51=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D51<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.5","Betriebshygiene"]
["3.5.1",null,null,null,"[K.O.] Reinigung",null,null,null,null,null,{"$f":"IF(B53=\"1\",IF(TRIM(F53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"3\",IF(TRIM(F53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"1\",IF(TRIM(G53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"3\",IF(TRIM(G53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"1\",IF(TRIM(H53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"3\",IF(TRIM(H53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"1\",IF(TRIM(I53)<>\"\",1,0),0)","v":0},{"$f":"IF(B53=\"3\",IF(TRIM(I53)<>\"\",1,0),0)","v":0},0,"224513097",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A53,8)=\"Stichpr.\",B53=\"1\",D53=\"\"),IF(TRIM(I53)<>\"\",1,0),0),IF(AND(B53=\"1\",D53=\"\"),IF(TRIM(I53)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A53,8)=\"Stichpr.\",LEFT(A53,1)=\"a\",B53=\"1\",D53=\"\"),IF(TRIM(I53)<>\"\",1,0),0),IF(AND(LEFT(A53,1)=\"a\",B53=\"1\",D53=\"\"),IF(TRIM(I53)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B53=\"1\",LEFT(A53,1)=\"a\",D53=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D53<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.5.2",null,null,null,"[K.O.] Schädlingsprophylaxe, -monitoring und -bekämpfung ",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,"224513098",{"$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!"}}]
["3.5.3",null,null,null,"Personalhygiene ",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,"224513099",{"$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!"}}]
["3.6","Futtermittelmonitoring"]
["3.6.1",null,null,null,"[K.O.] Erstellung standortbezogener QS-Kontrollpläne ",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,"224513101",{"$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!"}}]
["3.6.2",null,null,null,"[K.O.] Einhaltung der QS-Kontrollpläne",null,null,null,null,null,0,0,0,0,0,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},0,0,0,"224513113",0,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!"}}]
["3.6.3",null,null,null,"Probenahme und -versand",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B59=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B59=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513102",0,0,{"$f":"IF(AND(B59=\"1\",LEFT(A59,1)=\"a\",D59=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D59<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.4",null,null,null,"Analyse durch QS-anerkannte Labore",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B60=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B60=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513103",0,0,{"$f":"IF(AND(B60=\"1\",LEFT(A60,1)=\"a\",D60=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D60<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.5",null,null,null,"Branchenspezifische Kontrollpläne: Dateneingabe",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B61=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B61=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513104",0,0,{"$f":"IF(AND(B61=\"1\",LEFT(A61,1)=\"a\",D61=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D61<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.6",null,null,null,"Gate-Keeper-Regelung: Dateneingabe",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B62=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B62=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513149",0,0,{"$f":"IF(AND(B62=\"1\",LEFT(A62,1)=\"a\",D62=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D62<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.7",null,null,null,"[K.O.] Freigabeprüfung: Umsetzung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B63=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B63=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513112",0,0,{"$f":"IF(AND(B63=\"1\",LEFT(A63,1)=\"a\",D63=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D63<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.8",null,null,null,"Freigabeprüfung: Dateneingabe",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B64=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B64=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513119",0,0,{"$f":"IF(AND(B64=\"1\",LEFT(A64,1)=\"a\",D64=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D64<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.9",null,null,null,"[K.O.] Zusatzkontrollpläne: Umsetzung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B65=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B65=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513124",0,0,{"$f":"IF(AND(B65=\"1\",LEFT(A65,1)=\"a\",D65=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D65<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.10",null,null,null,"Zusatzkontrollpläne: Dateneingabe",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B66=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B66=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513125",0,0,{"$f":"IF(AND(B66=\"1\",LEFT(A66,1)=\"a\",D66=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D66<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.11",null,null,null,"[K.O.] Ad-hoc Monitoringpläne: Umsetzung",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B67=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B67=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513114",0,0,{"$f":"IF(AND(B67=\"1\",LEFT(A67,1)=\"a\",D67=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D67<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.6.12",null,null,null,"Ad-hoc Monitoringpläne: Dateneingabe",null,null,null,null,null,0,0,0,0,0,0,{"$f":"IF(B68=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B68=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},0,0,0,"224513120",0,0,{"$f":"IF(AND(B68=\"1\",LEFT(A68,1)=\"a\",D68=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D68<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["3.7","Transport von Futtermitten"]
["3.7.1",null,"",null,"Transport loser Ware",null,null,null,null,null,{"$f":"IF(B70=\"1\",IF(TRIM(F70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"3\",IF(TRIM(F70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"1\",IF(TRIM(G70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"3\",IF(TRIM(G70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"1\",IF(TRIM(H70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"3\",IF(TRIM(H70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"1\",IF(TRIM(I70)<>\"\",1,0),0)","v":0},{"$f":"IF(B70=\"3\",IF(TRIM(I70)<>\"\",1,0),0)","v":0},0,"224513123",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A70,8)=\"Stichpr.\",B70=\"1\",D70=\"\"),IF(TRIM(I70)<>\"\",1,0),0),IF(AND(B70=\"1\",D70=\"\"),IF(TRIM(I70)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A70,8)=\"Stichpr.\",LEFT(A70,1)=\"a\",B70=\"1\",D70=\"\"),IF(TRIM(I70)<>\"\",1,0),0),IF(AND(LEFT(A70,1)=\"a\",B70=\"1\",D70=\"\"),IF(TRIM(I70)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B70=\"1\",LEFT(A70,1)=\"a\",D70=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D70<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.","Anforderungen an den Handel"]
["4.1","Beschaffungsangaben"]
["4.1.1",null,"",null,"Beschreibung der Futtermittel",null,null,null,null,null,{"$f":"IF(B73=\"1\",IF(TRIM(F73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"3\",IF(TRIM(F73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"1\",IF(TRIM(G73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"3\",IF(TRIM(G73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"1\",IF(TRIM(H73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"3\",IF(TRIM(H73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"1\",IF(TRIM(I73)<>\"\",1,0),0)","v":0},{"$f":"IF(B73=\"3\",IF(TRIM(I73)<>\"\",1,0),0)","v":0},0,"224513131",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A73,8)=\"Stichpr.\",B73=\"1\",D73=\"\"),IF(TRIM(I73)<>\"\",1,0),0),IF(AND(B73=\"1\",D73=\"\"),IF(TRIM(I73)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A73,8)=\"Stichpr.\",LEFT(A73,1)=\"a\",B73=\"1\",D73=\"\"),IF(TRIM(I73)<>\"\",1,0),0),IF(AND(LEFT(A73,1)=\"a\",B73=\"1\",D73=\"\"),IF(TRIM(I73)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B73=\"1\",LEFT(A73,1)=\"a\",D73=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D73<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.2","Deklaration und Kennzeichnung als Futtermittel aus dem QS-System"]
["4.2.1",null,null,null,"[K.O.] Artikelbezogene Kennzeichnung als Futtermittel aus dem QS-System",null,null,null,null,null,{"$f":"IF(B75=\"1\",IF(TRIM(F75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"3\",IF(TRIM(F75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"1\",IF(TRIM(G75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"3\",IF(TRIM(G75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"1\",IF(TRIM(H75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"3\",IF(TRIM(H75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"1\",IF(TRIM(I75)<>\"\",1,0),0)","v":0},{"$f":"IF(B75=\"3\",IF(TRIM(I75)<>\"\",1,0),0)","v":0},0,"224513132",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A75,8)=\"Stichpr.\",B75=\"1\",D75=\"\"),IF(TRIM(I75)<>\"\",1,0),0),IF(AND(B75=\"1\",D75=\"\"),IF(TRIM(I75)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A75,8)=\"Stichpr.\",LEFT(A75,1)=\"a\",B75=\"1\",D75=\"\"),IF(TRIM(I75)<>\"\",1,0),0),IF(AND(LEFT(A75,1)=\"a\",B75=\"1\",D75=\"\"),IF(TRIM(I75)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B75=\"1\",LEFT(A75,1)=\"a\",D75=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D75<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.3","Anforderungen an Lagerstätten"]
["4.3.1",null,null,null,"[K.O.] Lagermanagement",null,null,null,null,null,{"$f":"IF(B77=\"1\",IF(TRIM(F77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"3\",IF(TRIM(F77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"1\",IF(TRIM(G77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"3\",IF(TRIM(G77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"1\",IF(TRIM(H77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"3\",IF(TRIM(H77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"1\",IF(TRIM(I77)<>\"\",1,0),0)","v":0},{"$f":"IF(B77=\"3\",IF(TRIM(I77)<>\"\",1,0),0)","v":0},0,"224513133",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A77,8)=\"Stichpr.\",B77=\"1\",D77=\"\"),IF(TRIM(I77)<>\"\",1,0),0),IF(AND(B77=\"1\",D77=\"\"),IF(TRIM(I77)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A77,8)=\"Stichpr.\",LEFT(A77,1)=\"a\",B77=\"1\",D77=\"\"),IF(TRIM(I77)<>\"\",1,0),0),IF(AND(LEFT(A77,1)=\"a\",B77=\"1\",D77=\"\"),IF(TRIM(I77)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B77=\"1\",LEFT(A77,1)=\"a\",D77=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D77<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.4","Futtermittelmonitoring"]
["4.4.1",null,null,null,"[K.O.] Erstellung und Einhaltung QS-Kontrollplan",null,null,null,null,null,{"$f":"IF(B79=\"1\",IF(TRIM(F79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"3\",IF(TRIM(F79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"1\",IF(TRIM(G79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"3\",IF(TRIM(G79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"1\",IF(TRIM(H79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"3\",IF(TRIM(H79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"1\",IF(TRIM(I79)<>\"\",1,0),0)","v":0},{"$f":"IF(B79=\"3\",IF(TRIM(I79)<>\"\",1,0),0)","v":0},0,"224513134",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A79,8)=\"Stichpr.\",B79=\"1\",D79=\"\"),IF(TRIM(I79)<>\"\",1,0),0),IF(AND(B79=\"1\",D79=\"\"),IF(TRIM(I79)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A79,8)=\"Stichpr.\",LEFT(A79,1)=\"a\",B79=\"1\",D79=\"\"),IF(TRIM(I79)<>\"\",1,0),0),IF(AND(LEFT(A79,1)=\"a\",B79=\"1\",D79=\"\"),IF(TRIM(I79)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B79=\"1\",LEFT(A79,1)=\"a\",D79=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D79<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.4.2",null,null,null,"Probenahme und -versand",null,null,null,null,null,{"$f":"IF(B80=\"1\",IF(TRIM(F80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"3\",IF(TRIM(F80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"1\",IF(TRIM(G80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"3\",IF(TRIM(G80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"1\",IF(TRIM(H80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"3\",IF(TRIM(H80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"1\",IF(TRIM(I80)<>\"\",1,0),0)","v":0},{"$f":"IF(B80=\"3\",IF(TRIM(I80)<>\"\",1,0),0)","v":0},0,"224513135",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A80,8)=\"Stichpr.\",B80=\"1\",D80=\"\"),IF(TRIM(I80)<>\"\",1,0),0),IF(AND(B80=\"1\",D80=\"\"),IF(TRIM(I80)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A80,8)=\"Stichpr.\",LEFT(A80,1)=\"a\",B80=\"1\",D80=\"\"),IF(TRIM(I80)<>\"\",1,0),0),IF(AND(LEFT(A80,1)=\"a\",B80=\"1\",D80=\"\"),IF(TRIM(I80)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B80=\"1\",LEFT(A80,1)=\"a\",D80=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D80<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.4.3",null,null,null,"Futtermittelmonitoring: Dateneingabe",null,null,null,null,null,{"$f":"IF(B81=\"1\",IF(TRIM(F81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"3\",IF(TRIM(F81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"1\",IF(TRIM(G81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"3\",IF(TRIM(G81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"1\",IF(TRIM(H81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"3\",IF(TRIM(H81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"1\",IF(TRIM(I81)<>\"\",1,0),0)","v":0},{"$f":"IF(B81=\"3\",IF(TRIM(I81)<>\"\",1,0),0)","v":0},0,"224513136",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A81,8)=\"Stichpr.\",B81=\"1\",D81=\"\"),IF(TRIM(I81)<>\"\",1,0),0),IF(AND(B81=\"1\",D81=\"\"),IF(TRIM(I81)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A81,8)=\"Stichpr.\",LEFT(A81,1)=\"a\",B81=\"1\",D81=\"\"),IF(TRIM(I81)<>\"\",1,0),0),IF(AND(LEFT(A81,1)=\"a\",B81=\"1\",D81=\"\"),IF(TRIM(I81)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B81=\"1\",LEFT(A81,1)=\"a\",D81=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D81<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["4.5","Transport von Futtermitteln"]
["4.5.1",null,"",null,"Transport loser Ware",null,null,null,null,null,{"$f":"IF(B83=\"1\",IF(TRIM(F83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"3\",IF(TRIM(F83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"1\",IF(TRIM(G83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"3\",IF(TRIM(G83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"1\",IF(TRIM(H83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"3\",IF(TRIM(H83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"1\",IF(TRIM(I83)<>\"\",1,0),0)","v":0},{"$f":"IF(B83=\"3\",IF(TRIM(I83)<>\"\",1,0),0)","v":0},0,"224513289",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A83,8)=\"Stichpr.\",B83=\"1\",D83=\"\"),IF(TRIM(I83)<>\"\",1,0),0),IF(AND(B83=\"1\",D83=\"\"),IF(TRIM(I83)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A83,8)=\"Stichpr.\",LEFT(A83,1)=\"a\",B83=\"1\",D83=\"\"),IF(TRIM(I83)<>\"\",1,0),0),IF(AND(LEFT(A83,1)=\"a\",B83=\"1\",D83=\"\"),IF(TRIM(I83)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B83=\"1\",LEFT(A83,1)=\"a\",D83=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D83<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.","Anforderungen an den Straßentransport"]
["5.1","Verfahrensbeschreibungen"]
["5.1.1",null,"",null,"Festlegung eines Verfahrens für den Transport",null,null,null,null,null,{"$f":"IF(B86=\"1\",IF(TRIM(F86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"3\",IF(TRIM(F86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"1\",IF(TRIM(G86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"3\",IF(TRIM(G86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"1\",IF(TRIM(H86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"3\",IF(TRIM(H86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"1\",IF(TRIM(I86)<>\"\",1,0),0)","v":0},{"$f":"IF(B86=\"3\",IF(TRIM(I86)<>\"\",1,0),0)","v":0},0,"224513107",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A86,8)=\"Stichpr.\",B86=\"1\",D86=\"\"),IF(TRIM(I86)<>\"\",1,0),0),IF(AND(B86=\"1\",D86=\"\"),IF(TRIM(I86)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A86,8)=\"Stichpr.\",LEFT(A86,1)=\"a\",B86=\"1\",D86=\"\"),IF(TRIM(I86)<>\"\",1,0),0),IF(AND(LEFT(A86,1)=\"a\",B86=\"1\",D86=\"\"),IF(TRIM(I86)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B86=\"1\",LEFT(A86,1)=\"a\",D86=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D86<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.2","Kennzeichnung und Rückverfolgbarkeit beim Straßentransport"]
["5.2.1",null,"",null,"Eindeutige Kennzeichnung der Laderäume",null,null,null,null,null,{"$f":"IF(B88=\"1\",IF(TRIM(F88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"3\",IF(TRIM(F88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"1\",IF(TRIM(G88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"3\",IF(TRIM(G88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"1\",IF(TRIM(H88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"3\",IF(TRIM(H88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"1\",IF(TRIM(I88)<>\"\",1,0),0)","v":0},{"$f":"IF(B88=\"3\",IF(TRIM(I88)<>\"\",1,0),0)","v":0},0,"224513110",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A88,8)=\"Stichpr.\",B88=\"1\",D88=\"\"),IF(TRIM(I88)<>\"\",1,0),0),IF(AND(B88=\"1\",D88=\"\"),IF(TRIM(I88)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A88,8)=\"Stichpr.\",LEFT(A88,1)=\"a\",B88=\"1\",D88=\"\"),IF(TRIM(I88)<>\"\",1,0),0),IF(AND(LEFT(A88,1)=\"a\",B88=\"1\",D88=\"\"),IF(TRIM(I88)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B88=\"1\",LEFT(A88,1)=\"a\",D88=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D88<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.2.2",null,"",null,"Dokumentation der Fahrten",null,null,null,null,null,{"$f":"IF(B89=\"1\",IF(TRIM(F89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"3\",IF(TRIM(F89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"1\",IF(TRIM(G89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"3\",IF(TRIM(G89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"1\",IF(TRIM(H89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"3\",IF(TRIM(H89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"1\",IF(TRIM(I89)<>\"\",1,0),0)","v":0},{"$f":"IF(B89=\"3\",IF(TRIM(I89)<>\"\",1,0),0)","v":0},0,"224513111",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A89,8)=\"Stichpr.\",B89=\"1\",D89=\"\"),IF(TRIM(I89)<>\"\",1,0),0),IF(AND(B89=\"1\",D89=\"\"),IF(TRIM(I89)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A89,8)=\"Stichpr.\",LEFT(A89,1)=\"a\",B89=\"1\",D89=\"\"),IF(TRIM(I89)<>\"\",1,0),0),IF(AND(LEFT(A89,1)=\"a\",B89=\"1\",D89=\"\"),IF(TRIM(I89)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B89=\"1\",LEFT(A89,1)=\"a\",D89=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D89<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["5.3","Ermittlung und Einhaltung der Reinigungsmaßnahmen"]
["5.3.1",null,null,null,"[K.O.] Ermittlung und Einhaltung der erforderlichen Reinigungsvorgaben",null,null,null,null,null,{"$f":"IF(B91=\"1\",IF(TRIM(F91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"3\",IF(TRIM(F91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"1\",IF(TRIM(G91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"3\",IF(TRIM(G91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"1\",IF(TRIM(H91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"3\",IF(TRIM(H91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"1\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"3\",IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"1\",IF(TRIM(I91)<>\"\",1,0),0)","v":0},{"$f":"IF(B91=\"3\",IF(TRIM(I91)<>\"\",1,0),0)","v":0},0,"224513108",{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A91,8)=\"Stichpr.\",B91=\"1\",D91=\"\"),IF(TRIM(I91)<>\"\",1,0),0),IF(AND(B91=\"1\",D91=\"\"),IF(TRIM(I91)<>\"\",1,0),0))","v":0},{"$f":"IF(COUNTIF(A:A,\"*Stichpr*\")>0,IF(AND(RIGHT(A91,8)=\"Stichpr.\",LEFT(A91,1)=\"a\",B91=\"1\",D91=\"\"),IF(TRIM(I91)<>\"\",1,0),0),IF(AND(LEFT(A91,1)=\"a\",B91=\"1\",D91=\"\"),IF(TRIM(I91)<>\"\",1,0),0))","v":0},{"$f":"IF(AND(B91=\"1\",LEFT(A91,1)=\"a\",D91=\"\"),IF(TRIM(#REF!)<>\"\",1,0),0)","v":0},{"$f":"IF(AND(TRIM(#REF!)<>\"\",D91<>\"\"),1,0)","v":{"$error":"#REF!"}}]
["II","Zusatzmodul QS-Sojaplus"]
["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 zur Korrektur 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","Betriebszweig ","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]