question

Jun J2 avatar image
0 Likes"
Jun J2 asked tannerp edited

How to paste the results from "statistical table" when the data is too large

I have pasted the results from "Statistics Tables" directly to Excel. I found there are two problems of doing this. First, it takes longer to paste it when the data is large. The second, it can only paste the data within 1,046,697 columns into Excel. Is there a better way to do this? Thanks for your help!

FlexSim 20.2.2
flexsim 20.2.2export data
1602710074637.png (65.9 KiB)
1602710245691.png (27.4 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

tannerp avatar image
1 Like"
tannerp answered tannerp edited

You can try checking the "Save statistics data for each replication" box. This will work if you're using a Statistics Collector by saving the data in the Stats Collector after each replication.

Then, you can set up a trigger on End of Replication to export the Stats Collector. The data will export in CSV format, which should make it easier to import into Excel.

The code used to export a table is just:

exporttable();

Someone may come along with a superior idea, but that's what I have to offer. Feel free to comment back if you run into any issues. Hope this helps!


1602714089647.png (36.6 KiB)
1602714131536.png (24.8 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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