March 21, 2012
by admin
0 comments
GIGO as the term goes, applies for MS Project also. If we think of MS Project to take care of all your Planning, Tracking and Control requirements if we keep updating any and all fields at will. Even if we … Continue reading
March 20, 2012
by soni
0 comments
Usually large project need to be searched for appropriate text to match relevance and importance of tasks. To demonstrate this one can make use of following short script which iterates through all tasks in active project and messages it: … Continue reading
March 20, 2012
by soni
0 comments
Going by the public holidays list, project managers needs to permanently mark specific dates of year as holidays. January 1st is one such case. In this method, we will show how to mark 1st of january in your MS Project … Continue reading
March 20, 2012
by admin
0 comments
While reporting cost we need to report Actual cost distribution resource wise. The following script walks through all tasks in project and check if a resource defined in “Resource sheet” is allocated to it, will calculate “Actual Cost” for entire … Continue reading
March 20, 2012
by soni
0 comments
During appraisals / price hike / change in tax rates, we as project managers need to revise “Standard rates” and other costing factors for resources on project by specific factor. The following example updates the “Standard rate” for all resources … Continue reading
March 20, 2012
by soni
0 comments
For a single project, we can identify all tasks on critical path via “Tracking Gantt” chart. I was wondering if there is a way to identify which tasks fall on Critical path programatically. The solution is simple and can be … Continue reading
March 19, 2012
by admin
3 Comments
Creating a Task’s start date and End date deadline (Must Start On, Must Finish On etc) limits the flexibility of schedule and Prevents MS Project from automatically managing the schedule dates for your project. To define deadlines, project managers can … Continue reading
March 19, 2012
by admin
2 Comments
MS Project constraints all tasks with “As Soon As Possible (ASAP)” constraint allowing tasks relationships and dependencies to define start date of tasks. Unless we have specific reason like “Raw material for plant” will be available not before specific dates, … Continue reading
March 19, 2012
by admin
1 Comment
MS Project allows you to create resources of type Budget. How to use budget resources and what does this means to Project tracking and monitoring? Before explaining on this, let’s understand how cost and project budget can be tracked. Eg. … Continue reading
September 7, 2011
by soni
0 comments
Before going through let us understand what is Unit, Duration and work in MS Project and how they are related. Unit : Refers to “Resource”. Measured as “% Allocation” Work: Refers to amount of “Work” to be completed. Measured as … Continue reading
August 29, 2011
by soni
2 Comments
If you’re managing projects, you must have come across Overtime Cost to represent cost of workers working beyond 5hrs of scheduled day. For non-project professionals, the best way will be to direct enter “Overtime Work” in Entry table of Gantt … Continue reading
August 4, 2011
by admin
0 comments
One can add progress lines to the Gantt view using Tools -> Tracking -> Progress Lines… option. What is the relevance of such progress line and what do they reveal about current project. This is common query which participants raise … Continue reading
June 21, 2011
by soni
6 Comments
In MS Project “Lead Time” represents the overlap between Predecessor and Successor tasks wherein the Successor can start much early to finish of predecessor tasks. E.g. For a party the menu can be decided before Party starts. In such case … Continue reading
June 21, 2011
by soni
2 Comments
As title goes renaming a field in MS Project is as easy as double click the field name and type the required title. That’s all!! But if we see our filters, views, tables, groups where above text30 field is … Continue reading
June 3, 2011
by soni
0 comments
Will it be nice to get a quick turnaround and get the basic questions on Where my project stands? Yes, Most PM can find such answers covering current estimated Start date, Finish date, Baseline details as well as Variances quickly … Continue reading
June 2, 2011
by soni
0 comments
Whenever a new task is created with user defined Start date or it is scheduled with “Must Start on” or other constraints, it impacts scheduling and resolving resource overallocation issues while tracking projects during execution phase. If we change the project Start … Continue reading
June 1, 2011
by admin
1 Comment
Adding color code to various tasks is most priliminary task a Project Manager has to report in his day to day reporting to team and senior management. Think of scenario where project manager needs to update this for tasks running … Continue reading