Hi! So you want to "Moneyball" Territory Battles, eh? For all my fellow number nerds, I have created a spreadsheet to calculate your guild's Potential Stars Earned!My guild has 74M GP and we just earned 28 stars. But we most likely should be earning 33 stars.Here is the Google Sheet:https://docs.google.com/spreadsheets/d/1YLGTBV_Jz0yMNJHa6a-KKVf2aobJ2RqDeD6JRStaw04/edit?usp=sharingI highly highly suggest that you first go to the tab "INSTRUCTIONS". It's a bit complex, but once you are familiar with the setup, things should go smoothly. I tried to simplify it as much as possible.Note: best viewed on an actual computer rather than a mobile device.Disclaimer:The TP range that I've calculated are simply based on numbers. It DOES NOT account for your actual roster, which characters get used in Platoons, which characters are "forced" into certain zones for Required Combat Missions, etc.Have fun with the numbers! Please let me know if you have any questions or suggestions! I'm just doing my part to help out the SWGOH community.Plus a quick shoutout to all of the SWGOH Devs! We know you're working hard, so thank you for your dedication! Cheers!

Sorry created by you thought I read pyrefly somewhere but I see you as creator in instructions.

Column A needs to be widened before instructions can be read.

Instructions seem to work better opening with browser rather than drive, but overall presentation is not as nice.

Thanks, crzydroid!I just widened it. I didn't think about people viewing it on a mobile device.

@Caz Thanks for the call-out! Glad the info was of help to someone.

TB - How to Calculate Your Guild's Potential Stars Earned

paulghar
8 years ago
Sorry created by you thought I read pyrefly somewhere but I see you as creator in instructions.
crzydroid
Retired Hero
8 years ago
Column A needs to be widened before instructions can be read.
crzydroid
Retired Hero
8 years ago
Instructions seem to work better opening with browser rather than drive, but overall presentation is not as nice.
Cruzerweight
8 years ago
Thanks, crzydroid!
I just widened it. I didn't think about people viewing it on a mobile device.
PyrrhusRex
8 years ago
@Caz Thanks for the call-out! Glad the info was of help to someone.
paulghar
8 years ago
Hi Caz, Thanks for the doc it looks great. Im good with spreadsheets and a fella number nerd but not real familiar with making the google doc something I can edit with my guilds data. Any help would be great im logged in and can ask for edit request but don't want to mess up someone elses guild data.

Assuming you meant to share that beauty spreadsheet pyrfly built it is really appreciated.
abc2020610813
8 years ago
Dude. Respect. This is a heck of an effort, even for a labor of love - which it obviously is. I don't geek on game numbers like I used to (though it certainly passes my personal quick-sniff test), but the thought and hard work put into it is obvious.

Bravo, and thank you for sharing it.
Cruzerweight
8 years ago
"Pyrefly;c-1260550" wrote:
@Caz Thanks for the call-out! Glad the info was of help to someone.

Np! Thank you for gathering the base info. Saved me a lot of manual time! =)
Cruzerweight
8 years ago
"Jimmy_Key;c-1260551" wrote:
Hi Caz, Thanks for the doc it looks great. Im good with spreadsheets and a fella number nerd but not real familiar with making the google doc something I can edit with my guilds data. Any help would be great im logged in and can ask for edit request but don't want to mess up someone elses guild data.

Assuming you meant to share that beauty spreadsheet pyrfly built it is really appreciated.

Hi Jimmy, are you able to create a duplicate of the spreadsheet so that you can modify your own? If you're logged into Google, open up the link, go to File > Make a copy... > and it should let you save it into your own Google Drive so that you can make edits. Let me know if that works.

If it does, you can PM me and I can help walk you through plugging in your guild's personal data.
paulghar
8 years ago
Hey Caz, that worked I got it now. Your instructions are great I should be good if I get into trouble Ill drop you a PM, thank you for sharing this and the work it is amazing. The guild I am in happens to have almost exact stats as yours so its easy to look up. I just copy pasted the data and it says we should likely get 32 stars from 28 we estimated only 31 from our by the eye so this really helps.

Thanks again form me and Max Rebo Fan Club