Excel reloading spreadsheet

Status
Not open for further replies.

brutus51

Member
Joined
Apr 7, 2013
Messages
1,367
Getting real close to running out of pages in my latest notebook and have decided to get with the 21st century and create a spread sheet. Have been reluctant as spread sheets are work related.
Anyone know of a good available sheet?
 
I don't have a crono so I don't need speed or deviation info, just lot #, cal, case mfgr, bullet info, powder type, lot, wt., anneal Y/N, rifle/pistol....

I also pick 5 random cases from lot and measure before and after all case dims. sizing, and shoulder, ID/OD neck bullet seating.
 
Here's what I track, each has a separate column/space:

Bullet: Make, Type, Weight
Powder: Make, type, charge
Primer:
Brass Make;
Brass prep: IE FL sized, bump sized, primer pockets uniformed, etc.
Brass length
OAL: straight measurement, then with a gauge measuring the ogive

Then there's the results section:
Groups:
Temp:
MV:
ES:
SD:
Finally a notes space
 
Brutus, I picked up a couple of Excel templates from here or another place, combined the two, and added my own sheets and formulas to turn into something that works for me. I can send it to you if you like. Send me a PM with your email address and I'll get it to you.
 
I use a spreadsheet to keep track of everything... inventory, cost, load records, and group and chrono results.

Each caliber have its own tab. I track date reloaded (used as batch number) and date used. Each record have number of rounds reloaded, powder and charge weight, projectile, primer, COL, and group results.

Inventory is automatically updated as I record the loads. It's been helpful in keeping track of when I need to purchase more components or when I need to start loading more of a particular cartridge.
 
Last edited:
And of course it can be tweaked all kinds of ways, and I do. This is labeled pistol, and has a lot of pistol caliber tabs, but I do similar for standard rifle. I do it very differently for match rifle, much more info.
 

Attachments

  • Load Log - Pistol - Blank.zip
    179.8 KB · Views: 60
I’ve decided to go caveman and use a recipe box with note cards. I’m currently transferring all my data over
 
  • Like
Reactions: RMH
Status
Not open for further replies.
Back
Top