In the formula above you are selecting columns 2, 5 and 6. Column 1 in the table shows images hence why it's blank in the spreadsheet import. That's why you need to offset it by starting with column 2.
EDIT: Also just realised why it broke, it was originally the 4th table on that page, it's now the 3rd table. to find out which one it is you can count the tables listed on the page, look at the source or use the first formula
and after the "table" query you use the number 1 to see what you get. Then just increase that number each by one each time until you find the table you want.
---- The Guardians of Tomorrow Protecting the Galaxy's Future from itself
@cmdrworf Admiral Nechayev is on the crew tab twice
I saw that too. Weird error that caused it. I've got it fixed in 5.03 already which I'll push after this weeks new crew is announced. Please keep reporting any issues you see though, by no means do I catch them all. I accidently found this looking into some other changes/improvements.
Happy New Year. Last update of 2021 has been posted.
"Fixed issue causing Admiral Nechayev showing up twice
Fixed issue with Dilemmas not showing up again.
Added New Crew: Angela Martine, Tawi'Yan Alexander, Mirror Marlena Moreau, Badge-Challenged Linus
Reworked Voyage tab to eliminate future issues around adding columns etc. (thanks to MrSparky) "
I'd like to renew my annual (more than annual?) suggestion that the sheet move from calculating best voyagers by rarity to best voyagers overall. It appears that's what CaptainIdol's sheet does, so the logic may be able to be imported from there.
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I'd like to renew my annual (more than annual?) suggestion that the sheet move from calculating best voyagers by rarity to best voyagers overall. It appears that's what CaptainIdol's sheet does, so the logic may be able to be imported from there.
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
Looks like dilemmas are messed up again. I tried @Negh_var’s suggestion but it didn’t work for me. Maybe because I’m on an iPad so I can’t view source?
Looks like dilemmas are messed up again. I tried @Negh_var’s suggestion but it didn’t work for me. Maybe because I’m on an iPad so I can’t view source?
Dilemmas seems to be importing correctly for me, even forced a reload by changing the 'https' to 'http' as a quick test and then changed it back again.
What do you see when you open the tab?
---- The Guardians of Tomorrow Protecting the Galaxy's Future from itself
Looks like dilemmas are messed up again. I tried @Negh_var’s suggestion but it didn’t work for me. Maybe because I’m on an iPad so I can’t view source?
Dilemmas seems to be importing correctly for me, even forced a reload by changing the 'https' to 'http' as a quick test and then changed it back again.
I'd like to renew my annual (more than annual?) suggestion that the sheet move from calculating best voyagers by rarity to best voyagers overall. It appears that's what CaptainIdol's sheet does, so the logic may be able to be imported from there.
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
The voyage tab does this in a kind of way. I use it for that.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
If I'm understanding you correctly, I do the same thing. What I do is, whenever there's an update with strong Voyage crew, I make a fresh copy of the Google Sheet, then go to the Crew tab and mark it up as if I owned *all* crew at level ∞.
Then I go to the Voyage tab and I copy and paste values so I have a "static" copy of everyone.
And then I set up Filter Views for every combination...cmd/dip, cmd/eng, cmd/sec, etc.
(Actually, I've set everything up so I don't have to re-create the Filter Views every single time).
This gives me an easy way to see where my current crew is at, who should be on my wishlist, who I should cite next, etc.
I'd like to renew my annual (more than annual?) suggestion that the sheet move from calculating best voyagers by rarity to best voyagers overall. It appears that's what CaptainIdol's sheet does, so the logic may be able to be imported from there.
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
Well then, good news for both of you. I've been working on this behind the scenes, and I'm close to having it changed. It functions a bit odd today so I've been slowly tweaking things to not break today, but to allow me to switch it for "tomorrow". I'm hoping to roll this out soon.
I'd like to renew my annual (more than annual?) suggestion that the sheet move from calculating best voyagers by rarity to best voyagers overall. It appears that's what CaptainIdol's sheet does, so the logic may be able to be imported from there.
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
Well then, good news for both of you. I've been working on this behind the scenes, and I'm close to having it changed. It functions a bit odd today so I've been slowly tweaking things to not break today, but to allow me to switch it for "tomorrow". I'm hoping to roll this out soon.
Awesome! If you need any help testing, let me know
That's great to hear! I came here specifically to suggest "could we have a function that lists [Voyage crew: XXX/YYY] out separately?" The overall voyagers list is a useful addition, but if I need to improve a particular skill combo it's harder to identify those crew that need to be leveled/cited/fused.
Thanks for all your hard work keeping this tool up and running!
There's probably a problem with the introduction or import sheet. Duplicate Crew in Introduction Sheet says, that Lieutenant Ogasa is double, but I don't have her at all. When i clear the Import Sheet before i import data from Playertools the double ogawa vanished.
There's probably a problem with the introduction or import sheet. Duplicate Crew in Introduction Sheet says, that Lieutenant Ogasa is double, but I don't have her at all. When i clear the Import Sheet before i import data from Playertools the double ogawa vanished.
That makes no sense. I've not even published a version with Lieutenant Ogawa yet. Thats in Dev right now and hoping to publish this week. Keep an eye on this and let me know if you see it again.
So that problem is caused from Player tools. The last three import lines are Explorer Cutler, Union Q and Lieutenant Ogawa.
Yes, I think so. I looked at all of the formulas, and I don't see anything on the Google Sheet that could possibly cause this.
I just downloaded a fresh Datacore file for myself and I don't see any duplicate lines for Ogawa. Can you look at the actual CSV file from your Datacore profile and see if there's a duplicate there?
So that problem is caused from Player tools. The last three import lines are Explorer Cutler, Union Q and Lieutenant Ogawa.
Yes, I think so. I looked at all of the formulas, and I don't see anything on the Google Sheet that could possibly cause this.
I just downloaded a fresh Datacore file for myself and I don't see any duplicate lines for Ogawa. Can you look at the actual CSV file from your Datacore profile and see if there's a duplicate there?
And it should go away today regardless. I'm planning to release the version with them later today (assuming I get time to add the last two crew). I've been focused on the new backend changes and didn't get to them yet.
So that problem is caused from Player tools. The last three import lines are Explorer Cutler, Union Q and Lieutenant Ogawa.
Yes, I think so. I looked at all of the formulas, and I don't see anything on the Google Sheet that could possibly cause this.
I just downloaded a fresh Datacore file for myself and I don't see any duplicate lines for Ogawa. Can you look at the actual CSV file from your Datacore profile and see if there's a duplicate there?
Ok, Here's what I'm working on for the next release.
I am removing the best X* Sec/Med crew from the recommendation logic, and replacing it with logic to recommend any crew that will improve the Sec/Med that you currently have based on the number of them that you wish to keep and the star level of crew you wish to include. This should give a better recommendation. This means if you have it set to 4* and up, and a 4* crew would help you it would be recommended to unfreeze if frozen, or "need" if you don't own it.
That's great to hear! I came here specifically to suggest "could we have a function that lists [Voyage crew: XXX/YYY] out separately?" The overall voyagers list is a useful addition, but if I need to improve a particular skill combo it's harder to identify those crew that need to be leveled/cited/fused.
Thanks for all your hard work keeping this tool up and running!
@MuadDave Take a look at my comments above and see if that will meet your need. Won't give the numbers but would show who will help.
Comments
Easy way:
in a blank tab/spreadsheet, insert the formula
=IMPORTHTML("https://sttwiki.org/wiki/Voyages#List_of_Dilemmas","table","3")in cell A1That will load the full table.
Then choose which columns you want and modify the formula as cmdrworf has done by selecting which columns you want in your import:
=QUERY(IMPORTHTML("https://sttwiki.org/wiki/Voyages#List_of_Dilemmas","table","3"),"Select Col2,Col5,Col6",1)In the formula above you are selecting columns 2, 5 and 6. Column 1 in the table shows images hence why it's blank in the spreadsheet import. That's why you need to offset it by starting with column 2.
EDIT: Also just realised why it broke, it was originally the 4th table on that page, it's now the 3rd table. to find out which one it is you can count the tables listed on the page, look at the source or use the first formula
=IMPORTHTML("https://sttwiki.org/wiki/Voyages#List_of_Dilemmas","table","3")and after the "table" query you use the number 1 to see what you get. Then just increase that number each by one each time until you find the table you want.The Guardians of Tomorrow
Protecting the Galaxy's Future from itself
I saw that too. Weird error that caused it. I've got it fixed in 5.03 already which I'll push after this weeks new crew is announced. Please keep reporting any issues you see though, by no means do I catch them all. I accidently found this looking into some other changes/improvements.
"Fixed issue causing Admiral Nechayev showing up twice
Fixed issue with Dilemmas not showing up again.
Added New Crew: Angela Martine, Tawi'Yan Alexander, Mirror Marlena Moreau, Badge-Challenged Linus
Reworked Voyage tab to eliminate future issues around adding columns etc. (thanks to MrSparky) "
Happy new year and I'd like to take a chance to thank you and all the other devs for working on this sheet, it's been a huge help in playing the game.
The Guardians of Tomorrow
Protecting the Galaxy's Future from itself
Thank you as always, @cmdrworf ! Happy New Year!
Why am I asking this? Well, I'm an admitted slave to the DNA spreadsheet. If it says to freeze a crew, I do. If it says they're useful, I keep them. (Yes, I appreciate the admonition on the sheet NOT to be a slave.)
At the moment, I have all 1*, 2* and 3* crew immortalized. I have over half the 4* crew immortalized. My voyages consist nearly always of solely 5* crew. When I change the sheet settings to only use 5* crew for voyages, I get a freeze recommendation for everyone except Nurse Faith and Mirror Phlox (for gauntlet). If I were to follow through, I'm concerned that I wouldn't have sufficient good crew for faction events. If the sheet allowed me to select/keep the top 10 (or whatever number makes sense) crew per pair/skill regardless of rarity, I'd like be able to freeze a bunch of 4* crew who aren't used for much.
My $.02 with full appreciation that others may disagree.
I agree - and I believe I've also casually tossed out this suggestion. I think it's more useful for the sheet to consider voyagers on a global level (ie. ignoring star level and just looking at voyage power per crew). I think that's more useful from a roster perspective - so it would be great if it could be implemented
Dilemmas seems to be importing correctly for me, even forced a reload by changing the 'https' to 'http' as a quick test and then changed it back again.
What do you see when you open the tab?
The Guardians of Tomorrow
Protecting the Galaxy's Future from itself
It’s loading again, they must’ve been updating it
The voyage tab does this in a kind of way. I use it for that.
If I'm understanding you correctly, I do the same thing. What I do is, whenever there's an update with strong Voyage crew, I make a fresh copy of the Google Sheet, then go to the Crew tab and mark it up as if I owned *all* crew at level ∞.
Then I go to the Voyage tab and I copy and paste values so I have a "static" copy of everyone.
And then I set up Filter Views for every combination...cmd/dip, cmd/eng, cmd/sec, etc.
(Actually, I've set everything up so I don't have to re-create the Filter Views every single time).
This gives me an easy way to see where my current crew is at, who should be on my wishlist, who I should cite next, etc.
Here's an example of what my "my Voyage if all 5/5" tab looks like.
Well then, good news for both of you. I've been working on this behind the scenes, and I'm close to having it changed. It functions a bit odd today so I've been slowly tweaking things to not break today, but to allow me to switch it for "tomorrow". I'm hoping to roll this out soon.
Awesome! If you need any help testing, let me know
That's great to hear! I came here specifically to suggest "could we have a function that lists [Voyage crew: XXX/YYY] out separately?" The overall voyagers list is a useful addition, but if I need to improve a particular skill combo it's harder to identify those crew that need to be leveled/cited/fused.
Thanks for all your hard work keeping this tool up and running!
That makes no sense. I've not even published a version with Lieutenant Ogawa yet. Thats in Dev right now and hoping to publish this week. Keep an eye on this and let me know if you see it again.
Yes, I think so. I looked at all of the formulas, and I don't see anything on the Google Sheet that could possibly cause this.
I just downloaded a fresh Datacore file for myself and I don't see any duplicate lines for Ogawa. Can you look at the actual CSV file from your Datacore profile and see if there's a duplicate there?
And it should go away today regardless. I'm planning to release the version with them later today (assuming I get time to add the last two crew). I've been focused on the new backend changes and didn't get to them yet.
Added New Crew: Commander Demos, Returning Saru, Lieutenant Ogawa, Kov, Explorer Cutler, Union Q
Plus included backend work for next wave of changes as discussed above. Hoping to move into beta testing soon.
There is no duplicate.
I am removing the best X* Sec/Med crew from the recommendation logic, and replacing it with logic to recommend any crew that will improve the Sec/Med that you currently have based on the number of them that you wish to keep and the star level of crew you wish to include. This should give a better recommendation. This means if you have it set to 4* and up, and a 4* crew would help you it would be recommended to unfreeze if frozen, or "need" if you don't own it.
@MuadDave Take a look at my comments above and see if that will meet your need. Won't give the numbers but would show who will help.