14/05/2021
[Reference] T. Wenzl et al. doi:10.2787/8931, JRC102946 (LINK to the pdf file)
The XLS sheet below calculates LOD/LOQ (an example is provided in Annex A.2.3 of the above mentioned guide)
You have to:
1. Provide the calibration data
(x_cal, y-cal) , from 20 (optimal) to 40 (max) data entries;
2. Review the graphs (visual check);
3. Confirm the suitability of the concentration range used. (max concentration < 10 *LOQ).
Note:
Microsoft does not allow to copy&paste cells into the online spreadsheet.
You have to type in all values one-by-one, in the yellow cell ONLY.
Your values will not be saved. The spreadsheet will be reset (= all introduced values deleted) each time you leave or refresh this page.
Disclaimer:
The information above is provided "as is" without warranty of any kind, either express or implied, including, but not limited to, fitness for a particular purpose and absence of errors in the application. The entire risk as to the use, quality, and performance of the application is with the user. The owner of these Tools will not be liable for any incidental, consequential, direct or indirect damages including but not limited to the loss of data, loss of profits, or any other financial loss arising from the use or inability to use the application provided.
pihin007 (C) 2025
Disclaimer:
The information provided hereinis offered on an "as is" basis, without any warranty, express or implied, including, but not limited to, implied warranties of fitness for a particular purpose, accuracy, or error-free functionality. The user assumes all risks associated with the use, quality, and performance of this application. The owner of these tools shall not be held liable for any direct, indirect, incidental, consequential, direct, or other damages, including, but not limited to, data loss, loss of profits, or financial losses, arising from the use of, or inability to use, this application.
.
