KEMBAR78
Critical Path Method | PDF
Scribd
Upload
19 views2 pages

Critical Path Method

critical path method excell templete

Uploaded by

g-65281770
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
19 views2 pages

Critical Path Method

critical path method excell templete

Uploaded by

g-65281770
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/ 2

Critical Path Method

Start Date Days to Completion


1/1/2019 20.00 Critical tasks
Finish Date No successor defined yet
1/29/2019 Times (in Days)
Time Distribution: Triangular [42]

ID Task Name Predecessors O M P Duration ES EF LS LF Slack


(Enter one ID per cell) (min) (most likely) (max) (exp. time)
10 Start 0.00 0.00 0.00 0.00 0.00 0.00
100 PHASE 1 140 0.00 10.67 10.67 20.00 20.00 9.33
110 Task A 10 2 4 6 4.00 0.00 4.00 0.00 4.00 0.00
120 Task B 10 3 5 9 5.67 0.00 5.67 3.67 9.33 3.67
130 Task C 110 4 5 7 5.33 4.00 9.33 4.00 9.33 0.00
140 Task D 110 4 6 10 6.67 4.00 10.67 8.33 15.00 4.33
200 PHASE 2 220 230 0.00 20.00 20.00 20.00 20.00 0.00
210 Task E 120 130 4 5 7 5.33 9.33 14.67 9.33 14.67 0.00
220 Task F 140 3 4 8 5.00 10.67 15.67 15.00 20.00 4.33
230 Task G 210 3 5 8 5.33 14.67 20.00 14.67 20.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00
1000 Finish 100 200 0.00 20.00 20.00 20.00 20.00 0.00

Days:
0 5 10 15 20 25
Start
PHASE 1 ES Flexible Slack
Task A
Task B
Task C
Task D
PHASE 2
Task E
Task F
Task G

http://www.vertex42.com/ExcelTemplates/critical-path-method.html
Holidays to Exclude from Working Days
See help (F1) on the WORKDAY() function

This worksheet lets you create a list of dates to be excluded


from the number of Working Days. The WORKDAY() function
already excludes weekends, so you only need to list dates for
holidays and other non-working days. If your project spans
more than one year, make sure you add dates for each year.
The named range, holidays, is a dynamic named range ending
at the last blank cell in column A. The comments column is just
for your reference.

Date Non-Working Days


1/1/2019 New Year's Day
1/1/2020
12/25/2019 Christmas
12/25/2010

You might also like