From your (brilliant) table, it appears that training spears are actually several times more powerful than metal spears. Is this true? Should we be arming all our speardwarves with training spears?
Heck no! All weapons have a primary attack and some have one or more secondary attacks, in the case of spears "stab" (edge) is the primary and shaft bash (blunt) is the secondary, notice how the training spears have the same attacks but the "stab" is no longer an edge attack but a blunt attack instead.
The table is colour coded gray for blunt attacks and cyan for edge attacks.
The stab attack of the Spear is 800 more than 5x the penetrating power of a bolt, and if it fails to penetrate it does 20,000 blunt attack, close to a Maul.
In the other hand a Training Spear stab attack is blunt so it won't penetrate or cut and is only 2,000, 1/10th of the Spear's stab when it becomes a blunt attack and 1/3rd weaker than a Short Sword's pommel strike...
So a Spear will cut and pierce and failing that can even break bones, instead a Training Spear at best will probably only bruise.
Do weapon traps use any of the secondary attacks or only and exclusively the primary? if only the primary, then training swords are the safest to put in a danger room, if the use all then training spears.
Also the "material multiplier" of metal is much higher than wood, I did the calculations using a multiplier of 1, as you can see on orange at the bottom of the table along with the "Wielder Strength" that also varies from creature to creature and among individual creatures.
The "material" columns on the right, are the availability of the weapons for the dwarves, it's also colour coded, red are combinations of weapons-material that can only be done by strange moods, orange are foreign made, and green can be made by your dwarves on command.
By "obsidian" I mean "obsidian and other stones" the only exception are obsidian short swords that need obsidian and wood, and a short sword made with other stone would need a mood.
The "used by" columns indicate which entities are able to make the weapons.
The weapons name that are highlighted on cyan or gray mean the best possible weapons edge and blunt weapons, there are some ties and I also highlighted the top best of its kind and the top best that can be made by dwarves:
The best Slash weapon: the Halberd (foreign) and the Battle Axe (dwarf made)
The best Pierce weapon: the Halberd (foreign) and the Pick (dwarf made)
The best Blunt weapon: the Scourge (foreign) and a tie between the Mace and War Hammer (dwarf made)
The things highlighted in yellow are assumptions by me, I didn't find the data so I assumed those values. If the velocity is correct for the projectiles the best are:
The best Pierce projectile: the blowdart (foreign)
The best Blunt projectile: a tie between the dart (dwarf made) and the arrow (foreign)
Since I'm not really sure I didn't highlighted them... I also made up the name of the attacks, but that's just cosmetic...
The same goes for the trap components, assuming a velocity of 1 they outperform many weapons if it's higher...
the massacre....