Problem of exporting to Excel

[Jenny12]

[ FlexSim 23.1.3 ]

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

[jason_lightfootVL7B4]

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.

[Jenny12]

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

[JordanLJohnson · Accepted solution]

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

[Matthew_Gillespie]

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