Captain Idol's Datacore Analysis Sheet (New 2.0! Crew Sorting, Images And More!)

[10F] Captain Idol[10F] Captain Idol ✭✭✭
edited November 25 in Ready Room
Latest Update 2.01
Now includes:
  • * Sorting options for all crew sheets!
  • * Images now on the main crew sheets. Crew sheets also sorted by rarity.
  • * Full Voyage Rankings
  • * Smarter and nicer looking Pair lists
  • * Triplet data is now added!

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 V2.01)

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!

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.

ptjz5bikq3tx.png
jo1e8tvw9552.png
2polvutg16ih.png
qinpp8jdaum0.png
ndqpldoqx1dk.png
Ten Forward Loungers - Give Your Best, Get Our Best!
Check out our website to find out more:
https://wiki.tenforwardloungers.com/
«13

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 91; Vip0; 411 Unique Immortals; Fleet: Omega Molecules; Base Lvl 134 (MAX); Playing Since March 2016.
  • 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?
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • [Mirror] Sanoa[Mirror] Sanoa ✭✭✭✭
    edited October 27
    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...?
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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 91; Vip0; 411 Unique Immortals; Fleet: Omega Molecules; Base Lvl 134 (MAX); Playing Since March 2016.
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • dext74dext74 ✭✭✭
    As a data junky, this is super cool. Thanks for sharing!
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • kapukapu ✭✭✭
    thanks!
    also; sweet sweet honor debt
    5kve2e20hhgt.png
    Captain Lvl 91; Vip0; 411 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".
  • [Mirror] Sanoa[Mirror] Sanoa ✭✭✭✭
    edited October 27
    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!
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • [Mirror] Sanoa[Mirror] 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
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • [Mirror] Sanoa[Mirror] 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. :)
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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.
  • 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).
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • 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?
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • [Mirror] Sanoa[Mirror] 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.
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • [Mirror] Sanoa[Mirror] Sanoa ✭✭✭✭
    edited October 27
    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.
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • 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.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • Latest bug fix, ENG/SEC Pairs were showing incorrectly, this has been resolved.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • cmdrworfcmdrworf ✭✭✭
    my Honor debt page didn't update.
  • cmdrworf wrote: »
    my Honor debt page didn't update.

    Hi, close your browser and reopen it, it should update then.
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • cmdrworfcmdrworf ✭✭✭
    fyi, I redid the import and it worked the 2nd time.
  • [Mirror] Sanoa[Mirror] Sanoa ✭✭✭✭
    Months for honor debt are now zero, looks fine.
    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
  • 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! :)
  • 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)
    Ten Forward Loungers - Give Your Best, Get Our Best!
    Check out our website to find out more:
    https://wiki.tenforwardloungers.com/
  • [Mirror] Sanoa[Mirror] Sanoa ✭✭✭✭
    edited October 30
    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?

    Von wegen harmlos und flauschig! Die [Mirror] Tribbles rekrutieren wieder. Euch erwarten: Starbase lvl. 134, Discord und eine nette, hilfsbereite Gemeinschaft.
Sign In or Register to comment.