I have a multi-page spreadsheet that helps you budget your supplies, money for those supplies, maintain inventory, etc. The sheets are all tied together so you update one cell and – shazam – your totals change accordingly.
I’ve had this thing forever, don’t remember where I got it, but there appears to be no copyright statement, nor any author’s claim to it. The categories covered: food, general, books (remember – knowledge is power), tools, medical, ammo and weapons.
HERE IS YOUR LINK – to download the FREE spreadsheet!
Cool, huh? Use it to prep, and remember me when you gotta do some Amazon shopping action.
- Ranger Man
BTW: Can anyone in my age bracket remember what old computer game hosted the following?
Related posts:
- Free Internet Tools for SHTF Folks (Tin-Foil Hat Wearers)
- Super Cheap Survival Bunker Building in Buffalo
- Army Field Manuals in Your Survival Book Collection
Attention - if you like SHTFblog, please subscribe by RSS or email.
{ 19 comments… read them below or add one }
Would that be Oregon Trail?
Greetings from slightly to your north! I’ve been following your blog for almost a year it is very well done. I look for balance and there is balance here. This spreadsheet is a great tool and another sign of careful consideration and planning.
I initially broke our prep into categories that have served us well up to now. Your spreadsheet categories reminded me of them, and the emphasis on technical resources makes me think to add another category, even though I want to keep it to fewer categories and tech books kinda fits under tools. Anyway, thanks for posting the file, and thanks for a good solid blog. I hope these post correctly from the word doc:
A. Food & Water: Skills/tools for storage, preparation, filtering, handling, and serving food and using water without electricity or bulk gas delivery.
B. Shelter & Clothing: Safe & secure housing, heat, light, and durable clothing. Again the emphasis is on operation without outside energy sources.
C. Health & Sanitation: Not only “first aid” stuff but skills/materials to care for injured/ill persons, handling waste, cleaning laundry, kitchen and bathroom.
D: Safety & Security: Skills/materials needed to safely handle a variety of contingencies and maintain security of the household.
E. Communication and Identification: Communication plan, alternative methods, and contacts for family members. Important documents located, copied, and securely stored.
F. Transportation, Navigation, Packing: Reliable, weather and terrain capable vehicle with needed supplies and navigation aids, and a safe destination.
G. Tools: Basic hand tools and the skill to use and maintain them; skills to make basic household and automotive repairs. Also tools needed to maintain a daily routine without electricity, and to manage specific anticipated problems.
yep, Oregon trail
get it here:
http://www.xtcabandonware.com/game.php?id=theoregontrail
Oregon Trail was a staple in classrooms across America during the 80′s.. ;)
thanks for that spreadsheet thats sweet.
you might want to add high cap. mags to the weapons catagory somewhere to keep track of what you have
Loved Oregon Trail… Played it on an old green screen Mac.
Thanks a ton for the spread sheets!
Loving the spreadsheet Rangerman, but there are some questions I have:
In the food section, some of the items appear to be kept in pounds of that item, while other items are in total amount. Could you sub-divide these for clarification’s sake? I am thinking that most of the items are in pounds, but I’m curious to be sure.
Also, when entering the pricing per unit (of food) it can be harder to do it per pound. For instance, I was playing around with it here at work (will store it at home for sure) but when I entered 50 LBS of Pinto beans, I couldn’t figure the cost per lb. easier than I could just enter it in total cost. Do you just circumvent the equation in the box for those items?
lol, sorry if I lost anybody in there…
Also:
what is meant by “short 10%” in Ammo and “Cover” in Books?
The more I look at the food section the more it confuses me. Maybe it’s my OCD, but I’ll have to separate it by good in LBS and others in servings, etc.
I am real happy to have this to work off of though, so thank you. I’ve wanted to make one of these forever, but it seemed to daunting a task, even for someone as familiar with excel as I am. I can now just tweak what I want to tweak. :)
Kyle bro, can’t help you out. I didn’t build the spreadsheet, just tossed it up there. Use it as best as you can, tweak it as you see fit. Sorry dude.
- RM
no problems. I’m already farther than what I was this morning :)
I love the spreadsheet! not even gonna lie! it is great! gives me somthing to keep track of my preps! awesome addition Rangerman!
Hmm…being a carpenter, if I bought 50 pounds of beans for 29.95 (ex. price), I’d enter the amount as: Beans, 50 lb@$29.95(divided by 50) = 0.599 cents per pound.
Interesting post, Ranger Man- now if I could only figure out what a ‘spredsheet’ is, I may be able to use it. Guess I’ll have to stick to pencil and paper (pencil, cuz I make a LOT of errots!)
Shy
I know how to divide Jim….I was just saying it’s much easier to put in the price that you bought the goods for when bought in big amounts. It takes out a whole step to take out the equation and just simply write in “$29.95″ than to divide by 50, then have the equation multiply by 50 to get your price back.
sweet spreadsheet. definitely beats the several paper pages i have hanging from the back of the door of my storage room. maybe i’ll still keep those, in case the power goes out… or should i just pull out the gennie?
You could always just keep a hard copy on the back of your door, then update the program once a week, either before or after you go shopping (or both).
Stan Deyo from Millenium Ark has an even more obnoxious list in Exel format, which helps you calculate based on the ages and sex of those within your household, and includes your pets. I also have a hard copy of a list created by the Y2K woman website (before it got hacked) somewhere in my notebooks.
Which is where my idea comes in. Anything you’ve downloaded to help you with gardening, animals, or crafts…you should print out a hard copy and keep them in notebooks. Unless you have alternative power, your computer is going to be fairly useless.
SWEET spreadsheet. Thanks, man! I’m divig into it right now!
Ranger Man ROCKS!
I’m younger then you but I loved that game. Also big props on the spreadsheet. I’m going to use it for sure. Been learning the joys of excell at work and tracking preps could be cool. Knowing what gets spent on what would be interesitng. Then again I am a bit scared to keep track of total spending on preps.
RangerMan,
I linked your site and the spreadsheet from over at thesurvivalpodcast.com. Hope someone tosses you a bone or 3 for the effort!
millerized