STO T5 Ship Comparison Spreadsheet

dabelgrave

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.

Link: http://bit.ly/STOShipComparison

This is a Google Spreadsheet, so you will need to make your own copy if you want to use the "Compare Ships" page that lets you choose which ships to put side by side. Other than that, it should still show all the stats without needing you to make a copy.

Enjoy!


Changes
V3.3

• Added information on which ships will be upgradeable in Delta Rising to T5-U.

V3.2

• Added the Xindi and Mirror Universe ships from the Xindi Lockbox.

V3.1.1

• Added Sensor Scan to the Science Odyssey.
• The Tactical Odyssey now has the correct power bonus for weapons.

V3.1

• Added the Risian Luxury Cruiser mentioned in S9 Dev Blog #23.

V3.0

• Revamped cannon limits. It's either single cannons or dual cannons.
• Added Warp Core or Singularity Core.
• Added innate abilities like increased hull regen. Flanking was moved to this category.
• Revamped special console and item lists to include non-standard weapons, hangars, and other items. Some ships had up to three.
• Corrected a few ships, mostly just stuff like cannon limits or sensor anlysis. There were also several links to STOWiki that needed fixed since they tend to rename their ship pages at times.
• Fixed Klingon Bird of Prey hull values. These ships were recently buffed when flanking was added.
• Added costs for all ships. This does not include possible discounts.

V2.10

• Added the Patrol Escort Refits mentioned in S9 Dev Blog #20.
• The old Fleet Patrol Escort will remain listed. Although retired, some players can still have this.

V2.9

• Added the Undine and Mirror Universe ships mentioned in S9 Dev Blog #18.

V2.8

• Added the Fleet Galaxy Dreadnought mentioned in S8 Dev Blog #55.
• Altered the existing Galaxy Dreadnought stats to match those announced for the Galaxy Reboot.

V2.7

• Added the Dyson Science Destroyers mentioned in S8 Dev Blogs #50, #51, and #52.

V2.6

• Added the Dyson Science Destroyers mentioned in S8 Dev Blog #47.

V2.5

• Added the Romulan (Ar'Kif) and KDF (Kar'Fi) Fleet ships from the T3 Spire.
• All the other Spire ships are already there... How did I miss these two?

V2.4

• Added the Hirogen and Mirror Universe lockbox ships mentioned in S8 Dev Blog #46.

V2.3

• Added the Voth Bulwark Dreadnought Cruiser mentioned in a Duty Officer Pack Promo.

V2.2

• Added the Mogh Battle Cruiser mentioned in S8 Dev Blog #30.
• Added mention if a ship can equip cannons.

V2.1

• Added Fleet Veteran ships and Fleet Atrox.
• Added Science Vessel Commands and Cloaking. All these additional gimmicks are being lumped together with things like Cruiser Commands and Flanking.
• Corrected some blatantly weird Bridge Officer setups. How did I get those wrong?

V2.0.1

• Added Cruiser Commands, Flanking, category, and ship class variant names.
• Corrected many ship names so the links to STOWiki now go to actual pages.
• This more or less completes the Version 2 upgrade for this comparison spreadsheet.

V2.0

• This was a major overhaul where I changed the way the spreadsheet works, and revamped how it stores the stats. This change will make it easier for me to make updates or additions.
• All ship stats are now collected on a single sheet, with the rest of the sheets taking data from there.
• Altered power bonuses so each has its own line.
• Added links to ship pages on STOWiki.
• Added special consoles, and those too link to STOWiki.
• The existence of a link here does not mean it also exists on STOWiki... they seem to lack a few.
• Corrected at least one typo that was affecting spreadsheet functionality.

V1.9

• Added the Breen Plesh Brek Heavy Raider mentioned in S8 Dev Blog #27.

V1.8

• Added the Voth Lockbox ships mentioned in S8 Dev Blog #21.

V1.7

• Added the Obelisk Carrier variants mentioned in S8 Dev Blog #14.

V1.6

• Added the Avenger Class (Battle Cruiser and Fleet Battle Cruiser) mentioned in LoR Dev Blog #48.

V1.5.1

• Changed the Ar'Kif Tactical Warbird Retrofit to the Ar'Kif Tactical Carrier Warbird Retrofit, and added a Hangar Bay.

V1.5

• Added Ar'Kif Tactical Warbird Retrofit mentioned in LoR Dev Blog #43.
• Put the inertia stats back into the mix. This helps in determining how much "glide" a ship has in a particular direction, especially while trying to turn. However, many of these might be estimates, and incorrect.

V1.4

• Added Elachi S’golth Escort and Elachi Monbosh Battleship mentioned in LoR Dev Blog #38.

V1.3

• Added Risian Corvette mentioned in LoR Dev Blog #26.
• Added Scimitar and variants mentioned in LoR Dev Blog #29.
• Added Romulan veteran ship mentioned in LoR Dev Blog #33.
• Added Romulan temporal ships mentioned in LoR Dev Blog #35.

V1.2

• Added T5/T5+ lockbox ships mentioned in Legacy of Romulus Dev Blog #22.
• Resequenced the ship list on the comparison sheet. They are now ordered by Federation, Klingon, Romulan, and Special Ships.
• Toyed with adding the ability to select a faction for each ship in the comparison so the dropdown lists are shorter. Unfortunately, Google validation wouldn't work that way. We're stuck with the full list of ships for now.

V1.1

• Added T5/T5+ Romulan ships mentioned in Legacy of Romulus Dev Blog #16.
• Removed inertia stats. They are hard to determine without owning every single ship. Just remember... escorts have high inertia, cruisers have low inertia. Other ships are in the middle somewhere. I may add it back in someday.

V1.0

• Initial STO Ship Comparison Spreadsheet
• Full listing of Vice Admiral / Lieutenant General ships as of 22 FEB 13. *I think it's complete*
• Ability to directly compare any eight ships at a time.

mightybobcnc

Swanky.

/10char

artfulmerkage

That's excellent work.

ooiue

Is this a revamp of this spreadsheet here at all?:-

https://docs.google.com/spreadsheet/ccc?key=0Amf9g7VGIx9JdDNiODBvNFZxYmZHVF9HVG9JN0RRV0E&usp=drive_web#gid=0

dabelgrave

ooiue wrote: »

Is this a revamp of this spreadsheet here at all?:-

https://docs.google.com/spreadsheet/ccc?key=0Amf9g7VGIx9JdDNiODBvNFZxYmZHVF9HVG9JN0RRV0E&usp=drive_web#gid=0

I think that's one of the ones that influenced me to make mine how I did, but it's been over a year since then. I found it hard to follow and actually compare specific ships, so I designed mine with the vertical layout instead of horizontal.

ooiue

dabelgrave wrote: »

I think that's one of the ones that influenced me to make mine how I did, but it's been over a year since then. I found it hard to follow and actually compare specific ships, so I designed mine with the vertical layout instead of horizontal.

yours actually looks a lot better than mine I think actually, I never really changed the actual interaction of how it looks

I wish you good luck in keeping this constantly updated!

dabelgrave

ooiue wrote: »

I wish you good luck in keeping this constantly updated!

Thank you.

dabelgrave

V3.1 is now complete, with the addition of the Risian Luxury Cruiser. Enjoy!

orangeitis

lol @ "KDF Escorts"

dabelgrave

orangeitis wrote: »

lol @ "KDF Escorts"

I could rename that sheet to "KDF Raptors, Raiders, and Destroyers" but that gets kinda long.

galadiman

As a spreadhseet guy, and someone who maintaines his own (pretty terrible) sheet on all these ships, this is phenomenal. You've nailed it on the vertical layout; SO easy to comparte Boff layouts in particular. Great work here!!!

orangeitis

dabelgrave wrote: »

I could rename that sheet to "KDF Raptors, Raiders, and Destroyers" but that gets kinda long.

"KDF tac ships" is more accurate.

dabelgrave

orangeitis wrote: »

"KDF tac ships" is more accurate.

Aside from the BoPs, the ships are generally more tactically-oriented based on their boff stations, so I'll keep your suggestion in mind the next time I make an upgrade to the spreadsheet. As a Science Officer who uses such ships quite well, however, I won't promise anything.


For the most part, the whole cruiser-escort-science vessel breakup is just so you can compare ships of remotely similar types and functions, not that they actually are in that category. And then there are the warbirds... I still haven't figured out how to break those into smaller categories.

iusasset

This is a pretty nifty spreadsheet. I'd like to submit a correction, however: you omit Odyssey Sci Cruiser's Sensor Analysis (this is correctly referenced for the Bortas Command Cruiser). Not a huge deal, but I'm a stickler for comprehensiveness.

dabelgrave

iusasset wrote: »

This is a pretty nifty spreadsheet. I'd like to submit a correction, however: you omit Odyssey Sci Cruiser's Sensor Analysis (this is correctly referenced for the Bortas Command Cruiser). Not a huge deal, but I'm a stickler for comprehensiveness.

Good catch. It's updated now with V3.1.1. It seems several ships were given Sensor Scan with S9, but I only found a few of them that were changed.

manarisama

Remarkable work! Only think I caught was that the Tactical Odyssey is missing it's +10 to weapons power.

dabelgrave

manarisama wrote: »

Remarkable work! Only think I caught was that the Tactical Odyssey is missing it's +10 to weapons power.

Thanks. I'm adding in these minor corrections as they come.

dabelgrave

V3.2 is now complete, with the addition of the new Xindi and Mirror Universe ships.

dabelgrave

The spreadsheet now lists which ships will be upgradeable to T5-U with the launch of Delta Rising based on: http://www.arcgames.com/en/games/star-trek-online/news/detail/7002163

stomperx99

Bloody good!!