Excel or Source set staff output schedule

[leelichou1112]

[ FlexSim 20.0.10 ]

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

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

病人入院時間(1).xlsx

病人入院時間.xlsx

病人入院時間.fsm

[ryan_c10 · Accepted solution]

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!

[leelichou1112]

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

[leelichou1112]

@瑞安克拉克 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

[ryan_c10]

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!

[ryan_c10]

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.

[leelichou1112]

Thank you ~~