Creating data driven applications straight out of Excel get it now
- How to create rich applications which pulls together Google Maps ,Google Visualization, Twitter and Google Earth.
- Use the generated web applications as standalone web pages.
Try it out first ?
and the same thing using Google Maps
You can select either just by changing a parameter in your worksheet.
- GeoCoding parameters. This describes how to deal with the response from various geoCoding providers and how to incorporate this in the VizMap application. This is the same as was introduced in the section on GeoCoding
- Application specific parameters. These describe the data to be shown on the map, which visualizations to embed in the map Popup Windows, where to position them, what data to include, and any tailoring information required to construct specific web page look and content. There will be one of these for each VizMap application, and from this a self contained web application will be generated.
- Master/Transaction joining application. When creating these kind of applications, there is often a join of transactions to master data and look up data required. The googlemapping.xlsm workbook also contains a capability to do this using Data Manipulation Classes covered elsewhere on this site.
- Excel/Json Conversion. Data and parameters are communicated from Excel to the Web applications and web services used using jSon. We use the cJobject serialization capability covered elsewhere on this site.
- Creating a VizMap Application
- Tailoring Output
- VBA – the Excel code walkthrough
- Creating VizMap framework without Excel
- Providing VizMap Data without Excel
- Creating a tabbed Google Mapping InfoWindow
- Embedding Google Analytics in your VizMap application
- Using Google Maps
- Using Google Visualization DataTables
- Using Google Visualization DataViews
- Using Google Visualization charts and tables
- Using Google Earth
- Click events in Google Earth
- Flying around with Google Earth
- Using Twitter in Earth and Maps