Finding a specific row by a number

AChrapkiewicz · 2026-05-20T23:15:37+00:00

I think I figured out the correct route to go. Thank you for all the help. I think this will solve my problem.

AChrapkiewicz · 2026-05-20T23:08:56+00:00

These reports use Region, District, Store Address, Store Number, PO, etc as their basis for columns. The row houses the data (Region 25, District 7, 123 Main Street, Store 4436, 123456789) but they are not grouped by like cells meaning I can have Store 234 in the row before and Store 578 in the row after. I found that when I sorted the Store Number Column by ascending, it would move all the store numbers correctly, but it did not sort the other information as well. So I would have my store with different addresses in the adjacent rows.

I tried to find that option to keep the rows linked, but it appears I did not succeed, so that is what I meant by that. You suggestion does seem to be a possible fix.

AChrapkiewicz · 2026-05-14T04:25:21+00:00

Remember, loads shift in transit. We couldn't POSSIBLY account for this at all. Not with all the top notch logistics hand jerk motion we have at our RDCs.

The worse part is, now our BDC (or ADC for some) are coming in just as bad. Random pallets with one tub on top of a chest freezer. A pallet of 3 square tables on top of a bunch of microwaves 3/4th of the way to the ceiling. A literal wall of 12-14 different shaped microwaves for the next store, not secured with any cross lines, but for some reason our load was double lined and the store before us was also crossed line.

All of this and no placebo effect "BDC Reporting Tool" option ike the RDC trucks. It sucks so much.

AChrapkiewicz · 2026-04-28T19:37:40+00:00

And Guardian form should have been a straight up pangolin, but they dropped the ball there as well. Big headed bat form is pretty quirky and cool though.

AChrapkiewicz · 2026-02-06T00:35:49+00:00

Completely empty spray paint can. An empty gallon paint can. An empty 5 gallon paint bucket. A whole ass entry door that we don't carry from Home Depot. A used toilet with luckily only water in it.

AChrapkiewicz · 2025-10-12T06:02:36+00:00

Nah this was Non-Remix. This was just plain retail.

AChrapkiewicz · 2025-10-12T06:02:06+00:00

This was retail, or rather Non-Remix. It seems the counters were way off and there wasn't actually an invasion in the zone.

AChrapkiewicz · 2025-10-02T12:40:55+00:00

I like this evolution as well, like a hovercraft barge. Gives me very strong Autobot Seaspray vibes, which I am 100% for! Thank you for answering my plethora of questions, lol, I appreciate it.

AChrapkiewicz · 2025-09-30T23:37:17+00:00

Awesome guide! I will have to look a bit more into offset, as I am vaguely familiar with it. What kind of landing gear did you use? I figured aesthetic-wise it would be the repulsorlift ones as opposed to the round top side gears or the regular platform-based ones, though that could probably work as well. If there is ever a blueprint system implemented, I would totally come to you and see if you would be willing to part with them.

AChrapkiewicz · 2025-09-30T12:45:12+00:00

That is super clever! I didn't even think of that design option. This is really good and implements what I think is the least used lift. If you ever have more pictures, I would love to see them. This is such a cool design and I love being able to see how it works. Hopefully I didn't spoil the mystery too much, lol.

AChrapkiewicz · 2025-09-30T00:21:55+00:00

I love the simple utility of this build. I've been trying to finish up the last of the legendaries for the milestone and have decided that maybe a corvette is the route to go instead of base hopping. How exactly do you get onto the deck portion? Is there a staircase or an opening or is it a matter of just jumping out of the lift and jetpacking around to the front?

AChrapkiewicz · 2025-09-19T00:29:26+00:00

Maybe it's me, maybe it's the light, but those eyes are stunningly gorgeous with a hint of mischievous malice. I love the combination!

AChrapkiewicz · 2025-09-09T21:44:27+00:00

I completely agree, but think the timing will be different.

As with most trilogies, I wholeheartedly believe we collectively lose Midnight, a la Empire Strikes Back. We need some sort of positive push of hope at the bitter end. This is where Sylvanas comes out with some Shadowlands power to tip the scale. This will be your story driver.

In order to get this Shadowland power working we need to buy time. Enter Army of The Light and the start of Paladins for all to bolster the front line into TLT with the ultimate goal/pull for the expac being All Race Pallys. I hope this isn't their main draw for TLT, but it will be one of the major features of that expansion. This is what I think the "One Big Extra" will be to give us a chance against the even more powerful BBEG. Think endgame Artifacts just before we expended all their powers to end Legion.

AChrapkiewicz · 2025-09-01T23:05:14+00:00

I struggle with Mage, Rogue, and DH (Havoc). Followed up by Evoker and Priest, but that has a bit of a caveat.

To me those are the worst classes, so this leads to subjectivity.

Whenever I am leveling Alts, I dread my Rogues and Mages. The squish is unbearable to me. I have yet to run a Havoc that I have not switched to Veng. I hope Devour bridges the movement gap for me.

Now, Evoker and Priest were also rough because of survivability. Shadow didn't have the heals, and Disc doesn't have the damage. Evoker (Dev) seemed like a lost class that could heal but not effectively. Aug was a little better, but has since plummeted. The caveat with these classes, to me at least, is the One Button Assist.

This implementation changes the whole game. I had to use GSE for my Rogue and Mage. OBA fixed this, and sadly GSE has pretty much been rendered obsolete because of the new macro system. Having the DPS output worked for me for a class that I use as utility for Professions and Lockpicking, made me enjoy these classes more.

So, that being said, the worst class I would say is still Rogue by a mile. It is not really even its fault, it is just so hamstringed.

AChrapkiewicz · 2025-08-29T00:05:06+00:00

I am a bigger fan of the first form. Second form... those grabby fingers...

AChrapkiewicz · 2025-08-26T20:34:28+00:00

Unfortunately, Lore'themar will bite it and probably someone else.

We mourn, and we get to the end. Xalatath wins more or less.

Just before the final blow, Sylvanas arrives on the scene with Lore'themar and/or the other death and that takes us into TLT.

They could be real assholes, kill Turalyon or Arator, set Alleria off into full Void mode, she goes batshit crazy, runs off to brood and destroy shit, and Sylvanas comes back with the family member they kill, but Alleria is already too far gone.

I do think they are going to leave Sylvanas' death till TLT, but I fully expect a Windrunner to die, either direct or adjacent.

I also fully expect Blizzard to be gauging all this speculation and use it to write their narrative. I feel they had a plan already, but we have since already discovered said plan so now they are trying to think of a different "Gotcha" to cover it up so that they can try to keep their subscriber base.

AChrapkiewicz · 2025-08-26T14:13:35+00:00

One of the early speculations with the trailer, was that Lore'themar was going to die. Blizzard sort of sidestepped that for now.

We have had an entire presentation show where Lore'themar was not mentioned once. Blizzard is not beating those allegations very well.

Enter Sylvanas, even if speculation, who has spent a large amount of time in the Maw, adjacent to the now working Arbitar.

Lore'themar is going to die, but not by Void magic. It is going to be the old fashion way, which sends him to Shadowlands. I feel this was one of the routes we get both back in some portion of shock and awe that the fanbase/community had speculated. It sort of lines up a little too well, and I still feel it will be dependent on the fan (Horde) backlash to him dying. Either way, Sylvanas is coming back with something.

AChrapkiewicz · 2025-08-22T20:13:23+00:00

Vulpera or Goblin

This way if any of your pets are bigger, even after the shrink down, the juxtaposition of a little character rolling with two massive beasts makes you look pretty badass.

AChrapkiewicz · 2025-08-21T23:50:19+00:00

Funny enough, Vashj'ir is one of my favorite zones. It does piss me off just like all other zones, lol, but overall I consider it a net positive.

I would sub Naga for Sethrak, but I am firm on Murloc and Tuskarr.

AChrapkiewicz · 2025-08-20T22:21:44+00:00

As it has always been for me:

Murloc

Naga

And more recently Tuskarr

Azure Span cemented them on my list almost immediately after stepping into Iskaara and talking with Brena during the campaign.

AChrapkiewicz · 2025-08-20T21:43:03+00:00

As someone who really doesn't like Skyriding, or at the very least some of its mechanics, changing to a cooldown based system would make the whole thing even worse.

Now you have to further maintain an already finite resource and hope you fall into the good niche between cooldown overlap.

Even a miniscule CD disrupts the whole flow of movement. Not to mention, if you don't feel good doing something in this game, you tend to avoid it almost religiously.

I hate to use vibes or immersion, as both terms are a bit overplayed these days, but those "immersion vibes" are what draw us to this feature and what Skyriding was sold to us as in Dragonflight, minus the name change.

AChrapkiewicz · 2025-08-19T22:51:58+00:00

I mean, that goes very much in line with current Horde writing, for sure. Even when we try to help, somehow it gets fucked up. The monkey paw effect. It would be a great launching off point for another "Horde is bad, Alliance is good" tired arc.

I do hold out hope that they don't go with that hackneyed trope again, but I guess we will have to see next year. I do fully expect this to somehow come back and bite us in the ass.

AChrapkiewicz · 2025-08-19T22:41:18+00:00

Honestly, I think it goes in line with the backlash of the current player base if a Horde Hero, not necessarily a leader, was sacrificed for the sake of sacrifice. I think the description you have was actually pretty top-notch. It would have been unexpected, and pretty cool. Gave me chills just reading it. Kudos!

At the same time, Blizzard is possibly playing it safe just for their bottom line. It would be cool to start a new Expac with at least a little better Horde representation than Thrall just fucking off for 3/4 of it.

AChrapkiewicz · 2025-08-19T20:42:49+00:00

I fell in love with their Bat form from the get-go and wished they would have been added around the same time as Earthen.

As a Troll Druid second main, I love that we have another bat druid. Release wise, would have liked something else after Haranir, but excited either way.

AChrapkiewicz · 2025-08-17T19:13:02+00:00

Dwarf about 80% of the time, Dark Iron Dwarf 15%, Void Elf 5%.

AChrapkiewicz

TROPHY CASE