Compare Planned vs Actuals for Team

Home Forums Discussion Forum Compare Planned vs Actuals for Team

Viewing 2 reply threads
  • Author
    Posts
    • #409590
      John Murphy
      Member

      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

    • #409591
      Larry Christofaro
      Participant

      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
      John Murphy
      Member

      Larry,

      Thanks for your reply.

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

      Thanks
      John

Viewing 2 reply threads
  • You must be logged in to reply to this topic.