+ Reply to Thread
Results 1 to 5 of 5

Thread: Effective Health Calculator Spreadsheet (Excel)

  1. #1
    Join Date
    Dec 2006
    Location
    Tacoma, Wa
    Posts
    8,766

    Effective Health Calculator Spreadsheet (Excel)

    This isn't mine, but it hasn't picked up alot of steam on the Warrior forums from the guy who posted it (probably because he did it on an alt and everyone assumes the link is a keylogger).

    http://www.freewebs.com/baalzebub/Ef...e%20Health.xls

    Seems accurate.

  2. #2
    Join Date
    Jul 2007
    Location
    Canada
    Posts
    2,390
    Here's an online version that does pretty much the same thing.

    http://www.tankingtips.com/effective-health-calculator/

  3. #3
    Join Date
    Dec 2006
    Location
    Tacoma, Wa
    Posts
    8,766
    Nice veneretio. Tankingtips is your own website?

    Oh, and from the WoW-US forums:
    um....im a lil skeptical, if i set enemy level to 50 my effective health is 220,168 but if i set it to 45 my effective health is -204,790 (yes negative)
    I tried it, and yeah, it goes negatives with lower levels. May be a PHP issue depending on how it is set up.

  4. #4
    Join Date
    Jul 2007
    Location
    Canada
    Posts
    2,390
    Ya as I mentioned on the us forums. It is not intended to work for level 1-59 since that uses the following formula.

    %Reduction = (Armor / (Armor + 400 + 85 * Enemy_Level)) * 100

    Where as level 60 and up uses...

    %Reduction = (Armor / (Armor - 22167.5 + 467.5 * Enemy_Level)) * 100

    So you can definitely see that when the enemy level is too low for that formula you'll end up with a negative reduction percentage.

    ---

    And yes tankingtips.com is my site that I've been putting together over the last couple months since I got tired of losing information and having to re-find it again and I found myself explaining concepts over and over again to guildies and friends alike. Suffice to say between a full time job, a life and a wow addiction it moves forward slower than perhaps I'd like

  5. #5
    Join Date
    Jul 2007
    Location
    Canada
    Posts
    2,390
    I updated the calculator noting what formula I used. I think you'll find that it should be perfectly accurate (rounding the decimals off) for level 60 and up mobs.

+ Reply to Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts