Car History Timeline - anyone done it ?

[mr momo]

Before I lose my marbles, I want to put a timeline together recording/showing all the cars I've owned.

Has anyone ever done this and recommend a good way of going about it (tools/software/apps) ?

I remember all the registration numbers, but not exact dates of ownership......


Tips most welcome ;-)

[2 sMoKiN bArReLs]

Without wishing to be a nerd..

..yep. Recorded all my cars with reg no & mileages & dates of ownership in an Excel sheet

[andy43]

2 sMoKiN bArReLs said:

Without wishing to be a nerd..

..yep. Recorded all my cars with reg no & mileages & dates of ownership in an Excel sheet

Purely to protect against speeding ticket and parking fine comebacks surely?

[2 sMoKiN bArReLs]

andy43 said:

2 sMoKiN bArReLs said:

Without wishing to be a nerd..

..yep. Recorded all my cars with reg no & mileages & dates of ownership in an Excel sheet

Purely to protect against speeding ticket and parking fine comebacks surely?

Without tempting fate I've driven 750,000 miles over 42 years & not had a parking ticket.

[2 sMoKiN bArReLs]

And because it's saved as a database it can be analysed

Type Mileage
Coupe 28,023
Estate 10,474
Executive 3,154
Hot Hatch 337,887
Pick Up 17,687
Saloon 49,893
Sports 288,471
SUV 33,661
Grand Total 769,227

[2 sMoKiN bArReLs]

Or

Colour Mileage
Black 5,150
Blue 244,185
Green 105,100
Grey 35,891
Mauve 65,004
Orange 33,661
Red 135,595
Silver 96,041
White 48,600
Grand Total 769,227

Mauve & orange sounds a bit weird

[smn159]

2 sMoKiN bArReLs said:

Or

Colour Mileage
Black 5,150
Blue 244,185
Green 105,100
Grey 35,891
Mauve 65,004
Orange 33,661
Red 135,595
Silver 96,041
White 48,600
Grand Total 769,227

Mauve & orange sounds a bit weird

Impressive!

Can you do a graph of miles travelled against BHP?

[2 sMoKiN bArReLs]

smn159 said:

2 sMoKiN bArReLs said:

Or

Colour Mileage
Black 5,150
Blue 244,185
Green 105,100
Grey 35,891
Mauve 65,004
Orange 33,661
Red 135,595
Silver 96,041
White 48,600
Grand Total 769,227

Mauve & orange sounds a bit weird

Impressive!

Can you do a graph of miles travelled against BHP?

Indeed I could.

[mr momo]

The aim is more for nostalgia, rather than data analysis, so needs to be pleasing to the eye....

I've started with some photos - by god, the early ones are shocking

[mr momo]

The aim is more for nostalgia, rather than data analysis, so needs to be pleasing to the eye....

I've started with some photos - by god, the early ones are shocking

[Podie]

2 sMoKiN bArReLs said:

Or

Mauve & orange sounds a bit weird

Mauve, yes.

Orange... less so...

[2 sMoKiN bArReLs]

Podie said:

2 sMoKiN bArReLs said:

Or

Mauve & orange sounds a bit weird

Mauve, yes.

Orange... less so...

I give you: Dusty mauve

[2 sMoKiN bArReLs]

Or

[2 sMoKiN bArReLs]

mr momo said:

The aim is more for nostalgia, rather than data analysis, so needs to be pleasing to the eye....

I've started with some photos - by god, the early ones are shocking

I've also got a scrap book with pictures etc in it.

[redandwhite]

I (regrettably) haven’t gone to this level of logging. Although I would like to think this information on dates etc would be available from DVLA (at a cost)

[B'stard Child]

2 sMoKiN bArReLs said:

Without wishing to be a nerd..

..yep. Recorded all my cars with reg no & mileages & dates of ownership in an Excel sheet

I love people that do stuff like that

[RammyMP]

2 sMoKiN bArReLs said:

smn159 said:

2 sMoKiN bArReLs said:

Or

Colour Mileage
Black 5,150
Blue 244,185
Green 105,100
Grey 35,891
Mauve 65,004
Orange 33,661
Red 135,595
Silver 96,041
White 48,600
Grand Total 769,227

Mauve & orange sounds a bit weird

Impressive!

Can you do a graph of miles travelled against BHP?

Indeed I could.

I’ve kept a record in an excel spreadsheet but it’s nowhere near as detailed as that! Well done.

...I need to add more detail to my list, not going to get anything at work tomorrow morning!

[andy43]

2 sMoKiN bArReLs said:

Podie said:

2 sMoKiN bArReLs said:

Or

Mauve & orange sounds a bit weird

Mauve, yes.

Orange... less so...

I give you: Dusty mauve

Oooh hello. Dusty Mavis is looking good.

[PixelpeepZ4]

For visuals i think an infograpic or MS Visio would be the way forward.

Or a combination of SQL & qlikview or Power Bi?

<runs and hides>

[KelvinatorNZ]

I have a page on my website dedicated to the cars I have owned, in chronological order. I also have a spreadsheet somewhere of various details like engine capacity, engine HP, current roadworthy status etc.

https://www.tasteslikepetrol.net/cars/