Admin or Register Login

Healthy diet

Forum Home

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
E-mail: (optional)
Smile: smile wink wassat tongue laughing sad angry crying 

| Forget Me
Content Management Powered by CuteNews


2007 for Society, Culture and the Arts