MrPotatoTed Posted November 1, 2021 Share Posted November 1, 2021 @vcczar @DakotaHale @ConservativeElector2 @Cal @jvikings1 @Hestia @Rezi @Rodja Hi guys -- I've been working to automate the excel sheet wherever possible. My excel skills are nil, I have no training -- but I'm teaching myself how to do it. My hope is that successfully automating so many functions in the excel sheet will make even the most complicated processes such as the legislative and elections super easy for all of us. Less work for you, less work for me, and therefore less burnout and more focusing on just having fun and providing useful feedback for the playtest. To that end, this will be a running progress report on what I've taught myself how to do, what I've achieved with those new skills, and what I still want/need to do. Last night, I taught myself the SUM function and its many uses. That's probably Excel 101 for all of you, but I never took Excel 101 so that's where I started. After successfully getting that done, I taught myself how to calculate and pull Sums from faction pages and display that information on different pages (such as how many times the word "Senator" or "Rep" appears on your politicians' job titles. That was a major hurdle that I'm super excited to have figured out, and will be very useful. My biggest remaining hurdle that will make the entire game 100% easier for everybody is figuring out how to create a drop-down list for politician names (where typing the first few letters will give you the politician's name) and then it autopopulates the relevant data on the sheet, like whether they have traits that impact their election odds. I don't think I'm ready for that level yet though, so I'm going to finetune my skills first by automating everything that I can on every page. Step one: I'll complete all of the "low hanging fruit" (the items I now already know how to do or can easily learn now). Step two: I'll learn how and then implement the "high effort/high reward" stuff that will save us huge amounts of time like the drop down thing where we won't have to keep looking up data for each individual politician anymore. Step three: Automating the rest of it -- stuff that won't necessarily save us significant time or be easy to do, but by the time I complete step two, I should have the skills to knock it out. Progress so far: MAIN TAB - Complete: Automatically generating # of Senate and House votes for each faction, automatically generating # of Senate and House votes for each party. - Short term To-Do: Automatically generate # of Governors for each faction and party (I know how to do this, will complete it momentarily. - Long term To-Do (Step Three): Automatically generate the ideologies, special interests, and lobbies. 4 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.