Posted: 2/24/2010 4:23:03 PM EDT
|
I'm at the beginning stages of my food preps so I pretty much just have a ton of totes with canned food inside. I am having trouble keeping everything orgazined and until now I have just been writing everything down in a notebook that I keep with the totes. As you can imagine this gets very messy as I add and subtract food. What I am planning on doing is making a spreadsheet for each tote including the pertinent information (type, quantity, expiration date) that I can update and keep neat. I'd like to make it so the block turns red when it is a few months before the expiration date so I don't waste food. Unfortunately, I'm not Excel master and I have no idea how to do this. How do you guys keep your preps organized? Does anyone have a pre-made spreadsheet that they could email to me? Thanks, hopefully that makes sense to someone. |
|
I also add a calorie/weight colum for each food type, and have it keep a tally of the total cals I have. Really helps you understand the days of food you have vs just the volume or weight.
You can get the calories of the food types on the emergency essentials web site |
|
http://standeyo.com/News_Files/Hollys.html
Try this one. Click food storage on the left and then Deyo long term food planer. Sorry I don't know how to make this a hot link. 
|