Requirements Completeness Excel Macro
The requirements completeness macro may save tens of thousands of dollars over the life of a project by automatically proving that the system requirements are complete and unambiguous.
Within the requirements specification, a functional requirement is unambiguous if all of the data items that are mentioned in the requirement can be traced through a series of other requirements to the system inputs. A set of functional requirements is complete if all of the requirements are unambiguous.
The requirements completeness macro takes a set of functional requirements and determines if all of the system outputs can be derived from the system inputs through an unbroken chain of requirements. The requirements start out as English language statements. The user generates a summary of the data used in each requirement. The macro checks the summary for completeness.
The Requirements Completeness Excel Macro is free and is in the public domain.
Requirements Completeness Tutorial.pdf contains an extended example, in tutorial format, that shows most of the functions of the requirements completeness macro. It also shows several of the common problems that occur when dealing with an existing set of incomplete and ambiguous requirements, and the solutions that are available. There are five example spreadsheets that go with the various stages of the tutorial. And to go with each spreadsheet there is a requirements analysis diagram in PDF format.
Requirements Completeness Quick Reference.pdf contains a description of all of the key words that are supported by version 2 of the completeness macro. There is a spreadsheet and two requirements analysis diagrams that go with the quick reference.
Release_Notes.pdf documents the changes that have been made to the macro in each release.
Requirements_Completeness_Unit_Test.xls is a spreadsheet that is used for debugging the requirements completeness macro. In addition to showing how each key word is used, it shows most of the ways in which they could be mis-used. It is included in the hope that it will be useful to someone reimplementing the macro in DOORS or Requisite Pro.