Can we export all dashboards from multiple replications to excel?

Question

question

Ignacio asked Nov 16, '20 Ben Wilson commented Nov 21, '20

Can we export all dashboards from multiple replications to excel?

I am trying to export all data to analyze and compare outside of Flexsim.

I tried adding the dashboard to a statistic collector as suggested on

https://answers.flexsim.com/questions/64489/exporting-dashboards-to-excel.html

but I don't see the tables populate on the Excel module.

Software Version:

FlexSim 20.1.2

experimenter flexsim 20.1.2 export data

· 1

5 |100000

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

Ben Wilson ♦♦ commented · Nov 21, 2020 at 05:35 PM

Hi @Ignacio, was Jordan Johnson's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2020-11-16T15:53:03Z

Jordan Johnson answered Nov 16, '20

Exporting all replication data to Excel is on the dev list, but is not currently a feature in FlexSim.

You can export the replication data from a single stats collector by making a Calculated Table, with a query like this:

SELECT * FROM [Experiment.Name of Table]

Then, you can export that calculated table using the Excel tool. The Name of Table can reference any Statistics Collector, Calculated Table, or Chart Template.

ReplicationDataExport.fsm

replicationdataexport.fsm (137.2 KiB)

5 |100000

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

question