{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Copy Values","Results","Score"],"not_rendered":{"charts":16,"images":0,"macros":1,"external_links":0,"defined_names":47,"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":"Copy Values","index":0,"n_rows":70,"n_cols":24,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Factors","Cost","Emissions","Total","CO2 Cap"]
["Coal",2,1.25,20,20]
["Gas",3,0.75,20]
["Wind/Solar",1,0,20]
[]
["Team ","Period","Coal ","Gas","Wind/Solar","Reserves"," Supply","Team ","Period","Coal ","Gas","Wind/Solar","Reserves"," Supply","Team ","Period","Coal ","Gas","Wind/Solar","Reserves","Supply",null,"Demand"]
[1,1,0,0,0,0,{"$f":"SUM(C7:E7)","v":0},2,1,0,0,0,0,{"$f":"SUM(J7:L7)","v":0},3,1,0,0,0,0,{"$f":"SUM(Q7:S7)","v":0},null,2]
[null,2,0,0,0,0,{"$f":"SUM(C8:E8)","v":0},null,2,0,0,0,0,0,null,2,0,0,0,0,{"$f":"SUM(Q8:S8)","v":0},null,3]
[null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,4]
[null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,6]
[null,5,0,0,0,0,0,null,5,0,0,0,0,0,null,5,0,0,0,0,0,null,9]
[null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,2]
[null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,1]
[4,1,0,0,0,0,{"$f":"SUM(C14:E14)","v":0},5,1,0,0,0,0,0,6,1,0,0,0,0,{"$f":"SUM(Q14:S14)","v":0}]
[null,2,0,0,0,0,{"$f":"SUM(C15:E15)","v":0},null,2,0,0,0,0,{"$f":"SUM(J15:L15)","v":0},null,2,0,0,0,0,{"$f":"SUM(Q15:S15)","v":0}]
[null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,3,0,0,0,0,0]
[null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,4,0,0,0,0,0]
[null,5,0,0,0,0,0,null,5,0,0,0,0,0,null,5,0,0,0,0,0]
[null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,6,0,0,0,0,0]
[null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,7,0,0,0,0,0]
[7,1,0,0,0,0,{"$f":"SUM(C21:E21)","v":0},8,1,0,0,0,0,{"$f":"SUM(J21:L21)","v":0},9,1,0,0,0,0,{"$f":"SUM(Q21:S21)","v":0}]
[null,2,0,0,0,0,{"$f":"SUM(C22:E22)","v":0},null,2,0,0,0,0,{"$f":"SUM(J22:L22)","v":0},null,2,0,0,0,0,{"$f":"SUM(Q22:S22)","v":0}]
[null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,3,0,0,0,0,0]
[null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,4,0,0,0,0,0]
[null,5,0,0,0,0,0,null,5,0,0,0,0,0,null,5,0,0,0,0,0]
[null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,6,0,0,0,0,0]
[null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,7,0,0,0,0,0]
[10,1,0,0,0,0,{"$f":"SUM(C28:E28)","v":0},11,1,0,0,0,0,{"$f":"SUM(J28:L28)","v":0},12,1,0,0,0,0,{"$f":"SUM(Q28:S28)","v":0}]
[null,2,0,0,0,0,{"$f":"SUM(C29:E29)","v":0},null,2,0,0,0,0,{"$f":"SUM(J29:L29)","v":0},null,2,0,0,0,0,{"$f":"SUM(Q29:S29)","v":0}]
[null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,3,0,0,0,0,0]
[null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,4,0,0,0,0,0]
[null,5,0,0,0,0,0,null,5,0,0,0,0,0,null,5,0,0,0,0,0]
[null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,6,0,0,0,0,0]
[null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,7,0,0,0,0,0]
[13,1,0,0,0,0,{"$f":"SUM(C35:E35)","v":0},14,1,0,0,0,0,{"$f":"SUM(J35:L35)","v":0},15,1,0,0,0,0,{"$f":"SUM(Q35:S35)","v":0}]
[null,2,0,0,0,0,{"$f":"SUM(C36:E36)","v":0},null,2,0,0,0,0,{"$f":"SUM(J36:L36)","v":0},null,2,0,0,0,0,{"$f":"SUM(Q36:S36)","v":0}]
[null,3,0,0,0,0,0,null,3,0,0,0,0,0,null,3,0,0,0,0,0]
[null,4,0,0,0,0,0,null,4,0,0,0,0,0,null,4,0,0,0,0,0]
[null,5,0,0,0,0,0,null,5,0,0,0,0,{"$f":"SUM(J39:L39)","v":0},null,5,0,0,0,0,0]
[null,6,0,0,0,0,0,null,6,0,0,0,0,0,null,6,0,0,0,0,0]
[null,7,0,0,0,0,0,null,7,0,0,0,0,0,null,7,0,0,0,0,0]
[16,1,0,0,0,0,{"$f":"SUM(C42:E42)","v":0}]
[null,2,0,0,0,0,{"$f":"SUM(C43:E43)","v":0}]
[null,3,0,0,0,0,0]
[null,4,0,0,0,0,{"$f":"SUM(C45:E45)","v":0}]
[null,5,0,0,0,0,0]
[null,6,0,0,0,0,0]
[null,7,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
["T1 Up Res","T1 Dn Res","Period Y/N","T2 Up Res","T2 Dn Res",null,"T3 Up Res","T3 Dn Res",null,"T4 Up Res","T4 Dn Res",null,"T5 Up Res","T5 Dn Res",null,"T6 Up Res","T6 Dn Res",null,"T7 Up Res","T7 Dn Res",null,"T8 Up Res","T8 Dn Res"]
[{"$f":"G7+F7","v":0},{"$f":"G7-F7","v":0},{"$f":"IF(AND(W7<=A56,B56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"N7+M7","v":0},{"$f":"N7-M7","v":0},{"$f":"IF(AND(W7<=D56,E56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"U7+T7","v":0},{"$f":"U7-T7","v":0},{"$f":"IF(AND(W7<=G56,H56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"G14+F14","v":0},{"$f":"G14-F14","v":0},{"$f":"IF(AND(W7<=J56,K56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"N14+M14","v":0},{"$f":"N14-M14","v":0},{"$f":"IF(AND(W7<=M56,N56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"U14+T14","v":0},{"$f":"U14-T14","v":0},{"$f":"IF(AND(W7<=P56,Q56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"G21+F21","v":0},{"$f":"G21-F21","v":0},{"$f":"IF(AND(W7<=S56,T56<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"N21+M21","v":0},{"$f":"N21-M21","v":0},{"$f":"IF(AND(W7<=V56,W56<=W7),\"Yes\",\"No\")","v":"No"}]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
["T9 Up Res","T1 Dn Res","Period Y/N","T10 Up Res","T2 Dn Res",null,"T11 Up Res","T3 Dn Res",null,"T12 Up Res","T4 Dn Res",null,"T13 Up Res","T5 Dn Res",null,"T14 Up Res","T6 Dn Res",null,"T15 Up Res","T7 Dn Res",null,"T16 Up Res","T8 Dn Res"]
[{"$f":"U21+T21","v":0},{"$f":"U21-T21","v":0},{"$f":"IF(AND(W7<=A64,B64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"G28+F28","v":0},{"$f":"G28-F28","v":0},{"$f":"IF(AND(W7<=D64,E64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"N28+M28","v":0},{"$f":"N28-M28","v":0},{"$f":"IF(AND(W7<=G64,H64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"U28+T28","v":0},{"$f":"U28-T28","v":0},{"$f":"IF(AND(W7<=J64,K64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"G35+F35","v":0},{"$f":"G35-F35","v":0},{"$f":"IF(AND(W7<=M64,N64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"N35+M35","v":0},{"$f":"N35-M35","v":0},{"$f":"IF(AND(W7<=P64,Q64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"U35-T35","v":0},{"$f":"G42-F42","v":0},{"$f":"IF(AND(W7<=S64,T64<=W7),\"Yes\",\"No\")","v":"No"},{"$f":"G42+F42","v":0},{"$f":"G42-F42","v":0},{"$f":"IF(AND(W7<=V64,W64<=W7),\"Yes\",\"No\")","v":"No"}]
[{"$f":"U22+T22","v":0},{"$f":"U22-T22","v":0},{"$f":"IF(AND(W8<=A65,B65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"G29+F29","v":0},{"$f":"G29-F29","v":0},{"$f":"IF(AND(W8<=D65,E65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"N29+M29","v":0},{"$f":"N29-M29","v":0},{"$f":"IF(AND(W8<=G65,H65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"U29+T29","v":0},{"$f":"U29-T29","v":0},{"$f":"IF(AND(W8<=J65,K65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"G36+F36","v":0},{"$f":"G36-F36","v":0},{"$f":"IF(AND(W8<=M65,N65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"N36+M36","v":0},{"$f":"N36-M36","v":0},{"$f":"IF(AND(W8<=P65,Q65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"U36-T36","v":0},{"$f":"G43-F43","v":0},{"$f":"IF(AND(W8<=S65,T65<=W8),\"Yes\",\"No\")","v":"No"},{"$f":"G43+F43","v":0},{"$f":"G43-F43","v":0},{"$f":"IF(AND(W8<=V65,W65<=W8),\"Yes\",\"No\")","v":"No"}]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]
[0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No",0,0,"No"]

{"sheet":"Results","index":1,"n_rows":49,"n_cols":24,"rows_kept":49,"cut":false,"hidden":false,"merged":[[19,14,19,15],[5,0,5,1],[5,7,5,8],[5,14,5,15],[17,0,17,1],[17,7,17,8],[17,14,17,15],[7,14,7,15],[6,0,6,1],[6,7,6,8],[6,14,6,15],[8,7,8,8],[8,0,8,1],[7,0,7,1],[7,7,7,8],[18,14,18,15],[18,7,18,8],[18,0,18,1],[19,0,19,1],[32,0,32,1],[32,7,32,8],[31,7,31,8],[29,7,29,8],[29,0,29,1],[30,0,30,1],[30,7,30,8],[31,0,31,1],[20,7,20,8],[20,0,20,1],[19,7,19,8],[20,14,20,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[41,14,41,15],[42,14,42,15],[43,14,43,15],[44,14,44,15],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[42,21,42,22],[43,21,43,22],[44,21,44,22],[5,21,5,22],[6,21,6,22],[7,21,7,22],[8,21,8,22],[17,21,17,22],[18,21,18,22],[19,21,19,22],[20,21,20,22],[29,21,29,22],[30,21,30,22],[31,21,31,22],[32,21,32,22],[41,21,41,22]]}
[]
[null,"Reset Button",null,null,null,"Scenario Button",null,null,"Demand Distribution"]
[]
[]
["Team 1",null,"S&D Graph",null,null,null,null,"Team 2",null,"S&D Graph",null,null,null,null,"Team 3",null,"S&D Graph",null,null,null,null,"Team 13",null,"S&D Graph"]
["Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied"]
[{"$f":"COUNTIF('Copy Values'!C56:C62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!F56:F62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!I56:I62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AK32:AK38, \"Yes\")","v":0}]
["Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost"]
[{"$f":"SUM(B10:B13)","v":0},null,null,null,null,null,null,{"$f":"SUM(I10:I13)","v":0},null,null,null,null,null,null,{"$f":"SUM(P10:P13)","v":0},null,null,null,null,null,null,{"$f":"SUM(W10:W13)","v":{"$error":"#REF!"}}]
["Dispatch",{"$f":"SUM(t1_coal)*coal_cost+SUM(t1_gas)*gas_cost+SUM(t1_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t2_coal)*coal_cost+SUM(t2_gas)*gas_cost+SUM(t2_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t3_coal)*coal_cost+SUM(t3_gas)*gas_cost+SUM(t3_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0}]
["Reserves",{"$f":"1.5*SUM(t1_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t2_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t3_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0}]
["Emissions",{"$f":"SUM(t1_coal)*coal_em+SUM(t1_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t2_coal)*coal_em+SUM(t2_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t3_coal)*coal_em+SUM(t3_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0}]
["CO2 Penalty",{"$f":"IF(B12>'Copy Values'!E2, B12, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(I12>'Copy Values'!E2, I12, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(P12>'Copy Values'!E2, P12, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(W12>'Copy Values'!#REF!, W12, 0)","v":{"$error":"#REF!"}}]
[]
[]
[]
["Team 4",null,"S&D Graph",null,null,null,null,"Team 5",{"$f":"COUNTIF('Copy Values'!U56:U62, \"Yes\")","v":0},"S&D Graph",null,null,null,null,"Team 6",null,"S&D Graph",null,null,null,null,"Team 14",null,"S&D Graph"]
["Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied"]
[{"$f":"COUNTIF('Copy Values'!L56:L62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!O56:O62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!R56:R62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AK44:AK50, \"Yes\")","v":0}]
["Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost"]
[{"$f":"SUM(B22:B25)","v":0},null,null,null,null,null,null,{"$f":"SUM(I22:I25)","v":0},null,null,null,null,null,null,{"$f":"SUM(P22:P25)","v":0},null,null,null,null,null,null,{"$f":"SUM(W22:W25)","v":{"$error":"#REF!"}}]
["Dispatch",{"$f":"SUM(t4_coal)*coal_cost+SUM(t4_gas)*gas_cost+SUM(t4_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t5_coal)*coal_cost+SUM(t5_gas)*gas_cost+SUM(t5_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t6_coal)*coal_cost+SUM(t6_gas)*gas_cost+SUM(t6_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0}]
["Reserves",{"$f":"1.5*SUM(t4_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t5_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t6_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0}]
["Emissions",{"$f":"SUM(t4_coal)*coal_em+SUM(t4_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t5_coal)*coal_em+SUM(t5_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t6_coal)*coal_em+SUM(t6_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0}]
["Over/Under",{"$f":"IF(B24>'Copy Values'!E2, B24, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(I24>'Copy Values'!E2, I24, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(P24>'Copy Values'!E2, P24, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(W24>'Copy Values'!#REF!, W24, 0)","v":{"$error":"#REF!"}}]
[]
[]
[]
["Team 7",null,"S&D Graph",null,null,null,null,"Team 8",null,"S&D Graph",null,null,null,null,"Team 9",null,"S&D Graph",null,null,null,null,"Team 15",null,"S&D Graph"]
["Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied"]
[{"$f":"COUNTIF('Copy Values'!U56:U62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!X56:X62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AD56:AD62, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AK56:AK62, \"Yes\")","v":0}]
["Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost"]
[{"$f":"SUM(B34:B37)","v":0},null,null,null,null,null,null,{"$f":"SUM(I34:I37)","v":0},null,null,null,null,null,null,{"$f":"SUM(P34:P37)","v":0},null,null,null,null,null,null,{"$f":"SUM(W34:W37)","v":0}]
["Dispatch",{"$f":"SUM(t7_coal)*coal_cost+SUM(t7_gas)*gas_cost+SUM(t7_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0}]
["Reserves",{"$f":"1.5*SUM(t7_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0}]
["Emissions",{"$f":"SUM(t7_coal)*coal_em+SUM(t7_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0}]
["Over/Under",{"$f":"IF(B36>'Copy Values'!E2, B36, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(I36>'Copy Values'!E2, I36, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(P36>'Copy Values'!L2, P36, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(W36>'Copy Values'!S2, W36, 0)","v":0}]
[]
[]
[]
["Team 10",null,"S&D Graph",null,null,null,null,"Team 11",null,"S&D Graph",null,null,null,null,"Team 12",null,"S&D Graph",null,null,null,null,"Team 16",null,"S&D Graph"]
["Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied",null,null,null,null,null,null,"Periods Supplied"]
[{"$f":"COUNTIF('Copy Values'!P68:P74, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!W68:W74, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AD68:AD74, \"Yes\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF('Copy Values'!AK68:AK74, \"Yes\")","v":0}]
["Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost",null,null,null,null,null,null,"Final Cost"]
[{"$f":"SUM(B46:B49)","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"SUM(I46:I49)","v":0},null,null,null,null,null,null,{"$f":"SUM(P46:P49)","v":0},null,null,null,null,null,null,{"$f":"SUM(W46:W49)","v":0}]
["Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0},null,null,null,null,null,"Dispatch",{"$f":"SUM(t8_coal)*coal_cost+SUM(t8_gas)*gas_cost+SUM(t8_wind)*1","v":0}]
["Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0},null,null,null,null,null,"Reserves",{"$f":"1.5*SUM(t8_reserves)","v":0}]
["Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0},null,null,null,null,null,"Emissions",{"$f":"SUM(t8_coal)*coal_em+SUM(t8_gas)*gas_em","v":0}]
["Over/Under",{"$f":"IF(B48>'Copy Values'!#REF!, B48, 0)","v":{"$error":"#REF!"}},null,null,null,null,null,"Over/Under",{"$f":"IF(I48>'Copy Values'!E14, I48, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(P48>'Copy Values'!L14, P48, 0)","v":0},null,null,null,null,null,"Over/Under",{"$f":"IF(W48>'Copy Values'!S14, W48, 0)","v":0}]

{"sheet":"Score","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Scores","Round 1","Round 2","Round 3","Round 4","Round 5","Total"]
["Team 1",null,null,null,null,null,{"$f":"SUM(B2:F2)","v":0}]
["Team 2",null,null,null,null,null,{"$f":"SUM(B3:F3)","v":0}]
["Team 3",null,null,null,null,null,0]
["Team 4",null,null,null,null,null,0]
["Team 5",null,null,null,null,null,0]
["Team 6",null,null,null,null,null,0]
["Team 7",null,null,null,null,null,0]
["Team 8",null,null,null,null,null,0]
["Team 9",null,null,null,null,null,0]
["Team 10",null,null,null,null,null,0]
["Team 11",null,null,null,null,null,0]
["Team 12",null,null,null,null,null,0]
["Team 13",null,null,null,null,null,0]
["Team 14",null,null,null,null,null,0]
["Team 15",null,null,null,null,null,0]
["Team 16",null,null,null,null,null,0]
[]
["Scoring: "]
["1st place","800 pts"]
["2nd place","500 pts"]
["3rd place","300 pts"]
["4th place","150 pts"]
["5th place","50 pts"]