Exporting Distribution Results Data Table to Excel

Answered

Follow

Michael Vogler

• April 04, 2024 17:27

I am a new GoldSim user so apologies for any incorrect nomenclature. I have a data table in a distribution result element and would like the data to be exported to excel without having to copy and paste the table multiply times (I currently have to do this for about 100 tables). The data is various radionuclide inventory doses set up with stochastic  1-D vector species data and then run for 1000 realizations. I need to export all doses from each species from all 1000 realizations so that the distribution results can be read into another model (currently done by reading in Excel spreadsheets). Is there a way to write the data into Excel or export the data table at all? Or is there a way to have the data converted into a time history result element? I see that GoldSim already has a function for exporting data tables to Excel from a time history element. Any help or insights would be appreciated. 

Best,

Mike 

1

• 

  Jason

  • April 04, 2024 22:00

  Mike, 

  You can export the final value output from each realization of the model by using the Spreadsheet element with an offset defined like this:

  Row offset: ~Realization - 1

  The above would be defined when you add the export item to the Spreadsheet element. Please see this section of our online documentation for more information: Defining Offsets for Inputs and Outputs to a Spreadsheet Element (goldsim.com).

  If you need more information on how to use the Spreadsheet element, please see this page: Spreadsheet Elements (goldsim.com).

  Please let us know if this answers your question.

  Regards,

  Jason

  1

  Comment actions Permalink
• 

  Michael Vogler

  • April 05, 2024 16:26

  Jason,

  Thank you so much for the help. That worked for me. I did look over the spreadsheet element before but I missed the offset option for including all realizations. 

  Mike

  0

  Comment actions Permalink

Please sign in to leave a comment.