Posted: 6/21/2009 5:24:26 AM EDT
| Anyone have an inventory spreadsheet(s) they would like to share for food, supplies, defensive items? |
| my old computer had an excel ss that i made for ammo. you changed the amount for each particular caliber and bullet type, and there were subtotals it added up for pistol, rifle, shotgun, different loads, and a grand total-ammo whore amount. pretty easy to make and use, but that computer went to hell. |
|
I have an Excel file I use for ammo that tabulates totals for each caliber.
So many boxes of Brand A 9mm x units (box, case etc) x unit measure (how many in box etc) = total rounds of Brand A 9mm At the bottom of the page I made a total of all of that particular caliber. There is a seperate page that has just the totals from each of the other pages. I also keep an inventory of all my mags this way too. They are pretty easy to set up. If any are interested, I could upload it, minus MY inventory How would I upload the file here? I will post a screen shot later. |
|
I'll send you the one I use. Not sure if it's right for what you do, but it works great here.
E-mail [email protected] |
|
Done. Happy to send it to anyone else, too. Just e-mail me.
[email protected] |
|
Quoted:
http://i42.tinypic.com/8z33tc.jpg This is a screen shot of the 22LR page with the totals extremely edited. 
The other pages are similar, just a diff caliber. 
I think you're set on the .22, my man. 
My new hero. 
|
|
walton feed has a spreadsheet you can download and use.
http://waltonfeed.com/old/grain/calc.html |
|
Quoted:
walton feed has a spreadsheet you can download and use. http://waltonfeed.com/old/grain/calc.html No worky. |
|
Quoted:
Quoted:
walton feed has a spreadsheet you can download and use. http://waltonfeed.com/old/grain/calc.html No worky. are you sure? It works for me. |
|
Quoted:
Quoted:
Quoted:
walton feed has a spreadsheet you can download and use. http://waltonfeed.com/old/grain/calc.html No worky. are you sure? It works for me. THIS link works, but links on the web-site to the actual spreadsheets are 404'd. |
|
Quoted:
Quoted:
http://i42.tinypic.com/8z33tc.jpg This is a screen shot of the 22LR page with the totals extremely edited.
The other pages are similar, just a diff caliber. http://farm3.static.flickr.com/2419/1849109365_569a41f236.jpg?v=0 I think you're set on the .22, my man.
My new hero.
my numbers are off just a hair. so, either I had to adjust the numbers down so as not to attract any attention or, I had to run the numbers up so that nobody would believe it... BTW, does ANYBODY out there think 100k is enough? 
|
|
Quoted:
I have an Excel file I use for ammo that tabulates totals for each caliber. So many boxes of Brand A 9mm x units (box, case etc) x unit measure (how many in box etc) = total rounds of Brand A 9mm At the bottom of the page I made a total of all of that particular caliber. There is a seperate page that has just the totals from each of the other pages. I also keep an inventory of all my mags this way too. They are pretty easy to set up. If any are interested, I could upload it, minus MY inventory How would I upload the file here? I will post a screen shot later. Upload it! :D I like to use http://sendspace.com/ for this kinda stuff. |
|
Thanks! Its been a big help getting my own ammo inventory organized. Thanks again 
|