Description
Problem 1) Build an advanced filter that brings back only certain people from Saginaw (zip code of 48603), certain people from Bay City (zip code of 48706) and anyone from the city of Frankenmuth. This query for the filter (including the heading row), should be from row 1 through row 4.
Problem 2) Copy over the filter from Problem 1. We now want to only find people that are from the desired cities but that also hold job codes 104 or 203. The query portion will now be on rows 1 through 7.
Problem 3) Copy over the filter from Problem 2. We now only want to bring back the employees matching the city and job code criteria that were hired anytime between the start of 1995 and the end of 1998. This criteria is more complicated that the one in the notes and simply sequencing the dates in a specific order isn’t going to work. What we need to do is have two Original_Hire_Date columns, so copy the cell contents from cell J1 to cell I1. You will then put the beginning date criteria (>=1/1/1995) in column I and the ending date criteria (<=12/31/1998).
Once you have the filtering for this problem working, add a comment to cell I1 that tells why the column name was changed from Home_Phone_Number to Original_Hire_Date. When I say comment this time, I mean New Comment from under the Review tab.
Unformatted Attachment Preview
Social_Security_Number
First_Name
Middle_Initial Last_Name
Social_Security_Number
371-00-5947
362-00-4662
386-00-8050
372-00-8175
378-00-7036
362-00-6827
302-00-9892
365-00-5638
371-00-7606
368-00-2546
374-00-7000
366-00-6857
368-00-9630
375-00-8458
380-00-8491
381-00-6503
368-00-4911
383-00-1208
383-00-5665
381-00-8426
375-00-8199
376-00-6431
380-00-8590
386-00-6939
363-00-1106
040-00-8585
380-00-4317
375-00-7515
383-00-4401
367-00-3332
006-00-9871
363-00-9510
379-00-3961
369-00-0212
378-00-8030
First_Name
SANDRA
TYE
SUSAN
CAROL
MARLENE
LOUANN
SUSAN
JOSEPH
CONSTANCE
JANE
CHARLENE
ELLEN
SANDRA
ELIZABETH
BETTY
COLLEEN
CAROL
GERALYN
LYNNE
JANE
MICHAEL
BRIGITTE
JEANNAN
RICKY
JOAN
BRIAN
ROSE
JANET
MARGARET
JUDITH
ALICE
ANNE
SHERRY
TIMOTHY
CAROL
Middle_Initial Last_Name
ARNDT
ATWOOD
BARBA
J
BEERY
V
BINDER
M
BIRCHLER
A
BLOME
D
BRABO
L
CARDINAL-DEMKO
R
CHESNY
K
DUPUY
R
ENGLEHARDT
GARCIA
GOULET
L
GREEN
HANSEN
HECHT
M
HODO
A
HUISKENS
IRISH
KAROLY
F
KILBORN
KOLB
LEARMAN
MAES
MARLIN
MCBRIDE
M
MCMARTIN
M
MERCIER
I
MORIN
MORSE
A
MUSINSKI
NADOLNY
NEELAKANDAN
M
PARMER
372-00-3702
366-00-6612
378-00-8956
372-00-2020
383-00-1808
382-00-2792
374-00-1101
375-00-9838
380-00-5248
382-00-1639
372-00-4927
Total
KATHLEEN
RICHARD
SUZANNE
JOHNNY
PATTI
BARBARA
PAULETTE
PATRICIA
MICHELE
DIANE
KATHRYN
J
W
A
46
PRIME
RICHARDSON
RIVARD
RUHLAND
SCHADE
SCHUMACHER
SMERDON
VANHAAREN
VASQUEZ
VOELKER
WARSZAWSKI
Address_Line_1
City
State
Zip_Code
Home_Phone_Number
Address_Line_1
421 BOWERS ROAD
250 CASCADE COURT
73 LINCOLN AVENUE
442 MOUNT VERNON PASS
296 SPRINGVALLEY DR
5125 EDDY LAKE ROAD
6141 RIVER RIDGE TRAIL
426 MURIEL DRIVE
10 STATE STREET
414 N IRISH
108 LYONS DRIVE
22 IRENE AVENUE
203 MILLER RD
06 TAMARAC DR
2759 SEVENTEEN MILE RD
487 HOWE RD
381 MERLE AVE
1208 JENNINGS
195 DILLON ROAD
336 CRYSTAL LAKE DRIVE
2059 JUNIPER WAY
379 N LINDEN RD
409 ALTOONA
08 NEFF RD
806 KEYES
281 S VASSAR
14 E PHILADELPHIA BLVD
338 N SEYMOUR ROAD
10 HICKORY STREET
326 N ELMS ROAD
32 E GENESEE STREET
709 COTT
192 ROBERTS DRIVE
521 MOUNTAIN AVENUE
5 PINEVIEW CT
City
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
SAGINAW
BAY CITY
BAY CITY
State
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Zip_Code
48706
48706
48706
48706
48706
48706
48706
48706
48603
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48734
48706
48706
48706
48603
48706
48603
48706
48706
Home_Phone_Number
(989)555-8944
(989)555-0304
(989)555-6897
(989)555-8466
(989)555-8076
(989)555-0257
(989)555-0169
(989)555-0724
(989)555-3317
(989)555-5290
(989)555-2255
(989)555-6146
(989)555-9620
(989)555-9795
(989)555-5902
(989)555-5134
(989)555-9897
(989)555-9824
(989)555-4402
(989)555-4276
(989)555-4391
(989)555-0318
(989)555-4552
(989)555-0296
(989)555-8317
(989)555-3664
(989)555-7425
(989)555-7282
(989)555-5602
(989)555-2117
(989)555-3179
(989)555-0116
(989)555-3122
(989)555-2105
(989)555-5167
075 E BRISTOL ROAD
0104 MORRIS RD
031 TORREY BEACH
073 WINSTON DR
200 W FRANCES
368 TIMBERWOOD PT DRIVE
3522 PETRUCCI
217 COMER
04 WILLIAMS
360 CRYSTAL LAKE DRIVE
161 E. WILLARD RD.
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
48734
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
(989)555-2593
(989)555-6210
(989)555-3951
(989)555-2110
(989)555-3885
(989)555-4192
(989)555-4563
(989)555-5252
(989)555-9640
(989)555-2190
(989)555-6730
Original_Hire_Date
Sex
Date_Of_Birth
Employee_Number
FT_PT_Code
Status_Code
Original_Hire_Date
7/19/1968
11/18/1999
8/26/2002
9/25/2000
7/27/1995
4/22/1996
5/9/1997
11/18/1996
7/23/2003
4/24/2003
6/18/1973
10/22/1979
10/8/2001
7/24/2000
6/10/1996
8/4/2003
3/6/2000
3/12/1979
8/25/2003
7/2/2001
11/18/1994
4/11/1996
8/23/1971
7/22/1985
9/26/2000
5/5/1998
3/11/1974
8/6/2001
9/2/1975
3/14/1994
8/4/2003
6/6/1977
11/10/1997
10/1/2001
9/24/2001
Sex
F
M
F
F
F
F
F
M
F
F
F
F
F
F
F
F
F
F
F
F
M
F
F
M
F
M
F
F
F
F
F
F
F
M
F
Date_Of_Birth
10/15/1950
6/7/1969
11/11/1964
4/22/1954
9/22/1948
5/22/1963
5/12/1972
9/20/1953
9/27/1955
3/19/1959
5/12/1962
4/1/1966
11/18/1978
3/4/1965
10/14/1946
5/1/1962
12/18/1976
8/26/1952
10/12/1975
5/12/1965
6/17/1955
9/14/1951
4/26/1964
10/5/1969
6/20/1956
8/9/1979
2/9/1966
1/30/1967
2/20/1962
9/8/1944
10/9/1959
9/16/1969
6/22/1964
8/2/1950
1/5/1977
Employee_Number
1117
1858
2087
525
2381
337
1671
2411
1135
2569
753
231
633
265
876
1596
426
1865
1728
2424
2618
1893
258
2075
2024
2748
803
1642
1926
1957
1391
644
2418
2488
1968
FT_PT_Code
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
CASUAL
CASUAL
FULLTIME
PARTTIME
FULLTIME
CASUAL
FULLTIME
CASUAL
FULLTIME
PARTTIME
Status_Code
A
T
A
T
A
A
A
A
A
A
A
A
A
T
A
A
A
A
T
A
A
T
A
A
A
T
A
A
A
A
A
A
A
A
A
11/3/1997
6/3/1985
11/15/1999
5/14/2001
1/17/2000
10/11/1999
10/13/1980
7/1/2001
4/18/1994
9/5/2000
6/25/2001
F
M
F
M
F
F
F
F
F
F
F
7/7/1950
9/10/1977
8/23/1948
1/4/1956
6/29/1965
11/2/1977
4/19/1972
9/19/1964
1/30/1973
5/14/1946
8/3/1959
1851
2625
1777
2635
2566
1871
1898
2142
246
2029
1164
PARTTIME
PARTTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
PARTTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
A
A
A
T
A
T
A
A
A
A
A
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
50
9.14
21.62
10.18
500
17
30.9
8.44
20.92
7.39
23.21
10.54
9.31
25
50.2
15.27
22.48
10.29
8.73
8.2
10.5
42.42
11.1
19.11
14.14
25.15
13.43
16.32
21.87
17.61
8.46
17.51
8.04
35
18.51
Job_Class_Code
0
80
0
80
0
80
0
80
0
0
50
0
80
0
0
0
64
80
80
0
48
0
80
0
48
0
48
0
80
0
0
48
0
0
0
Job_Class_Code
203
203
105
214
203
115
207
213
207
212
213
115
104
214
104
207
214
207
207
207
105
115
212
115
115
203
212
115
203
105
213
115
212
214
105
9.27
19.12
15.11
11.1
7.43
50
21.77
11.75
25.18
14.07
26.14
80
0
80
80
0
0
80
80
0
80
0
203
214
213
104
105
105
207
213
213
203
207
46
Social_Security_Number
First_Name
Middle_Initial Last_Name
Social_Security_Number
371-00-5947
362-00-4662
386-00-8050
372-00-8175
378-00-7036
362-00-6827
302-00-9892
365-00-5638
371-00-7606
368-00-2546
374-00-7000
366-00-6857
368-00-9630
375-00-8458
380-00-8491
381-00-6503
368-00-4911
383-00-1208
383-00-5665
381-00-8426
375-00-8199
376-00-6431
380-00-8590
386-00-6939
363-00-1106
040-00-8585
380-00-4317
375-00-7515
383-00-4401
367-00-3332
006-00-9871
363-00-9510
379-00-3961
369-00-0212
378-00-8030
First_Name
SANDRA
TYE
SUSAN
CAROL
MARLENE
LOUANN
SUSAN
JOSEPH
CONSTANCE
JANE
CHARLENE
ELLEN
SANDRA
ELIZABETH
BETTY
COLLEEN
CAROL
GERALYN
LYNNE
JANE
MICHAEL
BRIGITTE
JEANNAN
RICKY
JOAN
BRIAN
ROSE
JANET
MARGARET
JUDITH
ALICE
ANNE
SHERRY
TIMOTHY
CAROL
Middle_Initial Last_Name
ARNDT
ATWOOD
BARBA
J
BEERY
V
BINDER
M
BIRCHLER
A
BLOME
D
BRABO
L
CARDINAL-DEMKO
R
CHESNY
K
DUPUY
R
ENGLEHARDT
GARCIA
GOULET
L
GREEN
HANSEN
HECHT
M
HODO
A
HUISKENS
IRISH
KAROLY
F
KILBORN
KOLB
LEARMAN
MAES
MARLIN
MCBRIDE
M
MCMARTIN
M
MERCIER
I
MORIN
MORSE
A
MUSINSKI
NADOLNY
NEELAKANDAN
M
PARMER
372-00-3702
366-00-6612
378-00-8956
372-00-2020
383-00-1808
382-00-2792
374-00-1101
375-00-9838
380-00-5248
382-00-1639
372-00-4927
Total
KATHLEEN
RICHARD
SUZANNE
JOHNNY
PATTI
BARBARA
PAULETTE
PATRICIA
MICHELE
DIANE
KATHRYN
J
W
A
46
PRIME
RICHARDSON
RIVARD
RUHLAND
SCHADE
SCHUMACHER
SMERDON
VANHAAREN
VASQUEZ
VOELKER
WARSZAWSKI
Address_Line_1
City
State
Zip_Code
Home_Phone_Number
Address_Line_1
421 BOWERS ROAD
250 CASCADE COURT
73 LINCOLN AVENUE
442 MOUNT VERNON PASS
296 SPRINGVALLEY DR
5125 EDDY LAKE ROAD
6141 RIVER RIDGE TRAIL
426 MURIEL DRIVE
10 STATE STREET
414 N IRISH
108 LYONS DRIVE
22 IRENE AVENUE
203 MILLER RD
06 TAMARAC DR
2759 SEVENTEEN MILE RD
487 HOWE RD
381 MERLE AVE
1208 JENNINGS
195 DILLON ROAD
336 CRYSTAL LAKE DRIVE
2059 JUNIPER WAY
379 N LINDEN RD
409 ALTOONA
08 NEFF RD
806 KEYES
281 S VASSAR
14 E PHILADELPHIA BLVD
338 N SEYMOUR ROAD
10 HICKORY STREET
326 N ELMS ROAD
32 E GENESEE STREET
709 COTT
192 ROBERTS DRIVE
521 MOUNTAIN AVENUE
5 PINEVIEW CT
City
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
SAGINAW
BAY CITY
BAY CITY
State
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Zip_Code
48706
48706
48706
48706
48706
48706
48706
48706
48603
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48734
48706
48706
48706
48603
48706
48603
48706
48706
Home_Phone_Number
(989)555-8944
(989)555-0304
(989)555-6897
(989)555-8466
(989)555-8076
(989)555-0257
(989)555-0169
(989)555-0724
(989)555-3317
(989)555-5290
(989)555-2255
(989)555-6146
(989)555-9620
(989)555-9795
(989)555-5902
(989)555-5134
(989)555-9897
(989)555-9824
(989)555-4402
(989)555-4276
(989)555-4391
(989)555-0318
(989)555-4552
(989)555-0296
(989)555-8317
(989)555-3664
(989)555-7425
(989)555-7282
(989)555-5602
(989)555-2117
(989)555-3179
(989)555-0116
(989)555-3122
(989)555-2105
(989)555-5167
075 E BRISTOL ROAD
0104 MORRIS RD
031 TORREY BEACH
073 WINSTON DR
200 W FRANCES
368 TIMBERWOOD PT DRIVE
3522 PETRUCCI
217 COMER
04 WILLIAMS
360 CRYSTAL LAKE DRIVE
161 E. WILLARD RD.
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
48734
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
(989)555-2593
(989)555-6210
(989)555-3951
(989)555-2110
(989)555-3885
(989)555-4192
(989)555-4563
(989)555-5252
(989)555-9640
(989)555-2190
(989)555-6730
Original_Hire_Date
Sex
Date_Of_Birth
Employee_Number
FT_PT_Code
Status_Code
Original_Hire_Date
7/19/1968
11/18/1999
8/26/2002
9/25/2000
7/27/1995
4/22/1996
5/9/1997
11/18/1996
7/23/2003
4/24/2003
6/18/1973
10/22/1979
10/8/2001
7/24/2000
6/10/1996
8/4/2003
3/6/2000
3/12/1979
8/25/2003
7/2/2001
11/18/1994
4/11/1996
8/23/1971
7/22/1985
9/26/2000
5/5/1998
3/11/1974
8/6/2001
9/2/1975
3/14/1994
8/4/2003
6/6/1977
11/10/1997
10/1/2001
9/24/2001
Sex
F
M
F
F
F
F
F
M
F
F
F
F
F
F
F
F
F
F
F
F
M
F
F
M
F
M
F
F
F
F
F
F
F
M
F
Date_Of_Birth
10/15/1950
6/7/1969
11/11/1964
4/22/1954
9/22/1948
5/22/1963
5/12/1972
9/20/1953
9/27/1955
3/19/1959
5/12/1962
4/1/1966
11/18/1978
3/4/1965
10/14/1946
5/1/1962
12/18/1976
8/26/1952
10/12/1975
5/12/1965
6/17/1955
9/14/1951
4/26/1964
10/5/1969
6/20/1956
8/9/1979
2/9/1966
1/30/1967
2/20/1962
9/8/1944
10/9/1959
9/16/1969
6/22/1964
8/2/1950
1/5/1977
Employee_Number
1117
1858
2087
525
2381
337
1671
2411
1135
2569
753
231
633
265
876
1596
426
1865
1728
2424
2618
1893
258
2075
2024
2748
803
1642
1926
1957
1391
644
2418
2488
1968
FT_PT_Code
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
CASUAL
CASUAL
FULLTIME
PARTTIME
FULLTIME
CASUAL
FULLTIME
CASUAL
FULLTIME
PARTTIME
Status_Code
A
T
A
T
A
A
A
A
A
A
A
A
A
T
A
A
A
A
T
A
A
T
A
A
A
T
A
A
A
A
A
A
A
A
A
11/3/1997
6/3/1985
11/15/1999
5/14/2001
1/17/2000
10/11/1999
10/13/1980
7/1/2001
4/18/1994
9/5/2000
6/25/2001
F
M
F
M
F
F
F
F
F
F
F
7/7/1950
9/10/1977
8/23/1948
1/4/1956
6/29/1965
11/2/1977
4/19/1972
9/19/1964
1/30/1973
5/14/1946
8/3/1959
1851
2625
1777
2635
2566
1871
1898
2142
246
2029
1164
PARTTIME
PARTTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
PARTTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
A
A
A
T
A
T
A
A
A
A
A
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
50
9.14
21.62
10.18
500
17
30.9
8.44
20.92
7.39
23.21
10.54
9.31
25
50.2
15.27
22.48
10.29
8.73
8.2
10.5
42.42
11.1
19.11
14.14
25.15
13.43
16.32
21.87
17.61
8.46
17.51
8.04
35
18.51
Job_Class_Code
0
80
0
80
0
80
0
80
0
0
50
0
80
0
0
0
64
80
80
0
48
0
80
0
48
0
48
0
80
0
0
48
0
0
0
Job_Class_Code
203
203
105
214
203
115
207
213
207
212
213
115
104
214
104
207
214
207
207
207
105
115
212
115
115
203
212
115
203
105
213
115
212
214
105
9.27
19.12
15.11
11.1
7.43
50
21.77
11.75
25.18
14.07
26.14
80
0
80
80
0
0
80
80
0
80
0
203
214
213
104
105
105
207
213
213
203
207
46
Social_Security_Number
First_Name
Middle_Initial Last_Name
Social_Security_Number
371-00-5947
362-00-4662
386-00-8050
372-00-8175
378-00-7036
362-00-6827
302-00-9892
365-00-5638
371-00-7606
368-00-2546
374-00-7000
366-00-6857
368-00-9630
375-00-8458
380-00-8491
381-00-6503
368-00-4911
383-00-1208
383-00-5665
381-00-8426
375-00-8199
376-00-6431
380-00-8590
386-00-6939
363-00-1106
040-00-8585
380-00-4317
375-00-7515
383-00-4401
367-00-3332
006-00-9871
363-00-9510
379-00-3961
369-00-0212
378-00-8030
First_Name
SANDRA
TYE
SUSAN
CAROL
MARLENE
LOUANN
SUSAN
JOSEPH
CONSTANCE
JANE
CHARLENE
ELLEN
SANDRA
ELIZABETH
BETTY
COLLEEN
CAROL
GERALYN
LYNNE
JANE
MICHAEL
BRIGITTE
JEANNAN
RICKY
JOAN
BRIAN
ROSE
JANET
MARGARET
JUDITH
ALICE
ANNE
SHERRY
TIMOTHY
CAROL
Middle_Initial Last_Name
ARNDT
ATWOOD
BARBA
J
BEERY
V
BINDER
M
BIRCHLER
A
BLOME
D
BRABO
L
CARDINAL-DEMKO
R
CHESNY
K
DUPUY
R
ENGLEHARDT
GARCIA
GOULET
L
GREEN
HANSEN
HECHT
M
HODO
A
HUISKENS
IRISH
KAROLY
F
KILBORN
KOLB
LEARMAN
MAES
MARLIN
MCBRIDE
M
MCMARTIN
M
MERCIER
I
MORIN
MORSE
A
MUSINSKI
NADOLNY
NEELAKANDAN
M
PARMER
372-00-3702
366-00-6612
378-00-8956
372-00-2020
383-00-1808
382-00-2792
374-00-1101
375-00-9838
380-00-5248
382-00-1639
372-00-4927
Total
KATHLEEN
RICHARD
SUZANNE
JOHNNY
PATTI
BARBARA
PAULETTE
PATRICIA
MICHELE
DIANE
KATHRYN
J
W
A
46
PRIME
RICHARDSON
RIVARD
RUHLAND
SCHADE
SCHUMACHER
SMERDON
VANHAAREN
VASQUEZ
VOELKER
WARSZAWSKI
Address_Line_1
City
State
Zip_Code
Home_Phone_Number
Address_Line_1
421 BOWERS ROAD
250 CASCADE COURT
73 LINCOLN AVENUE
442 MOUNT VERNON PASS
296 SPRINGVALLEY DR
5125 EDDY LAKE ROAD
6141 RIVER RIDGE TRAIL
426 MURIEL DRIVE
10 STATE STREET
414 N IRISH
108 LYONS DRIVE
22 IRENE AVENUE
203 MILLER RD
06 TAMARAC DR
2759 SEVENTEEN MILE RD
487 HOWE RD
381 MERLE AVE
1208 JENNINGS
195 DILLON ROAD
336 CRYSTAL LAKE DRIVE
2059 JUNIPER WAY
379 N LINDEN RD
409 ALTOONA
08 NEFF RD
806 KEYES
281 S VASSAR
14 E PHILADELPHIA BLVD
338 N SEYMOUR ROAD
10 HICKORY STREET
326 N ELMS ROAD
32 E GENESEE STREET
709 COTT
192 ROBERTS DRIVE
521 MOUNTAIN AVENUE
5 PINEVIEW CT
City
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
SAGINAW
BAY CITY
SAGINAW
BAY CITY
BAY CITY
State
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
Zip_Code
48706
48706
48706
48706
48706
48706
48706
48706
48603
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
48734
48706
48706
48706
48603
48706
48603
48706
48706
Home_Phone_Number
(989)555-8944
(989)555-0304
(989)555-6897
(989)555-8466
(989)555-8076
(989)555-0257
(989)555-0169
(989)555-0724
(989)555-3317
(989)555-5290
(989)555-2255
(989)555-6146
(989)555-9620
(989)555-9795
(989)555-5902
(989)555-5134
(989)555-9897
(989)555-9824
(989)555-4402
(989)555-4276
(989)555-4391
(989)555-0318
(989)555-4552
(989)555-0296
(989)555-8317
(989)555-3664
(989)555-7425
(989)555-7282
(989)555-5602
(989)555-2117
(989)555-3179
(989)555-0116
(989)555-3122
(989)555-2105
(989)555-5167
075 E BRISTOL ROAD
0104 MORRIS RD
031 TORREY BEACH
073 WINSTON DR
200 W FRANCES
368 TIMBERWOOD PT DRIVE
3522 PETRUCCI
217 COMER
04 WILLIAMS
360 CRYSTAL LAKE DRIVE
161 E. WILLARD RD.
FRANKENMUTH
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
BAY CITY
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
MI
48734
48706
48706
48706
48706
48706
48706
48706
48706
48706
48706
(989)555-2593
(989)555-6210
(989)555-3951
(989)555-2110
(989)555-3885
(989)555-4192
(989)555-4563
(989)555-5252
(989)555-9640
(989)555-2190
(989)555-6730
Original_Hire_Date
Sex
Date_Of_Birth
Employee_Number
FT_PT_Code
Status_Code
Original_Hire_Date
7/19/1968
11/18/1999
8/26/2002
9/25/2000
7/27/1995
4/22/1996
5/9/1997
11/18/1996
7/23/2003
4/24/2003
6/18/1973
10/22/1979
10/8/2001
7/24/2000
6/10/1996
8/4/2003
3/6/2000
3/12/1979
8/25/2003
7/2/2001
11/18/1994
4/11/1996
8/23/1971
7/22/1985
9/26/2000
5/5/1998
3/11/1974
8/6/2001
9/2/1975
3/14/1994
8/4/2003
6/6/1977
11/10/1997
10/1/2001
9/24/2001
Sex
F
M
F
F
F
F
F
M
F
F
F
F
F
F
F
F
F
F
F
F
M
F
F
M
F
M
F
F
F
F
F
F
F
M
F
Date_Of_Birth
10/15/1950
6/7/1969
11/11/1964
4/22/1954
9/22/1948
5/22/1963
5/12/1972
9/20/1953
9/27/1955
3/19/1959
5/12/1962
4/1/1966
11/18/1978
3/4/1965
10/14/1946
5/1/1962
12/18/1976
8/26/1952
10/12/1975
5/12/1965
6/17/1955
9/14/1951
4/26/1964
10/5/1969
6/20/1956
8/9/1979
2/9/1966
1/30/1967
2/20/1962
9/8/1944
10/9/1959
9/16/1969
6/22/1964
8/2/1950
1/5/1977
Employee_Number
1117
1858
2087
525
2381
337
1671
2411
1135
2569
753
231
633
265
876
1596
426
1865
1728
2424
2618
1893
258
2075
2024
2748
803
1642
1926
1957
1391
644
2418
2488
1968
FT_PT_Code
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
FULLTIME
CASUAL
CASUAL
FULLTIME
PARTTIME
FULLTIME
CASUAL
FULLTIME
CASUAL
FULLTIME
PARTTIME
Status_Code
A
T
A
T
A
A
A
A
A
A
A
A
A
T
A
A
A
A
T
A
A
T
A
A
A
T
A
A
A
A
A
A
A
A
A
11/3/1997
6/3/1985
11/15/1999
5/14/2001
1/17/2000
10/11/1999
10/13/1980
7/1/2001
4/18/1994
9/5/2000
6/25/2001
F
M
F
M
F
F
F
F
F
F
F
7/7/1950
9/10/1977
8/23/1948
1/4/1956
6/29/1965
11/2/1977
4/19/1972
9/19/1964
1/30/1973
5/14/1946
8/3/1959
1851
2625
1777
2635
2566
1871
1898
2142
246
2029
1164
PARTTIME
PARTTIME
PARTTIME
CASUAL
PARTTIME
PARTTIME
PARTTIME
FULLTIME
PARTTIME
FULLTIME
FULLTIME
A
A
A
T
A
T
A
A
A
A
A
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
Hourly_Base_Pay
Budgeted_Hours_Per_Pay
50
9.14
21.62
10.18
500
17
30.9
8.44
20.92
7.39
23.21
10.54
9.31
25
50.2
15.27
22.48
10.29
8.73
8.2
10.5
42.42
11.1
19.11
14.14
25.15
13.43
16.32
21.87
17.61
8.46
17.51
8.04
35
18.51
Job_Class_Code
0
80
0
80
0
80
0
80
0
0
50
0
80
0
0
0
64
80
80
0
48
0
80
0
48
0
48
0
80
0
0
48
0
0
0
Job_Class_Code
203
203
105
214
203
115
207
213
207
212
213
115
104
214
104
207
214
207
207
207
105
115
212
115
115
203
212
115
203
105
213
115
212
214
105
9.27
19.12
15.11
11.1
7.43
50
21.77
11.75
25.18
14.07
26.14
80
0
80
80
0
0
80
80
0
80
0
203
214
213
104
105
105
207
213
213
203
207
46
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.😀 Hi there! I completed the assignment! 😀 I'm aiming to be a 5 starts tutor, hence feel free to send me any questions and to review whatever I did. I will be willing to fix it asap.
Social_Security_Number
First_Name
Middle_Initial Last_Name
Social_Security_Number
371-00-5947
362-00-4662
386-00-8050
372-00-8175
378-00-7036
362-00-6827
302-00-9892
365-00-5638
371-00-7606
368-00-2546
374-00-7000
366-00-6857
368-00-9630
375-00-8458
380-00-8491
381-00-6503
368-00-4911
383-00-1208
383-00-5665
381-00-8426
375-00-8199
376-00-6431
380-00-8590
386-00-6939
363-00-1106
040-00-8585
380-00-4317
375-00-7515
383-00-4401
367-00-3332
006-00-9871
363-00-9510
379-00-3961
369-00-0212
378-00-8030
First_Name
SANDRA
TYE
SUSAN
CAROL
MARLENE
LOUANN
SUSAN
JOSEPH
CONSTANCE
JANE
CHARLENE
ELLEN
SANDRA
ELIZABETH
BETTY
COLLEEN
CAROL
GERALYN
LYNNE
JANE
MICHAEL
BRIGITTE
JEANNAN
RICKY
JOAN
BRIAN
ROSE
JANET
MARGARET
JUDITH
ALICE
ANNE
SHERRY
TIMOTHY
CAROL
Middle_Initial Last_Name
ARNDT
ATWOOD
BARBA
J
BEERY
V
BINDER
M
BIRCHLER
A
BLOME
D
BRABO
L
CARDINAL-DEMKO
R
CHESNY
K
DUPUY
R
ENGLEHARDT
GARCIA
GOULET
L
GREEN
HANSEN
HECHT
M
HODO
A
HUISKENS
IRISH
KAROLY
F
KILBORN
KOLB
LEARMAN
MAES
MARLIN
MCBRIDE
M
MCMARTIN
M
MERCIER
I
MORIN
MORSE
A
MUSINSKI
NADOLNY
NEELAKANDAN
M
PARMER
372-00-3702
366-00-6612
378-00-8956
372-00-2020
383-00-1808
382-00-2792
374-00-1101
375-00-9838
380-00-5248
382-00-1639
372-00-4927
KATHLEEN
RICHARD
SUZANNE
JOHNNY
PATTI
BARBARA
PAULETTE
PATRICIA
MICHELE
DIANE
KATHRYN
J
W
A
PRIME
RICHARDSON
RIVARD
RUHLAND
SCHADE
SCHUMACHER
SMERDON
VANHAAREN
VASQUEZ
VOELKER
WARSZAWSKI
Address_Line_1
City
State
Zip_Code
48603
48706
48734
Home_Phone_Number
Address_Line_1
421 BOWERS ROAD
250 CASCADE COURT
73 LINCOLN AVENUE
442 MOUNT VER...
Review
Review
Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
MMIS692 Nova Southeastern University Business Intelligence Project
You must include the following in your mid-term report:LP formulation for the production-planning problem (as required in ...
Need help with this home work
Need you to follow all the instruction and be original and plagiarism free. Thanks for the help...
MT302 Kaplan University Four Functions of Management Discussion
Four Functions of ManagementPresent and future managers benefit from becoming proficient in the
four functions of manage...
Cash flow assessment
Everything is attached. Look at the scoring guide must have everything in the distinguished column.Thanks...
The Time Value of Money
Present values are negatively impacted by higher interest rates. How
does compounding compare with discounting? How does...
MGT 424 Saudi Electronic University Customer Focused Environment Article Q&As
College of Administrative and Financial Sciences
Assignment 1
Deadline: 23/10/2021 @ 23:59
Course Name: Quality managemen...
Global Trend Composition
Daily, business leaders are charged with making decisions that have an impact on the outcomes of organizations. Most of th...
Research Paper About Performance Appraisal 11
Performance appraisal is part of the Performance Management requirements in assessing the performance of employees, contin...
The Socio Political Compass.edited
The Fortune 500 company that I chose for this assignment is Amazon. This company is currently ranked number 2 in 2020 afte...
