 |
 Examples
of what goes wrong with Spreadsheets that affect the environment
|
|
|
Below are stories relating to spreadsheet errors found
in environmental calculations. Remember also, that these are the published stories only. We know of many
other that cannot be published, and it would surprise us if any large
organisation could claim to never having a spreadsheet error in the years
they have been operating. |
If you already know that spreadsheet errors are an issue, then why not
see how a tool like Spreadsheet Professional can assist you. See more on
the Spreadsheet Professional pages.
All
stories courtesy the European Spreadsheet Risks Interest Group Site www.eusprig.org
| Environment |
A Cleaner Future for BC's Polluting Pulp Mills by
Peter Ronald, campaign coordinator, Georgia Strait Alliance 2001
Spreadsheet error results in a company underreporting its
total reduced sulphur (TRS) emissions by 32 times for the past
14 years.Technical Memorandum Superfund JE Model
Spreadsheet Error By Eric Wannamaker, EnviroGroup Ltd July 2004
A VLOOKUP error in the US EPA Superfund Spreadsheet
results in inaccurate calculations with regards the disposal of
toxic wastes through groundwater. This meant that the EPA could
not accurately prioritize the sites to clean.
To see how this error happens with VLOOKUP in excel, view the
VLOOKUP errors clip.
1999
Vemco spreadsheet errors result in problems in calculations of
material usage and emission rates. As a result they were
unknowingly violating permit requirements.CANADIAN
ENVIRONMENTAL PROTECTION ACT, 1999 Estimated Incremental Capital
and Operating Costs, 2002 to 2016
A spreadsheet mistake results in a $100 million
understatement of capital and operating costs. |
| |
|
Quick Links:
Main War
Stories Page
Agriculture
Biotechnology/ Pharmaceutical/ Medical/ Science
Charity
Construction
Consulting
Education
Environment
Financial institutions/ Asset Management/ Private Equity/ Mergers and Acquisitions etc
Insurance
Mining
Storage
Technology
Telecommunication
Transportation
Utility
Government
|
