Bopper

Yes, all non-defender versions are broke. Luckily, it's an easy fix. Those versions are simply missing the EMP Arrow Burst summon effect which causes the -Regen. There was a recent fix for EMP Arrow that addressed a bug which was introduced in i27. When Trick Arrow had its revamp, procs in EMP Arrow started using pseudopet proc formulas instead of click proc formulas. So they fixed that in a very recent patch to have EMP arrow use click proc formulas again by changing how the effects are executed. However this fix seemed to only be completed for Defenders and broke the other ATs. If you look up EMP Arrow for defenders on CoD, you can find the EMP Arrow Burst execution, which is missing from other ATs.

Good catch. I think a recent bug fix resulted in only fixing the defender version. Controller, corruptor, and mastermind seem to be missing the effect for EMP Burst. This should be an easy fix.

Got a list of adjustments? It'll help folks checking the sheet to know where to look for verification and validation.

You are better off putting a stealth IO into one of your prestige sprints that way you can use it if needed but usually you won't have to. Put a LotG in Hover.

You know your formulas more intimately so I don't know if this would work for you, but what I've done in the past when I've used essentially multiple look up tables is to chain it. I will look up one table, and if it fails I have it look up the second table. If it doesn't fail it returns the proper item. It complicates the formula slightly, but once you get one right it becomes easy to copy/paste.

Try a layout like this. Expand the Abilities to another column which can handle up to 4 pool selections (notice I also include 6th slot powers like Jaunt, just in case that matters. I would rename your "Pool" sheet to "Epic", then make a new "Pool" sheet to hold all the pool power options. I also added a Huge Accuracy (11%) option as that was missing in your previous version. I moved the Legend to the top left so that it is hopefully the first thing someone sees before editing.

I'd also recommend Musculature Radial as it offers endurance modification (useful for proc builds) and run speed (slightly useful in granite, but more important outside granite if you don't want to TP all the time). GotA is nice because it's not just the run speed buff, it also enhances defense. So it's not a complete waste of a slot.

I was able to resave it into my Drive and the checkboxes work now.

My guess is, you're using excel while I dont have excel (I'm using the excel program built into Google drive). I dont have checkbooks so I just type in true. Nonetheless, I bet that is t what actually causes the issue. You are pulling values from cells that are likely functions. Excel probably treats those cells as a 0 when it's empty, but Google drive might not be

Elec/Energy/Flame (was the default setting from the version I downloaded)

That honestly is the answer I like. While you're fixing things, are there no options for using pool powers? One reason I ask, I see there is a damage buff calculation for unrelenting, but not one for adrenal booster, but it doesn't seem to have a way to be used in the rotation. Also, setting any of the +Recharge options from False to True causes a #Ref.

I opened the sheet to see what's going on with the Buildup and Aim. First, you should include the buff numbers when they are in the rotation. Not everyone takes Aim so seeing it automatically contributing is not good. Also, I tried using Aim and Buildup in the rotation. When I type 12 (buildup) I see my damage buff go up. When I type 5 (Aim) there is no change to the damage buff. Can you explain why Aim is not increasing my buff value?

You can turn off fly in caves and just use EvMa and Hover.

It directly came from that. The idea was simple enough to implement quickly and Number Six is a magician.

Very long time. Welcome back.

Editing a database is not code. You go in, find the power you want to change, make the edits. You can use City of Data to get the scales you need.

Sentinels have 3 sources of scaling resistances, so it is the only AT that can reach 75% resistance on Live. Increasing it to 1.5x would allow Sentinels to reach 90% at 0%HP. Well over their cap, but useful for resistance debuffs. In comparison to Brutes, Tankers, and Scrappers, that would allow Sentinels to reach the other AT's 60% resistance cap at 20% HP

Do it yourself. The database is right there for you to edit on your local machine.

It is a PBAoE, so you targeting an enemy won't matter. You will need to be within 100 ft of enemies, and all of them will be subject to teleportation. The TP is mag 4.1, so you should be able to pull anything less than a +4 boss.

I still haven't read everything in this thread, but I did skim most of it. You are right about Benumb, it debuffs strength (not resistance). So it acts as an anti-powerboost. In regards to debuffing debuff resistances, I believe Acid Arrow is truly unique (and underappreciated, as your post highlights). Debuffing debuff resistances works much like debuffing damage resistances, in that a resistance debuff of X% makes your debuffs X% more powerful, despite the targets resistance level (unless they have 100% resistance, of course). Let's do an example. Let's say a target has 40% resistance to regeneration debuffs. You apply a 80% regeneration debuff on the target, but thanks to its resistance it only takes a 48% debuff [80% x (100%-40%) = 48%]. Now let's say you use Acid Arrow and apply a 40% debuff to their resistance to regeneration debuffs. Their original 40% resistance will resist your 40%, so their new resistance will not be 40% - 40% = 0%, instead it will be 40% - 40% x (100% - 40%) = 16%. Now your 80% regen debuff against their 16% resistance results in the following final debuff: 80% x (100% - 16%) = 67.2%. So how much did we improve? 67.2% / 48% = 1.40 (40% increase in debuff performance). As you can see, this is significant...it's giving you and all your teammates a 40% increase in debuff performance against affected targets.

Not at home, so I haven't read the context of this post. If you're talking about my analysis done back in August on the closed beta testing, I can try to copy/paste it below. I expanded on my previous analysis, adding Traps and Storm Summoning. I underestimated Storm, it doesn't debuff everything but what it can debuff it is top tier. Reminder, this analysis is done using 375% total recharge in every power (perma-hasten amount), and Defense Debuffs are enhanced to 90% while To-Hit Debuffs are enhanced to 54%. So treat this as only performance potential with high-end build. With the simple rank-order analysis, Trick Arrow remains on top through incredible consistency. Of the 7 powersets anaylzed, Trick Arrow ranked between 3rd and 5th in every category other than To-Hit, which it ranked 2nd (arguably, that one is up for debate but I gave the edge to its AV performance). Anyways, here's the breakdown of everything.

On my computer, I went here (Activity) and selected unread content. It took me to the .../unread/ link Btw, I did not know about Dev Digest and Staff Digest. That's pretty cool, I guess I can start unfollowing Devs now that I have a direct link to their stuff 😛

Btw, I noticed your expected Elec times changed with VS. What did you tweak to correct it?

I was mostly referring to comparing Sentinel A to Sentinel B. If you have a Blaster sheet, you'll want to validate that as well. I imagine defiance will be the major change between sheets.

Keep in mind, the pylon DPS formula is not very accurate. It assumes consistent HP regeneration when in fact chunks of HP come back in 15s intervals. This leads to fluctuations in DPS, for example it's possible to have a longer pylon time but a higher DPS. It's unintuitive, but it's completely true. Long story short, I wouldn't sweat the variance too much. Your numbers are coming in very close to the spreadsheet calculations, and that's all that matters. Keep in mind though, although this helps validate your spreadsheet you must understand that when comparing A to B, if it's close you can't say definitely which is better. In those situations, you may look to doing a large sample size test to help determine that answer.