Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Points based on goal & weight of measures
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for points if less than goal | Excel Discussion (Misc queries) | |||
Help making postage calculator based on a given weight | Excel Discussion (Misc queries) | |||
how to limit the Weight of any weight distribution | Excel Discussion (Misc queries) | |||
Adding weight measures | Excel Worksheet Functions | |||
Calculate needed gallons of water, based on weight of person | Excel Worksheet Functions |