It is currently Sun Aug 20, 2017 1:28 am


All times are UTC [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: DEYO FOOD STORAGE PLANNER-An Excel program
PostPosted: Mon Dec 11, 2006 3:13 am 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
DEYO FOOD STORAGE PLANNER

http://www.standeyo.com/News_Files/Food/DFSP.html

NOTE from Admin: This is a highly recommended planner! You can alter the excel sheet to add/delete items for your own personal household. Definately a must-see.==Scroll down to 'DEYO FOOD STORAGE PLANNER' == it's in RED lettters, on the page to download excel file.

The Deyo Food Storage Planner program works in Excel for either Macintosh or Windows and is a straightforward, easy-to-use spreadsheet. You will also need the latest version of Unzip to decompress the program. All you need to do is fill in the number of family members and how many weeks you want to store; the worksheet will calculate the quantities needed.

We have also provided the Minimum Shelf Life listed for each item. If you would like the Metric Measures version, click here. For our friends in America, click US Measures. These are copyrighted but freeware programs.

When you open the program, there are 12 columns of helpful data. The first column lists over 375 Food and Household Items with places for you to add 2 additional items in each category without having to make any changes to the sheet. (In Excel, it is very easy to add extra rows should the lines provided not be enough.) With the stroke of a button, you may delete any item not used by your family or leave it blank. Foods are organized by USDA food groups.

You can use the Deyo Food Storage Planner two ways:

METHOD 1

You can use the Select Amount for foods at the beginning of each category and plug in the amount of each food you want to fulfill the amounts suggested. To use this method, multiply the number of Adult Portions (B528) by the suggested amount of pounds or kilograms needed as in lines 5, 16, 29, 38, 59 and so on.

For example, for Metric, if you need 5 Adult Portions of Salt, multiply 5 x 1/2kg = 2.5kg Salt to store for 6 months. If you want to figure amounts for 1 year, multiply the suggested 2.5kg amount by 2 to = 5kgs. For only 3 months storage, divide the suggested amount to select for each category in half. For Salt, for 3 months, the stored amount would be 5 x 1/4 kg or 1-1/4kg.

For Imperial, if you need 5 Adult Portions of Salt, multiply 5 x 1 pound = 5 pounds Salt to store for 6 months. If you want to figure this amount for 1 year, multiply the total by 2 which would be 10 pounds. For only 3 months, divide the suggested amount to select for each category in half. For Salt it would equal 2.5 pounds.

Whatever length of time you wish to store, scroll down to Column "B", Line 528 and plug in the number of weeks. This will automatically convert the formulas to your desired planning time.

METHOD 2

You can use the suggested amounts of Adults Shares found in Column L used to calculate the Target Amount in column C.

To use either method, scroll down to B515 and fill in the number of family members for each lines 515 - 520. The number of Adult Shares needed will automatically be figured for the suggested Target Amount in Column C. As you add to your stored supplies, fill in the amounts in Column D, Quantity On Hand. The worksheet will automatically fill in the amounts still needed in Column E, Amount Needed. If you want to keep track of how much you're spending, drop in the cost per item in Column F, Unit Cost. The worksheet will automatically extend the cost in Column G. This provides good incentive to rotate foods before they expire!

SHELF LIFE

For most products, Column H will list the recommended Minimum Shelf Life. Many food products mark the expiration date right on the package. For those that don't, you can keep track on this sheet when you purchase items by using Columns I, J or K. For products not marked with an expiration date, be sure to write on the product with a permanent marker the date of purchase.

The last column, L, is where you can change the suggested weekly amount for an Adult Share. For example, if your family wants to store more green beans, change the Adult Share in L87 to the quantity desired.

This worksheet's food group information is based on the USDA (United States Dept. of Agriculture) recommended amounts. However any quantity can be adjusted up or down to fit personal needs, budget or taste. These are suggestions only.

ADDING ITEMS

Adding extra items to the Deyo Food Planner is very easy in Excel, but for your convenience, each category already has two lines provided where you can insert products.

Suggested quantities are padded a bit to plan for unexpected circumstances. If the budget allows, it is always better to have too much than not enough! Additionally, extra stored items can be used for barter. Rotating these foods into your normal diet means nothing ever goes to waste.

SPECIALTY ITEMS

A few items like mouse and rat traps are not based on the Adult Share formula but on a per week use. Change these amounts to suit. For gender-dependent items like sanitary napkins, etc., you will need to fill in the amounts since this worksheet does not differentiate between male and female except in food requirements.

Deyo Food Planner doesn't cover all items needed except food and water. For additional items to stock, please check both the General Supplies List and First Aid List. These goods, too, may be added to this worksheet to keep track of stocks.

SHELF LIFE

Shelf life can be greatly increased by vacuum or nitrogen packing or other methods of hermetically sealing foods. Storing goodss away from light, at constant low temperatures, in low humidity and leaving packaging unopened from time of purchase to usage, also extends shelf life. Storing foods at a constant 68oF (20oC), or lower, will greatly lengthen shelf life. Many foods can be safely consumed months after their expiration date as long as the container is intact and cans are not rusting or bulging. However, using foods by their expiration date will insure best nutritional quality and taste. Be sure to read the Extending Shelf Life article from Al Durtschi of Walton Feed. He provides excellent information how to get more $$ and "life expectancy" from your food.

When I come back from the grocery store, these items stay in the grocery sacks, until their expiration dates are logged. That way it gets done. To put them in the cupboard or frig only to haul them out again is no incentive to do it. However, seeing a mess in "that corner" is! Besides it only takes a couple minutes and the $$ saved by not letting foods expire makes it worthwhile.

PRINTING THESE SHEETS

When you print out a hard copy, make sure to do so in the Landscape setting. If you want to save your color ink, before printing select the black ink option or save this page as a text file. However, color does make the sheet easier to read.

--------------------------------------------------------------------------------

This information may be used by you freely for noncommercial use only with
my name and email address attached.

hollydeyo@standeyo.com
http://standeyo.com
Contents © 1996-2006 Holly Deyo. All rights reserved


Top
Offline Profile  
 
 Post subject: Re: Food Storage Calculators-How much do you need to store away?
PostPosted: Fri May 14, 2010 3:51 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
BASIC FOOD STORAGE-How Much?

Image CFD PUBLICATIONS

BASIC FOOD STORAGE
http://www.simplyprepared.com/basic_food_storage.htm

Basic storage is the foundation of any good food storage program. It is composed of life-sustaining foods that store well for long periods. A year's supply of garden seeds for planting should be stored so that the diet may be supplemented with fresh vegetables. Where garden space is limited, a multiple vitamin pill should also be stored for daily use by each person during long periods of emergency. Vitamins deteriorate over time and must be replaced by the expiration date on the container.

The following recommendations are estimated for an average adult. The amounts in the left-hand column1 supply about 2300 calories per day for 1 year. The amounts in the right-hand column2 supply about 2400 calories per day for 1 year. Amounts for children are a percentage of the adult portion and can be estimated as follows: age 3 and under - 50%; ages 4 to 6 - 70%; ages 7 to 10 - 90%; ages 11 and up - 100%.3 Families with young children should consider using the amounts in the left-hand column because of the milk recommendations. Sixteen pounds of milk supplies only 1 cup of milk per day and is not enough for growing children or pregnant/nursing mothers.

Go here for PDF File of Recommended Amounts: http://www.simplyprepared.com/basic_food_storage.htm


Top
Offline Profile  
 
 Post subject: Re: Food Storage Calculators-How much do you need to store a
PostPosted: Fri May 14, 2010 4:31 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
A MONTH'S SUPPLY

Image CFD PUBLICATIONS

A MONTH'S SUPPLY
http://www.simplyprepared.com/a_month%27s_supply.htm

-snip-

Based on suggested amounts in "Essentials of Home Production and Storage", a month's supply of food for one person would consist of the following:

Grains:
Powdered milk:
Sugar or honey:
Salt:
Fats and oils:
Legumes:

A suggested month's supply of food for one person could consist of the following foods:
        --- See full list and suggested amounts and link, above ---
ESTIMATED COST: less than $25

=======
MORE
=======

One Month Supply of Shelf Stable Grocery Store Purchased Foods
for one person

http://www.simplyprepared.com/one_month ... supply.htm

Based on the MINIMUM (1600 calories) recommendations in the Food Pyramid ---- continued here: http://www.simplyprepared.com/one_month_grocery_store_supply.htm


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calculators
PostPosted: Wed Oct 20, 2010 4:01 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
BARE-MINIMUM LDS Church Food storage requirements

LDS Preparedness Manual
http://www.green-trust.org/freebooks/Preparedness.pdf

Page 22

BARE-MINIMUM LDS Church Food storage requirements for 1 adult male for 1 year Appx. 2,300 calories per day. (only 695lbs total)

This will keep you fed, but leave you hungry. TOTAL FOOD PER DAY = 24.65 Ounces

Grains (400lbs)
Unless your family already eats 100% whole wheat homemade bread, white flour should be used in the transition process to whole wheat. Adding rye flour (10%) helps make wheat bread a more complete protein. Dent corn is used to make tortillas.

Beans & Legumes (90lbs) {minimum reduced to only 60lbs in 2002}
Black beans cook quickly, make a good salad complement with a vinaigrette dressing over them. Soybeans can be used to make soy milk and tofu, a protein food you should be prepared to make. Familiarize yourself with sprouting techniques. Learn how to make wheat grass juice - the best vitamin supplement you can use.

Milk-Dair products (75lbs) {minimum reduced to only 16lbs in 2002}
Milk powder can be used to make cottage cheese, cream cheese and hard cheeses. Ideally your milk should be fortified with Vitamins A & D. When reconstituting aerate to improve flavor (special mixing pitchers can accomplish this). Whole eggs are the best all-purpose egg product. Powdered sour cream has a limited shelf life unless frozen.

Meats / Meat substitute (20lbs) {minimum reduced to only 0lbs in 2002}
Use meat in soups, stews and beans for flavor. Freeze dried is the best option for real meat. Textured Vegetable protein is the main alternative to freeze dried meats.

Fats / Oils (20lbs)
This group can boost the calories one is getting from food storage products, and supply essential fatty acids.

Sugars (60lbs)
Store your honey in 5 gallon pails. Candy and other sweets can help with appetite fatigue.

Fruits / Vegetables (90lbs) {minimum reduced to only zero lbs in 2002}
Some fruits and vegetables are best dehydrated, others freeze dried (strawberries & blueberries). Fruits are a nice addition to hot cereal, muffins, pancakes and breads.

Auxiliary foods (weight varies)
Vanilla extract improves the flavor of powdered milk. The production of tofu requires a precipitator such as nigari, epsom salt, calcium chloride or calcium sulfide (good calcium source). Learn how to make and use wheat gluten (liquid smoke adds good flavor). Chocolate syrup and powdered drink mixes help with appetite fatigue. Vitamins and protein powders will boost the nutrition levels of foods that may have suffered losses during processing.

Note:
For an average adult Female - multiply the weight by 0.75
For children ages 1-3 multiply by 0.3, 4-6 multiply by 0.5, 7-9 multiply by 0.75
For adults engaged in manual labor multiply by 1.25-1.50

Do you REALLY have a year’s supply?

Just how big is a Year’s Supply of food? As explained on the previous page, our Church is suggesting the following minimums for each adult:

400 lbs. Grains (17.5oz / day)
60 lbs. Beans (2.6oz / day)
10 quarts Cooking oil (0.87oz / day)
60 lbs. Honey (2.63oz / day)
8 lbs. Salt (0.35oz / day)
16 lbs Powdered milk (0.70oz / day)
14 gallons of drinking water (for 2 weeks)

So, just how much is this?

If you store all your grains in #10 cans...

Wheat, Rice, Corn, etc..
You would need 64 cans or 10.5 cases per person.

Pasta
You would need 32 cans or 5.25 cases per person.

Rolled oats
These are lighter but bulkier, so they require more storage containers and space.
You would need 124 cans or 21 cases person.

Beans
A 25 lb bag of beans will about fit in a single 5 gallon bucket, with a little space over, so 2 buckets would hold a one person supply, or 12 -13 # 10 cans or about 2 cases. Two 5 gallon buckets will hold about 75lbs of wheat, rice or other grains. This means you need 11 buckets of grain for each person in your family.

Daily Food
Dividing 400lbs by 365days, equals out to 1.09589lbs, or just over 1 lb of grain, per person, per day. That is approximately 2 cups of unground grain to cover your breakfast lunch and dinner.

Dividing 60lbs by 365, this works out to 0.16 lbs of beans per day, or 2.6 oz—approximately 3/4 cup.

The other foods listed would also need to be used in limited amounts.

This is not much food, folks. Get the basics, then immediately begin to add more kinds of grain, soup mix, canned and/or dehydrated vegetables and fruit, etc to add variety and provide more than the minimal survival diet.

As an example, the minimum recommended amount of grain, when ground and prepared will yield about 6 small biscuits or a plateful of pancakes. Its enough to keep you alive, but a far cry from being satisfied and not hungry.


Top
Offline Profile  
 
 Post subject: How to Calculate Food Storage
PostPosted: Wed Mar 30, 2011 5:36 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
How to Calculate Food Storage

Image

How to Calculate Food Storage
http://www.ehow.com/how_7495215_calcula ... orage.html

Ranging from job loss to natural disasters, emergency situations strike without warning and may leave your family short on food and water. Calculating your food and water requirements before hand ensures you and your family have the basic items you need to stay healthy. It only takes a few minutes to calculate how much food you need to save up, but those few minutes make all the difference if a crisis strikes.

Instructions

    1. Write down the number of . . . .
    2. Multiply the total number of people by the number of . . . .
    3. Multiply the number of people by the total number of . . . .
    4. Add 28 gallons of . . . .
    5, Try different online . . . . ---- copyrighted, continued at link, above ---


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Sun Apr 22, 2012 7:54 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
One Year Food and Water Supply Guide

GREAT Resource to help you figure out amounts!

Image Hat Tip to "Recon" over at American Preppers Network, for finding this. It's a PDF document for download.

One Year Food and Water Supply Guide
http://www.restoring-america.com/Documents/One%20Year%20Supply%20Guide.pdf


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Sat May 19, 2012 3:34 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
How much food do you need?-Putting the Foods You Love Into Food Storage

Image


Putting the Foods You Love Into Food Storage
http://everythingunderthesunblog.blogspot.com/2008/11/book-2.html

What’s for dinner? An age old question. But in times of crisis, that question becomes even more significant. Experience has shown that when disasters hit, having a supply of food and water can be life saving. But it doesn’t take a natural disaster to need food storage. Personal economic disasters happen every day and the choice to pay the mortgage or buy food becomes a reality. It is essential for every family to have food storage in order to survive whatever crisis may be ahead.

There are many questions and concerns about food storage. What should you buy? What will it cost? Where do you store it? How do you cook it? What about rotation? The following information answers all of these questions and more. It will give you the knowledge you need to put the foods you love into your food storage.

THE SYSTEM

This system is based on a worst case scenario, meaning there would be no running water or electricity. This scenario also assumes that families will be on their own and will not be banding together at churches or schools. There are many circumstances that would require isolation from other people, not banding together. Don’t put your family at risk by assuming that you will be eating someone else’s food.

Organization: How much food do you need? This system answers that question down to the last teaspoon of salt. Take 14 --- CONTINUED at LINK, above ---


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Mon Aug 19, 2013 3:53 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
Inventory PDF File

Image

Food Storage Inventory
http://www.eatwhatyoustore.com/wp-content/uploads/2013/02/Food-Storage-Inventory.pdf

Set a goal. Multiply the number of people in your household to find the number of pounds you will need for a 12 month supply. For a 3 month supply, simply divide the total pounds by 4.

The recommended amounts are the absolute minimum amounts of food needed for one adult for one year. If you only store
this much, you will be eating very small meals. Think about storing more. Remember that children grow up to be adults. Consider storing an adult supply for them.

On each page you will find a column for can size and weight. Put either the exact weight in this column, or an approximate weight. It is easy to count the number of cans or buckets and multiply to find out how many pounds you currently have. --- CONTINUED at LINK, above ---


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Mon Mar 03, 2014 6:06 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
Food Storage Calculator

Image

Food Storage Calculator
http://www.family-survival-planning.com/food-storage-calculator.html

This form should give you an idea of the volume of food you may need. You will need to use your own judgment when making decisions as to how much food to buy. Fifty pounds of oats can work wonders in the right hands, but if your limited to making oatmeal it will seem silly to buy so much. As many experts say: Buy and store the kind of food that you will eat.

Use the following calculator to figure the minimum food storage amounts for your family for a year. These are only recommendations. You will need to determine the needs of your own family.
Enter number of family members here: --- CONTINUED at LINK, above ---


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Fri May 06, 2016 9:03 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
Food Storage Calculator

Image

Go Here: http://www.areyouprepared.com/Food-Storage-Calculator-s/109.htm

The following calculator will help you figure the minimum food storage amounts needed for your family. These amounts are recommendations, and are basic year supply minimums only. You will need to choose the best options and foods you should store for your family.


Top
Offline Profile  
 
 Post subject: Re: How much do you need to store? Suggested Amts. & Calcula
PostPosted: Wed May 17, 2017 3:54 pm 
Site Admin

Joined: Tue Nov 21, 2006 2:42 pm
Posts: 2445
Food Storage- For One Year

Image

An Approach to Longer-Term Food Storage
http://ndfs.byu.edu/Portals/9/docs/rese ... 160623-283

Revised September 2015

This is a sample approach to storing food that provides adequate calories (2000-2400) and protein for an adult for one year. However, there are many possible scenarios. The kinds and amounts of food stored should be adjusted based on personal needs and preferences, and by experimenting with recipes. --- CONTINUED at LINK, above ---


Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Theme created StylerBB.net