question

立洲 avatar image
0 Likes"
立洲 asked 立洲 commented

Excel or Source set staff output schedule

使用Excel安排的日期和時間如何或在源中設置相應的日期和時間

Excel時間表中,數據應該如何描述,如下,請幫我修改參數數據以規定文件格式時間表

病人入院時間(1).xlsx

病人入院時間.xlsx

病人入院時間.fsm

FlexSim 20.0.10
excel importflexsim healthcareschedule
· 2
5 |100000

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

立洲 avatar image 立洲 commented ·

@瑞安克拉克 In addition, I would like to ask, how to obtain the resources corresponding to the Group according to the Label of the Global Table in the Location or Acquire Location of HC

0 Likes 0 ·
Ryan Clark avatar image Ryan Clark 立洲 commented ·

Hi @立洲,

Would you please ask this question as a separate post? This is because this is a separate question unrelated to the original topic of the question (Excel import). Thanks!

See Best practices for using this Answers site - FlexSim Community for more info.

0 Likes 0 ·

1 Answer

·
Ryan Clark avatar image
0 Likes"
Ryan Clark answered 立洲 commented

Hi @立洲 ,

It appears that the Excel Import/Export is working as it should. However, in your Excel files, the date/time is not formatted correctly to import into FlexSim. In your Excel files, you are indicating the start date as 110/05/09 instead of 2021/05/09, so FlexSim doesn't recognize the date properly. In order to import the data properly into Excel, you will need to update the date/time format in your Excel spreadsheets.

I hope this helps! Let us know if you have further questions!

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

立洲 avatar image 立洲 commented ·

@Ryan Clark 你能幫我創建一個可用的Excel示例供我參考,因為我如何使用它,我無法準確地執行我想要的操作

0 Likes 0 ·
Ryan Clark avatar image Ryan Clark 立洲 commented ·

Hi @立洲,

I was able to modify your Excel file and your model to import the correct data for your patient arrivals. I did a bit of a workaround in the Excel file by finding the amount of time in seconds that had elapsed since the model start time and using that as the time to import. Then, in the Arrivals table, I selected the option "From Time 0," so it counted from the model start time being time 0, then counted from there.

Also, in the Excel Import/Export tool, you need to specify the correct sheet of the Excel workbook. I have the values I'm using on "Sheet5" of my file, so I inputted that in the options for the import.

PatientSchedule-rc-v2.fsm

xlsx.xlsx

I hope this helps! Let us know if you have further questions!

0 Likes 0 ·
xlsx.xlsx (26.1 KiB)
立洲 avatar image 立洲 Ryan Clark commented ·

Thank you ~~

1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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