Of Maps and Macros: Object-Oriented Spreadsheet GIS

S Cole
Additional contact information
S Cole: Center for Regional Studies, School of Architecture and Planning, State University of New York at Buffalo, Buffalo, NY 14214, USA

Environment and Planning B, 1998, vol. 25, issue 2, 227-243

Abstract: I explain how object-oriented mapping may be carried out in spreadsheets, by use of simple user-created maps and macros. The method has uses for teaching, research, and policy. The advantage over current add-in mapping is that the macros can be written by users with basic spreadsheet skills, the procedures are relatively fast, new maps may be drawn or imported, and the macros can be adapted to a variety of applications such as real-time animation, or used in planning situations where ‘time is of the essence’. The paper raises a number of issues as to the inflexibility of some GIS modeling capabilities and spreadsheet mapping capability. The approach is illustrated for Quattro Pro for Windows and Excel with Visual Basic, with two classroom applications, and extensions to decision support, animation, and cellular modeling.

Date: 1998
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://journals.sagepub.com/doi/10.1068/b250227 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:sae:envirb:v:25:y:1998:i:2:p:227-243

DOI: 10.1068/b250227

Access Statistics for this article

More articles in Environment and Planning B
Bibliographic data for series maintained by SAGE Publications ().