Post reply

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: Aloriel
« on: Yesterday at 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. :)
Posted by: Froggiest1982
« on: Yesterday at 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.
Posted by: Aloriel
« on: Yesterday at 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: Yesterday at 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.
Posted by: Froggiest1982
« on: Yesterday at 04:57:49 PM »

Quote from: Aloriel on Yesterday at 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.

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: Yesterday at 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.
Posted by: nuclearslurpee
« on: June 13, 2025, 08:03:23 PM »

Quote from: Zap0 on June 13, 2025, 06:48: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?  ;D
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...
Posted by: Froggiest1982
« on: June 13, 2025, 05:47:52 PM »

Quote from: Zap0 on June 13, 2025, 09:22:43 AM
Quote from: Froggiest1982 on June 13, 2025, 07:23:50 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.

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 »

Quote from: Froggiest1982 on June 13, 2025, 07:23:50 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 »

Quote from: 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.

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.
Posted by: Froggiest1982
« on: June 12, 2025, 11:48:12 PM »

Released here https://aurora2.pentarch.org/index.php?topic=13639.msg171363#msg171363 or at the top of this discussion.

Please thank on the main post, not here.
Posted by: Froggiest1982
« on: June 07, 2025, 07:39:31 PM »

Quote from: Tall Guy (Acc. Pend.) on June 07, 2025, 04:31:14 PM
I'm a new player.

Do you think I should be patient, or should I jump into your older one for now to learn the ropes and get some of that sweet, sweet roleplay satisfaction?

The older one is a perfectly functioning and tested program with a full set of written rules, and it is highly recommended as a start. Furthermore, it will facilitate your first playthrough as soon as I can get around release rules and the file of the new version.

I am unsure though if after the big forum reset the file it's still available for download.
Posted by: Tall Guy (Acc. Pend.)
« on: June 07, 2025, 04:31:14 PM »

I'm a new player.

Do you think I should be patient, or should I jump into your older one for now to learn the ropes and get some of that sweet, sweet roleplay satisfaction?