Call and Task Scheduler for 20 Doctors

The calls and tasks spreadsheet allows you to schedule 4 daily calls and 50 daily tasks to 20 doctors. Doctors are assigned to calls via drop-down menus. In a like manner, one or two daily tasks can be 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

Keywords: doctor, task, assigned, week, daily, period, call