{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Model -->","Auction Simulation","Data -->","Demand Curve Parameters","LOLE Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":41,"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":"Instructions","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Description:"]
[]
[null,"This workbook contains a simplified version of The Brattle Group's proprietary simulation model used to test demand curve performance in PJM.  All cells highlighted in green are user inputs; all cells highlighted in orange are user outputs.  Please see the instructions below on how to run the simplified model and how to create a user-defined demand curve."]
[]
[null,"Instructions:"]
[]
[null,"Only adjust the input cells, highlighted in green, otherwise the model could break."]
[]
[null,"How To Run a Simulation:",null,"Cell Color Coding:"]
[null,"1)  Go to the [Auction Simulation] tab",null,"user input"]
[null,"2)  Select the appropriate demand curve from the pre-populated list in cell B4",null,"user input error"]
[null,"    Note: Use the scroll bar in the Demand Curve list to view all available selections",null,"user output"]
[null,"3)  Adjust the total offer quantity in cell  D4"]
[null,"4)  Click the \"Calculate Clearing Price\" button to run the auction"]
[]
[null,"How To Create a User-Defined Demand Curve:"]
[null,"1)  Go to the [Demand Curve Parameters] tab"]
[null,"2)  Set the price for the first point in cell F5"]
[null,"3)  Fill in the remaining quantities and prices."]
[null,"Note:"]
[null,"i.  The user-defined curve can handle up to 10 points"]
[null,"ii.  Quantities need to be inputted as a % of RR and in ascending order"]
[null,"iii.  Prices need to be inputted as a % of Net CONE and in descending order"]
[null,"iv.  See [Auction Simulation] tab, cells B40 and B42, for RR and Net CONE values"]
[null,"4)  Go to the [Auction Simulation] tab and select \"User-Defined Curve\" from the Demand Curve list, as described above in Step 2 of \"How To Run a Simulation\""]
[null,"5) Run the simulation, as described above in Steps 3 and 4 of \"How to Run a Simulation\""]
[]
[null,"Notes:"]
[]
[null,"The supply curve core shape is based on historical PJM offers, using a smoothed version of the supply curve from a specific historical auction.  This supply curve shape does not change in this simplified model; however, the user can shift the curve right or left by adjusting the \"total offer quantity\", as described above in Step 3 of \"How to Run a Simulation\"."]
[]
[null,"This model is not a Monte Carlo simulation model.  The results contained herein are not intended to exactly replicate those presented by The Brattle Group in our report or other stakeholder materials, as those results came from a more complex Monte Carlo analysis that tested demand curve performance over a distribution of draws with shocks to supply and demand."]

{"sheet":"Model -->","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Auction Simulation","index":2,"n_rows":81,"n_cols":24,"rows_kept":81,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Inputs",null,null,null,null,null,"Output",null,null,null,null,null,null,null,null,null,null,null,"Clearing Automation",null,null,null,"Demand Curve Options"]
[null,"Demand Curve Selection\n(Drop-down Below)",null,"Total Offer Quantity\n(MW must be > 150,000)",null,null,null,"Auction Clearing Results",null,null,null,"Input Demand Curve Definition",null,null,null,"Corresponding Demand Curve Parameters",null,null,null,"Initial Quantity",{"$f":"D4-$M$62","v":113841.43355955728},160101.43355955728]
[null,"Current VRR Curve",null,160000,null,null,null,null,"Current Run","Previous Run",null,null,"Quantity (UCAP RM %)","Price (% of Net Cone)",null,"MW","LOLE"," ($/MW-d)",null,"SC Price",{"$f":"Interpolate($P$19:$P$69,$N$19:$N$69,$V$3)","v":700.44380000000001},null,null,"User-Defined Curve"]
[null,null,null,null,null,null,null,"Price ($/MW-d)",495.8,495.8,null,"Point 1",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L5,FIND(\" \",$L5)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),\"\")","v":0},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L5,FIND(\" \",$L5)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),\"\")","v":1.5},null,{"$f":"IF(ISNUMBER(M5),0,\"\")","v":0},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P5)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P5)),\"\")","v":0},{"$f":"IFERROR($N5*$B$42,\"\")","v":495.79499999999996},null,"DC Price",{"$f":"Interpolate($P$5:$P$14,$R$5:$R$14,$V$3)","v":495.79500000000002},null,null,"Current VRR Curve"]
[null,null,null,null,null,null,null,"LOLE",{"$f":"IF(Interpolate('LOLE Data'!$H$6:$H$21,'LOLE Data'!$B$6:$B$21,I$9)=\"X is Too Low\",\"Below 1-in-5\",\"1-in-\"&ROUND(1/Interpolate('LOLE Data'!$H$6:$H$21,'LOLE Data'!$B$6:$B$21,I$9),1))","v":"Below 1-in-5"},{"$f":"IF(Interpolate('LOLE Data'!$H$6:$H$21,'LOLE Data'!$B$6:$B$21,J$9)=\"X is Too Low\",\"Below 1-in-5\",\"1-in-\"&ROUND(1/Interpolate('LOLE Data'!$H$6:$H$21,'LOLE Data'!$B$6:$B$21,J$9),1))","v":"Below 1-in-5"},null,"Point 2",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L6,FIND(\" \",$L6)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M5)","v":6.191E-2},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L6,FIND(\" \",$L6)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N5)","v":1.5},null,{"$f":"IFERROR((M6+1)*'Auction Simulation'!$B$41,\"\")","v":161816.60676599998},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P6)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P6)),\"\")","v":9.4174016546746259E-3},{"$f":"IFERROR($N6*$B$42,\"\")","v":495.79499999999996},null,"Check",{"$f":"U5-U4","v":-204.64879999999999},null,null,"Brattle Proposed"]
[null,null,null,null,null,null,null,null,null,null,null,"Point 3",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L7,FIND(\" \",$L7)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M6)","v":9.9629999999999996E-2},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L7,FIND(\" \",$L7)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N6)","v":1},null,{"$f":"IFERROR((M7+1)*'Auction Simulation'!$B$41,\"\")","v":167564.47843799999},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P7)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P7)),\"\")","v":"X is Too High"},330.53,null,null,null,null,null,"PJM Proposed"]
[null,null,null,null,null,null,null,"Demand Curve","Current VRR Curve","Current VRR Curve",null,"Point 4",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L8,FIND(\" \",$L8)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M7)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L8,FIND(\" \",$L8)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N7)","v":0.2},null,{"$f":"IFERROR((M8+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P8)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P8)),\"\")","v":"X is Too High"},66.105999999999995,null,null,null,null,null,"Vertical at RR"]
[null,null,null,null,null,null,null,"UCAP Quantity (MW)",160101.43355955728,160101.43355955728,null,"Point 5",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L9,FIND(\" \",$L9)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M8)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L9,FIND(\" \",$L9)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N8)","v":0},null,{"$f":"IFERROR((M9+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P9)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P9)),\"\")","v":"X is Too High"},0,null,null,null,null,null,"ISO-NE"]
[null,null,null,null,null,null,null,null,null,null,null,"Point 6",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L10,FIND(\" \",$L10)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M9)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L10,FIND(\" \",$L10)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N9)","v":0},null,{"$f":"IFERROR((M10+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P10)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P10)),\"\")","v":"X is Too High"},0,null,null,null,null,null,"NYISO"]
[null,null,null,null,null,null,null,null,null,null,null,"Point 7",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L11,FIND(\" \",$L11)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M10)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L11,FIND(\" \",$L11)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N10)","v":0},null,{"$f":"IFERROR((M11+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P11)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P11)),\"\")","v":"X is Too High"},0]
[null,null,null,null,null,null,null,null,null,null,null,"Point 8",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L12,FIND(\" \",$L12)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M11)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L12,FIND(\" \",$L12)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N11)","v":0},null,{"$f":"IFERROR((M12+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P12)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P12)),\"\")","v":"X is Too High"},0]
[null,null,null,null,null,null,null,null,null,null,null,"Point 9",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L13,FIND(\" \",$L13)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M12)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L13,FIND(\" \",$L13)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N12)","v":0},null,{"$f":"IFERROR((M13+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P13)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P13)),\"\")","v":"X is Too High"},0]
[null,null,null,null,null,null,null,null,null,null,null,"Point 10",{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L14,FIND(\" \",$L14)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(M$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),M13)","v":0.13735},{"$f":"IFERROR(ROUND(INDEX('Demand Curve Parameters'!$H$4:$K$49,MATCH(VALUE(MID($L14,FIND(\" \",$L14)+1,10)),'Demand Curve Parameters'!$H$4:$H$49,0),MATCH(N$4,'Demand Curve Parameters'!$H$4:$K$4,0)),5),N13)","v":0},null,{"$f":"IFERROR((M14+1)*'Auction Simulation'!$B$41,\"\")","v":173312.35011000003},{"$f":"IFERROR(IF(Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P14)=\"X is Too Low\",\"> 0.2\",Interpolate('LOLE Data'!$H$6:$H$32,'LOLE Data'!$B$6:$B$32,$P14)),\"\")","v":"X is Too High"},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Supply Curve Core Shape",null,null,null,"Final Supply Curve"]
[null,null,null,null,null,null,null,null,null,null,null,"Block","Shape MW","Price",null,"MW"]
[null,null,null,null,null,null,null,null,null,null,null,1,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,2,1073.4550334986707,1.0194488888888891,null,{"$f":"$P$69-($M$69-$M20)","v":108473.15839206395}]
[null,null,null,null,null,null,null,null,null,null,null,3,2146.9100669973122,1.9854222222222224,null,109546.61342556259]
[null,null,null,null,null,null,null,null,null,null,null,4,3220.365100496012,3.1232000000000002,null,110620.06845906129]
[null,null,null,null,null,null,null,null,null,null,null,5,4293.8201339946827,4.370204444444445,null,111693.52349255997]
[null,null,null,null,null,null,null,null,null,null,null,6,5367.2751674933534,5.7264355555555557,null,112766.97852605864]
[null,null,null,null,null,null,null,null,null,null,null,7,6440.7302009919949,7.2851911111111116,null,113840.43355955728]
[null,null,null,null,null,null,null,null,null,null,null,8,7514.1852344906656,8.9918577777777777,null,114913.88859305595]
[null,null,null,null,null,null,null,null,null,null,null,9,8587.6402679893363,10.719004444444446,null,115987.34362655462]
[null,null,null,null,null,null,null,null,null,null,null,10,9661.0953014880361,12.138951111111112,null,117060.79866005332]
[null,null,null,null,null,null,null,null,null,null,null,11,10734.550334986678,13.73184,null,118134.25369355196]
[null,null,null,null,null,null,null,null,null,null,null,12,11808.005368485348,15.041422222222222,null,119207.70872705063]
[null,null,null,null,null,null,null,null,null,null,null,13,12881.460401984019,16.613831111111111,null,120281.1637605493]
[null,null,null,null,null,null,null,null,null,null,null,14,13954.91543548269,18.484337777777778,null,121354.61879404797]
[null,null,null,null,null,null,null,null,null,null,null,15,15028.37046898136,20.608568888888886,null,122428.07382754664]
[null,null,null,null,null,null,null,null,null,null,null,16,16101.825502480031,22.575786666666666,null,123501.52886104531]
[null,null,null,null,null,null,null,null,null,null,null,17,17175.280535978673,24.801280000000002,null,124574.98389454396]
[null,null,null,null,null,null,null,null,null,null,null,18,18248.735569477372,27.120071111111113,null,125648.43892804265]
[null,null,null,null,null,null,null,null,null,null,null,19,19322.190602976014,29.40700444444445,null,126721.8939615413]
[null,null,null,null,null,null,null,null,null,null,null,20,20395.645636474714,32.365226666666672,null,127795.34899504]
[null,"System Input Parameters (Used in Brattle Modeling)",null,null,null,null,null,null,null,null,null,21,21469.100669973355,35.511182222222224,null,128868.80402853864]
[null,166127.5,"Reliability Requirement (2016/17 Planning Parameters)",null,null,null,null,null,null,null,null,22,22542.555703472026,38.489884444444442,null,129942.25906203731]
[null,152382.6,"Peak Load (2016/17 Planning Parameters)",null,null,null,null,null,null,null,null,23,23616.010736970697,41.338879999999996,null,131015.71409553598]
[null,330.53,"Net CONE (2016/17 Planning Parameters)",null,null,null,null,null,null,null,null,24,24689.465770469367,44.549688888888895,null,132089.16912903465]
[null,null,null,null,null,null,null,null,null,null,null,25,25762.920803968009,48.036977777777778,null,133162.62416253329]
[null,null,null,null,null,null,null,null,null,null,null,26,26836.375837466709,52.406044444444447,null,134236.07919603199]
[null,null,null,null,null,null,null,null,null,null,null,27,27909.830870965379,56.893439999999998,null,135309.53422953066]
[null,"Chart Lines","Quantity (MW)","Price ($/MW-d)",null,null,null,null,null,null,null,28,28983.28590446405,61.590186666666661,null,136382.98926302933]
[null,"RR",{"$f":"$B$40","v":166127.5},0,null,null,null,null,null,null,null,29,30056.740937962721,66.018417777777785,null,137456.444296528]
[null,null,{"$f":"$B$40","v":166127.5},10000,null,null,null,null,null,null,null,30,31130.195971461362,71.064462222222218,null,138529.89933002664]
[null,null,null,null,null,null,null,null,null,null,null,31,32203.651004960033,76.980906666666669,null,139603.35436352532]
[null,"Net CONE",0,{"$f":"$B$42","v":330.53},null,null,null,null,null,null,null,32,33277.106038458733,83.479893333333337,null,140676.80939702402]
[null,null,{"$f":"$B$40","v":166127.5},{"$f":"$B$42","v":330.53},null,null,null,null,null,null,null,33,34350.561071957374,89.986844444444429,null,141750.26443052266]
[null,null,null,null,null,null,null,null,null,null,null,34,35424.016105456045,96.626915555555556,null,142823.71946402133]
[null,null,null,null,null,null,null,null,null,null,null,35,36497.471138954716,102.43413333333334,null,143897.17449752]
[null,null,null,null,null,null,null,null,null,null,null,36,37570.926172453386,108.65322666666665,null,144970.62953101867]
[null,null,null,null,null,null,null,null,null,null,null,37,38644.381205952057,115.15903999999999,null,146044.08456451734]
[null,null,null,null,null,null,null,null,null,null,null,38,39717.836239450728,122.33614222222221,null,147117.53959801601]
[null,null,null,null,null,null,null,null,null,null,null,39,40791.291272949369,129.73169777777775,null,148190.99463151465]
[null,null,null,null,null,null,null,null,null,null,null,40,41864.746306448069,138.03747555555555,null,149264.44966501335]
[null,null,null,null,null,null,null,null,null,null,null,41,42938.201339946711,148.32753777777776,null,150337.90469851199]
[null,null,null,null,null,null,null,null,null,null,null,42,44011.65637344541,160.04664888888888,null,151411.35973201069]
[null,null,null,null,null,null,null,null,null,null,null,43,45085.111406944081,174.83775999999997,null,152484.81476550936]
[null,null,null,null,null,null,null,null,null,null,null,44,46158.566440442723,191.23768888888887,null,153558.26979900801]
[null,null,null,null,null,null,null,null,null,null,null,45,47232.021473941393,207.57390222222222,null,154631.72483250668]
[null,null,null,null,null,null,null,null,null,null,null,46,48305.476507440064,226.06051555555555,null,155705.17986600535]
[null,null,null,null,null,null,null,null,null,null,null,47,49378.931540938735,291.55555555555554,null,156778.63489950402]
[null,null,null,null,null,null,null,null,null,null,null,48,50452.386574437405,355.91281777777778,null,157852.08993300269]
[null,null,null,null,null,null,null,null,null,null,null,49,51525.841607936076,418.22207999999995,null,158925.54496650136]
[null,null,null,null,null,null,null,null,null,null,null,50,52599.296641434717,477.6868977777778,null,{"$f":"$P$69-($M$69-$M68)","v":159999}]
[null,null,null,null,null,null,null,null,null,null,null,51,{"$f":"M68+1","v":52600.296641434717},700,null,{"$f":"supply_shift","v":160000}]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Data -->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Demand Curve Parameters","index":4,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Peak Load (MW):",null,null,null,{"$f":"COUNTIFS($A:$A,'Auction Simulation'!$B$4)","v":5},"# of DC Points"]
[]
[null,null,null,"User-Defined Curve",null,null,null,null,"Current Curve"]
[null,null,"Point","Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)",null,"Point","Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)"]
[{"$f":"IF(ISNUMBER(B5),D3,\"\")","v":"User-Defined Curve"},{"$f":"IF(ISNUMBER(E5),C5,\"\")","v":1},1,{"$f":"IF(E5=0,0,(E5*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,null,null,1,{"$f":"IF(ISNUMBER(H5),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H5,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":0},{"$f":"IF(ISNUMBER(I5),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H5,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":0},{"$f":"IF(ISNUMBER(J5),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H5,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":1.5}]
[{"$f":"IF(ISNUMBER(B6),A5,\"\")","v":""},{"$f":"IF(ISNUMBER(E6),C6,\"\")","v":""},2,{"$f":"IF(E6=0,0,(E6*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,{"$f":"IF(H5>=$H$1,\"\",H5+1)","v":2},{"$f":"IF(ISNUMBER(H6),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H6,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":6.1907545211604909E-2},{"$f":"IF(ISNUMBER(I6),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H6,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":0.97404844290657433},{"$f":"IF(ISNUMBER(J6),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H6,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":1.5}]
[{"$f":"IF(ISNUMBER(B7),A6,\"\")","v":""},"",3,{"$f":"IF(E7=0,0,(E7*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,3,{"$f":"IF(ISNUMBER(H7),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H7,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":9.9630726213793652E-2},{"$f":"IF(ISNUMBER(I7),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H7,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":1.0086505190311419},{"$f":"IF(ISNUMBER(J7),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H7,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":1}]
["","",4,{"$f":"IF(E8=0,0,(E8*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,4,{"$f":"IF(ISNUMBER(H8),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H8,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":0.13735390721598195},{"$f":"IF(ISNUMBER(I8),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H8,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":1.0432525951557095},{"$f":"IF(ISNUMBER(J8),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H8,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":0.2}]
["","",5,{"$f":"IF(E9=0,0,(E9*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,5,{"$f":"IF(ISNUMBER(H9),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H9,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":0.13735390721598195},{"$f":"IF(ISNUMBER(I9),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H9,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":1.0432525951557095},{"$f":"IF(ISNUMBER(J9),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H9,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":0}]
["","",6,{"$f":"IF(E10=0,0,(E10*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,"",{"$f":"IF(ISNUMBER(H10),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H10,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I10),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H10,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J10),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H10,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["","",7,{"$f":"IF(E11=0,0,(E11*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,"",{"$f":"IF(ISNUMBER(H11),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H11,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I11),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H11,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J11),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H11,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["","",8,{"$f":"IF(E12=0,0,(E12*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,"",{"$f":"IF(ISNUMBER(H12),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H12,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I12),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H12,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J12),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H12,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["","",9,{"$f":"IF(E13=0,0,(E13*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,{"$f":"IF(H12>=$H$1,\"\",H12+1)","v":""},{"$f":"IF(ISNUMBER(H13),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H13,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I13),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H13,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J13),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H13,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["","",10,{"$f":"IF(E14=0,0,(E14*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},null,null,null,"",{"$f":"IF(ISNUMBER(H14),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H14,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I14),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H14,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J14),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H14,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(H15),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H15,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I15),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H15,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J15),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H15,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(H16),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H16,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I16),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H16,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J16),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H16,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Current VRR Curve",null,null,null,"",{"$f":"IF(ISNUMBER(H17),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H17,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I17),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H17,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J17),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H17,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)",null,"",{"$f":"IF(ISNUMBER(H18),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H18,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I18),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H18,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J18),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H18,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["Current VRR Curve",1,1,{"$f":"IF(E19=0,0,(E19*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.5,null,"",{"$f":"IF(ISNUMBER(H19),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H19,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I19),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H19,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J19),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H19,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B20),A19,\"\")","v":"Current VRR Curve"},2,2,{"$f":"IF(E20=0,0,(E20*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":6.1907545211604909E-2},0.97404844290657433,1.5,null,"",{"$f":"IF(ISNUMBER(H20),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H20,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I20),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H20,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J20),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H20,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B21),A20,\"\")","v":"Current VRR Curve"},3,3,{"$f":"IF(E21=0,0,(E21*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":9.9630726213793652E-2},1.0086505190311419,1,null,"",{"$f":"IF(ISNUMBER(H21),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H21,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I21),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H21,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J21),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H21,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B22),A21,\"\")","v":"Current VRR Curve"},4,4,{"$f":"IF(E22=0,0,(E22*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.13735390721598195},1.0432525951557095,0.2,null,"",{"$f":"IF(ISNUMBER(H22),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H22,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I22),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H22,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J22),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H22,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B23),A22,\"\")","v":"Current VRR Curve"},5,5,{"$f":"IF(E23=0,0,(E23*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.13735390721598195},1.0432525951557095,0]
[null,null,null,null,null,null,null,{"$f":"IF(H22>=$H$1,\"\",H22+1)","v":""},{"$f":"IF(ISNUMBER(H24),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H24,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I24),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H24,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J24),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H24,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Brattle Proposed",null,null,null,"",{"$f":"IF(ISNUMBER(H25),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H25,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I25),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H25,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J25),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H25,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)",null,"",{"$f":"IF(ISNUMBER(H26),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H26,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I26),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H26,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J26),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H26,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["Brattle Proposed",1,1,{"$f":"IF(E27=0,0,(E27*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.5,null,"",{"$f":"IF(ISNUMBER(H27),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H27,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I27),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H27,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J27),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H27,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B28),A27,\"\")","v":"Brattle Proposed"},2,2,{"$f":"IF(E28=0,0,(E28*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":7.8875418707819778E-2},0.98961244453077446,1.5,null,"",{"$f":"IF(ISNUMBER(H28),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H28,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I28),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H28,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J28),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H28,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B29),A28,\"\")","v":"Brattle Proposed"},3,3,{"$f":"IF(E29=0,0,(E29*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.10847276420366025},1.0167609928430914,0.75,null,"",{"$f":"IF(ISNUMBER(H29),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H29,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I29),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H29,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J29),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H29,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B30),A29,\"\")","v":"Brattle Proposed"},4,4,{"$f":"IF(E30=0,0,(E30*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.16391087548242744},1.0676123180947679,0,null,"",{"$f":"IF(ISNUMBER(H30),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H30,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I30),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H30,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J30),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H30,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(H31),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H31,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I31),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H31,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J31),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H31,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"PJM Proposed",null,null,null,"",{"$f":"IF(ISNUMBER(H32),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H32,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I32),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H32,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J32),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H32,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)",null,"",{"$f":"IF(ISNUMBER(H33),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H33,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I33),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H33,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J33),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H33,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
["PJM Proposed",1,1,{"$f":"IF(E34=0,0,(E34*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.5,null,"",{"$f":"IF(ISNUMBER(H34),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H34,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I34),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H34,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J34),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H34,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B35),A34,\"\")","v":"PJM Proposed"},2,2,{"$f":"IF(E35=0,0,(E35*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":8.8282791293568641E-2},0.99824147881940895,1.5,null,"",{"$f":"IF(ISNUMBER(H35),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H35,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I35),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H35,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J35),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H35,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B36),A35,\"\")","v":"PJM Proposed"},3,3,{"$f":"IF(E36=0,0,(E36*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.11787949422337207},1.0253894377297101,0.75,null,"",{"$f":"IF(ISNUMBER(H36),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H36,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I36),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H36,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J36),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H36,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[{"$f":"IF(ISNUMBER(B37),A36,\"\")","v":"PJM Proposed"},4,4,{"$f":"IF(E37=0,0,(E37*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.17331640192638331},1.0762396589859433,0,null,"",{"$f":"IF(ISNUMBER(H37),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H37,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I37),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H37,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J37),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H37,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(H38),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H38,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(I$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(I38),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H38,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(J$4,$A$4:$F$4,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(J38),INDEX($A$3:$F$9996,MATCH('Auction Simulation'!$B$4&$H38,$A$3:$A$9996&$B$3:$B$9996,0),MATCH(K$4,$A$4:$F$4,0)),\"\")","v":""}]
[null,null,null,"Vertical at RR"]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)"]
[{"$f":"IF(ISNUMBER(B41),D39,\"\")","v":"Vertical at RR"},1,1,{"$f":"IF(E41=0,0,(E41*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.5]
[{"$f":"IF(ISNUMBER(B42),A41,\"\")","v":"Vertical at RR"},2,2,{"$f":"IF(E42=0,0,(E42*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":9.0199930963246411E-2},1,1.5]
[{"$f":"IF(ISNUMBER(B43),A42,\"\")","v":"Vertical at RR"},3,3,{"$f":"IF(E43=0,0,(E43*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":9.0199930963246411E-2},1,0]
[]
[null,null,null,"ISO-NE"]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)"]
[{"$f":"IF(ISNUMBER(B47),D45,\"\")","v":"ISO-NE"},1,1,{"$f":"IF(E47=0,0,(E47*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.6]
[{"$f":"IF(ISNUMBER(B48),A47,\"\")","v":"ISO-NE"},2,2,{"$f":"IF(E48=0,0,(E48*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":7.8875418707819778E-2},0.98961244453077446,1.6]
[{"$f":"IF(ISNUMBER(B49),A48,\"\")","v":"ISO-NE"},3,3,{"$f":"IF(E49=0,0,(E49*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.18068652523319573},1.083,0]
[]
[null,null,null,"NYISO"]
[null,null,null,"Quantity (UCAP RM %)","Quantity (% of RR)","Price (% of Net Cone)"]
[{"$f":"D51","v":"NYISO"},1,1,{"$f":"IF(E53=0,0,(E53*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0},0,1.8376796283127932]
[{"$f":"A53","v":"NYISO"},2,2,{"$f":"IF(E54=0,0,(E54*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":1.814410456043869E-2},0.93390586042402091,1.8376796283127932]
[{"$f":"A54","v":"NYISO"},3,3,{"$f":"IF(E55=0,0,(E55*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":9.0199930963246411E-2},1,1.1850000000000001]
[{"$f":"A55","v":"NYISO"},4,4,{"$f":"IF(E56=0,0,(E56*'Auction Simulation'!$B$40)/'Auction Simulation'!$B$41-1)","v":0.22102392267883619},1.1200000000000001,0]

{"sheet":"LOLE Data","index":5,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LOLE",null,null,null,"Quantities for LOLE Lines",null,null,null,null,"Lines for Chart"]
[null,"(events/yr)","(yr/event)","(1-in-X)",null,"(% of RR)","(% UCAP RM)","(UCAP MW)",null,null,null,null,"X","Y"]
[]
[]
[null,0.2,5,"1-in-5",null,0.98961244453077446,7.8875418707819778E-2,164401.84137878622,null,null,{"$f":"$D$6","v":"1-in-5"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K6,$D$6:$D$21,0))","v":164401.84137878622},0]
[null,0.16666666666666666,6,"1-in-6",null,0.99233271979212923,8.1841062609949722E-2,164853.75390726695,null,null,{"$f":"K6","v":"1-in-5"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K7,$D$6:$D$21,0))","v":164401.84137878622},600]
[null,0.14285714285714285,7,"1-in-7",null,0.99463267975423619,8.4348478801856919E-2,165235.84050587186]
[null,0.125,8,"1-in-8",null,0.99662499569513885,8.65205015030861E-2,165566.81897234419,null,null,{"$f":"$D$11","v":"1-in-10"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K9,$D$6:$D$21,0))","v":166119.91520661194},0]
[null,0.1111111111111111,9,"1-in-9",null,0.99838234289937211,8.843636130381971E-2,165858.76267001545,null,null,{"$f":"K9","v":"1-in-10"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K10,$D$6:$D$21,0))","v":166119.91520661194},600]
[null,0.1,10,"1-in-10",null,0.99995434354102686,9.0150156294825923E-2,166119.91520661194]
[null,6.6666666666666666E-2,15,"1-in-15",null,1.0060039666482696,9.6745454988695689E-2,167124.92396936042,null,null,{"$f":"$D$21","v":"1-in-100"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K12,$D$6:$D$21,0))","v":171827.23292435677},0]
[null,0.05,20,"1-in-20",null,1.0102962425512791,0.10142489388183185,167837.98903443763,null,null,{"$f":"K12","v":"1-in-100"},null,{"$f":"INDEX($H$6:$H$21,MATCH($K13,$D$6:$D$21,0))","v":171827.23292435677},600]
[null,3.3333333333333333E-2,30,"1-in-30",null,1.016345865658522,0.10802019257570161,168842.99779718611]
[null,2.5000000000000001E-2,40,"1-in-40",null,1.0206381415615313,0.11269963146883755,169556.06286226329]
[null,0.02,50,"1-in-50",null,1.0239674894074193,0.11632928626057715,170109.15909653105]
[null,1.6666666666666666E-2,60,"1-in-60",null,1.0266877646687744,0.11929493016270776,170561.07162501183]
[null,1.4285714285714285E-2,70,"1-in-70",null,1.0289877246308814,0.12180234635461495,170943.15822361675]
[null,1.2500000000000001E-2,80,"1-in-80",null,1.0309800405717837,0.12397436905584369,171274.13669008901]
[null,1.1111111111111112E-2,90,"1-in-90",null,1.0327373877760173,0.12589022885657752,171566.0803877603]
[null,0.01,100,"1-in-100",null,1.0343093884176717,0.12760402384758329,171827.23292435677]