Rank

Hi everyone,

i have to track the performance of some sales Reps, p

All performance is measured on a composite basis with sales performance representing 50% (the higher the better), Customer Feedback 30% (the higher the better), and Average time spent per account 20% (the lower the better).

any ideas on how i can do this? on excel 2010?

Thanks for the reply.
I'm probably not allowed to post the data for confidentiality reasons, basically I have a pivot table,
Where

% of Sales Goal % of Customer Feedback Goal Time spent per account
REP A 150% 99% 300mins
REP B 80% 97 % 200mins

Performance has a weighted rank – 50% goes to the sales goal - 30% customer feedback – 20% efficiency (time spent per account)

I’m thinking about making a field in the pivot table with the formula

(.5 x % of sales goal) + (.3 x % of Customer feedback goal) ….. would this even work? And how would I do the time spent per account since it’s not in a percentage and the lowest time spent should get the highest rank.

Thanks in advance!