Seal of Dane County County of Dane
Dane County Land & Water Resources Department

Soil Loss & Sediment Discharge Calculation Tool

Image of the Soil Loss & Sediment Discharge worksheetThe Dane County Water Resource Engineering Division and Wisconsin DNR have developed an Excel worksheet that calculates soil loss and sediment discharge from construction sites. This spreadsheet uses the Universal Soil Loss Equation (USLE) to determine whether the combination of proposed erosion control practices will limit sediment discharge from sheet and rill erosion to 5 tons/acre/year, as required by Chapter 14.

Click on the buttons below to download the spreadsheet from Wisconsin DNR and view our Erosion Control and Stormwater Manual (ECSM) for guidance on its use.


Contact Jeremy Balousek at with questions.