Home > DOE article and Average Group Radius Spreadsheet
Using Design of Experiments (DOE) to Work
up a Match Load
PDF copy of my Design of Experiments article first published in
the January 2003 issue of The Varmint Hunter Magazine (#45).
View the Design of Experiments article pdf
(113K).
A Microsoft Excel spreadsheet for calculating Average
Group Radius (AGR)
Calculating the Average Group Radius by hand using a calculator
can take some time and be prone to errors. Here is a Microsoft Excel
spreadsheet that makes the calculations for you. You enter X and
Y coordinates from your 3, 5, 7 or 10 shot target and enter them into the
appropriate columns. The accompanying Microsoft Word document explains
how to measure the coordinates using a ruler or dial caliper and also how
to scan the targets into the Jasc Paint Shop Pro graphics program to so
you can quickly measure multiple targets and get better accuracy in your
measurements.
All this is to aid in developing better loads for match target shooting
whether it be in developing a load for High Power Rifle shooting as we
do with the San Jose Zouaves or other shooting sports.
Download the agr_rev1.zip
file (253K).
