Home Ready Room

Do Not Airlock Checklist Thread 4

1252628303164

Comments

  • ACEACE ✭✭✭
    Do you mean column B? That's where my fused count shows up.

    I mean column E of import sheet, thats more precise :-)
    Or B of Crew Sheet

    Yes, Crew tab, that's what I meant. Thanks
  • cmdrworf wrote: »
    2 - The ranking is within rarity. I have toyed with adding something "similiar" to tiers but basically it would just lump crew into "tier's" based on their ranking. top x percent is tier 1, etc.... I'm not excited by this which is why we added the ranking and color coded it so its easy to tell a crew's * level.
    Be careful to not rely solely on color-coding things, just as a fore-warning. There are folks like me that are color-blind and can't tell the difference at first glance. :smile:

    Welp, that covers my first thought! I was thinking red-yellow-green for bottom-middle-top of the range. Since that doesn't work for all, I'll have to give it some more thought.
  • cmdrworfcmdrworf ✭✭✭✭✭
    It would be cool if i could see the number of stars i fused in the voyage spreadsheet. Rarity and status are important informations, but it's just as important that I know how advanced the crew is.

    This will be on the Voyage sheet once I publish 4.54 (hopefully later today)
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    Publishing new version:

    Added new collection: Survival Training
    Added Xindi-Aquatic Councilor to Delphic Expanse Collection
    Added new crew: Risa Bashir,Zyree
    Added # of stars to display on Voyage tab
    Sir, I protest! I am NOT a merry man!
  • cmdrworf wrote: »
    It would be cool if i could see the number of stars i fused in the voyage spreadsheet. Rarity and status are important informations, but it's just as important that I know how advanced the crew is.

    This will be on the Voyage sheet once I publish 4.54 (hopefully later today)

    Great, thx a lot.
    But theres is an error now. The formula in column "stars" is only in the first row and is the same as in the column "rarity".
  • cmdrworfcmdrworf ✭✭✭✭✭
    edited May 2021
    cmdrworf wrote: »
    It would be cool if i could see the number of stars i fused in the voyage spreadsheet. Rarity and status are important informations, but it's just as important that I know how advanced the crew is.

    This will be on the Voyage sheet once I publish 4.54 (hopefully later today)


    Great, thx a lot.
    But theres is an error now. The formula in column "stars" is only in the first row and is the same as in the column "rarity".

    Stealth fixed
    Sir, I protest! I am NOT a merry man!
  • AdmiralMemoAdmiralMemo ✭✭✭
    cmdrworf wrote: »
    2 - The ranking is within rarity. I have toyed with adding something "similiar" to tiers but basically it would just lump crew into "tier's" based on their ranking. top x percent is tier 1, etc.... I'm not excited by this which is why we added the ranking and color coded it so its easy to tell a crew's * level.
    Be careful to not rely solely on color-coding things, just as a fore-warning. There are folks like me that are color-blind and can't tell the difference at first glance. :smile:
    Welp, that covers my first thought! I was thinking red-yellow-green for bottom-middle-top of the range. Since that doesn't work for all, I'll have to give it some more thought.
    Don't get me wrong. Color-coding is awesome and helpful. Do it if you can. Just make sure that color-coding isn't the ONLY way you're indicating a thing.
  • cmdrworfcmdrworf ✭✭✭✭✭
    New update being posted:

    Expanded Gauntlet tab to 1500 crew from 1000
    Added New Crew: Party Tilly, EV Suit Garak, Kal'Hyah Bashir, Tribble Quark
    Added EV Suit Garak to "A Little Stroll"

    Also including a new feature:

    Logic has been added to indicate "Need - Collection Only" vs just saying "Need" in the event that a crew is only needed for a collection. I'm hoping this will help everyone make their airlock decisions easier..
    Sir, I protest! I am NOT a merry man!
  • ACEACE ✭✭✭
    I love the feeling of a fresh new sheet! Thanks for all the work you do on it.
    djcg6hlstxyq.jpg
  • AdmiralMemoAdmiralMemo ✭✭✭
    Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.
  • dext74dext74 ✭✭✭✭✭
    Thought -- to simplify updating to a new sheet, it'd be great if there was a "All Missions Completed" button at the top of the missions page similar to the "Max Starbase" button on the stat bonuses!

    Thanks for all your work on this!
  • dext74 wrote: »
    Thought -- to simplify updating to a new sheet, it'd be great if there was a "All Missions Completed" button at the top of the missions page similar to the "Max Starbase" button on the stat bonuses!

    Thanks for all your work on this!

    Interesting, because I was thinking something similar. I imagine that simply selecting all missions (highlight first, hold shift, highlight last, space bar) obviates the need to select who won which episode.
  • dext74 wrote: »
    Thought -- to simplify updating to a new sheet, it'd be great if there was a "All Missions Completed" button at the top of the missions page similar to the "Max Starbase" button on the stat bonuses!

    Thanks for all your work on this!

    Interesting, because I was thinking something similar. I imagine that simply selecting all missions (highlight first, hold shift, highlight last, space bar) obviates the need to select who won which episode.

    Doesn't simply turning off recommendations for crew for missions achieve the same thing? You get no bonus for completing all missions like you do with the starbase so if they are not recommended, you won't get them highlighted
    ----
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.

    What issue are you seeing? I thought we had that one licked...?
  • cmdrworfcmdrworf ✭✭✭✭✭
    klobetime wrote: »
    Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.

    What issue are you seeing? I thought we had that one licked...?

    I thought we did too. @klobetime check my logic in the last field of the stats column. Maybe I broke it there.

    Otherwise @AdmiralMemo can you let us know details or better yet share a copy with us?
    Sir, I protest! I am NOT a merry man!
  • [VIP0]USS Dart[VIP0]USS Dart ✭✭✭
    edited June 2021
    Edit: Nothing to see here, I’m an idiot. 😉
  • cmdrworfcmdrworf ✭✭✭✭✭
    I may have located another bug. I did a new pull from Datacore and updated my sheet. Traveller Wesley shows as immortalized and frozen, yet he is Level 90 and not yet fully equipped in the game. The truly weird thing is that when I look at my crew stats in Datacore, he is correct.

    I did a second pull and a re-update thinking that perhaps I got bad data, with the same result.

    Can you share with me?
    Sir, I protest! I am NOT a merry man!
  • cmdrworf wrote: »
    I may have located another bug. I did a new pull from Datacore and updated my sheet. Traveller Wesley shows as immortalized and frozen, yet he is Level 90 and not yet fully equipped in the game. The truly weird thing is that when I look at my crew stats in Datacore, he is correct.

    I did a second pull and a re-update thinking that perhaps I got bad data, with the same result.

    Can you share with me?

    I sent you a link by pm. Please let me know if I wasn’t successful.

  • Sven LundgrenSven Lundgren ✭✭✭✭✭
    Is anyone else not seeing Event Crew listed? I have EV Suit Tucker thawed and listed as Event Crew but Even Crew is not showing up in the filter.
  • cmdrworfcmdrworf ✭✭✭✭✭
    cmdrworf wrote: »
    I may have located another bug. I did a new pull from Datacore and updated my sheet. Traveller Wesley shows as immortalized and frozen, yet he is Level 90 and not yet fully equipped in the game. The truly weird thing is that when I look at my crew stats in Datacore, he is correct.

    I did a second pull and a re-update thinking that perhaps I got bad data, with the same result.

    Can you share with me?

    I sent you a link by pm. Please let me know if I wasn’t successful.

    It worked. Message sent with the details on what I found.. I don't think there is an issue.
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    klobetime wrote: »
    Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.

    What issue are you seeing? I thought we had that one licked...?

    @AdmiralMemo PM sent with some questions on the sheet you sent me.
    Sir, I protest! I am NOT a merry man!
  • klobetime wrote: »
    Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.
    What issue are you seeing? I thought we had that one licked...?
    I mean, he functions, gladly, but he still displays as "Crist��bal Rios" which means the link to the Wiki is broken.
  • I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.
  • BurrakookaBurrakooka ✭✭
    edited June 2021
    "Facer Rios" is being overridden to Cristobal's stats via Stats tab column RP check for "Rios" in column D

    =if($D404="Rios","Cristóbal Rios",$A404)
  • Loretta {PoF}Loretta {PoF} ✭✭
    edited June 2021
    klobetime wrote: »
    Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.
    What issue are you seeing? I thought we had that one licked...?
    I mean, he functions, gladly, but he still displays as "Crist��bal Rios" which means the link to the Wiki is broken.

    I don't have that problem, google docs in german
  • EV Suit Garak should belong to A Little Stroll collection
  • cmdrworfcmdrworf ✭✭✭✭✭
    edited June 2021
    EV Suit Garak should belong to A Little Stroll collection

    He is. That was added in 4.55 (or should have been. Just checked my DEV copy and he wasn't in it, will be for sure in 4.56)
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.

    Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    cmdrworf wrote: »
    I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.

    Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.

    @[VIP0]USS Dart do you have them marked as Keep on the crew tab? If so, that was why. I fixed it so that won't affect it anymore. (in 4.56)
    Sir, I protest! I am NOT a merry man!
  • cmdrworfcmdrworf ✭✭✭✭✭
    Burrakooka wrote: »
    "Facer Rios" is being overridden to Cristobal's stats via Stats tab column RP check for "Rios" in column D

    =if($D404="Rios","Cristóbal Rios",$A404)

    @Burrakooka Thank you. This is now fixed in 4.56. (coming later this week)
    Sir, I protest! I am NOT a merry man!
Sign In or Register to comment.