This is one of a series of very small projects:
The program is a very simple excel based application where users would be able to calculate the burnt calories from doing a number of activities. the activity list is a predefined list (can use the one [url removed, login to view])
The front worksheet of the excel file will have a number of fields, user name, weight, height, age and the list of activities
This is a very simple file that requires minimal work, we dont anticipate it will require more than half a day
The calculation for calories burnt is
Calories burned = ((METs * 3.5 * weight in kg) / 200) * duration in minutes.
Table for MET is [url removed, login to view]
The MET table would be in a seperate excel worksheet, the main entry worksheet should have a field for Name, Age, Weight, Height and a weekly table (with drop down boxes linked to the activities in the MET Table)
The main table would include 7 columns (one per day of the week) and 30 rows. Each cell within the week table would contain the drop down menu of activities for the user to choose from.
The excel file should also provide the SUM of calories burnt per day and total calories burnt per week