{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Std Curve Instructions","Lab Std Curves","Initial Calibrators","IPR","Test Samples (AB Format)","TestSamples(SmartCyclerFormat)"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Std Curve Instructions","index":0,"n_rows":79,"n_cols":32,"rows_kept":79}
[null,null,"Laboratory Prepared Standard Curves"]
[null,null,"Only populate cells highlighted in yellow."]
[null,null,"*Replace indicated Sequences values in column C with your own values if necessary",{"$nulls":15},"Individual Run",{"$nulls":5},"Composite"]
["Run","Information ","*Sequences","Log Sequences","CT","1- h_ii","res","rss_i","sigma_i","r_student","outlier",null,"Log Sequences","CT","res","res1","*res2",null,"Parameter","estimate","std.","95% LB","95% UB",null,"Parameter","estimate","std.","95% LB","95% UB"]
[1,null,{"v":22698.648518838218,"d":"22698.65"},4.356,22.645103454589844,0.7803499986184514,0.5551185141789219,3.863131854299135,0.5673866887096735,1.107546202550918,"No",null,4.356,22.645103454589844,0.31543154472821655,0.35420933174612657,0.3342177969375282,null,"slope",-3.5132331627049034,0.09727935201632275,-3.725186662939782,-3.3012796624700247,null,"slope",-3.4931529475175918,0.05145571956456948,-3.598731363167627,-3.3875745318675565]
[null,null,{"v":22698.648518838218,"d":"22698.65"},4.356,22.328855514526367,0.7803499986184514,0.23887057411544532,4.18490722951605,0.5905440450350317,0.45789472653705227,"No",null,4.356,22.328855514526367,-8.1639533526001173E-4,0.03796139168265,0.017969856874051615,null,"intercept",37.594537779586275,0.27040362734334483,37.00537888714204,38.183696672030514,null,"intercept",37.545846149248256,0.1442070022451754,37.249957821351465,37.841734477145046]
[null,null,{"v":22698.648518838218,"d":"22698.65"},4.356,21.719789505004883,0.7803499986184514,-0.37019543540603905,4.082407698076526,0.5832672127819094,-0.7184867747099848,"No",null,4.356,21.719789505004883,-0.6098824048567444,-0.5711046178388344,-0.5910961526474328]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,24.243507385253906,0.9015344238990726,-1.3277700468535691,2.302501963224765,0.43803557344360033,-3.192436947498778,"Yes",null," "," "," "," "," ",null,"R^2 =",0.9908834355724372,{"$nulls":4},"R^2 =",0.9941754962753645]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,25.807815551757812,0.9015344238990726,0.2365381196503371,4.195966006329252,0.5913237978136606,0.42129337078948986,"No",null,3.3810000000000002,25.807815551757812,0.07231951806653569,0.09151909527681568,0.08684699740183355]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,25.9750919342041,0.9015344238990726,0.40381450209662617,4.077150942570999,0.5828915667150995,0.7296305040031356,"No",null,3.3810000000000002,25.9750919342041,0.23959590051282476,0.25879547772310474,0.2541233798481226]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,29.103504180908203,0.9315588058467129,-0.07403521695672666,4.2521432617765536,0.5952690751372129,-0.12886052445842971,"No",null,2.371,29.103504180908203,-0.16007632977584052,-0.16115776990474728,-0.14996050234080371,{"$nulls":7},"ANCOVA"]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,29.383441925048828,0.9315588058467129,0.20590252718389834,4.212516523110996,0.592488855247576,0.3600612241196883,"No",null,2.371,29.383441925048828,0.11986141436478448,0.11877997423587772,0.12997724179982129,{"$nulls":8},"RSS","SS1","SS2","SS3","F","p_value","Sig. diff?"]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,28.880273818969727,0.9315588058467129,-0.2972655788952032,4.163168083263014,0.5890082118317631,-0.522899391789011,"No",null,2.371,28.880273818969727,-0.3833066917143171,-0.38438813184322385,-0.3731908642792803,{"$nulls":7},"intercept",{"v":2.935731325074909,"d":"2.9357"},{"v":634.575372771985,"d":"634.5754"},{"v":5.256771287111164,"d":"5.2568"},{"v":2.948032168998655,"d":"2.9480"},{"v":0.10475110425365923,"d":"0.1048"},{"v":0.748892945518022,"d":"0.7489"},"No"]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,31.84320068359375,0.8927477759452412,0.05915511245857985,4.2541074505927865,0.5954065453251799,0.10515121404983077,"No",null,1.6410000000000002,31.84320068359375,0.029618521221863148,0.013878524006223358,0.03654572896661534,{"$nulls":7},"slope",{"v":2.935731325074909,"d":"2.9357"},{"v":506.5022958478394,"d":"506.5023"},{"v":41.2667132142857,"d":"41.2667"},{"v":-144.1522662504741,"d":"-144.1523"},{"v":0.13643176343006158,"d":"0.1364"},{"v":0.7149646140113457,"d":"0.7150"},"No"]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,31.684377670288086,0.8927477759452412,-0.09966790084708421,4.246900081050516,0.5949019583826758,-0.17731501960625634,"No",null,1.6410000000000002,31.684377670288086,-0.12920449208380091,-0.1449444892994407,-0.12227728433904872]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,32.54524230957031,0.8927477759452412,0.7611967384351424,3.60899674542802,0.5484065360530164,1.4690274401592258,"No",null,1.6410000000000002,32.54524230957031,0.7316601471984256,0.7159201499827859,0.7385873549431778]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,34.33692932128906,0.8271423290238551,0.5176666011620625,3.9340458012684816,0.5725706507547403,0.9941019826732469,"No",null,1.0710000000000002,34.33692932128906,0.532249978832148,0.5050642589597416,0.5366874424351695]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,32.94068145751953,0.8271423290238551,-0.8785812626074687,3.324808059027728,0.5263718630894993,-1.8352665427593062,"No",null,1.0710000000000002,32.94068145751953,-0.8639978849373833,-0.8911836048097896,-0.8595604213343617]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,33.88851547241211,0.8271423290238551,0.06925275228510941,4.252228968813796,0.5952750742873553,0.1279172802529182,"No",null,1.0710000000000002,33.88851547241211,0.08383612995519485,0.05665041008278848,0.0882735935582164]
[2,null,{"v":22698.648518838218,"d":"22698.65"},4.356,22.51841163635254,0.7803499986184514,0.15258103234635456,0.6033953495824493,0.22423859123384057,0.770274420029692,"No",null,4.356,22.51841163635254,0.18873972649091186,0.15258103234635456,0.1719352271700192,null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"},4.356,22.086593627929688,0.7803499986184514,-0.279236976076497,0.533308443100364,0.21081359125626523,-1.4994417625894985,"No",null,4.356,22.086593627929688,-0.2430782819319397,-0.279236976076497,-0.2598827812528324,null,"slope",-3.4738200097071292,0.04817180307746329,-3.577888863200979,-3.3697511562132796]
[null,null,{"v":22698.648518838218,"d":"22698.65"},4.356,22.439781188964844,0.7803499986184514,0.07395058495865925,0.6262213666871929,0.22844061348761827,0.366457469962855,"No",null,4.356,22.439781188964844,0.11010927910321655,0.07395058495865925,0.09330477978232388,null,"intercept",37.49779056629044,0.13602451426297893,37.203927469166125,37.791653663414756]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,25.94080352783203,0.9015344238990726,0.1879984143613953,0.5940257520206489,0.2224907773408164,0.8899200995428191,"No",null,3.3810000000000002,25.94080352783203,0.20530749414075444,0.1879984143613953,0.1922104714274706]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,25.652433395385742,0.9015344238990726,-0.10037171808489376,0.6220545453104261,0.22767933322080167,-0.4642977617819068,"No",null,3.3810000000000002,25.652433395385742,-0.08306263830553462,-0.10037171808489376,-0.09615966101881845,null,"R^2 =",0.9975063803342289]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},3.3810000000000002,25.9173641204834,0.9015344238990726,0.1645590070127625,0.6031920542652514,0.2242008129380986,0.7730246056850804,"No",null,3.3810000000000002,25.9173641204834,0.18186808679212163,0.1645590070127625,0.1687710640788378]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,28.954120635986328,0.9315588058467129,-0.30724268728850745,0.5318959105427279,0.21053422337447655,-1.5120066965909456,"No",null,2.371,28.954120635986328,-0.3094598746977155,-0.30724268728850745,-0.3187163318995285]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,29.2877140045166,0.9315588058467129,0.026350681241765983,0.6324839892579404,0.22958004944861468,0.11891936037738338,"No",null,2.371,29.2877140045166,0.024133493832557917,0.026350681241765983,0.014877036630744911]
[null,null,{"v":234.96328208483078,"d":"234.96"},2.371,29.004798889160156,0.9315588058467129,-0.25656443411467933,0.5625678980333164,0.2165194175344166,-1.227706244730212,"No",null,2.371,29.004798889160156,-0.2587816215238874,-0.25656443411467933,-0.2680380787257004]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,32.01007843017578,0.8927477759452412,0.21282649981473867,0.5824926137519104,0.22032033756780722,1.0223667715212985,"No",null,1.6410000000000002,32.01007843017578,0.1964962678038944,0.21282649981473867,0.19001566488265365]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,31.72368049621582,0.8927477759452412,-0.07357143414522227,0.627166332551132,0.22861290656025451,-0.34059956440253764,"No",null,1.6410000000000002,31.72368049621582,-0.08990166615606654,-0.07357143414522227,-0.09638226907730729]
[null,null,{"v":43.75221051582523,"d":"43.75"},1.6410000000000002,32.16550827026367,0.8927477759452412,0.3682563399026293,0.48132449517613507,0.2002757464048287,1.9460656408794295,"No",null,1.6410000000000002,32.16550827026367,0.351926107891785,0.3682563399026293,0.34544550497054427]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,33.85862731933594,0.8271423290238551,0.0812979834418357,0.6252387635216701,0.2282613201869132,0.3916132029499665,"No",null,1.0710000000000002,33.85862731933594,0.053947976879022974,0.0812979834418357,0.049634821820692565]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,33.46657180786133,0.8271423290238551,-0.3107575280327737,0.5164777003277483,0.20746037780898235,-1.6470105097509897,"No",null,1.0710000000000002,33.46657180786133,-0.3381075345955864,-0.3107575280327737,-0.3424206896539168]
[null,null,{"v":11.776059735208076,"d":"11.78"},1.0710000000000002,33.83725357055664,0.8271423290238551,0.05992423466253882,0.6288880123944489,0.22892648244841415,0.28781693076168996,"No",null,1.0710000000000002,33.83725357055664,0.0325742280997261,0.05992423466253882,0.02826107304139569]
["Instructions for determining standard curve parameters for individual runs and from composite data from multiple runs:"]
["1. For first instrument run, type run information (e.g. run date) in column B and copy and paste CT values from instrument export file to column E."]
["    Note: Calculated Log Sequences values should appear in column D, outlier calculations should appear in columns F-J and outlier determinations should appear in column K upon entering the CT values."]
["    Note: If cutting and pasting a block of CT data, make sure that CT values correspond to sequence copy number values in column C."]
["    Note: If necessary, also enter your lab-specific sequence copy numbers/rxn for your own standards in column C."]
["    Important Note: If mistakes are made in entering CT data in correct rows or if reusing a worksheet, make sure that all unused cells in column E contain the formula: =\" \""]
["2. Log Sequence and CT values should also automatically be copied from columns D & E to columns M & N and residuals should be automatically calculated in columns O and P for each row in which outlier = no. "]
["    Note: data in outlier = yes rows will automatically be excluded from residual and subsequent regression analysis (see row 8 in example above)."]
["3. Regression analysis should be automatically performed on all non-outlier data from the run and results reported in columns T- W."]
["    Note:  Mean, standard deviation, lower 95% confidence bound and upper 95% confidence bound for slope estimate should be reported in cells  T5, U5, V5 and W5, respectively."]
["    Note:  Mean, standard deviation, lower 95% confidence bound and upper 95% confidence bound for intercept estimate should be reported in cells T6, U6, V6  and W6, respectively."]
["    Note:  R-squared results should be reported in cell T8."]
["4. Repeat steps 1-3 for each subsequent run. "]
["    Note: Outlier, residuals and regression analyses should be calculated for each new run and regression analysis results should be reported in columns T - W as described in step 3."]
["    Note:  Residuals from the composite data analysis will be updated in column O with each new set of data."]
["5. As CT data for each new run is entered, a regression analysis also should be automatically performed on non-outlier composite data from all runs and results reported in rows 5 - 6, columns Z - AC."]
["    Note:  With the addition of each run, updated mean, standard deviation, lower 95% bound and upper 95% bound for composite slope estimate should be reported in cells  Z5, AA5, AB5 and AC5, respectively."]
["    Note:  With the addition of each run, updated mean, standard deviation, lower 95% bound and upper 95% bound for composite intercept estimate should be reported in cells  Z6, AA6, AB6 and AC6, respectively."]
["    Note:  Updated R-squared results for the composite data should be reported in cell Z8."]
["6. After entering CT data from each run, it is recommended to inspect the regression analysis outputs from that run in column T and the ancova analysis results for all runs in rows 13 - 14, columns Y - AF."]
["   \"Yes\" in cells AF14 or AF13 indicates that there is a signficant difference (P < 0.05) in slope or intercept values, respectively, among the curves from the different runs"]
["    Guidelines for slope and R2 values are discussed in Section 9.10 in the Method."]
["    Guidelines for intercept values are discussed in Section 9.10 in the Method but may be instrument type-dependent."]
["    Note:  Inspection of data from individual runs also may be facilitated by plotting the standard curves for each run as described below."]
["    Note: It is recommended that ancova analysis results indicate no significant differences among all accepted standard curves and that each curve meets the guidelines indicated in Section 9.10 of the Method."]
["    Note: If several curves are all substantially different, this could be an indication of a problem with laboratory technique, reagents or standards. See guidance in Section 9.10 in the Method."]
["7. Individual curves can be eliminated from the composite regression analysis by deleting the CT values in column E for that run or by overwriting them with new values from another run."]
["   Important Note: If CT values from any individual runs are deleted, make sure to replace the now-empty cells in column E for that run with the formula: =\" \""]
[]
["Instructions for plotting standard curves with equations from individual runs  (Note: these instructions are specific for Excel, Microsoft Office 2007):"]
["1. Copy the log sequences AND the CT values in columns D and E for the run and paste into another spreadsheet."]
["    Note: CT data excluding outliers can be analysed in the same manner by copying log sequences and CT values in columns "]
["             M and N for the run, however, no empty rows should be copied and pasted into the new spreadsheet."]
["2. Click on the\" Insert\" tab and then on the \"Scatter\" icon in the toolbar and then on upper left icon"]
["    in the drop down menu (showing only data points). A chart should appear."]
["3. At this point it is easier to finish playing with the chart before you move it. In the \"Design\" tab under \"Chart Tools\", "]
["    which should come up automatically after creating the chart, click on the \"layout 9\" icon (last icon in row 3)."]
["    in the menu of icons appearing in the \"Chart Layout\" section of the toolbar."]
["4. The regression equation and R2 value should automatically appear on the chart. "]
["     Note: slope = -3.3218, intercept = 37.493 and R² = 0.9977 in the example at right."]
["5. You can move the equation and the R2 information by clicking on it, positioning the cursor over any of the lines"]
["     in the resulting box and dragging the box to anywhere you want it on the chart."]
["6. Other options: chart title - click on the default title and then highlight the text by holding down mouse button and dragging"]
["    the cursor over it and then type your own descriptive title. Use same procedure for labeling x and y axes.  For (x) axis,"]
["    type Log10 sequences, and for (y) axis, type CT."]

{"sheet":"Lab Std Curves","index":1,"n_rows":154,"n_cols":32,"rows_kept":154}
[null,null,"Laboratory Prepared Standard Curves"]
[null,null,"Only populate cells highlighted in yellow."]
[null,null,"*replace indicated Sequences values in column C with your own values if necessary",{"$nulls":15},"Individual Run",{"$nulls":5},"Composite"]
["Run","Information ","*Sequences","Log Sequences","CT","1- h_ii","res","rss_i","sigma_i","r_student","outlier",null,"Log Sequences","CT","res","res1","*res2",null,"Parameter","estimate","std.","95% LB","95% UB",null,"Parameter","estimate","std.","95% LB","95% UB"]
[1,null,{"v":22698.648518838218,"d":"22698.65"},{"$f":"IF(E5=\" \",\" \",LOG10(C5))","v":" "},{"$f":"\" \"","v":" "},{"$f":" IF(E5=\" \",\" \",1- ( (1/COUNT(D$5:D$19)) + ((D5-AVERAGE(D$5:D$19))^2/DEVSQ(D$5:D$19))))","v":" "},{"$f":"IF(F5=\" \",\" \",E5-(INTERCEPT(E$5:E$19,D$5:D$19) + SLOPE(E$5:E$19,D$5:D$19)*D5))","v":" "},{"$f":"IF(G5=\" \",\" \",DEVSQ(G$5:G$19) -(G5^2/F5))","v":" "},{"$f":"IF(H5=\" \",\" \",SQRT(H5/(COUNT(D$5:D$19)-3)))","v":" "},{"$f":"IF(I5=\" \", \" \",G5/(I5*SQRT(F5)))","v":" "},{"$f":"IF(J5=\" \",\" \",IF(ABS(J5)>3,\"Yes\",\"No\"))","v":" "},null,{"$f":"IF(K5=\"No\",D5,\" \")","v":" "},{"$f":"IF(K5=\"No\",E5,\" \")","v":" "},{"$f":"IF(N5=\" \",\" \",N5-(INTERCEPT(N$5:N$154,M$5:M$154) + SLOPE(N$5:N$154,M$5:M$154)*M5))","v":" "},{"$f":"IF(N5=\" \",\" \",N5-(INTERCEPT($N$5:N$19,M$5:M$19) + SLOPE(N$5:N$19,M$5:M$19)*M5))","v":" "},{"$f":"IF(N5= \" \", \" \",N5 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT($N$5:$N$19)=0,\" \",(SUMPRODUCT($M$5:$M$19,$N$5:$N$19) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM($M$5:$M$19))/SUMSQ($M$5:$M$19))*M5)","v":" "},null,"slope",{"$f":"SLOPE($N$5:$N$19,$M$5:$M$19)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$5:$P$19)/(COUNT($P$5:$P$19)-2))/DEVSQ($M$5:$M$19))","v":{"$error":"#NUM!"}},{"$f":"$T$5- TINV(0.05,COUNT($O$5:$O$19)-2)*$U$5","v":{"$error":"#DIV/0!"}},{"$f":"$T$5 + TINV(0.05,COUNT($O$5:$O$19)-2)*$U$5","v":{"$error":"#DIV/0!"}},null,"slope",{"$f":"SLOPE($N$5:$N$154,$M$5:$M$154)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($O$5:$O$154)/(COUNT($O$5:$O$154)-2))/DEVSQ($M$5:$M$154))","v":{"$error":"#NUM!"}},{"$f":"$Z$5- TINV(0.05,COUNT($O$5:$O$154)-2)*$AA$5","v":{"$error":"#DIV/0!"}},{"$f":" $Z$5 + TINV(0.05,COUNT($O$5:$O$154)-2)*$AA$5","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"},{"$f":"IF(E6=\" \",\" \",LOG10(C6))","v":" "}," ",{"$f":" IF(E6=\" \",\" \",1- ( (1/COUNT(D$5:D$19)) + ((D6-AVERAGE(D$5:D$19))^2/DEVSQ(D$5:D$19))))","v":" "},{"$f":"IF(F6=\" \",\" \",E6-(INTERCEPT(E$5:E$19,D$5:D$19) + SLOPE(E$5:E$19,D$5:D$19)*D6))","v":" "},{"$f":"IF(G6=\" \",\" \",DEVSQ(G$5:G$19) -(G6^2/F6))","v":" "},{"$f":"IF(H6=\" \",\" \",SQRT(H6/(COUNT(D$5:D$19)-3)))","v":" "}," ",{"$f":"IF(J6=\" \",\" \",IF(ABS(J6)>3,\"Yes\",\"No\"))","v":" "},null,{"$f":"IF(K6=\"No\",D6,\" \")","v":" "},{"$f":"IF(K6=\"No\",E6,\" \")","v":" "},{"$f":"IF(N6=\" \",\" \",N6-(INTERCEPT(N$5:N$154,M$5:M$154) + SLOPE(N$5:N$154,M$5:M$154)*M6))","v":" "},{"$f":"IF(N6=\" \",\" \",N6-(INTERCEPT(N$5:N$19,M$5:M$19) + SLOPE(N$5:N$19,M$5:M$19)*M6))","v":" "}," ",null,"intercept",{"$f":"INTERCEPT($N$5:$N$19,$M$5:$M$19)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$5:$P$19)/(COUNT($P$5:$P$19)-2))*((1/COUNT($P$5:$P$19))+(AVERAGE($M$5:$M$19)^2/DEVSQ($M$5:$M$19))))","v":{"$error":"#DIV/0!"}},{"$f":"T$6- TINV(0.05,COUNT(O$5:O$19)-2)*U$6","v":{"$error":"#DIV/0!"}},{"$f":"$T$6 + TINV(0.05,COUNT($O$5:$O$19)-2)*$U$6","v":{"$error":"#DIV/0!"}},null,"intercept",{"$f":"INTERCEPT($N$5:$N$154,$M$5:$M$154)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($O$5:$O$154)/(COUNT($O$5:$O$154)-2))*((1/COUNT($O$5:$O$154))+(AVERAGE($M$5:$M$154)^2/DEVSQ($M$5:$M$154))))","v":{"$error":"#DIV/0!"}},{"$f":"$Z$6- TINV(0.05,COUNT($O$5:$O$154)-2)*$AA$6","v":{"$error":"#DIV/0!"}},{"$f":"$Z$6 + TINV(0.05,COUNT($O$5:$O$154)-2)*$AA$6","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$5:$P$19)/DEVSQ($N$5:$N$19))","v":{"$error":"#NUM!"}},{"$nulls":4},"R^2 =",{"$f":"1-(SUMSQ($O$5:$O$154)/DEVSQ($N$5:$N$154))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",{"$nulls":8},"ANCOVA"]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",{"$nulls":8},"RSS","SS1","SS2","SS3","F","p_value","Sig. diff?"]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",{"$nulls":7},"intercept",{"$f":"SUM(IF(SUMSQ($P$5:$P$19) = 0, 0,SUMSQ($P$5:$P$19)),IF(SUMSQ($P$20:$P$34) = 0, 0,SUMSQ($P$20:$P$34)),IF(SUMSQ($P$35:$P$49) = 0, 0,SUMSQ($P$35:$P$49)),IF(SUMSQ($P$50:$P$64) = 0,0,SUMSQ($P$50:$P$64)),IF(SUMSQ($P$65:$P$79) = 0, 0,SUMSQ($P$65:$P$79)),IF(SUMSQ($P$80:$P$94) = 0, 0,SUMSQ($P$80:$P$94)),IF(SUMSQ($P$95:$P$109) = 0,0,SUMSQ($P$95:$P$109)),IF(SUMSQ($P$110:$P$124) = 0, 0,SUMSQ($P$110:$P$124)),IF(SUMSQ($P$125:$P$139) = 0, 0,SUMSQ($P$125:$P$139)),IF(SUMSQ($P$140:$P$154) = 0, 0,SUMSQ($P$140:$P$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(IF(COUNT($N$5:$N$19)=0,0,SUM($M$5:$M$19)*SUMPRODUCT($N$5:$N$19,$M$5:$M$19)/SUMSQ($M$5:$M$19)),IF(COUNT($N$20:$N$34)=0,0,SUM($M$20:$M$34)*SUMPRODUCT($N$20:$N$34,$M$20:$M$34)/SUMSQ($M$20:$M$34)),IF(COUNT($N$35:$N$49)=0,0,SUM($M$35:$M$49)*SUMPRODUCT(N35:N49,M35:M49)/SUMSQ(M35:M49)),IF(COUNT(N50:N64)=0,0,SUM(M50:M64)*SUMPRODUCT(N50:N64,M50:M64)/SUMSQ(M50:M64)),IF(COUNT(N65:N79)=0,0,SUM(M65:M79)*SUMPRODUCT(N65:N79,M65:M79)/SUMSQ(M65:M79)),IF(COUNT(N80:N94)=0,0,SUM(M80:M94)*SUMPRODUCT(N80:N94,M80:M94)/SUMSQ(M80:M94)),IF(COUNT(N95:N109)=0,0,SUM(M95:M109)*SUMPRODUCT(N95:N109,M95:M109)/SUMSQ(M95:M109)),IF(COUNT(N110:N124)=0,0,SUM(M110:M124)*SUMPRODUCT(N110:N124,M110:M124)/SUMSQ(M110:M124)),IF(COUNT(N125:N139)=0,0,SUM(M125:M139)*SUMPRODUCT(N125:N139,M125:M139)/SUMSQ(M125:M139)),IF(COUNT(N140:N154)=0,0,SUM(M140:M154)*SUMPRODUCT(N140:N154,M140:M154)/SUMSQ(M140:M154)))","v":{"v":0,"d":"0.0000"}},{"$f":"COUNT($N$5:$N$154) - SUM(IF(COUNT($N$5:$N$19)=0,0,(SUM($M$5:$M$19))^2/SUMSQ($M$5:$M$19)),IF(COUNT($N$20:$N$34)=0,0,(SUM($M$20:$M$34))^2/SUMSQ($M$20:$M$34)),IF(COUNT($N$35:$N$49)=0,0,(SUM($M$35:$M$49))^2/SUMSQ($M$35:$M$49)),IF(COUNT($N$50:$N$64)=0,0,(SUM($M$50:$M$64))^2/SUMSQ($M$50:$M$64)),IF(COUNT($N$65:$N$79)=0,0,(SUM($M$65:$M$79))^2/SUMSQ($M$65:$M$79)),IF(COUNT($N$80:$N$94)=0,0,(SUM($M$80:$M$94))^2/SUMSQ($M$80:$M$94)),IF(COUNT($N$95:$N$109)=0,0,(SUM($M$95:$M$109))^2/SUMSQ($M$95:$M$109)),IF(COUNT($N$110:$N$124)=0,0,(SUM($M$110:$M$124))^2/SUMSQ($M$110:$M$124)),IF(COUNT($N$125:$N$139)=0,0,(SUM($M$125:$M$139))^2/SUMSQ($M$125:$M$139)),IF(COUNT($N$140:$N$154)=0,0,(SUM($M$140:$M$154))^2/SUMSQ($M$140:$M$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"SUMSQ($Q$5:$Q$154)","v":{"v":0,"d":"0.0000"}},{"$f":"($AC$13-$Z$13)/(COUNT($W$5:$W$154)/2 -1)/($Z$13/(COUNT($N$5:$N$154)-COUNT($W$5:$W$154)))","v":{"$error":"#DIV/0!"}},{"$f":"FDIST(AD13,COUNT(W5:W154)/2-1,COUNT(N5:N154)-COUNT(W5:W154))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AE13 > 0.05,\"No\",\"Yes\")","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",{"$nulls":7},"slope",{"$f":"SUM(IF(SUMSQ($P$5:$P$19) = 0, 0,SUMSQ($P$5:$P$19)),IF(SUMSQ($P$20:$P$34) = 0, 0,SUMSQ($P$20:$P$34)),IF(SUMSQ($P$35:$P$49) = 0, 0,SUMSQ($P$35:$P$49)),IF(SUMSQ($P$50:$P$64) = 0,0,SUMSQ($P$50:$P$64)),IF(SUMSQ($P$65:$P$79) = 0, 0,SUMSQ($P$65:$P$79)),IF(SUMSQ($P$80:$P$94) = 0, 0,SUMSQ($P$80:$P$94)),IF(SUMSQ($P$95:$P$109) = 0,0,SUMSQ($P$95:$P$109)),IF(SUMSQ($P$110:$P$124) = 0, 0,SUMSQ($P$110:$P$124)),IF(SUMSQ($P$125:$P$139) = 0, 0,SUMSQ($P$125:$P$139)),IF(SUMSQ($P$140:$P$154) = 0, 0,SUMSQ($P$140:$P$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(IF(SUMSQ($P$5:$P$19) = 0,0,DEVSQ($N$5:$N$19)),IF(SUMSQ($P$20:$P$34) = 0,0,DEVSQ($N$20:$N$34)),IF(SUMSQ($P$35:$P$49) = 0,0,DEVSQ($N$35:$N$49)),IF(SUMSQ($P$50:$P$64) = 0,0,DEVSQ($N$50:$N$64)),IF(SUMSQ($P$65:$P$79) = 0,0,DEVSQ($N$65:$N$79)),IF(SUMSQ($P$80:$P$94) = 0,0,DEVSQ($N$80:$N$94)),IF(SUMSQ($P$95:$P$109) = 0,0,DEVSQ($N$95:$N$109)),IF(SUMSQ($P$110:$P$124) = 0,0,DEVSQ($N$110:$N$124)),IF(SUMSQ($P$125:$P$139) = 0,0,DEVSQ($N$125:$N$139)),IF(SUMSQ($P$140:$P$154) = 0,0,DEVSQ($N$140:$N$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(IF(SUMSQ($P$5:$P$19) = 0,0,DEVSQ($M$5:$M$19)),IF(SUMSQ($P$20:$P$34) = 0,0,DEVSQ($M$20:$M$34)),IF(SUMSQ($P$35:$P$49) = 0,0,DEVSQ($M$35:$M$49)),IF(SUMSQ($P$50:$P$64) = 0,0,DEVSQ($M$50:$M$64)),IF(SUMSQ($P$65:$P$79) = 0,0,DEVSQ($M$65:$M$79)),IF(SUMSQ($P$80:$P$94) = 0,0,DEVSQ($M$80:$M$94)),IF(SUMSQ($P$95:$P$109) = 0,0,DEVSQ($M$95:$M$109)),IF(SUMSQ($P$110:$P$124) = 0,0,DEVSQ($M$110:$M$124)),IF(SUMSQ($P$125:$P$139) = 0,0,DEVSQ($M$125:$M$139)),IF(SUMSQ($P$140:$P$154) = 0,0,DEVSQ($M$140:$M$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(IF(SUMSQ($P$5:$P$19) = 0, 0,$T$5*DEVSQ($M$5:$M$19)),IF(SUMSQ($P$20:$P$34) = 0,0,$T$21*DEVSQ($M$20:$M$34)),IF(SUMSQ($P$35:$P$49) = 0,0,$T$36*DEVSQ($M$35:$M$49)),IF(SUMSQ($P$50:$P$64) = 0,0,$T$51*DEVSQ($M$50:$M$64)),IF(SUMSQ($P$65:$P$79) = 0,0,$T$66*DEVSQ($M$65:$M$79)),IF(SUMSQ($P$80:$P$94) = 0,0,$T$81*DEVSQ($M$80:$M$94)),IF(SUMSQ($P$95:$P$109) = 0,0,$T$96*DEVSQ($M$95:$M$109)),IF(SUMSQ($P$110:$P$124) = 0,0,$T$111*DEVSQ($M$110:$M$124)),IF(SUMSQ($P$125:$P$139) = 0,0,$T$126*DEVSQ($M$125:$M$139)),IF(SUMSQ($P$140:$P$154) = 0,0,$T$141*DEVSQ($M$140:$M$154)))","v":{"v":0,"d":"0.0000"}},{"$f":"(($AA$14 -($AC$14*$AC$14/$AB$14)  -$Z$14)/(COUNT($W$5:$W$154)/2 -1))/($Z$14/(COUNT($N$5:$N$154)-COUNT($W$5:$W$154)))","v":{"$error":"#DIV/0!"}},{"$f":"FDIST(AD$14,COUNT(W$5:W$154)/2-1,COUNT(N5:N154)-COUNT(W5:W154))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AE14 > 0.05,\"No\",\"yes\")","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[2,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E20=\" \",\" \",1- ( (1/COUNT(D$20:D$34)) + ((D20-AVERAGE(D$20:D$34))^2/DEVSQ(D$20:D$34))))","v":" "},{"$f":"IF(F20=\" \",\" \",E20-(INTERCEPT(E$20:E$34,D$20:D$34) + SLOPE(E$20:E$34,D$20:D$34)*D20))","v":" "},{"$f":"IF(G20=\" \",\" \",DEVSQ(G$20:G$34) -(G20^2/F20))","v":" "},{"$f":"IF(H20=\" \",\" \",SQRT(H20/(COUNT(D$20:D$34)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N20=\" \",\" \",N20-(INTERCEPT(N$20:N$34,M$20:M$34) + SLOPE(N$20:N$34,M$20:M$34)*M20))","v":" "},{"$f":"IF(N20= \" \", \" \",N20 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$20:N$34)=0,\" \",(SUMPRODUCT(M$20:M$34,N$20:N$34) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$20:M$34))/SUMSQ(M$20:M$34))*M20)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E21=\" \",\" \",1- ( (1/COUNT(D$20:D$34)) + ((D21-AVERAGE(D$20:D$34))^2/DEVSQ(D$20:D$34))))","v":" "},{"$f":"IF(F21=\" \",\" \",E21-(INTERCEPT(E$20:E$34,D$20:D$34) + SLOPE(E$20:E$34,D$20:D$34)*D21))","v":" "},{"$f":"IF(G21=\" \",\" \",DEVSQ(G$20:G$34) -(G21^2/F21))","v":" "},{"$f":"IF(H21=\" \",\" \",SQRT(H21/(COUNT(D$20:D$34)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N21=\" \",\" \",N21-(INTERCEPT(N$20:N$34,M$20:M$34) + SLOPE(N$20:N$34,M$20:M$34)*M21))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$20:$N$34,$M$20:$M$34)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$20:$P$34)/(COUNT($P$20:$P$34)-2))/DEVSQ($M$20:$M$34))","v":{"$error":"#NUM!"}},{"$f":"$T$21- TINV(0.05,COUNT($O$20:$O$34)-2)*$U$21","v":{"$error":"#DIV/0!"}},{"$f":"$T$21 + TINV(0.05,COUNT($O$20:$O$34)-2)*$U$21","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$20:$N$34,$M$20:$M$34)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$20:$P$34)/(COUNT($P$20:$P$34)-2))*((1/COUNT($P$20:$P$34))+(AVERAGE($M$20:$M$34)^2/DEVSQ($M$20:$M$34))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$22- TINV(0.05,COUNT($O$20:$O$34)-2)*$U$22","v":{"$error":"#DIV/0!"}},{"$f":"$T$22 + TINV(0.05,COUNT($O$20:$O$34)-2)*$U$22","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$20:P$34)/DEVSQ($N$20:$N$34))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[3,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E35=\" \",\" \",1- ( (1/COUNT(D$35:D$49)) + ((D35-AVERAGE(D$35:D$49))^2/DEVSQ(D$35:D$49))))","v":" "},{"$f":"IF(F35=\" \",\" \",E35-(INTERCEPT(E$35:E$49,D$35:D$49) + SLOPE(E$35:E$49,D$35:D$49)*D35))","v":" "},{"$f":"IF(G35=\" \",\" \",DEVSQ(G$35:G$49) -(G35^2/F35))","v":" "},{"$f":"IF(H35=\" \",\" \",SQRT(H35/(COUNT(D$35:D$49)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N35=\" \",\" \",N35-(INTERCEPT(N$35:N$49,M$35:M$49) + SLOPE(N$35:N$49,M$35:M$49)*M35))","v":" "},{"$f":"IF(N35= \" \", \" \",N35 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$35:N$49)=0,\" \",(SUMPRODUCT(M$35:M$49,N$35:N$49) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$35:M$49))/SUMSQ(M$35:M$49))*M35)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E36=\" \",\" \",1- ( (1/COUNT(D$35:D$49)) + ((D36-AVERAGE(D$35:D$49))^2/DEVSQ(D$35:D$49))))","v":" "},{"$f":"IF(F36=\" \",\" \",E36-(INTERCEPT(E$35:E$49,D$35:D$49) + SLOPE(E$35:E$49,D$35:D$49)*D36))","v":" "},{"$f":"IF(G36=\" \",\" \",DEVSQ(G$35:G$49) -(G36^2/F36))","v":" "},{"$f":"IF(H36=\" \",\" \",SQRT(H36/(COUNT(D$35:D$49)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N36=\" \",\" \",N36-(INTERCEPT(N$35:N$49,M$35:M$49) + SLOPE(N$35:N$49,M$35:M$49)*M36))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$35:$N$49,$M$35:$M$49)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$35:$P$49)/(COUNT($P$35:$P$49)-2))/DEVSQ($M$35:$M$49))","v":{"$error":"#NUM!"}},{"$f":"$T$36- TINV(0.05,COUNT($O$35:$O$49)-2)*$U$36","v":{"$error":"#DIV/0!"}},{"$f":"$T$36 + TINV(0.05,COUNT($O$35:$O$49)-2)*$U$36","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$35:$N$49,$M$35:$M$49)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$35:$P$49)/(COUNT($P$35:$P$49)-2))*((1/COUNT($P$35:$P$49))+(AVERAGE($M$35:$M$49)^2/DEVSQ($M$35:$M$49))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$37- TINV(0.05,COUNT($O$35:$O$49)-2)*$U$37","v":{"$error":"#DIV/0!"}},{"$f":"$T$37 + TINV(0.05,COUNT($O$35:$O$49)-2)*$U$37","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$35:P$49)/DEVSQ($N$35:$N$49))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[4,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E50=\" \",\" \",1- ( (1/COUNT(D$50:D$64)) + ((D50-AVERAGE(D$50:D$64))^2/DEVSQ(D$50:D$64))))","v":" "},{"$f":"IF(F50=\" \",\" \",E50-(INTERCEPT(E$50:E$64,D$50:D$64) + SLOPE(E$50:E$64,D$50:D$64)*D50))","v":" "},{"$f":"IF(G50=\" \",\" \",DEVSQ(G$50:G$64) -(G50^2/F50))","v":" "},{"$f":"IF(H50=\" \",\" \",SQRT(H50/(COUNT(D$50:D$64)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N50=\" \",\" \",N50-(INTERCEPT(N$50:N$64,M$50:M$64) + SLOPE(N$50:N$64,M$50:M$64)*M50))","v":" "},{"$f":"IF(N50= \" \", \" \",N50 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$50:N$64)=0,\" \",(SUMPRODUCT(M$50:M$64,N$50:N$64) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$50:M$64))/SUMSQ(M$50:M$64))*M50)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E51=\" \",\" \",1- ( (1/COUNT(D$50:D$64)) + ((D51-AVERAGE(D$50:D$64))^2/DEVSQ(D$50:D$64))))","v":" "},{"$f":"IF(F51=\" \",\" \",E51-(INTERCEPT(E$50:E$64,D$50:D$64) + SLOPE(E$50:E$64,D$50:D$64)*D51))","v":" "},{"$f":"IF(G51=\" \",\" \",DEVSQ(G$50:G$64) -(G51^2/F51))","v":" "},{"$f":"IF(H51=\" \",\" \",SQRT(H51/(COUNT(D$50:D$64)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N51=\" \",\" \",N51-(INTERCEPT(N$50:N$64,M$50:M$64) + SLOPE(N$50:N$64,M$50:M$64)*M51))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$50:$N$64,$M$50:$M$64)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$50:$P$64)/(COUNT($P$50:$P$64)-2))/DEVSQ($M$50:$M$64))","v":{"$error":"#NUM!"}},{"$f":"$T$51- TINV(0.05,COUNT($O$50:$O$64)-2)*$U$51","v":{"$error":"#DIV/0!"}},{"$f":"$T$51 + TINV(0.05,COUNT($O$50:$O$64)-2)*$U$51","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$50:$N$64,$M$50:$M$64)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$50:$P$64)/(COUNT($P$50:$P$64)-2))*((1/COUNT($P$50:$P$64))+(AVERAGE($M$50:$M$64)^2/DEVSQ($M$50:$M$64))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$52- TINV(0.05,COUNT($O$50:$O$64)-2)*$U$52","v":{"$error":"#DIV/0!"}},{"$f":"$T$52 + TINV(0.05,COUNT($O$50:$O$64)-2)*$U$52","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$50:P$64)/DEVSQ($N$50:$N$64))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[5,null,{"v":22698.648518838218,"d":"22698.65"}," ",{"$f":"\" \"","v":" "},{"$f":" IF(E65=\" \",\" \",1- ( (1/COUNT(D$65:D$79)) + ((D65-AVERAGE(D$65:D$79))^2/DEVSQ(D$65:D$79))))","v":" "},{"$f":"IF(F65=\" \",\" \",E65-(INTERCEPT(E$65:E$79,D$65:D$79) + SLOPE(E$65:E$79,D$65:D$79)*D65))","v":" "},{"$f":"IF(G65=\" \",\" \",DEVSQ(G$65:G$79) -(G65^2/F65))","v":" "},{"$f":"IF(H65=\" \",\" \",SQRT(H65/(COUNT(D$65:D$79)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N65=\" \",\" \",N65-(INTERCEPT(N$65:N$79,M$65:M$79) + SLOPE(N$65:N$79,M$65:M$79)*M65))","v":" "},{"$f":"IF(N65= \" \", \" \",N65 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$65:N$79)=0,\" \",(SUMPRODUCT(M$65:M$79,N$65:N$79) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$65:M$79))/SUMSQ(M$65:M$79))*M65)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E66=\" \",\" \",1- ( (1/COUNT(D$65:D$79)) + ((D66-AVERAGE(D$65:D$79))^2/DEVSQ(D$65:D$79))))","v":" "},{"$f":"IF(F66=\" \",\" \",E66-(INTERCEPT(E$65:E$79,D$65:D$79) + SLOPE(E$65:E$79,D$65:D$79)*D66))","v":" "},{"$f":"IF(G66=\" \",\" \",DEVSQ(G$65:G$79) -(G66^2/F66))","v":" "},{"$f":"IF(H66=\" \",\" \",SQRT(H66/(COUNT(D$65:D$79)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N66=\" \",\" \",N66-(INTERCEPT(N$65:N$79,M$65:M$79) + SLOPE(N$65:N$79,M$65:M$79)*M66))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$65:$N$79,$M$65:$M$79)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$65:$P$79)/(COUNT($P$65:$P$79)-2))/DEVSQ($M$65:$M$79))","v":{"$error":"#NUM!"}},{"$f":"$T$66- TINV(0.05,COUNT($O$65:$O$79)-2)*$U$66","v":{"$error":"#DIV/0!"}},{"$f":"$T$66 + TINV(0.05,COUNT($O$65:$O$79)-2)*$U$66","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$65:$N$79,$M$65:$M$79)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$65:$P$79)/(COUNT($P$65:$P$79)-2))*((1/COUNT($P$65:$P$79))+(AVERAGE($M$65:$M$79)^2/DEVSQ($M$65:$M$79))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$67- TINV(0.05,COUNT($O$65:$O$79)-2)*$U$67","v":{"$error":"#DIV/0!"}},{"$f":"$T$67 + TINV(0.05,COUNT($O$65:$O$79)-2)*$U$67","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," ",{"$f":"IF(I69=\" \", \" \",G69/(I69*SQRT(F69)))","v":" "}," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$65:P$79)/DEVSQ($N$65:$N$79))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"},{"$f":"IF(E70=\" \",\" \",LOG10(C70))","v":" "}," "," "," "," "," "," ",{"$f":"IF(J70=\" \",\" \",IF(ABS(J70)>3,\"Yes\",\"No\"))","v":" "},null,{"$f":"IF(K70=\"No\",D70,\" \")","v":" "},{"$f":"IF(K70=\"No\",E70,\" \")","v":" "},{"$f":"IF(N70=\" \",\" \",N70-(INTERCEPT(N$5:N$154,M$5:M$154) + SLOPE(N$5:N$154,M$5:M$154)*M70))","v":" "}," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[6,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E80=\" \",\" \",1- ( (1/COUNT(D$80:D$94)) + ((D80-AVERAGE(D$80:D$94))^2/DEVSQ(D$80:D$94))))","v":" "},{"$f":"IF(F80=\" \",\" \",E80-(INTERCEPT(E$80:E$94,D$80:D$94) + SLOPE(E$80:E$94,D$80:D$94)*D80))","v":" "},{"$f":"IF(G80=\" \",\" \",DEVSQ(G$80:G$94) -(G80^2/F80))","v":" "},{"$f":"IF(H80=\" \",\" \",SQRT(H80/(COUNT(D$80:D$94)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N80=\" \",\" \",N80-(INTERCEPT(N$80:N$94,M$80:M$94) + SLOPE(N$80:N$94,M$80:M$94)*M80))","v":" "},{"$f":"IF(N80= \" \", \" \",N80 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$80:N$94)=0,\" \",(SUMPRODUCT(M$80:M$94,N$80:N$94) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$80:M$94))/SUMSQ(M$80:M$94))*M80)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E81=\" \",\" \",1- ( (1/COUNT(D$80:D$94)) + ((D81-AVERAGE(D$80:D$94))^2/DEVSQ(D$80:D$94))))","v":" "},{"$f":"IF(F81=\" \",\" \",E81-(INTERCEPT(E$80:E$94,D$80:D$94) + SLOPE(E$80:E$94,D$80:D$94)*D81))","v":" "},{"$f":"IF(G81=\" \",\" \",DEVSQ(G$80:G$94) -(G81^2/F81))","v":" "},{"$f":"IF(H81=\" \",\" \",SQRT(H81/(COUNT(D$80:D$94)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N81=\" \",\" \",N81-(INTERCEPT(N$80:N$94,M$80:M$94) + SLOPE(N$80:N$94,M$80:M$94)*M81))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$80:$N$94,$M$80:$M$94)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$80:$P$94)/(COUNT($P$80:$P$94)-2))/DEVSQ($M$80:$M$94))","v":{"$error":"#NUM!"}},{"$f":"$T$81- TINV(0.05,COUNT($O$80:$O$94)-2)*$U$81","v":{"$error":"#DIV/0!"}},{"$f":"$T$81 + TINV(0.05,COUNT($O$80:$O$94)-2)*$U$81","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$80:$N$94,$M$80:$M$94)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$80:$P$94)/(COUNT($P$80:$P$94)-2))*((1/COUNT($P$80:$P$94))+(AVERAGE($M$80:$M$94)^2/DEVSQ($M$80:$M$94))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$82- TINV(0.05,COUNT($O$80:$O$94)-2)*$U$82","v":{"$error":"#DIV/0!"}},{"$f":"$T$82 + TINV(0.05,COUNT($O$80:$O$94)-2)*$U$82","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$80:P$94)/DEVSQ($N$80:$N$94))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[7,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E95=\" \",\" \",1- ( (1/COUNT(D$95:D$109)) + ((D95-AVERAGE(D$95:D$109))^2/DEVSQ(D$95:D$109))))","v":" "},{"$f":"IF(F95=\" \",\" \",E95-(INTERCEPT(E$95:E$109,D$95:D$109) + SLOPE(E$95:E$109,D$95:D$109)*D95))","v":" "},{"$f":"IF(G95=\" \",\" \",DEVSQ(G$95:G$109) -(G95^2/F95))","v":" "},{"$f":"IF(H95=\" \",\" \",SQRT(H95/(COUNT(D$95:D$109)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N95=\" \",\" \",N95-(INTERCEPT(N$95:N$109,M$95:M$109) + SLOPE(N$95:N$109,M$95:M$109)*M95))","v":" "},{"$f":"IF(N95= \" \", \" \",N95 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$95:N$109)=0,\" \",(SUMPRODUCT(M$95:M$109,N$95:N$109) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$95:M$109))/SUMSQ(M$95:M$109))*M95)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E96=\" \",\" \",1- ( (1/COUNT(D$95:D$109)) + ((D96-AVERAGE(D$95:D$109))^2/DEVSQ(D$95:D$109))))","v":" "},{"$f":"IF(F96=\" \",\" \",E96-(INTERCEPT(E$95:E$109,D$95:D$109) + SLOPE(E$95:E$109,D$95:D$109)*D96))","v":" "},{"$f":"IF(G96=\" \",\" \",DEVSQ(G$95:G$109) -(G96^2/F96))","v":" "},{"$f":"IF(H96=\" \",\" \",SQRT(H96/(COUNT(D$95:D$109)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N96=\" \",\" \",N96-(INTERCEPT(N$95:N$109,M$95:M$109) + SLOPE(N$95:N$109,M$95:M$109)*M96))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$95:$N$109,$M$95:$M$109)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$95:$P$109)/(COUNT($P$95:$P$109)-2))/DEVSQ($M$95:$M$109))","v":{"$error":"#NUM!"}},{"$f":"$T$96- TINV(0.05,COUNT($O$95:$O$109)-2)*$U$96","v":{"$error":"#DIV/0!"}},{"$f":"$T$96 + TINV(0.05,COUNT($O$95:$O$109)-2)*$U$96","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$95:$N$109,$M$95:$M$109)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$95:$P$109)/(COUNT($P$95:$P$109)-2))*((1/COUNT($P$95:$P$109))+(AVERAGE($M$95:$M$109)^2/DEVSQ($M$95:$M$109))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$97- TINV(0.05,COUNT($O$95:$O$109)-2)*$U$97","v":{"$error":"#DIV/0!"}},{"$f":"$T$97 + TINV(0.05,COUNT($O$95:$O$109)-2)*$U$97","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," ",{"$f":"\" \"","v":" "}," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$95:P$109)/DEVSQ($N$95:$N$109))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[8,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E110=\" \",\" \",1- ( (1/COUNT(D$110:D$124)) + ((D110-AVERAGE(D$110:D$124))^2/DEVSQ(D$110:D$124))))","v":" "},{"$f":"IF(F110=\" \",\" \",E110-(INTERCEPT(E$110:E$124,D$110:D$124) + SLOPE(E$110:E$124,D$110:D$124)*D110))","v":" "},{"$f":"IF(G110=\" \",\" \",DEVSQ(G$110:G$124) -(G110^2/F110))","v":" "},{"$f":"IF(H110=\" \",\" \",SQRT(H110/(COUNT(D$110:D$124)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N110=\" \",\" \",N110-(INTERCEPT(N$110:N$124,M$110:M$124) + SLOPE(N$110:N$124,M$110:M$124)*M110))","v":" "},{"$f":"IF(N110= \" \", \" \",N110 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$110:N$124)=0,\" \",(SUMPRODUCT(M$110:M$124,N$110:N$124) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$110:M$124))/SUMSQ(M$110:M$124))*M110)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E111=\" \",\" \",1- ( (1/COUNT(D$110:D$124)) + ((D111-AVERAGE(D$110:D$124))^2/DEVSQ(D$110:D$124))))","v":" "},{"$f":"IF(F111=\" \",\" \",E111-(INTERCEPT(E$110:E$124,D$110:D$124) + SLOPE(E$110:E$124,D$110:D$124)*D111))","v":" "},{"$f":"IF(G111=\" \",\" \",DEVSQ(G$110:G$124) -(G111^2/F111))","v":" "},{"$f":"IF(H111=\" \",\" \",SQRT(H111/(COUNT(D$110:D$124)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N111=\" \",\" \",N111-(INTERCEPT(N$110:N$124,M$110:M$124) + SLOPE(N$110:N$124,M$110:M$124)*M111))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$110:$N$124,$M$110:$M$124)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$110:$P$124)/(COUNT($P$110:$P$124)-2))/DEVSQ($M$110:$M$124))","v":{"$error":"#NUM!"}},{"$f":"$T$111- TINV(0.05,COUNT($O$110:$O$124)-2)*$U$111","v":{"$error":"#DIV/0!"}},{"$f":"$T$111 + TINV(0.05,COUNT($O$110:$O$124)-2)*$U$111","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$110:$N$124,$M$110:$M$124)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$110:$P$124)/(COUNT($P$110:$P$124)-2))*((1/COUNT($P$110:$P$124))+(AVERAGE($M$110:$M$124)^2/DEVSQ($M$110:$M$124))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$112- TINV(0.05,COUNT($O$110:$O$124)-2)*$U$112","v":{"$error":"#DIV/0!"}},{"$f":"$T$112 + TINV(0.05,COUNT($O$110:$O$124)-2)*$U$112","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$110:P$124)/DEVSQ($N$110:$N$124))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[9,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E125=\" \",\" \",1- ( (1/COUNT(D$125:D$139)) + ((D125-AVERAGE(D$125:D$139))^2/DEVSQ(D$125:D$139))))","v":" "},{"$f":"IF(F125=\" \",\" \",E125-(INTERCEPT(E$125:E$139,D$125:D$139) + SLOPE(E$125:E$139,D$125:D$139)*D125))","v":" "},{"$f":"IF(G125=\" \",\" \",DEVSQ(G$125:G$139) -(G125^2/F125))","v":" "},{"$f":"IF(H125=\" \",\" \",SQRT(H125/(COUNT(D$125:D$139)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N125=\" \",\" \",N125-(INTERCEPT(N$125:N$139,M$125:M$139) + SLOPE(N$125:N$139,M$125:M$139)*M125))","v":" "},{"$f":"IF(N125=\" \",\" \",N125-(SUM(N$5:N$154)-AA$13)/AB$13-IF(COUNT(N$125:N$139)=0,\" \",(SUMPRODUCT(M$125:M$139,N$125:N$139)-(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$125:M$139))/SUMSQ(M$125:M$139))*M125)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E126=\" \",\" \",1- ( (1/COUNT(D$125:D$139)) + ((D126-AVERAGE(D$125:D$139))^2/DEVSQ(D$125:D$139))))","v":" "},{"$f":"IF(F126=\" \",\" \",E126-(INTERCEPT(E$125:E$139,D$125:D$139) + SLOPE(E$125:E$139,D$125:D$139)*D126))","v":" "},{"$f":"IF(G126=\" \",\" \",DEVSQ(G$125:G$139) -(G126^2/F126))","v":" "},{"$f":"IF(H126=\" \",\" \",SQRT(H126/(COUNT(D$125:D$139)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N126=\" \",\" \",N126-(INTERCEPT(N$125:N$139,M$125:M$139) + SLOPE(N$125:N$139,M$125:M$139)*M126))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$125:$N$139,$M$125:$M$139)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$125:$P$139)/(COUNT($P$125:$P$139)-2))/DEVSQ($M$125:$M$139))","v":{"$error":"#NUM!"}},{"$f":"$T$126- TINV(0.05,COUNT($O$125:$O$139)-2)*$U$126","v":{"$error":"#DIV/0!"}},{"$f":"$T$126 + TINV(0.05,COUNT($O$125:$O$139)-2)*$U$126","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$125:$N$139,$M$125:$M$139)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$125:$P$139)/(COUNT($P$125:$P$139)-2))*((1/COUNT($P$125:$P$139))+(AVERAGE($M$125:$M$139)^2/DEVSQ($M$125:$M$139))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$127- TINV(0.05,COUNT($O$125:$O$139)-2)*$U$127","v":{"$error":"#DIV/0!"}},{"$f":"$T$127 + TINV(0.05,COUNT($O$125:$O$139)-2)*$U$127","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$125:P$139)/DEVSQ($N$125:$N$139))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," ",{"$f":"IF(I133=\" \", \" \",G133/(I133*SQRT(F133)))","v":" "}," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"},{"$f":"IF(E134=\" \",\" \",LOG10(C134))","v":" "}," "," "," "," "," "," ",{"$f":"IF(J134=\" \",\" \",IF(ABS(J134)>3,\"Yes\",\"No\"))","v":" "},null,{"$f":"IF(K134=\"No\",D134,\" \")","v":" "},{"$f":"IF(K134=\"No\",E134,\" \")","v":" "},{"$f":"IF(N134=\" \",\" \",N134-(INTERCEPT(N$5:N$154,M$5:M$154) + SLOPE(N$5:N$154,M$5:M$154)*M134))","v":" "}," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[10,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E140=\" \",\" \",1- ( (1/COUNT(D$140:D$154)) + ((D140-AVERAGE(D$140:D$154))^2/DEVSQ(D$140:D$154))))","v":" "},{"$f":"IF(F140=\" \",\" \",E140-(INTERCEPT(E$140:E$154,D$140:D$154) + SLOPE(E$140:E$154,D$140:D$154)*D140))","v":" "},{"$f":"IF(G140=\" \",\" \",DEVSQ(G$140:G$154) -(G140^2/F140))","v":" "},{"$f":"IF(H140=\" \",\" \",SQRT(H140/(COUNT(D$140:D$154)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N140=\" \",\" \",N140-(INTERCEPT(N$140:N$154,M$140:M$154) + SLOPE(N$140:N$154,M$140:M$154)*M140))","v":" "},{"$f":"IF(N140= \" \", \" \",N140 -(SUM(N$5:N$154)-AA$13)/AB$13 -IF(COUNT(N$140:N$154)=0,\" \",(SUMPRODUCT(M$140:M$154,N$140:N$154) -(SUM(N$5:N$154)-AA$13)/AB$13*SUM(M$140:M$154))/SUMSQ(M$140:M$154))*M140)","v":" "},null,"Parameter","estimate","std.","95% LB","95% UB"]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," ",{"$f":" IF(E141=\" \",\" \",1- ( (1/COUNT(D$140:D$154)) + ((D141-AVERAGE(D$140:D$154))^2/DEVSQ(D$140:D$154))))","v":" "},{"$f":"IF(F141=\" \",\" \",E141-(INTERCEPT(E$140:E$154,D$140:D$154) + SLOPE(E$140:E$154,D$140:D$154)*D141))","v":" "},{"$f":"IF(G141=\" \",\" \",DEVSQ(G$140:G$154) -(G141^2/F141))","v":" "},{"$f":"IF(H141=\" \",\" \",SQRT(H141/(COUNT(D$140:D$154)-3)))","v":" "}," "," ",null," "," "," ",{"$f":"IF(N141=\" \",\" \",N141-(INTERCEPT(N$140:N$154,M$140:M$154) + SLOPE(N$140:N$154,M$140:M$154)*M141))","v":" "}," ",null,"slope",{"$f":"SLOPE($N$140:$N$154,$M$140:$M$154)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$140:$P$154)/(COUNT($P$140:$P$154)-2))/DEVSQ($M$140:$M$154))","v":{"$error":"#NUM!"}},{"$f":"$T$141- TINV(0.05,COUNT($O$140:$O$154)-2)*$U$141","v":{"$error":"#DIV/0!"}},{"$f":"$T$141 + TINV(0.05,COUNT($O$140:$O$154)-2)*$U$141","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":22698.648518838218,"d":"22698.65"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"intercept",{"$f":"INTERCEPT($N$140:$N$154,$M$140:$M$154)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((SUMSQ($P$140:$P$154)/(COUNT($P$140:$P$154)-2))*((1/COUNT($P$140:$P$154))+(AVERAGE($M$140:$M$154)^2/DEVSQ($M$140:$M$154))))","v":{"$error":"#DIV/0!"}},{"$f":"$T$142- TINV(0.05,COUNT($O$140:$O$154)-2)*$U$142","v":{"$error":"#DIV/0!"}},{"$f":"$T$142 + TINV(0.05,COUNT($O$140:$O$154)-2)*$U$142","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," ",null,"R^2 =",{"$f":"1-(SUMSQ($P$140:P$154)/DEVSQ($N$140:$N$154))","v":{"$error":"#NUM!"}}]
[null,null,{"v":2404.3628000069343,"d":"2404.36"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":234.96328208483078,"d":"234.96"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":43.75221051582523,"d":"43.75"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]
[null,null,{"v":11.776059735208076,"d":"11.78"}," "," "," "," "," "," "," "," ",null," "," "," "," "," "]

{"sheet":"Initial Calibrators","index":2,"n_rows":84,"n_cols":13,"rows_kept":84,"merged":[[0,6,0,8],[62,8,63,12],[64,0,65,1],[66,8,67,12]]}
[{"$nulls":3},"Laboratory-Prepared Calibrators ",null,null,"Only populate cells highlighted in yellow."]
[null,null,"*In C4, enter 1 if undiluted extracts, enter 5 if 5-fold diluted extracts, enter 25 if 25-fold diluted extracts (all dilutions must be the same)"]
["Run","Information ","*Extract Dilution","Calibrator ID","Entero CT","Sketa (SPC) CT","mean dCT",null,"*Estimated cells/ml in stock suspension:",{"$nulls":3},"* In L3 enter 1e6 (CFU/ml in lab-prepared substocks if using standard dilution protocol in Section 11.1.8 of Method), or enter CFU/Bioball from certificate of analysis"]
[1,null,1,"Calib 1",null,null,{"$f":"IF(E4=\"\",\"\",(AVERAGE(E4:E5))-(AVERAGE(F4:F5)))","v":""},null,"**Dilution factor to prepare calibrator sample inoculum",{"$nulls":3},"** In L4 enter 100 (if using standard dilution protocol for lab-prepared substocks in Section 11.3.3 of Method), or enter 1 if using Bioballs"]
[{"$nulls":8},"Estimated cells/calibrator sample :",null,null,{"$f":"L3/L4","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E6=\"\",\"\",(AVERAGE(E6:E7))-(AVERAGE(F6:F7)))","v":""}]
[{"$nulls":8},"Intercept value (from Lab Std Curves sheet):",null,null,{"$f":"'Lab Std Curves'!Z6","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E8=\"\",\"\",(AVERAGE(E8:E9))-(AVERAGE(F8:F9)))","v":""},null,"Slope value (from Lab Std Curves sheet):",null,null,{"$f":"'Lab Std Curves'!Z5","v":{"$error":"#DIV/0!"}}]
[]
[2,null,null,"Calib 1",null,null,{"$f":"IF(E10=\"\",\"\",(AVERAGE(E10:E11))-(AVERAGE(F10:F11)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E12=\"\",\"\",(AVERAGE(E12:E13))-(AVERAGE(F12:F13)))","v":""}]
[{"$nulls":8},"Log sequences / rxn @ avg CT: ",null,null,{"$f":"(E65-L7)/L8","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E14=\"\",\"\",(AVERAGE(E14:E15))-(AVERAGE(F14:F15)))","v":""},null,"Sequences / rxn @ avg CT:",null,null,{"$f":"10^L13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":8},"Sequences /  extract:",null,null,{"$f":"L14/C65","v":{"$error":"#DIV/0!"}}]
[3,null,null,"Calib 1",null,null,{"$f":"IF(E16=\"\",\"\",(AVERAGE(E16:E17))-(AVERAGE(F16:F17)))","v":""},null,"Sequences / Cell or CFU :",null,null,{"$f":"L15/$L$5","v":{"$error":"#DIV/0!"}}]
[{"$nulls":8},"Amplification factor (based on std curve):",null,null,{"$f":"10^(1/-(L8))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E18=\"\",\"\",(AVERAGE(E18:E19))-(AVERAGE(F18:F19)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E20=\"\",\"\",(AVERAGE(E20:E21))-(AVERAGE(F20:F21)))","v":""}]
[]
[4,null,null,"Calib 1",null,null,{"$f":"IF(E22=\"\",\"\",(AVERAGE(E22:E23))-(AVERAGE(F22:F23)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E24=\"\",\"\",(AVERAGE(E24:E25))-(AVERAGE(F24:F25)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E26=\"\",\"\",(AVERAGE(E26:E27))-(AVERAGE(F26:F27)))","v":""}]
[]
[5,null,null,"Calib 1",null,null,{"$f":"IF(E28=\"\",\"\",(AVERAGE(E28:E29))-(AVERAGE(F28:F29)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E30=\"\",\"\",(AVERAGE(E30:E31))-(AVERAGE(F30:F31)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E32=\"\",\"\",(AVERAGE(E32:E33))-(AVERAGE(F32:F33)))","v":""}]
[]
[6,null,null,"Calib 1",null,null,{"$f":"IF(E34=\"\",\"\",(AVERAGE(E34:E35))-(AVERAGE(F34:F35)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E36=\"\",\"\",(AVERAGE(E36:E37))-(AVERAGE(F36:F37)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E38=\"\",\"\",(AVERAGE(E38:E39))-(AVERAGE(F38:F39)))","v":""}]
[]
[7,null,null,"Calib 1",null,null,{"$f":"IF(E40=\"\",\"\",(AVERAGE(E40:E41))-(AVERAGE(F40:F41)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E42=\"\",\"\",(AVERAGE(E42:E43))-(AVERAGE(F42:F43)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E44=\"\",\"\",(AVERAGE(E44:E45))-(AVERAGE(F44:F45)))","v":""}]
[]
[8,null,null,"Calib 1",null,null,{"$f":"IF(E46=\"\",\"\",(AVERAGE(E46:E47))-(AVERAGE(F46:F47)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E48=\"\",\"\",(AVERAGE(E48:E49))-(AVERAGE(F48:F49)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E50=\"\",\"\",(AVERAGE(E50:E51))-(AVERAGE(F50:F51)))","v":""}]
[]
[9,null,null,"Calib 1",null,null,{"$f":"IF(E52=\"\",\"\",(AVERAGE(E52:E53))-(AVERAGE(F52:F53)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E54=\"\",\"\",(AVERAGE(E54:E55))-(AVERAGE(F54:F55)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E56=\"\",\"\",(AVERAGE(E56:E57))-(AVERAGE(F56:F57)))","v":""}]
[]
[10,null,null,"Calib 1",null,null,{"$f":"IF(E58=\"\",\"\",(AVERAGE(E58:E59))-(AVERAGE(F58:F59)))","v":""}]
[]
[{"$nulls":3},"Calib 2",null,null,{"$f":"IF(E60=\"\",\"\",(AVERAGE(E60:E61))-(AVERAGE(F60:F61)))","v":""}]
[]
[{"$nulls":3},"Calib 3",null,null,{"$f":"IF(E62=\"\",\"\",(AVERAGE(E62:E63))-(AVERAGE(F62:F63)))","v":""}]
[{"$nulls":8},"See Method document, Section 9.11, for guidance on manually identifying outlier values in cells E4-E63, F4-F63 and G4-G63"]
[]
["Fraction of extract/reaction:",null,{"$f":"IF(C4=1,(5/600),IF(C4=5,(5/3000),IF(C4=25,(5/15000), )))","v":0.008333333333333333},"Average CT:",{"$f":"AVERAGE(E4:E63)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F4:F63)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G4:G63)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"*Standard deviation:",{"$f":"SQRT($H$70)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT($H$76)","v":{"$error":"#DIV/0!"}},{"$f":"SQRT($H$82)","v":{"$error":"#DIV/0!"}},null,"* Recommended maximum standard deviation values in cells E66, F66 and G66 are 0.33"]
[{"$nulls":3},"**lower bound:",{"$f":"E65-(3*E66)","v":{"$error":"#DIV/0!"}},{"$f":"F65-(3*F66)","v":{"$error":"#DIV/0!"}},{"$f":"G65-(3*G66)","v":{"$error":"#DIV/0!"}},null,"** upper and lower bound values in cells E67-E68, F67-F68 and G67-G68 define acceptance range for ongoing calibrator sample values"]
[{"$nulls":3},"**upper bound:",{"$f":"E65+(3*E66)","v":{"$error":"#DIV/0!"}},{"$f":"F65+(3*F66)","v":{"$error":"#DIV/0!"}},{"$f":"G65+(3*G66)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Entero CT","SS","df","MSS","var.comp"]
[{"$nulls":3},"Total",{"$f":"IF(COUNTBLANK($E$4:$E$63) =60,0,DEVSQ($E$4:$E$63))","v":0},{"$f":"COUNT($E$4:$E$63)-1","v":-1},{"$f":"$E$70/$F$70","v":0},{"$f":"IF(($H$73 <0),0,$H$73) +  IF(($H$71 <0 ), 0, $H$71)+  IF( ($H$72 <0),0,$H$72)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Run",{"$f":" IF(COUNTBLANK($E$4:$E$9)=6,0,(SUM($E$4:$E$9)^2/COUNT($E$4:$E$9))) + IF(COUNTBLANK($E$10:$E$15)=6,0, (SUM($E$10:$E$15)^2/COUNT($E$10:$E$15)))  +  IF(COUNTBLANK($E$16:$E$21)=6,0,(SUM($E$16:$E$21)^2/COUNT($E$16:$E$21))) +   IF(COUNTBLANK($E$22:$E$27)=6,0,(SUM($E$22:$E$27)^2/COUNT($E$22:$E$27)))  +    IF(COUNTBLANK($E$28:$E$33)=6,0, (SUM($E$28:$E$33)^2/COUNT($E$28:$E$33))) +   IF(COUNTBLANK($E$34:$E$39)=6,0,(SUM($E$34:$E$39)^2/COUNT($E$34:$E$39))) +   IF(COUNTBLANK($E$40:$E$45)=6,0,(SUM($E$40:$E$45)^2/COUNT($E$40:$E$45))) +  IF(COUNTBLANK($E$46:$E$51)=6,0,(SUM($E$46:$E$51)^2/COUNT($E$46:$E$51))) + IF(COUNTBLANK($E$52:$E$57)=6,0,(SUM($E$52:$E$57)^2/COUNT($E$52:$E$57)))  + IF(COUNTBLANK($E$58:$E$63)=6,0,(SUM($E$58:$E$63)^2/COUNT($E$58:$E$63)))   -SUM($E$4:$E$63)^2/COUNT($E$4:$E$63)","v":{"$error":"#DIV/0!"}},{"$f":"(IF(COUNTBLANK(E$4:$E$9)=6,0,1)) + (IF(COUNTBLANK($E$10:$E$15)=6,0,1)) + (IF(COUNTBLANK($E$16:$E$21)=6,0,1)) + (IF(COUNTBLANK($E$22:$E$27)=6,0,1)) + (IF(COUNTBLANK($E$28:$E$33)=6,0,1)) + (IF(COUNTBLANK($E$34:$E$39)=6,0,1)) + (IF(COUNTBLANK($E$40:$E$45)=6,0,1)) + (IF(COUNTBLANK($E$46:$E$51)=6,0,1)) + (IF(COUNTBLANK($E$52:$E$57)=6,0,1)) + (IF(COUNTBLANK($E$58:$E$63)=6,0,1)) -1","v":-1},{"$f":"$E$71/$F$71","v":{"$error":"#DIV/0!"}},{"$f":"($G$71-$G$73-((IF(COUNT($E$4:$E$9)=0,0,(COUNT($E$4:$E$6)^2+COUNT($E$7:$E$9)^2)/COUNT($E$4:$E$9))+IF(COUNT($E$13:$E$15)=0,0,(COUNT($E$10:$E$12)^2+COUNT($E$13:$E$15)^2)/COUNT($E$10:$E$15))+IF(COUNT($E$16:$E$21)=0,0,(COUNT($E$16:$E$18)^2+COUNT($E$19:$E$21)^2)/COUNT($E$16:$E$21))+IF(COUNT($E$22:$E$27)=0,0,(COUNT($E$22:$E$24)^2+COUNT($E$25:$E$27)^2)/COUNT($E$22:$E$27))+IF(COUNT($E$28:$E$33)=0,0,(COUNT($E$28:$E$30)^2+COUNT($E$31:$E$33)^2)/COUNT($E$28:$E$33))+IF(COUNT($E$34:$E$39)=0,0,(COUNT($E$34:$E$36)^2+COUNT($E$37:$E$39)^2)/COUNT($E$34:$E$39))+IF(COUNT($E$40:$E$45)=0,0,(COUNT($E$40:$E$42)^2+COUNT($E$43:$E$45)^2)/COUNT($E$40:$E$45))+IF(COUNT($E$46:$E$51)=0,0,(COUNT($E$46:$E$48)^2+COUNT($E$49:$E$51)^2)/COUNT($E$46:E$51))+IF(COUNT($E$52:$E$57)=0,0,(COUNT($E$52:$E$54)^2+COUNT($E$55:$E$57)^2)/COUNT($E$52:$E$57))+IF(COUNT($E$58:$E$63)=0,0,(COUNT($E$58:$E$60)^2+COUNT($E$61:$E$63)^2)/COUNT($E$58:$E$63))-((IF(COUNT($E$4:$E$6)=0,0,COUNT($E$4:$E$6)^2)+IF(COUNT($E$7:$E$9)=0,0,COUNT($E$7:$E$9)^2)+IF(COUNT($E$10:$E$12)=0,0,COUNT($E$10:$E$12)^2)+IF(COUNT($E$13:$E$15)=0,0,COUNT($E$13:$E$15)^2)+IF(COUNT($E$16:$E$18)=0,0,COUNT($E$16:$E$18)^2)+IF(COUNT($E$19:$E$21)=0,0,COUNT($E$19:$E$21)^2)+IF(COUNT($E$22:$E$24)=0,0,COUNT($E$22:$E$24)^2)+IF(COUNT($E$25:$E$27)=0,0,COUNT($E$25:$E$27)^2)+IF(COUNT($E$28:$E$30)=0,0,COUNT($E$28:$E$30)^2)+IF(COUNT($E$31:$E$33)=0,0,COUNT($E$31:$E$33)^2)+IF(COUNT($E$34:$E$36)=0,0,COUNT($E$34:$E$36)^2)+IF(COUNT($E$37:$E$39)=0,0,COUNT($E$37:$E$39)^2)+IF(COUNT($E$40:$E$42)=0,0,COUNT($E$40:$E$42)^2)+IF(COUNT($E$43:$E$45)=0,0,COUNT($E$43:$E$45)^2)+IF(COUNT($E$46:$E$48)=0,0,COUNT($E$46:$E$48)^2)+IF(COUNT($E$49:$E$51)=0,0,COUNT($E$49:$E$51)^2)+IF(COUNT($E$52:$E$54)=0,0,COUNT($E$52:$E$54)^2)+IF(COUNT($E$55:$E$57)=0,0,COUNT($E$55:$E$57)^2)+IF(COUNT($E$58:$E$60)=0,0,COUNT($E$58:$E$60)^2)+IF(COUNT($E$61:$E$63)=0,0,COUNT($E$61:$E$63)^2))/COUNT($E$4:$E$63)))/$F$71)*$H$72)/((COUNT($E$4:$E$63)-((IF(COUNT($E$4:$E$9)=0,0,COUNT($E$4:$E$9)^2)+IF(COUNT($E$10:$E$15)=0,0,COUNT($E$10:$E$15)^2)+IF(COUNT($E$16:$E$21)=0,0,COUNT($E$16:$E$21)^2)+IF(COUNT($E$22:$E$27)=0,0,COUNT($E$22:$E$27)^2)+IF(COUNT($E$28:$E$33)=0,0,COUNT($E$28:$E$33)^2)+IF(COUNT($E$34:$E$39)=0,0,COUNT($E$34:$E$39)^2)+IF(COUNT($E$40:$E$45)=0,0,COUNT($E$40:$E$45)^2)+IF(COUNT($E$46:$E$51)=0,0,COUNT($E$46:$E$51)^2)+IF(COUNT($E$52:$E$57)=0,0,COUNT($E$52:$E$57)^2)+IF(COUNT($E$58:$E$63)=0,0,COUNT($E$58:$E$63)^2))/COUNT($E$4:$E$63)))/$F$71)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib(Run)",{"$f":"$E$70-($E$73+$E$71)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(COUNTBLANK($E$4:$E$6) =3, COUNTBLANK($E$7:$E$9)=3),0,1) + IF(OR(COUNTBLANK($E$10:$E$12) =3, COUNTBLANK($E$13:$E$15)=3),0,1) + IF(OR(COUNTBLANK($E$16:$E$18) =3, COUNTBLANK($E$19:$E$21)=3),0,1) + IF(OR(COUNTBLANK($E$22:$E$24) =3, COUNTBLANK($E$25:$E$27)=3),0,1) + IF(OR(COUNTBLANK($E$28:$E$30) =3, COUNTBLANK($E$31:$E$33)=3),0,1) + IF(OR(COUNTBLANK($E$34:$E$36) =3, COUNTBLANK($E$37:$E$39)=3),0,1) + IF(OR(COUNTBLANK($E$40:$E$42) =3, COUNTBLANK($E$43:$E$45)=3),0,1) + IF(OR(COUNTBLANK($E$46:$E$48) =3, COUNTBLANK($E$49:$E$51)=3),0,1) + IF(OR(COUNTBLANK($E$52:$E$54) =3, COUNTBLANK($E$55:$E$57)=3),0,1) + IF(OR(COUNTBLANK($E$58:$E$60) =3, COUNTBLANK($E$61:$E$63)=3),0,1)","v":0},{"$f":"$E$72/$F$72","v":{"$error":"#DIV/0!"}},{"$f":"($G$72-$G$73)/((COUNT($E$4:$E$63) - (IF(COUNT($E$4:$E$9)=0,0,(COUNT($E$4:$E$6)^2+COUNT($E$7:$E$9)^2)/COUNT($E$4:$E$9))+ IF(COUNT($E$13:$E$15)=0,0,(COUNT($E$10:$E$12)^2+COUNT($E$13:$E$15)^2)/COUNT($E$10:$E$15))+ IF(COUNT($E$16:$E$21)=0,0,(COUNT($E$16:$E$18)^2+COUNT($E$19:$E$21)^2)/COUNT($E$16:$E$21))+ IF(COUNT($E$22:$E$27)=0,0,(COUNT($E$22:$E$24)^2+COUNT($E$25:$E$27)^2)/COUNT($E$22:$E$27)) + IF(COUNT($E$28:$E$33)=0,0,(COUNT($E$28:$E$30)^2+COUNT($E$31:$E$33)^2)/COUNT($E$28:$E$33))+ IF(COUNT($E$34:$E$39)=0,0,(COUNT($E$34:$E$36)^2+COUNT($E$37:$E$39)^2)/COUNT($E$34:$E$39))+ IF(COUNT($E$40:$E$45)=0,0,(COUNT($E$40:$E$42)^2+COUNT($E$43:$E$45)^2)/COUNT($E$40:$E$45))+ IF(COUNT($E$46:E51)=0,0,(COUNT($E$46:$E$48)^2+COUNT($E$49:$E$51)^2)/COUNT($E$46:$E$51))+ IF(COUNT($E$52:$E$57)=0,0,(COUNT($E$52:$E$54)^2+COUNT($E$55:$E$57)^2)/COUNT($E$52:$E$57)) + IF(COUNT($E$58:$E$63)=0,0,(COUNT($E$58:$E$60)^2+COUNT($E$61:$E$63)^2)/COUNT($E$58:$E$63))))/(( ( IF(COUNTBLANK($E$4:$E$6)=3,0,1)+ IF(COUNTBLANK($E$7:$E$9)=3,0,1) + IF(COUNTBLANK($E$10:$E$12)=3,0,1)+ IF(COUNTBLANK($E$13:$E$15)=3,0,1)+  IF(COUNTBLANK($E$16:$E$18)=3,0,1) + IF(COUNTBLANK($E$19:$E$21)=3,0,1) + IF(COUNTBLANK($E$22:$E$24)=3,0,1)+ IF(COUNTBLANK($E$25:$E$27)=3,0,1)+ IF(COUNTBLANK($E$28:$E$30)=3,0,1)+ IF(COUNTBLANK($E$31:$E$33)=3,0,1)+ IF(COUNTBLANK($E$34:$E$36)=3,0,1)+ IF(COUNTBLANK($E$37:$E$39)=3,0,1)+ IF(COUNTBLANK($E$40:$E$42)=3,0,1)+ IF(COUNTBLANK($E$43:$E$45)=3,0,1)+ IF(COUNTBLANK($E$46:$E$48)=3,0,1)+ IF(COUNTBLANK($E$49:$E$51)=3,0,1)+ IF(COUNTBLANK($E$52:$E$54)=3,0,1)+ IF(COUNTBLANK($E$55:$E$57)=3,0,1)+ IF(COUNTBLANK($E$58:$E$60)=3,0,1)+ IF(COUNTBLANK($E$61:$E$63)=3,0,1) )-($F$71+1))))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Residual",{"$f":"IF(COUNTBLANK($E$4:$E$6) =3,0,DEVSQ($E$4:$E$6)) + IF(COUNTBLANK($E$7:$E$9) =3,0,DEVSQ($E$7:$E$9))+IF(COUNTBLANK($E$10:$E$12) =3,0,DEVSQ($E$10:$E$12))+ IF(COUNTBLANK($E$13:$E$15) =3,0,DEVSQ($E$13:$E$15))+ IF(COUNTBLANK($E$16:$E$18) =3,0,DEVSQ($E$16:$E$18)) +IF(COUNTBLANK($E$19:$E$21) =3,0,DEVSQ($E$19:$E$21)) + IF(COUNTBLANK($E$22:$E$24) =3,0,DEVSQ($E$22:$E$24)) + IF(COUNTBLANK($E$25:$E$27) =3,0,DEVSQ($E$25:$E$27)) + IF(COUNTBLANK($E$28:$E$30) =3,0,DEVSQ($E$28:$E$30)) + IF(COUNTBLANK($E$31:$E$33) =3,0,DEVSQ($E$31:$E$33)) + IF(COUNTBLANK($E$34:$E$36) =3,0,DEVSQ($E$34:$E$36)) + IF(COUNTBLANK($E$37:$E$39) =3,0,DEVSQ($E$37:$E$39)) + IF(COUNTBLANK($E$40:$E$42) =3,0,DEVSQ($E$40:$E$42)) + IF(COUNTBLANK($E$43:$E$45) =3,0,DEVSQ($E$43:$E$45)) + IF(COUNTBLANK($E$46:$E$48) =3,0,DEVSQ($E$46:$E$48)) + IF(COUNTBLANK($E$49:$E$51) =3,0,DEVSQ($E$49:$E$51)) + IF(COUNTBLANK($E$52:$E$54) =3,0,DEVSQ($E$52:$E$54)) + IF(COUNTBLANK($E$55:$E$57) =3,0,DEVSQ($E$55:$E$57)) + IF(COUNTBLANK($E$58:$E$60) =3,0,DEVSQ($E$58:$E$60)) + IF(COUNTBLANK($E$61:$E$63) =3,0,DEVSQ($E$61:$E$63))","v":0},{"$f":"IF(COUNTBLANK($E$4:$E$6)=3,0,COUNT($E$4:$E$6)-1)+IF(COUNTBLANK($E$7:$E$9)=3,0,COUNT($E$7:$E$9)-1)+IF(COUNTBLANK($E$10:$E$12)=3,0,COUNT($E$10:$E$12)-1)+IF(COUNTBLANK($E$13:$E$15)=3,0,COUNT($E$13:$E$15)-1)+IF(COUNTBLANK($E$16:$E$18)=3,0,COUNT($E$16:$E$18)-1)+IF(COUNTBLANK($E$19:$E$21)=3,0,COUNT($E$19:$E$21)-1)+IF(COUNTBLANK($E$22:$E$24)=3,0,COUNT($E$22:$E$24)-1)+IF(COUNTBLANK($E$25:$E$27)=3,0,COUNT($E$25:$E$27)-1)+IF(COUNTBLANK($E$28:$E$30)=3,0,COUNT($E$28:$E$30)-1)+IF(COUNTBLANK($E$31:$E$33)=3,0,COUNT($E$31:E$33)-1)+IF(COUNTBLANK($E$34:$E$36)=3,0,COUNT($E$34:$E$36)-1)+IF(COUNTBLANK($E$37:$E$39)=3,0,COUNT($E$37:$E$39)-1)+IF(COUNTBLANK($E$40:$E$42)=3,0,COUNT($E$40:E$42)-1)+IF(COUNTBLANK($E$43:$E$45)=3,0,COUNT($E$43:$E$45)-1)+IF(COUNTBLANK($E$46:$E$48)=3,0,COUNT($E$46:$E$48)-1)+IF(COUNTBLANK($E$49:$E$51)=3,0,COUNT($E$49:$E$51)-1)+IF(COUNTBLANK($E$52:$E$54)=3,0,COUNT($E$52:$E$54)-1)+IF(COUNTBLANK($E$55:$E$57)=3,0,COUNT($E$55:$E$57)-1)+IF(COUNTBLANK($E$58:$E$60)=3,0,COUNT($E$58:$E$60)-1)+IF(COUNTBLANK($E$61:$E$63)=3,0,COUNT($E$61:$E$63)-1)","v":0},{"$f":"$E$73/$F$73","v":{"$error":"#DIV/0!"}},{"$f":"$G$73","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},"SPC CT","SS","df","MSS","var.comp"]
[{"$nulls":3},"Total",{"$f":"IF(COUNTBLANK(F$4:F$63) =60,0,DEVSQ(F$4:F$63))","v":0},{"$f":"COUNT($F$4:$F$63)-1","v":-1},{"$f":"$E$76/$F$76","v":0},{"$f":"IF(($H$79<0),0,$H$79)+IF(($H$77<0),0,$H77)+IF(($H$78<0),0,$H$78)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Run",{"$f":" IF(COUNTBLANK($F$4:$F$9)=6,0,(SUM($F$4:$F$9)^2/COUNT($F$4:$F$9))) + IF(COUNTBLANK($F$10:$F$15)=6,0, (SUM($F$10:$F$15)^2/COUNT($F$10:$F$15)))  +  IF(COUNTBLANK($F$16:$F$21)=6,0,(SUM($F$16:$F$21)^2/COUNT($F$16:$F$21))) +   IF(COUNTBLANK($F$22:$F$27)=6,0,(SUM($F$22:$F$27)^2/COUNT($F$22:$F$27)))  +    IF(COUNTBLANK($F$28:$F$33)=6,0, (SUM($F$28:$F$33)^2/COUNT($F$28:$F$33))) +   IF(COUNTBLANK($F$34:$F$39)=6,0,(SUM($F$34:$F$39)^2/COUNT($F$34:$F$39))) +   IF(COUNTBLANK($F$40:$F$45)=6,0,(SUM($F$40:$F$45)^2/COUNT($F$40:$F$45))) +  IF(COUNTBLANK($F$46:$F$51)=6,0,(SUM($F$46:$F$51)^2/COUNT($F$46:$F$51))) + IF(COUNTBLANK($F$52:$F$57)=6,0,(SUM($F$52:$F$57)^2/COUNT($F$52:$F$57)))  + IF(COUNTBLANK($F$58:$F$63)=6,0,(SUM($F$58:$F$63)^2/COUNT($F$58:$F$63)))   -SUM($F$4:$F$63)^2/COUNT($F$4:$F$63)","v":{"$error":"#DIV/0!"}},{"$f":"(IF(COUNTBLANK($F$4:$F$9)=6,0,1))+(IF(COUNTBLANK($F$10:$F$15)=6,0,1))+(IF(COUNTBLANK($F$16:$F$21)=6,0,1))+(IF(COUNTBLANK($F$22:$F$27)=6,0,1))+(IF(COUNTBLANK($F$28:$F$33)=6,0,1))+(IF(COUNTBLANK($F$34:$F$39)=6,0,1))+(IF(COUNTBLANK($F$40:$F$45)=6,0,1))+(IF(COUNTBLANK($F$46:$F$51)=6,0,1))+(IF(COUNTBLANK($F$52:F$57)=6,0,1))+(IF(COUNTBLANK($F$58:$F$63)=6,0,1))-1","v":-1},{"$f":"$E$77/$F$77","v":{"$error":"#DIV/0!"}},{"$f":"($G$77 -$G$79 - ( (IF(COUNT($F$4:$F$9)=0,0,(COUNT($F$4:$F$6)^2+COUNT($F$7:$F$9)^2)/COUNT($F$4:$F$9))+ IF(COUNT($F$13:$F$15)=0,0,(COUNT($F$10:$F$12)^2+COUNT($F$13:$F$15)^2)/COUNT($F$10:$F$15))+ IF(COUNT($F$16:$F$21)=0,0,(COUNT($F$16:$F$18)^2+COUNT($F$19:$F$21)^2)/COUNT($F$16:$F$21))+ IF(COUNT($F$22:$F$27)=0,0,(COUNT($F$22:$F$24)^2+COUNT($F$25:$F$27)^2)/COUNT($F$22:$F$27)) + IF(COUNT($F$28:$F$33)=0,0,(COUNT($F$28:$F$30)^2+COUNT($F$31:$F$33)^2)/COUNT($F$28:$F$33))+ IF(COUNT($F$34:$F$39)=0,0,(COUNT($F$34:$F$36)^2+COUNT($F$37:$F$39)^2)/COUNT($F$34:$F$39))+ IF(COUNT($F$40:$F$45)=0,0,(COUNT($F$40:$F$42)^2+COUNT($F$43:$F$45)^2)/COUNT($F$40:$F$45))+ IF(COUNT($F$46:$F$51)=0,0,(COUNT($F$46:$F$48)^2+COUNT($F$49:$F$51)^2)/COUNT($F$46:$F$51))+ IF(COUNT($F$52:$F$57)=0,0,(COUNT($F$52:$F$54)^2+COUNT($F$55:$F$57)^2)/COUNT($F$52:$F$57)) + IF(COUNT($F$58:$F$63)=0,0,(COUNT($F$58:$F$60)^2+COUNT($F$61:$F$63)^2)/COUNT($F$58:$F$63)) - ((IF(COUNT($F$4:$F$6)=0,0,COUNT($F$4:$F$6)^2) + IF(COUNT($F$7:$F$9)=0,0,COUNT($F$7:$F$9)^2) + IF(COUNT($F$10:$F$12)=0,0,COUNT($F$10:$F$12)^2) + IF(COUNT($F$13:$F$15)=0,0,COUNT($F$13:$F$15)^2) + IF(COUNT($F$16:$F$18)=0,0,COUNT($F$16:$F$18)^2) + IF(COUNT($F$19:$F$21)=0,0,COUNT($F$19:$F$21)^2) + IF(COUNT($F$22:$F$24)=0,0,COUNT($F$22:$F$24)^2) + IF(COUNT($F$25:$F$27)=0,0,COUNT($F$25:$F$27)^2) + IF(COUNT($F$28:$F$30)=0,0,COUNT($F$28:$F$30)^2) + IF(COUNT($F$31:$F$33)=0,0,COUNT($F$31:$F$33)^2) + IF(COUNT($F$34:$F$36)=0,0,COUNT($F$34:$F$36)^2) + IF(COUNT($F$37:$F$39)=0,0,COUNT($F$37:$F$39)^2) + IF(COUNT($F$40:$F$42)=0,0,COUNT($F$40:$F$42)^2) + IF(COUNT($F$43:$F$45)=0,0,COUNT($F$43:$F$45)^2) + IF(COUNT($F$46:$F$48)=0,0,COUNT($F$46:$F$48)^2) + IF(COUNT($F$49:$F$51)=0,0,COUNT($F$49:$F$51)^2) + IF(COUNT($F$52:$F$54)=0,0,COUNT($F$52:$F$54)^2) + IF(COUNT($F$55:$F$57)=0,0,COUNT($F$55:$F$57)^2) + IF(COUNT($F$58:$F$60)=0,0,COUNT($F$58:$F$60)^2) + IF(COUNT($F$61:$F$63)=0,0,COUNT($F$61:$F$63)^2))/COUNT($F$4:$F$63)))/$F$77 )   *  $H$78)/ ( (COUNT($F$4:$F$63) - ((IF(COUNT($F$4:$F$9)=0,0,COUNT($F$4:$F$9)^2) + IF(COUNT($F$10:$F$15)=0,0,COUNT($F$10:$F$15)^2) + IF(COUNT($F$16:$F$21)=0,0,COUNT($F$16:$F$21)^2) + IF(COUNT($F$22:$F$27)=0,0,COUNT($F$22:$F$27)^2) + IF(COUNT($F$28:$F$33)=0,0,COUNT($F$28:$F$33)^2) + IF(COUNT($F$34:$F$39)=0,0,COUNT($F$34:$F$39)^2) + IF(COUNT($F$40:$F$45)=0,0,COUNT($F$40:$F$45)^2) + IF(COUNT($F$46:$F$51)=0,0,COUNT($F$46:$F$51)^2) + IF(COUNT($F$52:$F$57)=0,0,COUNT($F$52:$F$57)^2) + IF(COUNT($F$58:$F$63)=0,0,COUNT($F$58:$F$63)^2))/COUNT($F$4:$F$63)))/$F$77 )","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Calib(Run)",{"$f":"$E$76-($E$79+$E$77)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(COUNTBLANK($F$4:$F$6) =3, COUNTBLANK($F$7:$F$9)=3),0,1) + IF(OR(COUNTBLANK($F$10:$F$12) =3, COUNTBLANK($F$13:$F$15)=3),0,1) + IF(OR(COUNTBLANK($F$16:$F$18) =3, COUNTBLANK($F$19:$F$21)=3),0,1) + IF(OR(COUNTBLANK($F$22:$F$24) =3, COUNTBLANK($F$25:$F$27)=3),0,1) + IF(OR(COUNTBLANK($F$28:$F$30) =3, COUNTBLANK($F$31:$F$33)=3),0,1) + IF(OR(COUNTBLANK($F$34:$F$36) =3, COUNTBLANK($F$37:$F$39)=3),0,1) + IF(OR(COUNTBLANK($F$40:$F$42) =3, COUNTBLANK($F$43:$F$45)=3),0,1) + IF(OR(COUNTBLANK($F$46:$F$48) =3, COUNTBLANK($F$49:$F$51)=3),0,1) + IF(OR(COUNTBLANK($F$52:$F$54) =3, COUNTBLANK($F$55:$F$57)=3),0,1) + IF(OR(COUNTBLANK($F$58:$F$60) =3, COUNTBLANK($F$61:$F$63)=3),0,1)","v":0},{"$f":"$E$78/$F$78","v":{"$error":"#DIV/0!"}},{"$f":"($G$78-$G$79)/((COUNT($F$4:$F$63) - (IF(COUNT($F$4:$F$9)=0,0,(COUNT($F$4:$F$6)^2+COUNT($F$7:$F$9)^2)/COUNT($F$4:$F$9))+ IF(COUNT($F$13:$F$15)=0,0,(COUNT($F$10:$F$12)^2+COUNT($F$13:$F$15)^2)/COUNT($F$10:$F$15))+ IF(COUNT($F$16:$F$21)=0,0,(COUNT($F$16:$F$18)^2+COUNT($F$19:$F$21)^2)/COUNT($F$16:$F$21))+ IF(COUNT($F$22:$F$27)=0,0,(COUNT($F$22:$F$24)^2+COUNT($F$25:$F$27)^2)/COUNT($F$22:$F$27)) + IF(COUNT($F$28:$F$33)=0,0,(COUNT($F$28:$F$30)^2+COUNT($F$31:$F$33)^2)/COUNT($F$28:$F$33))+ IF(COUNT($F$34:$F$39)=0,0,(COUNT($F$34:$F$36)^2+COUNT($F$37:$F$39)^2)/COUNT($F$34:$F$39))+ IF(COUNT($F$40:$F$45)=0,0,(COUNT($F$40:$F$42)^2+COUNT($F$43:$F$45)^2)/COUNT($F$40:$F$45))+ IF(COUNT($F$46:$F$51)=0,0,(COUNT($F$46:$F$48)^2+COUNT($F$49:$F$51)^2)/COUNT($F$46:$F$51))+ IF(COUNT($F$52:$F$57)=0,0,(COUNT($F$52:$F$54)^2+COUNT($F$55:$F$57)^2)/COUNT($F$52:$F$57)) + IF(COUNT($F$58:$F$63)=0,0,(COUNT($F$58:$F$60)^2+COUNT($F$61:$F$63)^2)/COUNT($F$58:$F$63))))/(( ( IF(COUNTBLANK($F$4:$F$6)=3,0,1)+ IF(COUNTBLANK($F$7:$F$9)=3,0,1) + IF(COUNTBLANK($F$10:$F$12)=3,0,1)+ IF(COUNTBLANK($F$13:$F$15)=3,0,1)+  IF(COUNTBLANK($F$16:$F$18)=3,0,1) + IF(COUNTBLANK($F$19:$F$21)=3,0,1) + IF(COUNTBLANK($F$22:$F$24)=3,0,1)+ IF(COUNTBLANK($F$25:$F$27)=3,0,1)+ IF(COUNTBLANK($F$28:$F$30)=3,0,1)+ IF(COUNTBLANK($F$31:$F$33)=3,0,1)+ IF(COUNTBLANK($F$34:$F$36)=3,0,1)+ IF(COUNTBLANK($F$37:$F$39)=3,0,1)+ IF(COUNTBLANK($F$40:$F$42)=3,0,1)+ IF(COUNTBLANK($F$43:$F$45)=3,0,1)+ IF(COUNTBLANK($F$46:$F$48)=3,0,1)+ IF(COUNTBLANK($F$49:$F$51)=3,0,1)+ IF(COUNTBLANK($F$52:$F$54)=3,0,1)+ IF(COUNTBLANK($F$55:$F$57)=3,0,1)+ IF(COUNTBLANK($F$58:$F$60)=3,0,1)+ IF(COUNTBLANK($F$61:$F$63)=3,0,1) )-($F$77+1))))","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Residual",{"$f":"IF(COUNTBLANK($F$4:$F$6) =3,0,DEVSQ($F$4:$F$6)) + IF(COUNTBLANK($F$7:$F$9) =3,0,DEVSQ($F$7:$F$9))+IF(COUNTBLANK($F$10:$F$12) =3,0,DEVSQ($F$10:$F$12))+ IF(COUNTBLANK($F$13:$F$15) =3,0,DEVSQ($F$13:$F$15))+ IF(COUNTBLANK($F$16:$F$18) =3,0,DEVSQ($F$16:$F$18)) +IF(COUNTBLANK($F$19:$F$21) =3,0,DEVSQ($F$19:$F$21)) + IF(COUNTBLANK($F$22:$F$24) =3,0,DEVSQ($F$22:$F$24)) + IF(COUNTBLANK($F$25:$F$27) =3,0,DEVSQ($F$25:$F$27)) + IF(COUNTBLANK($F$28:$F$30) =3,0,DEVSQ($F$28:$F$30)) + IF(COUNTBLANK($F$31:$F$33) =3,0,DEVSQ($F$31:$F$33)) + IF(COUNTBLANK($F$34:$F$36) =3,0,DEVSQ($F$34:$F$36)) + IF(COUNTBLANK($F$37:$F$39) =3,0,DEVSQ($F$37:$F$39)) + IF(COUNTBLANK($F$40:$F$42) =3,0,DEVSQ($F$40:$F$42)) + IF(COUNTBLANK($F$43:$F$45) =3,0,DEVSQ($F$43:$F$45)) + IF(COUNTBLANK($F$46:$F$48) =3,0,DEVSQ($F$46:$F$48)) + IF(COUNTBLANK($F$49:$F$51) =3,0,DEVSQ($F$49:$F$51)) + IF(COUNTBLANK($F$52:$F$54) =3,0,DEVSQ($F$52:$F$54)) + IF(COUNTBLANK($F$55:$F$57) =3,0,DEVSQ($F$55:$F$57)) + IF(COUNTBLANK($F$58:$F$60) =3,0,DEVSQ($F$58:$F$60)) + IF(COUNTBLANK($F$61:$F$63) =3,0,DEVSQ($F$61:$F$63))","v":0},{"$f":"IF(COUNTBLANK($F$4:$F$6)=3,0,COUNT($F4:$F$6)-1)+IF(COUNTBLANK($F$7:$F$9)=3,0,COUNT($F$7:$F$9)-1)+IF(COUNTBLANK($F$10:$F$12)=3,0,COUNT($F$10:$F$12)-1)+IF(COUNTBLANK($F$13:$F$15)=3,0,COUNT($F$13:$F$15)-1)+IF(COUNTBLANK($F$16:$F$18)=3,0,COUNT($F$16:$F$18)-1)+IF(COUNTBLANK($F$19:$F$21)=3,0,COUNT($F$19:F21)-1)+IF(COUNTBLANK($F$22:$F$24)=3,0,COUNT($F$22:$F$24)-1)+IF(COUNTBLANK($F$25:$F$27)=3,0,COUNT($F$25:$F$27)-1)+IF(COUNTBLANK($F$28:$F$30)=3,0,COUNT($F$28:$F$30)-1)+IF(COUNTBLANK($F$31:$F$33)=3,0,COUNT($F$31:$F$33)-1)+IF(COUNTBLANK($F$34:$F$36)=3,0,COUNT($F$34:$F$36)-1)+IF(COUNTBLANK($F$37:$F$39)=3,0,COUNT($F$37:$F$39)-1)+IF(COUNTBLANK($F$40:$F$42)=3,0,COUNT($F$40:$F$42)-1)+IF(COUNTBLANK($F$43:$F$45)=3,0,COUNT($F$43:$F$45)-1)+IF(COUNTBLANK($F$46:$F$48)=3,0,COUNT($F$46:$F$48)-1)+IF(COUNTBLANK($F$49:$F$51)=3,0,COUNT($F$49:$F$51)-1)+IF(COUNTBLANK($F$52:F$54)=3,0,COUNT($F$52:F$54)-1)+IF(COUNTBLANK($F$55:$F$57)=3,0,COUNT($F$55:$F$57)-1)+IF(COUNTBLANK($F$58:$F$60)=3,0,COUNT($F$58:$F$60)-1)+IF(COUNTBLANK($F$61:$F$63)=3,0,COUNT($F$61:$F$63)-1)","v":0},{"$f":"$E$79/$F$79","v":{"$error":"#DIV/0!"}},{"$f":"$G79","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},"dCT","SS","df","MSS","var.comp"]
[{"$nulls":3},"Total",{"$f":"IF(COUNTBLANK($G$4:$G$63) =60,0,DEVSQ($G$4:$G$63))","v":0},{"$f":"COUNT($G$4:$G$63)-1","v":-1},{"$f":"$E$82/$F$82","v":0},{"$f":"  IF(($H$83 <0 ), 0, $H$83)+  IF( ($H$84<0),0,$H$84)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Run",{"$f":" IF(COUNTBLANK($G$4:$G$9)=6,0,(SUM($G$4:$G$9)^2/COUNT($G$4:$G$9))) + IF(COUNTBLANK($G$10:$G$15)=6,0, (SUM($G$10:$G$15)^2/COUNT($G$10:$G$15)))  +  IF(COUNTBLANK($G$16:$G$21)=6,0,(SUM($G$16:$G$21)^2/COUNT($G$16:$G$21))) +   IF(COUNTBLANK($G$22:$G$27)=6,0,(SUM($G$22:$G$27)^2/COUNT($G$22:$G$27)))  +    IF(COUNTBLANK($G$28:$G$33)=6,0, (SUM($G$28:$G$33)^2/COUNT($G$28:$G$33))) +   IF(COUNTBLANK($G$34:$G$39)=6,0,(SUM($G$34:$G$39)^2/COUNT($G$34:$G$39))) +   IF(COUNTBLANK($G$40:$G$45)=6,0,(SUM($G$40:$G$45)^2/COUNT($G$40:$G$45))) +  IF(COUNTBLANK($G$46:$G$51)=6,0,(SUM($G$46:$G$51)^2/COUNT($G$46:$G$51))) + IF(COUNTBLANK($G$52:$G$57)=6,0,(SUM($G$52:$G$57)^2/COUNT($G$52:$G$57)))  + IF(COUNTBLANK($G$58:$G$63)=6,0,(SUM($G$58:$G$63)^2/COUNT($G$58:$G$63)))   -SUM($G$4:$G$63)^2/COUNT($G$4:$G$63)","v":{"$error":"#DIV/0!"}},{"$f":"(IF(COUNTBLANK($G$4:$G$9)=6,0,1)) + (IF(COUNTBLANK($G$10:$G$15)=6,0,1)) + (IF(COUNTBLANK($G$16:$G$21)=6,0,1)) + (IF(COUNTBLANK($G$22:$G$27)=6,0,1)) + (IF(COUNTBLANK($G$28:$G$33)=6,0,1)) + (IF(COUNTBLANK($G$34:$G$39)=6,0,1)) + (IF(COUNTBLANK($G$40:$G$45)=6,0,1)) + (IF(COUNTBLANK($G$46:$G$51)=6,0,1)) + (IF(COUNTBLANK($G$52:$G$57)=6,0,1)) + (IF(COUNTBLANK($G$58:$G$63)=6,0,1)) -1","v":-1},{"$f":"$E$83/$F$83","v":{"$error":"#DIV/0!"}},{"$f":"($G$83-((IF(COUNT($G$4:$G$9)=0,0,(COUNT($G$4:$G$6)^2+COUNT($G$7:$G$9)^2)/COUNT($G$4:$G$9))+IF(COUNT($G$10:$G$15)=0,0,(COUNT($G$10:$G$12)^2+COUNT($G$13:$G$15)^2)/COUNT($G$10:$G$15))+IF(COUNT($G$16:$G$21)=0,0,(COUNT($G$16:$G$18)^2+COUNT($G$19:$G$21)^2)/COUNT($G$16:$G$21))+IF(COUNT($G$22:$G$27)=0,0,(COUNT($G$22:$G$24)^2+COUNT($G$25:$G$27)^2)/COUNT($G$22:$G$27))+IF(COUNT($G$28:$G$33)=0,0,(COUNT($G$28:$G$30)^2+COUNT($G$31:$G$33)^2)/COUNT($G$28:$G$33))+IF(COUNT($G$34:$G$39)=0,0,(COUNT($G$34:$G$36)^2+COUNT($G$37:$G$39)^2)/COUNT($G$34:$G$39))+IF(COUNT($G$40:$G$45)=0,0,(COUNT($G$40:$G$42)^2+COUNT($G$43:$G$45)^2)/COUNT($G$40:$G$45))+IF(COUNT($G$46:$G$51)=0,0,(COUNT($G$46:$G$48)^2+COUNT($G$49:$G$51)^2)/COUNT($G$46:$G$51))+IF(COUNT($G$52:$G$57)=0,0,(COUNT($G$52:$G$54)^2+COUNT($G$55:$G$57)^2)/COUNT($G$52:$G$57))+IF(COUNT($G$58:$G$63)=0,0,(COUNT($G$58:$G$60)^2+COUNT($G$61:$G$63)^2)/COUNT($G$58:$G$63))-((IF(COUNT($G$4:$G$6)=0,0,COUNT($G$4:$G$6)^2)+IF(COUNT($G$7:$G$9)=0,0,COUNT($G$7:$G$9)^2)+IF(COUNT($G$10:$G$12)=0,0,COUNT($G$10:$G$12)^2)+IF(COUNT($G$13:$G$15)=0,0,COUNT($G$13:$G$15)^2)+IF(COUNT($G$16:$G$18)=0,0,COUNT($G$16:$G$18)^2)+IF(COUNT($G$19:$G$21)=0,0,COUNT($G$19:$G$21)^2)+IF(COUNT($G$22:$G$24)=0,0,COUNT($G$22:$G$24)^2)+IF(COUNT($G$25:$G$27)=0,0,COUNT($G$25:$G$27)^2)+IF(COUNT($G$28:$G$30)=0,0,COUNT($G$28:$G$30)^2)+IF(COUNT($G$31:$G$33)=0,0,COUNT($G$31:$G$33)^2)+IF(COUNT($G$34:$G$36)=0,0,COUNT($G$34:$G$36)^2)+IF(COUNT($G$37:$G$39)=0,0,COUNT($G$37:$G$39)^2)+IF(COUNT($G$40:$G$42)=0,0,COUNT($G$40:$G$42)^2)+IF(COUNT($G$43:$G$45)=0,0,COUNT($G$43:$G$45)^2)+IF(COUNT($G$46:$G$48)=0,0,COUNT($G$46:$G$48)^2)+IF(COUNT($G$49:$G$51)=0,0,COUNT($G$49:$G$51)^2)+IF(COUNT($G$52:$G$54)=0,0,COUNT($G$52:$G$54)^2)+IF(COUNT($G$55:$G$57)=0,0,COUNT($G$55:$G$57)^2)+IF(COUNT($G$58:$G$60)=0,0,COUNT($G$58:$G$60)^2)+IF(COUNT($G$61:$G$63)=0,0,COUNT($G$61:$G$63)^2))/COUNT($G$4:$G$63)))/$F$83)*$H$84)/((COUNT($G$4:$G$63)-((IF(COUNT($G$4:$G$9)=0,0,COUNT($G$4:$G$9)^2)+IF(COUNT($G$10:$G$15)=0,0,COUNT($G$10:$G$15)^2)+IF(COUNT($G$16:$G$21)=0,0,COUNT($G$16:$G$21)^2)+IF(COUNT($G$22:$G$27)=0,0,COUNT($G$22:$G$27)^2)+IF(COUNT($G$28:$G$33)=0,0,COUNT($G$28:$G$33)^2)+IF(COUNT($G$34:$G$39)=0,0,COUNT($G$34:$G$39)^2)+IF(COUNT($G$40:$G$45)=0,0,COUNT($G$40:$G$45)^2)+IF(COUNT($G$46:$G$51)=0,0,COUNT($G$46:$G$51)^2)+IF(COUNT($G$52:$G$57)=0,0,COUNT($G$52:$G$57)^2)+IF(COUNT($G$58:$G$63)=0,0,COUNT($G$58:$G$63)^2))/COUNT($G$4:$G$63)))/$F$83)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Residual",{"$f":"$E$82-($E$83)","v":{"$error":"#DIV/0!"}},{"$f":"$F$82 -$F$83","v":0},{"$f":"$E$84/$F$84","v":{"$error":"#DIV/0!"}},{"$f":"$G$84","v":{"$error":"#DIV/0!"}}]

{"sheet":"IPR","index":3,"n_rows":53,"n_cols":13,"rows_kept":53,"merged":[[17,8,18,8],[17,9,18,9],[17,10,18,10],[41,8,42,8],[41,9,42,9],[41,10,42,10],[41,11,42,11],[41,12,42,12]]}
[{"$nulls":3},"Laboratory ddCT - Initial Precision and Recovery of Reference Matrix Spike Samples"]
["Only populate/modify cells highlighted in yellow."]
["Dilutions must be same as for initial calibrators","*If the IAC assay is not performed, enter zeros \"0\" in all cells of this spreadsheet where Entero and Sketa Ct values have been entered in the same row"]
[]
["Positive Controls","Entero CT","*IAC CT","Sketa CT","Entero QC","SPC QC","Calib dCT"]
["Calibrator 1",{"$nulls":3},{"$f":"IF(OR(B6<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B6>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D6<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D6>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D6)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B7<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B7>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D7<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D7>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D7)","v":{"$error":"#DIV/0!"}}]
["Calibrator 2",{"$nulls":3},{"$f":"IF(OR(B8<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B8>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D8<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D8>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D8)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B9<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B9>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D9<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D9>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D9)","v":{"$error":"#DIV/0!"}}]
["Calibrator 3",{"$nulls":3},{"$f":"IF(OR(B10<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B10>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D10<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D10>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D10)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B11<('Initial Calibrators'!E$65-(3*'Initial Calibrators'!E$66)),B11>('Initial Calibrators'!E$65+(3*'Initial Calibrators'!E$66))),\"fail\",B11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D11<('Initial Calibrators'!F$65-(3*'Initial Calibrators'!F$66)),D11>('Initial Calibrators'!F$65+(3*'Initial Calibrators'!F$66))),\"fail\",D11)","v":{"$error":"#DIV/0!"}}]
["avg:",{"$nulls":3},{"$f":"AVERAGE(E6:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F6:F11)","v":{"$error":"#DIV/0!"}},{"$f":"E12-F12","v":{"$error":"#DIV/0!"}}]
["avg+3:",{"$nulls":4},{"$f":"F12+3","v":{"$error":"#DIV/0!"}}]
[]
["Avg sequences/extract (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L15","v":{"$error":"#DIV/0!"}}]
["Amplification Factor (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L17","v":{"$error":"#DIV/0!"}}]
[]
["Dilutions must be same as for positive controls",{"$nulls":7},"Estimated Calibrator Sequences","Calibrator Sequence Equivalents (CSE)","Percent Recovery"]
["Test Samples","Entero  CT","*IAC CT","Sketa CT","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Reference Matrix Spike 1",{"$nulls":3},{"$f":"IF(B20=\"Undetermined\",\"Undetermined\",SUM(B20-D20))","v":{"v":0,"d":"0.00"}},{"$f":"$G$12","v":{"$error":"#DIV/0!"}},{"$f":"IF(E20=\"Undetermined\", \"Undetermined\",SUM(E20-F20))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E20=\"Undetermined\", \"Undetermined\",($E$16^-G20))","v":{"$error":"#DIV/0!"}},{"$f":"$E$15","v":{"$error":"#DIV/0!"}},{"$f":"H20*I20","v":{"$error":"#DIV/0!"}},{"$f":"(J20/I20)*100","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike 1",{"$nulls":3},{"$f":"IF(B21=\"Undetermined\",\"Undetermined\",SUM(B21-D21))","v":{"v":0,"d":"0.00"}},{"$f":"$G$12","v":{"$error":"#DIV/0!"}},{"$f":"IF(E21=\"Undetermined\", \"Undetermined\",SUM(E21-F21))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"H21*I21","v":{"$error":"#DIV/0!"}},{"$f":"(J21/I21)*100","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike 2",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 2",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 3",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 3",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 4",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 4",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 5",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 5",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 6",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 6",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 7",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 7",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 8",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 8",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 9",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 9",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 10",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 10",{"$nulls":3},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["Calculations for mean CT's from duplicate analyses",{"$nulls":7},"Estimated Calibrator Sequences","Calibrator Sequence Equivalents (CSE)","Percent Recovery","IPR Mean Percent Recovery","IPR Relative Percent Standard Deviation (RSD)"]
["Test Samples","Entero  CT","IAC CT","Sketa CT","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Reference Matrix Spike 1",{"$f":"AVERAGE(B20:B21)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C20:C21)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D20:D21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(B44=\"Undetermined\",\"Undetermined\",SUM(B44-D44))","v":{"$error":"#DIV/0!"}},{"$f":"$G$12","v":{"$error":"#DIV/0!"}},{"$f":"IF(E44=\"Undetermined\", \"Undetermined\",SUM(E44-F44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E44=\"Undetermined\", \"Undetermined\",($E$16^-G44))","v":{"$error":"#DIV/0!"}},{"$f":"$E$15","v":{"$error":"#DIV/0!"}},{"$f":"H44*I44","v":{"$error":"#DIV/0!"}},{"$f":"(J44/I44)*100","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(K44:K53)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(K44:K53)","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike 2",{"$f":"AVERAGE(B22:B23)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C22:C23)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D22:D23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 3",{"$f":"AVERAGE(B24:B25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C24:C25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D24:D25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 4",{"$f":"AVERAGE(B26:B27)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C26:C27)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D26:D27)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 5",{"$f":"AVERAGE(B28:B29)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C28:C29)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D28:D29)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 6",{"$f":"AVERAGE(B30:B31)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C30:C31)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D30:D31)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 7",{"$f":"AVERAGE(B32:B33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C32:C33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D32:D33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 8",{"$f":"AVERAGE(B34:B35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C34:C35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D34:D35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 9",{"$f":"AVERAGE(B36:B37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C36:C37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D36:D37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Reference Matrix Spike 10",{"$f":"AVERAGE(B38:B39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C38:C39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D38:D39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Test Samples (AB Format)","index":4,"n_rows":92,"n_cols":20,"rows_kept":92,"merged":[[0,0,0,12],[4,0,5,0],[15,16,28,16],[18,0,19,0],[23,14,28,14],[23,15,28,15],[23,17,28,17],[24,13,28,13],[28,0,29,0],[29,11,30,11],[29,12,30,12],[29,13,30,13],[29,14,30,14],[29,15,30,15],[29,16,30,16],[29,17,30,17],[67,18,70,19],[71,11,72,11],[71,12,72,12],[71,13,72,13],[71,14,72,14],[71,15,72,15],[71,16,72,16],[71,17,72,17],[71,18,72,18],[71,19,72,19]]}
["Laboratory ddCT - PBS and Water Matrix Samples"]
["Only populate/modify cells highlighted in yellow."]
["This row can be used to enter Sample Batch Information, e.g. date and location of samples, reagent lot #'s, etc."]
["Extract dilutions must be same as for initial calibrators","*If the IAC assay is not performed, enter zeros \"0\" in all cells of this spreadsheet where Entero and Sketa Ct values have been entered in the same row"]
["Positive Controls                           (same run as test samples)","**At least one of the calibrator Entero and SPC Ct measurements as well as the avg dCT value must pass QC for test sample calculations to be performed"]
[null,"Entero CT","*IAC CT","Sketa CT","Entero QC","Sketa QC","Calib dCT","**dCT QC"]
["Calibrator 1",{"$nulls":3},{"$f":"IF(OR(B7<('Initial Calibrators'!E$67),B7>('Initial Calibrators'!E$68)),\"\",B7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D7<('Initial Calibrators'!F$67),D7>('Initial Calibrators'!F$68)),\"\",D7)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B8<('Initial Calibrators'!E$67),B8>('Initial Calibrators'!E$68)),\"\",B8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D8<('Initial Calibrators'!F$67),D8>('Initial Calibrators'!F$68)),\"\",D8)","v":{"$error":"#DIV/0!"}}]
["Calibrator 2",{"$nulls":3},{"$f":"IF(OR(B9<('Initial Calibrators'!E$67),B9>('Initial Calibrators'!E$68)),\"\",B9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D9<('Initial Calibrators'!F$67),D9>('Initial Calibrators'!F$68)),\"\",D9)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B10<('Initial Calibrators'!E$67),B10>('Initial Calibrators'!E$68)),\"\",B10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D10<('Initial Calibrators'!F$67),D10>('Initial Calibrators'!F$68)),\"\",D10)","v":{"$error":"#DIV/0!"}}]
["Calibrator 3",{"$nulls":3},{"$f":"IF(OR(B11<('Initial Calibrators'!E$67),B11>('Initial Calibrators'!E$68)),\"\",B11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D11<('Initial Calibrators'!F$67),D11>('Initial Calibrators'!F$68)),\"\",D11)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B12<('Initial Calibrators'!E$67),B12>('Initial Calibrators'!E$68)),\"\",B12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D12<('Initial Calibrators'!F$67),D12>('Initial Calibrators'!F$68)),\"\",D12)","v":{"$error":"#DIV/0!"}}]
["avg:",{"$nulls":3},{"$f":"AVERAGE(E7:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F7:F12)","v":{"$error":"#DIV/0!"}},{"$f":"E13-F13","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(G13<('Initial Calibrators'!G$67),G13>('Initial Calibrators'!G$68)),\"fail\",G13)","v":{"$error":"#DIV/0!"}}]
["avg+3:",{"$nulls":4},{"$f":"F13+3","v":{"$error":"#DIV/0!"}}]
[]
["Avg estimated sequences/extract (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L15","v":{"$error":"#DIV/0!"}},{"$nulls":11},"*From: Detection and Quantification Limits of EPA Enterococcus qPCR Methods, Office of Science and Technology (4303T), Office of Water, Washington, DC 20460, EPA 820-R-13-013"]
["Amplification Factor (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L17","v":{"$error":"#DIV/0!"}}]
[]
["Negative Controls                          (same run as test samples)","*\"Undetermined\" Entero CT results should be substituted with \"40\" for Entero QC analysis "]
[null,"*Entero CT","*IAC CT","Sketa CT","Entero QC","IAC QC"]
["NTC or Method Blank 1",{"$nulls":3},{"$f":"IF(OR(B21=\"\",B22=\"\"),\"\",AVERAGE(B21:B22))","v":""},{"$f":"IF(OR(C21>35,C21=\"undetermined\",C21=\"\"),\"fail\", \"OK\")","v":"fail"}]
[{"$nulls":5},{"$f":"IF(OR(C22>35,C22=\"undetermined\",C22=\"\"),\"fail\", \"OK\")","v":"fail"}]
["NTC or Method Blank 2",{"$nulls":3},{"$f":"IF(OR(B23=\"\",B24=\"\"),\"\",AVERAGE(B23:B24))","v":""},"fail"]
[{"$nulls":5},"fail",{"$nulls":8},"These values are used only for comparisons with Target Sequence Copy (TSC) limit of quantification","*Enter \"1\" if undiluted extract, \"5\" if 5x dilution, \"25\" if 25x dilution below",null,"*If Method blanks give a quantitative result ('Yes' in row 32), corresponding test sample results may be invalid"]
["NTC or Method Blank 3",{"$nulls":3},{"$f":"IF(OR(B25=\"\",B26=\"\"),\"\",AVERAGE(B25:B26))","v":""},"fail",{"$nulls":7},"*CCE are currently the final reporting units (these values are per volume of water filtered)"]
[{"$nulls":5},"fail"]
["avg:",{"$f":"AVERAGE(B21:B26)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C21:C26)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D21:D26)","v":{"$error":"#DIV/0!"}},{"$f":"SMALL(E21:E26,1)","v":{"$error":"#NUM!"}}]
["avg+1.5:",null,{"$f":"C27+1.5","v":{"$error":"#DIV/0!"}}]
["Enter your own water sample ID's. Extract dilutions should be same as for positive controls"]
[{"$nulls":11},"Estimated Calibrator Sequences/Extract","Calibrator Sequence Equivalents (CSE)","*RWQC-adjusted Calibrator Cell Equivalents (CCE)","Unadjusted CSE","*Extract Dilution","*TSC Limit of Quantification","*Reportable Quantitative Result"]
["Test Samples (1 instrument run)","Entero  CT","*IAC CT","Sketa CT","IAC QC","SPC QC","QC","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Method Blanks",{"$f":"E27","v":{"$error":"#NUM!"}},{"$f":"C27","v":{"$error":"#DIV/0!"}},{"$f":"D27","v":{"$error":"#DIV/0!"}},{"$f":"IF(C32>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D32>F$14, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E32=\"fail\",F32=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B32=\"Undetermined\",\"Undetermined\",SUM(B32-D32))","v":{"$error":"#NUM!"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H32=\"Undetermined\", \"Undetermined\",SUM(H32-I32))","v":{"$error":"#NUM!"}},{"$f":"IF(H32=\"Undetermined\", \"Undetermined\",($E$17^-J32))","v":{"$error":"#NUM!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",K32*L32))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",M32/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",($E$17^(-(B32-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF((P32=1),568,IF((P32=5),2841,IF((P32=25),14206,\"\")))","v":""},{"$f":"IF((O32=\"QC fail\"),\"QC fail\",IF((O32=\"Undetected\"),\"Undetected\",IF((O32>Q32),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike",{"$nulls":3},{"$f":"IF(C33>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D33>F$14, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E33=\"fail\",F33=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B33=\"Undetermined\",\"Undetermined\",SUM(B33-D33))","v":{"v":0,"d":"0.00"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H33=\"Undetermined\", \"Undetermined\",SUM(H33-I33))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H33=\"Undetermined\", \"Undetermined\",($E$17^-J33))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",K33*L33))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",M33/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",($E$17^(-(B33-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF((P33=1),568,IF((P33=5),2841,IF((P33=25),14206,\"\")))","v":""},{"$f":"IF((O33=\"QC fail\"),\"QC fail\",IF((O33=\"Undetected\"),\"Undetected\",IF((O33>Q33),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike",{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"IF(D34>F$14, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E34=\"fail\",F34=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B34=\"Undetermined\",\"Undetermined\",SUM(B34-D34))","v":{"v":0,"d":"0.00"}},{"$error":"#DIV/0!"},{"$f":"IF(H34=\"Undetermined\", \"Undetermined\",SUM(H34-I34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H34=\"Undetermined\", \"Undetermined\",($E$17^-J34))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G34=\"QC fail\"),\"QC fail\",IF((B34=\"Undetermined\"),\"Undetected\",K34*L34))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G34=\"QC fail\"),\"QC fail\",IF((B34=\"Undetermined\"),\"Undetected\",M34/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID Matrix Spike (MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID Matrix Spike (MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID (same ID as MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID (same ID as MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 2 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 2 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 3 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 3 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 4 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 4 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 5 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 5 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 6 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 6 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 7 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 7 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 8 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 8 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 9 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 9 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 10 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 10 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 11 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 11 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 12 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 12 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 13 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 13 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 14 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 14 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 15 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 15 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 16 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 16 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"},"*OPR and MSR calculations are only valid if same cell suspension is used for matrix spike and positive control (calibrator) samples"]
[]
[]
[]
["calculations for mean CT's from duplicate analyses",{"$nulls":10},"Estimated Calibrator Sequences","Calibrator Sequence Equivalents (CSE)","*RWQC-adjusted Calibrator Cell Equivalents (CCE)","Unadjusted CSE","*Extract Dilution","*Limit of Quantification","*Reportable Quantitative Result","*Ongoing Percent Recovery (OPR)","*Matrix Spike Percent Recovery (MSR)"]
["Test Samples (1 instrument run)","Entero  CT","IAC CT","Sketa CT","IAC QC","SPC QC","QC","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Method Blanks",{"$f":"B32","v":{"$error":"#NUM!"}},{"$f":"C32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"O32","v":{"$error":"#DIV/0!"}},0,{"$f":"IF((P74=1),568,IF((P74=5),2841,IF((P74=25),14206,\"\")))","v":""},{"$f":"IF((O74=\"QC fail\"),\"QC fail\",IF((O74=\"Undetected\"),\"Undetected\",IF((O74>Q74),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
[{"$f":"A33","v":"Reference Matrix Spike"},{"$f":"IF(AND(B33=\"undetermined\",B34=\"undetermined\"),\"undetermined\",AVERAGE(B33:B34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C33=\"undetermined\",C34=\"undetermined\"),\"fail\",AVERAGE(C33:C34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D33=\"undetermined\",D34=\"undetermined\"),\"fail\",AVERAGE(D33:D34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C75>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F33=\"fail\",F34=\"fail\",D75>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E75=\"fail\",F75=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B75=\"Undetermined\",\"Undetermined\",SUM(B75-D75))","v":{"$error":"#DIV/0!"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H75=\"Undetermined\", \"Undetermined\",SUM(H75-I75))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H75=\"Undetermined\", \"Undetermined\",($E$17^-J75))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G75=\"QC fail\"),\"QC fail\",IF((B75=\"Undetermined\"),\"Undetected\",K75*L75))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G75=\"QC fail\"),\"QC fail\",IF((B75=\"Undetermined\"),\"Undetected\",M75/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G75=\"QC fail\"),\"QC fail\",IF((B75=\"Undetermined\"),\"Undetected\",($E$17^(-(B75-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},{"$f":"P33","v":0},"",{"$f":"IF((O75=\"QC fail\"),\"QC fail\",IF((O75=\"Undetected\"),\"Undetected\",IF((O75>Q75),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}},{"$f":"(M75/L75)*100","v":{"$error":"#DIV/0!"}}]
[{"$f":"A35","v":"Water Sample 1 ID Matrix Spike (MS)"},{"$f":"IF(AND(B35=\"undetermined\",B36=\"undetermined\"),\"undetermined\",AVERAGE(B35:B36))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C35=\"undetermined\",C36=\"undetermined\"),\"fail\",AVERAGE(C35:C36))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D35=\"undetermined\",D36=\"undetermined\"),\"fail\",AVERAGE(D35:D36))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F35=\"fail\",F36=\"fail\",D76>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E76=\"fail\",F76=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B76=\"Undetermined\",\"Undetermined\",SUM(B76-D76))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H76=\"Undetermined\", \"Undetermined\",SUM(H76-I76))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H76=\"Undetermined\", \"Undetermined\",($E$17^-J76))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G76=\"QC fail\"),\"QC fail\",IF((B76=\"Undetermined\"),\"Undetected\",K76*L76))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G76=\"QC fail\"),\"QC fail\",IF((B76=\"Undetermined\"),\"Undetected\",M76/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P35","v":0},"",{"$error":"#DIV/0!"},null,{"$f":"IF(OR(N76=\"undetected\",N77=\"undetected\",N76=\"QC fail\",N77=\"QC fail\"),\"not determined\",((M76-M77)/L76)*100)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A37","v":"Water Sample 1 ID (same ID as MS)"},{"$f":"IF(AND(B37=\"undetermined\",B38=\"undetermined\"),\"undetermined\",AVERAGE(B37:B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C37=\"undetermined\",C38=\"undetermined\"),\"fail\",AVERAGE(C37:C38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D37=\"undetermined\",D38=\"undetermined\"),\"fail\",AVERAGE(D37:D38))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F37=\"fail\",F38=\"fail\",D77>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E77=\"fail\",F77=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B77=\"Undetermined\",\"Undetermined\",SUM(B77-D77))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H77=\"Undetermined\", \"Undetermined\",SUM(H77-I77))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H77=\"Undetermined\", \"Undetermined\",($E$17^-J77))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G77=\"QC fail\"),\"QC fail\",IF((B77=\"Undetermined\"),\"Undetected\",K77*L77))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G77=\"QC fail\"),\"QC fail\",IF((B77=\"Undetermined\"),\"Undetected\",M77/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P37","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A39","v":"Water Sample 2 ID"},{"$f":"IF(AND(B39=\"undetermined\",B40=\"undetermined\"),\"undetermined\",AVERAGE(B39:B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C39=\"undetermined\",C40=\"undetermined\"),\"fail\",AVERAGE(C39:C40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D39=\"undetermined\",D40=\"undetermined\"),\"fail\",AVERAGE(D39:D40))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F39=\"fail\",F40=\"fail\",D78>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E78=\"fail\",F78=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B78=\"Undetermined\",\"Undetermined\",SUM(B78-D78))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H78=\"Undetermined\", \"Undetermined\",SUM(H78-I78))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H78=\"Undetermined\", \"Undetermined\",($E$17^-J78))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G78=\"QC fail\"),\"QC fail\",IF((B78=\"Undetermined\"),\"Undetected\",K78*L78))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G78=\"QC fail\"),\"QC fail\",IF((B78=\"Undetermined\"),\"Undetected\",M78/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P39","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A41","v":"Water Sample 3 ID"},{"$f":"IF(AND(B41=\"undetermined\",B42=\"undetermined\"),\"undetermined\",AVERAGE(B41:B42))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C41=\"undetermined\",C42=\"undetermined\"),\"fail\",AVERAGE(C41:C42))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D41=\"undetermined\",D42=\"undetermined\"),\"fail\",AVERAGE(D41:D42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F41=\"fail\",F42=\"fail\",D79>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E79=\"fail\",F79=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B79=\"Undetermined\",\"Undetermined\",SUM(B79-D79))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H79=\"Undetermined\", \"Undetermined\",SUM(H79-I79))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H79=\"Undetermined\", \"Undetermined\",($E$17^-J79))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G79=\"QC fail\"),\"QC fail\",IF((B79=\"Undetermined\"),\"Undetected\",K79*L79))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G79=\"QC fail\"),\"QC fail\",IF((B79=\"Undetermined\"),\"Undetected\",M79/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P41","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A43","v":"Water Sample 4 ID"},{"$f":"IF(AND(B43=\"undetermined\",B44=\"undetermined\"),\"undetermined\",AVERAGE(B43:B44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C43=\"undetermined\",C44=\"undetermined\"),\"fail\",AVERAGE(C43:C44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D43=\"undetermined\",D44=\"undetermined\"),\"fail\",AVERAGE(D43:D44))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F43=\"fail\",F44=\"fail\",D80>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E80=\"fail\",F80=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B80=\"Undetermined\",\"Undetermined\",SUM(B80-D80))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H80=\"Undetermined\", \"Undetermined\",SUM(H80-I80))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H80=\"Undetermined\", \"Undetermined\",($E$17^-J80))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G80=\"QC fail\"),\"QC fail\",IF((B80=\"Undetermined\"),\"Undetected\",K80*L80))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G80=\"QC fail\"),\"QC fail\",IF((B80=\"Undetermined\"),\"Undetected\",M80/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P43","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A45","v":"Water Sample 5 ID"},{"$f":"IF(AND(B45=\"undetermined\",B46=\"undetermined\"),\"undetermined\",AVERAGE(B45:B46))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C45=\"undetermined\",C46=\"undetermined\"),\"fail\",AVERAGE(C45:C46))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D45=\"undetermined\",D46=\"undetermined\"),\"fail\",AVERAGE(D45:D46))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F45=\"fail\",F46=\"fail\",D81>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E81=\"fail\",F81=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B81=\"Undetermined\",\"Undetermined\",SUM(B81-D81))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H81=\"Undetermined\", \"Undetermined\",SUM(H81-I81))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H81=\"Undetermined\", \"Undetermined\",($E$17^-J81))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G81=\"QC fail\"),\"QC fail\",IF((B81=\"Undetermined\"),\"Undetected\",K81*L81))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G81=\"QC fail\"),\"QC fail\",IF((B81=\"Undetermined\"),\"Undetected\",M81/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P45","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A47","v":"Water Sample 6 ID"},{"$f":"IF(AND(B47=\"undetermined\",B48=\"undetermined\"),\"undetermined\",AVERAGE(B47:B48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C47=\"undetermined\",C48=\"undetermined\"),\"fail\",AVERAGE(C47:C48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D47=\"undetermined\",D48=\"undetermined\"),\"fail\",AVERAGE(D47:D48))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F47=\"fail\",F48=\"fail\",D82>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E82=\"fail\",F82=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B82=\"Undetermined\",\"Undetermined\",SUM(B82-D82))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H82=\"Undetermined\", \"Undetermined\",SUM(H82-I82))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H82=\"Undetermined\", \"Undetermined\",($E$17^-J82))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G82=\"QC fail\"),\"QC fail\",IF((B82=\"Undetermined\"),\"Undetected\",K82*L82))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G82=\"QC fail\"),\"QC fail\",IF((B82=\"Undetermined\"),\"Undetected\",M82/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P47","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A50","v":"Water Sample 7 ID"},{"$f":"IF(AND(B49=\"undetermined\",B50=\"undetermined\"),\"undetermined\",AVERAGE(B49:B50))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C49=\"undetermined\",C50=\"undetermined\"),\"fail\",AVERAGE(C49:C50))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D49=\"undetermined\",D50=\"undetermined\"),\"fail\",AVERAGE(D49:D50))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F49=\"fail\",F50=\"fail\",D83>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E83=\"fail\",F83=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B83=\"Undetermined\",\"Undetermined\",SUM(B83-D83))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H83=\"Undetermined\", \"Undetermined\",SUM(H83-I83))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H83=\"Undetermined\", \"Undetermined\",($E$17^-J83))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G83=\"QC fail\"),\"QC fail\",IF((B83=\"Undetermined\"),\"Undetected\",K83*L83))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G83=\"QC fail\"),\"QC fail\",IF((B83=\"Undetermined\"),\"Undetected\",M83/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P49","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A52","v":"Water Sample 8 ID"},{"$f":"IF(AND(B51=\"undetermined\",B52=\"undetermined\"),\"undetermined\",AVERAGE(B51:B52))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C51=\"undetermined\",C52=\"undetermined\"),\"fail\",AVERAGE(C51:C52))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D51=\"undetermined\",D52=\"undetermined\"),\"fail\",AVERAGE(D51:D52))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F51=\"fail\",F52=\"fail\",D84>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E84=\"fail\",F84=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B84=\"Undetermined\",\"Undetermined\",SUM(B84-D84))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H84=\"Undetermined\", \"Undetermined\",SUM(H84-I84))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H84=\"Undetermined\", \"Undetermined\",($E$17^-J84))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G84=\"QC fail\"),\"QC fail\",IF((B84=\"Undetermined\"),\"Undetected\",K84*L84))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G84=\"QC fail\"),\"QC fail\",IF((B84=\"Undetermined\"),\"Undetected\",M84/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P51","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A54","v":"Water Sample 9 ID"},{"$f":"IF(AND(B53=\"undetermined\",B54=\"undetermined\"),\"undetermined\",AVERAGE(B53:B54))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C53=\"undetermined\",C54=\"undetermined\"),\"fail\",AVERAGE(C53:C54))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D53=\"undetermined\",D54=\"undetermined\"),\"fail\",AVERAGE(D53:D54))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F53=\"fail\",F54=\"fail\",D85>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E85=\"fail\",F85=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B85=\"Undetermined\",\"Undetermined\",SUM(B85-D85))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H85=\"Undetermined\", \"Undetermined\",SUM(H85-I85))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H85=\"Undetermined\", \"Undetermined\",($E$17^-J85))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G85=\"QC fail\"),\"QC fail\",IF((B85=\"Undetermined\"),\"Undetected\",K85*L85))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G85=\"QC fail\"),\"QC fail\",IF((B85=\"Undetermined\"),\"Undetected\",M85/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P53","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A56","v":"Water Sample 10 ID"},{"$f":"IF(AND(B55=\"undetermined\",B56=\"undetermined\"),\"undetermined\",AVERAGE(B55:B56))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C55=\"undetermined\",C56=\"undetermined\"),\"fail\",AVERAGE(C55:C56))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D55=\"undetermined\",D56=\"undetermined\"),\"fail\",AVERAGE(D55:D56))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F55=\"fail\",F56=\"fail\",D86>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E86=\"fail\",F86=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B86=\"Undetermined\",\"Undetermined\",SUM(B86-D86))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H86=\"Undetermined\", \"Undetermined\",SUM(H86-I86))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H86=\"Undetermined\", \"Undetermined\",($E$17^-J86))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G86=\"QC fail\"),\"QC fail\",IF((B86=\"Undetermined\"),\"Undetected\",K86*L86))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G86=\"QC fail\"),\"QC fail\",IF((B86=\"Undetermined\"),\"Undetected\",M86/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P55","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A58","v":"Water Sample 11 ID"},{"$f":"IF(AND(B57=\"undetermined\",B58=\"undetermined\"),\"undetermined\",AVERAGE(B57:B58))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C57=\"undetermined\",C58=\"undetermined\"),\"fail\",AVERAGE(C57:C58))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D57=\"undetermined\",D58=\"undetermined\"),\"fail\",AVERAGE(D57:D58))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F57=\"fail\",F58=\"fail\",D87>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E87=\"fail\",F87=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B87=\"Undetermined\",\"Undetermined\",SUM(B87-D87))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H87=\"Undetermined\", \"Undetermined\",SUM(H87-I87))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H87=\"Undetermined\", \"Undetermined\",($E$17^-J87))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G87=\"QC fail\"),\"QC fail\",IF((B87=\"Undetermined\"),\"Undetected\",K87*L87))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G87=\"QC fail\"),\"QC fail\",IF((B87=\"Undetermined\"),\"Undetected\",M87/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P57","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A60","v":"Water Sample 12 ID"},{"$f":"IF(AND(B59=\"undetermined\",B60=\"undetermined\"),\"undetermined\",AVERAGE(B59:B60))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C59=\"undetermined\",C60=\"undetermined\"),\"fail\",AVERAGE(C59:C60))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D59=\"undetermined\",D60=\"undetermined\"),\"fail\",AVERAGE(D59:D60))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F59=\"fail\",F60=\"fail\",D88>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E88=\"fail\",F88=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B88=\"Undetermined\",\"Undetermined\",SUM(B88-D88))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H88=\"Undetermined\", \"Undetermined\",SUM(H88-I88))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H88=\"Undetermined\", \"Undetermined\",($E$17^-J88))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G88=\"QC fail\"),\"QC fail\",IF((B88=\"Undetermined\"),\"Undetected\",K88*L88))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G88=\"QC fail\"),\"QC fail\",IF((B88=\"Undetermined\"),\"Undetected\",M88/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P59","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A62","v":"Water Sample 13 ID"},{"$f":"IF(AND(B61=\"undetermined\",B62=\"undetermined\"),\"undetermined\",AVERAGE(B61:B62))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C61=\"undetermined\",C62=\"undetermined\"),\"fail\",AVERAGE(C61:C62))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D61=\"undetermined\",D62=\"undetermined\"),\"fail\",AVERAGE(D61:D62))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F61=\"fail\",F62=\"fail\",D89>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E89=\"fail\",F89=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B89=\"Undetermined\",\"Undetermined\",SUM(B89-D89))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H89=\"Undetermined\", \"Undetermined\",SUM(H89-I89))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H89=\"Undetermined\", \"Undetermined\",($E$17^-J89))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G89=\"QC fail\"),\"QC fail\",IF((B89=\"Undetermined\"),\"Undetected\",K89*L89))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G89=\"QC fail\"),\"QC fail\",IF((B89=\"Undetermined\"),\"Undetected\",M89/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P61","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A64","v":"Water Sample 14 ID"},{"$f":"IF(AND(B63=\"undetermined\",B64=\"undetermined\"),\"undetermined\",AVERAGE(B63:B64))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C63=\"undetermined\",C64=\"undetermined\"),\"fail\",AVERAGE(C63:C64))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D63=\"undetermined\",D64=\"undetermined\"),\"fail\",AVERAGE(D63:D64))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F63=\"fail\",F64=\"fail\",D90>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E90=\"fail\",F90=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B90=\"Undetermined\",\"Undetermined\",SUM(B90-D90))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H90=\"Undetermined\", \"Undetermined\",SUM(H90-I90))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H90=\"Undetermined\", \"Undetermined\",($E$17^-J90))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G90=\"QC fail\"),\"QC fail\",IF((B90=\"Undetermined\"),\"Undetected\",K90*L90))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G90=\"QC fail\"),\"QC fail\",IF((B90=\"Undetermined\"),\"Undetected\",M90/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P63","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A66","v":"Water Sample 15 ID"},{"$f":"IF(AND(B65=\"undetermined\",B66=\"undetermined\"),\"undetermined\",AVERAGE(B65:B66))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C65=\"undetermined\",C66=\"undetermined\"),\"fail\",AVERAGE(C65:C66))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D65=\"undetermined\",D66=\"undetermined\"),\"fail\",AVERAGE(D65:D66))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F65=\"fail\",F66=\"fail\",D91>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E91=\"fail\",F91=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B91=\"Undetermined\",\"Undetermined\",SUM(B91-D91))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H91=\"Undetermined\", \"Undetermined\",SUM(H91-I91))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H91=\"Undetermined\", \"Undetermined\",($E$17^-J91))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G91=\"QC fail\"),\"QC fail\",IF((B91=\"Undetermined\"),\"Undetected\",K91*L91))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G91=\"QC fail\"),\"QC fail\",IF((B91=\"Undetermined\"),\"Undetected\",M91/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P65","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A68","v":"Water Sample 16 ID"},{"$f":"IF(AND(B67=\"undetermined\",B68=\"undetermined\"),\"undetermined\",AVERAGE(B67:B68))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C67=\"undetermined\",C68=\"undetermined\"),\"fail\",AVERAGE(C67:C68))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D67=\"undetermined\",D68=\"undetermined\"),\"fail\",AVERAGE(D67:D68))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(F67=\"fail\",F68=\"fail\",D92>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E92=\"fail\",F92=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B92=\"Undetermined\",\"Undetermined\",SUM(B92-D92))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H92=\"Undetermined\", \"Undetermined\",SUM(H92-I92))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H92=\"Undetermined\", \"Undetermined\",($E$17^-J92))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G92=\"QC fail\"),\"QC fail\",IF((B92=\"Undetermined\"),\"Undetected\",K92*L92))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G92=\"QC fail\"),\"QC fail\",IF((B92=\"Undetermined\"),\"Undetected\",M92/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P67","v":0},"",{"$error":"#DIV/0!"}]

{"sheet":"TestSamples(SmartCyclerFormat)","index":5,"n_rows":74,"n_cols":20,"rows_kept":74,"merged":[[0,0,0,12],[4,0,5,0],[16,16,28,16],[18,0,19,0],[23,14,28,14],[23,15,28,15],[23,17,28,17],[24,13,28,13],[28,0,29,0],[28,1,29,3],[29,11,30,11],[29,12,30,12],[29,13,30,13],[29,14,30,14],[29,15,30,15],[29,16,30,16],[29,17,30,17],[55,18,58,19],[59,11,60,11],[59,12,60,12],[59,13,60,13],[59,14,60,14],[59,15,60,15],[59,16,60,16],[59,17,60,17],[59,18,60,18],[59,19,60,19]]}
["Laboratory ddCT - PBS and Water Matrix Samples"]
["Only populate/modify cells highlighted in yellow."]
["This row can be used to enter Sample Batch Information, e.g. date and location of samples, reagent lot #'s, etc."]
["Extract dilutions must be same as for initial calibrators","*If the IAC assay is not performed, enter zeros \"0\" in all cells of this spreadsheet where Entero and Sketa Ct values have been entered in the same row"]
["Positive Controls                    (separate run from test samples)","**At least one of the calibrator Entero and SPC Ct measurements as well as the avg dCT value must pass QC for test sample calculations to be performed"]
[null,"Entero CT","*IAC CT","Sketa CT","Entero QC","Sketa QC","Calib dCT","**dCT QC"]
["Calibrator 1",{"$nulls":3},{"$f":"IF(OR(B7<('Initial Calibrators'!E$67),B7>('Initial Calibrators'!E$68)),\"\",B7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D7<('Initial Calibrators'!F$67),D7>('Initial Calibrators'!F$68)),\"\",D7)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B8<('Initial Calibrators'!E$67),B8>('Initial Calibrators'!E$68)),\"\",B8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D8<('Initial Calibrators'!F$67),D8>('Initial Calibrators'!F$68)),\"\",D8)","v":{"$error":"#DIV/0!"}}]
["Calibrator 2",{"$nulls":3},{"$f":"IF(OR(B9<('Initial Calibrators'!E$67),B9>('Initial Calibrators'!E$68)),\"\",B9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D9<('Initial Calibrators'!F$67),D9>('Initial Calibrators'!F$68)),\"\",D9)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B10<('Initial Calibrators'!E$67),B10>('Initial Calibrators'!E$68)),\"\",B10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D10<('Initial Calibrators'!F$67),D10>('Initial Calibrators'!F$68)),\"\",D10)","v":{"$error":"#DIV/0!"}}]
["Calibrator 3",{"$nulls":3},{"$f":"IF(OR(B11<('Initial Calibrators'!E$67),B11>('Initial Calibrators'!E$68)),\"\",B11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D11<('Initial Calibrators'!F$67),D11>('Initial Calibrators'!F$68)),\"\",D11)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},{"$f":"IF(OR(B12<('Initial Calibrators'!E$67),B12>('Initial Calibrators'!E$68)),\"\",B12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D12<('Initial Calibrators'!F$67),D12>('Initial Calibrators'!F$68)),\"\",D12)","v":{"$error":"#DIV/0!"}}]
["avg:",{"$nulls":3},{"$f":"AVERAGE(E7:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F7:F12)","v":{"$error":"#DIV/0!"}},{"$f":"E13-F13","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(G13<('Initial Calibrators'!G$67),G13>('Initial Calibrators'!G$68)),\"fail\",G13)","v":{"$error":"#DIV/0!"}}]
["avg+3:",{"$nulls":4},{"$f":"F13+3","v":{"$error":"#DIV/0!"}}]
[]
["Avg estimated sequences/extract (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L15","v":{"$error":"#DIV/0!"}}]
["Amplification Factor (from initial calibrator sheet):",{"$nulls":3},{"$f":"'Initial Calibrators'!L17","v":{"$error":"#DIV/0!"}},{"$nulls":11},"*From: Detection and Quantification Limits of EPA Enterococcus qPCR Methods, Office of Science and Technology (4303T), Office of Water, Washington, DC 20460, EPA 820-R-13-013"]
[]
["Negative Controls (Method Blanks run with test samples, NTC run with positive controls)","Note: for correct calculations, SmartCycler export file values of \"0\" in this section must be manually changed to: \"40\""]
[null,"Entero CT","*IAC CT","Sketa CT","Entero QC","IAC QC"]
["NTC or Method Blank 1",{"$nulls":3},{"$f":"IF(OR(B21=\"\",B22=\"\"),\"\",AVERAGE(B21:B22))","v":""},{"$f":"IF(OR(C21>35,C21=\"undetermined\",C21=\"\"),\"fail\", \"OK\")","v":"fail"}]
[{"$nulls":5},{"$f":"IF(OR(C22>35,C22=\"undetermined\",C22=\"\"),\"fail\", \"OK\")","v":"fail"}]
["NTC or Method Blank 2",{"$nulls":3},{"$f":"IF(OR(B23=\"\",B24=\"\"),\"\",AVERAGE(B23:B24))","v":""},"fail"]
[{"$nulls":5},"fail",{"$nulls":8},"These values are used only for comparisons with Target Sequence Copy (TSC) limit of quantification","*Enter \"1\" if undiluted extract, \"5\" if 5x dilution, \"25\" if 25x dilution below",null,"*If Method blanks give a quantitative result ('Yes' in row 32), corresponding test sample results may be invalid"]
["NTC or Method Blank 3",{"$nulls":3},{"$f":"IF(OR(B25=\"\",B26=\"\"),\"\",AVERAGE(B25:B26))","v":""},"fail",{"$nulls":7},"*CCE are currently the final reporting units (values are per volume of water filtered)"]
[{"$nulls":5},"fail"]
["avg:",{"$f":"AVERAGE(B21:B26)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C21:C26)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D21:D26)","v":{"$error":"#DIV/0!"}},{"$f":"SMALL(E21:E26,1)","v":{"$error":"#NUM!"}}]
["avg+1.5:",null,{"$f":"C27+1.5","v":{"$error":"#DIV/0!"}}]
["Enter your own water sample ID's. Extract dilutions should be same as for positive controls","Note: for correct calculations, SmartCycler export file values of \"0\" in this section must be manually changed to: \"Undetermined\" "]
[{"$nulls":11},"Estimated Calibrator Sequences/Extract","Calibrator Sequence Equivalents (CSE)","*RWQC-adjusted Calibrator Cell Equivalents (CCE)","Unadjusted CSE","*Extract Dilution","*TSC Limit of Quantification","*Reportable Quantitative Result"]
["Test Samples (2 instrument runs)","Entero  CT","*IAC CT","Sketa CT","IAC QC","SPC QC","QC","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Method Blanks",{"$f":"E27","v":{"$error":"#NUM!"}},{"$f":"C27","v":{"$error":"#DIV/0!"}},{"$f":"D27","v":{"$error":"#DIV/0!"}},{"$f":"IF(C32>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D32>F$14, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E32=\"fail\",F32=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B32=\"Undetermined\",\"Undetermined\",SUM(B32-D32))","v":{"$error":"#NUM!"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H32=\"Undetermined\", \"Undetermined\",SUM(H32-I32))","v":{"$error":"#NUM!"}},{"$f":"IF(H32=\"Undetermined\", \"Undetermined\",($E$17^-J32))","v":{"$error":"#NUM!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",K32*L32))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",M32/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G32=\"QC fail\"),\"QC fail\",IF((B32=\"Undetermined\"),\"Undetected\",($E$17^(-(B32-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF((P32=1),568,IF((P32=5),2841,IF((P32=25),14206,\"\")))","v":""},{"$f":"IF((O32=\"QC fail\"),\"QC fail\",IF((O32=\"Undetected\"),\"Undetected\",IF((O32>Q32),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike",{"$nulls":3},{"$f":"IF(C33>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D33>F$14,D33=\"undetermined\"), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E33=\"fail\",F33=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B33=\"Undetermined\",\"Undetermined\",SUM(B33-D33))","v":{"v":0,"d":"0.00"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H33=\"Undetermined\", \"Undetermined\",SUM(H33-I33))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H33=\"Undetermined\", \"Undetermined\",($E$17^-J33))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",K33*L33))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",M33/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G33=\"QC fail\"),\"QC fail\",IF((B33=\"Undetermined\"),\"Undetected\",($E$17^(-(B33-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF((P33=1),568,IF((P33=5),2841,IF((P33=25),14206,\"\")))","v":""},{"$f":"IF((O33=\"QC fail\"),\"QC fail\",IF((O33=\"Undetected\"),\"Undetected\",IF((O33>Q33),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
["Reference Matrix Spike",{"$nulls":3},{"$f":"IF(C34>C$28, \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(D34>F$14,D34=\"undetermined\"), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E34=\"fail\",F34=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B34=\"Undetermined\",\"Undetermined\",SUM(B34-D34))","v":{"v":0,"d":"0.00"}},{"$error":"#DIV/0!"},{"$f":"IF(H34=\"Undetermined\", \"Undetermined\",SUM(H34-I34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H34=\"Undetermined\", \"Undetermined\",($E$17^-J34))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G34=\"QC fail\"),\"QC fail\",IF((B34=\"Undetermined\"),\"Undetected\",K34*L34))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G34=\"QC fail\"),\"QC fail\",IF((B34=\"Undetermined\"),\"Undetected\",M34/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID Matrix Spike (MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID Matrix Spike (MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID (same ID as MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 1 ID (same ID as MS)",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 2 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 2 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 3 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 3 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 4 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 4 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 5 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 5 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 6 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 6 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 7 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 7 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 8 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 8 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 9 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 9 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 10 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"}]
["Water Sample 10 ID",{"$nulls":3},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"",{"$error":"#DIV/0!"},"*OPR and MSR calculations are only valid if same cell suspension is used for matrix spike and positive control (calibrator) samples"]
[]
[]
[]
["Calculations for mean CT's from duplicate analyses",{"$nulls":10},"Estimated Calibrator Sequences","Calibrator Sequence Equivalents (CSE)","*RWQC-adjusted Calibrator Cell Equivalents (CCE)","Unadjusted CSE","*Extract Dilution","*Limit of Quantification","*Reportable Quantitative Result","*Ongoing Percent Recovery (OPR)","*Matrix Spike Percent Recovery (MSR)"]
["Test Samples","Entero  CT","IAC CT","Sketa CT","IAC QC","SPC QC","QC","dCT","Calib dCT","ddCT","Ratio Calib/Test"]
["Method Blanks",{"$f":"B32","v":{"$error":"#NUM!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"IF((P62=1),568,IF((P62=5),2841,IF((P62=25),14206,\"\")))","v":""},{"$f":"IF((O62=\"QC fail\"),\"QC fail\",IF((O62=\"Undetected\"),\"Undetected\",IF((O62>Q62),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}}]
[{"$f":"A33","v":"Reference Matrix Spike"},{"$f":"IF(AND(B33=\"undetermined\",B34=\"undetermined\"),\"undetermined\",AVERAGE(B33:B34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C33=\"undetermined\",C34=\"undetermined\"),\"fail\",AVERAGE(C33:C34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D33=\"undetermined\",D34=\"undetermined\"),\"fail\",AVERAGE(D33:D34))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C63>F$28,C63=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F33=\"fail\",F34=\"fail\",D63>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E63=\"fail\",F63=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B63=\"Undetermined\",\"Undetermined\",SUM(B63-D63))","v":{"$error":"#DIV/0!"}},{"$f":"$H$13","v":{"$error":"#DIV/0!"}},{"$f":"IF(H63=\"Undetermined\", \"Undetermined\",SUM(H63-I63))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H63=\"Undetermined\", \"Undetermined\",($E$17^-J63))","v":{"$error":"#DIV/0!"}},{"$f":"$E$16","v":{"$error":"#DIV/0!"}},{"$f":"IF((G63=\"QC fail\"),\"QC fail\",IF((B63=\"Undetermined\"),\"Undetected\",K63*L63))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G63=\"QC fail\"),\"QC fail\",IF((B63=\"Undetermined\"),\"Undetected\",M63/15))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G63=\"QC fail\"),\"QC fail\",IF((B63=\"Undetermined\"),\"Undetected\",($E$17^(-(B63-$E$13))*$E$16)))","v":{"$error":"#DIV/0!"}},{"$f":"P33","v":0},"",{"$f":"IF((O63=\"QC fail\"),\"QC fail\",IF((O63=\"Undetected\"),\"Undetected\",IF((O63>Q63),\"Yes\",\"No\")))","v":{"$error":"#DIV/0!"}},{"$f":"(M63/L63)*100","v":{"$error":"#DIV/0!"}}]
[{"$f":"A35","v":"Water Sample 1 ID Matrix Spike (MS)"},{"$f":"IF(AND(B35=\"undetermined\",B36=\"undetermined\"),\"undetermined\",AVERAGE(B35:B36))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C35=\"undetermined\",C36=\"undetermined\"),\"fail\",AVERAGE(C35:C36))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D35=\"undetermined\",D36=\"undetermined\"),\"fail\",AVERAGE(D35:D36))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C64>F$28,C64=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F35=\"fail\",F36=\"fail\",D64>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E64=\"fail\",F64=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B64=\"Undetermined\",\"Undetermined\",SUM(B64-D64))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H64=\"Undetermined\", \"Undetermined\",SUM(H64-I64))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H64=\"Undetermined\", \"Undetermined\",($E$17^-J64))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G64=\"QC fail\"),\"QC fail\",IF((B64=\"Undetermined\"),\"Undetected\",K64*L64))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G64=\"QC fail\"),\"QC fail\",IF((B64=\"Undetermined\"),\"Undetected\",M64/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P35","v":0},"",{"$error":"#DIV/0!"},null,{"$f":"IF(OR(N64=\"undetected\",N65=\"undetected\",N64=\"QC fail\",N65=\"QC fail\"),\"not determined\",((M64-M65)/L64)*100)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A37","v":"Water Sample 1 ID (same ID as MS)"},{"$f":"IF(AND(B37=\"undetermined\",B38=\"undetermined\"),\"undetermined\",AVERAGE(B37:B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C37=\"undetermined\",C38=\"undetermined\"),\"fail\",AVERAGE(C37:C38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D37=\"undetermined\",D38=\"undetermined\"),\"fail\",AVERAGE(D37:D38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C65>F$28,C65=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F37=\"fail\",F38=\"fail\",D65>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E65=\"fail\",F65=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B65=\"Undetermined\",\"Undetermined\",SUM(B65-D65))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H65=\"Undetermined\", \"Undetermined\",SUM(H65-I65))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H65=\"Undetermined\", \"Undetermined\",($E$17^-J65))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G65=\"QC fail\"),\"QC fail\",IF((B65=\"Undetermined\"),\"Undetected\",K65*L65))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G65=\"QC fail\"),\"QC fail\",IF((B65=\"Undetermined\"),\"Undetected\",M65/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P37","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A39","v":"Water Sample 2 ID"},{"$f":"IF(AND(B39=\"undetermined\",B40=\"undetermined\"),\"undetermined\",AVERAGE(B39:B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C39=\"undetermined\",C40=\"undetermined\"),\"fail\",AVERAGE(C39:C40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D39=\"undetermined\",D40=\"undetermined\"),\"fail\",AVERAGE(D39:D40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C66>F$28,C66=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F39=\"fail\",F40=\"fail\",D66>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E66=\"fail\",F66=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B66=\"Undetermined\",\"Undetermined\",SUM(B66-D66))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H66=\"Undetermined\", \"Undetermined\",SUM(H66-I66))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H66=\"Undetermined\", \"Undetermined\",($E$17^-J66))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G66=\"QC fail\"),\"QC fail\",IF((B66=\"Undetermined\"),\"Undetected\",K66*L66))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G66=\"QC fail\"),\"QC fail\",IF((B66=\"Undetermined\"),\"Undetected\",M66/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P39","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A41","v":"Water Sample 3 ID"},{"$f":"IF(AND(B41=\"undetermined\",B42=\"undetermined\"),\"undetermined\",AVERAGE(B41:B42))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C41=\"undetermined\",C42=\"undetermined\"),\"fail\",AVERAGE(C41:C42))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D41=\"undetermined\",D42=\"undetermined\"),\"fail\",AVERAGE(D41:D42))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C67>F$28,C67=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F41=\"fail\",F42=\"fail\",D67>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E67=\"fail\",F67=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B67=\"Undetermined\",\"Undetermined\",SUM(B67-D67))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H67=\"Undetermined\", \"Undetermined\",SUM(H67-I67))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H67=\"Undetermined\", \"Undetermined\",($E$17^-J67))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G67=\"QC fail\"),\"QC fail\",IF((B67=\"Undetermined\"),\"Undetected\",K67*L67))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G67=\"QC fail\"),\"QC fail\",IF((B67=\"Undetermined\"),\"Undetected\",M67/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P41","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A43","v":"Water Sample 4 ID"},{"$f":"IF(AND(B43=\"undetermined\",B44=\"undetermined\"),\"undetermined\",AVERAGE(B43:B44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C43=\"undetermined\",C44=\"undetermined\"),\"fail\",AVERAGE(C43:C44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D43=\"undetermined\",D44=\"undetermined\"),\"fail\",AVERAGE(D43:D44))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C68>F$28,C68=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F43=\"fail\",F44=\"fail\",D68>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E68=\"fail\",F68=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B68=\"Undetermined\",\"Undetermined\",SUM(B68-D68))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H68=\"Undetermined\", \"Undetermined\",SUM(H68-I68))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H68=\"Undetermined\", \"Undetermined\",($E$17^-J68))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G68=\"QC fail\"),\"QC fail\",IF((B68=\"Undetermined\"),\"Undetected\",K68*L68))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G68=\"QC fail\"),\"QC fail\",IF((B68=\"Undetermined\"),\"Undetected\",M68/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P43","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A45","v":"Water Sample 5 ID"},{"$f":"IF(AND(B45=\"undetermined\",B46=\"undetermined\"),\"undetermined\",AVERAGE(B45:B46))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C45=\"undetermined\",C46=\"undetermined\"),\"fail\",AVERAGE(C45:C46))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D45=\"undetermined\",D46=\"undetermined\"),\"fail\",AVERAGE(D45:D46))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C69>F$28,C69=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F45=\"fail\",F46=\"fail\",D69>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E69=\"fail\",F69=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B69=\"Undetermined\",\"Undetermined\",SUM(B69-D69))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H69=\"Undetermined\", \"Undetermined\",SUM(H69-I69))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H69=\"Undetermined\", \"Undetermined\",($E$17^-J69))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G69=\"QC fail\"),\"QC fail\",IF((B69=\"Undetermined\"),\"Undetected\",K69*L69))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G69=\"QC fail\"),\"QC fail\",IF((B69=\"Undetermined\"),\"Undetected\",M69/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P45","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A47","v":"Water Sample 6 ID"},{"$f":"IF(AND(B47=\"undetermined\",B48=\"undetermined\"),\"undetermined\",AVERAGE(B47:B48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C47=\"undetermined\",C48=\"undetermined\"),\"fail\",AVERAGE(C47:C48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D47=\"undetermined\",D48=\"undetermined\"),\"fail\",AVERAGE(D47:D48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C70>F$28,C70=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F47=\"fail\",F48=\"fail\",D70>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E70=\"fail\",F70=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B70=\"Undetermined\",\"Undetermined\",SUM(B70-D70))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H70=\"Undetermined\", \"Undetermined\",SUM(H70-I70))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H70=\"Undetermined\", \"Undetermined\",($E$17^-J70))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G70=\"QC fail\"),\"QC fail\",IF((B70=\"Undetermined\"),\"Undetected\",K70*L70))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G70=\"QC fail\"),\"QC fail\",IF((B70=\"Undetermined\"),\"Undetected\",M70/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P47","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A49","v":"Water Sample 7 ID"},{"$f":"IF(AND(B49=\"undetermined\",B50=\"undetermined\"),\"undetermined\",AVERAGE(B49:B50))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C49=\"undetermined\",C50=\"undetermined\"),\"fail\",AVERAGE(C49:C50))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D49=\"undetermined\",D50=\"undetermined\"),\"fail\",AVERAGE(D49:D50))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C71>F$28,C71=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F49=\"fail\",F50=\"fail\",D71>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E71=\"fail\",F71=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B71=\"Undetermined\",\"Undetermined\",SUM(B71-D71))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H71=\"Undetermined\", \"Undetermined\",SUM(H71-I71))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H71=\"Undetermined\", \"Undetermined\",($E$17^-J71))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G71=\"QC fail\"),\"QC fail\",IF((B71=\"Undetermined\"),\"Undetected\",K71*L71))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G71=\"QC fail\"),\"QC fail\",IF((B71=\"Undetermined\"),\"Undetected\",M71/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P49","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A51","v":"Water Sample 8 ID"},{"$f":"IF(AND(B51=\"undetermined\",B52=\"undetermined\"),\"undetermined\",AVERAGE(B51:B52))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C51=\"undetermined\",C52=\"undetermined\"),\"fail\",AVERAGE(C51:C52))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D51=\"undetermined\",D52=\"undetermined\"),\"fail\",AVERAGE(D51:D52))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C72>F$28,C72=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F51=\"fail\",F52=\"fail\",D72>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E72=\"fail\",F72=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B72=\"Undetermined\",\"Undetermined\",SUM(B72-D72))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H72=\"Undetermined\", \"Undetermined\",SUM(H72-I72))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H72=\"Undetermined\", \"Undetermined\",($E$17^-J72))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G72=\"QC fail\"),\"QC fail\",IF((B72=\"Undetermined\"),\"Undetected\",K72*L72))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G72=\"QC fail\"),\"QC fail\",IF((B72=\"Undetermined\"),\"Undetected\",M72/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P51","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A53","v":"Water Sample 9 ID"},{"$f":"IF(AND(B53=\"undetermined\",B54=\"undetermined\"),\"undetermined\",AVERAGE(B53:B54))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C53=\"undetermined\",C54=\"undetermined\"),\"fail\",AVERAGE(C53:C54))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D53=\"undetermined\",D54=\"undetermined\"),\"fail\",AVERAGE(D53:D54))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C73>F$28,C73=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F53=\"fail\",F54=\"fail\",D73>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E73=\"fail\",F73=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B73=\"Undetermined\",\"Undetermined\",SUM(B73-D73))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H73=\"Undetermined\", \"Undetermined\",SUM(H73-I73))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H73=\"Undetermined\", \"Undetermined\",($E$17^-J73))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G73=\"QC fail\"),\"QC fail\",IF((B73=\"Undetermined\"),\"Undetected\",K73*L73))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G73=\"QC fail\"),\"QC fail\",IF((B73=\"Undetermined\"),\"Undetected\",M73/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P53","v":0},"",{"$error":"#DIV/0!"}]
[{"$f":"A55","v":"Water Sample 10 ID"},{"$f":"IF(AND(B55=\"undetermined\",B56=\"undetermined\"),\"undetermined\",AVERAGE(B55:B56))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C55=\"undetermined\",C56=\"undetermined\"),\"fail\",AVERAGE(C55:C56))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(D55=\"undetermined\",D56=\"undetermined\"),\"fail\",AVERAGE(D55:D56))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(C74>F$28,C74=\"undetermined\"),\"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(F55=\"fail\",F56=\"fail\",D74>F$14), \"fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(E74=\"fail\",F74=\"fail\"),\"QC fail\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B74=\"Undetermined\",\"Undetermined\",SUM(B74-D74))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(H74=\"Undetermined\", \"Undetermined\",SUM(H74-I74))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H74=\"Undetermined\", \"Undetermined\",($E$17^-J74))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF((G74=\"QC fail\"),\"QC fail\",IF((B74=\"Undetermined\"),\"Undetected\",K74*L74))","v":{"$error":"#DIV/0!"}},{"$f":"IF((G74=\"QC fail\"),\"QC fail\",IF((B74=\"Undetermined\"),\"Undetected\",M74/15))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"P55","v":0},"",{"$error":"#DIV/0!"}]