Social policy costs?

I've not seen one that's been updated for BNW.
 
Isnt it a triple position fibonaccieli string with invisible 1st position of 5?
And then 10% (for standard) per extra city.
Like 0 (5) 25 30 60 105 195 360...?
Not exacly. :-(
 
Just checking in anyone has made a table of this for BNW like I've seen for Vanilla and if there's a link to such onlibe for BNW as I can't find this.

thx .. neilkaz ..
 
For the first 6 policies (a full tree), that link is close enough. Afterwords the cost in BNW becomes increasely cheaper than what it was before.
 
Only because the cost per city is lower in BNW (10% on standard per city vs. 15%). The base formula (i.e., the formula that applies if you play OCC -- 25+(3*(policy number - 1))^2.01) is unchanged.
 
Does anyone found a new formula for calculating policy costs? G&K formula does not work anymore for policy representation.

The number of cities policy cost mod is on standard map 10%. Using 6.7% with representation fails. For some test results (2 cities up to 10 policies) a factor of 6% with representation seems to work. :confused:

Any ideas? :crazyeye:
 
The existing formula works. Plug the following into a spreadsheet:

=FLOOR(B4 + ((B5*(B12- 1))^B6) * (1+(B7*(100-B8)/100) * (B13- 1)) *B9 *B11/10, B10)

Where:

Column A|Column B (starting at line 4)
<Base_Policy_Cost>|25
<Policy_Cost_To_Be_Exponented>|3
<Policy_Cost_Exponent>|2.01
<NumCitiesPolicyCostMod>|10
<NumCitiesPolicyCostDiscount>|-33
<PolicyPercent>|1
<Policy_Cost_Visible_Divisor>|5
<CulturePercent> - game speed modifier|1
Policy Number|Whichever number you want
Number of Cities|However many you want

This is for Prince or greater, standard speed, standard map with no Christo Redentor or other policy discount other than Representation's 33%.
 
Last edited:
Thanks for your fast reply ;)

But this formula does not work for me :confused:
Using 2 cities wihtout Representation and {B4 + ((B5*(B12- 1))^B6)} with extra brackets your formula works, with Representation not.

here my extracted policy costs from the game:

policy | w/o Representation | w Representation
4 | 115
5 | 185 | 180
6 | 280 | 270
7 | 390 | 375
8 | 525 | 505
9 | 680 | 655
10 | 855 | 820
11 | 1050 | 1010
12 | 1265 | 1220
13 | 1505 | 1450
14 | 1760 | 1695
15 | 2040 | 1965
Maybe I made strange mistake :help:
 
Last edited by a moderator:
Well, this was an interesting rabbit hunt. Serves me right for trying to build a spreadsheet late at night.

The solution is two rounddown functions, in just the right places:

=FLOOR(ROUNDDOWN( ( 25 + ( ( 3 * ([policy num]- 1 ) ) ^ 2.01 ) ), 0) * ( 1 +( ( 10 * (ROUNDDOWN( (100-33)/100, 1)) * ( [num cities] - 1 )) / 100) ), 5) -- the first expression rounds down the first piece (raw policy cost, before the city multiplier) to the next lower integer and the second expression rounds down the city multiplier to the first decimal before converting to a percentage.

This same formula can be used to generate non-Representation policy costs -- just omit the second rounddown piece.
 
:clap:

thanks for your great help - this formula works - great stuff

little bit confused of why using a second ROUNDDOWN for the Representation part (how did you find that?)
This increases the Representation value to exactly 40% - if so, why not using 40% directly? :confused:

Maybe I mod this value and play a few games to valide the second ROUNDDOWN...
 
Tedious experimentation! How else do we figure out stuff about this game?

For a standard, standard game at most difficulty levels, Representation is an effective 40% discount on the 10% per-city penalty, but that was not the case in vanilla (originally 30%) or pre-BNW-patch (15%), where Representation's -33 integer discount would, if left unrounded, result in a per-city social policy cost of 20.1% and 10.05%, respectively. I suspect Firaxis didn't want those minor decimal amounts cluttering up the computation -- hence, the Representation rounddown -- but they didn't revise that approach when they changed standard to a 10% per city penalty.
 
Hi folks,

thanks for the bnw formula :)
We are currently playing a pitboss game on a very large map (for half a year now, and we are in turn 113 :D )
The formula did not match exactly.
With some experimentation, I found out how it was to be adjusted for very large maps:

With representation:
=FLOOR(ROUNDDOWN((25+((3*(POLICIES-1))^2.01)),0)*(1+((5*(ROUNDDOWN((100-33)/100,1))*(CITIES-1))/100)),5)

Without Rep:
=FLOOR(ROUNDDOWN((25+((3*(POLICIES-1))^2.01)),0)*(1+((5*(CITIES-1))/100)),5)

As you can see, the factor in the second part of the formula just decreased from 10 to 5
 
Top Bottom