Datakliq Assignment as at the 21/11/2023

Click the navigation

buttons below
l Home

l Story

l Employee

l Task
Designed by datakliq
by datakliq
Conversation

Hi John, I need Your

Help on something

Task
So the finance team just sent in a table that contains
employees code and current salary, I need you to
assit to populate the table with the names, age,
Department of the staffs, I have included the
employee dimension table to help with that

Additional Task

One last thing, You would need to calculate the new

salary of some staffs based on certain criteria's, I have
included additional informations on the Task sheet, I need
the information on or before friday 11:59 PM, Thank you
 Sure I would Love to
help, What do you
want me to do

that contains
eed you to Ok, Boss would that be all,
mes, age, and when do you need the
ed the requested information
h that

lculate the new

n criteria's, I have
he Task sheet, I need Ok boss, I am on it
1:59 PM, Thank you
Code Name Age Contract Date Ft In Inches
Pau1 Paulson Adebo 23 1/1/2005 6 1 73
Zac2 Zach Allen 24 1/1/2006 6 4 76
Kik3 Kiko Alonso N/A 1/1/2010 6 3 75
Ste4 Stephen Anderson 29 1/1/2018 6 2 74
Jos5 Josh Andrews 31 1/1/2019 6 2 74
Mar6 Marcell Ateman N/A 1/1/2023 6 4 76
And7 Andre Baccellia 25 1/1/2022 5 10 70
Bud8 Budda Baker 26 1/1/2020 5 10 70
Kaw9 Kawaan Baker 23 1/1/2007 6 1 73
Dar10 Darrell Baker Jr. 24 1/1/2008 6 1 73
Zac11 Zack Baun 25 1/1/2005 6 3 75
Kel12 Kelvin Beachum 33 1/1/2006 6 3 75
Eno13 Eno Benjamin 23 1/1/2010 5 9 69
Jos14 Josh Black 24 1/1/2018 6 3 75
Vic15 Victor Bolden 27 1/1/2019 5 8 68
Ian16 Ian Book 24 1/1/2023 6 0 72
Bre17 Breon Borders 27 1/1/2022 6 0 72
Aar18 Aaron Brewer 32 1/1/2020 6 5 77
Nat19 Nate Brooks 25 1/1/2007 6 0 72
Mal20 Malcolm Brown 29 1/1/2008 5 11 71
Mar21 Marquise Brown 25 1/1/2005 5 9 69
Mar22 Marquez Callaway 24 1/1/2006 6 2 74
Tac23 Taco Charlton 27 1/1/2010 6 5 77
Zav24 Zaven Collins 23 1/1/2018 6 4 76
Jam25 James Conner 27 1/1/2019 6 1 73
Nol26 Nolan Cooney 25 1/1/2023 6 3 75
Ras27 Rashaad Coward 27 1/1/2022 6 5 77
Tae28 Tae Daley 23 1/1/2020 5 11 71
And29 Andy Dalton 34 1/1/2007 6 2 74
Dem30 Demario Davis 33 1/1/2008 6 2 74
Vic31 Victor Dimukeje 22 1/1/2005 6 2 74
Dai32 Dai'Jean Dixon 23 1/1/2006 6 4 76
Mic33 Michael Dogbe 26 1/1/2010 6 3 75
Gre34 Greg Dortch 24 1/1/2018 5 7 67
And35 Andrew Dowell 25 1/1/2019 6 1 73
Sag36 Sage Doxtater 23 1/1/2023 6 7 79
Kad37 Kaden Elliss 27 1/1/2022 6 3 75
Zac38 Zach Ertz 31 1/1/2020 6 5 77
Jus39 Justin Evans 26 1/1/2007 6 0 72
DaM40 DaMarcus Fields 24 1/1/2008 6 0 72
Lek41 Leki Fotu 23 1/1/2005 6 5 77
Den42 Dennis Gardeck 28 1/1/2006 6 0 72
C.J43 C.J. Gardner-Johnson 24 1/1/2010 5 11 71
Bla44 Blake Gillikin 24 1/1/2018 6 2 74
Mar45 Markus Golden 31 1/1/2019 6 3 75
Car46 Carl Granderson 25 1/1/2023 6 5 77
J.T47 J.T. Gray 26 1/1/2022 6 0 72
Vin48 Vincent Gray 22 1/1/2020 6 2 74
A.J49 A.J. Green 34 1/1/2007 6 4 76
Eth50 Ethan Greenidge 24 1/1/2008 6 4 76
Jar51 Jarrett Guarantano 24 1/1/2005 6 3 75
Ant52 Antonio Hamilton 29 1/1/2006 6 0 72
Sea53 Sean Harlow 27 1/1/2010 6 4 76
Deo54 Deonte Harty 24 1/1/2018 5 6 66
Jer55 Jerald Hawkins 28 1/1/2019 6 6 78
Mar56 Marquis Hayes 23 1/1/2023 6 5 77
Wil57 Will Hernandez 26 1/1/2022 6 2 74
Chr58 Chris Herndon 26 1/1/2020 6 4 76
Tay59 Taysom Hill 31 1/1/2007 6 2 74
J.P60 J.P. Holtz 28 1/1/2008 6 3 75
DeA61 DeAndre Hopkins 30 1/1/2005 6 1 73
Rod62 Rodney Hudson 33 1/1/2006 6 2 74
Alb63 Albert Huggins 25 1/1/2010 6 3 75
D.J64 D.J. Humphries 28 1/1/2018 6 5 77
Jam65 James Hurst 30 1/1/2019 6 5 77
Kea66 Keaontay Ingram 22 1/1/2023 6 0 72
Mar67 Mark Ingram II 32 1/1/2022 5 9 69
And68 Andy Isabella 25 1/1/2020 5 9 69
Dan69 Danny Isidora 28 1/1/2007 6 3 75
D'M70 D'Marco Jackson 24 1/1/2008 6 1 73
Jor71 Jordan Jackson 24 1/1/2005 6 5 77
Jos72 Josh Jackson 26 1/1/2006 6 0 72
Jal73 Jaleel Johnson 28 1/1/2010 6 3 75
Juw74 Juwan Johnson 25 1/1/2018 6 4 76
Jos75 Josh Jones 25 1/1/2019 6 5 77
Man76 Manny Jones 23 1/1/2023 6 4 76
Ton77 Tony Jones Jr. 24 1/1/2022 5 11 71
Cam78 Cameron Jordan 33 1/1/2020 6 4 76
Alv79 Alvin Kamara 27 1/1/2007 5 10 70
Kin80 Kingsley Keke 25 1/1/2008 6 3 75
Dev81 Devon Kennard 31 1/1/2005 6 3 75
Lew82 Lewis Kidd 24 1/1/2006 6 6 78
Jon83 Jontre Kirklin 23 1/1/2010 6 0 72
Tan84 Tanoh Kpassagnon 28 1/1/2018 6 7 79
Luc85 Lucas Krull 24 1/1/2019 6 6 78
For86 Forrest Lamp 28 1/1/2023 6 4 76
Jar87 Jarvis Landry 29 1/1/2022 5 11 71
Mar88 Marshon Lattimore 26 1/1/2020 6 0 72
Ras89 Rashard Lawrence 23 1/1/2007 6 2 74
Jon90 Jonathan Ledbetter 24 1/1/2008 6 4 76
And91 Andy Lee 40 1/1/2005 6 1 73
Jes92 Jessie Lemonier 25 1/1/2006 6 2 74
Gre93 Greg Long 25 1/1/2010 6 3 75
Jes94 Jesse Luketa 23 1/1/2018 6 3 75
Wil95 Wil Lutz 28 1/1/2019 5 11 71
Dyl96 Dylan Mabin 24 1/1/2023 6 1 73
Kod97 Koda Martin 26 1/1/2022 6 7 79
Nic98 Nick Martin 29 1/1/2020 6 4 76
Tyr99 Tyrann Mathieu 30 1/1/2007 5 9 69
Chr100 Christian Matthew 25 1/1/2008 6 2 74
Mar101 Marcus Maye 29 1/1/2005 5 11 71
Tre102 Trey McBride 22 1/1/2006 6 3 75
Col103 Colt McCoy 35 1/1/2010 6 1 73
Eri104 Erik McCoy 24 1/1/2018 6 4 76
Tra105 Trace McSorley 26 1/1/2019 6 0 72
Kir106 Kirk Merritt 25 1/1/2023 6 0 72
Jos107 Joshua Miles 26 1/1/2022 6 5 77
Ron108 Rondale Moore 22 1/1/2020 5 7 67
Byr109 Byron Murphy Jr. 24 1/1/2007 5 11 71
Jus110 Justin Murray 29 1/1/2008 6 5 77
Kyl111 Kyler Murray 25 1/1/2005 5 10 70
Hag112 Haggai Ndubuisi 21 1/1/2006 6 6 78
Ben113 Ben Niemann 27 1/1/2010 6 2 74
Chr114 Chris Olave 22 1/1/2018 6 1 73
Dav115 David Onyemata 29 1/1/2019 6 4 76
Dev116 Devine Ozigbo 25 1/1/2023 6 0 72
Joh117 John Parker Romo 24 1/1/2022 5 11 71
Sco118 Scott Patchan 25 1/1/2020 6 4 76
JaV119 JaVonta Payton 23 1/1/2007 6 0 72
And120 Andrus Peat 28 1/1/2008 6 7 79
Tre121 Trevor Penning 23 1/1/2005 6 7 79
Chr122 Chris Pierce Jr. 23 1/1/2006 6 3 75
T.J123 T.J. Pledger 22 1/1/2010 5 9 69
Mat124 Matt Prater 38 1/1/2018 5 10 70
Ada125 Adam Prentice 25 1/1/2019 6 0 72
Isa126 Isaiah Pryor 24 1/1/2023 6 1 73
Jus127 Justin Pugh 31 1/1/2022 6 5 77
Rya128 Ryan Ramczyk 28 1/1/2020 6 6 78
Chr129 Christian Ringo 30 1/1/2007 6 1 73
Ron130 Ronnie Rivers 23 1/1/2008 5 9 69
Mal131 Malcolm Roach 24 1/1/2005 6 3 75
Bra132 Bradley Roby 30 1/1/2006 5 11 71
Ces133 Cesar Ruiz 23 1/1/2010 6 4 76
Myj134 Myjai Sanders 24 1/1/2018 6 5 77
Ber135 Bernhard Seikovits 25 1/1/2019 6 5 77
Nep136 Nephi Sewell 23 1/1/2023 6 0 72
Isa137 Isaiah Simmons 24 1/1/2022 6 4 76
Abr138 Abram Smith 23 1/1/2020 5 11 71
Lec139 Lecitus Smith 24 1/1/2007 6 3 75
Tre140 Tre'Quan Smith 26 1/1/2008 6 2 74
Dan141 Daniel Sorensen 32 1/1/2005 6 1 73
Ken142 Kentavius Street 25 1/1/2006 6 2 74
Alo143 Alontae Taylor 23 1/1/2010 6 0 72
Cam144 Cameron Thomas 22 1/1/2018 6 5 77
Mic145 Michael Thomas 29 1/1/2019 6 3 75
Bry146 Bryce Thompson 22 1/1/2023 5 11 71
Dei147 Deionte Thompson 25 1/1/2022 6 1 73
Jal148 Jalen Thompson 24 1/1/2020 5 11 71
Cal149 Calvin Throckmorton 25 1/1/2007 6 5 77
Ada150 Adam Trautman 25 1/1/2008 6 5 77
Eze151 Ezekiel Turner 26 1/1/2005 6 2 74
Pay152 Payton Turner 23 1/1/2006 6 6 78
Shy153 Shy Tuttle 26 1/1/2010 6 3 75
Tan154 Tanner Vallejo 27 1/1/2018 6 1 73
Nic155 Nick Vannett 29 1/1/2019 6 6 78
Nic156 Nick Vigil 28 1/1/2023 6 2 74
Joe157 Joe Walker 29 1/1/2022 6 2 74
Jon158 Jonathan Ward 24 1/1/2020 6 0 72
Cha159 Charles Washington 29 1/1/2007 5 10 70
Dwa160 Dwayne Washington 28 1/1/2008 6 1 73
Kha161 Khalique Washington 23 1/1/2005 6 5 77
J.J162 J.J. Watt 33 1/1/2006 6 5 77
Pet163 Pete Werner 23 1/1/2010 6 3 75
Ant164 Antoine Wesley 24 1/1/2018 6 4 76
Kev165 Kevin White 30 1/1/2019 6 3 75
Jac166 Jace Whittaker 27 1/1/2023 5 11 71
Jam167 James Wiggins 25 1/1/2022 5 11 71
Dar168 Darrel Williams 27 1/1/2020 5 11 71
Max169 Maxx Williams 28 1/1/2007 6 4 76
P.J170 P.J. Williams 29 1/1/2008 6 0 72
Eri171 Eric Wilson 27 1/1/2005 6 1 73
Mar172 Marco Wilson 23 1/1/2006 5 11 71
Jam173 Jameis Winston 28 1/1/2010 6 4 76
Eas174 Easop Winston Jr. 25 1/1/2018 6 0 72
Zac175 Zach Wood 29 1/1/2019 6 3 75
Ant176 Antwaun Woods 29 1/1/2023 6 1 73
Cha177 Chandler Wooten 23 1/1/2022 6 3 75
Deo178 Deon Yelder 27 1/1/2020 6 4 76
Lan179 Landon Young 24 1/1/2007 6 7 79
Ham180 Hamza Abdullah 26 1/1/2008 6 2 74
Mic181 Michael Adams 24 1/1/2005 5 8 68
Sta182 Stanley Arnoux 23 1/1/2006 6 0 72
Rem183 Remi Ayodele 26 1/1/2010 6 2 74
Jas184 Jason Banks 24 1/1/2018 6 5 77
Ant185 Anthony Becht 32 1/1/2019 6 6 78
Mon186 Monty Beisel 31 1/1/2023 6 3 75
Mik187 Mike Bell 26 1/1/2022 6 0 72
Ber188 Bertrand Berry 34 1/1/2020 6 3 75
Anq189 Anquan Boldin 29 1/1/2007 6 1 73
Ala190 Alan Branch 25 1/1/2008 6 5 77
Ste191 Steve Breaston 26 1/1/2005 6 0 72
Dre192 Drew Brees 31 1/1/2006 6 0 72
Jer193 Jeremy Bridges 29 1/1/2010 6 4 76
Neh194 Nehemiah Broughton 28 1/1/2018 5 11 71
Cod195 Cody Brown 23 1/1/2019 6 3 75
Jam196 Jammal Brown 28 1/1/2023 6 6 78
Lev197 Levi Brown 25 1/1/2022 6 5 77
Ral198 Ralph Brown 31 1/1/2020 5 10 70
Mar199 Mark Brunell 39 1/1/2007 6 1 73
Reg200 Reggie Bush 24 1/1/2008 6 0 72
Jer201 Jermon Bushrod 25 1/1/2005 6 5 77
Cal202 Calais Campbell 23 1/1/2006 6 8 80
Dan203 Dan Campbell 33 1/1/2010 6 5 77
Jon204 Jonathan Casillas 22 1/1/2018 6 1 73
Jef205 Jeff Charleston 26 1/1/2019 6 4 76
Ken206 Kendrick Clancy 31 1/1/2023 6 1 73
Jer207 Jeremy Clark 26 1/1/2022 6 3 75
Ben208 Ben Claxton 29 1/1/2020 6 2 74
Mar209 Marques Colston 26 1/1/2007 6 4 76
Cha210 Chase Daniel 23 1/1/2008 6 0 72
Kar211 Karlos Dansby 28 1/1/2005 6 4 76
Wil212 Will Davis 23 1/1/2006 6 2 74
Dar213 Darnell Dinkins 32 1/1/2010 6 4 76
Dar214 Darnell Dockett 28 1/1/2018 6 4 76
Ear215 Early Doucet 24 1/1/2019 6 0 72
Jo-216 Jo-Lonn Dunbar 24 1/1/2023 6 0 72
Kyl217 Kyle Eckel 28 1/1/2022 5 11 71
Sed218 Sedrick Ellis 24 1/1/2020 6 1 73
Hea219 Heath Evans 31 1/1/2007 6 0 72
Jah220 Jahri Evans 26 1/1/2008 6 4 76
Tro221 Troy Evans 32 1/1/2005 6 3 75
Lar222 Larry Fitzgerald 26 1/1/2006 6 3 75
Wil223 Wilrey Fontenot 25 1/1/2010 5 10 70
Sco224 Scott Fujita 30 1/1/2018 6 5 77
Mik225 Mike Gandy 31 1/1/2019 6 4 76
Ran226 Randall Gay 27 1/1/2023 5 11 71
Jon227 Jonathan Goodwin 31 1/1/2022 6 3 75
Ben228 Ben Graham 36 1/1/2020 6 5 77
Cha229 Charles Grant 31 1/1/2007 6 3 75
Jus230 Justin Green 27 1/1/2008 5 11 71
Jab231 Jabari Greer 27 1/1/2005 5 11 71
Cla232 Clark Haggans 33 1/1/2006 6 4 76
Lyn233 Lynell Hamilton 24 1/1/2010 6 0 72
Ant234 Anthony Hargrove 26 1/1/2018 6 3 75
Rod235 Rod Harper 24 1/1/2019 6 0 72
Rom236 Roman Harper 27 1/1/2023 6 1 73
Gar237 Garrett Hartley 23 1/1/2022 5 8 68
Ger238 Gerald Hayes 29 1/1/2020 6 1 73
Dev239 Devery Henderson 27 1/1/2007 5 11 71
Tim240 Tim Hightower 23 1/1/2008 6 0 72
Tor241 Tory Humphrey 26 1/1/2005 6 2 74
Ken242 Kenny Iwebema 24 1/1/2006 6 4 76
Mal243 Malcolm Jenkins 22 1/1/2010 6 0 72
Her244 Herman Johnson 24 1/1/2018 6 7 79
Ras245 Rashad Johnson 24 1/1/2019 5 11 71
Reg246 Reggie Jones 23 1/1/2023 6 0 72
Bra247 Brandon Keith 25 1/1/2022 6 5 77
Dan248 Dan Kreider 32 1/1/2020 5 11 71
Mik249 Mike Leach 33 1/1/2007 6 2 74
Nic250 Nick Leckey 27 1/1/2008 6 3 75
Mat251 Matt Leinart 26 1/1/2005 6 5 77
Rod252 Rodney Leisle 28 1/1/2006 6 3 75
Deu253 Deuce Lutui 26 1/1/2010 6 4 76
Mar254 Marcus Mailei 23 1/1/2018 6 0 72
Deu255 Deuce McAllister 31 1/1/2019 6 1 73
Bob256 Bobby McCray 28 1/1/2023 6 6 78
Bry257 Bryant McFadden 28 1/1/2022 6 0 72
Rob258 Robert Meachem 25 1/1/2020 6 2 74
Bil259 Billy Miller 32 1/1/2007 6 3 75
Mar260 Marvin Mitchell 25 1/1/2008 6 3 75
Lan261 Lance Moore 26 1/1/2005 5 9 69
Sea262 Sean Morey 33 1/1/2006 5 11 71
Tho263 Thomas Morstead 23 1/1/2010 6 4 76
Jam264 Jamar Nesbit 33 1/1/2018 6 4 76
Car265 Carl Nicks 24 1/1/2019 6 5 77
Chi266 Chike Okeafor 33 1/1/2023 6 5 77
Ben267 Ben Patrick 25 1/1/2022 6 3 75
Tra268 Tracy Porter 23 1/1/2020 5 11 71
DeM269 DeMario Pressley 24 1/1/2007 6 3 75
Pie270 Pierson Prioleau 32 1/1/2008 5 11 71
Nei271 Neil Rackers 33 1/1/2005 6 1 73
Chr272 Chris Reis 26 1/1/2006 6 1 73
Bry273 Bryan Robinson 35 1/1/2010 6 4 76
Cou274 Courtney Roby 27 1/1/2018 6 0 72
Dom275 Dominique Rodgers-Cromartie 23 1/1/2019 6 2 74
Ant276 Antrel Rolle 27 1/1/2023 6 0 72
Lyl277 Lyle Sendlein 25 1/1/2022 6 3 75
Sco278 Scott Shanle 30 1/1/2020 6 2 74
Dar279 Darren Sharper 34 1/1/2007 6 2 74
Jer280 Jeremy Shockey 29 1/1/2008 6 5 77
Mar281 Mark Simoneau 32 1/1/2005 6 0 72
Wil282 Will Smith 28 1/1/2006 6 3 75
Ste283 Stephen Spach 27 1/1/2010 6 4 76
Pau284 Paul Spicer 34 1/1/2018 6 4 76
Bri285 Brian St. Pierre 30 1/1/2019 6 3 75
LaR286 LaRod Stephens-Howling 22 1/1/2023 5 7 67
Jon287 Jonathan Stinchcomb 30 1/1/2022 6 5 77
Zac288 Zach Strief 26 1/1/2020 6 7 79
Dav289 David Thomas 26 1/1/2007 6 3 75
Pie290 Pierre Thomas 25 1/1/2008 5 11 71
Gre291 Greg Toler 25 1/1/2005 5 10 70
Lei292 Leigh Torrence 28 1/1/2006 5 11 71
Jer293 Jerheme Urban 29 1/1/2010 6 3 75
Chi294 Chip Vaughn 24 1/1/2018 6 2 74
Jon295 Jonathan Vilma 27 1/1/2019 6 1 73
Reg296 Reggie Walker 23 1/1/2023 6 0 72
Mat297 Matt Ware 27 1/1/2022 6 2 74
Kur298 Kurt Warner 38 1/1/2020 6 2 74
Ant299 Anthony Waters 25 1/1/2007 6 3 75
Gab300 Gabe Watson 26 1/1/2008 6 4 76
Bea301 Beanie Wells 21 1/1/2005 6 1 73
Reg302 Reggie Wells 29 1/1/2006 6 4 76
Adr303 Adrian Wilson 30 1/1/2010 6 3 75
D'J304 D'Juan Woods 25 1/1/2018 6 1 73
Jas305 Jason Wright 27 1/1/2019 5 10 70
Usa306 Usama Young 24 1/1/2023 6 0 72
Department
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
Accounting
IT
Sales
Programs
Marketing
Management
 DATAKLIQ
Instructions
Scenario The HR-Team needs your help populating the table
Task use Lookup functions and logical functions where appropriate to populate the table
New Salary Add 35% increase to the Salary of employee's who have stayed in the firm for more than 8 years
Check Ensure Smiley shows to showcase you have completed the task
Activity Status If task is completed you should have a Code generated

Activity

### L J J
Code Contract Date Contract_Age Salary New Salary Name Age
A.J49 1/1/2007 16 642,689.00 867,630.15 A.J. Green 34
Aar18 1/1/2020 3 687,898.00 687,898.00 Aaron Brewer 32
Abr138 1/1/2020 3 370,461.00 370,461.00 Abram Smith 23
Ada125 1/1/2019 4 400,392.00 400,392.00 Adam Prentice 25
Ada150 1/1/2008 15 467,925.00 631,698.75 Adam Trautma 25
Adr303 1/1/2010 13 389,113.00 525,302.55 Adrian Wilson 30
Ala190 1/1/2008 15 475,323.00 641,686.05 Alan Branch 25
And120 1/1/2008 15 439,123.00 592,816.05 Andrus Peat 28
And29 1/1/2007 16 642,731.00 867,686.85 Andy Dalton 34
And35 1/1/2019 4 574,925.00 574,925.00 Andrew Dowel 25
And68 1/1/2020 3 574,296.00 574,296.00 Andy Isabella 25
And7 1/1/2022 1 631,456.00 631,456.00 Andre Baccell 25
And91 1/1/2005 18 378,337.00 510,754.95 Andy Lee 40
Anq189 1/1/2007 16 464,144.00 626,594.40 Anquan Boldin 29
Ant164 1/1/2018 5 399,836.00 399,836.00 Antoine Wesle 24
Ant176 1/1/2023 0 686,880.00 686,880.00 Antwaun Woo 29
Ant185 1/1/2019 4 616,621.00 616,621.00 Anthony Becht 32
Ant234 1/1/2018 5 444,706.00 444,706.00 Anthony Hargr 26
Ant276 1/1/2023 0 574,082.00 574,082.00 Antrel Rolle 27
Ant299 1/1/2007 16 458,488.00 618,958.80 Anthony Water 25
Ant52 1/1/2006 17 324,111.00 437,549.85 Antonio Hamil 29
Bea301 1/1/2005 18 377,577.00 509,728.95 Beanie Wells 21
Ben113 1/1/2010 13 442,657.00 597,586.95 Ben Niemann 27
Ben208 1/1/2020 3 503,148.00 503,148.00 Ben Claxton 29
Ben228 1/1/2020 3 662,436.00 662,436.00 Ben Graham 36
Ben267 1/1/2022 1 324,330.00 324,330.00 Ben Patrick 25
Ber135 1/1/2019 4 310,180.00 310,180.00 Bernhard Seiko 25
Ber188 1/1/2020 3 359,310.00 359,310.00 Bertrand Berry 34
Bil259 1/1/2007 16 635,630.00 858,100.50 Billy Miller 32
Bla44 1/1/2018 5 363,728.00 363,728.00 Blake Gillikin 24
Bob256 1/1/2023 0 323,150.00 323,150.00 Bobby McCray 28
Bra132 1/1/2006 17 517,905.00 699,171.75 Bradley Roby 30
Bra247 1/1/2022 1 612,359.00 612,359.00 Brandon Keith 25
Bre17 1/1/2022 1 517,525.00 517,525.00 Breon Borders 27
Bri285 1/1/2019 4 588,007.00 588,007.00 Brian St. Pierr 30
Bry146 1/1/2023 0 378,523.00 378,523.00 Bryce Thomps 22
Bry257 1/1/2022 1 433,581.00 433,581.00 Bryant McFad 28
Bry273 1/1/2010 13 519,076.00 700,752.60 Bryan Robinso 35
Bud8 1/1/2020 3 620,706.00 620,706.00 Budda Baker 26
Byr109 1/1/2007 16 501,099.00 676,483.65 Byron Murphy 24
C.J43 1/1/2010 13 529,749.00 715,161.15 C.J. Gardner- 24
Cal149 1/1/2007 16 417,578.00 563,730.30 Calvin Throck 25
Cal202 1/1/2006 17 483,847.00 653,193.45 Calais Campbe 23
Cam144 1/1/2018 5 377,792.00 377,792.00 Cameron Tho 22
Cam78 1/1/2020 3 414,407.00 414,407.00 Cameron Jord 33
Car265 1/1/2019 4 411,034.00 411,034.00 Carl Nicks 24
Car46 1/1/2023 0 536,082.00 536,082.00 Carl Granders 25
Ces133 1/1/2010 13 563,401.00 760,591.35 Cesar Ruiz 23
Cha159 1/1/2007 16 658,982.00 889,625.70 Charles Washi 29
Cha177 1/1/2022 1 548,442.00 548,442.00 Chandler Woo 23
Cha210 1/1/2008 15 509,054.00 687,222.90 Chase Daniel 23
Cha229 1/1/2007 16 413,864.00 558,716.40 Charles Grant 31
Chi266 1/1/2023 0 669,909.00 669,909.00 Chike Okeafor 33
Chi294 1/1/2018 5 428,489.00 428,489.00 Chip Vaughn 24
Chr100 1/1/2008 15 547,258.00 738,798.30 Christian Mat 25
Chr114 1/1/2018 5 617,203.00 617,203.00 Chris Olave 22
Chr122 1/1/2006 17 477,959.00 645,244.65 Chris Pierce Jr 23
Chr129 1/1/2007 16 614,138.00 829,086.30 Christian Ring 30
Chr272 1/1/2006 17 488,800.00 659,880.00 Chris Reis 26
Chr58 1/1/2020 3 328,005.00 328,005.00 Chris Herndon 26
Cla232 1/1/2006 17 413,894.00 558,756.90 Clark Haggans 33
Cod195 1/1/2019 4 452,747.00 452,747.00 Cody Brown 23
Col103 1/1/2010 13 688,139.00 928,987.65 Colt McCoy 35
Cou274 1/1/2018 5 494,227.00 494,227.00 Courtney Roby 27
D.J64 1/1/2018 5 627,979.00 627,979.00 D.J. Humphrie 28
Dai32 1/1/2006 17 545,168.00 735,976.80 Dai'Jean Dixo 23
DaM40 1/1/2008 15 640,637.00 864,859.95 DaMarcus Fiel 24
Dan141 1/1/2005 18 384,184.00 518,648.40 Daniel Sorens 32
Dan203 1/1/2010 13 674,815.00 911,000.25 Dan Campbell 33
Dan248 1/1/2020 3 371,099.00 371,099.00 Dan Kreider 32
Dan69 1/1/2007 16 686,343.00 926,563.05 Danny Isidora 28
Dar10 1/1/2008 15 441,909.00 596,577.15 Darrell Baker J 24
Dar168 1/1/2020 3 374,025.00 374,025.00 Darrel Willia 27
Dar213 1/1/2010 13 519,895.00 701,858.25 Darnell Dinkin 32
Dar214 1/1/2018 5 427,012.00 427,012.00 Darnell Docket 28
Dar279 1/1/2007 16 306,640.00 413,964.00 Darren Sharper 34
Dav115 1/1/2019 4 522,784.00 522,784.00 David Onyema 29
Dav289 1/1/2007 16 684,113.00 923,552.55 David Thomas 26
DeA61 1/1/2005 18 367,786.00 496,511.10 DeAndre Hopk 30
Dei147 1/1/2022 1 315,647.00 315,647.00 Deionte Thom 25
DeM269 1/1/2007 16 472,230.00 637,510.50 DeMario Press 24
Dem30 1/1/2008 15 519,390.00 701,176.50 Demario Davi 33
Den42 1/1/2006 17 397,698.00 536,892.30 Dennis Gardec 28
Deo178 1/1/2020 3 357,638.00 357,638.00 Deon Yelder 27
Deo54 1/1/2018 5 602,892.00 602,892.00 Deonte Harty 24
Deu253 1/1/2010 13 687,473.00 928,088.55 Deuce Lutui 26
Deu255 1/1/2019 4 365,567.00 365,567.00 Deuce McAllis 31
Dev116 1/1/2023 0 483,115.00 483,115.00 Devine Ozigb 25
Dev239 1/1/2007 16 566,987.00 765,432.45 Devery Hender 27
Dev81 1/1/2005 18 356,261.00 480,952.35 Devon Kennar 31
D'J304 1/1/2018 5 437,511.00 437,511.00 D'Juan Woods 25
D'M70 1/1/2008 15 473,338.00 639,006.30 D'Marco Jacks 24
Dom275 1/1/2019 4 624,859.00 624,859.00 Dominique Rod 23
Dre192 1/1/2006 17 323,235.00 436,367.25 Drew Brees 31
Dwa160 1/1/2008 15 597,296.00 806,349.60 Dwayne Washi 28
Dyl96 1/1/2023 0 305,292.00 305,292.00 Dylan Mabin 24
Ear215 1/1/2019 4 653,508.00 653,508.00 Early Doucet 24
Eas174 1/1/2018 5 342,943.00 342,943.00 Easop Winston 25
Eno13 1/1/2010 13 464,795.00 627,473.25 Eno Benjamin 23
Eri104 1/1/2018 5 557,470.00 557,470.00 Erik McCoy 24
Eri171 1/1/2005 18 545,446.00 736,352.10 Eric Wilson 27
Eth50 1/1/2008 15 624,131.00 842,576.85 Ethan Greenid 24
Eze151 1/1/2005 18 670,340.00 904,959.00 Ezekiel Turner 26
For86 1/1/2023 0 359,839.00 359,839.00 Forrest Lamp 28
Gab300 1/1/2008 15 438,264.00 591,656.40 Gabe Watson 26
Gar237 1/1/2022 1 502,727.00 502,727.00 Garrett Hartley 23
Ger238 1/1/2020 3 311,121.00 311,121.00 Gerald Hayes 29
Gre291 1/1/2005 18 516,920.00 697,842.00 Greg Toler 25
Gre34 1/1/2018 5 386,615.00 386,615.00 Greg Dortch 24
Gre93 1/1/2010 13 321,585.00 434,139.75 Greg Long 25
Hag112 1/1/2006 17 658,363.00 888,790.05 Haggai Ndubui 21
Ham180 1/1/2008 15 548,056.00 739,875.60 Hamza Abdull 26
Hea219 1/1/2007 16 605,486.00 817,406.10 Heath Evans 31
Her244 1/1/2018 5 403,064.00 403,064.00 Herman Johns 24
Ian16 1/1/2023 0 331,146.00 331,146.00 Ian Book 24
Isa126 1/1/2023 0 677,489.00 677,489.00 Isaiah Pryor 24
Isa137 1/1/2022 1 333,608.00 333,608.00 Isaiah Simmon 24
J.J162 1/1/2006 17 509,566.00 687,914.10 J.J. Watt 33
J.P60 1/1/2008 15 598,226.00 807,605.10 J.P. Holtz 28
J.T47 1/1/2022 1 332,637.00 332,637.00 J.T. Gray 26
Jab231 1/1/2005 18 433,146.00 584,747.10 Jabari Greer 27
Jac166 1/1/2023 0 540,657.00 540,657.00 Jace Whittaker 27
Jah220 1/1/2008 15 337,176.00 455,187.60 Jahri Evans 26
Jal148 1/1/2020 3 693,486.00 693,486.00 Jalen Thomps 24
Jal73 1/1/2010 13 557,076.00 752,052.60 Jaleel Johnson 28
Jam167 1/1/2022 1 601,903.00 601,903.00 James Wiggin 25
Jam173 1/1/2010 13 611,434.00 825,435.90 Jameis Winsto 28
Jam196 1/1/2023 0 361,518.00 361,518.00 Jammal Brown 28
Jam25 1/1/2019 4 584,246.00 584,246.00 James Conner 27
Jam264 1/1/2018 5 301,844.00 301,844.00 Jamar Nesbit 33
Jam65 1/1/2019 4 340,763.00 340,763.00 James Hurst 30
Jar51 1/1/2005 18 340,302.00 459,407.70 Jarrett Guaran 24
Jar87 1/1/2022 1 666,064.00 666,064.00 Jarvis Landry 29
Jas184 1/1/2018 5 428,972.00 428,972.00 Jason Banks 24
Jas305 1/1/2019 4 423,377.00 423,377.00 Jason Wright 27
JaV119 1/1/2007 16 325,073.00 438,848.55 JaVonta Payto 23
Jef205 1/1/2019 4 599,763.00 599,763.00 Jeff Charleston 26
Jer193 1/1/2010 13 548,810.00 740,893.50 Jeremy Bridge 29
Jer201 1/1/2005 18 625,374.00 844,254.90 Jermon Bushro 25
Jer207 1/1/2022 1 538,473.00 538,473.00 Jeremy Clark 26
Jer280 1/1/2008 15 571,021.00 770,878.35 Jeremy Shocke 29
Jer293 1/1/2010 13 588,830.00 794,920.50 Jerheme Urban 29
Jer55 1/1/2019 4 361,973.00 361,973.00 Jerald Hawkin 28
Jes92 1/1/2006 17 552,477.00 745,843.95 Jessie Lemoni 25
Jes94 1/1/2018 5 679,017.00 679,017.00 Jesse Luketa 23
Jo-216 1/1/2023 0 380,869.00 380,869.00 Jo-Lonn Dunba 24
Joe157 1/1/2022 1 671,415.00 671,415.00 Joe Walker 29
Joh117 1/1/2022 1 342,692.00 342,692.00 John Parker R 24
Jon158 1/1/2020 3 474,706.00 474,706.00 Jonathan Ward 24
Jon204 1/1/2018 5 438,800.00 438,800.00 Jonathan Casil 22
Jon227 1/1/2022 1 422,129.00 422,129.00 Jonathan Good 31
Jon287 1/1/2022 1 370,663.00 370,663.00 Jonathan Stin 30
Jon295 1/1/2019 4 680,979.00 680,979.00 Jonathan Vilm 27
Jon83 1/1/2010 13 512,680.00 692,118.00 Jontre Kirklin 23
Jon90 1/1/2008 15 485,677.00 655,663.95 Jonathan Ledbe 24
Jor71 1/1/2005 18 552,571.00 745,970.85 Jordan Jackso 24
Jos107 1/1/2022 1 543,742.00 543,742.00 Joshua Miles 26
Jos14 1/1/2018 5 374,962.00 374,962.00 Josh Black 24
Jos5 1/1/2019 4 473,471.00 473,471.00 Josh Andrews 31
Jos72 1/1/2006 17 648,131.00 874,976.85 Josh Jackson 26
Jos75 1/1/2019 4 580,281.00 580,281.00 Josh Jones 25
Jus110 1/1/2008 15 311,443.00 420,448.05 Justin Murray 29
Jus127 1/1/2022 1 602,763.00 602,763.00 Justin Pugh 31
Jus230 1/1/2008 15 521,355.00 703,829.25 Justin Green 27
Jus39 1/1/2007 16 576,664.00 778,496.40 Justin Evans 26
Juw74 1/1/2018 5 621,066.00 621,066.00 Juwan Johnso 25
Nic250 1/1/2008 15 643,242.00 868,376.70 Nick Leckey 27
Nic98 1/1/2020 3 670,066.00 670,066.00 Nick Martin 29
Nol26 1/1/2023 0 372,893.00 372,893.00 Nolan Cooney 25
P.J170 1/1/2008 15 440,336.00 594,453.60 P.J. Williams 29
Pau1 1/1/2005 18 697,962.00 942,248.70 Paulson Adeb 23
Pau284 1/1/2018 5 578,178.00 578,178.00 Paul Spicer 34
Pay152 1/1/2006 17 470,425.00 635,073.75 Payton Turner 23
Pet163 1/1/2010 13 651,164.00 879,071.40 Pete Werner 23
Pie270 1/1/2008 15 622,732.00 840,688.20 Pierson Priole 32
Pie290 1/1/2008 15 693,004.00 935,555.40 Pierre Thomas 25
Ral198 1/1/2020 3 695,950.00 695,950.00 Ralph Brown 31
Ran226 1/1/2023 0 352,706.00 352,706.00 Randall Gay 27
Ras245 1/1/2019 4 475,821.00 475,821.00 Rashad Johnso 24
Ras27 1/1/2022 1 694,390.00 694,390.00 Rashaad Cowa 27
Ras89 1/1/2007 16 381,740.00 515,349.00 Rashard Lawr 23
Reg200 1/1/2008 15 503,810.00 680,143.50 Reggie Bush 24
Reg246 1/1/2023 0 511,939.00 511,939.00 Reggie Jones 23
Reg296 1/1/2023 0 650,393.00 650,393.00 Reggie Walker 23
Reg302 1/1/2006 17 506,863.00 684,265.05 Reggie Wells 29
Rem183 1/1/2010 13 657,862.00 888,113.70 Remi Ayodele 26
Rob258 1/1/2020 3 643,432.00 643,432.00 Robert Meach 25
Rod235 1/1/2019 4 507,944.00 507,944.00 Rod Harper 24
Rod252 1/1/2006 17 466,870.00 630,274.50 Rodney Leisle 28
Rod62 1/1/2006 17 380,171.00 513,230.85 Rodney Hudso 33
Rom236 1/1/2023 0 353,129.00 353,129.00 Roman Harper 27
Ron108 1/1/2020 3 312,770.00 312,770.00 Rondale Moor 22
Ron130 1/1/2008 15 356,302.00 481,007.70 Ronnie Rivers 23
Rya128 1/1/2020 3 466,680.00 466,680.00 Ryan Ramczy 28
Sag36 1/1/2023 0 391,486.00 391,486.00 Sage Doxtater 23
Sco118 1/1/2020 3 494,326.00 494,326.00 Scott Patchan 25
Sco224 1/1/2018 5 395,071.00 395,071.00 Scott Fujita 30
Sco278 1/1/2020 3 464,992.00 464,992.00 Scott Shanle 30
Sea262 1/1/2006 17 367,888.00 496,648.80 Sean Morey 33
Sea53 1/1/2010 13 687,545.00 928,185.75 Sean Harlow 27
Sed218 1/1/2020 3 508,093.00 508,093.00 Sedrick Ellis 24
Shy153 1/1/2010 13 300,869.00 406,173.15 Shy Tuttle 26
Sta182 1/1/2006 17 371,605.00 501,666.75 Stanley Arnou 23
Ste191 1/1/2005 18 389,305.00 525,561.75 Steve Breaston 26
Ste283 1/1/2010 13 448,215.00 605,090.25 Stephen Spach 27
Ste4 1/1/2018 5 384,141.00 384,141.00 Stephen Ander 29
T.J123 1/1/2010 13 564,453.00 762,011.55 T.J. Pledger 22
Tac23 1/1/2010 13 429,423.00 579,721.05 Taco Charlton 27
Tae28 1/1/2020 3 619,881.00 619,881.00 Tae Daley 23
Tan154 1/1/2018 5 341,442.00 341,442.00 Tanner Vallej 27
Tan84 1/1/2018 5 569,753.00 569,753.00 Tanoh Kpassa 28
Tay59 1/1/2007 16 534,684.00 721,823.40 Taysom Hill 31
Tho263 1/1/2010 13 538,984.00 727,628.40 Thomas Morst 23
Tim240 1/1/2008 15 493,597.00 666,355.95 Tim Hightower 23
Ton77 1/1/2022 1 575,956.00 575,956.00 Tony Jones Jr. 24
Tor241 1/1/2005 18 552,827.00 746,316.45 Tory Humphre 26
Tra105 1/1/2019 4 666,310.00 666,310.00 Trace McSorle 26
Tra268 1/1/2020 3 364,732.00 364,732.00 Tracy Porter 23
Tre102 1/1/2006 17 546,375.00 737,606.25 Trey McBride 22
Tre121 1/1/2005 18 546,097.00 737,230.95 Trevor Pennin 23
Tre140 1/1/2008 15 450,461.00 608,122.35 Tre'Quan Smit 26
Tro221 1/1/2005 18 591,443.00 798,448.05 Troy Evans 32
Tyr99 1/1/2007 16 471,148.00 636,049.80 Tyrann Mathie 30
Usa306 1/1/2023 0 316,437.00 316,437.00 Usama Young 24
Vic15 1/1/2019 4 487,078.00 487,078.00 Victor Bolden 27
Vic31 1/1/2005 18 465,827.00 628,866.45 Victor Dimuke 22
Vin48 1/1/2020 3 566,326.00 566,326.00 Vincent Gray 22
Wil212 1/1/2006 17 603,136.00 814,233.60 Will Davis 23
Wil223 1/1/2010 13 413,394.00 558,081.90 Wilrey Fonteno 25
Wil282 1/1/2006 17 625,031.00 843,791.85 Will Smith 28
Wil57 1/1/2022 1 605,301.00 605,301.00 Will Hernande 26
Wil95 1/1/2019 4 349,947.00 349,947.00 Wil Lutz 28
Zac11 1/1/2005 18 583,531.00 787,766.85 Zack Baun 25
Zac175 1/1/2019 4 375,226.00 375,226.00 Zach Wood 29
Zac2 1/1/2006 17 630,754.00 851,517.90 Zach Allen 24
Zac288 1/1/2020 3 330,769.00 330,769.00 Zach Strief 26
Zac38 1/1/2020 3 588,343.00 588,343.00 Zach Ertz 31
Zav24 1/1/2018 5 518,758.00 518,758.00 Zaven Collins 23
.
 Task Completion Code Err:509

ore than 8 years

1/1/2023

J
Department
Accounting
Management
Management
Marketing
Management
Sales
Programs
Management
Marketing
Marketing
IT
Accounting
Accounting
Sales
IT
IT
Marketing
Management
Management
Marketing
Programs
Accounting
Marketing
Programs
Management
Sales
Sales
IT
Accounting
IT
Programs
Management
Accounting
Marketing
Sales
 IT
Marketing
Sales
IT
Accounting
Accounting
Marketing
Programs
Management
Management
Accounting
Programs
Accounting
Sales
Sales
Management
Accounting
IT
Management
Programs
Management
IT
Sales
IT
Programs
Programs
Sales
Accounting
Programs
Programs
IT
Programs
Sales
Marketing
IT
Sales
Programs
Management
Sales
Programs
Sales
Accounting
Accounting
Accounting
Sales
Marketing
Management
Management
Programs
Management
Accounting
Sales
IT
 Marketing
Sales
Programs
Programs
Marketing
Management
Programs
Management
Marketing
Management
Accounting
IT
Sales
IT
Accounting
IT
Management
Sales
Programs
Sales
Programs
Sales
Programs
Management
Sales
Programs
Programs
Management
Marketing
Management
Management
Marketing
Sales
Programs
Programs
Programs
Accounting
Marketing
Marketing
Programs
Accounting
Management
Marketing
Sales
Sales
Programs
Marketing
Marketing
Accounting
Accounting
Sales
Sales
Programs
 Marketing
Accounting
IT
Programs
Management
Accounting
Sales
IT
Management
Marketing
Marketing
Accounting
Marketing
Management
Marketing
Marketing
IT
Marketing
Management
Sales
IT
Accounting
IT
Sales
IT
Programs
IT
IT
IT
Accounting
IT
IT
Accounting
Management
IT
Management
Programs
Marketing
Sales
Marketing
IT
Management
IT
IT
Sales
Management
Accounting
Management
IT
IT
Management
Programs
IT
Management
Programs
IT
IT
Programs
Marketing
IT
Sales
IT
Marketing
Accounting
Programs
Sales
Marketing
Programs
Programs
Management
Marketing
Marketing
Management
Marketing
Accounting
Sales
Programs
Management
Accounting
IT
Marketing
Sales
Management
Sales
Accounting
Management
IT
Accounting
Management
Sales
Marketing
Marketing
Accounting
IT
Management
IT
Management