Automatic Doctors Calls with Excel

Automatically schedule up to 25 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 sent by e-mail to selected doctors and electronically transferred to your Microsoft Outlook Calendar as well as your PDA or Smart Phone. The Excel spreadsheets come in sizes for 25 doctors and 10 daily calls, 50 doctors and 10 daily calls as well as 100 doctor and 10 daily calls and are priced from $299 to $699. They can be downloaded from the Shift Schedules website and used freely for evaluation.