Maximisating Patients Seen Per Day
Sep 28, 2006
I have to maximise the number of patients seen per day from the below data
Open 7 days a weekOpen Close
Monday 8:3019:00
Tuesday 8:3019:00
Wed 8:3019:00
Thur 8:3021:00
Fri 8:3019:00
Sat 9:0018:00
Sun 9:0018:00
Time% Patients/day
Short Visit 15min 0.81
Double Time 30min 0.14
Triple Time 45min 0.05
ABOUT SURGERYAverage Waiting TimeDoctors Required
8:30 - 10:00 30min 5-7
10:00 - 13:00 45min 7-8
13:00 - 18:00 1.5hr 8+
18:00 - 19:00 1hr 6-7
19:00 - 21:00 30min 5+
View 3 Replies
Jan 12, 2009
I know how to get the pivot table in the my database to group patients by age. However it groups them like this:5-14
15-24
25-34
35-44
45-54
55-64
65-74
Medically it doesn't make sense to group pediatric patients with adolescents and adolescents with adults. What I would like to do is to get the pivot table to group patients the way I want them. Something like this:5-12
13-18
19-25
26-35
36-45
46-55
56-65
66-75
76-85
Is there a way to get a pivot table to do this? Or is there another solution?
View 12 Replies
View Related
Jan 23, 2014
I have been trying to work out a formula for capturing the number of patients in the hospital at half hour time intervals. There are a lot of formulas for capturing this information within a 24 hour period however not a lot of information when the Length of Stay or episode time is +24 hours.
As you can see in my example spreadsheet below, some of the patients stay for 244 hours (row 9).
The outcome that I am looking for is that a 1 is placed in all of the time slots when the patient is there. For example if they arrive on Jan 1st at 2.15 and leave on Jan 3rd at 10.30 all of the time slots in between would have a 1 placed in them.
I have been playing around a lot and think it is probably only possible if you set it up as I have in the example i.e. by having the date running down and the time running across.
How this could work? I have tried SUMIFs and SUMPRODUCT formulas which generally work for Jan 1st but then go wrong for any date after that.
View 4 Replies
View Related
