Ships & Modules

I put together a quick spreadsheet containing the basic information available from zkillboard on individual ships, and then added a little bit of math to make comparisons a little easier using standard deviation z-scores.

Here's a quick preview (A download is further below):

https://i.imgur.com/WqIv4c8.png

An explanation of what you're looking at:

Rank: The current rating on zkillboard when I got the data
Name: Self Explanatory
All-Time Rank: All time rank on zkillboard
Isk Efficiency: The zkillboard isk efficiency rating
Isk Efficiency Grade: A z-score value indicating where on the bellcurve the ship is in comparison to all the other ships in the dataset
Kill Efficiency: As above with isk efficiency
Kill Efficiency Grade: As above again
Isk:Kill Avg: Took the average of the Isk and Kill efficiency ratings
Isk:kill Grade: Same idea as previous grade columns
Type: A general idea of what role or type of ship
Class: Ship size classification
z-scores: This tells you where a ship places on a bell curve. A quick rule of thumb using letter grades, which most people are familiar with:

S: 4.000
M: 2.600
A: 1.250
B: 0.390
C: -0.325
D: -0.700
F: -1.650
T: -3.000

Anything that is approximately A- (1.00 or higher) is color coded green. Anything that is D-- (-1.00 or lower) is color coded red.

I would very much like to turn the raw z-scores into actual letter scores like this for readability reasons, (essentially, associating a number or range of numbers to a character) but I don't know how to do this in excel.

High isk efficiency suggests a ship that destroys more isk value than it loses
High kill efficiency suggests a ship that kills more ships than it loses
High isk and kill efficiency suggests a ship good at both

Not included in the dataset:

Tech I and Tech II Logistics Frigates
Marauders
Mining Frigates
Exploration Frigates
Covert Ops Frigates
Capital Ships
Haulers
Special edition or rare ships

These (and the Catalyst) are not included in the data because they are outliers, or they are not very applicable to combat comparisons. I've also considered removing Battleships from the data, and in my current spreadsheet have already removed the Astero.

My goal was to give myself a quick idea of what ships have a good isk:kill trade off for PVP, and I figured, since I did the work, I might as well share it with others.

Download: https://www.mediafire.com/?lu38ziegcz3oplr

If you see something amiss (ship is the wrong color, faction type when it isn't, bad calculation, bad data input, etc.) or you have a suggestion on type classification (such as appending EWAR to the EWAR frigates) or ships that should be added/removed, please let me know.

I have considered the possibility of placing ships on a bell curve within their ship size class, or type class - however for most types/classes that doesn't leave very many data points to curve.

Quick update: https://i.imgur.com/EG7YTx7.png

I prettified the data a little bit, and I've started organizing alternate group comparisons.

So far I have:
ALL PVP
ALL SHIPS
Cruiser PVP
Frigate PVP

Version 3: https://www.mediafire.com/?8y5wzyl56te63f3