Pert Analysis.xls

	B	C	D	E	F	G	H	J
1
2
3
4
5
6				PERT ANALYSIS CALCULATOR
7
8			USER SUPPLIED ESTIMATES		PERT
9		OPTIMISTIC	MOSTLY	PESSIMISTIC	EXPECTED	Std. Deviation	Variance	Pert = O+4M+P 6
10	Critical Path Tasks				DURATION
11	Requirments Gathering	2	4	6	4.00	0.667	0.444	Varience = ((P-V) ^2 6
12	Task A	2	5	9	5.17	1.167	1.361
13	Task B	2	5	9	5.17	1.167	1.361
14	Task C	2	5	9	5.17	1.167	1.361
15	Task D	2	5	9	5.17	1.167	1.361
16
17				Mean	24.67		5.889
18
19	Enter Desired Completion Time >>>		21	Probability of Completion >>>>>			6.54%
20
21
22
23	(Sample project - change task names & number of tasks as necessary - be sure to adjust formulae to reflect the number of tasks)
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100