ASTM_D_7510_-_10.pdf

Designation:D751010Standard Practice forPerforming Detection and Quantitation Estimation and DataAssessment Utilizing DQCALC Software,based on ASTMPractices D6091 and D6512 of Committee D19 on Water1,2This standard is issued under the fixed designation D7510;the number immediately following the designation indicates the year oforiginal adoption or,in the case of revision,the year of last revision.A number in parentheses indicates the year of last reapproval.Asuperscript epsilon()indicates an editorial change since the last revision or reapproval.1.Scope1.1 This software was developed to automate calculationswithin three ASTM standards:Practices D2777(outlier re-moval section),D6091,and D6512.1.2 The program calculates detection estimates(DE)andquantitation estimates(QE)for the constant,straight-line,exponential,and hybrid(Rocke-Lorenzato)models of thevariation of inter or intra laboratory standard deviation(ILSD)with concentration.Calculations are shown in theDE_QE worksheet and results are shown in the DLs&QLsworksheet.Several plots are generated showing how well eachmodel fits the data.The least complex model to fit the data withadequate confidence must be used by the ASTM standards.NOTE1Modeling techniques automated in this Practice and with thissoftware have been shown to work well with most data sets.Users of thissoftware are cautioned that with some,rare data sets,anomalous resultsmay be obtained,and manual forcing of a different model may berequired.It has been noted that for some data sets when an exponentialmodel is selected,there may be a lack of convergence on a result or theremay be a convergence on two separate results.1.3 Users of DQCALC should refer to these Practices forthe specifics of the scope and application of the Practices.1.4 The IDE and IQE Practices are concerned with esti-mates of limits of detection and limits of quantitation based oninter-laboratory data.DQCALC may also be employed tocalculate detection and quantitation estimates based on singlelaboratory data.1.5 The DQCALC Software consists of an Excel3workbookand associated macros and a user manual in Microsoft Word.32.Referenced Documents2.1 ASTM Standards:4D2777 Practice for Determination of Precision and Bias ofApplicable Test Methods of Committee D19 on WaterD6091 Practice for 99%/95%Interlaboratory DetectionEstimate(IDE)for Analytical Methods with NegligibleCalibration ErrorD6512 Practice for Interlaboratory Quantitation Estimate2.2 ASTM Adjuncts:DQCALC Microsoft Excel-based software for the Inter-laboratory Quantitation Estimate(IQE)23.Terminology3.1 Definitions of Terms Specific to This Standard:3.1.1 batchthe samples associated with a given samplepreparation.If all laboratories analyze samples prepared atthree different times then results from each sample preparationwould be considered a distinct batch.3.1.2 p-valueprobability value associated with curvature,the smaller the value the higher the likelihood of curvature(0.05 is acceptable).3.1.3 Q-valueQ must be positive and the associated prob-ability of Q(pQ-value)which is related to curvature must be 0.05.3.2 Acronyms:3.2.1 DEdetection estimate3.2.2 IDEinterlaboratory detection estimate3.2.3 ILSDinter or intra/within laboratory standard de-viation3.2.4 IQEinterlaboratory quantitation estimate3.2.5 QEquantitation estimate1This practice is under the jurisdiction of ASTM Committee D19 on Water andis the direct responsibility of Subcommittee D19.02 on Quality Systems,Specifi-cation,and Statistics.Current edition approved May 1,2010.Published June 2010.DOI:10.1520/D7510-10.2DQCALC is available from ASTM International Headquarters.Order AdjunctNo.ADJDQCALC.Original adjunct produced in 2007.3Trademark of Microsoft.4For referenced ASTM standards,visit the ASTM website,www.astm.org,orcontact ASTM Customer Service at serviceastm.org.For Annual Book of ASTMStandards volume information,refer to the standards Document Summary page onthe ASTM website.Copyright ASTM International,100 Barr Harbor Drive,PO Box C700,West Conshohocken,PA 19428-2959.United States1 3.2.6 SSRsum-of-squared residuals3.2.7 WDEwithin-lab detection estimate3.2.8 WQEwithin-lab quantitation estimate4.Minimum Requirements4.1 DQCALC is based on an Microsoft Excel spreadsheetworkbook.4.2 DQCALC requires the following minimum hardwareand operating system configuration to function properly:4.2.1 IBM-compatible PC with a Pentium microprocessor(or equivalent),133 Mhz or faster.4.2.2 Windows 2000 or XP.4.2.3 Excel 2000,2002(XP),or 2003.4.2.4 32 MB RAM,plus minimum of 2-3 MB free diskspace for each file to be processed.4.2.5 Color video monitor,using a standard 1024 768screen resolution.The program will function properly underany resolution,but may look awkward with other screenresolutions.4.2.6 Mouse.4.3 This application contains macros.You must have mac-ros enabled in order for the program to function.5.Basic Operation of DQCALC Software5.1 The Input File:5.1.1 The input file must be in the form of an Excelspreadsheet(