Spreadsheet Models Urb and Reg Analy / Edition 1

Spreadsheet Models Urb and Reg Analy / Edition 1

by Richard K. Brail
     
 

ISBN-10: 088285142X

ISBN-13: 9780882851426

Pub. Date: 01/28/1993

Publisher: CUPR/Transaction

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

…  See more details below

Overview

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 work provides 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.

Read More

Product Details

ISBN-13:
9780882851426
Publisher:
CUPR/Transaction
Publication date:
01/28/1993
Edition description:
BK&DISK
Pages:
487

Table of Contents

Tables
Exhibits
Figures
Acknowledgments
Introduction
1Spreadsheet Modeling
1Installing and Using the Models3
2Spreadsheet Design Guidelines11
3Advanced Spreadsheet Modeling23
Pt. 2Demographic Analysis and Forecasting
4EXTRAP: Curve Fitting/Extrapolation45
5SPOP: Small-Area Population Projection69
6COHORT: Cohort Component Population Projection85
7COMPARE: Comparative Analysis Techniques107
8GTEXTRAP: Multiple Region Population Extrapolation133
Pt. 3Economic Analysis and Forecasting
9ECONBASE: Economic Base Analysis161
10SHFT-SHR: Local Employment Projection183
11INTRO-IO: Introduction to Input-Output Accounting and Modeling205
12APRAM: Accounting Price Ratio Analysis229
Pt. 4Environmental Analysis and Modeling
13SMOKE: Air Pollution Dispersion251
14RISK-EQ: Earthquake Risk Analysis271
Pt. 5Management and Decision Making
15MANAGER: Project Management289
16CROSTIME: Simultaneous Time-Series and Cross-Sectional Analysis305
17AHP: Multiple Criteria Evaluation333
18CHI-SQR: Chi-Squared Analysis357
Pt. 6Other Applications
19REIA: Real Estate Investment Analysis377
20TRANSIT: Guideway Systems Cost Estimation401
21RETAIL: Retail Trade Spatial Interaction419
22LIFE: The Game449
Contributors463

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >