Manually Schedule Doctors to Daily Calls for a Year

Why do I need this spreadsheet scheduler

This spreadsheet provides an organized platform for you to manually assign doctors to up to 20 calls each day for a year. You can implement any kind of scheduling rules you have and if your rules are particularly complex you will be pleasantly surprised how easy call scheduling can be with this spreadsheet.

It's so easy to use

Just enter your call staffing requirements for each day of the week and your doctors preferences and qualifications then proceed to assign calls each day. It's easy to schedule vacations and other days off first and then fill in the calls for each doctor. A call counter keeps track of the number of each call assigned to each doctor each day of the week so you can easily adjust the call assignments to distribute them evenly across all days of the week. Another counter lets you know how many calls remain to be assigned each day to make sure you don't forget any calls.

It shows you exactly what you need to know to manage your business

Call counts and daily call distributions are provided to show the number of times each doctor has been assigned to each call so you can easily see who is due for a particular call. And you can highlight a selected call to see how it is distributed throughout the year to keep you from concentrating a particular call assignment to one of your doctors over a short period of time.

It tells your employees all they need to know about their schedules

Four calendars are created to show monthly and annual doctor's schedules as well as monthly and annual call schedules. The various calendars can be printed and distributed or automatically sent by e-mail to your doctors and call locations so everyone is informed of who has which call each day. You can also (at the push of a button) create a calendar file showing all of the call assignments for the year for a single doctor (selected from a drop-down list of your doctors) that can be imported into their Microsoft Outlook Calendar and to their PDA or Smart Phone so they will have a complete listing of all of their calls for the whole year.

It will save you time and money every week

Using this scheduler instead of your typical paper and pencil method or outdated scheduling program or a spreadsheet that somebody put together a few years ago will save you a great deal of time and since it is so easy to schedule your doctors while paying attention to their availability, qualifications and preferences you will save money every week and before you know it the small price you paid for the spreadsheet will be repaid many times over.