looks like I cannot upload xls format to this forum! so you will just get screen shots.
Two examples. Both have 1000 votes.
Team A has 500 votes cast (unique ID 1-500).
Team B has 500 votes cast (unique ID 501 - 1000).
Each vote record is assigned to a table depending on who the vote is cast for. Team A and Team B.
Each vote record = one line in the table + unique vote ID.
The "Weighted" example show that if a SUM formula, the system still counts all 1000 votes but the Sum Total is 400 for A and 600 for B.
If a record COUNT formula is used then system counts the entries and returns 500 votes each. Formula slight of hand!
The number of vote records in the system remains unchanged but the results are different.
This allows the results to pass the first question of the audit "Do the total number of votes cast equal the combined total of Team A + Team B in the system."
BUT it fails the second question of an actual hand count of the paper ballots. Oddly, it is for this reason that the US has paper ballots along side electronic voting. They needed a way to audit electronic voting machines to prove they are working correctly.
Is it possible of to build a voting system like this or exploit a system to work like this to rig the vote? Yes
Is it likely this is what we have seen happen wide scale in the States? unlikely. The s/w was audited and a hand count carried out. Plus the usual tamper seals etc.
Just because some thing is low risk and has a low chance of happening does not mean it cannot happen or will never happen.
No one on this forum is part of Dominion and privy to their s/w architecture, so there is going to be a lot of speculation on how their system works, but there is a very good reason why their systems have tamper seals on them and why they audit the s/w on a regular basis. Can anyone guess why they protect their systems from being tampered with?