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

**Mp859** · 08-21-2014, 10:45 AM

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.

**jesse4466** · 08-21-2014, 11:34 AM

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.

**Mp859** · 08-21-2014, 11:47 AM

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.

**Little_John** · 09-21-2014, 02:21 PM

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

**Times Roman** · 09-21-2014, 02:27 PM

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: 113
Size: 25.8 KB
ID: 153005

**Little_John** · 09-21-2014, 02:37 PM

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?

**Times Roman** · 09-21-2014, 02:47 PM

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: 118
Size: 25.9 KB
ID: 153006

**Times Roman** · 09-21-2014, 02:49 PM

learn more how to use filters here

Filter data in a range or table - Excel

How to Use Filters in Microsoft Excel | eHow

**Little_John** · 09-21-2014, 02:52 PM

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.

**Times Roman** · 09-21-2014, 02:55 PM

so everything working ok on the calc?

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

**Little_John** · 09-21-2014, 03:12 PM

yes sir just got done clearing out all the daily totals and getting it set up for my fatness… sláinte -John

**Times Roman** · 10-13-2014, 10:38 PM

anyone here excel proficient and has the time to show some how to insert rows so food can be added?

**lovbyts** · 10-14-2014, 04:51 AM

Put the courser between the two numbers or letters you want to add the row or cell, Right click, insert.

**Times Roman** · 10-14-2014, 07:59 AM

Originally Posted by lovbyts

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.

**lovbyts** · 10-14-2014, 10:38 AM

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.

**Times Roman** · 10-15-2014, 07:55 AM

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

**lovbyts** · 10-15-2014, 10:59 AM

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.

**Times Roman** · 10-16-2014, 07:46 AM

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.

**Times Roman** · 10-31-2014, 08:01 AM

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

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.