Exporting and Editing Parameter Sets to an Excel Spreadsheet
MapleSim lets you export parameter sets for your model to an Excel spreadsheet where you can view, edit and do a side-by-side comparison of the values.
Note: You must first create and save a parameter set as part of a model. For more information, see Saving and Applying Parameter Sets.
To export a parameter set from MapleSim into an Excel spreadsheet
Open the model that contains the parameter set you want to export.
In the main toolbar, click Show Apps Manager ( ). The Analysis window opens with Apps tab selected.
From the Apps palette on the left, double-click on the Excel Connectivity App. The Excel Connectivity App opens in the Analysis window.
In the Excel Connectivity app, scroll to the Export to Excel section.
From the Parameter Set File in MapleSim list, select the parameter set you want to export.
To change the file location and name, select the Set Default File Location check box, and enter the file location.
Click Export to Excel. The file is saved.
Repeat the procedure for each additional parameter set that you want to export to the same Excel spreadsheet.
You can now edit the values in the Excel spreadsheet and then import the parameter set back into MapleSim using the Excel Connectivity App. Your newly created Excel spreadsheet will have the following format:
The first column of the spreadsheet represents the parameter names of your model. The heading for this column must be MapleSim Filename Params.
Any subsequent column represents the values of a parameter set. The heading of any such column must be of the form filename.params. This heading will be used as the parameter set file name in MapleSim.
In the example spreadsheet below, columns B and C correspond to the parameter sets bbc and afa. The contents of these two parameter sets will be imported to MapleSim as parameter files called bbc.params and afa.params, respectively.
If, for example, you wanted to change the value of the parameter, simulation.relerr in the bbc.params parameter set, you would edit the cell B2, save your changes and then import the parameter set back into MapleSim.
If you wanted to change the value of the parameter R1.T from 300.1500000 K to 400.1500000 K, in the afa.params parameter set, you would edit the value enclosed in parenthesis in the WithUnits() command, in cell C8, save your changes and then import the parameter set back into MapleSim.
See Also
Saving and Applying Parameter Sets
Using a Parameter Set in a Simulation
Running a Simulation
Deleting a Parameter Set
Renaming a Parameter Set
Specifying Parameter Values
Specifying Parameters for Multiple Components
Comparing Parameter Sets
Download Help Document
