Record the total occupied minute per day of a bed area ?

Question

question

christophe C2 asked Jul 9, '19 Joseph Gillespie commented Aug 2, '19

Record the total occupied minute per day of a bed area ?

How can I get the total occupied minute of a bed area by day ?

I suppose that I need to use the data collector with a time interval recording ? Bur how to set up the other parameters in order to get the total occupied minutes ?

I need to export these data in order to evaluate the variability by day.

Thanks in advance.

Software Version:

FlexSim HC 5.3.4

data data collector variability occupied minute

model-occupied-minute-per-day.fsm (104.5 KiB)

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.

Answer 1 · 2019-07-12T19:16:03Z

Cliff King answered Jul 12, '19 Braydn T commented Aug 14, '19

I'm not sure where you got the spreadsheet of data from above. Usually you only get one value for the location or area's dwell time (either min, max, avg or total based on the widget settings) in a Location Dwell Time dashboard widget.

The dwell time option you chose for the column definition in the data collector gets the time a patient was dwelling in the location they exited from. Notice the option suggests "This option works best with a patient or item exit event" for the Recording Event. There's not a pick option, but the following expressions can be used to get the dwell time of a location. To get the dwell times for an area you would need to combine the dwell times for all the individual locations within the area.

return get(stats_staytime(theLocation));
return get(stats_staytimemin(theLocation));
return get(stats_staytimemax(theLocation));
return get(stats_staytimeavg(theLocation));

The easiest approach would probably be to use the Statistics > Output Raw Data menu option as shown here.

This will give you results that look like this from the model you attached earlier. Notice the model has a warmup time so the information at the end of the warmup day (time 10080) is reset to 0, and then you get values at the end of each day (every 1440 minutes) after that.

Will this work for you?

chris1.jpg (96.3 KiB)

chris2.jpg (774.6 KiB)

· 3

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.

Cliff King commented · Jul 12, 2019 at 08:07 PM

p.s. I think the column you'll be interested in is the one named "Occupied Time".

0 ·

christophe C2 commented · Jul 13, 2019 at 08:32 AM

Thanks @Cliff King for this really helpful answer. I never noticed before the time interval option in the output data settings! How can I manage this with an experiment and different replications ?

If I make 5 replications of one scenario, I get 5 differents output files, right ? Is it possible to get the output raw data with all the replications results in one file ? or should I assemble manually the 5 output files together..

(About the dwell time above and my spreadsheet, I got it directly by clicking on the widget and export data. but the widget was setting as line chart.. maybe it's for this reason I don't get a single value.)

0 ·

Cliff King christophe C2 commented · Jul 14, 2019 at 05:46 PM

You get what you get with those output files, so you'll need to combine them later. If you went through the extra effort of using a data collector that records total occupied state time at the end of each day, you could get a single report I believe, but i'm talking from imagination rather than experience...

0 ·

Answer 2 · 2019-07-09T13:38:06Z

Cliff King answered Jul 9, '19 christophe C2 commented Jul 12, '19

You should be able to use the Locations > Dwell Time dashboard widget. In the Display Settings for the widget, choose "Total" for the "Statistic to Show".

· 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.

christophe C2 commented · Jul 12, 2019 at 01:42 PM

Thanks @Cliff King

Something is still not clear about Dwell Time dashboard widget :

When I export the data I get this :

What is the time indicated? Is there a record for each new arrival of a patient in the bed area ?

How can I change the time record in order to get the total occupied minute per day ?

If I try to use the data collector with a 1440 min interval, I have this warning message :

what does it mean ?

thanks in advance for your clarification.

0 ·

dwell-time-data-export.png (12.1 KiB)

dwell-time-capture.png (17.2 KiB)

question