{"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 South Wales"]
["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",217.4,233.4,247.7,189.40134124899546,191.29535466148542,193.20830820810028,195.1403912901813,197.09179520308308,199.06271315511395,201.05334028666505,203.06387368953176,"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",239.38553590799998,264.71371482684,288.7983530555325,222.2964173354862,230.80621813427626,239.64143239024173,248.8146617157879,258.33971861448737,268.22904039162603,278.4971605460646,289.1581143415633,"A = A1 * A2 - A3"]
["Pass-Through Business Rates (B1)","RBt","CRC4",-1.2787341590816403,-1.3690245238540903,-1.453784118522007,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Licence Fees (B2)","LFt","CRC4",-0.2874564138664599,-0.29608010628245374,-0.30437034925836237,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Transmission Exit (B3)","TBt","CRC4",-1.6646167212932594,0.5277309073479408,0.5725289928350836,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",-3.2308072942413597,-1.1373737227886034,-1.1856254749452857,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,-3.39,0,-2.7411697532610986,-2.938533975495898,0,0,0,0,0,0,"Assumed Approach C Using RPI and WACC"]
["Quality of service incentive adjustment (C2)","IQt","CRC8",3.822817946515001,2.853735,6.357275232691334,4.8679901442264475,4.9896898978321085,0,0,0,0,0,0,"Actuals And Forecast"]
["Transmission connection point charges incentive adjustment (C3)","ITt","CRC9",-0.47403223649512,-0.4882532035899736,-0.5019242932904929,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Innovation funding incentive adjustment (C4)","IFIt","CRC10",0.1414048,0.11144000000000001,0.08912,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Incentive revenue for Distributed Generation (C5)","IGt","CRC11",0.8921916312502844,1.3077300781572252,1.5396204295331426,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.2765889,0.68,0.37,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
[null,"LCN2t","CRC13",2.1,1.58,1.58,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,6.758971041270165,2.6546518745672514,9.434091368933984,2.126820390965349,2.0511559223362106,0,0,0,0,0,0,"C = C1 + C2 + C3 + C4 + C5 + C6 + C7"]
["Correction Factor (D)","-Kt","CRC3",-2.827249385876024,2.4695069582157942,-5.907212536852508,0,0,0,0,0,0,0,0,"Carried forward from previous year (small variation for interest)"]
["Tax Trigger Mechanism Adjustment (E)","CTRAt","CRC3",-2.0921458979999996,-3.1756572472799998,-13.2282594508647,0,0,0,0,0,0,0,0,"Assumptions Outlined"]
["Total allowed Revenue (F): \n[F= A + B + C + D + E]","ARt",null,237.99430437115274,265.5248426895544,277.911346961804,224.42323772645156,232.85737405661249,239.64143239024173,248.8146617157879,258.33971861448737,268.22904039162603,278.4971605460646,289.1581143415633,"F= A + B + C + D + E"]
["Other 1. Excluded services - Top-up, standby, and enhanced system security (G1)","ES4","CRC15",0.5376539019999993,0.5537835190599993,0.5692894575936793,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,0.5376539019999993,0.5537835190599993,0.5692894575936793,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,238.53195827315272,266.0786262086144,278.4806364193977,224.42323772645156,232.85737405661249,239.64143239024173,248.8146617157879,258.33971861448737,268.22904039162603,278.4971605460646,289.1581143415633,"H = F + G"]
["1. Revenue raised outside CDCM - EDCM and interconnector charges (I1)",null,null,15.605414243174,13.7027974198611,14.341489207844745,11.557584337735628,11.991934376257978,12.34130695967382,12.813719587944593,13.304251003245863,13.813541715028576,14.342340184728844,14.891369215146653,"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,15.605414243174,13.7027974198611,14.341489207844745,11.557584337735628,11.991934376257978,12.34130695967382,12.813719587944593,13.304251003245863,13.813541715028576,14.342340184728844,14.891369215146653,"I = I1 + I2 + I3 + I4"]
["Latest forecast of CDCM Collected Revenue (J): [J =  H - I]",null,null,222.92654402997871,252.37582878875332,264.13914721155294,212.86565338871594,220.8654396803545,227.3001254305679,236.0009421278433,245.0354676112415,254.41549867659745,264.15482036133574,274.26674512641665,"J =  H - I"]
["CDCM Revenue Used in Charging Model",null,null,218.858265756826,257.457520140699,264.13914721155294,212.86565338871594,220.8654396803545,227.3001254305679,236.0009421278433,245.0354676112415,254.41549867659745,264.15482036133574,274.26674512641665,"Assumptions Outlined"]
["Final Collected Revenue Forecast (K)",null,null,236.11087301999999,271.8700110486659,278.4806364193977,224.42323772645156,232.85737405661249,239.64143239024173,248.8146617157879,258.33971861448737,268.22904039162603,278.4971605460646,289.1581143415633,"The units for 13/14 are forecast to be 2% lower than 12/13 on a weather corrected basis – except for Profile class 1 which is forecast to be 1% down."]
["Forecast Over / (Under) Recovery \n[being (K - G - F + I2]",null,null,-2.4210852531527394,5.791384840051478,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.11567729904774415,0.04664913514978175,-0.19246464680229058,0.03758138602581451,0.029133963917242767,0.038278978864590085,0.03828173481826247,0.0382802994064424,0.038281165005275675,0.03828029619618101,"Ft / Ft-1"]
["Overall % change to Use of System Charges effective 1st April of Regulatory Year to balance (M)",null,null,null,0.1514506196656047,0.024315390083786914,-0.19411546665504797,0.03758138602581451,0.029133963917242767,0.038278978864590085,0.03828173481826247,0.0382802994064424,0.038281165005275675,0.03828029619618101,"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",-2.190973946206954,5.791384840051478,13.77374362630991]
["Losses Incentive",null,null,null,0,0,0,-2.7411697532610986,-2.7411697532610986,0]
["Low Carbon Network Fund",null,null,null,1.58,1.9500000000000002,1.9500000000000002,0,0,2.222964173354862]
["Quality of Service",null,null,null,6.357275232691334,6.357275232691334,6.357275232691334,2.853735,4.8679901442264475,6.357275232691334]
["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,269.7673173268157,278.4806364193977,286.83505551197965,215.73671310475837,224.42323772645156,237.80295644377838]

{"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,3.452,0,0,4.12,0,0]
["Domestic Two Rate",2,3.82,0.273,0,4.12,0,0]
["Domestic Off Peak (related MPAN)",2,0.293,0,0,0,0,0]
["Small Non Domestic Unrestricted",3,2.819,0,0,7.08,0,0]
["Small Non Domestic Two Rate",4,3.526,0.317,0,7.08,0,0]
["Small Non Domestic Off Peak (related MPAN)",4,0.325,0,0,0,0,0]
["LV Medium Non-Domestic","5-8",3.367,0.218,0,48.76,0,0]
["LV Sub Medium Non-Domestic","5-8",2.182,0.141,0,4.38,0,0]
["HV Medium Non-Domestic","5-8",2.444,0.16,0,127.44,0,0]
["LV HH Metered",null,16.971,1.406,0.167,10.05,2.75,0.567]
["LV Sub HH Metered",null,12.869,1.049,0.125,7.38,3.22,0.502]
["HV HH Metered",null,12.906,1.036,0.119,75.21,3.26,0.398]
["HV Sub HH Metered",null,10.937,0.875,0.103,75.21,2.57,0.363]
["NHH UMS category A",8,2.574,0,0,0,0,0]
["NHH UMS category B",1,2.991,0,0,0,0,0]
["NHH UMS category C",1,4.98,0,0,0,0,0]
["NHH UMS category D",1,2.274,0,0,0,0,0]
["LV UMS (Pseudo HH Metered)",null,43.642,2.486,0.851,0,0,0]
["LV Generation NHH",8,-0.794,0,0,0,0,0]
["LV Sub Generation NHH",8,-0.728,0,0,0,0,0]
["LV Generation Intermittent",null,-0.794,0,0,0,0,0.26]
["LV Generation Non-Intermittent",null,-6.405,-0.619,-0.104,0,0,0.26]
["LV Sub Generation Intermittent",null,-0.728,0,0,0,0,0.227]
["LV Sub Generation Non-Intermittent",null,-5.866,-0.567,-0.097,0,0,0.227]
["HV Generation Intermittent",null,-0.492,0,0,36.96,0,0.185]
["HV Generation Non-Intermittent",null,-3.926,-0.38,-0.074,36.96,0,0.185]