{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["precision","bias","Tables, data","control chart","Amendments"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":3,"defined_names":76,"comments":3,"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":"precision","index":0,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Uncertainty of Measurement: precision calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C.  Range calculations"]
["Determinand, method  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"batch","rel.mean"]
["range  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"max","min","mean","Rj, rel"]
["liimit of quantification  ",null,{"$f":"C4","v":0},null,null,null,"coverage factor, k =",2,null,null,null,null,null,1,null,null,{"$f":"IFERROR(AVERAGE(O5:P5),\"\")","v":""},{"$f":"IF(O5=0,\"\",ABS(O5-P5)/Q5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"IFERROR(AVERAGE(O6:P6),\"\")","v":""},{"$f":"IF(O6=0,\"\",ABS(O6-P6)/Q6)","v":""}]
["A.  Precision estimate using a matrix standard",null,null,null,null,null,null,"AQC standard, nominal value",null,{"$f":"C4","v":0},null,null,null,3,null,null,"",""]
["Individual sources of","symbol","units","conc'n","st.dev.","no.","uncert-ainty","rel.uncert-ainty","expanded. factor =",{"$f":"H5","v":2},null,null,null,4,null,null,"",""]
["uncertainty",null,null,"cj","sj","nM","uj","uj,rel","U","Urel",null,null,null,5,null,null,"",""]
["AQC standard in matrix","sRw",{"$f":"C4","v":0},null,null,null,{"$f":"E10","v":0},{"$f":"IFERROR(G10/D10,\"\")","v":""},{"$f":"G10*$J$8","v":0},{"$f":"IFERROR(H10*$J$8,\"\")","v":""},null,null,null,6,null,null,"",""]
["mean range from chart","Rj, rel",{"$f":"$C$4","v":0},{"$f":"R45","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IFERROR(H11*D11,\"\")","v":""},{"$f":"IFERROR(D11/VLOOKUP(F11,'Tables, data'!$W$10:$X$18,2),\"\")","v":""},{"$f":"IFERROR(H11*$J$8*D11,\"\")","v":""},{"$f":"IFERROR(H11*$J$8,\"\")","v":""},null,null,null,7,null,null,"",""]
["Combined ","uRw","= √∑u2",null,null,null,{"$f":"SQRT(SUMSQ(G10:G11))","v":0},{"$f":"SQRT(SUMSQ(H10:H11))","v":0},{"$f":"SQRT(SUMSQ(I10:I11))","v":0},{"$f":"SQRT(SUMSQ(J10:J11))","v":0},null,null,null,8,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,"",""]
["B.  Precision estimate using a synthetic standard",null,null,null,null,null,null,"AQC standard, nominal value",null,{"$f":"C4","v":0},null,null,null,13,null,null,"",""]
["Individual sources of","symbol","units","conc'n","st.dev.","no.","uncertainty","rel.uncert-ainty","expanded. factor =",{"$f":"H5","v":2},null,null,null,14,null,null,"",""]
["uncertainty",null,null,"cj","sj","nM","uj","uj,rel","U","Urel",null,null,null,15,null,null,"",""]
["AQC standard","sRw",{"$f":"$C$4","v":0},null,null,null,{"$f":"E20","v":0},{"$f":"IFERROR(G20/D20,\"\")","v":""},{"$f":"G20*$J$8","v":0},{"$f":"IFERROR(H20*$J$8,\"\")","v":""},null,null,null,16,null,null,{"$f":"IFERROR(AVERAGE(O20:P20),\"\")","v":""},""]
["mean range from chart","Rj, rel",{"$f":"$C$4","v":0},{"$f":"D11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IFERROR(H21*D21,\"\")","v":""},{"$f":"IFERROR(D21/VLOOKUP(F21,'Tables, data'!$W$10:$X$18,2),\"\")","v":""},{"$f":"IFERROR(H21*$J$8*D21,\"\")","v":""},{"$f":"IFERROR(H21*$J$8,\"\")","v":""},null,null,null,17,null,null,"",""]
["reproducibility (between batch)","sRw,bat",{"$f":"$C$4","v":0},null,null,null,{"$f":"E22","v":0},{"$f":"IFERROR(G22/D22,\"\")","v":""},{"$f":"G22*$J$8","v":0},{"$f":"IFERROR(H22*$J$8,\"\")","v":""},null,null,null,18,null,null,"",""]
["repeatability (within batch)","srw",{"$f":"$C$4","v":0},null,null,null,{"$f":"E23","v":0},{"$f":"IFERROR(G23/D23,\"\")","v":""},{"$f":"G23*$J$8","v":0},{"$f":"IFERROR(H23*$J$8,\"\")","v":""},null,null,null,19,null,null,"",""]
["Combined ","uRw","= √∑u2",null,null,null,{"$f":"SQRT(SUMSQ(G20:G23))","v":0},{"$f":"SQRT(SUMSQ(H20:H23))","v":0},{"$f":"SQRT(SUMSQ(I20:I23))","v":0},{"$f":"SQRT(SUMSQ(J20:J23))","v":0},null,null,null,20,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,"",""]
["Summary table",null,null,null,"coverage factor, k =",{"$f":"H5","v":2},null,null,null,null,null,null,null,24,null,null,"",""]
["Determinand","Method","Matrix","section","units","relative expanded UoM                   %","rel. bias uncertainty","AQC standard","control chart  mean","control chart         st dev","rel. within lab. reproducibility","AQC        rel bias       %",null,25,null,null,"",""]
[null,null,null,null,"symbol (ISO11352)","Urel","ub,rel","Cref","cj","srw","uRw,rel","brel",null,26,null,null,"",""]
["A.  Precision estimate from matrix standard",null,null,null,{"$f":"C4","v":0},{"$f":"IF(G31=\"error\",\"error\",SQRT(SUMSQ(K31,G31))*$F$28)","v":{"$error":"#DIV/0!"}},{"$f":"IF(NOT(R43=\"\"),R43,IF(NOT(X43=\"\"),X43,IF(NOT(BK43=\"\"),BK43,\"no bias\")))","v":"no bias"},{"$f":"I7","v":0},{"$f":"D10","v":0},{"$f":"G12","v":0},{"$f":"IF(OR(J31=\"\",I31=\"\"),\"\",J31/I31*100)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(H31=\"\",I31=\"\"),\"\",(I31-H31)/H31*100)","v":{"$error":"#DIV/0!"}},null,27,null,null,"",""]
["B.  Precision estimate from synthetic standard",null,null,null,{"$f":"C4","v":0},{"$f":"IF(G32=\"error\",\"error\",SQRT(SUMSQ(K32,G32))*$F$28)","v":{"$error":"#DIV/0!"}},{"$f":"IF(NOT(R44=\"\"),R44,IF(NOT(X44=\"\"),X44,IF(NOT(BK44=\"\"),BK44,\"no bias\")))","v":"no bias"},{"$f":"I17","v":0},{"$f":"D20","v":0},{"$f":"G24","v":0},{"$f":"IF(OR(J32=\"\",I32=\"\"),\"\",J32/I32*100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,28,null,null,"",""]
[null,null,null,null,"formula","k.√(ub,rel2+uRw,rel2)","(cj - Cref)/Cref",null,null,null,"srw/cj","(cj - Cref)/Cref",null,29,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,37,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,38,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mean  (Rj, rel)",{"$f":"AVERAGE(O5:O44)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P5:P44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(R5:R44)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"st.deviation",{"$f":"STDEV(O5:O44)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(P5:P44)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"STDEV(R5:R44)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"no. replicates",null,"n",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"range chart factor ",null,"d2",null,1.1279999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Coeff variation (Cv)",null," ur,range,rel",null,{"$f":"R45/R48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ISO11352, table B.4)"]

{"sheet":"bias","index":1,"n_rows":166,"n_cols":51,"rows_kept":166,"cut":false,"hidden":false,"merged":[[110,4,110,5]]}
["Uncertainty of Measurement: bias calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M. Concentration of reference materials"]
["Determinand, method  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"units","nominal conc'n","st.dev","no.","relative unc'ty"]
["range  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cref","uCref","nM","uCref, rel"]
["liimit of quantification  ",null,{"$f":"C4","v":0},null,null,null,"coverage factor, k =",2,null,null,null,null,null,null,null,null,"Traceable standard","mg/L",null,null,null,{"$f":"IFERROR(T5/S5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference material","mg/L",null,null,null,""]
["Note: the within laboratory reproducibility needs to be combined with the sources of uncertainty in the reference value.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AQC sample for PT","mg/L",null,null,null,""]
["This is commonly estimated separately, eg. from a control chart as a coefficient of variation = standard deviation ÷ mean",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control chart standard","mg/L",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT scheme distribution","mg/L",null,null,null,""]
["D1.  Bias uncertainty using a single traceable standard or CRM ",null,null,null,null,null,null,null,null,null,"coverage factor, k =",{"$f":"H5","v":2},null,null,null,null,"Recovery test","mg/L",null,null,null,"",null,null,null,null,"D3.  pH (absolute) Bias uncertainty using a single traceable standard or CRM "]
[null,null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,null,null,null,"Other",null,null,null,null,"",null,null,null,null,null,null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty"]
["Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub"]
["Reference standard","Cref",null,null,null,{"$f":"D13/C13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AG13*AC13/100","v":0},null,"%"]
["Measured value, mean","c",null,null,null,{"$f":"D14/C14","v":{"$error":"#DIV/0!"}},null,{"$f":"C14-C13","v":0},{"$f":"H14/C13","v":{"$error":"#DIV/0!"}},{"$f":"D14/C14","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(I14^2+J14^2/E14+F13^2)","v":{"$error":"#DIV/0!"}},{"$f":"K14*L10","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measured value, mean","c",null,null,null,null,null,null,{"$f":"AC14-AC13","v":0},null,{"$f":"SQRT(AI14^2+(AD14/SQRT(AE14))^2+AF13^2)","v":{"$error":"#DIV/0!"}},{"$f":"AK14*L10","v":{"$error":"#DIV/0!"}}]
["Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"F14","v":{"$error":"#DIV/0!"}}]
["Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(K14:K15))","v":{"$error":"#DIV/0!"}},{"$f":"K16*L10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"(ISO11352, section B.1.3)",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,"(ISO11352, section B.1.3)"]
["D2.  Bias uncertainty using multiple traceable standards or CRMs ",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,"D4. pH (absolute) Bias uncertainty using multiple traceable standards or CRMs "]
["Overall TS or CRM",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall TS or CRM",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty"]
["Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub"]
["Reference standard",null,null,null,null,{"$f":"AVERAGE(F25,F32,F39,S25,S32,S39)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SQRT(SUMSQ(I26,I33,I40,V26,V33,V40)/COUNT(E26,E33,E40,R26,R33,R40))","v":{"$error":"#DIV/0!"}},null,{"$f":"SQRT(I21^2+F21^2)","v":{"$error":"#DIV/0!"}},{"$f":"K21*L10","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference standard",null,null,null,null,{"$f":"AVERAGE(AF25,AF32,AF39,AS25,AS32,AS39)","v":0},null,null,{"$f":"SQRT(SUMSQ(AI26,AI33,AI40,AV26,AV33,AV40)/COUNT(AE26,AE33,AE40,AR26,AR33,AR40))","v":{"$error":"#DIV/0!"}},null,{"$f":"SQRT(AI21^2+AF21^2)","v":{"$error":"#DIV/0!"}},{"$f":"AK21*L10","v":{"$error":"#DIV/0!"}}]
[]
["CRM 1",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 4",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 1",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty",null,"CRM 4",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty"]
["Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub"]
["Reference standard","Cref",null,null,null,{"$f":"D25/C25","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"IFERROR(Q25/P25,\"\")","v":""},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AG25*AC25/100","v":0},null,"%",null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AT25*AP25/100","v":0},null,"%"]
["Measured value, mean","c",null,null,null,{"$f":"D26/C26","v":{"$error":"#DIV/0!"}},null,{"$f":"C26-C25","v":0},{"$f":"H26/C25","v":{"$error":"#DIV/0!"}},{"$f":"D26/C26","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(I26^2+J26^2/E26+F25^2)","v":{"$error":"#DIV/0!"}},{"$f":"K26*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"Q26/P26","v":{"$error":"#DIV/0!"}},null,{"$f":"P26-P25","v":0},{"$f":"IFERROR(U26/P25,0)","v":0},{"$f":"Q26/P26","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(V26^2+W26^2/R26+S25^2)","v":{"$error":"#DIV/0!"}},{"$f":"X26*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AG26*AC26/100","v":0},null,"%",{"$f":"AC26-AC25","v":0},null,{"$f":"SQRT(AI26^2+(AD26/SQRT(AE26))^2+AF25^2)","v":{"$error":"#DIV/0!"}},{"$f":"AK26*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AT26*AP26/100","v":0},null,"%",{"$f":"AP26-AP25","v":0},null,{"$f":"SQRT(AV26^2+(AQ26/SQRT(AR26))^2+AS25^2)","v":{"$error":"#DIV/0!"}},{"$f":"AX26*L10","v":{"$error":"#DIV/0!"}}]
["Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"F26","v":{"$error":"#DIV/0!"}},null,null,"Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"S26","v":{"$error":"#DIV/0!"}},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AF26","v":0},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AS26","v":0}]
["Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(K26:K27))","v":{"$error":"#DIV/0!"}},{"$f":"K28*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(X26:X27))","v":{"$error":"#DIV/0!"}},{"$f":"X28*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AK26:AK27))","v":{"$error":"#DIV/0!"}},{"$f":"AK28*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AX26:AX27))","v":{"$error":"#DIV/0!"}},{"$f":"AX28*L10","v":{"$error":"#DIV/0!"}}]
[]
["CRM 2",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 5",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 2",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty",null,"CRM 5",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty"]
["Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub"]
["Reference standard","Cref",null,null,null,{"$f":"D32/C32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"IFERROR(Q32/P32,\"\")","v":""},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AG32*AC32/100","v":0},null,"%",null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AT32*AP32/100","v":0},null,"%"]
["Measured value, mean","c",null,null,null,{"$f":"D33/C33","v":{"$error":"#DIV/0!"}},null,{"$f":"C33-C32","v":0},{"$f":"H33/C32","v":{"$error":"#DIV/0!"}},{"$f":"D33/C33","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(I33^2+J33^2/E33+F32^2)","v":{"$error":"#DIV/0!"}},{"$f":"K33*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"Q33/P33","v":{"$error":"#DIV/0!"}},null,{"$f":"P33-P32","v":0},{"$f":"IFERROR(U33/P32,0)","v":0},{"$f":"Q33/P33","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(V33^2+W33^2/R33+S32^2)","v":{"$error":"#DIV/0!"}},{"$f":"X33*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AG33*AC33/100","v":0},null,"%",{"$f":"AC33-AC32","v":0},null,{"$f":"SQRT(AI33^2+(AD33/SQRT(AE33))^2+AF32^2)","v":{"$error":"#DIV/0!"}},{"$f":"AK33*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AT33*AP33/100","v":0},null,"%",{"$f":"AP33-AP32","v":0},null,{"$f":"SQRT(AV33^2+(AQ33/SQRT(AR33))^2+AS32^2)","v":{"$error":"#DIV/0!"}},{"$f":"AX33*L10","v":{"$error":"#DIV/0!"}}]
["Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"F33","v":{"$error":"#DIV/0!"}},null,null,"Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"S33","v":{"$error":"#DIV/0!"}},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AF33","v":0},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AS33","v":0}]
["Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(K33:K34))","v":{"$error":"#DIV/0!"}},{"$f":"K35*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(X33:X34))","v":{"$error":"#DIV/0!"}},{"$f":"X35*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AK33:AK34))","v":{"$error":"#DIV/0!"}},{"$f":"AK35*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AX33:AX34))","v":{"$error":"#DIV/0!"}},{"$f":"AX35*L10","v":{"$error":"#DIV/0!"}}]
[]
["CRM 3",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 6",null," conc'n"," st.dev =  sRw","no.","relative unc'ty",null,"bias","relative bias","coeff. variation","rel. bias uncertainty","rel. expanded uncertainty",null,"CRM 3",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty",null,"CRM 6",null," conc'n"," st.dev =  sRw","no."," unc'ty ref mat","relative unc'ty",null,"bias",null,"bias uncertainty"," expanded uncertainty"]
["Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","uCref","nM","uCref, rel",null,"b","brel","CV,b=uRw,rel","ub,rel","Ub,rel",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub",null,"Reference standard",null,"c","Sb","nM","uCref","uCref, rel",null,"b",null,"ub","Ub"]
["Reference standard","Cref",null,null,null,{"$f":"IFERROR(D39/C39,\"\")","v":""},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"IFERROR(Q39/P39,\"\")","v":""},null,null,null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AG39*AC39/100","v":0},null,"%",null,null,null,null,null,"Reference standard","Cref",null,null,null,{"$f":"AT39*AP39/100","v":0},null,"%"]
["Measured value, mean","c",null,null,null,{"$f":"IFERROR(D40/C40,\"\")","v":""},null,{"$f":"IFERROR(C40-C39,\"\")","v":0},{"$f":"IFERROR(H40/C39,0)","v":0},{"$f":"D40/C40","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(I40^2+J40^2/E40+F39^2)","v":{"$error":"#DIV/0!"}},{"$f":"K40*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"Q40/P40","v":{"$error":"#DIV/0!"}},null,{"$f":"P40-P39","v":0},{"$f":"IFERROR(U40/P39,0)","v":0},{"$f":"Q40/P40","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(V40^2+W40^2/R40+S39^2)","v":{"$error":"#DIV/0!"}},{"$f":"X40*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AG40*AC40/100","v":0},null,"%",{"$f":"AC40-AC39","v":0},null,{"$f":"SQRT(AI40^2+(AD40/SQRT(AE40))^2+AF39^2)","v":{"$error":"#DIV/0!"}},{"$f":"AK40*L10","v":{"$error":"#DIV/0!"}},null,"Measured value, mean","c",null,null,null,{"$f":"AT40*AP40/100","v":0},null,"%",{"$f":"AP40-AP39","v":0},null,{"$f":"SQRT(AV40^2+(AQ40/SQRT(AR40))^2+AS39^2)","v":{"$error":"#DIV/0!"}},{"$f":"AX40*L10","v":{"$error":"#DIV/0!"}}]
["Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"F40","v":""},null,null,"Within lab. reproducibility","uRw,rel","= CV",null,null,null,null,null,null,null,{"$f":"S40","v":{"$error":"#DIV/0!"}},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AF40","v":0},null,null,"Within lab. reproducibility","uRw",null,null,null,null,null,null,null,null,{"$f":"AS40","v":0}]
["Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(K40:K41))","v":{"$error":"#DIV/0!"}},{"$f":"K42*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc,rel",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(X40:X41))","v":{"$error":"#DIV/0!"}},{"$f":"X42*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AK40:AK41))","v":{"$error":"#DIV/0!"}},{"$f":"AK42*L10","v":{"$error":"#DIV/0!"}},null,"Combined uncertainty","uc",null,null,null,null,null,null,null,null,{"$f":"SQRT(SUMSQ(AX40:AX41))","v":{"$error":"#DIV/0!"}},{"$f":"AX42*L10","v":{"$error":"#DIV/0!"}}]
[]
["E.  Bias uncertainty from recovery tests",null,null,null,null,"F.  Recovery calculations",null,null,null,null,"C.  Range calculations",null,null,null,null,null,"N. Validation summary of statistics (NS30)"]
[null,"units","measured conc'n","bias",null,null,null,"measured recovery","relative deviation",null,null,null,null,"batch","rel.mean",null,null,"nominal","mean","bias","precision","degrees of freedom","within-batch st.dev.","between-batch st.dev.","total          st.dev."]
["Nominal conc'n (Cref)",null,"r","b = Di",null,null,"units","η","bi,rel",null,null,"max","min","mean","Rj, rel",null,null,"cref","c","b","sRw","nM-1","sw","sb","st"]
[1,{"$f":"C4","v":0},null,{"$f":"IF(ISBLANK(C47)=FALSE,C47-$B$46,\"\")","v":""},null,1,"%",null,{"$f":"IF(ISBLANK(H47)=FALSE,(H47-100)/100,\"\")","v":""},null,1,null,null,{"$f":"IFERROR(AVERAGE(L47:M47),\"\")","v":""},{"$f":"IF(L47=0,\"\",ABS(L47-M47)/N47)","v":""},null,"AQC standard",null,null,{"$f":"S47-R47","v":0}]
[2,{"$f":"B47","v":0},null,"",null,2,{"$f":"G47","v":"%"},null,{"$f":"IF(ISBLANK(H48)=FALSE,(H48-100)/100,\"\")","v":""},null,2,null,null,{"$f":"IFERROR(AVERAGE(L48:M48),\"\")","v":""},{"$f":"IF(L48=0,\"\",ABS(L48-M48)/N48)","v":""},null,"blank",null,null,{"$f":"S48-R48","v":0}]
[3,{"$f":"B48","v":0},null,"",null,3,{"$f":"G48","v":"%"},null,"",null,3,null,null,"","",null,"low standard",null,null,{"$f":"S49-R49","v":0}]
[4,0,null,"",null,4,"%",null,"",null,4,null,null,"","",null,"high standard",null,null,{"$f":"S50-R50","v":0}]
[5,{"$f":"B50","v":0},null,"",null,5,"%",null,"",null,5,null,null,"","",null,"sample"]
[6,0,null,"",null,6,"%",null,"",null,6,null,null,"","",null,"sample+spike"]
[7,0,null,"",null,7,"%",null,"",null,7,null,null,"","",null,"Recovery",null,null,{"$f":"S53-R53","v":0}]
[8,0,null,"",null,8,"%",null,"",null,8,null,null,"",""]
[9,0,null,"",null,9,"%",null,"",null,9,null,null,"",""]
[10,0,null,"",null,10,"%",null,"",null,10,null,null,"","",null,"P.  Comparison of bias estimates with PT results"]
[11,0,null,"",null,11,"%",null,"",null,11,null,null,"","",null,"Significance decided at p = 0.05%",null,null,"Traceable standard","Recovery tests","Proficency Test"]
[12,0,null,"",null,12,"%",null,"",null,12,null,null,"","",null,null,null,"results from calculation block","D","E","G"]
[13,0,null,"",null,13,"%",null,"",null,13,null,null,"","",null,null,"mean bias","b",{"$f":"I14","v":{"$error":"#DIV/0!"}},{"$f":"D77/C77","v":{"$error":"#DIV/0!"}},{"$f":"F106","v":{"$error":"#DIV/0!"}}]
[14,0,null,"",null,14,"%",null,"",null,14,null,null,"","",null,null,"uncertainty in bias","ub",{"$f":"J14","v":{"$error":"#DIV/0!"}},{"$f":"D78/C77","v":{"$error":"#DIV/0!"}},{"$f":"F107","v":{"$error":"#DIV/0!"}}]
[15,0,null,"",null,15,"%",null,"",null,15,null,null,"","",null,null,"degrees of freedom","nM -1",{"$f":"E14-1","v":-1},{"$f":"C79-1","v":-1},{"$f":"F109-1","v":-1}]
[16,0,null,"",null,16,"%",null,"",null,16,null,null,"","",null,"comparison of uncertainty"]
[17,0,null,"",null,17,"%",null,"",null,17,null,null,"","",null,null,"statistic","F =",{"$f":"(T60/V60)^2","v":{"$error":"#DIV/0!"}},{"$f":"(U60/V60)^2","v":{"$error":"#DIV/0!"}}]
[18,0,null,"",null,18,"%",null,"",null,18,null,null,"","",null,null,"probability","p =",{"$f":"FDIST(T63,T61,V61)","v":{"$error":"#DIV/0!"}},{"$f":"FDIST(U63,T61,V61)","v":{"$error":"#DIV/0!"}}]
[19,0,null,"",null,19,"%",null,"",null,19,null,null,"","",null,null,null,"difference in uncertainty",{"$f":"IF(T63>FINV(0.05,V61,T61),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(U63>FINV(0.05,V61,U61),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}}]
[20,0,null,"",null,20,"%",null,"",null,20,null,null,"",""]
[21,0,null,"",null,21,"%",null,"",null,21,null,null,"","",null,"comparison of bias"]
[22,0,null,"",null,22,"%",null,"",null,22,null,null,"","",null,null,"pooled sd",null,{"$f":"SQRT((T60^2*T61+V60^2*V61)/(T69))","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((U60^2*U61+V60^2*V61)/(U69))","v":{"$error":"#DIV/0!"}}]
[23,0,null,"",null,23,"%",null,"",null,23,null,null,"","",null,null,"total df.",null,{"$f":"T61+V61","v":-2},{"$f":"U61+V61","v":-2}]
[24,0,null,{"$f":"IF(ISBLANK(C70)=FALSE,C70-$B$46,\"\")","v":""},null,24,"%",null,"",null,24,null,null,"","",null,null,"statistic","t =",{"$f":"ABS(T59-V59)/SQRT((T61)^-1+(V61)^-1)/T68","v":{"$error":"#DIV/0!"}},{"$f":"ABS(U59-V59)/SQRT((U61)^-1+(V61)^-1)/U68","v":{"$error":"#DIV/0!"}}]
[25,0,null,"",null,25,"%",null,"",null,25,null,null,"","",null,null,"probability","p =",{"$f":"TDIST(T70,T69,2)","v":{"$error":"#DIV/0!"}},{"$f":"TDIST(U70,U69,2)","v":{"$error":"#DIV/0!"}}]
[26,0,null,"",null,26,"%",null,"",null,26,null,null,"","",null,null,null,"difference in bias",{"$f":"IF(T70>TINV(0.05,T69),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(U70>TINV(0.05,U69),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}}]
[27,0,null,"",null,27,"%",null,"",null,27,null,null,"","",null,"Note: this tests whether the laboratory uncertainty is significantly greater than the PT uncertainty"]
[28,0,null,"",null,28,"%",null,"",null,28,null,null,"",""]
[29,0,null,"",null,29,"%",null,"",null,29,null,null,"",""]
[30,0,null,"",null,30,"%",null,"",null,30,null,null,"",""]
["mean (rho)",{"$f":"B76","v":0},{"$f":"AVERAGE(C47:C76)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D47:D76)","v":{"$error":"#DIV/0!"}},null,"mean (r)",null,{"$f":"AVERAGE(H47:H76)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(I47:I76)","v":{"$error":"#DIV/0!"}},null,31,null,null,"",""]
["stdev (s)",0,{"$f":"STDEV(C47:C76)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D47:D76)","v":{"$error":"#DIV/0!"}},null,"stdev (s)",null,{"$f":"STDEV(H47:H76)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(I47:I76)","v":{"$error":"#DIV/0!"}},null,32,null,null,"",""]
["no. measurements","nM",{"$f":"COUNT(C47:C76)","v":0},null,null,"no. measurements","nM",{"$f":"COUNT(H47:H76)","v":0},null,null,33,null,null,"",""]
["Coeff variation (Cv)","uRw,stand,rel",{"$f":"C78/C77","v":{"$error":"#DIV/0!"}},null,null,"rms deviation (rel) ",null,"brms,rel",{"$f":"SQRT(SUMSQ(I47:I76)/H79)","v":{"$error":"#DIV/0!"}},null,34,null,null,"",""]
[null,null,null,"(ISO11352, table B.3)",null,null,null,null,"(ISO11352, table B.5)",null,35,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,36,null,null,"","",null,"G2.  Bias uncertainty using proficiency test data (pH  (absolute values))"]
["G.  Bias uncertainty using proficiency test data",null,null,null,null,null,null,"robust mean multiplier",null,null,37,null,null,"","",null,null,null,null,null,null,null,null,"robust mean multiplier"]
[null,"units","assigned value","own lab result","mean bias","relative bias","reprod'y st.dev.","no. labs","rel. uncert'y, ass'd value",null,38,null,null,"","",null,null,"units","assigned value","own lab result","mean bias","relative bias","reprod'y st.dev.","no. labs","uncert'y, ass'd value"]
["Test number",null,"cass","c","b = Di","Di,rel","sR,i,rel","np,i","uC-ref,i,rel",null,39,null,null,"","",null,"Test number",null,"cass","c","b = Di","Di","sR,i","np,i","uC-ref,i"]
[1,{"$f":"C4","v":0},null,null,{"$f":"IF(C86=0,\"\",D86-C86)","v":""},{"$f":"IF(C86=0,\"\",E86/C86)","v":""},null,null,{"$f":"IF(H86=0,\"\",$I$83*G86/SQRT(H86))","v":""},null,40,null,null,"","",null,1,{"$f":"C$4","v":0},null,null,{"$f":"IF(S86=0,\"\",T86-S86)","v":""},{"$f":"IF(S86=0,\"\",U86/S86)","v":""},null,null,{"$f":"IF(X86=0,\"\",$Y$83*W86/SQRT(X86))","v":""}]
[2,{"$f":"B86","v":0},null,null,"","",null,null,"",null,"mean  (Rj, rel)",{"$f":"AVERAGE(L47:L86)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(M47:M86)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(O47:O86)","v":{"$error":"#DIV/0!"}},null,2,{"$f":"C$4","v":0},null,null,{"$f":"IF(S87=0,\"\",T87-S87)","v":""},{"$f":"IF(S87=0,\"\",U87/S87)","v":""},null,null,{"$f":"IF(X87=0,\"\",$Y$83*W87/SQRT(X87))","v":""}]
[3,0,null,null,"","",null,null,"",null,"st.deviation",{"$f":"STDEV(L47:L86)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(M47:M86)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"STDEV(O47:O86)","v":{"$error":"#DIV/0!"}},null,3,0,null,null,"","",null,null,""]
[4,0,null,null,"","",null,null,"",null,"no. replicates",null,"n",null,2,null,4,0,null,null,"","",null,null,""]
[5,0,null,null,"","",null,null,"",null,"range chart factor ",null,"d2",null,1.1279999999999999,null,5,0,null,null,"","",null,null,""]
[6,0,null,null,"","",null,null,"",null,"Coeff variation (Cv)",null," ur,range,rel",null,{"$f":"O87/O90","v":{"$error":"#DIV/0!"}},null,6,0,null,null,"","",null,null,""]
[7,0,null,null,{"$f":"IF(C92=0,\"\",D92-C92)","v":""},{"$f":"IF(C92=0,\"\",E92/C92)","v":""},null,null,"",null,null,null,null,null,"(ISO11352, table B.4)",null,7,0,null,null,"","",null,null,""]
[8,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,8,0,null,null,"","",null,null,""]
[9,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,9,0,null,null,"","",null,null,""]
[10,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,10,0,null,null,"","",null,null,""]
[11,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,11,0,null,null,"","",null,null,""]
[12,0,null,null,"","",null,null,{"$f":"IF(H97=0,\"\",$I$83*G97/SQRT(H97))","v":""},null,null,null,null,null,null,null,12,0,null,null,"","",null,null,""]
[13,0,null,null,"","",null,null,{"$f":"IF(H98=0,\"\",$I$83*G98/SQRT(H98))","v":""},null,null,null,null,null,null,null,13,0,null,null,"","",null,null,""]
[14,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,14,0,null,null,"","",null,null,""]
[15,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,15,0,null,null,"","",null,null,""]
[16,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,16,0,null,null,"","",null,null,""]
[17,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,17,0,null,null,"","",null,null,""]
[18,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,18,0,null,null,"","",null,null,""]
[19,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,19,0,null,null,"","",null,null,""]
[20,0,null,null,"","",null,null,"",null,null,null,null,null,null,null,20,0,null,null,"","",null,null,""]
["mean",null,null,{"$f":"AVERAGE(D86:D105)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E86:E105)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F86:F105)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(I86:I105)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"mean",null,null,{"$f":"AVERAGE(T86:T105)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(U86:U105)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(V86:V105)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(Y86:Y105)","v":{"$error":"#DIV/0!"}}]
["stdev",null,null,{"$f":"STDEV(D86:D105)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(E86:E105)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(F86:F105)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"STDEV(I86:I105)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"stdev",null,null,{"$f":"STDEV(T86:T105)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(U86:U105)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(V86:V105)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"STDEV(Y86:Y105)","v":{"$error":"#DIV/0!"}}]
["Relative rms deviation","Drms,rel","= ub,rel",null,null,{"$f":"SQRT(SUMSQ(F86:F105)/F109)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"rms deviation","Drms","= ub,abs",null,{"$f":"SQRT(SUMSQ(U86:U105)/U109)","v":{"$error":"#DIV/0!"}}]
["no. measurements","nM",{"$f":"COUNT(C86:C105)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,"no. measurements","nM",{"$f":"COUNT(S86:S105)","v":0},0,0,0,0,0,0]
["Relative uncertainty in bias","ub,rel",null,{"$f":"SQRT(F108^2+I106^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"uncertainty in bias","ub",null,{"$f":"SQRT(U108^2+Y106^2)","v":{"$error":"#DIV/0!"}}]
["Within lab. reproducibility","CV=uRw,rel",null,null,"(from control chart)",null,null,null,null,null,null,null,null,null,null,null,"Within lab. reproducibility","CV=uRw",null,null,"(from control chart)"]
["Combined uncertainty","uc,rel",null,{"$f":"SQRT(SUMSQ(D110:D111))","v":{"$error":"#DIV/0!"}},"expanded",{"$f":"D112*H5","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"Combined uncertainty","uc",null,{"$f":"SQRT(SUMSQ(T110:T111))","v":{"$error":"#DIV/0!"}},"expanded =",{"$f":"T112*2","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"(ISO11352, table B.2)"]
[]
["H.  Standard addition calculations",null,null,"Rectangular distribution",null,null,"J. Replicates calculations",null,null,null,"K.  Standard addition, summary"]
["Amount added",null,null,"range","uncert'y",null,"Replicates",null,"mass",null,null,null,null,"uncert'y"]
["Stock standard concentration","mg/L",null,{"$f":"26/C117","v":{"$error":"#DIV/0!"}},{"$f":"D117/SQRT(3)","v":{"$error":"#DIV/0!"}},null,null,null,"uV,i,rep,rel",null,"systematic component",null,null,"uV, b"]
["systematic component (specification)",null,"V","range","uV, b",null,1,null,null,null,"Rel. rms deviation ",null,"brms,rel",{"$f":"I80","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"D119/SQRT(3)","v":0},null,2,null,null,null,"Rel. uncert'y of conc added",null,"uadd,rel"]
["vol. flask (manufacturer's)","ml",null,null,{"$f":"D120/SQRT(3)","v":0},null,3,null,null,null,"Combined uncert'y of bias",null,"ub,rel",{"$f":"SQRT(SUMSQ(N118:N119))","v":{"$error":"#DIV/0!"}}]
["vol. flask (manufacturer's)","ml",null,null,{"$f":"D121/SQRT(3)","v":0},null,4,null,null,null,"random component"]
["vol. flask (manufacturer's)","ml",null,null,{"$f":"D122/SQRT(3)","v":0},null,5,null,null,null,"Within lab. reproducibility",null,"sRw,rel",{"$f":"precision!H10","v":""}]
["vol. pipette (manufacturer's)","ml",null,null,{"$f":"D123/SQRT(3)","v":0},null,6,null,null,null,"Rel. combined uncert'y",null,"ub,rel",{"$f":"SQRT(N120^2+N122^2)","v":{"$error":"#DIV/0!"}}]
["vol. pipette (manufacturer's)","ml",null,null,{"$f":"D124/SQRT(3)","v":0},null,7,null,null,null,"Rel. expanded uncert'y",null,"Urel",{"$f":"N123*H5","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,0,null,8]
[null,null,null,null,0,null,9]
["random component (lab. calibration)",null,null,null,"uV,rep",null,10]
["vol. flask (internal QC)","ml",null,null,null,null,11]
["vol. flask (internal QC)","ml",null,null,null,null,12]
["vol. flask (internal QC)","ml",null,null,null,null,13]
["vol. pipette (internal QC)","ml",null,null,null,null,14]
["vol. pipette (internal QC)","ml",null,null,null,null,15]
[null,null,null,null,null,null,16]
[null,null,null,null,null,null,17]
["Relative uncertainty of concentration of addition solution",null,null,"uconc, rel",{"$f":"SQRT(SUMSQ(E117:E134))","v":{"$error":"#DIV/0!"}},null,18]
[null,null,null,null,null,null,19]
["volume added (syringe or pipette)",null,null,null,"uV",null,20]
["systematic uncertainty","certificate","uV,b,rel",null,{"$f":"D138/SQRT(3)","v":0},null,"mean  (Rj, rel)",null,{"$f":"AVERAGE(I118:I137)","v":{"$error":"#DIV/0!"}}]
["random uncertainty","internal QC","uV,rep,rel",null,null,null,"stdev (s)",null,{"$f":"STDEV(I118:I137)","v":{"$error":"#DIV/0!"}}]
["Relative uncertainty of volume added",null,null,"uV,rel",{"$f":"SQRT(SUMSQ(E138:E139))","v":0},null,"Coeff variation"]
["Relative uncertainty of concentration of analyte added",null,null,"uadd,rel",{"$f":"SQRT(E140^2+E135^2)","v":{"$error":"#DIV/0!"}},null,"CV=uRw,stand,rel",null,{"$f":"I139/I138","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"(ISO11352, table B.6)"]
[]
[]
["Summary table",null,null,"expansion factor =",{"$f":"$H$5","v":2},"Traceable standard"]
["Determinand","Method","Matrix","section","units","reference value","reference uncertainty","measured value","no. replicates","Relative measured uncertainty","relative bias","rel. bias uncertainty","CRMs Used"]
[null,null,null,null,"symbol (ISO11352)","Cref","uCref","cj","nM","uRw,rel","brel","ub,rel"]
[null,null,null,null,{"$f":"C4","v":0},{"$f":"C13","v":0},{"$f":"D13","v":0},{"$f":"C14","v":0},{"$f":"E14","v":0},{"$f":"IFERROR(J14*100,\"\")","v":""},{"$f":"IFERROR((H148-F148)/F148*100,\"\")","v":""},{"$f":"IF(M148=\"Single\",K14,IF(M148=\"Multiple\",K21,IF(M148=\"pH (Single)\",AK14,IF(M148=\"pH (Multiple)\",AK21,\"\"))))","v":{"$error":"#DIV/0!"}},"Multiple"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(C149/H149*100,\"\")","v":""},{"$f":"IFERROR((H149-F149)/F149*100,\"\")","v":""},{"$f":"IFERROR(SQRT(K149^2+J149^2/I149+(G149/F149*100)^2),\"\")","v":""}]
[null,null,null,null,"formula",null,null,null,null,"srw/cj","(cj - Cref)/Cref","√(brel2+(uRw)2/n+(uc.ref/Cref)2)"]
[]
[]
["Summary table",null,null,"expansion factor =",{"$f":"$H$5","v":2},"Recovery data"]
["Determinand","Method","Matrix","section","units","mean recovery %","no. measurements","Rel. rms deviation   %","Rel. uncert'y spike soln.","Rel. uncert'y of vol. added","rel. bias uncertainty"]
[null,null,null,null,"symbol (ISO11352)","η","nη","brms,rel","uconc, rel","uadd,rel","ub,rel"]
[null,null,null,null,{"$f":"C4","v":0},{"$f":"H77","v":{"$error":"#DIV/0!"}},{"$f":"H79","v":0},{"$f":"I80*100","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(H156=0,\"\",SQRT(SUMSQ(H156:J156)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H157=0,\"\",SQRT(SUMSQ(H157:J157)))","v":""}]
[null,null,null,null,"formula",null,null,"√∑b2/n",null,null,"√(brms,rel2+uconc,rel2+uadd,rel2)"]
[]
[]
["Summary table",null,null,"expansion factor =",{"$f":"$H$5","v":2},"PT data",null,"robust mean multiplier",{"$f":"I83","v":0}]
["Determinand","Method","Matrix","section","units",null,"rel. uncert'y, ass'd value","Relative rms deviation","rel. bias uncertainty"]
[null,null,null,null,"symbol (ISO11352)",null,"uC-ref,i,rel","Drms,rel","ub,rel"]
[null,null,null,null,{"$f":"C4","v":0},null,{"$f":"I106*100","v":{"$error":"#DIV/0!"}},{"$f":"F108*100","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(SQRT(SUMSQ(G164,H164)),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(#REF!,#REF!,#REF!,#REF!,#REF!,F165),\"\")","v":""},{"$f":"IFERROR(SQRT(SUMSQ(#REF!,#REF!,#REF!,#REF!,#REF!,C165)/COUNT(#REF!,#REF!,#REF!,#REF!,#REF!,C165)),\"\")","v":""},{"$f":"IF(F165=\"\",\"\",(SQRT(SUMSQ(G165,H165))))","v":""}]
[null,null,null,null,"formula",null,"(∑uc-ref,i,rel)/n","√∑Di2/n","√(uC-ref,i,rel2+Drms,rel2)"]

{"sheet":"Tables, data","index":2,"n_rows":107,"n_cols":24,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Tables and data",null,null,null,null,null,"coverage factor, k =",2]
[]
["L.  Control Chart data",null,null,null,null,"C'.  Range calculations",null,null,null,null,null,"F.  Recovery calculations",null,null,null,null,"J. Replicates calculations",null,null,null,null,null,"Q. Range chart factor"]
[null,"units","measured conc'n","bias",null,null,null,null,"batch","relative range",null,"Nominal","units","measured conc'n","relative bias",null,null,null,"mass",null,null,null,"mean range"]
["Nominal conc'n (Cref)",null,"c","b = Di",null,null,"max","min","mean","Rj, rel",null,"conc'n (Cref)",100,"η","bi,rel",null,null,null,"uV,i,rep,rel",null,null,null,"no. replicates"]
[1,"µg/ml",null,{"$f":"IF(ISBLANK(C6)=FALSE,C6-$B$5,\"\")","v":""},null,1,null,null,{"$f":"IFERROR(AVERAGE(G6:H6),\"\")","v":""},{"$f":"IF(G6=0,\"\",ABS(G6-H6)/I6)","v":""},null,1,"%",null,{"$f":"IF(ISBLANK(N6)=FALSE,(N6-$N$26)/$N$26,\"\")","v":""},null,1,null,null,null,null,null,"d2",{"$f":"VLOOKUP(X5,W10:X18,2)","v":{"$error":"#N/A"}}]
[2,{"$f":"B6","v":"µg/ml"},null,"",null,2,null,null,{"$f":"IFERROR(AVERAGE(G7:H7),\"\")","v":""},{"$f":"IF(G7=0,\"\",ABS(G7-H7)/I7)","v":""},null,2,{"$f":"M6","v":"%"},null,"",null,2,null,null,null,null,null,"sr,range = ur,range",{"$f":"X4/X6","v":{"$error":"#N/A"}}]
[3,"µg/ml",null,"",null,3,null,null,"","",null,3,"%",null,"",null,3,null,null,null,null,null,"No. of ","factor"]
[4,"µg/ml",null,"",null,4,null,null,"","",null,4,"%",null,"",null,4,null,null,null,null,null,"replicates","d2"]
[5,"µg/ml",null,"",null,5,null,null,"","",null,5,"%",null,"",null,5,null,null,null,null,null,2,1.1279999999999999]
[6,"µg/ml",null,"",null,6,null,null,"","",null,6,"%",null,"",null,6,null,null,null,null,null,3,1.6930000000000001]
[7,"µg/ml",null,"",null,7,null,null,"","",null,7,{"$f":"M11","v":"%"},null,"",null,7,null,null,null,null,null,4,2.0590000000000002]
[8,"µg/ml",null,"",null,8,null,null,"","",null,8,"%",null,"",null,8,null,null,null,null,null,5,2.3260000000000001]
[9,"µg/ml",null,"",null,9,null,null,"","",null,9,"%",null,"",null,9,null,null,null,null,null,6,2.5339999999999998]
[10,"µg/ml",null,"",null,10,null,null,"","",null,10,"%",null,"",null,10,null,null,null,null,null,7,2.7040000000000002]
[11,"µg/ml",null,"",null,11,null,null,"","",null,11,"%",null,"",null,11,null,null,null,null,null,8,2.847]
[12,"µg/ml",null,{"$f":"IF(ISBLANK(C17)=FALSE,C17-$B$5,\"\")","v":""},null,12,null,null,"","",null,12,{"$f":"M16","v":"%"},null,"",null,12,null,null,null,null,null,9,2.97]
[13,"µg/ml",null,"",null,13,null,null,"","",null,13,"%",null,"",null,13,null,null,null,null,null,10,3.0779999999999998]
[14,"µg/ml",null,"",null,14,null,null,"","",null,14,"%",null,"",null,14,null,null,null,null,null,null,"(ISO11352, table A.1)"]
[15,"µg/ml",null,"",null,15,null,null,"","",null,15,"%",null,"",null,15]
[16,{"$f":"B20","v":"µg/ml"},null,"",null,16,null,null,"","",null,16,"%",null,"",null,16]
[17,"µg/ml",null,"",null,17,null,null,"","",null,17,"%",null,"",null,17]
[18,{"$f":"B20","v":"µg/ml"},null,"",null,18,null,null,"","",null,18,"%",null,"",null,18]
[19,{"$f":"B23","v":"µg/ml"},null,"",null,19,null,null,"","",null,19,"%",null,"",null,19]
[20,"µg/ml",null,"",null,20,null,null,"","",null,20,{"$f":"M16","v":"%"},null,"",null,20]
[21,"µg/ml",null,"",null,"mean  (Rj, rel)",{"$f":"AVERAGE(G6:G25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H6:H25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(I6:I25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J6:J25)","v":{"$error":"#DIV/0!"}},null,"mean",null,{"$f":"AVERAGE(N6:N25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O6:O25)","v":{"$error":"#DIV/0!"}},null,"mean  (Rj, rel)",null,{"$f":"AVERAGE(S6:S25)","v":{"$error":"#DIV/0!"}}]
[22,"µg/ml",null,"",null,"st.deviation",{"$f":"STDEV(G6:G25)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(H6:H25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"st. deviation",null,{"$f":"STDEV(N6:N25)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(O6:O25)","v":{"$error":"#DIV/0!"}},null,"stdev (s)",null,{"$f":"STDEV(S6:S25)","v":{"$error":"#DIV/0!"}}]
[23,"µg/ml",null,"",null,"no. replicates",null,"n",null,null,null,"no. measurements","nM",{"$f":"COUNT(N6:N25)","v":0},null,null,"Coeff variation"]
[24,"µg/ml",null,"",null,"range chart factor ",null,"d2",null,{"$f":"VLOOKUP(J28, 'Tables, data'!W10:X18,2)","v":{"$error":"#N/A"}},null,"RMS deviation (rel) ",null,"brms,rel",{"$f":"SQRT(SUMSQ(O6:O25)/N28)","v":{"$error":"#DIV/0!"}},null,"  CV=uRw,stand,rel ",null,{"$f":"S27/S26","v":{"$error":"#DIV/0!"}}]
[25,"µg/ml",null,"",null,"Coefficient of variation (Cv)",null," ur,range,rel",null,{"$f":"J26/J29","v":{"$error":"#DIV/0!"}},null,null,null,null,"(ISO11352, table B.5)",null,null,null,"(ISO11352, table B.6)"]
[26,"µg/ml",null,"",null,null,null,null,null,"(ISO11352, table B.4)"]
[27,"µg/ml",null,""]
[28,"µg/ml",null,"",null,"G.  Bias uncertainty using proficiency test data",null,null,null,null,null,null,"robust mean multiplier",null,null,"P.  Comparison of bias estimates with PT results"]
[29,"µg/ml",null,"",null,null,"units","assigned value","mean,   all labs","mean bias","relative bias","reprod'y st.dev.","no. labs","rel. uncert'y, ass'd value",null,"Significance decided at p = 0.05%",null,null,"Traceable standard","Recovery tests","Proficency Test"]
[30,"µg/ml",null,"",null,"Test number",null,"cass","c","b = Di","Di,rel","sR,i,rel","np,i","uC-ref,i,rel",null,null,null,"results from calculation block","D","E","G"]
[31,"µg/ml",null,"",null,1,"µg/ml",null,null,{"$f":"I36-H36","v":0},{"$f":"J36/H36","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IFERROR($N$33*L36/SQRT(M36),\"\")","v":""},null,null,"mean bias","b"]
[32,"µg/ml",null,"",null,2,{"$f":"G36","v":"µg/ml"},null,null,0,{"$error":"#DIV/0!"},null,null,"",null,null,"uncertainty in bias","ub"]
[33,"µg/ml",null,{"$f":"IF(ISBLANK(C38)=FALSE,C38-$B$5,\"\")","v":""},null,3,"µg/ml",null,null,0,{"$error":"#DIV/0!"},null,null,"",null,null,"degrees of freedom","nM -1"]
[34,"µg/ml",null,"",null,4,"µg/ml",null,null,0,{"$error":"#DIV/0!"},null,null,"",null,"comparison of uncertainty"]
[35,"µg/ml",null,"",null,5,"µg/ml",null,null,0,{"$error":"#DIV/0!"},null,null,{"$f":"IFERROR($N$33*L40/SQRT(M40),\"\")","v":""},null,null,"statistic","F =",{"$f":"(S37/U37)^2","v":{"$error":"#DIV/0!"}},{"$f":"(T37/U37)^2","v":{"$error":"#DIV/0!"}}]
[36,"µg/ml",null,"",null,6,"µg/ml",null,null,0,{"$error":"#DIV/0!"},null,null,"",null,null,"probability","p =",{"$f":"FDIST(S40,S38,U38)","v":{"$error":"#DIV/0!"}},{"$f":"FDIST(T40,S38,U38)","v":{"$error":"#DIV/0!"}}]
[37,{"$f":"B41","v":"µg/ml"},null,"",null,7,"µg/ml",null,null,{"$f":"IF(H42=0,\"\",I42-H42)","v":""},{"$f":"IF(H42=0,\"\",J42/H42)","v":""},null,null,"",null,null,null,"difference in uncertainty",{"$f":"IF(S40>FINV(0.05,U38,S38),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(T40>FINV(0.05,U38,T38),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}}]
[38,"µg/ml",null,"",null,8,"µg/ml",null,null,"","",null,null,""]
[39,"µg/ml",null,"",null,9,"µg/ml",null,null,"","",null,null,"",null,"comparison of bias"]
[40,"µg/ml",null,"",null,10,"µg/ml",null,null,"","",null,null,"",null,null,"pooled sd",null,{"$f":"SQRT((S37^2*S38+U37^2*U38)/(S46))","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((T37^2*T38+U37^2*U38)/(T46))","v":{"$error":"#DIV/0!"}}]
[41,"µg/ml",null,"",null,11,"µg/ml",null,null,"","",null,null,"",null,null,"total df.",null,{"$f":"S38+U38","v":0},{"$f":"T38+U38","v":0}]
[42,"µg/ml",null,"",null,12,"µg/ml",null,null,"","",null,null,"",null,null,"statistic","t =",{"$f":"ABS(S36-U36)/SQRT((S38)^-1+(U38)^-1)/S45","v":{"$error":"#DIV/0!"}},{"$f":"ABS(T36-U36)/SQRT((T38)^-1+(U38)^-1)/T45","v":{"$error":"#DIV/0!"}}]
[43,"µg/ml",null,"",null,13,"µg/ml",null,null,"","",null,null,"",null,null,"probability","p =",{"$f":"TDIST(S47,S46,2)","v":{"$error":"#DIV/0!"}},{"$f":"TDIST(T47,T46,2)","v":{"$error":"#DIV/0!"}}]
[44,"µg/ml",null,"",null,14,"µg/ml",null,null,"","",null,null,"",null,null,null,"difference in bias",{"$f":"IF(S47>TINV(0.05,S46),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(T47>TINV(0.05,T46),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}}]
[45,"µg/ml",null,"",null,15,"µg/ml",null,null,"","",null,null,""]
[46,"µg/ml",null,"",null,16,"µg/ml",null,null,"","",null,null,""]
[47,"µg/ml",null,"",null,17,"µg/ml",null,null,"","",null,null,""]
[48,"µg/ml",null,"",null,18,"µg/ml",null,null,"","",null,null,""]
[49,"µg/ml",null,"",null,19,"µg/ml",null,null,"","",null,null,""]
[50,"µg/ml",null,"",null,20,"µg/ml",null,null,"","",null,null,""]
[51,"µg/ml",null,"",null,"mean","µg/ml",null,{"$f":"AVERAGE(I36:I55)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J36:J55)","v":0},{"$f":"AVERAGE(K36:K55)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(N36:N55)","v":{"$error":"#DIV/0!"}}]
[52,"µg/ml",null,"",null,"st. deviation","µg/ml",null,{"$f":"STDEV(I36:I55)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(J36:J55)","v":0},{"$f":"STDEV(K36:K55)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"STDEV(N36:N55)","v":{"$error":"#DIV/0!"}}]
[53,"µg/ml",null,"",null,"Relative rms deviation","Drms,rel","= ub,rel",null,null,{"$f":"SQRT(SUMSQ(K36:K55)/K59)","v":{"$error":"#DIV/0!"}}]
[54,"µg/ml",null,"",null,"no. measurements","nM",{"$f":"COUNT(H36:H55)","v":0},0,6,0,0,0,0]
[55,"µg/ml",null,"",null,"Rel. uncertainty","ub,rel",null,{"$f":"SQRT(K58^2+N56^2)","v":{"$error":"#DIV/0!"}}]
[56,{"$f":"B60","v":"µg/ml"},null,{"$f":"IF(ISBLANK(C61)=FALSE,C61-$B$5,\"\")","v":""},null,"Within lab. reproducibility","CV","= uRw,rel",null,"(from control chart)"]
[57,"µg/ml",null,"",null,"Combined uncertainty","uc,rel",null,{"$f":"SQRT(SUMSQ(I60:I61))","v":{"$error":"#DIV/0!"}},"expanded",{"$f":"I62*H1","v":{"$error":"#DIV/0!"}}]
[58,"µg/ml",null,"",null,null,null,null,null,null,null,null,null,"(ISO11352, table B.2)"]
[59,"µg/ml",null,""]
[60,"µg/ml",null,""]
[61,"µg/ml",null,""]
[62,"µg/ml",null,""]
[63,"µg/ml",null,""]
[64,"µg/ml",null,""]
[65,"µg/ml",null,""]
["mean (c)",null,{"$f":"AVERAGE(C6:C70)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D6:D70)","v":{"$error":"#DIV/0!"}}]
["stdev (sRw)",null,{"$f":"STDEV(C6:C70)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D6:D70)","v":{"$error":"#DIV/0!"}}]
["no. measurements (nM)",null,{"$f":"COUNT(C6:C70)","v":0},{"$f":"COUNT(D6:D70)","v":0}]
["Coeff var'n    (CV)","= uRw,rel",{"$f":"C72/C71","v":{"$error":"#DIV/0!"}}]
[null,null,null,"(ISO11352, table B.1)"]
[]
["Table of terms and symbols"]
["magenta text for data to be entered",null,null,"black for formulae;  bold for intermediate and final results"]
["relative expanded UoM            ",null,null,"The uncertainty to be quoted on certificates"]
["rel. bias uncertainty",null,"ub,rel","the prefered bias uncertainty is chosen for combining with the precision"]
["AQC standard",null,"Cref","concentration of the standard in the control chart"]
["control chart  mean",null,"cj","mean value of measurements in the control chart"]
["control chart st.dev.",null,"srw","standard deviation of control chart values"]
["rel. within lab. reproducibility",null,"uRw,rel","Precision or with-in laboratory reproducibility"]
["AQC  rel bias       %",null,"brel","bias shown by the control chart; not used in the calculations"]
["reference value",null,"Cref","certificate value of the CRM"]
["reference uncertainty",null,"uCref","uncertainty in the certificate value"]
["measured value",null,"cj","mean of laboratory measurements"]
["no. replicates",null,"nM","no. measurements made"]
["Relative measured uncertainty",null,"uRw,rel","control chart st.dev. divided by the mean"]
["relative bias",null,"brel","differnce of mean from certificate value divided by the mean"]
["rel. bias uncertainty",null,"ub,rel","uncertainty due to bias as measured against a CRM"]
["mean recovery %",null,"η","mean recovery from a series of spiked samples"]
["no. measurements",null,"nη","no. measurements made"]
["Rel. rms deviation   %",null,"brms,rel","rms of the relative difference between the measurement and the spiked concentration"]
["Rel. uncert'y of sol'n conc",null,"uconc, rel","uncertainty in the concentration of the standard used to spike the samples"]
["Rel. uncert'y of vol. added",null,"uadd,rel","uncertainty in the spike volume"]
["rel. bias uncertainty",null,"ub,rel","uncertainty due to bias as measured against recovery data"]
["assigned value",null,"cass","nominal value or the concentration of the sample supplied by the PT scheme"]
["own lab result",null,"c","the laboratory result"]
["relative bias",null,"Di,rel","the difference between lab. and assigned values"]
["reproducibility st.dev.",null,"sR,i,rel","standard deviation from the PT scheme"]
["no. labs",null,"np,i","no. participating labs"]
["rel. uncert'y, ass'd value",null,"uC-ref,i,rel","uncertainty in the assigned value (modified for a robust mean)"]
["rel. uncert'y, ass'd value",null,"uC-ref,i,rel","mean of the uncertainties in the assigned value"]
["Relative rms deviation",null,"Drms,rel","mean of the difference between lab. and assigned value"]
["rel. bias uncertainty",null,"ub,rel","uncertainty due to bias as measured against a PT scheme"]

{"sheet":"control chart","index":3,"n_rows":69,"n_cols":25,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Control chart",null,null,null,"(data copied from block L in 'Tables, data')"]
[]
[null,null,"AQC ",null,null,"Limits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"limits"]
["point","QC std","failure",null,null,"AL","WL","mean","WL","AL",null,null,null,null,null,null,null,null,null,null,"AL","WL","centre","WL","AL"]
[1,{"$f":"IF('Tables, data'!C6>0,'Tables, data'!C6,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(B5)=TRUE,\"\",IF(ABS(B5-$H$5)>($H$5-$F$5),\"action\",IF(ABS(B5-$H$5)>($H$5-$G$5),\"warning\",\"\"))),\"\")","v":""},null,null,{"$f":"$Q$32-$Q$36","v":0},{"$f":"$Q$32-$Q$35","v":0},{"$f":"$Q$32","v":0},{"$f":"$Q$32+$Q$35","v":0},{"$f":"$Q$32+$Q$36","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":0},{"$f":"G5","v":0},{"$f":"H5","v":0},{"$f":"I5","v":0},{"$f":"J5","v":0}]
[2,{"$f":"IF('Tables, data'!C7>0,'Tables, data'!C7,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U5","v":0},{"$f":"V5","v":0},{"$f":"W5","v":0},{"$f":"X5","v":0},{"$f":"Y5","v":0}]
[3,{"$f":"IF('Tables, data'!C8>0,'Tables, data'!C8,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U6","v":0},0,0,0,0]
[4,{"$f":"IF('Tables, data'!C9>0,'Tables, data'!C9,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[5,{"$f":"IF('Tables, data'!C10>0,'Tables, data'!C10,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[6,{"$f":"IF('Tables, data'!C11>0,'Tables, data'!C11,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[7,{"$f":"IF('Tables, data'!C12>0,'Tables, data'!C12,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[8,{"$f":"IF('Tables, data'!C13>0,'Tables, data'!C13,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U11","v":0},0,0,0,0]
[9,{"$f":"IF('Tables, data'!C14>0,'Tables, data'!C14,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U12","v":0},0,0,0,0]
[10,{"$f":"IF('Tables, data'!C15>0,'Tables, data'!C15,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U13","v":0},0,0,0,0]
[11,{"$f":"IF('Tables, data'!C16>0,'Tables, data'!C16,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U14","v":0},0,0,0,0]
[12,{"$f":"IF('Tables, data'!C17>0,'Tables, data'!C17,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U15","v":0},0,0,0,0]
[13,{"$f":"IF('Tables, data'!C18>0,'Tables, data'!C18,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U16","v":0},0,0,0,0]
[14,{"$f":"IF('Tables, data'!C19>0,'Tables, data'!C19,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U17","v":0},0,0,0,0]
[15,{"$f":"IF('Tables, data'!C20>0,'Tables, data'!C20,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U18","v":0},0,0,0,0]
[16,{"$f":"IF('Tables, data'!C21>0,'Tables, data'!C21,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U19","v":0},0,0,0,0]
[17,{"$f":"IF('Tables, data'!C22>0,'Tables, data'!C22,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U20","v":0},0,0,0,0]
[18,{"$f":"IF('Tables, data'!C23>0,'Tables, data'!C23,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21","v":0},0,0,0,0]
[19,{"$f":"IF('Tables, data'!C24>0,'Tables, data'!C24,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U22","v":0},0,0,0,0]
[20,{"$f":"IF('Tables, data'!C25>0,'Tables, data'!C25,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U23","v":0},0,0,0,0]
[21,{"$f":"IF('Tables, data'!C26>0,'Tables, data'!C26,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U24","v":0},0,0,0,0]
[22,{"$f":"IF('Tables, data'!C27>0,'Tables, data'!C27,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U25","v":0},0,0,0,0]
[23,{"$f":"IF('Tables, data'!C28>0,'Tables, data'!C28,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U26","v":0},0,0,0,0]
[24,{"$f":"IF('Tables, data'!C29>0,'Tables, data'!C29,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U27","v":0},0,0,0,0]
[25,{"$f":"IF('Tables, data'!C30>0,'Tables, data'!C30,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U28","v":0},0,0,0,0]
[26,{"$f":"IF('Tables, data'!C31>0,'Tables, data'!C31,\"\")","v":""},"",null,"Compare data with set-up values",null,null,null,null,"Data summary",null,null,null,null,"Chart set-up values",null,null,null,null,null,{"$f":"U29","v":0},0,0,0,0]
[27,{"$f":"IF('Tables, data'!C32>0,'Tables, data'!C32,\"\")","v":""},"",null,"st dev","F =",{"$f":"(L33/Q33)^2","v":{"$error":"#DIV/0!"}},null,null,"mean","mg/l",{"$f":"AVERAGE(B5:B69)","v":{"$error":"#DIV/0!"}},null,null,"nominal value","mg/l",null,null,null,null,{"$f":"U30","v":0},0,0,0,0]
[28,{"$f":"IF('Tables, data'!C33>0,'Tables, data'!C33,\"\")","v":""},"",null,"probability",null,{"$f":"FDIST(G31,L34,Q34)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G31>FINV(0.05,L34,Q34),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},null,"bias","mg/l",{"$f":"L31-Q31","v":{"$error":"#DIV/0!"}},{"$f":"H37","v":{"$error":"#DIV/0!"}},null,"central value","mg/l",null,"validation",null,null,{"$f":"U31","v":0},0,0,0,0]
[29,{"$f":"IF('Tables, data'!C34>0,'Tables, data'!C34,\"\")","v":""},"",null,"pooled sd",null,{"$f":"SQRT((L33^2*L34+Q33^2*Q34)/(L34+Q34))","v":{"$error":"#DIV/0!"}},null,null,"st dev","mg/l",{"$f":"STDEV(B5:B69)","v":{"$error":"#DIV/0!"}},null,null,"st dev","mg/l",null,"validation",null,null,{"$f":"U32","v":0},0,0,0,0]
[30,{"$f":"IF('Tables, data'!C35>0,'Tables, data'!C35,\"\")","v":""},"",null,"degrees of freedom",null,{"$f":"L34+Q34","v":-1},null,null,"degrees of freedom",null,{"$f":"COUNT(B5:B69)-1","v":-1},null,null,"degrees of freedom",null,null,null,null,null,{"$f":"U33","v":0},0,0,0,0]
[31,{"$f":"IF('Tables, data'!C36>0,'Tables, data'!C36,\"\")","v":""},"",null,"means",null,null,null,null,"WL     ±","mg/l",{"$f":"L33*2","v":{"$error":"#DIV/0!"}},null,null,"WL  ±","mg/l",{"$f":"Q33*2","v":0},null,null,null,{"$f":"U34","v":0},0,0,0,0]
[32,{"$f":"IF('Tables, data'!C37>0,'Tables, data'!C37,\"\")","v":""},"",null,{"$f":"O31","v":"nominal value"},"t =",{"$f":"ABS(L31-Q31)*SQRT(L34)/L33","v":{"$error":"#DIV/0!"}},null,null,"AL      ±","mg/l",{"$f":"L33*3","v":{"$error":"#DIV/0!"}},null,null,"AL   ±","mg/l",{"$f":"Q33*3","v":0},null,null,null,{"$f":"U35","v":0},0,0,0,0]
[33,{"$f":"IF('Tables, data'!C38>0,'Tables, data'!C38,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(B37)=TRUE,\"\",IF(ABS(B37-$H$5)>($H$5-$F$5),\"action\",IF(ABS(B37-$H$5)>($H$5-$G$5),\"warning\",\"\"))),\"\")","v":""},null,"probability",null,{"$f":"TDIST(G36,L34,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G36>TINV(0.05,G34),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},null,"st.dev. of the mean",null,{"$f":"L33/SQRT(L34+1)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"U36","v":0},0,0,0,0]
[34,{"$f":"IF('Tables, data'!C39>0,'Tables, data'!C39,\"\")","v":""},"",null,{"$f":"O32","v":"central value"},"t =",{"$f":"ABS(L31-Q32)/SQRT((L34)^-1+(Q34)^-1)/G33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U37","v":0},0,0,0,0]
[35,{"$f":"IF('Tables, data'!C40>0,'Tables, data'!C40,\"\")","v":""},"",null,"probability",null,{"$f":"TDIST(G38,G34,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G38>TINV(0.05,G34),\"sig\",\"ns\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U38","v":0},0,0,0,0]
[36,{"$f":"IF('Tables, data'!C41>0,'Tables, data'!C41,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U39","v":0},0,0,0,0]
[37,{"$f":"IF('Tables, data'!C42>0,'Tables, data'!C42,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U40","v":0},0,0,0,0]
[38,{"$f":"IF('Tables, data'!C43>0,'Tables, data'!C43,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U41","v":0},0,0,0,0]
[39,{"$f":"IF('Tables, data'!C44>0,'Tables, data'!C44,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U42","v":0},0,0,0,0]
[40,{"$f":"IF('Tables, data'!C45>0,'Tables, data'!C45,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U43","v":0},0,0,0,0]
[41,{"$f":"IF('Tables, data'!C46>0,'Tables, data'!C46,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U44","v":0},0,0,0,0]
[42,{"$f":"IF('Tables, data'!C47>0,'Tables, data'!C47,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U45","v":0},0,0,0,0]
[43,{"$f":"IF('Tables, data'!C48>0,'Tables, data'!C48,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U46","v":0},0,0,0,0]
[44,{"$f":"IF('Tables, data'!C49>0,'Tables, data'!C49,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U47","v":0},0,0,0,0]
[45,{"$f":"IF('Tables, data'!C50>0,'Tables, data'!C50,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U48","v":0},0,0,0,0]
[46,{"$f":"IF('Tables, data'!C51>0,'Tables, data'!C51,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U49","v":0},0,0,0,0]
[47,{"$f":"IF('Tables, data'!C52>0,'Tables, data'!C52,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U50","v":0},0,0,0,0]
[48,{"$f":"IF('Tables, data'!C53>0,'Tables, data'!C53,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U51","v":0},0,0,0,0]
[49,{"$f":"IF('Tables, data'!C54>0,'Tables, data'!C54,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52","v":0},0,0,0,0]
[50,{"$f":"IF('Tables, data'!C55>0,'Tables, data'!C55,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U53","v":0},0,0,0,0]
[51,{"$f":"IF('Tables, data'!C56>0,'Tables, data'!C56,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U54","v":0},0,0,0,0]
[52,{"$f":"IF('Tables, data'!C57>0,'Tables, data'!C57,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U55","v":0},0,0,0,0]
[53,{"$f":"IF('Tables, data'!C58>0,'Tables, data'!C58,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U56","v":0},0,0,0,0]
[54,{"$f":"IF('Tables, data'!C59>0,'Tables, data'!C59,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U57","v":0},0,0,0,0]
[55,{"$f":"IF('Tables, data'!C60>0,'Tables, data'!C60,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U58","v":0},0,0,0,0]
[56,{"$f":"IF('Tables, data'!C61>0,'Tables, data'!C61,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U59","v":0},0,0,0,0]
[57,{"$f":"IF('Tables, data'!C62>0,'Tables, data'!C62,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U60","v":0},0,0,0,0]
[58,{"$f":"IF('Tables, data'!C63>0,'Tables, data'!C63,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U61","v":0},0,0,0,0]
[59,{"$f":"IF('Tables, data'!C64>0,'Tables, data'!C64,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U62","v":0},0,0,0,0]
[60,{"$f":"IF('Tables, data'!C65>0,'Tables, data'!C65,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U63","v":0},0,0,0,0]
[61,{"$f":"IF('Tables, data'!C66>0,'Tables, data'!C66,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U64","v":0},0,0,0,0]
[62,{"$f":"IF('Tables, data'!C67>0,'Tables, data'!C67,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U65","v":0},0,0,0,0]
[63,{"$f":"IF('Tables, data'!C68>0,'Tables, data'!C68,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U66","v":0},0,0,0,0]
[64,{"$f":"IF('Tables, data'!C69>0,'Tables, data'!C69,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U67","v":0},0,0,0,0]
[65,{"$f":"IF('Tables, data'!C70>0,'Tables, data'!C70,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(B69)=TRUE,\"\",IF(ABS(B69-$H$5)>($H$5-$F$5),\"action\",IF(ABS(B69-$H$5)>($H$5-$G$5),\"warning\",\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U68","v":0},0,0,0,0]

{"sheet":"Amendments","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Amendments V1.2 "]
[null,"The following have been updated in the calculations file on the bias tab:"]
[null,"the RMS calculation changed from using relative bias to mean bias (this corrects the relative values to absolute);"]
[null,"the Di error, test numbers 1-6 updated from ‘=mean bias’ to ‘mean bias/assigned value’;"]
[null,"formula for test numbers 7 – 20 corrected for relative uncertainty assigned value column as #REF! error was being displayed, formula from test 1-6 copied down;"]
[null,"removed ‘rel’ from Cv=uRw;"]
[null,"separate robust mean multiplier added above table G2 and formula amended from I83 to Y83 accordingly"]
[null,"D2 - new blocks added to accommodate up to 6 different CRMs, correct calculation as per ISO (relative terms, %)"]
[null,"D3 – new block added in based on D1 (for pH in absolute terms)"]
[null,"D4 - new blocks added to accommodate up to 6 different CRMs, correct calculation as per ISO (absolute terms for pH)"]
[null,"G2 – block is the same (use of PT for pH bias estimate) as original but I’ve added a title is that it can be referenced in the BB (there wasn’t a title/reference block name)"]
[null,"- F – calculation changed in cells I47 to I76, updated to nominal 100% for recovery estimates of bias"]
[null,"- summary table - traceable standard, additional column with drop down added to specify which has been used (cell M148)"]
[null,"all data removed to leave a blank template"]