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. :)
Co-admiral and forum recruiter
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/frPd24t

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
    Co-admiral and forum recruiter
    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/frPd24t
  • 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.
    Co-admiral and forum recruiter
    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/frPd24t
  • 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.
    Co-admiral and forum recruiter
    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/frPd24t
  • 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.
    Co-admiral and forum recruiter
    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/frPd24t
  • 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.
    Co-admiral and forum recruiter
    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/frPd24t
Sign In or Register to comment.