Hi, I am trying to create a histogram / block graph style visual aid to predict workload and overload periods for a theatre recovery suite (PACU) in a small hospital. There are several theatres all delivering patients to a single recovery room (PACU) with 2 or 3 or more staff working in. There are times of low throughput and times of excessive workload when a few patients exit theatre at similar times causing problems.
The problem is that (I am very new to excel and have got so far by youtube and this forum) I cannot extract the data from the sheet to convert into a visual aid to enable the theatre operations to be juggled, to gain a more even workload throughout the day.
I need to show the working day in hours on X axis from 0700 – 2359hrs and staff numbers on Y axis 1 -6.
Info.
Each member of staff is one to one with a patient for the duration of the PACU stay.
A long operation results in a longer recovery time so there may be a patient that spends 2 or 3 hours in recovery (PACU) after a lengthy morning operation and then the 3 other theatres may output 3 patients together and therefore, a peak is produced so a normal team of 2 or 3 then requires other members of staff to scrub and gown up for the duration of the peak until 1 out of the 4 patients in recovery is then discharged to another department. Data to be taken from PACU ARRIVE and PACU DURATION MINS
Hope that makes sense.
Thanks in advance, and keep replies simple and idiot proof!!!
PACU Loading.jpg
Bookmarks