{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Ex. Strategy 1- Balanced ","Ex. Strategy 1- Unbalanced","Ex. Strategy 2","BLANK Strategy 1","BLANK Strategy 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Ex. Strategy 1- Balanced ","index":0,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Strategy 1 - Balanced:"]
["User instructions:"]
["Enter silica concentration data in columns C (GP=Ground person) and D (OP=Operator) (RED cells)."]
["If there are no data for a day at a site, then enter as \"-1\" (missing)."]
["If there are no data for a particular site, then \"-1\" is entered for all three days at the site."]
["The 95% upper confidence limits are computed at the bottom of the worksheet in Cells M43 (Ground person) and N43 (Operator)."]
[]
[null,null,"Silica Conc. (mg/m3)",null,"ln(measurement)",null,"No. measurements",null,"Site mean",null,"Degrees of freedom",null,"Within site variance"]
["Site","Day","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP"]
[1,1,5.0699999999999999E-3,1.32E-2,{"$f":"IF(C10>0,LN(C10),\" \")","v":-5.2844144613790451},{"$f":"IF(D10>0,LN(D10),\" \")","v":-4.3275384493898121},{"$f":"COUNT(E10:E12)","v":3},{"$f":"COUNT(F10:F12)","v":3},{"$f":"IF(G10>0,AVERAGE(E10:E12),\" \")","v":-5.6448442904751994},{"$f":"IF(H10>0,AVERAGE(F10:F12),\" \")","v":-4.6896017056129962},{"$f":"IF(G10>1,G10-1,0)","v":2},{"$f":"IF(H10>1,H10-1,0)","v":2},{"$f":"IF(K10>0,VAR(E10:E12),\" \")","v":0.12538997976700419},{"$f":"IF(L10>0,VAR(F10:F12),\" \")","v":0.15451653628829407},1]
[1,2,3.49E-3,6.0499999999999998E-3,-5.6578535427678016,-5.1076970069393868]
[1,3,2.4979999999999998E-3,9.7199999999999995E-3,-5.9922648672787515,-4.6335696605097896]
[2,1,1.2E-2,1.52E-2,-4.4228486291941369,-4.1864598511299063,{"$f":"COUNT(E13:E15)","v":3},{"$f":"COUNT(F13:F15)","v":3},{"$f":"IF(G13>0,AVERAGE(E13:E15),\" \")","v":-5.1724313496595693},{"$f":"IF(H13>0,AVERAGE(F13:F15),\" \")","v":-4.574555580900701},{"$f":"IF(G13>1,G13-1,0)","v":2},{"$f":"IF(H13>1,H13-1,0)","v":2},{"$f":"IF(K13>0,VAR(E13:E15),\" \")","v":0.47845740571867168},{"$f":"IF(L13>0,VAR(F13:F15),\" \")","v":0.16636719166845701}]
[2,2,3.0699999999999998E-3,6.7400000000000003E-3,-5.7860777173830309,-4.9996953540579216]
[2,3,4.9500000000000004E-3,1.0699999999999999E-2,-5.3083677024015383,-4.5375115375142769]
[3,1,1.01E-2,2.3800000000000002E-2,-4.595219855134923,-3.7380696983047081,{"$f":"COUNT(E16:E18)","v":3},{"$f":"COUNT(F16:F18)","v":3},{"$f":"IF(G16>0,AVERAGE(E16:E18),\" \")","v":-4.6556344591732897},{"$f":"IF(H16>0,AVERAGE(F16:F18),\" \")","v":-3.7750230842259334},{"$f":"IF(G16>1,G16-1,0)","v":2},{"$f":"IF(H16>1,H16-1,0)","v":2},{"$f":"IF(K16>0,VAR(E16:E18),\" \")","v":0.22619565045418635},{"$f":"IF(L16>0,VAR(F16:F18),\" \")","v":8.3359806969639724E-2}]
[3,2,5.7499999999999999E-3,0.03,-5.1585554241728779,-3.5065578973199818]
[3,3,1.4800000000000001E-2,1.6899999999999998E-2,-4.213128098212068,-4.0804416570531092]
[4,1,-1,-1," "," ",{"$f":"COUNT(E19:E21)","v":0},{"$f":"COUNT(F19:F21)","v":0},{"$f":"IF(G19>0,AVERAGE(E19:E21),\" \")","v":" "},{"$f":"IF(H19>0,AVERAGE(F19:F21),\" \")","v":" "},{"$f":"IF(G19>1,G19-1,0)","v":0},{"$f":"IF(H19>1,H19-1,0)","v":0},{"$f":"IF(K19>0,VAR(E19:E21),\" \")","v":" "},{"$f":"IF(L19>0,VAR(F19:F21),\" \")","v":" "}]
[4,2,-1,-1," "," "]
[4,3,-1,-1," "," "]
[5,1,-1,-1," "," ",{"$f":"COUNT(E22:E24)","v":0},{"$f":"COUNT(F22:F24)","v":0},{"$f":"IF(G22>0,AVERAGE(E22:E24),\" \")","v":" "},{"$f":"IF(H22>0,AVERAGE(F22:F24),\" \")","v":" "},{"$f":"IF(G22>1,G22-1,0)","v":0},{"$f":"IF(H22>1,H22-1,0)","v":0},{"$f":"IF(K22>0,VAR(E22:E24),\" \")","v":" "},{"$f":"IF(L22>0,VAR(F22:F24),\" \")","v":" "}]
[5,2,-1,-1," "," "]
[5,3,-1,-1," "," "]
[{"$nulls":12},"GP","OP"]
["Notes:",{"$nulls":11},{"$f":"SUM(G10:G22)","v":9},{"$f":"SUM(H10:H22)","v":9},"No. measurements"]
["Strategy 1 assumes sampling for three days at a minimum of three sites.",{"$nulls":10},"nsites",{"$f":"IF(G22>0,5,IF(G19>0,4,IF(G16>0,3,IF(G13>0,2,IF(G10>0,1,0)))))","v":3},{"$f":"IF(H22>0,5,IF(H19>0,4,IF(H16>0,3,IF(H13>0,2,IF(H10>0,1,0)))))","v":3},"No. sites"]
["Worksheet assumes a minimum of three sites.",{"$nulls":10},"ndays",{"$f":"M26/M27","v":3},{"$f":"N26/N27","v":3},"No. days (balanced if an integer; unbalanced otherwise)"]
["The example data is balanced, but the worksheet can also handle unbalanced data.",{"$nulls":11},{"$f":"IF(G22>0,1/HARMEAN(G10:G22),IF(G19>0,1/HARMEAN(G10:G19),1/HARMEAN(G10:G16)))","v":0.33333333333333331},{"$f":"IF(H22>0,1/HARMEAN(H10:H22),IF(H19>0,1/HARMEAN(H10:H19),1/HARMEAN(H10:H16)))","v":0.33333333333333331},"nbar"]
["* These quantitites are defined above equation B-1 in the Best Practices document",{"$nulls":11},{"$f":"1-M29","v":0.66666666666666674},{"$f":"1-N29","v":0.66666666666666674},"1-nbar"]
["** These terms are defined the analysis of example data section of the Best Practices document",{"$nulls":11},{"$f":"AVERAGE(I10:I22)","v":-5.1576366997693528},{"$f":"AVERAGE(J10:J22)","v":-4.3463934569132103},"Mean of site means, on natural log scale*"]
["Additional comments are in the Unbalanced Data section of the Best Practices document",{"$nulls":11},{"$f":"STDEV(I10:I22)","v":0.49477083971786245},{"$f":"STDEV(J10:J22)","v":0.49815357048949016},"Standard deviation of site mean, on natural log scale*"]
[{"$nulls":11},"df1",{"$f":"M27-1","v":2},{"$f":"N27-1","v":2},"Degrees of freedom for sites*"]
[{"$nulls":11},"astd2ws",{"$f":"SUMPRODUCT(M10:M22,K10:K22)/SUM(K10:K22)","v":0.27668101197995404},{"$f":"SUMPRODUCT(N10:N22,L10:L22)/SUM(L10:L22)","v":0.1347478449754636},"Weighted average of within-site variances*"]
[{"$nulls":11},"astdws",{"$f":"SQRT(M34)","v":0.52600476421792419},{"$f":"SQRT(N34)","v":0.36708016151171069},"Within-site standard deviation*"]
[{"$nulls":11},"df2",{"$f":"M26-M27","v":6},{"$f":"N26-N27","v":6},"Degrees of freedom for days at sites*"]
[{"$nulls":12},{"$f":"IF(M32*M32-M29*M34>0,SQRT(M32*M32-M29*M34),0)","v":0.39060360961184259},{"$f":"IF(N32*N32-N29*N34>0,SQRT(N32*N32-N29*N34),0)","v":0.45082261640946203},"Between-site standard deviation*"]
[{"$nulls":12},{"$f":"M31+0.5*M32*M32+0.5*(M30)*M35*M35","v":-4.9430106038584753},{"$f":"N31+0.5*N32*N32+0.5*(N30)*N35*N35","v":-4.1773990186923413},"Term1**"]
[{"$nulls":12},{"$f":"(M32*TINV(0.1,M33)/SQRT(M27))^2","v":0.69574220668928544},{"$f":"(N32*TINV(0.1,N33)/SQRT(N27))^2","v":0.70528825835458386},"Term2**"]
[{"$nulls":12},{"$f":"0.5^2*M32^4*(M33/_xlfn.CHISQ.INV.RT(1-0.05,M33)-1)^2","v":5.1250622612124417},{"$f":"0.5^2*N32^4*(N33/_xlfn.CHISQ.INV.RT(1-0.05,N33)-1)^2","v":5.2666657014634222},"Term3**"]
[{"$nulls":12},{"$f":"(0.5*(M30))^2*M35^4*(M36/_xlfn.CHISQ.INV.RT(0.05,M36)-1)^2","v":2.3309623180729415E-3},{"$f":"(0.5*(N30))^2*N35^4*(N36/_xlfn.CHISQ.INV.RT(0.05,N36)-1)^2","v":5.528664019415644E-4},"Term4**"]
[{"$nulls":11},"UCL2",{"$f":"M38+SQRT(M39+M40+M41)","v":-2.5298932361741349},{"$f":"N38+SQRT(N39+N40+N41)","v":-1.7335277401222227},"Natural logarithm of upper confidence limit (equation B-1)"]
[{"$nulls":11},"UCLM",{"$f":"EXP(M42)","v":7.9667525441681819E-2},{"$f":"EXP(N42)","v":0.17666009849556116},"Upper confidence limit (MOVER method) (equation B-2)"]

{"sheet":"Ex. Strategy 1- Unbalanced","index":1,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Strategy 1 - Unbalanced:"]
["User instructions:"]
["Enter silica concentration data in columns C (GP=Ground person) and D (OP=Operator) (RED cells)."]
["If there are no data for a day at a site, then enter as \"-1\" (missing)."]
["If there are no data for a particular site, then \"-1\" is entered for all three days at the site."]
["The 95% upper confidence limits are computed at the bottom of the worksheet in Cells M43 (Ground person) and N43 (Operator)."]
[]
[null,null,"Silica Conc. (mg/m3)",null,"ln(measurement)",null,"No. measurements",null,"Site mean",null,"Degrees of freedom",null,"Within site variance"]
["Site","Day","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP"]
[1,1,5.0699999999999999E-3,1.32E-2,{"$f":"IF(C10>0,LN(C10),\" \")","v":-5.2844144613790451},{"$f":"IF(D10>0,LN(D10),\" \")","v":-4.3275384493898121},{"$f":"COUNT(E10:E12)","v":3},{"$f":"COUNT(F10:F12)","v":3},{"$f":"IF(G10>0,AVERAGE(E10:E12),\" \")","v":-5.6448442904751994},{"$f":"IF(H10>0,AVERAGE(F10:F12),\" \")","v":-4.6896017056129962},{"$f":"IF(G10>1,G10-1,0)","v":2},{"$f":"IF(H10>1,H10-1,0)","v":2},{"$f":"IF(K10>0,VAR(E10:E12),\" \")","v":0.12538997976700419},{"$f":"IF(L10>0,VAR(F10:F12),\" \")","v":0.15451653628829407}]
[1,2,3.49E-3,6.0499999999999998E-3,-5.6578535427678016,-5.1076970069393868]
[1,3,2.4979999999999998E-3,9.7199999999999995E-3,-5.9922648672787515,-4.6335696605097896]
[2,1,1.2E-2,1.52E-2,-4.4228486291941369,-4.1864598511299063,{"$f":"COUNT(E13:E15)","v":2},{"$f":"COUNT(F13:F15)","v":2},{"$f":"IF(G13>0,AVERAGE(E13:E15),\" \")","v":-5.1044631732885843},{"$f":"IF(H13>0,AVERAGE(F13:F15),\" \")","v":-4.5930776025939135},{"$f":"IF(G13>1,G13-1,0)","v":1},{"$f":"IF(H13>1,H13-1,0)","v":1},{"$f":"IF(K13>0,VAR(E13:E15),\" \")","v":0.92919677344215046},{"$f":"IF(L13>0,VAR(F13:F15),\" \")","v":0.33067599161129108}]
[2,2,3.0699999999999998E-3,6.7400000000000003E-3,-5.7860777173830309,-4.9996953540579216]
[2,3,-1,-1," "," "]
[3,1,1.01E-2,2.3800000000000002E-2,-4.595219855134923,-3.7380696983047081,{"$f":"COUNT(E16:E18)","v":3},{"$f":"COUNT(F16:F18)","v":3},{"$f":"IF(G16>0,AVERAGE(E16:E18),\" \")","v":-4.6556344591732897},{"$f":"IF(H16>0,AVERAGE(F16:F18),\" \")","v":-3.7750230842259334},{"$f":"IF(G16>1,G16-1,0)","v":2},{"$f":"IF(H16>1,H16-1,0)","v":2},{"$f":"IF(K16>0,VAR(E16:E18),\" \")","v":0.22619565045418635},{"$f":"IF(L16>0,VAR(F16:F18),\" \")","v":8.3359806969639724E-2}]
[3,2,5.7499999999999999E-3,0.03,-5.1585554241728779,-3.5065578973199818]
[3,3,1.4800000000000001E-2,1.6899999999999998E-2,-4.213128098212068,-4.0804416570531092]
[4,1,-1,-1," "," ",{"$f":"COUNT(E19:E21)","v":0},{"$f":"COUNT(F19:F21)","v":0},{"$f":"IF(G19>0,AVERAGE(E19:E21),\" \")","v":" "},{"$f":"IF(H19>0,AVERAGE(F19:F21),\" \")","v":" "},{"$f":"IF(G19>1,G19-1,0)","v":0},{"$f":"IF(H19>1,H19-1,0)","v":0},{"$f":"IF(K19>0,VAR(E19:E21),\" \")","v":" "},{"$f":"IF(L19>0,VAR(F19:F21),\" \")","v":" "}]
[4,2,-1,-1," "," "]
[4,3,-1,-1," "," "]
[5,1,-1,-1," "," ",{"$f":"COUNT(E22:E24)","v":0},{"$f":"COUNT(F22:F24)","v":0},{"$f":"IF(G22>0,AVERAGE(E22:E24),\" \")","v":" "},{"$f":"IF(H22>0,AVERAGE(F22:F24),\" \")","v":" "},{"$f":"IF(G22>1,G22-1,0)","v":0},{"$f":"IF(H22>1,H22-1,0)","v":0},{"$f":"IF(K22>0,VAR(E22:E24),\" \")","v":" "},{"$f":"IF(L22>0,VAR(F22:F24),\" \")","v":" "}]
[5,2,-1,-1," "," "]
[5,3,-1,-1," "," "]
[{"$nulls":12},"GP","OP"]
["Notes:",{"$nulls":11},{"$f":"SUM(G10:G22)","v":8},{"$f":"SUM(H10:H22)","v":8},"No. measurements"]
["Strategy 1 assumes sampling for three days at a minimum of three sites.",{"$nulls":10},"nsites",{"$f":"IF(G22>0,5,IF(G19>0,4,IF(G16>0,3,IF(G13>0,2,IF(G10>0,1,0)))))","v":3},{"$f":"IF(H22>0,5,IF(H19>0,4,IF(H16>0,3,IF(H13>0,2,IF(H10>0,1,0)))))","v":3},"No. sites"]
["The design could become unbalanced if data is missing for some days within a site.",{"$nulls":10},"ndays",{"$f":"M26/M27","v":2.6666666666666665},{"$f":"N26/N27","v":2.6666666666666665},"No. days (balanced if an integer; unbalanced otherwise)"]
["Worksheet assumes a minimum of three sites.",{"$nulls":11},{"$f":"IF(G22>0,1/HARMEAN(G10:G22),IF(G19>0,1/HARMEAN(G10:G19),1/HARMEAN(G10:G16)))","v":0.38888888888888884},{"$f":"IF(H22>0,1/HARMEAN(H10:H22),IF(H19>0,1/HARMEAN(H10:H19),1/HARMEAN(H10:H16)))","v":0.38888888888888884},"nbar"]
["The example data is unbalanced, but the worksheet can also handle balanced data.",{"$nulls":11},{"$f":"1-M29","v":0.61111111111111116},{"$f":"1-N29","v":0.61111111111111116},"1-nbar"]
["* These quantitites are defined above equation B-1 in the Best Practices document",{"$nulls":11},{"$f":"AVERAGE(I10:I22)","v":-5.1349806409790242},{"$f":"AVERAGE(J10:J22)","v":-4.3525674641442809},"Mean of site means, on natural log scale*"]
["** These terms are defined the analysis of example data section of the Best Practices document",{"$nulls":11},{"$f":"STDEV(I10:I22)","v":0.49531051822242378},{"$f":"STDEV(J10:J22)","v":0.50249115285481505},"Standard deviation of site mean, on natural log scale*"]
["Additional comments are in the Unbalanced Data section of the Best Practices document",{"$nulls":10},"df1",{"$f":"M27-1","v":2},{"$f":"N27-1","v":2},"Degrees of freedom for sites*"]
[{"$nulls":11},"astd2ws",{"$f":"SUMPRODUCT(M10:M22,K10:K22)/SUM(K10:K22)","v":0.32647360677690629},{"$f":"SUMPRODUCT(N10:N22,L10:L22)/SUM(L10:L22)","v":0.16128573562543175},"Weighted average of within-site variances*"]
[{"$nulls":11},"astdws",{"$f":"SQRT(M34)","v":0.57137868946689485},{"$f":"SQRT(N34)","v":0.40160395369746021},"Within-site standard deviation*"]
[{"$nulls":11},"df2",{"$f":"M26-M27","v":5},{"$f":"N26-N27","v":5},"Degrees of freedom for days at sites*"]
[{"$nulls":12},{"$f":"IF(M32*M32-M29*M34>0,SQRT(M32*M32-M29*M34),0)","v":0.3440502162050576},{"$f":"IF(N32*N32-N29*N34>0,SQRT(N32*N32-N29*N34),0)","v":0.43563187231464123},"Between-site standard deviation*"]
[{"$nulls":12},{"$f":"M31+0.5*M32*M32+0.5*(M30)*M35*M35","v":-4.9125585619551977},{"$f":"N31+0.5*N32*N32+0.5*(N30)*N35*N35","v":-4.1770370322433852},"Term1**"]
[{"$nulls":12},{"$f":"(M32*TINV(0.1,M33)/SQRT(M27))^2","v":0.69726081636501969},{"$f":"(N32*TINV(0.1,N33)/SQRT(N27))^2","v":0.71762407208723744},"Term2**"]
[{"$nulls":12},{"$f":"0.5^2*M32^4*(M33/_xlfn.CHISQ.INV.RT(1-0.05,M33)-1)^2","v":5.1474598190454719},{"$f":"0.5^2*N32^4*(N33/_xlfn.CHISQ.INV.RT(1-0.05,N33)-1)^2","v":5.452509635806905},"Term3**"]
[{"$nulls":12},{"$f":"(0.5*(M30))^2*M35^4*(M36/_xlfn.CHISQ.INV.RT(0.05,M36)-1)^2","v":2.9922014461634594E-3},{"$f":"(0.5*(N30))^2*N35^4*(N36/_xlfn.CHISQ.INV.RT(0.05,N36)-1)^2","v":7.3027526809659501E-4},"Term4**"]
[{"$nulls":11},"UCL2",{"$f":"M38+SQRT(M39+M40+M41)","v":-2.494354096477422},{"$f":"N38+SQRT(N39+N40+N41)","v":-1.692914655394322},"Natural logarithm of upper confidence limit (equation B-1)"]
[{"$nulls":11},"UCLM",{"$f":"EXP(M42)","v":8.2549753352408092E-2},{"$f":"EXP(N42)","v":0.18398249617272255},"Upper confidence limit (MOVER method) (equation B-2)"]

{"sheet":"Ex. Strategy 2","index":2,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Strategy 2:"]
["User instructions:"]
["Enter silica concentration data in columns C (GP=Ground person) and D (OP=Operator) (RED cells)."]
["If there are no data for a particular site, then \"-1\" is entered."]
["The 95% upper confidence limits are computed at the bottom of the worksheet in Cells K25 (Ground person) and L25 (Operator)."]
[]
[null,null,"Silica Conc. (mg/m3)",null,"ln(measurement)"]
["Site","Day","GP","OP","GP","OP"]
[1,1,5.0000000000000001E-3,1.32E-2,{"$f":"IF(C9>0,LN(C9),\" \")","v":-5.2983173665480363},-4.3275384493898121]
[2,1,1.2E-2,1.52E-2,-4.4228486291941369,-4.1864598511299063]
[3,1,0.01,2.3800000000000002E-2,-4.6051701859880909,-3.7380696983047081]
[4,1,8.0000000000000002E-3,2.12E-2,-4.8283137373023015,-3.8537540973041704]
[5,1,6.0000000000000001E-3,1.9E-2,-5.1159958097540823,-3.9633162998156966]
[6,1,-1,-1," "," "]
[7,1,-1,-1," "," "]
[{"$nulls":10},"GP","OP"]
["Notes:",{"$nulls":9},{"$f":"COUNT(E9:E15)","v":5},{"$f":"COUNT(F9:F15)","v":5},"No. measurements"]
["Strategy 2 assumes sampling for day at a minimum of five sites.",{"$nulls":9},{"$f":"AVERAGE(E9:E15)","v":-4.8541291457573292},{"$f":"AVERAGE(F9:F15)","v":-4.013827679188859},"Mean of site means, on natural log scale*"]
["* These quantitites are defined above equation B-3 in the Best Practices document",{"$nulls":9},{"$f":"STDEV(E9:E15)","v":0.35865275968968141},{"$f":"STDEV(F9:F15)","v":0.24105690677412456},"Standard deviation of site mean, on natural log scale*"]
["** These terms are defined the analysis of example data section of the Best Practices document",{"$nulls":8},"df1",{"$f":"K17-1","v":4},{"$f":"L17-1","v":4},"Degrees of freedom for sites*"]
[{"$nulls":10},{"$f":"K18+0.5*K19*K19","v":-4.7898132447408175},{"$f":"L18+0.5*L19*L19","v":-3.9847734630371043},"Term1**"]
[{"$nulls":10},{"$f":"(K19*TINV(0.1,K20)/SQRT(K17))^2","v":0.11692040951765639},{"$f":"(L19*TINV(0.1,L20)/SQRT(L17))^2","v":5.2817900347932677E-2},"Term2**"]
[{"$nulls":10},{"$f":"0.5^2*K19^4*(K20/_xlfn.CHISQ.INV.RT(1-0.05,K20)-1)^2","v":8.8600636319759285E-2},{"$f":"0.5^2*L19^4*(L20/_xlfn.CHISQ.INV.RT(1-0.05,L20)-1)^2","v":1.8080833669782737E-2},"Term3**"]
[{"$nulls":9},"UCL2",{"$f":"K21+SQRT(K22+K23)","v":-4.3364689541211874},{"$f":"L21+SQRT(L22+L23)","v":-3.7185053011819638},"Natural logarithm of upper confidence limit (equation B-3)"]
[{"$nulls":9},"UCLM",{"$f":"EXP(K24)","v":1.308264214994141E-2},{"$f":"EXP(L24)","v":2.4270217413130367E-2},"Upper confidence limit (MOVER method) (equation B-4)"]

{"sheet":"BLANK Strategy 1","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Strategy 1 - Balanced:"]
["User instructions:"]
["Enter silica concentration data in columns C (GP=Ground person) and D (OP=Operator) (RED cells)."]
["If there are no data for a day at a site, then enter as \"-1\" (missing)."]
["If there are no data for a particular site, then \"-1\" is entered for all three days at the site."]
["The 95% upper confidence limits are computed at the bottom of the worksheet in Cells M43 (Ground person) and N43 (Operator)."]
[]
[null,null,"Silica Conc. (mg/m3)",null,"ln(measurement)",null,"No. measurements",null,"Site mean",null,"Degrees of freedom",null,"Within site variance"]
["Site","Day","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP","GP","OP"]
[1,1,-1,-1,{"$f":"IF(C10>0,LN(C10),\" \")","v":" "},{"$f":"IF(D10>0,LN(D10),\" \")","v":" "},{"$f":"COUNT(E10:E12)","v":0},{"$f":"COUNT(F10:F12)","v":0},{"$f":"IF(G10>0,AVERAGE(E10:E12),\" \")","v":" "},{"$f":"IF(H10>0,AVERAGE(F10:F12),\" \")","v":" "},{"$f":"IF(G10>1,G10-1,0)","v":0},{"$f":"IF(H10>1,H10-1,0)","v":0},{"$f":"IF(K10>0,VAR(E10:E12),\" \")","v":" "},{"$f":"IF(L10>0,VAR(F10:F12),\" \")","v":" "}]
[1,2,-1,-1," "," "]
[1,3,-1,-1," "," "]
[2,1,-1,-1," "," ",{"$f":"COUNT(E13:E15)","v":0},{"$f":"COUNT(F13:F15)","v":0},{"$f":"IF(G13>0,AVERAGE(E13:E15),\" \")","v":" "},{"$f":"IF(H13>0,AVERAGE(F13:F15),\" \")","v":" "},{"$f":"IF(G13>1,G13-1,0)","v":0},{"$f":"IF(H13>1,H13-1,0)","v":0},{"$f":"IF(K13>0,VAR(E13:E15),\" \")","v":" "},{"$f":"IF(L13>0,VAR(F13:F15),\" \")","v":" "}]
[2,2,-1,-1," "," "]
[2,3,-1,-1," "," "]
[3,1,-1,-1," "," ",{"$f":"COUNT(E16:E18)","v":0},{"$f":"COUNT(F16:F18)","v":0},{"$f":"IF(G16>0,AVERAGE(E16:E18),\" \")","v":" "},{"$f":"IF(H16>0,AVERAGE(F16:F18),\" \")","v":" "},{"$f":"IF(G16>1,G16-1,0)","v":0},{"$f":"IF(H16>1,H16-1,0)","v":0},{"$f":"IF(K16>0,VAR(E16:E18),\" \")","v":" "},{"$f":"IF(L16>0,VAR(F16:F18),\" \")","v":" "}]
[3,2,-1,-1," "," "]
[3,3,-1,-1," "," "]
[4,1,-1,-1," "," ",{"$f":"COUNT(E19:E21)","v":0},{"$f":"COUNT(F19:F21)","v":0},{"$f":"IF(G19>0,AVERAGE(E19:E21),\" \")","v":" "},{"$f":"IF(H19>0,AVERAGE(F19:F21),\" \")","v":" "},{"$f":"IF(G19>0,G19-1,0)","v":0},{"$f":"IF(H19>0,H19-1,0)","v":0},{"$f":"IF(K19>0,VAR(E19:E21),\" \")","v":" "},{"$f":"IF(L19>0,VAR(F19:F21),\" \")","v":" "}]
[4,2,-1,-1," "," "]
[4,3,-1,-1," "," "]
[5,1,-1,-1," "," ",{"$f":"COUNT(E22:E24)","v":0},{"$f":"COUNT(F22:F24)","v":0},{"$f":"IF(G22>0,AVERAGE(E22:E24),\" \")","v":" "},{"$f":"IF(H22>0,AVERAGE(F22:F24),\" \")","v":" "},{"$f":"IF(G22>0,G22-1,0)","v":0},{"$f":"IF(H22>0,H22-1,0)","v":0},{"$f":"IF(K22>0,VAR(E22:E24),\" \")","v":" "},{"$f":"IF(L22>0,VAR(F22:F24),\" \")","v":" "}]
[5,2,-1,-1," "," "]
[5,3,-1,-1," "," "]
[{"$nulls":12},"GP","OP"]
["Notes:",{"$nulls":11},{"$f":"SUM(G10:G22)","v":0},{"$f":"SUM(H10:H22)","v":0},"No. measurements"]
["Strategy 1 assumes sampling for three days at a minimum of three sites.",{"$nulls":10},"nsites",{"$f":"IF(G22>0,5,IF(G19>0,4,IF(G16>0,3,IF(G13>0,2,IF(G10>0,1,0)))))","v":0},{"$f":"IF(H22>0,5,IF(H19>0,4,IF(H16>0,3,IF(H13>0,2,IF(H10>0,1,0)))))","v":0},"No. sites"]
["Worksheet assumes a minimum of three sites.",{"$nulls":10},"ndays",{"$f":"M26/M27","v":{"$error":"#DIV/0!"}},{"$f":"N26/N27","v":{"$error":"#DIV/0!"}},"No. days (balanced if an integer; unbalanced otherwise)"]
["The worksheet can handle strategy 1 data that is balanced (same number of days at each site) or unbalanced.",{"$nulls":11},{"$f":"IF(G22>0,1/HARMEAN(G10:G22),IF(G19>0,1/HARMEAN(G10:G19),1/HARMEAN(G10:G16)))","v":{"$error":"#NUM!"}},{"$f":"IF(H22>0,1/HARMEAN(H10:H22),IF(H19>0,1/HARMEAN(H10:H19),1/HARMEAN(H10:H16)))","v":{"$error":"#NUM!"}},"nbar"]
["* These quantitites are defined above equation B-1 in the Best Practices document",{"$nulls":11},{"$f":"1-M29","v":{"$error":"#NUM!"}},{"$f":"1-N29","v":{"$error":"#NUM!"}},"1-nbar"]
["** These terms are defined the analysis of example data section of the Best Practices document",{"$nulls":11},{"$f":"AVERAGE(I10:I22)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J10:J22)","v":{"$error":"#DIV/0!"}},"Mean of site means, on natural log scale*"]
["Additional comments are in the Unbalanced Data section of the Best Practices document",{"$nulls":11},{"$f":"STDEV(I10:I22)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(J10:J22)","v":{"$error":"#DIV/0!"}},"Standard deviation of site mean, on natural log scale*"]
[{"$nulls":11},"df1",{"$f":"M27-1","v":-1},{"$f":"N27-1","v":-1},"Degrees of freedom for sites*"]
[{"$nulls":11},"astd2ws",{"$f":"SUMPRODUCT(M10:M22,K10:K22)/SUM(K10:K22)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(N10:N22,L10:L22)/SUM(L10:L22)","v":{"$error":"#DIV/0!"}},"Weighted average of within-site variances*"]
[{"$nulls":11},"astdws",{"$f":"SQRT(M34)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(N34)","v":{"$error":"#DIV/0!"}},"Within-site standard deviation*"]
[{"$nulls":11},"df2",{"$f":"M26-M27","v":0},{"$f":"N26-N27","v":0},"Degrees of freedom for days at sites*"]
[{"$nulls":12},{"$f":"IF(M32*M32-M29*M34>0,SQRT(M32*M32-M29*M34),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(N32*N32-N29*N34>0,SQRT(N32*N32-N29*N34),0)","v":{"$error":"#DIV/0!"}},"Between-site standard deviation*"]
[{"$nulls":12},{"$f":"M31+0.5*M32*M32+0.5*(M30)*M35*M35","v":{"$error":"#DIV/0!"}},{"$f":"N31+0.5*N32*N32+0.5*(N30)*N35*N35","v":{"$error":"#DIV/0!"}},"Term1**"]
[{"$nulls":12},{"$f":"(M32*TINV(0.1,M33)/SQRT(M27))^2","v":{"$error":"#DIV/0!"}},{"$f":"(N32*TINV(0.1,N33)/SQRT(N27))^2","v":{"$error":"#DIV/0!"}},"Term2**"]
[{"$nulls":12},{"$f":"0.5^2*M32^4*(M33/_xlfn.CHISQ.INV.RT(1-0.05,M33)-1)^2","v":{"$error":"#DIV/0!"}},{"$f":"0.5^2*N32^4*(N33/_xlfn.CHISQ.INV.RT(1-0.05,N33)-1)^2","v":{"$error":"#DIV/0!"}},"Term3**"]
[{"$nulls":12},{"$f":"(0.5*(M30))^2*M35^4*(M36/_xlfn.CHISQ.INV.RT(0.05,M36)-1)^2","v":{"$error":"#NUM!"}},{"$f":"(0.5*(N30))^2*N35^4*(N36/_xlfn.CHISQ.INV.RT(0.05,N36)-1)^2","v":{"$error":"#NUM!"}},"Term4**"]
[{"$nulls":11},"UCL2",{"$f":"M38+SQRT(M39+M40+M41)","v":{"$error":"#DIV/0!"}},{"$f":"N38+SQRT(N39+N40+N41)","v":{"$error":"#DIV/0!"}},"Natural logarithm of upper confidence limit (equation B-1)"]
[{"$nulls":11},"UCLM",{"$f":"EXP(M42)","v":{"$error":"#DIV/0!"}},{"$f":"EXP(N42)","v":{"$error":"#DIV/0!"}},"Upper confidence limit (MOVER method) (equation B-2)"]

{"sheet":"BLANK Strategy 2","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Strategy 2:"]
["User instructions:"]
["Enter silica concentration data in columns C (GP=Ground person) and D (OP=Operator) (RED cells)."]
["If there are no data for a particular site, then \"-1\" is entered."]
["The 95% upper confidence limits are computed at the bottom of the worksheet in Cells K25 (Ground person) and L25 (Operator)."]
[]
[null,null,"Silica Conc. (mg/m3)",null,"ln(measurement)"]
["Site","Day","GP","OP","GP","OP"]
[1,1,-1,-1,{"$f":"IF(C9>0,LN(C9),\" \")","v":" "}," "]
[2,1,-1,-1," "," "]
[3,1,-1,-1," "," "]
[4,1,-1,-1," "," "]
[5,1,-1,-1," "," "]
[6,1,-1,-1," "," "]
[7,1,-1,-1," "," "]
[{"$nulls":10},"GP","OP"]
["Notes:",{"$nulls":9},{"$f":"COUNT(E9:E15)","v":0},{"$f":"COUNT(F9:F15)","v":0},"No. measurements"]
["Strategy 2 assumes sampling for day at a minimum of five sites.",{"$nulls":9},{"$f":"AVERAGE(E9:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F9:F15)","v":{"$error":"#DIV/0!"}},"Mean of site means, on natural log scale*"]
["* These quantitites are defined above equation B-3 in the Best Practices document",{"$nulls":9},{"$f":"STDEV(E9:E15)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(F9:F15)","v":{"$error":"#DIV/0!"}},"Standard deviation of site mean, on natural log scale*"]
["** These terms are defined the analysis of example data section of the Best Practices document",{"$nulls":8},"df1",{"$f":"K17-1","v":-1},{"$f":"L17-1","v":-1},"Degrees of freedom for sites*"]
[{"$nulls":10},{"$f":"K18+0.5*K19*K19","v":{"$error":"#DIV/0!"}},{"$f":"L18+0.5*L19*L19","v":{"$error":"#DIV/0!"}},"Term1**"]
[{"$nulls":10},{"$f":"(K19*TINV(0.1,K20)/SQRT(K17))^2","v":{"$error":"#DIV/0!"}},{"$f":"(L19*TINV(0.1,L20)/SQRT(L17))^2","v":{"$error":"#DIV/0!"}},"Term2**"]
[{"$nulls":10},{"$f":"0.5^2*K19^4*(K20/_xlfn.CHISQ.INV.RT(1-0.05,K20)-1)^2","v":{"$error":"#DIV/0!"}},{"$f":"0.5^2*L19^4*(L20/_xlfn.CHISQ.INV.RT(1-0.05,L20)-1)^2","v":{"$error":"#DIV/0!"}},"Term3**"]
[{"$nulls":9},"UCL2",{"$f":"K21+SQRT(K22+K23)","v":{"$error":"#DIV/0!"}},{"$f":"L21+SQRT(L22+L23)","v":{"$error":"#DIV/0!"}},"Natural logarithm of upper confidence limit (equation B-3)"]
[{"$nulls":9},"UCLM",{"$f":"EXP(K24)","v":{"$error":"#DIV/0!"}},{"$f":"EXP(L24)","v":{"$error":"#DIV/0!"}},"Upper confidence limit (MOVER method) (equation B-4)"]