Home Ready Room

Spreadsheet for crew & ship abilities

This document was originally created by @~peregrine~ , who has graciously passed the honor of maintaining it to me.

https://docs.google.com/spreadsheets/d/1ZUbbJjaIurFCzCRiU2XSIG1lG-7GLKGBsKZsiQ_0lsk/edit?usp=drivesdk

The first tab contains the ship abilities of all crew. I try to update it on Wednesdays, after the Tuesday packs and event crew for that week are announced.

The second tab contains ship stats and abilities. I try to keep these at the highest known level. It is not updated frequently, unfortunately. If you have the stats for a fully leveled ship and would like me to update the sheet, please send me a private message (PM).

There is also a tool for creating arena line-ups. This was created by ~peregrine~ and I am not sure how it works. I favor trial-and-error experimentation, and would be happy to discuss line-ups in this or any other thread. :)

I'm not as great with making filters and sorting fields work for shared spreadsheets, but there is a tab which includes my workaround. If you have a better solution and would like to teach me more about Sheets, please PM me.

Hope you find this helpful. :)
Forum recruiter for [10F], +FH+, and [STA]
Ten Forward Loungers - Give Your Best, Get Our Best!
Check out our website: https://wiki.tenforwardloungers.com/
Chat with us on Discord: https://discord.gg/hg8ZRyn

Comments

  • ~peregrine~~peregrine~ ✭✭✭✭✭
    edited September 4
    This document was originally created by @~peregrine~ , who has graciously passed the honor of maintaining it to me.

    https://docs.google.com/spreadsheets/d/1ZUbbJjaIurFCzCRiU2XSIG1lG-7GLKGBsKZsiQ_0lsk/edit?usp=drivesdk

    The first tab contains the ship abilities of all crew. I try to update it on Wednesdays, after the Tuesday packs and event crew for that week are announced.

    The second tab contains ship stats and abilities. I try to keep these at the highest known level. It is not updated frequently, unfortunately. If you have the stats for a fully leveled ship and would like me to update the sheet, please send me a private message (PM).

    There is also a tool for creating arena line-ups. This was created by ~peregrine~ and I am not sure how it works. I favor trial-and-error experimentation, and would be happy to discuss line-ups in this or any other thread. :)

    I'm not as great with making filters and sorting fields work for shared spreadsheets, but there is a tab which includes my workaround. If you have a better solution and would like to teach me more about Sheets, please PM me.

    Hope you find this helpful. :)

    1. You improved it.

    2. For anyone who doubts that this is community, think again.

    3. I want to thank @Prime Lorca [10FH] publicly for taking on this chore. And, trust me, it can get tiresome. So I salute the admiral of 10FH.
    🖖
    "In the short run, the game defines the players. But in the long run, it's us players who define the game." -- Nicky Case, The Evolution of Trust
  • Prime Lorca [10FH]Prime Lorca [10FH] ✭✭✭✭✭
    edited September 16
    This is a list of strong skirmish crew that I created for my fleets. They're not all my fleets, of course, but I didn't just make the list for one fleet. Anyway... Here's some of the top skirmish crew. If you're looking for a starting point for building a good skirmish team, then this can get you started. I haven't updated the list in a long while. Please let me know if anyone needst to be added.

    LEGENDARY
    Killy: 6s Attack Bonus + 400% instant damage
    Rura Penthe Commandant (aka: RPC): 6s Attack Bonus + 400% instant damage
    Fury Kes: 6s Attack Bonus + 400% instant damage
    Garth of Izar: 6s Attack Bonus + 400% instant damage
    Rura Penthe Kirk: 6s (cloak trigger) Accuracy bonus + 500% instant damage
    Polywater Yar: 2s Attack bonus + 200% instant damage
    Locutus: 1s Attack Bonus
    Mirror Spock: 1s Accuracy bonus + passive stats
    Admiral Nechayev: 4s Attack bonus + 10k Crit Bonus
    FO Burnham: 12s Evasion + 400% instant damage
    Covert Operative Leland: 8s Attack bonus + 400% instant damage
    Sabateur Garak: 8s 400% instant damage, fits in the ENG slot
    Survivalist Kirk: 8s Accuracy bonus + 400% instant damage
    Torpedo Surgeon McCoy: 4s Accuracy bonus + 150% instant damage
    Enemy Lines Sisko: 8s Evasion bonus + 400% instant damage
    Suus Mahna Sarek: 10s Evasion bonus + 400% instant damage

    SUPER RARE
    Prisoner O'Brien: 4s Attack bonus + 5k crit bonus
    Ardra: 6s Accuracy bonus + 18k crit bonus
    Undercover O'Brien: 6s Evasion bonus + 18k crit bonus
    Mirror Leeta: 4s Accuracy bonus + 1,500 crit rating
    Raffi Musiker: 8s Attack bonus + 200% instant damage
    S31 Georgiou: 8s Attack bonus + 200% instant damage
    Noah Hippocrates: 3s Accuracy bonus + 100% instant damage (good for auto battles)
    Duras Sisters: 12s Attack bonus
    Thot Gor: 10s Attack bonus

    RARE
    Kang: Attack Bonus
    Mirror "Smiley" O'Brien Evasion, shield repair, and passive stats
    Tourist Worf: 10s (cloak trigger) Evasion bonus + 400% instant damage
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • I just put the ship stats in my spreadsheet. Interesting facts:
    - Queen's ship is the first legendary ship to have a 4s position trigger.
    - No SR or Legendary crew with position trigger initialize before 6s.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • Prime Lorca [10FH]Prime Lorca [10FH] ✭✭✭✭✭
    Spreadsheet up to date. My skirmish analysis is that the crew and ship are nothing special for old accounts, but newer accounts will benefit from both the new ship and crew.

    Older accounts:
    Ignore the ship. You're better off using a tried and true ship like the Krayton. For bonus crew, none initialize before 8s. That move them to the passive skill tie-breaker. Nexus Kirk wins with 965 accuracy. Boreth Pike is a not-too-distant second place.

    Newer accounts:
    If you struggle to complete the epic difficulty, this may be a good week to play on elite. Once you get the schematics for the new ship, it should breeze through with Boreth Pike for Attack bonus and maybe EV Suit Spock if you need his accuracy. The U.S.S. T'Kumbra is equipped with crit rating and crit bonus, both at 6s. If you have Ardra and/or Undercover O'Brien, they will fit nicely with the crit meta. Otherwise, just try to see what other crit crew or instant damage you can throw in there.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • Well done, this is interesting. Good work. B)
  • Prime Lorca [10FH]Prime Lorca [10FH] ✭✭✭✭✭
    Admiral 8Q wrote: »
    Well done, this is interesting. Good work. B)

    Happy to help. I'll try to provide a similar assessment before skirmishes.

    If you recently started an alt, this is a great skirmish. If you can get the ship and the new Pike, you'll be able to crush the elite difficulty. That'll set you up for future success. My alt had similar luck when Grebnedlog came out with a 4* ship - La Siranna, I think.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • Second your comment; 'crush elite' ... my alt can; SO not touching Epic ... crash and burn half-way through cycle 1, no maxed 5* ships
  • Prime Lorca [10FH]Prime Lorca [10FH] ✭✭✭✭✭
    Analysis for skirmish event: Sha Ka Ree

    Crew:

    Sybok is my choice for deeper rosters. He initializes at 6s and can sit in a DIP, SCI, or MED seat and those are usually toward the right. His shield repair means you'll probably never need hull repair. His passive accuracy is a little above average too.

    For newer rosters, it depends on your needs. Sybok is a solid choice with 6s activation and shield repair. Zarabeth is ok with her 6s evasion, but EV Spock is probably the best choice if you don't have Sybok. His accuracy boost may be useful at the 8s mark.

    Ships:

    If you have a level 7+ 5* ship, then you may be able to beat the epic difficulty. Talk with your fleet about crew selection if you have difficulty.

    The Enterprise A is kind of week, so I don't recommend chasing schematics. It boosts attack speed at 6s and reduces cooldown at 10s. The cooldown reduction comes too late to be useful, imo.

    The D'deridex Warbird is one of the top three 4* ships, so that's definitely an option for elite difficulty, if you have the ship.

    The U.S.S. T'Kumbra should get you through elite just fine if you managed to pick it up two weeks ago. The crit bonus / crit rating meta should work just as well as last skirmish if you have that type of crew.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • Spreadsheet is updated for the skirmish. There were some noteworthy additions. I think the rockstar this week is Maquis Takeover Paris. Maybe a slower burn will be Warship Voyager. The Warship has some potential that won't be realized until it becomes more widely used, if ever.

    Deeper rosters:
    Maquis Takeover Paris and Maquis Takeover Seska will be the crew to use this week. They both feature 350% damage at 10 seconds with a Position trigger. Paris wins the tiebreaker of passive abilities by a small margin. Neither will help much on deeper rosters with that Position trigger. It's just a matter of whether you want accuracy or attack bonus in case the battle goes to 8s or 10s. And don't even think of using Lorca, unless you're a fan like me and you just want him there for looks. His 13s boarding damage and paltry passive abilities will not win the battle, sadly.

    Newer players:
    For newer rosters, if you have the Borg Sphere or recently acquired La Sirena for those elite level battles, then Maquis Takeover Paris will knock it out of the park for you. You can also use the USS Defiant for its Position trigger.

    Captains Division of Arena:
    After this week, Maquis Paris is likely to be on every Borg Sphere bridge in Captains Division of the arena. His damage is just too good with that position trigger. He's pretty much the new must-have for the Captains Division.

    Ships to use this week:
    As far as ships go, use your tried and true favorite. If you're new and working on elite, then La Sirena and Borg Sphere will get you through. If you have 5* options, then the Krayton, Valdore, Borg Cube, Discovery, etc. will work like they do in every previous skirmish.

    Warship Voyager future potential:
    The new Warship Voyager has some arena potential. I don't think it will be a good skirmish ship, but 4s hull damage reduction of 35% may help it survive Krayton volleys when the Warship eventually gets maxed out. And the Boarding damage at 6s may help it win a battle or two, if it survives. DON'T go buying schematics for this reason though. It's all just possibility and conjecture at this point. But if you're the biggest Warship Voyager fan in the world and feel like you must buy these schematics, then let me know how it goes. It looks like a fun ship. I'll be patient and wait for it, though.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • @starfox , might I trouble you to post the stats here for Warship Voyager? The screen from the arena ship selection has all the stats I need in one tidy place, if you wouldn't mind posting that one.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
  • Prime Lorca [10FH]Prime Lorca [10FH] ✭✭✭✭✭
    I have decided to change the voyage stats to base stats. When crew are sorted in the ship menus, it is done by the base stats. There was also a change to data from Paladin's spreadsheet to @[10F] Captain Idol 's backend data spreadsheet. Hopefully I have everything sorted correctly. If you see errors (especially the wrong skills), please let me know.

    This week, Courier Burnham is the golden girl for the skirmish phase. I will be putting her in the far right seat, though. Her evasion help at 6s is best if it doesn't get in the way of better crew triggering sooner.

    Reinforcements Stamets, Booker and Grudge, and Linus all trigger later than 8s, so the matches should be over before they trigger. If it's not, then you may want Booker and Grudge to hold the seat with 400% damage at 14s as an insurance policy to ensure the battle ends.

    As far as ships, use whatever you normally use. The Orion ship isn't particularly strong. Its quickest ability triggers at 8s and it's just shield repair. The Krayton, Valdore, or Discovery will probably serve you better.
    Forum recruiter for [10F], +FH+, and [STA]
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website: https://wiki.tenforwardloungers.com/
    Chat with us on Discord: https://discord.gg/hg8ZRyn
Sign In or Register to comment.