Nicht eingeloggt.
Passwort vergessen?


Bitte erst registrieren. Danach ist es möglich Beiträge zu schreiben.



 Nach unten   Vorheriges Thema   Nächstes Thema

#1
How to calculate US Serial Number checksum
Geschrieben am: 28.10.2009 23:47
Nintendoid!
Dabei seit 11.08.2009
USA
112 Beiträge
Long Time User (10 Years)
I don't know if this is of any interest to anyone... maybe for those of you who don't know all the digits of your SN, you could manually calculate it?

Anyway, it follows the UPC-A / GTIN-12 pattern, except you just pad it with 000 to make it 12 digits (pad in the front of the serial number)

You can use this website, or just search for gtin-12 calculator...

http://www.ablt.com/check-digit-calculator.html

So, if you had a serial number of VN10413008[5], go to the website above, and type in "00010413008" and it will tell you the ckeck is "5"



If you want to do this in Excel, then fill cells A1 to A8 with the serial number (A1 being the far left digit), and paste the below wherever you want the checksum value to be...


=MOD(130-(3*(A8+A6+A4+A2)+A1+A3+A5+A7),10)


Sorry if this is a repost, I didn't see anything about it on here.
Nach oben

#2
Re: How to calculate US Serial Number checksum
Geschrieben am: 29.10.2009 14:10
Administrator
Dabei seit 08.01.2000
Deutschland
2524 Beiträge
Highscore Top10Highscore Top ScoreCoder#1 PosterHOTY09 1stLong Time User (15 Years) App Coder90+ Game Ratings
Very interesting, thanks for the info! :)
Nach oben

#3
Re: How to calculate US Serial Number checksum
Geschrieben am: 14.06.2012 17:10
PVB Elite
Dabei seit 26.07.2003
USA
1466 Beiträge
PVBCC EntryCoderContributorSpecial AchievementTop10 PosterHOTY09 EntryLong Time User (15 Years) App Coder20+ Game RatingsPVBCC 2013 Entry
The checksum calculator link seems to be broken. I found another that seems to work:

http://www.upcdatabase.com/checkdigit.asp
Nach oben

#4
Re: How to calculate US Serial Number checksum
Geschrieben am: 13.09.2019 15:57
VB Gamer
Dabei seit 10.04.2019
37 Beiträge
Sorry for the necrobump, but what would happen if you scanned the SN sticker on a US VB with a barcode scanner?
Nach oben

#5
Re: How to calculate US Serial Number checksum
Geschrieben am: 13.09.2019 20:32
PVB Elite
Dabei seit 17.06.2013
Kanada
1208 Beiträge
Top10 Poster10+ Game RatingsLong Time User (6 Years)
The serial number should show up in whatever field you had selected. Barcodes are dead simple in function.
Nach oben

 Nach oben   Vorheriges Thema   Nächstes Thema


Bitte erst registrieren. Danach ist es möglich Beiträge zu schreiben.