Skip to main content

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.

This is a preview of subscription content, access via your institution.


  • Alveteg, M., Walse, C. and Warfinge, P.: 1998, Water, Air, and Soil Pollut. 104, 269–283.

    Google Scholar 

  • Baccini, P. and Bader, H.: 1996, Regionaler Stoffhaushalt, Spektrum, Heidelberg.

    Google Scholar 

  • Boonpragob, K. and Santisirisomboon, J.: 1996, Water, Air, and Soil Pollut. 92, 107–117.

    Google Scholar 

  • EEA: 1998, Europe's Environment: The 2nd Assessment, European Environment Agency, Copenhagen.

    Google Scholar 

  • Hallerdt, B. and Lindroth, C.: 1992, Stockholms tekniska historia, 5 Ljus, kraft, värme. Energiförsörjning i Stockholm 1853–1992, Liber, Stockholm.

    Google Scholar 

  • Hedbrant, J. and Sörme, L.: 2001, ‘Data vagueness and uncertainties in an urban heavy metal data collection’, 2001, Water, Air, and Soil Pollution: Focus 1(3–4), 43–53.

    Google Scholar 

  • Lohm, U., Bergbäck, B., Hedbrant, J., Jonsson, A., Svidén, J., Sörme, L. and Östlund, C.: 1997a, Databasen Stockhome. Flöden och ackumulation av metaller i Stockholms teknosfär, Tema V Rapport 25, Department of water and environmental studies, Linköping University, Linköping.

    Google Scholar 

  • Lohm, U., Bolund, P., Lövkvist, A., Möller, J., Palm, V., Steen, P. and Anderberg, S.: 1997b, Kartläggning. Internationell forskning om uthållig utveckling. Material-och varuflöden, AFRreport 165, Swedish Environmental Protection Agency, Stockholm.

    Google Scholar 

  • Nwaogazie, I. and Ogelle, E.: 1997, Water, Air, and Soil Pollut. 100, 197–212.

    Google Scholar 

  • OECD: 1993, Environmental Monograph, OECD Core set of indicators for environmental performance reviews, Organisation for Economic Cooperation and Development, Paris.

    Google Scholar 

  • Sinha, R., Small, M., Ryan, P., Sullivan, T. and BJ, C.: 1998, Water, Air, and Soil Pollut. 105, 617–642.

    Google Scholar 

  • Sörme, L., Bergbäck, B. and Lohm, U.: 2001, ‘Goods in the anthroposphere as a metal emission source–a case study of Stockholm, Sweden’, 2001, Water, Air, and Soil Pollution: Focus 1(3–4), 213–228.

    Google Scholar 

  • Tarr, J. and Ayres, R.: 1990, ‘The Hudson-Raritan Basin’, in B. Turner (ed.), The Earth as Transformed by Human Action. Global an Regional Changes in the Biosphere over the Past 300 Years, Cambridge University Press, Cambridge.

    Google Scholar 

  • Van der Voet, E., Kleijn, R., van Oers, L., Heijungs, R., Huele, R. and Mulder, P.: 1995, Environ. Sci. and Pollut. Res. 2, 89–96.

    Google Scholar 

Download references

Author information

Authors and Affiliations


Rights and permissions

Reprints and Permissions

About this article

Cite this article

Hedbrant, J. Stockhome: A Spreadsheet Model of Urban Heavy Metal Metabolism. Water, Air, & Soil Pollution: Focus 1, 55–66 (2001).

Download citation

  • Issue Date:

  • DOI:

  • data organisation
  • data presentation
  • heavy metals
  • mathematical model
  • spreadsheet