Maps and Gantts in Google Docs. FTW
I’m not sure when the feature was introduced, but you can now incorporate maps within Google Spreadsheets, maps that display icons driven from mapping search terms (e.g. postcodes) as opposed to latitude/longitude combinations. You do so by inserting a Gadget. Thanks to Tom Viner for pointing me to this.
This is a great step forward, as you can publish the spreadsheet and put the script tag into any html page to display it there. The only issue is: it ain’t working for me. Apparently, my page is missing the Google Maps API. Google doesn’t give any insight into this error message, either in its Google Documents help or through what I thought was its rather comprehensive search engine.
It’s also got a bunch of other very cool gadgets to insert. The most useful I’ve found is the Gantt chart one. You put your MS Project data into one sheet and you can have a very good-looking Gantt chart in another, drawing from that data. Very cool indeed. There are some seemingly powerful chart gadgets too. Lots to explore.
But as for the maps, I’m flummoxed. And I don’t know what to do.