Dashboard Creator – Part II

Dashboard Creator – Part II In a post last week, I introduced a Excel-based Dashboard Creator I wrote. I gave examples of a dashboard showing counts. For example, the number of bugs assigned to a person. But what if you want to show the sum-total of a field? For example, you can show the number…


Dashboard Creator – Part I

First, my thoughts on dashboards. In the many projects I’ve managed I’ve used lots of different dashboards to help communicate to the team what is important. Dashboards are a communication and accountability tool. The problem is, the things that are important to be communicated change vastly over the project’s lifecycle: ·         At the beginning of…


New content on creating custom reports

There is new content on MSDN on building custom reports. Allen Clark has more details about it on his blog post: http://blogs.msdn.com/vstsue/archive/2007/08/29/new-content-available-on-creating-custom-reports.aspx  


How much time does my project team really have?

I think one of the greatest challenges for a project manager is to have a realistic view of how much time team members can really spend on their scheduled tasks. Unplanned activities can put a big dent in projects leading to all sorts of fire fighting; either towards the end of a milestone when the…

1

What is a Team Project?

What is a Team Project and how does it map to the real world. That’s a big question. I ran across this interesting post from Peter Bauwens: http://peterbauwens.wordpress.com/2007/08/18/planning-team-projects/ He’s done some good thinking on how this applies to his world, in using team projects for releases and maintenance. Right now, we are doing some heavy…


Rosario: What is the “Name” attribute for on Links Control XML

Last post, I talked about how to filter on link types. Here’s an example: <Control Type=”LinksControl” Name=”UniqueName”>    <LinksControlOptions>      <WorkItemLinkFilters FilterType=”includeAll” />      <ExternalLinkFilters FilterType=”excludeAll” />   </LinksControlOptions> </Control>   Some of you may have wondered want the “Name” attribute is for? Well, it does have a purpose. 🙂 The TFS Client uses this…


Rosario: Filtering link types on a work item form

In Whidbey, and Orcas, the work item links control that displayed the links always showed all the links. For Rosario, we made a design decision based on the fact that whoever is designing a work item form, may want to display certain link types separately from other link types. For example, let’s say you have a…


Rosario – Customing Link Types Primer

With Rosario, you can define multiple link types. This allows for you to customize link types to match your processes. This blog post is a primer in how to do that. Quick-start guide on creating a new link type:  Here’s how to create a new link type: From the command shell, go to “Program Files\Microsoft Visual…


Restricting access for a specific set of users

Have you ever wanted to provide access to your TFS data to an external set of users, for example, contractors or customers, but wanted to restrict access to the data. I mean you want transparency, but not COMPLETE transparency. I just answered a forum post on this topic, and thought you might find it interesting….


Rosario: Managing hierarchies in Microsoft Excel

As a follow up to Gregg’s post on querying on links and creating tree queries, I’d like to introduce you to managing work item hierarchies in Microsoft Excel. Creating work item hierarchy  There are a few ways you can get started with creating hierarchies in Excel: Create a tree query in Team explorer and export it to Excel…