M
Mayte
Hi-
I have no idea is this can be done as a marco but .... wondering if anybody
can give me any suggestions??
I need to do a ranking for my managers. I had a simple ranking:
actual/goal=score and then a raking from 1 to 5 but now my director added a
weight to each measure and that sort threw me off. I honestly went blank
because can't figure out the points using the weight for each measure ....any
ideas??
column-A, measures (all are unique, no duplicates)
column-B, goals (some are greater than and some less than)
column-C, weight for each measure
column-D, actual results
column-E, will have the points scored
column-F, will be the ranking based on the points
A B C D E F
Measure Goal Weight Actual Points Ranking
M-1 >= 85% 45% 45%
M-2 >= 90% 25% 25%
M-3 <= 25% 5% 5%
M-4 >= 95% 10% 10%
M-5 <= 7% 15% 15%
Thanks,
Mayte
I have no idea is this can be done as a marco but .... wondering if anybody
can give me any suggestions??
I need to do a ranking for my managers. I had a simple ranking:
actual/goal=score and then a raking from 1 to 5 but now my director added a
weight to each measure and that sort threw me off. I honestly went blank
because can't figure out the points using the weight for each measure ....any
ideas??
column-A, measures (all are unique, no duplicates)
column-B, goals (some are greater than and some less than)
column-C, weight for each measure
column-D, actual results
column-E, will have the points scored
column-F, will be the ranking based on the points
A B C D E F
Measure Goal Weight Actual Points Ranking
M-1 >= 85% 45% 45%
M-2 >= 90% 25% 25%
M-3 <= 25% 5% 5%
M-4 >= 95% 10% 10%
M-5 <= 7% 15% 15%
Thanks,
Mayte