{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["initial MDL 7 replicates","example initial MDL form","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"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":"initial MDL 7 replicates","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,8],[9,5,9,8],[36,0,36,8]]}
["INITIAL Method Detection Limit (MDL - Rev 2) Data Collection Form"]
["LAB NAME:"]
["SOP NUMBER:"]
["METHOD:",null,null,null,null,"TECHNOLOGY:"]
["ANALYTE:",null,null,null,null,"MATRIX:"]
["INSTRUMENT(S): "]
["What was the Estimated MDL and how was it determined?"]
[]
["FINAL DETERMINED MDL WITH UNITS OF MEASURE:",null,null,null,{"$f":"IF(OR(G22=\"\",G34=\"\"),\"\",(LARGE((G22,G34),1)))","v":""}]
[null,null,null,null,null,"Reviewer - Signature & Date"]
["SPIKED CLEAN MATRIX"]
["DATA","SPIKE VALUE \n(Must be same for all replicates)","SPIKE UNITS","PREP DATE & BATCH ID IF APPLICABLE","ANALYSIS DATE & BATCH ID IF APPLICABLE","INSTRUMENT","ANALYSIS VALUE","ANALYSIS RECOVERY","ANALYSIS UNITS"]
[1,null,null,null,null,null,null,{"$f":"IF(G13=\"\",\"\",G13/B13*100)","v":""}]
[2,{"$f":"IF($B$13=\"\",\"\",B13)","v":""},{"$f":"IF($C$13=\"\",\"\",C13)","v":""},null,null,null,null,{"$f":"IF(G14=\"\",\"\",G14/B14*100)","v":""},{"$f":"IF($I$13=\"\",\"\",I13)","v":""}]
[3,"",{"$f":"IF($C$13=\"\",\"\",C14)","v":""},null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15/B15*100)","v":""},{"$f":"IF($I$13=\"\",\"\",I14)","v":""}]
[4,"","",null,null,null,null,"",""]
[5,"","",null,null,null,null,"",""]
[6,"","",null,null,null,null,"",""]
[7,"","",null,null,null,null,"",""]
[null,null,null,"Count (n):",7,"Mean:",{"$f":"IF(G19=\"\",\"\",AVERAGE(G13:G19))","v":""}]
[null,null,null,"student's T:",3.1429999999999998,"Std Dev:",{"$f":"IF(G19=\"\",\"\",_xlfn.STDEV.P(G13:G19))","v":""}]
[null,null,null,null,null,"MDLs:",{"$f":"IF(G21=\"\",\"\",E21*G21)","v":""}]
["METHOD BLANK:"]
["DATA",null,null,"PREP DATE & BATCH ID IF APPLICABLE","ANALYSIS DATE & BATCH ID IF APPLICABLE","INSTRUMENT","ANALYSIS VALUE",null,"ANALYSIS UNITS"]
[1]
[2,null,null,null,null,null,null,null,{"$f":"IF($I$25=\"\",\"\",I25)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF($I$25=\"\",\"\",I26)","v":""}]
[4,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,""]
[null,null,null,"Count (n):",7,"Mean:",{"$f":"IF(G31=\"\",\"\",AVERAGE(G25:G31))","v":""}]
[null,null,null,"student's T:",3.1429999999999998,"Std Dev:",{"$f":"IF(G31=\"\",\"\",_xlfn.STDEV.P(G25:G31))","v":""}]
[null,null,null,null,null,"MDLb:",{"$f":"IF(G32=\"\",\"\",G32+(E33*G33))","v":""}]
[]
["Supporting Data is:  [    ] Attached      [     ] Located at: _______________________________________________________________"]
["Note:  This is an example of a suitable data collection format.   Other approaches may meet data collection and data review needs.  Form must be modified for approrpriate decimal formatting, larger data sets, multi-analyte summaries, and re-calculation.  Appropriate use / modification of the form is the responsibility of the user.  Full data traceability from this summary document to raw data records, calibrations, etc. is the responsibility of the laboratory."]

{"sheet":"example initial MDL form","index":1,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,5,9,8],[0,0,0,8],[36,0,36,8]]}
["INITIAL Method Detection Limit (MDL - Rev 2) Data Collection Form"]
["LAB NAME:"]
["SOP NUMBER:"]
["METHOD:",null,null,null,null,"TECHNOLOGY:"]
["ANALYTE:",null,null,null,null,"MATRIX:"]
["INSTRUMENT(S): "]
["What was the Estimated MDL and how was it determined?",null,null,null,null,"0.8  µg/L - previously determined"]
[]
["FINAL DETERMINED MDL WITH UNITS OF MEASURE:",null,null,null,{"$f":"IF(OR(G22=\"\",G34=\"\"),\"\",(LARGE((G22,G34),1)))","v":0.94610170700617591}]
[null,null,null,null,null,"Reviewer - Signature & Date"]
["SPIKED CLEAN MATRIX"]
["DATA","SPIKE VALUE \n(Must be same for all replicates)","SPIKE UNITS","PREP DATE & BATCH ID IF APPLICABLE","ANALYSIS DATE & BATCH ID IF APPLICABLE","INSTRUMENT","ANALYSIS VALUE","ANALYSIS RECOVERY","ANALYSIS UNITS"]
[1,4,"µg/L","2017-10-15","2017-10-15","Inst #1",4.2,{"$f":"IF(G13=\"\",\"\",G13/B13*100)","v":105},"µg/L"]
[2,{"$f":"IF($B$13=\"\",\"\",B13)","v":4},{"$f":"IF($C$13=\"\",\"\",C13)","v":"µg/L"},"2017-10-15","2017-10-15","Inst #1",4.2,{"$f":"IF(G14=\"\",\"\",G14/B14*100)","v":105},{"$f":"IF($I$13=\"\",\"\",I13)","v":"µg/L"}]
[3,4,{"$f":"IF($C$13=\"\",\"\",C14)","v":"µg/L"},"2017-10-15","2017-10-15","Inst #2",4.0999999999999996,{"$f":"IF(G15=\"\",\"\",G15/B15*100)","v":102.49999999999999},{"$f":"IF($I$13=\"\",\"\",I14)","v":"µg/L"}]
[4,4,"µg/L","2017-10-17","2017-10-17","Inst #1",3.9,97.5,"µg/L"]
[5,4,"µg/L","2017-10-17","2017-10-17","Inst #2",3.8,95,"µg/L"]
[6,4,"µg/L","2017-10-18","2017-10-18","Inst #1",3.5,87.5,"µg/L"]
[7,4,"µg/L","2017-10-18","2017-10-18","Inst #2",3.4,85,"µg/L"]
[null,null,null,"Count (n):",7,"Mean:",{"$f":"IF(G19=\"\",\"\",AVERAGE(G13:G19))","v":3.871428571428571}]
[null,null,null,"student's T:",3.1429999999999998,"Std Dev:",{"$f":"IF(G19=\"\",\"\",_xlfn.STDEV.P(G13:G19))","v":0.30101867865293541}]
[null,null,null,null,null,"MDLs:",{"$f":"IF(G21=\"\",\"\",E21*G21)","v":0.94610170700617591}]
["METHOD BLANK:"]
["DATA",null,null,"PREP DATE & BATCH ID IF APPLICABLE","ANALYSIS DATE & BATCH ID IF APPLICABLE","INSTRUMENT","ANALYSIS VALUE",null,"ANALYSIS UNITS"]
[1,null,null,"2017-10-15","2017-10-15","Inst #1",-0.2,null,"µg/L"]
[2,null,null,"2017-10-15","2017-10-15","Inst #1",-0.1,null,{"$f":"IF($I$25=\"\",\"\",I25)","v":"µg/L"}]
[3,null,null,"2017-10-15","2017-10-15","Inst #2",0.3,null,{"$f":"IF($I$25=\"\",\"\",I26)","v":"µg/L"}]
[4,null,null,"2017-10-17","2017-10-17","Inst #1",0,null,"µg/L"]
[5,null,null,"2017-10-17","2017-10-17","Inst #2",0,null,"µg/L"]
[6,null,null,"2017-10-18","2017-10-18","Inst #1",0,null,"µg/L"]
[7,null,null,"2017-10-18","2017-10-18","Inst #2",0.4,null,"µg/L"]
[null,null,null,"Count (n):",7,"Mean:",{"$f":"IF(G31=\"\",\"\",AVERAGE(G25:G31))","v":5.7142857142857141E-2}]
[null,null,null,"student's T:",3.1429999999999998,"Std Dev:",{"$f":"IF(G31=\"\",\"\",_xlfn.STDEV.P(G25:G31))","v":0.19897697538834458}]
[null,null,null,null,null,"MDLb:",{"$f":"IF(G32=\"\",\"\",G32+(E33*G33))","v":0.68252749078842412}]
[]
["Supporting Data is:  [    ] Attached      [     ] Located at: _______________________________________________________________"]
["Note:  This is an example of a suitable data collection format.   Other approaches may meet data collection and data review needs.  Form must be modified for approrpriate decimal formatting, larger data sets, multi-analyte summaries, and re-calculation.  Appropriate use / modification of the form is the responsibility of the user.  Full data traceability from this summary document to raw data records, calibrations, etc. is the responsibility of the laboratory."]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}