itsmevic
asked on
This Probably Isn't Technically Possible But will Ask Anyway (Excel Macro 2010, VBSCRPT - Pulling Patterns)
Hey there Experts!
I'm curious if a macro, add-in or third party type software can be invoked in a spreadsheet that will detect time patterns.
For example, I'm looking at IP's, there are date time stamps associated with each IP . My pivot table is broken down by IP address and under that the dates and times. What I"m looking for is patterns....
Let's say under IP 1.1.1.1 I have a date/time stamp of 08/24/2012 13:52 and then 3 minutres later another 13:55 and 3 minutes later 13:58 and then 2 minutes later 13:60 and then it repeats...trying to target behavior like that. Is there anything remotely out there that can assist me in identifying this behavior or is the human eye going to be the only work-around in this scenerio?
Example of my Pivot Table data:
0.0.0.0 <--IP Address
8/24/2012 13:52 <---Dates and Tims
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:57
8/24/2012 13:58
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 14:00
8/24/2012 14:00
8/24/2012 14:00
1.1.1.1
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
I'm curious if a macro, add-in or third party type software can be invoked in a spreadsheet that will detect time patterns.
For example, I'm looking at IP's, there are date time stamps associated with each IP . My pivot table is broken down by IP address and under that the dates and times. What I"m looking for is patterns....
Let's say under IP 1.1.1.1 I have a date/time stamp of 08/24/2012 13:52 and then 3 minutres later another 13:55 and 3 minutes later 13:58 and then 2 minutes later 13:60 and then it repeats...trying to target behavior like that. Is there anything remotely out there that can assist me in identifying this behavior or is the human eye going to be the only work-around in this scenerio?
Example of my Pivot Table data:
0.0.0.0 <--IP Address
8/24/2012 13:52 <---Dates and Tims
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:57
8/24/2012 13:58
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 14:00
8/24/2012 14:00
8/24/2012 14:00
1.1.1.1
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.