Automatic Calls for 100 Doctors with Excel Description:

Automatically schedule up to 100 doctors to 10 daily calls each day for up to a year with Excel. Call preferences and qualifications are combined with doctor availability and call history each day to randomly select who is assigned to each call. Holiday and weekend calls, as well as weekday calls are evenly and fairly distributed to all of your doctors throughout the year. Up to 10 vacation (or otherwise unavailable) periods can be specified for each doctor and calls will not be assigned on those days. Call schedules are made one-month-at-a-time and are saved for use in creating an annual schedule. Call assignment histories are saved and used to assure long-term call assignment fairness. Monthly calendars are created along with files that can be electronically transferred to your Microsoft Outlook Calendar as well as your PDA or Smart Phone.