If you look in the picture, you will see I have canned goods and dry goods seperate. Why, just did it that way. The canned goods also have columns labeled "cans, calories, servings, calories per can and total calories". First column is Corn, put the total number of cans you have on your shelf. If you havent figured out that nutrition labels on food items, they are all pretty much standard and should be almost identical on every brand name. Next column lists the calories-per-serving in each can. Next column is calories-per-can. Final colum is total calories of all the Corn. The Excel formula for this line item is: "Click on column "H", row "2". H2 is where you want the total calories for canned corn to be displayed. Column "H" is the SUM column
=D2*G2, translated as, =(SUM) Column "D", row "2" X(Multiply) Column "G", row "2"
Each item below Corn has the same formula except for the row number, it will be different. So the tenth row would be =D10*G10
Dry goods are setup simularly except I only use the pounds(LBS) to tell me how much weight I have in stock. Since most dry goods come in various sizes of product compared a base size for a canned good on the store shelve, I take the total number of servings per package and add them to the exisiting serving number I have in the list and multiply it by the calories per serving to get the total number of calories for that item. Formula for dry oatmeal is:
"Click on column "P", row "2". P2 is where you want the total calories for oatmeal to be displayed. Column "P" is the SUM column
=N2*O2, translated as, =(SUM) Column N, row "2" X(Multiply) Column "O", row "2"
Same as before, each item below oatmeal will have same column, just different number.
The totals at the bottom reflect total calories for canned goods which are 495,111 and dry goods are 1,717,248 which equals 2,212,359 and would last one person 1106.2 days on a 2000 calorie diet.
This next picture shows basically the same as what I have written above, except it is for Dehydrated/Freeze Dried and for Ready Made Meals such as pouches from Mountain House, Wise Foods, Etc, Etc. Same formula principle applies, total calories multipled by servings equals total calories. When looking at the multi-colored section, I added both dehydrated/freeze dried and Ready-made-meals together for the final row.
The multi-color section is for daily caloric intake based on a family size of four. Looking at the dark green is depicts 8000 CPD for a family of four. Now, I have two small boys, they do not eat 2000 calories a day, even when they pig out. But if they did, it would show I have 320.8 days of food in stock. Another issue to consider is I personally dont eat 2000 calories a day. I operate just fine on one meal a day, been doing it for along time. So if we all only eat 4000 calories a day, we have enough for 641.6 days. The formula in this section is the totals of all the canned goods, dry goods, dehydrate/freeze dryed and ready-made meals divided by the caloric intake (8000-3000).
This section's formulas are more elaborate to write it out, if you click on, say the canned goods number under 8000, and look to the top line (formula bar, a.k.a "fx") if will show you the formula.
For people who like pretty pictures of bar graphs, here is a brief visual of what you inverntory is saying.
The final picture is of the Food Deduction Sheet. This sheet is important. If you rotate items out of you inverntory, you need to account for them. "IMPORTANT"!!!, if you want your inventory to be accurate as possible, you have to do this. I have held a DRB with JUGM over this, she now has it posted on the Fridge. If you remove many items from your list, well then you will have to do a count on your inventory. That sucks, trust me. I have been storing food for about 6 years now, I will not do that again. All you have to do is list the item you take, number of items and the date. When I update my list, I save the list with the date I last updated it. Example, FOODSTORAGE_OCT12012. Next update say would be FOODSTORAGE_NOV12012.
If you have Microsoft Excel and have never used it, trust me, it is easy to learn. It is helpful for many things, budgets, Food inventory, Statistics, phone numbers. DO NOT BE INTIMINATED BY IT. If you would like a copy of this, shoot me an email and I will send you a blank copy with instructions of how to add stuff or delete stuff.