Do Not Airlock Checklist Thread 3: Press Ctrl-F, type Spock

1202123252629

Comments

  • SpukkZSpukkZ ✭✭
    Leshy wrote: »
    New version is now up for Month of Hell with the newest crew in!

    The Event Crew erroneous selection of crew with partially matching names should now be fixed; let me know if you still encounter issues with it.

    Great work as always!

    Just a tiny mistake I've just spotted: stats sheet has Obrist with SCI/CMD/DIP stats instead of SCI/CMD/ENG
  • LeshyLeshy ✭✭✭
    SpukkZ wrote: »
    Just a tiny mistake I've just spotted: stats sheet has Obrist with SCI/CMD/DIP stats instead of SCI/CMD/ENG
    Thanks, you're right, I added the numbers to the wrong column. Stealth-fixed now, will be in future versions, too :)

  • I've changed it manually, so you still get the right results. The tab is hidden, but possible to change.
    Proud member of the [DDF] fleet.
  • I needed to browse top active crew from my roster (base, max, skill), so I prepared an extra sheet to present the data nicely. If anyone would like to try it out, it is in sheet "Top" here:
    DOCS spreadsheets/d/1urLsLrgoiVnJ3S60sXwd4mdPF1QOtUgmzOpbg3OzIT8 (sorry, apparently I can't post links, just add this ID to google docs url to access the sheet)

    It should copy/paste nicely. I was considering if it should include frozen crew just to let you know that you might need to thaw them. Maybe I'll make it a switch.

    BTW. Is the logic in choosing best gauntlet crew on purpose different from all other? Right now best available gauntleteer might not be marked to keep if he is not in top 7 for his particular skill.
  • Just noticed that bonuses are applied incorrectly. Formulas in Stats sheet use wrong Settings values. For example to calculate security skill, cell J30 in Settings is used instead of J28. For base security, I29 is used instead I28.
  • LeshyLeshy ✭✭✭
    tomaszg wrote: »
    BTW. Is the logic in choosing best gauntlet crew on purpose different from all other? Right now best available gauntleteer might not be marked to keep if he is not in top 7 for his particular skill.
    Not really on purpose, just a holdover from the way the original coded it in. I might change it to be in line with the Voyage recommendations at some point. Which in turn, I might also review.

    It's a bit of a choice between:
    * Have the sheet display who the best crew in the game are for X
    * Have the sheet display who would be an upgrade from your current crew for X
    tomaszg wrote: »
    Just noticed that bonuses are applied incorrectly. Formulas in Stats sheet use wrong Settings values. For example to calculate security skill, cell J30 in Settings is used instead of J28. For base security, I29 is used instead I28.
    Well spotted, it's now fixed. Thanks!

    Incidentally, version 3.13 is now available with a few bug fixes and the latest crew in!

  • Prime LorQa [10F]Prime LorQa [10F] ✭✭✭✭✭
    Just wanted to pop in and say thanks for this resource!
  • Thanks for the fix.
    Leshy wrote: »
    It's a bit of a choice between:
    * Have the sheet display who the best crew in the game are for X
    * Have the sheet display who would be an upgrade from your current crew for X

    Yeah, the same is true for all stats, not only Gauntlet. In any way, I think that the sheet should not recommend to space the crew which is my current best representative.

    I suppose the original logic was that in Gauntlet you really need the best crew in order to be able to compete with other players. So, maybe a double logic should be applied: calculate "reason to keep" for active crew according to currently owned crew and calculate "reason to keep" for inactive according to the best candidates in the game.

    BTW. If anyone was interested, current version of my "best of" table is now on sheet id 1ovoqqRB9BWQxGfz2ViSBCKxEseqyo8nVlqtIZO3OTNg (still can't post links directly).
  • Sylv1DeSylv1De
    edited June 23
    I'd like to report two things:
    1) The Zahl Ambassador does not appear in the combo box for events (at least the 3rd one)
    2) An usually hidden tab is visible.

    Otherwise, and those 2 things are negligible, a great job.
  • Ward SerpentineWard Serpentine ✭✭✭
    edited June 29
    @Leshy
    As usual, great job. I noticed that the conditional formatting rule for the Collections tab was off in Column F.

    @Sylv1De
    It works in mine, but I rename some of the Variants so that they sort the way I want them to. Check to see if the leading space is in the variant column on the Stats page. I think that it's missing from all of the new 3.13 crew.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • Just noticed a mistake: Cardassian Kira has SEC / CMD in the Sheet while in the game she also has the DIP stat!
  • What does the setting "Display Maximum Base Values" mean/do? Where should I be able to see the Base max? This is what I'm missing from the crew sheet and would love to have one more column displaying the max base for each crew...
  • Great work, really appreciate it.
    Think you forgot to prefix the newest "Variant of" with a space...
  • Ward SerpentineWard Serpentine ✭✭✭
    edited July 10
    What does the setting "Display Maximum Base Values" mean/do? Where should I be able to see the Base max? This is what I'm missing from the crew sheet and would love to have one more column displaying the max base for each crew...

    Basically, this shuts off crew of a certain star level from showing up in the Reason column to keep. If you have a lot of 4 star characters, you may want to shut off the 3 star stats. This changes the recommendation to keep/freeze.

    I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.

    Thanks for the idea. I created a formula for the Notes column to display the max base for the highest skill (as I was not using the Notes column for anything). Here it is:
    =TEXTJOIN(" ", TRUE, INDEX({Stats!$BM$3,Stats!$BT$3,Stats!$CA$3,Stats!$CH$3,Stats!$CO$3,Stats!$CV$3}, 1, MATCH(MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}), {Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}, 0)),
    MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}) )

    Copy that to cell G5 and then copy the formula down to the bottom of the column.
  • There is a discrepancy for some characters between my formula and the first (highest) listed skill in Skills column, due to the fact that I'm using Base whereas Skills is based on Total (Base + Avg. proficiency).
  • I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.

    Thanks for the idea. I created a formula for the Notes column to display the max base for the highest skill (as I was not using the Notes column for anything). Here it is:
    =TEXTJOIN(" ", TRUE, INDEX({Stats!$BM$3,Stats!$BT$3,Stats!$CA$3,Stats!$CH$3,Stats!$CO$3,Stats!$CV$3}, 1, MATCH(MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}), {Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}, 0)),
    MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}) )

    Copy that to cell G5 and then copy the formula down to the bottom of the column.

    Not working for me ...
  • SvenLundgrenSvenLundgren ✭✭✭✭
    Ho do we go back to determine the Mission Victories? I have forgotten what I chose....
    Starfleet Commission: August 12, 2017
  • In the mission screen select the episode which had the choice and you can see for yourself.
    Proud member of the [DDF] fleet.
  • Not working for me ...

    Strange. Do you get an error message, or what happens? Works perfectly on my sheet.

  • SvenLundgrenSvenLundgren ✭✭✭✭
    In the mission screen select the episode which had the choice and you can see for yourself.

    thanks
    Starfleet Commission: August 12, 2017
  • I think the CliffNotes version would be: If its Gold, keep it.
    You may need it somewhere, someway, whatever.
    If its Purple, level it and freeze it.
    But dont feel remorse for dumping it.
    Some purples, like Lon Suder, are like the common cold.
    If its the matched pair of Dancing Chekov and Grilka..... well, you know
  • I think the CliffNotes version would be: If its Gold, keep it.
    You may need it somewhere, someway, whatever.
    If its Purple, level it and freeze it.
    But dont feel remorse for dumping it.
    Some purples, like Lon Suder, are like the common cold.
    If its the matched pair of Dancing Chekov and Grilka..... well, you know
    Well, in short and for experienced players maybe, but for starters and intermediate players, this tool is very useful.

    You don't have to use it though
    Proud member of the [DDF] fleet.
  • Negh_varNegh_var ✭✭
    Thanks @Leshy, also love the version name :-)
  • DaviCon1DaviCon1 ✭✭
    @Leshy , you're amazing. I honestly don't know how I'd play this game anymore if I had to keep track of this many crew without some sort of structure.

    That said, also dropping a pin to add Resolute Chakotay next round. ;-)
  • Leshy wrote: »
    A new update is now available with the latest additions in.

    Due to a busy offline life, updates are a bit slower around this time and I may not be able to respond as quickly or as much, but rest assured that I appreciate all feedback!

    Do you need/accept help?
  • FlemmingFlemming ✭✭✭✭✭
    DaviCon1 wrote: »
    @Leshy , you're amazing. I honestly don't know how I'd play this game anymore if I had to keep track of this many crew without some sort of structure.

    That said, also dropping a pin to add Resolute Chakotay next round. ;-)

    Leah Brahms was also overlooked.
    Intentionally Left Blank
  • Great job @Leshy, maintain course :smile:
    I saw just yesterday Mission: Impossible (1996), where Job 314 was a central plot device, but they didn't mention Pi...
  • On the Missions sheet Under Distress Call - Infinity, Mudd's Enterprise is marked as mission 7.
    It's mission 8.
Sign In or Register to comment.