Imperia Online International
March 28, 2024, 11:42:16 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: 1 [2]   Go Down
  Print  
Author Topic: Population growth above 100,000 - excel formula needed  (Read 8194 times)
0 Members and 1 Guest are viewing this topic.
Polymeron
Captain
****

Karma: +98/-103
Offline Offline

Posts: 304

Be the Storm


« Reply #15 on: April 13, 2009, 21:01:46 PM »

See correction to Cell 2 in my original post.

EDIT: Some checking showed that the formulas did not give a correct result for crowded (>100,000 pop) provinces.

I've made some corrections that give a correct result. These are:
- Not incremental, but rather smooth, crowding bonus.
- Guild bonus applied to Cell 4 and omitted from Cell 1, as suggested by chegwara - thanks, I might not have caught that one without your help.

The new formulas give me a correct result for one example, see if they always work. Correct formulas (hopefully):

Cell 1: =(30+Current_population/1000+Granary_level)*(1+(0.05*Medicine_level))*(1+terrain bonus)
Cell 2: =(Current_population-90000)/10000
Cell 3: =(8+C2*2)*C2
Cell 4: =IF(Current_population<100000,C1,C1-C3)*(1+(0.01*Healers_guild_level))

...Where Cell #4 should give you a correct result every time now.

This also means that the other approach will usually give a result that is off by a little bit.
« Last Edit: April 13, 2009, 21:11:34 PM by Polymeron » Logged

Respect GW, or we'll see how good your AA is.
Polymeron
Captain
****

Karma: +98/-103
Offline Offline

Posts: 304

Be the Storm


« Reply #16 on: April 13, 2009, 21:18:57 PM »

Nope, should be as I put it in the last post. Looks like it's not incremental after all.
That was only an assumption, you know *Smiley*



Please tell me how the formula reacts with actual data!
« Last Edit: April 13, 2009, 21:19:59 PM by Polymeron » Logged

Respect GW, or we'll see how good your AA is.
SEN
Sergeant
**

Karma: +12/-2
Offline Offline

Posts: 67


« Reply #17 on: April 13, 2009, 22:32:10 PM »


The new formula works for all my provinces  *ok*

Now i need to get it into my excel  *gamer*
Logged
Pages: 1 [2]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.12 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!