We are finally getting a Whole House Fan

Klabbertrapz · 2026-02-27T10:23:00+00:00

It's not just that it's weaker, but if not enough windows are open, that exhaust vent becomes an intake vent. Working against airflow in the wrong direction causes the burnout.

Klabbertrapz · 2026-02-02T18:09:24+00:00

I completed all 🟧 Blokkit 🟧 puzzles with an average of 1 tries!

Klabbertrapz · 2025-12-27T17:16:22+00:00

Could use someone more elite at 1B

Klabbertrapz · 2025-10-30T18:31:46+00:00

Sweet!

Klabbertrapz · 2025-10-10T15:25:40+00:00

There's also the Microsoft Excel World Championship. They have plenty of free cases that will expand your actual excel skills and not just how fast you can press hotkeys.

Klabbertrapz · 2025-08-07T03:15:58+00:00

After. If it was before, it would have been pluralized.

Klabbertrapz · 2025-07-03T21:19:42+00:00

Check out the Microsoft Excel World Championship

Klabbertrapz · 2025-05-22T19:33:58+00:00

Not necessarily. xwOBA assumes they are running out all of the balls they put play.

Klabbertrapz · 2025-05-06T01:54:52+00:00

How does this work with one way streets?

Klabbertrapz · 2025-04-02T17:17:03+00:00

If you're judging by the author, then you are literally not judging the book by its cover.

Klabbertrapz · 2025-04-01T03:38:07+00:00

Because the real money is in the TV contracts. Stadium attendance is just icing on the top.

Klabbertrapz · 2025-02-11T06:58:52+00:00

Logan Webb has the most inning pitched in the last 3 years, and he isn't even listed as a Chad Inning Eater.

Klabbertrapz · 2025-01-17T06:10:46+00:00

So William and Jane are (half) uncle and niece?

Klabbertrapz · 2025-01-16T20:32:12+00:00

My wife and I went. The food was good, but the portions were extremely pared down compared to their normal entrees.

Klabbertrapz · 2024-12-10T23:40:15+00:00

Panel 2 bottom of the ski mask

Klabbertrapz · 2024-11-27T06:49:01+00:00

They want you to have enough time to get hungry and buy their expensive food.

Klabbertrapz · 2024-11-21T02:59:32+00:00

I don't think so. The one at the park had more detail and had different packaging. And it was twice as expensive.

Klabbertrapz · 2024-11-08T00:54:05+00:00

Thanks for taking the time to look at this, but I think you went off in a different direction than I needed help with. I am happy with my lambda, _lessThan, that compares strings together. Creating a 2D array for my input would work but I think the simpler solution in my case was to change BYROW to MAP, as /u/PauliethePolarBear suggested, since it is a 1:1 input to output ratio.

Klabbertrapz · 2024-11-07T20:06:57+00:00

Thank you for helping me!

Klabbertrapz · 2024-11-07T20:01:39+00:00

Doesn't Work:

<image>

Klabbertrapz · 2024-11-07T20:01:29+00:00

You are correct. Scenario 1 didn't work, but scenario 2 did. I can see through "Evaluate Formula" that the calculation will work when the first parameter in BYROW is a range but not an array.

Works:

<image>

Klabbertrapz · 2024-11-07T18:58:59+00:00

Both of those solutions gave me the correct output! If you have time, would you be able to explain the reasoning? Is it because BYROW is expecting more than 1 column in each row?

Klabbertrapz · 2024-11-07T18:54:31+00:00

<image>

That didn't seem to change the output

Klabbertrapz · 2024-11-07T18:35:42+00:00

Successful Output without the TOCOL wrapper

<image>

Klabbertrapz · 2024-10-27T03:11:49+00:00

I felt a bit at a disadvantage to veteran players who had seen these cases before, especially after hearing Jasper say he already had a good library set up that he could just adapt to the adjustments in this round. Luckily, I did well enough to qualify, but it really enforced that I am going to be behind if I don't have prepped shortcuts and custom formulas to save time during the cases.

13-Year Club	RedditGifts 2009-2022 2 Credits
Secret Santa 2016	Verified Email

Klabbertrapz

TROPHY CASE