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 2017v19

Healthy Diet 2017v19  Excel spreadsheet Weekly Diet Tool

Further to the recent v18 update I have added Camembert cheese and included the USDA Food List reference number (NDB No.) to the Stilton cheese entry which was omitted in v18. The blue stilton data that I have used is from a commercial supplier Coombe Castle. The data in the USDA Food List that includes commercial products is from the labelled product and may not include all the entries that the Food List normally lists. In the case of cheese I have copied missing data from the Cheddar cheese entry to the Stilton entry.  This is preferable to entering a zero quantity. I will consider adding a comment to entries that have data from labelled products which does not supply the usual complete Food List nutrients. 

USDA Food List

The USDA Food List requires the user to select the data source from Select Source. The options are: All data sources, Branded food products and Standard Reference. 
To read the Food List entries as used in the Healthy Diet spreadsheet the user would normally select Standard Reference except when the entry is for a branded product.

Excel conditional formatting

So far the conditional formatting that I have employed is working but may need further information. Conditional formatting is used so a check can readily be seen that the target RDA (recommended Daily Allowance) is not met.  The spreadsheet cell's background colour remains light pink, or for those nutrients that do not have an RDA remain uncoloured. When a nutrient meets the target RDA it's background colour will be removed. If a nutrient's RDA is met and exceeded the adjoining cell's background colour will change to dark pink.  

I have re-included a muesli meal to provide an example of how the spreadsheet displays data. The user can delete the entries and enter their own. 

Note that each nutrient has its own spreadsheet for the data. These eighteen spreadsheets are unlocked. I have left them unlocked as it is a real chore to unlock them for editing the workbook and then lock them again. By all means refer to the individual nutrient lists but beware not to change anything.  Always when downloading an update make a copy as a Save As for your working weekly diet spreadsheet.

Healthy Diet 2017v19

 Earlier versions are below. Version 16 has a list of the features. Link

Posted on 17 Mar 2017 by Geoff Edwards

Powered by CuteNews


2007 for Society, Culture and the Arts