Test - Samir Sahel

Employee shift schedule – Google Drive

Employee shift schedule


1
2
3
4
5
6
7
8	Jan 1 – Jan 7
9	Weekly Schedule 01
10
11	Quick Tip ➜
12			Highlight "Names" and all the cells below it, then go to Data > Filter views > Create new (temporary) filter view to be able to filter for specific names.
13
14
15
16		1/1
17		Sunday
18		Shift A								Shift B								Shift C								Total Shifts
19	Names	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
20	Wendy Writer	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
21	Ronny Reader									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
22	Abby Author																									0	0	0
23	Casey Creator	A	A	A	A	A	A	A	A																	8	0	0
24	Perry Presenter																									0	0	0
25	Vinny Viewer	A	A	A	A	A	A	A	A									C	C	C	C	C	C	C	C	8	0	8
26	Molly Maker									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
27	Berry Books																									0	0	0
28		1/2
29		Monday
30		Shift A								Shift B								Shift C								Total Shifts
31		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
32	Wendy Writer																									0	0	0
33	Ronny Reader									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
34	Abby Author																	C	C	C	C	C	C	C	C	0	0	8
35	Casey Creator	A	A	A	A	A	A	A	A	B	B	B	B	B	B											8	6	0
36	Perry Presenter															B	B	C	C	C	C	C	C	C	C	0	2	8
37	Vinny Viewer									B	B	B	B	B	B	B	B									0	8	0
38	Molly Maker	A	A	A	A	A	A	A	A																	8	0	0
39	Berry Books	A	A	A	A	A	A	A	A																	8	0	0
40		1/3
41		Tuesday
42		Shift A								Shift B								Shift C								Total Shifts
43		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
44	Wendy Writer																									0	0	0
45	Ronny Reader	A	A	A	A	A	A	A	A									C	C	C	C	C	C	C	C	8	0	8
46	Abby Author	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
47	Casey Creator	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
48	Perry Presenter																									0	0	0
49	Vinny Viewer																									0	0	0
50	Molly Maker																	C	C	C	C	C	C	C	C	0	0	8
51	Berry Books									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
52		1/4
53		Wednesday
54		Shift A								Shift B								Shift C								Total Shifts
55		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
56	Wendy Writer																	C	C	C	C	C	C	C	C	0	0	8
57	Ronny Reader									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
58	Abby Author	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
59	Casey Creator																									0	0	0
60	Perry Presenter																									0	0	0
61	Vinny Viewer	A	A	A	A	A	A	A	A									C	C	C	C	C	C	C	C	8	0	8
62	Molly Maker	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
63	Berry Books																									0	0	0
64		1/5
65		Thursday
66		Shift A								Shift B								Shift C								Total Shifts
67		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
68	Wendy Writer	A	A	A	A	A	A	A	A																	8	0	0
69	Ronny Reader	A	A	A	A	A	A	A	A																	8	0	0
70	Abby Author									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
71	Casey Creator									B	B	B	B	B	B	B	B									0	8	0
72	Perry Presenter									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
73	Vinny Viewer																									0	0	0
74	Molly Maker	A	A	A	A	A	A	A	A									C	C	C	C	C	C	C	C	8	0	8
75	Berry Books																									0	0	0
76		1/6
77		Friday
78		Shift A								Shift B								Shift C								Total Shifts
79		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
80	Wendy Writer									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
81	Ronny Reader	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
82	Abby Author	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
83	Casey Creator																									0	0	0
84	Perry Presenter																	C	C	C	C	C	C	C	C	0	0	8
85	Vinny Viewer																	C	C	C	C	C	C	C	C	0	0	8
86	Molly Maker																									0	0	0
87	Berry Books	A	A	A	A	A	A	A	A																	8	0	0
88		1/7
89		Saturday
90		Shift A								Shift B								Shift C								Total Shifts
91		8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	0	1	2	3	4	5	6	7	A	B	C
92	Wendy Writer																									0	0	0
93	Ronny Reader																	C	C	C	C	C	C	C	C	0	0	8
94	Abby Author	A	A	A	A	A	A	A	A																	8	0	0
95	Casey Creator									B	B	B	B	B	B	B	B	C	C	C	C	C	C	C	C	0	8	8
96	Perry Presenter	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
97	Vinny Viewer	A	A	A	A	A	A	A	A	B	B	B	B	B	B	B	B									8	8	0
98	Molly Maker																									0	0	0
99	Berry Books																	C	C	C	C	C	C	C	C	0	0	8
100
101
102


1
2
3
4
5
6
7
8	Company Name
9	Employee Schedule Jan 2017
10
11
12
13	Shift Details
14
15	Shift	Duration					Period					Hourly Wage					Employees per Shift
16	A	8 hours					08:00 – 16:00					$50					3
17	B	8 hours					16:00 – 00:00					$50					3
18	C	8 hours					00:00 – 07:00					$85					3
19
20
21	Employee Wage Overview
22
23	Employee's Name	Shift															Monthly Wage
24		A					B					C
25	Name	W1	W2	W3	W4	W5	W1	W2	W3	W4	W5	W1	W2	W3	W4	W5
26	Wendy Writer	16	0	0	0	0	16	0	0	0	0	16	0	0	0	0	$2,960
27	Ronny Reader	24	0	0	0	0	32	0	0	0	0	40	0	0	0	0	$6,200
28	Abby Author	32	0	0	0	0	32	0	0	0	0	16	0	0	0	0	$4,560
29	Casey Creator	24	0	0	0	0	30	0	0	0	0	8	0	0	0	0	$3,380
30	Perry Presenter	8	0	0	0	0	18	0	0	0	0	24	0	0	0	0	$3,340
31	Vinny Viewer	24	0	0	0	0	16	0	0	0	0	24	0	0	0	0	$4,040
32	Molly Maker	24	0	0	0	0	16	0	0	0	0	24	0	0	0	0	$4,040
33	Berry Books	16	0	0	0	0	8	0	0	0	0	16	0	0	0	0	$2,560
34	Total Hours / per week	168	0	0	0	0	168	0	0	0	0	168	0	0	0	0
35