s91v1_1.zip     Spreadsheet to Assign Daily Calls to 30 Doctors

The Doctors Call Scheduler Excel spreadsheet schedules doctor's daily calls for a full year. It was developed with the assistance of a doctor responsible for scheduling 30 doctors to 5 calls per day for an anesthesiology clinic. You simply specify the doctor's names and the number of doctors that need to be on call each day of the week. You then proceed to assign first call, second call, etc. until sufficient calls have been assigned each day of the year. The program displays statistics regarding the number of each type call that has been assigned to each doctor so you know at a glance who is due for a specific call assignment. The program allows you to keep track of doctors with special qualifications and alerts you if you have not scheduled one of the "special" doctors to be on call each day. The spreadsheet is shareware that may be distributed and used freely for evaluation with the restriction that the schedule start date needs to be in March 1999 and the individual and group schedule displays are limited. Once you purchase the program, a password will be provided to remove these restrictions. The spreadsheet produces individual schedules and monthly calendars and comes in sizes for 5 calls & 30 doctors and 10 calls & 60 doctors. Other spreadsheets that can schedule up to 3 shifts, schedule up to 10 shifts, create rotating shifts, assign split-shifts, assign multiple daily tasks, create complex schedules, and create random schedules are available at http://www.shiftschedules.com.

Special Requirements: Microsoft Excel ver 97 or later.

Richard A. Chapman, Shift Schedules
Dickchapmn@shiftschedules.com
http://www.shiftschedules.com