Automatic Doctors Calls with Excel 2.12

Automatic Doctors Calls with Excel 2.12 offers an effective tool which helps you to 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.

The scheduler can be set to assign the same doctor to a Friday/Saturday/Sunday call or to a Saturday/Sunday call if you use a consecutive-day call strategy to cover your weekends.

The call assignment logic also tries to evenly distribute the number of times each doctor is assigned to a specific call. For example, someone will not be assigned to a Monday Call #1 and another Call #1 until it is absolutely necessary.

Call history is carried forward from one month to the next for as long as you use the scheduler, so month-to-month and year-to-year call counts and fairness are maintained forever.

You can specify up to 40 "holidays" per year including actual holidays and any other days (say those before and after an actual holiday) that you would like to treat as a holiday in the call distribution.

Major Features:

1. Automatically assigns daily calls for one year - Just push a button to create your schedules.
2. Allows you to manually edit and assign calls - You have complete control.
3. Creates a fair distribution of calls - No more complaints.
4. Allows consecutive day weekend calls - Fri/Sat/Sun or Sat/Sun.
5. Maintains call histories forever - For year-to-year continuity and fairness.
6. Keeps track of doctors with special qualifications - Make sure you have a specialist on call if needed.
7. Allows your doctors to specify daily availability - No assignments on unwanted days.
8. Specify up to 40 holidays per year - Including other "Special" days.
9. Keeps track of vacations - Up to 10 vacation periods can be specified.
10. Produces individual and group schedules - Hand them out, post them on the board.
11. Creates monthly calendars - All of your schedules in one handy format.
12. Can transfer your schedule into your Outlook calendar, PDA or Smart Phone - Keep them handy.
13. Automatically e-mail schedules to your employees- WOW, That's Easy.

Enhancements: Changed to Annual License

Requirements: None