Calculator city pop, food, gold

Hi all,

i hope this following topic will help u.
a bit long, but it could be useful. (at the end of the message i'll propose you an excel table that you can change as you want by mail)



it's about why a small city can have more army than a bigger one.
and how to predict your future gold income and not doing mistakes.

my aim was to know what would be the best population for a city, knowing the final max production of food, and wanting to have the more production of gold/h, without having a negative final production of food.

Here the equation:

Y = 4X(( Max food/h - Final food/h - X)/Basic food/h) - Sovereignty unkeep




Y = gold production hourly after changing extra food production in gold production by changing taxe rate

X = population of the city

Basic food/h = the food your farms produce without the bonus

Max food/h = your total production of food with the bonus with taxation to 25% = Basic food/h + Basic food/h * (flourmil%+season%+perstige%+spell%+sovereignity% +25)/100

Final food/h = the food production that will be effective in the city after u have change all you excedent food production into gold production by increasing taxe rate.

Sovereignty unkeep: here to calculate http://forum.illyriad.co.uk/coming-soon-sovereignty-brace-for-impact_topic765.html
------------------------------------------------------------------------------------------------
an other useful things:

value of 1 food/h in gold/h = 4X/Basic food/h

Gold/h = 4X*(tax/100)

tax rate = ((Max food/h - Final food/h - X)/Basic food/h)*100
----> this one is useful if u would like to calculate the production of your other ressources. For me tis is a very important thing to know if you want your town to produce many ressources or not. (i added this on the excel table)
------------------------------------------------------------------------------------------------

an exemple:

X = ?

Basic food/h = 14 000

Max food/h = 14 000 + 14 000*(99%+25%)/100 = 31 360

Final food/h = 500 fo exemple. i want to have 500 food/h to produce livestock etc...



so:

Y= 4X((31360-500-X)/14000)-0

Make a table on calculator or excel!

the max production we have is around 15 500 population . at this population if u let the 500 Food/h for ur production u will have average 69 000 gold/h.

Tip: I saw that always, the perfect population to have the best gold income (without having a negative production of food) was the half of Max food production per hour.

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

well here is what i did on Excel

http://imagik.fr/view-rl/292763

Edit: some adds: http://imagik.fr/view-rl/292890


if u want i can send the changable version by mail (only works if u have a gmail account, to use google calcs - option next to dowload option-)

if u are interested send me an ingame message with ur gmail mail , its much more quick by using excel than by using a table on a calculator. u just have to write your parameters and ur calculation is done



Any suggestions to upgrade this version are welcome ;)




Edited by Mandarins31 - 05 Sep 2010 at 12:19

Nice job Createure :)

your version is interesting because we have less calculations to do. and people just have to download on excel format to be able to change things :)

The only thing, like you said, is that it gets the true results only if you have lvl 20 farms and mill. then people are not able to see gold income at an earlier stage than finished city.
But anyway good reclalculation and good work for this calc sheet that is easier to use :)

Mandarins31


Edit ps:  oh and like i said, the best gold income without having a negative food production is exactly half the production of food u have at tax=0%

for exemple: u have 5 farms lvl 20 and mill lvl 20 (+40% bonus) and 25% bonus from 0% tax  (no spell bonus, no season, no prestige, no sov bonus)

the best pop for the best gold income will be (10 000 + 10 000*65/100) /2

= 8 250 pop.

with 7 farms and the same bonus its 11 550.

and u must know that the farest u are u are from this ideal population, the fastest u will lose ur gold income. if  11 550 is ideal  then at 9000 or 13000 u will have average the same gold income, but after u could lose many gold income each 1k population u take.




Edited by Mandarins31 - 29 Oct 2010 at 12:47

 You are right. This calculation only applies if you want your city to be totally self sufficient.

Like you said, have 0 food and still a negative production doesnt give you more penalties than stopping the production. If i remember (but im not sure) at 0 food and negative production, the gold production is stopped too. if im right u will need an other city to give food and gold if u want to handle a good army in this city.
So anyway if u produdce your gold and your food in this city or if u have a suppoting city, u need to produce the same amount of gold and food. the only difference in the case you are in negative and that u support is that u can handle a bigger army in a single city (what could be interesting tactically).

ps: u will need to produce the same gold and food as for a self sufficient city because u will need to use more production of food in an other city to produce the gold u will need to handle the army what is in your non-self sufficient city.


Edit:  yeah i was sure i already asked this questions. found the topic:

http://forum.illyriad.co.uk/food-attack-and-defence_topic962_post6798.html?KW=#6798




Edited by Mandarins31 - 29 Oct 2010 at 13:50