[Timothy Jones]

I have a trace macro that I can share if anyone’s interested. It will trace predecessors, successors, or both. It sets Flag 5 to yes. The code was from a PDF file that came with an MS Project 2003 book. I only had to make a few small changes to get it to run. Let me know and I can post the code for the macro.

[Timothy Jones]

Larry, Thanks – much appreciated! It’s been happening for a while with a few different MS Project files, but that’s a great suggestion to take a closer look at the printer and print driver.
Tim

[Timothy Jones]

Paul,
You can see the task information (including dates) for the predecessors and successors when you double click on them in the predecessors & successors detail view. I prefer to use the trace macro, which sets flag 5 to yes for predecessors/successors. Then sort by start or finish and you can see the flow of activities with dates/durations, etc. Hope that helps!
Tim

[Timothy Jones]

Thanks James – looks like a difference between 2013 and 2010 (I’m using 2010 stand alone).

Tony – Sorry I didn’t see this when you posted – hope you have it working now.

[Timothy Jones]

Daryl,
Thank you very much! It’s a huge help to understand exactly how Project displays the increments. This will save us a lot of time trying to figure this out – we’ll look at changing the reporting periods if that’s possible. Your time and expertise are much appreciated.

Tim

[Timothy Jones]

Brian,
Here’s the link to my blog post from 2013 on how to create a 30-day look ahead custom view in MS Project 2010. The 30 days can be adjusted for longer or shorter timeframe.

https://freeslack.com/?p=1

Daryl – Thanks for sharing the article on custom reports. That’s a nice way to do it as well.

Hope this helps!

Tim

[Timothy Jones]

Not sure if this helps with your question Jayakumar, but I wrote this formula to return the “% Should Be Complete” to flag activities that have not been updated to the status date. The formula shows the % that should be complete as of the status date. Then I compare that to the (actual) % Complete field to identify activities that need status update.

IIf([Scheduled Finish]<[Status Date],”100″,IIf([Scheduled Start]<[Status Date] And [Scheduled Finish]>=[Status Date],Round((ProjdateDiff([Scheduled Start],[Status Date])/[Scheduled Duration])*100,0),0))

This helps me in a large schedule to quickly see activities that are not at their expected % complete value.

[Author]

Posts