google spreadsheets
Work
Google Spreadsheets Can Validate Data
12:00AM Kevin Purdy | If you’re sharing or collaborating on a Google Spreadshet, you can now set columns to validate data types. Cells can enforce certain data types, require valid URLs or mandatory text, for example. [via Google Blogoscoped] More »
Organise
Chart Your Investments with Google Spreadsheet
4:55AM Gina Trapani | Techie Leonard Lin publishes his investment asset allocation in a Google Spreadsheet which employs the super-useful GoogleFinance formula for live-updating stock prices in-sheet. [via] More »
Get notifications to track changes in Google Spreadsheets
12:20PM Sarah Stokely | Here’s a tip for the Google Spreadsheet users out there. Google has added the ability to set alerts to notify you about new data as it is added. This will be useful if you work collaboratively and have shared your spreadsheet with others, or if you use forms to collect information from multiple users.
At the top right of the Spreadsheet page you’ll see a link to “Set Notification Rules” (or you can find it in the File menu). You can control
what parts of your spreadsheet to track, and how often alerts are sent. You can see the options in this screenshot:
[via Google Tip of the Day Gadget]
More » 
Heat Map Google Hits for a Search Term by Country
2:02AM Gina Trapani | Google expert Philipp Lenssen has come up with a brilliant spreadsheet that creates a world map coloured by how often a term gets Googled by country. Data nerds will love this: The sheet dynamically pulls in the number of results for a given search term and updates a map widget with colours representing the totals. After the jump, check out what the map looks like for a search for “lifehacker.” More »
