A
amh3258
Hi,
I'm trying to count the number of mouse calls in a sound file and use
another program to detect and count these calls, but to get all of th
calls I had to use two different detectors on the file, which cause
many of the calls to be counted twice, (once each by the two detectors)
Now I want to use excel to exclude all of the calls that were counte
twice and get a total count. I have information on the start and sto
times for each call counted, but these are different depending on whic
detector is used, even for the same call. I was wondering if there i
some way to get excel to count the calls, but only count the double
once by excluding ones that overlap. Thanks!
Example:
Detector 1 Detector 2
Start Time End Time Start Time End Time
1 0.205 0.227 0.203 0.236 <- These ar
happening at
2 2.415 2.443 0.323 0.371 the same time
3 2.567 2.632 0.605 0.689
4 2.76 2.849 2.392 2.457
5 2.957 3.021 2.517 2.652
6 3.085 3.097 3.325 3.389
7 3.147 3.233 3.547 3.589
8 3.325 3.383 3.628 3.687
9 3.565 3.584 4.593 4.648
10 3.628 3.664 4.737 4.8
11 4.091 4.136 4.84 4.96
I'm trying to count the number of mouse calls in a sound file and use
another program to detect and count these calls, but to get all of th
calls I had to use two different detectors on the file, which cause
many of the calls to be counted twice, (once each by the two detectors)
Now I want to use excel to exclude all of the calls that were counte
twice and get a total count. I have information on the start and sto
times for each call counted, but these are different depending on whic
detector is used, even for the same call. I was wondering if there i
some way to get excel to count the calls, but only count the double
once by excluding ones that overlap. Thanks!
Example:
Detector 1 Detector 2
Start Time End Time Start Time End Time
1 0.205 0.227 0.203 0.236 <- These ar
happening at
2 2.415 2.443 0.323 0.371 the same time
3 2.567 2.632 0.605 0.689
4 2.76 2.849 2.392 2.457
5 2.957 3.021 2.517 2.652
6 3.085 3.097 3.325 3.389
7 3.147 3.233 3.547 3.589
8 3.325 3.383 3.628 3.687
9 3.565 3.584 4.593 4.648
10 3.628 3.664 4.737 4.8
11 4.091 4.136 4.84 4.96