Ranking depending on several factors

[vicentiu]

Hi,

I have to make a hierarchy of my employees, taking in consideration the achievemnt of their target.
I'll attach a sample to make it simple to understand.
The are 2 classes of factors: Class I and Class II.
- In Class I (witch counts 75% in total results) there are:
- New deposit - count 75% from class I
- Insurance - count 10% from class I
- Investments fund - count 15% from class I

- In Class II (witch counts 25% in total results) trere are:
- Loan A - count 15% from class II, but the number have a weight of 40% in results, and volume 60%
- Loan B - count 75% from class II, but the number have a weight of 75%, while volume have 25%
- New clients - count 10% from class II

Now, I have to rank the employees taking in consideration the Deviation for all of the factors above (columns E, H, K, P, Q, V, W, Z).

Thank you!