Advanced P6 Reporting in Excel> More Earned Value Graphs
More Earned Value Graphs
Duration: 9m 49s
Skill Level: Beginner
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.
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: More Earned Value Graphs
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 g...