Hey all,
I am new to the forums, but a long time site user and I was hopeing someone out there would be able to help me figure this out.
I am working on a project in which we are attempting to compare some recorded numbers.
What we have:
A = the number of issues assigned to a specific person
B = the percentage of the number of issues assigned to the person that were completed on time
C = the sum of all issues assigned to all the users
What we are looking to do:
We want to use the A and B values from above to establish a ranking system that will allow us to determine who is doing the best overall. We need to take into account the number of issues that were assigned to make sure that someone that attends to 100 issues and is on time 100% gets more credit than someone who attends to 10 issues and is on time 100%. It does not matter how they are ranked or with what values, as long as it is a consistent result.
The formula I have in Excel right now:
=STDEV(A,B,C)
What it is giving to me:
It is giving me a number that appears to be correct, but it is inverted. So the lower the number, the better the score.
Problems:
There are two of these.
1) What is this number that Excel is giving to me? I have asked multiple people and attempted to find answers on the web, but was unable to find anything.
2) Is there a better way to do this without macros?
Thanks all for the help!
Brandon
I am new to the forums, but a long time site user and I was hopeing someone out there would be able to help me figure this out.
I am working on a project in which we are attempting to compare some recorded numbers.
What we have:
A = the number of issues assigned to a specific person
B = the percentage of the number of issues assigned to the person that were completed on time
C = the sum of all issues assigned to all the users
What we are looking to do:
We want to use the A and B values from above to establish a ranking system that will allow us to determine who is doing the best overall. We need to take into account the number of issues that were assigned to make sure that someone that attends to 100 issues and is on time 100% gets more credit than someone who attends to 10 issues and is on time 100%. It does not matter how they are ranked or with what values, as long as it is a consistent result.
The formula I have in Excel right now:
=STDEV(A,B,C)
What it is giving to me:
It is giving me a number that appears to be correct, but it is inverted. So the lower the number, the better the score.
Problems:
There are two of these.
1) What is this number that Excel is giving to me? I have asked multiple people and attempted to find answers on the web, but was unable to find anything.
2) Is there a better way to do this without macros?
Thanks all for the help!
Brandon