March 23, 2013

Free Spreadsheet to Calculate Your 2014 Vote Goals

Download the 2014 Vote Goal Sphreadsheet by clicking the picture

Download the 2014 Vote Goal Spreadsheet by clicking the picture

Some candidates are intimidated by the prospect of calculating their vote goals for their race. It is a necessary task so that candidates are not blindly going into precincts that don’t contribute much to vote totals or aren't that important. Or, worse, talking to all voters since we know not all registered voters actually vote.

To help you here’s a free Excel 2010 spreadsheet to download and calculate your 2012 vote goals. If you don’t have Excel 2010 you can download an Excel viewer allowing you to view and type your data.

You need only three pieces of data you should already have on-hand or can easily obtain from your local Supervisor of Elections’ office.

  1. 2010 number of registered voters broken down by precinct – enter into column “B”
  2. 2010 number of voters who actually voted (voter turnout) broken down by precinct – enter into column “C”
  3. 2014 number of registered voters broken down by precinct (this number will increase as time goes by, until the books close for the election) – enter into column “E”

Voila! Instant analysis that calculates your projected 2014 vote total by precinct!

To prevent risk of error I’ve protected all the fields except for where you need to enter. There’s enough room to calculate 20 precincts. Precinct 1 is completed as an example, so overwrite that data with your own.

If you need more fields please feel free to let me know and I’ll send you a modified spreadsheet.

To be sure, this doesn’t take into account partisan affiliation or go into a deep detailed analyses. This spreadsheet is geared to local races where party affiliation – though important – may not be as an important determining factor as the candidate him or herself or where the race is entirely non-partisan.

This spreadsheet will give you a good overall view of your district and provide you a hard-number goal to strive toward in your election. Use it to guide your strategy and plan.

Akins Creative

Partner with Akins Creative and let us help you build your brand and your business.
envelope-ophone linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram