You are viewing an obsolete version of the DU website which is no longer supported by the Administrators. Visit The New DU.
Democratic Underground Latest Greatest Lobby Journals Search Options Help Login

Reply #32: talk about overengineering [View All]

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
Home » Discuss » Topic Forums » Election Reform Donate to DU
foo_bar Donating Member (1000+ posts) Send PM | Profile | Ignore Sat Jul-19-08 01:05 PM
Response to Original message
32. talk about overengineering
# Just one (1) $400 Personal Computer is used for ballot data entry
# $100 Printer
# $100 Spreadsheet

Here, I'll save you $500:

Just install Lotus 1-2-3 and you're all set. Or better yet, use dBase IV (or GNU equivalent) since what you're describing is, gasp, a database (as it turns out a spreadsheet is more suited to analytical and accounting tasks than being a storage engine with a semblance of integrity (or transaction capabilities), but I guess when you're a specialized tool you tend to view everything as a nail.)

Note: Totals are calculated using the Excel function: COUNTIF (range, party code).

This is an excellent way to corrupt a vote total: no record of who entered what, a dozen ways to (pre-)insert a hidden value without leaving a trail, vulnerability to macro viruses without any compensatory benefit to the final product being mutable by ad hoc P-code (like the report writer on Optiscan memory cards but exponentially more publicized), not to mention Excel storing ~100 bytes of formatting data for every byte of useful information such that the real data isn't human readable or verifiable/checksum-able/reconstructable in the event of corruption.

As each code is entered, the spreadsheet automatically calculates the total vote and percentage for each candidate.

You lost the purists at "automatically". Maybe Wilms is right, we still need your help proving the Dodgers won the '51 world series.

Printer Friendly | Permalink | Reply | Top

Home » Discuss » Topic Forums » Election Reform Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC