I need to average utilisation values for server names, but the range of
values changes. Please can someone help with a macro for this.
Data example:
Time Duration Utilisation % Server Name
CW001P01-SH-C: CW001P01-SH-C:
2009/09/19 23:56 903 96.6814438
2009/09/20 00:11 899 96.68444105
2009/09/20 00:26 901 96.68782082
2009/09/20 00:56 927 96.69387136
2009/09/20 01:12 872 96.69638761
2009/09/20 01:26 902 96.69934001
2009/09/20 01:41 898 96.70246381
CW001P03-SH-C: CW001P03-SH-C:
2009/09/19 23:56 903 99.20851502
2009/09/20 00:11 900 99.21775174
2009/09/20 00:26 901 99.22421268
2009/09/20 00:41 899 99.22657119
2009/09/20 00:56 928 99.24876246
2009/09/20 01:12 872 99.25364643
2009/09/20 01:26 902 99.2604542
CW001P03-SH-E: CW001P03-SH-E:
2009/09/19 23:56 904 32.10759256
2009/09/20 00:11 899 32.10688525
2009/09/20 00:26 901 32.10960911
2009/09/20 00:41 900 32.10492405
2009/09/20 00:56 927 32.10638105
2009/09/20 01:12 872 32.09597414
2009/09/20 01:26 902 32.09691138
Thanks,