spreadsheets to keep track

Anything shooting related including law and procedure questions.

Moderator: dromia

Forum rules
Should your post be in Grumpy Old Men? This area is for general shooting related posts only please.
Post Reply
Message
Author
zzr1100

spreadsheets to keep track

#1 Post by zzr1100 »

Does anyone know of (or have) any ready made spreadsheets for keeping track of your shooting performance ? ie where your shots are going? are you improving ? graphs etc ?

Sorry for the nubies question ... i've tried making my own but its been 10 years or so since i used excel in anger ! sign85
User avatar
billgatese30
Posts: 430
Joined: Wed May 02, 2012 4:40 pm
Home club or Range: Bishop Auckland & District Gun Club...and anywhere that will have me.
Location: County Durham
Contact:

Re: spreadsheets to keep track

#2 Post by billgatese30 »

Its probably a very personal thing to each user, as it depends on what exactly you record at the range, and what discipline you shoot etc. It will also vary depending on what you wish to gain.

Do you simply want to record stage scores for each range and then plot the regression looking for trends (improvement etc) or do you want to record external variables (weather, wind speed/direction temperature, load etc) and then integrate poor scores against those variables to see where you suffer most (i.e. wind at 1000 yards, or maybe you do poorly in the cold but excel in the rain, load doesn't suit warm weather etc).

I'm sure if there is nothing out there already then it wouldn't be too difficult to create something which can be slowly added to as you find a new output to assess. Were you quite proficient in excel the last time you used it, there are several new functions in newer versions which I keep on discovering (thank you Google!) which often help simplify things which used to take 3 or 4 steps in older versions.
Chris
Ginger
Posts: 356
Joined: Sat Feb 12, 2011 11:50 pm
Contact:

Re: spreadsheets to keep track

#3 Post by Ginger »

Hi Chris,

you might find what you are after on this page

http://stevespages.com/table3.html

Scroll down to the bottom.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests