Joined
·
356 Posts
Has anyone kept a running tally of what types of rounds they've purchased/used or how much they've actually spent on their PS90s?
Me personally, I keep track of the price of ammo lots I've bought, how they were divided (if there were different types of rounds in the lot), average price per round, when/what was used, and how much of each type is left. I've even got it set up with color-coded "depletion" warnings: >50% ammo left is GREEN, 50-25% is YELLOW, 25-10% is RED, and <10% is BLACK.
I've got all this in an MS Excel file. While I haven't actually fired a round yet, I've got it all set up for when I do start. Pretty much everything is auto-calculated for me. Another page in the same file keeps track of everything I've purchased for this particular carbine and how much everything was (including tax). I figure with all this information, I should be pretty set should I ever decide to sell it.
I'd be happy to share this file with anyone, completed as an example. My PM inbox is VERY full, so if you'd like a copy, just email me at ryanahorst(at)gmail.com... of course replacing the "(at)" with "@". Make sure the email subject line says, "FNH PS90 Expense Sheet Request". Anything other than this will be ignored/deleted. This will obviously be useful for those with Five-seveN pistols, too.
Edited: If you get a copy of this, make sure under the "Ammo" tab that all the ammo "Types" are entered in the exact same way each time. Otherwise, the calculations will not be correct. Also do NOT delete anything in the "K" or "L" columns. Doing so will delete the coding.
Me personally, I keep track of the price of ammo lots I've bought, how they were divided (if there were different types of rounds in the lot), average price per round, when/what was used, and how much of each type is left. I've even got it set up with color-coded "depletion" warnings: >50% ammo left is GREEN, 50-25% is YELLOW, 25-10% is RED, and <10% is BLACK.
I've got all this in an MS Excel file. While I haven't actually fired a round yet, I've got it all set up for when I do start. Pretty much everything is auto-calculated for me. Another page in the same file keeps track of everything I've purchased for this particular carbine and how much everything was (including tax). I figure with all this information, I should be pretty set should I ever decide to sell it.
I'd be happy to share this file with anyone, completed as an example. My PM inbox is VERY full, so if you'd like a copy, just email me at ryanahorst(at)gmail.com... of course replacing the "(at)" with "@". Make sure the email subject line says, "FNH PS90 Expense Sheet Request". Anything other than this will be ignored/deleted. This will obviously be useful for those with Five-seveN pistols, too.
Edited: If you get a copy of this, make sure under the "Ammo" tab that all the ammo "Types" are entered in the exact same way each time. Otherwise, the calculations will not be correct. Also do NOT delete anything in the "K" or "L" columns. Doing so will delete the coding.