{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Standards_Data","Sketa22_Data","Samples_Data","Final Report"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,0,6,11],[1,0,1,10],[0,0,0,3],[0,8,0,10]]}
[null,null,null,null,null,null,null,null,"Office of Water (4303T)\nWashington, DC 20460\nMarch 2019"]
["Automated Draft EPA Methods 1696 and 1697 Data Analysis Tool"]
[]
["The following tool was designed to automate the analysis of data generated from a single instrument run using draft EPA Method 1696 and 1697.  Upon completion of data entry, the Excel macro will automatically perform all calculations for method proficiency, quality assurance and estimation of human-associated genetic marker concentration in test samples.  A summary of findings is located in the “Final Report” tab."]
[]
[]
[]
[]
[]
["Preparation of Export Data File:"]
["1. Export data spreadsheet formating will vary depending on amplifiation instrument, software version, and qPCR amplification plate well assignments."]
["Note: Refer to draft EPA Method 1696 or 1697 for recommended well assignments for best compatibility with automated data analysis tool"]
[]
[]
["Entering HF183/BacR287 or HumM2 Standard, NTC, and MB Data:"]
["1. Go to the \"Standards_Data\" tab to enter data for HF183/BacR287 or HumM2 Standard, NTC, and MB findings. "]
["2. Data only entered in Tables 1 or 2 color coded with a blue header and cells highlighted in orange. "]
["3. Cut and paste respective data from Export Data file to Table 1 for HF183/BacR287 or HumM2 Standard and NTC findings."]
["4. Cut and paste respective data from Export Data file to Table 2 for HF183/BacR287 or HumM2 MB findings."]
["5. Use drop-down menu found in the first row of the Assay column in Tables 1 and 2 to select human-associated fecal source identification qPCR method (HF183/BacR287 or HumM2)."]
[]
[]
["Entering Sketa22 MB and NTC Data:"]
["1. Go to \"Sketa22_Data\" tab to enter data for Sketa22 MB and NTC findings."]
["2. Data only entered in Tables 3 or 4 color coded with blue header and cells highlighted in orange."]
["3. Cut and paste respective data from Export Data file to Table 3 for Sketa22 MB findings."]
["4. Cut and paste respective data from Export Data file to Table 4 for Sketa22 NTC findings."]
[]
[]
["Entering Environmental Sample Data:"]
["1. Go to \"Samples_Data\" tab to enter data for HF183/BacR287 or HumM2 and Sketa22 for water sample findings."]
["2. Data only entered in Table 5 color coded with blue header and  cells highlighted in orange."]
["3. Cut and paste respective data from Export Data file to Table 5"]
["5. Use drop-down menu found in the first row of the Assay column in Table 5 to select human-associated fecal source identification qPCR method (HF183/BacR287 or HumM2)."]
[]
[]
["Reviewing Final Report:"]
["1. Go to \"Final Report\" tab to view results."]
["2. Consult draft EPA Method 1696 or 1696 Section 12.0 for a complete description of data analysis procedures."]

{"sheet":"Standards_Data","index":1,"n_rows":45,"n_cols":38,"rows_kept":45,"cut":false,"hidden":false,"merged":[[29,28,29,29],[28,30,28,31]]}
["TABLE 1:  Data Entry Table for HF183/BacR287 or HumM2 NTC and Standard Results"]
[]
["Batch","Run","Sample Type","Assay","Copy","l_Copy","FAM_Cq","VIC_Cq","NTC Pass/Fail",null,null,"Metric","Value",null,null,null,"Legend: \"Standards_Data\" Tab"]
[1,1,"NTC",null,null,null,null,null,{"$f":"IF(OR(G4=\"undetermined\",G4>M$22),1,0)","v":{"$error":"#DIV/0!"}},null,null,"NTC_VIC Mean",{"$f":"AVERAGE(H4:H9)","v":{"$error":"#DIV/0!"}},null,null,"NTC_VIC Mean","No template control VIC mean"]
[1,1,"NTC",null,null," ",null,null,{"$f":"IF(OR(G5=\"undetermined\",G5>M$22),1,0)","v":{"$error":"#DIV/0!"}},null,null,"NTC_VIC std",{"$f":"STDEV(H4:H9)","v":{"$error":"#DIV/0!"}},null,null,"NTC_VIC std","No template control VIC standard deviation"]
[1,1,"NTC",null,null," ",null,null,{"$error":"#DIV/0!"},null,null,"NTC_Criteria",{"$f":"IF(SUM(I4:I9)=6,\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},null,null,"NTC_Criteria","No template control Pass/Fail criteria"]
[1,1,"NTC",null,null," ",null,null,{"$error":"#DIV/0!"},null,null,"Slope",{"$f":"SLOPE(AF10:AF24,AE10:AE24)","v":{"$error":"#DIV/0!"}},null,null,"Slope","Calibration model slope"]
[1,1,"NTC",null,null," ",null,null,{"$error":"#DIV/0!"},null,null,"Slope_std",{"$f":"SQRT((SUMSQ(AG10:AG24)/(COUNT(AG10:AG24)-2))/DEVSQ(AE10:AE24))","v":{"$error":"#DIV/0!"}},null,null,"Slope_std","Calibration model slope standard deviation",null,null,null,null,null,null,"Outlier Calculations",null,null,null,null,null,null,"Calibration Model Calculations"]
[1,1,"NTC",null,null," ",null,null,{"$error":"#DIV/0!"},null,null,"Slope_95% LB",{"$f":"M7- TINV(0.05,COUNT(AG10:AG24)-2)*M8","v":{"$error":"#DIV/0!"}},null,null,"Slope_95% LB","Calibration model 95% Prediction limit lower bound",null,null,null,null,null,null,"1- h_ii","res","rss_i","sigma_i","r_student","outlier",null,"l_copy","FAM_Cq","res","IAC ROQ Pass/Fail","sum","Cat_i","min(<=1)","max(>1)"]
[1,1,"Standard",null,10,{"$f":"LOG10(E10)","v":1},null,null,null,null,null,"Slope_95% UB",{"$f":"M7 + TINV(0.05,COUNT(AG10:AG24)-2)*M8","v":{"$error":"#DIV/0!"}},null,null,"Slope_95% UB","Calibration model 95% Prediction limit upper bound",null,null,null,null,null,null,{"$f":" IF(G10=\"undetermined\",\" \",1- ( (1/COUNT(F$10:F$24)) + ((F10-AVERAGE(F$10:F$24))^2/DEVSQ(F$10:F$24))))","v":0.8},{"$f":"IF(X10=\" \",\" \",G10-(INTERCEPT(G$10:G$24,F$10:F$24) + SLOPE(G$10:G$24,F$10:F$24)*F10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(Y10=\" \",\" \",DEVSQ(Y$10:Y$24) -(Y10^2/X10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(Z10=\" \",\" \",SQRT(Z10/(COUNT(G$10:G$24)-3)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AA10=\" \", \" \",Y10/(AA10*SQRT(X10)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AB10=\" \",\" \",IF(ABS(AB10)>3,\"Yes\",\"No\"))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AC10=\"No\",F10,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AC10=\"No\",G10,\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AF10=\" \",\" \",AF10-(INTERCEPT(AF$10:AF$24,AE$10:AE$24) + SLOPE(AF$10:AF$24,AE$10:AE$24)*AE10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(H10<(M$4-3*M$5),H10>(M$4+3*M$5),H10=\"undetermined\"),0,1)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AH10:AH12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H10<$M$18,\"pass\",IF(OR(AF10>$M$17,AF10=40),\"fail\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI10<=1,1,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI10>1,1,\"\")","v":{"$error":"#DIV/0!"}}]
[1,1,"Standard",null,10,1,null,null,null,null,null,"Intercept",{"$f":"INTERCEPT(AF10:AF24,AE10:AE24)","v":{"$error":"#DIV/0!"}},null,null,"Intercept","Calibration model intercept",null,null,null,null,null,null,0.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(AB11=\" \",\" \",IF(ABS(AB11)>3,\"Yes\",\"No\"))","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,10,1,null,null,null,null,null,"Int_std",{"$f":"SQRT((SUMSQ(AG10:AG24)/(COUNT(AG10:AG24)-2))*((1/COUNT(AG10:AG24))+(AVERAGE(AE10:AE24)^2/DEVSQ(AE10:AE24))))","v":{"$error":"#DIV/0!"}},null,null,"Int_std","Calibration model intercept standard deviation",null,null,null,null,null,null,0.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(AB12=\" \",\" \",IF(ABS(AB12)>3,\"Yes\",\"No\"))","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,100,2,null,null,null,null,null,"Int_95% LB",{"$f":"M11- TINV(0.05,COUNT(AG10:AG24)-2)*M12","v":{"$error":"#DIV/0!"}},null,null,"Int_95% LB","Calibration model intercept 95% Prediction limit lower bound",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(AH13:AH15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(AI13<=1,2,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI13>1,2,\"\")","v":{"$error":"#DIV/0!"}}]
[1,1,"Standard",null,100,2,null,null,null,null,null,"Int_95% UB",{"$f":"M11 + TINV(0.05,COUNT(AG10:AG24)-2)*M12","v":{"$error":"#DIV/0!"}},null,null,"Int_95% UB","Calibration model 95% prediction limit upper bound",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,100,2,null,null,null,null,null,"R2",{"$f":"1-(SUMSQ(AG10:AG24)/DEVSQ(AF10:AF24))","v":{"$error":"#DIV/0!"}},null,null,"R2","Calibration model correliation coeficient",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,1000,3,null,null,null,null,null,"max",{"$f":"IF(AND((MIN(AK10:AK24)<MAX(AL10:AL24)),(MIN(AK10:AK24)>0)),MIN(AK10:AK24)-1,MAX(AL10:AL24))","v":{"$error":"#DIV/0!"}},null,null,"IAC_Comp_Thr","Internal amplification control competition threshold",null,null,null,null,null,null,0.93333333333333335,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(AH16:AH18)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(AI16<=1,3,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI16>1,3,\"\")","v":{"$error":"#DIV/0!"}}]
[1,1,"Standard",null,1000,3,null,null,null,null,null,"IAC_Comp_Thr",{"$f":"M7*M16+M11","v":{"$error":"#DIV/0!"}},null,null,"IAC_Int_Thr","Internal amplification control interference threshold",null,null,null,null,null,null,0.93333333333333335,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,1000,3,null,null,null,null,null,"IAC_Int_Thr",{"$f":"M4 + 3*M5","v":{"$error":"#DIV/0!"}},null,null,"E","Amplification efficiency",null,null,null,null,null,null,0.93333333333333335,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,10000,4,null,null,null,null,null,"E",{"$f":"(10^(-1/M7))-1","v":{"$error":"#DIV/0!"}},null,null,"E_Criteria","Amplification efficiency Pass/Fail criteria",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(AH19:AH21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(AI19<=1,4,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI19>1,4,\"\")","v":{"$error":"#DIV/0!"}}]
[1,1,"Standard",null,10000,4,null,null,null,null,null,"E_Criteria",{"$f":"IF(OR((10^(-1/M7))-1>=1.1, (10^(-1/M7))-1 <= 0.9),\"fail\",\"pass\")","v":{"$error":"#DIV/0!"}},null,null,"R2_Criteria","Calibration model correlation coefficient Pass/Fail criteria",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,10000,4,null,null,null,null,null,"R2_Criteria",{"$f":"IF(M15 < 0.98,\"fail\",\"pass\")","v":{"$error":"#DIV/0!"}},null,null,"LLOQ","Calibration model lower limit of quantification",null,null,null,null,null,null,0.9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,100000,5,null,null,null,null,null,"LLOQ",{"$f":"M11+M7+TINV(0.05,COUNT(AG10:AG24)-2)*SQRT((SUMSQ(AG10:AG24)/(COUNT(AG10:AG24)-2))*(1+(1/COUNT(AE10:AE24))+((1-AVERAGE(AE10:AE24))^2/DEVSQ(AE10:AE24))))","v":{"$error":"#DIV/0!"}},null,null,"IAC Prof_Bound","Internal amplification proficiency bound",null,null,null,null,null,null,0.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(AH22:AH24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(AI22<=1,5,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI22>1,5,\"\")","v":{"$error":"#DIV/0!"}}]
[1,1,"Standard",null,100000,5,null,null,null,null,null,"IAC Prof_Bound",{"$f":"IF(D4=\"HF183\",1.16,IF(D4=\"HumM2\",1.05,0))","v":0},null,null,"# of Outliers","Calibration model number of outliers removed",null,null,null,null,null,null,0.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[1,1,"Standard",null,100000,5,null,null,null,null,null,"# of Outliers",{"$f":"IF(AC10=\"Yes\",1,0) + IF(AC11=\"Yes\",1,0)  +IF(AC12=\"Yes\",1,0) +IF(AC13=\"Yes\",1,0) +IF(AC14=\"Yes\",1,0) +IF(AC15=\"Yes\",1,0) +IF(AC16=\"Yes\",1,0) +IF(AC17=\"Yes\",1,0) +IF(AC18=\"Yes\",1,0) +IF(AC19=\"Yes\",1,0) +IF(AC20=\"Yes\",1,0) +IF(AC21=\"Yes\",1,0) +IF(AC22=\"Yes\",1,0) +IF(AC23=\"Yes\",1,0) +IF(AC24=\"Yes\",1,0)","v":{"$error":"#DIV/0!"}},null,null,"IAC ROQ Pass/Fail","Internal amplification range of quantification Pass/Fail",null,null,null,null,null,null,0.8,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,"D/ND cutoff",{"$f":"MIN(MIN(G4:G9),MIN(F30:F35))","v":0},null,null,"Assay","qPCR assay name"]
[]
["TABLE 2:  Data Entry Table for HF183/BacR287 or HumM2 MB Results"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch","Batch number"]
["Batch ","Run","Sample Type","Assay","Filter","FAM_Cq","MB Pass/Fail","MB_Criteria",null,null,null,null,null,null,null,"Run","Instrument run number",null,null,null,null,null,null,null,null,"95% Prediction Limit Calculations"]
[1,1,"MB",null,1,null,{"$f":"IF(OR(F30=\"undetermined\",F30>M$22),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(SUM(G30:G38)=9,\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Copy","Calibration curve DNA standard number of copies in reaction",null,null,null,null,null,null,null,null,null,"DNA Standard Cq values","Fitted Model","95% Prediction Limits"]
[1,1,"MB",null,1,null,{"$f":"IF(OR(F31=\"undetermined\",F31>M$22),1,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"l_copy","Calibration curve DNA standard log10 copies per reaction",null,null,null,null,null,null,null,null,{"$f":"LOG10(E10)","v":1},{"$f":"AF10","v":{"$error":"#DIV/0!"}},{"$f":"$M$11+$M$7*Z31","v":{"$error":"#DIV/0!"}},{"$f":"AB31 -TINV(0.05, COUNT(AF$10:AF$24)-2)*SQRT(SUMSQ(AG$10:AG$24)/(COUNT(AF$10:AF$24)-2))*SQRT((1+ (1/COUNT(AE$10:AE$24)) + (Z31-AVERAGE(AE$10:AE$24))^2/DEVSQ(AE$10:AE$24)))","v":{"$error":"#DIV/0!"}},{"$f":"AB31 + TINV(0.05, COUNT(AF$10:AF$24)-2)*SQRT(SUMSQ(AG$10:AG$24)/(COUNT(AF$10:AF$24)-2))*SQRT((1+ (1/COUNT(AE$10:AE$24)) + (Z31-AVERAGE(AE$10:AE$24))^2/DEVSQ(AE$10:AE$24)))","v":{"$error":"#DIV/0!"}}]
[1,1,"MB",null,1,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"FAM_Cq","FAM quantification cycle",null,null,null,null,null,null,null,null,1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,2,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"VIC_Cq","Internal amplifcation control VIC quantification cycle",null,null,null,null,null,null,null,null,1,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,2,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"NTC Pass/Fail","No template control (Pass = 1 and Fail = 2)",null,null,null,null,null,null,null,null,2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,2,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"MB Pass/Fail","Method extraction blank (Pass = 1 and Fail = 2)",null,null,null,null,null,null,null,null,2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,3,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"MB_Criteria","Method extraction blank Pass/Fail criteria",null,null,null,null,null,null,null,null,2,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,3,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,1,"MB",null,3,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HF183",null,null,null,null,null,null,null,null,null,4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HumM2",null,null,null,null,null,null,null,null,null,4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Sketa22_Data","index":2,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["TABLE 3:  Data Entry Table for Sketa22 MB Results"]
[]
["Batch","Run","Sample Type","Filter No.","Assay","FAM_Cq"]
[1,1,"MB",1,"Sketa22",null,null,"Sketa22 Cq","SS","df","MSS","var.comp",null,"Mean Cq:",{"$f":"AVERAGE(F4:F12)","v":{"$error":"#DIV/0!"}}]
[1,1,"MB",1,"Sketa22",null,null,"Total",{"$f":"IF(COUNTBLANK(F4:F12) =9,0,DEVSQ(F4:F12))","v":0},{"$f":"COUNT(F4:F12)-1","v":-1},{"$f":"I5/J5","v":0},{"$f":"IF((L7 <0),0,L7) +    IF( (L6 <0),0,L6)","v":{"$error":"#DIV/0!"}},null,"Standard Deviation:",{"$f":"SQRT(L5)","v":{"$error":"#DIV/0!"}}]
[1,1,"MB",1,"Sketa22",null,null,"Filter",{"$f":"I5-(I7)","v":0},{"$f":"J5 - J7","v":-1},{"$f":"I6/J6","v":0},{"$f":"(K6-K7)/(((COUNT(F4:F6)+COUNT(F7:F9)+COUNT(F10:F12))-(COUNT(F4:F6)^2+COUNT(F7:F9)^2+COUNT(F10:F12)^2)/(COUNT(F4:F6)+COUNT(F7:F9)+COUNT(F10:F12)))/((IF(COUNTBLANK(F4:F6)=3,0,1))+(IF(COUNTBLANK(F7:F9)=3,0,1))+(IF(COUNTBLANK(F10:F12)=3,0,1))-1))","v":{"$error":"#DIV/0!"}},null,"SPC Proficiency",{"$f":"IF(O$5 <=0.62,\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}}]
[1,1,"MB",2,"Sketa22",null,null,"Residual",{"$f":"IF(COUNTBLANK(F4:F6)=3,0,DEVSQ(F4:F6))+IF(COUNTBLANK(F7:F9)=3,0,DEVSQ(F7:F9))+IF(COUNTBLANK(F10:F12)=3,0,DEVSQ(F10:F12))","v":0},{"$f":"IF(COUNTBLANK(F4:F6)=3,0,COUNT(F4:F6)-1)+IF(COUNTBLANK(F7:F9)=3,0,COUNT(F7:F9)-1)+IF(COUNTBLANK(F10:F12)=3,0,COUNT(F10:F12)-1)","v":0},{"$f":"I7/J7","v":{"$error":"#DIV/0!"}},{"$f":"K7","v":{"$error":"#DIV/0!"}}]
[1,1,"MB",2,"Sketa22"]
[1,1,"MB",2,"Sketa22"]
[1,1,"MB",3,"Sketa22"]
[1,1,"MB",3,"Sketa22"]
[1,1,"MB",3,"Sketa22"]
[]
[]
["TABLE 4:  Data Entry Table for Sketa22 NTC Results",null,null,null,null,null,null,null,null,null,"Legend: \"Sketa22_Data\" Tab"]
[null,null,null,null,null,null,null,null,null,"Batch","Batch number"]
["Batch ","Run","Sample Type","Assay","FAM_Cq","NTC Pass/Fail","NTC_Criteria",null,null,"Run","Instrument run number"]
[1,1,"NTC","Sketa22",null,{"$f":"IF(OR(E18>=35,E18=\"undermined\"),1,0)","v":0},{"$f":"IF(SUM(F18:F23)=6,\"pass\",\"fail\")","v":"fail"},null,null,"Sample Type","Sample type (MB = method blank or NTC = no template control)"]
[1,1,"NTC","Sketa22",null,{"$f":"IF(OR(E19>=35,E19=\"undermined\"),1,0)","v":0},null,null,null,"Filter No.","Filter number"]
[1,1,"NTC","Sketa22",null,0,null,null,null,"FAM_Cq","FAM quantification cycle"]
[1,1,"NTC","Sketa22",null,0,null,null,null,"NTC Pass/Fail","No template control Pass/Fail (1 = pass and 2 = fail)"]
[1,1,"NTC","Sketa22",null,0,null,null,null,"NTC_Criteria","No template control Pass/Fail"]
[1,1,"NTC","Sketa22",null,0,null,null,null,"Mean Cq","Sketa22 MB mean quantification cycle"]
[null,null,null,null,null,null,null,null,null,"SPC Proficiency","Sample processing control proficiency Pass/Fail"]
[null,null,null,null,null,null,null,null,null,"MB","Method blank"]
[null,null,null,null,null,null,null,null,null,"NTC","No template control"]

{"sheet":"Samples_Data","index":3,"n_rows":93,"n_cols":40,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["TABLE 5:  Data Entry Table for Environmental Sample Results"]
[]
["Batch","Run","Assay","Sample No.","Sample ID","Filter Rep.","Test Filter No.","FAM_Cq","VIC_Cq","Sketa22_Cq","IAC_Category","IAC_Count","IAC_Criteria","D/ND","LLOQ_Criteria","m_Sketa22_Cq","Sketa22 SPC_Accpt","Sketa22 SPC_Adj","Delta","SPC Test Pass/Fail","SPC Proficiency","All Criteria","Final_FAM_Cq","m_Cq","l_copy","Standard Deviation","n"]
[1,1,null,1,null,1,1,null,null,null,{"$f":"IF(I4<Standards_Data!M$18,\"pass\",IF(OR(H4>Standards_Data!M$17,H4=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(K4=\"pass\",K4=\"comp\"),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(COUNT(L4:L6)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L4:L6) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H4=\"undetermined\",0,IF(H4>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H4=\"undetermined\",\"ND\",IF(H4>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J4:J6)=0,\" \",AVERAGE(J4:J6))","v":" "},{"$f":"IF(P4=\" \",\" \",IF(P4> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P4=\" \",\" \",IF(P4> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),P4-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q4=\"pass\",T4=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L4=1,M4=\"pass\",O4=\"pass\",U4=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(V4=\"fail\",\"\",IF(T4=\"pass\",H4-S4,H4))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(W4:W12)=0,  \" \",AVERAGE(W4:W12))","v":" "},{"$f":"IF( X4=\" \", \" \",(X4-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y4=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ5^2+ (-2*(X4-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X4-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W4:W12)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W4:W12)","v":{"$error":"#DIV/0!"}},null,null,null,"Legend: \"Samples_Data\" Tab"]
[1,1,null,1,null,1,1,null,null,null,{"$f":"IF(I5<Standards_Data!M$18,\"pass\",IF(OR(H5>Standards_Data!M$17,H5=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(K5=\"pass\",K5=\"comp\"),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(COUNT(L4:L6)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L4:L6) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H5=\"undetermined\",0,IF(H5>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H5=\"undetermined\",\"ND\",IF(H5>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),P4-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q4=\"pass\",T4=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L5=1,M5=\"pass\",O5=\"pass\",U5=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W4:W12) =9,0,DEVSQ(W4:W12))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W4:W12)-1","v":-1},{"$f":"AD5/AE5","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG7 <0),0,AG7) +    IF( (AG6 <0),0,AG6)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W4:W12) <=3,0,   IF(AG6 >0,SQRT((AG7/(AE5+1))+(AG6*(COUNT(W4:W6)^2+COUNT(W7:W9)^2+COUNT(W10:W12)^2)/(AE5+1)^2)), STDEV(W4:W12)/SQRT(COUNT(W4:W12)  ) ))","v":0},null,null,"Batch","Batch number"]
[1,1,null,1,null,1,1,null,null,null,{"$f":"IF(I6<Standards_Data!M$18,\"pass\",IF(OR(H6>Standards_Data!M$17,H6=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L4:L6)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L4:L6) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H6=\"undetermined\",0,IF(H6>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H6=\"undetermined\",\"ND\",IF(H6>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),P4-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P4>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P4<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q4=\"pass\",T4=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L6=1,M6=\"pass\",O6=\"pass\",U6=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD5-(AD7)","v":{"$error":"#DIV/0!"}},{"$f":"AE5 - AE7","v":2},{"$f":"AD6/AE6","v":{"$error":"#DIV/0!"}},{"$f":"(AF6-AF7)/(((COUNT(  W4:W6)+COUNT(  W7:W9)+COUNT(  W10:W12))-(COUNT(  W4:W6)^2+COUNT(  W7:W9)^2+COUNT(  W10:W12)^2)/(COUNT(  W4:W6)+COUNT(  W7:W9)+COUNT(  W10:W12)))/((IF(COUNTBLANK(  W4:W6)=3,0,1))+(IF(COUNTBLANK(  W7:W9)=3,0,1))+(IF(COUNTBLANK(  W10:W12)=3,0,1))-1))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Run","Instrument run number"]
[1,1,null,1,null,2,2,null,null,null,{"$f":"IF(I7<Standards_Data!M$18,\"pass\",IF(OR(H7>Standards_Data!M$17,H7=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L7:L9)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L7:L9) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H7=\"undetermined\",0,IF(H7>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H7=\"undetermined\",\"ND\",IF(H7>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J7:J9)=0,\" \",AVERAGE(J7:J9))","v":" "},{"$f":"IF(P7=\" \",\" \",IF(P7> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P7=\" \",\" \",IF(P7> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),P7-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q7=\"pass\",T7=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L7=1,M7=\"pass\",O7=\"pass\",U7=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W4:W6)=3,0,DEVSQ(  W4:W6))+IF(COUNTBLANK(  W7:W9)=3,0,DEVSQ(  W7:W9))+IF(COUNTBLANK(  W10:W12)=3,0,DEVSQ(  W10:W12))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W4:W6)=3,0,COUNT(  W4:W6)-1)+IF(COUNTBLANK(  W7:W9)=3,0,COUNT(  W7:W9)-1)+IF(COUNTBLANK(  W10:W12)=3,0,COUNT(  W10:W12)-1)","v":-3},{"$f":"AD7/AE7","v":{"$error":"#DIV/0!"}},{"$f":"AF7","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Assay","qPCR assay name (HF183 or HumM2)"]
[1,1,null,1,null,2,2,null,null,null,{"$f":"IF(I8<Standards_Data!M$18,\"pass\",IF(OR(H8>Standards_Data!M$17,H8=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L7:L9)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L7:L9) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H8=\"undetermined\",0,IF(H8>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H8=\"undetermined\",\"ND\",IF(H8>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),P7-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q7=\"pass\",T7=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L8=1,M8=\"pass\",O8=\"pass\",U8=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample ID","Sample identification"]
[1,1,null,1,null,2,2,null,null,null,{"$f":"IF(I9<Standards_Data!M$18,\"pass\",IF(OR(H9>Standards_Data!M$17,H9=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L7:L9)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L7:L9) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H9=\"undetermined\",0,IF(H9>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H9=\"undetermined\",\"ND\",IF(H9>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),P7-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P7>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P7<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q7=\"pass\",T7=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L9=1,M9=\"pass\",O9=\"pass\",U9=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter No.","Filter number"]
[1,1,null,1,null,3,3,null,null,null,{"$f":"IF(I10<Standards_Data!M$18,\"pass\",IF(OR(H10>Standards_Data!M$17,H10=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L10:L12)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L10:L12) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H10=\"undetermined\",0,IF(H10>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H10=\"undetermined\",\"ND\",IF(H10>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J10:J12)=0,\" \",AVERAGE(J10:J12))","v":" "},{"$f":"IF(P10=\" \",\" \",IF(P10> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P10=\" \",\" \",IF(P10> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),P10-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q10=\"pass\",T10=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L10=1,M10=\"pass\",O10=\"pass\",U10=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIC_Cq","Internal amplification control VIC quantification cycle"]
[1,1,null,1,null,3,3,null,null,null,{"$f":"IF(I11<Standards_Data!M$18,\"pass\",IF(OR(H11>Standards_Data!M$17,H11=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L10:L12)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L10:L12) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H11=\"undetermined\",0,IF(H11>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H11=\"undetermined\",\"ND\",IF(H11>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),P10-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q10=\"pass\",T10=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L11=1,M11=\"pass\",O11=\"pass\",U11=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAM_Cq","HF183 or HumM2 FAM quantification cycle"]
[1,1,null,1,null,3,3,null,null,null,{"$f":"IF(I12<Standards_Data!M$18,\"pass\",IF(OR(H12>Standards_Data!M$17,H12=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L10:L12)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L10:L12) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H12=\"undetermined\",0,IF(H12>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H12=\"undetermined\",\"ND\",IF(H12>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),P10-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P10>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P10<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q10=\"pass\",T10=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L12=1,M12=\"pass\",O12=\"pass\",U12=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sketa22_Cq","Sketa22 quantification cycle"]
[1,1,null,2,null,1,4,null,null,null,{"$f":"IF(I13<Standards_Data!M$18,\"pass\",IF(OR(H13>Standards_Data!M$17,H13=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L13:L15)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L13:L15) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H13=\"undetermined\",0,IF(H13>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H13=\"undetermined\",\"ND\",IF(H13>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J13:J15)=0,\" \",AVERAGE(J13:J15))","v":" "},{"$f":"IF(P13=\" \",\" \",IF(P13> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P13=\" \",\" \",IF(P13> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),P13-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q13=\"pass\",T13=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L13=1,M13=\"pass\",O13=\"pass\",U13=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W13:W21)=0,  \" \",AVERAGE(W13:W21))","v":" "},{"$f":"IF( X13=\" \", \" \",(X13-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y13=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ14^2+ (-2*(X13-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X13-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W13:W21)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W13:W21)","v":{"$error":"#DIV/0!"}},null,null,"IAC_Category","Internal amplification control category (Pass = pass; Inhibition = inhb; competition = comp)"]
[1,1,null,2,null,1,4,null,null,null,{"$f":"IF(I14<Standards_Data!M$18,\"pass\",IF(OR(H14>Standards_Data!M$17,H14=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L13:L15)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L13:L15) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H14=\"undetermined\",0,IF(H14>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H14=\"undetermined\",\"ND\",IF(H14>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),P13-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q13=\"pass\",T13=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L14=1,M14=\"pass\",O14=\"pass\",U14=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W13:W21) =9,0,DEVSQ(W13:W21))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W13:W21)-1","v":-1},{"$f":"AD14/AE14","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG16 <0),0,AG16) +    IF( (AG15 <0),0,AG15)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W13:W21) <=3,0,   IF(AG15 >0,SQRT((AG16/(AE14+1))+(AG15*(COUNT(W13:W15)^2+COUNT(W16:W18)^2+COUNT(W19:W21)^2)/(AE14+1)^2)), STDEV(W13:W21)/SQRT(COUNT(W13:W21)  ) ))","v":0},null,null,"IAC_Count","Internal amplification control count (Pass or Comp = 1)"]
[1,1,null,2,null,1,4,null,null,null,{"$f":"IF(I15<Standards_Data!M$18,\"pass\",IF(OR(H15>Standards_Data!M$17,H15=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L13:L15)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L13:L15) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H15=\"undetermined\",0,IF(H15>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H15=\"undetermined\",\"ND\",IF(H15>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),P13-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P13>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P13<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q13=\"pass\",T13=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L15=1,M15=\"pass\",O15=\"pass\",U15=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD14-(AD16)","v":{"$error":"#DIV/0!"}},{"$f":"AE14 - AE16","v":2},{"$f":"AD15/AE15","v":{"$error":"#DIV/0!"}},{"$f":"(AF15-AF16)/(((COUNT(  W13:W15)+COUNT(  W16:W18)+COUNT(  W19:W21))-(COUNT(  W13:W15)^2+COUNT(  W16:W18)^2+COUNT(  W19:W21)^2)/(COUNT(  W13:W15)+COUNT(  W16:W18)+COUNT(  W19:W21)))/((IF(COUNTBLANK(  W13:W15)=3,0,1))+(IF(COUNTBLANK(  W16:W18)=3,0,1))+(IF(COUNTBLANK(  W19:W21)=3,0,1))-1))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"IAC_Criteria","Internal amplification control Pass/Fail criteria"]
[1,1,null,2,null,2,5,null,null,null,{"$f":"IF(I16<Standards_Data!M$18,\"pass\",IF(OR(H16>Standards_Data!M$17,H16=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L16:L18)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L16:L18) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H16=\"undetermined\",0,IF(H16>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H16=\"undetermined\",\"ND\",IF(H16>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J16:J18)=0,\" \",AVERAGE(J16:J18))","v":" "},{"$f":"IF(P16=\" \",\" \",IF(P16> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P16=\" \",\" \",IF(P16> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),P16-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q16=\"pass\",T16=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L16=1,M16=\"pass\",O16=\"pass\",U16=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W13:W15)=3,0,DEVSQ(  W13:W15))+IF(COUNTBLANK(  W16:W18)=3,0,DEVSQ(  W16:W18))+IF(COUNTBLANK(  W19:W21)=3,0,DEVSQ(  W19:W21))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W13:W15)=3,0,COUNT(  W13:W15)-1)+IF(COUNTBLANK(  W16:W18)=3,0,COUNT(  W16:W18)-1)+IF(COUNTBLANK(  W19:W21)=3,0,COUNT(  W19:W21)-1)","v":-3},{"$f":"AD16/AE16","v":{"$error":"#DIV/0!"}},{"$f":"AF16","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"LLOQ_Criteria","Lower limit of quantification Pass/Fail criteria"]
[1,1,null,2,null,2,5,null,null,null,{"$f":"IF(I17<Standards_Data!M$18,\"pass\",IF(OR(H17>Standards_Data!M$17,H17=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L16:L18)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L16:L18) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H17=\"undetermined\",0,IF(H17>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H17=\"undetermined\",\"ND\",IF(H17>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),P16-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q16=\"pass\",T16=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L17=1,M17=\"pass\",O17=\"pass\",U17=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m_Sketa22_Cq","mean Sketa22 qPCR FAM quantification cycle"]
[1,1,null,2,null,2,5,null,null,null,{"$f":"IF(I18<Standards_Data!M$18,\"pass\",IF(OR(H18>Standards_Data!M$17,H18=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L16:L18)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L16:L18) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H18=\"undetermined\",0,IF(H18>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H18=\"undetermined\",\"ND\",IF(H18>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),P16-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P16>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P16<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q16=\"pass\",T16=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L18=1,M18=\"pass\",O18=\"pass\",U18=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sketa22 SPC_Accpt","Sketa22 sample processing control acceptance threshold"]
[1,1,null,2,null,3,6,null,null,null,{"$f":"IF(I19<Standards_Data!M$18,\"pass\",IF(OR(H19>Standards_Data!M$17,H19=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L19:L21)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L19:L21) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H19=\"undetermined\",0,IF(H19>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H19=\"undetermined\",\"ND\",IF(H19>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J19:J21)=0,\" \",AVERAGE(J19:J21))","v":" "},{"$f":"IF(P19=\" \",\" \",IF(P19> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P19=\" \",\" \",IF(P19> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),P19-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q19=\"pass\",T19=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L19=1,M19=\"pass\",O19=\"pass\",U19=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sketa22 SPC_Adj","Sketa22 sample processing control adjustment threshold"]
[1,1,null,2,null,3,6,null,null,null,{"$f":"IF(I20<Standards_Data!M$18,\"pass\",IF(OR(H20>Standards_Data!M$17,H20=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L19:L21)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L19:L21) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H20=\"undetermined\",0,IF(H20>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H20=\"undetermined\",\"ND\",IF(H20>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),P19-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q19=\"pass\",T19=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L20=1,M20=\"pass\",O20=\"pass\",U20=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC Test Pass/Fail","Sample processing conrol Pass/Fail"]
[1,1,null,2,null,3,6,null,null,null,{"$f":"IF(I21<Standards_Data!M$18,\"pass\",IF(OR(H21>Standards_Data!M$17,H21=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L19:L21)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L19:L21) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H21=\"undetermined\",0,IF(H21>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H21=\"undetermined\",\"ND\",IF(H21>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),P19-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P19>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P19<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q19=\"pass\",T19=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L21=1,M21=\"pass\",O21=\"pass\",U21=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC Proficiency","Sample processing control proficiency Pass/Fail"]
[1,1,null,3,null,1,7,null,null,null,{"$f":"IF(I22<Standards_Data!M$18,\"pass\",IF(OR(H22>Standards_Data!M$17,H22=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L22:L24)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L22:L24) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H22=\"undetermined\",0,IF(H22>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H22=\"undetermined\",\"ND\",IF(H22>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J22:J24)=0,\" \",AVERAGE(J22:J24))","v":" "},{"$f":"IF(P22=\" \",\" \",IF(P22> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P22=\" \",\" \",IF(P22> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),P22-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q22=\"pass\",T22=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L22=1,M22=\"pass\",O22=\"pass\",U22=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W22:W30)=0,  \" \",AVERAGE(W22:W30))","v":" "},{"$f":"IF( X22=\" \", \" \",(X22-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y22=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ23^2+ (-2*(X22-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X22-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W22:W30)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W22:W30)","v":{"$error":"#DIV/0!"}},null,null,"Final_FAM_Cq","Final FAM quantification cycle used to make concentration estimate"]
[1,1,null,3,null,1,7,null,null,null,{"$f":"IF(I23<Standards_Data!M$18,\"pass\",IF(OR(H23>Standards_Data!M$17,H23=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L22:L24)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L22:L24) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H23=\"undetermined\",0,IF(H23>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H23=\"undetermined\",\"ND\",IF(H23>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),P22-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q22=\"pass\",T22=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L23=1,M23=\"pass\",O23=\"pass\",U23=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W22:W30) =9,0,DEVSQ(W22:W30))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W22:W30)-1","v":-1},{"$f":"AD23/AE23","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG25 <0),0,AG25) +    IF( (AG24 <0),0,AG24)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W22:W30) <=3,0,   IF(AG24 >0,SQRT((AG25/(AE23+1))+(AG24*(COUNT(W22:W24)^2+COUNT(W25:W27)^2+COUNT(W28:W30)^2)/(AE23+1)^2)), STDEV(W22:W30)/SQRT(COUNT(W22:W30)  ) ))","v":0},null,null,"std.error","Standard error in adjusted FAM quantifiation cycle"]
[1,1,null,3,null,1,7,null,null,null,{"$f":"IF(I24<Standards_Data!M$18,\"pass\",IF(OR(H24>Standards_Data!M$17,H24=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L22:L24)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L22:L24) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H24=\"undetermined\",0,IF(H24>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H24=\"undetermined\",\"ND\",IF(H24>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),P22-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P22>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P22<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q22=\"pass\",T22=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L24=1,M24=\"pass\",O24=\"pass\",U24=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD23-(AD25)","v":{"$error":"#DIV/0!"}},{"$f":"AE23 - AE25","v":2},{"$f":"AD24/AE24","v":{"$error":"#DIV/0!"}},{"$f":"(AF24-AF25)/(((COUNT(  W22:W24)+COUNT(  W25:W27)+COUNT(  W28:W30))-(COUNT(  W22:W24)^2+COUNT(  W25:W27)^2+COUNT(  W28:W30)^2)/(COUNT(  W22:W24)+COUNT(  W25:W27)+COUNT(  W28:W30)))/((IF(COUNTBLANK(  W22:W24)=3,0,1))+(IF(COUNTBLANK(  W25:W27)=3,0,1))+(IF(COUNTBLANK(  W28:W30)=3,0,1))-1))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"m_Cq","Mean quantification cycle"]
[1,1,null,3,null,2,8,null,null,null,{"$f":"IF(I25<Standards_Data!M$18,\"pass\",IF(OR(H25>Standards_Data!M$17,H25=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L25:L27)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L25:L27) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H25=\"undetermined\",0,IF(H25>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H25=\"undetermined\",\"ND\",IF(H25>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J25:J27)=0,\" \",AVERAGE(J25:J27))","v":" "},{"$f":"IF(P25=\" \",\" \",IF(P25> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P25=\" \",\" \",IF(P25> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),P25-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q25=\"pass\",T25=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L25=1,M25=\"pass\",O25=\"pass\",U25=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W22:W24)=3,0,DEVSQ(  W22:W24))+IF(COUNTBLANK(  W25:W27)=3,0,DEVSQ(  W25:W27))+IF(COUNTBLANK(  W28:W30)=3,0,DEVSQ(  W28:W30))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W22:W24)=3,0,COUNT(  W22:W24)-1)+IF(COUNTBLANK(  W25:W27)=3,0,COUNT(  W25:W27)-1)+IF(COUNTBLANK(  W28:W30)=3,0,COUNT(  W28:W30)-1)","v":-3},{"$f":"AD25/AE25","v":{"$error":"#DIV/0!"}},{"$f":"AF25","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"l_copy","Estimated log10 copies per reaction"]
[1,1,null,3,null,2,8,null,null,null,{"$f":"IF(I26<Standards_Data!M$18,\"pass\",IF(OR(H26>Standards_Data!M$17,H26=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L25:L27)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L25:L27) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H26=\"undetermined\",0,IF(H26>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H26=\"undetermined\",\"ND\",IF(H26>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),P25-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q25=\"pass\",T25=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L26=1,M26=\"pass\",O26=\"pass\",U26=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,3,null,2,8,null,null,null,{"$f":"IF(I27<Standards_Data!M$18,\"pass\",IF(OR(H27>Standards_Data!M$17,H27=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L25:L27)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L25:L27) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H27=\"undetermined\",0,IF(H27>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H27=\"undetermined\",\"ND\",IF(H27>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),P25-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P25>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P25<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q25=\"pass\",T25=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L27=1,M27=\"pass\",O27=\"pass\",U27=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,3,null,3,9,null,null,null,{"$f":"IF(I28<Standards_Data!M$18,\"pass\",IF(OR(H28>Standards_Data!M$17,H28=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L28:L30)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L28:L30) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H28=\"undetermined\",0,IF(H28>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H28=\"undetermined\",\"ND\",IF(H28>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J28:J30)=0,\" \",AVERAGE(J28:J30))","v":" "},{"$f":"IF(P28=\" \",\" \",IF(P28> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P28=\" \",\" \",IF(P28> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),P28-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q28=\"pass\",T28=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L28=1,M28=\"pass\",O28=\"pass\",U28=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,3,null,3,9,null,null,null,{"$f":"IF(I29<Standards_Data!M$18,\"pass\",IF(OR(H29>Standards_Data!M$17,H29=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L28:L30)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L28:L30) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H29=\"undetermined\",0,IF(H29>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H29=\"undetermined\",\"ND\",IF(H29>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),P28-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q28=\"pass\",T28=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L29=1,M29=\"pass\",O29=\"pass\",U29=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,3,null,3,9,null,null,null,{"$f":"IF(I30<Standards_Data!M$18,\"pass\",IF(OR(H30>Standards_Data!M$17,H30=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L28:L30)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L28:L30) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H30=\"undetermined\",0,IF(H30>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H30=\"undetermined\",\"ND\",IF(H30>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),P28-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P28>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P28<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q28=\"pass\",T28=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L30=1,M30=\"pass\",O30=\"pass\",U30=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,4,null,1,10,null,null,null,{"$f":"IF(I31<Standards_Data!M$18,\"pass\",IF(OR(H31>Standards_Data!M$17,H31=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L31:L33)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L31:L33) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H31=\"undetermined\",0,IF(H31>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H31=\"undetermined\",\"ND\",IF(H31>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J31:J33)=0,\" \",AVERAGE(J31:J33))","v":" "},{"$f":"IF(P31=\" \",\" \",IF(P31> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P31=\" \",\" \",IF(P31> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),P31-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q31=\"pass\",T31=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L31=1,M31=\"pass\",O31=\"pass\",U31=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W31:W39)=0,  \" \",AVERAGE(W31:W39))","v":" "},{"$f":"IF( X31=\" \", \" \",(X31-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y31=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ32^2+ (-2*(X31-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X31-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W31:W39)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W31:W39)","v":{"$error":"#DIV/0!"}}]
[1,1,null,4,null,1,10,null,null,null,{"$f":"IF(I32<Standards_Data!M$18,\"pass\",IF(OR(H32>Standards_Data!M$17,H32=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L31:L33)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L31:L33) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H32=\"undetermined\",0,IF(H32>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H32=\"undetermined\",\"ND\",IF(H32>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),P31-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q31=\"pass\",T31=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L32=1,M32=\"pass\",O32=\"pass\",U32=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W31:W39) =9,0,DEVSQ(W31:W39))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W31:W39)-1","v":-1},{"$f":"AD32/AE32","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG34 <0),0,AG34) +    IF( (AG33 <0),0,AG33)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W31:W39) <=3,0,   IF(AG33 >0,SQRT((AG34/(AE32+1))+(AG33*(COUNT(W31:W33)^2+COUNT(W34:W36)^2+COUNT(W37:W39)^2)/(AE32+1)^2)), STDEV(W31:W39)/SQRT(COUNT(W31:W39)  ) ))","v":0}]
[1,1,null,4,null,1,10,null,null,null,{"$f":"IF(I33<Standards_Data!M$18,\"pass\",IF(OR(H33>Standards_Data!M$17,H33=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L31:L33)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L31:L33) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H33=\"undetermined\",0,IF(H33>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H33=\"undetermined\",\"ND\",IF(H33>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),P31-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P31>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P31<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q31=\"pass\",T31=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L33=1,M33=\"pass\",O33=\"pass\",U33=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD32-(AD34)","v":{"$error":"#DIV/0!"}},{"$f":"AE32 - AE34","v":2},{"$f":"AD33/AE33","v":{"$error":"#DIV/0!"}},{"$f":"(AF33-AF34)/(((COUNT(  W31:W33)+COUNT(  W34:W36)+COUNT(  W37:W39))-(COUNT(  W31:W33)^2+COUNT(  W34:W36)^2+COUNT(  W37:W39)^2)/(COUNT(  W31:W33)+COUNT(  W34:W36)+COUNT(  W37:W39)))/((IF(COUNTBLANK(  W31:W33)=3,0,1))+(IF(COUNTBLANK(  W34:W36)=3,0,1))+(IF(COUNTBLANK(  W37:W39)=3,0,1))-1))","v":{"$error":"#DIV/0!"}}]
[1,1,null,4,null,2,11,null,null,null,{"$f":"IF(I34<Standards_Data!M$18,\"pass\",IF(OR(H34>Standards_Data!M$17,H34=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L34:L36)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L34:L36) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H34=\"undetermined\",0,IF(H34>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H34=\"undetermined\",\"ND\",IF(H34>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J34:J36)=0,\" \",AVERAGE(J34:J36))","v":" "},{"$f":"IF(P34=\" \",\" \",IF(P34> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P34=\" \",\" \",IF(P34> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),P34-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q34=\"pass\",T34=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L34=1,M34=\"pass\",O34=\"pass\",U34=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W31:W33)=3,0,DEVSQ(  W31:W33))+IF(COUNTBLANK(  W34:W36)=3,0,DEVSQ(  W34:W36))+IF(COUNTBLANK(  W37:W39)=3,0,DEVSQ(  W37:W39))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W31:W33)=3,0,COUNT(  W31:W33)-1)+IF(COUNTBLANK(  W34:W36)=3,0,COUNT(  W34:W36)-1)+IF(COUNTBLANK(  W37:W39)=3,0,COUNT(  W37:W39)-1)","v":-3},{"$f":"AD34/AE34","v":{"$error":"#DIV/0!"}},{"$f":"AF34","v":{"$error":"#DIV/0!"}}]
[1,1,null,4,null,2,11,null,null,null,{"$f":"IF(I35<Standards_Data!M$18,\"pass\",IF(OR(H35>Standards_Data!M$17,H35=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L34:L36)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L34:L36) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H35=\"undetermined\",0,IF(H35>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H35=\"undetermined\",\"ND\",IF(H35>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),P34-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q34=\"pass\",T34=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L35=1,M35=\"pass\",O35=\"pass\",U35=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,4,null,2,11,null,null,null,{"$f":"IF(I36<Standards_Data!M$18,\"pass\",IF(OR(H36>Standards_Data!M$17,H36=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L34:L36)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L34:L36) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H36=\"undetermined\",0,IF(H36>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H36=\"undetermined\",\"ND\",IF(H36>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),P34-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P34>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P34<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q34=\"pass\",T34=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L36=1,M36=\"pass\",O36=\"pass\",U36=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(V36=\"fail\",\"\",IF(T36=\"pass\",H36-S36,H36))","v":{"$error":"#DIV/0!"}}]
[1,1,null,4,null,3,12,null,null,null,{"$f":"IF(I37<Standards_Data!M$18,\"pass\",IF(OR(H37>Standards_Data!M$17,H37=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L37:L39)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L37:L39) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H37=\"undetermined\",0,IF(H37>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H37=\"undetermined\",\"ND\",IF(H37>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J37:J39)=0,\" \",AVERAGE(J37:J39))","v":" "},{"$f":"IF(P37=\" \",\" \",IF(P37> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P37=\" \",\" \",IF(P37> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),P37-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q37=\"pass\",T37=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L37=1,M37=\"pass\",O37=\"pass\",U37=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,4,null,3,12,null,null,null,{"$f":"IF(I38<Standards_Data!M$18,\"pass\",IF(OR(H38>Standards_Data!M$17,H38=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L37:L39)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L37:L39) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H38=\"undetermined\",0,IF(H38>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H38=\"undetermined\",\"ND\",IF(H38>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),P37-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q37=\"pass\",T37=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L38=1,M38=\"pass\",O38=\"pass\",U38=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,4,null,3,12,null,null,null,{"$f":"IF(I39<Standards_Data!M$18,\"pass\",IF(OR(H39>Standards_Data!M$17,H39=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L37:L39)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L37:L39) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H39=\"undetermined\",0,IF(H39>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H39=\"undetermined\",\"ND\",IF(H39>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),P37-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P37>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P37<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q37=\"pass\",T37=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L39=1,M39=\"pass\",O39=\"pass\",U39=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,5,null,1,13,null,null,null,{"$f":"IF(I40<Standards_Data!M$18,\"pass\",IF(OR(H40>Standards_Data!M$17,H40=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L40:L42)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L40:L42) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H40=\"undetermined\",0,IF(H40>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H40=\"undetermined\",\"ND\",IF(H40>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J40:J42)=0,\" \",AVERAGE(J40:J42))","v":" "},{"$f":"IF(P40=\" \",\" \",IF(P40> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P40=\" \",\" \",IF(P40> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),P40-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q40=\"pass\",T40=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L40=1,M40=\"pass\",O40=\"pass\",U40=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W40:W48)=0,  \" \",AVERAGE(W40:W48))","v":" "},{"$f":"IF( X40=\" \", \" \",(X40-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y40=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ41^2+ (-2*(X40-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X40-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W40:W48)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W40:W48)","v":{"$error":"#DIV/0!"}}]
[1,1,null,5,null,1,13,null,null,null,{"$f":"IF(I41<Standards_Data!M$18,\"pass\",IF(OR(H41>Standards_Data!M$17,H41=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L40:L42)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L40:L42) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H41=\"undetermined\",0,IF(H41>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H41=\"undetermined\",\"ND\",IF(H41>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),P40-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q40=\"pass\",T40=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L41=1,M41=\"pass\",O41=\"pass\",U41=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W40:W48) =9,0,DEVSQ(W40:W48))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W40:W48)-1","v":-1},{"$f":"AD41/AE41","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG43 <0),0,AG43) +    IF( (AG42 <0),0,AG42)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W40:W48) <=3,0,   IF(AG42 >0,SQRT((AG43/(AE41+1))+(AG42*(COUNT(W40:W42)^2+COUNT(W43:W45)^2+COUNT(W46:W48)^2)/(AE41+1)^2)), STDEV(W40:W48)/SQRT(COUNT(W40:W48)  ) ))","v":0}]
[1,1,null,5,null,1,13,null,null,null,{"$f":"IF(I42<Standards_Data!M$18,\"pass\",IF(OR(H42>Standards_Data!M$17,H42=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L40:L42)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L40:L42) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H42=\"undetermined\",0,IF(H42>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H42=\"undetermined\",\"ND\",IF(H42>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),P40-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P40>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P40<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q40=\"pass\",T40=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L42=1,M42=\"pass\",O42=\"pass\",U42=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD41-(AD43)","v":{"$error":"#DIV/0!"}},{"$f":"AE41 - AE43","v":2},{"$f":"AD42/AE42","v":{"$error":"#DIV/0!"}},{"$f":"(AF42-AF43)/(((COUNT(  W40:W42)+COUNT(  W43:W45)+COUNT(  W46:W48))-(COUNT(  W40:W42)^2+COUNT(  W43:W45)^2+COUNT(  W46:W48)^2)/(COUNT(  W40:W42)+COUNT(  W43:W45)+COUNT(  W46:W48)))/((IF(COUNTBLANK(  W40:W42)=3,0,1))+(IF(COUNTBLANK(  W43:W45)=3,0,1))+(IF(COUNTBLANK(  W46:W48)=3,0,1))-1))","v":{"$error":"#DIV/0!"}}]
[1,1,null,5,null,2,14,null,null,null,{"$f":"IF(I43<Standards_Data!M$18,\"pass\",IF(OR(H43>Standards_Data!M$17,H43=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L43:L45)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L43:L45) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H43=\"undetermined\",0,IF(H43>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H43=\"undetermined\",\"ND\",IF(H43>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J43:J45)=0,\" \",AVERAGE(J43:J45))","v":" "},{"$f":"IF(P43=\" \",\" \",IF(P43> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P43=\" \",\" \",IF(P43> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),P43-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q43=\"pass\",T43=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L43=1,M43=\"pass\",O43=\"pass\",U43=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W40:W42)=3,0,DEVSQ(  W40:W42))+IF(COUNTBLANK(  W43:W45)=3,0,DEVSQ(  W43:W45))+IF(COUNTBLANK(  W46:W48)=3,0,DEVSQ(  W46:W48))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W40:W42)=3,0,COUNT(  W40:W42)-1)+IF(COUNTBLANK(  W43:W45)=3,0,COUNT(  W43:W45)-1)+IF(COUNTBLANK(  W46:W48)=3,0,COUNT(  W46:W48)-1)","v":-3},{"$f":"AD43/AE43","v":{"$error":"#DIV/0!"}},{"$f":"AF43","v":{"$error":"#DIV/0!"}}]
[1,1,null,5,null,2,14,null,null,null,{"$f":"IF(I44<Standards_Data!M$18,\"pass\",IF(OR(H44>Standards_Data!M$17,H44=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L43:L45)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L43:L45) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H44=\"undetermined\",0,IF(H44>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H44=\"undetermined\",\"ND\",IF(H44>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),P43-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q43=\"pass\",T43=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L44=1,M44=\"pass\",O44=\"pass\",U44=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,5,null,2,14,null,null,null,{"$f":"IF(I45<Standards_Data!M$18,\"pass\",IF(OR(H45>Standards_Data!M$17,H45=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L43:L45)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L43:L45) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H45=\"undetermined\",0,IF(H45>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H45=\"undetermined\",\"ND\",IF(H45>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),P43-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P43>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P43<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q43=\"pass\",T43=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L45=1,M45=\"pass\",O45=\"pass\",U45=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,5,null,3,15,null,null,null,{"$f":"IF(I46<Standards_Data!M$18,\"pass\",IF(OR(H46>Standards_Data!M$17,H46=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L46:L48)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L46:L48) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H46=\"undetermined\",0,IF(H46>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H46=\"undetermined\",\"ND\",IF(H46>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J46:J48)=0,\" \",AVERAGE(J46:J48))","v":" "},{"$f":"IF(P46=\" \",\" \",IF(P46> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P46=\" \",\" \",IF(P46> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),P46-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q46=\"pass\",T46=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L46=1,M46=\"pass\",O46=\"pass\",U46=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,5,null,3,15,null,null,null,{"$f":"IF(I47<Standards_Data!M$18,\"pass\",IF(OR(H47>Standards_Data!M$17,H47=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L46:L48)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L46:L48) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H47=\"undetermined\",0,IF(H47>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H47=\"undetermined\",\"ND\",IF(H47>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),P46-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q46=\"pass\",T46=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L47=1,M47=\"pass\",O47=\"pass\",U47=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,5,null,3,15,null,null,null,{"$f":"IF(I48<Standards_Data!M$18,\"pass\",IF(OR(H48>Standards_Data!M$17,H48=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L46:L48)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L46:L48) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H48=\"undetermined\",0,IF(H48>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H48=\"undetermined\",\"ND\",IF(H48>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),P46-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P46>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P46<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q46=\"pass\",T46=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L48=1,M48=\"pass\",O48=\"pass\",U48=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,6,null,1,16,null,null,null,{"$f":"IF(I49<Standards_Data!M$18,\"pass\",IF(OR(H49>Standards_Data!M$17,H49=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L49:L51)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L49:L51) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H49=\"undetermined\",0,IF(H49>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H49=\"undetermined\",\"ND\",IF(H49>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J49:J51)=0,\" \",AVERAGE(J49:J51))","v":" "},{"$f":"IF(P49=\" \",\" \",IF(P49> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P49=\" \",\" \",IF(P49> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),P49-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q49=\"pass\",T49=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L49=1,M49=\"pass\",O49=\"pass\",U49=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W49:W57)=0,  \" \",AVERAGE(W49:W57))","v":" "},{"$f":"IF( X49=\" \", \" \",(X49-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y49=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ50^2+ (-2*(X49-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X49-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W49:W57)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W49:W57)","v":{"$error":"#DIV/0!"}}]
[1,1,null,6,null,1,16,null,null,null,{"$f":"IF(I50<Standards_Data!M$18,\"pass\",IF(OR(H50>Standards_Data!M$17,H50=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L49:L51)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L49:L51) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H50=\"undetermined\",0,IF(H50>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H50=\"undetermined\",\"ND\",IF(H50>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),P49-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q49=\"pass\",T49=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L50=1,M50=\"pass\",O50=\"pass\",U50=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W49:W57) =9,0,DEVSQ(W49:W57))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W49:W57)-1","v":-1},{"$f":"AD50/AE50","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG52 <0),0,AG52) +    IF( (AG51 <0),0,AG51)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W49:W57) <=3,0,   IF(AG51 >0,SQRT((AG52/(AE50+1))+(AG51*(COUNT(W49:W51)^2+COUNT(W52:W54)^2+COUNT(W55:W57)^2)/(AE50+1)^2)), STDEV(W49:W57)/SQRT(COUNT(W49:W57)  ) ))","v":0}]
[1,1,null,6,null,1,16,null,null,null,{"$f":"IF(I51<Standards_Data!M$18,\"pass\",IF(OR(H51>Standards_Data!M$17,H51=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L49:L51)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L49:L51) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H51=\"undetermined\",0,IF(H51>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H51=\"undetermined\",\"ND\",IF(H51>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),P49-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P49>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P49<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q49=\"pass\",T49=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L51=1,M51=\"pass\",O51=\"pass\",U51=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD50-(AD52)","v":{"$error":"#DIV/0!"}},{"$f":"AE50 - AE52","v":2},{"$f":"AD51/AE51","v":{"$error":"#DIV/0!"}},{"$f":"(AF51-AF52)/(((COUNT(  W49:W51)+COUNT(  W52:W54)+COUNT(  W55:W57))-(COUNT(  W49:W51)^2+COUNT(  W52:W54)^2+COUNT(  W55:W57)^2)/(COUNT(  W49:W51)+COUNT(  W52:W54)+COUNT(  W55:W57)))/((IF(COUNTBLANK(  W49:W51)=3,0,1))+(IF(COUNTBLANK(  W52:W54)=3,0,1))+(IF(COUNTBLANK(  W55:W57)=3,0,1))-1))","v":{"$error":"#DIV/0!"}}]
[1,1,null,6,null,2,17,null,null,null,{"$f":"IF(I52<Standards_Data!M$18,\"pass\",IF(OR(H52>Standards_Data!M$17,H52=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L52:L54)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L52:L54) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H52=\"undetermined\",0,IF(H52>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H52=\"undetermined\",\"ND\",IF(H52>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J52:J54)=0,\" \",AVERAGE(J52:J54))","v":" "},{"$f":"IF(P52=\" \",\" \",IF(P52> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P52=\" \",\" \",IF(P52> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),P52-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q52=\"pass\",T52=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L52=1,M52=\"pass\",O52=\"pass\",U52=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W49:W51)=3,0,DEVSQ(  W49:W51))+IF(COUNTBLANK(  W52:W54)=3,0,DEVSQ(  W52:W54))+IF(COUNTBLANK(  W55:W57)=3,0,DEVSQ(  W55:W57))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W49:W51)=3,0,COUNT(  W49:W51)-1)+IF(COUNTBLANK(  W52:W54)=3,0,COUNT(  W52:W54)-1)+IF(COUNTBLANK(  W55:W57)=3,0,COUNT(  W55:W57)-1)","v":-3},{"$f":"AD52/AE52","v":{"$error":"#DIV/0!"}},{"$f":"AF52","v":{"$error":"#DIV/0!"}}]
[1,1,null,6,null,2,17,null,null,null,{"$f":"IF(I53<Standards_Data!M$18,\"pass\",IF(OR(H53>Standards_Data!M$17,H53=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L52:L54)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L52:L54) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H53=\"undetermined\",0,IF(H53>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H53=\"undetermined\",\"ND\",IF(H53>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),P52-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q52=\"pass\",T52=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L53=1,M53=\"pass\",O53=\"pass\",U53=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,6,null,2,17,null,null,null,{"$f":"IF(I54<Standards_Data!M$18,\"pass\",IF(OR(H54>Standards_Data!M$17,H54=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L52:L54)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L52:L54) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H54=\"undetermined\",0,IF(H54>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H54=\"undetermined\",\"ND\",IF(H54>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),P52-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P52>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P52<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q52=\"pass\",T52=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L54=1,M54=\"pass\",O54=\"pass\",U54=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,6,null,3,18,null,null,null,{"$f":"IF(I55<Standards_Data!M$18,\"pass\",IF(OR(H55>Standards_Data!M$17,H55=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L55:L57)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L55:L57) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H55=\"undetermined\",0,IF(H55>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H55=\"undetermined\",\"ND\",IF(H55>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J55:J57)=0,\" \",AVERAGE(J55:J57))","v":" "},{"$f":"IF(P55=\" \",\" \",IF(P55> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P55=\" \",\" \",IF(P55> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),P55-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q55=\"pass\",T55=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L55=1,M55=\"pass\",O55=\"pass\",U55=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,6,null,3,18,null,null,null,{"$f":"IF(I56<Standards_Data!M$18,\"pass\",IF(OR(H56>Standards_Data!M$17,H56=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L55:L57)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L55:L57) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H56=\"undetermined\",0,IF(H56>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H56=\"undetermined\",\"ND\",IF(H56>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),P55-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q52=\"pass\",T52=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L56=1,M56=\"pass\",O56=\"pass\",U56=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,6,null,3,18,null,null,null,{"$f":"IF(I57<Standards_Data!M$18,\"pass\",IF(OR(H57>Standards_Data!M$17,H57=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L55:L57)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L55:L57) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H57=\"undetermined\",0,IF(H57>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H57=\"undetermined\",\"ND\",IF(H57>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),P55-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P55>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P55<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q52=\"pass\",T52=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L57=1,M57=\"pass\",O57=\"pass\",U57=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,7,null,1,19,null,null,null,{"$f":"IF(I58<Standards_Data!M$18,\"pass\",IF(OR(H58>Standards_Data!M$17,H58=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L58:L60)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L58:L60) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H58=\"undetermined\",0,IF(H58>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H58=\"undetermined\",\"ND\",IF(H58>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J58:J60)=0,\" \",AVERAGE(J58:J60))","v":" "},{"$f":"IF(P58=\" \",\" \",IF(P58> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P58=\" \",\" \",IF(P58> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),P58-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q58=\"pass\",T58=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L58=1,M58=\"pass\",O58=\"pass\",U58=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(COUNT(W58:W66)=0,  \" \",AVERAGE(W58:W66))","v":" "},{"$f":"IF( X58=\" \", \" \",(X58-Standards_Data!M$11)/Standards_Data!M$7)","v":" "},{"$f":"IF(Y58=\" \",\" \",SQRT((1/Standards_Data!$M$7^2)*(Standards_Data!$M$12^2+AJ59^2+ (-2*(X58-Standards_Data!$M$11)*SUMSQ(Standards_Data!$AG$10:$AG$24)*AVERAGE(Standards_Data!$AE$10:$AE$24)/(DEVSQ(Standards_Data!$AE$10:$AE$24)*(COUNT(Standards_Data!$AG$10:$AG$24)-2)*Standards_Data!$M$7))+ ((X58-Standards_Data!$M$11)^2*Standards_Data!$M$8^2/(Standards_Data!$M$7^2)))))","v":" "},{"$f":"COUNT(W58:W66)","v":0},null,null,"SS","df","MSS","var.comp",null,"Adj_FAM_Cq",{"$f":"AVERAGE(W58:W66)","v":{"$error":"#DIV/0!"}}]
[1,1,null,7,null,1,19,null,null,null,{"$f":"IF(I59<Standards_Data!M$18,\"pass\",IF(OR(H59>Standards_Data!M$17,H59=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L58:L60)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L58:L60) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H59=\"undetermined\",0,IF(H59>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H59=\"undetermined\",\"ND\",IF(H59>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),P58-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q58=\"pass\",T58=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L59=1,M59=\"pass\",O59=\"pass\",U59=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Total",{"$f":"IF(COUNTBLANK(W58:W66) =9,0,DEVSQ(W58:W66))","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(W58:W66)-1","v":-1},{"$f":"AD59/AE59","v":{"$error":"#DIV/0!"}},{"$f":"IF((AG61 <0),0,AG61) +    IF( (AG60 <0),0,AG60)","v":{"$error":"#DIV/0!"}},null,"std.error",{"$f":"IF(COUNT(W58:W66) <=3,0,   IF(AG60 >0,SQRT((AG61/(AE59+1))+(AG60*(COUNT(W58:W60)^2+COUNT(W61:W63)^2+COUNT(W64:W66)^2)/(AE59+1)^2)), STDEV(W58:W66)/SQRT(COUNT(W58:W66)  ) ))","v":0}]
[1,1,null,7,null,1,19,null,null,null,{"$f":"IF(I60<Standards_Data!M$18,\"pass\",IF(OR(H60>Standards_Data!M$17,H60=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L58:L60)=0,Standards_Data!M$5>1.16),\" \",IF(SUM(L58:L60) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H60=\"undetermined\",0,IF(H60>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H60=\"undetermined\",\"ND\",IF(H60>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),P58-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P58>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P58<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q58=\"pass\",T58=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L60=1,M60=\"pass\",O60=\"pass\",U60=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,"Filter",{"$f":"AD59-(AD61)","v":{"$error":"#DIV/0!"}},{"$f":"AE59 - AE61","v":2},{"$f":"AD60/AE60","v":{"$error":"#DIV/0!"}},{"$f":"(AF60-AF61)/(((COUNT(  W58:W60)+COUNT(  W61:W63)+COUNT(  W64:W66))-(COUNT(  W58:W60)^2+COUNT(  W61:W63)^2+COUNT(  W64:W66)^2)/(COUNT(  W58:W60)+COUNT(  W61:W63)+COUNT(  W64:W66)))/((IF(COUNTBLANK(  W58:W60)=3,0,1))+(IF(COUNTBLANK(  W61:W63)=3,0,1))+(IF(COUNTBLANK(  W64:W66)=3,0,1))-1))","v":{"$error":"#DIV/0!"}}]
[1,1,null,7,null,2,20,null,null,null,{"$f":"IF(I61<Standards_Data!M$18,\"pass\",IF(OR(H61>Standards_Data!M$17,H61=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L61:L63)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L61:L63) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H61=\"undetermined\",0,IF(H61>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H61=\"undetermined\",\"ND\",IF(H61>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J61:J63)=0,\" \",AVERAGE(J61:J63))","v":" "},{"$f":"IF(P61=\" \",\" \",IF(P61> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P61=\" \",\" \",IF(P61> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),P61-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q61=\"pass\",T61=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L61=1,M61=\"pass\",O61=\"pass\",U61=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(V61=\"fail\",\"\",IF(T61=\"pass\",H61-S61,H61))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Residual",{"$f":"IF(COUNTBLANK(  W58:W60)=3,0,DEVSQ(  W58:W60))+IF(COUNTBLANK(  W61:W63)=3,0,DEVSQ(  W61:W63))+IF(COUNTBLANK(  W64:W66)=3,0,DEVSQ(  W64:W66))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(  W58:W60)=3,0,COUNT(  W58:W60)-1)+IF(COUNTBLANK(  W61:W63)=3,0,COUNT(  W61:W63)-1)+IF(COUNTBLANK(  W64:W66)=3,0,COUNT(  W64:W66)-1)","v":-3},{"$f":"AD61/AE61","v":{"$error":"#DIV/0!"}},{"$f":"AF61","v":{"$error":"#DIV/0!"}}]
[1,1,null,7,null,2,20,null,null,null,{"$f":"IF(I62<Standards_Data!M$18,\"pass\",IF(OR(H62>Standards_Data!M$17,H62=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L61:L63)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L61:L63) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H62=\"undetermined\",0,IF(H62>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H62=\"undetermined\",\"ND\",IF(H62>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),P61-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q61=\"pass\",T61=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L62=1,M62=\"pass\",O62=\"pass\",U62=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,7,null,2,20,null,null,null,{"$f":"IF(I63<Standards_Data!M$18,\"pass\",IF(OR(H63>Standards_Data!M$17,H63=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L61:L63)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L61:L63) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H63=\"undetermined\",0,IF(H63>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H63=\"undetermined\",\"ND\",IF(H63>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),P61-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P61>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P61<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q61=\"pass\",T61=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L63=1,M63=\"pass\",O63=\"pass\",U63=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,7,null,3,21,null,null,null,{"$f":"IF(I64<Standards_Data!M$18,\"pass\",IF(OR(H64>Standards_Data!M$17,H64=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L64:L66)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L64:L66) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H64=\"undetermined\",0,IF(H64>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H64=\"undetermined\",\"ND\",IF(H64>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNT(J64:J66)=0,\" \",AVERAGE(J64:J66))","v":" "},{"$f":"IF(P64=\" \",\" \",IF(P64> (Sketa22_Data!O$4+3*Sketa22_Data!O$5),\"fail\",\"pass\"))","v":" "},{"$f":"IF(P64=\" \",\" \",IF(P64> (Sketa22_Data!O$4+3.3),\"fail\",\"pass\"))","v":" "},{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),P64-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q64=\"pass\",T64=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L64=1,M64=\"pass\",O64=\"pass\",U64=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,7,null,3,21,null,null,null,{"$f":"IF(I65<Standards_Data!M$18,\"pass\",IF(OR(H65>Standards_Data!M$17,H65=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L64:L66)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L64:L66) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H65=\"undetermined\",0,IF(H65>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H65=\"undetermined\",\"ND\",IF(H65>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),P64-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q64=\"pass\",T64=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L65=1,M65=\"pass\",O65=\"pass\",U65=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[1,1,null,7,null,3,21,null,null,null,{"$f":"IF(I66<Standards_Data!M$18,\"pass\",IF(OR(H66>Standards_Data!M$17,H66=\"undetermined\"),\"inhb\",\"comp\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(OR(COUNT(L64:L66)=0,Standards_Data!M$5>Standards_Data!M$23),\" \",IF(SUM(L64:L66) >=2,\"pass\",\"fail\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H66=\"undetermined\",0,IF(H66>=Standards_Data!M$25,0,1))","v":0},{"$f":"IF(H66=\"undetermined\",\"ND\",IF(H66>Standards_Data!M$22,\"fail\",\"pass\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),P64-(Sketa22_Data!O$4+3*Sketa22_Data!O$5),\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(P64>(Sketa22_Data!O$4+3*Sketa22_Data!O$5), P64<= (Sketa22_Data!O$4+3.3)),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(Sketa22_Data!O$5 <0.62,OR(Q64=\"pass\",T64=\"pass\")),\"pass\",\" \")","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(L66=1,M66=\"pass\",O66=\"pass\",U66=\"pass\",Standards_Data!M$20=\"pass\",Standards_Data!M$21=\"pass\",Standards_Data!M$6=\"pass\",Standards_Data!H$30=\"pass\",Sketa22_Data!G$18=\"pass\"),\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[null,null,null,null,null,null,"SPC Plot Data:"]
[]
[null,null,null,null,null,null,"Mean Sketa22","Pass SPC Acceptance Threshold","Filter","Eligible for Cq adjustment","Fail SPC test","SPC Aceptance Threshold","SPC Adjustment Threshold","Cq > 30"]
[null,null,"HF183",null,null,null,{"$f":"$P$4","v":" "},{"$f":"IF( G73 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G73,\"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF( AND(G73 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G73 <(Sketa22_Data!O$4+3.3)),G73,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G73 >(Sketa22_Data!O$4+3.3),G73< 30),G73,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}},{"$f":"IF(G73=\" \",\" \",IF(G73>=30,30,\" \"))","v":" "}]
[null,null,"HumM2",null,null,null,{"$f":"P$7","v":" "},{"$f":"IF( G74 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G74,\"\")","v":{"$error":"#DIV/0!"}},2,{"$f":"IF( AND(G74 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G74 <(Sketa22_Data!O$4+3.3)),G74,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G74 >(Sketa22_Data!O$4+3.3),G74< 30),G74,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}},{"$f":"IF(G74=\" \",\" \",IF(G74>=30,30,\" \"))","v":" "}]
[null,null,null,null,null,null,{"$f":"P$10","v":" "},{"$f":"IF( G75 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G75,\"\")","v":{"$error":"#DIV/0!"}},3,{"$f":"IF( AND(G75 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G75 <(Sketa22_Data!O$4+3.3)),G75,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G75 >(Sketa22_Data!O$4+3.3),G75< 30),G75,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$13","v":" "},{"$f":"IF( G76 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G76,\"\")","v":{"$error":"#DIV/0!"}},4,{"$f":"IF( AND(G76 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G76 <(Sketa22_Data!O$4+3.3)),G76,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G76 >(Sketa22_Data!O$4+3.3),G76< 30),G76,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$16","v":" "},{"$f":"IF( G77 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G77,\"\")","v":{"$error":"#DIV/0!"}},5,{"$f":"IF( AND(G77 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G77 <(Sketa22_Data!O$4+3.3)),G77,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G77 >(Sketa22_Data!O$4+3.3),G77< 30),G77,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$19","v":" "},{"$f":"IF( G78 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G78,\"\")","v":{"$error":"#DIV/0!"}},6,{"$f":"IF( AND(G78 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G78 <(Sketa22_Data!O$4+3.3)),G78,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G78 >(Sketa22_Data!O$4+3.3),G78< 30),G78,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$22","v":" "},{"$f":"IF( G79 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G79,\"\")","v":{"$error":"#DIV/0!"}},7,{"$f":"IF( AND(G79 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G79 <(Sketa22_Data!O$4+3.3)),G79,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G79 >(Sketa22_Data!O$4+3.3),G79< 30),G79,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$25","v":" "},{"$f":"IF( G80 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G80,\"\")","v":{"$error":"#DIV/0!"}},8,{"$f":"IF( AND(G80 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G80 <(Sketa22_Data!O$4+3.3)),G80,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G80 >(Sketa22_Data!O$4+3.3),G80< 30),G80,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$28","v":" "},{"$f":"IF( G81 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G81,\"\")","v":{"$error":"#DIV/0!"}},9,{"$f":"IF( AND(G81 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G81 <(Sketa22_Data!O$4+3.3)),G81,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G81 >(Sketa22_Data!O$4+3.3),G81< 30),G81,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$31","v":" "},{"$f":"IF( G82 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G82,\"\")","v":{"$error":"#DIV/0!"}},10,{"$f":"IF( AND(G82 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G82 <(Sketa22_Data!O$4+3.3)),G82,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G82 >(Sketa22_Data!O$4+3.3),G82< 30),G82,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$34","v":" "},{"$f":"IF( G83 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G83,\"\")","v":{"$error":"#DIV/0!"}},11,{"$f":"IF( AND(G83 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G83 <(Sketa22_Data!O$4+3.3)),G83,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G83 >(Sketa22_Data!O$4+3.3),G83< 30),G83,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$37","v":" "},{"$f":"IF( G84 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G84,\"\")","v":{"$error":"#DIV/0!"}},12,{"$f":"IF( AND(G84 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G84 <(Sketa22_Data!O$4+3.3)),G84,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G84 >(Sketa22_Data!O$4+3.3),G84< 30),G84,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$40","v":" "},{"$f":"IF( G85 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G85,\"\")","v":{"$error":"#DIV/0!"}},13,{"$f":"IF( AND(G85 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G85 <(Sketa22_Data!O$4+3.3)),G85,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G85 >(Sketa22_Data!O$4+3.3),G85< 30),G85,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$43","v":" "},{"$f":"IF( G86 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G86,\"\")","v":{"$error":"#DIV/0!"}},14,{"$f":"IF( AND(G86 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G86 <(Sketa22_Data!O$4+3.3)),G86,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G86 >(Sketa22_Data!O$4+3.3),G86< 30),G86,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$46","v":" "},{"$f":"IF( G87 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G87,\"\")","v":{"$error":"#DIV/0!"}},15,{"$f":"IF( AND(G87 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G87 <(Sketa22_Data!O$4+3.3)),G87,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G87 >(Sketa22_Data!O$4+3.3),G87< 30),G87,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$49","v":" "},{"$f":"IF( G88 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G88,\"\")","v":{"$error":"#DIV/0!"}},16,{"$f":"IF( AND(G88 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G88 <(Sketa22_Data!O$4+3.3)),G88,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G88 >(Sketa22_Data!O$4+3.3),G88< 30),G88,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$52","v":" "},{"$f":"IF( G89 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G89,\"\")","v":{"$error":"#DIV/0!"}},17,{"$f":"IF( AND(G89 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G89 <(Sketa22_Data!O$4+3.3)),G89,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G89 >(Sketa22_Data!O$4+3.3),G89< 30),G89,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$55","v":" "},{"$f":"IF( G90 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G90,\"\")","v":{"$error":"#DIV/0!"}},18,{"$f":"IF( AND(G90 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G90 <(Sketa22_Data!O$4+3.3)),G90,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G90 >(Sketa22_Data!O$4+3.3),G90< 30),G90,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$58","v":" "},{"$f":"IF( G91 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G91,\"\")","v":{"$error":"#DIV/0!"}},19,{"$f":"IF( AND(G91 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G91 <(Sketa22_Data!O$4+3.3)),G91,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G91 >(Sketa22_Data!O$4+3.3),G91< 30),G91,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$61","v":" "},{"$f":"IF( G92 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G92,\"\")","v":{"$error":"#DIV/0!"}},20,{"$f":"IF( AND(G92 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G92 <(Sketa22_Data!O$4+3.3)),G92,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G92 >(Sketa22_Data!O$4+3.3),G92< 30),G92,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,null,null,null,{"$f":"P$64","v":" "},{"$f":"IF( G93 <(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G93,\"\")","v":{"$error":"#DIV/0!"}},21,{"$f":"IF( AND(G93 >(Sketa22_Data!O$4+3*Sketa22_Data!O$5),G93 <(Sketa22_Data!O$4+3.3)),G93,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF( AND(G93 >(Sketa22_Data!O$4+3.3),G93< 30),G93,\"\")","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}," "]

{"sheet":"Final Report","index":4,"n_rows":66,"n_cols":17,"rows_kept":66,"cut":false,"hidden":false,"merged":[[23,1,24,1],[25,1,27,1],[25,2,26,2],[28,1,29,1],[0,0,0,12]]}
["Human Fecal Source Identification Results Summary"]
[]
[]
["Table 1:  Calibration Model Performance Metrics",null,null,null,null,"Figure 1: Calibration model with 95% Prediction Interval",null,null,null,null,null,null,null,null,null,null,"Legend: \"Final Report\" Tab"]
[null,null,null,"Std. Error",null,null,null,null,null,null,null,null,null,null,null,"Std. Error","Calibration model slope and intercpet standard error"]
[{"$f":"Standards_Data!$D$4","v":0},"Slope",{"$f":"Standards_Data!$M$7","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$M$8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"E","Calibration model amplification efficiency"]
[null,"Intercept",{"$f":"Standards_Data!$M$11","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$M$12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"R2","Calibration model correlation coefficient"]
[null,"E",{"$f":"Standards_Data!$M$19","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"LLOQ","Calibration model lower limit of quantification"]
[null,"R2",{"$f":"Standards_Data!$M$15","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"# of Outliers","Number of outliers"]
[null,"LLOQ",{"$f":"Standards_Data!$M$22","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"ROQ (min & max) ","Calibration model range of quantification log10 copies per reaction (min = minimum and max = maximum)"]
[null,"LLOQ in log10 copies/rxn",{"$f":"(C10 -C7)/C6","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"IAC ROQ (min & max)","Internal amplification control range of quantification log10 copies per reaction (min = minimum and max = maximum)"]
[null,"# of Outliers",{"$f":"Standards_Data!$M$24","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"NTC","No template control"]
[null,"ROQ (min & max) ",{"$f":"MIN(Standards_Data!$F$10:'Standards_Data'!$F$24)","v":1},{"$f":"MAX(Standards_Data!$F$10:'Standards_Data'!$F$24)","v":5},null,null,null,null,null,null,null,null,null,null,null,"MB","Method blank"]
[null,"IAC ROQ (min & max)",1,{"$f":"Standards_Data!$M$16","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Sample ID","Sample identification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n","number of individual reactions used to estimate log10 copies per reaction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Cq","Quantification cyle used to make concentration estimate"]
[]
[]
[]
[]
["Table 2: Quality Control and Proficiency Metrics"]
[]
[null,"Type","Metric","Assay","Acceptance Threshold","Observed","Result"]
[null,"Calibration Curve Model","R2",{"$f":"Standards_Data!$D$4","v":0},"≥ 0.980",{"$f":"Standards_Data!$M$15","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$M$21","v":{"$error":"#DIV/0!"}}]
[null,null,"E",{"$f":"Standards_Data!$D$4","v":0},"0.90 to 1.10",{"$f":"Standards_Data!$M$19","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$M$20","v":{"$error":"#DIV/0!"}}]
[null,"Extraneous DNA","NTC",{"$f":"Standards_Data!$D$4","v":0},"All test reaction Cq values ≤ LLOQ",{"$f":"SUM(Standards_Data!$I$4:$I$9)","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$M$6","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Sketa22","All test reaction Cq values > 35",{"$f":"SUM(Sketa22_Data!$F$18:$F$26)","v":0},{"$f":"Sketa22_Data!$G$18","v":"fail"}]
[null,null,"MB",{"$f":"Standards_Data!$D$4","v":0},"All test reaction Cq values ≤ LLOQ",{"$f":"SUM(Standards_Data!$G$30:$G$38)","v":{"$error":"#DIV/0!"}},{"$f":"Standards_Data!$H$30","v":{"$error":"#DIV/0!"}}]
[null,"Matrix and Amplification Control Proficiency","IAC Proficiency",{"$f":"Standards_Data!$D$4","v":0},"HF183/BacR287 = VIC Cq standard deviation ≤ 1.16; HumM2 = VIC Cq standard deviation ≤ 1.05",{"$f":"Standards_Data!$M$5","v":{"$error":"#DIV/0!"}},{"$f":"IF($F$29<Standards_Data!$M$23,\"pass\",\"fail\")","v":{"$error":"#DIV/0!"}}]
[null,null,"SPC Proficiency","Sketa22","Sketa22 = MEB  standard deviation ≤ 0.62 Cq",{"$f":"Sketa22_Data!$O$5","v":{"$error":"#DIV/0!"}},{"$f":"Sketa22_Data!$O$6","v":{"$error":"#DIV/0!"}}]
[]
[]
["Table 3: Amplification and Matrix Interference Thresholds",null,null,null,null,"Figure 2: Test Filter SPC Results"]
[]
["Assay","Criteria","Observed"]
[{"$f":"Standards_Data!$D$4","v":0},"IAC Standard Deviation",{"$f":"Standards_Data!$M$5","v":{"$error":"#DIV/0!"}}]
[null,"IAC Interference Threshold",{"$f":"Standards_Data!$M$18","v":{"$error":"#DIV/0!"}}]
[null,"IAC Competition Threshold",{"$f":"Standards_Data!$M$17","v":{"$error":"#DIV/0!"}}]
[]
["Sketa22","SPC Standard Deviation",{"$f":"Sketa22_Data!$O$5","v":{"$error":"#DIV/0!"}}]
[null,"SPC Acceptance Threshold",{"$f":"Sketa22_Data!O$4+3*Sketa22_Data!O$5","v":{"$error":"#DIV/0!"}}]
[null,"SPC Adjustment Threshold",{"$f":"Sketa22_Data!O$4+3.3","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 4: Test Sample Estimated Concentrations"]
[]
["Assay","Sample ID","n","Final Cq","Log10 copies per reaction","Standard Deviation"]
[{"$f":"Standards_Data!$D$4","v":0},{"$f":"IF(Samples_Data!$E$4=0,\" \",Samples_Data!$E$4)","v":" "},{"$f":"IF(B59=\" \",\" \",Samples_Data!$AA$4)","v":" "},{"$f":"IF(B59=\" \",\" \",IF(C59=0,\"*QA Fail\",Samples_Data!$AJ$4))","v":" "},{"$f":"Samples_Data!$Y$4","v":" "},{"$f":"Samples_Data!$Z$4","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$13=0,\" \",Samples_Data!$E$13)","v":" "},{"$f":"IF(B60=\" \",\" \",Samples_Data!$AA$13)","v":" "},{"$f":"IF(B60=\" \",\" \",IF(C60=0,\"*QA Fail\",Samples_Data!$AJ$13))","v":" "},{"$f":"Samples_Data!$Y$13","v":" "},{"$f":"Samples_Data!$Z$13","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$22=0,\" \",Samples_Data!$E$22)","v":" "},{"$f":"IF(B61=\" \",\" \",Samples_Data!$AA$22)","v":" "},{"$f":"IF(B61=\" \",\" \",IF(C61=0,\"*QA Fail\",Samples_Data!$AJ$22))","v":" "},{"$f":"Samples_Data!$Y$22","v":" "},{"$f":"Samples_Data!$Z$22","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$31=0,\" \",Samples_Data!$E$31)","v":" "},{"$f":"IF(B62=\" \",\" \",Samples_Data!$AA$31)","v":" "},{"$f":"IF(B62=\" \",\" \",IF(C62=0,\"*QA Fail\",Samples_Data!$AJ$31))","v":" "},{"$f":"Samples_Data!$Y$31","v":" "},{"$f":"Samples_Data!$Z$31","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$40=0,\" \",Samples_Data!$E$40)","v":" "},{"$f":"IF(B63=\" \",\" \",Samples_Data!$AA$40)","v":" "},{"$f":"IF(B63=\" \",\" \",IF(C63=0,\"*QA Fail\",Samples_Data!$AJ$40))","v":" "},{"$f":"Samples_Data!$Y$40","v":" "},{"$f":"Samples_Data!$Z$40","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$49=0,\" \",Samples_Data!$E$49)","v":" "},{"$f":"IF(B64=\" \",\" \",Samples_Data!$AA$49)","v":" "},{"$f":"IF(B64=\" \",\" \",IF(C64=0,\"*QA Fail\",Samples_Data!$AJ$49))","v":" "},{"$f":"Samples_Data!$Y$49","v":" "},{"$f":"Samples_Data!$Z$49","v":" "}]
[null,{"$f":"IF(Samples_Data!$E$58=0,\" \",Samples_Data!$E$58)","v":" "},{"$f":"IF(B65=\" \",\" \",Samples_Data!$AA$58)","v":" "},{"$f":"IF(B65=\" \",\" \",IF(C65=0,\"*QA Fail\",Samples_Data!$AJ$58))","v":" "},{"$f":"Samples_Data!$Y$58","v":" "},{"$f":"Samples_Data!$Z$58","v":" "}]
["* Indicates failure of one or more data acceptance metrics"]