Googlelookups() WOW

I saw this in one of the comments on Office Live Workspace vs Google Docs: Feature-by-Feature Comparison

—clip—

Hey Sarah,
If you want to focus on “everyman” features, why not to highlight the awesome GoogleLookUp function?

Here are the few steps:
1. Create a Google Spreadsheet
2. Tape “bmw” in A2, “mercedes” in A3 and “nissan” in A4
3. Select A2:A4 and, while holdind the Ctrl key, expand your selection until A50.
4. Say “wow”
5. Tape “employees” from B2 to B50.
6. Enter “=googlelookup(A2; B2)” in C2 and expand the formula until C50
7. “wow”, again

Here are some of the types of entities you can access using GoogleLookup, and a few popular attribute names:

Countries and Territories (like “Burkina Faso”): population, capital, largest city, gdp
U.S. States (like “Tennessee”): area, governor, nickname, flower
Rivers (like “Amazon River”): origin, length
Cities and Towns (like “Chicago”): state, mayor, elevation
Musicians (like “John Lennon”): date of birth, place of birth, nationality
Actors (like “Audrey Hepburn”): date of birth, place of birth, nationality
Politicians (like “Anwar Al-Sadat”): date of birth, place of birth, nationality
U.S. Presidents (like “Zachary Taylor”): date of birth, place of birth, political party
Baseball Players (like “Wade Boggs”): games, at bats, earned run average, position
Chemical Elements (like “Helium”): atomic number, discovered by, atomic weight
Chemical Compounds (like “Isopropyl Alcohol”): chemical formula, melting point, boiling point, density
Stars (like “Betelgeuse”): constellation, distance, mass, temperature
Planets (like “Saturn”): number of moons, length of day, distance from sun, atmosphere
Dinosaurs (like “Velociraptor”): height, weight, when it lived
Ships (like “USS Chesapeake”): length, displacement, complement, commissioned
Companies (like “Hewlett-Packard”): employees, ceo, ticker

9. Take a look at other Google functions in the “Google” tab of this page: http://documents.google.com/support/spreadsheets/bin/answer.py?answer=82712&ctx=
10. “wow”, again and again

These are the reasons why web-based apps are far more superior than desktop-based ones. And with more and more microformats, I bet this funtion will definitely improve the way we organize information. That could make a pretty corporate goal ;-)

Posted by: Jrome | March 4, 2008 2:23 PM

—clip—

1 thought on “Googlelookups() WOW”

  1. I second on “These are the reasons why web-based apps are far more superior than desktop-based ones.”

    It’s boring to see web apps catching apps with desktops in interactivity and responsiveness all the time. Use the internets!

Comments are closed.