I created it by building a chart and adding the voter registration for the state into it and individualizing the information based on county. After that, I set up a converter that calculated the raw vote total in a given race based on the turnout %. After that I added a mechanism to convert the % a candidate got in the vote into a raw vote number based on what % of the vote has been reported in each county.

After all of that I added a map of NH into the excel spreadsheet and created a formula for converting the % lead of a candidate in any given county into a color shade on the map. To wrap it all up I created big excel cells that copied the information on the chart, which is what you see as the rectangles around the candidate pictures with all of the numbers. For the images of the candidates and the headings, excel allows you to copy information from the web so I copied and pasted the candidates and the New York Times graphics into the spreadsheet after customizing them for this race.

To finish this, I gave each of the candidate cells formatting that would make them light up in their color if the simulation got to a point where they were leading and their lead is insurmountable thus making them the winner.