• 0 Posts
  • 11 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.





  • edit: also 2-300 hours in oldschool RuneScape lol

    I have logged over 200 hours in RuneScape just this month.

    It probably helps that I have a job where I can have it running next to me. At this point, it is basically just an idle game that I only need to touch every ~15 minutes to refresh my idle logout timer. Pretty much the only times it’s not running are when I’m asleep or physically away from a computer.

    Hell, even when I’m away from my computer, it keeps running as long as I can touch it every now and then to stay logged in. If I’m AFK’ing slayer with aggressive enemies, I only really need to touch it to refresh my inventory or the idle timer. Even when I’m playing other games, RuneScape just runs quietly on my second monitor.


  • It’s just disappointing to see how drastically the series has changed. It started as a top-down strategy RPG, and now it’s just a generic hack-n-slash game. Game publishers have shied away from games like the original Dragon Age, because they want to sell as many units as possible. And they think generic hack-n-slash games sell better. Games like Baldur’s Gate 3 have proved that there is still a large demand for more traditional RPGs, but the publishers simply don’t want to take the risk.




  • 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.