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 v23

Healthy Diet Excel spreadsheet Weekly Diet Tool 2018v23

I have updated the Weekly Healthy Diet Tool. Two new entries are Cider and a Custom Percentage for Beer.  I have also amended some of the cell notes and corrected a small error in the percentage of alcohol consumed. The water content of beer is 522ml per 568ml (pint) not 568ml this error has been amended.

The Custom Percentage calculator for beer requires to first add the quantity to the spreadsheet and then go to the Beer spreadsheet which is located after the Zinc tab. In the Beer sheet select the day of the week for the beer consumed and then enter the volume and the percentage. As the spreadsheet calculates in units of a pint (568ml) adjustment may be used to correct the water content.(only alter the Green cells)

I have also realized that it is not necessary to add the consumption of butter and butter spread, oils and lard as the food list takes into account whether these ingredients are used or not. It is still useful to record these fats though and I intend to continue to record the quantities but just in the Notes column.
Updated spreadsheet

Please note that it is worthwhile reviewing other posts for further information

Posted on 10 Mar 2018 by Geoff Edwards

Powered by CuteNews


2007 for Society, Culture and the Arts