{"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 West"]
["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",281.6,305,327.9,273.17469233404086,275.90643925738124,278.6655036499551,281.4521586864546,284.26668027331914,287.10934707605236,289.9804405468128,292.8802449522809,"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",310.078044672,345.919807293,382.30512703637106,320.6194581945869,332.8931950103011,345.63627761025873,358.86688137573736,372.6049281636202,386.8683563740395,401.67812775971385,417.054485465883,"A = A1 * A2 - A3"]
["Pass-Through Business Rates (B1)","RBt","CRC4",-1.2312605780523604,-1.2067895515141558,-1.1292655319410159,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Licence Fees (B2)","LFt","CRC4",-0.06785641386645991,-0.06989210628245368,-0.07184908525836231,0,0,0,0,0,0,0,0,"Actuals  and Forecast"]
["Pass-Through Transmission Exit (B3)","TBt","CRC4",0.2611866078305205,0.19238611140543682,0.22770153467625853,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",-1.0379303840882999,-1.0842955463911728,-0.9734130825231198,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,-4.55,0,0.26597425455642143,0.28512440088448376,0,0,0,0,0,0,"Assumed Approach C Using RPI and WACC"]
["Quality of service incentive adjustment (C2)","IQt","CRC8",3.602739595079082,4.785405527699998,4.336249493757937,4.721201610832415,4.8392316511032245,0,0,0,0,0,0,"Actuals And Forecast"]
["Transmission connection point charges incentive adjustment (C3)","ITt","CRC9",-0.5688386837941439,-0.5859038443079684,-0.30310915194859134,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Innovation funding incentive adjustment (C4)","IFIt","CRC10",0.23567516,0.18568,0.14856,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
["Incentive revenue for Distributed Generation (C5)","IGt","CRC11",1.2287478232627111,1.8318389936522743,2.1706323937931353,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.1584963,0.345,0.53,0,0,0,0,0,0,0,0,"Actuals And Forecast"]
[null,"LCN2t","CRC13",3,2.23,2.23,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,7.65682019454765,4.242020677044304,9.11233273560248,4.987175865388836,5.124356051987708,0,0,0,0,0,0,"C = C1 + C2 + C3 + C4 + C5 + C6 + C7"]
["Correction Factor (D)","-Kt","CRC3",-3.431775338090747,-1.9732496549972904,-4.4540810257974774,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.5325976659999996,-3.74273889858,-16.251120020877735,0,0,0,0,0,0,0,0,"Assumptions Outlined"]
["Total allowed Revenue (F): \n[F= A + B + C + D + E]","ARt",null,310.73256147836855,343.3615438700759,369.73884564277523,325.60663405997576,338.0175510622888,345.63627761025873,358.86688137573736,372.6049281636202,386.8683563740395,401.67812775971385,417.054485465883,"F= A + B + C + D + E"]
["Other 1. Excluded services - Top-up, standby, and enhanced system security (G1)","ES4","CRC15",2.146162946340003,1.6747070556678,1.7215988532264985,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.146162946340003,1.6747070556678,1.7215988532264985,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,312.87872442470854,345.0362509257437,371.46044449600174,325.60663405997576,338.0175510622888,345.63627761025873,358.86688137573736,372.6049281636202,386.8683563740395,401.67812775971385,417.054485465883,"H = F + G"]
["1. Revenue raised outside CDCM - EDCM and interconnector charges (I1)",null,null,4.023647,4.556681,4.905649030051515,4.300086031291689,4.463989358971851,4.5646051824170275,4.739333607719966,4.920763520105981,5.109131820963937,5.304715339235963,5.507781413658337,"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,4.023647,4.556681,4.905649030051515,4.300086031291689,4.463989358971851,4.5646051824170275,4.739333607719966,4.920763520105981,5.109131820963937,5.304715339235963,5.507781413658337,"I = I1 + I2 + I3 + I4"]
["Latest forecast of CDCM Collected Revenue (J): [J =  H - I]",null,null,308.85507742470855,340.47956992574365,366.55479546595024,321.30654802868406,333.553561703317,341.0716724278417,354.1275477680174,367.6841646435142,381.75922455307557,396.3734124204779,411.54670405222464,"J =  H - I"]
["CDCM Revenue Used in Charging Model",null,null,305.094059,343.5115825339725,366.55479546595024,321.30654802868406,333.553561703317,341.0716724278417,354.1275477680174,367.6841646435142,381.75922455307557,396.3734124204779,411.54670405222464,"Assumptions Outlined"]
["Final Collected Revenue Forecast (K)",null,null,314.81328291,349.4029970294667,371.46044449600174,325.60663405997576,338.0175510622888,345.63627761025873,358.86688137573736,372.6049281636202,386.8683563740395,401.67812775971385,417.054485465883,"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,1.9345584852914612,4.366746103723017,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.10500664055440079,0.07682078043859275,-0.11936049485435452,0.03811629034569064,0.022539440700716673,0.03827897886458986,0.03828173481826247,0.0382802994064424,0.038281165005275675,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.10987374420715068,0.06312895897877735,-0.12344197374296617,0.03811629034569064,0.022539440700716673,0.03827897886458986,0.03828173481826247,0.0382802994064424,0.038281165005275675,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",-5.984341424049292,4.366746103723017,14.717833631495326]
["Losses Incentive",null,null,null,0,0,0,0,0.26597425455642143,0.26597425455642143]
["Low Carbon Network Fund",null,null,null,2.23,2.76,2.76,0,0,3.2061945819458693]
["Quality of Service",null,null,null,4.336249493757937,4.336249493757937,4.336249493757937,3.602739595079082,4.721201610832415,4.785405527699998]
["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,359.8025311611217,371.46044449600174,382.6042578308818,314.49553185597597,325.60663405997576,338.74334353555287]

{"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.591,0,0,4.26,0,0]
["Domestic Two Rate",2,4.361,0.259,0,4.26,0,0]
["Domestic Off Peak (related MPAN)",2,0.22,0,0,0,0,0]
["Small Non Domestic Unrestricted",3,2.728,0,0,6.77,0,0]
["Small Non Domestic Two Rate",4,3.088,0.238,0,6.77,0,0]
["Small Non Domestic Off Peak (related MPAN)",4,0.233,0,0,0,0,0]
["LV Medium Non-Domestic","5-8",2.766,0.229,0,35.91,0,0]
["LV Sub Medium Non-Domestic","5-8",2.633,0.206,0,22.36,0,0]
["HV Medium Non-Domestic","5-8",2.846,0.134,0,150.64,0,0]
["LV HH Metered",null,26.519,0.29,0.163,8.53,2.61,0.412]
["LV Sub HH Metered",null,24.471,0.172,0.117,6.27,2.89,0.345]
["HV HH Metered",null,20.711,0.073,0.072,63.85,2.23,0.273]
["HV Sub HH Metered",null,18.837,0.035,0.054,63.85,1.57,0.203]
["NHH UMS category A",8,2.385,0,0,0,0,0]
["NHH UMS category B",1,3.641,0,0,0,0,0]
["NHH UMS category C",1,6.28,0,0,0,0,0]
["NHH UMS category D",1,1.416,0,0,0,0,0]
["LV UMS (Pseudo HH Metered)",null,85.305,1.062,0.786,0,0,0]
["LV Generation NHH",8,-0.659,0,0,0,0,0]
["LV Sub Generation NHH",8,-0.609,0,0,0,0,0]
["LV Generation Intermittent",null,-0.659,0,0,0,0,0.149]
["LV Generation Non-Intermittent",null,-7.615,-0.302,-0.159,0,0,0.149]
["LV Sub Generation Intermittent",null,-0.609,0,0,0,0,0.128]
["LV Sub Generation Non-Intermittent",null,-7.142,-0.265,-0.144,0,0,0.128]
["HV Generation Intermittent",null,-0.375,0,0,31.38,0,0.094]
["HV Generation Non-Intermittent",null,-4.941,-0.097,-0.078,31.38,0,0.094]