topic Can we export all dashboards from multiple replications to excel? in FlexSim Forum

Can we export all dashboards from multiple replications to excel?

ignacio_g4 — Mon, 16 Nov 2020 14:30:05 GMT

[ FlexSim 20.1.2 ]

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.

Re: Can we export all dashboards from multiple replications to excel?

JordanLJohnson — Mon, 16 Nov 2020 15:53:03 GMT

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

Re: Can we export all dashboards from multiple replications to excel?

Ben_WilsonADSK — Sat, 21 Nov 2020 17:35:41 GMT

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.