Admin or Register Login

Healthy diet

Forum Home

 

Healthy Diet Tool Introduction

Link to this post

Healthy Diet  Excel Weekly Tool Introduction

Author Geoff Edwards. Its all my own work taking over ten years. This Microsoft Excel based tool is based on verifiable data from the United States Department of Agriculture (USDA) . 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.

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 mainly on the development of the project and other topics. Reference:  The most definitive document on the topic of human nutrition is published by the Food and Agricultural Organisation of the United Nations in conjunction with the WHO (World Health Organisation  Human Vitamin and Mineral Requirements

U.S. Department of Agriculture, Agricultural Research Service. FoodData Central, 2019. fdc.nal.usda.gov.

I have set up a Facebook page which provides opportunities for users to ask questions: Healthy Diet Calculator

Healthy diet updates are listed below.

Posted on 10 Jun 2018 by Geoff Edwards
Powered by CuteNews
Healthy Diet Tool 2016v10

 

Healthy Diet Tool Update v10

Important update to the Microsoft Excel Diet Weekly sheet V10

I have added a new Microsoft Excel worksheet to my workbook:  Salt         .Healthy Diet Recording Tool 2016 v10

  • My Healthy Diet Record Tool is a useful tool to help count calories which is required to monitor weight loss or gain which is under the control of the user. It is also linked to the users age,gender,height and existing weight and their level of physical activity.
  • Food intake is analysed automatically to provide: carbohydrate, fat, protein, portions of the NHS Five a Day, alcohol units and iron, vitamin C and salt
  • according to individual personal data which is required protein, fat and carbohydrate needs are calculated
  • quantities are based on single items or 100g quantities
  • data is taken (mainly) directly from the USDA National Database for Standard Reference Release 28
  • there are two pie charts which automatically show the categories of food
  • the USDA chart omits alcohol and confectionary and is based on calories not volume
  • some new entries have been made and some errors traced and removed

Please note the workbook has a meal entered for Sunday. This is only included to show how the sheet can be used. Delete that data.

Salt in the diet

We are aware that the amount of salt consumed is often far too much. The labeling of food does provide a useful guide but in practice the salt content of the food we eat and drink is not made available at meal times. The Excel workbook with its multiple spreadsheets provides this and other information.

Healthy Diet Recording Tool Geoff Edwards

The tool has been developed using Microsoft's Excel software over a period starting in 2008. I have used it almost continuously on a day to day basis but it can be used for limited periods to monitor a healthy diet.

The user must be able to enter data on a spreadsheet and handle simple formulas.

0 Comments
Posted on 05 Jan 2016 by Geoff Edwards

Powered by CuteNews
 

 

2007 XYZWeb.co.uk for Society, Culture and the Arts