Modeling the World in a Spreadsheet: Environmental Simulation on a Microcomputer
Timothy J. Cartwright · 1993
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.