This ship comparison spreadsheet is designed to provide a slightly better graphical approach to comparing ships. While other ship comparison spreadsheets tend to list the same information, it is usually in a format that makes it tedious to read. My goal with this is to make it very easy to see the differences in a side-by-side format.

This is a Google Spreadsheet, so you will need to make your own copy to use the pages that let you choose which ships to compare side by side. Instructions how to do this are included in the spreadsheet.

Enjoy!

Latest ChangesV4.6.3

Added the Son'a Dreadnought stats.

Added Allied Flight Deck Cruiser ship stats.

A full list of changes from prior revisions is included in the spreadsheet.​​

Nitpicking is a time-honored tradition of science fiction. Asking your readers not to worry about the "little things" is like asking a dog not to sniff at people's crotches. If there's something that appears to violate natural laws, then you can expect someone's going to point it out. That's just the way things are.

I wouldn't lump the T5U ships in with the T6 data. They're rather different, especially considering there is a different between T5U-10 and T5U-11.

I kind of miss having separate tabs for categories like all Fed cruisers, all the Romulan Warbirds etc.

Off Topic:
When we have solid data, will you include Upgrade costs in this sheet?http://bit.ly/STORnD

T6, T5U-10/11, etc... Basically I'm lumping together ships you can use from levels 50 through 60 without getting too involved in the minor differences between them.

The real reason I had to make a new spreadsheet was to take advantage of everything offered in the "New" Google Sheets, particularly the increased calculation speed since the original spreadsheets were starting to get very slow, especially the T5 with almost 200 ships. Removal of all those separate tabs was one side affect. However, I am considering adding in another sheet that will allow filtering so you can see just T4 Fed Cruisers or whatever category you want. I'm uncertain when I will find time to do it though. But since you request it, I am inclined to add it sooner than later.

Off Topic:
The R&D spreadsheet will be getting the recipes for the craftable upgrade things (I don't remember what they're called). I also plan to eventually toss in a list of the R&D doffs to help people find those on the exchange. By upgrade costs, do you mean like to take a Mk X rifle up to Mk XI? I'm not yet sure what all that would require, but I'll hold on to the idea. I'm still trying to find time to get the T5-U ship data.

The real reason I had to make a new spreadsheet was to take advantage of everything offered in the "New" Google Sheets, particularly the increased calculation speed since the original spreadsheets were starting to get very slow

Off Topic:
The R&D spreadsheet will be getting the recipes for the craftable upgrade things (I don't remember what they're called). I also plan to eventually toss in a list of the R&D doffs to help people find those on the exchange. By upgrade costs, do you mean like to take a Mk X rifle up to Mk XI? I'm not yet sure what all that would require, but I'll hold on to the idea. I'm still trying to find time to get the T5-U ship data.

Yeah like a cell for [Type # of TP required to upgrade to next level] and then next to that it'll spit out the number of Basic, Improved, or Superior Tech Upgrade items you'd need to apply to it, how much EC to craft them, and how much dilithium to apply them.

It seems right now that there might be too much variability in the different prices to upgrade different types of gear (consoles, space weapons, warp cores, ground armor, etc.) at different mark levels to different qualities so you might have no choice but to just let the player manually enter how much TP the upgrade window tells them they need for the next upgrade.

Nitpicking is a time-honored tradition of science fiction. Asking your readers not to worry about the "little things" is like asking a dog not to sniff at people's crotches. If there's something that appears to violate natural laws, then you can expect someone's going to point it out. That's just the way things are.

I just modified the spreadsheet to provide a filter by faction and category, like Fed Cruisers, KDF Raiders, etc. You can find this on each tier's comparison sheet. Now I just need to improve the accuracy of the categories... some are still from back when I lumped everything into escorts, cruisers, and science vessels. Let me know how well it works for you.

I just modified the spreadsheet to provide a filter by faction and category, like Fed Cruisers, KDF Raiders, etc. You can find this on each tier's comparison sheet. Now I just need to improve the accuracy of the categories... some are still from back when I lumped everything into escorts, cruisers, and science vessels. Let me know how well it works for you.

Nitpicking is a time-honored tradition of science fiction. Asking your readers not to worry about the "little things" is like asking a dog not to sniff at people's crotches. If there's something that appears to violate natural laws, then you can expect someone's going to point it out. That's just the way things are.

The formulas still work, or should. Usually if they stop working, it has something to do with Google's scripts or the browser or internet lag. Either reload, make a fresh copy, or close it down and open it up later. Google Sheets is a great way to make and share spreadsheets like this, but sometimes we get quirks that cause it to temporarily stop working. I'm not trying to pass the buck, it's just I've had the same thing happen once or twice. Good luck.

I followed instructions. but cant find the file. im not sure how to get a copy.

Google documents are not usually files you download to your computer. Rather, they are files kept in the Google cloud. To make a copy of this spreadsheet for you to use, you need to have a Google account with Google Drive activated.

I'm using office 2013, and I simply cannot get the drop down menu for the faction to change the ship listings for that faction. Can you help me out and just tell me what the stats are on a t5u fleet ha'nom guardian warbird: shields, turn, consoles, boff slots, hull?