Home Ready Room

STT Level 100 Spreadsheet

123457»

Comments

  • Captain IdolCaptain Idol ✭✭✭✭✭
    Zottex wrote: »
    can you help me to know where are thee anomalies?

    If you can compare the stats on my sheet with the ones you have. Should be simple to create a subsheet to point out the differences. Or just copy the whole ream from mine as the setup of Base-Min-Av-Max should be the same as the L100.
  • Can you make me an example? because i and other people that maintain this sheet take data from this forum or the wiki. so for me there are no problems
  • Captain IdolCaptain Idol ✭✭✭✭✭
    edited January 15
    Zottex wrote: »
    Can you make me an example? because i and other people that maintain this sheet take data from this forum or the wiki. so for me there are no problems

    Check the stats for Little John Riker. He should be CMD 1023 (128-239), DIP 442 (113-245), SEC 1309 (192-354), I know he was one of the errors before, but there were hundreds of small ones like it.
  • JiveDutchJiveDutch ✭✭✭
    I started helping Zottex by going over the character data and syncing with datacore l ( with spot checks to my own ingame crew list i have FF for consistency ).
    1/2/3/4* have been updated, and 5* i am up to F .. hope i get the rest done tomorrow..
  • Thanks JiveDutch
  • JiveDutchJiveDutch ✭✭✭
    Numbers done ... changelog updated , now contemplating how to best check traits

    Fun Fact .. worst offenders were Mirror Regent Worf, Shinzon & Vengefull L'rell ,these crew had minor inconsistencies on all main numbers.
    Overall the inconsistencies were quite small, usually slightly lower than ingame, allmost all differences smaller than 5...
  • Thanks a lot!
  • JiveDutchJiveDutch ✭✭✭
    Traits done ... Bit of work, but the gauntlet matrix should see a slight improvement now ..
  • Can you make me a try of improvement?
  • JiveDutchJiveDutch ✭✭✭
    Zottex wrote: »
    Can you make me a try of improvement?

    Some traits were added to a number of chars after release, like ambassador and engineered, sometimes there was a missing char in the trait so they would not trigger for the matrix properly, some crew had traits changed over time ... from spy to undercover operative...

    So while it does not change how the gauntlet pair matrix works , and this was not a problem for the usual suspects (top chars for most gauntlets) as those were correct, it will now give some recommendations which were previously missed.

  • JiveDutchJiveDutch ✭✭✭
    Sheet Updated
    Big sync with Names, Stats & Traits.
    Crafted a conversion sheet for it to get datacore stats and make easy to copy table for the STTL100 sheet, used some intel from the DNA & CIDAS sheets to make it.. ( thnx guys )

    Noticed a slight pre-existing glitch in the sheet with "Em/3/Green" .. its the only one on the list which reads false in col BQ (FF?)
    According to the formula this is triggered due to / in the name ...
    I recall there used to be multi versions of chars in the sheet by * , was this perhaps used when all tracking was done manually on the sheet ?
    If this is false "Em/3/Green" is not on the overal voyage/gauntlet rankings , if True it is .

    Options would be to manually change that card, or change the way it calcs True/False..
    For now i swapped the char which is checked from / to \ so all will convert to True.
  • Captain IdolCaptain Idol ✭✭✭✭✭
    JiveDutch wrote: »
    Sheet Updated
    Big sync with Names, Stats & Traits.
    Crafted a conversion sheet for it to get datacore stats and make easy to copy table for the STTL100 sheet, used some intel from the DNA & CIDAS sheets to make it.. ( thnx guys )

    Noticed a slight pre-existing glitch in the sheet with "Em/3/Green" .. its the only one on the list which reads false in col BQ (FF?)
    According to the formula this is triggered due to / in the name ...
    I recall there used to be multi versions of chars in the sheet by * , was this perhaps used when all tracking was done manually on the sheet ?
    If this is false "Em/3/Green" is not on the overal voyage/gauntlet rankings , if True it is .

    Options would be to manually change that card, or change the way it calcs True/False..
    For now i swapped the char which is checked from / to \ so all will convert to True.

    What is BQ used for. IIRC it was a legacy thing for crew who were in the sheet but not fully fused, like a 2/4 Captain Kurn who were in there previously. Could it not be removed now?
  • ZottexZottex ✭✭
    edited January 21
    Hello, i see that you have made a very good work.
    we insert manually a row every new crew so if possible please dont sort alphabetically the crew because many people have a copy of this file ( me too) and so can copy only the new row without searching it
  • JiveDutchJiveDutch ✭✭✭
    Zottex wrote: »
    hello, we insert manually a row every new crew. please dont sort alphabetically the crew because many people have a copy of this file ( me too) and so can copy only the new row.
    I had not thought of that .... sorry ... i shall resist the urge to do so in the future..
    For safety ill switch my favorite to the htmlview , to avoid accidental changing of data.
  • Hello mates,
    with the new TRAIT megachange we musr edit too many crew. there is a way to reimport all from datacore?
  • JiveDutchJiveDutch ✭✭✭
    Zottex wrote: »
    Hello mates,
    with the new TRAIT megachange we musr edit too many crew. there is a way to reimport all from datacore?
    We can use the data conversion sheet I made to do the big sync , as the order between the datacore export, and the sheets do not allign 100% ( I'm lookng at you ... cards with "") , people who have their own personal copy of the sheet would need to re-copy that from the original.
    I sent the link to the sheet so you can do it yourself, or if you prefer i can do it.

    i did notice a difference in naming of 2 characters between the export and other sheets.
    "Dark Ages" McCoy & "The Colony" Tilly do not have quotes in the export, but do in the game & other sheets .. those would be 2 small after-edits to make after the import.
    Cristobal Rios seems to import correctly.
  • please make you the copy paste data and make a control that all work. please today i have too many works!
  • Captain IdolCaptain Idol ✭✭✭✭✭
    I just spent a couple of hours making the changes. Best just to plough through it :)
  • ok so is yet updated?
  • JiveDutchJiveDutch ✭✭✭
    Zottex wrote: »
    ok so is yet updated?
    Updated it now , also made a pre and post update "named version" for this.
    And returned the "" to Mccoy & Tilly
Sign In or Register to comment.