Hi,
I've always wondered what various coins would score if on a pistol pellet target. So, I finally wrote a little Visual Basic function to do the calculation for me. I've posted the results below. Kinda neat to share with the kids (or parents).
Respectfully,
Chris
/[img]
https://drive.google.com/open?id=0Bzu-R ... 0V2a3FfUDQ
[/img]
Scores for US Coins
Moderators: pilkguns, Marcus, m1963
-
Chris__Colorado
- Posts: 81
- Joined: Fri Aug 03, 2007 5:17 pm
- Location: Colorado
Scores for US Coins
- Attachments
-
- Pistol Coin Scores - 20171006t1327.pdf
- (14.85 KiB) Downloaded 300 times
-
Chris__Colorado
- Posts: 81
- Joined: Fri Aug 03, 2007 5:17 pm
- Location: Colorado
Re: Scores for US Coins
Hi,
I've received several PMs about the excel spreadsheet.
Rather than send this out individually, I've attached the Excel spreadsheet to this post for all.
The macro is unprotected and the code is pretty well documented, so you can adjust it as you see fit.
It's just a brute force implementation of the scoring rings, literally looking up values in a table to see where the pellet scores.
It's not perfect and doesn't work the way I initially planned, but the table output shown in the previous posts is correct. I had to use an adjusted (by 1/2 a pellet width) input to the function as it's currently written.
It's not a finished product and why I didn't post it earlier, but here it is anyway :-)
Enjoy.
Chris
PS If someone adjusts the code to work better, please let me know. Thanks.
PPS Seems we can't upload an excel XLSM file, so here's a link to the file.
https://drive.google.com/open?id=0Bzu-R ... Dl2aXpEYXc
I've received several PMs about the excel spreadsheet.
Rather than send this out individually, I've attached the Excel spreadsheet to this post for all.
The macro is unprotected and the code is pretty well documented, so you can adjust it as you see fit.
It's just a brute force implementation of the scoring rings, literally looking up values in a table to see where the pellet scores.
It's not perfect and doesn't work the way I initially planned, but the table output shown in the previous posts is correct. I had to use an adjusted (by 1/2 a pellet width) input to the function as it's currently written.
It's not a finished product and why I didn't post it earlier, but here it is anyway :-)
Enjoy.
Chris
PS If someone adjusts the code to work better, please let me know. Thanks.
PPS Seems we can't upload an excel XLSM file, so here's a link to the file.
https://drive.google.com/open?id=0Bzu-R ... Dl2aXpEYXc