question

Aaron C avatar image
0 Likes"
Aaron C asked Aaron C commented

Export a Throughput Template table after each replication in Experimenter?

I have a Throughput Per Week widget on my dashboard. I can open it up and view the table it creates on the dashboard when running the model in 3D view, but I would like to export that table after each replication when I run the Experimenter. I've worked with the End of Replication commands before, but I can't seem to figure out how to get at the Throughput Per Week table and export it with FlexScript at the end of each replication.

FlexSim 19.0.0
experimenterdashboard datareplication
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joshua S avatar image Joshua S commented ·

In what format do you want it to export it in? Do you want an individual excel file for each replication?

0 Likes 0 ·
Aaron C avatar image Aaron C Joshua S commented ·

Hi @Joshua S ! Either .csv or excel format would be fine! Preferably, I'd like to have it all in one file. That way I can then use Excel's pivot tables to organize/calculate the data I need without having to merge files.

0 Likes 0 ·

1 Answer

Jordan Johnson avatar image
1 Like"
Jordan Johnson answered Aaron C commented

When you run an experiment, be sure to check the "Save statistics data for each replication" box.

If your plot is called "Throughput Per Hour", and you have already run an experiment with that box checked, you can make a new Calculated Table, and use this query:

SELECT * FROM [Experiment.Throughput Per Hour]

Then you can right-click the Calculated Table in the Toolbox and choose Export to CSV.

experimentdatademo.fsm


· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Aaron C avatar image Aaron C commented ·

Worked perfectly!! Thanks @jordan.johnson !

0 Likes 0 ·