Shift Schedules Doctors Call and Task Scheduler

The calls and tasks spreadsheet allows you to schedule 2 daily calls and 50 daily tasks to 20 doctors. Since you can schedule 2 doctors to each call, essentially 4 daily calls can be scheduled. Doctors are assigned to calls via drop-down menus. In a like manner, one or two daily tasks are assigned to each doctor. A table is provided for you to specify the doctors available for each task. This feature allows you to associate tasks with special requirements with doctors having special qualifications. The task assignment drop-down menus for each doctor, in turn, displays only those tasks specified for that doctor.
Task and call assignment statistics are gathered and displayed on the scheduling sheet to allow you to see the distribution of calls and tasks assigned to each doctor.
Weekly calendars as well as individual schedules, task schedules and call schedules are produced by the program. The calendar shows assignments over a two-week period while the other schedules display assignments over a 16 week period. Multiple calendars and schedules can be created to cover the entire 52 week period.
Other spreadsheets are available to assign 5 calls to 30 doctors and 10 calls to 60 doctors.