First off, I calculate a different sum of the products. In column 15 you multiply 0 by 4 and get a 4. My calculation puts this portion at 0, and my sum of the products becomes 328. Anyway, here is my formula to generate the checksum digit:
In this example, this equates to 9.
Have I missed something, or are we on the right path here?