Id like some input on my spreadsheets im trying to create to help people figure out the BMR and calorie needs.

Any advice is welcomed, and i hope yall like it. I tried to make it as user friendly as i could. All you gotta do is put in your age and weight and height, of bf% if you know it.

http://www.dickwad.net/ot/macro.jpg

Sorry about that! Make sure your security level is set to low or medium.

This is from the help section of excel:
"I can't use a macro in a workbook or add-in program that I opened.

Macros might have been disabled automatically If the security level is set to High and you open a workbook or load an add-in program that contains unsigned macros, the macros are disabled and you cannot run them. You can enable macros that are not digitally signed if you change the security level to Medium, close the workbook or unload the add-in, and then reopen the workbook or reload the add-in. If you want Microsoft Excel to automatically disable unsigned macros in the future, remember to change the security level back to High.

You might have chosen to disable macros when you opened the workbook If the security level is set to Medium or High and you chose to disable macros because you don't trust their source, you cannot run the macros. To run the macros, close and then reopen the workbook or unload and reload the add-in program, and then click Enable Macros.

Shouldnt there be some kind of formula in B9 and E9?

I get 0 at the bottom no matter what.

Shouldnt there be some kind of formula in B9 and E9?

I get 0 at the bottom no matter what.

Yeah you are right! I forgot to protect the sheets and cleared some stuff before i uploaded it so i ended up deleting the formulas! Im an idiot!

This one should work, and i promise to give up and quit wasting your time if it doesnt!!

Great tool! Thanks for putting that together, maxout! :tu:

Yes, thanks. Cool spreadsheet. :)

So i take it that everything worked ok on my second try!!???

I got a question for anybody that knows how to use excel well. How do you lock a formula into a cell so nobody can change it, yet they can clear the cell without clearing the formula too and it not work anymore?

Thats awesome. Can you put in the formula for calculating bulking calories? Does anyone know what it is?

Thats awesome. Can you put in the formula for calculating bulking calories? Does anyone know what it is?

All i did for the cutting calories is take the BMR and subtract 500. So i guess you could just take your BMR and add calories to it. :confused:

Im not through with the worksheet by all means. Ive got millions of ideas that i want to add to it, so ill be updating it and posting it again in the future.

i wish i had excel : (

i wish i had excel : (


www.openoffice.org

I added a whole bunch of new features to my workbook!! Again, any suggestions would be GREATLY appreciated!

looks good, MAXOUT. :tu:

On the first sheet, you should think about making a seperate block for entering all of your personal data. It might make it easier than scrolling around the sheet looking for the places to fill in data. Just a thought. :D

Sweet!!! thanks! :tu:

Based on this I need to take in around 3500 cal to bulk. No wonder I never gain weight!! I don't ever eat enough! :mad:

Well at least I'm happy with my body now... :claplow:

looks good, MAXOUT. :tu:

On the first sheet, you should think about making a seperate block for entering all of your personal data. It might make it easier than scrolling around the sheet looking for the places to fill in data. Just a thought. :D

Thats a great idea! I axually thought about that not ten minutes after i posted it! Great minds think alike huh?!! :tu:

Excellent work MAXOUT! :claplow: :D

John, I think this spreadsheet workbook should be considered and moved to "Sticky" where everyone can use it for her/his personal use. :tucool:

Nice spreadsheet. Here's a suggestion for you: How about incorporating BF% calculations into it? There are many different methods for calculating BF and something like this spreadsheet found here http://maelstrom.seos.uvic.ca/people/zahariev/misc/bf_men.html

This spreadsheet takes measurements from 10 diff spots and plugs them into the various formulas and then gives you the average.

Something similar would be a very nice addition to your spreadsheet.

Great minds think alike huh?!! :tu:

Suggest you think about adding a body fat percentage estimator. I know it is not completely accurate, but it is a fast way to get a daily estimate with only little measurement.

For men:
1. multiply your weight (nude) by 1.082
2. add this number to 94.42
3. multiply your waist girth(measured at the navel)by 4.15
4. Subtract this number from the number obtained in step two to obtain your "fat-free" body weight.
5. Subtract your fat-free weight (obtained in step four) from your body weight.
6. Mutiply that number by 100.
7. Divide that number by your total body weight to obtain your body-fat percentage.

For Women:
1.Multiply your body weight (nude) by 0.732
2. add this number to 8.987 (save this number).
3. Measure the circumference of your wrist at its widest point, and divide the circumference by 3.14 (pi) to determine your wrist's diameter (save this number).
4. Multiply your waist (measured at the navel) by 0.157 (save this number).
5. Multiply your hip circumference (measured at its widest point) by 0.249 (save this number).
6. Multiply your forearm circumference (measured at its widest point) by 0.434 (save this number).
7.add the numbers obtaied in steps two and three (save this number).
8. Subtract the number obtained in step four from that obtained in step seven (save this number).
9. Subtract the number obtained in step five from that obtained in step eight (save this number).
10. Add the number obtained in step six to that obtained in step nine. This is your fat-free weight.
11. To obtain your body-fat percentage, subtract your fat-free or "lean" body weight from your total body weight. Multiply that number by 100 then divide by your total body weight.

Whew! Now you can fill in the BF% for Katch- McArdle BMR formula and keep it on a daily basis or when you choose to measure.

RTE

Suggest you think about adding a body fat percentage estimator. I know it is not completely accurate, but it is a fast way to get a daily estimate with only little measurement.

For men:
1. multiply your weight (nude) by 1.082
2. add this number to 94.42
3. multiply your waist girth(measured at the navel)by 4.15
4. Subtract this number from the number obtained in step two to obtain your "fat-free" body weight.
5. Subtract your fat-free weight (obtained in step four) from your body weight.
6. Mutiply that number by 100.
7. Divide that number by your total body weight to obtain your body-fat percentage.

For Women:
1.Multiply your body weight (nude) by 0.732
2. add this number to 8.987 (save this number).
3. Measure the circumference of your wrist at its widest point, and divide the circumference by 3.14 (pi) to determine your wrist's diameter (save this number).
4. Multiply your waist (measured at the navel) by 0.157 (save this number).
5. Multiply your hip circumference (measured at its widest point) by 0.249 (save this number).
6. Multiply your forearm circumference (measured at its widest point) by 0.434 (save this number).
7.add the numbers obtaied in steps two and three (save this number).
8. Subtract the number obtained in step four from that obtained in step seven (save this number).
9. Subtract the number obtained in step five from that obtained in step eight (save this number).
10. Add the number obtained in step six to that obtained in step nine. This is your fat-free weight.
11. To obtain your body-fat percentage, subtract your fat-free or "lean" body weight from your total body weight. Multiply that number by 100 then divide by your total body weight.

Whew! Now you can fill in the BF% for Katch- McArdle BMR formula and keep it on a daily basis or when you choose to measure.

RTE


Thanks for the info guys! The body fat percentages would be a great idea. I'll add them in as soon as I get back into town. ( i went home for the weekend from school). :tu: