Batch ERMiT interface spreadsheet

Download Batch ERMiT interface spreadsheet (Note: pre-2017 versions no longer work)

• Version 2022.03.22 (2.2 MB .xlsm file) for burned and unburned conditions & PEP – Windows 10 and Excel 2016-compatible with rock % import
• Version 2018.04.01 (2.2 MB .xlsm file) for burned and unburned conditions & PEP – Windows 10 and Excel 2016-compatible
• Version 2017.02.03 (2.4 MB .xls file) for burned and unburned conditions & PEP

We welcome any feedback you have.

Some hillslopes, especially for unburned conditions, produce a truncated ERMiT results page, which creates an "Error 5" and halts the batch run.
We are working on making the spreadsheet more robust.

This spreadsheet is designed to make running multiple ERMiT scenarios much more efficient. The spreadsheet interface is downloaded and run on one's PC, but the ERMiT model runs are on our server.

Requirements

• Microsoft Excel version 2016 or newer (365 highly preferred)
• An internet Connection

Optional

• The Hillslope Delineation Toolbox, an ArcInfo .tbx file that one downloads and installs on one's PC. It can assist in collecting input values for the Disturbed WEPP Batch or Batch ERMiT interface spreadsheets.

Enable Macros

These workbooks require macros to load the input data and query wepp runs. Below are two options to enable macros. We recommend using Option 1 if you have the necessary permissions to modify your Internet Options security settings. However, if you have a government computer, you might not have this capability, and you'll need to proceed with Option 2.

Option 1: Add to Trusted Sites

This method involves adding forest.moscowfsl.wsu.edu to your list of trusted sites through the Internet Options.

1. Open the Control Panel on your computer.
2. Select Network and Internet.
3. Select Internet Options.
4. Click on the Security tab.
5. Select Trusted Sites (it has a green check mark icon).
6. Click on the Sites button.
7. Under "Add this website to the zone:", enter forest.moscowfsl.wsu.edu and click Add.
8. Click Close and then OK.

Option 2: Add a Trusted Location through Excel's Trust Center

If you can't modify your Internet Options security settings, follow these steps to add a Trusted Location through Excel:

1. Open Microsoft Excel.
2. Click on the File tab located at the top-left corner.
3. Choose Options from the menu list.
4. In the Excel Options window, select Trust Center from the list on the left.
5. Click on the Trust Center Settings... button.
6. Choose Trusted Locations from the list on the left.
7. Click on the Add new location... button.
8. Browse and select the location where your Excel tool is saved.
9. Ensure the "Subfolders of this location are also trusted" option is checked if you want to trust all subfolders within the chosen location.
10. Click OK to confirm and add the location.
11. Click OK again to close the Trust Center Settings.
12. Finally, click OK to close the Excel Options window.

Hints

1. View –> Full Screen to display (more of) the entry fields (right-click on spreadsheet border and Restore to get menus back)
2. Use the zoom tool
3. Hillslope horizontal length limit is 1,000 feet (300 meters) in the interface
4. Keep a clean version of the interface spreadsheet, and make a copy for each project – save it under a different name before running the batch, and again after to save the results.
5. Some hillslopes, especially for unburned conditions, produce a truncated ERMiT results page, which creates an "Error 5" and halts the batch run. We are working on making the spreadsheet more robust.

Send us comments