{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Werte","Plot","PlotData"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Plot","index":1,"reason":"not_a_worksheet"}],"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":"Werte","index":0,"n_rows":111,"n_cols":20,"rows_kept":111,"cut":false,"hidden":false,"merged":[[6,9,6,11],[34,6,34,11],[30,6,30,11],[31,6,31,11],[32,6,32,11],[33,6,33,11],[26,6,26,11],[27,6,27,11],[23,6,23,11],[9,6,9,11],[12,6,12,11],[13,6,13,11],[18,6,18,11],[19,6,19,11],[20,6,20,11],[21,6,21,11],[14,6,14,11],[15,6,15,11],[16,6,16,11],[17,6,17,11],[22,6,22,11],[25,6,25,11],[28,6,28,11],[29,6,29,11],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[6,7,6,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[2,7,2,8],[6,3,6,5],[110,6,110,11],[55,6,55,11],[56,6,56,11],[57,6,57,11],[58,6,58,11],[59,6,59,11],[60,6,60,11],[61,6,61,11],[62,6,62,11],[63,6,63,11],[108,6,108,11],[109,6,109,11],[64,6,64,11],[65,6,65,11],[66,6,66,11],[67,6,67,11],[68,6,68,11],[105,6,105,11],[106,6,106,11],[107,6,107,11],[69,6,69,11],[70,6,70,11],[104,6,104,11],[99,6,99,11],[97,6,97,11],[98,6,98,11],[103,6,103,11],[93,6,93,11],[91,6,91,11],[92,6,92,11],[85,6,85,11],[86,6,86,11],[87,6,87,11],[88,6,88,11],[100,6,100,11],[101,6,101,11],[102,6,102,11],[39,6,39,11],[40,6,40,11],[95,6,95,11],[96,6,96,11],[89,6,89,11],[90,6,90,11],[82,6,82,11],[83,6,83,11],[84,6,84,11],[41,6,41,11],[42,6,42,11],[76,6,76,11],[77,6,77,11],[78,6,78,11],[50,6,50,11],[51,6,51,11],[80,6,80,11],[73,6,73,11],[74,6,74,11],[75,6,75,11],[81,6,81,11],[79,6,79,11],[2,9,2,11],[3,9,3,11],[4,9,4,11],[5,9,5,11],[94,6,94,11],[52,6,52,11],[53,6,53,11],[54,6,54,11],[49,6,49,11],[71,6,71,11],[72,6,72,11],[24,6,24,11],[8,3,8,11],[43,6,43,11],[44,6,44,11],[45,6,45,11],[46,6,46,11],[47,6,47,11],[48,6,48,11],[11,6,11,11],[38,6,38,11],[35,6,35,11],[36,6,36,11],[37,6,37,11]]}
["ExcelKontrol Light - Mittelwert-Regelkarte",null,null,null,null,"v 1.0",null,null,null,null,null,"© Dr.-Ing. Michael Koch"]
[]
[null,"Labor",null,null,null,null,null,"Bearbeiter"]
[null,"Parameter",null,null,null,null,null,"Karten-Nr.",null,null,null,null,null,"Die Vollversion von ExcelKontrol",null,null,"verteilt durch"]
[null,"Norm / SOP",null,null,null,null,null,null,null,null,null,null,null,"finden Sie auf",null,null,"Gesellschaft für Lebensmittel-Forschung mbH"]
[null,"Matrix",null,null,null,null,null,null,null,null,null,null,null,"www.aqsbw.de",null,null,"www.gfl-berlin.com"]
[null,"Einheit",null,null,null,null,null,null,null," "]
[]
[null,"Vorperiode",null,"Kontrollperiode"]
[null,"Datum","Wert","Datum","Wert",null,"Kommentar/AK-Situation/Maßnahme"]
[]
[1,null,null,null,null,"",null,null,null,null,null,null,null,"Regeln für Außer-Kontroll-Situationen"]
[2,null,null,null,null,"",null,null,null,null,null,null,null,"A Ein Wert jenseits der Kontrollgrenzen"]
[3,null,null,null,null,"",null,null,null,null,null,null,null,"B 2 von 3 aufeinanderfolgenden Werten jenseits der Wangrenzen"]
[4,null,null,null,null,"",null,null,null,null,null,null,null,"C 7 aufeinanderfolgende Werte stetig steigend oder fallend"]
[5,null,null,null,null,"",null,null,null,null,null,null,null,"D 7 aufeinanderfolgende Werte auf derselben Seite der Zentrallinie"]
[6,null,null,null,null,"",null,null,null,null,null,null,null,"E 10 von 11 aufeinanderf. Werten auf derselben Seite der Zentrallinie"]
[7,null,null,null,null,""]
[8,null,null,null,null,""]
[9,null,null,null,null,""]
[10,null,null,null,null,""]
[11,null,null,null,null,""]
[12,null,null,null,null,"",null,null,null,null,null,null,null,"Statistische Kennwerte"]
[13,null,null,null,null,""]
[14,null,null,null,null,"",null,null,null,null,null,null,null,"Mittelwert Vorperiode mVP =",null,null,null,{"$f":"IF(P27>11,AVERAGE(C12:C65536),\"zu wenig Werte\")","v":"zu wenig Werte"}]
[15,null,null,null,null,"",null,null,null,null,null,null,null,"Standardabweichung sVP =",null,null,null,{"$f":"IF(P27>11,STDEV(C12:C65536),\"zu wenig Werte\")","v":"zu wenig Werte"}]
[16,null,null,null,null,"",null,null,null,null,null,null,null,null,"nVP=",{"$f":"COUNT(C12:C65536)","v":0}]
[17,null,null,null,null,"",null,null,null,null,null,null,null,"Mittelwert Kontrollperiode MKP =",null,null,null,{"$f":"IF(P30>2,AVERAGE(E12:E65536),\"zu wenig Werte\")","v":"zu wenig Werte"}]
[18,null,null,null,null,"",null,null,null,null,null,null,null,"Standardabweichung (sKP) =",null,null,null,{"$f":"IF(P30>2,STDEV(E12:E65536),\"zu wenig Werte\")","v":"zu wenig Werte"}]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,"nKP=",{"$f":"COUNT(E12:E65536)","v":0}]
[20]
[21,null,null,null,null,null,null,null,null,null,null,null,null,"Zentrallinie",null,{"$f":"R25","v":"zu wenig Werte"},null,null,null,"schwarz"]
[22,null,null,null,null,null,null,null,null,null,null,null,null,"Standardabw.",null,{"$f":"R26","v":"zu wenig Werte"}]
[23,null,null,null,null,null,null,null,null,null,null,null,null,"Grenzen (siehe plot):"]
[24,null,null,null,null,null,null,null,null,null,null,null,null,"OK =",{"$f":"IF(OR(P32=\"keine gültige Zahl\",OR(P32=\"zu wenig Werte\",OR(P33=\"zu wenig Werte\",P33=\"keine gültige Zahl\"))),\"\",P32+3*P33)","v":""},null,"Obere Kontrollgrenze",null,null,"rot"]
[25,null,null,null,null,null,null,null,null,null,null,null,null,"OW =",{"$f":"IF(OR(P32=\"keine gültige Zahl\",OR(P32=\"zu wenig Werte\",OR(P33=\"zu wenig Werte\",P33=\"keine gültige Zahl\"))),\"\",P32+2*P33)","v":""},null,"Obere Warngrenze",null,null,"blau"]
[26]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P32=\"keine gültige Zahl\",OR(P32=\"zu wenig Werte\",OR(P33=\"zu wenig Werte\",P33=\"keine gültige Zahl\"))),\"\",P32-1*P33)","v":""}]
[28,null,null,null,null,null,null,null,null,null,null,null,null,"UW =",{"$f":"IF(OR(P32=\"keine gültige Zahl\",OR(P32=\"zu wenig Werte\",OR(P33=\"zu wenig Werte\",P33=\"keine gültige Zahl\"))),\"\",P32-2*P33)","v":""},null,"Untere Warngrenze",null,null,"blau"]
[29,null,null,null,null,null,null,null,null,null,null,null,null,"UK =",{"$f":"IF(OR(P32=\"keine gültige Zahl\",OR(P32=\"zu wenig Werte\",OR(P33=\"zu wenig Werte\",P33=\"keine gültige Zahl\"))),\"\",P32-3*P33)","v":""},null,"Untere Kontrollgenze",null,null,"rot"]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"PlotData","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"obere KG","obere WG","MW+1s","Mittelwert","MW-1s","untere WG","untere KG"]
[1,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[2,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[3,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[4,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[5,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[6,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[7,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[8,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[9,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[10,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[11,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[12,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[13,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[14,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[15,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[16,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[17,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[18,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[19,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]
[20,7.5584085962673253,6.7056057308448835,null,5,4.1471971345775582,3.2943942691551165,2.4415914037326747]