MAKER
CAR ID MAKER (FULL NAME) MODEL
LX20LM001 LX LEXUS LM
LX20LM002 LX LEXUS LM
LX20LM003 LX LEXUS LM
LX23LM004 LX LEXUS LM
LX23LM005 LX LEXUS LM
LX13RX006 LX LEXUS RX
LX15RX007 LX LEXUS RX
LX15RX008 LX LEXUS RX
LX15RX009 LX LEXUS RX
LX19RX010 LX LEXUS RX
HD15CV011 HD HONDA CV
HD15CV012 HD HONDA CV
HD16CV013 HD HONDA CV
HD16CV014 HD HONDA CV
HD17CV015 HD HONDA CV
HD19OD016 HD HONDA OD
HD19OD017 HD HONDA OD
HD21OD018 HD HONDA OD
HD21OD019 HD HONDA OD
HD21OD020 HD HONDA OD
TY16HX021 TY TOYOTA HX
TY16HX022 TY TOYOTA HX
TY16HX023 TY TOYOTA HX
TY20HX024 TY TOYOTA HX
TY20HX025 TY TOYOTA HX
TY18RS026 TY TOYOTA RS
TY18RS027 TY TOYOTA RS
TY19RS028 TY TOYOTA RS
TY19RS029 TY TOYOTA RS
TY19RS030 TY TOYOTA RS
HD HONDA CV Civic
LX LEXUS HX Hilux
TY TOYOTA LM Luxury Mover
OD Odyssey
RS Rush
RX Radiant Crossover
MODEL MANUFACTURE
(FULL NAME) YEAR AGE MILES MILES / YEAR
Luxury Mover 20 5 46,214.7 9,242.9
Luxury Mover 20 5 51,394.5 10,278.9
Luxury Mover 20 5 62,629.5 12,525.9
Luxury Mover 23 2 51,631.1 25,815.6
Luxury Mover 23 2 79,386.7 39,693.4
Radiant Crossover 13 12 42,717.8 3,559.8
Radiant Crossover 15 10 39,439.5 3,944.0
Radiant Crossover 15 10 63,641.2 6,364.1
Radiant Crossover 15 10 67,481.8 6,748.2
Radiant Crossover 19 6 69,740.0 11,623.3
Civic 15 10 83,426.9 8,342.7
Civic 15 10 98,259.2 9,825.9
Civic 16 9 94,789.4 10,532.2
Civic 16 9 43,455.0 4,828.3
Civic 17 8 70,796.3 8,849.5
Odyssey 19 6 21,562.6 3,593.8
Odyssey 19 6 38,083.8 6,347.3
Odyssey 21 4 65,630.5 16,407.6
Odyssey 21 4 56,369.2 14,092.3
Odyssey 21 4 35,298.0 8,824.5
Hilux 16 9 67,970.7 7,552.3
Hilux 16 9 59,113.1 6,568.1
Hilux 16 9 42,148.1 4,683.1
Hilux 20 5 25,354.0 5,070.8
Hilux 20 5 53,339.3 10,667.9
Rush 18 7 54,657.0 7,808.1
Rush 18 7 24,830.3 3,547.2
Rush 19 6 42,327.3 7,054.6
Rush 19 6 41,245.3 6,874.2
Rush 19 6 33,811.3 5,635.2
WARRANTY
COLOR DRIVER MILES COVERED?
Black Edwards 50000 YES
Black Paul 50000 NO
White Clinton 50000 NO
Blue Carlos 50000 NO
Blue Neal 50000 NO
White Gibson 100000 YES
Gray Samuel 100000 YES
Red Wilson 100000 YES
Red Timothy 100000 YES
Gray Grant 100000 YES
Gray Alvarez 75000 NO
Black Schmidt 75000 NO
Black Zachary 75000 NO
White Cole 75000 YES
Blue Felix 75000 YES
Blue Randall 70000 YES
White Raynor 70000 YES
Gray Oldman 70000 YES
Red Teller 70000 YES
Red Dawson 70000 YES
Gray Bernard 120000 YES
Gray Leonard 120000 YES
Black Lewis 120000 YES
Black James 120000 YES
White Ken 120000 YES
Blue Vincenzo 80000 YES
Blue Rudolf 80000 YES
White Marcel 80000 YES
Gray Maurice 80000 YES
Red Edgar 80000 YES
NEW CAR ID
LX20LMBLA001
LX20LMBLA002
LX20LMWHI003
LX23LMBLU004
LX23LMBLU005
LX13RXWHI006
LX15RXGRA007
LX15RXRED008
LX15RXRED009
Miles
LX19RXGRA010
120,000.0
HD15CVGRA011
HD15CVBLA012
100,000.0
HD16CVBLA013
HD16CVWHI014
80,000.0
HD17CVBLU015
Miles Driven
HD19ODBLU016
60,000.0
HD19ODWHI017
HD21ODGRA018
40,000.0
HD21ODRED019
HD21ODRED020
20,000.0
TY16HXGRA021
TY16HXGRA022
-
TY16HXBLA023 0 2 4
TY20HXBLA024 Age of th
TY20HXWHI025
TY18RSBLU026
MILES /
TY18RSBLU027
45,000.0
TY19RSWHI028
40,000.0
TY19RSGRA029
35,000.0
30,000.0
25,000.0
45,000.0
40,000.0
TY19RSRED030 35,000.0
30,000.0
25,000.0
20,000.0
15,000.0
10,000.0
5,000.0
-
0 2 4 6
KEYWORDS
LEFT
MID
RIGHT
VLOOKUP
CONCATENATE
UPPER
Miles / Age
0 2 4 6 8 10 12 14
Age of the Car (Years)
MILES / YEAR
2 4 6 8 10 12 14
DRIVER Sum of MILES
Alvarez 83,426.9 Total
Bernard 67,970.7
Carlos 51,631.1 1,800,000.0
Clinton 62,629.5
1,600,000.0
Cole 43,455.0
1,400,000.0
Dawson 35,298.0
Edgar 33,811.3 1,200,000.0
Edwards 46,214.7 1,000,000.0
Felix 70,796.3 800,000.0
Gibson 42,717.8 600,000.0
Grant 69,740.0
400,000.0
James 25,354.0
200,000.0
Ken 53,339.3
Leonard 59,113.1 -
re
z
rlo
s le ar lix an
t n is
Lewis 42,148.1 vl a Co g Fe Ke w
A C a Ed Gr Le au
Marcel 42,327.3 M
Maurice 41,245.3
Neal 79,386.7
Oldman 65,630.5
Paul 51,394.5
Randall 21,562.6
Raynor 38,083.8
Rudolf 24,830.3
Samuel 39,439.5
Schmidt 98,259.2
Teller 56,369.2
Timothy 67,481.8
Vincenzo 54,657.0
Wilson 63,641.2
Zachary 94,789.4
Total Result 1,626,744.1
Total
Sum of MILES
lix t n is e an ll lf t y n lt
Fe an Ke w ric da do id th so su
Gr Le au d m
Ra
n u h m o il
R e
M Ol R Sc Tim W
t al
To