+ Reply to Thread
Results 1 to 7 of 7

Need a formula for blended ranking score

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Phildelphia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Need a formula for blended ranking score

    Hello,

    I need help with a formula to create a blended ranking score. Thanks.

    Column A Column B Column C Column D Column E
    Miles Braking Stops Turns Accel
    139,000 3 26 613 58

    First I need to determine how many incidents per 1000 miles then I need to weight:
    Braking in Column B as 70%
    Stops in Column C as 5%
    Turns in Column D as 15%
    Accel in Column E as 10%

    See attached file.
    Attached Files Attached Files
    Last edited by ensmith; 10-25-2012 at 11:11 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need a formula for blended ranking score

    You example is not clear for me, but i give it a try.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    Phildelphia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Need a formula for blended ranking score

    Thanks but i need to show how many incidents occurred every 1000 miles first then show the weighted result in a %.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need a formula for blended ranking score

    add the desired result in the excel sheet.

    i bet it makes it more clear for (other) forummembers.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    06-26-2012
    Location
    Phildelphia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Need a formula for blended ranking score

    see attached - not sure of desired outcome because i am not sure of the formula to use.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need a formula for blended ranking score

    Is this what you want?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-26-2012
    Location
    Phildelphia
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Need a formula for blended ranking score

    I figured out what i wanted thanks oeldere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1