1. To login into the forum, use the GAMESinFLAMES Account you created on your first login into the game.
    Dismiss Notice

Google Spreadsheet with Gear Info

Discussion in 'Guides' started by EddArslon, Nov 2, 2016.

  1. EddArslon

    EddArslon Member

    Joined:
    Nov 2, 2016
    Messages:
    156
    Likes Received:
    16
    https://docs.google.com/spreadsheets/d/1nDMzbRY59x-ZcVXyQ22yrkPLDhwprgPD7AVJpirYWUY/edit?usp=sharing

    I am putting together some informational spreadsheets for use.

    Some personal thoughts on Stats:
    1) Armor Penetration does not do well against heavy armor targets
    This is based on the assumption that damage reduction is calculated by this formula:

    %reduction = Armor / (100 + Armor)

    Armor Reduction
    0 0.00%
    25 20.00%
    50 33.33%
    100 50.00%
    200 66.67%
    300 75.00%
    400 80.00%
    500 83.33%
    600 85.71%
    700 87.50%

    1b) Magic Resistance
    MR, EP-cost, %reduction
    25 500 20.00%
    50 1000 33.33%
    75 1500 42.86%
    100 2000 50.00%
    125 2500 55.56%
    150 3000 60.00%
    175 3500 63.64%
    200 4000 66.67%

    100 MR is achievable and is recommended (maybe more)


    2) There is little benefit over 450 armor, you will want to switch your stats over to something else.
    (550 if you take into account armor penetration)
    -- I count this as a Maximum
    -- I would not suggest going below 300 as armor penetration is very effective below this value.

    3) Attack, Armor, Magic Resist are the only Enhancements on gear that make sense
    (Health regen - maybe)
    -- See estimated values in #4

    4) Estimated EP Value are below as a 1 to 1:
    Health 1.0
    Attack 20.0
    Armor 15.0
    Armor pen 13.3
    AIS 32.0
    AP 29.3
    MR 20.0
    Life Steal 125.0
    Health Regen 20.0
    Critical 10.0
    -- 1 critical value is estimated at 10 EP Value... 10 critical value is estimated at 1% critical rate
    -- EP Value varies based on actual attack damage
    mana 1.0
    mana regen 40.0
    Cooldown 300.0
    Thorns 1000.0

    These values are estimates of the amount of EP it costs for these stats to be on a piece of gear
    -- This is not a comparison of which is best, but rather a way to assign a value to a stat based on what you theoretical can get now and in the future.



    5) Armor penetration begins to fall off after your target has more than 250 armor, which you can assume everyone is at or above this value given armor rolls on enhancement A = 24 (192 if on 8 pieces)

    38 attack = 100 armor pen versus 500 Armor
    50 attack = 100 armor pen versus 400 Armor
    75 attack = 100 armor pen versus 300 Armor
    100 attack = 100 armor pen versus 250 Armor
    150 attack = 100 armor pen versus 200 Armor

    Armor penetration is worth while if you needed added damage on PvE targets

    6) Recommended HP

    Base HP = 1160 (may vary by class)

    4200-5250 recommended HP
    -- This is an observation, based on play-time and reviewing gear
    -- Thorns armor appears to reflect full attack damage back (your AD times 0.3)... this is usually about 100-170 and is not reduced by your armor!


    7) Recommended Attack Speed
    60% for guardians (Bracelet + Boots)
    -- based on observation at 680 speed versus 990 speed on my Guardian, the attacks per second GREATLY increase damage output
    Punishers can go lower if they use a EoD Dagger because the Q ability gives AIS
     
    #1 EddArslon, Nov 2, 2016
    Last edited: Nov 3, 2016
  2. salkz

    salkz New Member

    Joined:
    Oct 29, 2016
    Messages:
    28
    Likes Received:
    2
    Nice read I was suspecting something like this becouze when I downgraded from 750 armor to 600 I didnt notice diference.
    Now about magic resistance I belive it work in same if not very similran way about dmg reduction.
     
  3. Nabbith

    Nabbith Member

    Joined:
    Oct 18, 2016
    Messages:
    42
    Likes Received:
    8
    I have almost the same spreadsheet :eek:
     
  4. EddArslon

    EddArslon Member

    Joined:
    Nov 2, 2016
    Messages:
    156
    Likes Received:
    16
    Let me know if you have something I don't. We can add it.

    Added 5/6/7 to original post
     
  5. Nabbith

    Nabbith Member

    Joined:
    Oct 18, 2016
    Messages:
    42
    Likes Received:
    8
    I can't look into it now. But I didn't add all the gear (like trashy stuff no one uses), so you probably have more stuff.
    I also use another formula to valuate EP cost per stat, so it's hard to compare right now.
     
  6. 8lueknight1

    8lueknight1 New Member

    Joined:
    Feb 23, 2017
    Messages:
    10
    Likes Received:
    0
    Thanks so much for this! :O
     

Share This Page