calculate value based by replacing letters with numbers

Hello!

I need to take a long alphanumeric number and assign the letter's predetermined values and based on those values mulitply and divide them out for a final figure. Or would it be easier to within an Excel cell with a formula?

for example -

OOLU 708695.


Each letter of the prefix has its own value:

A 10 J 20 S 30
B 12 K 21 T 31
C 13 L 23 U 32
D 14 M 24 V 34
E 15 N 25 W 35
F 16 O 26 X 36
G 17 P 27 Y 37
H 18 Q 28 Z38
I 19 R 29



Each figure of the number has its own value.

1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
0 0



We know that: Now calculate:


O=26 26 X 1 = 26
O=6 26 X 2 = 52
L=23 23 X 4 = 92
U=32 32 X 8 = 256
7=7 X 16 = 112
0=0 0 X 32 = 0
8=8 8 X 64 = 512
6=6 6 X 128 = 768
9=9 9 X 256 = 2304
5=5 5 X 512 = 2560

--------------------------------------------------------------------------------

Total = 6682


Now divide this total by 11:
6682 / 11 = 607.4545


and take the figures after the decimal
and multiply it by 11 to get the check digit.
0.4545 X 11 = 5


The complete number is:
OOLU 708695-5

what do you think?

thanks!