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

12931333435

Comments

  • Once you have logged into stt.disruptorbeam.com/player and gotten your game data, there doesn't seem to be any way to actually LOG OUT! If you go to stt.disruptorbeam.com the game has an annoying habit of jumping to the Facebook login screen, which doesn't help if you do not / or do not want to use Facebook to log into the game.

    The work around solution that I have found, is to jump to games.disruptorbeam.com where there is a LOGOUT screen. Then you will need to clear your cache and log in again, so that the game data is downloaded again, instead of just refreshing from cache. I've found the process to be a bit picky, so it may work for you to just try a different browser for the process.
  • MururoaMururoa ✭✭
    edited December 2019
    Really great job Klobetime !
    Maybe you should not mark 'Active' all crew but only those à 100/100 ?
  • klobetime wrote: »
    I really like this sheet but have a difficult time keeping it current with my actual crew. So I decided to forgo manual data entry and use the DataCore crew.csv file. I added a tab to the DNA Checklist that can be used to import the DataCore file, at which point the Crew tab is automatically updated.

    In addition to changing the Level and Active columns on the Crew tab, I made a couple of other small edits as well:
    • Updated the instructions
    • Added a few more stats near the top of the Introduction tab
    • Added an Immortal column to the Crew tab
    • Changed the highlighting of the Name column on the Crew tab to reflect immortalization rather than just fully fused

    It is quite a bit slower than Leshy's unmodified sheet, but there is a lot of duplicate info in the new tabs and the existing ones; I didn't want to do major surgery to the original sheet so it would be easier to replicate this in the future, but it should be possible to speed things up by getting rid of duplication.

    I don't contribute enough to the forums to be allowed to post a link, but prefix the following with https:// and you can see what I've attempted here: docs.google.com/spreadsheets/d/1-wjztyIa-eLcxGAtWYJoKkgL6cwFN6C1ATiZ4kp4rCk/edit?usp=sharing

    Comments welcome!

    Thanks again to Leshy for the existing DNA Checklist, to the DataCore folks for processing the raw DisruptorBeam data into something coherent, and to Captain Idol for giving me the idea to import the DataCore file.

    Awesome work! When I first made the Datacore tool it was originally going to be my Lazy Leshy sheet intended for easy imports but spun off into something more useful. Good stuff!
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • Thx Klobetime, this is really helpful.

    I noticed that the duplicate stats on the introduction page reads from the wrong field.
    Is: =countif('DataCore Massaged'!$L$3:$L,true)
    should be: =countif('DataCore Massaged'!$H$3:$H,true)
  • LeshyLeshy ✭✭✭
    klobetime wrote: »
    I really like this sheet but have a difficult time keeping it current with my actual crew. So I decided to forgo manual data entry and use the DataCore crew.csv file. I added a tab to the DNA Checklist that can be used to import the DataCore file, at which point the Crew tab is automatically updated.
    This is super cool stuff. I will have a look at exactly how you have done this and see if it's straightforward enough to implement, and how to ensure that there would be as little duplication as possible to keep the sheet as speedy as possible. I like that this does not involve having to log in through the sheet itself, and does not prevent anyone from manually inputting their crew if they so prefer.

    In the meantime, I did do a quick update with the most current crew in, now in the OP!

  • Leshy wrote: »
    In the meantime, I did do a quick update with the most current crew in, now in the OP!

    Amazing work, as always!
    Found a little bug since the renaming of "Dark Ages" McCoy: I'm guessing you cut/inserted the row in the Stats sheet, but the formulas on the Introduction worksheet are now not taking him into account for calculations. e.g. Crew immortalized says =countif(Stats!$AZ$6:$AZ,"C")+countif(Stats!$AZ$6:$AZ,"F"), but "Dark Ages" McCoy is on Stats!AZ5, so he's not counted for that number. Similar thing for the Crew Obtained formula.

    Also the stats for Christine Chapel are a tiny bit off. She has DIP 313, SCI 459 (correct) and MED 685 @ 3/4 FE.

  • Updated my version of the DNA Checklist, including the fix Phate_HK found and fixing the error messages on the (hidden) massaged sheet.

    https://docs.google.com/spreadsheets/d/1qrJ0gLoPDXN-ofu1YeCiRaemaR_i0Jn_M4FWitTg1Zc/edit?usp=sharing

    Merry Christmas!
  • Just noticed that Lenara Khan is listed on the Stats tab, but not visible on the Crew tab. That messed up some calculations that I had added on my sheet, but adding the extra row at 452 fixed it.
  • klobetime wrote: »
    Updated my version of the DNA Checklist, including the fix Phate_HK found and fixing the error messages on the (hidden) massaged sheet.

    https://docs.google.com/spreadsheets/d/1qrJ0gLoPDXN-ofu1YeCiRaemaR_i0Jn_M4FWitTg1Zc/edit?usp=sharing

    Merry Christmas!

    Klobetime:

    I'm not sure if this is just me, but I tried your version of the DNA spreadsheet. The lazy person in me loves importing the crew, so thank you. When I did so, the sheet listed 1* Ensign Mayweather as active, which he is certainly not. Not sure if that's just me, a bug, or something I did, but wanted to let you know.
  • edited January 3
    USS Dart wrote:

    I'm not sure if this is just me, but I tried your version of the DNA spreadsheet. The lazy person in me loves importing the crew, so thank you. When I did so, the sheet listed 1* Ensign Mayweather as active, which he is certainly not. Not sure if that's just me, a bug, or something I did, but wanted to let you know.

    I can confirm this. All my 1* crew are frozen but shown as active, except for Stargazer Picard and Will Riker. See my screenshot:

    ryt0mv4tzs1q.png


    EDIT:
    After some investigation I found that those two are the only 1* characters that I don't have multiple copies of. Therefore they are the only ones with value=1 in the 'Immortal' column of 'DataCore Import' table. Characters with multiple frozen copies have numbers greater then 1.

    Solution: On the 'DataCore Massaged' table in 'Frozen' column the formula should look for values > 0 in 'DataCore Import' column 'Immortal':
    i.e. 'DataCore Massaged'!M3
    =if(isblank($B3),"",'DataCore Import'!G2>0)
    
  • After some investigation I found that those two are the only 1* characters that I don't have multiple copies of. Therefore they are the only ones with value=1 in the 'Immortal' column of 'DataCore Import' table. Characters with multiple frozen copies have numbers greater then 1.

    Solution: On the 'DataCore Massaged' table in 'Frozen' column the formula should look for values > 0 in 'DataCore Import' column 'Immortal':
    i.e. 'DataCore Massaged'!M3
    =if(isblank($B3),"",'DataCore Import'!G2>0)
    

    Nice call -- thanks! I updated my sheet with the fix.
  • Leshy wrote: »
    Spukkz explained it correctly: when you did not have Laas, you did not need him for anything. The mission that he is eligible for, was already covered by your Lt. Airiam, so the sheet told you that you could safely airlock Laas if you got him. When you eventually immortalised him and entered him into the sheet, it told you that as a crew member now on your active roster, he could complete that particular mission for you.

    Eriond75 is incidentally also correct, in that if you enter a crew as 2/4, they may not meet the same requirements as they do at 4/4, so the recommendations will also differ. However, I do not think that you did that in this particular case.

    To answer your other question, there are basically six possible scenarios:

    Crew is active, and meets remaining requirements: Active
    Crew is active, and does not meet remaining requirements: Space/Freeze
    Crew is frozen, and meets remaining requirements: Unfreeze
    Crew is frozen, and does not meet remaining requirements: Frozen
    Crew is unobtained, and meets remaining requirements: Need
    Crew is unobtained, and does not meet remaining requirements: Space

    You can set the 'Mark as keep' checkbox to override the recommendations 'Space/Freeze', 'Frozen', and 'Space'.

    And as per above for the episode missions: if you have an active crew member who can complete that mission, unobtained and frozen crew will no longer have that mission counted towards their requirements.

    Leshy and others, I'd like to revisit this. I'm at a place where my crew is choked with 1/4s that do nothing for me. I've generally been reluctant to toss them, since the next event could provide one of them as a 3/4 reward.

    It would be great if I had some indicator that the crew doesn't improve my game. I'm thinking that the easiest way to do this would be to individually add the crew, mark them 4/4, active and let the sheet do its calculations. If I get a "space/freeze", I can safely discard the 1/4.

    Is that the easiest way to manage this aspect of crew?
  • USS Dart wrote: »

    Leshy and others, I'd like to revisit this. I'm at a place where my crew is choked with 1/4s that do nothing for me. I've generally been reluctant to toss them, since the next event could provide one of them as a 3/4 reward.

    It would be great if I had some indicator that the crew doesn't improve my game. I'm thinking that the easiest way to do this would be to individually add the crew, mark them 4/4, active and let the sheet do its calculations. If I get a "space/freeze", I can safely discard the 1/4.

    Is that the easiest way to manage this aspect of crew?

    That sounds like a good idea but have a look at the wiki for final numbers and skill sets too as they might be useful under certain situations. For instance Sarina was listed for freezing on my list but I know she's very useful due to her rare combination of secondary and tertiary skills.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • Synthetic CommanderSynthetic Commander ✭✭✭✭✭
    USS Dart wrote: »

    Leshy and others, I'd like to revisit this. I'm at a place where my crew is choked with 1/4s that do nothing for me. I've generally been reluctant to toss them, since the next event could provide one of them as a 3/4 reward.

    It would be great if I had some indicator that the crew doesn't improve my game. I'm thinking that the easiest way to do this would be to individually add the crew, mark them 4/4, active and let the sheet do its calculations. If I get a "space/freeze", I can safely discard the 1/4.

    Is that the easiest way to manage this aspect of crew?

    That sounds like a good idea but have a look at the wiki for final numbers and skill sets too as they might be useful under certain situations. For instance Sarina was listed for freezing on my list but I know she's very useful due to her rare combination of secondary and tertiary skills.

    I'd add that within this subset of 1/4 crew, it's generally a good idea to prioritize keeping main cast crew such as kirk, over one-off episode crew such as orion slaver. Maybe Slaver will one day eventually have one event, but even lousy kirk variants WILL have events.
  • klobetime wrote: »
    After some investigation I found that those two are the only 1* characters that I don't have multiple copies of. Therefore they are the only ones with value=1 in the 'Immortal' column of 'DataCore Import' table. Characters with multiple frozen copies have numbers greater then 1.

    Solution: On the 'DataCore Massaged' table in 'Frozen' column the formula should look for values > 0 in 'DataCore Import' column 'Immortal':
    i.e. 'DataCore Massaged'!M3
    =if(isblank($B3),"",'DataCore Import'!G2>0)
    

    Nice call -- thanks! I updated my sheet with the fix.

    Klobetime, I'm getting the following error when I try to add a crew manually:

    =iferror(vlookup($A5,'DataCore Massaged'!$C$3:$M,3,false),0)

    I've got a behold and I'm trying to see if one or the other crew helps more. The error might be connected to the sheet limiting entry to only the datacore input.
  • USS Dart wrote: »
    Klobetime, I'm getting the following error when I try to add a crew manually:

    =iferror(vlookup($A5,'DataCore Massaged'!$C$3:$M,3,false),0)

    I've got a behold and I'm trying to see if one or the other crew helps more. The error might be connected to the sheet limiting entry to only the datacore input.

    Message me with the steps you are using to manually add a crew member and I'll be happy to take a look!
  • USS Dart wrote: »
    Is that the easiest way to manage this aspect of crew?

    Easier for me is to clear the row altogether - Active and Keep both unchecked, stars-owned column blank. If it says Space in that state, then the sheet doesn't consider this crew an upgrade for you even if maxed.

    It is a little annoying to me that it doesn't show you the "this crew will be a voyage upgrade for you at 4/4, but not at your current 3/4" type logic if you already have data in the row. But at least pretending you don't have the crew at all does let you peek.
  • USS Dart wrote: »
    Is that the easiest way to manage this aspect of crew?

    Easier for me is to clear the row altogether - Active and Keep both unchecked, stars-owned column blank. If it says Space in that state, then the sheet doesn't consider this crew an upgrade for you even if maxed.

    It is a little annoying to me that it doesn't show you the "this crew will be a voyage upgrade for you at 4/4, but not at your current 3/4" type logic if you already have data in the row. But at least pretending you don't have the crew at all does let you peek.

    I don’t want to speak for Leshy, but I don’t understand the sheet to work that way. I wish it did because that would make assessing a new crew much easier.
  • JiveDutch wrote: »
    Here is me sitting the last month and secretly hoping @Leshy is working on import options of the datacore CSV for the next update/beta ....

    I'm just hoping for an update with the new crew. :smile:
  • Here's to @Leshy enjoying Risa or wherever he is :)
  • @Jim_Falls I hope he is on 22nd century Risa ( we know it's comfy in 2151 and later. Now it may still be some muddy, seismically unstable planet).

    I hope we'll get a 4.x version with auto import from datacore or it's source. But a simple crew manifest update would still be a gift.
  • philsfphilsf ✭✭
    edited February 7
    What is required to update the crew list in the DNA spreadsheet? Is it only the creation of new lines in the Stats sheet? What information is needed for each new crew, and what are the sources (is everything in the Wiki)?

    @klobetime Does your updated version require extra steps in the new sheets, or is simply adding new lines to the Stats sheet enough?
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • You need the new crew in the (hidden) stats sheet. When you look at that you'll notice that a lot goes into the extra data for recommendations etc.
  • I know that we all recognize the huge amount of work @Leshy puts in to produce this for us. I figure we’ll get it when we get it. If I gain new crew in between updates, I just write them on a post-it to add when the new sheet comes in.

  • In the mean time, it would be nice if we could get some news of the work in progress.
    @USS Dart : no need for post-it; just sort by version.
  • philsf wrote: »
    @klobetime Does your updated version require extra steps in the new sheets, or is simply adding new lines to the Stats sheet enough?

    New lines in the Stats and Crew sheets should be enough, although the character pages on https://stt.wiki/ don't all have complete numbers for each star level. I use the formulas on https://stt.wiki/wiki/Crew_Progression to extrapolate the missing values and shade them so I can tell which ones are guesses -- I think this is what @Leshy did as well but not sure.

    I haven't digested everything the original sheet does, but I took a crack at adding the new crew to my version of the sheet: https://docs.google.com/spreadsheets/d/1su8kt4oy1rRlU7D3z5E8TOIGDXFVJXa_dFDP8Vk-Bts/edit?usp=sharing

    Take a look, and let me know where I made any missteps.
  • CuttysarkCuttysark ✭✭✭
    edited February 9
    @Leshy
    Too bad that you feel like parting ways. But sometimes life 'comes-a-callin' and we have to heed the call of nature and move on. :smiley:
    Like your sheet! It's a little too advanced for me right now at my stage in the game but it is still great!
Sign In or Register to comment.