Downloading Excel data locally into GoldSim




  • Avatar

    When you run your model, it will automatically import the data. This is the case for spreadsheet elements, lookup tables and time series elements that import data. But are you saying you would like to be able to run the import while in Edit mode, before you start your simulation? In that case, you could have a dashboard button that opens the lookup table element. Then you can click the button in the lookup table element that runs the import. Unfortunately, this might not be ideal if you have multiple lookup tables that import data. I think the closest thing to what you are talking about is a button command that updates all importing spreadsheet elements in the model. But we don't have something similar for lookup tables.

  • Avatar

    I've looked into it a little bit more and I did confirm that if you use spreadsheet elements, and you have already done an initial import, you can thereafter run the model without the Excel file present. The below screen capture of a dashboard button illustrates this. In this case, you can click the 'Import All Data' button in the dashboard, in Edit mode, and it will update all spreadsheet elements.


    With the data then stored in the spreadsheet elements, you can put the .gsm file in a folder without the original Excel file and it will run. It will just issue a warning message, as shown in the first screenshot below, and log a warning in the run log, as shown in the second screenshot below.

    I believe that the behavior is the same for lookup tables and time series elements. The disadvantage in those cases, however, is that you don't have a dashboard button command (like you have for spreadsheet elements) that runs an Edit Mode import. But if you do want to use lookup tables instead of spreadsheet elements, can you consolidate the data import to just a few lookup tables using 2-D or 3-D lookup tables? To be able to do this, all data imported by a given lookup table has to have the same units.

    I hope this helps. Let me know if you have any questions.


Please sign in to leave a comment.