If you press the Export… button from the Import or Export Selection dialog, and the checkbox for using the wizard is checked, the Spreadsheet Wizard will be displayed:
This wizard is used to create an input to the Spreadsheet element. An input to a Spreadsheet element is defined as an existing GoldSim output that you wish to export from GoldSim to the spreadsheet file. Until you become comfortable creating inputs and outputs for Spreadsheet elements, it is recommended that you use the wizard.
The wizard has four pages:
1. On the first page you must select the GoldSim output that you wish to export to the spreadsheet. The wizard displays a browser for selecting an output. You can select a scalar, a vector or a matrix. The output can be a Value or a Condition. True Conditions will export into the spreadsheet as 1; False Conditions will export into the spreadsheet as 0.
2. On the second page, you specify the Name of the input. It will default to Inputn, where n is an integer. This name is used to label the inputs to the Spreadsheet element in the browser and the element’s input interface. If you wish to, you can change this name, but it is not required. The optional Description appears only in the dialog for subsequently editing this Input and is useful for helping to document your spreadsheet link.
3. On the third page, you must specify the Units in Spreadsheet. They will default to the display units for the output that you selected. If the units of the data in the spreadsheet are different from this, you should change the units accordingly. Note that this page is skipped if the output is dimensionless or a Condition.
4. On the last page of the wizard, you select the location in the spreadsheet to which you wish to export the GoldSim data. You can do this specifying the Sheet Name and Cell Range directly. Alternatively, you can press the Location… button, which opens the spreadsheet and provides a dialog allowing you to directly select the desired cell range using your mouse.
Note: The size of the range
must be consistent with the dimensions of the input which you are sending to the
spreadsheet. Hence, a scalar input must map to a single cell; a vector
input must map to a single column or row range with the number of rows or
columns matching the number of items in the vector; and a matrix input must map
to a rectangular range with the number of rows and columns matching the
dimensions of the matrix (e.g., a matrix with 3 rows and 6 columns would have to
map to a range in the spreadsheet 3 rows long and 6 columns wide).
If required, you can control the sheet and cell range into which GoldSim exports data dynamically. For example, you could instruct GoldSim to change the location to which it exports data based on the simulation time or the realization.
Learn more about:
Spreadsheet Element Inputs: Exporting Data to the Spreadsheet
Defining Offsets for Inputs and Outputs to a Spreadsheet Element