Went through the same thing. So i came up with this spreadsheet, that is a bit more friendly:jinks67 wrote:
Recently I've decided to do a complete and thorough overhaul of the ship stats to alter how combat plays out. Seemed like a great idea at the time, however I'm now knee deep in a giant spreadsheet that makes my head explode!
http://www.4shared.com/file/dtli548x/Sh ... or_11.html hope it helps you.
I only used it and tested it for UDM but the factions are not hard-coded but taken from the html ship list so it should work for other mods too.