+ Reply to Thread
Results 1 to 2 of 2

Help on creating report grading calculation method

  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    69

    Help on creating report grading calculation method

    Hello all,

    I'm trying to implement a grading scheme for graded reports I have in a sheet. The grades range from 1-5/A-E, and any report may receive one or more grades or none at all.

    What's important is the number of grades each report has gotten, as well as the grades themselves. I want 1/A grades and 5/E grades to stand out prominently; namely, I want it to be obvious by quick inspection any report has gotten any 1's or 5's, and I also want to assess strength relative to other reports.

    I want to weight the grades in some way, and a provisional method I have is to assign positive or negative points as follows:

    1=7
    2=3
    3=1
    4=-1
    5=-10

    Same thing with A-E.

    Then I simply SUM the points. I also average the scores by the following formula, which ignores 0:

    =IFERROR(SUM(range)/(SUMPRODUCT((range<>0)*1)),0)

    Can I normalize/standardize via this grading scheme? Right now, it's not obvious to me.

    I was also thinking of doing:

    1=100%
    2=90%
    3=70%
    4=50%
    5=30%

    But I don't know the relative merits, especially with weighing the scores and variable quantities of grades.

    I'd appreciate any insight. Tks!
    Last edited by jimbosi; 11-20-2014 at 07:21 AM. Reason: to conform to forum rules

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,571

    Re: Grading Scheme

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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. Replies: 10
    Last Post: 09-08-2014, 08:46 AM
  2. Color Scheme Help
    By rzacharia21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2012, 11:59 PM
  3. Excel 2007 : Salary scheme
    By Skjo in forum Excel General
    Replies: 1
    Last Post: 05-22-2011, 01:02 AM
  4. Color Scheme
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 08-14-2006, 01:45 AM
  5. Color scheme trouble
    By [email protected] in forum Excel General
    Replies: 6
    Last Post: 05-16-2006, 02:45 PM

Tags for this Thread

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