GRTS Model Training
Contents
1. Estimate BMP Efficiency Using USLE C Value Table Ill Values of Cover and Management Factor C for Pasture and Woodland Novotny amp Chesters 1981 Cover Value Permanent pasture idle land unmanaged woodland 95 100 ground cover as grass 0 003 as weeds 0 01 80 ground cover as grass 0 01 as weeds 0 04 60 ground cover as grass 0 04 as weeds 0 09 Managed woodland 75 100 tree canopy 0 001 40 7596 tree canopy 0 002 0 004 20 40 tree canopy 0 003 0 01 For example Increase ground cover from 60 to 80 will reduce erosion about 75 Estimate BMP Efficiency Using USLE C Value Table IV Generalized Values of Cover and Management Factor C for Field Crops East of the Rocky Mountains Stewart et al 1975 Notes and Abbreviations a High level exemplified by long term yield averages greater than 75 bu ac corn or 3 ton ac hay or cotton management that regularly provides good stands and growth b Numbers in parentheses indicate numbers of years in the rotation cycle 1 indicates a continuous one crop system c Grain sorghum soybeans or cotton may be substituted for corn in lines 12 14 15 17 19 21 25 to estimate values for sod based rotations Abbreviations B soybeans F fallow C corn M grass amp legume hay c k chemically killed pl plant conv conventional W wheat cot cotton WC winter cover Ib re pounds of residue per acre remaining on surface after new crop seeding re percentage of soi2. Sample Problem Exercise e Enter data in the Input 5 heet numbers in red in spreadsheet By default optional tables are not shown Click yes to show the optional tables Table 5 8 with their default values Click no to hide them Select state Alabama and county Cullman Notice that initial values for Annual Rainfall and Number of Rain Days are automatically specified in Table 1 as you select a state or county Select a weather station Al Birmingham FAA Notice that correction factors change with the selected weather station In Table 1 enter the land use areas for your watershed Refer next slide Also in Table 1 Select the feedlot percent paved assuming feedlot area is not zero Default value 0 24 QQ Sample Problem Exercise 1 Enter data in the Input Worksheet numbers in red in Spreadsheet cont d Also enter data into Tables 2 and 3 Set the number of months manure applied to 3 n Table 4 examine the initial USLE parameter values for each land use type which were automatically specified as you selected the state and county Table 2 Table 3 Cropland Beef Cattle Feedots 5 Dairy Cattle No of Septic Systems 5 Swine Hog Population per Septic System 2s Septic Failure Rate You can always change the default and initial data when local data are available Sample Problem Exercise 1 Examine estimated load in Total Load and Graph worksheets and enter the
3. Similar to exercise 1 create a new spreadsheet but specify three watersheds this time Program STEPL gt STEPL Select options For Exercise 5 specify the following e Specify number of watershed 3 e Specify gully formations 2 e Specify impaired streambanks 2 e Select second option under Option for Initialization Test STEPL model with non zero initial numbers Click ok to create new spreadsheet Click ok to the following message box Save the spreadsheet using a new file name e For this example you may save it to exercise5 xls When the new spreadsheet is opened click Ok button to enable stored formulas equations in the spreadsheet QQ Sample Problem Exercise e Enter data in the Input Worksheet numbers in red in spreadsheet Select state Alabama and county Cullman Select a weather station Al Birmingham FAA QQ Sample Problem Exercise HO e Click Gully and Streambank Erosion button in BMPs Worksheet and enter data in the Gully amp Streambank Worksheet numbers in red in spreadsheet Watershed Gully Top Bottom Depth ft Length Years BMP Sol Textural Class Width Width ft to Form Effi OOO ft ft Gully1 _ Z EN 5 C ONT Watershed zo T HI T T at O Fine Sandy loam eS Stim Length Height Lateral Recession Rate Rate BMP Soil Textural Class Bank ft ft jahi ft yr diris rank s TOME NEN TEE Te 02 ol Clay T
4. GRTS Model Training US EPA Andrea Matzke Matzke Andrea epamail epa gov Tetra Tech Sabu Paul sabu paul tetratech com xj TETRATECH INC What Will You Learn e STEPL model 1 Create an Excel Model 2 Use BMP calculator e R5 model a simple Excel model not just for Region 5 e Special discussion BMP Efficiency Estimator Online data server Fe Part 1 STEPL What is STEPL e Calculates nutrient N P and BOD pollutants and sediment loads by land use type and aggregated by watershed e Calculates load reductions as a result of implementing BMPs e Data driven and highly empirical e A customized MS Excel spreadsheet model Simple and easy to use Formulas and default parameter values can be modified by users optional with no programming required Q STEPL Users e Basic understanding of hydrology erosion and pollutant loading processes e Knowledge use and limitation of environmental data e g land use agricultural statistics and BMP efficiencies e Familiarity with MS Excel and Excel Formulas Fe Process Sources Groundwater Cropland Runoff Urban NS Load before BMP gt Bmp gt Load after BMP Pasture Erosion Forest Sedimentation Feedlot gt Others r SIEP1 _ SIEP2 STEP 3 STEP 4 STEPL Web Site A EPA STEPL Spreadsheet Tool for Estimating Pollutant Loads Microsoft Internet Explorer
5. Select a state and a county for default USLE parameter values Modify the default USLE parameter values for local conditions especially the cover factor C and the supporting practice factor P to reflect the before and after treatment effects Please check which BMPs apply Please select a state and a county and default USLE parame A Agricultural Field Practices Users should use the local USLE parameter values if available State Count 7 Filter Strips Alabama Autauga Please fill in the gray areas below Example Before After Before After USLE ar RUSLE Treatment Treatment Treatment Treatment Rainfall Runoff Erosivity Factor F ee 69 LB B3 Soil Erodibility Factor St a Length Slope Factor LS 029 o o 044 Cover Management Factor L lt 1 01 o20 B4 oF U5 Support Practice Factor P 1 0 ns oss 0775 0 311 Predicted Avg Annual soil Lass ton acre year User must use the local C and or P values in red ta obtain the reduction due to the field practices Agricultural Practices Usage 2 e Enter contributing areas e g 50 acres e Select a soil texture e g silt Estimated Load Reductions for Agricultural Field Practices Treated Example _ Sediment Load Reduction ton year 97 85 Phosphorus Load Reduction Ib year 118 100 Nitrogen Load Reduction Ib yr 236 200 Estimated Additional Load Reductions through Filter S
6. 5 Ol QB5 CembnedBMPs 1 w2 Pastue Orj X 075 0 065CombinedBMPs S wi Foes 0 A U Combined BMPs W2Forest Qj Dj QU Commbined BMPs wi Usr Of Combined BMPs w2 User O of Coornbined BMPs Sample Problem Exercise e Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction lb 6909 5 Total Annual P Load Reduction lb 1920 5 Total Annual Sediment Reduction ton 980 3 Source with highest annual load contribution after BMP N load lb _ 2844 1 What source Feedlot P load lb 528 7 What source Cropland Sediment load lb 287 6 What source Cropland Fe Sample Problem Exercise e Inthe Input worksheet check the box next to Treat all the subwatersheds as parts of a single watershed e Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction lb 6184 3 Total Annual P Load Reduction lb 1641 3 Total Annual Sediment Reduction ton 753 6 Source with highest annual load contribution after BMP N load lb 2844 1 What source _ Feedlot P load Ib 483 79 What source Cropland Sediment load Ib 351 18 What source Cropland End of Problem Exercise 4 Try adjusting your input data and reexamine the results Sample Problem Exercise 5 e Generate a new custom spreadsheet
7. 074 25 C W M M M Ya E I Z r dt fi r i f fi ets NS LIS CITE MI TEE v FN RdL TP for C disk for W 5 0 032 0 061 Oq _ O amp 8 945 re 1 Estimate BMP Efficiency Using USLE C Value Generalized Values of Cover and Management Aabl ell East of the Rocky Mountains Stewart et al 1975 Crop rotation amp management b Productivity a Please use the abbreviation table below High Moderate COTTON c 27 Cot conv western plains 1 0 42 0 49 28 Cot conv south 1 0 34 0 40 MEADOW HAY 29 Grass amp legume mix 0 004 0 01 30 Alfalfa lespedeza or sericia 0 020 31 oweet clover 0 025 SORGHUM GRAIN western plains 32 RdL spring TP conv 1 0 43 0 53 33 No till pl in shredded 70 5096 re 0 11 0 18 SOYBEANS c 34 B RdL spring TP conv 1 0 48 0 54 35 C B TP annually conv 2 0 43 0 51 36 B no till pl 0 22 0 28 37 C B no till pl fall shred C stalks 2 0 18 0 22 WHEAT 38 W F fall TP after W 2 0 38 39 W F stubble mulch 500 Ib re 2 0 32 40 W F stubble mulch 1000 Ib re 2 0 21 41 Spring W RdL Sept TP conv ND SD 1 0 23 42 winter W RdL Aug TP conv KS 1 0 19 43 Spring W stubble mulch 750 lb re 1 0 15 44 Spring W stubble mulch 1250 Ib re 1 0 12 45 Winter W stubble mulch 750 Ib re 1 0 11 46 Winter W stubble mulch 1250 Ib re 1 0 10 47 W M conv 2 0 054 48 W M M conv 3 0 026 49 W M M M conv 4 0 021
8. DBank2 5 Mio 3 Severe 41n3 05 04 0 o Fine Sandy loam gt We SD lt lt lt lt Sample Problem Exercise 5 Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction Ib 20 0 Total Annual P Load Reduction Ib ____ 7 7 Total Annual Sediment Reduction ton ____ 13 8 End of Problem Exercise 5 Try adjusting your input data and reexamine the results BMP Calculator More Exercises for BMP Calculator Try different BMP trains in the BMP Calculator Note that you may define as many trains as you want and calculate each BMP train s combined efficiency at the same time in the same window You don t need to open a separate BMP window for each BMP train see illustration below nml xj BMP Calculator File Edit View Help Dag telang Load Area 100 000 N Eff 0 550 Load Area 100 000 Load Area 100 000 N Eff 0 485 N Eff 0 550 Load Area 0 000 N Eff 0 700 Load A 100 000 N Eff 0 700 Total Load Area 100 000 Total Load Area 300 000 N Eff 0 865 N Eff 0 803 P Eff 0 863 P Eff 0 833 BOD Eff 0 000 BOD Eff 0 000 Sediment Eff 0 913 Sediment Eff 0 785 Need of BMP Calculator e When is BMP Calculator needed N ptr Needed Each land use type BMP Calculator Example 1 BMP Calculator File Edit View Help Sus MEE Load or Srea 100 000 ipn M Eff 0 5
9. E 8 xj File Edit View Favorites Tools Help Back gt 9 Ai A Search 4 Favorites Media 3 G5 amp Ej Address http fit tetratech FFx com stepl Google Search Web Q Search Site News O Page Info EJUp Highlight U S Environmental Protection Agency STEPL Spreadsheet Tool for Estimating Pollutant Load Recent Additions Contact Us Print version Search EJ EPA Home STEPL j Home Welcome to STEPL and Region 5 model Link to on line Access STEPL Data Data server Server for Input Data Models and Documentation 3 Link to downloade Spreadsheet Tool for Estimating Pollutant Load STEPL employs simple algorithms to calculate nutrient and sediment loads from different land uses and the load reductions that would result from the implementation of setup program to various best management practices BMPs STEPL provides a user friendly Visual Basic vB interface to create a customized spreadsheet based model in Microsoft MS Excel lt computes watershed surface e install STEPL program and documents runoff nutrient loads including nitrogen phosphorus and 5 day biological oxygen demand BOD5 and sediment delivery based on various land uses and management practices For each watershed the annual nutrient loading is calculated based on the runoff volume and the pollutant concentrations in the runoff water as influenced by factors such as
10. IS A 4444444434145434 PAR prp a pt pt pt pt ptu DAN AN AAA AN TS EN IS O dit AAA VG HH EN AS A ES AAA IS AS IS Ac A AAA ii AA A OS AA AS A IN ON IN CAI SEs Periit ttt tears OOO tears CO A OO teeter 4444 44445454 eres Hie PARA ee Ce rra 205050909020 20 20202000 20 00 0 202 0202000202020 2050505029020 20 20202020 20 000 202 02020202000 00 O OS O 2050502090 02026 20 2090 90 9 0 0 O O O AAA A ttp pt tpt tpt cern DAN AS PA A AA TICO Ses a 52525 ae 25252 om Soo AN A TOO AAA AAA PETT A AS AAA AS AA AS A AS OO A Bst AS AAA AS AA AS A PS A AS PS AS OOOO Cees SSA Cees ees PS ees Heese EN cedet OS P ost BMP Loading Ibs yr 13 482 126 031 Ttt ettet HHI edet teet td edente tette edente teet tete edente teet tete ettet tt teet tet ettet teet t ettet teet tet ettet t teet te ettet t tette t tette tate daten AAA 4444145414341454 DA teda tea AAA DA ERA AAA tt DA ERA AAA AAA AAA IAEA EA AAA AAA AAA A Se e eS aee 994 94 Se O E A A A t JE SPF FFF AAA AAA p000000000000000 E 000000000000000 p000000000000000 PAF 4 4 44 FF tt tt p000000000000000 PPP PF 44 44 AAA AA tette tate atn ERA AAA AAA AAA Ttt ttt Mtt tette DIN DA tte atn eat Ae AS eh rrr e eh et e EE PARA RHEE AA AI APO AAA Xtra itte t t
11. Insert Format Tools Data Window Help STEPL iD EGeY gms oc HideJLInhide Other STEPL Sheets Precipitation Runoff Cata USLE Parameters by Land Use View Edit BMF List Precipitation Correction Factors Soil M and P About Tip To ensure that files are linked to the customized menu set Excel Default file location to C STEPL or D STEPL Step Tools menu gt Options submenu gt General tab Fe STEPL BMP Calculator e Describe schematically BMP configuration Number and linkages BMP type and efficiency Land use area e Calculate combined efficiency Add BMP box Calculate combined efficiency Use source area or original load as the weighting factor Delete Connection BHP Calculator sa E ea O Load Lrea 30 000 de Eft n Biel Ed ero Eff E d Draw Connectio L aadi amp rea 460 00t H Eff2 550 Move BMP bo Total Load 4 rea 90 000 H Ett 0 702 P Eft 0 624 COD Ett 0 0568 Sediment Eff 0 549 Ready NUM 2 New Features in 4 0 e Ability to specify different ways by Subwatersheds or Individual Project Area vs the Entire Watershed to calculate sediment delivery e Calculation of Gully and stream bank erosion e Calculation of groundwater and pollutant output Treat all the subwatershedsas parts of a single watershed F Groundwater load calculation Watershed Gully Top j Bottom Depth ft Length Years BMP Soil Textural Class Width
12. Inthe Input worksheet check the box next to Groundwater load calculation e Examine estimated load in Total Load and Graph worksheets and enter the results below Total Annual N Load Ib yr __ 5221 0 Total Annual P Load Ib yr 1065 2 Total Annual Sediment Load ton yr 428 5 Amount and source with highest annual load contribution N load Ib yr 2135 92 What source Feedlot P load Ib yr 292 95 What source Feedlot Sediment load Ib yr 101 52 What source Cropland End of Problem Exercise 1 Try adjusting your input data and reexamine the results QQ Sample Problem Exercise 2 For the same farm area estimate total annual load reduction assuming reduced tillage is practiced in cropland areas and Solids Separation Basin BMP on feedlots e Create a spreadsheet for this project or exercise Instead of generating a new custom spreadsheet using the ST EPL main executable program you will be using the spreadsheet in the previous exercise Save the spreadsheet used for Exercise 1 to save recent changes Save this spreadsheet with a new name exercise2 xls be sure to save the file as xls type This new spreadsheet will be used for Exercise 2 Q Sample Problem Exercise 2 e Enter new data in the Input Worksheet Note that all the input data entered in the previous spreadsheet are still valid Only modification is an additional BMP
13. Sample Problem Exercise e Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction Ib 2259 4 Total Annual P Load Reduction lb 558 4 Total Annual Sediment Load Reduction ton 304 6 Source with highest annual load contribution after BMP N load Ib 1388 3 What source __Feedlots P load lb 237 97 What source Cropland Sediment load lb 101 5 What source Cropland Note that load reductions have been calculated since BMPs have been already specified in the previous exercise For this exercise assume that the same BMPs are installed for all cropland and urban areas in the 8 digit watershed Sample Problem Exercise 3 Estimate total annual load and load reduction for a watershed that consists more than one farm where all croplands are practicing reduced tillage and filter strips Shown below and urban open spaces has LI D Bioretention Reduced tillage D 2 ae Assume all croplands is implementing the above BMP train ER Sample Problem Exercise 3 e Create a spreadsheet for this project or exercise Save the spreadsheet used in Exercise 2 to exercise3 xls Enter new data in the Input Worksheet User Feedlot Percent a EC NN S NEO Set Feedlots Paved 5 of months manure ION cane applie d a 83 Wastewater Direct No of Population Septic Direct Discharge Septic per Septic F
14. Tetra Tech Inc Falrfas V October 006 Number of Subwatersheds Select the number of subwatersheds Start Number of Special Sediment Sources in the Subwatersheds Gully formations E Impaired streambanks E Option for Initialization Set initial land Use areas and r Test STEPL model with animal numbers ta zeros non zero initial numbers Spreadsheet tool creation progress OK Cancel D 50 100 Click OK to create the spreadsheet tool in MS Excel About STEFL STEPL Spreadsheet ES Microsoft Excel TrainingDemo xls D Ioj x ai Fie Edit View Insert Format Tools Data Window Help STEPL Type a question For help 2 x ia tata za c 955g M i arial 10 B E SES 82M E A B AJ d f TC M aes B uif umeros eus chm valen F ISTEPL Input Sheet Values in RED are required input Change worksheets by clicking on tabs at the bottom You entered This sheet is composed of eight input tables The first four tables require users to change initial values The next four tables initial hidden co Step 1 Select the state and county where your watersheds are located Select a nearby weather station This will automatically specify valu Step 2 a Enter land Use areas in acres in Table 1 b enter total number of agricultural animale by type and number af months per year that r c enter values for septic system parameters in Table 3 and dif desired modify USLE parameters associated with the selected
15. Width ft to Form Efficiency ft m 0 1 Sle 5 1 0 5 o Clay Watershed Length Lateral Recession Rate Rate ft pande ftyr Effi iclency 0 1 mjBak 5 UORNANEITTEMEE D TIE 0 05 O03 oco RT Soll Textural Class Hands on Exercises Sample Problem Exercises e Exercise 1 Estimate total annual load for a specific farm and total load reduction resulting to implementation of a single BMP on croplands e Hypothetical watersheds based on Agricultural Statistics and NRCS data e Exercise 2 Similar to Exercise 1 but with multiple BMPs e Exercise 3 Similar to Exercise 1 but BMP trains implemented on croplands and a single BMP on urban land e Exercise 4 Similar to Exercise 1 but for multiple subwatersheds and BMP trains implemented on croplands and pasture land e Exercise 5 Hypothetical watersheds for demonstrating gully and streambank erosion QQ Sample Problem Exercise 1 Estimate total annual load for a farm in Cullman County in Alabama Agricultural Statistics of Alabama Number of Farms 45126 Cattles and calves farms 27094 Acreage of farms 8904387 Cattles and calves number 1437795 Average size of farm ac 197 Beef cows farms 23558 Median Size of farm ac 90 Beef cows number 765901 Total Cropland Number 32073 Mall bi 223 Totat Cropland Area ac 3732751 MK cows number 18939 Hogs and pigs fa
16. a preformatted report with A i gt Y NB T tables that you can paste directly into AZ NM a OK J the STEPL worksheets Calaveras dol Hims AL GA Y UT Colusa B TX J AL p Generates preformated reports using EX p Ue s A custom percentages of HUC surface area Or select aHUC 15030101 Havasu Maohave L 15030102 Piute Wash 15030104 Imperial Reservoir This tool can be used to estimate the landuse and animal distribution number 15030707 Lower Colorado of septic system and failure rate and hydrologic group for your area of 16040205 Smoke Creek Des 16040204 Massacre Lake m interest These information are required mput for the STEPL model The data are provided by HUCO overlay of county and 8 dizit hydrologic unit oundary E Zoom to Full Extent LE m 57 a L4 E Internet zl STEPL Online Input Data Server E amp TEPL Model Input Data Server Microsoft Internet Explorer provided by Tetra Tech Inc File Edit View Favorites Tools Help Back gt amp fat O Search Favorites Media i4 Es 32 Address l http hudson tetratech FFx com website stepl viewer htm Step 3 Activate the California al pe Select tool and Connecticut i click on the map to District of Columbia H refine the area of Delaware interest Step 4 Select report Generates a preformatted Aport with tables that you can paste direi in
17. equations in the spreadsheet QQ Sample Problem Exercise e Enter data in the Input Worksheet numbers in red in spreadsheet Select state Alabama and county Cullman Select a weather station Al Birmingham FAA QQ Sample Problem Exercise 4 e Enter data in the Input Worksheet numbers in red in spreadsheet cont d User Feedlot Percent p Cropland p Pavewd wW 1D CE w 39 39 8 58 0 78 o 0 245 of months manure Wastewater Population pti Direct Discharge per Septic Failure Discharge Reduction Rate Sample Problem Exercise 4 e Cropland in watershed 1 has the same BMP train as In example 2 e Cropland in watershed 2 has filter strip e Pastureland in both watersheds has filter strip Reduced tillage Filter strip Assume all croplands in watershed 1 is implementing the above BMP train Fe Sample Problem Exercise 4 e Cropland in watershed 1 has the same BMP train as In example 2 e Cropland in watershed 2 has filter strip e Pastureland in both watersheds has filter strip Benet uon land N P X jBOD Sediment BMPs Wi ums al 0 913 Combined BMPs Calculated 2 077 oo 05516 Filter strip 100 Watershed Watershed Combined BMP Efficiencies N PT BOD Sediment BMPs Wi Crp 0865 08635 U 0 913 CombinedBMPs w2Crp Combined BMPS Wi Pastue O7 Q
18. results below Total Annual N Load Ib yr 4699 1 Total Annual P Load Ib yr 1042 7 Total Annual Sediment Load ton yr 428 5 Amount and source with highest annual load contribution N load Ib yr 2276 2 0 What source Cropland P load Ib yr 705 6 What source Cropland Sediment load lb yr _ 406 1 What source Cropland Note that load reduction 0 since you have not specified any BMP yet see next slide Q sample Problem Exercise 1 For the same farm area estimate total annual load reduction assuming reduced tillage is practiced in cropland areas e Enter BMP data in BMPs worksheet n Table 1 which is for cropland areas select Reduced Tillage System under BMP column Note that initial values of BMP efficiencies are automatically specified with the selected BMP QQ Sample Problem Exercise 1 Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction ID 1511 8 Total Annual P Load Reduction lb 467 6 Total Annual Sediment Load Reduction ton 304 6 Source with highest annual load contribution after BMP N load lb 2135 9 What source __Feedlots P load lb 292 9 What source __ Feedlots Sediment load lb 101 5 What source __Cropland End of Problem Exercise 1 Try adjusting your input data and reexamine the results Fe Sample Problem Exercise 1 e
19. the initial BMP efficiencies if local data are available If your BMP is not in the selection list you may use STEPL View Edit BMP List menu to add your BMP to the database please refer to the user manual Sample Problem Exercise e Examine estimated load reduction in Total Load and Graph worksheets and enter the results below Total Annual N Load Reduction Ib 9929 3 Total Annual P Load Reduction lb 2833 4 Total Annual Sediment Reduction ton 1340 0 Source with highest annual load contribution after BMP N load Ib 3952 4 What source Feedlot P load lb 658 6 What source X Feedlot Sediment load lb 127 7 What source Cropland End of Problem Exercise 3 Try adjusting your input data and reexamine the results Sample Problem Exercise 4 e Generate a new custom spreadsheet Similar to exercise 1 create a new spreadsheet but specify two watersheds this time Program gt STEPL gt STEPL Select options For Exercise 4 specify the following e Specify number of watershed 2 e Select first option under Option for Initialization default selection Set initial land use areas and animal numbers to Zeros Click ok to create new spreadsheet Click ok to the following message box Save the spreadsheet using a new file name e For this example you may save it to exercise4 xls When the new spreadsheet is opened click Ok button to enable stored formulas
20. 50 Load or rea 0 000 M Ett 0 700 Each box represents 100 ac Load or 4rea 0 000 M Ef 0 000 Total Load or 4rea 200 000 M Eff20 433 P Ett 0 431 Filter Strip COD Eff 0 000 Sediment Eff 0 456 BMP Calculator Example 2 BMP Calculator File Edit View Help Load ar rea 1 00 000 M Eft 0 000 Load or Srea 100 000 M Eff 0 000 Each box represents 100 ac Load or rea 0 000 M Ett 0 700 Total Load or 4rea 200 000 M Eft 0 700 P Eft 0 750 COD Ett 0 000 Sediment Effz0 774 Filter Strip BMP Calculator Example 3 BMP Calculator AE File Edit View Help A Ls Each box represents 100 ac Load ar rea 100 000 Load or rea 100 000 M Eff 0 850 M Eff2D 1060 F 0 650 Load ar 24rea 0 000 M Eff 0 000 Total Load or rea 200 000 M Eff 0 475 P Eff 0 450 COD Eff 0 150 Sediment Eff 0 775 NUM oZ Adding BMP Data Add New Data to BMP List e n STEPL customized menu click View Edit BMP List e BMPList worksheet is shown add or delete BMPs Ed Microsoft Excel Sample xls File Edit View Insert Format Tools Data Window Help STEPL Customized menu D H i ela FIA Em ct kI E Hide Unhide Other STEPL Sheets T e Precipitation Runoff Data USLE Parameters by Land Us View Edit BMP List BMP Calculator Precipitation Correction Factors Soil M and P About Landuse BMP amp Eff IM F BOD sediment Cropland Cropland 0 Mo
21. BMP Cropland Combined Example New data inserted Cropland Contour Fz 185 0 55 ND 0 405 h Cropland Diversion 0 1 0 3 ND 0 35 ere Cropland Filter strip 0 7 0 75 ND 0 65 Cropland Reduced T 55 0 45 ND 75 Cropland Streambar 0 75 0 75 ND 0 75 Cropland Terrace 0 2 0 7 NO 0 05 Pastureland PasturelanO No BMP asturelan User Defin STEPL Add New Data to BMP List Se L A AA ae 2 A ce n Landuse BMP amp Efficien N P BOD Sediment Instruction Update BMP button Cre i land sese s Dont Delete 1 Do not delete the grey ed rows ropland NoBHP 0 0 0 0O lt DontDelete 2 BMP efficiencies should be 1 Cropland _ Combined BMPs Calculated OF OF 0 0 3 If y ou add a row for a new BMP you BMPList worksheet Cropland Contour Farming must specify landuse BMP name and Cropland Diversion pollutant removal efficiencies Cropland MULA Or no daa Cropland T EEE A ae Cropland E T E Cropland EME Leto tons at fles art Pastureland L O ben Delete BME St to etemal t Pastureland 0 No BMP O 0 0 O lt DontDelete Pastureland Combined BMPs Calculated 0 0 0 Pastureland poU gent Delete Forest No BMP 0 O ME Dont Delete e EMP Dua New BMP added New BMP added e Click Update BMP Data button to update the BMP selections in the BMPs worksheet e Click Save Updates to save chan
22. Brush brush weeds grass mixture Poor b 48 67 77 83 with brush the major element Fair 35 56 70 77 Good 30 48 65 73 Woods grass combination Poor 57 73 82 86 orchard or tree farm c Fair 43 65 76 82 Good 32 58 72 79 Woods Poor d 45 66 77 83 Fair 36 60 73 79 Good 30 55 70 77 Farmsteads buildings lanes driveways and surrounding lots 59 74 82 86 a Poor 50 ground cover or heavily grazed with no mulch Fair 50 to 75 ground cover and not heavily grazed Good gt 75 ground cover and lightly or only occasionally grazed b Poor lt 50 ground cover Fair 50 to 75 ground cover Good gt 75 ground cover c Estimated as 50 woods 50 pasture d Poor forest lifter small trees and brush are destroyed by heavy grazing or regular burning Fair woods are grazed but not burned and some forest lifter covers the soil Good Woods are protected from grazing and litter and brush adequately cover the soil Estimate Runoff Changes Using Curve Number Ill Runoff Curve Numbers Antecedent Moisture Condition Il for Arid and Semiarid Rangelands Soil Conservation Service 1986 Hydrologic Soil Hydrologic Land Use Cover Condition Group A B C D Herbaceous grass weeds amp low Poor a 80 87 93 growing brush brush the minor Fair 71 81 89 component Good 62 74 85 Oak aspen oak brush aspen Poor 66 74 79 mountain mahogany bitter brush Fair 48 57 63 maple and other brush Good 30 41 48 Pinyon juniper pinyon j
23. ailure Discharge Reduction Watershed Systems System _ Rate 2 of wi 50 0 238 0 87 Sample Problem Exercise 3 e Examine estimated load in Total Load and Graph worksheets and enter the results below Total Annual N Load Ib 17015 2 Total Annual P Load lb 4108 5 Total Annual Sediment Load ton 1526 7 Source with highest annual load contribution N load lb 11208 3 What source Cropland P load lb 317 6 6 What source Cropland Sediment load lb 1467 7 What source Cropland Fe Sample Problem Exercise 3 e Enter BMP data in BMP worksheet n Table 1 which is for cropland areas select Combined BMP calculated under BMP column to indicate that we have a Reduced Tillage Filter Strip BMP train in croplands Note that the N P BOD and Sediment BMP efficiencies remained zero If you have the combined efficiency values for this particular BMP train enter them in Table 7 number in red These values will be reflected in Table 1 and in other tables 1 e if the same BMP train is implemented for other land uses f you do not have the values you may use the BMP calculator next step Q Sample Problem Exercise 3 e Use BMP Calculator to estimate combined efficiencies of the BMP train Run the BMP Calculator by selecting the STEPL BMP Calculator menu of the STEPL spreadsheet If the ined or Aree oo DOR system cannot find the BMP Calc
24. cour Step 3 You may stop here and proceed to the BMPs sheet If you have more detailed information on your watersheds click the Yes button in Step X a Specify the representative Soil Hydrologic Group SHG and soil nutrient concentrations in Table 5 b modify the curve number tak c modify the nutrient concentrations mad in runoff in Table F and d specify the detailed land use distribution in the urban area in T Step 5 Select BMPs in BMPs sheet Step 6 View the estimates af loads and load reductions in Total Load and Graphs sheets Show optional input tables YES No Treat all the subwatershedsas parts of a angle watershed Groundw State Coul Feedlot Percent a unu m f Watershed Cropland Forest Defined Feedlots Paved 0 24 a 32 329 3 39 10 7 0 24 ws o J o mof zooj oaj 10 o oza BMPs A Total Load Graphs Weather Station for rain correction factors O Default r O E m d ww m SO NEM Composed of four worksheets BMPs Worksheet MAA 000 Bediment _ BMPs O wi BP 0 55 ND 115 Ot D EA 100 ZZ E E a SAA 6 o 0 No BMP 100 Each land use type within each watershed can have a separate BMP Also it can be partial application Watershed N Load no P Load no BOD Load Sediment N Reduction P Reduction BOLD Sediment BMP BMP no BMP Load no Reduction Reduction BMP ibvyear Ibvyear_ Ibvyear__ t yea
25. erofYears pp Sol Weight tans ft3 sol P Conc Ib Ib soili en Soil N Conc lb lb soi k a non f nat using the default values users must provide input In red for Total P and Total M soil concentrations Estimated Load Reductions BMP Efficien Gull y Sediment Load Reduction ton year 10 287 1D Phosphorus Load Reduction Ib year 287 TB Nitrogen Load Reduction Ib yr o 8S4 18 5 5 BMP efficiency values should be between and 1 and 1 means 100 pollutant removal efficiency Gully Stabilization e Load Average annual erosion during the life of the gully t y Volume x Soil Weight Years Nutrient load Annual Erosion x Soil Nutrient Conc x Correction Factor e Load Reduction after implementing gully stabilization Specify reduction efficiency 100 efficiency by default Reduction is equal to annual erosion x user specified efficiency Volume Top Width Bottom Width x Depth x Length 2 Gully Erosion Nutrient Correction Factor e Correction Factor Smaller soil particles gt larger aggregated surface area gt more nutrients attached Soil Texture Clay sit Sand Peat Stream Bank Erosion Calculation e Select a soil texture e g silty clay e Enter the dimensions of the eroding stream banks Please fill in the gray areas below Parameter Bank Bank Example Length ft Height ft Lateral Recession Rate f
26. ette tete PA PAS DAS AN PARAR Ponle Ss Settee ICAIC Hd HA Hd O A O See Tees pale TAE See DON TARA AIN ARA AN ARA AN DI AN AS pA pt pt pt pt a a AN AAA ON AAA IN AAA A AAA DION HHG 4444 SS ettet ttd ftetit teat teet te iet tte dte t idet ten tete tet ident teta Paca fien Er PAPA AAA AAA DN AAA DN AAA DN AAA DN Hd PRA preteen M d HA AAA PA AAA PA AAA PA FAA Hees A PA A ud Sees nnt DON AAA DON AAA AAA DON DIS AN DIS DESEO AS Pi nner A AAA A CA AA AS DO DS DA tt PA Pu a AMAA APO AAA Xt Titae tan Xt tette idet tette tt idet tea Tide FE Md ftetit tea ten teet tette fatear Serato ce ftetit teda tn DIS A DIAS DI TS PARA M A See A See A See DIN FAA IN A System calculates load using default BMP efficiencies Load Reduction Ibs yr 17 158 999 219 Region 5 model vs STEPL 1 e Region 5 model Calculates load at the source level Sources are independent no relationship between worksheets e SIEPL Calculates load for different sources at source and watershed level Sources are related in watershed User can specify and update BMP list BMP calculator for complex BMP arrangements QQ Part 3 Special Discussion BMP Efficiency Estimator e Simple calculator to estimate BMP efficiency for non structural BMP e Estimates effic
27. ges to text files comma delimited Cor D Stepl Support AlIBMPstepl csv C or D Stepl Support AlIBMP csv Part 2 Region 5 Model R5 model is not limited to Region If controls of the model does not workset EXCEL gt Tools gt Macro gt Macros gt Security to Medium A B C D E F G H Estimating Load Reductions For Agricultural and Urban BMPs This workbook uses the Pollutants Controlled Calculation and Documentation for section 319 Watersheds Training Manual Michigan Department of Environmental Quality June 1999 to provide a gross estimate of sediment and nutrient load reductions from the implementation of agricultural BMAP The methodology far the gross estimate of sediment and other constituent load reductions from the implement Urban BMPs is based on reduction efficiencies and calculations developed by Illinois EPA OO 4 Y A te 4 Please note This workbook uses many simplifying assumptions to provide a general ESTIMATE of 10 pallutant load reductions through BMP implementation More accurate results of pollutant load reductions 11 may be obtained through direct monitoring and or a more detailed modeling application In addition 12 this workbook does not estimate pollutant load reductions for dissolved constituents 14 The workbook is divided inta worksheets see bottom of the Window Each worksheet is specific to 15 a particular source In some cases multiple practices may take place for a spec
28. iency due tochanges in cropping patterns or soil Support practices Models and Documentation e BMP Efficiency Calculator New Last updated 09 24 2006 Please send your comments ta STEPL support o BMP Efficiency Calculator 1 0 Package Fe BMP Efficiency Estimator contd ES Microsoft Excel BHP eff estimator 082005 xls r i O X File Edit wiew Insert Format Tools Data Window Help Calculator Type a question for help X NeW prer EA E a T E 10 OB i e 3 al it ay gt zi zh Ba Ve Reply with Changes End Review E Arial 10 B 7 Uj E m m BS gt FEN AA 515 F A B C D E F EE ST Help hy Pasture Improvement STEP 2 258 rax o VA WASHINGTN DC NATLAP m e ITI T _ o m T Ca SHGB SHGC SHGD g CT STEP 4 Continuous fallow tilled up and down slope Mo Support Prac Cornfsilage VVheat Residues left fall turn plowed 2 year rotation Mo Support Sediment My Pasture Improvement 0 65 0 434 Oo OO Oo A RARA RA ROEI RIRDJIRIIRSIRI cal ca ka gt fe WRJ T 00 24 001 ep Sm 0 oo Sy Cn Coy Sm ca Id 4 k M Calculator la cin Ready E Other Alternative Load Models Simple Field or Land Event or Data Level of Watershed Use Continuous Reqts Effort Simple Watershed Urban N P Event AA Method FHWA SLOSS Both Rural P Sed Even
29. ific site then the various 16 worksheets will all need to be completed one worksheet must be completed for each BMP 17 The following are the worksheets and what practices they cover 18 Region 5 model 18 Worksheet Possible Practices sully Stabilization Grade stabilization Structure has five functional Grassed Waterway Critical Area Planting in areas with gullies Water and Sediment Control Basins 24 Bank Stabilization Animal Trails and Walkways 25 Stream Channel Stabilization a Streambank Protection worksheets Prescribed Grazing Residue Management Mulch Till Conservation Crop Rotation Conservation Cover Cover and sreen Manure Critical Area Planting Stripcroppina Con i S ngcroppinag ll CIC N ly Stabilization i Bank Stabilization i Ag Fields amp Filter Strips Feedlots i Urban Runoff 7 Region 5 Load Estimation Model e Introduction Provide a general estimate of pollutant reduction at the source level Initially developed by Indiana Department of Environmental Management I DEM based on Michigan DEQ s pollution control manual for section 319 watersheds rr Gully Streambank Agricultural Fields Feedioi Urban Rurof Gully Erosion Calculate Load Reduction e Select a soil texture e g sand loamy sand e Enter gully dimensions and the number of years since the gully formed Please fill in the gray areas below Parameter _ Guly Example Mumb
30. l surface covered by residue mulch after new crop seeding xx yy re xx cover for high productivity yy for moderate RdR residues corn stover straw etc removed or burned RdL residues left on field on surface or incorporated TP turn plowed upper 5 or more inches of soil inverted covering residues Estimate BMP Efficiency Using USLE P Value Table Values of Supporting Practice Factor P Stewart et al 1975 Practice Slope 1 1 2 2 1 7 7 1 12 12 1 18 18 1 24 No support practice 1 00 1 00 1 00 1 00 1 00 Contouring 0 60 0 50 0 60 0 80 0 90 Contour strip cropping R R M M a 0 30 0 25 0 30 0 40 0 45 R W M M 0 30 0 25 0 30 0 40 0 45 R R W M 0 45 0 38 0 45 0 60 0 68 R W 0 52 0 44 0 52 0 70 0 90 R O 0 60 0 50 0 60 0 80 0 90 Contour listing or ridge planting 0 30 0 25 0 30 0 40 0 45 Contour terracing b 0 6 n 0 5 n 0 6 n 0 8 n 0 9 n a R 2 row crop W fall seeded grain M 2 meadow The crops are grown in rotation and so arranged on the field that row crop strips are always separated by a meadow or winter grain strip b These factors estimate the amount of soil eroded to the terrace channels To obtain off field values multiply by 0 2 n number of approximately equal length intervals into which the field slope is divided by the terraces Tillage operations must be parallel to the terraces For example Contouring will reduce sediment by 10 40 depending on slope Estimate Runoff Changes Using Curve Number R
31. le Swin Swine Hog g Sheep Horse Chicken Turkey Duck 141 88 o 0 00 o 0 00 0 0 01 o 0 00 o 0 00 ps1 ps3 p n he h4 fo 72 4 Z fo foo poo go po 7 7968 2 28569 f 113759 f 16339 f 1871 2 2540 3 223938 D 1 1056600 o 60 1600 00 500 00 lo 0 00 o 0 00 4 48 16 2 000 00 4 4300 00 7970 friso 2697 503 V 930 25437 p 3 00 000 o0 00 000 000 E 8290 D D o 0 lo o 2 0 51299 97 3129997 2 27500 00 o lo 0 00 4 454 38 1 169060 00 0 5 58600 00 8427 D D 72 F F SaO DB on a ias ID No of Septic Systems Population per Septic System Septic Failure Rate O O B Felco D Gaol Or SS E 7968 18862 2 81 38 Toa 42265 1580951 D 4478422 _ _ me B o EOS PE STEPL Discussion e Watershed vs subwatershed STEPL model is not limited to subwatershed can apply to farms scenarios etc Watershed size make the subwatershed small enough to reflect BMP effectiveness You want to know the reduction at the local subwatershed level Sum of loads from subwatersheds z load at the watershed outlet because of the transport loss in the main stem Local weather data How to use the user defined land use Septic failure rate clarification Add new BMPs to the list Small treated area vs large watershed R5 100 efficiency assumptions e Estimate BMP efficiencies using USLE tables Some useful data Estimate BMP Efficiency Using USLE C Value Generalized Values of Cover and Managemen
32. r_ Ibvyear_ Ibv year lb year t year wi 9888 8 615 6 608823 3429 66 33a WAY Ar w2 39er9Bp 56122 608642 3300 00 oo 00 00 ws _39679 8 __8612 2 __60864 2 __ sao oo oo oo on Total 1196484 168399 1826108 1088 8 amp 6 a3 wail 47 Each row of results corresponds to a different watershed or project F0000 000 0000 000 50000 000 40000 000 S0000 000 0000 000 10000 000 0 000 Graphs Worksheet 338 250 M Load with BMP 338 200 lbtyr 338 150 Bl P Load with BMAP 338 100 Ibryr 332 050 O EOD Load with EP 338 00 337 350 337 900 337 850 337 800 Urban H Cropland O Fastureland O Forest H Feedlots O User Defined B Septic a Gully H Streambank a Groundwater Sediment Load by Watersheds with BMAP tyr O Sediment Load by Watersheds with BMF tiyr Total F Load by Land Uses with BRIR bryr A Urban B Cropland O Fastureland O Forest B Feedlots O User Defined B Septic O Gully H Streambank a Groundwater STEPL BMP Calculator e Calculates combined efficiency of a BMP train for a given land use The use of BMP calculator requires the understanding of BMPs and their placement in the watershed Reduced tillage Series Parallel Conventional Reduced tillage tillage Filter strip A od Conventional Reduced tillage tillage Settling Basin Customized Menu Ed Microsoft Excel Sample xls 1647 File Edit View
33. ributing drainage area in acres wered Unsewered Com mercial Industrial Institutional Transportation Multi Family Residential Agriculture Vacant Open Space Note Storm sewers Urban Pollution Reduction Load Reduction Select BMP for the selected BMP re BMP oading Ibs yr BOD 30640 234 750 681 250 ac 755 D e e 35 e e Lo DWUM 6 U Removal Efficiency for the particular BMP and constituent unavailable A 2 5 Ses 5 3292 55 Behe Ses Se T o 2 5 Ses T o Se Set T o lt gt 5 Se o SS A rrt Se 5 Se A o Se Se Ses Se A o o o gt o o Se A Ses o 28 PEE TER AS CLXXI AAA IA AS A AAA AAA AAA a A LOCI O de d 4 A S O A A A A AAA AAA AAA AAA AAA AAA 0000000000000 D000000000000000 0000000000000 D000000000000000 00000000000 00CX I D000000000000000 2200000000000 0CX I tette ttt tte Hte t Vett NINI HIHIH tte Patet Vietata tt EEEIEI EEA A AT AAA AS AAA EE HET HER ea 4 0505 Ses Recerca ts AAA AAA AAA Att AI A A A A AS OA NS Bst VERE EH EH EE n EH ERE ee TER AAA da AAA A 444 4 4 0062 0606062606062 4 tt td 252 50 52 52 36 54 36 34 96 34 96 34 36 32 301 L6 26 26 26 20 20 26 26 26 26 26 20 26 20 20 20 Pu AME 909000202090 409090209 9 9020 Hed ttt Vetere a A IS A IS A
34. rms Hogs and pigs number Sheep and lambs farms Sheep and lambs number Harversted Cropland Number 23327 Harversted Cropland Area ac 1995139 Based on 2002 Census of Agriculture USDA National Agricultural Statistics Service Agricultural Statistics of Cullman County Average Farm Size ac 101 Average Cropland Size ac 64 2 Animal Total Average Beef Cattle 39 018 28 58 Dairy Cattle 1 962 140 14 owine Hog 152 11 69 sheep 508 25 4 Chicken 1 572 552 14427 08 Based on 2002 Census of Agriculture USDA National Agricultural Statistics Service Sample Problem Exercise 1 e Generate a new custom spreadsheet Note that you may reuse a spreadsheet you created previously for a different project Click Start button e g normally located at the Windows bottom left corner then Program STEPL and STEPL to run the STEPL main executable program stepl exe in STEPL folder and display main interface Select options For Exercise 1 specify the following e Specify number of watershed 1 e Select first option under Option for Initialization default selection Set initial land use areas and animal numbers to Zeros Click ok to create new spreadsheet Click ok to the following message box Save the spreadsheet using a new file name e For this example you may save it to exercisel xls When the new spreadsheet is opened click Ok button to enable stored formulas equations in the spreadsheet Fe
35. t PHOSPH Watershed Both Both P_ ____ jEvent Simple Medium Medium _ Reference List of alternative load and load reduction models STEPL Web site Fe Other Alternative Load Models Mid Range Field or Land Event or Data Level of Watershed Use Continuous Reqt s Effort IAM Both Rural N P Sed Both Detailed Medium Medium to High to High GWLF Both Both N P Sed Both simple Lowto Low to Medium Medium Other Alternative Load Models Detailed Field or Land Event or Data Level of Watershed Use Continuous Reqts Effort DetalliedoComplex O ANSWERS Both Rural N P Sed Both Detailed Medium Medium to High to High to High to High to High to High WEPP Both Rural Sed Continuous Detailed Low to Low to Hiah Hiah STEPL Online Input Data Server ONLY FOR PRACTICE J STEPL Model Input Data Server Microsoft Internet Explorer File Edit View Favorites Tools Help AY Back gt x E CA y Search x Favorites mL i gt Lj rel Address El http bering betratech FFx com websitefstepl viewer htm T Step 3 Activate the California rM SEE i m oo Es ang Colorado h 3 Connecticut PRA i lun er ME alis Sn E de District of Columbia 2 AD pc 2 a refine the area of Delaware OR Man I wv interest Florida ll Step 4 Select report m 7f TN ad A P N C 3 J Generates
36. t Lable lL East of the Rocky Mountains Stewart et al 1975 Crop rotation amp management b Productivity a Please use the abbreviation table below High Moderate Continuous fallow tilled up and down slope 1 00 1 00 CORN 1 C RdR fall TP conv 1 0 54 0 62 2 C RdR spring TP conv 1 0 50 0 59 3 C RaL fall TP conv 1 0 42 0 52 4 C RdR wc seeding spring TP conv 1 0 40 0 49 5 C RdL standing spring TP conv 1 0 38 0 48 6 C fall shred stalks spring TP conv 1 0 35 0 44 7 C silage W RaL fall TP 2 0 31 0 35 8 C Rd L fall chisel spring disk 40 30 re 1 0 24 0 30 9 C silage W wc seeding no till p1 in c k W 1 0 20 0 24 10 C RdL W RaL spring TP 2 0 20 0 28 11 C fall shred stalks chisel p1 40 30 re 1 0 19 0 26 12 C C C W M RdL TP for C disk for W 5 0 17 0 23 13 C Rd L strip till row zones 55 40 re 1 0 16 0 24 14 C C C W M M RdL TP for C disk for W 6 0 14 0 20 15 C C W M RdL TP for C disk for W 4 0 12 0 17 16 C fall shred no till pl 70 50 re 1 0 11 0 18 17 C C W M M RaL TP for C disk for W 5 0 087 0 14 18 C C C W M Rd L no till pl 2nd 3rd C 5 0 076 0 13 19 C C W M RdL no till pl 2d C 4 0 068 0 11 20 C no till pl in c k wheat 90 70 re 1 0 062 0 14 21 C C C W M M no till p1 2d amp 3rd C 6 0 061 0 11 22 C W M RdL TP for C disk for W 3 0 055 0 095 23 C C W M M RdL no till pl 2d C 5 0 051 0 094 24 C W M M RaL TP for C disk for W 4 0 039 0
37. t vri Soil Weight ftang ft3 0 0425 0 0425 AU USER opil P Cone blb soh 0 0005 0 0005 0 0005 Soil N Conc Ib lb soi 0 001 0 001 f nat using the default values users must provide input In red tor Total P and Total M sail concentrations Lateral Recession Rate LRA is the rate at which bank deterioration has taken place and ls measured in feet per year This rate may not be easily determined by direct measurement Therefore best professional judgement may be required to estimate the LER Please refer to the narrative descriptions in Table 1 Estimated Load Reductions BMP BMP Efficiency Efficiency Bank 1 E He 14 FP E sediment Load Reduction ftonsyear A 425 5 425 5 Phosphorus Load Reduction Ib yea f as ss Nitrogen Load Reduction Ib 850 eso 300 BMP efficiency values should be between and 1 and 1 means 100 pollutant removal efficiency Stream Bank Erosion e Load Channel Erosion Length Height Lateral Recession rate Soil weight e Load Reduction Load Load reduction efficiency Determining Lateral Recession Rate by Field Observation Lateral Recession Category Description Rate ft yr 0 01 0 05 Slight Some bare bank no gr roots 0 06 0 2 gc 0 3 0 5 Severe Bank is bare with exposed roots 0 5 Very Severe Bank is bare with fallen trees Agricultural Practices Usage Check BMPs Agricultural field practices and filter strips check both
38. the land use distribution and management practices The annual sediment load sheet and rill erosion only is calculated based on the Universal Soil Loss Equation USLE and the sediment delivery ratio The sediment and pollutant load reductions that result from the implementation of BMPs are computed using the known BMP efficiencies Region 5 model is an Excel workbook that provides a gross estimate of sediment and nutrient load reductions from the implementation of agricultural and urban BMPs The algorithms for non urban BMPs are based on the Pollutants controlled Calculation and documentation for Section 319 watersheds training manual Michigan Department of Environmental Quality June 1999 The algorithms for urban BMPs are based on the data and calculations developed by Illinois EPA Region 5 model does not estimate pollutant load reductions for dissolved constituents Questions Please contact STEPL support Navalnnod far FDA Cffiea nf Viator E E Done T 1 Internet Start e EAS 4532 0 Current g Microsoft PowerPoint 4 JEPA STEPL Spre 989b fg ETIEOS 11 39 AM Temporary URL http it tetratech ffx com stepl until moved to EPA server STEPL Main Program e Run STEPL executable program to create and customize spreadsheet dynamically X STEPL Spreadsheet Tool for the Estimation of Pollutant Load Versian 4 0 with BMP calculator Developed for US Environmental Protection A Es Agency by
39. to gA TO the STEPL worksheets 8052 step 2 Select a county y mem Calaveras y TUE Custom BSET Colusa l BGRS Generates preformated report Sinks custom percentages of HUC surface ares 8459 8819 18040003 San Joaquin Delta E 3 8850 18040004 Lower Calaveras h ad 330 15040005 Lower Cosumnes L This tool can be used to estimate the landuse and animal distribution number of septic 18040006 Upper San Joaquiry system and failure rate and hydrologic group for your area of interest These information are required input for the STEPL model The data are provided by HUCO overlay of county and 8 digit hydrologic unit boundary Map 2175216 31 1958242 66 Image 157 6 ScaleFactor 221 79810132759712 Internet E Note Zoom in further to display polygon I Ds Data is available at HUC and county Intersection HUCO Polygon Generate data Summaries STEPL Online Input Data Server Basic Report Data is summarized by HUCO polygon Polygon ID Urban Transportation Cropland Pasture Rangeland Forest User Defined Feedlots Water Others 7951 1000 00 200 00 5580000 2060000000122 1000 00 200 00 7968 61900 00 273100 00 267400 00 5500 00 10 00 348 00 110300 00 43300 00 7970 110000 133500 0031400 00 1400 00 0 00 55 4 3600 00 10800 00 8280 10 90 10 00 81 72 10 00 10 00 10 00 10 00 10 00 8380 6711 000 610711 o ooo 03 Q0 foo P Polygon ID ID Beef Cattle Dai airy Catt
40. trips Filter Strip Filter Strip Efficiency Treated Sediment Load Reduction ton year 065 416 Phosphorus Load Reduction Ib year Nitrogen Load Reduction Ib yr Total Estimated Load Reductions Sediment Load Reduction ton year Phosphorus Load Reduction Ib year Nitrogen Load Reduction Ib yr na 114 Note This worksheet is also applicable to other cases mining construction sites when USLE is used Q Feedlot Pollution Reduction e Load Enter a contributing area e g 1 74 acre Specify the percentage of paved area e g 75 100 Select state and a county Pennsylvania Lycoming Select Weather Station NY New York Central Park Enter animal count for each type Animal Numbers Animal Type Design Weight Feedlot Pollution Reduction e Load Reduction Select a feedlot best management practice e g waste management system System calculates load reduction using pre assigned BOD P N efficiencies for the selected BMP Estimated Load and Load Reductions Load before Load Load after BMP Reduction Biochemical Oxygen Demand load Ibs yr 8 598 Phosphorus load Ibs yr 848 Nitrogen load Ibs yr 7 239 9 791 1 448 Pollutants Urban Pollution Reduction e Load Enter size acres of storm water sewered and unsewered areas for each urban land use subclass System calculates load using default unit loads for each land use sub class Please enter landuse of cont
41. ulator program navigate to STEPL folder and select BMPCalculator exe Using the BMP Calculator interface do the following refer back to slide 13 for steps in using BMP lox File Edit wiew Help Calculator e Add two BMP boxes one each for Reduced Tillage and Filter Strip h Effz 7n e Enter BMP information type area etc for each BMP box Eff 0 750 by double clicking the box Question What is the area associated with the filter strip e Specify the connection between the two BMPs Question e Which BMP should be upstream You may move the P Eff 0 863 boxes to make them more readable COD Eff 0 000 e Calculate the combined efficiencies for N P BOD and ARAPE SHEU Sediment 0 865 0 863 ND 0 913 e Enter the combined efficiencies in Table 7 of STEPL spreadsheet Note the efficiencies are reflected in Table 1 Sample Problem Exercise 3 e Click Urban BMP Tool Select Open Space under urban land use options gt Select LI D Bioretention under Available LI D BMP gt Click Apply LI D BMP Set Urban LID BMP Select a Watershed 1 Select an Urban Land Use ommercia C Institutional C Transportation Multi Family C Single Family Urban Cultivated vacant Developed Open Space Select LID BMP Available LID BMP LID BMP Area ac Total Available Area ac 5 00 v simple Form Reset All Apply LID BMP Exit You can always manually change
42. uniper or Poor 75 85 89 both grass understory Fair 58 73 80 Good 41 61 71 Sagebrush with grass understory Poor 67 80 85 Fair 51 63 70 Good 35 47 55 Desert scrub saltbush greasewood Poor 63 77 85 88 creosotebrush blackbrush bursage Fair 55 72 81 86 palo verde mesquite and cactus Good 49 68 79 84 a Poor lt 30 ground cover litter grass and brush overstory Fair 30 to 70 ground cover Good 70 ground cover Estimate Runoff Changes Using Curve Number IV Runoff Curve Numbers Antecedent Moisture Condition Il for Urban Areas Soil Conservation Service 1986 Hydrologic Soil Hydrologic Land Use Cover Condition Group A B C D Open space lawns parks golf courses cemeteries etc Poor condition grass cover lt 50 68 79 86 89 Fair condition grass cover 50 75 49 69 79 84 Good condition grass cover gt 75 39 61 74 80 Impervious areas Paved parking lots roofs driveways etc 98 98 98 98 Streets and roads Paved with curbs amp storm sewers 98 98 98 98 Paved with open ditches 83 89 92 93 Gravel 76 85 89 91 Dirt 72 82 87 89 Western desert urban areas Natural desert landscaping pervious areas only 63 17 85 88 Artificial desert landscaping impervious weed barrier desert shrub with 1 2 in sand or gravel mulch and basin borders 96 96 96 96
43. unoff Curve Numbers Antecedent Moisture Condition Il for Cultivated Agricultural Land Soil Conservation Service 1986 Land Use Cover Hydrologic Condition A B C D lt Soil Hydrologic Group Fallow Bare Soil 77 86 91 94 Crop residue cover CR Poor 76 85 90 93 Good 74 83 88 90 Row Crops Straight row SR Poor 72 81 88 91 Good 67 78 85 89 SR CR Poor 71 80 87 90 Good 64 75 82 85 Contoured C Poor 70 79 84 88 Good 65 75 82 86 C CR Poor 69 78 83 87 Good 64 74 81 85 Contoured amp terraced C amp T Poor 66 74 80 82 Good 62 71 78 81 C amp T CR Poor 65 73 79 81 Good 61 70 77 80 Small SR Poor 65 76 84 88 Grains Good 63 75 83 87 SR CR Poor 64 75 83 86 Good 60 72 80 84 C Poor 63 74 82 85 Good 61 73 81 84 C4 CHR Poor 62 73 81 84 Good 60 72 80 83 C amp T Poor 61 72 79 82 Good 59 70 78 81 C amp T CR Poor 60 71 78 81 Good 58 69 77 80 Close SR Poor 66 77 85 89 seeded or Good 58 72 81 85 broadcast C Poor 64 75 83 85 legumes or Good 55 69 78 83 rotation C amp T Poor 63 73 80 83 meadow Good 51 67 76 80 Estimate Runoff Changes Using Curve Number II Runoff Curve Numbers Antecedent Moisture Condition Il for Other Rural Land Soil Conservation Service 1986 Hydrologic Soil Hydrologic Land Use Cover Condition Group A B C D Pasture grassland or range Poor a 68 79 86 89 continuous forage for grazing Fair 49 69 79 84 Good 39 61 74 80 Meadow continuous grass protected from grazing generally mowed for hay 30 58 71 78
Download Pdf Manuals
Related Search