Create Burndown chart & exclude weekends in TFS

Our team starts to use TFS for managing Product Backlog, and this is the first time I work on TFS Burndown chart. Google around and I found this page to help us configure Burndown chart to exclude weekend (By default, TFS keeps weekend in the Burndown chart, so it doesn't reflect correctly your team effort). This makes sure your Burndown chart works correctly with any length of sprint (2 weeks or more) Steps: Add code below to Category Group to exclude weekend

Select the filter tab and enter the following : Filter Expression =Weekday(Fields!DateValue.Value,0) Type Integer (to the right of the fx button) Operator < Value 6

The pop-up Window should like this

Then add this code into Report (right click into the Report, select Properties, then select Code)

' Define other methods and classes here Function NumberOfDaysToAdjustForWeekends(ByVal valNow as Date, ByVal startOfSprint as Date) AS Int32 Dim valCurrent As Date = startOfSprint Dim weekendDaysPassed As Int32 = 0 Do While valCurrent < valNow valCurrent = valCurrent.AddDays(1) If (valCurrent.DayOfWeek = DayOfWeek.Saturday Or valCurrent.DayOfWeek = DayOfWeek.Sunday) Then weekendDaysPassed = weekendDaysPassed + 1 End If Loop Return weekendDaysPassed End Function

Finally, add code below into "Work_Item_Count"'s expression

=Code.Burndown ( Sum(Fields!Remaining_Work.Value), Fields!DateValue.Value.AddDays(-Code.NumberOfDaysToAdjustForWeekends(Fields!DateValue.Value, Parameters!StartDateParam.Value)), Parameters!EndDateParam.Value.AddDays(-Code.NumberOfDaysToAdjustForWeekends(Parameters!EndDateParam.Value, Parameters!StartDateParam.Value)))

Source: http://2e2ba.blogspot.com.au/2011/08/tfs-scrum-templates-and-burndown-report.html

Use this tool as a part of SCM env.

http://groogle.sourceforge.net/

Want to build your own SCM?

Actually, here is the experience, real application of my client.
They use CVS for code repository, ViewCVS for viewing, LXR for cross-reference, JIRA to link to source code, Doxygen to read code comment, make it as the documentation itself

This is my lesson, it actually cannot compare to google code, but anyway, it is good start

And they have their own Build Generation System, Distrificationalizer, the system will read the definition file, and generate the package, binary for releasing

I was revising the current our project SCM, CI and found out Google Code

http://code.google.com/

Google supports us to host any project we would like, they provides many facilities for managing project source code, and document as well, using background SVN, ReviewBoard, etc.

It should be good approach for any demo project

I would like to add more information on this matter CI, SCM, ReviewBoard, CruiseControl, VSS, DOXYGEN, FXCOP, for automating UnitTest, Code Review, Making document, measuring the code quality, bug tracking and even test automation