{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["total","calculation"],"read":"whole","date_system":"1900"}

{"sheet":"total","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,6],[1,0,1,2],[1,3,1,6],[2,3,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[6,0,6,6],[7,1,7,2],[7,4,8,6],[8,1,8,2],[9,0,9,6]]}
["Estimation of sampling precision"]
["for the determination of"]
["when sampling from"]
["based on \"duplicate method\" in:"]
["Eurachem/EUROLAB/ CITAC/Nordtest/AMC Guide: Measurement uncertainty arising from sampling: "]
["a guide to methods and approaches. www.eurachem.org"]
[]
["calculated by:"]
["date:",null,null,"signature:"]
[]
[]
[null,"sampling target","sample 1 /result 1","sample 1 /result 2","sample 2 /result 1","sample 2 /result 2"]
[1,"target 1"]
[2,"target 2"]
[3,"target 3"]
[4,"target 4"]
[5,"target 5"]
[6,"target 6"]
[7,"target 7"]
[8,"target 8"]
[9,"target 9"]
[10,"target 10"]
[]
[null,"total standard deviation:",null,null,{"$f":"IF(calculation!B13>7,calculation!C25,\"too less data\")","v":"too less data"},{"$f":"IF(calculation!B13>7,calculation!D25,\"too less data\")","v":"too less data"}]
[null,"between target standard deviation:",null,null,{"$f":"IF(calculation!B13>7,calculation!C23,\"too less data\")","v":"too less data"},{"$f":"IF(calculation!B13>7,calculation!D23,\"too less data\")","v":"too less data"}]
[null,"repeatability standard deviation of analysis:",null,null,{"$f":"IF(calculation!B13>7,calculation!C21,\"too less data\")","v":"too less data"},{"$f":"IF(calculation!B13>7,calculation!D21,\"too less data\")","v":"too less data"}]
[null,"sampling standard deviation:",null,null,{"$f":"IF(calculation!B13>7,calculation!C22,\"too less data\")","v":"too less data"},{"$f":"IF(calculation!B13>7,calculation!D22,\"too less data\")","v":"too less data"}]
[]
[null,"expanded sampling uncertainty (without bias; k=2):",{"$nulls":3},{"$f":"IF(calculation!B13>7,2*F27,\"too less data\")","v":"too less data"}]
[]
[]
[]
[]
[]
[null,"© 2020, Dr. Michael Koch, Institut für Siedlungswasserbau, Univ. Stuttgart, www.aqsbw.de"]
[null,"The use of this EXCEL-Sheet is free, as long as the copyright notice is not removed."]

{"sheet":"calculation","index":1,"n_rows":25,"n_cols":30,"rows_kept":25,"merged":[[16,0,16,1],[17,0,17,1],[18,0,18,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1]]}
["t=target; s=sample; r=result"]
["mean t1 / s1",{"$f":"IF(total!C13,AVERAGE(total!C13:D13),\"\")","v":""},"mean t1 / s2",{"$f":"IF(total!E13,AVERAGE(total!E13:F13),\"\")","v":""},"mean t1",{"$f":"IF(total!C13,AVERAGE(B2,D2),\"\")","v":""},"total mean",{"$f":"AVERAGE(total!C13:F22)","v":{"$error":"#DIV/0!"}},"squared difference t1",{"$f":"IF(total!C13,(calculation!F2-calculation!$H$2)^2,\"\")","v":""},"squared difference t1 / s1",{"$f":"IF(total!C13,(B2-F2)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C13,(D2-F2)^2,\"\")","v":""},"squared difference t1 / s1 / r1",{"$f":"IF(total!C13,(total!C13-calculation!B2)^2,\"\")","v":""},"squared difference t1 / s1 / r2",{"$f":"IF(total!D13,(total!D13-calculation!B2)^2,\"\")","v":""},"squared difference t1 / s2 / r1",{"$f":"IF(total!E13,(total!E13-calculation!D2)^2,\"\")","v":""},"squared difference t1 / s2 / r2",{"$f":"IF(total!F13,(total!F13-calculation!D2)^2,\"\")","v":""},"squared difference_total t1 / s1 / r1",{"$f":"IF(total!C13,(total!C13-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t1 / s1 / r2",{"$f":"IF(total!D13,(total!D13-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t1 / s2 / r1",{"$f":"IF(total!E13,(total!E13-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t1 / s2 / r2",{"$f":"IF(total!F13,(total!F13-calculation!$H$2)^2,\"\")","v":""}]
["mean t2 /s1",{"$f":"IF(total!C14,AVERAGE(total!C14:D14),\"\")","v":""},"mean t2 / s2",{"$f":"IF(total!E14,AVERAGE(total!E14:F14),\"\")","v":""},"mean t2",{"$f":"IF(total!C14,AVERAGE(B3,D3),\"\")","v":""},null,null,"squared difference t2",{"$f":"IF(total!C14,(calculation!F3-calculation!$H$2)^2,\"\")","v":""},"squared difference t2 / s1",{"$f":"IF(total!C14,(B3-F3)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C14,(D3-F3)^2,\"\")","v":""},"squared difference t2 / s1 / r1",{"$f":"IF(total!C14,(total!C14-calculation!B3)^2,\"\")","v":""},"squared difference t2 / s1 / r2",{"$f":"IF(total!D14,(total!D14-calculation!B3)^2,\"\")","v":""},"squared difference t2 / s2 / r1",{"$f":"IF(total!E14,(total!E14-calculation!D3)^2,\"\")","v":""},"squared difference t2 / s2 / r2",{"$f":"IF(total!F14,(total!F14-calculation!D3)^2,\"\")","v":""},"squared difference_total t2 / s1 / r1",{"$f":"IF(total!C14,(total!C14-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t2 / s1 / r2",{"$f":"IF(total!D14,(total!D14-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t2 / s2 / r1",{"$f":"IF(total!E14,(total!E14-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t2 / s2 / r2",{"$f":"IF(total!F14,(total!F14-calculation!$H$2)^2,\"\")","v":""}]
["mean t3 / s1",{"$f":"IF(total!C15,AVERAGE(total!C15:D15),\"\")","v":""},"mean t3 / s2",{"$f":"IF(total!E15,AVERAGE(total!E15:F15),\"\")","v":""},"mean t3",{"$f":"IF(total!C15,AVERAGE(B4,D4),\"\")","v":""},null,null,"squared difference t3",{"$f":"IF(total!C15,(calculation!F4-calculation!$H$2)^2,\"\")","v":""},"squared difference t3 / s1",{"$f":"IF(total!C15,(B4-F4)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C15,(D4-F4)^2,\"\")","v":""},"squared difference t3 / s1 / r1",{"$f":"IF(total!C15,(total!C15-calculation!B4)^2,\"\")","v":""},"squared difference t3 / s1 / r2",{"$f":"IF(total!D15,(total!D15-calculation!B4)^2,\"\")","v":""},"squared difference t3 / s2 / r1",{"$f":"IF(total!E15,(total!E15-calculation!D4)^2,\"\")","v":""},"squared difference t3 / s2 / r2",{"$f":"IF(total!F15,(total!F15-calculation!D4)^2,\"\")","v":""},"squared difference_total t3 / s1 / r1",{"$f":"IF(total!C15,(total!C15-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t3 / s1 / r2",{"$f":"IF(total!D15,(total!D15-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t3 / s2 / r1",{"$f":"IF(total!E15,(total!E15-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t3 / s2 / r2",{"$f":"IF(total!F15,(total!F15-calculation!$H$2)^2,\"\")","v":""}]
["mean t4 / s1",{"$f":"IF(total!C16,AVERAGE(total!C16:D16),\"\")","v":""},"mean t4 / s2",{"$f":"IF(total!E16,AVERAGE(total!E16:F16),\"\")","v":""},"mean t4",{"$f":"IF(total!C16,AVERAGE(B5,D5),\"\")","v":""},null,null,"squared difference t4",{"$f":"IF(total!C16,(calculation!F5-calculation!$H$2)^2,\"\")","v":""},"squared difference t4 / s1",{"$f":"IF(total!C16,(B5-F5)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C16,(D5-F5)^2,\"\")","v":""},"squared difference t4 / s1 / r1",{"$f":"IF(total!C16,(total!C16-calculation!B5)^2,\"\")","v":""},"squared difference t4 / s1 / r2",{"$f":"IF(total!D16,(total!D16-calculation!B5)^2,\"\")","v":""},"squared difference t4 / s2 / r1",{"$f":"IF(total!E16,(total!E16-calculation!D5)^2,\"\")","v":""},"squared difference t4 / s2 / r2",{"$f":"IF(total!F16,(total!F16-calculation!D5)^2,\"\")","v":""},"squared difference_total t4 / s1 / r1",{"$f":"IF(total!C16,(total!C16-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t4 / s1 / r2",{"$f":"IF(total!D16,(total!D16-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t4 / s2 / r1",{"$f":"IF(total!E16,(total!E16-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t4 / s2 / r2",{"$f":"IF(total!F16,(total!F16-calculation!$H$2)^2,\"\")","v":""}]
["mean t5 / s1",{"$f":"IF(total!C17,AVERAGE(total!C17:D17),\"\")","v":""},"mean t5 / s2",{"$f":"IF(total!E17,AVERAGE(total!E17:F17),\"\")","v":""},"mean t5",{"$f":"IF(total!C17,AVERAGE(B6,D6),\"\")","v":""},null,null,"squared difference t5",{"$f":"IF(total!C17,(calculation!F6-calculation!$H$2)^2,\"\")","v":""},"squared difference t5 / s1",{"$f":"IF(total!C17,(B6-F6)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C17,(D6-F6)^2,\"\")","v":""},"squared difference t5 / s1 / r1",{"$f":"IF(total!C17,(total!C17-calculation!B6)^2,\"\")","v":""},"squared difference t5 / s1 / r2",{"$f":"IF(total!D17,(total!D17-calculation!B6)^2,\"\")","v":""},"squared difference t5 / s2 / r1",{"$f":"IF(total!E17,(total!E17-calculation!D6)^2,\"\")","v":""},"squared difference t5 / s2 / r2",{"$f":"IF(total!F17,(total!F17-calculation!D6)^2,\"\")","v":""},"squared difference_total t5 / s1 / r1",{"$f":"IF(total!C17,(total!C17-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t5 / s1 / r2",{"$f":"IF(total!D17,(total!D17-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t5 / s2 / r1",{"$f":"IF(total!E17,(total!E17-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t5 / s2 / r2",{"$f":"IF(total!F17,(total!F17-calculation!$H$2)^2,\"\")","v":""}]
["mean t6 / s1",{"$f":"IF(total!C18,AVERAGE(total!C18:D18),\"\")","v":""},"mean t6 / s2",{"$f":"IF(total!E18,AVERAGE(total!E18:F18),\"\")","v":""},"mean t6",{"$f":"IF(total!C18,AVERAGE(B7,D7),\"\")","v":""},null,null,"squared difference t6",{"$f":"IF(total!C18,(calculation!F7-calculation!$H$2)^2,\"\")","v":""},"squared difference t6 / s1",{"$f":"IF(total!C18,(B7-F7)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C18,(D7-F7)^2,\"\")","v":""},"squared difference t6 / s1 / r1",{"$f":"IF(total!C18,(total!C18-calculation!B7)^2,\"\")","v":""},"squared difference t6 / s1 / r2",{"$f":"IF(total!D18,(total!D18-calculation!B7)^2,\"\")","v":""},"squared difference t6 / s2 / r1",{"$f":"IF(total!E18,(total!E18-calculation!D7)^2,\"\")","v":""},"squared difference t6 / s2 / r2",{"$f":"IF(total!F18,(total!F18-calculation!D7)^2,\"\")","v":""},"squared difference_total t6 / s1 / r1",{"$f":"IF(total!C18,(total!C18-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t6 / s1 / r2",{"$f":"IF(total!D18,(total!D18-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t6 / s2 / r1",{"$f":"IF(total!E18,(total!E18-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t6 / s2 / r2",{"$f":"IF(total!F18,(total!F18-calculation!$H$2)^2,\"\")","v":""}]
["mean t7 / s1",{"$f":"IF(total!C19,AVERAGE(total!C19:D19),\"\")","v":""},"mean t7 / s2",{"$f":"IF(total!E19,AVERAGE(total!E19:F19),\"\")","v":""},"mean t7",{"$f":"IF(total!C19,AVERAGE(B8,D8),\"\")","v":""},null,null,"squared difference t7",{"$f":"IF(total!C19,(calculation!F8-calculation!$H$2)^2,\"\")","v":""},"squared difference t7 / s1",{"$f":"IF(total!C19,(B8-F8)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C19,(D8-F8)^2,\"\")","v":""},"squared difference t7 / s1 / r1",{"$f":"IF(total!C19,(total!C19-calculation!B8)^2,\"\")","v":""},"squared difference t7 / s1 / r2",{"$f":"IF(total!D19,(total!D19-calculation!B8)^2,\"\")","v":""},"squared difference t7 / s2 / r1",{"$f":"IF(total!E19,(total!E19-calculation!D8)^2,\"\")","v":""},"squared difference t7 / s2 / r2",{"$f":"IF(total!F19,(total!F19-calculation!D8)^2,\"\")","v":""},"squared difference_total t7 / s1 / r1",{"$f":"IF(total!C19,(total!C19-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t7 / s1 / r2",{"$f":"IF(total!D19,(total!D19-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t7 / s2 / r1",{"$f":"IF(total!E19,(total!E19-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t7 / s2 / r2",{"$f":"IF(total!F19,(total!F19-calculation!$H$2)^2,\"\")","v":""}]
["mean t8 / s1",{"$f":"IF(total!C20,AVERAGE(total!C20:D20),\"\")","v":""},"mean t8 / s2",{"$f":"IF(total!E20,AVERAGE(total!E20:F20),\"\")","v":""},"mean t8",{"$f":"IF(total!C20,AVERAGE(B9,D9),\"\")","v":""},null,null,"squared difference t8",{"$f":"IF(total!C20,(calculation!F9-calculation!$H$2)^2,\"\")","v":""},"squared difference t8 / s1",{"$f":"IF(total!C20,(B9-F9)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C20,(D9-F9)^2,\"\")","v":""},"squared difference t8 / s1 / r1",{"$f":"IF(total!C20,(total!C20-calculation!B9)^2,\"\")","v":""},"squared difference t8 / s1 / r2",{"$f":"IF(total!D20,(total!D20-calculation!B9)^2,\"\")","v":""},"squared difference t8 / s2 / r1",{"$f":"IF(total!E20,(total!E20-calculation!D9)^2,\"\")","v":""},"squared difference t8 / s2 / r2",{"$f":"IF(total!F20,(total!F20-calculation!D9)^2,\"\")","v":""},"squared difference_total t8 / s1 / r1",{"$f":"IF(total!C20,(total!C20-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t8 / s1 / r2",{"$f":"IF(total!D20,(total!D20-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t8 / s2 / r1",{"$f":"IF(total!E20,(total!E20-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t8 / s2 / r2",{"$f":"IF(total!F20,(total!F20-calculation!$H$2)^2,\"\")","v":""}]
["mean t9 / s1",{"$f":"IF(total!C21,AVERAGE(total!C21:D21),\"\")","v":""},"mean t9 / s2",{"$f":"IF(total!E21,AVERAGE(total!E21:F21),\"\")","v":""},"mean t9",{"$f":"IF(total!C21,AVERAGE(B10,D10),\"\")","v":""},null,null,"squared difference t9",{"$f":"IF(total!C21,(calculation!F10-calculation!$H$2)^2,\"\")","v":""},"squared difference t9 / s1",{"$f":"IF(total!C21,(B10-F10)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C21,(D10-F10)^2,\"\")","v":""},"squared difference t9 / s1 / r1",{"$f":"IF(total!C21,(total!C21-calculation!B10)^2,\"\")","v":""},"squared difference t9 / s1 / r2",{"$f":"IF(total!D21,(total!D21-calculation!B10)^2,\"\")","v":""},"squared difference t9 / s2 / r1",{"$f":"IF(total!E21,(total!E21-calculation!D10)^2,\"\")","v":""},"squared difference t9 / s2 / r2",{"$f":"IF(total!F21,(total!F21-calculation!D10)^2,\"\")","v":""},"squared difference_total t9 / s1 / r1",{"$f":"IF(total!C21,(total!C21-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t9 / s1 / r2",{"$f":"IF(total!D21,(total!D21-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t9 / s2 / r1",{"$f":"IF(total!E21,(total!E21-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t9 / s2 / r2",{"$f":"IF(total!F21,(total!F21-calculation!$H$2)^2,\"\")","v":""}]
["mean t10 / s1",{"$f":"IF(total!C22,AVERAGE(total!C22:D22),\"\")","v":""},"mean t10 / s2",{"$f":"IF(total!E22,AVERAGE(total!E22:F22),\"\")","v":""},"mean t10",{"$f":"IF(total!C22,AVERAGE(B11,D11),\"\")","v":""},null,null,"squared difference t10",{"$f":"IF(total!C22,(calculation!F11-calculation!$H$2)^2,\"\")","v":""},"squared difference t10 / s1",{"$f":"IF(total!C22,(B11-F11)^2,\"\")","v":""},"squared difference t1 / s2",{"$f":"IF(total!C22,(D11-F11)^2,\"\")","v":""},"squared difference t10 / s1 / r1",{"$f":"IF(total!C22,(total!C22-calculation!B11)^2,\"\")","v":""},"squared difference t10 / s1 / r2",{"$f":"IF(total!D22,(total!D22-calculation!B11)^2,\"\")","v":""},"squared difference t10 / s2 / r1",{"$f":"IF(total!E22,(total!E22-calculation!D11)^2,\"\")","v":""},"squared difference t10 / s2 / r2",{"$f":"IF(total!F22,(total!F22-calculation!D11)^2,\"\")","v":""},"squared difference_total t10 / s1 / r1",{"$f":"IF(total!C22,(total!C22-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t10 / s1 / r2",{"$f":"IF(total!D22,(total!D22-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t10 / s2 / r1",{"$f":"IF(total!E22,(total!E22-calculation!$H$2)^2,\"\")","v":""},"squared difference_total t10 / s2 / r2",{"$f":"IF(total!F22,(total!F22-calculation!$H$2)^2,\"\")","v":""}]
[]
["number of targets a",{"$f":"COUNT(total!C13:C22)","v":0},{"$nulls":6},"SS(between targets)",{"$f":"B14*B15*SUM(J2:J11)","v":0},null,null,"SS(between samples)",{"$f":"B15*SUM(L2:L11,N2:N11)","v":0},{"$nulls":6},"SS(within samples)",{"$f":"SUM(P2:P11,R2:R11,T2:T11,V2:V11)","v":0},{"$nulls":6},"SS(total)",{"$f":"SUM(X2:X11,T2:T11,AB2:AB11,AD2:AD11)","v":0}]
["number of samples per target",2,{"$nulls":6},"MS(between targets)",{"$f":"J13/(B13-1)","v":0},null,null,"MS(between samples)",{"$f":"N13/B13/(B14-1)","v":{"$error":"#DIV/0!"}},{"$nulls":6},"MS(within samples)",{"$f":"V13/(B13*B14*(B15-1))","v":{"$error":"#DIV/0!"}}]
["number of results per sample",2]
[]
["variance(within sample)",null,{"$f":"V14","v":{"$error":"#DIV/0!"}}]
["variance(between sample, within target)",null,{"$f":"(N14-V14)/B15","v":{"$error":"#DIV/0!"}}]
["variance(between targets)",null,{"$f":"(J14-N14)/(B15*B14)","v":{"$error":"#DIV/0!"}}]
["total variance",null,{"$f":"SUM(C17:C19)","v":{"$error":"#DIV/0!"}}]
["SD (within sample)",null,{"$f":"IF(C17>0,SQRT(C17),0)","v":{"$error":"#DIV/0!"}},{"$f":"C21/$H$2","v":{"$error":"#DIV/0!"}},"analysis"]
["SD (between sample, within target)",null,{"$f":"IF(C18>0,SQRT(C18),0)","v":{"$error":"#DIV/0!"}},{"$f":"C22/$H$2","v":{"$error":"#DIV/0!"}},"sampling"]
["SD (between target)",null,{"$f":"IF(C19>0,SQRT(C19),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"between target"]
["SD measurement",null,{"$f":"SQRT(SUMSQ(C21:C22))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"measurement"]
["total SD",null,{"$f":"SQRT(C20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},"total"]