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

  • Ottensmann J
  • 6

    Readers

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

    Citations

    Citations of this article.

Abstract

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

Authors

  • 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