Talk:Summability criterion: Difference between revisions

Send a copy of sheet2 to Central Counting. Can’t be more than all 1000 rows, right? Unlikely that every odd combination of preferences will occur in a meaningful election. But with 10 candidates x 4 choices x 2 operators (= or >) between each, how many is that? Take a reasonably limited US presidential election (say 40 candidates, pick your top 10). How many different voting combinations will that actually come out to in each ballot box? In total? Five million is my spreadsheet's limit.

Central Counting imports/copies/pastes all precinct sheet2’s into their own spreadsheet sheet1. Make sheet2, putting =unique() formula in column A, and sumif() in column B for all the rows arriving from the precincts in sheet1. For rollups to state and national type levels, Central Counting sends their sheet2s for merginga similar merge at those higher levels. At the level of decision, copy columns A and B into a vote counter with enough rows to handle the actual number of voting combinations.