Spreadsheet Models for Urban and Regional Analysis

Electronic spreadsheets are second only to word processors as the most widely used computer software tool. They are user friendly: easy to learn, forgiving of errors, and useful with minimal knowledge of computer fundamentals. Their simple format and logical structure provide an environment for examining quantitative problems that can be formulated as two-dimensional tables. In addition, their ability to report the results of changing values stored in the spreadsheet allows analysts to quickly and easily conduct "what-if" analyses, examining the implications of alternative policy choices and different assumptions.

This workprovides nineteen spreadsheet models that can be used for a wide range of urban and regional analysis and planning applications. They incorporate a common set of procedures for entering data, conducting analyses, and displaying results. This makes it easy for users to become familiar with and use the different models provided in the collection. The models also provide internal documentation allowing users to understand how the models operate and modify them to suit their needs.

This definitive guide to spreadsheet applications in urban and regional analysis describes the typographical conventions used and provides detailed instructions for using the models. The book also describes the models’ intended application and conceptual basis, the different components of the models, specialized commands and options; sources and procedures for entering required data; guidelines for interpreting and using outputs; and references for further information. It will appeal to professionals, instructors, and students in planning and related fields.

Richard K. Brail is professor emeritus in the Urban Planning and Policy Development Program, Edward J. Bloustein School of Planning and Public Policy at Rutgers University.