Amazing work as usual!!
One question, do you know if it works with Openoffice? (instead libreoffice).
Thanks.
Firefox/Windows Defender reports this as potential malware, whereas other downloads related to Aurora do not. I do not know why it is reported as such, but I thought the original author would like to know why their utility isn't being used much... ;)
Noticed an error in the spread sheet.
Under Constitution, Police Power does not properly show what is required for different government forms. It *always* shows "Regulated or above". I checked the cell, and it just has that as a literal, while all of the others have code that dictates which it should display.
First of all thanks for this! It's a lot of fun and fixes the lack of any government flavor on the game.
Small bug - when there is a tie between two candidates (using Republican government) one of the two gets repeated on the chancellor election.
I also noticed the number of max seats is different from the senate election votes, not sure if this is a bug or not.
Finally, could you clarify if the winning chancellor should be considered before or after you change the CUT to None?
=IF(D4="Republic";"Regulated or above";IF(D4="Democracy";"Bound by Law";IF(D4="Federation";"Regulated or below";IF(D4="Corporate";"Internal Affairs";IF(D4="Totalitarian";"Unlimited";IF(D4="Monarchy";"Regulated or above";0))))))
=IF(D4="Republic";"State Controlled or above";IF(D4="Democracy";"Independent";IF(D4="Federation";"State Controlled or below";IF(D4="Corporate";"State Controlled";IF(D4="Totalitarian";"Martial Court or below";IF(D4="Monarchy";"State Controlled or above";0))))))
Small problem:
At the place of Required Police power (MN4) There is justly "Regulated or above". Nothing dependent on government type.
Here's the fix:Code: [Select]=IF(D4="Republic";"Regulated or above";IF(D4="Democracy";"Bound by Law";IF(D4="Federation";"Regulated or below";IF(D4="Corporate";"Internal Affairs";IF(D4="Totalitarian";"Unlimited";IF(D4="Monarchy";"Regulated or above";0))))))
I also found a little error in Required Justice system (MN5). At monarchy it said "State controlled or below", when in practice it requires State controlled or above, so i fixed it as well:Code: [Select]=IF(D4="Republic";"State Controlled or above";IF(D4="Democracy";"Independent";IF(D4="Federation";"State Controlled or below";IF(D4="Corporate";"State Controlled";IF(D4="Totalitarian";"Martial Court or below";IF(D4="Monarchy";"State Controlled or above";0))))))
Thanks, the first fix was included already a couple of posts above and on main topic.I really should have checked more posts than the first one before posting :p
Hey there. First - thank you for putting this together. It's been fun to play with (and occasionally frustrating as voters make some really interesting decisions!)
I don't know why it took me this long to realize this, but for people running for office there are 7 potential parties (Federalists, Pacifists, Trade, Nationalists, Militarists, Democrats, Republicans), but only 5 parties are represented in the legislature (Federalists, Pacifists, Trade, Nationalists, Militarists).
Is this intentional?
Noticed a bug where terrorist attacks were 'succeeding' but returning an error for the target. Digging into the second page, I found the problem was that my Federation Separatists were reading the target from the Totalitarian government's rebellion target line. This seems to be the case for every government type above Totalitarian on the sheet, which is most of them.
It's a simple fix - just change the E374 in the formula of the cell labeled "DAMAGE" to E"whatever row the cell is in" to make it read the target line for that government. Figured I'd report it in case anybody else stumbled across this behavior, or in case an update is ever made.
I've really enjoyed the extra texture this adds - it's nice to step back every few years and match up notable figures with parties. Even just considering how the party in power will change how things are run is neat even without the voting bits. Also a lot of fun when the party that held power for the first three election cycles lost to electoral fraud, but had pushed their agenda hard enough with legislation that the rebellion that lead me to post this was set off. The new guy had to manage low-odds defense of the Constitution to tamp down on the opposition while dealing with infrastructure and banks blowing up over the nascent colonies of my conventional start.