Spreadsheet for reloading

clymbhard

New Member
Joined
Dec 27, 2008
Messages
4
mike
i am curious what is the bullet stability value in your spreadsheet?
what does it represent?

Micah
 

HiTechRob

Active Member
Joined
Sep 11, 2013
Messages
25
Location
Simpsonville, SC
Nice sheets Mike!

I'll be glad to share mine but I do not know how to upload an *.xlxs (Excel) file. If anyone can share how to do this, I will post. You will see some of my 7mm Rem Mag load data as well.

On that note, does anyone have any 7mm Rem Mag load data they would be willing to share with comments about accuracy, etc.?

My "go to" whitetail deer round is 140 grain Nosler AccuBond, load with IMR 4350 powder (63.5 grains), Federal 215 M or CCI 250 Primers, Nosler or Federal brass. Case length: 2.491", Neck thickness: 0.012", OAL: 3.340" (0.10" off the lands).
 

etisll40

Well-Known Member
Joined
Jan 28, 2009
Messages
1,747
Location
Rochester, NY
Good stuff, have you left a link for the sheet, tab, I'm not too Excle savvy. Or is this just something you use on paper? Good stuff either way...

Thx
 

doniphan

Well-Known Member
Joined
Jan 24, 2007
Messages
46
Location
Southeast Missouri
I've never posted an excel spreadsheet, so I'm not certain how to do it. However, anyone knows how to do that, just email me at [email protected] and I will send you the excel file and you can then post it here. Or if nobody knows how to make that happen, just email me and I'll send you the file individually.
John
 

ncwg2boatguy

Well-Known Member
Joined
Sep 10, 2013
Messages
358
Location
Virginia
I've built a couple of spreadsheets that I think are handy so I thought that I would share them with the reloading community here.

I use one for documenting my load when I use a chronograph. It calculates the following for a 1 to 10 shot group for 7 different loads:

Number of shots
Lowest velocity
Highest velocity
Average Velocity
ES
Energy in ft. lbs
SD (note- Standard Deviation is a statistical value. 10 data points is the least number recommended by most chronograph mfgs and a very small sample. Statisticians will tell you that SD is only as good as the number of samples and they generally wrinkle their nose at a sample as small as 10. If you have less than 10 data points the spreadsheet will still calculate a result but it's probably not of much value)

Just fill in the blanks that you can before you go to the range and add the velocity and atmospheric data once you get there and start shooting. I take a printed copy with me but it will load on to a PDA (I loaded it on my Dell Axim 50). Once you get home you can type in the recorded values and do file Save As and save a copy specific to a particular test.

I also use the sheet when I don't use a chronograph. It's handy for keeping track of what loads that I've tried. I also have columns to record atmospheric data as well as data about the load that I am testing (caliber, BC, powder, bullet, etc.). The spreadsheet is protected to prevent accidental over writing of a formula. If someone wants the password I will gladly give it out. For that matter, if Len wants to include it when he edits the post that's fine with me. Who knows, maybe someone will get froggy and change the calcs to handle a larger sample size :)

I use the other spreadsheet to give me an overview of what charges I will use for a specific cartridge. When I go to the loading bench all I take with me is one sheet of paper rather than the manual. Once the loads are built I put the printout into the cartridge box with notes on which row contains which load. This doesn't sound like it would be that handy but I list every powder that I have on hand and I have a tab for rifle and a tab for pistol. I know this is going to make some long time reloaders wince a little but we have a lot of new to reloading people out there (that's a good thing). By listing all of the rifle powders on one tab and all of the pistol powders on another the likelihood of accidentally loading a rifle powder in a pistol case or vice-versa should be diminished since the "recipe" is for a specific powder is right there. Another benefit is that I only have load info for the powders that I have on hand. I don't have to worry about weeding through all of the other data. I thought about breaking it into caliber specific tabs but decided it would be more useful to more people if I did it this way. To tweak it to your liking just remove the powders that you don't have and add the ones that you do.

If Len posts the sheets that I sent him then they will already have data points entered in a couple of columns. Just delete the blue and red colored info. BTW- I used red to indicate max or over max charges in.

Feedback is appreciated but not necessary.
Thanks for sharing this. great for novice and experienced loaders.
 

Saintsfan1977

Active Member
Joined
Jan 19, 2015
Messages
28
Location
Louisiana
I've found these spreadsheets very useful. I wonder if any of you excel masters have been able to add formulas in for calculating your velocity and muzzle energy at 100, 200, 300, etc. yardages, kind of like a ballistics calculator does. Or would this be too complicated of a formula?
Ballistics calculators do this already. It would be complicated but there are so many programs, some free, that it would be pointless. Unless you have something else in mind?
 

mickeymoose

New Member
Joined
Nov 24, 2013
Messages
4
I built a web site to manage all of my data. I know that's not for everybody though.
 
Last edited:

Buckskinner

Well-Known Member
Joined
Jan 14, 2017
Messages
212
John,
That is exactly what I've been looking for, I sent email and would appreciate a copy.
Thanks,
Scott
 

Trending threads

Top