Thread: Sanahtlig's Kamihime Project Toolbox

When you hear the word 'Calculator' you expect to enter numbers here and there, then result showed up according to formula. but I don't know where to input things in your toolbox and it's a view-only document. 'not user-friendly' isn't the word, it's more like 'not intuitive' because I'm not a user yet and still figuring out anything. being the only helpful math guy in the community sure is tough, you have to deal with people like me who won't go deeper into rabbit hole in those math. If only you could CSS the heck out of those formula it would be perfect.

I'll try pouring some ideas on the layouts,

For the gacha calculator, it would be something like: "Enter the amount of jewel/Nutaku gold/$", "select the rate-up type", "amount of SSR(KH,kamiless wep,eido) you have", "amount of SR you have", "amount of R KH you have",etc

Then the result cell would be: "Chances of getting SSR(KH,Kamiless wep,eido)", "chances of getting SSR dupes", "chances of getting new SSR","chances of getting featured SSR",etc.

For the damage calculator, it would be something like: "Enter the KH atk", "select debuff", "select enemy buff", "select negative status effect on KH", "select enemy status Stun/Normal/Raging", "select enemy element", "select KH element", "select active eidolon", "select friend eidolon", etc

Then the result cell would be: "Damage dealt in normal/raging/stun state", "Burst damage dealt in normal/raging/stun state", "chances to miss", "chances of double attack", "chances of triple attack", etc.

My advice is, make it so even an idiot could understand or not disheartened by a wall of numbers (I'm like that). And lastly, thank you for being "that math guy" everybody can rely on.

Thanks for the input. The document is read-only so people can always access and preview the latest version, but can't change the version everyone sees. Download the sheet to edit. Fields for user input are highlighted in grey throughout the Toolbox.

I've input reasonable defaults throughout the spreadsheet so users don't have to fill in every field one-by-one. They can change one or two fields and simply observe the effect. I think that's less tedious than demanding a series of inputs, though it requires a basic understanding of the layout and workflow.

The Toolbox is implemented in Google Sheets, and that's unlikely to change, so I have to work within the limits of a typical spreadsheet. It'll never be a program with pop-ups and customized input/output displays, as that's beyond the scope of the project. If someone else wanted to take on that sort of programming project, I'd be willing to work with them, but I sort of doubt that will happen.

In response to user feedback, I made a new landing page for my Toolbox that serves as a Table of Contents and user orientation. This should make it easier to jump in and start using the tools. The hyperlinks should also make navigation quicker and allow me to fit more sheets into the same space without scrolling.

The question, "When is a Gatcha eidolon better than an MLB event SSR as primary eidolon?" has come up several times lately, so I added an Eidolon Comparison tool to the Constitutive Effects Damage Calculator to answer it. The answer for Fafnir is: a slight damage increase at LB1 (~2%), and a significant increase at LB2 (~4.5%), both at the cost of some lost HP. At LB0, the loss of stats makes the Fafnir-type eidolons undesirable as primary eidolons.

I also upgraded the Weapon Comparison tool with the option to factor in the weapons' Burst modifiers (when equipped as a primary weapon).

I identified a minor error in the way I was factoring in off-element kamihime into the damage calculation, underestimating their damage contribution (underestimating total team damage by about 5%). This bug only affects comparisons between teams with different numbers of off-element kamihime (e.g., a Fire group with Light Sol vs. a full Fire group). I fixed it for the main Constant Effects Calculator (Comparisons of different team configurations), but implementing this fix throughout all of the damage calculators is going to be time-consuming.

Until I get around to propagating the fix, don't use the damage calculator to compare teams with differing numbers of matching-element kamihime. The results of such comparisons won't be valid, except for the one calculator I fixed.

New tool: An Encyclopedia of kamihime (incl. skill effects), SSR weapons, and SSR eidolons organized by event. This tool was compiled by Slashley of Harem-Battle from info on the JP wiki and revised by me. This is a one-stop reference that English users should find extremely helpful. Note that this was compiled by Slashley using machine translation and therefore may not be 100% accurate. There's far too much info for me to verify in its entirety, so please point out any potential errors and I'll investigate.

New tool: Overdrive simulator. Use this tool to predict and counter enemy overdrives with skills that affect the overdrive meter and defensive buffs. The tool simulates the enemy's overdrive usage, allowing users to deploy countermeasures and observe how these affect overdrive usage over the course of the battle.