Here is the important Variable definitions: (code clips)
from: http://blackboxvoting.org/fraction-magic-3/
Fraction Magic – Part 3: Proof of code
By Bev Harris May 12, 2016 COMPANIES, ELECTIONS INDUSTRY, MAKE AND MODEL, RESEARCH
3 – Programming to treat votes as decimals –
The term “DOUBLE” means to store and process numbers with “double precision floating points” – in other words, to enable large numbers of decimal values.
In contrast, the term “INT” instructs the program to treat numbers as whole integers.
Source Code:
Below are clips from GEMS source code showing that it converts votes from whole numbers (previous version, GEMS 1.17) to store and process them as decimal values by setting them to “double” in GEMS version 1.18:
“ALTER TABLE SumCandidateCounter”
“ALTER COLUMN TotalVotes DOUBLE”
“ALTER TABLE SumRaceCounter”
“ALTER COLUMN NumberOfUnderVotes DOUBLE”
***
“CREATE TABLE SumCandidateCounter (
ReportunitId INT,
VCenterId INT,
CounterGroupId INT,
CandVGroupId INT,
TotalVotes DOUBLE )”
***
“CREATE TABLE SumRaceCounter (
ReportunitId INT,
VCenterId INT,
CounterGroupId INT,
RaceId INT,
TimesCounted INT,
TimesBlankVoted INT,
TimesOverVoted INT,
NumberOfUnderVotes DOUBLE ) ”
***
“ALTER TABLE CandidateCounter ”
“ALTER COLUMN TotalVotes DOUBLE ”
“ALTER TABLE RaceCounter ”
“ALTER COLUMN NumberOfUnderVotes DOUBLE”
***
# Contains the candidate counts for the race
“CREATE TABLE CandidateCounter (
CounterBatchId INT,
ReportunitId INT,
CounterGroupId INT,
CandVGroupId INT,
TotalVotes DOUBLE
# Number of votes ) ”
***
“CREATE TABLE SumCandidateCounter (
ReportunitId INT,
VCenterId INT,
CounterGroupId INT,
CandVGroupId INT,
TotalVotes DOUBLE ) “
***
Non-programmers may not have seen the term “double” used to describe processing numbers with decimals.
Here is an SQL tutorial — there are many — showing that “Double” means to process numbers as decimal values:
They shouldn’t be using DOUBLE, they should be using UNSIGNED INT (max 4,294,967,295). Not everyone appreciates the difference between integers and floats.
This is just the database table definitions (CREATE TABLE) and table definition changes (ALTER TABLE). There is no “code” that adjusts vote totals based on race.
It looks as though they are keeping track of blank votes (no selections made for any candidate for any position), undervotes (i.e. no selection made for President) and overvotes (i.e. more than one selection made for President), and they’re recording that by race, and summing it, presumably to determine voting competency by race.