***Macro Calculator - Beta Version***

[|progress|]

Download Link: http://www.mediafire.com/file/lcno4k...alculator.xlsx

I created this a while back as a tool to calculate the Macros for my diet. Given the amount of questions I have seen on here lately of people asking for help in determining their Macros for their diet, I figured I would share. Again, this is the Beta Version. It is not perfect, it does have some flaws. I am working to improve this tool, but it's going to take some time. If anyone has any suggestions of finds any errors, please feel free to shoot me a PM here.

Now for the spreadsheet itself.
1. There are two different versions - one calculating your macro needs based on a Gram Per Pound basis, the other based on a Percentage Split (Ex. 40/40/20). See the tabs at the bottom of the sheet to select which version you want to use.
2. Enter the Required Data into their respective fields - Height in Inches, Weight in Lbs, Bodyfat%, etc. Just enter into the cells in Column B.
3. The calculator is based on the Katch-McArdle Formula to calculate your Basic Metabolism Rate.
4. The Spreadsheet does have a few dropdown menus to aid in the calculations. Click on the cell to activate the dropdown. These are indicated next to the arrows on the sheet.
5. You can select the number of meals you wish to consume per day.
6. It will calculate how many calories and grams you need to consume for each macro for each meal based on the data you input.
7. It will calculate how much of each macro source you need to eat to meet your meal requirements.

Something that needs to be kept in mind. This is what I am working to fix, but it's going to take some programming to do so. It gives you how much of each macro you need to eat based on the calculations, however, it does not take into consideration how much of other macros are in each food source and subtract that out from those macros. For example, Beef Fillet has 6 g of Protein per Oz, but it also has 2 g of Fat per Oz. It does not subtract the 2 Oz of fat from your requirement to meet your meal requirements for fat. You will need to manually do this or you will be overeating if you don't. I personally just round down, but I know some will want it to be precise. It's not there yet. I am working on it.

Post here if you have any questions.

[|progress|]

Bump for the day crowd.

[Thetree1918]

Nice spreadsheet, clean and not over complicated.

[bapestar7]

Nice work! This helps a lot!! Did you ever work out the kinks?

[Kerbouci]

very good job bro. thank you

[jiveinhere]

wow this is actually awesome, cheers man

[alex2363]

Nice, im still trying figure out how to calculate the macros.

[|progress|]

No, never did work out the kinks. I will get on that. Sorry for the late reply.

[SinNneerR]

Would be awesome if you could work out the kinks man. Repped bro.

[wheathins]

pretty cool bra, work out dem der kinks though. repped

[kingof_queens]

Thank you! Repped.

[luvta2s]

Now I understand what macros mean, thanks