Home Ready Room

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

1101113151635

Comments

  • LeshyLeshy ✭✭✭
    edited September 2018
    Thanks ~peregrine~!

    I have stealth-fixed it into the current version, and it will of course be included from here on out.
  • Sorry if this is covered elsewhere, I looked. New user to the checklist, about how long is the wait before new characters are added? Also, what's the best way to merge new edits to the copy on my drive?
    Thanks for the work, it's great.
  • Synthetic CommanderSynthetic Commander ✭✭✭✭✭
    edited September 2018
    It's one person developing this sheet, so it's updated when he has time available. He's applies updates pretty regularly, I typically look for updates every 2-3 events.

    It's not easy to merge edits with this spreadsheet (at least for me). My typical process is:
    1. make a new copy of the current version to your google drive
    2. sort both crew lists by Version - then Name (highlight whole crew page, click Data - Sort range, add another sort column to sort by one then the other).
    3. select the "active", "cryo'd", "notes" (if used) column and copy, paste it from your old version to the new one.
    4. sort your new crew page as desired (I like to sort by Active - Stars (Z to A order) - Name)
    5. set up your advanced settings and completed missions again. you can copy-paste a lot of those from the old to new version.

    note that as you make large number of changes like this, it takes a while for the new spreadsheet to process it all, so it looks for a while like the "active/space/freeze" field for example is not updating. just gotta give it some time.
  • So that you don't have to keep checking back in order to get updates, you can go to Tools, Notification Rules, and set an email alert on changes.
    xzgqzmocjtp7.jpg
  • So, I'm not sure what the error might be but I suspect there is an error, possibly on the Necessities page, involving Off-Duty Tilly.
  • Baarogue wrote: »
    So, I'm not sure what the error might be but I suspect there is an error, possibly on the Necessities page, involving Off-Duty Tilly.

    You think there's an error, but there may not be? Why? What??
  • The only reason you would need Off-Duty Tilly would be for the weekday cadet missions. Of course, that also depends on how many higher level engineers/diplomats you have. Tis the only reason I keep her around.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • Alright, more details then. I have Klingon Empire for Episode 1. A Father Figure is marked Completed. By Hook or By Crook is Not Completed because it's the other faction's choice, but it is the only mission on the Stats page she's flagged for. Marking it as Completed changes nothing, even if I switch my Episode 1 choice to Augments. Off-Duty Tilly is frozen, and marked as needed for cadet roster on my crew page. I currently have Sito, Seska, Worf, and Sci T'Pol active, plus Desert Ezri. Their scores are
    more than sufficient for my eng/dip needs during the week. Other cadet crew that are frozen and marked as needed for cadet roster are Gaia Odo, EMH Mk.1, Nurse Kes, Tasha Yar, Major Kira, and Persis.

    P.S. Mirror T'Pol is listed on the sheet with the curved apostrophe instead of the straight one. "Mirror T’Pol" instead of "Mirror T'Pol."
  • LeshyLeshy ✭✭✭
    Baarogue wrote: »
    Off-Duty Tilly is frozen, and marked as needed for cadet roster on my crew page.
    Hey Baarogue – the behaviour you are describing is not a bug.

    For the cadet missions, the sheet specifically recommends the "best" cadets that allow you to cover all requirements with the least amount of crew. For Diplomacy, for example, that is one of several combinations of Off-Duty Tilly, Gaia Odo, Dabo Girl Leeta, Ensign Sato, or Enterprise-D Picard.

    It may be that you have other crew that are sufficient for the specific missions that you run, in which case the cadet recommendations are not entirely correct for you. I have thought about changing the setup of these cadet recommendations, but it would actually be a good bit of work and add some complexity for a requirement that most people will meet fairly soon in playing the game.
    P.S. Mirror T'Pol is listed on the sheet with the curved apostrophe instead of the straight one. "Mirror T’Pol" instead of "Mirror T'Pol."
    There is no such thing as a straight apostrophe :)

    The ' is actually the prime symbol, and is commonly mistaken for and misused as an apostrophe. The ’ is the only true apostrophe, however. Hm, now I wonder if that makes the ' an apostate instead...
  • Ward SerpentineWard Serpentine ✭✭✭
    edited September 2018
    Leshy wrote: »
    Off-Duty Tilly is frozen, and marked as needed
    The ' is actually the prime symbol, and is commonly mistaken for and misused as an apostrophe. The ’ is the only true apostrophe, however. Hm, now I wonder if that makes the ' an apostate instead...

    Well, sort of. An apostrophe is straight up and down. A single quotation mark (right) is what is typically used for an apostrophe, which looks like an elevated comma. The prime symbol has a slight slant. Most of the time, these symbols are used interchangeably, even though they shouldn't be.

    The only way to accurately represent any of these characters is to use the Unicode (ALT + 4 digit number) or a character map. If you look up the character, for example in Windows Character Map, you will see that it has a U+4 digit number. This is a hexadecimal number and would need to be converted to decimal in order to be keyed in with a standard keyboard (using the number pad, not the numbers across the top of the keyboard) or by editing your registry to allow hexadecimal ALT codes.

    An apostrophe (U+0027) is ALT-0039 and produces the ' punctuation mark.
    A prime (U+2032) produces the ′ punctuation mark.
    A right quote (U+2019) produces the ’ punctuation mark.

    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • BaarogueBaarogue ✭✭
    edited September 2018
    Leshy wrote: »
    Baarogue wrote: »
    Off-Duty Tilly is frozen, and marked as needed for cadet roster on my crew page.
    Hey Baarogue – the behaviour you are describing is not a bug.

    For the cadet missions, the sheet specifically recommends the "best" cadets that allow you to cover all requirements with the least amount of crew. For Diplomacy, for example, that is one of several combinations of Off-Duty Tilly, Gaia Odo, Dabo Girl Leeta, Ensign Sato, or Enterprise-D Picard.

    It may be that you have other crew that are sufficient for the specific missions that you run, in which case the cadet recommendations are not entirely correct for you. I have thought about changing the setup of these cadet recommendations, but it would actually be a good bit of work and add some complexity for a requirement that most people will meet fairly soon in playing the game.
    P.S. Mirror T'Pol is listed on the sheet with the curved apostrophe instead of the straight one. "Mirror T’Pol" instead of "Mirror T'Pol."
    There is no such thing as a straight apostrophe :)

    The ' is actually the prime symbol, and is commonly mistaken for and misused as an apostrophe. The ’ is the only true apostrophe, however. Hm, now I wonder if that makes the ' an apostate instead...

    I say "more than sufficient for my eng/dip needs", but I believe Science Officer T'Pol has the Dip needed for all cadet missions, period. She is the more efficient choice for me than to add Odo and/or Tilly. But it's not a big deal. I believe T'Pol is only best because of her traits, and now I think I recall you saying earlier in the thread that traits aren't included in the formula. Thanks for looking into it.

    Re: no such thing as an apostrophe, my practical point is that when I press the "/' key on my keyboard when typing "Mirror T'Pol" in the search field on the sheet, it returns no entries because of the character used.
  • Ward SerpentineWard Serpentine ✭✭✭
    edited September 2018
    Baarogue wrote: »
    Re: no such thing as an apostrophe, my practical point is that when I press the "/' key on my keyboard when typing "Mirror T'Pol" in the search field on the sheet, it returns no entries because of the character used.

    You are correct. In the Stats page, Mirror T'Pol is using the incorrect character. It should be changed from a right quote to an apostrophe. You could change these yourself until the next iteration by going into the hidden Stats page and changing the punctuation. (lines 1057, 1058 and 1059)

    You will need to do a find and replace, as Mirror T’Pol appears in multiple places.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • LeshyLeshy ✭✭✭
    Well, sort of. An apostrophe is straight up and down. A single quotation mark (right) is what is typically used for an apostrophe, which looks like an elevated comma. The prime symbol has a slight slant. Most of the time, these symbols are used interchangeably, even though they shouldn't be.
    You're absolute right, I stand corrected! While nearly all lists of ALT codes I can find do indeed list ALT-39 as having to produce an apostrophe, it actually produces a single quote wherever I try it. I have thus been confusing the two.

    In how this relates to the sheet however, I have already 'fixed' Mirror T'pol, as she should indeed be consistent with the other crew.
    Baarogue wrote: »
    I say "more than sufficient for my eng/dip needs", but I believe Science Officer T'Pol has the Dip needed for all cadet missions, period.
    By default, with no bonuses or matching traits, Science Officer T'Pol has a DIP roll of 278–339.

    The final missions on Epic difficulty in The United Federation and A Certain Formality require a 380 roll to pass the DIP nodes, and there are no matching traits for T'Pol, so she should not be able to cover these.

    Of course, it is entirely possible that you tend to run other missions, or go with a crew setup that allows you to avoid or fail the DIP nodes – the sheet obviously does not take this into account.
  • Leshy wrote: »
    Well, sort of. An apostrophe is straight up and down. A single quotation mark (right) is what is typically used for an apostrophe, which looks like an elevated comma. The prime symbol has a slight slant. Most of the time, these symbols are used interchangeably, even though they shouldn't be.
    You're absolute right, I stand corrected! While nearly all lists of ALT codes I can find do indeed list ALT-39 as having to produce an apostrophe, it actually produces a single quote wherever I try it. I have thus been confusing the two.

    In how this relates to the sheet however, I have already 'fixed' Mirror T'pol, as she should indeed be consistent with the other crew.
    Baarogue wrote: »
    I say "more than sufficient for my eng/dip needs", but I believe Science Officer T'Pol has the Dip needed for all cadet missions, period.
    By default, with no bonuses or matching traits, Science Officer T'Pol has a DIP roll of 278–339.

    The final missions on Epic difficulty in The United Federation and A Certain Formality require a 380 roll to pass the DIP nodes, and there are no matching traits for T'Pol, so she should not be able to cover these.

    Of course, it is entirely possible that you tend to run other missions, or go with a crew setup that allows you to avoid or fail the DIP nodes – the sheet obviously does not take this into account.

    Ah, right. A Certain Formality does have epic missions, doesn't it. It's been so long since I ran those I entirely forgot. Thanks.
  • Baarogue wrote: »
    Re: no such thing as an apostrophe, my practical point is that when I press the "/' key on my keyboard when typing "Mirror T'Pol" in the search field on the sheet, it returns no entries because of the character used.

    You are correct. In the Stats page, Mirror T'Pol is using the incorrect character. It should be changed from a right quote to an apostrophe. You could change these yourself until the next iteration by going into the hidden Stats page and changing the punctuation. (lines 1057, 1058 and 1059)

    You will need to do a find and replace, as Mirror T’Pol appears in multiple places.

    Nah, I can wait until the next version. My goal is just to help Leshy improve the sheet for the future. Sometimes I'm on the right track, like with this, and sometimes I overlook things, like with the cadet missions Leshy corrected me on above. Thanks!
  • I noticed a bug I think: Mirror Keiko is showing SEC instead of SCI. Not sure if this had been previously reported.

    Thank you for all your hard work on this awesome tool.
  • Yep, it's supposed to be science, not security. The values are also way off from what is on the wiki.
    The wiki stats are as follows for a lvl 100 FF/FE Mirror Keiko
    Command 670 (212-435)
    Science 597 (92-234)
    Diplomacy 385 (76-146)
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • LeshyLeshy ✭✭✭
    Yes, it looks like I accidentally copied Mirror K'Ehleyr's stats, rather than put the correct ones in for Mirror Keiko. Fixed in upcoming version, thanks!
  • Ward SerpentineWard Serpentine ✭✭✭
    edited September 2018
    Leshy, The Common Crew collection bug has crept back in. On Collection Data, check the second Advanced Settings cell reference in B8. Should be $F$28 vs $F$29.

    Cell references are also off for Do No Harm ($F$38 vs$F$42)
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • LeshyLeshy ✭✭✭
    Thanks, Ward Serpentine. Fix included in new version!
  • Only two crew entries remain with the wrong apostrophe/quote.
    First Goran’Agar
    RAF Miles O’Brien
    

    Incorrect Skill
    Warship Tuvok has DIP and should be CMD
    

    And lastly, any chance of getting these crew names fixed up for consistency?
    DNA Checklist               Cryostatis
    Smitten Jean Luc Picard     Smitten Jean-Luc Picard
    Rachel Garrett              Captain Rachel Garrett
    Bell Riots Dax              Bell Riots Jadzia Dax
    Dark Ages McCoy             ''Dark Ages'' McCoy
    Satin Lily Sloane           Satin Dress Lily Sloane
    Xindi Insectoid Counselor   Xindi Insectoid Councilor
    

    Thanks for keeping this checklist going! It's no small feat and is greatly appreciated!
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • LeshyLeshy ✭✭✭
    Thanks a lot for the comments!

    I have made the changes in the new version, except for "Dark Ages" McCoy as I think it makes more sense for him to be properly alphabetised under the D.
  • I can live with that one exception :wink:

    With the change for Rachel Garret to Captain Rachel Garret, I advise all users of the DNA checklist to double check these crew members when copying their info into the new version!

    Chancellor Gorkon
    Enemy Lines Sisko
    Malik
    Rachel Garrett
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • FlemmingFlemming ✭✭✭✭✭
    Appreciate the changes, and the userfriendly warning. I did the update last week and noticed no anomalies.
    Intentionally Left Blank
  • PhantumPhantum ✭✭✭
    Hi,
    I noticed Mirror Kirk showing up in my top 4* security, there is an error in the stats sheet listing him as 4 instead of 5 star for security.

    Thanks heaps for your work on the sheet.
  • thank you for this awesome piece of help :-)
  • LeshyLeshy ✭✭✭
    And the new crew and collections are now in and should be working!
  • Leshy, I don't know if you have had a chance yet to add the new collections to the Advanced Settings: Display Cryostasis Collection Requirements block. The Big Goodbye and Delphic Expanse are the two missing. There is something funky going on in the code as well, as when you mark Wild West and Sherwood Forrest to no, the two new collections are marked complete.
    The Guardians of Tomorrow
    Protecting the Galaxy's Future from itself
  • LeshyLeshy ✭✭✭
    Thanks, quick-fixed them into the existing sheet!
Sign In or Register to comment.