Magnetospeed Excel Spreadsheet

[walker2713]

I've been using the Magnetospeed almost since they came out a few years ago, and currently am using the V3 model...and very happy with it.

I suspect some of you guys are wizards when it comes to Excel spreadsheets, and that there's a lot that one could do using the Magnetospeed data in some kind of "graph" format to understand and analyse the results in the course of load development.

This is a pretty open ended question, but would like to know if any one is doing something like this, and if so, how a duffer such as myself can benefit?

Many thanks,

George

 

[orbitup]

Great question! I wish I knew how to make charts and graphs with the data. Looking forward to hearing how people use it.

 

[memilanuk]

Not really MagnetoSpeed specific, but perhaps there is something here that would be of interest to you?

There is also an interesting spreadsheet over in the Files section of the ".308 Winchester Only Reloading" group on FaceBook... basically an OCW Load Analysis spreadsheet. I find I have to do a little 'massaging' of the formulas and layout to get it where I want it - but I'm a little persnickety about that sort of thing.

 

[spife7980]

The easiest route is to just drag to select all of the data in your series that you are wanting to see and on the insert tab you can select whatever type of a graph you want, it will spit it out immediately.

If you are wanting to analyze different batches all in the same graph theres a bit of data manipulation to get it to go in correct but I would have to get a sample and start playing with it while Im here at work, cant remember off the top of my head how it comes out and how I would need to organize it.

 

[normmatzen]

I do use EXCEL to analyze my testing data.
I characterize new bullet, load and powder
combinations by shooting 5-6 5 shot groups each with different loads in 1% steps. I shoot round robin and monitor Mv.
Then, I calculate ES for each 5 shot load group and plot ES vs load. Then, I plot avg Mv for each load and plot Mv vs load,

The key item to me is, after plotting ES vs Load, I do a curve fit and select polynomial and increase to 4 or 5th order till the curve doesn't change or I get to 5th order. Now you have a curve that goes through your data points and tells you where your actual null is.

Now that I have the load for best ES ( lowest null in ES vs Load) I shoot 4 shot groups with the new ideal load, 2 with 1% higher and 2 with 1% lower loads than best load, and tune my tuner over the range I expect is relevant. I shoot groups first at 200 yd, then 600 and 1000. I plot group size or vert. dispersion vs tuner setting.
Now, I plot another curve in EXCEL and do another curve fit (if necessary) and I'm done.

I have tuned my load to the best Es from the "traveling donut" longitudinal resonance as well as the tuner setting for the best cantilever resonance. Bullet jump? What ever floats your boat, just don't change it once characterized!

Done!

Different EXCEL issues will do these functions differently so it's best to ask Google how to do curve fitting for your issue of EXCEL.

 

[Defender 3]

I've been using the Magnetospeed almost since they came out a few years ago, and currently am using the V3 model...and very happy with it.

I suspect some of you guys are wizards when it comes to Excel spreadsheets, and that there's a lot that one could do using the Magnetospeed data in some kind of "graph" format to understand and analyse the results in the course of load development.

This is a pretty open ended question, but would like to know if any one is doing something like this, and if so, how a duffer such as myself can benefit?

Many thanks,

George

Do you mean something like a scatter chart?

 

[300_whisper]

I love excel! There are so many things you can do with it. It’s an absolutely amazing calculator!!

 

[300_whisper]

Also Rex reveiws has an awesome excel spreadsheet you can take off his google docs. The link is in his video description.

 

[walker2713]

Thanks, guys....appreciate the responses....now I need to analyse and see how I can put some of this information to use.

George

 

[normmatzen]

the curve fitting is not difficult.
1. "INSERT" to pick graph, scatter.
2. "LAYOUT" select then pick lowest option.
3. select polynomial and increase power till curve does not change, for example most
times 4th order and 5th order look the same.