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?