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.
Get full access to this article
View all access options for this article.
References
1.
AangeenbrugR, 1992, “Editorial: Special issue on Geographic Information Systems education”International Journal of Geographic Information Systems63
2.
AlbaredesG, 1993, “Dynamic GIS”GIS Europe July 32–35
3.
BattyM, 1995a, “Urban planning and planning support systems—editorial introduction”Regional Development Dialog16 (1) v–xiii
4.
BattyM, 1995b, “Urban modeling in computer-graphic and GIS environments”Environment and Planning B: Planning and Design19689–708
5.
BattyMXieY, 1994a, “Modeling inside GIS: Part 1. Exploratory spatial data analysis and aggregation”International Journal of GIS8291–307
6.
BattyMXieY, 1994b, “Modeling inside GIS: Part 2. Selecting and calibrating urban models using Arc/Info”International Journal of GIS8451–470
7.
BrailR, 1987Microcomputers in Urban Planning and ResearchCenter for Urban Policy Research, Rutgers University, New Jersey
8.
ClarkeK, 1997Getting Started with Geographic Information Systems (Prentice-Hall, Englewood Cliffs, NJ)
9.
ColeS, 1995a, “A spreadsheet approach to GIS”Environment and Planning B: Planning and Design22131–148
10.
ColeS, 1995b, “Developing a framework for planning support systems: A comment. Special issue on urban planning and planning support systems”Regional Development Dialogue16 (1) 49–52
11.
ColeS, 1996a, “A GIS-based many-region disaster preparedness model for the United States”, Third International Conference on Integrating GIS and Environmental Modeling, Santa Fe, New Mexico, January; copy available from the National Center for Geographic Information and Analysis, Santa Barbara, CA
12.
ColeS, 1996b, “Economic cultures and ecology in a small Caribbean island”, in Historical and Analytical Approaches to Ecological Economics Eds van der BergJvan den StraatenJ, (Island Press, Washington, DC) pp 231–270
13.
CHE, 1995, “The nation”Chronicle of Higher Education Almanac September, pages 5–90
14.
ESRI Inc., 1995, Environmental Systems Research Institute, Redlands, CA
15.
ArcView User's Guide
16.
Getting to know Desktop GIS
17.
FosterKPerryDShefferJTaylorH, 1996, “Governance in Erie County: A foundation for understanding and action”The Governance Project, Office of the President, University of Buffalo, NY
18.
FotheringhamSRogersonP, 1994Spatial Analysis and GIS (Taylor and Francis, New York)
19.
Goodchild M, Haining R, Wise S, and twelve others, 1992, “Integrating GIS and spatial data analysis: Problems and possibilities”International Journal of Geographic Information Systems6407–423
20.
GoodchildM, 1996, “Directions in GIS: Progress and future directions.” Plenary presentations, Third international conference on integrating GIS and environmental modeling, Santa Fe, New Mexico, January; copy available from the National Center for Geographic Information and Analysis, Santa Barbara, CA
21.
GuarisoGWerthnerH, 1991Environmental Decision Support Systems (Ellis Harwood, New York)
22.
HarrisBBattyM, 1993, “Locational models, geographic information, and planning support systems”Journal of Planning Research and Education12184–198
23.
HuxoldW, 1991An Introduction to Geographic Information Systems (John Wiley, New York)
24.
HawkeD, 1992, “GIS TT: A geographic information system teaching tool”International Journal of Geographic Information Systems6291–298
25.
InnesJSimpsonM, 1993, “Implementing GIS for planning”APA Journal59230–234
26.
JacobsonR, 1994Microsoft Excel Visual Basic for Applications: Step by Step (Microsoft Press, Redmond, Washington, DC)
27.
KaufmanSSimmonsR, 1995, “Quantitative and research methods in planning: Are schools teaching what practitioners practice?”Journal of Planning Education and Research15 (1) 17–34
28.
KlostermanRBrailRBossardE, 1992Spreadsheet Models for Urban and Regional Analysis (Rutgers University Press, New Brunswick, NJ)
29.
LandisJ, 1985, “Electronic spreadsheets in planning”APA Journal51216–224
30.
LoveRMorrisJWesolowskyG, 1990Facilities Location (North-Holland, New York)
MartinD, 1991Geographic Information Systems and their Socioeconomic Applications (Routledge, New York)
33.
MathewsMSeymourS, 1994Excel for Windows: The Complete Reference (McGraw-Hill, New York)
34.
MonmonierM, 1991How to Lie with Maps (University of Chicago Press, Chicago, IL)
35.
Quattro Pro, 1994Users Guide: Version 6 (Novell Applications Group, Orem, Utah)
36.
PopMap, 1994United Nations Integrated Software Package for Geographic Information, Maps and Graphics Database (United Nations, New York)
37.
REIS, 1995, “Regional Economic Information System 1969–1993”, US Department of Commerce, Washington, DC
38.
SipeNHopkinsR, 1984Microcomputers and Economic Analysis: Spreadsheet Templates for Local Government BEBR monograph number 2, Bureau of Economic and Business Research, University of Florida, Gainesville, Florida
39.
Software Illustrated, 1994MapLand: Spreadsheet Mapping for Microsoft Excel/Quattro Pro for Windows UsersSoftware Illustrated, Pleasanton, CA
40.
SteinbeckJ, 1935Of Mice and Men (Vintage, New York)
41.
ToblerW, 1967, “Of maps and matrices”Journal of Regional Science7275–280
