Applicable Versions
NetSim AcademicNetSim StandardNetSim Pro


Analyzing Packet trace using Pivot tables

NetSim Packet trace is saved as a spreadsheet. This file can be converted to an Excel table to make the management and analysis of data easier. A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet

PivotTables are a great way to summarize, analyze, explore, and present your data, and you can create them with just a few clicks. PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your results. You can also create Pivot Charts based on PivotTables that will automatically update when your PivotTables do.

Following are the steps to analyze the packet trace using pivot tables (using Excel 2013)


  1. Click on a cell and then click on Format as Table



2. The Excel would ask you for the range of the data set and in general, Excel would automatically choose till the last row, as shown below:


3. Click Ok and then the spreadsheet will be converted to a table as shown below




4.  Next, from the Insert tab, click the PivotTable command.




5. The Create PivotTable dialog box will appear. Click on OK



6. A blank PivotTable and Field List will appear on a new worksheet.



7. Once you create a PivotTable, you'll need to decide which fields to add. Each field is simply a column header from the source data. In the PivotTable Field List, check the box for each field you want to add. 


8. If you want to analyse packets sent from all sources to all destinations, then check SOURCE_ID, DESTINATION_ID and CONTROL_PACKET_TYPE/APP_NAME. 


9. The selected fields will be added to one of the four areas below the Field List. Click SOURCE_ID, hold it and drag to the ROW field. Similarly, DESTINATION_ID to COLUMNS and CONTROL_PACKET_TYPE/APP_NAME VALUES 


10. The PivotTable will calculate and summarize the selected fields. In this example, the PivotTable shows the packets sent from all sources to all destinations.



11.  The above example shows all the packets which including data packets and control packets. 


12. If you wish to know how many were Data and how many were control packets then, check the PACKET_TYPE and drag it to the ROWS field.



13. This will look like



14. Further, if you wish to know how many packets got errored and how many were successful, check the PACKET_STATUS field and drag it to the ROWS field.