Analyzing NetSim Packet trace using Pivot tables

NetSim Packet trace is saved as a spread sheet and 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, analyse, 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 analyse the packet trace using pivot tables (using Excel 2013)

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

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

Click OK and then the spread sheet will be converted to a table as shown below

Step 2. Next, from the Insert tab, click the PivotTable command.

Step 3. The Create Pivot Table dialog box will appear. Click on OK

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

Step 5. Once you create a Pivot Table, you’ll need to decide which fields to add. Each field is simply a column header from the source data. In the Pivot Table Field List, check the box for each field you want to add.

Step 6. 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.

Step 7. 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

Step 8. The Pivot Table will calculate and summarize the selected fields. In this example, the Pivot Table shows the packets sent from all sources to all destinations.

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

Step 10. 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

Step 11. This will look like

Step 12. 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.

Video: “How to analyze and visualize simulation output data in NetSim” is available at   https://www.youtube.com/watch?v=edcYMxt-UM8&t=1s

For more information on NetSim please visit http://www.tetcos.com