• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

Data Pattern Software?

I have a spreadsheet that I have to review daily that consist of IP addresses and a timestamps.  I pivot table this data so I can see all the date/time values for each IP address  Then based off that I determine what might be a pattern.  For example, I've got a date time stamp that keeps reflecting outbound activity every 10 minutes.  Naturally, this would raise suspicion and need to be checked.  

I'm using 10 minutes as an example but it might even be something that happening every 5 minutes, then it takes a break and 15 minutes later it trys again every five minutes...I'm looking for patterns.  I'm curious if thier is an Add-In or software that can assist me with this because the worksheet becomes rather large. and sifting through it takes a lot of time.   Nothing replaces the human eye, however I think with something like this it would help greatly.
0
itsmevic
Asked:
itsmevic
  • 4
  • 2
1 Solution
 
RyanProject Engineer, ElectricalCommented:
Couldn't you just look at an average/count by IP address?

If you don't have a lot of IP addresses, you could graph activity as a histogram?  Series by IP, Y axis by count in a time frame, x axis by time frames.
0
 
itsmevicAuthor Commented:
testing this.
0
 
itsmevicAuthor Commented:
Histogram's do not like IP Addresses i.e. it doesn't like the dot.  Take the dot out and the report generates without issue.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
RyanProject Engineer, ElectricalCommented:
I'm confused. Does the histogram idea work or not?
Yes, you may have to massage the data a little bit, although I'm not sure what method you used, as Excel shouldn't care what format the labels(IP addresses) are in, but removing the dots doesn't invalid the method of the answer.
0
 
itsmevicAuthor Commented:
"Histogram's do not like IP Addresses."   It does not work.
0
 
itsmevicAuthor Commented:
Histogram will not work in this case because it's not accepting IP format
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now