Find suitable sonar data

[IanMayo]

Our sonar data comes from a spreadsheet with one worksheet per sensor. We've got lots of sets of sonar data.

They only cover relatively small periods of the overall data.

We wish to use a sonar dataset that has broad coverage - so we can look for the most target zigs.

I can provide a spreadsheet with all the datasets in.

I'd like a Gannt chart (or similar) that shows the coverage of the datasets.

One way to visualise this could be:

• scatter chart with time along the bottom, and a y-axis of 0 to 20
• introduce a counter for the sets of sonar data, incrementing by one for each new dataset
• plot one series per sonar dataset, with each sensor cut marked by a point at the relevant time, and the incremental counter as the y value.
• the densely packed points will form a gantt-like bar for the period of coverage.

It will then be possible to intelligently determine which sonar dataset is the best to use.

[IanMayo]

First version received:

Feedback on DropBox version:

• It's not clear what the x-axis represesents. Could it be either calendar time or elapsed seconds?
• There are handful of times when the sensors all gain/lose contact at the same time. If you haven't done so already, could you double-check that this actually happens in the data
• Could you please add Ownship Heading and Noise Source Heading to the secondary axis? These are in columns F and N of the Scenario worksheet.
• It would be slightly easier to navigate the data if the legend items were in same vertical order as in the Gantt chart. I guess this could be achieved by using a reducing counter, rather than an increasing one. (this is especially significant given that we inevitably end up re-using colors)