Nutritional Intake and Activities Database
Originally published: 02/04/2020 13:09
Publication number: ELQ-92151-1
View all versions & Certificate
certified

Nutritional Intake and Activities Database

This is a workbook that show how to create and subsequently create dashboards from Datasource brought into Excel.

Description
This file opens at the Instructions sheet, whereby the user is directed by on how to use the file. There are six worksheets, two (Activities, Foods) of which are user input sheets in yellow. The Inputs require the user to record daily intake of food for breakfast, lunch and dinner. The other input sheet requires the user to record daily activities. There is a dashboard sheet which provides several Indicators such as BMI, Calorie counts, Nutritional Intake, nutrition, Deficiencies and so forth.

The Tracking of the Activities and Food intake are calculated and presented in the Dashboard file. The Dashboard requires the user to first input some personal information i.e Age, Gender, Weight and expected daily calorie in take. In return the user will then be provided with information relating to their Current BMI and the calorie Intake and Calorie burn.
The BMI uses the Excel Graphing tools to present a Meter for measuring the where the users BMI lies between Under used to Obese.

The rest of the dashboard presents various details on recommended daily in take of Vitamins, Minerals and trace elements including calories and water and also displays where the user is under or over the recommended Intake. The user can also view how they are burning their calories through their daily activities.

This Best Practice includes
1 Excel File

Acquire business license for $10.50

Add to cart

Add to bookmarks

Discuss

Further information

KEY OBJECTIVE IS TO PROVIDE A TEMPLATE TO LOOKUP AND CONCERT DATA INFORMATION INTO DASHBOARDS

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Nutritional Intake And Activities Database?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...