Employee scheduling template - does one already exist

B

Brian

I need an employee scheduling spreadsheet template to assist with scheduling
@10 employees on a monthly basis. Example below. Can anyone help?

AUGUST 2003

OFF = Day Off S/L = Sick Leave
V = Vacation B = Out of office on business
F = Floating day
Name Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri
Mon Tue Wed Thu Fri Mon Tue Wed Thu Fri
7/28 7/29 7/30 7/31 8/1 8/4 8/5 8/6 8/7 8/8 8/11 8/12 8/13 8/14
8/15 8/18 8/19 8/20 8/21 8/22 8/25 8/26 8/27 8/28 8/29
Rep 1 8:30-5:00 OFF 11:30-8:00 OFF 8:00- 4:30 8:30-5:00 OFF
9:30-6:00 OFF 8:00- 4:30 8:30-5:00 OFF 9:30-6:00 OFF 8:00- 4:30 8:30-5:00
OFF 9:30-6:00 OFF 8:00- 4:30 8:30-5:00 OFF 9:30-6:00 OFF 8:00- 4:30
Rep 2 11:30- 8:00 8:00- 4:30 8:00- 4:30 8:00- 4:30 8:00- 4:30
9:30- 6:00 8:00- 4:30 8:00- 4:30 8:00- 4:30 8:00- 4:30 9:30-6:00 8:00- 4:30
8:00- 4:30 8:00- 4:30 8:00- 4:30 9:30-6:00 8:00- 4:30 8:00- 4:30 8:00- 4:30
8:00- 4:30 9:30-6:00 8:00- 4:30 8:00- 4:30 8:00- 4:30 8:00- 4:30
Rep 3 9:00 - 5:30 9:00- 5:30 9:00- 5:30 11:30-8:00 9:00-5:30
9:00 - 5:30 9:00- 5:30 9:00- 5:30 9:30-6:00 9:00-5:30 9:00 - 5:30 9:00- 5:30
9:00- 5:30 9:30-6:00 9:00-5:30 9:00 - 5:30 9:00- 5:30 9:00- 5:30 9:30-6:00
9:00-5:30 9:00 - 5:30 9:00- 5:30 9:00- 5:30 9:30-6:00 9:00-5:30
Rep 4 8:00-4:30 8:00-4:30 8:00-4:30 8:00-4:30 9:30- 6:00 8:00-4:30
8:00-4:30 V V 9:30-6:00 8:00-4:30 8:00-4:30 8:00-4:30 8:00-4:30 9:30-6:00
8:00-4:30 8:00-4:30 8:00-4:30 8:00-4:30 9:30-6:00 8:00-4:30 8:00-4:30
8:00-4:30 8:00-4:30 9:30-6:00
 
Top