skip to main content | skip to footer
N.C. Department of Environment and Natural Resources

NC Department of Environment and Natural Resources
Water Quality - Tools

Water Quality

Web Content Display Web Content Display

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

06/04/2014 (low)     05/19/2014 (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 05/19/2014 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 CalculationSpreadsheet   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)

38364 FEEDBACK

Your input is valuable to us. Please send us your feedback.

What type of feedback would you like to send?*

Ask a Question Report a Problem Have a Concern Make a Comment

(If you would like us to respond please include your phone or e-mail.)

Your Question has been sent. Thank you!

An internal server error prevented Your Question from being sent.
Please try again later, or call Toll-Free (877) 623-6748 for immediate assistance.

Please complete all highlighted items

Your Problem has been sent. Thank you!

An internal server error prevented Your Question from being sent.
Please try again later, or call Toll-Free (877) 623-6748 for immediate assistance.

Please complete all highlighted items

Your Concern has been sent. Thank you!

An internal server error prevented Your Question from being sent.
Please try again later, or call Toll-Free (877) 623-6748 for immediate assistance.

Please complete all highlighted items

Your Comment has been sent. Thank you!

An internal server error prevented Your Question from being sent.
Please try again later, or call Toll-Free (877) 623-6748 for immediate assistance.

Please complete all highlighted items

*If you are a DENR employee with an I.T. issue, please submit a DOTS ticket.