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


--
Patti