Page 2 of 2 FirstFirst 12
Results 41 to 59 of 59
Like Tree1Likes

Thread: Q&A: Roman's Macro Calculator - Open discussion

  1. #41
    Mp859's Avatar
    Mp859 is offline Knowledgeable Member
    Join Date
    Jul 2013
    Posts
    2,445
    Quote Originally Posted by jesse4466
    Maybe u can help me confirm my TDEE. A few calculators gave me different results. Not sure why that would be. Currently eating 3,800 calories, about 500 above what I think it my TDEE. 33 220 lbs 6'1 Excercise 5x wk
    The one I use said 2925. So you are quite a bit higher above maintenance.

  2. #42
    jesse4466's Avatar
    jesse4466 is offline Member
    Join Date
    Jun 2014
    Location
    Florida
    Posts
    506
    Quote Originally Posted by Mp859
    The one I use said 2925. So you are quite a bit higher above maintenance.
    Ok, yeah one said what you had then another said about 3300. So I used the higher one... But want to know which is more accurate.

  3. #43
    Mp859's Avatar
    Mp859 is offline Knowledgeable Member
    Join Date
    Jul 2013
    Posts
    2,445
    Quote Originally Posted by jesse4466
    Ok, yeah one said what you had then another said about 3300. So I used the higher one... But want to know which is more accurate.
    I would think the lower.

  4. #44
    Little_John's Avatar
    Little_John is offline Junior Member
    Join Date
    Jul 2013
    Location
    Florida
    Posts
    66
    I'm having trouble working the meals.. i can't figure out how to get the items that i have as meal 1 deleted and the list back up? i tried deleting to quantities but the banana and apples act are still in tan and on the page. maybe I'm over thinking this

  5. #45
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    first, each meal tab is a copy of the others. do not delete lines. Instead, just zero out the value, preferably to the null value. I'm assuming you have some understanding of how spreadsheets work?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	109 
Size:	25.8 KB 
ID:	153005

  6. #46
    Little_John's Avatar
    Little_John is offline Junior Member
    Join Date
    Jul 2013
    Location
    Florida
    Posts
    66
    I have a ok knowledge and I just clicked the box hit delete i didn't delete the formats or anything like that. but now all the items you have in that pick are there and no values. does it revert to the list where all the items to select from are green? like i have in meal 7 tab?

  7. #47
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    do you know how to operate a filter? look at the filter in the square box. click on it and you should see a variety of things. choose "select all" and all hidden rows will reveal themselves to you

    Click image for larger version. 

Name:	Capture.PNG 
Views:	115 
Size:	25.9 KB 
ID:	153006

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

  9. #49
    Little_John's Avatar
    Little_John is offline Junior Member
    Join Date
    Jul 2013
    Location
    Florida
    Posts
    66
    had to go to data and select filter from menu bar. I'm using a mac so it might have got lost in translation..it's working now and i appreciate the help, hope the backs doing better today.

  10. #50
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    so everything working ok on the calc?

    good. let me know if any other q's.

  11. #51
    Little_John's Avatar
    Little_John is offline Junior Member
    Join Date
    Jul 2013
    Location
    Florida
    Posts
    66
    yes sir just got done clearing out all the daily totals and getting it set up for my fatness… sláinte -John

  12. #52
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    anyone here excel proficient and has the time to show some how to insert rows so food can be added?

  13. #53
    lovbyts's Avatar
    lovbyts is online now Knowledgeable Member
    Join Date
    Apr 2008
    Posts
    30,248
    Put the courser between the two numbers or letters you want to add the row or cell, Right click, insert.

  14. #54
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    Quote Originally Posted by lovbyts View Post
    Put the courser between the two numbers or letters you want to add the row or cell, Right click, insert.
    I'm trying to have each tab a copy of all the others. there is a global way of doing this, by highlighting all the meals tabs, the doing work on one tab and all tabs will update. but if not excel savy, highly prone to fvcking up. I was getting hit up on a few PM's on how to do certain excel functions, more basic excel skills. I barely have time to come here in the AM and maybe an hour or so in the PM, not like it used to be when on permenant vacation between projects. So I was hoping someone could step up and help out with some basic excel questions when they come up. I can refer the pm'ers to come here and ask.

  15. #55
    lovbyts's Avatar
    lovbyts is online now Knowledgeable Member
    Join Date
    Apr 2008
    Posts
    30,248
    Excel use to be easier in a lot of ways. I took a couple excellent classes back in the day when I was getting my computer science degree.

  16. #56
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    I always considered myself an excel guru. helped pay my way through college creating excel models for companies. the formulas keep getting better. but then fvcking MS decided that after 97, they would change up things, and now many accountants have devolved to a certain extent trying to remember where shit is found. That was a huge bone head decision by MS to move around where functionality is located. Most accountants (the good ones) "think" in excel and can put together complex formulas almost as fast as they can type.

    the one I used to be great at pre Y2K was Access. But most companies don't use, so it's been years, and now skill set is pretty rusty

  17. #57
    lovbyts's Avatar
    lovbyts is online now Knowledgeable Member
    Join Date
    Apr 2008
    Posts
    30,248
    Exactly. That's what I am saying. Pre 2000 it was easy to make fields and calculations then they changed it and nothing worked right.

  18. #58
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    it still works the same. but now you have to hunt down where they put the shit. I debug a lot of spreadsheets made/used by others, and the "trace dependents/precedents" audit feature seems to keep moving around. This feature also helps debug circular references.

  19. #59
    Times Roman's Avatar
    Times Roman is offline Anabolic Member
    Join Date
    May 2010
    Location
    Back from Afghanistan
    Posts
    27,376
    Quote Originally Posted by jesse4466 View Post
    Maybe u can help me confirm my TDEE. A few calculators gave me different results. Not sure why that would be. Currently eating 3,800 calories, about 500 above what I think it my TDEE.

    33
    220 lbs
    6'1
    Excercise 5x wk
    you are correct. I estimate your TDEE to be 3300. Ignore BF%, as that is used more for LBM calc and determining max protein intake.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	205 
Size:	69.5 KB 
ID:	153607

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 6 users browsing this thread. (0 members and 6 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
  •