Advanced P6 Reporting in Excel> Earned Value Histogram with S-Curves
Earned Value Histogram with S-Curves
Duration: 10m 50s
Skill Level: Beginner
We all know the Earned Value Management provides us with a realistic progress and performance analysis. In this lesson, you'll graph Earned Value data to create an essential Earned Value Histogram, complete with Actual, Planned and Estimate at Completion Curves.
This course will revolutionize how you graph Primavera P6 data! In our Advanced P6 Reporting in Excel course, you’ll learn very specific techniques for quickly exporting Primavera P6 Professional data to Excel, reformatting it and creating amazing-looking graphs and charts with only a few clicks! You’ll also learn to create specialized graphs that are only possible in Excel and not in Primavera P6 Professional natively. This course is a must for any planner who has any sort of reporting responsibilities. This course presents graphing methods in Excel 2013 primarily, but if you're using an earlier version of Excel, don't worry, we'll show you the workarounds.
Video: Earned Value Histogram with S-Curves
Hello and welcome back! This is Trevor Watt. I’m going to continue on with this lesson with another Earned Value Chart, this is my favorite chart. It is showing multiple different series so we got Period Earned Value Labor Units, Period Planned Value Labor Units, Period Estimated at Completion – Labor Units, Period Actual Labor Units, and then Cumulative for each one of those to former S curves. So in this chart it’s easy to relate Actual versus Earned versus Planned and where you are behind schedule, ahead of schedule, or under budget. I’m going to close this down and we’ll go into P6.
So again we’re using our same project as we were before. We have the baseline attached and what we’re going to do is go into our show on top, Activity Users Spreadsheet. First step, how we’re going to use this is we’re going to remove our Group and Sort setting, we’re going to select our columns, and I’m just going to add in again WBS Path and Name. Then we’re going to go to our Spreadsheet Fields. We’re going to be adding, like I said, 8 different series in here. And we’re going to be working on Units but the reverse is actually true on Cost. I just want to mention for, in my mind true Earned Value Report, you should actually be using Financial Period Values but for this example is the Period, store pe...