Creating parameters in a spreadsheet

For models that require complex calculations or have specific data associated with them, these values can be created and edited in a Microsoft Excel spreadsheet that is stored with the model.

Each new model has a new, blank spreadsheet ready for use.

Note: You need a licence for Microsoft Excel to use the spreadsheet options.

1. Select Home tab > Utilities panel > Parameters to display the Parameter Editor dialog.
2. Select the Spreadsheet tab.

   

3. Click to display a Microsoft Excel spreadsheet.

   

4. Enter values and any calculations into the spreadsheet.

   

5. Select File, and select Close and return to New_Model_1, where New_Model_1 is the name of the current model in PowerShape.
6. In the Parameter Editor dialog, Select New and enter the parameter name in the Parameter text box.
7. In the Cell box, enter the cell for the value you want to work with.

   For example enter A3.

8. Click to display the cell's value in the Expression text box.

   

9. Click Apply to store the parameter and continue.
10. Click OK to store the parameter and exit.