Weekly Diet Excel workbook calories protein and fat calculator
The screen shot below shows part of the Excel workbook that can be used to control weight. It can also provide indications of whether the food and drink consumed is healthy. The diet sheet works like a shopping list, except the lists are of food and drink consumed. It could also be used for meal planning.
The image below is a close up of the information provided from personal data that the user needs to input. All information is automatically generated.
The image below includes a larger view of the worksheet. A pie chart is generated along with calculated BMI, protein and fat requirements. In the example shown food and drink for Friday is not complete and there are no entries for Saturday yet - it being 6pm thursday :)
The Excel workbook download: Diet weekly sheet 2013v1. The workbook includes a pie chart for the the US Dept of Agriculture categories but the food groups are displayed as Kcal not volume.
Important: Cooking Oil fat content is 13.8 gm per tablespoon or equivalent 14 gm. The worksheet has been amended date 2,d July 2013 12:06 Greenwich London time
Update: added Stinging nettle. Diet weekly sheet 2013 Update required Sunday 13th Ocotber 2013 update