Creating multiple parameters in a spreadsheet

You can create numerous parameter names and values in Microsoft Excel spreadsheets and apply them all at the same time.

When these are created, the parameters are available to be used in a text box on dialogs.

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

To create multiple parameters, you need to enter the data into the spreadsheet.

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

   

3. Select to modify the spreadsheet. A Microsoft Excel spreadsheet is displayed.

   

4. Enter one column with parameter names and another column with their values.

   The example below shows parameter names entered in column A and their values entered in column B.

   

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. On the Parameter Editor dialog, select to create multiple spreadsheet parameters.

   The Multiple Spreadsheet Parameters dialog is displayed.

   Use this dialog to create a set of parameters with the values entered on the spreadsheet that are to be available to be selected in dialogs.