Admin or Register Login

Healthy diet

Forum Home


Healthy Diet Tool Introduction

Link to this post

Healthy Diet Tool Introduction

Author Geoff Edwards. Its all my own work taking over ten years. Of course it is based on verifiable data and use on a daily basis and the Microsoft application Excel without which it would not have been created. 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. Fortunately, I am healthy, aged 76 and still capable of over a thousand press-ups a week and of performing a complete circuit of 360 degree jumps at Swindon Ice Rink (provided no one gets in the way :). And I weigh a little under 84Kg (update 10th Feb 2019 79Kg).

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 on the development of the project and other topics.

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