2023 BWS - SE - Google Sheets

	B	C	D	E	G	I	K	L	M	N	O	P	Q	R	S	U	V	W	X	Y	Z	AA	AB
1
2		2023 BWS - SOUTHEAST AREA													CREW
3	#	NAME		SUN	MON	TUE	WED		THU		FRI		SAT		CREW
4	1	TZ		0	0	1339	1300		700		707		2200		F		SUN	MON	TUE	WED	THU	FRI	SAT
5	2	BP		0	0	1430	1300		700		600		2200			500	0	0	0	0	0	0	0
6	3	RQ		0	0	1400	700		600		700	2	530	3		530	0	0	0	1	0	1	0
7	4	OS		0	0	1500	1200		700		530		530			600	0	0	2	2	1	1	0
8	5	XP		0	0	1400	1400		1200		600		500			700	0	0	0	0	0	0	0
9	6	NK		2400	0	0	1500	4	1300		700		600			800	0	0	0	0	0	0	0
10	7	OQ		2400	0	0	1339		1200	1	637	2	2200	3	F	1200	0	0	0	0	0	0	0
11	8	ZK		530	0	0	1430	4	1400		1200		800			1300	2	0	0	0	0	0	0
12	9	CT		500	0	0	1300		1300		1200		600			1400	1	0	0	0	0	0	0
13	10	IM		530	0	0	1400		1400	1, 6	700		500			1430	2	1	1	1	0	0	0
14	11	NP		600	2200	0	0		1430		1300		700			1500	0	0	0	0	0	0	0
15	12	VA		530	2200	0	0		1430		1300		700			1600	0	0	0	0	0	0	0
16	13	HX		700	500	0	0		1500		1400		1200			2200	0	0	0	0	0	0	0
17	14	TA		500	530	0	0		1300	6	1200		600			2400	0	0	0	0	0	0	0
18	15	DH		700	600	2200	0		0		1430		1300
19	16	AM		700	600	2200	0		0		1430		1300
20	17	TR		600	530	2200	0		0		1300		1200
21	18	CH		1200	700	530	0		0		1500		1400
22	19	DW		1200	500	500	0		0		1400		1400
23	20	MJ		1209	700	707	2200		0		0		1430		F
24	21	XM		1209	700	707	2200		0		0		1500		F
25	22	DE		1200	530	530	2200		0		0		1600
26	23	RX		1300	600	500	500	5	0		0		1600
27	24	WR		1339	1300	700	707		2200		0		0		F
28	25	MR		1339	1300	700	707		2200		0		0		F
29	26	MZ		1309	700	530	637		2200		0		0		F
30	27	QQ		1500	1200	700	500		530		0		0
31	28	FG		1400	1200	600	530		500		0		0
32	29	TB		0	1339	1300	700		707		2200		0		F
33	30	IX		0	1430	1300	700		600		2200		0
34	31	TX		0	1300	700	530	5	530		2200		0
35	32	FF		0	1500	1300	700		500		500		0
36	33	II		0	1200	1200	600		530		530		0
37	34	LL		0	1400	1200	1200		700		500		0
38	35	SM		0	1400	1200	1200		1200		700		0
39
40
41				SUN	MON	TUE	WED		THU		FRI		SAT
42				SUN	MON	TUE	WED		THU		FRI		SAT
43		COVERAGE REQUIREMENTS	DAY	10	12	12	12		12		12		10
44			SWING	11	11	11	11		11		11		10
45			MID	2	2	3	3		3		3		3			Coverage Requirements
46			TOTAL	23	25	26	26		26		26		23			175
47
48		TOTAL SHIFTS ASSIGNED	RDO	12	10	9	9		9		9		12
49			DAY	10	12	10	9		11		10		10
50			SWING	6	10	10	10		11		11		10			Total Shift Assigned
51			MID	2	2	3	3		3		3		3			159
52			TOTAL	30	34	32	31		34		33		35
53
54		OVER/UNDER	DAY	0	0	-2	-3		-1		-2		0
55			SWING	-5	-1	-1	-1		0		0		0
56			MID	0	0	0	0		0		0		0
57
58
59		Actual Shifts Assigned	RDO	12	10	9	9		9		9		12
60			500	2	2	2	2		2		2		2
61			530	3	3	3	2		3		2		2
62			600	2	3	1	1		2		2		3
63			700	3	4	4	4		4		4		2
64			800	0	0	0	0		0		0		1
65			1200	3	3	3	3		3		3		2
66			1300	1	3	3	3		3		3		2
67			1400	1	2	2	2		2		2		2
68			1430	0	1	1	1		2		2		1
69			1500	1	1	1	1		1		1		1
70			1600	0	0	0	0		0		0		2
71			2200	0	2	3	3		3		3		3
72			2400	2	0	0	0		0		0		0
73
74
75				SUN	MON	TUE	WED		THU		FRI		SAT
76				SUN	MON	TUE	WED		THU		FRI		SAT
77		Shift Breakdown	500	2	2	2	2		2		2		2
78			530	3	3	3	3		3		3		2
79			600	2	3	3	3		3		3		3
80			700	3	4	4	4		4		4		2
81			800	0	0	0	0		0		0		1
82			1200	3	3	3	3		3		3		2
83			1300	3	3	3	3		3		3		2
84			1400	2	2	2	2		2		2		2
85			1430	2	2	2	2		2		2		1
86			1500	1	1	1	1		1		1		1
87			1600	0	0	0	0		0		0		2
88			2200	0	2	3	3		3		3		3
89			2400	2	0	0	0		0		0		0
90
91
92
93
94
95
96
97
98
99
100