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.
Still more to play with,
Cheers Carl
Magnetometer data experiments
-
- Oh, I get it now!
- Posts: 43
- Joined: Sat Oct 29, 2016 6:38 pm
- Location: Antrim
- Montana
- Way More Fun to Share It!!
- Posts: 20029
- Joined: Mon Oct 17, 2011 5:25 pm
- Location: Cheshire, UK
Re: Magnetometer data experiments
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).
Alexandra

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).
Alexandra
-
- Oh, I get it now!
- Posts: 43
- Joined: Sat Oct 29, 2016 6:38 pm
- Location: Antrim
Re: Magnetometer data experiments
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.

- Carbon60
- Way More Fun to Share It!!
- Posts: 5636
- Joined: Wed Mar 07, 2012 12:33 pm
- Location: Lancashire, UK
Re: Magnetometer data experiments
Nice work Carl.
Looks like it's working well.
Stu.
Looks like it's working well.
Stu.
Lunt LS60THa B1200 PTFT
150mm H-alpha Solar telescope with Lunt35 mod
DMK41, Basler acA1920-155
NEQ6 Pro-mount
Fluxgate Magnetometers (1s and 150s Cadence)
More images at http://www.flickr.com/photos/solarcarbon60/
150mm H-alpha Solar telescope with Lunt35 mod
DMK41, Basler acA1920-155
NEQ6 Pro-mount
Fluxgate Magnetometers (1s and 150s Cadence)
More images at http://www.flickr.com/photos/solarcarbon60/
-
- Oh, I get it now!
- Posts: 43
- Joined: Sat Oct 29, 2016 6:38 pm
- Location: Antrim
Re: Magnetometer data experiments
Cheers Stu as usual work in progress.
Carl
Carl
- marktownley
- Librarian
- Posts: 24840
- Joined: Tue Oct 18, 2011 5:27 pm
- Location: Brierley Hills, UK
- Contact:
Re: Magnetometer data experiments
Very interesting, thanks!

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!
- Montana
- Way More Fun to Share It!!
- Posts: 20029
- Joined: Mon Oct 17, 2011 5:25 pm
- Location: Cheshire, UK
Re: Magnetometer data experiments
Very nice addition! looks like it is working well 
Alexandra

Alexandra
Who is online
Users browsing this forum: No registered users and 4 guests