Shop Heroes Spreadsheet
Tell me if you like it or not
https://docs.google.com/spreadsheets/d/1Wa6wlT9ycfa5twpsc7Igf22-CtGHM8y6LAPTUZn9G9I/edit#gid=1330526577
Trade Wars is coming to Shop Heroes! Want a quick primer on how it works? Yue will walk you through all the ways to earn Domination Points that help your City in the Trade Wars event. Shop Heroes is a cross-platform multiplayer fantasy shop simulation and city building game. Manage your dream shop, hire skilled workers, craft hundreds of epic items and enlist powerful heroes to engage in quests and raids, collaborate with your friends to enhance your city and much more.
Replies
- 286 postsMemberI created this spreadsheet to be like a calculator.
Tell me if you like it or not
https://docs.google.com/spreadsheets/d/1Wa6wlT9ycfa5twpsc7Igf22-CtGHM8y6LAPTUZn9G9I/edit#gid=1330526577
I'm not even mad. that's impressiveFollow on twitter, Subscribe to my channel , 10$ free giveaway here - 6 postsMemberI created this spreadsheet to be like a calculator.
Tell me if you like it or not
https://docs.google.com/spreadsheets/d/1Wa6wlT9ycfa5twpsc7Igf22-CtGHM8y6LAPTUZn9G9I/edit#gid=1330526577
I'm not even mad. that's impressive
Thanks! Tell me if you would like me to change something or add! If you spot any errors tell me so I can fix it :-) - 66 postsMemberHello EA?!? Could you employ this guy? And give us an option to export our toons into this spreadsheet, maybe?
THANK YOU - 6 postsMemberHello EA?!? Could you employ this guy? And give us an option to export our toons into this spreadsheet, maybe?
THANK YOU
I have talked to im-not-really-a-jedi about an API of a sort, because I wanted to create an app. He said they're not planning any sort of API - 444 postsMemberis there anyway to show max power for each character at each star level?
- 35 postsMemberis there anyway to show max power for each character at each star level?
here
https://swgohdb.com/stats - 131 postsMember0
- 70 postsMemberFebruary 26, 2016 9:04PMedited February 2016Nice KaZyKa, I have a spreadsheet as well but the focus was more on computing potential team speed, power, etc. Based on statistics published from http://www.swgohcantina.com/character-max-stats/
Here is my spreadsheet.
https://docs.google.com/spreadsheets/d/18AnWWKcVQSV0T0RRU4w43t24WybZE4vfzuY2pvhWtCA/edit?usp=sharing
There are hidden formula on Team Calculation tab that look up the character names entered to the Stats tab and bring back statistics. The sample tab shows a few example teams I looked up. You can also have it look at what top 5 teams of various statistics (such as power/speed) may look like.My Youtube Channel Droids with Jawa Engineer and HK Omega Lead IG88 DOT Omega Lead Droids with mod - 6 postsMemberNice KaZyKa, I have a spreadsheet as well but the focus was more on computing potential team speed, power, etc. Based on statistics published from http://www.swgohcantina.com/character-max-stats/
Here is my spreadsheet. Perhaps you can merge them together? : )
https://onedrive.live.com/redir?page=view&resid=FB00DF6D17DADBB7!116&authkey=!AIjjEzfuwNiO-5Y
There are hidden formula on Team Calculation tab that look up the character names entered to the Stats tab and bring back statistics. The sample tab shows a few example teams I looked up. You can also have it look at what top 5 teams of various statistics (such as power/speed) may look like.
I can give you permission to edit this on google so only you and I can edit the spreadsheet. It is easier if there are two people doing this than one. PM me your google mail if you wish to. Otherwise I will try to see how to slowly do it - 70 postsMemberI translated the spreadsheet to google sheet now.
Link: https://docs.google.com/spreadsheets/d/18AnWWKcVQSV0T0RRU4w43t24WybZE4vfzuY2pvhWtCA/edit?usp=sharing
We can see if people prefer two different sheet or a single.My Youtube Channel Droids with Jawa Engineer and HK Omega Lead IG88 DOT Omega Lead Droids with mod - 6 postsMemberCoolI translated the spreadsheet to google sheet now.
Link: https://docs.google.com/spreadsheets/d/18AnWWKcVQSV0T0RRU4w43t24WybZE4vfzuY2pvhWtCA/edit?usp=sharing
We can see if people prefer two different sheet or a single.
Cool - 70 postsMemberOkay, all merged into a single sheet now! (the link that KaZyKa originally posted) Changes are fluid, comments are welcome as usual.My Youtube Channel Droids with Jawa Engineer and HK Omega Lead IG88 DOT Omega Lead Droids with mod
- 6 postsMemberFebruary 27, 2016 12:11PMedited February 20160
- 102 postsMemberAcording to this my characters i should consider in building team is
1. Rey
2. Ima Gun Di
3. Gs
4. Yoda
5. Savage Opress
6. Nightsister Initiate
7. Kylo Ren
8. Hoth Rebel Scout
9. Tusken Raider
10. Darth Vader
11. First Order Tie Pilot
12. Teebo
13. Qui Gon Jinn
14. Aayla Secura
15. Luminara Unduli
Doesnt counted a lot this so on first view
1. QGJ(lead)
2. Rey
3. Gs
4. Yoda
5. Ima Gun Di
Would be worth analysing - 6 postsMemberAcording to this my characters i should consider in building team is
1. Rey
2. Ima Gun Di
3. Gs
4. Yoda
5. Savage Opress
6. Nightsister Initiate
7. Kylo Ren
8. Hoth Rebel Scout
9. Tusken Raider
10. Darth Vader
11. First Order Tie Pilot
12. Teebo
13. Qui Gon Jinn
14. Aayla Secura
15. Luminara Unduli
Doesnt counted a lot this so on first view
1. QGJ(lead)
2. Rey
3. Gs
4. Yoda
5. Ima Gun Di
Would be worth analysing
Glad you could use this - 8 postsMemberSo I have looked over the list you have (or at least the list visible) and I do not see it being very complete. Many new characters have been added and some changes have been made. I have been working on a list very similar to this of which I will share with you once I get my calculations nailed down. However I do have a question for you, 'How is the POWER determined for each character or did I look over it in your messages?' I do know that the team power is a combination of all characters in the team and it would seem the power levels are flawed ever so slightly but are a ok guide. Also I have the created formulas for the base stats and there prospective increases via star levels for ALL the Characters. and have a work in progress for the gear increases
We are preparing to move all Fandom and Gamepedia logins to a unified login system. If you have an account on Fandom with the same username as on Gamepedia, we have a very simple set of instructions to resolve the conflicting username. Further work will be done to resolve other username conflicts later.
This a small guide on how to operate Shop Heroes Central. A item directory with various sorting and filtering options.
Getting Started[editedit source]
In the top left there are the options to filter items, to sort the item list and a search bar. The search bar can be used to both search for item names and item's skill names.
Click 1 for filtering items and 2 for sorting the list of items.
Filtering Items[editedit source]
Clicking the filter button brings up the filter popup.
Item Level:
Slide the left slider to filter the minimum item level that shows up.
Slide the right slider to filter the maximum item level that shows up.
Item Class:
Worst of All in Fort LauderdaleFort Lauderdale has a limited selection of places to stay. There are two great county parks within easy driving distance of town, but they're constantly filled ahead of time.We chose this RV park because it's somewhat near the ocean and near our friend's place. Paradise island rv resort florida. You feel as though you are either in France or Montreal Canada.Nice place that filled our needs for being in the Miami, Fort Lauderdale area.
Here you can select which class of items show up(sword, boots, herbs). You can click a single item class or multiples.
Chests and Packages:
Here you can filter the various chest items and package items. The first option is the filter for the base item lines. You can click a single chest or package or multiples.
Precrafts:
Here you can select Items that need a certain quality of precraft to be filtered out. If you don't want items that need a flawless precraft for example, then you can unselect it here.
If you want to filter by mastery skill you can use the search bar.
Sorting Items[editedit source]
Clicking the sort button brings up the sorting popup.
You can sort the item list by:
Item level,
Base gold value,
Base item power,
Base item exp,
Craft time that can be set up to display base on your own worker skills.
How much base gold per crafting second(based on your worker skills),
How much base exp per crafting second(based on your worker skills),
How much exp you get per base gold value.
Crafting skills[editedit source]
Click the 'Time' at the top of the list allows you to enter in your own workers' skills so that the list can be sorted by the various crafting time settings. The last number is for your workers' mastery.
Clicking on a item will take you to that item's page, giving you details on how to obtain it and what precrafts it can be used for, along with it's gold value for the different stages of quality and surcharge/mastered/impatient, It also displays the chances for getting levels of quality based on your worker's mastery.
Example:
