Printable View
Hi guys. Trying to run some numbers for %based buildings and the formula on the wiki is
Percentage Based Buildings = Base Effect * BE * Max(50%, % of building) * (100% - Max(50%, % of building))
But I don't understand what the (max(50%, % of building) is suppose to mean. Can anyone help me out with this?
Thanks!
It means whichever is larger between 50% or the actual % of the buildings that you have
But I think it should be min?
That formula that uses max will only work if your actual % of buildings is more than 50%
The max % is the maximum percentage of those buildings you can build for effect.
still not making sense...
lets take homes for example here that have a 4% base effect.
and say we have 100% BE and have 5.5% homes. what should your % bonus be for the population growth
Percentage Based Buildings = Base Effect * BE * Max(50%, % of building) * (100% - Max(50%, % of building))
% effect = 4% * 100% * 50% * (100% - 50%)
This just doesnt add up or make sense...
Yeah that's why I edited my post above. Should be using min instead of maxQuote:
Originally Posted by SBWildFire
ok lets change up the formula like its suppose to be then.
lets take homes for example here that have a 4% base effect.
and say we have 100% BE and have 5.5% homes. what should your % bonus be for the population growth
Percentage Based Buildings = Base Effect * BE * min(50%, % of building) * (100% - min(50%, % of building))
% effect = 4% * 100% * 5.5% * (100% - 5.5%)
% Effect = .04*1*.055*.94 = .002068
Thats .2% thats still not making sense.
it should be:
4 * 1 * 0.055 * 0.945 * 100 = 20.79
thanks.
You could try using this:
=MIN(BE*(MIN(Building%,0.5)-MIN(Building%,0.5)^2),0.25)*BaseEffect
or
=MIN(Building%*BE*MAX(0.5,(1-Building%)),0.25)*BaseEffect
(Both give the same result)