{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Enable Macros","Instructions","Inputs","Hillslope Data","Match Types","Summary Results","Hillslope Results","Reference","Hidden"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":85,"comments":1,"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":121,"n_cols":2,"rows_kept":121,"cut":false,"hidden":false,"merged":[[105,1,106,10],[25,1,27,9]]}
["For help or to check for a newer version: https://forest.moscowfsl.wsu.edu/fswepp/batch/dWb.html"]
["USFS DISTURBED WEPP 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 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.  Steps 5 and 6 will have to be done every time the Disturbed WEPP spreadsheet is opened."]
[]
[]
[]
[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 Disturbed WEPP 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":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":true,"merged":[[22,3,23,3],[22,2,23,2],[24,2,29,2],[32,2,34,2],[32,3,34,3],[24,3,29,3]]}
[null,null,"USFS DISTURBED WEPP BATCH PROGRAM - Instructions"]
[null,"2018.04.06"]
[]
[]
[null,"Model description"]
[null,null,null,"The Disturbed WEPP Batch Program is an interface to the Water Erosion Prediction Project soil erosion model (WEPP) to allow you to easily describe disturbed forest and rangeland erosion conditions. The interface summarizes the results and presents the probability of a given level of erosion (return period) occurring the year following a disturbance. Disturbed WEPP is linked to the Rock:Clime climate generator, which has a database of climate statistics for more than 2600 weather stations. The climate also can be refined for a specific location, optionally with PRISM data. "]
[null,"Model documentation",null,"Disturbed WEPP Documentation"]
[]
[]
[null,"Description of pages"]
[]
[null,null,"Page Name","Description"]
[null,null,"Instructions","Guidance on how to use the program"]
[null,null,"Inputs","Select input parameters for the Disturbed WEPP model"]
[null,null,"Hillslope Data","Enter hillslope data manually or import hillslope file created using GIS toolbox"]
[null,null,"Summary Results","Average and cumulative results for all the hillslopes"]
[null,null,"Hillslope Results","Results for each hillslope"]
[null,null,"Match Types","Match GIS hillslope file soil and treatment types to Disturbed WEPP types"]
[null,null,"Reference","Reference information on how to select soil texture, treatment, rock percentage, and gradient values for hillslope data"]
[]
[]
[null,null,"Internet Connection","The program requires an internet connection to work."]
[null,null,"Climates","Upon opening, the climates associated with the computer's current IP address will be retrieved from the USFS server and listed in the Climate list 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\n1. On the Inputs page, click on the Create New Climate button.  A browser window will open up showing the Rock:Clime climate generator web page.\n\n2. In the browser window, select a state and then a climate station.\n\n3.  To use the standard climate without any modifications, click on the ADD TO PERSONAL CLIMATES button.\n\n4.  To create a custom climate, click on the MODIFY CLIMATE button and modify the climate as desired.\n\n5.  On the Inputs page of this spreadsheet, click on the Refresh Climate List button.  "]
[]
[null,null,"Hillslope Data","Before running Disturbed WEPP, the user will need to enter data for all hillslopes to be modeled. \n\nIf you have generated hillslope data using the GIS toolbox, click on the Import GIS Hillslope File button on the Inputs sheet.  The program will load the hillslope data from the selected file into the Hillslope Data sheet.\n\nFor manual data entry, select the Hillslope Data tab and type in the desired values. Do not cut and paste data from a different spreadsheet. Some of the fields are limited to specific values, and if you try to paste data into those cells that do not match the prescribed list, an error message will occur."]
[]
[]
[]
[]
[]
[null,null,"Reference","The Reference page contains background information for selecting soil texture, treatment, rock percentage, and hillslope gradients."]
[null,null,"Saving Results","If you wish to save the detailed results for each hillslope, select Yes next to Save Results? on the Inputs page.  The results for each hillslope will be saved to an HTML file.  The result files will be saved to a sub-directory called Disturbed WEPP Results in the directory that contains the local Disturbed WEPP Batch program file."]
[null,null,"Interpreting Results","A summary of the results is provided on the Summary Results page. This page provides average and total results for all hillslopes modeled.  The average result is the average erosion or sediment rate per unit area for all the hillslopes.  The total values are calculated by multiplying the estimated erosion/sediment delivery rates for each hillslope by their corresponding area and then summing up those values to yield the total erosion or sediment in English or metric tons for all of the hillslopes.\n\nTo view results from a single run, select the Hillslope ID from the drop down box on the Summary Results page.  The results will be displayed in box below the drop down box.  The hillslope results also can be viewed on the Hillslope Results page.\n\n"]
[]
[]
[null,null,"Update/send comments ","http://forest.moscowfsl.wsu.edu/fswepp/batch/dWb.html"]
[null,null,"Citation","Elliot, William J.; Hall, David E. 2010. Disturbed WEPP Model 2.0. Ver. 2011.11.22. \nMoscow, ID: U.S. Department of Agriculture, Forest Service, Rocky Mountain Research Station. Online at <http://forest.moscowfsl.wsu.edu/fswepp>. "]

{"sheet":"Inputs","index":2,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[31,8,34,12],[2,3,2,5],[6,3,6,5],[4,3,4,5],[10,5,11,9],[17,2,17,3],[18,7,27,12]]}
[null,"USFS DISTURBED WEPP BATCH PROGRAM - Inputs"]
[]
[null,null,"Project Name  ","First 2 from D Yu"]
[]
[null,null,"Location  ","Cove Fire"]
[]
[null,null,"Watershed  ",null,null,null,"(optional)"]
[]
[null,null,"Units  "]
[]
[null,null,"Save Results?",null,null,"Select Yes to save individual run results as external HTML files.  Result files will be saved to the same directory as the current spreadsheet."]
[]
[null,"Step 1.","Select Personality","(click for explanation)",null,null,"a-z (optional)"]
[]
[]
[null,"Step 2.","Select Climate"]
[]
[null,null,"Climate List "]
[null,null,null,null,null,null,null,"If there are no climates listed in the Climate List, click on the Refresh Climates button.  If there are still no climates after updating, then the program could not find any climates associated with your computer's current IP address and personality; please create climates through the FS WEPP webpage forest.moscowfsl.wsu.edu/fswepp\nStart Disturbed WEPP, and create or modify a climate, then click on the Refresh Climates button here to refresh."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3.","Hillslope Data Entry/Import"]
[]
[null,null,null,null,null,null,null,null,"Click on Import GIS Hillslope File to import data created by the GIS Hillslope Toolbox.  To manually enter Hillslope data, click on Enter Hillslope Data Manually."]
[]
[]
[]
[null,"Step 4.","Select Years of Simulation"]
[]
[]
[null,"Step 5. ","Click Button To Run Batch"]

{"sheet":"Hillslope Data","index":3,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":true,"merged":[[15,0,15,17],[16,0,16,5]]}
["USFS DISTURBED WEPP BATCH PROGRAM - Hillslope Data"]
[]
[null,"Column","Label","Description"]
[null,1,"Hillslope Code","Alphanumeric string that uniquely identifies each hillslope."]
[null,2,"GIS Land Type","Soils information from the GIS Hillslope Tool.  Not required for manual entry."]
[null,3,"Soil Texture","The WEPP soil texture corresponding to the landtype. WEPP uses the following soil textures: loam, silt loam, clay loam, sandy loam. See the Soils section on the Reference page for more information."]
[null,4,"Area","The area of the hillslope, in acres or hectares."]
[null,5,"GIS Treatment","Treatment value assigned by the GIS Hillslope Tool.  Not required for manual entry."]
[null,"6,13","Treatment","The treatment associated with the upper and lower hillslope. The following options are allowed: twenty-year old forest; five-year old forest; shrub-dominated rangeland; tall grass prairie; short-grass prairie; low-severity fire; high-severity fire; skid trail.       "]
[null,"7,14","Horizontal Slope Length","The horizontal slope length for the upper and lower hillslope."]
[null,"8,9,15,16","Gradient","The hillslope surface gradient, in percent. See the Hillslope section on the Reference page for an image depicting upper and lower hillslopes."]
[null,"10,17","Cover","The vegetative cover, in percent, for the upper and lower hillslopes."]
[null,"11,18","Rock","The rock content, in percent, for the upper and lower hillslopes."]
[]
[]
["DO NOT INSERT OR DELETE ROWS OR COLUMNS ON THIS SHEET"]
["Place mouse arrow over column header text for more information"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,null,"Upper",null,null,null,null,null,null,"Lower"]
["Hillslope Code","GIS Soil Type","Soil Texture",{"$f":"\"Area (\" & area_units & \")\"","v":"Area (acres)"},"GIS Treatment","Treatment/ Vegetation",{"$f":"\"Horizontal Slope Length (\" & length_units & \")\"","v":"Horizontal Slope Length (feet)"},"Gradient % Top","Gradient % Bottom","Cover %","Rock %","GIS Treatment","Treatment/ Vegetation",{"$f":"\"Horizontal Slope Length (\" & length_units & \")\"","v":"Horizontal Slope Length (feet)"},"Gradient % Top","Gradient % Bottom","Cover %","Rock %"]
["Required","Optional","Required","Required","Optional","Required","Required","Required","Required","Required","Required","Optional","Required","Required","Required","Required","Required","Required"]
["1","loam",null,10.98,"Moderate Severity Fire",null,1,51,62.4,null,null,"Moderate Severity Fire",null,100.87,61.1,45.7,null,15]
["2","loam",null,9.27,"Grass Low Severity Fire",null,2,58,65.2,null,null,"Grass Low Severity Fire",null,85.16,56.5,37,null,15]
["3","loam",null,10.44,"Moderate Severity Fire",null,3,54.1,65.599999999999994,null,null,"Moderate Severity Fire",null,155.77000000000001,64.099999999999994,52.1,null,15]
["4","loam",null,3.06,"Moderate Severity Fire",null,4,53.3,54.8,null,null,"Moderate Severity Fire",null,60.61,55.4,59.9,null,15]
["5","loam",null,1.8,"Moderate Severity Fire",null,5,65.8,74,null,null,"Moderate Severity Fire",null,35.65,67.099999999999994,53.6,null,15]
["6","loam",null,10.8,"Moderate Severity Fire",null,6,67.400000000000006,65.2,null,null,"Moderate Severity Fire",null,135.91999999999999,45.4,42.6,null,15]
["7","sand loam",null,9.7200000000000006,"Grass Low Severity Fire",null,7,53.5,68.900000000000006,null,null,"Grass Low Severity Fire",null,122.33,69,39.200000000000003,null,15]
["8","loam",null,10.26,"High Severity Fire",null,8,56.6,61.8,null,null,"High Severity Fire",null,181.24,71,53.5,null,15]
["9","loam",null,2.0699999999999998,"Moderate Severity Fire",null,9,53.7,64,null,null,"Moderate Severity Fire",null,19.809999999999999,67.5,58,null,15]
["10","loam",null,5.13,"Moderate Severity Fire",null,10,71.400000000000006,69,null,null,"Moderate Severity Fire",null,49.1,66.400000000000006,62,null,15]
["11","loam",null,18.36,"Moderate Severity Fire",null,11,66.7,67,null,null,"Moderate Severity Fire",null,160.44999999999999,65.2,54.7,null,15]
[12,"sand loam",null,25.38,"Grass Low Severity Fire",null,12,63.6,65.900000000000006,null,null,"Grass Low Severity Fire",null,221.8,65.2,39.6,null,15]
[13,"loam",null,10.08,"High Severity Fire",null,13,64.400000000000006,77.900000000000006,null,null,"High Severity Fire",null,214.37,50.3,71.900000000000006,null,15]
[14,"loam",null,6.03,"Moderate Severity Fire",null,14,59.9,80.2,null,null,"Moderate Severity Fire",null,50.07,76.8,57.6,null,15]
[15,"loam",null,10.17,"Moderate Severity Fire",null,15,75.400000000000006,65.8,null,null,"Moderate Severity Fire",null,84.45,60.2,67.2,null,15]
[16,"loam",null,0.18,"Moderate Severity Fire",null,16,28.1,26.3,null,null,"Moderate Severity Fire",null,15,24.6,22.8,null,15]
[17,"sand loam",null,0.63,"Moderate Severity Fire",null,17,66.099999999999994,65.599999999999994,null,null,"Moderate Severity Fire",null,52.5,59.5,36.9,null,15]
[18,"loam",null,3.06,"Moderate Severity Fire",null,18,66.7,61.2,null,null,"Moderate Severity Fire",null,47.86,68.099999999999994,40.9,null,15]
[19,"sand loam",null,4.8600000000000003,"Shrub Moderate Severity Fire",null,19,77,77.7,null,null,"Shrub Moderate Severity Fire",null,76.010000000000005,69.099999999999994,44.9,null,15]
[20,"loam",null,10.44,"High Severity Fire",null,20,47.5,50.4,null,null,"High Severity Fire",null,190.64,77.099999999999994,61.3,null,15]
[21,"loam",null,6.84,"Moderate Severity Fire",null,21,71.599999999999994,81.400000000000006,null,null,"Moderate Severity Fire",null,52.23,80.400000000000006,77.400000000000006,null,15]
[22,"loam",null,5.4,"Moderate Severity Fire",null,22,78.2,77.2,null,null,"Moderate Severity Fire",null,41.23,60.5,54.9,null,15]
[23,"loam",null,4.32,"Moderate Severity Fire",null,23,70.7,60.6,null,null,"Moderate Severity Fire",null,115.34,59.6,55.9,null,15]
[24,"sand loam",null,0.45,"Moderate Severity Fire",null,24,76.8,73.5,null,null,"Moderate Severity Fire",null,12.01,70.099999999999994,66.7,null,15]
[25,"loam",null,7.11,"Moderate Severity Fire",null,25,73.3,75.5,null,null,"Moderate Severity Fire",null,89.01,67.900000000000006,48.7,null,15]
[26,"sand loam",null,23.22,"High Severity Fire",null,26,68.7,67.099999999999994,null,null,"High Severity Fire",null,290.68,63.9,52.1,null,15]
[27,"loam",null,10.08,"High Severity Fire",null,27,33.5,40.700000000000003,null,null,"High Severity Fire",null,153.88,48.6,44.8,null,15]
[28,"loam",null,12.6,"High Severity Fire",null,28,39.799999999999997,33.299999999999997,null,null,"High Severity Fire",null,91.71,63.2,75.599999999999994,null,15]
[29,"loam",null,13.86,"High Severity Fire",null,29,48.7,60.6,null,null,"High Severity Fire",null,100.88,58.8,65.3,null,15]
[30,"loam",null,13.5,"High Severity Fire",null,30,57.4,67.3,null,null,"High Severity Fire",null,126.92,58.8,58.3,null,15]
[31,"sand loam",null,6.12,"Moderate Severity Fire",null,31,62.7,71.7,null,null,"Moderate Severity Fire",null,57.54,71.8,56,null,15]
[32,"loam",null,14.67,"Low Severity Fire",null,32,43.4,49.7,null,null,"Low Severity Fire",null,179.07,42.6,46.7,null,15]
[33,"loam",null,12.24,"High Severity Fire",null,33,41.2,47.8,null,null,"High Severity Fire",null,105.08,51.7,52.8,null,15]
[34,"loam",null,17.190000000000001,"Moderate Severity Fire",null,34,47.9,56,null,null,"Moderate Severity Fire",null,147.57,52.3,43.7,null,15]
[35,"loam",null,1.17,"Moderate Severity Fire",null,35,72.3,79.8,null,null,"Moderate Severity Fire",null,50.93,82.2,84.7,null,15]
[36,"loam",null,0.9,"Moderate Severity Fire",null,36,75.3,75.599999999999994,null,null,"Moderate Severity Fire",null,39.18,70.900000000000006,44.9,null,15]
[37,"loam",null,0.9,"Low Severity Fire",null,37,74,67.7,null,null,"Low Severity Fire",null,31.07,57.7,43.8,null,15]
[38,"sand loam",null,1.98,"Moderate Severity Fire",null,38,71.3,80,null,null,"Moderate Severity Fire",null,68.349999999999994,73,61.2,null,15]
[39,"loam",null,16.739999999999998,"Low Severity Fire",null,39,43.6,43.5,null,null,"Low Severity Fire",null,179.35,52.8,44.1,null,15]
[40,"loam",null,14.76,"Low Severity Fire",null,40,38,40.299999999999997,null,null,"Low Severity Fire",null,158.13,37.5,43,null,15]
[41,"loam",null,10.62,"Low Severity Fire",null,41,7,8.9,null,null,"Low Severity Fire",null,158.66,9.8000000000000007,9.5,null,15]
[42,"loam",null,18.36,"Low Severity Fire",null,42,27.6,41.8,null,null,"Low Severity Fire",null,101.76,46.8,42.9,null,15]
[43,"loam",null,12.06,"Low Severity Fire",null,43,33.5,24.9,null,null,"Low Severity Fire",null,66.84,32.9,40.200000000000003,null,15]
[44,"loam",null,0.36,"Evergreen Forest",null,44,43.4,50.1,null,null,"Evergreen Forest",null,15.67,50.6,48.7,null,15]
[45,"loam",null,1.71,"Low Severity Fire",null,45,45.9,56.6,null,null,"Low Severity Fire",null,74.44,50.6,41.5,null,15]
[46,"loam",null,10.98,"Low Severity Fire",null,46,33.799999999999997,32.299999999999997,null,null,"Low Severity Fire",null,230.8,29.7,27.3,null,15]
[47,"loam",null,1.98,"Low Severity Fire",null,47,37.200000000000003,41.5,null,null,"Low Severity Fire",null,27.73,48.9,44,null,15]
[48,"loam",null,1.8,"Moderate Severity Fire",null,48,36.4,40.200000000000003,null,null,"Moderate Severity Fire",null,25.21,39.799999999999997,49.7,null,15]
[49,"loam",null,0.9,"Low Severity Fire",null,49,40.6,40.4,null,null,"Low Severity Fire",null,150,40.200000000000003,40.1,null,15]
[50,"loam",null,10.53,"Low Severity Fire",null,50,37.9,15,null,null,"Low Severity Fire",null,264.19,23,30.1,null,15]
[51,"loam",null,4.8600000000000003,"Low Severity Fire",null,51,33.700000000000003,40.5,null,null,"Low Severity Fire",null,64,44.7,43,null,15]
[52,"loam",null,3.6,"Low Severity Fire",null,52,27.6,31,null,null,"Low Severity Fire",null,47.41,36.6,37.9,null,15]
[53,"loam",null,10.8,"Evergreen Forest",null,53,22.4,23.8,null,null,"Evergreen Forest",null,158.87,23.8,26.8,null,15]
[54,"loam",null,0.27,"Moderate Severity Fire",null,54,30.4,33.700000000000003,null,null,"Moderate Severity Fire",null,4.87,37,40.200000000000003,null,15]
[55,"loam",null,1.71,"Low Severity Fire",null,55,44,50.3,null,null,"Low Severity Fire",null,30.84,45.6,43.4,null,15]
[56,"loam",null,10.35,"Evergreen Forest",null,56,24.6,26.3,null,null,"Evergreen Forest",null,271.13,26.3,31.6,null,15]
[57,"loam",null,9.09,"Low Severity Fire",null,57,47.7,49.6,null,null,"Low Severity Fire",null,61.27,50.1,51.2,null,15]
[58,"sand loam",null,8.5500000000000007,"Low Severity Fire",null,58,30.7,54.3,null,null,"Low Severity Fire",null,57.63,57.4,47.6,null,15]
[59,"loam",null,19.89,"Low Severity Fire",null,59,35.799999999999997,38.1,null,null,"Low Severity Fire",null,235.76,33.5,29.1,null,15]
[60,"loam",null,15.12,"Low Severity Fire",null,60,36,35.1,null,null,"Low Severity Fire",null,92.02,30,40.4,null,15]
[61,"sand loam",null,12.15,"Low Severity Fire",null,61,33.799999999999997,38.700000000000003,null,null,"Low Severity Fire",null,73.95,43.3,48.6,null,15]
[62,"loam",null,30.42,"Moderate Severity Fire",null,62,57.5,60.3,null,null,"Moderate Severity Fire",null,185.14,58.2,54.1,null,15]
[63,"sand loam",null,16.02,"Shrub Moderate Severity Fire",null,63,58.3,62.1,null,null,"Shrub Moderate Severity Fire",null,97.5,62.5,55.1,null,15]
[64,"loam",null,10.44,"Low Severity Fire",null,64,36.700000000000003,48.6,null,null,"Low Severity Fire",null,329.08,43.9,41.4,null,15]
[65,"loam",null,11.79,"Moderate Severity Fire",null,65,35.5,40,null,null,"Moderate Severity Fire",null,166.13,42.4,52.2,null,15]
[66,"loam",null,9.5399999999999991,"Low Severity Fire",null,66,31.3,36,null,null,"Low Severity Fire",null,134.41999999999999,46.6,49.1,null,15]
[67,"loam",null,9.99,"Low Severity Fire",null,67,44.5,44.6,null,null,"Low Severity Fire",null,104.19,51.9,48.2,null,15]
[68,"loam",null,16.29,"Moderate Severity Fire",null,68,48.4,46.9,null,null,"Moderate Severity Fire",null,121.29,56.2,65.599999999999994,null,15]
[69,"sand loam",null,24.03,"Shrub Moderate Severity Fire",null,69,68.2,64.099999999999994,null,null,"Shrub Moderate Severity Fire",null,178.92,58.8,48.2,null,15]
[70,"sand loam",null,10.89,"Shrub Moderate Severity Fire",null,70,48.9,51.2,null,null,"Shrub Moderate Severity Fire",null,158.72999999999999,60.2,64.7,null,15]
[71,"sand loam",null,5.4,"High Severity Fire",null,71,74.8,77.099999999999994,null,null,"High Severity Fire",null,49.61,76.599999999999994,66.900000000000006,null,15]
[72,"sand loam",null,17.28,"Grass Low Severity Fire",null,72,59.8,65,null,null,"Grass Low Severity Fire",null,158.75,66.2,53.1,null,15]

{"sheet":"Match Types","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,6,3,9],[2,0,5,1],[1,0,1,1],[2,3,5,5],[1,3,1,5]]}
["Match GIS Hillslope File Soil and Treatment Types to Disturbed WEPP Types"]
["Match Soil Types",null,null,"Match Treatment/Vegetation Types and Cover %",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 Disturbed WEPP 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 Disturbed WEPP treatment/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.\n\nEnter the cover % associated with each treatment type"]
[]
[]
[]
[]
["Hillslope File Soil Type","Disturbed WEPP Soil Type",null,"Hillslope File Treatment Type","Disturbed WEPP Treatment /Vegetation Type","Average Cover % for Treatment Type"]
["loam",null,null,"Moderate Severity Fire"]
["sand loam",null,null,"Grass Low Severity Fire"]
[null,null,null,"High Severity Fire"]
[null,null,null,"Shrub Moderate Severity Fire"]
[null,null,null,"Low Severity Fire"]
[null,null,null,"Evergreen Forest"]

{"sheet":"Summary Results","index":5,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[[38,1,38,6],[20,2,20,3],[29,5,29,6],[29,3,29,4],[27,1,27,6],[2,3,2,5],[6,3,6,4],[4,3,4,5],[8,3,9,6],[11,4,11,6],[8,1,8,2],[17,2,17,3],[18,2,18,3],[19,2,19,3],[13,1,13,6]]}
["USFS DISTURBED WEPP BATCH PROGRAM - Summary Results"]
[]
[null,null,"Project Name  ",{"$f":"ProjectName","v":"First 2 from D Yu"},null,null,null,"Select Hillslope ID",null,null,null,"To view the results for individual hillslopes, select the desired Hillslope ID"]
[]
[null,null,"Location  ",{"$f":"location","v":"Cove Fire"}]
[]
[null,null,"Watershed  ",{"$f":"watershed","v":0}]
[]
[null,"Climate Summary",null,"Modified by Rock:Clime on August 24, 2017 from\r\n  ALTURAS CA                               4 161 0\r \tT MAX   39.16  43.69  49.45  57.64  66.16  74.81  85.37  84.52  76.91  65.08  49.97  41.64 deg F \t\r\nT MIN   14.32  18.74  22.77  26.75  32.98  39.15  42.25  39.80  33.59  26.61  21.02  16.56 deg F \t\r\nMEANP  2.41 1.69 1.70 1.47 1.65 1.58 0.37 0.56 0.70 1.60 2.28 2.96 in \t\r\n# WET  8.61 8.44 8.97 6.99 6.89 4.93 1.53 2.01 2.92 5.17 7.85 8.45 days \t\r\nLatitude   41.89 Longitude  120.82 Elevation  5117.0 ft\t\r\n\r\n       \r\n      "]
[]
[]
[null,null,"Total Hillslope Area  ",{"$f":"SUM('Hillslope Data'!D22:D59885)","v":674.54999999999984},{"$f":"area_units & \" consisting of \" & HillslopeCount & \" hillslopes\"","v":"acres consisting of 72 hillslopes"}]
[]
[null,"Mean Annual Averages for Watershed"]
[]
[null,null,null,"Precipitation  ",null,{"$f":"rainfall_units","v":"inches"}]
[null,null,null,"# of storms  "]
[null,null,"Average runoff from rainfall  ",null,null,{"$f":"F16","v":"inches"}]
[null,null,"Average # of runoff events  "]
[null,null,"Average snowmelt runoff  ",null,null,{"$f":"F18","v":"inches"}]
[null,null,"Average # of snowmelt runoff events  "]
[]
[null,null,null,"Average","Total"]
[null,null,null,{"$f":"erosion_units","v":"tons/acre"},{"$f":"delivery_unts","v":"tons"}]
[null,null,"Upland Erosion  "]
[null,null,"Sediment Delivery  "]
[]
[null,"Return Period Analysis"]
[]
[null,null,null,{"$f":" \"Average (\" & erosion_units & \")\"","v":"Average (tons/acre)"},null,{"$f":"\"Total (\" & delivery_unts & \")\"","v":"Total (tons)"}]
[null,null,null,"Erosion","Sediment Delivery","Erosion","Sediment Delivery"]
[null,null,"10 year"]
[null,null,"5 year"]
[null,null,"2 year"]
[null,null,"1 year"]
[]
[null,null,"Average "]
[]
[null,"Probability of Occurrence in First Year Following Disturbance"]
[]
[null,null,null,"Probability Range"]
[null,null,"Runoff ",null,"%"]
[null,null,"Erosion ",null,"%"]
[null,null,"Sediment Delivery ",null,"%"]

{"sheet":"Hillslope Results","index":6,"n_rows":8,"n_cols":60,"rows_kept":8,"cut":false,"hidden":true,"merged":[[4,3,4,6],[4,7,4,10],[3,0,3,10],[3,11,3,59],[5,27,5,30]]}
["USFS DISTURBED WEPP BATCH PROGRAM - Hillslope Results",null,null,null,null,null,null,null,null,null,null,null,null,null,"USFS DISTURBED WEPP BATCH PROGRAM - Hillslope Results",null,null,null,null,null,null,null,null,null,null,null,null,"USFS DISTURBED WEPP BATCH PROGRAM - Hillslope Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USFS DISTURBED WEPP BATCH PROGRAM - Hillslope Results"]
["DO NOT INSERT/DELETE ROWS OR COLUMNS ON THIS SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT INSERT/DELETE ROWS OR COLUMNS ON THIS SHEET",null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT INSERT/DELETE ROWS OR COLUMNS ON THIS SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT INSERT/DELETE ROWS OR COLUMNS ON THIS SHEET"]
[]
["INPUTS"]
[null,null,null,"UPPER",null,null,null,"LOWER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Return period analysis based on \" & SimulationLength & \" years of climate\"","v":"Return period analysis based on 10 years of climate"}]
["Hillslope Code","Soil Texture","Area ","Treatment","Slope Length","Gradient Top","Gradient Bottom","Treatment","Slope Length","Gradient Top","Gradient Bottom",{"$f":"\"Mean Annual Averages for \" & SimulationLength & \" years\"","v":"Mean Annual Averages for 10 years"},null,null,null,null,null,null,null,"Return Period # 1:       10 year",null,null,null,"Return Period # 2:       5 year",null,null,null,"Return Period # 3:       2 year",null,null,null,"Return Period # 4:       1 year",null,null,null,"Return Period # 5:       ",null,null,null,"Average",null,null,null,"Probabilities of Occurrence in First Year Following Disturbance",null,null,"Mean Annual Averages",null,{"$f":"Period1","v":"Return Period # 1:       10 year"},null,{"$f":"Period2","v":"Return Period # 2:       5 year"},null,{"$f":"Period3","v":"Return Period # 3:       2 year"},null,{"$f":"Period4","v":"Return Period # 4:       1 year"},null,{"$f":"Period5","v":"Return Period # 5:       "},null,"Return Period: Average"]
[null,null,null,null,null,null,null,null,null,null,null,"Precipitation ","Storms","Rainfall Runoff ","Rainfall Runoff Events","Snowmelt Runoff ","Snowmelt Runoff Events","Upland Erosion Rate","Sediment Leaving Profile","Precipitation ","Runoff ","Erosion ","Sediment ","Precipitation ","Runoff ","Erosion ","Sediment ","Precipitation ","Runoff ","Erosion ","Sediment ","Precipitation ","Runoff ","Erosion ","Sediment ","Precipitation ","Runoff ","Erosion ","Sediment ","Precipitation ","Runoff ","Erosion ","Sediment ","Runoff","Erosion","Sediment Delivery","Mean Annual Average Erosion ","Mean Annual Average Sediment Delivery ","Erosion","Sediment Delivery","Erosion","Sediment Delivery","Erosion","Sediment Delivery","Erosion","Sediment Delivery","Erosion","Sediment Delivery","Erosion","Sediment Delivery"]
[null,null,{"$f":"area_units","v":"acres"},null,{"$f":"length_units","v":"feet"},"%","%",null,{"$f":"length_units","v":"feet"},"%","%",{"$f":"rainfall_units","v":"inches"},"#",{"$f":"L8","v":"inches"},"#",{"$f":"L8","v":"inches"},"#",{"$f":"erosion_units","v":"tons/acre"},{"$f":"R8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$L$8","v":"inches"},{"$f":"$L$8","v":"inches"},{"$f":"$R$8","v":"tons/acre"},{"$f":"$R$8","v":"tons/acre"},"%","%","%",{"$f":"delivery_unts","v":"tons"},{"$f":"$AU$8","v":"tons"},{"$f":"$AU$8","v":"tons"},"tons","tons","tons","tons","tons","tons","tons","tons","tons","tons","tons"]

{"sheet":"Reference","index":7,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[23,2,23,4],[29,1,33,4],[16,2,16,4],[19,2,19,4],[20,2,20,4],[17,2,17,4],[18,2,18,4],[21,2,21,4],[22,2,22,4],[24,2,24,4]]}
["USFS DISTURBED WEPP BATCH PROGRAM - Input Reference"]
[]
["Soil Information"]
[null,"Categories of Common Forest Soils in relation to Disturbed WEPP Soil textures"]
[]
[null,"Soil Texture"," Soil Description",null," Universal Soil Classification"]
[null,"Clay loam","Soils derived from shales, limestone and similar decomposing fine-grained sedimentary rock. Lakebeds and similar areas of ancient lacustrian deposits. ",null,"CH"]
[null,"Silt loam ","Ash cap and loess soils, soils derived from siltstone or similar sedimentary rock. Highly-erodible mica/schist geologies.",null,"ML,CL"]
[null,"Sandy loam ","Glacial outwash areas; decomposed granites and sand stone, and sand deposits ",null,"GP, GM, SW, SP"]
[null,"Loam ","Glacial tills, alluvium",null,"GC, SM, SC, MH "]
[]
[]
[]
["Treatment"]
[]
[null,"Vegetation Treatment Options in the Disturbed WEPP Interface"]
[null,"Vegetation Treatment ","Description"]
[null,"Twenty-year old forest","Any well-established forest with trees spaced about 2 m (6 ft) apart, about 5 m (20 ft) tall or taller. Ground is generally covered with a substantial layer of forest duff."]
[null,"Five-year old forest","A growing forest describing conditions several years after a wilfire with surface cover approaching 100 percent in most climates.  May also describe a forest in the first year or two following a significant harvest for timber of biomass.  Be sure to not the correct ground cover following such an operation."]
[null,"Shrub-dominated rangeland","Areas of shrubs with soil covered with residue beneath shrubs, and gaps between shrubs with minimal ground cover. Plants are about 1.2 m (4 ft) tall, with a 0.5 m (20 inch) spacing. The percent cover entered is an indication of the percent of the canopy or ground cover by the vegetation. Examples of this vegetation may be sage-dominated rangeland, or sparsely vegetated pinyon-juniper communities. This treatment may also be a reasonable estimate of a harvested forest 3 years after harvest and prescribed burn, or a forest 4 years after a severe wildfire."]
[null,"Tall-grass prairie","Areas covered by tall bunch grasses, with gaps between bunches. Plants are about 0.6 m (24 inch) tall and 0.3 m (12 inch) average spacing. The percent cover entered is an indication of the percent of the canopy or ground covered by the vegetation. This vegetation treatment would best describe blue-stem or similar range communities in the west, or ryegrass, brome, or orchard grass pastures in the east. It may also describe post-fire conditions where wheat or oats have germinated to provide post-fire erosion mitigation. This treatment may also be a reasonable estimate of a harvested forest 2 years after a prescribed burn, or 3 years after a wildfire."]
[null,"Short-grass prairie","Areas covered by short sod-forming grasses. Plants are about 0.4 m (16 inch) tall and with an average spacing of 0.2 m (8 inch). The percent cover entered is an indication of the percent canopy or ground covered by the vegetation. This vegetation treatment would best describe buffalo grass or similar sodding grasses in the west, or Kentucky bluegrass in the east. It may also best describe sparsely-covered reclaimed mine lands. This treatment may best describe forest conditions 1 year after a prescribed fire or two years after a wildfire."]
[null,"Low-severity fire","This condition describes areas that have either had a low-severity fire, or a successful prescribed fire. Vegetation is assumed to reach an maximum height of 0.2 m (8 inch) and at a spacing of 0.2 m (8 inch). This is probably the most appropriate treatment to describe a sparsely vegetated, newly exposed surface following excavation where material has not been highly compacted, such as a road cut. The user enters an estimate of the vegetated cover, which may be zero. This treatment may best describe forest conditions the year of a prescribed fire, or conditions 1 year after a wildfire. If there has been a high severity fire, and the soils are NOT water repellent, this is probably the best selection, but with a cover reduced to about 60 percent, or that observed on the site."]
[null,"High-severity fire","This condition describes areas that have experienced a high-severity fire and soils may be water repellent. Vegetation is assumed to reach a maximum height of 0.15 m (6 inch) with a spacing of 0.15 m (6 inch)."]
[null,"Skid trail","This condition describes a skid trail with vegetation reaching a maximum height of 0.15 m (6 inch) at a 0.1 m (4 inch) spacing. The soil is assumed to be compacted. This treatment would also describe any site mechanically disturbed and compacted --as long as the user estimates the amount of cover--such as landings, forwarder tracks, skyline paths, etc. If the soils remain compacted during the regeneration period, then the user is advised to use the skid trail for the first five years of regeneration, using increasing amounts of cover to describe local conditions. The time required to achieve 100 percent cover may be as short as 2 years in Eastern forests."]
[]
[]
["Rock Percentage"]
[]
[null,"Rock fragments in WEPP are considered rocks in the soil. As such, WEPP assumes that as water moves through soil, it must flow around the rocks. Therefore, WEPP reduces the hydraulic conductivity of the soil in direct proportion to the rock content (i.e. 20 percent rock will reduce the hydraulic conductivity by 20 percent). WEPP will not accept a value for rock content higher than 50 percent, so even when the user puts 100 percent rock into the rock content box, WEPP assumes that it is only 50 percent. In this context, as rock content increases up to 50 percent, runoff increases, as does rill erosion. Above 50 percent, there is no further impact modeled from increased rock content.   \n\n"]
[]
[]
[]
[]
[]
["Hillslope"]
[]
[null,"Columns referred to in the diagram below are the corresponding column in the Hillslope Data page in which to put the specified value."]

{"sheet":"Hidden","index":8,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["DO NOT MODIFY ANY VALUES IN THIS SHEET"]
["OK"]
[]
["Years to simulate"]
[10]
[20]
[30]
[40]
[50]
[]
["Soil Types"]
["clay loam"]
["silt loam"]
["sandy loam"]
["loam"]
[]
["Treatments"]
["20 Year Old Forest"]
["5 Year Old Forest"]
["Shrubs"]
["Tall Grass"]
["Short Grass"]
["Low Severity Fire"]
["High Severity Fire"]
["Skid Trail"]
[]
[]
["sediment delivery"]
["yes"]
["no"]
[]
["feet"]
["acres"]
["inches"]
["tons/acre"]
[{"$f":"LEFT(erosion_units,FIND(\"/\",erosion_units,1)-1)","v":"tons"}]
[]
["10"]
[]
[]
[{"$f":"COUNT('Hillslope Data'!D22:D29879)","v":72}]
[]
[]
[0]