EngineerOnDemand

re: Excel Help - Suggestions

Posted by EngineerOnDemand on 4/21/24 at 10:48 am

You could probably do some powerful work with indirect and sumifs or xlookup.

Use indirect to find the tab you’re looking for and sumifs or xlookup to find the data you’re looking for.

re: Plantar Fasciitis - ish

Posted by EngineerOnDemand on 5/10/23 at 3:35 am

Sounds like you may have a neuroma. I was diagnosed with Morton’s neuroma and a simple steroid injection into the inflamed nerve dramatically reduced the pain .

Health/Fitness Board

re: Cities that are named wrong

Posted by EngineerOnDemand on 3/1/23 at 5:06 am

I’m still trying to find East Virginia on the map.

re: How many Engineers are on this board?

Posted by EngineerOnDemand on 2/22/22 at 9:36 am

Guilty…

re: Who has slept with a woman with an STD?

Posted by EngineerOnDemand on 12/19/20 at 8:36 pm

Fortunately penicillin cures all problems

-1

re: 1031

Posted by EngineerOnDemand on 4/19/19 at 9:00 pm

My personal accounts aren’t nearly as valuable as my retirement. If I can borrow against the retirement without much interest, that would be huge for me.

re: 1031

Posted by EngineerOnDemand on 4/19/19 at 8:58 pm

I may have to investigate this idea. I have a sizable amount in retirement with Morgan Stanley. Thanks.

1031

Posted by EngineerOnDemand on 4/19/19 at 7:13 pm

So kind of new to this topic since most of my real estate transactions have just been done through cash. Anyway, a great investment opportunity came up and my only way to get the down payment is to liquidate my personal stock investments (not retirement accounts). The plan is to sell down all of my stocks to convert to cash and use those funds for the down payment. My question becomes, should I prepare for a capital gains hit? Or can I claim this as a 1031 exchange? Or is really there a better process for this?

-1

re: gas lease proposal

Posted by EngineerOnDemand on 12/22/18 at 7:28 am

This is one of those truly risk reward properties. I think I would lean more to option 3 though. Mineral owners always make more money off the royalties as compared to the bonus. Take the cash because with today’s market, I highly doubt people are going to be aggressively developing any area. If you want more leverage push for no cost royalties. You can avoid taking on marketing, processing maybe even some operating expenses from the revenue stream they will “share” with you. Additionally, there really is no such thing as 28 acre spacing, you’re going to be pooled into a 640 acre unit and your royalties will be allocated this way. Remember, most wells drain 80-160 acres, so you may be getting your 240 “drained” without pay. Congrats on being one of the chosen ones to have valuable royalties - color me jealous.

re: Dexcom G5 mobile CGM

Posted by EngineerOnDemand on 6/16/17 at 11:33 am

My girlfriend is Type 1. She has used the Dexcom and swears by it. She can monitor trends so much better than before and adjusted her lifestyle due to it. She works at a diabetic clinic doing research, and still maintains it's the best option out there. She was able to even lower her A1C count and says she sees the same result in the patients for her studies. Good luck to your family member.

Health/Fitness Board

re: Separate Router/Modem or Google WiFi

Posted by EngineerOnDemand on 1/17/17 at 5:07 am

Not a tech guru, but if your coverage is less than 1000 ft2, you won't need any mesh network. Just get a router and modem, coverage will not be an issue.

re: Suicide Vest of Firecrackers

Posted by EngineerOnDemand on 12/17/16 at 9:20 am

At least he gained all that weight to protect his vitals before attempting this. Smart move.

re: Trump presidency and sexual harassment

Posted by EngineerOnDemand on 11/18/16 at 10:27 am

Everyone wins....

I did vote for him to answer your other question.

-1

re: Trump presidency and sexual harassment

Posted by EngineerOnDemand on 11/18/16 at 10:18 am

Or you're not getting out enough. Enjoy the free love once in a while.

Trump presidency and sexual harassment

Posted by EngineerOnDemand on 11/18/16 at 10:14 am

Ever since last weeks election, I can't go anywhere without numerous women grabbing at my genitals. It's been the greatest week of my life. Any fellow OTers encountering this issue?

-1

re: Excel Help

Posted by EngineerOnDemand on 11/11/16 at 3:31 pm

No problem...

I have a production profile: 100,90,85,70...

Integers are based on time: 0,0,0,1,0,0,8,6...

So, I would like to multiply the production profile by the integer and carry that continuous production profile, while also adding in the additional multiplied production profiles that start later in the sequence.

Excel Help

Posted by EngineerOnDemand on 11/11/16 at 3:06 pm

I have been instructed to minimize using VBA in a spreadsheet, yet I think this may be the only option...

So, I'm trying to multiply and sum a production profile (call it A2:A500) each time B2:B500 is an integer which changes over time. How can I sum these production values whilst still keeping the production profile continuous yet restarting at each new integer?

I hope this request is even legible...

re: Dog owners: best antibarking device?

Posted by EngineerOnDemand on 10/22/16 at 4:50 pm

I bought this same one for all my annoying arse neighbors' dogs. Amazon Prime at their doorstep. They get the hint.

I can't stand jerking off when barks are going on around me. Kills my confidence.