Crusader DPS and EHP Spreadsheet

  • #1
    This is a Crusader DPS and EHP Spreadsheet I've been working on. It is based around the one I made with a wizard in mind, but adjusted for Crusaders. It should work for any class that is not dual wielding to an extent, though it currently does not support any class specific buffs or passives besides some of the Crusader ones. If you're having any issues with the spreadsheet please read the "Notes" tab to make sure you're entering the correct information.
    In case there's any confusion, your Int, Vit, Str, DPS, HP, CC, CD, APS should exactly match the in game value (APS rounds to 2 decimals though). Your armor and lowest resist should match the in game values exactly, though they might differ by 1 due to rounding on the char sheet.

    Link to spreadsheet
    https://drive.google.com/file/d/0B4-opYZrg_XRVERGYXA4eXNQRVE/edit?usp=sharing


    Features:
    The spreadsheet features the ability to input your total stats and weapon stats to compute your dps and EHP. There's also a separate tab where you can compare a secondgear set. The DPS value should match your in game Damage Number, provided all applicable stats are entered correctly. Additionally the spreadsheet computes relative dps gains for a range of dps stats and also reports those values in terms of comperable values of your primary stat, i.e., how many Primary stat points is 1%IAS worth, etc.

    Here are some more specific features:

    1) Calculates unbuffed dps, char sheet buffed dps, and effective char sheet dps. Char sheet buffed dps is what you will see in game based on all your skills. The effective char sheet dps is what your buffed char sheet dps would be if it included all the bonuses for the skill you use (such as +Blessed Shield%) and elemental damage type (like +holy damage%).

    2) Paragon point table where you can input how many points you spent on each stat. The table also shows you the relative gain of a paragon point for each stat to your effective char sheet dps and your EHP.

    3) A second sheet allows you to compare two gear sets and displays the difference in EHP and DPS.

    4) Relative dps and EHP gains for each stat are shown (Primary, vit, crit%, etc.).

    5) A comparison of Marquise Ruby vs Emerald is shown for easy reference, or the gear comparison can be used to compare the different gems at higher levels. For most people Emerald will be much better now that weapon damage% has been drastically cut on new drops (used to go up to 50%, now it's like 10%, if that).


    Limitations and Workarounds
    Does not compute toughness stat, and toughness is not the same as EHP. I have no plans to implement functionality to compute toughness.

    The spreadsheet does not work well with weapons that have a base attack speed of 1.15 APS, or any other base APS not divisible by 0.1. The workaround currently is to set the 1.15 APS weapon to 1.15 APS in the spreadsheet, and put 15% IAS on the weapon IAS cell in column C. That tricks the spreadsheet into computing the correct IAS. If your weapon does have IAS, I'm still working on a solution.


    If you have any issues downloading or using the spreadsheet, feel free to post here or send me a PM after you've read the Help tab.


    Planned Updates:

    None, but I'm open to suggestions for updates, but currently do not plan to include the option to import your character from the blizz armory, mostly because I don't know how and the armor still doesn't quite seem to display values correctly for everything. If someone knows how toimport character stats and wants to add the functionality to the spreadsheet, let me know, or feel free to make your own variant of the spreadsheet.


    Updates:
    5-31-14 fixed weapon damage% affix on weapons to work correctly with elemental damage, per patch 2.0.5 changes
    Last edited by Loroese: 5/31/2014 9:10:56 AM
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #2
    Just wanted to say thanks for this. It's really amazing and accurate. I have one question though, is there a plan to add the consideration of set bonuses for stuff like life% and +AR?
  • #3
    Yes, I've been thinking about how to do that. For now I just put them in as socket bonuses as a workaround. If I have time this weekend I can add separate boxes like the elite damage ones for extra things like AR, life%, life regen, etc.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #4
    Loroese,

    You've been busy! I see you've added Fervor, and CDR! Great work! Is there a way to equate EHP with Toughness in the spreadsheet, so players can estimate what toughness values they need to hit to reach a given EHP level? i.e. if they're not thinking of a specific item or have it for gear comparison, but realize for instance, "oh, I need to pick up X more toughness with my next two defensive upgrades to reach Y EHP level". Just curious! Again, great work!

    Oh and and I believe you overlooked CDR from paragon with the addition of CDR from gear to the spreadsheet!

    Thanks Loro, you do a lot for the D3 community and we laud (love?...whoa) you for it!
    Last edited by Hjalmr: 5/31/2014 3:31:59 PM
  • #5
    Yes, I overlooked CDR from gear for now, but I can add that pretty easily. In the mean time you can just put it into one of the gear slots as a workaround, just only use one cell per amount.

    As for toughness, I don't really plan to do anything with the value. EHP is practically the same as toughness anyway, it just doesn't include other affixes like elite reduction and melee/ranged reduction. In the absence of those extra effects, EHP is the same as toughness (though it won't exactly match the in game value for a few reasons that aren't worth getting into unless people are really interested in specifics). In other words, trying to add some amount of toughness to reach some EHP is a bit redundant.

    You can play with the extra fields a little and put in elite damage reduction and add some average of melee and ranged reduction to the elite reduction for a better indication of what your toughness would be.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • #6
    Quote from Loroese
    Yes, I overlooked CDR from gear for now, but I can add that pretty easily. In the mean time you can just put it into one of the gear slots as a workaround, just only use one cell per amount.

    As for toughness, I don't really plan to do anything with the value. EHP is practically the same as toughness anyway, it just doesn't include other affixes like elite reduction and melee/ranged reduction. In the absence of those extra effects, EHP is the same as toughness (though it won't exactly match the in game value for a few reasons that aren't worth getting into unless people are really interested in specifics). In other words, trying to add some amount of toughness to reach some EHP is a bit redundant.

    You can play with the extra fields a little and put in elite damage reduction and add some average of melee and ranged reduction to the elite reduction for a better indication of what your toughness would be.

    Fair enough, any chance you've gotten contact from Maikyl? He's trying to build on the very similar spreadsheet he developed from your wizard version but I don't see why...why have two pretty much similar spreadsheets when you guys could just work together on what is, in spirit and fact, your spreadsheet? If nothing else, he could give some direction for improvements? I don't know.
  • #7
    Yes, I've been in contact with Maikyl, and said I was fine with the attempt to release a version of the spreadsheet for the crusader. I just happened to have been working on mine last weekend, but ran out of time and wasn't able to publish it until this weekend, so the timing is just fairly coincidental. I think our ideas are just slightly different and Maikyl plans to add some things I'm not expecting to include.
    Wizard DPS and EHP Spreadsheet, mostly useful for wizards.
    Crusader DPS and EHP Spreadsheet, meant for Crusaders
    My Wizard
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes