Gratuitous Spreadsheet Battles

Here is an updates spreadsheet detailing weapons, defenses and other modules. I’ll add hulls when I have more time.

The DPS number for howitzers and similar weapons are wrong. I know this. I don’t know how to calculate their DPS properly. If you can fill me in, please do so.

The file is a MS Excel spreadsheet - you can read it with a free viewer from MS’ website. (12.5 KB)

Those weapons have two extra statistics:


Weapons fire at the standard rate until they expend their salvo_size, then they go into a longer reload time as dictated by salvo_interval.

DPS is likely damage*salvo_size/(salvo_interval+((salvo_size-1)*fire_interval))

My own spreadsheets look like the scrawlings of a madman.

Thank you very much for this resource!

Its certainly been very helpful for balancing some of my modded weapons with those already in the game.

Yes, thanks for posting this resource, I found it helpful for learning the game. :slight_smile:

I’d also like to thank the creators of the following useful threads I also found helpful for learning:
Frigate and Cruiser Design Guide
The State of Fighter Design
Modules Stats Beta 1.10 current. Updated: 9/16/09 Ver: 1.15
Gunnery and Dying last: Defense on a budget
Guide: Positioning and Movement
My Counter to Cruiser Laser Spam w/o Using Cruiser Lasers
The State of Defence - A beginners guide…