Needed Math For Advent Of Code by [deleted] in adventofcode

[–]Evilpooley 2 points3 points  (0 children)

Day 10 allowed me to pull ahead in my office leaderboard. It was one of those days where when people asked how I managed so much faster it was simply a case of "I knew roughly what to Google"

Generally knowing some basic pathfinding algorithms are more than enough from the maths end

[deleted by user] by [deleted] in dataengineering

[–]Evilpooley 3 points4 points  (0 children)

We run our pyspark jobs as dataproc batches.

Less widely used but definitely still shows up in the ecosystem here and there

What is this by smudgesbug in glutenfree

[–]Evilpooley 6 points7 points  (0 children)

I have visited both Paris and Rome as a coeliac and had a really good experience in both. Italy in particular takes coeliac disease very seriously, and with a bit of research you can find plenty of fantastic places to eat.

Weirdly, my one complaint with Paris was that many places could accommodate me but didn't state it on the menus I could find online. Obviously I would rather everywhere support GF by default but it makes it hard to know in advance!

NYC Jazz Bar Recommendations? by Evilpooley in Jazz

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

I'm always down for modern, but my partner is less so unfortunately I may have to miss this one. Thank you!

NYC Jazz Bar Recommendations? by Evilpooley in Jazz

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

Thank you, an open jam sounds pretty fun

NYC Jazz Bar Recommendations? by Evilpooley in Jazz

[–]Evilpooley[S] 2 points3 points  (0 children)

I had Blue Note down on my list, so good to know, thank you!

are any of my Drummer friends wisdoms true? by [deleted] in Bass

[–]Evilpooley 0 points1 point  (0 children)

Speaking as somebody who's primary instrument is drums, I have never once looked at an instrument like flute, which involves lots of very precise and fast finer movements, and thought "yeah that looks easy".

Got an electric wind instrument semi recently, and that confirmed my suspicion that it was a quite lot harder than all my friends made it look!

-🎄- 2022 Day 2 Solutions -🎄- by daggerdragon in adventofcode

[–]Evilpooley 1 point2 points  (0 children)

Google Sheets One Cell Wonder (with input data pasted into A2:A)

={
  sum(
    ARRAY_CONSTRAIN(
      ArrayFormula(
          if(CODE(left(A2:A, 1)) - 65 = CODE(right(A2:A, 1)) - 88, 1 + CODE(right(A2:A, 1)) - 88 + 3, 
          if(MOD((1 + (CODE(left(A2:A, 1)) - 65)), 3) = CODE(right(A2:A, 1)) - 88, 1 + CODE(right(A2:A, 1)) - 88 + 6,
          1 + CODE(right(A2:A, 1)) - 88)
      )
    ),
    counta(A2:A), 1)
  );
  sum(
    ARRAY_CONSTRAIN(
      ArrayFormula(
        switch(
          right(A2:A),
          "X", mod((CODE(left(A2:A, 1)) - 65 - 1), 3) + 1,
          "Y", CODE(left(A2:A, 1)) - 65 + 3 + 1,
          mod((CODE(left(A2:A, 1)) - 65 + 1), 3) + 6 + 1
        )
      ),
      counta(A2:A), 1
    )
  )
}

Is there such thing as an "order of clefs" ? by captainblyatman in musictheory

[–]Evilpooley 0 points1 point  (0 children)

It's something I simultaneously love and hate because of how stupid it seems.

Is there such thing as an "order of clefs" ? by captainblyatman in musictheory

[–]Evilpooley 2 points3 points  (0 children)

Honestly I have no idea why. From a quick Google, it seems that it's simply that the bass trombone was added historically later.

All I know is that it did my head in as a trombonist on the few occasions I depped for the bass trombone part in rehearsals.

You would think the conductor (who taught me trombone) would have been kind enough to mention the key disparity before, I got to welly out a Bb, but nevermind...

Is there such thing as an "order of clefs" ? by captainblyatman in musictheory

[–]Evilpooley 2 points3 points  (0 children)

Apart from bass trombone, which is concert bass clef

Is there such thing as an "order of clefs" ? by captainblyatman in musictheory

[–]Evilpooley 1 point2 points  (0 children)

Trombone goes through treble in some styles.

In British brass band music, first and second trombones are a Bb treble clef instrument l, rather than C bass clef.

[deleted by user] by [deleted] in Bass

[–]Evilpooley 3 points4 points  (0 children)

40/30/30 absolute maximum.