[Cialug] Lazy programmer question

[Matthew Nuzum]

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>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
> http://www.internetsolver.com/
> Please check out our Complete Support Service
> http://www.internetsolver.com/completesupport/
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>



-- 
Matthew Nuzum
newz2000 on freenode, skype, linkedin, 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/797b4bab/attachment.htm