Play Now Login Create Account
illyriad
  New Posts New Posts RSS Feed - Sindicate v. Assorted Elgea based Alliances
  FAQ FAQ  Forum Search   Register Register  Login Login

Sindicate v. Assorted Elgea based Alliances

 Post Reply Post Reply Page  <1 45678 13>
Author
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 01 Jan 2018 at 07:19
Day 25. Here are updated stats, with VALOR having surrendered and exited the conflict.

Current Stats

Grand Alliance
  Land Mem Towns Pop Atk Build Diplo Def
Aesir 6,303 75 613 10,776,639 69,316,067 4,741,729 2,170,991 14,248,379
Unbow 6,531 56 492 8,393,163 23,524,298 1,083,716 840,635 13,621,656
EE 5,318 60 467 8,163,171 47,720,716 4,484,388 2,151,750 13,629,541
mCrow 5,025 63 464 7,278,571 65,498,052 3,074,330 1,469,528 6,525,642
Storm 3,248 30 282 5,136,801 35,994,028 2,859,000 1,908,063 11,144,278
Hell 2,167 28 197 3,131,193 11,975,919 1,855,067 181,308 2,167,181
HoMa 1,053 5 96 1,520,303 2,184,596 39,976 5,164 91,076
eCrow 904 10 81 1,581,722 39,723,815 3,092,171 329,566 9,913,798
TEA 660 8 52 678,440 917,109 37,979 18,251 934
Bane 734 13 94 1,600,799 3,908,156 488,318 30,698 600,089
TROUT 443 9 54 731,261 1,538,630 267,302 4,915 313,380
SV 22 3 7 8,110 14,556,103 2,850,052 228,821 44,218
WOT 2 1 2 2,316 25,419,879 2,773,639 852,608 6,264,454
32,410 361 2,901 49,002,489 342,277,368 27,647,667 10,192,298 78,564,626

SINdicate
  Land Mem Towns Pop Atk Build Diplo Def
LOKI 3,553 42 327 4,642,352 24,012,032 1,979,719 1,959,219 6,867,756
SIN 2,836 22 177 2,682,443 58,806,893 2,747,465 2,102,661 41,925,992
TA2IN 1,832 13 106 1,313,358 8,465,541 503,957 896,920 8,414,783
300 1,149 7 63 889,595 6,975,855 183,080 167,369 4,750,975
9,370 84 673 9,527,748 98,260,321 5,414,221 5,126,169 61,959,506

Numeric Delta

Grand Alliance
  Land Mem Towns Pop Atk Build Diplo Def
Aesir -493 -4 -36 -954,314 1,828,479 81,959 264,400 1,872,698
Unbow -393 0 -10 -301,766 450,739 82,773 17,145 202,294
EE 525 1 32 601,432 722,016 116,675 38,415 124,844
mCrow 183 3 27 450,382 901,018 78,809 82,028 87,178
Storm -143 -3 -9 -162,540 339,235 28,227 96,808 37,536
Hell 67 -1 4 53,036 468,785 36,270 28,785 29,640
HoMa -468 -2 -28 -538,141 980,041 14,416 250 71,416
eCrow -303 -3 -25 -302,798 47,169 2,590 170 11,263
TEA 43 1 6 44,263 152,424 9,830 460 201
Bane -12 -1 -2 -16,537 30,343 7,456 0 3,140
TROUT 0 0 0 2,636 16,112 2,082 0 0
SV -4 0 -3 -12,874 79 446 0 2,149
WOT 0 0 0 0 0 0 0 0
-998 -9 -44 -1,137,221 5,936,440 461,533 528,461 2,442,359

SINdicate
  Land Mem Towns Pop Atk Build Diplo Def
LOKI 241 -6 -22 -135,255 1,563,272 95,047 122,065 366,295
SIN 100 -2 -11 -12,878 873,240 42,910 57,422 863,113
TA2IN -170 -3 -19 -154,442 2,517,965 32,872 32,458 1,641,728
300 14 0 4 -24,638 846,671 17,608 46,810 173,529
185 -11 -48 -327,213 5,801,148 188,437 258,755 3,044,665

Percentage Delta

Grand Alliance
  Land Mem Towns Pop Atk Build Diplo Def
Aesir -7% -5% -6% -8% 3% 2% 14% 15%
Unbow -6% 0% -2% -3% 2% 8% 2% 2%
EE 11% 2% 7% 8% 2% 3% 2% 1%
mCrow 4% 5% 6% 7% 1% 3% 6% 1%
Storm -4% -9% -3% -3% 1% 1% 5% 0%
Hell 3% -3% 2% 2% 4% 2% 19% 1%
HoMa -31% -29% -23% -26% 81% 56% 5% 363%
eCrow -25% -23% -24% -16% 0% 0% 0% 0%
TEA 7% 14% 13% 7% 20% 35% 3% 27%
Bane -2% -7% -2% -1% 1% 2% 0% 1%
TROUT 0% 0% 0% 0% 1% 1% 0% 0%
SV -15% 0% -30% -61% 0% 0% 0% 5%
WOT 0% 0% 0% 0% 0% 0% 0% 0%
-3% -8% -4% -3% 2% 1% 5% 3%

SINdicate
  Land Mem Towns Pop Atk Build Diplo Def
LOKI 7% -13% -6% -3% 7% 5% 7% 6%
SIN 4% -8% -6% 0% 2% 2% 3% 2%
TA2IN -8% -19% -15% -11% 42% 7% 4% 24%
300 1% 0% 7% -3% 14% 11% 39% 4%
2% -12% -7% -3% 6% 4% 5% 5%
Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 01 Jan 2018 at 07:27
Day 25 Correction - fixing a spreadsheet error in the Numeric Delta stats. Please ignore my previous post.

Current Stats

Grand Alliance
 LandMemTownsPopAtkBuildDiploDef
Aesir6,3037561310,776,63969,316,0674,741,7292,170,99114,248,379
Unbow6,531564928,393,16323,524,2981,083,716840,63513,621,656
EE5,318604678,163,17147,720,7164,484,3882,151,75013,629,541
mCrow5,025634647,278,57165,498,0523,074,3301,469,5286,525,642
Storm3,248302825,136,80135,994,0282,859,0001,908,06311,144,278
Hell2,167281973,131,19311,975,9191,855,067181,3082,167,181
HoMa1,0535961,520,3032,184,59639,9765,16491,076
eCrow90410811,581,72239,723,8153,092,171329,5669,913,798
TEA660852678,440917,10937,97918,251934
Bane73413941,600,7993,908,156488,31830,698600,089
TROUT443954731,2611,538,630267,3024,915313,380
SV22378,11014,556,1032,850,052228,82144,218
WOT2122,31625,419,8792,773,639852,6086,264,454
32,4103612,90149,002,489342,277,36827,647,66710,192,29878,564,626

SINdicate
 LandMemTownsPopAtkBuildDiploDef
LOKI3,553423274,642,35224,012,0321,979,7191,959,2196,867,756
SIN2,836221772,682,44358,806,8932,747,4652,102,66141,925,992
TA2IN1,832131061,313,3588,465,541503,957896,9208,414,783
3001,149763889,5956,975,855183,080167,3694,750,975
9,370846739,527,74898,260,3215,414,2215,126,16961,959,506

Numeric Delta

Grand Alliance
  Land Mem Towns Pop Atk Build Diplo Def
Aesir -493 -4 -36 -954,314 1,828,479 81,959 264,400 1,872,698
Unbow -393 0 -10 -301,766 450,739 82,773 17,145 202,294
EE 525 1 32 601,432 722,016 116,675 38,415 124,844
mCrow 183 3 27 450,382 901,018 78,809 82,028 87,178
Storm -143 -3 -9 -162,540 339,235 28,227 96,808 37,536
Hell 67 -1 4 53,036 468,785 36,270 28,785 29,640
HoMa -468 -2 -28 -538,141 980,041 14,416 250 71,416
eCrow -303 -3 -25 -302,798 47,169 2,590 170 11,263
TEA 43 1 6 44,263 152,424 9,830 460 201
Bane -12 -1 -2 -16,537 30,343 7,456 0 3,140
TROUT 0 0 0 2,636 16,112 2,082 0 0
SV -4 0 -3 -12,874 79 446 0 2,149
WOT 0 0 0 0 0 0 0 0
-1,149 -31 -111 -1,372,973 5,277,411 190,260 507,116 2,434,835

SINdicate
 LandMemTownsPopAtkBuildDiploDef
LOKI241-6-22-135,2551,563,27295,047122,065366,295
SIN100-2-11-12,878873,24042,91057,422863,113
TA2IN-170-3-19-154,4422,517,96532,87232,4581,641,728
3001404-24,638846,67117,60846,810173,529
185-11-48-327,2135,801,148188,437258,7553,044,665

Percentage Delta

Grand Alliance
 LandMemTownsPopAtkBuildDiploDef
Aesir-7%-5%-6%-8%3%2%14%15%
Unbow-6%0%-2%-3%2%8%2%2%
EE11%2%7%8%2%3%2%1%
mCrow4%5%6%7%1%3%6%1%
Storm-4%-9%-3%-3%1%1%5%0%
Hell3%-3%2%2%4%2%19%1%
HoMa-31%-29%-23%-26%81%56%5%363%
eCrow-25%-23%-24%-16%0%0%0%0%
TEA7%14%13%7%20%35%3%27%
Bane-2%-7%-2%-1%1%2%0%1%
TROUT0%0%0%0%1%1%0%0%
SV-15%0%-30%-61%0%0%0%5%
WOT0%0%0%0%0%0%0%0%
-3%-8%-4%-3%2%1%5%3%

SINdicate
 LandMemTownsPopAtkBuildDiploDef
LOKI7%-13%-6%-3%7%5%7%6%
SIN4%-8%-6%0%2%2%3%2%
TA2IN-8%-19%-15%-11%42%7%4%24%
3001%0%7%-3%14%11%39%4%
2%-12%-7%-3%6%4%5%5%
Back to Top
Neytiri View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 25 Nov 2010
Location: California
Status: Offline
Points: 122
Post Options Post Options   Thanks (0) Thanks(0)   Quote Neytiri Quote  Post ReplyReply Direct Link To This Post Posted: 01 Jan 2018 at 16:09
I don't know of a better way.  I just thought I would weigh in with something productive.  I applaud your efforts to somehow score the conflict, actually.  I like it better than the traditional way of comparing cities lost.

How are you getting the charts you're posting here?
Is there a way to dump them into a spreadsheet?


"It is well that their bodies know the heat and the cold; it will make them strong warriors and mothers." - Absaroke elder (from Edward S. Curtis's book 'The North American Indian')
Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 01 Jan 2018 at 19:24
Originally posted by Neytiri Neytiri wrote:

How are you getting the charts you're posting here?
Is there a way to dump them into a spreadsheet?

Steps to recreating these stats:
1. Go to the Alliance Leaderboard page and copy all stats related to a given alliance.
2. Go to a pre-defined spreadsheet and paste that data.
3. Repeat this for all alliances on each side.
4. Build formulas in the spreadsheet to sum stats for each side.
6. Using the initial data as the baseline, create an identical section in your spreadsheet for current stats.
7. Build formulas to calculate the numeric and percentage deltas between current and baseline.

Ah heck, I'll just move my process from Excel to a Google Sheet. Here's a link to it:


Oooo...maybe I'll just post the link to this sheet instead of pasting and reformatting it here! Noice.
Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (1) Thanks(1)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 02 Jan 2018 at 21:35
Day 27. I've added SAINT as a newcomer to the Grand Alliance after BayNight's successful siege on 300's Ten Kulch. If anyone knows of additional participants in the war, please let me know.

Also, I'm getting 500 Internal Server Error messages when I try to post updated stats on the forums. It appears to be related to the size of the tables. That said, I'm going to just paste the link to the Google Sheet here for the time being, and going forward I will archive the previous "current stats" on a separate tab to allow for a view of historic data for those that enjoy it. Also, if you like the data in spreadsheet form, hit that "Thanks" link above or drop me a line in game so I know to keep doing it. :)

Here's the link...


If anyone knows the workaround that will allow for pasting large tables from Google Sheets into this buggy forum, lemme know! :)


Edited by Mafro - 02 Jan 2018 at 21:39
Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 04 Jan 2018 at 02:37
Day 28.

It is notable that 300 has four fewer cities than last update - a decrease of 6.5% of their cities in roughly 24 hours. Presumably at least some of those are in exodus. I've seen sieges by BayNights and Hucbold in GC, and multiple Legendary Battles reported outside 300's cities. Insights welcome!

TEA also lost a member and six cities, an 8.8% decrease in their towns.

I've also noticed that WoT has been inactive for weeks, and SV for days. If they disband, I will obviously remove them from the stats.

Lots happening!

Back to Top
Jadefae View Drop Down
Greenhorn
Greenhorn
Avatar

Joined: 09 Jan 2015
Location: United States
Status: Offline
Points: 45
Post Options Post Options   Thanks (0) Thanks(0)   Quote Jadefae Quote  Post ReplyReply Direct Link To This Post Posted: 04 Jan 2018 at 20:14
WoT joined unbow
Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 05 Jan 2018 at 07:36
Back to Top
digiosox View Drop Down
New Poster
New Poster


Joined: 24 Dec 2017
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote digiosox Quote  Post ReplyReply Direct Link To This Post Posted: 06 Jan 2018 at 05:43
I was thinking about the stats.

Population, Build, Diplo, magic, tech, quest, and trade is irrelevant so maybe get rid of them so the report seems less confusing.

percentage delta isn't much help when the starting numbers are so different.

Attack and Defense numbers are correlated as they are fighting each other (assuming the participants are not engaged in anything big with a third party).

For final stats:
Maybe look at the ratio of attack growth to defense growth between the opposing sides.
Change in number of players and cities to both sides. (the true indicator)

Back to Top
Mafro View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 01 Apr 2012
Status: Offline
Points: 172
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mafro Quote  Post ReplyReply Direct Link To This Post Posted: 06 Jan 2018 at 06:54
Back to Top
 Post Reply Post Reply Page  <1 45678 13>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.10
Copyright ©2001-2017 Web Wiz Ltd.