Saturday, December 15, 2007

Collaborating Information on Bike Sharing

There's a new trend in public transportation called "Bike Sharing" - discussed in a BusinessWeek article and well-followed by a blog by MetroBike LLC. MetroBike recently blogged about a collaborative spreadsheet started by TransLink (South Coast British Columbia Transportation Authority) which is attempting to share information about these Bike Sharing programs across all the cities which provide them. An interesting use case in global collaboration online - with a green tint ;)

Site:Bike-Sharing by MetroBike
Page/Post:Online Public Bicycle System Inventory
Spreadsheet:Public Bicycle System Inventory Spreadsheet

Project Plan Gantt Chart

Antonio Lupetti strikes again... Last time, he posted a descriptive project planning template using Google spreadsheets. This time, he's got a spreadsheet which produces a gantt chart of your project tasks using conditional formatting.

Site:Woork Blog
Page/Post:Gantt Chart using Google Spreadsheets
Spreadsheet:Gantt Chart Spreadsheet

Project Planning Spreadsheet

The Woork Blog (spelling intentional) by Antonio Lupetti has a post including a useful Project Plan template using a spreadsheet. The post itself is a good read as it offers an explanation of the meaning of all the data in the spreadsheet including some methods used (like vlookup).

Site:Woork Blog
Page/Post:Implement a Project Plan and manage activities with Google Spreadsheets
Spreadsheet:Project Plan Tutorial
Get Your Own Copy:This link gives you your own copy of the above spreadsheet to edit

$2 Billion in Investments for Peoria Illinois

Looks like the government of the City of Peoria, IL has begun to use a public blog to share data and information about the city. In particular, there is a post which uses a spreadsheet to outline $2 Billion dollars of investments made, organized in three different ways. While we didn't confirm the source of this blog or the data itself, the profile certainly looks valid... and even if it isn't valid, I figured the idea was good enough to share.

Site: City of Peoria Economic Development
Page/Post:$2 Billion in Investment
Spreadsheet:$2 Billion Invested Spreadsheet

Thursday, December 6, 2007

Stock Gumshoe Tracks Stock Tips

The Stock Gumshoe blog is for people who are "frustrated or intrigued by email teasers from investment newsletters and advisers". It includes a spreadsheet which tracks the investment advice of these investment newsletters which provide, for lack of a better name, "Stock Tips". Travis Johnson, the author of this blog and another investment blog (called OneGuysInvestments) says on that other blog that he's "not an investment advisor, registered or otherwise, so don't follow my moves unless you're happy to lose money without suing someone.". Notice in this spreadsheet, Travis' smart use of links in cells to point viewers to specific blog posts for each of the investments being tracked... Great way to offer value to readers but also to syndicate your pages to other sites.

Site:Stock Gumshoe Blog
Page/Post:Sock Gumshoe's Tracking Spreadsheet Page
Spreadsheet:Stock Gumshoe Tracking Spreadsheet