# Healthcare scheduling

#### loopa

##### New Member
Hi all
I'm hoping to be able to create/utilize a dynamic scheduler which allows me to assign a member of staff to a treatment chair, for periods of time dependent upon the intervention being delivered, so that I can be always aware of what capacity I have available.

For example:
Patient 1 is allocated to Chair 1 at 08:00 on Monday, because it's free for the duration of their intervention (lets say the intervention lasts 4 hours and the patient does not leave the chair during this time). Staff 1 is required to begin the intervention at 08:00 and this "task" takes 30 minutes. Therefore, Staff 1 becomes free at 08:30 to undertake other tasks with other patients, but must return to patient 1/chair 1 at 10:00 for a further 30 minute task and again at 11:30 for another 30 minutes (as per the requirements of the intervention being delivered). It must always be the same member of staff who delivers care to patient 1 (ie. different staff members cannot deliver individual parts of the intervention) but the staff member can be delivering care to multiple patients in different chairs at any one time.

There are approximately 90 different interventions - some quite small in length and with few "tasks", others take much longer and involve a number of tasks being delivered. Every intervention can be defined in advance to set the required start/end task times within the intervention.

How can I set up a scheduler which shows me / suggests to me which member of staff to use and which chair to seat the patient in, in order to maximize the use of both the staff member's time and chair utilization? So in the above example, Staff 1 is not available at 08:00-08:30, 10:00-10:30 and 11:30-12:00 on Monday and similarly, Chair 1 isn't available between 08:00-12:00 on Monday - so if Patient 2 is coming in at 10:00, they cannot sit in Chair 1, nor can Staff 1 be allocated to this patient (since they're busy at 10:00).

Thank you.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### loopa

##### New Member
Similarly, if Patient 2 came in at 09:30 (when Staff 1 is free), but would require Staff 1 at 11:30 as per the task time rules of their intervention (at which point, they are not available, because they are with Patient 1/Chair 1), then Staff 1 is not available to be assigned to Patient 2 when Patient 2 is being booked in/assigned a Chair.

Replies
0
Views
178
Replies
8
Views
1K
Replies
3
Views
81
Replies
7
Views
1K
Replies
0
Views
663

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

1,151,697
Messages
5,765,982
Members
425,320
Latest member
Galin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back