Non-Field Tools

Municipal, Industrial, Commercial and Other Laboratories

This page provides computer applications, spreadsheets, calculators, etc. to aid laboratories and laboratory analysts in meeting certification and quality assurance requirements.

Tool Revision Date Description

Total Residual Chorine (TRC) Curve Calculators

3/17/2017 (low)     3/17/2017 (reg) Excel® spreadsheets for calculating the correlation coefficient and percent recoveries of standards used to verify the instrument calibration. The worksheets may also be used to document the process and satisfy record retention requirements.
Free Available Chlorine (FAC) Curve Calculator 3/17/2017 An Excel® spreadsheet for calculating the correlation coefficient and percent recoveries of standards used to verify the instrument calibration. The worksheet may also be used to document the process and satisfy record retention requirements.
Adjustable Pipettor Calibration Worksheet  05/21/2009  An Excel® spreadsheet for determining relative error and coefficient of variation of adjustable pipettors. An example procedure for calibrating mechanical volumetric liquid-dispensing devices can be viewed here.
Fixed Pipettor Calibration Worksheet   05/21/2009 An Excel® spreadsheet for determining relative error and coefficient of variation of fixed pipettors. An example procedure for calibrating mechanical volumetric liquid-dispensing devices can be viewed here.
ADMI Color Calculation Spreadsheet   10/01/2009 An Excel® spreadsheet for calculating ADMI color using the Tristimulus Filter Method. Tristimulus values are converted to an ADMI single number color difference of all the same magnitude assigned to PtCo standards using the Adams Nickerson Color Difference (DE). 
Total Hardness (mg/L as CaCO3) Calculator  06/16/2010 An Excel® spreadsheet for calculating Total Hardness (mg/L as CaCO3) using results obtained for Calcium and Magnesium.

Link to National Pollution Discharge Elimination System (NPDES) Permitting Guidance and Directions for Completing a Discharge Monitoring Report (DMR). Look under Compliance Forms.

Link to Land Application Unit spreadsheets for Vector Attraction Reduction (VAR) Option 4 - SOUR Calculation and Temperature Correction for pH.

Link to Control of Pathogens and Vector Attraction in Sewage Sludge (White House Book)