Friday, December 01, 2006

Google Docs & Spreadsheets

The engineers at Google have been working very hard on their Google Spreadsheets. They just released the API for that too. They might be working hard on Docs, but they haven't released too many new functions for that yet.

I know that they've hired the guys at iRows, have implemented some new functions too (such as GoogleLookup and GoogleFinance). They're still lagging behind Editgrid but give it a few more months and I'm sure we'll see them catch up.

See the differences between Editgrid, Google Spreadsheets and Excel 2003 here. If you want to see how one of my spreadsheets using the GoogleLookup function looks like, click here. You'll see that it's far from perfect, and a few things still need to be modified, like the following;

* Some GoogleLookup searches don't work correctly, you'd think that GoogleLookup("Germany", "population") would work...
* Population searches are not integers, so using these in other fields
(such as calculation of GDP per capita) are not possible
* Revision is only in PST, other timezones would be appreciated
* Change the 100 row maximum to something more workable, like 1000
* Change the 250 GoogleLookup maximum to unlimited.