Main Content

Link to Requirements in Excel Workbooks

With Simulink® Requirements™, you can create direct links from linkable items such as Simulink blocks or test cases to requirements in Microsoft® Excel®. You can only create direct links to requirements in Microsoft Excel on Windows® platforms.

Navigate from a Model Object to Requirements in an Excel Workbook

  1. Open the example model. At the command line, enter:

    slvnvdemo_fuelsys_officereq
  2. In the Apps tab, click Requirements Manager. In the Requirements tab, click Highlight Links to highlight the model objects with requirements.

  3. Right-click the Test inputs Signal Builder block and select Requirements > 1. “Normal mode of operation”.

    The slvnvdemo_FuelSys_TestScenarios.xlsx file opens, with the associated cell highlighted.

Keep the example model and workbook open.

For information about creating requirements links in Signal Builder blocks, see Link Signal Builder Blocks to Requirements and Simulink Model Objects.

Create Requirements Links to the Workbook

  1. At the top level of the slvnvdemo_fuelsys_officereq model, right-click the speed sensor block and select Requirements > Open Outgoing Links dialog.

    The Requirements Traceability Link Editor opens.

  2. To create a requirements link, click New.

  3. In the Description field, enter:

    Speed sensor failure

    You will link the speed sensor block to the Speed Sensor Failure information in the Excel requirements document.

  4. When you browse and select a requirements document, the RMI stores the document path as specified by the Document file reference option on the Requirements Settings dialog box, Selection Linking tab.

    For information about which setting to use for your working environment, see Document Path Storage.

  5. At the Document field, click Browse to locate and open the slvnvdemo_FuelSys_TestScenarios.xlsx file.

    The Document Type field information changes to Microsoft Excel.

  6. In the workbook, the Speed sensor failure information is in cells B22:E22. For the Location (Type/Identifier) field, select Sheet range and in the second field, enter B22:E22. (The cell range letters are not case sensitive.)

  7. Click Apply or OK to create the link.

  8. To confirm that you created the link, right-click the speed sensor block and select Requirements > 1. “Speed sensor failure”.

    The workbook opens, with cells B22:E22 highlighted.

Keep the model and Excel file open.

Link Multiple Model Objects to a Microsoft Excel Workbook

You can use the same technique to link multiple model objects to a requirement in a Excel workbook. Follow this workflow:

  1. In the model window, select the objects to link to a requirement.

  2. Right-click one of the selected objects and select Requirements > Open Outgoing Links dialog.

  3. When you browse and select a requirements document, the RMI stores the document path as specified by the Document file reference option on the Requirements Settings dialog box, Selection Linking tab.

    For information about which setting to use for your working environment, see Document Path Storage.

  4. Use the Link Editor to specify information about the Excel requirements document, the requirement, and the link.

  5. Click Apply or OK to create the link.

Change Requirements Links

  1. In the slvnvdemo_fuelsys_officereq model, right-click the MAP sensor block and select Requirements > Open Outgoing Links dialog.

    The Requirements Traceability Link Editor opens displaying the information about the requirements link.

  2. In the Description field, enter:

    MAP sensor test scenario

    The Keyword field contains the tag test. User tags filter requirements for highlighting and reporting.

    Note

    For more information about keywords, see Filter Requirements with User Tags.

  3. Click Apply or OK to save the change.

Keep the example model open.