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 establishes a standardized practice for performing detection and quantitation estimation and data assessment with the DQCALC software. Developed by ASTM Committee D19 on Water, this standard is grounded in key ASTM practices (D2777, D6091, and D6512) and streamlines statistical calculations essential for laboratories analyzing water samples. The DQCALC software automates calculations to estimate detection and quantitation limits using various models of inter- or intra-laboratory standard deviation as a function of concentration. This standard supports both interlaboratory and single-laboratory data assessment processes, ensuring consistent and reliable application in water quality laboratories.

Key Topics

• Automated Calculations: DQCALC automates detection and quantitation estimates (DE and QE), reducing manual calculation errors and increasing reproducibility.
• Multiple Statistical Models: Supports constant, straight-line, exponential, and hybrid (Rocke-Lorenzato) models to represent how laboratory standard deviation varies with concentration.
• Data Visualization: The software generates plots to assess model fit and guides users to select the least complex, adequately performing model as per ASTM requirements.
• Input Requirements: Data must be formatted as a Microsoft Excel spreadsheet with specific columns (Concentration, Result, Lab, Batch) and meet minimum data size criteria for accurate analysis.
• Compatibility: DQCALC is designed for Microsoft Excel (versions 2000, 2002, 2003, 2010, or 2013), operating on Windows 2000 or XP.
• Data Preparation and Quality Assurance: Incorporates outlier removal as outlined in ASTM D2777 to ensure the robustness of statistical analyses.

Applications

The standardized approach established in ASTM D7510-10(2016)e1 is especially valuable in:

• Environmental Water Analysis: Ensuring reliable determination of detection and quantitation limits for chemical and biological contaminants in interlaboratory or single-laboratory studies.
• Regulatory Compliance: Supporting laboratories in demonstrating adherence to quality system requirements and regulatory guidelines by providing standardized, defensible statistics.
• Laboratory Accreditation: Assisting laboratories seeking accreditation by generating documentation and statistical outputs consistent with international standards and ASTM practices.
• Method Validation and Verification: Used during development, validation, and verification of new analytical methods or modifications to existing protocols in water testing labs.
• Data Quality Assessment: Allowing rapid identification of outliers, model fitting, and statistical summaries to support data integrity and decision-making.

Related Standards

The application of ASTM D7510-10(2016)e1 is closely linked with several pivotal ASTM practices, including:

• ASTM D2777: Practice for Determination of Precision and Bias of Applicable Test Methods of Committee D19 on Water, specifically for outlier removal protocols.
• ASTM D6091: Practice for Interlaboratory Detection Estimate (IDE) calculation for analytical methods with negligible calibration error.
• ASTM D6512: Practice for Interlaboratory Quantitation Estimate (IQE) calculation.
• Related Software: DQCALC itself is an ASTM adjunct available via ASTM International.
• Microsoft Excel: DQCALC requires compatibility with specified versions of Microsoft Excel for its operation.

Keywords: Detection estimate, quantitation estimate, DQCALC software, interlaboratory detection estimate, water testing, ASTM D7510, laboratory standard deviation, data assessment, analytical method validation, statistical modeling.

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
...