• 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


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

Stack Ranking


New Member

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.



Excel Ninja


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