• 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

S

sms2luv

Member
Hi All,
I have made a Stack Ranking File, which I have attached.
The file is Working great but had confusion related to the points.
If you see the file there are 6 Parameter.
For the First 3 parameters lower number is better and should get higher points, but its opposite as of now.
the last 3 Parameter are working as deseigned and the problem is only with the 1st 3 parameters.
please tell me how can formulate the 1st 3 parameters so that lower number are scored high
 

Attachments

  • test.xlsx
    16.6 KB · Views: 6
If you want to use Lower as having more value simply use (Maximum Possible Parameter Value - Parameter Value) instead of Parameter Value in your Rank calculations
 
Hi ,

Shouldn't the calculations for the first 3 parameters be as shown in the uploaded file ?

Narayan
 

Attachments

  • test (4).xlsx
    17.3 KB · Views: 7
You must log in or register to reply here.
Back
Top