Automate Excel Templates

SWedge Excel Templates are designed to work in conjunction with the Automate from Excel feature. There is a specific template for each Analysis Type in SWedge, as inputs are specific to each type.

Blank Excel Templates

There are 3 Excel Templates in SWedge:

• Deterministic Excel Template
• Probabilistic Excel Template
• Combinations Excel Template

To open a blank Excel Templates for Deterministic, Probabilistic, or Combinations analysis:

1. Select Deterministic Excel Template, Probabilistic Excel Template or Combinations Excel Template from the Analysis > Automate Compute sub-menu.
2. A blank read-only Excel Template will open.
3. Make changes as necessary and Save As to the desired directory.

Create Excel Template From Current

The Create Excel Template From Current gives users the option to generate the appropriate Excel Template using current model inputs. This serves as a good starting point to set up an Excel Template since you are not starting from scratch. All that is necessary is changing the specific entries which are going to differ from your current model for each case (in each row).

To open the corresponding Excel Template based on the current Analysis Type and model input data:

1. Select Create Excel Template From Current from the Analysis > Automate Compute sub-menu.
2. In the Create Excel Template from Current dialog:
   1. Set the Number of Rows to Populate.
   2. Select OK.
3. A read-only Excel Template will open. The Excel Template will contain the specified number of rows of data, populated directly from current model inputs.
4. Make changes as necessary and Save As to the desired directory.