{"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":262,"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":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[1,"Designed to illustrate the energy and A/S pricing results with RTC under A/S surplus and shortage conditions by decomposing the current ORDC"]
[null,"into a reserve demand curve for each A/S"]
[2,"Assumptions"]
[null,null,"VOLL = $9,000"]
[null,null,"Offer Cap = $2,000"]
[null,null,"Max Reserve Demand Curve Value = $7000.99"]
[null,null,"No Congestion"]
[null,null,"Generators available from 0 to HSL for Energy, available in quantities offered for each A/S"]
[null,null,"All RRS provided from generators for the purpose of this example"]
[3,"A/S Demand Curves"]
[null,null,"Designed to approximate the 2017 Summer Peak A/S requirements (URS = 270, RRS = 2,300, NSRS = 1,375)"]
[null,null,"Simulating a different time period would require decomposing the applicable ORDC into the individual A/S product demand curves"]
[null,null,"NSRS represented as SOR (Spinning Online Reserves from the whitepaper, basically online NSRS)"]
[null,null,"170 MW of URS and 1,830 MW of RRS are priced at $7,000.99"]
[null,null,"Approx 100 MW of URS and 100 MW of RRS are priced at values that approximate the steps of the CURRENT PBPC"]
[null,null,"The remaining RRS is priced at values that approximate the existing ORDC from 1,930 to 2,300 MW"]
[null,null,"The maximum value on the SOR demand curve is $1,425 and extends for 3,000 MW (beyond the 1,375 MW requirement)"]
[null,null,"Tab 'Reserve Demand Curves CHT' shows charts with the resulting individual and aggregate A/S demand curves"]
[4,"Running a Case"]
[null,null,"G1 represents the sum of 50,000 MW of infra-marginal generation"]
[null,null,"G2-G8 represent online generation with increasing energy offers and identical A/S offer quantities"]
[null,null,"G9 represents a quick-start unit that can only provide energy or SOR"]
[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, A/S 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":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Note: This tab is only one example of a potential example AS demand curve. "]
[]
[0,0,7000.99]
[170,{"$f":"A4+B3","v":170},7000.99]
[1830,{"$f":"A5+B4","v":2000},7000.99]
[10,{"$f":"A6+B5","v":2010},4500]
[100,2110,4500]
[15,2125,3500]
[100,2225,3500]
[15,2240,2500]
[55,2295,2500]
[15,2310,1500]
[55,2365,1500]
[375,2740,1425]
[15,2755,1000]
[55,2810,1000]
[15,2825,500]
[55,2880,500]
[375,3255,422]
[15,3270,250]
[50,3320,250]
[375,3695,139]
[375,4070,46]
[375,4445,13]
[375,4820,3]
[375,5195,0.6]
[375,5570,0.1]
[]
[null,0,7000.99]
[170,{"$f":"A30","v":170},7000.99]
[10,{"$f":"B30+A31","v":180},4500]
[15,195,3500]
[15,210,2500]
[15,225,1500]
[15,240,1000]
[15,255,500]
[15,270,250]
[]
[null,0,7000.99]
[1830,{"$f":"A40","v":1830},7000.99]
[100,{"$f":"B40+A41","v":1930},4500]
[100,2030,3500]
[55,2085,2500]
[55,2140,1500]
[55,2195,1000]
[55,2250,500]
[50,2300,250]
[]
[null,0,1425]
[375.000001,{"$f":"A50","v":375.000001},1425]
[375,{"$f":"B50+A51","v":750.000001},422]
[375,1125.0000009999999,139]
[375,1500.0000009999999,46]
[375,1875.0000009999999,13]
[375,2250.0000009999999,3]
[375,2625.0000009999999,0.6]
[375,3000.0000009999999,0.1]

{"sheet":"Optimization Engine","index":2,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,7,27,8],[27,12,27,13],[27,17,27,18],[0,17,0,20],[0,7,0,10],[0,12,0,15],[15,7,15,10],[15,12,15,15],[15,17,15,20],[22,0,22,1],[0,2,0,5],[0,0,0,1],[14,0,14,1],[1,0,12,0],[14,2,20,5]]}
["Modify blue cells and click 'Solve' to view results. White cells should not be modified.",null,"Energy Offers and Awards",null,null,null,null,"URS Offers and Awards",null,null,null,null,"RRS Offers and Awards",null,null,null,null,"SOR Offers and Awards",null,null,null,null,"Total Awarded Capacity"]
[null,"Generator","Offer Qty","Offer Price","Awarded Qty","Energy Cost",null,"Offer Qty","Offer Price","Awarded Qty","URS Cost",null,"Offer Qty","Offer Price","Awarded Qty","RRS Cost",null,"Offer Qty","Offer Price","Awarded Qty","SOR Cost"]
[null,"Rest of System",50000,25,50000,{"$f":"E3*D3","v":1250000},null,50,0,0,{"$f":"J3*I3","v":0},null,500,0,0,{"$f":"O3*N3","v":0},null,50000,0,0,{"$f":"T3*S3","v":0},null,{"$f":"E3+J3+O3+T3","v":50000}]
[null,"G2",1000,30,1000,{"$f":"E4*D4","v":30000},null,50,0,0,{"$f":"J4*I4","v":0},null,500,0,0,{"$f":"O4*N4","v":0},null,1000,0,0,{"$f":"T4*S4","v":0},null,{"$f":"E4+J4+O4+T4","v":1000}]
[null,"G3",1000,35,980,34300,null,50,0,20,0,null,500,0,0,0,null,1000,0,0,0,null,1000]
[null,"G4",1000,40,20,800,null,50,0,50,0,null,500,0,500,0,null,1000,0,430,0,null,1000]
[null,"G5",1000,45,0,0,null,50,0,50,0,null,500,0,500,0,null,1000,0,450,0,null,1000]
[null,"G6",1000,50,0,0,null,50,0,50,0,null,500,0,500,0,null,1000,0,450,0,null,1000]
[null,"G7",1000,55,0,0,null,50,0,50,0,null,500,0,500,0,null,1000,0,20,0,null,570]
[null,"G8",1000,60,0,0,null,50,0,50,0,null,500,0,300,0,null,1000,0,650,0,null,1000]
[null,"G9",1000,800,0,0,null,0,0,0,0,null,0,0,0,0,null,1000,0,1000,0,null,1000]
[null,"Power Balance Penalty",10000,9001,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0]
[null,"Totals",{"$f":"SUM(C3:C12)","v":68000},null,{"$f":"SUM(E3:E12)","v":52000},{"$f":"SUM(F3:F12)","v":1315100},null,{"$f":"SUM(H3:H12)","v":400},null,{"$f":"SUM(J3:J12)","v":270},{"$f":"SUM(K3:K12)","v":0},null,{"$f":"SUM(M3:M12)","v":4000},null,{"$f":"SUM(O3:O12)","v":2300},{"$f":"SUM(P3:P12)","v":0},null,{"$f":"SUM(R3:R12)","v":58000},null,{"$f":"SUM(T3:T12)","v":3000},{"$f":"SUM(U3:U12)","v":0},null,{"$f":"SUM(W3:W12)","v":57570}]
[]
["System Inputs",null,"As an example, change 'Demand' value to 53000 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",52000,null,null,null,null,null,"URS Shortage",null,null,null,null,"RRS Shortage",null,null,null,null,"SOR Shortage"]
["URS Requirement",270,null,null,null,null,null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Solution Cost",null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Solution Cost",null,"Demand Curve Qty","Demand Curve Price","Solution Qty","Solution Cost"]
["RRS Requirement",2300,null,null,null,null,null,170,7000.99,0,{"$f":"J18*I18","v":0},null,1830,7000.99,0,{"$f":"O18*N18","v":0},null,375.000001,1425,0,{"$f":"T18*S18","v":0}]
["SOR Requirement",3000,null,null,null,null,null,10,4500,0,{"$f":"J19*I19","v":0},null,100,4500,0,{"$f":"O19*N19","v":0},null,375,422,0,{"$f":"T19*S19","v":0}]
[null,null,null,null,null,null,null,15,3500,0,0,null,100,3500,0,0,null,375,139,0,0]
["Objective Function",{"$f":"F13+K13+K26+P13+U13+P26+U26","v":1315100},null,null,null,null,null,15,2500,0,0,null,55,2500,0,0,null,375,46,0,0]
[null,null,null,null,null,null,null,15,1500,0,0,null,55,1500,0,0,null,375,13,0,0]
["Output Prices",null,null,null,null,null,null,15,1000,0,0,null,55,1000,0,0,null,375,3,0,0]
["Energy",40,null,null,null,null,null,15,500,0,0,null,55,500,0,0,null,375,0.6,0,0]
["URS",5,null,null,null,null,null,15,250,0,0,null,50,250,0,0,null,375,0.1,0,0]
["RRS",0,null,null,null,null,null,{"$f":"SUM(H18:H25)","v":270},null,{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},null,{"$f":"SUM(M18:M25)","v":2300},null,{"$f":"SUM(O18:O25)","v":0},{"$f":"SUM(P18:P25)","v":0},null,{"$f":"SUM(R18:R25)","v":3000.0000009999999},null,{"$f":"SUM(T18:T25)","v":0},{"$f":"SUM(U18:U25)","v":0}]
["SOR",0]
[null,null,null,null,null,null,null,"URS Awarded + Shortage Qty",null,{"$f":"J13+J26","v":270},null,null,"RRS Awarded + Shortage Qty",null,{"$f":"O13+O26","v":2300},null,null,"SOR Awarded + Shortage Qty",null,{"$f":"T13+T26","v":3000}]

{"sheet":"Results Summary","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Awarded MW"]
[null,"Energy","URS","RRS","SOR"]
["G2",{"$f":"'Optimization Engine'!E4","v":1000},{"$f":"'Optimization Engine'!J4","v":0},{"$f":"'Optimization Engine'!O3","v":0},{"$f":"'Optimization Engine'!T3","v":0}]
["G3",{"$f":"'Optimization Engine'!E5","v":980},{"$f":"'Optimization Engine'!J5","v":20},{"$f":"'Optimization Engine'!O4","v":0},{"$f":"'Optimization Engine'!T4","v":0}]
["G4",{"$f":"'Optimization Engine'!E6","v":20},{"$f":"'Optimization Engine'!J6","v":50},{"$f":"'Optimization Engine'!O5","v":0},{"$f":"'Optimization Engine'!T5","v":0}]
["G5",{"$f":"'Optimization Engine'!E7","v":0},{"$f":"'Optimization Engine'!J7","v":50},{"$f":"'Optimization Engine'!O6","v":500},{"$f":"'Optimization Engine'!T6","v":430}]
["G6",{"$f":"'Optimization Engine'!E8","v":0},{"$f":"'Optimization Engine'!J8","v":50},{"$f":"'Optimization Engine'!O7","v":500},{"$f":"'Optimization Engine'!T7","v":450}]
["G7",{"$f":"'Optimization Engine'!E9","v":0},{"$f":"'Optimization Engine'!J9","v":50},{"$f":"'Optimization Engine'!O8","v":500},{"$f":"'Optimization Engine'!T8","v":450}]
["G8",{"$f":"'Optimization Engine'!E10","v":0},{"$f":"'Optimization Engine'!J10","v":50},{"$f":"'Optimization Engine'!O9","v":500},{"$f":"'Optimization Engine'!T9","v":20}]
["G9",{"$f":"'Optimization Engine'!E11","v":0},{"$f":"'Optimization Engine'!J11","v":0},{"$f":"'Optimization Engine'!O10","v":300},{"$f":"'Optimization Engine'!T10","v":650}]
["Award",null,{"$f":"SUM(C3:C10)","v":270},{"$f":"SUM(D3:D10)","v":2300},{"$f":"'Optimization Engine'!T11","v":1000}]
["Req",null,270,2300,{"$f":"'Optimization Engine'!T12","v":0}]
[]
["Price",{"$f":"'Optimization Engine'!$B$24","v":40},{"$f":"'Optimization Engine'!$B$25","v":5},{"$f":"'Optimization Engine'!$B$26","v":0},{"$f":"'Optimization Engine'!$B$27","v":0}]

{"sheet":"Answer Report","index":4,"n_rows":166,"n_cols":7,"rows_kept":166,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 15.0 Answer Report"]
["Worksheet: [RT Co-Optimization_Scenario v3.xlsm]Optimization Engine"]
["Report Created: 6/28/2017 10:57:20 AM"]
["Result: Label1"]
["Solver Engine"]
[null,"Engine: Simplex LP"]
[null,"Solution Time: 0.109 Seconds."]
[null,"Iterations: 50 Subproblems: 0"]
["Solver Options"]
[null,"Max Time 100 sec,  Iterations 100, Precision 0.000001"]
[null,"Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 0.01%, Solve Without Integer Constraints, Assume NonNegative"]
[]
[]
["Objective Cell ()"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$B$21","Objective Function Totals",1357104.5,1315100]
[]
[]
["Variable Cells"]
[null,"Cell","Name","Original Value","Final Value","Integer"]
[null,"$E$3","Rest of System Awarded Qty",50000,50000,"Contin"]
[null,"$E$4","G2 Awarded Qty",1000,1000,"Contin"]
[null,"$E$5","G3 Awarded Qty",980,980,"Contin"]
[null,"$E$6","G4 Awarded Qty",650,20,"Contin"]
[null,"$E$7","G5 Awarded Qty",370,0,"Contin"]
[null,"$E$8","G6 Awarded Qty",0,0,"Contin"]
[null,"$E$9","G7 Awarded Qty",0,0,"Contin"]
[null,"$E$10","G8 Awarded Qty",0,0,"Contin"]
[null,"$E$11","G9 Awarded Qty",0,0,"Contin"]
[null,"$E$12","Power Balance Penalty Awarded Qty",0,0,"Contin"]
[null,"$J$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$J$4","G2 Awarded Qty",0,0,"Contin"]
[null,"$J$5","G3 Awarded Qty",20,20,"Contin"]
[null,"$J$6","G4 Awarded Qty",50,50,"Contin"]
[null,"$J$7","G5 Awarded Qty",50,50,"Contin"]
[null,"$J$8","G6 Awarded Qty",50,50,"Contin"]
[null,"$J$9","G7 Awarded Qty",50,50,"Contin"]
[null,"$J$10","G8 Awarded Qty",50,50,"Contin"]
[null,"$J$11","G9 Awarded Qty",0,0,"Contin"]
[null,"$J$12","Power Balance Penalty Awarded Qty",0,0,"Contin"]
[null,"$O$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$O$4","G2 Awarded Qty",0,0,"Contin"]
[null,"$O$5","G3 Awarded Qty",0,0,"Contin"]
[null,"$O$6","G4 Awarded Qty",300,500,"Contin"]
[null,"$O$7","G5 Awarded Qty",500,500,"Contin"]
[null,"$O$8","G6 Awarded Qty",500,500,"Contin"]
[null,"$O$9","G7 Awarded Qty",500,500,"Contin"]
[null,"$O$10","G8 Awarded Qty",500,300,"Contin"]
[null,"$O$11","G9 Awarded Qty",0,0,"Contin"]
[null,"$O$12","Power Balance Penalty Awarded Qty",0,0,"Contin"]
[null,"$T$3","Rest of System Awarded Qty",0,0,"Contin"]
[null,"$T$4","G2 Awarded Qty",0,0,"Contin"]
[null,"$T$5","G3 Awarded Qty",0,0,"Contin"]
[null,"$T$6","G4 Awarded Qty",0,430,"Contin"]
[null,"$T$7","G5 Awarded Qty",80,450,"Contin"]
[null,"$T$8","G6 Awarded Qty",450,450,"Contin"]
[null,"$T$9","G7 Awarded Qty",450,20,"Contin"]
[null,"$T$10","G8 Awarded Qty",450,650,"Contin"]
[null,"$T$11","G9 Awarded Qty",1000,1000,"Contin"]
[null,"$T$12","Power Balance Penalty Awarded Qty",0,0,"Contin"]
[null,"$J$18","RRS Requirement Solution Qty",0,0,"Contin"]
[null,"$J$19","SOR Requirement Solution Qty",0,0,"Contin"]
[null,"$J$20","Solution Qty",0,0,"Contin"]
[null,"$J$21","Objective Function Solution Qty",0,0,"Contin"]
[null,"$J$22","Solution Qty",0,0,"Contin"]
[null,"$J$23","Output Prices Solution Qty",0,0,"Contin"]
[null,"$J$24","Energy Solution Qty",0,0,"Contin"]
[null,"$J$25","URS Solution Qty",0,0,"Contin"]
[null,"$O$18","RRS Requirement Solution Qty",0,0,"Contin"]
[null,"$O$19","SOR Requirement Solution Qty",0,0,"Contin"]
[null,"$O$20","Solution Qty",0,0,"Contin"]
[null,"$O$21","Objective Function Solution Qty",0,0,"Contin"]
[null,"$O$22","Solution Qty",0,0,"Contin"]
[null,"$O$23","Output Prices Solution Qty",0,0,"Contin"]
[null,"$O$24","Energy Solution Qty",0,0,"Contin"]
[null,"$O$25","URS Solution Qty",0,0,"Contin"]
[null,"$T$18","RRS Requirement Solution Qty",0,0,"Contin"]
[null,"$T$19","SOR Requirement Solution Qty",0,0,"Contin"]
[null,"$T$20","Solution Qty",0,0,"Contin"]
[null,"$T$21","Objective Function Solution Qty",0,0,"Contin"]
[null,"$T$22","Solution Qty",0,0,"Contin"]
[null,"$T$23","Output Prices Solution Qty",0,0,"Contin"]
[null,"$T$24","Energy Solution Qty",195,0,"Contin"]
[null,"$T$25","URS Solution Qty",375,0,"Contin"]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$W$8","G6 Total Awarded Capacity",1000,"$W$8<=$C$8","Binding",0]
[null,"$W$5","G3 Total Awarded Capacity",1000,"$W$5<=$C$5","Binding",0]
[null,"$W$6","G4 Total Awarded Capacity",1000,"$W$6<=$C$6","Binding",0]
[null,"$W$9","G7 Total Awarded Capacity",570,"$W$9<=$C$9","Not Binding",430]
[null,"$W$4","G2 Total Awarded Capacity",1000,"$W$4<=$C$4","Binding",0]
[null,"$W$11","G9 Total Awarded Capacity",1000,"$W$11<=$C$11","Binding",0]
[null,"$W$12","Power Balance Penalty Total Awarded Capacity",0,"$W$12<=$C$12","Not Binding",10000]
[null,"$W$3","Rest of System Total Awarded Capacity",50000,"$W$3<=$C$3","Binding",0]
[null,"$W$7","G5 Total Awarded Capacity",1000,"$W$7<=$C$7","Binding",0]
[null,"$W$10","G8 Total Awarded Capacity",1000,"$W$10<=$C$10","Binding",0]
[null,"$T$28","SOR Awarded + Shortage Qty Solution Qty",3000,"$T$28=$B$19","Binding",0]
[null,"$O$28","RRS Awarded + Shortage Qty Solution Qty",2300,"$O$28=$B$18","Binding",0]
[null,"$E$13","Totals Awarded Qty",52000,"$E$13=$B$16","Binding",0]
[null,"$J$28","URS Awarded + Shortage Qty Solution Qty",270,"$J$28=$B$17","Binding",0]
[null,"$J$6","G4 Awarded Qty",50,"$J$6<=$H$6","Binding",0]
[null,"$J$22","Solution Qty",0,"$J$22<=$H$22","Not Binding",15]
[null,"$J$8","G6 Awarded Qty",50,"$J$8<=$H$8","Binding",0]
[null,"$O$10","G8 Awarded Qty",300,"$O$10<=$M$10","Not Binding",200]
[null,"$J$19","SOR Requirement Solution Qty",0,"$J$19<=$H$19","Not Binding",10]
[null,"$O$11","G9 Awarded Qty",0,"$O$11<=$M$11","Binding",0]
[null,"$O$12","Power Balance Penalty Awarded Qty",0,"$O$12<=$M$12","Binding",0]
[null,"$O$5","G3 Awarded Qty",0,"$O$5<=$M$5","Not Binding",500]
[null,"$O$3","Rest of System Awarded Qty",0,"$O$3<=$M$3","Not Binding",500]
[null,"$O$4","G2 Awarded Qty",0,"$O$4<=$M$4","Not Binding",500]
[null,"$T$6","G4 Awarded Qty",430,"$T$6<=$R$6","Not Binding",570]
[null,"$T$8","G6 Awarded Qty",450,"$T$8<=$R$8","Not Binding",550]
[null,"$T$9","G7 Awarded Qty",20,"$T$9<=$R$9","Not Binding",980]
[null,"$T$7","G5 Awarded Qty",450,"$T$7<=$R$7","Not Binding",550]
[null,"$O$6","G4 Awarded Qty",500,"$O$6<=$M$6","Binding",0]
[null,"$T$21","Objective Function Solution Qty",0,"$T$21<=$R$21","Not Binding",375]
[null,"$T$3","Rest of System Awarded Qty",0,"$T$3<=$R$3","Not Binding",50000]
[null,"$T$5","G3 Awarded Qty",0,"$T$5<=$R$5","Not Binding",1000]
[null,"$T$24","Energy Solution Qty",0,"$T$24<=$R$24","Not Binding",375]
[null,"$T$4","G2 Awarded Qty",0,"$T$4<=$R$4","Not Binding",1000]
[null,"$T$25","URS Solution Qty",0,"$T$25<=$R$25","Not Binding",375]
[null,"$T$22","Solution Qty",0,"$T$22<=$R$22","Not Binding",375]
[null,"$T$23","Output Prices Solution Qty",0,"$T$23<=$R$23","Not Binding",375]
[null,"$T$20","Solution Qty",0,"$T$20<=$R$20","Not Binding",375]
[null,"$T$12","Power Balance Penalty Awarded Qty",0,"$T$12<=$R$12","Binding",0]
[null,"$T$18","RRS Requirement Solution Qty",0,"$T$18<=$R$18","Not Binding",375.000001]
[null,"$T$19","SOR Requirement Solution Qty",0,"$T$19<=$R$19","Not Binding",375]
[null,"$O$20","Solution Qty",0,"$O$20<=$M$20","Not Binding",100]
[null,"$O$8","G6 Awarded Qty",500,"$O$8<=$M$8","Binding",0]
[null,"$O$9","G7 Awarded Qty",500,"$O$9<=$M$9","Binding",0]
[null,"$O$25","URS Solution Qty",0,"$O$25<=$M$25","Not Binding",50]
[null,"$O$7","G5 Awarded Qty",500,"$O$7<=$M$7","Binding",0]
[null,"$T$10","G8 Awarded Qty",650,"$T$10<=$R$10","Not Binding",350]
[null,"$T$11","G9 Awarded Qty",1000,"$T$11<=$R$11","Binding",0]
[null,"$O$24","Energy Solution Qty",0,"$O$24<=$M$24","Not Binding",55]
[null,"$O$23","Output Prices Solution Qty",0,"$O$23<=$M$23","Not Binding",55]
[null,"$O$22","Solution Qty",0,"$O$22<=$M$22","Not Binding",55]
[null,"$O$21","Objective Function Solution Qty",0,"$O$21<=$M$21","Not Binding",55]
[null,"$O$19","SOR Requirement Solution Qty",0,"$O$19<=$M$19","Not Binding",100]
[null,"$O$18","RRS Requirement Solution Qty",0,"$O$18<=$M$18","Not Binding",1830]
[null,"$J$9","G7 Awarded Qty",50,"$J$9<=$H$9","Binding",0]
[null,"$J$7","G5 Awarded Qty",50,"$J$7<=$H$7","Binding",0]
[null,"$J$5","G3 Awarded Qty",20,"$J$5<=$H$5","Not Binding",30]
[null,"$J$24","Energy Solution Qty",0,"$J$24<=$H$24","Not Binding",15]
[null,"$J$4","G2 Awarded Qty",0,"$J$4<=$H$4","Not Binding",50]
[null,"$J$3","Rest of System Awarded Qty",0,"$J$3<=$H$3","Not Binding",50]
[null,"$E$5","G3 Awarded Qty",980,"$E$5<=$C$5","Not Binding",20]
[null,"$J$12","Power Balance Penalty Awarded Qty",0,"$J$12<=$H$12","Binding",0]
[null,"$J$10","G8 Awarded Qty",50,"$J$10<=$H$10","Binding",0]
[null,"$E$8","G6 Awarded Qty",0,"$E$8<=$C$8","Not Binding",1000]
[null,"$E$6","G4 Awarded Qty",20,"$E$6<=$C$6","Not Binding",980]
[null,"$E$9","G7 Awarded Qty",0,"$E$9<=$C$9","Not Binding",1000]
[null,"$J$18","RRS Requirement Solution Qty",0,"$J$18<=$H$18","Not Binding",170]
[null,"$J$11","G9 Awarded Qty",0,"$J$11<=$H$11","Binding",0]
[null,"$J$20","Solution Qty",0,"$J$20<=$H$20","Not Binding",15]
[null,"$J$21","Objective Function Solution Qty",0,"$J$21<=$H$21","Not Binding",15]
[null,"$E$7","G5 Awarded Qty",0,"$E$7<=$C$7","Not Binding",1000]
[null,"$J$25","URS Solution Qty",0,"$J$25<=$H$25","Not Binding",15]
[null,"$J$23","Output Prices Solution Qty",0,"$J$23<=$H$23","Not Binding",15]
[null,"$E$4","G2 Awarded Qty",1000,"$E$4<=$C$4","Binding",0]
[null,"$E$10","G8 Awarded Qty",0,"$E$10<=$C$10","Not Binding",1000]
[null,"$E$12","Power Balance Penalty Awarded Qty",0,"$E$12<=$C$12","Not Binding",10000]
[null,"$E$11","G9 Awarded Qty",0,"$E$11<=$C$11","Not Binding",1000]
[null,"$E$3","Rest of System Awarded Qty",50000,"$E$3<=$C$3","Binding",0]

{"sheet":"Sensitivity Report","index":5,"n_rows":90,"n_cols":8,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 15.0 Sensitivity Report"]
["Worksheet: [RT Co-Optimization_Scenario v3.xlsm]Optimization Engine"]
["Report Created: 6/28/2017 10:57:21 AM"]
[]
[]
["Variable Cells"]
[null,null,null,"Final","Reduced","Objective","Allowable","Allowable"]
[null,"Cell","Name","Value","Cost","Coefficient","Increase","Decrease"]
[null,"$E$3","Rest of System Awarded Qty",50000,-10,25,10,1E+30]
[null,"$E$4","G2 Awarded Qty",1000,0,30,5,1E+30]
[null,"$E$5","G3 Awarded Qty",980,0,35,5,5]
[null,"$E$6","G4 Awarded Qty",20,0,40,5,5]
[null,"$E$7","G5 Awarded Qty",0,5,45,1E+30,5]
[null,"$E$8","G6 Awarded Qty",0,10,50,1E+30,10]
[null,"$E$9","G7 Awarded Qty",0,15,55,1E+30,15]
[null,"$E$10","G8 Awarded Qty",0,20,60,1E+30,20]
[null,"$E$11","G9 Awarded Qty",0,760,800,1E+30,760]
[null,"$E$12","Power Balance Penalty Awarded Qty",0,8961,9001,1E+30,8961]
[null,"$J$3","Rest of System Awarded Qty",0,0,0,5,10]
[null,"$J$4","G2 Awarded Qty",0,5,0,1E+30,5]
[null,"$J$5","G3 Awarded Qty",20,0,0,5,5]
[null,"$J$6","G4 Awarded Qty",50,-5,0,5,1E+30]
[null,"$J$7","G5 Awarded Qty",50,-5,0,5,1E+30]
[null,"$J$8","G6 Awarded Qty",50,-5,0,5,1E+30]
[null,"$J$9","G7 Awarded Qty",50,-5,0,5,1E+30]
[null,"$J$10","G8 Awarded Qty",50,-5,0,5,1E+30]
[null,"$J$11","G9 Awarded Qty",0,-5,0,1E+30,5]
[null,"$J$12","Power Balance Penalty Awarded Qty",0,-5,0,1E+30,5]
[null,"$O$3","Rest of System Awarded Qty",0,5,0,1E+30,5]
[null,"$O$4","G2 Awarded Qty",0,10,0,1E+30,10]
[null,"$O$5","G3 Awarded Qty",0,5,0,1E+30,5]
[null,"$O$6","G4 Awarded Qty",500,0,0,0,1E+30]
[null,"$O$7","G5 Awarded Qty",500,0,0,0,1E+30]
[null,"$O$8","G6 Awarded Qty",500,0,0,0,1E+30]
[null,"$O$9","G7 Awarded Qty",500,0,0,0,1E+30]
[null,"$O$10","G8 Awarded Qty",300,0,0,0,0]
[null,"$O$11","G9 Awarded Qty",0,0,0,1E+30,0]
[null,"$O$12","Power Balance Penalty Awarded Qty",0,0,0,1E+30,0]
[null,"$T$3","Rest of System Awarded Qty",0,5,0,1E+30,5]
[null,"$T$4","G2 Awarded Qty",0,10,0,1E+30,10]
[null,"$T$5","G3 Awarded Qty",0,5,0,1E+30,5]
[null,"$T$6","G4 Awarded Qty",430,0,0,0,0]
[null,"$T$7","G5 Awarded Qty",450,0,0,0,0]
[null,"$T$8","G6 Awarded Qty",450,0,0,0,0]
[null,"$T$9","G7 Awarded Qty",20,0,0,0,0]
[null,"$T$10","G8 Awarded Qty",650,0,0,0,0]
[null,"$T$11","G9 Awarded Qty",1000,0,0,0,1E+30]
[null,"$T$12","Power Balance Penalty Awarded Qty",0,0,0,1E+30,0]
[null,"$J$18","RRS Requirement Solution Qty",0,6995.989999999998,7000.989999999998,1E+30,6995.989999999998]
[null,"$J$19","SOR Requirement Solution Qty",0,4495,4500,1E+30,4495]
[null,"$J$20","Solution Qty",0,3495,3500,1E+30,3495]
[null,"$J$21","Objective Function Solution Qty",0,2495,2500,1E+30,2495]
[null,"$J$22","Solution Qty",0,1495,1500,1E+30,1495]
[null,"$J$23","Output Prices Solution Qty",0,995,1000,1E+30,995]
[null,"$J$24","Energy Solution Qty",0,495,500,1E+30,495]
[null,"$J$25","URS Solution Qty",0,245,250,1E+30,245]
[null,"$O$18","RRS Requirement Solution Qty",0,7000.989999999998,7000.989999999998,1E+30,7000.989999999998]
[null,"$O$19","SOR Requirement Solution Qty",0,4500,4500,1E+30,4500]
[null,"$O$20","Solution Qty",0,3500,3500,1E+30,3500]
[null,"$O$21","Objective Function Solution Qty",0,2500,2500,1E+30,2500]
[null,"$O$22","Solution Qty",0,1500,1500,1E+30,1500]
[null,"$O$23","Output Prices Solution Qty",0,1000,1000,1E+30,1000]
[null,"$O$24","Energy Solution Qty",0,500,500,1E+30,500]
[null,"$O$25","URS Solution Qty",0,250,250,1E+30,250]
[null,"$T$18","RRS Requirement Solution Qty",0,1425,1425,1E+30,1425]
[null,"$T$19","SOR Requirement Solution Qty",0,422,422,1E+30,422]
[null,"$T$20","Solution Qty",0,139,139,1E+30,139]
[null,"$T$21","Objective Function Solution Qty",0,46,46,1E+30,46]
[null,"$T$22","Solution Qty",0,13,13,1E+30,13]
[null,"$T$23","Output Prices Solution Qty",0,3,3,1E+30,3]
[null,"$T$24","Energy Solution Qty",0,0.59999999999854481,0.59999999999854481,1E+30,0.59999999999854481]
[null,"$T$25","URS Solution Qty",0,9.9999999998544808E-2,9.9999999998544808E-2,1E+30,9.9999999998544808E-2]
[]
["Constraints"]
[null,null,null,"Final","Shadow","Constraint","Allowable","Allowable"]
[null,"Cell","Name","Value","Price","R.H. Side","Increase","Decrease"]
[null,"$W$8","G6 Total Awarded Capacity",1000,0,1000,20,430]
[null,"$W$5","G3 Total Awarded Capacity",1000,-5,1000,20,430]
[null,"$W$6","G4 Total Awarded Capacity",1000,0,1000,20,430]
[null,"$W$9","G7 Total Awarded Capacity",570,0,1000,1E+30,430]
[null,"$W$4","G2 Total Awarded Capacity",1000,-10,1000,0,430]
[null,"$W$11","G9 Total Awarded Capacity",1000,0,1000,1E+30,0]
[null,"$W$12","Power Balance Penalty Total Awarded Capacity",0,0,10000,1E+30,10000]
[null,"$W$3","Rest of System Total Awarded Capacity",50000,-5,50000,20,0]
[null,"$W$7","G5 Total Awarded Capacity",1000,0,1000,20,430]
[null,"$W$10","G8 Total Awarded Capacity",1000,0,1000,20,430]
[null,"$T$28","SOR Awarded + Shortage Qty Solution Qty",3000,0,3000,430,20]
[null,"$O$28","RRS Awarded + Shortage Qty Solution Qty",2300,0,2300,200,20]
[null,"$E$13","Totals Awarded Qty",52000,40,52000,430,20]
[null,"$J$28","URS Awarded + Shortage Qty Solution Qty",270,5,270,30,20]