Originally Posted by mistla
I am looking at 92.b of the spreadsheet. One the Calculations worksheet in the Armor Penetration block. The calculation for the armor Constant looks correct when compared to wowwiki, but the Level_Selected parameter appears to be set to 80 when the boss level is set to 83. The result is a Constant of 15232.5 for a level 83 boss.
I am wondering if wowwiki has it wrong, I have my spreadsheet setup wrong, or there is a possible bug with the calculation. Can anyone else confirm or deny?
|
My understanding, and how I believe the spreadsheet is coded, is the following:
The level armor constant of 16635 for level 83 targets effects how much armor they have. This is already factored into the target's armor amount. Different levels of targets and their armor constants factor into the armor amount for target's of various levels.
The reason that the level 80 armor constant of 15232.5 is used in the calculation of the ArP cap is because it is believed that the attacker's level affects the maximum amount of armor that can be penetrated. Hence, the armor constant for our level is used to determine the ArP cap.
Thus, both our level and the target's level factor into how much of the armor can be penetratable.
Here is another way to look at it. Say if there are two targets with the same amount of armor, but one is level 80 and one is level 83. One would think that we would be able to penetrate an equal or lesser amount of that armor on the level 83 target than the level 80 target since it should be harder to kill. If the armor constant for the target was used in the ArP calculation, then we would actually be able to ignore more of the armor on the 83 target than the 80 target as shown, making it easier to kill instead of harder.
If target's level was used in ArP cap calculation:
- Level 80 target with 10K armor results in 8411 ArP cap
- Level 83 target with 10K armor results in 8878 ArP cap
With using the attackers level to determine the armor cap, we ignore the same amount of armor on a level 80 and level 83 target with the same base armor; however, since level 83 targets will tend on average to have higher amounts of armor than level 80 targets due to the higher armor constant, more of the armor on average level 83 targets will be unpenetratable.