- svartling's Library tagged docs →  View Popular

Here Ken Norton, Product Manager at Google, shows us the new offline features of
Google Docs, which were just released today.

Google plans to roll out
enhancements to its online spreadsheet program, including the ability to display
data in new ways using lightweight "gadgets" and to notify users via e-mail when
data is changed.

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