Just an FYI, there appears to be issues with the stats that are showing in the datacore downloads. I have verified there are scattered incorrected stats. I suspect this is causing raking issues which is what is probably casing invalid freeze recommendations. I've reported this in discord to the datacore team.
I noticed that some of my crew stats with all collection bonuses is higher than the ones listed on Big Book fully boosted stats
this might be a new issue. Can you share your sheet with me and let me know who. I don't "think" this is related to the datacore issue. That should just be the rankings so I'll need to look at this one..
In addition to the listed changes, I made a couple of tweaks to the import logic. I've looked at the Datacore logic compared to other sources, and I think what we are seeing on datacore is accurate. They have just cleaned everything up and updated it with all the changes, etc. This did causes significant changes to rankings between 6.25 and 6.26. It seems to be a combination of the version upgrade on datacore and the mass addition of new tiers of collections that impacted crew ratings/stats. I am still doing some comparisons with Datacore and the other sources as I do have a few crew that look out of line but I'm trying to see if that is the case or not. And to be honest it is really just a ton of spot checking when looking for anomalies in the data sets.
IF anyone has some time and wants to help please let me know and I can give you details on what I am looking at as I could use some additional sets of eyes.
"Changed Datacore download link to link to main page and added note in the instructions above about how to access the CSV download.
Added New Crew: Emotionally Heightened T'Lyn, Worst Contact Riker, Displaced Elnor, Displaced Mariner, Out of Time Burnham, Captain Rayner
Added New Series: Short Treks (only Worst Contact Riker, but I anticipate that several existing crew will migrate to this series via hidden trait changes/additions.)
Added New Collection - No Rules"
I posted on their Discord channel and was directed to the profile button, share profile, and then export csv. They said it wasn't working, but I believe I was able to download a good file.
Oh I've been using the beta for months, so I forgot that most people weren't familiar with the change.
I posted on their Discord channel and was directed to the profile button, share profile, and then export csv. They said it wasn't working, but I believe I was able to download a good file.
Oh I've been using the beta for months, so I forgot that most people weren't familiar with the change.
New update coming to allow a collection to be selected for event crew. i.e "Animated". Hoping to get it published before the Mega starts.
Allowing for more than 1 series on the Settings page would be great, since we've gone to THREE series in this upcoming event (TAS, LD, and VST).
@AdmiralMemo I'm actually adding collection vs additional series as series would not cover them all. Ephrim and Dot are discovery yet animated. they are from the "short treks" but their series ID is discovery. Right now they are the only exception, but I want to be sure we accounted for it. This should allow for it and any other exceptions. I'm close to having it ready. I have one small issue I'm working on right now. @mr_sparky and I have been hammering this change out.
Here it is. Support added for the Animated event. Please note, this support was added by way of being able to select a "collection" due to Ephrim and Dot not being in an Animated series. Thanks to @mr_sparky for his work on this release as well. without his help this one would not have made it out for the "start" of this mega.
6.28
"Added New Crew: Renegade Locarno, Projector Spock, Hologram Garak, Goodgey, Orion Hurricane Pike, Orion Hurricane Ortegas
Correct Series from Short Treks to Very Short Treks
Added option in settings for Collection for event crew to suppot the ""Animated"" event."
"Updated script to support changes to settings tab
Major work on support for Adding option in settings for Collection for event crew"
Unfortunately settings for event collection and series do not seem to be working. I saved a brand new copy of 6.28 and imported data. Entering anything into either collection or series seems to have no effect on the sheet. Crew variants and traits working as expected
Unfortunately settings for event collection and series do not seem to be working. I saved a brand new copy of 6.28 and imported data. Entering anything into either collection or series seems to have no effect on the sheet. Crew variants and traits working as expected
Found the error, not sure why it effected both. Stats CA4 line MAP(indirect(Data!$AJ$7),lambda(row,len(row))),"Event Collection",
should be
MAP(indirect(Data!$AJ$6),lambda(row,len(row))),"Event Collection",
Unfortunately settings for event collection and series do not seem to be working. I saved a brand new copy of 6.28 and imported data. Entering anything into either collection or series seems to have no effect on the sheet. Crew variants and traits working as expected
Found the error, not sure why it effected both. Stats CA4 line MAP(indirect(Data!$AJ$7),lambda(row,len(row))),"Event Collection",
should be
MAP(indirect(Data!$AJ$6),lambda(row,len(row))),"Event Collection",
@LT Smash Thanks for catching that. I made a change to that right at the end before I published and didn't catch it. I've done a stealth fix to 6.28. So it can be downloaded again for the fix or the change above can be made to fix it.
I found a bit of a flaw in the Upgrade stuff, which is easily avoidable.
If you place the link to the old sheet in the box, Google Sheets will give you a pop-up saying "Tab to replace with [title of old sheet]" and if you do that, it'll turn into a different type of link to the file.
Whatever this new style of linking is, don't use it, because the Upgrade scripts will give you an "Invalid Link" error when trying to run.
I found a bit of a flaw in the Upgrade stuff, which is easily avoidable.
If you place the link to the old sheet in the box, Google Sheets will give you a pop-up saying "Tab to replace with [title of old sheet]" and if you do that, it'll turn into a different type of link to the file.
Whatever this new style of linking is, don't use it, because the Upgrade scripts will give you an "Invalid Link" error when trying to run.
Yes, Google's been really pushing this feature out aggressively lately, but it's not compatible with scripts, and there's no way for a script to grab the underlying URL. Hopefully they'll fix this sooner or later. Sigh. Right hand, meet left hand.
For now, after your type in (or more likely, copy-n-paste the url for your old GS):
I always just use a fresh Datacore import
but have crew immortalized not in sheet yet
Lately the datacore crew export has been jacked up. Information is not showing up correctly in the crew tab. ie: Crew I froze days ago are still list as needing to be frozen, the level of the crew is not displaying correctly. The information shows up fine if you use the crew export from the steeve tool.
I do not have those problems with my sheet, all crew is lvl 100 and FE, 1512 Immortalized, i just use it to re-freeze crew i used for boss battles, i try to keep 50 slots open for new crew and boss battle
Once in a while i do have error with Datacore import with the Numbers of crew/immortalized not matching my in game count, just refresh the sheet after import and it's fixed, works for me every time
Comments
I'll take a look. I'll try to pull a fresh copy today and play with it.
this might be a new issue. Can you share your sheet with me and let me know who. I don't "think" this is related to the datacore issue. That should just be the rankings so I'll need to look at this one..
In addition to the listed changes, I made a couple of tweaks to the import logic. I've looked at the Datacore logic compared to other sources, and I think what we are seeing on datacore is accurate. They have just cleaned everything up and updated it with all the changes, etc. This did causes significant changes to rankings between 6.25 and 6.26. It seems to be a combination of the version upgrade on datacore and the mass addition of new tiers of collections that impacted crew ratings/stats. I am still doing some comparisons with Datacore and the other sources as I do have a few crew that look out of line but I'm trying to see if that is the case or not. And to be honest it is really just a ton of spot checking when looking for anomalies in the data sets.
IF anyone has some time and wants to help please let me know and I can give you details on what I am looking at as I could use some additional sets of eyes.
"Changed Datacore download link to link to main page and added note in the instructions above about how to access the CSV download.
Added New Crew: Emotionally Heightened T'Lyn, Worst Contact Riker, Displaced Elnor, Displaced Mariner, Out of Time Burnham, Captain Rayner
Added New Series: Short Treks (only Worst Contact Riker, but I anticipate that several existing crew will migrate to this series via hidden trait changes/additions.)
Added New Collection - No Rules"
@AdmiralMemo I'm actually adding collection vs additional series as series would not cover them all. Ephrim and Dot are discovery yet animated. they are from the "short treks" but their series ID is discovery. Right now they are the only exception, but I want to be sure we accounted for it. This should allow for it and any other exceptions. I'm close to having it ready. I have one small issue I'm working on right now. @mr_sparky and I have been hammering this change out.
6.28
"Added New Crew: Renegade Locarno, Projector Spock, Hologram Garak, Goodgey, Orion Hurricane Pike, Orion Hurricane Ortegas
Correct Series from Short Treks to Very Short Treks
Added option in settings for Collection for event crew to suppot the ""Animated"" event."
"Updated script to support changes to settings tab
Major work on support for Adding option in settings for Collection for event crew"
Found the error, not sure why it effected both. Stats CA4 line MAP(indirect(Data!$AJ$7),lambda(row,len(row))),"Event Collection",
should be
MAP(indirect(Data!$AJ$6),lambda(row,len(row))),"Event Collection",
@LT Smash Thanks for catching that. I made a change to that right at the end before I published and didn't catch it. I've done a stealth fix to 6.28. So it can be downloaded again for the fix or the change above can be made to fix it.
@cmdrworf I think Very Short Treks; needs to be added to Data!G22?
Correct. Will be fixed with 6,29 this week.
6.29
"Added New Crew: Orion Hurricane Uhura, Ensign Mesk, Vineyard Boimler, Lt. Sam Kirk
Correct issue with VST not showing up as Animated."
"Added New Crew: Prince Billups, Heroic Shaw, EV Suit Hoshi Sato
Added New Collection: Those Who Can Destroy"
If you place the link to the old sheet in the box, Google Sheets will give you a pop-up saying "Tab to replace with [title of old sheet]" and if you do that, it'll turn into a different type of link to the file.
Whatever this new style of linking is, don't use it, because the Upgrade scripts will give you an "Invalid Link" error when trying to run.
Thanks @AdmiralMemo !
Yes, Google's been really pushing this feature out aggressively lately, but it's not compatible with scripts, and there's no way for a script to grab the underlying URL. Hopefully they'll fix this sooner or later. Sigh. Right hand, meet left hand.
For now, after your type in (or more likely, copy-n-paste the url for your old GS):
but have crew immortalized not in sheet yet
Are you trying to tell me something.
"Added New Crew: Yeoman Leslie Thompson, Ariana, Experienced Traveler Wesley, Dawn Trip Tucker
By Popular Demand : Renamed Variant Tucker to Trip"