ASTM D7510-10(2016)e1

Standard Practice for Performing Detection and Quantitation Estimation and Data Assessment Utilizing DQCALC Software, based on ASTM Practices D6091 and D6512 of Committee D19 on Water

SCOPE
1.1 This software was developed to automate calculations within three ASTM standards: Practices D2777 (outlier removal section), D6091, and D6512.  
1.2 The program calculates detection estimates (DE) and quantitation estimates (QE) for the constant, straight-line, exponential, and hybrid (Rocke-Lorenzato) models of the variation of [inter or intra] laboratory standard deviation (ILSD) with concentration. Calculations are shown in the DE_QE worksheet and results are shown in the DLs & QLs worksheet. Several plots are generated showing how well each model fits the data. The least complex model to fit the data with adequate confidence must be used by the ASTM standards.
Note 1: Modeling techniques automated in this practice and with this software have been shown to work well with most data sets. Users of this software are cautioned that with some, rare data sets, anomalous results may be obtained, and manual forcing of a different model may be required. It has been noted that for some data sets when an exponential model is selected, there may be a lack of convergence on a result or there may be a convergence on two separate results.  
1.3 Users of DQCALC should refer to Practices D2777, D6091, and D6512 for the specifics of the scope and application of the Practices.  
1.4 The IDE Practice (D6091) and the IQE Practice (D6512) are concerned with estimates of limits of detection and limits of quantitation based on inter-laboratory data. DQCALC may also be employed to calculate detection and quantitation estimates based on single laboratory data.  
1.5 The DQCALC Software consists of a Microsoft Excel3 workbook spreadsheet and associated macros and a user manual in Microsoft Word.3

General Information

• Status: Published
• Publication Date: 14-Dec-2016
• ICS: 17.020 - Metrology and measurement in general
• Technical Committee: D19 - Water
• Drafting Committee: D19.02 - Quality Systems, Specification, and Statistics

Relations

• Replaces: ASTM D7510-10 - Standard Practice for Performing Detection and Quantitation Estimation and Data Assessment Utilizing DQCALC Software, based on ASTM Practices D6091 and D6512 of Committee D19 on Water <a href="#fn00003"></a>
• Effective Date: 15-Dec-2016
• Refers: ASTM D2777-12 - Standard Practice for Determination of Precision and Bias of Applicable Test Methods of Committee D19 on Water
• Effective Date: 15-Jun-2012
• Refers: ASTM D2777-08 - Standard Practice for Determination of Precision and Bias of Applicable Test Methods of Committee D19 on Water
• Effective Date: 15-Jan-2008
• Refers: ASTM D6512-07 - Standard Practice for Interlaboratory Quantitation Estimate
• Effective Date: 01-Mar-2007
• Refers: ASTM D6091-07 - Standard Practice for 99 %/95 % Interlaboratory Detection Estimate (IDE) for Analytical Methods with Negligible Calibration Error
• Effective Date: 01-Mar-2007
• Refers: ASTM D2777-06 - Standard Practice for Determination of Precision and Bias of Applicable Test Methods of Committee D19 on Water
• Effective Date: 15-Aug-2006
• Refers: ASTM D6091-03 - Standard Practice for 99 %/95 % Interlaboratory Detection Estimate (IDE) for Analytical Methods with Negligible Calibration Error
• Effective Date: 10-Aug-2003
• Refers: ASTM D2777-03 - Standard Practice for Determination of Precision and Bias of Applicable Methods of Committee D-19 on Water
• Effective Date: 10-Aug-2003
• Refers: ASTM D6512-03 - Standard Practice for Interlaboratory Quantitation Estimate
• Effective Date: 10-Mar-2003
• Refers: ASTM D6512-00 - Standard Practice for Interlaboratory Quantitation Estimate
• Effective Date: 10-Feb-2000
• Refers: ASTM D2777-98 - Standard Practice for Determination of Precision and Bias of Applicable Methods of Committee D-19 on Water
• Effective Date: 10-Jan-1998
• Refers: ASTM D6091-97 - Standard Practice for 99 %/95 % Interlaboratory Detection Estimate (IDE) for Analytical Methods with Negligible Calibration Error
• Effective Date: 10-Feb-1997
• Referred By: ASTM D7729-12(2018)e1 - Standard Practice for Determining and Expressing Precision of Measurement Results, in the Analysis of Water, as Relative Standard Deviation, Utilizing DQCALC Software
• Effective Date: 15-Dec-2016

Overview

ASTM D7510-10(2016)e1 is an international standard practice developed by ASTM Committee D19 on Water. It provides a structured methodology for performing detection and quantitation estimation and data assessment using the DQCALC software. The main aim of this standard is to automate complex statistical calculations within analytical laboratory workflows, particularly for water testing, by leveraging established ASTM practices (D2777, D6091, and D6512). It standardizes the use of Excel-based DQCALC to ensure consistent, accurate reporting of detection limits and quantitation limits.

This standard is especially relevant for laboratories analyzing water samples, as it ensures comparability and reliability of results by using comprehensive data assessment techniques and widely accepted statistical models.

Key Topics

• Automated Calculations: DQCALC streamlines the calculation of detection estimates (DE) and quantitation estimates (QE) using multiple models - constant, straight-line, exponential, and hybrid (Rocke-Lorenzato) - to fit laboratory standard deviation data versus concentration.
• Interlaboratory and Intralaboratory Analysis: The software is designed for use with both interlaboratory and single-laboratory data, providing flexibility across different laboratory settings.
• Model Selection and Visualization: DQCALC generates plots to visualize how well each statistical model fits the provided data, ensuring users select the least complex suitable model with adequate confidence.
• Outlier Handling and Data Assessment: Incorporates outlier removal functions per ASTM Practice D2777, enhancing data integrity.
• User Requirements: Operates via Microsoft Excel (with macro support), requiring specific hardware and operating system configurations.

Applications

ASTM D7510-10(2016)e1 and its associated DQCALC software have practical applications in analytical chemistry laboratories, especially those working within regulatory frameworks for water quality assessment. Key uses include:

• Standardization of Detection and Quantitation Estimates: Ensures laboratories apply consistent methods to estimate detection limits (DLs) and quantitation limits (QLs), improving reliability and comparability of test results across facilities.
• Regulatory Compliance: Facilitates adherence to ASTM standards, often referenced in regulatory documentation for environmental monitoring and water testing.
• Data Quality Assurance: Automates robust model fitting and data evaluation, reducing human error and increasing analytical transparency in laboratory reports.
• Optimization of Laboratory Workflows: By automating calculations and model selection, DQCALC enhances laboratory efficiency, freeing up resources for additional analysis.

Related Standards

ASTM D7510-10(2016)e1 integrates and builds upon several critical ASTM practices:

• ASTM D2777: Practice for Determination of Precision and Bias of Applicable Test Methods of Committee D19 on Water
• ASTM D6091: Practice for 99%/95% Interlaboratory Detection Estimate (IDE) for Analytical Methods with Negligible Calibration Error
• ASTM D6512: Practice for Interlaboratory Quantitation Estimate (IQE)
• DQCALC Software: Excel-based tool developed as an adjunct to support statistics and data handling for detection and quantitation estimates

Keywords: DQCALC, detection estimate, quantitation estimate, water testing, ASTM D7510, interlaboratory analysis, Excel-based laboratory software, data assessment, analytical laboratory standardization, detection limit, quantitation limit, statistical models, outlier removal.

For laboratories performing water analysis or environmental monitoring, implementing ASTM D7510-10(2016)e1 ensures accurate, repeatable, and standardized quantitation and detection estimation through a robust, automated Excel-based process. This supports regulatory compliance and promotes the highest levels of data integrity in water quality testing practices.

Standards Content (Sample)

This international standard was developed in accordance with internationally recognized principles on standardization established in the Decision on Principles for the
Development of International Standards, Guides and Recommendations issued by the World Trade Organization Technical Barriers to Trade (TBT) Committee.
´1
Designation: D7510 − 10 (Reapproved 2016)
Standard Practice for
Performing Detection and Quantitation Estimation and Data
Assessment Utilizing DQCALC Software, based on ASTM
1,2
Practices D6091 and D6512 of Committee D19 on Water
This standard is issued under the fixed designation D7510; the number immediately following the designation indicates the year of
original adoption or, in the case of revision, the year of last revision.Anumber in parentheses indicates the year of last reapproval.A
superscript epsilon (´) indicates an editorial change since the last revision or reapproval.
ε NOTE—Reapproved with editorial change to 4.2.3 in December 2016.
1. Scope 2. Referenced Documents
1.1 This software was developed to automate calculations 2.1 ASTM Standards:
within three ASTM standards: Practices D2777 (outlier re- D2777Practice for Determination of Precision and Bias of
moval section), D6091, and D6512. Applicable Test Methods of Committee D19 on Water
D6091Practice for 99 %/95 % Interlaboratory Detection
1.2 The program calculates detection estimates (DE) and
Estimate (IDE) for Analytical Methods with Negligible
quantitation estimates (QE) for the constant, straight-line,
Calibration Error
exponential, and hybrid (Rocke-Lorenzato) models of the
D6512Practice for Interlaboratory Quantitation Estimate
variation of [inter or intra] laboratory standard deviation
2.2 ASTM Adjuncts:
(ILSD) with concentration. Calculations are shown in the
DQCALC Microsoft Excel-based software for the Inter-
DE_QE worksheet and results are shown in the DLs & QLs
laboratory Quantitation Estimate (IQE)
worksheet. Several plots are generated showing how well each
modelfitsthedata.Theleastcomplexmodeltofitthedatawith
3. Terminology
adequate confidence must be used by the ASTM standards.
NOTE 1—Modeling techniques automated in this practice and with this 3.1 Definitions of Terms Specific to This Standard:
software have been shown to work well with most data sets. Users of this
3.1.1 batch—the samples associated with a given sample
software are cautioned that with some, rare data sets, anomalous results
preparation. If all laboratories analyze samples prepared at
may be obtained, and manual forcing of a different model may be
three different times then results from each sample preparation
required. It has been noted that for some data sets when an exponential
would be considered a distinct batch.
model is selected, there may be a lack of convergence on a result or there
may be a convergence on two separate results.
3.1.2 p-value—probability value associated with curvature,
1.3 Users of DQCALC should refer to Practices D2777,
the smaller the value the higher the likelihood of curvature
D6091, and D6512 for the specifics of the scope and applica- (<0.05 is acceptable).
tion of the Practices.
3.1.3 Q-value—Q must be positive and the associated prob-
ability of Q (p -value) which is related to curvature must be
1.4 The IDE Practice (D6091) and the IQE Practice
Q
(D6512) are concerned with estimates of limits of detection <0.05.
and limits of quantitation based on inter-laboratory data.
3.2 Acronyms:
DQCALC may also be employed to calculate detection and
3.2.1 DE—detection estimate
quantitation estimates based on single laboratory data.
3.2.2 IDE—interlaboratory detection estimate
1.5 The DQCALC Software consists of a Microsoft Excel
3.2.3 ILSD—[inter or intra/within] laboratory standard de-
workbook spreadsheet and associated macros and a user
viation
manual in Microsoft Word.
3.2.4 IQE—interlaboratory quantitation estimate
This practice is under the jurisdiction ofASTM Committee D19 on Water and 3.2.5 QE—quantitation estimate
is the direct responsibility of Subcommittee D19.02 on Quality Systems,
3.2.6 SSR—sum-of-squared residuals
Specification, and Statistics.
Current edition approved Dec. 15, 2016. Published December 2016. Originally
approved in 2010. Last previous edition approved in 2010 as D7510 – 10. DOI:
10.1520/D7510-10R16E01. For referenced ASTM standards, visit the ASTM website, www.astm.org, or
DQCALC is available fromASTM International Headquarters. OrderAdjunct contact ASTM Customer Service at [e-mail]. For Annual Book of ASTM
No. ADJDQCALC. Original adjunct produced in 2007. Standards volume information, refer to the standard’s Document Summary page on
Trademark of Microsoft, Redmond, WA, 98052. the AS
...