Ok we are trying to rate certain staff members on their performance. We have five different performance categories where the ratings are 1-5 for each. Additionally, is category has a specific weight based on its importance.
For example
"30% Skills / Accuracy"
"25% Professionalism"
"25% Procedural Compliance"
"10% Availability"
"10% Technology / Equipment"
I am tring to get a formula that will work in both 2003 and 2007, that will take into account the weights for each category and realize that if the rating is 5 it is 100% of that category.
Please help, I need this by close of business today.
If you need any additional information, let me know.
Bookmarks