{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Front Sheet","NIC Funding Request"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Front Sheet","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,3,16,4],[14,3,14,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Electricity Network Innovation Competition Full Submission "]
[null,null,null,null,null," Spreadsheet "]
[]
[null,null,null,null,null,"(2019 version 1.1)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","Western Power Distribution"]
[]
[null,null,"Submission Date:","2019-07-29"]
[]
[]
[]
[null,"Input cells",null," "]
[null,"Totals cells (of formula within worksheet)"]
[null,"Referencing to other worksheets"]
[null,"Check cells"]
[null,"No Input"]
[null,"Descriptions and pack data"]
[null,"Ofgem Input cells"]

{"sheet":"NIC Funding Request","index":1,"n_rows":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","Total"]
["Total Project Cost","From Project Cost Summary sheet"]
[null,"Labour",78.49199999999999,157.96080000000001,116.5008,137.99520000000001,0,0,0,{"$f":"SUM(C4:I4)","v":490.94880000000001}]
[null,"Equipment",0,1003.0464654375,186.01519250000001,0,0,0,0,1189.0616579375001]
[null,"Contractors",597.16784652444449,1307.4936620911112,388.73197911888894,399.97284962555557,0,0,0,2693.3663373600002]
[null,"IT",0,420.15600000000006,0,0,0,0,0,420.15600000000006]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",23.962919822319197,36.304580833333333,28.026266666666665,16.401120000000002,0,0,0,104.69488732231919]
["Payments to users & Contingency",null,69.962276634676371,296.93365083619443,80.227423828555573,62.83611696255555,0,0,0,509.9594682619819]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,44.375,83,93,0,0,0,220.375]
[null,"Total",{"$f":"SUM(C4:C12)","v":769.5850429814401},{"$f":"SUM(D4:D12)","v":3266.2701591981386},{"$f":"SUM(E4:E12)","v":882.50166211411124},{"$f":"SUM(F4:F12)","v":710.20528658811111},{"$f":"SUM(G4:G12)","v":0},0,0,5628.5621508818012]
[]
["External funding","Any funding that will be received from Project Partners and/or External Funders - from Project Cost Summary sheet"]
[null,"Labour",0,0,0,0,0,0,0,{"$f":"SUM(C16:I16)","v":0}]
[null,"Equipment",0,0,0,0,0,0,0,0]
[null,"Contractors",83.007644652444441,174.92550620911109,42.093197911888865,41.227284962555537,0,0,0,341.25363373599993]
[null,"IT",0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C16:C24)","v":83.007644652444441},174.92550620911109,42.093197911888865,41.227284962555537,{"$f":"SUM(G16:G24)","v":0},0,0,341.25363373599993]
[]
["Licensee extra contribution","Any funding from the Licensee which is in excess of the Licensee Compulsory Contribution - from Project Cost Summary sheet"]
[null,"Labour",0,0,0,0,0,0,0,{"$f":"SUM(C28:I28)","v":0}]
[null,"Equipment",0,0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C28:C36)","v":0},0,0,0,{"$f":"SUM(G28:G36)","v":0},0,0,0]
[]
["Initial Net Funding Required"]
[null,"Labour",{"$f":"C4-C16-C28","v":78.49199999999999},{"$f":"D4-D16-D28","v":157.96080000000001},{"$f":"E4-E16-E28","v":116.5008},{"$f":"F4-F16-F28","v":137.99520000000001},{"$f":"G4-G16-G28","v":0},0,0,{"$f":"J4-J16-J28","v":490.94880000000001}]
[null,"Equipment",{"$f":"C5-C17-C29","v":0},{"$f":"D5-D17-D29","v":1003.0464654375},{"$f":"E5-E17-E29","v":186.01519250000001},{"$f":"F5-F17-F29","v":0},{"$f":"G5-G17-G29","v":0},0,0,1189.0616579375001]
[null,"Contractors",{"$f":"C6-C18-C30","v":514.16020187200002},{"$f":"D6-D18-D30","v":1132.5681558820002},{"$f":"E6-E18-E30","v":346.63878120700008},{"$f":"F6-F18-F30","v":358.74556466300004},{"$f":"G6-G18-G30","v":0},0,0,2352.1127036240005]
[null,"IT",{"$f":"C7-C19-C31","v":0},{"$f":"D7-D19-D31","v":420.15600000000006},{"$f":"E7-E19-E31","v":0},{"$f":"F7-F19-F31","v":0},{"$f":"G7-G19-G31","v":0},0,0,420.15600000000006]
[null,"IPR Costs",{"$f":"C8-C20-C32","v":0},{"$f":"D8-D20-D32","v":0},{"$f":"E8-E20-E32","v":0},{"$f":"F8-F20-F32","v":0},{"$f":"G8-G20-G32","v":0},0,0,0]
[null,"Travel & Expenses",{"$f":"C9-C21-C33","v":23.962919822319197},{"$f":"D9-D21-D33","v":36.304580833333333},{"$f":"E9-E21-E33","v":28.026266666666665},{"$f":"F9-F21-F33","v":16.401120000000002},{"$f":"G9-G21-G33","v":0},0,0,104.69488732231919]
["Payments to users & Contingency",null,{"$f":"C10-C22-C34","v":69.962276634676371},{"$f":"D10-D22-D34","v":296.93365083619443},{"$f":"E10-E22-E34","v":80.227423828555573},{"$f":"F10-F22-F34","v":62.83611696255555},{"$f":"G10-G22-G34","v":0},0,0,509.9594682619819]
[null,"Decommissioning",{"$f":"C11-C23-C35","v":0},{"$f":"D11-D23-D35","v":0},{"$f":"E11-E23-E35","v":0},{"$f":"F11-F23-F35","v":0},{"$f":"G11-G23-G35","v":0},0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",{"$f":"C12-C24-C36","v":0},{"$f":"D12-D24-D36","v":44.375},{"$f":"E12-E24-E36","v":83},{"$f":"F12-F24-F36","v":93},{"$f":"G12-G24-G36","v":0},0,0,220.375,"in Project Cost Summary"]
[null,"Total",{"$f":"C13-C25-C37","v":686.57739832899563},3091.3446529890275,840.40846420222238,668.97800162555552,{"$f":"G13-G25-G37","v":0},0,0,{"$f":"J13-J25-J37","v":5287.3085171458015},"OK"]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0,0,0,0,0,0,{"$f":"SUM(C52:I52)","v":0}]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits"]
[null,"Labour",7.8492000000000006,15.796080000000002,11.650079999999999,13.799520000000001,0,0,0,{"$f":"SUM(C57:I57)","v":49.094880000000003}]
[null,"Equipment",0,100.30464654375001,18.601519250000003,0,0,0,0,118.90616579375001]
[null,"Contractors",51.416020187200012,113.2568155882,34.663878120700012,35.874556466300007,0,0,0,235.21127036240006]
[null,"IT",0,42.015600000000006,0,0,0,0,0,42.015600000000006]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",2.3962919822319195,3.630458083333334,2.8026266666666668,1.6401120000000005,0,0,0,10.469488732231921]
["Payments to users & Contingency",null,6.9962276634676366,29.693365083619447,8.022742382855558,6.473691696255556,0,0,0,51.186026826198201]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"of Total Initial Net Funding Required"]
[null,"Other",0,4.4375,8.3000000000000007,9.3000000000000007,0,0,0,22.037500000000001,{"$f":"IF(J66>=J49*0.1,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C57:C65)","v":68.65773983289958},309.1344652989028,84.040846420222238,67.087880162555564,{"$f":"SUM(G57:G65)","v":0},0,0,528.92093171458009,"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J66>=J52,\"OK\",\"ERROR\")","v":"OK"}]
["Outstanding Funding required"]
[null,"Labour",{"$f":"C40-C57","v":70.642799999999994},142.16472000000002,104.85072,{"$f":"F40-F57","v":124.19568000000001},0,0,0,{"$f":"SUM(C70:I70)","v":441.85392000000002}]
[null,"Equipment",0,902.74181889375006,167.41367325000002,0,0,0,0,1070.1554921437501]
[null,"Contractors",462.74418168480003,1019.3113402938002,311.97490308630006,322.87100819670002,0,0,0,2116.9014332616002]
[null,"IT",0,378.14040000000006,0,0,0,0,0,378.14040000000006]
[null,"IPR Costs",0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",21.566627840087278,32.674122749999995,25.223639999999996,14.761008000000002,0,0,0,94.225398590087281]
["Payments to users & Contingency",null,62.966048971208735,267.24028575257501,72.204681445700018,56.362425266299994,0,0,0,458.77344143578375]
[null,"Decommissioning",0,0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,39.9375,74.7,83.7,0,0,0,198.33750000000001,"Total Outstanding Funding required"]
[null,"Total",617.91965849609608,2782.2101876901247,756.36761778200014,601.89012146300001,0,0,0,4758.3875854312209,"OK"]
[]
["balance",4715.78659101228,0,{"$f":"B81-C79-D79","v":1315.6567448260589},{"$f":"D81-E79+D82","v":589.44634372325049},{"$f":"E81-F79+E82","v":-2.9182622970029737},{"$f":"F81-G79+F82","v":1.4378110128263621E-2},{"$f":"G81-H79+G82","v":-1.413108061099292E-4},{"$f":"H81-I79+H82","v":-7.0126809499160736E-5},{"$f":"G81-G79+G82","v":-1.413108061099292E-4},{"$f":"B81","v":4715.78659101228}]
["interest",null,0,{"$f":"((B81+D81)/2)*$D86","v":30.157216679191698},{"$f":"((D81+E81)/2)*$D86","v":9.5255154427465474},{"$f":"((E81+F81)/2)*$D86","v":2.9326404071312373},{"$f":"((F81+G81)/2)*$D86","v":-1.4519420934373551E-2},{"$f":"((G81+H81)/2)*$D86","v":7.1183996610768466E-5},-1.0571880780454496E-6,{"$f":"((G81+J81)/2)*$D86","v":7.1183996610768466E-5},{"$f":"SUM(D82:J82)","v":42.600994418940246}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K81+K82","v":4758.38758543122}]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,null,null,{"$f":"K81","v":4715.78659101228}]
[null,"interest rate used in calculation",null,{"$f":"D85+0.5%","v":0.01}]
[null,"RPI adjustment","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,"Annual inflation ",2.75E-2,3.2000000000000001E-2,3.1800000000000002E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2]
["n.b the NIC Funding Request calculation should use the Bank of England Base rate plus 0.5% on 30 June of the year in which the Full Submission is made."]
[]
[]
[null,null,"Bank of England Base Rate: https://www.bankofengland.co.uk/boeapps/iadb/Repo.asp "]
[null,null,"RPI Forecast 2018/19-202223: https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-may-2019"]
[null,null,"RPI for 2024/25 and thereafter is an extension from 2023/24 as no further consistent forecast is available. "]