Supported Formats
The format of the data to be imported or exported depends on the model definition that you are working with. It is recommended that you export a table to a file to check how the data is formatted, you can then format data similarly for the import.
The following is an overview of the data format for each feature that supports reading or writing of Excel files:
•
Parameters: the first column in the cell range defines the parameter name, the second its expression, and the third optional column the parameter description.
The parameter unit can also be defined in the file with an extra column included between the expression and the parameter description. For these data formats you need to select Separate units column in the Excel load dialog.
Same as for the units, the parameters value can be included in an extra column. For these data formats you need to select Calculated values in the Excel load dialog.
If you want to include both units and parameters values, the units column must be placed between the expression and the parameters value columns. For these data formats you need to select both Separate units column and Calculated values in the Excel load dialog.
•
Variables: the first column in the cell range defines the parameter name, the second its expression, and the third optional column the parameter description.
•
Interpolation functions: the first cell column in the cell range defines the value of the input argument parameter t, and the second column defines the value of the function f(t).
•
Piecewise functions: the first column in the cell range defines the start of the interval, the second column defines the end of the interval, and the third column defines the expression for the function.
•
Parametric Sweep and Auxiliary Sweep: the first column in the cell range defines the parameter name, and the second column contains the list of the parameters separated by space.