This question was asked by a customer in December 2015 and we felt the question was good enough for all users to see.
“We have recently developed a water balance model for our Mine Site using actual data retrieved from our flow meters and input sheets. During each simulation, the model imports the relevant data from a destination Excel sheet. Is there a method of downloading the Excel data locally into GoldSim to make this process easier?
The idea behind the Excel data sheet is to actively calculate averages and standard deviations of our data when it's updated and, to facilitate user input, to avoid copy/pasting the data from Excel to GoldSim manually. In addition, saving the data locally would allow for its usage outside of our network.“
“So, right now the sheet is importing data from an Excel sheet located on a specific drive, so that someone on our site using the computers can access the data. GoldSim does this each simulation period; seeks out the Excel sheet and retrieves the values, populating temporary variables in GoldSim. At the end of the simulation period, these values are lost (I assume) as GoldSim wraps up. What I want to do is be able to download/update these values (such as averages and standard deviations) into GoldSim to avoid importing every simulation period.
The data would be imported just as static values; Excel does all the work of calculation. And they would mostly be 2-D matrices, with values of Average, StDev, Max and Min corresponding to each Month. Those values are used to population Stochastic Distributions.
If there is alternatively a way to retrieve an Excel Spreadsheet from a web address, that would also suffice for what I want it to do.”