Elections

2020 Board Election Results

After final tally.

8/24/2020

Results sent 14 days after election

Setting up Survey Monkey Ballot • Login to Survey Monkey and in the search bar type in “Board of Trustees”. o This search will bring up the previous year’s survey. o Make a copy of this survey and rename to match current year. • Begin editing the survey with updated candidate information and dates. • Double Check that the Web Link is correct. It is currently: o https://www.surveymonkey.com/r/OMABoard o You will use this link in all election emails and on the website. Results Spreadsheet Template on the shared drive under Elections > 2019 Board Election > 2019 Election Results What you’ll need: • Compiled list of all voting members who received the ballot • Exported spreadsheet from Survey Monkey with the election results Instructions: • Once you pull the raw data from Survey Monkey and open it in Excel, rename the tab with the initial export data to “Raw Data.” (You need to keep the raw data.) • Create a copy of the “Raw Data” tab and call it “Election Results.” This will be your working file. • Create a new tab and call it “Summary.” • Open your compiled list of all voting members. In the “Election Results” tab, insert a new column A. Do a V-lookup to match voting member ID numbers with the ID numbers typed into the ballot. Remove any results with an invalid ID number. Then go through the votes and remove any blank votes. Then remove duplicate ID numbers. o Note: In your “Summary” tab, make note of total votes, ineligible votes removed, and blank votes removed to calculate your total eligible votes.

• In the “Election Results” tab, go through each column and filter for the name of each candidate. Keep track of the number of votes for each candidate by position in the “Summary” tab.