• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stack Ranking

Build4excel

New Member
Team,

I want to build score card based on employee performance.
Attaching excel file for reference.
I have 7 metric with Targets and their weightage.

I would like to know how can I use formula in Column J to P to calculate their score and in column Q their total score followed by their Rank.
 

Attachments

  • test.xlsx
    10.7 KB · Views: 8
Build4excel
Have You checked You I-column?
If Target is 90% and Metric 7-values are >= 90 ( x100) then Score would be ... hmm?
 

Attachments

  • test.xlsx
    12.1 KB · Views: 8
Build4excel
...hmm?
If Metrics -3,-4,-5 give with as You've given then what else should those results be?
If You would like to see as decimals, then ... format Your output as You would like to see.
I was more worry about Metric 7-values, which are x100 with its target.
 
Back
Top