Use Excel To Develop A Traceability Matrix: Backstory

Oct. 2, 2008
A subrequirement that derives from multiple primary requirements can be achieved using the concatenation of the cells in the reference coupled with a line-feed character. For example, if CEI requirements 1.3.3 and 1.3.4 drive requirement 2.1.9

The basis of the idea evolved over several years and is a bit disjointed. The actual implementation was an epiphany. In the early 1990s, I was working as a systems engineer at (then named) Spar Aerospace on the specifications for the robotic arm (Canadarm 2) to be mounted on the International Space Station. Part of my job was the maintenance of traceability of requirements between the hierarchy of documents. This responsibility was accentuated when one of the levels of the hierarchy was deleted and the traceability was significantly altered. This work was done manually. I guess this process was then imprinted on my brain.

In my next (and current) position I worked on a project that involved the hierarchy of messages on a multi-line LCD. Continuous requirement changes necessitated the development of a versatile approach to implement the modified message structure quickly and easily.

While writing my book "Excel by Example: A Microsoft Excel Cookbook for Electronics Engineers," I investigated and wrote about the auditing features of Excel, but I took the functions at face value-a support tool to aid with the debugging of a worksheet.

The project involving the LCD messaging was ongoing, and I wanted to develop a better method of composing the four lines of a screen within the context of a hierarchy of screens. It was at this point that I gor the idea (probably in the shower-all y good ideas start there!) that the linkage could be visually displayed using the audit feature of Excel. I don't remember whether the association with the tracebility of requirements was the progenitor of the messaging approach or vice versa. It was just one of those things where the human brain combined several disparate ideas together to generate an elegant solution.

Sponsored Recommendations

What are the Important Considerations when Assessing Cobot Safety?

April 16, 2024
A review of the requirements of ISO/TS 15066 and how they fit in with ISO 10218-1 and 10218-2 a consideration the complexities of collaboration.

Wire & Cable Cutting Digi-Spool® Service

April 16, 2024
Explore DigiKey’s Digi-Spool® professional cutting service for efficient and precise wire and cable management. Custom-cut to your exact specifications for a variety of cable ...

DigiKey Factory Tomorrow Season 3: Sustainable Manufacturing

April 16, 2024
Industry 4.0 is helping manufacturers develop and integrate technologies such as AI, edge computing and connectivity for the factories of tomorrow. Learn more at DigiKey today...

Connectivity – The Backbone of Sustainable Automation

April 16, 2024
Advanced interfaces for signals, data, and electrical power are essential. They help save resources and costs when networking production equipment.


To join the conversation, and become an exclusive member of Electronic Design, create an account today!