I need help figuring out an easier way to determine occurrences of species from camera trap photos. I don't need regular occurrences, where you count the number of detections within a designated time period. I need to find "independent occurrences", where the detection starts from the first occurrence and all photos within the designated time period are included in that occurrence. The next occurrence starts whenever the next detection occurs and the time period starts again. It is a little confusing so I have attached a subset of my data and an example.
In this example, we used a 60 minute designated time interval. The first detection event would start at 10:03 on 7/1 and all detections between 10:03 and 11:03 would be considered 1 occurrence. In the above example, that would mean that 7/1/2021 at 10:03 and 7/1/21 at 10:11 are condensed into one occurrence. The next detection event would start at 12:43 and go until 13:43, so the detections at 12:43, 12:44, 13:12, 13:14, and 13:40 are all one occurrence. The next detection event would start at 13:44 and go until 14:44, etc.
Is there a way to automate this process in Excel? Our dataset is very large and we are going through all the occurrences manually right now, which takes a lot of time. Any help would be appreciated, thank you!
In this example, we used a 60 minute designated time interval. The first detection event would start at 10:03 on 7/1 and all detections between 10:03 and 11:03 would be considered 1 occurrence. In the above example, that would mean that 7/1/2021 at 10:03 and 7/1/21 at 10:11 are condensed into one occurrence. The next detection event would start at 12:43 and go until 13:43, so the detections at 12:43, 12:44, 13:12, 13:14, and 13:40 are all one occurrence. The next detection event would start at 13:44 and go until 14:44, etc.
Is there a way to automate this process in Excel? Our dataset is very large and we are going through all the occurrences manually right now, which takes a lot of time. Any help would be appreciated, thank you!