Monthly Archives: September 2011

Atlanta Presentations Follow Up

Thanks to everyone who attended my two presentations at the Atlanta Microsoft Project event held last week in Alpharetta.  As promised, here’s some follow up information (organized more or less by topic): -skip to the bottom for a list of … Continue reading

Posted in Events | Tagged , | Leave a comment

Rolling Up Physical Percent Complete

A couple of weeks ago, I kicked off a bit of an exercise in personal improvement by revisiting my own understanding of how Microsoft Project calculates Actual Cost and Earned Value measurements.  This post represents a continuation of that effort, … Continue reading

Posted in Project Desktop | Tagged , , | 4 Comments

Developing a Baseline Execution Index Report

Well, some of you have been reading this blog for nigh on 4 months, and through this medium, I feel that we’ve built a solid and trusting relationship.  Hence, it’s probably about time for me to admit something rather embarrassing.  … Continue reading

Posted in BI, Reporting | Tagged , | 3 Comments

Houston Techfest Coming Up on October 15th

In Houston and looking for some free SharePoint content?  Houston Techfest will be offering two SharePoint tracks at the all day free conference held over at U of H next month. http://www.houstontechfest.com/dotnetnuke/HoustonTechFest/Agenda/tabid/55/Default.aspx …also lots of other content for developers and … Continue reading

Posted in Events, SharePoint | Tagged | Leave a comment

You Want Workflow? We Got Workflow!

Check out our UMT software folks’ blog for the announcement of our exciting new product: UMT Workflow Designer. Link to the blog: http://www.ro.umt.com/blog/2011/09/15/umt-workflow-designer/ Link to the product site: http://www.umtworkflowdesigner.com/en-us/default.aspx Stay tuned to both that blog and this blog to keep … Continue reading

Posted in Portfolio Management, Project Essentials, Workflow Designer | Leave a comment

Developing a Cumulative Milestone Report (Part II)

In the last post, I reviewed a SQL query that may be added to an ODC file to generate the required data set.  In this post, I’ll talk about how to configure the pivot table within Excel to generate a … Continue reading

Posted in BI, Reporting | 2 Comments

Developing a Cumulative Milestone Report (Part I)

Well, I got some very good feedback from that post I did a couple of weeks ago, and decided to throw some more BI examples at the wall to see what sticks.  This post kicks off a twoish part series … Continue reading

Posted in BI, Reporting | 6 Comments

Tracking Actual Costs in Microsoft Project 2010 (Part IV)

If you read the first three parts of this series, you’ll see that I talked about the three options to control how Actual Cost is tracked within a Microsoft Project schedule. Actual Costs are always calculated by Project – Covered … Continue reading

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

Tracking Actual Costs in Microsoft Project 2010 (Part III)

Yes, I know what you’re thinking.  At this point, I probably should be arm wrestling Brian Kennemer for the title of who“endlessly obsesses over Microsoft Project” more.  (And Brian, watch out, I’ll be looking for you in Phoenix next year.)  … Continue reading

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

Tracking Actual Costs in Microsoft Project 2010 (Part II)

Continuing in the thread of documenting more on Actual Cost calculations than you ever wanted to know, let’s look at what happens when we manually edit the Actual Cost for a task on which a resource is actually assigned. For … Continue reading

Posted in Project Desktop | Tagged , , | 6 Comments