ARKF05 Example - Handling Missing Time Between Sound Files

Split intervals get merged into a single interval

Due to gaps in the sound files the resulting PSD values in the CSV output will break up the minute intervals, creating two smaller ones that occur due to a time gap. The user may want to represent all time intervals, including the split ones, into “nearly” 60-minute intervals. To do this, an option exists in the MANTA UI that will combine all the split-intervals caused by time gaps. The option is shown below.

Before and after results for an example CSV are shown below.

‌

Single Time Gaps in a minute interval

‌

Given the following Sound Set

Table below considers a sequency of 6 files (n=6), sample rate of 48kHz and files n=1 to n= 5 have exactly 28800000 samples, or 600 seconds per file.

From the original time stamps on the sound files, there are two gaps shown below (red).

Table below shows the values from Raven-X, the same time gaps are shown

‌

The example below shows where the gaps occur, and results of Raven-X merging those intervals.

CSV before the merge

24-Jul-2016 00:24:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:25:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:26:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:27:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:28:00,29,0,0,0,0,0,0,0,0,0,0  << GAP01 start
24-Jul-2016 00:28:30,30,0,0,0,0,0,0,0,0,0,0  << GAP01 end
24-Jul-2016 00:29:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:30:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:31:00,60,0,0,0,0,0,0,0,0,0,0

24-Jul-2016 00:36:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:37:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:38:00,30,0,0,0,0,0,0,0,0,0,0  << GAP02 start
24-Jul-2016 00:38:31,29,0,0,0,0,0,0,0,0,0,0  << GAP02 end
24-Jul-2016 00:39:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:40:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:41:00,60,0,0,0,0,0,0,0,0,0,0


24-Jul-2016 00:52:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:53:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:54:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:55:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:56:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:57:00,60,0,0,0,0,0,0,0,0,0,0  << GAP03 start
24-Jul-2016 00:58:00,31,0,0,0,0,0,0,0,0,0,0  << GAP03 end
24-Jul-2016 00:58:32,28,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:59:00,60,0,0,0,0,0,0,0,0,0,0

Start of Next Day

24-Jul-2016 01:00:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:01:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:02:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:03:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:04:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:05:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:06:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:07:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:08:00,32,0,0,0,0,0,0,0,0,0,0

‌

CSV after the merge

24-Jul-2016 00:08:29,31,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:09:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:10:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:11:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:12:00,60,0,0,0,0,0,0,0,0,0,0
  ....
24-Jul-2016 00:26:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:27:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:28:00,59,0,0,0,0,0,0,0,0,0,0  << GAP01 merged
24-Jul-2016 00:29:00,60,0,0,0,0,0,0,0,0,0,0
 ....
24-Jul-2016 00:36:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:37:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:38:00,59,0,0,0,0,0,0,0,0,0,0  << GAP02 merged
24-Jul-2016 00:39:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:40:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:41:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:42:00,60,0,0,0,0,0,0,0,0,0,0
 ....
24-Jul-2016 00:55:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:56:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:57:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:58:00,59,0,0,0,0,0,0,0,0,0,0  << GAP03 merged
24-Jul-2016 00:59:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:00:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:01:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:02:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:03:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:04:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:05:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:06:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:07:00,60,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:08:00,32,0,0,0,0,0,0,0,0,0,0




...

‌

Multiple Time Gaps in a minute interval

24-Jul-2016 00:54:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:55:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:56:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:57:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:58:00,25.9999791666667,0,0,0,0,0,0,0,0,0,0  << start of interval 
24-Jul-2016 00:58:28,1.9999791666667,0,0,0,0,0,0,0,0,0,0   << gap 1
24-Jul-2016 00:58:32,27.9999791666667,0,0,0,0,0,0,0,0,0,0  << gap 2
24-Jul-2016 00:59:00,58.9999791666667,0,0,0,0,0,0,0,0,0,0

‌

24-Jul-2016 00:53:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:54:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:55:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:56:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:57:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 00:58:00,55.9999375000001,0,0,0,0,0,0,0,0,0,0   << merged 2 gaps
24-Jul-2016 00:59:00,58.9999791666667,0,0,0,0,0,0,0,0,0,0    
24-Jul-2016 01:00:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:01:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:02:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:03:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0
24-Jul-2016 01:04:00,59.9999791666667,0,0,0,0,0,0,0,0,0,0

‌