Optimization of patient arrivals based on conditions

Question

question

Estephe DLDL asked Mar 18 2019 at 9:15 AM Cliff King commented Mar 28 2019 at 1:50 PM

Optimization of patient arrivals based on conditions

Hello,

I am currently working on a simulation analysis and I need your help.

The objective is to schedule patients based on certain conditions and rule.

A patient has certain data and it needs to be taken into account to be scheduled :

An ESOP : early start of operation which means the first day of the week we can schedule the patients. (1=monday, 5=friday)
A LSOP : late start of operation which means the last day of the week we can schedule the patient
A number of anesthetists and nurses required for the full length of surgery
A surgery duration
A surgeon assigned to the operation
A room assigned for the operation. If possible I would like to use a binary table to also have the possibility to change the room assignment with specialized operating rooms and a specialty for an operation.

The objective will be to schedule patients based on these data and other basic conditions, such that the operating rooms are open from 8h00 to 16h00 (an operation can finish after, and if we don’t have the choice we can schedule a patient at 16h00 to be operated at 16h45 for example) and most important we want the longer operations, or shorter (depending of the model, both will be done), to be scheduled first.

Before I was working with an appointment table with a room assigned for a specific hour, but now the objective is to het this based on our conditions.

I feel that this is more an optimization problem than a simulation problem, but is it possible to do it on flexsim HC ?

The final objective is to check performance indicators such as average LOS, utilization of rooms, nurses etc.

You can find attached (beginning of the post) my basic model, with the data in the global table.

Thanks by advance,

Sincerely

Software Version:

FlexSim HC 5.3.10

operation room

test-optimization-arrival.fsm (968.4 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2019-03-18T23:28:19Z

Cliff King answered Mar 18 2019 at 11:28 PM Cliff King commented Mar 28 2019 at 1:50 PM

A closely related topic was discussed a couple years ago on this site that you might find interesting. Take a look at what was said and the the sample model I uploaded at the end of the thread, and let me know what your thoughts are! https://answers.flexsim.com/questions/32789/advice-needed-healthcare-or-suite.html

Cliff

· 5

Estephe DLDL commented · Mar 24 2019 at 1:47 PM

I have read the thread, and opened every file to understand better. It is really interesting and it is close to what I would like to achieve. One problem is that with my student licence the model is too big so I think I don't have access to the moel finally cause when I try to look at the excel import, the SPTF formulation, how it is set, I don't have anything.
I don't know if it is because of my licence or because it is somewhere else but I don't know where then.
My model is much simpler, because we only focus on operating rooms, the patient comes in, he goes in the room and the surgeon and staff comes, operation occurs and then he leaves.
It is close to what you did but in a simpler way. Problem is that I have different constraints, such as availability days for the patient and the surgeon. My problem is based on a week and not a single day. I don't know if since then you have went further in order to achieve a week or not ?

Thanks

0 ·

Cliff King Estephe DLDL commented · Mar 27 2019 at 1:34 PM

I never did take that model any further to include more than a single day. Including constraints such as availability days for patients and surgeons would indeed make the scheduling problem more challenging. I really don't know how you would solve this problem without writing all the code yourself for the scheduling piece.

In the following post, I attached an example model at the end of it called "dynamically-fill-appt-slots-daily.fsm" where I used flexscript code to manipulate the patient Appointments Table dynamically that could give you some useful tips as well

https://answers.flexsim.com/questions/61817/how-to-create-random-arrival-schedules-with-fixed.html?childToView=62621#answer-62621

Good luck!

0 ·

Cliff King Cliff King commented · Mar 27 2019 at 1:47 PM

Also, the script that builds the patient arrivals schedule in the PreOp-OR-PACU model can be found in the Post Import Code editor of the Excel Import/Export Interface. I've attached a text file of the code if for some reason you still can't access it from within the model.

postimportcode.txt

0 ·

postimportcode.txt (18.9 KiB)

2019-03-27-7-47-35.jpg (535.5 KiB)

Show more comments

question