{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["COST CALC 2012 13","Invitation Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"COST CALC 2012 13","index":0,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[27,0,27,3]]}
[null,null,null,null,null,null,null,null,null,null,"Site"]
[null,"Avonmouth","Dynevor",null,null,"Partington",null,null,null,null,{"$f":"B31","v":"Avonmouth"}]
["Unit Space Offered kwh",607100000,169100000,null,null,864100000,null,null,null,"Unit Space Offered kwh",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B3,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C3,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F3,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E3,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F3,\"\")))))","v":607100000}]
["Unit Reserve Price",0.40939999999999999,0.40939999999999999,null,null,0.34939999999999999,null,null,null,"Unit Reserve Price",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B4,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C4,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F4,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E4,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F4,\"\")))))","v":0.40939999999999999}]
["Deliverability Offered kwh/day",{"$f":"B3/(1/0.2573)","v":156206830},{"$f":"C3/(1/0.291)","v":49208100},null,null,{"$f":"F3/(1/0.2541)","v":219567810},null,null,null,"Deliverability Offered kwh/day",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B5,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C5,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F5,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E5,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F5,\"\")))))","v":156206830}]
["Ratio (Space vs. Deliverability)",{"$f":"B3/B5","v":3.8865137971239796},{"$f":"C3/C5","v":3.4364261168384878},null,null,{"$f":"F3/F5","v":3.9354584809130264},null,null,null,"Ratio (Space vs. Deliverability)",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B6,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C6,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F6,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E6,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F6,\"\")))))","v":3.8865137971239796}]
["Injection Offered kwh/day",{"$f":"B3/(1/0.0027)","v":1639170.0000000002},{"$f":"C3/(1/0.0086)","v":1454260},null,null,{"$f":"F3/(1/0.0022)","v":1901020.0000000002},null,null,null,"Injection Offered kwh/day",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B7,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C7,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F7,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E7,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F7,\"\")))))","v":1639170.0000000002}]
["Ratio (Space vs. Injection)",{"$f":"B3/B7","v":370.37037037037032},{"$f":"C3/C7","v":116.27906976744185},null,null,{"$f":"F3/F7","v":454.5454545454545},null,null,null,"Ratio (Space vs. Injection)",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B8,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C8,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F8,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E8,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F8,\"\")))))","v":370.37037037037032}]
[]
["Implied reserve price unit/deliverability (inc Rebate)",{"$f":"(B22*100)/B5","v":-0.94959713674147761},{"$f":"(C22*100)/C5","v":1.4068728522336771},null,null,{"$f":"(F22*100)/F5","v":1.3750491932310114},null,null,null,"Implied reserve price unit/deliverability",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B10,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C10,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F10,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E10,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F10,\"\")))))","v":-0.94959713674147761}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B11,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C11,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F11,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E11,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F11,\"\")))))","v":0}]
["LNG Injection Charge p/kwh",0.19,0.19800000000000001,null,null,0.25800000000000001,null,null,null,"LNG Injection Charge p/kwh",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B12,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C12,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F12,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E12,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F12,\"\")))))","v":0.19}]
["LNG Withdrawal Charge p/kwh",1.9E-2,1.7000000000000001E-2,null,null,1.7000000000000001E-2,null,null,null,"LNG Withdrawal Charge p/kwh",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B13,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C13,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F13,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E13,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F13,\"\")))))","v":1.9E-2}]
[]
["Unit Cost/kwh excluding constrain rebate",{"$f":"B13+B12+B4","v":0.61839999999999995},{"$f":"C13+C12+C4","v":0.62440000000000007},null,null,{"$f":"F13+F12+F4","v":0.62440000000000007},null,null,null,"Unit Cost/kwh excluding constrain rebate",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B15,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C15,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F15,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E15,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F15,\"\")))))","v":0.61839999999999995}]
["Unit Cost/therm excluding constrain rebate",{"$f":"B15*29.3071","v":18.123510639999999},{"$f":"C15*29.3071","v":18.299353240000002},null,null,{"$f":"F15*29.3071","v":18.299353240000002},null,null,null,"Unit Cost/therm excluding constrain rebate",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B16,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C16,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F16,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E16,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F16,\"\")))))","v":18.123510639999999}]
[]
["Constrained Rebate p/kwh/space",{"$f":"SUM(0.0032*365)/B40","v":0.65373134328358218},0,null,null,0,null,null,null,"Constrained Rebate p/kwh/space",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B18,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C18,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F18,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E18,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F18,\"\")))))","v":0.65373134328358218}]
[]
["Unit Cost of Service (including rebate)",{"$f":"B15-B18","v":-3.5331343283582228E-2},{"$f":"C15-C18","v":0.62440000000000007},null,null,{"$f":"F15-F18","v":0.62440000000000007},null,null,null,"Unit Cost of Service (including rebate)",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B20,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C20,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F20,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E20,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F20,\"\")))))","v":-3.5331343283582228E-2}]
[]
["Cost of Service (inc Rebate, ex other service charges)",{"$f":"(B3*B4/100)-((B18*B3)/100)","v":-1483335.5850746273},{"$f":"(C3*C4/100)","v":692295.4},null,null,{"$f":"(F3*F4/100)","v":3019165.4},null,null,null,"Cost of Service (inc Rebate, ex other service charges)",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B22,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C22,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F22,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E22,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F22,\"\")))))","v":-1483335.5850746273}]
["Total Cost of Service (inc Rebate)",{"$f":"B20*B3/100","v":-214496.58507462768},{"$f":"C20*C3/100","v":1055860.4000000001},null,null,{"$f":"F20*F3/100","v":5395440.4000000004},null,null,null,"Total Cost of Service (inc Rebate)",{"$f":"IF(B$31='COST CALC 2012 13'!B$25,'COST CALC 2012 13'!B23,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!C$25,'COST CALC 2012 13'!C23,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!D$25,'COST CALC 2012 13'!F23,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!E$25,'COST CALC 2012 13'!E23,IF('COST CALC 2012 13'!B$31='COST CALC 2012 13'!F$25,'COST CALC 2012 13'!F23,\"\")))))","v":-214496.58507462768}]
[]
[null,"Avonmouth","Dynevor","Partington"]
["Enter data in yellow cells"]
[]
["LNG 2015/2016 Service Costs"]
[]
[]
["Site","Avonmouth",null,null,null,null,null,null,null,null,null,null,null,null,"Avonmouth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glenmavis"]
[null,"kWh","Therms",null,null,null,null,null,null,null,null,null,null,null,"Partington"]
["Total bundled units required",268000000,{"$f":"B34/29.3071","v":9144541.766329661}]
[]
["Capacity to be purchased"]
["Total space",{"$f":"B34","v":268000000},{"$f":"B37/29.3071","v":9144541.766329661}]
["Firm Withdrawal rights per day",{"$f":"B37*'Invitation Table'!H6","v":150000000},{"$f":"B38/29.3071","v":5118213.6751845116}]
["Firm Injection per day",{"$f":"B37*'Invitation Table'!H4","v":1103260},{"$f":"IF(ISERROR(B39/29.3071),\"\",B39/29.3071)","v":37644.8027952271}]
["Duration (days)",{"$f":"B37/B38","v":1.7866666666666666}]
[]
[null,"p/kWh","p/Therm"]
[]
["Reserve Price unit/space",{"$f":"'Invitation Table'!E14","v":0.42030000000000001},{"$f":"B44*29.3071","v":12.31777413}]
["Customer Bid Price",0.45,{"$f":"B45*29.3071","v":13.188195},{"$f":"IF(B45<B44,\"Error bid price is less than reserve please re-enter!\",IF(B45<B44,\"Error bid price is less than reserve please re-enter!\",IF(B45<B44,\"Error bid price is less than reserve please re-enter!\",IF(B45<B44,\"Error bid price is less than reserve please re-enter!\",\"Bid is OK as it is greater than reserve price\"))))","v":"Bid is OK as it is greater than reserve price"}]
["Estimated cost of summer gas for injection",2.1,{"$f":"B46*29.3071","v":61.544910000000002}]
[]
["Associated LNG Costs"]
[]
["Injection / unit ",{"$f":"'Invitation Table'!C14","v":0.46700000000000003},{"$f":"B50*29.3071","v":13.6864157}]
["Withdrawal / unit",{"$f":"'Invitation Table'!D14","v":3.5000000000000003E-2},{"$f":"B51*29.3071","v":1.0257485}]
["Constrained rebate",0,{"$f":"B52*29.3071","v":0}]
[]
["Total LNG Service Cost ",{"$f":"B45+B50+B51-B52","v":0.95200000000000007},{"$f":"B54*29.3071","v":27.9003592}]
[]
["Total Cost of Service Including Gas Costs ",{"$f":"B54+B46","v":3.052},{"$f":"B56*29.3071","v":89.445269199999998}]
[]
["Tankering"]
[]
["Number of Slots",1]
["Monthly Tanker Loads Required",10]
[]
["Summary"]
[]
["Cost of LNG Service (Capacity only)",{"$f":"SUM(B45-B52)*B34/100","v":1206000}]
["Cost of LNG Service inc associated costs (exc Gas Costs)",{"$f":"B54*B37/100","v":2551360.0000000005}]
["Cost of LNG Service inc associated costs (inc Gas Costs)",{"$f":"B56*B37/100","v":8179360}]
["Tankering Costs (Annual)",{"$f":"B60*'Invitation Table'!C19+'COST CALC 2012 13'!B61*'Invitation Table'!D19*12","v":93567.46}]
[]
[]
["Enter data only in Yellow  Cells Only"]
[]
["Disclaimer"]
["This program is supplied only with the intention of providing a guide to the cost of an LNG Storage Service for 2012/13. National Grid LNG Storage does not accept any liability for any errors"]
["contained within the program. It is not recommended to solely base your auction strategy on this program."]

{"sheet":"Invitation Table","index":1,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,3,2,8],[3,1,8,1],[3,2,8,2]]}
[null,"Appendix 1",null,null,null,null,null,null,null,null,null,"Appendix 5 - Table 5"]
[]
[null,"Facility","2015/16 Constrained Status","Bundled Units Available",null,null,null,null,null,"Reserve Price (pence per bundled unit)",null,"Facility","Storage Injectability (kWh/d)","Storage Space (kWh)","Storage Deliverability (kWh/d)"]
[null,"Avonmouth","Not Constrained","Stage 1:  (12 month fixed Storage Duration )",134000000,"kWh","Injectability:",{"$f":"M4/N4","v":4.1166417910447764E-3},"kWh/d","Stage 1: 0.4203",null,"Avonmouth",1103260,268000000,150000000]
[null,null,null,"Stage 2: (6 month fixed Storage Duration )",67000000,"kWh","Space:",1,"kWh","Stage 2: 0.4203"]
[null,null,null,"(plus any rolled over capacity)",null,null,"Deliverability:",{"$f":"O4/N4","v":0.55970149253731338},"kWh/d"]
[null,null,null,"Stage 3: (6 month fixed Storage Duration )",67000000,"kWh","Duration:",{"$f":"H5/H6","v":1.7866666666666668},"Days","Stage 3: 0.4203"]
[null,null,null,"(plus any rolled over capacity)"]
[null,null,null,"Total",{"$f":"SUM(E4:E7)","v":268000000},"kWh"]
[]
[null,"Appendix 2 - Service costs (p/kWh)"]
[]
[null,null,"Storage Injection (inside window)","Storage Withdrawal","Reserve Price"]
[null,"Avonmouth",0.46700000000000003,3.5000000000000003E-2,0.42030000000000001]
[]
[null,"Appendix 2 - Tankering Costs (£)"]
[]
[null,null,"Tanker Filling Slot","Tanker Withdrawal Charge"]
[null,"Avonmouth",9619.06,699.57]