{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Start","Determinand Names","Log","Help","Test data to delete","ValidationTemplate_0","SummaryTemplate_0","Validation_1","Results_1","Summary_1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"Start","index":0,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
["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","2017-11-01"]
[]
["Personnel Overview"]
["Work Completed By","Redacted"]
["Work Completed Date","2017-11-01"]
["Authorised By","Redacted"]
["Authorised Date","2017-11-01"]
[]
["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":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Action Taken","Sheet Group","Completed By","Date/Time"]
["Validation sheets created","Validation_1","Redacted","2017-11-02T10:10:54"]
["Results submitted","Validation_1","Redacted","2017-11-02T10:14:50"]
["Results calculated","Validation_1","Redacted","2017-11-02T10:15:33"]
["Results re-submitted - additional notes","Validation_1","Redacted","2017-11-02T12:01:29"]
["Results calculated","Validation_1","Redacted","2017-11-02T12:01:33"]

{"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":[[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],[2,13,14,42],[1,5,1,11],[6,5,6,11],[10,5,10,11],[7,5,9,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":21,"n_cols":54,"rows_kept":21,"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 Elliott, Janine at 02/11/2017 12:01:33"]
[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. Unspiked matrix = unspiked Far field sediment, ii. PCS at 90% range = spiked far field sample"]
["Procedure","ES-TORG-P-216 Determination of Emamectin Benzoate in FF sediments",null,null,null,null,"Optional Text Entry",null,null,"2. Purpose of mini validation: To provide within batch data to assess impact on change to injection volume from 2000ul to 400ul, "]
["Lab","ASB Instrument lab",null,null,null,null,"Ready Data",null,null,"This change has been put in place to resolve interference issues indentified."]
["Date","2017-10-31",null,null,null,null,"Corrected Data",null,null,"3. All performance targets hve been met a summary of the performance comparison with the orginal validation data is included on "]
["Sample Stability","N/A",null,null,null,null,"Determinand Name",null,null,"the summary tab."]
["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/Kg",0.2,null,25]
["Unspiked Sample = Unspiked PCS","Marine SEdiment","Outside AZE = Far field",null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(E20:F20)","v":0},null,{"$f":"STDEV(E20:F20)","v":0},0,null,null,null,null,{"$f":"IF($L$19>Y20,($L$19/4),(Y20/4))","v":0.05},{"$f":"($S$20*$N$19)/100","v":0},{"$f":"IF(AB20>AA20,AB20,AA20)","v":0.05},{"$f":"$U$20^2/AC20^2","v":0},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678}]
["Spiked Sample = PCS at 90% range","Marine SEdiment","Outside AZE = Far field",null,63.284999999999997,66.480625000000003,71.558750000000003,62.403750000000002,66.113124999999997,68.354375000000005,null,null,null,null,null,100,50,130,{"$f":"AVERAGE(E21:J21)","v":66.365937499999987},{"$f":"($S$21-$P$21)/$P$21*100","v":-33.634062500000013},{"$f":"STDEV(E21:J21)","v":3.3522338342793914},{"$f":"(U21/$S$21)*100","v":5.0511361107185317},null,null,null,null,{"$f":"IF($L$19>Y21,($L$19/4),(Y21/4))","v":0.05},{"$f":"($S$21*$N$19)/100","v":16.591484374999997},{"$f":"IF(AB21>AA21,AB21,AA21)","v":16.591484374999997},{"$f":"$U$21^2/AC21^2","v":4.0822361614407589E-2},{"$f":"FINV(0.05,5,10^10)","v":2.2140995728034678},{"$f":"($S$21/$P$21)*100","v":66.365937499999987},{"$f":"$S$21-$P$21","v":-33.634062500000013},null,{"$f":"((2*$N$19)/100)*$P$21","v":50},{"$f":"0.5*$L$19","v":0.1},{"$f":"IF(AI21>AJ21, AI21, AJ21)","v":50},{"$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":11.958651460212961},{"$f":"_xlfn.T.INV(0.95, (6 - 1))","v":2.0150483733330233}]

{"sheet":"Results_1","index":8,"n_rows":21,"n_cols":18,"rows_kept":21,"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",null,null,"1. Validation test types: i. Unspiked matrix = unspiked Far field sediment, ii. PCS at 90% range = spiked far field sample"]
["Procedure","ES-TORG-P-216 Determination of Emamectin Benzoate in FF sediments",null,null,null,null,"Optional Text Entry",null,null,"2. Purpose of mini validation: To provide within batch data to assess impact on change to injection volume from 2000ul to 400ul, "]
["Lab","ASB Instrument lab",null,null,null,null,"Ready Data",null,null,"This change has been put in place to resolve interference issues indentified."]
["Date","2017-10-31",null,null,null,null,"Corrected Data",null,null,"3. All performance targets hve been met a summary of the performance comparison with the orginal validation data is included on "]
["Sample Stability","N/A",null,null,null,null,"Determinand Name",null,null,"the summary tab."]
["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/Kg",0.2,null,25]
["Unspiked Sample = Unspiked PCS","Marine SEdiment","Outside AZE = Far field",null,0,0]
["Spiked Sample = PCS at 90% range","Marine SEdiment","Outside AZE = Far field",null,{"$f":"202.512/4*1.25","v":63.284999999999997},{"$f":"212.738/4*1.25","v":66.480625000000003},{"$f":"228.988/4*1.25","v":71.558750000000003},{"$f":"199.692/4*1.25","v":62.403750000000002},{"$f":"211.562/4*1.25","v":66.113124999999997},{"$f":"218.734/4*1.25","v":68.354375000000005},null,null,null,null,null,100,50,130]

{"sheet":"Summary_1","index":9,"n_rows":61,"n_cols":43,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,2,60,5],[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,38,16,42],[20,4,20,5],[13,8,13,11],[14,8,14,11],[16,1,16,3],[57,2,57,5],[16,19,16,21],[23,4,23,5],[38,2,38,5],[24,2,26,5],[16,22,16,28],[16,29,16,32],[16,33,16,37],[21,4,21,5],[22,4,22,5],[16,6,16,8],[16,9,16,11],[16,12,16,18]]}
[]
["Summary Information",null,null,null,null,"Statement of Suitability",null,null,null,null,null,null,null,"Notes"]
["Instrument","Orbitrap LC-HRAM",null,null,null,"The two data-sets are  statistically different as demonstrated by the above F-test.  This is due to the improved variance from the mini-validation.  Therefore performance can be assessed as showing no deterioration.\nThere is no statistical difference between means as demonstrated by the above T-test.  Therefore it is concluded that there has been no change to method recovery with the change in injection volume.\nTherefore it can be concluded performance from the previous full validation has been maintained and can continue to be quoted with confidence.",null,null,null,null,null,null,null,"1. Validation test types: i. unspiked matrix = unspiked far field sediment, ii. PCS at 90% range = spiked far field sample. \n2 Purpose of mini validation : To provide within batch data to assess the impact on change to injection volume from 2000ul to 400ul. This change has been put in place to resolve interference issues identified in CAPA 17/822. \n3 All performance targets have been met (MDL is to be reassessed). \nA summary of the performance comparison with the original validation data is included below."]
["Procedure","ES-TORG-P-216 Determination of Emamectin Benzoate in FF sediments"]
["Lab","ASB Instrument lab"]
["Date","2017-10-31"]
["Sample Stability","N/A",null,null,null,"Further Action (if Required)"]
["MDL/LOQ Test Matrix Type","Not Required",null,null,null,"No further action required to assess method performance RSD and Recovery.\nFurther validation to be carried out to assess method detection limit."]
["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-11-01"]
["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-11-01"]
[]
["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":"Yes"},null,null,{"$f":"IF(COUNTIF(I20:I20,\"No\"),\"No\",IF(COUNTIF(I20:I20,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,{"$f":"IF(COUNTIF(L20:L20,\"No\"),\"No\",IF(COUNTIF(L20:L20,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,{"$f":"MAX(O20:O20)","v":5.0511361107185317},null,null,null,{"$f":"IF(COUNTIF(S20:S20,\"No\"),\"No\",IF(COUNTIF(S20:S20,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,{"$f":"IF(COUNTIF(V20:V20,\"No\"),\"No\",IF(COUNTIF(V20:V20,\"Yes\"),\"Yes\",\"\"))","v":""},{"$f":"IF(ABS(MAX(W20:W20))>ABS(MIN(W20:W20)),MAX(W20:W20),MIN(W20:W20))","v":-33.634062500000013},null,{"$f":"IF(ABS(MAX(Y20:Y20))>ABS(MIN(Y20:Y20)),MAX(Y20:Y20),MIN(Y20:Y20))","v":-33.634062500000013},null,null,null,{"$f":"IF(COUNTIF(AC20:AC20,\"No\"),\"No\",IF(COUNTIF(AC20:AC20,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,{"$f":"IF(COUNTIF(AG20:AG20,\"No\"),\"No\",IF(COUNTIF(AG20:AG20,\"Yes\"),\"Yes\",\"\"))","v":"Yes"},null,null,null,null,{"$f":"IF(COUNTIF(AL20:AL20,\"No\"),\"No\",IF(COUNTIF(AL20:AL20,\"Yes\"),\"Yes\",\"\"))","v":""},null,null,null,null,{"$f":"IF(COUNTIF(AQ20:AQ20,\"No\"),\"No\",IF(COUNTIF(AQ20:AQ20,\"Yes\"),\"Yes\",\"\"))","v":""}]
["Spiked Sample = PCS at 90% range","Marine SEdiment","Outside AZE = Far field",null,null,null,null,null,null,null,null,null,3.3522338342793914,16.591484374999997,5.0511361107185317,16.591484374999997,null,null,{"$f":"IF(M20<N20,\"Yes\",IF(Q20<R20, \"Yes\",\"No\"))","v":"Yes"},null,null,null,-33.634062500000013,50,-33.634062500000013,50,null,null,{"$f":"IF(ABS(W20)<X20, \"Yes\",IF(AA20<AB20,\"Yes\",\"No\"))","v":"Yes"},50,130,66.365937499999987,{"$f":"IF(AND(AF20>AD20,AF20<AE20), \"Yes\",\"No\")","v":"Yes"}]
[null,null,null,"Observed RSD%","Recovery Achieved %"]
[null,null,"Validation data 11-22/09/17",11.821999999999999,70.516000000000005]
[null,null,"Mini validation 01/11/17",5.0510000000000002,66.366]
[null,null,"% difference in observed values ",{"$f":"(D23/D22*100)-100","v":-57.274572830316359},{"$f":"(E23/E22*100)-100","v":-5.8851891769243849}]
[null,null,"The precision of the mini validation data is is much lower than the original validation data, showing an improvement in precision, therefore improvement in method performance. It should be noted that the mini-validation performance is from within-batch data and the full validation performance is from between-batch data.  Therefore it would be expected that performance from within-batch data would be tighter than for between-batch data.\nThe achieved recoveries are within 6% of of each other indicating that the methodology differences to the injection volume have had little effect on the method recovery.  The two data sets are assessed for comparibility below using F-test and T-test to compare variances and means respectively.     "]
[]
[]
[null,null,"F-Test Two-Sample for Variances"]
[]
[null,null,null,"Variable 1","Variable 2"]
[null,null,"Mean",70.515794270833354,66.365937499999987]
[null,null,"Variance",65.475438034806643,11.237471679687511]
[null,null,"Observations",24,6]
[null,null,"df",23,5]
[null,null,"F",5.8265275233714648]
[null,null,"P(F<=f) one-tail",2.9488879349588722E-2]
[null,null,"F Critical one-tail",4.5339263572725539]
[]
[null,null,"F-Test resut is above the critical value showing that statistically the variances of the two data sets are significantly different from each other."]
[]
[]
[]
[null,null,"t-Test: Two-Sample Assuming Unequal Variances"]
[]
[null,null,null,"Variable 1","Variable 2"]
[null,null,"Mean",70.515794270833354,66.365937499999987]
[null,null,"Variance",65.475438034806643,11.237471679687511]
[null,null,"Observations",24,6]
[null,null,"Hypothesized Mean Difference",0]
[null,null,"df",21]
[null,null,"t Stat",1.934658812331894]
[null,null,"P(T<=t) one-tail",3.3308861281099132E-2]
[null,null,"t Critical one-tail",1.7207429028118781]
[null,null,"P(T<=t) two-tail",6.6617722562198264E-2]
[null,null,"t Critical two-tail",2.07961384472768]
[]
[]
[null,null,"T-Test (two tailed) result is below the critical value showing that staistically the means of the two sets of data are not significantly different from each other. "]
[]
[]
[null,null,"Conclusion: \nThe two data-sets are  statistically different as demonstrated by the above F-test.  This is due to the improved variance from the mini-validation.  Therefore performance can be assessed as showing no deterioration.\nThere is no statistical difference between means as demonstrated by the above T-test.  Therefore it is concluded that there has been no change to method recovery with the change in injection volume.\nTherefore it can be concluded performance from the previous full validation has been maintained and can continue to be quoted with confidence.\n"]