Results 1 to 11 of 11

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

  1. #1
    Senior Member erictan8888's Avatar
    Join Date
    Nov 2004
    Location
    Singapore
    Posts
    2,885

    Default 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
    Hope to learn from everyone here....

  2. #2
    Senior Member
    Join Date
    Jan 2006
    Location
    The Land of the Teddy Bear
    Posts
    1,454

    Default 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
    I Love You :)

  3. #3
    Senior Member redstone's Avatar
    Join Date
    Aug 2005
    Location
    Beyond the outer limits
    Posts
    2,898

    Default Re: formula to calculate the last alphabet of veh no plate

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

  4. #4

    Default Re: formula to calculate the last alphabet of veh no plate


  5. #5

    Default Re: formula to calculate the last alphabet of veh no plate

    Yup, works correctly.

  6. #6
    Senior Member erictan8888's Avatar
    Join Date
    Nov 2004
    Location
    Singapore
    Posts
    2,885

    Default Re: formula to calculate the last alphabet of veh no plate

    works like a charm... thanks klose.....
    Hope to learn from everyone here....

  7. #7
    Member
    Join Date
    Jan 2004
    Location
    Central
    Posts
    295

    Default 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. #8

    Default 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.
    Jia Wang... "A photo is only as beautiful as the photographer's eyes can see."
    My Eyes ;)

  9. #9

    Default 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. #10

    Default Re: formula to calculate the last alphabet of veh no plate

    Quote 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










    Gallery | Facebook Page Spreading the Good photography.

  11. #11

    Default Re: formula to calculate the last alphabet of veh no plate

    Quote 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".

Bookmarks

Posting Permissions

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