Ship Stats Spreadsheet

Spreadsheet of Ship Stats, including calculations of DPS, in front and side arcs at 3/6/9/12k, taking into account armour penetration and accuracy.

Now covers Imperial Navy, Chaos, Orc, Eldar, Space Marine AND Tau Fleets.

Introduction

I couldn't find all the ship stats in one location in a convenient format, so I started pulling this together for myself. Thought it might be of use to others. I'm sure there is a typo or two in there, drop a line if you spot anything.

Note:

• Raw DPS (Damage Per Second) for lance and macro weapons are calculated assuming (number of attacks) x (damage) x (60) / (reload time).
  
• Actual DPS = (raw DPS) x (accuracy @ range) x (penetration: 0.75 for lances, 0.5 for weapons batteries).
  
• Max raw and actual DPS for a ship is calculated in side and frontal arcs at 3-12k. A ship may not be able to produce its max DPS in each arc due to F 270 weapons.
  
• DPS from torpedoes, ordnance launch bays, nova cannons, cutting beams and other exotic weapons are not included.
  
• A future version will include bonus damage from ciritcals (fires and hull breaches).
  
• Ork ships are listed as having a number of weapon hardpoints, each hard point has it's own entry listing the weapon options. Ship DPS aren't calculated for Ork ships in most situations due to their customisable nature.
  
• Tau ships have been added, but as I haven't unlocked battlecruiser slots yet, the battlecruiser and battleship stats come from 3rd parties which I can't vouch for.

Imperial Navy

Chaos Renegades

Orc Pirates

Eldar Corsairs

Space Marines

Tau

[snakewhipmike]

Good stuff love it all.

[TGCMactar]

please no tau guide, solaire made one and he took it down cuz it got too popular.
do somethin more productive

[chaz]

thanks man, don't worry i will credit you for your work

[Rocky]

also, I can make the original google doc available to anyone who wants it.

[Rocky]

Please feel free to redistribute. If you put in a reference that would be a bonus :-) (you can take the man out of academia but you can't take the academic out the man it seems...)

[chaz]

hey, thank you for this. i making a guide on the tau fleet. could i use your work for illustrate a part?

[Rocky]

28/10/16 Added Tau ship stats, fixed bug with Slaughter DPS, and improved formatting of DPS columns.

[Rocky]

27/10/16 Corrected mistake in Ork and Eldar Accuracy Tables

[Orange Juice Goose]

noice

[Rocky]

09/10/16 Improved image quality and fixed typo in formula so DPS are correctly calculated taking account of weapon ranges.