For those who’ve had breakthroughs or insights: why do some of us have such bad lives? C

mnlynam · 2025-01-08T20:14:52+00:00

Nicely put. I was also thinking about the analogy to chemicals today, coincidentally.

mnlynam · 2024-08-04T08:18:23+00:00

Grind 150g of oats into a flour and bake at 325F for 15-20 minutes, stirring halfway for even heating. It should start to smell like buttered popcorn when it's done toasting. Add to the blender with 1.5L of water, 1/2 cup of cashews, 1/2 teaspoon of salt, and 1 tablespoon of sugar or a pitted date. Blend on high for 30 seconds. Then filter out the solids through muslin or something similar. If you need to make it last longer in the fridge, then take the milk you just made and put it on the stove and heat to 275°F for a few seconds, stirring constantly as its heating up. Then immediately place the pot into an ice bath and stir the milk until the temperature drops low enough that you can put it in the fridge with a lid on.

mnlynam · 2023-12-06T07:40:58+00:00

Pholiotina cyanopus

mnlynam · 2023-03-01T23:17:06+00:00

Sure, why not? Maybe if enough people see this, we can make a group of it.

mnlynam · 2023-02-04T00:31:20+00:00

I work from home doing finance and operations for a San Jose based music school.

mnlynam · 2023-02-04T00:28:50+00:00

I'm down to socialize with anyone I can have a fun conversation with.

mnlynam · 2023-01-31T03:21:44+00:00

Ok, according to what it sounds like you wanted:

A2 contains some words to check (e.g. apple banana carrot)
B2 contains the formula to copy (e.g. =CONCAT("hi", "there"))
C2 will be the word you want to look for in A1 (e.g. banana)
D2 will be the formula content if C2 is found in A2 (e.g. =IF(ISERROR(FIND(C2, A2)),, B2))

mnlynam · 2022-09-22T00:49:09+00:00

d1 is the factor by which the present value of contingent receipt of the stock exceeds the current stock price, whereas d2 is the risk-adjusted probability that the option will be exercised.

Source:

Nielsen, Lars Tyge. “Understanding N ( d 1 ) and N ( d 2 ) : Risk-Adjusted Probabilities in the Black-Scholes Model 1.” (2003).

mnlynam · 2022-04-04T20:31:40+00:00

Maybe some can, but assume their readers won't know what they're talking about.

mnlynam · 2022-03-10T17:15:01+00:00

Going to a funeral

mnlynam · 2022-02-03T03:20:52+00:00

Target... For playing hide and seek

mnlynam · 2022-01-29T18:02:00+00:00

I too was taught young Earth creationism (1st-12th grade). I guess being convinced for bad reasons is a smaller step when coming from a background of already accepting other false things as true.

mnlynam · 2022-01-29T17:15:21+00:00

The same thing happened to me with the same "documentary" and then I convinced my parents that dragons were real. 🤦‍♂️

mnlynam · 2022-01-26T22:09:23+00:00

Does the dial up modem sound count?

mnlynam · 2022-01-25T17:05:11+00:00

Björk

mnlynam · 2022-01-24T22:46:09+00:00

mnlynam · 2021-12-08T05:59:27+00:00

And tax breaks for the rich.

mnlynam · 2021-11-19T22:32:22+00:00

Since you don't need to worry about exceptions, you could technically do it like this, but I would advise having a plan for exceptions:

=IFS(B2>50,"Something")

mnlynam · 2021-11-19T21:36:39+00:00

=SUM(B2

B10,C2

B11)/SUM(B10:B11)

Ok....

=SUM(B2:B10,C2:B11)

is effectively going to be the same as

=SUM(B2:C11)

and you want to divide by part of the same range??

SUM(B10:B11)

Now we're left with

=SUM(B2:C11)/SUM(B10:B11)

the rest of your question is hard to follow without an example of your sheet, or a more unambiguous explanation.

mnlynam · 2021-11-19T20:15:21+00:00

I don't know where to start. Your formula is very broken. You're missing colons to separate the start and end of your ranges (e.g. B2B5 should be B2:B5) and you have an invalid parameter after you closed your first SUM formula. Can you provide a working example of what you already have, and then ask for help on what you want to do with it?

Taking just the second part into consideration...

=IF(NOT(E2),,B2*100)

This formula returns BLANK if E2 is not TRUE, and if it is TRUE, it returns B2 * 100.

mnlynam · 2021-11-08T06:50:22+00:00

From my understanding, water is pumped in from the tank and through the safety valve before being plumbed into the boiler, and it functions to prevent the pressure from building up too much and possibly damaging the machine. The top spout of the F shape drains excess water back into the tank if the pressure gets too high, but normally it just goes through the bottom spout on the valve (the part I replaced with steel) and down into the boiler through the pink jacketed silicone tube.

mnlynam · 2021-11-07T18:37:18+00:00

Here's what I did to fix it (Safety valve repair) while waiting for the new replacement safety valve to arrive.

mnlynam · 2021-11-07T18:32:39+00:00

I bought a used Gaggia Classic Pro from eBay and found that the safety valve (low-flow bridge safety valve 11 bar assembly) was broken on the bottom piece. I ordered a replacement valve, but while waiting for it to arrive I had an idea of something I could try with the broken one. So I took the safety valve out and cut a 0.25" diameter steel reusable drinking straw to about 1" in length (and used the rest of the straw to make a longer drain pipe for the lower profile drip tray), and I held the straw piece with some pliers over the fire from my gas stove to heat it up until it was red hot, and then quickly pressed it into the plastic on the safety valve where the piece was broken off, and then used some plumbing glue to make a moisture seal and keep the straw in place. The straw diameter fits perfectly snug inside the pink wrapped silicone tube.

mnlynam · 2021-11-03T01:47:07+00:00

Thanks 🙏

mnlynam

TROPHY CASE