American Ride Temperatures as Spreadsheet Examples

by Pete Hindle

(click image to see large/download)

Following on from the last post, I just quickly wanted to post this image of the last database and spreadsheet work I did, which was featured in a magazine called ‘Esc’. This is a list of the average temperatures of all the Critical Mass locations in the USA, which I threw together using a variety of sources for weather across the states.

After throwing all the data I could find into a spreadsheet, I managed to make this fancy layout within Numbers, Apple’s spreadsheet program. The only problem with that is that exporting the file is quite a bugger; for some reason, it only wants to output A4 pages, which makes exporting my nicely laid out page a pain in the ass.

Here are the files for download:

PDF file of above image, with links: american-rides (pdf)

Just the spreadsheet: american_rides (csv file)

Image download: american_rides (png file, used above)

Feel free to download, remix and restructure this information to your hearts content: I’m licensing it under an Attribution CC license.

Creative Commons License
American Rides by Pete Hindle is licensed under a Creative Commons Attribution 2.0 UK: England & Wales License.
Based on a work at unnamedlaboratory.org.