Results 1 to 7 of 7

Need a formula for blended ranking score

Threaded View

  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.

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