Demon Hunter DPS Calculator

  • #201
    Quote from upchuck1383

    Why is it when I select the drop down menu to toggle from crossbow to bow, the only item in the menu is "0"? I tried all of the spreadsheet downloads. What am I doing wrong?


    I have no idea. Nobody else has ever mentioned such a situation. What do You use to open the spreadsheet? MS Office,googledocs, Open Office, or smth else?

    EDIT: Also, try simply writing Bow or Crossbow or Hand Crossbow in the cell.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #202
    If I try and type "Bow" into the cell, it just prompts me to select a weapon from the dropdown menu. I use open office, the free version.
  • #203
    Quote from upchuck1383

    If I try and type "Bow" into the cell, it just prompts me to select a weapon from the dropdown menu. I use open office, the free version.


    Draco_Draco, You use open office as well right? Do You have any clue on the situation in question?

    In the meantime upchuck, just go on with the googledocs version since it does not have protected cells even if you download the file, so You can type in Bowetc easily.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #204
    Google Docs worked, thanks. Great spreadsheet!
  • #205
    Quote from Dretar

    Quote from upchuck1383

    If I try and type "Bow" into the cell, it just prompts me to select a weapon from the dropdown menu. I use open office, the free version.


    Draco_Draco, You use open office as well right? Do You have any clue on the situation in question?

    In the meantime upchuck, just go on with the googledocs version since it does not have protected cells even if you download the file, so You can type in Bowetc easily.

    Nope, it works just fine for me, I get all 3 options :/
  • #206
    Quote from Dretar

    Warning, wall of text :).
    Base Sheet Information is a "YES/NO" info box that the User can edit and check the properties of his target, that is:
    1) Is it Elite (so the sheet knows whether to consider +X% dmg vs elites"
    2) Is it slowed (so the sheet knows whether to consider the dmg bonus from Cull The Weak assive (If used)
    3) Is it targeted with Marked for Death (for the dmg benefit).

    All of these benefits are only considered in the Row "Final DPS considering Base Sheet Info".
    I made it separately, because this DPS is "hypothetical" and will never (unless u put "NO" everywhere" match the character sheet DPS in the game.

    It's an option for "more advanced users" who are familiar wit the sheet and want to compare for example their dps when selecting bewtween Archery or Cull the Weak passive.. (If you assume the enemy is always slowed, by using Entlangling shot or caltorps for example it is a great method for choosing which passive serves You best, but still can calculate the Char sheet DPS by looking 2 rows above to the "FINAL DPS",


    Thanks! I thought it was calculated this way, just wanted a confirmation :)
  • #207
    Due to many requests of the unprotected versions i also gave a link to it in the main post.

    But remember, If You want to post a "bug complaint" or want me to help You with something You think is an error I will not consider them unless you use the protected version - since You simply could mess up the formulas.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #208
    Hi, I've been using your spreadsheet like it's the next best thing in the world since Diablo came out but I have a slight problem right now. I've just changed my belt and am currently using Inna's Blessing which adds +6% Holy Damage. How do I insert this value in your spreadsheet?
  • #209
    Quote from Fye

    Hi, I've been using your spreadsheet like it's the next best thing in the world since Diablo came out but I have a slight problem right now. I've just changed my belt and am currently using Inna's Blessing which adds +6% Holy Damage. How do I insert this value in your spreadsheet?


    You can't atm.

    I Will add up such functionality soonish.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #210
    Version 1.6 is up. See main post for changelog.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #211
    Thanks to a fast feedback response i got information that 1.6 is bugged, it's in the middle of fixing now that i received Inna's Glory to test.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #212
    Quote from Dretar

    Version 1.6 is up. See main post for changelog.

    Quote from Dretar

    Thanks to a fast feedback response i got information that 1.6 is bugged, it's in the middle of fixing now that i received Inna's Glory to test.

    Thanks for the fast update, looking forward to the fixed version.
  • #213
    not needed anymore :D
  • #214
    Hey Trulala!

    Thanks for the response, but SW is fixed and working, i'm working on dual wield now, which is a bit more complex.

    EDIT:

    I have used the same (but written in a different manner) fix for that since i was in a hurry. But your formulas were correct as well.

    Thanks for Your support!
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #215
    1.61 is up.

    I think it should be fine now for both SW and DW.
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #216
    Quote from Dretar

    1.61 is up.

    I think it should be fine now for both SW and DW.


    DPS value is still off by ~2000 with the current calculation of Elemental Damage
  • #217
    Quote from Fye

    Quote from Dretar

    1.61 is up.

    I think it should be fine now for both SW and DW.


    DPS value is still off by ~2000 with the current calculation of Elemental Damage


    Please send me the screenshots of your gear and your stats in game with and without sharpshooter maxed and the filled in spreadsheet (protected version). I'll check that out.

    [email protected]
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #218
    1.62 is up.. 1.61 did not consider the bonus min dmg from set bonusses for the sake of +X% ele dmg.

    Trying to do things to fast which results in stupid mistakes..
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • #219
    Quote from Dretar

    Quote from Fye

    Quote from Dretar

    1.61 is up.

    I think it should be fine now for both SW and DW.


    DPS value is still off by ~2000 with the current calculation of Elemental Damage


    Please send me the screenshots of your gear and your stats in game with and without sharpshooter maxed and the filled in spreadsheet (protected version). I'll check that out.

    [email protected]


    Sent. Let me know if you need additional data.
  • #220
    Quote from Fye

    DPS value is still off by ~2000 with the current calculation of Elemental Damage


    A question first. Have you read the instruction i posted in the main post?

    Because:
    1) You did not input the Min elemental dmg from your weapon.
    2) (Also you mistyped the max dmg from your weapon - 1222 instead of 1221 (but since the weapon has +X% dmg it might be showing different values in profile screen and char screen sometimes).

    After proper data entry the error is of 23 DPS, which results from +30% dmg bonus on your weapon (rounding).

    So PLEASE do not say that the spreadsheet is bugged when, simply You make a mistake.

    I am starting to get tired of that. :( :QQ:
    Demon Hunter DPS calculator - http://www.diablofan...dps-calculator/
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes