{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Model"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":42,"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":"Model","index":0,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,3,42,4],[17,20,22,20],[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,3,40,4],[41,3,41,4],[19,5,19,16],[23,1,34,1],[17,18,22,18],[17,19,22,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"License","GPL 2.0"]
[]
[null,"Valuation Date","2020-10-20"]
[]
[null,"Contract","Apr'21","May'21","Jun'21","Jul'21","Aug'21","Sep'21","Oct'21","Nov'21","Dec'21","Jan'22","Feb'22","Mar'22","Apr'22","May'22","Jun'22","Jul'22","Aug'22","Sep'22","Oct'22","Nov'22","Dec'22","Jan'23","Feb'23","Mar'23","Apr'23"]
[null,"Henry Hub Price",2.9209999999999998,2.8919999999999999,2.9220000000000002,2.96,2.9740000000000002,2.9660000000000002,3.0070000000000001,3.07,3.2029999999999998,3.294,3.2160000000000002,3.03,2.5680000000000001,2.48,2.5249999999999999,2.5619999999999998,2.57,2.5590000000000002,2.5920000000000001,2.681,2.87,2.9870000000000001,2.9390000000000001,2.7789999999999999,2.3879999999999999]
[null,"Number of days",30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30]
[]
[]
[]
[null,"Max Storage Capacity [Dth]",100000]
[null,"Max Daily Injection [Dth]",2000]
[null,"Max Daily Withdrawal [Dth]",4000]
[null,null,null,null,null,null,null,null,null,null,"http://processiqcompany.com"]
[]
[null,"Storage Revenue",{"$f":"SUM(F37:Q37)+SUM(S24:S35)","v":39520}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Withdrawal credit","Total draw","Daily draw"]
[]
[null,null,null,null,null,"Injections"]
[null,null,"Injection",null,"Days",{"$f":"HLOOKUP(F23,$C$5:$AA$7,3,FALSE)","v":30},{"$f":"HLOOKUP(G23,$C$5:$AA$7,3,FALSE)","v":31},30,31,31,30,31,30,31,31,28,31]
[null,null,null,null,"Price",{"$f":"HLOOKUP(F23,$C$5:$AA$6,2,FALSE)","v":2.9209999999999998},{"$f":"HLOOKUP(G23,$C$5:$AA$6,2,FALSE)","v":2.8919999999999999},{"$f":"HLOOKUP(H23,$C$5:$AA$6,2,FALSE)","v":2.9220000000000002},{"$f":"HLOOKUP(I23,$C$5:$AA$6,2,FALSE)","v":2.96},{"$f":"HLOOKUP(J23,$C$5:$AA$6,2,FALSE)","v":2.9740000000000002},{"$f":"HLOOKUP(K23,$C$5:$AA$6,2,FALSE)","v":2.9660000000000002},{"$f":"HLOOKUP(L23,$C$5:$AA$6,2,FALSE)","v":3.0070000000000001},{"$f":"HLOOKUP(M23,$C$5:$AA$6,2,FALSE)","v":3.07},{"$f":"HLOOKUP(N23,$C$5:$AA$6,2,FALSE)","v":3.2029999999999998},{"$f":"HLOOKUP(O23,$C$5:$AA$6,2,FALSE)","v":3.294},{"$f":"HLOOKUP(P23,$C$5:$AA$6,2,FALSE)","v":3.2160000000000002},{"$f":"HLOOKUP(Q23,$C$5:$AA$6,2,FALSE)","v":3.03}]
[null,null,"Days","Price","Contract",{"$f":"C5","v":"Apr'21"},{"$f":"D5","v":"May'21"},{"$f":"E5","v":"Jun'21"},{"$f":"F5","v":"Jul'21"},{"$f":"G5","v":"Aug'21"},{"$f":"H5","v":"Sep'21"},{"$f":"I5","v":"Oct'21"},{"$f":"J5","v":"Nov'21"},{"$f":"K5","v":"Dec'21"},{"$f":"L5","v":"Jan'22"},{"$f":"M5","v":"Feb'22"},{"$f":"N5","v":"Mar'22"}]
[null,"Withdrawals",{"$f":"TRANSPOSE(F21:Q21)","v":30},{"$f":"TRANSPOSE(F22:Q22)","v":2.9209999999999998},{"$f":"TRANSPOSE(F23:Q23)","v":"Apr'21"},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(F24:Q24)*D24*10000","v":0},{"$f":"SUM(F24:Q24)*10000","v":0},{"$f":"T24/C24","v":0}]
[null,null,31,2.8919999999999999,"May'21",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(F25:Q25)*D25*10000","v":0},{"$f":"SUM(F25:Q25)*10000","v":0},{"$f":"T25/C25","v":0}]
[null,null,30,2.9220000000000002,"Jun'21",0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0]
[null,null,31,2.96,"Jul'21",0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0]
[null,null,31,2.9740000000000002,"Aug'21",0,0,0,0,0,0,0,0,0,0,0,6,null,178440,60000,1935.483870967742]
[null,null,30,2.9660000000000002,"Sep'21",0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0]
[null,null,31,3.0070000000000001,"Oct'21",0,0,0,0,0,0,0,0,0,1,1,0,null,60140,20000,645.16129032258061]
[null,null,30,3.07,"Nov'21",0,0,0,0,0,5,0,0,0,0,0,0,null,153500,50000,1666.6666666666667]
[null,null,31,3.2029999999999998,"Dec'21",0,0,0,0,0,0,2,4,0,0,0,0,null,192180,60000,1935.483870967742]
[null,null,31,3.294,"Jan'22",3,0,0,0,0,1,0,1,6,0,1,0,null,395280,120000,3870.9677419354839]
[null,null,28,3.2160000000000002,"Feb'22",1,4,0,0,0,0,0,0,0,0,0,0,null,160800.00000000003,50000,1785.7142857142858]
[null,null,31,3.03,"Mar'22",0,2,0,0,0,0,0,0,0,1,3,0,null,181800,60000,1935.483870967742]
[]
[null,null,null,"Injection Charge",null,{"$f":"-SUM(F24:F35)*F22*10000","v":-116840},{"$f":"-SUM(G24:G35)*G22*10000","v":-173520},{"$f":"-SUM(H24:H35)*H22*10000","v":0},{"$f":"-SUM(I24:I35)*I22*10000","v":0},{"$f":"-SUM(J24:J35)*J22*10000","v":0},{"$f":"-SUM(K24:K35)*K22*10000","v":-177960},{"$f":"-SUM(L24:L35)*L22*10000","v":-60140},{"$f":"-SUM(M24:M35)*M22*10000","v":-153500},{"$f":"-SUM(N24:N35)*N22*10000","v":-192180},{"$f":"-SUM(O24:O35)*O22*10000","v":-65880},{"$f":"-SUM(P24:P35)*P22*10000","v":-160800.00000000003},{"$f":"-SUM(Q24:Q35)*Q22*10000","v":-181800}]
[null,null,null,"Total injection",null,{"$f":"SUM(F24:F35)*10000","v":40000},{"$f":"SUM(G24:G35)*10000","v":60000},0,0,0,60000,20000,50000,60000,20000,50000,60000]
[null,null,null,"Daily injection",null,{"$f":"F38/F21","v":1333.3333333333333},{"$f":"G38/G21","v":1935.483870967742},0,0,0,2000,645.16129032258061,1666.6666666666667,1935.483870967742,645.16129032258061,1785.7142857142858,1935.483870967742]
[]
[null,null,null,"Contract",null,{"$f":"F23","v":"Apr'21"},{"$f":"G23","v":"May'21"},"Jun'21","Jul'21","Aug'21","Sep'21","Oct'21","Nov'21","Dec'21","Jan'22","Feb'22","Mar'22"]
[null,null,null,"Total Storage",null,{"$f":"F38-T24","v":40000},{"$f":"F42+G38-T25","v":100000},{"$f":"G42+H38-T26","v":100000},{"$f":"H42+I38-T27","v":100000},{"$f":"I42+J38-T28","v":40000},{"$f":"J42+K38-T29","v":100000},{"$f":"K42+L38-T30","v":100000},{"$f":"L42+M38-T31","v":100000},{"$f":"M42+N38-T32","v":100000},{"$f":"N42+O38-T33","v":0},{"$f":"O42+P38-T34","v":0},{"$f":"P42+Q38-T35","v":0}]
[null,null,null,"Price",null,{"$f":"F22","v":2.9209999999999998},{"$f":"G22","v":2.8919999999999999},2.9220000000000002,2.96,2.9740000000000002,2.9660000000000002,3.0070000000000001,3.07,3.2029999999999998,3.294,3.2160000000000002,3.03]