Here is a public copy of the ETR GvG spreadsheet I created for Scarlet (retired Nov 15th as R1). Using this spreadsheet we were about to standardize our defence teams as well as easily streamline our attacks and let people casually FFA without needing 30 people in VC at the same time.
The spreadsheet features:
- Current top meta defense team recommendations
- Comprehensive list of counters to each defence with video examples included
- Audit tab for keeping track of member investments
- Attack units tab to keep track of how many hits each player used and what units they have left
- Attack Log tab for tracking all hits overall since the in game tracker sucks
The spreadsheet itself contains multiplier lookup functions so all you need to do is update the names of your members in the Audit and Attack Units tab, then enter in hits in the Attack Log tab. Also make sure to update the Audit and Units tabs with new meta units that come out and grab unit pics from Prydwen or your preferred ETR fan site.
Feel free to make a copy for your own guild’s usage or use it as reference to build your own. While Scarlet ended up getting lazy and not really using the spreadsheet the last few GvGs leading up to our retirement, hopefully it will prove to be useful for those who still want to tryhard in GvG and push rankings.
Good luck and have fun!
Scarlet Etheria Restart GvG (Public)
Originally posted on Discord.
