Super Team Builder Redux

[aks47u]

Due to the prohibition of editing cells, you can not change the formatting. Even the width of the columns. This is somewhat inconvenient.

You can unprotect the tabs from the menu, and this will let you edit stuff. Careful with the formulas.

[Azbandar]

Due to the prohibition of editing cells, you can not change the formatting. Even the width of the columns. This is somewhat inconvenient.

I know aks answered already, but I only have it soft locked so people unfamiliar with the program can't undo something they don't mean to.

There is no password on the lock, just go to the Review tab in the top ribbon and click unprotect.

[Molly]

Oh, thanks!

[Azbandar]

New version posted!

Changelog for August 5, 2017:

• Added in the ability to equip an item without owning the BP by putting "no" into the Have column on the Items tab (result is "Zero Skill")
• Further optomized some formulas
• Added Sports & Vacation Packs
• Added skills to Summer Sports Pack
• Added a check for hero level vs skill acquire level
• Added Resilient into solo skill options

[Tim1981]

Az, hi again!
I'm adding some calculations in your STB (e.g. average quest loot value (using TH price), value per hour, etc.) and faced one strange thing:

Quest time calculation (that shows above each team on 'Main')is correct, but when i add 3 Inn boosts, calculations differs from what I see ingame.
For example, Tainted Grove (cleared) quest time with 25% SpeedRunner is 1d 5h 09min. When I boost Inn 3 times, it must be 1749min*0,5*0,5*0,5 = 218min. But in fact, game shows that final time is around 258 min (4h 18 min).
Maybe my calculation is wrong, and Inn boost is not 0,5*0,5*0,5?
Thanks in advance!

[Shiroe]

Az, hi again!
I'm adding some calculations in your STB (e.g. average quest loot value (using TH price), value per hour, etc.) and faced one strange thing:

Quest time calculation (that shows above each team on 'Main')is correct, but when i add 3 Inn boosts, calculations differs from what I see ingame.
For example, Tainted Grove (cleared) quest time with 25% SpeedRunner is 1d 5h 09min. When I boost Inn 3 times, it must be 1749min*0,5*0,5*0,5 = 218min. But in fact, game shows that final time is around 258 min (4h 18 min).
Maybe my calculation is wrong, and Inn boost is not 0,5*0,5*0,5?
Thanks in advance!

Inn boosting has a lower cap of 15% as far as I know. Using *0.15 instead of *0.5*0.5*0.5 (0.125), I get 262.35 minutes for your numbers.

[Tim1981]

Inn boosting has a lower cap of 15% as far as I know

That's exactly my numbers! Thanks a lot, didn't know about any cap!

[Azbandar]

Like Shiroe was saying, there's a strange cap, that makes almost no sense on the final outcome. It varies from the 15% slightly and seems to alter as it sees fit. That's the main reason I didn't add something like that in. I had thought about it, but the math never works out.

Just like the team power calculator is not 100% accurate, but at least I could fake a number and get it close for all the testing I did.

[Tim1981]

At 'Hero Power' tab you're adding building CJ upgrade level twice, firstly in H column, and again in U and W columns.
When I remove multiplier from H column, U and W calculation becomes correct

[Shiroe]

Like Shiroe was saying, there's a strange cap, that makes almost no sense on the final outcome. It varies from the 15% slightly and seems to alter as it sees fit. That's the main reason I didn't add something like that in. I had thought about it, but the math never works out.

Just like the team power calculator is not 100% accurate, but at least I could fake a number and get it close for all the testing I did.

Through some google digging, it seems the 15% lower cap was added early 2016, probably around the time inn boosts were switched from flat time reduction to percentage time reduction. (some people were boosting some of their quests down to zero seconds/insta-finish and I guess CC added the lower cap to make extra sure nobody can find a use case for doing something like 20 boosts...)

viewtopic.php?f=4&t=7980
viewtopic.php?f=4&t=5990
viewtopic.php?f=10&t=5921&start=20#p21210
https://www.facebook.com/shopheroes/pos ... 8738909314