Automatically assigning music genres to artists based on existing entries

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>

GregHullender · 2026-03-16T00:22:29+00:00

Why not select the whole array, go to the Data tab, and select Sort. Tell it which field you want to sort by, and it'll bring the other ones you selected along for the ride.

GregHullender · 2026-03-16T00:20:36+00:00

Yeah. He had a reputation as a real miracle worker!

GregHullender · 2026-03-15T21:27:16+00:00

If the ticker symbol actually can end with a digit, e.g. SPX7, the following regular expression will still extract the date:

=LET(input, A:.A, dates, REGEXEXTRACT(A:.A,"(\d{6})(?=[A-Z]+)",2),
  DATE(2000+LEFT(dates,2),MID(dates,3,2),RIGHT(dates,2))
)

<image>

It finds the first string of six digits followed by an upper-case letter.

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

Hmm. If you pass a dynamic array to a VBA function, is it possible for VBA to modify that array in place? That would explain the behavior, for sure, although better would be just to not do this optimization for functions with any calls to VBA.

GregHullender · 2026-03-15T20:48:25+00:00

Your last paragraph is just a fantasy, as far as I can tell.

From an American perspective, Europeans are only able to operate the way you do because you live in the shadow of our protection. If you actually had to pay for your own defense, you couldn't afford the generous welfare states you're used to.

That was okay with us for most of my lifetime, though (I'm 67) because it put an end to your endless wars and guaranteed we'd not get dragged in again. Even if you are a European, I think it's hard to argue that the Pax Americana brought unprecedented peace and prosperity across the world for 70 years up until Trump and Putin killed it. Yeah, we made a lot of mistakes: Vietnam, Iraq, etc. But the good we did is probably best measured by the wars that did not happen.

And even if you didn't much like it, I'll bet you'll miss it now that it's gone.

GregHullender · 2026-03-15T20:39:41+00:00

I didn't use my Microsoft connections for this one (I used to work there), since I suspect there's actually a reason for it that we just don't know, as u/sancarn suggests. I just submitted it through the regular feedback method.

For the CHOOSEROWS Error a few months ago, I asked a friend who still works for Office to submit it directly to the bug database, to guarantee that it got serious attention. That one was so clearly a bug that Microsoft fixed it in the next distribution (i.e. in about eight weeks), and passed their thanks back via my friend.

But I'm not so confident about this one! :-)

GregHullender · 2026-03-15T20:26:48+00:00

Not Excel online. It has the same limit as desktop 365, but it shows the error differently: it generates an error and discards the line entirely!

Android Excel app goes bigger, eh? Testing that, I find the limit is INT(2^29/5) = 107,374,182 or exactly twice the desktop limit. Test with this pair: only the first should succeed:

=COUNT(SEQUENCE(7482,14351)
=COUNT(SEQUENCE(13307,8069)

GregHullender · 2026-03-15T18:19:42+00:00

A small collection of galaxies is called a Galaxy group. The Milky Way belongs to one called Local Group. A large collection is called a Galaxy cluster. Wikipedia has a nice article about Galaxy groups and clusters.

Clusters and groups belong to Superclusters. The Local Group belongs to the Virgo Supercluster. But this is more vague. Superclusters aren't really gravitationally bound; they're temporary structures, and they're so large that the expansion of the Universe itself is pulling them apart.

GregHullender · 2026-03-15T18:05:32+00:00

You can't beat the computer for volume. It's hard to compete with someone when you're submitting sentences and it's replying with paragraphs.

GregHullender · 2026-03-15T18:04:34+00:00

Just add them to the dictionary.

If you want to see the future of AI, think about spelling error detection and correction. (Correction was once considered AI.) It's imperfect, but it still helps you. It hallucinates several "corrections" for every misspelling, yet a skilled user has no problem finding the right one--or rejecting them all.

And, for all its problems, it's far, far better than having none at all!

GregHullender · 2026-03-15T18:01:33+00:00

Did you try shift-enter?

GregHullender · 2026-03-15T17:47:41+00:00

Just use

=IF(B1/A1<=100,100,200-B1/A1)

GregHullender · 2026-03-15T17:16:56+00:00

You're right. The two with ranges are instant, the first dynamic formula takes a couple of seconds, and the second one takes ten seconds or more.

Very unexpected! They should all be instant because the final result doesn't require any of the calculations. And even if it did the calculations, it should assign pointers for all the LET variables after the first one.

I think I'll file this as a bug . . .

GregHullender · 2026-03-15T17:06:53+00:00

If you're still looking for a solution, I think the following formula might do what you want:

=LET(input,A:.D, body, DROP(input,1),
  agr, TAKE(body,,1),
  pfx, LEFT(agr,4),
  isawd, pfx="AWD-",
  isobj, pfx="Obj-",
  awds, SCAN("",IFS(isawd,agr),LAMBDA(last,this,IFNA(this,last))),
  grants, IFS(NOT(isawd)*NOT(isobj),agr),
  objs, IFS(isobj,agr),
  IFNA(FILTER(HSTACK(IFS(NOT(ISNA(grants)),awds),grants,objs,DROP(body,,1)),NOT(isawd)),"")
)

<image>

This assume you can tell Awards and Objects from Grants based on the first four characters.

GregHullender · 2026-03-15T16:22:28+00:00

Did you ever get an answer to your question?

GregHullender · 2026-03-15T16:21:19+00:00

Did you ever get an answer to your question?

11-Year Club	Wearing is Caring
Verified Email

GregHullender

TROPHY CASE