RECORD KEEPING

784 Views
Last Post 18 May 2016

CBA Member

joeb33050 posted this 16 May 2016

I've never found the perfect way to keep shooting records. Notebooks, EXCEL, ... I now have pre printed pieces of paper where I note notes about loads, keep the paper with the ctgs, fill it in after shooting, transfer info to excel, and store the paper. When there are a lot of groups, the graph tells the story a lot clearer than the notes. Here's an example, but I can't get the graph to print here.

Attached Files

9 Comments

Order By: Standard | Newest | Votes

CBA Member

RicinYakima posted this 16 May 2016

Joe, Very clear visual representation. Glad it works for you, and that you keep a paper copy to safety. I learned that the hard way when the local transformer was hit by lightening, and fried TV, Computer(that was on standby), land line phones and stereo.

Attached Files

CBA Member

Ken Campbell Iowa posted this 16 May 2016

test

Attached Files

joes graph html_html_5c4516ef.jpg

CBA Member

joeb33050 posted this 16 May 2016

Ken Campbell Iowa wrote: testHow do you get from excel to a picture on the forum? These dam computers...

Attached Files

CBA Member

Ken Campbell Iowa posted this 16 May 2016

i am using * open office * which is 99 per cent the same as excel .. at least some version .... i use OO because it is free, and then i can buy another gun ...

i loaded from your url....then did * save as * and that gives me a choice of formats ... i saved it to my desktop as * html * and the cba forum accepted that ... oh, after i entered a text ...* test * or some such .

dam computers .

ken

Attached Files

CBA Member

joeb33050 posted this 17 May 2016

Ken Campbell Iowa wrote: i am using * open office * which is 99 per cent the same as excel .. at least some version .... i use OO because it is free, and then i can buy another gun ...

dam computers .

kenI almost understand that. I've shot about 140 groups with Titegroup and 37 with SR4756; all with 225646M. I find it interesting that as powder charge increases, group size falls and the variation decreases. Both average group size and variance seem to fall. Now this is with 2 rifle barrels in 2 actions and the Striker, with some other things varying, such as mold cavity, bullet size and lube. It looks like powder charge is important, and powder # is important. At least down to 1.5” group sizes. I think I've learned with the 22-250 that powder selection is maybe THE most important choice in the search for accuracy. That SR4756 just works great. Thanks Bill G.

Attached Files

CBA Member

billglaze posted this 17 May 2016

Joe: Glad the powder is working for you. For a time, it was the best for me, also. Then I got into a mode with Titegroup and Red Dot. Kinda neglected 4756. After awhile, I went back for a re-check--it proved itself a good powder for cast--again. Can't give firm numbers; too many variables going on one after the other, so the above statements are subjective, at best. Call them “Observational.” (Thanks, Ric.)

In theory, there's no difference between theory and practice. In practice, there is. My fate is not entirely in Gods hands, if I have a weapon in mine.

Attached Files

CBA Member

Ken Campbell Iowa posted this 17 May 2016

powders ... there are so many anymore ... it makes me glad i settle for plinker ” accuracy ” ...anything under 3 moa., for those who take note of such things...

but anyway, for the 22 HORNET guys, it is about 90 per cent * lil gun * ... compared to 2400, h110, 4427, 4198 ... range . 12 grains for a hornet max load .

might be worth a try for a 2200 fps load in a 223/22-250 ....

once things get down to 1.5 moa of course ...

ken

Attached Files

CBA Member

mtngun posted this 18 May 2016

I've been relying on my forum posts to keep long term records. That's one reason why I try to include detailed load & chrono data in my forum posts. The disadvantage is that once in a great while forums do crash and lose their data or their photos. I lost some hunting photos that way.

Now I store the photos on Photobucket or Picasa in addition to a copy on my hard drive.

Paper records -- bulky, they get lost or misplaced, and it's hard to find the particular paper you're looking for.

Spreadsheet -- ok but you still have to have paper field notes then transfer your notes to the spreadsheet?

I have been contemplating setting up a cheap PC at the shooting bench and directly entering my loads & chrono data into a spreadsheet, eliminating the need for paper field notes. Or if you shoot at a public range you could carry a notebook computer or perhaps even a smart phone for the same purpose, though I am too old school for smart phones. :D

There are several ways to post your EXCEL graphs. The way I do it is to use a graphics program to capture a screen shot of the graph, save the screen shot as a JPG, and then upload it to Photobucket or Picasa like any other JPG. Here I used the URL of Ken's attached JPG to embed your graph in my post.

By the way, it looks like accuracy improves as you add more powder. What happens if you increase the charge to 9 gains? http://castbulletassoc.org/attachment.php?id=6691

Attached Files

CBA Member

Ken Campbell Iowa posted this 18 May 2016

record keeping .. a major advantage to electronic records is that of search capability .

i am not a whiz on excel, but at worst you can have windows search for file names .

jim scearcy has a nice excel spreadsheet in which you enter the x-y co-ordinates of each shot up to 20 shots ... it then makes a graph of your target and tells you the center of the group, and the mean radius . if you label that file right, you can search for it later .

a nice thing about entering each shot in order is that you can see if there is a pattern as more shots are fired .

i added to my copy a function which tells group size, just for practice; so far i think it works.

there are probably many other programs out there for target data, but one advantage to jim's is that you can modify his spreadsheet to show all kinds of interesting things ..

for instance i like to see standard deviation of impact, even though this does not give a clearly useful factoid of the group .

RECORD KEEPING

Categories

Search

Popular Tags

This Weeks High Earners

Hot Topics