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 Tutorial.pdf

doit.bat.txt to convert .txt to .pdf

Requirements_Completeness_Example_1.xls
Requirements_Completeness_Example_1.txt
Requirements_Completeness_Example_1.pdf

Requirements_Completeness_Example_2.xls
Requirements_Completeness_Example_2.txt
Requirements_Completeness_Example_2.pdf

Requirements_Completeness_Example_3.xls
Requirements_Completeness_Example_3.txt
Requirements_Completeness_Example_3.pdf

Requirements_Completeness_Example_4.xls
Requirements_Completeness_Example_4.txt
Requirements_Completeness_Example_4.pdf

Requirements_Completeness_Example_5.xls
Requirements_Completeness_Example_5.txt
Requirements_Completeness_Example_5.pdf

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.

Requirements Completeness Quick Reference.pdf

Requirements_Completeness_Quick_Reference.bat.txt to convert .txt to .pdf

Requirements_Completeness_Quick_Reference_Example.xls
Requirements_Completeness_Quick_Reference_Example.txt
Requirements_Completeness_Quick_Reference_Example.pdf

Requirements_Completeness_Quick_Reference_Example_Control_Relay.txt
Requirements_Completeness_Quick_Reference_Example_Control_Relay.pdf

Release_Notes.pdf documents the changes that have been made to the macro in each release.

Release_Notes.pdf

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.

Requirements_Completeness_Unit_Test.xls

1 comment to Requirements Completeness Excel Macro

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>