I'm building the changes to sheetsee.js. Through a Knight-Mozilla Open News Grant I'll be making lots of improvements and working with WBEZ to make a sheetssee awesome. Newness will include: stripping it of all CfA project-specific idiosyncrasies and making it really easy to understand and stand up, more out of the box vizualization options, sortable tables of data, data caching and documentation galore!
This branch will remain for now and branch twoOh will eventually have the new client-side version on it. I'm also working on a server-side version which, for now is here: github.com/jllord/sheetsee-cache.
Woo!
Sheetsee.js is a javascript library mashup that allows you to fill a website with content from a Google Spreadsheet. The web content and visualizations will update with every auto save by Google. That's cool. No pushing or uploading changes.
It was created and is the intregal part of my Code for America project, See Penny Work. This is a tool-kit for cities to easily visualize budgets and manage the data through a Google Spreadsheet (open data!). Check out the illustrated readme for that project to get a sense of the potential.
Because it was created for my CfA project, it's really customized to that project's needs but I hope to be generalizing it soon. There is all kinds of stuff you can do once you have data in a Google Spreadsheet. I'm also using it on my own website here.
Once you've hooked up your spreadsheet and your website through sheetsee.js, all you'll need to interact with is the spreadsheet. Think of it as a super simple CMS.
You can view a working sample of the bits in action at jllord.github.com/sheetsee.js/
It all starts with tabletop.js. With that you can pile on any other library to style and visualize your data.
You can feed d3.js the data it needs to make charts.
You can feed leaflet.js the data it needs to make maps.
Use mustache.js to create templates for the data in your spreadsheet.
For now, check out the readme for my CfA project which talks about the set up.
This repo is BSD Licensed, read more in license.md.
I may have done some funky merging, but things appear to be ok.
I've made many changes in sheetsee.js while developing it's parent project (the CfA project mentioned in this readme) and haven't refelcted that in this separate repo - until now! Fresh update with sheetsee.js the way it is in the larger project.