STT Level 100 Spreadsheet

1235»

Comments

  • Thanks for clarification.
  • PsionStormPsionStorm ✭✭ ✭✭
    Make a copy of the spreadsheet then update your bonuses in tab 3, i think that's how you do it.

    Right, I've done that. My question is more "Do I just add my 5 CMD base Starbase bonus and my 5 CMD collection bonus and put 10 for my bonus on the sheet?"

    The Do Not Airlock checklist separates these values. I do not believe this sheet does. I'm not sure what order they're applied in in-game, or if it even matters.
  • Peachtree RexPeachtree Rex ✭✭✭✭✭ ✭✭✭✭✭
    PsionStorm wrote: »
    Make a copy of the spreadsheet then update your bonuses in tab 3, i think that's how you do it.

    Right, I've done that. My question is more "Do I just add my 5 CMD base Starbase bonus and my 5 CMD collection bonus and put 10 for my bonus on the sheet?"

    The Do Not Airlock checklist separates these values. I do not believe this sheet does. I'm not sure what order they're applied in in-game, or if it even matters.

    The bonuses are additive. You just add them together on sheet 3
  • PsionStormPsionStorm ✭✭ ✭✭
    The bonuses are additive. You just add them together on sheet 3

    Perfect, thank you for clarifying!
  • MaKdMaKd
    This is pretty cool! Thanks for this :)
  • Automaton_2000Automaton_2000 ✭✭✭✭ ✭✭✭✭
    Might be nice to have [Gauntlet] Overall header pinned as it is in the other tabs.
  • Peachtree RexPeachtree Rex ✭✭✭✭✭ ✭✭✭✭✭
    Might be nice to have [Gauntlet] Overall header pinned as it is in the other tabs.

    Done. Could have sworn they were all like that, but clearly not :)
  • FlemmingFlemming ✭✭✭✭✭ ✭✭✭✭✭
    One minor Trait issue:
    Professor Sato, this shows "Commander" instead of "Communicator"

    (I was using your table to aggregate traits and that one made me blink, "When did she get a promotion?")
    Intentionally Left Blank
  • Peachtree RexPeachtree Rex ✭✭✭✭✭ ✭✭✭✭✭
    Flemming wrote: »
    One minor Trait issue:
    Professor Sato, this shows "Commander" instead of "Communicator"

    (I was using your table to aggregate traits and that one made me blink, "When did she get a promotion?")

    Fixed
  • Roadrunner {SG-66}Roadrunner {SG-66} ✭✭✭ ✭✭✭
    I think who ever did the stats for Hawk in the voyage tab got it wrong. His score is nowhere close to #5. I got him at 3,474 according to the FFFE stats published by Shan (unless other numbers have been published somewhere else):

    CMD: 1261.5
    SEC: 1581.5
    SCI: 631

    birils4qjlp3.jpeg
  • Synthetic CommanderSynthetic Commander ✭✭✭✭✭ ✭✭✭✭✭
    I think who ever did the stats for Hawk in the voyage tab got it wrong. His score is nowhere close to #5. I got him at 3,474 according to the FFFE stats published by Shan (unless other numbers have been published somewhere else):

    CMD: 1261.5
    SEC: 1581.5
    SCI: 631

    birils4qjlp3.jpeg

    are the numbers you're seeing including your fleet and collection bonuses?
  • Roadrunner {SG-66}Roadrunner {SG-66} ✭✭✭ ✭✭✭
    I think who ever did the stats for Hawk in the voyage tab got it wrong. His score is nowhere close to #5. I got him at 3,474 according to the FFFE stats published by Shan (unless other numbers have been published somewhere else):

    CMD: 1261.5
    SEC: 1581.5
    SCI: 631

    birils4qjlp3.jpeg

    are the numbers you're seeing including your fleet and collection bonuses?

    I’m not “seeing” any numbers. I just did the calculation manually based on Shan’s published numbers. I don’t know where the spreadsheet numbers came from but they are wrong

    ckfg31iwtvlh.jpeg
  • [7TW] UnkieB[7TW] UnkieB ✭✭✭✭✭ ✭✭✭✭✭
    Doesn't the spreadsheet use all possible bonuses by default?
  • Roadrunner {SG-66}Roadrunner {SG-66} ✭✭✭ ✭✭✭
    edited January 3
    Doesn't the spreadsheet use all possible bonuses by default?

    Well I’ll be damned. Just checked a couple of my crew and it does. Why add the bonuses since it varies from player to player? So Hawk is a beast, going for him.

    Thanks UnkieB

    Edit: @Peachtree Rex , maybe add a note on the sheet table of content specifying the above. I’ve been doing my calculations wrong For weeks :smile:
  • cmdrworfcmdrworf ✭✭✭ ✭✭✭
    Hope all this blows over and you bring it back.
  • DreamsnakeDreamsnake ✭✭ ✭✭
    still not the right time? some of us stil lhave troubles with like clearing certain nodes, and returning of this resource would be awesome
  • [7TW] UnkieB[7TW] UnkieB ✭✭✭✭✭ ✭✭✭✭✭
    edited April 30
    Dreamsnake wrote: »
    still not the right time? some of us stil lhave troubles with like clearing certain nodes, and returning of this resource would be awesome

    IIRC there is a more current thread around here for this, but...
    https://docs.google.com/spreadsheets/d/1zrObDH5UtTOfSm37pdMVmm7hwr2u6kMDgdWZpwfjON8/htmlview#gid=1942976
  • <TGE> Darxide<TGE> Darxide ✭✭✭ ✭✭✭
    Maybe I'm just really dumb at the moment, but why do the Gauntlet tabs check that the card is FF before considering it?

    Fusion level means nothing to proficiency rolls and has no effect on the Gauntlet viability of a card.
  • <TGE> Darxide<TGE> Darxide ✭✭✭ ✭✭✭
    Bueller?
  • Travis S McClainTravis S McClain ✭✭✭✭✭ ✭✭✭✭✭
    I had an idea for using the data in the spreadsheet, but I don't know nearly enough to implement it, and that's to create sheets to display Faction Event and Galaxy Event stats. There isn't much to do that the Gauntlet and Voyage sheets don't already do. I just don't know how to make it do that!

    In case some intrepid soul might wish to take the idea and run with it, the event bonuses are:

    Faction Featured - x3
    Faction Bonus - x2
    Galaxy Featured - x5
    Galaxy Bonus - x3
  • DilvishDilvish
    edited June 8
    Just started using the Database/Spreadsheet & entering in Owned crew...why is KDF Alexander missing?

    I also see Away Team Archer also not included, now assuming 1 to 3 star crew not included in collection database.
  • Negh_varNegh_var ✭✭ ✭✭
    Hey, it's been a while since I got the latest copy of the doc to update my own so I was going to start from scratch but with the hyperlink at the top I can't access the sheets menu. Is this intended?
Sign In or Register to comment.