|
Forum Rules | Firearms Safety | Firearms Photos | Links | Library | Lost Password | Email Changes |
Register | FAQ | Calendar | Today's Posts | Search |
|
Thread Tools | Search this Thread |
June 6, 2014, 01:58 PM | #1 |
Senior Member
Join Date: December 24, 2008
Location: Loveland, CO
Posts: 1,476
|
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 |
June 6, 2014, 02:16 PM | #2 |
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. |
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 Accurweather.com 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.
__________________
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? |
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 rounds@ 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.” |
June 6, 2014, 03:44 PM | #5 |
Senior Member
Join Date: March 21, 2013
Location: Idaho
Posts: 5,523
|
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. Life Member, National Rifle Association |
June 6, 2014, 04:57 PM | #6 |
Senior Member
Join Date: September 6, 2011
Location: Wyoming
Posts: 1,352
|
__________________
Go Pokes! Go Rams! |
June 9, 2014, 07:49 AM | #7 |
Senior Member
Join Date: October 24, 2008
Location: Naples, Fl
Posts: 5,440
|
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.
__________________
Seek truth. Relax. Take a breath. |
June 9, 2014, 12:16 PM | #8 |
Senior Member
Join Date: September 27, 2004
Posts: 4,811
|
Doc:
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.” |
June 9, 2014, 01:53 PM | #9 |
Senior Member
Join Date: January 20, 2009
Location: Overlooking the Baker River Valley
Posts: 1,723
|
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 Instructor: Rifle, Pistol, Shotgun, PPIH, Metallic & Shotgun Shell Reloading; RSO Pemigewasset Valley Fish & Game Club |
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.” |
June 9, 2014, 03:41 PM | #11 |
Senior Member
Join Date: February 12, 2009
Location: Butte, MT
Posts: 2,622
|
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 and deplorable, MAGA, and life NRA member. When guns are outlawed, only outlaws will have guns. Single Action .45 Colt (Sometimes colloquially referred to by its alias as the .45 'Long' Colt or .45LC). Don't leave home without it. That said, the .44Spec is right up their too... but the .45 Colt is still the king. |
|
|