[Cialug] Lazy programmer question

[Dave Weis]

I did find a bunch of ways to put dots on individual points but none off the shelf to make lines between two points.

________________________________
From: cialug-bounces at cialug.org <cialug-bounces at cialug.org>
To: Central Iowa Linux Users Group <cialug at cialug.org>
Sent: Fri Aug 20 13:19:57 2010
Subject: Re: [Cialug] Lazy programmer question

There are some mashups on the web that let you upload a spreadsheet of addresses. I've not seen one that lets you create multiple maps from one spreadsheet.

Somethign I do ocassionally (actually, its by far my #1 use of a spreadsheet) is to use a formula to spit out HTML.

For example, if A1 is address one and B1 is address 2 then I might create a formula in C1 like this:
="<a href='...?address="&A1&"'>adress 1</a> and <a href='...?address="&A2&"'>address 2</a>"

Then you fill down and copy the resulting column into an HTML doc.

That could come in handy with the static map api:
http://code.google.com/apis/maps/documentation/staticmaps/

Or with just a little looking I'll bet you could do the same to spit out javascript that uses the normal maps api.

I don't know it's possible to embed images into a spreadsheet where details about the image come from cell references. That would be pretty cool.

One more option is to upload your doc to google docs, switch to the older version and play with the map gadget. I gave it a quick glance and could not see how to feed it two addresses though.

On Fri, Aug 20, 2010 at 12:27 PM, Dave Weis <djweis at internetsolver.com<mailto:djweis at internetsolver.com>> wrote:

I have a spreadsheet containing two addresses per line and I want to draw a (google or other) map with a line between each of those addresses. I would prefer it not to take the rest of the day.

Any pointers on the most efficient method to give this to google maps?

--
Dave Weis
515-224-9229
djweis at internetsolver.com<mailto:djweis at internetsolver.com>
http://www.internetsolver.com/
Please check out our Complete Support Service
http://www.internetsolver.com/completesupport/

_______________________________________________
Cialug mailing list
Cialug at cialug.org<mailto:Cialug at cialug.org>
http://cialug.org/mailman/listinfo/cialug



--
Matthew Nuzum
newz2000 on freenode, skype, linkedin, identi.ca<http://identi.ca> and twitter

"Never stop learning" –Robert Nuzum (My dad)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20100820/db6ed036/attachment.htm