@cmdrworf Any chance you can explain how the Gauntlet recommendations work? If I'm looking at the code correctly, it looks like it's trying to recommend the top 6 crew for each of the 6 skills, but only if I actually have them. If you own 2 or more of those top 6, the others, while marked with an N in Stats, don't end up getting marked as Need on the main Crew sheet.
For me, this means that the best Gauntlet crew aren't getting recommended to me as Need, even though they would be better / I don't have all of the top 6 gauntlet crew for a skill. (Which is not how I'd really like/expect that to work.)
Ok.... What it does is recommends the top 7. The sheet assumes that all you really need is 2 of those top 7 (in each skill) and you're good. It doesn't look to see if another crew is better then you have, etc. As long as yours are in the top 7 for that skill it considers it done. I know the "2/7" is there I just can't find were the "2" is checked as I'm still digging into this a bit more. Ideally I think I need to change this to work more similar to Voyage crew where it recommends "upgrades" that are x points better then you have. I think this should be in conjunction with the current logic to some degree though.
This appears to be REALLY OLD logic that has not been updated in a long time.
@cmdrworf I made my own Gauntlet sheet to (kind of) do what Sven suggested. happy to share my sheet with you so you can take a look and use whatever is helpful.
I’d love to be able to filter crew I have that I only need for a collection. That would help me know who to immortalize and freeze.
You can do this now, actually. On the Crew tab got to column R (Reason) and click on the filter control, the striped down triangle. Then choose "Filter by condition" and change the "None" dropdown to "Text contains." Then in the box that appears type "Collection" and hit the OK button at the bottom of the dialog. Voila -- you are looking at crew needed for your collections!
I sometimes use "Text starts with" rather than "Text contains" which gives you the list of crew you need only for collections, the ones you can freeze right after immortalizing. Helps if you want to free up a crew slot.
@cmdrworf I made my own Gauntlet sheet to (kind of) do what Sven suggested. happy to share my sheet with you so you can take a look and use whatever is helpful.
I know the "2/7" is there I just can't find were the "2" is checked as I'm still digging into this a bit more.
@cmdrworf I think the check is in KO2:KT2, where it sets condition P or I based on that check, then BF5:BF displays active crew if P and displays best crew if I. (Or something like that.)
Ideally I think I need to change this to work more similar to Voyage crew where it recommends "upgrades" that are x points better then [sp] you have. I think this should be in conjunction with the current logic to some degree though.
I’d love to be able to filter crew I have that I only need for a collection. That would help me know who to immortalize and freeze.
You can do this now, actually. On the Crew tab got to column R (Reason) and click on the filter control, the striped down triangle. Then choose "Filter by condition" and change the "None" dropdown to "Text contains." Then in the box that appears type "Collection" and hit the OK button at the bottom of the dialog. Voila -- you are looking at crew needed for your collections!
I sometimes use "Text starts with" rather than "Text contains" which gives you the list of crew you need only for collections, the ones you can freeze right after immortalizing. Helps if you want to free up a crew slot.
Apologies if this has been covered, but something I'm thinking of since I'm back playing gauntlet more regularly now that Red Angel is released.
Is it possible to include a function where you input the traits and the skill that are being used for gauntlet whenever its on and the sheet calculates the best crew to use for that gauntlet?
This function can include all gauntlet crew that we have and calculates the best crew to use, even if those crew don't match up to the required skill/traits.
So if the skill is DIP and the trains are El-Aurian, Bartender and Marksman (Guinan, basically), but you've got other crew that can perform well regardless of the skill/trait (Gowron, Kahless, Armus etc), the function calculates the best crew to use for that gauntlet.
The sheet already points out what crew are good for gauntlet in particular skills, but so far not with traits. So maybe this function can help for those of us taking gauntlet more seriously?
Is it possible to include a function where you input the traits and the skill that are being used for gauntlet whenever its on and the sheet calculates the best crew to use for that gauntlet?
This function can include all gauntlet crew that we have and calculates the best crew to use, even if those crew don't match up to the required skill/traits.
This functionality is available in the Latest Crew L100 Sheet that can be found here:
@cmdrworf Someone new has a "Federation.Starfleet" trait because they have a period instead of a comma.
EDIT: It's 1701 O'Brien
Doh!. I'll fix it. Thank you. (stealth fix in current version is done).
Another one for my list. I'll need to add error checking to look for periods in that column. That should alleviate that issue in the future once I get that done.
ok, I just added the error check. Next release will have error checking for "." in the trait list so that should help this issue.
Apologies if this has been covered, but something I'm thinking of since I'm back playing gauntlet more regularly now that Red Angel is released.
Is it possible to include a function where you input the traits and the skill that are being used for gauntlet whenever its on and the sheet calculates the best crew to use for that gauntlet?
This function can include all gauntlet crew that we have and calculates the best crew to use, even if those crew don't match up to the required skill/traits.
So if the skill is DIP and the trains are El-Aurian, Bartender and Marksman (Guinan, basically), but you've got other crew that can perform well regardless of the skill/trait (Gowron, Kahless, Armus etc), the function calculates the best crew to use for that gauntlet.
The sheet already points out what crew are good for gauntlet in particular skills, but so far not with traits. So maybe this function can help for those of us taking gauntlet more seriously?
@PhilJS89 Funny you should ask. I'm working on that as I type this. I've got a few different updates in the works right now which is why you see the notes about "behind the scenes updates" in the last two releases. I'm trying to get set to roll out additional features. I'm hoping in the next couple of weeks to release version 4.0 which should include the first wave of these features. Gauntlet is one, and I'm working on incorporating another rating system to provide different opinions on crew for people to consider. There are a few other things in the works as well. We'll see how much I can get done, but it looks like August will provide a bunch of new features.
And before anyone is concerned, unless Datacore changes force it, nothing is being removed.
Dumb question: does the dna spreadsheet include crew in overflow?
If by overflow, you mean duplicates, no. But if you do have duplicates and you use the import feature, you need to make sure that you have your import is properly sorted. Else, it causes some havoc with the Crew screen.
The Guardians of Tomorrow Protecting the Galaxy's Future from itself
I think he might be talking about that temporary holding for crew you have when you don't have any more crew in the quarters. With the countdown-to-airlock timer.
CABTools.app
Ov (Overall) | Vo (Voyage) | Fa (Faction) | Ga (Gauntlet)
Sb (Ship Battle) | Bt (Boss Battle Traits) | Co (Collection) | (Cd (Cadet)
Dumb question: does the dna spreadsheet include crew in overflow?
As @(A) Traveling Man said, Crew in the countdown-to-airlock timer are included on the sheet, but no way to distinguish them. (I started looking at a change to DataCore that exports this value in the CSV, but didn't get far due to work responsibilities.)
Duplicate crew are indicated by the ⧉ character at the end of the level column, but no matter how many copies you have, there will be only one row for the member on the Crew tab. This means that recommendations for duplicate crew are suspect, as the rec will not necessarily be based on your best version -- this is what @Ward Serpentine was mentioning. The sheet will use the stats from the first dup on the Import tab, so sorting that gives you some control over which one is used for the recommendation.
Dumb question: does the dna spreadsheet include crew in overflow?
As @(A) Traveling Man said, Crew in the countdown-to-airlock timer are included on the sheet, but no way to distinguish them. (I started looking at a change to DataCore that exports this value in the CSV, but didn't get far due to work responsibilities.)
Duplicate crew are indicated by the ⧉ character at the end of the level column, but no matter how many copies you have, there will be only one row for the member on the Crew tab. This means that recommendations for duplicate crew are suspect, as the rec will not necessarily be based on your best version -- this is what @Ward Serpentine was mentioning. The sheet will use the stats from the first dup on the Import tab, so sorting that gives you some control over which one is used for the recommendation.
Does that help?
Yes. I was referring to crew in the “countdown to airlock” status.
Another “how the sheet works” question: in settings, I have the sheet track “best” crew at 4* and 5*. For voyages, I have active crew that are “best 4* xxx.” As I add 5* crew that eclipse 4* crew, I would want the sheet to tell me I can freeze that crew.
Another “how the sheet works” question: in settings, I have the sheet track “best” crew at 4* and 5*. For voyages, I have active crew that are “best 4* xxx.” As I add 5* crew that eclipse 4* crew, I would want the sheet to tell me I can freeze that crew.
Does it do so?
Unfortunately no. Both of those are independent. You can turn off the 4* but there is combined best setting (yet). I've been torn on this one. Ive debated trying to redo it into a single setting that looks at all crew for the best versus splitting the 4* and 5*. Thoughts?
Anyone else notice that EV Suit Seven of Nine also shows up in the ENT collection? Not a sheet issue, but where ever datacore gets it's hidden stats from...
The Guardians of Tomorrow Protecting the Galaxy's Future from itself
Anyone else notice that EV Suit Seven of Nine also shows up in the ENT collection? Not a sheet issue, but where ever datacore gets it's hidden stats from...
Yes. It's an error in the hidden traits within the game itself. Same is true for Fesek.
The hidden traits for EV Suit Seven are female,organic,ent,seven,crew_max_rarity_5. That "ent" is wrong, should be "voy".
Comments
@erulin9
Ok.... What it does is recommends the top 7. The sheet assumes that all you really need is 2 of those top 7 (in each skill) and you're good. It doesn't look to see if another crew is better then you have, etc. As long as yours are in the top 7 for that skill it considers it done. I know the "2/7" is there I just can't find were the "2" is checked as I'm still digging into this a bit more. Ideally I think I need to change this to work more similar to Voyage crew where it recommends "upgrades" that are x points better then you have. I think this should be in conjunction with the current logic to some degree though.
This appears to be REALLY OLD logic that has not been updated in a long time.
Ok, I sent you a PM with a link.
You can do this now, actually. On the Crew tab got to column R (Reason) and click on the filter control, the striped down triangle. Then choose "Filter by condition" and change the "None" dropdown to "Text contains." Then in the box that appears type "Collection" and hit the OK button at the bottom of the dialog. Voila -- you are looking at crew needed for your collections!
I sometimes use "Text starts with" rather than "Text contains" which gives you the list of crew you need only for collections, the ones you can freeze right after immortalizing. Helps if you want to free up a crew slot.
@cmdrworf Me, too, if you're interested.
@cmdrworf I think the check is in KO2:KT2, where it sets condition P or I based on that check, then BF5:BF displays active crew if P and displays best crew if I. (Or something like that.)
Agreed
Thank you very much! This is very helpful!
Apologies if this has been covered, but something I'm thinking of since I'm back playing gauntlet more regularly now that Red Angel is released.
Is it possible to include a function where you input the traits and the skill that are being used for gauntlet whenever its on and the sheet calculates the best crew to use for that gauntlet?
This function can include all gauntlet crew that we have and calculates the best crew to use, even if those crew don't match up to the required skill/traits.
So if the skill is DIP and the trains are El-Aurian, Bartender and Marksman (Guinan, basically), but you've got other crew that can perform well regardless of the skill/trait (Gowron, Kahless, Armus etc), the function calculates the best crew to use for that gauntlet.
The sheet already points out what crew are good for gauntlet in particular skills, but so far not with traits. So maybe this function can help for those of us taking gauntlet more seriously?
This functionality is available in the Latest Crew L100 Sheet that can be found here:
https%3A2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1zrObDH5UtTOfSm37pdMVmm7hwr2u6kMDgdWZpwfjON8%2Fedit%23gid%3D1942976
It has the gauntlet calculations you are looking for.
Protecting the Galaxy's Future from itself
EDIT: It's 1701 O'Brien
Doh!. I'll fix it. Thank you. (stealth fix in current version is done).
Another one for my list. I'll need to add error checking to look for periods in that column. That should alleviate that issue in the future once I get that done.
ok, I just added the error check. Next release will have error checking for "." in the trait list so that should help this issue.
@PhilJS89 Funny you should ask. I'm working on that as I type this. I've got a few different updates in the works right now which is why you see the notes about "behind the scenes updates" in the last two releases. I'm trying to get set to roll out additional features. I'm hoping in the next couple of weeks to release version 4.0 which should include the first wave of these features. Gauntlet is one, and I'm working on incorporating another rating system to provide different opinions on crew for people to consider. There are a few other things in the works as well. We'll see how much I can get done, but it looks like August will provide a bunch of new features.
And before anyone is concerned, unless Datacore changes force it, nothing is being removed.
If by overflow, you mean duplicates, no. But if you do have duplicates and you use the import feature, you need to make sure that you have your import is properly sorted. Else, it causes some havoc with the Crew screen.
Protecting the Galaxy's Future from itself
Ov (Overall) | Vo (Voyage) | Fa (Faction) | Ga (Gauntlet)
Sb (Ship Battle) | Bt (Boss Battle Traits) | Co (Collection) | (Cd (Cadet)
As @(A) Traveling Man said, Crew in the countdown-to-airlock timer are included on the sheet, but no way to distinguish them. (I started looking at a change to DataCore that exports this value in the CSV, but didn't get far due to work responsibilities.)
Duplicate crew are indicated by the ⧉ character at the end of the level column, but no matter how many copies you have, there will be only one row for the member on the Crew tab. This means that recommendations for duplicate crew are suspect, as the rec will not necessarily be based on your best version -- this is what @Ward Serpentine was mentioning. The sheet will use the stats from the first dup on the Import tab, so sorting that gives you some control over which one is used for the recommendation.
Does that help?
Yes. I was referring to crew in the “countdown to airlock” status.
Whew. Only in the change log. Fixed for next release, but that was funny one.
Does it do so?
Unfortunately no. Both of those are independent. You can turn off the 4* but there is combined best setting (yet). I've been torn on this one. Ive debated trying to redo it into a single setting that looks at all crew for the best versus splitting the 4* and 5*. Thoughts?
That is incorrect on Datacore then.
Actually, thats not from Datacore. Fixed in this weeks release.
Odd, my datacore export shows Ent.
I should clarify, I don't use the datacore export for that field. It may be wrong.
Protecting the Galaxy's Future from itself
Yes. It's an error in the hidden traits within the game itself. Same is true for Fesek.
The hidden traits for EV Suit Seven are female,organic,ent,seven,crew_max_rarity_5. That "ent" is wrong, should be "voy".