Container Check Digit Calculator Excel

C sub total a divided with b d sub total without decimals.

Container check digit calculator excel. Steps b to e is a calculation of the remainder found after division of a by 11. The next number will be produced by adding 1 to the end of the 7 digit number 1234567 1 1234568 then concatenating again the number with the check digit 6 12345686. 11 is used as divisor because a container number has 11 letters and digits in total. Container check digit calculator.

These numbers are produced by using any seven digits and adding a check digit at the end for an eight digit number using the mod function specifically mod7 mod a1 7 for example if cell a1 has 1234567 the mod7 function will produce the check digit 5 then concatenating for the eight digit number 12345675. If the final difference is 10 then the check digit becomes 0. E subtract result of d from result of a. In this case the sum of the multiplications is 118 so modulo 10 in this case is 118 10 11 8 8.

If modulo 10 is not 0 then your check digit is 10 the modulo. 11 characters starting with 4 letters the rest digits. How to calculate a check digit in a container no. Take modulo 10 of the results and if the answer is 0 your check digit is 0.

This is the check digit. Enter the first six digits of the starting serial number. Enter the first six digits of the ending serial number. This would be.

You have the possibility to calculate 25 check digits at once if the serial number are sequential. Enter 10 characters to calculate check digit 11 characters to verify. B divide with 11. To find the modulo in excel mod d16 10 where the sum is in d16 and the modulo divisor is 10.

Container check digit calculator for calculation and verification. It does not matter where in the world you are if you have a wrong check digit you have an invalid container number and an invalid container number is impossible to trace through the seafreight shipping process. Owner code serial number. Container check digit calculator.

Container check digit calculator validate multiple container numbers a check digit is the last digit in the container number xxxx 123456 7 it validates the container prefix xxxx 123456 7 and the container serial number xxxx 123456 7 for detailed instruction on how the check digit is calculated please see the check digit manual manual for check digit calculation excel file.