This topic has been locked.
9 replies Latest Post - 2012-04-17T07:38:58Z by SystemAdmin
Pinned topic nmon analyzer Excel timeline out of order
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Is anyone having an issue with all graph timelines? I take a nmon file that runs at 5 second intervals for an entire day. When I use the analyzer to convert to Excel all the graphs that have a timeline are all out of order. So starting on the left of the graph should be 00:00 moving in time to the right to 23:59. Well dispersed through out these graphs I have times earlier in time to the right of times later. For instance, 02:00 is to the right of 11:00.
Updated on 2012-04-17T07:38:58Z at 2012-04-17T07:38:58Z by SystemAdmin
Re: nmon analyzer Excel timeline out of order2009-05-20T17:35:54Z in response to SystemAdminWell, are the timestamps in order? I mean, do you see
or are the "Tnnnnn" lines out of sequence? If so, if you sort the ZZZZ sheet in Excel do the timestamps come out right? All seems a bit odd.
You can send me the nmon file if you like and I'll take a look.
steve_atkins at uk.ibm.com
Re: nmon analyzer Excel timeline out of order2009-05-20T18:08:41Z in response to SystemAdminT0999 1:23:22 18-May-09 01:23
T1000 1:23:27 18-May-09 01:23
T10000 13:53:29 18-May-09 13:53
T10001 13:53:34 18-May-09 13:53
T10002 13:53:39 18-May-09 13:53
T10003 13:53:44 18-May-09 13:53
T10004 13:53:49 18-May-09 13:53
T10005 13:53:54 18-May-09 13:53
T10006 13:53:59 18-May-09 13:53
T10007 13:54:04 18-May-09 13:54
T10008 13:54:09 18-May-09 13:54
T10009 13:54:14 18-May-09 13:54
T1001 1:23:32 18-May-09 01:23
This is one clip I will attach one file since they are large
Re: nmon analyzer Excel timeline out of order2009-05-20T18:35:59Z in response to SystemAdminI see the problem.
The timestamps are being generated incorrectly. T0999 should be T00999 in order to sort correctly.
Is this topasnmon you're using or nmon classic?
If it's topasnmon then you need to put in a call to IBM support.
Re: nmon analyzer Excel timeline out of order2012-02-06T11:58:08Z in response to SystemAdminI've worked out a quick fix for my Excel 2007.
1. With the latest 3.3g up to this moment, find the string "ZZZZ" in the macro editor. (Sorry that I'm not with an Excel right now.)
2. There is a loop trying to calculate the timestamp column. There are 2 lines:
a... = ... format(Tn, "0000")...
Change the format code "0000" to "00000"
3. Save the changes.
This just pads an additional zero to the timestamp so that the sorting can work as expected.
The fix works for me to draw charts for merging 180 nmon files(96 readings each).
cjy452 270004WJDE1 PostACCEPTED ANSWER
Re: nmon analyzer Excel timeline out of order2012-04-17T06:18:13Z in response to SystemAdminCould someone tell me if there is an update to this condition please.
Using topas_nmon 12 with analyzer 3.3g and excel 2007.
Still getting date out of sequence on merged graph sets.