Actually, that would be amusing to do, but I'm just using Excel to compare unit-vs-unit performance while I rescale it all to a new baseline (10,000 health Fighter is my base), reworked Armor system, reworked Hull bonus system including splitting hull size out from hull type. If I have time, I'll crank in the old system because I'd like to do a comparison of how each ship match-up goes under each. I'm trying to keep stuff reasonable close. There is also an economic rework I'm playing with, but it is independant of the combat rework. It is just kinda fun, so I'm entering the data for it in the same spreadsheet.
By the way, what is up with the build time multipliers for Marks, specially Mark V? I got these to go from Mark I build time to Mark V:
I x1.000, II x2.000, III x3.985, IV x5.970, V x8.209. It's odd that II isn't x4 and IV isn't x6, but its only a second or two different. But V just seems way off. Again, this is on Normal Speed/Normal Caps.
Here is an example of my WIP combat results page:
PS: Bah on not having number of shots in the debug export. It's in the CSV export from the reference so I'm cross-referencing. But that's pretty annoying. Also sad there isn't anything that marks if a ship type scales with different cap settings. I'm having to set that data by hand.