AS&SH Average Damage per 2 Rounds

I have made another spreadsheet that I thought might interest others as well. This time I was calculating the average damage output of various weapons in AS&SH.

Here's a breakdown of what's in the spreadsheet:

• Average damage output was calculated for all FA/HD levels vs. all non-negative AC values.
• The numbers show average damage in 2 combat rounds (!) because the number of attacks often alternates.
• Each sheet contains details for a single type of weapon (such as bows, light/heavy crossbows, 1d8 melee weapons, etc.).
• "Dmg" is for the weapon's average damage, "To-hit" and "DmgB" cover bonuses from high attributes and weapon mastery, while "#Atk" and "#Atk7" show how many attacks are made in two rounds level 1-6 and 7-12, respectively.
• Melee weapon damages are calculated with fighter types in mind (other characters have the same attack rate throughout all levels).
• Four primary circumstances are covered: (1) no mastery, average attributes, (2) no mastery, high attributes, (3) mastery, average attributes, and (4) mastery, high attributes. Details are added in notes.
• The last four sheets cover the following special cases: (1) bow vs. damage reduction 1, (2) light crossbow vs. damage reduction 1, (3) bow vs. damage reduction 2, and (4) heavy crossbow vs. damage reduction 2.

Here are my findings:

• Weapon mastery is even stronger than I suspected. Without weapon mastery, it takes 2 rounds on average for a 1st level fighter to kill a zombie (HD 2, AC 8). With weapon mastery, it takes only 1 round.
• A fighter with a two-handed sword (3d4 dmg) has a lower average damage than a fighter with a longsword (1d8) having mastery (until level 6 at least). Note that these numbers don't take damage reduction into account (but also note that monsters don't usually have damage reduction).
• Crossbows are supposed to be better against armoured opponents, but the fact is they are outperformed by bows (provided the archer is stationary). Light crossbows outperform bows against medium armour only if the archer moves before shooting (thus having a reduced rate of fire). Heavy crossbows are even worse against heavy armour: they only outperform (moving) archers from level 7 and on.