Page 1 of 5 123 ... LastLast
Results 1 to 10 of 43

Thread: Spreadsheet - Calculate your effective stats with Pierce & Resistance!

  1. #1

    Post Spreadsheet - Calculate your effective stats with Pierce & Resistance!

    The impact of Pierce and Resistance on your PvP strength is huge. However there is no easy way to calculate by how much your stats are actually enhanced by your Pierce and Resistance.

    Retribution determined the formulas (best guesses) and created a spreadsheet to easily calculate your effective Attack and Defense.

    And there it is:


    --- CALCULATOR - Piercing and Resistance impact on Attack and Defense stats ---


    All you have to do is enter your attack and defense values (pierce and resistance boost everything) and your pierce and resistance amounts and you get your effective stats as a result.


    Keep in mind that the results you get however are your stats IF you opponent had no piercing (if you're being attacked) or no resistance (if you're attacking him).
    Indeed, the bonus provided by your own pierce and resist depends on your opponent's pierce and resist values; and most of the time, a big chunk of it will probably be negated.

    That said, personally, I find this spreadsheet awesome



    --------------------------
    Edit [June 11, 2019]:

    Spreadsheet link above updated.

    It now allows 2 new things:
    • Calculate your eBSI (and eAtk / level and eDef / level)
    • Simulate battles between 2 players

    The spreadsheet now has 2 additional tabs called BattleSim and BattleSim2, which allow you to simulate battles between either you and any other player, or between any 2 players.
    These are pretty much the same tabs, except that in the first one, your own stats are already filled (imported from the first tab (Calculator)), so you only have to fill your opponent's stats. But in case you want to use other stats to simulate the battle, you can use BattleSim2 to fill stats for both players.

    Just fill the stats (atk/def and pierce/resist), and the spreadsheet will display who should win the duel.


    Other than that, Badpuppehs (on Discord) put up a Google Form to gather eBSI data from all players:

    --- Pierce and Resistance Calculator Data ---

    I think he wants to eventually make graphs like those in this post:
    http://www.castleageforums.com/cforu...eed-Index-(LSI)
    But with data relevant to today's standards
    Last edited by gogoo; 06-11-2019 at 11:20 PM.

  2. #2

  3. #3
    Join Date
    Mar 2010
    Location
    as far away as possible from the rest of the world <_<
    Posts
    22,781
    Blog Entries
    5

    Default

    It doesn't factor in the so called threshold bonus which some would say makes it useless

    I think it's still good to give you an idea, since I don't know how much these threshold bonuses will actually come into play day to day, or if they will, you're probably a 2k player hitting some level 500 with no gems and you would have won anyway

  4. #4

    Default

    Quote Originally Posted by Will Cochrane View Post

    Quote Originally Posted by zserg View Post
    It doesn't factor in the so called threshold bonus which some would say makes it useless
    Yep and as you can see, it doesn't differentiate physical from elemental, while physical is better (roughly, elemental only gives about 80% of what physical gives you).

    Edit:
    Also it doesn't take into account General & Equipment stats which are also boosted by Pierce and Resistance (although you can add them to another field (like the "Attack" field) if you know they count and want to calculate your effective attack with pierce).

    All in all, I don't get the same results at all using this website and the spreadsheet.
    Last edited by gogoo; 03-26-2019 at 04:48 PM.

  5. #5

    Default

    43K / 29K.
    Could anyone with level >800 and BSI > 6 post their stats for comparison?
    (Using spreadsheet)
    Last edited by Barathor; 03-27-2019 at 12:43 AM.

  6. #6
    Join Date
    Mar 2010
    Location
    as far away as possible from the rest of the world <_<
    Posts
    22,781
    Blog Entries
    5

    Default

    Quote Originally Posted by Barathor View Post
    43K / 29K.
    Could anyone with level >800 and BSI > 6 post their stats for comparison?
    (Using spreadsheet)
    37073 Attack Defense 35 780

    Check if you can break me ?

    Seems like you should

    https://web3.castleagegame.com/castl...ser=1491912182
    Last edited by zserg; 03-27-2019 at 08:24 AM.

  7. #7
    Join Date
    Oct 2014
    Location
    London, England
    Posts
    454

    Default

    54303 eAtk 54053 eDef

  8. #8

    Default

    I tried Zserg. Invade yes, duel no. I lost the first war try but fixed my war council, hadn't looked at it in a long time and the second try won.
    29,972/26,498 if I did it right.
    Last edited by FiveMinuteRule; 03-27-2019 at 01:48 PM.
    I like Ginger Ale!

  9. #9

    Default

    Quote Originally Posted by zserg View Post
    37073 Attack Defense 35 780
    Check if you can break me ?
    Seems like you should
    I can beat your Daphne loadout, but I guess that is the one you have for guild defense purposes, not your pvp alone purposes because I remember losing to you in the last Arenas/Deathmatches.
    I have improved my gear, specially my gems since then, but I didn't expect to win now. One of my latest goodies:

    I tried invade, first with Chase and then with my regular pvp. Won too, probably thanks to my many items from Vargulis.
    Last edited by Barathor; 03-27-2019 at 02:19 PM.

  10. #10
    Join Date
    Mar 2010
    Location
    as far away as possible from the rest of the world <_<
    Posts
    22,781
    Blog Entries
    5

    Default

    Quote Originally Posted by Barathor View Post
    I can beat your Daphne loadout, but I guess that is the one you have for guild defense purposes, not your pvp alone purposes because I remember losing to you in the last Arenas/Deathmatches.
    I have improved my gear, specially my gems since then, but I didn't expect to win now. One of my latest goodies:

    I tried invade, first with Chase and then with my regular pvp. Won too, probably thanks to my many items from Vargulis.

    I could make a slightly better loadout for def, but I don't have one right now. That's the loadout I keep on these days as def and it's the one with the 35k figure.

Posting Permissions

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