Forums
New posts
Search forums
What's new
Articles
Latest reviews
Author list
Classifieds
Log in
Register
What's new
Search
Search
Search titles and first posts only
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Rifles, Reloading, Optics, Equipment
Reloading
Calculating group size in excel
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="QuietTexan" data-source="post: 2776542" data-attributes="member: 116181"><p>Manually measure the mean radius distances on each target and put them into excel to aggregate. You won't get a visual overlay of actual targets, but you'll get ATC group size and SD of horizontal and vertical dispersion from it, which is what really matters. If you really want a visual you'd have to do a second step of adjusting all the relative X/Y to the average center and plotting them on a cartesian plane. This is the manual version of what Ballistic-X is doing based on overlaying a digital grid on the picture you upload. It would be nice if they offered either 1) and export of the raw coordinates, or 2) an option to save coordinates into a profile and aggregate them for us.</p><p></p><p>[URL unfurl="true"]https://www.ar15.com/forums/AR-15/Mean-Radius/16-512887/[/URL]</p><p></p><p>Target example: (turns out I punched a random example of excellent accuracy with poor precision, group was almost perfectly centered on the aim point <img class="smilie smilie--emoji" loading="lazy" alt="🤣" title="Rolling on the floor laughing :rofl:" src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f923.png" data-shortname=":rofl:" />)</p><p>[ATTACH=full]448419[/ATTACH]</p><p></p><p>Excel Example</p><p>[ATTACH=full]448420[/ATTACH]</p><p></p><p>[ATTACH=full]448421[/ATTACH]</p><p></p><p></p><p>If anyone is curious, the keystroke of CRTL+ ` (accent/tilde key, left of '1' and above 'Tab') flips Excel to showing cell contents instead of cell results, that's what is showing the formals in the second screen shot.</p></blockquote><p></p>
[QUOTE="QuietTexan, post: 2776542, member: 116181"] Manually measure the mean radius distances on each target and put them into excel to aggregate. You won't get a visual overlay of actual targets, but you'll get ATC group size and SD of horizontal and vertical dispersion from it, which is what really matters. If you really want a visual you'd have to do a second step of adjusting all the relative X/Y to the average center and plotting them on a cartesian plane. This is the manual version of what Ballistic-X is doing based on overlaying a digital grid on the picture you upload. It would be nice if they offered either 1) and export of the raw coordinates, or 2) an option to save coordinates into a profile and aggregate them for us. [URL unfurl="true"]https://www.ar15.com/forums/AR-15/Mean-Radius/16-512887/[/URL] Target example: (turns out I punched a random example of excellent accuracy with poor precision, group was almost perfectly centered on the aim point 🤣) [ATTACH type="full" width="602px" alt="IMG_6929.jpg"]448419[/ATTACH] Excel Example [ATTACH type="full" alt="excel 1.jpg"]448420[/ATTACH] [ATTACH type="full" alt="excel 2.jpg"]448421[/ATTACH] If anyone is curious, the keystroke of CRTL+ ` (accent/tilde key, left of '1' and above 'Tab') flips Excel to showing cell contents instead of cell results, that's what is showing the formals in the second screen shot. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Rifles, Reloading, Optics, Equipment
Reloading
Calculating group size in excel
Top