Experiment 1: Load the data, then extract relevant RTP packets

Starting with a tab-separated file of the form:

"No."  "Time"    "Source"    "Destination“     "Protocol“   "RSSI"  "Info“

"1443"  "17685.760952"  "90.226.255.70"  "217.211.xx.xx"  "RTP"  ""  "PT=ITU-T G.711 PCMA, SSRC=0x6E21893F, Seq=183, Time=46386 “

Extract the traffic going to me, i.e., with the 217.211.xx.xx destination and Protocol = RTP

⇒Do this by sorting on Protocol and Destination columns 

⇒Select the desired rows and move to new sheet

Note: Either preprocess the “Info” filed into separate columns (for PT, SSRC, Seq, and Time) or write an Excel function to do this for you

---

Transcript

So the first thing I did was, I exported the data in a tab-separated form.  I then extracted the data that I was interested in looking at a particular destination address while looking at a particular protocol. Then I sorted on the column protocol destination, and I moved the results into the spreadsheet.  So, from this data, I could calculate things like what's the mean and inter-arrival time.