question

Matthew W5 avatar image
0 Likes"
Matthew W5 asked

Milestone Timestamps do not match application Generate Report to Excel Workbook

I'm running a fairly simple model in Healthcare 24.2.2. I have 2 workflows that use unique Milestones for each workflow. When I run the experimenter and view the results on the Statistics Table tab, the milestone timestamps all appear to be populated with the correct values. However when I select the 'Generate Report' option and create an Excel Workbook, the timestamps for one of the workflows are no longer accurate and do not match the Person Milestones table in the application. Interestingly, if I export to CSV files, the values do appear to be populated appropriately, so it's only the export to the Excel workbook that is having issues.

I also only see this with one workflow, not both. Perhaps related, the non-populated milestone timestamps for the problematic workflow export as 'NULL', while the workflow that does extract appropriately, the non-populated timestamps export as '1/0/1900 12:00:00 AM' to Excel, while in the CSV extract, the non-populated values all export as '1/1/1601 12:00:00 AM'.

I don't want to publicly upload a copy of this .fsm due to potential organization identification, but I have added a couple screenshots of the export and the table within the workflow application.

Excel Export Person Milestones.png

FlexSim 24.2.2
milestones
5 |100000

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

0 Answers