Creating Data Driven Mapping applications

Creating Data Driven Mapping applications
In a previous post I looked at the the various mapping packages and how they compared. Having concluded that Google Maps was the winner, I started to work on an Excel application that could generate the necessary javaScript to Map Excel data and create tabbed Info Windows with embedded Google Visualization. This is now completed and can be downloaded and read about on the Excel Ramblings Site

Open up Google Maps and Vizualizations to Excel users
It occurred to me that Google Maps and Google Visualizations were pretty much out of reach to those who did not know javaScript, or have much web experience, even though they might quite adept at VBA and have some interesting data that could benefit from these tools.

VizMap application: DEPRECATED
The purpose of this application then is to take Excel Data and some parameters and create an html file to map and visualize that data. In the example you’ll find 3 demo applications that have been created this way. You can also run them directly below

  1. A Customer/Orders theme.
  2. A Concert Venues/Artist theme.
  3. A Dictators/Palaces theme
Non-Excel users
Since the javaScript component of this is taking a jSon formatted framework definition, as well as jSon data, clearly this input can be created manually or indeed from some web service, so this application may be of some interest to non- Excel users also. All that is needed is to write 2 functions that will return the framework (what the application needs to look like and how to present data), and the data that needs to be displayed.
More on this on future blog entries. I look forward to your comments on this blog or at our forum.
About brucemcp 223 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


six + 13 =