Cal Posted November 10, 2021 Share Posted November 10, 2021 7 minutes ago, MrPotatoTed said: My crowning achievement of the day: I've figured out how to pair VLOOKUP with COUNTIF functions, to automatically check if a governor candidate has both Celebrity "and" military leader, which earns them a +1 in elections. My goal today is to finish the Governor elections, which has been the most complicated section so far. I've learned like twenty different new excel skillsets just for this one task. But once that's done, 95% of it should be copy/paste for the Senate elections and House elections tabs. Do you intend to try and automate any of the legislative vote shifting stuff? Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 10, 2021 Author Share Posted November 10, 2021 21 minutes ago, Cal said: Do you intend to try and automate any of the legislative vote shifting stuff? I already have -- kind of. I've got the Senate and House tabs set up to automatically display the relevant traits for each politician. I'll still have to roll the dice for each one (dice rolls can be automated too, but not in the way I want them to be), but it's better than looking up every politician that has debate across all ten factions, and then every politician that has puritan across all ten factions, and then every politician that has integrity... Now it's all on one page, which should speed it up considerably. 2 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 GOVERNOR ELECTIONS ARE DONE! There are 41 variables in the Governor elections. Players will only need to input two for each state's race: their candidate's name, and how many terms they've previously served as governor. I only need to manually input 12: mostly die rolls and inputting the results of various multivariable checks (which I can calculate in my head at a glance). The other 27 variables are fully automated now, all on a single page! 1 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 SENATE ELECTIONS ARE DONE! (I'll "hide" the states that don't have any senate elections in the given phase during election time). 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 REPRESENTATIVE ELECTIONS ARE DONE! I hope. These were a little more complicated because there's so many of them, but I "think" they're done. We'll take a closer look during the election, to make sure there are no errors. 2 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 Started working on Presidential elections, but it'll be a while before we actually need it and Friday (the day we resume the game) is right around the corner. So I'm going to focus my remaining time on seeing if I can autocalculate the outcomes of various laws, how many points each faction gets, etc. 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 Proof of concept on calculating the outcomes of a law is done -- I've created a tab called Calculating scores, which has calculated the outcome of the new Constitutional Amendment (if it passes). That one was pretty easy though since it was just one law. Working now to calculate a package of multiple laws at once. 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 17 minutes ago, MrPotatoTed said: Proof of concept on calculating the outcomes of a law is done -- I've created a tab called Calculating scores, which has calculated the outcome of the new Constitutional Amendment (if it passes). That one was pretty easy though since it was just one law. Working now to calculate a package of multiple laws at once. It works! 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 11, 2021 Author Share Posted November 11, 2021 Ok, I've got all of the recently passed packages automatically calculating, awarding point totals based on what cards people have. It doesn't factor in things like state industries, I'll probably just do that manually. In fact, other than Presidential elections, I think I might have everything to the point that I can probably do the rest manually. I'll still continue to add automation as needed -- basically, if any phase is still taking me more than 30 minutes to process, that's a phase I'll focus on automating further. But for now, my plan is: 1) Clean up the Senate/House/Governor election page. This shouldn't take me long, can definitely do today after my daughter's swim class. 2) Start playing the game again! The points are already calculated, I just need to process the outcome of the state ratification and then the meter outcomes and industry stuff for our new laws. I should be able to complete this tonight, and then action will be to @Cal to consider Executive Actions. 3) As I have free time, I'll work on the Presidential election automation. 4) Just ad-hoc whack-a-mole, as we discover issues in need of automation, I'll create it. 1 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 12, 2021 Author Share Posted November 12, 2021 3 hours ago, MrPotatoTed said: 1) Clean up the Senate/House/Governor election page. This shouldn't take me long, can definitely do today after my daughter's swim class. Complete! 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 12, 2021 Author Share Posted November 12, 2021 Added "Pliable" and "Manipulative" flags on the Executive tab because they're needed during legislation signing. 1 Quote Link to comment Share on other sites More sharing options...
MrPotatoTed Posted November 12, 2021 Author Share Posted November 12, 2021 For my to-do list, after I finish the presidential election automation: find a way to include industry point gains when autocalculating points from legislative packages. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.