[Cialug] Lazy programmer question

j.bengtson at mchsi.com j.bengtson at mchsi.com
Fri Aug 20 13:58:10 CDT 2010


Mark's technique does work.  If you have three columns in your spreadsheet:
(A) Start Address (2711 South Loop Drive, Ames, IA)
(B) Destination Address (1007 East Grand Avenue, Des Moines, IA)
(C) Computed URL (=HYPERLINK("http://maps.google.com/maps?saddr="& A1&"&daddr=" & B1))

When you click on the URL, it should show you a google map from Beardshear Hall, ISU Campus, to the Capitol Building in Des Moines.  One drawback for your requirement, google maps seems to follow roads...it won't show you a direct line or follow a buried cable.

----- Original Message -----
From: Dave Weis 
To: 'cialug at cialug.org' 
Sent: Fri, 20 Aug 2010 13:28:31 -0500 (CDT)
Subject: Re: [Cialug] Lazy programmer question


I might have been unclear the first time, I do want all the lines on one map. 

I have a spreadsheet with the start and end of fiber optic lines but want a view of it because its a pain to create a route with cells. 


----- Original Message -----
From: cialug-bounces at cialug.org 
To: Central Iowa Linux Users Group 
Sent: Fri Aug 20 13:33:00 2010
Subject: Re: [Cialug] Lazy programmer question

Toying around a little, it looks like you can use

http://maps.google.com/maps?saddr="start address here"&daddr="end address here"

as a URL to generate a map from the starting address to the ending
address. Combined with Matthew's suggestion for creating a URL using
cells, this should get you a column of links/addresses from which to
build maps.

-- 
Mark Hesseltine
mailto:markhesseltine at gmail.com
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20100820/491929ec/attachment.htm 


More information about the Cialug mailing list