I am starting this thread for the excel spreadsheet I made back in college to track my practice and matches. A number of folks asked for a copy from another thread. I typed out directions for it when I emailed it to them. Those directions will be in the next post. read through it, and if you think you might want a copy, drop me a PM with your email address and I'll send it to you.
Feel free to leave comments/feedback/bugs you find here and I'll get to them when I can.
Thanks.
Rifle Spreadsheet/Graphing
Moderators: pilkguns, Marcus, m1963, David Levene, Spencer
First off, the empty sheet has a large number of circular references. Once you start putting data in, these will resolve themselves. I have not locked any of the thousands of formulas, so I highly suggest saving this blank version of the file by itself and entering your data in a separate version.
When you first open the file, you will be in the Formulas page. In the top left, there will be a black box which is meant to resemble two 12-bull targets next to each other. You will see I have typed in the order I shoot my bulls, you will need to replace this with the order you shoot your bulls. After that, unless you decide to change how you shoot your bulls, try to stay away from this sheet because it's the hub for all the graphs in this file.
Scroll to the far left side of the list of worksheets at the bottom. There are adjustment and diary pages, though I personally put all of that data in my diary with my shooting gear. Next is a scores page. Ignore this one. This file was designed for a college rifle team. The shooters put their 10 shots strings in this page after each practice, and email them to the coaches each week to generate team rankings. Those rankings were automatically generated by a master spreadsheet.
The SB Raw Scores sheet is where you can enter your 10 shot raw practice scores for each position. These will be graphed on the next sheet to show your progress.
Next, scroll to the Prone 20 Practice worksheet. This will be your data entry lesson. You'll enter your shot scores in the order in which you shot them, P1 through P20. Scroll down a little bit more, and enter the shot direction, using the clock system (12 high, 6 low, 3 right...) for each shot in the order you shot them. And you're done.
The next worksheet will graph your shot value for your average (white line), your last practice (red line), and will graph your 200 point scores.
Next, the Shots Lost graph shows how many shots one loses in each direction. Again, white is your average, red is your last practice. This can show NPA issues, not clicking your sights.
The Points Lost graph shows how many points are lost in each direction. Combined with the Shots Lost graph, this can tell you if the shots in each direction are costing your points, or you happen to shoot a lot of 10s at 12 o'clock (something I found I do a lot).
And the Points Lost per Shot (PLPS) graph shows how many points you lose per shot in each direction. This shows you where your wide shots are.
Those are the Prone Practice sheets, there are duplicate sheets for standing and kneeling practice.
Next is a Half Course sheet and graph. This is for practice half courses. Same data entry, score by shot, then scroll down for shot direction. There are no shot direction graphs for this one, if you can figure out the order in the mess that the formulas are organized in, you are welcome to add them.
Now we get to air rifle. There are 40 and 60 shot options with the shots lost, points lost, and PLPS graphs. But you get an added bonus with the practice target sheet. On this one, it shows you Points Lost for each bull, red line for your last practice, white for your average. With the number of NPA changes shooting 12 bulls, we found on the college team that everyone had two bulls where they seemed to lose 3-4 points each, even shooters in the 580s range seemed to lose points on the same bulls. Below the bulls, there are two more graphs, one counts shot values, the other is a bar graph of your 10 shots strings (red is last practice, white average, yellow is your personal best for these two graphs).
The Air 60 SAM sheets are our Simulated Air Match pages. On the team, your team rank was a 7 part weighted average. Your practice scores were 1/7, your SAM scores were 2/7, and your match average was 4/7. I have left this in here so everything will still work with the master spreadsheet.
Then there are sheets for 60 shot air rifle match scores, which includes the Targets sheet with per bull analysis.
Last is Half Course Match sheets. The first sheet you enter shots by value and direction per usual. The next graph sheet is the usual line graph. Then there is a 10 shot string score entry and graph. Lastly, the match is broken down into prone, standing, and kneeling, shots lost, points lost, PLPS, and per bull points lost.
And there you have it. I know it's unwieldy to the n-th degree, so if anyone has programming experience and can put this into java, basic, or whatever code would make it a little easier to work with, have at it (and send me a copy please).
When you first open the file, you will be in the Formulas page. In the top left, there will be a black box which is meant to resemble two 12-bull targets next to each other. You will see I have typed in the order I shoot my bulls, you will need to replace this with the order you shoot your bulls. After that, unless you decide to change how you shoot your bulls, try to stay away from this sheet because it's the hub for all the graphs in this file.
Scroll to the far left side of the list of worksheets at the bottom. There are adjustment and diary pages, though I personally put all of that data in my diary with my shooting gear. Next is a scores page. Ignore this one. This file was designed for a college rifle team. The shooters put their 10 shots strings in this page after each practice, and email them to the coaches each week to generate team rankings. Those rankings were automatically generated by a master spreadsheet.
The SB Raw Scores sheet is where you can enter your 10 shot raw practice scores for each position. These will be graphed on the next sheet to show your progress.
Next, scroll to the Prone 20 Practice worksheet. This will be your data entry lesson. You'll enter your shot scores in the order in which you shot them, P1 through P20. Scroll down a little bit more, and enter the shot direction, using the clock system (12 high, 6 low, 3 right...) for each shot in the order you shot them. And you're done.
The next worksheet will graph your shot value for your average (white line), your last practice (red line), and will graph your 200 point scores.
Next, the Shots Lost graph shows how many shots one loses in each direction. Again, white is your average, red is your last practice. This can show NPA issues, not clicking your sights.
The Points Lost graph shows how many points are lost in each direction. Combined with the Shots Lost graph, this can tell you if the shots in each direction are costing your points, or you happen to shoot a lot of 10s at 12 o'clock (something I found I do a lot).
And the Points Lost per Shot (PLPS) graph shows how many points you lose per shot in each direction. This shows you where your wide shots are.
Those are the Prone Practice sheets, there are duplicate sheets for standing and kneeling practice.
Next is a Half Course sheet and graph. This is for practice half courses. Same data entry, score by shot, then scroll down for shot direction. There are no shot direction graphs for this one, if you can figure out the order in the mess that the formulas are organized in, you are welcome to add them.
Now we get to air rifle. There are 40 and 60 shot options with the shots lost, points lost, and PLPS graphs. But you get an added bonus with the practice target sheet. On this one, it shows you Points Lost for each bull, red line for your last practice, white for your average. With the number of NPA changes shooting 12 bulls, we found on the college team that everyone had two bulls where they seemed to lose 3-4 points each, even shooters in the 580s range seemed to lose points on the same bulls. Below the bulls, there are two more graphs, one counts shot values, the other is a bar graph of your 10 shots strings (red is last practice, white average, yellow is your personal best for these two graphs).
The Air 60 SAM sheets are our Simulated Air Match pages. On the team, your team rank was a 7 part weighted average. Your practice scores were 1/7, your SAM scores were 2/7, and your match average was 4/7. I have left this in here so everything will still work with the master spreadsheet.
Then there are sheets for 60 shot air rifle match scores, which includes the Targets sheet with per bull analysis.
Last is Half Course Match sheets. The first sheet you enter shots by value and direction per usual. The next graph sheet is the usual line graph. Then there is a 10 shot string score entry and graph. Lastly, the match is broken down into prone, standing, and kneeling, shots lost, points lost, PLPS, and per bull points lost.
And there you have it. I know it's unwieldy to the n-th degree, so if anyone has programming experience and can put this into java, basic, or whatever code would make it a little easier to work with, have at it (and send me a copy please).
-
Mike in OZ
- Posts: 14
- Joined: Thu Aug 23, 2012 12:15 am
- Location: Central Victoria, Australia
How do you fillout a spreadsheet showing finances? I have to make a spreadsheet showing incoming and outgoing expenses. Is there a special format to use?
________________________
market samurai ~ marketsamurai ~ marketsamurai.com
________________________
market samurai ~ marketsamurai ~ marketsamurai.com