I needed to browse top active crew from my roster (base, max, skill), so I prepared an extra sheet to present the data nicely. If anyone would like to try it out, it is in sheet "Top" here:
DOCS spreadsheets/d/1urLsLrgoiVnJ3S60sXwd4mdPF1QOtUgmzOpbg3OzIT8 (sorry, apparently I can't post links, just add this ID to google docs url to access the sheet)
It should copy/paste nicely. I was considering if it should include frozen crew just to let you know that you might need to thaw them. Maybe I'll make it a switch.
BTW. Is the logic in choosing best gauntlet crew on purpose different from all other? Right now best available gauntleteer might not be marked to keep if he is not in top 7 for his particular skill.
Just noticed that bonuses are applied incorrectly. Formulas in Stats sheet use wrong Settings values. For example to calculate security skill, cell J30 in Settings is used instead of J28. For base security, I29 is used instead I28.
BTW. Is the logic in choosing best gauntlet crew on purpose different from all other? Right now best available gauntleteer might not be marked to keep if he is not in top 7 for his particular skill.
Not really on purpose, just a holdover from the way the original coded it in. I might change it to be in line with the Voyage recommendations at some point. Which in turn, I might also review.
It's a bit of a choice between:
* Have the sheet display who the best crew in the game are for X
* Have the sheet display who would be an upgrade from your current crew for X
Just noticed that bonuses are applied incorrectly. Formulas in Stats sheet use wrong Settings values. For example to calculate security skill, cell J30 in Settings is used instead of J28. For base security, I29 is used instead I28.
Well spotted, it's now fixed. Thanks!
Incidentally, version 3.13 is now available with a few bug fixes and the latest crew in!
It's a bit of a choice between:
* Have the sheet display who the best crew in the game are for X
* Have the sheet display who would be an upgrade from your current crew for X
Yeah, the same is true for all stats, not only Gauntlet. In any way, I think that the sheet should not recommend to space the crew which is my current best representative.
I suppose the original logic was that in Gauntlet you really need the best crew in order to be able to compete with other players. So, maybe a double logic should be applied: calculate "reason to keep" for active crew according to currently owned crew and calculate "reason to keep" for inactive according to the best candidates in the game.
BTW. If anyone was interested, current version of my "best of" table is now on sheet id 1ovoqqRB9BWQxGfz2ViSBCKxEseqyo8nVlqtIZO3OTNg (still can't post links directly).
I'd like to report two things:
1) The Zahl Ambassador does not appear in the combo box for events (at least the 3rd one)
2) An usually hidden tab is visible.
Otherwise, and those 2 things are negligible, a great job.
@Leshy
As usual, great job. I noticed that the conditional formatting rule for the Collections tab was off in Column F.
@Sylv1De
It works in mine, but I rename some of the Variants so that they sort the way I want them to. Check to see if the leading space is in the variant column on the Stats page. I think that it's missing from all of the new 3.13 crew.
The Guardians of Tomorrow Protecting the Galaxy's Future from itself
What does the setting "Display Maximum Base Values" mean/do? Where should I be able to see the Base max? This is what I'm missing from the crew sheet and would love to have one more column displaying the max base for each crew...
What does the setting "Display Maximum Base Values" mean/do? Where should I be able to see the Base max? This is what I'm missing from the crew sheet and would love to have one more column displaying the max base for each crew...
Basically, this shuts off crew of a certain star level from showing up in the Reason column to keep. If you have a lot of 4 star characters, you may want to shut off the 3 star stats. This changes the recommendation to keep/freeze.
I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.
The Guardians of Tomorrow Protecting the Galaxy's Future from itself
I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.
Thanks for the idea. I created a formula for the Notes column to display the max base for the highest skill (as I was not using the Notes column for anything). Here it is:
=TEXTJOIN(" ", TRUE, INDEX({Stats!$BM$3,Stats!$BT$3,Stats!$CA$3,Stats!$CH$3,Stats!$CO$3,Stats!$CV$3}, 1, MATCH(MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}), {Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}, 0)),
MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}) )
Copy that to cell G5 and then copy the formula down to the bottom of the column.
There is a discrepancy for some characters between my formula and the first (highest) listed skill in Skills column, due to the fact that I'm using Base whereas Skills is based on Total (Base + Avg. proficiency).
I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.
Thanks for the idea. I created a formula for the Notes column to display the max base for the highest skill (as I was not using the Notes column for anything). Here it is:
=TEXTJOIN(" ", TRUE, INDEX({Stats!$BM$3,Stats!$BT$3,Stats!$CA$3,Stats!$CH$3,Stats!$CO$3,Stats!$CV$3}, 1, MATCH(MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}), {Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}, 0)),
MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}) )
Copy that to cell G5 and then copy the formula down to the bottom of the column.
A new update is now available with the latest additions in.
Due to a busy offline life, updates are a bit slower around this time and I may not be able to respond as quickly or as much, but rest assured that I appreciate all feedback!
I think the CliffNotes version would be: If its Gold, keep it.
You may need it somewhere, someway, whatever.
If its Purple, level it and freeze it.
But dont feel remorse for dumping it.
Some purples, like Lon Suder, are like the common cold.
If its the matched pair of Dancing Chekov and Grilka..... well, you know
I think the CliffNotes version would be: If its Gold, keep it.
You may need it somewhere, someway, whatever.
If its Purple, level it and freeze it.
But dont feel remorse for dumping it.
Some purples, like Lon Suder, are like the common cold.
If its the matched pair of Dancing Chekov and Grilka..... well, you know
Well, in short and for experienced players maybe, but for starters and intermediate players, this tool is very useful.
A new update is now available with the latest additions in.
Due to a busy offline life, updates are a bit slower around this time and I may not be able to respond as quickly or as much, but rest assured that I appreciate all feedback!
Great job @Leshy, maintain course
I saw just yesterday Mission: Impossible (1996), where Job 314 was a central plot device, but they didn't mention Pi...
Comments
Great work as always!
Just a tiny mistake I've just spotted: stats sheet has Obrist with SCI/CMD/DIP stats instead of SCI/CMD/ENG
DOCS spreadsheets/d/1urLsLrgoiVnJ3S60sXwd4mdPF1QOtUgmzOpbg3OzIT8 (sorry, apparently I can't post links, just add this ID to google docs url to access the sheet)
It should copy/paste nicely. I was considering if it should include frozen crew just to let you know that you might need to thaw them. Maybe I'll make it a switch.
BTW. Is the logic in choosing best gauntlet crew on purpose different from all other? Right now best available gauntleteer might not be marked to keep if he is not in top 7 for his particular skill.
It's a bit of a choice between:
* Have the sheet display who the best crew in the game are for X
* Have the sheet display who would be an upgrade from your current crew for X
Well spotted, it's now fixed. Thanks!
Incidentally, version 3.13 is now available with a few bug fixes and the latest crew in!
Yeah, the same is true for all stats, not only Gauntlet. In any way, I think that the sheet should not recommend to space the crew which is my current best representative.
I suppose the original logic was that in Gauntlet you really need the best crew in order to be able to compete with other players. So, maybe a double logic should be applied: calculate "reason to keep" for active crew according to currently owned crew and calculate "reason to keep" for inactive according to the best candidates in the game.
BTW. If anyone was interested, current version of my "best of" table is now on sheet id 1ovoqqRB9BWQxGfz2ViSBCKxEseqyo8nVlqtIZO3OTNg (still can't post links directly).
1) The Zahl Ambassador does not appear in the combo box for events (at least the 3rd one)
2) An usually hidden tab is visible.
Otherwise, and those 2 things are negligible, a great job.
As usual, great job. I noticed that the conditional formatting rule for the Collections tab was off in Column F.
@Sylv1De
It works in mine, but I rename some of the Variants so that they sort the way I want them to. Check to see if the leading space is in the variant column on the Stats page. I think that it's missing from all of the new 3.13 crew.
Protecting the Galaxy's Future from itself
Think you forgot to prefix the newest "Variant of" with a space...
Basically, this shuts off crew of a certain star level from showing up in the Reason column to keep. If you have a lot of 4 star characters, you may want to shut off the 3 star stats. This changes the recommendation to keep/freeze.
I added six columns on the crew tab to pull the total column (BM, BT, etc) for each character to give me their FE stats for comparison. It's not perfect, but it helps.
Protecting the Galaxy's Future from itself
Thanks for the idea. I created a formula for the Notes column to display the max base for the highest skill (as I was not using the Notes column for anything). Here it is:
=TEXTJOIN(" ", TRUE, INDEX({Stats!$BM$3,Stats!$BT$3,Stats!$CA$3,Stats!$CH$3,Stats!$CO$3,Stats!$CV$3}, 1, MATCH(MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}), {Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}, 0)),
MAX({Stats!$BI5,Stats!$BP5,Stats!$BW5,Stats!$CD5,Stats!$CK5,Stats!$CR5}) )
Copy that to cell G5 and then copy the formula down to the bottom of the column.
Not working for me ...
Strange. Do you get an error message, or what happens? Works perfectly on my sheet.
thanks
Due to a busy offline life, updates are a bit slower around this time and I may not be able to respond as quickly or as much, but rest assured that I appreciate all feedback!
You may need it somewhere, someway, whatever.
If its Purple, level it and freeze it.
But dont feel remorse for dumping it.
Some purples, like Lon Suder, are like the common cold.
If its the matched pair of Dancing Chekov and Grilka..... well, you know
You don't have to use it though
The Guardians of Tomorrow
Protecting the Galaxy's Future from itself
That said, also dropping a pin to add Resolute Chakotay next round. ;-)
Do you need/accept help?
Leah Brahms was also overlooked.
I saw just yesterday Mission: Impossible (1996), where Job 314 was a central plot device, but they didn't mention Pi...
It's mission 8.