Decision 2008: Riding Data Analysis Template
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.|