Fifty North Sea oil & gas investment transactions were analysed using
traditional spreadsheet based financial modelling methods. The purpose of the
analysis was to determine if there was a statistically significant relationship
between the price paid for an oil & gas asset and the actual or expected
financial return over the asset's economically useful life.
The purpose of this report is to show that computer and allied technologies
can be used to increase energy efficiency. The report is divided into
transport, industrial, commercial and domestic sections, which correspond to
the major energy consuming sectors of the economy. Each section considers the
various ways in which energy can be saved by the use of the computer. The
report concludes that it is economic to incorporate computer based energy
management systems in a wide variety of applications and that it is important
that this capability is realised on a large scale.
We briefly review the well-known risks, weaknesses and limitations of
spreadsheets and then introduce some more. We review and slightly extend our
previous work on the importance and criticality of spreadsheets in the City of
London, introducing the notions of ubiquity, centrality, legality and
contagion. We identify the sector of the financial market that we believed in
2005 to be highly dependant on the use of spreadsheets and relate this to its
recent catastrophic financial performance.