Consider these popular products

Spreadsheet Risk

This Item is no longer available
We're unable to show you buying options for this item.

About this item

Important Made in USA Origin Disclaimer: For certain items sold by Walmart on Walmart.com, the displayed country of origin information may not be accurate or consistent with manufacturer information. For updated, accurate country of origin data, it is recommended that you rely on product packaging or manufacturer information.
Hardcover, John Wiley & Sons Inc, 2010, ISBN13 9780470748541, ISBN10 0470748540

About this item

Important Made in USA Origin Disclaimer: For certain items sold by Walmart on Walmart.com, the displayed country of origin information may not be accurate or consistent with manufacturer information. For updated, accurate country of origin data, it is recommended that you rely on product packaging or manufacturer information.

Hardcover, John Wiley & Sons Inc, 2010, ISBN13 9780470748541, ISBN10 0470748540

This book offers a variety of strategies and tactics that financial institutions can employ to manage their exposure to this significant business risk. It is the first book to comprehensively address the many problems caused by the widespread and naive use of spreadsheets in organisations.

The book explores the notion that users do not take into account that through their use of a spreadsheet to solve a problem, they are deploying a complex software application. Technology can be faulty, but also spreadsheets are used, misused, abused and through the non-adoption of any of the disciplines of software engineering. The apparently simple task of creating a spreadsheet, for example, to calculate the cost of building a garden wall will be frequently performed incorrectly unless independent and comprehensive testing has taken place. Given that most financial spreadsheets are significantly more complex than this, it is essential that spreadsheet users come to understand how careful they must be in reaching decisions that are supported by spreadsheet models.

The purpose of the book is to lay bare the various risks of using spreadsheets, supported by a comprehensive summary of the well-established academic and commercial research on the subject. The book will include some simple exercises for the reader to perform which will support the truth of the research being reported.

The book outlines a set of strategies and tactics which can be put in place to control the risks of using spreadsheets, and introduces the emerging discipline of spreadsheet engineering. It considers technological solutions to spreadsheet risk, looking also at the alternatives to using spreadsheets.

Table of Contents

Preface

Introduction

Part I Spreadsheet Risks

The Cell Error Rate .

The Spreadsheet Error Rate

The Impact of Errors
Types of Error

The Ubiquity of Spreadsheets
The Ubiquity of Spreadsheet Error
Human Aspects
Overconfidence
Interpretation
Fraud
Employee Migration

Machine Aspects

Legal Aspects
Companies Acts
Sarbanes Oxley
Civil, Criminal & Medical Negligence
Other Regulation
The subversion of control

Documentation

Archiving and Backup

Part II Remediating the Risks

Assessing the problem

Determining Importance & Criticality .

Identifying Spreadsheets to test

Testing & Correcting Spreadsheets

Maintaining System Integrity

The Challenges of Organisational Spreadsheet Remediation

Part III Spreadsheet Engineering

The Software Development Lifecycle

The Eight Principles of Spreadsheet Engineering

Designing, Building and Testing Better Spreadsheets

Spreadsheet Use, Maintenance, Backup, Archival and Disposal

Promulgating Spreadsheet Engineering

Part IV Spreadsheet Alternatives

A History of Alternatives
Commercial Alternatives

Alternative Architecture Research

Part V Summary & Conclusion

Appendix A Exercise Solutions:
Garden Wall Exercise Solution
Balloon and Basket Exercise Solution
Other exercises

Chapter Notes
References
Bibliography
Index

Specifications

Number of Pages: 352
Languages: English
Author: Croll, Grenville
Series Title: Wiley Finance
Publisher: John Wiley & Sons Inc
Publication Date: August, 2016
ISBN-13: 9780470748541
Digital Video Formats: Hardcover
ISBN-10: 0470748540
Show

Customer Reviews

Be the first to review this item. Share your rating and review so that other customers can decide if this is the right item for them.

Customer Q&A

Back
Questions & Answers 0 questions

Ask a question

If you would like to share feedback with us about pricing, delivery or other customer service issues, please contact customer service directly.


Q&A tips and guidelines

Q&A Exchange Guidelines

When writing your question or answer, please follow these guidelines:

  • Do: Make sure your question is directly related to the product
  • Do: Be specific and provide as many details as possible
  • Do: Include the model number (if applicable)
  • Do: Write your question in English
  • Do Not: Include personal information (such as your full name)
  • All submitted questions and answers are subject to the terms set forth in our Terms and Conditions

We reserve the right not to post your question or answer if it contains any of the following:

  • Any information not related to the actual merchandise or topic
  • Obscenities, discriminatory language or other language not suitable for a public forum
  • Advertisements or “spam” content
  • Email addresses, physical addresses or other forms of contact information
  • Critical or spiteful comments on other questions or answers posted on the page or their authors
  • Any imagery that demonstrates incorrect use of the merchandise
  • Anything that Walmart deems to be inappropriate, at Walmart's discretion

Provide as many details as possible, including the model number (if applicable).

Remember: Don’t include personal information (such as your full name).


Preview Question

Thank you.

Questions will be checked against our question guidelines and posted within five to seven business days.

Policies & Plans

See any care plans, options and policies that may be associated with this product.

Gifting plans

Gift options are not available for this item.

Pricing policy

About our prices
We’re committed to providing low prices every day, on everything. So if you find a current lower price from an online retailer on an identical, in-stock product, tell us and we’ll match it. See more details at Online Price Match.