SWGoH calculator spreadsheet

KaZyKa · February 25, 2016 9:57AM

I 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

eBitzu · February 25, 2016 10:26AM

KaZyKa wrote: »

I 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

KaZyKa · February 25, 2016 11:02AM

eBitzu wrote: »

KaZyKa wrote: »

I 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 :-)

Drayden · February 25, 2016 2:41PM

Hello EA?!? Could you employ this guy? And give us an option to export our toons into this spreadsheet, maybe?

THANK YOU

KaZyKa · February 25, 2016 3:02PM

Drayden wrote: »

Hello 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

Speaker4thedead · February 26, 2016 4:17AM

is there anyway to show max power for each character at each star level?

jeffoule · February 26, 2016 7:20PM

Speaker4thedead wrote: »

is there anyway to show max power for each character at each star level?

here

https://swgohdb.com/stats

EwokJedi1 · February 26, 2016 8:49PM

Cool

UNivek · February 26, 2016 9:04PM

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

KaZyKa · February 26, 2016 9:23PM

UNivek wrote: »

Nice 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

UNivek · February 26, 2016 10:00PM

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

KaZyKa · February 26, 2016 10:18PM

Cool

UNivek wrote: »

I 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

UNivek · February 26, 2016 11:05PM

Okay, all merged into a single sheet now! (the link that KaZyKa originally posted) Changes are fluid, comments are welcome as usual.

KaZyKa · February 27, 2016 12:11PM

cool

Trevor · February 29, 2016 3:08PM

Acording 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

KaZyKa · February 29, 2016 9:28PM

Trevor wrote: »

Acording 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

SpaceBallone · May 13, 2017 8:38PM

So 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

New player? Check out the new player index

SWGoH calculator spreadsheet

Replies

Howdy, Stranger!

Quick Links