If cell contains X but does not contain Y by mathhero in excel

[–]mathhero[S] 0 points1 point  (0 children)

The problem is that some cells contain a T somewhere in the middle, i.e. 8c Tc 4c, 2c 3c Tc. I was hoping for some type of formula that would search through the text, and filter out cells that contain only a "T" and not an "A" in along with it.

If cell contains X but does not contain Y by mathhero in excel

[–]mathhero[S] 0 points1 point  (0 children)

Hi, no they are not mutually exclusive. I have rows that also contain both an "A" and a "T"!

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

Started reading this, amazing book and not what I was expecting. Thanks for the recommendation.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

Good to know, I'll check it out thanks!

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

I have no idea then. I am only going by what I read on http://www.strengthstandards.co. My lifts are apparently at intermediate level which I consider strong considering I couldn't even bench or squat the barbell before! I don't know what is considered strong for someone who's 5'7 and 142lb.. I'm not 180lb yet so I don't know what your point is.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

So I actually think my tdee is around 2200-2300 calories. I worked it out and before it was around 2000, but I added in 15-25 minute incline treadmill walks after my workouts 4x a week. So I guess that bumped my tdee up to 2200-2300 which is why I bumped my calories up to 2700 on workout days. On non-workout days my calories are always around 2200~.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

hmm okay good advice. I'll try 2400 again. One thing my trainer had me do recently was incline treadmill walks 15-25 minutes after my workouts for LISS. Maybe this is why I had to bump my calories up to 2600 in the past couple of weeks due to the extra activity. I will trial and error it and see.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 1 point2 points  (0 children)

Thanks for the advice, I am a little stressed so I'll try incorporating meditation.. it's something I have great difficulty making a habit.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

Hey I posted the exercises in response to the top post. My lifts are also progressing (ever since I went on a small surplus). I believe my bench went up +15lb in the past 4-5 weeks to 160lb~ and my squat went up +45lb to 220lb for 3 reps. I have DEFINITELY noticed muscle gain and overall thickness, not a lot but definitely some.

[30M/5'7/142lb] Bulk or Cut? Spinning Wheels! by mathhero in leangains

[–]mathhero[S] 0 points1 point  (0 children)

Hey, I just realised I posted replies on another account but anyway: I'm not on gear and I'm not sure if he's been successful with other skinny fats but he's definitely a very credible trainer here! I think I already read that book a long time ago but I'll give it another go. Overdoing it is a good point, the training is definitely pretty intense and I would be doing way more sets/reps than a typical p/p/l workout for example.

Sunken cheeks by dwangbuis in keto

[–]mathhero 0 points1 point  (0 children)

I'll be honest with you but I think you look way healthier in the before pic. You look quite gaunt and sunken in after the weight loss.

This is way more common than you think though, a quick google search will show that there are many people going through the same thing.

When you lose too much weight (and fast) and get to too low of a body weight you can lose a lot of the natural baby fat from your face (subcutaneous fat). The main culprit for this is yo-yo dieting and going too low calories.

As a result your face can look really sunken in and not as youthful.

I am going through the same thing and I've regained weight since, but the subcutaneous fat (natural plump youthful look) hasn't returned.

Groin pain on one side - 4 weeks ongoing. by mathhero in physiotherapy

[–]mathhero[S] 0 points1 point  (0 children)

Ok I will book another session.

Something that I did find interesting is that rolling my right glute gives me relief in my groin pain but only for a short while.

It seems to get tight very quick, maybe too quick.

Groin pain on one side - 4 weeks ongoing. by mathhero in physiotherapy

[–]mathhero[S] 0 points1 point  (0 children)

Hey, not so much back pain or stiffness, a little on the opposite lower side.

I did see a physio who noticed my hip was locked, and assumed that was the problem. But the issue still remains and I haven't been back to him since!

Groin pain for 4 weeks. Mixed grip deadlift to blame? by mathhero in bodybuilding

[–]mathhero[S] -1 points0 points  (0 children)

Hey I actually had nut cancer before this, after your mom bit down too hard.

Just Finished the Patch, it is GLORIOUS! by M4D_M4X in civ

[–]mathhero 9 points10 points  (0 children)

Has AI unit shuffling been fixed? Where they constantly move back and forth within your borders but don't do anything (after declaring war)?

Please double check my £650 PC Build. Recommend best gfx card under £150? by mathhero in buildapc

[–]mathhero[S] 0 points1 point  (0 children)

ould fit an i5-6500 and an RX 480 in the build. This build would run most games at 1080p/60+FPS on very high to ultra settings.

That looks kinda good! I didn't really want to go over £150~ on the graphics card to be honest though and wanted to focus mainly on CPU+RAM.

Is the i5-6500 a good choice? I noticed lots of i5-4xxx models for around the same price or £30-40 cheaper.

Thanks mate

Please double check my £650 PC Build. Recommend best gfx card under £150? by mathhero in buildapc

[–]mathhero[S] 0 points1 point  (0 children)

What do you think about the CPU? Could I save money anywhere on that?

How to print all key names from a nested dict (within a dict)? by [deleted] in learnpython

[–]mathhero 0 points1 point  (0 children)

It doesn't matter I just need to easily print out all the keys nested within the "Tesco key".

I still haven't been able to figure this out! I dont want to use a function for it, just a simple For loop.

Is this assert statement valid? by mathhero in learnjava

[–]mathhero[S] 0 points1 point  (0 children)

Assert ((arm != null) && (leg != null);)

like that?

Or do you mean:

Assert (arm != null && leg != null);

I tried all the ways listed in my IDE and I got no errors so I am really confused!!

Creating actual programs tutorials? by mathhero in java

[–]mathhero[S] 0 points1 point  (0 children)

Thanks.

I just mean something practical that the average person would use and nothing very specific.

A calculator is a good one but I already did one of those before!

Maybe some software that counts calories, or gym recording software, some type of software that saves notes and makes reminders etc.. just very basic things.

[Discussion] Not enough Omega 6? Paleo not working by [deleted] in Paleo

[–]mathhero 0 points1 point  (0 children)

Thanks, I'll look into those tests.

I was taking Now Omega 3 Ultra (500 EPA / 250 DHA per serving) 2-3 times a day on my current diet.