Some Basics of Project Scheduling using Microsoft Project Professional

Some Basics of Project Scheduling using Microsoft Project Professional

Few days back I was planning to do some study on project professional.  But I was unsure where to start but last Friday I got the idea when I was doing my RND on the thing given below.  From today I will be sharing some of my knowledge and some new information about Project pro.  I will make sure the each entry must be more than 30 lines with simple explanation.  I will try to provide the most up-to-date and correct information.  Please do not hesitate to provide feedback or any question.  The entry below is not part of this blog series just an RND done by me for a presentation. 

This RND was about mostly used fields/formulas in project professional.  So enjoy reading…

Updating Task Status Updates Resource Status (% Work Complete VS % Complete)

Updating Task Status Updates Resource Status  (available through the Tools menu, click Options then select the Calculation tab): If this option is selected, then edits to % Complete cause assignment Actual Work to recalculate at that percentage of the assignment Work. This is a two-way setting. Edits to Actual Work and Stop dates cause % Complete to be calculated. When the setting is not selected, % Complete is independent of Actual Work and Stop dates.

Assignment % Work Complete

This field reflects assignment Actual Work as a percentage of total Work. Editing the Assignment % Work Complete field causes

·         Task and assignment Actual Work and Remaining Work recalculate based on total assignment Work.

·         Sets Actual Start for both the task and assignment if not previously set.

·         If 100% is entered, then assignment Actual Finish is set as scheduled.

·         Task Actual Duration, task, and assignment Remaining Duration all recalculate.

·         Task % Complete is calculated based on task Duration/ Actual Duration x 100.

% Complete

When the % Complete field is edited, Microsoft Project performs the following:

·         The Actual Start date is set equal to the scheduled start date, unless an actual start date was already entered. If a task does not start on schedule, then the start date should be updated with the Actual Start date, before % Complete is entered.

·         The Actual Finish date is set to match the scheduled finish date if the value entered for percent complete is 100%. If the Actual Finish date is not the same as the calculated date, the Actual Finish date should be entered before 100% is entered (Once a task is 100% complete Microsoft Project stops calculating other fields in the task record.)

·         The Actual Duration field is set to equal the percent value times the scheduled Duration. Therefore, if a task is marked 60% complete when the scheduled Duration was 10hrs, the Actual Duration field is calculated and set to 6hrs.

·         Remaining Work and Remaining Duration are recalculated. Remaining Work = Total Work – Actual Work, the same equation is used for Duration.

·         The % Work Complete for the task is set of match the % Complete, by default.

·         The Actual Work and Cost fields are set to match the percent value times the scheduled work and cost rates, by default.

Note  If the checkbox for Updating Task Status is unchecked, then % Work Complete, Work and Cost are independent of % Complete.  To find this option go to the Tools menu, click Options, and click the Calculation tab.

Remaining Work

Editing Remaining Work only affects progress if the task has already started.

·         Scheduled and Actual Work is recalculated and in turn % Complete, % Work Complete, scheduled Finish, Work, and Remaining Duration are recalculated based on the new duration.

·         Entering zero in the remaining work field is the same as entering 100% complete.

Actual Duration

If a value is entered that is less than or equal to the scheduled Duration, Microsoft Project assumes that everything is going as planned.

·         Actual Start date is set to schedule start, unless it has been set previously.

·         The % Complete is calculated, Actual Duration x 100/ Duration.

·         The Remaining Duration field is calculated by; using this equation: Total DurationActual Duration = Remaining Duration.

·         Work or Resource Units may be recalculated based on the task Type field.

If Duration is entered that is greater than the original Duration, Microsoft Project assumes that the task is finished and took longer than scheduled.

·         The scheduled Duration is changed to match the new, longer Actual Duration.

·         Work or Resource Units may be recalculated based on the task Type field.

·         The % Complete and Remaining Duration fields are set to 100% and 0, respectively, to indicate that the task is complete.

Actual Work

If a value is entered that is less than or equal to the scheduled work, Microsoft Project assumes that everything is going as planned. Refer to Actual Duration as these fields are interrelated and recalculate based on task Type.

 

Best Regards,

Jerry
EPM Consultant\Sr. Software Engineer

Work In Progress

Work: +92 42 5427001-4 Ext 213
Mobile: +92 345 4257573

See My Blogs

Email: yasir.attiq@gmail.com
IM: <On Request>

INTECH Process Automation
119 B, Tech Society,
Lahore, Punjab 54950
Pakistan

See who we know in common

Want a signature like this?

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s