Here are a couple examples using the formula:
To insert the number of Internet users in Paraguay:=GoogleLookup("Paraguay"; "internet users")
To insert the Earned Run Average of Roger Clemens:=GoogleLookup("Roger Clemens";"earned run average")
Note: In order for the formula to compute properly, quotation marks must be used around both the "entity" and the "attribute."
Some of the entities and attributes you can use
Here are some of the types of entities you can access using GoogleLookup, and a few popular attribute names (some entities won't have all these attributes, and some will have more, so feel free to experiment):
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
The information listed above was taken from:
http://docs.google.com/support/spreadsheets/bin/answer.py?answer=54199
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment