Home > Computers and Internet > Decision 2008: Riding Data Analysis Template

Decision 2008: Riding Data Analysis Template

14-Oct-08 01:36 pm EDT Leave a comment Go to comments

Ever wanted to know what the election history of your riding was?  How did people vote last time?  What were the percentages?  Were there any trends?

Well, in preparing a blog article tonight, I quickly put together a Microsoft Excel spreadsheet template that’s compatible both with Elections Canada data from the 2000 general election, and the newer data set Elections Canada has used from 2004 to the present.  The template comes complete with numeric summaries and charts displaying voting trends and comparing them.  Each spreadsheet is devoted to data from a single riding.

I’ve uploaded the template and several riding data examples (again, used in the previously-posted article) to my Microsoft Live "Skydrive":



How do you use the template?  Well, you simply cut-and-paste downloaded data from Elections Canada and then match the results cell on each of the yearly worksheets to the right place in the totals chart for that election.  I’ve created a short video to explain the process (because it’s much faster to just demo the process than write it all out) – you can watch this below.  Feel free to chat or email me with any questions, but the hope is you’ll find it straightforward…


Links to remaining video segments (there are a total of 4 parts):


Above is the first video in a 4-part series running a combined total of 34 minutes and 4 seconds (0:34:04) documenting the usage of the very first version of the template.  I would have posted the whole thing as a single file, but YouTube doesn’t let one post videos longer than 10 minutes.  Even worse, if – as in my case – you upload the full video without breaking it into segments, it cheerfully lets you proceed and even takes all the time required to do the post-upload processing all videos are subjected to only to then tell you some additional 10-15 minutes later that it was "rejected".  The rationale for the video’s rejection is contained only in a small place buried within the dreadful UI of the YouTube web site and any efforts to contact YouTube or solicit help from the dysfunctional YouTube forum fail completely.  Look for a later blog article outlining my remarkable experience with YouTube (and Google, which owns YouTube) over the past couple of days; attempting to find out why my original efforts to bring this video to you were met with chronic failure.
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Breaching the barrier between PC and Console.

Terry Glavin


Techno Manor

Geek's Corner


an IT blog.. and an occasional rant

Yammer Site Status

Is Yammer down? Offline? Broken? Undergoing scheduled maintenance? When will it be back? Find out here.


A journey full of wonderful experiences

Azure and beyond

My thoughts on Microsoft Azure and cloud technologies


Startup and Technology News

Ottawa Citizen

Ottawa Latest News, Breaking Headlines & Sports

National Post

Canadian News, World News and Breaking Headlines

Targeted individuals's

One Government to rule them all.

Joey Li's IT Zone

Everything about IT


Unravelling the magik of code...

The Bike Escape

Because Cycling is Life

The Ross Report

Now you know where you need to know more...

Strength Rehabilitation Institute

Bridging the gap between physiotherapy and exercise.

Little Girl's Mostly Linux Blog

Nothing to see here. Move along...

%d bloggers like this: