Spreadsheet: mary_fischer__25408__TrentMesapavout1201revised
Sheet: ContractRef

Trent Mesa Contract / Warranty Reference
Executive Summary
This sheet provides data needed to compute contractually important metrics & cross references to Construction documents.
Due to Visupro data recording anomalies during the first 60 days the data 30 day and 60 day availabilities are based on the following logic:
If there is reliable SCADA data throughout the rampup period then compute the availability from the data.  All 90 day rampup data is exact.
If there is no reliable SCADA data throughout the 30 or 60 day rampup periods then use the following:
 | For month m and the following month f
 | If 30 or 60 day rampup starts between m/1 and m/6 then rampup availability = availability for mth month.
 |  | m/1 is the first day of month m and [NAME] is the sixth day of month m.
 | If 30 or 60 day rampup starts between [NAME] and m/25 then rampup availability = Average the availability of months m and f.
 | If 30 or 60 day rampup starts between m/26 and End of Month then rampup availability = availability of fth month.
 |  |  |  |  | Goal |  |  | Ramp up Goal | 0.65 | 0.75 | 0.85
Site | Row | Pad | Construct ID | Start Date For Avail Warranty | Start Date Group | End of 30 day ramp up | End of 60 day ramp up | End of 90 day ramp up | 30 day Avg Contractual Availability | 60 day Avg Contractual Availability | 90 day Avg Contractual Availability
TrentMesa | 1 | 1 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8539
TrentMesa | 1 | 2 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.6594953982654622
TrentMesa | 1 | 3 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8659
TrentMesa | 1 | 4 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9906
TrentMesa | 1 | 5 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.97
TrentMesa | 1 | 6 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9933
TrentMesa | 1 | 7 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8902
TrentMesa | 1 | 8 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9231
TrentMesa | 1 | 9 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.7824
TrentMesa | 1 | 10 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8514
TrentMesa | 1 | 11 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8444
TrentMesa | 1 | 12 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9969
TrentMesa | 1 | 13 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.6964302824516666
TrentMesa | 1 | 14 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.882
TrentMesa | 1 | 15 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9878
TrentMesa | 1 | 16 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8185
TrentMesa | 1 | 17 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8683
TrentMesa | 1 | 18 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9726
TrentMesa | 1 | 19 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.972
TrentMesa | 1 | 20 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.96967
TrentMesa | 1 | 21 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.7327
TrentMesa | 1 | 22 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.89
TrentMesa | 1 | 23 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.3772
TrentMesa | 1 | 24 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9889
TrentMesa | 1 | 25 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9879
TrentMesa | 1 | 26 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9719
TrentMesa | 1 | 27 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9957
TrentMesa | 1 | 28 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8406
TrentMesa | 1 | 29 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8785
TrentMesa | 1 | 30 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9115
TrentMesa | 1 | 31 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9158
TrentMesa | 1 | 32 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9462810108972872
TrentMesa | 1 | 33 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9907
TrentMesa | 1 | 34 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.2794
TrentMesa | 1 | 35 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.5126226861630264
TrentMesa | 1 | 36 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.6838
TrentMesa | 1 | 37 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8154
TrentMesa | 1 | 38 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9551
TrentMesa | 1 | 39 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9855
TrentMesa | 1 | 40 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9231
TrentMesa | 1 | 41 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9602
TrentMesa | 1 | 42 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.974
TrentMesa | 1 | 43 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.8137
TrentMesa | 1 | 44 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9549
TrentMesa | 1 | 45 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9548
TrentMesa | 1 | 46 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9179565369028917
TrentMesa | 1 | 47 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.965
TrentMesa | 1 | 48 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.9131
TrentMesa | 1 | 49 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8971519562324732
TrentMesa | 1 | 50 |  | 2001-11-02 00:00:00 | 10 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 51 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.5468164183736809
TrentMesa | 1 | 52 |  | 2001-09-04 00:00:00 |  |  |  |  |  |  | 0.9346795468653011
TrentMesa | 1 | 53 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8364137181874612
TrentMesa | 1 | 54 |  | 2001-09-04 00:00:00 |  |  |  |  |  |  | 0.9506967592592592
TrentMesa | 1 | 55 |  | 2001-09-01 00:00:00 |  |  |  |  |  |  | 0.511
TrentMesa | 1 | 56 |  | 2001-09-04 00:00:00 |  |  |  |  |  |  | 0.8474290275563177
TrentMesa | 1 | 57 |  | 2001-09-04 00:00:00 |  |  |  |  |  |  | 0.9871940586419753
TrentMesa | 1 | 58 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.2059512725015518
TrentMesa | 1 | 59 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9651465933199188
TrentMesa | 1 | 60 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8848391203703704
TrentMesa | 1 | 61 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.7551097920546245
TrentMesa | 1 | 62 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9760241409697762
TrentMesa | 1 | 63 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.837879990783307
TrentMesa | 1 | 64 |  | 2001-09-04 00:00:00 |  |  |  |  |  |  | 0.87039130296675
TrentMesa | 1 | 65 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.4527855369335816
TrentMesa | 1 | 66 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9956750575437259
TrentMesa | 1 | 67 |  | 2001-11-02 00:00:00 | 10 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 68 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.937449097892156
TrentMesa | 1 | 69 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9954170312516879
TrentMesa | 1 | 70 |  | 2001-09-06 00:00:00 |  |  |  |  |  |  | 0.7441584702865475
TrentMesa | 1 | 71 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.995474211116172
TrentMesa | 1 | 72 |  | 2001-09-07 00:00:00 |  |  |  |  |  |  | 0.8873102886405959
TrentMesa | 1 | 73 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.5872140751086282
TrentMesa | 1 | 74 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9936481260930304
TrentMesa | 1 | 75 | B-5 | 2001-10-22 00:00:00 |  |  |  |  |  |  |  | Comm problems in first & third 90 days.
TrentMesa | 1 | 76 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.5744258224705152
TrentMesa | 1 | 77 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8437748049484057
TrentMesa | 1 | 78 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8978768814219504
TrentMesa | 1 | 79 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9510930524645113
TrentMesa | 1 | 80 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.971758788773889
TrentMesa | 1 | 81 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9212323257498041
TrentMesa | 1 | 82 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.925114189075272
TrentMesa | 1 | 83 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.864549037667314
TrentMesa | 1 | 84 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.9857332161282267
TrentMesa | 1 | 85 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8984844819610489
TrentMesa | 1 | 86 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8820656446616847
TrentMesa | 1 | 87 |  | 2001-09-07 00:00:00 |  |  |  |  |  |  | 0.8317729671011794
TrentMesa | 1 | 88 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.6859904562383613
TrentMesa | 1 | 89 |  | 2001-09-07 00:00:00 |  |  |  |  |  |  | 0.993332452363896
TrentMesa | 1 | 90 |  | 2001-09-18 00:00:00 |  |  |  |  |  |  | 0.8299906890130354
TrentMesa | 1 | 91 |  | 2001-11-02 00:00:00 | 10 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 92 |  | 2001-10-31 00:00:00 | 9 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 93 |  | 2001-11-02 00:00:00 | 10 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 94 |  | 2001-10-26 00:00:00 |  |  |  |  |  |  | 0.9999371645330167
TrentMesa | 1 | 95 |  | 2001-11-06 00:00:00 | 11 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 96 |  | 2001-11-06 00:00:00 | 11 |  |  |  |  |  |  | 90 days not yet complete
TrentMesa | 1 | 97 | B-6 | 2001-10-26 00:00:00 |  |  |  |  |  |  | 0.9999567193968681
TrentMesa | 1 | 98 | B-7 | 2001-10-26 00:00:00 |  |  |  |  |  |  | 0.767765135162405
TrentMesa | 1 | 99 | B-8 | 2001-10-19 00:00:00 |  |  |  |  |  |  |  | No comm in 3rd ramp up period
TrentMesa | 1 | 100 | [NAME] | 2001-10-19 00:00:00 |  |  |  |  |  |  | 0.6655223765432099
 |  |  |  |  | Actual
 |  |  |  |  | Goal |  |  | Ramp up Goal | 0.65 | 0.75 | 0.85
 |  |  |  |  | [NAME]
 |  |  |  |  | Negative variances are undesirable.