Home Ready Room

Captain Idol's Datacore Analysis Sheet (CIDAS V6.0) (Continuum Best/Trait Finder)

Captain IdolCaptain Idol ✭✭✭✭✭
edited November 2023 in Ready Room
DON'T FORGET YOUR STARBASE BONUSES

Good day to you all!
Some of you might be thinking, oh great, another spreadsheet to maintain! But wait, this one is slightly different! May I introduce...

Captain Idol's Datacore Analysis Sheet!
Yes in ten simple steps you can import you datacore csv file and the sheet will analyse the data within and give you detailed results about your crew roster. Unlike the Do Not Airlock list and the Level 100 Crew list this will give you statistics based on your current skills, bonuses included!

CLICK HERE TO GOTO THE SHEET (current version V6.0)

This includes:
  • * A breakdown of your stars owned and your current Honor Debt and Chron Debt *New*
  • * A list of your crew with their skills and statuses.
  • * Lists of your top crew sorted by both Shuttle and Voyage stats
  • * Pie Charts and more lists, top variants, top traits!
  • * A top 10 list of your best pairs/triplets both for Shuttle and Voyage stats!
  • * A trait list showing you all the traits you own and which crew has them!
  • * A Voyage Calculator to work out who on your crew give you the biggest boost!
  • * Potential Crew, who would be your heaviest hitters should they get cites
  • * What If? Add up to three crew you don't have to your roster, see where they fit in!
  • * Continuum Best Crew and Trait Finder!

sfgoi44lzwwe.png
h77f339j8n8b.png
3w4tpi99zpoe.png


NOTES
This is quite a dense sheet and contains a lot of data, so follow through the guide in the Introduction page then whilst it's processing sit back and let the sheet do it's thing for ten minutes or so. Some people have noted that the Honor page doesn't update, just try closing the sheet and re-opening it and it should refresh. Also use Chrome, Firefox and Opera seem to have problems with Google Sheets
Some users have tried to import stats on mobile/tablet but I wouldn't recommend it. Best to use a computer to do the initial work and then use mobile devices to view the data later.

Using the Potential Crew Updater
This updates your Potential Crew, Images and What If? crew and NOT your datacore import. This is so you can see any new crew that have been added to the game.
  • * Uncheck the button on the "Intro" screen. Now wait a few minutes for the update. Do this too fast and it won't work.
  • * Recheck it, wait again for the sheet to reload. You should have all the latest crew stats/image info when the Datacore adds it.
  • *Make sure your starbase bonuses are correct! This will only effect potential crew, not your actual roster which already has this in account.

DON'T FORGET YOUR STARBASE BONUSES
«13456713

Comments

  • kapukapu ✭✭✭
    wow, managed to get it to work... so I have 579 crew in total, huh. didn't know that lol

    didnt have time to make a cup of tea thou, was still reading thru the intro page guide when it finished processing the data. But I really need a cup of tea now :DD
    Captain Lvl 99; Vip0; 552 Unique Immortals; Fleet: Omega Molecules; Base Lvl 134 (MAX); Playing Since March 2016.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    kapu wrote: »
    wow, managed to get it to work... so I have 579 crew in total, huh. didn't know that lol

    didnt have time to make a cup of tea thou, was still reading thru the intro page guide when it finished processing the data. But I really need a cup of tea now :DD

    Just out of interest @kapu did the honor page load up first time?
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    edited October 2019
    This is hilarious. :D Like!
    It is still calculating but I assume that this is correct already:

    0uxml3kmpnpx.png

    30 years... ok... let's see how far I get until they shut down the game. But probably this gets worse each non-pre-flashback-week.

    /edit: Oh wait... 30 years and 15 months...?
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • kapukapu ✭✭✭
    Just out of interest @kapu did the honor page load up first time?

    maybe. But I tried to sort the crew list couple of times before checking the honor page so the sheet processed the data couple of times before I looked at the honor. Might be unrelated dunno.

    Speaking of sorting, what would be the correct way to point to the pV score column? Using number 15 resulted in sorting by the first column ie the id number instead. (managed to sort by 'DC Vrank' as the next best thing using 9)
    Captain Lvl 99; Vip0; 552 Unique Immortals; Fleet: Omega Molecules; Base Lvl 134 (MAX); Playing Since March 2016.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    This is hilarious. :D Like!
    It is still calculating but I assume that this is correct already:

    0uxml3kmpnpx.png

    30 years... ok... let's see how far I get until they shut down the game. But probably this gets worse each non-flashback-week.

    /edit: Oh wait... 30 years and 15 months...?

    Yeh I'm pretty sure I got the code wrong for that. It's mostly guess work. Either that or it's for a planet with bigger seasonal drift and 28 hour days.
  • dext74dext74 ✭✭✭✭✭
    As a data junky, this is super cool. Thanks for sharing!
  • Captain IdolCaptain Idol ✭✭✭✭✭
    kapu wrote: »
    Just out of interest @kapu did the honor page load up first time?

    maybe. But I tried to sort the crew list couple of times before checking the honor page so the sheet processed the data couple of times before I looked at the honor. Might be unrelated dunno.

    Speaking of sorting, what would be the correct way to point to the pV score column? Using number 15 resulted in sorting by the first column ie the id number instead. (managed to sort by 'DC Vrank' as the next best thing using 9)

    15 should work but I tested it on my sheet and does that same thing. Hmm I will look into that one.
    the Voyage scores are all on lists on other sheets however.
    I might see if I can come up with a dropdown switch for sorting data on that page.
  • kapukapu ✭✭✭
    thanks!
    also; sweet sweet honor debt
    5kve2e20hhgt.png
    Captain Lvl 99; Vip0; 552 Unique Immortals; Fleet: Omega Molecules; Base Lvl 134 (MAX); Playing Since March 2016.
  • I created the crew.csv, uploaded it to my google drive and when it comes to file > import I can select it, choose the select button (other language so idk the english term there) and it does something for a short time but I don't get any option like "replace current sheet".
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    edited October 2019
    If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...

    But... this is AWESOME work, really. Thanks for sharing!
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    I created the crew.csv, uploaded it to my google drive and when it comes to file > import I can select it, choose the select button (other language so idk the english term there) and it does something for a short time but I don't get any option like "replace current sheet".

    In German it is the 4th option from the top, probably it is the same for all languages:

    vjy1sps5wymn.png
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...

    But... this is AWESOME work, really. Thanks for sharing!

    This kind of exists under Top Crew, which sorts all your Voyagers by their total voyage skill. This accounts for all three skills sets.
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...

    But... this is AWESOME work, really. Thanks for sharing!

    This kind of exists under Top Crew, which sorts all your Voyagers by their total voyage skill. This accounts for all three skills sets.

    Hmmm column B + C do, but they are unsorted stat-wise. The other columns only show the main bases and no pairs or totals. But ok, it was just a suggestion. It is your tool. :)
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • I created the crew.csv, uploaded it to my google drive and when it comes to file > import I can select it, choose the select button (other language so idk the english term there) and it does something for a short time but I don't get any option like "replace current sheet".

    In German it is the 4th option from the top, probably it is the same for all languages:

    vjy1sps5wymn.png

    Didn't get that menu selection in firefox, worked in chrome.
  • dext74dext74 ✭✭✭✭✭
    Oh god. 37 years for my honor debt. I regret loading this sheet.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...

    But... this is AWESOME work, really. Thanks for sharing!

    This kind of exists under Top Crew, which sorts all your Voyagers by their total voyage skill. This accounts for all three skills sets.

    Hmmm column B + C do, but they are unsorted stat-wise. The other columns only show the main bases and no pairs or totals. But ok, it was just a suggestion. It is your tool. :)

    Oh so would a list of the crew and their voyage stats similar to the L100 Crew chart be more useful. I think I can possibly design that and put it in, shouldn't be too hard (famous last words).
  • Captain IdolCaptain Idol ✭✭✭✭✭
    dext74 wrote: »
    Oh god. 37 years for my honor debt. I regret loading this sheet.

    Take that with a grain of salt, I'm 99.996% sure I've done the time calculation wrong...the years should be correct but very sure the months/days are incorrect.
    Also it's based on you earning 1300 honor a day which you will probably exceed most days.
    So only 34 years maybe?
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...

    But... this is AWESOME work, really. Thanks for sharing!

    This kind of exists under Top Crew, which sorts all your Voyagers by their total voyage skill. This accounts for all three skills sets.

    Hmmm column B + C do, but they are unsorted stat-wise. The other columns only show the main bases and no pairs or totals. But ok, it was just a suggestion. It is your tool. :)
    Oh so would a list of the crew and their voyage stats similar to the L100 Crew chart be more useful. I think I can possibly design that and put it in, shouldn't be too hard (famous last words).

    To be honest I do not know what that looks like, I use a different one with this output:

    r8lbdhydm4a4.png

    It can also be sorted by skill on top.
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Yes that's exactly was the L100 sheet looks like, I will look into it, shouldn't be too hard to extrapolate the data. Sorting might be an issue but it's something I can learn.
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    edited October 2019
    Yes that's exactly was the L100 sheet looks like, I will look into it, shouldn't be too hard to extrapolate the data. Sorting might be an issue but it's something I can learn.

    Wow that would be super-cool! Thanks for even trying!

    /edit: Sorting and color stuff is not that important. We can always set filters at the top row and sort with it.
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Fixed a bug with the crew rarity showing the wrong numbers, it was calculating the sum of all the crew instead of just counting how many there were.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Also I think I fixed the honor time bug, shouldn't show silly suggestions like 15 months in a year. Might have to wait for some feedback on that one.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Latest bug fix, ENG/SEC Pairs were showing incorrectly, this has been resolved.
  • cmdrworfcmdrworf ✭✭✭✭✭
    my Honor debt page didn't update.
    Sir, I protest! I am NOT a merry man!
  • Captain IdolCaptain Idol ✭✭✭✭✭
    cmdrworf wrote: »
    my Honor debt page didn't update.

    Hi, close your browser and reopen it, it should update then.
  • cmdrworfcmdrworf ✭✭✭✭✭
    fyi, I redid the import and it worked the 2nd time.
    Sir, I protest! I am NOT a merry man!
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    Months for honor debt are now zero, looks fine.
    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
  • LeshyLeshy ✭✭✭
    This seems eerily similar to Leshy's Do Not Airlock List
    What can I say, his use of the Nunito font inspired me.
    I'll take any time someone releases a sheet that's mentioned as looking like the DNA Checklist as a compliment!

    Looks like another useful tool, look forward to playing around with it! :)
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Leshy wrote: »
    This seems eerily similar to Leshy's Do Not Airlock List
    What can I say, his use of the Nunito font inspired me.
    I'll take any time someone releases a sheet that's mentioned as looking like the DNA Checklist as a compliment!

    Looks like another useful tool, look forward to playing around with it! :)

    Nunito baby! It's a beautiful font (also Conditional Formatting with code was a new experience for me, thanks for that)
  • MiT SanoaMiT Sanoa ✭✭✭✭✭
    edited October 2019
    To me the "Top something" ranking on the "Lists and Pies" tab is inconsistent. At least it was confusing to me at first.

    93xx7w2ynsub.png

    E.g. my Gary Seven is not levelled yet, still he is #2 in the Gauntlet Top 50 but he is nowhere in the Top 50 Voyagers list even though he would be there quite prominent if he was levelled.

    I conclude that the Gauntleteers ranking is drawn from the general ranking ignoring the crew's actual level but the Voyagers' ranking only considers crew which is L100 already, but on the other hand it does not take into account the stars already applied (#2 Sarah Sisko is 2/5 only and currently NOT my second best voyager).

    To decide on whom to level (and cite) next it would make more sense to list crew like in the Gauntlet section (ignoring the current level and fusion) for everything, including the "Worst Voyagers" (maybe removing 4* crew there alltogether as they would dominate this section otherwise).

    /edit: Adding a star to Honey Bare increased (!) my honor debt from 30y0m to 30y1m. Not that it matters too much at this point :D, I just wanted to share the information. Not sure though how the calculation handles crew in the overflow. Overflow Gary Seven was considered for Gauntlet ranking already but maybe was not considered for honor debt before I pulled him out to the active roster?

    Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
Sign In or Register to comment.