First off, that last poll really surprised me. A full 50% of you people don’t keep track of what you have using anything more complicated than what’s between your ears. And only 1/5 of you use anything more technologically advanced than a paper and pencil.
Why am I surprised? Well, you’re sitting in front of a computer right now, aren’t you? You know how to work the thing, don’t you? So it seemed reasonable to figure that people who can figure out how to use a computer would take advantage of it for this sort of thing. However, a previous poll showed that the readership around here is..shall we say…a bit ‘seasoned’…and perhaps with the older demographic there is a resistance (or ignorance) towards the technological. Who knows. All in all, though…I was very surprised.
I use spreadsheets for keeping track of all my stuff that I need to consider myself ‘prepared’. You can call it your Master List, Inventory, TOE, or whatever. Since I have a bizarre sense of humour, I call mine The Preponomicon.
Anyway……
I use Excel. Mostly because I’m familiar with it and because I still haven’t sat my butt down in front of the computer and mastered Access. My spreadsheets don’t have anything really fancy to them, but I do have them wired up to alert me when inventory levels are at particular thresholds. This is signalled to me by changing the colors of the cells that show my percentage of quantity. At the moment it’s set up like this:
100%-90% = Green – All good
75%-89% = Light green – Okay, but you might wanna jump on this
50%-74% = Yellow – Next trip to the store, get this stuff
0%-49% = Red – Get this fixed ASAP.
It looks something like this:
How do we do the color change? Conditional formatting. Somewhere in your menu bar you’ll see it.
From there, under “Manage Rules”, are the rules I made:
And here’s the actual rule saying that if the value in that cell is equal to 90%, or more than 90%, make it green:
For the other values its just a mater of creating a separate rule for each one. And, yes, you can also use a rule that uses a color gradient rather than just these….I just went with something basic. What’s that you say? Still seems overwhelming? Alright, how about I give you a template to work with?
Fairly simple….Just a basic template. As you add stuff to your list copy the cells in Column M downwards to your new line. I threw in filters for the column headers in case you want to sort or see only a specific category.
Delete or add columns to add/delete the things you want to sort by. I de facto go with four categories so I can narrow down my focus….Gun stuff, Magazine, Glock, 9mm……Food, Dry, Freeze Dried, Rice & Chicken……Hygiene, Dry, Paper, TP….. that sort of thing. I throw two descriptors after that for brand/model and size. If you really want to go nuts, add a column for ‘servings per qty’ and ‘servings total’, throw in some math, and get yourself an idea of how many servings of oatmeal three five pound sacks will provide. I’m sure there’s someone reading this who is chuckling to themselves that this is a kludgy spreadsheet and that there’s a more streamlined way to do this. Hey, have it. Just showing ya what works for me.
If your virus warning pops up as you try to open the template, ignore it. They do that if there isn’t some sort of certificate or whatnot. This is just a half dozen or so lines of Excel.
If you find this useful, how about thanking me in a renumerative way? Oh, and I lay claim to the term ‘Preponomicon’ which, if you haven’t figured it out, is a nod to the necronomicon from ‘Evil Dead’.












