Dps/EHP/stat spreadsheet for all classes. menu

User Tag List

Results 1 to 1 of 1
  1. #1
    Thrill12's Avatar Active Member
    Reputation
    52
    Join Date
    Feb 2009
    Posts
    158
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Dps/EHP/stat spreadsheet for all classes.

    My friend sent me the link to this today and I found it pretty useful.

    https://docs.google.com/spreadsheet/...HRDduYnc#gid=1

    First off you have to sign in to google/gmail and make a copy of the file and enter in whatever name you want and it will allow you to edit.

    Enter in all your current gear information, what class you are, and what buffs you're using. After all that you can compare stats of another item by entering the information next to your items information to what you have equipped and it will compare and tell you how much dps you gain/lose, life you gain, etc.

    I'm not very good at explaining it but it's really simple to figure out. There is a read me that leads to a walkthrough on redditt: EHP & DPS spreadsheet : Diablo

    Walkthrough from Reddit:
    New and improved version of my old EHP spreadsheet. By now, everyone probably knows the value of tools like this, so I won't go into a lengthy explanation, but just show how to use this:

    first "File → Make a copy...", to get write access;
    edit Character, Character level, Monster level;
    edit all equipment stats, you don't have to sum anything together, simply enter them as you see on your item (except for gems, add stats from them to the item stats);
    check that calculated values (gray tables) match what you see in game;
    enter stats from a new item to the right of current item stats and note how your survivability and damage changes;
    optionally, edit formulas in the gray tables, to account for various buffs (e.g. for enchantress +15% armor skill, edit U9 to "=T9*1.15" and W9 to "=V9*1.15");
    optionally, press "Diablo → Rank equipment" from the top menu and those two colors, to the right of item names, will change, to reflect how good each item is at defense and offense.

    EDIT1: Small update, now you have to enter weapon Base Attack Speed and IAS, because Attack Speed that's shown on weapons is rounded and won't give accurate result. Thanks tetracycloide, mmatia, wickermoon. Only formulas in B69, C69, B72, C72, B84, C84 were changed, so you can try and copy them over to your spreadsheet.

    EDIT2: Once you made a copy, please close the original document, so that other people can access it, Google allows only so few people to view it at the same time. I made three copies, in case anyone still can't access it: 1, 2, 3.


    Credit goes to Lupus, I just thought some people might get some use from it.

    Dps/EHP/stat spreadsheet for all classes.

Similar Threads

  1. [How-To] Massive DPS/HPS/TPS for all classes!
    By Nitachi in forum World of Warcraft Guides
    Replies: 24
    Last Post: 02-15-2011, 02:04 PM
  2. Small dps increase for all classes
    By IJakobI in forum World of Warcraft Exploits
    Replies: 21
    Last Post: 01-13-2011, 02:42 PM
  3. [Guide] DPS Rotation for ALL CLASSES!
    By [AfterBurner] in forum World of Warcraft Guides
    Replies: 46
    Last Post: 10-23-2009, 04:45 AM
  4. WPE Filters for All Classes
    By Örpheus in forum World of Warcraft Bots and Programs
    Replies: 28
    Last Post: 12-05-2006, 02:19 PM
  5. Breack out of sap for all classes
    By scraman in forum World of Warcraft Exploits
    Replies: 24
    Last Post: 11-21-2006, 12:03 PM
All times are GMT -5. The time now is 06:33 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search