Anyone else get an error every time they try to export from datacore.app/voyage?
Just tried it and it's working fine for me. Make sure you wait for the page to finish loading. Alternatively, open the page in an incognito browser window or try clearing your cookies and cache.
Anyone else get an error every time they try to export from datacore.app/voyage?
Just tried it and it's working fine for me. Make sure you wait for the page to finish loading. Alternatively, open the page in an incognito browser window or try clearing your cookies and cache.
I see the problem... the DBID in the output doesn't match the one in-game. How do I log in on the web when my game shows as being logged in through my Apple ID?
I have created a bit of code that allows me to see what is the primary voyage pair for each crew. By selecting "format -> conditional formating" and then selecting "add another rule". Then under range put "B1:DB1492" and under "format cells if..." select "custom formula is". In the subsequent text box enter the formula
I have created a bit of code that allows me to see what is the primary voyage pair for each crew. By selecting "format -> conditional formating" and then selecting "add another rule". Then under range put "B1:DB1492" and under "format cells if..." select "custom formula is". In the subsequent text box enter the formula
Select your preferred format then go make a cup a tea (or two). The primary pair of each crew should then be highlighted.
I do love conditional formatting, it's a great way to highlight things you might miss. But in the case of this and the backend sheet it uses a lot of processing especially on larger rosters so I tend to avoid it. But you've given me an idea (to add to the backlog of ideas) to add a toggle to enable something like that.
To be clear it wasn't meant a suggestion to be added due to the obvious overhead it adds. It is primarily so that when you bring out another superb version of your sheet and I inevitably delete the old sheet without copying the code across first I have somewhere to retrieve it from. If it helps other people then that's great too.
Is there any progress on the sheet update for big rosters/exports ?
As it is now the pair data sheets ignore all entries that are over 1000 lines in the "Datacore Import" tab.
Ran into this issue again when i was contemplating which crew to best use the campaign citation on today ..
Is there any progress on the sheet update for big rosters/exports ?
As it is now the pair data sheets ignore all entries that are over 1000 lines in the "Datacore Import" tab.
Ran into this issue again when i was contemplating which crew to best use the campaign citation on today ..
Ah I didn't realise anyone had run into this. When I do an update next I'll expand this. For now you can just add another 1000 columns to the bottom of your sheet and reimport and that should fix it.
As it is now the pair data sheets ignore all entries that are over 1000 lines in the "Datacore Import" tab.
Ah I didn't realise anyone had run into this. When I do an update next I'll expand this. For now you can just add another 1000 columns to the bottom of your sheet and reimport and that should fix it.
Which sheet do i need to add these rows ?
When importing using import function they automatically get added to that one...
I'll PM my datacore link so u have something to test against when u have the time..
Quick fix for some rosters to get recommendations working in the current version .
Sort the datacore-import tab to owned , and delete all FALSE lines , this reduced my list to 988 rows and temporarily fixxed it for my sheet.
Great work Idol. I wonder if they chron dept calculates what you already have equipped or not.
I need to go back and rework it but it's based on what set of 10 levels you are at. It's more a rough guide based on averages from the SSR Crew Cost calc than an actual amount. Results may vary.
I just realized that neither of the Adira cards appear at my voyage rank despite just imported my latest file from datacore
They are on mine ( Adira Tal is #9, and EDF Adira #16) ... but since they are new cards .. they may be out of bounds on the import tab .. to far down the rows.
Make sure the cards you want are under 1000 rows ... ( i did this by sorting for Max-Rarity (descending) ) so my 1/2* cards would be over the 1000 rows
I just realized that neither of the Adira cards appear at my voyage rank despite just imported my latest file from datacore
They are on mine ( Adira Tal is #9, and EDF Adira #16) ... but since they are new cards .. they may be out of bounds on the import tab .. to far down the rows.
Make sure the cards you want are under 1000 rows ... ( i did this by sorting for Max-Rarity (descending) ) so my 1/2* cards would be over the 1000 rows
Not that I really care in specific, but in principal it looks to me like Bride Yates is not showing up in the Shuttle Pair and Voyage Pair sheets (at least). I see her as a Potential, but not in the regular CMD/DIP column. When I look at the entry in Datacore Import, nothing jumps out at me for why she wouldn't be showing up. Any ideas on why that might be?
When I get some time I'm going to sit and start working on the next version of this sheet which will include some of these fixes. I'm still unpacking boxes but soon I'll have time to revise a few things.
I may have found a bug. On the Overview tab, my Roster Overview section lists me as having one less Immortal after updating. This was just after acquiring a duplicate copy of a 5 star crew I have FFFE, but not frozen.
My sheet number always is different than the number in the game, but this is the first time I can see a possible reason why.
I've noticed a couple newer crew, Adira Tal and Lothario Q, aren't registering properly in the voyage calculator. Their picture doesn't appear and their stats don't get added in to the totals, throwing off the final estimate. Any idea why?
I even started a new sheet, using the latest version, and still have this issue.
I've noticed a couple newer crew, Adira Tal and Lothario Q, aren't registering properly in the voyage calculator. Their picture doesn't appear and their stats don't get added in to the totals, throwing off the final estimate. Any idea why?
I even started a new sheet, using the latest version, and still have this issue.
NoblemanDK fixed this issue for me: "Ahh. When i import, i sort from z-a in column d
That helps with the way they are shown in all aspects"
Comments
I was surprised last night to see Dark Ages McCoy shows up as 3/5 but not in the potential category at 5/5.
Error
Failed to parse player data from the text you pasted. Make sure the page is loaded correctly and you copied the entire contents!
Yes, I used Ctrl-A and Ctrl-C to get everything on the page from stt.disruptorbeam.com/player
Just tried it and it's working fine for me. Make sure you wait for the page to finish loading. Alternatively, open the page in an incognito browser window or try clearing your cookies and cache.
I see the problem... the DBID in the output doesn't match the one in-game. How do I log in on the web when my game shows as being logged in through my Apple ID?
=MAX(MAX(INDIRECT("'Converted Data'!BF"&MATCH(B1, INDIRECT("'Converted Data'!B1:B1492"), 0)&":BT"&MATCH(B1, INDIRECT("'Converted Data'!B1:B1492"), 0))), 1)=F1Select your preferred format then go make a cup a tea (or two). The primary pair of each crew should then be highlighted.
I do love conditional formatting, it's a great way to highlight things you might miss. But in the case of this and the backend sheet it uses a lot of processing especially on larger rosters so I tend to avoid it. But you've given me an idea (to add to the backlog of ideas) to add a toggle to enable something like that.
As it is now the pair data sheets ignore all entries that are over 1000 lines in the "Datacore Import" tab.
Ran into this issue again when i was contemplating which crew to best use the campaign citation on today ..
Ah I didn't realise anyone had run into this. When I do an update next I'll expand this. For now you can just add another 1000 columns to the bottom of your sheet and reimport and that should fix it.
Which sheet do i need to add these rows ?
When importing using import function they automatically get added to that one...
I'll PM my datacore link so u have something to test against when u have the time..
Sort the datacore-import tab to owned , and delete all FALSE lines , this reduced my list to 988 rows and temporarily fixxed it for my sheet.
It is based on what you havent equipped
I need to go back and rework it but it's based on what set of 10 levels you are at. It's more a rough guide based on averages from the SSR Crew Cost calc than an actual amount. Results may vary.
Your honor debt...100% accurately depressing
They are on mine ( Adira Tal is #9, and EDF Adira #16) ... but since they are new cards .. they may be out of bounds on the import tab .. to far down the rows.
Make sure the cards you want are under 1000 rows ... ( i did this by sorting for Max-Rarity (descending) ) so my 1/2* cards would be over the 1000 rows
That did the trick. Thx for educating me
Maybe it sorts out the same problem as i had(For voyages)
My sheet number always is different than the number in the game, but this is the first time I can see a possible reason why.
Thanks! That worked
Awaiting publication .... ( or is it s fix in the 4.1 from the opening post ?? .. stealth version fix)
ps.. yer signature is still Advertising v3.13 ?
I even started a new sheet, using the latest version, and still have this issue.
@IceCat can you DM a share link to your sheet?
NoblemanDK fixed this issue for me: "Ahh. When i import, i sort from z-a in column d
That helps with the way they are shown in all aspects"