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.
Healthy Diet Excel based Weekly Diet Calculator Geoff Edwards
I have updated the Excel spreadsheet. As far as I remember very little has been changed. I have added some more comments and revised some others. The current version is Weekly Healthy Diet 2019v26
The tool provides the data for the user it is up to the user to modify their diet so that it is well balanced. Indivdiuals may need to modify their diet according to a health practioner's instructions, ie. allergies. The calculator can be used to control weight gain and loss and also enble the diet to be balanced:
individual monitorig levels of, for example, iron in the diet
automatci calculation of BMI (Body Mass Index) to a tenth of a unit eg. 24.7 or 24.1 this shows whether you are almost 25 BMI or almost 24 BMI
recording of Five a Day in partial portions. If the food eaten is contributing to your 5 a Day then it all counts
water consumption from food and drinks enables controls hydration levels
adaption to individual requirements: sex, age, weight, height, level of activity
meaningful colour coded foodstuffs - eg. meat pink, fish, blue, bakery beige, vegetables green, fruit dark green, confectionary gray
sensible units nearly all food is based on 100g units (almost 1/4 a pound weight)
accuracy of data which is based on USDA (United States Department of Agriculture Standard Food LIsts
Is similar to a shopping list - not what you want to buy but what you have eaten
developed using MIcrosoft Excel compatible to open source spreadsheet software (except for Conditional Formatting)