2023 BWS - S - Google Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	U	V	W	X	Y	Z	AA	AB
1
2	2023 BWS - SOUTH AREA
3	Includes Trades 1-6 and Fatigue Mitigation Amendments
4	Effective: 11/5/2023 --- XT, KJ, EL, IP, GC, AT Removed / Trade 5 Cancelled / Addendum 1 (GQ), Addedum 2 (RA) Added
5	#	INITIALS		SUN		MON		TUE		WED		THU		FRI		SAT		CREW		Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
6	1	QA		1300	T2	1430		1300		700		700	T3	O	T2	O			530	0	0	0	0	0	1	0
7	2 [A2.2]	GZ		O		1500		1300		700		530		2200		O			600	0	0	0	1	0	0	0
8	3 [A2.3]	DP		O		1500		1400		800		530		2200		O			630	0	0	1	1	0	0	0
9																			637	0	0	0	0	0	0	0
10	5	OI		O		1430		1300		1500	T4	1400	T4	1100	T4	O			700	0	0	0	0	0	0	0
11	6	IB		1430		1300		700		530	B	2200		O		O			800	0	0	0	0	1	0	0
12	7	TU		1500		1300		700		530		2200		O		O			1100	0	1	0	0	0	0	0
13	8	RE		1409	F9	1400		800		637	F7	2200		O		O			1300	1	0	0	0	1	1	0
14	9	HS		1500		1400		700		630		530	T3/B	O		O			1400	0	0	0	0	0	0	0
15																			1409	0	0	0	0	0	0	0
16	11 [A 2.5]	RA		1400		700		530		2200		O		O		1600			1430	0	0	0	1	0	0	0
17	12 [A2.4]	RD		O	T2	700		530		2200		O		2200	T2	1500			1500	0	0	1	0	0	0	1
18	13 [A1.2]	GQ		1400		800		530		2200		O		O		1600			1600	0	0	0	0	0	0	0
19																			2200	0	0	0	0	0	0	1
20	15	MM		700		530		2200		O		O		1430		1300			2400	0	0	0	0	0	0	0
21	16	CB		700		630	T1	600	T1/B	O		O		1500		1400
22	17	LP		800		530		2200		O		O		1430	T6	1300	T6
23	18	AW		1100		530	T1	2200	T1	O		O		1500	T6	1400	T6
24	19	SZ		1300		700		630	B	O		O		1500		1400
25	20	GB		530		2200		O		O		1430		1300		700
26	21	SB		530		2200		O		O		1500		1300		700
27	22	LZ		630		600	B	O		O		1500		1400		800
28	23	FB		700		630	B	O		O		1500		1400		800			Note
29	24	DJ		2400		O		O		1430		1300		700		530			B = BackUp MID
30	25	XZ		2400		O		O		1500		1400		700		530			F7 = Fatigue Mitigation 7 Hour Shift
31	26	TM		530	B	O		O		1500		1430		800		630			F9 = Fatigue Mitigation 9 Hour Shift
32	27	AL		630	B	O		O		1100	T4	700	T4	630	T4/B	700			T# = Permanent Trade
33	28	MD		O		O		1430		1300		600	T3	530		2200
34	29	WA		O		O		1500		1400		700		530		2200
35
36	31	CX		O		O		1430		1300		1100		630		530	B
37	32	GM		O		O		1500		1400		1300		700		630	B
38
39	A1.1	CN		O		1500		1400		1300		630		600	B	O
40	A2.1	XO		1430		1300		1100		700		630		O		O
41
42	4	Vacant		O		1500		1400		700		630		600	B	O
43	10	Vacant		1430		1300		1100		630		630	B	O		O
44	14	Vacant		1300		1100		630		600	B	O		O		1500
45	30	Vacant		O		O		1500		1430		800		530		2200
46
47				SUN		MON		TUE		WED		THU		FRI		SAT
48				SUN		MON		TUE		WED		THU		FRI		SAT
49		SHIFT GUIDELINES	DAY	9		10		10		10		10		10		10
50			SWING	11		11		11		11		11		11		9
51			MID	2		2		3		3		3		3		3			Shift Guidelines
52			TOTAL	22		23		24		24		24		24		22			163
53
54		TOTAL SHIFTS ASSIGNED	RDO	9		8		8		9		8		7		9
55			DAY	9		10		9		8		9		9		10
56			SWING	10		10		10		10		10		10		8			Total Shift Assigned
57			MID	2		2		3		3		3		3		2			150
58			TOTAL	30		30		30		30		30		29		29
59
60		OVER/UNDER	DAY	0		0		-1		-2		-1		-1		0
61			SWING	-1		-1		-1		-1		-1		-1		-1
62			MID	0		0		0		0		0		0		-1
63
64
65		Actual Shifts Assigned	RDO	9		8		8		9		8		7		9
66			530	3		3		3		2		3		2		3
67			600	0		1		1		0		1		1		0
68			630	2		2		1		1		2		2		2
69			637	0		0		0		1		0		0		0
70			700	3		3		3		3		3		3		3
71			800	1		1		1		1		0		1		2
72			1100	1		0		1		1		1		1		0
73			1300	2		3		3		3		2		2		2
74			1400	2		2		2		2		2		2		3
75			1409	1		0		0		0		0		0		0
76			1430	2		2		2		1		2		2		0
77			1500	2		3		2		3		3		3		1
78			1600	0		0		0		0		0		0		2
79			2200	0		2		3		3		3		3		2
80			2400	2		0		0		0		0		0		0
81
82
83				SUN		MON		TUE		WED		THU		FRI		SAT
84				SUN		MON		TUE		WED		THU		FRI		SAT
85		Shift Worksheet	530	3		3		3		2		3		3		3
86			600	0		1		1		1		1		1		0
87			630	2		2		2		2		2		2		2
88			637	0		0		0		1		0		0		0
89			700	3		3		3		3		3		3		3
90			800	1		1		1		1		1		1		2
91			1100	1		1		1		1		1		1		0
92			1300	3		3		3		3		3		3		2
93			1400	2		2		2		2		2		2		3
94			1409	1		0		0		0		0		0		0
95			1430	2		2		2		2		2		2		0
96			1500	2		3		3		3		3		3		2
97			1600	0		0		0		0		0		0		2
98			2200	0		2		3		3		3		3		3
99			2400	2		0		0		0		0		0		0
100