Excel Workbook Healthy Diet Record Tool: Update 2015v6
I have updated my Microsoft Excel Weekly Diet sheet as I found a few more items that needed improvement. Existing users should download the new sheet. Please note that the existing issue with whether to record oil and butter consumption on a daily basis or weekly still persists. I have added Butter Spread separate to Butter. I have also added the fat content of Crisps to Cooking Oil. So if the user decides to eat a packet of crisps he or she will note that Cooking Oil is added to and shown on the pie chart.
There is a new item, Lasagne added (I couldn't find data for percentage cheese content of a beef lasagne, so meat and bakery content only)
I needed to amend Pancakes and Cornish Pasty.
It is important to note that the fat content of all foods listed is complete and is recorded each day. It would be possible to add additional worksheets for Nutrient content but this would be a lot of work. The Five a Day Portions helps to ensure that users can balance their diet.
Healthy Diet Excel Spreadsheet Weekly Record
For new users please note that I add some food to the Sunday column so as to populate the pie chart, which would otherwise be blank! That data should be deleted, it is only included to help users realize how the spreadsheet works.
For personal use you will need to alter the data referring to your: gender, age, present weight, height and level of activity.
NB. Portions of the Five a Day advice will tally all foods that are listed in the Five A Day list published by the NHS no matter how small. The Weekly sum of portions will reflect this