*Please note that I use a point (".") for my decimal*
FP cost Formula
If I was looking for how much FP a would be required for Cape Canaveral to reach level 24, I would use this formula here:
Now I know my Y would be 24, and I would have to look at the tenth level of the GB to find out that X would be 880. Now, I have: RoundUp(880 * 1.025^(24-10)) = RoundUp(880 * 1.025^(14)) = RoundUp(880 * (1.41297)) = RoundUp(1243.4) = 1244. Checking at the levels 11-25, I see that the 24th level does require 1244 FP
Happiness/Population Formula
Now let's say I am looking for how much population a level 16 Habitat holds. Using the top formula here:
I will have to use this 6 times in order to only get an estimate of the population (though Excel would make it easy to find past a hundred levels
). Anyways, first I know that a level 10 holds 17690 population, so to find the next level, so it would be: (17690)*(10.75/10.25) = 18552.93 (as you see I'm already one off here compared to the true level 11's population)
Next, level 12 would be: (18552.93)*(11.75/11.25) = 19377.50
Then Level 13: (19377.50) * (12.75/12.25) = 20168.42
You can continually do this to get Level 14 (20929.49), Level 15 (21663.86) then Level 16 (22374.15)
OR
You can alternatively multiply everything together at once: (17690)*(
10.75/
10.25)*(
11.75/
11.25)*(
12.75/
12.25)*(13.75/13.25)*(14.75/14.25)*(15.75/15.25) which will give you the exact same answer of 22734.15
In conclusion that will be about 22374 people which is 3 off compared to the true value (sue me for being less than 1% off lol)
Coins/Supply Formula
Now let's say I am looking for how much coins a level 21 Cathedral of Aachen holds. Using the other formula here:
I will have to use this 11 times in order to only get an estimate of the coin bonus. So again, I know that a level 10 holds 18950 coins, so to find the next level, so it would be: (18950)*(10+1.125)/(10-0.125) = 21348.73 (as you see I'm one off here again compared to the true level 11)
Now level 12 would be: (21348.73)*(12.125/10.875) = 23802.61
Level 13: (23802.61) * (13.125/11.875) = 26308.15
Level 14 = 28862.34
Level 15 = 31462.55
Level 16 = 34106.46
Level 17 = 36792.01
Level 18 = 39517.34
Level 19 = 42280.79
Level 20 = 45080.85
and Level 21 would be 47916.12 or about 47916 coins which is 10 off compared to the true value (sue me for being less than 1% off again :p)