Penny Arcade Forums› Debate and/or Discourse
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
We now return to our regularly scheduled PA Forums. Please let me (Hahnsoo1) know if something isn't working. The Holiday Forum will remain up until January 10, 2025.

How's the desktop interface treating you, [chat]

1…34689…99

Posts

  • WonderMinkWonderMink Adventure! Candy IslandRegistered User regular
    Tumin wrote: »
    OK back to shitposting

    Omg it's baaaaaaaaacccccccckkkkkk

    and I wonder about my neighbors even though I don't have them
    but they're listening to every word I say
  • credeikicredeiki Registered User regular
    I always used a computer so I didn't notice
    Jacobkosh wrote: »
    Hey guys, I've got a spreadsheet question.

    Let's say I have this spreadsheet where I've taken down the results of, say, a survey, like how many people in various cities in the US have goldfish.

    So sheet 1 is like

    Rochester, NY | 100 people surveyed | 15 goldfish owners |
    Tucson, AZ | 160 people surveyed | 23 goldfish owners |
    Salem, OR | 73 people surveyed | 6 goldfish owners |

    And then on sheet 2 I want to have an individual row for each goldfish owner with more detailed information about the individual, but with their location autofilled in with the data from Sheet 1, like so

    Jim Bob Earl Duke | Rochester, NY | Truck Wrestler |
    Kylee Crayfish | Rochester, NY | Homeunmaker |
    Tits McGee | Tucson, AZ | dancer |

    Is there a way to get it so, after I've put the data for sheet 1 in, the first 15 rows of sheet 2 are autopopulated with "Rochester, NY", the next 23 with "Tucson, AZ", etc etc? Because if I just set Jim Bob Earl Duke's location to $Sheet1.A1, it'll return Rochester, but Kylee Crayfish's location will show as Tucson (because it's calling to $Sheet1.A2).


    I believe you want vlookup https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 if you are using excel

    Steam, LoL: credeiki
  • Rhesus PositiveRhesus Positive GNU Terry Pratchett Registered User regular
    I'm pretty sure theres a javascript clicking the wrong buttons on purpose
    I thought for a minute that the forum had completely broken just moments after the mobile site came back

    Turned out it was my WiFi shitting the bed

    [Muffled sounds of gorilla violence]
  • Havelock3.0Havelock3.0 What are you? Some kind of half-assed astronaut?Registered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    God

    Bless

    Americaaaaa

    You go in the cage, cage goes in the water, you go in the water. Shark's in the water, our shark.
  • BlackDragon480BlackDragon480 Bluster Kerfuffle Master of Windy ImportRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    amateurhour wrote: »
    I've never thought of putting beans under the spit.

    That is some galaxy brain shit and I'm here for it.

    Thanks Kosh

    Jack Stack's beans are a meal unto themselves. Seasoned with a days worth of assorted meat drippings and enough beef trimmings make a 1/4lb hamburger.

    They also do another side that's creamed sweet corn with drippings, pit ham, and enough cheese to make a Wisconsinite stand up and take notice. All of that is put in crocks and then baked.

    No matter where you go...there you are.
    ~ Buckaroo Banzai
  • amateurhouramateurhour One day I'll be professionalhour The woods somewhere in TennesseeRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    you had me at pit ham

    are YOU on the beer list?
  • WinkyWinky rRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    Havelock2.0 wrote: »
    “Russian Warship go fuck yourself”

    Narrator: So they did

    The fact that it is literally the same ship from the meme is some real good shit

  • Havelock3.0Havelock3.0 What are you? Some kind of half-assed astronaut?Registered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    No Man’s Sky is fun. Just started it on survival. Died five times to rad poisoning and once to life support failure

    I think I got the hang of this

    You go in the cage, cage goes in the water, you go in the water. Shark's in the water, our shark.
  • JacobkoshJacobkosh Gamble a stamp. I can show you how to be a real man!Moderator mod
    BlackDragon480 wrote: »
    amateurhour wrote: »
    I've never thought of putting beans under the spit.

    That is some galaxy brain shit and I'm here for it.

    Thanks Kosh

    Jack Stack's beans are a meal unto themselves. Seasoned with a days worth of assorted meat drippings and enough beef trimmings make a 1/4lb hamburger.

    They also do another side that's creamed sweet corn with drippings, pit ham, and enough cheese to make a Wisconsinite stand up and take notice. All of that is put in crocks and then baked.

    my secret critical rubric for judging a bbq place is the quality of the beans and nothing I've had anywhere else has ever topped Jack Stack's. Sometimes I just buy a quart just to have around.

    The cheesy corn bake is also rad although I don't generally do pork so I kind of try to pick the little porky bits out. But if it was meatfree I'd probably just shove the entire wedge into my mouth, so.

  • JacobkoshJacobkosh Gamble a stamp. I can show you how to be a real man!Moderator mod
    credeiki wrote: »
    Jacobkosh wrote: »
    Hey guys, I've got a spreadsheet question.

    Let's say I have this spreadsheet where I've taken down the results of, say, a survey, like how many people in various cities in the US have goldfish.

    So sheet 1 is like

    Rochester, NY | 100 people surveyed | 15 goldfish owners |
    Tucson, AZ | 160 people surveyed | 23 goldfish owners |
    Salem, OR | 73 people surveyed | 6 goldfish owners |

    And then on sheet 2 I want to have an individual row for each goldfish owner with more detailed information about the individual, but with their location autofilled in with the data from Sheet 1, like so

    Jim Bob Earl Duke | Rochester, NY | Truck Wrestler |
    Kylee Crayfish | Rochester, NY | Homeunmaker |
    Tits McGee | Tucson, AZ | dancer |

    Is there a way to get it so, after I've put the data for sheet 1 in, the first 15 rows of sheet 2 are autopopulated with "Rochester, NY", the next 23 with "Tucson, AZ", etc etc? Because if I just set Jim Bob Earl Duke's location to $Sheet1.A1, it'll return Rochester, but Kylee Crayfish's location will show as Tucson (because it's calling to $Sheet1.A2).


    I believe you want vlookup https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 if you are using excel

    ah hah, thanks cred!

  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    baked beans and macaroni and cheese
    the two sides to judge all BBQ joints
    and dessert is banana pudding

    Bless your heart.
  • UnknownUnknown
    This content has been removed.

  • UnknownUnknown
    This content has been removed.

  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    cole slaw and potato salad are a distant third and fourth

    Bless your heart.
  • UnknownUnknown
    This content has been removed.

  • WonderMinkWonderMink Adventure! Candy IslandRegistered User regular
    Havelock2.0 wrote: »
    No Man’s Sky is fun. Just started it on survival. Died five times to rad poisoning and once to life support failure

    I think I got the hang of this

    You've almost got gud

    and I wonder about my neighbors even though I don't have them
    but they're listening to every word I say
  • evilbobevilbob RADELAIDERegistered User regular
    I have a cat cuddled up next to me but any minute now someone else in the house will wake up and he'll shoot off to beg them for breakfast.

    l5sruu1fyatf.jpg

  • AbdyAbdy Registered User regular
    Glad we've finally rejected mobile devices
    Organichu wrote: »
    it's a little weird to me that I have tomorrow off for Good Friday. it makes sense for Christmas because that's risen above just being a religious occasion. but Good Friday is like... just a religious thing?? no one observes it areligiously?

    why do I have off? not uh, complaining

    I am observing it

    I wore skis today and a crime series was on in the background

    as is tradition

    ftOqU21.png
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    NCAA gymnastics is so hard to follow scoring wise since every team is doing something different at any given moment

    Bless your heart.
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    Also it’s kind of unfair since Auburn has like the top ranked gymnast on the planet right now as a freshman

    Bless your heart.
  • TuminTumin Registered User regular
    edited April 2022
    TTODewback wrote: »
    Also it’s kind of unfair since Auburn has like the top ranked gymnast on the planet right now as a freshman
    Lee is the first all-around Olympic gold medalist ever to compete as an NCAA gymnast. She won gold in 2021 then enrolled at Auburn a month later.

    Hmmmm

    DOESNT SOUND VERY AMATEUR TO ME HUEHUE

    Tumin on
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    Other teams be jealous
    But then they remember she has to live in Alabama

    Bless your heart.
  • BurnageBurnage Registered User regular
    Glad we've finally rejected mobile devices
    Man, some of those Hellfire Gala designs look great

    The Gambit one... does not

  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    AU is alright as long as you avoid Jordan Hare during weekends in the Fall. You can basically live there for four years without stepping into the horrible shitzone outside of it.
    And you can go to ATL on the weekends

    Bless your heart.
  • UnknownUnknown
    This content has been removed.

  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    mmm cajun nips

    Bless your heart.
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    best nips i guaranteeeeeeeeeee

    Bless your heart.
  • amateurhouramateurhour One day I'll be professionalhour The woods somewhere in TennesseeRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    Hey I noticed Alabama is actually like middle of the pack for education now in the US.

    are YOU on the beer list?
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    amateurhour wrote: »
    Hey I noticed Alabama is actually like middle of the pack for education now in the US.

    only if you look at a certain metric.
    on one of the metrics we're like 22nd
    but on the one that makes a big deal out of math and stuff I think we're 47th?

    Bless your heart.
  • amateurhouramateurhour One day I'll be professionalhour The woods somewhere in TennesseeRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    Oh shit Picard......


    Oh shit.

    are YOU on the beer list?
  • TTODewbackTTODewback Puts the drawl in ya'll I think I'm in HellRegistered User regular
    like we just passed a bill TODAY about getting goods at math.

    Bless your heart.
  • 21stCentury21stCentury Call me Pixel, or Pix for short! [They/Them]Registered User regular
    edited April 2022
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    amateurhour wrote: »
    Oh shit Picard......


    Oh shit.

    did he F, M & K Q?

    21stCentury on
    f8EQaL1.png
    Check out my site, the Bismuth Heart | My Twitter
  • amateurhouramateurhour One day I'll be professionalhour The woods somewhere in TennesseeRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    TTODewback wrote: »
    amateurhour wrote: »
    Hey I noticed Alabama is actually like middle of the pack for education now in the US.

    only if you look at a certain metric.
    on one of the metrics we're like 22nd
    but on the one that makes a big deal out of math and stuff I think we're 47th?

    I mean I was trying to give us some props.

    are YOU on the beer list?
  • amateurhouramateurhour One day I'll be professionalhour The woods somewhere in TennesseeRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    21stCentury wrote: »
    amateurhour wrote: »
    Oh shit Picard......


    Oh shit.

    did he F, M & K Q?

    Spoilers

    For real
    BSG

    are YOU on the beer list?
  • RMS OceanicRMS Oceanic Registered User regular
    Rhesus Positive wrote: »
    I thought for a minute that the forum had completely broken just moments after the mobile site came back

    Turned out it was my WiFi shitting the bed

    This happened to me too

  • WinkyWinky rRegistered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    I did my taxes, it was extremely unrewarding

  • TavTav Irish Minister for DefenceRegistered User regular
    I just went for a nap at like 5pm which is annoying because I won’t sleep properly tonight and also that’s not a nap time in any timezone I’ve been in the last three weeks!!

  • 21stCentury21stCentury Call me Pixel, or Pix for short! [They/Them]Registered User regular
    Did you know amateurhour browsed on mobile but with the desktop site on purpose, before this bug?
    amateurhour wrote: »
    21stCentury wrote: »
    amateurhour wrote: »
    Oh shit Picard......


    Oh shit.

    did he F, M & K Q?

    Spoilers

    For real
    BSG

    oh i meant did Picard fuck, marry and subsequently kill the alien Q.

    I don't actually know what your spoiler means.

    f8EQaL1.png
    Check out my site, the Bismuth Heart | My Twitter
  • TavTav Irish Minister for DefenceRegistered User regular


    🤌

  • MimMim lemme gobble that weenieRegistered User regular
    I'm pretty sure theres a javascript clicking the wrong buttons on purpose


    “I can be your heeerrroo baaabbbyy”

    BlueSky: thekidwonder Steam: mimspanks (add me then tell me who you are!)
This discussion has been closed.
Penny Arcade Forums› Debate and/or Discourse