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

  • Primavera P6: Download a 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

Notizie sulla certificazione PMP

OnlinePMCourses Online Project Management Video Courses to Build Your Project Career

Installare una versione di valutazione di Microsoft Project 365

Come installare una copia di valutazione di Microsoft Project
In questo articolo vedremo come installare sul nostro PC una copia di valutazione di 30 giorni di Microsoft Project Professional 2016 .

Una premessa.

Il costo di una licenza illimitata di Project Professional é molto cara.

COSTA ben 1.369 euro (una tantum alla data di questo articolo).
Da un pò di tempo ne esiste una versione ad abbonamento mensile, molto più abbordabile se utilizzi Project per lavoro.

Per installare una copia di valutazione di Project segui i passi seguenti:

1.Apri la la pagina

Si aprirà il sito di Office365 di Microsoft che presenta le tre versioni online (sul Cloud) di Project e, nel pannello Soluzioni locali, le versioni di Project installabili su PC e Server.

Per capire, la licenza Project Online Essentials serve agli utenti di Project Online Premium per poter accedere a Project Online e interagire con l’ambiente di gestione progetti aziendale.

Questa licenza permette di aggiornare le Attività di progetto assegnate alla risorsa e altre operazioni permesse dall’Amministratore di Project Online.

La licenza Project Online Premium, é la più completa e sofisticata e serve a creare e gestire un ambiente di Project Online (detto anche Project Portfolio Management).

Questa licenza non é l’argomento di questo articolo.

La licenza che ci interessa e che ci dà la possibilità di averla gratuitamente per 30 giorni, é Project Online Professional.

Clicca su Prova di Project Online Professional per scaricare il software e iniziare il periodo di prova.
Per poter scaricare il software (e usarlo) é necessario attivare un account Microsoft Office365, cosa semplicissima.

Inserire i dati anagrafici richiesti nelle pagine successive (non viene richiesta nessuna carta di credito).

Ricordarsi di salvare utenza e password.

Dopo avere fornito il numero di cellulare per ricevere l’SMS di verifica (controllo di essere una persona e non un software automatico), viene creato l’account Office365 come nella figura seguente:

sempre per un periodo di prova di 30 giorni, trascorsi i quali si dovrà pagare ogni mese per mantenerlo, avremo a disposizione i principali programmi di Office e Project installabili fino a 5 PC/ Mac / Tablet diversi (interessante poter avere i programmi originali di Office per noi, nostra moglie, figli e fidanzata e tutto compreso nella licenza di Project!).

In alto a destra viene mostrato il pulsante Scarica il Software che permetterà di scaricare Project sul nostro PC e iniziare ad usarlo.

Project Online Professional costa € 25,30 + IVA al mese, cioè € 30,87 al mese che, per chi ha Partita IVA fa € 303/anno + IVA comprensivi di tutti gli aggiornamenti e del servizio di assistenza.

Per chi ha budget limitato non é proprio regalato, ma tutto dipende se e come lo usiamo.

Nota: io non ricevo alcun compenso dalle vendite dei prodotti Microsoft.

Se gestiamo progetti e commesse nostre o per conto di clienti, allora il costo é giustificabile per diversi motivi (questo naturalmente dal mio punto di vista):

abbiamo uno strumento formidabile per pianificare e controllare progetti
ti presenti al cliente con un approccio professionale e competente
pianificando e gestendo bene i progetti, il valore che ottieni é ben superiore al costo della licenza
puoi proporre l’acquisto al tuo capo in azienda senza che questi muoia di infarto o ti prenda per pazzo
puoi avere compresi Word, Excel, Powerpoint e l’ambiente completo di SharePoint e OneDrive con 1 Terabyte di spazio su disco sul Cloud.
Bene, se sei d’accordo con me sulle considerazioni che ho fatto, sei pronto a iniziare a studiare Microsoft Project Professional 2016 (o 2013) magari con il mio manuale che ti guida passo-passo a questo scopo.

Primavera P6: ridurre il DB locale PPMDBSQLite per velocizzare l’esecuzione dell’applicazione

Ciao come va? Se sei arrivato fino a qui potresti avere bisogno di velocizzare l’esecuzione dell’applicazione Oracle Primavera P6.
La breve guida è riferita alle installazioni con il DB locale di Primavera PPMDBSQLite.db e alla versione P6 Professional R16.2 (x64) anche se questa procedura può funzionare anche con altre versioni.
Per le problematiche riferite a DB Oracle Server in rete chiedete supporto al vostro amministratore IT.

Veniamo al problema, in pratica per ordine e per velocizzare P6 ho rimosso molti progetti dal Primavera ma la dimensione del DB non è mai diminuita.
Come vedi sotto, nel corso del tempo avevo fatto delle copie de DB e si può vedere come la dimensione sia sempre aumentata, seppure abbia a volte cancellato intere annualità di progetti.
Questo penso che sia il problema per cui quando copio un Progetto, o quando ne importo uno grande il processo di import non mi va mai alla fine, o fallisce oppure devo spegnere il programma e riavviare.

Così come altri database, sqlite non riduce le dimensioni dei datafile automaticamente quando vengono cancellati i dati. Quantomeno non lo fa per default.

Per risolvere il problema prima effettuati una copia di sicurezza de DB stesso, chiudi P6, e poi connettiti al database con la console di amministrazione, ovvero lanciando il comando:

sqlite3 NomeDBnel tuo caso penso sia
sqlite3 PPMDBSQLite.db

Una volta connesso, va lanciato il comando
che comprime il datafile
Alla fine si esce dalla console con il comando

Purtroppo probabilmente non hai quel comando disponibile sul PC, il comendo sqlite3 deriva da una installazione sqlite stand alone che esula dall’istallazione di primavera P6 che ha il driver del DB già al suo interno.

Per cui ho installato il pacchetto:
(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)

Dal sito

A.C:\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


Ora il file è quasi la metà come dimensione e spero siano stati ricostruiti anche gli indici.

Adesso P6 lavora meglio ed è veloce come ala prima installazione vuota dello stesso applicativo.

Buon lavoro, ricorda prima di fare questa operazione esporta e svuota progetti non più recenti da P6,

Chiudi P6

Fai una copia di sicurezza del PMDBSQLite.db

Lancia sqlite3 e poi i comandi interni ricordando il ; dopo lo statemend VACUUM.

Buon lavoro