Consider these popular products
$9.97 Was $10.82Save $0.85
$13.68 List price $22.99Save $9.31
$14.22 Was $15.49Save $1.27
$9.99 Was $14.79Save $4.80
$12.86 Was $13.84Save $0.98
$7.38 Was $13.56Save $6.18
$6.19 Was $6.95Save $0.76
$16.23 Was $20.36Save $4.13
About 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
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
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
Civil, Criminal & Medical Negligence
The subversion of control
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
Alternative Architecture Research
Part V Summary & Conclusion
Appendix A Exercise Solutions:
Garden Wall Exercise Solution
Balloon and Basket Exercise Solution
|Number of Pages:||352|
|Series Title:||Wiley Finance|
|Publisher:||John Wiley & Sons Inc|
|Publication Date:||August, 2016|
|Digital Video Formats:||Hardcover|
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.
Questions will be checked against our question guidelines and posted within five to seven business days.