Category Archives: EAVS

PCEA research white papers

The Presidential Commission on Election Administration’s report is getting a lot of attention and praise following its release on Wednesday. One aspect of the report I want to highlight is the degree to which the Commission aimed to ground their findings in the best available research, academic and otherwise.  It renews my faith that it […]

An easier solution to the leading zero problem

Start with the Excel file Add in 3 new columns (D, E, and F) Highlight column C and select “data / text to columns” from the menu Select “fixed format” and then use the cursor to separate columns 1-2, 3-5, and 6-9 Finish The result should look like this and allows a match/merge by State, […]

Leading zero problems in the NVRA Dataset

In the EAC’s NVRA 2010 dataset, the FIPS code is stored as a numeric value, and this will cause problems with anyone who is trying to match / merge this with other data because 10 state FIPS codes start with a “0″.  Most statistical programs will strip that leading zero, making it hard to identify […]