Defense Stats for dummies (Spreadsheet)

[whyzerman]

I have been looking for weeks to find a spreadsheet that would simply give me actual in game values for defense/shield/absorb%. Every sheet I looked at gave me different values then what appeared in my character tab in game. So what I attempted to do was use the formulas from these forums and plug those in using my in game stats. I had to tweak the formulas a bit, but I think I did it. I need some help testing this from classes other then assassins which is why I am here.

I am asking people to take the values from their in game stats, and plug them into this spreadsheet and let me know if the values match what shows up on their character tab. Please make a copy of the sheet before you plug your values in though. I have the spreadsheet backed up, however I would like to get an actual test on this spreadsheet without someone screwing up the formulas.

Here is a link to the spreadsheet, the instructions are very basic, so if you run into any problems please post here so I can fix them or clarify what value is needed in each field.

https://docs.google.com/spreadsheet/ccc?...Pb0E#gid=0