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

1131415161719»

Comments

  • Thanks, Ward Serpentine!
    Now on Star Trek Timelines as Kathryn Crow's Eye.
  • LeshyLeshy ✭✭✭
    edited February 10
    cmdrworf wrote: »
    Should probably be changed to =if($D117=TRUE,ʺʺ,Stats!$HN$3)
    Yup, you're right. It's fixed now and should stay fixed. Thanks!

    Leshy, thanks for the awesome work this spreadsheet is very useful <3

    No problem, you're welcome!
    Apologies if this has been mentioned but I have version 3.0.1 and 2* L'Rell and Section 31 Georgiou are missing, are they planned for your next update? Thanks so much!

    I had indeed missed the new 2* L'Rell in the previous update. She's in now, along with the new event crew!
  • cmdrworfcmdrworf ✭✭✭
    Thanks again Leshy. Can't say enough about your work with this.
  • I assume found an error in the last version: Kol of House Kor is 4* and Section 31 Philippa Georgiou is 5* in the sheet, I think they just switched places.

    Anyway, thank you very much for this sheet, it's invalueable help to keep track of my crew. :)

    Tfradd
  • HasteurHasteur
    edited February 12
    Sheet Version: 3.03 (2019-02-10)
    Bug: Sphere-Builder Presage is listed in the Dephic Expanse collection.

    Fix solution: On Stats Sheet, Column H, Add "Sphere-Builder Presage"
  • Tfradd wrote: »
    I assume found an error in the last version: Kol of House Kor is 4* and Section 31 Philippa Georgiou is 5* in the sheet, I think they just switched places.

    Anyway, thank you very much for this sheet, it's invalueable help to keep track of my crew. :)

    Tfradd

    It seems to be correct in the 3.03 sheet I'm using.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • Hasteur wrote: »
    Sheet Version: 3.03 (2019-02-10)
    Bug: Sphere-Builder Presage is listed in the Dephic Expanse collection.

    Fix solution: On Stats Sheet, Column H, Add "Sphere-Builder Presage"

    I think that you meant the Data sheet. But he is missing.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • HasteurHasteur
    edited February 13

    I think that you meant the Data sheet. But he is missing.

    No, I mean the stats sheet where membership in collections is tracked. Column H lists the membership of the Delphic Expanse collection.
  • LeshyLeshy ✭✭✭
    You are both right. The Stats sheet tracks which crew are part of what collection, which feeds into the recommendations. However, the Data sheet contains the overview of which crew are part of the custom collections not based on traits or rarity. Adding Sphere-Builder Presage to the Data sheet will cause the Stats sheet to also pick him up correctly.

    I have already fixed it in the 3.03 version that is currently up, and he will be in there in future versions as well.
    Tfradd wrote: »
    I assume found an error in the last version: Kol of House Kor is 4* and Section 31 Philippa Georgiou is 5* in the sheet, I think they just switched places.
    Same as Ward Serpentine: as far as I can tell, they are both correct in the current version 3.03 and I think they also were in 3.02. If they somehow got mixed up for you, you can easily fix it by looking them up in the Stats sheet and setting the correct rarities in column B.

  • SiscardSiscard ✭✭
    edited February 14
    Hi Leshy, sorry if this has been cleared earlier I couldn't find any posts on it, in 3.03 Lonzak is 5* not 3*. It's correct on 3.00 btw.
  • LeshyLeshy ✭✭✭
    Lonzak is a 5* crew, and as far as I can tell, he is also correctly listed as one in 3.03. Maybe I am misunderstanding you?
  • I see this. If this is my mistake, can I corrected by just changing the number to 5? Or will I ruin the formula? u6ajqbxfkq1h.png
  • Siscard wrote: »
    I see this. If this is my mistake, can I corrected by just changing the number to 5? Or will I ruin the formula? u6ajqbxfkq1h.png

    Without looking, I would say that the first thing to do would be to select the cell in question to see if it contains a value, or a formula. If it's a formula leave it alone, otherwise you are probably safe to change it.
  • Hey, yes it does contain a formula that is why I don't risk changing it by simply replacing the number. It is very weird, I did the transition from 3.00 to 3.03 twice already in case I did something wrong but no.
  • LeshyLeshy ✭✭✭
    The place to change the rarity is actually on the Stats sheet, not on the Crew sheet (hit the little button with horizontal lines in the bottom left of the screen to unhide it).

    Alternatively, grab the new 3.04 version :)
  • Thanks Leshy! Keep up the good work! :)
Sign In or Register to comment.