+ Reply to Thread
Results 1 to 6 of 6

Calculating Supplier Performance Score

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Eskisehir / Turkey
    MS-Off Ver
    Excel 2003
    Posts
    3

    Calculating Supplier Performance Score

    Hello guys,

    I have been searching for something suitable for my case but i failed to find. So i need help.

    I created a document where i will calculate supplier delivery performance score.

    I enter 2 dates as due date and delivery date and the difference between dates are shown as day format.

    For ex. 11 days difference. I calculated the score simple as =100-(differance*10)

    But this formula doesn't work good always. The score exceeds above 100 or below 0. I would like the outcome to be in between 0 and 100.

    What would you recommend for scoring formula?

    Thank you.

    P.S. Sorry i am at work now, system didn't let me upload files to forum. I will upload if needed in the evening.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Calculating Supplier Performance Score

    Perhaps something like
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Calculating Supplier Performance Score

    Or even:

    =MAX(0,MIN(your_formula,100))

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    08-19-2013
    Location
    Eskisehir / Turkey
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculating Supplier Performance Score

    Thank you both. Both your formulas helped but only when number is below 0.

    What i need also, if the number exceeds 100, score should decrease. For example if score is 130, the result should be 100-30=70. I am confused trying this with IF formulas. Could you help me with this formula too please?

  5. #5
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Calculating Supplier Performance Score

    Try

    =MAX(0,MIN(your_formula,100-(your_formula-100),100))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  6. #6
    Registered User
    Join Date
    08-19-2013
    Location
    Eskisehir / Turkey
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculating Supplier Performance Score

    Thank you very much. Hopefully i will learn the formulas myself soon.

    Have a great day guys.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating Position Based on Score
    By shanipk82 in forum Excel General
    Replies: 5
    Last Post: 03-28-2012, 11:31 AM
  2. Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  3. Calculating Monthly & Weekly Performance.
    By Pigggy in forum Excel General
    Replies: 1
    Last Post: 03-04-2012, 04:12 AM
  4. Replies: 4
    Last Post: 01-28-2010, 01:30 PM
  5. Calculating the closest score
    By AussieM8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2007, 08:21 PM

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