I'll see if I can't cover this tomorrow.
Really the gripe is about methodology (take a look at your calculated ratios.
Cost/Output is clearly done by dividing the average cost by average output.
But, Mass/Output is not. I'm betting when you look at your numbers, it will turn out that you calculated a value for each individual reactor, then averaged them.
Second, while I don't think this is a simple evaluation, you've actually duplicated yourself with what are known as dependent variables.
A "dependent variable" is something like your calculated ratio of Cost/Output if and only if you also include the variable separately in your evaluation. Don't use Cost & Output & Cost/Output as three different rankiing values, unless it is your intention to give them more weight. Weighting would be where you figured out the rankings for something like Cost, but deliberately included that ranking 2 or more times because it was a really important variable.
The right answer is to do either the ratio and not use Cost or Output - or vice versa.
-
But, I don't think it's that simple to evaluate warp cores for the races.
So, what I propose again is this.
In order to get a good analysis, you must use realistic numbers. Nobody is going to put a Level 1 reactor into a Battleship. They can, but it won't be real effective - in fact, the ship almost becomes completely useless except for perhaps warping around the map.
Look at each individual hull - look at the engine that comes on a stock shiplist and get the specs and calculate most of your values. Then, swap in an engine one size smaller, if possible, and then swap in larger engines until you can't fit anymore. Most likely, these are all of the viable potential options. Players *might* reduce warp cores in favor of impulse/thrusters, for example.
From here, the real rankings go into place.
Provide a summary spreadsheet of all engines for each hull with ratios.
Provide an average for each hull (averaging values consistently)
Provide an average for each race (averaging only the engines selected previously)
If you're adept with spreadsheet formulas (I am) - you can setup a lookup table with all engine values, then type in engine types, make it lookup and calculate the required values. Might be a fun task as it could be reused whenever the raw data changes. Might even be a good tool to give to server admins when they're looking at tweaking their ships just to give them a quick way to evaluate the numbers as a whole.
Nax