Re: The 105 Hybrid Results Spreadsheet grouping error....
Fo those who downloaded my spreadsheet and plan to use it..........I received this and thought it beneficial to users.
Please note:
"When looking at your worksheet, I noticed that the "Group Size" output is being formulated as the Largest Spread of Vertical / Horizontal. It is wrote like this (=MAX(D49:E49) ).
That is not giving the actual group size and is giving which of those two is the greatest.
To compute the actual group sizes, it needs to have the "cosine" to each spread and the length of the largest cosine, and that being the actual greatest spread, hence being actual group size.
To test this, simply measure the actual targets shot, from the two widest bullet holes, and compare that to your worksheet's "Group Size" and you will see it is wrong.
Another way to think of this is the same as calculating the "RUN" of any angle. The "Length of the Run" is the same thing as a X - Y charted Group Size."
Please remember, there are a lot of references to other cells but you can make whatever changes you want or need. The above isn’t real important to me as I’m most interested in Consistant loads, Vertical Spread, Ladder results and then Group size.
I present this to you without warranty, implied or expressed but it does seem to work for me. Only enter data in the gray areas and make note how the data is input for grouping. I usually mark a crosshair on the target and measure off that and enter values as '+" for all data right or above the cross. Enter "-" values for left and below the cross. It's referenced on the spread sheet next to the first group graphing input area.
Hope it works for you and enjoy
BRXBrad
Fo those who downloaded my spreadsheet and plan to use it..........I received this and thought it beneficial to users.
Please note:
"When looking at your worksheet, I noticed that the "Group Size" output is being formulated as the Largest Spread of Vertical / Horizontal. It is wrote like this (=MAX(D49:E49) ).
That is not giving the actual group size and is giving which of those two is the greatest.
To compute the actual group sizes, it needs to have the "cosine" to each spread and the length of the largest cosine, and that being the actual greatest spread, hence being actual group size.
To test this, simply measure the actual targets shot, from the two widest bullet holes, and compare that to your worksheet's "Group Size" and you will see it is wrong.
Another way to think of this is the same as calculating the "RUN" of any angle. The "Length of the Run" is the same thing as a X - Y charted Group Size."
Please remember, there are a lot of references to other cells but you can make whatever changes you want or need. The above isn’t real important to me as I’m most interested in Consistant loads, Vertical Spread, Ladder results and then Group size.
I present this to you without warranty, implied or expressed but it does seem to work for me. Only enter data in the gray areas and make note how the data is input for grouping. I usually mark a crosshair on the target and measure off that and enter values as '+" for all data right or above the cross. Enter "-" values for left and below the cross. It's referenced on the spread sheet next to the first group graphing input area.
Hope it works for you and enjoy
BRXBrad
