I had been looking for a way to calculate how long my stockpile of food and water will last me and my family. I did not find what I was looking for, so I created my own way to calculate the time my stockpile would last. I used Excel sheets to do all the calculations.
How these sheets calculate how long a stockpile will last is simple. For water the entire amount of water is added up to a total in gallons, then divided by the number of gallons each person will need a day, then divided by the number of people living off the stockpile.
To calculate how long food will last all food items are converted to their calorie amount. The entire amount of calories are then divided by the estimated calories needed per day to survive, then divided by the number of people that will be living off this stockpile.
The numbers that you enter for gallons needed per day, calories needed per day, and the number of people that will live from this stockpile are on the first sheet. These numbers will affect the two yellow boxes. One yellow box is the number of days food will last, the other yellow box is the number of days water and other drinkable liquids will last.
On the other sheets are where all the food calorie data, and water, are entered and totaled up. When looking at the calories on the labels of prepackaged food be sure to get the total calories in the entire container. Be sure to look at the number of servings per container multiplied by the calories per serving.
Below I have put two Excel files. The first one is the blank calculations sheets. The second file is the same sheet with some data already entered into it show how the sheets work. To get the calorie amount for non prepackaged food you will need to do some research. If there is doubt about the number of calories in an item it is best to under estimate the calories. It is better to have more food than you believe you have then it is to be short. After entering all your data it will give you an idea of places you may need improvements in your stockpile.
I would like to thank all my followers of this page. If you have not already, please sign up for email subscription to this blog so you will be notified when there is a new article. To subscribe enter your email in the box provided in the upper right hand corner. Be sure to tell your friends about this page also.
Enjoy playing with the numbers and improving your stockpile.