{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["total","reproducibility","method and laboratory bias","s from range","m and s from data","combination","a"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"total","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]]}
["Estimation of measurement uncertainty",{"$nulls":6},"v2.31 abs"]
["for the determination of"]
["in"]
["using"]
["for the concentration range:"]
["on the basis of "]
["ISO DIS 11352:2010 Water quality — Determination of measurement uncertainty based on"]
["validation data"]
[]
["calculated by:"]
["Date:",null,null,"Signature:"]
[]
["Reproducibility within Laboratory",{"$nulls":3},"uRw"]
["No.","contribution",{"$nulls":3},"standard uncertainty"]
[1]
[2]
[3]
["Combined uncertainty component",{"$nulls":3},"uRw",{"$f":"IF(COUNT(F15:F17)<>0,SQRT(SUMSQ(F15:F17)),\"\")","v":""}]
["Method and Laboratory Bias",{"$nulls":3},"ubias"]
["No.","contribution",{"$nulls":3},"rel. standard uncertainty"]
[1]
[2]
[3]
["Combined uncertainty component",{"$nulls":3},"ubias",{"$f":"IF(COUNT(F21:F23)<>0,SQRT(SUMSQ(F21:F23)),\"\")","v":""}]
["Total Combined Standard uncertainty u",{"$nulls":4},{"$f":"IF(AND(F18<>\"\",F24<>\"\"),SQRT(F18*F18+F24*F24),\"\")","v":""}]
["Expanded Uncertainty U",null,null,"k-factor",null,{"$f":"IF(AND(F25<>\"\",E26<>\"\"),E26*F25,\"\")","v":""}]
["© 2015 Dr. M. Koch, Institute for Sanitary Engineering, Universität Stuttgart, www.aqsbw.de"]
["The use of this EXCEL-sheet is free, as long as the copyright statement is not removed."]

{"sheet":"reproducibility","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]]}
["Reproducibility within laboratory",{"$nulls":3},"uRw"]
["A) Control sample, covering the whole analytical process"]
["Standard deviation:",null,null,"transfer to sheet \"Total\""]
[]
["Remarks:"]
[]
[]
["B) Control sample, not covering the whole analytical process"]
["B.1 result from the control sample"]
["Standard deviation:"]
["B.2 component from changing matrices and concentrations (from range)"]
["Mean range:",{"$nulls":4},"sheet \"s from range\", cell M3"]
["Number of measurements for the range (2, 3, 4 or 5)"]
["Standard deviation:"]
["Combination:",{"$nulls":3},{"$f":"IF(AND(C10<>\"\",E14<>\"\"),SQRT(C10*C10+E14*E14),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["Remarks:"]
[]
[]
["C) Unstable control samples"]
["C.1 Repeatability"]
["Mean range:",{"$nulls":4},"sheet \"s from range\", cell M3"]
["Number of measurements for the range (2, 3, 4 or 5)"]
["Standard deviation:",{"$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 \"Long term\" component"]
["Estimation for standard deviation"]
["based on"]
["Combination:",{"$nulls":3},{"$f":"IF(AND(E24<>\"\",E26<>\"\"),SQRT(E24*E24+E26*E26),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["Remarks:"]

{"sheet":"method and laboratory bias","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]]}
["Method and Laboratory Bias",{"$nulls":3},"ubias"]
["A) Multiple Analysis of one certified reference material"]
["Certified value",null,null,"unit:",null,"Remarks:"]
["Confidence interval     +/-"]
["Confidence level"]
["Standard uncertainty:",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":""}]
["Mean of CRM-analysis:",{"$nulls":3},{"$f":"IF(E3<>\"\",E3,\"\")","v":""}]
["Mean deviation:",null,null,{"$f":"IF(AND(D7<>\"\",C3<>\"\"),D7-C3,\"\")","v":""}]
["Std.-deviation of CRM-analysis:",{"$nulls":3},{"$f":"IF(E3<>\"\",E3,\"\")","v":""}]
["Number of measurements:"]
["Standard uncertainty",null,null,{"$f":"IF(AND(D8<>\"\",AND(D9<>\"\",AND(D10<>\"\",D6<>\"\"))),SQRT(D8*D8+(D9*D9/D10)+D6*D6),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["B) Multiple analysis of several certified reference materials"]
[null,"cert. value","confid. interval","confid. level","mean"]
["CRM 1",{"$nulls":4},"Remarks:"]
["CRM 2"]
["CRM 3"]
["CRM 4"]
[null,"u(cref)",null,"deviation","squared dev."]
["CRM 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":""}]
["CRM 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":""}]
["CRM 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":""}]
["CRM 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":""}]
["mean",{"$f":"IF(B20<>\"\",AVERAGE(B20:B23),\"\")","v":""},"RMSbias",{"$f":"IF(E20<>\"\",SQRT(SUM(E20:E23)/COUNT(E20:E23)),\"\")","v":""}]
["Standard uncertainty",null,{"$f":"IF(AND(B24<>\"\",D24<>\"\"),SQRT(B24*B24+D24*D24),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["C) Proficiency tests"]
["Own results"]
[null,"Assigned val.","result","deviation","squared deviation"]
["Sample 1",null,null,{"$f":"IF(AND(C30<>\"\",B30<>\"\"),(C30-B30),\"\")","v":""},{"$f":"IF(D30<>\"\",D30*D30,\"\")","v":""},"Remarks:"]
["Sample 2",null,null,"",""]
["Sample 3",null,null,"",""]
["Sample 4",null,null,"",""]
["Sample 5",null,null,"",""]
["Sample 6",null,null,"",""]
["Sample 7",null,null,"",""]
["Sample 8",null,null,"",""]
["Sample 9",null,null,"",""]
["Sample 10",null,null,"",""]
["Sample 11",null,null,"",""]
["Sample 12",null,null,"",""]
[{"$nulls":3},"RMSbias",{"$f":"IF(E30<>\"\",SQRT(SUM(E30:E41)/COUNT(E30:E41)),\"\")","v":""}]
["Uncertainty of the assigned value"]
[]
[null,null,1]
[null,"sR","N values","u(cref)",null,"Unc.","Conf.-level","u(cref)"]
["Sample 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":""}]
["Sample 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":""}]
["Sample 3",null,null,"",{"$nulls":3},""]
["Sample 4",null,null,"",{"$nulls":3},""]
["Sample 5",null,null,"",{"$nulls":3},""]
["Sample 6",null,null,"",{"$nulls":3},""]
["Sample 7",null,null,"",{"$nulls":3},""]
["Sample 8",null,null,"",{"$nulls":3},""]
["Sample 9",null,null,"",{"$nulls":3},""]
["Sample 10",null,null,"",{"$nulls":3},""]
["Sample 11",null,null,"",{"$nulls":3},""]
["Sample 12",null,null,"",{"$nulls":3},""]
[null,null,"mean",{"$f":"IF(D47<>\"\",AVERAGE(D47:D58),\"\")","v":""},null,null,"mean",{"$f":"IF(H47<>\"\",AVERAGE(H47:H58),\"\")","v":""}]
[]
["Standard uncertainty",null,{"$f":"IF(E42<>\"\",    IF(D59<>\"\", SQRT(E42^2+D59^2), IF(H59<>\"\",  SQRT(E42^2+H59^2),\"\")                    ),\"\")","v":""},"transfer to sheet \"Total\""]
[]
["D) Recovery Experiment"]
["Uncertainty of the concentration of the spike solution:"]
["Concentration of the spike solution:"]
["Confidence interval     +/-"]
["Confidence level:"]
[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":""}]
["Uncertainty of the added volume:"]
["max. deviation (rectangular distribution)",{"$nulls":4},"Std-dev.:",{"$f":"IF(E70<>\"\",E70/SQRT(3),\"\")","v":""}]
["Repeatability (as standard deviation)"]
[{"$nulls":3},"uvol",{"$f":"IF(AND(E70<>\"\",E71<>\"\"),SQRT(G70*G70+E71*E71),\"\")","v":""}]
["Uncertainty of the spike:",null,null,"uspike",{"$f":"IF(AND(D68<>\"\",E72<>\"\"),SQRT(D68*D68+E72*E72),\"\")","v":""}]
["Recovery:"]
[null,"spike","deviation","squared deviation"]
[1,null,null,{"$f":"IF(C76<>\"\",C76*C76,\"\")","v":""},null,"Remarks:"]
[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,"RMSbias",{"$f":"IF(AND(B76<>\"\",C76<>\"\"),SQRT(SUM(D76:D87)/COUNT(D76:D87)),\"\")","v":""}]
["Standard uncertainty",null,{"$f":"IF(AND(E73<>\"\",D88<>\"\"),SQRT(E73*E73+D88*D88),\"\")","v":""},"transfer to sheet \"Total\""]

{"sheet":"s from range","index":3,"n_rows":101,"n_cols":13,"rows_kept":101,"merged":[[7,11,19,12]]}
[null,"1st value","2nd value","3rd value","4th value","5th value",null,null,"mean","range","rel. range"]
[1,{"$nulls":5},"number of measurem.",{"$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":""},"total mean",{"$f":"IF(I2<>\"\",AVERAGE(I2:I101),\"\")","v":""}]
[2,{"$nulls":5},"s (absolute)",{"$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":""},"mean range",{"$f":"IF(J2<>\"\",AVERAGE(J2:J101),\"\")","v":""}]
[3,{"$nulls":5},"s (relative)",{"$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":""},"","","","mean rel. range",{"$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":""},"Remarks:"]
[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 and s from data","index":4,"n_rows":101,"n_cols":4,"rows_kept":101,"merged":[[6,3,17,4]]}
[null,"values"]
[1,null,"mean:",{"$f":"IF(B2<>\"\",AVERAGE(B2:B101),\"\")","v":""}]
[2,null,"standard deviation",{"$f":"IF(AND(B2<>\"\",B3<>\"\"),STDEV(B2:B101),\"\")","v":""}]
[3,null,"rel. standard deviation",{"$f":"IF(D3<>\"\",D3/D2,\"\")","v":""}]
[4]
[5]
[6,null,"Remarks:"]
[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":"combination","index":5,"n_rows":40,"n_cols":6,"rows_kept":40}
[]
[]
["No.","description","deviation","confidence level","denominator","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=\"rectangular\",1.732,IF(D4=\"triangular\",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=\"rectangular\",1.732,IF(D5=\"triangular\",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},"combination",{"$f":"IF(COUNT(F4:F13)<>0,SQRT(SUMSQ(F4:F13)),\"\")","v":""}]
[]
["No.","description","deviation","confidence level","denominator","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=\"rectangular\",1.732,IF(D17=\"triangular\",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=\"rectangular\",1.732,IF(D18=\"triangular\",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},"combination",{"$f":"IF(COUNT(F17:F26)<>0,SQRT(SUMSQ(F17:F26)),\"\")","v":""}]
[]
["No.","description","deviation","confidence level","denominator","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=\"rectangular\",1.732,IF(D30=\"triangular\",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=\"rectangular\",1.732,IF(D31=\"triangular\",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},"combination",{"$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,"rectangular"]
[null,"triangular"]