Models & spreadsheets

Models and spreadsheets assist with scientific research and engineering. The models and spreadsheets we develop are available for use by the scientific community and the public. Download here.

Learn about models

Modeling the environment describes the models that we are developing and using. Models can predict environmental changes.

Let us help you calculate

Water quality

Models & tools for water quality improvement projects offers a variety of modeling tools for those involved in the TMDL water quality improvement process.
River & stream water quality index explains the Water Quality Index (WQI) and offers a WQI calculator that can be used with your own stream data.
Spreadsheet tool for estimating groundwater nitrate concentration from available data can be used to quantitatively predict the impact of residual or excess farm-field soil nitrate or mass balance residual on the concentration of nitrate in underlying shallow groundwater.

Effluents

A PermitCalc spreadsheet can help with many kinds of calculations needed by dischargers of effluents. Please contact your permit manager for the current version.

Contamination cleanup

Online tools for cleaning up sites has a number of tools that will help owners of sites contaminated by substances that are not petroleum, including a workbook for calculating cleanup levels.
Tools for cleaning up petroleum contaminated sites has tools specifically for sites contaminated by petroleum.

Water supply

Rainwater collection has the rainwater harvesting calculator available for download.
Dam construction & modification guidance includes a number of spreadsheets and tools that engineers can use to construct or retrofit dams.

Laboratories

Bench sheets & control charts can help labs with quality control.

Were you able to find what you were looking for today?*:	Yes No Not sure
What were you trying to find?*:
Please describe your experience. What was challenging? What was helpful? *:	Please include details that will help us address any issues you're reporting. NOTE: There is a 1,500 character limit (including spaces) on this form field.
Was the search tool helpful to you? *:	Yes No I didn't use Search.
How can we improve our website?:	Optional. If you have suggestions, we'd like to hear them! NOTE: There is a 1,500 character limit (including spaces) on this form field.
Your name:	Please include contact information if you'd like a reply.
Email:	If you’d like a reply, please provide an email address.
Phone number:	( ) - Second three digits Last four digits If you’d like us to call you, please provide a phone number.
Which best describes your role in visiting our site today?*:	Business / Consultant / Contractor Government - Local Government - State Government - Federal Government - Tribal Scientist / Researcher Non-profit Washington resident / Public Educator Student Job seeker Ecology employee
PleaseLeaveBlank:	Are you a robot? If not, please do not enter anything in this field.
	ignore
	ignore