You are not logged in.
Lost Password?


Register To Post



 Bottom   Previous Topic   Next Topic

#1
How to calculate US Serial Number checksum
Posted on: 2009/10/28 23:47
Nintendoid!
Joined 2009/8/11
USA
112 Posts
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.
Top

#2
Re: How to calculate US Serial Number checksum
Posted on: 2009/10/29 14:10
Administrator
Joined 2000/1/8
Germany
2515 Posts
Highscore Top10Highscore Top ScoreCoder#1 PosterHOTY09 1stLong Time User (15 Years) App Coder90+ Game Ratings
Very interesting, thanks for the info! :)
Top

#3
Re: How to calculate US Serial Number checksum
Posted on: 2012/6/14 17:10
PVB Elite
Joined 2003/7/26
USA
1464 Posts
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
Top

#4
Re: How to calculate US Serial Number checksum
Posted on: 9/13 15:57
VB Gamer
Joined 4/10
33 Posts
Sorry for the necrobump, but what would happen if you scanned the SN sticker on a US VB with a barcode scanner?
Top

#5
Re: How to calculate US Serial Number checksum
Posted on: 9/13 20:32
PVB Elite
Joined 2013/6/17
Canada
1144 Posts
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.
Top

 Top   Previous Topic   Next Topic


Register To Post