{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Example standard curve","Lab-prep Std curve ","Lab Calibrators","BioBall Calibrators","Lab ddCT - Water Matrix","BioBall ddCT-Water Matrix"],"not_rendered":{"charts":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Example standard curve","index":0,"n_rows":56,"n_cols":16,"rows_kept":56,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]]}
["EPA Method 1611 Calculation Spreadsheet"]
["October 2012"]
["EPA  821-R-12-013"]
[]
["Lab Prepared Standard Curves Example",{"$nulls":6},"SUMMARY OUTPUT"]
["Sequences","Log Sequences","CT"]
[40000,{"$f":"LOG10(A7)","v":4.6020599913279625},22.64,{"$nulls":4},"Regression Statistics"]
[4000,3.6020599913279625,26.05,{"$nulls":4},"Multiple R",0.9988739306133065]
[400,2.6020599913279625,29.47,{"$nulls":4},"R Square",0.9977491292588768]
[100,2,31.89,{"$nulls":4},"Adjusted R Square",0.997588352777368]
[40000,4.6020599913279625,22.58,{"$nulls":4},"Standard Error",0.18589469523812555]
[4000,3.6020599913279625,26.01,{"$nulls":4},"Observations",16]
[400,2.6020599913279625,29.99]
[100,2,32.1,{"$nulls":4},"ANOVA"]
[40000,4.6020599913279625,22.2,{"$nulls":5},"df","SS","MS","F","Significance F"]
[4000,3.6020599913279625,26.12,{"$nulls":4},"Regression",1,214.4533480219526,214.4533480219526,6205.815178287023,6.137752002202638e-20]
[400,2.6020599913279625,30.02,{"$nulls":4},"Residual",14,0.4837957280474582,0.034556837717675586]
[100,2,31.93,{"$nulls":4},"Total",15,214.93714375000005]
[40000,4.6020599913279625,22.47]
[4000,3.6020599913279625,25.92,{"$nulls":5},"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
[400,2.6020599913279625,29.85,{"$nulls":4},"Intercept",39.42944608144751,0.15722867897672707,250.77769741539225,5.6668857087152294E-27,39.09222380387462,39.7666683590204,39.09222380387462,39.7666683590204]
[100,2,32.31,{"$nulls":4},"X Variable 1",-3.6958940466199013,0.04691590452301312,-78.77699650460745,6.13775200220324E-20,-3.7965187435938197,-3.595269349645983,-3.7965187435938197,-3.595269349645983]
[]
["To do the statistical analysis of your data:"]
["1. Click on tools at top of screen - check to see if you have \"data analysis\" as an option, if you do, "]
["    skip to step 3."]
["2. If not, click on options instead, then add-ins, then check the box next to Analysis Tool Pack, "]
["    click on OK, then wait while the program loads (your screen will go black and then come back), when "]
["    its done click on tools again and you should see \"data analysis\" as an option at the bottom "]
["3. Click on data analysis, regression, OK"]
["4. Click on the icon for the input y range in the resulting Regression window, a much smaller box "]
["    should appear with the \"regression\" heading over it - using your mouse, highlight the CT values on "]
["    the main spreadsheet,  the selected cells, e.g. \"$C$3:$C$18\" should appear in the box, close"]
["    the small window to accept these values "]
["5. Click on the icon for the input x range, and this time highlight the log sequences , and accept "]
["    as in step 4"]
["6. Click on the radio button for the output range, then click on the icon in the box- small window "]
["    appears as above, click on cell F3 on main spreadsheet - $F$3 should appear in small window"]
["    (very important to use this and ONLY this cell, or else the rest of the spreadsheets will not work)"]
["    then close small window to accept this output range"]
["7. Click on OK in Regression window - you should see a summary output table (filling cells F3 to G10), "]
["    an ANOVA table (cells F12 to K16), and an intercept-X variable table (F18-N20)"]
[]
["To make a standard curve with equation:",{"$nulls":6},"Figure 1. Standard Curve"]
["1. Highlight the log sequences AND the CT values using your mouse "]
["2. Click on the chart wizard icon on the toolbar, which looks like a bar graph, under chart type "]
["    select XY scatter, click next to see the chart and finish to get it"]
["3. At this point it is easier to finish playing with the chart before you move it - right click in the white "]
["    space under the word series on the right of the chart"]
["4. Options, chart title - type in either referee prepared or laboratory prepared, as appropriate - note "]
["    that everything you type shows up immediately on the chart.  For value (x) axis, type log sequences, "]
["    and for value (y) axis, type CT, and click ok"]
["5. Click on chart word at top of screen, add trendline, options tab, click on box to the left of both "]
["    display equation on chart and \"display R-squared value on chart,\" click OK"]
["6. You can move the equation and the R squared information by clicking on any of the squares around"]
["     this information and dragging it to where you want"]

{"sheet":"Lab-prep Std curve ","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[0,0,0,3],[1,0,1,2]]}
["Laboratory Prepared Standard Curves"]
["Only populate cells highlighted in yellow.",{"$nulls":4},"For summary data output, follow instructions given on the \"Example standard curve\" tab and place cursor in cell F3"]
["Standard Curve "]
["Date: "]
["Sequences","Log Sequences","CT"]
[4000,{"$f":"LOG10(A6)","v":3.6020599913279625}]
[400,2.6020599913279625]
[100,2]
[40,1.6020599913279623]
[4000,3.6020599913279625]
[400,2.6020599913279625]
[100,2]
[40,1.6020599913279623]
[4000,3.6020599913279625]
[400,2.6020599913279625]
[100,2]
[40,1.6020599913279623]

{"sheet":"Lab Calibrators","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"merged":[[0,4,0,6],[1,1,1,2],[1,11,2,17],[3,1,5,1],[3,11,3,19],[8,8,11,8],[14,1,14,2]]}
[null,"Laboratory-Prepared Calibrators ",null,null,"Only populate cells highlighted in yellow."]
[{"$nulls":11},"Example calculation for starting conc of 10^9 cells/ml in undiluted cell suspension: (10^9 cells/ml) divided by dilution factor (100) multiplied by volume of dilution added to calibrator sample  (0.01ml) = 100,000 cells"]
["Calibrator ID","Calibrator ID","Entero CT","SPC CT","dCT",null,"Estimated number of cells from calibrator/filter (based on spec reading):",{"$nulls":3},"cells"]
["Calib 1:","Diluted (1:5)",null,null,{"$f":"SUM(C4-D4)","v":{"v":0,"d":"0.00"}},null,"Estimated CFU/calibrator sample (based on plate counts):",{"$nulls":3},"CFU"]
["Calib 2:",{"$nulls":3},{"$f":"SUM(C5-D5)","v":{"v":0,"d":"0.00"}},null,"Crude Extract"]
["Calib 3:",{"$nulls":3},{"$f":"SUM(C6-D6)","v":{"v":0,"d":"0.00"}},null,"Intercept value (from genomic std curve sheet):",null,null,{"$f":"'Lab-prep Std curve '!G19","v":0}]
[{"$nulls":6},"X-variable (from genomic std curve sheet):",null,null,{"$f":"'Lab-prep Std curve '!G20","v":0}]
["Diluted","Average CT:",{"$f":"AVERAGE(C4:C6)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D4:D6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C8-D8)","v":{"$error":"#DIV/0!"}}]
[null,"Standard deviation:",{"$f":"STDEV(C4:C6)","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Log sequences/rxn @ avg CT: ",null,"Diluted (1:5)",{"$f":"(C8-J6)/J7","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences/rxn @ avg CT:",null,null,{"$f":"10^J9","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences / 3000 ul extract:",null,null,{"$f":"J10*600","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences / CFU :",null,null,{"$f":"J11/$J$4","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Amplification factor (based on genomic std curve):",null,null,{"$f":"10^(1/-J7)","v":{"$error":"#DIV/0!"}}]

{"sheet":"BioBall Calibrators","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"merged":[[0,5,0,7],[3,1,5,1],[3,6,3,8],[8,8,11,8]]}
[null,"BioBall® Calibrators",{"$nulls":3},"Only populate cells highlighted in yellow."]
[null,"BioBall®",550,"CFU"]
["Calibrator ID","Calibrator ID","Entero CT","SPC CT","dCT"]
["Calib 1:","Undiluted ",null,null,{"$f":"SUM(C4-D4)","v":{"v":0,"d":"0.00"}},null,"Estimated CFU/calibrator sample (based on manufacturer's lot mean value):",{"$nulls":3},"CFU"]
["Calib 2:",{"$nulls":3},{"$f":"SUM(C5-D5)","v":{"v":0,"d":"0.00"}},null,"Crude Extract"]
["Calib 3:",{"$nulls":3},{"$f":"SUM(C6-D6)","v":{"v":0,"d":"0.00"}},null,"Intercept value (from genomic std curve sheet):",null,null,{"$f":"'Lab-prep Std curve '!G19","v":0}]
[{"$nulls":6},"X-variable (from genomic std curve sheet):",null,null,{"$f":"'Lab-prep Std curve '!G20","v":0}]
["Undiluted ","Average CT:",{"$f":"AVERAGE(C4:C6)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D4:D6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C8-D8)","v":{"$error":"#DIV/0!"}}]
[null,"Standard deviation:",{"$f":"STDEV(C4:C6)","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Log sequences/rxn @ avg CT: ",null,"Undiluted",{"$f":"(C8-J6)/J7","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences/rxn @ avg CT:",null,null,{"$f":"10^J9","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences / 600 ul extract:",null,null,{"$f":"J10*120","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Sequences / CFU :",null,null,{"$f":"J11/$J$4","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},"Amplification factor (based on genomic std curve):",null,null,{"$f":"10^(1/-J7)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Lab ddCT - Water Matrix","index":4,"n_rows":39,"n_cols":13,"rows_kept":39,"merged":[[0,0,0,9]]}
["PBS and Water Matrix Samples"]
["Only populate/modify cells highlighted in yellow."]
["Calibrator","Sample","Crude Extract"]
["ID","Dilution","Entero CT","SPC CT","dCT"]
["Calib 1","Undiluted",{"$f":"'Lab Calibrators'!C4","v":{"v":0,"d":"0.00"}},{"$f":"'Lab Calibrators'!D4","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C5-D5)","v":{"v":0,"d":"0.00"}}]
["Calib 2","Undiluted",{"$f":"'Lab Calibrators'!C5","v":{"v":0,"d":"0.00"}},{"$f":"'Lab Calibrators'!D5","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C6-D6)","v":{"v":0,"d":"0.00"}}]
["Calib 3","Undiluted",{"$f":"'Lab Calibrators'!C6","v":{"v":0,"d":"0.00"}},{"$f":"'Lab Calibrators'!D6","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C7-D7)","v":{"v":0,"d":"0.00"}}]
["Diluted 1:5","avg:",{"$f":"AVERAGE(C5:C7)","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(D5:D7)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C8-D8)","v":{"v":0,"d":"0.00"}}]
[null,"avg+3:",null,{"$f":"D8+3","v":{"v":3,"d":"3.00"}}]
[]
["Estimated CFU/calibrator (from calib sheet):",null,null,{"$f":"'Lab Calibrators'!J4","v":{"v":0,"d":"0.00"}}]
["Avg sequences/calibrator (from calib. sheet):",null,null,{"$f":"'Lab Calibrators'!J11","v":{"$error":"#DIV/0!"}}]
["Amplification Factor (from calib. sheet):",null,null,{"$f":"'Lab Calibrators'!J13","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Crude Extracts"]
["Sample","Sample","Extract",{"$nulls":4},"Ratio","Estimated Calibrator","Measured","Estimated Calibrator","Calibrator "]
["ID","Dilution","Entero  CT","SPC CT","dCT","Calib dCT","ddCT","calib/test","Sequences","Sequences (N)"," Cells (CFU)","Cell Eqivalents (CCEs)","CCEs are the final reporting units"]
["No-template","N/A",null,null,{"$f":"SUM(C20-D20)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E20-F20)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G20","v":{"$error":"#DIV/0!"}},{"$f":"$D$12","v":{"$error":"#DIV/0!"}},{"$f":"IF(C20=0,\"none detected\",H20*I20)","v":"none detected"},{"$f":"$D$11","v":{"v":0,"d":"0.00"}},{"$f":"IF(C20=0,\"none detected\",H20*K20)","v":"none detected"}]
["Unspiked PBS","1:5",null,null,{"$f":"SUM(C21-D21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E21-F21)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G21","v":{"$error":"#DIV/0!"}},{"$f":"$D$12","v":{"$error":"#DIV/0!"}},"none detected",{"$f":"$D$11","v":{"v":0,"d":"0.00"}},{"$f":"IF(C21=0,\"none detected\",H21*K21)","v":"none detected"}]
["Unspiked Water","1:5",null,null,{"$f":"SUM(C22-D22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E22-F22)","v":{"v":0,"d":"0.00"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C22=0,\"none detected\",H22*I22)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Unspiked Water","1:5",null,null,{"$f":"SUM(C23-D23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E23-F23)","v":{"v":0,"d":"0.00"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C23=0,\"none detected\",H23*I23)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["PBS - spiked","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},{"$f":"IF(C24=0,\"none detected\",H24*K24)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C26-D26)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C26=0,\"none detected\",H26*I26)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C27-D27)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C27=0,\"none detected\",H27*I27)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C28-D28)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C28=0,\"none detected\",H28*I28)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C29-D29)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C29=0,\"none detected\",H29*I29)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C32-D32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E32-F32)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(C32=0,\"none detected\",H32*I32)","v":"none detected"},{"v":0,"d":"0.00"},{"$f":"IF(C32=0,\"none detected\",H32*K32)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C33-D33)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C33=0,\"none detected\",H33*I33)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C34-D34)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C34=0,\"none detected\",H34*I34)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C35-D35)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C35=0,\"none detected\",H35*I35)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C37-D37)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E37-F37)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(C37=0,\"none detected\",H37*I37)","v":"none detected"},{"v":0,"d":"0.00"},{"$f":"IF(C37=0,\"none detected\",H37*K37)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C38-D38)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C38=0,\"none detected\",H38*I38)","v":"none detected"},{"v":0,"d":"0.00"},{"$f":"IF(C38=0,\"none detected\",H38*K38)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]

{"sheet":"BioBall ddCT-Water Matrix","index":5,"n_rows":39,"n_cols":13,"rows_kept":39,"merged":[[0,0,0,9]]}
["PBS and Water Matrix Samples"]
["Only populate/modify cells highlighted in yellow."]
["Calibrator","Sample","Crude Extract"]
["ID","Dilution","Entero CT","SPC CT","dCT"]
["Calib 1","Undiluted",{"$f":"'BioBall Calibrators'!C4","v":{"v":0,"d":"0.00"}},{"$f":"'BioBall Calibrators'!D4","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C5-D5)","v":{"v":0,"d":"0.00"}}]
["Calib 2","Undiluted",{"$f":"'BioBall Calibrators'!C5","v":{"v":0,"d":"0.00"}},{"$f":"'BioBall Calibrators'!D5","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C6-D6)","v":{"v":0,"d":"0.00"}}]
["Calib 3","Undiluted",{"$f":"'BioBall Calibrators'!C6","v":{"v":0,"d":"0.00"}},{"$f":"'BioBall Calibrators'!D6","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C7-D7)","v":{"v":0,"d":"0.00"}}]
["Undiluted","avg:",{"$f":"AVERAGE(C5:C7)","v":{"v":0,"d":"0.00"}},{"$f":"AVERAGE(D5:D7)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C8-D8)","v":{"v":0,"d":"0.00"}}]
[null,"avg+3:",null,{"$f":"D8+3","v":{"v":3,"d":"3.00"}}]
[]
["Estimated CFU/calibrator (from calib sheet):",null,null,{"$f":"'BioBall Calibrators'!J4","v":{"v":0,"d":"0.00"}}]
["Avg sequences/calibrator (from calib. sheet):",null,null,{"$f":"'BioBall Calibrators'!J11","v":{"$error":"#DIV/0!"}}]
["Amplification Factor (from calib. sheet):",null,null,{"$f":"'BioBall Calibrators'!J13","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Crude Extracts"]
["Sample","Sample","Extract",{"$nulls":4},"Ratio","Estimated Calibrator","Measured","Estimated Calibrator","Calibrator "]
["ID","Dilution","Entero  CT","SPC CT","dCT","Calib dCT","ddCT","calib/test","Sequences","Sequences (N)"," Cells (CFU)","Cell Eqivalents (CCEs)","CCEs are the final reporting units"]
["No-template","N/A",null,null,{"$f":"SUM(C20-D20)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E20-F20)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G20","v":{"$error":"#DIV/0!"}},{"$f":"$D$12","v":{"$error":"#DIV/0!"}},{"$f":"IF(C20=0,\"none detected\",H20*I20)","v":"none detected"},{"$f":"$D$11","v":{"v":0,"d":"0.00"}},{"$f":"IF(C20=0,\"none detected\",H20*K20)","v":"none detected"}]
["Unspiked PBS","1:5",null,null,{"$f":"SUM(C21-D21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"$f":"$D$11","v":{"v":0,"d":"0.00"}},{"$f":"IF(C21=0,\"none detected\",H21*K21)","v":"none detected"}]
["Unspiked Water","1:5",null,null,{"$f":"SUM(C22-D22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E22-F22)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(C22=0,\"none detected\",H22*I22)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Unspiked Water","1:5",null,null,{"$f":"SUM(C23-D23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(E23-F23)","v":{"v":0,"d":"0.00"}},{"$f":"$D$13^-G23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(C23=0,\"none detected\",H23*I23)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["PBS  - Spiked","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},{"$f":"IF(C24=0,\"none detected\",H24*K24)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(E25-F25)","v":{"v":0,"d":"0.00"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},{"$f":"IF(C25=0,\"none detected\",H25*K25)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C26-D26)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C26=0,\"none detected\",H26*I26)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C27-D27)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C27=0,\"none detected\",H27*I27)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C28-D28)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C28=0,\"none detected\",H28*I28)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C29-D29)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C29=0,\"none detected\",H29*I29)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C32-D32)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C32=0,\"none detected\",H32*I32)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C33-D33)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C33=0,\"none detected\",H33*I33)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C34-D34)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C34=0,\"none detected\",H34*I34)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C35-D35)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C35=0,\"none detected\",H35*I35)","v":"none detected"},{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"none detected",{"v":0,"d":"0.00"},"none detected"]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C37-D37)","v":{"v":0,"d":"0.00"}},{"$f":"$E$8","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C37=0,\"none detected\",H37*I37)","v":"none detected"},{"v":0,"d":"0.00"},{"$f":"IF(C37=0,\"none detected\",H37*K37)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"$f":"SUM(C38-D38)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(C38=0,\"none detected\",H38*I38)","v":"none detected"},{"v":0,"d":"0.00"},{"$f":"IF(C38=0,\"none detected\",H38*K38)","v":"none detected"}]
["Water Sample ID","1:5",null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$error":"#DIV/0!"},{"$f":"$D$12","v":{"$error":"#DIV/0!"}},"none detected",{"v":0,"d":"0.00"},"none detected"]