About Requirement Capture from Microsoft Excel

Requirement Capture is an optional program that is installed on Microsoft ExcelCAS. Requirement Capture can directly capture customer requirements and reduce the chance for error due to incorrect input of customer needs.

See Also
About Requirements Management

A user can import an entire spreadsheet full of data in one action or import a single row of data at a time. Once the data is uploaded into Traceable Requirements Management, the content of the imported requirements and comments can be edited.

Using the Export to Excel command from the dashboard, you can export requirement structure with the Physical ID. Extra output of ID is generated next to the output column if the structure is downloaded in Excel and updates are made using the same downloaded file. The Import capability from Requirement Capture allows you to create a hierarchal requirement structure. In Requirement Capture Excel, you can update a requirement, chapter and comment.

Note: If you are mapping an Excel spreadsheet column containing money amounts to the Estimate Cost Attribute field in Traceable Requirements Management, you must include the monetary unit in each cell's contents (for example: 1 Dollar or 46 Yen). The permitted monetary units are: Euro, Dollar, Won, Yen, Yuan, Renminbi, and Pound.

After you install Requirement Capture, there will be a new Requirement Capture toolbar in Excel. This toolbar contains two icons:

  • 3DEXPERIENCE allows you to navigate to the CAS login page.
  • Import allows you to control the import of row information for making requirements and comments.