Compare Planned vs Actuals for Team

[John Murphy]

We use Power Query with Excel to report out Actuals for one of our Teams. The Manager wants a to compare Planned time vs Actuals for his team.

How can this be done with Power Query and Excel?

Is there an easier way to do it in Project Online?

Thanks
John

[Larry Christofaro]

John, I think the answer is more about the data and less about the tool or environment. What are you using for planned time? Planned time in the timesheet is simply the assignment Work, which as you know gets changed during the process to match actual work once it is entered. So the typical option is to use Assignment Baseline Work for planned work. That doesn’t change when actuals are entered. Otherwise, I’m seen customers extract data on a regular basis (weekly, bi-weekly, etc.) and then manipulate that data for comparison. That, as you can tell, is not the easy button. Hope that helps…

[John Murphy]

Larry,

Thanks for your reply.

I understand what you are saying and will need to discuss this with the teams.

Thanks
John

[Author]

Posts