ABCDEF
1
Star Trek Online Ship Comparison
2
by @daBelgrave
3
4
The latest available version (V4.7) comes from:
5
http://bit.ly/STOShips
6
7
You can discuss, comment, or provide corrections at:
8
http://forum.arcgames.com/startrekonline/discussion/1165394/sto-ship-comparison-spreadsheet-all-tiers-small-craft
9
10
11
You can find simple non-spreadsheet versions at:
12
http://thephoenixdivision.com/ships.html
13
http://thephoenixdivision.com/smallcraft.html
14
15
Introduction
16
This ship comparison spreadsheet is designed to provide a slightly better 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, very similar to the "Data" sheets used in this spreadsheet. My goal with this is to make it very easy to see the differences in a side-by-side format, although with the arbitrary additional limit of allowing only a select number of ships to be compared at a time.
17
18
How to Use
You do need your own Google account.
19
1.The first thing you need to do if you want to use this spreadsheet is to make your own copy of it. To do this, select File -> Make a copy. Keep in mind, your copy will not be updated when I make updates to this spreadsheet, but it will list the latest version and provide a link where you can find it.
20
21
2.Go to the 'Ships' sheet. It can compare any three ships, with the ability to select them provided by a dropdown list at the top of each column. The ability to use the dropdown is why you need to make your own copy of the spreadsheet.
22
3.If you ever think you broke your copy of the spreadsheet, just get a new one!
23
4.Enjoy!
24
25
What This Does Not Do
26
1.This does not provide quick easily printable depictions of each ship or list any possible discounts on ship prices.
27
2.This does not guarantee absolutely 100% correct information. I make mistakes (on rare occasions), so some figures might be incorrect. I did try to catch those mistakes, but I don't know if anything slipped through. If you find a mistake, please let me know!
28
3.The existence of a hyperlink in this website does not mean the actual destination page exists. This particularly applies to STOWiki, which is not always updated with the latest additions to the game.
29
4.This does not provide any services unrelated to ships in Star Trek Online. Sorry, but it won't heat your coffee, make you awesome at PvP, or do other things besides help you compare these ships.
30
31
Notes
32
1.Bridge Officer Order: Rather than attempt to order the bridge officer layouts the way it is ingame--seemingly random--I do it by rank, or as close as possible. If there are two or more of the same rank, then it's either alphabetical or ordered in a way that more or less matches the order I have on related ships.
33
2.Console Order: Rather than use the Tac/Eng/Sci order seen at Ship Requisitions and other places where Cryptic describes the ship, I order them Eng/Sci/Tac as shown on the Ship Character Sheet. I find this makes it easier to quickly understand how each ship relates to what I would see most often in the game.
34
3.Other Ordering: Everything else is alphabetical, random, or in whatever way I felt was best. In fact, there's a good chance I just tossed some things in there in whatever order I could. Don't read too much into it.
35
4.Have questions, comments, suggestions, etc? Contact me ingame: @daBelgrave
36
37
Change Log
38
V4.7- Added the Type 7 Shuttle stats from:
39
https://www.arcgames.com/en/games/star-trek-online/news/detail/10645594
40
- Added the Tzenkethi Lockbox and Lobi ship stats from:
41
https://www.arcgames.com/en/games/star-trek-online/news/detail/10670944
42
- Added the Miracle Worker Mega Bundle ship stats from:
43
https://www.arcgames.com/en/games/xbox/star-trek-online/news/detail/10684194
44
- Added a new column to fit the Universal Console Slots added with the Miracle Worker bundle ships.
45
- Added another column for abilities.
46
47
V4.6.3- Added the Son'a Dreadnought stats from:
48
http://www.arcgames.com/en/games/star-trek-online/news/detail/10609304
49
- Added the Allied Flight Deck Cruiser ship stats from:
50
https://www.arcgames.com/en/games/star-trek-online/news/detail/10638324
51
52
V4.6.2I'm having a really busy summer, so updating this has been slow.
53
- Added the Vorgon Ryn'kodan Carrier summer ship stats from:
54
https://www.arcgames.com/en/games/star-trek-online/news/detail/10525893
55
- Added new T6 Xindi ship stats from:
56
https://www.arcgames.com/en/games/star-trek-online/news/detail/10558824
57
- Added the Son'a Lockbox and Lobi ship stats from:
58
https://www.arcgames.com/en/games/star-trek-online/news/detail/10571234
59
- The Vaadwuar Pythus Fighter can actually equip Dual Cannons instead of just Single Cannons.
60
61
V4.6.1- Added the Advanced Light Cruiser Bundle ship stats from:
62
https://www.arcgames.com/en/games/star-trek-online/news/detail/10502913
63
- Added the Smuggler's Heavy Escort stats from:
64
https://www.arcgames.com/en/games/star-trek-online/news/detail/10507963
65
66
V4.6- Added the Privateer Lockbox and Lobi ship stats from:
67
https://www.arcgames.com/en/games/star-trek-online/news/detail/10472663
68
- Merged 'Flanking' and 'Other Abilities' stats into the 'Abilities' area, and removed those two columns.
69
- Good news! Qualifying T5 ships also get Heavy Weapon slots!
70
71
V4.5- Added the Allied Escort Bundle ship stats from:
72
http://www.arcgames.com/en/games/star-trek-online/news/detail/10447343
73
- Added a column for the new Heavy Weapon slots on T6 escorts and related ships.
74
75
V4.4- Added the 26th Century Heavy Dreadnought ship stats from:
76
http://www.arcgames.com/en/games/star-trek-online/news/detail/10423633
77
- Added two more columns for abilities.
78
79
V4.3- Finally finished revamping the Hangar Pets portion of the spreadsheet. I consider this part of V4.0.
80
- The HP Data sheet has been completely reorganized, and some info removed or added. There may still be errors and mistakes, and I intend to fix them as I become aware of them.
81
- The old versions of the Ships, Small Craft, and Hangar Pets sheets have been completely removed.
82
- Added the (currently Console Only) T6 Tal Shiar Lockbox/Lobi ship stats from:
83
http://www.arcgames.com/en/games/playstation/star-trek-online/news/detail/10390093
84
- Removed specific YouTube Review links from ships since I did not have time to go looking for more.
85
- Added "Search YouTube" and "Search reddit" links near the top of the Ships, Small Craft, and Hangar Pets sheets. These are automatically generated, and replace the previously used links to specific reviews.
86
- Adjusted calculations for the Hull Strength modifiers. These currently only work based on the ship's minimum level. There still seems to be something wacky going on for the ships that get increases from 40 to 50 or 50 to 60. The actual formula remains unchanged, but only works with the level when a ship first becomes available
87
88
V4.2.4- Added the T6 Multi-Mission Explorer ship stats from:
89
http://www.arcgames.com/en/games/star-trek-online/news/detail/10378863
90
91
V4.2.3- Added the Undiscovered Lockbox/Lobi ship stats from:
92
http://www.arcgames.com/en/games/star-trek-online/news/detail/10359403
93
- Added the Lukari Anniversary ship stats from:
94
http://www.arcgames.com/en/games/star-trek-online/news/detail/10354933
95
- Any missing images and admiralty stats will be added later without a version increase.
96
97
V4.2.2- Added the (currently Console Only) T6 Elachi Lockbox/Lobi ship stats from:
98
http://www.arcgames.com/en/games/xbox/star-trek-online/news/detail/10315963
99
100
V4.2.1- Added the Science Modern Bundle ship stats from: