Comparison of Spreadsheet functions

This is a Comparison of Spreadsheet Functions between Excel, Google Spreadsheets, EditGrid, ThinkFree - Calc, OpenOffice Calc and Zoho Sheets made in July 2007. It consists of more than 500 unique Spreadsheet functions.

It took some time to compile this list since the quality of the Suppliers Spreadsheet functions lists are far from flawless. Also the interpretation of what category a certain function belongs to varies. Since then I have not attempted an update.

Still, I think it is the most complete Spredsheet function comparison list right now.


Update June-2008:
EditGrid just took a great leap with the introduction of 41 External Data Retrieval Functions. They now have more then twice the amount of functions compared to Google, and more the 50% more the Excel and the other competitors. Here is one example what you can do with the new external data retrieve functions.

Fredrik Härén - Del 1 & 2

Del 1
Sverige anses ofta ha en välutbildad befolkning. Men hur mycket vet vi egentligen om världens två största länder, Kina och Indien? I allmänhet inte så mycket. Det menar i alla fall Fredrik Härén.




Del 2
Mer av Fredrik Härén från Kunskapens dag. Bland annat om skillnaderna mellan oss i "developed countries" i väst och de nya ekonomierna i framförallt Asien, i "developing countries".



More: TED spreading ideas

Amazing vision

A Swiss marine biologist and an Australian quantum physicist have found that a species of shrimp from the Great Barrier Reef, Australia, can see a world invisible to all other animals.

Dr Sonja Kleinlogel and Professor Andrew White have shown that mantis shrimp not only have the ability to see colours from the ultraviolet through to the infrared, but have optimal polarisation vision -- a first for any animal and a capability that humanity has only achieved in the last decade using fast computer technology.

They can move each eye independently, they see the world in 11 or 12 primary colours as opposed to our humble three.

Most animals can tell how fast the electric field in a light wave is oscillating, which is perceived as colour. (Blue light oscillates faster than green, which is faster than red). The direction of the oscillation is known as polarisation.

The two scientists have shown that shrimp of the species Gonodactylus smithii have eyes that simultaneously measure four linear and two circular polarisations, enabling them to determine both the direction of the oscillation, as well as how polarised the light is.

Each eye measures the six polarisation components that are precisely required for optimal polarisation vision. In fact, the physics we used to understand what was going on is the same physics that we use in quantum computing for optimal storage of information."

Colleagues at The University of Queensland have recently found a related species where the males reflect circular polarisation from their bodies, and hypothesized that circular polarisation vision is used for sexual signalling.

Read more


Human perception limit (Updated 2013-01)
Only for humans. ...

Source: link