u/theguitargym

I'm having trouble getting more than 3k waves on any tier for my defense dissonant runs despite my damage being more than enough to kill the wave. Not being able to use space displacer, land mine stun, or shockwave feels genuinely bad for cc.

BH cooldown is 150 seconds with a duration of 38 with the perk. I have Cl, ILM, BH, GT, and DW. CL damage is always well above wave health when I die. Using an ancestral Shrink Ray, M+ OA, legendary PF, and M+ DC. Attack speed is 57. How do I actually win a defense dissonant run?

I recently started a new job as an accounting manager for a manufacturing company. It's mainly doing cost accounting tasks and every report is 1000s upon 1000s of rows from an old ERP that sometimes exports as text-based reports (really shitty) or tab-delimited reports (less shitty, but formatting still gets wonky.)

I was charged with calculating and sales tax in each state that we need to pay. The old process from my predecessor used a VLOOKUP (not even the vastly superior XLOOKUP) that was checking a workbook of around 200k rows against a different workbook on the hard drive with around 60k rows and matching it back. Needless to say, Excel broke multiple times and most of the time just froze me out of my computer entirely. The two times I've now done this process, it's taken me two whole days to just get all the states calculated, not to mention I still have to file and pay the taxes.

I automated the entire calculation process in Power Query in about 4 hours on Friday. I can literally drag and drop the new sales data and have everything calculated in less than two minutes once the query and pivot table gets refreshed. Used Copilot to fill in some weird code parts needed and spent a good amount of time understanding what my predecessor's formulas were doing and now this process is going to be way less frustrating.

I'm absolutely milking this time in the future, no one needs to know that I just saved myself hours of time each month on a process no one else wanted to do lol.

I may not be as far as most others here, but I think the fixed nature of the bot cooldown labs is silly. I shouldn't have to stop researching a bot cooldown just because it's in a different increment than the medal cooldown, especially when the range slider exists for nearly the exact same reason (farming vs tournaments.)

Let us research the lab cooldown then choose how much cooldown we need from the lab, especially when we can only respec medals to bots in 3 second increments.

I just got everything synced to my legendary MVN and now I've pulled a 4th copy to get M+. I'm afraid of breaking the sync by going up a tier without having a fast game plan to get it back in sync ASAP.

DW is at 270s and GT and BH are at 150s naturally. With a legendary MVN, that puts the trio at a 200s cool down (190 +10). A mythic+ would bring this down to 191s (190+1) which is just a weird number to sync.

I have GBot and Summon synced at 100s CD. GBot has 2 lab CD levels and the rest from medals. I have enough bits to drop summon probably 10s currently. I have enough medals for one point into Gbot cooldown.

I was thinking I might try to reroll the -3 BH cooldown as soon as I synced to mythic and that would bring the average cooldown to 190. From there, I could drop the summon CD to 95 and then do two labs of GBot cooldown plus a tick with medals. I just spent some stones to get everything working with a legendary MVN, so I only have 86 stones to work with for any UW cooldown drops lol.

Any advice on how to get the sync back quickly?