Results 1 to 14 of 14
Like Tree3Likes
  • 3 Post By Times Roman

Thread: Excel: Macro Nutrient Calculator

  1. #1
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383

    Excel: Macro Nutrient Calculator

    I periodically put this out there for the asking. (see attached example)

    I have an Excel Macro Nutrient Calculator I've created. It's simple, interactive, and easy to use with almost 1,000 food items.

    PM me or email me if there is any interest.

    And of course, it's free.

    Let me know

    ---Roman

    Click image for larger version. 

Name:	Screen Shot of Macro Calculator.PNG 
Views:	1552 
Size:	16.2 KB 
ID:	150626
    tarmyg, tango02 and Timburr like this.

  2. #2
    tango02 is offline Associate Member
    Join Date
    Jun 2012
    Posts
    231
    PM sent

  3. #3
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    just sent it to you. check it out. if you have any suggestions or if you think the spread sheet could use some improvements, just tell me here and i'll fix if need be.

  4. #4
    Beethoven's Avatar
    Beethoven is offline Productive Member
    Join Date
    Jun 2013
    Location
    South Fla
    Posts
    1,472
    PM sent.

  5. #5
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    with a little help I've modified the original for a more complex version that now has tabs for each of eight meals and a summary tab for the entire day

  6. #6
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    and now the super deluxe version...

    The Macro Calculator: Deluxe Version

    and what the summary page now looks like:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	3168 
Size:	80.7 KB 
ID:	150671

  7. #7
    tango02 is offline Associate Member
    Join Date
    Jun 2012
    Posts
    231
    I have been using this spread sheet for the day and its a nice addition to keeping up with my meals. Nice to have technology to help.

  8. #8
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    here is a website you can cross reference the validity of some of the values for the food items I've included

    Foods List

  9. #9
    tango02 is offline Associate Member
    Join Date
    Jun 2012
    Posts
    231
    I was adjusting my meals on each tab and my totals were coming out WAYY off. So I went back and looked....and looked again....double check my numbers. My TDEE is way off, my fats are way high...im like WTF is going on????

    I didnt change the quantity tabs on meals 7 and 8!!!( I dont eat 8 meals a day) DUHHH!! IDIOT!! Read through the entire fvcking spreadsheet man!! LMAO

  10. #10
    Lee_1978's Avatar
    Lee_1978 is offline Member
    Join Date
    Mar 2014
    Posts
    537
    PM sent

  11. #11
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    Quote Originally Posted by tango02 View Post
    I was adjusting my meals on each tab and my totals were coming out WAYY off. So I went back and looked....and looked again....double check my numbers. My TDEE is way off, my fats are way high...im like WTF is going on????

    I didnt change the quantity tabs on meals 7 and 8!!!( I dont eat 8 meals a day) DUHHH!! IDIOT!! Read through the entire fvcking spreadsheet man!! LMAO
    just revised the spreadsheet for a new function.

    grams to go based on your macro split goals, and what you have ate so far. check the upper right hand corner to see.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	5674 
Size:	159.5 KB 
ID:	150876

  12. #12
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    Quote Originally Posted by tango02 View Post
    I was adjusting my meals on each tab and my totals were coming out WAYY off. So I went back and looked....and looked again....double check my numbers. My TDEE is way off, my fats are way high...im like WTF is going on????

    I didnt change the quantity tabs on meals 7 and 8!!!( I dont eat 8 meals a day) DUHHH!! IDIOT!! Read through the entire fvcking spreadsheet man!! LMAO
    tango,
    Next time, you can check here and immediately see if you have 100% cleared out the prior day's data.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	1520 
Size:	16.1 KB 
ID:	150877

  13. #13
    Timburr is offline New Member
    Join Date
    Feb 2015
    Posts
    2
    I wish I knew how to PM you.

  14. #14
    RaginCajun's Avatar
    RaginCajun is offline Pissing Excellence!
    Join Date
    Jan 2011
    Location
    Deep Down South
    Posts
    23,624
    Quote Originally Posted by Timburr View Post
    I wish I knew how to PM you.
    welcome!

    you need to get your post count up to 50 to PM

    browse the forum, plenty of great info all over the place!

    if you are looking for advice or help, start a thread and we can assist you

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •