The Firing Line Forums

Go Back   The Firing Line Forums > The Skunkworks > Handloading, Reloading, and Bullet Casting

Reply
 
Thread Tools
Old October 22, 2011, 03:21 PM   #1
zxcvbob
Senior Member
 
Join Date: December 20, 2007
Location: S.E. Minnesota
Posts: 4,184
Database to keep track of reloads

I've been reloading for almost 10 years, and I'm losing track of what loads work and what don't. I usually write everything on a label and stick it on the box, but after the label is replaced all I have is my memory to go on. It doesn't help that I have a dozen different primers and 20 or so powders and I like to tinker. I'm trying to consolidate a little as I use things up, but that's not working very well.

So I tho't maybe I ought to keep track of my load data in a Google Docs or Excel spreadsheet. Does anybody else do this? Do you track individual lots by date? There's an awful lot of columns you can have on a spreadsheet; what to put in all of them? Seems like too much data is better than not enough; you can always hide columns or leave fields blank.

Any good templates?
__________________
"The only way to stop a bad guy with a gun is with a good guy with a gun"
zxcvbob is offline  
Old October 22, 2011, 03:37 PM   #2
Unclenick
Staff
 
Join Date: March 4, 2005
Location: Ohio
Posts: 10,247
Try doing a search. I'm pretty sure someone shared his Excel file for that purpose recently. A log book will work, too, of course, but it takes longer to find old data that way. A relational database file like an Access file is ideal, as you can search it on any parameter, but I don't think most shooters need that sophistication. Just use Excel, or the free Open Office Suite's spreadsheet program, Calc, to create a worksheet for each gun (a good place to record the serial number and insert a photo for insurance purposes is in this worksheet). Then record the load data in columns and sort those by bullet or powder or whatever. You can also link the same load among different guns that share them (if you do any general purpose loads). Columns just need to be whatever data you normally check when you load. I like to add which dies I used along with the cartridge info. If you've ever shot out a barrel, you'll want to note which barrel used which loads.
__________________
Gunsite Orange Hat Family Member
CMP Certified GSM Master Instructor
NRA Certified Rifle Instructor
NRA Benefactor Member
Unclenick is offline  
Old October 22, 2011, 06:26 PM   #3
jdillon
Senior Member
 
Join Date: October 7, 2011
Location: Southern NM
Posts: 141
Sinclair makes a good reloading data book to keep track of your reloads. I keep a log of all my reloads for future reference. Very handy when you reload for numerous pistol and rifle loads. I keep a range log as well.
__________________
"Emergencies have always been the pretext on which the safeguards of individual liberty have been eroded" - F.A. Hayek
jdillon is offline  
Old October 22, 2011, 06:32 PM   #4
saands
Senior Member
 
Join Date: November 14, 1999
Posts: 1,563
I have an Excel spreadsheet that has, as suggested, a worksheet for each caliber. I have columns for all the load parameters as well as columns to record the velocities of the test rounds that go over the Chrony. I also note where the recipe came from (e.g. QuickLoad, or a load book, or in some cases an Internet reference). I also have a column for the group size, and another for notes.

Saands
saands is offline  
Old October 22, 2011, 07:02 PM   #5
dts686
Member
 
Join Date: March 25, 2010
Location: Orlando FL
Posts: 66
I created a Microsoft Access database to keep my reloading data in. Not a ton of data but all the basics and an area for keeping chrono data and reviews of shooting the bullet. Works for me.

dts686 is offline  
Old October 22, 2011, 07:32 PM   #6
Don P
Senior Member
 
Join Date: December 17, 2005
Location: Florida
Posts: 4,792
I set up an Excel program so I could put any or all or some of the data that I feel is pertinent to me. By doing so you can put as much or as little info as you wish in the program.

Reloading recipes that I need for each caliber plus all the data I for each. 10 sheets or pages for the spread sheet.
__________________
NRA Life Member, NRA Range Safety Officer, IDPA Safety Officer
As you are, I once was, As I am, You will be.
Don P is offline  
Old October 22, 2011, 07:36 PM   #7
CherokeeT
Senior Member
 
Join Date: April 23, 2008
Location: Medina, Ohio
Posts: 264
I use Microsoft WORD documents to keep track of my load data and range results. Before that (1960's to 1980's) I used large index cards for each cartridge/load combination, then went to 8.5x11 paper forms. Converting from paper to WORD was a pain but worth the effort. WORD doesn't have the searchability of a data base or Excel file, but does allow unlimined text and freer form wherein I keep records of every range session with that load and firearm. Here is a link to a copy of one page.

__________________
God Bless America
US Army, NRA Endowment
TSRA Life, SASS
CherokeeT is offline  
Old October 22, 2011, 07:41 PM   #8
emcon5
Senior Member
 
Join Date: July 10, 1999
Location: High Desert NV
Posts: 1,618
I just write notes in the margins of my loading manual.
emcon5 is online now  
Old October 22, 2011, 08:24 PM   #9
TXGunNut
Senior Member
 
Join Date: January 16, 2010
Location: If you have to ask...
Posts: 2,851
I took the low-tech approach about 24 yrs ago with a 3-ring notebook and dividers for each cartridge. First pages are where I assign a load number (and often a variation letter) to each load. Next few pages are a log of rounds loaded and notes about the results.
I like CherokeeT's format. This computer thing might just catch on after all.
__________________
Life Member NRA, TSRA
Smokeless powder is a passing fad! -Steve Garbe
I hate rude behavior in a man. I won't tolerate it. -Woodrow F. Call Lonesome Dove
My favorite recipes start out with a handful of used wheelweights.
TXGunNut is offline  
Old October 22, 2011, 09:27 PM   #10
dunerjeff
Senior Member
 
Join Date: March 31, 2011
Location: central Wisconsin
Posts: 440
Just be sure to BACKUP YOUR WORK,believe me it happens.Thankfully I had a bunch of it printed out so I could write new notes on them while at the range.
dunerjeff is offline  
Old October 22, 2011, 09:59 PM   #11
medalguy
Senior Member
 
Join Date: August 31, 2009
Location: New Mexico
Posts: 1,017
Amen to backup!! I made a fairly simple Excel worksheet to track data for my reloads. Different sections for pistol and rifle ammo, and I enter whatever information pertains to that particular round.
medalguy is offline  
Old October 24, 2011, 05:47 AM   #12
richfr
Member
 
Join Date: December 5, 2009
Location: France
Posts: 79
dts686 that looks an excellent way to do it. Can you print labels from that database too to put on batches of ammo?
Have now started to reload 38spl/357mag as well as 9mm so hard to keep track of everything
Any chance you would share the template
richfr is offline  
Old October 24, 2011, 06:10 AM   #13
OEF-Vet
Senior Member
 
Join Date: October 23, 2011
Location: Backwoods, PA
Posts: 284
http://westernsafellc.com/Reloading.xls[/URL]

This is a great spreadsheet I found on outdoorsdirectory.com posted by Wyatt. Thanks Wyatt. It does a lot of calculations and conversions that you may or may not want to use. It makes great lables too. Hope this helps a little more than the common "I made my own."
OEF-Vet is online now  
Old October 24, 2011, 09:19 AM   #14
richfr
Member
 
Join Date: December 5, 2009
Location: France
Posts: 79
Thanks OEF that should do everything I need with a few tweaks
richfr is offline  
Old October 24, 2011, 10:20 AM   #15
OEF-Vet
Senior Member
 
Join Date: October 23, 2011
Location: Backwoods, PA
Posts: 284
Glad I could help.
OEF-Vet is online now  
Old October 24, 2011, 10:24 AM   #16
Sevens
Senior Member
 
Join Date: July 28, 2007
Location: Central Ohio
Posts: 8,771
I use an Excel workbook that I made myself. Got pages for each caliber, but I find that I don't refer to them all too often, but those particular pages are the best place to list ALL the loads you've made in any one caliber, and use the strike-through text feature to ensure that you never make the same crappy load more than once.

More than anything, I use one of the work sheets in my file with a dated log. Entries include any ammo that is produced at my bench with just the most necessary items according to my own standards. I list the caliber, the bullet brand/weight/style, the powder type and charge weight and the COAL of the loaded rounds. I rarely list the brass headstamp, and I rarely list the primers simply because I tend to stick to CCI non-magnum in all four sizes. When I use something else, I will list that. I also don't record powder or primer lot numbers because I don't do much rifle loading and I don't tend to load at or near or over max, where those items become more important.

I could never possibly be convinced that ANY method using paper and pen is going to come anywhere near the power, flexibility and ease of use as a spreadsheet and a log page in that workbook.

I'm very nearly SHOCKED that anyone who has been handloading for a number of years and is serious enough about handloading that he takes regular part in an internet discussion forum would still be using a series of paper notes and labels and NOT taking advantage of a log on his PC.
__________________
Attention Brass rats and other reloaders: I really need .327 Federal Magnum brass, no lot size too small. Tell me what caliber you need and I'll see what I have to swap. PM me and we'll discuss.
Sevens is offline  
Old October 24, 2011, 10:59 PM   #17
mrbro
Senior Member
 
Join Date: September 14, 2008
Posts: 195
My notes are on my Crackberry and in an Excel spreadsheet. The Crackberry works well because I can enter shooting notes while on the range. I have found that once I settle on a load I don't refer to the notes, unless old age kicks in. Back in the days before PCs (yes, its true) I kept a ledger with all my notes. What a PITA that was! I don't even know where that book is now!
mrbro is offline  
Old October 25, 2011, 08:16 AM   #18
highvel
Senior Member
 
Join Date: January 21, 2010
Location: Powhatan VA
Posts: 633
I use Excel and made a target that has 1" grid and at the bottom has all the pertinent data, I shoot and then put it into a three ring binder for reference.
You can get one at http://www.ballistics-software.com
I make notes on the target for conditions, FPS, etc and it makes for a handy reference to keep from making the same mistakes.
Oh, and it helps a great deal to be able to see the actual groups for different loads
__________________
Do not argue with an idiot. He will drag you down to his level and beat you with experience.--Mark Twain

"I have opinions of my own 'strong opinions' but I don't always agree with them."--George Bush
highvel is offline  
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 11:46 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
This site and contents, including all posts, Copyright © 1998-2014 S.W.A.T. Magazine
Copyright Complaints: Please direct DMCA Takedown Notices to the registered agent: thefiringline.com
Contact Us
Page generated in 0.11160 seconds with 9 queries