4.1 Update!! I've added sooooo many new collections. Basically if there is an episode of Star Trek with two timelines cards in it, I've included it in here!
Also:
Mirror Broken: All the TNG Comic Mirror Crew
Diana Muldur I Presume: Tracing her history across the Trekverse.
New sections for TOS, TNG, DS9, VOY, ENT, DSC and PCD
Noticed something odd in the pair data.
Some cards are not counted in the actual listing ( it is counted in the possible)
My 5/5 Warship EMA for example ... could this be caused by a cut-off somewhere in the calculations ?? .. my datacore import is currently almost 1100 lines ..
Just a suggestion, but in the next version, could you add conditional formatting to the Potential columns to highlight which crew are already at 5/5? It lets me immediately spot which crew should be considered for a cite. Thanks!
One other thing I noticed about the Potentials list when I was playing around with the highlight. "Dark Ages" McCoy is no where to be found (as a potential) and Q as "God" has lost his quotes. It looks like the source in DCImport doesn't have the quotes. No biggie, but I thought you might want to know.
The Guardians of Tomorrow Protecting the Galaxy's Future from itself
Yep I need to go through and fixes quoted crew. It's on the to do list.
The reason I've not done Conditional Formatting is that it takes up a lot of processing time. However that's not a bad shout and I'll look into a way of highlighting these crew.
Somethings changed on Google's end where it's not letting me import the Datacore csv file, nor the same csv from the Github. Currently consulting the DC team about this. Will try and get it working.
Meanwhile the normal functions of the sheet still work, just not the potentials or annoyingly, images.
Okay I've changed nothing about the link that imports the DC data (it's on the hidden sheet DCImport) and now it works. So if you are having problems try using a fresh sheet and see what happens.
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.
Actual question. How do you even copy your player info on a mobile device? I've tried on both Android and iOS devices and it opens as plain text in the browser window, but long tapping does not give me the option to "Select All" and it's impossible to tap and hold to scroll all the way to the bottom.
And yea, I know mobile devices choke and die when you try to copy all this text to the clipboard. That's not what I'm asking about.
Anyway. I don't know how I didn't know about this spreadsheet until now. Looks like something I'll get a lot of use out of. Thanks for keeping it going. It looks like a beast of a project.
Also, tiny problem. (bug?) Both characters whose names begin with double quote marks, "Dark Ages" McCoy and "The Colony" Tilly are both missing their character portrait. Not sure if anything else is messed up with it or not.
Also, DataCore still doesn't have Mirror McCoy and so the spreadsheet seems to just ignore his presence entirely. Is that by design?
The Potential and What If are entirely dependant on the Datacore updating, so when they do so will those parts of the sheet. Sadly out of my hands.
Yes I need to address the problems with anyone with weird quotes or apostaphes.
Just a note, as the Datacore has not been updated for any crew since EV Suit Worf, they will not show up in your rosters. I believe they are working to resolve this.
If you have a big crew roster/freezer ... the recommendations go wonky ...
I recommend removing some lines of duplicate crew from the list to get around this for the time being...
I ran into this problem and noticed this "fix" because i always sort my imports, and i was missing Warhip EMA as my top med-sec in the potential row, while he was top in the active row ..
I concur on that ... duplicates would be irrelevant on the potentials, as the potential max of a dupe is the same for all dupes , and only on the active stats would you have any relevance at the current power of a dupe card to know if a particular dupe will perform better than other cards for shuttles during faction events .
Comments
=IF(D16=TRUE,IMAGE(indirect(address(ARRAYFORMULA(MATCH(REGEXREPLACE(D15,"[^0-9a-zA-Z ]+", ""),'Crew Cache'!$B:$B,0)),4,3,1,"Crew Cache"))),IMAGE("..."))
Edit: Fix now in the main sheet. And also I'm planning a ton of new collections going in soon.
Also:
Looks like Phlox is MIA.
Vahar’ai Saru in "An Obol For Charon".
EV Suit T'Pol too in "Baby It's Cold Outside".
You might be able to add Admiral Forrest to the Vulcan trilogy, sadly he's not in it alive for long.
Just one character but the rest of the sheet is working? Are you using an up to date Datacore export?
Yes I need to go through and sort the apostraphe problem out. Will get that fixed (and "Dark Ages" McCoy too)
Some cards are not counted in the actual listing ( it is counted in the possible)
My 5/5 Warship EMA for example ... could this be caused by a cut-off somewhere in the calculations ?? .. my datacore import is currently almost 1100 lines ..
One other thing I noticed about the Potentials list when I was playing around with the highlight. "Dark Ages" McCoy is no where to be found (as a potential) and Q as "God" has lost his quotes. It looks like the source in DCImport doesn't have the quotes. No biggie, but I thought you might want to know.
Protecting the Galaxy's Future from itself
The reason I've not done Conditional Formatting is that it takes up a lot of processing time. However that's not a bad shout and I'll look into a way of highlighting these crew.
No, I don't know why.
More at 10
Nope, it’s down again.
Meanwhile the normal functions of the sheet still work, just not the potentials or annoyingly, images.
Yes I need to address the problems with anyone with weird quotes or apostaphes.
only google docs. Excel and ODS don't support some functions like QUERY or FILTER.
Ok, found in the intro
I second this. Thank you Captain Idol for all the hard work you have done. Finding this resource has been invaluable.
That is odd. If the Datacore gets round to adding the new crew I'll look into it.
Very strange! Just checked and she's on mine. Have you tried reimporting?
I recommend removing some lines of duplicate crew from the list to get around this for the time being...
I ran into this problem and noticed this "fix" because i always sort my imports, and i was missing Warhip EMA as my top med-sec in the potential row, while he was top in the active row ..