ACCEPTABLE PARAMETERS AND VALUES FOR EXCEL MAP LOADING

[ROGMO]

Greetings,

 

[ROGMO]

On Sunday, July 22, 2012 9:32:28 AM UTC-4, ROGMO wrote:

Greetings,  I apologize for the newbie questions that no doubt have obvious answers to the indoctrinated, but I have spent a lot of time trying to find the answers to no avail.  Any help would be appreciated.  I am trying to set-up an easy to use and maintain interface for inputing channel marker data and displaying it in Google's map and earth views.

 

Question 1:  I have downloaded the 'Creating Google Maps' layer from the Excel Data example set.  This has a macro enabled spredsheet that you can update the fields and generate your own map from.   I was able to run it and make some changes to lat/lon settings to place markers on my own generated map as well as updating marker pop-up boxes.  All of this is terrific, except I cannot find a simple explanation of what 'parameters'/column headings are used in Excel with their acceptable values (when there is a defined set). e.g.:  markerimage markersize  I have downloaded the Google Workbook and reviewed items there, but it does not cover these Excel column headings and acceptable values.

 

Question 2:  I would like to create my own marker images instead of using the standard upside down teardrop.  How to imbed an address into the Excel spredsheet that contains the custom markers would be helpful.

 

Question 2:  I would like to connect the generated markers on my map with something like the 'path' command shown in the GOOGLE WORKBOOK.  Has this been accomplished using the Excel spredsheet input process?

 

I obviously have not absorbed the overall relationships between the Excel spredsheet data and the Excel API that updates and calls the Google mapping function. Perhaps the API is the marcro fused Excel spredsheet.  Confused.  

 

Thanks again.

 

[Bruce Mcpherson]

Hi. thanks for contacting our forum.

Most of your questions are covered here somewhere,  http://ramblings.mcpher.com/Home/excelquirks/getmaps , but I'll try to point you in the right direction.

There are 3 or 4 different kinds of application in the workbook you downloaded. There are also 2 parameter sheets. 1 which contains generic parameters, applicable to all data sets - this called geoCodingParameters, and another which is specific to a particular data set. 

Im assuming that you have the geocoding one figured out, so we'll deal with the simple marking on a google map.  

A typical application would simply look like this

Public Sub stepByStepMarking()

    googleMarkingExample "Step by Step Parameters"

End Sub

Where in this the "Step by Step parameters" refers to the parameters for a particular data set. There is a step by step guide for these applications here http://ramblings.mcpher.com/Home/excelquirks/snippets/steps

There are two types of parameter - those that refer to manadatory data location such as labels, content, location etc. This tells you the basic parameters required http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapmarkers

The other type is optional, for example creating circles, flightmaps, alternate markers etc. 

How to set up data - http://ramblings.mcpher.com/Home/excelquirks/snippets/steps/custommarkers

What the parameters are about - http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapping/circles

That should get you started and there is plenty more detail in http://ramblings.mcpher.com/Home/excelquirks/getmaps also

1. acceptable values. In most cases, a few  parameters refers to either a size or dimension equivalent to those required by the Mapping API (like size of a circle - and these are documented in   http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapping/circles ), but mainly they refer to column headings in your data. In other words they are simply describing where to find data. A third type are category names you assign (and invent) in order to group places together as in  http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapping/quicklinks
2. You can use your own images - Just add a column of data with URL links to markers in it (or leave it blank to get the default image) as per   http://ramblings.mcpher.com/Home/excelquirks/snippets/steps/custommarkers. and set the markerImage parameter to the column name
3. I assume you mean by path, flightPath- as per the writeup at  http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapping/flight. In this case you can add a couple of columns to your data - flightGroup and flightColor. Any data points in the same flightgroup will be connected. You can have mutilple flight groups. Flightcolor defines the color of the connection line. 

Finally, a standalone html file is created that contains all the code and the data from the worksheet, with all the parameters translated into appropriate googleMaps api code. The template for the code (should you need to change it) is itself the value of various parameters in the geoCodingParameters worksheet.

 So in summary, Excel provides the parameters and data, VBA creates a javaScript application from an html template based on that, and you execute the generated application with you browser.

regards

bruce

 

--
You received this message because you are subscribed to the Google Groups "Excel Ramblings" group.

To view this discussion on the web, visit https://groups.google.com/d/msg/excel-ramblings/-/OXgHBKAYslkJ.

To post to this group, send an email to excel-r...@googlegroups.com.
To unsubscribe from this group, send email to excel-ramblin...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/excel-ramblings?hl=en-GB.