Stockhome: A Spreadsheet Model of Urban Heavy Metal Metabolism

Computer models for analysis,visualising and decision support in environmentalresearch have become increasingly popular. TheStockhome project, where the urban metabolism ofheavy metals in Stockholm was studied, resultedin a database with historical data of the use ofgoods containing cadmium (Cd), chromium (Cr),copper (Cu), lead (Pb), mercury (Hg), nickel (Ni)and zinc (Zn). A spreadsheet model was developedto study flows and stocks of the metalconsumption process and emissions. The modelindicates uncertainties of the data, societalaspects such as field of use and rights ofdisposition of the goods. By considering goods asthe drivers of the emissions, the model would bewell suited for policy support.