Exporting simulation date to Excel via spreadsheet element



1 comment

  • Avatar


    Thanks for posting in the GoldSim Community Forum. If you have 1-day time steps in the model and you want to export monthly values, then I would suggest that you enable Reporting Periods and export using a Time History Result element instead of a Spreadsheet element. Enable Reporting periods in the simulation settings dialog.


    With Reporting Periods enabled, you can configure your Time History Result element to export on the reporting periods:

    Please let me know if this works for you.

    I'm guessing that the reason you see blank rows in your case, is because the offset value needs to be an integer and you are running into a rounding issue the the calculation of your offset. Hopefully you can export using the Time History Result element, which is a lot easier for time history data.

    Comment actions Permalink

Please sign in to leave a comment.