Results 1 to 9 of 9

Thread: Need help understanding a formula.

  1. #1
    Member
    Join Date
    Jul 2017
    Posts
    24

    Need help understanding a formula.

    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!

  2. #2
    Regular
    Join Date
    Oct 2014
    Location
    Singapore
    Posts
    58
    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%
    Last edited by Aetherion; 03-07-2017 at 05:17.

  3. #3
    Post Fiend joeblogs's Avatar
    Join Date
    Nov 2014
    Posts
    265
    The max % is the maximum percentage of those buildings you can build for effect.
    "Because of the implication"

  4. #4
    Member
    Join Date
    Jul 2017
    Posts
    24
    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...

  5. #5
    Regular
    Join Date
    Oct 2014
    Location
    Singapore
    Posts
    58
    Quote Originally Posted by SBWildFire View Post
    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))

    Yes, that's why I edited my post above that it should be using min instead of max

    % 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 max

  6. #6
    Member
    Join Date
    Jul 2017
    Posts
    24
    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.

  7. #7
    Regular
    Join Date
    Oct 2014
    Location
    Singapore
    Posts
    58
    it should be:
    4 * 1 * 0.055 * 0.945 * 100 = 20.79
    Last edited by Aetherion; 03-07-2017 at 05:46.

  8. #8
    Member
    Join Date
    Jul 2017
    Posts
    24
    thanks.

  9. #9
    Strategy Moderator
    Join Date
    Aug 2008
    Posts
    1,226
    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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •