Spreadsheet: 189977d1351485561-fleet-management-spreadsheet-general-advice-car1
Sheet: Sheet1

QT VEHICLE DETAILS
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] | Make | Location | Contract | End of lease | K's |  |  |  |  |  |  |  |  |  |  |  |  | 2013
C-51-BI | FORD RANGER | DEVONPORT | 24/60 | 2013-07-04 00:00:00 | Month | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30700
B-15-JN | FORD RANGER | DEVONPORT | 24/40 | 2012-03-18 00:00:00 | Month | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
[NAME] | VW CADDY | DEVONPORT | 24/40 | 2013-01-27 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
B-25-YR | FORD RANGER | DEVONPORT | 24/40 | 2013-03-01 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-41-AS | FORD RANGER | DEVONPORT | 24/40 | 2012-08-18 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
[NAME] | TOYOTA CAMRY | DEVONPORT | 24/40 | 2013-01-25 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
[NAME] | TOYOYA CAMRY | DEVONPORT | 24/60 | 2012-01-01 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
B-03-SM | TOYOTA CAMRY | LAUNCESTON | 24/60 | 2012-11-10 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
B-82-YU | FORD FOCUS | LAUNCESTON | 24/36 | 2013-04-28 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1500 | 3000 | 4500 | 6000 | 7500 | 9000 | 10500 | 12000 | 13500 | 15000 | 16500 | 18000 | 19500 | 21000 | 22500 | 24000 | 25500 | 27000 | 28500 | 30000 | 31500 | 33000 | 34500 | 36000
 |  |  |  |  | Actual km's
G-89-AV | VW CADDY | LAUNCESTON | 24/50 | 2013-01-06 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2083 | 4166 | 6249 | 8332 | 10415 | 12498 | 14581 | 16664 | 18747 | 20830 | 22913 | 24996 | 27079 | 29162 | 31245 | 33328 | 35411 | 37494 | 39577 | 41660 | 43743 | 45826 | 47909 | 49992
 |  |  |  |  | Actual km's
C-52-BI | FORD RANGER | LAUNCESTON | 24/60 | 2013-07-04 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
G-48-AV | FORD RANGER | LAUNCESTON | 24/40 | 2014-07-05 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
[NAME] | FORD RANGER | LAUNCESTON | 24/50 | 2011-11-18 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2083 | 4166 | 6249 | 8332 | 10415 | 12498 | 14581 | 16664 | 18747 | 20830 | 22913 | 24996 | 27079 | 29162 | 31245 | 33328 | 35411 | 37494 | 39577 | 41660 | 43743 | 45826 | 47909 | 49992
 |  |  |  |  | Actual km's
G-30-AZ | HYUNDAI i-30 | LAUNCESTON | 24/40 | 2013-02-23 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
C-73-BJ | FORD FOCUS | HOBART | 24/60 | 2013-07-29 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
G-12-AS | FORD RANGER 4X4 | HOBART | 24/40 | 2012-12-17 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
B-54-FS | TOYOTA TARAGO | HOBART | 24/60 | 2012-01-27 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
B-07-LK | TOYOTA AURION | HOBART | 24/50 | 2012-05-14 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2083 | 4166 | 6249 | 8332 | 10415 | 12498 | 14581 | 16664 | 18747 | 20830 | 22913 | 24996 | 27079 | 29162 | 31245 | 33328 | 35411 | 37494 | 39577 | 41660 | 43743 | 45826 | 47909 | 49992
 |  |  |  |  | Actual km's
B-08-ND | TOYOTA CAMRY | HOBART | 24/60 | 2012-07-16 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
B-57-UD | COMMODORE UTE | HOBART | 24/60 | 2012-12-01 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 2500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 22500 | 25000 | 27500 | 30000 | 32500 | 35000 | 37500 | 40000 | 42500 | 45000 | 47500 | 50000 | 52500 | 55000 | 57500 | 60000
 |  |  |  |  | Actual km's
[NAME] | VW GOLF | HOBART | 36/60 | 2015-01-20 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984 | 41650 | 43316 | 44982 | 46648 | 48314 | 49980 | 51646 | 53312 | 54978 | 56644 | 58310 | 59976
 |  |  |  |  | Actual km's
G-40-AS | FORD RANGER | HOBART | 24/40 | 2012-08-14 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-20-AT | FORD RANGER | HOBART | 24/40 | 2013-04-07 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-47-AO | FORD RANGER | HOBART | 24/40 | 2013-04-07 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-82-AK | VW CADDY | HOBART | 24/40 | 2012-10-26 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-54-AV | MITSHIBISHI TRITON 4X4 | HOBART | 24/40 | 2012-10-25 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's
G-32-AS | FORD RANGER 4X4 | HOBART | 24/40 | 2012-09-13 00:00:00 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Estimated km's | 1666 | 3332 | 4998 | 6664 | 8330 | 9996 | 11662 | 13328 | 14994 | 16660 | 18326 | 19992 | 21658 | 23324 | 24990 | 26656 | 28322 | 29988 | 31654 | 33320 | 34986 | 36652 | 38318 | 39984
 |  |  |  |  | Actual km's