Super Team Builder!

Share strategies, experience and tips & tricks.
User avatar
akerson
"Flawless" Mastery Member
Posts: 366
Joined: Tue May 03, 2016 11:41 am
Contact:

Super Team Builder!

Postby akerson » Thu Aug 25, 2016 3:09 pm

I was going to write up something, but I'm not good at plugging my creations, so I got a sponsor (who may or may not be abqu...)

So without further adieu!

Image

Have you ever been sitting at your computer, staring at a spreadsheet, and said, "Dang, there's gotta be a better way to build teams!" Have you ever said, "I would love some help making teams, but that Abqu guy is just not my cuppa tea"? Maybe you've tried to make a team composition, and it was just too darn hard! Well, stop cleaning those glass panels with your tongue, because we've got just the thing for you!

Hi! Abqu here, with another awesome thing made by Akerson [source #1].

Image

Introducing Akerson's Equipment Manager!

It solves all these problems and more! Experts [2] have tested this spreadsheet, and it's had life changing results! The patented [3] technology behind this tool is simple, and easy to use! All you have to do is download the spreadsheet, and BAM! your life is changed forever.

https://www.dropbox.com/s/pfvv2fmfznjakgv/Equip_Manager.xlsx?dl=0 (for the cool excel users)
https://www.dropbox.com/s/ynn7r713fg9zmgl/Equip_Manager.ods?dl=0 (for the dirty OpenOffice users)
(no link for google doc users, since this spreadsheet is TOO MUCH FOR GOOGLE TO HANDLE!!! thats how cool it is)

But Abqu? This can't be real, can it? This deal is too good to be true!

Image

If you act now, Akerson will throw in a tutorial video, FOR FREE!

https://www.youtube.com/watch?v=z6j9b7XcnQg

You need to hurry because this offer can't last long due to demand. The next 10 callers will receive a special Skunk Spray Jellybean package! Call now!

Here's how you order:

Image

Sources:
1: It's all Akerson's work, give him all the credit. He just asked me to write the foreward to the thing.
2: Richard is an expert, Abqu is not
3: not patented
Last edited by akerson on Thu Aug 25, 2016 3:23 pm, edited 2 times in total.

User avatar
akerson
"Flawless" Mastery Member
Posts: 366
Joined: Tue May 03, 2016 11:41 am
Contact:

Re: Super Team Builder!

Postby akerson » Thu Aug 25, 2016 3:11 pm

Changelog:

v0.15
* Fix: Music items will now properly be highlighted
* Fix: All 10%/15% values will now come up accurately instead of 1%/1.5%
* Fix: Added commander, and calculation for commander, to the team skills attributes

v0.14
* Fix: Added missing item wisdom ocarina (thanks schumi!)
* Fix: Changed the lookup from item list from direct reference to indexes, so adding new items doesn't mess up things. This should mean no more "this item is in the list but X hero can't equip it!" issues (also thanks schumi for bringing the original problem up!)

v0.13
* Fix: Added missing items Valkyrie's Grip and Loki's Mask (thanks Zman!!)
* Made all items checked by default, instead of the blueprints I own

v0.12
* Fix: Team 3 slots incorrectly using Team 4 slot data (fancy that??)

v0.11
* Fix: Minh Acc1 incorrect item types
* Fix: Team 4 slots incorrectly using Team 3 slot data

v0.1 BETA:
RELEASED!
Last edited by akerson on Sun Aug 28, 2016 7:49 am, edited 8 times in total.

User avatar
Abqu
"Epic" Mastery Member
Posts: 937
Joined: Thu Jan 14, 2016 6:39 pm

Re: Super Team Builder!

Postby Abqu » Thu Aug 25, 2016 3:17 pm

This is gonna save so much time, I hope the community loves it as much as I already do.

User avatar
Richard
Community Moderator
Posts: 1499
Joined: Thu Jun 25, 2015 10:29 pm
Location: New York, NY
Contact:

Re: Super Team Builder!

Postby Richard » Thu Aug 25, 2016 4:36 pm

Awesome as always Akerson!

Adding this to the Community Resources list as well.
Kong: TheCongressman | Reddit: Zesty_Hamburger | In-Game: Richard#73188 | Shop Heroes Discord Server | Shop Heroes Data Spreadsheet

User avatar
akerson
"Flawless" Mastery Member
Posts: 366
Joined: Tue May 03, 2016 11:41 am
Contact:

Re: Super Team Builder!

Postby akerson » Thu Aug 25, 2016 6:17 pm

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!NOTICE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Copy+paste will move your data validation with you, which is literally the opposite of what you want. AKA copy/paste will BREAK YOUR SHEET. Instead, use copy-paste VALUES (it's in the special paste box). I'm not sure how to fix this right now to prevent that from happening, so for now just don't do it B)

snewt
Posts: 14
Joined: Fri May 13, 2016 10:12 pm

Re: Super Team Builder!

Postby snewt » Thu Aug 25, 2016 8:27 pm

A+

Akaistos
Posts: 11
Joined: Fri Jul 01, 2016 8:17 am

Re: Super Team Builder!

Postby Akaistos » Thu Aug 25, 2016 9:24 pm

This is actually crisp.
Like. Awesome.
Totally what I needed. Thanks a lot, Abqu*!



Akerson <3

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

Re: Super Team Builder!

Postby Shiroe » Fri Aug 26, 2016 3:37 am

Thanks for the links.
On the fusion cauldron calculator google spreadsheet it silently refuses to let me download as open document format (excel does work), so direct download links are very handy for me. :)
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)

User avatar
akerson
"Flawless" Mastery Member
Posts: 366
Joined: Tue May 03, 2016 11:41 am
Contact:

Re: Super Team Builder!

Postby akerson » Fri Aug 26, 2016 3:52 am

Shiroe wrote:Thanks for the links.
On the fusion cauldron calculator google spreadsheet it silently refuses to let me download as open document format (excel does work), so direct download links are very handy for me. :)


I needed to do two for this one because #1 it takes about an hour for my computer to convert from xls to ods which sucks for any OO users, but #2 for whatever reason, certain conditional formatting gets blown out when converting so half the sheet functions don't work if you try and convert. So I'm just gonna keep two going at the same time :D

If you want a .ods of fusion cauldron let me know, I can definitely upload :D

Yohek
Posts: 47
Joined: Fri Mar 18, 2016 6:37 am

Re: Super Team Builder!

Postby Yohek » Sat Aug 27, 2016 4:10 pm

Thanks for the work on this. It's really awesome.

I dowloaded it and find out some mistakes (in the .ods one at least) that were easy to fix :
Lancaster is not listed as Brother-in-arms II
Gauvin is listed as Brother-in-arms II instead of I
Speed Runner II is missing (replace by a Speed Runner III at 0.25 -> just removed one I)

It saved me considerable time and effort, so really : Thank you !


Return to “Strategy & Guides”



Who is online

Users browsing this forum: Google [Bot] and 3 guests

©2015 Cloudcade, Inc. All Rights Reserved.