Knowledge Base

Exporting / analysis in Excel

Question

How do I export data from PingPlotter into Excel, and then see the average times and packet loss?

Solution

PingPlotter allows you to export data to a text file (File -> Export to text file), which you can then import into a package like Excel. If you save the export with a .CSV extension, then you'll be able to just open the file in Excel.

Here are the settings you might use during the export (note that you can focus in a certain time period by using the PingPlotter interface to find a period in question, set your "Samples to include", and then when you go to export, these settings will be pulled in to the export dialog).

This will get you a file that you can then import into Excel and do some statistical analysis and graphing. Only the raw data is included (no min/max/avg/PL%), so you'll need to add columns to calculate those values. Here is an example spreadsheet and dataset that does this:

PingPlotter Excel Import Example.zip (~700K)

Note that this isn't a template, it's an example. You'll have to do some work to make it all solve the issues you're after.

If you come up with a nice graph you think others would find useful, or some techniques for making this easier/better, please send it to us at support@pingplotter.com and we'll add it to our knowledge base.


Article Rating (12 Votes)

Rate this article


Article Info

Article Number: 18 | Last Updated: March 28, 2017

This article has been viewed 13896 times since October 21, 2003

Filed Under: Usage

Attachments

There are no attachments for this article.