WELCOME to our Family Preparedness Blog!

Here you can obtain the information that we discuss in our monthly meetings, run it off for your notebooks
and have the information that you need to get and be prepared.

Check back often. Our blog
will regularly provide new subjects and information in our posts.

9/23/2011

Excel Family Food Storage Plan


 These instructions are for those who have the Excel program that helps you take your food storage inventory.  If you don't have that plan as yet please let us know by sending us an email at familyprepared@gmail.com  We will then send you the link to the program.


Click on the program in your email.  Open the program.  It should open in an Excel File in your Microsoft Word program.
STEP ONE
-After you read the Instruction sheet, click the tab at the bottom left of the page titled “2000 Calorie Plan”.
-Type in the number of family members at the top of the page to personalize the program for you.  Make sure you click on “Enable Edit” if you can’t  type in these numbers.  Check to be sure your family numbers and ages are correct at the top of the columns.  Then print the four pages. 
-Take a highlighter marker and make a line down the columns that pertain to your family. 
-Take your clipboard to where your year’s supply is and mark how much you have of the things listed
-Mark the amounts you currently have on hand and mark in the “Notes” column the foods that are expired.  (You may want to set these cans aside and see if the food is still edible and incorporate it into your family’s meals now.)

STEP TWO
  Go back to the Storage Plan and click on the “Custom Inventory” tab at the left bottom of the page and make sure the family info. is correct on this page,  and decide how many months you want to start working toward.  Fill in your amounts and then run it off.   
NOW YOU HAVE AN IDEA OF WHAT YOU STILL NEED TO GET TO MAKE YOUR 3 MONTH TO A YEAR’S SUPPLY UP TO DATE.  THE STAKE WILL BE MAKING AVAILABLE THE FOODS THAT THEY WILL BE CANNING FOR OUR BENEFIT THROUGHOUT THE YEAR.  YOU WILL BE NOTIFIED WHEN THESE ARE READY FOR YOU TO PURCHASE.

CONVERSION CHARTS FROM POUND WEIGHT TO #10 CAN WEIGHT
Food Item
#10 Can
5 Gallon Bucket

Wheat-Hard Red*
5.5 pounds
37 pounds
White Flour
4.5 pounds
33 pounds
Cornmeal
4.3 pounds
33 pounds
Popcorn
5 pounds
37 pounds
Rolled Oats
2.5 pounds
20 pounds
White Rice*
5.4 pounds
36 pounds
Spaghetti
N/A
30 pounds
Macaroni
3.1 pounds
21 pounds
         Quick Oats*                  2.4 pounds                   
Dried Beans
5.6 pounds
35 pounds
Lima Beans
5.4 pounds
35 pounds
Soy Beans
5 pounds
33 pounds
Split Peas
5 pounds
33 pounds
Lentils
5.5 pounds
35 pounds
 Pinto Beans, Dry*                 5.2 pounds
White Sugar
5.7 pounds
35 pounds
Brown Sugar
4.42 pounds
33 pounds
Powdered Milk
3 pounds
29 pounds
Powdered Eggs
2.6 pounds
20 pounds
 #10 can data comes from ShelfReliance.com and is what THEIR #10 cans contain. Numbers could be slightly more or less elsewhere.
* These amounts are from Our Church Cannery #10 can weight for these items
The rest of this information was obtained from:
Other websites with Food Storage spreadsheets:

 If you need us to calculate this for you please let Argene Richards know or send this email back to me and tell me how many members of your family there is and the ages and I will run it off for you and bring it to you, or you can pick it up from her.