Play Now Login Create Account
illyriad
  New Posts New Posts RSS Feed - Spreadsheet comparing the 2 sides of the war
  FAQ FAQ  Forum Search   Register Register  Login Login

Spreadsheet comparing the 2 sides of the war

 Post Reply Post Reply Page  123>
Author
Sir A View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 26 Sep 2012
Status: Offline
Points: 121
Post Options Post Options   Thanks (0) Thanks(0)   Quote Sir A Quote  Post ReplyReply Direct Link To This Post Topic: Spreadsheet comparing the 2 sides of the war
    Posted: 13 Jan 2014 at 08:22
A while back someone made a topic about where the most powerful players are...now I present to you a comparison of the sov/troop production of all the alliances on both sides of the war.  The spreadsheet compares both sides statistics on each individual alliance involved and on both sides as a whole.  These stats won't necessarily tell which alliances are the best at war but it will give some kind of idea as to where each alliance stands in terms of troop production...which will give a kind of idea as to how fast an alliance can make troops assuming the alliances use most of their sov for troop production bonuses and are constantly producing troops.  It also compares some other things that you can check out.  Let me know if I made any mistakes or missed anything.  Everything is color coded and there should be no bias.  Just numbers.

Back to Top
Rill View Drop Down
Postmaster General
Postmaster General
Avatar
Player Council - Geographer

Joined: 17 Jun 2011
Location: California
Status: Offline
Points: 6903
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rill Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 08:36
/me goes out to claim more sov

I'm guessing that the spreadsheet assumes everything is troop sov?  Alliances that support large cities with lots of food sov might end up looking more powerful than they actually are.

I can only speak for my armies, and they can't fight their way out of a paper bag.  That is, if they could find the bag to begin with.
Back to Top
Halcyon View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 17 Aug 2012
Location: Israel
Status: Offline
Points: 360
Post Options Post Options   Thanks (0) Thanks(0)   Quote Halcyon Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 08:47
Need reinforcments Rill?
Back to Top
Rill View Drop Down
Postmaster General
Postmaster General
Avatar
Player Council - Geographer

Joined: 17 Jun 2011
Location: California
Status: Offline
Points: 6903
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rill Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 08:54
I don't know, everyone just tells me where to go and what to do.
Back to Top
Yhina View Drop Down
Greenhorn
Greenhorn
Avatar

Joined: 04 May 2012
Status: Offline
Points: 61
Post Options Post Options   Thanks (0) Thanks(0)   Quote Yhina Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 09:32
besides what Rill point out on whether those sov lands are used for troops or just for food ( higher level sov lands are more likely to be food bonuses, while low ones 1-2, most likely for troop bonuses) , you are considering just sov I for each sov land?

Ex. you average sov lands per town.. and if you get, lets say 10, you say average bonus 50%? Which would be true only IF all sov lands were level 1...

Considering the linear cost for sov II from sov I ( and becoming exponential after that point), it would be safer to assume that most of those sov lands are level II than I.

And probably reducing a few sov lands, on the averaged land per town result, to reflect food sov, could lead to more "accurate" average results.
Back to Top
Brandmeister View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 12 Oct 2012
Location: Laoshin
Status: Offline
Points: 2396
Post Options Post Options   Thanks (0) Thanks(0)   Quote Brandmeister Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 12:32
While this is a nice effort to be scientific, I think the assumption that "most sov is used for troops" pretty much breaks the entire premise. Some alliances have many big cities with 8x Farmstead V (or Fishery V). Other alliances have mostly 8x Military III around their cities. Comparing those two configurations is apples to oranges. Even more so if the Farmstead V counts as 5 points (when it should be 0), but the Military III counts as 3 points.

A better methodology would be to eliminate all squares with Sov IV and V, assuming they are Farmsteads or Fisheries. Also eliminate all sovereignty claims over 20 for a city. I suspect this is spreadsheet just takes the alliance stat page Lands Claimed stat. Many people have pointed out that Consone spent a lot of time talking about the math. The numbers don't mean much unless you filter out all the noise, and that is certainly no small task.

Edited by Brandmeister - 13 Jan 2014 at 12:32
Back to Top
Elmindra View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 10 Sep 2012
Status: Offline
Points: 464
Post Options Post Options   Thanks (0) Thanks(0)   Quote Elmindra Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 14:12
If you have 8x Farmsteads V then you are not a military town period.  A military town has 18-20 sovs level 2-3 all devoted to troop production.  
Back to Top
Brandmeister View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 12 Oct 2012
Location: Laoshin
Status: Offline
Points: 2396
Post Options Post Options   Thanks (0) Thanks(0)   Quote Brandmeister Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 14:38
I agree that it really isn't a military town. However, large cities can support larger numbers of troops (to a point), so population can't be dismissed entirely.

As I said in other posts that tried to compare numbers: while it is difficult to do a quick comparison of stats, you can identify military players and alliances simply by looking at a few cities.
Back to Top
JimJams View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 20 Sep 2011
Location: Italy
Status: Offline
Points: 496
Post Options Post Options   Thanks (0) Thanks(0)   Quote JimJams Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 16:58
While all the notes other made on the previous posts are valid, still those numbers are interesting reading.
Back to Top
geofrey View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 31 May 2011
Status: Offline
Points: 1013
Post Options Post Options   Thanks (0) Thanks(0)   Quote geofrey Quote  Post ReplyReply Direct Link To This Post Posted: 13 Jan 2014 at 18:30
Originally posted by Rill Rill wrote:

/me goes out to claim more sov

I'm guessing that the spreadsheet assumes everything is troop sov?  Alliances that support large cities with lots of food sov might end up looking more powerful than they actually are.

I can only speak for my armies, and they can't fight their way out of a paper bag.  That is, if they could find the bag to begin with.


I believe it is possible to access the sov. information through the api/data info. 

Back to Top
 Post Reply Post Reply Page  123>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.