Project - Gantt Chart - Gantt Chart Report Date: 2023-04-10 2023-04-10

Project Name Moyale Water Supply Project 2023 2023 2023 2023 2023 2023 2023 2023
Project Start Date Thu,1/Jun/23 Jun Jul Jul Aug Sep Oct Nov Dec
Display Week 1

29

12
19
26

10
17
24
31

14
21
28

11
18
25

16
23
30

13
20
27

11
18
25
5

2
9

1
No Activities Start Finish Days Status %done
1.1 Guard House 28-May-23 26-Jul-23 59 d INP 0%
1.1.1 Earth Work and Excavation 28-May-23 09-Jun-23 10 INP 0%
1.1.2 Hardcore 29-May-23 30-May-23 2 INP 0%
1.1.3 Masonry foundation wall 30-May-23 31-May-23 2 COMP 0%
1.1.4 50mm thick lean concrete 31-May-23 02-Jun-23 3 INP 0%
1.1.5 Grade C-25 RCC For Grade beams 31-May-23 01-Jun-23 2 INP 0%
1.1.6 Grade C-25 RCC Column 08-Jun-23 09-Jun-23 2 NS 0%
1.1.7 For lintels and Top tie beam 07-Jun-23 08-Jun-23 2 NS 0%
1.1.8 10cm thick mass concrete to floor 07-Jun-23 08-Jun-23 2 NS 0%
1.1.9 Formwork to floor slab 07-Jun-23 08-Jun-23 2 NS 0%
1.1.10 Formwork to column 08-Jun-23 09-Jun-23 2 NS 0%
1.1.11 Formwork to grade beam 08-Jun-23 09-Jun-23 2 NS 0%
1.1.12 Form work to top tie beam 08-Jun-23 09-Jun-23 2 NS 0%
1.1.13 High yield reinforced steel bars to specification 08-Jun-23 09-Jun-23 2 NS 0%
1.1.14 Carpentry and Joiney 29-May-23 30-May-23 2 NS 0%
1.1.15 LTZ steel framed doors and windows 29-May-23 30-May-23 2 NS 0%
1.1.16 200mm thick HCB wall 29-May-23 30-May-23 2 NS 0%
1.1.17 Three coats of plastering 28-May-23 29-May-23 1 NS 0%
1.1.18 30mm thick cement sand screed for the floor 28-May-23 29-May-23 1 NS 0%
1.1.19 Three coats of Painting 28-May-23 29-May-23 1 NS 0%

1
Adding Milstone Diamonds

percentage completed

Complete status golden colur

Adding the Gantt bar
IF(H$5=($F8-WEEKDAYS($F8,2)+1),"u","")
AND($G7>0,H$5<=($C7+($D7-$C7)*$G7)-WEEKDAY(($C7+($D7-
$C7)*$G7),2)+1,H$5>=$C7-WEEKDAY($C7,2)+1)
AND($F7="COMP",H$5=$D7-WEEKDAY($D7,2)+1)
I$4=(TODAY()-WEEKDAY(TODAY(),2)+1)
AND($I7>0,K$4<=($E7+($F7-$E7)*$I7)-WEEKDAY(($E7+($F7-
$E7)*$I7),2)+1,K$4>=$E7-WEEKDAY($E7,2)+1)
AND($I7>0,K$4<=($E7+($F7-$E7)*$I7)-WEEKDAY(($E7+($F7-$E7)*$I7),2)+1)
K$4=TODAY()-WEEKDAY(TODAY(),2)
AND(K$4>=$E6-(WEEKDAY($E6,2)+1),K$4<=$F6)
AND(K$4>=$E6-(WEEKDAY($E6,2)+1),K$4<=$F6)
K$4=(TODAY()-WEEKDAY(TODAY(),2)+1)
AND(K$6>=$E9-(WEEKDAY($E9,2)+1),K$6<=$F9)

IF(MONTH(D3-WEEKDAY((D3),2)+1)<MONTH(D3),(D3-28-DAY(D3)+7)-WEEKDAY((D3-
DAY(D3)+7),2)+1,(D3-DAY(D3)+7)-WEEKDAY((D3-DAY(D3)+7),2)+1)

AND(K$4>=$E6,K$4<=$F6)
AND(K$5>=$E8,K$5<=$F8)
AND($E$5>=$B$7,$E$5<=$C$7)
AND(K$4=TODAY())
IF(F6="","",NETWORKDAYS(E6,F6))