Line 27: | Line 27: | ||
*Row A: Headers for the inputs | *Row A: Headers for the inputs | ||
*Row B: Annual precipitation, in inches. The user inputs annual precipitation in Cell D2. Cell E2 contains a link to precipitation data for select Minnesota cities. The default is 30.6 inches, corresponding to annual precipitation at the Minneapolis-St. Paul International airport at the time the spreadsheet was created. | *Row B: Annual precipitation, in inches. The user inputs annual precipitation in Cell D2. Cell E2 contains a link to precipitation data for select Minnesota cities. The default is 30.6 inches, corresponding to annual precipitation at the Minneapolis-St. Paul International airport at the time the spreadsheet was created. | ||
− | *Row C: Percent of the area over which loading is being calculated that is impervious. The user enters impervious area, as a percent of the total area, in cell C4. Note this represents total impervious area (i.e. directly connected and disconnected impervious area) such as streets, sidewalks, parking lots, roofs, and so on. It does not include compacted pervious areas. The value may range from 0 (no impervious surface) to 100 (the entire area consists of impervious surface). | + | *Row C: Percent of the area over which loading is being calculated that is impervious. The user enters impervious area, as a percent of the total area, in cell C4. Note this represents total impervious area (i.e. directly connected and disconnected impervious area) such as streets, sidewalks, parking lots, roofs, and so on. It includes pervious areas that are part of the practice (e.g. swales and filter strips). It does not include compacted pervious areas. The value may range from 0 (no impervious surface) to 100 (the entire area consists of impervious surface). |
− | *Row D: Percent of the area over which loading is being calculated that is pervious. The user enters pervious area, as a percent of the total area, in cell D4. Note this represents total pervious area, including lawns, gardens, stormwater practices such as swales and bioretention | + | *Row D: Percent of the area over which loading is being calculated that is pervious. The user enters pervious area, as a percent of the total area, in cell D4. Note this represents total pervious area, including lawns, gardens, wooded areas, cropped areas, etc. It does not include pervious portions of stormwater practices such as swales, filter strips, and bioretention practices as these areas are included in the impervious area draining to the stormwater practice. The estimate of pervious area does not consider the condition of the pervious area (e.g. compacted) or the underlying soil (e.g. sand, clay, etc.). The value may range from 0 (no pervious surface) to 100 (the entire area consists of pervious surface). |
*Row E: Percent of the impervious area draining to [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices infiltration practice(s)]. Infiltration practices are practices with no <span title="An underground drain or trench with openings through which the water may percolate from the soil or ground above"> '''underdrain'''</span> and that are designed to capture and infiltrate a specified amount of stormwater runoff. The user enters the value in cell E4. The value may range from 0 (no infiltration practices) to 100 (all runoff from impervious surfaces drains to infiltration practices). | *Row E: Percent of the impervious area draining to [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_infiltration_Best_Management_Practices infiltration practice(s)]. Infiltration practices are practices with no <span title="An underground drain or trench with openings through which the water may percolate from the soil or ground above"> '''underdrain'''</span> and that are designed to capture and infiltrate a specified amount of stormwater runoff. The user enters the value in cell E4. The value may range from 0 (no infiltration practices) to 100 (all runoff from impervious surfaces drains to infiltration practices). | ||
*Row F: Percent of the impervious area draining to [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_filtration_Best_Management_Practices filtration practice(s)]. Filtration practices include practices having an underdrain, filter strips not designed for infiltration, and swales not designed for infiltration. The user enters the value in cell F4. The value may range from 0 (no filtration practices) to 100 (all runoff from impervious surfaces drains to filtration practices). | *Row F: Percent of the impervious area draining to [https://stormwater.pca.state.mn.us/index.php?title=Stormwater_filtration_Best_Management_Practices filtration practice(s)]. Filtration practices include practices having an underdrain, filter strips not designed for infiltration, and swales not designed for infiltration. The user enters the value in cell F4. The value may range from 0 (no filtration practices) to 100 (all runoff from impervious surfaces drains to filtration practices). |
This page provides guidance for using an Excel spreadsheet designed to estimate contributions of chloride to shallow groundwater from nine different sources. The calculator allows the user to adjust inputs for each source and produces an estimate, in pounds per acre or kilograms per hectare, from each source and cumulatively for all sources. The nine sources, described in greater detail below, include the following.
Before using the calculator, we strongly recommend reading the following.
Cells A1 through D7 are for general inputs into the calculator.
The following conditions apply to the inputs in these cells.
This term includes chloride loading from areas such as lawns, gardens, wooded areas, and cropped areas. It does not include loading from pervious areas in stormwater practices, such as a swale of filter strip.
Cell B10 has a default formula for estimating annual recharge, in inches, through pervious surfaces. Recharge, R, is given by
\( R_{pervious} = P * F_P \)
where
FP = is the fraction of annual precipitation that infiltrates through the soil, vadose zone, and into groundwater.
The default for FP in cell G10 is 0.2 based on a literature review. The user may change the value for FP. Recharge, calculated in cell B10, equals cellD4*0.01*G10*D2, where the 0.01 corrects for cell D4 (percent pervious) being expressed as a percent and cell D2 is P.
FP is often known for an area. For example, USGS studies often publish this information as part of hydrologic studies in a watershed. If annual recharge through pervious surfaces is known, it may be input directly into cell B10. Note that substituting a value in cell B10 erases the formula.
This input includes leakage from water distribution systems. There is always some leakage from these systems since they are under pressure.
The default annual infiltration rate (I) is based on the following equation
\( I = P * F_{precipitation} * L \)
where
L is the leakage rate from the piped infrastructure, as a fraction of total piped inflow.
The term Fprecipitation is used because most literature expresses the volume of piped inflow as a percentage of precipitation. For example, studies suggest that a typical volume of piped inflow is about 50% the value of annual precipitation volume. Leakage represents an annual average value. For example, if 15% of the annual piped inflow is lost through leakage, the value for F is 0.15. The terms Fprecipitation and L are thus unitless.
Users who have data for the volume of piped inflow should use that data. In this case, the formula in cell B12 would be rewritten as L times the annual volume of piped inflow divided by the area with piped inflow. For example, if the leakage rate is 0.15 the annual piped inflow is 1000 ft3, and the area with piped inflow is 100 ft2, the annual infiltration rate (I) equals 0.15 * 1000 / 10 or 1.5 inches per year.