Magnetometer data experiments

I LOVE finding out about different ways to appreciate the Sun and light in general. Use this forum to post your info or questions about various outside the mainstream ways to appreciate our life giving star!
Post Reply
carlosjackal
Oh, I get it now!
Oh, I get it now!
Posts: 43
Joined: Sat Oct 29, 2016 6:38 pm
Location: Antrim

Magnetometer data experiments

Post by 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
mag test2.jpg (28.92 KiB) Viewed 3770 times
mag test.jpg
mag test.jpg (69.65 KiB) Viewed 3770 times
Still more to play with,
Cheers Carl


User avatar
Montana
Librarian
Librarian
Posts: 34560
Joined: Mon Oct 17, 2011 5:25 pm
Location: Cheshire, UK
Has thanked: 17667 times
Been thanked: 8787 times

Re: Magnetometer data experiments

Post by Montana »

Wow! that's an excellent plot :bow

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
AuroraWatch.JPG (87.86 KiB) Viewed 3761 times
Alexandra


carlosjackal
Oh, I get it now!
Oh, I get it now!
Posts: 43
Joined: Sat Oct 29, 2016 6:38 pm
Location: Antrim

Re: Magnetometer data experiments

Post by 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
magtest5.jpg (26.82 KiB) Viewed 3755 times


User avatar
Carbon60
Way More Fun to Share It!!
Way More Fun to Share It!!
Posts: 14205
Joined: Wed Mar 07, 2012 12:33 pm
Location: Lancashire, UK
Has thanked: 8415 times
Been thanked: 8161 times

Re: Magnetometer data experiments

Post by Carbon60 »

Nice work Carl.

Looks like it's working well.

Stu.


H-alpha, WL and Ca II K imaging kit for various image scales.
Fluxgate Magnetometers (1s and 150s Cadence).
Radio meteor detector.
More images at http://www.flickr.com/photos/solarcarbon60/
carlosjackal
Oh, I get it now!
Oh, I get it now!
Posts: 43
Joined: Sat Oct 29, 2016 6:38 pm
Location: Antrim

Re: Magnetometer data experiments

Post by carlosjackal »

Cheers Stu as usual work in progress.

Carl


User avatar
marktownley
Librarian
Librarian
Posts: 42270
Joined: Tue Oct 18, 2011 5:27 pm
Location: Brierley Hills, UK
Has thanked: 20424 times
Been thanked: 10243 times
Contact:

Re: Magnetometer data experiments

Post by marktownley »

Very interesting, thanks!


Image
http://brierleyhillsolar.blogspot.co.uk/
Solar images, a collection of all the most up to date live solar data on the web, imaging & processing tutorials - please take a look!
User avatar
Montana
Librarian
Librarian
Posts: 34560
Joined: Mon Oct 17, 2011 5:25 pm
Location: Cheshire, UK
Has thanked: 17667 times
Been thanked: 8787 times

Re: Magnetometer data experiments

Post by Montana »

Very nice addition! looks like it is working well :)

Alexandra


Post Reply