1 / 31

Google Spreadsheets Mashup Functionality: A Creative Way to Collaborate and Analyze Data

Discover how to utilize Google Spreadsheets for mashups and collaboration with other apps, from financial analysis to geographical data plotting. Learn to create, edit, and share documents to work together effectively.

bmaldonado
Download Presentation

Google Spreadsheets Mashup Functionality: A Creative Way to Collaborate and Analyze Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mashup Functionality included in Google Spreadsheets Mashups created by combining Google Spreadsheets with other applications Online word processing with Google Docs Mashups in this Presentation

  2. Mashups at Programmable Web http://www.programmableweb.com/api/GoogleSpreadsheets

  3. Docs and Spreadsheets • Free: Web-based word processing and spreadsheet programs • Create or Upload: Use existing documents and spreadsheets, or create new ones from scratch. • Storage: Edit your documents and spreadsheets from anywhere. • Collaborate: Invite people to your documents/spreadsheets and make changes together, at the same time. http://docs.google.com

  4. Google Spreadsheets

  5. Spreadsheet Functions

  6. Mashup with Google Search Syntax =GoogleLookup("Earth", "number of moons") =GoogleLookup(A3 ,"number of moons") – Since it is a spreadsheet, you can copy formulas.

  7. Google Search 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 Dinosaurs (like "Velociraptor"): height, weight, when it lived Ships (like "USS Chesapeake"): length, displacement, complement, commissioned Companies (like "Hewlett-Packard"): employees, ceo, ticker

  8. Google Finance

  9. Mashup with Google Finance Syntax Since it is a spreadsheet, you can copy formulas.

  10. Google Finance Mashup in a WebCT Content File

  11. Finance Update Published edits to the Google Spreadsheet will be reflected in the WebCT Content File.

  12. Finance Update Published edits to the Google Spreadsheet will be reflected in the WebCT Content File. Changes in Financial Data from Google Finance will be reflected in both the Google Spreadsheet and the WebCT Content File.

  13. Some GoogleFinance Attributes Syntax: Syntax: =GoogleFinance("symbol"; "attribute"); price: market price of the stock - delayed by up to 20 minutes. priceopen: the opening price of the stock for the current day. high: the highest price the stock traded for the current day. low: the lowest price the stock traded for the current day. volume: number of shares traded of this stock for the current day. marketcap: the market cap of the stock. tradetime: the last time the stock traded. datadelay: the delay in the data presented for this stock using the googleFinance() function. volumeavg: the average volume for this stock. pe: the Price-to-Earnings ratio for this stock. eps: the earnings-per-share for this stock. high52: the 52-week high for this stock. low52: the 52-week low for this stock. change: the change in the price of this stock since yesterday's market close. beta: the beta value of this stock. changepct: the percentage change in the price of this stock since yesterday's close. closeyest: yesterday's closing price of this stock. shares: the number of shares outstanding of this stock. currency: the currency in which this stock is traded.

  14. Collaboration Changes by any collaborator immediately appear for all to see.

  15. Publish

  16. GoogleFinance Mashup as RSS Feed http://www.google.com/reader/view

  17. Google Spreadsheet API Mashups PlotKit Google Maps Amazon.com

  18. PlotKit Mashup Example Mashup produces chart Create Spreadsheet of Financial Results

  19. PlotKit Mashup Example Mashup produces updated chart Edit Spreadsheet of Financial Results

  20. Google Maps Mashup Example Google Spreadsheet

  21. Google Maps Mashup Example Google Spreadsheet Google Map

  22. Amazon.com Mashup

  23. Query Results Posted to Google Spreadsheet

  24. Google Docs

  25. Docs Functions

  26. Google Doc as Content File Changes to Google Docs by any collaborator are reflected in the WebCT Content File.

  27. Collaborate and Publish

  28. Blogger http://www.blogger.com

  29. Google Docs & Spreadsheets Resources http://googleproductivitytools.com http://google-d-s.blogspot.com/

  30. Any Questions? gene.shwalb@umb.edu

More Related