Modeling the World in a Spreadsheet
Environmental Simulation on a Microcomputer
Published on 1. October 1993
Book
Hardback
364 pages
978-0-8018-4596-3 (ISBN)
Description
Thanks to the spreadsheet, simulation modelling is now accessible to anyone with a microcomputer. In this book, the author aims to explain how to create models of different environmental phenomena. These range from natural processes such as the dispersion of water and air pollution, to social processes such as housing affordability. The book offers complete "recipes" for building and running the models in the most popular spreadsheet programs, such as: Lotus 1-2-3, SuperCalc, Excel and Quatro. A 3.5" diskette, containing Lotus or SuperCalc data files for all 14 models may be ordered, using a tear-out card accompanying the book (spreadsheet software is required).
Reviews / Votes
"Harness[es] the open programming environment of the electronic spreadsheet to provide sophisticated modeling capabilities to virtually any planner, and even to the citizen activist with a high school mathematics background. By bringing urban and environmental models closer to their real-world planning circumstances, this book will further the democratization of modeling in planning practice."--'Journal of Planning Education and Research' Contents 'Modeling Natural Systems' Blowing Smoke: Atmospheric Dispersion of Air Pollution Running Water: The Underground Transport of Pollutants Preserving the Species: Determining Minimum Viable Population Sustainable Yield: Managing the Forest for the Trees Here Comes the Sun: Solar Energy from a Flat-Plate Collector 'Modeling Social Systems' Macroeconomic Policy: Econometrics and the Klein Model Urban Form: The Lowry Model of Population Distribution Affordable Housing: The Bertaud/World Bank Model Traffic on the Roads: Modeling Trip Generation and Trip Distribution Throwing Things Away: A Model for Waste Management Apples and Oranges: An Environmental Impact Assessment Model 'Modeling Artificial Systems' Life in a Spreadsheet: John Conway's Game The Game of Choice: Neighborhood Tolerance The Game Machine: Cellular Automations Recipes for Building the ModelsMore details
Edition
Illustrated edition
Language
English
Place of publication
Baltimore, MD
United States
Target group
College/higher education
Edition type
Illustrated edition
Illustrations
Illustrations
Dimensions
Height: 229 mm
Width: 152 mm
Weight
870 gr
ISBN-13
978-0-8018-4596-3 (9780801845963)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part 1 Modelling natural systems: blowing smoke - atmospheric dispersion of air pollution; running water - the underground transport of pollutants; preserving the species - determining minimum viable population; sustainable yield - managing the forest for the trees; here comes the sun - solar energy from a flat-plate collector. Part 2 Modelling social systems: macroeconomic policy - econometrics and the Klein model; urban form - the Lowry model of population distribution; affordable housing - the Bertraud/World Bank model; traffic on the roads - modelling trip generation and trip distribution; throwing things away - a model for waste management; apples and oranges - an environmental impact assessment model. Part 3 Modelling artificial systems: life in a spreadsheet - John Conway's game; the game of choice - neighbourhood tolerance; the game machine - cellular automations; recipes for building the models.