Spreadsheet Element Inputs: Exporting Data to the Spreadsheet

If you press the Export… button from the Import or Export Selection dialog (and the checkbox for using the wizard is cleared), or if you select an existing input in the main Spreadsheet dialog and press the Edit… button, the following dialog is displayed:

This dialog 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.

1. Select the GoldSim output that you wish to export to the spreadsheet by pressing the Select Output… button, which will display 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. The Units in Spreadsheet 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.

3. The Name of the input 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 this dialog and is useful for helping to document your spreadsheet link.

4. You must then select the location in the spreadsheet to which you wish to export the GoldSim data. You can do this by 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.

If you would like to edit the location of several inputs (or outputs) simultaneously by shifting them by sheet, row or column, you can do this from the main Spreadsheet element dialog using the Shift… button.