2016 U.S. Presidential Election Tracker – Excel Template

Posted on
2016 U.S. Presidential Elections - Map with Electoral votes total

It’s election day in the U.S. and almost everyone is interested in knowing the results. Surveys say that more than 80% of U.S. voters are not pleased with the campaigns so far. My opinion about politics continues to go lower and lower with every election cycle (India & U.S.). No, this post is not about my political view. 🙂 It is about Excel, of course.

A couple of years ago, I wanted to build a tracker during 2014 elections in India, but couldn’t complete it in time. U.S. election system is relatively easier on many aspects. So, here we go. A simple Excel template where you can enter the winner of each state and view the results on map. The electoral votes get calculated for each candidate. You can download and edit to apply techniques to other elections or competitions.

It should be noted that I have simplified the framework by only considering 2 candidates/parties (though there are others on ballot).

 

2016 US Presidential Election - Results on Map - Sample Data
2016 US Presidential Election – Results on Map – Sample Data

 

 

FREE DOWNLOAD

2016 U.S. Election Tracker

 

VIDEO DEMO

 

HOW TO USE THE U.S. ELECTION TRACKER TEMPLATE

All the states (and D.C.) are listed on the left side.

2016 US Presidential Election - Enter Winner of Each State
2016 US Presidential Election – Enter Winner of Each State

 

The electoral votes for each state are also listed.

Please choose the winner of each state. Select Clinton, Trump or NoResult.

 

On the right side, you can see the results update.

2016 U.S. Presidential Elections - Excel Template
2016 U.S. Presidential Elections – Excel Template

 

At the top is the Race to White House.

2016 Elections - Race to White House
2016 Elections – Race to White House

 

The bars represent the electoral votes won by each candidate and they increase as the candidates win states. Red color is for Republican party (Trump) and the Blue for the Democratic party (Clinton). The Green line is the magic 270 mark which is needed to become President.

Then, we have the map view.

2016 US Presidential Election - Results on Map - Sample Data
2016 US Presidential Election – Results on Map – Sample Data

 

The Initial D (Democrat) or R (Republican) represents the party that won the state.

The candidates’ total electoral votes are also shown.

2016 U.S. Presidential Elections - Map with Electoral votes total
2016 U.S. Presidential Elections – Map with Electoral votes total

 

When the candidate’s total touches 270, we can see the winner. I don’t have the right to vote and am not picking any sides here. So, let’s see winning scenarios for both parties. 🙂

A completely random scenario where Clinton wins.

 

2016 U.S. Presidential Elections - Winning Scenario for Clinton
2016 U.S. Presidential Elections – Winning Scenario for Clinton

 

Here is a random scenario for Trump’s win.

2016 U.S. Presidential Elections - Winning Scenario for Trump
2016 U.S. Presidential Elections – Winning Scenario for Trump

 

At the bottom we have the state results in Alphabetical order.

Election results by State in Alphabetical Order
Election results by State in Alphabetical Order

 

The width for each state is proportional to the electoral votes.

 

If you would like to edit the formulas, please unprotect the sheet using indzara as password.

 

Please share this with your friends if you like the templates available on this site.


RELEVANT EXCEL TEMPLATES

2 thoughts on “2016 U.S. Presidential Election Tracker – Excel Template

  1. there is a password needed to edit the template

    1. Please use indzara as password. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *