Advanced P6 Reporting in Excel

1
Advanced Primavera P6 Reporting in Excel Course Welcome
1m 25s

The Advanced P6 Reporting in Excel course is going to blow you away by showing you a simple way to create beautiful graphs of Primavera P6 data in Excel. Watch the trailer to find out the complete details.
2
Exporting P6 Data to Excel, Reshaping and Charting
9m 54s

In this lesson we'll get you up and running fast with P6 data and Excel charts. You'll start by learning to how to install an Excel add-in to help with creating graphs quickly. Then we'll dive into the process of importing data from P6 into Excel and how to prepare it for charting. Lastly, you'll learn how to create simple Budgeted Units histogram.
3
Understanding Excel Charting Options
3m 12s

Learn how to manipulate and chart data using Excel's easy drag and drop interface. Practice creating different charts and learn how to create a graph of Total Budgeted Units by Role. You'll also learn how to easily create a Stacked Histogram by Role. Once you get the hang of Excel's charts, you may never go back.
4
Graphing Workarounds for Excel 2010 or earlier
3m 41s

Want to create some amazing P6 graphs but you're using Excel 2010 or earlier? Don't worry, here are the workarounds you need to make those pretty pictures and charts!
5
Creating a Budgeted vs Actual Costs Histogram
9m 20s

Learn how to reproduce a common Primavera P6 graph from the Activity Usage Profile - the Budgeted, Actual, Remaining Histogram. Learn how to create this histogram to graph either Costs or Units. You'll also learn how to add cumulative trend lines just like in P6. It's like using the graphs in P6, only much better!
6
Tips & Tricks to Plotting Data in Excel
11m 01s

Cumulative graph lines don't originate at 0. Adding Data Tables below your graphs. How to plot FTEs or format the graph for total man-power. Making multiple charts from the same data. Working with calculated fields in Excel. Adding Chart Titles.
7
Graphing Banana Curves
8m 47s

In Lesson 5, you'll learn how to quickly graph a banana curve consisting of Early Units, Late Units and Earned Value. To graph this type of curve, we'll show you how to first extract data from a P6 baseline. Then we'll take Earned Value data from your current project and pull it all together into a useful graph that looks like a banana.
8
Earned Value Histogram with S-Curves
10m 50s

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.
9
More Earned Value Graphs
9m 49s

In lesson 7, we'll take you through 2 more essential Earned Value graphs. First, you'll learn to chart Cost Performance Index vs Schedule Performance Index. And secondly, you'll look at charting Cost Variance vs Schedule Variance. These are graphs that are not possible in P6 alone but take advantage of Excel's calculated fields.
Previous Lesson

More Earned Value Graphs

In lesson 7, we'll take you through 2 more essential Earned Value graphs. First, you'll learn to chart Cost Performance Index vs Schedule Performance Index. And secondly, you'll look at charting Cost Variance vs Schedule Variance. These are graphs that are not possible in P6 alone but take advantage of Excel's calculated fields.

Advanced P6 Reporting in Excel More Earned Value Graphs

RATS!
This video is only available
to Plan Academy members.

Start Your Primavera P6 Training Today!

Hello, and welcome back! This is Trevor Watt. In this lesson I’m going to show you how to create two other in value graphs. First we’re going to look at is CPI versus SPI. And Cost Variants versus Schedule Variants. Now, these two charts we have to make actually entirely in Excel.

So what we’re going to do is use the Excel data that we created in Lesson 6. So if you don’t have a copy of that, there is a file available for download below to get us started. So I’m just going to close this and we’re going to start from scratch.

First of all actually, I have P6 open. I want to go in here and show you that those units are not available in here so we don’t have any reference to CPI or Cost Variants or Schedule Variants and either Cumulative or/and Time Interval fields. So we have to calculate it all in Excel. So I’m just going to open up our Lesson 6 table or chart and we’re going to continue from where we left off.

So what we need to do actually is we’re going to use the same data. We’re going to actually just copy this Pivot Table so I do that just go Analyze, select Entire Pivot Table, and then right click and then go copy. And we’re going to add a new sheet. And we’re going to paste it in here. Now, we don’t need any of these existing Spreadsheet Fields.

Mostly blank in there now. And what we’re going to do is...

For questions about this course please visit this course's Community Forum.

Course Community Forum
Previous Lesson
Back to Course