• 1 Post
  • 34 Comments
Joined 2 years ago
cake
Cake day: July 3rd, 2023

help-circle

  • I have written similarly awful formulae when I needed to get a csv to export to Google Calendars, but the program I was exporting to wasn’t using Google’s accepted csv headers.

    I ended up creating a template that looked at the exported csv file, and then reformatted it in a way that Google liked (and added some extra info along the way.) I needed it to only fill text if an entry actually had info in it, and hide all the text otherwise. So that I could automatically delete empty cells and avoid a bunch of empty calendar entries when importing it into Google. The resulting formula for some of the fields was… Not great. This is what controlled the “name” of each calendar event:

    It takes several different potential fields, and combines them into a single field. If there are no entries, it gets left blank.

    And every single time I would get it working properly, someone would add a row or change the data validation rules, so I would have to go in and update my formulae. After the fifth or sixth time that happened, I told the person making the changes that it was his job to update the formulae. Suddenly, it stopped getting changed.


  • Someone breaking into your password manager is a lot less likely than someone breaking into one of the dozens or even hundreds of services you probably reuse passwords on.

    Exactly. Without a password manager, every single service you have reuses your password on is a security risk, because any one of them will compromise the rest. And it has repeatedly been demonstrated that even large software companies don’t follow best practices regarding passwords. So any one of them being compromised is a risk. With a password manager, as long as it is properly encrypted and secured with a strong master password, the only point of attack will be your master password.

    It’s less about keeping all your eggs in one basket, and more about reducing attack vectors that hackers have access to. With reused passwords, every single individual service is a potential vector of attack.





  • that respect their time

    I know you’re not talking about old school RPGs. The older games tended to pad playtime by having insane difficulty levels or by requiring grinds. Hell, my favorite JRPG (edit: Legend of Legaia) is specifically more grindy in America, because the devs decided to slash the experience and gold drop rates by like 50% for the American release, and make all of the enemies hit much harder. So you need to be a higher level to be able to survive, and you need to grind twice as long to reach those higher levels and to be able to buy better gear. I like it despite the grind, not because of it; In most of my play throughs, I end up using cheats to avoid the grind.

    and aren’t a glorified second job

    I mean, games like Ultima Online, RuneScape, Diablo, and EverQuest have existed since the 90’s. Hell, RuneScape used to be extremely approachable for young players because it didn’t require a good computer or any installs; It just ran directly in your internet browser.

    The bigger reason many adults feel this way is not because games have gotten longer or harder. Adults simply have less time to play. They don’t want to spend a bunch of time researching optimal builds or grinding rank in multiplayer matches. Instead, they want to fall back to the games that they already know how to play. They’re willing to ignore the fact that their favorite single player game requires 10-20 hours of grinding, because it doesn’t feel like work to them. Or if it does, they can just use cheats to get around it. They don’t need to research how to get a specific item, or how to approach a specific boss fight, because they have already done it a dozen times.


  • You can 100% the Sphere Grid in only a few hours, if you’re smart about it. My guess is they were going around using Clear Spheres to wipe unneeded spheres off the map and replace them. The default Sphere Grid doesn’t actually allow you to max your stats; You need to clear the existing +2 or +3 spheres, and replace them with +4 spheres instead.

    Even then, maxing your stats doesn’t require 9999 hours. Unless OP was farming experience in Besaid Island (the starting area) it shouldn’t take that long to navigate the grid and farm enough replacement spheres.



  • Nah, Trump has said that he wants to eliminate taxes for anyone below $150k… But quickly followed up with “but only after we balance the budget”. Which is really just code for “I want to put my name on something that says <$150k doesn’t pay taxes, without actually implementing it.” And then the actual proposal landed, and it turns out they want to cut taxes by cutting it straight from social security and Medicaid.





  • Prion diseases. In order to work properly, proteins have to be folded in a certain way. Misfolded proteins typically don’t work as they should. Prions are misfolded proteins that cause other healthy proteins to misfold when they come into contact with each other. This causes all sorts of medical issues.

    Mad Cow Disease is one of the more infamous prion diseases. In humans, it manifests as Creutzfeldt-Jakob disease. It basically causes your brain to melt, as the proteins holding it together all get misfolded. It has a 100% fatality rate, typically within 1 year of initial diagnosis. Fatal Insomnia is another prion disease, where the area of the brain that controls sleep is affected, but the body’s need for sleep still persists. You just become totally unable to fall asleep, until you fucking die from sleep deprivation.

    The big issue with prion diseases is that they’re totally 100% incurable and untreatable. Once you have come into contact with the prion, you have a death timer. Prions are also extremely resilient. They aren’t destroyed by time, decomposition, fire, or even caustic chemicals. So they’ll just sit there, waiting for someone to come into contact with them.



  • Yeah, my “Public Transit” option on google maps is entirely greyed out. This is my daily commute to work:

    It’s always entertaining to see the Europeans go “lol just ditch your car, it has to start somewhere” like it wouldn’t require me to move my entire family across town, (and pay 3x as much rent to live in the city…) Like I don’t even have the option of taking public transit, because there are no connecting lines between my home and my job. Literally none. The nearest bus stop is almost as far away as my job, and it’s in the opposite direction.


  • This feels a little bit like Brainfuck tbh.

    For what it’s worth, I can think of one thing that would make brainfuck even worse: Instead of using 8 arbitrary characters (it only uses > < + - . , ] and [ for every instruction) for the coding, use the 8 most common letters of the alphabet. Since it ignores all other characters, all of your comments would need to be done without those 8 letters.

    For example, “Hello World” in brainfuck is the following:

    ++++++++[>++++[>++>+++>+++>+<<<<-]>+>+>->>+[<]<-]>>.>---.+++++++..+++.>>.<-.<.+++.------.--------.>>+.>++.
    

    If we instead transposed those 8 instructions onto the 8 most common letters of the alphabet, it would look more like this:

    eeeeeeeeaneeeeaneeneeeneeenesssstonenentnneasostonnIntttIeeeeeeeIIeeeInnIstIsIeeeIttttttIttttttttInneIneeI
    



  • Yeah, one of my most often stated phrases at work is “you can’t make people read.”

    Error pops up, explaining exactly what the issue is and how to fix it? Oh god, let me call IT to see what I need to do. Yeah, you can’t make people read.

    Some piece of equipment or machinery has changed in some meaningful way? Management is quick to go “just hang a sign on it, letting people know the new process.” Nope, you can’t make people read. People will physically move the sign to the side, try to use the machine like they previously did, and get surprised when it doesn’t work as expected.

    Some area is unsafe due to work happening overhead? “Oh just hang signs on the doors, telling people not to come in.” No, you can’t make people read; I have seen people push their way past physical barriers with big “do not enter” signs, just to ask if we’re open. How about we lock the doors, and disable the keyways on all the doors (except one, where we have physical barriers to entry) until the work is completed?