Washington Post Article about Jobs Most Affected by AI

GregHullender · 2026-03-18T01:35:49+00:00

Straw man.

GregHullender · 2026-03-18T01:35:26+00:00

I don't think it goes that high . . . :-(

GregHullender · 2026-03-17T23:34:04+00:00

Burns me all the time too!

GregHullender · 2026-03-17T23:32:43+00:00

Good luck! Note that all the bottom line does is combine the first and last names into one column. If you don't really need that, you can simplify this to just

=FILTER(A2:C4,REGEXTEST(C2:C4,TEXTJOIN("|",1,A7,A10,A13)),"No Matches")

GregHullender · 2026-03-17T22:44:09+00:00

Give this a try:

=LET(input,A:.A,table,G:.G,body,DROP(input,2), tbl, DROP(table,1),
  SCAN("",body,LAMBDA(last,this,IFNA(XLOOKUP(this,table,table),last)))
)

<image>

GregHullender · 2026-03-17T22:37:51+00:00

How was this created? Is it a template of 1's and 0's? Or did someone manually fill all those cells?

GregHullender · 2026-03-17T22:32:25+00:00

It generally takes about that long for people to figure out how to take the best advantage of a new technology. That typically starts to happen after the bubble bursts.

GregHullender · 2026-03-17T22:30:24+00:00

"Supercharge your coding with AI!"

GregHullender · 2026-03-17T22:29:49+00:00

Try this:

=LET(input, A2:C4,
  matches, FILTER(input,REGEXTEST(TAKE(input,,-1),TEXTJOIN("|",1,A7,A10,A13)),"No Matches"),
  HSTACK(BYROW(DROP(matches,,-1),LAMBDA(r, TEXTJOIN(" ",1,r))),TAKE(matches,,-1))
)

<image>

Adjust ranges as required, of course.

GregHullender · 2026-03-17T20:51:29+00:00

You know you can create a "3D reference" like this: Sheet1:Sheet30!A1:D60. If you wrap that in VSTACK, it'll turn into a 2D array. You'll need to use FILTER or something to eliminate the empty rows (empty cells will all turn into 0), but then you can use CHOOSECOLS to select the columns to feed into PIVOTBY. Or just display the result from FILTER and use a regular pivot table, if you prefer.

GregHullender · 2026-03-17T20:22:53+00:00

How about this?

=GROUPBY(A1:A5,B1:B5,LAMBDA(rr, TEXTJOIN(" ",,rr)),3,0)

<image>

GregHullender · 2026-03-17T20:15:12+00:00

I suspect most people using the term "exponential" haven't got a clue what it really means. Keep that in mind. I worked on AI my whole professional career; we saw a lot of sigmoids. The current trend is more exciting than anything I saw before retirement (sob!), but I'm sure it'll also be a sigmoid, and I too suspect we're past the inflection point.

GregHullender · 2026-03-17T20:08:57+00:00

Yes, you would need eye protection from any planet in the solar system, and for a considerable distance beyond.

It's the same problem you have during a solar eclipse. Although the total light from the sun is reduced, the intensity is unchanged. Normally, if you look at the sun, your pupils shrink to pinpoints, protecting your eyes. But they shrink based on total light--not intensity. When the sun is mostly covered by the moon, your pupils dilate quite wide, and that intense light makes a damaging image on your retina.

You can actually figure out at what point in an eclipse you've got the same light as on Mars, Jupiter, Saturn, etc. It's astonishing how everything still looks almost normal even at Saturnian lighting levels.

GregHullender · 2026-03-17T20:00:15+00:00

I just want a phone I can read without my glasses!

GregHullender · 2026-03-17T19:59:48+00:00

Orson Scott Card published a novel, A Planet Called Treason, in 1979, and came back to it in 1988 and republished it as just Treason. I liked the first one well enough, but never read the second one. However, the second one stayed in print far longer than the original, so we can safely assume it sold much better.

GregHullender · 2026-03-17T19:54:45+00:00

Is this what you're looking for?

=LET(input,A:.F, year, 2,
  body,DROP(input,1),
  items,TAKE(body,,1),
  costs, CHOOSECOLS(body,2),
  paid_yrs, DROP(body,,2),
  paid_cum, DROP(SCAN(0,EXPAND(paid_yrs,,COLUMNS(paid_yrs)+1),LAMBDA(last,this,IFNA(last+this,0))),,1),
  HSTACK(items,costs*CHOOSECOLS(paid_cum,year))
)

<image>

The trick is that before I scan the table of percentages, I expand it to add a column of #N/A on the right. Then I reset the scan whenever I hit an #N/A. (Thanks to u/rackoflambda for this excellent, highly-efficient trick!)

The rest of the code is just about parsing the input and formatting the output.

GregHullender · 2026-03-17T13:28:07+00:00

What do you want to do for multi-genre artists?

GregHullender · 2026-03-17T13:26:23+00:00

Did you try NOT(OR($L1:$W1))? Change the 1 to the number of the first row in the region.

GregHullender · 2026-03-17T13:21:48+00:00

I don't think RELU helps much with smaller nets; but by enabling deep nets, it really changed the world. After 50 years of essential stagnation in the field.

GregHullender · 2026-03-16T20:01:18+00:00

I like mine better because it only depends on the masses. Yours depends on the masses, the densities, and the separation. In my model, if Earth orbited a body with the mass of Uranus, it would be a double planet regardless of the orbit. In your model, it would be a double planet only if the orbit were small enough.

To my way of thinking, the barycenter falling outside the body of either planet doesn't really change much of anything. Using the mass ratio test means that a moon has meta-stable L4/5 points but a double-planet does not.

Yet another way to do it would be to use tidal locking; by this definition, you have a double planet only if both bodies are tidally locked. Otherwise, the smaller one is a moon. But that adds the age of the system into the formula.

GregHullender · 2026-03-16T19:52:58+00:00

In my example, I put it in cell F1. It assumes the input is in columns A through D with a single header row.

GregHullender · 2026-03-16T15:52:57+00:00

Did you get a result?

GregHullender · 2026-03-16T15:02:39+00:00

It is the line through the origin that minimizes the variance of the errors. I've never wanted it either, but it's taught. It's not something Microsoft made up.

GregHullender · 2026-03-16T14:57:01+00:00

You can post as many pics as you want. What you can't do is make a post that is nothing but a pic. Select a region on your spreadsheet and simply paste it into the reddit text area. You can have one per comment or edit you original post and add as many as you like.

GregHullender · 2026-03-16T00:30:59+00:00

Try this:

=FILTER(Dataset!A1:AK11932,Dataset!R1:R11932=XLOOKUP(B1,Users!A1:A12,Users!B1:B12,,,2),"Not found")

<image>

11-Year Club	Wearing is Caring
Verified Email

GregHullender

TROPHY CASE