{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Enable Macros","Instructions","Reference","Inputs","Match Types","Summary Results - Year 1","Results By Hillslope - Year 1","Results - Out Years","Results - Erosion Barriers","Results - Rainfall","Results - Treatment","Probability","Sediment","StoredRunValues","Ref"],"not_rendered":{"charts":0,"images":33,"macros":1,"external_links":0,"defined_names":63,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Enable Macros","index":0,"n_rows":134,"n_cols":2,"rows_kept":134,"cut":false,"hidden":false,"merged":[[118,1,119,10],[38,1,40,9]]}
["v.2018.04.01"]
["USFS ERMiT Batch Program - Instructions"]
[]
[]
[]
[]
[]
[]
[null,"Macros are not enabled.  In order for the batch program to work macros must be enabled."]
[null,"Follow the instructions below to enable the macros on this spreadsheet."]
[null,"How To Enable Macros in Excel 2010"]
[null,"Click \"File\" -- \"Options\" -- \"Trust Center\" -- \"Macro Settings\" and check \"Disable all macros with notification\"  -- apply changes."]
[null,"Close and reopen this worksheet and click through the Security Warnings."]
[]
[]
[]
[]
[]
[null,"How To Enable Macros in Excel 2003"]
[]
[null,"1. Close and re-open the current file.  Upon re-opening the file, a security warning will appear.  Click on Enable Macros."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How To Enable Macros in Excel 2007"]
[]
[null,"By default Excel blocks all macros, the following instructions show how to change the macro settings to allow for macro notification and enabling.  Steps 1 -4 only need to be done once.  \nSteps 5 and 6 will have to be done every time Batch ERMiT is started."]
[]
[]
[]
[null,"1.  Click on the office button in the upper left hand corner of the Excel window. "]
[]
[]
[null,"2.  In the pop-up menu that appears, click on Excel Options at the bottom right of the menu."]
[]
[null,"3.  In the window that appears, click on Trust Center from the left side list and then click Trust Center Settings."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.  In the window that appears select the Disable all macros with notification option and then click OK."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Close the Batch ERMiT spreadsheet and re-open it.  Upon re-opening you will see the following security warning across the top of the spreadsheet window.  Click on Options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.  In the Microsoft Office Security Options window that appears, select the Enable this content option and click OK."]

{"sheet":"Instructions","index":1,"n_rows":65,"n_cols":4,"rows_kept":65,"cut":false,"hidden":true,"merged":[[3,3,3,9],[3,1,3,2],[4,3,23,9],[4,1,23,2],[64,3,68,9],[64,1,68,2],[38,3,63,9],[38,1,63,2],[24,3,33,9],[24,1,33,2],[34,3,37,9],[34,1,37,2]]}
["USFS ERMiT Batch Program - Instructions"]
["2018.04.01"]
[]
[null,"Internet Connection",null,"An internet connection is required to run the program."]
[null,"Adding Climates",null,"Upon opening, the climates associated with the computer's current IP address will be retrieved from the USFS server and listed in the Select Climate drop down box on the Inputs page.  If no climates are listed, then the user must add the desired climates before running a batch.\n\nTo add a climate:\n\n 1. Go to the FS WEPP web page, and start ERMiT: \n       http://forest.moscowfsl.wsu.edu/fswepp\n\n 2. Select the state and then the climate station.\n\n 3.  To use the standard climate without any modifications, click on\n      the ADD TO PERSONAL CLIMATES button.\n\n 4.  To create a custom climate, click on the MODIFY CLIMATE button and \n      modify the climate as desired.\n\n 5.  On the Inputs page of this spreadsheet, click on the Refresh Climates \n      button.  The new climates should appear in the drop down box."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entering Inputs",null,"Use the Inputs page to enter the required inputs for each hillslope.  \n\nFor a description of each input variable, see the Reference page.\n\nHillslope data can be entered manually or by importing from the data file generated by the GIS Hillslope toolbox.  To import hillslope data from GIS, click on the Import GIS Hillslope File button. The gradient % and horizontal slope length values will be filled in from the file.  All the other variables must be entered manually."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Running the Batch Program",null,"After entering all the inputs, click on the Run ERMIT Batch button.  The program will process each hillslope."]
[]
[]
[]
[null,"Results",null," There are six results sheets:\n\n   Summary Results - Year 1:  Average, min, max, and quartile sediment delivery rates \n      calculated for 10, 30, 50, and 75% probabilities for all the hillslopes combined.\n\n   Results By Hillslope - Year 1: After running a hillslope batch, the user can select a \n       single hillslope and the sediment delivery rates will be calculated for the six \n       treatment types and 10, 30, 50, and 75% probabilities.\n\n   Results - Out Years:  After running a hillslope batch, the user can enter different \n       probability and treatment types in columns and the sediment delivery rates\n       for each hillslope will be calculated for years 2-5 after the fire.\n\n    Results - Erosion Barriers: After running a hillslope batch, the user can enter \n       different year, probability, log spacing and diameter parameters in columns \n       and the sediment delivery rates for each hillslope will be calculated.\n\n    Results - Rainfall: Rainfall and runoff event statistics for each hillslope\n\n    Results - Treatment:  Enter probability % and year after fire.  The average sediment\n       sediment delivery rate and total sediment for all the hillslopes will be calculated for\n       the six treatment types.  The sediment delivery rate and total sediment will be \n       calculated for each hillslope for each treatment type and sorted in descending\n       order by total sediment."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Citation",null,"\nRobichaud, Peter R.; Elliot, William J.; Pierson, Fredrick B.; Hall, David E.; Moffet, Corey A. 2014. Erosion Risk Management Tool (ERMiT). \n[Online at <http://forest.moscowfsl.wsu.edu/fswepp/>.] Moscow, ID: U.S. Department of Agriculture, Forest Service, Rocky Mountain Research Station.  \n\n\n"]

{"sheet":"Reference","index":2,"n_rows":76,"n_cols":4,"rows_kept":76,"cut":false,"hidden":true,"merged":[[75,1,76,4],[23,1,29,5],[3,1,12,7],[72,1,74,4],[31,1,42,4],[60,1,70,4]]}
["USFS ERMiT Batch Program - Reference"]
[]
["Soil Texture"]
[null,"The erosion potential of a given soil depends on the vegetation cover, the surface residue cover, the soil texture, and other soil properies that influence soil strength.\n\nFour soil textures (clay loam, silt loam, sandy loam, and loam) are available.\n\nThe following table can aid in selecting the desired soil texture. The specific soil properties associated with each selection can be seen by selecting the desired soil and clicking \"Describe\" under the Soil Texture title.\n\nTo fully describe each set of soils for WEPP requires 24 soil parameter values. Further details describing these parameters are available in the WEPP Technical Documentation (Alberts and others 1995). "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Categories of Common Forest Soils in Relation to ERMiT Soil Textures "]
[null,"ERMiT Soil Texture ","Soil Description ","Unified Soil Classification "]
[null,"Clay loam ","Soils derived from shales, limestone and similar decomposing fine-grained sedimentary rock.\nLakebeds and similar areas of ancient lacustrian deposits ","CH "]
[null,"Silt loam ","Ash cap and loess soils, soils derived from siltstone or similar sedimentary rock\nHighly-erodible mica/schist geologies ","ML,CL "]
[null,"Sandy loam ","Glacial outwash areas; decomposed granites and sand stone, and sand deposits ","GP, GM, SW, SP "]
[null,"Loam ","Glacial tills, alluvium ","GC, SM, SC, MH "]
[]
["Vegetation Type"]
[]
[null,"The user may select one of three vegetation types to be modeled: forest, range, or chaparral.\n\nThis selection affects the parameter values behind the chosen soil texture.\n\nIf range or chaparral is chosen, then the user may specify the percentage split among shrub, grass, and bare soil. The default values for range are 15% shrub, 75% grass, 10% bare; for chaparral, it is 80% shrub, 0% grass, and 20% bare.\n"]
[]
[]
[]
[]
[]
[]
["Hillslope Gradient and Horizontal Length"]
[null,"The topographic inputs for ERMiT are hillslope horizontal length and hillslope top, middle, and toe gradients. The top and toe gradients each represent 10% of the hillslope length, and the middle gradient represents 80%.\n\nTop gradient is the steepness, in percent, of the upper portion of the hillslope. Enter zero if the top of the slope starts at the top of the hill.\nMiddle gradient is the steepness, in percent, of the main portion of the hillslope.\nToe gradient is the steepness, in percent, of the lower portion of the hillslope.\nThese values may be obtained from a field survey, a forest map, or a GIS database.\n\nHillslope horizontal length is the length that would be measured directly off a topographic map [from where to where?]. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Soil Burn Severity Class"]
[null,"Fire effects on erosion are not homogeneous. Soil burn severity is a description of the impact of a fire on the soil and its litter layer. The soil burn severity of a fire varies widely in space, depending on fuel load, moisture conditions and weather at the time of the fire, and the topography. Variability in fire often creates mosaic landscapes with varying portions having low, moderate, and high soil burn severity. Areas that are drier, such as those near ridge tops, and areas with greater amounts of fuel, may experience higher soil burn severity than areas that are wetter, such as riparian areas.\n\nThe user may select \"high,\" \"moderate,\" or \"low\" soil burn severity for the hillside. ERMiT will model the hillslope as a set of one, two, or three overland flow elements (OFEs) on the hillslope using a variety of soil burn severities based on the selected severity class. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The hillslope file generated by the GIS hillslope toolbox will contain a numeric burn severity value.  The numeric burn severity is converted to the high, moderate, and low class using the specified breakpoint values  at the time of import."]
[]
[]
[null,"You may adjust the breakpoints and then click on Reclassify burn if you need to reclassify after the GIS Hillslope data are imported."]

{"sheet":"Inputs","index":3,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[[15,14,15,15],[19,11,19,13],[1,2,14,6],[16,10,16,11],[16,12,16,13],[1,7,13,12]]}
["USFS ERMiT Batch Program - Inputs"]
[null,null,"Instructions\n\n      1. Select the unit system.\n\n      2. Select the user personality (a-z) as applicable.\n\n      3. Select the climate option.  To use a single climate for all the hillslopes, select \n          Single Climate and then the climate to use in the drop down box that appears.\n          To enable selecting a different climate for each hillslope, select Multiple Climates.\n\n      4. If importing a GIS hillslope file, select Soil Burn Severity Classification values.  \n          This will allow the program to convert the numeric burn severity values in the \n          hillslope file to the Low, Moderate, or High classification.\n",null,null,null,null," \n\n      5. Import GIS hillslope data file, or enter hillslope data manually. To use the \n          default pre-fire shrub, grass, and bare values for Range and Chaparral\n          vegetation types, click on Use Default Values.\n\n      6. Click on Run ERMiT Batch to model the hillslopes.\n\nCells with red triangles in the upper right-hand corner contain embedded comments.  \nPlace mouse arrow over these cells to view the comments."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Burn Severity Classification"]
[null,null,null,null,null,null,null,"Personality","Units",null,"Climate",null,"Climate Option",null,null,"Low >",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moderate >",109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High >",187]
[]
["Hillslope Input Data",null,null,null,"columns labeled with Optional are imported from the GIS hillslope file and not required if entering hillslope data manually"]
[null,null,null,null,null,null,null,null,"Hillslope Gradient",null,null,"Range/Chaparral pre-fire community description"]
["Hillslope Code","Hillslope Climate","GIS Soil Type","Area","GIS Treatment","Soil Texture","Rock %","Vegetation Type","Top","Middle","Toe","% Shrub","%Grass","% Bare","Horizontal Slope Length","Soil Burn Severity Rating","Soil Burn \nSeverity \nClass"]
[null,null,"Optional",{"$f":"AreaUnits","v":"hectares"},"Optional",null,"(0-50)",null,"%","%","%",null,null,null,{"$f":"LengthUnits","v":"meters"},"Optional","(Unburned, Low, \nModerate, High)"]

{"sheet":"Match Types","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,6,3,9],[2,0,5,1],[1,0,1,1],[2,3,5,4],[1,3,1,4]]}
["Match GIS Hillslope File Soil and Vegetation Types to ERMiT Types"]
["Match Soil Types",null,null,"Match Treatment/Vegetation Types",null,null,"Click on the Update Types button after you are finished matching the soil and treatment types.  The macro will automatically fill in the hillslope data sheet with the matched types"]
["Match the soil type from the GIS Hillslope file in the left column to the corresponding ERMiT soil type (clay loam, silt loam, sandy loam, loam).  Each cell in the right column contains an embedded drop down list with the four soil type options.  Click on a cell to view the drop down list.",null,null,"Match the treatment type from the GIS Hillslope file in the left column to the corresponding ERMiT vegetation type.  Each cell in the right column contains an embedded drop down list with the treatment type options.  Click on a cell to view the drop down list."]
[]
[]
[]
[]
["Hillslope File Soil Type","ERMiT Soil Type",null,"Hillslope File Treatment Type","ERMiT Vegetation Type"]

{"sheet":"Summary Results - Year 1","index":5,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[[23,4,23,5],[23,6,23,7],[23,12,23,13],[23,14,23,15],[11,14,11,15],[22,11,22,15],[20,9,20,15],[4,1,4,15],[10,3,10,7],[20,1,20,7],[22,3,22,7],[11,6,11,7],[11,4,11,5],[11,12,11,13],[8,1,8,7],[10,11,10,15],[8,9,8,15]]}
["USFS ERMiT Batch Program - Summary Results For Year 1"]
[]
[null,"Year 1 is the first summer after the fire"]
[]
[null,"Overall Year 1 Sediment Delivery Rate Statistics For Different Target Probabilities"]
[]
[null,null,"Hillslope Count",{"$f":"InputCount","v":0},null,"Total Hillslope Area",null,{"$f":"AreaUnits","v":"hectares"}]
[]
[null,"Probability 10%",null,null,null,null,null,null,null,"Probability 30%"]
[]
[null,null,null,{"$f":"\"Sediment Delivery Rate Statistics (\" & sedunits & \")\"","v":"Sediment Delivery Rate Statistics (tons/hectare)"},null,null,null,null,null,null,null,{"$f":"\"Sediment Delivery Rate Statistics (\" & sedunits & \")\"","v":"Sediment Delivery Rate Statistics (tons/hectare)"}]
[]
[null,null,null,{"$f":"\"Average (\" & sedunits & \")\"","v":"Average (tons/hectare)"},"Hillslope Code",{"$f":"\"Minimum (\" & sedunits & \")\"","v":"Minimum (tons/hectare)"},"Hillslope Code",{"$f":"\"Maximum (\" & sedunits & \")\"","v":"Maximum (tons/hectare)"},null,null,null,{"$f":"\"Average (\" & sedunits & \")\"","v":"Average (tons/hectare)"},"Hillslope Code",{"$f":"\"Minimum (\" & sedunits & \")\"","v":"Minimum (tons/hectare)"},"Hillslope Code",{"$f":"\"Maximum (\" & sedunits & \")\"","v":"Maximum (tons/hectare)"}]
[null,null,"Untreated",null,null,null,null,null,null,null,"Untreated"]
[null,null,"Seeding",null,null,null,null,null,null,null,"Seeding"]
[null,null,{"$f":" \"Mulch - \" & SedUnits1","v":"Mulch - 1 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits1","v":"Mulch - 1 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits2","v":"Mulch - 2 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits2","v":"Mulch - 2 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits3","v":"Mulch - 3.5 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits3","v":"Mulch - 3.5 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits4","v":"Mulch - 4.5 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits4","v":"Mulch - 4.5 tons/hectare"}]
[]
[null,"Probability 50%",null,null,null,null,null,null,null,"Probability 75%"]
[]
[null,null,null,{"$f":"\"Sediment Delivery Rate Statistics (\" & sedunits & \")\"","v":"Sediment Delivery Rate Statistics (tons/hectare)"},null,null,null,null,null,null,null,{"$f":"\"Sediment Delivery Rate Statistics (\" & sedunits & \")\"","v":"Sediment Delivery Rate Statistics (tons/hectare)"}]
[]
[null,null,null,{"$f":"\"Average (\" & sedunits & \")\"","v":"Average (tons/hectare)"},"Hillslope Code",{"$f":"\"Minimum (\" & sedunits & \")\"","v":"Minimum (tons/hectare)"},"Hillslope Code",{"$f":"\"Maximum (\" & sedunits & \")\"","v":"Maximum (tons/hectare)"},null,null,null,{"$f":"\"Average (\" & sedunits & \")\"","v":"Average (tons/hectare)"},"Hillslope Code",{"$f":"\"Minimum (\" & sedunits & \")\"","v":"Minimum (tons/hectare)"},"Hillslope Code",{"$f":"\"Maximum (\" & sedunits & \")\"","v":"Maximum (tons/hectare)"}]
[null,null,"Untreated",null,null,null,null,null,null,null,"Untreated"]
[null,null,"Seeding",null,null,null,null,null,null,null,"Seeding"]
[null,null,{"$f":" \"Mulch - \" & SedUnits1","v":"Mulch - 1 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits1","v":"Mulch - 1 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits2","v":"Mulch - 2 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits2","v":"Mulch - 2 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits3","v":"Mulch - 3.5 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits3","v":"Mulch - 3.5 tons/hectare"}]
[null,null,{"$f":" \"Mulch - \" & SedUnits4","v":"Mulch - 4.5 tons/hectare"},null,null,null,null,null,null,null,{"$f":" \"Mulch - \" & SedUnits4","v":"Mulch - 4.5 tons/hectare"}]

{"sheet":"Results By Hillslope - Year 1","index":6,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[[2,1,3,7],[11,4,11,7],[8,2,8,7],[9,2,10,7]]}
["USFS ERMiT Batch Program - Year 1 Results By Hillslope"]
[]
[null,"Select the hillslope code to view the year 1 sediment delivery results.  Select the desired probability % by clicking on the percentage column headers in row 13."]
[]
[]
[null,"Select Hillslope Code  "]
[]
[]
[null,null,{"$f":"\"Year 1 Sediment Delivery  (\" & sedunits & \")\"","v":"Year 1 Sediment Delivery  (tons/hectare)"}]
[null,null,"To change probability % for a column click on the probability cell and select the desired probability"]
[]
[null,null,null,null,"Probability %"]
[null,null,null,null,0.3,0.4,0.3,0.5]
[null,null,"Untreated"]
[null,null,"Seeding"]
[null,null,{"$f":" \"Mulch (\" & SedUnits1 & \")\"","v":"Mulch (1 tons/hectare)"}]
[null,null,{"$f":" \"Mulch (\" & SedUnits2 & \")\"","v":"Mulch (2 tons/hectare)"}]
[null,null,{"$f":" \"Mulch (\" & SedUnits3 & \")\"","v":"Mulch (3.5 tons/hectare)"}]
[null,null,{"$f":" \"Mulch (\" & SedUnits4 & \")\"","v":"Mulch (4.5 tons/hectare)"}]
[]
[]
[]
[null,null,"Year 1 is defined as the first summer after the fire."]

{"sheet":"Results - Out Years","index":7,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,1,11,7]]}
["USFS ERMiT Batch Program - Out Year Results"]
[]
[null,"Instructions\n\n      1.  Run ERMiT on a hillslope batch.\n      2.  Enter the desired probability % and treatment type combinations in rows 14 and 15.\n      3.  Click on the Calculate button\n\n     For each column containing a probability and treatment value, the sediment delivery rate for years 2-5 after the\n     fire will be calculated for each hillslope and displayed starting in row 18."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter Probability %"]
[null,"Select Treatment Type"]
[]
["Hillslope Code","Out Year","Sediment Delivery (tons/hectare)",{"$f":"\"Sediment Delivery \" & sedunits","v":"Sediment Delivery tons/hectare"},"Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare","Sediment Delivery tons/hectare"]

{"sheet":"Results - Erosion Barriers","index":8,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,6,7]]}
["USFS ERMiT Batch Program - Erosion Barrier Sediment Delivery Calculation"]
[null,"Instructions\n\nTo calculate the sediment delivery rates for log and wattles: \n          1. Run ERMiT on a hillslope set\n          2. Enter the year following fire (1-5) in row 12\n          3. Enter the target probability % values in row 13\n          4. Enter the log spacing values in row 14\n          5. Enter log diameter values in row 15\n          6. Click on the Calculate Sediment Delivery button\n\n For each column with filled inputs, the sediment delivery will be calculated for each hillslope and shown starting at row 18"]
[]
[]
[]
[]
[]
[]
[{"$f":"\"  Allowable log diameter range: \" & LogDiameterMin & \" - \" & LogDiameterMax & \" \" & LengthUnits","v":"  Allowable log diameter range: 0.05 - 1 meters"}]
[{"$f":"\"  Allowable log spacing range: \" & LogSpacingMin & \" - \" & LogSpacingMax & \" \" & LengthUnits","v":"  Allowable log spacing range: 1.5 - 25 meters"}]
[]
["Enter Year (1-5)"]
["Enter Probability %"]
["Enter Log Spacing"]
["Enter Log Diameter"]
[]
["Hillslope Code",{"$f":"\"Sediment Delivery (\" & sedunits & \")\"","v":"Sediment Delivery (tons/hectare)"},"Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)","Sediment Delivery (tons/hectare)"]

{"sheet":"Results - Rainfall","index":9,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[3,0,8,7]]}
["USFS ERMiT Batch Program - Rainfall Results"]
[]
[]
["This page allows for sorting information on the rainfall events and characteristics of selected storms.  The Rank column reports the ranking of the runoff from the 5th, 10th, 20th, 50th, and 75th largest modeled runoff events.  The associated return interval of those runoff events are provided (in parentheses).  Each column can be sorted (smallest to largest, etc.) while the data  matrix is maintained."]
[]
[]
[]
[]
[]
[]
[]
["Hillslope Code","Rank","Storm Runoff",{"$f":"\"Storm Precipitation \" &\n RainfallUnits","v":"Storm Precipitation mm"},"Storm Duration\n hours","Peak Rainfall Intensity 10 minute","Peak Rainfall Intensity 30 minute","Storm Date"]

{"sheet":"Results - Treatment","index":10,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":true,"merged":[[21,2,21,4],[2,0,18,5],[17,10,18,16],[21,14,21,16],[21,17,21,19],[6,7,6,10],[21,5,21,7],[21,8,21,10],[21,11,21,13]]}
["USFS ERMiT Batch Program - Treatment Results"]
[]
["  Instructions\n\n      1. Enter the probability %.\n      2. Enter the year after fire (1-5).\n      3. Click on Calculate Results.\n\n   The average sediment delivery rate and total sediment will be calculated\n    for each hillslope and treatment type.  \n    (Total sediment = area x sediment delivery rate)\n\n   The results initially will be displayed by hilllslope code in the same \n   order as on the Inputs sheet.  If a different sort option is selected, then\n   the data will be sorted using the untreated column values.\n\n   Any cell with a red triangle in the upper right hand corner contains a \n   descriptive comment that can be viewed by placing the mouse cursor \n   over the cell.",null,null,null,null,null,null,"Probability %"]
[null,null,null,null,null,null,null,"Year after fire (1-5)"]
[]
[]
[null,null,null,null,null,null,null,"Summary For All Hillslopes"]
[null,null,null,null,null,null,null,null,null,"Average Sediment Delivery","Total Sediment"]
[null,null,null,null,null,null,null,null,null,{"$f":"sedunits","v":"tons/hectare"},"tons"]
[null,null,null,null,null,null,null,null,"Untreated"]
[null,null,null,null,null,null,null,null,"Seeding"]
[null,null,null,null,null,null,null,null,{"$f":" \"Mulch: \" & SedUnits1","v":"Mulch: 1 tons/hectare"}]
[null,null,null,null,null,null,null,null,{"$f":" \"Mulch: \" & SedUnits2","v":"Mulch: 2 tons/hectare"}]
[null,null,null,null,null,null,null,null,{"$f":" \"Mulch: \" & SedUnits3","v":"Mulch: 3.5 tons/hectare"}]
[null,null,null,null,null,null,null,null,{"$f":" \"Mulch: \" & SedUnits4","v":"Mulch: 4.5 tons/hectare"}]
[]
[]
[null,null,null,null,null,null,null,"Sort Results By"]
[null,null,null,null,null,null,null,"Sort Order"]
[]
[]
[null,null,{"$f":"I10","v":"Untreated"},null,null,{"$f":"I11","v":"Seeding"},null,null,{"$f":"I12","v":"Mulch: 1 tons/hectare"},null,null,{"$f":"I13","v":"Mulch: 2 tons/hectare"},null,null,{"$f":"I14","v":"Mulch: 3.5 tons/hectare"},null,null,{"$f":"I15","v":"Mulch: 4.5 tons/hectare"}]
["Hillslope Code",{"$f":"\"Area (\"\n& AreaUnits & \")\"","v":"Area (hectares)"},{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment",{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment",{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment",{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment",{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment",{"$f":"\"Sediment Delivery (\"&sedunits&\")\"","v":"Sediment Delivery (tons/hectare)"},"Total Sediment\n(tons)","% of Total Sediment"]

{"sheet":"Probability","index":11,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["DO NOT MODIFY THE VALUES IN THIS SHEET"]
["cumulative probability values, treatment: 0-untreated, 1-seeded, 2-5 mulch"]

{"sheet":"Sediment","index":12,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["DO NOT MODIFY THE VALUES IN THIS SHEET"]
["hillslope sediment delivery values for each simulation year, each row has the values for a single hillslope, each column represents simulation year"]

{"sheet":"StoredRunValues","index":13,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["DO NOT MODIFY THIS SHEET"]
[null,"value used in mitigation calculator"]
[null,"i10 - peak 10 minute rainfall intensity (mm/hour)"]
[]
[]
["hillslope row","i10","js_sedconv"]

{"sheet":"Ref","index":14,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["DO NOT MODIFY DATA ON THIS SHEET"]
["English",null,"Normal"]
["Metric",null,"Station Fire"]
[]
["Forest"]
["Range",null,"Ascending"]
["Chaparral",null,"Descending"]
[]
["Clay Loam"]
["Silt Loam"]
["Sandy Loam"]
["Loam"]
[]
["High"]
["Moderate"]
["Low"]
["Unburned"]
["Single Climate"]
["Multiple Climates"]
["Values used by underlying programming Do not delete"]
[null,"area units","hectares"]
[null,"length units","meters"]
[null,"sediment units","tons/hectare"]
[null,"input row count",{"$f":"COUNT(Inputs!O25:O9994)","v":0}]
[null,"cumulative probability count",{"$f":"COUNT(Sediment!A3:A60000)","v":0}]
[null,"rainfall stat rows",{"$f":"COUNT('Results - Rainfall'!C13:C60009)","v":0}]
[null,"mitigation table label","1 tons/hectare"]
[null,"mitigation table label","2 tons/hectare"]
[null,"mitigation table label","3.5 tons/hectare"]
[null,"mitigation table label","4.5 tons/hectare"]
[null,"rainfall units","mm"]
[null,"log spacing min value",1.5]
[null,"log spacing max value",25]
[null,"log diameter min value",0.05]
[null,"log diameter max value",1]
[null,"Sed Table Filled",0]
[null,"sed units abbreviated","t/ac"]
[]
[]
[null,"Untreated"]
[null,"Seeding"]
[null,{"$f":" \"Mulch: \" & SedUnits1 & \"\"","v":"Mulch: 1 tons/hectare"}]
[null,{"$f":" \"Mulch: \" & SedUnits2","v":"Mulch: 2 tons/hectare"}]
[null,{"$f":" \"Mulch: \" & SedUnits3","v":"Mulch: 3.5 tons/hectare"}]
[null,{"$f":" \"Mulch: \" & SedUnits4","v":"Mulch: 4.5 tons/hectare"}]
[]
[]
[]
[]
[null,0.1]
[null,0.2]
[null,0.3]
[null,0.4]
[null,0.5]
[null,0.6]
[null,0.7]
[null,0.8]
[null,0.9]
[null,1]
[]
[]
[null,"Hillslope Code"]
[null,"Hillslope Area"]
[null,"Sediment Delivery"]
[null,"Total Sediment"]
[]
[]
["Climate Count",0]
[]
["Climate Address","Climate Name"]