{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","MRTS Clearing TPSSOLVE","MRTS Clearing FINALSOLVE","Framework (Current vs MRTS)"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Steps to Simulate Regulation Market Clearing with MRTS Framework"]
["1. Start on the MRTS Clearing TPSSOLVE sheet"]
["2. Update any of the inputs listed below: 2a through 2e"]
[null,"a. Only make updates to the cells with light blue background on the \"MRTS Clearing TPSSOLVE\" sheet"]
[null,"b. RegA - Resource Name, RawMW, $ Price Offer, $ Cost Offer, Self Scheduled, Perf Score, Owner"]
[null,null,"i. $ Price Offer represents Price-Based Capability Offer + Price-Based Performance Offer"]
[null,null,"ii. $ Cost Offer represents Cost-Based Capability Offer + Cost-Based Performance Offer"]
[null,null,"iii. $ Price Offer and $ Cost Offer are ignored, and Adj Cost Offer are set to $0 when the Self-Schedule flag is set to 1"]
[null,"c. RegD - Resource Name, RawMW, $ Price Offer, $ Cost Offer, Self Scheduled, Perf Score, Owner"]
[null,null,"i. $ Price Offer represents Price-Based Capability Offer + Price-Based Performance Offer"]
[null,null,"ii. $ Cost Offer represents Cost-Based Capability Offer + Cost-Based Performance Offer"]
[null,null,"iii. $ Price Offer and $ Cost Offer are ignored, and Adj Cost Offer are set to $0 when the Self-Schedule flag is set to 1"]
[null,"d. Chosen Period - Select Season and either Ramping or Non-Ramping from the dropdown box"]
[null,null,"i. RTS Equations - equations from the results of the Regulation Study are listed as examples"]
[null,"e. Regulation Requirement - Enter a value for the requirement"]
["2. Press \"Simulate Clearing\" Button"]
[null,"a. \"MRTS Clearing TPSSOLVE\" sheet has results from the TPS Solve (where all resources are offer-capped) as well as the results of the TPS test"]
[null,"b. \"MRTS Clearing FINALSOLVE\" sheet has results from the final solve (where resources are cleared using the cost or price offer, depending on the results of the TPS test)"]
["3. The \"Optimal Mix Summary\" section has results of the market as a whole, including MW totals by Resource type (RegA, RegD), RMCP, and the Marginal Rate of Technical Substitution (MRTS)"]
["4. Clearing results for individual resources can be found at the bottom under the \"Simulated Regulation Market Clearing\" section or at the top right in the \"Regulation Resource Clearing\" section"]
["5. See tooltips for more detailed descriptions of each column"]

{"sheet":"MRTS Clearing TPSSOLVE","index":1,"n_rows":65,"n_cols":34,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,15,28,15],[41,10,41,11],[44,10,44,11],[0,0,28,0],[30,0,57,0],[41,15,57,15],[30,10,30,11],[30,15,38,15],[42,10,42,11],[45,10,45,11],[41,32,41,33],[50,32,50,33],[50,29,50,30],[41,29,41,30],[41,26,41,27],[50,26,50,27],[56,16,56,17],[50,23,50,24],[41,23,41,24],[59,24,59,27],[49,16,49,17],[51,16,51,17],[53,16,53,17],[55,16,55,17],[50,16,50,17],[52,16,52,17],[54,16,54,17]]}
["Regulation Resource Offers","RegA Resources","RawMW","$ Price Offer","$ Cost Offer","Self Schedule","Perf Score","Owner","Adj Cost Offer (Assume LOC Included)","Cost per Effective RegA","Perf Adj MW","Cum Perf Adj MW","Cum Eff MW","Indiv Eff MW","RTS","Regulation Resource Clearing","Status","Cleared Perf Adj MW","Cleared Eff MW for Isoquant","Cleared Eff MW","$ Per Eff RegA","Settlement Credit","TPS Eligibility","TPS Failed","PostTPS Adj Offer"]
[null,"A13",100,0,0,0,0.85,"Bravo",{"$f":"IF(F2=0,(MIN(D2,E2))/G2,0)","v":0},{"$f":"IF(O2<0,\"\",I2/O2)","v":0},{"$f":"C2*G2","v":85},{"$f":"SUM($K$2)","v":85},{"$f":"SUM(K2)","v":85},{"$f":"M2","v":85},1,null,{"$f":"INDEX($H$32:$H$58,MATCH(B2,$B$32:$B$58,0))","v":"Cleared"},{"$f":"IF($Q2=\"Cleared\",K2,IF($Q2=\"Partially Cleared\",K2-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-$K$43),\"\"))","v":85},{"$f":"R2","v":85},{"$f":"IF($R2=\"\",\"\",$R2)","v":85},{"$f":"IF(T2=\"\",\"\",$L$38)","v":3.333333333333333},{"$f":"IFERROR(T2*U2,0)","v":283.33333333333331},{"$f":"IF(J2<=(1.5*$L$38),1,0)","v":1},{"$f":"VLOOKUP($H2,$Q$32:$T$39,3,0)","v":0},{"$f":"IF(F2=0,IF(W2=0,999,IF(AND(W2=1,X2=0),D2/G2,I2)),0)","v":0}]
[null,"A2",100,0,0,0,0.5,"Echo",{"$f":"IF(F3=0,(MIN(D3,E3))/G3,0)","v":0},0,50,{"$f":"SUM($K$2:$K$3)","v":135},{"$f":"SUM($K$2:K3)","v":135},{"$f":"M3-M2","v":50},1,null,"Cleared",50,{"$f":"R3","v":50},{"$f":"IF($R3=\"\",\"\",$R3)","v":50},3.333333333333333,{"$f":"IFERROR(T3*U3,0)","v":166.66666666666666},1,0,{"$f":"IF(F3=0,IF(W3=0,999,IF(AND(W3=1,X3=0),D3/G3,I3)),0)","v":0}]
[null,"A3",100,2,1,0,0.75,"Alpha",{"$f":"IF(F4=0,(MIN(D4,E4))/G4,0)","v":1.3333333333333333},1.3333333333333333,75,{"$f":"SUM($K$2:$K$4)","v":210},{"$f":"SUM($K$2:K4)","v":210},{"$f":"M4-M3","v":75},1,null,"Cleared",75,75,75,3.333333333333333,249.99999999999997,1,0,2.6666666666666665]
[null,"A4",100,3,2,0,0.9,"Charlie",{"$f":"IF(F5=0,(MIN(D5,E5))/G5,0)","v":2.2222222222222223},2.2222222222222223,90,{"$f":"SUM($K$2:$K$5)","v":300},{"$f":"SUM($K$2:K5)","v":300},90,1,null,"Cleared",90,90,90,3.333333333333333,300,1,0,3.333333333333333]
[null,"A1",100,3,3,0,0.9,"Gamma",{"$f":"IF(F6=0,(MIN(D6,E6))/G6,0)","v":3.333333333333333},3.333333333333333,90,{"$f":"SUM($K$2:$K$6)","v":390},{"$f":"SUM($K$2:K6)","v":390},90,1,null,"Partially Cleared",58.153418750000014,58.153418750000014,58.153418750000014,3.333333333333333,193.8447291666667,1,0,3.333333333333333]
[null,"A14",100,6,3,0,0.78,"Harry",{"$f":"IF(F7=0,(MIN(D7,E7))/G7,0)","v":3.8461538461538458},3.8461538461538458,78,{"$f":"SUM($K$2:$K$7)","v":468},{"$f":"SUM($K$2:K7)","v":468},78,1,null,"Not Cleared","","","","",0,1,0,7.6923076923076916]
[null,"A5",100,4,3,0,0.72,"Delta",{"$f":"IF(F8=0,(MIN(D8,E8))/G8,0)","v":4.166666666666667},4.166666666666667,72,{"$f":"SUM($K$2:$K$8)","v":540},{"$f":"SUM($K$2:K8)","v":540},72,1,null,"Not Cleared","","","","",0,1,0,5.5555555555555554]
[null,"A6",100,5,4,0,0.78,"Bravo",{"$f":"IF(F9=0,(MIN(D9,E9))/G9,0)","v":5.1282051282051277},5.1282051282051277,78,{"$f":"SUM($K$2:$K$9)","v":618},{"$f":"SUM($K$2:K9)","v":618},78,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A15",100,5,4,0,0.72,"Delta",{"$f":"IF(F10=0,(MIN(D10,E10))/G10,0)","v":5.5555555555555554},5.5555555555555554,72,{"$f":"SUM($K$2:$K$10)","v":690},{"$f":"SUM($K$2:K10)","v":690},72,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A11",100,10,5,0,0.85,"Gamma",{"$f":"IF(F11=0,(MIN(D11,E11))/G11,0)","v":5.882352941176471},5.882352941176471,85,{"$f":"SUM($K$2:$K$11)","v":775},{"$f":"SUM($K$2:K11)","v":775},85,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A7",100,6,5,0,0.8,"Alpha",{"$f":"IF(F12=0,(MIN(D12,E12))/G12,0)","v":6.25},6.25,80,{"$f":"SUM($K$2:$K$12)","v":855},{"$f":"SUM($K$2:K12)","v":855},80,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A12",100,10,5,0,0.75,"Echo",{"$f":"IF(F13=0,(MIN(D13,E13))/G13,0)","v":6.666666666666667},6.666666666666667,75,{"$f":"SUM($K$2:$K$13)","v":930},{"$f":"SUM($K$2:K13)","v":930},75,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A9",100,8,6,0,0.88,"Foxtrot",{"$f":"IF(F14=0,(MIN(D14,E14))/G14,0)","v":6.8181818181818183},6.8181818181818183,88,{"$f":"SUM($K$2:$K$14)","v":1018},{"$f":"SUM($K$2:K14)","v":1018},88,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A8",100,7,5,0,0.7,"Echo",{"$f":"IF(F15=0,(MIN(D15,E15))/G15,0)","v":7.1428571428571432},7.1428571428571432,70,{"$f":"SUM($K$2:$K$15)","v":1088},{"$f":"SUM($K$2:K15)","v":1088},70,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"A10",100,9,8,0,0.78,"Charlie",{"$f":"IF(F16=0,(MIN(D16,E16))/G16,0)","v":10.256410256410255},10.256410256410255,78,{"$f":"SUM($K$2:$K$16)","v":1166},{"$f":"SUM($K$2:K16)","v":1166},78,1,null,"Not Cleared","","","","",0,0,0,999]
[null,"RegD Resources","RawMW","$ Price Offer","$ Cost Offer","Self Schedule","Perf Score","Owner","Adj Cost Offer (Assume LOC Included)","Cost per Effective RegA","Perf Adj MW","Cum Perf Adj MW","Cum Eff MW","Indiv Eff MW","RTS",null,"Status","Cleared Perf Adj MW","Cleared Eff MW for Isoquant","Cleared Eff MW","$ Per Eff RegA","Settlement Credit","TPS Eligibility","TPS Failed","PostTPS Adj Offer"]
[null,"D10",100,9,8,1,0.93,"Foxtrot",{"$f":"IF(F18=0,(MIN(D18,E18))/G18,0)","v":0},{"$f":"IF(O18<=0,\"\",I18/O18)","v":0},{"$f":"C18*G18","v":93},{"$f":"SUM($K$18)","v":93},{"$f":"IF(L18<=$X$61,(0.5*L18*($AB$61-O18))+(L18*O18),IF(L18<=$X$62,$AE$61+(0.5*(L18-$X$61)*$Z$62*($X$61-L18))+((L18-$X$61)*O18),IF(L18<=$X$63,$AE$61+$AE$62+(0.5*(L18-$X$62)*$Z$63*($X$62-L18))+((L18-$X$62)*O18),IF(L18<=$X$64,$AE$61+$AE$62+$AE$63+(0.5*(L18-$X$63)*$Z$64*($X$63-L18))+((L18-$X$63)*O18),$AE$61+$AE$62+$AE$63+$AE$64+(0.5*(L18-$X$64)*$Z$65*($X$64-L18))+((L18-$X$64)*O18)))))","v":310.20249999999999},{"$f":"M18","v":310.20249999999999},{"$f":"IF(L18<=$X$61,$Z$61*L18+$AB$61,IF(L18<=$X$62,$Z$62*L18+$AB$62,IF(L18<=$X$63,$Z$63*L18+$AB$63,IF(L18<=$X$64,$Z$64*L18+$AB$64,$Z$65*L18+$AB$65))))","v":1.6983333333333333},null,{"$f":"INDEX($H$32:$H$58,MATCH(B18,$B$32:$B$58,0))","v":"Cleared"},{"$f":"IF($Q18=\"Cleared\",K18,IF($Q18=\"Partially Cleared\",K18-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-$K$43),\"\"))","v":93},{"$f":"IF($Q18=\"Cleared\",N18,IF($Q18=\"Partially Cleared\",N18-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-$K$43),\"\"))","v":310.20249999999999},{"$f":"IF($R18=\"\",\"\",$R18*$L$39)","v":70.115025000000003},3.333333333333333,{"$f":"IFERROR(T18*U18,0)","v":233.71674999999999},{"$f":"IF(J18<=(1.5*$L$38),1,0)","v":1},{"$f":"VLOOKUP($H18,$Q$32:$T$39,3,0)","v":0},{"$f":"IF(F18=0,IF(W18=0,999,IF(AND(W18=1,X18=0),D18/G18,I18)),0)","v":0}]
[null,"D9",50,8,6,1,0.89,"Harry",{"$f":"IF(F19=0,(MIN(D19,E19))/G19,0)","v":0},{"$f":"IF(O19<=0,\"\",I19/O19)","v":0},44.5,{"$f":"SUM($K$18:$K$19)","v":137.5},373.12673611111109,{"$f":"IF(M19<M18,0,M19-M18)","v":62.924236111111099},1.1297222222222221,null,"Cleared",44.5,{"$f":"IF($Q19=\"Cleared\",N19,IF($Q19=\"Partially Cleared\",N19-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-$K$43),\"\"))","v":62.924236111111099},{"$f":"IF($R19=\"\",\"\",$R19*$L$39)","v":33.549662499999997},3.333333333333333,{"$f":"IFERROR(T19*U19,0)","v":111.83220833333331},1,0,0]
[null,"D3",50,2,1,0,0.7,"Echo",{"$f":"IF(F20=0,(MIN(D20,E20))/G20,0)","v":1.4285714285714286},1.5968382602447155,35,{"$f":"SUM($K$18:$K$20)","v":172.5},407.22703124999998,{"$f":"IF(M20<M19,0,M20-M19)","v":34.100295138888896},0.894625,null,"Cleared",35,34.100295138888896,26.387374999999999,3.333333333333333,87.957916666666648,1,0,2.8571428571428572]
[null,"D5",50,2,3,0,0.84,"Echo",{"$f":"IF(F21=0,(MIN(D21,E21))/G21,0)","v":2.3809523809523809},3.1580759106706648,42,{"$f":"SUM($K$18:$K$21)","v":214.5},441.84658124999999,34.619550000000004,0.75392499999999996,null,"Cleared",42,34.619550000000004,31.664849999999998,3.333333333333333,105.54949999999998,1,0,2.3809523809523809]
[null,"D4",100,3,2,0,0.72,"Foxtrot",{"$f":"IF(F22=0,(MIN(D22,E22))/G22,0)","v":2.7777777777777777},5.4176757087674243,72,{"$f":"SUM($K$18:$K$22)","v":286.5},487.44598124999999,45.599400000000003,0.51272499999999999,null,"Not Cleared","","","","",0,0,0,999]
[null,"D6",100,5,4,0,0.83,"Harry",{"$f":"IF(F23=0,(MIN(D23,E23))/G23,0)","v":4.8192771084337354},16.766590890990614,83,{"$f":"SUM($K$18:$K$23)","v":369.5},518.97747500000003,31.531493750000038,0.28743333333333332,null,"Not Cleared","","","","",0,0,0,999]
[null,"D12",50,10,5,0,0.95,"Alpha",{"$f":"IF(F24=0,(MIN(D24,E24))/G24,0)","v":5.2631578947368425},20.493389743286137,47.5,{"$f":"SUM($K$18:$K$24)","v":417},531.90354444444438,12.926069444444352,0.25682222222222223,null,"Not Cleared","","","","",0,0,0,999]
[null,"D11",50,10,5,0,0.94,"Harry",{"$f":"IF(F25=0,(MIN(D25,E25))/G25,0)","v":5.3191489361702127},23.480645686448852,47,{"$f":"SUM($K$18:$K$25)","v":464},543.26239999999996,11.358855555555579,0.22653333333333331,null,"Not Cleared","","","","",0,0,0,999]
[null,"D8",100,6,5,0,0.91,"Gamma",{"$f":"IF(F26=0,(MIN(D26,E26))/G26,0)","v":5.4945054945054945},32.727034712474826,91,{"$f":"SUM($K$18:$K$26)","v":555},561.20861111111117,17.946211111111211,0.16788888888888887,null,"Not Cleared","","","","",0,0,0,999]
[null,"D1",100,5,5,0,0.9,"Charlie",{"$f":"IF(F27=0,(MIN(D27,E27))/G27,0)","v":5.5555555555555554},50.55611729019212,90,{"$f":"SUM($K$18:$K$27)","v":645},573.70861111111105,12.499999999999886,0.10988888888888887,null,"Not Cleared","","","","",0,0,0,999]
[null,"D7",50,6,5,0,0.87,"Charlie",{"$f":"IF(F28=0,(MIN(D28,E28))/G28,0)","v":5.7471264367816088},70.210584947786714,43.5,{"$f":"SUM($K$18:$K$28)","v":688.5},577.87905277777782,4.1704416666667612,8.185555555555557E-2,null,"Not Cleared","","","","",0,0,0,999]
[null,"D2",100,5,5,0,0.75,"Harry",{"$f":"IF(F29=0,(MIN(D29,E29))/G29,0)","v":6.666666666666667},198.87305270135892,75,{"$f":"SUM($K$18:$K$29)","v":763.5},582.20571944444441,4.3266666666665969,3.3522222222222231E-2,null,"Not Cleared","","","","",0,0,0,999]
[]
["Simulated Regulation Market Clearing","Resource","PS","Cost per Effective RegA","Indiv Eff MW","RTS","Cum Eff MW","Status","Total Adjusted Cost",null,"Optimal Mix Summary:",null,null,null,null,"TPS Test","Owner","Eff MW",null,"TPS Failed",null,null,"Owner 1","Eff MW","TPS Failed","Owner 2","Eff MW","TPS Failed","Owner 3","Eff MW","TPS Failed","Result"]
[null,"A13",0.85,0,85,1,{"$f":"E32","v":85},{"$f":"IF(G32<$K$43,\"Cleared\",IF(H31=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},{"$f":"IF(AND(OR(H32=\"Cleared\",H32=\"Partially Cleared\"),H33=\"Not Cleared\"),D32*(SUM($R$2:$R$16)+SUM($R$18:$R$29)*$L$39),\"\")","v":""},null,"Total Production Cost",{"$f":"MAX(I32:I58)","v":1732.9011041666663},null,null,null,null,"Alpha",{"$f":"SUMIFS($N$2:$N$29,$W$2:$W$29,\"=1\",$H$2:$H$29,\"=\"&$Q32)","v":75},null,{"$f":"IFERROR(IFERROR(VLOOKUP($Q32,$W$32:$Y$37,3,0),0)+IFERROR(VLOOKUP($Q32,$Z$32:$AB$37,3,0),0)+IFERROR(VLOOKUP($Q32,$AC$32:$AE$37,3,0),0),\"N/A\")","v":0},{"$f":"R32+0.00001","v":75.000010000000003},"Test#1",{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($R$32:$R$39,1),$R$32:$R$39,0))","v":"Foxtrot"},{"$f":"VLOOKUP(W32,$Q$32:$R$40,2)","v":310.20249999999999},{"$f":"IF($AF32<=1,1,0)","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($R$32:$R$39,2),$R$32:$R$39,0))","v":"Harry"},{"$f":"VLOOKUP(Z32,$Q$32:$R$40,2)","v":140.9242361111111},{"$f":"IF($AF32<=1,1,0)","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,3),$U$32:$U$39,0))","v":"Echo"},{"$f":"VLOOKUP(AC32,$Q$32:$R$40,2)","v":118.7198451388889},{"$f":"IF(ROUND(AD32,2)=0,\"N/A\",IF($AF32<=1,1,0))","v":0},{"$f":"($R$40-(X32+AA32+AD32))/$X$63","v":1.177142857142857}]
[null,"D10",0.93,0,310.20249999999999,1.6983333333333333,{"$f":"IFERROR(G32+E33,\"\")","v":395.20249999999999},"Cleared","",null,"Total Effective MW",{"$f":"L34+L35","v":800},null,null,null,null,"Bravo",85,null,0,{"$f":"R33+0.00002","v":85.000020000000006},"Test#2","Foxtrot",310.20249999999999,{"$f":"Y32","v":0},"Harry",140.9242361111111,{"$f":"AB32","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,4),$U$32:$U$39,0))","v":"Gamma"},90,0,1.2591995575396826]
[null,"D9",0.89,0,62.924236111111099,1.1297222222222221,{"$f":"IFERROR(G33+E34,\"\")","v":458.12673611111109},"Cleared","",null,"RegA (Effective)",{"$f":"SUM(S2:S16)","v":358.15341875000001},null,null,null,null,"Charlie",90,null,0,{"$f":"R34+0.00003","v":90.000029999999995},"Test#3","Foxtrot",310.20249999999999,{"$f":"Y32","v":0},"Harry",140.9242361111111,{"$f":"AB32","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,5),$U$32:$U$39,0))","v":"Charlie"},90,0,1.2591995575396826]
[null,"A2",0.5,0,50,1,508.12673611111109,"Cleared","",null,"RegD (Effective)",{"$f":"SUM(S18:S29)","v":441.84658124999999},null,null,null,null,"Delta",72,null,0,{"$f":"R35+0.00004","v":72.000039999999998},"Test#4","Foxtrot",310.20249999999999,{"$f":"Y32","v":0},"Harry",140.9242361111111,{"$f":"AB32","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,6),$U$32:$U$39,0))","v":"Bravo"},85,0,1.2734852718253968]
[null,"A3",0.75,1.3333333333333333,75,1,583.12673611111109,"Cleared","",null,"RegA (Perf Adj)",{"$f":"SUM(R2:R16)","v":358.15341875000001},null,null,null,null,"Echo",118.7198451388889,null,0,{"$f":"R36+0.00005","v":118.7198951388889},"Test#5","Foxtrot",310.20249999999999,{"$f":"Y32","v":0},"Harry",140.9242361111111,{"$f":"AB32","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,7),$U$32:$U$39,0))","v":"Alpha"},75,0,1.3020567003968255]
[null,"D3",0.7,1.5968382602447155,34.100295138888896,0.894625,617.22703124999998,"Cleared","",null,"RegD (Perf Adj)",{"$f":"SUM(R18:R29)","v":214.5},null,null,null,null,"Foxtrot",310.20249999999999,null,0,{"$f":"R37+0.00006","v":310.20256000000001},"Test#6","Foxtrot",310.20249999999999,{"$f":"Y32","v":0},"Harry",140.9242361111111,{"$f":"AB32","v":0},{"$f":"INDEX($Q$32:$Q$39,MATCH(LARGE($U$32:$U$39,8),$U$32:$U$39,0))","v":"Delta"},72,0,1.310628128968254]
[null,"A4",0.9,2.2222222222222223,90,1,707.22703124999998,"Cleared","",null,"RMCP (per Eff RegA)",{"$f":"INDEX($D$32:$D$58,MATCH($L$32,$I$32:$I$58,0))","v":3.333333333333333},null,null,null,null,"Gamma",90,null,0,{"$f":"R38+0.00007","v":90.000069999999994}]
[null,"D5",0.84,3.1580759106706648,34.619550000000004,0.75392499999999996,741.84658124999999,"Cleared","",null,"MRTS",{"$f":"MIN(IF(Q18:Q29=\"Cleared\",O18:O29),IF(Q18:Q29=\"Partially Cleared\",O18:O29))","v":0.75392499999999996},null,null,null,null,"Harry",140.9242361111111,null,0,{"$f":"R39+0.00008","v":140.9243161111111}]
[null,"A1",0.9,3.333333333333333,90,1,831.84658124999999,"Partially Cleared",1732.9011041666663,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R32:R39)","v":981.84658124999999}]
[null,"A14",0.78,3.8461538461538458,78,1,909.84658124999999,"Not Cleared",""]
[null,"A5",0.72,4.166666666666667,72,1,981.84658124999999,"Not Cleared","",null,"Regulation Requirement:",null,null,null,null,"Rate of Substitution Curve Points",null,null,null,null,null,null,null,"Fall Ramping",null,null,"Winter Ramping",null,null,"Spring Ramping",null,null,"Summer Ramping"]
[null,"A6",0.78,5.1282051282051277,78,1,1059.8465812499999,"Not Cleared","",null,800,null,null,null,null,null,null,null,null,null,null,null,null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS"]
[null,"D4",0.72,5.4176757087674243,45.599400000000003,0.51272499999999999,1105.4459812499999,"Not Cleared","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4.5,null,0,6.12,null,0,5.36,null,0,5.07]
[null,"A15",0.72,5.5555555555555554,72,1,1177.4459812499999,"Not Cleared","",null,"Chosen Period (Select from Dropdown):",null,null,null,null,null,null,null,null,null,null,null,null,60,2.2200000000000002,null,60,2.12,null,60,1.98,null,60,2.1]
[null,"A11",0.85,5.882352941176471,85,1,1262.4459812499999,"Not Cleared","",null,"Winter Ramping",null,null,null,null,null,null,null,null,null,null,null,null,150,0.67,null,150,0.97,null,150,0.99,null,150,0.94]
[null,"A7",0.8,6.25,80,1,1342.4459812499999,"Not Cleared","",null,"RegD Perf Adj MW","RTS",null,null,null,null,null,null,null,null,null,null,null,350,0.48,null,350,0.3,null,350,0.35,null,350,0.42]
[null,"A12",0.75,6.666666666666667,75,1,1417.4459812499999,"Not Cleared","",null,{"$f":"IF($K$46=$X$42,X44,IF($K$46=$AA$42,AA44,IF($K$46=$AD$42,AD44,IF($K$46=$AG$42,AG44,IF($K$46=$X$51,X53,IF($K$46=$AA$51,AA53,IF($K$46=$AD$51,AD53,IF($K$46=$AG$51,AG53,\"\"))))))))","v":0},6.12,null,null,null,null,null,null,null,null,null,null,null,759,0,null,800,0.01,null,709,0,null,800,0.09]
[null,"A9",0.88,6.8181818181818183,88,1,1505.4459812499999,"Not Cleared","",null,60,2.12,null,null,null,null,null,null,null,null,null,null,null,800,0,null,800,0.01,null,800,0,null,800,0.09]
[null,"A8",0.7,7.1428571428571432,70,1,1575.4459812499999,"Not Cleared","",null,150,0.97,null,null,null,null,"Fall Ramping"]
[null,"A10",0.78,10.256410256410255,78,1,1653.4459812499999,"Not Cleared","",null,350,0.3,null,null,null,null,"Fall Non-Ramping",null,null,null,null,null,null,"Fall Non-Ramping",null,null,"Winter Non-Ramping",null,null,"Spring Non-Ramping",null,null,"Summer Non-Ramping"]
[null,"D6",0.83,16.766590890990614,31.531493750000038,0.28743333333333332,1684.9774749999999,"Not Cleared","",null,800,0.01,null,null,null,null,"Winter Ramping",null,null,null,null,null,null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS",null,"RegD Perf Adj MW","RTS"]
[null,"D12",0.95,20.493389743286137,12.926069444444352,0.25682222222222223,1697.9035444444444,"Not Cleared","",null,800,{"$f":"IF($K$46=$X$42,Y49,IF($K$46=$AA$42,AB49,IF($K$46=$AD$42,AE49,IF($K$46=$AG$42,AH49,IF($K$46=$X$51,Y58,IF($K$46=$AA$51,AB58,IF($K$46=$AD$51,AE58,IF($K$46=$AG$51,AH58,\"\"))))))))","v":0.01},null,null,null,null,"Winter Non-Ramping",null,null,null,null,null,null,0,4.5199999999999996,null,0,3.64,null,0,6,null,0,4.17]
[null,"D11",0.94,23.480645686448852,11.358855555555579,0.22653333333333331,1709.2624000000001,"Not Cleared","",null,null,null,null,null,null,null,"Spring Ramping",null,null,null,null,null,null,60,1.5,null,60,1.75,null,60,1.51,null,60,1.38]
[null,"D8",0.91,32.727034712474826,17.946211111111211,0.16788888888888887,1727.2086111111112,"Not Cleared","",null,null,null,null,null,null,null,"Spring Non-Ramping",null,null,null,null,null,null,150,0.79,null,150,0.68,null,150,0.69,null,150,0.78]
[null,"D1",0.9,50.55611729019212,12.499999999999886,0.10988888888888887,1739.7086111111112,"Not Cleared","",null,null,null,null,null,null,null,"Summer Ramping",null,null,null,null,null,null,350,0.16,null,350,0.27,null,350,0.19,null,350,0.25]
[null,"D7",0.87,70.210584947786714,4.1704416666667612,8.185555555555557E-2,1743.8790527777778,"Not Cleared","",null,null,null,null,null,null,null,"Summer Non-Ramping",null,null,null,null,null,null,800,7.0000000000000007E-2,null,800,7.0000000000000007E-2,null,800,0.01,null,800,7.0000000000000007E-2]
[null,"D2",0.75,198.87305270135892,4.3266666666665969,3.3522222222222231E-2,1748.2057194444444,"Not Cleared",{"$f":"IF(AND(OR(H58=\"Cleared\",H58=\"Partially Cleared\"),H70=\"Not Cleared\"),D58*(SUM($R$2:$R$16)+SUM($R$18:$R$29)*$L$39),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,7.0000000000000007E-2,null,800,7.0000000000000007E-2,null,800,0.01,null,800,7.0000000000000007E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K48","v":0},"RTS Equations:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Segment 1:",{"$f":"(L49-L48)/(K49-K48)","v":-6.6666666666666666E-2},"x +",{"$f":"Z61*-K48+L48","v":6.12},null,"Segment 1 Area:",{"$f":"(0.5*(X61-X60)*Z61*(X60-X61))+((X61-X60)*(Z61*X61+AB61))","v":247.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"Segment 2:",{"$f":"(L50-L49)/(K50-K49)","v":-1.2777777777777779E-2},"x +",{"$f":"Z62*-K49+L49","v":2.8866666666666667},null,"Segment 2 Area:",{"$f":"(0.5*(X62-X61)*Z62*(X61-X62))+((X62-X61)*(Z62*X62+AB62))","v":139.05000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,"Segment 3:",{"$f":"(L51-L50)/(K51-K50)","v":-3.3499999999999997E-3},"x +",{"$f":"Z63*-K50+L50","v":1.4724999999999999},null,"Segment 3 Area:",{"$f":"(0.5*(X63-X62)*Z63*(X62-X63))+((X63-X62)*(Z63*X63+AB63))","v":127}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,"Segment 4:",{"$f":"(L52-L51)/(K52-K51)","v":-6.4444444444444445E-4},"x +",{"$f":"Z64*-K51+L51","v":0.52555555555555555},null,"Segment 4 Area:",{"$f":"(0.5*(X64-X63)*Z64*(X63-X64))+((X64-X63)*(Z64*X64+AB64))","v":69.75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,"Segment 5:",{"$f":"IFERROR((L53-L52)/(K53-K52),\"\")","v":""},"x +",{"$f":"IFERROR(Z65*-K52+L52,\"\")","v":""},null,"Segment 5 Area:",{"$f":"IF(Z65=\"\",0,(0.5*(X65-X64)*Z65*(X64-X65))+((X65-X64)*(Z65*X65+AB65)))","v":0}]

{"sheet":"MRTS Clearing FINALSOLVE","index":2,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,15,28,15],[30,0,57,0],[0,0,28,0],[30,10,30,11]]}
["Regulation Resource Offers","RegA Resources","RawMW","$ Price Offer","$ Cost Offer","Self Schedule","Perf Score","Owner","PostTPS Adj Offer (Assume LOC Included)","Cost per Effective RegA","Perf Adj MW","Cum Perf Adj MW","Cum Eff MW","Indiv Eff MW","RTS","Regulation Resource Clearing","Status","Cleared Perf Adj MW","Cleared Eff MW for Isoquant","Cleared Eff MW","$ Per Eff RegA","Settlement Credit"]
[null,"A13",100,0,0,0,0.85,"Bravo",{"$f":"VLOOKUP($B2,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":0},{"$f":"IF(O2<0,\"\",I2/O2)","v":0},{"$f":"C2*G2","v":85},{"$f":"SUM($K$2)","v":85},{"$f":"SUM(K2)","v":85},{"$f":"M2","v":85},1,null,{"$f":"INDEX($H$32:$H$58,MATCH(B2,$B$32:$B$58,0))","v":"Cleared"},{"$f":"IF($Q2=\"Cleared\",K2,IF($Q2=\"Partially Cleared\",K2-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":85},{"$f":"R2","v":85},{"$f":"IF($R2=\"\",\"\",$R2)","v":85},{"$f":"IF(T2=\"\",\"\",$L$38)","v":3.333333333333333},{"$f":"IFERROR(T2*U2,0)","v":283.33333333333331}]
[null,"A2",100,0,0,0,0.5,"Echo",{"$f":"VLOOKUP($B3,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":0},0,50,{"$f":"SUM($K$2:$K$3)","v":135},{"$f":"SUM($K$2:K3)","v":135},{"$f":"M3-M2","v":50},1,null,"Cleared",{"$f":"IF($Q3=\"Cleared\",K3,IF($Q3=\"Partially Cleared\",K3-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":50},{"$f":"R3","v":50},{"$f":"IF($R3=\"\",\"\",$R3)","v":50},3.333333333333333,{"$f":"IFERROR(T3*U3,0)","v":166.66666666666666}]
[null,"A3",100,2,1,0,0.75,"Alpha",{"$f":"VLOOKUP($B4,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":2.6666666666666665},2.6666666666666665,75,{"$f":"SUM($K$2:$K$4)","v":210},{"$f":"SUM($K$2:K4)","v":210},{"$f":"M4-M3","v":75},1,null,"Cleared",{"$f":"IF($Q4=\"Cleared\",K4,IF($Q4=\"Partially Cleared\",K4-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":75},75,75,3.333333333333333,249.99999999999997]
[null,"A4",100,3,2,0,0.9,"Charlie",{"$f":"VLOOKUP($B5,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":3.333333333333333},3.333333333333333,90,{"$f":"SUM($K$2:$K$5)","v":300},{"$f":"SUM($K$2:K5)","v":300},90,1,null,"Cleared",{"$f":"IF($Q5=\"Cleared\",K5,IF($Q5=\"Partially Cleared\",K5-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":90},90,90,3.333333333333333,300]
[null,"A1",100,3,3,0,0.9,"Gamma",{"$f":"VLOOKUP($B6,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":3.333333333333333},3.333333333333333,90,{"$f":"SUM($K$2:$K$6)","v":390},{"$f":"SUM($K$2:K6)","v":390},90,1,null,"Partially Cleared",{"$f":"IF($Q6=\"Cleared\",K6,IF($Q6=\"Partially Cleared\",K6-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":86.59266875000003},86.59266875000003,86.59266875000003,3.333333333333333,288.64222916666677]
[null,"A5",100,4,3,0,0.72,"Delta",{"$f":"VLOOKUP($B7,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":5.5555555555555554},5.5555555555555554,72,{"$f":"SUM($K$2:$K$7)","v":462},{"$f":"SUM($K$2:K7)","v":462},72,1,null,"Not Cleared",{"$f":"IF($Q7=\"Cleared\",K7,IF($Q7=\"Partially Cleared\",K7-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A14",100,6,3,0,0.78,"Harry",{"$f":"VLOOKUP($B8,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":7.6923076923076916},7.6923076923076916,78,{"$f":"SUM($K$2:$K$8)","v":540},{"$f":"SUM($K$2:K8)","v":540},78,1,null,"Not Cleared",{"$f":"IF($Q8=\"Cleared\",K8,IF($Q8=\"Partially Cleared\",K8-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A9",100,8,6,0,0.88,"Foxtrot",{"$f":"VLOOKUP($B9,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,88,{"$f":"SUM($K$2:$K$9)","v":628},{"$f":"SUM($K$2:K9)","v":628},88,1,null,"Not Cleared",{"$f":"IF($Q9=\"Cleared\",K9,IF($Q9=\"Partially Cleared\",K9-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A11",100,10,5,0,0.85,"Gamma",{"$f":"VLOOKUP($B10,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,85,{"$f":"SUM($K$2:$K$10)","v":713},{"$f":"SUM($K$2:K10)","v":713},85,1,null,"Not Cleared",{"$f":"IF($Q10=\"Cleared\",K10,IF($Q10=\"Partially Cleared\",K10-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A7",100,6,5,0,0.8,"Alpha",{"$f":"VLOOKUP($B11,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,80,{"$f":"SUM($K$2:$K$11)","v":793},{"$f":"SUM($K$2:K11)","v":793},80,1,null,"Not Cleared",{"$f":"IF($Q11=\"Cleared\",K11,IF($Q11=\"Partially Cleared\",K11-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A6",100,5,4,0,0.78,"Bravo",{"$f":"VLOOKUP($B12,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,78,{"$f":"SUM($K$2:$K$12)","v":871},{"$f":"SUM($K$2:K12)","v":871},78,1,null,"Not Cleared",{"$f":"IF($Q12=\"Cleared\",K12,IF($Q12=\"Partially Cleared\",K12-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A10",100,9,8,0,0.78,"Charlie",{"$f":"VLOOKUP($B13,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,78,{"$f":"SUM($K$2:$K$13)","v":949},{"$f":"SUM($K$2:K13)","v":949},78,1,null,"Not Cleared",{"$f":"IF($Q13=\"Cleared\",K13,IF($Q13=\"Partially Cleared\",K13-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A12",100,10,5,0,0.75,"Echo",{"$f":"VLOOKUP($B14,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,75,{"$f":"SUM($K$2:$K$14)","v":1024},{"$f":"SUM($K$2:K14)","v":1024},75,1,null,"Not Cleared",{"$f":"IF($Q14=\"Cleared\",K14,IF($Q14=\"Partially Cleared\",K14-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A15",100,5,4,0,0.72,"Delta",{"$f":"VLOOKUP($B15,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},999,72,{"$f":"SUM($K$2:$K$15)","v":1096},{"$f":"SUM($K$2:K15)","v":1096},72,1,null,"Not Cleared",{"$f":"IF($Q15=\"Cleared\",K15,IF($Q15=\"Partially Cleared\",K15-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"A8",100,7,5,0,0.7,"Echo",{"$f":"VLOOKUP($B16,'MRTS Clearing TPSSOLVE'!$B$2:$Y$16,24,0)","v":999},{"$f":"IF(O16<0,\"\",I16/O16)","v":999},70,{"$f":"SUM($K$2:$K$16)","v":1166},{"$f":"SUM($K$2:K16)","v":1166},70,1,null,"Not Cleared",{"$f":"IF($Q16=\"Cleared\",K16,IF($Q16=\"Partially Cleared\",K16-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","","",0]
[null,"RegD Resources","RawMW","$ Price Offer","$ Cost Offer","Self Schedule","Perf Score","Owner","PostTPS Adj Offer (Assume LOC Included)","Cost per Effective RegA","Perf Adj MW","Cum Perf Adj MW","Cum Eff MW","Indiv Eff MW","RTS",null,"Status","Cleared Perf Adj MW","Cleared Eff MW for Isoquant","Cleared Eff MW","$ Per Eff RegA","Settlement Credit"]
[null,"D10",100,9,8,1,0.93,"Foxtrot",{"$f":"VLOOKUP($B18,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":0},{"$f":"IF(O18<=0,\"\",I18/O18)","v":0},{"$f":"C18*G18","v":93},{"$f":"SUM($K$18)","v":93},{"$f":"IF(L18<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L18*('MRTS Clearing TPSSOLVE'!$AB$61-O18))+(L18*O18),IF(L18<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L18-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L18))+((L18-'MRTS Clearing TPSSOLVE'!$X$61)*O18),IF(L18<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L18-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L18))+((L18-'MRTS Clearing TPSSOLVE'!$X$62)*O18),IF(L18<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L18-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L18))+((L18-'MRTS Clearing TPSSOLVE'!$X$63)*O18),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L18-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L18))+((L18-'MRTS Clearing TPSSOLVE'!$X$64)*O18)))))","v":310.20249999999999},{"$f":"M18","v":310.20249999999999},{"$f":"IF(L18<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L18+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L18<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L18+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L18<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L18+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L18<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L18+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L18+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":1.6983333333333333},null,{"$f":"INDEX($H$32:$H$58,MATCH(B18,$B$32:$B$58,0))","v":"Cleared"},{"$f":"IF($Q18=\"Cleared\",K18,IF($Q18=\"Partially Cleared\",K18-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":93},{"$f":"IF($Q18=\"Cleared\",N18,IF($Q18=\"Partially Cleared\",N18-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":310.20249999999999},{"$f":"IF($R18=\"\",\"\",$R18*$L$39)","v":81.019275000000007},3.333333333333333,{"$f":"IFERROR(T18*U18,0)","v":270.06425000000002}]
[null,"D9",50,8,6,1,0.89,"Harry",{"$f":"VLOOKUP($B19,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":0},{"$f":"IF(O19<=0,\"\",I19/O19)","v":0},44.5,{"$f":"SUM($K$18:$K$19)","v":137.5},{"$f":"IF(L19<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L19*('MRTS Clearing TPSSOLVE'!$AB$61-O19))+(L19*O19),IF(L19<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L19-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L19))+((L19-'MRTS Clearing TPSSOLVE'!$X$61)*O19),IF(L19<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L19-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L19))+((L19-'MRTS Clearing TPSSOLVE'!$X$62)*O19),IF(L19<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L19-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L19))+((L19-'MRTS Clearing TPSSOLVE'!$X$63)*O19),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L19-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L19))+((L19-'MRTS Clearing TPSSOLVE'!$X$64)*O19)))))","v":373.12673611111109},{"$f":"IF(M19<M18,0,M19-M18)","v":62.924236111111099},{"$f":"IF(L19<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L19+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L19<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L19+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L19<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L19+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L19<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L19+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L19+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":1.1297222222222221},null,"Cleared",{"$f":"IF($Q19=\"Cleared\",K19,IF($Q19=\"Partially Cleared\",K19-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":44.5},{"$f":"IF($Q19=\"Cleared\",N19,IF($Q19=\"Partially Cleared\",N19-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":62.924236111111099},{"$f":"IF($R19=\"\",\"\",$R19*$L$39)","v":38.767287500000002},3.333333333333333,{"$f":"IFERROR(T19*U19,0)","v":129.22429166666666}]
[null,"D5",50,2,3,0,0.84,"Echo",{"$f":"VLOOKUP($B20,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":2.3809523809523809},2.7330357057449777,42,{"$f":"SUM($K$18:$K$20)","v":179.5},{"$f":"IF(L20<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L20*('MRTS Clearing TPSSOLVE'!$AB$61-O20))+(L20*O20),IF(L20<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L20-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L20))+((L20-'MRTS Clearing TPSSOLVE'!$X$61)*O20),IF(L20<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L20-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L20))+((L20-'MRTS Clearing TPSSOLVE'!$X$62)*O20),IF(L20<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L20-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L20))+((L20-'MRTS Clearing TPSSOLVE'!$X$63)*O20),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L20-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L20))+((L20-'MRTS Clearing TPSSOLVE'!$X$64)*O20)))))","v":413.40733124999997},{"$f":"IF(M20<M19,0,M20-M19)","v":40.280595138888884},{"$f":"IF(L20<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L20+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L20<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L20+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L20<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L20+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L20<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L20+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L20+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.87117500000000003},null,"Cleared",{"$f":"IF($Q20=\"Cleared\",K20,IF($Q20=\"Partially Cleared\",K20-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":42},{"$f":"IF($Q20=\"Cleared\",N20,IF($Q20=\"Partially Cleared\",N20-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":40.280595138888884},36.589350000000003,3.333333333333333,121.9645]
[null,"D3",50,2,1,0,0.7,"Echo",{"$f":"VLOOKUP($B21,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":2.8571428571428572},3.789691092804798,35,{"$f":"SUM($K$18:$K$21)","v":214.5},{"$f":"IF(L21<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L21*('MRTS Clearing TPSSOLVE'!$AB$61-O21))+(L21*O21),IF(L21<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L21-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L21))+((L21-'MRTS Clearing TPSSOLVE'!$X$61)*O21),IF(L21<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L21-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L21))+((L21-'MRTS Clearing TPSSOLVE'!$X$62)*O21),IF(L21<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L21-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L21))+((L21-'MRTS Clearing TPSSOLVE'!$X$63)*O21),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L21-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L21))+((L21-'MRTS Clearing TPSSOLVE'!$X$64)*O21)))))","v":441.84658124999999},28.439250000000015,{"$f":"IF(L21<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L21+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L21<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L21+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L21<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L21+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L21<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L21+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L21+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.75392499999999996},null,"Not Cleared",{"$f":"IF($Q21=\"Cleared\",K21,IF($Q21=\"Partially Cleared\",K21-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q21=\"Cleared\",N21,IF($Q21=\"Partially Cleared\",N21-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D12",50,10,5,0,0.95,"Alpha",{"$f":"VLOOKUP($B22,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},1679.5561533288501,47.5,{"$f":"SUM($K$18:$K$22)","v":262},{"$f":"IF(L22<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L22*('MRTS Clearing TPSSOLVE'!$AB$61-O22))+(L22*O22),IF(L22<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L22-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L22))+((L22-'MRTS Clearing TPSSOLVE'!$X$61)*O22),IF(L22<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L22-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L22))+((L22-'MRTS Clearing TPSSOLVE'!$X$62)*O22),IF(L22<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L22-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L22))+((L22-'MRTS Clearing TPSSOLVE'!$X$63)*O22),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L22-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L22))+((L22-'MRTS Clearing TPSSOLVE'!$X$64)*O22)))))","v":473.87879999999996},32.03221874999997,{"$f":"IF(L22<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L22+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L22<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L22+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L22<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L22+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L22<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L22+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L22+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.5948},null,"Not Cleared",{"$f":"IF($Q22=\"Cleared\",K22,IF($Q22=\"Partially Cleared\",K22-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q22=\"Cleared\",N22,IF($Q22=\"Partially Cleared\",N22-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D11",50,10,5,0,0.94,"Harry",{"$f":"VLOOKUP($B23,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},2284.2117297359086,47,{"$f":"SUM($K$18:$K$23)","v":309},{"$f":"IF(L23<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L23*('MRTS Clearing TPSSOLVE'!$AB$61-O23))+(L23*O23),IF(L23<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L23-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L23))+((L23-'MRTS Clearing TPSSOLVE'!$X$61)*O23),IF(L23<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L23-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L23))+((L23-'MRTS Clearing TPSSOLVE'!$X$62)*O23),IF(L23<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L23-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L23))+((L23-'MRTS Clearing TPSSOLVE'!$X$63)*O23),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L23-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L23))+((L23-'MRTS Clearing TPSSOLVE'!$X$64)*O23)))))","v":498.13432500000005},24.255525000000091,{"$f":"IF(L23<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L23+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L23<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L23+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L23<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L23+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L23<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L23+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L23+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.43735000000000013},null,"Not Cleared",{"$f":"IF($Q23=\"Cleared\",K23,IF($Q23=\"Partially Cleared\",K23-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q23=\"Cleared\",N23,IF($Q23=\"Partially Cleared\",N23-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D8",100,6,5,0,0.91,"Gamma",{"$f":"VLOOKUP($B24,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},3730.7053941908712,91,{"$f":"SUM($K$18:$K$24)","v":400},{"$f":"IF(L24<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L24*('MRTS Clearing TPSSOLVE'!$AB$61-O24))+(L24*O24),IF(L24<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L24-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L24))+((L24-'MRTS Clearing TPSSOLVE'!$X$61)*O24),IF(L24<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L24-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L24))+((L24-'MRTS Clearing TPSSOLVE'!$X$62)*O24),IF(L24<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L24-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L24))+((L24-'MRTS Clearing TPSSOLVE'!$X$63)*O24),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L24-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L24))+((L24-'MRTS Clearing TPSSOLVE'!$X$64)*O24)))))","v":527.44444444444446},29.31011944444441,{"$f":"IF(L24<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L24+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L24<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L24+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L24<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L24+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L24<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L24+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L24+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.26777777777777778},null,"Not Cleared",{"$f":"IF($Q24=\"Cleared\",K24,IF($Q24=\"Partially Cleared\",K24-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q24=\"Cleared\",N24,IF($Q24=\"Partially Cleared\",N24-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D1",100,5,5,0,0.9,"Charlie",{"$f":"VLOOKUP($B25,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},4762.1822033898306,90,{"$f":"SUM($K$18:$K$25)","v":490},{"$f":"IF(L25<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L25*('MRTS Clearing TPSSOLVE'!$AB$61-O25))+(L25*O25),IF(L25<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L25-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L25))+((L25-'MRTS Clearing TPSSOLVE'!$X$61)*O25),IF(L25<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L25-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L25))+((L25-'MRTS Clearing TPSSOLVE'!$X$62)*O25),IF(L25<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L25-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L25))+((L25-'MRTS Clearing TPSSOLVE'!$X$63)*O25),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L25-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L25))+((L25-'MRTS Clearing TPSSOLVE'!$X$64)*O25)))))","v":548.93444444444447},21.490000000000009,{"$f":"IF(L25<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L25+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L25<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L25+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L25<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L25+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L25<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L25+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L25+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.20977777777777779},null,"Not Cleared",{"$f":"IF($Q25=\"Cleared\",K25,IF($Q25=\"Partially Cleared\",K25-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q25=\"Cleared\",N25,IF($Q25=\"Partially Cleared\",N25-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D7",50,6,5,0,0.87,"Charlie",{"$f":"VLOOKUP($B26,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},5496.7292290762371,43.5,{"$f":"SUM($K$18:$K$26)","v":533.5},{"$f":"IF(L26<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L26*('MRTS Clearing TPSSOLVE'!$AB$61-O26))+(L26*O26),IF(L26<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L26-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L26))+((L26-'MRTS Clearing TPSSOLVE'!$X$61)*O26),IF(L26<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L26-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L26))+((L26-'MRTS Clearing TPSSOLVE'!$X$62)*O26),IF(L26<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L26-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L26))+((L26-'MRTS Clearing TPSSOLVE'!$X$63)*O26),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L26-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L26))+((L26-'MRTS Clearing TPSSOLVE'!$X$64)*O26)))))","v":557.45005277777773},8.5156083333332617,{"$f":"IF(L26<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L26+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L26<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L26+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L26<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L26+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L26<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L26+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L26+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.18174444444444443},null,"Not Cleared",{"$f":"IF($Q26=\"Cleared\",K26,IF($Q26=\"Partially Cleared\",K26-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q26=\"Cleared\",N26,IF($Q26=\"Partially Cleared\",N26-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D6",100,5,4,0,0.83,"Harry",{"$f":"VLOOKUP($B27,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},7789.1362730659266,83,{"$f":"SUM($K$18:$K$27)","v":616.5},{"$f":"IF(L27<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L27*('MRTS Clearing TPSSOLVE'!$AB$61-O27))+(L27*O27),IF(L27<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L27-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L27))+((L27-'MRTS Clearing TPSSOLVE'!$X$61)*O27),IF(L27<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L27-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L27))+((L27-'MRTS Clearing TPSSOLVE'!$X$62)*O27),IF(L27<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L27-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L27))+((L27-'MRTS Clearing TPSSOLVE'!$X$63)*O27),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L27-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L27))+((L27-'MRTS Clearing TPSSOLVE'!$X$64)*O27)))))","v":570.31505277777774},12.865000000000009,{"$f":"IF(L27<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L27+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L27<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L27+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L27<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L27+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L27<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L27+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L27+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":0.12825555555555557},null,"Not Cleared",{"$f":"IF($Q27=\"Cleared\",K27,IF($Q27=\"Partially Cleared\",K27-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q27=\"Cleared\",N27,IF($Q27=\"Partially Cleared\",N27-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D2",100,5,5,0,0.75,"Harry",{"$f":"VLOOKUP($B28,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},12499.652439872098,75,{"$f":"SUM($K$18:$K$28)","v":691.5},{"$f":"IF(L28<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L28*('MRTS Clearing TPSSOLVE'!$AB$61-O28))+(L28*O28),IF(L28<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L28-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L28))+((L28-'MRTS Clearing TPSSOLVE'!$X$61)*O28),IF(L28<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L28-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L28))+((L28-'MRTS Clearing TPSSOLVE'!$X$62)*O28),IF(L28<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L28-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L28))+((L28-'MRTS Clearing TPSSOLVE'!$X$63)*O28),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L28-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L28))+((L28-'MRTS Clearing TPSSOLVE'!$X$64)*O28)))))","v":578.12171944444447},7.8066666666667288,{"$f":"IF(L28<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L28+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L28<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L28+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L28<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L28+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L28<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L28+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L28+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":7.9922222222222228E-2},null,"Not Cleared",{"$f":"IF($Q28=\"Cleared\",K28,IF($Q28=\"Partially Cleared\",K28-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q28=\"Cleared\",N28,IF($Q28=\"Partially Cleared\",N28-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[null,"D4",100,3,2,0,0.72,"Foxtrot",{"$f":"VLOOKUP($B29,'MRTS Clearing TPSSOLVE'!$B$18:$Y$29,24,0)","v":999},29801.126947298631,72,{"$f":"SUM($K$18:$K$29)","v":763.5},{"$f":"IF(L29<='MRTS Clearing TPSSOLVE'!$X$61,(0.5*L29*('MRTS Clearing TPSSOLVE'!$AB$61-O29))+(L29*O29),IF(L29<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$AE$61+(0.5*(L29-'MRTS Clearing TPSSOLVE'!$X$61)*'MRTS Clearing TPSSOLVE'!$Z$62*('MRTS Clearing TPSSOLVE'!$X$61-L29))+((L29-'MRTS Clearing TPSSOLVE'!$X$61)*O29),IF(L29<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+(0.5*(L29-'MRTS Clearing TPSSOLVE'!$X$62)*'MRTS Clearing TPSSOLVE'!$Z$63*('MRTS Clearing TPSSOLVE'!$X$62-L29))+((L29-'MRTS Clearing TPSSOLVE'!$X$62)*O29),IF(L29<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+(0.5*(L29-'MRTS Clearing TPSSOLVE'!$X$63)*'MRTS Clearing TPSSOLVE'!$Z$64*('MRTS Clearing TPSSOLVE'!$X$63-L29))+((L29-'MRTS Clearing TPSSOLVE'!$X$63)*O29),'MRTS Clearing TPSSOLVE'!$AE$61+'MRTS Clearing TPSSOLVE'!$AE$62+'MRTS Clearing TPSSOLVE'!$AE$63+'MRTS Clearing TPSSOLVE'!$AE$64+(0.5*(L29-'MRTS Clearing TPSSOLVE'!$X$64)*'MRTS Clearing TPSSOLVE'!$Z$65*('MRTS Clearing TPSSOLVE'!$X$64-L29))+((L29-'MRTS Clearing TPSSOLVE'!$X$64)*O29)))))","v":582.20571944444441},4.0839999999999463,{"$f":"IF(L29<='MRTS Clearing TPSSOLVE'!$X$61,'MRTS Clearing TPSSOLVE'!$Z$61*L29+'MRTS Clearing TPSSOLVE'!$AB$61,IF(L29<='MRTS Clearing TPSSOLVE'!$X$62,'MRTS Clearing TPSSOLVE'!$Z$62*L29+'MRTS Clearing TPSSOLVE'!$AB$62,IF(L29<='MRTS Clearing TPSSOLVE'!$X$63,'MRTS Clearing TPSSOLVE'!$Z$63*L29+'MRTS Clearing TPSSOLVE'!$AB$63,IF(L29<='MRTS Clearing TPSSOLVE'!$X$64,'MRTS Clearing TPSSOLVE'!$Z$64*L29+'MRTS Clearing TPSSOLVE'!$AB$64,'MRTS Clearing TPSSOLVE'!$Z$65*L29+'MRTS Clearing TPSSOLVE'!$AB$65))))","v":3.3522222222222231E-2},null,"Not Cleared",{"$f":"IF($Q29=\"Cleared\",K29,IF($Q29=\"Partially Cleared\",K29-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},{"$f":"IF($Q29=\"Cleared\",N29,IF($Q29=\"Partially Cleared\",N29-(INDEX($G$32:$G$58,MATCH(\"Partially Cleared\",$H$32:$H$58,0))-'MRTS Clearing TPSSOLVE'!$K$43),\"\"))","v":""},"","",0]
[]
["Simulated Regulation Market Clearing","Resource","PS","Cost per Effective RegA","Indiv Eff MW","RTS","Cum Eff MW","Status","Total Adjusted Cost",null,"Optimal Mix Summary:"]
[null,"A13",0.85,0,85,1,{"$f":"E32","v":85},{"$f":"IF(G32<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H31=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},{"$f":"IF(AND(OR(H32=\"Cleared\",H32=\"Partially Cleared\"),H33=\"Not Cleared\"),D32*(SUM($R$2:$R$16)+SUM($R$18:$R$29)*$L$39),\"\")","v":""},null,"Total Production Cost",{"$f":"MAX(I32:I58)","v":1809.8952708333334}]
[null,"D10",0.93,0,310.20249999999999,1.6983333333333333,{"$f":"IFERROR(G32+E33,\"\")","v":395.20249999999999},{"$f":"IF(G33<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H32=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"Total Effective MW",{"$f":"L34+L35","v":800}]
[null,"D9",0.89,0,62.924236111111099,1.1297222222222221,{"$f":"IFERROR(G33+E34,\"\")","v":458.12673611111109},{"$f":"IF(G34<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H33=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"RegA (Effective)",{"$f":"SUM(S2:S16)","v":386.59266875000003}]
[null,"A2",0.5,0,50,1,508.12673611111109,{"$f":"IF(G35<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H34=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"RegD (Effective)",{"$f":"SUM(S18:S29)","v":413.40733124999997}]
[null,"A3",0.75,2.6666666666666665,75,1,583.12673611111109,{"$f":"IF(G36<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H35=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"RegA (Perf Adj)",{"$f":"SUM(R2:R16)","v":386.59266875000003}]
[null,"D5",0.84,2.7330357057449777,40.280595138888884,0.87117500000000003,623.40733124999997,{"$f":"IF(G37<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H36=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"RegD (Perf Adj)",{"$f":"SUM(R18:R29)","v":179.5}]
[null,"A4",0.9,3.333333333333333,90,1,713.40733124999997,{"$f":"IF(G38<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H37=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Cleared"},"",null,"RMCP (per Eff RegA)",{"$f":"INDEX($D$32:$D$58,MATCH($L$32,$I$32:$I$58,0))","v":3.333333333333333}]
[null,"A1",0.9,3.333333333333333,90,1,803.40733124999997,{"$f":"IF(G39<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H38=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Partially Cleared"},1809.8952708333334,null,"MRTS",{"$f":"MIN(IF(Q18:Q29=\"Cleared\",O18:O29),IF(Q18:Q29=\"Partially Cleared\",O18:O29))","v":0.87117500000000003}]
[null,"D3",0.7,3.789691092804798,28.439250000000015,0.75392499999999996,831.84658124999999,{"$f":"IF(G40<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H39=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A5",0.72,5.5555555555555554,72,1,903.84658124999999,{"$f":"IF(G41<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H40=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A14",0.78,7.6923076923076916,78,1,981.84658124999999,{"$f":"IF(G42<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H41=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A9",0.88,999,88,1,1069.8465812499999,{"$f":"IF(G43<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H42=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A11",0.85,999,85,1,1154.8465812499999,{"$f":"IF(G44<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H43=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A7",0.8,999,80,1,1234.8465812499999,{"$f":"IF(G45<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H44=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A6",0.78,999,78,1,1312.8465812499999,{"$f":"IF(G46<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H45=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A10",0.78,999,78,1,1390.8465812499999,{"$f":"IF(G47<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H46=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A12",0.75,999,75,1,1465.8465812499999,{"$f":"IF(G48<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H47=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A15",0.72,999,72,1,1537.8465812499999,{"$f":"IF(G49<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H48=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"A8",0.7,999,70,1,1607.8465812499999,{"$f":"IF(G50<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H49=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D12",0.95,1679.5561533288501,32.03221874999997,0.5948,1639.8788,{"$f":"IF(G51<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H50=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D11",0.94,2284.2117297359086,24.255525000000091,0.43735000000000013,1664.134325,{"$f":"IF(G52<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H51=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D8",0.91,3730.7053941908712,29.31011944444441,0.26777777777777778,1693.4444444444443,{"$f":"IF(G53<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H52=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D1",0.9,4762.1822033898306,21.490000000000009,0.20977777777777779,1714.9344444444444,{"$f":"IF(G54<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H53=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D7",0.87,5496.7292290762371,8.5156083333332617,0.18174444444444443,1723.4500527777777,{"$f":"IF(G55<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H54=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D6",0.83,7789.1362730659266,12.865000000000009,0.12825555555555557,1736.3150527777777,{"$f":"IF(G56<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H55=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D2",0.75,12499.652439872098,7.8066666666667288,7.9922222222222228E-2,1744.1217194444444,{"$f":"IF(G57<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H56=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},""]
[null,"D4",0.72,29801.126947298631,4.0839999999999463,3.3522222222222231E-2,1748.2057194444442,{"$f":"IF(G58<'MRTS Clearing TPSSOLVE'!$K$43,\"Cleared\",IF(H57=\"Cleared\",\"Partially Cleared\",\"Not Cleared\"))","v":"Not Cleared"},{"$f":"IF(AND(OR(H58=\"Cleared\",H58=\"Partially Cleared\"),H70=\"Not Cleared\"),D58*(SUM($R$2:$R$16)+SUM($R$18:$R$29)*$L$39),\"\")","v":""}]

{"sheet":"Framework (Current vs MRTS)","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,0,24,0],[23,1,24,2],[23,4,23,5],[23,6,24,7],[24,4,24,5],[21,0,22,0],[21,1,22,2],[21,4,21,5],[21,6,21,7],[22,4,22,5],[22,6,22,7],[18,4,18,5],[18,6,18,7],[19,1,19,3],[19,4,19,5],[19,6,19,7],[20,1,20,3],[20,4,20,5],[20,6,20,7],[15,6,15,7],[16,0,18,0],[16,1,18,1],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[17,4,17,5],[17,6,17,7],[18,2,18,3],[13,0,15,0],[13,1,15,1],[13,2,13,3],[15,2,15,3],[15,4,15,5],[11,1,11,3],[11,4,11,5],[11,6,11,7],[12,1,12,3],[12,4,12,5],[12,6,12,7],[13,4,13,5],[13,6,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[8,1,8,3],[8,4,8,5],[8,6,8,7],[9,0,10,0],[9,1,10,2],[9,4,9,5],[9,6,9,7],[10,4,10,5],[10,6,10,7],[6,1,6,3],[6,4,6,5],[6,6,6,7],[7,1,7,3],[7,4,7,5],[7,6,7,7],[0,4,0,5],[0,6,0,7],[2,0,5,0],[2,1,5,1],[2,2,3,2],[4,2,5,2]]}
[null,null,null,null,"Current",null,"MRTS Framework"]
[null,null,null,null,"Conventional Generator","Energy Storage Device","Conventional Generator","Energy Storage Device"]
[1,"Regulation Price Offers","Cost-Based Regulation Offer","Capability Cost-Based Offer","[(Difference in Reduced Load and Base Load Heat Rate Fuel Input * Fuel Cost)/(Eco Max - Reg Min)] + Regulation Margin Adder ","Regulation Margin Risk Adder\nHeat Rate Adjustment (Operating Range) for Battery and Flywheel Units is zero.","[(Difference in Reduced Load and Base Load Heat Rate Fuel Input * Fuel Cost)/(Eco Max - Reg Min)] + Regulation Margin Adder ","Regulation Margin Risk Adder\nHeat Rate Adjustment (Operating Range) for Battery and Flywheel Units is zero."]
[null,null,null,"Performance Cost-Based Offer","{[(Heat Rate Loss* Fuel Cost)/Reg Band MW] + VOM}/Historic Mileage ","(VOM + Energy Storage Unit Losses) / Historic Mileage\nHeat Rate Adjustment (Non Steady-State Operation) for Battery and Flywheel Units is zero.","{[(Heat Rate Loss* Fuel Cost)/Reg Band MW] + VOM}/Historic Mileage ","(VOM + Energy Storage Unit Losses) / Historic Mileage\nHeat Rate Adjustment (Non Steady-State Operation) for Battery and Flywheel Units is zero."]
[null,null,"Price-Based Regulation Offer","Capability Price-Based Offer","Optional but <= $100 when sum with cost-based offer","Optional but <= $100 when sum with cost-based offer","Optional but <= $100 when sum with cost-based offer","Optional but <= $100 when sum with cost-based offer"]
[null,null,null,"Performance Price-Based Offer","Optional but adjusted by Historic Mileage ","Optional but adjusted by Historic Mileage ","Optional but adjusted by Historic Mileage ","Optional but adjusted by Historic Mileage "]
[2,"Regulation Offer MW",null,null,"Same",null,"Same"]
[3,"Performance Score",null,null,"Same",null,"Same"]
[4,"Mileage",null,null,"Same",null,"Same"]
[5,"Rate of Substitution between Signals",null,"RegA",1,null,1]
[null,null,null,"RegD","Benefits factor (BF)",null,"Rate of Technical Substitution (RTS)"]
[6,"Performance Adjusted MW",null,null,"Reg MW * Performance Score, That is MW * PS",null,"Reg MW * Performance Score, That is MW * PS"]
[7,"Effective MW",null,null,"MW * PS * BF",null,"(MW * PS * RTS) + ∆ (Area under the curve)"]
[8,"Initial Adjusted Cost","Adjusted Capability Cost",null,"Cap$ / (PS)",null,"Cap$ / (PS)"]
[null,null,"Adjusted Performance Cost",null,"(Per$ * Mileage) / (PS)",null,"(Per$ * Mileage) / (PS)"]
[null,null,"Adjusted LOC",null,"LOC / (PS)",null,"LOC / (PS)"]
[9,"Adjusted Total Cost","Adjusted Capability Cost",null,"Cap$ / (PS * BF)",null,"Cap$ / (PS * RTS)"]
[null,null,"Adjusted Performance Cost",null,"(Per$ * Mileage) / (PS * BF)",null,"(Per$ * Mileage) / ( PS * RTS)"]
[null,null,"Adjusted LOC",null,"LOC / (PS * BF)",null,"LOC / (PS * RTS)"]
[10,"RegD Offer$ in Term of RegA",null,null,"RegD($) = RegA($) * BF\nRegA($) = RegD($) / BF",null,"RegD($) = RegA($) * RTS\nRegA($) = RegD($) / RTS "]
[11,"Regulation Market Clearing Price (RMCP)",null,null,"Max{[(Cap$(A) + Per$(A) + LOC$(A))/(PS * MBF)], [(Cap$(D) + Per$(D) + LOC$(D) / (PS * MBF)}",null,"Max{[(Cap$(A) + Per$(A) + LOC$(A))/(PS * MRTS)], [(Cap$(D) + Per$(D) + LOC$(D) / (PS * MRTS)}"]
[12,"RMCP Components",null,"PCP","Max(Adjusted Performance Cost)",null,"None"]
[null,null,null,"CCP","RMCP minus max(Adjusted Performance Cost)",null,"None"]
[13,"Settlement Credit(s)",null,"PCP","RegMW * PCP * PS * Mileage Ratio",null,"RegMW * RMCP *PS * MRTS"]
[null,null,null,"CCP","RegMW * CCP * PS "]