{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["BID SHEET","Monetary Values of Bids","Application Form","Attribution","Appendix One","HowUse","Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":8,"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":"BID SHEET","index":0,"n_rows":83,"n_cols":4,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Avonmouth National Grid LNG Special Storage Capacity 2015 / 2016 Bid Tender"]
[]
[]
[]
[]
[]
["Bid Number","Duration","Bundled Unit kWh","Bid Value One"]
[]
[{"$f":"IF(ISERR(A8+1),\"\",IF(B9=\"\",\"\",A8+1))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISERR(A28+1),\"\",IF(B29=\"\",\"\",A28+1))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISERR(A82+1),\"\",IF(B83=\"\",\"\",A82+1))","v":""}]

{"sheet":"Monetary Values of Bids","index":1,"n_rows":83,"n_cols":4,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[{"$f":"'BID SHEET'!A7","v":"Bid Number"},{"$f":"'BID SHEET'!B7","v":"Duration"},{"$f":"'BID SHEET'!C7","v":"Bundled Unit kWh"},"BID Value One £"]
[{"$f":"IF('BID SHEET'!A8=\"\",\"\",'BID SHEET'!A8)","v":""},{"$f":"IF('BID SHEET'!B8=\"\",\"\",'BID SHEET'!B8)","v":""},{"$f":"IF('BID SHEET'!C8=\"\",\"\",'BID SHEET'!C8)","v":""},{"$f":"IF('BID SHEET'!$C8*'BID SHEET'!D8/100=0,\"\",'BID SHEET'!$C8*'BID SHEET'!D8/100)","v":""}]
[{"$f":"IF('BID SHEET'!A9=\"\",\"\",'BID SHEET'!A9)","v":""},{"$f":"IF('BID SHEET'!B9=\"\",\"\",'BID SHEET'!B9)","v":""},{"$f":"IF('BID SHEET'!C9=\"\",\"\",'BID SHEET'!C9)","v":""},{"$f":"IF('BID SHEET'!$C9*'BID SHEET'!D9/100=0,\"\",'BID SHEET'!$C9*'BID SHEET'!D9/100)","v":""}]
[{"$f":"IF('BID SHEET'!A10=\"\",\"\",'BID SHEET'!A10)","v":""},{"$f":"IF('BID SHEET'!B10=\"\",\"\",'BID SHEET'!B10)","v":""},{"$f":"IF('BID SHEET'!C10=\"\",\"\",'BID SHEET'!C10)","v":""},{"$f":"IF('BID SHEET'!$C10*'BID SHEET'!D10/100=0,\"\",'BID SHEET'!$C10*'BID SHEET'!D10/100)","v":""}]
[{"$f":"IF('BID SHEET'!A11=\"\",\"\",'BID SHEET'!A11)","v":""},{"$f":"IF('BID SHEET'!B11=\"\",\"\",'BID SHEET'!B11)","v":""},{"$f":"IF('BID SHEET'!C11=\"\",\"\",'BID SHEET'!C11)","v":""},{"$f":"IF('BID SHEET'!$C11*'BID SHEET'!D11/100=0,\"\",'BID SHEET'!$C11*'BID SHEET'!D11/100)","v":""}]
[{"$f":"IF('BID SHEET'!A12=\"\",\"\",'BID SHEET'!A12)","v":""},{"$f":"IF('BID SHEET'!B12=\"\",\"\",'BID SHEET'!B12)","v":""},{"$f":"IF('BID SHEET'!C12=\"\",\"\",'BID SHEET'!C12)","v":""},{"$f":"IF('BID SHEET'!$C12*'BID SHEET'!D12/100=0,\"\",'BID SHEET'!$C12*'BID SHEET'!D12/100)","v":""}]
[{"$f":"IF('BID SHEET'!A13=\"\",\"\",'BID SHEET'!A13)","v":""},{"$f":"IF('BID SHEET'!B13=\"\",\"\",'BID SHEET'!B13)","v":""},{"$f":"IF('BID SHEET'!C13=\"\",\"\",'BID SHEET'!C13)","v":""},{"$f":"IF('BID SHEET'!$C13*'BID SHEET'!D13/100=0,\"\",'BID SHEET'!$C13*'BID SHEET'!D13/100)","v":""}]
[{"$f":"IF('BID SHEET'!A14=\"\",\"\",'BID SHEET'!A14)","v":""},{"$f":"IF('BID SHEET'!B14=\"\",\"\",'BID SHEET'!B14)","v":""},{"$f":"IF('BID SHEET'!C14=\"\",\"\",'BID SHEET'!C14)","v":""},{"$f":"IF('BID SHEET'!$C14*'BID SHEET'!D14/100=0,\"\",'BID SHEET'!$C14*'BID SHEET'!D14/100)","v":""}]
[{"$f":"IF('BID SHEET'!A15=\"\",\"\",'BID SHEET'!A15)","v":""},{"$f":"IF('BID SHEET'!B15=\"\",\"\",'BID SHEET'!B15)","v":""},{"$f":"IF('BID SHEET'!C15=\"\",\"\",'BID SHEET'!C15)","v":""},{"$f":"IF('BID SHEET'!$C15*'BID SHEET'!D15/100=0,\"\",'BID SHEET'!$C15*'BID SHEET'!D15/100)","v":""}]
[{"$f":"IF('BID SHEET'!A16=\"\",\"\",'BID SHEET'!A16)","v":""},{"$f":"IF('BID SHEET'!B16=\"\",\"\",'BID SHEET'!B16)","v":""},{"$f":"IF('BID SHEET'!C16=\"\",\"\",'BID SHEET'!C16)","v":""},{"$f":"IF('BID SHEET'!$C16*'BID SHEET'!D16/100=0,\"\",'BID SHEET'!$C16*'BID SHEET'!D16/100)","v":""}]
[{"$f":"IF('BID SHEET'!A17=\"\",\"\",'BID SHEET'!A17)","v":""},{"$f":"IF('BID SHEET'!B17=\"\",\"\",'BID SHEET'!B17)","v":""},{"$f":"IF('BID SHEET'!C17=\"\",\"\",'BID SHEET'!C17)","v":""},{"$f":"IF('BID SHEET'!$C17*'BID SHEET'!D17/100=0,\"\",'BID SHEET'!$C17*'BID SHEET'!D17/100)","v":""}]
[{"$f":"IF('BID SHEET'!A18=\"\",\"\",'BID SHEET'!A18)","v":""},{"$f":"IF('BID SHEET'!B18=\"\",\"\",'BID SHEET'!B18)","v":""},{"$f":"IF('BID SHEET'!C18=\"\",\"\",'BID SHEET'!C18)","v":""},{"$f":"IF('BID SHEET'!$C18*'BID SHEET'!D18/100=0,\"\",'BID SHEET'!$C18*'BID SHEET'!D18/100)","v":""}]
[{"$f":"IF('BID SHEET'!A19=\"\",\"\",'BID SHEET'!A19)","v":""},{"$f":"IF('BID SHEET'!B19=\"\",\"\",'BID SHEET'!B19)","v":""},{"$f":"IF('BID SHEET'!C19=\"\",\"\",'BID SHEET'!C19)","v":""},{"$f":"IF('BID SHEET'!$C19*'BID SHEET'!D19/100=0,\"\",'BID SHEET'!$C19*'BID SHEET'!D19/100)","v":""}]
[{"$f":"IF('BID SHEET'!A20=\"\",\"\",'BID SHEET'!A20)","v":""},{"$f":"IF('BID SHEET'!B20=\"\",\"\",'BID SHEET'!B20)","v":""},{"$f":"IF('BID SHEET'!C20=\"\",\"\",'BID SHEET'!C20)","v":""},{"$f":"IF('BID SHEET'!$C20*'BID SHEET'!D20/100=0,\"\",'BID SHEET'!$C20*'BID SHEET'!D20/100)","v":""}]
[{"$f":"IF('BID SHEET'!A21=\"\",\"\",'BID SHEET'!A21)","v":""},{"$f":"IF('BID SHEET'!B21=\"\",\"\",'BID SHEET'!B21)","v":""},{"$f":"IF('BID SHEET'!C21=\"\",\"\",'BID SHEET'!C21)","v":""},{"$f":"IF('BID SHEET'!$C21*'BID SHEET'!D21/100=0,\"\",'BID SHEET'!$C21*'BID SHEET'!D21/100)","v":""}]
[{"$f":"IF('BID SHEET'!A22=\"\",\"\",'BID SHEET'!A22)","v":""},{"$f":"IF('BID SHEET'!B22=\"\",\"\",'BID SHEET'!B22)","v":""},{"$f":"IF('BID SHEET'!C22=\"\",\"\",'BID SHEET'!C22)","v":""},{"$f":"IF('BID SHEET'!$C22*'BID SHEET'!D22/100=0,\"\",'BID SHEET'!$C22*'BID SHEET'!D22/100)","v":""}]
[{"$f":"IF('BID SHEET'!A23=\"\",\"\",'BID SHEET'!A23)","v":""},{"$f":"IF('BID SHEET'!B23=\"\",\"\",'BID SHEET'!B23)","v":""},{"$f":"IF('BID SHEET'!C23=\"\",\"\",'BID SHEET'!C23)","v":""},{"$f":"IF('BID SHEET'!$C23*'BID SHEET'!D23/100=0,\"\",'BID SHEET'!$C23*'BID SHEET'!D23/100)","v":""}]
[{"$f":"IF('BID SHEET'!A24=\"\",\"\",'BID SHEET'!A24)","v":""},{"$f":"IF('BID SHEET'!B24=\"\",\"\",'BID SHEET'!B24)","v":""},{"$f":"IF('BID SHEET'!C24=\"\",\"\",'BID SHEET'!C24)","v":""},{"$f":"IF('BID SHEET'!$C24*'BID SHEET'!D24/100=0,\"\",'BID SHEET'!$C24*'BID SHEET'!D24/100)","v":""}]
[{"$f":"IF('BID SHEET'!A25=\"\",\"\",'BID SHEET'!A25)","v":""},{"$f":"IF('BID SHEET'!B25=\"\",\"\",'BID SHEET'!B25)","v":""},{"$f":"IF('BID SHEET'!C25=\"\",\"\",'BID SHEET'!C25)","v":""},{"$f":"IF('BID SHEET'!$C25*'BID SHEET'!D25/100=0,\"\",'BID SHEET'!$C25*'BID SHEET'!D25/100)","v":""}]
[{"$f":"IF('BID SHEET'!A26=\"\",\"\",'BID SHEET'!A26)","v":""},{"$f":"IF('BID SHEET'!B26=\"\",\"\",'BID SHEET'!B26)","v":""},{"$f":"IF('BID SHEET'!C26=\"\",\"\",'BID SHEET'!C26)","v":""},{"$f":"IF('BID SHEET'!$C26*'BID SHEET'!D26/100=0,\"\",'BID SHEET'!$C26*'BID SHEET'!D26/100)","v":""}]
[{"$f":"IF('BID SHEET'!A27=\"\",\"\",'BID SHEET'!A27)","v":""},{"$f":"IF('BID SHEET'!B27=\"\",\"\",'BID SHEET'!B27)","v":""},{"$f":"IF('BID SHEET'!C27=\"\",\"\",'BID SHEET'!C27)","v":""},{"$f":"IF('BID SHEET'!$C27*'BID SHEET'!D27/100=0,\"\",'BID SHEET'!$C27*'BID SHEET'!D27/100)","v":""}]
[{"$f":"IF('BID SHEET'!A28=\"\",\"\",'BID SHEET'!A28)","v":""},{"$f":"IF('BID SHEET'!B28=\"\",\"\",'BID SHEET'!B28)","v":""},{"$f":"IF('BID SHEET'!C28=\"\",\"\",'BID SHEET'!C28)","v":""},{"$f":"IF('BID SHEET'!$C28*'BID SHEET'!D28/100=0,\"\",'BID SHEET'!$C28*'BID SHEET'!D28/100)","v":""}]
[{"$f":"IF('BID SHEET'!A29=\"\",\"\",'BID SHEET'!A29)","v":""},{"$f":"IF('BID SHEET'!B29=\"\",\"\",'BID SHEET'!B29)","v":""},{"$f":"IF('BID SHEET'!C29=\"\",\"\",'BID SHEET'!C29)","v":""},{"$f":"IF('BID SHEET'!$C29*'BID SHEET'!D29/100=0,\"\",'BID SHEET'!$C29*'BID SHEET'!D29/100)","v":""}]
[{"$f":"IF('BID SHEET'!A30=\"\",\"\",'BID SHEET'!A30)","v":""},{"$f":"IF('BID SHEET'!B30=\"\",\"\",'BID SHEET'!B30)","v":""},{"$f":"IF('BID SHEET'!C30=\"\",\"\",'BID SHEET'!C30)","v":""},{"$f":"IF('BID SHEET'!$C30*'BID SHEET'!D30/100=0,\"\",'BID SHEET'!$C30*'BID SHEET'!D30/100)","v":""}]
[{"$f":"IF('BID SHEET'!A31=\"\",\"\",'BID SHEET'!A31)","v":""},{"$f":"IF('BID SHEET'!B31=\"\",\"\",'BID SHEET'!B31)","v":""},{"$f":"IF('BID SHEET'!C31=\"\",\"\",'BID SHEET'!C31)","v":""},{"$f":"IF('BID SHEET'!$C31*'BID SHEET'!D31/100=0,\"\",'BID SHEET'!$C31*'BID SHEET'!D31/100)","v":""}]
[{"$f":"IF('BID SHEET'!A32=\"\",\"\",'BID SHEET'!A32)","v":""},{"$f":"IF('BID SHEET'!B32=\"\",\"\",'BID SHEET'!B32)","v":""},{"$f":"IF('BID SHEET'!C32=\"\",\"\",'BID SHEET'!C32)","v":""},{"$f":"IF('BID SHEET'!$C32*'BID SHEET'!D32/100=0,\"\",'BID SHEET'!$C32*'BID SHEET'!D32/100)","v":""}]
[{"$f":"IF('BID SHEET'!A33=\"\",\"\",'BID SHEET'!A33)","v":""},{"$f":"IF('BID SHEET'!B33=\"\",\"\",'BID SHEET'!B33)","v":""},{"$f":"IF('BID SHEET'!C33=\"\",\"\",'BID SHEET'!C33)","v":""},{"$f":"IF('BID SHEET'!$C33*'BID SHEET'!D33/100=0,\"\",'BID SHEET'!$C33*'BID SHEET'!D33/100)","v":""}]
[{"$f":"IF('BID SHEET'!A34=\"\",\"\",'BID SHEET'!A34)","v":""},{"$f":"IF('BID SHEET'!B34=\"\",\"\",'BID SHEET'!B34)","v":""},{"$f":"IF('BID SHEET'!C34=\"\",\"\",'BID SHEET'!C34)","v":""},{"$f":"IF('BID SHEET'!$C34*'BID SHEET'!D34/100=0,\"\",'BID SHEET'!$C34*'BID SHEET'!D34/100)","v":""}]
[{"$f":"IF('BID SHEET'!A35=\"\",\"\",'BID SHEET'!A35)","v":""},{"$f":"IF('BID SHEET'!B35=\"\",\"\",'BID SHEET'!B35)","v":""},{"$f":"IF('BID SHEET'!C35=\"\",\"\",'BID SHEET'!C35)","v":""},{"$f":"IF('BID SHEET'!$C35*'BID SHEET'!D35/100=0,\"\",'BID SHEET'!$C35*'BID SHEET'!D35/100)","v":""}]
[{"$f":"IF('BID SHEET'!A36=\"\",\"\",'BID SHEET'!A36)","v":""},{"$f":"IF('BID SHEET'!B36=\"\",\"\",'BID SHEET'!B36)","v":""},{"$f":"IF('BID SHEET'!C36=\"\",\"\",'BID SHEET'!C36)","v":""},{"$f":"IF('BID SHEET'!$C36*'BID SHEET'!D36/100=0,\"\",'BID SHEET'!$C36*'BID SHEET'!D36/100)","v":""}]
[{"$f":"IF('BID SHEET'!A37=\"\",\"\",'BID SHEET'!A37)","v":""},{"$f":"IF('BID SHEET'!B37=\"\",\"\",'BID SHEET'!B37)","v":""},{"$f":"IF('BID SHEET'!C37=\"\",\"\",'BID SHEET'!C37)","v":""},{"$f":"IF('BID SHEET'!$C37*'BID SHEET'!D37/100=0,\"\",'BID SHEET'!$C37*'BID SHEET'!D37/100)","v":""}]
[{"$f":"IF('BID SHEET'!A38=\"\",\"\",'BID SHEET'!A38)","v":""},{"$f":"IF('BID SHEET'!B38=\"\",\"\",'BID SHEET'!B38)","v":""},{"$f":"IF('BID SHEET'!C38=\"\",\"\",'BID SHEET'!C38)","v":""},{"$f":"IF('BID SHEET'!$C38*'BID SHEET'!D38/100=0,\"\",'BID SHEET'!$C38*'BID SHEET'!D38/100)","v":""}]
[{"$f":"IF('BID SHEET'!A39=\"\",\"\",'BID SHEET'!A39)","v":""},{"$f":"IF('BID SHEET'!B39=\"\",\"\",'BID SHEET'!B39)","v":""},{"$f":"IF('BID SHEET'!C39=\"\",\"\",'BID SHEET'!C39)","v":""},{"$f":"IF('BID SHEET'!$C39*'BID SHEET'!D39/100=0,\"\",'BID SHEET'!$C39*'BID SHEET'!D39/100)","v":""}]
[{"$f":"IF('BID SHEET'!A40=\"\",\"\",'BID SHEET'!A40)","v":""},{"$f":"IF('BID SHEET'!B40=\"\",\"\",'BID SHEET'!B40)","v":""},{"$f":"IF('BID SHEET'!C40=\"\",\"\",'BID SHEET'!C40)","v":""},{"$f":"IF('BID SHEET'!$C40*'BID SHEET'!D40/100=0,\"\",'BID SHEET'!$C40*'BID SHEET'!D40/100)","v":""}]
[{"$f":"IF('BID SHEET'!A41=\"\",\"\",'BID SHEET'!A41)","v":""},{"$f":"IF('BID SHEET'!B41=\"\",\"\",'BID SHEET'!B41)","v":""},{"$f":"IF('BID SHEET'!C41=\"\",\"\",'BID SHEET'!C41)","v":""},{"$f":"IF('BID SHEET'!$C41*'BID SHEET'!D41/100=0,\"\",'BID SHEET'!$C41*'BID SHEET'!D41/100)","v":""}]
[{"$f":"IF('BID SHEET'!A42=\"\",\"\",'BID SHEET'!A42)","v":""},{"$f":"IF('BID SHEET'!B42=\"\",\"\",'BID SHEET'!B42)","v":""},{"$f":"IF('BID SHEET'!C42=\"\",\"\",'BID SHEET'!C42)","v":""},{"$f":"IF('BID SHEET'!$C42*'BID SHEET'!D42/100=0,\"\",'BID SHEET'!$C42*'BID SHEET'!D42/100)","v":""}]
[{"$f":"IF('BID SHEET'!A43=\"\",\"\",'BID SHEET'!A43)","v":""},{"$f":"IF('BID SHEET'!B43=\"\",\"\",'BID SHEET'!B43)","v":""},{"$f":"IF('BID SHEET'!C43=\"\",\"\",'BID SHEET'!C43)","v":""},{"$f":"IF('BID SHEET'!$C43*'BID SHEET'!D43/100=0,\"\",'BID SHEET'!$C43*'BID SHEET'!D43/100)","v":""}]
[{"$f":"IF('BID SHEET'!A44=\"\",\"\",'BID SHEET'!A44)","v":""},{"$f":"IF('BID SHEET'!B44=\"\",\"\",'BID SHEET'!B44)","v":""},{"$f":"IF('BID SHEET'!C44=\"\",\"\",'BID SHEET'!C44)","v":""},{"$f":"IF('BID SHEET'!$C44*'BID SHEET'!D44/100=0,\"\",'BID SHEET'!$C44*'BID SHEET'!D44/100)","v":""}]
[{"$f":"IF('BID SHEET'!A45=\"\",\"\",'BID SHEET'!A45)","v":""},{"$f":"IF('BID SHEET'!B45=\"\",\"\",'BID SHEET'!B45)","v":""},{"$f":"IF('BID SHEET'!C45=\"\",\"\",'BID SHEET'!C45)","v":""},{"$f":"IF('BID SHEET'!$C45*'BID SHEET'!D45/100=0,\"\",'BID SHEET'!$C45*'BID SHEET'!D45/100)","v":""}]
[{"$f":"IF('BID SHEET'!A46=\"\",\"\",'BID SHEET'!A46)","v":""},{"$f":"IF('BID SHEET'!B46=\"\",\"\",'BID SHEET'!B46)","v":""},{"$f":"IF('BID SHEET'!C46=\"\",\"\",'BID SHEET'!C46)","v":""},{"$f":"IF('BID SHEET'!$C46*'BID SHEET'!D46/100=0,\"\",'BID SHEET'!$C46*'BID SHEET'!D46/100)","v":""}]
[{"$f":"IF('BID SHEET'!A47=\"\",\"\",'BID SHEET'!A47)","v":""},{"$f":"IF('BID SHEET'!B47=\"\",\"\",'BID SHEET'!B47)","v":""},{"$f":"IF('BID SHEET'!C47=\"\",\"\",'BID SHEET'!C47)","v":""},{"$f":"IF('BID SHEET'!$C47*'BID SHEET'!D47/100=0,\"\",'BID SHEET'!$C47*'BID SHEET'!D47/100)","v":""}]
[{"$f":"IF('BID SHEET'!A48=\"\",\"\",'BID SHEET'!A48)","v":""},{"$f":"IF('BID SHEET'!B48=\"\",\"\",'BID SHEET'!B48)","v":""},{"$f":"IF('BID SHEET'!C48=\"\",\"\",'BID SHEET'!C48)","v":""},{"$f":"IF('BID SHEET'!$C48*'BID SHEET'!D48/100=0,\"\",'BID SHEET'!$C48*'BID SHEET'!D48/100)","v":""}]
[{"$f":"IF('BID SHEET'!A49=\"\",\"\",'BID SHEET'!A49)","v":""},{"$f":"IF('BID SHEET'!B49=\"\",\"\",'BID SHEET'!B49)","v":""},{"$f":"IF('BID SHEET'!C49=\"\",\"\",'BID SHEET'!C49)","v":""},{"$f":"IF('BID SHEET'!$C49*'BID SHEET'!D49/100=0,\"\",'BID SHEET'!$C49*'BID SHEET'!D49/100)","v":""}]
[{"$f":"IF('BID SHEET'!A50=\"\",\"\",'BID SHEET'!A50)","v":""},{"$f":"IF('BID SHEET'!B50=\"\",\"\",'BID SHEET'!B50)","v":""},{"$f":"IF('BID SHEET'!C50=\"\",\"\",'BID SHEET'!C50)","v":""},{"$f":"IF('BID SHEET'!$C50*'BID SHEET'!D50/100=0,\"\",'BID SHEET'!$C50*'BID SHEET'!D50/100)","v":""}]
[{"$f":"IF('BID SHEET'!A51=\"\",\"\",'BID SHEET'!A51)","v":""},{"$f":"IF('BID SHEET'!B51=\"\",\"\",'BID SHEET'!B51)","v":""},{"$f":"IF('BID SHEET'!C51=\"\",\"\",'BID SHEET'!C51)","v":""},{"$f":"IF('BID SHEET'!$C51*'BID SHEET'!D51/100=0,\"\",'BID SHEET'!$C51*'BID SHEET'!D51/100)","v":""}]
[{"$f":"IF('BID SHEET'!A52=\"\",\"\",'BID SHEET'!A52)","v":""},{"$f":"IF('BID SHEET'!B52=\"\",\"\",'BID SHEET'!B52)","v":""},{"$f":"IF('BID SHEET'!C52=\"\",\"\",'BID SHEET'!C52)","v":""},{"$f":"IF('BID SHEET'!$C52*'BID SHEET'!D52/100=0,\"\",'BID SHEET'!$C52*'BID SHEET'!D52/100)","v":""}]
[{"$f":"IF('BID SHEET'!A53=\"\",\"\",'BID SHEET'!A53)","v":""},{"$f":"IF('BID SHEET'!B53=\"\",\"\",'BID SHEET'!B53)","v":""},{"$f":"IF('BID SHEET'!C53=\"\",\"\",'BID SHEET'!C53)","v":""},{"$f":"IF('BID SHEET'!$C53*'BID SHEET'!D53/100=0,\"\",'BID SHEET'!$C53*'BID SHEET'!D53/100)","v":""}]
[{"$f":"IF('BID SHEET'!A54=\"\",\"\",'BID SHEET'!A54)","v":""},{"$f":"IF('BID SHEET'!B54=\"\",\"\",'BID SHEET'!B54)","v":""},{"$f":"IF('BID SHEET'!C54=\"\",\"\",'BID SHEET'!C54)","v":""},{"$f":"IF('BID SHEET'!$C54*'BID SHEET'!D54/100=0,\"\",'BID SHEET'!$C54*'BID SHEET'!D54/100)","v":""}]
[{"$f":"IF('BID SHEET'!A55=\"\",\"\",'BID SHEET'!A55)","v":""},{"$f":"IF('BID SHEET'!B55=\"\",\"\",'BID SHEET'!B55)","v":""},{"$f":"IF('BID SHEET'!C55=\"\",\"\",'BID SHEET'!C55)","v":""},{"$f":"IF('BID SHEET'!$C55*'BID SHEET'!D55/100=0,\"\",'BID SHEET'!$C55*'BID SHEET'!D55/100)","v":""}]
[{"$f":"IF('BID SHEET'!A56=\"\",\"\",'BID SHEET'!A56)","v":""},{"$f":"IF('BID SHEET'!B56=\"\",\"\",'BID SHEET'!B56)","v":""},{"$f":"IF('BID SHEET'!C56=\"\",\"\",'BID SHEET'!C56)","v":""},{"$f":"IF('BID SHEET'!$C56*'BID SHEET'!D56/100=0,\"\",'BID SHEET'!$C56*'BID SHEET'!D56/100)","v":""}]
[{"$f":"IF('BID SHEET'!A57=\"\",\"\",'BID SHEET'!A57)","v":""},{"$f":"IF('BID SHEET'!B57=\"\",\"\",'BID SHEET'!B57)","v":""},{"$f":"IF('BID SHEET'!C57=\"\",\"\",'BID SHEET'!C57)","v":""},{"$f":"IF('BID SHEET'!$C57*'BID SHEET'!D57/100=0,\"\",'BID SHEET'!$C57*'BID SHEET'!D57/100)","v":""}]
[{"$f":"IF('BID SHEET'!A58=\"\",\"\",'BID SHEET'!A58)","v":""},{"$f":"IF('BID SHEET'!B58=\"\",\"\",'BID SHEET'!B58)","v":""},{"$f":"IF('BID SHEET'!C58=\"\",\"\",'BID SHEET'!C58)","v":""},{"$f":"IF('BID SHEET'!$C58*'BID SHEET'!D58/100=0,\"\",'BID SHEET'!$C58*'BID SHEET'!D58/100)","v":""}]
[{"$f":"IF('BID SHEET'!A59=\"\",\"\",'BID SHEET'!A59)","v":""},{"$f":"IF('BID SHEET'!B59=\"\",\"\",'BID SHEET'!B59)","v":""},{"$f":"IF('BID SHEET'!C59=\"\",\"\",'BID SHEET'!C59)","v":""},{"$f":"IF('BID SHEET'!$C59*'BID SHEET'!D59/100=0,\"\",'BID SHEET'!$C59*'BID SHEET'!D59/100)","v":""}]
[{"$f":"IF('BID SHEET'!A60=\"\",\"\",'BID SHEET'!A60)","v":""},{"$f":"IF('BID SHEET'!B60=\"\",\"\",'BID SHEET'!B60)","v":""},{"$f":"IF('BID SHEET'!C60=\"\",\"\",'BID SHEET'!C60)","v":""},{"$f":"IF('BID SHEET'!$C60*'BID SHEET'!D60/100=0,\"\",'BID SHEET'!$C60*'BID SHEET'!D60/100)","v":""}]
[{"$f":"IF('BID SHEET'!A61=\"\",\"\",'BID SHEET'!A61)","v":""},{"$f":"IF('BID SHEET'!B61=\"\",\"\",'BID SHEET'!B61)","v":""},{"$f":"IF('BID SHEET'!C61=\"\",\"\",'BID SHEET'!C61)","v":""},{"$f":"IF('BID SHEET'!$C61*'BID SHEET'!D61/100=0,\"\",'BID SHEET'!$C61*'BID SHEET'!D61/100)","v":""}]
[{"$f":"IF('BID SHEET'!A62=\"\",\"\",'BID SHEET'!A62)","v":""},{"$f":"IF('BID SHEET'!B62=\"\",\"\",'BID SHEET'!B62)","v":""},{"$f":"IF('BID SHEET'!C62=\"\",\"\",'BID SHEET'!C62)","v":""},{"$f":"IF('BID SHEET'!$C62*'BID SHEET'!D62/100=0,\"\",'BID SHEET'!$C62*'BID SHEET'!D62/100)","v":""}]
[{"$f":"IF('BID SHEET'!A63=\"\",\"\",'BID SHEET'!A63)","v":""},{"$f":"IF('BID SHEET'!B63=\"\",\"\",'BID SHEET'!B63)","v":""},{"$f":"IF('BID SHEET'!C63=\"\",\"\",'BID SHEET'!C63)","v":""},{"$f":"IF('BID SHEET'!$C63*'BID SHEET'!D63/100=0,\"\",'BID SHEET'!$C63*'BID SHEET'!D63/100)","v":""}]
[{"$f":"IF('BID SHEET'!A64=\"\",\"\",'BID SHEET'!A64)","v":""},{"$f":"IF('BID SHEET'!B64=\"\",\"\",'BID SHEET'!B64)","v":""},{"$f":"IF('BID SHEET'!C64=\"\",\"\",'BID SHEET'!C64)","v":""},{"$f":"IF('BID SHEET'!$C64*'BID SHEET'!D64/100=0,\"\",'BID SHEET'!$C64*'BID SHEET'!D64/100)","v":""}]
[{"$f":"IF('BID SHEET'!A65=\"\",\"\",'BID SHEET'!A65)","v":""},{"$f":"IF('BID SHEET'!B65=\"\",\"\",'BID SHEET'!B65)","v":""},{"$f":"IF('BID SHEET'!C65=\"\",\"\",'BID SHEET'!C65)","v":""},{"$f":"IF('BID SHEET'!$C65*'BID SHEET'!D65/100=0,\"\",'BID SHEET'!$C65*'BID SHEET'!D65/100)","v":""}]
[{"$f":"IF('BID SHEET'!A66=\"\",\"\",'BID SHEET'!A66)","v":""},{"$f":"IF('BID SHEET'!B66=\"\",\"\",'BID SHEET'!B66)","v":""},{"$f":"IF('BID SHEET'!C66=\"\",\"\",'BID SHEET'!C66)","v":""},{"$f":"IF('BID SHEET'!$C66*'BID SHEET'!D66/100=0,\"\",'BID SHEET'!$C66*'BID SHEET'!D66/100)","v":""}]
[{"$f":"IF('BID SHEET'!A67=\"\",\"\",'BID SHEET'!A67)","v":""},{"$f":"IF('BID SHEET'!B67=\"\",\"\",'BID SHEET'!B67)","v":""},{"$f":"IF('BID SHEET'!C67=\"\",\"\",'BID SHEET'!C67)","v":""},{"$f":"IF('BID SHEET'!$C67*'BID SHEET'!D67/100=0,\"\",'BID SHEET'!$C67*'BID SHEET'!D67/100)","v":""}]
[{"$f":"IF('BID SHEET'!A68=\"\",\"\",'BID SHEET'!A68)","v":""},{"$f":"IF('BID SHEET'!B68=\"\",\"\",'BID SHEET'!B68)","v":""},{"$f":"IF('BID SHEET'!C68=\"\",\"\",'BID SHEET'!C68)","v":""},{"$f":"IF('BID SHEET'!$C68*'BID SHEET'!D68/100=0,\"\",'BID SHEET'!$C68*'BID SHEET'!D68/100)","v":""}]
[{"$f":"IF('BID SHEET'!A69=\"\",\"\",'BID SHEET'!A69)","v":""},{"$f":"IF('BID SHEET'!B69=\"\",\"\",'BID SHEET'!B69)","v":""},{"$f":"IF('BID SHEET'!C69=\"\",\"\",'BID SHEET'!C69)","v":""},{"$f":"IF('BID SHEET'!$C69*'BID SHEET'!D69/100=0,\"\",'BID SHEET'!$C69*'BID SHEET'!D69/100)","v":""}]
[{"$f":"IF('BID SHEET'!A70=\"\",\"\",'BID SHEET'!A70)","v":""},{"$f":"IF('BID SHEET'!B70=\"\",\"\",'BID SHEET'!B70)","v":""},{"$f":"IF('BID SHEET'!C70=\"\",\"\",'BID SHEET'!C70)","v":""},{"$f":"IF('BID SHEET'!$C70*'BID SHEET'!D70/100=0,\"\",'BID SHEET'!$C70*'BID SHEET'!D70/100)","v":""}]
[{"$f":"IF('BID SHEET'!A71=\"\",\"\",'BID SHEET'!A71)","v":""},{"$f":"IF('BID SHEET'!B71=\"\",\"\",'BID SHEET'!B71)","v":""},{"$f":"IF('BID SHEET'!C71=\"\",\"\",'BID SHEET'!C71)","v":""},{"$f":"IF('BID SHEET'!$C71*'BID SHEET'!D71/100=0,\"\",'BID SHEET'!$C71*'BID SHEET'!D71/100)","v":""}]
[{"$f":"IF('BID SHEET'!A72=\"\",\"\",'BID SHEET'!A72)","v":""},{"$f":"IF('BID SHEET'!B72=\"\",\"\",'BID SHEET'!B72)","v":""},{"$f":"IF('BID SHEET'!C72=\"\",\"\",'BID SHEET'!C72)","v":""},{"$f":"IF('BID SHEET'!$C72*'BID SHEET'!D72/100=0,\"\",'BID SHEET'!$C72*'BID SHEET'!D72/100)","v":""}]
[{"$f":"IF('BID SHEET'!A73=\"\",\"\",'BID SHEET'!A73)","v":""},{"$f":"IF('BID SHEET'!B73=\"\",\"\",'BID SHEET'!B73)","v":""},{"$f":"IF('BID SHEET'!C73=\"\",\"\",'BID SHEET'!C73)","v":""},{"$f":"IF('BID SHEET'!$C73*'BID SHEET'!D73/100=0,\"\",'BID SHEET'!$C73*'BID SHEET'!D73/100)","v":""}]
[{"$f":"IF('BID SHEET'!A74=\"\",\"\",'BID SHEET'!A74)","v":""},{"$f":"IF('BID SHEET'!B74=\"\",\"\",'BID SHEET'!B74)","v":""},{"$f":"IF('BID SHEET'!C74=\"\",\"\",'BID SHEET'!C74)","v":""},{"$f":"IF('BID SHEET'!$C74*'BID SHEET'!D74/100=0,\"\",'BID SHEET'!$C74*'BID SHEET'!D74/100)","v":""}]
[{"$f":"IF('BID SHEET'!A75=\"\",\"\",'BID SHEET'!A75)","v":""},{"$f":"IF('BID SHEET'!B75=\"\",\"\",'BID SHEET'!B75)","v":""},{"$f":"IF('BID SHEET'!C75=\"\",\"\",'BID SHEET'!C75)","v":""},{"$f":"IF('BID SHEET'!$C75*'BID SHEET'!D75/100=0,\"\",'BID SHEET'!$C75*'BID SHEET'!D75/100)","v":""}]
[{"$f":"IF('BID SHEET'!A76=\"\",\"\",'BID SHEET'!A76)","v":""},{"$f":"IF('BID SHEET'!B76=\"\",\"\",'BID SHEET'!B76)","v":""},{"$f":"IF('BID SHEET'!C76=\"\",\"\",'BID SHEET'!C76)","v":""},{"$f":"IF('BID SHEET'!$C76*'BID SHEET'!D76/100=0,\"\",'BID SHEET'!$C76*'BID SHEET'!D76/100)","v":""}]
[{"$f":"IF('BID SHEET'!A77=\"\",\"\",'BID SHEET'!A77)","v":""},{"$f":"IF('BID SHEET'!B77=\"\",\"\",'BID SHEET'!B77)","v":""},{"$f":"IF('BID SHEET'!C77=\"\",\"\",'BID SHEET'!C77)","v":""},{"$f":"IF('BID SHEET'!$C77*'BID SHEET'!D77/100=0,\"\",'BID SHEET'!$C77*'BID SHEET'!D77/100)","v":""}]
[{"$f":"IF('BID SHEET'!A78=\"\",\"\",'BID SHEET'!A78)","v":""},{"$f":"IF('BID SHEET'!B78=\"\",\"\",'BID SHEET'!B78)","v":""},{"$f":"IF('BID SHEET'!C78=\"\",\"\",'BID SHEET'!C78)","v":""},{"$f":"IF('BID SHEET'!$C78*'BID SHEET'!D78/100=0,\"\",'BID SHEET'!$C78*'BID SHEET'!D78/100)","v":""}]
[{"$f":"IF('BID SHEET'!A79=\"\",\"\",'BID SHEET'!A79)","v":""},{"$f":"IF('BID SHEET'!B79=\"\",\"\",'BID SHEET'!B79)","v":""},{"$f":"IF('BID SHEET'!C79=\"\",\"\",'BID SHEET'!C79)","v":""},{"$f":"IF('BID SHEET'!$C79*'BID SHEET'!D79/100=0,\"\",'BID SHEET'!$C79*'BID SHEET'!D79/100)","v":""}]
[{"$f":"IF('BID SHEET'!A80=\"\",\"\",'BID SHEET'!A80)","v":""},{"$f":"IF('BID SHEET'!B80=\"\",\"\",'BID SHEET'!B80)","v":""},{"$f":"IF('BID SHEET'!C80=\"\",\"\",'BID SHEET'!C80)","v":""},{"$f":"IF('BID SHEET'!$C80*'BID SHEET'!D80/100=0,\"\",'BID SHEET'!$C80*'BID SHEET'!D80/100)","v":""}]
[{"$f":"IF('BID SHEET'!A81=\"\",\"\",'BID SHEET'!A81)","v":""},{"$f":"IF('BID SHEET'!B81=\"\",\"\",'BID SHEET'!B81)","v":""},{"$f":"IF('BID SHEET'!C81=\"\",\"\",'BID SHEET'!C81)","v":""},{"$f":"IF('BID SHEET'!$C81*'BID SHEET'!D81/100=0,\"\",'BID SHEET'!$C81*'BID SHEET'!D81/100)","v":""}]
[{"$f":"IF('BID SHEET'!A82=\"\",\"\",'BID SHEET'!A82)","v":""},{"$f":"IF('BID SHEET'!B82=\"\",\"\",'BID SHEET'!B82)","v":""},{"$f":"IF('BID SHEET'!C82=\"\",\"\",'BID SHEET'!C82)","v":""},{"$f":"IF('BID SHEET'!$C82*'BID SHEET'!D82/100=0,\"\",'BID SHEET'!$C82*'BID SHEET'!D82/100)","v":""}]
[{"$f":"IF('BID SHEET'!A83=\"\",\"\",'BID SHEET'!A83)","v":""},{"$f":"IF('BID SHEET'!B83=\"\",\"\",'BID SHEET'!B83)","v":""},{"$f":"IF('BID SHEET'!C83=\"\",\"\",'BID SHEET'!C83)","v":""},{"$f":"IF('BID SHEET'!$C83*'BID SHEET'!D83/100=0,\"\",'BID SHEET'!$C83*'BID SHEET'!D83/100)","v":""}]

{"sheet":"Application Form","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,0,34,15],[35,0,35,15],[31,0,31,15],[26,0,26,15],[27,0,27,15],[32,0,32,15],[33,0,33,15]]}
[]
[]
["APPLICATION FORM"]
[]
["To National Grid LNG Storage"]
[]
[1,"Name, address and registration number of applying company:"]
[]
[]
[]
[]
["(“the Applicant”)"]
[]
[2,"Applicant’s Contact Details"]
[]
["Name and Position Held:"]
["Address (if different from Company address):"]
[]
[]
[]
[]
["Telephone Number:"]
["Fax Number:"]
[]
[3,"Application"]
[]
["The Applicant wishes to Purchase and Use Storage Services for Natural Gas from National Grid LNG Storage as specified in the relevant Application Form"]
["(or such smaller quantities as may be allocated under the terms of the Uniform Network Code and the 2015 Special Storage Capacity Invitation)"]
[]
[4,"Validity of Application"]
[" "]
["The Applicant hereby applies for Storage Services from National Grid LNG Storage, which application may not be withdrawn after the relevant National"]
["Grid LNG Storage Invitation Close Date.  As soon as reasonably practicable after the National Grid LNG Special Storage Capacity  Invitation Close Date, National Grid LNG"]
["Storage will confirm to the Applicant the allocation of Special Storage Capacity. By applying for the Storage Services, the Applicant agrees to accept the provisions"]
["governing operation of Storage Services contained in the Uniform Network Code and the Special Storage Capcity 2015  Invitation. “2015 Special Storage Capacity Invitation”"]
["means National Grid LNG Storage’s enclosures dated 15th September 2015."]
[]
[]
[]
[null,"Signed on behalf of the Applicant",null,null,null,null,"______________________"]
[]
[]
[null,"Position ",null,null,null,null,"______________________"]
[]
[]
[]
[null,"Date",null,null,null,null,"______________________"]

{"sheet":"Attribution","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6]]}
[]
[]
[]
[]
[null,"Attribution of Value"]
[null,"Applicants are requested to indicate their attribution of annual value of tenders below. "]
[null,"Where applicants fail to complete this section, or where attribution is outside the"]
[null,"permitted range or does not total 100% then the default attribution will be used for"]
[null,"the purposes described in the 2015 Special  Storage Capacity Invitation, paragraph 5.9."]
[]
[null,"Capacity ","Applicants’ attribution","Permitted range","Default attribution"]
[null,"Deliverability ",0.14000000000000001,"Not less than 7%",0.14000000000000001,{"$f":"IF(OR(C12<0.07,C12>0.57),\"Attribution Error\",\"\")","v":""}]
[null,"Space ",0.51,"Not less than 25%",0.51,{"$f":"IF(OR(C13<0.25,C13>0.75),\"Attribution Error\",\"\")","v":""}]
[null,"Injectability",0.35,"Not less than 18%",0.35,{"$f":"IF(OR(C14<0.18,C14>0.65),\"Attribution Error\",\"\")","v":""}]
[null,"Total ",{"$f":"SUM(C12:C14)","v":1},null,1,{"$f":"IF(E15<>100,\"\",\"Total Does not equal 100%, please amend \")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,"NO"]

{"sheet":"Appendix One","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[12,0,12,8],[3,8,4,8],[7,8,8,8],[2,2,2,7],[3,0,8,0],[3,1,8,1],[11,0,11,8]]}
["INDICATIVE QUANTITIES AVAILABLE AND RESERVE PRICES"]
[]
["Facility","2015/16 Constrained Status","Bundled Units Available",null,null,null,null,null,"Reserve Price (pence per bundled unit)"]
["Avonmouth","Not Constrained","Stage 1:  (2 month fixed Storage Duration )",50000000,"kWh","Injectability:",4.1000000000000003E-3,"kWh/d","Stage  : 0.4203"]
[null,null,null,null,null,"Space:",1,"kWh"]
[]
[]
[null,null,"(plus any rolled over capacity)",null,null,"Deliverability:",0.55969999999999998,"kWh/d"]
[null,null,"Total",{"$f":"SUM(D4:D7)","v":50000000},"kWh","Duration:",1.97,"Days"]

{"sheet":"HowUse","index":5,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"How to use Spreadsheet"]
[]
[null,"1) Use \"BID Sheet\" to create bid via the \"Click to create BID\" button"]
[]
[null,"To successfully create  a bid the following conditions must be satisfied"]
[null,null,"a) The bid value must be greater than the reserve price"]
[null,null,"b) Each conditional bid value must be less than or equal to"]
[null,null,"the previous conditional bid or primary bid"]
[null,null,"c) For each individual bid all sites must be unique"]
[]
[null,"2) Complete sheet named \"Application Form\""]
[]
[null,"3) Complete sheet named \"Attribution\" and indicate if you require overruns"]
[null,"to be limited to low cost only"]
[]
[null,"4) Print \"BID SHEET\", \"Application Form\" and \"Attribution\" and submit to LNG "]
[null,"by tender close"]
[]
[null,"5) The other two sheets in the spreadsheet are for information only:"]
[]
[null,"Monetary Values of Bids:"]
[]
[null,"This sheet shows the values of each bid calculated from the data in the BID SHEET"]
[]
[null,"Appendix One"]
[]
[null,"This sheet shows the space and reserve price at each site"]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}