The powerful optimization capabilities included in modern electronic spread-sheets, such as the Solver in Excel, provide opportunities for implementing facility location and spatial interaction models in the spreadsheet environment. Such models are used as part of an integrated public facility location assignment in the teaching of planning methods. These spreadsheet applications provide students with the tools for applying the models to realistic planning problems and illustrate the potential for using electronic spread-sheets for implementing sophisticated planning methods.
Get full access to this article
View all access options for this article.
References
1.
Ashley, David W.1995. A spreadsheet optimization system for library staff scheduling. Computers & Operations Research22 (6): 615-624.
2.
Batty, Michael . 1976. Urban modelling: Algorithms, calibrations, predictions. London: Cambridge University Press.
3.
Bossard, Earl G.1993. RETAIL: Retail trade spatial interaction. In Spreadsheet models for urban and regional analysis, edited by Richard E. Klosterman, Richard K. Brail, and Earl G. Bossard, 419-448. New Brunswick, NJ: Center for Urban Policy Research.
4.
Brail, Richard K.1984. The micro in the classroom. Journal of Planning Education and Research4 (1): 55-60.
5.
Burchell, Robert W. , David Listokin, and William R. Dolphin. 1994. Development impact assessment handbook. Washington, DC: Urban Land Institute.
6.
Cartwright, Timothy J.1993. Modeling the world in a spreadsheet: Environmental simulation on a microcomputer. Baltimore: Johns Hopkins University Press.
7.
Conway, D. G. , and C. T. Ragsdale. 1997. Modeling optimization problems in the unstructured world of spreadsheets. Omega International Journal of Management Science25 (3): 313-322.
8.
Drezner, Tammy . 1995. Competitive facility location in the plane. In Facility location: A survey of applications and methods, edited by Zvi Drezner, 285-300. New York: Springer-Verlag.
9.
Drezner, Zvi . 1995. Facility location: A survey of applications and methods. New York: Springer-Verlag.
10.
Drezner, Zvi , George O. Wesolowsky, and Tammy Drezner. 1998. On the logit approach to competitive facility location. Journal of Regional Science38 (2): 313-327.
11.
Filipovitch, Anthony J.1985. Urban analytical tools: A handbook. Mankato, MN: Urban and Regional Studies Institute, Mankato State University.
12.
Fotheringham, A. S. , and M. E. O’Kelly. 1989. Spatial interaction models: Formulations and applications. Boston: Kluwer Academic.
13.
Ghosh, Avijit , and Sara L. McLafferty. 1987. Location strategies for retail and service firms. Lexington, MA: Lexington Books.
14.
Gleeson, Michael E. , and John R. Ottensmann. 1994. A decision support system for acquisitions budgeting in public libraries. Interfaces24 (5): 107-117.
15.
Goodchild, Michael F. , and Valerian T. Noronha. 1983. Location-allocation for small computers. Monograph No. 8. Iowa City: Department of Geography, University of Iowa.
16.
Harris, Britton , and Michael Batty. 1993. Locational models, geographic information and planning support systems. Journal of Planning Education and Research12 (3): 184-198.
17.
Harris, Daniel C.1998. Nonlinear least-squares curve-fitting with Microsoft Excel Solver. Journal of Chemical Education75 (1): 119-121.
18.
Indianapolis-Marion County Public Library . 1996. Into the 21st century. 5 vols. Indianapolis, IN: Author.
19.
King, Malcolm . 1997. Some comments on “Modeling optimization problems in the unstructured world of spreadsheets.”Omega International Journal of Management Science25 (5): 595-598.
20.
Klosterman, Richard E.1997. Planning support systems: A new perspective on computer-aided planning. Journal of Planning Education and Research17 (1): 45-54.
21.
Klosterman, Richard E. , Richard K. Brail, and Earl G. Bossard, eds. 1993. Spreadsheet models for urban and regional analysis. New Brunswick, NJ: Center for Urban Policy Research.
22.
Landis, John D.1985. Electronic spreadsheets in planning: The case of shiftshare analysis. Journal of the American Planning Association51 (2): 216-224.
23.
Levine, Ned . 1985. The construction of a population analysis program using a microcomputer spreadsheet. Journal of the American Planning Association51 (4): 496-511.
24.
Love, Robert F. , James G. Morris, and George O. Wesolowsky. 1988. Facilities location: Models & methods. New York: North-Holland.
25.
Machuca-Herrera, Juan O.1997. Nonlinear curve fitting using spreadsheets. Journal of Chemical Education74 (4): 448-449.
26.
Ottensmann, John R.1984. Analyzing planning alternatives using electronic spreadsheets. Journal of Planning Education and Research4 (1): 33-42.
27.
Ottensmann, John R.1985. BASIC microcomputer programs for urban analysis and planning. New York: Chapman & Hall.
28.
Ottensmann, John R.1995. Using a gravity model to predict circulation in a public library system. Library & Information Science Research17 (4): 387-402.
29.
Ottensmann, John R.1997. Partially-constrained gravity models for predicting spatial interaction with elastic demand. Environment and Planning A29 (6): 975-988.
30.
Page, G. William , and David S. Sawicki. 1984. Teaching computer and policy analysis skills in a case study course. Journal of Planning Education and Research4 (1): 43-54.
31.
ReVelle, Charles . 1991. Siting ambulances and fire companies: New tools for planners. Journal of the American Planning Association57 (4): 471-484.
Rushton, Gerard , Michael F. Goodchild, and Lawrence M. Ostresh, Jr.1973. Computer programs for location-allocation problems. Monograph No. 6. Iowa City: Department of Geography, University of Iowa.
34.
Sawicki, David S.1985. Microcomputer applications in planning. Journal of the American Planning Association51 (2): 209-215.
35.
Sen, Ashish . 1986. Maximum likelihood estimation of gravity model parameters. Journal of Regional Science26 (4): 461-474.
36.
Sipe, Neil G. , and Robert W. Hopkins. 1984. Microcomputers and economic analysis: Spreadsheet templates for local government. Gainesville: Bureau of Business and Economic Research, University of Florida.
37.
U.S. Bureau of the Census . 1992. Census of population and housing, 1990. Summary tape file 3 on CD-ROM. Washington, DC: Author.
38.
Walsh, S. , and D. Diamond. 1995. Nonlinear curve fitting using Microsoft Excel Solver. Talanta42 (4): 561-572.
39.
Winston, Wayne L. , and S. Christian Albright. 1997. Practical management science: Spreadsheet modeling and applications. Belmont, CA: Duxbury Press.
