Experiments with Geographical Information System (GIS) central places

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

This was an experiment using ACAD LT and the commonly used UBD street directory. UBD map grid references are transformed into Australian Map Grid (AMG) coordinates, and then able to be plotted into ACAD, or plotted on Excel XY chart. VBA macro is used to scan all the location points one at a time, and if within 5km of each other, a simple line defined between the two. This then transformed into ACAD script in the workbook, then copy pasted to ACAD to draw the lines between the locations. The example shows location of Shed Suppliers in Adelaide. Better still is to modify the VBA routines and use nearest neighbours, and triangulation. The 5km radius was chosen because it was a simple approach and 5km/hr is average walking speed: so it connects suppliers within 1 hours walking distance. Or otherwise identifies a lack of facilities in walking distance. Change the data. I have versions with churches, shopping centres, consulting engineers, and location of my projects. Just using Excel alone is a simple way to get a picture. Don't really need maps to over lay. In ACAD I just have the UBD map grid, and that alone is provides useful information, when data points plotted over.

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
05 May 2010
Submitted By:
File Date:
02 May 2010
File Author:
Conrad Harrison
File Version:
File Size:
107.31 Kb
File Type:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Please sign in or register to add a comment.

We have 1 guest and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics