{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Change Log","MOD Timetable","K Model flowchart","Colour Coding","Checklist","BBPTACShadowWks0001","Portfolio & Structure","Pricing Notice Tables","Mod186 Statement","Mod186 Statement movement","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":80,"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":"Change Log","index":0,"n_rows":160,"n_cols":8,"rows_kept":160,"cut":false,"hidden":true,"merged":[[68,2,68,5],[69,2,69,5],[67,2,67,5],[3,1,3,5],[4,1,4,2],[7,1,7,5],[9,1,10,5],[12,1,15,5],[19,1,24,5],[62,0,62,5],[63,2,63,5],[64,2,64,5],[65,2,65,5],[66,2,66,5],[70,2,70,5],[71,2,71,5],[72,2,72,5],[73,2,73,5],[74,2,74,5],[75,2,75,5],[76,2,76,5],[77,2,77,5],[78,2,78,5],[80,2,80,5],[79,2,79,5],[81,2,81,5],[82,2,82,5],[83,2,83,5],[84,2,84,5],[98,2,98,5],[90,2,90,5],[85,2,85,5],[86,2,86,5],[87,2,87,5],[88,2,88,5],[89,2,89,5],[93,0,96,0],[111,2,111,5],[117,2,117,5],[106,2,106,5],[100,2,100,5],[101,2,101,5],[97,2,97,5],[99,2,99,5],[102,2,105,5],[107,2,110,5],[113,2,116,5],[135,2,141,5],[128,2,134,5],[127,2,127,5],[123,2,126,5],[118,2,118,5],[119,2,119,5],[122,2,122,5],[120,2,121,5],[159,2,162,5],[155,2,157,5],[158,2,158,5],[151,2,153,5],[142,7,146,7],[142,2,146,5]]}
["Spreadsheet - Control Sheet - in compliance with End User Computer Policy"]
["(Inputs required into blue cells)"]
[]
["Spreadsheet name","RIIO K Model - Live"]
["Version","Live Version"]
[]
["Information"]
["Spreadsheet owner (name)","Jon Trapps"]
[]
["Spreadsheet content","Allowed Revenue Forecasts and subsequent pricing calculations"]
[]
[]
["Spreadsheet purpose","Forecast Revenue and calculate annual price changes required to ensure NGN are correctly recovering income in accordance with the Allowed Revenue formula"]
["(include details of outputs and "]
["frequency of use)"]
[]
[]
[]
["Basis of calculations"]
["(include notes about macros, ","There is one macro in the document - this is used to calculate the overall price change and works using a 'goal seek' calculation to make Collected Revenue = Allowed Revenue by changing the price change cells.  The tabs in the spreadsheet model both Collected and Allowed Revenue, and use a variety of formula types including Vlookups, IFs, SUMIFs, and Goalseeks (macro)."]
["types of formula (eg. IF, Vlookups))"]
[]
[]
[]
[]
[]
[]
["Assumptions and limitations"]
[]
["Assumptions","n/a"]
["(list key assumptions - if there"]
["are many a seperate tab may be"]
["required - reference here)"]
[]
[]
[]
[]
[]
["Limitations","n/a"]
["(list key limitations - if there"]
["are many a seperate tab may be"]
["required - reference here)"]
[]
[]
[]
[]
[]
[]
[]
["Spreadsheet testing"]
[]
["Spreadsheet risk rating",97]
[]
["Date last tested",null,null,"Date of next test"]
[]
["Testing carried out by"]
["Testing signed off by"]
[]
[]
["Change log "]
["(to be completed when spreadsheet"]
["amended eg. formulas, links)"]
[]
["Name","Date","Details of change",null,null,null,"Procedures Updated?","Changes signed off by:"]
[]
["Jon Trapps","06.01.2013","Exit Capacity process has been reworked to simplify and separate it"]
[null,null,"from LDZ Customer and Capacity charges.  This is impacted the model"]
[null,null,"in the following places:"]
[]
[null,null,"* Summary sheet : added the summary from Exit Capacity at the bottom"]
[null,null,"* K Factor Kt - added the K calculations for ECNK underneath the normal K"]
[null,null,"* Calc Rev - added a price change needed for Exit in row 8 and linked row"]
[null,null,"62 to mirror the same process as the other capacity calculations i.e take"]
[null,null,"run rate, reduce for any SOQ assumptions and inflate by required price"]
[null,null,"change needed."]
[null,null,"* The macro button - so added into the macro the same price change"]
[null,null,"process as the normal one - so the macro now calculated the required"]
[null,null,"price change needed for Exit first, then does the price change needed"]
[null,null,"for all other elements."]
[]
[null,null,"Simplication of the following sheets :"]
[]
[null,null,"*Exit Costs calculator :"]
[null,null,"So this is now done by month going across and in 5 key sections with"]
[null,null,"regulatory and gas years calculated to the far right."]
[]
[null,null,"* Exit revenue calculator - 4 key sections to calculate the required charges"]
[null,null,"by exit zone for the annual pricing updates.  Again this is done by month"]
[null,null,"to reflect the changes in capacity of the network after the annual SOQ"]
[null,null,"changes."]
[]
["Jon Trapps","15.01.2013","CSOUt","17% formula updated","CSOUt"]
[null,null,"CSOD","linked to opposite of CSOUt","CSOD"]
["(these changes were done after a reconciliation exercise vs.the ofgem revenue templates was completed)"]
[null,null,"SHRR","changed so corporation tax uses rate in year rather than t-2","SHRR"]
[]
[null,null,"EEIt","changed so corporation tax uses rate in year rather than t-2","EEIt"]
[]
["Jon Trapps","03.04.2014","Customer Bill Impact added to within the Mod186 Statement - Table 7"]
[null,null,"Also the Mod186 statements have been redone to be in alignment "]
[null,null,"with standard document requested by the shippers"]
[]
["Jon Trapps","27.01.2015","Changed row 12 on the mod186 statement to row that includes actuals so it gets automatically updated with actuals once available - presentation purposes only no impact on £ numbers - and row 12 on the mod186 movements sheet"]
[]
[]
[]
[]
["Jon Trapps","29.05.2015","Updated the calc rev sheet capacity forecasts to link to the new model.  Also linked the commodity unit rates to the same file and deleted the old shorthaul fixed elements with no back up."]
[]
[]
[]
[]
[]
["Jon Trapps","13.07.2015","Added 2 rows into MOD section on summary sheet to reflect additional items from changes to shrinkage and exit allowances - and changed price change macro as everything has moved down 2 rows, and mod186 statements"]
[]
[]
[]
[]
["Mandip Grewal","18.09.2015","Added rows to show interest rate for each month.",null,null,null,"n/a"]
[]
["Jon Trapps","30.09.2015","Deleted the charge type detail on the finance outputs tab to simplify the process at month end"]
[]
[]
["Jon Trapps","01.10.2015","Summary sheet - added fuel poor allowances to MOD box and inserted some blank rows into this section in case of future additions.  Also changed macro so that the row numbers are correct on the price change macro."]
[]
[]
[]
[]
["Jon Trapps","04.01.2016","Updated the calc rev sheet to link to my simpler capacity model which is basically as summary of the latest months invoices.  Also inserted a row for exit capacity and amended the forward looking formula logic to calculate on the same basis, also colour coded the soq change vs the price change so its clear to the end user"]
[]
[]
[]
[]
[]
[]
["Jon Trapps","07.06.2016","Added on 3 extra years of RIIOGD2 in readiness for budget modelling and amended the macro to calculate the price change in these years"]
[]
[]
[]
[]
[]
[]
["Jon Trapps","10.01.2017","Calc Rev sheet - changed timings of when SOQ is impacting revenue collection in line with projected Nexus go live as agreed by DW in meeting on 09.01.2017 - old model kept as evidence of what has changed",null,null,null,"n/a","Dave Pearson as part of Jan 16 pricing checking"]
[]
[]
[]
[]
["Jon Trapps","18.04.2017","Model tidy up to make it work on sharepoint:"]
[null,null,"Deleted Xoserve template sheet"]
[null,null,"Deleted Com Rev Cal sheet as not needed"]
[]
["Jon Trapps","25.05.2017","Calc Rev - changed assumption on \"other revenue\" to £300k a year to simplify formula logic"]
[]
[]
[]
["Jon Trapps","31.07.2017","Redesigned Mod186 sheets to match that of the new standard that will be presented to shippers from September onwards (an old version of  the K model has been saved down as a trace)"]
[]
[]
[]
["Jon Trapps","13.09.2017","Complaints formula on customer BMt sheet row 124 amended as it was all linking to the first year 13/14 - no impact on any cash values as there is zero penalty"]

{"sheet":"MOD Timetable","index":1,"n_rows":81,"n_cols":5,"rows_kept":81,"cut":false,"hidden":true,"merged":[[65,1,69,1],[71,1,80,1],[5,1,9,1],[11,1,20,1],[24,1,31,1],[35,1,39,1],[41,1,50,1],[54,1,61,1]]}
[]
[null,"HIGH LEVEL TIMETABLE - WHAT WILL BE INCLUDED IN \"MOD\""]
[]
[null,"MAR 13",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2013"]
[]
[null,"NOV 13",null,"(1) Legacy Price Control Adjustments (True up for 12/13 forecast vs. actuals)"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/13 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 14/15"]
[]
[null,"NOV 14",null,"(1) Totex Actuals for 13/14 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/14 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2013 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 15/16 onwards (13 years left)"]
[null,null,null,null,"- Deficit true up for year 13/14 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated year 13/14"]
[]
[null,null,null,"K model process generates prices for 15/16"]
[]
[null,"MAY 15",null,"First reopener window : 1st May to 31st May"]
[]
[null,"NOV 15",null,"(1) Totex Actuals for 14/15 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/15 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Ofgem view of reopener costs put through MOD process, costs entered against relevant year and"]
[null,null,null,"time value of money adjustment applied."]
[]
[null,null,null,"K model process generates prices for 16/17"]
[]
[null,"MAR 16",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2016"]
[]
[null,"NOV 16",null,"(1) Totex Actuals for 15/16 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/16 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 17/18"]
[]
[null,"NOV 17",null,"(1) Totex Actuals for 16/17 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/17 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2016 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 18/19 onwards (10 years left)"]
[null,null,null,null,"- Deficit true up for year 14/15, 15/16, 16/17 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated for years 14/15, 15/16, 16/17 "]
[]
[null,null,null,"K model process generates prices for 18/19"]
[]
[null,"MAY 18",null,"Second reopener window :1st May to 31st May"]
[]
[null,"NOV 18",null,"(1) Totex Actuals for 17/18 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/18 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Ofgem view of reopener costs put through MOD process, costs entered against relevant year and"]
[null,null,null,"time value of money adjustment applied."]
[]
[null,null,null,"K model process generates prices for 19/20"]
[]
[null,"MAR 19",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2019"]
[]
[null,"NOV 19",null,"(1) Totex Actuals for 18/19 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/19 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 20/21"]
[]
[null,"NOV 20",null,"(1) Totex Actuals for 19/20 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/20 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2019 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 21/22 onwards (7 years left)"]
[null,null,null,null,"- Deficit true up for year 17/18, 18/19, 19/20 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated for years 17/18, 18/19, 19/20 "]
[]
[null,null,null,"K model process generates prices for 21/22"]

{"sheet":"K Model flowchart","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
["K Model Flowchart"]
[]
[]
[]
[]
[]
[]
[" "]
[null,null,null,null,null,null,null,null,null,null,null,null,"I"]
[]
[]
[]
[]
[]
[]
[]
[null,"BR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"PT"]
[]
[null,"BM"]
[]
[]
[null,"Ex"]
[]
[null,"SHR"]
[]
[null,"EEI"]
[]
[]
[null,"DRS"]
[]
[null,null,null,null,null,"RPI"]
[]
[null,"NIA"]
[]
[]
[]
[null,"K"]

{"sheet":"Colour Coding","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["The following colours are used throughout the K Model to identify the different types of data held within the model:"]
[]
[null,null,null,"Data hard coded from the Licence"]
[]
[null,null,null,"Data hard coded from a data source"]
[]
[null,null,null,"Data transferred from other worksheets within the K Model"]
[]
[null,null,null,"Data linking to other data files"]
[]
[null,null,null,"Calculation cells"]
[]
[null,null,null,"Manually keyed in data"]
[]
[null,null,null,"Macro driven calculation cells"]
[]
["The tabs in the K Model are coloured to reflect the type of calculation within the tab:",null,null,null,null," "]
[]
[null,null,null,"Tabs which calculate Allowed Revenue, per the the Allowed Revenue Formula",null,null,null,null,null,null," "]
[]
[null,null,null,"Tabs which calculate Actual and Forecast Collected Revenue"]
[]
[null,null,null,"Summary and Other Tabs"]
[]
[null,null,null,"Output tabs for Xoserve Pricing templates, Pricing Statements, and Financial Reporting requirements"]
[]
[null,null,null,"Overall summary tab for internal review purposes to show the building blocks"]
[]
[null,null,null,null,null," "]

{"sheet":"Checklist","index":4,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":true,"merged":[[4,1,4,3],[45,2,48,2],[45,1,48,1],[50,7,50,11],[8,7,8,11],[11,7,11,11],[12,7,12,11],[25,7,25,11],[45,7,48,11],[62,7,67,11],[62,13,67,17],[7,7,7,11],[7,13,7,17],[83,2,83,3],[79,1,79,5],[62,2,67,2],[8,13,8,17],[62,1,67,1],[62,4,67,4],[62,5,67,5],[57,4,57,5],[57,7,57,17],[45,13,48,17],[84,2,84,3],[85,2,85,3],[80,2,80,3],[81,2,81,3],[82,2,82,3]]}
[]
[null,"Checklist"]
[null,"The following checklist should be used when completing a full update of the K Model :"]
[]
[null,"Task",null,null,"Deadline","Tick when complete"]
[]
[null,"Annual updates to the K model :"]
[null,null,"Sheet in model","What is the task",null,null,null,"Procedures reference point",null,null,null,null,null,"License reference point in applicable"]
[null,1,"Summary","row 66 : change the word \"Forecast\" into \"Actual\"","April"]
[null,{"$f":"B9+1","v":2},"Summary","On the summary tab - the macro needs amending so it pulls in only forecast years not actual","April",null,null,"Section 27. Adhoc changing the macro"]
[null,3,"Unit Prices","Hard code the unit rates for the most recent price change as once published they should not change","as soon as 60 day notice is published at end of Jan"]
[null,4,"Calc Rev","Update the rates held in rows 16 to 17 for commodity income (source = Pricing Statement on NGN website) - can input in January but effective from April","May",null,null,"refer to the Pricing Statement held on NGN website"]
[null,5,"Calc Rev","Revisit the rates held in rows 16 to 20 and link to the most recent capacity modelling.","May",null,null,"follow procedures held in external file (Dom & IC Historic rates)"]
[null,{"$f":"B13+1","v":6},"Base Revenue BRt","Hard code the factor for the last regulatory year in cell H24 (or the appropriate year).  This is the RPIf factor that was included when prices were set  and for the RPI true up to calculate correctly in future years it needs to be fixed.","April",null,null,"Section 5. Base Revenue (BR)",null,null,null,null,null,"Special Condition 1B : page 24"]
[null,{"$f":"B14+1","v":7},"Base Revenue BRt","Update the last full regulatory years RPI data in row 15 : source = ONS website","April",null,null,"Section 5. Base Revenue (BR)",null,null,null,null,null,"Special Condition 1B : page 24"]
[null,{"$f":"B15+1","v":8},"Exit revenue calculator","Hard code the rates held in cells DL78 to DL82 for exit prices for the last full regulatory year.  These should be the rates that are held in the latest pricing statement.","April",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,{"$f":"B16+1","v":9},"Pass Through Costs","Theft of Gas - license term TGt - the reasonable endeavour costs - finalise the full year number and enter in the reg year - costs incurred can be found in SAP from type \"ADN846\".","May"]
[null,{"$f":"B16+1","v":9},"Exit costs calculator","Exit Costs are reworked once a year : review the workings held in this model and check that they are correct","May",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,10,"Interest calculations","Once the actual interest rate is known for the last full regulatory year input this figure into the top of the \"Interest Calculations\" sheet in column E.  Over the key the formulas with the actual value and protect the cell so it cant be changed again.","April"]
[null,11,"Exit costs calculator","NTS issue their indicative prices for the following gas year (October to September) during May.  Update these in the relevant section on this sheet","May",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,12,"Exit Ext","The NTS prices that are used for the incentive element are as at 3 years prior - get the prices from the Joint Office website when available and input into rows 53  76.","May",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,13,"Reward DRS","Discretionary Reward Scheme : DRS : Once available input the value into the \"Reward DRS\" tab","usually June",null,null,"Section 11. Discretionary Reward Scheme",null,null,null,null,null,"Special Condition 1G : page 69"]
[null,14,"Throughput Vols","Check with Gareth Mills / Emma Buckton that the latest set of Throughput volumes are available.  Re-link rows 6 to 10 to the latest file.","July"]
[null,15,"Calc Rev","If there have been any changes to the allowed revenue for NTS Exit Charges these need to be updated in row 62.   Also check that any \"new\" allowances are reflected in the exit revenue and costs calculator sheets","July",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,16,"All relevant sheets with actual data","Reconciliation to 1b - ensure all inputs into the K model for the last regulatory year match the 1b submission - submission deadline 31st July but can be done before if finalised","July before 1b submitted"]
[null,17,"Unit Prices","Once the load factors are available input these into the relevant section on the \"Unit Prices\" sheet, calculate the average load factor % and put this into the future years calculations of SOQ within Table 7 on the MOD186 statement which calculates average domestic customer bills.","Sept",null,null,"The ENA website normally publishes these or they will be available from Xoserve"]
[null,18,"Exit costs calculator","Check with Gareth Mills / Emma Buckton that the volume booking figures are available by exit zone - input these into rows 63 to 86.  These should then flow to the \"Exit Ext\" tab rows 108 to 131.","Sept",null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,19,"SOQ Assumptions","Once known update the SOQ % change in the relevant year - finalised position not known until mid October.  Also revisit the assumption for future years aswell.","Oct",null,null,"Section 14. SOQ Assumptions"]
[null,{"$f":"B28+1","v":20},"Exit Revenue calculator","Update the amount to claim back through the revenue allowances and any under/over recovery - bring in the latest capacity figures aswell so a rate per Kwh can be established for Indicative Prices","Oct"]
[null,{"$f":"B29+1","v":21},"NIA","We need confirmation from Ofgem if any of our proposed NIA spend has been classed as unrecoverable.","Sept?"]
[null,{"$f":"B30+1","v":22},"Exit revenue calculator","Update the latest capacity figures inclusive of the latest AQ changes in section 3 of this sheet.  These are used when calculating a rate to charge per KWh","Oct / Nov"]
[null,{"$f":"B31+1","v":23},"Summary","Enter what the final \"MOD\" term is that Ofgem publish each November - put this in row 21 against the relevant tab.  As soon as this is entered the formula will pick up this value instead of the forecasted MOD section directly above.  Protect this cell once it is input so it can't be changed.","Nov",null,null,"Section 5. Calculation of Allowed Revenue",null,null,null,null,null,"Special Condition 2B - page 82"]
[null,24,"Base Revenue BRt","When the final \"MOD\" is available this will also change the WACC - as a result of the cost of debt changing.  On the \"Base Revenue Brt\" sheet update row 31 with the latest WACC figures.","Nov"]
[null,25,"Base Revenue BRt","After the final MOD has been made available update the WACC in row 31 on this sheet to match that in the latest Ofgem PCFM","Nov"]
[null,26,"Unit Prices","Annual Pricing Statement Updates : on tab \"Unit Prices\" update the cell in E2 to the next full regulatory year (will do anyway as part of Indicative pricing statement)","Nov"]
[null,27,"Customer BMt","Stakeholder Engagement Award : Se : Once known enter the value awarded by Ofgem into row 6 on the \"Customer BMt\" tab (can only be a positive figure)","Once known",null,null,"Section 8. Broad Measure of Customer Satisfaction",null,null,null,null,null,"Special Condition 1E : page 48"]
[null,28,"All allowed revenue sheets","Before we set prices - as an additional check - plug the same numbers into the Ofgem annual revenue templates and check that it arrives at the same position.","January"]
[null,29,"Unit Prices","If the scaling factor is to be applied in any given year, e.g. to rebalance the 95-5 Capacity-Commodity split link the relevant cells to the scaling factor calculations in the Portfolio & Structure tab","Jan",null,null,"Section 19. Portfolio and Structure"]
[null,30,"Unit Prices","Update the CSEP Admin charge  (source Matt Smith at Xoserve) in row 31.  This is only relevant up to Project Nexus go live though.","Jan"]
[null,31,"Interest calculations","Annual / adhoc - Bank of England interest base rates : on the \"Interest Calculations\" tab ensure the actuals are always in line","As and when",null,null,"Section 4.3 Interest Rates"]
[null,32,"Exit Ext","Corporation Tax rates - check with Claire Hodgson that CT rates are in line with HM Treasury - input into \"Exit Ext\" row 25 and this will flow through the model to any other sheets that have Corporation Tax rates included","announced in March"]
[]
[null,"The end of each calendar month :"]
[null,1,"Gas Prices","Link the gas prices section for last month to the latest Gaz de France Invoice file - in rows 9 to 374.",null,null,null,"Section 4.4 Gas Prices",null,null,null,null,null,"Special Condition 1F : page 56"]
[null,{"$f":"B44+1","v":2},"Gas Prices","Columns K and L : link the future daily Heren gas prices to the latest file - then ensure that future months in the section to the left are linked to these prices. ",null,null,null,"Section 4.4 Gas Prices",null,null,null,null,null,"Special Condition 1F : page 56"]
[null,{"$f":"B45+1","v":3},"Exit Costs calculator","To calculate the values held in row 137 on the Exit Ext tab these are calculated on the \"Exit costs calculator\" sheet - to update this sheet do the following :",null,null,null,"Section 4.5. Exit Costs Calculator",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,null,null,"8a)     Check there have been no updates to the NTS prices held in rows 30 to 53.  These can be found on the gas governance website. Examples of where they are found are held in the comments cells in row 28.  In reality prices usually only change once a year, but in gas years so expect the values to change each October onwards."]
[null,null,null,"8b)     Check the bookings figures are still linked correctly - again in reality these will only change once a year after the bookings window has closed - see action above in annual section."]
[null,null,null,"8c)     Update last months invoice value from SAP and enter this in the relevant cell in row 134.  Also check the difference between the invoice value and what has been calculated above - it should be zero difference if all inputs are up to date."]
[null,{"$f":"B46+1","v":4},"Throughput vols","You will need to calculate these in the file outside of this model (Monthly Throughput reports from 2006).  Once populated check the data is linked correctly in the K model. (Rows 19 - 23 and 30 - 34)",null,null,null,"Section 15. Throughput"]
[null,5,"Actual Revenue","Get the actual revenue numbers out of SAP.  Once populated check the total agrees to that in the management accounts.",null,null,null,"Section 17. Actual Revenue"]
[null,{"$f":"B51+1","v":6},"Summary","Always make sure the macro button has been ran to reflect any changes made"]
[null,{"$f":"B52+1","v":7},"Finance Output and Audit recs","On the \"Finance Output and Audit recs\" sheet : input the latest months SAP revenue accrual into rows 50-69 so we can validate how accurate the accrual has been the month after.",null,null,null,"Section 24. Finance output tables"]
[null,8,"Finance Output and Audit recs","Input the latest months SAP revenue invoices into rows 361-542.  You will need to do this outside of this model and summarise the data accordingly to fit in with the reconciliation.",null,null,null,"Section 24. Finance output tables"]
[null,9,"Finance Output and Audit recs","Input the latest months Xoserve BO15 report data into rows  148 to 328.  You will need to do this outside of this model and summarise the data in the same format as what is needed in this reconciliation.",null,null,null,"Section 24. Finance output tables"]
[]
[null,"Quarterly / before the Mod186 report is published - after month end checklist above is completed (Oct / Jan / Apr / July)"]
[null,1,"Calc Rev","Update the capacity model calculations (held outside of this model).  Once calculated go on to the \"Calc Rev\" sheet and link rows 47 to 52 for last month to the latest capacity model","changed to update quarterly",null,null,"..\\..\\..\\Distribution Charges\\Pricing related publications\\Pricing related procedure Docs\\PRFIN032 Capacity Revenue Forecasting.docx"]
[null,{"$f":"B58+1","v":2},"Interest Calculations","Obtain forecast interest data from the Head of Treasury (Ian Clark) who can obtain such forecasts from Bloomberg"]
[null,{"$f":"B59+1","v":3},"Base Revenue Brt","Obtain forecast RPI data from HM Treasury publication \"Forecasts for the UK Economy\" - use the table that summarises the independent average of new forecasts (unless Ofgem direct otherwise) - need this for row 20",null,null,null,"Section 5. Calculation of Allowed Revenue",null,null,null,null,null,"Special Condition 1B : page 24"]
[null,{"$f":"B60+1","v":4},"Base Revenue Brt","For future years obtain RPI forecasts from the Head of Treasury (Ian Clark). Check that RPIA = RPIF in the rows above equal each other after these have been input(rows 17 & 21)",null,null,null,"Section 5. Calculation of Allowed Revenue",null,null,null,null,null,"Special Condition 1B : page 24"]
[null,{"$f":"B61+1","v":5},"Summary","A forecast of the \"MOD\" term will need to be established - calculate outside of this model the MOD term due to forecasted cost of debt/Totex Outperformance impact/any others (through Ofgem PCFM)",null,null,null,"Section 5. Calculation of Allowed Revenue",null,null,null,null,null,"Special Condition Chapter 3 : page 84 onwards"]
[null,{"$f":"B62+1","v":6},"Customer BMt","Ask Eileen Brown / Kirsten Jameson for the latest position of customer scores.  Enter as follows if you have not already done this monthly :",null,null,null,"Section 8. Broad Measure of Customer Satisfaction",null,null,null,null,null,"Special Condition 1E : page 48"]
[null,null,null,"* Row 31 for Planned Supply Interruptions (i.e Repair)"]
[null,null,null,"* Row 58 for UnPlanned Supply Interruptions (i.e Emergency)"]
[null,null,null,"* Row 85 for Connections"]
[null,null,null,"* Rows 119 - 122 for Complaints (Tom Pollock)"]
[null,null,null,"* Row 7 - check that if there has been any stakeholder engagement monies awarded these have been input. There should be an Ofgem letter to back up any awarded monies."]
[null,{"$f":"B63+1","v":7},"Shrinkage SHRt","Check that the latest shrinkage volumes are in the model - they are saved on the joint office website before the start of each regulatory year.  Agree with Gareth Mills any forward looking logic on outperformance.",null,null,null,"Section 9. Shrinkage (SHR)",null,null,null,null,null,"Special Condition 1F : page 56"]
[null,{"$f":"B69+1","v":8},"Gas Prices","Agree with Gareth Mills the future price growth entered in row 2 / or input the gas prices from the market reports saved down in the shrinkage directory",null,null,null,"Section 9. Shrinkage (SHR)",null,null,null,null,null,"Special Condition 1F : page 56"]
[null,9,"Leakage EEIt","Check that the latest shrinkage volumes are in the model - they are saved on the joint office website before the start of each regulatory year.  Agree with Gareth Mills any forward looking logic on outperformance.",null,null,null,"Section 9. Shrinkage (SHR)",null,null,null,null,null,"Special Condition 1F : page 56"]
[null,10,"Innovation NIA","Ask Alec Breen / Laura Shaw for the latest actual and forecast data for NIA.",null,null,null,"Section 12. Network Innovation Allowance (NIA)",null,null,null,null,null,"Special Condition 1H : page 71"]
[null,11,"Innovation NIC","Ask Alec Breen / Laura Shaw for the latest actual and forecast data for NIC bid preparation costs",null,null,null,"Section 12. Network Innovation Allowance (NIA)",null,null,null,null,null,"Special Condition 1H : page 71"]
[null,12,"Pass Through PTt","Ask Claire Hodgson for the following for the next 5 years : - row 16 for rates, row 26 for license fee and row 36 for NTS Pension Deficit Charge. (doesn't really move between months so could be done quarterly at mod186 time)",null,null,null,"Section 6. Pass Through Costs (PT)",null,null,null,null,null,"Special Condition 1C : page 32"]
[null,13,"Pass Through PTt","Ask Tom Pollock for the following information : 3rd Party Damage and Water Ingress information - (unless a massive claim this will most likely be an adjustment once a year at RRP time)",null,null,null,"Section 6. Pass Through Costs (PT)",null,null,null,null,null,"Special Condition 1C : page 32"]
[null,14,"Pass Through PTt","Theft of gas and Miscellaneous costs get notified by Ofgem to us on the allowed pass through amount.  (unless a massive claim this will most likely be an adjustment once a year at RRP time)",null,null,null,"Section 6. Pass Through Costs (PT)",null,null,null,null,null,"Special Condition 1C : page 32"]
[null,15,"Exit Ext","Ask Keith Owen / Emma Buckton if we have had any revenue received from buybacks and costs incurred from overruns - input  into row 45 and 45 - these are also visible on the exit capacity invoices that come through so you can also check on the actual invoices that the nil assumption is correct.",null,null,null,"Section 7. Exit Costs and Incentive",null,null,null,null,null,"Special Condition 1D : page 38"]
[null,16,"Mod186 Statement","Validate the assumptions held within the average domestic customer bill impact in table 7 - check that there are no changes to the average AQ assumed or the load factors"]
[]
[null,"General Principles"]
[null,1,"All entries made above have supporting data saved in both an electronic and hard-copy audit file"]
[null,2,"The checker should review and check all of the above items have been actioned and/or addressed"]
[null,3,"File Passwords maintained and sheet protection applied"]
[null,4,"Macro to establish the future price change requirements is run following changes to the above - the button is held at the bottom right section of the \"Summary\" tab."]
[null,5,"Each month end / quarterly MOD186 has a separate K model saved off elsewhere as an audit trail so we can track changes made."]
[null,6,"Audit reconciliations are completed monthly and differences reviewed on going (ref. Finance Output and Audit recs sheet)"]

{"sheet":"BBPTACShadowWks0001","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[{"$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!"}}]

{"sheet":"Portfolio & Structure","index":6,"n_rows":56,"n_cols":28,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[null,"Portfolio & Structure Analysis"]
[]
[null,"1.  Current Portfolio Splits","2012/13","%",null,"2013/14","%",null,"2014/15","%",null,"2015/16","%",null,"2016/17","%",null,"2017/18","%",null,"2018/19","%",null,"2019/20","%",null,"2020/21","%"]
[]
[null,"LDZ System Commodity",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"C$5/(C$9+C$5)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"F$5/F$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"I$5/I$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"L$5/L$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"O$5/O$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"R$5/R$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"U$5/U$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"X$5/X$9","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"AA$5/AA$9","v":{"$error":"#REF!"}}]
[null,"LDZ System Capacity",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"C$6/C$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"F$6/F$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"I$6/I$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"L$6/L$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"O$6/O$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"R$6/R$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"U$6/U$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"X$6/X$7","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"AA$6/AA$7","v":{"$error":"#REF!"}}]
[null,"Total LDZ System",{"$f":"SUM(C5:C6)","v":{"$error":"#REF!"}},{"$f":"D6+D5","v":{"$error":"#REF!"}},null,{"$f":"SUM(F5:F6)","v":{"$error":"#REF!"}},{"$f":"G6+G5","v":{"$error":"#REF!"}},null,{"$f":"SUM(I5:I6)","v":{"$error":"#REF!"}},{"$f":"J6+J5","v":{"$error":"#REF!"}},null,{"$f":"SUM(L5:L6)","v":{"$error":"#REF!"}},{"$f":"M6+M5","v":{"$error":"#REF!"}},null,{"$f":"SUM(O5:O6)","v":{"$error":"#REF!"}},{"$f":"P6+P5","v":{"$error":"#REF!"}},null,{"$f":"SUM(R5:R6)","v":{"$error":"#REF!"}},{"$f":"S6+S5","v":{"$error":"#REF!"}},null,{"$f":"SUM(U5:U6)","v":{"$error":"#REF!"}},{"$f":"V6+V5","v":{"$error":"#REF!"}},null,{"$f":"SUM(X5:X6)","v":{"$error":"#REF!"}},{"$f":"Y6+Y5","v":{"$error":"#REF!"}},null,{"$f":"SUM(AA5:AA6)","v":{"$error":"#REF!"}},{"$f":"AB6+AB5","v":{"$error":"#REF!"}}]
[]
[null,"Total LDZ System Capacity",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"C$9/C$11","v":{"$error":"#REF!"}},null,{"$f":"F7","v":{"$error":"#REF!"}},{"$f":"F$9/F$11","v":{"$error":"#REF!"}},null,{"$f":"I7","v":{"$error":"#REF!"}},{"$f":"I$9/I$11","v":{"$error":"#REF!"}},null,{"$f":"L7","v":{"$error":"#REF!"}},{"$f":"L$9/L$11","v":{"$error":"#REF!"}},null,{"$f":"O7","v":{"$error":"#REF!"}},{"$f":"O$9/O$11","v":{"$error":"#REF!"}},null,{"$f":"R7","v":{"$error":"#REF!"}},{"$f":"R$9/R$11","v":{"$error":"#REF!"}},null,{"$f":"U7","v":{"$error":"#REF!"}},{"$f":"U$9/U$11","v":{"$error":"#REF!"}},null,{"$f":"X7","v":{"$error":"#REF!"}},{"$f":"X$9/X$11","v":{"$error":"#REF!"}},null,{"$f":"AA7","v":{"$error":"#REF!"}},{"$f":"AA$9/AA$11","v":{"$error":"#REF!"}}]
[null,"Customer Capacity",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"C$10/C$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"F$10/F$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"I$10/I$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"L$10/L$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"O$10/O$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"R$10/R$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"U$10/U$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"X$10/X$11","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"AA$10/AA$11","v":{"$error":"#REF!"}}]
[null,"Total Revenue (exc exit/misc)",{"$f":"SUM(C9:C10)","v":{"$error":"#REF!"}},{"$f":"D10+D9","v":{"$error":"#REF!"}},null,{"$f":"SUM(F9:F10)","v":{"$error":"#REF!"}},{"$f":"G10+G9","v":{"$error":"#REF!"}},null,{"$f":"SUM(I9:I10)","v":{"$error":"#REF!"}},{"$f":"J10+J9","v":{"$error":"#REF!"}},null,{"$f":"SUM(L9:L10)","v":{"$error":"#REF!"}},{"$f":"M10+M9","v":{"$error":"#REF!"}},null,{"$f":"SUM(O9:O10)","v":{"$error":"#REF!"}},{"$f":"P10+P9","v":{"$error":"#REF!"}},null,{"$f":"SUM(R9:R10)","v":{"$error":"#REF!"}},{"$f":"S10+S9","v":{"$error":"#REF!"}},null,{"$f":"SUM(U9:U10)","v":{"$error":"#REF!"}},{"$f":"V10+V9","v":{"$error":"#REF!"}},null,{"$f":"SUM(X9:X10)","v":{"$error":"#REF!"}},{"$f":"Y10+Y9","v":{"$error":"#REF!"}},null,{"$f":"SUM(AA9:AA10)","v":{"$error":"#REF!"}},{"$f":"AB10+AB9","v":{"$error":"#REF!"}}]
[]
[null,"Exit Revenue / other",null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[null,"TOTAL REVENUE",null,null,null,{"$f":"F11+F13","v":{"$error":"#REF!"}},null,null,{"$f":"I11+I13","v":{"$error":"#REF!"}},null,null,{"$f":"L11+L13","v":{"$error":"#REF!"}},null,null,{"$f":"O11+O13","v":{"$error":"#REF!"}},null,null,{"$f":"R11+R13","v":{"$error":"#REF!"}},null,null,{"$f":"U11+U13","v":{"$error":"#REF!"}},null,null,{"$f":"X11+X13","v":{"$error":"#REF!"}},null,null,{"$f":"AA11+AA13","v":{"$error":"#REF!"}}]
[null,"Check",null,null,null,{"$f":"F15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"I15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"L15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"O15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"R15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"U15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"X15-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"AA15-#REF!","v":{"$error":"#REF!"}}]
[]
[null,"2.  Scaling Factors Required "]
[null,null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…",null,"Is…","Want…"]
[null,null,"2013-03-01","2013-04-01",null,"2014-03-01","2014-04-01",null,"2015-03-01","2015-04-01",null,"2016-03-01","2016-04-01",null,"2017-03-01","2017-04-01",null,"2018-03-01","2018-04-01",null,"2019-03-01","2019-04-01",null,"2020-03-01","2020-04-01",null,"2021-03-01","2021-04-01"]
[]
[null,"a. Overall System / Customer Split :"]
[null,"LDZ Capacity",{"$f":"D9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"G9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"J9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"M9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"P9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"S9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"V9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"Y9","v":{"$error":"#REF!"}},0.71199999999999997,null,{"$f":"AB9","v":{"$error":"#REF!"}},0.71199999999999997]
[null,"Customer Capacity",{"$f":"D10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"G10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"J10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"M10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"P10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"S10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"V10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"Y10","v":{"$error":"#REF!"}},0.28799999999999998,null,{"$f":"AB10","v":{"$error":"#REF!"}},0.28799999999999998]
[]
[null,"b. Split with System between Capacity and Commodity"]
[null,"Capacity",{"$f":"D6","v":{"$error":"#REF!"}},0.95,null,{"$f":"G6","v":{"$error":"#REF!"}},0.95,null,{"$f":"J6","v":{"$error":"#REF!"}},0.95,null,{"$f":"M6","v":{"$error":"#REF!"}},0.95,null,{"$f":"P6","v":{"$error":"#REF!"}},0.95,null,{"$f":"S6","v":{"$error":"#REF!"}},0.95,null,{"$f":"V6","v":{"$error":"#REF!"}},0.95,null,{"$f":"Y6","v":{"$error":"#REF!"}},0.95,null,{"$f":"AB6","v":{"$error":"#REF!"}},0.95]
[null,"Commodity",{"$f":"D5","v":{"$error":"#REF!"}},0.05,null,{"$f":"G5","v":{"$error":"#REF!"}},0.05,null,{"$f":"J5","v":{"$error":"#REF!"}},0.05,null,{"$f":"M5","v":{"$error":"#REF!"}},0.05,null,{"$f":"P5","v":{"$error":"#REF!"}},0.05,null,{"$f":"S5","v":{"$error":"#REF!"}},0.05,null,{"$f":"V5","v":{"$error":"#REF!"}},0.05,null,{"$f":"Y5","v":{"$error":"#REF!"}},0.05,null,{"$f":"AB5","v":{"$error":"#REF!"}},0.05]
[]
[]
[null,"SCALING FACTOR REQUIRED"]
[null,"Commodity",null,{"$f":"(D28*D23)/(C28*C23)","v":{"$error":"#REF!"}},null,null,{"$f":"($G$28*$G$23)/($F$28*$F$23)","v":{"$error":"#REF!"}},null,null,{"$f":"(J28*J23)/(I28*I23)","v":{"$error":"#REF!"}},null,null,{"$f":"(M28*M23)/(L28*L23)","v":{"$error":"#REF!"}},null,null,{"$f":"(P28*P23)/(O28*O23)","v":{"$error":"#REF!"}},null,null,{"$f":"(S28*S23)/(R28*R23)","v":{"$error":"#REF!"}},null,null,{"$f":"(V28*V23)/(U28*U23)","v":{"$error":"#REF!"}},null,null,{"$f":"(Y28*Y23)/(X28*X23)","v":{"$error":"#REF!"}},null,null,{"$f":"(AB28*AB23)/(AA28*AA23)","v":{"$error":"#REF!"}}]
[" ","LDZ Capacity",null,{"$f":"(D27*D23)/(C27*C23)","v":{"$error":"#REF!"}},null,null,{"$f":"(G27*G23)/(F27*F23)","v":{"$error":"#REF!"}},null,null,{"$f":"(J27*J23)/(I27*I23)","v":{"$error":"#REF!"}},null,null,{"$f":"(M27*M23)/(L27*L23)","v":{"$error":"#REF!"}},null,null,{"$f":"(P27*P23)/(O27*O23)","v":{"$error":"#REF!"}},null,null,{"$f":"(S27*S23)/(R27*R23)","v":{"$error":"#REF!"}},null,null,{"$f":"(V27*V23)/(U27*U23)","v":{"$error":"#REF!"}},null,null,{"$f":"(Y27*Y23)/(X27*X23)","v":{"$error":"#REF!"}},null,null,{"$f":"(AB27*AB23)/(AA27*AA23)","v":{"$error":"#REF!"}}]
[null,"Cust Capacity",null,{"$f":"D24/C24","v":{"$error":"#REF!"}},null,null,{"$f":"G24/F24","v":{"$error":"#REF!"}},null,null,{"$f":"J24/I24","v":{"$error":"#REF!"}},null,null,{"$f":"M24/L24","v":{"$error":"#REF!"}},null,null,{"$f":"P24/O24","v":{"$error":"#REF!"}},null,null,{"$f":"S24/R24","v":{"$error":"#REF!"}},null,null,{"$f":"V24/U24","v":{"$error":"#REF!"}},null,null,{"$f":"Y24/X24","v":{"$error":"#REF!"}},null,null,{"$f":"AB24/AA24","v":{"$error":"#REF!"}}]
[]
[]
[null,"3.  New Daily Rates"]
[]
[null,"Scaling applied within Pricing Statement?",null,null,null,"No","No",null,"No","No"]
[]
[null,"3.a.  Commodity",null,null,null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling",null,"Per model","After scaling"]
[]
[null,"0-73 MWh - Domestic",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C43*D$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F43*G$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I43*J$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L43*M$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O43*P$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R43*S$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U43*V$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X43*Y$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA43*AB$32","v":{"$error":"#REF!"}}]
[null,"73-732 MWh - Small I&C",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C44*D$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F44*G$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I44*J$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L44*M$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O44*P$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R44*S$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U44*V$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X44*Y$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA44*AB$32","v":{"$error":"#REF!"}}]
[null,"732-5,861 MWh - Large I&C",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C45*D$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F45*G$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I45*J$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L45*M$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O45*P$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R45*S$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U45*V$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X45*Y$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA45*AB$32","v":{"$error":"#REF!"}}]
[null,">5,861 MWh",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C46*D$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F46*G$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I46*J$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L46*M$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O46*P$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R46*S$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U46*V$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X46*Y$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA46*AB$32","v":{"$error":"#REF!"}}]
[null,"Very Large Loads",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C47*D$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F47*G$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I47*J$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L47*M$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O47*P$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R47*S$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U47*V$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X47*Y$32","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA47*AB$32","v":{"$error":"#REF!"}}]
[]
[null,"3.b.  Capacity"]
[]
[null,"LDZ Capacity",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C51*D$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F51*G$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I51*J$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L51*M$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O51*P$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R51*S$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U51*V$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X51*Y$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA51*AB$33","v":{"$error":"#REF!"}}]
[null,"Customer Capacity",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C52*D$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F52*G$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I52*J$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L52*M$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O52*P$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R52*S$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U52*V$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X52*Y$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA52*AB$34","v":{"$error":"#REF!"}}]
[null,"Customer Fixed",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C53*D$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F53*G$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I53*J$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L53*M$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O53*P$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R53*S$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U53*V$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X53*Y$34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA53*AB$34","v":{"$error":"#REF!"}}]
[null,"CSEP Capacity",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C54*D$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F54*G$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I54*J$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L54*M$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O54*P$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R54*S$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U54*V$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X54*Y$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA54*AB$33","v":{"$error":"#REF!"}}]
[null,"CSEP Administration",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C55*D$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F55*G$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I55*J$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L55*M$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O55*P$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R55*S$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U55*V$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X55*Y$33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA55*AB$33","v":{"$error":"#REF!"}}]
[null,"Daily Shorthaul",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"O56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"R56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"U56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"X56","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AA56","v":{"$error":"#REF!"}}]

{"sheet":"Pricing Notice Tables","index":7,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":true,"merged":[[1,1,1,2],[2,1,2,2],[13,1,13,2],[28,1,28,2],[43,1,43,2]]}
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,"DIRECTLY CONNECTED SUPPLY POINTS"]
[]
[null,"Charge Type","LDZ CAPACITY","LDZ COMMODITY"]
[null,"Charge Code","ZCA","ZCO"]
[null,"Unit Rate","pence per peak day kWh per day","pence per kWh"]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"73,200 to 732,000 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Subject to a minimum rate of ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"Minimum reached at SOQ of ",{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"CONNECTED SYSTEM EXIT POINTS"]
[]
[null,"Charge Type","LDZ CAPACITY","LDZ COMMODITY"]
[null,"Charge Code",891,893]
[null,"Unit Rate","pence per peak day kWh per day","pence per kWh"]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"73,200 to 732,000 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Subject to a minimum rate of ",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"Minimum reached at SOQ of ",{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}}]
[]
[null,"CSEP administration charge "]
[null,"Charge per supply point ",{"$f":"#REF!&\" pence per day\"","v":{"$error":"#REF!"}}]
[]
[]
[null,"CUSTOMER CHARGES"]
[null,null," "]
[null,"Charge Type","LDZ CAPACITY"]
[null,"Charge Code","CCA"]
[null,"Unit Rate","pence per peak day kWh per day"]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"73,200 to 732,000 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Charge Type","LDZ CAPACITY"]
[null,"Charge Code","CFI"]
[null,"Unit Rate","Fixed charge - pence per day"]
[null,"Non-monthly read supply points ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"Monthly read supply points ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[]
[null,"EXIT CAPACITY CHARGES"]
[]
[null,"Charge Type","LDZ EXIT CAPACITY"]
[null,"Charge Code - directly connected supply points/cseps","ECN/C04"]
[null,"Unit Rate","pence per peak day kWh per day"]
[null,"NE1",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NE2",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NE3",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NO1",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NO2",{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Mod186 Statement","index":8,"n_rows":164,"n_cols":19,"rows_kept":164,"cut":false,"hidden":false,"merged":[[112,17,116,18],[1,3,1,18],[5,17,5,18],[151,3,151,4],[37,17,37,18],[38,17,38,18],[35,17,35,18],[30,17,30,18],[130,3,130,4],[36,17,36,18],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[93,17,93,18],[108,3,108,4],[27,17,27,18],[31,17,31,18],[34,17,34,18],[6,17,8,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[17,17,17,18],[18,17,18,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[26,17,26,18],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,"Published:",null,"2017-09-13T12:26:22.790",null,"RIIO-GD2"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140249519157237,1.3534457004731957,1.3940490714873917]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,null,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,null,null,null,null,null,"Prices set with an assumed RPI rate of 3.4% for 17/18 regulatory year"]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,null,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,9.9999999999991762E-4,"","","",null,null,"Difference between forecast and actual drives true up in 2 years time"]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,"Per final proposal data"]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,"14/15 - 17/18 MOD is actual, forecast thereafter."]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,5.3890861274262444E-2,5.6268108628512755E-14,null,null,"Latest RPI inflation impact on the true up mechanism"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.675641224536605,111.49008526137345,123.40649702044658]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,412.90430561111259,426.92774686571522,436.58195142421414]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583303954468199,5.8069421677628705,5.981150432795757]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937766987509522E-2,-6.1674099920134638E-2,-6.3524322917738685E-2]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391031842379761,2.2715064366794158,2.339651629779798]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,2.6049984567951485,8.0167745045221519,8.2572777396578161]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310260127886272,2.165854051077365,1.8558880265214446,null,null,"Data uses finalised July 2017 Gemini bookings applied with NTS incentive rates"]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039255584813738,-1.845927455940827,-5.7368476801532049]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.92964166347367816,0.93437767594001142,null,null,"13/14 - 16/17 actual volume impact - and assumed this level of outperformance will continue"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099516506447442,-7.2917508127408812,-7.6350198214282115,null,null,"Actuals and forecast compared against original allowance with actual/forecast gas prices"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481471132640724,-6.3621091492672033,-6.7006421454882004]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4091212241289091,3.0983210477234864,3.1925927538746204,null,null,"Assumes customer service scores and stakeholder results will continue at same rate as 16/17"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2963840569788383,5.4855713933858627,null,null,"13/14 - 16/17 actual volume impact - and assumed this level of outperformance will continue"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,"DRS from 11/12, 12/13,14/15 - forecast thereafter"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.5007691837990245,2.6012971253500092,2.6896448052540061,2.7504662939725493,null,null,"Actual spend 13/14 - 16/17, assumed will spend maximum allowance thereafter"]
[null,25,null,"Less Correction Term revenue Adjustment (K added)","-Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.411240613350806,-0.6526168685756718,-1.1842336658238662E-13]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,407.69602572356268,437.96821780641005,443.83036977946341,443.83036977946341]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,409.81056549398045,407.69602572356285,437.96821780641039,443.83036977946369,443.83036977946352]
[null,28,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,10.044088504568094,0.62890019107152284,0,0,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,-3.6307579379111221E-3,7.4251869463582532E-2,1.3384879849077436E-2,null,null,"Movement year on year in row reference 26"]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,null,null,null,null,-1.5369706035238914E-3,0,0,null,null,"Movement year on year in row reference 28"]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,null,null,null,null,null,-7.4999999999999997E-3,2.0000000000000004E-2,2.0000000000000004E-2,null,null,"Latest view on how much load factors could move capacity levels"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-4.1656217812578548E-4,-1.7084668933655262E-3,5.9803391185916932E-3]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1350878274177234E-2,4.262170956228286E-2,-3.5098650983371234E-2,-1.3084290719560798E-2,9.2543402570217009E-2,3.9365218967669133E-2,1.9707241358115791E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,0,0,0,0,0]
[]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,0,0,0,0,0]
[]
[null,null,null,"Average AQ","NE",null,null,15078.02270927113,14890.239844223981,14300.054833420678,14173.317543880596,"","","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,"","","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,"","","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,"","","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,"","","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,"","","","",""]
[]
[null,null,null,"Unit Rates","Commodity",null,null,2.7799999999999998E-2,2.92E-2,3.1199999999999999E-2,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3700000000000001E-2,3.5200000000000002E-2,3.5200000000000002E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19639999999999999,0.21440000000000001,0.2238,0.2238]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1048,0.1144,0.11940000000000001,0.11940000000000001]
[]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,"","","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,"","","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,"","","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,0,0,0,0,0]
[]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.21690097198598,411.31483044543188,409.18166530290893,407.69602572356274,437.96821780641005,443.83036977946347,443.83036977946347]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,129.12132406333461,128.65251579103807,138.2052055997157,140.05506567118493,140.05506567118493]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (16/17 Prices)","16/17 prices",null,null,132.54664381436916,135.50737749986558,137.26596764323389,129.79446543550341,124.75490247665179,120.24372200647292,125.40975063758528,123.386742797837,120.6716310981291]
[null,37,null,"% movement in domestic customer bill - (16/17 prices)",null,null,null,null,2.2337296519125083E-2,1.2977818446601175E-2,-5.4430842079877806E-2,-3.8827256169530977E-2,-3.6160346251909004E-2,4.2962980061730383E-2,-1.6131184612546257E-2,-2.2004889975550168E-2]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523998828300895,11.869718793149925,12.225810356944423]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,4.6425642213681218E-3,-6.4762778599742681E-15]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0907295754890702,7.862579850353101,4.6330746502697675]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.683584578064516,7.0907295754890765,7.8625798503531126,4.6330746502697675]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-4.4738493080211938E-3,0,1.1546319456101628E-14,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7695670178147935E-2,0.1088534355522639,-0.41074370773332103]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,5.8192186626632755E-4,0,-1.46851538246484E-15]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-7.4999999999999997E-3,0.02,0.02]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,-2.5117254049654338E-4,-4.6182192291089816E-4,-6.3270136264644405E-3]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4864920852378151E-2,0.128391613629353,-0.39707072135978694]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,380.29677084437623,null,384.44668689922634,401.47893814541436,414.68036008213767,402.55038396788387,401.49360687553639,400.60529614807359,430.10563795605697,439.19729512919366]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.12698091591591,400.60529614807376,430.10563795605731,439.19729512919395]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,3.013229155623776,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,0.63337404037952183,0,0,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,-2.2125152486878186E-3,7.3639420376208298E-2,2.113819576125997E-2,null,null,"(Ref. line 55) Load factors published this year indicate an increase in capacity of 0.8% - the impact won't be finalised until we know the December snapshot of AQ and SOQ which will be used to set prices for 18/19.  We have also reduced the forward assumption to a reduction of -2% based on the average of all years tracking to date."]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-1.5775445225853092E-3,0,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-7.4999999999999997E-3,0.02,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-5.2371095785329683E-4,-1.7513438400424096E-3,2.8309684356323563E-3]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.1813770729126424E-2,9.1888076536165889E-2,4.3969164196892327E-2]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"F'Cast","F'Cast","F'Cast"]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"Assumptions","Frequency"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2,null,null,"Internal NGN Treasury view on IBOXX 10 year rate","Annual"]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.18]
[]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,null,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-10.686093517544123,-14.552293314851397,-19.908210400401288,null,null,"Cash Impact of the above vs. allowance","Annual"]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.3476202057198634,-1.3790617652316541,-2.7013801056288003,null,null,"Forecast impact of long term change in Corp. Tax rates","At any time"]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","At any time"]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081601,-2.7942966052081033,null,null,"31.03.2013 valuation impact, and forecasted 2016","3-yearly review"]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","3-yearly review"]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-14.828010328472089,-18.725651685291211,-25.403887111238191]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844,null,null,null,null,null,null,null,null,"Revenue impact via RAV will be over 45 years","One-off"]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,null,17.398062412967949,null,null,null,null,null,null,null,null,"This amount is to be spread over the 8 years of RIIO-GD1","One-off"]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.808761744527652,-1.3733628810600989,-1.5899423343145109,null,null,"Forecasted IQI impact from Totex outperformance"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","Reopener -> Revenue Driver"]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,"Change in allowance directed by Ofgem","1 Reopener (Flexible)"]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,"Change in allowance directed by Ofgem","1 Reopener (Flexible)"]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78079225612011349,-0.73162665283795314,-0.69508151228635329,null,null,"13/14 - 16/17 actual, then assumes  50% of allowance","Annual"]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,null,null,"No current change in revenue allowance forecast","Annual"]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,"As per Ofgem direction from shrinkage model changes","Annual"]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.002887657041148,-2.5479120381988665,-2.8447487788814416]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,0,0,0]
[null,null,null,"Check that it adds down and matches the summary sheet",null,null,null,0,0,0,0,0,0,0,0]

{"sheet":"Mod186 Statement movement","index":9,"n_rows":160,"n_cols":32,"rows_kept":160,"cut":false,"hidden":false,"merged":[[95,3,95,4],[97,3,97,4],[98,3,98,4],[89,3,89,4],[114,3,114,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[110,3,110,4],[112,3,112,4],[113,3,113,4],[148,3,148,4],[150,3,150,4],[151,3,151,4],[153,3,153,4],[1,10,1,15],[47,3,47,4],[48,3,48,4],[49,3,49,4],[115,3,115,4],[116,3,116,4],[118,3,118,4],[130,3,130,4],[135,3,135,4],[136,3,136,4],[108,3,108,4],[109,3,109,4],[1,24,1,29],[1,31,1,39],[45,3,45,4],[46,3,46,4],[7,3,7,4],[1,3,1,4],[1,17,1,22],[3,31,5,39],[46,31,48,39],[17,31,17,39]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,"JUNE MOD186",null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140249519157237,1.3534457004731957,1.3940490714873917,null,null,1.2327329838381795,1.2709189417960116,1.3133898502180597,1.3554183254250376,1.3991305664199949,null,null,0,0,6.3510169766400892E-4,-1.972624951841917E-3,-5.0814949326032366E-3]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,0,0,0,null,null,2.3E-2,3.4000000000000002E-2,null,null,null,null,null,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2,null,null,2.1427497658355055E-2,3.499999999999992E-2,3.3417480081011197E-2,3.2000000000000028E-2,3.224999999999989E-2,null,null,0,0,3.3251991898874955E-4,-2.0000000000000018E-3,-2.2499999999998632E-3,null,null,"Movement between February and August HM Treasury report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,9.9999999999991762E-4,"","","",null,null,-1.5725023416449449E-3,9.9999999999991762E-4,"","","",null,null,0,0,"","",""]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,0,0,0,0,0]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,-6.2324478434481421,-11.079016524139888,-19.554571793368861,-22.173495732598031,-28.396169323769392,null,null,0,0,1.5420298571559208,1.335326556655545,0.55421647222613757,null,null,"Finalised 16/17 Totex actuals and latest forecast impact through Totex Incentive"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,5.3890861274262444E-2,5.6268108628512755E-14,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,-2.6610394064885853E-2,0,null,null,0,0,0,8.05012553391483E-2,5.6268108628512755E-14]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.675641224536605,111.49008526137345,123.40649702044658,null,null,76.602895594612164,84.616406495412889,97.992817560364131,111.60911431337547,124.7766917705361,null,null,0,0,0.68282366417247431,-0.11902905200201985,-1.3701947500895244]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,412.90430561111259,426.92774686571522,436.58195142421414,null,null,405.74788540780747,396.94748949190864,410.67945208978421,425.6309481057225,437.39792970207742,null,null,0,0,2.2248535213283844,1.2967987599927255,-0.81597827786328025]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583303954468199,5.8069421677628705,5.981150432795757,null,null,0.45240792338436564,0.96340416482706637,0.42562722360036376,5.8274159204022657,6.0153500838352381,null,null,0,0,2.058159443182328E-4,-2.0473752639395215E-2,-3.4199651039481083E-2]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937766987509522E-2,-6.1674099920134638E-2,-6.3524322917738685E-2,null,null,0.21262510901874174,0.24439389996628133,-5.9908797539469393E-2,-6.1763988911131704E-2,-6.3755877553515694E-2,null,null,0,0,-2.896944804012952E-5,8.9888990997065432E-5,2.315546357770093E-4]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391031842379761,2.2715064366794158,2.339651629779798,null,null,4.3580661027896449E-2,2.2977955273491282,2.2380209686898764,2.2768204257384697,2.3502478844685339,null,null,0,0,1.0822155480996187E-3,-5.3139890590538919E-3,-1.0596254688735929E-2]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0,0,0,null,null,0,0,0,0,0,null,null,-0.15071466,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,2.6049984567951485,8.0167745045221519,8.2572777396578161,null,null,0.70861369343100389,3.5055935921424757,2.6037393947507708,8.0424723572296042,8.3018420907502559,null,null,-0.15071466,0,1.2590620443777567E-3,-2.5697852707452284E-2,-4.4564351092439836E-2]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310260127886272,2.165854051077365,1.8558880265214446,null,null,0.67553374772655639,3.3793563036027767,1.9300926987772247,1.8128460755617586,1.5260777929398257,null,null,0,0,9.3331401140250847E-4,0.35300797551560636,0.32981023358161887,null,null,"Latest Gemini bookings (a further 14 Gwh reduction) impact on the incentive"]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,null,null,0,0,-1.9018622283355491E-3,-0.11116646373676797,-0.17010780564289707,null,null,"Lower bookings impact on the cost pass through adjustment"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039255584813738,-1.845927455940827,-5.7368476801532049,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0029570102644407,-2.0877689677196654,-5.8965501080919269,null,null,0,0,-9.6854821693304061E-4,0.24184151177883839,0.15970242793872202]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.92964166347367816,0.93437767594001142,null,null,0.63104830905755127,0.55522982323705239,0.56566492100254073,0.61875416863662702,0.61436104957349347,null,null,0,0,0.2961396163781308,0.31088749483705114,0.32001662636651795,null,null,"Impact of finalised 16/17 volumes - 18 Gwh further reduction than forecast"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099516506447442,-7.2917508127408812,-7.6350198214282115,null,null,-5.7074720867072717,-7.208780850335943,-7.0362141281641657,-6.9272492758046305,-7.3549049722594573,null,null,0,0,-0.27373752248057848,-0.36450153693625076,-0.28011484916875418,null,null,"Impact of finalised 16/17 volumes - 18 Gwh further reduction than forecast"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481471132640724,-6.3621091492672033,-6.7006421454882004,null,null,-5.0764237776497207,-6.6535510270988905,-6.4705492071616248,-6.3084951071680031,-6.7405439226859638,null,null,0,0,2.2402093897552433E-2,-5.3614042099200176E-2,3.9901777197763444E-2]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4091212241289091,3.0983210477234864,3.1925927538746204,null,null,2.7280489896020739,3.366405616377834,3.0502608515814709,3.0085042909545647,3.0909542364897487,null,null,0,0,0.35886037254743819,8.9816756768921646E-2,0.10163851738487173,null,null,"Higher than forecast stakeholder engagement award for 16/17"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2963840569788383,5.4855713933858627,null,null,2.819183646010214,3.0799122187215673,3.192177531877407,3.3540080013561226,3.472973382465594,null,null,0,0,1.8474390593949002,1.9423760556227156,2.0125980109202688,null,null,"Impact of finalised 16/17 volumes - 18 Gwh further reduction than forecast"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,0.8,0,0,0.8,0,null,null,0,0,0,0,0]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.5007691837990245,2.6012971253500092,2.6896448052540061,2.7504662939725493,null,null,2.5562116780691873,2.5007691837990245,2.5872805481656407,2.6814749730660519,2.7556069571230877,null,null,-0.14751827806918705,0,1.401657718436855E-2,8.1698321879541957E-3,-5.1406631505384048E-3,null,null,"Finalised 16/17 NIA spend"]
[null,25,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.411240613350806,-0.6526168685756718,-1.1842336658238662E-13,null,null,2.7784430349248272,6.4989282987774661,-10.1021060536889,-6.54178924246238E-2,0,null,null,0,0,-0.30913455966190639,-0.58719897615104799,-1.1842336658238662E-13]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,407.69602572356268,437.96821780641005,443.83036977946341,443.83036977946341,null,411.61306338350113,409.18166530290893,403.53729814504459,435.0557257610165,442.38221233812817,459.56902857000983,null,-0.29823293806919082,0,4.1587275785180964,2.9124920453935488,1.4481574413352405,-15.738658790546424]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,409.81056549398045,407.69602572356285,437.96821780641039,443.83036977946369,443.83036977946352,null,421.35891895000003,409.24470585093388,403.53729814504453,435.05572576101645,442.38244817259852,459.56952311506109,null,0,0.565859643046565,4.1587275785183238,2.9124920453939467,1.4479216068651795,-15.739153335597564]
[null,28,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,10.044088504568094,0.62890019107152284,0,0,0,0,null,9.7458555664989035,6.3040548024957843E-2,0,0,2.3583447034525307E-4,null,null,0.29823293806919082,0.565859643046565,0,0,-2.3583447034525307E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,-3.6307579379111221E-3,7.4251869463582532E-2,1.3384879849077436E-2,null,null,null,null,-1.3794281700491018E-2,7.8105364140697464E-2,1.6840340543262444E-2,null,null,null,null,1.0163523762579896E-2,-3.8534946771149325E-3,-3.4554606941850086E-3,null,null,"Reflects the cash movement shown above in row reference 26"]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-1.5369706035238914E-3,0,0,null,null,null,null,-1.5406493831606605E-4,0,0,null,null,null,null,-1.3829056652078253E-3,0,0,null,null,"Load factors published this year indicate an increase in capacity of 0.8% - the impact won't be finalised until we know the December snapshot of AQ and SOQ which will be used to set prices for 18/19.  We have also reduced the forward assumption to a reduction of -2% based on the average of all years tracking to date."]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-7.4999999999999997E-3,2.0000000000000004E-2,2.0000000000000004E-2,null,null,null,null,0.03,0.03,0.03,null,null,null,null,-3.7499999999999999E-2,-9.999999999999995E-3,-9.999999999999995E-3]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-4.1656217812578548E-4,-1.7084668933655262E-3,5.9803391185916932E-3,null,null,null,null,-1.2412049014065805E-3,-6.6826159459748569E-4,6.3194199175553648E-3,null,null,null,null,8.2464272328079506E-4,-1.0402052987680405E-3,-3.3908079896367155E-4]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1350878274177234E-2,4.262170956228286E-2,-3.5098650983371234E-2,-1.3084290719560798E-2,9.2543402570217009E-2,3.9365218967669133E-2,1.9707241358115791E-2,null,4.2618797603094616E-2,-3.5050122301578224E-2,1.4810448459786334E-2,0.10743710254609998,5.3159760460817808E-2,8.653794832459763E-2,null,2.9119591882439955E-6,-4.8528681793010009E-5,-2.7894739179347133E-2,-1.4893699975882968E-2,-1.3794541493148675E-2,-6.6830706966481843E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,"","","","","",null,13967.493608369672,"","","","","",null,0,0,0,0,0,0]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,129.12132406333461,128.65251579103807,138.2052055997157,140.05506567118493,140.05506567118493,null,129.79446543550341,129.02776961798671,127.24792421669012,137.1866696737826,139.49693990908517,144.91648030709462,null,0,9.3554445347905357E-2,1.4045915743479469,1.0185359259330937,0.55812576209976328,-4.8614146359096821]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (16/17 Prices)","16/17 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,124.75490247665179,120.24372200647292,125.40975063758528,123.386742797837,120.6716310981291,null,125.71683696086805,120.77721932054072,115.25029930743219,120.39919176566238,118.60184563441969,119.27357114740421,null,4.077628474635361,3.9776831561110697,4.9934226990407353,5.0105588719228962,4.7848971634173125,1.3980599507248854]
[null,37,null,"% movement in domestic customer bill - (16/17 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877806E-2,-3.8827256169530977E-2,-3.6160346251909004E-2,4.2962980061730383E-2,-1.6131184612546257E-2,-2.2004889975550168E-2,null,-5.4430842079877917E-2,-3.9291615663738733E-2,-4.5761278858724053E-2,4.4675740446412426E-2,-1.4928224225466025E-2,5.6637020224379331E-3,null,1.1102230246251565E-16,4.6435949420775557E-4,9.6009326068150491E-3,-1.7127603846820438E-3,-1.2029603870802319E-3,-2.7668591997988101E-2]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,8.77,8.77,8.77,8.77,8.77,null,null,0,0,0,0,0,0]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523998828300895,11.869718793149925,12.225810356944423,null,null,10.811068268260835,11.145959119551021,11.518428986412383,11.887018713977579,12.270375067503355,null,null,0,0,5.5698418885121725E-3,-1.7299920827653636E-2,-4.4564710558931964E-2,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,null,null,0,0,-1.9018622283355491E-3,-0.11116646373676797,-0.17010780564289707,0,null,"Lower bookings impact on the cost pass through adjustment"]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,4.6425642213681218E-3,-6.4762778599742681E-15,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,-1.5303440238558523E-3,-9.251825514248955E-16,null,null,0,0,0,6.1729082452239743E-3,-5.5510953085493722E-15,0]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0907295754890702,7.862579850353101,4.6330746502697675,null,null,8.7644464775480895,7.6880584273725372,7.0870615958288941,7.9848733266722993,4.8477471664716019,null,null,0,0,3.6679796601761794E-3,-0.12229347631919829,-0.21467251620183436,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.683584578064516,7.0907295754890765,7.8625798503531126,4.6330746502697675,null,null,9.2451910000000019,7.6895331573333312,7.0870615958288949,7.9850300010242758,4.8477471664716019,null,null,0,-5.9485792688152017E-3,3.6679796601815085E-3,-0.12245015067116327,-0.21467251620183436,0]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-4.4738493080211938E-3,0,1.1546319456101628E-14,0,null,null,0.48074452245191246,1.4747299607940079E-3,0,1.5667435197652679E-4,0,null,null,0,-5.9485792688152017E-3,0,-1.5667435196498047E-4,0,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7695670178147935E-2,0.1088534355522639,-0.41074370773332103,null,null,null,null,-7.8172771086631676E-2,0.12668321259854931,-0.39288364784968943,null,null,null,null,4.7710090848374076E-4,-1.7829777046285411E-2,-1.7860059883631596E-2,0,null,"Reflects the cash movement shown above in row reference 38"]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,5.8192186626632755E-4,0,-1.46851538246484E-15,null,null,null,null,-1.9182085759694337E-4,0,-1.9621394800738926E-5,null,null,null,null,7.7374272386327098E-4,0,1.9621394799270411E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-7.4999999999999997E-3,0.02,0.02,null,null,null,null,0.03,0.03,0.03,null,null,null,null,-3.7499999999999999E-2,-9.9999999999999985E-3,-9.9999999999999985E-3,0,null,"Latest indication on load factors and impact on price change required"]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-2.5117254049654338E-4,-4.6182192291089816E-4,-6.3270136264644405E-3,null,null,null,null,-1.3732001593708965E-3,1.6950243699537237E-3,-9.501122766034098E-3,null,null,null,null,1.1220276188743531E-3,-2.1568462928646219E-3,3.1741091395696575E-3,0]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4864920852378151E-2,0.128391613629353,-0.39707072135978694,null,null,0.38917876005399071,-0.17690890802795603,-4.9737792103599521E-2,0.15837823696850303,-0.37240439201052422,null,null,0,0,-3.512712874877863E-2,-2.9986623339150031E-2,-2.4666329349262717E-2,0]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.55038396788387,401.49360687553639,400.60529614807359,430.10563795605697,439.19729512919366,null,null,402.84861690595307,401.49360687553639,396.45023654921567,427.0708524343442,437.53446517165656,null,null,-0.29823293806919082,0,4.1550595988579175,3.0347855217127631,1.6628299575370988,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.12698091591591,400.60529614807376,430.10563795605731,439.19729512919395,null,null,412.11372795000005,401.55517269360053,396.45023654921562,427.07069575999219,437.53470100612691,null,null,0,0.57180822231538286,4.1550595988581449,3.0349421960651171,1.6625941230670378,0]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,0.63337404037952183,0,0,0,null,null,9.2651110440469893,6.1565818064138966E-2,0,-1.5667435201294211E-4,2.3583447034525307E-4,null,null,0.29823293806919082,0.57180822231538286,0,1.5667435201294211E-4,-2.3583447034525307E-4,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,-2.2125152486878186E-3,7.3639420376208298E-2,2.113819576125997E-2,null,null,null,null,-1.2561520880914445E-2,7.723697216492198E-2,2.4500882412529013E-2,null,null,null,null,1.0349005632226627E-2,-3.5975517887136821E-3,-3.3626866512690423E-3,0,null,"Reflects the cash movement shown above in row reference 46"]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-1.5775445225853092E-3,0,0,null,null,null,null,-1.533419636323735E-4,0,3.6685798414919563E-7,null,null,null,null,-1.4242025589529356E-3,0,-3.6685798414919563E-7,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-7.4999999999999997E-3,0.02,0.02,null,null,null,null,0.03,0.03,0.03,null,null,null,null,-3.7499999999999999E-2,-9.9999999999999985E-3,-9.9999999999999985E-3,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-5.2371095785329683E-4,-1.7513438400424096E-3,2.8309684356323563E-3,null,null,null,null,-1.3410701704948021E-3,-7.3482687003012526E-4,3.3219613850832552E-3,null,null,null,null,8.1735921264150524E-4,-1.0165169700122843E-3,-4.9099294945089897E-4,0]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.1813770729126424E-2,9.1888076536165889E-2,4.3969164196892327E-2,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,1.5944066984958379E-2,0.10650214529489185,5.7823210655596417E-2,null,null,0,0,-2.7757837714084802E-2,-1.4614068758725965E-2,-1.385404645870409E-2,0]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5800000000000002E-2,1.1299999999999999E-2,0,null,0,0,1.0000000000000286E-4,1.9999999999999879E-4,2.0000000000000052E-4,null,null,"Latest internal NGN view on long range Iboxx 10 year index"]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.18,null,null,0.2,0.19,0.19,0.19,0.18,null,null,0,0,0,0,0]
[]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-10.686093517544123,-14.552293314851397,-19.908210400401288,null,null,-5.5790833627772258,-7.3944730844739297,-10.686628331710097,-14.722000417543541,-20.624849417592372,null,null,0,1.0891301940318954E-6,5.3481416597378484E-4,0.16970710269214351,0.7166390171910848,null,null,"Impact of row 58 through the revenue allowance calculations"]
[null,61,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.3476202057198634,-1.3790617652316541,-2.7013801056288003,null,null,-0.19685269418482676,-1.5508191124258197,-1.3844534664004868,-1.1960955798004989,-2.535955725271549,null,null,-3.2414588110327713E-3,-5.4340516721758103E-3,3.6833260680623425E-2,-0.18296618543115528,-0.16542438035725127]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081601,-2.7942966052081033,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081033,-2.7942966052081033,null,null,0,0,0,-5.6843418860808015E-14,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-14.828010328472089,-18.725651685291211,-25.403887111238191,null,null,-5.45623266217018,-8.6255888021078775,-14.865378403318687,-18.712392602552143,-25.955101748072025,null,null,-3.2414588110327713E-3,-5.4329625419811123E-3,3.736807484659721E-2,-1.3259082739068617E-2,0.55121463683383354]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.808761744527652,-1.3733628810600989,-1.5899423343145109,null,null,-1.4566126363418817,-2.7806280473497438,-4.3889206310587134,-2.7313037388832599,-1.601354361620885,null,null,3.3742440941342267E-5,-6.1728400169158704E-14,1.5801588865310614,1.3579408578231611,1.1412027306374029E-2,null,null,"Finalised 16/17 Totex actuals and latest forecast impact through Totex Incentive"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,0,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,0.44039938762580277,0.44703528497319667,0.45423635614167779,0.46189279414852535,0.46990821173807262,null,null,5.6843418860808015E-14,-5.6843418860808015E-14,0,5.6843418860808015E-14,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,0,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,0,-0.86042197470561721,-1.5664219619677056,-2.1006485042972827,-2.4217101462949699,null,null,0,5.6843418860808015E-14,5.6843418860808015E-14,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,0,0,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78079225612011349,-0.73162665283795314,-0.69508151228635329,null,null,-0.72183359008705117,-0.63350022196946565,-0.70529515189831926,-0.72227143440934882,-0.68667132037228429,null,null,1.0081700812403227E-5,6.1506355564233672E-14,-7.5497104221794231E-2,-9.3552184286043172E-3,-8.4101919140689985E-3]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,0,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,-0.30210545545344614,-0.1335774007937971,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,1.2908519582133238E-6,5.6843418860808015E-14,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.002887657041148,-2.5479120381988665,-2.8447487788814416,null,null,-0.58353965791469453,-1.1804643124956833,-1.9273905528194106,-2.538556819770319,-2.8363385869673725,null,null,1.137255282745997E-5,1.1834977442504169E-13,-7.5497104221737388E-2,-9.3552184285474738E-3,-8.4101919140691095E-3]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392,null,null,-3.196343817263525E-3,-5.4329625419242689E-3,1.5420298571559208,1.3353265566555415,0.55421647222613757]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392,null,null,-3.196343817263525E-3,-5.4329625419242689E-3,1.5420298571559208,1.3353265566555415,0.55421647222613757]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]

{"sheet":"High level mod186 rec","index":10,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":true,"merged":[[35,1,35,2],[84,1,84,8]]}
[]
[null,"MOD186 Reconciliation - June 2017 to September 2017"]
[]
[null,"ALLOWED REVENUE",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"JUNE",null,411.61306338350113,409.18166530290893,403.53729814504459,435.0557257610165,442.38221233812817,459.56902857000983]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   June",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5800000000000002E-2,1.1299999999999999E-2]
[null,"Cost of debt %   September",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2]
[null,"Cost of debt £ movement",null,0,1.0891301940318954E-6,5.3481416597378484E-4,0.16970710269214351,0.7166390171910848]
[]
[null,"Totex Incentive",null,3.3742440941342267E-5,-6.1728400169158704E-14,1.5801588865310614,1.3579408578231611,1.1412027306374029E-2]
[]
[null,"Pension deficit valuation",null,0,0,0,-5.6843418860808015E-14,0]
[]
[null,"Tax trigger - Corp. Tax rates long term impact",null,-3.2414588110327713E-3,-5.4340516721758103E-3,3.6833260680623425E-2,-0.18296618543115528,-0.16542438035725127]
[]
[null,"Repex Tier 2a",null,1.0081700812403227E-5,6.1506355564233672E-14,-7.5497104221794231E-2,-9.3552184286043172E-3,-8.4101919140689985E-3]
[]
[null,"FGO Impact",null,0,5.6843418860808015E-14,5.6843418860808015E-14,0,0]
[]
[null,"Ofgem changes to Fuel Poor allowances",null,5.6843418860808015E-14,-5.6843418860808015E-14,0,5.6843418860808015E-14,0]
[]
[null,"\"MOD\" Adjustment",null,-3.1976346692221824E-3,-5.4329625419820005E-3,1.5420298571559212,1.335326556655545,0.55421647222613857]
[]
[null,"Change in Inflation %"]
[null,"June (Based on HM Treasury Feb report)",null,2.1427497658355055E-2,3.499999999999992E-2,3.3417480081011197E-2,3.2000000000000028E-2,3.224999999999989E-2]
[null,"September (Based on HM Treasury August report)",null,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2]
[null,"% RPI Difference between June & September",null,0,0,3.3251991898874955E-4,-2.0000000000000018E-3,-2.2499999999998632E-3]
[null,"Cumulative change in inflation",null,0,0,3.3251991898874955E-4,-1.6674800810112522E-3,-3.9174800810111154E-3]
[]
[null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,3.1976346692221824E-3,5.4329625419820005E-3,0.68282366417246321,-0.11902905200196777,-1.3701947500894749]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 17/18)",null,0,0,0,8.05012553391483E-2,5.6268108628512755E-14]
[]
[null,"Total base revenue changes",null,0,0,2.2248535213283844,1.2967987599927255,-0.81597827786328003]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0.35886037254743819,8.9816756768921646E-2,0.10163851738487173]
[null,"Shrinkage/Leakage",null,0,0,2.1435786757730311,2.2532635504597667,2.3326146372867869]
[null,"DRS",null,0,0,0,0,0]
[null,"Exit",null,0,0,9.3331401140250847E-4,0.35300797551560636,0.32981023358161887]
[null,"Total",null,0,0,2.5033723623318718,2.6960882827442947,2.7640633882532777]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,2.058159443182328E-4,-2.0473752639395215E-2,-3.4199651039481083E-2]
[null,"License Fee",null,0,0,-2.896944804012952E-5,8.9888990997065432E-5,2.315546357770093E-4]
[null,"Pension Deficit",null,0,0,1.0822155480996187E-3,-5.3139890590538919E-3,-1.0596254688735929E-2]
[null,"Exit Capacity",null,0,0,-1.9018622283355491E-3,-0.11116646373676797,-0.17010780564289707]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,-0.27373752248057848,-0.36450153693625076,-0.28011484916875418]
[null,"Others",null,-0.15071466,0,0,0,0]
[null,"Total",null,-0.15071466,0,-0.27438032266453632,-0.50136585338047079,-0.49478700590409125]
[]
[null,"Network Innovation",null,-0.14751827806918705,0,1.401657718436855E-2,8.1698321879541957E-3,-5.1406631505384048E-3]
[]
[null,"K factor",null,0,0,-0.30913455966190639,-0.58719897615104799,-1.1842336658238662E-13]
[]
[null,"SEPTEMBER",null,411.31483044543194,409.18166530290893,407.6960257235628,437.96821780640994,443.83036977946341,443.83036977946341]
[null,"Difference",null,-0.29823293806919082,0,4.1587275785182101,2.9124920453934351,1.4481574413352405,-15.738658790546424]
[]
[null,"COLLECTED REVENUE £",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"June",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"September",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Difference",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"PRICE CHANGE % IMPACT",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"LDZ Price Change %","June",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"LDZ Price Change %","September",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"LDZ PRICE CHANGE %","Difference",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Exit Cap. Price Change %","June",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Exit Cap. Price Change %","September",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"EXIT CAP. PRICE CHANGE %","Difference",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Total Price Change","June",4.2618797603094616E-2,-3.5050122301578224E-2,1.4810448459786334E-2,0.10743710254609998,5.3159760460817808E-2,8.653794832459763E-2]
[null,"Total Price Change","September",4.262170956228286E-2,-3.5098650983371234E-2,-1.3084290719560798E-2,9.2543402570217009E-2,3.9365218967669133E-2,1.9707241358115791E-2]
[null,"TOTAL PRICE CHANGE %","Difference",2.9119591882439955E-6,-4.8528681793010009E-5,-2.7894739179347133E-2,-1.4893699975882968E-2,-1.3794541493148675E-2,-6.6830706966481843E-2]
[]
[null,"21/22 is illustrative only assuming flat revenues year on year.  The final outcome could be significantly different to this."]