The Firing Line Forums

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

Thread Tools Search this Thread
Old June 6, 2014, 01:58 PM   #1
Senior Member
Join Date: December 24, 2008
Location: Loveland, CO
Posts: 1,475
Chronograph Record Sheet

I'm interested in developing a record sheet to record my information while at the range when firing over the chrony.

So if you have a sheet you use, please post an image of it, so I can benefit from your work and experience. thanks!
NRA Benefactor Life member
jepp2 is offline  
Old June 6, 2014, 02:16 PM   #2
serf 'rett
Senior Member
Join Date: June 25, 2009
Location: Stuttgart, AR
Posts: 1,569
My range "record sheet" ranges from a pad and clipboard to scribbles on a piece of cardboard gleaned from trash.

The important thing is to transfer the info into an Excel spreadsheet on the home computer, where we can play all types of number games.
A lack of planning on your part does not necessarily constitute an emergency on my part.
serf 'rett is offline  
Old June 6, 2014, 02:40 PM   #3
Senior Member
Join Date: December 4, 1999
Location: WA, the ever blue state
Posts: 4,678
I have binoculars, the back of a target, and a pen on the shooting bench.
I write down each velocity.
I write down what gun and what range on each target as I pull it down.
I write up a range report as soon as I get home.

Range report 2007-2-15 6mmBR 9mm 45acp
It is getting close to varmint season, and I need to see if 1 in 14" twist stabilizes a 65 gr Vmax in a 6mmBR.
I get Friday afternoon off, and I saw that had a couple of hours predicted to be 0 miles per hour wind at Issaquah WA, where my range is, so I tried to get ready.
1918 Savage 99 take down 250-3000 with Shilen 21.375" 5.1 pound stainless barrel benchrest take off 6mmPPC after 400 rounds. I reamed out to 6mmBR .272" neck and cut threads and reliefs to fit on Sav99. It is the second trip for gun and second trip for scope to the range. Leupold VXIII 6.5x20x50 Varmint. I took the scope off to put a magnetic screw on lens cover on the objective.
W748 33..5 gr 65 gr 6mm Vmax moly coated with BBs and magnetically separated.
2.22" OAL, but the chamber will seat it further.
Quickload thinks that this is 3229 fps 45,801 psi
I fired into the dirt over the chrono and measured 3122 fps and 3159 fps.
0.3" 3 shot group at 100 yards. [with the rifle forward in the bag]
1" 3 shot group at 100 yards. [ with the rifle forward in the bag]
The targets were then un shootable with only one staple as the wind was blowing them sideways.

So 7 years later, those velocities will still have meaning.
Attached Images
File Type: jpg 6mmbr RangeBenchSav99s.jpg (153.0 KB, 146 views)
The word 'forum" does not mean "not criticizing books."
"Ad hominem fallacy" is not the same as point by point criticism of books. If you bought the book, and believe it all, it may FEEL like an ad hominem attack, but you might strive to accept other points of view may exist.
Are we a nation of competing ideas, or a nation of forced conformity of thought?
Clark is offline  
Old June 6, 2014, 03:25 PM   #4
Senior Member
Join Date: September 27, 2004
Posts: 4,811
Here you go. This is actually done in Excel to ease formatting & let me use the gathered data later.
I usually print 3 or 4 "entries" to a sheet of 81/2X11 so the cells are big enough for easy writing.

The data columns are in the order my chronograph presents them you can just modify to work with your system.

Why 2 "notes",easy, 1 for target info (5 ro[email protected] 100 yds no wind) & so on, the other for the things that happened firing the string. (unusual recoil, lots of muzzle flash) & so on. I mark the target with the "STRING # so I can match everything up when I get back home.
Allan Quatermain: “Automatic rifles. Who in God's name has automatic rifles”?

Elderly Hunter: “That's dashed unsporting. Probably Belgium.”
wogpotter is offline  
Old June 6, 2014, 03:44 PM   #5
Senior Member
Join Date: March 21, 2013
Location: Taxifornia
Posts: 4,432
Excel Spreadsheet

I have an Excel spreadsheet I take to the range.

PM me w/ your e-mail address and I'll send it to you, if you wish.

It works for me (I only shoot pistol, if that matters). It may or may not for you. No harm in taking a peek at it.

(I'm at work right now, so I can't send it 'till tomorrow.)
Gun control laws benefit only criminals and politicians - but then, I repeat myself.
Nick_C_S is offline  
Old June 6, 2014, 04:57 PM   #6
Senior Member
Join Date: September 6, 2011
Location: Wyoming
Posts: 1,320

Here ya go!
Go Pokes!
Go Rams!
Wyoredman is offline  
Old June 9, 2014, 07:49 AM   #7
Doc Hoy
Senior Member
Join Date: October 24, 2008
Location: Chesapeake, VA
Posts: 5,105
I like yours better'n mine

I cobbled one together a while back which I use. It is also in Excel. I print the form and carry it to the range, then load the data into Excel for statistical analysis when I get home. Yes...My computer keyboard has BP soot (I shoot mostly BP Cartridge or Cap and ball) and gun oil all over it.

I like both of the examples above better than mine.

My reading of history convinces me that most bad government results from too much government. Thomas Jefferson
Doc Hoy is offline  
Old June 9, 2014, 12:16 PM   #8
Senior Member
Join Date: September 27, 2004
Posts: 4,811
If you'd like a live excel copy PM me with an e-mail address so I can send you the sheet.
Allan Quatermain: “Automatic rifles. Who in God's name has automatic rifles”?

Elderly Hunter: “That's dashed unsporting. Probably Belgium.”
wogpotter is offline  
Old June 9, 2014, 01:53 PM   #9
Senior Member
Join Date: January 20, 2009
Location: Overlooking the Baker River Valley
Posts: 1,642
Here's what I use when I'm serious about working up a load (this version is set up for evaluating 5-shot groups, but it's easily converted to other group sizes):

It's a bit more labor-intensive, but provides a great deal more information. I like to shoot on those "sighting-in" targets that provide 5 bulls with a 1" grid around them. I shoot the groups using the chronograph and note the velocity for each shot and also make a little drawing so I know which hole corresponds to which shot. That all gets taken home, where I measure the x and y distance from the aiming point for each shot, then enter those two numbers and the velocity for each into the spreadsheet.

The spreadsheet then calculates the center of the group as the mean x and mean y distances and then calculates the distance that each shot is from that group center. Those distances are used to calculate the mean distance from the group center, which is a much better measure of the accuracy (precision, really) of the load than group size, which has lots of drawbacks statistically (though the sheet calculates that as well).

Finally, each shot and the group center is plotted. That all gets printed out and stored in the noteboook. The example I provided represents real data from my .22-250, shot back in September of 2001.
NRA Benefactor Life Member
NRA Certified Pistol Instructor, Range Safety Officer
SASS #84900
Pemigewasset Valley Fish & Game Club
FlyFish is offline  
Old June 9, 2014, 03:31 PM   #10
Senior Member
Join Date: September 27, 2004
Posts: 4,811
One nice thing about collecting data in excel is that it ports directly over into the "Point Blank" ballistics calculator. It also makes plotting impacts easier as you print a copy of the digital target shoot it & then just push the data back into the digital again.
Like this:
Allan Quatermain: “Automatic rifles. Who in God's name has automatic rifles”?

Elderly Hunter: “That's dashed unsporting. Probably Belgium.”
wogpotter is offline  
Old June 9, 2014, 03:41 PM   #11
Senior Member
Join Date: February 12, 2009
Location: Butte, MT
Posts: 2,008
Notebook with a pencil. Can't get much simpler.

Caliber, gun, bullet, primer, and powder being tested and temperature out. Then just start a column of velocities for each load tested (at least 10 entries, but I shoot 15, sometimes more). At a glance you can tell pretty much where it's at and target tells accuracy. Simple. When I get home, then I put in a LibreOffice Calc and play the numbers game. I don't need it in 'Excel' but if I did, LibreOffice easily converts to that proprietary format . And if is free and works both on Linux and Windoze.
A clinger. When guns are outlawed, only outlaws will have guns. Single Action .45 Colt (Sometimes improperly referred to by its alias as the .45 'Long' Colt or .45LC). Don't leave home without it. Ok.... the .44Spec is growing on me ... but the .45 Colt is still king.
rclark is offline  

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 04:54 AM.

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