{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Offer Pack 1 Within Day Offers ","DC3A","Offer Pack 2 Day Ahead  (2)","Offer Pack 3 D-5 Offers","1","Sheet1","DC3B","DC3C"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":5,"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":"Offer Pack 1 Within Day Offers ","index":0,"n_rows":199,"n_cols":18,"rows_kept":199,"cut":false,"hidden":false,"merged":[[191,10,191,11],[192,3,192,4],[192,5,192,7],[192,8,192,9],[192,10,192,11],[193,3,193,4],[193,5,193,7],[193,8,193,9],[193,10,193,11],[191,3,191,4],[191,5,191,7],[149,3,150,15],[152,3,152,15],[154,3,157,6],[154,14,157,15],[158,3,158,15],[159,3,159,4],[159,5,159,7],[159,8,159,9],[159,10,159,11],[159,14,159,15],[154,7,157,13],[140,3,145,15],[133,3,133,4],[133,5,133,7],[133,8,133,9],[133,10,133,11],[134,3,134,4],[134,5,134,7],[134,8,134,9],[134,10,134,11],[139,3,139,4],[139,5,139,7],[139,8,139,9],[139,10,139,11],[135,3,135,4],[135,5,135,7],[135,8,135,9],[135,10,135,11],[136,3,136,4],[136,5,136,7],[136,8,136,9],[136,10,136,11],[138,3,138,4],[138,5,138,7],[138,8,138,9],[131,3,131,4],[131,5,131,7],[131,8,131,9],[131,10,131,11],[132,3,132,4],[132,5,132,7],[132,8,132,9],[132,10,132,11],[138,10,138,11],[137,3,137,4],[137,5,137,7],[137,8,137,9],[137,10,137,11],[103,2,104,2],[103,3,104,6],[103,7,104,15],[105,2,106,2],[105,3,106,6],[105,7,106,15],[109,3,110,6],[109,7,110,15],[125,3,126,4],[125,5,126,7],[125,8,126,9],[125,10,126,11],[125,12,126,12],[125,14,125,15],[123,3,123,15],[124,3,124,4],[124,5,124,7],[124,8,124,9],[124,10,124,11],[124,14,124,15],[125,13,126,13],[119,7,122,13],[108,3,108,6],[108,7,108,15],[99,2,100,2],[99,3,100,6],[99,7,100,15],[101,2,102,2],[101,3,102,6],[101,7,102,15],[92,2,96,2],[92,3,96,6],[92,7,96,15],[97,3,97,6],[97,7,97,15],[98,3,98,6],[98,7,98,15],[90,2,91,2],[90,3,91,6],[90,7,91,15],[77,3,77,6],[77,7,77,15],[78,3,78,6],[78,7,78,15],[79,2,80,2],[79,3,80,6],[79,7,80,15],[67,2,68,2],[67,3,68,6],[67,7,68,15],[69,2,70,2],[69,3,70,6],[69,7,70,15],[81,3,81,6],[81,7,81,15],[85,3,86,15],[2,3,6,15],[3,17,5,18],[8,3,11,15],[13,3,14,15],[16,3,22,15],[17,17,20,18],[39,3,45,15],[39,17,41,18],[47,3,59,15],[51,17,53,18],[162,3,162,4],[162,5,162,7],[162,8,162,9],[162,10,162,11],[62,3,63,15],[65,3,65,15],[23,17,23,18],[25,3,34,15],[25,17,27,18],[38,3,38,15],[71,3,74,6],[71,7,74,15],[75,3,75,6],[75,7,75,15],[76,3,76,6],[76,7,76,15],[88,3,88,15],[119,3,122,6],[119,14,122,15],[107,3,107,6],[107,7,107,15],[114,3,115,15],[117,3,117,15],[129,3,129,4],[163,3,163,4],[163,5,163,7],[163,8,163,9],[163,10,163,11],[164,3,164,4],[164,5,164,7],[164,8,164,9],[164,10,164,11],[165,3,165,4],[165,5,165,7],[165,8,165,9],[165,10,165,11],[166,3,166,4],[166,5,166,7],[166,8,166,9],[166,10,166,11],[167,3,167,4],[167,5,167,7],[167,8,167,9],[167,10,167,11],[168,3,168,4],[168,5,168,7],[168,8,168,9],[168,10,168,11],[172,3,172,4],[172,5,172,7],[172,8,172,9],[172,10,172,11],[169,3,169,4],[169,5,169,7],[169,8,169,9],[169,10,169,11],[170,3,170,4],[170,5,170,7],[170,8,170,9],[170,10,170,11],[171,3,171,4],[171,5,171,7],[171,8,171,9],[171,10,171,11],[198,3,198,4],[198,5,198,7],[198,8,198,9],[198,10,198,11],[194,3,194,4],[194,5,194,7],[194,8,194,9],[194,10,194,11],[195,3,195,4],[195,5,195,7],[195,8,195,9],[195,10,195,11],[196,3,196,4],[196,5,196,7],[196,8,196,9],[196,10,196,11],[175,3,176,15],[178,3,178,15],[180,2,183,2],[180,3,183,6],[180,7,183,13],[180,14,183,15],[184,3,184,15],[197,3,197,4],[197,5,197,7],[197,8,197,9],[197,10,197,11],[188,3,188,4],[188,5,188,7],[188,8,188,9],[188,10,188,11],[189,3,189,4],[189,5,189,7],[189,8,189,9],[189,10,189,11],[190,3,190,4],[190,5,190,7],[190,8,190,9],[190,10,190,11],[191,8,191,9],[154,2,157,2],[160,3,161,4],[160,5,161,7],[160,8,161,9],[160,10,161,11],[160,12,161,12],[160,13,161,13],[160,14,160,15],[119,2,122,2],[129,5,129,7],[129,8,129,9],[129,10,129,11],[130,3,130,4],[130,5,130,7],[130,8,130,9],[130,10,130,11],[127,3,127,4],[127,5,127,7],[127,8,127,9],[127,10,127,11],[128,3,128,4],[128,5,128,7],[128,8,128,9],[128,10,128,11],[185,3,185,4],[185,5,185,7],[185,8,185,9],[185,10,185,11],[185,14,185,15],[186,3,187,4],[186,5,187,7],[186,8,187,9],[186,10,187,11],[186,12,187,12],[186,13,187,13],[186,14,186,15]]}
[]
[]
[null,null,null,"OFFER PACK 1\nGAS DSR\nWITHIN DAY OPTION OFFERS"]
[]
[]
[]
[]
[]
[null,null,null,"This offer pack is designed for:\n• Users (shippers who have consumers at offtake points) to submit Within Day DSR Option Offers for the current Winter Period and/or the subsequent two Winter Periods.\n"]
[]
[]
[]
[]
[null,null,null,"Issued 18th November 2022"]
[]
[]
[null,null,null,"Produced by National Grid Gas Transmission  \nNational Grid Gas plc\nNational Grid House\nWarwick Technology Park\nGallows Hill\nWarwick\nCV34 6DA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"PLEASE NOTE:\n\nThis document should be read in conjunction with the Invitation to Offer guidance document on the website link below:\n\nhttps://www.nationalgrid.com/gas-transmission/balancing/demand-side-response-dsr  \n\n\nTerms and phrases used in this document have the meanings set out or referred to in this template have been set out in the Offer Guidance Document. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1"]
[]
[]
[null,null,null,"IMPORTANT INFORMATION - PLEASE READ:"]
[null,null,null,"All parts of \"Within Day Offers\" must be completed to be eligible for selection of Within Day Offers.\n\nThe Winter Period is defined in the Uniform Network Code General Terms C.2.2.1.h as the period from 1st November in any year until the 30th April in the following year. \n\nThe Winter Period for 2022/23 Option Offer will be calculated from the day on which the DSR option offer is accepted until 30th April 2023.\n\nPlease submit one offer pack per consumer \n"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Completed Offers should be submitted by 12:00 hours (GMT) on 9th December 2022 via email to Brendan.Mullan@nationalgrid.com and cc Andrea.Godden@nationalgrid.com\n\nThe completed Offer Pack should be submitted with a filename which includes the company name and site.\nSubmissions can be revised up to and including the deadline date."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DSR WITHIN DAY OPTION OFFERS"]
[]
[]
[null,null,null,"Part 1: Shippers Details"]
[]
[null,null,1,"User company Name\n(including company number)"]
[]
[null,null,2,"User Representative, Job Title"]
[]
[null,null,3,"User Representative Address\n(full address including postcode)"]
[]
[]
[]
[null,null,4,"User Telephone Number"]
[null,null,5,"User Out of hours Telephone Number"]
[null,null,6,"User Email Address"]
[null,null,7,"User Legal Agent Name (if applicable)"]
[null,null,8,"User Legal Agent Address (if applicable)"]
[]
[null,null,9,"Shipper Short Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3"]
[]
[]
[null,null,null,"DSR WITHIN DAY OPTION OFFERS"]
[]
[]
[null,null,null,"Part 2: Consumer Details"]
[]
[null,null,10,"Consumer Name\n(including company number)"]
[]
[null,null,11,"Consumer Location\n(full address including postcode)\n"]
[]
[]
[]
[]
[null,null,12,"Type of Business"]
[null,null,13,"If other, please specify"]
[null,null,14,"Annual Quantity Therms or kWh (specify the unit of measure)"]
[]
[null,null,15,"Gemini Meter ID"]
[]
[null,null,16,"Multi Year Offer"]
[]
[null,null,17,"If yes, how many additional years?"]
[]
[null,null,18,"How will the demand reduction be delivered? "]
[null,null,19,"If the consumer has the capability to switch to back-up fuel, what type of fuel it is  (free text)"]
[null,null,20,"Website for Service Availability / Unavailability"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4"]
[]
[]
[null,null,null,"2022/23 DSR WITHIN DAY OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"**Winter Period Number of Days \n11th January to 30th April 2023 ","Total Option Fee 11th January 2023 to 30th April 2023 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,"Example ",null,150000,null,null,6,null,3,null,104,{"$f":"F128*K128*M128/100","v":468000},null," D-1 SAP *1.1"]
[null,null,null,"Example ",null,100000,null,null,6,null,4.0999999999999996,null,104,{"$f":"F129*K129*M129/100","v":426399.99999999994},11.65]
[null,null,null,1,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,2,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,3,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,104,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N130:N139)","v":0}]
[null,null,null,"** The number of days figure is based on the offer starting on the 11th January 2023\n\nWorked example of Option Fee for 2022/23\n                                             \nReduction Quantity (Minimum 100,000 kWh/d) = 150,000                                                   Total Option Fee = Reduction Quantity x option price  \n                                                                                                                                       (150,000 X 3.0p ) x Number of days (104)  = £468,000\nOption Price (pence/kWh/d)  = 3.0p\nNumber of days in Winter Period = 104\n\n                                                       "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2023/24 DSR WITHIN DAY OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November  2023 to 30th April 2024 ","Total Option Fee   Ist November 2023 to 30th April 2024 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,182,{"$f":"F163*K163*M163/100","v":0},0," D-1 SAP *1.1"]
[null,null,null,2,null,0,null,null,0,null,0,null,182,{"$f":"F164*K164*M164/100","v":0},0]
[null,null,null,3,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N163:N172)","v":0}]
[]
[]
[null,null,null,"2024/25 DSR WITHIN DAY OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November 2024 to 30th April 2025 ","Total Option Fee   Ist November 2024 to 30th April 2025 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,181,{"$f":"F189*K189*M189/100","v":0},0," D-1 SAP *1.1"]
[null,null,null,2,null,0,null,null,0,null,0,null,181,{"$f":"F190*K190*M190/100","v":0},0]
[null,null,null,3,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N189:N198)","v":0}]

{"sheet":"DC3A","index":1,"n_rows":4,"n_cols":41,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,2,1,9]]}
[null,null,"Data Collection Tab for Contracts Team"]
[]
["Tender Pack","Tender Ref","Tranche Ref","Main Ref",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Winter Only?",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"A4&\".\"&B4&\".\"&C4","v":".."},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,\"12\",IF(#REF!=2,\"24\",\"UNCHECKED\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"N\",\"Y\")","v":{"$error":"#REF!"}}]

{"sheet":"Offer Pack 2 Day Ahead  (2)","index":2,"n_rows":400,"n_cols":16,"rows_kept":400,"cut":false,"hidden":false,"merged":[[399,3,399,4],[399,5,399,7],[399,8,399,9],[399,10,399,11],[400,3,400,14],[397,3,397,4],[397,5,397,7],[397,8,397,9],[397,10,397,11],[398,3,398,4],[398,5,398,7],[398,8,398,9],[398,10,398,11],[395,3,395,4],[395,5,395,7],[395,8,395,9],[395,10,395,11],[396,3,396,4],[396,5,396,7],[396,8,396,9],[396,10,396,11],[393,3,393,4],[393,5,393,7],[393,8,393,9],[393,10,393,11],[394,3,394,4],[394,5,394,7],[394,8,394,9],[394,10,394,11],[391,3,391,4],[391,5,391,7],[391,8,391,9],[391,10,391,11],[392,3,392,4],[392,5,392,7],[392,8,392,9],[392,10,392,11],[389,3,389,4],[389,5,389,7],[389,8,389,9],[389,10,389,11],[390,3,390,4],[390,5,390,7],[390,8,390,9],[390,10,390,11],[387,3,388,4],[387,5,388,7],[387,8,388,9],[387,10,388,11],[387,12,388,12],[387,13,387,14],[381,2,384,2],[381,3,384,6],[381,7,384,12],[381,13,384,14],[385,3,385,14],[386,3,386,4],[386,5,386,7],[386,8,386,9],[386,10,386,11],[386,13,386,14],[374,3,374,14],[376,2,378,2],[376,3,378,6],[376,7,378,12],[376,13,378,14],[379,2,380,2],[379,3,380,6],[379,7,380,12],[379,13,380,14],[367,3,367,4],[367,5,367,7],[367,8,367,9],[367,10,367,11],[368,3,368,14],[371,3,372,14],[365,3,365,4],[365,5,365,7],[365,8,365,9],[365,10,365,11],[366,3,366,4],[366,5,366,7],[366,8,366,9],[366,10,366,11],[363,3,363,4],[363,5,363,7],[363,8,363,9],[363,10,363,11],[364,3,364,4],[364,5,364,7],[364,8,364,9],[364,10,364,11],[361,3,361,4],[361,5,361,7],[361,8,361,9],[361,10,361,11],[362,3,362,4],[362,5,362,7],[362,8,362,9],[362,10,362,11],[359,3,359,4],[359,5,359,7],[359,8,359,9],[359,10,359,11],[360,3,360,4],[360,5,360,7],[360,8,360,9],[360,10,360,11],[357,3,357,4],[357,5,357,7],[357,8,357,9],[357,10,357,11],[358,3,358,4],[358,5,358,7],[358,8,358,9],[358,10,358,11],[355,3,356,4],[355,5,356,7],[355,8,356,9],[355,10,356,11],[355,12,356,12],[355,13,355,14],[353,3,353,14],[354,3,354,4],[354,5,354,7],[354,8,354,9],[354,10,354,11],[354,13,354,14],[347,2,348,2],[347,3,348,6],[347,7,348,12],[347,13,348,14],[349,2,352,2],[349,3,352,6],[349,7,352,12],[349,13,352,14],[333,2,336,15],[339,3,340,14],[342,3,342,14],[344,2,346,2],[344,3,346,6],[344,7,346,12],[344,13,346,14],[331,3,331,4],[331,5,331,7],[331,8,331,9],[331,10,331,11],[332,3,332,4],[332,5,332,7],[332,8,332,9],[332,10,332,11],[196,3,196,4],[196,5,196,7],[196,8,196,9],[196,10,196,11],[330,3,330,4],[330,5,330,7],[330,8,330,9],[330,10,330,11],[194,3,194,4],[194,5,194,7],[194,8,194,9],[194,10,194,11],[195,3,195,4],[195,5,195,7],[195,8,195,9],[195,10,195,11],[192,3,192,4],[192,5,192,7],[192,8,192,9],[192,10,192,11],[193,3,193,4],[193,5,193,7],[193,8,193,9],[193,10,193,11],[190,3,190,4],[190,5,190,7],[190,8,190,9],[190,10,190,11],[191,3,191,4],[191,5,191,7],[191,8,191,9],[191,10,191,11],[188,3,188,4],[188,5,188,7],[188,8,188,9],[188,10,188,11],[189,3,189,4],[189,5,189,7],[189,8,189,9],[189,10,189,11],[184,14,184,15],[186,3,186,4],[186,5,186,7],[186,8,186,9],[186,10,186,11],[187,3,187,4],[187,5,187,7],[187,8,187,9],[187,10,187,11],[184,3,185,4],[184,5,185,7],[184,8,185,9],[184,10,185,11],[184,12,185,12],[184,13,185,13],[182,3,182,15],[183,3,183,4],[183,5,183,7],[183,8,183,9],[183,10,183,11],[183,14,183,15],[173,3,174,15],[176,3,176,15],[178,2,181,2],[178,3,181,6],[178,7,181,13],[178,14,181,15],[169,3,169,4],[169,5,169,7],[169,8,169,9],[169,10,169,11],[170,3,170,4],[170,5,170,7],[170,8,170,9],[170,10,170,11],[167,3,167,4],[167,5,167,7],[167,8,167,9],[167,10,167,11],[168,3,168,4],[168,5,168,7],[168,8,168,9],[168,10,168,11],[165,3,165,4],[165,5,165,7],[165,8,165,9],[165,10,165,11],[166,3,166,4],[166,5,166,7],[166,8,166,9],[166,10,166,11],[163,3,163,4],[163,5,163,7],[163,8,163,9],[163,10,163,11],[164,3,164,4],[164,5,164,7],[164,8,164,9],[164,10,164,11],[161,3,161,4],[161,5,161,7],[161,8,161,9],[161,10,161,11],[162,3,162,4],[162,5,162,7],[162,8,162,9],[162,10,162,11],[158,13,159,13],[158,14,158,15],[160,3,160,4],[160,5,160,7],[160,8,160,9],[160,10,160,11],[157,3,157,4],[157,5,157,7],[157,8,157,9],[157,10,157,11],[157,14,157,15],[158,3,159,4],[158,5,159,7],[158,8,159,9],[158,10,159,11],[158,12,159,12],[150,3,150,15],[152,2,155,2],[152,3,155,6],[152,7,155,13],[152,14,155,15],[156,3,156,15],[138,3,138,4],[138,5,138,7],[138,8,138,9],[138,10,138,11],[139,3,144,15],[147,3,148,15],[136,3,136,4],[136,5,136,7],[136,8,136,9],[136,10,136,11],[137,3,137,4],[137,5,137,7],[137,8,137,9],[137,10,137,11],[134,3,134,4],[134,5,134,7],[134,8,134,9],[134,10,134,11],[135,3,135,4],[135,5,135,7],[135,8,135,9],[135,10,135,11],[132,3,132,4],[132,5,132,7],[132,8,132,9],[132,10,132,11],[133,3,133,4],[133,5,133,7],[133,8,133,9],[133,10,133,11],[130,3,130,4],[130,5,130,7],[130,8,130,9],[130,10,130,11],[131,3,131,4],[131,5,131,7],[131,8,131,9],[131,10,131,11],[128,3,128,4],[128,5,128,7],[128,8,128,9],[128,10,128,11],[129,3,129,4],[129,5,129,7],[129,8,129,9],[129,10,129,11],[124,14,124,15],[126,3,126,4],[126,5,126,7],[126,8,126,9],[126,10,126,11],[127,3,127,4],[127,5,127,7],[127,8,127,9],[127,10,127,11],[124,3,125,4],[124,5,125,7],[124,8,125,9],[124,10,125,11],[124,12,125,12],[124,13,125,13],[122,3,122,15],[123,3,123,4],[123,5,123,7],[123,8,123,9],[123,10,123,11],[123,14,123,15],[113,3,114,15],[116,3,116,15],[118,2,121,2],[118,3,121,6],[118,7,121,13],[118,14,121,15],[107,3,107,6],[107,7,107,15],[108,3,108,6],[108,7,108,15],[109,3,110,6],[109,7,110,15],[103,2,104,2],[103,3,104,6],[103,7,104,15],[105,2,106,2],[105,3,106,6],[105,7,106,15],[98,3,98,6],[98,7,98,15],[99,2,100,2],[99,3,100,6],[99,7,100,15],[101,2,102,2],[101,3,102,6],[101,7,102,15],[91,16,93,16],[92,2,96,2],[92,3,96,6],[92,7,96,15],[97,3,97,6],[97,7,97,15],[82,3,82,6],[82,7,82,14],[85,3,86,15],[88,3,88,15],[90,2,91,2],[90,3,91,6],[90,7,91,15],[78,3,78,6],[78,7,78,14],[79,3,79,6],[79,7,79,14],[80,2,81,2],[80,3,81,6],[80,7,81,14],[72,3,75,6],[72,7,75,14],[76,3,76,6],[76,7,76,14],[77,3,77,6],[77,7,77,14],[63,3,64,14],[66,3,66,14],[68,2,69,2],[68,3,69,6],[68,7,69,14],[70,2,71,2],[70,3,71,6],[70,7,71,14],[24,3,33,14],[24,16,26,16],[37,3,37,14],[38,3,44,14],[38,16,40,16],[47,3,59,14],[51,16,53,16],[1,3,5,14],[2,16,4,16],[7,3,10,14],[12,3,13,14],[15,3,21,14],[16,16,19,16]]}
[]
[null,null,null,"OFFER PACK 2\nGAS DSR   \nDAY AHEAD OPTION OFFERS"]
[]
[]
[]
[]
[]
[null,null,null,"This offer pack is designed for:\n Users (shippers who have consumers at offtake points) to submit Day Ahead DSR Offers for upcoming Winter Period and/or the subsequent two Winter Periods.\n"]
[]
[]
[]
[]
[null,null,null,"Issued 18th November 2022"]
[]
[]
[null,null,null,"Produced by National Grid Gas Transmission  \nNational Grid Gas plc\nNational Grid House\nWarwick Technology Park\nGallows Hill\nWarwick\nCV34 6DA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"PLEASE NOTE:\n\nThis document should be read in conjunction with the Invitation to Offer guidance document on the website link below:\nhttps://www.nationalgrid.com/gas-transmission/balancing/demand-side-response-dsr \n\n\nTerms and phrases used in this document have the meanings set out or referred to in this template have been set out in the Offer Guidance Document. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"IMPORTANT INFORMATION - PLEASE READ:"]
[null,null,null,"All parts of \"Day Ahead Offers\" must be completed to be eligible for selection of Day Ahead Offers.\n\nThe Winter Period is defined in the Uniform Network Code General Terms C.2.2.1 h has the period from 1st November in any year until the 30th April in the following year. \n\nSection 24 Lead Times is greyed out for Day Ahead Offers as they are not required.\n \nThe Winter Period  for 22/23 option Offer is defined and will be  calculated from the first day the DSR offer is accepted till the 30th April 2023\n\nPlease submit one offer pack per consumer."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Completed Offers should be submitted by 12:00 hours (GMT) on 9th December 2022 via email to Brendan.Mullan@nationalgrid.com and cc Andrea.Godden@nationalgrid.com\n\nThe completed Offer Pack should be submitted with a filename which includes the company name and site.\nSubmissions can be revised up to and including the deadline date."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DSR DAY AHEAD OPTION OFFERS"]
[]
[]
[null,null,null,"Part 1: Shipper Details"]
[]
[null,null,1,"User company Name\n(including company number)"]
[]
[null,null,2,"User Representative, Job Title"]
[]
[null,null,3,"User Representative Address\n(full address including postcode)"]
[]
[]
[]
[null,null,4,"User Telephone Number"]
[null,null,5,"User Out of hours Telephone Number"]
[null,null,6,"User Email Address"]
[null,null,7,"User Legal Agent Name (if applicable)"]
[null,null,8,"User Legal Agent Address (if applicable)"]
[]
[null,null,9,"Shipper Short Code"]
[]
[]
[null,null,null,"DSR DAY AHEAD OPTION OFFERS"]
[]
[]
[null,null,null,"Part 2: Consumer Details"]
[]
[null,null,10,"Consumer Name\n(including company number)"]
[]
[null,null,11,"Consumer Location\n(full address including postcode)\n"]
[]
[]
[]
[]
[null,null,12,"Type of Business"]
[null,null,13,"If other, please specify"]
[null,null,14,"Annual Quantity Therms or kWh (specify the unit of measure)"]
[]
[null,null,15,"Gemini Meter ID"]
[]
[null,null,16,"Multi Year Offer"]
[]
[null,null,17,"If yes, how many additional years?"]
[]
[null,null,18,"How will the demand reduction be delivered?"]
[null,null,19,"If the consumer has the capability to switch to back-up fuel, what type of fuel it is (free text)"]
[null,null,20,"Website for Service Availability / Unavailability"]
[]
[]
[]
[null,null,null,"2022/23 DSR DAY AHEAD OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"**Winter Period Number of Days \n11th January to 30th April 2023 ","Total Option Fee 11th January 2023 to 30th April 2023 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,"Example ",null,150000,null,null,null,null,3,null,104,{"$f":"F127*K127*M127/100","v":468000},null," D-1 SAP *1.1"]
[null,null,null,"Example ",null,100000,null,null,null,null,4.0999999999999996,null,104,{"$f":"F128*K128*M128/100","v":426399.99999999994},11.65]
[null,null,null,1,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,2,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,3,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,4,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,5,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,6,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,7,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,8,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,9,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,10,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N129:N138)","v":0}]
[null,null,null,"** The number of days figure is based on the offer starting on the 11th January 2023\n\nWorked example of Option Fee for 2022/23\n                                             \nReduction Quantity (Minimum 100,000 kWh/d) = 150,000                                                   Total Option Fee = Reduction Quantity x option price  \n                                                                                                                                       (150,000 X 3.0p ) x Number of days (104)  = £468,000.00\nOption Price (pence/kWh/d)  = 3.0p\nNumber of days in Winter Period = 104\n\n                                                       "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2023/24 DSR DAY AHEAD OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November  2023 to 30th April 2024 ","Total Option Fee   Ist November 2023 to 30th April 2024 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,182,{"$f":"F161*K161*M161/100","v":0},0," D-1 SAP *1.1"]
[null,null,null,2,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,3,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N161:N170)","v":0}]
[]
[]
[null,null,null,"2024/25 DSR DAY AHEAD OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November 2024 to 30th April 2025 ","Total Option Fee   Ist November 2024 to 30th April 2025 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,181,{"$f":"F187*K187*M187/100","v":0},0]
[null,null,null,2,null,0,null,null,0,null,0,null,181,{"$f":"F188*K188*M188/100","v":0},0]
[null,null,null,3,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N187:N196)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,7,null,null,null,null,null,null,null,null,{"$f":"(F331*K331)/100*(181/365)","v":0}]
[null,null,null,8,null,null,null,null,null,null,null,null,{"$f":"(F332*K332)/100*(181/365)","v":0}]
[null,null,null,"Total",null,{"$f":"SUM(F105:G332)","v":250069}]
[null,null,"**    Where a User offers an exercise price that is indexed in accordance with BR 4(f)(ii), National Grid NTS shall \ndetermine such price for the purposes of its assessment as being the forward price for the relevant winter \nas published in the Argus European Natural Gas Report on the day the invitation to offer closes, provided \nthat for any such offers submitted in the first invitation to offer for Winter Period 2022/23, the ‘Winter 2022’\ncontract will no longer be available, therefore the Q1 2023 price quoted in such report shall be used. "]
[]
[]
[]
[]
[]
[null,null,null,"2023/24 DSR DAY AHEAD OFFERS"]
[]
[]
[null,null,null,"Part 3: Deliverability & Availability"]
[]
[null,null,20,"Minimum Reduction Quantity Offered (100,000 kWh/d)",null,null,null,null,null,null,null,null,null,"kWh/day"]
[]
[]
[null,null,21,"Lead Time",null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,22,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,23,null,24,null,null,25,null,26,null,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity (in kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price / Service Fee (pence/kWh/d)",null,"Number of Days","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column N or O not both"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to SAP"]
[null,null,null,1,null,null,null,null,null,null,null,null,182]
[null,null,null,2,null,null,null,null,null,null,null,null,0]
[null,null,null,3,null,null,null,null,null,null,null,null,0]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"(F361*K361)/100*(181/365)","v":0}]
[null,null,null,5,null,null,null,null,null,null,null,null,0]
[null,null,null,6,null,null,null,null,null,null,null,null,0]
[null,null,null,7,null,null,null,null,null,null,null,null,0]
[null,null,null,8,null,null,null,null,null,null,null,null,0]
[null,null,null,9,null,null,null,null,null,null,null,null,0]
[null,null,null,10,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,{"$f":"SUM(F358:G367)","v":0}]
[]
[]
[]
[null,null,null,"2024/25 DSR DAY AHEAD OFFERS"]
[]
[]
[null,null,null,"Part 3: Deliverability & Availability"]
[]
[null,null,20,"Minimum Reduction Quantity Offered (100,000 kWh/d)",null,null,null,null,null,null,null,null,null,"kWh/day"]
[]
[]
[null,null,21,"Lead Time",null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,22,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,23,null,24,null,null,25,null,26,null,27,28]
[null,null,null,"DSR  Tranche Number",null,"Reduction Quantity (in kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price / Service Fee (pence/kWh/d)",null,"Number of Days","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column N or O not both"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to SAP"]
[null,null,null,1,null,null,null,null,null,null,null,null,0]
[null,null,null,2,null,null,null,null,null,null,null,null,0]
[null,null,null,3,null,null,null,null,null,null,null,null,0]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"(F393*K393)/100*(181/365)","v":0}]
[null,null,null,5,null,null,null,null,null,null,null,null,0]
[null,null,null,6,null,null,null,null,null,null,null,null,0]
[null,null,null,7,null,null,null,null,null,null,null,null,0]
[null,null,null,8,null,null,null,null,null,null,null,null,0]
[null,null,null,9,null,null,null,null,null,null,null,null,0]
[null,null,null,10,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,{"$f":"SUM(F390:G399)","v":0}]

{"sheet":"Offer Pack 3 D-5 Offers","index":3,"n_rows":400,"n_cols":16,"rows_kept":400,"cut":false,"hidden":false,"merged":[[91,16,93,16],[85,3,86,15],[88,3,88,15],[90,3,91,6],[90,7,91,15],[90,2,91,2],[109,3,110,6],[109,7,110,15],[333,2,336,15],[332,3,332,4],[332,5,332,7],[332,8,332,9],[332,10,332,11],[330,3,330,4],[330,5,330,7],[330,8,330,9],[330,10,330,11],[331,3,331,4],[331,5,331,7],[331,8,331,9],[331,10,331,11],[99,2,100,2],[99,3,100,6],[101,2,102,2],[101,3,102,6],[92,2,96,2],[92,3,96,6],[97,3,97,6],[98,3,98,6],[92,7,96,15],[97,7,97,15],[98,7,98,15],[99,7,100,15],[101,7,102,15],[82,3,82,6],[82,7,82,14],[78,3,78,6],[78,7,78,14],[79,3,79,6],[79,7,79,14],[80,2,81,2],[80,3,81,6],[80,7,81,14],[76,7,76,14],[77,3,77,6],[77,7,77,14],[68,2,69,2],[68,3,69,6],[68,7,69,14],[70,2,71,2],[70,3,71,6],[70,7,71,14],[1,3,5,14],[2,16,4,16],[7,3,10,14],[12,3,13,14],[15,3,21,14],[16,16,19,16],[339,3,340,14],[342,3,342,14],[344,2,346,2],[344,3,346,6],[344,7,346,12],[344,13,346,14],[38,3,44,14],[38,16,40,16],[47,3,59,14],[51,16,53,16],[63,3,64,14],[66,3,66,14],[24,3,33,14],[24,16,26,16],[37,3,37,14],[72,3,75,6],[72,7,75,14],[76,3,76,6],[347,2,348,2],[347,3,348,6],[347,7,348,12],[347,13,348,14],[349,2,352,2],[349,3,352,6],[349,7,352,12],[349,13,352,14],[353,3,353,14],[354,3,354,4],[354,5,354,7],[354,8,354,9],[354,10,354,11],[354,13,354,14],[355,3,356,4],[355,5,356,7],[355,8,356,9],[355,10,356,11],[355,12,356,12],[355,13,355,14],[357,3,357,4],[357,5,357,7],[357,8,357,9],[357,10,357,11],[358,3,358,4],[358,5,358,7],[358,8,358,9],[358,10,358,11],[359,3,359,4],[359,5,359,7],[359,8,359,9],[359,10,359,11],[360,3,360,4],[360,5,360,7],[360,8,360,9],[360,10,360,11],[361,3,361,4],[361,5,361,7],[361,8,361,9],[361,10,361,11],[362,3,362,4],[362,5,362,7],[362,8,362,9],[362,10,362,11],[363,3,363,4],[363,5,363,7],[363,8,363,9],[363,10,363,11],[364,3,364,4],[364,5,364,7],[364,8,364,9],[364,10,364,11],[365,3,365,4],[365,5,365,7],[365,8,365,9],[365,10,365,11],[366,3,366,4],[366,5,366,7],[366,8,366,9],[366,10,366,11],[367,3,367,4],[367,5,367,7],[367,8,367,9],[367,10,367,11],[368,3,368,14],[371,3,372,14],[374,3,374,14],[376,2,378,2],[376,3,378,6],[376,7,378,12],[376,13,378,14],[379,2,380,2],[379,3,380,6],[379,7,380,12],[379,13,380,14],[381,2,384,2],[381,3,384,6],[381,7,384,12],[381,13,384,14],[385,3,385,14],[386,3,386,4],[386,5,386,7],[386,8,386,9],[386,10,386,11],[386,13,386,14],[387,3,388,4],[387,5,388,7],[387,8,388,9],[387,10,388,11],[387,12,388,12],[387,13,387,14],[389,3,389,4],[389,5,389,7],[389,8,389,9],[389,10,389,11],[390,3,390,4],[390,5,390,7],[390,8,390,9],[390,10,390,11],[391,3,391,4],[391,5,391,7],[391,8,391,9],[391,10,391,11],[392,3,392,4],[392,5,392,7],[392,8,392,9],[392,10,392,11],[393,3,393,4],[393,5,393,7],[393,8,393,9],[393,10,393,11],[394,3,394,4],[394,5,394,7],[394,8,394,9],[394,10,394,11],[395,3,395,4],[395,5,395,7],[395,8,395,9],[395,10,395,11],[399,3,399,4],[399,5,399,7],[399,8,399,9],[399,10,399,11],[400,3,400,14],[396,3,396,4],[396,5,396,7],[396,8,396,9],[396,10,396,11],[397,3,397,4],[397,5,397,7],[397,8,397,9],[397,10,397,11],[398,3,398,4],[398,5,398,7],[398,8,398,9],[398,10,398,11],[139,3,144,15],[147,3,148,15],[103,2,104,2],[103,3,104,6],[103,7,104,15],[105,2,106,2],[105,3,106,6],[105,7,106,15],[107,3,107,6],[107,7,107,15],[108,3,108,6],[108,7,108,15],[113,3,114,15],[116,3,116,15],[118,2,121,2],[118,3,121,6],[118,7,121,13],[118,14,121,15],[138,3,138,4],[138,5,138,7],[138,8,138,9],[138,10,138,11],[122,3,122,15],[123,3,123,4],[123,5,123,7],[123,8,123,9],[123,10,123,11],[123,14,123,15],[124,3,125,4],[124,5,125,7],[124,8,125,9],[124,10,125,11],[124,12,125,12],[124,13,125,13],[124,14,124,15],[126,3,126,4],[126,5,126,7],[126,8,126,9],[126,10,126,11],[127,3,127,4],[127,5,127,7],[127,8,127,9],[127,10,127,11],[128,3,128,4],[128,5,128,7],[128,8,128,9],[128,10,128,11],[129,3,129,4],[129,5,129,7],[129,8,129,9],[129,10,129,11],[130,3,130,4],[130,5,130,7],[130,8,130,9],[130,10,130,11],[131,3,131,4],[131,5,131,7],[131,8,131,9],[131,10,131,11],[132,3,132,4],[132,5,132,7],[132,8,132,9],[132,10,132,11],[133,3,133,4],[133,5,133,7],[133,8,133,9],[133,10,133,11],[134,3,134,4],[134,5,134,7],[134,8,134,9],[134,10,134,11],[135,3,135,4],[135,5,135,7],[135,8,135,9],[135,10,135,11],[136,3,136,4],[136,5,136,7],[136,8,136,9],[136,10,136,11],[137,3,137,4],[137,5,137,7],[137,8,137,9],[137,10,137,11],[150,3,150,15],[152,2,155,2],[152,3,155,6],[152,7,155,13],[152,14,155,15],[156,3,156,15],[157,3,157,4],[157,5,157,7],[157,8,157,9],[157,10,157,11],[157,14,157,15],[158,3,159,4],[158,5,159,7],[158,8,159,9],[158,10,159,11],[158,12,159,12],[158,13,159,13],[158,14,158,15],[160,3,160,4],[160,5,160,7],[160,8,160,9],[160,10,160,11],[161,3,161,4],[161,5,161,7],[161,8,161,9],[161,10,161,11],[162,3,162,4],[162,5,162,7],[162,8,162,9],[162,10,162,11],[163,3,163,4],[163,5,163,7],[163,8,163,9],[163,10,163,11],[164,3,164,4],[164,5,164,7],[164,8,164,9],[164,10,164,11],[165,3,165,4],[165,5,165,7],[165,8,165,9],[165,10,165,11],[166,3,166,4],[166,5,166,7],[166,8,166,9],[166,10,166,11],[167,3,167,4],[167,5,167,7],[167,8,167,9],[167,10,167,11],[168,3,168,4],[168,5,168,7],[168,8,168,9],[168,10,168,11],[169,3,169,4],[169,5,169,7],[169,8,169,9],[169,10,169,11],[170,3,170,4],[170,5,170,7],[170,8,170,9],[170,10,170,11],[173,3,174,15],[176,3,176,15],[178,2,181,2],[178,3,181,6],[178,7,181,13],[178,14,181,15],[182,3,182,15],[183,3,183,4],[183,5,183,7],[183,8,183,9],[183,10,183,11],[183,14,183,15],[184,3,185,4],[184,5,185,7],[184,8,185,9],[184,10,185,11],[184,12,185,12],[184,13,185,13],[184,14,184,15],[186,3,186,4],[186,5,186,7],[186,8,186,9],[186,10,186,11],[187,3,187,4],[187,5,187,7],[187,8,187,9],[187,10,187,11],[188,3,188,4],[188,5,188,7],[188,8,188,9],[188,10,188,11],[189,3,189,4],[189,5,189,7],[189,8,189,9],[189,10,189,11],[190,3,190,4],[190,5,190,7],[190,8,190,9],[190,10,190,11],[191,3,191,4],[191,5,191,7],[191,8,191,9],[191,10,191,11],[195,3,195,4],[195,5,195,7],[195,8,195,9],[195,10,195,11],[196,3,196,4],[196,5,196,7],[196,8,196,9],[196,10,196,11],[192,3,192,4],[192,5,192,7],[192,8,192,9],[192,10,192,11],[193,3,193,4],[193,5,193,7],[193,8,193,9],[193,10,193,11],[194,3,194,4],[194,5,194,7],[194,8,194,9],[194,10,194,11]]}
[]
[null,null,null,"OFFER PACK 3\nGAS DSR   \nD-5 OPTION OFFERS"]
[]
[]
[]
[]
[]
[null,null,null,"This offer pack is designed for:\n Users (shippers who have consumers at offtake points) to submit Day D-5 DSR Offers for upcoming Winter Period and/or the subsequent two Winter Periods.\n"]
[]
[]
[]
[]
[null,null,null,"Issued 18th November 2022"]
[]
[]
[null,null,null,"Produced by National Grid Gas Transmission  \nNational Grid Gas plc\nNational Grid House\nWarwick Technology Park\nGallows Hill\nWarwick\nCV34 6DA"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"PLEASE NOTE:\n\nThis document should be read in conjunction with the Invitation to Offer guidance document on the website link below:\nhttps://www.nationalgrid.com/gas-transmission/balancing/demand-side-response-dsr \n\n\nTerms and phrases used in this document have the meanings set out or referred to in this template have been set out in the Offer Guidance Document. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"IMPORTANT INFORMATION - PLEASE READ:"]
[null,null,null,"All parts of \"D-5 Offers\" must be completed to be eligible for selection of D-5 Offers.\n\nSuch offers would not be capable of acceptance until and unless a UNC Modification and corresponding change to our DSR Methodology had been implemented which set out the rules for such an additional DSR scheme.\n\nThe Winter Period is defined in the Uniform Network Code General Terms C.2.2.1 h has the period from 1st November in any year until the 30th April in the following year. \n\nSection 24 Lead Times is greyed out for D-5 offers as they are not required.\n \nThe Winter Period  for 22/23 option Offer is defined and will be  calculated from the first day the DSR offer is accepted till the 30th April 2023\n\nPlease submit one offer pack per consumer."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Completed Offers should be submitted by 12:00 hours (GMT) on 9th December 2022 via email to Brendan.Mullan@nationalgrid.com and cc Andrea.Godden@nationalgrid.com\n\nThe completed Offer Pack should be submitted with a filename which includes the company name and site.\nSubmissions can be revised up to and including the deadline date."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DSR D- 5 OPTION OFFERS"]
[]
[]
[null,null,null,"Part 1: Shipper Details"]
[]
[null,null,1,"User company Name\n(including company number)"]
[]
[null,null,2,"User Representative, Job Title"]
[]
[null,null,3,"User Representative Address\n(full address including postcode)"]
[]
[]
[]
[null,null,4,"User Telephone Number"]
[null,null,5,"User Out of hours Telephone Number"]
[null,null,6,"User Email Address"]
[null,null,7,"User Legal Agent Name (if applicable)"]
[null,null,8,"User Legal Agent Address (if applicable)"]
[]
[null,null,9,"Shipper Short Code"]
[]
[]
[null,null,null,"DSR D-5  OPTION OFFERS"]
[]
[]
[null,null,null,"Part 2: Consumer Details"]
[]
[null,null,10,"Consumer Name\n(including company number)"]
[]
[null,null,11,"Consumer Location\n(full address including postcode)\n"]
[]
[]
[]
[]
[null,null,12,"Type of Business"]
[null,null,13,"If other, please specify"]
[null,null,14,"Annual Quantity Therms or kWh (specify the unit of measure)"]
[]
[null,null,15,"Gemini Meter ID"]
[]
[null,null,16,"Multi Year Offer"]
[]
[null,null,17,"If yes, how many additional years?"]
[]
[null,null,18,"How will the demand reduction be delivered?"]
[null,null,19,"If the consumer has the capability to switch to back-up fuel, what type of fuel it is (free text)"]
[null,null,20,"Website for Service Availability / Unavailability"]
[]
[]
[]
[null,null,null,"2022/23 DSR D-5 OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"**Winter Period Number of Days \n11th January 2023 to 30th April 2023 ","Total Option Fee 11th January 2023 to 30th April 2023 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,"Example ",null,150000,null,null,null,null,3,null,104,{"$f":"F127*K127*M127/100","v":468000},null," D-1 SAP *1.1"]
[null,null,null,"Example ",null,100000,null,null,null,null,4.0999999999999996,null,104,{"$f":"F128*K128*M128/100","v":426399.99999999994},11.65]
[null,null,null,1,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,2,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,3,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,4,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,5,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,6,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,7,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,8,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,9,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,10,null,0,null,null,null,null,0,null,104,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N129:N138)","v":0}]
[null,null,null,"** The number of days figure is based on the offer starting on the 11th January 2023\n\nWorked example of Option Fee for 2022/23\n                                             \nReduction Quantity (Minimum 100,000 kWh/d) = 150,000                                                   Total Option Fee = Reduction Quantity x option price  \n                                                                                                                                       (150,000 X 3.0p ) x Number of days (104)  = £468,000.00\nOption Price (pence/kWh/d)  = 3.0p\nNumber of days in Winter Period = 104\n\n                                                       "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2023/24 DSR D-5 OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November  2023 to 30th April 2024 ","Total Option Fee   Ist November 2023 to 30th April 2024 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,182,{"$f":"F161*K161*M161/100","v":0},0," D-1 SAP *1.1"]
[null,null,null,2,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,3,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,182,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N161:N170)","v":0}]
[]
[]
[null,null,null,"2024/25 DSR D-5 OPTION OFFERS"]
[]
[]
[null,null,null,"Part 3: Availability"]
[]
[null,null,21,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,22,null,23,null,null,24,null,25,null,26,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity \n(Minimum 100,000 kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price (pence/kWh/d)",null,"Winter Period Number of Days \nIst November 2024 to 30th April 2025 ","Total Option Fee   Ist November 2024 to 30th April 2025 ","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column O or P not both "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to D-1 SAP"]
[null,null,null,1,null,0,null,null,0,null,0,null,181,{"$f":"F187*K187*M187","v":0},0]
[null,null,null,2,null,0,null,null,0,null,0,null,181,{"$f":"F188*K188*M188","v":0},0]
[null,null,null,3,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,4,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,5,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,6,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,7,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,8,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,9,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,10,null,0,null,null,0,null,0,null,181,0,0]
[null,null,null,"Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(N187:N196)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,7,null,null,null,null,null,null,null,null,{"$f":"(F331*K331)/100*(181/365)","v":0}]
[null,null,null,8,null,null,null,null,null,null,null,null,{"$f":"(F332*K332)/100*(181/365)","v":0}]
[null,null,null,"Total",null,{"$f":"SUM(F105:G332)","v":250069}]
[null,null,"**    Where a User offers an exercise price that is indexed in accordance with BR 4(f)(ii), National Grid NTS shall \ndetermine such price for the purposes of its assessment as being the forward price for the relevant winter \nas published in the Argus European Natural Gas Report on the day the invitation to offer closes, provided \nthat for any such offers submitted in the first invitation to offer for Winter Period 2022/23, the ‘Winter 2022’\ncontract will no longer be available, therefore the Q1 2023 price quoted in such report shall be used. "]
[]
[]
[]
[]
[]
[null,null,null,"2023/24 DSR DAY AHEAD OFFERS"]
[]
[]
[null,null,null,"Part 3: Deliverability & Availability"]
[]
[null,null,20,"Minimum Reduction Quantity Offered (100,000 kWh/d)",null,null,null,null,null,null,null,null,null,"kWh/day"]
[]
[]
[null,null,21,"Lead Time",null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,22,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,23,null,24,null,null,25,null,26,null,27,28]
[null,null,null,"DSR Tranche Number",null,"Reduction Quantity (in kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price / Service Fee (pence/kWh/d)",null,"Number of Days","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column N or O not both"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to SAP"]
[null,null,null,1,null,null,null,null,null,null,null,null,182]
[null,null,null,2,null,null,null,null,null,null,null,null,0]
[null,null,null,3,null,null,null,null,null,null,null,null,0]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"(F361*K361)/100*(181/365)","v":0}]
[null,null,null,5,null,null,null,null,null,null,null,null,0]
[null,null,null,6,null,null,null,null,null,null,null,null,0]
[null,null,null,7,null,null,null,null,null,null,null,null,0]
[null,null,null,8,null,null,null,null,null,null,null,null,0]
[null,null,null,9,null,null,null,null,null,null,null,null,0]
[null,null,null,10,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,{"$f":"SUM(F358:G367)","v":0}]
[]
[]
[]
[null,null,null,"2024/25 DSR DAY AHEAD OFFERS"]
[]
[]
[null,null,null,"Part 3: Deliverability & Availability"]
[]
[null,null,20,"Minimum Reduction Quantity Offered (100,000 kWh/d)",null,null,null,null,null,null,null,null,null,"kWh/day"]
[]
[]
[null,null,21,"Lead Time",null,null,null,null,null,null,null,null,null,"Hours"]
[]
[null,null,22,"Planned Maintenance Periods",null,null,null,null,null,null,null,null,null,"Dates"]
[]
[]
[]
[null,null,null,"Tranche Offers "]
[null,null,null,23,null,24,null,null,25,null,26,null,27,28]
[null,null,null,"DSR  Tranche Number",null,"Reduction Quantity (in kWh/d)",null,null,"Lead Time for Reduction (Hours)",null,"Option Price / Service Fee (pence/kWh/d)",null,"Number of Days","Exercise Price (pence/kWh or indexed SAP Price)\nFill in either  Column N or O not both"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pence/kWh","Indexed to SAP"]
[null,null,null,1,null,null,null,null,null,null,null,null,0]
[null,null,null,2,null,null,null,null,null,null,null,null,0]
[null,null,null,3,null,null,null,null,null,null,null,null,0]
[null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"(F393*K393)/100*(181/365)","v":0}]
[null,null,null,5,null,null,null,null,null,null,null,null,0]
[null,null,null,6,null,null,null,null,null,null,null,null,0]
[null,null,null,7,null,null,null,null,null,null,null,null,0]
[null,null,null,8,null,null,null,null,null,null,null,null,0]
[null,null,null,9,null,null,null,null,null,null,null,null,0]
[null,null,null,10,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,{"$f":"SUM(F390:G399)","v":0}]

{"sheet":"1","index":4,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["List Options"]
[]
["Multi Year Offer"]
["Yes"]
["No"]
[]
["How Many Years"]
["N/A"]
["Y+1"]
["Y+2"]
[]
[]
["Type of Business"]
["Chemical"]
["Food & Drink"]
["Heavy Industry - Steel, Glass etc"]
["Manufacturing"]
["Power Generation"]
["Public Services"]
["Other"]
[]
[]
["How will demand reduction be delivered?"]
["Column1","Column2","Column3"]
["Fuel Switching"]
["Reduction in production"]
["Combination of both"]
["Other"]

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

{"sheet":"DC3B","index":6,"n_rows":4,"n_cols":41,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,2,1,9]]}
[null,null,"Data Collection Tab for Contracts Team"]
[]
["Tender Pack","Tender Ref","Tranche Ref","Main Ref",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Winter Only?",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"A4&\".\"&B4&\".\"&C4","v":".."},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,\"12\",IF(#REF!=2,\"24\",\"UNCHECKED\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"N\",\"Y\")","v":{"$error":"#REF!"}}]

{"sheet":"DC3C","index":7,"n_rows":4,"n_cols":41,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,2,1,9]]}
[null,null,"Data Collection Tab for Contracts Team"]
[]
["Tender Pack","Tender Ref","Tranche Ref","Main Ref",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Winter Only?",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"A4&\".\"&B4&\".\"&C4","v":".."},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Yes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=1,\"12\",IF(#REF!=2,\"24\",\"UNCHECKED\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"N\",\"Y\")","v":{"$error":"#REF!"}}]