Useless Conversation

[RhyssaFireheart]

All right, Ex-hell question time.

For the life of me, I cannot remember a formula to use, so I'm coming here.  I'm calculating percentages for some historical data.  Basically, I'm trying to figure out how accurately my PMs have been predicting their projects versus what is actually entered into project server.  The issue is that I'm tired of seeing #DIV/0! in a bunch of my cells because there wasn't any data or the amount was 0 in one of the cells for whatever reason.  I used to know a formula which would just return a "blank" cell and not put the #DIV/0! in it but I can't remember it, can't seem to ask the right question of online help and don't want to wait until I get home tonight and can dig into my old work files to see what the formula was.

So, any ideas based on what I put above?

[Merusk]

Are you thinking of  Iferror() ?

[Yegolev]

Couldn't you just buy some of the capsular probiotics that are offered?  That seems like a more appetizing solution.

I have these.  I don't know which of these small organisms might help me, if any.  I also have a prescription.  Basically we don't know what is going on, need to do more testing.  Seems to be related to eating at restaurants, though.  Last night I ate strawberry-banana pancakes and two mouthfuls of hash browns, then had some bloating and whatnot.  Curious if there's some common oil or other ingredient used in restaurants.  Or perhaps it's stress and I don't like wrestling a seven year old or being rushed by a 37-year-old while trying to enjoy a meal.

Edit to say that $135 for a duplicate key from a Nissan dealer is a ripoff.

[Yegolev]

Food :: Organism
Yogurt :: Lactobacillus bulgaricus, Streptococcus thermophilus; optionally Lactobacillus acidophilus, Lactobacillus bifidus, Lactobacillus casei
Natto :: Bacillus subtilis
Kimchi :: Lactobacillus kimchii plus various other Lactobacillus
Sauerkraut :: Various during three fermentation phases, final phase contains Lactobacillus brevis and plantarum
Miso :: Fungus koji, or Aspergillus oryzae, which is also used to make sake.
Tempeh :: Rhizopus oligosporus, which produces an antibiotic that suppresses Staphylococcus aureus.
Kefir :: Lactobacillus kefiranofaciens, Lactobacillus bulgaricus

[Paelos]

All right, Ex-hell question time.

For the life of me, I cannot remember a formula to use, so I'm coming here.  I'm calculating percentages for some historical data.  Basically, I'm trying to figure out how accurately my PMs have been predicting their projects versus what is actually entered into project server.  The issue is that I'm tired of seeing #DIV/0! in a bunch of my cells because there wasn't any data or the amount was 0 in one of the cells for whatever reason.  I used to know a formula which would just return a "blank" cell and not put the #DIV/0! in it but I can't remember it, can't seem to ask the right question of online help and don't want to wait until I get home tonight and can dig into my old work files to see what the formula was.

So, any ideas based on what I put above?

CPA/Financial modeling dork to the rescue!

=IF(ISERROR(H19), " ",H19) - Formula will return a blank if cell is in error, otherwise it will return the value of the cell H19

[RhyssaFireheart]

By Jove! I think that's done it!  Thanks, Paelos!

[Lantyssa]

I have these.  I don't know which of these small organisms might help me, if any.  I also have a prescription.  Basically we don't know what is going on, need to do more testing.  Seems to be related to eating at restaurants, though.  Last night I ate strawberry-banana pancakes and two mouthfuls of hash browns, then had some bloating and whatnot.  Curious if there's some common oil or other ingredient used in restaurants.  Or perhaps it's stress and I don't like wrestling a seven year old or being rushed by a 37-year-old while trying to enjoy a meal.

1) Wheat is a pretty common ingredient.
2) Grease is also common.
3) Getting old is also frequent.

Try to eliminate all those from your diet and see if you improve.

[Rasix]

I get to play family chauffeur for the next 3 months. Fantastic.  At least I get bear this in a new car. 

 

[Paelos]

By Jove! I think that's done it!  Thanks, Paelos!

No problem! Excel is the lifeblood of the industry.

[Sand]

I get to play family chauffeur for the next 3 months. Fantastic.  At least I get bear this in a new car. 

 

If you're a parent isnt that a full time position?

[ghost]

1) Wheat is a pretty common ingredient.

I would second this.  I had issues forever with gastroesophageal reflux, to the point that I had to take a prilosec every day to even maintain a semblance of comfort.  I also had some of the other issues that go with celiac.  I found an article the other day though (and I'm sorry, but for the life of me I can't find it right now) talking about how people that have gluten sensitivity don't respond the same way to the gluten that celiacs do, thus the testing doesn't come out the same.  I switched off of wheat and feel like a million bucks now.  It's worth a shot to cut it out of the diet because it's relatively easy to do now. 

[Merusk]

While it's gratifying to know my 12 year old still listens to her old man, I'd appreciate it more if she didn't prove it by repeating one of my rants about fatass Americans and their need to have foodservice in every store, much less shopping center, while we were in the middle of one such store.  Loudly.

[Lantyssa]

I'm sure she'll be coming up with ways to embarrass you in public while proving she doesn't listen in a few short years.

[Paelos]

While it's gratifying to know my 12 year old still listens to her old man, I'd appreciate it more if she didn't prove it by repeating one of my rants about fatass Americans and their need to have foodservice in every store, much less shopping center, while we were in the middle of one such store.  Loudly.

Teaching your kids to not becoming fatass Americans is a good trait. Also, teaching them not to avoid dancing around the truth because it's uncomfortable is a smart thing.

Kudos to you sir!

[Sand]

Agreed kudos to her and you both!

[rattran]

So, after spending 2 months in Arizona, I get to spend another month without internet near Atlanta.

sux, maybe I can at least but Yeg a beer and watch him get sick.

[schild]

I was wondering where the hell you'd been.

[rattran]

In the desert, with spotty 3g and no wifi to steal.

[Fraeg]

A buddy of mine from high school just passed away due to colon cancer.  He was 40.

They are mighty unpleasent but if you are getting up in age get a damn colonoscopy.  Had one 2 years ago, not something to write home about, but fuck an ounce of prevention......

[Paelos]

Sorry Fraeg, it's terrible to lose a friend to cancer.

I had a colonoscopy just last month, and it's really not that bad. I agree with you, and I encourage everyone to get one done when you hit 30 if you have digestive issues. They really aren't that bad except for the 24 fasting and drinking the stuff that cleans out your system the night before. The actual procedure happens while you are totally conked out, takes like 20 minutes, and you wake up feeling fine.

[Fraeg]

Sorry Fraeg, it's terrible to lose a friend to cancer.

I had a colonoscopy just last month, and it's really not that bad. I agree with you, and I encourage everyone to get one done when you hit 30 if you have digestive issues. They really aren't that bad except for the 24 fasting and drinking the stuff that cleans out your system the night before. The actual procedure happens while you are totally conked out, takes like 20 minutes, and you wake up feeling fine.

thanks.

I always tell people "it was a very draining experience"

[Rasix]

In the desert, with spotty 3g and no wifi to steal.

You forgot my coffee.

[bhodi]

They really aren't that bad except for the 24 fasting and drinking the stuff that cleans out your system the night before.

This is something I've always wondered about; there are tons of pseudoscience "cleansing" diets, enemas, all that sort of shit. Why don't they just get a colonoscopy? Then, you get REAL MEDICINE to roto-rooter your insides.

[Paelos]

I called it, "Spring Cleaning" 

[Lantyssa]

This is something I've always wondered about; there are tons of pseudoscience "cleansing" diets, enemas, all that sort of shit. Why don't they just get a colonoscopy? Then, you get REAL MEDICINE to roto-rooter your insides.

Compared to the taste of a swiffer, all the pseudoscience is more tolerable.  I gag thinking about the taste of that stuff.  (For real.  I'm gagging right now.)

[Morat20]

thanks.

I always tell people "it was a very draining experience"

My wife had one awhile back. The nurse there offered all sorts of practical advice the doctor failed to. Didn't do her any good (The nurse was prepping her for the colonoscopy, and the advice was for the preceding "fun" 24 hours as the meds they give you force your body to EJECT EVERYTHING YOU'VE EVER EATEN.)

It felt a little awkward passing that advice on to my Dad for his, but he -- in a round-about fashion -- admitted it certainly made things more tolerable.

[Yegolev]

At least I get bear this in a new car.

what

[Ironwood]

"The shittiness of this situation is made manifestly better by the addition of a new automobile in my life."

[Rasix]

I'll be less cryptic.

Wife had a seizure.  She is now not allowed to drive for 3 months.  So I get to drive everywhere, including driving her back and forth to work.  I no longer get to skip going shopping.  I get to accompany her to every appointment, where I'm going to have to bring my son and keep him happy in all sorts of locations.  2 year olds are not the most patient of beings.

But I just got a very nice car, so there's that.  Still highly annoying situation.

[ghost]

That sucks, man.  I hope she's okay. 

[Nebu]

I'm sorry Rasix.  Hope all goes well. 

[HaemishM]

You'll be amazed at how commonplace that will seem after 3 months. As someone who has a loved one with a seizure condition, it can be rough when you first have to deal with the consequences, but it gets better. Sort of.

[Morat20]

Texas is, I think, six months. Except there is no actual verification. Nothing goes on your license, no law enforcement or state database is notified, nada. It's totally on the honor system.

*Rolls eyes*.

Good luck with your wife, Rasix. Seizures can be scary -- especially the first few. Here's hoping it's something simple -- an infection or allergy that lowered her threshold.

[Fraeg]

1) Wheat is a pretty common ingredient.

I would second this.  I had issues forever with gastroesophageal reflux, to the point that I had to take a prilosec every day to even maintain a semblance of comfort.  I also had some of the other issues that go with celiac.  I found an article the other day though (and I'm sorry, but for the life of me I can't find it right now) talking about how people that have gluten sensitivity don't respond the same way to the gluten that celiacs do, thus the testing doesn't come out the same.  I switched off of wheat and feel like a million bucks now.  It's worth a shot to cut it out of the diet because it's relatively easy to do now. 

pretty much ditto for me, if I eat wheat or drink beer I *know* within minutes that I am eating something my body doesn't like.  I am not as good about it as I once was.  But when I was a anti-wheat nazi I felt so much better,  I fell of the wheat horse so to speak and my body has been letting me know.   So back to Captain *wheat is evil*

[Furiously]

Someone really needs to make a decent wheatfree bread.