Taxing and Patrolling... is it worth it?

[TheDemon]

The population killed from having a tax rate above 100% is far FAR more significant than the population killed by patrolling. I tested this extensively for my Bogarus guide on the wiki. After testing, the manual formulae for both items are correct.

I then spreadsheeted the tax formula. Conditions:
Patrol down all unrest
No other income percentage bonuses
Growth income % = 2% (no CBM)
Starting Population 30000:

At Growth 0, Growth 3, and Death 3, the last turn the income for 150% tax is greater than the income for 100% tax is turn 20, 19 and 21 respectively.
At Growth 0, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 42.
At Growth 3, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 39.
At Death 3, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 45.

Starting Population 5000:
At Growth 0, Growth 3, and Death 3, the last turn the income for 150% tax is greater than the income for 100% tax is turn 10, 10 and 11 respectively.
At Growth 0, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 21.
At Growth 3, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 20.
At Death 3, the last turn the total income for 150% tax is greater than the total for 100% tax is turn 22.


Spreadsheet attached, sorry I have no idea how the conditional formatting will show up in the old excel file (xls) but the new ones can't be attached. The spreadsheet lets you tweak with all kinds of income percentages and bonuses so its quite a powerful tool.