Thank you - here it is. Many thanksdanagsf
You should upload a sample file here.
Thank you vletm - I need to be able to plot this in a 9 grid box not a 4 box grid, and problem is usually the scales are 1 to 3 for both potential and performance. in my case, the company decided to go with a scale of 1 to 4 for performance and 1 to 3 for potential, so I cannot really place the employees properly as it is not 3x3 - it is 4x3. I can say that for performance 1 and 2 should be considered 'low'. However, I also have an issue with placing because when let's say someone is at 1 potential and 1 performance, they would not be visible in the grid - I think in some cases there is a calibration such as multiplying both sides by a coefficient but not sure how to do it when scales are different...Thanks so much for any ideas you may havedanagsf
There were and still are some links ...
I gotta take care some of those ...
Did You mean this or
did You give other clear idea of Your needs?
Adam | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 4.93333 | 4.21905 | |||
Bob | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5 | 4 | |||
Charlie | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.06667 | 3.78095 | |||
Dan | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.13333 | 3.84762 | |||
Evan | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.2 | 3.91429 | |||
Frank | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.26667 | 4.12381 | |||
Jim | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.33333 | 4.19048 | |||
Jose | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.4 | 4.54286 | |||
Tim | 3 | 2 | B | #N/A | #N/A | #N/A | #N/A | 5.46667 | 4.75238 | |||
Zack | 3 | 2 | G | #N/A | #N/A | 5.53333 | 4.9619 | #N/A | #N/A |
sorry - I don't understand what you mean by giving 2 values from each 'name'? to where?danagsf
Hint: You should give two values from each 'name'; Potential & Performance.
vletm thank you very much for your help. Actually I solved the problem of the 4 and 3 so now I only have 3 and 3. The problem is though what I described in my previous note - the calculation seems to be wrong as some values go over 3 and thus are not plotted in the 9 box - do you know a fix for this issue? thanks again!danagsf
the potential is evaluated on a scale of 1-3 and the performance on a scale of 1 to 4
if potential is 2 and performance is 3 ... total 5 (if no take care of scale)
if only notice value 5 could plot in many possible 'boxes'
... because potential could be 1-4 and performance could be 1-4 ( but total value max 5)
( eg potential = 1 and performance = 4 or potential = 4 and performance = 1 ... plots in different 'box' )
refer to Your used Excel-file as in #8 Reply.
... and
... You should give those values with Excel-file!
I do read messages - it is not what I was asking. The question is more complex and the attached did not solve the issue, but thanks anyway for your help. I will not take any more of the time of this forum. Regardsdanagsf
It would be good sometimes read replies ...
I wrote twice - what You should do ... and so on.
... seem that I should give You a sample ... which would fix this thread ...