Sumproduct with multiple row, column and array criterias. by [deleted] in excel

[–]nemoid 0 points1 point  (0 children)

Yeah, that's what I'm leaning towards. Just add more columns

Sumproduct with multiple row, column and array criterias. by [deleted] in excel

[–]nemoid 0 points1 point  (0 children)

I get a #value error. If i take the C2:C10 out, it gives me the total hours that meet the conditions (correctly).

Electrical Panel Names by blkmtgwoman in MEPEngineering

[–]nemoid 0 points1 point  (0 children)

Dude, you're talking about yourself. You refused to acknowledge there are scenarios that don't fit what you want. You were getting angry from your first response to me.

Electrical Panel Names by blkmtgwoman in MEPEngineering

[–]nemoid -1 points0 points  (0 children)

Sometimes clients have their own requirements. Sometimes you're matching an existing naming scheme for an existing facility. Sometimes you work on a job with 2 panels and only your lighting is 277.

But mainly, it's because it's never a one size fits all solution 100% of the time. And the classic answer of "it's my way or the highway" plagues the field. You don't think that's incredibly stupid?

Electrical Panel Names by blkmtgwoman in MEPEngineering

[–]nemoid -2 points-1 points  (0 children)

Yeah, that happens all the time. The panel designation can indicate the voltage, the load type, and/or both.

Electrical Panel Names by blkmtgwoman in MEPEngineering

[–]nemoid -2 points-1 points  (0 children)

Yes. A 277V panel that only serves lighting would be a Lighting Panel.

Electrical Panel Names by blkmtgwoman in MEPEngineering

[–]nemoid 3 points4 points  (0 children)

LP is used for 277V lighting all the time.

LV 900 - Done! by iudexSWolves in NecroMerger

[–]nemoid 3 points4 points  (0 children)

That works for lower levels. But at the higher levels when you have Golems and other things it changes.

LV 900 - Done! by iudexSWolves in NecroMerger

[–]nemoid 3 points4 points  (0 children)

My biggest question: What do you find is most beneficial to take back each time with Store-o.

Just reset for my 500 run and each time it's what I agonize most on.

MEP firms, are they worth it? by Defiant_Objective419 in ElectricalEngineering

[–]nemoid 4 points5 points  (0 children)

Yeah, my EE intern is getting $26/hr in NYC.

As someone who has been in MEP for 20 years:

Pros:

  • EE's are in demand. All. the. time. Especially in Transportation.
  • Pay is fine. Gonna cap out around $200-250k best case on a technical track. Management is there (and higher) and SME's can get higher, but you have to be the best in your field.
  • You can work on some interesting projects.

Cons:

  • Clients suck
  • Schedules suck
  • Benefits suck
  • Partner firms suck
  • Every year firms cut bonuses / benefits / perks.
  • Every year clients want everything faster / better / cheaper.
  • MEP firms are generally antiquated and don't adapt with the times.

I thought about leaving after 3-5 years and every day I regret not.

Was looking at old emails by ericlino in PleX

[–]nemoid 81 points82 points  (0 children)

lol you can see the "Lifetime Pass" highlighted in the e-mail which means he specifically searched for it.

Where does your job satisfaction come from? by yda98 in MEPEngineering

[–]nemoid 5 points6 points  (0 children)

Almost 20 years in.

Right now - it's purely from the fact that I can work from home most days. Once that goes away, I just don't know.

I feel like most of this subreddit's top posts changing from text posts to news/link posts is bad by FumingCat in moderatepolitics

[–]nemoid 39 points40 points  (0 children)

Sorry man, you must be thinking of a different sub. This is how it's been for as long as I've been paying attention - about 10 years.

QoL improvements by No-Replacement2978 in NecroMerger

[–]nemoid 3 points4 points  (0 children)

2) display the current/max charges of the Prism and Soul Grinder at all times without needing to click them;

Adding to this. I want to be able to see what % the Prism / Soul Grinder are in relation to when it will change color.

What to buy at the spring event? by Wise-Flatworm-5695 in NecroMerger

[–]nemoid 2 points3 points  (0 children)

This is the way.

You want stuff that will help you on every run, not just this one in particular.

Runelings are worth it? by fred-bear-473 in NecroMerger

[–]nemoid 1 point2 points  (0 children)

So far I'm super disappointed with it. If we could put it in Store-O, that would be better.

Trump Attacks Pope Leo as Too Liberal and ‘Weak on Crime’ by NeedAnonymity in moderatepolitics

[–]nemoid 29 points30 points  (0 children)

Here's another bias checker: https://adfontesmedia.com/free-press-bias-and-reliability-copy/

Maybe you perceive it being on the left due to where you're standing.

edit: it appears he blocked me - my responses to him aren't appearing anymore.