This is a Government Simulator with strong RP ties for Aurora C#. It started here
]http://aurora2.pentarch.org/index.php?topic=11908.msg140960#msg140960] and continued here
https://aurora2.pentarch.org/index.php?topic=12763.msg155606#msg155606It is designed to work with the latest Libre Office which is free to download here https://www.libreoffice.org/download/download/It has been reported that the new libre office makes the compatibility with OPENOFFICE easier and that currently, the file seems to work under that software as well. While not suggested then, it may still be possible to use the file with OPENOFFICEI recommend reading the tutorial to understand its rules. If you are after a fancy simulator integrated into Aurora C# that does not require your intervention to function please don't use it as you will be disappointed.
This file's not a mod but a tool to be used along with Aurora C# and your RP abilities.
As started on the previous iteration of the file, I am writing an extensive tutorial of actions to perform before running an election. I trust that this, plus more information on the screen will guide the player much better than before making it all clear and easy to use and understand.
This new file has also been built keeping modders in mind, so all information will be easily accessible on the relative tab and to edit or add a few features should be easy for a person familiar with basic/advanced excel skills. For instance, adding a new government form should be very easy to achieve providing the modders respects the structure on the DATA sheet.
Download at the end of the post or fast download here: https://aurora2.pentarch.org/index.php?action=dlattach;topic=13639.0;attach=8656
Known issues and fixes:None
CHANGELOG
1.0 RELEASED 01/10/2021
TUTORIAL
Important info prior to starting: The player should fill only the white cells. Editing and or writing on other cells may cause issues breaking the file. To leave the modding option on, I cannot lock the cells so it is up to the user to abide by the recommended rules.
STARTING SETUP – RACE INFORMATION AND RACIAL TRAITS
This new file is now divided in 2 main work sheets: ELECT and GOVERN.
The first thing to do once the file is open is to set up the
RACE INFORMATION and the
BASE RACIAL TRAITS located in the
ELECT worksheet. In case you do not know or remember, these values are available on Aurora C# under the Race Information window.

- Total Population – Total Population of your empire as per Race Information window
- % of Race Population – Percentage of Race Population of your empire as per Race Information window
- Government Form (current) – Current Government form of your Race. See GOVERNMENTS section for more info
- Term Length – This is automated depending on the Government Form of your choice
- Legal Age – The age your population is allowed to vote
- Determination – Determination level of your Race as per Race Information window
- Diplomacy – Diplomacy level of your Race as per Race Information window
- Expansion – Expansion level of your Race as per Race Information window
- Militancy – Militancy level of your Race as per Race Information window
- Trade – Trade level of your Race as per Race Information window
- Xenophobia – Xenophobia level of your Race as per Race Information window
The racial traits determine the political landscape of your population and the ideals each voter has. There are 5 main ideas tied to 5 traits. The traits will change over time depending on the actions of your government.
See LEGISLATION section for more info- Determination – Federalists Modifier
- Diplomacy – Pacifists Modifier
- Expansion – Militarists Modifier
- Trade – Trade Modifier
- Xenophobia – Nationalists Modifier
A special trait is instead used to simulate how many people feel voting is important and how many will negative react to unpopular laws and choices.
- Militancy – The higher the number the more people will turn up to vote on election day or oppose legislations
STARTING SETUP – LEADERS
Another important part to set up are
LEADERS which are as well located located in the
ELECT worksheet. To get the best out of this it is preferred to use real characters from your Aurora C# game. All available characters are listed under the Aurora C# Commanders window.

- Name – Name and Surname of your selected Character as per Commander window
- Status – Determines if the Character is participating or not in the next election
- Background – Depending on the Character’s Job as per Commander window
- Party – The Character’s party affiliation. Player choice
- Role – The Character’s current political role in the upcoming election
- Trait – Traits of your selected Character as per Aurora’s Commander window
- Points (Funds) – Promotion Points of your selected Character as per Commander window.
To make every leader feel different, their traits and promotion points will actually impact how much people are supporting and voting for them. For instance, a Born Leader will generally attract more votes than one that Yields to Others.
Scientists and Civilian Leaders have their promotion points determined by their Admin Level multiplied by 1,000.Special RulesIf the player would like to play without the traits activated, it is possible to set them all to None. If the player would like to play without the promotion points activated, it is possible to set them all to 0 (zero). If the player would like to play with less than 3 leaders, the status of the leader can be set to INACTIVE.
Once completed, it is time to move into the
CONSTITUTION which is located in the
GOVERN worksheet.
STARTING SETUP – CONSTITUTION

If the player is just starting and have selected a government of choice, it is time to align the constitution with the government ideals. The available choices are under the required section. A good indication the player’s choices are correct is if there are no red warnings under Race Equality (like in the picture).
The constitution is divided into 2 branches: Primary and Secondary. The primary constitution can be changed only by one slot up or down. So for instance, if you open Civil Rights and they are set as Limited, during a constitutional reform you will be able to choose only Full or Few.
See VOTE section for more infoThe secondary constitution can be changed as the government wish without any limitation. So for instance an Equal status on the Voting Rights could be moved to Elite directly if needed.
It is worth noting that leaders can now be either appointed or elected. Elected leaders will operate as they have done in all previous iterations of the file, including endorsements from other parties. Appointed leaders, on the other hand, will rely solely on the government's relationships with its parties. This means that in an appointed system, a candidate will focus more on gaining support from a large and impactful party rather than just increasing their appeal and likeability.
Once everything has been set please ensure NO EVENTS or LEGISLATION are active and head back to the ELECT worksheet.
Please note: In the above picture, for instance, President Views should be unticked before proceeding.[/li][/list]
STARTING SETUP – RACIAL TRAITS MOD FACTOR
The Racial Trait Modifier has been introduced to limit the rapid changes of the Racial Traits. Simply put, the higher the value, the lesser the impact of laws on dynamic value changes.
This can be used in various ways. I am starting it at 5, and with each election won by the same party, I increase it by 1 to simulate the radicalization of the population. So, it starts at 5, then goes to 4, 3, and so on. In the case of a government dissolution, I bump it up instantly to 1, emphasizing that radicals gain more power. After that, I reduce it back to 5 year after year and increase it again if no changes occur. You can use it as you see fit, but at least you now have a tool to control radicalization that works in tandem with government dissolution.
FIRST ELECTION
For the first Election, usually at the start of the game, the player must complete the setup of the Elect worksheet by unticking any active party in the Custom Coalition section along with all the options in the Campaign section. Furthermore, all Endorsement should be set to none, while the Stable Government check should be the only one ticked. All participating Characters to this first election should have their roles set as Running for Office and status as Active.
To run the election, the player must push F9 and visualize the green message and follow the instructions, otherwise, the player shall read the red message and act accordingly.

If elections are valid just paste and special copy – unformatted text on the relative cell. It is very important to use unformatted text, otherwise, the file may get damaged. If elections are not valid they may lead to the special Electoral Fraud rule which will influence the amount of Nationalists, Federalists, and Militarists ideals.
Once copied into the relative cells, the new data will generate updated government houses or powers which will proceed to the election of the new government leader.

Once done, the player should set the winner of the election role as Ruler.
Rules and options vary depending on the government form adopted.
See GOVERNMENTS section for more infoIn the above picture, for instance, we are using a Federation and a clear majority within the regular coalitions could not be formed, therefore, the Player receives and alert asking to form a custom coalition. In this case, for RP, we can suppose that being a Federation, the Federalists will be part of the Coalition. As the Current President is a Martial Artist, we can assume that Militarists will be happy to support the candidate as well. Since Federalists cut off Nationalists and the Militarists cut off the Pacifists, we will have the Trade Party to join the coalition and reach the >50% threshold required to govern.

It is now time to head back to the GOVERN worksheet and align the constitution with the desired column and tick all the relative President Views. Once completed, the Player has the option to select a more granular Government system by selecting an Ideology.

By utilizing the Government Types in the database, the Player can now choose from existing government forms and define their ideologies. While this is purely for flavour, since it is linked to the database and racial traits, the ideology should provide deeper insights into the population's orientation, enhancing role-playing depth. In summary, if the racial traits align with the parameters for a specific ideology, it will be displayed in the list; otherwise, it will be omitted.
It is now time to govern and select the Govern worksheet, where there player have the option to enact and void 1 legislation in exchange of 1 Sway Vote.
See LEGISLATION section for more info[/li][/list]
ELECTIONS
Every 1st of January of the election year, elections are due. Elections take place every number of years depending on the government form selected.
Special RulesIf the player would like to play with Dynamic Racial Traits, the player shall update the BASE TRAITS with the value of the ACTUAL TRAITS.
Note that the actual trait value will still change after updating the base value. This is WAI and the player shall update the value only once per election.
To run the election, the player must push F9 and visualize the green message and follow the instructions, otherwise, the player shall read the red message and act accordingly.

If elections are valid just paste and special copy – unformatted text on the relative cell. It is very important to use unformatted text, otherwise, the file may get damaged. If elections are not valid they may lead to the special Electoral Fraud rule which will influence the amount of Nationalists, Federalists, and Militarists ideals.
Once copied into the relative cells, the new data will generate updated government houses or powers which will proceed to the election of the new government leader.

ELECTIONS – CAMPAIGN
Leaders are now much more in charge of their fate than in previous versions. By campaigning, each leader can attract more votes from a particular group or smear the reputation of other candidates.
To campaign Leaders have to spend funds/points. The player can make up their own for RP reasons or use the Promotion Points in Aurora C# with Scientists and Civilian Leaders having their promotion points determined by their Admin Level multiplied by 1,000.
Likeability now plays a major role. While this was a hidden feature in previous versions, it wasn’t possible to account for it or modify it. Now, it's important to understand that some candidates will find it very difficult to win if their likeability is too low compared to their opponents. Character traits will determine a candidate’s likeability, along with the attack ad buffs active at the time of the election.
In the first round of the election, all candidates have the chance to secure 50.01% of the votes required to be appointed as leader. If this does not happen in the first round, the candidate rated third will be eliminated, allowing one of the remaining two candidates to reach a majority. This process involves persuading all undecided voters from the eliminated candidate to support the candidate with the highest likeability.
Finally, once everything is concluded, the CUT leader has the option to endorse one of the candidates, potentially altering the election's outcome and requesting a high price in return. This allows them to subtly or overtly push their own agenda from behind the scenes, as they could potentially withdraw their support anytime.
The RNG and endorsements will change each election dramatically, making the leader's choices strategic and calculated.
There are then multiple ways for each candidate to win, depending on both their campaign abilities and the RNG seat generation. Campaign funds serve as promotion points, with different ads costing different points/funds to run during an election. Overall, a highly-rated character will have a better chance of winning against a poorly-rated one. Conversely, a well-funded, balanced character may have multiple paths to victory against a poorly-funded, well-rated character.
Once the campaign is done, the player should set the winner of the election role as Ruler.
Rules and options vary depending on the government form adopted.
See GOVERNMENTS section for more infoAny outcome, such as leaders not reaching the minimum quorum required to govern, will result in a red alert with instructions on what to do prior moving forward.
See GOVERNMENTS section for more infoIt is now time to go back and govern by selecting the Govern worksheet, where there player have the option to enact and void 1 legislation in exchange of 1 Sway Vote.
See GOVERNING AND VOTING section for more info[/li][/list]
GOVERNING AND VOTING
Every government is subjected to a voting system. Even a Totalitarian entity must deal with the small council or generals that supports him or her. The same goes for a Monarch and so on.

To vote is easy and there are different kind of vote:
- Diplomacy – Used for any diplomatic decision
- Industrial Commercial – Used to approve Industrial Commercial or Civilian projects
- Industrial Military – Used to approve Industrial Military projects
- Peace or Peace Ops – Used for any peaceful decisions like make peace, trade deals or colonization and mining operations
- Research Commercial – Used to approve Commercial or Civilian research projects
- Research Military – Used to approve Military research projects
- War or War Ops – Used for any military decisions like declare war, and any other military operation
Every time the player loses a vote, One of the Lost checkboxes should be ticked. Losing motions will decrease the level of support to the leader and government up to a point that a single more lost vote could result in the dissolution of the government.
So, what happens if the player receives the final warning and chooses not to take any further action? The player can indeed choose to do nothing, but this will still trigger an event called "Frozen Government." While the consequences of government dissolution are severe, the "Frozen Government" event still results in a penalty for the next election due to the previous government’s partial inability to handle day-to-day operations. This penalty is less severe than government dissolution and does not cause any additional voters to turn up at the election.
It’s important to note, that regardless the level of support, once the count reaches 39 motions lost, you will incur in the Frozen government penalty and the 40th loss will always result in the dissolution of the government.
Important: The player could decide to vote for every single operation or for packages. For instance, it is possible to vote for changing the percentage of a given construction or simply for a series of constructions independently of the percentage allocated. A vote could be held for a single military operation or for a bigger one that entails the conquest of an objective and so on.
VOTE – REFORMS
There are also other votes available:
- Defend Constitution – Used to vote for a change to the constitution in favour of current Government ideals. See CONSTITUTION section for more info
- Reform Constitution – Used to vote for a change to the constitution against the current Government ideals. See CONSTITUTION section for more info
- Reform Government – Used to change government form
There is a limit to the number of times a reform can be put up for a vote. Every time a vote for such reform is called, the player shall thick the relative box. Once they all depleted for the kind, no more votes are possible until the next term.
For balance reasons, losing a Reform vote, does not add to the lost motion tally as there are more steps required to get to that point requiring a proper vote already.
Also, prior to voting for the government reform, the player shall choose the new government formation in the appropriate section.

If the government reform succeeds, a new election shall be taken and the new government elected shall be in power for the number of years indicated in the term length starting from the 1st of January of the current year.
Important: It will not be possible to change government form until the constitution matches the one of the new government selected. The player shall then try first to reform the constitution and then the government.
VOTE – SWAY VOTE
Each Leader can use their political credit or support to change the outcome of a particular vote. Once the maximum number of Sways is reached or the Leader’s political credit is exhausted no more vetoes are possible. Eventually, a Sway could be expressed to force a resolution that was approved to be rejected but also one that was rejected to be approved. This is particularly handy when the player faces situations where a 0% chance or a 100% chance are present for a given vote.

The Sway is a very powerful tool for Players, however, some government forms may not allow for the Leader to express veto rights. In other instances, while Leaders are allowed to Sway votes, the government forms may not allow them to use Sways in support of reforms instead.
See GOVERNMENTS section for more info
EVENTS
Events are particular situations that could influence your race ideals.

Currently, there are 13 available events:
- Artifacts Available – The player shall activate it if an artifact has been detected but not activated yet
- At War (Declared) – The player shall activate it if a war was declared by the player and still ongoing
- At War (Attacked) – The player shall activate it if a war was declared against the player and still ongoing
- Budget Deficit (Election) – The player shall activate it if the Expenditure in the Aurora C# Economics window under the Wealth / Trade tab is higher than the Income in the One Year filter prior the election
- First Contact – The player shall activate it if during the term any new race was encountered
- In Science Agreements – The player shall activate it if during the term any new science agreement with an alien race has been reached
- In Survey Agreements – The player shall activate it if during the term any new survey agreement with an alien race has been reached
- In Trade Agreements – The player shall activate it if during the term any new trade agreement with an alien race has been reached
- Mineral Shortage – The player shall activate it if reckons that mineral shortage is influencing production and decisions. For instance, not producing fuel at refineries due to lack of Sorium rather than overstocking of fuel
- Piracy Detected (Term) – The player shall activate it if any pirate activity was detected during the term
- Ruins Available – The player shall activate it if there are any available ruins not exploited yet
- Turmoils (Threat present) – The player shall activate it if at the moment of elections a threat is present
See UNEXPECTED EVENTS and REBELLIONS section for more info[/li]
[li]War Casualties (1 Year) – The player shall activate it if in the year prior to the election any lives were lost during a war[/li][/list]
Important: All the war events are subjected to the player. Spoiler races may be not considered to declare a war alert, however, bigger operations against planets with full-scale battles could be considered as mini-wars. The concept should be fluid and used carefully as it may lead to extreme militaristic societies.
UNEXPECTED EVENTS and REBELLIONS
When government popularity falls or the forces in power are not aligned with the current government ideals severe events could happen. These go from a simple terrorist attack to a more serious leader assassination.

If the
UNEXPECTED EVENTS are available, the player shall run at least 1 event per year and act accordingly to the result. This part is entirely RP so it is up to the player to use it following the 1 per year rule or even extend it to 2 or 3 or more events per year.
LEGISLATION
There are 32 different legislation available. Each one influences one or more ideals and racial traits. It is up to the player to discover what does what, as some may work only in combination with others or if used in a particular government could lead to new parties or ideas.

A government may change one only at the start of each term in exchange of a Sway Vote.
UNDERSTANDING YOUR RACE
There is more information about the player’s race that can be found on the screen.

The
VOTING POPULATION situated left of the red box in the above picture, is a more detailed view of your voting platform. Some government forms allow only a restricted amount of people to vote increasing unrest. Unrest straightens the opposition of your government through more support given by a surprising number of people that decided to turn up for a vote last minute. This is added to the already calculated RGN of the base election poll. Having too much opposition to your government can lead to severe consequences that vary from terroristic attacks to government reform with consequent loss of power.
You can see the unrest value in the Govern worksheet. Each level of unrest generates Activists and Radicals, which are pop generally supporting their own party views and will most likely stick to it, leading to a stagnant and very unstable political landscape.
The
LEADER CURRENT APPEAL is the likelihood a leader would be voted by the relative party member with the same ideals. This is good to know while ruling as a leader and could help with the RP decisions. It is reasonable to expect a leader highly supported by the military faction to favour a resolution that could advantage such faction and so on. The player should also take into account the size of the party in question. A 20% of preference of a party counting 30 seats is higher than 50% of a party counting 5 seats. However, increasing the chances such a party could get more seats may result in more votes. It is up to the player to decide the strategy.
The
VOTE BY IDEALS is divided into 3 groups.
First, you can see the Poll by base value. This is the likelihood the party will get voted without any events or legislations influence. This is valuable later if the player is trying to understand why there aren’t enough militarists for instance. Perhaps the base Expansion value is too low and legislation to raise it over time may be needed.
Then you have the Poll Min which will highlight the minimum amount of votes a party will get. In any case, the RNG will generate a number lower than that.
Lastly, you have the Poll Max which will work as the Min but with the maximum of votes possible.
GOVERNMENTS
There are currently 6 Governments forms available:
- Democracy
- Republic
- Federation
- Totalitarian
- Corporate
- Monarchy
Each one has its own advantages and disadvantages. Each prefers an ideal over another and favour only some legislations or events.
GOVERNMENTS – DEMOCRACY
Originating in Ancient Greece, democracy means ‘rule of the people. The term today refers to a political system in which the people or their elected representatives govern themselves, rather than being governed, so everyone has an equal say in the decisions affecting their lives. Everybody can vote to elect parliamentarians which number is defined by the number of eligible voters. Once elected parliamentarians will reunite in a parliament with a capped seat amount of 5000 and a minimum of 100.
Each parliamentarians vote count as one. After the motion is discussed a vote takes place and to be approved a majority vote of the attending voters is required. As the parliamentarians represent the people they are often busy or travelling to visit their pool of voters making promises. For this reason, the amount of undecided votes per motion is always higher than any other government form.
The Parliament is led by the President which acts as head of the government and of the executive branch that is separate from the legislative branch. The President is usually elected by the Parliament, but there are forms of democracy that allows the President to be elected directly as well. To reform the constitution all parliamentarians are required to vote with a majority set to 2/3 of the parliament.
Due to the nature of the legislative form, the President cannot express any Veto Right to any motion. However, only the President can present motions to any matter of the state for the parliament to discuss. Obviously, the action and pressures of bigger parliamentarians groups often lead to a prompt motion by the President.
GOVERNMENTS – REPUBLIC
The Republic is a government whose authority is based on citizen voters, which are represented by elected or nominated officials chosen in free elections to be part of the Senate. The amount of seats is determined by the number of eligible voters and it is capped at 2,000 and a minimum of 50.
The most important figure of the Senate is the Chancellor which is elected directly from the Senate. After the election of the Chancellor, a majority is needed to rule and only the coalition of powers with the 50%+1 seats in total are able to govern and present motions. To reform the constitution the motion will have to be approved by 2/3 of the Senate.
If the coalitions presented prior to the election cannot win a majority the Chancellor can select a custom majority to rule during the term.

To select a custom majority the player shall flag the join coalition to all parties he wishes to involve until more than 50% of the Senate is reached.
GOVERNMENTS – FEDERATION
A Federation can be defined as a political organisation characterised by the union of small states, groups or parties, which are self-governed in internal affairs and are united under a central government. The division of power among the states and the central governing body is typically constitutionally entrenched.
A federal government having a constitutional structure that can be considered the opposite of a unitary state system. Because of that, these kinds of governments are usually very unstable. During elections, the number of seats is determined by the Federation strength and is uncapped with a minimum of 25 representatives.
Once the representatives are elected they will join one of the House of Representative's coalitions based on the population priorities. The coalitions with the majority of members usually lead the government policies with motions approved through a classic 50%+1 majority of the votes. The same applies to all reforms.
If no coalitions in the House can win a majority the President can select a custom majority to rule during the term only if such President is elected, not appointed. In case of an appointed President, the player shall form a government considering the majority of seats.
In example, if the pacifists represent the majority of seats, they will be in charge of forming a government with parties aligned closer to their goals rather than the military for instance.

To select a custom majority the player shall flag the join coalition to all parties he wishes to involve until more than 50% of the Senate is reached.
GOVERNMENTS – OLIGARCHY
Oligarchy is from the Greek term for “rule of the few.” It is a form of the power structure in which power effectively rests with a faction of persons or families. The people that form the ruling group are usually a group of distinguished people in terms of wealth or power who pass their influence from one generation to the next. This Elite group is the only one able to vote for the election of the Senate with a number of seats determined by the number of eligible voters.
An Oligarchy can exist till the majority supports its ideals. If this support ends, then a revolution may take place to replace the current government with a new a more democratic one.
There are 3 Oligarchies available:
- Monarchy
- Corporate
- Totalitarian
In the Monarchy a person, the Monarch, is head of state for life or until abdication. In most cases, the succession of monarchies is hereditary (Birthright), often building dynastic periods, however elective and self-proclaimed monarchies are possible. The political legitimacy and authority of the monarch may vary and can expand across the domains of the executive, legislative and judicial.
In the Corporate the government-run primarily like a business, involving a board of directors and executives, in which all aspects of society are privatised by a single or small groups of companies. The ultimate goal of this state is to increase the wealth of its shareholders, and the government acknowledges its status as a corporation. Utilities, including hospitals, schools, the military, and the police force, would be privatised. Social welfare is carried out by corporations in the form of pensions and benefits to employees, instead of the state.
In Totalitarianism, the concept is to prohibits opposition parties, restricts individual opposition to the state and its claims, and exercises an extremely high degree of control over public and private life. Political power has often been held by autocrats who employ all-encompassing campaigns in which propaganda is broadcast by state-controlled mass media along with extensive political repression, a complete lack of democracy, widespread personality cultism, absolute control over the economy, massive censorship, and mass surveillance.
Other aspects include the use of labour camps, fraudulent elections (if they take place), and possible possession of weapons of mass destruction.[/list]