Plan Academy

Plan Academy Project Controls Training & Courses

  • Units Percent Complete in Primavera P6 – the Missing Guide
    by Nader Khorrami Rad on 28 Settembre 2022 at 15:04

    This article belongs to a series of articles about units percent complete fields of Primavera P6. As explained in the previous article on the Duration % Complete, there are three percent complete fields for each activity: Duration % Complete Units % Complete Physical % Complete. We’ve already covered Duration % Complete and <a title=”Schedule % Complete in Oracle

  • Duration Percent Complete in Primavera P6 – the Missing Guide
    by Nader Khorrami Rad on 21 Settembre 2022 at 14:34

    There are many different methods for calculation of actual progress in Primavera P6.  These methods involve using many fields and settings, including: Duration % Complete Units % Complete Physical % Complete Activity % Complete Performance % Complete Percent Complete Type Earned Value settings of the WBS Elements I will

  • Critical Path Analysis in P6 – 5 Things I Wish I Knew Earlier
    by Michael Lepage on 14 Settembre 2022 at 15:00

    When I first started learning planning and Primavera P6, I thought I had it all figured out. But it wasn’t until I sat with a client and tried to explain what I was showing him that I realized I still had a long way to go. This video tutorial walks you through 5 Things about Critical Path Analysis in P6 that I wish someone would have told me earlier on as a planner. But fret not! You can learn these Primavera P6 Critical Path Analysis tips now and forego the pain and suffering I’ve had to endure. 😉

  • 70 Project Scheduling Terms That Every Planner Needs To Know
    by Michael Lepage on 1 Settembre 2022 at 16:15

    The number of project scheduling and planning terms out there can be overwhelming. Interpreting and communicating a plan can become a task in itself if you are not up-to-date with the planning jargon. So here is a list of 70  Project Scheduling terms every planner should know for smooth sailing – check out the glossary below to brush up on your terms. If you have any terms that are essential and not listed – feel free to leave a comment below with the term and

  • What is a Level of Effort Activity in Primavera P6? [FAQs]
    by Michael Lepage on 17 Agosto 2022 at 15:36

    A “Level of Effort” Activity in Primavera P6 is a special activity type with unique qualities for duration. Primavera P6 will calculate the duration of a Level of Effort Activity based on dates from its predecessor(s) and successor(s). Let’s dive into some specifics about Level of Effort activities in general because they are not specific to Oracle Primavera P6 but are common tasks in project management. What are Level of Effort Activities for? You might already know that Level of Effort activities are designed to represent support work on a project. This is work that does

  • What is High-Level Resourcing?
    by Michael Lepage on 3 Agosto 2022 at 15:03

    We all know how versatile Primavera P6 is as a planning, scheduling and project resource management tool. P6 can handle incredibly detailed project schedules where you can plan and track thousands of work tasks by the hour. But Primavera P6 is also an ideal tool for creating high-level project plans and schedules. High-level resourcing is the process of planning your resource needs across a high-level project plan. What is a high-level project plan? You’ve probably heard the term Level 4 schedule or Level 5 schedule. According to <a

  • 10 Primavera P6 Layouts You Must Implement
    by Michael Lepage on 27 Luglio 2022 at 18:00

    It can get difficult to analyze the mountain of schedules you’re responsible for and our good friend Jerome Ijachi Odeh pulled together a list of 10 Must-Have Primavera P6 Layouts….ones you probably should be using everyday. So to help you take advantage of P6’s powerful layout features (like these ones we’ve already told you about), here is a little sneak peek of 10 must-have Primavera P6 layouts you should be using in Primavera P6 with the

  • How Primavera Calendars Change Durations – and what to do about it
    by Michael Lepage on 20 Luglio 2022 at 15:30

    If you do a quick google on keywords <Primavera calendars change>, you’ll end up with quite a few results that show you how to use Primavera’s Fill-Down feature to change the activity calendar of all the activities in a project. But I think the fill-down piece is only the first step in changing activity calendars. What about durations? Changing an activity’s calendar in Primavera can actually alter the activity’s duration. It’s

  • Here’s A Quick Way To Keep Your Primavera P6 Milestones in Focus
    by Michael Lepage on 6 Luglio 2022 at 15:08

    Primavera P6 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 least it may take a few clicks to <a

  • How To Write Better P6 Activity Names – These 5 Easy Ways
    by Roshan Vani on 24 Giugno 2022 at 20:03

    Every planner knows that WBS and Code Structure are essential elements needed to successfully maintain a Primavera P6 schedule network. But what about your Primavera P6 Activity Names? A sometimes overlooked schedule quality issue is the use of well articulated activity descriptions.  Planners who began their career in P3 or earlier versions were limited to 48 characters in the activity description. This has created an industry habit of abbreviations and acronyms that at times may only be understood by a small group of individuals

  • One Trick to Export P6 Resource Assignment Data to Excel
    by Kazem Salehiyan on 15 Giugno 2022 at 17:15

    As you know Primavera P6 has a lack of graphical features so often we schedulers need to export everything to other software packages (mostly Excel) to produce an understandable schedule and graphs. I always had a problem when I export P6 resource assignment data to Excel with the standard exporting feature on P6 until I found a way to leverage the Reports feature. Here you can use the current screen to develop a report and instead of making it a text report, we can have it <a

  • 4 Tactics To Understand A Schedule You Didn’t Build
    by Michael Lepage on 10 Giugno 2022 at 14:20

    You stepped into work today and were suddenly whisked away to a meeting, only to hear that you will be taking over full responsibility for someone else’s project plan and schedule. Whether you like it or not you will have to tackle understanding this new schedule. So what now!? Before you freak out in a quiet little corner, breathe and take the first steps of trying to understand as much as you can of the Primavera P6 schedule you’ve just been handed. Here are 4 tactics that you can utilize to avoid getting overwhelmed when taking over someone else’s schedule, whether

  • How to Onboard New P6 Schedulers to Your Company
    by Michael Lepage on 1 Giugno 2022 at 15:00

    When it comes to onboarding P6 schedulers, most companies are in a rush. The demands of working in a projectized world lead to feeling like we’re always 3 steps behind where we want to be; effectively productive. And when we’re onboarding our newly hired P6 scheduler, sometimes we have tunnel vision and miss the bigger picture. Here are some recommendations you can use during your onboarding process to help your newly hired P6 scheduler land in their role and get productive, while not forgetting the long-game. Let’s break it down into 30-day phases where each phase has its own

  • Top 6 Reasons How PMP Certification Will Advance Your Career
    by Michael Lepage on 25 Maggio 2022 at 16:30

    Working in project management requires careful attention to detail, inexplicable hands-on training, and credibility. However, planners and schedulers in project management roles often find themselves unable to provide proof of their accomplishments beyond previous roles as project managers. To meet the growing demand for a streamlined, predictable means of ensuring a project manager’s credibility, Project Management Professional (PMP) certification was created. Ultimately, PMP certification is an examination of your past and current abilities as project manager, which gives reliability

  • Update Baseline Feature in Primavera P6 Use or Not
    by Michael Lepage on 19 Maggio 2022 at 17:00

    In today’s post, I want to talk about the Primavera P6 Update Baseline feature. Are you using it right? Should you be using it at all? I want to dive into that and talk about Project Change Management while we talk about the P6 Update Baseline feature.  What is the Problem with Update Baseline? Okay. So number one Update Baseline; If you’ve done any digging, you know it’s fraught with errors and

  • Top New Features in Primavera P6 v21
    by Michael Lepage on 2 Maggio 2022 at 17:14

    A new version of Primavera P6 Professional has recently dropped: Primavera P6 v21, and I’m here to tell about what’s new, what’s great and what’s not. I feel it’s my heartfelt duty to schedulers everywhere to unpack these yearly updates and highlight all of the features that are changing or improving, or are still broken. I love to do it, and I’ve been doing it for years. Here is the yearly schedule of releases for on-premise users of

  • Spring P6: Download to Free Trial
    by Michael Lepage on 27 Aprile 2022 at 15:00

    Primavera P6 Professional is likely the most-used construction project management software package around today. Now at version 21.12, project controls planners & schedulers use Primavera P6 Professional to manage construction projects big and small around the globe. The Primavera P6 download process will let you download a free trial of Primavera P6 Project Management. And we’ll take you through the Primavera P6 download and install process step-by-step.   Here’s what you’ll need to get started with

  • 4 Ways To Benefit From Online Primavera P6 Training
    by Michael Lepage on 20 Aprile 2022 at 16:30

    Here in Primavera-land it seems like eLearning is the new norm! We’ve seen many traditional Primavera P6 training providers launch online Primavera P6 training courses or some sort of Primavera P6 eLearning this year. Quick brag….Plan Academy has some of the best, most comprehensive courses you’ll find! From a learner’s perspective, this is a great opportunity as there are now many more options for learners who want <a

  • 9 Common Project Controls Mistakes Companies Make That Cost Them Millions In Lost Wrench Time
    by Michael Lepage on 6 Aprile 2022 at 15:50

    WRENCH-TIME [average hours/shift that a craftsperson spends directly working to execute construction, maintenance or shutdown activities]. It’s estimated that a worker spends on average only 3.5 hours actually working during a ten-hour shift; this is a startling figure. With industry already lacking in skilled labor, wouldn’t it make sense to try and increase worker performance? The savings of indirect support (travel, tools, safety, living allowance, etc.) in themselves would save millions in

  • The Power Of Oil On the Construction Industry [INFOGRAPHIC]
    by Michael Lepage on 30 Marzo 2022 at 16:15

    Worried that your project might be the next one affected by the recent crude oil price increase?  Closing 2014 oil prices were 49% in decline, back then we feared it could reach the all time low we saw in 2008 where oil dropped 67%. Now in 2022, crude oil prices saw a 40% increase reaching an all time high and getting very close to the 2008 recession highest oil

  • Schedule % Complete in Oracle Primavera – The Missing Guide (Part 2)
    by Nader Khorrami Rad on 23 Marzo 2022 at 15:00

    If you missed Part 1 of Schedule % Complete in Oracle Primavera, go back now and have a read through.  Then come back here. The Proper Setup : Baselined and Cost-loaded Now let’s see how Schedule % Complete works in action on a sample Primavera P6 plan. Since Schedule % Complete is based on both Project Baseline fields and Earned Value Cost  fields, to calculate it properly, your schedule should: be cost-loaded at the Activity-level have a project baseline

  • Schedule % Complete in Oracle Primavera – The Missing Guide (Part 1)
    by Nader Khorrami Rad on 16 Marzo 2022 at 18:00

    Schedule % Complete is one of the many percent completes you have in Primavera P6 and we’re going to have a complete look at what it is and how it is calculated.  Two important products of maintaining schedules are planned progress and actual progress of a given time; you want to know how much you’ve done so far and compare it with how much you were supposed to do so far, in order to reach project targets. The first thing to mention is that Schedule % Complete deals with planned progress. As a result, it is calculated based on the Project Baseline and the Data Date; it has nothing to

  • Fix Out of Sequence Progress in Primavera P6 Schedule
    by Sean Cain on 24 Febbraio 2022 at 16:00

    What is Out-of-Sequence Progress in Primavera P6? Out-of-sequence progress in Primavera P6 occurs from a deviation in the original planned logic that was set up in the baseline schedule. It can occur when work is executed in the field in a different order than was planned in the schedule. The result can affect your project’s logic, which dictates the order of execution of activities. Checking for Out-of-sequence progress To check for out-of-sequence progress in an updated

  • Out of Sequence Progressing in Primavera P6: Why Do We Care?
    by Michael Lepage on 17 Febbraio 2022 at 17:26

    In this post, we’re talking about as-built progress schedules, out of sequence and how that affects everything. But why do we care? What is as-built about and why do we have to fix out of sequence progress in Primavera P6? First, let me start by letting you know that I have a brand-new course that’s coming out; it is the Advanced P6 Progressing course. In this course, we cover out of sequence in depth but I’m going to give you some key information today. Why do

News about the PMP certification

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

Install an evaluation version of Microsoft Project 365

How to install an evaluation copy of Microsoft Project
In this article we will see how to install a 30-day evaluation copy of Microsoft Project Professional 2016 on our PC.

A premise.

The cost of an unlimited Project Professional license is very expensive.

COSTS well 1,369 euros (one-off at the date of this article).
There has been a monthly subscription version for some time, much more affordable if you use Project for work.

To install an evaluation copy of Project follow the steps below:

1.Open the page

The Microsoft Office365 website will open, presenting the three online versions (on the Cloud) of Project and, in the Local Solutions panel, the versions of Project that can be installed on PC and Server.

To understand, the Project Online Essentials license is for Project Online Premium users to be able to access Project Online and interact with the corporate project management environment.

This license allows you to update the Project Activities assigned to the resource and other operations allowed by the Project Online Administrator.

The Project Online Premium license is the most complete and sophisticated and is used to create and manage a Project Online environment (also called Project Portfolio Management).

This license is not the subject of this article.

The license that interests us and that gives us the opportunity to have it for free for 30 days, is Project Online Professional.

Click on Project Online Professional Trial to download the software and start the trial period.
In order to download the software (and use it) you need to activate a Microsoft Office365 account, which is very simple.

Enter the personal data requested on the following pages (no credit card is required).

Remember to save user and password.

After providing the mobile number to receive the verification SMS (check to be a person and not an automatic software), the Office365 account is created as in the following figure:

always for a 30-day trial period, after which you will have to pay each month to maintain it, we will have the main Office and Project programs available for installation up to 5 different PC / Mac / Tablet (interesting to have the original Office programs for us, our wife, children and girlfriend and all included in the Project license!).

The Download Software button is shown at the top right which will allow you to download Project to our PC and start using it.

Project Online Professional costs € 25.30 + VAT per month, that is € 30.87 per month which, for those who have a VAT number, makes € 303 / year + VAT inclusive of all updates and assistance service.

For those with a limited budget it is not really given, but it all depends on whether and how we use it.

Note: I am not receiving any compensation from sales of Microsoft products.

If we manage projects and orders of ours or on behalf of clients, then the cost is justifiable for several reasons (this of course from my point of view):

we have a terrific tool for planning and controlling projects
introduce yourself to the customer with a professional and competent approach
By planning and managing projects well, the value you get is far greater than the cost of the license
you can propose the purchase to your boss in the company without them dying of a heart attack or going crazy
you can have included Word, Excel, Powerpoint and the complete environment of SharePoint and OneDrive with 1 Terabyte of disk space on the Cloud.
Well, if you agree with me on the considerations I made, you are ready to start studying Microsoft Project Professional 2016 (or 2013) maybe with my manual that guides you step-by-step for this purpose.

Primavera P6: reduce the local DB PPMDBSQLite to speed up application execution

Hi how are you? If you have come this far you may need to speed up the execution of the Oracle Primavera P6 application.
The short guide refers to the installations with the local Spring DB PPMDBSQLite.db and to the version P6 Professional R16.2 (x64) even if this procedure can also work with other versions.
For problems relating to Oracle Server DB on the network, ask your IT administrator for support.

We come to the problem, in practice to order and to speed up P6 I have removed many projects from Primavera but the size of the DB has never decreased.
As you see below, over time I had made copies of DB and you can see how the size has always increased, although it has sometimes canceled entire years of projects.
This I think is the problem that when I copy a Project, or when I import a large one, the import process never goes to the end, it either fails or I have to shut down the program and restart.

Like other databases, sqlite does not automatically reduce the size of data files when data is deleted. At least it doesn't by default.

To solve the problem, first make a backup copy of the DB itself, close P6, and then connect to the database with the administration console, or by running the command:

sqlite3 DBNamein your case I think it is
sqlite3 PPMDBSQLite.db

Once connected, the command must be launched
which compresses the datafile
Eventually you exit the console with the command

Unfortunately you probably don't have that command available on your PC, the sqlite3 command derives from a stand alone sqlite installation that is outside the P6 spring installation that has the DB driver already inside it.

So I installed the package:
(1.71 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exeprogram, and the sqlite3_analyzer.exe program.
(sha1: f009ff42b8c22886675005e3e57c94d62bca12b3)

From the site

AC: \ Users \ ofgod> cd \ Users \ ofgod \ Downloads

C: \ Users \ ofgod \ Downloads> cd sqlite-tools-win32-x86-3290000

C: \ Users \ ofgod \ Downloads \ sqlite-tools-win32-x86-3290000> sqlite3.exe \ TEMP \ PPMDBSQLite.db
SQLite version 3.29.0 2019-07-10 17:32:03
Enter ".help" for usage hints.
sqlite> VACUUM;
sqlite> .q

C: \ Users \ ofgod \ Downloads \ sqlite-tools-win32-x86-3290000>

Now the file is almost half the size and I hope the indexes have also been rebuilt.

Now P6 works better and is as fast as the first empty installation of the same application.

Good job, remember before doing this export and empty older projects from P6,

Close P6

Make a backup copy of PMDBSQLite.db

Launch sqlite3 and then the internal commands remembering the; after the statemend VACUUM.

good job