{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Info","Table Of Contents","Instruction","Input and Output >","Radial","Radial with IC","Mesh","Model Formulation >","Radial formulation","Radial IC formulation","Mesh formulation"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":570,"comments":2,"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":"Info","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,25,1],[20,2,20,3],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Creation Date",null,"2024-07-16"]
["Client",null,"Australian Energy Market Commission"]
["Project",null,"Transmission Access Reform Stylised Model"]
["Description"]
["Author",null,"Endgame Economics"]
["Version",null,1]

{"sheet":"Table Of Contents","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Table Of Contents"]
[]
[null,"Sheet","Description"]
[null,"Instruction","Instruction on setup and executing runs"]
[null,"Input and Output >"]
[null,"Radial","Radial network input and output"]
[null,"Radial with IC","Radial with IC network input and output"]
[null,"Mesh","Mesh network input and output"]
[null,"Model Formulation >"]
[null,"Radial formulation","Radial network formulation"]
[null,"Radial IC formulation","Radial with IC network formulation"]
[null,"Mesh formulation","Mesh network formulation"]

{"sheet":"Instruction","index":2,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"instruction"]
[]
[null,"Setup"]
[]
[null,"To enable Solver Add-in"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Executing simulation"]

{"sheet":"Input and Output >","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Radial","index":4,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[22,3,22,6],[22,12,22,15]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Output ( 1 hour resolution)"]
[]
[null,"Global settings"]
[]
[null,"Priority level","BPF ($/MWh)",null,null,null,null,null,null,null,null,"Colour guide"]
[null,1,-1000,null,null,null,null,null,null,null,null,null,"User inputs"]
[null,2,-850,null,null,null,null,null,null,null,null,null,"Model output - do not change"]
[null,3,-700,null,null,null,null,null,null,null,null,null,"Derived calculation - do not change"]
[null,4,-550,null,null,null,null,null,null,null,null,null,"Fixed parameter - do not change"]
[]
[null,"General assumptions","$/MWh"]
[null,"VOLL",17500]
[]
[]
[null,"User inputs"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Demand (RRN)","MW",null,null,null,null,null,null,null,"Demand (RRN)","MW"]
[null,1,250,null,null,null,null,null,null,null,1,250]
[]
[null,null,"RHS","LHS",null,null,null,null,null,null,null,"RHS","LHS"]
[null,"Transfer Cosntraint","Rating (MW)","Unit 1","Unit 2","Unit 3","Unit 4",null,null,null,"Transfer Cosntraint","Rating (MW)","Unit 1","Unit 2","Unit 3","Unit 4"]
[null,1,120,null,1,0.8,0.6,null,null,null,1,100,null,1,1,1]
[]
[null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid",null,null,null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid"]
[null,1,300,80,false,true,80,null,null,null,1,200,50,false,true,100]
[null,2,100,25,false,true,25,null,null,null,2,100,0,false,true,30]
[null,3,100,15,false,true,20,null,null,null,3,100,10,false,true,50]
[null,4,100,12,false,true,12,null,null,null,4,50,0,true,true,15]
[]
[null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)",null,null,null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)"]
[null,1,1,"SRMC","SRMC",{"$f":"IF(D34 = \"BPF\",VLOOKUP(C34,$B$7:$C$10,2,FALSE),D28)","v":80},{"$f":"IF(E34 = \"SRMC\",D28,G28)","v":80},null,null,null,1,1,"SRMC","SRMC",{"$f":"IF(M34 = \"BPF\",VLOOKUP(L34,$B$7:$C$10,2,FALSE),M28)","v":50},{"$f":"IF(N34 = \"SRMC\",M28,P28)","v":50}]
[null,2,1,"BPF","SRMC",{"$f":"IF(D35 = \"BPF\",VLOOKUP(C35,$B$7:$C$10,2,FALSE),D29)","v":-1000},{"$f":"IF(E35 = \"SRMC\",D29,G29)","v":25},null,null,null,2,1,"SRMC","SRMC",{"$f":"IF(M35 = \"BPF\",VLOOKUP(L35,$B$7:$C$10,2,FALSE),M29)","v":0},{"$f":"IF(N35 = \"SRMC\",M29,P29)","v":0}]
[null,3,3,"BPF","Strategic",{"$f":"IF(D36 = \"BPF\",VLOOKUP(C36,$B$7:$C$10,2,FALSE),D30)","v":-700},{"$f":"IF(E36 = \"SRMC\",D30,G30)","v":20},null,null,null,3,1,"SRMC","SRMC",{"$f":"IF(M36 = \"BPF\",VLOOKUP(L36,$B$7:$C$10,2,FALSE),M30)","v":10},{"$f":"IF(N36 = \"SRMC\",M30,P30)","v":10}]
[null,4,4,"BPF","SRMC",{"$f":"IF(D37 = \"BPF\",VLOOKUP(C37,$B$7:$C$10,2,FALSE),D31)","v":-550},{"$f":"IF(E37 = \"SRMC\",D31,G31)","v":12},null,null,null,4,1,"BPF","Strategic",{"$f":"IF(M37 = \"BPF\",VLOOKUP(L37,$B$7:$C$10,2,FALSE),M31)","v":-1000},{"$f":"IF(N37 = \"SRMC\",M31,P31)","v":15}]
[]
[null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)",null,null,null,null,null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)"]
[null,1,"Cap",50,300,null,null,null,null,null,1,"Cap",50,90]
[null,2,"Swap",50,75,null,null,null,null,null,2,"Swap",100,30]
[null,3,"PPA",50,50,null,null,null,null,null,3,"Swap",0,30]
[null,4,"PPA",50,60,null,null,null,null,null,4,"Cap",50,60]
[]
[]
[null,"Outputs"]
[]
[]
[]
[null,"CONTROL\nPANEL"]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Region","RRP ($/MWh)","Access USE (MW)","Physical USE (MW)",null,null,null,null,null,"Region","RRP ($/MWh)","Access USE (MW)","Physical USE (MW)"]
[null,1,{"$f":"'Radial formulation'!$K$30","v":80},{"$f":"'Radial formulation'!$G$16","v":0},{"$f":"'Radial formulation'!$G$54","v":0},null,null,null,null,null,1,{"$f":"'Radial formulation'!$V$30","v":50},{"$f":"'Radial formulation'!$R$16","v":0},{"$f":"'Radial formulation'!$R$54","v":0}]
[]
[null,"Transfer constraint","Access LHS (MW)","Physical LHS (MW)",null,null,null,null,null,null,"Transfer constraint","Access LHS (MW)","Physical LHS (MW)"]
[null,1,{"$f":"'Radial formulation'!$H$38","v":120},{"$f":"'Radial formulation'!$H$76","v":120.00000000000001},null,null,null,null,null,null,1,{"$f":"'Radial formulation'!$S$38","v":100},{"$f":"'Radial formulation'!$S$76","v":100}]
[]
[null,"Unit dispatch","Region","CRMP ($/MWh)","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)",null,"Unit dispatch","Region","CRMP (MW)","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)"]
[null,1,1,{"$f":"TRANSPOSE('Radial formulation'!$C$77:$F$77)","v":80},{"$f":"TRANSPOSE('Radial formulation'!$C$16:$F$16)","v":116.66666666666666},{"$f":"TRANSPOSE('Radial formulation'!$C$54:$F$54)","v":74.999999999999986},{"$f":"F62-E62","v":-41.666666666666671},{"$f":"IF(C40=\"PPA\",MIN(D40,ABS(F62)),D40) * IF(E28,-1,1)","v":50},{"$f":" IF(C40 = \"Cap\", MIN(E40-VLOOKUP(C62,B$56:C$56,2,FALSE),0), E40-VLOOKUP(C62,B$56:C$56,2,FALSE))","v":0},null,1,1,{"$f":"TRANSPOSE('Radial formulation'!$N$77:$Q$77)","v":50},{"$f":"TRANSPOSE('Radial formulation'!$N$16:$Q$16)","v":150},{"$f":"TRANSPOSE('Radial formulation'!$N$54:$Q$54)","v":150},{"$f":"O62-N62","v":0},{"$f":"IF(L40=\"PPA\",MIN(M40,ABS(O62)),M40) * IF(N28,-1,1)","v":50},{"$f":" IF(L40 = \"Cap\", MIN(N40-VLOOKUP(L62,K$56:L$56,2,FALSE),0), N40-VLOOKUP(L62,K$56:L$56,2,FALSE))","v":0}]
[null,2,1,5,100,0,{"$f":"F63-E63","v":-100},{"$f":"IF(C41=\"PPA\",MIN(D41,ABS(F63)),D41) * IF(E29,-1,1)","v":50},{"$f":" IF(C41 = \"Cap\", MIN(E41-VLOOKUP(C63,B$56:C$56,2,FALSE),0), E41-VLOOKUP(C63,B$56:C$56,2,FALSE))","v":-5},null,2,1,10,100,100,{"$f":"O63-N63","v":0},{"$f":"IF(L41=\"PPA\",MIN(M41,ABS(O63)),M41) * IF(N29,-1,1)","v":100},{"$f":" IF(L41 = \"Cap\", MIN(N41-VLOOKUP(L63,K$56:L$56,2,FALSE),0), N41-VLOOKUP(L63,K$56:L$56,2,FALSE))","v":-20}]
[null,3,1,20,0,75.000000000000014,{"$f":"F64-E64","v":75.000000000000014},{"$f":"IF(C42=\"PPA\",MIN(D42,ABS(F64)),D42) * IF(E30,-1,1)","v":50},-30,null,3,1,10,0,50,50,{"$f":"IF(L42=\"PPA\",MIN(M42,ABS(O64)),M42) * IF(N30,-1,1)","v":0},-20]
[null,4,1,35,33.333333333333343,100,{"$f":"F65-E65","v":66.666666666666657},{"$f":"IF(C43=\"PPA\",MIN(D43,ABS(F65)),D43) * IF(E31,-1,1)","v":50},-20,null,4,1,10,0,50,50,{"$f":"IF(L43=\"PPA\",MIN(M43,ABS(O65)),M43) * IF(N31,-1,1)","v":-50},0]
[]
[null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)",null,null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)"]
[null,1,{"$f":"E62 * VLOOKUP(C62,B$56:C$56,2,FALSE)","v":9333.3333333333321},{"$f":"G62*D62","v":-3333.3333333333339},{"$f":"C68+D68","v":5999.9999999999982},{"$f":"H62*I62","v":0},{"$f":"F62*D28","v":5999.9999999999991},{"$f":"SUM(E68:F68) - G68","v":0},null,null,1,{"$f":"N62 * VLOOKUP(L62,K$56:L$56,2,FALSE)","v":7500},{"$f":"P62*M62","v":0},{"$f":"L68+M68","v":7500},{"$f":"Q62*R62","v":0},0,{"$f":"SUM(N68:O68) - P68","v":7500}]
[null,2,{"$f":"E63 * VLOOKUP(C63,B$56:C$56,2,FALSE)","v":8000},{"$f":"G63*D63","v":-500},{"$f":"C69+D69","v":7500},{"$f":"H63*I63","v":-250},{"$f":"F63*D29","v":0},{"$f":"SUM(E69:F69) - G69","v":7250},null,null,2,{"$f":"N63 * VLOOKUP(L63,K$56:L$56,2,FALSE)","v":5000},{"$f":"P63*M63","v":0},{"$f":"L69+M69","v":5000},{"$f":"Q63*R63","v":-2000},{"$f":"O63*M29","v":0},{"$f":"SUM(N69:O69) - P69","v":3000}]
[null,3,0,1500.0000000000002,1500.0000000000002,{"$f":"H64*I64","v":-1500},{"$f":"F64*D30","v":1125.0000000000002},{"$f":"SUM(E70:F70) - G70","v":-1125.0000000000002},null,null,3,0,500,500,{"$f":"Q64*R64","v":0},{"$f":"O64*M30","v":500},{"$f":"SUM(N70:O70) - P70","v":0}]
[null,4,2666.6666666666674,2333.333333333333,5000,{"$f":"H65*I65","v":-1000},{"$f":"F65*D31","v":1200},2800,null,null,4,0,500,500,{"$f":"Q65*R65","v":0},{"$f":"O65*M31","v":0},{"$f":"SUM(N71:O71) - P71","v":500}]
[null,"Total",{"$f":"SUM(C68:C71)","v":20000},{"$f":"SUM(D68:D71)","v":0},20000,-2750,8325,8925,null,null,"Total",{"$f":"SUM(L68:L71)","v":12500},1000,13500,-2000,500,11000]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[]
[null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u1_crmp),0) &\"/MWh\"","v":"$80/MWh"},null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u1_crmp),0) &\"/MWh\"","v":"$50/MWh"}]
[null,{"$f":"ROUND(TRANSPOSE(s1u1_dispatch),0)&\"MW\"","v":"117MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u1_dispatch),0)&\"MW\"","v":"150MW"},null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u2_crmp),0) &\"/MWh\"","v":"$10/MWh"}]
[null,"75MW",null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u2_crmp),0) &\"/MWh\"","v":"$5/MWh"},null,null,"150MW",null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u2_dispatch),0)&\"MW\"","v":"100MW"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1u2_dispatch),0)&\"MW\"","v":"100MW"},null,null,null,null,null,null,null,null,"100MW"]
[null,null,null,null,null,null,null,"0MW"]
[]
[null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n1_price),0) &\"/MWh\"","v":"$80/MWh"},null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n1_price),0) &\"/MWh\"","v":"$50/MWh"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u3_crmp),0) &\"/MWh\"","v":"$10/MWh"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u3_dispatch),0)&\"MW\"","v":"0MW"}]
[null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u3_crmp),0) &\"/MWh\"","v":"$20/MWh"},null,null,null,null,null,null,null,null,"50MW"]
[null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1l1_flow),0)&\"MW\"","v":"120MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s1u3_dispatch),0)&\"MW\"","v":"0MW"},null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2l1_flow),0)&\"MW\"","v":"100MW"}]
[null,null,null,null,"120MW",null,null,null,"75MW",null,null,null,null,"100MW"]
[]
[null,null,{"$f":"ROUND(s1n1_demand,0)&\"MW\"","v":"250MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(s2n1_demand,0)&\"MW\"","v":"250MW"}]
[null,null,{"$f":"ROUND(TRANSPOSE(s1n1_use),0)&\"MW\"","v":"0MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2n1_use),0)&\"MW\"","v":"0MW"}]
[null,null,"0MW",null,null,null,null,null,null,null,null,"0MW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u4_crmp),0) &\"/MWh\"","v":"$10/MWh"}]
[null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u4_crmp),0) &\"/MWh\"","v":"$35/MWh"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u4_dispatch),0)&\"MW\"","v":"0MW"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1u4_dispatch),0)&\"MW\"","v":"33MW"},null,null,null,null,null,null,null,null,"50MW"]
[null,null,"Load",null,null,null,null,"100MW"]
[null,"Access Quantity","Access USE","RRP"]
[null,"Physical Quantity","Physical USE","CRMP"]
[]
[]
[]
[null,"Sheet end"]

{"sheet":"Radial with IC","index":5,"n_rows":134,"n_cols":18,"rows_kept":134,"cut":false,"hidden":false,"merged":[[28,3,28,8],[28,12,28,17]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Output ( 1 hour resolution)"]
[]
[null,"Global settings"]
[]
[null,"Priority level","BPF ($/MWh)",null,null,null,null,null,null,null,null,"Colour guide"]
[null,1,-1000,null,null,null,null,null,null,null,null,null,"User inputs"]
[null,2,-850,null,null,null,null,null,null,null,null,null,"Model output - do not change"]
[null,3,-700,null,null,null,null,null,null,null,null,null,"Derived calculation - do not change"]
[null,4,-550,null,null,null,null,null,null,null,null,null,"Fixed parameter - do not change"]
[null,5,-400]
[null,6,-250]
[]
[null,"General assumptions","$/MWh"]
[null,"VOLL",17500]
[]
[]
[null,"User inputs"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Demand (RRN)","MW",null,null,null,null,null,null,null,"Demand (RRN)","MW"]
[null,1,500,null,null,null,null,null,null,null,1,200]
[null,2,300,null,null,null,null,null,null,null,2,213]
[]
[null,"Line","Rating (MW)",null,null,null,null,null,null,null,"Line","Rating (MW)"]
[null,1,90,null,null,null,null,null,null,null,1,300]
[]
[null,null,"RHS","LHS",null,null,null,null,null,null,null,"RHS","LHS"]
[null,"Transfer Cosntraint","Rating (MW)","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6",null,"Transfer Cosntraint","Rating (MW)","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6"]
[null,1,130,null,1,0.5,null,null,null,null,1,100,null,1,0.5]
[null,2,100,null,null,null,null,1,0.5,null,2,150,null,null,null,null,1,0.2]
[]
[null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid",null,null,null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid"]
[null,1,400,80,false,true,100,null,null,null,1,400,80,false,false,0]
[null,2,100,30,false,true,45,null,null,null,2,100,30,false,false,0]
[null,3,100,20,false,true,50,null,null,null,3,100,0,false,false,0]
[null,4,400,150,false,true,200,null,null,null,4,400,150,false,false,0]
[null,5,100,10,false,true,50,null,null,null,5,100,10,false,false,0]
[null,6,100,0,false,true,30,null,null,null,6,100,0,false,true,0]
[]
[null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)",null,null,null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)"]
[null,1,1,"SRMC","Strategic",{"$f":"IF(D43 = \"BPF\",VLOOKUP(C43,$B$7:$C$12,2,FALSE),D35)","v":80},{"$f":"IF(E43 = \"SRMC\",D35,G35)","v":100},null,null,null,1,1,"SRMC","SRMC",{"$f":"IF(M43 = \"BPF\",VLOOKUP(L43,$B$7:$C$12,2,FALSE),M35)","v":80},{"$f":"IF(N43 = \"SRMC\",M35,P35)","v":80}]
[null,2,4,"BPF","Strategic",{"$f":"IF(D44 = \"BPF\",VLOOKUP(C44,$B$7:$C$12,2,FALSE),D36)","v":-550},{"$f":"IF(E44 = \"SRMC\",D36,G36)","v":45},null,null,null,2,1,"SRMC","SRMC",{"$f":"IF(M44 = \"BPF\",VLOOKUP(L44,$B$7:$C$12,2,FALSE),M36)","v":30},{"$f":"IF(N44 = \"SRMC\",M36,P36)","v":30}]
[null,3,1,"BPF","Strategic",-1000,50,null,null,null,3,4,"SRMC","Strategic",0,0]
[null,4,1,"SRMC","Strategic",150,200,null,null,null,4,1,"SRMC","SRMC",150,150]
[null,5,1,"BPF","SRMC",-1000,10,null,null,null,5,1,"BPF","SRMC",-1000,10]
[null,6,5,"BPF","SRMC",-400,0,null,null,null,6,6,"SRMC","SRMC",0,0]
[]
[null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)",null,null,null,null,null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)"]
[null,1,"Cap",200,100,null,null,null,null,null,1,"Cap",200,100]
[null,2,"PPA",100,45,null,null,null,null,null,2,"Swap",100,70]
[null,3,"PPA",100,50,null,null,null,null,null,3,"PPA",100,75]
[null,4,"Cap",200,200,null,null,null,null,null,4,"Cap",200,200]
[null,5,"PPA",0,0,null,null,null,null,null,5,"PPA",100,50]
[null,6,"PPA",0,0,null,null,null,null,null,6,"PPA",0,0]
[]
[]
[null,"Outputs"]
[]
[]
[]
[null,"CONTROL\nPANEL"]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Region","RRP ($/MWh)","Access USE (MW)","Physical USE (MW)",null,null,null,null,null,"Region","RRP ($/MWh)","Access USE (MW)","Physical USE (MW)"]
[null,1,{"$f":"'Radial IC formulation'!O30","v":150},{"$f":"TRANSPOSE('Radial IC formulation'!$J$16:$K$16)","v":0},{"$f":"TRANSPOSE('Radial IC formulation'!$J$56:$K$56)","v":0},null,null,null,null,null,1,{"$f":"'Radial IC formulation'!AD30","v":80},{"$f":"TRANSPOSE('Radial IC formulation'!$Y$16:$Z$16)","v":0},{"$f":"TRANSPOSE('Radial IC formulation'!$Y$56:$Z$56)","v":0}]
[null,2,{"$f":"'Radial IC formulation'!O31","v":150},0,0,null,null,null,null,null,2,{"$f":"'Radial IC formulation'!AD31","v":80},0,0]
[]
[null,"Line flow","Access Run Flow (MW)","Physical Flow (MW)",null,null,null,null,null,null,"Line flow","Access Run Flow (MW)","Physical Flow (MW)"]
[null,1,{"$f":"'Radial IC formulation'!$I$16","v":-80},{"$f":"'Radial IC formulation'!I56","v":-80},null,null,null,null,null,null,1,{"$f":"'Radial IC formulation'!$X$16","v":-13},{"$f":"'Radial IC formulation'!X56","v":-13}]
[]
[null,"Transfer constraint","Access LHS (MW)","Physical LHS (MW)",null,null,null,null,null,null,"Transfer constraint","Access LHS (MW)","Physical LHS (MW)"]
[null,1,{"$f":"'Radial IC formulation'!L39","v":130},{"$f":"'Radial IC formulation'!L79","v":130},null,null,null,null,null,null,1,{"$f":"'Radial IC formulation'!AA39","v":100},{"$f":"'Radial IC formulation'!AA79","v":100}]
[null,2,{"$f":"'Radial IC formulation'!L40","v":100},{"$f":"'Radial IC formulation'!L80","v":100},null,null,null,null,null,null,2,{"$f":"'Radial IC formulation'!AA40","v":120},{"$f":"'Radial IC formulation'!AA80","v":120}]
[]
[null,"Unit dispatch","Region","CRMP ($/MWh)","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)",null,"Unit","Region","CRMP ($/MWh)","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)"]
[null,1,1,{"$f":"TRANSPOSE('Radial IC formulation'!$C$81:$H$81)","v":200},{"$f":"TRANSPOSE('Radial IC formulation'!$C$16:$H$16)","v":400},{"$f":"TRANSPOSE('Radial IC formulation'!$C$56:$H$56)","v":400},{"$f":"F80-E80","v":0},{"$f":"IF(C51=\"PPA\",MIN(D51,ABS(F80)),D51) * IF(E35,-1,1)","v":200},{"$f":" IF(C51 = \"Cap\", MIN(E51-VLOOKUP(C80,B$69:C$70,2,FALSE),0), E51-VLOOKUP(C80,B$69:C$70,2,FALSE))","v":-50},null,1,1,{"$f":"TRANSPOSE('Radial IC formulation'!$R$81:$W$81)","v":0},{"$f":"TRANSPOSE('Radial IC formulation'!$R$16:$W$16)","v":63},{"$f":"TRANSPOSE('Radial IC formulation'!$R$56:$W$56)","v":63},{"$f":"O80-N80","v":0},{"$f":"IF(L51=\"PPA\",MIN(M51,ABS(O80)),M51) * IF(N35,-1,1)","v":200},{"$f":" IF(L51 = \"Cap\", MIN(N51-VLOOKUP(L80,K$69:L$70,2,FALSE),0), N51-VLOOKUP(L80,K$69:L$70,2,FALSE))","v":0}]
[null,2,1,45,80,80,{"$f":"F81-E81","v":0},80,{"$f":" IF(C52 = \"Cap\", MIN(E52-VLOOKUP(C81,B$69:C$70,2,FALSE),0), E52-VLOOKUP(C81,B$69:C$70,2,FALSE))","v":-105},null,2,1,0,50,50,{"$f":"O81-N81","v":0},{"$f":"IF(L52=\"PPA\",MIN(M52,ABS(O81)),M52) * IF(N36,-1,1)","v":100},{"$f":" IF(L52 = \"Cap\", MIN(N52-VLOOKUP(L81,K$69:L$70,2,FALSE),0), N52-VLOOKUP(L81,K$69:L$70,2,FALSE))","v":-10}]
[null,3,1,122.5,100,100,{"$f":"F82-E82","v":0},100,-100,null,3,1,0,100,100,0,100,-5]
[null,4,2,200,120,70,-50,200,0,null,4,2,0,0,0,0,200,0]
[null,5,2,10,100,50,{"$f":"F84-E84","v":-50},0,-150,null,5,2,0,100,100,0,100,-30]
[null,6,2,105,0,100,100,0,-150,null,6,2,0,100,100,0,0,-80]
[]
[null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)",null,null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)"]
[null,1,{"$f":"E80 * VLOOKUP(C80,B$69:C$70,2,FALSE)","v":60000},{"$f":"G80*D80","v":0},{"$f":"C88+D88","v":60000},{"$f":"H80*I80","v":-10000},{"$f":"F80*D35","v":32000},{"$f":"SUM(E88:F88) - G88","v":18000},null,null,1,{"$f":"N80 * VLOOKUP(L80,K$69:L$70,2,FALSE)","v":5040},{"$f":"P80*M80","v":0},{"$f":"L88+M88","v":5040},{"$f":"Q80*R80","v":0},0,{"$f":"SUM(N88:O88) - P88","v":5040}]
[null,2,{"$f":"E81 * VLOOKUP(C81,B$69:C$70,2,FALSE)","v":12000},{"$f":"G81*D81","v":0},{"$f":"C89+D89","v":12000},-8400,{"$f":"F81*D36","v":2400},{"$f":"SUM(E89:F89) - G89","v":1200},null,null,2,{"$f":"N81 * VLOOKUP(L81,K$69:L$70,2,FALSE)","v":4000},{"$f":"P81*M81","v":0},{"$f":"L89+M89","v":4000},-1000,{"$f":"O81*M36","v":1500},{"$f":"SUM(N89:O89) - P89","v":1500}]
[null,3,15000,0,15000,-10000,2000,3000,null,null,3,8000,0,8000,-500,{"$f":"O82*M37","v":0},7500]
[null,4,18000,-10000,{"$f":"C91+D91","v":8000},0,10500,-2500,null,null,4,0,0,0,0,{"$f":"O83*M38","v":0},0]
[null,5,15000,-500,14500,0,500,14000,null,null,5,8000,0,8000,-3000,{"$f":"O84*M39","v":1000},4000]
[null,6,0,10500,10500,0,0,10500,null,null,6,8000,0,8000,0,{"$f":"O85*M40","v":0},8000]
[null,"Total",{"$f":"SUM(C88:C93)","v":120000},{"$f":"SUM(D88:D93)","v":0},120000,-28400,47400,44200,null,null,"Total",{"$f":"SUM(L88:L93)","v":33040},{"$f":"SUM(M88:M93)","v":0},{"$f":"SUM(N88:N93)","v":33040},{"$f":"SUM(O88:O93)","v":-4500},{"$f":"SUM(P88:P93)","v":2500},{"$f":"SUM(Q88:Q93)","v":26040}]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[null,null,null,null,{"$f":"ROUND(s1n1_demand,0)&\"MW\"","v":"500MW"},null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u2_crmp),0) &\"/MWh\"","v":"$45/MWh"},null,null,null,null,null,{"$f":"ROUND(s2n1_demand,0)&\"MW\"","v":"200MW"},null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u2_crmp),0) &\"/MWh\"","v":"$0/MWh"}]
[null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1n1_use),0)&\"MW\"","v":"0MW"},{"$f":"\"$\"&ROUND(TRANSPOSE(s1n1_price),0) &\"/MWh\"","v":"$150/MWh"},null,{"$f":"ROUND(TRANSPOSE(s1u2_dispatch),0)&\"MW\"","v":"80MW"},null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2n1_use),0)&\"MW\"","v":"0MW"},{"$f":"\"$\"&ROUND(TRANSPOSE(s2n1_price),0) &\"/MWh\"","v":"$80/MWh"},null,{"$f":"ROUND(TRANSPOSE(s2u2_dispatch),0)&\"MW\"","v":"50MW"}]
[null,null,null,null,"0MW",null,null,"80MW",null,null,null,null,null,"0MW",null,null,"50MW"]
[]
[]
[]
[null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1l1_flow),0)&\"MW\"","v":"130MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2l1_flow),0)&\"MW\"","v":"100MW"}]
[null,null,null,null,null,"130MW",null,null,null,null,null,null,null,null,"100MW"]
[null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u1_crmp),0) &\"/MWh\"","v":"$200/MWh"},null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u3_crmp),0) &\"/MWh\"","v":"$123/MWh"},null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u1_crmp),0) &\"/MWh\"","v":"$0/MWh"},null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u3_crmp),0) &\"/MWh\"","v":"$0/MWh"}]
[null,null,null,{"$f":"ROUND(TRANSPOSE(s1u1_dispatch),0)&\"MW\"","v":"400MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s1u3_dispatch),0)&\"MW\"","v":"100MW"},null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u1_dispatch),0)&\"MW\"","v":"63MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s2u3_dispatch),0)&\"MW\"","v":"100MW"}]
[null,null,null,"400MW",null,null,null,"100MW",null,null,null,null,"63MW",null,null,null,"100MW"]
[]
[null,null,null,{"$f":"ROUND(TRANSPOSE(s1lc1_flow),0)&\"MW\"","v":"-80MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2lc1_flow),0)&\"MW\"","v":"-13MW"}]
[null,null,null,"-80MW",null,null,null,null,null,null,null,null,"-13MW"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u5_crmp),0) &\"/MWh\"","v":"$10/MWh"},null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u5_crmp),0) &\"/MWh\"","v":"$0/MWh"}]
[null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1u5_dispatch),0)&\"MW\"","v":"100MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u5_dispatch),0)&\"MW\"","v":"100MW"}]
[null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n2_price),0) &\"/MWh\"","v":"$150/MWh"},null,"50MW",null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n2_price),0) &\"/MWh\"","v":"$80/MWh"},null,"100MW"]
[]
[]
[]
[null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1l2_flow),0)&\"MW\"","v":"100MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2l2_flow),0)&\"MW\"","v":"120MW"}]
[null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u4_crmp),0) &\"/MWh\"","v":"$200/MWh"},null,"100MW",null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u4_crmp),0) &\"/MWh\"","v":"$0/MWh"},null,"120MW"]
[null,null,null,{"$f":"ROUND(TRANSPOSE(s1u4_dispatch),0)&\"MW\"","v":"120MW"},{"$f":"ROUND(s1n2_demand,0)&\"MW\"","v":"300MW"},null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1u6_crmp),0) &\"/MWh\"","v":"$105/MWh"},null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u4_dispatch),0)&\"MW\"","v":"0MW"},{"$f":"ROUND(s2n2_demand,0)&\"MW\"","v":"213MW"},null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2u6_crmp),0) &\"/MWh\"","v":"$0/MWh"}]
[null,null,null,"70MW",{"$f":"ROUND(TRANSPOSE(s1n2_use),0)&\"MW\"","v":"0MW"},null,null,{"$f":"ROUND(TRANSPOSE(s1u6_dispatch),0)&\"MW\"","v":"0MW"},null,null,null,null,"0MW",{"$f":"ROUND(TRANSPOSE(s2n2_use),0)&\"MW\"","v":"0MW"},null,null,{"$f":"ROUND(TRANSPOSE(s2u6_dispatch),0)&\"MW\"","v":"100MW"}]
[null,null,null,null,"0MW",null,null,"100MW",null,null,null,null,null,"0MW",null,null,"100MW"]
[]
[null,null,"Load"]
[null,"Access Quantity","Access USE","RRP"]
[null,"Physical Quantity","Physical USE","CRMP"]
[]
[]
[]
[null,"Sheet end"]

{"sheet":"Mesh","index":6,"n_rows":147,"n_cols":18,"rows_kept":147,"cut":false,"hidden":false,"merged":[[29,12,29,17]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Output ( 1 hour resolution)"]
[]
[null,"Global settings"]
[]
[null,"Priority level","BPF ($/MWh)",null,null,null,null,null,null,null,null,"Colour guide"]
[null,1,-1000,null,null,null,null,null,null,null,null,null,"User inputs"]
[null,2,-850,null,null,null,null,null,null,null,null,null,"Model output - do not change"]
[null,3,-700,null,null,null,null,null,null,null,null,null,"Derived calculation - do not change"]
[null,4,-550,null,null,null,null,null,null,null,null,null,"Fixed parameter - do not change"]
[null,5,-400]
[null,6,-250]
[]
[null,"General assumptions","$/MWh"]
[null,"VOLL",17500]
[]
[]
[null,"User inputs"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Demand (node)","MW",null,null,null,null,null,null,null,"Demand (node)","MW"]
[null,1,50,null,null,null,null,null,null,null,1,50]
[null,2,150,null,null,null,null,null,null,null,2,150]
[null,3,50,null,null,null,null,null,null,null,3,50]
[null,4,400,null,null,null,null,null,null,null,4,400]
[null,5,50,null,null,null,null,null,null,null,5,50]
[null,6,150,null,null,null,null,null,null,null,6,150]
[]
[]
[null,"Line ","Rating (MW)",null,null,null,null,null,null,null,"Line ","Rating (MW)"]
[null,1,200,null,null,null,null,null,null,null,1,200]
[null,2,200,null,null,null,null,null,null,null,2,200]
[null,3,250,null,null,null,null,null,null,null,3,200]
[null,4,100,null,null,null,null,null,null,null,4,100]
[null,5,200,null,null,null,null,null,null,null,5,200]
[null,6,200,null,null,null,null,null,null,null,6,200]
[]
[null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid",null,null,null,"Unit Specification","Capacity (MW)","SRMC ($/MWh)","Is load","CRM participation","CRM Strategic bid"]
[null,1,200,60,false,false,0,null,null,null,1,200,60,false,false,0]
[null,2,300,105,false,true,105,null,null,null,2,300,100,false,true,105]
[null,3,200,50,false,false,0,null,null,null,3,200,50,false,false,0]
[null,4,400,100,false,true,100,null,null,null,4,300,150,false,true,110]
[null,5,200,4,false,true,50,null,null,null,5,200,5,false,true,40]
[null,6,250,10,false,true,30,null,null,null,6,300,10,false,true,40]
[]
[null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)",null,null,null,"Unit Bidding","Priority level","Access run bidding strategy","CRM bidding strategy","Access run bid ($/MWh)","CRM bid ($/MWh)"]
[null,1,1,"SRMC","SRMC",{"$f":"IF(D48 = \"BPF\",VLOOKUP(C48,$B$7:$C$12,2,FALSE),D40)","v":60},{"$f":"IF(E48 = \"SRMC\",D40,G40)","v":60},null,null,null,1,1,"SRMC","SRMC",{"$f":"IF(M48 = \"BPF\",VLOOKUP(L48,$B$7:$C$12,2,FALSE),M40)","v":60},{"$f":"IF(N48 = \"SRMC\",M40,P40)","v":60}]
[null,2,1,"SRMC","SRMC",{"$f":"IF(D49 = \"BPF\",VLOOKUP(C49,$B$7:$C$12,2,FALSE),D41)","v":105},{"$f":"IF(E49 = \"SRMC\",D41,G41)","v":105},null,null,null,2,1,"SRMC","Strategic",{"$f":"IF(M49 = \"BPF\",VLOOKUP(L49,$B$7:$C$12,2,FALSE),M41)","v":100},{"$f":"IF(N49 = \"SRMC\",M41,P41)","v":105}]
[null,3,1,"SRMC","SRMC",50,50,null,null,null,3,1,"SRMC","SRMC",50,50]
[null,4,1,"SRMC","SRMC",100,100,null,null,null,4,1,"SRMC","Strategic",150,110]
[null,5,1,"BPF","SRMC",-1000,4,null,null,null,5,1,"BPF","SRMC",-1000,5]
[null,6,5,"BPF","SRMC",-400,10,null,null,null,6,5,"BPF","SRMC",-400,10]
[]
[null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)",null,null,null,null,null,"Unit Contracts","Type","Volume (MW/hr)","Strike price ($/MW/hr)"]
[null,1,"Swap",15,65,null,null,null,null,null,1,"Swap",15,65]
[null,2,"Cap",100,100,null,null,null,null,null,2,"Cap",100,105]
[null,3,"Swap",10,60,null,null,null,null,null,3,"Swap",10,60]
[null,4,"Cap",100,100,null,null,null,null,null,4,"Cap",100,110]
[null,5,"PPA",200,40,null,null,null,null,null,5,"PPA",200,40]
[null,6,"PPA",250,40,null,null,null,null,null,6,"PPA",250,40]
[]
[]
[null,"Outputs"]
[]
[]
[]
[null,"CONTROL\nPANEL"]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,"Node","Region","RRP ($/MWh)","CRMP ($/MWh)","Access USE (MW)","Physical USE (MW)",null,null,null,"Node prices","Region","RRP ($/MWh)","CRMP ($/MWh)","Access USE (MW)","Physical USE (MW)"]
[null,1,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X111","v":100},{"$f":"TRANSPOSE('Mesh formulation'!O36:T36)","v":0},{"$f":"TRANSPOSE('Mesh formulation'!O97:T97)","v":0},null,null,null,1,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV111","v":105},{"$f":"TRANSPOSE('Mesh formulation'!AM36:AR36)","v":0},{"$f":"TRANSPOSE('Mesh formulation'!AM97:AR97)","v":0}]
[null,2,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X112","v":100},0,0,null,null,null,2,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV112","v":105},0,0]
[null,3,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X113","v":100},0,0,null,null,null,3,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV113","v":105},0,0]
[null,4,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X114","v":100},0,0,null,null,null,4,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV114","v":105},0,0]
[null,5,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X115","v":4},0,0,null,null,null,5,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV115","v":5},0,0]
[null,6,1,{"$f":"'Mesh formulation'!$X$53","v":100},{"$f":"'Mesh formulation'!X116","v":52},0,0,null,null,null,6,1,{"$f":"'Mesh formulation'!$AV$53","v":150},{"$f":"'Mesh formulation'!AV116","v":55},0,0]
[]
[null,"Line flow","Access Run Flow (MW)","Physical Flow (MW)",null,null,null,null,null,null,"Line flow","Access Run Flow (MW)","Physical Flow (MW)"]
[null,1,{"$f":"'Mesh formulation'!U63","v":-150},{"$f":"'Mesh formulation'!U124","v":-150},null,null,null,null,null,null,1,{"$f":"'Mesh formulation'!AS63","v":-150},{"$f":"'Mesh formulation'!AS124","v":-150}]
[null,2,{"$f":"'Mesh formulation'!U64","v":-150},{"$f":"'Mesh formulation'!U125","v":-150},null,null,null,null,null,null,2,{"$f":"'Mesh formulation'!AS64","v":-150},{"$f":"'Mesh formulation'!AS125","v":-150}]
[null,3,{"$f":"'Mesh formulation'!U65","v":-149.99999999981813},{"$f":"'Mesh formulation'!U126","v":-149.99999999981813},null,null,null,null,null,null,3,{"$f":"'Mesh formulation'!AS65","v":-199.99999999981813},{"$f":"'Mesh formulation'!AS126","v":-174.99999999981816}]
[null,4,{"$f":"'Mesh formulation'!U66","v":99.999999999909036},{"$f":"'Mesh formulation'!U127","v":99.999999999909022},null,null,null,null,null,null,4,{"$f":"'Mesh formulation'!AS66","v":99.999999999909051},{"$f":"'Mesh formulation'!AS127","v":99.999999999909065}]
[null,5,{"$f":"'Mesh formulation'!U67","v":49.999999999818087},{"$f":"'Mesh formulation'!U128","v":99.99999999981803},null,null,null,null,null,null,5,{"$f":"'Mesh formulation'!AS67","v":49.999999999818101},{"$f":"'Mesh formulation'!AS128","v":124.99999999981807}]
[null,6,{"$f":"'Mesh formulation'!U68","v":-50.000000000090949},{"$f":"'Mesh formulation'!U129","v":-9.0999208168796031E-11},null,null,null,null,null,null,6,{"$f":"'Mesh formulation'!AS68","v":-50.000000000090949},{"$f":"'Mesh formulation'!AS129","v":24.999999999909008}]
[]
[null,"Unit dispatch","Node","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)",null,null,"Unit","Node","Access Quantity (MW)","Physical Quantity (MW)","PQ - AQ","Contracted Quantity (MW)","Contract Payoff ($/MWh)"]
[null,1,1,{"$f":"TRANSPOSE('Mesh formulation'!C36:H36) *IF($E$40:$E$45,-1,1)","v":200},{"$f":"TRANSPOSE('Mesh formulation'!C97:H97)*IF($E$40:$E$45,-1,1)","v":200},{"$f":"E90-D90","v":0},{"$f":"IF(C56=\"PPA\",MIN(D56,ABS(E90)),D56) * IF(E40,-1,1)","v":15},{"$f":" IF(C56 = \"Cap\", MIN(E56-VLOOKUP(C90,B$74:D$79,3,FALSE),0), E56-VLOOKUP(C90,B$74:D$79,3,FALSE))","v":-35},null,null,1,1,{"$f":"TRANSPOSE('Mesh formulation'!AA36:AF36)*IF($N$40:$N$45,-1,1)","v":200},{"$f":"TRANSPOSE('Mesh formulation'!AA97:AF97)*IF($N$40:$N$45,-1,1)","v":200},{"$f":"N90-M90","v":0},{"$f":"IF(L56=\"PPA\",MIN(M56,ABS(N90)),M56) * IF(N40,-1,1)","v":15},{"$f":" IF(L56 = \"Cap\", MIN(N56-VLOOKUP(L90,K$74:M$79,3,FALSE),0), N56-VLOOKUP(L90,K$74:M$79,3,FALSE))","v":-85}]
[null,2,2,0,0,{"$f":"E91-D91","v":0},100,0,null,null,2,2,50,25.000000000000021,{"$f":"N91-M91","v":-24.999999999999979},{"$f":"IF(L57=\"PPA\",MIN(M57,ABS(N91)),M57) * IF(N41,-1,1)","v":100},-45]
[null,3,3,200,200,0,10,-40,null,null,3,3,200,200,0,10,-90]
[null,4,4,100,50.000000000000043,-49.999999999999957,100,0,null,null,4,4,50,0,-50,100,-40]
[null,5,5,200,150,-50,150,-60,null,null,5,5,200,125,-75,125,-110]
[null,6,6,150,250,100,250,-60,null,null,6,6,150,300,150,250,-110]
[]
[null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)",null,null,"Unit financials","Access revenue ($)","CRM revenue ($)","Pool revenue ($)","Contract difference payment ($)","Dispatch cost ($)","Net profit ($)"]
[null,1,{"$f":"D90 * VLOOKUP(C90,B$74:D$79,3,FALSE)","v":20000},{"$f":"F90*VLOOKUP(C90,B$74:E$79,4,FALSE)","v":0},{"$f":"C98+D98","v":20000},{"$f":"G90*H90","v":-525},{"$f":"E90*D40","v":12000},{"$f":"SUM(E98:F98) - G98","v":7475},null,null,1,{"$f":"M90 * VLOOKUP(L90,K$74:M$79,3,FALSE)","v":30000},{"$f":"O90*VLOOKUP(L90,K$74:N$79,4,FALSE)","v":0},{"$f":"L98+M98","v":30000},{"$f":"P90*Q90","v":-1275},0,{"$f":"SUM(N98:O98) - P98","v":28725}]
[null,2,{"$f":"D91 * VLOOKUP(C91,B$74:D$79,3,FALSE)","v":0},{"$f":"F91*VLOOKUP(C91,B$74:E$79,4,FALSE)","v":0},{"$f":"C99+D99","v":0},{"$f":"G91*H91","v":0},0,{"$f":"SUM(E99:F99) - G99","v":0},null,null,2,{"$f":"M91 * VLOOKUP(L91,K$74:M$79,3,FALSE)","v":7500},{"$f":"O91*VLOOKUP(L91,K$74:N$79,4,FALSE)","v":-2624.9999999999977},{"$f":"L99+M99","v":4875.0000000000018},{"$f":"P91*Q91","v":-4500},{"$f":"N91*M41","v":2500.0000000000023},{"$f":"SUM(N99:O99) - P99","v":-2125.0000000000005}]
[null,3,20000,0,20000,-400,10000,9600,null,null,3,30000,0,30000,-900,{"$f":"N92*M42","v":10000},19100]
[null,4,10000,-4999.9999999999955,5000.0000000000045,0,5000.0000000000045,0,null,null,4,7500,-5250,2250,-4000,{"$f":"N93*M43","v":0},-1750]
[null,5,20000,-200,19800,-9000,600,10200,null,null,5,30000,-375,29625,-13750,{"$f":"N94*M44","v":625},15250]
[null,6,15000,5200,20200,-15000,2500,2700,null,null,6,22500,8250,30750,-27500,{"$f":"N95*M45","v":3000},250]
[null,"Total",{"$f":"SUM(C98:C103)","v":85000},{"$f":"SUM(D98:D103)","v":0},85000,-24925,30100.000000000004,29975,null,null,"Total",{"$f":"SUM(L98:L103)","v":127500},{"$f":"SUM(M98:M103)","v":0},127500,-51925,16125.000000000002,{"$f":"SUM(Q98:Q103)","v":59450}]
[]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[null,null,null,{"$f":"ROUND(TRANSPOSE(s1u2_dispatch),0)&\"MW\"","v":"0MW"},null,{"$f":"ROUND(TRANSPOSE(s1u4_dispatch),0)&\"MW\"","v":"100MW"},null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u2_dispatch),0)&\"MW\"","v":"50MW"},null,{"$f":"ROUND(TRANSPOSE(s2u4_dispatch),0)&\"MW\"","v":"50MW"}]
[null,null,null,"0MW",null,"50MW",null,null,null,null,null,null,"25MW",null,"0MW"]
[null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n1_price),0) &\"/MWh\"","v":"$100/MWh"},null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n4_price),0) &\"/MWh\"","v":"$100/MWh"},null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n1_price),0) &\"/MWh\"","v":"$150/MWh"},null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n4_price),0) &\"/MWh\"","v":"$150/MWh"}]
[null,"$100/MWh",null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n2_price),0) &\"/MWh\"","v":"$100/MWh"},null,"$100/MWh",null,null,null,"$105/MWh",null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n2_price),0) &\"/MWh\"","v":"$150/MWh"},null,"$105/MWh"]
[null,{"$f":"ROUND(s1n1_demand,0)&\"MW\"","v":"50MW"},null,null,"$100/MWh",null,{"$f":"ROUND(s1n4_demand,0)&\"MW\"","v":"400MW"},null,null,null,{"$f":"ROUND(s2n1_demand,0)&\"MW\"","v":"50MW"},null,null,"$105/MWh",null,{"$f":"ROUND(s2n4_demand,0)&\"MW\"","v":"400MW"}]
[null,{"$f":"ROUND(TRANSPOSE(s1n1_use),0)&\"MW\"","v":"0MW"},null,null,{"$f":"ROUND(s1n2_demand,0)&\"MW\"","v":"150MW"},null,{"$f":"ROUND(TRANSPOSE(s1n4_use),0)&\"MW\"","v":"0MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s2n1_use),0)&\"MW\"","v":"0MW"},null,null,{"$f":"ROUND(s2n2_demand,0)&\"MW\"","v":"150MW"},null,{"$f":"ROUND(TRANSPOSE(s2n4_use),0)&\"MW\"","v":"0MW"}]
[null,"0MW",null,null,{"$f":"ROUND(TRANSPOSE(s1n2_use),0)&\"MW\"","v":"0MW"},null,"0MW",null,null,null,"0MW",null,null,{"$f":"ROUND(TRANSPOSE(s2n2_use),0)&\"MW\"","v":"0MW"},null,"0MW"]
[null,null,null,null,"0MW",null,null,null,null,null,null,null,null,"0MW"]
[]
[null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n6_price),0) &\"/MWh\"","v":"$100/MWh"},null,null,null,null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n6_price),0) &\"/MWh\"","v":"$150/MWh"}]
[null,null,{"$f":"ROUND(TRANSPOSE(s1l1_flow),0)&\"MW\"","v":"-150MW"},null,{"$f":"ROUND(TRANSPOSE(s1l3_flow),0)&\"MW\"","v":"-150MW"},null,null,null,"$52/MWh",null,null,{"$f":"ROUND(TRANSPOSE(s2l1_flow),0)&\"MW\"","v":"-150MW"},null,{"$f":"ROUND(TRANSPOSE(s2l3_flow),0)&\"MW\"","v":"-200MW"},null,null,null,"$55/MWh"]
[null,null,"-150MW",null,"-150MW",null,{"$f":"ROUND(TRANSPOSE(s1l5_flow),0)&\"MW\"","v":"50MW"},null,{"$f":"ROUND(s1n6_demand,0)&\"MW\"","v":"150MW"},null,null,"-150MW",null,"-175MW",null,{"$f":"ROUND(TRANSPOSE(s2l5_flow),0)&\"MW\"","v":"50MW"},null,{"$f":"ROUND(s2n6_demand,0)&\"MW\"","v":"150MW"}]
[null,null,null,{"$f":"ROUND(TRANSPOSE(s1l2_flow),0)&\"MW\"","v":"-150MW"},null,null,"100MW",null,{"$f":"ROUND(TRANSPOSE(s1n6_use),0)&\"MW\"","v":"0MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s2l2_flow),0)&\"MW\"","v":"-150MW"},null,null,"125MW",null,{"$f":"ROUND(TRANSPOSE(s2n6_use),0)&\"MW\"","v":"0MW"}]
[null,null,null,"-150MW",null,null,null,null,"0MW",null,null,null,"-150MW",null,null,null,null,"0MW"]
[]
[]
[null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n3_price),0) &\"/MWh\"","v":"$100/MWh"},null,null,{"$f":"ROUND(TRANSPOSE(s1l4_flow),0)&\"MW\"","v":"100MW"},null,null,null,null,null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n3_price),0) &\"/MWh\"","v":"$150/MWh"},null,null,{"$f":"ROUND(TRANSPOSE(s2l4_flow),0)&\"MW\"","v":"100MW"}]
[null,null,"$100/MWh",null,null,"100MW",null,null,null,null,null,"$105/MWh",null,null,"100MW"]
[null,{"$f":"ROUND(TRANSPOSE(s1u1_dispatch),0)&\"MW\"","v":"200MW"},{"$f":"ROUND(s1n3_demand,0)&\"MW\"","v":"50MW"},null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1u6_dispatch),0)&\"MW\"","v":"150MW"},null,{"$f":"ROUND(TRANSPOSE(s2u1_dispatch),0)&\"MW\"","v":"200MW"},{"$f":"ROUND(s2n3_demand,0)&\"MW\"","v":"50MW"},null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u6_dispatch),0)&\"MW\"","v":"150MW"}]
[null,"200MW",{"$f":"ROUND(TRANSPOSE(s1n3_use),0)&\"MW\"","v":"0MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s1l6_flow),0)&\"MW\"","v":"-50MW"},null,"250MW",null,"200MW",{"$f":"ROUND(TRANSPOSE(s2n3_use),0)&\"MW\"","v":"0MW"},null,null,null,{"$f":"ROUND(TRANSPOSE(s2l6_flow),0)&\"MW\"","v":"-50MW"},null,"300MW"]
[null,null,"0MW",null,{"$f":"\"$\"&ROUND(TRANSPOSE(s1n5_price),0) &\"/MWh\"","v":"$100/MWh"},null,"0MW",null,null,null,null,"0MW",null,{"$f":"\"$\"&ROUND(TRANSPOSE(s2n5_price),0) &\"/MWh\"","v":"$150/MWh"},null,"25MW"]
[null,null,null,null,"$4/MWh",null,null,null,null,null,null,null,null,"$5/MWh"]
[null,null,null,null,{"$f":"ROUND(s1n5_demand,0)&\"MW\"","v":"50MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(s2n5_demand,0)&\"MW\"","v":"50MW"}]
[null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1n5_use),0)&\"MW\"","v":"0MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2n5_use),0)&\"MW\"","v":"0MW"}]
[null,null,{"$f":"ROUND(TRANSPOSE(s1u3_dispatch),0)&\"MW\"","v":"200MW"},null,"0MW",null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u3_dispatch),0)&\"MW\"","v":"200MW"},null,"0MW"]
[null,null,"200MW",null,null,null,null,null,null,null,null,"200MW"]
[null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s1u5_dispatch),0)&\"MW\"","v":"200MW"},null,null,null,null,null,null,null,null,{"$f":"ROUND(TRANSPOSE(s2u5_dispatch),0)&\"MW\"","v":"200MW"}]
[null,null,null,null,null,null,null,"150MW",null,null,null,null,null,null,null,null,"125MW"]
[null,null,"Load"]
[null,"Access Quantity","Access USE","RRP"]
[null,"Physical Quantity","Physical USE","CRMP"]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet end"]

{"sheet":"Model Formulation >","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Radial formulation","index":8,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[[10,2,10,5],[27,2,27,6],[35,2,35,6],[10,13,10,16],[35,13,35,17],[27,13,27,17],[47,13,47,16],[73,13,73,17],[65,13,65,17],[47,2,47,5],[73,2,73,6],[65,2,65,6]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Model formulation - Radial"]
[null,"DO NOT MODIFY"]
[null,"Access Run"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,"USE",null,null,null,null,null,null,"Dispatch",null,null,null,"USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1"]
[null,"Cost coefficient",{"$f":"TRANSPOSE(Radial!$F$34:$F$37) *IF(_xlfn.ANCHORARRAY(C14),-1,1)","v":80},-1000,-700,-550,17500,null,null,null,null,null,"Cost coeffeiceint",{"$f":"TRANSPOSE(Radial!$O$34:$O$37) *IF(_xlfn.ANCHORARRAY(N14),-1,1)","v":50},0,10,1000,17500]
[null,"Is load",{"$f":"TRANSPOSE(Radial!$E$28:$E$31)","v":false},false,false,false,null,null,null,null,null,null,"Is load",{"$f":"TRANSPOSE(Radial!$N$28:$N$31)","v":false},false,false,true]
[null,"Lowerbound",0,0,0,0,0,null,null,null,null,null,"Lowerbound",0,0,0,0,0]
[null,"Solution",116.66666666666666,100,0,33.333333333333343,0,null,null,null,null,null,"Solution",150,100,0,0,0]
[null,"Upperbound",{"$f":"TRANSPOSE(Radial!$C$28:$C$31)","v":300},100,100,100,{"$f":"TRANSPOSE(Radial!$C$21:$C$21)","v":250},null,null,null,null,null,"Upperbound",{"$f":"TRANSPOSE(Radial!$L$28:$L$31)","v":200},100,100,50,{"$f":"TRANSPOSE(Radial!$L$21:$L$21)","v":250}]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C13:G13,C16:G16)","v":-109000.00000000001},null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(N13:R13,N16:R16)","v":7500}]
[]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"IF(C$14,-1,1)","v":1},{"$f":"IF(D$14,-1,1)","v":1},1,1,1,{"$f":"SUMPRODUCT(C$16:G$16,C30:G30)","v":250},"=",{"$f":"Radial!C21","v":250},80,null,"Node 1",{"$f":"IF(N$14,-1,1)","v":1},{"$f":"IF(O$14,-1,1)","v":1},1,-1,1,{"$f":"SUMPRODUCT(N$16:R$16,N30:R30)","v":250},"=",{"$f":"Radial!L21","v":250},50]
[]
[]
[null,"Nodal dispatch constraints",null,null,null,null,null,null,null,null,null,null,"Nodal dispatch constraints"]
[null,"Constraint dispatch based on flow limit",null,null,null,null,null,null,null,null,null,null,"Constraint dispatch based on flow limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual"]
[null,"Transfer limit",null,{"$f":"IF(D$14,-1,1) * Radial!E25","v":1},{"$f":"IF(E$14,-1,1) * Radial!F25","v":0.8},{"$f":"IF(F$14,-1,1) * Radial!G25","v":0.6},null,{"$f":"SUMPRODUCT(C$16:G$16,C38:G38)","v":120},"<=",{"$f":"Radial!C25","v":120},-1050.0000000000005,null,"Transfer limit",null,{"$f":"IF(O$14,-1,1) *Radial!N25","v":1},{"$f":"IF(P$14,-1,1) *Radial!O25","v":1},{"$f":"IF(Q$14,-1,1) *Radial!P25","v":-1},null,{"$f":"SUMPRODUCT(N$16:R$16,N38:R38)","v":100},"<=",{"$f":"Radial!L25","v":100},-40]
[]
[]
[null,"CRM"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,"USE",null,null,null,null,null,null,"Dispatch",null,null,null,"USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1"]
[null,"Cost coefficient",{"$f":"TRANSPOSE(Radial!$G$34:$G$37)*IF(C51:F51,-1,1)","v":80},25,20,12,{"$f":"G13","v":17500},null,null,null,null,null,"Cost coeffeiceint",{"$f":"TRANSPOSE(Radial!$P$34:$P$37)*IF(N51:Q51,-1,1)","v":50},0,10,-15,17500]
[null,"Is load",{"$f":"C14","v":false},{"$f":"D14","v":false},{"$f":"E14","v":false},{"$f":"F14","v":false},null,null,null,null,null,null,"Is load",{"$f":"N14","v":false},{"$f":"O14","v":false},{"$f":"P14","v":false},{"$f":"Q14","v":true}]
[null,"Participation",{"$f":"TRANSPOSE(Radial!$F$28:$F$31)","v":true},true,true,true,null,null,null,null,null,null,"Participation",{"$f":"TRANSPOSE(Radial!$O$28:$O$31)","v":true},true,true,true]
[null,"Lowerbound",{"$f":"IF(C52,C15,C16)","v":0},{"$f":"IF(D52,D15,D16)","v":0},{"$f":"IF(E52,E15,E16)","v":0},{"$f":"IF(F52,F15,F16)","v":0},0,null,null,null,null,null,"Lowerbound",{"$f":"IF(N52,N15,N16)","v":0},{"$f":"IF(O52,O15,O16)","v":0},{"$f":"IF(P52,P15,P16)","v":0},{"$f":"IF(Q52,Q15,Q16)","v":0},0]
[null,"Solution",74.999999999999986,0,75.000000000000014,100,0,null,null,null,null,null,"Solution",150,100,50,50,0]
[null,"Upperbound",{"$f":"IF(C52,C17,C16)","v":300},{"$f":"IF(D52,D17,D16)","v":100},{"$f":"IF(E52,E17,E16)","v":100},{"$f":"IF(F52,F17,F16)","v":100},{"$f":"G17","v":250},null,null,null,null,null,"Upperbound",{"$f":"IF(N52,N17,N16)","v":200},{"$f":"IF(O52,O17,O16)","v":100},{"$f":"IF(P52,P17,P16)","v":100},{"$f":"IF(Q52,Q17,Q16)","v":50},{"$f":"R17","v":250}]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C50:G50,C54:G54)","v":8700},null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(N50:R50,N54:R54)","v":7250}]
[]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"C30","v":1},{"$f":"D30","v":1},1,1,{"$f":"G30","v":1},{"$f":"SUMPRODUCT(C$54:G$54,C68:G68)","v":250},"=",{"$f":"J30","v":250},80,null,"Node 1",{"$f":"N30","v":1},{"$f":"O30","v":1},1,-1,1,{"$f":"SUMPRODUCT(N$54:R$54,N68:R68)","v":250},"=",{"$f":"U30","v":250},50]
[]
[]
[null,"Nodal dispatch constraints",null,null,null,null,null,null,null,null,null,null,"Nodal dispatch constraints"]
[null,"Constraint dispatch based on flow limit",null,null,null,null,null,null,null,null,null,null,"Constraint dispatch based on flow limit",null,null,"* negative coefficient on unit dispatch indicate load. Fetched from is load column"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","USE Node 1","LHS","Sense","RHS","Dual"]
[null,"Node 2 dispatch",null,{"$f":"D38","v":1},{"$f":"E38","v":0.8},0.6,null,{"$f":"SUMPRODUCT(C$54:G$54,C76:G76)","v":120.00000000000001},"<=",{"$f":"J38","v":120},-75,null,"Node 2 dispatch",null,{"$f":"O38","v":1},{"$f":"P38","v":1},{"$f":"Q38","v":-1},null,{"$f":"SUMPRODUCT(N$54:R$54,N76:R76)","v":100},"<=",{"$f":"U38","v":100},-40]
[null,"CRMP",{"$f":"$K$68+ABS(C76)*$K$76","v":80},{"$f":"$K$68+ABS(D76)*$K$76","v":5},20,35,null,null,null,null,null,null,"CRMP",{"$f":"$V$68+ABS(N76)*$V$76","v":50},{"$f":"$V$68+ABS(O76)*$V$76","v":10},10,10]
[]
[null,"Sheet end"]

{"sheet":"Radial IC formulation","index":9,"n_rows":662,"n_cols":30,"rows_kept":662,"cut":false,"hidden":false,"merged":[[76,17,76,25],[67,17,67,25],[67,2,67,10],[76,2,76,10],[49,2,49,7],[49,9,49,10],[10,24,10,25],[36,17,36,25],[27,17,27,25],[49,17,49,22],[49,24,49,25],[10,9,10,10],[27,2,27,10],[36,2,36,10],[10,2,10,7],[10,17,10,22]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Model formulation - Radial with IC"]
[null,"DO NOT MODIFY"]
[null,"Access Run"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,null,null,"Export","USE",null,null,null,null,null,null,null,"Dispatch",null,null,null,null,null,"Export","USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 1","USE Node 1","USE Node 2",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2"]
[null,"Cost coefficient",{"$f":"TRANSPOSE('Radial with IC'!$F43:$F48) * IF(_xlfn.ANCHORARRAY(C14),-1,1)","v":80},-550,-1000,150,-1000,-400,null,17500,17500,null,null,null,null,null,"Cost coeffeiceint",{"$f":"TRANSPOSE('Radial with IC'!$O$43:$O$48) * IF(_xlfn.ANCHORARRAY(R14),-1,1)","v":80},30,0,150,-1000,0,null,17500,17500]
[null,"Is load",{"$f":"TRANSPOSE('Radial with IC'!$E$35:$E$40)","v":false},false,false,false,false,false,null,null,null,null,null,null,null,null,"Is load",{"$f":"TRANSPOSE('Radial with IC'!$N$35:$N$40)","v":false},false,false,false,false,false]
[null,"Lowerbound",0,0,0,0,0,0,{"$f":"-'Radial with IC'!$C$27","v":-90},0,0,null,null,null,null,null,"Lowerbound",0,0,0,0,0,0,{"$f":"-'Radial with IC'!$L$27","v":-300},0,0]
[null,"Solution",400,80,100,120,100,0,-80,0,0,null,null,null,null,null,"Solution",63,50,100,0,100,100,-13,0,0]
[null,"Upperbound",{"$f":" TRANSPOSE('Radial with IC'!$C$35:$C$40)","v":400},100,100,400,100,100,{"$f":"'Radial with IC'!$C$27","v":90},{"$f":"TRANSPOSE('Radial with IC'!$C$23:$C$24)","v":500},300,null,null,null,null,null,"Upperbound",{"$f":" TRANSPOSE('Radial with IC'!$L$35:$L$40)","v":400},100,100,400,100,100,{"$f":"'Radial with IC'!$L$27","v":300},{"$f":"TRANSPOSE('Radial with IC'!$L$23:$L$24)","v":200},213]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C13:K13,C16:K16)","v":-194000},null,null,null,null,null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(R13:Z13,R16:Z16)","v":-93460}]
[]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 1","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"IF(C$14,-1,1)","v":1},{"$f":"IF(D$14,-1,1)","v":1},1,null,null,null,1,1,null,{"$f":"SUMPRODUCT(C$16:K$16,C30:K30)","v":500},"=",{"$f":"'Radial with IC'!C23","v":500},150,null,"Node 1",{"$f":"IF(R$14,-1,1)","v":1},{"$f":"IF(S$14,-1,1)","v":1},1,null,null,null,1,1,null,{"$f":"SUMPRODUCT(R$16:Z$16,R30:Z30)","v":200},"=",{"$f":"'Radial with IC'!L23","v":200},80]
[null,"Node 2",null,null,null,{"$f":"IF(F$14,-1,1)","v":1},{"$f":"IF(G$14,-1,1)","v":1},1,-1,null,1,{"$f":"SUMPRODUCT(C$16:K$16,C31:K31)","v":300},"=",{"$f":"'Radial with IC'!C24","v":300},150,null,"Node 2",null,null,null,{"$f":"IF(U$14,-1,1)","v":1},{"$f":"IF(V$14,-1,1)","v":1},1,-1,null,1,{"$f":"SUMPRODUCT(R$16:Z$16,R31:Z31)","v":213},"=",{"$f":"'Radial with IC'!L24","v":213},80]
[]
[]
[null,"Nodal dispatch constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nodal dispatch constraints"]
[null,"Constraint dispatch based on flow limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constraint dispatch based on flow limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual"]
[null,"Transfer limit 1",null,{"$f":"IF(D$14,-1,1) * 'Radial with IC'!E31","v":1},{"$f":"IF(E$14,-1,1) * 'Radial with IC'!F31","v":0.5},null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$16:K$16,C39:K39)","v":130},"<=",{"$f":"'Radial with IC'!C31","v":130},-700,null,"Transfer limit 1",null,{"$f":"IF(S$14,-1,1) * 'Radial with IC'!N31","v":1},{"$f":"IF(T$14,-1,1) * 'Radial with IC'!O31","v":0.5},null,null,null,null,null,null,{"$f":"SUMPRODUCT(R$16:Z$16,R39:Z39)","v":100},"<=",{"$f":"'Radial with IC'!L31","v":100},-50]
[null,"Transfer limit 2",null,null,null,null,{"$f":"IF(G$14,-1,1) * 'Radial with IC'!H32","v":1},{"$f":"IF(H$14,-1,1) * 'Radial with IC'!I32","v":0.5},null,null,null,{"$f":"SUMPRODUCT(C$16:K$16,C40:K40)","v":100},"<=",{"$f":"'Radial with IC'!C32","v":100},-1100,null,"Transfer limit 2",null,null,null,null,{"$f":"IF(V$14,-1,1) * 'Radial with IC'!Q32","v":1},{"$f":"IF(W$14,-1,1) * 'Radial with IC'!R32","v":0.2},null,null,null,{"$f":"SUMPRODUCT(R$16:Z$16,R40:Z40)","v":120},"<=",{"$f":"'Radial with IC'!L32","v":150},0]
[]
[]
[null,"CRM"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,null,null,"Export","USE",null,null,null,null,null,null,null,"Dispatch",null,null,null,null,null,"Export","USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2"]
[null,"Cost coefficient",{"$f":"TRANSPOSE('Radial with IC'!$G$43:$G$48) * IF(C53:H53,-1,1)","v":100},45,50,200,10,0,null,{"$f":"J13","v":17500},{"$f":"K13","v":17500},null,null,null,null,null,"Cost coeffeiceint",{"$f":"TRANSPOSE('Radial with IC'!$P$43:$P$48) * IF(R53:W53,-1,1)","v":80},30,0,150,10,0,null,{"$f":"Y13","v":17500},{"$f":"Z13","v":17500}]
[null,"Is load",{"$f":"C14","v":false},false,false,false,false,false,null,null,null,null,null,null,null,null,"Is load",{"$f":"R14","v":false},false,false,false,false,false]
[null,"Participation",{"$f":"TRANSPOSE('Radial with IC'!$F$35:$F$40)","v":true},true,true,true,true,true,null,null,null,null,null,null,null,null,"Participation",{"$f":"TRANSPOSE('Radial with IC'!$O$35:$O$40)","v":false},false,false,false,false,true]
[null,"Lowerbound",{"$f":"IF(C54,C15,C16)","v":0},0,0,0,0,0,{"$f":"I15","v":-90},0,0,null,null,null,null,null,"Lowerbound",{"$f":"IF(R54,R15,R16)","v":63},50,100,0,100,0,{"$f":"X15","v":-300},0,0]
[null,"Solution",400,80,100,70,50,100,-80,0,0,null,null,null,null,null,"Solution",63,50,100,0,100,100,-13,0,0]
[null,"Upperbound",{"$f":"IF(C54,C17,C16)","v":400},100,100,400,100,100,{"$f":"I17","v":90},{"$f":"J17","v":500},{"$f":"K17","v":300},null,null,null,null,null,"Upperbound",{"$f":"IF(R54,R17,R16)","v":63},50,100,0,100,100,{"$f":"X17","v":300},{"$f":"Y17","v":200},{"$f":"Z17","v":213}]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C52:K52,C56:K56)","v":63100},null,null,null,null,null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(R52:Z52,R56:Z56)","v":7540}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"C30","v":1},{"$f":"D30","v":1},1,null,null,null,{"$f":"I30","v":1},{"$f":"J30","v":1},null,{"$f":"SUMPRODUCT(C$56:K$56,C70:K70)","v":500},"=",{"$f":"N30","v":500},200,null,"Node 1",{"$f":"R30","v":1},{"$f":"S30","v":1},1,null,null,null,1,1,null,{"$f":"SUMPRODUCT(R$56:Z$56,R70:Z70)","v":200},"=",{"$f":"AC30","v":200},0]
[null,"Node 2",null,null,null,{"$f":"F31","v":1},{"$f":"G31","v":1},1,{"$f":"I31","v":-1},null,{"$f":"K31","v":1},{"$f":"SUMPRODUCT(C$56:K$56,C71:K71)","v":300},"=",{"$f":"N31","v":300},200,null,"Node 2",null,null,null,{"$f":"U31","v":1},{"$f":"V31","v":1},1,-1,null,1,{"$f":"SUMPRODUCT(R$56:Z$56,R71:Z71)","v":213},"=",{"$f":"AC31","v":213},0]
[]
[]
[null,"Nodal dispatch constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nodal dispatch constraints"]
[null,"Constraint dispatch based on flow limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constraint dispatch based on flow limit",null,null,"* negative coefficient on unit dispatch indicate load. Fetched from is load column"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Line 3","USE Node 1","USE Node 2","LHS","Sense","RHS","Dual"]
[null,"Transfer limit 1",null,{"$f":"D39","v":1},{"$f":"E39","v":0.5},null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$56:K$56,C79:K79)","v":130},"<=",{"$f":"N39","v":130},-155,null,"Transfer limit 1",null,{"$f":"S39","v":1},{"$f":"T39","v":0.5},null,null,null,null,null,null,{"$f":"SUMPRODUCT(R$56:Z$56,R79:Z79)","v":100},"<=",{"$f":"AC39","v":100},0]
[null,"Transfer limit 2",null,null,null,null,{"$f":"G40","v":1},{"$f":"H40","v":0.5},null,null,null,{"$f":"SUMPRODUCT(C$56:K$56,C80:K80)","v":100},"<=",{"$f":"N40","v":100},-190,null,"Transfer limit 2",null,null,null,null,{"$f":"V40","v":1},{"$f":"W40","v":0.2},null,null,null,{"$f":"SUMPRODUCT(R$56:Z$56,R80:Z80)","v":120},"<=",{"$f":"AC40","v":150},0]
[null,"CRMP",{"$f":"$O$70+ABS(C79)*$O$79","v":200},{"$f":"$O$70+ABS(D79)*$O$79","v":45},122.5,{"$f":"$O$71+ABS(F80)*$O$80","v":200},{"$f":"$O$71+ABS(G80)*$O$80","v":10},105,null,null,null,null,null,null,null,null,"CRMP",{"$f":"$AD$70+ABS(R79)*$AD$79","v":0},{"$f":"$AD$70+ABS(S79)*$AD$79","v":0},0,{"$f":"$AD$71+ABS(U80)*$AD$80","v":0},{"$f":"$AD$71+ABS(V80)*$AD$80","v":0},0]
[]
[null,"Sheet end"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0]

{"sheet":"Mesh formulation","index":10,"n_rows":144,"n_cols":48,"rows_kept":144,"cut":false,"hidden":false,"merged":[[134,2,134,19],[134,26,134,43],[121,26,121,43],[108,26,108,43],[73,26,73,43],[73,2,73,19],[108,2,108,19],[121,2,121,19],[90,2,90,7],[90,8,90,13],[90,14,90,19],[90,26,90,31],[30,2,30,7],[30,8,30,13],[30,14,30,19],[90,32,90,37],[90,38,90,43],[30,26,30,31],[30,32,30,37],[30,38,30,43],[47,26,47,43],[60,26,60,43],[60,2,60,19],[47,2,47,19]]}
[null,"ENDGAME Economics | AEMC transmission access reform | Stylised model"]
[null,"Model formulation - Mesh"]
[null,"DO NOT MODIFY"]
[null,"Powerflow Data"]
[]
[null,"Susceptance Matrix",1,2,3,4,5,6,null,"Y Bus Matrix",1,2,3,4,5,6]
[null,1,0,-10,0,0,0,0,null,1,{"$f":"IF($J7=K$6,-SUM(C$7:C$12),C7)","v":10},{"$f":"IF($J7=L$6,-SUM(D$7:D$12),D7)","v":-10},0,0,0,0]
[null,2,-10,0,-10,-10,0,0,null,2,{"$f":"IF($J8=K$6,-SUM(C$7:C$12),C8)","v":-10},30,-10,-10,0,0]
[null,3,0,-10,0,0,0,0,null,3,0,-10,10,0,0,0]
[null,4,0,-10,0,0,-10,-10,null,4,0,-10,0,30,-10,-10]
[null,5,0,0,0,-10,0,-10,null,5,0,0,0,-10,20,-10]
[null,6,0,0,0,-10,-10,0,null,6,0,0,0,-10,-10,20]
[]
[]
[null,"Flow specification","From","To","Susceptance","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6"]
[null,"Line 1",2,1,{"$f":"VLOOKUP(C16,B$7:H$12,MATCH(D16,B$6:H$6,0),FALSE)","v":-10},-1,1,null,null,null,null,null,"Voltage Base Scalar",500]
[null,"Line 2",2,3,-10,null,1,-1]
[null,"Line 3",4,2,-10,null,-1,null,1]
[null,"Line 4",5,4,-10,null,null,null,-1,1]
[null,"Line 5",6,4,-10,null,null,null,-1,null,1]
[null,"Line 6",6,5,-10,null,null,null,null,-1,1]
[]
[]
[null,"Access Run"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,null,null,"Phase Angles",null,null,null,null,null,"USE",null,null,null,null,null,null,null,null,null,null,null,"Dispatch",null,null,null,null,null,"Phase Angles",null,null,null,null,null,"USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6"]
[null,"Cost coefficient",{"$f":"TRANSPOSE(Mesh!$F$48:$F$53)*IF(_xlfn.ANCHORARRAY(C34),-1,1)","v":60},105,50,100,-1000,-400,null,null,null,null,null,null,17500,17500,17500,17500,17500,17500,null,null,null,null,null,"Cost coefficient",{"$f":"TRANSPOSE(Mesh!$O$48:$O$53)*IF(_xlfn.ANCHORARRAY(AA34),-1,1)","v":60},100,50,150,-1000,-400,null,null,null,null,null,null,17500,17500,17500,17500,17500,17500]
[null,"Is load",{"$f":"TRANSPOSE(Mesh!$E$40:$E$45)","v":false},false,false,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is load",{"$f":"TRANSPOSE(Mesh!$N$40:$N$45)","v":false},false,false,false,false,false]
[null,"Lowerbound",0,0,0,0,0,0,-1000,-1000,-1000,-1000,-1000,-1000,0,0,0,0,0,0,null,null,null,null,null,"Lowerbound",0,0,0,0,0,0,-1000,-1000,-1000,-1000,-1000,-1000,0,0,0,0,0,0]
[null,"Solution",200,0,200,100,200,150,-3.0000000000000002E-2,0,-0.03,2.9999999999963629E-2,9.9999999999818186E-3,2.0000000000000007E-2,0,0,0,0,0,0,null,null,null,null,null,"Solution",200,50,200,50,200,150,-3.0000000000000002E-2,0,-0.03,3.9999999999963627E-2,1.9999999999981817E-2,3.0000000000000006E-2,0,0,0,0,0,0]
[null,"Upperbound",{"$f":"TRANSPOSE(Mesh!$C$40:$C$45)","v":200},300,200,400,200,250,1000,1000,1000,1000,1000,1000,{"$f":"TRANSPOSE(Mesh!$C$23:$C$28)","v":50},150,50,400,50,150,null,null,null,null,null,"Upperbound",{"$f":"TRANSPOSE(Mesh!$L$40:$L$45)","v":200},300,200,300,200,300,1000,1000,1000,1000,1000,1000,{"$f":"TRANSPOSE(Mesh!$L$23:$L$28)","v":50},150,50,400,50,150]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C33:T33,C36:T36)","v":-228000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(AA33:AR33,AA36:AR36)","v":-225500}]
[]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"IF(C$34,-1,1)","v":1},null,null,null,null,null,{"$f":"K7*$N$16","v":5000},{"$f":"L7*$N$16","v":-5000},0,0,0,0,1,null,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C50:T50)","v":50},"=",{"$f":"Mesh!C23","v":50},100,null,"Node 1",{"$f":"IF(AA$34,-1,1)","v":1},null,null,null,null,null,{"$f":"K7*$N$16","v":5000},{"$f":"L7*$N$16","v":-5000},0,0,0,0,1,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA50:AR50)","v":50},"=",{"$f":"Mesh!L23","v":50},100]
[null,"Node 2",null,{"$f":"IF(D$34,-1,1)","v":1},null,null,null,null,{"$f":"K8*$N$16","v":-5000},15000,-5000,-5000,0,0,null,1,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C51:T51)","v":150.00000000018187},"=",{"$f":"Mesh!C24","v":150},100,null,"Node 2",null,{"$f":"IF(AB$34,-1,1)","v":1},null,null,null,null,{"$f":"K8*$N$16","v":-5000},15000,-5000,-5000,0,0,null,1,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA51:AR51)","v":150.00000000018187},"=",{"$f":"Mesh!L24","v":150},100]
[null,"Node 3",null,null,{"$f":"IF(E$34,-1,1)","v":1},null,null,null,0,-5000,5000,0,0,0,null,null,1,null,null,null,50,"=",{"$f":"Mesh!C25","v":50},100,null,"Node 3",null,null,{"$f":"IF(AC$34,-1,1)","v":1},null,null,null,0,-5000,5000,0,0,0,null,null,1,null,null,null,50,"=",{"$f":"Mesh!L25","v":50},100]
[null,"Node 4",null,null,null,{"$f":"IF(F$34,-1,1)","v":1},null,null,0,-5000,0,15000,-5000,-5000,null,null,null,1,null,null,399.99999999954525,"=",{"$f":"Mesh!C26","v":400},100,null,"Node 4",null,null,null,{"$f":"IF(AD$34,-1,1)","v":1},null,null,0,-5000,0,15000,-5000,-5000,null,null,null,1,null,null,399.99999999954537,"=",{"$f":"Mesh!L26","v":400},150]
[null,"Node 5",null,null,null,null,{"$f":"IF(G$34,-1,1)","v":1},null,0,0,0,-5000,10000,-5000,null,null,null,null,1,null,50.000000000000014,"=",{"$f":"Mesh!C27","v":50},-900,null,"Node 5",null,null,null,null,{"$f":"IF(AE$34,-1,1)","v":1},null,0,0,0,-5000,10000,-5000,null,null,null,null,1,null,50,"=",{"$f":"Mesh!L27","v":50},-950]
[null,"Node 6",null,null,null,null,null,{"$f":"IF(H$34,-1,1)","v":1},0,0,0,-5000,-5000,10000,null,null,null,null,null,1,150.00000000027285,"=",{"$f":"Mesh!C28","v":150},-400,null,"Node 6",null,null,null,null,null,{"$f":"IF(AF$34,-1,1)","v":1},0,0,0,-5000,-5000,10000,null,null,null,null,null,1,150.00000000027285,"=",{"$f":"Mesh!L28","v":150},-400]
[]
[]
[null,"Line export limit constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line export limit constraints"]
[null,"Enforce line rating limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce line rating limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS",null,null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS"]
[null,"Line 1",null,null,null,null,null,null,{"$f":"$E16*F16*$N$16","v":5000},{"$f":"$E16*G16*$N$16","v":-5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C63:T63)","v":-150},"<=",{"$f":"Mesh!C32","v":200},null,null,"Line 1",null,null,null,null,null,null,{"$f":"$E16*F16*$N$16","v":5000},{"$f":"$E16*G16*$N$16","v":-5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA63:AR63)","v":-150},"<=",{"$f":"Mesh!L32","v":200}]
[null,"Line 2",null,null,null,null,null,null,{"$f":"$E17*F17*$N$16","v":0},-5000,5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C64:T64)","v":-150},"<=",{"$f":"Mesh!C33","v":200},null,null,"Line 2",null,null,null,null,null,null,{"$f":"$E17*F17*$N$16","v":0},-5000,5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA64:AR64)","v":-150},"<=",{"$f":"Mesh!L33","v":200}]
[null,"Line 3",null,null,null,null,null,null,0,5000,0,-5000,0,0,null,null,null,null,null,null,-149.99999999981813,"<=",{"$f":"Mesh!C34","v":250},null,null,"Line 3",null,null,null,null,null,null,0,5000,0,-5000,0,0,null,null,null,null,null,null,-199.99999999981813,"<=",{"$f":"Mesh!L34","v":200}]
[null,"Line 4",null,null,null,null,null,null,0,0,0,5000,-5000,0,null,null,null,null,null,null,99.999999999909036,"<=",{"$f":"Mesh!C35","v":100},null,null,"Line 4",null,null,null,null,null,null,0,0,0,5000,-5000,0,null,null,null,null,null,null,99.999999999909051,"<=",{"$f":"Mesh!L35","v":100}]
[null,"Line 5",null,null,null,null,null,null,0,0,0,5000,0,-5000,null,null,null,null,null,null,49.999999999818087,"<=",{"$f":"Mesh!C36","v":200},null,null,"Line 5",null,null,null,null,null,null,0,0,0,5000,0,-5000,null,null,null,null,null,null,49.999999999818101,"<=",{"$f":"Mesh!L36","v":200}]
[null,"Line 6",null,null,null,null,null,null,0,0,0,0,5000,-5000,null,null,null,null,null,null,-50.000000000090949,"<=",{"$f":"Mesh!C37","v":200},null,null,"Line 6",null,null,null,null,null,null,0,0,0,0,5000,-5000,null,null,null,null,null,null,-50.000000000090949,"<=",{"$f":"Mesh!L37","v":200}]
[]
[]
[null,"Line import limit cosntraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line import limit cosntraints"]
[null,"Enforce line rating limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce line rating limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS",null,null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS"]
[null,"Line 1",null,null,null,null,null,null,{"$f":"-$E16*F16*$N$16","v":-5000},{"$f":"-$E16*G16*$N$16","v":5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C76:T76)","v":150},"<=",{"$f":"Mesh!C32","v":200},null,null,"Line 1",null,null,null,null,null,null,{"$f":"-$E16*F16*$N$16","v":-5000},{"$f":"-$E16*G16*$N$16","v":5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA76:AR76)","v":150},"<=",{"$f":"Mesh!L32","v":200}]
[null,"Line 2",null,null,null,null,null,null,{"$f":"-$E17*F17*$N$16","v":0},5000,-5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$36:T$36,C77:T77)","v":150},"<=",{"$f":"Mesh!C33","v":200},null,null,"Line 2",null,null,null,null,null,null,{"$f":"-$E17*F17*$N$16","v":0},5000,-5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$36:AR$36,AA77:AR77)","v":150},"<=",{"$f":"Mesh!L33","v":200}]
[null,"Line 3",null,null,null,null,null,null,0,-5000,0,5000,0,0,null,null,null,null,null,null,149.99999999981813,"<=",{"$f":"Mesh!C34","v":250},null,null,"Line 3",null,null,null,null,null,null,0,-5000,0,5000,0,0,null,null,null,null,null,null,199.99999999981813,"<=",{"$f":"Mesh!L34","v":200}]
[null,"Line 4",null,null,null,null,null,null,0,0,0,-5000,5000,0,null,null,null,null,null,null,-99.999999999909036,"<=",{"$f":"Mesh!C35","v":100},null,null,"Line 4",null,null,null,null,null,null,0,0,0,-5000,5000,0,null,null,null,null,null,null,-99.999999999909051,"<=",{"$f":"Mesh!L35","v":100}]
[null,"Line 5",null,null,null,null,null,null,0,0,0,-5000,0,5000,null,null,null,null,null,null,-49.999999999818087,"<=",{"$f":"Mesh!C36","v":200},null,null,"Line 5",null,null,null,null,null,null,0,0,0,-5000,0,5000,null,null,null,null,null,null,-49.999999999818101,"<=",{"$f":"Mesh!L36","v":200}]
[null,"Line 6",null,null,null,null,null,null,0,0,0,0,-5000,5000,null,null,null,null,null,null,50.000000000090949,"<=",{"$f":"Mesh!C37","v":200},null,null,"Line 6",null,null,null,null,null,null,0,0,0,0,-5000,5000,null,null,null,null,null,null,50.000000000090949,"<=",{"$f":"Mesh!L37","v":200}]
[]
[]
[null,"CRM"]
[]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[]
[]
[]
[]
[null,null,"Dispatch",null,null,null,null,null,"Phase Angles",null,null,null,null,null,"USE",null,null,null,null,null,null,null,null,null,null,null,"Dispatch",null,null,null,null,null,"Phase Angles",null,null,null,null,null,"USE"]
[null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6",null,null,null,null,null,"Variable specification","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6"]
[null,"Cost coefficient",{"$f":"TRANSPOSE(Mesh!G48:$G$53)*IF(C94:H94,-1,1)","v":60},105,50,100,4,10,null,null,null,null,null,null,{"$f":"O33","v":17500},{"$f":"P33","v":17500},17500,17500,17500,17500,null,null,null,null,null,"Cost coefficient",{"$f":"TRANSPOSE(Mesh!$P$48:$P$53)*IF(AA94:AF94,-1,1)","v":60},105,50,110,5,10,null,null,null,null,null,null,{"$f":"AM33","v":17500},{"$f":"AN33","v":17500},17500,17500,17500,17500]
[null,"Is load",{"$f":"C34","v":false},{"$f":"D34","v":false},false,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is load",{"$f":"AA34","v":false},{"$f":"AB34","v":false},false,false,false,false]
[null,"Participation",{"$f":"TRANSPOSE(Mesh!$F$40:$F$45)","v":false},true,false,true,true,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Participation",{"$f":"TRANSPOSE(Mesh!$O$40:$O$45)","v":false},true,false,true,true,true]
[null,"Lowerbound",{"$f":"IF(C95,C35,C36)","v":200},{"$f":"IF(D95,D35,D36)","v":0},200,0,0,0,{"$f":"I35","v":-1000},{"$f":"J35","v":-1000},-1000,-1000,-1000,-1000,0,0,0,0,0,0,null,null,null,null,null,"Lowerbound",{"$f":"IF(AA95,AA35,AA36)","v":200},{"$f":"IF(AB95,AB35,AB36)","v":0},{"$f":"IF(AC95,AC35,AC36)","v":200},{"$f":"IF(AD95,AD35,AD36)","v":0},{"$f":"IF(AE95,AE35,AE36)","v":0},{"$f":"IF(AF95,AF35,AF36)","v":0},{"$f":"AG35","v":-1000},{"$f":"AH35","v":-1000},-1000,-1000,-1000,-1000,0,0,0,0,0,0]
[null,"Solution",200,0,200,50.000000000000043,150,250,-0.03,0,-0.03,2.9999999999963625E-2,9.9999999999818203E-3,1.0000000000000019E-2,0,0,0,0,0,0,null,null,null,null,null,"Solution",200,25.000000000000021,200,0,125,300,-0.03,0,-0.03,3.499999999996363E-2,1.499999999998182E-2,1.0000000000000018E-2,0,0,0,0,0,0]
[null,"Upperbound",{"$f":"IF(C95,C37,C36)","v":200},{"$f":"IF(D95,D37,D36)","v":300},200,400,200,250,{"$f":"I37","v":1000},{"$f":"J37","v":1000},1000,1000,1000,1000,50,150,50,400,50,150,null,null,null,null,null,"Upperbound",{"$f":"IF(AA95,AA37,AA36)","v":200},{"$f":"IF(AB95,AB37,AB36)","v":300},200,300,200,300,{"$f":"AG37","v":1000},{"$f":"AH37","v":1000},1000,1000,1000,1000,50,150,50,400,50,150]
[]
[]
[null,"Sense","Minimisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sense","Minimisation"]
[]
[null,"Objective value",{"$f":"SUMPRODUCT(C93:T93,C97:T97)","v":30100.000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Objective value",{"$f":"SUMPRODUCT(AA93:AR93,AA97:AR97)","v":28250}]
[]
[]
[null,"Supply demand balance constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supply demand balance constraints"]
[null,"Enforce dispatch to meet demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce dispatch to meet demand"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS","Dual",null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS","Dual"]
[null,"Node 1",{"$f":"C50","v":1},null,null,null,null,null,{"$f":"I50","v":5000},{"$f":"J50","v":-5000},0,0,0,0,{"$f":"O50","v":1},null,null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C111:T111)","v":50},"=",{"$f":"W50","v":50},100,null,"Node 1",{"$f":"AA50","v":1},null,null,null,null,null,{"$f":"AG50","v":5000},{"$f":"AH50","v":-5000},0,0,0,0,{"$f":"AM50","v":1},null,null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA111:AR111)","v":50},"=",{"$f":"AU50","v":50},105]
[null,"Node 2",null,{"$f":"D51","v":1},null,null,null,null,{"$f":"I51","v":-5000},15000,-5000,-5000,0,0,null,{"$f":"P51","v":1},null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C112:T112)","v":150.00000000018187},"=",{"$f":"W51","v":150},100,null,"Node 2",null,{"$f":"AB51","v":1},null,null,null,null,{"$f":"AG51","v":-5000},15000,-5000,-5000,0,0,null,{"$f":"AN51","v":1},null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA112:AR112)","v":150.00000000018184},"=",{"$f":"AU51","v":150},105]
[null,"Node 3",null,null,{"$f":"E52","v":1},null,null,null,0,-5000,5000,0,0,0,null,null,{"$f":"Q52","v":1},null,null,null,50,"=",50,100,null,"Node 3",null,null,{"$f":"AC52","v":1},null,null,null,{"$f":"AG52","v":0},-5000,5000,0,0,0,null,null,{"$f":"AO52","v":1},null,null,null,50,"=",50,105]
[null,"Node 4",null,null,null,{"$f":"F53","v":1},null,null,0,-5000,0,15000,-5000,-5000,null,null,null,{"$f":"R53","v":1},null,null,399.9999999995452,"=",400,100,null,"Node 4",null,null,null,{"$f":"AD53","v":1},null,null,{"$f":"AG53","v":0},-5000,0,15000,-5000,-5000,null,null,null,{"$f":"AP53","v":1},null,null,399.99999999954525,"=",400,105]
[null,"Node 5",null,null,null,null,{"$f":"G54","v":1},null,0,0,0,-5000,10000,-5000,null,null,null,null,{"$f":"S54","v":1},null,49.999999999999972,"=",50,4,null,"Node 5",null,null,null,null,{"$f":"AE54","v":1},null,{"$f":"AG54","v":0},0,0,-5000,10000,-5000,null,null,null,null,{"$f":"AQ54","v":1},null,49.999999999999943,"=",50,5]
[null,"Node 6",null,null,null,null,null,{"$f":"H55","v":1},0,0,0,-5000,-5000,10000,null,null,null,null,null,{"$f":"T55","v":1},150.00000000027296,"=",150,52,null,"Node 6",null,null,null,null,null,{"$f":"AF55","v":1},{"$f":"AG55","v":0},0,0,-5000,-5000,10000,null,null,null,null,null,{"$f":"AR55","v":1},150.00000000027291,"=",150,55]
[]
[]
[null,"Line export limit constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line export limit constraints"]
[null,"Enforce line rating limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce line rating limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS",null,null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS"]
[null,"Line 1",null,null,null,null,null,null,{"$f":"I63","v":5000},{"$f":"J63","v":-5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C124:T124)","v":-150},"<=",{"$f":"W63","v":200},null,null,"Line 1",null,null,null,null,null,null,{"$f":"AG63","v":5000},{"$f":"AH63","v":-5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA124:AR124)","v":-150},"<=",{"$f":"AU63","v":200}]
[null,"Line 2",null,null,null,null,null,null,{"$f":"I64","v":0},-5000,5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C125:T125)","v":-150},"<=",{"$f":"W64","v":200},null,null,"Line 2",null,null,null,null,null,null,{"$f":"AG64","v":0},-5000,5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA125:AR125)","v":-150},"<=",{"$f":"AU64","v":200}]
[null,"Line 3",null,null,null,null,null,null,0,5000,0,-5000,0,0,null,null,null,null,null,null,-149.99999999981813,"<=",250,null,null,"Line 3",null,null,null,null,null,null,{"$f":"AG65","v":0},5000,0,-5000,0,0,null,null,null,null,null,null,-174.99999999981816,"<=",200]
[null,"Line 4",null,null,null,null,null,null,0,0,0,5000,-5000,0,null,null,null,null,null,null,99.999999999909022,"<=",100,null,null,"Line 4",null,null,null,null,null,null,{"$f":"AG66","v":0},0,0,5000,-5000,0,null,null,null,null,null,null,99.999999999909065,"<=",100]
[null,"Line 5",null,null,null,null,null,null,0,0,0,5000,0,-5000,null,null,null,null,null,null,99.99999999981803,"<=",200,null,null,"Line 5",null,null,null,null,null,null,{"$f":"AG67","v":0},0,0,5000,0,-5000,null,null,null,null,null,null,124.99999999981807,"<=",200]
[null,"Line 6",null,null,null,null,null,null,0,0,0,0,5000,-5000,null,null,null,null,null,null,-9.0999208168796031E-11,"<=",200,null,null,"Line 6",null,null,null,null,null,null,{"$f":"AG68","v":0},0,0,0,5000,-5000,null,null,null,null,null,null,24.999999999909008,"<=",200]
[]
[]
[null,"Line import limit cosntraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line import limit cosntraints"]
[null,"Enforce line rating limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enforce line rating limit"]
[]
[null,null,"LHS Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LHS Coefficient"]
[null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS",null,null,"Constraint index","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Theta 1","Theta 2","Theta 3","Theta 4","Theta 5","Theta 6","USE Node 1","USE Node 2","USE Node 3","USE Node 4","USE Node 5","USE Node 6","LHS","Sense","RHS"]
[null,"Line 1",null,null,null,null,null,null,{"$f":"I76","v":-5000},{"$f":"J76","v":5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C137:T137)","v":150},"<=",{"$f":"W76","v":200},null,null,"Line 1",null,null,null,null,null,null,{"$f":"AG76","v":-5000},{"$f":"AH76","v":5000},0,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA137:AR137)","v":150},"<=",{"$f":"AU76","v":200}]
[null,"Line 2",null,null,null,null,null,null,{"$f":"I77","v":0},5000,-5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(C$97:T$97,C138:T138)","v":150},"<=",{"$f":"W77","v":200},null,null,"Line 2",null,null,null,null,null,null,{"$f":"AG77","v":0},5000,-5000,0,0,0,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AA$97:AR$97,AA138:AR138)","v":150},"<=",{"$f":"AU77","v":200}]
[null,"Line 3",null,null,null,null,null,null,0,-5000,0,5000,0,0,null,null,null,null,null,null,149.99999999981813,"<=",250,null,null,"Line 3",null,null,null,null,null,null,{"$f":"AG78","v":0},-5000,0,5000,0,0,null,null,null,null,null,null,174.99999999981816,"<=",200]
[null,"Line 4",null,null,null,null,null,null,0,0,0,-5000,5000,0,null,null,null,null,null,null,-99.999999999909022,"<=",100,null,null,"Line 4",null,null,null,null,null,null,{"$f":"AG79","v":0},0,0,-5000,5000,0,null,null,null,null,null,null,-99.999999999909065,"<=",100]
[null,"Line 5",null,null,null,null,null,null,0,0,0,-5000,0,5000,null,null,null,null,null,null,-99.99999999981803,"<=",200,null,null,"Line 5",null,null,null,null,null,null,{"$f":"AG80","v":0},0,0,-5000,0,5000,null,null,null,null,null,null,-124.99999999981807,"<=",200]
[null,"Line 6",null,null,null,null,null,null,0,0,0,0,-5000,5000,null,null,null,null,null,null,9.0999208168796031E-11,"<=",200,null,null,"Line 6",null,null,null,null,null,null,{"$f":"AG81","v":0},0,0,0,-5000,5000,null,null,null,null,null,null,-24.999999999909008,"<=",200]
[]
[null,"Sheet end"]