We all struggle with the same issue when exporting data from Primavera P6 to Microsoft Excel for analysis, progress updating and graphing. Excel does not seem to recognize numbers as numbers! That is because P6 formats all data exports as text (appends an apostrophe in front of all data). This makes getting clean data from P6 (even filtered data) extremely difficult. Often we would like to
Primavera P6 Quick Tips
Helpful tips and tricks that will make planning and scheduling with Primavera P6 easier.
Faster is better. That should be Oracle Primavera's mantra. Well, in this case it is! Exporting Primavera P6 data to Excel could not be faster & easier with this quick tip. Getting Primavera P6 Activity data into Excel is essential. Excel's data crunching, grouping, pivoting and filtering is just so much easier to use than Primavera P6's. Even generating S-curves and graphs is better in
To import a newer version XER file to an older version of Oracle Primavera P6 installed on your computer, follow this quick fix. 1) Open the XER file in any text editor like Windows Notepad. 2) On the very first line, you should see the version of Oracle Primavera P6 that this XER file was saved in. Edit the version in the file to match the version installed on your machine. You can check
Milestone Activities in any schedule usually represent the most important deadlines, deliveries, start ups or drop-dead dates for a project. These are undeniably dates that you’ll want to stay on top of and keep close at hand in case you’re asked for a report or to check on the health of the project. But it can be difficult to search for milestones in a large construction schedule, and at the
Plan Academy, I have to send my client a copy of my schedule every month. But the client would like me to exclude any resourcing information in the copy that I send them. How can I easily remove resources in the copy of the project I send to my client?Signed, Geoff. Geoff, it turns out that this is easily accomplished in Primavera P6 with the features included in the software's smart project
Building a filter where all the conditions are either 'And' or ‘Or’ between each row is pretty straightforward. However, if you want to mix them up a little its not so obvious how you should do that in Oracle Primavera P6 Professional. This quick tip will show you how. Example: I want to find all the milestones in the project that have a date variance that is not equal to zero. In other words,
As all of you know, when you want to develop a time schedule there are many attributes that should be assigned to activities and for this purpose we use Activity Detail bottom on the Activity Toolbar. By pressing this bottom, a form will be appear below your time schedule and in this for you can assign different attributes to your activities, such as type, duration, start and finish dates,
Have you ever printed your P6 Gantt Chart only to find that you can't quite see the first or last milestone because they fall off the page or are cutoff? I have. Here's how to avoid printing a scrunched gantt chart by easily expanding your P6 gantt timescale before you print.
Primavera P6 relationships lines sometimes do some strange things. By now you've probably figured out how to turn on and off the relationships lines on the Primavera P6 Gantt Chart using the toggle button on the toolbar. But do you do if Primavera P6's relationship lines are pointing to the baseline bars? Well, in P6 order is important! Last post, we showed you the nuances of shading
It turns out that people like pictures. Yes, that's right, we love pictures....and we love the Gantt Chart. What makes the Gantt Chart so essential is that it simplifies something that is complex. It gives us a snapshot and a trend that our brain can digest rather than just text and numbers. Getting the Gantt Chart to look the way you need it is a really key skill for Primavera
P6's EPS Activity Codes are great when we want to have a set of Activity Codes available to certain projects based on where they sit in your EPS structure. An example might be having a set of Activity Codes for each Department in your database. Typically, EPS nodes would be set up for each Department, allowing an organization to specific a set of EPS Activity Codes for each Department that are
Primavera's custom Activity filters are great for focusing in on a subcontractor's work list or even to hide Activities that are already completed. But when it comes to filtering down a 5000 line project plan to Activities in a specific timeframe, P6's filters fall flat. Here's the Gotcha: any filter that uses a rolling date or P6's built-in date variables will not work when exporting P6 data to