I am responsible for doing the scheduling for the ER staff. The process works ok. The schedules are generated using Microsoft Excel and have a pretty nice format. When the schedule is finally posted, an open hours sheet is posted for the staff to sign up for extra hours not filled. The problem we have is people changing their's or others hours, too many people signing up for an extra shift, or just too much writing on the schedule making it difficult to read.
We have tried to ask staff not to do things and make some new policy changes but that has not worked. We are looking at a couple of options. Putting the schedule behind glass and locking it, using our intranet or one we would really like to do is put the schedule on the server where staff can view it on the computers in the ER.
I like features of Excel that allow you to protect it so people can view only without changing unless they know the password.
My question(s) for those responsible for doing the schedule...
1. How do you post the schedule?
2. Anyone use their intranet for posting the schedule?
3. Anyone place the schedules on a server?
4. Anyone else use Excel? (If you do, can you set the number of rows? Instead of the standard 65,000 or so rows, say only 50 rows?)
Any other suggestions you have would be greatly appreciated!!!!
Thanks soo much