Me and the Spreadsheet for Ammo
Posted: Sat Nov 11, 2023 5:36 am
Good evening, Bonjour, and Howdy to KCA Rookies. In keeping with my quality control theme I present to you the spreadsheet.
The spreadsheet is your friend. Your can trap any kind of info that you want. "Thank you, Captain Obvious. We've only known that for thirty years." True, true. But it pays to here it again every few years.
Moving on. The simplest information to trap is costs. In my sheet I capture everything relating to a purchase including the date in as machine sortable format. That would be yyyy mm dd. Name of the item, date, units per item, quantity of items, price per, total price, shipping, hazmat, taxes (ugh), Complete total, URL link, and then the best part. I created three cells for the price of each individual piece, and then the price of each piece with shipping, hazmat, taxes (ugh).
Most of the time it is simple arithmetic to get a good answer. Lean a little bit and I'll tell you. Let's I bought an eight pound jug of Varget for 320 dollars and because I want to keep track of where I spend my moola record it in the sheet. So a pound of powder is 7000 grains. Eight pound is 56000 grains. Using my toes to help count would not give the answer but =sum(320/56000) does.
I loaded up twenty 7.62x51 cartridges and primed another one hundred and fifty-one this afternoon. I know the total coast to build the cartridges thanks to the spreadsheet. "well, hold on. You show the SMKs as twenty-five cents. What gives?" Good eye. That was how much I paid for 175 SMKs seconds a couple of years ago. When I run out of those I will change the sheet to reflect the latest reality.
As you can see reloading does not save you any money looking at the big picture. What it does is you allow you to shoot more for the same money. Compare 87 cents to my 54 cents.
https://ammoseek.com/ammo/308-wincheste ... -175grains
good shooting to you
.
The spreadsheet is your friend. Your can trap any kind of info that you want. "Thank you, Captain Obvious. We've only known that for thirty years." True, true. But it pays to here it again every few years.
Moving on. The simplest information to trap is costs. In my sheet I capture everything relating to a purchase including the date in as machine sortable format. That would be yyyy mm dd. Name of the item, date, units per item, quantity of items, price per, total price, shipping, hazmat, taxes (ugh), Complete total, URL link, and then the best part. I created three cells for the price of each individual piece, and then the price of each piece with shipping, hazmat, taxes (ugh).
Most of the time it is simple arithmetic to get a good answer. Lean a little bit and I'll tell you. Let's I bought an eight pound jug of Varget for 320 dollars and because I want to keep track of where I spend my moola record it in the sheet. So a pound of powder is 7000 grains. Eight pound is 56000 grains. Using my toes to help count would not give the answer but =sum(320/56000) does.
I loaded up twenty 7.62x51 cartridges and primed another one hundred and fifty-one this afternoon. I know the total coast to build the cartridges thanks to the spreadsheet. "well, hold on. You show the SMKs as twenty-five cents. What gives?" Good eye. That was how much I paid for 175 SMKs seconds a couple of years ago. When I run out of those I will change the sheet to reflect the latest reality.
As you can see reloading does not save you any money looking at the big picture. What it does is you allow you to shoot more for the same money. Compare 87 cents to my 54 cents.
https://ammoseek.com/ammo/308-wincheste ... -175grains
good shooting to you
.