link to Home Page

Excel Spreadsheet

On the CNBC TV show "Topic A With Tina Brown," several months ago, Howard Dean had filled in for Tina Brown as guest host. His guest was Bev Harris, the Seattle grandmother who started www.blackboxvoting.org from her living room. Bev pointed out that regardless of how votes were tabulated (other than hand counts, only done in odd places like small towns in Vermont), the real "counting" is done by computers. Be they Diebold Opti-Scan machines, which read paper ballots filled in by pencil or ink in the voter's hand, or the scanners that read punch cards, or the machines that simply record a touch of the screen, in all cases the final tally is sent to a "central tabulator" machine. That central tabulator computer is a Windows-based PC.

"In a voting system," Harris explained to Dean on national television, "you have all the different voting machines at all the different polling places, sometimes, as in a county like mine, there's a thousand polling places in a single county. All those machines feed into the one machine so it can add up all the votes. So, of course, if you were going to do something you shouldn't to a voting machine, would it be more convenient to do it to each of the 4000 machines, or just come in here and deal with all of them at once?" Dean nodded in rhetorical agreement, and Harris continued. "What surprises people is that the central tabulator is just a PC, like what you and I use. It's just a regular computer." "So," Dean said, "anybody who can hack into a PC can hack into a central tabulator?"

Harris nodded affirmation, and pointed out how Diebold uses a program called GEMS, which fills the screen of the PC and effectively turns it into the central tabulator system. "This is the official program that the County Supervisor sees," she said, pointing to a PC that was sitting between them loaded with Diebold's software. Bev then had Dean open the GEMS program to see the results of a test election. They went to the screen titled "Election Summary Report" and waited a moment while the PC "adds up all the votes from all the various precincts," and then saw that in this faux election Howard Dean had 1000 votes, Lex Luthor had 500, and Tiger Woods had none. Dean was winning. "Of course, you can't tamper with this software," Harris noted. Diebold wrote a pretty good program. But, it's running on a Windows PC.

So Harris had Dean close the Diebold GEMS software, go back to the normal Windows PC desktop, click on the "My Computer" icon, choose "Local Disk C:," open the folder titled GEMS, and open the sub-folder "LocalDB" which, Harris noted, "stands for local database, that's where they keep the votes." Harris then had Dean double-click on a file in that folder titled "Central Tabulator Votes," which caused the PC to open the vote count in a database program like Excel. In the "Sum of the Candidates" row of numbers, she found that in one precinct Dean had received 800 votes and Lex Luthor had gotten 400. "Let's just flip those," Harris said, as Dean cut and pasted the numbers from one cell into the other. "And," she added magnanimously, "let's give 100 votes to Tiger." They closed the database, went back into the official GEMS software "the legitimate way, you're the county supervisor and you're checking on the progress of your election." As the screen displayed the official voter tabulation, Harris said, "And you can see now that Howard Dean has only 500 votes, Lex Luthor has 900, and Tiger Woods has 100." Dean, the winner, was now the loser.

Harris sat up a bit straighter, smiled, and said, "We just edited an election, and it took us 90 seconds." On live national television. (You can see the clip on www.votergate.tv.) And they had left no tracks whatsoever, Harris said, noting that it would be nearly impossible for the election software – or a County election official - to know that the vote database had been altered.