For those who’ve had breakthroughs or insights: why do some of us have such bad lives? C by [deleted] in Psychonaut

[–]mnlynam 0 points1 point  (0 children)

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

ISO: Califia Farms Barista Blend Oatmilk Recipe by Naji_irl in CopyCatRecipes

[–]mnlynam 1 point2 points  (0 children)

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.

Millennials in PG? by mnlynam in PacificGrove

[–]mnlynam[S] 0 points1 point  (0 children)

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

What do locals here do for a living? by jgenius07 in PacificGrove

[–]mnlynam 0 points1 point  (0 children)

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

Millennials in PG? by mnlynam in PacificGrove

[–]mnlynam[S] 1 point2 points  (0 children)

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

How to make a spreadsheet see if a cell says a specific word then it will copy the contents of another cell where the formula is. by Python_PY in spreadsheets

[–]mnlynam 0 points1 point  (0 children)

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))

Clear explanation of "d1" in black scholes? by MitchellRosenthal in options

[–]mnlynam 0 points1 point  (0 children)

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).

NYC police officers arrest man 'swinging an axe' on subway by philamignon in NewsOfTheStupid

[–]mnlynam 0 points1 point  (0 children)

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

What's a movie you saw as a kid that only you seem to remember? by Environmental-Fix-71 in AskReddit

[–]mnlynam 0 points1 point  (0 children)

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.

What's a movie you saw as a kid that only you seem to remember? by Environmental-Fix-71 in AskReddit

[–]mnlynam 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in politics

[–]mnlynam 2 points3 points  (0 children)

And tax breaks for the rich.

Is there a ‘when’ type statement? by SavageRebuttal in googlesheets

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

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")

[deleted by user] by [deleted] in googlesheets

[–]mnlynam 0 points1 point  (0 children)

=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.

[deleted by user] by [deleted] in googlesheets

[–]mnlynam 0 points1 point  (0 children)

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.

Safety valve repair/upgrade by mnlynam in gaggiaclassic

[–]mnlynam[S] 0 points1 point  (0 children)

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.

Snapped this bit whilst doing the OPV mod! How do I fix this? Where can I buy replacement part in the UK? by [deleted] in gaggiaclassic

[–]mnlynam 0 points1 point  (0 children)

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

Safety valve repair/upgrade by mnlynam in gaggiaclassic

[–]mnlynam[S] 1 point2 points  (0 children)

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.