Spreadsheet for reloading

Hugnot

Well-Known Member
Joined
Sep 26, 2020
Messages
637
Location
Montana
Here is a spread sheet that I use to distribute my limited powder stocks among 4 different cartridges - .300 WM, 178ELDM; .243 Win, 87 VMAX; .22-.250, 75 ELDM; 6mm AI, 87 VMAX. All loaded with some what available Alliant 4000MR ball powder. All loads shown are conservative & work well. Alliant touts 4000MR for use in the .300WM and also has 4000MR data for the .243 W. 4000MR is sort of an unappreciated propellant.

The total amount of powder is determined - then, the spread sheet allows charge weight, & number of rounds for each cartridge to be adjusted.

Running out of powder is shown by red numbers in the powder remaining slots.

Any combo of 4 cartridges, powder charge weights may be used.

Screenshot (251).png
 

Hugnot

Well-Known Member
Joined
Sep 26, 2020
Messages
637
Location
Montana
Sending Open Office spread sheets to others via email.

Close Open Office spread sheet.

Locate Open Office spread sheet under documents on host computer & double click -this will get you into excel in Micro-Soft Office One Drive.

Go to file section in excel task bar, click; then find "send" & click.

Enter recipients email address and should you want to enable "write" access enable this.

Send link to recipient via email & recipient can then down load excel spread sheet to his/her computer by going the "re-name spread sheet" then clicking on download to enable working off-line.
 

Hugnot

Well-Known Member
Joined
Sep 26, 2020
Messages
637
Location
Montana
I use this spread sheet before buying bullets. I also check out my rifle barrel twist rates using a cleaning rod having a lightly oiled tight fitting patch fitted over a pinned jag, a strip of masking tape, a felt tip pen & a ruler. I once had a 6.5-06 PacNor barrel that should have been a 9 twist & it would not shoot 140 Hornady HP BT bullets while my other 9 twist 6.5 rifles would. Upon checking out the 6.5 PacNor barrel I discovered it was actually a 9 3/4 twist. It shot 120's incredibly well & I continued to happily shoot it.

Screenshot (253).png
 

Hugnot

Well-Known Member
Joined
Sep 26, 2020
Messages
637
Location
Montana
Here is a spread sheet that I use to get probability estimates like "bell shaped curve" low to hi end.

It can be used for velocity, powder charge, & ogive length. Spread sheet use gives some idea of what to expect with a batch of ammo, like 100 to 1000 rounds. Data made up for display purposes. The sample size was cut off at 20.

Screenshot (254).png
 
Last edited:

DickC

New Member
Joined
Sep 29, 2021
Messages
3
Location
NE Washington state
It depends on what a guy is trying to accomplish.
10 years ago I was using a spread sheet when I tried to work up ever powder and ever bullet combination in 9mm to case failure or case full.

These spread sheets look like a Sierra load book.
I really like the Rifle Sierra data, but that is not how I am currently organizing.

Right now I have hundreds of guns with ~ 60 different cartridges. I write up range reports and email them to friends. Each time I am about to do something new, I do a search on that gun and that cartridge to see where I left off.

Most guys organize their reloading with shelves of dies and shelves of bullets.
I have a file folder box with the dies and brass for a cartridge. I have the bullets in another file folder box. This way everything for a project is already kitted up.
I'd like to do that for .40S&W.
 
Top