Super Team Builder Redux

Share strategies, experience and tips & tricks.
User avatar
aks47u
"Flawless" Mastery Member
Posts: 292
Joined: Thu Oct 20, 2016 7:17 am

Re: Super Team Builder Redux

Postby aks47u » Tue Aug 01, 2017 9:44 am

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

Re: Super Team Builder Redux

Postby Azbandar » Tue Aug 01, 2017 1:02 pm

Molly wrote: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.
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

Molly
"Good" Mastery Member
Posts: 63
Joined: Wed Jan 18, 2017 7:41 pm

Re: Super Team Builder Redux

Postby Molly » Wed Aug 02, 2017 6:45 pm

Oh, thanks!

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

Re: Super Team Builder Redux

Postby Azbandar » Sat Aug 05, 2017 4:41 am

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
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

Tim1981
Posts: 17
Joined: Fri Apr 15, 2016 2:02 pm

Re: Super Team Builder Redux

Postby Tim1981 » Wed Aug 09, 2017 12:25 am

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!

User avatar
Shiroe
"Legendary" Mastery Member
Posts: 2630
Joined: Sun Aug 23, 2015 11:05 am
Location: the Netherlands
Contact:

Re: Super Team Builder Redux

Postby Shiroe » Wed Aug 09, 2017 1:27 am

Tim1981 wrote: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.
as of 2016-09-11: Player level: 44, City: Eolythes, Blueprints: 517, Mastered: 419, Crafted: 78.61K
(except for tier 1 and some tier 2 artifacts mostly running my shop/gearing self sufficient)

Tim1981
Posts: 17
Joined: Fri Apr 15, 2016 2:02 pm

Re: Super Team Builder Redux

Postby Tim1981 » Wed Aug 09, 2017 1:56 am

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

Re: Super Team Builder Redux

Postby Azbandar » Wed Aug 09, 2017 2:48 am

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.
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

Tim1981
Posts: 17
Joined: Fri Apr 15, 2016 2:02 pm

Re: Super Team Builder Redux

Postby Tim1981 » Wed Aug 09, 2017 4:13 am

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

User avatar
Shiroe
"Legendary" Mastery Member
Posts: 2630
Joined: Sun Aug 23, 2015 11:05 am
Location: the Netherlands
Contact:

Re: Super Team Builder Redux

Postby Shiroe » Wed Aug 09, 2017 6:43 am

Azbandar wrote: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
as of 2016-09-11: Player level: 44, City: Eolythes, Blueprints: 517, Mastered: 419, Crafted: 78.61K
(except for tier 1 and some tier 2 artifacts mostly running my shop/gearing self sufficient)


Return to “Strategy & Guides”



Who is online

Users browsing this forum: No registered users and 3 guests

©2015 Cloudcade, Inc. All Rights Reserved.