Advanced Search

Journal Navigation

Journal Home

Subscriptions

Archive

Contact Us

Table of Contents

Click here to sign up for SAGE Journal Email Alerts today!
Journal of Planning Education and Research
This Article
Right arrow Full Text (PDF)
Right arrow References
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Right arrow Citation Map
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Alert me to new issues of the journal
Right arrow Add to Saved Citations
Right arrow Download to citation manager
Right arrowRequest Permissions
Right arrow Request Reprints
Right arrow Add to My Marked Citations
Citing Articles
Right arrow Citing Articles via Google Scholar
Right arrow Citing Articles via Scopus
Google Scholar
Right arrow Articles by Ottensmann, J. R.
Right arrow Search for Related Content
Social Bookmarking
Add to CiteULike   Add to Connotea   Add to Del.icio.us   Add to Digg   Add to Reddit   Add to Technorati  
What's this?

Applications of Spreadsheet Optimization Capabilities in Teaching Planning Methods

Facility Location and Spatial Interaction

John R. Ottensmann

Indiana University School of Public and Environmental Affairs in Indianapolis, jottensm{at}iupui.edu

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.

Journal of Planning Education and Research, Vol. 20, No. 2, 247-258 (2000)
DOI: 10.1177/0739456X0002000209
Add to CiteULike CiteULike   Add to Connotea Connotea   Add to Del.icio.us Del.icio.us   Add to Digg Digg   Add to Reddit Reddit   Add to Technorati Technorati    What's this?