Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Paper Money
>
Plate position arithmetic
>
Reply to Thread
Message:
<p>[QUOTE="dursin, post: 560923, member: 17425"]If you have Excel (or just use Google Documents), you can plug this formula into any cell other than B2 and then put your serial number in cell B2 and it will tell you the plate position.</p><p><br /></p><p>=CHAR(CODE("A")+INT(MOD(MOD(B2-1,6400000)/200000,8)))&INT((MOD(B2-1,6400000)/200000)/8)+1</p><p><br /></p><p>Little sloppy, but I wanted to get it all in one line. Need to change the 6400000 and 20000 if using anything other than the 32 note sheets.</p><p><br /></p><p>Tested it with the notes in my wallet and it seems to work.</p><p><img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie2" alt=";)" unselectable="on" unselectable="on" /></p><p>Oops...didn't see your spreadsheet. Like your solution much better![/QUOTE]</p><p><br /></p>
[QUOTE="dursin, post: 560923, member: 17425"]If you have Excel (or just use Google Documents), you can plug this formula into any cell other than B2 and then put your serial number in cell B2 and it will tell you the plate position. =CHAR(CODE("A")+INT(MOD(MOD(B2-1,6400000)/200000,8)))&INT((MOD(B2-1,6400000)/200000)/8)+1 Little sloppy, but I wanted to get it all in one line. Need to change the 6400000 and 20000 if using anything other than the 32 note sheets. Tested it with the notes in my wallet and it seems to work. ;) Oops...didn't see your spreadsheet. Like your solution much better![/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Paper Money
>
Plate position arithmetic
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...