Applications of spreadsheet optimization capabilities in teaching planning methods: Facility location and spatial interaction

Journal of Planning Education and Research

Volumn 20, Issue 2, 2000, Pages 247-258

  Ottensmann, John R ^a  

^a INDIANA UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 33750637274     PISSN: 0739456X     EISSN: None     Source Type: Journal    
DOI: 10.1177/0739456X0002000209     Document Type: Article

References (39)

1. Ashley, David W. 1995. A spreadsheet optimization system for library staff scheduling. Computers & Operations Research 22 (6): 615-24.
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-48. New Brunswick, NJ: Center for Urban Policy Research.
4. Brail, Richard K. 1984. The micro in the classroom. Journal of Planning Education and Research 4 (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 Science 25 (3): 313-22.
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 Science 38 (2): 313-27.
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. Interfaces 24 (5): 107-17.
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 Research 12 (3): 184-98.
17. Harris, Daniel C. 1998. Nonlinear least-squares curve-fitting with Microsoft Excel Solver. Journal of Chemical Education 75 (1): 119-21.
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 Science 25 (5): 595-98.
20. Klosterman, Richard E. 1997. Planning support systems: A new perspective on computer-aided planning. Journal of Planning Education and Research 17 (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 Association 51 (2): 216-24.
23. Levine, Ned. 1985. The construction of a population analysis program using a microcomputer spreadsheet. Journal of the American Planning Association 51 (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 Education 74 (4): 448-49.
26. Ottensmann, John R. 1984. Analyzing planning alternatives using electronic spreadsheets. Journal of Planning Education and Research 4 (1): 33-42.
27. _. 1985. BASIC microcomputer programs for urban analysis and planning. New York: Chapman & Hall.
28. _. 1995. Using a gravity model to predict circulation in a public library system. Library & Information Science Research 17 (4): 387-402.
29. _. 1997. Partially-constrained gravity models for predicting spatial interaction with elastic demand. Environment and Planning A 29 (6): 975-88.
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 Research 4 (1): 43-54.
31. ReVelle, Charles. 1991. Siting ambulances and fire companies: New tools for planners. Journal of the American Planning Association 57 (4): 471-84.
32. Rushton, Gerard. 1979. Optimal location of facilities. Wentworth, NH: COMPress.
33. 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 Association 51 (2): 209-15.
35. Sen, Ashish. 1986. Maximum likelihood estimation of gravity model parameters. Journal of Regional Science 26 (4): 461-74.
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. Talanta 42 (4): 561-72.
39. Winston, Wayne L., and S. Christian Albright. 1997. Practical management science: Spreadsheet modeling and applications. Belmont, CA: Duxbury Press.