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
- Librarian
- Posts: 34722
- Joined: Mon Oct 17, 2011 5:25 pm
- Location: Cheshire, UK
- Has thanked: 17974 times
- Been thanked: 8907 times
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: 14315
- Joined: Wed Mar 07, 2012 12:33 pm
- Location: Lancashire, UK
- Has thanked: 8559 times
- Been thanked: 8297 times
Re: Magnetometer data experiments
Nice work Carl.
Looks like it's working well.
Stu.
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/
Fluxgate Magnetometers (1s and 150s Cadence).
Radio meteor detector.
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
- marktownley
- Librarian
- Posts: 42551
- Joined: Tue Oct 18, 2011 5:27 pm
- Location: Brierley Hills, UK
- Has thanked: 20822 times
- Been thanked: 10498 times
- 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
- Librarian
- Posts: 34722
- Joined: Mon Oct 17, 2011 5:25 pm
- Location: Cheshire, UK
- Has thanked: 17974 times
- Been thanked: 8907 times