I know there isn't one set of values that can be used to do the math for it, but does anyone have an idea if spears actually are better against cavalry in this game? I know they get a +8 bonus, but then longswords and other high lethality weapons compensate for that by having a higher chance to kill.
Take Galatian Heavy Spearmen vs Hellenic bodyguard cavalry.
Sword: 11/30*0.225 = 0.0825
Spear: (12+8)/30*0.13 = 0.0866
(NOTE - I compensated for all the +4 bonuses that were given prior to the spear --> light_spear transition in my EDU)
This is only one example, but in general is there is anyone who knows if spears are actually worth using against cavalry rather than longswords and getic weapons? I know they are better than shortswords, but higher lethality swords seem to have almost the same effectiveness against mounted units.