PDA

View Full Version : Excel Formula to Create Full VIN number



lazabby
11-10-2022, 05:56 PM
Someone has probably already done this but I need an Excel formula to create the full Delorean VIN based upon the last five digits of the VIN. For example if the VIN is 6235 is there an Excel formula that can create the full VIN? (SCED...). This should be a fun challenging project for some Excel expert out there.

Victor
11-10-2022, 06:14 PM
Somewhat unrelated, but would very much appreciate if some decals could be reproduce to recreate the black lettering on the VIN plate of maybe what the later cars had, with the words ? DMC Delorean Motor Cars ? and below the vin ? Belfast N. Ireland. As seen in attached picture.

Was wondering if a decal or a micro sticker like this would sell?

I am myself not equipped to fabricate a decal, and I do mot have a plotter for to create sign.

DeloreanGo sells tiny stickers of fan logo to put on switched, so it is feasible for sure?

Citizen
11-10-2022, 10:21 PM
Someone has probably already done this but I need an Excel formula to create the full Delorean VIN based upon the last five digits of the VIN. For example if the VIN is 6235 is there an Excel formula that can create the full VIN? (SCED...). This should be a fun challenging project for some Excel expert out there.

I'm not an Excel expert, but I could do it, if I had the criteria. Doesn't have to be Excel (VBA), could be Access, VB, C#, C++, Java, or any programming language really. And it could be put on the web easy enough. Shoot me an email of the rules for creating the full VIN, and I'll do it. Not really sure how to handle the check digit though, we'd have to talk about that.

Thomas

...

Mark D
11-10-2022, 11:44 PM
These links might be helpful:

https://en.wikibooks.org/wiki/Vehicle_Identification_Numbers_(VIN_codes)/Check_digit

http://www.alton-moore.net/vin_calculation.html

pk2678
11-11-2022, 02:42 AM
The model year is also included in the VIN. To get the model year from the last five digits, this would be helpful:

http://support.delorean.com/kb/a12/delorean-vehicle-identification-numbers-vins.aspx

And here is another example how to calculate the VIN:

https://lukesandel.com/auto/delorean/repair/VINdecode.html

Peter

Helirich
11-11-2022, 10:40 AM
What is the purpose of this program? I mean, if you have the car and title, you have the vin. If you don?t, why do you want it? Sounds kind of nefarious.