Monthly Archives: October 2011

Setting Subproject Status Date with VBA

Posted on October 26, 2011 by

If you read yesterday’s post, you’ll remember that I was kvetching about how setting the status date in the master project didn’t set the status date for subprojects – and how this impacted both task updates and EVMS calculations in … Continue reading →

Posted in Project Desktop, VBA | Tagged | 2 Comments

Working with Master Projects in Project 2010

Posted on October 25, 2011 by

The first blog post I ever wrote was actually on this topic – as I struggled with the “insies and the outsies” of managing my own master project.  Seeing as I am currently proposing a master project solution to a … Continue reading →

Posted in Project Desktop | Tagged | 5 Comments

VBA: Updating Assignment Level Fields from SQL

Posted on October 18, 2011 by

Rod Gill’s book on VBA for Project 2007 has been sitting on my bookshelf for a couple of years.  I finally decided to open it up again last week to see if I could use it to sort out some … Continue reading →

Posted in Project Desktop, VBA | Tagged | Leave a comment

Documenting Lookup Tables with Playbooks

Posted on October 13, 2011 by

It slices!  It dices!  Not only does it move Project Server settings from one environment to another, but it also provides an easy way to document some of the configuration settings you made in your environment.  This is a trick … Continue reading →

Posted in Admin | Tagged , | 1 Comment

Three Perspectives on Project Size

Posted on October 11, 2011 by

There is a discussion that comes up often in different client engagements: how do you define a project as “big?”  Something happened recently which caused me to reconsider different perspectives on project size.  You see, my daughter broke her arm. … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

The BEI Report Revisited

Posted on October 6, 2011 by

A couple of weeks ago, I wrote up instructions on how to create a Baseline Execution Index Report.  It’s a pretty nifty concept, but in retrospect I think it was missing a key element, a cumulative record of the task … Continue reading →

Posted in BI, Reporting | 1 Comment

Scheduling Milestones for Specific Days of the Week

Posted on October 4, 2011 by

Here’s a little trick that may come in useful when developing your schedules.  The scenario here is that you have a milestone such as key meeting or review or training kick off or go-live date, but that event has to … Continue reading →

Posted in Project Desktop | Tagged , | 1 Comment