Home
News
Our Products
Downloads
Purchase
Contact Information
About Us
Nessoft logo
Knowledgebase Top : PingPlotter : Usage
Exporting / Analysis in Excel
ID: 000018
Rating: 5.0 / 5.0 (11 votes)
 
Views: 4836

Question

How do I export data from Ping Plotter into Excel, and then see the Average times and packet loss?


Answer

Ping Plotter 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 Ping Plotter 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:

Ping Plotter 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.


Rating
Did you find this article helpful? 

Related Articles
Exporting Data
Time graph packet loss height
Using PingPlotter to troubleshoot World of Warcraft
What's "Normal" for latency and packet loss?
Errors when running Kaspersky Antivirus

E-mail us