+ Reply to Thread
Results 1 to 11 of 11

Rating system

  1. 08-05-2015, 01:00 AM #1
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Rating system

    Hi everyone,

    I am a newbie in using excel but I'm trying to program a rating system using excel. But I can't figure out how to program this outcome:

    1 NC / 3 = S
    2 NC / 3 = NI
    3 NC / 3 = US

    3 is the number of samples.
    (1,2 or 3) NC is the number of non-conformity.

    So if there is 1 NC out of the 3 samples, the rating would be S (satisfactory).
    if there are 2 NCs out of the 3 samples, the rating would be NI (needs improvement)
    if there are 3 NCs out of the 3 samples, the rating would be US (unsatisfactory).

    Is this possible to formulate using excel?
    Thanks.
    Reply With QuoteRegister To Reply
  2. 08-05-2015, 01:04 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Rating system

    Hi Mavi and welcome to the forum,

    Perhaps

    = Choose(NC, "S","NI","US")

    would work for you in your example.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 08-05-2015, 01:14 AM #3
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Re: Rating system

    Hi MarvinP,

    thank you for the quick response!
    I am sorry but I'm really new in using excel...but I tried to type in the formula you gave, it asked for the index_num which should be a number 1-254?
    I don't know what that means...
    Reply With QuoteRegister To Reply
  4. 08-05-2015, 01:20 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Rating system

    You have to replace the NC with number between 1 to 3


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  5. 08-05-2015, 01:48 AM #5
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Re: Rating system

    Hi sixthsense!
    Thank you for that clarification...

    But maybe you can check this out...this is what I want to have as an outcome...i entered this manually, so i wanted to know how to formulate the average rating...

    rating2.JPG
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  6. 08-05-2015, 01:57 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Rating system

    Will be helpful to provide exact solution if you attach a sample file with expected result (Instead of Screenshot).


    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Reply With QuoteRegister To Reply
  7. 08-05-2015, 02:16 AM #7
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Re: Rating system

    Hi Sixthsense,

    I hope this will help...
    The ORANGE data are manual inputs, the RED data (in After sheet) will be the outcome per row (Section 1.0, 2.0, 3.0 and 4.0).

    RatingSample.xlsx
    Reply With QuoteRegister To Reply
  8. 08-05-2015, 02:33 AM #8
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Rating system

    In F3 Cell of Before Sheet


    =CHOOSE(COUNTIF(C3:E3,"US")+1,"S","S","NI","US")


    Drag it down
    Reply With QuoteRegister To Reply
  9. 08-05-2015, 02:44 AM #9
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Re: Rating system

    Sixthsense!
    OMG! It worked!
    I don't know how to drag it down, so i manually changed the cell numbers, but it worked!!! sooo happy and thankful for sharing your expertise in excel!!!
    Reply With QuoteRegister To Reply
  10. 08-05-2015, 02:54 AM #10
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Rating system

    Refer the below link to know how to apply the formula down

    http://blog.contextures.com/archives...-formula-down/


    Alternatively, you can also copy the F3 cell and select the below range and paste. The formula will get auto adjusted when it is pasted in the below cells.
    Reply With QuoteRegister To Reply
  11. 08-05-2015, 10:25 PM #11
    Mavi28
    Mavi28 is offline
    Registered User
    Join Date
    08-04-2015
    Location
    philippines
    MS-Off Ver
    2010
    Posts
    8

    Re: Rating system

    thank you sixthsense!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ELO Rating system
    By Melis K. in forum Excel General
    Replies: 3
    Last Post: 11-23-2013, 01:06 PM
  2. Weekly Rating System
    By swltony in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-14-2012, 01:00 PM
  3. Excel rating system
    By atomickaos in forum Excel General
    Replies: 5
    Last Post: 08-29-2011, 07:10 AM
  4. Rating system build
    By adamwestrop in forum Excel General
    Replies: 10
    Last Post: 08-16-2011, 03:05 PM
  5. Building a rating system
    By adamwestrop in forum Excel General
    Replies: 2
    Last Post: 08-16-2011, 03:59 AM
  6. Rating System Auto-Update?
    By Mike2020 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2007, 11:51 AM
  7. Rating system
    By TTL in forum Excel General
    Replies: 1
    Last Post: 07-10-2007, 12:17 AM
  8. help with my rating system
    By sarina1113 in forum Excel General
    Replies: 3
    Last Post: 10-05-2006, 05:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1