|
Host worksheet |
Top Previous Next |
|
Host worksheet presents not only the IP address but the related location information by a ip to location database.
The location and IP value are referenced by PivotTable which is described in Graphs worksheet to generate graphs called location view and IP subnet view. Both graphs reuse the data in the Host sheet, so if we modify the values here, those graphs can be refresh to latest status to reflect the changes lively.
If you click on the Total bytes column and select Sort & Filter feature in Excel ribbon, you can easily get the top-N hosts by bytes or by other columns like packets sent . This operation is just 2 mouse click by select "Sort Z to A" after you select a specific column value.
Many Excel features can be used to strengthen the analysis and understanding to the packets.
Enhanced by PivotTable, Host sheet includes a dynamic table breakdowns the application/protocol talked by a specific host. |