Still having problems getting patients from the Source Table.

Question

question

Tee Hiett asked Nov 13, '20 Ben Wilson commented Dec 1, '20

Still having problems getting patients from the Source Table.

I have been following your instructions at:

https://answers.flexsim.com/answers/93417/view.html

but I'm still having trouble getting the data into and out of the source table correctly. When I replace the Source table in the attached model and Edit Arrivals, the values for Start and End are correct. When I import the values from the attached Excel file, the values for Start and End are read-only.

In the attached model, I have tried Copy and paste and the values look correct to me but the two patients don't come into the model.

Any suggestions?? As you can imagine, this is very frustrating.

Thanks for your help

Book1.xlsx

Cardio First_1 With Subs Flow.fsm

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 healthcare import source table

book1.xlsx (11.8 KiB)

cardio-first-1-with-subs-flow.fsm (1.6 MiB)

· 1

5 |100000

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

Ben Wilson ♦♦ commented · Dec 01, 2020 at 03:23 PM

Hi @Tee Hiett, was Cliff King's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2020-11-13T19:39:47Z

Cliff King answered Nov 13, '20 Jason Lightfoot commented Nov 23, '20

How did you create the data in your Excel file? It doesn't look right. I suggest you follow along with the steps of this video (https://www.youtube.com/watch?v=E4X9l2xoeZc&t=2985s) and you will save yourself a lot of headaches. The key step I think you are missing is to first generate a little bit of data in the Date Time Source and then copy/paste the data into an Excel spreadsheet to act as a starting point and to ensure all the cell formats are correct. This is what I do in the video. You also will want to set the "Time Mode" field in the Date Time Source table to "Use Model Start Date/Time" or you may miss arrivals occurring before you defined model start time. This is covered in the video as well. That video really is the bible for defining and importing patient arrivals!

· 2

5 |100000

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

Tee Hiett commented · Nov 18, 2020 at 05:16 PM

@Cliff King, @Brittany Evans , @Matthew Gillespie

After hours and hours of experimentation, I'm still having difficulty getting patients into the model.

I have tried the using the first column as the Start (DD:)HH:MM:SS column and Second column as the End (DD:)HH:MM:SS column. As Cliff suggested, I copied and pasted the first 2 columns from FlexSim to be sure the data was formatted correctly (Custom(h:mm:ss)). With this process, I get the times imported to the Arrivals table as read only.

My second approach, as seen in the Advanced view of the Arrivals table, was to have the First column showing the Start Time in minutes and the second column showing the Duration also in minutes. Although this process seemed to show the data in the correct format in the Arrivals table, The patients may or may not come into the model.

I've included the FlexSim model and an Excel Workbook with a worksheet with each of these approaches.

I would appreciate any help identifying my problem.

Tee

Book1.xlsx

cardiology.fsm

0 ·

book1.xlsx (16.3 KiB)

cardiology.fsm (1.6 MiB)

Jason Lightfoot ♦♦ Tee Hiett commented · Nov 23, 2020 at 02:50 PM

I'm trying to fix my install so I can test this but in the meantime:

That workbook still doesn't look right, does it? I think you're meant to have the whole day's worth of time slots. Also - I'd check that the start time of the model matches the data, and maybe consider trying it starting the run from 00:00:00 with time slots in excel from 00:00:00 to 24:00:00.

0 ·

question