tomf's recent activity

  1. Comment on Day 1: Report Repair in ~comp.advent_of_code

    tomf
    (edited )
    Link
    With Google Sheets. I'm trying to do most of these with one formula, which as of now (day three) has been successful. We'll see what the future holds. Part 1 =ARRAYFORMULA( TRANSPOSE( QUERY(...

    With Google Sheets. I'm trying to do most of these with one formula, which as of now (day three) has been successful. We'll see what the future holds.

    Part 1
    =ARRAYFORMULA(
      TRANSPOSE(
       QUERY(
        SPLIT(
         FLATTEN(
          IF(ISBLANK(A2:A),,
           (A2:A+TRANSPOSE(FILTER(A2:A,A2:A<>""))&"|"&
           A2:A&"|"&TRANSPOSE(FILTER(A2:A,A2:A<>""))))),
         "|"),
        "select Col2, Col3 
         where Col1 = 2020 
         limit 1")))
    
    
    Part 2
    =ARRAYFORMULA(
      UNIQUE(
       QUERY(
        FLATTEN(
         IF(ISBLANK(A2:A),,
          IFERROR(
           VLOOKUP(
            2020-
             (A2:A+TRANSPOSE(FILTER(A2:A,A2:A<>""))),
            A2:A,1,FALSE)))),
        "select Col1 
         where Col1 is not null")))
    
    
  2. Comment on Day 3: Toboggan Trajectory in ~comp.advent_of_code

    tomf
    Link
    With Google Sheets I used a variation of this for everything. The only major difference between the first four and the last one was pulling odd rows. Nothing crazy. Part 1 and 2 =ARRAYFORMULA(...

    With Google Sheets I used a variation of this for everything. The only major difference between the first four and the last one was pulling odd rows. Nothing crazy.

    Part 1 and 2
    =ARRAYFORMULA(
      COUNTIF(
       REGEXEXTRACT(
        A1:A,
        REPT(
         ".",
         MOD(
          TRANSPOSE(
          SEQUENCE(1,COUNTA(A1:A),4,3)-3)-1, 
          LEN($A1:A)))&
         "(.)"),
       "#"))
    
    
    For the 1 - 2 one...
    =ARRAYFORMULA(
      COUNTIF(
       IF(ISEVEN(ROW(A1:A)),,
       REGEXEXTRACT(
        A1:A,
        REPT(
         ".",
         MOD(
          TRANSPOSE(
         SEQUENCE(1,COUNTA(A1:A),0,1))-1, 
          LEN($A1:A)))&
         "(.)")),
       "#"))
    
    Solution

    176 and 5,872,458,240

    1 vote
  3. Comment on Day 2: Password Philosophy in ~comp.advent_of_code

    tomf
    Link
    I'm using Google Sheets! Part 1 =ARRAYFORMULA( COUNTA( IF(ISBLANK(A1:A),, IF(--REGEXEXTRACT(A1:A,"([0-9]+)-")<= LEN(REGEXEXTRACT(A1:A,": (.*)"))- LEN(REGEXREPLACE(REGEXEXTRACT(A1:A,": (.*)"),...

    I'm using Google Sheets!

    Part 1
    =ARRAYFORMULA(
      COUNTA(
       IF(ISBLANK(A1:A),,
        IF(--REGEXEXTRACT(A1:A,"([0-9]+)-")<=
         LEN(REGEXEXTRACT(A1:A,": (.*)"))-
          LEN(REGEXREPLACE(REGEXEXTRACT(A1:A,": (.*)"),
         REGEXEXTRACT(A1:A,"([a-z]):"),"")),
         IF(--REGEXEXTRACT(A1:A,"-([0-9]+)")>=
          LEN(REGEXEXTRACT(A1:A,": (.*)"))-
           LEN(REGEXREPLACE(REGEXEXTRACT(A1:A,": (.*)"),
          REGEXEXTRACT(A1:A,"([a-z]):"),"")),
         TRUE,),))))
    
    Part 2
    =ARRAYFORMULA(
       SUM(
        IF(
         REGEXEXTRACT(
          A1:A,
          "([a-z]):")=
         REGEXEXTRACT(
          REGEXEXTRACT(
           A1:A,
           ": ([a-z]+)"),
          REPT(
           ".",
           REGEXEXTRACT(
            A1:A,
            "([0-9]+)-")-1)&"([a-z])"),
         IF(REGEXEXTRACT(A1:A,"([a-z]):")=
          REGEXEXTRACT(
          REGEXEXTRACT(
           A1:A,
           ": ([a-z]+)"),
           REPT(
            ".",
            REGEXEXTRACT(
             A1:A,
             "-([0-9]+)")-1)&"([a-z])"),
         0,
         1),
          IF(REGEXEXTRACT(A1:A,"([a-z]):")=
           REGEXEXTRACT(
            REGEXEXTRACT(
            A1:A,
            ": ([a-z]+)"),
            REPT(
             ".",
             REGEXEXTRACT(
             A1:A,
             "-([0-9]+)")-1)&"([a-z])"),
           1,
           0))))
    
  4. Comment on Advent of Code 2020 has begun in ~comp.advent_of_code

    tomf
    Link Parent
    good Lord. There's a guy in the sub that has been doing everything with Excel -- so there is still hope. But yes, I am also doubting I can complete it with sheets alone. I've dipped into a little...

    good Lord. There's a guy in the sub that has been doing everything with Excel -- so there is still hope. But yes, I am also doubting I can complete it with sheets alone. I've dipped into a little python, but not a lot.

    1 vote
  5. Comment on Salesforce signs definitive agreement to acquire Slack for approximately $27.7 billion in ~tech

    tomf
    Link Parent
    I knew one of the guys who was illustrating it. It was so cool to see the progress... then it all suddenly stopped. I won't let the dream die :)

    I knew one of the guys who was illustrating it. It was so cool to see the progress... then it all suddenly stopped.

    I won't let the dream die :)

    2 votes
  6. Comment on Advent of Code 2020 has begun in ~comp.advent_of_code

    tomf
    (edited )
    Link
    oh man, I need to learn a language quick. I did the first three(!!) in Sheets... but I doubt I'll be able to hack through most of them this way. edit: If anyone wants to see my sheet so far, you...

    oh man, I need to learn a language quick. I did the first first two three(!!) in Sheets... but I doubt I'll be able to hack through most of them this way.

    edit: If anyone wants to see my sheet so far, you can see it here.

    4 votes
  7. Comment on Salesforce signs definitive agreement to acquire Slack for approximately $27.7 billion in ~tech

    tomf
    Link
    A little off-topic, but I hope that Butterfield will go back to Glitch and finish it off, but free it from the browser.

    A little off-topic, but I hope that Butterfield will go back to Glitch and finish it off, but free it from the browser.

    2 votes
  8. Comment on Blood Orange - High Street (Feat. Skepta) in ~music

    tomf
    Link Parent
    ha. That's awesome. I can't believe I forgot to list Always Disappoint U -- the original version feels so corny. Skepta is great. A lot of UK hip hop has been a real blindspot for me.

    ha. That's awesome.

    I can't believe I forgot to list Always Disappoint U -- the original version feels so corny.

    Skepta is great. A lot of UK hip hop has been a real blindspot for me.

  9. Comment on Blood Orange - High Street (Feat. Skepta) in ~music

    tomf
    (edited )
    Link
    This is from Blood Orange's Cupid Deluxe record from 2013. A good deal of this record was a collaboration with Samantha Urbani (Friends... the band, not the sitcom.) The main single was You're Not...

    This is from Blood Orange's Cupid Deluxe record from 2013. A good deal of this record was a collaboration with Samantha Urbani (Friends... the band, not the sitcom.)

    The main single was You're Not Good Enough. I had this record on loop when it came out, then forgot about it for a few years. Now it has returned to the rotation.

    Track Listing
    1. Chamakay
    2. You're Not Good Enough
    3. Uncle ACE
    4. No Right Thing
    5. It Is What It Is
    6. Chosen
    7. Clipped On (feat. Despot)
    8. Always Disappoint U
    9. On The Line
    10. High Street (feat. Skepta)
    11. Time Will Tell
    1 vote
  10. Comment on The Mandalorian | S02E05: The Jedi in ~tv

    tomf
    Link Parent
    it took me a few episodes to get into Clone Wars, but if you do it, make sure you use the absolute / chronological order -- S01E003 is the movie. If you're downloading and using Kodi, scrape them...

    it took me a few episodes to get into Clone Wars, but if you do it, make sure you use the absolute / chronological order -- S01E003 is the movie.

    If you're downloading and using Kodi, scrape them using TVDB and in the options select 'Absolute Order' and it'll pull everything correctly.

    It's a fun series.

    3 votes
  11. Comment on There is a Reddit moderator that has been behaving strangely towards my self and other moderators in ~talk

    tomf
    Link
    If you're top mod, just remove the person and put all of their posts and comments on filter with automod. You said you tried to talk to them about things and the issue wasn't resolved, so what's...

    If you're top mod, just remove the person and put all of their posts and comments on filter with automod.

    You said you tried to talk to them about things and the issue wasn't resolved, so what's left?

    It sucks, but some folks go through difficult seasons and take it out on others. It's not fair to your team or the community.

    I solo mod all of my subs purely so I don't have to deal with this bullshit. My main sub is coming up on 300k subscribers, but my others are between 10k - 60k. Some of the subs have other mods, but they've never done anything. It's a difficult conversation, but getting rid of bad or underperforming mods is better for the community and mod team.

    2 votes
  12. Comment on TV Tuesdays Free Talk in ~tv

    tomf
    Link Parent
    You have no idea how happy it makes me feel to not be the last :) We should get matching jackets. Moonbase 8 didn't get the best reception, but I really liked it. I did all but the last episode...

    You have no idea how happy it makes me feel to not be the last :) We should get matching jackets.

    Moonbase 8 didn't get the best reception, but I really liked it. I did all but the last episode last night. I guess it took them a few years to get the series picked up, but I don't know why. It's got some big names in it within the ol comedy series world.

    2 votes
  13. Comment on TV Tuesdays Free Talk in ~tv

    tomf
    Link
    After listening to the latest episode of the A24 podcast with Tim Heidecker, John C. Reilly, Fred Armisen, and Jonathan Krisel, I decided to tuck into Moonbase 8. It may not be for everybody, but...

    After listening to the latest episode of the A24 podcast with Tim Heidecker, John C. Reilly, Fred Armisen, and Jonathan Krisel, I decided to tuck into Moonbase 8. It may not be for everybody, but I really like it.

    I also finished up Queen's Gambit. Being the last person on earth to watch this, I really enjoyed it. I'll leave it there.... purely as a record for future generations that I did, in fact, watch this series AND was the last person to do so. πŸ†

    Both Bruce Pandolfini and Garry Kasparov consulted on the book and the series, which was pretty neat. Its nice to see a series do their best to try and capture the technical side of the game. Rounders did a decent job at this, but didn't go as far as they could have (for more on this, check the poker pros commentary track.)

    3 votes
  14. Comment on What have you been listening to this week? in ~music

    tomf
    Link
    I used to be DEEP into Nirvana back in the day -- especially the trading scene and all. Then around 2000 or so I just got out of them and moved on without realizing it. I've listened here and...

    I used to be DEEP into Nirvana back in the day -- especially the trading scene and all. Then around 2000 or so I just got out of them and moved on without realizing it. I've listened here and there over the years, but recently I've been going through Bleach, Nevermind (skipping Smells like Teen Spirit), Incesticide, Outcesticide, and In Utero.

    I never need to hear Smells like Teen Spirit again. I do, however, need to pop the other b-sides onto my devices. My favorite record is still Incesticide, followed by most of the b-sides. But the other records are so enjoyable. I'm surprised I left them alone for so long.

    But yeah, Nirvana rules. It's funny how poppy they were in a lot of respects.

    Outside of this, Unicorns - Who Will Cut Our Hair When We're Gone? is another gem I've been revisiting. They split up a little while after this record came out and Nick Thorburn went on to start Islands, who has cranked out a lot of excellent records.

    1 vote
  15. Comment on TV Tuesdays Free Talk in ~tv

    tomf
    Link
    ok, I totally slept on Midnight Gospel because I thought it would be some weird, stoner animation like something from Adult Swim or whatever. However, I was so wrong. What an unbelievable delight!...

    ok, I totally slept on Midnight Gospel because I thought it would be some weird, stoner animation like something from Adult Swim or whatever.

    However, I was so wrong. What an unbelievable delight! Every episode was beautifully illustrated, meditative, weird, and amazing. I'm not a super emotional person or anything, but everything ties up so perfectly while maintaining a consistent feel.

    1 vote
  16. Comment on If you could rewrite 1 element of modern computing, what would it be and why? in ~comp

    tomf
    Link Parent
    yeah, some of those tiny ones are insane. For MacOS, we can probably do it with Karabiner by taking over the right super or using ESC. Going between MacOS and Linux (using tiling window managers...

    yeah, some of those tiny ones are insane. For MacOS, we can probably do it with Karabiner by taking over the right super or using ESC. Going between MacOS and Linux (using tiling window managers for both) always has my fingers forgetting where I am :)

    1 vote
  17. Comment on If you could rewrite 1 element of modern computing, what would it be and why? in ~comp

    tomf
    Link
    MacOS needs another meta key! I mapped my caps to HYPER, but I want a 'super duper' key for an extra layer that is purely my own shortcuts. And this shouldn't be limited to MacOS. Every OS would...

    MacOS needs another meta key! I mapped my caps to HYPER, but I want a 'super duper' key for an extra layer that is purely my own shortcuts.

    And this shouldn't be limited to MacOS. Every OS would benefit from it.

    2 votes
  18. Comment on TV Tuesdays Free Talk in ~tv

    tomf
    Link Parent
    last night's Fargo was so beautifully shot. This season isn't getting a lot of love, but I'm really enjoying it.

    last night's Fargo was so beautifully shot. This season isn't getting a lot of love, but I'm really enjoying it.

    2 votes
  19. Comment on Is there still a housing crisis in Canada? in ~finance

    tomf
    Link Parent
    there are plenty of them, too, which is really great. If you get onto the board, most places give you a reduction in 'rent' / the cost of your share. :)

    there are plenty of them, too, which is really great. If you get onto the board, most places give you a reduction in 'rent' / the cost of your share. :)

    2 votes