In the Hi Point Challenge thread at Tam’s, someone asked me about round count. I know I’ve talked about tracking rounds before, but here’s a copy of a single page of the spreadsheet that I use.
Link to Spreadsheet here.
This has worked very well for me to keep track of what I’m shooting, when I’m shooting it, etc. As you can see, the list of guns from 2009 is kind of psychotic – I spent a good chunk of 2009 going back and forth from one gun to another, until I settled on my S&W 625 near the end of the year. But the round counts and the malf counts are pretty accurate – I never go to the range without a pencil and a notepad, so that if something happens with a gun then I’m 100% aware of what’s going on with it. Another to note on there is that with the exception of the rounds I shot at Gunsite, I didn’t count .22 LR. It’s just not worth it to keep track of that, because I can go through 1k rounds of .22 like it’s not even there.
Now, my wife would say that I’m a spreadsheet geek (I am), but there’s value in this. If something happens to my gun at the range, I can look back at this and see if it’s a new problem, if it’s a problem that only occurs with this type of ammo, which means I can take measures to reduce the problem in the future. For example, my ParaUSA Tac-5 had continued failures to extract using 115 grain FMJ ammo, but when I used the hotter 124 grain NATO ammo it ran like a top. My 625 and S&B primers didn’t get along, so I didn’t use S&B ammo in my 625. The list goes on and on. Don’t like my format? That’s okay, because you can get one of your own!