Quick Links

Compare Planned vs Actuals for Team

Home Forums Discussion Compare Planned vs Actuals for Team

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #409590 Reply

    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?


    #409591 Reply
    Larry ChristofaroLarry 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…

    #409616 Reply


    Thanks for your reply.

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


Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Compare Planned vs Actuals for Team
Your information:

16 − 11 =