I need help with this excel assignment that is consisted of VLOOKUP and Pivot Table

Instructions: Using a v-lookup formula, populate column F to indicate the corresponding district f each vehicle. See the reference tab for a list of sites and districts. Unit # Site Location Truck Type Manufacture Year 100515 Oklahoma East Hauling ASL - Diesel 2003 100517 Oklahoma East Hauling ASL - Diesel 2003 100522 Oklahoma East Hauling MSL - Diesel 2003 100527 Oklahoma South Hauling ASL - Diesel 2006 100528 Oklahoma South Hauling ASL - Diesel 2006 100529 Oklahoma South Hauling ASL - Diesel 2007 100534 Oklahoma South Hauling ASL - Diesel 2006 100535 Oklahoma South Hauling ASL - Diesel 2007 100536.1 Oklahoma East Hauling ASL - Diesel 2007 100545 Rolling Meadows Hauling ASL - Diesel 2007 100546 Oklahoma East Hauling ASL - Diesel 2007 100547 Oklahoma City Hauling ASL - Diesel 2011 100548 Ada Hauling ASL - Diesel 2011 100549 South Arkansas Hauling ASL - Diesel 2011 100550 South Arkansas Hauling ASL - Diesel 2011 100551 Rolling Meadows Hauling ASL - Diesel 2011 100552 Oklahoma City Hauling ASL - Diesel 2011 100553 Rolling Meadows Hauling ASL - Diesel 2011 100554 Oklahoma South Hauling ASL - Diesel 2011 100560 South Arkansas Hauling ASL - Diesel 2012 100561 Ada Hauling ASL - Diesel 2012 100562 South Arkansas Hauling ASL - Diesel 2012 101113 Oklahoma South Hauling ASL - Diesel 2010 101114 Oklahoma South Hauling ASL - Diesel 2010 101115 Oklahoma East Hauling ASL - Diesel 2010 101116 Oklahoma South Hauling ASL - Diesel 2010 101117 Transit Hauling ASL - Diesel 2010 101118 Ada Hauling ASL - Diesel 2010 101119 Oklahoma East Hauling ASL - Diesel 2010 101120 Oklahoma East Hauling ASL - Diesel 2009 101121 Oklahoma South Hauling ASL - Diesel 2011 101122 Oklahoma South Hauling ASL - Diesel 2011 101123 Oklahoma City Hauling ASL - Diesel 2011 101124 Oklahoma East Hauling ASL - Diesel 2012 101125 Transit Hauling ASL - Diesel 2012 101129 Springfield Hauling ASL - Diesel 2003 101130 Springfield Hauling ASL - Diesel 2003 101131 Springfield Hauling ASL - Diesel 2003 101132 Springfield Hauling REL - Diesel 2004 101133 Springfield Hauling REL - Diesel 2004 101136 Bay City Hauling ASL - Diesel 2010 101137 Bay City Hauling ASL - Diesel 2010 101138 Bay City Hauling ASL - Diesel 2010 101140 Bay City Hauling ASL - Diesel 2010 101141 Bay City Hauling ASL - Diesel 2008 101220 Kansas City Hauling ASL - Diesel 2007 101221 Kansas City Hauling ASL - Diesel 2002 101222 Kansas City Hauling ASL - Diesel 2002 101223 Kansas City Hauling ASL - Diesel 2009 101224 Kansas City Hauling ASL - Diesel 2007 101225 Kansas City Hauling ASL - Diesel 2011 101226 Kansas City Hauling ASL - Diesel 2011 101227 Kansas City Hauling Split Body - Diesel 2008 101228 Kansas City Hauling Split Body - Diesel 2010 101229 Kansas City Hauling Split Body - Diesel 2007 101230 Kansas City Hauling ASL - Diesel 2012 101231 Kansas City Hauling ASL - Diesel 2012 101232 Kansas City Hauling ASL - Diesel 2011 101233 Kansas City Hauling ASL - Diesel 2011 101234 Transit Hauling MSL - Diesel 2011 101235 Kansas City Hauling ASL - Diesel 2015 101236 Kansas City Hauling Split Body - Diesel 2016 101237 Kansas City Hauling Split Body - Diesel 2016 101238 Kansas City Hauling ASL - Diesel 2015 101239 Kansas City Hauling ASL - Diesel 2012 101240 Kansas City Hauling ASL - Diesel 2012 101241 Kansas City Hauling Split Body - Diesel 2009 101242 Kansas City Hauling Split Body - Diesel 2010 101243 Kansas City Hauling Split Body - Diesel 2010 101244 Kansas City Hauling Split Body - Diesel 2010 101245 Kansas City Hauling Split Body - Diesel 2010 101246 Kansas City Hauling Split Body - Diesel 2010 101247 Kansas City Hauling Split Body - Diesel 2010 101248 Kansas City Hauling Split Body - Diesel 2010 101250 Kansas City Hauling Split Body - Diesel 2010 101251 Kansas City Hauling Split Body - Diesel 2005 101252 Kansas City Hauling Split Body - Diesel 2012 101253 Kansas City Hauling ASL - Diesel 2010 101254 Kansas City Hauling ASL - Diesel 2014 101255 Kansas City Hauling ASL - Diesel 2012 101256 Kansas City Hauling ASL - Diesel 2014 101257 Kansas City Hauling ASL - Diesel 2015 202101 Springfield Hauling FEL - Diesel 2003 205200 Springfield Hauling AFL - Diesel 2001 205201 Springfield Hauling FEL - Diesel 2001 205202 Springfield Hauling FEL - Diesel 2002 205206.1 Springfield Hauling FEL - Diesel 2004 205207 Joplin Hauling FEL - Diesel 2007 205208 Springfield Hauling FEL - Diesel 2005 205210 Springfield Hauling FEL - Diesel 2008 205211 Joplin Hauling FEL - Diesel 2008 205212 Springfield Hauling FEL - Diesel 2011 205213 Oklahoma City Hauling FEL - Diesel 2011 205214 Little Rock Hauling FEL - Diesel 2012 205215 Little Rock Hauling FEL - Diesel 2012 205216 Orange City Hauling FEL - Diesel 2011 205217 Orange City Hauling FEL - Diesel 2011 205218 Rolling Meadows Hauling FEL - Diesel 2012 205219 Oklahoma South Hauling FEL - Diesel 2012 205220 Oklahoma City Hauling FEL - Diesel 2011 205221 Orange City Hauling FEL - Diesel 2013 205240 Houston East Hauling REC - Diesel 2002 205242.1 Springfield Hauling FEL - Diesel 2013 260100 FEL - Diesel 2006 AFL - Diesel 2007 Joplin Hauling 260101.1 Springfield Hauling 260102 Joplin Hauling FEL - Diesel 2007 260121 Little Rock Hauling FEL - Diesel 2003 260122.1 Transit Hauling FEL - Diesel 2002 260124 Transit Hauling FEL - Diesel 2004 260125 Oklahoma City Hauling FEL - Diesel 2004 260127.1 Little Rock Hauling FEL - Diesel 2005 260132 Transit Hauling FEL - Diesel 2007 260135 Central Missouri Hauling FEL - Diesel 2008 260137 Houston North Hauling FEL - Diesel 2008 260139 Houston South Hauling FEL - Diesel 2008 260140 Houston South Hauling FEL - Diesel 2008 260142 Houston North Hauling FEL - Diesel 2009 260149 Houston South Hauling FEL - Diesel 2008 260150.2 Houston North Hauling FEL - Diesel 2010 260152 Little Rock Hauling FEL - Diesel 2010 260153 Houston East Hauling REC - Diesel 2010 260154 Oklahoma South Hauling FEL - Diesel 2010 260155 Little Rock Hauling FEL - Diesel 2011 260156 Oklahoma East Hauling FEL - Diesel 2011 260157 Oklahoma East Hauling FEL - Diesel 2011 260158 Houston North Hauling FEL - Diesel 2011 260164 Houston North Hauling FEL - Diesel 2004 260165 Houston North Hauling FEL - Diesel 2004 260166 Bay City Hauling FEL - Diesel 2005 260167 Houston East Hauling FEL - Diesel 2009 260169 Houston South Hauling FEL - Diesel 2010 260170 Houston South Hauling FEL - Diesel 2010 260171 Central Missouri Hauling FEL - Diesel 2011 260172 Houston East Hauling FEL - Diesel 2011 260173 Houston North Hauling FEL - Diesel 2011 260174 Houston North Hauling FEL - Diesel 2011 260175 Houston East Hauling FEL - Diesel 2011 260184 Houston South Hauling FEL - Diesel 2006 260185 Transit Hauling FEL - Diesel 2007 260186 Joplin Hauling FEL - Diesel 2007 260192 Orange City Hauling FEL - Diesel 2005 260196.1 Rolling Meadows Hauling FEL - Diesel 2011 260197 FEL - Diesel 2012 Oklahoma City Hauling 260198 Ada Hauling FEL - Diesel 2012 260199 Joplin Hauling FEL - Diesel 2013 260200 Springfield Hauling AFL - Diesel 2013 260201 Orange City Hauling AFL - Diesel 2013 260202 Joplin Hauling FEL - Diesel 2013 260203 Springfield Hauling AFL - Diesel 2013 260204.1 Springfield Hauling AFL - Diesel 2013 260205.1 Springfield Hauling AFL - Diesel 2013 260206.1 Little Rock Hauling FEL - Diesel 2011 260212.1 Houston East Hauling FEL - Diesel 2013 260213 Bay City Hauling FEL - Diesel 2010 260233 Houston East Hauling FEL - Diesel 2014 260240 Joplin Hauling FEL - Diesel 2014 260241 Springfield Hauling AFL - Diesel 2014 260242 Oklahoma City Hauling FEL - Diesel 2014 260245 Rolling Meadows Hauling FEL - Diesel 2014 260247 Orange City Hauling FEL - Diesel 2014 260248 Transit Hauling AFL - Diesel 2014 260249 Transit Hauling AFL - Diesel 2014 260250 Transit Hauling AFL - Diesel 2014 260251 Springfield Hauling AFL - Diesel 2014 260252 Joplin Hauling FEL - Diesel 2014 260253 Ozarks Hauling FEL - Diesel 2014 260254 Ozarks Hauling FEL - Diesel 2014 260255 Bay City Hauling FEL - Diesel 2010 260258 Oklahoma City Hauling FEL - Diesel 2001 260259 Oklahoma City Hauling REC - Diesel 1999 260283 Little Rock Hauling FEL - Diesel 2014 260310 Kansas City Hauling FEL - Diesel 2003 260311 Kansas City Hauling FEL - Diesel 2011 260312 Kansas City Hauling FEL - Diesel 2011 260313 Kansas City Hauling FEL - Diesel 2013 260314 Kansas City Hauling FEL - Diesel 2013 260315 Kansas City Hauling FEL - Diesel 2015 260316 Kansas City Hauling FEL - Diesel 2013 260317 Kansas City Hauling FEL - Diesel 2013 260318 Kansas City Hauling FEL - Diesel 1999 260319 Transit Hauling FEL - Diesel 2001 260320 Kansas City Hauling FEL - Diesel 2009 260321 Kansas City Hauling FEL - Diesel 2016 260322 Rolling Meadows Hauling FEL - Diesel 2017 260323 Kansas City Hauling FEL - Diesel 2017 260324 Kansas City Hauling FEL - Diesel 2017 260325 Kansas City Hauling AFL - Diesel 2017 260326 Kansas City Hauling AFL - Diesel 2017 260327 Oklahoma City Hauling FEL - Diesel 2017 260328 Houston East Hauling FEL - Diesel 2017 260331 Joplin Hauling FEL - Diesel 2017 260332 Springfield Hauling FEL - Diesel 2017 260333 Springfield Hauling FEL - Diesel 2017 301533.1 Springfield Hauling REL - Diesel 1996 301541 Oklahoma South Hauling REC - Diesel 2004 301542 Ada Hauling REC - Diesel 2005 302022.1 Joplin Hauling REL - Diesel 2005 302023.1 Joplin Hauling REL - Diesel 2005 302024 REL - Diesel 2005 302025.1 Rolla Hauling REL - Diesel 2005 302027 Ozarks Hauling REL - Diesel 2003 302029 Ozarks Hauling REL - Diesel 2003 302030 Wilco Hauling REL - Diesel 2004 305151 Ozarks Hauling REL - Diesel 2000 305152 Wilco Hauling REL - Diesel 2009 305153.1 Rolla Hauling REL - Diesel 2009 305154 Chillicothe Hauling REL - Diesel 2011 305155 Chillicothe Hauling REL - Diesel 2011 305158 Wilco Hauling REL - Diesel 2011 305159 Joplin Hauling REL - Diesel 2004 305160 Ozarks Hauling REL - Diesel 2013 305161 Houston South Hauling REL - Diesel 2013 305162 Joplin Hauling REL - Diesel 2005 305163 Houston South Hauling REL - Diesel 2013 305164 Houston South Hauling REL - Diesel 2013 305165 Houston South Hauling REL - Diesel 2013 305166 Houston South Hauling REL - Diesel 2013 305167 Ozarks Hauling REL - Diesel 2011 305168 Ozarks Hauling REL - Diesel 2007 Joplin Hauling 305169 Ozarks Hauling REL - Diesel 2008 305170 Ozarks Hauling REL - Diesel 2007 305171 Ozarks Hauling REL - Diesel 2002 310005.1 Rolla Hauling REL - Diesel 2003 310008 Springfield Hauling REL - Diesel 2008 310009 Springfield Hauling REL - Diesel 2008 310014 Joplin Hauling REL - Diesel 2003 351583 Houston South Hauling REL - Diesel 1993 361297 Springfield Hauling REL - Diesel 1999 361303 Central Missouri Hauling REL - Diesel 2003 361304 Ozarks Hauling REL - Diesel 2003 361305 Joplin Hauling REL - Diesel 2002 361306 Wilco Hauling REL - Diesel 2005 361307 Wilco Hauling REL - Diesel 2005 361308 Joplin Hauling REL - Diesel 2005 361309.1 Rolla Hauling REL - Diesel 2005 361312 Wilco Hauling REL - Diesel 2006 361313 Central Missouri Hauling REL - Diesel 2007 361314 Central Missouri Hauling REL - Diesel 2007 361315.1 Springfield Hauling REL - Diesel 2007 361316.1 Springfield Hauling REL - Diesel 2007 361317 Wilco Hauling REL - Diesel 2007 361318 Springfield Hauling REL - Diesel 2007 361319 Wilco Hauling REL - Diesel 2007 361320 Central Missouri Hauling REL - Diesel 2007 361321 Springfield Hauling REL - Diesel 2007 361322 Joplin Hauling REL - Diesel 2007 361323 Wilco Hauling REL - Diesel 2007 361324 Ozarks Hauling REL - Diesel 2007 361325 Rolla Hauling REL - Diesel 2007 361326 Wilco Hauling REL - Diesel 2007 361327 Central Missouri Hauling REL - Diesel 2007 361339 Rolla Hauling REL - Diesel 2002 361350 Springfield Hauling REL - Diesel 2005 361351 Springfield Hauling REL - Diesel 2005 361352 Chillicothe Hauling REL - Diesel 2005 361354 Houston North Hauling REL - Diesel 2005 361355 Houston North Hauling REL - Diesel 2005 361356 Houston North Hauling REL - Diesel 2005 361358 Houston North Hauling REL - Diesel 2005 361359 Houston South Hauling REL - Diesel 2005 361360 Oklahoma South Hauling REC - Diesel 2005 361365 Houston North Hauling REL - Diesel 2005 361366 Houston South Hauling REL - Diesel 2006 361368 Houston South Hauling REL - Diesel 2006 361369 Houston South Hauling REL - Diesel 2007 361370 Houston South Hauling REL - Diesel 2007 361372 Houston North Hauling REL - Diesel 2007 361373 Houston North Hauling REL - Diesel 2007 361374 Houston South Hauling REL - Diesel 2007 361375 Houston North Hauling REL - Diesel 2007 361376 Houston South Hauling REL - Diesel 2007 361377 Houston North Hauling REL - Diesel 2007 361378 Houston South Hauling REL - Diesel 2007 361379 Houston South Hauling REL - Diesel 2007 361380 Houston South Hauling REL - Diesel 2007 361381 Houston South Hauling REL - Diesel 2007 361382 Rolla Hauling REL - Diesel 2007 361383 Houston South Hauling REL - Diesel 2007 361384 Houston South Hauling REL - Diesel 2007 361385 Houston South Hauling REL - Diesel 2007 361386 Houston South Hauling REL - Diesel 2007 361387 Houston South Hauling REL - Diesel 2007 361388 Houston South Hauling REL - Diesel 2007 361389 Rolla Hauling REL - Diesel 2007 361390 Oklahoma East Hauling REL - Diesel 2007 361391 Houston South Hauling REL - Diesel 2007 361392 Houston South Hauling REL - Diesel 2007 361393 Houston South Hauling REL - Diesel 2007 361394 Houston South Hauling REL - Diesel 2007 361395 Houston South Hauling REL - Diesel 2007 361396 Houston South Hauling REL - Diesel 2007 361397 Houston South Hauling REL - Diesel 2007 361398 Houston South Hauling REL - Diesel 2007 361399 Houston South Hauling REL - Diesel 2007 361400 Houston South Hauling REL - Diesel 2007 361401 Houston South Hauling REL - Diesel 2007 361402 Houston South Hauling REL - Diesel 2007 361403 Houston South Hauling REL - Diesel 2007 361404 Houston South Hauling REL - Diesel 2007 361405 Houston North Hauling REL - Diesel 2007 361406 Houston South Hauling REL - Diesel 2007 361407 Houston North Hauling REL - Diesel 2008 361408 Houston South Hauling REL - Diesel 2008 361409 Houston North Hauling REL - Diesel 2008 361410 Houston North Hauling REL - Diesel 2008 361411 Houston North Hauling REL - Diesel 2008 361412 Houston South Hauling REL - Diesel 2008 361413 Houston North Hauling REL - Diesel 2008 361415 Joplin Hauling REL - Diesel 2008 361416 Chillicothe Hauling REL - Diesel 2009 361417 Chillicothe Hauling REL - Diesel 2009 361418 Ozarks Hauling REL - Diesel 2009 361419 Rolla Hauling REL - Diesel 2009 361420 Houston South Hauling REL - Diesel 2008 361421 Chillicothe Hauling REL - Diesel 2008 361422.1 Houston North Hauling REL - Diesel 2008 361423 Houston South Hauling REL - Diesel 2008 361424 Houston South Hauling REL - Diesel 2008 361425 Houston South Hauling REL - Diesel 2008 361426 Houston South Hauling REL - Diesel 2008 361427 Houston South Hauling REL - Diesel 2008 361428 Houston South Hauling REL - Diesel 2008 361434 Houston South Hauling REL - Diesel 2009 361435 Houston South Hauling REL - Diesel 2009 361436 Houston South Hauling REL - Diesel 2009 361437 Houston South Hauling REL - Diesel 2009 361438 Houston South Hauling REL - Diesel 2009 361439 Houston South Hauling REL - Diesel 2009 361440 Houston North Hauling REL - Diesel 2009 361441 Houston South Hauling REL - Diesel 2010 361443 South Arkansas Hauling REL - Diesel 2011 361444 South Arkansas Hauling REL - Diesel 2005 361455 Rolla Hauling REL - Diesel 2002 361457 Houston North Hauling REL - Diesel 2007 361458 Houston North Hauling REL - Diesel 2007 361459 Houston North Hauling REL - Diesel 2007 361460 Joplin Hauling REL - Diesel 2011 361461 Rolla Hauling REL - Diesel 2011 361462 Wilco Hauling REL - Diesel 2011 361463 South Arkansas Hauling REL - Diesel 2008 361464 Wilco Hauling REL - Diesel 2011 361465 South Arkansas Hauling REC - Diesel 2007 361472 Orange City Hauling REL - Diesel 2005 361474 Orange City Hauling REL - Diesel 2005 361476 Orange City Hauling REL - Diesel 2005 361483 Lake County Hauling REL - Diesel 2003 361485 Gainesville Hauling REL - Diesel 2002 361486 Central Missouri Hauling REL - Diesel 2004 361490 Chillicothe Hauling REL - Diesel 2009 361492 Joplin Hauling REL - Diesel 2010 361493 Gainesville Hauling GRAP - Diesel 2009 361494 Ozarks Hauling REL - Diesel 2009 361495 Chillicothe Hauling REL - Diesel 2009 361496 Rolla Hauling REL - Diesel 2009 361497 Rolla Hauling REL - Diesel 2009 361498 Ozarks Hauling REL - Diesel 2009 361499 Ozarks Hauling REL - Diesel 2009 361500 Joplin Hauling REL - Diesel 2009 361501 Gainesville Hauling REL - Diesel 2009 361502 Gainesville Hauling REL - Diesel 2009 361503 Lake County Hauling REL - Diesel 2010 361504 Gainesville Hauling REL - Diesel 2008 361519 Gainesville Hauling GRAP - Diesel 2001 361520 Orange City Hauling GRAP - Diesel 2002 361523 Gainesville Hauling REL - Diesel 2005 361524 Lake County Hauling REL - Diesel 2005 361525 Orange City Hauling REL - Diesel 2005 361527 Orange City Hauling REL - Diesel 2002 361528 Orange City Hauling REL - Diesel 2002 361545 Central Missouri Hauling REL - Diesel 2012 361547 Central Missouri Hauling REL - Diesel 2004 361553 Houston South Hauling REL - Diesel 2007 361554 Houston North Hauling REL - Diesel 2006 361556 Houston South Hauling REL - Diesel 2009 361581 Sarasota Hauling GRAP - Diesel 2004 361582 Houston South Hauling REL - Diesel 1993 361584 Houston South Hauling REL - Diesel 1994 361586 Houston North Hauling REL - Diesel 2007 361587 Bay City Hauling REL - Diesel 2008 361588 Houston South Hauling REL - Diesel 2008 361591 Bay City Hauling REL - Diesel 2009 361592 Bay City Hauling REL - Diesel 2009 361593 Houston North Hauling REL - Diesel 2010 361594 Houston North Hauling REL - Diesel 2010 361595 Houston North Hauling REL - Diesel 2010 361597 Houston North Hauling REL - Diesel 2011 361599 Houston South Hauling REL - Diesel 2015 361600 Houston South Hauling REL - Diesel 2015 361601 Houston North Hauling REL - Diesel 2015 361602 Houston North Hauling REL - Diesel 2014 361603 Houston North Hauling REL - Diesel 2015 361604 Houston North Hauling REL - Diesel 2015 361605 Houston North Hauling REL - Diesel 2015 361606 Houston North Hauling REL - Diesel 2015 361607 Houston North Hauling REL - Diesel 2016 361608 Houston North Hauling REL - Diesel 2015 361609 Houston South Hauling REL - Diesel 1997 361610 Houston Residential Valet REL - Diesel 1999 361611 Houston Residential Valet REL - Diesel 1999 361612 Houston Residential Valet REL - Diesel 2001 361613 Houston Residential Valet REL - Diesel 2003 361614 Houston Residential Valet REL - Diesel 2006 361615 Houston Residential Valet REL - Diesel 2007 361616 Houston Residential Valet REL - Diesel 2007 361617 Houston Residential Valet REL - Diesel 2007 361618 Houston Residential Valet REL - Diesel 2007 361619 Houston Residential Valet REL - Diesel 2007 361620 Houston Residential Valet REL - Diesel 2009 361621 Houston Residential Valet REL - Diesel 2010 361622 Houston Residential Valet REL - Diesel 2012 361623 Houston Residential Valet REL - Diesel 2013 361624 Houston Residential Valet REL - Diesel 2014 361625 Houston Residential Valet REL - Diesel 2012 361626 Houston Residential Valet REL - Diesel 2013 361627 Houston South Hauling REL - Diesel 2016 361628 Houston South Hauling REL - Diesel 2016 361629 Houston South Hauling REL - Diesel 2016 361632 Kansas City Hauling REL - Diesel 2008 361633 Kansas City Hauling REL - Diesel 2007 361635 Kansas City Hauling REL - Diesel 2013 361636 Kansas City Hauling REL - Diesel 2013 361637 Kansas City Hauling REL - Diesel 2011 361638 Kansas City Hauling ASL - Diesel 2015 361639 Kansas City Hauling REL - Diesel 2003 361640 Kansas City Hauling REL - Diesel 2005 361641 Kansas City Hauling REL - Diesel 2006 361642 Kansas City Hauling REL - Diesel 2007 361643 Kansas City Hauling REL - Diesel 2007 361644 Kansas City Hauling REL - Diesel 2007 361645 Kansas City Hauling REL - Diesel 2008 361646 Kansas City Hauling REL - Diesel 2009 361647 Kansas City Hauling REL - Diesel 2010 361648 Kansas City Hauling REL - Diesel 2011 361649 Kansas City Hauling REL - Diesel 2011 361650 Kansas City Hauling REL - Diesel 2010 361651 Kansas City Hauling REL - Diesel 2011 361652 Kansas City Hauling REL - Diesel 2011 361653 Kansas City Hauling REL - Diesel 2011 361655 Kansas City Hauling REL - Diesel 2011 361656 Kansas City Hauling REL - Diesel 2011 361657 Kansas City Hauling REL - Diesel 2012 361658 Kansas City Hauling REL - Diesel 2012 361659 Kansas City Hauling REL - Diesel 2013 361660 Joplin Hauling REL - Diesel 2006 361661 Joplin Hauling REL - Diesel 2000 361662 Joplin Hauling REL - Diesel 1993 361663 Joplin Hauling REL - Diesel 1999 361664 Kansas City Hauling REL - Diesel 2016 361665 Ada Hauling REL - Diesel 2006 361666 Ada Hauling REL - Diesel 2009 361667 Ada Hauling REL - Diesel 2008 361668 Houston North Hauling REL - Diesel 2017 361669 Bay City Hauling REL - Diesel 2017 361670 Houston North Hauling REL - Diesel 2017 361671 Rolla Hauling REL - Diesel 2017 361672 Joplin Hauling REL - Diesel 2017 361673 Springfield Hauling REL - Diesel 2017 361674 Joplin Hauling REL - Diesel 2017 361675 Wilco Hauling REL - Diesel 2017 361676 Rolla Hauling REL - Diesel 2017 401078 Ozarks Hauling RO - Diesel 1992 401090 Wilco Hauling RO - Diesel 1999 401091 Joplin Hauling RO - Diesel 1999 401376 Rolla Hauling RO - Diesel 1999 401377 Springfield Hauling RO - Diesel 1999 401382 Springfield Hauling RO - Diesel 2001 401383 Wilco Hauling RO - Diesel 2003 401384 Joplin Hauling RO - Diesel 2003 401385.1 Rolla Hauling RO - Diesel 2005 401386.1 Joplin Hauling RO - Diesel 2005 401387.1 Springfield Hauling RO - Diesel 2005 401388.1 Joplin Hauling RO - Diesel 2006 401390.1 Joplin Hauling RO - Diesel 2007 401391 Springfield Hauling RO - Diesel 2003 401392 Springfield Hauling RO - Diesel 1999 401393 Springfield Hauling RO - Diesel 2001 401394 Ozarks Hauling RO - Diesel 2007 402004 Chillicothe Hauling RO - Diesel 1999 402006 Joplin Hauling RO - Diesel 1995 402007 Joplin Hauling RO - Diesel 2000 402008 Joplin Hauling RO - Diesel 2000 402039 Blount Hauling RO - Diesel 2001 402041 Fines Hauling RO - Diesel 2006 402043 Fines Hauling RO - Diesel 2006 402047 Blount Hauling RO - Diesel 2003 402050 Fines Hauling RO - Diesel 2007 402065 Sarasota Hauling RO - Diesel 2003 402069 Fines Hauling RO - Diesel 2006 402070 Houston South Hauling RO - Diesel 2007 402072 Sarasota Hauling RO - Diesel 2005 402073 Blount Hauling RO - Diesel 2007 402074 Blount Hauling RO - Diesel 2007 402075 Houston East Hauling RO - Diesel 2007 402076 Gainesville Hauling RO - Diesel 2001 402079 Volunteer Hauling RO - Diesel 2005 402080 Volunteer Hauling RO - Diesel 2000 402081 Volunteer Hauling RO - Diesel 2005 402082 Gainesville Hauling RO - Diesel 2000 402083 Rolling Meadows Hauling RO - Diesel 2000 402085 Volunteer Hauling RO - Diesel 2000 402087 Volunteer Hauling RO - Diesel 2006 402088 Rolling Meadows Hauling RO - Diesel 2000 402090 Sarasota Hauling RO - Diesel 2005 402093 Sarasota Hauling RO - Diesel 2004 402096 Sarasota Hauling RO - Diesel 2006 402105 Bay City Hauling RO - Diesel 2004 402118 Little Rock Hauling RO - Diesel 1997 402123 Little Rock Hauling RO - Diesel 1998 402129 Little Rock Hauling RO - Diesel 1999 402130 South Arkansas Hauling RO - Diesel 1999 402131 Transit Hauling RO - Diesel 1999 402135 Transit Hauling RO - Diesel 2000 402142.1 Houston East Hauling RO - Diesel 2000 402143.2 Houston North Hauling RO - Diesel 2000 402148 Houston East Hauling RO - Diesel 2001 402154 Little Rock Hauling RO - Diesel 2002 402156 Oklahoma City Hauling RO - Diesel 2002 402157 Oklahoma City Hauling RO - Diesel 2002 402158 Oklahoma City Hauling RO - Diesel 2002 402159 Houston East Hauling RO - Diesel 2002 402161 Houston East Hauling RO - Diesel 2002 402163 Oklahoma City Hauling RO - Diesel 2003 402164 Oklahoma City Hauling RO - Diesel 2003 402166 Oklahoma City Hauling RO - Diesel 2003 402168 Houston North Hauling RO - Diesel 2003 402169 Houston East Hauling RO - Diesel 2002 402170 Orange City Hauling RO - Diesel 2002 402172 Houston North Hauling RO - Diesel 2003 402173 Bay City Hauling RO - Diesel 2003 402174 Houston North Hauling RO - Diesel 2003 402175 Little Rock Hauling RO - Diesel 2004 402176 Transit Hauling RO - Diesel 2004 402177 Transit Hauling RO - Diesel 2004 402178 Oklahoma South Hauling RO - Diesel 2004 402179 Oklahoma South Hauling RO - Diesel 2004 402180 Houston North Hauling RO - Diesel 2004 402181 Houston North Hauling RO - Diesel 2004 402182 Houston East Hauling RO - Diesel 2004 402188 Oklahoma South Hauling RO - Diesel 2005 402189 Oklahoma City Hauling RO - Diesel 2005 402190 Oklahoma East Hauling RO - Diesel 2005 402192 Houston East Hauling RO - Diesel 2005 402193 Houston East Hauling RO - Diesel 2005 402194 Houston East Hauling RO - Diesel 2005 402195.1 Little Rock Hauling RO - Diesel 2007 402203 Oklahoma City Hauling RO - Diesel 2006 402204 Ada Hauling RO - Diesel 2006 402205 Oklahoma City Hauling RO - Diesel 2006 402206 Oklahoma South Hauling RO - Diesel 2006 402208 Houston North Hauling RO - Diesel 2006 402210 Joplin Hauling RO - Diesel 2006 402211 Houston East Hauling RO - Diesel 2006 402212 Houston East Hauling RO - Diesel 2006 402213 South Arkansas Hauling RO - Diesel 2006 402214 Oklahoma City Hauling RO - Diesel 2007 402215 Houston East Hauling RO - Diesel 2007 402216 Central Missouri Hauling RO - Diesel 2007 402217 Houston East Hauling RO - Diesel 2007 402218 Houston East Hauling RO - Diesel 2007 402222 Gainesville Hauling GRAP - Diesel 2007 GRAP - Diesel 2008 402225.1 South Arkansas Hauling 402226 Joplin Hauling RO - Diesel 2008 402228.1 Houston East Hauling RO - Diesel 2007 402230 Joplin Hauling RO - Diesel 1999 402233 Chillicothe Hauling RO - Diesel 2001 402234 Springfield Hauling RO - Diesel 2007 402235 Springfield Hauling RO - Diesel 2005 402243 Volunteer Hauling RO - Diesel 2007 402244 Houston East Hauling RO - Diesel 2005 402245 Houston East Hauling RO - Diesel 2006 402246 Houston East Hauling RO - Diesel 2006 402247 South Arkansas Hauling RO - Diesel 2007 402248 Oklahoma City Hauling RO - Diesel 2005 402249 Oklahoma South Hauling RO - Diesel 2005 402250 Oklahoma East Hauling RO - Diesel 2006 402255 Bay City Hauling GRAP - Diesel 2007 402256 South Arkansas Hauling GRAP - Diesel 2010 402268 Gainesville Hauling RO - Diesel 2006 402270 Lake County Hauling RO - Diesel 2000 402271 Orange City Hauling RO - Diesel 2005 402272 Orange City Hauling RO - Diesel 2005 402273 Blount Hauling RO - Diesel 2012 402275 Blount Hauling RO - Diesel 2012 402276 Little Rock Hauling RO - Diesel 2012 402278 Sarasota Hauling RO - Diesel 2012 402279 South Arkansas Hauling RO - Diesel 2012 402280 Ozarks Hauling RO - Diesel 2009 402281 Ozarks Hauling RO - Diesel 2006 402282 South Arkansas Hauling RO - Diesel 2013 402283 Central Missouri Hauling RO - Diesel 2011 402284 Springfield Hauling RO - Diesel 2010 402288 Houston East Hauling RO - Diesel 2014 402289 Ozarks Hauling RO - Diesel 1997 402290 Bay City Hauling RO - Diesel 2015 402291 Houston South Hauling RO - Diesel 2015 402292 Houston North Hauling RO - Diesel 2015 402293 Joplin Hauling RO - Diesel 2001 402297 Rolling Meadows Hauling RO - Diesel 1984 402298 Joplin Hauling RO - Diesel 2006 402299 Sarasota Hauling RO - Diesel 2015 402300 Houston South Hauling RO - Diesel 2015 402302 Sarasota Hauling RO - Diesel 2015 402303 Bay City Hauling GRAP - Diesel 2006 402304.1 Sarasota Hauling GRAP - Diesel 2016 402305 Houston South Hauling RO - Diesel 2016 402306 Kansas City Hauling RO - Diesel 2003 402307 Kansas City Hauling RO - Diesel 2007 402308 Kansas City Hauling RO - Diesel 2007 402309 Kansas City Hauling RO - Diesel 2006 402310 Kansas City Hauling RO - Diesel 2011 402311 Kansas City Hauling RO - Diesel 2011 402312 Kansas City Hauling RO - Diesel 2003 402313 Kansas City Hauling RO - Diesel 2012 402314 Kansas City Hauling RO - Diesel 2015 402315 Kansas City Hauling RO - Diesel 2015 402316 Kansas City Hauling RO - Diesel 2015 402317 Kansas City Hauling RO - Diesel 2016 402318 Kansas City Hauling RO - Diesel 2016 402319 Kansas City Hauling RO - Diesel 2010 402320 Kansas City Hauling RO - Diesel 2009 402321 Joplin Hauling RO - Diesel 2016 402322 Sarasota Hauling GRAP - Diesel 2015 402323 Ada Hauling RO - Diesel 2011 402324 Houston North Hauling GRAP - Diesel 2016 402325 Kansas City Hauling RO - Diesel 2008 402326 Kansas City Hauling RO - Diesel 2008 402327 Kansas City Hauling RO - Diesel 2007 402328 Kansas City Hauling RO - Diesel 2012 402329 Kansas City Hauling RO - Diesel 2014 402330 Kansas City Hauling RO - Diesel 2016 402331 Oklahoma City Hauling RO - Diesel 2017 402332 Bay City Hauling RO - Diesel 2017 402333 Wilco Hauling RO - Diesel 2017 402334 Springfield Hauling RO - Diesel 2017 402340 Houston South Hauling RO - Diesel 2017 402341 Houston South Hauling RO - Diesel 2017 502102 Rolla Hauling REC - Diesel 2001 502108 Houston South Hauling REC - Diesel 2007 502109 Rolla Hauling REC - Diesel 2000 502123 Gainesville Hauling REC - Diesel 2009 502124 Gainesville Hauling REC - Diesel 2009 502125 Gainesville Hauling REC - Diesel 2009 502126 Gainesville Hauling REC - Diesel 2009 502127 Gainesville Hauling REC - Diesel 2009 502128 Gainesville Hauling REC - Diesel 2010 502129 Gainesville Hauling REC - Diesel 2010 502130 Gainesville Hauling REC - Diesel 2010 502139 Gainesville Hauling REC - Diesel 2005 502141 Gainesville Hauling REC - Diesel 2011 502142 Orange City Hauling REC - Diesel 2011 502143 Gainesville Hauling REC - Diesel 2012 502144 Orange City Hauling REC - Diesel 2012 502145 Gainesville Hauling REC - Diesel 2012 502146 Ozarks Hauling REC - Diesel 2005 502150 Gainesville Hauling REC - Diesel 2012 502153 Kansas City Hauling REC - Diesel 1996 502154 Kansas City Hauling AFL - Diesel 2009 502155 Kansas City Hauling REC - Diesel 1995 502156 Kansas City Hauling Split Body - Diesel 2009 632102 Joplin Hauling REL - Diesel 1993 651083 Springfield Hauling RO - Diesel 2013 651084 Wilco Hauling RO - Diesel 2007 730201 Oklahoma City Hauling RO - Diesel 2007 730203 South Arkansas Hauling RO - Diesel 2004 730668 South Arkansas Hauling RO - Diesel 2002 900014 Little Rock Hauling GRAP - Diesel 2008 999126 Houston North Hauling FEL - Diesel 2003 400204 Chillicothe Hauling RO - Diesel 1999 651091 Kansas City Hauling RO - Diesel 2007 651093 Kansas City Hauling RO - Diesel 2007 651054 Springfield Hauling RO - Diesel 1995 402142 Houston East Hauling RO - Diesel 2000 402143 Houston North Hauling RO - Diesel 2000 260138 Houston South Hauling FEL - Diesel 2008 260161 Orange City Hauling FEL - Diesel 2006 260329 Houston East Hauling FEL - Diesel 2017 260330 Houston North Hauling FEL - Diesel 2017 550004 Rolling Meadows Hauling REL - Diesel 2006 te the corresponding district for District Instructions: Summarize the data from the table you created in question #1 using a pivot table. Your pivot table should communicate the number of vehicles (by truck type) in each of the districts as well as the average age of those vehicles. estion #1 using a pivot table. truck type) in each of the Instructions: Using either the text-to-columns function or your choice of text formulas, separate first and last names from the list below. Customer Name Sy, Fredda Priest, Angelita Hanus, Clementina Mcgaha, Stefan Sherburne, Deetta Hise, Rhea Rawson, Earlie Mixon, Delaine Toler, Mildred Whitehill, Julietta Helfer, Donte Mally, Mandie Marion, Derick Bosio, Renay Shell, Shelly Juarbe, Eliza Lees, Santos Ristau, Tuyet Corle, Kaleigh Piner, Hosea Shoults, Iris Eckhart, Bobbi Zoll, Jonah Kopf, Inger Shapiro, Winfred Bones, Aide Kidney, Freida Ernst, Tony Scarpelli, Darron Karim, Suzie First Name Last Name Staudt, Leland Engelman, Fran Nolte, Margarett Marinello, Linn Brzozowski, Gwenda Hermansen, Wilbur Rideout, Harold Remy, Shawnee Streets, Joannie Ricca, Francoise Pino, Sade Lovell, Charita Pasquale, Keith Doggett, Evon Garay, Enda Maben, Albert Rahe, Ike Melle, Hal Deberry, Ann Obryan, Latosha of text formulas, separate out the Account Type Monthly Bill Rate Residential $196.00 Commercial $386.00 Residential $363.00 Commercial $381.00 Residential $318.00 Commercial $113.00 Residential $498.00 Commercial $491.00 Residential $488.00 Commercial $19.00 Residential $289.00 Commercial $121.00 Residential $57.00 Commercial $459.00 Residential $351.00 Commercial $338.00 Residential $439.00 Commercial $214.00 Residential $268.00 Commercial $479.00 Residential $30.00 Commercial $136.00 Residential $41.00 Commercial $313.00 Residential $487.00 Commercial $452.00 Residential $417.00 Commercial $322.00 Residential $59.00 Commercial $120.00 Residential $148.00 Commercial $405.00 Residential $76.00 Commercial $124.00 Residential $399.00 Commercial $227.00 Residential $426.00 Commercial $288.00 Residential $425.00 Commercial $182.00 Residential $464.00 Commercial $192.00 Residential $444.00 Commercial $141.00 Residential $456.00 Commercial $103.00 Residential $321.00 Commercial $203.00 Residential $335.00 Commercial $332.00 Instructions: Using the data from the table you created in problem #3, calculate the following fo each account type using an Excel function. Residential Number of Customers: Average Service Rate: Total Monthly Billed Amount: in problem #3, calculate the following for Commercial Site 63rd Transfer Station Ada Hauling Bay City Hauling Black Oak Landfill Blount Hauling Blount Landfill Central Missouri Hauling Central Missouri Landfill Chillicothe Hauling Chillicothe Transfer Station Corporate Desoto Landfill Durango Transfer Station El Dorado Transfer Station Fines Hauling Fines Landfill Fruitville Transfer Station Ft. Bend Landfill Ft. Meade Landfill Gainesville Hauling Greenbelt Landfill Harrisonville Transfer Station Houston East Hauling Houston North Hauling Houston Residential Valet Houston South Hauling Joplin Hauling Joplin Transfer Station Kansas City Hauling Kansas City MRF Kansas City Transfer Station Knights Trail Transfer Station Lake County Hauling Little Rock Hauling Neosho Transfer Station Newday Transfer Station Northeast Landfill Oak Grove Landfill Oklahoma City Hauling Oklahoma East Hauling Oklahoma South Hauling Orange City Hauling Ozarks Hauling Ozarks Transfer Station Parsons Transfer Station Paul's Valley Landfill Ralston Road Landfill District Sarasota District Oklahoma District Texas South District Missouri South District Alabama/Tennessee District Alabama/Tennessee District Missouri North District Missouri North District Missouri North District Missouri North District Texas South District Sarasota District Colorado/New Mexico District Missouri South District Alabama/Tennessee District Alabama/Tennessee District Sarasota District Texas Landfill District Sarasota District Gainesville District Texas Landfill District Missouri North District Texas North District Texas North District Texas South District Texas South District Missouri South District Missouri South District Missouri North District Missouri North District Missouri North District Sarasota District Orlando District Arkansas District Missouri South District Missouri South District Oklahoma District Missouri South District Oklahoma District Oklahoma District Oklahoma District Orlando District Missouri South District Missouri South District Missouri South District Oklahoma District Texas Landfill District Rolla Hauling Rolling Meadows Hauling Rolling Meadows Landfill Ruffino Hills Transfer Station Sarasota Hauling Searcy Transfer Station Sooner Landfill South Arkansas Hauling Springfield Hauling Springfield Transfer Station Tall Pines Landfill Transit Hauling Transit Landfill Union County Landfill Volunteer Hauling Volunteer Landfill Wilco Hauling Missouri South District Arkansas District Arkansas District Texas Landfill District Sarasota District Arkansas District Oklahoma District Arkansas District Missouri South District Missouri South District Texas Landfill District Colorado/New Mexico District Colorado/New Mexico District Arkansas District Alabama/Tennessee District Alabama/Tennessee District Missouri South District