Exhibit Transforms Your Spreadsheet into an Interactive Web Page. Exhibit Transforms Your Spreadsheet into an Interactive Web Page Turn a boring old spreadsheet into an interactive web-based map, timeline, or table with some simple HTML using the free, open source Exhibit project. Exhibit takes data sets up to about 500 rows, plots locations on a Google Map, dates on an interactive timeline, and displays images and links in a tabular or thumbnail view. The viewer can sort, search, and filter data in any Exhibit view without reloading the page. You can make Exhibit do all this with a single HTML file and a spreadsheet--no hardcore programming required.
To try it out, yesterday I threw together my first Exhibit visualization called Broadway Shows I've Seen in the Past 17 Years. Why? A Few Exhibit Views in Action To switch between views in my Broadway shows Exhibit, click on the top row of links (Table, Thumbnails, Map, Timeline, Tiles). The first and default view is a simple tabular view ("Table"), which looks a lot like your spreadsheet.
U.S. An Ad Hoc Youtube Playlist Player Gadget, Via Google Spreadsheet. Featured gadget: Gantt charts in spreadsheets. Cross-posted from the Google Enterprise blog. Editor's note: Hangouts On Air are live video chats, interviews, or performances that are broadcast to Google+. We’ll host these broadcasts from time to time on the Google Enterprise Google+ page to give you the inside scoop on our business and products. Last week, we hosted our first Hangout On Air from the Google Enterprise Google+ page with Jonathan Rochelle, Director of Product Management, Jeff Harris, Google Docs Product Manager, Teresa Wu, Google Docs Community Manager, and Eric Brunnett, Director of IT at Trump Hotel Collection.
During the conversation, Jonathan Rochelle told us the story of how Google Docs, Google Drive and cloud collaboration came to be. Then, Eric Brunnett fielded questions about his company’s transition to Google Apps for Business and how they use shared Google documents and spreadsheets to streamline internal operations and communication. Google Chart API + some JavaScript = Beautiful Charts « Oh, the. The Google Chart API lets you dynamically generate charts. To see the Chart API in action, open up a browser window and copy the following URL into it: Press the Enter or Return key and – presto!
– you should see the following image: I just happened to notice last week that Google released a nifty Chart API for public use. You can include a Chart API image in a webpage by embedding a URL within an <img> tag. Let us develop a pie chart of our own to show the popularity tallies of the various games in India.First, you need the chart data. <table id="GraphThisTable" cellpadding="2"><tr><td>Game</td><td>Popularity</td></tr><tr><td>Cricket</td><td>940</td></tr><tr><td>Hockey</td><td>744</td></tr><tr><td>Footbal</td><td>737</td></tr><tr><td>Tennis</td><td>53</td></tr><tr><td>Other</td><td>27</td></tr></table> var tbl = document.getElementById(“GraphThisTable”); var rows = tbl.getElementsByTagName(“tr”); if (!
} else { Turn Google Docs Into an RSS Reader and Feed Aggregator. Learn how to use any Google Docs spreadsheet as an RSS Feed reader. You can also use the technique to embed RSS feeds into web pages. This tutorial shows how to use a spreadsheet in Google Docs as an RSS Feed reader. You can fetch RSS news feeds from different sources into one spreadsheet – much like a simpler version of Feedly – and then publish your feeds as a public web page. No coding required. If you have a website, you can use the same trick to embed RSS feeds in web pages.
The Google Docs approach is preferred over Flash or Javascript widgets because here you have complete control over the layout and the embedded content will show up on mobile devices too. Before we get started, let’s look at a real example. Here are the complete step involved for putting RSS feeds into Google Docs. Open a new Google spreadsheet and type the RSS feed URL in cell A1. Creating a Googleshare Map With Google Spreadsheets. Creating a Googleshare Map With Google Spreadsheets The new gadget feature of Google Spreadsheets makes it easy to add heat maps. This can be used to create a world map illustrating the Googleshare for a given keyword across different countries; now-Google employee Douwe Osinga called this "Land Geist" a couple of years ago. What's "googleshare"? Also called mindshare, the Googleshare expresses how much any two given concepts are related to each other. To do this in Google Spreadsheets, you first need to find out how to grab the page count for something.
=importXml(" The second page count we need for the calculation adds the country name as well, like this: =importXml(" Now that is set up, let's add real values for the countries and for the keyword. Now pick another empty cell somewhere to be your keyword placeholder. Before we add the map, let's first add the formulas that will calculate the Googleshare. >> More posts Advertisement. Google Releases Chart Image Generator. Google Releases Chart Image Generator Google released a chart generator service they are calling the Google Chart API.
Usage is quite straightforward: you link to an image in the form of a parameterized URL, e.g. (line break added) p3&chd=t:90,49&chs=350x150&chl=Foo|Bar ... and Google returns a PNG graphic containing the chart. Splitting up the image URL parameters, you can see what it's made up of: I'm not linking live to Google but caching this image on my server instead, just in case, as Google limits your requests to this API to 50,000 per day.
This service is really neat all in all. Here are a couple of more examples of what can be done with the Chart API (cached again, but click them to see a live parametrized version): Also see how you can kidnap Google Page Creator's image generator. [Via Google Code blog. >> More posts Advertisement This site unofficially covers Google™ and more with some rights reserved. How can I get financial market information updated automatically. Ruft aktuelle oder historische Informationen zu Wertpapieren aus Google Finanzen ab. Verwendungsbeispiel GOOGLEFINANCE("GOOG";"marketcap") GOOGLEFINANCE("GOOG";"price";TODAY()-30;TODAY()) Syntax GOOGLEFINANCE(Aktie; [Attribut]; [Startdatum]; [Anz_Tage|Enddatum]; [Intervall]) Anmerkungen Die Nutzung von Google Finanzen ist auf 1.000 Anwendungen pro Tabelle beschränkt.
Beispiele Ruft Marktdaten von Google Finanzen ab. Hier ist eine Liste der häufigsten Attribute. Ruft historische Marktinformationen basierend auf den angegebenen Daten von Google Finanzen ab. Hier ist eine Liste der häufigsten Attribute für Anlagefonds. Erstellt unter Verwendung der von Google Finanzen zurückgegebenen Abrufergebnisse ein Diagramm innerhalb einer Zelle, um den Trend des Währungskurses der letzten 30 Tage anzuzeigen. Docs Help Center - How can I use spreadsheets to answer some of.