Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
12/9/2005 6:17:52 PM EDT
Hey guys,

I put this together, and figured you could use/alter/whatever it to your specific needs.  Good for 100 range trips, beyond that you'll need to just adjust the formula.

www.badongo.com/file.php?file=G17__2005-12-09_glock+17+shooting+lo.xls

Springer
12/10/2005 3:31:29 AM EDT
[#1]
Very nice and thanks for sharing!

I've been using a similiar spreadsheet(s) (not quite as nice lookingas yours) for years now. Hopefully someone can get some use out of this.
12/10/2005 7:37:06 AM EDT
[#2]
Nice log sheet. Thanks  
12/10/2005 8:19:28 AM EDT
[#3]
Off topic: HotRod9mm, I see you know have a team membership! Congrats man, I was going to buy you one for Xmas since you are such an asset to this board. I guess I'll buy someone else one now
12/10/2005 8:28:50 AM EDT
[#4]
When I downloaded it my antivirus said something abut a Trojan ??? Just kidding! Nice job and thanks.

12/10/2005 5:01:06 PM EDT
[#5]
Cool, glad you guys like it.  Feel free to play around with it for your different weapon types, I have one for each of my weapons.

Springer
12/11/2005 6:59:13 AM EDT
[#6]
Thx M4arc!


Ok, I'm not up on Excell at all. There seams to be a "value" limit set on the bullet weight. How do I reset it so I can add 40 & 45 data?

TIA
12/11/2005 12:35:30 PM EDT
[#7]
Ok, list is being taken from the second sheet.  What you can do is look in that sheet and modify the data, select them all, and towards the top left of the screen the cell names will be listed.  You can name that "Ammo" and it should fix it.  If not, select the cell and click "Data" on the top list, then click "Validation."  You should then be able to choose "Any Value" and you can put whatever you want in there.  If you're having trouble, let me know what you would like to show up and I can throw it together and email a copy back to you.

Springer
12/11/2005 10:18:24 PM EDT
[#8]
Wow, thats great.

Thanks
12/12/2005 8:20:16 AM EDT
[#9]
No prob, glad you liked it.

Springer
12/12/2005 8:43:39 AM EDT
[#10]
I have an honest question and I in no way intend to offend or insult anybody with it.

Why would you do this for a pistol?  I could understand it for a bench rest rifle or tricked out bullseye gun but not G-17.  I am a huge Glock fan and that is all I shoot and I shoot GSSF and other matches and such so I have put many rounds down range.  My best guess of rounds for my G-17 is some where north of 5000 and for the G-21 is somewhere around 7000 and they shoot the same as they did the day I got them.  I do function test the springs regularly and replace the springs a needed.  I know old school shooters that log their rounds as you have and would benefit from your spread sheet and I will inform them of it but I don't see it for a pistol that is rated for 50,000-55,000 NATO pressure rounds (+P or +P+) no where near WWB pressures.  

I'm just asking, maybe I should start a log.
12/12/2005 8:55:09 AM EDT
[#11]


Why would you do this for a pistol?




Good question.  I guess I just for my own record to see where it should be in regards to maintainace, etc, and also just out of keeping track of how many rounds downrange, i.e. I ran into problem x at round #5,254.