Showing posts with label Charts. Show all posts
Showing posts with label Charts. Show all posts

Monday, February 22, 2010

Create an Olympics Medal Map using Google Spreadsheets

This is a very detailed "How-to" blog post which takes the reader step-by-step through the creation of a "HeatMap". This is the sort of visual presentation that shows "heat" (color intesity) using some data points connected to physical locations - like countries, in this case - as the source. The post describes taking data from the web, putting the data into a useful form and then creating the map using spreadsheet gadgets. Very well done - except that the author did not provide a link to the underlying spreadsheet example for readers to use as a starting point.

Site:OUseful.Info, the blog...
Page/Post:Create an olympics medal map using a spreadsheet
Spreadsheet:spreadsheet link not provided

Thursday, February 26, 2009

Tracking, Charting (then twittering) a Hamster's Stamina

SpookyPeanut (aka Henry) posted a link on twitter which caught my eye (well, my search, anyway)... He's apparently found a way to monitor his hamster's wheel - and has charted it using a Google spreadsheet. As he described it: "showing off my geeky side again". Nothing useful here, actually, but interesting that the Technical Director of this animated rodent film would post a spreadsheet about a pet rodent. ;)

Site:SpookyPeanut
Spreadsheet Chart:Stamina of a Hamster

Tuesday, June 17, 2008

Fantasy Golf Deserves Fantastic Spreadsheets

Serious fantasy sports leagues require serious data tracking and collaboration. Proof in this spreadsheet which is used by the "A Level Above" Fantasy Sports Site to track a Fantasy Golf game. Look through the blog post for some nice charts presenting some data analysis.

Site:Fantasy Sports Commissioner's Blog
Page/Post:Greatest Tournament Ever
Spreadsheet:PGA Fantasy Golf Standings

Friday, April 11, 2008

Minnesota Politics viewed through spreadsheet gadgets

MNPublius is a blog which is "tracking the status of Minnesota Politics", which, in a recent post, they've decided to visualize using charts and data summaries from a Google spreadsheet. They present the poll results for the 2008 senate race and presidential race as well as approval ratings of 3 local politicians. They've embedded these charts and data summaries right in their blog post, which makes it a nice visual page.
Note - this probably marks the beginning of some posts which point to examples of people using spreadsheet gadgets rather than pointing to the actual underlying spreadsheet itself). To see more examples, visit the Google Docs help center.

Site:MNPublius Blog
Page/Post:PMN Polling Report

Friday, November 30, 2007

Data: Church Attendance by Income

Political Animal is a, you guessed it, political blog as part of Washington Monthly... They took posted some data about church attendance mapped to median incomes and someone on the post commented with a spreadsheet in return showing the data and the chart re-created. Worth a look as an example of a scatter chart.

Site:Washington Monthly
Page/Post:Political Animal
Spreadsheet:US States: Church Attendance v.s. Median Income

Tuesday, October 2, 2007

No Child Left Behind Stats for DC

This is an example of publishing information in a very easy to consume form - charts first, and then the underlying data in a spreadsheet if people want it. The charts were published IN-LINE in the blog post, so they appear without the need to follow a link - they are just included in the post. The author, Nathan, sys these charts show "the percentage of students who have tested as 'proficient' in reading and math according to the No Child Left Behind annual report cards. I've broken out the data into four graphs, splitting the data by Elementary and Secondary schools and test type.". To publish charts like this, there's a special option in the chart menu (once your editing a chart) called "publish chart", which gives you a URL of the chart image.

Site: DC Education Blog
Page/Post: NCLB Stats, 2007 Edition
Spreadsheet: DC NCLB Report Card