Magnetometer data experiments

[carlosjackal]

Hi all after Stu kindly shared his spreadsheet templates i have been playing in Excel 2016. I wanted to see if i could manipulate the data to show a level bar graph to act as a sort of indicator with colour changes at certain levels.

The bar chart now takes the incoming data every half hour and subtracts the max and min levels in that period. It won't be exactly the same as other magnetometers a there is no North South data but not bad. This is work in progress and needs refined. As there was quite a bit of activity last night i thought i would share. Data from 10:02 21/04/17 until this morning.

mag test2.jpg (28.92 KiB) Viewed 1126 times

mag test.jpg (69.65 KiB) Viewed 1126 times

Still more to play with,
Cheers Carl

[Montana]

Wow! that's an excellent plot

Here is the plot from Lancaster and it looks very similar, not sure if it is the same data analysis but it show 2 peaks but it does included lasts nights hit as well. I'm not sure which hours yours corresponds with (no hrs on X axis).

AuroraWatch.JPG (87.86 KiB) Viewed 1117 times

Alexandra

[carlosjackal]

Thanks Alexandra here is a plot for the same period you posted. I think the lack of N S data to add makes a difference. It does pick up the larger changes however. Bit more playing and tweaking required. Working in Excel is a steep learning curve.

magtest5.jpg (26.82 KiB) Viewed 1111 times

[Carbon60]

Nice work Carl.

Looks like it's working well.

Stu.

[carlosjackal]

Cheers Stu as usual work in progress.

Carl

[marktownley]

Very interesting, thanks!

[Montana]

Very nice addition! looks like it is working well

Alexandra