My Website (in progress)

My Website (HTML)

in progress

Here, you can see the main template of my website. I have a banner, 4 buttons and a footer that I have created on Adobe Photoshop and I put the whole thing together in Adobe Dreamweaver. The white part in the middle is where the content will go so i have created an editable region so I can edit the part to make multiple pages. This isn't finished yet, and i will be adding more things in the future (like some actual content) 

My Calorie Counter (microsoft excel)

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.