How do formulas work in Imperia Online?

[Decimus]

Couldn't get time calculating of Buildings and Research right in my spreadsheets !!   
Asked IO support for help ..... omg 
Answer of Support: Time calculating is too difficult to explain 
My answer: But, but, but when it's calculated there must be a formula for it 
Support: No really too difficult 

Now I ask myself .... if it's true .... and it's really that difficult ....

WHY THE HELL THEY MAKE IT THAT DIFFICULT .... does this have a reason .... must it stay a secret .... OMG 

everything can pe "hacked" in IO and formulated with good math in excels , ill try this era to see how buildings time  evolve  on..as soon ill start a new province.
hope that didnt upset IO-team 

[fragmaster]

so dissapointed that formula 1 DOESNT WORK anymore after certan level.Why it isn't mentioned ! ! .I hope i ll get chance to have conversation with caxo or somebody from io team ,via private message

[chegewara]

i try to revert formulas from many datas and this is few on the exel sheets


time is a very difficult situation, because the parameter is not constant and varies depending on the level of university studies or for the architecture for buildings

I found the formula for the duration of the buildings and research. The time varies according to Formula 1 for each level of the building or researches and modified by the university or architecture in accordance with the model

- (1+level university*0,02) for the researches and university
- (1+level architecture*0,02) for the buildings

but this formula doesn't  work with all buildings (fortresses, university, depot station have other formulas)

This is the work of the Polish team IO

[dePariz]

Am very confused using this Imeperial Online calculator, at the Nomads today we attacked with Fortress siege mode from Robbyal [NOMADS] with detail army:

Heavy Spearmen : 10000
Heavy Archer : 5000
Swordsmen : 10000
Heavy Swordsmen : 10000
Heavy Cavalry : 3000
Catapults : 200   
            
We have detail :
Range Attack : 14
Male Attack : 11
Armor : 11
Military Medicine : 6
Fortification : 13
Fortress Level : 6

with Army:
On Field:
Heavy Spearmen : 1004
Heavy Swordsmen : 1153
Heavy Archer : 769
Elite Archer : 500
Heavy Cavalry : 830

And at Garrison :
Elite Archer : 6080

After battle my army lost at all fight, my province terrain is train and train with forest.

Need help from all to analize why am lose?

thanks for all answer...

[fragmaster]

=PRODUCT(100;POWER(1,96;N2-1);POWER(0,98;PRODUCT(N2-1;N2-2;0,5));1/(1+0,02*(N2-1)))

this Excel formula will work for gold calculation for university for v4 ,where N2 is field which contains level of university u want to calculate.Ofcourse ,it works only below lvl 41 ,and after that only self-discount applies (those 2% per level).
product(a;b;c) <=> a*b*c
power(a;b) <=> a^b
100 is base gold price (w:s:g=2:1:1 ,so knowing gold is enough).
This is iterative formula ,not recursive ,and ofc, is derived from recursive. If u have any question ,pm me.

[chegewara]

in several posts I'll give most of the formulas IO (ver4a).

Farm, lumbermill, iron mine and stone quarry:

• cost=bc*1,25^cl/(1+al*0,02)

bc - basic cost
cl - current level
al - architecture level

• time=bt*1,25^cl/(1+al*0,02)/(1+al*0,3)

bt - basic time
cl - current level
al - architecture level


University

• cost=bc*formula1/(1+ul*0,02)

bc - basic cost
ul - current level of university

• time=0:03:00*formula1/(1+ul*0,02)/(1+ul*0,45)

ul - current level of university


Military buildings, granary, depot station, reserve

• cost=bc*formula1/(1+al*0,02)

bc - basic cost
al - architecture level

• time=bt*formula1/(1+al*0,02)/(1+al*0,3)

bt - basic time
al - architecture level


Fortress

• cost=bc*4^cl/(1+al*0,02)

bc - basic cost
cl - current level
al - architecture level

• time=0:23:00*4^cl/(1+al*0,02)/(1+(al+ma)*0,3)

• repair cost=(300*4^cl/3*2+1000*4^cl)/5/(1+al*0,02)

cl - current level
al - architecture level
ma - military architecture level

* build time fortress thanks to SEN

[chegewara]

Researches

Military academy

• cost=bc*4^cl/(1+ul*0,02)

bc - basic cost
cl - current level
ul - university level

• time=0:01:00*4^cl/(1+ul*0,02)/(1+ul*0,45)

cl - current level
ul - university level


Other researches

• cost=bc*formula1/(1+ul*0,02)

bc - basic cost
cl - current level
ul - university level

• time=bt*formula1/(1+ul*0,02)/(1+ul*0,45)

bt - basic time
cl - current level
ul - university level

[tytus_160]

How does the population grow?

The population has fixed growth of 30 people per hour, plus 1 for every 1000 population, 1 for every Granary. Then everything is multiplied by the terrain bonus and medicine. So if you have 10 000 population, with 11 Granaries 5th level medicine and Plains terrain, you would have:

(30+10+11)*1.25*1.2=76.5 people per hour

However after 100 000 the population growth starts to slow down:

at 100 000 after the calculation of the growth formula we take 10 population out, so you have (30+100+Granaries)*terrain*medicine-10..
at 110 000 we take 24 out (this is 10 + 14)
at 120 000 we take 42 out (this is 10+14+18)
and so on.... every 10 000 above 100 000 adds:
10 at 100k
14 (10+4) at 110k
18 (14+4)
22 (18+4)
26 (22+4)
30 (26+4) at 150k
and so on...

So at 150 000 population we are subtracting from the hourly growth the sum of 10+14+18+22+26+30=120 ... soon the growth will seize... medicine and granaries can push the absolute barrier but inevitably the growth will stop.

Is this still correct - especially for the population above 100 000?

[Starbuck]

of course it is .... why would you want it to have change ?

[tytus_160]

cause reality shows some differences...
my province:
110037 pop
14 granary
9 healers
13 med
20% terrain
so:
(30+100+14)*1,65*1,2*1,09 = 310,78 -24 = 286,78

Actually the growth is 306

[Starbuck]

cause reality shows some differences...
my province:
110037 pop
14 granary
9 healers
13 med
20% terrain
so:
(30+100+14)*1,65*1,2*1,09 = 310,78 -24 = 286,78

Actually the growth is 306

That's because you don't use the formula correctly ...

1) it doesn't say that you max the pop value at 100k, but that from that point you have to include an incremental malus
2) the healer guild was introduced a posteriori, and for simplicity, is to be included on the overall calculus

here is how you should have done it :

{[(30 + 110 + 14) x 1.2 x 1.65) - 24] x 1.09} = 306.2 rounded up at 306


Have fun,

[tytus_160]

Hmmm, so how about this:
113637 pop
14 granary
9 healers
13 med
20% terrain

according to your formula:
{[(30 + 113(?) + 14) x 1.2 x 1.65) - 24] x 1.09} = 312,67
{[(30 + 114(?) + 14) x 1.2 x 1.65) - 24] x 1.09} = 314,83

but the growth is 307

edit:
116087 population
growth still 307
while {[(30 + 116 + 14) x 1.2 x 1.65) - 24] x 1.09} = 319,15

any ideas?

[Starbuck]

no ideas at the moment 

[Radooo]

I'm not so sure that for every 1k villagers you gain one more villager, meaning that they are added only they reach a multiple of 10 (for example you have 110 at 110k, 110 at 119k and 120 at 120k)

[Starbuck]

which would mean that the 306 or 307 value is just a round-up issue ...