HAVA Look: A Simple, Verifiable Open Source Voting System

http://www.geocities.com/electionmodel/HAVAOnePC.htm

Currently being discussed at:
http://www.democraticunderground.com/discuss/duboard.php?az=view_all&address=203x505612

TruthIsAll

Thanks to HAVA, elections are vulnerable to multiple vote miscounts: at the precinct level with closed-source, diverse, proprietary code-based touch screens (DREs) and Optical scanners and then on closed-source, proprietary Central Tabulators. They have you coming and going.

On the other hand, paper ballots can easily be input to a standard personal computer spreadsheet. Voters can request a copy before leaving the precinct. The precinct (spreadsheet) file is uploaded to the Internet. The voter can quickly and easily verify his vote as the spreadsheet ballot records are sorted by a unique Precinct/Ballot ID code. At the same time, he can view and/or download the total precinct ballots to verify the vote counts. Consolidation of district/county/state vote counts is tabulated by Open Source software.

Three (3) volunteers input and verify the paper ballots. As Volunteer A reads the ballot, B enters the data and C verifies the result. Data entry would be completed shortly after the polls closed. The voter fills out a ballot marking each selected candidate's code (i.e. a=Dem, b=Rep, c=Ind). The volunteers use their god-given optical scanners (EYES) to read the ballots and enter the codes in a spreadsheet. As each code is entered, the spreadsheet automatically calculates the total vote and percentage for each candidate.

The following simple steps complete the process: 1) Print the spreadsheet (1 minute). 2) Upload it to the Internet (10 seconds) so anyone can check the precinct results. 3) Upload the sheet to the Central Tabulator (10 seconds). The published totals should match the precinct totals on the Internet and the local PC.

There are approximately 200,000 precincts nationwide, an average of 4,000 per state. How much would it cost and how long would it take to process and count the votes in an average precinct of 600 voters? Just one (1) $400 Personal Computer is used for ballot data entry; $100 Printer; $100 spreadsheet. Assuming that data entry/verification takes 1 minute per voter, total data entry time would be 600 minutes (10 hours), whiich can be spread out over 12 hours on Election Day. Larger precincts could install additional PCs and add volunteers as necessary. The individual PC spreadsheets would be combined into a single file ( sorted by voter ID) for uploading to the Internet.

There are many advantages over the current, vulnerable system. HAVA look:

Data redundancy:
1) Original paper ballots: retained in a secure location
2) Precinct spreadsheet files: ballots sorted by voter ID
3) Internet: copies of uploaded precinct files for online viewing/download
4) Internet: County/state composite files (vote totals sorted by precinct/county) for online viewing

Data / software integrity:
1) Original paper ballots: documented chain of custody
2) Data integrity (100% automatic audit to catch discrepancies between the local precinct spreadsheet and corresponding internet file
3) Open Source code: eliminate proprietary code on DRE/ Optiscan/ central tabulator

Eliminate corrupting influence of vendors and election officials:
1) Hardware: Eliminate bribery of election officials for purchase of DREs and optical scanners
2) Diebold/Premier & ES&S out of the DRE/Opscan voting machine business

A Simple Precinct Spreadsheet Vote Recorder

Example:
Precinct 101 (500 voters)
Party Code: a=Dem, b=Rep, c=Ind
Voter Ballot Code: 101xxxxxx

Note: Totals are calculated using the Excel function: COUNTIF (range, party code).
For example, the total number of Democratic (column B, rows 10-509) votes for president:
242 =COUNTIF (b10.b509,”a”)

Download this sample Excel precinct file
A challenge: try to corrupt the data.
Lot's of luck:

http://www.geocities.com/electionmodel/HandCountedSecureExcel.xls

[code]



PRECINCT 101

Code a=Dem, b=Rep, c=Ind
VoterCode Pres Senate Congress Other1 Other2 Other3 Other4 Other5 Other6 Other7 Other8
Totals
Democrat 242 233 252 242 233 252 242 233 252 242 233
Republican 234 244 225 234 244 225 234 244 225 234 244
Independent 24 23 23 24 23 23 24 23 23 24 23

1010001 a a a a a a a a a a a
1010002 a a a a a a a a a a a
1010003 a a a a a a a a a a a
1010004 b b b b b b b b b b b
1010005 b b b b b b b b b b b
1010006 a a a a a a a a a a a
1010007 a a a a a a a a a a a
1010008 b b b b b b b b b b b
1010009 b b b b b b b b b b b
1010010 b b b b b b b b b b b
1010011 b b b b b b b b b b b
1010012 a a a a a a a a a a a
1010013 c c c c c c c c c c c
1010014 a a a a a a a a a a a
1010015 a a a a a a a a a a a
1010016 a a a a a a a a a a a
1010017 b b b b b b b b b b b
1010018 b b b b b b b b b b b
1010019 b b b b b b b b b b b
1010020 a a a a a a a a a a a
1010021 b b b b b b b b b b b
1010022 a a a a a a a a a a a
1010023 b b b b b b b b b b b
1010024 a a a a a a a a a a a
1010025 a a a a a a a a a a a
1010026 a a a a a a a a a a a
1010027 b b b b b b b b b b b
1010028 b b b b b b b b b b b
1010029 a a a a a a a a a a a
1010030 a a a a a a a a a a a
1010031 b b b b b b b b b b b
1010032 b b b b b b b b b b b
1010033 b b b b b b b b b b b
1010034 b b b b b b b b b b b
1010035 a a a a a a a a a a a
1010036 c c c c c c c c c c c
1010037 a a a a a a a a a a a
1010038 a a a a a a a a a a a
1010039 a a a a a a a a a a a
1010040 b b b b b b b b b b b
1010041 b b b b b b b b b b b
1010042 b b b b b b b b b b b
1010043 a a a a a a a a a a a
1010044 b b b b b b b b b b b
1010045 a a a a a a a a a a a
1010046 b b b b b b b b b b b
1010047 a a a a a a a a a a a
1010048 a a a a a a a a a a a
1010049 a a a a a a a a a a a
1010050 b b b b b b b b b b b
1010051 b b b b b b b b b b b
1010052 a a a a a a a a a a a
1010053 a a a a a a a a a a a
1010054 b b b b b b b b b b b
1010055 b b b b b b b b b b b
1010056 b b b b b b b b b b b
1010057 b b b b b b b b b b b
1010058 a a a a a a a a a a a
1010059 c c c c c c c c c c c
1010060 a a a a a a a a a a a
1010061 a a a a a a a a a a a
1010062 a a a a a a a a a a a
1010063 b b b b b b b b b b b
1010064 b b b b b b b b b b b
1010065 b b b b b b b b b b b
1010066 a a a a a a a a a a a
1010067 b b b b b b b b b b b
1010068 a a a a a a a a a a a
1010069 b b b b b b b b b b b
1010070 a b a a b a a b a a b
1010071 a b a a b a a b a a b
1010072 a b a a b a a b a a b
1010073 b b a b b a b b a b b
1010074 b b a b b a b b a b b
1010075 a b a a b a a b a a b
1010076 a b a a b a a b a a b
1010077 b b a b b a b b a b b
1010078 b b a b b a b b a b b
1010079 b b a b b a b b a b b
1010080 b b a b b a b b a b b
1010081 a b a a b a a b a a b
1010082 c b a c b a c b a c b
1010083 a b a a b a a b a a b
1010084 a b a a b a a b a a b
1010085 a b a a b a a b a a b
1010086 b b a b b a b b a b b
1010087 b b a b b a b b a b b
1010088 b b a b b a b b a b b
1010089 a a a a a a a a a a a
1010090 b b b b b b b b b b b
1010091 a a a a a a a a a a a
1010092 b b b b b b b b b b b
1010093 a a a a a a a a a a a
1010094 a a a a a a a a a a a
1010095 a a a a a a a a a a a
1010096 b b b b b b b b b b b
1010097 b b b b b b b b b b b
1010098 a a a a a a a a a a a
1010099 a a a a a a a a a a a
1010100 b b b b b b b b b b b
1010101 b b b b b b b b b b b
1010102 b b b b b b b b b b b
1010103 b b b b b b b b b b b
1010104 a a a a a a a a a a a
1010105 c c c c c c c c c c c
1010106 a a a a a a a a a a a
1010107 a a a a a a a a a a a
1010108 a a a a a a a a a a a
1010109 b b b b b b b b b b b
1010110 b b b b b b b b b b b
1010111 b b b b b b b b b b b
1010112 a a a a a a a a a a a
1010113 b b b b b b b b b b b
1010114 a a a a a a a a a a a
1010115 b b b b b b b b b b b
1010116 a a a a a a a a a a a
1010117 a a a a a a a a a a a
1010118 a a a a a a a a a a a
1010119 b b b b b b b b b b b
1010120 b b b b b b b b b b b
1010121 a a a a a a a a a a a
1010122 a a a a a a a a a a a
1010123 b b b b b b b b b b b
1010124 b b b b b b b b b b b
1010125 b b b b b b b b b b b
1010126 b b b b b b b b b b b
1010127 a a a a a a a a a a a
1010128 c c c c c c c c c c c
1010129 a a a a a a a a a a a
1010130 a a a a a a a a a a a
1010131 a a a a a a a a a a a
1010132 b b b b b b b b b b b
1010133 b b b b b b b b b b b
1010134 b b b b b b b b b b b
1010135 a a a a a a a a a a a
1010136 b b b b b b b b b b b
1010137 a a a a a a a a a a a
1010138 b b b b b b b b b b b
1010139 a a a a a a a a a a a
1010140 a a a a a a a a a a a
1010141 a a a a a a a a a a a
1010142 b b b b b b b b b b b
1010143 b b b b b b b b b b b
1010144 a a a a a a a a a a a
1010145 a a a a a a a a a a a
1010146 b b b b b b b b b b b
1010147 b b b b b b b b b b b
1010148 b b b b b b b b b b b
1010149 b b b b b b b b b b b
1010150 a a a a a a a a a a a
1010151 c c c c c c c c c c c
1010152 a a a a a a a a a a a
1010153 a a a a a a a a a a a
1010154 a a a a a a a a a a a
1010155 b b b b b b b b b b b
1010156 b b b b b b b b b b b
1010157 b b b b b b b b b b b
1010158 a a a a a a a a a a a
1010159 b b b b b b b b b b b
1010160 a a a a a a a a a a a
1010161 b b b b b b b b b b b
1010162 a a a a a a a a a a a
1010163 a a a a a a a a a a a
1010164 a a a a a a a a a a a
1010165 b b b b b b b b b b b
1010166 b b b b b b b b b b b
1010167 a a a a a a a a a a a
1010168 a a a a a a a a a a a
1010169 b b b b b b b b b b b
1010170 b b b b b b b b b b b
1010171 b b b b b b b b b b b
1010172 b b b b b b b b b b b
1010173 a a a a a a a a a a a
1010174 c c c c c c c c c c c
1010175 a a a a a a a a a a a
1010176 a a a a a a a a a a a
1010177 a a a a a a a a a a a
1010178 b b b b b b b b b b b
1010179 b b b b b b b b b b b
1010180 b b b b b b b b b b b
1010181 a a a a a a a a a a a
1010182 b b b b b b b b b b b
1010183 a a a a a a a a a a a
1010184 b b b b b b b b b b b
1010185 a a a a a a a a a a a
1010186 a a a a a a a a a a a
1010187 a a a a a a a a a a a
1010188 b b b b b b b b b b b
1010189 b b b b b b b b b b b
1010190 b b b b b b b b b b b
1010191 a a a a a a a a a a a
1010192 b b b b b b b b b b b
1010193 a a a a a a a a a a a
1010194 b b b b b b b b b b b
1010195 a a a a a a a a a a a
1010196 a a a a a a a a a a a
1010197 a a a a a a a a a a a
1010198 b b b b b b b b b b b
1010199 b b b b b b b b b b b
1010200 a a a a a a a a a a a
1010201 a a a a a a a a a a a
1010202 b b b b b b b b b b b
1010203 b b b b b b b b b b b
1010204 b b b b b b b b b b b
1010205 b b b b b b b b b b b
1010206 a a a a a a a a a a a
1010207 c c c c c c c c c c c
1010208 a a a a a a a a a a a
1010209 a a a a a a a a a a a
1010210 a a a a a a a a a a a
1010211 b b b b b b b b b b b
1010212 b b b b b b b b b b b
1010213 b b b b b b b b b b b
1010214 a a a a a a a a a a a
1010215 b b b b b b b b b b b
1010216 a a a a a a a a a a a
1010217 b b b b b b b b b b b
1010218 a a a a a a a a a a a
1010219 a a a a a a a a a a a
1010220 a a a a a a a a a a a
1010221 b b b b b b b b b b b
1010222 b b b b b b b b b b b
1010223 a a a a a a a a a a a
1010224 a a a a a a a a a a a
1010225 b b b b b b b b b b b
1010226 b b b b b b b b b b b
1010227 b b b b b b b b b b b
1010228 b b b b b b b b b b b
1010229 a a a a a a a a a a a
1010230 c c c c c c c c c c c
1010231 a a a a a a a a a a a
1010232 a a a a a a a a a a a
1010233 a a a a a a a a a a a
1010234 b b b b b b b b b b b
1010235 b b b b b b b b b b b
1010236 b b b b b b b b b b b
1010237 a a a a a a a a a a a
1010238 b b b b b b b b b b b
1010239 a a a a a a a a a a a
1010240 b b b b b b b b b b b
1010241 a a a a a a a a a a a
1010242 a a a a a a a a a a a
1010243 a a a a a a a a a a a
1010244 b b b b b b b b b b b
1010245 b b b b b b b b b b b
1010246 a a a a a a a a a a a
1010247 a a a a a a a a a a a
1010248 b b b b b b b b b b b
1010249 b b b b b b b b b b b
1010250 b b b b b b b b b b b
1010251 b b b b b b b b b b b
1010252 a a a a a a a a a a a
1010253 c c c c c c c c c c c
1010254 a a a a a a a a a a a
1010255 a a a a a a a a a a a
1010256 a a a a a a a a a a a
1010257 b b b b b b b b b b b
1010258 b b b b b b b b b b b
1010259 b b b b b b b b b b b
1010260 a a a a a a a a a a a
1010261 b b b b b b b b b b b
1010262 a a a a a a a a a a a
1010263 b b b b b b b b b b b
1010264 a a a a a a a a a a a
1010265 a a a a a a a a a a a
1010266 a a a a a a a a a a a
1010267 b b b b b b b b b b b
1010268 b b b b b b b b b b b
1010269 a a a a a a a a a a a
1010270 a a a a a a a a a a a
1010271 b b b b b b b b b b b
1010272 b b b b b b b b b b b
1010273 b b b b b b b b b b b
1010274 b b b b b b b b b b b
1010275 a a a a a a a a a a a
1010276 c c c c c c c c c c c
1010277 a a a a a a a a a a a
1010278 a a a a a a a a a a a
1010279 a a a a a a a a a a a
1010280 b b b b b b b b b b b
1010281 b b b b b b b b b b b
1010282 b b b b b b b b b b b
1010283 a a a a a a a a a a a
1010284 b b b b b b b b b b b
1010285 a a a a a a a a a a a
1010286 b b b b b b b b b b b
1010287 a a a a a a a a a a a
1010288 a a a a a a a a a a a
1010289 a a a a a a a a a a a
1010290 b b b b b b b b b b b
1010291 b b b b b b b b b b b
1010292 a a a a a a a a a a a
1010293 a a a a a a a a a a a
1010294 b b b b b b b b b b b
1010295 b b b b b b b b b b b
1010296 b b b b b b b b b b b
1010297 b b b b b b b b b b b
1010298 a a a a a a a a a a a
1010299 c c c c c c c c c c c
1010300 a a a a a a a a a a a
1010301 a a a a a a a a a a a
1010302 a a a a a a a a a a a
1010303 b b b b b b b b b b b
1010304 b b b b b b b b b b b
1010305 b b b b b b b b b b b
1010306 a a a a a a a a a a a
1010307 b b b b b b b b b b b
1010308 a a a a a a a a a a a
1010309 b b b b b b b b b b b
1010310 a a a a a a a a a a a
1010311 c c c c c c c c c c c
1010312 a a a a a a a a a a a
1010313 a a a a a a a a a a a
1010314 a a a a a a a a a a a
1010315 b b b b b b b b b b b
1010316 b b b b b b b b b b b
1010317 b b b b b b b b b b b
1010318 a a a a a a a a a a a
1010319 b b b b b b b b b b b
1010320 a a a a a a a a a a a
1010321 b b b b b b b b b b b
1010322 a a a a a a a a a a a
1010323 a a a a a a a a a a a
1010324 a a a a a a a a a a a
1010325 b b b b b b b b b b b
1010326 b b b b b b b b b b b
1010327 a a a a a a a a a a a
1010328 a a a a a a a a a a a
1010329 b b b b b b b b b b b
1010330 b b b b b b b b b b b
1010331 b b b b b b b b b b b
1010332 b b b b b b b b b b b
1010333 a a a a a a a a a a a
1010334 c c c c c c c c c c c
1010335 a a a a a a a a a a a
1010336 a a a a a a a a a a a
1010337 a a a a a a a a a a a
1010338 b b b b b b b b b b b
1010339 b b b b b b b b b b b
1010340 b b b b b b b b b b b
1010341 a a a a a a a a a a a
1010342 b b b b b b b b b b b
1010343 a a a a a a a a a a a
1010344 b b b b b b b b b b b
1010345 a a a a a a a a a a a
1010346 c c c c c c c c c c c
1010347 a a a a a a a a a a a
1010348 a a a a a a a a a a a
1010349 a a a a a a a a a a a
1010350 b b b b b b b b b b b
1010351 b b b b b b b b b b b
1010352 b b b b b b b b b b b
1010353 a a a a a a a a a a a
1010354 b b b b b b b b b b b
1010355 a a a a a a a a a a a
1010356 b b b b b b b b b b b
1010357 a a a a a a a a a a a
1010358 a a a a a a a a a a a
1010359 a a a a a a a a a a a
1010360 b b b b b b b b b b b
1010361 b b b b b b b b b b b
1010362 a a a a a a a a a a a
1010363 a a a a a a a a a a a
1010364 b b b b b b b b b b b
1010365 b b b b b b b b b b b
1010366 b b b b b b b b b b b
1010367 b b b b b b b b b b b
1010368 a a a a a a a a a a a
1010369 c c c c c c c c c c c
1010370 a a a a a a a a a a a
1010371 a a a a a a a a a a a
1010372 a a a a a a a a a a a
1010373 b b b b b b b b b b b
1010374 b b b b b b b b b b b
1010375 b b b b b b b b b b b
1010376 a a a a a a a a a a a
1010377 b b b b b b b b b b b
1010378 a a a a a a a a a a a
1010379 b b b b b b b b b b b
1010380 a a a a a a a a a a a
1010381 c c c c c c c c c c c
1010382 a a a a a a a a a a a
1010383 a a a a a a a a a a a
1010384 a a a a a a a a a a a
1010385 b b b b b b b b b b b
1010386 b b b b b b b b b b b
1010387 b b b b b b b b b b b
1010388 a a a a a a a a a a a
1010389 b b b b b b b b b b b
1010390 a a a a a a a a a a a
1010391 b b b b b b b b b b b
1010392 a a a a a a a a a a a
1010393 a a a a a a a a a a a
1010394 a a a a a a a a a a a
1010395 b b b b b b b b b b b
1010396 b b b b b b b b b b b
1010397 a a a a a a a a a a a
1010398 a a a a a a a a a a a
1010399 b b b b b b b b b b b
1010400 b b b b b b b b b b b
1010401 b b b b b b b b b b b
1010402 b b b b b b b b b b b
1010403 a a a a a a a a a a a
1010404 c c c c c c c c c c c
1010405 a a a a a a a a a a a
1010406 a a a a a a a a a a a
1010407 a a a a a a a a a a a
1010408 b b b b b b b b b b b
1010409 b b b b b b b b b b b
1010410 b b b b b b b b b b b
1010411 a a a a a a a a a a a
1010412 b b b b b b b b b b b
1010413 a a a a a a a a a a a
1010414 b b b b b b b b b b b
1010415 a a a a a a a a a a a
1010416 c c c c c c c c c c c
1010417 a a a a a a a a a a a
1010418 a a a a a a a a a a a
1010419 a a a a a a a a a a a
1010420 b b b b b b b b b b b
1010421 b b b b b b b b b b b
1010422 b b b b b b b b b b b
1010423 a a a a a a a a a a a
1010424 b b b b b b b b b b b
1010425 a a a a a a a a a a a
1010426 b b b b b b b b b b b
1010427 a a a a a a a a a a a
1010428 a a a a a a a a a a a
1010429 a a a a a a a a a a a
1010430 b b b b b b b b b b b
1010431 b b b b b b b b b b b
1010432 a a a a a a a a a a a
1010433 a a a a a a a a a a a
1010434 b b b b b b b b b b b
1010435 b b b b b b b b b b b
1010436 b b b b b b b b b b b
1010437 b b b b b b b b b b b
1010438 a a a a a a a a a a a
1010439 c c c c c c c c c c c
1010440 a a a a a a a a a a a
1010441 a a a a a a a a a a a
1010442 a a a a a a a a a a a
1010443 b b b b b b b b b b b
1010444 b b b b b b b b b b b
1010445 b b b b b b b b b b b
1010446 a a a a a a a a a a a
1010447 b b b b b b b b b b b
1010448 a a a a a a a a a a a
1010449 b b b b b b b b b b b
1010450 a a a a a a a a a a a
1010451 c c c c c c c c c c c
1010452 a a a a a a a a a a a
1010453 a a a a a a a a a a a
1010454 a a a a a a a a a a a
1010455 b b b b b b b b b b b
1010456 b b b b b b b b b b b
1010457 b b b b b b b b b b b
1010458 a a a a a a a a a a a
1010459 b b b b b b b b b b b
1010460 a a a a a a a a a a a
1010461 b b b b b b b b b b b
1010462 a a a a a a a a a a a
1010463 a a a a a a a a a a a
1010464 a a a a a a a a a a a
1010465 b b b b b b b b b b b
1010466 b b b b b b b b b b b
1010467 a a a a a a a a a a a
1010468 a a a a a a a a a a a
1010469 b b b b b b b b b b b
1010470 b b b b b b b b b b b
1010471 b b b b b b b b b b b
1010472 b b b b b b b b b b b
1010473 a a a a a a a a a a a
1010474 c c c c c c c c c c c
1010475 a a a a a a a a a a a
1010476 a a a a a a a a a a a
1010477 a a a a a a a a a a a
1010478 b b b b b b b b b b b
1010479 b b b b b b b b b b b
1010480 b b b b b b b b b b b
1010481 a a a a a a a a a a a
1010482 b b b b b b b b b b b
1010483 a a a a a a a a a a a
1010484 b b b b b b b b b b b
1010485 a a a a a a a a a a a
1010486 c c c c c c c c c c c
1010487 a a a a a a a a a a a
1010488 a a a a a a a a a a a
1010489 a a a a a a a a a a a
1010490 b b b b b b b b b b b
1010491 b b b b b b b b b b b
1010492 b b b b b b b b b b b
1010493 a a a a a a a a a a a
1010494 b b b b b b b b b b b
1010495 a a a a a a a a a a a
1010496 b b b b b b b b b b b
1010497 a a a a a a a a a a a
1010498 a a a a a a a a a a a
1010499 a a a a a a a a a a a
1010500 b b b b b b b b b b b

Too damn simple.
Too damn verifiable.

I can probably think of 10 more reasons...

http://www.democraticunderground.com/discuss/duboard.php?az=view_all&address=203x505612

http://www.geocities.com/electionmodel/HAVAOnePC.htm#bline

All existing voting systems are insecure, lack data redundancy, are not open source, subject to program "patching" and remote hacking. They are designed and manufactured by Republican firms which control the tabulation (see Ohio 2004) from the voting machines to the central tabulators. The OP illustrates how data redundancy checks can provide a full audit of the count. Individuals retain a copy of their paper ballot to prove his vote was accurately recorded. He can compare the copy to his uniquely coded ballot record in the precinct file on the Internet. Election officials at the precinct, county and state levels can audit the vote totals.

In their replies to the OP, some critics use classic diversionary tactics to change the subject - or fail to understand what it is all about. They criticize the use of spreadsheet software for precinct data entry and uploading to the Internet. But they ignore the fact that election fraud is easily accomplished with all of the voting methods in use today - except for hand-counted paper ballots.

Critics created an Excel straw man which reveals limited knowledge of programming in general and spreadsheets in particular. They appear to have an agenda to retain voting machines which can be rigged internally and/or by humans after the fact. The OP suggests an Open Source system developed by professional programmers for use in all state precincts - not a set of individual spreadsheets written by non-professionals. A robust Excel VBA application could be developed in a matter of weeks.

The author of the OP has had over 30 years experience in quantitative application program design and development- from defense/aerospace IBM mainframes to Wall Street PCs. He converted main frame applications for investment banks on Wall Street from FORTRAN to Lotus 1-2-3 in the early eighties and then to Excel in the mid-nineties. He developed and marketed spreadsheet based corporate financial models to some of the largest U.S. consumer product manufacturers and foreign banks. As a programming consultant, he developed Excel VBA applications for dozens of the world's largest international banking institutions and corporations. He knows very well what Excel is capable of.

In response to a challenge to corrupt the spreadsheet one critic, a database proponent, said: "No thanks". That says it all. Why not take up the challenge? And not one word about the Access software for voting machines which has been proved vulnerable to hackers time and again.

It is patently false to claim that spreadsheets are not up to the task (due to security issues) and that a database system is the only feasible programming solution. Virtually all banking institutions use Excel in conjunction with securities databases for data retrieval, input and analysis. Criticism of spreadsheets is reminiscent of that leveled at Lotus 1-2-3 and PCs in general by MIS Luddites in the early eighties. Corporate gatekeepers feared that mainframes were being made obsolete by the new machines. They called them toys. Some toys. Spreadsheets have long been used for securities data retrieval and analysis by all U.S. corporations – from Wall Street Investment Banks, consumer goods manufacturers, consulting and accounting firms et al.

Have critics ever written a commercial Excel-based application? One can only assume from the comments that they haven't. Then why don’t they create an equivalent program using their favorite database? That should be a piece of cake for them. The sample spreadsheet took all of 20 minutes to write and proved that counting votes is not rocket science.

Critics fail to suggest a new system design to help eliminate election fraud. What hardware would they use? What software? Would they keep DREs and Optiscans? Should precinct records should be available online for individual retrieval? If yes, how would they go about it? If not, why not? Diebold used Microsoft Access software. How did that go?

The Coopers & Lybrand "study" cited in the article is highly critical of spreadsheets. The study was probably done twenty years ago: "Coopers and Lybrand in London cited research showing that over ninety percent of all spreadsheets with more than 150 rows contained at least one significant formula mistake". But there is little doubt that C&L still uses Excel.

This statement is a complete falsehood which exposes the author's naivete: “Spreadsheets are often temporary pieces of work. Generally, they are used to meet a particular need and then discarded, or used very little. This means that the full rigors of software engineering are often absent from their development. The ease with which an inexperienced user can produce plausible output also tends to militate against the adoption of a more rigorous approach Ray Panko of the University of Hawaii has collected information from both field audits and laboratory experiments in spreadsheet development indicate that spreadsheet errors are fairly common”.

Is the author stating that spreadsheets are inherently error-prone? That is preposterous. Were the "errors" cited the result of sloppy coding by individuals who were office workers as opposed to professional programmers? Were they the result of data entry errors? This statement shows the writer’s ignorance, inverted logic and misplaced sarcasm: "In another study, subjects were shown large and small, well- formatted and poorly formatted spreadsheets. Which combination inspired the most user confidence? You guessed it: large, well- formatted ones. Call it the Information Age Effect; with all that rigorous data so beautifully laid out under program control, how can anything possibly be wrong"? What the author doesn't realize is that a well-formatted spreadsheet, just like easy to read programming code, is a key element of good program design. Mistakes are more likely to occur when a program or spreadsheet is convoluted and complex. This applies to all current programming environments: C++, Visual Basic, Java, etc, as well as the original mainframe procedural language compilers (FORTRAN, PL/I, COBOL).

The author's objections to Excel are the equivalent of GOP/media talking points – just like WMD and terror alerts. No substance. He cites these Excel "disadvantages": Repeated Data; Data Entry; Data Validation & Checking; Data sharing/ Collaboration; Search and Retrieval; Error Debugging; Upper row limit (65000 for Excel); Easy data duplication; Formula errors. But he does not support the statements.

He has no clue about Excel's powerful facilities and is obviously unaware of these relevant features (see Excel Help for examples and documentation):
. Object-oriented programming: Excel Object Model, Visual Basic, interface to programming languages such as C++.
. Databases: Data objects (DAO, ADO); Jet SQL
. Security: virus protection, digital signatures and certificates; workbook, worksheet and cell protection
. Web interface: files, hyperlinks, archiving, web servers
. Debugging tools: available for the programmer to check VBA code, data and formulas.

Every programming language requires that the programmer step through the code. Excel is no different. Formula and programming errors are caused by programmers during development. These errors are not unique to spreadsheets; they are unique to humans. Sixty-five thousand rows are more than enough to handle the largest precinct in the U.S. Excel critics are unfamiliar with Visual Basic for Applications (VBA). Have they had hands-on commercial and/or scientific programming experience in mission-critical applications?

How would critics insure the integrity of the vote? Anyone who has done any reading on the election fraud would agree that there no way to PROVE that votes are counted correctly. Here's a brief summary of why all voting methods can be rigged:

DRE touch screens: Insecure
Many hardware/software loopholes for vote-switching have been exposed

Optical scanners: Vulnerable
No chain of custody; limited or no recount allowed

Levers: Unverifiable
Vote totals reversing at 99, zero votes for Obama in Harlem

Punched cards: Pre-election under-votes; post-election over-votes
In Florida 2000, 110,000 double and triple-punched over-votes, 75,000 under-votes; Dan Rather produced an explosive documentary on how faulty paper was used in 2000 to limit the vote count in heavily Democratic Palm Beach County.

Central tabulators: Invisible
Who controls the count controls the votes. Stalin would be proud.