{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Gesamt","Reproduzierbarkeit","Methoden- und Laborbias","s aus Spannw","m und s aus Daten","Kombination","a"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gesamt","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,0,0,6],[1,0,1,2],[1,3,1,6],[2,1,2,6],[3,1,3,6],[4,0,4,3],[4,4,4,6],[5,0,5,6],[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,1,9,2],[9,4,10,6],[10,1,10,2],[11,0,11,6],[12,0,12,3],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,0,17,3],[18,0,18,3],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,0,23,3],[24,0,24,4],[25,0,25,2]]}
["Schätzung der Messunsicherheit",{"$nulls":6},"v2.31 abs"]
["für die Bestimmung von"]
["in"]
["mittels"]
["für den Konzentrationsbereich:"]
["basierend auf"]
["DIN ISO 11352:2013 Wasserbeschaffenheit — Abschätzung der Messunsicherheit beruhende"]
["auf Validierungs- und Kontrolldaten"]
[]
["berechnet von:"]
["Datum:",null,null,"Unterschrift:"]
[]
["Reproduzierbarkeit innerhalb de Labors",{"$nulls":3},"uRw"]
["Nr.","Unsicherheitsbeitrag",{"$nulls":3},"Standard-unsicherheit"]
[1]
[2]
[3]
["Kombinierte Unsicherheitskomponente",{"$nulls":3},"uRw",{"$f":"IF(COUNT(F15:F17)<>0,SQRT(SUMSQ(F15:F17)),\"\")","v":""}]
["Methoden- und Laborbias",{"$nulls":3},"ub"]
["Nr.","Unsicherheitsbeitrag",{"$nulls":3},"Standard-unsicherheit"]
[1]
[2]
[3]
["Kombinierte Unsicherheitskomponente u",{"$nulls":3},"ub",{"$f":"IF(COUNT(F21:F23)<>0,SQRT(SUMSQ(F21:F23)),\"\")","v":""}]
["Gesamte kombinierte Standardunsicherheit",{"$nulls":4},{"$f":"IF(AND(F18<>\"\",F24<>\"\"),SQRT(F18*F18+F24*F24),\"\")","v":""}]
["Erweiterte Unsicherheit",null,null,"k-Faktor",null,{"$f":"IF(AND(F25<>\"\",E26<>\"\"),E26*F25,\"\")","v":""}]
["© 2015 Dr. M. Koch, Institut für Siedlungswasserbau, Universität Stuttgart, www.aqsbw.de"]
["Die Benutzung dieses EXCEL-Blattes ist kostenfrei, solange der Copyright-Vermerk nicht entfernt wird."]

{"sheet":"Reproduzierbarkeit","index":1,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[0,0,0,3],[1,0,1,6],[2,0,2,1],[2,3,2,6],[4,1,4,7],[7,0,7,6],[9,0,9,1],[9,3,9,6],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,5,14,7],[16,1,16,7],[21,0,21,3],[22,0,22,3],[23,0,23,3],[26,2,26,6],[27,5,27,7],[29,1,29,7]]}
["Reproduzierbarkeit innerhalb des Labors",{"$nulls":3},"uRw"]
["A) Kontrollprobe, die den gesamten Analysenprozess abdeckt"]
["Standardabweichung:",null,null,"übertragen in Blatt \"Gesamt\""]
[]
["Bem.:"]
[]
[]
["B) Kontrollprobe, die nicht den gesamten Analysenprozess abdeckt"]
["B.1 Ergebnis der Kontrollprobe"]
["Standardabweichung:"]
["B.2 Komponente aus wechselnden Matrizes und Konzentrationen (aus Spannweiten)"]
["Mittlere Spannweite:",{"$nulls":4},"Blatt \"s aus Spannw\", Zelle M3"]
["Anzahl der Messungen für die Spannweiten (2, 3, 4 or 5)"]
["Standardabweichung:",{"$nulls":3},{"$f":"IF(E12<>\"\",IF(E13=\"2\",E12/1.128,IF(E13=\"3\",E12/1.693,IF(E13=\"4\",E12/2.059,IF(E13=\"5\",E12/2.326,\"\")))),\"\")","v":""}]
["Kombination:",{"$nulls":3},{"$f":"IF(AND(C10<>\"\",E14<>\"\"),SQRT(C10*C10+E14*E14),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["Bem.:"]
[]
[]
["C) Instabile Kontrollproben"]
["C.1 Wiederholbarkeit"]
["Mittlere Spannweite:",{"$nulls":4},"Blatt \"s aus Spannw\", Zelle M3"]
["Anzahl der Messungen für die Spannweiten (2, 3, 4 or 5)"]
["Standardabweichung:",{"$nulls":3},{"$f":"IF(E22<>\"\",IF(E23=\"2\",E22/1.128,IF(E23=\"3\",E22/1.693,IF(E23=\"4\",E22/2.059,IF(E23=\"5\",E22/2.326,\"\")))),\"\")","v":""}]
["C.2 \"Langzeit\"-Komponente"]
["Schätzwert für die Standardabweichung"]
["basierend auf"]
["Kombination:",{"$nulls":3},{"$f":"IF(AND(E24<>\"\",E26<>\"\"),SQRT(E24*E24+E26*E26),\"\")","v":""},"übertragen in Blatt \"Gesamt\""]
[]
["Bem.:"]

{"sheet":"Methoden- und Laborbias","index":2,"n_rows":89,"n_cols":8,"rows_kept":89,"merged":[[0,0,0,3],[1,0,1,6],[2,6,9,7],[10,4,10,6],[12,0,12,6],[14,6,23,7],[24,3,24,5],[26,0,26,6],[29,6,41,7],[60,3,60,5],[62,0,62,6],[75,6,87,7],[88,3,88,5]]}
["Methoden- und Laborbias",{"$nulls":3},"ub"]
["A) Mehrfache Analytik eines zertifizierten Referenzmaterials"]
["Zertifizierter Wert:",null,null,"unit:",null,"Bem.:"]
["Konfidenzintervall:     +/-"]
["Konfidenzniveau:"]
["Standardunsicherheit:",null,null,{"$f":"IF(AND(C3<>\"\",C4<>\"\"),IF(C5=\"1 s\",C4,IF(C5=\"95%\",C4/1.96,IF(C5=\"2 s\",C4/2,IF(C5=\"99%\",C4/2.58,IF(C5=\"3 s\",C4/3,\"\"))))),\"\")","v":""}]
["Mittelwert der ZRM-Analytik:",{"$nulls":3},{"$f":"IF(E3<>\"\",E3,\"\")","v":""}]
["Mittlere Abweichung:",null,null,{"$f":"IF(AND(D7<>\"\",C3<>\"\"),D7-C3,\"\")","v":""}]
["Std.-Abweichung der ZRM-Analytik:",{"$nulls":3},{"$f":"IF(E3<>\"\",E3,\"\")","v":""}]
["Anzahl der Messungen:"]
["Standardunsicherheit:",null,null,{"$f":"IF(AND(D8<>\"\",AND(D9<>\"\",AND(D10<>\"\",D6<>\"\"))),SQRT(D8*D8+(D9*D9/D10)+D6*D6),\"\")","v":""},"übertragen in Blatt \"Gesamt\""]
[]
["B) Mehrfache Analytik mehrerer zertifzierter Referenzmaterialien"]
[null,"zert. Wert","Konf.-intervall","Konf.-niveau","Mittelwert"]
["ZRM 1",{"$nulls":4},"Bem.:"]
["ZRM 2"]
["ZRM 3"]
["ZRM 4"]
[null,"u(cref)",null,"Abweichung","quadr. Abw."]
["ZRM 1",{"$f":"IF(AND(B15<>\"\",C15<>\"\"),IF(D15=\"1 s\",C15,IF(D15=\"95%\",C15/1.96,IF(D15=\"2 s\",C15/2,IF(D15=\"99%\",C15/2.58,IF(D15=\"3 s\",C15/3,\"\"))))),\"\")","v":""},null,{"$f":"IF(AND(E15<>\"\",B15<>\"\"),(E15-B15),\"\")","v":""},{"$f":"IF(D20<>\"\",D20*D20,\"\")","v":""}]
["ZRM 2",{"$f":"IF(AND(B16<>\"\",C16<>\"\"),IF(D16=\"1 s\",C16,IF(D16=\"95%\",C16/1.96,IF(D16=\"2 s\",C16/2,IF(D16=\"99%\",C16/2.58,IF(D16=\"3 s\",C16/3,\"\"))))),\"\")","v":""},null,{"$f":"IF(AND(E16<>\"\",B16<>\"\"),(E16-B16),\"\")","v":""},{"$f":"IF(D21<>\"\",D21*D21,\"\")","v":""}]
["ZRM 3",{"$f":"IF(AND(B17<>\"\",C17<>\"\"),IF(D17=\"1 s\",C17,IF(D17=\"95%\",C17/1.96,IF(D17=\"2 s\",C17/2,IF(D17=\"99%\",C17/2.58,IF(D17=\"3 s\",C17/3,\"\"))))),\"\")","v":""},null,{"$f":"IF(AND(E17<>\"\",B17<>\"\"),(E17-B17),\"\")","v":""},{"$f":"IF(D22<>\"\",D22*D22,\"\")","v":""}]
["ZRM 4",{"$f":"IF(AND(B18<>\"\",C18<>\"\"),IF(D18=\"1 s\",C18,IF(D18=\"95%\",C18/1.96,IF(D18=\"2 s\",C18/2,IF(D18=\"99%\",C18/2.58,IF(D18=\"3 s\",C18/3,\"\"))))),\"\")","v":""},null,{"$f":"IF(AND(E18<>\"\",B18<>\"\"),(E18-B18),\"\")","v":""},{"$f":"IF(D23<>\"\",D23*D23,\"\")","v":""}]
["Mittelwert:",{"$f":"IF(B20<>\"\",AVERAGE(B20:B23),\"\")","v":""},"bRMS",{"$f":"IF(E20<>\"\",SQRT(SUM(E20:E23)/COUNT(E20:E23)),\"\")","v":""}]
["Standardunsicherheit:",null,{"$f":"IF(AND(B24<>\"\",D24<>\"\"),SQRT(B24*B24+D24*D24),\"\")","v":""},"übertragen in Blatt \"Gesamt\""]
[]
["C) Ringversuche"]
["Eigene Ergebnisse"]
[null,"Vorgabewert","Ergebnis","Abweichung","quadr. Abw."]
["Probe 1",null,null,{"$f":"IF(AND(C30<>\"\",B30<>\"\"),(C30-B30),\"\")","v":""},{"$f":"IF(D30<>\"\",D30*D30,\"\")","v":""},"Bem.:"]
["Probe 2",null,null,"",""]
["Probe 3",null,null,"",""]
["Probe 4",null,null,"",""]
["Probe 5",null,null,"",""]
["Probe 6",null,null,"",""]
["Probe 7",null,null,"",""]
["Probe 8",null,null,"",""]
["Probe 9",null,null,"",""]
["Probe 10",null,null,"",""]
["Probe 11",null,null,"",""]
["Probe 12",null,null,"",""]
[{"$nulls":3},"bRMS",{"$f":"IF(E30<>\"\",SQRT(SUM(E30:E41)/COUNT(E30:E41)),\"\")","v":""}]
["Unsicherheit des Vorgabewerts"]
[]
[null,null,2]
[null,"sR","Anzahl Werte","u(cref)",null,"Uns.","Konf.-niv.","u(cref)"]
["Probe 1",null,null,{"$f":"IF(AND(B47<>\"\",C47<>\"\"),IF($C$45=1,1.25*B47/SQRT(C47),B47/SQRT(C47)),\"\")","v":""},{"$nulls":3},{"$f":"IF(F47<>\"\",IF(G47=\"1 s\",F47,IF(G47=\"95%\",F47/1.96,IF(G47=\"2 s\",F47/2,IF(G47=\"99%\",F47/2.58,IF(G47=\"3 s\",F47/3,\"\"))))),\"\")","v":""}]
["Probe 2",null,null,"",{"$nulls":3},{"$f":"IF(F48<>\"\",IF(G48=\"1 s\",F48,IF(G48=\"95%\",F48/1.96,IF(G48=\"2 s\",F48/2,IF(G48=\"99%\",F48/2.58,IF(G48=\"3 s\",F48/3,\"\"))))),\"\")","v":""}]
["Probe 3",null,null,"",{"$nulls":3},""]
["Probe 4",null,null,"",{"$nulls":3},""]
["Probe 5",null,null,"",{"$nulls":3},""]
["Probe 6",null,null,"",{"$nulls":3},""]
["Probe 7",null,null,"",{"$nulls":3},""]
["Probe 8",null,null,"",{"$nulls":3},""]
["Probe 9",null,null,"",{"$nulls":3},""]
["Probe 10",null,null,"",{"$nulls":3},""]
["Probe 11",null,null,"",{"$nulls":3},""]
["Probe 12",null,null,"",{"$nulls":3},""]
[null,null,"Mittelwert",{"$f":"IF(D47<>\"\",AVERAGE(D47:D58),\"\")","v":""},null,null,"Mittelwert",{"$f":"IF(H47<>\"\",AVERAGE(H47:H58),\"\")","v":""}]
[]
["Standardunsicherheit:",null,{"$f":"IF(E42<>\"\",    IF(D59<>\"\", SQRT(E42^2+D59^2), IF(H59<>\"\",  SQRT(E42^2+H59^2),\"\")                    ),\"\")","v":""},"übertragen in Blatt \"Gesamt\""]
[]
["D) Wiederfindungsexperiment"]
["Unsicherheit der Konzentration der Aufstocklösung:"]
["Konzentration der Aufstocklösung:"]
["Konfidenzintervall     +/-"]
["Konfidenzniveu:"]
[null,null,"uconc",{"$f":"IF(AND(D65<>\"\",D66<>\"\"),IF(D67=\"1 s\",D66,IF(D67=\"95%\",D66/1.96,IF(D67=\"2 s\",D66/2,IF(D67=\"99%\",D66/2.58,IF(D67=\"3 s\",D66/3,\"\"))))),\"\")","v":""}]
["Unsicherheit des zugegebenen Volumens:"]
["max. Abweichung (Rechteckverteilung)",{"$nulls":4},"Std-Abw.:",{"$f":"IF(E70<>\"\",E70/SQRT(3),\"\")","v":""}]
["Wiederholbarkeit (als Standardabweichung)"]
[{"$nulls":3},"uV",{"$f":"IF(AND(E70<>\"\",E71<>\"\"),SQRT(G70*G70+E71*E71),\"\")","v":""}]
["Unsicherheit der Aufstockung",null,null,"uadd",{"$f":"IF(AND(D68<>\"\",E72<>\"\"),SQRT(D68*D68+E72*E72),\"\")","v":""}]
["Wiederfindung:"]
[null,"Aufstockung","Abweichung","quadr. Abw."]
[1,null,null,{"$f":"IF(C76<>\"\",C76*C76,\"\")","v":""},null,"Bem.:"]
[2,null,null,{"$f":"IF(C77<>\"\",C77*C77,\"\")","v":""}]
[3,null,null,""]
[4,null,null,""]
[5,null,null,""]
[6,null,null,""]
[7,null,null,""]
[8,null,null,""]
[9,null,null,""]
[10,null,null,""]
[11,null,null,""]
[12,null,null,""]
[null,null,"bRMS",{"$f":"IF(AND(B76<>\"\",C76<>\"\"),SQRT(SUM(D76:D87)/COUNT(D76:D87)),\"\")","v":""}]
["Standardunsicherheit:",null,{"$f":"IF(AND(E73<>\"\",D88<>\"\"),SQRT(E73*E73+D88*D88),\"\")","v":""},"übertragen in Blatt \"Gesamt\""]

{"sheet":"s aus Spannw","index":3,"n_rows":101,"n_cols":13,"rows_kept":101,"merged":[[7,11,19,12]]}
[null,"1. Wert","2. Wert","3. Wert","4. Wert","5. Wert",null,null,"Mittelwert","Spannweite","rel. Spannw."]
[1,{"$nulls":5},"Anzahl Messungen",{"$f":"IF(B2<>\"\",COUNT(B2:F2),\"\")","v":""},{"$f":"IF(B2<>\"\",AVERAGE(B2:F2),\"\")","v":""},{"$f":"IF(B2<>\"\",MAX(B2:F2)-MIN(B2:F2),\"\")","v":""},{"$f":"IF(B2<>\"\",J2/I2,\"\")","v":""},"Gesamtmittelwert",{"$f":"IF(I2<>\"\",AVERAGE(I2:I101),\"\")","v":""}]
[2,{"$nulls":5},"s (absolut)",{"$f":"IF(AND(B2<>\"\",H2<>\"\"),IF(H2=2,M3/1.128,IF(H2=3,M3/1.693,IF(H2=4,M3/2.059,IF(H2=5,M3/2.326,\"\")))),\"\")","v":""},{"$f":"IF(B3<>\"\",AVERAGE(B3:F3),\"\")","v":""},{"$f":"IF(B3<>\"\",MAX(B3:F3)-MIN(B3:F3),\"\")","v":""},{"$f":"IF(B3<>\"\",J3/I3,\"\")","v":""},"Mittlere Spannw.",{"$f":"IF(J2<>\"\",AVERAGE(J2:J101),\"\")","v":""}]
[3,{"$nulls":5},"s (relativ)",{"$f":"IF(H3<>\"\",IF(H2=2,M4/1.128,IF(H2=3,M4/1.693,IF(H2=4,M4/2.059,IF(H2=5,M4/2.326,\"\")))),\"\")","v":""},"","","","Mittlere rel. Spannw.",{"$f":"IF(K2<>\"\",AVERAGE(K2:K101),\"\")","v":""}]
[4,{"$nulls":7},"","",""]
[5,{"$nulls":7},"","",""]
[6,{"$nulls":7},{"$f":"IF(B7<>\"\",AVERAGE(B7:F7),\"\")","v":""},{"$f":"IF(B7<>\"\",MAX(B7:F7)-MIN(B7:F7),\"\")","v":""},{"$f":"IF(B7<>\"\",J7/I7,\"\")","v":""},"Bem.:"]
[7,{"$nulls":7},"","",""]
[8,{"$nulls":7},"","",""]
[9,{"$nulls":7},"","",""]
[10,{"$nulls":7},"","",""]
[11,{"$nulls":7},"","",""]
[12,{"$nulls":7},"","",""]
[13,{"$nulls":7},"","",""]
[14,{"$nulls":7},"","",""]
[15,{"$nulls":7},"","",""]
[16,{"$nulls":7},"","",""]
[17,{"$nulls":7},"","",""]
[18,{"$nulls":7},"","",""]
[19,{"$nulls":7},"","",""]
[20,{"$nulls":7},"","",""]
[21,{"$nulls":7},"","",""]
[22,{"$nulls":7},"","",""]
[23,{"$nulls":7},"","",""]
[24,{"$nulls":7},"","",""]
[25,{"$nulls":7},"","",""]
[26,{"$nulls":7},"","",""]
[27,{"$nulls":7},"","",""]
[28,{"$nulls":7},"","",""]
[29,{"$nulls":7},"","",""]
[30,{"$nulls":7},"","",""]
[31,{"$nulls":7},"","",""]
[32,{"$nulls":7},"","",""]
[33,{"$nulls":7},"","",""]
[34,{"$nulls":7},"","",""]
[35,{"$nulls":7},"","",""]
[36,{"$nulls":7},"","",""]
[37,{"$nulls":7},"","",""]
[38,{"$nulls":7},"","",""]
[39,{"$nulls":7},"","",""]
[40,{"$nulls":7},"","",""]
[41,{"$nulls":7},"","",""]
[42,{"$nulls":7},"","",""]
[43,{"$nulls":7},"","",""]
[44,{"$nulls":7},"","",""]
[45,{"$nulls":7},"","",""]
[46,{"$nulls":7},"","",""]
[47,{"$nulls":7},"","",""]
[48,{"$nulls":7},"","",""]
[49,{"$nulls":7},"","",""]
[50,{"$nulls":7},"","",""]
[51,{"$nulls":7},"","",""]
[52,{"$nulls":7},"","",""]
[53,{"$nulls":7},"","",""]
[54,{"$nulls":7},"","",""]
[55,{"$nulls":7},"","",""]
[56,{"$nulls":7},"","",""]
[57,{"$nulls":7},"","",""]
[58,{"$nulls":7},"","",""]
[59,{"$nulls":7},"","",""]
[60,{"$nulls":7},"","",""]
[61,{"$nulls":7},"","",""]
[62,{"$nulls":7},"","",""]
[63,{"$nulls":7},"","",""]
[64,{"$nulls":7},"","",""]
[65,{"$nulls":7},"","",""]
[66,{"$nulls":7},{"$f":"IF(B67<>\"\",AVERAGE(B67:F67),\"\")","v":""},{"$f":"IF(B67<>\"\",MAX(B67:F67)-MIN(B67:F67),\"\")","v":""},{"$f":"IF(B67<>\"\",J67/I67,\"\")","v":""}]
[67,{"$nulls":7},"","",""]
[68,{"$nulls":7},"","",""]
[69,{"$nulls":7},"","",""]
[70,{"$nulls":7},"","",""]
[71,{"$nulls":7},"","",""]
[72,{"$nulls":7},"","",""]
[73,{"$nulls":7},"","",""]
[74,{"$nulls":7},"","",""]
[75,{"$nulls":7},"","",""]
[76,{"$nulls":7},"","",""]
[77,{"$nulls":7},"","",""]
[78,{"$nulls":7},"","",""]
[79,{"$nulls":7},"","",""]
[80,{"$nulls":7},"","",""]
[81,{"$nulls":7},"","",""]
[82,{"$nulls":7},"","",""]
[83,{"$nulls":7},"","",""]
[84,{"$nulls":7},"","",""]
[85,{"$nulls":7},"","",""]
[86,{"$nulls":7},"","",""]
[87,{"$nulls":7},"","",""]
[88,{"$nulls":7},"","",""]
[89,{"$nulls":7},"","",""]
[90,{"$nulls":7},"","",""]
[91,{"$nulls":7},"","",""]
[92,{"$nulls":7},"","",""]
[93,{"$nulls":7},"","",""]
[94,{"$nulls":7},"","",""]
[95,{"$nulls":7},"","",""]
[96,{"$nulls":7},"","",""]
[97,{"$nulls":7},"","",""]
[98,{"$nulls":7},"","",""]
[99,{"$nulls":7},"","",""]
[100,{"$nulls":7},"","",""]

{"sheet":"m und s aus Daten","index":4,"n_rows":101,"n_cols":4,"rows_kept":101,"merged":[[6,3,17,4]]}
[null,"Werte"]
[1,null,"Mittelwert:",{"$f":"IF(B2<>\"\",AVERAGE(B2:B101),\"\")","v":""}]
[2,null,"Standardabweichung:",{"$f":"IF(AND(B2<>\"\",B3<>\"\"),STDEV(B2:B101),\"\")","v":""}]
[3,null,"Rel. Standardabweichung:",{"$f":"IF(D3<>\"\",D3/D2,\"\")","v":""}]
[4]
[5]
[6,null,"Bem.:"]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[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":"Kombination","index":5,"n_rows":40,"n_cols":6,"rows_kept":40}
[]
[]
["Nr.","Beschreibung","Abweichung","Konfidenzniveau","Teiler","u"]
[1,{"$nulls":3},{"$f":"IF(AND(D4<>\"\",C4<>\"\"),IF(D4=\"1 s\",1,IF(D4=\"95%\",1.96,IF(D4=\"2 s\",2,IF(D4=\"99%\",2.58,IF(D4=\"3 s\",3,IF(D4=\"Rechteck\",1.732,IF(D4=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E4<>\"\",C4/E4,\"\")","v":""}]
[2,{"$nulls":3},{"$f":"IF(AND(D5<>\"\",C5<>\"\"),IF(D5=\"1 s\",1,IF(D5=\"95%\",1.96,IF(D5=\"2 s\",2,IF(D5=\"99%\",2.58,IF(D5=\"3 s\",3,IF(D5=\"Rechteck\",1.732,IF(D5=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E5<>\"\",C5/E5,\"\")","v":""}]
[3,{"$nulls":3},"",""]
[4,{"$nulls":3},"",""]
[5,{"$nulls":3},"",""]
[6,{"$nulls":3},"",""]
[7,{"$nulls":3},"",""]
[8,{"$nulls":3},"",""]
[9,{"$nulls":3},"",""]
[10,{"$nulls":3},"",""]
[{"$nulls":4},"Kombination:",{"$f":"IF(COUNT(F4:F13)<>0,SQRT(SUMSQ(F4:F13)),\"\")","v":""}]
[]
["Nr.","Beschreibung","Abweichung","Konfidenzniveau","Teiler","u"]
[1,{"$nulls":3},{"$f":"IF(AND(D17<>\"\",C17<>\"\"),IF(D17=\"1 s\",1,IF(D17=\"95%\",1.96,IF(D17=\"2 s\",2,IF(D17=\"99%\",2.58,IF(D17=\"3 s\",3,IF(D17=\"Rechteck\",1.732,IF(D17=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E17<>\"\",C17/E17,\"\")","v":""}]
[2,{"$nulls":3},{"$f":"IF(AND(D18<>\"\",C18<>\"\"),IF(D18=\"1 s\",1,IF(D18=\"95%\",1.96,IF(D18=\"2 s\",2,IF(D18=\"99%\",2.58,IF(D18=\"3 s\",3,IF(D18=\"Rechteck\",1.732,IF(D18=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E18<>\"\",C18/E18,\"\")","v":""}]
[3,{"$nulls":3},"",""]
[4,{"$nulls":3},"",""]
[5,{"$nulls":3},"",""]
[6,{"$nulls":3},"",""]
[7,{"$nulls":3},"",""]
[8,{"$nulls":3},"",""]
[9,{"$nulls":3},"",""]
[10,{"$nulls":3},"",""]
[{"$nulls":4},"Kombination:",{"$f":"IF(COUNT(F17:F26)<>0,SQRT(SUMSQ(F17:F26)),\"\")","v":""}]
[]
["Nr.","Beschreibung","Abweichung","Konfidenzniveau","Teiler","u"]
[1,{"$nulls":3},{"$f":"IF(AND(D30<>\"\",C30<>\"\"),IF(D30=\"1 s\",1,IF(D30=\"95%\",1.96,IF(D30=\"2 s\",2,IF(D30=\"99%\",2.58,IF(D30=\"3 s\",3,IF(D30=\"Rechteck\",1.732,IF(D30=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E30<>\"\",C30/E30,\"\")","v":""}]
[2,{"$nulls":3},{"$f":"IF(AND(D31<>\"\",C31<>\"\"),IF(D31=\"1 s\",1,IF(D31=\"95%\",1.96,IF(D31=\"2 s\",2,IF(D31=\"99%\",2.58,IF(D31=\"3 s\",3,IF(D31=\"Rechteck\",1.732,IF(D31=\"Dreieck\",2.449,\"\"))))))),\"\")","v":""},{"$f":"IF(E31<>\"\",C31/E31,\"\")","v":""}]
[3,{"$nulls":3},"",""]
[4,{"$nulls":3},"",""]
[5,{"$nulls":3},"",""]
[6,{"$nulls":3},"",""]
[7,{"$nulls":3},"",""]
[8,{"$nulls":3},"",""]
[9,{"$nulls":3},"",""]
[10,{"$nulls":3},"",""]
[{"$nulls":4},"Kombination:",{"$f":"IF(COUNT(F30:F39)<>0,SQRT(SUMSQ(F30:F39)),\"\")","v":""}]

{"sheet":"a","index":6,"n_rows":7,"n_cols":2,"rows_kept":7,"hidden":true}
[2,"1 s"]
[3,"95%"]
[4,"2 s"]
[5,"99%"]
[null,"3 s"]
[null,"Rechteck"]
[null,"Dreieck"]