Spreadsheet: 129854d1321934497-excel-2007-drop-down-list-with-named-range-constants-example-data
Sheet: SST

161516.6666666667 |  |  |  |  |  |  | 8 | 9 | 10 | 11 | 1900-01-01 00:00:00 |  | 14 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00
2011-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spread of Revenue in 5 equal periods |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 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 | 101 | 102 | 103 | 75
Source | Lead Office | Project No. | Market Region | Submarket | Client | Desciption | Backlog as of 11/01/2011*100% | Backlog as of 11/01/2011*Probability | Scheduled 11/1/11 - 4/29/12 | Date of Remaining Value | Probability of Realizing Value | Remaining Value (Labor Rev) | Months to Complete From Date of  Remaining Value | Average Project Rate / hr | Percent 1st period | 2nd | 3rd | 4th | 5th | Total | Month No. | 20% months | Adjusted | [NAME] | [NAME] | 1/Rate | Amount Spread with % Prob |  | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00
DO NOT SORT ABOVE THIS ROW
Alexiades | Billings | 0 | NPCC | IOU | NGRID | Bridgewater |  |  |  | 2011-11-01 00:00:00 | 1 | 150000 | 5 | 110 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1 | 31 | 1 | 1 | 150000 | 0 | 0.00909090909090909 | 150000 |  | 0 | 30000 | 30000 | 30000 | 30000.00000000003 | 29999.99999999997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Alexiades | Hailey | 121105 | NPCC | IOU | NGRID | NEEWS Construction Support |  |  |  | 2011-11-01 00:00:00 | 1 | 160000 | 16 | 110 | 0.31 | 0.3 | 0.05 | 0.09 | 0.25 | 1 | 31 | 3 | 3 | 160000 | 0 | 0.00909090909090909 | 160000 |  | 0 | 15500 | 15500 | 15500 | 15100 | 15000 | 15000 | 7500 | 2500 | 2500 | 3300 | 4500 | 4500 | 6099.999999999985 | 12500.00000000001 | 12500 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Alexiades | Hailey | 123588 | NPCC | IOU | NGRID | Hartford Ave IR |  |  |  | 2012-01-01 00:00:00 | 1 | 300000 | 13 | 110 | 0.1 | 0.3 | 0.3 | 0.2 | 0.1 | 0.9999999999999999 | 33 | 3 | 3 | 300000 | 0 | 0.00909090909090909 | 300000 |  | 0 | 0 | 0 | 11538.46153846154 | 11538.46153846154 | 20769.23076923077 | 34615.38461538462 | 34615.38461538461 | 34615.38461538461 | 34615.3846153846 | 32307.69230769234 | 23076.92307692306 | 23076.92307692309 | 16153.84615384616 | 11538.4615384615 | 11538.46153846156 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | San Diego | 124189 | WECC | MUNI | City Of Burbank | Clybourne Substation Rebuilt |  |  |  | 2011-11-01 00:00:00 | 1 | 80000 | 2 | 110 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1 | 31 | 1 | 1 | 80000 | 0 | 0.00909090909090909 | 80000 |  | 0 | 40000 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Alexiades | Atlanta | 0 | NPCC | IOU | Nstar | Sta-Service Generators |  |  |  | 2011-11-01 00:00:00 | 1 | 5000 | 5 | 100 | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 1 | 31 | 1 | 1 | 5000 | 0 | 0.01 | 5000 |  | 0 | 1250 | 1250 | 1250 | 1250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Alexiades | Atlanta | 0 | NPCC | IOU | Nstar | Substation Civil-Physical Permits |  |  |  | 2011-11-01 00:00:00 | 1 | 30000 | 10 | 110 | 0.35 | 0.35 | 0.3 | 0 | 0 | 1 | 31 | 2 | 2 | 30000 | 0 | 0.00909090909090909 | 30000 |  | 0 | 5250 | 5250 | 5249.999999999998 | 5250.000000000002 | 4500 | 4500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
oglevie | Hailey | 0 | 0 | 0 | NSTAR | Cap Bank Projects |  |  |  | 2011-11-01 00:00:00 | 1 | 10000 | 1 | 110 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1 | 31 | 1 | 1 | 10000 | 0 | 0.00909090909090909 | 10000 |  | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Billings | 122302 | MRO | IOU | [NAME] | Pathfinder bypass |  |  |  | 2011-11-01 00:00:00 | 1 | 15000 | 5 | 110 | 0.6 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9999999999999999 | 31 | 1 | 1 | 15000 | 0 | 0.00909090909090909 | 15000 |  | 0 | 9000 | 1500 | 1500 | 1499.999999999998 | 1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Billings | 122300 | MRO | IOU | [NAME] | [NAME] replacement |  |  |  | 2011-11-01 00:00:00 | 1 | 25000 | 5 | 110 | 0.6 | 0.1 | 0.1 | 0.1 | 0.1 | 0.9999999999999999 | 31 | 1 | 1 | 25000 | 0 | 0.00909090909090909 | 25000 |  | 0 | 15000 | 2500 | 2500 | 2500 | 2499.999999999996 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Boise | 123274 | WECC | IOU | Clallam County PUD | [NAME] |  |  |  | 2011-11-01 00:00:00 | 1 | 40000 | 8 | 100 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1 | 31 | 2 | 2 | 40000 | 0 | 0.01 | 40000 |  | 0 | 5000 | 5000 | 5000 | 5000 | 5000.000000000004 | 5000 | 4999.999999999996 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Boise | 118163 | WECC | IOU | Clallam County PUD | SCADA and Relay Upgrades TO3 |  |  |  | 2012-04-01 00:00:00 | 1 | 5000 | 5 | 100 | 0.2 | 0.2 | 0.1 | 0.3 | 0.2 | 1 | 36 | 1 | 1 | 5000 | 0 | 0.01 | 5000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 500 | 1500 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120259 | MRO | IOU | [NAME] | Aldrich Substation, MN w/UG |  |  |  | 2011-11-01 00:00:00 | 1 | 2000 | 5 | 95 | 0.25 | 0.25 | 0.05 | 0.25 | 0.2 | 1 | 31 | 1 | 1 | 2000 | 0 | 0.01052631578947368 | 2000 |  | 0 | 500 | 500 | 100 | 500 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120263 | MRO | IOU | [NAME] | Elliot Park Substation, MN w/UG |  |  |  | 2011-11-01 00:00:00 | 1 | 5000 | 5 | 95 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 1 | 31 | 1 | 1 | 5000 | 0 | 0.01052631578947368 | 5000 |  | 0 | 1000 | 1000 | 1000 | 1000.000000000001 | 999.9999999999991 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120038 | MRO | IOU | [NAME] | Fenton Substation |  |  |  | 2011-11-01 00:00:00 | 1 | 25000 | 6 | 100 | 0.2 | 0.25 | 0.2 | 0.25 | 0.1 | 1 | 31 | 1 | 1 | 25000 | 0 | 0.01 | 25000 |  | 0 | 4166.666666666667 | 4999.999999999999 | 4583.333333333334 | 4583.333333333332 | 4583.333333333336 | 2083.333333333332 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120261 | MRO | IOU | [NAME] | Fifth Street Substation, MN w/UG |  |  |  | 2011-11-01 00:00:00 | 1 | 2000 | 5 | 95 | 0.25 | 0.25 | 0.05 | 0.25 | 0.2 | 1 | 31 | 1 | 1 | 2000 | 0 | 0.01052631578947368 | 2000 |  | 0 | 500 | 500 | 100 | 500 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Murphy | Denver | 123264 | MRO | IOU | [NAME] | [NAME] CB replace |  |  |  | 2011-11-01 00:00:00 | 1 | 125000 | 10 | 110 | 0.15 | 0.35 | 0.3 | 0.1 | 0.1 | 1 | 31 | 2 | 2 | 125000 | 0 | 0.00909090909090909 | 125000 |  | 0 | 9375 | 9375 | 21874.99999999999 | 21875.00000000001 | 18750 | 18750 | 6250 | 6250 | 6250 | 6250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Murphy | Denver | 122756 | MRO | IOU | [NAME] | [NAME] |  |  |  | 2011-11-01 00:00:00 | 1 | 8000 | 5 | 110 | 0.8 | 0.05 | 0.05 | 0.05 | 0.05 | 1 | 31 | 1 | 1 | 8000.000000000002 | 0 | 0.00909090909090909 | 8000 |  | 0 | 6400 | 400 | 400.0000000000009 | 400 | 400.0000000000009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120256 | MRO | IOU | [NAME] | Split Rock Substation 11CB Repl |  |  |  | 2011-11-01 00:00:00 | 1 | 2000 | 5 | 95 | 0.1 | 0.1 | 0.4 | 0.4 | 0 | 1 | 31 | 1 | 1 | 2000 | 0 | 0.01052631578947368 | 2000 |  | 0 | 200 | 200 | 800 | 800.0000000000005 | -4.547473508864641e-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Murphy | Denver | 123768 | MRO | IOU | [NAME] | West River Road - TX2 |  |  |  | 2011-11-01 00:00:00 | 1 | 110000 | 12 | 120 | 0.15 | 0.25 | 0.25 | 0.25 | 0.1 | 1 | 31 | 2 | 2 | 110000 | 0 | 0.008333333333333333 | 110000 |  | 0 | 6874.999999999999 | 6874.999999999999 | 9625.000000000002 | 11458.33333333333 | 11458.33333333334 | 11458.33333333334 | 11458.33333333334 | 11458.33333333331 | 11458.33333333334 | 8708.333333333328 | 4583.333333333328 | 4583.333333333343 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 120260 | MRO | IOU | [NAME] | West River Road Substation, MN |  |  |  | 2011-11-01 00:00:00 | 1 | 2000 | 5 | 95 | 0.25 | 0.25 | 0.05 | 0.25 | 0.2 | 1 | 31 | 1 | 1 | 2000 | 0 | 0.01052631578947368 | 2000 |  | 0 | 500 | 500 | 100 | 500 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Boston | Denver | 121767 | MRO | IOU | [NAME] | Wind Farm AGC study |  |  |  | 2011-11-01 00:00:00 | 1 | 2000 | 5 | 110 | 0.5 | 0.5 | 0 | 0 | 0 | 1 | 31 | 1 | 1 | 2000 | 0 | 0.00909090909090909 | 2000 |  | 0 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 161516.6666666667 | 126350 | 111121.7948717948 | 113755.1282051282 | 116660.8974358974 | 92407.05128205128 | 65823.71794871795 | 60323.71794871792 | 56323.71794871794 | 51566.02564102567 | 32160.25641025639 | 32160.25641025644 | 22253.84615384614 | 24038.46153846152 | 24038.46153846156 | 12500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0