Popular Post hidude45454 Posted August 2, 2021 Popular Post Share Posted August 2, 2021 Releasing this so that ppl can shut up and stop arguing about who tiers in what and which alliances count for what and is an alliance a part of a coalition or not 🙃 Lemme give a quick rundown of how to work with this before I post a link: Step 1: Make a copy. Feel free to make another or copy-paste values whenever the sheet is updated. Tab 1: Lists all active (logged on in past 30 days, includes VM) nations sorted by score. I update this manually cuz I'm lazy lol Tab 2: Lists all alliances in the top 100. Ordering of the list is also manually updated. I have a manual preset of affiliation rn that you can go off of. There's a dropdown menu for what coalition each alliance is affiliated with that you can change (colored yellow): Tab 3: Lists all coalitions with their aggregated sums. Should be straightforward enough to sort this list. Every tier is colored according to which has the most and least members tiered in that range. Tab 4: You can aggregate coalitions together here in order to simulate tiering in a global war. Enter "A" or "B" in the yellow cells. Here's a garbage random example: Tab 5: Same thing as tab 3 but with everyone C1-10 removed. Tab 6: Same thing as tab 4 but with everyone C1-10 removed. Tab 7: City-by-city comparison of all alliances. Tab 8: City-by-city comparison of all coalitions. There's a pretty graph at the bottom where you can compare two. Just enter which ones in the yellow boxes and you get something like this: And finally, here's the link: https://docs.google.com/spreadsheets/d/1Tl9pXdAnD11o-2rLHfThK6wcoTsvF5wmM2xWHzpRnNc/ Please let me know if you are experiencing any technical difficulties or if you would like to see features added! 6 1 15 Quote Link to comment Share on other sites More sharing options...
Velyni Vas Posted August 2, 2021 Share Posted August 2, 2021 Thank you for this! Quote  Link to comment Share on other sites More sharing options...
Indger Posted August 2, 2021 Share Posted August 2, 2021 Nice. Ty Quote Link to comment Share on other sites More sharing options...
JadenStar10 Posted August 2, 2021 Share Posted August 2, 2021 This is awesome, thanks! Quote Coal Duke (Imperator Emeritus) of The Coal Mines Diety Emeritus of The Immortals, Patres Conscripti (President Emeritus) of the Independent Republic of Orange Nations, Lieutenant Emeritus of Black Skies, Imperator Emeritus of the Valyrian Freehold, Imperator Emeritus of the Divine Phoenix, Prefect Emeritus of Carthago, Regent Emeritus of the New Polar Order  Link to comment Share on other sites More sharing options...
Kevanovia Posted August 2, 2021 Share Posted August 2, 2021 (edited) Orbis doesn’t deserve you, but it does need you @hidude45454 Edited August 2, 2021 by Kevanovia Quote Link to comment Share on other sites More sharing options...
Gudea Posted August 3, 2021 Share Posted August 3, 2021 😎 This is too cool for words. 😎 Quote Link to comment Share on other sites More sharing options...
hidude45454 Posted August 5, 2021 Author Share Posted August 5, 2021 On 8/2/2021 at 7:34 AM, Kevanovia said: Orbis doesn’t deserve you, but it does need you @hidude45454 I don't need Orbis but I totally deserve this suffering :^) Added a tab 8: just shows you which alliances are being counted within each sphere. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.