051 430 0048

Info@lerouxconsulting.com

Log In
from termcolor import colored # The South African flag colors, approximated colors = { 'black': 'on_grey', 'yellow': 'on_yellow', 'green': 'on_green', 'blue': 'on_blue', 'red': 'on_red', 'white': 'on_white' } # The flag as a 2D list, simplified flag = [ ['red', 'red', 'white', 'blue', 'blue'], ['red', 'red', 'white', 'blue', 'blue'], ['white', 'white', 'green', 'white', 'white'], ['black', 'black', 'yellow', 'black', 'black'], ['white', 'white', 'green', 'white', 'white'], ['blue', 'blue', 'white', 'red', 'red'], ['blue', 'blue', 'white', 'red', 'red'], ] # Print each color block with the right color background for row in flag: for color in row: print(colored(' ', 'grey', colors[color]), end='') print()
BOOK AN APPOINTMENT
BOOK AN APPOINTMENT

 051 430 0048

Info@lerouxconsulting.com

Log In
from termcolor import colored # The South African flag colors, approximated colors = { 'black': 'on_grey', 'yellow': 'on_yellow', 'green': 'on_green', 'blue': 'on_blue', 'red': 'on_red', 'white': 'on_white' } # The flag as a 2D list, simplified flag = [ ['red', 'red', 'white', 'blue', 'blue'], ['red', 'red', 'white', 'blue', 'blue'], ['white', 'white', 'green', 'white', 'white'], ['black', 'black', 'yellow', 'black', 'black'], ['white', 'white', 'green', 'white', 'white'], ['blue', 'blue', 'white', 'red', 'red'], ['blue', 'blue', 'white', 'red', 'red'], ] # Print each color block with the right color background for row in flag: for color in row: print(colored(' ', 'grey', colors[color]), end='') print()

Welcome to our resource center for built-environment professionals.

Whether you're just starting out or are an experienced professional, our free videos are designed to help you stay up-to-date with the latest trends and developments in the industry. From technical tips and tricks to in-depth discussions on current topics, our videos are packed with valuable information that will help you excel in your field..

In this months' featured video we look at:

How to calculate planned % in Microsoft Project

In this video, we're going to show you how to calculate the planned percentage in Microsoft Projects. If you're a project manager or just someone who uses Microsoft Projects for tracking and planning your projects, this tutorial is for you. We'll take you through a step-by-step process on how to set up and calculate the planned percentage of your project, which is a key metric for measuring project progress. Whether you're a beginner or an experienced user, this video is sure to enhance your understanding of Microsoft Projects and help you track your projects with ease. So, grab a pen and paper and let's get started!"

How to calculate planned % complete in Microsoft Project

Here are some of the formulas we share in the video:


Simple Number Formula (Note this will not yield accurate % complete results): 


IIf([Baseline Estimated Finish]<=[Status Date],1,IIf([Baseline Estimated Start]>[Status Date],0,ProjDateDiff([Baseline Estimated Start],[Status Date])/ProjDateDiff([Baseline Estimated Start],[Baseline Estimated Finish])))


Correct % complete formula for MS Project:


Number1 - Baseline Duration Total - Must be a Number field, must Sum the roll-up headings.
IIf([Duration]=0,0.01,ProjDateDiff([Baseline Estimated Start],[Baseline Estimated Finish]))


Number2 - Baseline Days Completed - Must be a Number field, must Sum the roll-up headings.

IIf([Baseline Estimated Finish]<=[Status Date],[Baseline Duration],IIf([Baseline Estimated Start]>[Status Date],0,ProjDateDiff([Baseline Estimated Start],[Status Date])))


Number3 - Planned Completion value - Must be a Number field

IIf([Baseline Estimated Finish]<=[Status Date],1,IIf([Baseline Estimated Start]>[Status Date],0,[Number2]/[Number1]))


Text1 - Round([Number3]*100) & "%"


If you like to know more about our Microsoft Projects for Construction and Engineering Professionals, see below:

Microsoft Projects for Construction and Engineering Professionals

Enroll now and take your project management skills to the next level!

OUR FREE RESOURCES

CHECK OUT SOME OF OUR PREVIOUS VIDEOS

The Importance of Cost-Loading a Schedule

Part of our free course preview on the importance of cost-loading a schedule in Microsoft Projects

Understanding WBS and how to set it up in CCS Candy

Part of our CCS Candy Planning course. A free preview of an informative lesson on WBS and how it applies to scheduling.

Subscribe to receive our monthly articles

Sign Up For Our News Letter

Email* Required field!
View Details
- +
Sold Out