{"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 West Midlands"]
["Date: 01/08/2013"]
[]
["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",367.5,381.6,399.7,365.49098981155703,369.1458997096725,372.8373587067693,376.56573229383696,380.33138961677537,384.13470351294313,387.9760505480726,391.8558110535533,"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",404.66506185,432.79671627216004,466.01817406659814,428.9691776611996,445.3906850092391,462.44014824067835,480.14188490132113,498.52254921425424,517.6061416590387,537.4207077756326,557.9933316512448,"A = A1 * A2 - A3"]
["Pass-Through Business Rates (B1)","RBt","CRC4",-1.7520456575931824,-1.8261545073209788,-1.9773249375259638,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Licence Fees (B2)","LFt","CRC4",-0.09458865036158004,-0.09742630987242729,-0.10015424654885519,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Transmission Exit (B3)","TBt","CRC4",-0.44866312449202006,-0.43960161210176807,-2.078256634907193,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.2952974324467825,-2.363182429295174,-4.155735818982012,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,-11.21,0,-5.246306003835484,-5.624040036111639,0,0,0,0,0,0,"Assumed Approach C Using RPI and WACC"]
["Quality of service incentive adjustment (C2)","IQt","CRC8",4.269842667230175,26.05678352392499,29.779684761259052,28.756142802858086,29.47504637292954,0,0,0,0,0,0,"Actuals And Forecast"]
["Transmission connection point charges incentive adjustment (C3)","ITt","CRC9",0,-0.9325064071799473,-7.202741679357394,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",0.45110136622543817,0.6304723606043994,0.7192818817141821,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.5330016,0.575,0.88,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
[null,"LCN2t","CRC13",4.7,3.54,3.54,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,10.236755233455614,18.882629477349443,27.894544963615836,23.5098367990226,23.851006336817903,0,0,0,0,0,0,"C = C1 + C2 + C3 + C4 + C5 + C6 + C7"]
["Correction Factor (D)","-Kt","CRC3",10.084567100872194,-0.14560567154645015,1.135812403891524,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.321355304,-0.22683266052,-8.648374761829636,0,0,0,0,0,0,0,0,"Assumptions Outlined"]
["Total allowed Revenue (F): \n[F= A + B + C + D + E]","ARt",null,421.369731447881,448.94372498814784,482.24442085329383,452.4790144602222,469.241691346057,462.44014824067835,480.14188490132113,498.52254921425424,517.6061416590387,537.4207077756326,557.9933316512448,"F= A + B + C + D + E"]
["Other 1. Excluded services - Top-up, standby, and enhanced system security (G1)","ES4","CRC15",3.4947808237399998,3.5996242484521996,3.7004137274088613,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,3.4947808237399998,3.5996242484521996,3.7004137274088613,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,424.864512271621,452.5433492366,485.9448345807027,452.4790144602222,469.241691346057,462.44014824067835,480.14188490132113,498.52254921425424,517.6061416590387,537.4207077756326,557.9933316512448,"H = F + G"]
["1. Revenue raised outside CDCM - EDCM and interconnector charges (I1)",null,null,3.02413853711502,4.164738,4.472130508372271,4.164145929674904,4.318412161906412,4.255817837898794,4.418726198967267,4.58788270355064,4.763508227084197,4.945860871529197,5.135189890636434,"Linked to Allowed Revenue"]
["2. Revenue raised outside CDCM - Voluntary under-recovery (I2)",{"$nulls":13},"None"]
["3. Revenue raised outside CDCM - blank or if required please provide description (I3)",{"$nulls":13},"None"]
["4. Revenue raised outside CDCM - blank or if required please provide description (I4)",{"$nulls":13},"None"]
["Total Revenue to be raised outside the CDCM (I): [I = I1 + I2 + I3 + I4]",null,null,3.02413853711502,4.164738,4.472130508372271,4.164145929674904,4.318412161906412,4.255817837898794,4.418726198967267,4.58788270355064,4.763508227084197,4.945860871529197,5.135189890636434,"I = I1 + I2 + I3 + I4"]
["Latest forecast of CDCM Collected Revenue (J): [J =  H - I]",null,null,421.840373734506,448.3786112366,481.47270407233043,448.31486853054724,464.9232791841506,458.18433040277955,475.7231587023539,493.9346665107036,512.8426334319545,532.4748469041034,552.8581417606084,"J =  H - I"]
["CDCM Revenue Used in Charging Model",null,null,415.776728897485,445.927423260896,481.47270407233043,448.31486853054724,464.9232791841506,458.18433040277955,475.7231587023539,493.9346665107036,512.8426334319545,532.4748469041034,552.8581417606084,"Assumptions Outlined"]
["Final Collected Revenue Forecast (K)",null,null,425.0072629299999,451.4298076641574,485.9448345807027,452.4790144602222,469.241691346057,462.44014824067835,480.14188490132113,498.52254921425424,517.6061416590387,537.4207077756326,557.9933316512448,"The units for 13/14 are forecast to be 1% lower than 12/13 on a weather corrected basis."]
["Forecast Over / (Under) Recovery \n[being (K - G - F + I2]",null,null,0.14275065837892953,-1.1135415724426139,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.06543895178592685,0.0741756572408383,-0.06172265578605163,0.03704630789525476,-0.014494754474752347,0.03827897886458986,0.03828173481826247,0.038280299406442175,0.03828116500527612,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.06216963105995066,0.07645712872868793,-0.06886752927285766,0.03704630789525476,-0.014494754474752347,0.03827897886458986,0.03828173481826247,0.038280299406442175,0.03828116500527612,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",-14.689842049540614,-1.1135415724426139,12.462758904655386]
["Losses Incentive",null,null,null,0,0,0,-5.246306003835484,-5.246306003835484,0]
["Low Carbon Network Fund",null,null,null,3.54,4.42,4.42,0,0,4.2896917766119955]
["Quality of Service",null,null,null,29.779684761259052,29.779684761259052,29.779684761259052,4.269842667230175,28.756142802858086,29.779684761259052]
["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,470.51288954328163,485.9448345807027,500.52317961812383,415.1529328948564,452.4790144602222,476.9297108250428]

{"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.432,0,0,3.91,0,0]
["Domestic Two Rate",2,2.818,0.103,0,3.91,0,0]
["Domestic Off Peak (related MPAN)",2,0.202,0,0,0,0,0]
["Small Non Domestic Unrestricted",3,1.92,0,0,6.65,0,0]
["Small Non Domestic Two Rate",4,2.291,0.088,0,6.65,0,0]
["Small Non Domestic Off Peak (related MPAN)",4,0.335,0,0,0,0,0]
["LV Medium Non-Domestic","5-8",2.204,0.082,0,35.05,0,0]
["LV Sub Medium Non-Domestic","5-8",2.007,0.066,0,17.17,0,0]
["HV Medium Non-Domestic","5-8",1.243,0.02,0,302.42,0,0]
["LV HH Metered",null,10.246,0.626,0.055,9.29,3.31,0.377]
["LV Sub HH Metered",null,8.974,0.475,0.033,6.82,4.21,0.309]
["HV HH Metered",null,6.799,0.305,0.018,69.53,4.7,0.212]
["HV Sub HH Metered",null,6.649,0.321,0.017,69.53,4.56,0.226]
["NHH UMS category A",8,2.069,0,0,0,0,0]
["NHH UMS category B",1,2.608,0,0,0,0,0]
["NHH UMS category C",1,4.401,0,0,0,0,0]
["NHH UMS category D",1,1.751,0,0,0,0,0]
["LV UMS (Pseudo HH Metered)",null,37.776,1.378,0.726,0,0,0]
["LV Generation NHH",8,-0.636,0,0,0,0,0]
["LV Sub Generation NHH",8,-0.532,0,0,0,0,0]
["LV Generation Intermittent",null,-0.636,0,0,0,0,0.263]
["LV Generation Non-Intermittent",null,-4.951,-0.51,-0.057,0,0,0.263]
["LV Sub Generation Intermittent",null,-0.532,0,0,0,0,0.234]
["LV Sub Generation Non-Intermittent",null,-4.173,-0.423,-0.045,0,0,0.234]
["HV Generation Intermittent",null,-0.327,0,0,34.17,0,0.192]
["HV Generation Non-Intermittent",null,-2.649,-0.249,-0.02,34.17,0,0.192]