|
Additionally, Chalon modeled Crusader at 37 str MH and 24.5 str offhand. How did he come to those numbers?
|
Those numbers are just from Kalman's uptime table, which he derived using a Monte Carlo simulation in MATLAB. The main hand value actually will change depending on what weapon you have equipped, whereas the off-hand is constant since you don't have any specials which use the off-hand. For a warrior the numbers are going to be different.
|
Separate question for anyone. Does Kings multiply every stat, regardless of source? As in, does it work on other buffs, like fort?
|
Yeah, anything that directly modifies a stat will get a kings bonus. So for instance a 54 sta fort would be a 59 sta fort if you have kings.
As for VLookup, this explains it fairly well:
http://www.mvps.org/dmcritchie/excel/vlookup.htm
But I guess the short story the way those are setup:
-I made a named range for just the item names themselves. (eg., WeaponsList)
-This named range is used for the validation list in that cell (to create the drop-down)
-Then I created another named range that includes both the item names and the stats (eg., WeaponsStatsList).
-Then the VLookup is applied to WeaponStatsList