Weekly Diet Excel worksheet update 2014v3
I have updated my Weekly diet sheet from v2 to v3. I have added "Portions a Day". The spreadsheet provides valuable information about the proportion of food and drink and its fat, protein and calorie content, units of alcohol are recorded and now you can check to see how many recommended portions of food you are eating.
The spreadsheet is meant to be used daily to record what is eaten and drunk. Anyone intent on losing weight should be able to check the progress they are making and be aware of whether they are consuming enough protein and fat. The spreadsheet can of course be used for body building as well as losing weight safely :)
The formula for determining bodily requirements is calculated using the Harris-Benedict formula. Microsoft Excel workbook free download: Weekly diet calculator
Please note I have added my food and drink consumption for Sunday and some of my food and drink for Monday. The reason being that users can see clearly how the list creates the pie chart. This data should be deleted. Personal details must be changed according to the user's age, gender, height and level of activity. Sunday's date will need to be changed.
My procedure is to open the (downloaded) spreadsheet and then Save As with Sunday's date. I then delete the previously entered data in order to start afresh. The spreadsheet will not reflect your requirements without adding details of your: gender, level of physical activity, age and present weight.