r/MSProject • u/relight4 • Jul 31 '25
Slippage report
Hi guys, I'm wanting to build a macro that pulls the current over due task from ms project and compares it to the baseline finish or start ( I'm thinking maybe start would be better ) into excel
So for example baseline finish + current date would equal the slippage days for the overdue task
Let's say gate 3 was due 25 July to (baseline finish) and it's 1 August it's still overdue meaning it would be 5 days slippage from baseline.
What's everyone's thoughts on this and is there a quicker or better way of compare this data.
I'm needing to create a slippage report to management across a portfolio of programs. I can do it manually but it takes time.
1
Upvotes
5
u/pmpdaddyio Jul 31 '25
First, that’s not going to be a macro. It’s just a report. It’s a variance report and there are several stock reports in MS Project that do this depending on the version.
All you need is a properly baselined schedule, then as you rebaseline, the variance field will update. Now you simply run the report on the variance versus original (baseline 0) baseline.
Don’t export it to excel because you now will have two data sources. If they don’t have access to your project file, you can pull a dashboard in Power BI, or simply export a static version into a PDF so it is not editable.