Multi-purpose Maximum Damage Calculator

Kittysama - Raging Tide_1432680721
edited June 2014 in General Discussion
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.
Post edited by Kittysama - Raging Tide_1432680721 on
[SIGPIC][/SIGPIC]
Final ragequit on 21/02/2014 'cause ARC. Back on 15/04/2014, RL was bored.
Ten Paths of Kittyness(old mains when deleted): Kittysama 100(100) Sage HA-Venomancer |Aivina 100(101) Sage (ex-Zerk) Str. Seeker | Kittytart 90(101) Demon All path Zerk BM | KittyFishie 92(101) Demon APS/DPH Zerk Assassin | Haroin 100(100) Demon Vit. Zerk Barbarian | Elfborn 82(100) Demon Cleric | Pessimiste 85(100) Sage Wizard | PalavaEnkeli 87(100) Demon Fist/APS-Archer | VerenVanki 85(100) Demon Mystic | MerenPeto 85(100) Sage Psychic
Current mains: Old psy and 19 new/recreated mains(avg. level 82)

Comments

  • Olbaze - Sanctuary
    Olbaze - Sanctuary Posts: 4,242 Arc User
    edited June 2014
    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.
    I am Olba. Not Ol, not Baze nor Blaze. And even less would I go by Olblaze. Please, take a second to read a person's username.
    If you see b:cute be sure to take a second, calm look at anything I said.
  • Kittysama - Raging Tide_1432680721
    edited June 2014
    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

    [SIGPIC][/SIGPIC]
    Final ragequit on 21/02/2014 'cause ARC. Back on 15/04/2014, RL was bored.
    Ten Paths of Kittyness(old mains when deleted): Kittysama 100(100) Sage HA-Venomancer |Aivina 100(101) Sage (ex-Zerk) Str. Seeker | Kittytart 90(101) Demon All path Zerk BM | KittyFishie 92(101) Demon APS/DPH Zerk Assassin | Haroin 100(100) Demon Vit. Zerk Barbarian | Elfborn 82(100) Demon Cleric | Pessimiste 85(100) Sage Wizard | PalavaEnkeli 87(100) Demon Fist/APS-Archer | VerenVanki 85(100) Demon Mystic | MerenPeto 85(100) Sage Psychic
    Current mains: Old psy and 19 new/recreated mains(avg. level 82)
  • DoesntMatter - Harshlands
    DoesntMatter - Harshlands Posts: 11 Arc User
    edited June 2014
    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
    //#######################################//
    Surviving in a world full of crazy humans, or perhaps i am the crazy one?
  • CapnK - Sanctuary
    CapnK - Sanctuary Posts: 1,166 Arc User
    edited June 2014
    Methinks Kitty doesn't like the channeling debuff from Creeper. b:chuckle
  • Kittysama - Raging Tide_1432680721
    edited June 2014
    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
    [SIGPIC][/SIGPIC]
    Final ragequit on 21/02/2014 'cause ARC. Back on 15/04/2014, RL was bored.
    Ten Paths of Kittyness(old mains when deleted): Kittysama 100(100) Sage HA-Venomancer |Aivina 100(101) Sage (ex-Zerk) Str. Seeker | Kittytart 90(101) Demon All path Zerk BM | KittyFishie 92(101) Demon APS/DPH Zerk Assassin | Haroin 100(100) Demon Vit. Zerk Barbarian | Elfborn 82(100) Demon Cleric | Pessimiste 85(100) Sage Wizard | PalavaEnkeli 87(100) Demon Fist/APS-Archer | VerenVanki 85(100) Demon Mystic | MerenPeto 85(100) Sage Psychic
    Current mains: Old psy and 19 new/recreated mains(avg. level 82)
  • Fissile - Archosaur
    Fissile - Archosaur Posts: 607 Arc User
    edited June 2014
    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).
    [SIGPIC][/SIGPIC]
  • Kittysama - Raging Tide_1432680721
    edited June 2014
    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).
    [SIGPIC][/SIGPIC]
    Final ragequit on 21/02/2014 'cause ARC. Back on 15/04/2014, RL was bored.
    Ten Paths of Kittyness(old mains when deleted): Kittysama 100(100) Sage HA-Venomancer |Aivina 100(101) Sage (ex-Zerk) Str. Seeker | Kittytart 90(101) Demon All path Zerk BM | KittyFishie 92(101) Demon APS/DPH Zerk Assassin | Haroin 100(100) Demon Vit. Zerk Barbarian | Elfborn 82(100) Demon Cleric | Pessimiste 85(100) Sage Wizard | PalavaEnkeli 87(100) Demon Fist/APS-Archer | VerenVanki 85(100) Demon Mystic | MerenPeto 85(100) Sage Psychic
    Current mains: Old psy and 19 new/recreated mains(avg. level 82)