Document Type

Occasional Paper

Publication Date



Geographic Information Systems (GIS), which are computer-based systems that allow decision makers to incorporate geographically based data into their analyses, are widespread and powerful tools in many business and scientific settings today. In this paper, we present a tutorial discussing ways in which GIS functionality can be implemented within the spreadsheet environment. We show the straightforward and natural analogy between several GIS functions with spreadsheet functions, particularly for raster based data. We present two realistic examples meshing OR/MS methods with GIS methods --- an integration which is greatly enhanced by the “remarkable development platform” provided by spreadsheets. We discuss the many benefits of the spreadsheet enabled seamless integration of geographical data, analysis, and display.


Working Paper #1029.

Included in

Business Commons



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.