Calorie Counter
This is the main sheet of my calorie counter. One side is for the questions,and the other is for the results. I have used drop-down lists, radio buttons and spinners to allow the user to edit their answers. It calculates your BMI using your weight and height, then it looks up the average BMI for your age. I have not put in this function yet, but i will and when I do I will use the "VLOOKUP" command. It also calculates the number of calories in each meal, each day and each year. To do this i had to find out the calories for each meal of the day, add them up to get the calories for each day, then multiply them by 365.25 to get the calories for each year. I will put a question to see how many calories are burned in a day to make it more accurate.
This is the second sheet of my calorie counter. This is where I keep all the data to make the first sheet work. There is a table on the right of all the foods and their calories. I have made these appear on the first sheet using the "VLOOKUP" command.
On the left there is the calculation to differentiate the results of male and female users.I have not put this in yet, but i shall do so later on.
This is the "VLOOKUP" formula that i used. This formula is very effective because it can look at a chart and understand what something means, for example on the charts shown above it says that eggs are 155 calories, if we used "VLOOKUP"on a cell that says eggs, it will be able to understand that eggs are 155 calories.
Here are the differences between a male's and a female's results. The top one is the female results and the bottom is the male results
This is the results for a person who only eats junk food that contains lots of calories.
This is the results for a person who only eats low calorie food.
Explain how you are able to make 'what - if' predictions. E.g. What if a person eats junk all day? What is the calorie intake? What if they eat healthily? What is the calorie intake? What if a female eats the same food as a male? How is their BMR affected (the required calories) ? Show screenshots for different 'what-if' scenarios and explain each.
ReplyDeleteI think your calorie counter is very good fro various reasons. One reason is that it is very bright as you have used very bright colours which makes it stand out alot which is eye catching. Also I like how you have almost like two seprate parts to your calorie counter, one for the questions and one for the results which I think is very good and helps the whole thing flow better. You have used alot of features like drop-down lists, spinners and radio buttons which look as if the work. The only thing you have not included in your blog is what if predictions which would have been good in showing us how your counter worked and if it worked. Apart from that I think it is very good.
ReplyDeleteoh yeah this is a nice work m8
ReplyDelete