24
TCN PROFESSIONAL JOURNAL FALL 2021
Several notes on the spreadsheet :
• The item being voted on is entered in cell A1
• The name / title is entered in cell A2
• The potential voters ’ names are formatted in an Excel Table
■ Names can be manually entered one by one , or copied and pasted into the table
■ The table will automatically expand as more names are added
■ The table will alternate row shading to make entering / viewing data easier
■ As new names are entered , columns are added for “ Vote ” and “ How Recd ”
■ Note : row colors displayed can be changed by clicking the Home tab on the Ribbon and then clicking the Styles section
• Once all names are entered , the sheet will count the number of names and display that value in Cell B3 ( Count of potential voters )
• The sheet will tabulate the number of votes needed ( simple majority of 50 % + 1 ) and display in Cell C2
■ A formula is used to calculate the value = IF ( ISEVEN ( B3 ),( B3 / 2 + 1 ), B3 / 2 )
◆ The IF () function will evaluate the expression ( ISEVEN ( B3 ) to determine if it is an even number
◆ If the number is even , the formula will divide the number by 2 and add one to the result ( 24 / 2 )= 12 + 1 = 13
◆ If the result of ( ISEVEN ( B3 ) is an odd number , the formula will divide the number by 2
◆ Cell C2 is formatted to only display whole numbers
■ In this example there are 24 voters , so Cell C2 is 13 ( 24 / 2 + 1 )
• Votes are recorded on the line next to the voter ’ s name as they are received
■ The “ VoteOptions ” tab shows the only allowable entries for the “ Vote ” column . In this example the options are “ Yes ”, “ No ”, or “ Abstain ”, however , these can be customized based on the vote .
■ Data Validation is used to allow only these entries . In all cells where a vote can be recorded , a dropdown arrow appears next to the cell :
◆ Value options are displayed when the dropdown is clicked
◆ Values can be typed directly into the cell , or selected from the list ; if anything other than an allowable value is entered , the error box appears
• In the case of a “ Yes ” vote from April :
■ Cell C3 counts and records the “ Yes ” vote
■ Cell A5 shows that 4 % of voters have responded ( 1 total vote out of the potential 23 voters )
■ Cell E3 shows that 100 % of the votes “ Yes ” since only one vote has been received
• Once 12 “ Yes ” votes are received , the formula in cell B4 changes from “ Results Pending ” to “ APPROVED ”