MS Project-Rajeev Sharma

Download as pdf or txt
Download as pdf or txt
You are on page 1of 185

Microsoft Project

Prepared By:
Rajeev Sharma
PT-301516
MIED 2016-18
Create New Project
New Blank Microsoft Project File
Add 100+ Construction Activities and Duration
Add 100+ Construction Activities and Duration
Add 100+ Construction Activities and Duration
Add 100+ Construction Activities and Duration
Add 100+ Construction Activities and Duration
Add 100+ Construction Activities and Duration
Add Predecessors according to how it should be done
Add Predecessors and change their FS,SS,SF,FF as per
Activities requirement
After adding FS,SS,SF,FF according to their requirement
and lag required
Select All Activities
Auto Schedule it, Date Changes according to Data input
To Show Critical Activity
To Show Project Summary
Select Format Format Bar Style
Format bar
Insert Column(Right Click on Arrow Area)
Insert <Total Slack> And <Free Slack> Column
• ADD Four Text Column with
Their Lookup Value
Four Text Column
To add their lookup value, Right click on column head
and Custom field
Right click Custom Field Rename to
rename field name
Renamed Filed Name <Responsibility> <Stage> <Data
Saved > <Project manager>
To add lookup values

Right click Custom Field


Rename to rename field name
lookup values of Responsibility Column
lookup values of Stage Column
lookup values of Data Saved In
Column
lookup values of Project Manager
Column
After Assigning all the Lookup values to the Respective
columns
Create Filters
View Menu Filter New Filter
New Filter Name <Rajeev_Filter2>
Add Filter Values
Result after Adding Filter Values
Add 3line Filter
Result 3 Line Filter
Add 4line Filter
Result 4 line filter
Add 5 Line Filter
Result
To come in original Activities
View Menu Filter Clear Filter
Create Interactive Filters
To modify and make it interactive 5line Filter Values
View Menu Filter More Filter <Filter
Name> Edit
Add in Values Question
“< Question>:”?
Add All Questions OK Apply
Dialogue Box will Open For Filter the matter
Interactive Filter <Responsibility>
Interactive Filter <Stage>
Interactive Filter <Project manager>
Interactive Filter <Storage>
Interactive Filter <Critical>
Result After Filter the values
To come in original Activities
View Menu Filter Clear Filter
Result-Clear Filter
Resource
To Add Resource
Click Resource Sheet
Blank resource sheet
Add Resource on every activities
Assign Resource
Assign resource & Unit
After assigning resource OK
Assign All Resources
Resource Level Resource
Level Resource task bar Level now
Level Auto Resourced
Add Cost Column
Resource Graph
View Other view Resource Graph
Resource Graph
Work Contour
View Resource Usage
Select all activities which is doing by Mason
Select Front loaded in work contour
Result
To See Resource Graph
Select
View Other View Resource Graph
Resource Graph
Grouping
Create Group
Select Activity for Grouping
Create Grouping
Result
Phase Grouping
Apply
Result
Clear Phase
Calendar Making
Project Menu Change Working time
Dialogue Box will open , Here we can manage our calendar
All Saturday Working
Add Start and Finish
Go to Details
Add as working Hours
Set as Weekly Tick Saturday Set End By Date OK
2nd and Last Saturday Non-Working
Set as Monthly Last Saturday Of Every 1 Month
Set End By Date OK
Set as Monthly 2nd Saturday Of Every 1 Month
Set End By Date OK
2nd and 4th Saturday Non-Working
Add Start and Finish Date
Set as Monthly 4th Saturday Of Every 1 Month
Set End By Date OK
Add any holidays
Add Start and Finish Date
Apply Ok
Project Final Statics
Project Menu Project Information
Adding Formula
Add new column
Adding formulae

Step 1 : Right Click on the column header > Click on Custom fields
Step 2 : Rename the column as Interfering float > Click on the bubble formula >
Click on formula
Step 3 : In the formula box, click on field, select duration and select total float
Step 3 : In the formula box, click on field, select duration and select total float
Step 4 : Next select the mathematical operation
Step 6 : In the formula box, click on field, select duration and select free
float > Click OK
Note: Interfering float is the time available to delay an
Step 7 : OUTPUT activity without delaying the project’s estimated
completion time, but delaying an activity into interfering
float will delay the start of one or more following non-
critical activities.
Using Iff function
Method : Add a new column > Go to custom fields and rename
as Activity critical or non-critical
Click on formula > Click on function > Click on function
> click on general > select Iff ( Expression, true, false)
Delete the word expression in the formula > click on field > select
duration > click on duration > use the symbol = and type “0” > in
the true part type “ Critical” and in the false part type “Non-
Critical” > click on OK
OUTPUT
Using Switch function
Method : Add a new column > Go to custom fields and
rename as Switch drawing numbers
Click on formula > Click on function > Click on function > click on
general > select switch ( Expression1, value1…)
Add Formulae
Output of switch function
Recurring activities
Here let us consider payday as the recurring activity throughout the
project duration.
Click on task tab > Click on task > select recurring task
Enter the name of the activity> enter the recurrence
pattern >select the day >click on OK
Output
Macro and creating switch
Click on view tab > click on macros > Click on record macro
Enter the macro name > set the shortcut as Ctrl + A >write the
description> Click on OK to start recording
In the recording – select all the activities by clicking on the
box in the left corner > Click on resource tab > click on level
resources > click Ok > Stop recording
k on view tab > click on macros > select stop recording
Creating button/switch
Let us create a new micro as shown previously with task range filter
Click on view > Click on macro > click on record macro > Enter name as task range
filter > type shortcut as Ctrl + U > enter the description > Click on OK
Record the macro by clicking on filter > select task Range > set the from and to ID
>Click OK > click on view > Click on macro > select stop recording
Go to view > select macro > select view macro > select the task
range filter macro and click on edit
After clicking on Edit, select the code lines as shown below
Then click on insert > select userform
In the user form dialogue box click on the command button from the
side menu and drag a box and rename it as task range filter > double
click on the command and paste the link copied earlier
Click on Run
Click on Task
After Clicking on run we will get the button dialogue box > click on
the button task range filter and enter thebetween ID as 150 and
And ID as 180 and click on OK
Output : We can observe that it now displays all
activities with task ID between 150 and 180
COST FORECAST

• Earned value,
• Planned value,
• CPI, SPI
• Cost
Click on Project Set Base line Set Baseline
Click Ok
File Options
Schedule uncheck actual cost
To see earn value table
View Table more Table
Click Earn value Cost Indicator
Add New table % Completed
Result
Result
Cleat Table
To get Actual cost Table

Table More table


Apply
Crete New Table
Add Field Name
Apply
Result
Add Cost Column
Project Reports
Click on Report tab >select Custom
Select Resources > Resource overview
Output
Resource Overview Report
Report on Cost overrun
lick on reports tab > select customize > Select costs > select cost
verruns
Reports
Cost Overrun Reports
Earn Value Report
RESOURCE COST OVERVIEW
RESOURCE COST OVERVIEW
COST OVERRUNS
COST OVERRUNS
PROJECT OVERVIEW
BURNDOWN
• Ribbon
Go to Resource sheet
Right Click Customize ribbon
Add 12 Ribbons
Apply Ok
Result
Project Link
Project1
Project2
Project 3
Click Sub Project
result
Grantt Chart
THANK YOU

You might also like