Spreadsheet Models Urb and Reg Analy / Edition 1

Hardcover (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $3.69
Usually ships in 1-2 business days
(Save 91%)
Other sellers (Hardcover)
  • All (9) from $3.69   
  • New (2) from $61.89   
  • Used (7) from $3.69   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2008

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.


Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


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 Show Less

Editorial Reviews

From the Publisher
“What can you say about a book that covers everything from gravity models to earthquake risk analysis, includes curve extrapolation and economic base analysis, and ends with The Game of Life Itself?. . . I expect that this book will appeal to a wide audience. As the title indicates, the book presents spreadsheet models that are often used in urban and regional analysis. It contains nineteen models along with complete instructions for their use . . . The authors presume that he or she is at least somewhat familiar with basic spreadsheet procedures (although not necessarily with macros). Most importantly, they assume that the user already knows about the basic analytical techniques themselves. This book is not meant to teach you all you need to know about, for example, input-output or shift-share analysis. This is not a failing of the book; rather, it represents a focus that allows the book to spend its pages on extra models rather than repeating information available elsewhere. Moreover, the authors are consistent in suggesting other sources that present the basics . . . I found the book to be very useful. It demonstrates how powerful spreadsheet macros are . . . [I]t encouraged me to learn about techniques that are new to me by making them seem less intimidating.” —James A. Kurre, Journal of Regional Science “This book can provide an important practical aid to anyone who might need to work in any of the topic areas covered. It can also serve as a relatively easy introduction to the power of spreadsheet modeling.” —George I. Treyz, Growth and Change "Harnesses the open programming environment of the electronic spreadsheet to provide sophisticated modeling capabilities." —Journal of Planning Education and Research "The Center for Urban Policy Research at Rutgers University dominates American publishing in the field of urban housing. . . . Its unique role places it on the frontier of thinking in urban policy." —Ecology Law Quarterly
Published by the Center for Urban Policy Research, Rutgers University, P.O. Box 489, Piscataway, New Jersey 08855-0489. Provides nineteen models with dozens of applications, guidance on using the models, advice on data collection and entry, guidelines for interpreting and using model options, and directions for developing additional applications. All models are included on a disk in Lotus 1-2-3 for IBM compatible systems. No index. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

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

Meet the Author

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.

Earl G. Bossard is professor emeritus of urban and regional planning at San Jose State University.

Richard E. Klosterman is professor in the department of geography and planning at the University of Akron.

Read More Show Less

Table of Contents

1 Spreadsheet Modeling
1 Installing and Using the Models 3
2 Spreadsheet Design Guidelines 11
3 Advanced Spreadsheet Modeling 23
Pt. 2 Demographic Analysis and Forecasting
4 EXTRAP: Curve Fitting/Extrapolation 45
5 SPOP: Small-Area Population Projection 69
6 COHORT: Cohort Component Population Projection 85
7 COMPARE: Comparative Analysis Techniques 107
8 GTEXTRAP: Multiple Region Population Extrapolation 133
Pt. 3 Economic Analysis and Forecasting
9 ECONBASE: Economic Base Analysis 161
10 SHFT-SHR: Local Employment Projection 183
11 INTRO-IO: Introduction to Input-Output Accounting and Modeling 205
12 APRAM: Accounting Price Ratio Analysis 229
Pt. 4 Environmental Analysis and Modeling
13 SMOKE: Air Pollution Dispersion 251
14 RISK-EQ: Earthquake Risk Analysis 271
Pt. 5 Management and Decision Making
15 MANAGER: Project Management 289
16 CROSTIME: Simultaneous Time-Series and Cross-Sectional Analysis 305
17 AHP: Multiple Criteria Evaluation 333
18 CHI-SQR: Chi-Squared Analysis 357
Pt. 6 Other Applications
19 REIA: Real Estate Investment Analysis 377
20 TRANSIT: Guideway Systems Cost Estimation 401
21 RETAIL: Retail Trade Spatial Interaction 419
22 LIFE: The Game 449
Contributors 463
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)