Calorie Counter

We made a calorie counter and BMI model on excel.

We got all of the information for our calorie counter first: We got a list of foods for each meal of the day and how many calories it has. 

We used drop down lists by clicking data validation, selecting list then highlighting the cells we wanted to use   to create multiple choice answers for the questions, and to help when using formula later.

We also used spinners, arrows that can be pressed up or down for an answer, for height and weight options.

The formulae for calculating a person's BMI is:

BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) + 5         (man)
BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) - 161     (woman)

VLOOKUP is a command that looks up and applies cells. To use VLOOKUP, you type 'VLOOKUP' into the cell, then click the cell you want it to appear in, then highlight the cells you want to look up, then the column number.

Updated Calorie Counter ^

This If statement formula is for the BMR, If the person selects female for gender options, the end of the formula is -161, but if the user is male it is +5 instead.

What If they eat junk all day?

If I eat junk all day the calculator counts the calorie intake from the whole day and compares it to the calories supposed to be intaken. It then recommends the calorie amount you should be having to keep fit and healthy.

What If they eat healthy all day?

If I eat healthy all day the calculator counts the calorie intake from the whole day and compares it to the calories supposed to be intaken. It then recommends the calorie amount you should be having to keep fit and healthy.