{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","Reserve Demand Curves Example","Optimization Engine","Results Summary","Answer Report","Sensitivity Report"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":2180,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[1,"Designed to illustrate the energy and AS pricing results with RTC under AS surplus and shortage conditions by decomposing the current ORDC"]
[null,"into a reserve demand curve for each AS"]
[2,"Assumptions"]
[null,null,"VOLL = $9,000"]
[null,null,"Offer Cap = $2,000"]
[null,null,"Max Reserve Demand Curve Value = $9000"]
[null,null,"No Congestion"]
[null,null,"Generators available from 0 to HSL for Energy, available in quantities offered for each AS"]
[null,null,"All RRS provided from generators for the purpose of this example"]
[3,"AS Demand Curves"]
[null,null,"AS Demand Curve and Aggregate Demand Curve is approximated using composite historical RTOLCAP and RTOFFCAP values between 2014 and 2018"]
[null,null,"These curves use the Post-NPRR863 AS Requirements for May 2019 HE17 (REGUP = 296, RRS = 2564, ECRS = 942, NSPIN = 511)"]
[null,null,"The curves could change based on the AS Requirements each hour"]
[null,null,"Simulating a different time period would require decomposing the applicable ORDC into the individual AS product demand curves"]
[null,null,"200 MW of REGUP and 1,800 MW of RRS are priced at $9,000"]
[null,null,"Approx 25 MW of REGUP and 25 MW of RRS are priced at values that approximate the steps of the Current Power Balance Penalty Curve between $250/MWh and $2,250/MWh"]
[null,null,"The remaining REGUP and RRS is priced at the approximate composite RTOLCAP and RTOFFCAP prices between 2,000 and 3,000 MW"]
[null,null,"The full 942 MW of ECRS is priced between $1,750/MWh and $4,000/MWh"]
[null,null,"The maximum value on the NSPIN demand curve is $1,500 and the curve extends out to 10,000 MW"]
[null,null,"Tab 'Reserve Demand Curves Example' shows charts with the resulting individual and aggregate AS demand curves"]
[4,"Running a Case"]
[null,null,"'Rest of System' represents the sum of 50,000 MW of infra-marginal generation"]
[null,null,"G1-G10 represent online generation with increasing energy offers and identical AS offer quantities"]
[null,null,"G11-G15 represent quick-start that can provide Energy, ECRS, or NSPIN"]
[null,null,"There is a field for a Capacity Offer Price for each reserve that is set to $0 in these examples"]
[null,null,"In the optimization, AS shortages are represented as a cost"]
[null,null,"The original excel sheet has been modified to only have 1 case that the user can modify. "]
[null,null,"Tab 'Optimization Engine' contains the inputs and solution of the SOLVER Linear Program"]
[null,null,"Tab 'Results Summary' contains tabular and graphical summaries of the SOLVER Linear Program result for the case run in the Optimization Engine tab"]
[null,null,"Sensitivity Report and Answer Report contain the raw values from the SOLVER. The prices are copied from the results to the Optimizaiton Engine and Results Summary tabs"]

{"sheet":"Reserve Demand Curves Example","index":1,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,7],[3,8,3,11],[33,8,33,11],[48,8,48,11],[18,8,18,11],[0,8,0,11],[2,8,2,11],[1,16,1,17]]}
["Note: This is only one example of a potential AS demand curve.  Because of the limited capacity of Excel, these curves are blocky due to being broken into a small number of segments.  In production the curves could contain many more segments and therefore be smoother."]
["Aggregate AS Demand Curve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected Post NPRR863 AS Quantities (May-19 HE17)"]
["Bucket","MW","Cumulative","AS Demand Curve",null,null,null,null,"Ancillary Service Demand Curves",null,null,null,null,null,null,null,"Product","Quantity"]
["REGUP1",{"$f":"VLOOKUP(A4,I:J,2,FALSE)","v":200},{"$f":"B4","v":200},{"$f":"VLOOKUP(A4,I:L,4,FALSE)","v":9000},null,null,null,null,"REGUP",null,null,null,null,null,null,null,"REGUP",296]
["RRS1",{"$f":"VLOOKUP(A5,I:J,2,FALSE)","v":1800},{"$f":"B5+C4","v":2000},{"$f":"VLOOKUP(A5,I:L,4,FALSE)","v":9000},null,null,null,null,"Breakpoint","MW","Cumulative MW","$/MWh",null,null,null,null,"RRS",2563.91]
["PLACEHOLDER",1E-4,2000.0001,{"$f":"D7+1","v":6501},null,null,null,null,null,null,{"$f":"J6","v":0},{"$f":"L7","v":9000},null,null,null,null,"ECRS",942.37196019997998]
["REGUP2",{"$f":"VLOOKUP(A7,I:J,2,FALSE)","v":5},2005.0001,{"$f":"VLOOKUP(A7,I:L,4,FALSE)","v":6500},null,null,null,null,"REGUP1",200,{"$f":"J7","v":200},9000,null,null,null,null,"NSPIN",510.62803980002002]
["RRS2",54,2059.0001000000002,6500,null,null,null,null,"REGUP2",5,{"$f":"K7+J8","v":205},6500]
["REGUP3",30,2089.0001000000002,5500,null,null,null,null,"REGUP3",30,{"$f":"K8+J9","v":235},5500]
["RRS3",316,2405.0001000000002,5500,null,null,null,null,"REGUP4",36,271,4500]
["REGUP4",36,2441.0001000000002,4500,null,null,null,null,"REGUP5",5,276,2250]
["RRS4",369,2810.0001000000002,4500,null,null,null,null,"REGUP6",5,281,1000]
["ECRS1",205,3015.0001000000002,4000,null,null,null,null,"REGUP7",5,286,500]
["ECRS2",95,3110.0001000000002,3750,null,null,null,null,"REGUP8",5,291,400]
["ECRS3",95,3205.0001000000002,3500,null,null,null,null,"REGUP9",2.5,293.5,300]
["ECRS4",113,3318.0001000000002,3250,null,null,null,null,"REGUP10",2.5,296,250]
["ECRS5",100,3418.0001000000002,3000,null,null,null,null,"Total:",{"$f":"SUM(J7:J16)","v":296}]
["ECRS6",64,3482.0001000000002,2750]
["ECRS7",79,3561.0001000000002,2500,null,null,null,null,"RRS"]
["REGUP5",5,3566.0001000000002,2250,null,null,null,null,"Breakpoint","MW","Cumulative MW","$/MWh"]
["RRS5",5,3571.0001000000002,2250,null,null,null,null,null,null,0,{"$f":"L22","v":9000}]
["ECRS8",81,3652.0001000000002,2250,null,null,null,null,"RRS1",1800,{"$f":"J22","v":1800},9000]
["ECRS9",68,3720.0001000000002,2000,null,null,null,null,"RRS2",54,{"$f":"K22+J23","v":1854},6500]
["ECRS10",42,3762.0001000000002,1750,null,null,null,null,"RRS3",316,{"$f":"K23+J24","v":2170},5500]
["NSPIN1",152,3914.0001000000002,1500,null,null,null,null,"RRS4",369,2539,4500]
["NSPIN2",201,4115.0001000000002,1250,null,null,null,null,"RRS5",5,2544,2250]
["REGUP6",5,4120.0001000000002,1000,null,null,null,null,"RRS6",5,2549,1000]
["RRS6",5,4125.0001000000002,1000,null,null,null,null,"RRS7",5,2554,500]
["NSPIN3",117,4242.0001000000002,1000,null,null,null,null,"RRS8",5,2559,400]
["NSPIN4",169,4411.0001000000002,750,null,null,null,null,"RRS9",2.5,2561.5,300]
["NSPIN5",86,4497.0001000000002,625,null,null,null,null,"RRS10",2.5,2564,250]
["REGUP7",5,4502.0001000000002,500,null,null,null,null,"Total:",{"$f":"SUM(J22:J31)","v":2564}]
["RRS7",5,4507.0001000000002,500]
["NSPIN6",162,4669.0001000000002,500,null,null,null,null,"ECRS"]
["REGUP8",5,4674.0001000000002,400,null,null,null,null,"Breakpoint","MW","Cumulative MW","$/MWh"]
["RRS8",5,4679.0001000000002,400,null,null,null,null,null,null,0,{"$f":"L37","v":4000}]
["NSPIN7",210,4889.0001000000002,375,null,null,null,null,"ECRS1",205,{"$f":"J37","v":205},4000]
["REGUP9",2.5,4891.5001000000002,300,null,null,null,null,"ECRS2",95,{"$f":"K37+J38","v":300},3750]
["RRS9",2.5,4894.0001000000002,300,null,null,null,null,"ECRS3",95,{"$f":"K38+J39","v":395},3500]
["REGUP10",2.5,4896.5001000000002,250,null,null,null,null,"ECRS4",113,508,3250]
["RRS10",2.5,4899.0001000000002,250,null,null,null,null,"ECRS5",100,608,3000]
["NSPIN8",215,5114.0001000000002,250,null,null,null,null,"ECRS6",64,{"$f":"K41+J42","v":672},2750]
["NSPIN9",330,5444.0001000000002,150,null,null,null,null,"ECRS7",79,751,2500]
["NSPIN10",276,5720.0001000000002,100,null,null,null,null,"ECRS8",81,832,2250]
["NSPIN11",362,6082.0001000000002,50,null,null,null,null,"ECRS9",68,900,2000]
["NSPIN12",419,6501.0001000000002,25,null,null,null,null,"ECRS10",42,942,1750]
["NSPIN13",582,7083.0001000000002,10,null,null,null,null,"Total:",{"$f":"SUM(J37:J46)","v":942}]
["NSPIN14",1237,8320.0001000000011,1]
["NSPIN15",1680,10000.000100000001,0.01,null,null,null,null,"NSPIN"]
[null,null,null,null,null,null,null,null,"Breakpoint","MW","Cumulative MW","$/MWh"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"L52","v":1500}]
[null,null,null,null,null,null,null,null,"NSPIN1",152,{"$f":"J52","v":152},1500]
[null,null,null,null,null,null,null,null,"NSPIN2",201,{"$f":"K52+J53","v":353},1250]
[null,null,null,null,null,null,null,null,"NSPIN3",117,{"$f":"K53+J54","v":470},1000]
[null,null,null,null,null,null,null,null,"NSPIN4",169,639,750]
[null,null,null,null,null,null,null,null,"NSPIN5",86,725,625]
[null,null,null,null,null,null,null,null,"NSPIN6",162,887,500]
[null,null,null,null,null,null,null,null,"NSPIN7",210,1097,375]
[null,null,null,null,null,null,null,null,"NSPIN8",215,1312,250]
[null,null,null,null,null,null,null,null,"NSPIN9",330,1642,150]
[null,null,null,null,null,null,null,null,"NSPIN10",276,1918,100]
[null,null,null,null,null,null,null,null,"NSPIN11",362,2280,50]
[null,null,null,null,null,null,null,null,"NSPIN12",419,2699,25]
[null,null,null,null,null,null,null,null,"NSPIN13",582,3281,10]
[null,null,null,null,null,null,null,null,"NSPIN14",1237,4518,1]
[null,null,null,null,null,null,null,null,"NSPIN15",1680,6198,0.01]
[null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(J52:J66)","v":6198}]

{"sheet":"Optimization Engine","index":2,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,0,30,1],[0,3,0,6],[0,0,0,1],[21,0,21,1],[21,2,27,6],[2,0,20,0],[36,8,36,9],[36,13,36,14],[41,23,41,24],[0,23,0,26],[0,8,0,11],[0,13,0,16],[22,8,22,11],[22,13,22,16],[22,23,22,26],[0,18,0,21],[22,18,22,21],[36,18,36,19]]}
["Modify grey cells and click 'Solve' to view results. White cells should not be modified.",null,null,"Energy Offers and Awards",null,null,null,null,"REGUP Offers and Awards",null,null,null,null,"RRS Offers and Awards",null,null,null,null,"ECRS Offers and Awards",null,null,null,null,"NSPIN Offers and Awards",null,null,null,null,"Total Awarded Capacity"]
[null,"Generator","HSL","Offer Qty","Offer Price","Awarded Qty","Energy Cost",null,"Offer Qty","Offer Price","Awarded Qty","Award Cost",null,"Offer Qty","Offer Price","Awarded Qty","Award Cost",null,"Offer Qty","Offer Price","Awarded Qty","Award Cost",null,"Offer Qty","Offer Price","Awarded Qty","Award Cost"]
[null,"Rest of System",50000,50000,25,49571,{"$f":"F3*E3","v":1239275},null,2500,0,0,{"$f":"K3*J3","v":0},null,{"$f":"0.2*C3","v":10000},0,429,{"$f":"P3*O3","v":0},null,50000,0,0,{"$f":"U3*T3","v":0},null,50000,0,0,{"$f":"Z3*Y3","v":0},null,{"$f":"F3+K3+P3+U3+Z3","v":50000}]
[null,"G1",1000,1000,30,800,{"$f":"F4*E4","v":24000},null,50,0,0,{"$f":"K4*J4","v":0},null,200,0,200,{"$f":"P4*O4","v":0},null,1000,0,0,{"$f":"U4*T4","v":0},null,1000,0,0,{"$f":"Z4*Y4","v":0},null,{"$f":"F4+K4+P4+U4+Z4","v":1000}]
[null,"G2",1000,1000,35,800,28000,null,50,0,0,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G3",1000,1000,40,800,32000,null,50,0,0,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G4",1000,1000,45,800,36000,null,50,0,0,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G5",1000,1000,50,779,38950,null,50,0,21,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G6",1000,1000,55,750,41250,null,50,0,50,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G7",1000,1000,60,750,45000,null,50,0,50,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G8",1000,1000,65,750,48750,null,50,0,50,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G9",1000,1000,70,750,52500,null,50,0,50,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G10",1000,1000,75,750,56250,null,50,0,50,0,null,200,0,200,0,null,1000,0,0,0,null,1000,0,0,0,null,1000]
[null,"G11",500,500,80,500,40000,null,0,0,0,0,null,0,0,0,0,null,500,0,0,0,null,500,0,0,0,null,{"$f":"F14+K14+P14+U14+Z14","v":500}]
[null,"G12",500,500,100,500,50000,null,0,0,0,0,null,0,0,0,0,null,500,0,0,0,null,500,0,0,0,null,500]
[null,"G13",500,500,150,500,75000,null,0,0,0,0,null,0,0,0,0,null,500,0,0,0,null,500,0,0,0,null,500]
[null,"G14",500,500,250,500,125000,null,0,0,0,0,null,0,0,0,0,null,500,0,0,0,null,500,0,0,0,null,500]
[null,"G15",500,500,1000,200,200000,null,0,0,0,0,null,0,0,0,0,null,500,0,300,0,null,500,0,0,0,null,500]
[null,"Power Balance Penalty",10000,10000,11001,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F19","v":0}]
[null,"Totals with Power Balance Penalty",{"$f":"SUM(C3:C19)","v":72500},{"$f":"SUM(D3:D19)","v":72500},null,{"$f":"SUM(F3:F19)","v":59500},{"$f":"SUM(G3:G19)","v":2131975},null,{"$f":"SUM(I3:I19)","v":3000},null,{"$f":"SUM(K3:K19)","v":271},{"$f":"SUM(L3:L19)","v":0},null,{"$f":"SUM(N3:N19)","v":12000},null,{"$f":"SUM(P3:P19)","v":2429},{"$f":"SUM(Q3:Q19)","v":0},null,{"$f":"SUM(S3:S19)","v":62500},null,{"$f":"SUM(U3:U19)","v":300},{"$f":"SUM(V3:V19)","v":0},null,{"$f":"SUM(X3:X19)","v":62500},null,{"$f":"SUM(Z3:Z19)","v":0},{"$f":"SUM(AA3:AA19)","v":0},null,{"$f":"SUM(AC3:AC19)","v":62500}]
[null,"Totals - Generators Only",{"$f":"SUM(C3:C18)","v":62500},{"$f":"SUM(D3:D18)","v":62500},null,59500,{"$f":"SUM(G3:G18)","v":2131975}]
["System Inputs (MW)",null,"As an example, change 'Demand' value to 56,000 and click solve. The objective function and output prices will update along with the awarded and solution quantities for the 7 tables. The 'Results Summary' tab will summarize the real-time co-optimized solution."]
["Demand",59500,null,null,null,null,null,null,"REGUP Shortage",null,null,null,null,"RRS Shortage",null,null,null,null,"ECRS Shortage",null,null,null,null,"NSPIN Shortage"]
["Max REGUP Demand Curve Qty",296,null,null,null,null,null,null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Penalty Cost",null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Penalty Cost",null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Penalty Cost",null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Penalty Cost"]
["Max RRS Demand Curve Qty",2564,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J7","v":200},{"$f":"'Reserve Demand Curves Example'!$L7","v":9000},0,{"$f":"K25*J25","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J22","v":1800},{"$f":"'Reserve Demand Curves Example'!$L22","v":9000},0,{"$f":"P25*O25","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J37","v":205},{"$f":"'Reserve Demand Curves Example'!$L37","v":4000},0,{"$f":"U25*T25","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J52","v":152},{"$f":"'Reserve Demand Curves Example'!$L52","v":1500},151.90000000000146,{"$f":"Z25*Y25","v":227850.00000000218}]
["Max ECRS Demand Curve Qty",942,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J8","v":5},{"$f":"'Reserve Demand Curves Example'!$L8","v":6500},0,{"$f":"K26*J26","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J23","v":54},{"$f":"'Reserve Demand Curves Example'!$L23","v":6500},0,{"$f":"P26*O26","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J38","v":95},{"$f":"'Reserve Demand Curves Example'!$L38","v":3750},0,{"$f":"U26*T26","v":0},null,{"$f":"'Reserve Demand Curves Example'!$J53","v":201},{"$f":"'Reserve Demand Curves Example'!$L53","v":1250},201,{"$f":"Z26*Y26","v":251250}]
["Max NSPIN Demand Curve Qty",6198.0000000000009,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J9","v":30},{"$f":"'Reserve Demand Curves Example'!$L9","v":5500},0,0,null,{"$f":"'Reserve Demand Curves Example'!$J24","v":316},{"$f":"'Reserve Demand Curves Example'!$L24","v":5500},0,0,null,{"$f":"'Reserve Demand Curves Example'!$J39","v":95},{"$f":"'Reserve Demand Curves Example'!$L39","v":3500},95,332500,null,{"$f":"'Reserve Demand Curves Example'!$J54","v":117},{"$f":"'Reserve Demand Curves Example'!$L54","v":1000},117,117000]
[null,null,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J10","v":36},{"$f":"'Reserve Demand Curves Example'!$L10","v":4500},0,0,null,{"$f":"'Reserve Demand Curves Example'!$J25","v":369},{"$f":"'Reserve Demand Curves Example'!$L25","v":4500},110,495000,null,{"$f":"'Reserve Demand Curves Example'!$J40","v":113},{"$f":"'Reserve Demand Curves Example'!$L40","v":3250},113,367250,null,{"$f":"'Reserve Demand Curves Example'!$J55","v":169},{"$f":"'Reserve Demand Curves Example'!$L55","v":750},169,126750]
["Objective Function",{"$f":"G20+L20+L35+Q20+V20+Q35+V35+AA20+AA40","v":5537849.1700000018},null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J11","v":5},{"$f":"'Reserve Demand Curves Example'!$L11","v":2250},5,11250,null,{"$f":"'Reserve Demand Curves Example'!$J26","v":5},{"$f":"'Reserve Demand Curves Example'!$L26","v":2250},5,11250,null,{"$f":"'Reserve Demand Curves Example'!$J41","v":100},{"$f":"'Reserve Demand Curves Example'!$L41","v":3000},100,300000,null,{"$f":"'Reserve Demand Curves Example'!$J56","v":86},{"$f":"'Reserve Demand Curves Example'!$L56","v":625},86,53750]
[null,null,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J12","v":5},{"$f":"'Reserve Demand Curves Example'!$L12","v":1000},5,5000,null,{"$f":"'Reserve Demand Curves Example'!$J27","v":5},{"$f":"'Reserve Demand Curves Example'!$L27","v":1000},5,5000,null,{"$f":"'Reserve Demand Curves Example'!$J42","v":64},{"$f":"'Reserve Demand Curves Example'!$L42","v":2750},64,176000,null,{"$f":"'Reserve Demand Curves Example'!$J57","v":162},{"$f":"'Reserve Demand Curves Example'!$L57","v":500},162,{"$f":"Z30*Y30","v":81000}]
["Output Prices ($/MWh)",null,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J13","v":5},{"$f":"'Reserve Demand Curves Example'!$L13","v":500},5,{"$f":"K31*J31","v":2500},null,{"$f":"'Reserve Demand Curves Example'!$J28","v":5},{"$f":"'Reserve Demand Curves Example'!$L28","v":500},5,2500,null,{"$f":"'Reserve Demand Curves Example'!$J43","v":79},{"$f":"'Reserve Demand Curves Example'!$L43","v":2500},79,197500,null,{"$f":"'Reserve Demand Curves Example'!$J58","v":210},{"$f":"'Reserve Demand Curves Example'!$L58","v":375},210,78750]
["Energy",4525,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J14","v":5},{"$f":"'Reserve Demand Curves Example'!$L14","v":400},5,2000,null,{"$f":"'Reserve Demand Curves Example'!$J29","v":5},{"$f":"'Reserve Demand Curves Example'!$L29","v":400},5,2000,null,{"$f":"'Reserve Demand Curves Example'!$J44","v":81},{"$f":"'Reserve Demand Curves Example'!$L44","v":2250},81,182250,null,{"$f":"'Reserve Demand Curves Example'!$J59","v":215},{"$f":"'Reserve Demand Curves Example'!$L59","v":250},215,53750]
["REGUP",4475,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J15","v":2.5},{"$f":"'Reserve Demand Curves Example'!$L15","v":300},2.5,750,null,{"$f":"'Reserve Demand Curves Example'!$J30","v":2.5},{"$f":"'Reserve Demand Curves Example'!$L30","v":300},2.5,750,null,{"$f":"'Reserve Demand Curves Example'!$J45","v":68},{"$f":"'Reserve Demand Curves Example'!$L45","v":2000},68,136000,null,{"$f":"'Reserve Demand Curves Example'!$J60","v":330},{"$f":"'Reserve Demand Curves Example'!$L60","v":150},330,49500]
["RRS",4500,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J16","v":2.5},{"$f":"'Reserve Demand Curves Example'!$L16","v":250},2.5,625,null,{"$f":"'Reserve Demand Curves Example'!$J31","v":2.5},{"$f":"'Reserve Demand Curves Example'!$L31","v":250},2.5,625,null,{"$f":"'Reserve Demand Curves Example'!$J46","v":42},{"$f":"'Reserve Demand Curves Example'!$L46","v":1750},42,73500,null,{"$f":"'Reserve Demand Curves Example'!$J61","v":276},{"$f":"'Reserve Demand Curves Example'!$L61","v":100},276,27600]
["ECRS",3525,null,null,null,null,null,null,{"$f":"SUM(I25:I34)","v":296},null,{"$f":"SUM(K25:K34)","v":25},{"$f":"SUM(L25:L34)","v":22125},null,{"$f":"SUM(N25:N34)","v":2564},null,{"$f":"SUM(P25:P34)","v":135},{"$f":"SUM(Q25:Q34)","v":517125},null,{"$f":"SUM(S25:S34)","v":942},null,{"$f":"SUM(U25:U34)","v":642},{"$f":"SUM(V25:V34)","v":1765000},null,{"$f":"'Reserve Demand Curves Example'!$J62","v":362},{"$f":"'Reserve Demand Curves Example'!$L62","v":50},362,18100]
["NSPIN",1500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reserve Demand Curves Example'!$J63","v":419},{"$f":"'Reserve Demand Curves Example'!$L63","v":25},419,10475]
[null,null,null,null,null,null,null,null,"REGUP Awarded + Shortage Qty",null,{"$f":"K20+K35","v":296},null,null,"RRS Awarded + Shortage Qty",null,{"$f":"P20+P35","v":2564},null,null,"ECRS Awarded + Shortage Qty",null,{"$f":"U20+U35","v":942},null,null,{"$f":"'Reserve Demand Curves Example'!$J64","v":582},{"$f":"'Reserve Demand Curves Example'!$L64","v":10},582,5820]
[null,null,null,null,null,null,null,null,"* Example does not accont for REGUP being carried by Load Resources",null,null,null,null,"* Example does not accont for RRS being carried by UFR or Other Load Resources",null,null,null,null,"* Example does not accont for ECRS being carried by Load Resources",null,null,null,null,2917,0.01,2917,29.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0,0.1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X25:X39)","v":6198.1},null,{"$f":"SUM(Z25:Z39)","v":6198.0000000000018},{"$f":"SUM(AA25:AA39)","v":1101624.1700000023}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NSPIN Awarded + Shortage Qty",null,{"$f":"Z20+Z40","v":6198.0000000000018}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Example does not accont for NSPIN being carried by Load Resources"]

{"sheet":"Results Summary","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Awarded MW"]
[null,"Energy","REGUP","RRS","ECRS","NSPIN"]
["G1",{"$f":"'Optimization Engine'!F4","v":800},{"$f":"'Optimization Engine'!K4","v":0},{"$f":"'Optimization Engine'!P4","v":200},{"$f":"'Optimization Engine'!U4","v":0},{"$f":"'Optimization Engine'!Z4","v":0}]
["G2",{"$f":"'Optimization Engine'!F5","v":800},{"$f":"'Optimization Engine'!K5","v":0},{"$f":"'Optimization Engine'!P5","v":200},{"$f":"'Optimization Engine'!U5","v":0},{"$f":"'Optimization Engine'!Z5","v":0}]
["G3",{"$f":"'Optimization Engine'!F6","v":800},{"$f":"'Optimization Engine'!K6","v":0},{"$f":"'Optimization Engine'!P6","v":200},{"$f":"'Optimization Engine'!U6","v":0},{"$f":"'Optimization Engine'!Z6","v":0}]
["G4",{"$f":"'Optimization Engine'!F7","v":800},{"$f":"'Optimization Engine'!K7","v":0},{"$f":"'Optimization Engine'!P7","v":200},{"$f":"'Optimization Engine'!U7","v":0},{"$f":"'Optimization Engine'!Z7","v":0}]
["G5",{"$f":"'Optimization Engine'!F8","v":779},{"$f":"'Optimization Engine'!K8","v":21},{"$f":"'Optimization Engine'!P8","v":200},{"$f":"'Optimization Engine'!U8","v":0},{"$f":"'Optimization Engine'!Z8","v":0}]
["G6",{"$f":"'Optimization Engine'!F9","v":750},{"$f":"'Optimization Engine'!K9","v":50},{"$f":"'Optimization Engine'!P9","v":200},{"$f":"'Optimization Engine'!U9","v":0},{"$f":"'Optimization Engine'!Z9","v":0}]
["G7",{"$f":"'Optimization Engine'!F10","v":750},{"$f":"'Optimization Engine'!K10","v":50},{"$f":"'Optimization Engine'!P10","v":200},{"$f":"'Optimization Engine'!U10","v":0},{"$f":"'Optimization Engine'!Z10","v":0}]
["G8",{"$f":"'Optimization Engine'!F11","v":750},{"$f":"'Optimization Engine'!K11","v":50},{"$f":"'Optimization Engine'!P11","v":200},{"$f":"'Optimization Engine'!U11","v":0},{"$f":"'Optimization Engine'!Z11","v":0}]
["G9",{"$f":"'Optimization Engine'!F12","v":750},{"$f":"'Optimization Engine'!K12","v":50},{"$f":"'Optimization Engine'!P12","v":200},{"$f":"'Optimization Engine'!U12","v":0},{"$f":"'Optimization Engine'!Z12","v":0}]
["G10",{"$f":"'Optimization Engine'!F13","v":750},{"$f":"'Optimization Engine'!K13","v":50},{"$f":"'Optimization Engine'!P13","v":200},{"$f":"'Optimization Engine'!U13","v":0},{"$f":"'Optimization Engine'!Z13","v":0}]
["G11",{"$f":"'Optimization Engine'!F14","v":500},{"$f":"'Optimization Engine'!K14","v":0},{"$f":"'Optimization Engine'!P14","v":0},{"$f":"'Optimization Engine'!U14","v":0},{"$f":"'Optimization Engine'!Z14","v":0}]
["G12",{"$f":"'Optimization Engine'!F15","v":500},{"$f":"'Optimization Engine'!K15","v":0},{"$f":"'Optimization Engine'!P15","v":0},{"$f":"'Optimization Engine'!U15","v":0},{"$f":"'Optimization Engine'!Z15","v":0}]
["G13",{"$f":"'Optimization Engine'!F16","v":500},{"$f":"'Optimization Engine'!K16","v":0},{"$f":"'Optimization Engine'!P16","v":0},{"$f":"'Optimization Engine'!U16","v":0},{"$f":"'Optimization Engine'!Z16","v":0}]
["G14",{"$f":"'Optimization Engine'!F17","v":500},{"$f":"'Optimization Engine'!K17","v":0},{"$f":"'Optimization Engine'!P17","v":0},{"$f":"'Optimization Engine'!U17","v":0},{"$f":"'Optimization Engine'!Z17","v":0}]
["G15",{"$f":"'Optimization Engine'!F18","v":200},{"$f":"'Optimization Engine'!K18","v":0},{"$f":"'Optimization Engine'!P18","v":0},{"$f":"'Optimization Engine'!U18","v":300},{"$f":"'Optimization Engine'!Z18","v":0}]
["Award",null,{"$f":"'Optimization Engine'!K20","v":271},{"$f":"'Optimization Engine'!P20","v":2429},{"$f":"'Optimization Engine'!U20","v":300},{"$f":"'Optimization Engine'!Z20","v":0}]
["Posted AS Requirement",null,{"$f":"'Reserve Demand Curves Example'!R4","v":296},{"$f":"'Reserve Demand Curves Example'!R5","v":2563.91},{"$f":"'Reserve Demand Curves Example'!R6","v":942.37196019997998},{"$f":"'Reserve Demand Curves Example'!R7","v":510.62803980002002}]
[]
["Price ($/MWh)",{"$f":"'Optimization Engine'!$B$32","v":4525},{"$f":"'Optimization Engine'!$B$33","v":4475},{"$f":"'Optimization Engine'!$B$34","v":4500},{"$f":"'Optimization Engine'!$B$35","v":3525},{"$f":"'Optimization Engine'!$B$36","v":1500}]

{"sheet":"Answer Report","index":4,"n_rows":298,"n_cols":7,"rows_kept":298,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 15.0 Answer Report"]
["Worksheet: [Real-Time_Co-optimization_-_Automated_Scenario_Analysis_-_Update_Ver5_2.xlsm]Optimization Engine"]
["Report Created: 7/16/2019 3:07:56 PM"]
["Result: Label1"]
["Solver Engine"]
[null,"Engine: Simplex LP"]
[null,"Solution Time: 29.687 Seconds."]
[null,"Iterations: 104 Subproblems: 0"]
["Solver Options"]
[null,"Max Time 100 sec,  Iterations 1000, Precision 0.000001"]
[null,"Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0.01%, Solve Without Integer Constraints, Assume NonNegative"]
[]
[]
["Objective Cell (Max)"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$B$29","Objective Function Totals - Generators Only",5537849.1700000018,5537849.1700000018]
[]
[]
["Variable Cells"]
[null,"Cell","Name","Original Value","Final Value","Integer"]
[null,"$F$3","Rest of System Awarded Qty",49571,49571,"Contin"]
[null,"$F$4","G1 Awarded Qty",800,800,"Contin"]
[null,"$F$5","G2 Awarded Qty",800,800,"Contin"]
[null,"$F$6","G3 Awarded Qty",800,800,"Contin"]
[null,"$F$7","G4 Awarded Qty",800,800,"Contin"]
[null,"$F$8","G5 Awarded Qty",779,779,"Contin"]
[null,"$F$9","G6 Awarded Qty",750,750,"Contin"]
[null,"$F$10","G7 Awarded Qty",750,750,"Contin"]
[null,"$F$11","G8 Awarded Qty",750,750,"Contin"]
[null,"$F$12","G9 Awarded Qty",750,750,"Contin"]
[null,"$F$13","G10 Awarded Qty",750,750,"Contin"]
[null,"$F$14","G11 Awarded Qty",500,500,"Contin"]
[null,"$F$15","G12 Awarded Qty",500,500,"Contin"]
[null,"$F$16","G13 Awarded Qty",500,500,"Contin"]
[null,"$F$17","G14 Awarded Qty",500,500,"Contin"]
[null,"$F$18","G15 Awarded Qty",200,200,"Contin"]
[null,"$F$19","Power Balance Penalty Awarded Qty",0,0,"Contin"]
[null,"$K$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$K$4","G1 Awarded Qty",0,0,"Contin"]
[null,"$K$5","G2 Awarded Qty",0,0,"Contin"]
[null,"$K$6","G3 Awarded Qty",0,0,"Contin"]
[null,"$K$7","G4 Awarded Qty",0,0,"Contin"]
[null,"$K$8","G5 Awarded Qty",21,21,"Contin"]
[null,"$K$9","G6 Awarded Qty",50,50,"Contin"]
[null,"$K$10","G7 Awarded Qty",50,50,"Contin"]
[null,"$K$11","G8 Awarded Qty",50,50,"Contin"]
[null,"$K$12","G9 Awarded Qty",50,50,"Contin"]
[null,"$K$13","G10 Awarded Qty",50,50,"Contin"]
[null,"$K$14","G11 Awarded Qty",0,0,"Contin"]
[null,"$K$15","G12 Awarded Qty",0,0,"Contin"]
[null,"$K$16","G13 Awarded Qty",0,0,"Contin"]
[null,"$K$17","G14 Awarded Qty",0,0,"Contin"]
[null,"$K$18","G15 Awarded Qty",0,0,"Contin"]
[null,"$P$3","Rest of System Awarded Qty",429,429,"Contin"]
[null,"$P$4","G1 Awarded Qty",200,200,"Contin"]
[null,"$P$5","G2 Awarded Qty",200,200,"Contin"]
[null,"$P$6","G3 Awarded Qty",200,200,"Contin"]
[null,"$P$7","G4 Awarded Qty",200,200,"Contin"]
[null,"$P$8","G5 Awarded Qty",200,200,"Contin"]
[null,"$P$9","G6 Awarded Qty",200,200,"Contin"]
[null,"$P$10","G7 Awarded Qty",200,200,"Contin"]
[null,"$P$11","G8 Awarded Qty",200,200,"Contin"]
[null,"$P$12","G9 Awarded Qty",200,200,"Contin"]
[null,"$P$13","G10 Awarded Qty",200,200,"Contin"]
[null,"$P$14","G11 Awarded Qty",0,0,"Contin"]
[null,"$P$15","G12 Awarded Qty",0,0,"Contin"]
[null,"$P$16","G13 Awarded Qty",0,0,"Contin"]
[null,"$P$17","G14 Awarded Qty",0,0,"Contin"]
[null,"$P$18","G15 Awarded Qty",0,0,"Contin"]
[null,"$U$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$U$4","G1 Awarded Qty",0,0,"Contin"]
[null,"$U$5","G2 Awarded Qty",0,0,"Contin"]
[null,"$U$6","G3 Awarded Qty",0,0,"Contin"]
[null,"$U$7","G4 Awarded Qty",0,0,"Contin"]
[null,"$U$8","G5 Awarded Qty",0,0,"Contin"]
[null,"$U$9","G6 Awarded Qty",0,0,"Contin"]
[null,"$U$10","G7 Awarded Qty",0,0,"Contin"]
[null,"$U$11","G8 Awarded Qty",0,0,"Contin"]
[null,"$U$12","G9 Awarded Qty",0,0,"Contin"]
[null,"$U$13","G10 Awarded Qty",0,0,"Contin"]
[null,"$U$14","G11 Awarded Qty",0,0,"Contin"]
[null,"$U$15","G12 Awarded Qty",0,0,"Contin"]
[null,"$U$16","G13 Awarded Qty",0,0,"Contin"]
[null,"$U$17","G14 Awarded Qty",0,0,"Contin"]
[null,"$U$18","G15 Awarded Qty",300,300,"Contin"]
[null,"$Z$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$Z$4","G1 Awarded Qty",0,0,"Contin"]
[null,"$Z$5","G2 Awarded Qty",0,0,"Contin"]
[null,"$Z$6","G3 Awarded Qty",0,0,"Contin"]
[null,"$Z$7","G4 Awarded Qty",0,0,"Contin"]
[null,"$Z$8","G5 Awarded Qty",0,0,"Contin"]
[null,"$Z$9","G6 Awarded Qty",0,0,"Contin"]
[null,"$Z$10","G7 Awarded Qty",0,0,"Contin"]
[null,"$Z$11","G8 Awarded Qty",0,0,"Contin"]
[null,"$Z$12","G9 Awarded Qty",0,0,"Contin"]
[null,"$Z$13","G10 Awarded Qty",0,0,"Contin"]
[null,"$Z$14","G11 Awarded Qty",0,0,"Contin"]
[null,"$Z$15","G12 Awarded Qty",0,0,"Contin"]
[null,"$Z$16","G13 Awarded Qty",0,0,"Contin"]
[null,"$Z$17","G14 Awarded Qty",0,0,"Contin"]
[null,"$Z$18","G15 Awarded Qty",0,0,"Contin"]
[null,"$K$25","Max RRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$K$26","Max ECRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$K$27","Max NSPIN Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$K$28","Solution Qty",0,0,"Contin"]
[null,"$K$29","Objective Function Solution Qty",5,5,"Contin"]
[null,"$K$30","Solution Qty",5,5,"Contin"]
[null,"$K$31","Output Prices ($/MWh) Solution Qty",5,5,"Contin"]
[null,"$K$32","Energy Solution Qty",5,5,"Contin"]
[null,"$K$33","REGUP Solution Qty",2.5,2.5,"Contin"]
[null,"$K$34","RRS Solution Qty",2.5,2.5,"Contin"]
[null,"$P$25","Max RRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$P$26","Max ECRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$P$27","Max NSPIN Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$P$28","Solution Qty",110,110,"Contin"]
[null,"$P$29","Objective Function Solution Qty",5,5,"Contin"]
[null,"$P$30","Solution Qty",5,5,"Contin"]
[null,"$P$31","Output Prices ($/MWh) Solution Qty",5,5,"Contin"]
[null,"$P$32","Energy Solution Qty",5,5,"Contin"]
[null,"$P$33","REGUP Solution Qty",2.5,2.5,"Contin"]
[null,"$P$34","RRS Solution Qty",2.5,2.5,"Contin"]
[null,"$U$25","Max RRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$U$26","Max ECRS Demand Curve Qty Solution Qty",0,0,"Contin"]
[null,"$U$27","Max NSPIN Demand Curve Qty Solution Qty",95,95,"Contin"]
[null,"$U$28","Solution Qty",113,113,"Contin"]
[null,"$U$29","Objective Function Solution Qty",100,100,"Contin"]
[null,"$U$30","Solution Qty",64,64,"Contin"]
[null,"$U$31","Output Prices ($/MWh) Solution Qty",79,79,"Contin"]
[null,"$U$32","Energy Solution Qty",81,81,"Contin"]
[null,"$U$33","REGUP Solution Qty",68,68,"Contin"]
[null,"$U$34","RRS Solution Qty",42,42,"Contin"]
[null,"$Z$25","Max RRS Demand Curve Qty Solution Qty",151.90000000000146,151.90000000000146,"Contin"]
[null,"$Z$26","Max ECRS Demand Curve Qty Solution Qty",201,201,"Contin"]
[null,"$Z$27","Max NSPIN Demand Curve Qty Solution Qty",117,117,"Contin"]
[null,"$Z$28","Solution Qty",169,169,"Contin"]
[null,"$Z$29","Objective Function Solution Qty",86,86,"Contin"]
[null,"$Z$30","Solution Qty",162,162,"Contin"]
[null,"$Z$31","Output Prices ($/MWh) Solution Qty",210,210,"Contin"]
[null,"$Z$32","Energy Solution Qty",215,215,"Contin"]
[null,"$Z$33","REGUP Solution Qty",330,330,"Contin"]
[null,"$Z$34","RRS Solution Qty",276,276,"Contin"]
[null,"$Z$35","ECRS Solution Qty",362,362,"Contin"]
[null,"$Z$36","NSPIN Solution Qty",419,419,"Contin"]
[null,"$Z$37","ECRS Awarded + Shortage Qty Solution Qty",582,582,"Contin"]
[null,"$Z$38","* Example does not accont for ECRS being carried by Load Resources Solution Qty",2917,2917,"Contin"]
[null,"$Z$39","Solution Qty",0.1,0.1,"Contin"]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$AC$3","Rest of System Total Awarded Capacity",50000,"$AC$3<=$C$3","Binding",0]
[null,"$AC$4","G1 Total Awarded Capacity",1000,"$AC$4<=$C$4","Binding",0]
[null,"$AC$5","G2 Total Awarded Capacity",1000,"$AC$5<=$C$5","Binding",0]
[null,"$AC$6","G3 Total Awarded Capacity",1000,"$AC$6<=$C$6","Binding",0]
[null,"$AC$7","G4 Total Awarded Capacity",1000,"$AC$7<=$C$7","Binding",0]
[null,"$AC$8","G5 Total Awarded Capacity",1000,"$AC$8<=$C$8","Binding",0]
[null,"$AC$9","G6 Total Awarded Capacity",1000,"$AC$9<=$C$9","Binding",0]
[null,"$AC$10","G7 Total Awarded Capacity",1000,"$AC$10<=$C$10","Binding",0]
[null,"$AC$11","G8 Total Awarded Capacity",1000,"$AC$11<=$C$11","Binding",0]
[null,"$AC$12","G9 Total Awarded Capacity",1000,"$AC$12<=$C$12","Binding",0]
[null,"$AC$13","G10 Total Awarded Capacity",1000,"$AC$13<=$C$13","Binding",0]
[null,"$AC$14","G11 Total Awarded Capacity",500,"$AC$14<=$C$14","Binding",0]
[null,"$AC$15","G12 Total Awarded Capacity",500,"$AC$15<=$C$15","Binding",0]
[null,"$AC$16","G13 Total Awarded Capacity",500,"$AC$16<=$C$16","Binding",0]
[null,"$AC$17","G14 Total Awarded Capacity",500,"$AC$17<=$C$17","Binding",0]
[null,"$AC$18","G15 Total Awarded Capacity",500,"$AC$18<=$C$18","Binding",0]
[null,"$AC$19","Power Balance Penalty Total Awarded Capacity",0,"$AC$19<=$C$19","Not Binding",10000]
[null,"$F$20","Totals with Power Balance Penalty Awarded Qty",59500,"$F$20=$B$23","Binding",0]
[null,"$K$37","REGUP Awarded + Shortage Qty Solution Qty",296,"$K$37=$B$24","Binding",0]
[null,"$P$37","RRS Awarded + Shortage Qty Solution Qty",2564,"$P$37=$B$25","Binding",0]
[null,"$U$37","ECRS Awarded + Shortage Qty Solution Qty",942,"$U$37=$B$26","Binding",0]
[null,"$Z$42","NSPIN Awarded + Shortage Qty Solution Qty",6198.0000000000018,"$Z$42=$B$27","Binding",0]
[null,"$F$3","Rest of System Awarded Qty",49571,"$F$3<=$D$3","Not Binding",429]
[null,"$F$4","G1 Awarded Qty",800,"$F$4<=$D$4","Not Binding",200]
[null,"$F$5","G2 Awarded Qty",800,"$F$5<=$D$5","Not Binding",200]
[null,"$F$6","G3 Awarded Qty",800,"$F$6<=$D$6","Not Binding",200]
[null,"$F$7","G4 Awarded Qty",800,"$F$7<=$D$7","Not Binding",200]
[null,"$F$8","G5 Awarded Qty",779,"$F$8<=$D$8","Not Binding",221]
[null,"$F$9","G6 Awarded Qty",750,"$F$9<=$D$9","Not Binding",250]
[null,"$F$10","G7 Awarded Qty",750,"$F$10<=$D$10","Not Binding",250]
[null,"$F$11","G8 Awarded Qty",750,"$F$11<=$D$11","Not Binding",250]
[null,"$F$12","G9 Awarded Qty",750,"$F$12<=$D$12","Not Binding",250]
[null,"$F$13","G10 Awarded Qty",750,"$F$13<=$D$13","Not Binding",250]
[null,"$F$14","G11 Awarded Qty",500,"$F$14<=$D$14","Binding",0]
[null,"$F$15","G12 Awarded Qty",500,"$F$15<=$D$15","Binding",0]
[null,"$F$16","G13 Awarded Qty",500,"$F$16<=$D$16","Binding",0]
[null,"$F$17","G14 Awarded Qty",500,"$F$17<=$D$17","Binding",0]
[null,"$F$18","G15 Awarded Qty",200,"$F$18<=$D$18","Not Binding",300]
[null,"$F$19","Power Balance Penalty Awarded Qty",0,"$F$19<=$D$19","Not Binding",10000]
[null,"$K$3","Rest of System Awarded Qty",0,"$K$3<=$I$3","Not Binding",2500]
[null,"$P$3","Rest of System Awarded Qty",429,"$P$3<=$N$3","Not Binding",9571]
[null,"$U$3","Rest of System Awarded Qty",0,"$U$3<=$S$3","Not Binding",50000]
[null,"$Z$3","Rest of System Awarded Qty",0,"$Z$3<=$X$3","Not Binding",50000]
[null,"$K$4","G1 Awarded Qty",0,"$K$4<=$I$4","Not Binding",50]
[null,"$P$4","G1 Awarded Qty",200,"$P$4<=$N$4","Binding",0]
[null,"$U$4","G1 Awarded Qty",0,"$U$4<=$S$4","Not Binding",1000]
[null,"$Z$4","G1 Awarded Qty",0,"$Z$4<=$X$4","Not Binding",1000]
[null,"$K$5","G2 Awarded Qty",0,"$K$5<=$I$5","Not Binding",50]
[null,"$P$5","G2 Awarded Qty",200,"$P$5<=$N$5","Binding",0]
[null,"$U$5","G2 Awarded Qty",0,"$U$5<=$S$5","Not Binding",1000]
[null,"$Z$5","G2 Awarded Qty",0,"$Z$5<=$X$5","Not Binding",1000]
[null,"$K$6","G3 Awarded Qty",0,"$K$6<=$I$6","Not Binding",50]
[null,"$P$6","G3 Awarded Qty",200,"$P$6<=$N$6","Binding",0]
[null,"$U$6","G3 Awarded Qty",0,"$U$6<=$S$6","Not Binding",1000]
[null,"$Z$6","G3 Awarded Qty",0,"$Z$6<=$X$6","Not Binding",1000]
[null,"$K$7","G4 Awarded Qty",0,"$K$7<=$I$7","Not Binding",50]
[null,"$P$7","G4 Awarded Qty",200,"$P$7<=$N$7","Binding",0]
[null,"$U$7","G4 Awarded Qty",0,"$U$7<=$S$7","Not Binding",1000]
[null,"$Z$7","G4 Awarded Qty",0,"$Z$7<=$X$7","Not Binding",1000]
[null,"$K$8","G5 Awarded Qty",21,"$K$8<=$I$8","Not Binding",29]
[null,"$P$8","G5 Awarded Qty",200,"$P$8<=$N$8","Binding",0]
[null,"$U$8","G5 Awarded Qty",0,"$U$8<=$S$8","Not Binding",1000]
[null,"$Z$8","G5 Awarded Qty",0,"$Z$8<=$X$8","Not Binding",1000]
[null,"$K$9","G6 Awarded Qty",50,"$K$9<=$I$9","Binding",0]
[null,"$P$9","G6 Awarded Qty",200,"$P$9<=$N$9","Binding",0]
[null,"$U$9","G6 Awarded Qty",0,"$U$9<=$S$9","Not Binding",1000]
[null,"$Z$9","G6 Awarded Qty",0,"$Z$9<=$X$9","Not Binding",1000]
[null,"$K$10","G7 Awarded Qty",50,"$K$10<=$I$10","Binding",0]
[null,"$P$10","G7 Awarded Qty",200,"$P$10<=$N$10","Binding",0]
[null,"$U$10","G7 Awarded Qty",0,"$U$10<=$S$10","Not Binding",1000]
[null,"$Z$10","G7 Awarded Qty",0,"$Z$10<=$X$10","Not Binding",1000]
[null,"$K$11","G8 Awarded Qty",50,"$K$11<=$I$11","Binding",0]
[null,"$P$11","G8 Awarded Qty",200,"$P$11<=$N$11","Binding",0]
[null,"$U$11","G8 Awarded Qty",0,"$U$11<=$S$11","Not Binding",1000]
[null,"$Z$11","G8 Awarded Qty",0,"$Z$11<=$X$11","Not Binding",1000]
[null,"$K$12","G9 Awarded Qty",50,"$K$12<=$I$12","Binding",0]
[null,"$P$12","G9 Awarded Qty",200,"$P$12<=$N$12","Binding",0]
[null,"$U$12","G9 Awarded Qty",0,"$U$12<=$S$12","Not Binding",1000]
[null,"$Z$12","G9 Awarded Qty",0,"$Z$12<=$X$12","Not Binding",1000]
[null,"$K$13","G10 Awarded Qty",50,"$K$13<=$I$13","Binding",0]
[null,"$P$13","G10 Awarded Qty",200,"$P$13<=$N$13","Binding",0]
[null,"$U$13","G10 Awarded Qty",0,"$U$13<=$S$13","Not Binding",1000]
[null,"$Z$13","G10 Awarded Qty",0,"$Z$13<=$X$13","Not Binding",1000]
[null,"$K$14","G11 Awarded Qty",0,"$K$14<=$I$14","Binding",0]
[null,"$P$14","G11 Awarded Qty",0,"$P$14<=$N$14","Binding",0]
[null,"$U$14","G11 Awarded Qty",0,"$U$14<=$S$14","Not Binding",500]
[null,"$Z$14","G11 Awarded Qty",0,"$Z$14<=$X$14","Not Binding",500]
[null,"$K$15","G12 Awarded Qty",0,"$K$15<=$I$15","Binding",0]
[null,"$P$15","G12 Awarded Qty",0,"$P$15<=$N$15","Binding",0]
[null,"$U$15","G12 Awarded Qty",0,"$U$15<=$S$15","Not Binding",500]
[null,"$Z$15","G12 Awarded Qty",0,"$Z$15<=$X$15","Not Binding",500]
[null,"$K$16","G13 Awarded Qty",0,"$K$16<=$I$16","Binding",0]
[null,"$P$16","G13 Awarded Qty",0,"$P$16<=$N$16","Binding",0]
[null,"$U$16","G13 Awarded Qty",0,"$U$16<=$S$16","Not Binding",500]
[null,"$Z$16","G13 Awarded Qty",0,"$Z$16<=$X$16","Not Binding",500]
[null,"$K$17","G14 Awarded Qty",0,"$K$17<=$I$17","Binding",0]
[null,"$P$17","G14 Awarded Qty",0,"$P$17<=$N$17","Binding",0]
[null,"$U$17","G14 Awarded Qty",0,"$U$17<=$S$17","Not Binding",500]
[null,"$Z$17","G14 Awarded Qty",0,"$Z$17<=$X$17","Not Binding",500]
[null,"$K$18","G15 Awarded Qty",0,"$K$18<=$I$18","Binding",0]
[null,"$P$18","G15 Awarded Qty",0,"$P$18<=$N$18","Binding",0]
[null,"$U$18","G15 Awarded Qty",300,"$U$18<=$S$18","Not Binding",200]
[null,"$Z$18","G15 Awarded Qty",0,"$Z$18<=$X$18","Not Binding",500]
[null,"$K$25","Max RRS Demand Curve Qty Solution Qty",0,"$K$25<=$I$25","Not Binding",200]
[null,"$P$25","Max RRS Demand Curve Qty Solution Qty",0,"$P$25<=$N$25","Not Binding",1800]
[null,"$U$25","Max RRS Demand Curve Qty Solution Qty",0,"$U$25<=$S$25","Not Binding",205]
[null,"$K$26","Max ECRS Demand Curve Qty Solution Qty",0,"$K$26<=$I$26","Not Binding",5]
[null,"$P$26","Max ECRS Demand Curve Qty Solution Qty",0,"$P$26<=$N$26","Not Binding",54]
[null,"$U$26","Max ECRS Demand Curve Qty Solution Qty",0,"$U$26<=$S$26","Not Binding",95]
[null,"$K$27","Max NSPIN Demand Curve Qty Solution Qty",0,"$K$27<=$I$27","Not Binding",30]
[null,"$P$27","Max NSPIN Demand Curve Qty Solution Qty",0,"$P$27<=$N$27","Not Binding",316]
[null,"$U$27","Max NSPIN Demand Curve Qty Solution Qty",95,"$U$27<=$S$27","Binding",0]
[null,"$K$28","Solution Qty",0,"$K$28<=$I$28","Not Binding",36]
[null,"$P$28","Solution Qty",110,"$P$28<=$N$28","Not Binding",259]
[null,"$U$28","Solution Qty",113,"$U$28<=$S$28","Binding",0]
[null,"$K$29","Objective Function Solution Qty",5,"$K$29<=$I$29","Binding",0]
[null,"$P$29","Objective Function Solution Qty",5,"$P$29<=$N$29","Binding",0]
[null,"$U$29","Objective Function Solution Qty",100,"$U$29<=$S$29","Binding",0]
[null,"$K$30","Solution Qty",5,"$K$30<=$I$30","Binding",0]
[null,"$P$30","Solution Qty",5,"$P$30<=$N$30","Binding",0]
[null,"$U$30","Solution Qty",64,"$U$30<=$S$30","Binding",0]
[null,"$K$31","Output Prices ($/MWh) Solution Qty",5,"$K$31<=$I$31","Binding",0]
[null,"$P$31","Output Prices ($/MWh) Solution Qty",5,"$P$31<=$N$31","Binding",0]
[null,"$U$31","Output Prices ($/MWh) Solution Qty",79,"$U$31<=$S$31","Binding",0]
[null,"$K$32","Energy Solution Qty",5,"$K$32<=$I$32","Binding",0]
[null,"$P$32","Energy Solution Qty",5,"$P$32<=$N$32","Binding",0]
[null,"$U$32","Energy Solution Qty",81,"$U$32<=$S$32","Binding",0]
[null,"$K$33","REGUP Solution Qty",2.5,"$K$33<=$I$33","Binding",0]
[null,"$P$33","REGUP Solution Qty",2.5,"$P$33<=$N$33","Binding",0]
[null,"$U$33","REGUP Solution Qty",68,"$U$33<=$S$33","Binding",0]
[null,"$K$34","RRS Solution Qty",2.5,"$K$34<=$I$34","Binding",0]
[null,"$P$34","RRS Solution Qty",2.5,"$P$34<=$N$34","Binding",0]
[null,"$U$34","RRS Solution Qty",42,"$U$34<=$S$34","Binding",0]
[null,"$Z$25","Max RRS Demand Curve Qty Solution Qty",151.90000000000146,"$Z$25<=$X$25","Not Binding",9.9999999998544808E-2]
[null,"$Z$26","Max ECRS Demand Curve Qty Solution Qty",201,"$Z$26<=$X$26","Binding",0]
[null,"$Z$27","Max NSPIN Demand Curve Qty Solution Qty",117,"$Z$27<=$X$27","Binding",0]
[null,"$Z$28","Solution Qty",169,"$Z$28<=$X$28","Binding",0]
[null,"$Z$29","Objective Function Solution Qty",86,"$Z$29<=$X$29","Binding",0]
[null,"$Z$30","Solution Qty",162,"$Z$30<=$X$30","Binding",0]
[null,"$Z$31","Output Prices ($/MWh) Solution Qty",210,"$Z$31<=$X$31","Binding",0]
[null,"$Z$32","Energy Solution Qty",215,"$Z$32<=$X$32","Binding",0]
[null,"$Z$33","REGUP Solution Qty",330,"$Z$33<=$X$33","Binding",0]
[null,"$Z$34","RRS Solution Qty",276,"$Z$34<=$X$34","Binding",0]
[null,"$Z$35","ECRS Solution Qty",362,"$Z$35<=$X$35","Binding",0]
[null,"$Z$36","NSPIN Solution Qty",419,"$Z$36<=$X$36","Binding",0]
[null,"$Z$37","ECRS Awarded + Shortage Qty Solution Qty",582,"$Z$37<=$X$37","Binding",0]
[null,"$Z$38","* Example does not accont for ECRS being carried by Load Resources Solution Qty",2917,"$Z$38<=$X$38","Binding",0]
[null,"$Z$39","Solution Qty",0.1,"$Z$39<=$X$39","Binding",0]

{"sheet":"Sensitivity Report","index":5,"n_rows":160,"n_cols":8,"rows_kept":160,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 15.0 Sensitivity Report"]
["Worksheet: [Real-Time_Co-optimization_-_Automated_Scenario_Analysis_-_Update_Ver5_2.xlsm]Optimization Engine"]
["Report Created: 7/16/2019 3:08:09 PM"]
[]
[]
["Variable Cells"]
[null,null,null,"Final","Reduced","Objective","Allowable","Allowable"]
[null,"Cell","Name","Value","Cost","Coefficient","Increase","Decrease"]
[null,"$F$3","Rest of System Awarded Qty",49571,0,25,5,25]
[null,"$F$4","G1 Awarded Qty",800,0,30,20,5]
[null,"$F$5","G2 Awarded Qty",800,0,35,15,10]
[null,"$F$6","G3 Awarded Qty",800,0,40,10,15]
[null,"$F$7","G4 Awarded Qty",800,0,45,5,20]
[null,"$F$8","G5 Awarded Qty",779,0,50,5,5]
[null,"$F$9","G6 Awarded Qty",750,0,55,945,5]
[null,"$F$10","G7 Awarded Qty",750,0,60,940,10]
[null,"$F$11","G8 Awarded Qty",750,0,65,935,15]
[null,"$F$12","G9 Awarded Qty",750,0,70,930,20]
[null,"$F$13","G10 Awarded Qty",750,0,75,925,25]
[null,"$F$14","G11 Awarded Qty",500,0,80,30,1E+30]
[null,"$F$15","G12 Awarded Qty",500,0,100,50,1E+30]
[null,"$F$16","G13 Awarded Qty",500,0,150,100,1E+30]
[null,"$F$17","G14 Awarded Qty",500,0,250,200,1E+30]
[null,"$F$18","G15 Awarded Qty",200,0,1000,25,225]
[null,"$F$19","Power Balance Penalty Awarded Qty",0,6476,11001,1E+30,6476]
[null,"$K$3","Rest of System Awarded Qty",0,25,0,1E+30,25]
[null,"$K$4","G1 Awarded Qty",0,20,0,1E+30,20]
[null,"$K$5","G2 Awarded Qty",0,15,0,1E+30,15]
[null,"$K$6","G3 Awarded Qty",0,10,0,1E+30,10]
[null,"$K$7","G4 Awarded Qty",0,5,0,1E+30,5]
[null,"$K$8","G5 Awarded Qty",21,0,0,5,5]
[null,"$K$9","G6 Awarded Qty",50,-5,0,5,1E+30]
[null,"$K$10","G7 Awarded Qty",50,-10,0,10,1E+30]
[null,"$K$11","G8 Awarded Qty",50,-15,0,15,1E+30]
[null,"$K$12","G9 Awarded Qty",50,-20,0,20,1E+30]
[null,"$K$13","G10 Awarded Qty",50,-25,0,25,1E+30]
[null,"$K$14","G11 Awarded Qty",0,-30,0,1E+30,30]
[null,"$K$15","G12 Awarded Qty",0,-50,0,1E+30,50]
[null,"$K$16","G13 Awarded Qty",0,-100,0,1E+30,100]
[null,"$K$17","G14 Awarded Qty",0,-200,0,1E+30,200]
[null,"$K$18","G15 Awarded Qty",0,-950,0,1E+30,950]
[null,"$P$3","Rest of System Awarded Qty",429,0,0,25,5]
[null,"$P$4","G1 Awarded Qty",200,-5,0,5,1E+30]
[null,"$P$5","G2 Awarded Qty",200,-10,0,10,1E+30]
[null,"$P$6","G3 Awarded Qty",200,-15,0,15,1E+30]
[null,"$P$7","G4 Awarded Qty",200,-20,0,20,1E+30]
[null,"$P$8","G5 Awarded Qty",200,-25,0,25,1E+30]
[null,"$P$9","G6 Awarded Qty",200,-30,0,30,1E+30]
[null,"$P$10","G7 Awarded Qty",200,-35,0,35,1E+30]
[null,"$P$11","G8 Awarded Qty",200,-40,0,40,1E+30]
[null,"$P$12","G9 Awarded Qty",200,-45,0,45,1E+30]
[null,"$P$13","G10 Awarded Qty",200,-50,0,50,1E+30]
[null,"$P$14","G11 Awarded Qty",0,-55,0,1E+30,55]
[null,"$P$15","G12 Awarded Qty",0,-75,0,1E+30,75]
[null,"$P$16","G13 Awarded Qty",0,-125,0,1E+30,125]
[null,"$P$17","G14 Awarded Qty",0,-225,0,1E+30,225]
[null,"$P$18","G15 Awarded Qty",0,-975,0,1E+30,975]
[null,"$U$3","Rest of System Awarded Qty",0,975,0,1E+30,975]
[null,"$U$4","G1 Awarded Qty",0,970,0,1E+30,970]
[null,"$U$5","G2 Awarded Qty",0,965,0,1E+30,965]
[null,"$U$6","G3 Awarded Qty",0,960,0,1E+30,960]
[null,"$U$7","G4 Awarded Qty",0,955,0,1E+30,955]
[null,"$U$8","G5 Awarded Qty",0,950,0,1E+30,950]
[null,"$U$9","G6 Awarded Qty",0,945,0,1E+30,945]
[null,"$U$10","G7 Awarded Qty",0,940,0,1E+30,940]
[null,"$U$11","G8 Awarded Qty",0,935,0,1E+30,935]
[null,"$U$12","G9 Awarded Qty",0,930,0,1E+30,930]
[null,"$U$13","G10 Awarded Qty",0,925,0,1E+30,925]
[null,"$U$14","G11 Awarded Qty",0,920,0,1E+30,920]
[null,"$U$15","G12 Awarded Qty",0,900,0,1E+30,900]
[null,"$U$16","G13 Awarded Qty",0,850,0,1E+30,850]
[null,"$U$17","G14 Awarded Qty",0,750,0,1E+30,750]
[null,"$U$18","G15 Awarded Qty",300,0,0,225,25]
[null,"$Z$3","Rest of System Awarded Qty",0,3000,0,1E+30,3000]
[null,"$Z$4","G1 Awarded Qty",0,2995,0,1E+30,2995]
[null,"$Z$5","G2 Awarded Qty",0,2990,0,1E+30,2990]
[null,"$Z$6","G3 Awarded Qty",0,2985,0,1E+30,2985]
[null,"$Z$7","G4 Awarded Qty",0,2980,0,1E+30,2980]
[null,"$Z$8","G5 Awarded Qty",0,2975,0,1E+30,2975]
[null,"$Z$9","G6 Awarded Qty",0,2970,0,1E+30,2970]
[null,"$Z$10","G7 Awarded Qty",0,2965,0,1E+30,2965]
[null,"$Z$11","G8 Awarded Qty",0,2960,0,1E+30,2960]
[null,"$Z$12","G9 Awarded Qty",0,2955,0,1E+30,2955]
[null,"$Z$13","G10 Awarded Qty",0,2950,0,1E+30,2950]
[null,"$Z$14","G11 Awarded Qty",0,2945,0,1E+30,2945]
[null,"$Z$15","G12 Awarded Qty",0,2925,0,1E+30,2925]
[null,"$Z$16","G13 Awarded Qty",0,2875,0,1E+30,2875]
[null,"$Z$17","G14 Awarded Qty",0,2775,0,1E+30,2775]
[null,"$Z$18","G15 Awarded Qty",0,2025,0,1E+30,2025]
[null,"$K$25","Max RRS Demand Curve Qty Solution Qty",0,4525,9000,1E+30,4525]
[null,"$K$26","Max ECRS Demand Curve Qty Solution Qty",0,2025,6500,1E+30,2025]
[null,"$K$27","Max NSPIN Demand Curve Qty Solution Qty",0,1025,5500,1E+30,1025]
[null,"$K$28","Solution Qty",0,25,4500,1E+30,25]
[null,"$K$29","Objective Function Solution Qty",5,-2225,2250,2225,1E+30]
[null,"$K$30","Solution Qty",5,-3475,1000,3475,1E+30]
[null,"$K$31","Output Prices ($/MWh) Solution Qty",5,-3975,500,3975,1E+30]
[null,"$K$32","Energy Solution Qty",5,-4075,400,4075,1E+30]
[null,"$K$33","REGUP Solution Qty",2.5,-4175,300,4175,1E+30]
[null,"$K$34","RRS Solution Qty",2.5,-4225,250,4225,1E+30]
[null,"$P$25","Max RRS Demand Curve Qty Solution Qty",0,4500,9000,1E+30,4500]
[null,"$P$26","Max ECRS Demand Curve Qty Solution Qty",0,2000,6500,1E+30,2000]
[null,"$P$27","Max NSPIN Demand Curve Qty Solution Qty",0,1000,5500,1E+30,1000]
[null,"$P$28","Solution Qty",110,0,4500,25,25]
[null,"$P$29","Objective Function Solution Qty",5,-2250,2250,2250,1E+30]
[null,"$P$30","Solution Qty",5,-3500,1000,3500,1E+30]
[null,"$P$31","Output Prices ($/MWh) Solution Qty",5,-4000,500,4000,1E+30]
[null,"$P$32","Energy Solution Qty",5,-4100,400,4100,1E+30]
[null,"$P$33","REGUP Solution Qty",2.5,-4200,300,4200,1E+30]
[null,"$P$34","RRS Solution Qty",2.5,-4250,250,4250,1E+30]
[null,"$U$25","Max RRS Demand Curve Qty Solution Qty",0,475,4000,1E+30,475]
[null,"$U$26","Max ECRS Demand Curve Qty Solution Qty",0,225,3750,1E+30,225]
[null,"$U$27","Max NSPIN Demand Curve Qty Solution Qty",95,-25,3500,25,1E+30]
[null,"$U$28","Solution Qty",113,-275,3250,275,1E+30]
[null,"$U$29","Objective Function Solution Qty",100,-525,3000,525,1E+30]
[null,"$U$30","Solution Qty",64,-775,2750,775,1E+30]
[null,"$U$31","Output Prices ($/MWh) Solution Qty",79,-1025,2500,1025,1E+30]
[null,"$U$32","Energy Solution Qty",81,-1275,2250,1275,1E+30]
[null,"$U$33","REGUP Solution Qty",68,-1525,2000,1525,1E+30]
[null,"$U$34","RRS Solution Qty",42,-1775,1750,1775,1E+30]
[null,"$Z$25","Max RRS Demand Curve Qty Solution Qty",151.90000000000146,0,1500,2025,250]
[null,"$Z$26","Max ECRS Demand Curve Qty Solution Qty",201,-250,1250,250,1E+30]
[null,"$Z$27","Max NSPIN Demand Curve Qty Solution Qty",117,-500,1000,500,1E+30]
[null,"$Z$28","Solution Qty",169,-750,750,750,1E+30]
[null,"$Z$29","Objective Function Solution Qty",86,-875,625,875,1E+30]
[null,"$Z$30","Solution Qty",162,-1000,500,1000,1E+30]
[null,"$Z$31","Output Prices ($/MWh) Solution Qty",210,-1125,375,1125,1E+30]
[null,"$Z$32","Energy Solution Qty",215,-1250,250,1250,1E+30]
[null,"$Z$33","REGUP Solution Qty",330,-1350,150,1350,1E+30]
[null,"$Z$34","RRS Solution Qty",276,-1400,100,1400,1E+30]
[null,"$Z$35","ECRS Solution Qty",362,-1450,50,1450,1E+30]
[null,"$Z$36","NSPIN Solution Qty",419,-1475,25,1475,1E+30]
[null,"$Z$37","ECRS Awarded + Shortage Qty Solution Qty",582,-1490,10,1490,1E+30]
[null,"$Z$38","* Example does not accont for ECRS being carried by Load Resources Solution Qty",2917,-1499.9900000000052,9.9999999947613105E-3,1499.9900000000052,1E+30]
[null,"$Z$39","Solution Qty",0.1,-1500,0,1500,1E+30]
[]
["Constraints"]
[null,null,null,"Final","Shadow","Constraint","Allowable","Allowable"]
[null,"Cell","Name","Value","Price","R.H. Side","Increase","Decrease"]
[null,"$AC$3","Rest of System Total Awarded Capacity",50000,-4500,50000,110,259]
[null,"$AC$4","G1 Total Awarded Capacity",1000,-4495,1000,110,259]
[null,"$AC$5","G2 Total Awarded Capacity",1000,-4490,1000,110,259]
[null,"$AC$6","G3 Total Awarded Capacity",1000,-4485,1000,110,259]
[null,"$AC$7","G4 Total Awarded Capacity",1000,-4480,1000,110,259]
[null,"$AC$8","G5 Total Awarded Capacity",1000,-4475,1000,110,259]
[null,"$AC$9","G6 Total Awarded Capacity",1000,-4470,1000,110,259]
[null,"$AC$10","G7 Total Awarded Capacity",1000,-4465,1000,110,259]
[null,"$AC$11","G8 Total Awarded Capacity",1000,-4460,1000,110,259]
[null,"$AC$12","G9 Total Awarded Capacity",1000,-4455,1000,110,259]
[null,"$AC$13","G10 Total Awarded Capacity",1000,-4450,1000,110,259]
[null,"$AC$14","G11 Total Awarded Capacity",500,-4445,500,0,259]
[null,"$AC$15","G12 Total Awarded Capacity",500,-4425,500,0,259]
[null,"$AC$16","G13 Total Awarded Capacity",500,-4375,500,0,259]
[null,"$AC$17","G14 Total Awarded Capacity",500,-4275,500,0,259]
[null,"$AC$18","G15 Total Awarded Capacity",500,-3525,500,110,200]
[null,"$AC$19","Power Balance Penalty Total Awarded Capacity",0,0,10000,1E+30,10000]
[null,"$F$20","Totals with Power Balance Penalty Awarded Qty",59500,4525,59500,259,110]
[null,"$K$37","REGUP Awarded + Shortage Qty Solution Qty",296,4475,296,29,21]
[null,"$P$37","RRS Awarded + Shortage Qty Solution Qty",2564,4500,2564,259,110]
[null,"$U$37","ECRS Awarded + Shortage Qty Solution Qty",942,3525,942,200,110]
[null,"$Z$42","NSPIN Awarded + Shortage Qty Solution Qty",6198.0000000000018,1500,6198.0000000000009,9.9999999998544808E-2,151.90000000000146]