Shop Heroes Skillz Maximizing Spreadsheet V3

Discuss anything related to Shop Heroes gameplay.
Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Shop Heroes Skillz Maximizing Spreadsheet V3

Postby Pantless » Wed Sep 07, 2016 5:25 pm

THIS IS THE MOST RECENT VERSION --- USE THIS LINK! Version 3 release!! 3/21/2017!

Make a copy - read instructions

https://docs.google.com/spreadsheets/d/1K6ZGzj4RjC30kFfbYIXXGtFwhUWVvjFgAVCL8rHXkGo/edit?usp=sharing

Updated to include have flat % increase from premium decorations

Thanks,
Pantless
Last edited by Pantless on Tue Mar 21, 2017 3:32 pm, edited 4 times in total.
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

internetz
"Great" Mastery Member
Posts: 165
Joined: Mon May 16, 2016 1:22 pm

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby internetz » Wed Sep 07, 2016 6:18 pm

would you like me to integrate a lookup table into this?
it would automatically look up the crafting info from richard's sheet for the items you entered into the side column, no more copy/pasting needed.

edit: try this, just has some basic queries.
https://docs.google.com/spreadsheets/d/ ... =811500224
Last edited by internetz on Wed Sep 07, 2016 8:09 pm, edited 1 time in total.

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Wed Sep 07, 2016 6:25 pm

could you make it a drop down lookup? that would be amazing
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Wed Sep 07, 2016 6:26 pm

i was thinking of ways to make it auto maximize to either mastery or table max skill... but the formulas are too hard in google docs vs excel
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

internetz
"Great" Mastery Member
Posts: 165
Joined: Mon May 16, 2016 1:22 pm

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby internetz » Wed Sep 07, 2016 8:27 pm

if you've got your excel formulas already done i can usually modify them to make them work in google sheets.

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Thu Sep 08, 2016 3:15 pm

i havent made it that far to automate maximization. I would think that you would want 2 modes - max mastery or min craft time.

Also, if we parsed the unlock 5 steps and set a flag for 25% time redox - i think that could auto populate as well.
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Sun Oct 16, 2016 11:22 am

bump!

So - i have a new version of this i will upload soon.
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Wed Oct 19, 2016 7:49 pm

I CALL UPON THE POWER OF THE INTERNETZ!!!!!


hey - i need some help with some major changes i have made --can you give me some assistance on the spreadsheet?
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.

cc_Tadaaah
"Legendary" Mastery Member
Posts: 2243
Joined: Fri Aug 14, 2015 11:01 am

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby cc_Tadaaah » Thu Oct 20, 2016 2:00 pm

Image

Pantless
"Good" Mastery Member
Posts: 89
Joined: Fri Apr 29, 2016 6:42 pm
Location: Ohio
Contact:

Re: Shop Heroes Skillz Maximizing Spreadsheet

Postby Pantless » Thu Oct 20, 2016 4:19 pm

Version 3 is coming out later tonight
Author of the award winning Skillz Spreadsheet!
http://forum.shopheroes.com/viewtopic.php?f=4&t=7374

-when in doubt, assume I am not wearing pants.


Return to “General Discussion”



Who is online

Users browsing this forum: Bing [Bot], Poison Lotus and 2 guests

©2015 Cloudcade, Inc. All Rights Reserved.