nutval-v3.0
DESCRIPTION
nutritionTRANSCRIPT
Developed for WFP and UNHCR by the UCL Centre for International Health and Development
Help and Information
For support please email: or visit:
© 2006-2012
NutVal 3.0
A spreadsheet application for planning, calculating, and monitoring the Nutritional Value of food aid
The NutVal Database and Calculator can help you to select commodities and products and calculate the nutrient content of food aid rations. The On-Site Distribution and Monitoring sheet can help in collecting and analysing distribution monitoring data (also called food basket monitoring). NutVal 3.0 is not designed for calculating diets for the treatment of malnutrition but therapeutic and supplementary feeding products are now included in the database for easy reference. To use NutVal you must enable macros when you start the application. Click one of the buttons below to start or read the help pages for more information.
What's new in NutVal 3.0?
How to get a good view of the worksheets
How to enable macros
Planning and calculating a general ration Where do the nutrient reference values come from?Where does the nutrient data come from?
How to use the On-Site Distribution Monitoring spreadsheet
How to track nutrient content over time
Acknowledgements
[email protected] www.nutval.net
Food and Nutrient Database
On-Site Distribution Monitoring
Funding for the development of NutVal has been provided by WFP, UNHCR, the Global Nutrition Cluster, and UCL Futures.
NutVal v3.0
We would like to acknowledge the contributions of the many people who have provided comments and feedback and have helped us in improving this current version of NutVal.
Home
A bug that resulted in an error during the saving of calculation worksheet data has been fixed.
The nutrient content of barley has been adjusted to bring it in to line with the latest USDA nutrient composition data.
What's new in NutVal 3.0
Name change! From this release onwards it has been decided not to include the year of release as part of the NutVal name. This is to avoid confusion over version numbers and to make the naming approach more consistent with other, similar, software. We hope this change in how we name NutVal will also encourage all users to update whenever a new version is released, thereby ensuring they are using the most recent version for their planning and monitoring work.
Thirty-five new items have been added to the NutVal 3.0 database. These include a number of new WFP specifications for fortified blended foods. Entries for several pre-existing products have been updated using the latest data sheets from the manufacturers. Previous entries for WFP and US CSB and WSB have been deleted, along with some redundant or little used items (Amla and Snail). Following user requests, Mung beans and Pigeon peas have been added and the entry for Cowpeas re-named to make it easier to find.
Nutrition products for therapeutic feeding have also been added, along with the specification for ready to use therapeutic foods (RUTF) provided in the UN joint statement on Community Based Management of Acute Malnutrition (2007). These products are listed in the database under a new food group called 'Therapeutic'.
Other special nutrition products including products for targeted supplementary feeding, WFP Micronutrient Powder (MNP) specifications, and Lipid Nutrient Supplements (LNS) have also been added. These can be found under the 'Miscellaneous' food group.
The focus of NutVal remains the planning and monitoring of general food rations. The addition of these new special nutritional products is primarily to allow users to access composition data in a convenient format.
Two new population groups and requirements have been added. These are: the WFP nutrient requirements for primary school feeding programmes, and the WFP nutrient requirements for general feeding requirements for adults with HIV. (Additional age groups will be added in future updates.)
The general food ration energy adjustment spinner now increments in 5 kcal steps to make changing the energy target faster.
Several additional improvements have been made and the help pages have been updated to reflect the main changes.
What's new in NutVal 2006 v2.2
Some users may have experienced problems in running version 2.1 for the first time on computers with certain installations of Excel. This bug has been fixed in version 2.2. No other functionality has been changed.
What's new in NutVal 2006 v2.1
What's new in NutVal 2006 v2.0
Food commodity price data was included in earlier versions of NutVal. However, due to the recent sharp increases in food prices and continuing market volatility it is no longer possible to provide a meaningful FOB guide price for planning purposes. To prevent confusion this data has now been removed in v2. Users are advised to obtain up to date food commodity, and transport and handling prices for planning and monitoring programmes.
An bug which resulted in the kcal requirement for lactation being given as 300 kcal too high by the calculator has been fixed
Minor text changes including links to the new NutVal web site (www.nutval.net) and email address for technical support ([email protected]) have been added to the front menu page
What's new in NutVal 2006
The following items have been added to the Commodity database: Soy flour; HEPS; Split Peas; WFP specifications for Fortified Maize Meal, Corn Soy Blend, and Wheat Soy Blend; Tomato paste; Dried Tomatoes; Pea-Wheat blend; Red, Green and Yellow Sweet Peppers.
The following items have been deleted from the Commodity database: Rison; Lichis bastard; Shallots; Milk Bars; Milk Tablets; Condensed Milk
Composition data has been updated for: Peas; Tomatoes; Lentils; Soybean Meal
Some commodities have been renamed to make it easier to locate them in the database. e.g. Vegetable Oil is now called Oil, Vegetable.
The Food Basket Monitoring (OSDM) data entry sheet has been modified to make data entry easier and give a more streamlined look.
A View Full Screen button has been added on the menu page. The help screens have been redesigned and updated. From all the main help screens you can now click on the green go-back arrow to get back to where you came from.
Previous versions of NutVal has been improved by including modifications, fixes and additional features that have been suggested by users. Please help us to continue this process by sending suggestions or corrections to Thanks!
Home
[email protected]@nutval.net
NutVal is best viewed on a screen with 1024 x 768 resolution. If you are using a screen with a different resolution you may not be able to see all of the contents on the screen. If this is the case you can try adjusting the zoom from 100% to 75% to get a better view. You can also use the Full Screen View button on the menu page to improve your view of the screen. To close the full screen view just press the button again.
Home
NutVal - How to enable macros
To allow NutVal to operate correctly macros must be allowed to work. However, Excel has security protection which can prevent macros from working. It has this security protection because macros may contain computer viruses. To allow macros to work in Excel you may need to do the following: (1) Search help in your version of Excel and find out how to set the macro security level to medium. (2) Set the security level to medium, close NutVal and re-open it, and then click the button that allows macros to work.
Home
There are currently 174 entries included in the NutVal Database.
Calculation of their nutritional value is based on the nutrient values for food given in:
(F) 'Food and Nutrition Needs in Emergencies' UNHCR, UNICEF, WFP, WHO (2002)(G) 'Food and Nutrition Handbook' WFP (2002)
NutVal - Data Sources for Foods and Nutrients
(A) Annex No.3: 'Nutrient Composition of Selected Foods', FAO Food and Nutrition Paper 23: 'Management of Group Feeding Programmes', Rome 1982
(B) For US food aid items, most data comes from the USAID Commodities Reference Guide (http://www.usaid.gov/our_work/humanitarian_assistance/ffp/crg/)
(C) 'The Composition of Foods' McCance and Widdowson, Fifth Edition, 1991, The Royal Society of Chemistry and Ministry of Agriculture, Fisheries and Foods, UK
(D) 'USDA National Nutrient Database for Standard Reference, Releases 15 -18' U.S. Department of Agriculture, Agricultural Research Service. Nutrient Data Laboratory Home Page, (http://www.ars.usda.gov/main/site_main.htm?modecode=12354500)
(E) Data from WFP Operations Department Directives are used for energy and macronutrient values for core WFP commodities.
(H) Specifications are provided by WFP for a range of commodities and products. These are indicated by [WFP SPECS.] in the text and the entries are shown in blue in the Database
(I) For branded products the nutrient content is taken from the manufacturer's data sheets. Where this contains a range the mid-point of the range is given. These entries are coloured purple in the Database.
As far as possible, the database entries are consistent with all data sources although for some commodities a consensus nutrient value was included.
The iodine concentration for fortified salt is given as the mid-point of the WFP specification range, 60 mg of iodine per kg of salt. While this is above the WHO recommended range of 20 - 40 ppm, WFP considers that typical salt rations are only 5 g/p/d compared to the 10g/p/d used in drawing up the WHO recommendations. A higher specification is therefore required.
Where vitamin A was converted between international units (IU) and ug retinol equivalents (ug RE) a multiplication or division by 3.33 was used. To convert beta-carotene to ug RE the beta-carotene value was divided by 6.
For commodities where different nutrient values were found in different reference sources the mid-point value was chosen. For example, the iodine value for 'canned fish' was the average value for canned tuna and canned sardines.
Please note that Maize and Maize Meal is listed under the European name 'Maize' rather then the American term 'Corn'.
It is important to note that the values are for raw portions of food. The actual amount of nutrient consumed will depend on food preparation and cooking practices which are highly variable.
Where nutrient values are unknown or trace a blank is left in the database, but a value of zero is used by NutVal in calculations.
Food and Nutrient Database
Home
There are currently 174 entries included in the NutVal Database.
Calculation of their nutritional value is based on the nutrient values for food given in:
(F) 'Food and Nutrition Needs in Emergencies' UNHCR, UNICEF, WFP, WHO (2002)(G) 'Food and Nutrition Handbook' WFP (2002)
NutVal - Data Sources for Foods and Nutrients
(A) Annex No.3: 'Nutrient Composition of Selected Foods', FAO Food and Nutrition Paper 23: 'Management of Group Feeding Programmes', Rome 1982
(B) For US food aid items, most data comes from the USAID Commodities Reference Guide (http://www.usaid.gov/our_work/humanitarian_assistance/ffp/crg/)
(C) 'The Composition of Foods' McCance and Widdowson, Fifth Edition, 1991, The Royal Society of Chemistry and Ministry of Agriculture, Fisheries and Foods, UK
(D) 'USDA National Nutrient Database for Standard Reference, Releases 15 -18' U.S. Department of Agriculture, Agricultural Research Service. Nutrient Data Laboratory Home Page, (http://www.ars.usda.gov/main/site_main.htm?modecode=12354500)
(E) Data from WFP Operations Department Directives are used for energy and macronutrient values for core WFP commodities.
(H) Specifications are provided by WFP for a range of commodities and products. These are indicated by [WFP SPECS.] in the text and the entries are shown in blue in the Database
(I) For branded products the nutrient content is taken from the manufacturer's data sheets. Where this contains a range the mid-point of the range is given. These entries are coloured purple in the Database.
As far as possible, the database entries are consistent with all data sources although for some commodities a consensus nutrient value was included.
The iodine concentration for fortified salt is given as the mid-point of the WFP specification range, 60 mg of iodine per kg of salt. While this is above the WHO recommended range of 20 - 40 ppm, WFP considers that typical salt rations are only 5 g/p/d compared to the 10g/p/d used in drawing up the WHO recomendations. A higher specification is therefore required.
Where vitamin A was converted between international units (IU) and ug retinol equivalents (ug RE) a multiplication or division by 3.33 was used. To convert beta-carotene to ug RE the beta-carotene value was divided by 6.
For commodities where different nutrient values were found in different reference sources the mid-point value was chosen. For example, the iodine value for 'canned fish' was the average value for canned tuna and canned sardines.
Please note that Maize and Maize Meal is listed under the European name 'Maize' rather then the American term 'Corn'.
It is important to note that the values are for raw portions of food. The actual amount of nutrient consumed will depend on food preparation and cooking practices which are highly variable.
Where nutrient values are unknown or trace a blank is left in the database, but a value of zero is used by NutVal in calculations.
Home
Food and Nutrient Database
NutVal - References and Standards for Nutrient Content
The population requirement for energy is taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000).
The recommended planning figure of 2,100 kcals for food aid dependent populations is used as the default. It may be appropriate to adjust this figure based on factors such as the ambient temperature, activity level, demographic composition of the beneficiary population, and degree of self-sufficiency. If you are sure it is justified to alter the planning figure this can be done by selecting Whole Population from the dropdown menu and then clicking on the up or down arrows to the right of the list. When the energy level is changed the safe level of intake for individual nutrients is adjusted proportionately.
The population requirements for protein and fat are taken from 'Food and Nutrition Needs in Emergencies' (UNHCR/UNICEF/WFP/WHO, 2002). These figures are based on the need to supply 10-12 % of the energy as protein and at least 17 % as fat.
The safe levels of intake for micronutrients are taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000). The figures given above are also consistent with key indicators from The Sphere Project 'The Humanitarian Charter and Minimum Standards in Disaster Response' (2004). Niacin requirements are calculated based on the need for 6.6 mg per 1000 kcal.
The percentage of requirement figures in the calculation and planning sheet represent the proportion of the population requirement or safe levels of intake that would be supplied by the selected ration.
The energy content of the ration is shown in red if it falls below 100% and blue if it exceeds 115% of the selected requirement.
The protein and fat content of the ration are shown as the % of requirements in grams, and also as the % of the ration energy content. Protein should contribute between 10-12% of the energy content, with an upper limit of 15%. If the proportion of energy supplied by protein is below 10% or exceeds 15.0%, the percentage is shown in red.
For the whole population at least 17% of energy should be supplied as fat. For young children the minimum is 30%, and for pregnant or lactating women the minimum is 20% from fat. The acceptable ranges are indicated by green percentages and excessive amounts are shown in blue.
If the value for any of the listed micronutrients is less than 100% of the requirement the percentage is shown in red. If the value for any of the listed nutrients is between 100% of the safe level of intake and the upper safe level of intake the percentage is shown in green. If the upper safe level of intake is exceeded the percentage is shown in red.
Where there is no upper intake limit for micronutrients but the amount exceeds 4 times the safe level of intake the nutrient is shown in blue.
Food and Nutrient Database
Calculation sheet
Home
NutVal - References Used in Evaluating Ration Adequacy
The population requirement for energy is taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000).
The recommended planning figure of 2,100 kcals for food aid dependent populations is used as the default. It may be appropriate to adjust this figure based on factors such as the ambient temperature, activity level, demographic composition of the beneficiary population, and degree of self-sufficiency. If you are sure it is justified to alter the planning figure this can be done by selecting Whole Population from the dropdown menu and then clicking on the up or down arrows to the right of the list. When the energy level is changed the safe level of intake for individual nutrients is adjusted proportionately.
The population requirements for protein and fat are taken from 'Food and Nutrition Needs in Emergencies' (UNHCR/UNICEF/WFP/WHO, 2002). These figures are based on the need to supply 10-12 % of the energy as protein and at least 17 % as fat.
The safe levels of intake for micronutrients are taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000). The figures given above are also consistent with key indicators from The Sphere Project 'The Humanitarian Charter and Minimum Standards in Disaster Response' (2004). Niacin requirements are calculated based on the need for 6.6 mg per 1000 kcal.
The percentage of requirement figures shown on the bar chart represent the proportion of the population requirement or safe levels of intake that would be supplied by the selected ration.
Nutrient Bar Chart
Menu
NutVal - Reference and Data Sources
The population requirement for energy is taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000).
The recommended planning figure of 2100 kcals for food aid dependent populations is used. It should be noted that it may be appropriate to adjust this figure based on factors such as the ambient temperature, activity level, demographic composition of the beneficiary population, and degree of self-sufficiency. If you are sure it is justified to alter the planning figure this can be done by selecting Whole Population from the dropdown menu and then clicking on the up or down arrows to the right of the list. When the energy level is changed the safe level of intake for individual nutrients is adjusted proportionately.
The population requirements for protein and fat are taken from 'Food and Nutrition Needs in Emergencies' (UNHCR/UNICEF/WFP/WHO, 2002). These figures are based on the need to supply 10-12 % of the energy as protein and at least 17 % as fat.
The safe levels of intake for micronutrients are taken from the 'Management of Nutrition in Major Emergencies' (WHO, 2000). The figures given above are also consistent with key indicators from The Sphere Project 'The Humanitarian Charter and Minimum Stan
The percentage of requirement figures in the calculation and planning sheet represent the proportion of the population requirement or safe levels of intake that would be supplied by the selected ration.
Pie Chart
Home
(5) To see a graph of the nutrients included in the selected ration click on the button below the calculation sheet.
NutVal - How to calculate and plan the nutrient content of a general food ration
The underlying concepts of the NutVal calculation sheet are that: (a) a general food ration should deliver a balanced set of nutrients that meet accepted international standards for population requirements, and (b); that the nutrient content of the ration is determined by the energy content. Therefore, if a ration delivers 100% of the energy requirement it should also provide 100% of each of the micro and macronutrients. However, if for example the ration is designed to only provide 50% of the energy requirement it only needs to provide 50% of the micro and macronutrients.
It was not possible to include data on all the nutrients that are important for human nutrition. However, if a balanced ration is achieved for the nutrients that are included in the NutVal database there can be reasonable confidence that adequate nutrition for the prevention of acute disease and excess mortality has been achieved.
(1) Select the commodities to be included in the ration from the commodities list. You can scroll through an alphabetical list of food aid commodities and products by placing the cursor in the item entry cell and using the drop down list. Up to 10 items can be selected from the database for inclusion.
(2) If you want to find the best food aid commodities to include you can search the NutVal database. Click the Food and Nutrient Database button in the top right corner of the Calculator sheet to go there directly. You can view foods by type and sort the list to find foods with the highest nutrient densities. If you want to include commodities that are not in the database you can type these in on the on the last 2 lines of the calculation list. However, you have to calculate and type in the nutrient contents if you use this option.
(3) Complete the ration calculation by entering the amount of each food in the planned or actual daily ration (grams per person per day). You can do this by typing in the number of grams or by using the up and down arrows next to the commodity name.
(4) The nutrients contained in the single food items and in the overall daily ration will be displayed. If the value for any of the listed nutrients is less than 100% of the minimum recommended level the percentage is highlighted in red. To see the effect of altering the quantities of commodities on the nutrient content of the ration use the up and down arrows to adjust the number of grams of food in the daily ration. Keep adjusting the amounts until the desired ration composition is achieved.
(6) To see examples of commonly used rations click one of the buttons at the bottom of the screen. As you will see, many such rations are deficient in various nutrients and should not be considered as acceptable.
Home
Calculation sheet
Food and Nutrient Database
NutVal - How to calculate and plan the nutrient content of a general food ration
The underlying concepts of the NutVal calculation sheet are that: (a) a general food ration should deliver a balanced set of nutrients that meet accepted international standards for population requirements, and (b); that the nutrient content of the ration is determined by the energy content. Therefore, if a ration delivers 100% of the energy requirement it should also provide 100% of each of the micro and macronutrients. However, if for example the ration is designed to only provide 50% of the energy requirement it only needs to provide 50% of the micro and macronutrients.
It was not possible to include data on all the nutrients that are important for human nutrition. However, if a balanced ration is achieved for the nutrients that are included in the NutVal database there can be reasonable confidence that adequate nutrition for the prevention of acute disease and excess mortality has been achieved.
(1) Select the commodities to be included in the ration from the commodities list. You can scroll through an alphabetical list of food aid commodities and products by placing the cursor in the item entry cell and using the drop down list. Up to 10 items can be selected from the database for inclusion.
(2) If you want to find the best food aid commodities to include you can search the NutVal database. Click the Food and Nutrient Database button in the top right corner of the Calculator sheet to go there directly. You can view foods by type and sort the list to find foods with the highest nutrient densities. If you want to include commodities that are not in the database you can type these in on the on the last 2 lines of the calculation list. However, you have to calculate and type in the nutrient contents if you use this option.
(3) Complete the ration calculation by entering the amount of each food in the planned or actual daily ration (grams per person per day). You can do this by typing in the number of grams or by using the up and down arrows next to the commodity name.
(4) The nutrients contained in the single food items and in the overall daily ration will be displayed. If the value for any of the listed nutrients is less than 100% of the minimum recommended level the percentage is highlighted in red. To see the effect of altering the quantities of commodities on the nutrient content of the ration use the up and down arrows to adjust the number of grams of food in the daily ration. Keep adjusting the amounts until the desired ration composition is achieved.
(5) To see a graph of the nutrients included in the selected ration click on the button below the calculation sheet.
(6) To see examples of commonly used rations click one of the buttons at the bottom of the screen. As you will see, many such rations are deficient in various nutrients and should not be considered as acceptable.
Home
Calculation sheet
Food and Nutrient Database
NutVal - Using the Food Basket (On-site Distribution) Monitoring spreadsheet
The spreadsheet is designed to help with collection and analysis of data from On-site Distribution Monitoring activities that may be carried out in emergency feeding programmes. The data that is collected for this activity includes the weight of food that the beneficiaries collect during a food distribution, as well as their gender and family size. The addresses of the beneficiaries are also sometimes collected. This data should be collected from a systematic (interval) sample of people leaving the distribution site. A sampling interval should be calculated before beginning based on the expected number of beneficiaries and the required sample size.
Collection of this type of data is one of the reporting requirements for UNHCR food aid operations and constitutes one aspect of best practice in the management of food aid programmes. Further details may be found in 'Commodity Distribution' UNHCR, Division of Operational Support, June 1997.
The data collected during On-site Distribution Monitoring can then be entered into the NutVal spreadsheet which calculates the results automatically. Both the data entry sheet and the results page can be easily exported to new files to enable effective record keeping.
On-Site Food Distribution Monitoring
Home
NutVal - Using the Food Basket (On-site Distribution) Monitoring spreadsheet
The spreadsheet is designed to help with collection and analysis of data from On-site Distribution Monitoring activities that may be carried out in emergency feeding programmes. The data that is collected for this activity includes the weight of food that the beneficiaries collect during a food distribution, as well as their gender and family size. The addresses of the beneficiaries are also sometimes collected. This data should be collected from a systematic (interval) sample of people leaving the distribution site. A sampling interval should be calculated before beginning based on the expected number of beneficiaries and the required sample size.
Collection of this type of data is one of the reporting requirements for UNHCR food aid operations and constitutes one aspect of best practice in the management of food aid programmes. Further details may be found in 'Commodity Distribution' UNHCR, Division of Operational Support, June 1997.
The data collected during On-site Distribution Monitoring can then be entered into the NutVal spreadsheet which calculates the results automatically. Both the data entry sheet and the results page can be easily exported to new files to enable effective record keeping.
On-site Distribution Monitoring
Home
NutVal - Tracking nutrient content over time
Following the nutrient content of a ration over time is an important part of on-going quality monitoring of the food aid programme. It can also be very useful if nutritional problems occur and you need to analyse the nutrient content of the ration was that was distributed in the past.
NutVal enables you to analyse the content of different rations in the calculation sheet and then save the summary results into a database for further analysis. A copy of the whole calculation sheet can also easily be saved to a new file by clicking the save to new file button.
The same process can be used to save the data entry and results sheets from On-site Distribution Monitoring. This data should tell you what the beneficiaries actually received and should be compared to what was planned.
Summary Nutrient Tracking Sheet
Home
NutVal - Tracking nutrient content over time
Following the nutrient content of a ration over time is an important part of on-going quality monitoring of the food aid programme. It can also be very useful if nutritional problems occur and you need to analyse the nutrient content of the ration was that was distributed in the past.
NutVal enables you to analyse the content of different rations in the calculation sheet and then save the summary results into a database for further analysis. A copy of the whole calculation sheet can also easily be saved to a new file by clicking the save to new file button.
The same process can be used to save the data entry and results sheets from On-site Distribution Monitoring. This data should tell you what the beneficiaries actually received and should be compared to what was planned.
Summary Nutrient Tracking Sheet
Home
RATION CONTENTS DAILY
Click below to select food items RATION ENERGY PROTEIN FAT CALCIUM IRON IODINE VIT. A
or type them in on the bottom two rows g/person/day kcal g g mg mg µg mg mg mg mg
MAIZE GRAIN, WHITE 400 1,400 40.0 16.0 28 10.8 0 0 1.54 0.80 8.8 0
BEANS, DRIED 80 268 16.0 1.0 114 6.6 0 0 0.40 0.18 5.0 0
OIL, VEGETABLE [WFP SPECS.] 25 221 0.0 25.0 0 0.0 0 225 0.00 0.00 0.0 0
CSB SUPERCEREAL (CSB+) [WFP SPECS.] 60 225 9.2 4.8 238 5.6 24 333 0.35 0.43 6.6 61
SALT, IODISED [WFP SPECS.] 5 5 0 0.0 0.0 0 0.0 300 0 0.00 0.00 0.0 0
100
5
Ration total 570 2,115 65.2 46.8 380 23.0 324 558 2.29 1.41 20.4 61
Beneficiaries 2,100 52.5 40.0 450 22 150 500 0.90 1.40 13.9 28
% of requirements supplied by ration ### ### ### ### ### 2.16 ### ### ### ### ###% of energy supplied by protein or fat 68% ### ###
Ration Name or Reference: Ration 1 - Location A Date: 01/03/2012
Carbohydrate ProteinFat
NutVal 3.0 Food Aid Planning and Calculation Sheet
THIAMINE RIBOFLAVIN NIACIN VIT. C
µg RE
Ration Examples:Ration Examples: Maize-BasedMaize-Based Rice-BasedRice-Based Wheat-BasedWheat-Based
View Graph of NutrientsView Graph of Nutrients View Pie Chart of EnergyView Pie Chart of Energy Add Data to Tracking SheetAdd Data to Tracking Sheet View Tracking SheetView Tracking Sheet
Menu
Help
Export Data to Save or Print Export Data to Save or Print
Clear Ration ContentsClear Ration Contents
Nutrients per 100 grams of raw portion
Food Type Food Commodities and Products
OILS AND FATS ANIMAL FAT 900 0.0 100.0 0 0.0
FRUIT APRICOTS, DRIED 270 4.0 0.5 62 4.5
FRUIT AVOCADO PEAR 121 1.4 11.3 19 1.4
FRUIT BANANA 88 1.5 0.1 9 1.4
CEREALS BARLEY, DEHULLED 337 12.5 2.3 33 3.6
PULSES & OILSEEDS BEANS, BLACK (USA) 341 21.6 1.4 123 5.0
PULSES & OILSEEDS BEANS, DRIED 335 20.0 1.2 143 8.2
PULSES & OILSEEDS BEANS, GREAT NORTHERN (USA) 339 21.9 1.1 175 5.5
PULSES & OILSEEDS BEANS, KIDNEY, ALL TYPES (USA) 333 23.6 0.8 143 8.2
PULSES & OILSEEDS BEANS, NAVY / PEA BEANS (USA) 335 22.3 1.3 155 6.4
PULSES & OILSEEDS BEANS, PINK (USA) 343 21.0 1.1 130 6.8
PULSES & OILSEEDS BEANS, PINTO (USA) 340 20.9 1.1 121 5.9
PULSES & OILSEEDS BEANS, SMALL RED (USA) 350 22.0 1.0 150 7.0
PULSES & OILSEEDS BEANS, SOYA 416 36.5 19.9 277 15.7
MEAT BEEF, MODERATELY FAT 237 18.2 17.7 11 3.6
MISCELLANEOUS BP-5™ 458 14.7 17.0 600 10.0
MISCELLANEOUS BREAD, WHITE 261 7.7 2.0 37 1.7
CEREALS BULGUR WHEAT 350 11.0 1.5 29 3.7
CEREALS BULGUR WHEAT, FORTIFIED, (USA) 342 12.3 1.3 110 2.9
OILS AND FATS BUTTER 725 0.0 81.0 12 0.2
FISH CANNED FISH 305 22.0 24.0 330 2.7
FISH CANNED FISH IN WATER 150 20.0 8.0 36 1.0
MEAT CANNED MEAT 220 21.0 15.0 14 4.1
PULSES & OILSEEDS CASHEW NUT 566 18.2 46.9 37 6.7
ROOTS AND TUBERS CASSAVA, FLOUR 342 1.5 0.0 55 2.0
ROOTS AND TUBERS CASSAVA, FRESH 160 1.4 0.3 16 0.3
MILK & PRODUCTS CHEESE, CANNED 355 22.5 28.0 630 0.2
MEAT CHICKEN, CANNED 215 21.0 14.0 14 1.5
PULSES & OILSEEDS CHICKPEAS 364 19.3 6.0 105 6.2
MISCELLANEOUS COCOA 270 17.0 21.0 50 14.0
PULSES & OILSEEDS COCONUT MEAT, RAW 354 3.3 33.5 14 2.4
MISCELLANEOUS COFFEE, GROUND 56 8.0 0.0 30 1.0
BLENDED FOODS CORN SOY MASA FLOUR (USA) 365 9.3 3.8 110 2.9
BLENDED FOODS CORN SOY MASA FLOUR, INSTANT (USA) 363 11.4 3.7 110 2.9
BLENDED FOODS CORN SOY MILK (USA) 375 21.4 6.8 1,020 17.5
BLENDED FOODS CORN SOY MILK, INSTANT (ICSM) 380 20.0 6.0 900 18.0
MEAT CORNED BEEF, CANNED 233 25.5 14.0 56 4.0
PULSES & OILSEEDS COWPEAS, BLACK-EYED 336 23.5 1.3 110 8.3
BLENDED FOODS CSB SUPERCEREAL (CSB+) [WFP SPECS.] 376 15.3 8.0 396 9.4
BLENDED FOODS CSB SUPERCEREAL (CSB+), Algeria [WFP SPECS.] 376 15.3 8.0 396 9.4
BLENDED FOODS CSB SUPERCEREAL (CSB+), Cuba [WFP SPECS.] 376 15.3 8.0 396 9.4
BLENDED FOODS CSB SUPERCEREAL (CSB+), Sri Lanka [WFP SPECS.] 376 15.3 8.0 396 9.4
BLENDED FOODS CSB SUPERCEREAL PLUS (CSB++) [WFP SPECS.] 394 16.3 10.2 496 8.9
BLENDED FOODS CSB SUPERCEREAL WITH SUGAR (CSB+/SUGAR) [WFP SPECS.] 381 15.6 8.2 401 9.2
BLENDED FOODS CSB SUPERCEREAL WITH SUGAR (CSB+/SUGAR), Timor-Leste [WFP SPECS.] 391 15.2 10.0 400 9.2
FRUIT DATES, DRIED 245 2.0 0.5 32 1.2
MILK & PRODUCTS DRIED SKIM MILK (DSM) 348 36.1 0.6 1,280 0.3
MILK & PRODUCTS DRIED SKIM MILK (DSM), FORTIFIED 360 36.0 1.0 1,257 1.0
MILK & PRODUCTS DRIED WHOLE MILK (DWM) 500 25.0 27.0 912 0.5
EGGS EGG, DRIED 594 47.4 41.0 231 6.8
EGGS EGG, HEN, FRESH 149 12.5 10.0 49 1.4
VEGETABLES EGGPLANT (AUBERGINE) 26 1.0 0.2 7 0.3
MILK & PRODUCTS EVAPORATED MILK 151 8.4 9.4 290 0.3
THERAPEUTIC F100 THERAPEUTIC MILK 535 14.7 31.2 450 0.4
THERAPEUTIC F75 THERAPEUTIC MILK 442 5.5 15.2 450 0.3
BLENDED FOODS FAMIX (ETHIOPIA) 402 14.7 7.0 100 8.0
FISH FISH FILLET, COD, FRESH 76 17.4 0.7 16 0.3
Menu NutVal 3.0 Food and Nutrient Database
Help
ENERGY (kcal)PROTEIN (g)FAT (g) CALCIUM (mg)IRON (mg)
Click Here To Display: To Sort List Click: Food Type
ProteinVitamin A
Food Name
Energy
FISH FISH, DRIED, SALTED 270 47.0 7.5 343 2.8
FISH FISH, DRIED, WHOLE, FRESHWATER 309 63.0 6.3 3,000 9
FRUIT FRUIT IN SYRUP, CANNED 60 0.5 0.0 7 0.3
OILS AND FATS GHEE, BUTTER OIL 862 0.0 97.8 0 0.0
MEAT GOAT, MODERATELY FAT 357 15.2 32.4 11 2.0
PULSES & OILSEEDS GROUNDNUTS, DRY 567 25.8 49.2 92 4.6
FRUIT GUAVA 64 1.1 0.4 24 1.3
BLENDED FOODS HEPS (ZAMBIA) 350 15.0 6.0 173 13.7
MISCELLANEOUS HIGH ENERGY BISCUITS [WFP SPECS.] 450 12.0 15.0 250 11.0
VEGETABLES LEAVES, DARK GREEN, e.g. SPINACH 25 2.8 0.8 170 2.1
VEGETABLES LEAVES, LIGHT GREEN, e.g. CABBAGE 26 1.7 0.4 52 0.7
VEGETABLES LEAVES, MEDIUM GREEN, e.g. PUMPKIN 19 3.2 0.4 39 2.2
FRUIT LEMON 59 0.5 1.0 90 0.3
PULSES & OILSEEDS LENTILS 338 28.1 1.0 51 9.0
FRUIT LIMES 30 0.7 0.2 33 0.6
MEAT LIVER 136 20.0 4.0 10 10.0
MISCELLANEOUS LNS - NUTRIBUTTER® 540 12.8 35.4 500 45.0
MISCELLANEOUS LNS - PLUMPY'DOZ® 561 13.0 35.1 879 20.4
CEREALS MAIZE GRAIN, WHITE 350 10.0 4.0 7 2.7
CEREALS MAIZE GRAIN, YELLOW 350 10.0 4.0 13 2.7
CEREALS MAIZE MEAL, FORTIFIED (USA) 366 8.5 1.7 110 2.9
CEREALS MAIZE MEAL, FORTIFIED [WFP SPECS.] 366 8.5 1.7 5 2.6
CEREALS MAIZE MEAL, WHITE, DEGERMED 360 8.5 1.7 5 1.1
CEREALS MAIZE MEAL, WHITE, WHOLE GRAIN 360 9.0 3.5 6 2.4
CEREALS MAIZE MEAL, YELLOW, DEGERMED 360 8.5 1.7 5 1.1
CEREALS MAIZE MEAL, YELLOW, WHOLE GRAIN 360 9.0 3.5 6 2.4
VEGETABLES MAIZE, FRESH 86 3.2 1.2 2 0.5
FRUIT MANGO 65 0.5 0.3 10 0.1
OILS AND FATS MARGARINE, CORN (USA) 719 0.0 80.5 30 0.0
MILK & PRODUCTS MILK, COW, WHOLE 66 3.2 3.9 115 0.1
MILK & PRODUCTS MILK, GOAT, WHOLE 69 3.6 4.1 134 0.05
MILK & PRODUCTS MILK, HUMAN 69 1.3 4.1 34 0.1
CEREALS MILLET, BULRUSH 335 11.0 3.0 22 20.7
MISCELLANEOUS MNP FORMULATION (UN Joint Statement) 0 0.0 0.0 0 1,000.0
MISCELLANEOUS MNP FORMULATION 1 [WFP SPECS.] 0 0.0 0.0 0 1,000.0
MISCELLANEOUS MNP FORMULATION 2 [WFP SPECS.] 0 0.0 0.0 0 1,000.0
MISCELLANEOUS MNP FORMULATION 3 [WFP SPECS.] 0 0.0 0.0 0 250.0
MISCELLANEOUS MNP FORMULATION 4 [WFP SPECS.] 0 0.0 0.0 0 250.0
MISCELLANEOUS MNP FORMULATION 5 [WFP SPECS.] 0 0.0 0.0 0 3,125.0
MISCELLANEOUS MNP FORMULATION 6 [WFP SPECS.] 0 0.0 0.0 0 1,000.0
PULSES & OILSEEDS MUNG BEANS (GREEN GRAM) 347 23.9 1.2 132 6.7
MEAT MUTTON, MODERATELY FAT 249 15.0 21.0 10 2.4
BLENDED FOODS NUTRAMIX SUPERCEREAL (CSB+) [WFP SPECS.] 374 17.2 7.5 411 9.6
CEREALS OATS, ROLLED 370 13.0 5.5 30 3.4
CEREALS OATS, WHOLE 375 17.0 7.0 60 4.6
OILS AND FATS OIL, VEGETABLE [WFP SPECS.] 885 0.0 100.0 0 0.0
OILS AND FATS OIL, VEGETABLE, UNFORTIFIED 890 0.0 100.0 0 0.0
OILS AND FATS OIL, VEGETABLE, Vit A FORTIFIED (USA) 884 0.0 100.0 0 0.0
VEGETABLES ONION 38 1.2 0.2 20 0.2
FRUIT ORANGE, WHOLE 26 0.8 0.1 33 0.1
OILS AND FATS PALM OIL, RED 875 0.0 98.9 6 0.0
FRUIT PAPAYA 32 0.4 0.1 21 0.6
CEREALS PASTA, MACARONI 348 12.0 1.8 25 1.6
FRUIT PAWPAW 32 0.4 0.1 21 0.6
PULSES & OILSEEDS PEAS, DRIED 341 24.6 1.2 55 4.4
PULSES & OILSEEDS PEAS, DRIED, SPLIT 341 24.6 1.2 55 4.4
VEGETABLES PEPPERS, SWEET, GREEN, RAW 20 0.9 0.2 10 0.3
VEGETABLES PEPPERS, SWEET, RED, RAW 26 1.0 0.3 7 0.4
VEGETABLES PEPPERS, SWEET, YELLOW, RAW 27 1.0 0.2 11 0.5
PULSES & OILSEEDS PIGEON PEAS (RED GRAM) 343 21.7 1.5 130 5.2
FRUIT PINEAPPLE 47 0.4 0.1 16 0.4
FRUIT PLANTAIN 135 1.2 0.3 8 1.3
MEAT PORK, CANNED 271 16.0 22.0 8 2.1
MEAT PORK, FATTY 535 10.0 55.0 11 1.8
ROOTS AND TUBERS POTATO, IRISH 77 2.0 0.1 12 0.8
ROOTS AND TUBERS POTATO, SWEET, ORANGE 87 1.2 0.3 24 0.7
MEAT POULTRY 139 19.0 7.0 15 1.5
CEREALS RICE, LIGHTLY MILLED, PARBOILED 364 7.0 0.5 7 1.2
CEREALS RICE, POLISHED 360 7.0 0.5 9 1.7
BLENDED FOODS RSB SUPERCEREAL (RSB+) [WFP SPECS.] 385 15.9 7.5 412 7.9
BLENDED FOODS RSB SUPERCEREAL PLUS (RSB++) [WFP SPECS.] 403 15.9 10.2 504 7.7
BLENDED FOODS RSB SUPERCEREAL WITH SUGAR (RSB+/SUGAR) [WFP SPECS.] 387 15.4 7.3 411 7.9
MISCELLANEOUS RUSF - eeZeeRUSF™ 550 14.0 34.0 545 7.0
MISCELLANEOUS RUSF - PLUMPY'SUP® 544 13.9 33.2 325 11.5
MISCELLANEOUS RUSF - WAWAMUM PAKISTAN [WFP SPECS.] 520 13.0 29.0 840 20.4
THERAPEUTIC RUTF - BP100™ 527 14.5 31.0 470 10.0
THERAPEUTIC RUTF - eeZeePaste NUT™ 550 15.0 34.0 400 10.0
THERAPEUTIC RUTF - PLUMPY'NUT® 535 14.7 31.2 450 12.0
THERAPEUTIC RUTF SPECIFICATIONS (UN Joint Statement, 2007) 535 14.7 31.2 450 12.0
SUGAR AND SALT SALT 0 0.0 0.0 0 0.0
SUGAR AND SALT SALT, IODISED [WFP SPECS.] 0 0.0 0.0 0 0.0
FISH SARDINES, CANNED IN OIL 309 20.0 25.0 400 3.0
BLENDED FOODS SENMIX SUPERCEREAL (CSB+) [WFP SPECS.] 394 13.3 11.3 391 10.1
PULSES & OILSEEDS SESAME SEEDS 573 17.7 49.7 975 14.6
CEREALS SORGHUM 335 11.0 3.0 26 4.5
PULSES & OILSEEDS SOYA BEAN MEAL, DEFATTED 339 45.0 2.4 244 13.7
PULSES & OILSEEDS SOYA BEANS 416 36.5 19.9 277 15.7
CEREALS SOYA FLOUR, FULL FAT, RAW 436 34.5 20.7 206 6.4
BLENDED FOODS SOYA FORTIFIED BULGUR WHEAT (USA) 350 17.0 1.5 110 2.9
BLENDED FOODS SOYA FORTIFIED MAIZE MEAL (USA) 390 13.0 1.5 110 2.9
Nutrients per 100 grams of raw portion
0 0 0.00 0.00 0.0 0
300 0.08 0.09 2.9 5
1 265 0.05 0.15 2.3 18
8 60 0.03 0.03 0.7 9
7 0.65 0.29 8.1 0
5 0.80 0.19 6.2 0
0 0.50 0.22 6.2 0
1 0.70 0.20 6.3 5
2 0.50 0.20 6.6 5
1 0.65 0.23 6.5 3
0 0.80 0.20 6.0 0
2 0.60 0.20 5.6 7
0 0.70 0.20 6.2 0
6 7 0.87 0.87 10.4 6
6 0 0.07 0.15 6.6 0
100 470 0.52 0.80 8.0 40
6 0 0.16 0.06 5.6 0
0 0.28 0.14 4.5 0
662 0.44 0.26 3.5 0
38 714 0.01 0.02 0.2 0
19 0 0.40 0.30 6.5 0
19 33 0.03 0.06 5.4 0
0 0.20 0.23 6.6 0
11 0 0.42 0.06 5.8 1
0 0.04 0.04 0.8 0
8 0.09 0.08 0.9 21
39 120 0.03 0.45 5.4 0
120 0.08 0.16 10.4 0
20 0.48 0.21 4.6 4
0.10 0.30 3.1 0
3 0 0.07 0.02 1.2 3
0 0 0.00 0.01 27.0 0
662 0.44 0.26 3.5 0
662 0.44 0.26 3.5 0
57 785 0.59 0.71 6.4 41
57 510 0.80 0.60 8.0 40
14 0 0.02 0.20 4.5 0
15 0.90 0.20 6.2 2
40 555 0.59 0.71 11.1 101
40 555 0.59 0.71 11.1 101
40 555 0.59 0.71 11.1 101
40 555 0.59 0.71 11.1 101
59 543 0.54 0.79 10.4 101
40 546 0.55 0.71 13.5 101
40 546 0.55 0.70 10.6 101
0 0.09 0.10 3.0 0
0 9 0.38 1.63 9.5 13
0 1,500 0.42 1.55 9.5 0
280 0.28 1.21 6.8 0
270 0.20 1.54 9.9 0
53 191 0.06 0.51 2.6 0
1 25 0.05 0.03 0.7 2
11 105 0.07 0.42 2.2 1
105 1,200 0.50 1.60 5.0 50
105 1,200 0.50 1.60 5.0 50
0.10 0.40 5.0 30
110 2 0.08 0.07 4.9 0
IODINE (µg)VIT. A (µg RE)THIAMINE (mg)RIBOFLAVIN (mg)NIACIN (mg)VIT. C (mg)
IronProteinVitamin A Niacin
CalciumRiboflavin
IodineVitamin C
FatThiamine
0 0.07 0.11 8.6 0
0 0.10 0.20 19.7 0
63 0.03 0.03 0.2 5
600 0.00 0.00 0.0 0
0 0.07 0.13 8.9 0
20 0 0.64 0.14 16.2 0
145 0.06 0.04 1.3 230
501 0.60 0.80 8.8 50
75 250 0.50 0.70 6.0 20
2 589 0.07 0.09 1.9 26
64 0.15 0.02 0.8 49
583 0.09 0.13 1.7 11
2 15 0.02 0.03 0.2 63
12 0.48 0.25 6.8 6
3 0.03 0.02 0.2 29
9 12,000 0.30 2.50 17.6 30
450 2,000 1.50 2.00 20.0 150
204 950 1.15 1.65 13.9 113
0 0.39 0.20 2.2 0
141 0.39 0.20 2.2 0
662 0.44 0.26 4.8 0
0 165 0.58 0.31 4.5 0
0 0.14 0.05 1.3 0
0 0.39 0.20 2.0 0
124 0.14 0.05 1.3 0
141 0.39 0.20 2.0 0
84 0.20 0.06 0.9 7
1,168 0.06 0.06 0.6 28
1,074 0.01 0.04 0.0 0
15 56 0.03 0.17 0.8 1
56 0.05 0.14 1.0 1
7 62 0.02 0.03 0.7 4
0 0.30 0.22 6.7 3
9,000 40,000 50.00 50.00 600.0 3,000
3,000 10,000 50.00 50.00 600.0 6,000
9,000 40,000 50.00 50.00 600.0 6,000
3,000 10,000 50.00 50.00 600.0 6,000
9,000 40,000 50.00 50.00 600.0 6,000
12,000 125,000 225.00 225.00 3,000.0 3,000
12,000 125,000 225.00 225.00 3,000.0 6,000
34 0.62 0.23 2.3 5
5 0 0.15 0.20 7.9 0
40 525 0.57 0.72 11.4 101
0 0.20 0.08 4.9 0
0 0.35 0.09 4.9 0
900 0.00 0.00 0.0 0
0 0.00 0.00 0.0 0
1,800 0.00 0.00 0.0 0
2 0 0.04 0.02 0.4 6
3 0.08 0.03 0.4 38
6,000 0.01 0.02 0.0 0
475 0.03 0.03 0.5 52
0 0.18 0.05 4.4 0
475 0.03 0.03 0.5 52
2 45 0.70 0.20 2.9 2
2 45 0.70 0.20 2.9 2
111 0.06 0.03 0.6 80
940 0.05 0.09 1.2 190
60 0.03 0.03 1.1 184
85 0.64 0.19 3.0 0
0 45 0.06 0.03 0.5 34
390 0.08 0.04 0.9 20
0 0.70 0.16 3.7 0
3 0 0.50 0.15 3.2 0
3 1 0.08 0.03 1.6 20
2 655 0.17 0.00 0.8 23
10 0 0.10 0.15 9.5 0
0 0.20 0.08 4.9 0
0 0.10 0.03 5.6 0
41 504 0.42 0.64 13.6 101
59 505 0.41 0.73 9.7 102
41 504 0.41 0.64 9.9 101
100 435 0.80 0.80 6.5 33
100 950 1.00 1.90 5.9 93
204 950 1.65 1.21 13.9 65
50 900 0.50 1.60 5.8 54
100 900 0.50 1.80 5.8 54
105 950 0.80 0.80 5.5 91
105 950 0.50 1.60 5.0 50
0 0 0.00 0.00 0.0 0
6,000 0 0.00 0.00 0.0 0
23 5 0.05 0.20 12.6 0
40 541 0.60 0.56 12.7 100
3 0.79 0.25 11.0 0
0 0.34 0.15 5.0 0
12 0.69 0.25 13.5 0
6 7 0.87 0.87 10.4 6
36 0.58 1.16 12.7 0
662 0.44 0.26 3.5 0
662 0.44 0.26 3.5 0
NutVal
Ration Name/Reference: Ration 1 - Location A Date: 01/03/2012 Calculated for a planned ration of: 2100
Home Help Return to Calculator
kcal g g mg mg µg µg RE mg mg mg mgENERGY PROTEIN FAT CALCIUM IRON IODINE VIT. A THIAMINE RIBOFLAVIN NIACIN VIT. C
0%
50%
100%
150%
200%
250%
300%
Percentage of Population Nutrient Requirements Supplied by the Selected Ration
NutVal
kcals
Return to Calculator
kcal g g mg mg µg µg RE mg mg mg mgENERGY PROTEIN FAT CALCIUM IRON IODINE VIT. A THIAMINE RIBOFLAVIN NIACIN VIT. C
0%
50%
100%
150%
200%
250%
300%
Percentage of Population Nutrient Requirements Supplied by the Selected Ration
NutVal
Ration Name/Reference: Ration 1 - Location A Date: 01/03/2012 Calculated for a ration of: 2115
Home Help Return to Calculator
Carbohydrate68%
Protein12%
Fat20%
Percentage Of Energy Supplied by the Different Macronutrients
Carbohydrate
Protein
Fat
NutVal
kcals
Return to Calculator
Carbohydrate68%
Protein12%
Fat20%
Percentage Of Energy Supplied by the Different Macronutrients
Carbohydrate
Protein
Fat
Percentage of Safe Level of Nutrient Intakes Provided by Planned Ration
Ration Ration Planned ENERGY PROTEIN FAT Calcium IRON IODINE VIT. A THIAMINE RIBOFLAVIN
Name Date Kcal kcal g g mg mg µg µg RE mg mg
NutVal 2006 - Ration Nutrient Summary Tracking Sheet
Data Entry Sheet
How to use:(1) Enter details of the survey into Box (A). (4) Enter the data from the survey into part (C) below.
(2) Enter the planned ration commodities, the grams per There is space to enter data on up to 37 beneficiaries
person per day (g/p/d), and the kcal/100g into Box (B). although samples of 30 are often adequate.
(3) Also enter the number of days covered by the (5) Results are calculated automatically. Click the
distribution in Box (B). View Results button to see the printer friendly results sheet.
Commodity g/p/d kcals/100g kcals/p/d
Camp/Area: Camp Name Maize 400 350 1400 Sample number
Beans 60 335 201
Distribution Site: Site 1 Oil 25 885 221
CSB 50 376 188 Average kcal
Survey Date: 01/01/2006 Sugar 15 400 60 % of planned
Salt 5 0 0
Survey Start Time: 09:00 0
Total weight: 555 Energy content: 2070
Survey End Time: 12:30
Number of days covered by this distribution: 14
(c) Food Basket Monitoring DataMaize Beans Oil CSB Sugar Salt 0 Summary
1 3 21000 500 100 2 1100 26 2500 60 800 19 330 8 0 96170 2290 111
2 8 25000 223 0 0 0 0 600 5 0 87500 781 38
3 3 15000 357 0 0 0 0 0 0 52500 1250 60
4 2 5678 203 0 0 0 0 0 0 19873 710 34
5 2 15000 536 0 0 0 0 0 0 52500 1875 91
6 4 12000 214 0 0 0 0 0 0 42000 750 36
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!
NutVal 3.0 On-Site Distribution Monitoring
(A) Details of Survey (B) Ration Planned for this Distribution
Sample NumberSex Address Family SizeRec. (g) g/p/d1 Rec. (g) g/p/d2 Rec. (g) g/p/d3 Rec. (g) g/p/d4 Rec. (g) g/p/d5 Rec. (g) g/p/d6 Rec. (g) g/p/d7 Total Kcal Kcal/p/d % Kcal
Food Basket Monitoring Data Collection Sheet
Date: Camp or Area: Site: Survey Times: -
Commodity name:
Address Received (gm) Received (gm) Received (gm) Received (gm) Received (gm) Received (gm) Received (gm)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Sample Number
Sex (M or F)
Family Size
Results Sheet
Survey Details
Camp/Area: Camp Name Distribution Site: Site 1
Survey Date: 01/01/2006 Survey Start Time: 09:00 End Time: 12:30
Results Summary
Number of samples taken 6 Number receiving <90% of planned kcals 4
Planned kcal/person/day 2070 % receiving <90% of planned ration 67%
Received kcal/person/day 1276 Number receiving >110% planned kcals 1
Average % of planned kcals received 62% % receiving >110% of planned ration 17%
Results by Commodity Weight
Planned Distribution Actual Distribution Received in Weight/Person/Day
Min. Max. Average % of No. Receiving
Commodity g/p/d kcals g/p/d g/p/d g/p/d planned <90% >110%
Maize 400 1400 203 536 339 85% 4 2
Beans 60 201 0 2 0 1% 6 0
Oil 25 221 0 26 4 17% 5 0
CSB 50 188 0 60 10 20% 5 1
Sugar 15 60 0 19 3 21% 5 1
Salt 5 0 0 8 2 44% 4 1
0 0 0 0 0 0 #DIV/0! 0 0
Total 555 2070
Results by Gender of Beneficiary Collecting Ration
Actual Distribution Received in kcals/Person/Day
Min. Max. Average % of Receiving < 90% Receiving > 110%kcal kcal kcal planned n % n %
Male 0 0 #DIV/0! #DIV/0! 0 #DIV/0! 0 #DIV/0!
Female 0 0 #DIV/0! #DIV/0! 0 #DIV/0! 0 #DIV/0!
Number of Male Beneficiaries: 0
Number of Female Beneficiaries: 0
% Female Beneficiaries: #DIV/0!
NutVal - Food Basket Monitoring Results (Version 2)
Gender of Ration Collector