Print Page | Close Window

Illyriad City Planner

Printed From: Illyriad
Category: Strategies, Guides & Help
Forum Name: Strategies, Tips & Tricks
Forum Description: Player created guides and advice.
URL: http://forum.illyriad.co.uk/forum_posts.asp?TID=4161
Printed Date: 17 Apr 2022 at 02:48
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Illyriad City Planner
Posted By: JimJams
Subject: Illyriad City Planner
Date Posted: 10 Sep 2012 at 09:31
It's now a year I am playing this game, and I am still playing, so it is time to share some knowledge.

Well, English is not my native language, so please forgive me if I am not that good explaining.

The sheet I am presenting here was not kept secret, it is used in H? and T?, and probably, as T? spread members in every alliance, it is used in other alliances too.

But publishing it here I think more people will know...

Many people found the sheet to be valuable, so I hope you will too.
I know other people have something similar, or may be better. 
This is what I use, feel free to get it or not :-)

I will support the sheet, until I use it, so probably until I play the game.

This is from now on, the official link to the official sheet:

http://docs.google.com/spreadsheet/ccc?key=0AumwLJzwY-1pdFRORHJwMXRmVXJBd2ZFSHloU0lyX0E" rel="nofollow - https://docs.google.com/spreadsheet/ccc?key=0AumwLJzwY-1pdFRORHJwMXRmVXJBd2ZFSHloU0lyX0E

It's a google doc sheet, you cannot edit it, but you can use "File"->"Make a Copy" to have your own google doc copy, or just "File"->"Download as" to download the spreadsheet and use it locally on your computer.

I prepared a document with a walk through, read it before to try using the sheet:

http://docs.google.com/open?id=0B-mwLJzwY-1pMzhaWmNUalRraXc" rel="nofollow - https://docs.google.com/open?id=0B-mwLJzwY-1pMzhaWmNUalRraXc
or
http://docs.google.com/file/d/0B-mwLJzwY-1pMzhaWmNUalRraXc/preview?pli=1" rel="nofollow - https://docs.google.com/file/d/0B-mwLJzwY-1pMzhaWmNUalRraXc/preview?pli=1

Please use this thread to ask questions, report bugs or errors, give suggestions.... 






-------------



Replies:
Posted By: JimJams
Date Posted: 10 Sep 2012 at 09:32
Reserved

-------------


Posted By: dunnoob
Date Posted: 10 Sep 2012 at 13:13
The open URL for the PDF manual asked me to login, here's a read-only https://docs.google.com/file/d/0B-mwLJzwY-1pMzhaWmNUalRraXc/preview?pli=1" rel="nofollow - variant  of this PDF working without account.  Very interesting, at a first glance, thanks.  Hopefully folks know that sov distances (4|0) and (4|1) are cheaper than (3|3), but typically still far too expensive for hungry 5-food towns... Wink 


Posted By: Anjire
Date Posted: 10 Sep 2012 at 14:29
I approve of this message :)

-------------
http://elgea.illyriad.co.uk/a/p/26125" rel="nofollow">


Posted By: Gossip Boy
Date Posted: 10 Sep 2012 at 18:27
how can i edit the doc?

-------------
Elessar2
[08:34]<Rill> when you've just had part of your brain taken out, you lack a certain amount of credibility
<KillerPoodle> I can say anything I like and it is impossible to prove or disprove


Posted By: Bonaparta
Date Posted: 10 Sep 2012 at 19:29
Very nice city planner. 

-------------
http://elgea.illyriad.co.uk/a/p/95216" rel="nofollow">


Posted By: geofrey
Date Posted: 10 Sep 2012 at 19:42
I don't know what I'm doing, but it looks very professional and colorful. 

-------------
http://elgea.illyriad.co.uk/a/p/45534" rel="nofollow">


Posted By: JimJams
Date Posted: 10 Sep 2012 at 20:55
Originally posted by Gossip Boy Gossip Boy wrote:

how can i edit the doc?

It's a google doc sheet, you cannot edit it, but you can use "File"->"Make a Copy" to have your own google doc copy, or just "File"->"Download as" to download the spreadsheet and use it locally on your computer.


-------------


Posted By: JimJams
Date Posted: 10 Sep 2012 at 20:59
Originally posted by Anjire Anjire wrote:

I approve of this message :)

Thanks Anjire, you know a lot of your own work is in the sheet :-)


-------------


Posted By: SunStorm
Date Posted: 11 Sep 2012 at 19:46
Very nice JimJams!  (^_^)

-------------
"Side? I am on nobody's side because nobody is on my side" ~LoTR



Posted By: Salararius
Date Posted: 12 Sep 2012 at 03:08
Wow, neat ideas in here.  I especially like the sov grid.  Much nicer than the array I used in Excel.  Got me so interested I started messing around with Google docs and ended up with a different take on the entire thing.  Not sure if it's helpful or not but I'll share it too as a way to say thank you.

https://docs.google.com/spreadsheet/ccc?key=0Ao6l7avI4cJvdG8zV2s1UzRXOXh0dEZWZnFFOXlGaVE" rel="nofollow - https://docs.google.com/spreadsheet/ccc?key=0Ao6l7avI4cJvdG8zV2s1UzRXOXh0dEZWZnFFOXlGaVE

Sal



Posted By: Albatross
Date Posted: 12 Sep 2012 at 12:02
mCrow have this one (just a screenshot attached) - it's missing the tax slider, but gives a reasonably good feel for the food-generating potential of a square.

Uniquely, this one:
  • Assesses the likelihood that a town on the map will want to claim food sov, and makes a 'contention heat map'.
  • Makes 'Farmstead build level' suggestions, based on requirements.




-------------


Posted By: JimJams
Date Posted: 12 Sep 2012 at 22:01
Originally posted by Salararius Salararius wrote:

Wow, neat ideas in here.  I especially like the sov grid.  Much nicer than the array I used in Excel.  Got me so interested I started messing around with Google docs and ended up with a different take on the entire thing.  Not sure if it's helpful or not but I'll share it too as a way to say thank you.

https://docs.google.com/spreadsheet/ccc?key=0Ao6l7avI4cJvdG8zV2s1UzRXOXh0dEZWZnFFOXlGaVE" rel="nofollow - https://docs.google.com/spreadsheet/ccc?key=0Ao6l7avI4cJvdG8zV2s1UzRXOXh0dEZWZnFFOXlGaVE

Sal


I really appreciate it Salararius, and I like some of the approach, especially the buildings tables.
I am about to start a new version to fit some more things and adjust the sheet, I will probably use some of your approach :-)

Thanks !


-------------


Posted By: JimJams
Date Posted: 12 Sep 2012 at 22:03
Originally posted by Albatross Albatross wrote:

mCrow have this one (just a screenshot attached) - it's missing the tax slider, but gives a reasonably good feel for the food-generating potential of a square.

Uniquely, this one:
  • Assesses the likelihood that a town on the map will want to claim food sov, and makes a 'contention heat map'.
  • Makes 'Farmstead build level' suggestions, based on requirements.



Look as a nice tool to address sovereignty decisions.

I would like to have a private talk with you about it, will send IGM.


-------------


Posted By: Salararius
Date Posted: 13 Sep 2012 at 15:03
I realized that I could easily add production rates and basic resources usage (from production) pretty easily.  I added that so you can now see how many spears, cows, etc... your cities will be capable of producing.



Posted By: Bonaparta
Date Posted: 13 Sep 2012 at 15:15
JimJams, could you implement advanced resource production cost into your city planer like it is here:

https://docs.google.com/spreadsheet/ccc?key=0ApL1rFFXeNNtdEoxNVRPZEpTeGYxNm5XdHRYdWNWVHc&hl=en_US#gid=0" rel="nofollow - https://docs.google.com/spreadsheet/ccc?key=0ApL1rFFXeNNtdEoxNVRPZEpTeGYxNm5XdHRYdWNWVHc&hl=en_US#gid=0

Especially food costs for cows and horses can effect city size.


-------------
http://elgea.illyriad.co.uk/a/p/95216" rel="nofollow">


Posted By: Rill
Date Posted: 13 Sep 2012 at 18:42
import food to produce cows and horses.  it will more than pay for itself if you sell a percentage.  I don't think that should be a factor in city planning, personally



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net