What is SmartExcel4TFS?
SmartExcel4TFS automates the generation of user defined Traceability Matrix from Microsoft TFS such Requirements Traceability Matrix, Defect Analysis Matrix and Work Item Decomposition Matrix.
How does SmartExcel4TFS work?
With SmartExcel4TFS, large volume of Work Items and its relationships from TFS can be visualized and organised from a variety of different perspectives right within Microsoft Excel. Creating, analyzing and understanding how information is linked is critical to Application Lifecycle Management.
SmartExcel4TFS is essentially a reporting and analysis tool that virtually helps all the actors in the ALM stage.
Access any Team Project
Connect SmartExcel4TFS to any team project including the ones based on CMMI, SCRUM, Agile or custom process templates. Generate traceability matrix for a project, portfolio or across multiple projects.
Get Updated Data from TFS
Use the Refresh functionality to get updated data from TFS in your generated matrix. This makes sure to always display the latest matrix report, based on the saved perimeters.
Keep Track of Requirements to Test Coverage
Using Requirements Traceability Matrix, analyze test coverage, test status by configuration, missing links as well as impact assessment.
Generate Work Item Decomposition Matrix
Visualize Work Item decomposition in Excel and share this report with others.
Generate Intersection Traceability Matrix
Automatically generate Intersection Traceability Matrix. Display work items as rows and columns, with the intersecting cells revealing the links existing between work items. Furthermore, you can view user-selected properties in the intersection cells either text based or color coded.
View and Edit Work Item Details
Access and modify Work Item details right within Excel. All the updates will be saved in Team Foundation Server.
SmartExcel4TFS can be used to verify that user requirements are built, tested and bug free. It creates a virtual bridge from the requirements domain to the testing domain.
Traceability Along with Link Type and Properties
SmartExcel4TFS reveals the link types between the row & column work item and gives users the option to select properties that can appear in traceability matrix as label and color thereby making the report much more informative and concise.
Update Work Item Using Excel
Individual Work Items can be updated from right within Excel with just a click. This allows users to view and update Work Items directly from within the Traceability matrix.
Visible Requirements Coverage
Requirements coverage count on a traceability matrix to save time and energy. It shows the count on the number of column work items intersecting with the individual row work items and vice versa. This makes it easy to identify missing and disconnected requirements.
Better Verification and Validation
With the proper linking of Work Items, the matrix can provide an organized representation to know location of requirements and where they need to be placed. A traceability matrix gives a concise and interlinked picture of work items in just a glance.
Requirements Traceability provides Client Satisfaction
SmartExcel4TFS’ traceability matrix makes the product implementation cycle run better and transparently to key stakeholders involved in the project. It is a critical tool for analysing the health of the solution, thereby increasing the confidence of stakeholders in the project.
Aug 2016: SmartExcel4TFS™ v2016
Dec 2015: SmartExcel4TFS™ v2015 update 3 – Updated Features
Customer Feedback support: As a user, I shall be able to send smiley or frown as feedback so that I can give ideas, suggestions, or even problems within SmartExcel4TFS
Bilingual Support: SmartWord4TFS now works with multilingual team foundation server (German, Chinese and French)
Nov 2015: SmartExcel4TFS™ v2015 update 2 – Updated Features
SmartExcel4TFS now works with MS Excel 2016
SmartExcel4TFS now works with Excel 365 ProPlus support
SmartExcelTFS™ v18.104.22.168 Oct 2015
SmartExcel4TFS™ v22.214.171.124 Aug 2015
SmartExcel4TFS™ v126.96.36.199 Jul 2015, New Features
Ribbon bar enhancements
SmartExcel4TFS log file enhancements
Send SmartExcel4TFS log
SmartExcel4TFS™ v1.1.0 2nd April 2014, Released Features
Access Any TFS Team Project
Generate Intersection Traceability Matrix
Keep Track Of Requirements Coverage
Generate Horizontal Traceability Matrix
View And Edit Work Item Details
Get Updated Data From TFS
Save Input Configuration
- Generate Traceability Matrix
- Generate an Intersection Traceability Matrix from TFS/VSTS
- Generate a Horizontal Traceability Matrix from TFS/VSTS
By submitting this form, you agree to receive emails from Modern Requirements. You understand that you will be subscribed to the Modern Requirements monthly marketing newsletter and periodic offers for additional content and/or services. Your consent can be withdrawn at any time using the links provided in every email.
All registration information is confidential and for company and MSDN Subscriptions use only.