• 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

vletm

Excel Ninja
 

vletm

Excel Ninja
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.
 
Top