Spreadsheet Income Calculator

[Jesus Prime]

I want to create a spreadsheet that can calculate the income of my nation. What are the formulas that calculate gross income and expenses?

[Noscar]

You know you can just go into the "Revenue" tab.

[Darth Ataxia]

I’m neither a tech or spreadsheet aficionado but this wikipage may have what you’re looking for.

https://politicsandwar.fandom.com/wiki/Nation_Formulas
 

[Jesus Prime]

33 minutes ago, Darth Ataxia said:

I’m neither a tech or spreadsheet aficionado but this wikipage may have what you’re looking for.

https://politicsandwar.fandom.com/wiki/Nation_Formulas
 

Thanks, I had a look, however, It doesn't really have anything to directly calculate income. Does anyone know if @zevfer is going to add the information?

[naTia]

Gross income:

Calculate per city income, and then add them all up. Is modified by new player bonus, color bonus, and alliance tax.

Per city income can be calculated with:

City Income = (((Commerce / 50) * 0.725) + 0.725) * Population

Which requires:

Population: https://politicsandwar.fandom.com/wiki/City_Formulas#Population_Formulas

Which requires:

Crime/Disease: https://politicsandwar.fandom.com/wiki/City_Formulas#Crime_and_Disease_Rate_Formulas

And commerce, which you just calculate from your improvements.

 

Improvement upkeep cost:

The formula for this would be way too long to write out. This is just a matter of adding the operational cost values of all of the improvements that you have. Easiest way to implement I can think of is just to have a table of all the cost values of each improvement so you can multiply them by the count in each city, and then add it all up.

They're all here: https://politicsandwar.fandom.com/wiki/Improvements

 

Military upkeep cost:

Same as above, just adding up counts multiplied by costs. Modified by whether you are in war or at peace.

Costs are here: https://politicsandwar.fandom.com/wiki/War#Units

 

Net Income = Gross Income - Total Improvement Upkeep Cost - Military Upkeep Cost

 

Been a hot minute since I've done this, could be missing something(s)

Edited June 24 by naTia

[Jesus Prime]

24 minutes ago, naTia said:

Gross income:

Calculate per city income, and then add them all up. Is modified by new player bonus, color bonus, and alliance tax.

Per city income can be calculated with:

City Income = (((Commerce / 50) * 0.725) + 0.725) * Population

Which requires:

Population: https://politicsandwar.fandom.com/wiki/City_Formulas#Population_Formulas

Which requires:

Crime/Disease: https://politicsandwar.fandom.com/wiki/City_Formulas#Crime_and_Disease_Rate_Formulas

And commerce, which you just calculate from your improvements.

 

Improvement upkeep cost:

The formula for this would be way too long to write out. This is just a matter of adding the operational cost values of all of the improvements that you have. Easiest way to implement I can think of is just to have a table of all the cost values of each improvement so you can multiply them by the count in each city, and then add it all up.

They're all here: https://politicsandwar.fandom.com/wiki/Improvements

 

Military upkeep cost:

Same as above, just adding up counts multiplied by costs. Modified by whether you are in war or at peace.

Costs are here: https://politicsandwar.fandom.com/wiki/War#Units

 

Net Income = Gross Income - Total Improvement Upkeep Cost - Military Upkeep Cost

 

Been a hot minute since I've done this, could be missing something(s)

Thanks you so much! 🙏 

[Jacob Knox]

13 hours ago, Noscar said:

You know you can just go into the "Revenue" tab.

You know you can just not comment.

[Noscar]

On 6/24/2024 at 7:36 PM, Jacob Knox said:

You know you can just not comment.

Whatever... Btw I'm sorry if I hurt someone's feelings.

[Lisa_Dr4]

On 6/24/2024 at 2:11 AM, Jesus Prime said:

I want to create a spreadsheet that can calculate the income of my nation. What are the formulas that calculate gross income and expenses?

You can use SUM to total your income sources and expenses. For gross income, subtract total expenses from total income.

On 6/24/2024 at 7:35 AM, naTia said:

Gross income:

Calculate per city income, and then add them all up. Is modified by new player bonus, color bonus, and alliance tax.

Per city income can be calculated with:

City Income = (((Commerce / 50) * 0.725) + 0.725) * Population

Which requires:

Population: https://politicsandwar.fandom.com/wiki/City_Formulas#Population_Formulas

Which requires:

Crime/Disease: https://politicsandwar.fandom.com/wiki/City_Formulas#Crime_and_Disease_Rate_Formulas

And commerce, which you just calculate from your improvements.

 

Improvement upkeep cost:

The formula for this would be way too long to write out. This is just a matter of adding the operational cost values of all of the improvements that you have. Easiest way to implement I can think of is just to have a table of all the cost values of each improvement so you can multiply them by the count in each city, and then add it all up.

They're all here: https://politicsandwar.fandom.com/wiki/Improvements

 

Military upkeep cost:

Same as above, just adding up counts multiplied by costs. Modified by whether you are in war or at peace.

Costs are here: https://politicsandwar.fandom.com/wiki/War#Units

 

Net Income = Gross Income - Total Improvement Upkeep Cost - Military Upkeep Cost

 

Been a hot minute since I've done this, could be missing something(s)

Thanks for sharing!