The ranged weapon proficiencies on the hidden section of the Attacks sheet are incorrectly calculated, owing to the "Improvised Melee" line in the Weapon section of the Class Overview sheet.
For example, the formula in cell AA50 of the Attacks sheet presently begins:
Code:
=IF(OR((HLOOKUP(Class,'Class Overview'!$3:$23,17,FALSE)=TRUE)...
It should instead begin:
Code:
=IF(OR((HLOOKUP(Class,'Class Overview'!$3:$23,18,FALSE)=TRUE)...
Note the change from "17" to "18" in the HLOOKUP function. The same change is needed in AA51 and AA52, as is a similar change from "18" to "19" in AA54 and AA55, and from "19" to "20" in AA57. This adjusts the ranged weapon proficiency lookups to examine the correct table rows.
And yet another word from our sponsors
