Can you help me chart this data?

[Patti W]

I cannot find a way to chart this data - can anyone make suggestions: The
data represents each of our servers by component ID, age, End of service
life, failures, MTBF, Maint cost and business unit.

The corresponding values are scored - the goal is to identify assets to be
tech refreshed by thier score, ie. if a component has a lot of failures and
it is really old, we may decide to tech refresh.


ID Age EOSL Failures MTBF Maint Cost BU
C102204 7 12/31/2010 4 688 £5,460 Corporate
Score 3 10 3 10 10

C194606 5 12/31/2010 25 4 £5,460 GMS
score 9 10 10 9 10 6 76
C194607 5 12/31/2010 4 52 5,460 R&D
score 9 15 10 6 5 6
C194608 5 12/31/2010 Standard 3 44 £5,460 Corporate
score 3 10 10 6 10 12 87
C28115 9 12/31/2010 Standard 135 33 £5,460 Corporate
score 6 10 5 9 10 6 82
C28116 9 12/31/2010 Standard 27 169 £5,460 Corporate
score 9 5 10 9 5 6 78
C28117 9 12/31/2010 Standard 7 569 £5,460 Corporate
score 9 15 15 9 15 18 107
C28118 9 12/31/2010 Standard 182 23 £5,460 Corporate
score 3 15 15 9 10 6 87
C28120 9 12/31/2010 Standard 16 226 £5,460 Corporate
score 6 15 10 6 15 12 105
C28122 9 12/31/2010 Standard 6 589 £5,460 Corporate
score 3 10 10 3 15 12 95
C28124 9 12/31/2010 Standard 4 445 £5,460 Corporate
score 9 10 10 9 10 6 76
C28125 9 12/31/2010 Standard 9 361 £5,460 Corporate
score 9 10 10 9 10 6 76
C28126 9 12/31/2010 Standard 20 216 £5,460 Corporate
score 9 10 10 9 10 6 76

 

[JLatham]

If I'm reading this correctly, each system has 2 rows of information, with
the 'scores' being on the row below various values for the system.

I'd rearrange the data so that the scores are on the same row with the other
system information. That should make it easy to chart it all out. Also, I
notice that it appears some systems have 5 scores, some 6 and some 7. Being
consistent in providing all scores for each system will help you also.