Skip to main content
Spreadsheet-based GIS Models
College of Management Working Papers and Reports
  • Roger Blake, University of Massachusetts Boston
  • Jeffrey Keisler, University of Massachusetts Boston
  • Janet Wagner
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.

Community Engaged/Serving
No, this is not community-engaged.
Citation Information
Roger Blake, Jeffrey Keisler and Janet Wagner. "Spreadsheet-based GIS Models" (2007)
Available at: