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

  • Ottensmann J
  • 6


    Mendeley users who have this article in their library.
  • 1


    Citations of this article.


The powerful optimization capabilities included in modern electronic spreadsheets, 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 spreadsheets for implementing sophisticated planning methods.

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document


  • John R. Ottensmann

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free