Home Ready Room

Captain Idol's Datacore Analysis Sheet (CIDAS V5.6) (New: Better Collection Tracking, Customisable!)

1678911

Comments

  • Legate Damar Legate Damar ✭✭✭✭✭
    I’ll try reimporting after recaps.
  • Legate Damar Legate Damar ✭✭✭✭✭
    edited December 2020
    d8psmk1y4dc9.png

    I was surprised last night to see Dark Ages McCoy shows up as 3/5 but not in the potential category at 5/5.
  • Anyone else get an error every time they try to export from datacore.app/voyage?

    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
  • 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
    =MAX(MAX(INDIRECT("'Converted Data'!BF"&MATCH(B1,  INDIRECT("'Converted Data'!B1:B1492"), 0)&":BT"&MATCH(B1, INDIRECT("'Converted Data'!B1:B1492"), 0))), 1)=F1
    

    Select your preferred format then go make a cup a tea (or two). The primary pair of each crew should then be highlighted.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    joshurtree wrote: »
    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
    =MAX(MAX(INDIRECT("'Converted Data'!BF"&MATCH(B1,  INDIRECT("'Converted Data'!B1:B1492"), 0)&":BT"&MATCH(B1, INDIRECT("'Converted Data'!B1:B1492"), 0))), 1)=F1
    

    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 ..
  • Captain IdolCaptain Idol ✭✭✭✭✭
    JiveDutch wrote: »
    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.
  • JiveDutch wrote: »
    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.
  • PeetsPeets ✭✭✭
    Great work Idol. I wonder if they chron dept calculates what you already have equipped or not.
  • Peets wrote: »
    Great work Idol. I wonder if they chron dept calculates what you already have equipped or not.

    It is based on what you havent equipped
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Peets wrote: »
    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.

    Your honor debt...100% accurately depressing
  • I just realized that neither of the Adira cards appear at my voyage rank despite just imported my latest file from datacore
    qsiimpkcrt26.png

  • NoblemanDK wrote: »
    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

  • NoblemanDKNoblemanDK ✭✭✭
    edited February 2021
    JiveDutch wrote: »
    NoblemanDK wrote: »
    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

    wmjhppxte5cd.png
    That did the trick. Thx for educating me :D
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Expanding the rows for 1000+ crew is on my to do list!
  • 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?
  • In the tab where you import crew. Sort by rarity.
    Maybe it sorts out the same problem as i had(For voyages)
  • Captain IdolCaptain Idol ✭✭✭✭✭
    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.
  • IceCatIceCat ✭✭✭✭✭
    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.
  • NoblemanDK wrote: »
    In the tab where you import crew. Sort by rarity.
    Maybe it sorts out the same problem as i had(For voyages)

    Thanks! That worked :smile:
  • Captain IdolCaptain Idol ✭✭✭✭✭
    I have fixed the sheets now so any crew over 1000 should now register on your roster.
  • JiveDutchJiveDutch ✭✭✭
    edited March 2021
    I have fixed the sheets now so any crew over 1000 should now register on your roster.

    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 ?
  • IceCatIceCat ✭✭✭✭✭
    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.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    Should be a stealth fix. Hmmm Adira and Loth should be appearing. I'll look into it today.
    @IceCat can you DM a share link to your sheet?
  • JiveDutchJiveDutch ✭✭✭
    Yes, grabbed a new copy , can confirm it works at least up to 1112
  • Legate Damar Legate Damar ✭✭✭✭✭
    IceCat wrote: »
    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"
Sign In or Register to comment.