{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RTC DAM Draft Scenario 1","RTC DAM Draft Scenario 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"RTC DAM Draft Scenario 1","index":0,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,8,19,9],[19,12,19,13],[17,12,17,13],[3,18,3,19],[4,18,4,19],[16,14,16,16],[3,1,5,1],[7,2,7,3],[18,14,18,16],[4,7,6,7],[7,7,9,7],[1,7,1,13],[3,14,4,14],[3,15,3,16],[4,15,4,16],[8,2,8,3]]}
[]
[null,null,null,null,null,null,null,"Determine Awards that Maximize the Solution Value \nsubject to transmission constraints shown below"]
[]
[null,"AS Demand \nCurves","Product","MW","Price","Procured",null,"QSE","Product","Bid or Offer","Location","MW","Price","Awarded \nMW",null,"Bid-based Revenues",null,"–","Offer-based Costs",null," =","Value"]
[null,null,"ECRS",8,35,{"$f":"N6+N9","v":0},null,"QSE 1","Energy","Offer","A",100,20,null,null,{"$f":"(N11*M11)+(N12*M12)+(F5*E5)+(F6*E6)","v":0},null,"–",{"$f":"(N5*M5)+(N6*M6)+(N7*M7)+(N8*M8)+(N9*M9)+(N10*M10)","v":0},null," =",{"$f":"P5-S5","v":0}]
[null,null,"Non-Spin",12,15,{"$f":"N7+N10","v":0},null,null,"ECRS","Offer","--",10,25]
[null,null,null,null,null,null,null,null,"Non-Spin","Offer","--",20,5]
[null,null,{"$f":"IF((N6+N9)<D5,\"ECRS not fulfilled\",\"\")","v":"ECRS not fulfilled"},null,null,null,null,"QSE 2","Energy","Offer","C",60,30,null,null,"LMPA","LMPB","LMPC","LMPD",null,"MCPCECRS","MCPCNS"]
[null,null,{"$f":"IF((N7+N10)<D6,\"Non-Spin not fulfilled\",\"\")","v":"Non-Spin not fulfilled"},null,null,null,null,null,"ECRS","Offer","--",20,15]
[null,null,null,null,null,null,null,null,"Non-Spin","Offer","--",10,15]
[null,null,null,null,null,null,null,"QSE 3","Energy","Bid","D",90,40]
[null,null,null,null,null,null,null,"QSE 4","PTP OBL","Bid","A to B",30,20]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N5+N8=N11,\"Power is balanced\",\"Cleared Energy Offers must equal cleared Energy Bids\")","v":"Power is balanced"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF((N5+N12)>100,\"A to B path is overloaded\",\"\")","v":""},null,null,null,{"$f":"IF(N11>90,\"QSE 3 only wants 90MW\",\"\")","v":""}]

{"sheet":"RTC DAM Draft Scenario 2","index":1,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,8,19,9],[19,12,19,13],[7,2,7,3],[7,7,9,7],[8,2,8,3],[17,12,17,13],[18,14,18,16],[1,7,1,13],[3,1,5,1],[3,14,4,14],[3,15,3,16],[3,18,3,19],[4,7,6,7],[4,15,4,16],[4,18,4,19],[16,14,16,16]]}
[]
[null,null,null,null,null,null,null,"Determine Awards that Maximize the Solution Value \nsubject to transmission constraints shown below"]
[]
[null,"AS Demand \nCurves","Product","MW","Price","Procured",null,"QSE","Product","Bid or Offer","Location","MW","Price","Awarded \nMW",null,"Bid-based Revenues",null,"–","Offer-based Costs",null," =","Value"]
[null,null,"ECRS",8,35,{"$f":"N6+N9","v":0},null,"QSE 1","Energy","Offer","A",100,20,null,null,{"$f":"(N11*M11)+(N12*M12)+(F5*E5)+(F6*E6)","v":0},null,"–",{"$f":"(N5*M5)+(N6*M6)+(N7*M7)+(N8*M8)+(N9*M9)+(N10*M10)","v":0},null," =",{"$f":"P5-S5","v":0}]
[null,null,"Non-Spin",12,15,{"$f":"N7+N10","v":0},null,null,"ECRS","Offer","--",10,25]
[null,null,null,null,null,null,null,null,"Non-Spin","Offer","--",20,25]
[null,null,{"$f":"IF((N6+N9)<D5,\"ECRS not fulfilled\",\"\")","v":"ECRS not fulfilled"},null,null,null,null,"QSE 2","Energy","Offer","C",60,30,null,null,"LMPA","LMPB","LMPC","LMPD",null,"MCPCECRS","MCPCNS"]
[null,null,{"$f":"IF((N7+N10)<D6,\"Non-Spin not fulfilled\",\"\")","v":"Non-Spin not fulfilled"},null,null,null,null,null,"ECRS","Offer","--",20,15]
[null,null,null,null,null,null,null,null,"Non-Spin","Offer","--",10,5]
[null,null,null,null,null,null,null,"QSE 3","Energy","Bid","D",90,40]
[null,null,null,null,null,null,null,"QSE 4","PTP OBL","Bid","A to B",30,20]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N5+N8=N11,\"Power is balanced\",\"Cleared Energy Offers must equal cleared Energy Bids\")","v":"Power is balanced"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF((N5+N12)>100,\"A to B path is overloaded\",\"\")","v":""},null,null,null,{"$f":"IF(N11>90,\"QSE 3 only wants 90MW\",\"\")","v":""}]