Results 1 to 37 of 37
Like Tree1Likes
  • 1 Post By Times Roman

Thread: The Macro Calculator: Deluxe Version

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

    The Macro Calculator: Deluxe Version

    Mates,

    I spent more time on this today. This is an interactive spreadsheet that will calculate your macros for you:

    1) Macros per meal
    2) Macros per day
    3) It will calculate your TDEE
    4) It will calculate your minimum protein requirement per day in grams
    5) Allows for up to eight meals per day
    6) Does a variety of analytics including protein deficiency in grams and %, and including macro percentages
    7) includes almost 1,000 food items

    Take a look at the summary page:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	3299 
Size:	80.7 KB 
ID:	150670

    Yours free, just for being a member (gee, isn't that wonderful?)

    PM me and I will email it to you

    Fair enough?

    ---Roman

  2. #2
    Hazard's Avatar
    Hazard is offline AR-Elite Hall of Famer
    Join Date
    Mar 2004
    Posts
    20,517
    Great job roman..... Damn.
    Failure is not and option..... ONLY beyond failure is - Haz

    Think beyond yourselves and remember this forum is for educated members to help advise SAFE usage of AAS, not just tell you what you want to hear
    - Knockout_Power

    NOT DOING SOURCE CHECKS......


  3. #3
    wellshii is offline Member
    Join Date
    Apr 2014
    Posts
    675
    Right on.

  4. #4
    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 Hazard View Post
    Great job roman..... Damn.
    Quote Originally Posted by wellshii View Post
    Right on.

    see all the wunnerful shit I can do when 'tween jobs? =)

  5. #5
    lovbyts's Avatar
    lovbyts is offline Knowledgeable Member
    Join Date
    Apr 2008
    Posts
    30,210
    Quote Originally Posted by Times Roman View Post

    see all the wunnerful shit I can do when 'tween jobs? =)
    Haha haha haha. You said tween...

  6. #6
    Shadeed's Avatar
    Shadeed is offline Associate Member
    Join Date
    Mar 2010
    Posts
    314
    Very useful, thanks!

  7. #7
    trikydik's Avatar
    trikydik is offline Senior Member
    Join Date
    Mar 2013
    Posts
    1,232
    Blog Entries
    2
    can you send me a copy?

  8. #8
    Rwy's Avatar
    Rwy
    Rwy is offline Productive Member
    Join Date
    Feb 2006
    Posts
    3,497
    Very awesome. Thanks. The amount of times friends ask me to calculate their macros now I can send them this instead of saying google it lol

  9. #9
    theseus is offline Junior Member
    Join Date
    Mar 2014
    Location
    London, United Kingdom
    Posts
    56
    that's great..may I have a copy too? will pm you with my email...cheers bro

  10. #10
    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 trikydik View Post
    can you send me a copy?
    Quote Originally Posted by Rwy View Post
    Very awesome. Thanks. The amount of times friends ask me to calculate their macros now I can send them this instead of saying google it lol
    Quote Originally Posted by theseus View Post
    that's great..may I have a copy too? will pm you with my email...cheers bro
    PM me your email addy..............




    btw, this is the results of what I ate yesterday. as you can see, 12 eggs provides a lot of fat, something I have to work on....

    Click image for larger version. 

Name:	Screen shot of summary of daily meals.PNG 
Views:	495 
Size:	77.2 KB 
ID:	150691

  11. #11
    Sicko's Avatar
    Sicko is offline Senior Member
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    1,571
    Quote Originally Posted by Times Roman View Post
    Mates,

    I spent more time on this today. This is an interactive spreadsheet that will calculate your macros for you:

    1) Macros per meal
    2) Macros per day
    3) It will calculate your TDEE
    4) It will calculate your minimum protein requirement per day in grams
    5) Allows for up to eight meals per day
    6) Does a variety of analytics including protein deficiency in grams and %, and including macro percentages
    7) includes almost 1,000 food items

    Take a look at the summary page:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	3299 
Size:	80.7 KB 
ID:	150670

    Yours free, just for being a member (gee, isn't that wonderful?)

    PM me and I will email it to you

    Fair enough?

    ---Roman
    Hey TR I think I PM'd you but it has been a minute so I don't even know if I did it right.
    Let me know if you got it.
    Great job on the spreadsheet BTW.

  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 Sicko View Post
    Hey TR I think I PM'd you but it has been a minute so I don't even know if I did it right.
    Let me know if you got it.
    Great job on the spreadsheet BTW.
    thanks mate!

    yes, I got it

    ---Roman

  13. #13
    Rwy's Avatar
    Rwy
    Rwy is offline Productive Member
    Join Date
    Feb 2006
    Posts
    3,497
    Thanks Roman got it

  14. #14
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    any time mates!

  15. #15
    AZGOLDSMEMBER86's Avatar
    AZGOLDSMEMBER86 is offline Senior Member
    Join Date
    Apr 2010
    Location
    AZ
    Posts
    1,157
    Blog Entries
    1
    Thank TR as always you da best

  16. #16
    Othello's Avatar
    Othello is offline Member
    Join Date
    May 2006
    Location
    Lebanon
    Posts
    524
    thanks mate. it looks great.

    heading for baghdad on assignment on monday. will be using it there since its canteen food and no room to cook my own meals. will keep you posted as i will be comparing to my fitness pal application...

    again thanks for the effort mate.

  17. #17
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    for those that are interested, just pm me and I will send.

    btw, I'm constantly revising, so ok to ask for revision 2.0

    here is what yesterday's summary and detail pages look like

    Click image for larger version. 

Name:	Meal Summary.PNG 
Views:	1594 
Size:	111.0 KB 
ID:	150727

    Click image for larger version. 

Name:	Meal 1.PNG 
Views:	348 
Size:	23.1 KB 
ID:	150728

    Click image for larger version. 

Name:	Meal 2.PNG 
Views:	257 
Size:	19.4 KB 
ID:	150729

    Click image for larger version. 

Name:	Meal 3.PNG 
Views:	212 
Size:	21.3 KB 
ID:	150730

    Click image for larger version. 

Name:	Meal 4.PNG 
Views:	224 
Size:	17.6 KB 
ID:	150731

    There are over 900 food items. Even then, I'm still adding food items daily. But to do so requires a certain amount of Excel "savvy" as all meal tabs need to be mirror images. And since not everyone is at the same skill level, trying to decide the best and easiest way to do this for the lay person.

    So this is still a work in process................
    cheers0323 likes this.

  18. #18
    Lunk1's Avatar
    Lunk1 is offline aka "JOB"
    Join Date
    Mar 2012
    Location
    METHAMERICA
    Posts
    16,396
    You guys realize that after he receives you email addresses you will be getting blown up with requests to purchase advocare and amway products. I think he sells Kirby vacuum cleaners as well

  19. #19
    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 Lunk1 View Post
    You guys realize that after he receives you email addresses you will be getting blown up with requests to purchase advocare and amway products. I think he sells Kirby vacuum cleaners as well
    actually, time share properties in the florida flood zones at a premium price............! =)

    ........actually, I just delete the emails, unless there is some kind of ongoing conversation

  20. #20
    ppwc1985's Avatar
    ppwc1985 is offline Productive Member
    Join Date
    Jun 2012
    Location
    CT
    Posts
    1,928
    Thks TR

  21. #21
    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 ppwc1985 View Post
    Thks TR
    welcome.

    let me know how it works out for you. if you can see areas that need improvement. Especially in the user interface areas. This will be an evolving tool, as users will be adding food items on the fly. For this to work best, all the food tabs should probably be mirror images. I've got a variety of ideas I'm kicking around for improvements, but I need time to consider the degree of difficulty this will have on the users.

    ---Roman

  22. #22
    DontTaseMeBro is offline Member
    Join Date
    Sep 2013
    Location
    Texas
    Posts
    912
    looks great. sending a PM now. That would really make my life better. i'm still using a notebook and hand calculator.

  23. #23
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    it sure as shit does make it easier. less up front planning. and it allows you to track what you eat on the fly. it also tells you how much more you need to eat by the end of the day in a variety of categories

  24. #24
    ppwc1985's Avatar
    ppwc1985 is offline Productive Member
    Join Date
    Jun 2012
    Location
    CT
    Posts
    1,928
    Quote Originally Posted by Times Roman
    welcome. let me know how it works out for you. if you can see areas that need improvement. Especially in the user interface areas. This will be an evolving tool, as users will be adding food items on the fly. For this to work best, all the food tabs should probably be mirror images. I've got a variety of ideas I'm kicking around for improvements, but I need time to consider the degree of difficulty this will have on the users. ---Roman
    will do, could we see you designing an app? I use my phone for everything.

  25. #25
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    I can do pretty much anything in Excel........

    ..........what's an app? =)


    apps on a phone require different programming skills, although the programming logic would be identical. If there were a phone app programming language "Wizard" I'd be willing to learn. I have the time since I find myself 'tween (ya, that one's for you LB) jobs right at the moment. Any recommendations or ideas?

    (I've programmed quite a few excel spread sheets over the years. This food macro spreadsheet is actually pretty simple comparatively speaking. I created one for a business owner that took over six months to design and create.)

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

  27. #27
    j2048b is offline Associate Member
    Join Date
    Mar 2012
    Posts
    250
    Tr, sent ya a pm for a copy! Hope all is well w u!

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

    Calculator improvements

    Today, I added an "All Days" tab that keeps track of the calories consumed per day with an overall average % broke out by macro type:

    Click image for larger version. 

Name:	All days.PNG 
Views:	374 
Size:	10.5 KB 
ID:	150753

    it's still a work in process. It will require the operator to do a little leg work, but I'm still working on automating this as much as possible.

    Additionally, i'll be trying to add a Glycemic Index broke out by food type, a Glycemic Value, and an average burn time.

    If there are other things you would like to see, just let me know. I'm 'tween jobs and have some time I can spend on these little activities.

    ---Roman

  29. #29
    DrewZ's Avatar
    DrewZ is offline Productive Member
    Join Date
    Nov 2013
    Location
    Half Nattyville
    Posts
    1,308
    This is pretty great Roman, if we could combine it with the app I use on my phone it would be the ULTIMATE macro calc!

  30. #30
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,383
    ^ don't know the programming language for the apps on the phone.

    find a translater for me and i'll make it happen. or even a book on the programming language

  31. #31
    DrewZ's Avatar
    DrewZ is offline Productive Member
    Join Date
    Nov 2013
    Location
    Half Nattyville
    Posts
    1,308
    Android: Android SDK | Android Developers
    ipad/iphone: https://developer.apple.com/ipad/sdk/

    One of my favorite features on the app I use is barcode scanner.
    I can use my phone to scan any food item or supplement I have, it pulls up its nutritional facts and allows me to select how much I consumed.

    Accessing that DB of nutritional facts would be a great resource for yours as it is.

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

    Thanks. I'll check it out later when things calm down at the homestead.

  33. #33
    eaglejave1 is offline New Member
    Join Date
    May 2014
    Posts
    1
    Is this macro chart still available

  34. #34
    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 eaglejave1 View Post
    Is this macro chart still available
    just pm me and i'll send you the latest and greatest............

  35. #35
    jsam's Avatar
    jsam is offline Junior Member
    Join Date
    Jul 2014
    Posts
    100
    Would like to get a copy of the calculator but don't have pm rights yet

  36. #36
    Daniel15443 is offline New Member
    Join Date
    Feb 2016
    Posts
    1
    pm'd you

  37. #37
    RaginCajun's Avatar
    RaginCajun is offline Pissing Excellence!
    Join Date
    Jan 2011
    Location
    Deep Down South
    Posts
    23,624
    Quote Originally Posted by Daniel15443 View Post
    pm'd you
    you don't have enough posts to PM him plus, haven't seen the old man around

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
  •