{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Instructions","Input and results","Calculations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":59,"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":"Cover","index":0,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,1,3,2],[7,1,7,4]]}
[]
[null,"AEC"]
[null,"Capacity Market Model"]
[null,"2022-09-14",null,"Version 1.0","Fianl"]
[]
[null,"Accompanying report:",null,null,"CEPA_AEC_FinalReport"]
[]
[]
[]
[null,"Disclaimers"]
[]
[]
[]
[null,"Version history"]
[]
[null,"Version","Date","Author","Description of changes"]
[null,"0.1","2022-08-31","Jacob","Draft Model"]
[null,"0.11","2022-09-02","Jacob","Updated Draft"]
[null,"1.0","2022-09-13","Jacob","Final Model"]
[]
[]
[]
[]
[null,"Contents",null,null,null,null,"Notes and assumptions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Format key"]
[]
[null,null,null,"Cell intentionally blank"]
[null,"Value",null,"Model outputs"]
[null,"Value",null,"Hardcoded input"]
[null,"Value",null,"User input"]
[null,"Value",null,"Calculation"]
[null,"Value",null,"Unique formula"]
[null,"Value",null,"Value from another worksheet"]
[null,"Value",null,"Formula change compared to base case scenario"]
[null,"Value",null,"Annotation"]
[null,"Sheet colour",null,"Information sheet"]
[null,"Sheet colour",null,"Input sheet"]
[null,"Sheet colour",null,"Calculation sheet"]
[null,"Sheet colour",null,"Output sheet"]

{"sheet":"Instructions","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[]
[null,"Please enable macros and ensure calculations are set to automically update"]
[]
[null,"The 'inputs and results' sheet contains various cells where the inputs can be changed, These are coded in blue and red as shown in the key on the cover sheet"]
[]
[null,"Input the desired demand forecasts, generator characteristics, market price cap and target unserved energy"]
[]
[null,"Ensure MPC is set above generators marginal costs and the highest demand periods occur with lower probability"]
[]
[null,"Press the button called 'click here after updating inputs'"]
[]
[null,"Excel will then attempt to find a combination of generator capcity which minimises total costs in the system subject to the desired level of unserved energy"]
[]
[null,"The results including revenue and profits to each generator are then displayed in the 'inputs and results'"]
[]
[null,"Limitations"]
[]
[null,"There are limitations to excel solver, in particular when solving for many decimal points and small changes which can occur when finding a solution during low probability high demand dispatch intervals."]
[]
[null,"These limitations do not impact our conclusions for the main purpose of the model which is to illustrate how revenues move between the energy market and capacity market."]

{"sheet":"Input and results","index":2,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,3,6,4]]}
[]
[null,"Inputs and Results"]
[]
[null,"Inputs"]
[]
[]
[null,"Market price cap ($/MWh)",15500,{"$f":"IF(C7<MAX(C24:C29), \"ERROR: MPC less than generator variable costs\",\"\")","v":""}]
[null,null,"Ensure Market price cap > marginal cost of the generators"]
[null,"Target unserved energy (%)",2.0000000000000002E-5]
[]
[null,"Demand forecasts"]
[]
[null,null,"Interval 1","Interval 2","Interval 3","Interval 4","Interval 5","Interval 6"]
[null,"Probability (%)",1,1,0.999,0.999,0.999,0.999]
[null,"Demand (MWh)",3000,10000,10000,8000,5000,11000]
[null,"Probability (%)",{"$f":"1-C14","v":0},{"$f":"1-D14","v":0},1.0000000000000009E-3,1.0000000000000009E-3,1.0000000000000009E-3,1.0000000000000009E-3]
[null,"Demand (MWh)",4000,15000,16000,16000,16000,16000]
[]
[null,"Probability check",{"$f":"C14+C16","v":1},1,1,1,1,1]
[]
[null,"Generator Inputs"]
[]
[null,null,"Variable costs ($/MWh)","Expansions costs ($/MW)","Current Capacity (MW)"]
[null,"Generator 1",5,30000,4500]
[null,"Generator 2",50,25000,4500]
[null,"Generator 3",100,30000,4500]
[null,"Generator 4",5,22000,0]
[null,"Generator 5",50,18000,0]
[null,"Generator 6",100,30000,0]
[]
[null,"Outputs"]
[]
[]
[]
[]
[]
[]
[]
[null,"Generator Outputs - listed in ascending order of variable costs"]
[]
[null,null,"Variable costs ($/MWh)","Expansions costs ($/MW)","Current Capacity (MW)","change in capacity (MW)","Total Capacity (MW)","Capacity Stack (MW)","Energy only revenue ($)","Energy only profit ($)","Cap market revenue ($)","Total profit ($)","Total revenue ($)","MPC"]
[null,{"$f":"Calculations!B17","v":"Generator 1"},{"$f":"Calculations!C17","v":5},{"$f":"Calculations!D17","v":30000},{"$f":"Calculations!E17","v":4500},{"$f":"Calculations!F17-Calculations!E17","v":0},{"$f":"Calculations!F17","v":4500},{"$f":"Calculations!P17","v":4500},{"$f":"Calculations!K17","v":1418100},{"$f":"Calculations!L17","v":1290600.0000000002},{"$f":"Calculations!N17","v":80721900},{"$f":"Calculations!O17","v":82012500},{"$f":"K42+I42","v":82140000}]
[null,{"$f":"Calculations!B18","v":"Generator 4"},{"$f":"Calculations!C18","v":5},{"$f":"Calculations!D18","v":22000},{"$f":"Calculations!E18","v":0},{"$f":"Calculations!F18-Calculations!E18","v":0},{"$f":"Calculations!F18","v":0},{"$f":"Calculations!P18","v":4500},{"$f":"Calculations!K18","v":0},{"$f":"Calculations!L18","v":0},{"$f":"Calculations!N18","v":0},{"$f":"Calculations!O18","v":0},{"$f":"K43+I43","v":0}]
[null,{"$f":"Calculations!B19","v":"Generator 5"},{"$f":"Calculations!C19","v":50},{"$f":"Calculations!D19","v":18000},{"$f":"Calculations!E19","v":0},{"$f":"Calculations!F19-Calculations!E19","v":2264.9},{"$f":"Calculations!F19","v":2264.9},{"$f":"Calculations!P19","v":6764.9},{"$f":"Calculations!K19","v":618039.06500000018},{"$f":"Calculations!L19","v":-40628229.18},{"$f":"Calculations!N19","v":40628229.18},{"$f":"Calculations!O19","v":0},{"$f":"K44+I44","v":41246268.244999997}]
[null,{"$f":"Calculations!B20","v":"Generator 2"},{"$f":"Calculations!C20","v":50},{"$f":"Calculations!D20","v":25000},{"$f":"Calculations!E20","v":4500},{"$f":"Calculations!F20-Calculations!E20","v":0},{"$f":"Calculations!F20","v":4500},{"$f":"Calculations!P20","v":11264.9},{"$f":"Calculations!K20","v":875584.73500000034},{"$f":"Calculations!L20","v":278100.00000000023},{"$f":"Calculations!N20","v":80721900},{"$f":"Calculations!O20","v":81000000},{"$f":"K45+I45","v":81597484.734999999}]
[null,{"$f":"Calculations!B21","v":"Generator 6"},{"$f":"Calculations!C21","v":100},{"$f":"Calculations!D21","v":30000},{"$f":"Calculations!E21","v":0},{"$f":"Calculations!F21-Calculations!E21","v":0},{"$f":"Calculations!F21","v":0},{"$f":"Calculations!P21","v":11264.9},{"$f":"Calculations!K21","v":0},{"$f":"Calculations!L21","v":0},{"$f":"Calculations!N21","v":0},{"$f":"Calculations!O21","v":0},{"$f":"K46+I46","v":0}]
[null,{"$f":"Calculations!B22","v":"Generator 3"},{"$f":"Calculations!C22","v":100},{"$f":"Calculations!D22","v":30000},{"$f":"Calculations!E22","v":4500},{"$f":"Calculations!F22-Calculations!E22","v":0},{"$f":"Calculations!F22","v":4500},{"$f":"Calculations!P22","v":15764.9},{"$f":"Calculations!K22","v":279000.00000000023},{"$f":"Calculations!L22","v":277200.00000000023},{"$f":"Calculations!N22","v":80721900},{"$f":"Calculations!O22","v":80999100},{"$f":"IF(K47+I47=\"\",\"\",K47+I47)","v":81000900}]
[null,"Totals",null,null,null,null,null,null,{"$f":"SUM(I42:I47)","v":3190723.8000000007},{"$f":"SUM(J42:J47)","v":-38782329.18},{"$f":"SUM(K42:K47)","v":282793929.18000001},{"$f":"SUM(L42:L47)","v":244011600},{"$f":"SUM(M42:M47)","v":285984652.98000002},{"$f":"C7","v":15500}]
[null,"Previous Total ",null,null,null,null,null,null,3190723.8000000007,-38782329.18,282793929.18000001,244011600,285984652.98000002,15500]
[null,"Difference",null,null,null,null,null,null,{"$f":"I49-I48","v":0},{"$f":"J49-J48","v":0},0,0,0,{"$f":"N49-N48","v":0}]

{"sheet":"Calculations","index":3,"n_rows":114,"n_cols":16,"rows_kept":114,"cut":false,"hidden":false,"merged":[[32,1,60,1],[61,1,89,1],[90,1,109,1],[30,3,30,8]]}
[]
[null,"Calculations"]
[]
[null,"Reorder generators by variable cost"]
[]
[null,"generator","Variable costs","Expansion costs","Capacity"]
[null,{"$f":"'Input and results'!B24","v":"Generator 1"},{"$f":"'Input and results'!C24","v":5},{"$f":"'Input and results'!D24","v":30000},{"$f":"'Input and results'!E24","v":4500}]
[null,{"$f":"'Input and results'!B27","v":"Generator 4"},{"$f":"'Input and results'!C27","v":5},{"$f":"'Input and results'!D27","v":22000},{"$f":"'Input and results'!E27","v":0}]
[null,{"$f":"'Input and results'!B28","v":"Generator 5"},{"$f":"'Input and results'!C28","v":50},{"$f":"'Input and results'!D28","v":18000},{"$f":"'Input and results'!E28","v":0}]
[null,{"$f":"'Input and results'!B25","v":"Generator 2"},{"$f":"'Input and results'!C25","v":50},{"$f":"'Input and results'!D25","v":25000},{"$f":"'Input and results'!E25","v":4500}]
[null,{"$f":"'Input and results'!B29","v":"Generator 6"},{"$f":"'Input and results'!C29","v":100},{"$f":"'Input and results'!D29","v":30000},{"$f":"'Input and results'!E29","v":0}]
[null,{"$f":"'Input and results'!B26","v":"Generator 3"},{"$f":"'Input and results'!C26","v":100},{"$f":"'Input and results'!D26","v":30000},{"$f":"'Input and results'!E26","v":4500}]
[]
[null,"Generator outputs"]
[]
[null,null,"Variable costs","Expansion costs","current capacity","optimal capacity","rounded capacity","Total variable costs","Total expansion costs","Total costs","Energy rev","Energy Profit","Capacity Offer","Capacity revenue","Total profit","Capacity Stack"]
[null,{"$f":"B7","v":"Generator 1"},5,30000,4500,4500,{"$f":"ROUND(F17,1)","v":4500},{"$f":"J99","v":127500},{"$f":"IF(F17>E17,(F17-E17)*D17,0)","v":0},{"$f":"H17+I17","v":127500},{"$f":"J93","v":1418100},{"$f":"J105-I17","v":1290600.0000000002},{"$f":"IFERROR(-MIN(L17/F17,0),0)","v":0},{"$f":"$C$27*F17","v":80721900},{"$f":"L17+N17","v":82012500},{"$f":"SUM($F$17:F17)","v":4500}]
[null,"Generator 4",5,22000,0,0,{"$f":"ROUND(F18,1)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM($F$17:F18)","v":4500}]
[null,"Generator 5",50,18000,0,2264.9,2264.9,478068.245,40768200,41246268.244999997,618039.06500000018,-40628229.18,17938.2,40628229.18,0,{"$f":"SUM($F$17:F19)","v":6764.9}]
[null,"Generator 2",50,25000,4500,4500,4500,597484.7350000001,0,597484.7350000001,875584.73500000034,278100.00000000023,0,80721900,81000000,{"$f":"SUM($F$17:F20)","v":11264.9}]
[null,"Generator 6",100,30000,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($F$17:F21)","v":11264.9}]
[null,"Generator 3",100,30000,4500,4500,4500,1800.0000000000016,0,1800.0000000000016,279000.00000000023,277200.00000000023,0,80721900,80999100,{"$f":"SUM($F$17:F22)","v":15764.9}]
[]
[null,"Total current Capacity",{"$f":"SUM(E17:E22)","v":13500}]
[null,"Optimal level of capacity",{"$f":"SUM(F17:F22)","v":15764.9}]
[null,"Total costs",{"$f":"SUM(J17:J22)","v":41973052.979999997}]
[null,"Capacity price",{"$f":"MAX(M17:M22)","v":17938.2}]
[null,"Target unserved",{"$f":"'Input and results'!C9*100000","v":2}]
[null,"unserved energy",{"$f":"(J92/J91)*100000","v":1.9995747395279659}]
[]
[]
[null,null,null,"Interval 1","Interval 2","Interval 3","Interval 4","Interval 5","Interval 6","Total"]
[null,"Forecast 1","Probability (%)",{"$f":"'Input and results'!$C$14","v":1},{"$f":"'Input and results'!$D$14","v":1},{"$f":"'Input and results'!$E$14","v":0.999},{"$f":"'Input and results'!$F$14","v":0.999},{"$f":"'Input and results'!$G$14","v":0.999},{"$f":"'Input and results'!$H$14","v":0.999},"NA"]
[null,null,"Demand (MWh)",{"$f":"'Input and results'!$C$15","v":3000},{"$f":"'Input and results'!$D$15","v":10000},{"$f":"'Input and results'!$E$15","v":10000},{"$f":"'Input and results'!$F$15","v":8000},{"$f":"'Input and results'!$G$15","v":5000},{"$f":"'Input and results'!$H$15","v":11000},{"$f":"SUM(D34:I34)","v":47000}]
[null,null,"Energy price ($/MWh)",{"$f":"MIN(IF(D$34<=$P$17,$C$17,IF(D$34<=$P$18,$C$18,IF(D$34<=$P$19,$C$19,IF(D$34<=$P$20,$C$20,IF(D$34<=$P$21,$C$21,IF(D$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":5},{"$f":"MIN(IF(E$34<=$P$17,$C$17,IF(E$34<=$P$18,$C$18,IF(E$34<=$P$19,$C$19,IF(E$34<=$P$20,$C$20,IF(E$34<=$P$21,$C$21,IF(E$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":50},{"$f":"MIN(IF(F$34<=$P$17,$C$17,IF(F$34<=$P$18,$C$18,IF(F$34<=$P$19,$C$19,IF(F$34<=$P$20,$C$20,IF(F$34<=$P$21,$C$21,IF(F$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":50},{"$f":"MIN(IF(G$34<=$P$17,$C$17,IF(G$34<=$P$18,$C$18,IF(G$34<=$P$19,$C$19,IF(G$34<=$P$20,$C$20,IF(G$34<=$P$21,$C$21,IF(G$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":50},{"$f":"MIN(IF(H$34<=$P$17,$C$17,IF(H$34<=$P$18,$C$18,IF(H$34<=$P$19,$C$19,IF(H$34<=$P$20,$C$20,IF(H$34<=$P$21,$C$21,IF(H$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":50},{"$f":"MIN(IF(I$34<=$P$17,$C$17,IF(I$34<=$P$18,$C$18,IF(I$34<=$P$19,$C$19,IF(I$34<=$P$20,$C$20,IF(I$34<=$P$21,$C$21,IF(I$34<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":50},"NA"]
[null,null,"Served demand (MWh)",{"$f":"SUM(D38:D43)","v":3000},{"$f":"SUM(E38:E43)","v":10000},10000,8000,5000,11000,{"$f":"SUM(D36:I36)","v":47000}]
[null,null,"Unserved energy (MWh)",{"$f":"D34-D36","v":0},0,0,0,0,0,0]
[null,null,"G1 quantity (MWh)",{"$f":"IF(D34>=$F$17,$F$17,D34)","v":3000},{"$f":"IF(E34>=$F$17,$F$17,E34)","v":4500},4500,4500,4500,4500,{"$f":"SUM(D38:I38)","v":25500}]
[null,null,"G2 quantity (MWh)",{"$f":"IF(D$34>=$P18,$F18,D$34-SUM(D$38:D38))","v":0},{"$f":"IF(E$34>=$P18,$F18,E$34-SUM(E$38:E38))","v":0},{"$f":"IF(F$34>=$P18,$F18,F$34-SUM(F$38:F38))","v":0},{"$f":"IF(G$34>=$P18,$F18,G$34-SUM(G$38:G38))","v":0},{"$f":"IF(H$34>=$P18,$F18,H$34-SUM(H$38:H38))","v":0},{"$f":"IF(I$34>=$P18,$F18,I$34-SUM(I$38:I38))","v":0},0]
[null,null,"G3 quantity (MWh)",{"$f":"IF(D$34>=$P19,$F19,D$34-SUM(D$38:D39))","v":0},{"$f":"IF(E$34>=$P19,$F19,E$34-SUM(E$38:E39))","v":2264.9},{"$f":"IF(F$34>=$P19,$F19,F$34-SUM(F$38:F39))","v":2264.9},{"$f":"IF(G$34>=$P19,$F19,G$34-SUM(G$38:G39))","v":2264.9},{"$f":"IF(H$34>=$P19,$F19,H$34-SUM(H$38:H39))","v":500},{"$f":"IF(I$34>=$P19,$F19,I$34-SUM(I$38:I39))","v":2264.9},9559.6]
[null,null,"G4 quantity (MWh)",{"$f":"IF(D$34>=$P20,$F20,D$34-SUM(D$38:D40))","v":0},{"$f":"IF(E$34>=$P20,$F20,E$34-SUM(E$38:E40))","v":3235.1000000000004},{"$f":"IF(F$34>=$P20,$F20,F$34-SUM(F$38:F40))","v":3235.1000000000004},{"$f":"IF(G$34>=$P20,$F20,G$34-SUM(G$38:G40))","v":1235.1000000000004},{"$f":"IF(H$34>=$P20,$F20,H$34-SUM(H$38:H40))","v":0},{"$f":"IF(I$34>=$P20,$F20,I$34-SUM(I$38:I40))","v":4235.1000000000004},11940.400000000001]
[null,null,"G5 quantity (MWh)",{"$f":"IF(D$34>=$P21,$F21,D$34-SUM(D$38:D41))","v":0},{"$f":"IF(E$34>=$P21,$F21,E$34-SUM(E$38:E41))","v":0},{"$f":"IF(F$34>=$P21,$F21,F$34-SUM(F$38:F41))","v":0},{"$f":"IF(G$34>=$P21,$F21,G$34-SUM(G$38:G41))","v":0},{"$f":"IF(H$34>=$P21,$F21,H$34-SUM(H$38:H41))","v":0},{"$f":"IF(I$34>=$P21,$F21,I$34-SUM(I$38:I41))","v":0},0]
[null,null,"G6 quantity (MWh)",{"$f":"IF(D$34>=$P22,$F22,D$34-SUM(D$38:D42))","v":0},{"$f":"IF(E$34>=$P22,$F22,E$34-SUM(E$38:E42))","v":0},{"$f":"IF(F$34>=$P22,$F22,F$34-SUM(F$38:F42))","v":0},{"$f":"IF(G$34>=$P22,$F22,G$34-SUM(G$38:G42))","v":0},{"$f":"IF(H$34>=$P22,$F22,H$34-SUM(H$38:H42))","v":0},{"$f":"IF(I$34>=$P22,$F22,I$34-SUM(I$38:I42))","v":0},0]
[null,null,"G1 revenue ($)",{"$f":"D38*D$35","v":15000},{"$f":"E38*E$35","v":225000},225000,225000,225000,225000,{"$f":"SUM(D44:I44)","v":1140000}]
[null,null,"G2 revenue ($)",{"$f":"D39*D$35","v":0},0,0,0,0,0,{"$f":"SUM(D45:I45)","v":0}]
[null,null,"G3 revenue ($)",0,113245,113245,113245,25000,113245,477980]
[null,null,"G4 revenue ($)",0,161755.00000000003,161755.00000000003,61755.000000000015,0,211755.00000000003,597020.00000000012]
[null,null,"G5 revenue ($)",0,0,0,0,0,0,0]
[null,null,"G6 revenue ($)",0,0,0,0,0,0,0]
[null,null,"G1 variable costs ($)",{"$f":"D38*$C7","v":15000},22500,22500,22500,22500,22500,{"$f":"SUM(D50:I50)","v":127500}]
[null,null,"G2 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G3 variable costs ($)",0,113245,113245,113245,25000,113245,477980]
[null,null,"G4 variable costs ($)",0,161755.00000000003,161755.00000000003,61755.000000000015,0,211755.00000000003,597020.00000000012]
[null,null,"G5 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G6 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G1 variable profit ($)",{"$f":"D44-D50","v":0},202500,202500,202500,202500,202500,1012500]
[null,null,"G2 variable profit ($)",{"$f":"D45-D51","v":0},0,0,0,0,0,0]
[null,null,"G3 variable profit ($)",{"$f":"D46-D52","v":0},{"$f":"E46-E52","v":0},0,0,0,0,0]
[null,null,"G4 variable profit ($)",{"$f":"D47-D53","v":0},0,0,0,0,0,0]
[null,null,"G5 variable profit ($)",{"$f":"D48-D54","v":0},0,0,0,0,0,0]
[null,null,"G6 variable profit ($)",{"$f":"D49-D55","v":0},0,0,0,0,0,0]
[null,"Forecast 2","Probability (%)",{"$f":"'Input and results'!$C$16","v":0},{"$f":"'Input and results'!$D$16","v":0},{"$f":"'Input and results'!$E$16","v":1.0000000000000009E-3},{"$f":"'Input and results'!$F$16","v":1.0000000000000009E-3},{"$f":"'Input and results'!$G$16","v":1.0000000000000009E-3},{"$f":"'Input and results'!$H$16","v":1.0000000000000009E-3},"NA"]
[null,null,"Demand (MWh)",{"$f":"'Input and results'!$C$17","v":4000},{"$f":"'Input and results'!$D$17","v":15000},{"$f":"'Input and results'!$E$17","v":16000},{"$f":"'Input and results'!$F$17","v":16000},{"$f":"'Input and results'!$G$17","v":16000},{"$f":"'Input and results'!$H$17","v":16000},{"$f":"SUM(D63:I63)","v":83000}]
[null,null,"Energy price ($/MWh)",{"$f":"MIN(IF(D$63<=$P$17,$C$17,IF(D$63<=$P$18,$C$18,IF(D$63<=$P$19,$C$19,IF(D$63<=$P$20,$C$20,IF(D$63<=$P$21,$C$21,IF(D$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":5},{"$f":"MIN(IF(E$63<=$P$17,$C$17,IF(E$63<=$P$18,$C$18,IF(E$63<=$P$19,$C$19,IF(E$63<=$P$20,$C$20,IF(E$63<=$P$21,$C$21,IF(E$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":100},{"$f":"MIN(IF(F$63<=$P$17,$C$17,IF(F$63<=$P$18,$C$18,IF(F$63<=$P$19,$C$19,IF(F$63<=$P$20,$C$20,IF(F$63<=$P$21,$C$21,IF(F$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":15500},{"$f":"MIN(IF(G$63<=$P$17,$C$17,IF(G$63<=$P$18,$C$18,IF(G$63<=$P$19,$C$19,IF(G$63<=$P$20,$C$20,IF(G$63<=$P$21,$C$21,IF(G$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":15500},{"$f":"MIN(IF(H$63<=$P$17,$C$17,IF(H$63<=$P$18,$C$18,IF(H$63<=$P$19,$C$19,IF(H$63<=$P$20,$C$20,IF(H$63<=$P$21,$C$21,IF(H$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":15500},{"$f":"MIN(IF(I$63<=$P$17,$C$17,IF(I$63<=$P$18,$C$18,IF(I$63<=$P$19,$C$19,IF(I$63<=$P$20,$C$20,IF(I$63<=$P$21,$C$21,IF(I$63<=$P$22,$C$22,'Input and results'!$C$7)))))),'Input and results'!$C$7)","v":15500},"NA"]
[null,null,"Served demand (MWh)",{"$f":"SUM(D67:D72)","v":4000},{"$f":"SUM(E67:E72)","v":15000},15764.9,15764.9,15764.9,15764.9,{"$f":"SUM(D65:I65)","v":82059.599999999991}]
[null,null,"Unserved energy (MWh)",{"$f":"D63-D65","v":0},0,235.10000000000036,235.10000000000036,235.10000000000036,235.10000000000036,940.40000000000873]
[null,null,"G1 quantity (MWh)",{"$f":"IF(D63>=$F$17,$F$17,D63)","v":4000},{"$f":"IF(E63>=$F$17,$F$17,E63)","v":4500},4500,4500,4500,4500,{"$f":"SUM(D67:I67)","v":26500}]
[null,null,"G2 quantity (MWh)",{"$f":"IF(D$63>=$P18,$F18,D$63-SUM(D$67:D67))","v":0},{"$f":"IF(E$63>=$P18,$F18,E$63-SUM(E$67:E67))","v":0},{"$f":"IF(F$63>=$P18,$F18,F$63-SUM(F$67:F67))","v":0},{"$f":"IF(G$63>=$P18,$F18,G$63-SUM(G$67:G67))","v":0},{"$f":"IF(H$63>=$P18,$F18,H$63-SUM(H$67:H67))","v":0},{"$f":"IF(I$63>=$P18,$F18,I$63-SUM(I$67:I67))","v":0},0]
[null,null,"G3 quantity (MWh)",{"$f":"IF(D$63>=$P19,$F19,D$63-SUM(D$67:D68))","v":0},{"$f":"IF(E$63>=$P19,$F19,E$63-SUM(E$67:E68))","v":2264.9},{"$f":"IF(F$63>=$P19,$F19,F$63-SUM(F$67:F68))","v":2264.9},{"$f":"IF(G$63>=$P19,$F19,G$63-SUM(G$67:G68))","v":2264.9},{"$f":"IF(H$63>=$P19,$F19,H$63-SUM(H$67:H68))","v":2264.9},{"$f":"IF(I$63>=$P19,$F19,I$63-SUM(I$67:I68))","v":2264.9},11324.5]
[null,null,"G4 quantity (MWh)",{"$f":"IF(D$63>=$P20,$F20,D$63-SUM(D$67:D69))","v":0},{"$f":"IF(E$63>=$P20,$F20,E$63-SUM(E$67:E69))","v":4500},{"$f":"IF(F$63>=$P20,$F20,F$63-SUM(F$67:F69))","v":4500},{"$f":"IF(G$63>=$P20,$F20,G$63-SUM(G$67:G69))","v":4500},{"$f":"IF(H$63>=$P20,$F20,H$63-SUM(H$67:H69))","v":4500},{"$f":"IF(I$63>=$P20,$F20,I$63-SUM(I$67:I69))","v":4500},22500]
[null,null,"G5 quantity (MWh)",{"$f":"IF(D$63>=$P21,$F21,D$63-SUM(D$67:D70))","v":0},{"$f":"IF(E$63>=$P21,$F21,E$63-SUM(E$67:E70))","v":0},{"$f":"IF(F$63>=$P21,$F21,F$63-SUM(F$67:F70))","v":0},{"$f":"IF(G$63>=$P21,$F21,G$63-SUM(G$67:G70))","v":0},{"$f":"IF(H$63>=$P21,$F21,H$63-SUM(H$67:H70))","v":0},{"$f":"IF(I$63>=$P21,$F21,I$63-SUM(I$67:I70))","v":0},0]
[null,null,"G6 quantity (MWh)",{"$f":"IF(D$63>=$P22,$F22,D$63-SUM(D$67:D71))","v":0},{"$f":"IF(E$63>=$P22,$F22,E$63-SUM(E$67:E71))","v":3735.1000000000004},{"$f":"IF(F$63>=$P22,$F22,F$63-SUM(F$67:F71))","v":4500},{"$f":"IF(G$63>=$P22,$F22,G$63-SUM(G$67:G71))","v":4500},{"$f":"IF(H$63>=$P22,$F22,H$63-SUM(H$67:H71))","v":4500},{"$f":"IF(I$63>=$P22,$F22,I$63-SUM(I$67:I71))","v":4500},21735.1]
[null,null,"G1 revenue ($)",{"$f":"D67*D$64","v":20000},{"$f":"E67*E$64","v":450000},69750000,69750000,69750000,69750000,279470000]
[null,null,"G2 revenue ($)",{"$f":"D68*D$64","v":0},0,0,0,0,0,0]
[null,null,"G3 revenue ($)",0,226490,35105950,35105950,35105950,35105950,140650290]
[null,null,"G4 revenue ($)",0,450000,69750000,69750000,69750000,69750000,279450000]
[null,null,"G5 revenue ($)",0,0,0,0,0,0,0]
[null,null,"G6 revenue ($)",0,373510.00000000006,69750000,69750000,69750000,69750000,279373510]
[null,null,"G1 variable costs ($)",{"$f":"D67*$C17","v":20000},22500,22500,22500,22500,22500,132500]
[null,null,"G2 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G3 variable costs ($)",0,113245,113245,113245,113245,113245,566225]
[null,null,"G4 variable costs ($)",0,225000,225000,225000,225000,225000,1125000]
[null,null,"G5 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G6 variable costs ($)",0,373510.00000000006,450000,450000,450000,450000,2173510]
[null,null,"G1 variable profit ($)",{"$f":"D73-D79","v":0},{"$f":"E73-E79","v":427500},69727500,69727500,69727500,69727500,279337500]
[null,null,"G2 variable profit ($)",{"$f":"D74-D80","v":0},0,0,0,0,0,0]
[null,null,"G3 variable profit ($)",{"$f":"D75-D81","v":0},113245,34992705,34992705,34992705,34992705,140084065]
[null,null,"G4 variable profit ($)",{"$f":"D76-D82","v":0},225000,69525000,69525000,69525000,69525000,278325000]
[null,null,"G5 variable profit ($)",{"$f":"D77-D83","v":0},0,0,0,0,0,0]
[null,null,"G6 variable profit ($)",{"$f":"D78-D84","v":0},0,69300000,69300000,69300000,69300000,277200000]
[null,"Prob weighted average","Demand (MWh)",{"$f":"D$33*D34+D$62*D63","v":3000},10000,10006,8008,5011,11005,47030]
[null,null,"Unserved energy (MWh)",{"$f":"D$33*D37+D$62*D66","v":0},0,0.23510000000000059,0.23510000000000059,0.23510000000000059,0.23510000000000059,0.94040000000000235]
[null,null,"G1 revenue ($)",{"$f":"D$33*D44+D$62*D73","v":15000},225000,294525.00000000006,294525.00000000006,294525.00000000006,294525.00000000006,1418100]
[null,null,"G2 revenue ($)",0,0,0,0,0,0,0]
[null,null,"G3 revenue ($)",0,113245,148237.70500000005,148237.70500000005,60080.950000000033,148237.70500000005,618039.06500000018]
[null,null,"G4 revenue ($)",0,161755.00000000003,231343.24500000008,131443.24500000008,69750.000000000058,281293.24500000011,875584.73500000034]
[null,null,"G5 revenue ($)",0,0,0,0,0,0,0]
[null,null,"G6 revenue ($)",0,0,69750.000000000058,69750.000000000058,69750.000000000058,69750.000000000058,279000.00000000023]
[null,null,"G1 variable costs ($)",15000,22500,22500,22500,22500,22500,127500]
[null,null,"G2 variable costs ($)",0,0,0,0,0,0,0]
[null,null,"G3 variable costs ($)",0,113245,113245,113245,25088.244999999999,113245,478068.245]
[null,null,"G4 variable costs ($)",0,161755.00000000003,161818.24500000002,61918.245000000017,225.0000000000002,211768.24500000002,597484.7350000001]
[null,null,"G5 variable costs ($)",{"$f":"D$33*D54+D$62*D83","v":0},0,0,0,0,0,0]
[null,null,"G6 variable costs ($)",0,0,450.0000000000004,450.0000000000004,450.0000000000004,450.0000000000004,1800.0000000000016]
[null,null,"G1 variable profit ($)",0,202500,272025.00000000006,272025.00000000006,272025.00000000006,272025.00000000006,1290600.0000000002]
[null,null,"G2 variable profit ($)",0,0,0,0,0,0,0]
[null,null,"G3 variable profit ($)",0,0,34992.705000000031,34992.705000000031,34992.705000000031,34992.705000000031,139970.82000000012]
[null,null,"G4 variable profit ($)",0,0,69525.000000000058,69525.000000000058,69525.000000000058,69525.000000000058,278100.00000000023]
[null,null,"G5 variable profit ($)",0,0,0,0,0,0,0]
[null,null,"G6 variable profit ($)",0,0,69300.000000000058,69300.000000000058,69300.000000000058,69300.000000000058,277200.00000000023]
[]
[]
[null,null,null,"Energy only revenue ($)","Energy only profit ($)","Cap market revenue ($)","Total profit ($)","Total revenue ($)","MPC"]
[null,null,null,2843896.0000000009,-39129156.979999997,283140756.97999996,244011599.99999994,285984652.97999996,10000]