Since this thread was brought back from the dead, I'll add another thing in. The link on the first page does to a document that no longer exists. Is there an updated link?
Its the /htmlview at the end of the URL, which is quicker loading for sheets like this and the BBoBA where most usage is just viewing, and not the editing ( unlike the DNA and CIDAS sheets )
Since this thread was brought back from the dead, I'll add another thing in. The link on the first page does to a document that no longer exists. Is there an updated link?
@Paladin 27 Is it possible to get the Gauntlet selection boxxes on sheet-3 to contain the available traits as a selection ?? ( like in the event selection of traits in the DNA sheet )
I have had it happen a few times where i made typo's there giving me the wrong crew pairs ..
I did a quick try to do it myself with a data-validation ( example copy from dna sheet ) , but could not get it working ...
I've lost track of who's running this so I dunno who to @, but I remembered back in the fall of 2016 when most crew got a little bump, mostly +3% to their max proficiencies. Turns out, those weren't accounted for in the original Level 100 Spreadsheet. I've cross-referenced with the Wiki and provided the information there is accurate, I've been able to identify revisions that ought to be made. (They're highlighted in cyan.) This may be incomplete, since I'm not entirely clear when that took place.
I've added the link to the spreadsheet to The Kirk Offensive blog's links section. Thank you for your work, guys.
(I'm sorry: I'm still new here and can't post links yet).
This resource was used for the Crew and Ship Abilities spreadsheet, which I have taken over. It's normally updated weekly, but I think it's been two weeks since the last update. Is the sheet still being maintained?
I was looking for a way to autofill the "Owned" column on "Crew Stats" table. The solution I found is to make a lookup on my copy of the "Do Not Airlock Checklist" (because I can import my crew data from the DataCore site into the DNA sheet).
The only thing I'm struggling with are the different crew names between the DataCore/DNA and your "Latest Crew lvl 100" sheet.
Would you consider changing the crew names in your sheet to match the ones from DataCore/DNA?
I could provide you with a list of necessary changes for this. Or I could grant you access to my own copy of your "Level 100" sheet, and you can copy the names from there.
Any idea what's going on with this sheet? The version I've been using stopped being updated on November 25th. Thanks to those who have been updating it for so long, enjoy your rest/retirement.
Is there another version of this sheet that is being updated?
Any idea what's going on with this sheet? The version I've been using stopped being updated on November 25th. Thanks to those who have been updating it for so long, enjoy your rest/retirement.
Is there another version of this sheet that is being updated?
I was using the sheet with the gauntlet pair function often to start my gauntlets and get the "best" lineup ...
The Matrix view proved invaluable to me to select my crew for each path & skill..
Is there a way to enter the gauntlet traits to use it in the same way ? ( or do i have to get my eyes checked again ??? )
I was using the sheet with the gauntlet pair function often to start my gauntlets and get the "best" lineup ...
The Matrix view proved invaluable to me to select my crew for each path & skill..
Is there a way to enter the gauntlet traits to use it in the same way ? ( or do i have to get my eyes checked again ??? )
I have a bot available on the discord that does something similar. but not quite as refined to one's individual roster.
Great info, but this is not a replication of the matrix on the 100 list and what it does.
It shows by skill pairing the top crew to use according to the potentials and the current traits.
As for this gauntlet... my crew lineup is Angel, Burnham, Gowron, Locutus and Mambo with max potential in this gauntlet..
If you copy the spreadsheet you can enter the gauntlet traits on the '3. Filters and settings' sheet that updates the '(gauntlet) Top Pairs' sheet.
That is correct (and what i currently do).
But this functionality is not ( as far as i can tell) available in the Hyperstats edition which is updated by [10F] Captain Idol.
If you copy the spreadsheet you can enter the gauntlet traits on the '3. Filters and settings' sheet that updates the '(gauntlet) Top Pairs' sheet.
That is correct (and what i currently do).
But this functionality is not ( as far as i can tell) available in the Hyperstats edition which is updated by [10F] Captain Idol.
Yeh the difference is mine is more a reference of crew stats and I haven't implemented the functionality to enter trait data or personal rosters like the L100 sheet does. But I did put in the grid view of gauntlet pairs and best matches at 5%, although not the best overall view if I'm honest.
This might be something I put forward into the next version of my DC Analysis Sheet though as that's more easily editable by the user.
Thank you very much ... yes .. the CIDAS sheet would be a good place to add this option as well, if the main intention of the Hyper sheet is data lookup, whereas CIDAS is more for "Your crew can do this for you ... potentially" ...
Thank you very much ... yes .. the CIDAS sheet would be a good place to add this option as well, if the main intention of the Hyper sheet is data lookup, whereas CIDAS is more for "Your crew can do this for you ... potentially" ...
Okay CIDAS is an amazing acronym and I'm stealing it
Thank you very much ... yes .. the CIDAS sheet would be a good place to add this option as well, if the main intention of the Hyper sheet is data lookup, whereas CIDAS is more for "Your crew can do this for you ... potentially" ...
Okay CIDAS is an amazing acronym and I'm stealing it
HAHAHAHAHA ... it is what i have been calling my shortcut since you started publicizing it
but i have no time to edit. so if anyone want i can give the power of edit it. make request to me
please we need more people the are capable of edit it
but i have no time to edit. so if anyone want i can give the power of edit it. make request to me
please we need more people the are capable of edit it
This is an awesome offer @Zottex ..
While i unfortunatly do not have the sheets expertise nor the time to keep up 2 date on this .. i do hope you get the help with the sheet..
but i have no time to edit. so if anyone want i can give the power of edit it. make request to me
please we need more people the are capable of edit it
Me and @TemporalAgent7 went through an extensive list of hundreds of anomalies between my sheets and the Datacore stats. We resolved them but wondered if you've kept up to date on that.
As it stands the current L100 sheet has those incorrect stats still in them.
Comments
Think that's a mobile-friendly link. Try this.
There ye go ...
Its the /htmlview
Thanks, @Automaton_2000!
I have had it happen a few times where i made typo's there giving me the wrong crew pairs ..
I did a quick try to do it myself with a data-validation ( example copy from dna sheet ) , but could not get it working ...
https://docs.google.com/spreadsheets/d/1KApd7CL2OTamqunWJhH5q80lQEpJsLzDTaq7-TDUGDc/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1czPEYhyNszsx7BqzYsbicAHKK15w4hjTmYiSp_jKsgg/edit#gid=0
Does most of the same stuff (with a few extra metrics) but is not as good for picking personalized crew or Gauntlet pair statistics.
(I'm sorry: I'm still new here and can't post links yet).
You can just copy/paste the rows you need.
https://docs.google.com/spreadsheets/d/1qMvJXeY2jZ1B18rKpG2uNnhTbPNtcNdyJ96N5plQQE8
Edit: Guys, don't request access. You can view and copy what you need without it. I will private my spreadsheet in a few days. Get what you need now.
This happens with DC Sheet about 3 times a week.
I was looking for a way to autofill the "Owned" column on "Crew Stats" table. The solution I found is to make a lookup on my copy of the "Do Not Airlock Checklist" (because I can import my crew data from the DataCore site into the DNA sheet).
The only thing I'm struggling with are the different crew names between the DataCore/DNA and your "Latest Crew lvl 100" sheet.
Would you consider changing the crew names in your sheet to match the ones from DataCore/DNA?
I could provide you with a list of necessary changes for this. Or I could grant you access to my own copy of your "Level 100" sheet, and you can copy the names from there.
Any idea what's going on with this sheet? The version I've been using stopped being updated on November 25th. Thanks to those who have been updating it for so long, enjoy your rest/retirement.
Is there another version of this sheet that is being updated?
Thanks!
Yes I keep this one updated: https://docs.google.com/spreadsheets/d/1czPEYhyNszsx7BqzYsbicAHKK15w4hjTmYiSp_jKsgg/edit#gid=0
The Matrix view proved invaluable to me to select my crew for each path & skill..
Is there a way to enter the gauntlet traits to use it in the same way ? ( or do i have to get my eyes checked again
I have a bot available on the discord that does something similar.
It shows by skill pairing the top crew to use according to the potentials and the current traits.
As for this gauntlet... my crew lineup is Angel, Burnham, Gowron, Locutus and Mambo with max potential in this gauntlet..
That is correct
But this functionality is not ( as far as i can tell) available in the Hyperstats edition which is updated by [10F] Captain Idol.
Yeh the difference is mine is more a reference of crew stats and I haven't implemented the functionality to enter trait data or personal rosters like the L100 sheet does. But I did put in the grid view of gauntlet pairs and best matches at 5%, although not the best overall view if I'm honest.
This might be something I put forward into the next version of my DC Analysis Sheet though as that's more easily editable by the user.
Okay CIDAS is an amazing acronym and I'm stealing it
HAHAHAHAHA ... it is what i have been calling my shortcut since you started publicizing it
im the owner of the spreadsheet
link:
https://docs.google.com/spreadsheets/d/1zrObDH5UtTOfSm37pdMVmm7hwr2u6kMDgdWZpwfjON8/edit#gid=724122454
but i have no time to edit. so if anyone want i can give the power of edit it. make request to me
please we need more people the are capable of edit it
This is an awesome offer @Zottex ..
While i unfortunatly do not have the sheets expertise nor the time to keep up 2 date on this .. i do hope you get the help with the sheet..
Me and @TemporalAgent7 went through an extensive list of hundreds of anomalies between my sheets and the Datacore stats. We resolved them but wondered if you've kept up to date on that.
As it stands the current L100 sheet has those incorrect stats still in them.