All-In-One Spreadsheet

This all-in-one player stat spreadsheet aims to help theorycrafters create and/or verify new builds for their Fox without needing the actual in-game resources, items, and other unlockables
 link to Google Spreadsheet: TDS Stat Sheet
 Make sure to click > File > Make a copy
 by: Oble#3809
== Acknowledgements & Changelogs ==
This spreadsheet wouldn't have been possible without:
*@Zaderton; Costume Tracker - Tailed Demon Slayer (link)
*@Natelicious; Monster Cards - Library (link)
*@Spark; for explaining to me how the relic, Exotic Emerald, works and for their Cemetery-efficacy calculations
*@Ellezard and @antbeforesunsetsalt1; for clarifying some formulas regarding Critical Damage
*@Bert; for verifying the level 100 equipment stats
*@Rosumad; for reporting a decimal error in the Monster Deck (skill) crit%
*@Extraversion; for suggesting adding a version tracker, for pointing out some oversights
August 24, 2022
*HP Rec (base, %, total) should now be accurate:
**added missing initial 100%
**fixed costume stat allocation (totals unchanged)
*Relics tab:
**fixed weapon grade-based conditionals
*Costumes:
**added the Good Start S set and recent summer SSS sets
June 20, 2022
*TOTALS tab:
**Increased max level
**Fixed arithmetic of build comparisons
**Changed Displayed Crit% remarks to reflect added crit%
**Fixed damage increase comparison when adding extra stats in the Additional Stats table
*Monster Card Deck tab:
**Fixed total attack for Loadout 8 (thanks, Extraversion)
*Masteries tab:
**Fixed names of masteries (thanks, Extraversion)
*Relics tab:
**adjusted relic dependent on SS fairies to also work when equipped with SSS fairies (in-game description did not change but works for SSS fairies no problem)
*(NEW!) Titles tab:
**added new tab for new Titles feature
*Summary tab:
**re-made formulas, please help me double check my calculations if possible. At least confirm if the same inputs you have in your old sheet is reflected on the new version (on any tab)
*THINGS TO VERIFY:
**if new calculations give the same numbers as your old copy
**if titles that mention "installed" mean equipped or must be active weapon
**have yet to verify what the current in-game displayed stats is composed of. Currently, Displayed Stats in TOTALS tab does not reflect in-game stats thanks to the new Titles effects, but also because Titles are not properly reflected in-game.
May 27, 2022
*Fixed counting of monster card region bonus since it was also counting non-leader effects
*added version trackers within the spreadsheet
*added mushroom bonus disclaimer
**damage calculations involving Mushroom Forest bonus may appear lower than actual in-game performance due to its mechanics. Compared to the spreadsheet, its bonus is not linear and its effects are more pronounced in higher stages/pushing. This was the reason why Mushroom Forest bonus was not originally added to the spreadsheet.
May 12, 2022
*Added Mushroom Forest monster card region deck bonus to all loadouts
**Using ~1.05x (20/19) and ~1.09x (12/11) for 2/4 and 4/4 damage bonus respectively
May 11, 2022
*fixed decimal point for Monster Deck (skill) crit%
== Features ==
VIP bonus tracker
*Most VIP perks are separated into their own columns by category, listed per incremental bonuses (as compared to total bonuses as shown in-game)
Costumes tracker (c/o Zaderton)
*Check-list style tracker
*Added a section for summation of stats obtained from each costume piece, excludes skill effect bonuses
Relics tracker
*Check-list style tracker
*Based only on max leveled relics
*Auto-computes bonuses received from each relic
Masteries tracker
*Designed to look similar to in-game Mastery section
*Has convenient quick navigation hyperlink cells (upper left) to help you move between Mastery trees (Talent, Skill, Battle, Assist)
Titles tracker
*Check-list style tracker
Equipment tracker
*Inventory tracker for each unique equipment piece
**allows inputting Ability of Transcendence rolls
**automatically includes Blacksmith of Transcendence bonuses when applicable
*Has 6 loadouts with damage output numbers to easily compare each loadout
**automatically includes applicable equipment grade (e.g. B, A, S, SS, SSS) bonuses depending on the listed equipment in each loadout
** Energy Orb configurations independent from other tabs. Does not affect final build. Refer to Overall Fox stat calculator section below for Energy Orbs affecting main loadouts.
**each loadout can be compared to the other based on a combined number factoring in Base Attack, Attack%, Skill Damage, (Skill) Crit%, (Skill) Crit Damage, and Boss Damage Up
Monster Card Deck builder/tracker (built from Natelicious' Monster Card Library)
*Card library tracker
*Has 8 loadouts, also with damage output numbers for easy loadout comparison
**still only compares using Base Attack, Attack%, Skill Damage, (Skill) Crit%, (Skill) Crit Damage, and Boss Damage Up
**Cooldown Reduction and Attack Speed are not factored in but are displayed for loadout clarity
**leader effects are properly taken into consideration
Overall Fox stat calculator
*Contains fields for VIP level, Training levels, Weapon Proficiencies, Clover bonuses, active Energy Orbs, equipped fairy grades, and a Glacio checkbox
*Has an additional input table in case you would like to add more stats affecting all loadouts in the spreadsheet. Useful for factoring in extra stats temporarily
*Based on the equipped loadouts, the final damage output is displayed as well as stats that should mimic the in-game stats panel
*Contains another 3 input tables if you wish to compare which added stat(s) will give you a better damage change
Independent stat comparison tab
*If you don't have time to input your complete build into all of the aforementioned tabs in the spreadsheet, you can simply use this last tab to place and compare stats directly
*Has a Base Attack and Attack% calculator to help you input the proper stats
*Contains 5 loadouts by default, which can be easily increased by copying one column onto a new one
*Also has options for Energy Orbs
== How to use? ==
*Every cell that needs an input value (number, percent, ticking a checkbox, etc.) is colored ORANGE. Simply fill in these cells
*If you have placed an invalid input or configuration, cell(s) will turn into a vibrant RED to show that some error or confusion may occur. Stats will still be calculated, but results might confuse you regarding which inputs were considered. Please attend to your inputs promptly to avoid any confusion.
*Some cells will change color when placing an input just to signify the default value has changed. These come in BLUE or VIOLET colors.
*Damage output numbers showing changes to show a stronger or weaker increase will be using a soft GREEN or RED color to help you determine better loadouts quicker.
== Disclaimer, Errors, Bug Reporting ==
*This spreadsheet is accurate in obtaining the very same stats you will see in-game
**These include Total Attack, Total Def, Crit%, Cooldown Reduction, Attack Speed, Total HP, Skill Damage, Crit Damage, and Move Speed
**HP Recovery is the only inconsistent stat. Even within the game, obtaining the HP Recovery Energy Orb does not change the HP Recovery value in the in-game stats page. Regardless, defensive stats (e.g. HP, HP Recovery, and Def) mean very little in TDS and are often overlooked anyways.
*However, my method of displaying damage output has not yet been verified to properly calculate these values across all 18 possible loadouts that use the above verifiable stats, excluding the 5 loadouts in the independent stats-only comparison tab.
**Skill Crit%, Skill Crit Damage, Weapon-specific bonuses, and Boss (and normal monster) Damage Up are all not shown in the in-game stats panel and my calculations for them may, but are very unlikely, to be incorrect
**What is more likely to be incorrect is how I calculated these stats across the 18 different loadouts. You may verify my formulas in a hidden tab called "Summary" where most of the final calculations are done. To help guide you in how I compute the damage output numbers I display for each loadout, I use the following formulas:
 Total Attack = Base Attack * (1 + Attack%)
 Skill Damage Output (SDO) = Total Attack * (1 + Skill Damage) * (1 + Boss Damage %Up) * (averaged Mushroom Forest bonus)
 Skill Crit Damage Output (SCDO) = SDO * (Crit Damage + Skill Crit Damage)
 Total Crit% = Crit% + Skill Crit%; max 100%
 Average Skill Damage Output (ASDO) = [SCDO * Total Crit%] + [SDO * (1 - Total Crit%)]
 (unverified; representation) Actual Damage Output = ASDO * (Base Skill% + %perLevel * skillLevel)
**ASDO is useful because this number is used as the basis of damage for all skills and attacks. The only missing component is (Base Skill% + %perLevel * skillLevel) which differs across all skills of all weapons. Using ASDO works as a common point for comparison, independent of skill strength and weapon class, as shown above
*This spreadsheet will likely not feature skills and their runes so just be mindful of runes like -30% Skill Damage that can affect your damage output. You can factor this using the Additional Stats table in the TOTALS tab.
*If there are any discrepancies in my calculations or, say, some cells are referencing incorrect cells, kindly approach me on Discord. Feel free to ping me on the TDS Server or send me a DM. No need to send friend requests.
 Discord handle: Oble#3809