I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.
Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.
@[VIP0]USS Dart do you have them marked as Keep on the crew tab? If so, that was why. I fixed it so that won't affect it anymore. (in 4.56)
Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.
What issue are you seeing? I thought we had that one licked...?
I mean, he functions, gladly, but he still displays as "Crist��bal Rios" which means the link to the Wiki is broken.
I don't have that problem, google docs in german
Well, DataCore did a recent update. Let me re-export and see if the issue is solved. Maybe they fixed it on their side? *checks* Nope, that ain't it.
Edit: I checked, and from DataCore's end, the character is definitely correct in the CSV file. It just gets mangled when importing to Google Docs for whatever reason.
Excellent as always, though, the changelog claims the Rios issue is solved when it isn't.
What issue are you seeing? I thought we had that one licked...?
I mean, he functions, gladly, but he still displays as "Crist��bal Rios" which means the link to the Wiki is broken.
I don't have that problem, google docs in german
Well, DataCore did a recent update. Let me re-export and see if the issue is solved. Maybe they fixed it on their side? *checks* Nope, that ain't it.
Edit: I checked, and from DataCore's end, the character is definitely correct in the CSV file. It just gets mangled when importing to Google Docs for whatever reason.
Yeah its google docs. We've got the same issue now with two of the new characters added. they used the other apostrophe and that is messing things up now.
I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.
Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.
@[VIP0]USS Dart do you have them marked as Keep on the crew tab? If so, that was why. I fixed it so that won't affect it anymore. (in 4.56)
No. I don’t have any crew marked “Keep.”
Ah.... they show as Active if there is any need for them and not FFE. I could do "Active - Collection Only" Or something else? Thoughts?
I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.
Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.
@[VIP0]USS Dart do you have them marked as Keep on the crew tab? If so, that was why. I fixed it so that won't affect it anymore. (in 4.56)
No. I don’t have any crew marked “Keep.”
Ah.... they show as Active if there is any need for them and not FFE. I could do "Active - Collection Only" Or something else? Thoughts?
So, let me back up. I thought the purpose of “collection only” was to identify crew who you only need to add to or complete a collection. In other words, they don’t make your crew any stronger. If that’s true, then the logic should report back “collection only” for both crew you own and crew you don’t.
If that’s not the intent, then I simply need to adjust.
I just noticed something and I'm not sure what triggers it. Recommendation of "Roll the Dice!" although the two characters that seem to have that their "# Collections not complete" throws an error of #N/A. Two characters are Commander Barclay and Tucker On-The-Ropes. Checklist 4.55 and the import sheet does list their collections...
I just noticed something and I'm not sure what triggers it. Recommendation of "Roll the Dice!" although the two characters that seem to have that their "# Collections not complete" throws an error of #N/A. Two characters are Commander Barclay and Tucker On-The-Ropes. Checklist 4.55 and the import sheet does list their collections...
@Maxwell 4.55 isn't doing that on mine (but I never guarantee my copy is vanilla as I use it to test dev stuff too). I sent you a message, as I'd like you to share your sheet with me so I can take a look. That usually makes troubleshooting these much easier for me.
I think I've identified another oddity that may be a bug or may be the sheet acting as planned. For me, sorting by "Need-Collection Only" only, only results in crew that I do not have. It doesn't return crew that I have either unfused or unequipped that do not make my crew better.
Hmmm.... Thats not intended functionality. I'll take a look. I must have an error in my logic.
@[VIP0]USS Dart do you have them marked as Keep on the crew tab? If so, that was why. I fixed it so that won't affect it anymore. (in 4.56)
No. I don’t have any crew marked “Keep.”
Ah.... they show as Active if there is any need for them and not FFE. I could do "Active - Collection Only" Or something else? Thoughts?
So, let me back up. I thought the purpose of “collection only” was to identify crew who you only need to add to or complete a collection. In other words, they don’t make your crew any stronger. If that’s true, then the logic should report back “collection only” for both crew you own and crew you don’t.
If that’s not the intent, then I simply need to adjust.
I was trying to improve on the ones that previously just said "Need". I hadn't taken into account anything that said "Active".
That being said perhaps Active needs to be looked at. Currently all active crew (that don't trigger the Freeze condition) say Active. It could be FFE crew, or it could be a level 1, 1* gold worth nothing.
FFE Crew works fairly well with the Freeze recommendations, but I think it starts to fail after that.
I'm open for thoughts/ideas/suggestions on how to improve the "Active" note. I'm not sure whats the best here, but I'm open to ideas for crew that is not FFE.
I just noticed something and I'm not sure what triggers it. Recommendation of "Roll the Dice!" although the two characters that seem to have that their "# Collections not complete" throws an error of #N/A. Two characters are Commander Barclay and Tucker On-The-Ropes. Checklist 4.55 and the import sheet does list their collections...
@Maxwell 4.55 isn't doing that on mine (but I never guarantee my copy is vanilla as I use it to test dev stuff too). I sent you a message, as I'd like you to share your sheet with me so I can take a look. That usually makes troubleshooting these much easier for me.
I responded to your message. Thanks for getting back to me! It might just be something unique to me, but I'm just also not sure even how the "Roll the Dice!" case is supposed to be considered when it is meant to happen/occur.
Added new crew: Kal'Hyah O'Brien, Luma Rahl Kira, Desert Ben Sisko, Displaced Molly O'Brien, Henry Starling
Adjusted logic for "Need - Collection Only"
Fixed EV Suit Garak in "A Little Stroll"
Fixed Facer Rios from pulling in Cristobal Rios stats.
Added new crew: Kal'Hyah O'Brien, Luma Rahl Kira, Desert Ben Sisko, Displaced Molly O'Brien, Henry Starling
Adjusted logic for "Need - Collection Only"
Fixed EV Suit Garak in "A Little Stroll"
Fixed Facer Rios from pulling in Cristobal Rios stats.
Added new crew: Kal'Hyah O'Brien, Luma Rahl Kira, Desert Ben Sisko, Displaced Molly O'Brien, Henry Starling
Adjusted logic for "Need - Collection Only"
Fixed EV Suit Garak in "A Little Stroll"
Fixed Facer Rios from pulling in Cristobal Rios stats.
hm, my voyage tab stays empty
Ugh. I missed two crew on the crew tab and that messed it up. Publishing 4.57 shortly to fix this (and one issue on Molly Obrien)
Added new crew: Kal'Hyah O'Brien, Luma Rahl Kira, Desert Ben Sisko, Displaced Molly O'Brien, Henry Starling
Adjusted logic for "Need - Collection Only"
Fixed EV Suit Garak in "A Little Stroll"
Fixed Facer Rios from pulling in Cristobal Rios stats.
hm, my voyage tab stays empty
Ugh. I missed two crew on the crew tab and that messed it up. Publishing 4.57 shortly to fix this (and one issue on Molly Obrien)
EDIT: Published.
I'm curious...you guys have done an amazing job on this spreadsheet and I'm trying to figure out how parts of it works and *why* you use certain formulas vs others.
On the Voyage tab, the Multiplier column...you're using this formula down the column:
=iferror(ARRAYFORMULA(LARGE(IF(Stats!$DT:$DT>1,Stats!$DT:$DT),A3)))
Couldn't you use something like this?
=query(Stats!$DU:$DU, "Select DU where DU > 0 order by DU desc",0)
And for the other columns on that tab, instead of using the indirect/match, couldn't you use vlookups?
Thanks for the updates. The sheet is taking a really long time to open again. Each time it's like it loads everything from scratch. Would you have any suggestions?
Kal'Hyah O'Brien and Kal'Hyah Bashir have no stats on crew tab
Neither Bashir nor O'Brien have the right apostrophe in the import (and neither does Molly), so importing isn't matching up ` with ��� to give you info.
Sorry everyone, my son was in the hospital. He's home and much better now. I'll look at all of this next week and see if I can get it all fixed. Thank you.
Sorry everyone, my son was in the hospital. He's home and much better now. I'll look at all of this next week and see if I can get it all fixed. Thank you.
You have other priorities and no one should ever complain.
Sorry everyone, my son was in the hospital. He's home and much better now. I'll look at all of this next week and see if I can get it all fixed. Thank you.
You have other priorities and no one should ever complain.
thanks Sven, I've got the new crew done already. Working on the issues. This is a nice escape from reality which is why I love doing it.
"Fixed issue on Voyage tab with Stars and Status not displaying
Added New Crew: Captain Picard Day Picard, Resigned Picard, Desert Jake Sisko
Fixed apostrophe issue on Kal'Hyah O'Brien, Displaced Molly O'Brien, and Kal'Hyah Bashir
Fixed centering on CAB columns"
Thanks for the updates. The sheet is taking a really long time to open again. Each time it's like it loads everything from scratch. Would you have any suggestions?
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
Thanks, you know we're not pushy. Hope everything is well at home. Thanks for working on this for us.
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
If it helps, I found the Dilemmas sheet to be my issue. If I remove the queries in Column E, it opens much better. I would guess that removing all the queries would also help, that page is pretty static, isn't it?
Just a suggestion for the voyage tab, which to be honest I've never actually tried using as I can't actually understand how to use it effectively (do you just pick the ones that have the trait matching going from the top?)
An extra column that will show with a tick if they are flagged as an event crew for Galaxy/Faction events so you don't accidentally put them on a voyage.
It's unlikely that someone would have a crew that would outweigh a high stat one and maybe if I understood the sheet usage better, it may not be needed but suggesting it anyway
---- The Guardians of Tomorrow Protecting the Galaxy's Future from itself
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
If it helps, I found the Dilemmas sheet to be my issue. If I remove the queries in Column E, it opens much better. I would guess that removing all the queries would also help, that page is pretty static, isn't it?
Correction: problem of slow opening came back even after deleting Dilemmas. I removed CABs, and it seems consistently stable now. Maybe it's just formula overload.
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
If it helps, I found the Dilemmas sheet to be my issue. If I remove the queries in Column E, it opens much better. I would guess that removing all the queries would also help, that page is pretty static, isn't it?
Correction: problem of slow opening came back even after deleting Dilemmas. I removed CABs, and it seems consistently stable now. Maybe it's just formula overload.
CAB was my concern as well which is where I've been focusing on Ideas......
Comments
No. I don’t have any crew marked “Keep.”
Edit: I checked, and from DataCore's end, the character is definitely correct in the CSV file. It just gets mangled when importing to Google Docs for whatever reason.
Yeah its google docs. We've got the same issue now with two of the new characters added. they used the other apostrophe and that is messing things up now.
Ah.... they show as Active if there is any need for them and not FFE. I could do "Active - Collection Only" Or something else? Thoughts?
So, let me back up. I thought the purpose of “collection only” was to identify crew who you only need to add to or complete a collection. In other words, they don’t make your crew any stronger. If that’s true, then the logic should report back “collection only” for both crew you own and crew you don’t.
If that’s not the intent, then I simply need to adjust.
@Maxwell 4.55 isn't doing that on mine (but I never guarantee my copy is vanilla as I use it to test dev stuff too). I sent you a message, as I'd like you to share your sheet with me so I can take a look. That usually makes troubleshooting these much easier for me.
I was trying to improve on the ones that previously just said "Need". I hadn't taken into account anything that said "Active".
That being said perhaps Active needs to be looked at. Currently all active crew (that don't trigger the Freeze condition) say Active. It could be FFE crew, or it could be a level 1, 1* gold worth nothing.
FFE Crew works fairly well with the Freeze recommendations, but I think it starts to fail after that.
I'm open for thoughts/ideas/suggestions on how to improve the "Active" note. I'm not sure whats the best here, but I'm open to ideas for crew that is not FFE.
I responded to your message. Thanks for getting back to me! It might just be something unique to me, but I'm just also not sure even how the "Roll the Dice!" case is supposed to be considered when it is meant to happen/occur.
Added new crew: Kal'Hyah O'Brien, Luma Rahl Kira, Desert Ben Sisko, Displaced Molly O'Brien, Henry Starling
Adjusted logic for "Need - Collection Only"
Fixed EV Suit Garak in "A Little Stroll"
Fixed Facer Rios from pulling in Cristobal Rios stats.
hm, my voyage tab stays empty
Ugh. I missed two crew on the crew tab and that messed it up. Publishing 4.57 shortly to fix this (and one issue on Molly Obrien)
EDIT: Published.
I'm curious...you guys have done an amazing job on this spreadsheet and I'm trying to figure out how parts of it works and *why* you use certain formulas vs others.
On the Voyage tab, the Multiplier column...you're using this formula down the column:
=iferror(ARRAYFORMULA(LARGE(IF(Stats!$DT:$DT>1,Stats!$DT:$DT),A3)))
Couldn't you use something like this?
=query(Stats!$DU:$DU, "Select DU where DU > 0 order by DU desc",0)
And for the other columns on that tab, instead of using the indirect/match, couldn't you use vlookups?
You have other priorities and no one should ever complain.
thanks Sven, I've got the new crew done already. Working on the issues. This is a nice escape from reality which is why I love doing it.
"Fixed issue on Voyage tab with Stars and Status not displaying
Added New Crew: Captain Picard Day Picard, Resigned Picard, Desert Jake Sisko
Fixed apostrophe issue on Kal'Hyah O'Brien, Displaced Molly O'Brien, and Kal'Hyah Bashir
Fixed centering on CAB columns"
As to this issue, I've thought I had it fixed a couple of times, and then it shows up again. I'm wondering if its google doing something or something I did. I've got a message out to someone looking for some assistance on this specific issue. I wish I had a timeframe for fixing it, but I do not yet. I am still working on it though.
Thanks, you know we're not pushy. Hope everything is well at home. Thanks for working on this for us.
If it helps, I found the Dilemmas sheet to be my issue. If I remove the queries in Column E, it opens much better. I would guess that removing all the queries would also help, that page is pretty static, isn't it?
An extra column that will show with a tick if they are flagged as an event crew for Galaxy/Faction events so you don't accidentally put them on a voyage.
It's unlikely that someone would have a crew that would outweigh a high stat one and maybe if I understood the sheet usage better, it may not be needed but suggesting it anyway
The Guardians of Tomorrow
Protecting the Galaxy's Future from itself
Correction: problem of slow opening came back even after deleting Dilemmas. I removed CABs, and it seems consistently stable now. Maybe it's just formula overload.
CAB was my concern as well which is where I've been focusing on Ideas......