Have you ever used Microsoft Excel Power Query in your daily planning tasks, such as data loading and Cost Loading sheets? If the answer is yes, in this article I want to give you some tips and tricks about the …
Excel in Planning
planning, Primavera P6, cost control, claims and reporting, written by working planning engineers.
One of our students in the PPE Course (Professional Planning Engineer) asked about Excel macros. In the PPE Course, we teach planning engineers how to automate most of their work by using Excel macros In Construction Planning. This article will …
Working hours create realistic project schedules. It enables accurate resource allocation, cost estimation, and critical path analysis. Project managers can assess resource productivity and adhere to project constraints, such as night shifts or specific time windows. Working hours aid in …
How to create cost loading, activity list, and smart activity ID using Excel Power Query. Save a lot of working hours and get your activities ready to be imported to your Oracle Primavera P6. If you need to learn more, …
Materials tracking is very important to project success. in this post I will show you how to create Materials Procurement Scheduling in a Baseline Programme to track the materials as per the following sequence: 1- Material Submittal 2- Material Approval …
Automated Spread Excel sheets that calculate the planned values based on planned start and planned finish. And it will give you the total progress and the total planned per week. Furthermore, it compares the planned values to the actual values …
Grow your planning career
Learn with a clear path
From Primavera P6 basics to claims, cost control and Power BI. Start with our free courses.
Browse coursesGet help on WhatsApp
Every course comes with a private WhatsApp support group where our team answers your questions.
Join a courseFind planning jobs
86 open planning and project control jobs. Post your resume so employers can find you.
See jobsGet tips by email
Free planning tips, templates and course offers. Unsubscribe any time.
This Excel sheet helps you to make 3 weeks look-ahead by Excel. It automatically gives you one week before the Data Date and 3 weeks after. Once you change the Data Date all the yellow dates will be adjusted according …
You might have heard before about the Microsoft Excel Power Query. However, have you ever used it in your daily planning tasks? In this article, I want to give you some more information about the application of power queries in …
I have received a question from one of my trainees as follow “I have schedule of work around 50,000 activities and the schedule contains the scope of work of two contractors. Now one contractor will not be working under us …
I just received a question about Primavera from one of our website courses member and i believe it is interesting. Following is the question and my answer: “Dear Mr.Hany, When im importing almost 6000 activities from excel to Primavera it …
Never miss a planning tip
Join our email list and follow Planning Engineer for new articles, free templates and course updates.
Free planning tips, templates and course offers. Unsubscribe any time.