{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["README","Calculate LDES SOC","Duration Lookback Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":39,"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":"README","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
["User must have Solver enabled (File>Options>Add-Ins>Manage)"]
["User must have macros enabled to use the \"SOLVE\" button. Otherwise, user can use Data>Solver."]
[]
["Calculate LDES SOC tab"]
["User can configure values in blue cells"]
["Do not touch values in gray cells"]
["When user hits \"SOLVE\" on row 32-33, optimization chooses values in orange cells"]
["J28:J30 will list the SOC value each LDES Resource carries into the worst-day"]
[]
["Duration Lookback Table tab"]
["Table designating the number of days prior to the worst-day that LDES Resources of varying durations are eligible to store energy from."]
["Supports calculations in Calculate LDES SOC tab B12:I14."]

{"sheet":"Calculate LDES SOC","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,1,9,8],[17,1,17,8],[25,1,25,8]]}
["Resource Limitations"]
[]
["Resource Specifications"]
["Resource (r)","Pmin","SOCmax","RTE","Duration","ISOC"]
["R1",-10,720,0.6,72,{"$f":"0.5*C5","v":360}]
["R2",-15,360,0.5,24,{"$f":"0.5*C6","v":180}]
["R3",-20,240,0.9,12,120]
[]
["Daily Maximum Stored Energy Limit (MSEd,r)"]
[null,"Day Prior (d=8..d=1)"]
["Resource (r)",8,7,6,5,4,3,2,1]
["R1",{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=B$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=C$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=D$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=E$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=F$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=G$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=H$11,$C5,0),-1*$B5*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E5,'Duration Lookback Table'!$A:$C,3,TRUE)>=I$11,$C5,0),-1*$B5*24)","v":240}]
["R2",{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=B$11,$C6,0),-1*$B6*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=C$11,$C6,0),-1*$B6*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=D$11,$C6,0),-1*$B6*24)","v":360},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=E$11,$C6,0),-1*$B6*24)","v":360},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=F$11,$C6,0),-1*$B6*24)","v":360},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=G$11,$C6,0),-1*$B6*24)","v":360},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=H$11,$C6,0),-1*$B6*24)","v":360},{"$f":"MIN(IF(VLOOKUP($E6,'Duration Lookback Table'!$A:$C,3,TRUE)>=I$11,$C6,0),-1*$B6*24)","v":360}]
["R3",{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=B$11,$C7,0),-1*$B7*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=C$11,$C7,0),-1*$B7*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=D$11,$C7,0),-1*$B7*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=E$11,$C7,0),-1*$B7*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=F$11,$C7,0),-1*$B7*24)","v":0},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=G$11,$C7,0),-1*$B7*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=H$11,$C7,0),-1*$B7*24)","v":240},{"$f":"MIN(IF(VLOOKUP($E7,'Duration Lookback Table'!$A:$C,3,TRUE)>=I$11,$C7,0),-1*$B7*24)","v":240}]
[]
["Portfolio Limitations"]
[]
[null,"Day Prior (d=8..d=1)"]
[null,8,7,6,5,4,3,2,1]
["Excess Energy Limit (EEd)",200,150,125,100,100,75,50,40,"<<user entered values (or pre-calculated based on difference between Load Forecast and non-storage RA supply)"]
["LDES Consumed Energy",{"$f":"SUMPRODUCT(B28:B30/$D$5:$D$7)","v":200},{"$f":"SUMPRODUCT(C28:C30/$D$5:$D$7)","v":150},{"$f":"SUMPRODUCT(D28:D30/$D$5:$D$7)","v":125},{"$f":"SUMPRODUCT(E28:E30/$D$5:$D$7)","v":100},{"$f":"SUMPRODUCT(F28:F30/$D$5:$D$7)","v":100},{"$f":"SUMPRODUCT(G28:G30/$D$5:$D$7)","v":74.999999999999972},{"$f":"SUMPRODUCT(H28:H30/$D$5:$D$7)","v":49.999999999999972},{"$f":"SUMPRODUCT(I28:I30/$D$5:$D$7)","v":40}]
[]
["Daily Stored Energy Optimization"]
[]
["Resource Daily Stored Energy (SEd,r)"]
[null,"Day Prior (d=8..d=1)"]
["Resource (r)",8,7,6,5,4,3,2,1,"LDES SOD SOC"]
["R1",120,90,75,60,15,0,0,0,{"$f":"F5+SUM(B28:I28)","v":720},null,"R1 carries this SOC into the worst-day"]
["R2",0,0,0,0,37.5,0,0,15.833333333333304,{"$f":"F6+SUM(B29:I29)","v":233.33333333333331},null,"R2 carries this SOC into the worst-day"]
["R3",0,0,0,0,0,67.499999999999972,44.999999999999979,7.5000000000000497,{"$f":"F7+SUM(B30:I30)","v":240},null,"R3 carries this SOC into the worst-day"]
[null,null,null,null,null,null,null,null,"Objective (max):",{"$f":"SUM(J28:J30)","v":1193.3333333333333}]

{"sheet":"Duration Lookback Table","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Storage Duration (from)","Storage Duration (to)","# of Lookback Days"]
[8,12,2]
[12,16,3]
[16,20,4]
[20,24,5]
[24,48,6]
[48,72,7]
[72,200,8]