Mapping street addresses in Excel.

[kjspear]

Hello everyone,

I have a question about Excel. My job maintains a delivery route within certain neighborhoods. The line of travel which includes streets are in a Excel database. Is there any way that I can have Excel actually produce a map of the routes? What I'm trying to accomplish is displaying the area the route is and showing the lie of travel. We need this so that any proposals of new route adjustments can be analyzed by diagram. I say Excel because that is the one we use due to licensing issues.

In other words, the user can enter a street address and type lets say N for the line of travel to be north on that street and left on the next street. If this is too complicated or not the right forum, please let me know.

Thanks,
Kyle

 

[MichaelRed]

Excel database = oxymoron.



MichaelRed

 

[xlbo]

well - no - not really. It works perfectly well as a single table database - what it is not is a relational database.

Having said that, my feeling is that this would be very complicated to do in excel as you would need to have a table of dependancies (which road joins which road) and then a table of turns into and out of each road. You would slo need road lengths and distances between roads / turns. You would then have to have a mapping table to translate the turn direction into the horiz / vertical layout on the map. In short, it is a LOT more complex than you might 1st think. Personally, I'd do a search in google to see if you can find some specific mapping software - I know there is some out there cos Sales people use it for route planning.....

 

[oharab]

there're lots of GIS type applications out there, but if all you are after is a visual representation of the data, you may want to look at google maps & the accompanying API. You'll need to be familliar with Javascript, but it's pretty straight forward.

B.

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[MichaelRed]

Toma'to - To'mato

I guess you can define "it" as ye may. I still think not.



MichaelRed