March 25, 2014
This utility analyses the packets from a trace obtained from Wireshark or other packet analysers and displays a time based ‘bounce‘ diagram’. This utility uses VBA to automate the construction of the bounce diagram from a packet trace imported into excel. Columns in the packet trace may need to be modified to fit the column headers shown in the packets sheet. As with most of our macros they read data rows until a row is reached with a blank first cell. Note that packets are colour coded according to a list in the names sheet.
It is rather basic but does allow end points to be named, conversations to be selected and time intervals defined. Note that the VBA for this utility is not available – on inspection it did not meet our most basic quality standards. If the author no longer understands it … Still the functionality is quite handy!