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

Healthy Diet 2017v20 Excel spreadsheet Weekly Diet Tool

This update adds three more cheeses: Feta, Parmesan and Ricotta to the spreadsheet. Sweet Corn has also been added. The Beer 5 percent entry is too awkward to manage for percent alcohol less or more than 5 percent so I have added an extra entry Beer 3 percent.Update

Experimental trial

I have highlighted food that contains more than 300mg of Potassium in the Potassium spreadsheet. If this is worthwhile I will introduce highlighting to other nutrient entries.

Managing Alcohol

Alcohol Total Units has been adjusted to include both three and five percent beer entries.  Entering 0.5 in both beer cells is equivalent to a pint of beer of 4 percent and records 2.3 units of alcohol. Those users who are familar with Excel may use the Formula bar to insert a function to calculate other percentages of alcohol. For example entering "=3.8/5"  without caps, will provide the correct number of units for a 3.8 percent beer, but this returns a value of 0.76 which alters the water content so that 0.24 needs to be added to the Water entry.(disregard this nothing needs to be added to the Water entry. The water content of all  food entries have their water content added automatcially.)

Reference Note

It is worthwhile for new users to refer to earlier entries in the Healthy diet category.

Posted on 20 May 2017 by Geoff Edwards

Powered by CuteNews


2007 for Society, Culture and the Arts