Multi-purpose Maximum Damage Calculator

Kittysama - Raging Tide_1432680721

Kitty was extremely bored watching her new mains farming Aquametals in Astral Domain so she thought about making a maximum damage calculator to make calculating maximal damage doable with certain skill easy. It can also be used for some other uses like how you could 1-shot someone or how much HP you need to survive supposed 1-shot.

Soo, https://docs.zoho.com/sheet/published.do?rid=egrja77e973eab611466fb88b727047623454

The file works by writing necessary values to green blocks. It automatically calculates stuff when values are written.

Damage from most skills can be calculated with that, excluding Armageddon(dat friggin HP-based attack ._. Can be done though if you calculate HP- and mana-based damage yourself and copy-paste it to "Additional add") and couple others.

Kitty used http://pwi-wiki.perfectworld.com/index.php/Damage for creating formulas. Kitty thanks Olbaze for mentioning about Spirit added to PW-Wiki. Kitty added it to calculator.

Edit: Kitty's DPS-calculator also now available! https://docs.zoho.com/sheet/published.do?rid=egrjaa0a9806db36948eca66d45fa32b5981d

Edit 2: There's no typo in how Kitty wrote that mystic's certain herb.

Olbaze - Sanctuary

Ok, this is going to be a bit long, but whatever.

The first thing that I see is the colours. I think you really should use less colours. You really only need to use three colours: One for the naming, one for the input and one for the calculated output. There really is no need to give every single multiplier their own colour scheme. Another thing that I would note is the choice of colours. You should avoid dark and bright colours. For example, on my monitor, I can barely read output numbers on the dark red, not to mention the dark purple naming on the Phys. Dds.

The second thing that jumps is how many things the spreadsheet has. I think that there are two things you are doing wrong here. First is that you're not grouping similar things together. What I mean by this is things like two modifiers for each ring or separating your War Avatars and Nuemas into Battle and Destruction. The second is that you're showing all of your numbers. Examples of numbers that don't serve any purpose but are visible would be H56 "Defence multiplier lowered from debuffs", D56 "Defence multiplier lowered from debuffs", and basically everything that you have in red, such as the entire E and J columns. Multipliers that serve no purpose should be hidden from sight on a separate sheet.

Another thing that jumps at me is your naming scheme. With every single skill, you include which class it belongs to. I don't think that's really necessary.

As for actual content: In cell B37, you're not using the multiplier for Attack Levels correctly. You're only using the one where Attack Level > Defense Level, which results in a faulty number when Defense Level > Attack Level, as then you're supposed to use a different formula.

And while you did not include it, The Damage wiki article does not have the formulae for Spirit.

Kittysama - Raging Tide_1432680721

Thanks Olbaze for feedback. Kitty couldn't change the attack/def. level formula as that little change would need pretty much duplicating most of the stuff. Kitty also left those extra multipliers just so that users could see where the numbers are coming from and maybe learn a bit about how everything affects and how much. Kitty's noticed some have overestimated some things and underestimated others so that will help to realize the image. Kitty added spirit too to calculator and adjusted colors to be less mindblowing.

And Kitty's sorry about it's massivity. Kitty wanted to make it as accurate as possible and having tested it on her chars Kitty thinks it gives about 99% accurate values. Quite small marginal for so many factors.

Kitty also made another calculator as a result from her arguing about sin-APS barb OPness in a certain FC. Kitty hopes this finally ends the constant arguments of which class has best DPS(or maybe it's just throwing fuel to the fire).

Soo, DPS Calculator by KittyLogic™.

https://docs.zoho.com/sheet/published.do?rid=egrjaa0a9806db36948eca66d45fa32b5981d

DoesntMatter - Harshlands

I got a fracking migraine trying to read your text. Why the fracking hell would you use that font color?b:angry

And.. for the Damage Calculator... thanks, good job. We alll love you b:victory

CapnK - Sanctuary

Methinks Kitty doesn't like the channeling debuff from Creeper. b:chuckle

Kittysama - Raging Tide_1432680721

CapnK - Sanctuary wrote: »

Methinks Kitty doesn't like the channeling debuff from Creeper. b:chuckle

Nope. Kitty hates how it ruins her Myriads, Ironwood and barb's Devour Q.Q

Fissile - Archosaur

You have frostblade / condensed thorn marked as sin only, but it works on all melee skills. Most BM and barb skills benefit from frostblade, and a couple seeker skills as well (veno fox skills too, but those aren't gonna 1 shot anyone lol).

Kittysama - Raging Tide_1432680721

Fissile - Archosaur wrote: »

You have frostblade / condensed thorn marked as sin only, but it works on all melee skills. Most BM and barb skills benefit from frostblade, and a couple seeker skills as well (veno fox skills too, but those aren't gonna 1 shot anyone lol).

Kitty marked Condensed Thorn as sin-only due to text box being too small to accommodate both. Frostblade indeed affects any melee-attacks, be it sin, claw-archer, barb or psy whacking with sphere.

And, about veno fox skills...when used as T3-HA-veno, they actually have a high chance to 1-shot any squishy targets. If Myriad procs, only high HP can save from 1-shot if speaking of G16-Nirvie(or lower)-geared ppl. R9rr+12s are their own realm within a realm.

Sage melee mastery's like 250 extra str, after all. And sage HA-veno with enough str for T3-armors can thus have melee damage multiplier pretty much similar to sins. And sparked even surpasses sins in pure base damage multiplier XD HA-veno though has the disadvantage of inability to get either -int on weapon or plate, thus having max. 2,5 effective APS(with magic sword) and lacking crit. rate real melee-classes have. But the debuffs veno has nicely compensates for that, a lot, not to mention extra DPS from suitably skilled pet(Kitty used to have evolved scorpion with 5 damage skills and Tabby for extra debuffs).