Working Days.xlsx

	A	B	C	D	I	J	K
1
2
3	Emp. ID	Employee Name	Personal Leaves	Actual Working Days	Year Start Date	Year Start Date	Total Working days
4	CG-12520	Claire Gute	2		1/1/2022	12/31/2022
5	DV-13045	Darrin Van Huff	16
6	SO-20335	Sean O'Donnell	20
7	BH-11710	Brosina Hoffman	6
8	AA-10480	Andrew Allen	20
9	IM-15070	Irene Maddox	6
10	HP-14815	Harold Pawlan	4
11	PK-19075	Pete Kriz	17
12	AG-10270	Alejandro Grove	7
13	ZD-21925	Zuschuss Donatelli	13
14	KB-16585	Ken Black	20
15	SF-20065	Sandra Flanagan	19
16	EB-13870	Emily Burns	15
17	EH-13945	Eric Hoffmann	14
18	TB-21520	Tracy Blumstein	18
19	MA-17560	Matt Abelman	8
20	GH-14485	Gene Hale	14
21	SN-20710	Steve Nguyen	14
22	LC-16930	Linda Cazamias	12
23	RA-19885	Ruben Ausman	17
24	ES-14080	Erin Smith	8
25	ON-18715	Odella Nelson	7
26	PO-18865	Patrick O'Donnell	19
27	LH-16900	Lena Hernandez	17
28	DP-13000	Darren Powers	3
29	JM-15265	Janet Molinari	15
30	TB-21055	Ted Butterfield	8
31	KM-16720	Kunst Miller	8
32	PS-18970	Paul Stevenson	14
33	BS-11590	Brendan Sweed	10
34	KD-16270	Karen Daniels	12
35	HM-14980	Henry MacAllister	18
36	JE-15745	Joel Eaton	3
37	KB-16600	Ken Brennan	18
38	SC-20770	Stewart Carmichael	19
39	DN-13690	Duane Noonan	14
40	JC-16105	Julie Creighton	5
41	CS-12400	Christopher Schild	4
42	PG-18895	Paul Gonzalez	14
43	GM-14455	Gary Mitchum	2
44	JS-15685	Jim Sink	14
45	KB-16315	Karl Braun	18
46	RB-19705	Roger Barcio	2
47	PN-18775	Parhena Norris	13
48	KD-16345	Katherine Ducich	20
49	ER-13855	Elpida Rittenbach	9
50	RB-19465	Rick Bensley	6
51	GZ-14470	Gary Zandusky	2
52	LC-16870	Lena Cacioppo	12
53	JM-15250	Janet Martin	2
54	PA-19060	Pete Armstrong	18
55	CV-12805	Cynthia Voltz	19
56	CL-12565	Clay Ludtke	4
57	RC-19960	Ryan Crowe	14
58	DK-13090	Dave Kipp	17
59	GG-14650	Greg Guthrie	19
60	SC-20725	Steven Cartwright	9
61	AD-10180	Alan Dominguez	4
62	PF-19165	Philip Fox	9
63	TS-21610	Troy Staebel	14
64	LS-16975	Lindsay Shagiari	3
65	DW-13585	Dorothy Wardle	16
66	LC-16885	Lena Creighton	15
67	JD-15895	Jonathan Doherty	15
68	SH-19975	Sally Hughsby	6
69	SG-20080	Sandra Glassco	16
70	HA-14920	Helen Andreada	10
71	MG-17680	Maureen Gastineau	18
72	JE-16165	Justin Ellison	16
73	TW-21025	Tamara Willingham	16
74	SP-20650	Stephanie Phelps	18
75	NK-18490	Neil Knudson	8
76	DB-13060	Dave Brooks	4
77	NP-18670	Nora Paige	13
78	TT-21070	Ted Trevino	12
79	EM-13960	Eric Murdock	5
80	RD-19900	Ruben Dartt	10
81	MJ-17740	Max Jones	18
82	BM-11140	Becky Martin	10
83	CS-12130	Chad Sievert	15
84	JB-15400	Jennifer Braxton	3
85	SJ-20500	Shirley Jackson	4
86	JK-15640	Jim Kriz	18
87	DK-13150	David Kendrick	14
88	RM-19675	Robert Marley	17
89	SK-19990	Sally Knutson	3
90	FM-14290	Frank Merwin	19
91	AM-10360	Alice McCarthy	14
92	MP-17470	Mark Packer	2
93	MZ-17515	Mary Zewe	18
94	CB-12025	Cassandra Brandow	8
95	VM-21685	Valerie Mitchum	16
96	FH-14365	Fred Hopkins	4
97	MB-17305	Maria Bertelson	5
98	BS-11755	Bruce Stewart	4
99	LC-17140	Logan Currie	13
100	HK-14890	Heather Kirkland	4