{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example Prices","Divergent Prices"],"not_rendered":{"charts":0,"images":0,"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":"Example Prices","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,1,23,1],[18,1,20,1],[15,1,17,1],[10,1,10,2],[3,1,5,1],[16,6,19,7],[1,1,1,2],[6,1,7,1],[8,1,8,2],[13,1,14,1],[6,5,6,7],[7,5,7,7],[8,5,8,7]]}
[]
[null,"Type of Settlement",null,"Result",null,null,"Resource Node A","West Hub","West Load Zone"]
[null,"CRR Auction","Charge for Awarded PTP Option",{"$f":"D14*I8 + D15*I9","v":0},null,"Bilateral Trade",50,55,60]
[null,"Day-Ahead \nMarket","DAM Energy Purchase",{"$f":"D16*G4+D17*H4+D18*I4","v":0},null,"Day-Ahead Market",35,43,50]
[null,null,"Payment for PTP Option",{"$f":"-(D14*(I4-H4)+D15*(I4-G4))","v":0},null,"Real-Time Market",25,35,40]
[null,null,"Charge for DAM PTP Obligations",{"$f":"D19*(I4-H4)+D20*(H4-G4)+D21*(I4-G4)","v":0}]
[null,"Real-Time\nMarket","Real-Time Energy Imbalance",{"$f":"-((D16+D22)*G5)-((D17+D23)*H5)-((D18+D24-100)*I5)","v":4000},null,"Peak Weekday PTP Option",null,null,"Auction Price"]
[null,null,"Payment for DAM PTP Obligation",{"$f":"-(D19*(I5-H5)+D20*(H5-G5)+D21*(I5-G5))","v":0},null,"West Hub to West Load Zone",null,null,2]
[null,"Net ERCOT Settlement",null,{"$f":"SUM(D3:D8)","v":4000},null,"Resource Node A to West Load Zone",null,null,3]
[null,"Energy Trade","Cost to LSE for Energy Traded",{"$f":"D22*G3+D23*H3+D24*I3","v":0}]
[null,"NET Cost to Serve 100 MW Load",null,{"$f":"SUM(D9:D10)","v":4000}]
[]
[null,null,"Location / Path","MW"]
[null,"Buy CRR?","West Hub to West Load Zone"]
[null,null,"Resource Node A to West Load Zone"]
[null,"Buy DAM Energy?","Resource Node A"]
[null,null,"West Hub",null,null,null,"Enter MW values of financial instruments\nyou wish to buy"]
[null,null,"West Load Zone"]
[null,"Buy DAM PTP?","West Hub to West Load Zone"]
[null,null,"Resource Node A to West Hub"]
[null,null,"Resource Node A to West Load Zone"]
[null,"Buy Trade?","Resource Node A"]
[null,null,"West Hub"]
[null,null,"West Load Zone"]

{"sheet":"Divergent Prices","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,1,23,1],[1,1,1,2],[3,1,5,1],[6,1,7,1],[6,5,6,7],[7,5,7,7],[8,1,8,2],[8,5,8,7],[10,1,10,2],[13,1,14,1],[15,1,17,1],[16,6,19,7],[18,1,20,1]]}
[]
[null,"Type of Settlement",null,"Result",null,null,"Resource Node A","West Hub","West Load Zone"]
[null,"CRR Auction","Charge for Awarded PTP Option",{"$f":"D14*I8 + D15*I9","v":0},null,"Bilateral Trade",50,55,60]
[null,"Day-Ahead \nMarket","DAM Energy Purchase",{"$f":"D16*G4+D17*H4+D18*I4","v":0},null,"Day-Ahead Market",80,83,90]
[null,null,"Payment for PTP Option",{"$f":"-(D14*(I4-H4)+D15*(I4-G4))","v":0},null,"Real-Time Market",95,100,120]
[null,null,"Charge for DAM PTP Obligations",{"$f":"D19*(I4-H4)+D20*(H4-G4)+D21*(I4-G4)","v":0}]
[null,"Real-Time\nMarket","Real-Time Energy Imbalance",{"$f":"-((D16+D22)*G5)-((D17+D23)*H5)-((D18+D24-100)*I5)","v":12000},null,"Peak Weekday PTP Option",null,null,"Auction Price"]
[null,null,"Payment for DAM PTP Obligation",{"$f":"-(D19*(I5-H5)+D20*(H5-G5)+D21*(I5-G5))","v":0},null,"West Hub to West Load Zone",null,null,2]
[null,"Net ERCOT Settlement",null,{"$f":"SUM(D3:D8)","v":12000},null,"Resource Node A to West Load Zone",null,null,3]
[null,"Energy Trade","Cost to LSE for Energy Traded",{"$f":"D22*G3+D23*H3+D24*I3","v":0}]
[null,"NET Cost to Serve 100 MW Load",null,{"$f":"SUM(D9:D10)","v":12000}]
[]
[null,null,"Location / Path","MW"]
[null,"Buy CRR?","West Hub to West Load Zone"]
[null,null,"Resource Node A to West Load Zone"]
[null,"Buy DAM Energy?","Resource Node A"]
[null,null,"West Hub",null,null,null,"Enter MW values of financial instruments\nyou wish to buy"]
[null,null,"West Load Zone"]
[null,"Buy DAM PTP?","West Hub to West Load Zone"]
[null,null,"Resource Node A to West Hub"]
[null,null,"Resource Node A to West Load Zone"]
[null,"Buy Trade?","Resource Node A"]
[null,null,"West Hub"]
[null,null,"West Load Zone"]