Monthly Shift Schedule

Document Sample
Monthly Shift Schedule Powered By Docstoc
					Shift Schedule for Mar/2009
2
3/2/2009 Monday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 9 3/9/2009 Monday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 16 3/16/2009 Monday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 23 3 3/23/2009 Monday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 24 3 3/24/2009 Tuesday Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am -

3
3/3/2009 Tuesday Personnel … … … … … … … 3/10/2009 Tuesday Personnel … … … … … … … 3/17/2009 Tuesday Personnel … … … … … … …

4
3/4/2009 Wednesday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/11/2009 Wednesday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/18/2009 Wednesday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 25 3 3/25/2009 Wednesday Personnel … … … … … … … Personnel … … … … … … …

5
3/5/2009 Thursday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/12/2009 Thursday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/19/2009 Thursday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 26 3 3/26/2009 Thursday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … Personnel … … … … … … …

10

11

12

17

18

19

hedule for Mar/2009
6
3/5/2009 Thursday Personnel … … … … … … … 3/12/2009 Thursday Personnel … … … … … … … 3/19/2009 Thursday Personnel … … … … … … … 3/26/2009 Thursday Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 27 3 3/27/2009 Friday Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 3/6/2009 Friday Personnel … … … … … … … 3/13/2009 Friday Personnel … … … … … … … 3/20/2009 Friday Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 28 3 3/28/2009 Saturday Personnel … … … … … … … Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am -

7
3/7/2009 Saturday Personnel … … … … … … … 3/14/2009 Saturday Personnel … … … … … … … 3/21/2009 Saturday Personnel … … … … … … …

8
3/8/2009 Sunday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/15/2009 Sunday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am Personnel … … … … … … … 3/22/2009 Sunday Shift 6am-10am 10am-2pm 2pm-6pm 6pm-10pm 10pm-2am 2am-6am 29 3 3/29/2009 Sunday Personnel … … … … … … … Personnel … … … … … … …

13

14

15

20

21

22

Mar/2009 Shift Schedule Summary
Personnel J.Brown A.White M.Green Week 1 # of Shifts Durations 0 0 0 0 0 0 Week 2 # of Shifts Durations 0 0 0 0 0 0 Week 3 # of Shifts Durations 0 0 0 0 0 0 Week 4 # of Shifts 0 0 0

Total

0

0

0

0

0

0

0

Total Number of Shifts Total Duration of Shifts Assigned Number of Shifts Unassigned Number of Shifts Assigned Duration of Shifts Unassigned Duration of Shifts

Week 1 0 0 0 0 0 0

Week 2 0 0 0 0 0 0

Week 3 0 0 0 0 0 0

Week 4 0 0 0 0 0 0

mary
Week 4 # of Shifts Durations 0 0 0 0 0 0 Total # of Shifts Durations 0 0 0 0 0 0

0

0

0

0

Week 4 0 0 0 0 0 0

Total 0 0 0 0 0 0

Monthly Shift Schedule
1) 2) 3) 4) 5) 6) Type year: Select month: 2009 Mar 1 2 3 4 5 6 7 From 6am 10am 2pm 6pm 10pm 2am Fill the personnel list on the right (as short as possible). Fill your shift list on the right (make sure that durations are correct). Which calendar type do you use? from Monday to Sunday Check Monthly Schedule sheet. You will see "…" in Personnel columns. This means there are no shifts in these rows (initially in none of them). "NEED SHIFT" rows are the unassigned shifts. This can be changed by any personnel in the list when the shift is assigned. 7) The "Report" sheet provides you information for salary or performance calculations.

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

From 6am 10am 2pm 6pm 10pm 2am

To 10am 2pm 6pm 10pm 2am 6am

Duration (hr.s) 4.00 4.00 4.00 4.00 4.00 4.00

Personnel Name … NEED SHIFT 1 J.Brown 2 A.White 3 M.Green 4 5 6 7 8 9 10

Months Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Days 1 2 3 4 5 6 7

1 2 3 4 5 6 7 8 9 10 11 12

31 28 31 30 31 30 31 31 30 31 30 31

Sel Month FALSE Nb of Days First Day First Monday Sel Calendar Term

3 31 7 2 1 2

Mar 2009

1 2 Monday unday S Tuesday onday M Wednesday Tuesday Thursday Wednesday Friday Thursday 
				
DOCUMENT INFO
Categories:
Stats:
views:3333
posted:8/3/2009
language:English
pages:17
Description: This file may be used for tracking the shifts assigned to employees (currently up to 10, but may be increased easily) in a month. First a calendar and is generated for the desired month. Each day on the calendar rows for shifts which will be defined by the user. Each shift row also contains a combo box displaying the list of employees. Assigning process is done by just selecting the desired employee from the combo box. A report of the data stored in this sheet is provided on another sheet. This report is prepared for assisting salary or performance calculations. The report displays the number of hours assigned to each employee. Also, an overall report on the number of shifts assigned, unassigned, etc. is provided.
BUY THIS DOCUMENT NOW PRICE: $12.99 100% MONEY BACK GUARANTEED
PARTNER SpreadsheetZone
SpreadsheetZONE features one of the biggest Microsoft Excel template repositories on the web. Supported by an active community and Excel Pros SpreadsheetZONE grows rapidly, delivering new templates everyday. Find the template you need now!