Forum Discussion
Total score
Hello everyone,
Probable a very ease question, but i don't know how to do it. I tried to look it up but i wasn't sure how to find the right way.
So what i want to do is this:
- i have a score form that i want to use to score someones telefoon call.
- It is a yes, no or a does not apply.
- if Yes, you get the total points (you did something good)
- if No, you get 0 points (you did something wrong)
- if does not apply you get nothing (it is not good/bad. It just wasn't needed it does not influence your score)
And here comes my question. If everything is a Yes then i will get total of 25 points = 100% (25 out of 25) but if 1 is a does not apply i don't want it to say 23 out of 25 points = 92%. I want it to tell me i scored 100%.
So basically if you have a does not apply you scored 23 out of 23 but if you have a No you scored 23 out of 25 because you got 0 points for one part
I want excel to know that it does noting with the percent/score if i say it does not apply. I don's want to punish someone if he gets a does not apply. Otherwise it will be the same thing if i would give someone a No (0 points)
Does this makes sense what i'm trying to do? So what is the best way to make this happen?
Thanks for you help!
So i want it to look like this:
Review | Score | Total points you can get if everything is yes | |
Did you do this? | Yes | 10 | 10 |
Did you do this? | Yes | 5 | 5 |
Did you do this? | does not apply | x | 2 |
Did you do this? | Yes | 8 | 8 |
Total score | 23 (so basically 23 out of 23) | 25 | |
Total percent score | 100% |
Review | Score | Total points you can get if everything is yes | |
Did you do this? | Yes | 10 | 10 |
Did you do this? | Yes | 5 | 5 |
Did you do this? | No | 0 | 2 |
Did you do this? | Yes | 8 | 8 |
Total score | 23 (so basically 23 out of 25) | 25 |
Total percent score | 92% |
Different example:
I scored 10 points out of 20 ( i have 1 Yes), because two parts i have 0 points (two No) and 1 part is a does not apply. It is 50%
Review | Score | Total points you can get if everything is yes | |
Did you do this? | Yes | 10 | 10 |
Did you do this? | does not apply | x | 5 |
Did you do this? | No | 0 | 2 |
Did you do this? | No | 0 | 8 |
Total score | 10 (so basically 10 out of 20) | 25 |
Total percent score | 50% |
7 Replies
Hello everyone,
Thanks for the quick reply!! Did not expect such quick and helpful replies!
So i have this now (see attachment). I would like to go one step further.Is it also possible to do the following?:
- if give a NVT (does not apply). That the points will be equally divided over the rest of score form?
So in my form for example you get 4 points if you have a Yes and 0 points if you get a No .Is it possible to divide 4 points over the rest of the form when you get a NVT (does not apply).
So basically the means other parts wille be judged harder.
Once again thanks for the help!
Beoordeling Punten NVT Weging% Ja 4 4 4% Ja 10 10 10% Ja 5 5 5% Ja 3 3 3% Ja 2 2 2% Ja 5 5 5% Ja 22 22 22% Ja 3 3 3% Ja 4 4 4% Ja 2 2 2% Ja 5 5 5% Ja 15 15 15% Ja 2 2 2% Ja 2 2 2% Ja 2 2 2% Ja 2 2 2% Ja 2 2 2% Ja 10 10 10% Total points 100 100 Score 100% You wrote:
Is it also possible to do the following?:
- if give a NVT (does not apply). That the points will be equally divided over the rest of score form?
- So in my form for example you get 4 points if you have a Yes and 0 points if you get a No .Is it possible to divide 4 points over the rest of the form when you get a NVT (does not apply).
- So basically the means other parts wille be judged harder. [emphasis added]
To which my response is that I think your premise is wrong. For two reasons.
- You're whole point of NVT is that it does not apply; right?!. But by judging the others harder, you would be, in effect, reversing that position and making it apply, making it have significance, after all. So there's (at the very least) an appearance of internal inconsistency in your thinking.
- Second, and more theoretical: I don't think it actually makes any significant difference at all. Why not? Because of the distributive properties of addition, followed by conversion to percentage. You're adding equally to the remaining parts. Then basically converting those to percentages anyway. Now, I say that as if I could explain it, as if I know exactly what it means. If it were important, I'd try to articulate it a bit more.
But I really think the first point is the one you should pay attention to: that you seem to be undercutting your very contention that that given dimension isn't important in assessing this person's performance.
As even a further refinement--isn't it wonderful how many ways Excel can do these things?--I took Riny_van_Eekelen's variant and turned the basic matrix of questions and scores into an Excel Table, made the total of the "Possible Points" a calculation, and thus enabled you to have a flexible scoring sheet.
Which is to say, you can now add questions into the middle of the mix, with whatever weight you want--there's no compelling reason why the max score needs to be 100, since you're turning it into a percentage anyway.
This is why Excel is exceptional. So many ways to be creative!
pts: =SUMIF($B$2:$B$5,"<>Does not Apply",C$2:C$5)
total points: =SUMIF($B$2:$B$5,"<>Does not Apply",D$2:D$5)
Tato_89 As a variant, please see attached.
