• 160 Posts
  • 2.23K Comments
Joined 1 year ago
cake
Cake day: March 8th, 2024

help-circle




  • There’s different quantity limits on different items. Some are only one per.

    That said, the mods weren’t scalping (at least as far as I know). Unlike a lot of other storefronts, once you put something in your cart on PB, it can’t be sold out from under you. So people were loading up their carts and just letting them sit. Then someone on discord would say “is for me? 👉👈” or whatever, and someone would remove one from their cart while the other person refreshed like mad. They did this for HOURS when the II Neo Zeong was reprinted a few years ago. Their justification was that they were making sure the kits were received by fans and not gobbled up by scalpers. But it’s still gatekeeping. People who weren’t part of that Reddit/discord clique? Well, they can get fucked I guess. 🙄





  • Its saving grace is that pretty much everything comes back around if you’re patient enough. I absolutely hate the timed preorder game, especially when there’s not enough quantity to last more than a few minutes. I have missed every PB Efreet drop. 🙃 And then there’s nonsense like the r/Gunpla mods running interference by loading up their carts with something in high demand (like, say, II Neo Zeong) and letting them go one or two at a time to make sure the in-crowd on discord can get their orders in. Buncha bullshit.



  • I’ve done some seriously stupid shit in excel, mostly due to it being the only tool I had. By the time I handed the project off to someone else for maintenance/feature creep, there were VLOOKUP ranges spanning dozens of columns. VLOOKUP doesn’t care what column the target is named, only the offset from the beginning of the range. So being able to calculate CA minus W is pretty handy.

    Yes, the project should have been a database. But these things happen when skinflint company meets annoyed amateur: you get a sprawling VBA abomination that, despite making actual developers want to choke a bitch, still works orders of magnitude better than the previous system.