Grenville J. Croll

  1. Evaluating Financial Model Performance: An Empirical Analysis of Some North Sea Investments.

    Authors: Grenville J. Croll, David F. Baker, Ola Lawal
    Subjects: Computers and Society
    Abstract

    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.

  2. Computers and the Conservation of Energy.

    Authors: Grenville J. Croll
    Subjects: Computers and Society
    Abstract

    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.

  3. Spreadsheets and the Financial Collapse.

    Authors: Grenville J. Croll
    Subjects: Computers and Society
    Abstract

    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.

RSS-материал