{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Table1","Table2","Illustrative Prices t+1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Table1","index":0,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[17,0,20,0],[26,0,28,0]],"flags":["formulas_cached_only"]}
["Schedule 15 table 1"]
["Company Name: WPD Mid East"]
["Date:01/08/2012"]
[]
["Description","Licence Term","CRC",{"$nulls":11},"Assumptions"]
["Regulatory Year",null,null,"t-1","t","t+1","t+2","t+3","t+4","t+5","t+6","t+7","t+8","t+9"]
["Regulatory Year",null,null,"2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","Please specify year (i.e. 2013/14)"]
["Base Demand Before Inflation (A1)","PUt","CRC3",364.1,381.3,398.7,366.8088142162737,370.4769023584364,374.1816713820208,377.9234880958409,381.7027229767994,385.5197502065674,389.3749477086331,393.2686971857194,"Actual Base Demand Up To 2014/15. Forecast Base Demand 2015/16 and 2016/17"]
["RPI Effective % (A2)","PIADt","CRC3",1.10112942,1.1341633026,1.1659198750728,1.173679214041285,1.206543768627884,1.2403267468815544,1.2750546417926922,1.3107583618500938,1.3474599845457556,1.3851904183684733,1.4239761563086435," Inflation assumed to be 4.69% for 2011/12 base income, 5.18% for 2012/13, 3.00% for 2013/14, 2.8% thereafter.."]
["Merger adjustment (A3)","MGt","CRC3",{"$nulls":11},"Zero Merger Adjustment"]
["Base Demand Revenue (A): \n[A = A1 * A2 - A3]","BRt","CRC3",400.921221822,432.45646728138,464.85225419152533,430.5158807727718,446.99659796113247,464.1075352079647,481.87309773908726,500.32003588278974,519.4724366554249,539.3584467187239,560.0052478150286,"A = A1 * A2 - A3"]
["Pass-Through Business Rates (B1)","RBt","CRC4",-2.3142160918766805,-2.438495074632982,-2.611511436722708,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Licence Fees (B2)","LFt","CRC4",-0.13379670948535982,-0.13781061076992085,-0.14166930787147858,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Transmission Exit (B3)","TBt","CRC4",-0.3393430907786197,-0.11687739844197864,-0.24420271074385802,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Price Control Reopener (B4)","UNCt","CRC4",0,0,0,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Others (B5)","MPTt, HBt, IEDt","CRC4",0,0,0,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Allowed Pass-Through Items (B): \n[B = B1 + B2 + B3 +B4 + B5]","PTt","CRC3",-2.78735589214066,-2.6931830838448816,-2.9973834553380447,0,0,0,0,0,0,0,0,"B = B1 + B2 + B3 +B4 + B5"]
["Losses Incentive (C1)","UILt","CRC7",0,0,0,0,0,0,0,0,0,0,0,"Zero Assumed Due To OFGEM Decision Not To Activate DPCR5 Losses"]
[null,"PCOLt","CRC7",0,0,0,0,0,0,0,0,0,0,0,"Zero Assumed Due To OFGEM Decision Not To Activate DPCR5 Losses"]
[null,"-COLt","CRC7",0,0,0,0,0,0,0,0,0,0,0,"Zero Assumed Due To OFGEM Decision Not To Activate DPCR5 Losses"]
[null,"PPLt","CRC7",0,-44.52,0,10.374625526812181,11.121598564742659,0,0,0,0,0,0,"Assumed Approach C Using RPI and WACC"]
["Quality of service incentive adjustment (C2)","IQt","CRC8",8.340378625159222,18.221877185399993,25.359322119565817,22.580678375583894,23.14519533497349,0,0,0,0,0,0,"Actuals And Forecast"]
["Transmission connection point charges incentive adjustment (C3)","ITt","CRC9",0,-8.593256383183535,-12.01281244152711,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Innovation funding incentive adjustment (C4)","IFIt","CRC10",0.2828096,0.22288000000000002,0.17832000000000003,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Incentive revenue for Distributed Generation (C5)","IGt","CRC11",1.7116401371210905,2.2374688633285515,2.5429159160180053,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Connection Guaranteed Standards Systems & Processes penalty (C6)","CGSRAt,CGSSPt & AUMt","CRC12",0,0,0,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Low Carbon Networks Fund (C7)","LCN1t","CRC13",0.4866372,0.63,0.88,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
[null,"LCN2t","CRC13",5.1,3.77,3.77,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
[null,"LCN3t","CRC13",0,0,0,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Incentive Revenue and Other Adjustments (C): \n[C = C1 + C2 + C3 + C4 + C5 + C6 + C7]",null,null,15.921465562280313,-28.03103033445499,20.71774559405671,32.955303902396075,34.26679389971615,0,0,0,0,0,0,"C = C1 + C2 + C3 + C4 + C5 + C6 + C7"]
["Correction Factor (D)","-Kt","CRC3",17.868649321407844,-2.946077647668326,-11.104265048968326,0,0,0,0,0,0,0,0,"Carried forward from previous year (small variation for interest)"]
["Tax Trigger Mechanism Adjustment (E)","CTRAt","CRC3",-1.10112942,0,-4.9962401836356785,0,0,0,0,0,0,0,0,"Assumptions Outlined"]
["Total allowed Revenue (F): \n[F= A + B + C + D + E]","ARt",null,430.82285139354747,398.7861762154118,466.47211109764004,463.4711846751679,481.2633918608486,464.1075352079647,481.87309773908726,500.32003588278974,519.4724366554249,539.3584467187239,560.0052478150286,"F= A + B + C + D + E"]
["Other 1. Excluded services - Top-up, standby, and enhanced system security (G1)","ES4","CRC15",2.7033360971699993,2.784436180085099,2.862400393127482,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Other 2. Excluded services - Revenue protection services (G2)","ES5","CRC15",null,null,null,0,0,0,0,0,0,0,0,"None"]
["Other 3. Excluded services - Miscellaneous (G3)","ES7","CRC15",null,null,null,0,0,0,0,0,0,0,0,"None"]
["Other 4. - blank or if required please provide description (G4)",{"$nulls":5},0,0,0,0,0,0,0,0,"None"]
["Other 5. - blank or if required please provide description (G5)",{"$nulls":5},0,0,0,0,0,0,0,0,"None"]
["Total Other Revenue to be recovered by Use of System Charges (G): [G = G1 + G2 + G3 + G4 +G5]",null,null,2.7033360971699993,2.784436180085099,2.862400393127482,0,0,0,0,0,0,0,0,"G = G1 + G2 + G3 + G4 +G5"]
["Total Revenue for Use of System Charges (H): \n[H =F + G]",null,null,433.52618749071746,401.5706123954969,469.3345114907675,463.4711846751679,481.2633918608486,464.1075352079647,481.87309773908726,500.32003588278974,519.4724366554249,539.3584467187239,560.0052478150286,"H = F + G"]
["1. Revenue raised outside CDCM - EDCM and interconnector charges (I1)",null,null,9.97029279350202,10.8043262958801,12.627525639425013,12.469771824430376,12.948474214556155,12.486892944807886,12.964878455926584,13.461196494927373,13.976495127122142,14.51153164327894,15.067037372843904,"Linked to Allowed Revenue"]
["2. Revenue raised outside CDCM - Voluntary under-recovery (I2)",{"$nulls":5},0,0,0,0,0,0,0,0,"None"]
["3. Revenue raised outside CDCM - blank or if required please provide description (I3)",{"$nulls":5},0,0,0,0,0,0,0,0,"None"]
["4. Revenue raised outside CDCM - blank or if required please provide description (I4)",{"$nulls":5},0,0,0,0,0,0,0,0,"None"]
["Total Revenue to be raised outside the CDCM (I): [I = I1 + I2 + I3 + I4]",null,null,9.97029279350202,10.8043262958801,12.627525639425013,12.469771824430376,12.948474214556155,12.486892944807886,12.964878455926584,13.461196494927373,13.976495127122142,14.51153164327894,15.067037372843904,"I = I1 + I2 + I3 + I4"]
["Latest forecast of CDCM Collected Revenue (J): [J =  H - I]",null,null,423.5558946972154,390.76628609961676,456.7069858513425,451.0014128507375,468.3149176462925,451.6206422631568,468.9082192831607,486.85883938786236,505.49594152830275,524.846915075445,544.9382104421848,"J =  H - I"]
["CDCM Revenue Used in Charging Model",null,null,421.226122206498,401.0249965270705,456.7069858513425,451.0014128507375,468.3149176462925,451.6206422631568,468.9082192831607,486.85883938786236,505.49594152830275,524.846915075445,544.9382104421848,"Assumptions Outlined"]
["Final Collected Revenue Forecast (K)",null,null,436.41449891000013,412.45714675723053,469.3345114907675,463.4711846751679,481.2633918608486,464.1075352079647,481.87309773908726,500.32003588278974,519.4724366554249,539.3584467187239,560.0052478150286,"The units for 13/14 are forecast to be 2% lower than 12/13 on a weather corrected basis."]
["Forecast Over / (Under) Recovery \n[being (K - G - F + I2]",null,null,2.8883114192826724,10.886534361733652,0,0,0,0,0,0,0,0,0,"being K - G - F + I2"]
["Forecast overall percentage change to Allowed Revenue (L)",null,null,null,-0.07436159682456323,0.16972989265722793,-0.006433238667603924,0.0383890256265893,-0.03564754133188741,0.03827897886458986,0.03828173481826269,0.038280299406442175,0.0382811650052759,0.03828029619618056,"Ft / Ft-1"]
["Overall % change to Use of System Charges effective 1st April of Regulatory Year to balance (M)",null,null,null,-0.054895866687761474,0.13789884641522443,-0.012492852479515482,0.0383890256265893,-0.03564754133188741,0.03827897886458986,0.03828173481826269,0.038280299406442175,0.0382811650052759,0.03828029619618056,"Assumptions Outlined"]

{"sheet":"Table2","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,9],[1,1,1,3],[1,4,1,6],[1,7,1,9]],"flags":["formulas_cached_only"]}
["Description"]
["Regulatory Year","Regulatory Year t",null,null,"Regulatory Year t+1",null,null,"Regulatory Year t+2"]
["£m","Low (P10)","Central","High (P90)","Low (P10)","Central","High (P90)","Low (P10)","Central","High (P90)"]
["Under/over recovery",-1.1605840101312541,10.886534361733652,22.933652733598556]
["Losses Incentive",null,null,null,0,0,0,0,10.374625526812181,10.374625526812181]
["Low Carbon Network Fund",null,null,null,3.77,4.65,4.65,0,0,4.305158807727718]
["Quality of Service",null,null,null,25.359322119565817,25.359322119565817,25.359322119565817,8.340378625159222,22.580678375583894,25.359322119565817]
["Price Control Reopeners",null,null,null,0,0,0,0,0,0]
["Significant others (please specify)",null,null,null,0,0,0,0,0,0]
["Final Collected Revenue Forecast",null,null,null,454.4008761460445,469.3345114907675,483.41454683549057,425.69057161599306,463.4711846751679,484.67163684368387]

{"sheet":"Illustrative Prices t+1","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["2014/15","PCs","Unit rate 1 p/kWh","Unit rate 2 p/kWh","Unit rate 3 p/kWh","Fixed charge p/MPAN/day","Capacity charge p/kVA/day","Reactive power charge p/kVArh"]
["Domestic Unrestricted",1,2.314,0,0,2.97,0,0]
["Domestic Two Rate",2,2.728,0.054,0,2.97,0,0]
["Domestic Off Peak (related MPAN)",2,0.487,0,0,0,0,0]
["Small Non Domestic Unrestricted",3,1.802,0,0,5.59,0,0]
["Small Non Domestic Two Rate",4,1.928,0.042,0,5.59,0,0]
["Small Non Domestic Off Peak (related MPAN)",4,0.284,0,0,0,0,0]
["LV Medium Non-Domestic","5-8",1.985,0.041,0,29.74,0,0]
["LV Sub Medium Non-Domestic","5-8",2.065,0.039,0,3.86,0,0]
["HV Medium Non-Domestic","5-8",1.244,0.011,0,270.81,0,0]
["LV HH Metered",null,10.19,0.489,0.03,8.86,2.4,0.364]
["LV Sub HH Metered",null,8.757,0.355,0.021,6.51,3.16,0.301]
["HV HH Metered",null,6.493,0.182,0.009,66.31,4.05,0.197]
["HV Sub HH Metered",null,5.673,0.119,0.004,66.31,3.62,0.175]
["NHH UMS category A",8,1.938,0,0,0,0,0]
["NHH UMS category B",1,2.544,0,0,0,0,0]
["NHH UMS category C",1,4.286,0,0,0,0,0]
["NHH UMS category D",1,1.56,0,0,0,0,0]
["LV UMS (Pseudo HH Metered)",null,36.92,1.215,0.652,0,0,0]
["LV Generation NHH",8,-0.74,0,0,0,0,0]
["LV Sub Generation NHH",8,-0.632,0,0,0,0,0]
["LV Generation Intermittent",null,-0.74,0,0,0,0,0.258]
["LV Generation Non-Intermittent",null,-6.256,-0.515,-0.033,0,0,0.258]
["LV Sub Generation Intermittent",null,-0.632,0,0,0,0,0.23]
["LV Sub Generation Non-Intermittent",null,-5.392,-0.428,-0.027,0,0,0.23]
["HV Generation Intermittent",null,-0.446,0,0,32.59,0,0.183]
["HV Generation Non-Intermittent",null,-3.942,-0.27,-0.015,32.59,0,0.183]