Results 1 to 37 of 37

Thread: The Macro Calculator: Deluxe Version

  1. #1
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376

    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:	3375 
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
    Join Date
    Mar 2004
    Posts
    20,517
    Great job roman..... Damn.

  3. #3
    Right on.

  4. #4
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    Apr 2008
    Posts
    30,265
    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
    Join Date
    Mar 2010
    Posts
    314
    Very useful, thanks!

  7. #7
    Join Date
    Mar 2013
    Posts
    1,232
    can you send me a copy?

  8. #8
    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
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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:	531 
Size:	77.2 KB 
ID:	150691

  11. #11
    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:	3375 
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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    Feb 2006
    Posts
    3,497
    Thanks Roman got it

  14. #14
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    any time mates!

  15. #15
    Join Date
    Apr 2010
    Location
    AZ
    Posts
    1,157
    Thank TR as always you da best

  16. #16
    Join Date
    May 2006
    Location
    Lebanon
    Posts
    523
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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:	1643 
Size:	111.0 KB 
ID:	150727

    Click image for larger version. 

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

    Click image for larger version. 

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

    Click image for larger version. 

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

    Click image for larger version. 

Name:	Meal 4.PNG 
Views:	277 
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................

  18. #18
    Join Date
    Mar 2012
    Location
    METHAMERICA
    Posts
    16,397
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    Jun 2012
    Location
    CT
    Posts
    1,926
    Thks TR

  21. #21
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    Jun 2012
    Location
    CT
    Posts
    1,926
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    oops. wrong thread

  27. #27
    Join Date
    Mar 2012
    Posts
    249
    Tr, sent ya a pm for a copy! Hope all is well w u!

  28. #28
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376

    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:	409 
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
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    ^ 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
    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
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    ^ Bookmarked

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

  33. #33
    Is this macro chart still available

  34. #34
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    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
    Join Date
    Jul 2014
    Posts
    100
    Would like to get a copy of the calculator but don't have pm rights yet

  36. #36
    pm'd you

  37. #37
    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
  •