STO Ship Comparison Spreadsheet V4.6.3 - All Tiers + Small Craft + Hangar Pets

dabelgrave

markhawkman wrote: »

BTW, the mirror Guardian is a command ship instead of Intel. Forgot to look at what else was different.

That was the only difference I saw other than a minor difference in the Admiralty numbers. It has the same console, same mastery trait, same everything else.​​

markhawkman

the admiralty card boosts a different crit stat. +sci instead of +tac.

dabelgrave

V3.12 is available with the new T6 Carrier.

I've also updated the Hangar Pets info. Since I'm really not a carrier person, I had to guess on some of it. Please let me know if there are any errors.

Enjoy!
​​

markhawkman

BTW, the Rezreth card has a bug. It shows that it ignores tac events, but it actually ignores Eng.

warpdongle

Thanks for the great spreadsheet! Just found out though that the Rom Morrigu Heavy Warbird's only have 4 front weps, not 5.

markhawkman

yeah, it's a Valdore variant. Thus 4/3.

dabelgrave

warpdongle wrote: »

Thanks for the great spreadsheet! Just found out though that the Rom Morrigu Heavy Warbird's only have 4 front weps, not 5.

markhawkman wrote: »

yeah, it's a Valdore variant. Thus 4/3.

Thanks. I've made the correction.
​​

dabelgrave

V3.13 is now available. All the Admiralty stats are now complete. Enjoy!
​​

dabelgrave

V3.14 is now available with Mirror Lockbox and Anniversary ship stats. Enjoy!
​​

dabelgrave

V3.15 adds the new T6 flagship stats.​​

dabelgrave

V3.16 is now available, adding the Na'kuhl lockbox ships, and removing crew stats for S11.5. I would have posted the update sooner, but I've been trying to figure out a few of the S11.5 changes that affect ships:

• Did ship hull values change in Season 11.5? As far as I can tell, no, but patch notes suggest otherwise: http://www.arcgames.com/en/games/star-trek-online/news/detail/9910963. For the Delta Rising launch, I managed to get enough info that I extrapolated a way to calculate the hull increase on the T5-U/T6 ships as a character leveled from 50 to 60. S11.5 seems to have increased the variable used in the formula, but everything I have found still shows the old hull stats. I'll have to look into this more when I have time.
• Was crew replaced with a hidden stat that affects passive hull regeneration: http://forum.arcgames.com/startrekonline/discussion/1214347/passive-hull-repair-rate-mainly-depends-on-ship-class-but-why-is-this-a-hidden-stat. I personally do not think crew totally disappeared, and I believe Devs have said it was actually set so everyone effectively has 100% all the time. For the moment, I am not even sure how to test this, and will leave the crew stats out of the spreadsheet.

​​

markhawkman

Well, I made a quick data table on a character who still has an empty skill tree.

Soheth
Kara 61466 hp 66%(with techie)/51%(without)
Rezreth 60770 72/60
Dhael 15750 54/45
d'ridthau 33750 72/60
Risian Corvette 27000 57.3/49
SCS 10000 60/50
Faeht 35199 50/41.7
Dinaes 47518 50/41.7
Malem 36000 50/41.7
Nandi 48800 60/50
Sarr Theln 55999 72/60
Samsar 57999 72/60
Khopesh 53333 66/55
Flambard 53333 66/55
Shamshir 55093 66/55

dabelgrave

markhawkman wrote: »

66%(with techie)/51%(without)

Passive hull regen?

I'll try to find time to work through the stats sometime this week, and see if I can figure out what's going on. I'm somewhat preoccupied making a recharge reduction calculator. Fortunately, it's nearly finished.
​​

markhawkman

Yes, passive regen.

dabelgrave

markhawkman wrote: »

Well, I made a quick data table on a character who still has an empty skill tree.

Soheth
Kara 61466 hp 66%(with techie)/51%(without)
Rezreth 60770 72/60
Dhael 15750 54/45
d'ridthau 33750 72/60
Risian Corvette 27000 57.3/49
SCS 10000 60/50
Faeht 35199 50/41.7
Dinaes 47518 50/41.7
Malem 36000 50/41.7
Nandi 48800 60/50
Sarr Theln 55999 72/60
Samsar 57999 72/60
Khopesh 53333 66/55
Flambard 53333 66/55
Shamshir 55093 66/55

Here are some of those showing how they compared to what's already in my spreadsheet:
Dinaes Heavy Destroyer 47518 (+1518) Significant
Faeht Intel Warbird 35199 (-1) Rounding error?
Kara Advanced Warbird 61466 (+8146) Significant
Breen Sarr Theln Carrier 55999 (-1) Rounding error?
Ferengi Nandi Warship 48800 (0) N/A
Risian Corvette 27000 (0) N/A
D'ridthau Warbird Battle Cruiser 33750 (0) N/A
Dhael Warbird 15750 (-50) WTF?
Suliban Cell Ship 10000 (0) N/A

Reading the patch notes again, I think the base hull values should remain the same. Are you putting any equipment on your ships that could be affecting the hull values, or sitting in any cruiser auras? I was previously able to calculate the lvl 50 values from known lvl 60 values using this formula: lvl50Hull = lvl60Hull - (lvl60Hull * .1375).​​

markhawkman

Auras don't affect HP do they? some of them did have consoles, I didn't double check the console stats..

markhawkman

Ok, I double checked Soheth. I looked at the consoles on her Kara, but forgot two things... The ship mastery and Deflector. T4 Kara mastery is +10% hp. and the deflector was adding 17.5(to the HP skill). looking at the HP on ground showed 53,333.

The Dinaes comes with a console that gives it +3.3% HP. And it was still equipped.

Also the same applies to the Shamshir, it has more HP than the other dreads because of it's special console.

dabelgrave

V3.17 adds the Vorgon summer event ship. Enjoy!
​​

dabelgrave

V3.18 adds all the Age of Yesterday ship stats. Admiralty stats will be added in later as I get them. Enjoy!
​​

dabelgrave

V3.19 adds the Ferengi Nagus Marauder.
​​

ccmadden

This sheet is incredible!

I'm a returning user and I'd like to be able to compare starting equipment of the ships - is there any predictive way to determine which equipment each ship has as standard issue (type and Mk.) based on, say, class/faction/purpose? I would LOVE that information!

dabelgrave

ccmadden wrote: »

This sheet is incredible!

I'm a returning user and I'd like to be able to compare starting equipment of the ships - is there any predictive way to determine which equipment each ship has as standard issue (type and Mk.) based on, say, class/faction/purpose? I would LOVE that information!

I'm glad you find it useful.

At the moment, you can find each ship's standard issue equipment on stowiki. It won't be going into the spreadsheet at the moment, but it certainly fits something I have in mind for adding in V4.0... a major redesign which I am slowly working on as I have time. I won't make any promises, but I'm definitely open to suggestions.
​​

markhawkman

very few ship have standard issue gear worth paying attention to. It's mostly white mk X junk.

dabelgrave

You can see the first updates for V4.0 already added to the main spreadsheet. It will remain as V3.19 until I finish making all the changes I'm planning.​​

dabelgrave

V4.0 is a major revision, providing graphics and much more info. Also, the new T6 Connie and related ships are in there. Enjoy!


I do have a few other changes planned, such as the standard default equipment, but those won't be added until a later update.

dabelgrave

V4.1 adds the Cardassian/Dominion lockbox/lobi ships currently available only to console players.

Also added is a new hull mod stat that showed up in a dev blog for the first time. Although, in the process of adding it, I think I found a bug with the listed level 50 hull values on ships that auto-level with the player: http://forum.arcgames.com/startrekonline/discussion/1221475/starship-hull-strength-display-bug#latest​​

markhawkman

how do I get it to display stats on the Romulan drone fighters?

dabelgrave

markhawkman wrote: »

how do I get it to display stats on the Romulan drone fighters?

I'm not seeing any problem with those... as in they show up in the list for me.

I do need to completely revamp the Hangar Pets portion of the spreadsheet, but it's not a project I really want to start. Since I'm not a carrier captain, most of the information for them comes from whatever tooltips I can find ingame, or third-party sources, or in some cases I end up having to guess.

markhawkman

Are you using the drop down things? Those don't work for me.

dabelgrave

markhawkman wrote: »

Are you using the drop down things? Those don't work for me.

Yeah, those work fine for me. Did you...

• ...wait for the spreadsheet to finish loading completely (it can take longer than it appears to take)?
• ...make sure you clicked on the dropdown arrow and not just close to it (sometimes that causes problems for me, but selecting another cell and coming back to it can make it work again)?
• ...try manually typing in the hangar name, such as "Advanced Rom..." or "Elite Rom..." (you can check your spelling on the 'HP Data' sheet if there is a validation problem)?
• ...get a fresh copy of the spreadsheet when all else failed?

Anyway, I made it so the main copy currently has the three Romulan Drone Fighters showing on the hangar pets comparison sheet. Since everything else is working for me, that's pretty much the only thing I can do for you right now.