Spreadsheet: 689029d1596092353-take-average-of-a-range-excluding-top-1-3-and-bottom-1-3-and-zero-values-excel
Sheet: ESTIMATESUMMARYSHEETNEW

ID | ESTIMATE PREPARED BY | PROJECT_EQUIP_NO | PROJECT PHASE | ESTIMATE DATE | YEAR OF THE $ | TYPE OF CONTRACT | OUTTURN P50 ROUNDUP
0 |  | P.0011469
1 |  | P.0010935 | Delivery Readiness | 2016-07-11 00:00:00 | 2016 |  | 180000000
2 |  | P.0011062 | Delivery Readiness | 2016-05-11 00:00:00 | 2016 | Alliance | 32500000
3 |  | P.0011204 | Delivery Readiness | 2016-06-27 00:00:00 | 2016 |  | 90000000
4 |  | P.0010455 | Construction | 2016-07-18 00:00:00 | 2016 |  | 38000000
5 |  | P.0010609 | Strategic Assessment | 2016-06-20 00:00:00 | 2016 |  | 540000000
6 |  | P.0010797 | Construction | 2016-07-31 00:00:00 | 2016 |  | 68000000
7 |  | P.0010795 | Construction | 2016-08-08 00:00:00 | 2016 |  | 69000000
8 |  | P.0010885 | Strategic Assessment | 2016-08-31 00:00:00 | 2016 |  | 234000000
9 |  | P.0007186 | Concept | 2016-09-30 00:00:00 | 2016 |  | 60000000
10 |  | P.0010842 | Delivery Readiness | 2016-08-31 00:00:00 | 2016 |  | 36000000
11 |  | P.0011424 | Strategic Assessment | 2016-06-30 00:00:00 | 2016 |  | 41000000
12 |  | P.0011424 | Strategic Assessment | 2016-06-30 00:00:00 | 2016 |  | 48000000
13 |  | P.0011424 | Strategic Assessment | 2016-06-30 00:00:00 | 2016 |  | 12000000
14 |  | P.0010544 | Concept | 2016-09-06 00:00:00 | 2016 |  | 120000000
15 |  | P.0011062 |  | 2016-08-15 00:00:00 | 2016 |  | 37000000
16 |  | P.0011172 | Construction | 2016-10-17 00:00:00 | 2016 | D&C | 276000000
17 |  | P.0010745 | Concept | 2016-09-26 00:00:00 | 2016 |  | 31000000
18 |  | P.0010970 | Strategic Assessment | 2016-09-30 00:00:00 | 2016 |  | 182000000
19 |  | P.0011325 | Strategic Assessment | 2016-08-23 00:00:00 | 2016 |  | 130000000
20 |  | P.0010408 | Concept | 2016-10-20 00:00:00 | 2016
21 |  | P.0010856 | Delivery Readiness | 2016-11-25 00:00:00 | 2016 |  | 113000000
22 |  | P.0010916 | Concept | 2017-01-18 00:00:00 | 2017 |  | 89000000
23 |  | P.0010558 | Delivery Readiness | 2016-11-01 00:00:00 | 2016 |  | 76000000
24 |  | P.0018249 | Concept | 2017-02-24 00:00:00 | 2017 |  | 93000000
25 |  | P.0010593 | Construction | 2017-02-10 00:00:00 | 2017 |  | 141000000
26 |  | P.0011444 | Concept | 2016-08-12 00:00:00 | 2016 |  | 86000000
27 |  | P.0011444 | Delivery Readiness | 2017-03-31 00:00:00 | 2017 |  | 101000000
28 |  | P.0010439 | Delivery Readiness | 2016-12-07 00:00:00 | 2016 |  | 416000000
29 |  | P.0011175 | Delivery Readiness | 2017-03-01 00:00:00 | 2017 |  | 262000000
30 |  | P.0011463 | Delivery Readiness | 2017-01-20 00:00:00 | 2017 |  | 286000000
31 |  | P.0011471 | Delivery Readiness | 2017-01-19 00:00:00 | 2017 |  | 236000000
32 |  | [NAME] | Delivery Readiness | 2017-01-16 00:00:00 | 2017 |  | 540000000
33 |  | P.0011031 | Delivery Readiness | 2016-10-12 00:00:00 | 2016 |  | 172000000
34 |  | P.0011031 | Construction | 2017-03-10 00:00:00 | 2017 |  | 174000000
35 |  | [NAME] | Construction | 2017-01-29 00:00:00 | 2017 |  | 530000000
36 |  | P.0011207 | Concept | 2016-09-01 00:00:00 |  |  | 118000000
37 |  | P.0005322 | Strategic Assessment | 2017-03-30 00:00:00 |  | D&C | 1250000000
38 |  | P.0010578 | Delivery Readiness | 2016-08-08 00:00:00 |  |  | 162000000
39 |  | P.0011200 | Concept | 2016-11-07 00:00:00 |  |  | 18500000
40 |  | P.0011200 | Concept | 2016-11-07 00:00:00 |  |  | 42000000
41 |  | P.0010555 | Construction | 2016-11-30 00:00:00 |  |  | 82000000
42 |  | P.0008971 | Delivery Readiness | 2017-01-04 00:00:00 |  |  | 46000000
43 |  | P.0006542 | Concept | 2017-01-24 00:00:00 |  |  | 79000000
44 |  | P.0009855 | Delivery Readiness | 2017-03-01 00:00:00 |  |  | 44000000
45 |  | P.0008833 | Delivery Readiness | 2017-05-25 00:00:00 |  |  | 59000000
46 |  | P.0018539 | Strategic Assessment | 2017-07-04 00:00:00 |  |  | 36000000
47 |  | P.0010544 | Delivery Readiness | 2017-07-19 00:00:00
48 |  | P.0010346 | Construction | 2017-05-05 00:00:00 |  |  | 240000000
49 |  | P.0010738 | Delivery Readiness | 2017-08-09 00:00:00 |  |  | 156000000
50 |  | P.0008812 | Concept | 2017-09-19 00:00:00 |  |  | 22000000
51 |  | P.0017695 | Concept | 2017-09-01 00:00:00 |  |  | 23000000
52 |  | P.0023181 | Concept | 2017-09-01 00:00:00 |  |  | 64000000
53 |  | P.0005324 | Delivery Readiness | 2017-10-06 00:00:00 |  |  | 28000000
54 |  | P.0010601 | Concept | 2017-05-01 00:00:00 |  |  | 600000000
55 |  | P.0018249 | Delivery Readiness | 2017-10-11 00:00:00 |  |  | 99000000
56 |  | P.0009281 | Concept | 2017-10-19 00:00:00 |  |  | 250000000
57 |  | P.0021960 | Initiation | 2017-09-21 00:00:00
58 |  | P.0021960 | Initiation | 2017-09-21 00:00:00
59 |  | P.0021960 | Initiation | 2017-09-27 00:00:00
60 |  | P.0021960 | Initiation | 2017-10-11 00:00:00
61 |  | P.0021960 | Initiation | 2017-09-27 00:00:00
62 |  | P.0021960 | Initiation | 2017-09-22 00:00:00
63 |  | P.0021960 | Initiation | 2017-09-27 00:00:00
64 |  | P.0021960 | Initiation | 2017-09-27 00:00:00
65 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
66 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
67 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
68 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
69 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
70 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
71 |  | P.0021960 | Initiation | 2017-06-20 00:00:00
72 |  | P.0005300 | Delivery Readiness | 2017-07-01 00:00:00 |  | Single Construct only contract | 172000000
73 |  | P.0009281 | Concept | 2017-11-01 00:00:00 |  | D&C Contract | 250000000
74 |  | P.0011071 | Concept | 2018-02-28 00:00:00 |  |  | 140000
75 |  | P.0011071 | Concept | 2018-02-28 00:00:00 |  |  | 136000000
76 |  | P.0011071 | Concept | 2019-05-12 00:00:00 |  | Construct Only
78 |  | P.0022890 | Strategic Assessment | 2017-11-16 00:00:00 |  | Construct | 116000000
79 |  | p.0005286 | Strategic Assessment | 2018-01-11 00:00:00 |  | Construct | 266000000
80 |  | P.0010842 | Delivery Readiness | 2017-10-12 00:00:00 |  | Construct | 40000000
81 |  | P.0020089 | Strategic Assessment | 2017-12-12 00:00:00 |  | Construct | 26000000
82 |  | P.0009987 | Concept | 2018-01-17 00:00:00 |  | Construct | 374000000
83 |  | P.0010938 | Strategic Assessment | 2017-11-30 00:00:00 |  | Construct | 370000000
84 |  | P.0011463 | Concept | 2017-11-10 00:00:00 |  | Construct | 288000000
85 |  | P.0011471 | Concept | 2018-02-05 00:00:00 |  | Construct | 222000000
86 |  | P.0010544 | Construction | 2017-12-05 00:00:00 |  | Construct | 133000000
87 |  | p.0018255 | Concept | 2018-04-09 00:00:00 |  | Design and Construct | 186000000
88 |  | p.0011068 | Construction | 2018-03-21 00:00:00 |  | Construct | 132000000
89 |  | P.0033006 | Concept | 2018-04-18 00:00:00 |  | Construct | 19500000
90 |  | p.0010916 | Delivery Readiness | 2018-04-12 00:00:00 |  | Construct | 91000000
91 |  | P.0011376 | Strategic Assessment | 2018-05-10 00:00:00 |  | Construct
92 |  | P.0019448 | Strategic Assessment | 2018-05-18 00:00:00 |  | Construct | 740000000
93 |  | p.0011436 | Delivery Readiness | 2018-05-10 00:00:00 |  | Construct | 18500000
94 |  | P.0010842 | Delivery Readiness | 2017-10-12 00:00:00 |  | Construct | 40000000
95 |  | p.0011068 | Construction | 2018-03-21 00:00:00 |  | Construct | 132000000
96 |  | P.005299 | Concept | 2017-12-01 00:00:00 |  | Construct | 83000000
97 |  | [NAME] | Concept | 2018-01-30 00:00:00 |  | Construct | 16000000
98 |  | P.0011444 | Construction | 2018-03-01 00:00:00 |  | Construct | 130000000
99 |  | P.0011175 | Delivery Readiness | 2018-01-01 00:00:00 |  | Construct | 234000000
100 |  | P.0010948 | Concept | 2018-03-15 00:00:00 |  | Construct | 176000000
101 |  | P.0010856 | Construction | 2018-09-18 00:00:00 |  | Construct | 117000000
102 |  | P.0010842 | Construction | 2018-09-10 00:00:00 |  | Construct | 29500000
103 |  | P.0011463 | Construction | 2018-08-01 00:00:00 |  | Construct | 292000000
104 |  | P.0022078 | Strategic Assessment | 2018-08-31 00:00:00 |  | Construct | 400000000
105 |  | P.0010948 | Concept | 2018-03-08 00:00:00 |  | Construct | 176000000
106 |  | P.0035567 | Concept | 2018-04-23 00:00:00 |  | Construct
107 |  | P.0022154 | Concept | 2018-05-18 00:00:00 |  | Construct | 107000000
108 |  | P.0010941 | Construction | 2018-10-10 00:00:00 |  | Construct | 140000000
109 |  | [NAME] | Strategic Assessment | 2018-11-29 00:00:00 |  | Construct | 290000000
110 |  | P.0022354 | Concept | 2018-05-18 00:00:00 |  | Design and Construct | 48000000
111 |  | P.0005324 | Construction | 2018-05-11 00:00:00 |  | Construct | 26000000
112 |  | P.010429 | Delivery Readiness | 2018-06-14 00:00:00 |  | Construct Only | 34000000
113 |  | P.011436 | Construction | 2019-01-17 00:00:00 |  | Construct Only | 17000000
114 |  | P.0011471 | Construction | 2018-12-21 00:00:00 |  | Construct Only | 220000000
115 |  | P.0018539 | Concept | 2019-12-06 00:00:00 |  |  | 50000000
116 |  | P.010429 | Construction | 2019-01-17 00:00:00 |  | Construct Only | 31000000
117 |  | [NAME] | Concept | 2019-03-31 00:00:00 |  | Construct Only
118 |  | P.0019383 | Concept | 2019-07-04 00:00:00 |  | Alliance Contract | 186000000
119 |  | P.0011325 | Concept | 2019-06-06 00:00:00 |  | Construct Only | 172000000
120 |  | P.0007010 | Construction | 2019-08-08 00:00:00 |  | Construct Only | 97000000
121 |  | P.0022002 | Concept | 2019-06-05 00:00:00 |  | Construct Only | 12500000
122 |  | P.0022890 | Concept | 2019-08-05 00:00:00 |  | Construct Only | 146000000
123 |  | P.0010948 | Concept | 2019-05-01 00:00:00 |  | Construct Only
124 |  | [NAME] | Delivery Readiness | 2019-07-10 00:00:00 |  | Construct Only
125 |  | P.0011207 | Concept | 2019-06-04 00:00:00 |  | Construct Only | 178000000
126 |  | P.0036757 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construct Only | 9000000
127 |  | P.0036757 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construct Only | 3200000
128 |  | P.0036757 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construct Only | 6400000
129 |  | P.0040773 | Strategic Assessment | 2019-07-13 00:00:00 |  | Construct Only | 36000000
130 |  | P.0040773 | Strategic Assessment | 2019-07-13 00:00:00 |  | Construct Only | 40000000
131 |  | P.0040773 | Strategic Assessment | 2019-07-13 00:00:00 |  | Construct Only | 35000000
132 |  | P.0040773 | Strategic Assessment | 2019-07-12 00:00:00 |  | Construct Only | 42000000
133 |  | P.0011445 | Concept | 2019-10-01 00:00:00 |  | Design & Construct | 2640000000
134 |  | P.0022154 | Delivery Readiness | 2019-10-25 00:00:00 |  | Construct Only
135 |  | P.0043075 | Strategic Assessment | 2019-05-09 00:00:00 |  | Construct Only | 205000000
136 |  | P.0019383 | Concept | 2019-07-04 00:00:00 |  | Construct Only
137 |  | [NAME] | Delivery Readiness | 2019-07-10 00:00:00 |  | Construction Only | 17000000
138 |  | p.0036757 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construct Only | 3200000
139 |  | p.0036757 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construction Only | 9000000
140 |  | P.0011469 | Strategic Assessment | 2019-06-25 00:00:00 |  | Construction Only | 7400000
141 |  | P.0043028 | Strategic Assessment | 2020-05-23 00:00:00 |  | Construct Only | 330000000
142 |  | P.0023287
143 |  | P.0023287
144 |  | P.0023287
145 |  | P.0023287
146 |  | P.0006733 |  | 2019-10-29 00:00:00 |  | Construct Only | 320000000
147 |  | P.0011469 | Delivery Readiness | 2020-02-04 00:00:00 |  | Construct Only | 29000000
148 |  | P.0039272 | Strategic Assessment | 2020-03-07 00:00:00 |  | Construct Only
149 |  | P.0018250 | Construction | 2020-03-27 00:00:00 |  | Construct Only | 236000000
150 |  | P.0033024 | Strategic Assessment | 2020-01-30 00:00:00 |  | Construct Only | 435000000
151 |  | P.0033024 | Strategic Assessment | 2020-01-30 00:00:00 |  | Construct Only | 430000000
152 |  | P.0010578 | Delivery Readiness | 2020-03-31 00:00:00 |  | Construct Only
153 |  | P.0036874 | Concept | 2019-10-21 00:00:00 |  | Construct Only
154 |  | P.0018252 | Delivery Readiness | 2020-05-27 00:00:00 |  | Construct Only