TargetTalk

A forum to talk about Olympic style shooting, rifle or pistol, 10 meters to 50 meters, and whatever is in between. Hosted by Pilkguns.com
It is currently Sun Jan 21, 2018 5:57 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Scores for US Coins
PostPosted: Tue Oct 17, 2017 1:08 am 
Offline

Joined: Fri Aug 03, 2007 5:17 pm
Posts: 72
Location: Colorado
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]


Attachments:
Pistol Coin Scores - 20171006t1327.pdf [14.85 KiB]
Downloaded 56 times
Top
 Profile  
 
 Post subject: Re: Scores for US Coins
PostPosted: Tue Oct 24, 2017 12:12 am 
Offline

Joined: Fri Aug 03, 2007 5:17 pm
Posts: 72
Location: Colorado
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group