Tweet
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:
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
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
I've got some gemless gear that would be better than what I'm using, but no good gems for it 
Comment