Hi all,
I am working on a project and I am a bit stuck when it comes to calculating the weapon attack speed and attribute requirements for certain items.
I will be using the level 50 “The Butcher of Burrwitch” as a reference.
Weapon attack speed
There are two fields with values populated on the item record when I look for attack speed:

The tag just references a string, while the base attack speed does not really seem to correlate with anything.
The attack speed in game for this weapon is 1.78 base, so how would one get to that value from the available data in the DB?
Attribute requirements
There are once again two fields that look relevant here, one being the attribute scale percent and the other being the reference to the calculation formulas:

Looking at the available formulas, this seems to be the logical one to use:
0.92*(0.31*((itemLevel22)+6.5((damageAvgBase0.8)(1+(damageAvgPierceRatio/100)))-10*(0.05*(itemLevel^1.62)-1))-4)
“itemLevel” and “damageAvgBase” seems quite self explanatory, but what would the value for “damageAvgPierceRatio” be?
I cannot find any reference to that field on the item record, unless I am completely off track here?
Any help here would be much appreciated.