Hi All
Im trying to make a big fuss of nothing.. hitting my head instead of thinking calm. Appreciate any help on my issue.
I'm trying to rate a set of servers with respect to the no. of alerts which they throw.
Rating being 1-Red, 2-Amber, 3-Green...
Overall average here being = 7, server 1 to server 23 are 1-Red
Take an average from Server 24 to Server 41, which is 5 here.( point where the no. of alerts gets lesser than the overall average(7))
and rate the servers which are in between overall average(7) and the new average(5) as 2 -Amber
Servers below new average(5) are 3-Green
Please help me to accomplish this one..
[TABLE="width: 215"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Server 1[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Server 2[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Server 3[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 4[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 6[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 7[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 10[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 11[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 13[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 14[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 15[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 16[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 17[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 18[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 19[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 20[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 21[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 22[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 23[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 24[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 25[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 26[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 27[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 28[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 29[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 30[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 31[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 32[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 33[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 34[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 35[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 36[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 37[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 38[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 39[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 40[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 41[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance guys
Im trying to make a big fuss of nothing.. hitting my head instead of thinking calm. Appreciate any help on my issue.
I'm trying to rate a set of servers with respect to the no. of alerts which they throw.
Rating being 1-Red, 2-Amber, 3-Green...
Overall average here being = 7, server 1 to server 23 are 1-Red
Take an average from Server 24 to Server 41, which is 5 here.( point where the no. of alerts gets lesser than the overall average(7))
and rate the servers which are in between overall average(7) and the new average(5) as 2 -Amber
Servers below new average(5) are 3-Green
Please help me to accomplish this one..
[TABLE="width: 215"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Server 1[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Server 2[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Server 3[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 4[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 6[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Server 7[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 10[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 11[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 13[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 14[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Server 15[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 16[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 17[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 18[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Server 19[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 20[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 21[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 22[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 23[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Server 24[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 25[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 26[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 27[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 28[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 29[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Server 30[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 31[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 32[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 33[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 34[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 35[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 36[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 37[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 38[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 39[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 40[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Server 41[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance guys