{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","System","Optimization Engine","Answer Report","Sensitivity Report"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":417,"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":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,3,1],[11,0,11,1],[15,0,15,1],[0,0,0,1],[20,0,20,1],[1,0,1,1]]}
["Instructions"]
["DISCLAIMER: This tool is made available by ERCOT and is intended for educational purposes only. It should not be relied upon for the purpose of directing market participant behavior or developing market strategies. Support for the tool is limited and ERCOT is not responsible for outcomes arising from use of the tool beyond its intended purpose. Users should always refer to published materials from the RTC+B Task Force and approved governing documents, which may evolve separately from the development of this tool."]
[]
["Overview"]
["Sheet","Description"]
["Instructions","This sheet!"]
["System","Contains the inputs to the system (i.e. Resource, Line, and Load parameters), a one-line of the system, as well as the output of the SCED optimization. This is the main sheet where you will change system inputs to produce the different conditions required for each of the different scenarios."]
["Optimization Engine","Contains the formulation of the Linear Programming problem used to model and solve the SCED problem. There will be a few things on this sheet you will be required to use to answer some of the questions but it will all be locked from editing."]
["Answer Report","Details the results from the Simplex LP optimization problem, including the variable values, and objective function."]
["Sensitivity Report","Details the results from the Simplex LP optimization problem, including the shadow prices for each of the constraints."]
[]
["How to Run"]
[1,"On the 'System' sheet, enter in your desired system parameters in the 'Inputs' section"]
[2,"On the 'System' sheet, click 'Run SCED'"]
[3,"Results will update automatically in both the 'System' sheet and the 'Optimization Engine' sheet from both the 'Answer Report' and 'Sensitivity Report' sheets"]
["Notes"]
[1,"Do not edit or change the text of any cell outside the 'Inputs' section on the 'System' sheet"]
[2,"The password to any protected sheet is 'ercot123' but keep in mind the protection is there to keep the problem from being broken."]
[3,"Make sure the proper References are added  to the sheet prior to running, as seen in the figure below. To get to the VBA screen for Excel, hit Alt + F11. Once there, click Tools, then References… and it will open a References screen. Ensure 'Solver' is selected. This is Excels Optimization Solver tool that will be used to solve the Linear Programming optimization problem."]
[]
["Assumptions and Deviation from RTC"]
[1,"System magnitude is lessened (5 gens, 3 loads). AS plan is reduced. AS demand curves try to mimic the shape and magnitudes of curves using techniques described in RTC key principles."]
[2,"AS Demand curves are blocky step functions rather than step-wise linear. Excel simplex solver requires linearity, and step-wise demand curves require a quadratic solver."]
[3,"This tool doesn't demonstrate handling CC configurations. RTC will handle with mixed integer optimization."]
[4,"Assume that HDL = HSL and LDL = LSL. In RTC, these may be different."]

{"sheet":"System","index":1,"n_rows":100,"n_cols":22,"rows_kept":100,"cut":false,"hidden":false,"merged":[[80,16,80,17],[81,16,81,17],[91,16,91,17],[92,16,92,17],[82,16,82,17],[83,16,83,17],[90,16,90,17],[86,6,86,13],[86,15,86,17],[87,16,87,17],[88,16,88,17],[89,16,89,17],[79,11,79,12],[54,18,55,19],[75,16,75,17],[69,16,69,17],[70,16,70,17],[71,16,71,17],[72,16,72,17],[73,16,73,17],[60,14,60,15],[60,10,60,11],[67,7,67,15],[77,15,77,17],[78,16,78,17],[79,16,79,17],[77,6,77,12],[50,9,50,10],[36,11,36,12],[55,4,56,5],[55,7,56,8],[78,11,78,12],[45,4,45,5],[53,10,53,11],[0,1,1,23],[3,2,4,4],[5,8,5,12],[5,13,5,15],[14,5,14,7],[14,15,14,16],[14,10,14,12],[34,20,35,21],[4,6,4,15],[74,16,74,17],[24,1,25,3],[28,2,29,3],[40,2,41,3],[44,19,44,20],[49,3,49,4],[47,17,47,18],[50,13,50,14],[68,16,68,17],[65,4,66,6],[35,16,35,17],[35,5,35,6],[53,14,53,15],[41,11,41,12]]}
[null,"RTC Simulator Tool"]
[]
[]
[null,null,"I N P U T S"]
[null,null,null,null,null,null,"Resource Data"]
[null,null,null,null,null,null,null,null,"Offers ($/MWh)",null,null,null,null,"Limits (MW)"]
[null,null,null,null,null,null,"Resource","Bus","Energy","REGUP","RRS","ECRS","NSPIN","AS Qty","LSL","HSL"]
[null,null,null,null,null,null,"G1","A",14,0,20,0,0,20,0,110]
[null,null,null,null,null,null,"G2","A",15,0,20,0,0,20,0,100,null,null,null,null,null,"."]
[null,null,null,null,null,null,"G3","C",30,0,0,0,0,0,0,520]
[null,null,null,null,null,null,"G4","D",29,0,20,0,0,20,0,200]
[null,null,null,null,null,null,"G5","E",10,0,20,0,0,20,0,400]
[null,null,null,null,null,null,"L1","E",10,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(P8:P13)","v":1330}]
[null,null,null,null,null,"Load Data",null,null,null,null,"Line Data",null,null,null,null,"AS Plan"]
[null,null,null,null,null,"Load","Bus","Load",null,null,"Line","Limit*","Max Shadow",null,null,"AS Type","Amount"]
[null,null,null,null,null,"AUS","B",300,null,null,"L1",1000,4500,null,null,"REGUP",0]
[null,null,null,null,null,"HOU","C",300,null,null,"L2",1000,4500,null,null,"RRS",0]
[null,null,null,null,null,"DFW","D",500,null,null,"L3",1000,4500,null,null,"ECRS",0]
[null,null,null,null,null,null,"TOTAL",{"$f":"SUM(H17:H19)","v":1100},null,null,"L4",1000,4500,null,null,"NSPIN",0]
[null,null,null,null,null,null,"Load + AS Plan",{"$f":"H20+Q21","v":1100},null,null,"L5",1000,4500,null,null,"TOTAL",{"$f":"SUM(Q17:Q20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"L6",1000,4500]
[]
[]
[null,"S Y S T E M"]
[]
[]
[]
[null,null,"L1"]
[]
[null,null,"BP:",{"$f":"'Optimization Engine'!F26","v":0}]
[null,null,"REGUP:",{"$f":"'Optimization Engine'!N26","v":0}]
[null,null,"RRS:",{"$f":"'Optimization Engine'!S26","v":0}]
[null,null,"ECRS:",{"$f":"'Optimization Engine'!X26","v":0}]
[null,null,"NSPIN:",{"$f":"'Optimization Engine'!AC26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G4"]
[null,null,null,null,null,"Bus E",null,null,null,null,null,null,null,null,null,null,"Bus D"]
[null,null,null,null,null,"LMP:",{"$f":"'Optimization Engine'!Q58","v":30},null,null,null,null,"Line 5",null,null,null,null,"LMP:",{"$f":"'Optimization Engine'!Q57","v":30},null,null,"BP:",{"$f":"'Optimization Engine'!F24","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,"Flow:",{"$f":"ABS(Line_5_Flow)","v":204.03532058178382},null,null,null,null,null,null,null,"REGUP:",{"$f":"'Optimization Engine'!N24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRS:",{"$f":"'Optimization Engine'!S24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECRS:",{"$f":"'Optimization Engine'!X24","v":0}]
[null,null,"G5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NSPIN:",{"$f":"'Optimization Engine'!AC24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Line 2"]
[null,null,"BP:",{"$f":"'Optimization Engine'!F25","v":400},null,null,null,null,null,null,null,"Flow:",{"$f":"ABS(Line_2_Flow)","v":158.08141687507865}]
[null,null,"REGUP:",{"$f":"'Optimization Engine'!N25","v":0}]
[null,null,"RRS:",{"$f":"'Optimization Engine'!S25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallas/Ft. Worth"]
[null,null,"ECRS:",{"$f":"'Optimization Engine'!X25","v":0},"Line 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW:",{"$f":"'Optimization Engine'!C15","v":500}]
[null,null,"NSPIN:",{"$f":"'Optimization Engine'!AC25","v":0},"Flow:",{"$f":"ABS(Line_6_Flow)","v":195.96467941821618}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow:",{"$f":"ABS(Line_4_Flow)","v":62.116737456862211}]
[null,null,null,"Bus A"]
[null,null,null,"LMP:",{"$f":"'Optimization Engine'!Q54","v":30},null,null,null,null,"Line 1",null,null,null,"Line 3"]
[null,null,null,null,null,null,null,null,null,"Flow:",{"$f":"ABS(Line_1_Flow)","v":247.88326254313807},null,null,"Flow:",{"$f":"ABS(Line_3_Flow)","v":52.116737456862175}]
[]
[null,null,null,null,null,null,null,null,null,null,"Bus B",null,null,null,"Bus C"]
[null,null,null,null,null,null,null,null,null,null,"LMP:",{"$f":"'Optimization Engine'!Q55","v":30},null,null,"LMP:",{"$f":"'Optimization Engine'!Q56","v":30},null,null,"G3"]
[null,null,null,null,"G2",null,null,"G1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP:",{"$f":"'Optimization Engine'!F23","v":290}]
[null,null,null,null,"BP:",{"$f":"'Optimization Engine'!F22","v":100},null,"BP:",{"$f":"'Optimization Engine'!F21","v":110},null,null,null,null,null,null,null,null,null,"REGUP:",{"$f":"'Optimization Engine'!N23","v":0}]
[null,null,null,null,"REGUP:",{"$f":"'Optimization Engine'!N22","v":0},null,"REGUP:",{"$f":"'Optimization Engine'!N21","v":0},null,null,null,null,null,null,null,null,null,"RRS:",{"$f":"'Optimization Engine'!S23","v":0}]
[null,null,null,null,"RRS:",{"$f":"'Optimization Engine'!S22","v":0},null,"RRS:",{"$f":"'Optimization Engine'!S21","v":0},null,null,null,null,null,null,null,null,null,"ECRS:",{"$f":"'Optimization Engine'!X23","v":0}]
[null,null,null,null,"ECRS:",{"$f":"'Optimization Engine'!X22","v":0},null,"ECRS:",{"$f":"'Optimization Engine'!X21","v":0},null,"Austin/San Antonio",null,null,null,"Houston",null,null,null,"NSPIN:",{"$f":"'Optimization Engine'!AC23","v":0}]
[null,null,null,null,"NSPIN:",{"$f":"'Optimization Engine'!AC22","v":0},null,"NSPIN:",{"$f":"'Optimization Engine'!AC21","v":0},null,"MW:",{"$f":"'Optimization Engine'!C13","v":300},null,null,"MW:",{"$f":"'Optimization Engine'!C14","v":300}]
[]
[]
[]
[null,null,null,null,"R E P O R T"]
[]
[null,null,null,null,null,null,null,"Gen Data"]
[null,null,null,null,null,null,"Resource","Bus","LSL","HSL","BP","REGUP","RRS","ECRS","NSPIN","LMP","Operating Cost"]
[null,null,null,null,null,null,"G1","A",{"$f":"'Optimization Engine'!D21","v":0},{"$f":"'Optimization Engine'!E21","v":110},{"$f":"'Optimization Engine'!F21","v":110},{"$f":"'Optimization Engine'!N21","v":0},{"$f":"'Optimization Engine'!S21","v":0},{"$f":"'Optimization Engine'!X21","v":0},{"$f":"'Optimization Engine'!AC21","v":0},{"$f":"'Optimization Engine'!Q54","v":30},{"$f":"'Optimization Engine'!G21","v":1540}]
[null,null,null,null,null,null,"G2","A",{"$f":"'Optimization Engine'!D22","v":0},{"$f":"'Optimization Engine'!E22","v":100},{"$f":"'Optimization Engine'!F22","v":100},{"$f":"'Optimization Engine'!N22","v":0},{"$f":"'Optimization Engine'!S22","v":0},{"$f":"'Optimization Engine'!X22","v":0},{"$f":"'Optimization Engine'!AC22","v":0},{"$f":"'Optimization Engine'!Q54","v":30},{"$f":"'Optimization Engine'!G22","v":1500}]
[null,null,null,null,null,null,"G3","C",{"$f":"'Optimization Engine'!D23","v":0},{"$f":"'Optimization Engine'!E23","v":520},{"$f":"'Optimization Engine'!F23","v":290},{"$f":"'Optimization Engine'!N23","v":0},{"$f":"'Optimization Engine'!S23","v":0},{"$f":"'Optimization Engine'!X23","v":0},{"$f":"'Optimization Engine'!AC23","v":0},{"$f":"'Optimization Engine'!Q56","v":30},{"$f":"'Optimization Engine'!G23","v":8700}]
[null,null,null,null,null,null,"G4","D",{"$f":"'Optimization Engine'!D24","v":0},{"$f":"'Optimization Engine'!E24","v":200},{"$f":"'Optimization Engine'!F24","v":200},{"$f":"'Optimization Engine'!N24","v":0},{"$f":"'Optimization Engine'!S24","v":0},{"$f":"'Optimization Engine'!X24","v":0},{"$f":"'Optimization Engine'!AC24","v":0},{"$f":"'Optimization Engine'!Q57","v":30},{"$f":"'Optimization Engine'!G24","v":5800}]
[null,null,null,null,null,null,"G5","E",{"$f":"'Optimization Engine'!D25","v":0},{"$f":"'Optimization Engine'!E25","v":400},{"$f":"'Optimization Engine'!F25","v":400},{"$f":"'Optimization Engine'!N25","v":0},{"$f":"'Optimization Engine'!S25","v":0},{"$f":"'Optimization Engine'!X25","v":0},{"$f":"'Optimization Engine'!AC25","v":0},{"$f":"'Optimization Engine'!Q58","v":30},{"$f":"'Optimization Engine'!G25","v":4000}]
[null,null,null,null,null,null,"L1","E",{"$f":"'Optimization Engine'!D26","v":0},{"$f":"'Optimization Engine'!E26","v":0},{"$f":"'Optimization Engine'!F26","v":0},{"$f":"'Optimization Engine'!N26","v":0},{"$f":"'Optimization Engine'!S26","v":0},{"$f":"'Optimization Engine'!X26","v":0},{"$f":"'Optimization Engine'!AC26","v":0},{"$f":"'Optimization Engine'!Q58","v":30},{"$f":"'Optimization Engine'!G26","v":0}]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I70:I75)","v":0},1330,1100,0,0,0,0,null,{"$f":"SUM(Q70:Q75)","v":21540}]
[]
[null,null,null,null,null,null,"System Data",null,null,null,null,null,null,null,null,"Ancillary Service Data"]
[null,null,null,null,null,null,null,"Total Base Points:",{"$f":"SUM(K70:K75)","v":1100},null,"System Lambda:",{"$f":"'Optimization Engine'!F37","v":30},null,null,null,"AS Type","MCPC ($/MWh)"]
[null,null,null,null,null,null,null,"PB Violation:",{"$f":"'Optimization Engine'!C32","v":0},null,"Objective Function",{"$f":"'Optimization Engine'!C40","v":21540},null,null,null,"REGUP",{"$f":"'Optimization Engine'!J34","v":1}]
[null,null,null,null,null,null,null,"Total Load:",{"$f":"'Optimization Engine'!C16","v":1100},null,null,null,null,null,null,"RRS",{"$f":"'Optimization Engine'!J35","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECRS",{"$f":"'Optimization Engine'!J36","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NSPIN",{"$f":"'Optimization Engine'!J37","v":1}]
[]
[]
[]
[null,null,null,null,null,null,"Line & Constraint Data",null,null,null,null,null,null,null,null,"Bus/LMP Data"]
[null,null,null,null,null,null,"Line","From Bus","To Bus","Limit","Flow","Violation","Shadow Price","Binding?",null,"Bus","LMP ($/MWh)"]
[null,null,null,null,null,null,"L1","A","B",{"$f":"'Optimization Engine'!I4","v":1000},{"$f":"'Optimization Engine'!J47","v":247.88326254313807},{"$f":"'Optimization Engine'!H47","v":0},{"$f":"'Optimization Engine'!M47","v":0},{"$f":"IF(M89>0,\"YES\",\"NO\")","v":"NO"},null,"A",{"$f":"'Optimization Engine'!Q54","v":30}]
[null,null,null,null,null,null,"L2","A","D",{"$f":"'Optimization Engine'!I5","v":1000},{"$f":"'Optimization Engine'!J48","v":158.08141687507865},{"$f":"'Optimization Engine'!H48","v":0},{"$f":"'Optimization Engine'!M48","v":0},"NO",null,"B",{"$f":"'Optimization Engine'!Q55","v":30}]
[null,null,null,null,null,null,"L3","B","C",{"$f":"'Optimization Engine'!I6","v":1000},{"$f":"'Optimization Engine'!J49","v":-52.116737456862175},{"$f":"'Optimization Engine'!H49","v":0},{"$f":"'Optimization Engine'!M49","v":0},"NO",null,"C",{"$f":"'Optimization Engine'!Q56","v":30}]
[null,null,null,null,null,null,"L4","C","D",{"$f":"'Optimization Engine'!I7","v":1000},{"$f":"'Optimization Engine'!J50","v":-62.116737456862211},{"$f":"'Optimization Engine'!H50","v":0},{"$f":"'Optimization Engine'!M50","v":0},"NO",null,"D",{"$f":"'Optimization Engine'!Q57","v":30}]
[null,null,null,null,null,null,"L5","D","E",{"$f":"'Optimization Engine'!I8","v":1000},{"$f":"'Optimization Engine'!J51","v":-204.03532058178382},{"$f":"'Optimization Engine'!H51","v":0},{"$f":"'Optimization Engine'!M51","v":0},"NO",null,"E",{"$f":"'Optimization Engine'!Q58","v":30}]
[null,null,null,null,null,null,"L6","E","A",{"$f":"'Optimization Engine'!I9","v":1000},{"$f":"'Optimization Engine'!J52","v":195.96467941821618},{"$f":"'Optimization Engine'!H52","v":0},{"$f":"'Optimization Engine'!M52","v":0},"NO"]
[null,null,null,null,null,null,"L1","B","A",{"$f":"'Optimization Engine'!I4","v":1000},{"$f":"'Optimization Engine'!J53","v":-247.88326254313807},{"$f":"'Optimization Engine'!H53","v":0},{"$f":"'Optimization Engine'!M53","v":0},"NO"]
[null,null,null,null,null,null,"L2","D","A",{"$f":"'Optimization Engine'!I5","v":1000},{"$f":"'Optimization Engine'!J54","v":-158.08141687507865},{"$f":"'Optimization Engine'!H54","v":0},{"$f":"'Optimization Engine'!M54","v":0},"NO"]
[null,null,null,null,null,null,"L3","C","B",{"$f":"'Optimization Engine'!I6","v":1000},{"$f":"'Optimization Engine'!J55","v":52.116737456862175},{"$f":"'Optimization Engine'!H55","v":0},{"$f":"'Optimization Engine'!M55","v":0},"NO"]
[null,null,null,null,null,null,"L4","D","C",{"$f":"'Optimization Engine'!I7","v":1000},{"$f":"'Optimization Engine'!J56","v":62.116737456862211},{"$f":"'Optimization Engine'!H56","v":0},{"$f":"'Optimization Engine'!M56","v":0},"NO"]
[null,null,null,null,null,null,"L5","E","D",{"$f":"'Optimization Engine'!I8","v":1000},{"$f":"'Optimization Engine'!J57","v":204.03532058178382},{"$f":"'Optimization Engine'!H57","v":0},{"$f":"'Optimization Engine'!M57","v":0},"NO"]
[null,null,null,null,null,null,"L6","A","E",{"$f":"'Optimization Engine'!I9","v":1000},{"$f":"'Optimization Engine'!J58","v":-195.96467941821618},{"$f":"'Optimization Engine'!H58","v":0},{"$f":"'Optimization Engine'!M58","v":0},"NO"]

{"sheet":"Optimization Engine","index":2,"n_rows":75,"n_cols":220,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,0,1,5],[10,0,10,2],[41,0,41,5],[10,4,10,5],[17,16,17,19],[18,16,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[18,13,19,13],[18,14,19,14],[18,12,19,12],[43,18,43,19],[33,1,33,2],[29,16,29,19],[30,16,31,16],[30,17,31,17],[30,18,31,18],[30,19,31,19],[29,11,29,14],[30,11,31,11],[30,12,31,12],[30,13,31,13],[30,14,31,14],[39,16,39,17],[43,20,43,21],[43,22,43,23],[43,24,43,25],[29,26,29,29],[30,26,31,26],[30,27,31,27],[30,28,31,28],[30,29,31,29],[29,21,29,24],[30,21,31,21],[30,22,31,22],[30,23,31,23],[30,24,31,24],[39,21,39,22],[41,26,41,27],[18,21,19,21],[18,22,19,22],[18,23,19,23],[18,24,19,24],[17,11,17,14],[17,21,17,24],[17,26,17,29],[18,26,19,26],[18,27,19,27],[18,28,19,28],[18,29,19,29],[63,0,68,0],[69,0,74,0],[61,9,62,9],[61,10,62,10],[61,4,61,8],[60,0,60,11],[39,0,39,1],[45,7,45,8],[18,3,18,4],[29,0,29,4],[18,6,19,6],[18,5,19,5],[18,11,19,11],[17,8,19,8],[17,2,17,6],[18,2,19,2],[39,11,39,12]]}
["Objective Function","Decision Variable","User Input","Parameter"]
["Shift Factor Matrix/Line Data",null,null,null,null,null,null,null,null,null,null,"Original Shift Factor Matrix (w/ A as Slack Bus)",null,null,null,null,null,null,null,null,null,"Load Distributed Shift Factor Matrix"]
[null,"A","B","C","D","E",null,"Line","Limit","Flow",null,null,"A","B","C","D","E",null,"Load*SF","SFC",null,null,"A","B","C","D","E"]
["L1",{"$f":"W4","v":0.41402007867364976},{"$f":"X4","v":-0.24801204237758523},{"$f":"Y4","v":-0.12258066462340422},0.22235562420059377,0.38004078480585046,null,"L1",{"$f":"System!L17","v":1000},{"$f":"MMULT(B4:F9,TRANSPOSE(B44:F44))","v":247.88326254313807},null,"L1",0,-0.66203212105123499,-0.53660074329705398,-0.191664454473056,-3.3979293867799298E-2,null,{"$f":"MMULT(M4:Q9,TRANSPOSE(M13:Q13))","v":-455.42208654101472},{"$f":"S4/SUM($M$13:$Q$13)","v":-0.41402007867364976},null,"L1",{"$f":"M4-$T4","v":0.41402007867364976},{"$f":"N4-$T4","v":-0.24801204237758523},-0.12258066462340422,0.22235562420059377,0.38004078480585046]
["L2",{"$f":"W5","v":0.31810338586287618},0.13463510871926018,6.654378936699118E-2,-0.12070733885175083,0.24030868674449346,null,"L2",{"$f":"System!L18","v":1000},158.08141687507865,null,"L2",0,-0.18346827714361599,-0.251559596495885,-0.43881072471462701,-7.7794699118382701E-2,null,-349.91372444916379,{"$f":"S5/SUM($M$13:$Q$13)","v":-0.31810338586287618},null,"L2",0.31810338586287618,0.13463510871926018,6.654378936699118E-2,-0.12070733885175083,0.24030868674449346]
["L3",0.14129280594637644,0.47926068489514245,-0.39530793735067654,-5.0371648526679552E-2,0.10731351207857714,null,"L3",{"$f":"System!L19","v":1000},-52.116737456862175,null,"L3",0,0.33796787894876601,-0.53660074329705298,-0.191664454473056,-3.3979293867799298E-2,null,-155.4220865410141,-0.14129280594637644,null,"L3",0.14129280594637644,0.47926068489514245,-0.39530793735067654,-5.0371648526679552E-2,0.10731351207857714]
["L4",-0.13143446678089626,0.20653341216786975,0.33196478992205075,-0.32309892125395223,-0.16541376064869556,null,"L4",{"$f":"System!L20","v":1000},-62.116737456862211,null,"L4",0,0.33796787894876601,0.46339925670294702,-0.191664454473056,-3.3979293867799298E-2,null,144.5779134589859,0.13143446678089626,null,"L4",-0.13143446678089626,0.20653341216786975,0.33196478992205075,-0.32309892125395223,-0.16541376064869556]
["L5",-0.26787653546347479,-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,-0.3796505284496568,null,"L5",{"$f":"System!L21","v":1000},-204.03532058178382,null,"L5",0,0.15449960180514999,0.21183966020706099,0.36952482081231802,-0.111773992986182,null,294.66418900982228,0.26787653546347479,null,"L5",-0.26787653546347479,-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,-0.3796505284496568]
["L6",-0.26787653546347479,-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,0.62034947155034326,null,"L6",{"$f":"System!L22","v":1000},195.96467941821618,null,"L6",0,0.15449960180514999,0.21183966020706099,0.36952482081231802,0.88822600701381804,null,294.66418900982228,0.26787653546347479,null,"L6",-0.26787653546347479,-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,0.62034947155034326]
[]
["Load Data",null,null,null,"AS Requirement",null,null,null,null,null,null,"Load Injection Array"]
["Load","Bus","Load",null,"REGUP",{"$f":"System!Q17","v":0},null,null,null,null,null,"Bus","A","B","C","D","E"]
["AUS","B",{"$f":"System!H17","v":300},null,"RRS",{"$f":"System!Q18","v":0},null,null,null,null,null,"Bus Injection",{"$f":"0","v":0},{"$f":"C13","v":300},{"$f":"C14","v":300},{"$f":"C15","v":500},{"$f":"0","v":0}]
["HOU","C",{"$f":"System!H18","v":300},null,"ECRS",{"$f":"System!Q19","v":0}]
["DFW","D",{"$f":"System!H19","v":500},null,"NSPIN",{"$f":"System!Q20","v":0}]
[null,"Sum",{"$f":"SUM(C13:C15)","v":1100}]
[]
["Resource Data",null,"Energy",null,null,null,null,null,"Energy + AS Award",null,null,"REGUP",null,null,null,null,"RRS",null,null,null,null,"ECRS",null,null,null,null,"NSPIN"]
[null,null,"Offers ($/MW)","Limits (MW)",null,"Award (MW)","Cost",null,null,null,null,"Offers ($/MW)","Offer QTY","Award (MW)","Cost",null,"Offers ($/MW)","Offer QTY","Award (MW)","Cost",null,"Offers ($/MW)","Offer QTY","Award (MW)","Cost",null,"Offers ($/MW)","Offer QTY","Award (MW)","Cost"]
["Resource","Bus",null,"LSL","HSL",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,"Offer QTY","Total Award"]
["G1","A",{"$f":"System!I8","v":14},{"$f":"System!O8","v":0},{"$f":"System!P8","v":110},110,{"$f":"F21*C21","v":1540},null,{"$f":"F21+N21+S21+X21+AC21","v":110},null,null,{"$f":"System!J8","v":0},{"$f":"System!N8","v":20},0,{"$f":"N21*L21","v":0},null,{"$f":"System!K8","v":20},{"$f":"System!N8","v":20},0,{"$f":"S21*Q21","v":0},null,{"$f":"System!L8","v":0},{"$f":"System!N8","v":20},0,{"$f":"X21*V21","v":0},null,{"$f":"System!M8","v":0},{"$f":"System!N8","v":20},0,{"$f":"AC21*AA21","v":0},null,{"$f":"System!N8","v":20},{"$f":"N21+S21+X21+AC21","v":0},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,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,0,0]
["G2","A",{"$f":"System!I9","v":15},{"$f":"System!O9","v":0},{"$f":"System!P9","v":100},100,1500,null,{"$f":"F22+N22+S22+X22+AC22","v":100},null,null,{"$f":"System!J9","v":0},{"$f":"System!N9","v":20},0,0,null,{"$f":"System!K9","v":20},{"$f":"System!N9","v":20},0,0,null,{"$f":"System!L9","v":0},{"$f":"System!N9","v":20},0,0,null,{"$f":"System!M9","v":0},{"$f":"System!N9","v":20},0,0,null,{"$f":"System!N9","v":20},{"$f":"N22+S22+X22+AC22","v":0},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,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,0,0]
["G3","C",{"$f":"System!I10","v":30},{"$f":"System!O10","v":0},{"$f":"System!P10","v":520},290,8700,null,290,null,null,{"$f":"System!J10","v":0},{"$f":"System!N10","v":0},0,0,null,{"$f":"System!K10","v":0},{"$f":"System!N10","v":0},0,{"$f":"S23*Q23","v":0},null,{"$f":"System!L10","v":0},{"$f":"System!N10","v":0},0,0,null,{"$f":"System!M10","v":0},{"$f":"System!N10","v":0},0,0,null,{"$f":"System!N10","v":0},0,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,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,0,0]
["G4","D",{"$f":"System!I11","v":29},{"$f":"System!O11","v":0},{"$f":"System!P11","v":200},200,5800,null,200,null,null,{"$f":"System!J11","v":0},{"$f":"System!N11","v":20},0,0,null,{"$f":"System!K11","v":20},{"$f":"System!N11","v":20},0,0,null,{"$f":"System!L11","v":0},{"$f":"System!N11","v":20},0,0,null,{"$f":"System!M11","v":0},{"$f":"System!N11","v":20},0,0,null,{"$f":"System!N11","v":20},0,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,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,0,0]
["G5","E",{"$f":"System!I12","v":10},{"$f":"System!O12","v":0},{"$f":"System!P12","v":400},400,4000,null,400,null,null,{"$f":"System!J12","v":0},{"$f":"System!N12","v":20},0,0,null,{"$f":"System!K12","v":20},{"$f":"System!N12","v":20},0,0,null,{"$f":"System!L12","v":0},{"$f":"System!N12","v":20},0,0,null,{"$f":"System!M12","v":0},{"$f":"System!N12","v":20},0,0,null,{"$f":"System!N12","v":20},0,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,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,0,0]
["L1","E",{"$f":"System!I13","v":10},{"$f":"System!O13","v":0},{"$f":"System!P13","v":0},0,0,null,{"$f":"F26+N26+S26+X26+AC26","v":0},null,null,{"$f":"System!J13","v":0},{"$f":"System!N13","v":0},0,0,null,{"$f":"System!K13","v":0},{"$f":"System!N13","v":0},0,0,null,{"$f":"System!L13","v":0},{"$f":"System!N13","v":0},0,0,null,{"$f":"System!M13","v":0},{"$f":"System!N13","v":0},0,0,null,{"$f":"System!N13","v":0},0]
[0,0,null,null,"Sum:",{"$f":"SUM(F21:F26)","v":1100},{"$f":"SUM(G21:G26)","v":21540},null,null,null,null,null,"Totals:",{"$f":"SUM(N21:N26)","v":0},{"$f":"SUM(O21:O26)","v":0},null,null,"Totals:",{"$f":"SUM(S21:S26)","v":0},{"$f":"SUM(T21:T26)","v":0},null,null,"Totals:",{"$f":"SUM(X21:X26)","v":0},{"$f":"SUM(Y21:Y26)","v":0},null,null,"Totals:",{"$f":"SUM(AC21:AC26)","v":0},{"$f":"SUM(AD21:AD26)","v":0}]
[null,null,null,null,"Sum + PBPC:",{"$f":"F27+C32","v":1100},null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
["Power Balance Penalty Curve",null,null,null,null,null,null,null,null,null,null,"REGUP ASDC Benefit",null,null,null,null,"RRS ASDC Benefit",null,null,null,null,"ECRS ASDC Benefit",null,null,null,null,"NSPIN ASDC Benefit"]
["LSL","HSL","BP","Penalty Value ($/MWh)",null,null,null,null,null,null,null,"Price","QTY","Award (MW)","Benefit",null,"Price","QTY","Award (MW)","Benefit",null,"Price","QTY","Award (MW)","Benefit",null,"Price","QTY","Award (MW)","Benefit"]
[0,99999,0,7000.01,{"$f":"C32*D32","v":0}]
[null,null,null,null,null,null,null,null,null,"MCPC",null,5000,{"$f":"$S$47","v":0},0,{"$f":"-N33*L33","v":0},null,5000,{"$f":"$U$47","v":0},0,{"$f":"-S33*Q33","v":0},null,2750,{"$f":"$W$47","v":0},0,{"$f":"-X33*V33","v":0},null,420,{"$f":"$Y$47","v":0},0,{"$f":"-AC33*AA33","v":0}]
[null,"Total Costs",null,null,null,null,null,null,"REGUP",1,null,5000,{"$f":"$S$47","v":0},0,{"$f":"-N34*L34","v":0},null,5000,{"$f":"$U$47","v":0},0,{"$f":"-S34*Q34","v":0},null,2100,{"$f":"$W$47","v":0},0,{"$f":"-X34*V34","v":0},null,150,{"$f":"$Y$47","v":0},0,{"$f":"-AC34*AA34","v":0}]
[null,"Energy",{"$f":"G27","v":21540},null,null,null,null,null,"RRS",1,null,5000,0,0,0,null,5000,0,0,0,null,1500,0,0,0,null,60,0,0,0]
[null,"AS",{"$f":"O27+T27+Y27+AD27","v":0},null,null,null,null,null,"ECRS",1,null,5000,0,0,0,null,3000,0,0,0,null,950,0,0,0,null,25,0,0,0]
[null,"AS Shortage",{"$f":"O38+T38+Y38+AD40","v":0},null,"Sys. Lambda =",30,null,null,"NSPIN",1,null,5000,0,0,0,null,3000,0,0,0,null,600,0,0,0,null,12,0,0,0]
[null,"Transmission Penalty",{"$f":"I59","v":0},null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(N33:N37)","v":0},{"$f":"SUM(O33:O37)","v":0},null,null,"Totals:",{"$f":"SUM(S33:S37)","v":0},{"$f":"SUM(T33:T37)","v":0},null,null,"Totals:",{"$f":"SUM(X33:X37)","v":0},{"$f":"SUM(Y33:Y37)","v":0},null,9,0,0,0]
[null,"Power Balance Penalty",{"$f":"E32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0]
["Objective Function:",null,{"$f":"G27+E32+I59+O27+T27+Y27+AD27+O38+T38+Y38+AD40","v":21540},null,null,null,null,null,null,null,null,"ASDC QTY - Award",null,{"$f":"N38 - N27","v":0},null,null,"ASDC QTY - Award",null,{"$f":"S38 - S27","v":0},null,null,"ASDC QTY - Award",null,{"$f":"X38 - X27","v":0},null,null,null,"Totals:",{"$f":"SUM(AC33:AC39)","v":0},{"$f":"SUM(AD33:AD39)","v":0}]
[]
["Injection Array",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,"ASDC QTY - Award",null,{"$f":"AC40 - AC27","v":0}]
["Bus","A","B","C","D","E"]
["Bus Injection",{"$f":"F21+F22","v":210},{"$f":"-C13","v":-300},{"$f":"F23-C14","v":-10},{"$f":"F24-C15","v":-300},{"$f":"F25+F26","v":400},null,null,null,null,null,null,null,null,null,null,null,null,"REGUP",null,"RRS",null,"ECRS",null,"NSPIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block","QTY","Price","QTY","Price","QTY","Price","QTY","Price"]
["Transmission Limits","A","B","C","D","E",null,"Slack",null,"Flow","Flow + Slack","PL Limit","Shadow Price",null,"Shadow Price",null,null,null,0,{"$f":"T47","v":5000},0,{"$f":"V47","v":5000},0,{"$f":"X47","v":2750},0,{"$f":"Z47","v":420}]
["L1 High Limit",{"$f":"B4*B$44","v":86.944216521466444},74.403612713275564,1.2258066462340422,-66.706687260178128,152.01631392234017,null,0,{"$f":"H47*System!M17","v":0},{"$f":"SUM(B47:F47)","v":247.88326254313807},{"$f":"J47-H47","v":247.88326254313807},{"$f":"I4","v":1000},0,null,"PL1",{"$f":"M47-M53","v":0},null,1,{"$f":"$R47*System!$Q$17/5","v":0},{"$f":"L33","v":5000},{"$f":"$R47*System!$Q$18/5","v":0},{"$f":"Q33","v":5000},{"$f":"$R47*System!$Q$19/5","v":0},{"$f":"V33","v":2750},{"$f":"$R47*System!$Q$20/7","v":0},{"$f":"AA33","v":420}]
["L2 High Limit",66.801711031203993,-40.390532615778056,-0.6654378936699118,36.212201655525249,96.123474697797377,null,0,{"$f":"H48*System!M18","v":0},{"$f":"SUM(B48:F48)","v":158.08141687507865},{"$f":"J48-H48","v":158.08141687507865},1000,0,null,"PL2",{"$f":"M48-M54","v":0},null,null,{"$f":"S47","v":0},{"$f":"T49","v":5000},{"$f":"U47","v":0},{"$f":"V49","v":5000},{"$f":"W47","v":0},{"$f":"X49","v":2100},{"$f":"Y47","v":0},{"$f":"Z49","v":150}]
["L3 High Limit",29.671489248739054,-143.77820546854272,3.9530793735067653,15.111494558003866,42.92540483143086,null,0,{"$f":"H49*System!M19","v":0},-52.116737456862175,-52.116737456862175,1000,0,null,"PL3",0,null,2,{"$f":"$R49*System!$Q$17/5","v":0},{"$f":"L34","v":5000},{"$f":"$R49*System!$Q$18/5","v":0},{"$f":"Q34","v":5000},{"$f":"$R49*System!$Q$19/5","v":0},{"$f":"V34","v":2100},{"$f":"$R49*System!$Q$20/7","v":0},{"$f":"AA34","v":150}]
["L4 High Limit",-27.601238023988216,-61.960023650360924,-3.3196478992205076,96.929676376185668,-66.165504259478226,null,0,{"$f":"H50*System!M20","v":0},-62.116737456862211,-62.116737456862211,1000,0,null,"PL4",0,null,null,{"$f":"S49","v":0},{"$f":"T51","v":5000},{"$f":"U49","v":0},{"$f":"V51","v":5000},{"$f":"W49","v":0},{"$f":"X51","v":1500},{"$f":"Y49","v":0},{"$f":"Z51","v":60}]
["L5 High Limit",-56.254072447329705,34.013080097497436,0.56036875256413787,-30.494485604652972,-151.86021137986273,null,0,{"$f":"H51*System!M21","v":0},-204.03532058178382,-204.03532058178382,1000,0,null,"PL5",0,null,3,{"$f":"$R51*System!$Q$17/5","v":0},{"$f":"L35","v":5000},{"$f":"$R51*System!$Q$18/5","v":0},{"$f":"Q35","v":5000},{"$f":"$R51*System!$Q$19/5","v":0},{"$f":"V35","v":1500},{"$f":"$R51*System!$Q$20/7","v":0},{"$f":"AA35","v":60}]
["L6 High Limit",-56.254072447329705,34.013080097497436,0.56036875256413787,-30.494485604652972,248.1397886201373,null,0,{"$f":"H52*System!M22","v":0},195.96467941821618,195.96467941821618,1000,0,null,"PL6",0,null,null,{"$f":"S51","v":0},{"$f":"T53","v":5000},{"$f":"U51","v":0},{"$f":"V53","v":3000},{"$f":"W51","v":0},{"$f":"X53","v":950},{"$f":"Y51","v":0},{"$f":"Z53","v":25}]
["L1 Low Limit",{"$f":"-B47","v":-86.944216521466444},{"$f":"-C47","v":-74.403612713275564},{"$f":"-D47","v":-1.2258066462340422},66.706687260178128,-152.01631392234017,null,0,{"$f":"H53*System!M17","v":0},-247.88326254313807,-247.88326254313807,{"$f":"I4","v":1000},0,null,null,null,null,4,{"$f":"$R53*System!$Q$17/5","v":0},{"$f":"L36","v":5000},{"$f":"$R53*System!$Q$18/5","v":0},{"$f":"Q36","v":3000},{"$f":"$R53*System!$Q$19/5","v":0},{"$f":"V36","v":950},{"$f":"$R53*System!$Q$20/7","v":0},{"$f":"AA36","v":25}]
["L2 Low Limit",{"$f":"-B48","v":-66.801711031203993},40.390532615778056,0.6654378936699118,-36.212201655525249,-96.123474697797377,null,0,{"$f":"H54*System!M18","v":0},-158.08141687507865,-158.08141687507865,1000,0,null,"Bus A",{"$f":"MMULT(TRANSPOSE(B4:F9),P47:P52)","v":0},{"$f":"$F$37-$P54","v":30},null,{"$f":"S53","v":0},{"$f":"T55","v":5000},{"$f":"U53","v":0},{"$f":"V55","v":3000},{"$f":"W53","v":0},{"$f":"X55","v":600},{"$f":"Y53","v":0},{"$f":"Z55","v":12}]
["L3 Low Limit",-29.671489248739054,143.77820546854272,-3.9530793735067653,-15.111494558003866,-42.92540483143086,null,0,{"$f":"H55*System!M19","v":0},52.116737456862175,52.116737456862175,1000,0,null,"Bus B",0,{"$f":"$F$37-$P55","v":30},5,{"$f":"$R55*System!$Q$17/5","v":0},{"$f":"L37","v":5000},{"$f":"$R55*System!$Q$18/5","v":0},{"$f":"Q37","v":3000},{"$f":"$R55*System!$Q$19/5","v":0},{"$f":"V37","v":600},{"$f":"$R55*System!$Q$20/7","v":0},{"$f":"AA37","v":12}]
["L4 Low Limit",27.601238023988216,61.960023650360924,3.3196478992205076,-96.929676376185668,66.165504259478226,null,0,{"$f":"H56*System!M20","v":0},62.116737456862211,62.116737456862211,1000,0,null,"Bus C",0,{"$f":"$F$37-$P56","v":30},null,null,null,null,null,null,null,{"$f":"Y55","v":0},{"$f":"Z57","v":9}]
["L5 Low Limit",56.254072447329705,-34.013080097497436,-0.56036875256413787,30.494485604652972,151.86021137986273,null,0,{"$f":"H57*System!M21","v":0},204.03532058178382,204.03532058178382,1000,0,null,"Bus D",0,{"$f":"$F$37-$P57","v":30},6,null,null,null,null,null,null,{"$f":"$R57*System!$Q$20/7","v":0},{"$f":"AA38","v":9}]
["L6 Low Limit",56.254072447329705,-34.013080097497436,-0.56036875256413787,30.494485604652972,-248.1397886201373,null,0,{"$f":"H58*System!M22","v":0},-195.96467941821618,-195.96467941821618,1000,0,null,"Bus E",0,{"$f":"$F$37-$P58","v":30},null,null,null,null,null,null,null,{"$f":"Y57","v":0},{"$f":"Z59","v":7}]
[null,null,null,null,null,null,null,"Violation Slack Sum:",{"$f":"SUM(I47:I58)","v":0},null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,{"$f":"$R59*System!$Q$20/7","v":0},{"$f":"AA39","v":7}]
[]
["Constraint Analysis"]
[null,null,null,null,"Shift Factors",null,null,null,null,"Limit","Flow","Shadow Price"]
[null,"Line","From Bus","To Bus","A","B","C","D","E"]
["Forward Direction","L1","A","B",{"$f":"B4","v":0.41402007867364976},-0.24801204237758523,-0.12258066462340422,0.22235562420059377,0.38004078480585046,{"$f":"I4","v":1000},{"$f":"K47","v":247.88326254313807},{"$f":"M47","v":0}]
[null,"L2","A","D",0.31810338586287618,0.13463510871926018,6.654378936699118E-2,-0.12070733885175083,0.24030868674449346,1000,{"$f":"K48","v":158.08141687507865},{"$f":"M48","v":0}]
[null,"L3","B","C",{"$f":"B6","v":0.14129280594637644},0.47926068489514245,-0.39530793735067654,-5.0371648526679552E-2,0.10731351207857714,1000,-52.116737456862175,0]
[null,"L4","C","D",{"$f":"B7","v":-0.13143446678089626},0.20653341216786975,0.33196478992205075,-0.32309892125395223,-0.16541376064869556,1000,-62.116737456862211,0]
[null,"L5","D","E",{"$f":"B8","v":-0.26787653546347479},-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,-0.3796505284496568,1000,-204.03532058178382,0]
[null,"L6","E","A",{"$f":"B9","v":-0.26787653546347479},-0.1133769336583248,-5.6036875256413793E-2,0.10164828534884324,0.62034947155034326,1000,195.96467941821618,0]
["Backward Direction","L1","B","A",{"$f":"-B4","v":-0.41402007867364976},0.24801204237758523,0.12258066462340422,-0.22235562420059377,-0.38004078480585046,{"$f":"I4","v":1000},-247.88326254313807,0]
[null,"L2","D","A",-0.31810338586287618,-0.13463510871926018,-6.654378936699118E-2,0.12070733885175083,-0.24030868674449346,{"$f":"I5","v":1000},-158.08141687507865,0]
[null,"L3","C","B",-0.14129280594637644,-0.47926068489514245,0.39530793735067654,5.0371648526679552E-2,-0.10731351207857714,1000,52.116737456862175,0]
[null,"L4","D","C",0.13143446678089626,-0.20653341216786975,-0.33196478992205075,0.32309892125395223,0.16541376064869556,1000,62.116737456862211,0]
[null,"L5","E","D",0.26787653546347479,0.1133769336583248,5.6036875256413793E-2,-0.10164828534884324,0.3796505284496568,1000,204.03532058178382,0]
[null,"L6","A","E",0.26787653546347479,0.1133769336583248,5.6036875256413793E-2,-0.10164828534884324,-0.62034947155034326,1000,-195.96467941821618,0]

{"sheet":"Answer Report","index":3,"n_rows":160,"n_cols":7,"rows_kept":160,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 16.0 Answer Report"]
["Worksheet: [RTC_Simulator_v3.xlsm]Optimization Engine"]
["Report Created: 6/2/2024 8:44:01 AM"]
["Result: Label1"]
["Solver Engine"]
[null,"Engine: 單純 LP"]
[null,"Solution Time: 0.203 Seconds."]
[null,"Iterations: 16 Subproblems: 0"]
["Solver Options"]
[null,"Max Time Unlimited,  Iterations Unlimited, Precision 0.000001"]
[null,"Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative"]
[]
[]
["Objective Cell (Max)"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$C$40","Objective Function: BP",21540,21540]
[]
[]
["Variable Cells"]
[null,"Cell","Name","Original Value","Final Value","Integer"]
[null,"$F$21","A Award (MW)",110,110,"Contin"]
[null,"$F$22","A Award (MW)",100,100,"Contin"]
[null,"$F$23","C Award (MW)",290,290,"Contin"]
[null,"$F$24","D Award (MW)",200,200,"Contin"]
[null,"$F$25","E Award (MW)",400,400,"Contin"]
[null,"$F$26","E Award (MW)",0,0,"Contin"]
[null,"$C$32","BP",0,0,"Contin"]
[null,"$N$21","A Award (MW)",0,0,"Contin"]
[null,"$N$22","A Award (MW)",0,0,"Contin"]
[null,"$N$23","C Award (MW)",0,0,"Contin"]
[null,"$N$24","D Award (MW)",0,0,"Contin"]
[null,"$N$25","E Award (MW)",0,0,"Contin"]
[null,"$N$26","E Award (MW)",0,0,"Contin"]
[null,"$S$21","A Award (MW)",0,0,"Contin"]
[null,"$S$22","A Award (MW)",0,0,"Contin"]
[null,"$S$23","C Award (MW)",0,0,"Contin"]
[null,"$S$24","D Award (MW)",0,0,"Contin"]
[null,"$S$25","E Award (MW)",0,0,"Contin"]
[null,"$S$26","E Award (MW)",0,0,"Contin"]
[null,"$X$21","A Award (MW)",0,0,"Contin"]
[null,"$X$22","A Award (MW)",0,0,"Contin"]
[null,"$X$23","C Award (MW)",0,0,"Contin"]
[null,"$X$24","D Award (MW)",0,0,"Contin"]
[null,"$X$25","E Award (MW)",0,0,"Contin"]
[null,"$X$26","E Award (MW)",0,0,"Contin"]
[null,"$AC$21","A Award (MW)",0,0,"Contin"]
[null,"$AC$22","A Award (MW)",0,0,"Contin"]
[null,"$AC$23","C Award (MW)",0,0,"Contin"]
[null,"$AC$24","D Award (MW)",0,0,"Contin"]
[null,"$AC$25","E Award (MW)",0,0,"Contin"]
[null,"$AC$26","E Award (MW)",0,0,"Contin"]
[null,"$N$33","MCPC Award (MW)",0,0,"Contin"]
[null,"$N$34","REGUP Award (MW)",0,0,"Contin"]
[null,"$N$35","RRS Award (MW)",0,0,"Contin"]
[null,"$N$36","ECRS Award (MW)",0,0,"Contin"]
[null,"$N$37","NSPIN Award (MW)",0,0,"Contin"]
[null,"$S$33","MCPC Award (MW)",0,0,"Contin"]
[null,"$S$34","REGUP Award (MW)",0,0,"Contin"]
[null,"$S$35","RRS Award (MW)",0,0,"Contin"]
[null,"$S$36","ECRS Award (MW)",0,0,"Contin"]
[null,"$S$37","NSPIN Award (MW)",0,0,"Contin"]
[null,"$X$33","MCPC Award (MW)",0,0,"Contin"]
[null,"$X$34","REGUP Award (MW)",0,0,"Contin"]
[null,"$X$35","RRS Award (MW)",0,0,"Contin"]
[null,"$X$36","ECRS Award (MW)",0,0,"Contin"]
[null,"$X$37","NSPIN Award (MW)",0,0,"Contin"]
[null,"$AC$33","MCPC Award (MW)",0,0,"Contin"]
[null,"$AC$34","REGUP Award (MW)",0,0,"Contin"]
[null,"$AC$35","RRS Award (MW)",0,0,"Contin"]
[null,"$AC$36","ECRS Award (MW)",0,0,"Contin"]
[null,"$AC$37","NSPIN Award (MW)",0,0,"Contin"]
[null,"$AC$38","Totals: Award (MW)",0,0,"Contin"]
[null,"$AC$39","Power Balance Penalty Award (MW)",0,0,"Contin"]
[null,"$H$47","L1 High Limit Slack",0,0,"Contin"]
[null,"$H$48","L2 High Limit Slack",0,0,"Contin"]
[null,"$H$49","L3 High Limit Slack",0,0,"Contin"]
[null,"$H$50","L4 High Limit Slack",0,0,"Contin"]
[null,"$H$51","L5 High Limit Slack",0,0,"Contin"]
[null,"$H$52","L6 High Limit Slack",0,0,"Contin"]
[null,"$H$53","L1 Low Limit Slack",0,0,"Contin"]
[null,"$H$54","L2 Low Limit Slack",0,0,"Contin"]
[null,"$H$55","L3 Low Limit Slack",0,0,"Contin"]
[null,"$H$56","L4 Low Limit Slack",0,0,"Contin"]
[null,"$H$57","L5 Low Limit Slack",0,0,"Contin"]
[null,"$H$58","L6 Low Limit Slack",0,0,"Contin"]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$F$28","Sum + PBPC: Award (MW)",1100,"$F$28=$C$16","Binding",0]
[null,"$I$21","A Energy + AS Award",110,"$I$21<=$E$21","Binding",0]
[null,"$I$22","A Energy + AS Award",100,"$I$22<=$E$22","Binding",0]
[null,"$I$23","C Energy + AS Award",290,"$I$23<=$E$23","Not Binding",230]
[null,"$I$24","D Energy + AS Award",200,"$I$24<=$E$24","Binding",0]
[null,"$I$25","E Energy + AS Award",400,"$I$25<=$E$25","Binding",0]
[null,"$I$26","E Energy + AS Award",0,"$I$26<=$E$26","Binding",0]
[null,"$N$40","ASDC QTY - Award Award (MW)",0,"$N$40=0","Binding",0]
[null,"$S$40","ASDC QTY - Award Award (MW)",0,"$S$40=0","Binding",0]
[null,"$X$40","ASDC QTY - Award Award (MW)",0,"$X$40=0","Binding",0]
[null,"$AC$42","ASDC QTY - Award Award (MW)",0,"$AC$42=0","Binding",0]
[null,"$AG$21","A Total Award",0,"$AG$21<=$AF$21","Not Binding",20]
[null,"$AG$22","A Total Award",0,"$AG$22<=$AF$22","Not Binding",20]
[null,"$AG$23","C Total Award",0,"$AG$23<=$AF$23","Binding",0]
[null,"$AG$24","D Total Award",0,"$AG$24<=$AF$24","Not Binding",20]
[null,"$AG$25","E Total Award",0,"$AG$25<=$AF$25","Not Binding",20]
[null,"$AG$26","E Total Award",0,"$AG$26<=$AF$26","Binding",0]
[null,"$K$47","L1 High Limit Flow + Slack",247.88326254313807,"$K$47<=$L$47","Not Binding",752.11673745686198]
[null,"$K$48","L2 High Limit Flow + Slack",158.08141687507865,"$K$48<=$L$48","Not Binding",841.91858312492138]
[null,"$K$49","L3 High Limit Flow + Slack",-52.116737456862175,"$K$49<=$L$49","Not Binding",1052.1167374568622]
[null,"$K$50","L4 High Limit Flow + Slack",-62.116737456862211,"$K$50<=$L$50","Not Binding",1062.1167374568622]
[null,"$K$51","L5 High Limit Flow + Slack",-204.03532058178382,"$K$51<=$L$51","Not Binding",1204.0353205817837]
[null,"$K$52","L6 High Limit Flow + Slack",195.96467941821618,"$K$52<=$L$52","Not Binding",804.03532058178382]
[null,"$K$53","L1 Low Limit Flow + Slack",-247.88326254313807,"$K$53<=$L$53","Not Binding",1247.883262543138]
[null,"$K$54","L2 Low Limit Flow + Slack",-158.08141687507865,"$K$54<=$L$54","Not Binding",1158.0814168750787]
[null,"$K$55","L3 Low Limit Flow + Slack",52.116737456862175,"$K$55<=$L$55","Not Binding",947.88326254313779]
[null,"$K$56","L4 Low Limit Flow + Slack",62.116737456862211,"$K$56<=$L$56","Not Binding",937.88326254313779]
[null,"$K$57","L5 Low Limit Flow + Slack",204.03532058178382,"$K$57<=$L$57","Not Binding",795.96467941821618]
[null,"$K$58","L6 Low Limit Flow + Slack",-195.96467941821618,"$K$58<=$L$58","Not Binding",1195.9646794182163]
[null,"$F$21","A Award (MW)",110,"$F$21>=$D$21","Not Binding",110]
[null,"$F$22","A Award (MW)",100,"$F$22>=$D$22","Not Binding",100]
[null,"$F$23","C Award (MW)",290,"$F$23>=$D$23","Not Binding",290]
[null,"$F$24","D Award (MW)",200,"$F$24>=$D$24","Not Binding",200]
[null,"$F$25","E Award (MW)",400,"$F$25>=$D$25","Not Binding",400]
[null,"$F$26","E Award (MW)",0,"$F$26>=$D$26","Binding",0]
[null,"$C$32","BP",0,"$C$32>=$A$32","Binding",0]
[null,"$C$32","BP",0,"$C$32<=$B$32","Not Binding",99999]
[null,"$N$33","MCPC Award (MW)",0,"$N$33<=$M$33","Binding",0]
[null,"$S$33","MCPC Award (MW)",0,"$S$33<=$R$33","Binding",0]
[null,"$X$33","MCPC Award (MW)",0,"$X$33<=$W$33","Binding",0]
[null,"$N$34","REGUP Award (MW)",0,"$N$34<=$M$34","Binding",0]
[null,"$S$34","REGUP Award (MW)",0,"$S$34<=$R$34","Binding",0]
[null,"$X$34","REGUP Award (MW)",0,"$X$34<=$W$34","Binding",0]
[null,"$N$35","RRS Award (MW)",0,"$N$35<=$M$35","Binding",0]
[null,"$S$35","RRS Award (MW)",0,"$S$35<=$R$35","Binding",0]
[null,"$X$35","RRS Award (MW)",0,"$X$35<=$W$35","Binding",0]
[null,"$N$36","ECRS Award (MW)",0,"$N$36<=$M$36","Binding",0]
[null,"$S$36","ECRS Award (MW)",0,"$S$36<=$R$36","Binding",0]
[null,"$X$36","ECRS Award (MW)",0,"$X$36<=$W$36","Binding",0]
[null,"$N$37","NSPIN Award (MW)",0,"$N$37<=$M$37","Binding",0]
[null,"$S$37","NSPIN Award (MW)",0,"$S$37<=$R$37","Binding",0]
[null,"$X$37","NSPIN Award (MW)",0,"$X$37<=$W$37","Binding",0]
[null,"$AC$33","MCPC Award (MW)",0,"$AC$33<=$AB$33","Binding",0]
[null,"$AC$34","REGUP Award (MW)",0,"$AC$34<=$AB$34","Binding",0]
[null,"$AC$35","RRS Award (MW)",0,"$AC$35<=$AB$35","Binding",0]
[null,"$AC$36","ECRS Award (MW)",0,"$AC$36<=$AB$36","Binding",0]
[null,"$AC$37","NSPIN Award (MW)",0,"$AC$37<=$AB$37","Binding",0]
[null,"$AC$38","Totals: Award (MW)",0,"$AC$38<=$AB$38","Binding",0]
[null,"$AC$39","Power Balance Penalty Award (MW)",0,"$AC$39<=$AB$39","Binding",0]
[null,"$H$47","L1 High Limit Slack",0,"$H$47>=0","Binding",0]
[null,"$H$48","L2 High Limit Slack",0,"$H$48>=0","Binding",0]
[null,"$H$49","L3 High Limit Slack",0,"$H$49>=0","Binding",0]
[null,"$H$50","L4 High Limit Slack",0,"$H$50>=0","Binding",0]
[null,"$H$51","L5 High Limit Slack",0,"$H$51>=0","Binding",0]
[null,"$H$52","L6 High Limit Slack",0,"$H$52>=0","Binding",0]
[null,"$H$53","L1 Low Limit Slack",0,"$H$53>=0","Binding",0]
[null,"$H$54","L2 Low Limit Slack",0,"$H$54>=0","Binding",0]
[null,"$H$55","L3 Low Limit Slack",0,"$H$55>=0","Binding",0]
[null,"$H$56","L4 Low Limit Slack",0,"$H$56>=0","Binding",0]
[null,"$H$57","L5 Low Limit Slack",0,"$H$57>=0","Binding",0]
[null,"$H$58","L6 Low Limit Slack",0,"$H$58>=0","Binding",0]

{"sheet":"Sensitivity Report","index":4,"n_rows":106,"n_cols":8,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 16.0 Sensitivity Report"]
["Worksheet: [RTC_Simulator_v3.xlsm]Optimization Engine"]
["Report Created: 6/2/2024 8:44:02 AM"]
[]
[]
["Variable Cells"]
[null,null,null,"Final","Reduced","Objective","Allowable","Allowable"]
[null,"Cell","Name","Value","Cost","Coefficient","Increase","Decrease"]
[null,"$F$21","A Award (MW)",110,0,14,15,1E+30]
[null,"$F$22","A Award (MW)",100,0,15,14,1E+30]
[null,"$F$23","C Award (MW)",290,0,30,6970.01,1]
[null,"$F$24","D Award (MW)",200,0,29,1,14]
[null,"$F$25","E Award (MW)",400,0,10,19,1E+30]
[null,"$F$26","E Award (MW)",0,0,10,19,1E+30]
[null,"$C$32","BP",0,6970.01,7000.01,1E+30,6970.01]
[null,"$N$21","A Award (MW)",0,15,0,1E+30,15]
[null,"$N$22","A Award (MW)",0,14,0,1E+30,14]
[null,"$N$23","C Award (MW)",0,0,0,1,0]
[null,"$N$24","D Award (MW)",0,0,0,0,1]
[null,"$N$25","E Award (MW)",0,19,0,1E+30,19]
[null,"$N$26","E Award (MW)",0,19,0,1E+30,19]
[null,"$S$21","A Award (MW)",0,35,20,1E+30,35]
[null,"$S$22","A Award (MW)",0,34,20,1E+30,34]
[null,"$S$23","C Award (MW)",0,0,0,19,2999]
[null,"$S$24","D Award (MW)",0,20,20,1E+30,20]
[null,"$S$25","E Award (MW)",0,39,20,1E+30,39]
[null,"$S$26","E Award (MW)",0,19,0,1E+30,19]
[null,"$X$21","A Award (MW)",0,15,0,1E+30,15]
[null,"$X$22","A Award (MW)",0,14,0,1E+30,14]
[null,"$X$23","C Award (MW)",0,0,0,0,599]
[null,"$X$24","D Award (MW)",0,0,0,1E+30,0]
[null,"$X$25","E Award (MW)",0,19,0,1E+30,19]
[null,"$X$26","E Award (MW)",0,19,0,1E+30,19]
[null,"$AC$21","A Award (MW)",0,15,0,1E+30,15]
[null,"$AC$22","A Award (MW)",0,14,0,1E+30,14]
[null,"$AC$23","C Award (MW)",0,0,0,0,6]
[null,"$AC$24","D Award (MW)",0,0,0,1E+30,0]
[null,"$AC$25","E Award (MW)",0,19,0,1E+30,19]
[null,"$AC$26","E Award (MW)",0,19,0,1E+30,19]
[null,"$N$33","MCPC Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$N$34","REGUP Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$N$35","RRS Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$N$36","ECRS Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$N$37","NSPIN Award (MW)",0,-4998.9999999999982,-4999.9999999999982,1E+30,4998.9999999999982]
[null,"$S$33","MCPC Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$S$34","REGUP Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$S$35","RRS Award (MW)",0,-4999,-5000,1E+30,4999]
[null,"$S$36","ECRS Award (MW)",0,-2999,-3000,1E+30,2999]
[null,"$S$37","NSPIN Award (MW)",0,-2999,-3000,1E+30,2999]
[null,"$X$33","MCPC Award (MW)",0,-2749,-2750,1E+30,2749]
[null,"$X$34","REGUP Award (MW)",0,-2099,-2100,1E+30,2099]
[null,"$X$35","RRS Award (MW)",0,-1499,-1500,1E+30,1499]
[null,"$X$36","ECRS Award (MW)",0,-949,-950,1E+30,949]
[null,"$X$37","NSPIN Award (MW)",0,-599,-600,1E+30,599]
[null,"$AC$33","MCPC Award (MW)",0,-419,-420,1E+30,419]
[null,"$AC$34","REGUP Award (MW)",0,-149,-150,1E+30,149]
[null,"$AC$35","RRS Award (MW)",0,-59,-60,1E+30,59]
[null,"$AC$36","ECRS Award (MW)",0,-24,-25,1E+30,24]
[null,"$AC$37","NSPIN Award (MW)",0,-11,-12,1E+30,11]
[null,"$AC$38","Totals: Award (MW)",0,-8,-9,1E+30,8]
[null,"$AC$39","Power Balance Penalty Award (MW)",0,-6,-7,1E+30,6]
[null,"$H$47","L1 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$48","L2 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$49","L3 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$50","L4 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$51","L5 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$52","L6 High Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$53","L1 Low Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$54","L2 Low Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$55","L3 Low Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$56","L4 Low Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$57","L5 Low Limit Slack",0,4500,4500,1E+30,4500]
[null,"$H$58","L6 Low Limit Slack",0,4500,4500,1E+30,4500]
[]
["Constraints"]
[null,null,null,"Final","Shadow","Constraint","Allowable","Allowable"]
[null,"Cell","Name","Value","Price","R.H. Side","Increase","Decrease"]
[null,"$F$28","Sum + PBPC: Award (MW)",1100,30,1100,230,290]
[null,"$I$21","A Energy + AS Award",110,-16,110,290,110]
[null,"$I$22","A Energy + AS Award",100,-15,100,290,100]
[null,"$I$23","C Energy + AS Award",290,0,520,1E+30,230]
[null,"$I$24","D Energy + AS Award",200,-1,200,290,200]
[null,"$I$25","E Energy + AS Award",400,-20,400,290,230]
[null,"$I$26","E Energy + AS Award",0,-20,0,290,0]
[null,"$N$40","ASDC QTY - Award Award (MW)",0,-1,0,0,20]
[null,"$S$40","ASDC QTY - Award Award (MW)",0,-1,0,0,0]
[null,"$X$40","ASDC QTY - Award Award (MW)",0,-1,0,0,0]
[null,"$AC$42","ASDC QTY - Award Award (MW)",0,-1,0,0,0]
[null,"$AG$21","A Total Award",0,0,20,1E+30,20]
[null,"$AG$22","A Total Award",0,0,20,1E+30,20]
[null,"$AG$23","C Total Award",0,-1,0,0,0]
[null,"$AG$24","D Total Award",0,0,20,1E+30,20]
[null,"$AG$25","E Total Award",0,0,20,1E+30,20]
[null,"$AG$26","E Total Award",0,0,0,1E+30,0]
[null,"$K$47","L1 High Limit Flow + Slack",247.88326254313807,0,1000,1E+30,752.11673745686107]
[null,"$K$48","L2 High Limit Flow + Slack",158.08141687507865,0,1000,1E+30,841.91858312492207]
[null,"$K$49","L3 High Limit Flow + Slack",-52.116737456862175,0,1000,1E+30,1052.1167374568624]
[null,"$K$50","L4 High Limit Flow + Slack",-62.116737456862211,0,1000,1E+30,1062.1167374568677]
[null,"$K$51","L5 High Limit Flow + Slack",-204.03532058178382,0,1000,1E+30,1204.0353205817839]
[null,"$K$52","L6 High Limit Flow + Slack",195.96467941821618,0,1000,1E+30,804.03532058178405]
[null,"$K$53","L1 Low Limit Flow + Slack",-247.88326254313807,0,1000,1E+30,1247.8832625431389]
[null,"$K$54","L2 Low Limit Flow + Slack",-158.08141687507865,0,1000,1E+30,1158.0814168750778]
[null,"$K$55","L3 Low Limit Flow + Slack",52.116737456862175,0,1000,1E+30,947.88326254313756]
[null,"$K$56","L4 Low Limit Flow + Slack",62.116737456862211,0,1000,1E+30,937.88326254313233]
[null,"$K$57","L5 Low Limit Flow + Slack",204.03532058178382,0,1000,1E+30,795.96467941821595]
[null,"$K$58","L6 Low Limit Flow + Slack",-195.96467941821618,0,1000,1E+30,1195.9646794182161]