
S9530v1.zip     Spreadsheet to Assign Daily Calls to 25 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 produces individual schedules and monthly calendars and comes in sizes for 5 calls & 30 doctors and 10 calls & 60 doctors. During the free trial period restrictions apply with respect to schedule start dates and the number of schedules displayed.

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

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