Modeling the World in a Spreadsheet
Environmental Simulation on a Microcomputer
Published on 1. October 1993
Book
Paperback/Softback
364 pages
978-0-8018-4597-0 (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).
More details
Language
English
Place of publication
Baltimore, MD
United States
Target group
College/higher education
Illustrations
Illustrations
Dimensions
Height: 229 mm
Width: 152 mm
Weight
700 gr
ISBN-13
978-0-8018-4597-0 (9780801845970)
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.