Talk:Summability criterion: Difference between revisions

Content deleted Content added
Line 41: Line 41:
Record the votes.
Record the votes.
Get from the ballot box to the spreadsheet somehow. Convert candidate names to identifiers. Save the ballots for audit.
Get from the ballot box to the spreadsheet somehow. Convert candidate names to identifiers. Save the ballots for audit.

Sheet1: Enter votes in column A as 7 characters (A>B=D>C) for up to 1000 rows
Sheet1: Enter votes in column A as 7 characters (A>B=D>C) for up to 1000 rows

Sheet2: enter formula in cell A1 =Unique(A1:A1000),and enter formula in B1:B1000 =countif(sheet1!a1:a1000,a1)
Sheet2: enter formula in cell A1 =Unique(A1:A1000),and enter formula in B1:B1000 =countif(sheet1!a1:a1000,a1)