基于Excel和VBA编程的需求跟踪矩阵工具开发

摘要

From the requirement management process, it was developed a tool of requirement traceability matrix based on Excel and VBA. The function of requirements allocation, partition, mergence and coverage were implemented in the Excel. The window interface was easy to use, the tool was highly portable. The informatization of requirement management could improve the efficiency of daily work.%从需求管理流程出发,针对需求跟踪矩阵开发了一套基于Excel和VBA编程的辅助工具,在Excel表格中实现了需求分类、拆分、合并、覆盖的功能,窗口界面操作方便,工具可移植性高.需求管理工作的信息化提升了日常工作的效率.