Related Experiment Video
Updated: Jul 10, 2026

Iterative Development of an Innovative Smartphone-Based Dietary Assessment Tool: Traqq
Published on: March 19, 2021
Development of NutVal version 5: a spreadsheet application for planning and monitoring humanitarian food assistance
1Institute for Global Health, UCL, UK.
Objective:
To develop a software application for planning and monitoring the nutritional content and cost of humanitarian food assistance, provided by food or cash transfers.
Design:
Development of software.
Setting:
Humanitarian emergencies.
Subjects:
Food rations or cash transfers provided to beneficiaries.
Results:
NutVal v5 is an Excel application for the calculation of the macro- and micronutrient content of food assistance and comparison with the requirements of fourteen different population groups, including the population-averaged requirements, child and adult sub-groups, and people in detention. The criteria for nutrient inclusion and the calculation of population group requirements are presented. Market costs can be entered for the calculation of a cash-transfer equivalent value, and different food rations can be saved and compared over time.
Conclusions:
The NutVal application has been widely used by humanitarian organisations to plan and monitor food transfers. The enhancements in version 5 should allow for its continued use in food assistance programmes where cash and voucher transfers are increasingly common.
Related Concept Videos
Applications of GIS: Disaster Management and Emergency Response
Hazard Analysis and Critical Control Points (HACCP)
Levels of Use of a GIS
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Data Reporting and Recording
Overview of Microsoft Excel as a Data Analysis Tool
