Load Data & Chrono Results Template

Status
Not open for further replies.

Ej3

Member
Joined
May 6, 2017
Messages
114
I started out hand loading strictly for my 300 BLK and 9mm. I never intended for it to grow and expand like it has over the past year or so. I am now loading 300 BLK, 9mm, 380 ACP, 38 Special, 357 Mag, .223 Rem & 30-06. Starting out I just kept minimal hand notes and summarized my favorite loads, which were not many. So organizing my data was not really an issue.

But recently I decided that I need a better way to organize and save my information. Especially since loading .223 Rem and experimenting with various weights/types of bullets and powders. It gets complicated organizing load data & results. I am not into precision shooting, so I wanted something that was not too overly complicated. I am not concerned about tracking every possible aspect of my hand loads.

And I prefer to not hand write out all the data and notes. So I developed a PDF document that allows me to enter information in fields (see attached). I like this better than a spreadsheet. This way I can take my field notes on an index card and transfer and complete all the information on my computer. If I need more than one page, I simply combine multiple PDF pages into one document. So I have one PDF file per caliber/bullet/powder combination. As a final step I highlight the best combination to visually stand out.
 

Attachments

  • Load_Data_Chrono_Results_Template.pdf
    38.8 KB · Views: 72
I have a few favorite targets from "My Targets.com" that I downloaded in a PDF file, I edited the targets to include load and chronogragh data.
Here is a example, pretty low tech but it works for me.

index.php
 
So I developed a PDF document that allows me to enter information in fields (see attached). I like this better than a spreadsheet.
Very nice! And pdfs are searchable as well. If I had to start all over, I'd probably go with a database approach given all the data I've collected. I'd then write the queries that would deliver what information I was interested in, as that changes depending on the question.
For now I do use a spreadsheet approach since I wanted the analytical and sorting capabilities. I also start with the spreadsheet, that is I create the loads there first, and then use Word's mail merge capability to populate label templates. Depending on the caliber, I may print directly on 1/4" quadrille paper which is then the target, or, I may print on mailing labels and then paste them on a different target. I'll also generate a shoot sheet, another template, with all this data so I can take notes at the range. Once I gather all the chrono data, I do need to copy/paste that data back in to the spreadsheet on the rows awaiting that data. Finally, I can generate a post shoot summary using another template that lists what the load was supposed to do and what it actually did. The quadrille loose-leaf paper also allows a quick way to estimate group size and it's cheap.
Printing on labels example:
IMG_4507.jpg
Printing on paper example:
IMG_4508.jpg
 
  • Like
Reactions: Ej3
Mine is written on the little sticky notes that come with the bullets. If it's exceptional, I stck it to pertinent page in my manual. If it's just an ok load, it's stuck to the ammo box and rejected after I burn up that set of components.
 
I actually like writing mine out in a spiral notebook. Besides writing out a check here and there, it's about the only way I keep some kind of hand writing skills. ;)
 
I do like the idea of having the target with pertinent load information. Then just write the results for each powder charge.
Here a two PDF letter size targets with form fields for typing out the load data in advance. Or, just print and hand write.

Edit - replaced with revision that expands some line items.
 

Attachments

  • Target - Load Test - 4 (Template) R2.pdf
    53 KB · Views: 35
  • Target - Load Test - 1 (Template) R2.pdf
    53.3 KB · Views: 34
Last edited:
Then just write the results for each powder charge.
I like the idea of the targets having the load information, but in my case I’ve found every time I write the data is an opportunity to make a mistake. In my process I craft the load data, load it at the bench, record it at the bench, create a target, chrono it with range metrics, and generate the chrono data related to the load data to review and summarize. I used to hand write that at all points, and when you’re doing tens of loads per session with just a few differences, it’s easy (at my age) to get confused.
I think there’s a balance to using technology and the old school ways. You’ve got to decide which works well for you!
 
  • Like
Reactions: Ej3
Status
Not open for further replies.
Back
Top