Disturbed WEPP batch interface spreadsheet

We welcome any feedback you have.
This spreadsheet is designed to make running multiple Disturbed WEPP scenarios much more efficient. The spreadsheet interface is downloaded and run on one's PC, but the Disturbed WEPP model runs are on our server.

Requirements

Optional

Enable Macros

These workbooks require Macros and ActiveX 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 or Option 3.

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.

Option 3: Unblock the worksheet

Set Unblock for the worksheet:

  1. Right-click the file in Explorer and click Properties
  2. In the Properties window, select Unblock under the Security section of the General Tab.

Enabling ActiveX Controls in Excel's Trust Center

If you encounter a Run-time error '438': Object doesn't support this property or method when using the WEPP Batch Tool, it may be due to Excel blocking ActiveX controls. Follow the steps below to fix this:

Step 1: Understand the Error

You might see this error message when Excel prevents ActiveX from initializing:

Run-time Error 438
Step 2: Change ActiveX Settings in the Trust Center
  1. Open Microsoft Excel.
  2. Click the File tab in the top-left corner.
  3. Select Options.
  4. In the Excel Options window, click Trust Center from the list on the left.
  5. Click the Trust Center Settings… button.
  6. Choose ActiveX Settings from the left pane.
  7. Select the option: Prompt me before enabling all controls with minimal restrictions.
  8. Make sure Safe mode is also checked.
  9. Click OK to apply the changes and close the dialogs.

The correct configuration should look like this:

Trust Center ActiveX Settings

Once you've updated these settings, close and reopen the Excel workbook. If prompted, allow macros and ActiveX content to run.


Send us comments