Excel Version of .22 and .45 Ammo Testing

by Edwin C. Hall

Back to Homepage

Description

First, I'd like to thank Mr. Jan Brundin for sending me the initial file from which this was made. His work in setting up the original spreadsheets allowed me to advance this package to what I'm using today.

This Excel package is a growing database of my .22 and .45 testing. By using the macros I can input data for a particular session and the data will be placed not only on their own sheet, but will also be added to a sorted list of ammo on a page which shows the best loads to worst loads for the caliber.

Note1: This file contains macros. They are not certified or signed in any way so they may be flagged and/or disabled by your machine, especially if your security settings are high. In order to use the macros you may need to lower your Macro Security settings.

Note2: The original version had an annoying link to a clark38 file. That may now be gone (hopefully). If you experience this problem please send me a note. You should be able to choose to ignore the link and continue with the file.

Features

• Has separate sheets for each group
• Provides a group rating which is based on how many of the group are more centered
• Automatically calculates group size and possible score
• Has macros for entering data and sorting results
• Measurements are input by drawing a right angle near the group and then taking x and y dimensions with a ruler or calipers, etc. of each hole
• A graph is drawn of each group, however you will have to manually size the graph and the plot points are not size representative of the caliber in use

Download targetstats.zip (targetstats.xls) (approx 150k - expands to approx 1 Meg)