@jbell, this is a cool dataset. I've been pondering standardizing the dataset and adding a few fields of interest going forward due to coming changes from Vudoo and competitors (barrel twist rates, firing pin position, ammo, etc). This would be interesting to have for analysis.
Going forward, could the following be done?
- Compile the results in table format.
- Keep all results so a screen name/rifle can be tracked over time. I believe now the old results are removed and replaced with best scores.
- Standardize the fields to (other suggestions?):
- SCREEN_NAME
- AVG_GROUP
- AVG_MOA
- BEST_GROUP
- BEST_MOA
- MAKE
- MODEL
- BARREL
- FIRING_PIN
- TWIST
- CALIBER
- AMMO
- SIGHT
- DATE
- The above fields/data would be tracked for each post and kept as a record so old results don't disappear.
- This could be kept in a google spreadsheet, sorted by AVG_GROUP, and pasted here for each distance.
- The google spreadsheet could also be made publicly available as a csv, xlsx, ods, or html page.
I took ALL the previous data and compiled it into a spreadsheet. I tried my best to align the data for average and best groups. I believe the best groups were replaced as new ones were posted and they don't necessarily line up with the last average posted. It's kind of a fudge, but it's close enough. I also tried to standardize all the make/model names and barrel makers. I assumed a 1:16 twist unless specified otherwise or a different caliber than 22lr. Same thing for firing pin and barrel make which I assumed to be 12 o'clock and factory respectively unless specified otherwise. For Vudoo rifles, I assumed an Ace barrel unless specified. If another distance was specified, I rounded to the nearest of 50, 100, or 200 since that's how it was originally grouped. Some data is missing, but maybe it can be filled in as we go.
Here's the
google spreadsheet downloadable as an Excel file or viewable as an
html file.
What do you think?
Here's an example of the 200yd results pasted below since it's short.
SCREEN_NAME | AVG_GROUP | AVG_MOA | BEST_GROUP | BEST_MOA | MAKE | MODEL | BARREL | FIRING_PIN | TWIST | CALIBER | AMMO | SIGHT | DATE |
justin amateur | 1.38 | 0.659 | 0.430 | 0.900 | CZ | 455 | Lilja | 12 o'clock | 9 | 17HMR | | | 4/9/2018 |
tansinator | 1.722 | 0.822 | 0.599 | 1.256 | Vudoo | Sinister 16 | Ace | 12 o'clock | 16 | 22lr | | | 3/30/2019 |
Justin amateur | 1.73 | 0.826 | 0.610 | 1.260 | Savage | | Factory | 12 o'clock | 8 | 17WSM | | | 9/17/2018 |
jaia2 | 2.254 | 1.076 | 0.401 | 0.839 | CZ | 455 SOF | Factory | 12 o'clock | 9 | 17HMR | | | 3/19/2016 |
Aquatic_Robot | 2.373 | 1.186 | 0.918 | 1.923 | Anschutz | 64 MPR | Factory | 12 o'clock | 16 | 22lr | | | 11/20/2013 |
justin amateur | 2.4 | 1.146 | 0.669 | 1.400 | Savage | Barrel Block | Factory | 12 o'clock | 8 | 17WSM | | | 1/5/2020 |
JG26_Irish | 2.431 | 1.161 | 0.991 | 2.075 | Remington | 540XR | Factory | 12 o'clock | 16 | 22lr | | | 5/29/2014 |
jaia2 | 2.46 | 1.17 | 0.720 | 1.550 | CZ | 455 | Factory | 12 o'clock | 16 | 22lr | | | 12/8/2015 |
jbell | 2.623 | 1.253 | 0.724 | 1.516 | Vudoo | V-22 | Ace | 12 o'clock | 16 | 22lr | | | 8/18/2019 |
BillOH | 2.708 | 1.293 | 0.937 | 1.962 | Vudoo | V-22 | Ace | 12 o'clock | 16 | 22lr | | | 6/28/2019 |
komishe | 2.777 | 1.326 | 0.875 | 1.833 | CZ | 455 PT | Factory | 12 o'clock | 16 | 22lr | | | 12/19/2013 |
jbell | 2.783 | 1.332 | 0.900 | 1.875 | Sauer | 200TR | Factory | 12 o'clock | 16 | 22lr | | | 9/15/2013 |
VAGentleman | 2.868 | 1.304 | 0.969 | 2.131 | Anschutz | 64 MPR | Factory | 12 o'clock | 16 | 22lr | | | 9/8/2013 |
BillOH | 2.952 | 1.41 | 0.640 | 1.340 | Vudoo | V-22 | Ace | 12 o'clock | 16 | 22lr | | | 1/7/2020 |
drglock | 3.038 | 1.451 | 1.030 | 2.157 | CZ | 457 Varmint | Factory | 12 o'clock | 16 | 22lr | | | 6/28/2019 |
bm11 | 3.253 | 1.554 | 0.792 | 1.659 | CZ | 455 | Lilja | 12 o'clock | 16 | 22lr | | | 9/15/2013 |
Armorpl8chikn | 3.296 | 1.499 | 0.863 | 1.897 | Anschutz | 64 MPR | Factory | 12 o'clock | 16 | 22lr | | | 9/8/2013 |
theoriginaljbell | 3.486 | 1.448 | 0.802 | 1.932 | Anschutz | 54.18 | Lilja | 12 o'clock | 16 | 22lr | | | 6/6/2016 |
Justin amateur | 4.2 | 2.006 | 0.597 | 1.250 | CZ | 455 | Lilja | 12 o'clock | 16 | 22lr | | | 11/29/2019 |