Software Testing & QA Online Community > Detail: Defect Depletion and Cost Analysis Spreadsheet
Defect Depletion and Cost Analysis Spreadsheet
By Ed Weller
May 11, 2001
Summary: This spreadsheet can be used to demonstrate the value of early defect removal, using defect depletion curves or phase containment effectiveness calculations, in terms of quality and productivity (reduced cost). The user can input the project size and defect injection rates per unit of size for development phases, and defect removal rates via reviews or inspections, and test. It also allows for defect introduction via bad fixes in test (recidivism rate).
It provides a good picture of project quality versus goals.
View Content Detail:
XUS328600file1.xls (24 Kb)
About the Author
Ed Weller has recently joined Software Technology Transition, providing software process improvement consulting services. In a 30+-year career spanning hardware, software, test, systems, and process engineering, he has developed a process-oriented view to product development that is closely tied to the organization's business needs. He has over 30 publications to his credit, including the 1993 IEEE Software's Best Article of the Year award for "Lessons from Three Years of Inspection Data," and has presented over 20 tutorials and talks at conferences and seminars. He is widely recognized for his knowledge in software engineering, including inspections, metrics, project management, software maintenance, test management, and applications of statistical process control to software development processes. He can be contacted at email@example.com
Back to Top