Page 1 of 2
Weapon Damage and Armor Info
Posted: Tue Jan 11, 2011 10:39 pm
by unclean
I wanted to get a better understanding of the weapons (especially with tech upgrades), so I dumped all their stats into a spreadsheet. This also lets you figure out some useful stats not shown in game, like DPS per size, burst damage per size, energy used per second/Size and energy efficiency, plus there's some funky looking visuals.
There's also an armor selection drop down so that you can see the effects of different armor vs phasers, missiles and what not.
Weapon DPS per size vs shields:
Weapon DPS per size vs reactive armor (second best):
Y axis is weapon DPS per unit of size, X is weapon type and upgrades, while Z is distance from 0-990.
Individual weapon comparisons of the same here:
1 2
About this:
-Weapon DPS is per unit of size, with range 0-990 on the Z-axis
-Just treat this as a baseline. Range is arguably more important than sheer damage in practice.
-This also doesn't take accuracy in to consideration. Beam weapons for example have terrible accuracy at range, while torpedo weapons always hit.
-Range is roughly modeled and gets rounded to the nearest hundred.
-Damage Control components only reduce damage that gets past the reactive rating of armor, and isn't modeled here.
-Modifiers vs armor that railguns, missiles and phasers get are all applied here.
Updated for Legends:
RE: Weapons spreadsheet
Posted: Tue Jan 11, 2011 11:38 pm
by elanaahova
awesome work...
RE: Weapons spreadsheet
Posted: Wed Jan 12, 2011 12:21 am
by Pipewrench
that is fantastic
RE: Weapons spreadsheet
Posted: Wed Jan 12, 2011 7:28 am
by Data
you are truly assimilated, great job
RE: Weapons spreadsheet
Posted: Wed Jan 12, 2011 1:09 pm
by cmdrnarrain
Sweet and thanks!!!
RE: Weapons spreadsheet
Posted: Wed Jan 12, 2011 2:07 pm
by J HG T
Nice and useful. Thank you sir!
RE: Cheetsheets!
Posted: Fri Jan 21, 2011 2:10 am
by unclean
Here's one for the races
This is pretty much races.txt in a sortable and more readable format. It lists everything about the races from their preferred planet type to their troop strength and tech focus.
I'm not sure how to sort in MS office, but in openoffice I have it set up so you can just click on a tile and hit the sort ascending or descending button.
edit: added to top post
RE: Cheetsheets!
Posted: Fri Jan 21, 2011 7:29 am
by Data
wow, please don't stop [&o]
RE: Cheetsheets!
Posted: Fri Jan 21, 2011 5:05 pm
by Larsenex
Ooo yoiu need to put Death Ray and Devastator Pulse superweapons in there! GREAT Job!
RE: Cheetsheets!
Posted: Fri Jan 21, 2011 6:24 pm
by elanaahova
wonderful summary data. thank you, Larsenex!
RE: Cheetsheets!
Posted: Mon Feb 14, 2011 8:50 pm
by unclean
Thanks people [:)]
I updated the weapons spreadsheet so that you can see how they do against armor, and increased to range data slightly to 990. For example here's how much damage each weapon armor deals against maximum armor:
See attachment for how to set it.
It's added to the first post along with a slightly updated races sheet.
ORIGINAL: Larsenex
Ooo yoiu need to put Death Ray and Devastator Pulse superweapons in there! GREAT Job!
I didn't really want to spoil it. They blow thing up real good though though, believe me [:D]

RE: Cheetsheets!
Posted: Tue Feb 15, 2011 5:24 am
by Data
we should make this a stickied thread, this one certainly deserves it

RE: Cheetsheets!
Posted: Tue Jul 24, 2012 11:02 am
by Bleek
Wow!
If this could be updated for Legends that would be awesome. [&o]
RE: Cheetsheets!
Posted: Fri Aug 31, 2012 6:46 am
by joeyeti
I second the notion of updating the tables for Legends!
Is the data mined from the actual components when they are researched in the game?
Or can it be found in a raw text form somewhere in the files?
RE: Cheetsheets!
Posted: Fri Aug 31, 2012 3:30 pm
by lordmoore
I third it!
Signed,
lordmoore, professional lurker
RE: Cheetsheets!
Posted: Sun Sep 02, 2012 8:50 pm
by jpinard
Has anyone made a spreadsheet of the races?
RE: Cheetsheets!
Posted: Mon Sep 03, 2012 4:25 am
by joeyeti
I plan to do one when I transfer the races to the DW Wiki - as I am also working on other tables from the game and elsewhere...
RE: Weapon Damage and Armor comparison
Posted: Sat Feb 09, 2013 10:00 pm
by unclean
Finally got around to adding the Legends weapons! Only images right now, I'll upload the rest later.
Weapon DPS per size vs shields:
Weapon DPS per size vs reactive armor (second best):
I zoomed in a little to get a beter picture, the autocannons go to 5.5 or something.
Individual weapon comparisons of the same here:
1 2
About this:
-Just treat this as a baseline. Range is arguably more important than sheer damage in practice, and some things aren't modeled here, like energy use and accuracy.
-Range is roughly modeled and gets rounded to the nearest hundred, so range differences are more dramatic here than they are in game.
-Modifiers vs armor that railguns, missiles and phasers get are all applied here.
-Damage Control components only reduce damage that gets past the reactive rating of armor, so it isn't modeled here.
Anyways there's some interesting stuff here - I didn't realize rail guns got shut down so hard by high tech armor. Also the top tier rail gun looks horrible, does anyone actually use it? I'm a fan of rail guns but I always stop at Heavy Rails personally.
Also I'm going to try missiles and phasers instead of switching to torpedoes early on, looks fun.
RE: Weapon Damage and Armor comparison
Posted: Sat Feb 09, 2013 10:44 pm
by Arcatus
Oooh. Nice update.
Images are not working though...
RE: Weapon Damage and Armor comparison
Posted: Sat Feb 09, 2013 11:06 pm
by unclean
Might be because I edited it a million times, try ctr+f5.