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
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.
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.)
It is worthwhile for new users to refer to earlier entries in the Healthy diet category.