Group items tagged

A starter on creating gadgets to manipulate data in Googlr spreadsheets.

importHTML is a fantastic formula you can use in Google Spreadsheets. Martin describes how you can select and reshape the data you want. For codewranglers only :)

Creating calendar entries from dates in a spreadsheet. Also links to options for reverse direction or using forms, contacts etc.

"TAGS Viewer allows users to browse, explore, and search a Twitter archive. As a backend, it requires Martin Hawksey's Twitter Archive Google Spreadsheet (TAGS). TAGS provides a free, non-technical method of archiving tweets for a given hashtag, which can be particularly useful for capturing a conference's backchannel. This application is contained in a single HTML file and has no server dependencies, which makes it easy to host anywhere: just upload a single file (this one!) and you're done. Or, if you don't need to share it with anyone, just double-click the file on your hard drive to open it in your Web browser. Configuration is as simple as supplying a Google Spreadsheet URL"

Some options using Google Refine or ScraperWiki to get data from online spreadsheets.

Analysing tweets by hashtag using Google Spreadsheets

How to transpose spreadsheet data so stuff entered in forms can be easier to read.

How to mass download Google docs using Greasemonkey scripts

Leaderboarded - interesting little tool to allow comparisons or display of data. I think it can get used with more dynamic data than this video shows.

The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. No scripting ability required to use.

Some techy stuff on getting Google to pull in RSS data

Mark Hawksey describes how to make a great event booking form by customising Google Forms.

Added the J. of Interactive Tech. & Pedagogy http://t.co/OugST0Tp to the #openaccess #elearning #journal spreadsheet http://t.co/vkEVls2U

Create easy flashcards using Google Docs and get them on your puter or phone.

40 2min videos describing how to use Google Docs, spreadsheets and presentations. From 2008 so shows an older Google interface.

Comparison of licence terms of photo sharing sites

Links to all the recordings from RSCon3 2011

This weeks new Google tool! Take a spreadsheet (Google or Excel) and apply visualisations and pivots without needing to know much about what you are doing. Showed me the Gallery when I first opened - need to click 'New Table' to access your own data.