Super Team Builder Redux

Share strategies, experience and tips & tricks.
Azbandar
"Great" Mastery Member
Posts: 181
Joined: Sun May 29, 2016 10:39 am
Location: Canada
Contact:

Re: Super Team Builder Redux

Postby Azbandar » Sun Dec 03, 2017 2:37 pm

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.
Mayor of Eolythes, overseer of many spreadsheets & maker of many things...MANY things.

Shop Heroes Spreadsheet | Super Team Builder Redux
Shop Heroes Spreadsheet design by Richard | Super Team Builder original design by Akerson

Azbandar
"Great" Mastery Member
Posts: 181
Joined: Sun May 29, 2016 10:39 am
Location: Canada
Contact:

Re: Super Team Builder Redux

Postby Azbandar » Sun Dec 03, 2017 5:52 pm

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
Mayor of Eolythes, overseer of many spreadsheets & maker of many things...MANY things.

Shop Heroes Spreadsheet | Super Team Builder Redux
Shop Heroes Spreadsheet design by Richard | Super Team Builder original design by Akerson

BigNasty
"Good" Mastery Member
Posts: 76
Joined: Sat Jun 25, 2016 4:17 pm

Re: Super Team Builder Redux

Postby BigNasty » Sun Dec 03, 2017 6:47 pm

Azbandar wrote: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
"Great" Mastery Member
Posts: 181
Joined: Sun May 29, 2016 10:39 am
Location: Canada
Contact:

Re: Super Team Builder Redux

Postby Azbandar » Mon Dec 04, 2017 1:57 am

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.
Mayor of Eolythes, overseer of many spreadsheets & maker of many things...MANY things.

Shop Heroes Spreadsheet | Super Team Builder Redux
Shop Heroes Spreadsheet design by Richard | Super Team Builder original design by Akerson

User avatar
aks47u
"Flawless" Mastery Member
Posts: 292
Joined: Thu Oct 20, 2016 7:17 am

Re: Super Team Builder Redux

Postby aks47u » Mon Dec 04, 2017 6:25 am

BigNasty wrote: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
"Great" Mastery Member
Posts: 181
Joined: Sun May 29, 2016 10:39 am
Location: Canada
Contact:

Re: Super Team Builder Redux

Postby Azbandar » Mon Dec 04, 2017 3:05 pm

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.
Mayor of Eolythes, overseer of many spreadsheets & maker of many things...MANY things.

Shop Heroes Spreadsheet | Super Team Builder Redux
Shop Heroes Spreadsheet design by Richard | Super Team Builder original design by Akerson

Azbandar
"Great" Mastery Member
Posts: 181
Joined: Sun May 29, 2016 10:39 am
Location: Canada
Contact:

Re: Super Team Builder Redux

Postby Azbandar » Sun Dec 24, 2017 11:34 am

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.
Mayor of Eolythes, overseer of many spreadsheets & maker of many things...MANY things.

Shop Heroes Spreadsheet | Super Team Builder Redux
Shop Heroes Spreadsheet design by Richard | Super Team Builder original design by Akerson

Arty
"Good" Mastery Member
Posts: 75
Joined: Sat May 06, 2017 4:57 am

Re: Super Team Builder Redux

Postby Arty » Mon Dec 25, 2017 4:11 am

Azbandar wrote: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.)


Return to “Strategy & Guides”



Who is online

Users browsing this forum: No registered users and 3 guests

©2015 Cloudcade, Inc. All Rights Reserved.