{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Konzentration","Motilität PR a+b","Vitalität","Motilität NP oder c","Motilität IM oder d","Morphologie Normalformen"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"Konzentration","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Nr.","Prim.Zähl-ergebnis 1","Prim.Zähl-ergebnis 2","diff","Betrag der diff","diff rel","Betrag der diff rel.","MW","1.96x \nAE","Frei-gabe diff","Frei-gabe diff rel","Verdün-nung\n(n-fach)","Ergebnis für Befund (Mio/ml)","Datum"]
[1,null,null,{"$f":"(B2-C2)","v":0},{"$f":"ABS(D2)","v":0},{"$f":"D2/H2","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F2)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(B2:C2)","v":{"$error":"#DIV/0!"}},{"$f":"1.96*SQRT(2*H2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E2>I2),\"!!!!!!\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(G2>I2),\"!!!!!!\",\"OK\")","v":{"$error":"#DIV/0!"}},null,{"$f":"(H2*L2)/100","v":{"$error":"#DIV/0!"}},null,null,"Beispiel: erste Zählung ergab 200 Spermien, zweite 210 Spermien. Ergebnis ist unter B und C eingetragen. Die Verdünnung war 1:20, also ist die Zahl 20 unter L eingetragen worden. Das Ergebnis in Mio/ml erscheint automatisch unter M"]
[2,null,null,0,{"$f":"ABS(D3)","v":0},{"$error":"#DIV/0!"},{"$f":"ABS(F3)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1.96*SQRT(2*H3)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E3>I3),\"!!!!!!\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(G3>I3),\"!!!!!!\",\"OK\")","v":{"$error":"#DIV/0!"}},null,{"$f":"(H3*L3)/100","v":{"$error":"#DIV/0!"}}]
[3,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"(H4*L4)/100","v":{"$error":"#DIV/0!"}}]
[4,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[5,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[6,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[7,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[8,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}," "]
[9,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[10,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[11,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[12,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[13,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[14,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[15,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[16,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[17,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[18,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[19,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[20,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[21,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[22,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[23,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[24,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[25,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[26,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[27,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[28,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[29,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[30,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[31,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[32,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[33,null,null,{"$f":"(B34-C34)","v":0},0,{"$f":"D34/H34","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(B34:C34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[34,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[35,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[36,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[37,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[38,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[39,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[40,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[41,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[42,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[43,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[44,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[45,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[46,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[47,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[48,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[49,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[50,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"n=",null,{"$f":"COUNT(B2:B51)","v":0}]
[null,"MW diff=",null,{"$f":"AVERAGE(D2:D51)","v":0}]
[null,"Median=",null,{"$f":"MEDIAN(D2:D51)","v":0}]
[null,"s(diff)=",null,{"$f":"STDEV(D2:D51)","v":0}]
[null,"Prüfgröße=",null,{"$f":"1.96*D57/SQRT(D54)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"MW diff soll kleiner sein als die Prüfgröße"]

{"sheet":"Motilität PR a+b","index":1,"n_rows":149,"n_cols":11,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
["Nr.","Mot. a+b1\n(%)","Mot. a+b2\n(%)","Anzahl N der\ndifferen-zierten Zellen","diff","Betrag der diff","MW","1.96x sqrt","Frei-gabe",null,"Datum"]
[1,30,33,200,{"$f":"(B2-C2)","v":-3},{"$f":"ABS(C2-B2)","v":3},{"$f":"AVERAGE(B2:C2)","v":31.5},{"$f":"1.96*SQRT(2*G2*(100-G2)/D2)","v":9.1045111895147883},{"$f":"IF(OR(F2>H2),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-15"]
[2,36,31,200,{"$f":"(B3-C3)","v":5},{"$f":"ABS(C3-B3)","v":5},{"$f":"AVERAGE(B3:C3)","v":33.5},{"$f":"1.96*SQRT(2*G3*(100-G3)/D3)","v":9.2510131337059498},{"$f":"IF(OR(F3>H3),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-21"]
[3,8,8,200,{"$f":"(B4-C4)","v":0},0,8,5.31734670677021,"OK",null,"2014-01-22"]
[4,62,53,200,{"$f":"(B5-C5)","v":9},{"$f":"ABS(C5-B5)","v":9},{"$f":"AVERAGE(B5:C5)","v":57.5},9.6891227673097422,"OK",null,"2014-02-03"]
[5,20,27,200,{"$f":"(B6-C6)","v":-7},7,23.5,8.3103768867603112,"OK",null,"2014-02-11"]
[6,20,28,200,-8,8,24,8.3708293495925474,"OK",null,"2014-02-12"]
[7,25,18,200,7,7,{"$f":"AVERAGE(B8:C8)","v":21.5},8.0521179822454165,"OK",null,"2014-02-17"]
[8,31,35,200,-4,4,33,9.2161692692788577,"OK",null,"2014-02-18"]
[9,7,12,200,-5,5,9.5,5.7470127892671341,"OK",null,"2014-02-24"]
[10,26,24,200,2,2,25,8.4870489570874987,"OK",null,"2014-02-25"]
[11,35,42,200,-7,7,38.5,9.5372681623198581,"OK",null,"2014-03-05"]
[12,36,32,200,4,4,34,9.2846919173443769,"OK",null,"2014-03-10"]
[13,32,24,200,8,8,28,8.8003781736923106,"OK",null,"2014-03-12"]
[14,30,26,200,4,4,28,8.8003781736923106,"OK",null,"2014-03-18"]
[15,46,51,200,-5,5,48.5,9.7955890073032368,"OK",null,"2014-03-19"]
[16,12,18,200,-6,6,15,6.9985998599719936,"OK",null,"2014-04-21"]
[17,42,42,200,0,0,42,9.6737467405344031,"OK",null,"2014-04-28"]
[18,32,38,200,-6,6,35,9.3486041738860663,"OK",null,"2014-04-30"]
[19,55,46,200,9,9,50.5,9.7995099877493868,"OK",null,"2014-05-06"]
[20,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2014-05-07"]
[21,33,32,200,1,1,32.5,9.1801470576456445,"OK",null,"2014-05-13"]
[22,23,25,200,-2,2,24,8.3708293495925474,"OK",null,"2014-05-14"]
[23,19,22,200,-3,3,20.5,7.9125518007783038,"OK",null,"2014-05-21"]
[24,25,30,200,-5,5,27.5,8.7516798387509578,"OK",null,"2014-05-26"]
[25,4,4,200,0,0,4,3.840799916684023,"OK",null,"2014-05-27"]
[26,38,33,200,5,5,35.5,9.3788611248914435,"OK",null,"2014-05-28"]
[27,21,22,200,-1,1,21.5,8.0521179822454165,"OK",null,"2014-06-03"]
[28,37,45,200,-8,8,41,9.6399327798486247,"OK",null,"2014-06-04"]
[29,34,33,200,1,1,33.5,9.2510131337059498,"OK",null,"2014-06-10"]
[30,25,24,200,1,1,24.5,8.4297091290269321,"OK",null,"2014-06-17"]
[31,42,35,200,7,7,38.5,9.5372681623198581,"OK",null,"2014-06-18"]
[32,25,21,200,4,4,23,8.248317161700319,"OK",null,"2014-07-08"]
[33,24,32,200,-8,8,28,8.8003781736923106,"OK",null,"2014-07-16"]
[34,3,2,200,1,1,2.5,3.060049019215215,"OK",null,"2014-07-17"]
[35,34,32,200,2,2,33,9.2161692692788577,"OK",null,"2014-07-22"]
[36,23,28,200,-5,5,25.5,8.5428798423014243,"OK",null,"2014-07-23"]
[37,21,16,200,5,5,18.5,7.6106322996187377,"OK",null,"2014-07-28"]
[38,53,53,200,0,0,53,9.7823440953587397,"OK",null,"2014-07-29"]
[39,21,18,200,3,3,19.5,7.7655338515777528,"OK",null,"2014-07-30"]
[40,27,33,200,-6,6,30,8.9818483621134462,"OK",null,"2014-08-05"]
[41,11,13,200,-2,2,12,6.3692461092345924,"OK",null,"2014-08-06"]
[42,25,26,200,-1,1,25.5,8.5428798423014243,"OK",null,"2014-08-11"]
[43,57,52,200,5,5,54.5,9.7602293005851042,"OK",null,"2014-09-01"]
[44,46,40,200,6,6,43,9.7034847348774651,"OK",null,"2014-09-02"]
[45,16,15,200,1,1,15.5,7.0933317982454485,"OK",null,"2014-09-09"]
[46,14,19,200,-5,5,16.5,7.2751387615632463,"OK",null,"2014-09-11"]
[47,33,39,200,-6,6,36,9.4079999999999995,"OK",null,"2014-09-15"]
[48,23,26,200,-3,3,24.5,8.4297091290269321,"OK",null,"2014-09-16"]
[49,32,24,200,8,8,28,8.8003781736923106,"OK",null,"2014-09-17"]
[50,29,29,200,0,0,29,8.8937362227581271,"OK",null,"2014-09-23"]
[51,53,46,200,{"$f":"(B52-C52)","v":7},{"$f":"ABS(C52-B52)","v":7},{"$f":"AVERAGE(B52:C52)","v":49.5},{"$f":"1.96*SQRT(2*G52*(100-G52)/D52)","v":9.7995099877493868},{"$f":"IF(OR(F52>H52),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-09-29"]
[52,29,23,200,6,6,26,8.5972311821888319,"OK",null,"2014-10-01"]
[53,29,24,200,5,5,26.5,8.650130866062085,"OK",null,"2014-10-08"]
[54,34,28,200,6,6,31,9.0648675666001868,"OK",null,"2014-10-14"]
[55,48,44,200,4,4,46,9.7685896627916566,"OK",null,"2014-10-20"]
[56,53,46,200,{"$f":"(B57-C57)","v":7},{"$f":"ABS(C57-B57)","v":7},{"$f":"AVERAGE(B57:C57)","v":49.5},{"$f":"1.96*SQRT(2*G57*(100-G57)/D57)","v":9.7995099877493868},{"$f":"IF(OR(F57>H57),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-10-22"]
[57,8,12,200,-4,4,10,5.88,"OK",null,"2014-11-03"]
[58,9,7,200,2,2,8,5.31734670677021,"OK",null,"2104-11-04"]
[59,20,22,200,-2,2,21,7.9832414469311903,"OK",null,"2014-11-05"]
[60,20,23,200,-3,3,21.5,8.0521179822454165,"OK",null,"2014-11-11"]
[61,36,32,200,4,4,34,9.2846919173443769,"OK",null,"2014-11-18"]
[62,38,31,200,7,7,34.5,9.317218254393314,"OK",null,"2014-11-19"]
[63,15,14,200,1,1,14.5,6.9011764214516358,"OK",null,"2014-12-09"]
[64,29,22,200,7,7,25.5,8.5428798423014243,"OK",null,"2015-01-12"]
[65,63,59,200,4,4,61,9.5598987442336441,"OK",null,"2015-01-13"]
[66,41,45,200,-4,4,43,9.7034847348774651,"OK",null,"2015-01-19"]
[67,30,34,200,-4,4,32,9.1429325711174325,"OK",null,"2015-02-02"]
[68,39,47,200,-8,8,43,9.7034847348774651,"OK",null,"2015-02-09"]
[69,30,24,200,6,6,27,8.7016053691258612,"OK",null,"2015-02-10"]
[70,45,40,200,5,5,42.5,9.6891227673097422,"OK",null,"2015-02-11"]
[71,37,32,200,5,5,34.5,9.317218254393314,"OK",null,"2015-02-18"]
[72,25,30,200,-5,5,27.5,8.7516798387509578,"OK",null,"2015-02-24"]
[73,31,25,200,6,6,28,8.8003781736923106,"OK",null,"2015-03-03"]
[74,21,21,200,0,0,21,7.9832414469311903,"OK",null,"2015-03-09"]
[75,50,49,200,1,1,49.5,9.7995099877493868,"OK",null,"2015-03-11"]
[76,36,27,200,9,9,31.5,9.1045111895147883,"OK",null,"2015-03-16"]
[77,21,26,200,-5,5,23.5,8.3103768867603112,"OK",null,"2015-03-18"]
[78,5,6,200,-1,1,5.5,4.4684131411497754,"OK",null,"2015-03-24"]
[79,33,29,200,4,4,31,9.0648675666001868,"OK",null,"2015-03-30"]
[80,6,10,200,-4,4,8,5.31734670677021,"OK",null,"2015-04-13"]
[81,36,30,200,6,6,33,9.2161692692788577,"OK",null,"2015-04-20"]
[82,45,44,200,1,1,44.5,9.7405295543928201,"OK",null,"2015-04-21"]
[83,55,52,200,3,3,53.5,9.7759605154685438,"OK",null,"2015-04-22"]
[84,30,27,200,3,3,28.5,8.8477230969329046,"OK",null,"2015-04-27"]
[85,48,44,200,4,4,46,9.7685896627916566,"OK",null,"2015-04-28"]
[86,30,25,200,5,5,27.5,8.7516798387509578,"OK",null,"2015-05-26"]
[87,30,23,200,7,7,26.5,8.650130866062085,"OK",null,"2015-06-22"]
[88,28,27,200,1,1,27.5,8.7516798387509578,"OK",null,"2015-06-29"]
[89,13,18,200,-5,5,15.5,7.0933317982454485,"OK",null,"2015-07-13"]
[90,56,54,200,2,2,55,9.7508768836448745,"OK",null,"2015-07-21"]
[91,29,25,200,4,4,27,8.7016053691258612,"OK",null,"2015-07-22"]
[92,37,31,200,6,6,34,9.2846919173443769,"OK",null,"2015-07-27"]
[93,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-08-03"]
[94,16,22,200,-6,6,19,7.6890977364057482,"OK",null,"2015-08-04"]
[95,25,21,200,4,4,23,8.248317161700319,"OK",null,"2015-08-11"]
[96,24,20,200,4,4,22,8.1192275494655277,"OK",null,"2015-08-12"]
[97,36,31,200,5,5,33.5,9.2510131337059498,"OK",null,"2015-09-07"]
[98,8,11,200,-3,3,9.5,5.7470127892671341,"OK",null,"2015-09-15"]
[99,19,18,200,1,1,18.5,7.6106322996187377,"OK",null,"2015-09-16"]
[100,20,28,200,-8,8,24,8.3708293495925474,"OK",null,"2015-09-21"]
[101,12,17,200,-5,5,14.5,6.9011764214516358,"OK",null,"2015-09-28"]
[102,19,12,200,7,7,15.5,7.0933317982454485,"OK",null,"2015-10-05"]
[103,22,18,200,4,4,20,7.84,"OK",null,"2015-10-06"]
[104,14,10,200,4,4,12,6.3692461092345924,"OK",null,"2015-10-12"]
[105,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-10-13"]
[106,31,33,200,-2,2,32,9.1429325711174325,"OK",null,"2015-10-13"]
[107,3,7,200,-4,4,5,4.2717209646698606,"OK",null,"2015-10-14"]
[108,16,20,200,-4,4,18,7.5300741032210299,"OK",null,"2015-10-19"]
[109,16,12,200,4,4,14,6.8009458165758083,"OK",null,"2015-10-20"]
[110,9,9,200,0,0,9,5.60916250433164,"OK",null,"2015-10-26"]
[111,10,12,200,-2,2,11,6.1326392360875097,"OK",null,"2015-10-27"]
[112,37,32,200,5,5,34.5,9.317218254393314,"OK",null,"2015-10-28"]
[113,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[136,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[137,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"n=",{"$f":"COUNT(B2:B138)","v":112}]
[null,null,null,"MW diff=",{"$f":"SUM(E2:E138)/E141","v":0.7946428571428571}]
[null,null,null,"Median=",{"$f":"MEDIAN(E2:E138)","v":1}]
[null,null,null,"s(diff)=",{"$f":"STDEV(E2:E138)","v":4.6407603549056669}]
[null,null,null,"Prüfgröße=",{"$f":"1.96*E144/SQRT(E141)","v":0.85948084553297688}]
[]
[]
[]
[null,null,null,"MW diff soll kleiner sein als die Prüfgröße"]

{"sheet":"Vitalität","index":2,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["Nr.","Vit.   N1","Vit.     N2","Anzahl N der\ndifferen-zierten Zellen","diff","Betrag der diff","MW","1.96x sqrt","Frei-gabe",null,"Datum"]
[1,75,80,200,{"$f":"B2-C2","v":-5},{"$f":"ABS(C2-B2)","v":5},{"$f":"AVERAGE(B2:C2)","v":77.5},{"$f":"1.96*SQRT(2*G2*(100-G2)/D2)","v":8.184613613360133},{"$f":"IF(OR(F2>H2),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-15"]
[2,82,81,200,{"$f":"B3-C3","v":1},{"$f":"ABS(C3-B3)","v":1},{"$f":"AVERAGE(B3:C3)","v":81.5},7.6106322996187377,{"$f":"IF(OR(F3>H3),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-22"]
[3,85,79,200,6,6,{"$f":"AVERAGE(B4:C4)","v":82},7.5300741032210299,"OK",null,"2014-02-18"]
[4,75,71,200,4,4,{"$f":"AVERAGE(B5:C5)","v":73},8.7016053691258612,"OK",null,"2014-02-24"]
[5,83,81,200,2,2,{"$f":"AVERAGE(B6:C6)","v":82},7.5300741032210299,"OK",null,"2014-02-25"]
[6,80,84,200,-4,4,82,7.5300741032210299,"OK",null,"2014-03-12"]
[7,75,82,200,-7,7,78.5,8.0521179822454165,"OK",null,"2014-03-18"]
[8,72,68,200,4,4,70,8.9818483621134462,"OK",null,"2014-04-21"]
[9,77,84,200,-7,7,80.5,7.7655338515777528,"OK",null,"2014-05-13"]
[10,86,87,87,-1,1,86.5,10.155150892782068,"OK",null,"2014-05-14"]
[11,79,76,200,3,3,77.5,8.184613613360133,"OK",null,"2014-05-20"]
[12,82,83,200,-1,1,82.5,7.4473552352496251,"OK",null,"2014-05-21"]
[13,88,90,200,-2,2,89,6.1326392360875097,"OK",null,"2014-05-26"]
[14,82,76,200,6,6,79,7.9832414469311903,"OK",null,"2014-05-27"]
[15,17,20,200,-3,3,18.5,7.6106322996187377,"OK",null,"2014-05-28"]
[16,83,81,200,2,2,82,7.5300741032210299,"OK",null,"2014-06-03"]
[17,81,79,200,2,2,80,7.84,"OK",null,"2014-06-04"]
[18,85,87,200,-2,2,86,6.8009458165758083,"OK",null,"2014-06-10"]
[19,85,82,200,3,3,83.5,7.2751387615632463,"OK",null,"2014-06-18"]
[20,77,76,200,1,1,76.5,8.3103768867603112,"OK",null,"2014-07-08"]
[21,73,73,200,0,0,73,8.7016053691258612,"OK",null,"2014-07-16"]
[22,90,87,200,3,3,88.5,6.2528300792521136,"OK",null,"2014-07-17"]
[23,80,80,200,0,0,80,7.84,"OK",null,"2014-07-23"]
[24,74,79,200,-5,5,76.5,8.3103768867603112,"OK",null,"2014-07-30"]
[25,78,74,200,4,4,76,8.3708293495925474,"OK",null,"2014-08-05"]
[26,76,69,200,7,7,72.5,8.7516798387509578,"OK",null,"2014-08-06"]
[27,80,76,200,4,4,78,8.1192275494655277,"OK",null,"2014-08-11"]
[28,74,75,200,-1,1,74.5,8.5428798423014243,"OK",null,"2014-09-11"]
[29,86,91,200,-5,5,88.5,6.2528300792521136,"OK",null,"2014-09-15"]
[30,81,81,200,0,0,81,7.6890977364057482,"OK",null,"2014-09-17"]
[31,80,76,200,4,4,78,8.1192275494655277,"OK",null,"2014-10-01"]
[32,90,88,200,2,2,89,6.1326392360875097,"OK",null,"2014-11-03"]
[33,90,86,200,4,4,88,{"$f":"1.96*SQRT(2*G34*(100-G34)/D34)","v":6.3692461092345924},"OK",null,"2014-11-04"]
[34,84,83,200,1,1,83.5,7.2751387615632463,"OK",null,"2014-10-08"]
[35,76,70,200,6,6,73,8.7016053691258612,"OK",null,"2015-05-26"]
[36,70,65,200,5,5,67.5,9.1801470576456445,"OK",null,"2015-07-13"]
[37,92,94,200,-2,2,93,5.0008815222918441,"OK",null,"2015-08-11"]
[38,85,89,200,-4,4,87,6.5915473145536927,"OK",null,"2015-10-05"]
[39,86,88,200,-2,2,87,6.5915473145536927,"OK",null,"2015-10-06"]
[40,93,90,200,3,3,91.5,5.4660812288146614,"OK",null,"2015-10-12"]
[41,88,84,200,4,4,86,6.8009458165758083,"OK",null,"2015-10-19"]
[42,80,86,200,-6,6,83,7.3624028686292355,"OK",null,"2015-10-26"]
[43,90,91,200,-1,1,90.5,5.7470127892671341,"OK",null,"2015-10-27"]
[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,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[72,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[73,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[74,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[75,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[76,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[77,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[78,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[79,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[80,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[81,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[82,null,null,200,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"n=",{"$f":"COUNT(B2:B85)","v":43}]
[null,null,null,"MW diff=",{"$f":"AVERAGE(E2:E83)","v":0.41818181818181815}]
[null,null,null,"Median=",{"$f":"MEDIAN(E2:E83)","v":0}]
[null,null,null,"s(diff)=",{"$f":"STDEV(E2:E83)","v":3.3592928548800991}]
[null,null,null,"Prüfgröße=",{"$f":"1.96*E89/SQRT(E86)","v":1.0040832210875883}]
[]
[]
[null,"MW diff soll kleiner sein als die Prüfgröße"]

{"sheet":"Motilität NP oder c","index":3,"n_rows":136,"n_cols":11,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["Nr.","Mot. c1","Mot. c2","Anzahl N der\ndifferen-zierten Zellen","diff","Betrag der diff","MW","1.96x sqrt","Frei-gabe",null,"Datum"]
[1,22,26,200,{"$f":"B2-C2","v":-4},{"$f":"ABS(C2-B2)","v":4},{"$f":"AVERAGE(B2:C2)","v":24},{"$f":"1.96*SQRT(2*G2*(100-G2)/D2)","v":8.3708293495925474},{"$f":"IF(OR(F2>H2),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-15"]
[2,16,23,200,-7,{"$f":"ABS(C3-B3)","v":7},{"$f":"AVERAGE(B3:C3)","v":19.5},{"$f":"1.96*SQRT(2*G3*(100-G3)/D3)","v":7.7655338515777528},{"$f":"IF(OR(F3>H3),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-21"]
[3,23,21,200,2,2,{"$f":"AVERAGE(B4:C4)","v":22},8.1192275494655277,"OK",null,"2014-01-22"]
[4,18,26,200,-8,8,{"$f":"AVERAGE(B5:C5)","v":22},8.1192275494655277,"OK",null,"2014-02-03"]
[5,33,30,200,3,3,{"$f":"AVERAGE(B6:C6)","v":31.5},9.1045111895147883,"OK",null,"2014-02-11"]
[6,15,16,200,-1,1,15.5,7.0933317982454485,"OK",null,"2014-02-12"]
[7,19,25,200,-6,6,22,8.1192275494655277,"OK",null,"2014-02-17"]
[8,23,17,200,6,6,20,7.84,"OK",null,"2014-02-18"]
[9,7,4,200,3,3,5.5,4.4684131411497754,"OK",null,"2014-02-24"]
[10,17,23,87,-6,6,20,11.886977323317206,"OK",null,"2014-02-25"]
[11,24,23,200,1,1,23.5,8.3103768867603112,"OK",null,"2014-03-05"]
[12,15,11,200,4,4,13,6.5915473145536927,"OK",null,"2014-03-10"]
[13,13,17,200,-4,4,15,6.9985998599719936,"OK",null,"2014-03-12"]
[14,18,15,200,3,3,16.5,7.2751387615632463,"OK",null,"2014-03-18"]
[15,11,17,200,-6,6,14,6.8009458165758083,"OK",null,"2014-03-19"]
[16,20,14,200,6,6,17,7.3624028686292355,"OK",null,"2014-04-21"]
[17,15,20,200,-5,5,17.5,7.4473552352496251,"OK",null,"2014-05-07"]
[18,11,17,200,-6,6,14,6.8009458165758083,"OK",null,"2014-05-07"]
[19,17,15,200,2,2,16,7.1854786896907568,"OK",null,"2014-05-06"]
[20,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2014-05-07"]
[21,25,18,200,7,7,21.5,8.0521179822454165,"OK",null,"2014-05-13"]
[22,15,19,200,-4,4,17,7.3624028686292355,"OK",null,"2014-05-14"]
[23,16,16,200,0,0,16,7.1854786896907568,"OK",null,"2014-05-21"]
[24,17,22,200,-5,5,19.5,7.7655338515777528,"OK",null,"2014-05-26"]
[25,6,10,200,-4,4,8,5.31734670677021,"OK",null,"2014-05-27"]
[26,17,24,200,-7,7,20.5,7.9125518007783038,"OK",null,"2014-05-28"]
[27,26,23,200,3,3,24.5,8.4297091290269321,"OK",null,"2014-06-03"]
[28,12,18,200,-6,6,15,6.9985998599719936,"OK",null,"2014-06-04"]
[29,16,20,200,-4,4,18,7.5300741032210299,"OK",null,"2014-06-10"]
[30,14,19,200,-5,5,16.5,7.2751387615632463,"OK",null,"2014-06-17"]
[31,12,10,200,2,2,11,6.1326392360875097,"OK",null,"2014-06-18"]
[32,12,17,200,-5,5,14.5,6.9011764214516358,"OK",null,"2014-07-08"]
[33,18,14,200,4,4,16,7.1854786896907568,"OK",null,"2014-07-16"]
[34,9,7,200,2,2,8,5.31734670677021,"OK",null,"2014-07-17"]
[35,13,16,200,-3,3,14.5,6.9011764214516358,"OK",null,"2014-07-22"]
[36,14,15,200,-1,1,14.5,6.9011764214516358,"OK",null,"2014-07-23"]
[37,22,18,200,4,4,20,7.84,"OK",null,"2014-07-28"]
[38,15,16,200,-1,1,15.5,7.0933317982454485,"OK",null,"2014-07-29"]
[39,20,23,200,-3,3,21.5,8.0521179822454165,"OK",null,"2014-07-30"]
[40,13,11,200,2,2,12,6.3692461092345924,"OK",null,"2014-08-05"]
[41,6,11,200,-5,5,8.5,5.4660812288146614,"OK",null,"2014-08-06"]
[42,12,12,200,0,0,12,6.3692461092345924,"OK",null,"2014-08-11"]
[43,11,9,200,2,2,10,5.88,"OK",null,"2014-09-01"]
[44,8,14,200,-6,6,11,6.1326392360875097,"OK",null,"2014-09-02"]
[45,39,40,200,-1,1,39.5,9.5814735818662058,"OK",null,"2014-09-09"]
[46,8,10,200,-2,2,9,5.60916250433164,"OK",null,"2014-09-11"]
[47,22,24,200,-2,2,23,8.248317161700319,"OK",null,"2014-09-15"]
[48,47,44,200,3,3,45.5,9.7602293005851042,"OK",null,"2014-09-16"]
[49,10,8,200,2,2,9,5.60916250433164,"OK",null,"2014-09-17"]
[50,23,19,200,4,4,21,7.9832414469311903,"OK",null,"2014-09-23"]
[51,14,21,200,-7,7,17.5,7.4473552352496251,"OK",null,"2014-09-29"]
[52,18,21,200,-3,3,19.5,7.7655338515777528,"OK",null,"2014-10-01"]
[53,13,19,200,-6,6,16,7.1854786896907568,"OK",null,"2014-10-08"]
[54,20,25,200,-5,5,22.5,8.184613613360133,"OK",null,"2014-10-14"]
[55,27,29,200,-2,2,28,8.8003781736923106,"OK",null,"2014-10-20"]
[56,15,12,200,3,3,13.5,6.6977820209379768,"OK",null,"2014-10-22"]
[57,21,20,200,1,1,20.5,7.9125518007783038,"OK",null,"2014-11-03"]
[58,19,18,200,1,1,18.5,7.6106322996187377,"OK",null,"2014-11-04"]
[59,28,20,200,8,8,24,8.3708293495925474,"OK",null,"2014-11-05"]
[60,18,21,200,-3,3,19.5,7.7655338515777528,"OK",null,"2014-11-11"]
[61,23,31,200,-8,8,27,8.7016053691258612,"OK",null,"2014-11-18"]
[62,12,14,200,-2,2,13,6.5915473145536927,"OK",null,"2014-11-19"]
[63,23,16,200,7,7,19.5,7.7655338515777528,"OK",null,"2014-12-09"]
[64,20,21,200,-1,1,20.5,7.9125518007783038,"OK",null,"2015-01-12"]
[65,12,12,200,0,0,12,6.3692461092345924,"OK",null,"2015-01-13"]
[66,27,21,200,6,6,24,8.3708293495925474,"OK",null,"2015-01-19"]
[67,24,30,200,-6,6,27,8.7016053691258612,"OK",null,"2015-02-02"]
[68,14,9,200,5,5,11.5,6.2528300792521136,"OK",null,"2015-02-09"]
[69,16,23,200,-7,7,19.5,7.7655338515777528,"OK",null,"2015-02-10"]
[70,10,12,200,-2,2,11,6.1326392360875097,"OK",null,"2015-02-11"]
[71,28,25,200,3,3,26.5,8.650130866062085,"OK",null,"2015-02-18"]
[72,23,20,200,3,3,21.5,8.0521179822454165,"OK",null,"2015-02-24"]
[73,12,10,200,2,2,11,6.1326392360875097,"OK",null,"2015-03-03"]
[74,19,22,200,-3,3,20.5,7.9125518007783038,"OK",null,"2015-03-09"]
[75,13,13,200,0,0,13,6.5915473145536927,"OK",null,"2015-03-11"]
[76,17,19,200,-2,2,18,7.5300741032210299,"OK",null,"2015-03-16"]
[77,17,22,200,-5,5,19.5,7.7655338515777528,"OK",null,"2015-03-18"]
[78,13,12,200,1,1,12.5,6.4820907121082465,"OK",null,"2015-03-24"]
[79,11,15,200,-4,4,13,6.5915473145536927,"OK",null,"2015-03-30"]
[80,10,15,200,-5,5,12.5,6.4820907121082465,"OK",null,"2015-04-13"]
[81,10,16,200,-6,6,13,6.5915473145536927,"OK",null,"2015-04-20"]
[82,20,19,200,1,1,19.5,7.7655338515777528,"OK",null,"2015-04-21"]
[83,9,14,200,-5,5,11.5,6.2528300792521136,"OK",null,"2015-04-22"]
[84,18,25,200,-7,7,21.5,8.0521179822454165,"OK",null,"2015-04-27"]
[85,22,25,200,-3,3,23.5,8.3103768867603112,"OK",null,"2015-04-28"]
[86,12,17,200,-5,5,14.5,6.9011764214516358,"OK",null,"2015-05-26"]
[87,22,26,200,-4,4,24,8.3708293495925474,"OK",null,"2015-06-22"]
[88,19,14,200,5,5,16.5,7.2751387615632463,"OK",null,"2015-06-29"]
[89,14,18,200,-4,4,16,7.1854786896907568,"OK",null,"2015-07-13"]
[90,11,17,200,-6,6,14,6.8009458165758083,"OK",null,"2015-07-21"]
[91,20,23,200,-3,3,21.5,8.0521179822454165,"OK",null,"2015-07-22"]
[92,18,21,200,-3,3,19.5,7.7655338515777528,"OK",null,"2015-07-27"]
[93,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-08-03"]
[94,29,26,200,3,3,27.5,8.7516798387509578,"OK",null,"2015-08-04"]
[95,17,19,200,-2,2,18,7.5300741032210299,"OK",null,"2015-08-11"]
[96,20,16,200,4,4,18,7.5300741032210299,"OK",null,"2015-08-12"]
[97,10,11,200,-1,1,10.5,6.0084470539399781,"OK",null,"2015-09-07"]
[98,25,32,200,-7,7,28.5,8.8477230969329046,"OK",null,"2015-09-15"]
[99,30,32,200,-2,2,31,9.0648675666001868,"OK","2015-09-16","2015-09-16"]
[100,27,22,200,5,5,24.5,8.4297091290269321,"OK",null,"2015-09-21"]
[101,27,29,200,-2,2,28,8.8003781736923106,"OK",null,"2015-09-28"]
[102,17,18,200,-1,1,17.5,7.4473552352496251,"OK",null,"2015-10-05"]
[103,11,14,200,-3,3,12.5,6.4820907121082465,"OK",null,"2015-10-06"]
[104,24,23,200,1,1,23.5,8.3103768867603112,"OK",null,"2015-10-12"]
[105,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-10-13"]
[106,34,30,200,4,4,32,9.1429325711174325,"OK",null,"2015-10-13"]
[107,44,40,200,4,4,42,9.6737467405344031,"OK",null,"2015-10-14"]
[108,18,21,200,-3,3,19.5,7.7655338515777528,"OK",null,"2015-10-19"]
[109,46,44,200,2,2,45,9.7508768836448745,"OK",null,"2015-10-20"]
[110,26,18,200,8,8,22,8.1192275494655277,"OK",null,"2015-10-26"]
[111,19,24,200,-5,5,21.5,8.0521179822454165,"OK",null,"2015-10-27"]
[112,26,30,200,-4,4,28,8.8003781736923106,"OK",null,"2015-10-28"]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[124,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[125,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"n=",{"$f":"COUNT(B2:B128)","v":112}]
[null,null,null,"MW diff=",{"$f":"AVERAGE(E2:E126)","v":-1.0608695652173914}]
[null,null,null,"Median=",{"$f":"MEDIAN(E2:E126)","v":-1}]
[null,null,null,"s(diff)=",{"$f":"STDEV(E2:E126)","v":4.026854931672144}]
[null,null,null,"Prüfgröße=",{"$f":"1.96*E132/SQRT(E129)","v":0.74578397004569408}]
[]
[]
[null,"MW diff soll kleiner sein als die Prüfgröße"]

{"sheet":"Motilität IM oder d","index":4,"n_rows":139,"n_cols":11,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Nr.","Mot. d1","Mot. d2","Anzahl N der\ndifferen-zierten Zellen","diff","Betrag der diff","MW","1.96x sqrt","Frei-gabe",null,"Datum"]
[1,47,46,200,{"$f":"B2-C2","v":1},{"$f":"ABS(C2-B2)","v":1},{"$f":"AVERAGE(B2:C2)","v":46.5},{"$f":"1.96*SQRT(2*G2*(100-G2)/D2)","v":9.7759605154685438},{"$f":"IF(OR(F2>H2),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-15"]
[2,48,42,200,{"$f":"B3-C3","v":6},{"$f":"ABS(C3-B3)","v":6},{"$f":"AVERAGE(B3:C3)","v":45},{"$f":"1.96*SQRT(2*G3*(100-G3)/D3)","v":9.7508768836448745},{"$f":"IF(OR(F3>H3),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-21"]
[3,81,80,200,1,1,{"$f":"AVERAGE(B4:C4)","v":80.5},7.7655338515777528,"OK",null,"2014-01-22"]
[4,23,20,200,3,3,{"$f":"AVERAGE(B5:C5)","v":21.5},8.0521179822454165,"OK",null,"2014-02-03"]
[5,47,51,200,-4,4,{"$f":"AVERAGE(B6:C6)","v":49},9.7980398039607906,"OK",null,"2014-02-11"]
[6,65,56,200,9,9,60.5,9.5814735818662058,"OK",null,"2014-02-12"]
[7,57,59,200,-2,2,58,9.6737467405344031,"OK",null,"2014-02-17"]
[8,46,50,200,-4,4,48,9.7921568614886887,"OK",null,"2014-02-18"]
[9,86,84,200,2,2,85,6.9985998599719936,"OK",null,"2014-02-24"]
[10,60,55,200,5,5,57.5,9.6891227673097422,"OK",null,"2014-02-25"]
[11,41,35,200,6,6,38,9.5135743020170924,"OK",null,"2014-03-05"]
[12,49,57,200,-8,8,53,9.7823440953587397,"OK",null,"2014-03-10"]
[13,56,62,200,-6,6,59,9.6399327798486247,"OK",null,"2014-03-12"]
[14,52,59,200,-7,7,55.5,9.7405295543928201,"OK",null,"2014-03-18"]
[15,43,34,200,9,9,38.5,9.5372681623198581,"OK",null,"2014-03-19"]
[16,73,71,200,2,2,72,8.8003781736923106,"OK",null,"2014-04-21"]
[17,45,40,200,5,5,42.5,9.6891227673097422,"OK",null,"2014-04-28"]
[18,56,47,200,9,9,51.5,9.7955890073032368,"OK",null,"2014-04-30"]
[19,29,38,200,-9,9,33.5,9.2510131337059498,"OK",null,"2014-05-06"]
[20,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2014-05-07"]
[21,45,53,200,-8,8,49,9.7980398039607906,"OK",null,"2014-05-13"]
[22,62,58,200,4,4,60,9.6019997917100568,"OK",null,"2014-05-14"]
[23,65,62,200,3,3,63.5,9.4360311572185882,"OK",null,"2014-05-21"]
[24,59,51,200,8,8,55,9.7508768836448745,"OK",null,"2014-05-26"]
[25,80,86,200,-6,6,83,7.3624028686292355,"OK",null,"2014-05-27"]
[26,45,43,200,2,2,44,9.7291841384568318,"OK",null,"2014-05-28"]
[27,54,53,200,1,1,53.5,9.7759605154685438,"OK",null,"2014-06-03"]
[28,45,37,200,8,8,41,9.6399327798486247,"OK",null,"2014-06-04"]
[29,51,48,200,3,3,49.5,9.7995099877493868,"OK",null,"2014-06-10"]
[30,63,57,200,6,6,60,9.6019997917100568,"OK",null,"2014-06-17"]
[31,46,55,200,-9,9,50.5,9.7995099877493868,"OK",null,"2014-06-18"]
[32,64,60,200,4,4,62,9.5135743020170924,"OK",null,"2014-07-08"]
[33,60,54,200,6,6,57,9.7034847348774651,"OK",null,"2014-07-16"]
[34,88,91,200,-3,3,89.5,6.0084470539399781,"OK",null,"2014-07-17"]
[35,53,52,200,1,1,52.5,9.7877423341647063,"OK",null,"2014-07-22"]
[36,65,57,200,8,8,61,9.5598987442336441,"OK",null,"2014-07-23"]
[37,57,66,200,-9,9,61.5,9.5372681623198581,"OK",null,"2014-07-28"]
[38,32,31,200,1,1,31.5,9.1045111895147883,"OK",null,"2014-07-29"]
[39,59,59,200,0,0,59,9.6399327798486247,"OK",null,"2014-07-30"]
[40,60,51,200,9,9,55.5,9.7405295543928201,"OK",null,"2014-08-05"]
[41,83,76,200,7,7,79.5,7.9125518007783038,"OK",null,"2014-08-06"]
[42,63,62,200,1,1,62.5,9.4888091982081715,"OK",null,"2014-08-11"]
[43,32,39,200,-7,7,35.5,9.3788611248914435,"OK",null,"2014-09-01"]
[44,46,44,200,2,2,45,9.7508768836448745,"OK",null,"2014-09-02"]
[45,45,46,200,-1,1,45.5,9.7602293005851042,"OK",null,"2014-09-09"]
[46,77,80,200,-3,3,78.5,8.0521179822454165,"OK",null,"2014-09-11"]
[47,45,37,200,8,8,41,9.6399327798486247,"OK",null,"2014-09-15"]
[48,32,31,200,1,1,31.5,9.1045111895147883,"OK",null,"2014-09-16"]
[49,58,67,200,-9,9,62.5,9.4888091982081715,"OK",null,"2014-09-17"]
[50,50,53,200,-3,3,51.5,9.7955890073032368,"OK",null,"2014-09-23"]
[51,31,34,200,-3,3,32.5,9.1801470576456445,"OK",null,"2014-09-29"]
[52,53,56,200,-3,3,54.5,9.7602293005851042,"OK",null,"2014-10-01"]
[53,58,58,200,0,0,58,9.6737467405344031,"OK",null,"2014-10-08"]
[54,46,47,200,-1,1,46.5,9.7759605154685438,"OK",null,"2014-10-14"]
[55,25,27,200,-2,2,26,8.5972311821888319,"OK",null,"2014-10-20"]
[56,33,42,200,-9,9,37.5,9.4888091982081715,"OK",null,"2014-10-22"]
[57,71,68,200,3,3,69.5,9.0239855939601323,"OK",null,"2014-11-03"]
[58,72,75,200,-3,3,73.5,8.650130866062085,"OK",null,"2014-11-04"]
[59,52,58,200,-6,6,55,9.7508768836448745,"OK",null,"2014-11-05"]
[60,62,56,200,6,6,59,9.6399327798486247,"OK",null,"2014-11-11"]
[61,41,37,200,4,4,39,9.5598987442336441,"OK",null,"2014-11-18"]
[62,50,55,200,-5,5,52.5,9.7877423341647063,"OK",null,"2014-11-19"]
[63,62,70,200,-8,8,66,9.2846919173443769,"OK",null,"2014-12-09"]
[64,51,57,200,-6,6,54,9.7685896627916566,"OK",null,"2015-01-12"]
[65,25,29,200,-4,4,27,8.7016053691258612,"OK",null,"2015-01-13"]
[66,32,34,200,-2,2,33,9.2161692692788577,"OK",null,"2015-01-19"]
[67,46,37,200,9,9,41.5,9.6573518109262224,"OK",null,"2015-02-02"]
[68,47,44,200,3,3,45.5,9.7602293005851042,"OK",null,"2015-02-09"]
[69,53,54,200,-1,1,53.5,9.7759605154685438,"OK",null,"2015-02-10"]
[70,43,50,200,-7,7,46.5,9.7759605154685438,"OK",null,"2015-02-11"]
[71,35,43,200,-8,8,39,9.5598987442336441,"OK",null,"2015-02-18"]
[72,52,50,200,2,2,51,9.7980398039607906,"OK",null,"2015-02-24"]
[73,57,65,200,-8,8,61,9.5598987442336441,"OK",null,"2015-03-03"]
[74,60,57,200,3,3,58.5,9.6573518109262224,"OK",null,"2015-03-09"]
[75,37,38,200,-1,1,37.5,9.4888091982081715,"OK",null,"2015-03-11"]
[76,47,54,200,-7,7,50.5,9.7995099877493868,"OK",null,"2015-03-16"]
[77,62,53,200,9,9,57.5,9.6891227673097422,"OK",null,"2015-03-18"]
[78,51,51,200,0,0,51,9.7980398039607906,"OK",null,"2015-03-24"]
[79,55,55,200,0,0,55,9.7508768836448745,"OK",null,"2015-03-30"]
[80,84,77,200,7,7,80.5,7.7655338515777528,"OK",null,"2015-04-13"]
[81,57,54,200,3,3,55.5,9.7405295543928201,"OK",null,"2015-04-20"]
[82,35,37,200,-2,2,36,9.4079999999999995,"OK",null,"2015-04-21"]
[83,33,37,200,-4,4,35,9.3486041738860663,"OK",null,"2015-04-22"]
[84,46,49,200,-3,3,47.5,9.7877423341647063,"OK",null,"2015-04-27"]
[85,30,31,200,-1,1,30.5,9.0239855939601323,"OK",null,"2015-04-28"]
[86,58,58,200,0,0,58,9.6737467405344031,"OK",null,"2015-05-26"]
[87,48,51,200,-3,3,49.5,9.7995099877493868,"OK",null,"2015-06-22"]
[88,54,59,200,-5,5,56.5,9.716837139728133,"OK",null,"2015-06-29"]
[89,73,64,200,9,9,68.5,9.1045111895147883,"OK",null,"2015-07-13"]
[90,33,36,200,-3,3,34.5,9.317218254393314,"OK",null,"2015-07-21"]
[91,51,52,200,-1,1,51.5,9.7955890073032368,"OK",null,"2015-07-22"]
[92,44,49,200,-5,5,46.5,9.7759605154685438,"OK",null,"2015-07-27"]
[93,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-08-03"]
[94,54,54,200,0,0,54,9.7685896627916566,"OK",null,"2015-08-04"]
[95,57,60,200,-3,3,58.5,9.6573518109262224,"OK",null,"2015-08-11"]
[96,56,64,200,-8,8,60,9.6019997917100568,"OK",null,"2015-08-12"]
[97,57,64,200,-7,7,60.5,9.5814735818662058,"OK",null,"2015-09-07"]
[98,65,58,200,7,7,61.5,9.5372681623198581,"OK",null,"2015-09-15"]
[99,52,52,200,0,0,52,9.7921568614886887,"OK",null,"2015-09-16"]
[100,54,50,200,4,4,52,9.7921568614886887,"OK",null,"2015-09-21"]
[101,62,59,200,3,3,60.5,9.5814735818662058,"OK",null,"2015-09-28"]
[102,65,70,200,-5,5,67.5,9.1801470576456445,"OK",null,"2015-10-05"]
[103,70,70,200,0,0,70,8.9818483621134462,"OK",null,"2015-10-06"]
[104,64,68,200,-4,4,66,9.2846919173443769,"OK",null,"2015-10-12"]
[105,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-10-13"]
[106,35,37,200,-2,2,36,9.4079999999999995,"OK",null,"2015-10-13"]
[107,54,53,200,1,1,53.5,9.7759605154685438,"OK",null,"2015-10-14"]
[108,67,59,200,8,8,63,9.4629644403854751,"OK",null,"2015-10-19"]
[109,38,44,200,-6,6,41,9.6399327798486247,"OK",null,"2015-10-20"]
[110,65,73,200,-8,8,69,9.0648675666001868,"OK",null,"2015-10-26"]
[111,71,64,200,7,7,67.5,9.1801470576456445,"OK",null,"2015-10-27"]
[112,37,38,200,-1,1,37.5,9.4888091982081715,"OK",null,"2015-10-28"]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[125,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[126,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[127,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"n=",{"$f":"COUNT(B2:B130)","v":112}]
[null,null,null,"MW diff=",{"$f":"AVERAGE(E2:E128)","v":-0.20689655172413793}]
[null,null,null,"Median=",{"$f":"MEDIAN(E2:E128)","v":0}]
[null,null,null,"s(diff)=",{"$f":"STDEV(E2:E128)","v":5.1474218812904784}]
[null,null,null,"Prüfgröße=",{"$f":"1.96*E134/SQRT(E131)","v":0.95331587337187906}]
[]
[]
[]
[null,"MW diff soll kleiner sein als die Prüfgröße"]

{"sheet":"Morphologie Normalformen","index":5,"n_rows":134,"n_cols":11,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["Nr.","Morph N1","Morph N2","Anzahl N der\ndifferen-zierten Zellen","diff","Betrag der diff","MW","1.96x sqrt","Frei-gabe",null,"Datum"]
[1,20,24,200,{"$f":"B2-C2","v":-4},{"$f":"ABS(C2-B2)","v":4},{"$f":"AVERAGE(B2:C2)","v":22},{"$f":"1.96*SQRT(2*G2*(100-G2)/D2)","v":8.1192275494655277},{"$f":"IF(OR(F2>H2),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-15"]
[2,16,18,200,{"$f":"B3-C3","v":-2},{"$f":"ABS(C3-B3)","v":2},{"$f":"AVERAGE(B3:C3)","v":17},{"$f":"1.96*SQRT(2*G3*(100-G3)/D3)","v":7.3624028686292355},{"$f":"IF(OR(F3>H3),\"!!!!!!\",\"OK\")","v":"OK"},null,"2014-01-20"]
[3,8,4,200,4,4,{"$f":"AVERAGE(B4:C4)","v":6},4.654742098118863,"OK",null,"2014-01-21"]
[4,4,4,200,0,0,{"$f":"AVERAGE(B5:C5)","v":4},3.840799916684023,"OK",null,"2014-01-22"]
[5,18,18,200,0,0,{"$f":"AVERAGE(B6:C6)","v":18},7.5300741032210299,"OK",null,"2014-02-03"]
[6,17,14,200,3,3,15.5,7.0933317982454485,"OK",null,"2014-02-11"]
[7,20,18,200,2,2,19,7.6890977364057482,"OK",null,"2014-02-12"]
[8,19,21,200,-2,2,20,7.84,"OK",null,"2014-02-17"]
[9,8,11,200,-3,3,9.5,5.7470127892671341,"OK",null,"2014-02-18"]
[10,10,10,200,0,0,10,5.88,"OK",null,"2014-02-24"]
[11,18,21,200,-3,3,19.5,7.7655338515777528,"OK",null,"2014-02-25"]
[12,14,10,200,4,4,12,6.3692461092345924,"OK",null,"2014-03-05"]
[13,22,27,200,-5,5,24.5,8.4297091290269321,"OK",null,"2014-03-10"]
[14,7,4,200,3,3,5.5,4.4684131411497754,"OK",null,"2014-03-12"]
[15,25,18,200,7,7,21.5,8.0521179822454165,"OK",null,"2014-03-18"]
[16,29,26,200,3,3,27.5,8.7516798387509578,"OK",null,"2014-03-19"]
[17,19,23,200,-4,4,21,7.9832414469311903,"OK",null,"2014-04-30"]
[18,19,23,200,-4,4,21,7.9832414469311903,"OK",null,"2014-04-30"]
[19,22,24,200,-2,2,23,8.248317161700319,"OK",null,"2014-05-06"]
[20,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2014-05-07"]
[21,4,7,200,-3,3,5.5,4.4684131411497754,"OK",null,"2014-05-13"]
[22,21,23,200,-2,2,22,8.1192275494655277,"OK",null,"2014-05-14"]
[23,17,15,200,2,2,16,7.1854786896907568,"OK",null,"2014-05-20"]
[24,6,5,200,1,1,5.5,4.4684131411497754,"OK",null,"2014-05-21"]
[25,4,8,200,-4,4,6,4.654742098118863,"OK",null,"2014-05-26"]
[26,16,23,200,-7,7,19.5,7.7655338515777528,"OK",null,"2014-05-27"]
[27,17,20,200,-3,3,18.5,7.6106322996187377,"OK",null,"2014-05-28"]
[28,22,28,200,-6,6,25,8.4870489570874987,"OK",null,"2014-06-03"]
[29,29,35,200,-6,6,32,9.1429325711174325,"OK",null,"2014-06-04"]
[30,22,26,200,-4,4,24,8.3708293495925474,"OK",null,"2014-06-10"]
[31,4,7,200,-3,3,5.5,4.4684131411497754,"OK",null,"2014-06-17"]
[32,15,20,200,-5,5,17.5,7.4473552352496251,"OK",null,"2014-06-18"]
[33,9,15,200,-6,6,12,6.3692461092345924,"OK",null,"2014-07-08"]
[34,11,8,200,3,3,9.5,5.7470127892671341,"OK",null,"2014-07-16"]
[35,18,15,200,3,3,16.5,7.2751387615632463,"OK",null,"2014-07-17"]
[36,5,5,200,0,0,5,4.2717209646698606,"OK",null,"2014-07-22"]
[37,7,11,200,-4,4,9,5.60916250433164,"OK",null,"2014-07-23"]
[38,22,26,200,-4,4,24,8.3708293495925474,"OK",null,"2014-07-28"]
[39,20,26,200,-6,6,23,8.248317161700319,"OK",null,"2014-07-30"]
[40,8,13,200,-5,5,10.5,6.0084470539399781,"OK",null,"2014-08-05"]
[41,2,4,200,-2,2,3,3.3435095334094682,"OK",null,"2014-08-06"]
[42,4,3,200,1,1,3.5,3.6020832860998646,"OK",null,"2014-08-11"]
[43,20,17,200,3,3,18.5,7.6106322996187377,"OK",null,"2014-09-01"]
[44,28,33,200,-5,5,30.5,9.0239855939601323,"OK",null,"2014-09-02"]
[45,27,23,200,4,4,25,8.4870489570874987,"OK",null,"2014-09-09"]
[46,20,25,200,-5,5,22.5,8.184613613360133,"OK",null,"2014-09-11"]
[47,10,8,200,2,2,9,5.60916250433164,"OK",null,"2014-09-15"]
[48,10,8,200,2,2,9,5.60916250433164,"OK",null,"2014-09-16"]
[49,17,17,200,0,0,17,7.3624028686292355,"OK",null,"2014-09-17"]
[50,9,12,200,-3,3,10.5,6.0084470539399781,"OK",null,"2014-09-23"]
[51,13,8,200,5,5,10.5,6.0084470539399781,"OK",null,"2014-09-29"]
[52,7,9,200,-2,2,8,5.31734670677021,"OK",null,"2014-10-01"]
[53,8,11,200,-3,3,9.5,5.7470127892671341,"OK",null,"2014-10-08"]
[54,9,7,200,2,2,8,5.31734670677021,"OK",null,"2014-10-14"]
[55,21,25,200,-4,4,23,8.248317161700319,"OK",null,"2014-10-20"]
[56,21,26,200,-5,5,23.5,8.3103768867603112,"OK",null,"2014-10-22"]
[57,4,2,200,2,2,3,3.3435095334094682,"OK",null,"2014-11-03"]
[58,5,10,200,-5,5,7.5,5.1624703388978412,"OK",null,"2014-11-04"]
[59,11,8,200,3,3,9.5,5.7470127892671341,"OK",null,"2014-11-05"]
[60,12,8,200,4,4,10,5.88,"OK",null,"2014-11-18"]
[61,17,15,200,2,2,16,7.1854786896907568,"OK",null,"2014-11-19"]
[62,8,13,200,-5,5,10.5,6.0084470539399781,"OK",null,"2014-11-11"]
[63,15,21,200,-6,6,18,7.5300741032210299,"OK",null,"2014-12-09"]
[64,4,8,200,-4,4,6,4.654742098118863,"OK",null,"2015-01-12"]
[65,22,29,200,-7,7,25.5,8.5428798423014243,"OK",null,"2015-01-13"]
[66,14,18,200,-4,4,16,7.1854786896907568,"OK",null,"2015-01-19"]
[67,3,2,200,1,1,2.5,3.060049019215215,"OK",null,"2015-02-02"]
[68,7,12,200,-5,5,9.5,5.7470127892671341,"OK",null,"2015-02-09"]
[69,8,12,200,-4,4,10,5.88,"OK",null,"2015-02-10"]
[70,23,19,200,4,4,21,7.9832414469311903,"OK",null,"2015-02-11"]
[71,28,34,200,-6,6,31,9.0648675666001868,"OK",null,"2015-02-18"]
[72,21,25,200,-4,4,23,8.248317161700319,"OK",null,"2015-02-24"]
[73,8,12,200,-4,4,10,5.88,"OK",null,"2015-03-03"]
[74,8,5,200,3,3,6.5,4.8319068699634515,"OK",null,"2015-03-09"]
[75,16,19,200,-3,3,17.5,7.4473552352496251,"OK",null,"2015-03-11"]
[76,17,22,200,-5,5,19.5,7.7655338515777528,"OK",null,"2015-03-16"]
[77,17,21,200,-4,4,19,7.6890977364057482,"OK",null,"2015-03-18"]
[78,3,5,200,-2,2,4,3.840799916684023,"OK",null,"2015-03-30"]
[79,9,6,200,3,3,7.5,5.1624703388978412,"OK",null,"2015-04-13"]
[80,17,22,200,-5,5,19.5,7.7655338515777528,"OK",null,"2015-04-20"]
[81,24,20,200,4,4,22,8.1192275494655277,"OK",null,"2015-04-21"]
[82,23,20,200,3,3,21.5,8.0521179822454165,"OK",null,"2015-04-22"]
[83,19,16,200,3,3,17.5,7.4473552352496251,"OK",null,"2015-04-27"]
[84,20,25,200,-5,5,22.5,8.184613613360133,"OK",null,"2015-04-28"]
[85,24,28,200,-4,4,26,8.5972311821888319,"OK",null,"2015-05-26"]
[86,14,10,200,4,4,12,6.3692461092345924,"OK",null,"2015-06-22"]
[87,14,8,200,6,6,11,6.1326392360875097,"OK",null,"2015-06-29"]
[88,6,10,200,-4,4,8,5.31734670677021,"OK",null,"2015-07-13"]
[89,19,22,200,-3,3,20.5,7.9125518007783038,"OK",null,"2015-07-21"]
[90,5,7,200,-2,2,6,4.654742098118863,"OK",null,"2015-07-22"]
[91,17,16,200,1,1,16.5,7.2751387615632463,"OK",null,"2015-07-27"]
[92,20,25,200,-5,5,22.5,8.184613613360133,"OK",null,"2015-08-04"]
[93,4,7,200,-3,3,5.5,4.4684131411497754,"OK",null,"2015-08-11"]
[94,12,9,200,3,3,10.5,6.0084470539399781,"OK",null,"2015-08-12"]
[95,17,20,200,-3,3,18.5,7.6106322996187377,"OK",null,"2015-09-07"]
[96,19,22,200,-3,3,20.5,7.9125518007783038,"OK",null,"2015-09-15"]
[97,15,19,200,-4,4,17,7.3624028686292355,"OK",null,"2015-09-16"]
[98,12,10,200,2,2,11,6.1326392360875097,"OK",null,"2015-09-21"]
[99,23,26,200,-3,3,24.5,8.4297091290269321,"OK",null,"2015-10-05"]
[100,27,23,200,4,4,25,8.4870489570874987,"OK",null,"2015-10-06"]
[101,7,9,200,-2,2,8,5.31734670677021,"OK",null,"2015-10-12"]
[102,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"2015-10-13"]
[103,19,16,200,3,3,17.5,7.4473552352496251,"OK",null,"2015-10-13"]
[104,14,19,200,-5,5,16.5,7.2751387615632463,"OK",null,"2015-10-14"]
[105,16,12,200,4,4,14,6.8009458165758083,"OK",null,"2015-10-19"]
[106,9,13,200,-4,4,11,6.1326392360875097,"OK",null,"2015-10-20"]
[107,7,10,200,-3,3,8.5,5.4660812288146614,"OK",null,"2015-10-26"]
[108,13,16,200,-3,3,14.5,6.9011764214516358,"OK",null,"2015-10-27"]
[109,13,9,200,4,4,11,6.1326392360875097,"OK",null,"2015-10-28"]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[123,null,null,null,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,"n=",{"$f":"COUNT(B2:B126)","v":109}]
[null,null,null,"MW diff=",{"$f":"AVERAGE(E2:E124)","v":-1.2432432432432432}]
[null,null,null,"Median=",{"$f":"MEDIAN(E2:E124)","v":-2}]
[null,null,null,"s(diff)=",{"$f":"STDEV(E2:E124)","v":3.5348041381157591}]
[null,null,null,"Prüfgröße=",{"$f":"1.96*E130/SQRT(E127)","v":0.66360275005277114}]
[]
[]
[null,"MW diff soll kleiner sein als die Prüfgröße"]