The official (I think) TED group on facebook has a link to a published spreadsheet listing all the TED talk videos. This makes it quite easy to quickly find and watch the ones which seem interesting from their name or the speaker name. There are even separate sheets sorting the list by conference and by speaker. It even lists the duration, which is useful.
| Site: | Facebook Ted Page |
| Spreadsheet: | List of all Ted Talks |
Kortina from bit.ly posted this spreadsheet which is actually a tool tied back to his URL shortening service. This is a good use of the ImportData() function within Google spreadsheets... it allows entry of lots of original (long) URLs, then creates a call to the bit.ly service (which, itself is a simple URL), then uses the importdata() function to get back the answer (the shortened URL)... Try this to learn a few new tricks.
| Site: | bit.ly blog |
| Page/Post: | bit.ly meets Google spreadsheets |
| Spreadsheet: | bit.ly shortener spreadsheet |
| Get Your Own Copy |
Geo-aware coin collectors commonly post their "trading lists" on the GeoCaching.com user forums (known as GroundSpeak). One user thouht it would be helpful to collect all these trading list URLs into a well organized spreadsheet. That spreadsheet is now like a navigation page to all the trading lists posted by users.
| Site: | Geocaching.com |
| Page/Post: | Trading List Post |
| Spreadsheet: | Geo-COIN Trading Lists |
Using a spreadsheet to organize favorite or useful links to web sites is a common use case we’ve seen. Here is a good example... Frank Kelly in Boston posted “a collection of quite a number (250+) of the many online articles on Java, Software engineering (architecture, the development process), XML etc. that I've read over the last years - probably going back to 2001. I've included a URL and a personal score (on a scale of 1 to 5 with 5 being awesome).”
Site: The Art and Craft of Great Software Architecture and Development
Page/Post: Favorite Java and SW Eng Articles
Spreadsheet: Ranked List of Articles
