Spreadsheet to Track Firearms Usage

[Zeteo]

I have been working on a Firearms Shooting Spreadsheet to track the ammo fired through and FTF/FTE issues that may arise in my weapons. It is also a great way to track the total weapons usage for my guns.

It is a work in progress, and suggestions for improvements are appreciated. You may download and use it if you like. I am attaching it here in both xls and xlsx format through a zip file. The first tab in the spreadsheet has a few entries in it in order for you to see how the spreadsheet calculates.

There are also some sample comments inserted to record type of ammo used.

Hope it helps someone!!!

Let me know if you like it.

Al

 

[125JHP]

It's a good idea to keep data such as this.
My personal system also uses Excel, however slightly differently.
I have a single page with each gun's info on a single line...

Make,Model,Cal,Ser No,Cost, etc... This is where I tally the rounds fired thru that gun.

I also have a printable Range sheet where I record the ammo details, chrono data etc. I use codes for problems encountered and then this gets transferred to a excel sheet where I keep all ammo performance records. The failure codes I use are:

FTX- Failure to eXtract
FTE- Failure to Eject
FTF- Failure to Feed
SS- Short Stroke Jam
SP- Stove Pipe Jam
MFJ- Magazine Failure/Jam

Pressure Signs - Describe
SC-Split Cases
CS-Case Separation

Primer Issues
PP- Pierced Primer
CP- Cratered Primer
BP- Blown/Loose Primer
FP- Flattened Primer

I suppose one could add a few for recoil, flash whatever you feel is important to record.

 

[Zeteo]

Made a few changes, it's a work in progress. Download this file for the newest update.

 

[LOBONCA]

Thank you. Very nice indeed!

 

[Bicky Robby]

Well done and thanks for sharing it. As an Excel user for almost everything, I bow to your ability.

 

[dondavis3]

Wow, well done ... and thank you

 

[Ben Cartwright SASS]

I think it is a great idea, my problem is I don't even have enough time to get to the range every few weeks let alone keep track of it.

I do have a way to tell which Military Guns I haven't shot yet, they are the ones still in cosmoline

 

[Knochen]

It's a good idea to keep data such as this.
My personal system also uses Excel, however slightly differently.
I have a single page with each gun's info on a single line...

Make,Model,Cal,Ser No,Cost, etc... This is where I tally the rounds fired thru that gun.

I also have a printable Range sheet where I record the ammo details, chrono data etc. I use codes for problems encountered and then this gets transferred to a excel sheet where I keep all ammo performance records. The failure codes I use are:

FTX- Failure to eXtract
FTE- Failure to Eject
FTF- Failure to Feed
SS- Short Stroke Jam
SP- Stove Pipe Jam
MFJ- Magazine Failure/Jam

Pressure Signs - Describe
SC-Split Cases
CS-Case Separation

Primer Issues
PP- Pierced Primer
CP- Cratered Primer
BP- Blown/Loose Primer
FP- Flattened Primer

I suppose one could add a few for recoil, flash whatever you feel is important to record.

Without the need to reinvent the wheel, care to share? I like the idea of having just one sheet.

 

[mcracco]

There are online and dedicated apps as well. I am using RangeLog.com. $5 iPhone app and free web account for the 'lite' version. Enter/view data from either iPhone or web interface.

But you can't beat the cost of an Excel ss.

 

[125JHP]

Here is a blank sample with some of my sheets included. Data has been deleted and row formulas are not included but you can get a pretty good start for your own system with the top row headers. I try to keep headers the same where I might copy/paste from one sheet to another. I just hide the unwanted columns on one or the other. The Range Sheet and Chrono data are an example. I hide a lot of columns for the range sheet printout but may use them in the master chrono data sheet where all loads are compiled for history.

I added comments to several fields to help understand its use a little better. I am providing these for discussion purposes only, not for general use.
Be careful reviewing the velocity calc sheet. It is an experiment for "what-if" amusement only. I was trying to explain the difference between load book published velocities (for a given load) and what I see from my own gun chrono tests. It tries to use loss per inch of barrel to estimate what velocities might be had with a given powder charge. It has flaws and should not be relied on for load development-just after the fact comparisons. All disclaimers apply, I will not be held liable for your use of it.

Sorry - had to re-upload the correct sample. dated the 28th

 

[Knochen]

Thanks, JHP! Nice and thorough job!!