Problem of exporting to Excel

Question

question

jenny asked Aug 21, '23 Matthew Gillespie commented Sep 8, '23

Problem of exporting to Excel

Hello,

I have question about exporting to Excel. If I export the data from "Statistics Collector" to Excel, there're some garbled characters. But, if the data from "Global Table", the data can be displayed correctly. Is't because the data from "Statistics Collector" cannot be exported in Traditional Chinese?

I have another question about tracker. I link the tracker to the parameters, and set Dashboard Control Value. I drag the tracker to control value when the simulation is stopped, and after the simulation starts, the tracker return to initial positions.

How should I do above two questions?

Thanks in advance!

DataTest.fsm

Software Version:

FlexSim 23.1.3

excel export tracker

global-table.jpg (72.5 KiB)

1692629299898.gif (60.9 KiB)

statistics-collector.jpg (104.5 KiB)

datatest.fsm (33.5 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.

Answer 1 · 2023-08-31T18:18:41Z

Jordan Johnson answered Aug 31, '23 Matthew Gillespie commented Sep 8, '23

Thank you for reporting this issue. I have added this bug to the dev list. Unfortunately, there's not a straightforward workaround. If it is critical to get the data to Excel, you could change the Statistics Collector (or create a second one) that collects times in Excel format. You can use the convert() command for this.

https://docs.flexsim.com/en/21.1/Reference/CodingInFlexSim/CommandReference/Commands.html#convert

· 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.

Matthew Gillespie ♦♦ commented · Sep 08, 2023 at 06:59 PM

@Jenny This issue has been fixed in 23.0.11 and 23.2.1 released today.

0 ·

Answer 2 · 2023-08-21T17:12:22Z

Jason Lightfoot answered Aug 21, '23 jenny commented Aug 22, '23

As a workaround for the export for now you can change the stats collector to store either the numeric excel value (fractional days since 1900) or the string value. You can convert the date time using the Datetime methods.

· 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.

jenny commented · Aug 22, 2023 at 02:40 AM

Hi Jason,

Thanks for your quick reply, appreciate!

If the string value is Traditional Chinese, exporting the data from "Statistics Collector" to Excel, the data can't be displayed correctly.There're also some garbled characters.

Datatest_2.fsm

0 ·

pic.png (100.3 KiB)

datatest-2.fsm (32.7 KiB)

question