0% found this document useful (0 votes)
13 views6 pages

Gantt Chart With Steps

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 6

WEEK 14 CBA OM-PM

14NOV2023 - SESSION 1 TUESDAY

TOPIC FOR DISCUSSION: INTRODUCTION TO GANTT CHART DEVELOPMENT

PROJECT
PROJECT NAME PROJECT START DATE
PROJECT END DATE
DURATION
Office renovation 27 June 11, 2023 July 08, 2023

June 11, 2023


June 12, 2023
June 13, 2023
June 14, 2023
Task ID Task Descriptions Task Duration Satrt Date End Date
1 Demolitions 4 June 11, 2023 June 15, 2023 X X X X
2 Install new wall partitions 2 June 16, 2023 June 18, 2023
3 Reroute current plumbing 2 June 19, 2023 June 21, 2023
4 Painting new walls and ceiling 2 June 22, 2023 June 24, 2023
5 Install baseboard 1 June 25, 2023 June 26, 2023
6 Install new fixtures 1 June 27, 2023 June 28, 2023
7 Place new appliances 1 June 29, 2023 June 30, 2023
8 Install new office caninets 3 July 01, 2023 July 04, 2023
9 Install new lights 1 July 05, 2023 July 06, 2023
10 Final delivery with customer 1 July 07, 2023 July 08, 2023

Nov 14 tues.

process of a project

just explaing things from no. 1 to 10

no formula yet

June 11, 2023 numerical on top as you can see just transform into word
LOPMENT

m into word
X
June 15, 2023

X
June 16, 2023

X
June 17, 2023

X
June 18, 2023 Nov-14

X
June 19, 2023

X
June 20, 2023

X
June 21, 2023

X
June 22, 2023

X
June 23, 2023

X
June 24, 2023

X
June 25, 2023

X
June 26, 2023

X
June 27, 2023

X
June 28, 2023

X
June 29, 2023

X
June 30, 2023

X
July 01, 2023

X
July 02, 2023

X
July 03, 2023
X
July 04, 2023
X
July 05, 2023
X

July 06, 2023


X

July 07, 2023


X

July 08, 2023


July 09, 2023
July 10, 2023
Project Base task decleration Project start date
office renuvation 2/5/24

task ID Tasj Description Task Declaration Start Date


1 demolition 6 ###
2 new wall and partition 2 ###
3 revu and planting 2 ###
4 painting walls and celing 2 ###
5 instal baseboard 1 ###
6 instal pictures 1 ###
7 place new applainces 1 ###
8 install new office cabinets 3 ###
9 instal new lights 1 ###
10 delivery of office to client 1 ###
Project End Date
2/21/24

End Date
February 11, 2024
February 14, 2024
February 15, 2024
February 16, 2024
February 16, 2024
February 17, 2024
February 18, 2024
February 21, 2024
February 20, 2024
February 21, 2024
End Date
why not start in last 3 months of the year
it has lot of holidays which is lazy day plus start date and decleration date

not also january in cebu in construction since sinulog

start 1st quarter Feb or march

go to HOME
PRESS the general bar then more select date =IF(AND(F$10>=$D11,F$10<=$E11),"X","")
5/2/2024

for color set up in table

> go styles then conditional formating

ALWAYS CHECK THE DATES IF ITS IN THEIR CORRECT ORDERS


THE FORMULA
AND THE STEPS
ecleration date

1,F$10<=$E11),"X","")

You might also like