Gratuitous Spreadsheet Battles


#1

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.
gsb_modules.zip (12.5 KB)


#2

Those weapons have two extra statistics:

salvo_size
salvo_interval

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.


#3

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.


#4

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…