Smart Joules - Founder's Office (Excel Expert) Assignment.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	EEID	Full Name	Job Title	Department	Business Unit	Gender	Ethnicity	Age	Hire Date	Annual Salary	Bonus %	Hike %	Country	City	Exit Date	MEDIAN
2	E02387	Emily Davis	Sr. Manger	IT	Research & Development	Female	Black	55	8/4/2016	$141,604	15%	12%	United States	Seattle	16/10/2021	59
3	E04105	Theodore Dinh	Technical Architect	IT	Manufacturing	Male	Asian	59	29/11/1997	$99,975	0%	0%	China	Chongqing		59
4	E02572	Luna Sanders	Director	Finance	Speciality Products	Female	Caucasian	59	26/10/2006	$163,099	20%	7%	United States	Chicago		59
5	E02832	Penelope Jordan	Computer Systems Manager	IT	Manufacturing	Female	Caucasian	59	27/9/2019	$84,913	7%	3%	United States	Chicago		59
6	E01639	Austin Vo	Sr. Analyst	Finance	Manufacturing	Male	Asian	59	20/11/1995	$95,409	0%	0%	United States	Phoenix		59
7	E00644	Joshua Gupta	Account Representative	Sales	Corporate	Male	Asian	59	24/1/2017	$50,994	0%	0%	China	Chongqing		59
8	E01550	Ruby Barnes	Manager	IT	Corporate	Female	Caucasian	59	1/7/2020	$119,746	10%	13%	United States	Phoenix		59
9	E04332	Luke Martin	Analyst	Finance	Manufacturing	Male	Black	59	16/5/2020	$41,336	0%	0%	United States	Miami	20/5/2021	59
10	E04533	Easton Bailey	Manager	Accounting	Manufacturing	Male	Caucasian	59	25/1/2019	$113,527	6%	7%	United States	Austin		59
11	E03838	Madeline Walker	Sr. Analyst	Finance	Speciality Products	Female	Caucasian	59	13/6/2018	$77,203	0%	0%	United States	Chicago		59
12	E00591	Savannah Ali	Sr. Manger	Human Resources	Manufacturing	Female	Asian	59	11/2/2009	$157,333	15%	15%	United States	Miami		59
13	E03344	Camila Rogers	Controls Engineer	Engineering	Speciality Products	Female	Caucasian	59	21/10/2021	$109,851	0%	0%	United States	Seattle		59
14	E00530	Eli Jones	Manager	Human Resources	Manufacturing	Male	Caucasian	59	14/3/1999	$105,086	9%	10%	United States	Austin		59
15	E04239	Everleigh Ng	Sr. Manger	Finance	Research & Development	Female	Asian	59	10/6/2021	$146,742	10%	14%	China	Shanghai		59
16	E03496	Robert Yang	Sr. Analyst	Accounting	Speciality Products	Male	Asian	59	4/11/2017	$97,078	0%	0%	United States	Austin	9/3/2020	59
17	E00549	Isabella Xi	Vice President	Marketing	Research & Development	Female	Asian	59	13/3/2013	$249,270	30%	33%	United States	Seattle		59
18	E00163	Bella Powell	Director	Finance	Research & Development	Female	Black	59	4/3/2002	$175,837	20%	26%	United States	Phoenix		59
19	E00884	Camila Silva	Sr. Manger	Marketing	Speciality Products	Female	Latino	59	1/12/2003	$154,828	13%	19%	United States	Seattle		59
20	E04116	David Barnes	Director	IT	Corporate	Male	Caucasian	59	3/11/2013	$186,503	24%	19%	United States	Columbus		59
21	E04625	Adam Dang	Director	Sales	Research & Development	Male	Asian	59	9/7/2002	$166,331	18%	8%	China	Chongqing		59
22	E03680	Elias Alvarado	Sr. Manger	IT	Manufacturing	Male	Latino	59	9/1/2012	$146,140	10%	7%	Brazil	Manaus		59
23	E04732	Eva Rivera	Director	Sales	Manufacturing	Female	Latino	59	2/4/2021	$151,703	21%	25%	United States	Miami		59
24	E03484	Logan Rivera	Director	IT	Research & Development	Male	Latino	59	24/5/2002	$172,787	28%	20%	Brazil	Rio de Janerio		59
25	E00671	Leonardo Dixon	Analyst	Sales	Speciality Products	Male	Caucasian	59	5/9/2019	$49,998	0%	0%	United States	Seattle		59
26	E02071	Mateo Her	Vice President	Sales	Speciality Products	Male	Asian	59	2/3/2014	$207,172	31%	29%	China	Chongqing		59
27	E02206	Jose Henderson	Director	Human Resources	Speciality Products	Male	Black	59	17/4/2015	$152,239	23%	28%	United States	Columbus		59
28	E04545	Abigail Mejia	Quality Engineer	Engineering	Corporate	Female	Latino	59	5/2/2005	$98,581	0%	0%	Brazil	Rio de Janerio		59
29	E00154	Wyatt Chin	Vice President	Engineering	Speciality Products	Male	Asian	59	7/6/2004	$246,231	31%	35%	United States	Seattle		59
30	E03343	Carson Lu	Engineering Manager	Engineering	Speciality Products	Male	Asian	59	4/12/1996	$99,354	12%	8%	China	Beijing		59
31	E00304	Dylan Choi	Vice President	IT	Corporate	Male	Asian	59	11/5/2012	$231,141	34%	50%	China	Beijing		59
32	E02594	Ezekiel Kumar	IT Coordinator	IT	Research & Development	Male	Asian	59	25/6/2017	$54,775	0%	0%	United States	Columbus		59
33	E00402	Dominic Guzman	Analyst	Finance	Manufacturing	Male	Latino	59	16/5/2004	$55,499	0%	0%	Brazil	Manaus		59
34	E01994	Angel Powell	Analyst II	Sales	Research & Development	Male	Caucasian	59	11/7/2008	$66,521	0%	0%	United States	Seattle		59
35	E03549	Mateo Vu	Account Representative	Sales	Speciality Products	Male	Asian	59	29/9/2016	$59,100	0%	0%	China	Chongqing		59
36	E03247	Caroline Jenkins	Analyst	Finance	Research & Development	Female	Caucasian	59	6/5/2018	$49,011	0%	0%	United States	Chicago		59
37	E02074	Nora Brown	Enterprise Architect	IT	Manufacturing	Female	Caucasian	59	11/2/2014	$99,575	0%	0%	United States	Austin		59
38	E04152	Adeline Huang	Controls Engineer	Engineering	Manufacturing	Female	Asian	59	16/12/2019	$99,989	0%	0%	China	Chengdu		59
39	E01628	Jackson Perry	Vice President	Marketing	Research & Development	Male	Caucasian	59	20/10/2019	$256,420	30%	28%	United States	Phoenix		59
40	E04285	Riley Padilla	Technical Architect	IT	Manufacturing	Female	Latino	59	15/5/2013	$78,940	0%	0%	United States	Miami		59
41	E01417	Leah Pena	Enterprise Architect	IT	Corporate	Female	Latino	59	3/1/1994	$82,872	0%	0%	Brazil	Manaus		59
42	E01754	Owen Lam	Sr. Business Partner	Human Resources	Speciality Products	Male	Asian	59	29/5/2017	$86,317	0%	0%	China	Chengdu	16/7/2017	59
43	E03749	Kennedy Foster	Manager	Marketing	Speciality Products	Female	Caucasian	59	23/11/2013	$113,135	5%	2%	United States	Austin		59
44	E03574	John Moore	Vice President	IT	Speciality Products	Male	Caucasian	59	8/11/2005	$199,808	32%	45%	United States	Seattle		59
45	E04600	William Vu	Account Representative	Sales	Speciality Products	Male	Asian	59	14/11/2013	$56,037	0%	0%	China	Shanghai		59
46	E00586	Sadie Washington	Sr. Manger	Marketing	Research & Development	Female	Caucasian	59	24/5/2019	$122,350	12%	5%	United States	Phoenix		59
47	E03538	Gabriel Holmes	Enterprise Architect	IT	Research & Development	Male	Caucasian	59	4/11/2010	$92,952	0%	0%	United States	Seattle		59
48	E02185	Wyatt Rojas	Computer Systems Manager	IT	Corporate	Male	Latino	59	20/3/2013	$79,921	5%	2%	United States	Austin		59
49	E03830	Eva Coleman	Director	IT	Research & Development	Female	Black	59	20/9/2009	$167,199	20%	25%	United States	Seattle		59
50	E03720	Dominic Clark	Quality Engineer	Engineering	Research & Development	Male	Caucasian	59	17/10/2012	$71,476	0%	0%	United States	Phoenix		59
51	E03025	Lucy Alexander	Director	Engineering	Manufacturing	Female	Caucasian	59	29/10/2014	$189,420	20%	9%	United States	Seattle		59
52	E04917	Everleigh Washington	HRIS Analyst	Human Resources	Research & Development	Female	Caucasian	59	20/10/2001	$64,057	0%	0%	United States	Phoenix		59
53	E00415	Leilani Butler	Analyst II	Marketing	Manufacturing	Female	Black	59	21/9/2021	$68,728	0%	0%	United States	Phoenix		59
54	E02862	Peyton Huang	Sr. Manger	IT	Manufacturing	Female	Asian	59	2/7/2021	$125,633	11%	14%	China	Beijing		59
55	E04207	John Contreras	Analyst II	Marketing	Manufacturing	Male	Latino	59	15/5/2011	$66,889	0%	0%	United States	Columbus		59
56	E02139	Rylee Yu	Director	Accounting	Research & Development	Female	Asian	59	29/9/2015	$178,700	29%	10%	United States	Seattle		59
57	E01797	Piper Lewis	Field Engineer	Engineering	Research & Development	Female	Caucasian	59	22/12/2018	$83,990	0%	0%	United States	Chicago		59
58	E01839	Stella Alexander	Automation Engineer	Engineering	Corporate	Female	Caucasian	59	10/12/2005	$102,043	0%	0%	United States	Chicago		59
59	E01633	Addison Do	Operations Engineer	Engineering	Manufacturing	Female	Asian	59	30/5/2001	$90,678	0%	0%	United States	Columbus		59
60	E01848	Zoey Jackson	Business Partner	Human Resources	Manufacturing	Female	Black	59	21/8/2008	$59,067	0%	0%	United States	Miami		59
61	E00716	John Chow	Sr. Manger	Marketing	Research & Development	Male	Asian	59	11/3/2021	$135,062	15%	21%	China	Chengdu		59
62	E00699	Ava Ayala	Sr. Manger	IT	Corporate	Female	Latino	59	16/8/2006	$159,044	10%	13%	Brazil	Manaus		59
63	E00502	Natalia Salazar	Sr. Analyst	Accounting	Manufacturing	Female	Latino	59	2/1/2019	$74,691	0%	0%	Brazil	Manaus	8/7/2020	59
64	E04000	Skylar Carrillo	Engineering Manager	Engineering	Corporate	Female	Latino	59	18/12/2008	$92,753	13%	9%	United States	Austin	24/6/2021	59
65	E02112	Christian Sanders	Vice President	Human Resources	Speciality Products	Male	Black	59	7/8/2013	$236,946	37%	24%	United States	Seattle		59
66	E03824	Penelope Coleman	Analyst	Finance	Corporate	Female	Black	59	27/8/2021	$48,906	0%	0%	United States	Miami		59
67	E03906	Piper Richardson	Sr. Analyst	Sales	Corporate	Female	Caucasian	59	27/1/2008	$80,024	0%	0%	United States	Columbus		59
68	E00436	Everly Walker	HRIS Analyst	Human Resources	Speciality Products	Female	Caucasian	59	23/10/2009	$54,415	0%	0%	United States	Seattle	22/1/2014	59
69	E04798	Aurora Ali	Manager	Marketing	Research & Development	Female	Asian	59	24/4/2016	$120,341	7%	5%	United States	Seattle		59
70	E01249	Penelope Guerrero	Vice President	IT	Speciality Products	Female	Latino	59	4/8/2009	$208,415	35%	11%	United States	Seattle		59
71	E03349	Anna Mehta	Cloud Infrastructure Architect	IT	Speciality Products	Female	Asian	59	5/1/2020	$78,844	0%	0%	United States	Seattle		59
72	E02966	William Foster	Field Engineer	Engineering	Manufacturing	Male	Caucasian	59	23/5/2002	$76,354	0%	0%	United States	Phoenix	26/9/2021	59
73	E01499	Jade Rojas	Director	Finance	Speciality Products	Female	Latino	59	28/1/2019	$165,927	20%	27%	United States	Phoenix		59
74	E00105	Isla Espinoza	Manager	Accounting	Speciality Products	Female	Latino	59	16/11/2021	$109,812	9%	4%	Brazil	Manaus		59
75	E00665	David Chu	Controls Engineer	Engineering	Corporate	Male	Asian	59	3/9/1998	$86,299	0%	0%	United States	Seattle		59
76	E00791	Thomas Padilla	Vice President	Marketing	Research & Development	Male	Latino	59	26/7/2003	$206,624	40%	29%	Brazil	Sao Paulo		59
77	E01540	Miles Salazar	IT Coordinator	IT	Manufacturing	Male	Latino	59	23/12/2010	$53,215	0%	0%	Brazil	Sao Paulo	27/3/2014	59
78	E04474	Mila Hong	Test Engineer	Engineering	Research & Development	Female	Asian	59	22/5/2017	$86,858	0%	0%	China	Chongqing	8/10/2017	59
79	E03417	Benjamin Moua	Computer Systems Manager	IT	Manufacturing	Male	Asian	59	2/7/2007	$93,971	8%	11%	China	Chongqing		59
80	E00254	Samuel Morales	Analyst II	Finance	Corporate	Male	Latino	59	27/6/2015	$57,008	0%	0%	United States	Phoenix		59
81	E02166	John Soto	Sr. Manger	Finance	Manufacturing	Male	Latino	59	23/9/2015	$141,899	15%	7%	United States	Phoenix		59
82	E00935	Joseph Martin	Analyst II	Marketing	Corporate	Male	Black	59	13/9/2016	$64,847	0%	0%	United States	Miami		59
83	E01525	Jose Ross	Engineering Manager	Engineering	Research & Development	Male	Caucasian	59	8/4/1992	$116,878	11%	11%	United States	Miami		59
84	E00386	Parker James	Quality Engineer	Engineering	Speciality Products	Male	Black	59	5/2/2005	$70,505	0%	0%	United States	Austin		59
85	E00416	Everleigh Fernandez	Director	Engineering	Research & Development	Female	Latino	59	22/5/2016	$189,702	28%	29%	Brazil	Manaus	21/12/2020	59
86	E03383	Lincoln Hall	Director	Accounting	Speciality Products	Male	Caucasian	59	28/7/2020	$180,664	27%	32%	United States	Chicago		59
87	E01516	Willow Mai	Business Partner	Human Resources	Manufacturing	Female	Asian	59	17/12/2003	$48,345	0%	0%	China	Chengdu		59
88	E01234	Jack Cheng	Director	Human Resources	Manufacturing	Male	Asian	59	16/1/2014	$152,214	30%	23%	China	Beijing		59
89	E03440	Genesis Navarro	Cloud Infrastructure Architect	IT	Corporate	Female	Latino	59	28/4/2009	$69,803	0%	0%	Brazil	Manaus		59
90	E00431	Eliza Hernandez	Network Architect	IT	Corporate	Female	Latino	59	4/7/2019	$76,588	0%	0%	Brazil	Rio de Janerio		59
91	E01258	Gabriel Brooks	Network Engineer	IT	Manufacturing	Male	Caucasian	59	10/12/2018	$84,596	0%	0%	United States	Miami		59
92	E00440	Jack Huynh	Manager	Marketing	Research & Development	Male	Asian	59	25/9/2018	$114,441	10%	6%	China	Chongqing	22/12/2019	59
93	E00595	Everly Chow	Sr. Manger	Finance	Speciality Products	Female	Asian	59	21/4/2018	$140,402	15%	22%	China	Beijing		59
94	E00972	Amelia Salazar	Analyst II	Finance	Corporate	Female	Latino	59	23/4/2019	$59,817	0%	0%	Brazil	Sao Paulo		59
95	E04562	Xavier Zheng	Account Representative	Sales	Manufacturing	Male	Asian	59	22/7/2017	$55,854	0%	0%	United States	Austin		59
96	E02802	Matthew Chau	Sr. Business Partner	Human Resources	Research & Development	Male	Asian	59	16/11/2002	$95,998	0%	0%	United States	Seattle		59
97	E01427	Mia Cheng	Sr. Manger	Sales	Manufacturing	Female	Asian	59	22/4/2015	$154,941	13%	17%	United States	Phoenix		59
98	E04568	Rylee Yu	Vice President	Finance	Speciality Products	Female	Asian	59	10/7/2011	$247,022	30%	45%	China	Beijing		59
99	E04931	Zoe Romero	Network Architect	IT	Manufacturing	Female	Latino	59	5/10/2021	$88,072	0%	0%	Brazil	Sao Paulo		59
100	E00443	Nolan Bui	Computer Systems Manager	IT	Research & Development	Male	Asian	59	26/5/2020	$67,925	8%	9%	China	Shanghai		59