Spreadsheet: 691734d1597847526-use-min-and-max-excluding-top-and-bottom-values-average_of_table
Sheet: Sheet2

 |  |  | Concept | Average | Minimum | [NAME] | TRIMMEAN(IF(B2:B12=8,C2:C12),40%)
ID | ESTIMATE TYPE | P50%
7 | PostTender | 0.0414718055050178
15 | PostTender | 0.05840296146869716
25 | PostTender | 0.06440606282348108
108 | PostTender | 0.06564108096627212
4 | PostTender | 0.07425908858755631
6 | PostTender | 0.08983269753882761
41 | PostTender | 0.1038520347672508
44 | Detailed | 0.1040203215443415
86 | PostTender | 0.1052285799642419
111 | PostTender | 0.1062532881783433
34 | PostTender | 0.1067774550899212
55 | Detailed | 0.1073603825284964
35 | PostTender | 0.1138221368661211
47 | Detailed | 0.1163331522144812
102 | PostTender | 0.1206201853080525
23 | Detailed | 0.1207368905038164
48 | PostTender | 0.1207515605378545
110 | Concept | 0.1251699910840994
45 | Detailed | 0.1267497266324078
101 | PostTender | 0.1278792870225837
32 | Detailed | 0.1309973086831965
95 | PostTender | 0.135737810013832
33 | Detailed | 0.1357881859938649
3 | Detailed | 0.1358394754083828
38 | Detailed | 0.1380876957215597
29 | Detailed | 0.1395813000302973
146 | PostTender | 0.1408595959243796
116 | PostTender | 0.141680059842302
42 | PostTender | 0.1476846805201352
99 | Detailed | 0.149700479556419
114 | PostTender | 0.1511707641168817
103 | PostTender | 0.1520595494703789
21 | Concept | 0.1535449997263535
154 | Detailed | 0.1541784908311779
149 | Detailed | 0.1561376346955876
88 | PostTender | 0.1563875689412048
16 | PostTender | 0.1611436896613565
113 | PostTender | 0.1621087470375911
28 | Detailed | 0.1636726721044164
90 | Detailed | 0.1638097545075757
27 | Detailed | 0.1643807660323337
124 | Detailed | 0.1732708113476786
2 | Detailed | 0.1748303177886639
72 | Detailed | 0.1801415321106609
112 | Detailed | 0.1833659516069747
84 | Concept | 0.1889925085697778
122 | Concept | 0.1950451246874145
14 | Concept | 0.197514413871738
98 | PostTender | 0.1987091333351333
93 | Detailed | 0.1996603361701524
30 | Concept | 0.2043939445462139
24 | Concept | 0.2060076503643486
85 | Concept | 0.2085314595478486
137 | Detailed | 0.2111428917262188
80 | Detailed | 0.2115128664898155
94 | Detailed | 0.2115128664898155
51 | Concept | 0.2163629343915396
115 | Concept | 0.2172664427638858
49 | Detailed | 0.2201670027109705
134 | Detailed | 0.2326592239615805
119 | Concept | 0.233040586378616
22 | Concept | 0.23365475154765
54 | Concept | 0.2385566113549838
107 | Detailed | 0.2396568816964952
31 | Concept | 0.2425301583552431
36 | Concept | 0.2475053304538311
17 | Concept | 0.2512745201804476
43 | Concept | 0.2527336344313422
125 | Detailed | 0.2537388282915122
50 | Concept | 0.2569500697324475
82 | Concept | 0.2571226054581837
10 | Concept | 0.261533383438471
123 | Concept | 0.2685068811424274
96 | Concept | 0.2687828968899768
74 | Concept | 0.2722083646147448
100 | Concept | 0.2743673980500108
105 | Concept | 0.2743673980500108
39 | Concept | 0.2746859870821728
97 | Concept | 0.2761270548321333
121 | Concept | 0.2776557912250813
81 | Strategic | 0.2849589794835226
5 | Strategic | 0.291236632550681
40 | Concept | 0.2922282699701764
9 | Concept | 0.2996756803748034
118 | Concept | 0.3005660549314703
52 | Strategic | 0.3038692081685272
76 | Concept | 0.3083410486742215
78 | Strategic | 0.3252562323288677
117 | Concept | 0.3284942999880693
83 | Strategic | 0.3301562295094683
104 | Strategic | 0.3335214150106699
37 | Strategic | 0.3361559844583045
56 | Concept | 0.3401611340960605
73 | Concept | 0.3401611340960605
75 | Concept | 0.3419151641009603
109 | Strategic | 0.3433558195216764
91 | Strategic | 0.3476855401592936
19 | Strategic | 0.3618432184803941
153 | Concept | 0.3626364342477041
79 | Strategic | 0.3677122913249064
151 | Strategic | 0.3790608888810877
8 | Strategic | 0.3815924692557183
11 | Strategic | 0.3818170763645207
135 | Strategic | 0.4006324826552159
46 | Strategic | 0.4207033955787888
12 | Concept | 0.4260397255639086
150 | Strategic | 0.426107478844941
141 | Strategic | 0.4398011009860193
148 | Strategic | 0.4405119807381438
92 | Strategic | 0.457272283516757
132 | Strategic | 0.458524281587036
131 | Strategic | 0.4723129541276807
128 | Strategic | 0.4734747965759344
140 | Strategic | 0.4771918414272543
129 | Strategic | 0.4858278678903246
130 | Strategic | 0.4900448534870265
89 | Concept | 0.4954167836764711
133 | Concept | 0.5340718084641711