Patient characteristics

Question

question

Estephe DLDL asked Nov 12, '18 Cliff King edited Nov 13, '18

Patient characteristics

Hello,

I'm currently finishing my thesis, working on flexsim HC and I have some last questions.
- I want to put my patients in my model, but I have more than 800 different patients, each patient has different caracteristics like the surgeon used, the OR used, the day he comes in, the length of the surgery, the number of anesthesists needed, the number of nurses needed. And I have no ideas how to put it in my model so it can be automatic and Flexsim understands that it will need that people and not others, that the patient will arrive at that time and not another. I have thought about using labels, but where do I put them ? in PCI ? in a global table ? And how do I put them in my excel document so it will be automatically understood after my flexsim ? Do I need 1 or more patient track as in global the track is always the same, only the caracteristics are changing.
- I want to limit the overtime per day, 2 hours max, how do i do it without stopping my current intervention ?

Here is my model if you want to check it out and modify it, there are some mistakes in the tracks because I have changed some things but not changed my tracks for the moment.

bloc-ope-hc.fsm

Thanks by advance,

Estèphe de Lussac

Software Version:

Choose One

patient condition

bloc-ope-hc.fsm (966.2 KiB)

Answer 1 · 2018-11-12T17:04:31Z

Cliff King answered Nov 12, '18 Estephe DLDL edited Nov 13, '18

This little example model I built should give you the basics of how to work with patient labels. Let me know if you have further questions.

roomnursedoctorlookup.fsm

roomnursedoctorlookup.fsm (180.8 KiB)

· 5

Estephe DLDL commented · Nov 12, 2018 at 05:47 PM

Thanks a lot for your example, it really helps me to get some points. I still have some questions.
In your model, I understand how I can specify which room will be used and which surgeon will be used aswell, also I can have the length of the operation with this method.

However I still have questions, can it help me for the day and the hour of the operation ? Is there any form that the software recognizes automatically ?.
And how can I do it for my nurses and my anesthesists as it is not fixed and the number vary depending of the operation. I have thought about putting in the staff requirements a "based on condition" requirement for both of them, but if it refers to my table as it is a number and not the code of the person (not like the surgeon) how can it understands it is a number ? Cause I don't care which one will be used, I just need the good number.

test.xlsx
You can look at the excel table to understand how each patient is expressed.
For ID1 for example, it will be in the room 3, with the surgeon number 22, with 1 nurse and 1 anesthesist, on tuesday at 8:30 and the length of the operation will be 435 minutes

Thanks by advance, you really help me.

0 ·

test.xlsx (8.2 KiB)

Cliff King Estephe DLDL commented · Nov 12, 2018 at 06:28 PM

The PreOp-OR-PACU zip file and contained information/model should help you with your question regarding scheduling of patient surgeries.

0 ·

Estephe DLDL Cliff King commented · Nov 12, 2018 at 09:20 PM

I still don't get how i can do my things.
I have checked your document, but in your case, you always want only one person of the category when I can have 2 at the same time so I can't juste put any member from nurses. How do I deal with that ?
Also for the time of arrival, you do everything during one day, I want to do it for 10 weeks, how can I do that ? Do I just calculate from day 1 8 am to the last day 4 pm or there is another formula possible ?

Thanks by advance

0 ·

Show more comments

Answer 2 · 2018-11-13T17:26:04Z

Cliff King answered Nov 13, '18 Cliff King edited Nov 13, '18

Thanks for the background information! I've attached an example of one way to model variable staffing assignments based on patient information contained in a table. Take a look at the Appointments table in the arrival object and you will see that I'm generating 7 patient arrivals. Each patient has been assigned a unique combination of staffing requirements for their treatment using thw two labels I created in the PCI table named NumNurses and NumAnes. I defined every combination from patient 1 who needs neither a nurse nor an anesthesiologist, to patient 7 who needs two of each.

Next take a look at the Treatment activity in the patient track and you'll see I needed to use four staff requirement fields to cover the maximum case of using two nurses and two anesthesiologists. I used the Based on Condition pick list option which returns any member from a group if needed or a NULL if not needed. The software allows you to return a NULL for a given staff requirement, in which case, no staff will be used.

numstaffbytablelookup.fsm

2018-11-13-9-17-20.png (13.4 KiB)

2018-11-13-9-26-39.png (29.8 KiB)

numstaffbytablelookup.fsm (113.8 KiB)