Timelines Backend Stats (Super Hyper Edition)

Captain Idol

Morning all. This is probably a known sheet by now but I could warrant it's own thread outside of the Guides & Tips Thread. This is the Timelines Backend Stats (Super Hyper Edition) Spreadsheet
This is my alternative to the L100 Sheet, a hugely invaluble resource which has been kept updated by Paladin. This is essentially the same thing but with a few extra bells and whistles attached. This features everything in the L100 sheets (except for Gauntlet Pairs detailed information) and also includes:

• Detailed breakdowns of crew Voyage and Shuttle Pairs
• Specific and Triplet Skill rankings
• A full list of visable and hidden traits and who owns them
• Main cast variant lists and Portal eligability
• Base and Voyage lists for all crew plus breakouts depending on Rarity.
• Dates of cards added into the game and their mega appearances
• Very detailed rankings of SEC/TRI and PRI/TRI skill orders.
• Stats updated with Bonuses for all current starbase and stat boosting collections.
• Rank Drops over time for both Base skill and Voyage rank and Big Book Tier ranking.
• Discord ready text for showing skills easily and Integrates with Dahj-Bot, a Discord bot designed for pulling stats easily (ask in PM for access).

I update this as soon as I can but be warned, it is a heavy sheet. A lighter but less detailed mobile friendly version can be found here. Backend-Lite. This automatically updates from the main sheet so should stay up to date.

This isn't intended to replace L100 but to supplement it, as this one does not show Gauntlet Pairs or Cadet information nor does it have the option to select your own crew and compare. But hopefully you can get some use out of it. Enjoy!

NoNameNamer

This is, in my opinion, the single best resource out there. It's on my bookmarks bar because I use it all the time and I'm sorry for not thanking you enough for doing this amazing work. Thank you!

Captain Idol

NoNameNamer wrote: »

This is, in my opinion, the single best resource out there. It's on my bookmarks bar because I use it all the time and I'm sorry for not thanking you enough for doing this amazing work. Thank you!

Your cheque is in the mail.

[CFOH] Khaaaaaaannnnnn!!!!

I use this sheet constantly (and in conjunction with your Datacore Analysis Sheet), thanks for all the hard work!

Captain Idol

Just gone through and checked a ton of stats. Over 200 innaccuracies have now been fixed.

Captain Idol

Good morning. At some point today I'll be doing a complete overhaul so some of the data will be funky whilst I change up the sheet to work a bit more efficiently (all tested on another sheet so hopefully should be one big Copy+Paste). This will effect The Big Book and DahjBot on Discord. Will edit this post when it's all done.

Edit: All done

Prime Lorca

Are the bonuses that you use displayed somewhere? Since WRG is rolling out these wonderful collections lately, it would be nice to check and see if/when your marvelous piece of spreadsheet wizardry reflects the new bonuses.

Thank you again for this great resource!

Captain Idol

Updated with Gauntlet Pairings similar to the L100 sheet for easy breakdowns in each category.

Captain Idol

I have also updated the Traits section to now and be ordered by Voyage Score.

Captain Idol

Updated for the new collection and stats boosts!

Edit: Also tweaked the Traits screen to sort by Base Pair Ranks instead of voyage power, helps to find the best crew for that trait event.

Captain Idol

All changes to traits and collection accounted for.

~peregrine~

*deleted*

Captain Idol

Updated to include Hidden traits. Also reworked the event score backend and collections to be more autonomous meaning less work for me yay!

[CFOH] Khaaaaaaannnnnn!!!!

Something is wrong with Little Boy Blue Wesley - looks like the sheet thinks one of his stats is CMD? Thanks for all your work on this!

Captain Idol

[CFOH] Khaaaaaaannnnnn!!!! wrote: »

Something is wrong with Little Boy Blue Wesley - looks like the sheet thinks one of his stats is CMD? Thanks for all your work on this!

I'm dumb, this is fixed now thanks!

Captain Idol

Updated with Tribble Info, Dahj should also have updated with all this too.

Captain Idol

Updated with Resourceful and a placeholder for whatever Primal's name will be

Captain Idol

Much requested new feature added, highlighting two skillers in the voy pairs!

[CFOH] Khaaaaaaannnnnn!!!!

Just wanted to pop in and say thanks for maintaining this tool, I use this a lot - I appreciate the work put in.

~peregrine~

The Traits column (V) on the first page of this sheet looks to be very useful for the upcoming fleet boss battles, in terms of searching for which cards cover the most traits with minimal overlap.

@Captain Idol , would it be possible to add a column to the left of that one which would display the total number of traits each card has?

Captain Idol

~peregrine~ wrote: »

The Traits column (V) on the first page of this sheet looks to be very useful for the upcoming fleet boss battles, in terms of searching for which cards cover the most traits with minimal overlap.

@Captain Idol , would it be possible to add a column to the left of that one which would display the total number of traits each card has?

That is actually possible, and probably useful. I'll look into it.

guest_1624969369756672

This is, in my opinion, the single best resource out there. It's on my bookmarks bar because I use it all the time and I'm sorry for not thanking you enough for doing this amazing work.