{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Start","Determinand Names","Log","Help","Test data to delete","ValidationTemplate_0","SummaryTemplate_0","Validation_1","Results_1","Summary_1","Validation_2","Results_2","Summary_2"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Start","index":0,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,3,7,3],[1,5,1,7],[11,0,11,3],[17,0,17,3],[30,0,30,3],[1,0,1,3],[9,1,9,3],[31,0,45,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[23,0,23,3],[24,1,24,3],[27,1,27,3],[25,1,25,3],[26,1,26,3],[28,1,28,3]]}
[]
["Document Overview",null,null,null,null,"Colour Key",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["QPulse Document Title","Method Validation for Chemical Tests Workbook",null,null,null,null,"Mandatory Data Entry",null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["QPulse Document ID","ES-VALID-S-009",null,null,null,null,"Optional Text Entry"]
["Issue No",9,null,null,null,null,"Ready Data"]
["Issue Date","2017-09-12",null,null,null,null,"Corrected Data"]
["Owner","Redacted",null,null,null,null,"Determinand Name"]
["Authorised By","Redacted",null,null,null,null,"No Entry Required"]
[]
["Workbook Status"]
[]
["Method Overview"]
["Instrument","Orbitrap LC-HRAM"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments"]
["Lab","ASB"]
["Date","6 - 22/09/17"]
[]
["Personnel Overview"]
["Work Completed By","Redacted"]
["Work Completed Date","2017-09-22"]
["Authorised By","Redacted"]
["Authorised Date","2017-10-05"]
[]
["Accreditation and Design Plan Documentation"]
["Has form BF-213 been completed?","Yes"]
["BF-213 Document","See Aquaculture folder"]
["Accreditation Change Number","See Aquaculture folder"]
["Has validation design plan been completed?","Yes"]
["Validation design plan document","See Aquaculture folder"]
[]
["Validation Notes"]

{"sheet":"Determinand Names","index":1,"n_rows":202,"n_cols":3,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Determinand Number","Determinand Name(s) - Optional List for > 20 Determinands"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,102]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]
[null,126]
[null,127]
[null,128]
[null,129]
[null,130]
[null,131]
[null,132]
[null,133]
[null,134]
[null,135]
[null,136]
[null,137]
[null,138]
[null,139]
[null,140]
[null,141]
[null,142]
[null,143]
[null,144]
[null,145]
[null,146]
[null,147]
[null,148]
[null,149]
[null,150]
[null,151]
[null,152]
[null,153]
[null,154]
[null,155]
[null,156]
[null,157]
[null,158]
[null,159]
[null,160]
[null,161]
[null,162]
[null,163]
[null,164]
[null,165]
[null,166]
[null,167]
[null,168]
[null,169]
[null,170]
[null,171]
[null,172]
[null,173]
[null,174]
[null,175]
[null,176]
[null,177]
[null,178]
[null,179]
[null,180]
[null,181]
[null,182]
[null,183]
[null,184]
[null,185]
[null,186]
[null,187]
[null,188]
[null,189]
[null,190]
[null,191]
[null,192]
[null,193]
[null,194]
[null,195]
[null,196]
[null,197]
[null,198]
[null,199]
[null,200]

{"sheet":"Log","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Action Taken","Sheet Group","Completed By","Date/Time"]
["Validation sheets created","Validation_1","Redacted","2017-10-07T08:38:42"]
["Results submitted","Validation_1","Redacted","2017-10-07T08:42:01"]
["Results calculated","Validation_1","Redacted","2017-10-07T08:42:05"]
["Validation sheets created","Validation_2","Redacted","2017-10-07T08:47:09"]
["Results submitted (Some results missing)","Validation_2","Redacted","2017-10-07T08:53:49"]
["Sheets Deleted","Validation_2","Redacted","2017-10-07T08:56:08"]
["Validation sheets created","Validation_2","Redacted","2017-10-07T08:56:43"]
["Results submitted (Some results missing)","Validation_2","Redacted","2017-10-07T09:00:05"]
["Results submitted","Validation_2","Redacted","2017-10-07T09:02:37"]
["Results calculated","Validation_2","Redacted","2017-10-07T09:02:41"]

{"sheet":"Help","index":3,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Crib sheet"]
["See procedure QPULSE LINK"]
[]
[null,"Welcome to the new method validation workbook"]
[null,"It is comprised of three sheets which each have a different role"]
[null,"Validation is where the validation results are automatically calculated and contains all the controls for the macros. This sheet is protected from any manual modification."]
[null,"Results is where data is entered by the user. This sheet is unprotected."]
[null,"Summary is where a condensed version of the validation results is displayed. This sheet is unprotected"]
[]
[null,"Validation contains several special buttons which control some of the features of the workbook"]
[null,"Setup","This button opens a userform where you can choose what type of validation you are undertaking, number of determinands, type of samples"]
[null,"Submit Raw Results","This button sends the raw results from the Results sheet and enters them into the Validation1 sheet"]
[null,"Calculate","This button will correct all the submitted raw data and calculate the statistical results of the validation exercise. It is only enabled when results have been submitted."]
[null,"Clear Calculated Results","This button will clear everything from the Validation sheet. This is the only way to remove data as the Validation sheet is protected."]
[null,"Create Summary","This button creates a condensed set of final results and sends them to the Summary sheet."]
[null,"Lock","This button deactivates all the other buttons. Once the validation exercise is complete this can be used to prevent accidentally overwriting the template."]
[]
[null,"To use the sheet it must be set up first for the required exercise. See SPC procedure QPULSE LINK for guidelines"]
[null,"The Setup button is used to create a new template for the validation exercise. This template is applied to the Validation and Results sheet, reflecting the options that you select."]
[]
[null,"Click setup"]
[null,"Enter determinand names","not mandatory","can enter manually later if needed"]
[null,"number of determinands","mandatory"]
[null,"select MDL type","mandatory"]
[null,"number of unspiked replicates","mandatory"]
[null,"if sample is stable","mandatory"]
[null,"select objective","mandatory"]
[null,"select test types","mandatory","beware test types removed if you change page"]
[null,"enter matrix details","not mandatory","can enter manually later if needed"]
[null,"click OK","sheet generated"]
[null,"if happy click Close Form","form closes"]
[]
[null,"The template should now be generated for the validation exercise. Check that it reflects your needs. If any changes are required, simply select the setup button and start again."]
[]
[null,"Once the template is configured you can now enter results on to the Results sheet"]
[null,"Determinand names and matrix information can also be entered/updated here."]
[null,"Enter data for every sample type for every determinand (this is mandatory)"]
[null,"Once all the results are entered click Submit Results on the Validation sheet."]
[null,"Raw results are now copied over to the Validation sheet."]
[null,"If raw results need to be amended/updated then the Submit Results button will need to be used again"]
[null,"Once satisfied that all the raw results are final click the Calculate button"]
[null,"The raw results are now corrected (eg for spike/unspike or blank correction) and used to calculate the statistical results"]
[null,"Inspect these calculated results and if satisfied click the Summary button"]
[null,"Final results should be transposed to the Summary sheet and ready for reporting"]
[]
[null,"If finished click the Lock button to prevent accidentally erasing data."]

{"sheet":"Test data to delete","index":4,"n_rows":256,"n_cols":33,"rows_kept":256,"cut":false,"hidden":true,"merged":[]}
[]
["Mandatory red","RGB(230, 184, 183)"]
["Optional Yellow","RGB(255, 255, 153)"]
["Ready to go green","RGB(196, 215, 155)"]
["Calculated Blue","RGB(170, 213, 240)"]
["Determinand Purple","RGB(177, 160, 199)"]
[]
[]
[null,null,"Batch",null,null,null,null,null,null,null,null,null,null,"Targets"]
[null,null,1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery"]
[null,null,null,null,null,null,null,null,null,5,10,10,25]
["1x6","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001]
["spike unspike","PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,null,null,null,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,null,null,null,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,null,null,null,null,50,80,120]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,10,25]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,null,null,null,null,100,80,120,null,null,null,0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,null,null,null,null,null,null,null,null,null,null,0.5,0.56000000000000005,0.62,0.68,0.74,0.8]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,null,null,null,null,null,null,null,null,null,null,10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,null,null,null,null,100,80,120,null,null,null,11,11.561,12.122,12.683,13.244,13.805,null,null,null,null,null,10,80,120]
[null,null,null,null,null,null,null,null,null,5,5,10,null,null,null,null,null,null,null,90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995]
["1x6","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,null,null,null,null,null,null,null,null,null,null,90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,null,null,null,null,90,80,120]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,null,null,null,null,10,80,120,null,null,null,49.311690980069848,49.867926854325034,50.424162728580228,50.980398602835415,51.536634477090601,52.092870351345788]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,null,null,null,null,90,80,120,null,null,null,49.311690980069848,50.148549825354415,50.985408670638989,51.822267515923556,52.659126361208124,53.495985206492698]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,null,null,null,null,50,80,120,null,null,null,98.962798777035601,98.802646301545053,98.642493826054533,98.482341350563985,98.322188875073437,98.162036399582902]
[null,"MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,null,null,null,null,null,null,null,null,null,null,98.962798777035601,99.007782936022153,99.052767095008718,99.097751253995256,99.142735412981793,99.187719571968373,null,null,null,null,null,100,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,null,null,null,null,null,null,null,null,null,null,49.311690980069848,49.867926854325034,50.424162728580228,50.980398602835415,51.536634477090601,52.092870351345788]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,null,null,null,null,null,null,null,null,null,null,49.311690980069848,50.148549825354415,50.985408670638989,51.822267515923556,52.659126361208124,53.495985206492698]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,null,null,null,null,100,80,120,null,null,null,98.962798777035601,98.802646301545053,98.642493826054533,98.482341350563985,98.322188875073437,98.162036399582902]
[null,null,null,null,null,null,null,null,null,5,10,10,null,null,null,null,null,null,null,98.962798777035601,99.007782936022153,99.052767095008718,99.097751253995256,99.142735412981793,99.187719571968373,null,null,null,null,null,100,80,120]
["6x2","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,null,null,null,null,null,null,null,null,null,null,49.311690980069848,49.867926854325034,50.424162728580228,50.980398602835415,51.536634477090601,52.092870351345788]
[null,"2nd Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8,null,null,null,null,null,null,null,null,null,null,null,49.311690980069848,50.148549825354415,50.985408670638989,51.822267515923556,52.659126361208124,53.495985206492698]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,null,null,null,null,null,null,null,null,null,null,98.962798777035601,98.802646301545053,98.642493826054533,98.482341350563985,98.322188875073437,98.162036399582902]
[null,"2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,null,null,null,null,10,80,120,null,null,null,98.962798777035601,99.007782936022153,99.052767095008718,99.097751253995256,99.142735412981793,99.187719571968373,null,null,null,null,null,100,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995]
[null,"2nd PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,null,null,null,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,null,null,null,null,50,80,120]
[null,"Unspiked MDL",5,5.84,6.68,7.52,8.36,9.1999999999999993]
[null,"2nd Unspiked MDL",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993]
[null,"Spiked MDL",50,50.564,51.128,51.692,52.256,52.82]
[null,"2nd Spiked MDL",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,null,null,null,null,100,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82]
[null,"2nd Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,null,null,null,null,null,null,null,null,"raw",50,null,{"$f":"(S46-S47)/S48","v":59.868421052631575},{"$f":"(S46/S48)-(S47/S48)","v":59.868421052631575}]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,null,null,null,null,null,null,null,null,"blank",4.5]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,null,null,null,null,100,80,120,null,"recovery",0.76]
[]
["6x2","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,5,null,10]
["1 unsp rep","PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,5,null,10,null,10]
[null,"2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,5,null,10,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,5,null,10,null,90]
[null,"2nd PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,5,null,10,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,5,null,10,null,null,80,120]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"2nd Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,15,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,5,null,10]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100,80,120]
[null,null,null,null,null,null,null,null,null,5,null,10]
["6x4","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001]
["2 unsp","2nd Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999]
[null,"2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805]
[null,"3rd PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999]
[null,"4th PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,null,null,null,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995]
[null,"2nd PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27]
[null,"3rd PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995]
[null,"4th PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,null,null,null,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"3rd CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"4th CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50,80,120]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,5,null,10]
[null,"2nd Unspiked MDL",50,50.894100000000002,51.788200000000003,52.682299999999998,53.5764,54.470500000000001,null,5,null,10]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"2nd Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100]
[null,"3rd Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"4th Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,null,10]
[null,"3rd LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"4th LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,15,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,5,null,10]
[null,"2nd Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,5,null,10]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100]
[null,"3rd Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100]
[null,"4th Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100,80,120]
[]
[]
["6x4","Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,5,null,10,null,0]
[null,"2nd Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8,null,5,null,10,null,0]
[null,"3rd Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,5,null,10,null,0]
[null,"4th Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8,null,5,null,10,null,0]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,5,null,10,null,10,null,null,null,10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999]
[null,"2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,5,null,10,null,10,null,null,null,11,11.561,12.122,12.683,13.244,13.805]
[null,"3rd PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,5,null,10,null,10,null,null,null,10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999]
[null,"4th PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,5,null,10,null,10,80,120,null,11,11.561,12.122,12.683,13.244,13.805]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,5,null,10,null,90,null,null,null,90,88,87,90,89,91]
[null,"2nd PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,5,null,10,null,90,null,null,null,91,88.8,88.55,91,89,91]
[null,"3rd PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,5,null,10,null,90,null,null,null,90,89.2,88,91,89,92]
[null,"4th PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,5,null,10,null,90,80,120,null,92,87.54,88,90,89,92]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"3rd CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"4th CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,5,null,10,null,50]
[null,"2nd Unspiked MDL",50,50.894100000000002,51.788200000000003,52.682299999999998,53.5764,54.470500000000001,null,5,null,10,null,50]
[null,"3rd Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,5,null,10,null,50]
[null,"4th Unspiked MDL",50,50.894100000000002,51.788200000000003,52.682299999999998,53.5764,54.470500000000001,null,5,null,10,null,50]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"2nd Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100]
[null,"3rd Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"4th Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,null,10]
[null,"3rd LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"4th LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,15,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,5,null,10,null,null,null,null,null,{"$f":"C126","v":50},{"$f":"D126-2.5","v":48.064},{"$f":"E126-5","v":46.128},{"$f":"F126-7.5","v":44.192},{"$f":"G126-10","v":42.256},{"$f":"H126-12.5","v":40.32}]
[null,"2nd Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,5,null,10,null,null,null,null,null,{"$f":"C127","v":50},{"$f":"D127-2.5","v":48.34854},{"$f":"E127-5","v":46.69708},{"$f":"F127-7.5","v":45.04562},{"$f":"G127-10","v":43.394159999999999},{"$f":"H127-12.5","v":41.742699999999999}]
[null,"3rd Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,5,null,10,null,null,null,null,null,50,48.064,46.128,44.192,42.256,40.32]
[null,"4th Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,5,null,10,null,null,null,null,null,50,48.34854,46.69708,45.04562,43.394159999999999,41.742699999999999]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100,null,null,null,150,{"$f":"D130-2.5","v":148.04},146.08000000000001,144.12,142.16,140.19999999999999,null,100,5,10]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100,null,null,null,150,148.24799999999999,146.49600000000001,144.744,142.99199999999999,141.24,null,100,5,10]
[null,"3rd Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100,null,null,null,150,148.04,146.08000000000001,144.12,142.16,140.19999999999999,null,100,5,10]
[null,"4th Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100,80,120,null,150,148.24799999999999,146.49600000000001,144.744,142.99199999999999,141.24,null,100,5,10,80,120]
[]
[null,"Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,null,5,null,10]
[null,"2nd Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8,null,5,null,10]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,5,null,10,null,10]
["6x4","2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,5,null,10,null,10]
["2 unsp reps","3rd PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,null,5,null,10,null,10]
[null,"4th PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,null,5,null,10,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,5,null,10,null,90]
[null,"2nd PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,5,null,10,null,90]
[null,"3rd PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,null,5,null,10,null,90]
[null,"4th PCS at 90% Method Range",90,90.653999999999996,91.308000000000007,91.962000000000003,92.616,93.27,null,5,null,10,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"3rd CRM",50,50.561,51.122,51.683,52.244,52.805,null,5,null,10,null,50]
[null,"4th CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,null,5,null,10,null,50]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,null,5,null,10]
[null,"2nd Unspiked MDL",50,50.894100000000002,51.788200000000003,52.682299999999998,53.5764,54.470500000000001,null,5,null,10]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"2nd Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100]
[null,"3rd Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,null,5,null,10,null,100]
[null,"4th Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,null,5,null,10,null,100,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,null,10]
[null,"3rd LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,null,5,null,10]
[null,"4th LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,null,5,15,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,null,5,null,10]
[null,"2nd Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,null,5,null,10]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100]
[null,"3rd Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,null,5,null,10,null,100]
[null,"4th Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,null,5,null,10,null,100,80,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,10]
["1x11","Process Blank",0.1]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,13.384600000000001,13.948700000000001,14.5128,15.0769,15.641,null,null,null,null,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,92.105999999999995,92.456999999999994,92.808000000000007,93.159000000000006,93.51,null,null,null,null,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,53.366,53.927,54.488,55.048999999999999,55.61,null,50,5,10,80,120]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,55.244,56.118000000000002,56.991999999999997,57.866,58.74,null,50,5,10]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,153.92400000000001,154.578,155.232,155.886,156.54,null,100,5,10,80,120]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,10.039999999999999,10.88,11.72,12.56,13.4,null,5,5,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,53.384,53.948,54.512,55.076000000000001,55.64,null,50,5,10]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,153.24,153.78,154.32,154.86000000000001,155.4,null,100,5,10,80,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,10]
[null,"Process Blank",0.1,0.32100000000000001,0.54200000000000004,0.76300000000000001,0.98399999999999999,1.2050000000000001,1.4259999999999999,1.647,1.8680000000000001,2.089,2.31]
[null,"2nd Process Blank",0.5,0.56000000000000005,0.62,0.68,0.74,0.8,0.86,0.92,0.98,1.04,1.1000000000000001]
[null,"PCS at 10% Method Range",10,10.5641,11.1282,11.692299999999999,12.256399999999999,12.820499999999999,13.384600000000001,13.948700000000001,14.5128,15.0769,15.641]
[null,"2nd PCS at 10% Method Range",11,11.561,12.122,12.683,13.244,13.805,14.366,14.927,15.488,16.048999999999999,16.61,null,null,null,null,null,10,80,120]
[null,"PCS at 90% Method Range",90,90.350999999999999,90.701999999999998,91.052999999999997,91.403999999999996,91.754999999999995,92.105999999999995,92.456999999999994,92.808000000000007,93.159000000000006,93.51]
[null,"2nd PCS at 90% Method Range",90,90.4,90.8,91.2,91.6,92,92.4,92.8,93.2,93.600000000000094,94.000000000000099,null,null,null,null,null,90,80,120]
[null,"CRM",50,50.561,51.122,51.683,52.244,52.805,53.366,53.927,54.488,55.048999999999999,55.61,null,50,5,10]
[null,"2nd CRM",50,50.651000000000003,51.302,51.953000000000003,52.603999999999999,53.255000000000003,53.905999999999999,54.557000000000002,55.207999999999998,55.859000000000002,56.51,null,50,5,10]
[null,"Unspiked MDL",50,50.874000000000002,51.747999999999998,52.622,53.496000000000002,54.37,55.244,56.118000000000002,56.991999999999997,57.866,58.74,null,50,5,10]
["11x2","2nd Unspiked MDL",50,50.894100000000002,51.788200000000003,52.682299999999998,53.5764,54.470500000000001,55.364600000000003,56.258699999999997,57.152799999999999,58.046900000000001,58.941000000000003,null,50,5,10]
[null,"Spiked MDL",150,150.654,151.30799999999999,151.96199999999999,152.61600000000001,153.27000000000001,153.92400000000001,154.578,155.232,155.886,156.54,null,100,5,10]
[null,"2nd Spiked MDL",150,150.68440000000001,151.36879999999999,152.0532,152.73759999999999,153.422,154.10640000000001,154.79079999999999,155.4752,156.15960000000001,156.84399999999999,null,100,5,10]
[null,"LOQ",5,5.84,6.68,7.52,8.36,9.1999999999999993,10.039999999999999,10.88,11.72,12.56,13.4,null,5,5,10]
[null,"2nd LOQ",5,5.6584399999999997,6.3168800000000003,6.97532,7.6337599999999997,8.2921999999999993,8.9506399999999999,9.6090800000000005,10.267519999999999,10.92596,11.5844,null,5,5,10]
[null,"Unspiked Sample",50,50.564,51.128,51.692,52.256,52.82,53.384,53.948,54.512,55.076000000000001,55.64,null,50,5,10]
[null,"2nd Unspiked Sample",50,50.84854,51.69708,52.54562,53.394159999999999,54.242699999999999,55.091239999999999,55.939779999999999,56.788319999999999,57.636859999999999,58.485399999999998,null,50,5,10]
[null,"Spiked Sample",150,150.54,151.08000000000001,151.62,152.16,152.69999999999999,153.24,153.78,154.32,154.86000000000001,155.4,null,100,5,10]
[null,"2nd Spiked Sample",150,150.74799999999999,151.49600000000001,152.244,152.99199999999999,153.74,154.488,155.23599999999999,155.98400000000001,156.732,157.47999999999999,null,100,5,10]
[]
[]
[null,0.1,10,90,null,9.6999999999999993,89.7]
[null,0.5,11,90,null,10.7,89.7]
[null,0.32100000000000001,10.5641,90.350999999999999,null,10.1236,89.910499999999999]
[null,0.56000000000000005,11.561,90.653999999999996,null,11.1205,90.213499999999996]
[null,0.54200000000000004,11.1282,90.701999999999998,null,10.5472,90.120999999999995]
[null,0.62,12.122,91.308000000000007,null,11.541,90.727000000000004]
[null,0.76300000000000001,11.692299999999999,91.052999999999997,null,10.970799999999999,90.331499999999991]
[null,0.68,12.683,91.962000000000003,null,11.961499999999999,91.240499999999997]
[null,0.98399999999999999,12.256399999999999,91.403999999999996,null,11.394399999999999,90.542000000000002]
[null,0.74,13.244,92.616,null,12.382,91.754000000000005]
[null,1.2050000000000001,12.820499999999999,91.754999999999995,null,11.818,90.752499999999998]
[null,0.8,13.805,93.27,null,12.8025,92.267499999999998]
[]
[]
[null,0.1,10,90,null,0.1,9.6999999999999993,89.7]
[null,0.5,11,90,null,0.5,10.7,89.7]
[null,0.1,10,90,null,0.1,9.6999999999999993,89.7]
[null,0.5,11,90,null,0.5,10.7,89.7]
[null,0.32100000000000001,10.5641,90.350999999999999,null,0.32100000000000001,10.1236,89.910499999999999]
[null,0.56000000000000005,11.561,90.653999999999996,null,0.56000000000000005,11.1205,90.213499999999996]
[null,0.32100000000000001,10.5641,90.350999999999999,null,0.32100000000000001,10.1236,89.910499999999999]
[null,0.56000000000000005,11.561,90.653999999999996,null,0.56000000000000005,11.1205,90.213499999999996]
[null,0.54200000000000004,11.1282,90.701999999999998,null,0.54200000000000004,10.5472,90.120999999999995]
[null,0.62,12.122,91.308000000000007,null,0.62,11.541,90.727000000000004]
[null,0.54200000000000004,11.1282,90.701999999999998,null,0.54200000000000004,10.5472,90.120999999999995]
[null,0.62,12.122,91.308000000000007,null,0.62,11.541,90.727000000000004]
[null,0.76300000000000001,11.692299999999999,91.052999999999997,null,0.76300000000000001,10.970799999999999,90.331499999999991]
[null,0.68,12.683,91.962000000000003,null,0.68,11.961499999999999,91.240499999999997]
[null,0.76300000000000001,11.692299999999999,91.052999999999997,null,0.76300000000000001,10.970799999999999,90.331499999999991]
[null,0.68,12.683,91.962000000000003,null,0.68,11.961499999999999,91.240499999999997]
[null,0.98399999999999999,12.256399999999999,91.403999999999996,null,0.98399999999999999,11.394399999999999,90.542000000000002]
[null,0.74,13.244,92.616,null,0.74,12.382,91.754000000000005]
[null,0.98399999999999999,12.256399999999999,91.403999999999996,null,0.98399999999999999,11.394399999999999,90.542000000000002]
[null,0.74,13.244,92.616,null,0.74,12.382,91.754000000000005]
[null,1.2050000000000001,12.820499999999999,91.754999999999995,null,1.2050000000000001,11.818,90.752499999999998]
[null,0.8,13.805,93.27,null,0.8,12.8025,92.267499999999998]
[null,1.2050000000000001,12.820499999999999,91.754999999999995,null,1.2050000000000001,11.818,90.752499999999998]
[null,0.8,13.805,93.27,null,0.8,12.8025,92.267499999999998]
[]
[null,0.1,9.6999999999999993,89.7]
[null,0.5,10.7,89.7]
[null,0.32100000000000001,10.1236,89.910499999999999]
[null,0.56000000000000005,11.1205,89.959500000000006]
[null,0.54200000000000004,10.5472,90.120999999999995]
[null,0.62,11.541,90.218999999999994]
[null,0.76300000000000001,10.970799999999999,90.331499999999991]
[null,0.68,11.961499999999999,90.478499999999997]
[null,0.98399999999999999,11.394399999999999,90.542000000000002]
[null,0.74,12.382,90.738]
[null,1.2050000000000001,11.818,90.752499999999998]
[null,0.8,12.8025,90.997500000000002]
[null,1.4259999999999999,12.2416,90.962999999999994]
[null,0.86,13.222999999999999,91.257000000000005]
[null,1.647,12.6652,91.17349999999999]
[null,0.92,13.6435,91.516499999999994]
[null,1.8680000000000001,13.088800000000001,91.384]
[null,0.98,14.064,91.775999999999996]
[null,2.089,13.5124,91.594500000000011]
[null,1.04,14.484499999999999,92.035500000000098]
[null,2.31,13.936,91.805000000000007]
[null,1.1000000000000001,14.904999999999999,92.295000000000101]

{"sheet":"ValidationTemplate_0","index":5,"n_rows":18,"n_cols":54,"rows_kept":18,"cut":false,"hidden":true,"merged":[[16,48,16,53],[1,5,1,7],[16,18,16,22],[16,24,16,25],[16,26,16,30],[16,39,16,47],[1,9,1,17],[16,31,16,38]]}
[]
[null,"Summary Information",null,null,null,"Colour Key",null,null,null,"Notes"]
["Instrument",null,null,null,null,null,"Mandatory Data Entry"]
["Procedure",null,null,null,null,null,"Optional Text Entry"]
["Lab",null,null,null,null,null,"Ready Data"]
["Date",null,null,null,null,null,"Corrected Data"]
["Sample Stability",null,null,null,null,null,"Determinand Name"]
["MDL/LOQ Test Matrix Type",null,null,null,null,null,"No Entry Required"]
["LOQ Assessment - QC Level"]
["Number of Unspiked Replicates"]
["Stage"]
["Blank Correction"]
["Recovery Correction"]
["P% Assessment - Marine Methods"]
["Validation Task"]
[]
[null,"Matrix",null,null,"Batch",null,null,null,null,null,null,"Targets",null,null,null,null,null,null,"Summary Stats",null,null,null,null,"P% Assessment","Detection Limit Assessment",null,"Std Dev Assessment",null,null,null,null,"Bias Assessment",null,null,null,null,null,null,null,"ANOVA",null,null,null,null,null,null,null,null,"Unstable samples"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date",1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD%","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery","Mean","Bias%","Total Standard Deviation","RSD%","Observed Recovery Factor","Observed P%","Observed MDL","Observed LOQ","Target SD from MDL","Target SD from RSD","Target SD Value","F-test Observed Std Dev vs Target Std Dev","F-Critical","Recovery %","Absolute Uncorrected Bias","Absolute Corrected Bias","Absolute Bias from Target RSD","Absolute Bias from Target MDL","Target Absolute Bias Value","T-Test","T-Critical","M0","M1","F-test M0 vs M1","F-Critical","Sw (Within Batch Std Dev)","Sb (Between Batch Std Dev)","St (Total Std Dev)",null,null,"Constant of Slope (Mean Standard Conc vs Standard Sb Value)","Unstable Sb Value","Unstable M1","Unstable St (Total Std Dev)","F-test M0 vs Unstable M1","F-Critical"]

{"sheet":"SummaryTemplate_0","index":6,"n_rows":18,"n_cols":43,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,13,14,42],[1,5,1,11],[6,5,6,11],[10,5,10,11],[7,5,9,11],[1,0,1,3],[2,5,5,11],[16,29,16,32],[16,33,16,37],[16,38,16,42],[16,1,16,3],[16,6,16,8],[16,9,16,11],[16,19,16,21],[16,22,16,28],[16,12,16,18],[1,13,1,42],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11]]}
[]
["Summary Information",null,null,null,null,"Statement of Suitability",null,null,null,null,null,null,null,"Notes"]
["Instrument"]
["Procedure"]
["Lab"]
["Date"]
["Sample Stability",null,null,null,null,"Further Action (if Required)"]
["MDL/LOQ Test Matrix Type"]
["LOQ Assessment - QC Level"]
["Number of Unspiked Replicates"]
["Stage",null,null,null,null,"Summary Authorisation"]
["Blank Correction",null,null,null,null,"Work Completed By"]
["Recovery Correction",null,null,null,null,"Work Completed Date"]
["P% Assessment - Marine Methods",null,null,null,null,"Authorised By"]
["Validation Task",null,null,null,null,"Authorised Date"]
[]
["Assessment Type","Matrix",null,null,null,null,"MDL Assessment",null,null,"LOQ Assessment",null,null,"Precision Assessment",null,null,null,null,null,null,"P% Assessment",null,null,"Bias Assessment",null,null,null,null,null,null,"Recovery Assessment",null,null,null,"One Way ANOVA Assessment",null,null,null,null,"Unstable samples Assessment"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date","Units","Overall Assessment Satisfactory?","Observed MDL","Required MDL","Performance Within Target?","Observed LOQ","Required LOQ","Performance Within Target?","Observed Standard Deviation","Target Standard Deviation","Observed RSD%","Target RSD%","F-test Observed Std Dev vs Target Std Dev","F-Critical (0.05)","Performance Within Target?","Observed P%","Target P%","Performance Within Target?","Observed Absolute Bias","Target Absolute Bias","Observed Bias%","Target Bias%","T-test","T-Critical","Performance Within Target?","Min Acceptable Recovery","Max Acceptable Recovery","Recovery Achieved","Performance Within Target?","M0","M1","F-test M0 vs M1","F-Critical","Performance Within Target?","M0","Unstable M1","F-test M0 vs Unstable M1","F-Critical","Performance Within Target?"]

{"sheet":"Validation_1","index":7,"n_rows":23,"n_cols":54,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,39,16,47],[16,48,16,53],[1,5,1,7],[1,9,1,17],[16,18,16,22],[16,24,16,25],[16,26,16,30],[16,31,16,38]]}
["Results calculated by Bowers, Sue at 07/10/2017 08:42:05"]
[null,"Summary Information",null,null,null,"Colour Key",null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,null,"Mandatory Data Entry"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments",null,null,null,null,"Optional Text Entry"]
["Lab","ASB",null,null,null,null,"Ready Data"]
["Date","2017-09-06",null,null,null,null,"Corrected Data"]
["Sample Stability","N/A",null,null,null,null,"Determinand Name"]
["MDL/LOQ Test Matrix Type","Not Required",null,null,null,null,"No Entry Required"]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 1&2 (6 reps) within batch"]
["Blank Correction","Not Required"]
["Recovery Correction","Not Required"]
["P% Assessment - Marine Methods","Not Required"]
["Validation Task","Preliminary Stage 1&2"]
[]
[null,"Matrix",null,null,"Replicate",null,null,null,null,null,null,"Targets",null,null,null,null,null,null,"Summary Stats",null,null,null,null,"P% Assessment","Detection Limit Assessment",null,"Std Dev Assessment",null,null,null,null,"Bias Assessment",null,null,null,null,null,null,null,"ANOVA",null,null,null,null,null,null,null,null,"Unstable samples"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date",1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD%","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery","Mean","Bias%","Total Standard Deviation","RSD%","Observed Recovery Factor","Observed P%","Observed MDL","Observed LOQ","Target SD from MDL","Target SD from RSD","Target SD Value","F-test Observed Std Dev vs Target Std Dev","F-Critical","Recovery %","Absolute Uncorrected Bias","Absolute Corrected Bias","Absolute Bias from Target RSD","Absolute Bias from Target MDL","Target Absolute Bias Value","T-Test","T-Critical","M0","M1","F-test M0 vs M1","F-Critical","Sw (Within Batch Std Dev)","Sb (Between Batch Std Dev)","St (Total Std Dev)",null,null,"Constant of Slope (Mean Standard Conc vs Standard Sb Value)","Unstable Sb Value","Unstable M1","Unstable St (Total Std Dev)","F-test M0 vs Unstable M1","F-Critical"]
["Determinand: Emamectin benzoate",null,null,null,null,null,null,null,null,null,"ng/l",null,null,25]
["Unspiked Sample","Cage Edge = Near-Field",null,null,52.3,46.96,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E20:F20)","v":49.629999999999995},null,{"$f":"STDEV(E20:F20)","v":3.7759502115361609},{"$f":"(U20/$S$20)*100","v":7.6082011112959123},null,null,null,null,{"$f":"IF($L$19>Y20,($L$19/4),(Y20/4))","v":0},{"$f":"($S$20*$N$19)/100","v":12.407500000000001},{"$f":"IF(AB20>AA20,AB20,AA20)","v":12.407500000000001},{"$f":"$U$20^2/AC20^2","v":9.2615558639878928E-2},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678}]
["Spiked Sample","Cage Edge = Near-Field",null,null,91.460000000000008,106.11000000000001,76.14,113.18,111.87,106.94,null,null,null,null,null,150,60,120,{"$f":"AVERAGE(E21:J21)","v":100.95},{"$f":"($S$21-$P$21)/$P$21*100","v":-32.699999999999996},{"$f":"STDEV(E21:J21)","v":14.400841642070764},{"$f":"(U21/$S$21)*100","v":14.265321091699617},null,null,null,null,{"$f":"IF($L$19>Y21,($L$19/4),(Y21/4))","v":0},{"$f":"($S$21*$N$19)/100","v":25.237500000000001},{"$f":"IF(AB21>AA21,AB21,AA21)","v":25.237500000000001},{"$f":"$U$21^2/AC21^2","v":0.32559901735886393},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678},{"$f":"($S$21/$P$21)*100","v":67.300000000000011},{"$f":"$S$21-$P$21","v":-49.05},null,{"$f":"((2*$N$19)/100)*$P$21","v":75},{"$f":"0.5*$L$19","v":0},{"$f":"IF(AI21>AJ21, AI21, AJ21)","v":75},{"$f":"IF($S$21 > $P$21,ABS((($S$21 - ($P$21 + $AK$21)) * (SQRT(6)/$U$21))),ABS((($S$21 - ($P$21 - $AK$21)) * (SQRT(6)/$U$21))))","v":4.4139266582535157},{"$f":"_xlfn.T.INV(0.95, (6 - 1))","v":2.0150483733330233}]
["Unspiked Sample","Outside AZE = Far-Field",null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E22:F22)","v":0},null,{"$f":"STDEV(E22:F22)","v":0},0,null,null,null,null,{"$f":"IF($L$19>Y22,($L$19/4),(Y22/4))","v":0},{"$f":"($S$22*$N$19)/100","v":0},{"$f":"IF(AB22>AA22,AB22,AA22)","v":0},{"$f":"$U$22^2/AC22^2","v":{"$error":"#DIV/0!"}},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678}]
["Spiked Sample","Outside AZE = Far-Field",null,null,90.17,111.06,99.44,96.48,83.01,96.52,null,null,null,null,null,150,60,120,{"$f":"AVERAGE(E23:J23)","v":96.113333333333344},{"$f":"($S$23-$P$23)/$P$23*100","v":-35.92444444444444},{"$f":"STDEV(E23:J23)","v":9.3998929071913704},{"$f":"(U23/$S$23)*100","v":9.7800092673836811},null,null,null,null,{"$f":"IF($L$19>Y23,($L$19/4),(Y23/4))","v":0},{"$f":"($S$23*$N$19)/100","v":24.028333333333336},{"$f":"IF(AB23>AA23,AB23,AA23)","v":24.028333333333336},{"$f":"$U$23^2/AC23^2","v":0.15303773003217713},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678},{"$f":"($S$23/$P$23)*100","v":64.075555555555567},{"$f":"$S$23-$P$23","v":-53.886666666666656},null,{"$f":"((2*$N$19)/100)*$P$23","v":75},{"$f":"0.5*$L$19","v":0},{"$f":"IF(AI23>AJ23, AI23, AJ23)","v":75},{"$f":"IF($S$23 > $P$23,ABS((($S$23 - ($P$23 + $AK$23)) * (SQRT(6)/$U$23))),ABS((($S$23 - ($P$23 - $AK$23)) * (SQRT(6)/$U$23))))","v":5.5018598559134944},{"$f":"_xlfn.T.INV(0.95, (6 - 1))","v":2.0150483733330233}]

{"sheet":"Results_1","index":8,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,5,1,7],[1,9,1,17]]}
[]
[null,"Summary Information",null,null,null,"Colour Key",null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,null,"Mandatory Data Entry"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments",null,null,null,null,"Optional Text Entry"]
["Lab","ASB",null,null,null,null,"Ready Data"]
["Date","2017-09-06",null,null,null,null,"Corrected Data"]
["Sample Stability","N/A",null,null,null,null,"Determinand Name"]
["MDL/LOQ Test Matrix Type","Not Required",null,null,null,null,"No Entry Required"]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 1&2 (6 reps) within batch"]
["Blank Correction","Not Required"]
["Recovery Correction","Not Required"]
["P% Assessment - Marine Methods","Not Required"]
["Validation Task","Preliminary Stage 1&2"]
[]
[null,"Matrix",null,null,"Replicate",null,null,null,null,null,null,"Targets"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date",1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD%","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery"]
["Determinand: Emamectin benzoate",null,null,null,null,null,null,null,null,null,"ng/l",null,null,25]
["Unspiked Sample","Cage Edge = Near-Field",null,null,52.3,46.96]
["Spiked Sample","Cage Edge = Near-Field",null,null,141.09,155.74,125.77,162.81,161.5,156.57,null,null,null,null,null,150,60,120]
["Unspiked Sample","Outside AZE = Far-Field",null,null,0,0]
["Spiked Sample","Outside AZE = Far-Field",null,null,90.17,111.06,99.44,96.48,83.01,96.52,null,null,null,null,null,150,60,120]

{"sheet":"Summary_1","index":9,"n_rows":56,"n_cols":43,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,5,1,11],[1,13,1,42],[2,5,5,11],[2,13,14,42],[6,5,6,11],[7,5,9,11],[10,5,10,11],[11,8,11,11],[12,8,12,11],[16,29,16,32],[16,33,16,37],[16,38,16,42],[26,1,26,3],[13,8,13,11],[14,8,14,11],[16,1,16,3],[16,6,16,8],[16,9,16,11],[16,12,16,18],[37,1,37,3],[53,1,53,3],[55,1,55,3],[16,19,16,21],[16,22,16,28]]}
[]
["Summary Information",null,null,null,null,"Statement of Suitability",null,null,null,null,null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,"Both matrices meet the required performance criteria. Assessment of the differences between the matrices has been added (cells B24:C56). There is a differential between the RSDs achieved for the two matrices however statistical analysis of the two sets of results shows them have equal variance (f-test) and no significant difference between the means (t-test).  Therefore it can be concluded that the Cage Edge Sediment and the Outide Edge Sediment can be treated as a single Marine Sediment Matrix.",null,null,null,null,null,null,null,"Assesment has been done using the raw ng/L values rather than converting to the final ng/kg units. Different sample masses are used for the two matrices, and although coverting to ng/Kg would not change the %bias, RSD or %recovery leaving the results in ng/L allows for easier comparison between the two sets of values. "]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments"]
["Lab","ASB"]
["Date","2017-09-06"]
["Sample Stability","N/A",null,null,null,"Further Action (if Required)"]
["MDL/LOQ Test Matrix Type","Not Required",null,null,null," Between-batch validation can commence using a single sediment which can be assumed to be representative of all Marine Sediment to be analysed using this methodology."]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 1&2 (6 reps) within batch",null,null,null,"Summary Authorisation"]
["Blank Correction","Not Required",null,null,null,"Work Completed By",null,null,"Redacted"]
["Recovery Correction","Not Required",null,null,null,"Work Completed Date",null,null,"2017-09-04"]
["P% Assessment - Marine Methods","Not Required",null,null,null,"Authorised By",null,null,"Redacted"]
["Validation Task","Preliminary Stage 1&2",null,null,null,"Authorised Date",null,null,"2017-09-08"]
[]
["Assessment Type","Matrix",null,null,null,null,"MDL Assessment",null,null,"LOQ Assessment",null,null,"Precision Assessment",null,null,null,null,null,null,"P% Assessment",null,null,"Bias Assessment",null,null,null,null,null,null,"Recovery Assessment",null,null,null,"One Way ANOVA Assessment",null,null,null,null,"Unstable samples Assessment"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date","Units","Overall Assessment Satisfactory?","Observed MDL","Required MDL","Performance Within Target?","Observed LOQ","Required LOQ","Performance Within Target?","Observed Standard Deviation","Target Standard Deviation","Observed RSD%","Target RSD%","F-test Observed Std Dev vs Target Std Dev","F-Critical (0.05)","Performance Within Target?","Observed P%","Target P%","Performance Within Target?","Observed Absolute Bias","Target Absolute Bias","Observed Bias%","Target Bias%","T-test","T-Critical","Performance Within Target?","Min Acceptable Recovery","Max Acceptable Recovery","Recovery Achieved","Performance Within Target?","M0","M1","F-test M0 vs M1","F-Critical","Performance Within Target?","M0","Unstable M1","F-test M0 vs Unstable M1","F-Critical","Performance Within Target?"]
["Determinand: Emamectin benzoate",null,null,null,"ng/l",{"$f":"IF(OR(I19=\"No\",L19=\"No\",S19=\"No\",V19=\"No\",AC19=\"No\",AG19=\"No\",AL19=\"No\",AQ19=\"No\"),\"No\", \"Yes\")","v":"Yes"},null,null,{"$f":"IF(COUNTIF(I20:I21,\"No\"),\"No\",IF(COUNTIF(I20:I21,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,{"$f":"IF(COUNTIF(L20:L21,\"No\"),\"No\",IF(COUNTIF(L20:L21,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,{"$f":"MAX(O20:O21)","v":14.265321091699617},null,null,null,{"$f":"IF(COUNTIF(S20:S21,\"No\"),\"No\",IF(COUNTIF(S20:S21,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,{"$f":"IF(COUNTIF(V20:V21,\"No\"),\"No\",IF(COUNTIF(V20:V21,\"Yes\"),\"Yes\",\"\"))","v":""},{"$f":"IF(ABS(MAX(W20:W21))>ABS(MIN(W20:W21)),MAX(W20:W21),MIN(W20:W21))","v":-53.886666666666656},null,{"$f":"IF(ABS(MAX(Y20:Y21))>ABS(MIN(Y20:Y21)),MAX(Y20:Y21),MIN(Y20:Y21))","v":-35.92444444444444},null,null,null,{"$f":"IF(COUNTIF(AC20:AC21,\"No\"),\"No\",IF(COUNTIF(AC20:AC21,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,{"$f":"IF(COUNTIF(AG20:AG21,\"No\"),\"No\",IF(COUNTIF(AG20:AG21,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,null,{"$f":"IF(COUNTIF(AL20:AL21,\"No\"),\"No\",IF(COUNTIF(AL20:AL21,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,null,null,{"$f":"IF(COUNTIF(AQ20:AQ21,\"No\"),\"No\",IF(COUNTIF(AQ20:AQ21,\"Yes\"),\"Yes\",\"\"))","v":""}]
["Spiked Sample","Cage Edge = Near-Field",null,null,null,null,null,null,null,null,null,null,14.400841642070764,25.237500000000001,14.265321091699617,16.825000000000003,null,null,{"$f":"IF(M20<N20,\"Yes\",IF(Q20<R20, \"Yes\",\"No\"))","v":"Yes"},null,null,null,-49.05,75,-32.699999999999996,50,null,null,{"$f":"IF(ABS(W20)<X20, \"Yes\",IF(AA20<AB20,\"Yes\",\"No\"))","v":"Yes"},60,120,67.300000000000011,{"$f":"IF(AND(AF20>AD20,AF20<AE20), \"Yes\",\"No\")","v":"Yes"}]
["Spiked Sample","Outside AZE = Far-Field",null,null,null,null,null,null,null,null,null,null,9.3998929071913704,24.028333333333336,9.7800092673836811,16.018888888888892,null,null,{"$f":"IF(M21<N21,\"Yes\",IF(Q21<R21, \"Yes\",\"No\"))","v":"Yes"},null,null,null,-53.886666666666656,75,-35.92444444444444,50,null,null,{"$f":"IF(ABS(W21)<X21, \"Yes\",IF(AA21<AB21,\"Yes\",\"No\"))","v":"Yes"},60,120,64.075555555555567,{"$f":"IF(AND(AF21>AD21,AF21<AE21), \"Yes\",\"No\")","v":"Yes"}]
[]
[null,null,"Observed RSD%","Recovery Achieved %"]
[null,"Cage Edge",14.265321091699617,67.300000000000011]
[null,"Outside AZE",9.7800092673836811,64.075555555555567]
[null,"% difference in observed values ",{"$f":"100-(C25/C24*100)","v":31.442067062379323},{"$f":"100-(D25/D24*100)","v":4.791150734687136}]
[null,"Achieved recoveries are within 5% of each other indicating the differences between the matrices have little effect on method recovery. There is a  31% difference in achieved RSDs.\n\nThe two datasets are assessed for comparability below using F-test and T-test to compare variances and means respectively.  "]
[]
[null,"F-Test Two-Sample for Variances"]
[null,null,"Variable 1","Variable 2"]
[null,"Mean",100.95,96.113333333333344]
[null,"Variance",207.38423999999941,88.357986666666648]
[null,"Observations",6,6]
[null,"df",5,5]
[null,"F",2.3470910533799638]
[null,"P(F<=f) one-tail",0.1853581658724841]
[null,"F Critical one-tail",5.0503290576326485]
[null,"F-Test result is below the critical value showing that statistically the variances of the two sets of results  are not significantly different from each other."]
[]
[]
[null,"t-Test: Two-Sample Assuming Equal Variances"]
[null,null,"Variable 1","Variable 2"]
[null,"Mean",100.95,96.113333333333344]
[null,"Variance",207.38423999999941,88.357986666666648]
[null,"Observations",6,6]
[null,"Pooled Variance",147.87111333333303]
[null,"Hypothesized Mean Difference",0]
[null,"df",10]
[null,"t Stat",0.68891416372191461]
[null,"P(T<=t) one-tail",0.25327293678213791]
[null,"t Critical one-tail",1.812461122811676]
[null,"P(T<=t) two-tail",0.50654587356427583]
[null,"t Critical two-tail",2.2281388519862744]
[null,"T-Test result is below the critical value showing that statistically the means of the two sets of results  are not significantly different from each other."]
[]
[null,"Conclusion: The two data-sets are not satatistically different as demonstrated by the above F and T-tests.  Therefore it can be concluded that the Cage Edge Sediment and the Outide Edge Sediment can be treated as a single Marine Sediment Matrix.  Between-batch validation can commence using a single sediment which can be assumed to be representative of all Marine Sediment to be analysed using this methodology."]

{"sheet":"Validation_2","index":10,"n_rows":35,"n_cols":54,"rows_kept":35,"cut":false,"hidden":false,"merged":[[16,39,16,47],[16,48,16,53],[1,5,1,7],[1,9,1,17],[16,18,16,22],[16,24,16,25],[16,26,16,30],[16,31,16,38]]}
["Results calculated by Bowers, Sue at 07/10/2017 09:02:41"]
[null,"Summary Information",null,null,null,"Colour Key",null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,null,"Mandatory Data Entry",null,null,"1.  Validation test types: i. Process blank = reagent blank; ii Unspiked matrix = unspiked far-field sediment; iii PCS at 10% of range = spiked far-field sediment; iv PCS at 90% of range = spiked far-field sediment.\n2. MDL validation batches 1, 2 and 3 were prepared 15/09/17, 20/09/17 and 22/09/17 respectively following completion of validation of other test types.  This was due to initial MDL batches 1, 2 and 3 being spiked at levels too low to consistently detect.  Therefore the spike level used for MDL validation was raised from batch 4 onwards. \n3. All performance targets have been met with the exception of target MDL.  A written customer acceptance is to be sought.  Acceptance has ben accepted verbally.  Note that the target MDL is significantly lower than 10th of the proposed EQS's.\n4. A summary table of overall validation performance is presented below the validation data.\n"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments",null,null,null,null,"Optional Text Entry"]
["Lab","ASB",null,null,null,null,"Ready Data"]
["Date","11-22/09/17",null,null,null,null,"Corrected Data"]
["Sample Stability","Stable",null,null,null,null,"Determinand Name"]
["MDL/LOQ Test Matrix Type","Real sample matrix - naturally low or no determinand spiked to low level",null,null,null,null,"No Entry Required"]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 3 (6 by 4) between batch"]
["Blank Correction","Not Required"]
["Recovery Correction","Not Required"]
["P% Assessment - Marine Methods","Not Required"]
["Validation Task","New Method or Determinand Stage 3"]
[]
[null,"Matrix",null,null,"Batch",null,null,null,null,null,null,"Targets",null,null,null,null,null,null,"Summary Stats",null,null,null,null,"P% Assessment","Detection Limit Assessment",null,"Std Dev Assessment",null,null,null,null,"Bias Assessment",null,null,null,null,null,null,null,"ANOVA",null,null,null,null,null,null,null,null,"Unstable samples"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date",1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD%","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery","Mean","Bias%","Total Standard Deviation","RSD%","Observed Recovery Factor","Observed P%","Observed MDL","Observed LOQ","Target SD from MDL","Target SD from RSD","Target SD Value","F-test Observed Std Dev vs Target Std Dev","F-Critical","Recovery %","Absolute Uncorrected Bias","Absolute Corrected Bias","Absolute Bias from Target RSD","Absolute Bias from Target MDL","Target Absolute Bias Value","T-Test","T-Critical","M0","M1","F-test M0 vs M1","F-Critical","Sw (Within Batch Std Dev)","Sb (Between Batch Std Dev)","St (Total Std Dev)",null,null,"Constant of Slope (Mean Standard Conc vs Standard Sb Value)","Unstable Sb Value","Unstable M1","Unstable St (Total Std Dev)","F-test M0 vs Unstable M1","F-Critical"]
["Determinand: Emamectin benzoate",null,null,null,null,null,null,null,null,null,"ng/Kg",0.2,null,25]
["1st Process Blank - Ideal Matrix","Marine Sediment","Outside AZE = Far-Field",null,0,4.5312499999999999E-2,0,0,0,0]
["2nd Process Blank - Ideal Matrix","Marine Sediment","Outside AZE = Far-Field",null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E20:J21)","v":3.7760416666666667E-3},null,{"$f":"SQRT(AO21 + ((4 - 1)*AN21) / 4)","v":1.7303996764807209E-2},{"$f":"(U21/$S$21)*100","v":458.25756949558399},null,null,null,null,{"$f":"IF($L$19>Y21,($L$19/4),(Y21/4))","v":0.05},{"$f":"($S$21*$N$19)/100","v":9.4401041666666667E-4},{"$f":"IF(AB21>AA21,AB21,AA21)","v":0.05},{"$f":"$U$21^2/AC21^2","v":0.11977132161458331},{"$f":"FINV(0.05,ROUND((6*((6 - 1)*(AO21+(4 - 1)*AN21)^2))/(6 *(AO21)^2+(6 - 1)*(4 - 1)*(AN21)^2),0),10^10)","v":1.5292374666782338},null,null,null,null,null,null,null,null,{"$f":"Batch2M0($E$20:$E$21, $F$20:$F$21, $G$20:$G$21, $H$20:$H$21, $I$20:$I$21, $J$20:$J$21)","v":1.7110188802083333E-4},{"$f":"Batch2Rep6M1($E$20:$E$21, $F$20:$F$21, $G$20:$G$21, $H$20:$H$21, $I$20:$I$21, $J$20:$J$21)","v":1.7110188802083333E-4},{"$f":"IF(OR(AO21=0,AN21=0),0,IF(AO21>AN21,AO21/AN21,AN21/AO21))","v":1},{"$f":"FINV(0.025,6,5)","v":6.9777018585355677},{"$f":"SQRT(AN21)","v":1.3080592036327459E-2},{"$f":"IF(AO21>AN21,SQRT((AO21-AN21)/2),0)","v":0},{"$f":"SQRT((AO21+((4 - 1)*AN21))/2)","v":1.8498750661643793E-2}]
["1st PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,7.0271874999999993,6.176874999999999,10.178750000000001,7.5546875,8.1850000000000005,7.9996875000000003]
["2nd PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,10.264374999999999,5.9865624999999998,7.9225000000000003,7.92,7.0125000000000002,6.8149999999999995]
["3rd PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,10.2525,6.4990625,6.8650000000000002,6.6378124999999999,8.43,6.9159375000000001]
["4th PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,7.7946875000000002,7.2796875000000005,10.094687499999999,8.8909374999999997,7.5956250000000001,8.3525000000000009,null,null,null,null,null,10,50,130,{"$f":"AVERAGE(E22:J25)","v":7.8604817708333341},{"$f":"($S$25-$P$25)/$P$25*100","v":-21.395182291666657},{"$f":"SQRT((AO25 + ((4 - 1)*AN25)) / 4)","v":1.3109646971193054},{"$f":"(U25/$S$25)*100","v":16.677917910626014},null,null,null,null,{"$f":"IF($L$19>Y25,($L$19/4),(Y25/4))","v":0.05},{"$f":"($P$25*$N$19)/100","v":2.5},{"$f":"IF(AB25>AA25,AB25,AA25)","v":2.5},{"$f":"$U$25^2/AC25^2","v":0.27498054993489796},{"$f":"FINV(0.05,ROUND((6*((6 - 1)*(AO25+(4 - 1)*AN25)^2))/(6 *(AO25)^2+(6 - 1)*(4 - 1)*(AN25)^2),0),10^10)","v":1.6038499587107986},{"$f":"($S$25/$P$25)*100","v":78.604817708333343},{"$f":"$S$25-$P$25","v":-2.1395182291666659},null,{"$f":"((2*$N$19)/100)*$P$25","v":5},{"$f":"0.5*$L$19","v":0.1},{"$f":"IF(AI25>AJ25, AI25, AJ25)","v":5},{"$f":"IF($S$25 > $P$25,ABS((($S$25 - ($P$25 + $AK$25)) * (SQRT(6)/STDEV(AVERAGE($E$22:$E$25),AVERAGE($F$22:$F$25),AVERAGE($G$22:$G$25),AVERAGE($H$22:$H$25),AVERAGE($I$22:$I$25),AVERAGE($J$22:$J$25))))),ABS((($S$25 - ($P$25 - $AK$25)) * (SQRT(6)/STDEV(AVERAGE($E$22:$E$25),AVERAGE($F$22:$F$25),AVERAGE($G$22:$G$25),AVERAGE($H$22:$H$25),AVERAGE($I$22:$I$25),AVERAGE($J$22:$J$25))))))","v":8.0494431778496143},{"$f":"_xlfn.T.INV(0.95, (6 - 1))","v":2.0150483733330233},{"$f":"Batch2M0($E$22:$E$25, $F$22:$F$25, $G$22:$G$25, $H$22:$H$25, $I$22:$I$25, $J$22:$J$25)","v":1.2812363945855036},{"$f":"Batch4Rep6M1($E$22:$E$25, $F$22:$F$25, $G$22:$G$25, $H$22:$H$25, $I$22:$I$25, $J$22:$J$25)","v":3.0308045646159369},{"$f":"IF(OR(AO25=0,AN25=0),0,IF(AO25>AN25,AO25/AN25,AN25/AO25))","v":2.3655311208954855},{"$f":"FINV(0.025,5,18)","v":3.3819678058752425},{"$f":"SQRT(AN25)","v":1.1319171323844797},{"$f":"IF(AO25>AN25,SQRT((AO25-AN25)/4),0)","v":0.6613562145376789},{"$f":"SQRT((AO25+((4 - 1)*AN25))/4)","v":1.3109646971193054}]
["1st MDL","Marine Sediment","Outside AZE = Far-Field",null,1.4465624999999998,3.3750000000000002E-2,0.99125000000000008,1.6778124999999999,0.87843749999999998,0.76]
["2nd MDL","Marine Sediment","Outside AZE = Far-Field",null,1.5015624999999999,0.82281249999999995,0.59468750000000004,1.2825,0.99500000000000011,0.37343750000000003]
["3rd MDL","Marine Sediment","Outside AZE = Far-Field",null,1.5987499999999999,0.13312499999999999,0.47437499999999999,2.1303125000000001,1.1912499999999999,0.29843749999999997]
["4th MDL","Marine Sediment","Outside AZE = Far-Field",null,1.2071875000000001,0.27124999999999999,0.56312499999999999,1.5621874999999998,1.4815624999999999,0.93093749999999997,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E26:J29)","v":0.96667968749999977},null,{"$f":"SQRT((AO29 + ((4 - 1)*AN29)) / 4)","v":0.58407155390253762},{"$f":"(U29/$S$29)*100","v":60.420381379177137},null,null,{"$f":"(AR29*4.65)","v":1.3298567339494927},null,{"$f":"IF($L$19>Y29,($L$19/4),(Y29/4))","v":0.33246418348737317},{"$f":"($P$29*$N$19)/100","v":0},{"$f":"IF(AB29>AA29,AB29,AA29)","v":0.33246418348737317},{"$f":"$U$29^2/AC29^2","v":3.0863301375649841},{"$f":"FINV(0.05,ROUND((6*((6 - 1)*(AO29+(4 - 1)*AN29)^2))/(6 *(AO29)^2+(6 - 1)*(4 - 1)*(AN29)^2),0),10^10)","v":2.0095913850174001},null,null,null,null,null,null,null,null,{"$f":"Batch2M0($E$26:$E$29, $F$26:$F$29, $G$26:$G$29, $H$26:$H$29, $I$26:$I$29, $J$26:$J$29)","v":8.1790677897135469E-2},{"$f":"Batch4Rep6M1($E$26:$E$29, $F$26:$F$29, $G$26:$G$29, $H$26:$H$29, $I$26:$I$29, $J$26:$J$29)","v":1.1191862866210933},{"$f":"IF(OR(AO29=0,AN29=0),0,IF(AO29>AN29,AO29/AN29,AN29/AO29))","v":13.68354334987472},{"$f":"FINV(0.025,5,18)","v":3.3819678058752425},{"$f":"SQRT(AN29)","v":0.28599069547300915},{"$f":"IF(AO29>AN29,SQRT((AO29-AN29)/4),0)","v":0.50926309721104812},{"$f":"SQRT((AO29+((4 - 1)*AN29))/4)","v":0.58407155390253762}]
["1st Unspiked Sample = P Blk","Marine Sediment","Outside AZE = Far-Field",null,0,0,8.7812500000000016E-2,0,0,0]
["2nd Unspiked Sample = P Blk","Marine Sediment","Outside AZE = Far-Field",null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E30:J31)","v":7.3177083333333349E-3},null,{"$f":"SQRT(AO31 + ((4 - 1)*AN31) / 4)","v":3.3533952351109148E-2},{"$f":"(U31/$S$31)*100","v":458.25756949558399},null,null,null,null,{"$f":"IF($L$19>Y31,($L$19/4),(Y31/4))","v":0.05},{"$f":"($S$31*$N$19)/100","v":1.8294270833333337E-3},{"$f":"IF(AB31>AA31,AB31,AA31)","v":0.05},{"$f":"$U$31^2/AC31^2","v":0.44981038411458341},{"$f":"FINV(0.05,ROUND((6*((6 - 1)*(AO31+(4 - 1)*AN31)^2))/(6 *(AO31)^2+(6 - 1)*(4 - 1)*(AN31)^2),0),10^10)","v":1.5292374666782338},null,null,null,null,null,null,null,null,{"$f":"Batch2M0($E$30:$E$31, $F$30:$F$31, $G$30:$G$31, $H$30:$H$31, $I$30:$I$31, $J$30:$J$31)","v":6.4258626302083352E-4},{"$f":"Batch2Rep6M1($E$30:$E$31, $F$30:$F$31, $G$30:$G$31, $H$30:$H$31, $I$30:$I$31, $J$30:$J$31)","v":6.4258626302083374E-4},{"$f":"IF(OR(AO31=0,AN31=0),0,IF(AO31>AN31,AO31/AN31,AN31/AO31))","v":0.99999999999999967},{"$f":"FINV(0.025,5,6)","v":5.9875651260469276},{"$f":"SQRT(AN31)","v":2.5349285256607009E-2},{"$f":"IF(AO31>AN31,SQRT((AO31-AN31)/2),0)","v":0},{"$f":"SQRT((AO31+((4 - 1)*AN31))/2)","v":3.5849303006357976E-2}]
["1st PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,62.525624999999998,61.844999999999999,61.105312500000004,64.022812500000001,83.75,67.516249999999999]
["2nd PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,64.581562500000004,67.831249999999997,79.608437500000008,70.918125000000003,90.202500000000015,72.518437500000005]
["3rd PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,70.506249999999994,63.413125000000001,73.054374999999993,70.947812499999998,77.497812499999995,74.775000000000006]
["4th PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,62.392187499999999,67.203749999999999,59.671875,83.056249999999991,77.034687500000004,66.400625000000005,null,null,null,null,null,100,50,130,{"$f":"AVERAGE(E32:J35)","v":70.515794270833354},{"$f":"($S$35-$P$35)/$P$35*100","v":-29.484205729166646},{"$f":"SQRT((AO35 + ((4 - 1)*AN35)) / 4)","v":8.3362416539423325},{"$f":"(U35/$S$35)*100","v":11.821807780998586},null,null,null,null,{"$f":"IF($L$19>Y35,($L$19/4),(Y35/4))","v":0.05},{"$f":"($P$35*$N$19)/100","v":25},{"$f":"IF(AB35>AA35,AB35,AA35)","v":25},{"$f":"$U$35^2/AC35^2","v":0.11118867986067713},{"$f":"FINV(0.05,ROUND((6*((6 - 1)*(AO35+(4 - 1)*AN35)^2))/(6 *(AO35)^2+(6 - 1)*(4 - 1)*(AN35)^2),0),10^10)","v":1.720156328919094},{"$f":"($S$35/$P$35)*100","v":70.515794270833354},{"$f":"$S$35-$P$35","v":-29.484205729166646},null,{"$f":"((2*$N$19)/100)*$P$35","v":50},{"$f":"0.5*$L$19","v":0.1},{"$f":"IF(AI35>AJ35, AI35, AJ35)","v":50},{"$f":"IF($S$35 > $P$35,ABS((($S$35 - ($P$35 + $AK$35)) * (SQRT(6)/STDEV(AVERAGE($E$32:$E$35),AVERAGE($F$32:$F$35),AVERAGE($G$32:$G$35),AVERAGE($H$32:$H$35),AVERAGE($I$32:$I$35),AVERAGE($J$32:$J$35))))),ABS((($S$35 - ($P$35 - $AK$35)) * (SQRT(6)/STDEV(AVERAGE($E$32:$E$35),AVERAGE($F$32:$F$35),AVERAGE($G$32:$G$35),AVERAGE($H$32:$H$35),AVERAGE($I$32:$I$35),AVERAGE($J$32:$J$35))))))","v":7.899090199505248},{"$f":"_xlfn.T.INV(0.95, (6 - 1))","v":2.0150483733330233},{"$f":"Batch2M0($E$32:$E$35, $F$32:$F$35, $G$32:$G$35, $H$32:$H$35, $I$32:$I$35, $J$32:$J$35)","v":38.692192180718315},{"$f":"Batch4Rep6M1($E$32:$E$35, $F$32:$F$35, $G$32:$G$35, $H$32:$H$35, $I$32:$I$35, $J$32:$J$35)","v":161.89512310953785},{"$f":"IF(OR(AO35=0,AN35=0),0,IF(AO35>AN35,AO35/AN35,AN35/AO35))","v":4.1841806831047403},{"$f":"FINV(0.025,5,18)","v":3.3819678058752425},{"$f":"SQRT(AN35)","v":6.2203048302087511},{"$f":"IF(AO35>AN35,SQRT((AO35-AN35)/4),0)","v":5.5498407844013764},{"$f":"SQRT((AO35+((4 - 1)*AN35))/4)","v":8.3362416539423325}]

{"sheet":"Results_2","index":11,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,5,1,7],[1,9,1,17],[2,9,13,17]]}
[]
[null,"Summary Information",null,null,null,"Colour Key",null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,null,"Mandatory Data Entry",null,null,"1.  Validation test types: i. Process blank = reagent blank; ii Unspiked matrix = unspiked far-field sediment; iii PCS at 10% of range = spiked far-field sediment; iv PCS at 90% of range = spiked far-field sediment.\n2. MDL validation batches 1, 2 and 3 were prepared 15/09/17, 20/09/17 and 22/09/17 respectively following completion of validation of other test types.  This was due to initial MDL batches 1, 2 and 3 being spiked at levels too low to consistently detect.  Therefore the spike level used for MDL validation was raised from batch 4 onwards. \n3. All performance targets have been met with the exception of target MDL.  A written customer acceptance is to be sought.  Acceptance has ben accepted verbally.  Note that the target MDL is significantly lower than 10th of the proposed EQS's.\n4. A summary table of overall validation performance is presented below the validation data.\n"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments",null,null,null,null,"Optional Text Entry"]
["Lab","ASB",null,null,null,null,"Ready Data"]
["Date","11-22/09/17",null,null,null,null,"Corrected Data"]
["Sample Stability","Stable",null,null,null,null,"Determinand Name"]
["MDL/LOQ Test Matrix Type","Real sample matrix - naturally low or no determinand spiked to low level",null,null,null,null,"No Entry Required"]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 3 (6 by 4) between batch"]
["Blank Correction","Not Required"]
["Recovery Correction","Not Required"]
["P% Assessment - Marine Methods","Not Required"]
["Validation Task","New Method or Determinand Stage 3"]
[]
[null,"Matrix",null,null,"Batch",null,null,null,null,null,null,"Targets"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date",1,2,3,4,5,6,"Units","Required MDL","Required LOQ","Required RSD%","Required P%","Expected Conc","Min Acceptable Recovery","Max Acceptable Recovery"]
["Determinand: Emamectin benzoate",null,null,null,null,null,null,null,null,null,"ng/Kg",0.2,null,25]
["1st Process Blank - Ideal Matrix","Marine Sediment","Outside AZE = Far-Field",null,0,{"$f":"0.145/4*1.25","v":4.5312499999999999E-2},0,0,0,0]
["2nd Process Blank - Ideal Matrix","Marine Sediment","Outside AZE = Far-Field",null,0,0,0,0,0,0]
["1st PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"22.487/4*1.25","v":7.0271874999999993},{"$f":"19.766/4*1.25","v":6.176874999999999},{"$f":"32.572/4*1.25","v":10.178750000000001},{"$f":"24.175/4*1.25","v":7.5546875},{"$f":"26.192/4*1.25","v":8.1850000000000005},{"$f":"25.599/4*1.25","v":7.9996875000000003}]
["2nd PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"32.846/4*1.25","v":10.264374999999999},{"$f":"19.157/4*1.25","v":5.9865624999999998},{"$f":"25.352/4*1.25","v":7.9225000000000003},{"$f":"25.344/4*1.25","v":7.92},{"$f":"22.44/4*1.25","v":7.0125000000000002},{"$f":"21.808/4*1.25","v":6.8149999999999995}]
["3rd PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"32.808/4*1.25","v":10.2525},{"$f":"20.797/4*1.25","v":6.4990625},{"$f":"21.968/4*1.25","v":6.8650000000000002},{"$f":"21.241/4*1.25","v":6.6378124999999999},{"$f":"26.976/4*1.25","v":8.43},{"$f":"22.131/4*1.25","v":6.9159375000000001}]
["4th PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"24.943/4*1.25","v":7.7946875000000002},{"$f":"23.295/4*1.25","v":7.2796875000000005},{"$f":"32.303/4*1.25","v":10.094687499999999},{"$f":"28.451/4*1.25","v":8.8909374999999997},{"$f":"24.306/4*1.25","v":7.5956250000000001},{"$f":"26.728/4*1.25","v":8.3525000000000009},null,null,null,null,null,10,50,130]
["1st MDL","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"4.629/4*1.25","v":1.4465624999999998},{"$f":"0.108/4*1.25","v":3.3750000000000002E-2},{"$f":"3.172/4*1.25","v":0.99125000000000008},{"$f":"5.369/4*1.25","v":1.6778124999999999},{"$f":"2.811/4*1.25","v":0.87843749999999998},{"$f":"2.432/4*1.25","v":0.76}]
["2nd MDL","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"4.805/4*1.25","v":1.5015624999999999},{"$f":"2.633/4*1.25","v":0.82281249999999995},{"$f":"1.903/4*1.25","v":0.59468750000000004},{"$f":"4.104/4*1.25","v":1.2825},{"$f":"3.184/4*1.25","v":0.99500000000000011},{"$f":"1.195/4*1.25","v":0.37343750000000003}]
["3rd MDL","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"5.116/4*1.25","v":1.5987499999999999},{"$f":"0.426/4*1.25","v":0.13312499999999999},{"$f":"1.518/4*1.25","v":0.47437499999999999},{"$f":"6.817/4*1.25","v":2.1303125000000001},{"$f":"3.812/4*1.25","v":1.1912499999999999},{"$f":"0.955/4*1.25","v":0.29843749999999997}]
["4th MDL","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"3.863/4*1.25","v":1.2071875000000001},{"$f":"0.868/4*1.25","v":0.27124999999999999},{"$f":"1.802/4*1.25","v":0.56312499999999999},{"$f":"4.999/4*1.25","v":1.5621874999999998},{"$f":"4.741/4*1.25","v":1.4815624999999999},{"$f":"2.979/4*1.25","v":0.93093749999999997}]
["1st Unspiked Sample = P Blk","Marine Sediment","Outside AZE = Far-Field",null,0,0,{"$f":"0.281/4*1.25","v":8.7812500000000016E-2},0,0,0]
["2nd Unspiked Sample = P Blk","Marine Sediment","Outside AZE = Far-Field",null,0,0,0,0,0,0]
["1st PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"200.082/4*1.25","v":62.525624999999998},{"$f":"197.904/4*1.25","v":61.844999999999999},{"$f":"195.537/4*1.25","v":61.105312500000004},{"$f":"204.873/4*1.25","v":64.022812500000001},{"$f":"268/4*1.25","v":83.75},{"$f":"216.052/4*1.25","v":67.516249999999999}]
["2nd PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"206.661/4*1.25","v":64.581562500000004},{"$f":"217.06/4*1.25","v":67.831249999999997},{"$f":"254.747/4*1.25","v":79.608437500000008},{"$f":"226.938/4*1.25","v":70.918125000000003},{"$f":"288.648/4*1.25","v":90.202500000000015},{"$f":"232.059/4*1.25","v":72.518437500000005}]
["3rd PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"225.62/4*1.25","v":70.506249999999994},{"$f":"202.922/4*1.25","v":63.413125000000001},{"$f":"233.774/4*1.25","v":73.054374999999993},{"$f":"227.033/4*1.25","v":70.947812499999998},{"$f":"247.993/4*1.25","v":77.497812499999995},{"$f":"239.28/4*1.25","v":74.775000000000006}]
["4th PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,{"$f":"199.655/4*1.25","v":62.392187499999999},{"$f":"215.052/4*1.25","v":67.203749999999999},{"$f":"190.95/4*1.25","v":59.671875},{"$f":"265.78/4*1.25","v":83.056249999999991},{"$f":"246.511/4*1.25","v":77.034687500000004},{"$f":"212.482/4*1.25","v":66.400625000000005},null,null,null,null,null,100,50,130]

{"sheet":"Summary_2","index":12,"n_rows":27,"n_cols":43,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,12,16,18],[1,0,1,3],[1,5,1,11],[1,13,1,42],[2,5,5,11],[2,13,14,42],[6,5,6,11],[7,5,9,11],[10,5,10,11],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,1,16,3],[16,6,16,8],[16,9,16,11],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,5],[24,6,25,7],[16,19,16,21],[16,22,16,28],[16,29,16,32],[16,33,16,37],[16,38,16,42],[26,14,26,15],[24,8,24,11],[24,12,24,15],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13]]}
[]
["Summary Information",null,null,null,null,"Statement of Suitability",null,null,null,null,null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,"All performance targets have been met with the exception of target MDL.  Note that the target MDL is significantly lower than 10th of the proposed EQS's.",null,null,null,null,null,null,null,"1.  Validation test types: i. Process blank = reagent blank; ii Unspiked matrix = unspiked far-field sediment; iii PCS at 10% of range = spiked far-field sediment; iv PCS at 90% of range = spiked far-field sediment.\n2. MDL validation batches 1, 2 and 3 were prepared 15/09/17, 20/09/17 and 22/09/17 respectively following completion of validation of other test types.  This was due to initial MDL batches 1, 2 and 3 being spiked at levels too low to consistently detect.  Therefore the spike level used for MDL validation was raised from batch 4 onwards. \n3. All results have been reported as equiavent to a 20 g sample dry-weight and a 40 ml ACN extract solvent volume.\n4. All performance targets have been met with the exception of target MDL.  A written customer acceptance is to be sought.  Acceptance has been accepted verbally.  Note that the target MDL is significantly lower than 10th of the proposed EQS's.\n5. It has not been possible to assess bias since there is no available CRM or external PT.\n6. A summary table of overall validation performance is presented below the validation data.\n7. Spiking standard purchased from AccuStandard - Lot No. 217071276: date Jul 20 2017; expiry Aug 20 2018"]
["Procedure","ES-TORG-P-216 Determination of emamectin benzoate in FF sediments"]
["Lab","ASB"]
["Date","11-22/09/17"]
["Sample Stability","Stable",null,null,null,"Further Action (if Required)"]
["MDL/LOQ Test Matrix Type","Real sample matrix - naturally low or no determinand spiked to low level",null,null,null,"A written customer acceptance is to be sought.  Acceptance has been accepted verbally.  "]
["LOQ Assessment - QC Level","Not Required"]
["Number of Unspiked Replicates",2]
["Stage","Stage 3 (6 by 4) between batch",null,null,null,"Summary Authorisation"]
["Blank Correction","Not Required",null,null,null,"Work Completed By",null,null,"Redacted"]
["Recovery Correction","Not Required",null,null,null,"Work Completed Date",null,null,"2017-09-22"]
["P% Assessment - Marine Methods","Not Required",null,null,null,"Authorised By",null,null,"Redacted"]
["Validation Task","New Method or Determinand Stage 3",null,null,null,"Authorised Date",null,null,"2017-10-07"]
[]
["Assessment Type","Matrix",null,null,null,null,"MDL Assessment",null,null,"LOQ Assessment",null,null,"Precision Assessment",null,null,null,null,null,null,"P% Assessment",null,null,"Bias Assessment",null,null,null,null,null,null,"Recovery Assessment",null,null,null,"One Way ANOVA Assessment",null,null,null,null,"Unstable samples Assessment"]
["Determinands and Test Types","UKAS Matrix","SEPA Matrix Type","SEPA Matrix Site and Date","Units","Overall Assessment Satisfactory?","Observed MDL","Required MDL","Performance Within Target?","Observed LOQ","Required LOQ","Performance Within Target?","Observed Standard Deviation","Target Standard Deviation","Observed RSD%","Target RSD%","F-test Observed Std Dev vs Target Std Dev","F-Critical (0.05)","Performance Within Target?","Observed P%","Target P%","Performance Within Target?","Observed Absolute Bias","Target Absolute Bias","Observed Bias%","Target Bias%","T-test","T-Critical","Performance Within Target?","Min Acceptable Recovery","Max Acceptable Recovery","Recovery Achieved","Performance Within Target?","M0","M1","F-test M0 vs M1","F-Critical","Performance Within Target?","M0","Unstable M1","F-test M0 vs Unstable M1","F-Critical","Performance Within Target?"]
["Determinand: Emamectin benzoate",null,null,null,"ng/Kg",{"$f":"IF(OR(I19=\"No\",L19=\"No\",S19=\"No\",V19=\"No\",AC19=\"No\",AG19=\"No\",AL19=\"No\",AQ19=\"No\"),\"No\", \"Yes\")","v":"No"},null,null,{"$f":"IF(COUNTIF(I20:I22,\"No\"),\"No\",IF(COUNTIF(I20:I22,\"Yes\"),\"Yes\",\"\"))","v":"No"},null,null,{"$f":"IF(COUNTIF(L20:L22,\"No\"),\"No\",IF(COUNTIF(L20:L22,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,{"$f":"MAX(O20:O22)","v":16.677917910626014},null,null,null,{"$f":"IF(COUNTIF(S20:S22,\"No\"),\"No\",IF(COUNTIF(S20:S22,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,{"$f":"IF(COUNTIF(V20:V22,\"No\"),\"No\",IF(COUNTIF(V20:V22,\"Yes\"),\"Yes\",\"\"))","v":""},{"$f":"IF(ABS(MAX(W20:W22))>ABS(MIN(W20:W22)),MAX(W20:W22),MIN(W20:W22))","v":-29.484205729166646},null,{"$f":"IF(ABS(MAX(Y20:Y22))>ABS(MIN(Y20:Y22)),MAX(Y20:Y22),MIN(Y20:Y22))","v":-29.484205729166646},null,null,null,{"$f":"IF(COUNTIF(AC20:AC22,\"No\"),\"No\",IF(COUNTIF(AC20:AC22,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,{"$f":"IF(COUNTIF(AG20:AG22,\"No\"),\"No\",IF(COUNTIF(AG20:AG22,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,null,{"$f":"IF(COUNTIF(AL20:AL22,\"No\"),\"No\",IF(COUNTIF(AL20:AL22,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,null,{"$f":"IF(COUNTIF(AQ20:AQ22,\"No\"),\"No\",IF(COUNTIF(AQ20:AQ22,\"Yes\"),\"Yes\",\"\"))","v":""}]
[" PCS at 10% Method Range","Marine Sediment","Outside AZE = Far-Field",null,null,null,null,null,null,null,null,null,1.3109646971193054,2.5,16.677917910626014,25,null,null,{"$f":"IF(M20<N20,\"Yes\",IF(Q20<R20, \"Yes\",\"No\"))","v":"Yes"},null,null,null,-2.1395182291666659,5,-21.395182291666657,50,null,null,{"$f":"IF(ABS(W20)<X20, \"Yes\",IF(AA20<AB20,\"Yes\",\"No\"))","v":"Yes"},50,130,78.604817708333343,{"$f":"IF(AND(AF20>AD20,AF20<AE20), \"Yes\",\"No\")","v":"Yes"},1.2812363945855036,3.0308045646159369,null,null,{"$f":"IF(AI20>=AH20,\"Yes\",IF(AJ20<AK20,\"Yes\",\"No\"))","v":"Yes"}]
[" MDL","Marine Sediment","Outside AZE = Far-Field",null,null,null,1.3298567339494927,0.2,{"$f":"IF(G21<H21,\"Yes\",\"No\")","v":"No"}]
[" PCS at 90% Method Range","Marine Sediment","Outside AZE = Far-Field",null,null,null,null,null,null,null,null,null,8.3362416539423325,25,11.821807780998586,25,null,null,{"$f":"IF(M22<N22,\"Yes\",IF(Q22<R22, \"Yes\",\"No\"))","v":"Yes"},null,null,null,-29.484205729166646,50,-29.484205729166646,50,null,null,{"$f":"IF(ABS(W22)<X22, \"Yes\",IF(AA22<AB22,\"Yes\",\"No\"))","v":"Yes"},50,130,70.515794270833354,{"$f":"IF(AND(AF22>AD22,AF22<AE22), \"Yes\",\"No\")","v":"Yes"},38.692192180718315,161.89512310953785,null,null,{"$f":"IF(AI22>=AH22,\"Yes\",IF(AJ22<AK22,\"Yes\",\"No\"))","v":"Yes"}]
[]
[null,"Summary of Performance:"]
[null,"Determinand","Target RSD%","Achieved RSD%","Target Recovery %",null,"Achieved Recovery %",null,"Near-Field Samples",null,null,null,"Far-Field Samples"]
[null,null,null,null,null,null,null,null,"Target MDL ng/Kg dry-weight",null,"Achieved MDL ng/Kg dry-weight",null,"Target MDL ng/Kg dry-weight",null,"Achieved MDL ng/Kg dry-weight"]
[null,"Emamectin Benzoate",25,16.8,"50 - 130",null,{"$f":"((100+Y20)+(100+Y22))/2","v":74.560305989583355},null,2,null,{"$f":"G21*10*100/G27","v":17.835988148107706},null,0.2,null,{"$f":"G21*100/G27","v":1.7835988148107704}]