The Packets worksheet displays all the packet summary information.
The packet index, flow id (TCP/UDP), source and destination address, packet size, relative time , IPID (if available), TTL (if available), Protocol and decode summary are generated into different columns.
The Protocol and Summary column are rendered in color to easily distinguished, be noticed that Office 2003 and Office 2007 generated result uses different color rendering theme in BoneLight. So the color will be different for the single file under Excel 2003 and Excel 2007 environment.
The Excel Autofilter feature is activated, so we can see a small arrow icon appears in each column header. By select the arrow icon, you can choose which data to be filtered to see, e.g. we can select HTTP from Protocol column and see all packets talks HTTP protocol just by 2 clicks.
The Autofilter in TTL column can be useful to find out whether there is a routing loop or some packet failed to reach destinations.
The IPID column can be determine whether a retransmission or packet drop happens in the traffic captured.
We can insert more rows or freely add some functions to calculate needed information by ourselves in the sheet.