Excel ISBN and UIN Checker (with algorithm provided!)

There is often a need to use the check digit often to detect any errors such as from data entry. For example, one might need to check if the digits and letter in a UIN were legitimate or valid before registering the person in a course or before granting access for further online transactions.

"A check digit is a form of redundancy check used for error detection, the decimal equivalent of a binary checksum. It consists of a single digit computed from the other digits in the message.

With a check digit, one can detect simple errors in the input of a series of digits, such as a single mistyped digit, or the permutation of two successive digits."

There are various uses of the check digit. In this post, we are using the "Modulo 11" checksum algorithm to find the check digit for ISBN and UIN (for Singapore and Hong Kong).

Why do we use the "modulo 11"? For numerical check digit, using modulo 11 allows checksum to be written as single digit.

In Singapore, the National Registration Identity Card (NRIC) number is the Unique Identification Number (UIN) or Foreigner Identification Number (FIN)

The algorithm for UIN is not officially announced but is common knowledge among those in the industry.

When used appropriately, this could be a useful first-level protection against malicious attacks or to prevent frivolous usage of certain services your company provide.

Download options:
1) Direct download
ISBN:
Singapore NRIC/UIN/FIN:
Hong Kong UIN:


2) From Docstoc

ISBN: here

Singapore NRIC/UIN/FIN: here

Hong Kong UIN: here

OR see all in docstoc



__________________________________________________________________