Author Topic: Avoidance and Mitigation AC Spreadsheet  (Read 7108 times)

Marshall Maathers

  • Slacker
  • *
  • Posts: 6
  • Karma: +2/-0
    • View Profile
Avoidance and Mitigation AC Spreadsheet
« on: April 18, 2014, 06:26:45 AM »
Hey folks,

As many of you may already know, Dzarn spilled the beans on many facets of how avoidance ac and mitigation ac are calculated based on your gear, heroics, skills, etc.

The post is found here: https://forums.station.sony.com/eq/index.php?threads/ac-vs-acv2.210028/

I have taken the information and made a first take at a spreadsheet based on the info so people can play around with it and see what different changes will make on their different ac values.

The spreadsheet works for the example Dzarn posted, and it is 1ac low when I test with my values. I need people to "beta" test this to see if it works for you all and what bugs I might need to fix in future versions.

Hope it is helpful to you, and please let me know of any discrepancies between what my sheet says your displayed ac should be, and what it really is, after you have plugged in your data.

NOTES:

I haven't fully implemented the weight penalty for monks. It acts as if you are purely under your weight soft cap.

It only works for L100 toons with 18 Armor of Wisdom.

You either need a magelo to extract your ac from gear, or you can manually tally up all gear pieces. Make sure not to double count food and drink ac like I did at first.

Have fun.

Marshall Maathers

  • Slacker
  • *
  • Posts: 6
  • Karma: +2/-0
    • View Profile
Re: Avoidance and Mitigation AC Spreadsheet
« Reply #1 on: April 21, 2014, 09:48:02 PM »
For some reason when I saved this file, the changes never updated.

I had a problem with the warrior scaling factor for having AoW 18. The new version is attached here.