# Thread: formula to calculate the last alphabet of veh no plate

1. ## formula to calculate the last alphabet of veh no plate

hi,

anyone knows of the formula to calculate the last alphabet of the singapore vehicle number plate?

my friend's father has this car, but sold away about 10 to 15 years liao and knows the front 2 alphabets, the 4 numbers, but can't remember the last alphabet of the vehicle....

so need to know the formula...

any help?
thanks

2. ## Re: formula to calculate the last alphabet of veh no plate

they did this with a nric number some time back. i remember some cs-ers that know this i think. good luck =D

3. ## Re: formula to calculate the last alphabet of veh no plate

I thought it was by alphabetical order... interesting...

5. ## Re: formula to calculate the last alphabet of veh no plate

Originally Posted by Klose
Yup, works correctly.

6. ## Re: formula to calculate the last alphabet of veh no plate

works like a charm... thanks klose.....

7. ## Re: formula to calculate the last alphabet of veh no plate

it works for licence plate nos. with lesser digits as well, like motorcycles etc. you just have to leave the first box empty... cool!

8. ## Re: formula to calculate the last alphabet of veh no plate

The xcel file works out automatically, but the formula is hidden.

For those who's interested in the details, here goes (I found this somewhere, but can't remember where now ):

For the first 3 alphabets, use their numeric value - 64.
The constants are the code. Multiply constant to each respective numbers.
Then add up all the figures and divide by 19. Use the remainder to reference the string of alphabets.

Example SCE1234Z
The numeric value of 'S' (uppercase) is 83, so you take 83 - 64 to get the value, which is 19.
'C' is 67 - 64 which is 3 and 'E' is 69 - 64 which is 5.
Now you have a string of numbers, 19, 3, 5, 1, 2, 3, 4.
Multiply each of this to the constant(value that does not change) 3, 14, 2, 12, 2, 11, 1 respectively.
Now you will get a new set of values which are 57, 42, 10, 12, 4, 33, 4.
Total this set of number 57+42+10+12+4+33+4=162
Divide the total of 162 by 19 to find the remainder.
The remainder is 10.
Using the string of alpha,AYUSPLJGDBZXTR, the number 10 alpha is the last alpha to the number plate. Note that you start with Zero, hence position for 'A' is zero.

By the way, the numeric value of alphabets are as follows. Starting with 'A' with a value of 65, 'B' with 66 ............ till 'Z' with 90.

9. ## Re: formula to calculate the last alphabet of veh no plate

Reviving an old thread here. For the NRIC formula, it works on all my friends except one!

We tried using the excel sheet and also through manual calculation. However, both methods "calculated" her last digit to be 'D' when it is actually 'C'.

Though it makes more sense if i show the numbers involved but I dun not think its prudent to reveal the actual numbers here.

Does anybody have any idea when (if ever) the calculations do not work?

10. ## Re: formula to calculate the last alphabet of veh no plate

Originally Posted by ahbian
Reviving an old thread here. For the NRIC formula, it works on all my friends except one!

We tried using the excel sheet and also through manual calculation. However, both methods "calculated" her last digit to be 'D' when it is actually 'C'.

Though it makes more sense if i show the numbers involved but I dun not think its prudent to reveal the actual numbers here.

Does anybody have any idea when (if ever) the calculations do not work?
where your friend got her IC from

11. ## Re: formula to calculate the last alphabet of veh no plate

Originally Posted by CYRN
where your friend got her IC from

Yeah. We were joking around that she was an illegal immigrant.

Still, it really puzzled us on why the alphabets "did'nt tally".

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•