Spreadsheet Calculations

Calculating nutrition requirements: This is a simple spreadsheet application to calculate nutrition requirements for a specific country using UN Population Division population data and World Food Programme estimates of nutritional requirements. The resulting estimates are then compared to the estimates of available food from FAO, Note that the calculation is an estimate of nutritional requirements-- calories, protein, fat and additional nutrients required for a healthy lifestyle-- it does not estimate demand for food, which is, among other things, dependent on population size, taste, disposable income, income distribution, etc.  In economics nutritional requirements would be termed a necessary condition-- you cannot have national food security unless all nutritional requirements at the national level are met.  However, just meeting nutritional requirements at the national level is not a sufficient condition which requires that every person have access to that food. Data in this model will be entered by hand--the emphasis is on using a spreadsheet to carry out the calculations, however, links will be provided for the data sources. To see the training material click here.

Copyright 1998/2015 GRI    Updated 2 May 2015