Tour Page 11


Linking to Spreadsheets and Databases

GoldSim Quick Tour (11 of 23)

Spreadsheet LinkageGoldSim allows you to dynamically link a spreadsheet directly into your model. In the simplest use of a such a spreadsheet link, you can use the spreadsheet as a data source. In addition to importing data from a spreadsheet, you can use a spreadsheet as a custom element (with specific functionality). That is, you can dynamically send data from GoldSim to a spreadsheet, force the spreadsheet to recalculate, and then retrieve (updated) data from the spreadsheet back into GoldSim during a simulation (e.g., every timestep).

GoldSim also provides powerful capabilities to easily import lookup tables and time series data from spreadsheets to GoldSim. You can also readily export GoldSim results to a spreadsheet.

GoldSim also allows input elements to be linked directly to an ODBC-compliant database. After defining the linkage, you can then instruct GoldSim to download the data at any time. When it does this, GoldSim internally records the time and date at which the download occurred, and this information is stored with the model results. This mechanism provides very strong and defensible quality control over your model input data.



Making Better Decisions In An Uncertain World