{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Front Sheet","NIC Funding Request","2024-2025","2025-2026"],"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,"(2018 version 1.0)"]
[null,null,null,null,null,"Appendix A"]
[]
[]
[]
[null,null,"Licensee Name:","Western Power Distribution"]
[]
[null,null,"Submission Date:","02.08.2018"]
[]
[]
[]
[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":12,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["NIC Funding Request"]
[null," ","2018/19","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",33.426000000000002,298.07600000000002,344.10200000000003,803.64199999999983,194.15299999999996,27.74,0,0,1701.1389999999999]
[null,"Equipment",0,0,2765,3110,100,0,0,0,5975]
[null,"Contractors",0,1362.3400000000001,1081.3400000000001,614.34,307.84000000000003,2.5,0,0,3368.3600000000006]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",3.7140000000000004,52.564,57.678000000000004,108.738,41.016999999999996,10.86,0,0,274.57100000000003]
["Payments to users & Contingency",null,3.7140000000000004,171.298,424.81199999999995,463.67199999999997,64.301000000000002,4.1099999999999994,0,0,1131.9069999999997]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,120,0,0,120]
[null,"Total",40.853999999999999,1884.2780000000002,4672.9319999999998,5100.3919999999998,707.31100000000004,165.20999999999998,0,0,12570.976999999999]
[]
["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,0,0]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0]
[null,"Total",0,0,0,0,0,0,0,0,0]
[]
["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,0,0]
[null,"Equipment",0,0,0,0,0,0,0,0,0]
[null,"Contractors",0,0,0,0,0,0,0,0,0]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0,0,0,0,0,0,0,0,0]
["Payments to users & Contingency",null,0,0,0,0,0,0,0,0,0]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0]
[null,"Other",0,0,0,0,0,0,0,0,0]
[null,"Total",0,0,0,0,0,0,0,0,0]
[]
["Initial Net Funding Required"]
[null,"Labour",33.426000000000002,298.07600000000002,344.10200000000003,803.64199999999983,194.15299999999996,27.74,0,0,1701.1389999999999]
[null,"Equipment",0,0,2765,3110,100,0,0,0,5975]
[null,"Contractors",0,1362.3400000000001,1081.3400000000001,614.34,307.84000000000003,2.5,0,0,3368.3600000000006]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",3.7140000000000004,52.564,57.678000000000004,108.738,41.016999999999996,10.86,0,0,274.57100000000003]
["Payments to users & Contingency",null,3.7140000000000004,171.298,424.81199999999995,463.67199999999997,64.301000000000002,4.1099999999999994,0,0,1131.9069999999997]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"Check Total = to Initial Net Funding request "]
[null,"Other",0,0,0,0,0,120,0,0,120,"in Project Cost Summary"]
[null,"Total",40.853999999999999,1884.2780000000002,4672.9319999999998,5100.3919999999998,707.31100000000004,165.20999999999998,0,0,12570.976999999999,"OK"]
[]
["Direct Benefits","from Direct Benefits sheet"]
[null,"Total",0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Licensee Compulsory Contribution / Direct Benefits",null,"from Project Cost Summary sheet"]
[null,"Labour",3.3426000000000005,29.807600000000004,34.410200000000017,80.364200000000011,19.415299999999995,2.774,0,0,170.11390000000003]
[null,"Equipment",0,0,276.5,311,10,0,0,0,597.5]
[null,"Contractors",0,136.23400000000001,108.134,61.434000000000005,30.784000000000002,0.25,0,0,336.83600000000001]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",0.37140000000000006,5.2564000000000002,5.7677999999999994,10.873800000000003,4.1017000000000001,1.0860000000000001,0,0,27.457100000000004]
["Payments to users & Contingency",null,0.37140000000000006,17.129800000000003,42.481199999999994,46.36719999999999,6.4300999999999995,0.41100000000000003,0,0,113.19069999999998]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"of Total Initial Net Funding Required"]
[null,"Other",0,0,0,0,0,12,0,0,12,"OK"]
[null,"Total",4.0854000000000008,188.42780000000005,467.29320000000007,510.03919999999999,70.731099999999984,16.521000000000001,0,0,1257.0977,"Check that Total is = or > than "]
[null,null,null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,null,null,"OK"]
["Outstanding Funding required"]
[null,"Labour",30.083400000000001,268.26840000000004,309.6918,723.27779999999984,174.73769999999996,24.965999999999998,0,0,1531.0250999999996]
[null,"Equipment",0,0,2488.5,2799,90,0,0,0,5377.5]
[null,"Contractors",0,1226.1060000000002,973.20600000000013,552.90600000000006,277.05600000000004,2.25,0,0,3031.5240000000003]
[null,"IT",0,0,0,0,0,0,0,0,0]
[null,"IPR Costs",0,0,0,0,0,0,0,0,0]
[null,"Travel & Expenses",3.3426000000000005,47.307600000000001,51.910200000000003,97.864199999999997,36.915299999999995,9.7739999999999991,0,0,247.1139]
["Payments to users & Contingency",null,3.3426000000000005,154.16820000000001,382.33079999999995,417.3048,57.870900000000006,3.6989999999999994,0,0,1018.7162999999999]
[null,"Decommissioning",0,0,0,0,0,0,0,0,0,"Check that Total is =to "]
[null,"Other",0,0,0,0,0,108,0,0,108,"Total Outstanding Funding required"]
[null,"Total",36.768599999999999,1695.8502000000003,4205.6387999999997,4590.3527999999997,636.57990000000007,148.68899999999996,0,0,11313.879300000001,"OK"]
[]
["balance",11103.0598046287,0,9370.4410046286994,5267.1697086749864,750.00496224150515,143.51093559608756,-0.71048491472443764,3.5173386823779129E-3,-1.7499197832385703E-5,11103.0598046287]
["interest",null,0,102.367504046287,73.188053566518434,30.085873354582461,4.4675794891879637,0.71400225340681556,-3.5348378802102986E-3,1.7499197422727637E-5,210.81949537129989]
[null,null,null,null,null,null,null,null,null,null,11313.879299999999,0]
[]
[null,"Bank of England interest rate",null,5.0000000000000001E-3,null,null,"NIC FUNDING REQUEST   £",null,null,null,11103.0598046287]
[null,"interest rate used in calculation",null,0.01]
[null,"RPI adjustment","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,"Annual inflation ",3.3000000000000002E-2,0.03,3.0499999999999999E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-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,null,"Bank of England Base Rate: https://www.bankofengland.co.uk/boeapps/iadb/Repo.asp "]
[null,null,null,"RPI Forecast 2018/19-202223: https://www.gov.uk/government/statistics/forecasts-for-the-uk-economy-may-2018 "]
[null,null,null,"RPI for 2023/24 and thereafter is an extension from 2022/23 as no further consistent forecast is available. "]

{"sheet":"2024-2025","index":2,"n_rows":255,"n_cols":90,"rows_kept":255,"cut":false,"hidden":true,"merged":[[3,69,3,78],[3,80,3,89],[3,6,3,15],[3,17,3,23],[3,25,3,34],[3,36,3,45],[3,47,3,56],[3,58,3,67]]}
[null,"Project Costs in 2024-2025"]
[]
[]
[null,null,null,null,null,null,"Total Cost £K",null,null,null,null,null,null,null,null,null,null,"Funding source %",null,null,null,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Project Partner 1",null,null,null,null,null,null,null,null,null,null,"Project Partner 2",null,null,null,null,null,null,null,null,null,null,"Project Partner 3",null,null,null,null,null,null,null,null,null,null,"Licensee Extra Contribution",null,null,null,null,null,null,null,null,null,null,"Outstanding Funding Required"]
[null,null,null,null,null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:W7)","v":0},null,{"$f":"$R7*G7","v":0},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R8:W8)","v":0},null,{"$f":"$R8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$S8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$T8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$U8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$V8*G8","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"$W8*G8","v":0},0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G9:P9)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z8)","v":0},{"$f":"SUM(AA7:AA8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK8)","v":0},{"$f":"SUM(AL7:AL8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV8)","v":0},{"$f":"SUM(AW7:AW8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG8)","v":0},{"$f":"SUM(BH7:BH8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR8)","v":0},{"$f":"SUM(BS7:BS8)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC8)","v":0},{"$f":"SUM(CD7:CD8)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]

{"sheet":"2025-2026","index":3,"n_rows":274,"n_cols":90,"rows_kept":274,"cut":false,"hidden":true,"merged":[[3,69,3,78],[3,80,3,89],[3,6,3,15],[3,17,3,23],[3,25,3,34],[3,36,3,45],[3,47,3,56],[3,58,3,67]]}
[null,"Project Costs in 2025-2026"]
[]
[]
[null,null,null,null,null,null,"Total Cost £K",null,null,null,null,null,null,null,null,null,null,"Funding source %",null,null,null,null,null,null,null,"Licensee Compulsory Contribution/Direct Benefits",null,null,null,null,null,null,null,null,null,null,"Project Partner 1",null,null,null,null,null,null,null,null,null,null,"Project Partner 2",null,null,null,null,null,null,null,null,null,null,"Project Partner 3",null,null,null,null,null,null,null,null,null,null,"Licensee Extra Contribution",null,null,null,null,null,null,null,null,null,null,"Outstanding Funding Required"]
[null,null,null,null,null,null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Licensee Compulsory Contribution\n/Direct Benefits","Project Partner 1","Project Partner 2","Project Partner 3","Licensee Extra Contribution","Oustanding Funding Required","Total",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other",null,"Labour","Equipment","Contractors","IT","IPR Costs","Travel & Expenses","Payments to users","Contingency","Decommissioning","Other"]
[null,"Description","Task","Project Workstream"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:W7)","v":0},null,{"$f":"$R7*G7","v":0},{"$f":"$R7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$S7*G7","v":0},{"$f":"$S7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$T7*G7","v":0},{"$f":"$T7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$U7*G7","v":0},{"$f":"$U7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$V7*G7","v":0},{"$f":"$V7*H7","v":0},0,0,0,0,0,0,0,0,null,{"$f":"$W7*G7","v":0},{"$f":"$W7*H7","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$R8*G8","v":0},{"$f":"$R8*H8","v":0},{"$f":"$R8*I8","v":0},{"$f":"$R8*J8","v":0},{"$f":"$R8*K8","v":0},{"$f":"$R8*L8","v":0},{"$f":"$R8*M8","v":0},{"$f":"$R8*N8","v":0},{"$f":"$R8*O8","v":0},{"$f":"$R8*P8","v":0},null,{"$f":"$S8*G8","v":0},{"$f":"$S8*H8","v":0},{"$f":"$S8*I8","v":0},{"$f":"$S8*J8","v":0},{"$f":"$S8*K8","v":0},{"$f":"$S8*L8","v":0},{"$f":"$S8*M8","v":0},{"$f":"$S8*N8","v":0},{"$f":"$S8*O8","v":0},{"$f":"$S8*P8","v":0},null,{"$f":"$T8*G8","v":0},{"$f":"$T8*H8","v":0},{"$f":"$T8*I8","v":0},{"$f":"$T8*J8","v":0},{"$f":"$T8*K8","v":0},{"$f":"$T8*L8","v":0},{"$f":"$T8*M8","v":0},{"$f":"$T8*N8","v":0},{"$f":"$T8*O8","v":0},{"$f":"$T8*P8","v":0},null,{"$f":"$U8*G8","v":0},{"$f":"$U8*H8","v":0},{"$f":"$U8*I8","v":0},{"$f":"$U8*J8","v":0},{"$f":"$U8*K8","v":0},{"$f":"$U8*L8","v":0},{"$f":"$U8*M8","v":0},{"$f":"$U8*N8","v":0},{"$f":"$U8*O8","v":0},{"$f":"$U8*P8","v":0},null,{"$f":"$V8*G8","v":0},{"$f":"$V8*H8","v":0},{"$f":"$V8*I8","v":0},{"$f":"$V8*J8","v":0},{"$f":"$V8*K8","v":0},{"$f":"$V8*L8","v":0},{"$f":"$V8*M8","v":0},{"$f":"$V8*N8","v":0},{"$f":"$V8*O8","v":0},{"$f":"$V8*P8","v":0},null,{"$f":"$W8*G8","v":0},{"$f":"$W8*H8","v":0},{"$f":"$W8*I8","v":0},{"$f":"$W8*J8","v":0},{"$f":"$W8*K8","v":0},{"$f":"$W8*L8","v":0},{"$f":"$W8*M8","v":0},{"$f":"$W8*N8","v":0},{"$f":"$W8*O8","v":0},{"$f":"$W8*P8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,null,null,null,null,{"$f":"SUM(R27:W27)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,"Total",null,null,null,null,{"$f":"SUM(G7:G27)","v":0},{"$f":"SUM(H7:H27)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(G28:P28)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Z7:Z27)","v":0},{"$f":"SUM(AA7:AA27)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AK7:AK27)","v":0},{"$f":"SUM(AL7:AL27)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(AV7:AV27)","v":0},{"$f":"SUM(AW7:AW27)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BG7:BG27)","v":0},{"$f":"SUM(BH7:BH27)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(BR7:BR27)","v":0},{"$f":"SUM(BS7:BS27)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(CC7:CC27)","v":0},{"$f":"SUM(CD7:CD27)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totals"]