<!–

–>

December 25, 2022

I am pretty technical, and I have performed troubleshooting for some time in multiple industries and with multiple technologies. One of my first rules for troubleshooting any problem is scope. What is the scope of the problem?

‘); googletag.cmd.push(function () { googletag.display(‘div-gpt-ad-1609268089992-0’); }); }

To really understand scope, you must have clarity on the problem. Maricopa County has now admitted there was an issue or issues on election day 2022, and that they are undertaking a root cause analysis. The question I did not hear is: a root cause analysis of what problem(s)?

Given the admission of issues, I will frame my problem statement this way:

Were enough ballots printed and not counted at the voting center to impact the results of the election, i.e. is the door #3 count the representation of the impact of the issues? Along with that, did the county accurately report the scope of the problem to the public and to the court? Did the problem impact one group more than others?

‘); googletag.cmd.push(function () { googletag.display(‘div-gpt-ad-1609270365559-0’); }); }

Proposed solution: This is a data-driven system with several different databases (an educated guess). First, query the “check-in and print system.” I would pull at least the following information: Voter identifier, party affiliation, check-in date and time, ballot identifier, polling location, terminal ID where the voter checked in

That will determine the number of people who physically visited a polling site on election day and checked in and were given a ballot.

Second, using a standard SQL query, join with the table of ballots scanned on election day. There are several ways this could be done, and any database expert should be able to work with the tables and extract this information. With access to the system and a court-appointed expert monitoring me, I would estimate I could pull the data in less than eight hours. Two to four hours if data dictionaries are supplied by the vendor.

I would also generate a list of ballots not accepted or counted at the polling location to be used later.

Now, we have total number of check-ins, and total number of ballots scanned by location on election day. What is that difference? Keep in mind that these election machines were certified, but to maintain certification, the systems should have an error rate of less than one percent. I understand this is a separate issue, but if they were certified incorrectly, that may be an issue to be debated later.

If these numbers don’t match, this is closer to the true scope of the problems, not the false door #3 counts. Door #3 only represents a portion of the total population impacted. It represents the people who put the ballot into door #3. I suspect that is why they keep pointing the court and media to the door #3 estimates because the number of impacted voters is higher.