A series of weighted variables for a percentage ranking

Hello,

I've attached the excel file that showcases the break out.

Ultimately there 6 vendors (labeled A - F) the various categors and each vendors ranking within each out 6 categories left to right. How do I calculate a combined weighted ranking formula?:
- Category 1, weighted 20%, - (value 1 - 100)
- Category 2, weighted 20%, - (value 1 - 5, w/ 5 being the highest)
- Category 3, weighted 20%, - (value 1 - 5, w/ 5 being the highest)
- Category 4, weighted 20%, - (value 1 - 100)
- Category 5, weighted 10%, - (value 1 - 5, w/ 1 being the highest)
- Category 6, weighted 10%, - (value 1 - 5, w/ 5 being the highest)

Categories (weighted)>>>>>>
A 75 4 2 55 5 4 = (A % Ranking result Formula???? )
B 65 2 5 70 4 3 = (B % Ranking result Formula???? )
C 70 4 4 66 3 5 = (C % Ranking result Formula???? )
D 45 1 3 40 3 3 = (D % Ranking result Formula???? )
E 55 3 3 52 5 3 = (E % Ranking result Formula???? )
F 45 1 4 80 2 4 = (F % Ranking result Formula???? )