question

Matthew W5 avatar image
0 Likes"
Matthew W5 asked Jeanette F commented

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
· 3
5 |100000

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

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Matthew W5,

Thank you for contributing to our community! We couldn't identify a maintained license or subscription linked to your account.

You may need to update your profile information to identify yourself as a license owner or their associate. Check out our article for how to ensure you receive timely support. If you update your profile comment back to let us know - we'll adjust the priority of your post accordingly.

If your current license is expired, please contact your local distributor to renew.

0 Likes 0 ·
Matthew W5 avatar image Matthew W5 Jeanette F ♦♦ commented ·
Hi @Jeanette F , I didn't realize my license information was no longer attached. I have had it re-added. Do I need to repost this question?
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ Matthew W5 commented ·
No, I will update your priority in our tracker
0 Likes 0 ·

0 Answers