MrQuizzles

Wait, no it doesn't. Even if you input 15000000 defense, you will not get the sheet to report an even-lvl boss's final accuracy under 6.5%.

I did respect the lower clamps (the ones stopping it from going under 5%), that's why the formulas are so long and rife with IF statements.

I ignored the upper-end clamps (the ones stopping it from going over 95%) because they're largely irrelevant and I felt that the formulas were long and complicated enough.

The exact formula used:

=IF(IF((50-(L14+(M14*L46)))<5,(C14)*5,(50-(L14+(M14*L46)))*(C14))<5, 5, (IF((50-(L14+(M14*L46)))<5,(C14)*5,(50-(L14+(M14*L46)))*(C14))))

Where C14 is the accuracy modifier, M14 is the ToHit debuff, L14 is a defense value, and L46 is the level disparity power effect modifier.

The accuracy formula looks like this:

[Base ToHit - (defense - defdebuffs) + (ToHitbuffs - ToHitdebuffs) maxmin 95,5] * (accuracy)

at which point the 95,5 max,min is again applied.

As of Issue 7 (which is what this sheet is made for), all enemies will have a Base ToHit of 50 regardless of rank or level. Instead, the accuracy modifier will be increased and decreased based upon level and rank.

You can get a boss down to 5% final accuracy, just never an even-lvl one. They have 2 accuracy modifiers, one for level and one for rank, that are multiplied together. The accuracy modifier for level goes below 1 when an enemy is a lower level than you. At some point, the rank modifier and the level modifier multiplied together will be equal to or less than 1.

So against a -3 boss, 50 defense would look like this:

[50 - (50) + (0)] * (.7330 (level modifier)*1.3(rank modifier))
^^^This gets hit by the minimum
[5]*(.9529)=4.7645
The minimum then brings that back up to 5
The level accuracy modifier is enough to drag the entire accuracy value below 1, making a 5% final accuracy possible.

I have never heard of such a thing. Please post a link to where a dev said that.

Also, every enemy's base to-hit chance is 50% as of I7.
50% x .1 = 5%

Either way you look at it, it's correct.

This spreadsheet was originally created by Ladioss_Sopp some time ago, and it has been a great tool to use to help us calculate enemy accuracy and power effectiveness over a large spread of levels.

With the coming changes to enemy accuracy in Issue 7 this sheet would have been obsolete (his old sheet was actually working off the old assumption that to-hit debuffs were multiplicative, anyway). Ladioss hasn't been around in a while, so I have updated it to work with Issue 7.

So now I give you: The Sheet!

Using it is simple. Just type in the amount of defense or to-hit debuffing you have in either L4 or M4 respectively, and the sheet will calculate the final accuracy of enemies of all levels and ranks.

On it is also a handy recharge calculator and HP/healing sheet for heroes.

See the sheet.
Love the sheet.
Live the sheet.

And a thank you to Pilcrow for hosting the sheet.

Yes, there was a typo in the description of a blaster power that is now fixed.

There ya go, bug fix!

[ QUOTE ]
[ QUOTE ]
Ninjitsu also has a version of it, I'm very sure. It's got some crazy name, but it's there.

[/ QUOTE ]

Ninjitsu only has a self-heal. EA's final defensive power has a Dull Pain-like function to it, I'm fairly sure.

[/ QUOTE ]

Well that makes me hate Ninjitsu stalkers a bit less, although I'll never be able to forgive them for the fear protection.

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Heh, I'm sure they do. The point is, they die more often than Stalkers, or are you going to tell me that isn't true, too?


[/ QUOTE ]

The kill ratio of stalkers is more aligned with blasters while death ratio is similar to scrappers. unless +perception is heavy then most stalkers go down as fast as MMs. =)

[/ QUOTE ]

I wouldn't say as fast as MMs. MMs have less HP, no mez protection, and very little defense for themselves.

To my blaster (ice/fire), an MM is two shots with Aim and Buildup. A stalker is 4.

[/ QUOTE ]

Explain why a stalker takes twice as many shots to kill when they have very similar hp to a MM... Please don't say defense is an issue when you just hit aim and bu for a +150% (well over 200% if slotted with THBs) to hit buff (although depending on the MM's spec they may have significantly better defense than a stalker. And what does status protection have to do with anything when you're trying to blast someone to death in as few shots as possible?

[/ QUOTE ]

Well for one, they don't have similar HP to an MM. They actually have THE SAME AMOUNT OF HP AS A CONTROLLER, DEFENDER, CORRUPTOR, AND DOMINATOR. Why do people keep thinking they have less HP than everyone else???!!! They don't!

Besides that, some of the sets (I know at least regen and ninjitsu have one, not sure about energy aura) have a Dull Pain equivalent that gives them much more HP, near un-buffed scrapper levels.

The only time I two-shot a stalker with my blaster was when he made the mistake of not killing me after AS brought me down to about 5% health. Defiance tore him to shreds.

[/ QUOTE ]

I said similar...as in not exactly the same but close. And actually, my dear evolutionary throwback, corruptors have more hp than all the others you mentioned, but less than blasters. the point of my post was to say that stalkers don't have double the hp of a MM...they are actually within about 10% of eachother. Why are you trying to say it takes twice as many hits to kill a stalker? That's just crap.

[/ QUOTE ]

You're assuming all my powers do the same damage.

With Aim and Buildup, Bitter Ice Blast + Ice Blast will kill an MM.

Adding Ice Bolt onto that usually isn't enough to defeat a stalker unless I've got some defiance. I usually have to resort to using Frost Breath to finish them off.

Ninjitsu also has a version of it, I'm very sure. It's got some crazy name, but it's there.

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Heh, I'm sure they do. The point is, they die more often than Stalkers, or are you going to tell me that isn't true, too?


[/ QUOTE ]

The kill ratio of stalkers is more aligned with blasters while death ratio is similar to scrappers. unless +perception is heavy then most stalkers go down as fast as MMs. =)

[/ QUOTE ]

I wouldn't say as fast as MMs. MMs have less HP, no mez protection, and very little defense for themselves.

To my blaster (ice/fire), an MM is two shots with Aim and Buildup. A stalker is 4.

[/ QUOTE ]

Explain why a stalker takes twice as many shots to kill when they have very similar hp to a MM... Please don't say defense is an issue when you just hit aim and bu for a +150% (well over 200% if slotted with THBs) to hit buff (although depending on the MM's spec they may have significantly better defense than a stalker. And what does status protection have to do with anything when you're trying to blast someone to death in as few shots as possible?

[/ QUOTE ]

Well for one, they don't have similar HP to an MM. They actually have THE SAME AMOUNT OF HP AS A CONTROLLER, DEFENDER, CORRUPTOR, AND DOMINATOR. Why do people keep thinking they have less HP than everyone else???!!! They don't!

Besides that, some of the sets (I know at least regen and ninjitsu have one, not sure about energy aura) have a Dull Pain equivalent that gives them much more HP, near un-buffed scrapper levels.

The only time I two-shot a stalker with my blaster was when he made the mistake of not killing me after AS brought me down to about 5% health. Defiance tore him to shreds.

[ QUOTE ]
[ QUOTE ]
Heh, I'm sure they do. The point is, they die more often than Stalkers, or are you going to tell me that isn't true, too?


[/ QUOTE ]

The kill ratio of stalkers is more aligned with blasters while death ratio is similar to scrappers. unless +perception is heavy then most stalkers go down as fast as MMs. =)

[/ QUOTE ]

I wouldn't say as fast as MMs. MMs have less HP, no mez protection, and very little defense for themselves.

To my blaster (ice/fire), an MM is two shots with Aim and Buildup. A stalker is 4.

[ QUOTE ]
He posted a Stalkers HP, other ATs will have significantly more HP.

[/ QUOTE ]

Where do people get this stuff?

He posted a stalker's HP, yes. He also posted a controller's, defender's, dominator's and corruptor's HP in the same number.

Stalkers do not have less HP than most ATs, you are not masterminds!

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]

Now now Kosh.... don't tease the chowd. After all, living next to the north pole causes dementia... he can't help it.

[/ QUOTE ]

Man, I'm originally from Indiana and I still never thought that Florida and Texas were even remotely close together. Of course, I also realized quite early on that states in the south tend to be larger and filled with tons of nothingness between bastions of civilization (example: Georgia. Never have I seen a state so full of empty. And people say we're running out of room for our population..), as opposed to states in the north/northeast, which tend towards the more compact.

[/ QUOTE ]

Heh... I thought it was a riot when i lived in georgia. This was exactly what the people there thought. They thought the south had a monopoly on the concept of "rural". Yet,... anywhere you go in georgia you're no more than an hour drive from a city.

I live in Maine, where we only have a million people altogether, and some places are 5 or so hours from an actual city. People routinely drive a couple hours just to shop. I personally consider boston a day trip.. it's only five hours to get there, and when you live so seperated from the rest of the states, five hours isn't so bad. That's probably why I considered NJ so close to boston.. that's only a four hour drive. (depending on where in jersey of course... but NYC is three from boston)... Hell, once when driving from south carolina to maine I stopped by Ohio because it was on my way.


And it's still only one waterway. Take a canoe. It's cheap and you could use the excersize.

Zeus - god of real men

[/ QUOTE ]

Great crap, how do you live? I'm originally from Rhode Island and I think that anything longer than a 45 minute's drive is long!

I guess it's a side-effect of living in the smallest state for so long.

Woo, great pics! I wish I could've been there. Sadly, though, I am but a college student who lives nowhere near anywhere any event is ever held...ever.

[ QUOTE ]
[ QUOTE ]
They wouldn't nerf defenders. We're the most balanced AT, after all.

[/ QUOTE ]

I can't hear you over the six slots I had to put into pet gaze. What was that again?

[/ QUOTE ]

Oh, well, we're balanced but we're not allowed to have anything resembling a good control powers.

Controlling is for controllers while...er...well, something or other is for defenders, but I'm not quite sure what it is.

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Basically: if it was meant to be taken down by more than 1 team, it gives the badge. Mission versions are scaled down versions that are more like AV's, thus able to be defeated by a single team, and thus do not give the badge.

[/ QUOTE ]
You might need to buff Giant Monsters then. There's not one in the game that requires more than one team to defeat.

[/ QUOTE ]

Will do.

[/ QUOTE ]

They're supposed to require teams??!!
Crap, I've been doing it wrong!

They wouldn't nerf defenders. We're the most balanced AT, after all.

You could always come to my hometown. We've got lots of woods that'll fit tons of people in 'em.

[ QUOTE ]
NO WAI!!!

[/ QUOTE ]

YEA WAI!

I got mine

Edit: Changed it a bit since I don't like what it did with my question mark >: (

Yeah, I'm definitely guilty of using the toga as a tunic. Call me crazy, but I think it makes a pretty good fancy tunic.

Now, I've never had the best taste, but I came up with this. You can't really see the golden body sparkles in the picture, but they're there.

[ QUOTE ]
[ QUOTE ]
Note on testing:

I haven't checked this myself, but "people" say that the sets don't really acheive the final ratio of damage, etc. until level 20. I knowl, for HP, that the level 1's are all within 5 HP of each other, while at level 40-ish they've spread to whatever their final value is.

Level 15 may be a little early for testing.

[/ QUOTE ]

Actually I beleive "back in the day" it was said that the damage does not normalize across the board till level 30. Though most everyone reached correct ratio by level 20. So 20 should e fine but I would suggest for any real test you test at level 30 or above. Heck do it at level 50 to make sure you completely remove the variable.

Defender blasts are I am quite certain set to 66% of blaster blasts. Also blaster blasts are apprently NOT 100% effectivness but some postive percent based off some mysterious hidden number. Which we are not really privy to. Some people here have said here the corruptors are 100% blast strength. Given that they are 77% of blasters blast strength(a werid number) I consider the arguement that corruptors are in fact the baseline damage to have more than a little merit. Regardless there is no way to really know what the underlying base damage is, when the devs buffed tanks for example I think they said it was to 80% of blaster damage so that really answered nothing

For all we really know it could be:
Tanks X+5%
Scappers X+15%
Corruptors X-5%
Defenders X-15%
Blasters X+20%
C0ntrollers X-30%
With X being some magic base number. I point this out because with out really knowing the equation the math an get all wonky if your not careful.

[/ QUOTE ]

I believe the damage scales look like this:
Controllers- 60%
Defenders- 75%
Tankers- 90%
Blasters- 110%
Scrappers- 125%

Although it's just easier to think of blaster damage as 100%
Controllers- 55%
Defenders- 68%
Tankers- 80%
Blasters- 100%
Scrappers- 110%

No

Containment is only really throwing the equation way out of whack in PvP. A controller can take a squishy down faster than my defender could ever dream of doing.

[ QUOTE ]
[ QUOTE ]
Power values are the same. AT mods are different, except for the Perception debuff which is hard coded at -90% for all of these powers.

[/ QUOTE ]

If I'm reading you correct, I believe you've stumbled into the heart of a lot of complaints between Controllers and Defender powers. IF I'm reading you right, you mean to say that Smoke from Fire Control has the same value as Trick Arrow's Flash Arrow when used by a Controller (and a 1.25 modifier when used by a Defender).

That's a big issue for Defenders, because we've seen powers constantly reduced in order to ensure that Controller primary controls remain (significantly) more than 25% better.

[/ QUOTE ]

Ugh, don't remind me about going through I5 with Dark Miasma: Controller nerfs (lots), defender buffs (none).

Er...I don't see any way -acc can be called soft control. It has absolutely nothing to do with control whatsoever.