Admin or Register Login

Healthy diet

Forum Home


Healthy Diet Tool Introduction

Link to this post

Healthy Diet  Excel Weekly Tool Introduction

Author Geoff Edwards. Its all my own work taking over ten years. This Microsoft Excel based tool is based on verifiable data from the United States Department of Agriculture (USDA) . I was not employed to develop the tool. It just developed and I thought that if it was useful to me it could be useful to others.

Accompanying this introduction is a download to a PDF file that reports on the project: Healthy Diet  the rest of the website category "Healthy Diet" is provided as a report mainly on the development of the project and other topics. Reference:  The most definitive document on the topic of human nutrition is published by the Food and Agricultural Organisation of the United Nations in conjunction with the WHO (World Health Organisation  Human Vitamin and Mineral Requirements

U.S. Department of Agriculture, Agricultural Research Service. FoodData Central, 2019.

I have set up a Facebook page which provides opportunities for users to ask questions: Healthy Diet Calculator

Healthy diet updates are listed below.

Posted on 10 Jun 2018 by Geoff Edwards
Powered by CuteNews
Healthy Diet update v25

Excel Based Healthy Diet Tool 2018v25

I have updated the Weekly Healthy diet Tool.  I have amended the Beer list as I had forgotten to list the fact that increasing amounts of alcohol provide more calories.  This has lead in may case to a discrepancy between my actual weight and the weight as calculated by the spreadsheet.  My actual weight being lower than what the spreadsheet calculates.

Although the existing Custom Beer entry works it has flaws, I do not think that I can resolve the issues. The best solution is to include more beer entries with varying percentage of strength.

Another addition is that I have highlighted in yellow nutrients that have a greater amount of the nutrient. Every one of the supplementary spreadsheet has been modified. This makes it easier to scan a nutrient to see which foodstuff has large amounts of a nutrient. I have reduced the RDA for Potassium from 4700mg to 3500mg in line with WHO recommendations.   Geoff Edwards 24/08/2018

 Link: Weekly Healthy Diet 2018v25

PS.  I have also formatted BMI (Body Mass Index) to two places of decimals. I think that this is useful as one could be either almost a lower BMI or almost a higher BMI index number.

NB. As mentioned in the spreadsheet the calculated BMI is only calculated from the weight at the end of the week.


Posted on 24 Aug 2018 by Geoff Edwards

Powered by CuteNews


2007 for Society, Culture and the Arts