Excel TFS Add-In User Guide

The add-in serves a dual purpose:

* Sprint Backlog Item – link manipulation / display.

* SBI Estimated / Work Remaining / Total Hours Worked extraction.

 

The two features are quite distinct and are enabled in distinct ways. The first scenario is covered in an instructional video:

Whilst the second scenario (calculating hour totals) is explained as follows:

 

Using the cell formulas provided by the Add-In, you can create usefull worksheets to assist in daily SCRUM meetings:

 

 

The Excel Add-In provides the following in cell Formulas that can be used to calculate Total Hours Remaining and Total Hours Worked:

 

• GetSprintEnd(String TfsServerName, String TfsProject, String IterationPath)
• GetSprintStart(String TfsServerName, String TfsProject, String IterationPath)
• GetTotalEstimatedEffort(String TfsServerName, String TfsProject, String IterationPath, String TfsTeam, Range& UserNames)
• GetTotalHoursRemaining(String TfsServerName, String TfsProject, String IterationPath, String TfsTeam, Range& UserNames)
• GetTotalHoursWorked(String TfsServerName, String TfsProject, String IterationPath, String TfsTeam, Range& UserNames)

 

The three GetTotal* functions (GetTotalEstimatedEffort, GetTotalHoursRemaining and GetTotalHoursWorked) return a Range depending on the size of the Range parameter entered (UserNames):

 

 

GetTotalEstimatedEffort

This function calculates all of the Estimated Effort hours for a Range of UserNames:

 

 

GetTotalHoursRemaining

This function calculates all of the Work Remaining hours for a Range of UserNames:

 

 

GetTotalHoursWorked

This function calculates all of the Total hours worked for a Range of UserNames:

 

 

The functionality behind this feature is based on certain fields being defined in the SCRUM template (Estimated Effort (Scrum), Work Remaining (Scrum) and Actual Hours Worked).

 

A sample Excel worksheet is provided as an example.