RIST: Rainfall Intensity Summarization Tool

Analysis of time-and-date stamp tipping-bucket precipitation records

http://ars.usda.gov/Research/docs.htm?docid=3251

GCLAS: Graphical Constituent Loading Analysis System

Stream flow daily constituent load transport computation

http://water.usgs.gov/software/gclas.html

WARMF: Watershed Analysis Risk Management Framework

Decision support system for watershed management

http://www.epa.gov/athens/wwqtsc/html/warmf.html

BORAMEP: Bureau of Reclamation Automated Modified Einstein Procedure

Stream Channel Sediment Transport

http://www.usbr.gov/pmts/sediment/model/boramep/index.html

Stormwater Analysis Spreadsheets: Detention, Infiltration, and Pollutant Loadings

Pond Size and Shape Calculator
http://unix.eng.ua.edu/~rpitt/SLAMMDETPOND/7c%20pond%20sizer%20and%20shaper.xls

Loading and Life of Infiltration Device
http://unix.eng.ua.edu/~rpitt/SLAMMDETPOND/4%20loading%20and%20treatment%20needs.xls

Roadways/Channels: hydraulics analysis

Open-Channels: circular conduit calculator and reports application

Inlet on Grade: spreadsheet analysis for roadway street section and catch basin flow capacity on continuous grade

http://www.jeffers-assoc.com

Bruce Hunt PhD: Software and PDF Texts

* Pipe networks software
* Groundwater analysis spreadsheet
* Fluid Mechanics for Civil Engineers
* Fluid Mechanics Problems
* Fluid Mechanics Solutions
* The Solution of 2nd Order Partial Differential Equations
* Six Tutorials and Solutions for 2nd Order Partial Differential Equations

http://www.civil.canterbury.ac.nz/staff/bhunt.asp

Roadway stormwater analysis/design spreadsheet

Oregon DOT Hydraulics Manual Basis

Spreadsheet
http://egov.oregon.gov/ODOT/HWY/ENGSERVICES/files/drain6.xls

Erosion control measures analysis spreadsheets

North Carolina Division of Land Resources
Design Calculation Spreadsheets

* Sediment control measures
* Rationale method with Kinematic Wave Tc
* Spillway capacity
* Plunge pool, submerged outlet
* Plunge pool, cantilevered outlet
* Open Channel Flow

http://www.dlr.enr.state.nc.us/pages/links.htm

Rainfall-Runoff Processes (RRP) W3 Module

Analysis spreadsheets accompany this educational resource...

Target audience: 1)Professionals with a scientific or engineering background with a college degree in science or engineering; 2) Students (senior and graduate level) in a hydrologic science or engineering program.

Module should take about 6-15 hours to complete depending on your quantitative background and a priori knowledge in this area.

* A complete workbook on Rainfall Runoff Processes serving as the textbook for this module.
* Streaming video and slide presentations.
* Visualizations and computer animations to convey key concepts.
* Powerpoint presentations.
* Online quizzes serving as exercises where the user needs to respond to multiple choice questions or enter numeric answers to problems.
* An online final test.

http://hydrology.neng.usu.edu/RRP/

1D SEDIMENT TRANSPORT MORPHODYNAMICS with applications to RIVERS AND TURBIDITY CURRENTS

Excellent e-book series with analysis spreadsheets

http://cee.uiuc.edu/people/parkerg/morphodynamics_e-book.htm

Estimating Runoff Losses Due to Infiltration in Treatment Facilities and Trenches

Washington State DOT Design Office Hydraulics Branch
http://www.wsdot.wa.gov/eesc/design/hydraulics/

Low Impact Developing Modeling Guidance

Spreadsheet analysis of BMP infiltration
http://www.wsdot.wa.gov/eesc/design/hydraulics/MGSFloodTraining/wwinfilpondex.xls
http://www.wsdot.wa.gov/eesc/design/hydraulics/Manual/InfiltrationLossEst.pdf

WSDOE Low Impact Development Design and Flow Modeling Guidance
http://www.wsdot.wa.gov/eesc/design/hydraulics/Manual/LIDDesign&FlowModeling.pdf

Bioretention Sizing/Routing Spreadsheet

Bioretention stormwater management measure spreadsheet

http://www.bae.ncsu.edu/people/faculty/hunt/BR.Sizing.Routing2.xls

WTM (Watershed Treatment Model)

The Watershed Treatment Model (WTM) is a simple spreadsheet that tracks pollutant sources and the effectiveness of various watershed treatment options in urban and urbanizing watersheds.

http://www.cwp.org/PublicationStore/TechResearch.htm

WWHM (Western Washington Hydrology Model)

User friendly software application for sizing stormwater detention and water quality facilities to meet the Washington State Department of Ecology standards.

http://www.ecy.wa.gov/programs/wq/stormwater/wwhm_training/index.html
http://www.clearcreeksolutions.com/SearchResults.asp?Cat=17

SET (Site Evaluation Tool)

Planning tool: spreadsheet-based model for analysis of predevelopment and postdevelopment stormwater runoff, infiltration, and pollutant loading rates.

http://www.charmeck.org/Departments/StormWater/Contractors/Huntersville+LID.htm

Wake County Stormwater Tool

Planning/screening level analysis: spreadsheet tool

http://www.wakegov.com/departments/erosion.htm

LCS (LID Credit Spreadsheet)

LID Credits are based on the ability of various LID practices to reduce the overall VOLUME of runoff from a development site.

http://www.dcr.virginia.gov/documents/stmwtrwsswm052207.pdf

StormWISE (Storm Water Investment Strategy Evaluator)

StormWISE: screening and planning level analysis, cost-benefit model for stormwater management facilities.

http://watershed.swarthmore.edu

STEPL (Spreadsheet Tool for Estimating Pollutant Load)

Spreadsheet: nutrient and sediment loads from different land uses and the load reductions that would result from the implementation of various best management practices (BMPs).

http://it.tetratech-ffx.com/stepl/

NJGRS (New Jersey Groundwater Recharge Spreadsheet)

Groundwater recharge analysis: methodology, design storm, details, etc

http://www.njstormwater.org/tier_A/bmp_manual.htm#spreadsheet

IDEAL (Integrated Design and Evaluation Assessment of Loadings)

Spreadsheet model: stormwater structural management measures analysis

http://www.greenvillecounty.org/Storm_Water/Planning.asp
http://www.stormwatercentral.com/sw_0309_model.html

A Milwaukee Model for LID Hydrologic Analysis

Calculations for the preferred approach have been formulated in a spreadsheet that allows the user to input the amount of retention provided by each of several kinds of LID components, and then see immediately a recalculated hydrograph that reflects the predicted effect of the aggregate retention volume. The spreadsheet, which has been dubbed the ”LID Quicksheet”, is expected to be incorporated along with its documentation into the MMSD stormwater management guidance.

http://www.pubs.asce.org/WWWdisplay.cgi?0523336
http://www.lowimpactdevelopment.org/milwaukee.htm

BURBS Spreadsheet (nitrogen mass balance)

BURBS is a Lotus 1-2-3 version 2 spreadsheet that helps you to construct a nitrogen mass balance for a residential area in a place like Long Island. Much of the U.S. Atlantic Coastal Plain is similar to Long Island:

* Significant surplus of precipitation over evapotranspiration.
* High soil and subsoil infiltration rates.
* Flat terrain, leading to very little overland runoff except from impervious surfaces.

http://wri.eas.cornell.edu/products/software/burbs.html

3-PG Forest Growth Model

Land Cover Changes (Trending/Predictive Watershed Parameter Analysis)

3-PG calculates the radiant energy absorbed by forest canopies and converts it into biomass production. The efficiency of radiation conversion is modified by the effects of nutrition, soil drought (the model includes continuous calculation of water balance), atmospheric vapour pressure deficits and stand age. The carbon produced by the canopy is allocated to leaves, stems and roots, using dynamic equations that update the state of the system on a monthly time step.

http://www.ensisjv.com/Default.aspx?PageContentID=344&tabid=414

Rational Method storm drain network analysis spreadsheet

HawsEDC (Engineering, Drafting, and Computing)

SDnet: Rational Method storm drain network analysis spreadsheet
OpenOffice Calc

http://www.hawsedc.com/gnu/sdnet.php

Landscape Irrigation Management Program

Microsoft Excel spreadsheet (LIMP): used to calculate ETo rates, determine landscape coefficients (KL), estimate evapotranspiration (ETL) of landscape vegetation, and determine irrigation schedules.

http://biomet.ucdavis.edu/irrigation_scheduling/LIMP/LIMP.htm

Hourly Reference Evapotranspiration (ETo) Calculator

HRPM.EXE is an executable program that calculates reference evapotranspiration (ETo) for a grass reference using hourly weather data and the Penman-Monteith equation.

http://biomet.ucdavis.edu/evapotranspiration/HRPMexe/HRPM.htm

BSTEM: Bank Stability and Toe Erosion Model

Analysis spreadsheet

http://ars.usda.gov/Research/docs.htm?docid=5044
http://pubs.usgs.gov/wri/wri034265/

STREAM Modules: Stream Morphology

Spreadsheet Tools for River Evaluation, Assessment, and Monitoring

http://www.dnr.state.oh.us/tabid/9188/default.aspx

Spreadsheet: Water Table Mounding

Hantush 1967 WRR
ZIP file, Microsoft Excel spreadsheet (folks need to develop these things for FOSS applications)

http://www.ndwrcdp.org/userfiles/WaterTableMounding_EnglishUnits.xls
http://www.ndwrcdp.org/userfiles/WUHT0245_Electronic.pdf

New version of SWMM released

Latest update to EPA SWMM released: Version 5 Build 0.011 (5.0.011, 2007 July 07). Download at "http://www.epa.gov/ednnrmrl/models/swmm/index.htm".