Formulas for calculation

Question

question

Estephe DLDL asked May 27 2019 at 6:43 PM Joseph Gillespie edited Jun 26 2019 at 9:33 PM

Formulas for calculation

modele-memoire-sem1.fsm

Hello everyone,

Recently I have been working on a model, and I have faced some conclusions that I do not understand. Basically, I run a model where a patient has a room assigned to him directly, and then I run exactly the same model, but without that room assigned and the operation can go in whatever room is available.
I would like to analyze the utilization of the room, and to analyze it from 8h to 16h which is the normal hours and from 16h to midnight which are additional hours. Normally, I would expect that from 4 to midnight my room are less utilized as in general they are more available, so everyhting should finish earlier as another graph is saying, so my utilization rate for that period of time should be lower also, but the opposite is happening.
Could you please advise on this ?

I have shared the model.

Also, do you have any table with how numbers are calculated ? It would help me to understand some changes for my analysis as I do not see a place where i can find them.

Thanks,

Estephe de Lussac

utilization calculation formula

modele-memoire-sem1.fsm (1016.7 KiB)

· 3

Clair A commented · May 30 2019 at 12:21 PM

To help us understand your question, could you please add screenshots of the graphs you compare ? Or share the 2 different versions of your model for which you get different results ?

0 ·

Estephe DLDL Clair A commented · May 30 2019 at 2:02 PM

Hello,

Attached you can have the 2 differents models if you want. Also I have attached a word document with the graphs for the two scenarios.

I have an idead maybe that could explain, in the model in the first message, a room is assigned to each operation, sometimes it is not open for a day, but it is a specific room that is not open. In my seconde model, this one, as rooms are not assigned, what I have done for the availability is I do not care which room it is, I need for example 6 rooms monday, 5 tuesday, 3 wednesday, so in this model I will havec 3 rooms that will operate from monday to Wed, 2 others on monday and tuesday and only one more on monday, the availability consideration is different than in the first scenario (not the same rooms are available). This could affect the calculation ?

But basically, I would except on the second model these numbers to be lower, as rooms are more available, they should work less than in the first scenario for the same amount of operation (and time of operation) but according to graphs, they are higher...

I think you will understand better if you look at the scenario and when rooms are available.

graphs-room-assigned-or-not2.pdf

modele-memoire-sem1-sp.fsm

0 ·

modele-memoire-sem1-sp.fsm (1012.6 KiB)

graphs-room-assigned-or-not2.pdf (589.9 KiB)

Joseph Gillespie commented · Jun 26 2019 at 9:33 PM

@Estephe DLDL

Was Clair's answer helpful for you? Do you have any more questions?

0 ·

______

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-06-03T09:48:45Z

Clair A answered Jun 03 2019 at 9:48 AM Clair A commented Jun 04 2019 at 9:48 PM

I think I understand better your question now, thanks. Let's take an example to illustrate how statistics are calculated. I ran your first model from 8am to 4pm.

Here are the values of OR utilization between 8am and 4pm:

OR1: 96.80%
OR2: 82.44%
OR3: 75.81%
OR4: 0%
OR5: 96.59%
OR6: 96.59%
ORArea: 89.65%

During these 8 hours, OR4 was 100% in the state OffSchedule:

In the properties of your graph, the state OffSchedule is by default excluded from the calculation:

So if you double check the result, the utilization of ORArea is:

utilization of (OR1 + OR2 + OR3 + OR5 + OR6)/5 = (96.80 + 82.44 + 75.81 + 96.59 + 96.59)/5 = 89.65%

It's as if you had 5 rooms in your area since OR4 was OffSchedule all this time.

If you include the state OffSchedule in the calculation:

Then the mean utilization of ORArea is 74.71%:

Double check:

utilization(OR1 + OR2 + OR3 + OR4 + OR5 + OR6)/6 = (96.80 + 82.44 + 75.81 + 0 + 96.59 + 96.59)/6 = 74.71%

Based on your question, I assume it would make more sense for you to include the state OffSchedule in your statistical analysis.

3.png (7.5 KiB)

2.png (36.2 KiB)

4.png (7.5 KiB)

1.png (9.9 KiB)

5.png (9.7 KiB)

· 2

Estephe DLDL commented · Jun 03 2019 at 4:01 PM

Hello Clair,

I thought about this, my objective is not really to look at if the room is closed how much we lose, it is really to see with the rooms opened, what happened. And my concern is not from 8 to 4, but really from 4 to midnight. Because it the model where a room is assigned, maybe 5 rooms will be used on this time horizon because it has to be that room and not another one, but when room is not assigned, it is possible that during the day we have avoided some late, and that at 4 you only have 4 rooms that are being used, but it does not mean that the room is offscheduled because it can be used. And my question is, in that case, will it be counted in the calculation as a 0 or not ? Because in that particular case it should because the room is open, just not used, but it is not offscheduled officially...

I ask this because when you take the model, with room assigned, you have 14.46% over the week of utilization for rooms from 4 to midnight, but when you just say in the process that patient goes in OR area so whatever room, I finish with 14.64, but it is bot logical, and the problem I am pointed is the only answer I have to explain this.

0 ·

Clair A Estephe DLDL commented · Jun 04 2019 at 9:48 PM

The way statistics are calculated between 8am and 4pm is the same as between 4pm and midnight.

From what I understood in your model, I am not surprised that results are the same.

Whether you assign rooms or not, the average utilization between 8am and 4pm is the same in both scenarios.

And it's also the same average utilization in both scenarios between 4pm and midnight. From 14.46% to 14.64% the difference is almost nothing (1%), so I would not conclude that the utilization is increasing, for me it's the same.

0 ·

question