[go: up one dir, main page]

0% found this document useful (0 votes)
420 views23 pages

Excel Gantt Chart Sample

The document outlines a drilling project schedule with task names, start dates, end dates, and durations. Key tasks include rig move, casing installations at various diameters, drilling holes at different diameters, installing blowout preventers, logging, plug and abandonment, and rig down/demobilization. The schedule spans from July 25, 2016 to August 29, 2016.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
420 views23 pages

Excel Gantt Chart Sample

The document outlines a drilling project schedule with task names, start dates, end dates, and durations. Key tasks include rig move, casing installations at various diameters, drilling holes at different diameters, installing blowout preventers, logging, plug and abandonment, and rig down/demobilization. The schedule spans from July 25, 2016 to August 29, 2016.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 23

Task Name Start Date End Date Duration Start Date in Number Form 42576.

Duration Start Date in Number Form 42576.00 Use this number for the Minimum Bound of the Horizontal Axis to set the beginning of the chart.

Rig Move 7/25/2016 7/30/2016 2


7/25/16 7/30/16 8/4/16 8/9/16 8/14/16 8/19/16 8/24/16
Jack Down & Preload 7/27/2016 8/1/2016 1
Rig Move

RigUp & Test 7/27/2016 8/4/2016 1 Jack Down & Preload

Drill 36" Hole 7/27/2016 8/6/2016 1.25 RigUp & Test

Install 30" Casing 8/1/2016 8/9/2016 1.25 Drill 36" Hole

Drill 26" Hole 8/1/2016 8/5/2016 1.5 Install 30" Casing

Install 20" Casing & BOP 8/3/2016 8/10/2016 1.25 Drill 26" Hole

Install 20" Casing & BOP


Drill 16" Hole 8/5/2016 8/12/2016 9
Drill 16" Hole
Install 13-3/8" Casing 8/6/2016 8/9/2016 2.75
Install 13-3/8" Casing
Drill 12-1/4" Hole 8/6/2016 8/10/2016 8.5
Drill 12-1/4" Hole
Install 9-5/8" Casing & MPD Equipment 8/7/2016 8/13/2016 2.75
Install 9-5/8" Casing & MPD Equipment
Drill 8-1/2" Hole w/ MPD 8/10/2016 8/16/2016 1.75
Drill 8-1/2" Hole w/ MPD
Run 7" Liner & Rig Down MPD Equipment 8/14/2016 8/19/2016 2.75
Run 7" Liner & Rig Down MPD Equipment

Drill 6 " Hole 8/15/2016 8/23/2016 2 Drill 6 " Hole

Reservoir Logging 8/16/2016 8/26/2016 1.5 Reservoir Logging

Plug & Abandonment 8/17/2016 8/28/2016 2 Plug & Abandonment

Rig Down & Demob 8/18/2016 8/29/2016 2.75 Rig Down & Demob

Key: Calculated Cell Manual Entry Cell

These cells will be automatically calculated based on These cells require manual input so the calculated
the inputs on other cells. cells have data to work with.
Task Name Start Date End Date

1. Research to analyse and evaluate similar investi 9/1/2021 11/30/2021

2. Explore ways of improvement of existing digital 11/30/2021 7/28/2022

3. Develop database using statistical methods 7/28/2022 1/24/2023

4. Develop integrated models – pore space and so 1/24/2023 7/23/2023

5. Evaluate the application of boundary constrains 7/23/2023 2/18/2024

6. Recommend the application 2/18/2024 8/16/2024


Duration (Days) Start Date in Number Form 44440.00 Use this number for the Minimum Bound o

9/1/2021 12/30/2021 4/29/2022 8/


90
1. Research to analyse and evaluate similar investigations 90
240

180
2. Explore ways of improvement of existing digital-rock approaches. 11/30/2021 240
180

210 3. Develop database using statistical methods 7/28/2022

180
4. Develop integrated models – pore space and solid framework 1/24/2023

Key: Calculated
5. Evaluate the application of boundary constrains to a non-solid domain Cell 7/2

These cells will be automatically calculated based on the


inputs6.on other cells.
Recommend the application

1080
for the Minimum Bound of the Horizontal Axis to set the beginning of the chart.

12/30/2021 4/29/2022 8/27/2022 12/25/2022 4/24/2023 8/22/2023 12/20/2023 4/18/2024 8/16/2024

2021 240

7/28/2022 180

1/24/2023 180

ell 7/23/2023 Manual Entry Cell 210

lculated based on the These cells require manual input so the


calculated cells have data to work with.
2/18/2024 180
/2024 8/16/2024

180
Task Name Start Date End Date

Rig Move 1/15/2019 1/18/2019

36" Section 1/18/2019 1/24/2019

26" Section 1/24/2019 1/27/2019

16" Section 1/27/2019 2/8/2019

12-1/4" Section 2/8/2019 2/19/2019

8-1/2" Section 2/19/2019 2/23/2019

6" Section + P&A + Demob 2/23/2019 3/3/2019

Drilling Mud materials and additives 1/15/2019 1/18/2019

Casing 30" + Riser 21" + Wellhead 1/15/2019 1/18/2019

Serv. Companies Equipment & Materials 1/15/2019 1/18/2019

Personnel: Contractor + Operator 1/15/2019 1/16/2019

Personnel: Service Companies 1/15/2019 1/17/2019

Casing 20" + Shoe Track + Riser 16" 1/16/2019 1/23/2019

Casing 13-3/8" + Shoe Track + Centralizers 1/24/2019 1/31/2019

Serv. Companies Equipment & Materials 1/28/2019 2/4/2019

Turnaorund 1: Personnel (+ MPD people) 2/2/2019 2/6/2019

Casing 9-5/8" + Shoe Track 2/5/2019 2/12/2019

MPD Equipment 2/8/2019 2/15/2019

Casing 7" + Shoe Track + Hanger Liner 2/10/2019 2/17/2019


Logging and Suspension Requirements 2/15/2019 2/22/2019

Management Visit 2/20/2019 2/21/2019

Turnaorund 2: Personnel (+ P&A people) 2/22/2019 2/26/2019

Waste transport + extras 2/22/2019 3/1/2019

Personnel Demob 2/28/2019 3/1/2019


Duration (Days) Start Date in Number Form 43483.00 Use this number for the Minimum Bound of t

3
1/15/19 1/20/19 1/25/19 1/30/19
7

3
1. Research to analyse and evaluate similar investigations

12

11

4
2. Explore ways of improvement of existing digital-rock approaches.
8

3
3. Develop database using statistical methods
3

2
4. Develop integrated models – pore space and solid framework
7

4 5. Evaluate the application of boundary constrains to a non-solid domain

7 6. Recommend the application


6. Recommend the application

Key: Calculated Cell

These cells will be automatically calculated based on the


inputs on other cells.
for the Minimum Bound of the Horizontal Axis to set the beginning of the chart.

1/20/19 1/25/19 1/30/19 2/4/19 2/9/19 2/14/19 2/19/19 2/24/19 3/1/19


Cell Manual Entry Cell

calculated based on the These cells require manual input so the


calculated cells have data to work with.
Duration
Task Name Start Date End Date
(Days)

Task One 7/25/2016 7/30/2016 5

Task Two 7/27/2016 8/1/2016 5

Drilling Mud materials and additives 7/25/2016 8/1/2016 7

Casing 30" + Riser 21" + Wellhead 7/25/2016 8/1/2016 7

Serv. Companies Equipment & Materials 7/25/2016 8/1/2016 7

Personnel: Contractor + Operator 1/11/2019 1/15/2019 4

Personnel: Service Companies 1/13/2019 1/17/2019 4

26" Section 8/1/2016 8/4/2016 3

Casing 20" + Shoe Track + Riser 16" 1/14/2019 1/21/2019 7

16" Section 8/4/2016 8/16/2016 12

Casing 13-3/8" + Shoe Track + Centralizers 1/24/2019 1/31/2019 7

Serv. Companies Equipment & Materials 1/18/2019 1/25/2019 7

12-1/4" Section 8/16/2016 8/27/2016 11

Task Fourteen 8/15/2016 8/23/2016 8

Task Fifteen 8/16/2016 8/26/2016 10

Task Sixteen 8/17/2016 8/28/2016 11

Task Seventeen 8/18/2016 8/29/2016 11


Days Percent
Days Complete Start Date in Number Form 42576.00
Remaining Complete

2.50 2.50 50%


6 6 6 16
3.75 1.25 75% 5/1 3/1 2/1 2/ /
/ 2 / 1 1/ 2/ 2
/ 10
7 9 1 1 2
1.75 5.25 25% Task One

7.00 0.00 100% Task Two

5.25 1.75 75% Drilling Mud materials and additives

Casing 30" + Riser 21" + Wellhead


1.40 2.60 35%
Serv. Companies Equipment & Materials
1.00 3.00 25%
Personnel: Contractor + Operator
2.10 0.90 70%
Personnel: Service Companies
1.05 5.95 15%
26" Section

7.20 4.80 60% Casing 20" + Shoe Track + Riser 16"

4.55 2.45 65% 16" Section

1.75 5.25 25% Casing 13-3/8" + Shoe Track + Centralizers

Serv. Companies Equipment & Materials


3.30 7.70 30%
12-1/4" Section
4.00 4.00 50%
Task Fourteen
4.00 6.00 40%
Task Fifteen
3.85 7.15 35%
Task Sixteen
1.65 9.35 15% Task Seventeen
Task Seventeen

Key: Calculated

These cells will be automatically


inputs on other cells.
Use this number for the Minimum Bound of the Horizontal Axis to set the beginning of the chart.

6 6 6 16 17 7 7 7 17 17 18 18 8 8 8 18 19
/1 /1 /1 2/ 0/ 17 /1 /1 /1 8/ 7/ 6/ 7/ 18 /1 /1 /1 2/ 1/
25 / 13
1/ 2 / 2
/ 1 / 1/ / 21
/ 10
/ 29 / 1
2/ / 2 / 1 / 6/ 25 14 / 3 / 2 1
9 1 12 2 4 5 7 8 10 1 1 3 5 6/ 8/ 10 11 1/
Calculated Cell Manual Entry Cell

e cells will be automatically calculated based on the These cells require manual input so the
s on other cells. calculated cells have data to work with.
ing of the chart.

8 8 18 19
4/1 3/1 22/ 1/
1 / / 1
8/ 10 11 1/

You might also like