I have been a volunteer ISO17025 technical assessor for a national accreditation authority for over 30 years. I use Microsoft Excel and Apple Numbers on an iPad, and developed these tools to help me - Both Apple and Microsoft versions can be downloaded.
These spreadsheets use only "Cell Functions" (No code, macros, or hyperlinks) - They should be “Safe” to distribute...
ISO/IEC 17025:2017 requires Measurement Uncertainty (MU) of chemical test results to be available - For new methods or for "novel" analytes and matrices, MUs may be determined with sample blanks, spikes, and comparisons with reference materials. Matrix Spikes establish MUs and recoveries at different concentrations. "Low Level Spikes" determine Method Detection Limits. Horwitz Ratios (HorRat) can be an initial assessment criteria, and Grubbs' test helps check for outliers. These are in the first two spreadsheets below:-
The 'Single Analyte Report' is for one analyte, and includes a printable "Summary Report" that can be sent to a customer or archived. Concentrations range from parts-per-trillion to 10%.
The 'Multiple Analytes MU' spreadsheet can be used within the laboratory for up to 24 analytes and 32 results in a test.
The 'Sample Extraction' spreadsheet can be used for different analytes in aqueous and solid materials like food or environmental samples. Several important published methods are included that can be modified for new analytes or to improve performance. Likely efficiencies can be compared using different solvents and amounts for similar matrices.
A particular aim is to help reduce the use of chlorinated solvents by some older methods ("Green Chemistry").
This spreadsheet can print reports for Recoveries, Relative Standard Deviations (RSD), Bias, Method Detection Limits (MDL), Practical Quantitation limits (PLQ), and Results "Corrected for Recovery" for a single analyte within a Test. It has a statement of satisfactory performance.
This spreadsheet may be useful to assist Laboratory Analysts and Assessors to investigate Recoveries, Relative Standard Deviations (RSD), Bias, Method Detection Limits (MDL), Practical Quantitation limits (PLQ), and Results "Corrected for Recovery" for a number of analytes within a Test.
This spreadsheet indicates likely extraction efficiencies for a range of analytes, based on the standard "aqueous" USEPA Methods 3510 and 3511. Relative performances for environmental and foods methods like USEPA 3540, ISO 16703, and QuEChERS can be inferred for different solvents. Solvent densities ρ, boiling points, water miscibilities/solubilities, and LogP partition coefficients for a range of solvents including: dichloromethane, n-octanol (LogKow), hexane, pentane, toluene, carbon disulfide, ether, ethyl acetate, acetone, acetonitrile, and methanol are shown. "Fine Tuning" is possible by using mixed solvents with different polarities and different solvent/matrix amounts for extraction. Detailed Notes are in the last sheet.
This is a simple one-page tabbed site constructed with standard non-commercial elements:-
[ timstrutt.com ] is currently hosted by CloudFlare - Published at https://github.com/timstrutt [20221203].
I'm retired, a Chartered Chemist, and interested in chromatography and mass spectrometry. My jobs included: research chemist, forensic scientist, toxicologist, environmental chemist, and computer advisor - Computer projects included writing Laboratory Information Management Systems (LIMS), specialist technical and financial systems, and heritage management.
I'm on Linkedin [ https://au.linkedin.com/in/timstrutt ] and ResearchGate [ https://www.researchgate.net/profile/Tim-Strutt ].
All of my current projects (including work on this web site) are on a voluntary "pro bono" basis.