Posted by: watchers78
« on: July 23, 2025, 12:24:31 PM »thanks .
Posted by: Froggiest1982
« on: July 22, 2025, 03:29:20 PM »My friend, I'm new to the game and trying to learn this amazing game. Is this government simulator a mod, a cheat, or a new feature added to the game?
Hi, simply put, 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.
It is a spreadsheet that works with Libre Office or, as some have reported, but I have not tested Open Office.
I would recommend you get familiar with the game before thinking of using this file.
Posted by: watchers78
« on: July 22, 2025, 11:47:52 AM »My friend, I'm new to the game and trying to learn this amazing game. Is this government simulator a mod, a cheat, or a new feature added to the game?
Posted by: Aloriel
« on: June 16, 2025, 07:48:47 PM »It's possible. I was just hitting F9 until the specific situation arose. In my actual gameplay, I've only copied when it was a valid election.
Weird that the majority system causes there to be more seats. Anyway, good that it's WAI.
Weird that the majority system causes there to be more seats. Anyway, good that it's WAI.
Posted by: Froggiest1982
« on: June 16, 2025, 06:56:35 PM »Yes, you are correct and currently it's WAI.
The rationale is to avoid extra seats to be assigned as I had instances where of the 311 seats you may ended up with 314. In all my tests the ROUNDDOWN always created less discrepancies than the ROUNDUP with results similar to yours usually happens only when a high spoil amount of votes are present.
In your case, If you scroll down to the Majority of the House section in the Government Federation calculation, you will see that the Majority has a ROUNDDOWN formula, effectively correcting the "missing" seats. Other governments have instead a ROUNDUP majority, based on the rest of the formulas.
You can change to a ROUNDUP formula for your own sheet, and if so you may end up with elected seats being higher than the maximum amount of seats, which is not a biggie. However, I would recommend though that you also change the Majority of the House formula to the ROUNDUP version and amend for the extra not accounted seats.
As all calculations happen at the Government Federation sheet level, the Majority number in the ELECT page can be considered only a "Visual" bug and since that entry is manual, you can enter the effective right number without compromising anything.
EDIT: Please remember to copy only GREEN elections in there, as I have a feeling you copied a RED one in the file.
The rationale is to avoid extra seats to be assigned as I had instances where of the 311 seats you may ended up with 314. In all my tests the ROUNDDOWN always created less discrepancies than the ROUNDUP with results similar to yours usually happens only when a high spoil amount of votes are present.
In your case, If you scroll down to the Majority of the House section in the Government Federation calculation, you will see that the Majority has a ROUNDDOWN formula, effectively correcting the "missing" seats. Other governments have instead a ROUNDUP majority, based on the rest of the formulas.
You can change to a ROUNDUP formula for your own sheet, and if so you may end up with elected seats being higher than the maximum amount of seats, which is not a biggie. However, I would recommend though that you also change the Majority of the House formula to the ROUNDUP version and amend for the extra not accounted seats.
As all calculations happen at the Government Federation sheet level, the Majority number in the ELECT page can be considered only a "Visual" bug and since that entry is manual, you can enter the effective right number without compromising anything.
EDIT: Please remember to copy only GREEN elections in there, as I have a feeling you copied a RED one in the file.
Posted by: Aloriel
« on: June 16, 2025, 05:33:48 PM »Also, I'm pretty sure the issue is that all of these entries need to be ROUNDUP not ROUNDDOWN
Posted by: Aloriel
« on: June 16, 2025, 05:25:09 PM »Ahh crap. How'd that happen? LOL
Unfortunately, since I know a few things about spreadsheets, I've made a few modifications to mine now. Before I did so, I made a copy of your original. I'll just fire it up and get some sample values in there for you.
Et voila...
I have double checked to make sure the file is *actually* in there this time.
You may have to hit F9 a few times for the error to trigger. You can see a copy/paste of data that failed in the usual row you want us to paste to.
Unfortunately, since I know a few things about spreadsheets, I've made a few modifications to mine now. Before I did so, I made a copy of your original. I'll just fire it up and get some sample values in there for you.
Et voila...
I have double checked to make sure the file is *actually* in there this time.
You may have to hit F9 a few times for the error to trigger. You can see a copy/paste of data that failed in the usual row you want us to paste to.
Posted by: Froggiest1982
« on: June 16, 2025, 04:57:49 PM »Got a minor bug. My election results have 311 seats, but claims a majority is 155. I think it's rounding down here, when it should be rounding up.
Turned out alright anyway, since my majority is 159 seats.
File included, just in case it helps. Yes, my government was dissolved for this election.
thanks Sarah. The file attached is empty, can you please modify your message and re upload?
I think I know why that happened, but I would like to double check it.
Posted by: Aloriel
« on: June 16, 2025, 09:37:14 AM »Got a minor bug. My election results have 311 seats, but claims a majority is 155. I think it's rounding down here, when it should be rounding up.
Turned out alright anyway, since my majority is 159 seats.
File included, just in case it helps. Yes, my government was dissolved for this election.
Turned out alright anyway, since my majority is 159 seats.
File included, just in case it helps. Yes, my government was dissolved for this election.
Posted by: nuclearslurpee
« on: June 13, 2025, 08:03:23 PM »Now to go and model the intricate federal democracy of the Interstellar League...
Overly complicated dozen-power AAR that breaks the game in increasingly improbable ways when?
Posted by: Zap0
« on: June 13, 2025, 06:48:23 PM »Thanks, the prepopulated file displays and works fine, and elections run with F9.
Now to go and model the intricate federal democracy of the Interstellar League...
Now to go and model the intricate federal democracy of the Interstellar League...
Posted by: Froggiest1982
« on: June 13, 2025, 05:47:52 PM »EDIT: Try to populate with 0 (Zero) the Leader's Point/Funds
That had no effect.
Could it be different windows locale/date formats or windows system page? I've got mine set to Japanese because the indie devs there seem permanently stuck 20 years behind in technology...
Edit: I've checked the previous version, the file you have on download there does not cause this behavior with me. So it has to be something that changed in the new iteration.
I have used a prepopulated version and it seems like everything works fine now.
I have uploaded the new file on the main post.
Posted by: Zap0
« on: June 13, 2025, 09:22:43 AM »EDIT: Try to populate with 0 (Zero) the Leader's Point/Funds
That had no effect.
Could it be different windows locale/date formats or windows system page? I've got mine set to Japanese because the indie devs there seem permanently stuck 20 years behind in technology...
Edit: I've checked the previous version, the file you have on download there does not cause this behavior with me. So it has to be something that changed in the new iteration.
Posted by: Froggiest1982
« on: June 13, 2025, 07:23:50 AM »I'm getting lots of division by zero errors in fields. Do I need to fill something before the sheet works? I've followed your main posts instructions on what to fill in what order so far.
F9 does nothing. Is there no info/feedback on that? Do I need to enable/register macros? Am I right that a dialog should pop up and give me values to copy/paste?
Tried in LibreOffice 7 and 25.
That's a bit weird, I am out atm so cannot double check, I will do it later and see if somehow the file got corrupted.
Any other having same issue please let me know.
EDIT: Try to populate with 0 (Zero) the Leader's Point/Funds
Posted by: Zap0
« on: June 13, 2025, 06:34:35 AM »I'm getting lots of division by zero errors in fields. Do I need to fill something before the sheet works? I've followed your main posts instructions on what to fill in what order so far.
F9 does nothing. Is there no info/feedback on that? Do I need to enable/register macros? Am I right that a dialog should pop up and give me values to copy/paste?
Tried in LibreOffice 7 and 25.
F9 does nothing. Is there no info/feedback on that? Do I need to enable/register macros? Am I right that a dialog should pop up and give me values to copy/paste?
Tried in LibreOffice 7 and 25.
