# VIN calculations

#### Timberline

##### New Member

First, find the numerical value associated with each letter in the VIN. (I, O and Q are not allowed.) Digits use their own values.

A=1, B=2, C=3, D=4, E=5, F=6, G=7, H=8,
J=1, K=2, L=3, M=4, N=5, P=7, R=9,
S=2, T=3, U=4, V=5, W=6, X=7, Y=8, Z=9

Second, look up the weight factor for each position in the VIN except the 9th (the position of the check digit).

1st=8 2nd=7 3rd=6 4th=5 5th=4 6th=3
7th=2 8th=10 10th=9 11th=8 12th=7 13th=6
14th=5 15th=4 16th=3 17th=2
Example;
<table class="MsoNormalTable" style="width: 337pt; margin-left: 5.15pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="449"> <tbody><tr style="height: 12.75pt;"> <td style="width: 11pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td rowspan="4" style="width: 17pt; border-width: 1pt; border-style: solid; border-color: windowtext windowtext black; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="23">
[FONT=&quot]Check Digit<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 11pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]4<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot]associated values<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 11pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]7<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]4<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]10<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]7<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]4<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot]weight factors<o></o>[/FONT]
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 11pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]21<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]54<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]10<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]20<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]6<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]20<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]32<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]63<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]12<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]40<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]4<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]15<o></o>[/FONT]​
</td> <td style="width: 16pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="21">
[FONT=&quot]12<o></o>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot]products<o></o>[/FONT]
</td> </tr> </tbody></table> <o> </o>
The check digit is then calculated by dividing the sum of products which in this case is 332 by 11 which give me 30 and 2/11 the remainder of 2 then becomes the check digit. So the VIN in this case would be
<table class="MsoNormalTable" style="width: 191pt; margin-left: 5.15pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="255"> <tbody><tr style="height: 12.75pt;"> <td style="width: 11pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]3<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 12pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 12pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 11pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 12.75pt;" nowrap="nowrap" valign="bottom" width="15">
[FONT=&quot]6<o></o>[/FONT]​
</td> </tr> </tbody></table> If this calculation produces a whole number the check digit = 0 and if it produces 10/11 it = X
Using v-lookup and simple formulas I can create the VINâ€™s with the exception of the check digit, is there away to calculate this and have it placed in its position in the VIN? I will be having our secretary producing these VINâ€™s and would like to keep it to where all she has to do is enter the length of the trailer and the year it was produced. Any help would be appreciated.
Thanks Mike

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi Timberline,
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:
=IF(MOD(SUMPRODUCT(B4:I4,B5:I5)+SUMPRODUCT(K4:R4,K5:R5),11)=10,"X",MOD(SUMPRODUCT(B4:I4,B5:I5)+SUMPRODUCT(K4:R4,K5:R5),11))
In this example, this equates to 9.
Have I missed something, or are we on the right path here?
Larry.

Last edited:
Hi indiantrix,
Thanks for the correction, you are right it should be a 0 in column 15, it has been a long day. That being said it looks like to me that not only are you on the right path but you are paving the road. Would you mind taking a look at the spread sheet I have made up and tell me if there is a better way etc... I just want to make this as simple as possible for the lady that is going to be generating the VIN's and as fool proof as possible, I have already had to deal with the Federal Government because some incorrect VIN's were issued. Please email me mike@trccamps.com and I will email you an attachment of the spread sheet.
Thanks
Mike

Hi Mike

It's not a good idea to post your email, because of spam.

I wrote the table with the value of the characters in columns E:F. Column E has text values, including the digits at the end (format the column as text before entering the digits).

In B2:

=SUBSTITUTE(A2,"_",SUBSTITUTE(MOD(SUM((MID(A2,TRANSPOSE(ROW(INDIRECT("1:17"))),1)=\$E\$2:\$E\$34)*\$F\$2:\$F\$34*{8,7,6,5,4,3,2,10,0,9,8,7,6,5,4,3,2}),11),10,"X"))

This is an array formula, you have to confirm it with CTRL+SHIFT+ENTER.

Copy down

Please test with some VIN's and if you find an error post it.

The same formula, but non-array, entered as usual just with ENTER and not with the CTRL+SHIFT+ENTER. In B2:

=SUBSTITUTE(A2,"_",SUBSTITUTE(MOD(SUMPRODUCT((MID(A2,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17},1)=\$E\$2:\$E\$34)*\$F\$2:\$F\$34*{8,7,6,5,4,3,2,10,0,9,8,7,6,5,4,3,2}),11),10,"X"))

I have set up a spread sheet that through v-lookup pulls all of the information for the VIN, model year, trailer type, length, sequence of production, etcâ€¦ These numbers along with the manufacture ID number make up the VIN with the exception of the check digit. There are only six digits that will change in the calculation of the check digit. The model year (yearly change) positions 6&7, Length position 10, and sequence of production position 15, 16, &17. What I have done is a simple equation for this to calculate the product of the VIN multiplied by the various weights.
1T9BV2322AU928058
=SUM((D3*8)+(3*7)+(F3*6)+(2*5)+(5*4)+(I3*3)+(J3*2)+(K3*10)+(1*9)+(4*8)+(O3*7)+(P3*6)+(Q3*5)+(R3*4)+(S3*3)+(T3*2))
The sum of this equation is 332 which is then divided by 11 giving me 30 and 2/11 making the check digit 2 which is then put in as the 9<sup>th</sup> digit.
<table class="MsoNormalTable" style="width: 357pt; margin-left: 5.15pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="476"> <tbody><tr style="height: 15pt;"> <td rowspan="2" style="width: 50pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" width="67">
[FONT=&quot]Customer<o></o>[/FONT]
</td> <td rowspan="2" style="width: 41pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="55">
[FONT=&quot]Trailer Size<o></o>[/FONT]
</td> <td colspan="17" style="width: 191pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="255">
[FONT=&quot]VIN Calculation<o></o>[/FONT]
</td> <td colspan="3" rowspan="2" style="width: 75pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" width="100">
[FONT=&quot]Check Digit Calculation<o></o>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td colspan="3" style="width: 33.1pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="44">
[FONT=&quot]WMI<o></o>[/FONT]
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17">
[FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17">
[FONT=&quot] <o></o>[/FONT]
</td> <td colspan="2" style="width: 21.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="28">
[FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17">
[FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18">
[FONT=&quot] <o></o>[/FONT]
</td> <td colspan="3" style="width: 31.95pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="43">
[FONT=&quot]WMI<o></o>[/FONT]
</td> <td colspan="3" style="width: 31.95pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="43">
[FONT=&quot] <o></o>[/FONT]
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Inventory<o></o>[/FONT]
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
[FONT=&quot]18<o></o>[/FONT]​
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
3<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]5<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]332<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]30 2/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot]2<o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Inventory<o></o>[/FONT]
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
[FONT=&quot]14<o></o>[/FONT]​
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
1<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
9<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
5<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
9<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]343<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]31 2/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot]2<o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Inventory<o></o>[/FONT]
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
[FONT=&quot]12<o></o>[/FONT]​
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
1<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
7<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
5<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
6<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]324<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]29 5/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot]5<o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Inventory<o></o>[/FONT]
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
[FONT=&quot]16<o></o>[/FONT]​
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
1<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
9<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
6<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
1<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]317<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]28 9/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot]9<o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot] <o></o>[/FONT]
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
<o></o>
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
6<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]311<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]28 3/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot] <o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> <o></o>
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
<o></o>
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
6<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
3<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]313<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]28 5/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot] <o></o>[/FONT]​
</td> </tr> <tr style="height: 15pt;"> <td style="width: 50pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="67"> <o></o>
</td> <td style="width: 41pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="55">
<o></o>
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]1<o></o>[/FONT]​
</td> <td style="width: 11.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="16"> [FONT=&quot]T<o></o>[/FONT]
</td> <td style="width: 10.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 12.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]B<o></o>[/FONT]
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]V<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
2<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
0<o></o>
</td> <td style="width: 12.6pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="17"> [FONT=&quot]A<o></o>[/FONT]
</td> <td style="width: 13.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="18"> [FONT=&quot]U<o></o>[/FONT]
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]9<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]2<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]8<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
[FONT=&quot]0<o></o>[/FONT]​
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
6<o></o>
</td> <td style="width: 10.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="14">
4<o></o>
</td> <td style="width: 21.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="29">
[FONT=&quot]315<o></o>[/FONT]​
</td> <td style="width: 45.85pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]28 7/11<o></o>[/FONT]​
</td> <td style="width: 7.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="10">
[FONT=&quot] <o></o>[/FONT]​
</td> </tr> </tbody></table> <o> </o>
Here is the spread sheet I have been working on, once the trailer length is entered it will look up and add the 6 &7 digits. I will change the 10<sup>th</sup> digit at the first of the model year. So it is very simple with the exception of the check digit which at this point we have to manually put into the right hand column of the check digit calculation section and then the formula which is in the 9<sup>th</sup> digit column of =V3 which of course is the number we manually put in.
I am just trying to make this as simple as I can for the lady who will be generating the VINâ€™s for our federally labels. I would like to get it to where all she has to do is enter the size of the trailer and that the spread sheet she works with looks basically like the one above minus the check digit calculation portion. This sure would be easier if I could just attach the spread sheet as good as you guys are at this you would have me helped out in no time.

Mike

See if this helps. I used columns W:X as auxilliary, with a table with the correspondences you posted. Make sure the digits in W25:W34 are entered as text (first format the cells as text and then enter the digits). The numbers in column X are real numbers, not text (format the column X as General and then enter the numbers).

The sum, in T3:

=SUMPRODUCT(N(OFFSET(\$X\$2,MATCH(CHOOSE({1;2},C3:J3,L3:S3)&"",\$W\$2:\$W\$34,0)-1,0))*{8,7,6,5,4,3,2,10;9,8,7,6,5,4,3,2})

The check digit, in U3:

=SUBSTITUTE(MOD(T3,11),10,"X")

The check digit, in K3:

=U3

Copy the formulas in T3, U3 and K3 down.

You can, if you want, not use the T3:U3 cells and just use a formula in K3. I just followed your layout.

Last edited:
Thanks PGC,
This helped emensly. I understand the formula and how that you are calculating the VIN by converting the Alpha digits as part of the formula. I really don't need to do this. at this point in the construction of trailers, the only alpha character that changes is the one for the production year. I did however use the formula "The check it, in U3:
=SUBSTITUTE(MOD(T3,11),10,"X") " that you provided. works great, moved some columns around, hide some others and now I have a simple spread sheet that all the secretary has to do is punch in the length of the trailer and just like magic it generates the VIN, give a nice neat list so that we can track the the trailers and VINs along with any customer info we need to all on the same sheet. It's great.
Thanks so much, one less thing I have to worry about.
Thanks again to both PGC and indiantrix,
Mike

Replies
7
Views
1K
Replies
1
Views
508
Replies
2
Views
1K
Replies
0
Views
396
Replies
1
Views
1K

1,217,357
Messages
6,136,081
Members
449,990
Latest member
orthodmd

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browserâ€™s toolbar.
2)Click on the icon in the browserâ€™s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browserâ€™s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browserâ€™s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browserâ€™s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back