Super Team Builder Redux

[Azbandar]

I think I see what you're seeing now. I hadn't realized it was doing that, exactly. Give me a bit to work on some formula stuff to see if I can clean it up fully and I will take it from there.

I'm adding in a simple fusion calculator to the next version too btw. It's ready, but I was doing some power formula testing (which I still need help from some higher CJ cities to perfect!) before I did a full release again.

[Azbandar]

New version uploaded with a couple new features.

• Fusion Calculator Added
• Mastery Calculator Added
• Several bug fixes
  
  • Display bug for leader skills calculating as if whole party had same skills as leader
  • In items tab, "no" was not working as intended, initial tests were not showing this, but it was found & fixed
  • Hero dropdown list stopped at Odette, not Theor (or bottom hero) as intended

[BigNasty]

New version uploaded with a couple new features.

• Fusion Calculator Added
• Mastery Calculator Added
• Several bug fixes
  
  • Display bug for leader skills calculating as if whole party had same skills as leader
  • In items tab, "no" was not working as intended, initial tests were not showing this, but it was found & fixed
  • Hero dropdown list stopped at Odette, not Theor (or bottom hero) as intended

Think this got broken. https://imgur.com/a/f0lf7

Not that items on D/E are missing several like Revivie, Healer, Speed Runner, etc and some items not counting for energetic on 0.
Also, as a general comment, importing from one spreadsheet to another is more cumbersome than previous version as you can't copy/paste values into a single sheet as you could in previous, since you moved item and item quality to separate pages.

[Azbandar]

To meet the desires of the many, cumbersome copying is how it must be. If I'd stop screwing up the formula copying, you may not actually notice as much!

I have a fixed version uploaded.

[aks47u]

Also, as a general comment, importing from one spreadsheet to another is more cumbersome than previous version as you can't copy/paste values into a single sheet as you could in previous, since you moved item and item quality to separate pages.

Once this new version is debugged there should hopefully only be updates with game updates so moving to a new sheet won't be needed that often. Unless Az keeps adding more features, but again, moving sheets shouldn't be too often once those too are debugged.

[Azbandar]

I'm trying to only add new features with game updates. I had planned on having the Fusion Calculator and Mastery in the newest release of the remake, but I was getting to many asks for the the update to hold out. Thankfully, haha, I screwed up enough to still get them in to the current version.

I will eventually add in some Mythical+ options, though I'm not sure how I will do that for the Fusion Calculator, that may be stuck on the basics for a while.

[Azbandar]

New version out. Still trying to get it easier for you all the copy the power calculator (Info tab) over, no luck.

However, here's what did change:

• Fixed an error in the power formula causing buildings to always count as buffed. Resulting change may cause unbuffed power to not be accurate, please reach out to me if you can help me test it.
• Rewrote the entire dropdown menu options for gear, resulted in the elimination of the "Lists" tab.
• Fixed the resulting highlight issue caused by the removal of the "Lists" tab (rewrote entire "Highlights" tab).
• Added highlights to heroes based on innate skills, only works once in the team, sorry, no go the other way.
• Sheet is more responsive with certain areas, less with others, working on the culprit.

[Arty]

I will eventually add in some Mythical+ options, though I'm not sure how I will do that for the Fusion Calculator, that may be stuck on the basics for a while.

The calculations for enchanting are paractically the same as for regular fusion, it's just new parameters for the new qualities (so far I know them only up to Myth+3). I have already added it to my own calculator (which was also just based on Abqu's old calculator). Here's a version on google, feel free to use whatever you like from it. (You might have to be careful at a few places, because my number representations of the qualities start with 1, not with 0 like yours.)

Aside from the added enchanting it also fixes two small issues from Abqu's old calculator (which are also still present in yours):

• NQL calculation was wrong in some (realistically less relevant) cases involving level 1 items, because the NQL calculation table didn't distinguish between "there is no item of that quality" and "there is a level 1 item of that quality". For example when fusing a flawless level 1 item with a good level 2+ item, the old calculator produced the wrong numbers.
• There was also the ugly old "hack" of artificially modifying result percentages (so that no two numbers are equal, allowing them to rank properly), which would occasionally shift a number across some rounding barrier, resulting in a slight discrepancy with the numbers shown ingame.

Merry Christmas,
Arty

Edit: Finally managed to make a Myth+3. Fusion paramters for Myth+4 confirmed. (They were as expected.)

[Mitrax]

Well done Arty. Using your sheet is really nice!

Is there a way to "equip" heroes and build teams later? All Team Builder are not flexible in this way. If you want to change teams, you always have to put the name in another team and edit equipment. In case of death (not 100% revive team) the new team could have not enough Support or heal for example.
To change that way of equip and teambuilding is a lot of work. But I think it would be worth or?

Regards
Mitrax

[Azbandar]

Is there a way to "equip" heroes and build teams later? All Team Builder are not flexible in this way. If you want to change teams, you always have to put the name in another team and edit equipment. In case of death (not 100% revive team) the new team could have not enough Support or heal for example.
To change that way of equip and teambuilding is a lot of work. But I think it would be worth or?

Regards
Mitrax

With the last formula grinding I did, you can actually copy and paste, I believe. That should allow for relatively easy hero swapping.

I have not looked at Arty's modified code, so it's not into the fusion calculator yet, and I do have one small bug fix that I have done, but was waiting to see if there was something new coming out before I released the fix. It only stops highlights for working on Cone-of-Cold, so it's not like it breaks anything.