{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Review Log","Model Guide","Glossary","Check Summary","Name labels","Inputs >","Target Revenue","Allocator Data","Asset Mapping","Calculations >","Pricing Area Allocations","RAB Allocations","RAB - Depreciation Allocations","Load Group Allocations","Outputs >","Rev - Pricing Area & Cust Group","Pricing Methodology Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":1,"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":"Review Log","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[1,"Updated Commerce Act Levies in Target Revenue to agree to compliance model"]
[2,"Allocator Data Tab - Assumed ID references were for 2023 not 2022."]
[3,"Renamed connection charge to include new investment contracts"]
[4,"Deleted Te Anau from Allocator Data and Asset Mapping"]
[5,"Changed Cost Type for IRIS penalties to recoverable and passthrough"]

{"sheet":"Model Guide","index":1,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[[85,1,85,7],[16,1,16,7],[77,1,77,7],[65,1,65,7],[69,1,69,7],[70,1,70,7],[71,1,71,7]]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Model Guide"}]
[]
[]
[null,"Key"]
[]
[null,"Input cell",1000]
[null,"Source Reference","xxx"]
[null,"Calculation cell",1000]
[null,"Calculated percentage","%"]
[null,"Total",1000]
[null,"Check cell - no error",0]
[null,"Check cell - error",{"$f":"SUM(C11)","v":1000}]
[]
[null,"Pricing Process"]
[]
[null,"Aurora Energy’s pricing process is designed to support an efficient level of investment in our network for the long-term benefit of customers, and to comply with the Electricity Authority’s 2019 pricing principles. Prices are set to signal the underlying costs of supplying services, using a five step process as outlined below. This Cost of Supply Model (CoSM) is used for steps 2 and 3 of the pricing process."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model flow diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model overview"]
[]
[null,"The purpose of this model is to allocate the target revenue to:\n1. Pricing areas based on the underlying costs of supply,\n2. Customer load groups based on service characteristics.\nA detailed rationale for allocating costs is provided in our Pricing Methodology."]
[]
[null,"The model has 3 key steps:"]
[]
[null,"1. Target revenue is entered by component and then allocated to pricing areas based on a proxy allocator of the cost driver.\nFor example, capital related costs are allocated to each pricing area based on the relative RAB value in each pricing area. "]
[null,"2. The RAB and RAB depreciation are allocated to customer load groups based on each load group's use of network assets,\nfor example larger customers make proportionately more use of HV assets than smaller customers."]
[null,"3. Each pricing area's target revenue is further allocated to customer load groups based on underlying service characteristics and use of the network."]
[]
[null,"Input sheet guide"]
[]
[null,"Target revenue"]
[]
[null,"In the Target Revenue sheet:\n1. Each component of target revenue is entered, with totals reconciling to the Annual Price-Setting Disclosure Statement. \n2. For each component of target revenue a pricing area allocator is selected to determine what proportion of this target revenue is allocated to each pricing area.\n3. For each component of target revenue a load group allocator is selected to determine how each component of target revenue is allocated to customer load groups within each pricing area.\n4. Each component of target revenue is assigned as being either distribution or passthrough. This determines whether the component of target revenue is recovered through distribution tariffs, or passthrough tariffs. \n5. Each component of target revenue is assigned a cost type. The cost type is used for reporting purposes only, and does not impact prices.\n6. The model scales distribution revenue components to match the limit on forecast revenue from prices as disclosed in the annual price-setting statement. Passthrough and recoverable revenue components are not scaled."]
[]
[null,"Allocator Data"]
[]
[null,"In the Allocator Data sheet the allocators are input at the pricing area and where possible, customer load group level."]
[]
[null,"Asset Mapping"]
[]
[null,"In the Asset Mapping sheet:\n1. Each asset category is identified as supporting either the LV, or HV network. \n2. For each customer load group there is a flag to indicate whether they are supplied from the LV, or HV network.\n3. The model determines each load group's share of network assets based on the relative CPD values of each customer load group."]

{"sheet":"Glossary","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Glossary"}]
[]
[]
[null,"Abbreviation","Definition"]
[null,"ACOT","Avoided Cost of Transmission"]
[null,"Capex","Capital Expenditure"]
[null,"CoSM","Cost of Supply Model"]
[null,"CPD","Control Period Demand"]
[null,"CPP","Customised Pricing-quality Path"]
[null,"FENZ","Fire Emergency New Zealand"]
[null,"HV","High Voltage"]
[null,"ICP","Installation Control Point, and is further defined in the Code"]
[null,"IRIS","Incremental Rolling Incentive Scheme"]
[null,"km","kilometre"]
[null,"kVA","kilovolt-ampere"]
[null,"LV","Low Voltage"]
[null,"MWh","Megawatt Hours"]
[null,"Opex","Operating Expenditure"]
[null,"RAB","Regulatory Asset Base"]
[null,"SONS","System Operations and Network Support"]

{"sheet":"Check Summary","index":3,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Check Summary"}]
[null,"Description"]
[]
[null,"This sheet provides a summary of the checks witin the Workbook."]
[]
[]
[null,"Model Status","Flag","Check"]
[]
[null,"Model Status","Ok / Error",{"$f":"SUM(D12:D35)","v":0}]
[]
[null,"Target Revenue"]
[null,"Scaled revenue is equal to limit on forecast revenue from prices","Ok / Error",{"$f":"'Target Revenue'!J49","v":0}]
[]
[null,"Asset Mapping"]
[null,"Network types are fully allocated","Ok / Error",{"$f":"'Asset Mapping'!B135","v":0}]
[]
[null,"Pricing Area Allocations"]
[null,"Target revenue is fully allocated to pricing areas","Ok / Error",{"$f":"'Pricing Area Allocations'!B62","v":0}]
[]
[null,"RAB Allocations"]
[null,"RAB is fully allocated to pricing areas and load groups","Ok / Error",{"$f":"'RAB Allocations'!C23","v":0}]
[]
[null,"RAB - Depreciation Allocations"]
[null,"RAB is fully allocated to pricing areas and load groups","Ok / Error",{"$f":"'RAB - Depreciation Allocations'!C23","v":0}]
[]
[null,"Price Allocations"]
[null,"Pricing area load group totals match pricing area allocations","Ok / Error",{"$f":"SUM('Load Group Allocations'!G320:I320)","v":0}]
[]
[null,"Revenue by Pricing Area and Load Group"]
[null,"Distribution and passthrough by load group matches target revenue","Ok / Error",{"$f":"'Rev - Pricing Area & Cust Group'!C46","v":0}]
[]
[null,"Pricing Methodology Tables"]
[null,"Table updates match model inputs","Ok / Error",{"$f":"'Pricing Methodology Tables'!C47","v":0}]

{"sheet":"Name labels","index":4,"n_rows":93,"n_cols":5,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Name labels"}]
[]
[null,"Description"]
[]
[null,"This sheet records the name labels and look-up tables used in the model."]
[]
[null,"Pricing Area Name","Customer Load Groups","Prior year","This Year"]
[]
[null,"Dunedin","Load group Streetlighting","RY25","RY26"]
[null,"Central Otago","Load group 1 (incl residential)"]
[null,"Queenstown","Load group 2"]
[null,"Te Anau","Load group 3"]
[null,null,"Load group 4"]
[null,null,"Load group 5"]
[]
[null,"Target Revenue Components","Distribution / Passthrough","Cost type","Tariff Types"]
[]
[null,"Service interruptions and emergencies","Distribution","Operational costs","Daily Fixed Price"]
[null,"Vegetation management","Distribution","Operational costs","Capacity Price"]
[null,"Routine and corrective maintenance and inspection","Distribution","Operational costs","Distance Price"]
[null,"System operations and network support","Distribution","Operational costs","CPD Price"]
[null,"Business support","Distribution","Operational costs"]
[null,"Depreciation","Distribution","Capital related costs"]
[null,"Asset revaluations and other regulatory revenue","Distribution","Capital related costs"]
[null,"Tax","Distribution","Capital related costs"]
[null,"Return on capital","Distribution","Capital related costs"]
[null,"Local Authority rates","Passthrough","Passthrough and recoverable costs"]
[null,"Commerce Act levies","Passthrough","Passthrough and recoverable costs"]
[null,"Electricity Authority levies","Passthrough","Passthrough and recoverable costs"]
[null,"Utilities Disputes levies","Passthrough","Passthrough and recoverable costs"]
[null,"Opex Incentive Amount","Passthrough","Passthrough and recoverable costs"]
[null,"Capex Incentive Amount","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower  - Connection charge","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower - Interconnection costs","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower - New investment contract","Passthrough","Passthrough and recoverable costs"]
[null,"Distributed Generation Allowance","Passthrough","Passthrough and recoverable costs"]
[null,"CPP recoverable costs","Passthrough","Passthrough and recoverable costs"]
[null,"Quality Incentive Adjustments","Passthrough","Passthrough and recoverable costs"]
[null,"Capex Wash-up Adjustment","Passthrough","Passthrough and recoverable costs"]
[null,"Fire and Emergency Management New Zealand (FENZ) levies","Passthrough","Passthrough and recoverable costs"]
[null,"Opening wash-up Account Balance","Passthrough","Operational costs"]
[null,"Transmission Costs","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower - Benefit-based Charge","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower - Residual Charge","Passthrough","Passthrough and recoverable costs"]
[null,"Transpower - Transitional Price Cap ","Passthrough","Passthrough and recoverable costs"]
[]
[null,"Pricing Area Allocators","Load Group Allocators","RAB Allocators"]
[]
[null,"ICP Count","ICP Count","CPD"]
[null,"Total Circuit Length","CPD"]
[null,"Overhead Circuit Length","Prior year distribution revenue"]
[null,"CPD","MWh"]
[null,"Transpower connection charge and NIC","Regulated Asset Base"]
[null,"Transpower benefit based charge","Regulated Asset Base (Depreciation)"]
[null,"Transpower residual charge"]
[null,"Transpower transitional price cap"]
[null,"Distributed Generation Allowance"]
[null,"Prior year distribution revenue"]
[null,"MWh"]
[null,"BBC"]
[null,"Residual"]
[null,"Cap"]
[null,"Regulated Asset Base"]
[null,"Regulated Asset Base (Depreciation)"]
[null,"Overhead lines and underground cables"]
[]
[null,"Distribution / Passthrough","Cost type"]
[]
[null,"Distribution","Capital related costs"]
[null,"Passthrough","Operational costs"]
[null,null,"Passthrough and recoverable costs"]
[]
[null,"Asset Categories","Network Voltage","Network Use Indicators"]
[]
[null,"33KV Lines","LV","Yes"]
[null,"33KV Cables","HV","No"]
[null,"Zone Subs","Shared"]
[null,"HV lines"]
[null,"LV lines"]
[null,"HV cables"]
[null,"LV cables"]
[null,"Dist Subs"]
[null,"Other Network Assets"]
[null,"Non-Network Assets"]
[]
[null,"Tariff Types"]
[]
[null,"Daily Fixed"]
[null,"CPD"]
[null,"Capacity"]
[null,"Distance"]
[null,"Shared"]

{"sheet":"Inputs >","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This sheet has been deliberately left blank."]

{"sheet":"Target Revenue","index":6,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[44,11,44,21],[14,11,14,21],[16,11,21,21],[22,11,24,21],[25,11,25,21],[26,11,43,21]]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Target Revenue"}]
[]
[]
[]
[]
[]
[null,"Description"]
[]
[null,"In this sheet the target revenue is input at the cost category and cost item level consistent with the annual price-setting statement and the Commerce Commission's financial models."]
[null,"The Pricing Area and Load Group Allocators are selected to determine how costs are allocated."]
[null,"The target revenue is then scaled to match the total revenue allowable."]
[null,"More information about the target revenue components is provided in section 3.4 of the Pricing Methodology."]
[null,null,null,null,null,null,null,null,"UPDATED 23/09/2024"]
[null,{"$f":"'Name labels'!B17","v":"Target Revenue Components"},null,{"$f":"'Name labels'!B48","v":"Pricing Area Allocators"},{"$f":"'Name labels'!C48","v":"Load Group Allocators"},"Tariff Type",{"$f":"'Name labels'!B68","v":"Distribution / Passthrough"},{"$f":"'Name labels'!C68","v":"Cost type"},"RY25 inputs ($000's)","RY26 inputs ($000's)","Scaled target revenue","Source & comments"]
[]
[null,{"$f":"'Name labels'!B19","v":"Service interruptions and emergencies"},{"$f":"CONCATENATE(\"(50% allocated by \",D17,\")\")","v":"(50% allocated by Total Circuit Length)"},"Total Circuit Length","CPD","Capacity",{"$f":"VLOOKUP(B17,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B17,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},2428.559865193195,2428.6394886804651,2499.589294425185,"Aurora CPP Expenditure Model With ComCom Adjustments - Final Decision - 31 March 2021 (published on Commerce Commission website). Sheet CPP model output"]
[null,{"$f":"'Name labels'!B19","v":"Service interruptions and emergencies"},{"$f":"CONCATENATE(\"(50% allocated by \",D18,\")\")","v":"(50% allocated by ICP Count)"},"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B18,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B18,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},2428.559865193195,2428.6394886804651,2499.589294425185]
[null,{"$f":"'Name labels'!B20","v":"Vegetation management"},null,"Overhead Circuit Length","CPD","Distance",{"$f":"VLOOKUP(B19,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B19,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},3937.8806306512301,3921.7983618609001,4036.3690230236125]
[null,{"$f":"'Name labels'!B21","v":"Routine and corrective maintenance and inspection"},null,"Total Circuit Length","CPD","Capacity",{"$f":"VLOOKUP(B20,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B20,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},9569.8618079384305,9757.8686518572395,10042.933145191289]
[null,{"$f":"'Name labels'!B22","v":"System operations and network support"},null,"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B21,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B21,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},15090.42708243243,14505.971470039452,14929.746123599474]
[null,{"$f":"'Name labels'!B23","v":"Business support"},null,"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B22,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B22,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Operational costs"},15270.33301220449,15402.917218007879,15852.895071704652]
[null,{"$f":"'Name labels'!B24","v":"Depreciation"},null,"Regulated Asset Base (Depreciation)","Regulated Asset Base (Depreciation)","Capacity",{"$f":"VLOOKUP(B23,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B23,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Capital related costs"},23086.187750556201,24551.6844866479,25268.932663313164,"Aurora CPP Financial Model With ComCom Adjustments - Final Decision - 31 March 2021 (published on Commerce Commission website). \nSheet RABx\nSheet TAXx"]
[null,{"$f":"'Name labels'!B25","v":"Asset revaluations and other regulatory revenue"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B24,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B24,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Capital related costs"},-14969.489381004101,-16167.272790798501,-16639.580380819727]
[null,{"$f":"'Name labels'!B26","v":"Tax"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B25,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B25,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Capital related costs"},6800.9859366589799,7219.4668265752998,7430.3749384269559]
[null,{"$f":"'Name labels'!B27","v":"Return on capital"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B26,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Distribution"},{"$f":"VLOOKUP(B26,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Capital related costs"},30078.693430175954,49796.286798448891,51251.025919518645,"Amount required to balance to Forecast net allowable revenue "]
[null,{"$f":"'Name labels'!B28","v":"Local Authority rates"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B27,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B27,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},1641.4639999999999,1833.3620000000001,1833.3620000000001,"Annual Price-Setting Compliance Statement - Table 6"]
[null,{"$f":"'Name labels'!B29","v":"Commerce Act levies"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B28,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B28,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},450.29,444.392,444.392]
[null,{"$f":"'Name labels'!B30","v":"Electricity Authority levies"},{"$f":"CONCATENATE(\"(80% allocated by \",D29,\")\")","v":"(80% allocated by MWh)"},"MWh","MWh","Capacity",{"$f":"VLOOKUP(B29,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B29,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},236.1104,309.54640000000001,309.54640000000001]
[null,{"$f":"'Name labels'!B30","v":"Electricity Authority levies"},{"$f":"CONCATENATE(\"(20% allocated by \",D30,\")\")","v":"(20% allocated by ICP Count)"},"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B30,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B30,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},59.0276,77.386600000000001,77.386600000000001]
[null,{"$f":"'Name labels'!B31","v":"Utilities Disputes levies"},null,"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B31,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B31,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},67.266999999999996,70.724000000000004,70.724000000000004]
[null,{"$f":"'Name labels'!B32","v":"Opex Incentive Amount"},null,"Prior year distribution revenue","Prior year distribution revenue","Daily Fixed",{"$f":"VLOOKUP(B32,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B32,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},28434.583384023699,29264.873218837201,29264.873218837201]
[null,{"$f":"'Name labels'!B33","v":"Capex Incentive Amount"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B33,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B33,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},-1581.40721004899,0,0]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B34","v":"Transpower  - Connection charge"},"Transpower connection charge and NIC","MWh","Capacity",{"$f":"VLOOKUP(B34,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B34,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},5381.7443300000004,6633.4082500000004,6633.4082500000004]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B44","v":"Transpower - Benefit-based Charge"},"Transpower benefit based charge","MWh","Capacity",{"$f":"VLOOKUP(B35,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B35,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},2713.7791426608401,2934.3718949331483,2934.3718949331483]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B45","v":"Transpower - Residual Charge"},"Transpower residual charge","MWh","Capacity",{"$f":"VLOOKUP(B36,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B36,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},17310.83239,19938.975939999997,19938.975939999997]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B46","v":"Transpower - Transitional Price Cap "},"Transpower transitional price cap","MWh","Capacity",{"$f":"VLOOKUP(B37,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B37,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},16.746749999999999,12.783419999999996,12.783419999999996]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B35","v":"Transpower - Interconnection costs"},"Transpower connection charge and NIC","MWh","Capacity",{"$f":"VLOOKUP(B38,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B38,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},null,null,0]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B36","v":"Transpower - New investment contract"},"Transpower connection charge and NIC","MWh","Capacity",{"$f":"VLOOKUP(B39,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B39,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},774.87108000000001,742.87271999999996,742.87271999999996]
[null,{"$f":"'Name labels'!B$43","v":"Transmission Costs"},{"$f":"'Name labels'!B37","v":"Distributed Generation Allowance"},"Distributed Generation Allowance","MWh","Capacity",{"$f":"VLOOKUP(B40,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B40,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},null,null,0]
[null,{"$f":"'Name labels'!B38","v":"CPP recoverable costs"},null,"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B41,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B41,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},0,null,0]
[null,{"$f":"'Name labels'!B39","v":"Quality Incentive Adjustments"},null,"ICP Count","ICP Count","Daily Fixed",{"$f":"VLOOKUP(B42,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B42,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},-581.66399999999999,-500.02600000000001,-500.02600000000001]
[null,{"$f":"'Name labels'!B40","v":"Capex Wash-up Adjustment"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B43,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B43,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},-831.48419799727094,-855.76353657879099,-855.76353657879099]
[null,{"$f":"'Name labels'!B41","v":"Fire and Emergency Management New Zealand (FENZ) levies"},null,"Regulated Asset Base","Regulated Asset Base","Capacity",{"$f":"VLOOKUP(B44,'Name labels'!$B$19:$D$46,2,FALSE)","v":"Passthrough"},{"$f":"VLOOKUP(B44,'Name labels'!$B$19:$D$46,3,FALSE)","v":"Passthrough and recoverable costs"},48.643999999999998,79.180000000000007,79.180000000000007]
[null,{"$f":"'Name labels'!B42","v":"Opening wash-up Account Balance"},null,null,null,null,null,null,25479.254278368498,28075.412845305142,null,"Annual Price-Setting Compliance Statement - Table 5"]
[null,"Forecast Allowable Revenue",null,null,null,null,null,null,173342.05894700679,202907.49975249669]
[null,"Forecast Revenue From Prices",null,null,null,null,null,null,158101.807,178157.962]
[null,"Revenue Deferred to Future Periods",null,null,null,null,null,null,15240.251947006793,24749.53775249669]
[null,null,null,null,null,null,null,null,null,0]
[null,"Forecast net allowable revenue",113846000,"Reconsideration of customised price-quality path for Aurora Energy Limited following a change to weighted average cost of capital (Table 1)",null,null,null,null,null,0]
[null,"Limit on Forecast Revenue From Prices",178157962,"Annual Price-Setting Compliance Statement (Table 10)"]
[]
[null,null,null,"Scaling"]
[null,{"$f":"'Name labels'!C70","v":"Capital related costs"},65400.165320873595,{"$f":"(C58-C56)/SUM(C54:C55)","v":1.029213807185219}]
[null,{"$f":"'Name labels'!C71","v":"Operational costs"},48445.834679126405,{"$f":"D54","v":1.029213807185219}]
[null,{"$f":"'Name labels'!C72","v":"Passthrough and recoverable costs"},60986.086907191551,1]
[null,"Revenue deferrred & Wash-ups",3325.8750928084482,0]
[null,"Forecast Revenue From Prices",178157.962]

{"sheet":"Allocator Data","index":7,"n_rows":210,"n_cols":11,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Allocator Data"}]
[null,{"$f":"'Name labels'!B8","v":"Pricing Area Name"},null,null,null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"In this sheet allocation data is input by pricing area and customer load group (if applicable):"]
[null,"The source of the information for each input is referenced in ","blue."]
[]
[1,{"$f":"'Name labels'!B50","v":"ICP Count"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2024 - Schedule 8 (excluding Load group 0, Load Group 0A, and Distributed Generation)"]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},"#",12,null,null,null,null,2,7,3]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},"#",86303.871150535182,null,null,null,null,53023.642869975309,20625.677595628425,12654.550684931461]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},"#",7277.9788457219838,null,null,null,null,3176.7759562841529,2184.9453551912561,1916.2575342465752]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},"#",436.31461187214643,null,null,null,null,205.78415300546482,154.38251366120221,76.147945205479402]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},"#",154.55498914589418,null,null,null,null,74.975409836065595,44.453551912568301,35.126027397260302]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},"#",9.0628565012351299,null,null,null,null,6,1.05737704918033,2.0054794520548]
[null,"Total",null,94193.782453776454,null,null,null,null,56489.178389100991,23017.516393442631,14687.08767123283]
[null,null,null,null,null,null,null,null,0.59971238990027631,0.2443634366709711,0.15592417342875256]
[null,"Allocation percentages"]
[]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},null,1.2739694369836712E-4,null,null,null,null,3.5405011314271118E-5,3.0411621655211256E-4,2.0426105346099435E-4]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},null,0.91623745115965516,null,null,null,null,0.93865133786767341,0.89608614774374151,0.86161061799321592]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},null,7.7266021770529214E-2,null,null,null,null,5.6236894337572438E-2,9.4925330684839507E-2,0.13047226088259098]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},null,4.6320956702875617E-3,null,null,null,null,3.64289513272809E-3,6.7071751366356638E-3,5.1846865021870983E-3]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},null,1.6408194375434353E-3,null,null,null,null,1.3272526167690082E-3,1.9312922885647427E-3,2.3916264533547127E-3]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},null,9.6215018286186028E-5,null,null,null,null,1.0621503394281335E-4,4.5937929666537001E-5,1.3654711519036372E-4]
[null,"Total",null,1,null,null,null,null,1,1,1]
[]
[]
[]
[2,{"$f":"'Name labels'!B51","v":"Total Circuit Length"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2024 - Schedule 9c"]
[null,"Total","km",6311.790724339895,null,null,null,null,2397.8858272298985,2879.4154147048021,1034.4894824051948]
[null,null,null,null,null,null,null,null,0.3799057877478465,0.45619627463265422,0.16389793761949936]
[]
[]
[3,{"$f":"'Name labels'!B52","v":"Overhead Circuit Length"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2024 - Schedule 9c"]
[null,"Total","km",3830.3512856283974,null,null,null,null,1679.2015322945988,1755.9913662945987,395.15838703919991]
[null,null,null,null,null,null,null,null,0.43839361120610987,0.45844133745203358,0.10316505134185656]
[]
[]
[4,{"$f":"'Name labels'!B53","v":"CPD"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual CPD assessments"]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},"kW",2093.9,null,null,null,null,1524.6,320.89999999999998,248.4]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},"kW",216268.80000000173,null,null,null,null,121289.30000000085,51467.500000000611,43512.000000000306]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},"kW",53850.035000000105,null,null,null,null,25141.400000000063,13553.400000000031,15155.235000000013]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},"kW",24780.059999999994,null,null,null,null,14758.799999999996,5130.5,4890.7599999999993]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},"kW",29354.094999999998,null,null,null,null,15060.199999999997,6932.6049999999996,7361.29]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},"kW",6669.375,null,null,null,null,6077.7,77.474999999999994,514.20000000000005]
[null,"Total",null,333016.26500000188,null,null,null,null,183852.00000000093,77482.380000000645,71681.885000000315]
[null,null,null,null,null,null,null,null,0.5520811423430021,0.23266845539811759,0.2152504022588804]
[null,"Allocation percentages"]
[]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},null,6.2876808734852281E-3,null,null,null,null,8.2925396514587392E-3,4.1415867710826292E-3,3.4653106569393216E-3]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},null,0.64942413548479538,null,null,null,null,0.6597116158649361,0.66424779414365154,0.60701528705613861]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},null,0.16170391857586836,null,null,null,null,0.1367480364641121,0.17492235008785118,0.21142349981449213]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},null,7.4410960077279875E-2,null,null,null,null,8.0275438940016541E-2,6.6215054312992933E-2,6.822867451100062E-2]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},null,8.8146130039623835E-2,null,null,null,null,8.1914801035615173E-2,8.9473309931883113E-2,0.10269386749525306]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},null,2.00271749489472E-2,null,null,null,null,3.3057568043861195E-2,9.9990475253856881E-4,7.173360466176326E-3]
[null,"Total",null,1,null,null,null,null,0.99999999999999989,0.99999999999999989,1.0000000000000002]
[]
[]
[]
[5,{"$f":"'Name labels'!B54","v":"Transpower connection charge and NIC"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Price-Setting Compliance Statement - Table 6"]
[null,"Total","$",7376280.9700000007,null,null,null,null,3246886.4400000004,1581434.2424507372,2547960.2875492629]
[null,null,null,null,null,null,null,null,0.44017933335313286,0.21439452332178949,0.34542614332507765]
[]
[]
[6,{"$f":"'Name labels'!B55","v":"Transpower benefit based charge"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Price-Setting Compliance Statement - Table 6"]
[null,"Total","$",2934371.8949331483,null,null,null,null,1661808.7177373427,461504.73157473415,811058.44562107115]
[null,null,null,null,null,null,null,null,0.56632518891243078,0.15727547430904232,0.27639933677852679]
[]
[]
[7,{"$f":"'Name labels'!B56","v":"Transpower residual charge"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Price-Setting Compliance Statement - Table 6"]
[null,"Total","$",19938975.939999998,null,null,null,null,11952170.739999998,4277417.33,3709387.87]
[null,null,null,null,null,null,null,null,0.59943754262838034,0.21452542712682568,0.18603703024479404]
[]
[]
[8,{"$f":"'Name labels'!B57","v":"Transpower transitional price cap"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Price-Setting Compliance Statement - Table 6"]
[null,"Total","$",12783.419999999996,null,null,null,null,7608.5590327900209,2648.4811710796394,2526.3797961303376]
[null,null,null,null,null,null,null,null,0.59518963100563249,0.20718095557211139,0.19762941342225621]
[]
[]
[9,{"$f":"'Name labels'!B59","v":"Prior year distribution revenue"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Compliance Statement 2023 - Table 20"]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},"$",572338.52,null,null,null,null,434720.16000000003,86560.98000000001,51057.380000000005]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},"$",64322790.790000007,null,null,null,null,34438138.229999997,19774969.470000003,10109683.090000002]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},"$",15864522.1,null,null,null,null,8002223.4399999995,4471907.76,3390390.9]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},"$",8236819.2600000007,null,null,null,null,4084126.3600000003,2395733.4500000002,1756959.4500000002]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},"$",6694989.4700000007,null,null,null,null,2956086.16,2640569.54,1098333.77]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},"$",956999.09,null,null,null,null,778208.56,139812.93,38977.599999999999]
[null,"Total",null,96648459.229999989,null,null,null,null,50693502.909999996,29509554.129999999,16445402.190000003]
[null,null,null,null,null,null,null,null,0.52451434108599393,0.30532875914528951,0.17015689976871662]
[null,"Allocation percentages"]
[]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},null,5.9218587089730273E-3,null,null,null,null,8.575461056060607E-3,2.93332049744528E-3,3.1046598562999325E-3]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},null,0.6655335356865576,null,null,null,null,0.67934027544201525,0.67012091686930553,0.61474222236701648]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},null,0.16414666334458855,null,null,null,null,0.15785501061560001,0.15154101415086341,0.20616041254750239]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},null,8.5224527381221465E-2,null,null,null,null,8.0565084785142155E-2,8.1185010096931617E-2,0.10683590645587002]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},null,6.9271559250288134E-2,null,null,null,null,5.8312919611181006E-2,8.9481851483331792E-2,6.6786677352765902E-2]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},null,9.9018556283714081E-3,null,null,null,null,1.5351248490001025E-2,4.7378869021224351E-3,2.370121420545203E-3]
[null,"Total",null,1,null,null,null,null,1.0000000000000002,1,0.99999999999999989]
[]
[]
[]
[10,{"$f":"'Name labels'!B60","v":"MWh"},"Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2024 - Schedule 8 (excluding Load group 0, Load Group 0A, and Distributed Generation)"]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},"MWh",6098.7150000000001,null,null,null,null,4434.482,936.16099999999994,728.072]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},"MWh",723322.21259000013,null,null,null,null,449809.18410000001,149245.30475000001,124267.72374]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},"MWh",284896.63557000004,null,null,null,null,130259.12159000004,83475.007610000001,71162.506370000003]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},"MWh",150060.89608999999,null,null,null,null,83073.198659999995,42705.158889999999,24282.538540000001]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},"MWh",193781.48615000001,null,null,null,null,98511.503559999997,44157.782400000004,51112.200190000003]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},"MWh",63212.292000000001,null,null,null,null,46222.53314,7993.4507599999997,8996.3081000000002]
[null,"Total",null,1421372.2374,null,null,null,null,812310.02304999996,328512.86541000003,280549.34894000005]
[null,null,null,null,null,null,null,null,0.57149703763448501,0.23112373857176341,0.19737922379375161]
[null,"Allocation percentages"]
[]
[null,{"$f":"'Name labels'!$C$10","v":"Load group Streetlighting"},null,4.2907233161918797E-3,null,null,null,null,5.4591004347696506E-3,2.849693569326807E-3,2.5951655305951533E-3]
[null,{"$f":"'Name labels'!$C$11","v":"Load group 1 (incl residential)"},null,0.50889006662541425,null,null,null,null,0.55374077794964371,0.45430581406221221,0.44294425992974462]
[null,{"$f":"'Name labels'!$C$12","v":"Load group 2"},null,0.2004377376127299,null,null,null,null,0.1603564130612509,0.25409966062004646,0.25365414904320183]
[null,{"$f":"'Name labels'!$C$13","v":"Load group 3"},null,0.10557466379425992,null,null,null,null,0.10226784885416415,0.12999539252961032,8.6553537307239331E-2]
[null,{"$f":"'Name labels'!$C$14","v":"Load group 4"},null,0.13633408691341026,null,null,null,null,0.12127328330889786,0.1344172087290674,0.18218613011620696]
[null,{"$f":"'Name labels'!$C$15","v":"Load group 5"},null,4.4472721737993895E-2,null,null,null,null,5.6902576391273794E-2,2.4332230489736786E-2,3.2066758073011972E-2]
[null,"Total",null,1,null,null,null,null,1,1,0.99999999999999989]
[]
[]
[]
[11,{"$f":"'Name labels'!B64","v":"Regulated Asset Base"},null,"Total"]
[]
[null,"Asset categories"]
[null,null,null,null,null,null,null,null,"RAB model for Information Disclosure 2023 - Schedule 4"]
[null,{"$f":"'Name labels'!$B$76","v":"33KV Lines"},"$",44500395.768851653,null,null,null,null,14040839.104204237,22591386.468082514,7868170.196564896]
[null,{"$f":"'Name labels'!$B$77","v":"33KV Cables"},"$",38390088.07060542,null,null,null,null,23491429.605926272,2978846.7366602863,11919811.728018861]
[null,{"$f":"'Name labels'!$B$78","v":"Zone Subs"},"$",136407932.8346003,null,null,null,null,64874598.694122426,52032450.076440729,19500884.064037152]
[null,{"$f":"'Name labels'!$B$79","v":"HV lines"},"$",159318956.07360536,null,null,null,null,62471032.47498031,71014599.766931087,25833323.831693977]
[null,{"$f":"'Name labels'!$B$80","v":"LV lines"},"$",103282383.29447383,null,null,null,null,86698079.459993705,11733943.745109713,4850360.0893704221]
[null,{"$f":"'Name labels'!$B$81","v":"HV cables"},"$",122151714.83216453,null,null,null,null,44094964.401436597,45908436.771525405,32148313.659202516]
[null,{"$f":"'Name labels'!$B$82","v":"LV cables"},"$",65918004.957907178,null,null,null,null,21412808.416059699,24638468.7747593,19866727.767088182]
[null,{"$f":"'Name labels'!$B$83","v":"Dist Subs"},"$",132773957.05049619,null,null,null,null,49572403.726098195,51652849.421491206,31548703.902906798]
[null,{"$f":"'Name labels'!$B$84","v":"Other Network Assets"},"$",21256201.594233207,null,null,null,null,15469611.628202837,2655159.4815096068,3131430.4845207613]
[null,{"$f":"'Name labels'!$B$85","v":"Non-Network Assets"},"$",6157411.7279236056,null,null,null,null,4892760.2456090571,847821.3503893977,416830.13192515098]
[null,"Total",null,830157046.20486128,null,null,null,null,387018527.75663328,286053962.59289926,157084555.85532874]
[null,"Total Check",null,null,null,null,null,null,0.46619917222400725,0.34457813000638982,0.1892226977696029]
[]
[]
[12,{"$f":"'Name labels'!B65","v":"Regulated Asset Base (Depreciation)"},null,"Total"]
[]
[null,"Asset categories"]
[null,null,null,null,null,null,null,null,"RAB model for Information Disclosure 2023- Schedule 4"]
[null,{"$f":"'Name labels'!$B$76","v":"33KV Lines"},"$",1327440.71509971,null,null,null,null,407479.72879037721,690829.8700505388,229131.11625879409]
[null,{"$f":"'Name labels'!$B$77","v":"33KV Cables"},"$",840254.88318535569,null,null,null,null,636949.32939527091,87242.538011592565,116063.01577849216]
[null,{"$f":"'Name labels'!$B$78","v":"Zone Subs"},"$",4616168.9879504768,null,null,null,null,2336431.5456920154,1444018.4531040539,835718.98915440775]
[null,{"$f":"'Name labels'!$B$79","v":"HV lines"},"$",4098168.4137548902,null,null,null,null,1519416.2899011134,1888068.239098948,690683.88475482853]
[null,{"$f":"'Name labels'!$B$80","v":"LV lines"},"$",2550315.7875022613,null,null,null,null,2108664.9126123167,311970.87045799202,129680.00443195253]
[null,{"$f":"'Name labels'!$B$81","v":"HV cables"},"$",3771408.7659168113,null,null,null,null,1287167.3081547038,1423527.3857051907,1060714.0720569165]
[null,{"$f":"'Name labels'!$B$82","v":"LV cables"},"$",2044536.5043086191,null,null,null,null,625057.01825748605,763988.87675622955,655490.60929490335]
[null,{"$f":"'Name labels'!$B$83","v":"Dist Subs"},"$",4869977.4826782709,null,null,null,null,1916977.194275442,1813015.7139786631,1139984.574424166]
[null,{"$f":"'Name labels'!$B$84","v":"Other Network Assets"},"$",2887313.5513664428,null,null,null,null,1853705.7784753691,702174.51047573599,331433.26241533807]
[null,{"$f":"'Name labels'!$B$85","v":"Non-Network Assets"},"$",2074717.9890020611,null,null,null,null,1595735.1280503254,341313.01409873489,137669.84685300069]
[null,"Total",null,29080303.080764901,null,null,null,null,14287584.23360442,9466149.471737681,5326569.3754228009]
[null,null,null,null,null,null,null,null,0.49131483237720824,0.32551756580553121,0.18316760181726055]
[]
[]
[13,{"$f":"'Name labels'!B66","v":"Overhead lines and underground cables"}]
[null,"Note: This input is used to allocate 'RAB' and 'RAB - Depreciation' values for lines and cables between HV and LV"]
[]
[null,"Overhead Circuit Length (km)",null,null,null,null,null,null,"Information Disclosure 2024 - Schedule 9c"]
[null,"Distribution lines(HV)","km",null,null,"2004 ODV RC ($000/km Medium):",28,null,872.2180898463015,1581.7530088707999,351.19863321880001]
[null,"LV lines","km",null,null,"2004 ODV RC ($000/km Medium):",42,null,806.98344244829843,174.23835742380018,43.95975382040001]
[null,"Total",null,null,null,null,null,null,1679.2015322945999,1755.9913662946001,395.15838703920002]
[]
[null,"Distribution lines(HV)",null,null,null,null,null,null,0.41879335248850152,0.85819757971447197,0.84192380217941687]
[null,"LV lines",null,null,null,null,null,null,0.58120664751149853,0.14180242028552803,0.15807619782058313]
[null,null,null,null,null,null,null,null,1,1,1]
[null,"Underground Circuit Length (km)"]
[null,"Distribution cables(HV)","km",null,null,"2004 ODV RC ($000/km Medium):",103,null,400.62040099370006,598.38050626909933,318.02238122759553]
[null,"LV cables","km",null,null,"2004 ODV RC ($000/km Medium):",63,null,318.06389394159999,525.0435421411006,321.30871413839947]
[null,"Total",null,null,null,null,null,null,718.68429493530004,1123.4240484101999,639.331095365995]
[]
[null,"Distribution cables(HV)",null,null,null,null,null,null,0.67312568424947872,0.65075053846841813,0.61805802278864164]
[null,"LV cables",null,null,null,null,null,null,0.32687431575052128,0.34924946153158187,0.38194197721135836]
[null,null,null,null,null,null,null,null,1,1,1]

{"sheet":"Asset Mapping","index":8,"n_rows":136,"n_cols":9,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Asset Mapping"]
[]
[null,"Description"]
[]
[null,"In this sheet asset categories are firstly mapped to a network type (HV, LV, or Shared). "]
[null,"Each Load Group is then mapped to the network types used by that load group."]
[]
[]
[null,"Asset Categories","Network Voltage"]
[]
[null,"33KV Lines","HV","HV - CPD"]
[null,"33KV Cables","HV","HV - CPD"]
[null,"Zone Subs","LV","LV - CPD"]
[null,"HV lines","HV","HV - CPD"]
[null,"LV lines","LV","LV - CPD"]
[null,"HV cables","HV","HV - CPD"]
[null,"LV cables","LV","LV - CPD"]
[null,"Dist Subs","LV","LV - CPD"]
[null,"Other Network Assets","Shared","Shared - CPD"]
[null,"Non-Network Assets","Shared","Shared - CPD"]
[]
[null,"Network Voltage","RAB Allocators"]
[]
[null,"LV","CPD","LV - CPD"]
[null,"HV","CPD","HV - CPD"]
[null,"Shared","CPD","Shared - CPD"]
[]
[null,"Load Groups","LV","HV","Shared"]
[]
[null,"Load group Streetlighting","Yes","No","Yes"]
[null,"Load group 1 (incl residential)","Yes","No","Yes"]
[null,"Load group 2","Yes","No","Yes"]
[null,"Load group 3","No","Yes","Yes"]
[null,"Load group 4","No","Yes","Yes"]
[null,"Load group 5","No","Yes","Yes"]
[]
[1,"LV - CPD","Units","Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Allocation to pricing categories"]
[]
[null,"Load group Streetlighting","kW",2093.9,null,null,1524.6,320.89999999999998,248.4]
[null,"Load group 1 (incl residential)","kW",216268.80000000173,null,null,121289.30000000085,51467.500000000611,43512.000000000306]
[null,"Load group 2","kW",53850.035000000105,null,null,25141.400000000063,13553.400000000031,15155.235000000013]
[null,"Load group 3","kW",0,null,null,0,0,0]
[null,"Load group 4","kW",0,null,null,0,0,0]
[null,"Load group 5","kW",0,null,null,0,0,0]
[null,"Total",null,272212.73500000185,null,null,147955.30000000092,65341.800000000643,58915.635000000322]
[null,null,null,null,null,null,0.54352820781878519,0.24003946766120329,0.2164323245200116]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,7.6921456301446952E-3,null,null,1.0304463577850814E-2,4.9110982556341701E-3,4.2161982977862947E-3]
[null,"Load group 1 (incl residential)",null,0.79448450492222655,null,null,0.81976988996000877,0.78766578208742499,0.73854758588276381]
[null,"Load group 2",null,0.19782334944762867,null,null,0.16992564646214031,0.20742311965694085,0.25723621581944978]
[null,"Load group 3",null,0,null,null,0,0,0]
[null,"Load group 4",null,0,null,null,0,0,0]
[null,"Load group 5",null,0,null,null,0,0,0]
[null,"Total",null,1,null,null,1,1,0.99999999999999989]
[]
[]
[]
[2,"HV - CPD","Units","Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Allocation to pricing categories"]
[]
[null,"Load group Streetlighting","kW",0,null,null,0,0,0]
[null,"Load group 1 (incl residential)","kW",0,null,null,0,0,0]
[null,"Load group 2","kW",0,null,null,0,0,0]
[null,"Load group 3","kW",24780.059999999994,null,null,14758.799999999996,5130.5,4890.7599999999993]
[null,"Load group 4","kW",29354.094999999998,null,null,15060.199999999997,6932.6049999999996,7361.29]
[null,"Load group 5","kW",6669.375,null,null,6077.7,77.474999999999994,514.20000000000005]
[null,"Total",null,60803.529999999992,null,null,35896.69999999999,12140.58,12766.25]
[null,null,null,null,null,null,0.59037197346930337,0.19966899948078676,0.20995902704990979]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,0,null,null,0,0,0]
[null,"Load group 1 (incl residential)",null,0,null,null,0,0,0]
[null,"Load group 2",null,0,null,null,0,0,0]
[null,"Load group 3",null,0.40754311468429544,null,null,0.41114642850178429,0.42259101294995793,0.38310075394105547]
[null,"Load group 4",null,0.48276958591055491,null,null,0.41954274348338433,0.57102749621517257,0.57662116909820815]
[null,"Load group 5",null,0.10968729940514968,null,null,0.16931082801483149,6.3814908348695035E-3,4.027807696073632E-2]
[null,"Total",null,1,null,null,1,1,1]
[]
[]
[]
[3,"Shared - CPD","Units","Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Allocation to pricing categories"]
[]
[null,"Load group Streetlighting","kW",2093.9,null,null,1524.6,320.89999999999998,248.4]
[null,"Load group 1 (incl residential)","kW",216268.80000000173,null,null,121289.30000000085,51467.500000000611,43512.000000000306]
[null,"Load group 2","kW",53850.035000000105,null,null,25141.400000000063,13553.400000000031,15155.235000000013]
[null,"Load group 3","kW",24780.059999999994,null,null,14758.799999999996,5130.5,4890.7599999999993]
[null,"Load group 4","kW",29354.094999999998,null,null,15060.199999999997,6932.6049999999996,7361.29]
[null,"Load group 5","kW",6669.375,null,null,6077.7,77.474999999999994,514.20000000000005]
[null,"Total",null,333016.26500000188,null,null,183852.00000000093,77482.380000000645,71681.885000000315]
[null,null,null,null,null,null,0.5520811423430021,0.23266845539811759,0.2152504022588804]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,6.2876808734852281E-3,null,null,8.2925396514587392E-3,4.1415867710826292E-3,3.4653106569393216E-3]
[null,"Load group 1 (incl residential)",null,0.64942413548479538,null,null,0.6597116158649361,0.66424779414365154,0.60701528705613861]
[null,"Load group 2",null,0.16170391857586836,null,null,0.1367480364641121,0.17492235008785118,0.21142349981449213]
[null,"Load group 3",null,7.4410960077279875E-2,null,null,8.0275438940016541E-2,6.6215054312992933E-2,6.822867451100062E-2]
[null,"Load group 4",null,8.8146130039623835E-2,null,null,8.1914801035615173E-2,8.9473309931883113E-2,0.10269386749525306]
[null,"Load group 5",null,2.00271749489472E-2,null,null,3.3057568043861195E-2,9.9990475253856881E-4,7.173360466176326E-3]
[null,"Total",null,1,null,null,0.99999999999999989,0.99999999999999989,1.0000000000000002]
[]
[4,"Load Group Summary",null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,"Load group Streetlighting"]
[null,"LV - CPD",null,null,null,null,1.0304463577850814E-2,4.9110982556341701E-3,4.2161982977862947E-3]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,8.2925396514587392E-3,4.1415867710826292E-3,3.4653106569393216E-3]
[null,"Load group 1 (incl residential)"]
[null,"LV - CPD",null,null,null,null,0.81976988996000877,0.78766578208742499,0.73854758588276381]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,0.6597116158649361,0.66424779414365154,0.60701528705613861]
[null,"Load group 2"]
[null,"LV - CPD",null,null,null,null,0.16992564646214031,0.20742311965694085,0.25723621581944978]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,0.1367480364641121,0.17492235008785118,0.21142349981449213]
[null,"Load group 3"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.41114642850178429,0.42259101294995793,0.38310075394105547]
[null,"Shared - CPD",null,null,null,null,8.0275438940016541E-2,6.6215054312992933E-2,6.822867451100062E-2]
[null,"Load group 4"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.41954274348338433,0.57102749621517257,0.57662116909820815]
[null,"Shared - CPD",null,null,null,null,8.1914801035615173E-2,8.9473309931883113E-2,0.10269386749525306]
[null,"Load group 5"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.16931082801483149,6.3814908348695035E-3,4.027807696073632E-2]
[null,"Shared - CPD",null,null,null,null,3.3057568043861195E-2,9.9990475253856881E-4,7.173360466176326E-3]
[]
[null,"Error check",null,null,null,null,0,0,0]
[null,0,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]

{"sheet":"Calculations >","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This sheet has been deliberately left blank."]

{"sheet":"Pricing Area Allocations","index":10,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Pricing Area Allocations"]
[null,"Pricing Area Name",null,null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"This sheet allocates each component of target revenue to pricing areas based on the selected allocator, and calculated allocation percentages."]
[null,"More information about pricing area allocations are provided in section 3.5 of the Pricing Methodology."]
[]
[null,"Allocator percentages",null,null,null,null,null,"Dunedin","Central Otago","Queenstown",null,"check"]
[]
[1,"ICP Count",null,null,null,null,null,0.59971238990027631,0.2443634366709711,0.15592417342875256,null,0]
[2,"Total Circuit Length",null,null,null,null,null,0.3799057877478465,0.45619627463265422,0.16389793761949936,null,0]
[3,"Overhead Circuit Length",null,null,null,null,null,0.43839361120610987,0.45844133745203358,0.10316505134185656,null,0]
[4,"CPD",null,null,null,null,null,0.5520811423430021,0.23266845539811759,0.2152504022588804,null,0]
[5,"Transpower connection charge and NIC",null,null,null,null,null,0.44017933335313286,0.21439452332178949,0.34542614332507765,null,0]
[6,"Transpower benefit based charge",null,null,null,null,null,0.56632518891243078,0.15727547430904232,0.27639933677852679,null,0]
[7,"Transpower residual charge",null,null,null,null,null,0.59943754262838034,0.21452542712682568,0.18603703024479404,null,0]
[8,"Transpower transitional price cap",null,null,null,null,null,0.59518963100563249,0.20718095557211139,0.19762941342225621,null,0]
[9,"Prior year distribution revenue",null,null,null,null,null,0.52451434108599393,0.30532875914528951,0.17015689976871662,null,0]
[10,"MWh",null,null,null,null,null,0.57149703763448501,0.23112373857176341,0.19737922379375161,null,0]
[11,"Regulated Asset Base",null,null,null,null,null,0.46619917222400725,0.34457813000638982,0.1892226977696029,null,0]
[12,"Regulated Asset Base (Depreciation)",null,null,null,null,null,0.49131483237720824,0.32551756580553121,0.18316760181726055,null,0]
[]
[null,"Target Revenue Components","Cost type","Pricing Area Allocators","Scaled target revenue",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[]
[]
[null,"Service interruptions and emergencies","Operational costs","Total Circuit Length",2499.589294425185,null,null,949.60843994468371,1140.3033242284341,409.67753025206741]
[null,"Service interruptions and emergencies","Operational costs","ICP Count",2499.589294425185,null,null,1499.0346695288731,610.80823025170605,389.7463946446058]
[null,"Vegetation management","Operational costs","Overhead Circuit Length",4036.3690230236125,null,null,1769.518392163799,1850.438413364903,416.41221749491041]
[null,"Routine and corrective maintenance and inspection","Operational costs","Total Circuit Length",10042.933145191289,null,null,3815.3684278228543,4581.5486872210713,1646.0160301473645]
[null,"System operations and network support","Operational costs","ICP Count",14929.746123599474,null,null,8953.5537283882259,3648.2840713878763,2327.9083238233707]
[null,"Business support","Operational costs","ICP Count",15852.895071704652,null,null,9507.1775902903082,3873.8679209060497,2471.8495605082931]
[null,"Depreciation","Capital related costs","Regulated Asset Base (Depreciation)",25268.932663313164,null,null,12415.001415826669,8225.4814510655797,4628.4497964209149]
[null,"Asset revaluations and other regulatory revenue","Capital related costs","Regulated Asset Base",-16639.580380819727,null,null,-7757.3585996929878,-5733.6354917138733,-3148.5862894128654]
[null,"Tax","Capital related costs","Regulated Asset Base",7430.3749384269559,null,null,3464.0346456086559,2560.3447015295042,1405.9955912887956]
[null,"Return on capital","Capital related costs","Regulated Asset Base",51251.025919518645,null,null,23893.185859310732,17659.982672256749,9697.8573879511605]
[null,"Local Authority rates","Passthrough and recoverable costs","Regulated Asset Base",1833.3620000000001,null,null,854.71184678695045,631.73644958477485,346.91370362827473]
[null,"Commerce Act levies","Passthrough and recoverable costs","Regulated Asset Base",444.392,null,null,207.17518254297102,153.12776434979958,84.089053107229375]
[null,"Electricity Authority levies","Passthrough and recoverable costs","MWh",309.54640000000001,null,null,176.90485061041935,71.54352122943051,61.098028160150157]
[null,"Electricity Authority levies","Passthrough and recoverable costs","ICP Count",77.386600000000001,null,null,46.409702832256727,18.910455528281773,12.066441639461503]
[null,"Utilities Disputes levies","Passthrough and recoverable costs","ICP Count",70.724000000000004,null,null,42.414059063307143,17.282359695117762,11.027581241575097]
[null,"Opex Incentive Amount","Passthrough and recoverable costs","Prior year distribution revenue",29264.873218837201,null,null,15349.845693343545,8935.4074264517767,4979.6200990418811]
[null,"Capex Incentive Amount","Passthrough and recoverable costs","Regulated Asset Base",0,null,null,0,0,0]
[null,"Transpower  - Connection charge","Passthrough and recoverable costs","Transpower connection charge and NIC",6633.4082500000004,null,null,2919.8892213441718,1422.1663997575758,2291.3526288982525]
[null,"Transpower - Benefit-based Charge","Passthrough and recoverable costs","Transpower benefit based charge",2934.3718949331483,null,null,1661.8087177373427,461.50473157473419,811.05844562107109]
[null,"Transpower - Residual Charge","Passthrough and recoverable costs","Transpower residual charge",19938.975939999997,null,null,11952.170739999998,4277.4173300000002,3709.38787]
[null,"Transpower - Transitional Price Cap ","Passthrough and recoverable costs","Transpower transitional price cap",12.783419999999996,null,null,7.6085590327900201,2.6484811710796392,2.5263797961303376]
[null,"Transpower - Interconnection costs","Passthrough and recoverable costs","Transpower connection charge and NIC",0,null,null,0,0,0]
[null,"Transpower - New investment contract","Passthrough and recoverable costs","Transpower connection charge and NIC",742.87271999999996,null,null,326.99721865582853,159.26784269316119,256.60765865101024]
[null,"Distributed Generation Allowance","Passthrough and recoverable costs","Distributed Generation Allowance",0,null,null,0,0,0]
[null,"CPP recoverable costs","Passthrough and recoverable costs","ICP Count",0,null,null,0,0,0]
[null,"Quality Incentive Adjustments","Passthrough and recoverable costs","ICP Count",-500.02600000000001,null,null,-299.87178747227557,-122.188071784839,-77.966140742885429]
[null,"Capex Wash-up Adjustment","Passthrough and recoverable costs","Regulated Asset Base",-855.76353657879099,null,null,-398.95625237252131,-294.87739916197455,-161.92988504429508]
[null,"Fire and Emergency Management New Zealand (FENZ) levies","Passthrough and recoverable costs","Regulated Asset Base",79.180000000000007,null,null,36.913650456696899,27.283696333905947,14.98265320939716]
[null,"Total",null,null,178157.962,null,null,91393.145971753314,54178.654967920818,32586.16106032587]
[null,null,null,null,0,null,null,0.51298939966406509,0.3041045954933006,0.18290600484263436]
[null,"Error check"]
[null,0]

{"sheet":"RAB Allocations","index":11,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[]
[null,"RAB Allocations"]
[null,"Pricing Area Name",null,null,null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"In this sheet the RAB is allocated to load groups based on the inputs from the Asset Mapping worksheet."]
[null,"More information about pricing area allocations are provided in section 3.5 of the Pricing Methodology."]
[]
[null,"RAB Allocator Summary","Units",null,null,"Total"]
[]
[null,"Load Group Summary"]
[]
[null,"Load group Streetlighting","$",null,null,3496283.6898974143,null,null,2462195.4506826065,702345.08425148414,331743.15496332396]
[null,"Load group 1 (incl residential)","$",null,null,366636209.01039416,null,null,195879550.48962343,112645514.56439294,58111143.956377827]
[null,"Load group 2","$",null,null,90506883.60532847,null,null,40602807.755340308,29663957.19817416,20240118.651813991]
[null,"Load group 3","$",null,null,151364103.8050715,null,null,60880085.589240633,60448325.265371747,30035692.950459115]
[null,"Load group 4","$",null,null,189012353.12792504,null,null,62123361.316033952,81680998.338630244,45207993.47326085]
[null,"Load group 5","$",null,null,29141212.966244653,null,null,25070527.155712381,912822.1420786815,3157863.6684535909]
[null,"Total",null,null,null,830157046.20486128,null,null,387018527.75663328,286053962.59289926,157084555.85532871]
[null,"Error check",0]
[]
[null,"RAB Allocation"]
[]
[null,"Load group Streetlighting ","$",null,null,4.2115931026315973E-3,null,null,6.36195756558429E-3,2.455288777981496E-3,2.1118763277330195E-3]
[null,"Load group 1 (incl residential) ","$",null,null,0.44164680729568584,null,null,0.50612447839395758,0.3937911348730575,0.36993543789178651]
[null,"Load group 2 ","$",null,null,0.10902380943351496,null,null,0.10491179321748738,0.10370056380023211,0.12884855892806343]
[null,"Load group 3 ","$",null,null,0.18233189069110034,null,null,0.15730535161232259,0.21131790910164536,0.19120716729225312]
[null,"Load group 4 ","$",null,null,0.22768264630410867,null,null,0.16051779659267021,0.28554401973055493,0.28779400512738107]
[null,"Load group 5 ","$",null,null,3.5103253172958503E-2,null,null,6.4778622617977968E-2,3.1910837165285981E-3,2.0102954432782757E-2]
[null,null,null,null,null,1,null,null,1,1,0.99999999999999989]
[]
[]
[]
[null,"Load group Streetlighting","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"33KV Cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"Zone Subs","LV - CPD",null,null,1006254.008374174,null,null,668497.93937127257,255536.47480678011,82219.594196121325]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,971453.83267589286,null,null,893377.20206512092,57626.550658317792,20450.079952454154]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,425411.50923818286,null,null,220647.50442278455,121001.94102121737,83762.063794180911]
[null,"Dist Subs","LV - CPD",null,null,897504.83904731425,null,null,510817.02866209485,253672.2186924199,133015.59169279947]
[null,"Other Network Assets","Shared - CPD",null,null,150130.32063274845,null,null,128282.36781953921,10996.5733837348,10851.379429474457]
[null,"Non-Network Assets","Shared - CPD",null,null,45529.179929101898,null,null,40573.408341794107,3511.3256890141402,1444.445898293649]
[null,null,null,null,null,3496283.6898974143,null,null,2462195.4506826065,702345.08425148414,331743.15496332396]
[]
[null,"Load group 1 (incl residential)","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"33KV Cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"Zone Subs","LV - CPD",null,null,108568753.96413936,null,null,53182242.632680468,40984180.483384587,14402330.848074298]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,83897122.770291448,null,null,71072475.05866313,9242425.9769616909,3582221.7346666316]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,51632978.207648449,null,null,17553575.59896801,19406878.776907384,14672523.831773048]
[null,"Dist Subs","LV - CPD",null,null,104623365.08944146,null,null,40637963.947596647,40685182.036622867,23300219.105221946]
[null,"Other Network Assets","Shared - CPD",null,null,13869992.487194769,null,null,10205482.484044699,1763683.8286923578,1900826.174457713]
[null,"Non-Network Assets","Shared - CPD",null,null,4043996.4916787157,null,null,3227810.7676704726,563163.46182404936,253022.26218419365]
[null,null,null,null,null,366636209.01039422,null,null,195879550.48962343,112645514.56439294,58111143.956377827]
[]
[null,"Load group 2","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"33KV Cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"Zone Subs","LV - CPD",null,null,26832924.862086773,null,null,11023858.122070678,10792733.118249366,5016333.6217667293]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,18413806.691506479,null,null,14732227.199265439,2433891.2174897045,1247688.2747513356]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,13859615.241020555,null,null,3638585.3126689033,5110588.0568306996,5110441.8715209514]
[null,"Dist Subs","LV - CPD",null,null,27253087.122007418,null,null,8423622.7498394493,10713995.166175919,8115469.2059920505]
[null,"Other Network Assets","Shared - CPD",null,null,3241943.7438460053,null,null,2115439.0150191342,464446.73636370082,662057.9924631702]
[null,"Non-Network Assets","Shared - CPD",null,null,905505.94486122625,null,null,669075.3564767054,148302.90306476897,88127.685319751894]
[null,null,null,null,null,90506883.605328456,null,null,40602807.755340308,29663957.19817416,20240118.651813991]
[]
[null,"Load group 3","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,18334059.676793281,null,null,5772840.8508617645,9546916.8914909624,3014301.9344405541]
[null,"33KV Cables","HV - CPD",null,null,15483740.102585074,null,null,9658417.3828776646,1258833.8598679469,4566488.8598394608]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,65591639.373375788,null,null,25684741.886907138,30010131.649743255,9896765.8367253989]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,49846023.12756601,null,null,18129487.128563974,19400492.798228018,12316043.200774016]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,1631294.7442455753,null,null,1241829.8636855667,175811.52927781676,213653.35128219199]
[null,"Non-Network Assets","Shared - CPD",null,null,477346.78050577774,null,null,392768.47634453018,56138.536763748984,28439.767397498574]
[null,null,null,null,null,151364103.80507153,null,null,60880085.589240633,60448325.265371747,30035692.950459115]
[]
[null,"Load group 4","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,23327988.506892048,null,null,5890732.1585866306,12900302.850898487,4536953.4974069288]
[null,"33KV Cables","HV - CPD",null,null,18429877.992901735,null,null,9855658.8252171054,1701003.3936438607,6873215.7740407689]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,81656598.841950059,null,null,26209268.352792837,40551289.099633239,14896041.389523983]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,63252100.250282839,null,null,18499722.338780876,26214979.704796713,18537398.20670525]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,1826334.7730781324,null,null,1267190.1586224742,237565.90720768712,321578.70724797115]
[null,"Non-Network Assets","Shared - CPD",null,null,519452.76282024209,null,null,400789.48203403351,75857.382450258257,42805.898335950304]
[null,null,null,null,null,189012353.12792507,null,null,62123361.316033952,81680998.338630244,45207993.47326085]
[]
[null,"Load group 5","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,2838347.5851663202,null,null,2377266.0947558442,144166.72569306349,316914.76471741271]
[null,"33KV Cables","HV - CPD",null,null,4476469.9751186129,null,null,3977353.3978315038,19009.483148478546,480107.09413863107]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,12070717.858279534,null,null,10577022.235280344,453179.01755459671,1040516.6054445937]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,9053591.4543156736,null,null,7465754.9340917487,292964.26850067545,1294872.2517232497]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,536505.52523597155,null,null,511387.73901142163,2654.9065843092981,22462.879640240608]
[null,"Non-Network Assets","Shared - CPD",null,null,165580.5681285414,null,null,161742.75474152042,847.74059755802591,2990.0727894629404]
[null,null,null,null,null,29141212.966244657,null,null,25070527.155712381,912822.1420786815,3157863.6684535909]

{"sheet":"RAB - Depreciation Allocations","index":12,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"RAB - Depreciation Allocations"}]
[null,{"$f":"'Name labels'!B8","v":"Pricing Area Name"},null,null,null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"In this sheet the Depreciation is allocated to load groups based on the inputs from the Asset Mapping worksheet."]
[null,"More information about pricing area allocations are provided in section 3.5 of the Pricing Methodology."]
[]
[null,"RAB Allocator Summary","Units",null,null,"Total"]
[]
[null,"Load Group Summary"]
[]
[null,{"$f":"'Name labels'!C10","v":"Load group Streetlighting"},"$",null,null,139470.69299630777,null,null,100603.25900405497,25601.452981744558,13265.981010508234]
[null,{"$f":"'Name labels'!C11","v":"Load group 1 (incl residential)"},"$",null,null,14433350.619249336,null,null,8003475.5754431393,4106085.3266997626,2323789.7171064345]
[null,{"$f":"'Name labels'!C12","v":"Load group 2"},"$",null,null,3549665.619126834,null,null,1658996.9670238451,1081292.4052439311,809376.24685905757]
[null,{"$f":"'Name labels'!C13","v":"Load group 3"},"$",null,null,4492799.3156497786,null,null,1860235.4825978465,1797351.539752648,835212.29329928407]
[null,{"$f":"'Name labels'!C14","v":"Load group 4"},"$",null,null,5584015.2543251021,null,null,1898224.6805309439,2428677.1798551613,1257113.3939389966]
[null,{"$f":"'Name labels'!C15","v":"Load group 5"},"$",null,null,881001.57941753918,null,null,766048.26900458941,27141.567204431612,87811.743208518106]
[null,"Total",null,null,null,29080303.080764897,null,null,14287584.233604418,9466149.4717376791,5326569.375422799]
[null,"Error check",0]
[]
[null,"RAB Allocation"]
[]
[null,{"$f":"'Name labels'!C10 & \" \" &$C$14","v":"Load group Streetlighting "},"$",null,null,4.7960536246460361E-3,null,null,7.0413064489541878E-3,2.70452659322365E-3,2.4905300345318868E-3]
[null,{"$f":"'Name labels'!C11 & \" \" &$C$14","v":"Load group 1 (incl residential) "},"$",null,null,0.49632737936614713,null,null,0.56016996607578717,0.43376510575487648,0.43626386015520219]
[null,{"$f":"'Name labels'!C12 & \" \" &$C$14","v":"Load group 2 "},"$",null,null,0.12206425803982603,null,null,0.1161145887155564,0.1142272693318713,0.15195075663401322]
[null,{"$f":"'Name labels'!C13 & \" \" &$C$14","v":"Load group 3 "},"$",null,null,0.15449630298459754,null,null,0.13019944114993004,0.1898714514406154,0.15680116683601603]
[null,{"$f":"'Name labels'!C14 & \" \" &$C$14","v":"Load group 4 "},"$",null,null,0.19202053151979137,null,null,0.13285833696548341,0.25656442327540541,0.23600807674437033]
[null,{"$f":"'Name labels'!C15 & \" \" &$C$14","v":"Load group 5 "},"$",null,null,3.0295474464991933E-2,null,null,5.3616360644288825E-2,2.8672236040077335E-3,1.6485609595866382E-2]
[null,null,null,null,null,1,null,null,1,1,1]
[]
[]
[]
[null,{"$f":"B16","v":"Load group Streetlighting"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"'Asset Mapping'!B12","v":"33KV Lines"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,{"$f":"'Asset Mapping'!B13","v":"33KV Cables"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,{"$f":"'Asset Mapping'!B14","v":"Zone Subs"},"LV - CPD",null,null,34690.947250368423,null,null,24075.673764725052,7091.7165061428714,3523.5569795004967]
[null,{"$f":"'Asset Mapping'!B15","v":"HV lines"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,{"$f":"'Asset Mapping'!B16","v":"LV lines"},"LV - CPD",null,null,23807.537001563422,null,null,21728.660789905585,1532.1195977149182,546.7566139429174]
[null,{"$f":"'Asset Mapping'!B17","v":"HV cables"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,{"$f":"'Asset Mapping'!B18","v":"LV cables"},"LV - CPD",null,null,12956.580109799797,null,null,6440.8772787142962,3752.024439961428,2763.6783911240727]
[null,{"$f":"'Asset Mapping'!B19","v":"Dist Subs"},"LV - CPD",null,null,33463.721010529691,null,null,19753.421677981936,8903.8983103579521,4806.4010221898025]
[null,{"$f":"'Asset Mapping'!B20","v":"Other Network Assets"},"Shared - CPD",null,null,19428.564550034953,null,null,15371.928670145187,2908.1166635777295,1148.5192163120378]
[null,{"$f":"'Asset Mapping'!B21","v":"Non-Network Assets"},"Shared - CPD",null,null,15123.343074011478,null,null,13232.696822582911,1413.5774639896592,477.06878743890763]
[null,null,null,null,null,139470.69299630777,null,null,100603.25900405497,25601.452981744558,13265.981010508234]
[]
[null,{"$f":"B17","v":"Load group 1 (incl residential)"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"B40","v":"33KV Lines"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,"33KV Cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"Zone Subs","LV - CPD",null,null,3669958.3972402862,null,null,1915336.2311110366,1137403.9242128781,617218.24191637151]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,2070123.6372530041,null,null,1728620.0033747302,245728.77966778903,95774.854210484657]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,1598281.8262555322,null,null,512402.92307567055,601767.89611628884,484111.00706357282]
[null,"Dist Subs","LV - CPD",null,null,3841463.4792793784,null,null,1571480.1836070255,1428050.4402877949,841932.85538455774]
[null,"Other Network Assets","Shared - CPD",null,null,1890514.1610685599,null,null,1222911.234456155,466417.869687406,201185.05692499896]
[null,"Non-Network Assets","Shared - CPD",null,null,1363009.1181525756,null,null,1052724.9998185209,226716.41672760568,83567.701606448856]
[null,null,null,null,null,14433350.619249336,null,null,8003475.5754431393,4106085.3266997626,2323789.7171064345]
[]
[null,{"$f":"B18","v":"Load group 2"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"B55","v":"33KV Lines"},"HV - CPD",null,null,0,null,null,0,0,0]
[null,"33KV Cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"Zone Subs","LV - CPD",null,null,911519.64345982193,null,null,397019.64081625344,299522.81238503277,214977.19025853564]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,456384.61324769352,null,null,358316.2484476805,64709.971192488068,33358.393607524944]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,433298.09794328676,null,null,106213.21790310116,158468.95619997923,168615.92384020638]
[null,"Dist Subs","LV - CPD",null,null,995050.28238836315,null,null,325743.58899043442,376061.37538051029,293245.31801741838]
[null,"Other Network Assets","Shared - CPD",null,null,446389.42122767307,null,null,253490.62538868509,122826.01554420221,70072.780294785756]
[null,"Non-Network Assets","Shared - CPD",null,null,307023.56085999566,null,null,218213.6454776905,59703.274541718587,29106.640840586551]
[null,null,null,null,null,3549665.619126834,null,null,1658996.9670238451,1081292.4052439311,809376.24685905757]
[]
[null,{"$f":"B19","v":"Load group 3"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"B70","v":"33KV Lines"},"HV - CPD",null,null,547252.63312988391,null,null,167533.83517903928,291938.49456074502,87780.303390099652]
[null,{"$f":"B71","v":"33KV Cables"},"HV - CPD",null,null,343211.18327752926,null,null,261879.4419174722,36867.912510644113,44463.828849412967]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,1687184.7676642542,null,null,624702.58100027451,797880.6696794678,264601.51698451187]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,1537144.482240116,null,null,529214.24163206213,601569.87988716201,406360.3607208918]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,217914.82056456056,null,null,148807.04503275533,46494.523348350085,22613.252183455155]
[null,"Non-Network Assets","Shared - CPD",null,null,160091.42877343512,null,null,128098.33783624337,22600.059766279053,9393.0311709126872]
[null,null,null,null,null,4492799.3156497786,null,null,1860235.4825978465,1797351.539752648,835212.29329928407]
[]
[null,{"$f":"B20","v":"Load group 4"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"B85","v":"33KV Lines"},"HV - CPD",null,null,697559.86647011572,null,null,170955.16333058025,394482.85100561217,132121.8521339233]
[null,{"$f":"B86","v":"33KV Cables"},"HV - CPD",null,null,383969.74900586845,null,null,267227.46911439381,49817.888044216721,66924.391847257924]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,2113861.9071191419,null,null,637460.07875845837,1078138.879256062,398262.94910462131]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,1964525.1709466926,null,null,540021.70378534717,812873.27885296533,611630.18830838019]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,248707.98115844402,null,null,151845.94002238,62825.877602063832,34036.163534000159]
[null,"Non-Network Assets","Shared - CPD",null,null,175390.57962483945,null,null,130714.32551978431,30538.405094241298,14137.849010813834]
[null,null,null,null,null,5584015.2543251021,null,null,1898224.6805309439,2428677.1798551613,1257113.3939389966]
[]
[null,{"$f":"B21","v":"Load group 5"},"Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,{"$f":"B100","v":"33KV Lines"},"HV - CPD",null,null,82628.215499710466,null,null,68990.730280757736,4408.5244841816038,9228.9607347711299]
[null,{"$f":"B101","v":"33KV Cables"},"HV - CPD",null,null,113073.95090195796,null,null,107842.41836340497,556.73745673173221,4674.7950818212612]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,297121.7389714942,null,null,257253.63014238075,12048.690163418139,27819.418665695317]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,269739.11273000261,null,null,217931.36273729466,9084.2269650634189,42723.523027644493]
[null,"LV cables","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Dist Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"Other Network Assets","Shared - CPD",null,null,64358.602797170359,null,null,61279.004905248199,702.10763013613155,2377.4902617860303]
[null,"Non-Network Assets","Shared - CPD",null,null,54079.958517203646,null,null,52751.122575503192,341.28050490058854,987.55543679986442]
[null,null,null,null,null,881001.57941753929,null,null,766048.26900458941,27141.567204431612,87811.743208518106]

{"sheet":"Load Group Allocations","index":13,"n_rows":323,"n_cols":9,"rows_kept":323,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Load Group Allocations"]
[null,"Pricing Area Name",null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"In this sheet the cost of supply for each pricing area is allocated to each load group."]
[null,"More information about load group allocation is provided in section 3.6 of the Pricing Methodology."]
[]
[null,"Load group Streetlighting","Units","Allocator","Distribution / Passthrough","Tariff Types"]
[]
[null,"Load Group Allocators"]
[]
[null,"ICP Count","%",null,null,null,3.5405011314271118E-5,3.0411621655211256E-4,2.0426105346099435E-4]
[null,"CPD","%",null,null,null,8.2925396514587392E-3,4.1415867710826292E-3,3.4653106569393216E-3]
[null,"Prior year distribution revenue","%",null,null,null,8.575461056060607E-3,2.93332049744528E-3,3.1046598562999325E-3]
[null,"MWh","%",null,null,null,5.4591004347696506E-3,2.849693569326807E-3,2.5951655305951533E-3]
[null,"Regulated Asset Base","%",null,null,null,6.36195756558429E-3,2.455288777981496E-3,2.1118763277330195E-3]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,7.0413064489541878E-3,2.70452659322365E-3,2.4905300345318868E-3]
[]
[null,"Load group Streetlighting Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",7.8746656416011644,4.7226651626460292,1.4196599114910706]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",5.3073339435154417E-2,0.18575668802304046,7.9610009152731628E-2]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",14.673801431003819,7.6637512534952119,1.4429976949648478]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",31.639093972644812,18.974881434065775,5.7039568907626181]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",0.31700067105651947,1.1095023486978184,0.47550100658477928]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",0.33660173015101319,1.1781060555285463,0.50490259522651981]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",87.4178295330357,22.246033326474716,11.527293231309287]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-49.351986232267159,-14.077730879841489,-6.6494248504357767]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",22.038041421076084,6.2863856134297746,2.9692888061397968]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",152.00743454355347,43.360357274539666,20.480675447344829]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",5.4376405000607599,1.5510954153073708,0.73263883845874189]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",1.3180397199805607,0.37597288140545787,0.17758568067864242]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",0.9657413468802003,0.20387711237450401,0.15855949666855371]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",1.6431360538680098E-3,5.7509761885380338E-3,2.4647040808020147E-3]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",1.5016702410205528E-3,5.2558458435719357E-3,2.2525053615308293E-3]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",131.63200395980721,26.210413757035774,15.460026621119622]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",15.939968517719185,4.0527384439018208,5.946439360955333]
[null,"Transpower - Benefit-based Charge",null,"MWh","Passthrough","Capacity",9.0719806935039227,1.3151470657824142,2.1048309213738872]
[null,"Transpower - Residual Charge",null,"MWh","Passthrough","Capacity",65.248100483175079,12.189328658628041,9.626475539831775]
[null,"Transpower - Transitional Price Cap ",null,"MWh","Passthrough","Capacity",4.1535887923874554E-2,7.5473597617087785E-3,6.5563737641094631E-3]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",1.7851106585325001,0.45386454712325491,0.66593935061782894]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-1.0616964028286621E-2,-3.7159374099003169E-2,-1.592544604242993E-2]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-2.5381427481185175,-0.72400916904276635,-0.34197589097757586]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",0.23484307779631683,6.6989353430494156E-2,3.1641510639559015E-2]
[null,"Total",null,null,null,null,496.13490599081825,137.32652115070027,72.511970309071089]
[]
[null,null,null,null,"Distribution",null,267.00555605129057,91.649708277059091,37.954460742540704]
[null,null,null,null,"Passthrough",null,229.12934993952769,45.676812873641175,34.557509566530385]
[]
[null,"Load group 1 (incl residential)","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,0.93865133786767341,0.89608614774374151,0.86161061799321592]
[null,"CPD","%",null,null,null,0.6597116158649361,0.66424779414365154,0.60701528705613861]
[null,"Prior year distribution revenue","%",null,null,null,0.67934027544201525,0.67012091686930553,0.61474222236701648]
[null,"MWh","%",null,null,null,0.55374077794964371,0.45430581406221221,0.44294425992974462]
[null,"Regulated Asset Base","%",null,null,null,0.50612447839395758,0.3937911348730575,0.36993543789178651]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.56016996607578717,0.43376510575487648,0.43626386015520219]
[]
[null,"Load group 1 (incl residential) Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",626.46771835488846,757.44396777341046,248.68052362640861]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",1407.0708980633024,547.33679405642351,335.80963195036662]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",1167.3718377971036,1229.1496342763153,252.76858173635625]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",2517.0428706390762,3043.283609248339,999.15689303890815]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",8404.2651858217032,3269.1768194048154,2005.7505295210058]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",8923.9249644715619,3471.3193821127593,2129.7718274158096]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",6954.5109219344749,3567.9268315062359,2019.225374721148]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-3926.1890749844947,-2257.8548272304474,-1164.7736477140236]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",1753.2327281472787,1008.2410456815231,520.12759473734195]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",12092.926230213527,6954.3446183465157,3587.5811194238095]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",432.5905876321815,248.77221342266455,128.33567286238727]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",104.85643120073415,60.30035610388169,31.107520683128591]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",97.959429600079105,32.502637653013586,27.063020866564408]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",43.562529653538931,16.945397246417354,10.3965742379555]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",39.812013284171769,15.486483123119779,9.5014810885239154]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",10427.768401308434,5987.8034172146663,3061.1827262284687]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",1616.8617289539011,646.09846397379101,1014.9414944454112]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",920.211252163376,209.66428277162234,359.25368295539437]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",6618.4043237545675,1943.2555621894644,1643.0520648695217]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",4.2131693978929343,1.2032203944557767,1.1190454290984115]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",181.07169424584825,72.356306928648948,113.66288945347627]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-281.4750544996221,-109.49103854591213,-67.17645470802357]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-201.92152513405046,-116.12010566440954,-59.903602931627951]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",18.682902083012593,10.744077742860702,5.5426143757991193]
[null,"Total",null,null,null,null,59943.222164102495,30609.889149730177,17212.177158313207]
[]
[null,null,null,null,"Distribution",null,39920.624280458418,21590.367875175889,10934.098428457131]
[null,null,null,null,"Passthrough",null,20022.597883644066,9019.5212745542849,6278.078729856079]
[]
[null,"Load group 2","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,5.6236894337572438E-2,9.4925330684839507E-2,0.13047226088259098]
[null,"CPD","%",null,null,null,0.1367480364641121,0.17492235008785118,0.21142349981449213]
[null,"Prior year distribution revenue","%",null,null,null,0.15785501061560001,0.15154101415086341,0.20616041254750239]
[null,"MWh","%",null,null,null,0.1603564130612509,0.25409966062004646,0.25365414904320183]
[null,"Regulated Asset Base","%",null,null,null,0.10491179321748738,0.10370056380023211,0.12884855892806343]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.1161145887155564,0.1142272693318713,0.15195075663401322]
[]
[null,"Load group 2 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",129.85708957218421,199.46453728702662,86.615457241249572]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",84.301054318653058,57.981173241664784,50.851093280120267]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",241.97816561553219,323.68303595862341,88.039328388287444]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",521.7441408919417,801.41526341061922,348.00646984451237]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",503.52005496914643,346.3145719087268,303.72746213663788]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",534.65414159369266,367.72819342139849,322.50780072115589]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1441.5627833017641,939.57428509517956,703.29644860870246]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-813.8384013248882,-594.58123311574968,-405.69080605150617]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",363.41808643830745,265.50918907154659,181.16050579677176]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",2506.6769741790008,1831.3501598153546,1249.5549491273805]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",89.669352530649306,65.511425995098065,44.699330784900489]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",21.735119910743375,15.8794354965433,10.8347533144919]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",28.367827297023286,18.179184463961381,15.497768341180469]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",2.6099375544157577,1.7950812444230986,1.5743359215083801]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",2.3852349579707606,1.6405337090733956,1.4387934566547527]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",2423.0500548705672,1354.0807032556586,1026.600533948309]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",468.22296207096025,361.37199952363335,581.21110124108964]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",266.48168517027705,117.2681956676856,205.72833984831476]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1916.6072281620363,1086.8902918833053,940.90162363602496]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",1.2200812350629882,0.6729781667299195,0.6408267173473785]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",52.436101064654217,40.469904776019206,65.089597293090407]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-16.86385802689734,-11.598743119918749,-10.172418655014553]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-41.85521585172966,-30.578952545042853,-20.864432335344393]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",3.8726772636155937,2.8293346923803728,1.9304932749497488]
[null,"Total",null,null,null,null,10731.813277764682,7562.8505493039393,5793.1793558808158]
[]
[null,null,null,null,"Distribution",null,5513.8740895553346,4538.4391760943899,2928.068709093312]
[null,null,null,null,"Passthrough",null,5217.9391882093496,3024.4113732095507,2865.1106467875029]
[]
[null,"Load group 3","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,3.64289513272809E-3,6.7071751366356638E-3,5.1846865021870983E-3]
[null,"CPD","%",null,null,null,8.0275438940016541E-2,6.6215054312992933E-2,6.822867451100062E-2]
[null,"Prior year distribution revenue","%",null,null,null,8.0565084785142155E-2,8.1185010096931617E-2,0.10683590645587002]
[null,"MWh","%",null,null,null,0.10226784885416415,0.12999539252961032,8.6553537307239331E-2]
[null,"Regulated Asset Base","%",null,null,null,0.15730535161232259,0.21131790910164536,0.19120716729225312]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.13019944114993004,0.1898714514406154,0.15680116683601603]
[]
[null,"Load group 3 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",76.23023433770382,75.505246547072161,27.951754866038918]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",5.4608261014173927,4.0967977751966744,2.0207128715899736]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",142.0488656433813,122.52688004380552,28.411253649864239]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",306.28037526136046,303.36749516196471,112.30549196081392]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",32.616857297764909,24.469680214996696,12.069474864856023]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",34.633650969650134,25.982710601711549,12.815765051804458]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1616.4262462162226,1561.7841019116809,725.74632872072027]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-1220.2740221075799,-1211.6198636599599,-602.03226537386024]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",544.91118792473685,541.04668890669109,268.8364342357271]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",3758.5260027374488,3731.8706130725836,1854.2998399543903]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",134.45074758603883,133.49722562955162,66.332386565626649]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",32.589764935269173,32.358638987809115,16.078429644921165]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",18.091678523794855,9.3003281251703278,5.2882504597583155]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",0.16906568055898508,0.12683573714174595,6.2560717097544419E-2]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",0.15450996932096331,0.11591581324948816,5.7174551614966047E-2]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",1236.6616197230719,725.42114213668526,532.00222708700858]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",298.61078955932879,184.87507937890877,198.32467524938582]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",169.94960277009491,59.993488735330018,70.199977431414922]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1222.322790717483,556.04454482630774,321.06064139306602]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",0.77811096516335521,0.34429034944177972,0.21866710793662286]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",33.441302133226337,20.704085728241715,22.21030055637355]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-1.0924014750252249,-0.81953679706872584,-0.40422999753725769]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-62.757953557393975,-62.312875432239736,-30.962154619279847]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",5.8067147643850783,5.7655336618452315,2.864790678691016]
[null,"Total",null,null,null,null,8386.0365666774233,6844.4450474561181,3645.7584876280234]
[]
[null,null,null,null,"Distribution",null,5296.860224382106,5179.0303505757429,2442.4247908019452]
[null,null,null,null,"Passthrough",null,3089.1763422953168,1665.4146968803745,1203.3336968260783]
[]
[null,"Load group 4","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,1.3272526167690082E-3,1.9312922885647427E-3,2.3916264533547127E-3]
[null,"CPD","%",null,null,null,8.1914801035615173E-2,8.9473309931883113E-2,0.10269386749525306]
[null,"Prior year distribution revenue","%",null,null,null,5.8312919611181006E-2,8.9481851483331792E-2,6.6786677352765902E-2]
[null,"MWh","%",null,null,null,0.12127328330889786,0.1344172087290674,0.18218613011620696]
[null,"Regulated Asset Base","%",null,null,null,0.16051779659267021,0.28554401973055493,0.28779400512738107]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.13285833696548341,0.25656442327540541,0.23600807674437033]
[]
[null,"Load group 4 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",77.786986419809679,102.02671274504729,42.071370007488333]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",1.9895976877596622,1.1796492248769976,0.93212778753166481]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",144.94974702295926,165.56484966886001,42.762981086826827]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",312.53514564267698,409.9263256597431,169.03575209501591]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",11.883627615385182,7.045902893564989,5.567487128240602]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",12.618426334800485,7.4815712425641863,5.9117407976248542]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1649.4364415308532,2110.3659046551852,1092.3515347611726]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-1245.1941098019199,-1637.2053259737563,-906.1442587192879]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",556.03920863377266,731.09111797056255,404.63710240844284]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",3835.2815477157042,5042.7024406081391,2790.9852188326267]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",137.19646236789322,180.38856522474566,99.839684200754448]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",33.255303810481941,43.724717364794934,24.20032538109859]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",21.453832066795638,9.6166804263088252,11.131213308228794]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",6.1597399527584792E-2,3.6521616935017091E-2,2.885842102279694E-2]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",5.6294170879569672E-2,3.3377288007383051E-2,2.6373855013869209E-2]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",895.09431795997511,799.55680027681785,332.57228089405828]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",354.10455277066893,191.16363780368039,417.45266819056991]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",201.53299943135704,62.034177833533271,147.76359950576904]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1449.478988308339,574.95849806794024,675.79902113529977]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",0.92271493515601799,0.35600144638801673,0.4602713582607581]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",39.656026339269914,21.40833885511492,46.750356287808174]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-0.39800561461777761,-0.23598088079265478,-0.18646588466666145]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-64.039578567706371,-84.200477884401579,-46.602450166714085]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",5.9252978355010004,7.790696324291309,4.3119177745670187]
[null,"Total",null,null,null,null,8431.6274220153209,8746.8107024581514,5361.6587104467526]
[]
[null,null,null,null,"Distribution",null,5357.3266188018015,6940.1791486947877,3648.1110561856826]
[null,null,null,null,"Passthrough",null,3074.3008032135203,1806.6315537633636,1713.5476542610706]
[]
[null,"Load group 5","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,1.0621503394281335E-4,4.5937929666537001E-5,1.3654711519036372E-4]
[null,"CPD","%",null,null,null,3.3057568043861195E-2,9.9990475253856881E-4,7.173360466176326E-3]
[null,"Prior year distribution revenue","%",null,null,null,1.5351248490001025E-2,4.7378869021224351E-3,2.370121420545203E-3]
[null,"MWh","%",null,null,null,5.6902576391273794E-2,2.4332230489736786E-2,3.2066758073011972E-2]
[null,"Regulated Asset Base","%",null,null,null,6.4778622617977968E-2,3.1910837165285981E-3,2.0102954432782757E-2]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,5.3616360644288825E-2,2.8672236040077335E-3,1.6485609595866382E-2]
[]
[null,"Load group 5 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",31.391745618496259,1.1401947132315398,2.9387645993909364]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",0.15922001830546326,2.8059265521044811E-2,5.321874584456595E-2]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",58.495974653818642,1.8502621638034953,2.987074938610808]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",126.12680141515372,4.5811123063391905,11.807466317351604]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",0.95100201316955846,0.16759461707496351,0.31786916604571636]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",1.0098051904530394,0.17795747208803603,0.33752392667197584]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",665.64719331031904,23.584294570823012,76.302816377862442]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-502.51100524183806,-18.296510854118583,-63.295886703751378]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",224.39539304348418,8.1702742857510753,28.264665304372105]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",1547.7676699214976,56.354483139615709,194.9555851656078]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",55.367056170126865,2.0159238974075646,6.9739903761471087]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",13.420522965761817,0.48864351536507378,1.6904384029104815]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",10.066341775846265,1.74081344860188,1.9592156877496079]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",4.9294081616040293E-3,8.6870717602038384E-4,1.6476377964813511E-3]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",4.5050107230616586E-3,7.9391582414611362E-4,1.505784406064449E-3]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",235.63929552168884,42.334949810913407,11.802304262916588]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",0,0,0]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",166.14921947159368,34.604480633660479,73.476250410840251]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",94.561197508733898,11.229439500780538,26.008014958804022]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",680.10930857439735,104.07910437435451,118.94804342625518]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",0.43294661159085035,6.444345430243778E-2,8.1012809723056842E-2]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",18.606984214297345,3.8753418580131389,8.2285757096439838]
["Load group Streetlighting","Distributed Generation Allowance","$","MWh","Passthrough","Capacity",0,0,0]
["Load group Streetlighting","CPP recoverable costs","$","ICP Count","Passthrough","Daily Fixed",0,0,0]
["Load group Streetlighting","Quality Incentive Adjustments","$","ICP Count","Passthrough","Daily Fixed",-3.1850892084859861E-2,-5.6130670477417084E-3,-1.0646051600966887E-2]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-25.843836513522334,-0.94097846683808073,-3.2552691003512138]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",2.3912154323863186,8.7064559097838279E-2,0.30119559475069746]
[null,"Total",null,null,null,null,3404.3116352025604,277.33299782174066,500.87537774799802]
[]
[null,null,null,null,"Distribution",null,2153.4337999428594,77.757721680129492,254.66909783800656]
[null,null,null,null,"Passthrough",null,1250.877835259701,199.57527614161123,246.20627990999139]
[]
[]
[null,"Distribution"]
[]
[null,null,null,"Load group Streetlighting",396.60972507089036,null,267.00555605129057,91.649708277059091,37.954460742540704]
[null,null,null,"Load group 1 (incl residential)",72445.090584091435,null,39920.624280458418,21590.367875175889,10934.098428457131]
[null,null,null,"Load group 2",12980.381974743037,null,5513.8740895553346,4538.4391760943899,2928.068709093312]
[null,null,null,"Load group 3",12918.315365759794,null,5296.860224382106,5179.0303505757429,2442.4247908019452]
[null,null,null,"Load group 4",15945.616823682272,null,5357.3266188018015,6940.1791486947877,3648.1110561856826]
[null,null,null,"Load group 5",2485.8606194609956,null,2153.4337999428594,77.757721680129492,254.66909783800656]
[null,null,null,"Total",117171.87509280842,null,58509.124569191816,38417.423980498002,20245.326543118619]
[null,null,null,null,0]
[]
[null,"Passthrough"]
[]
[null,null,null,"Load group Streetlighting",309.36367237969921,null,229.12934993952769,45.676812873641175,34.557509566530385]
[null,null,null,"Load group 1 (incl residential)",35320.197888054434,null,20022.597883644066,9019.5212745542849,6278.078729856079]
[null,null,null,"Load group 2",11107.461208206403,null,5217.9391882093496,3024.4113732095507,2865.1106467875029]
[null,null,null,"Load group 3",5957.9247360017698,null,3089.1763422953168,1665.4146968803745,1203.3336968260783]
[null,null,null,"Load group 4",6594.4800112379544,null,3074.3008032135203,1806.6315537633636,1713.5476542610706]
[null,null,null,"Load group 5",1696.6593913113038,null,1250.877835259701,199.57527614161123,246.20627990999139]
[null,null,null,"Total",60986.086907191566,null,32884.021402561477,15761.230987422825,12340.834517207251]
[null,null,null,null,0]
[]
[null,"Total"]
[]
[null,null,null,"Load group Streetlighting",705.97339745058957,null,496.13490599081825,137.32652115070027,72.511970309071089]
[null,null,null,"Load group 1 (incl residential)",107765.28847214587,null,59943.222164102481,30609.889149730174,17212.17715831321]
[null,null,null,"Load group 2",24087.843182949437,null,10731.813277764684,7562.8505493039411,5793.1793558808149]
[null,null,null,"Load group 3",18876.240101761563,null,8386.0365666774233,6844.4450474561172,3645.7584876280234]
[null,null,null,"Load group 4",22540.096834920227,null,8431.6274220153209,8746.8107024581514,5361.6587104467535]
[null,null,null,"Load group 5",4182.5200107722994,null,3404.3116352025604,277.33299782174072,500.87537774799796]
[null,null,null,"Total",178157.962,null,91393.145971753285,54178.654967920826,32586.16106032587]
[null,null,null,null,null,null,0,0,0]
[]
[null,"Error check"]
[null,0]

{"sheet":"Outputs >","index":14,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This sheet has been deliberately left blank."]

{"sheet":"Rev - Pricing Area & Cust Group","index":15,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rev - Pricing Area & Cust Group"]
[null,"Pricing Area Name",null,null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,null,null,null,null,null,null,1,2,3]
[]
[]
[null,"Description"]
[]
[null,"This sheet summarises the output of the model with target revenue split into pricing area, customer load group, and distribution/passthrough."]
[]
[]
[null,"Distribution",null,null,null,"Units",null,"Dunedin","Central Otago","Queenstown"]
[]
[null,null,null,"Load group Streetlighting",396.60972507089036,"$000's",null,267.00555605129057,91.649708277059091,37.954460742540704]
[null,null,null,"Load group 1 (incl residential)",72445.090584091435,"$000's",null,39920.624280458418,21590.367875175889,10934.098428457131]
[null,null,null,"Load group 2",12980.381974743037,"$000's",null,5513.8740895553346,4538.4391760943899,2928.068709093312]
[null,null,null,"Load group 3",12918.315365759794,"$000's",null,5296.860224382106,5179.0303505757429,2442.4247908019452]
[null,null,null,"Load group 4",15945.616823682272,"$000's",null,5357.3266188018015,6940.1791486947877,3648.1110561856826]
[null,null,null,"Load group 5",2485.8606194609956,"$000's",null,2153.4337999428594,77.757721680129492,254.66909783800656]
[null,null,null,"Total",117171.87509280842,null,null,58509.124569191816,38417.423980498002,20245.326543118619]
[]
[]
[null,"Passthrough",null,null,null,"Units",null,"Dunedin","Central Otago","Queenstown"]
[]
[null,null,null,"Load group Streetlighting",309.36367237969921,"$000's",null,229.12934993952769,45.676812873641175,34.557509566530385]
[null,null,null,"Load group 1 (incl residential)",35320.197888054434,"$000's",null,20022.597883644066,9019.5212745542849,6278.078729856079]
[null,null,null,"Load group 2",11107.461208206403,"$000's",null,5217.9391882093496,3024.4113732095507,2865.1106467875029]
[null,null,null,"Load group 3",5957.9247360017698,"$000's",null,3089.1763422953168,1665.4146968803745,1203.3336968260783]
[null,null,null,"Load group 4",6594.4800112379544,"$000's",null,3074.3008032135203,1806.6315537633636,1713.5476542610706]
[null,null,null,"Load group 5",1696.6593913113038,"$000's",null,1250.877835259701,199.57527614161123,246.20627990999139]
[null,null,null,"Total",60986.086907191566,null,null,32884.021402561477,15761.230987422825,12340.834517207251]
[]
[]
[null,"Total",null,null,null,"Units",null,"Dunedin","Central Otago","Queenstown"]
[]
[null,null,null,"Load group Streetlighting",705.97339745058957,"$000's",null,496.13490599081825,137.32652115070027,72.511970309071089]
[null,null,null,"Load group 1 (incl residential)",107765.28847214587,"$000's",null,59943.222164102481,30609.889149730174,17212.17715831321]
[null,null,null,"Load group 2",24087.843182949437,"$000's",null,10731.813277764684,7562.8505493039411,5793.1793558808149]
[null,null,null,"Load group 3",18876.240101761563,"$000's",null,8386.0365666774233,6844.4450474561172,3645.7584876280234]
[null,null,null,"Load group 4",22540.096834920227,"$000's",null,8431.6274220153209,8746.8107024581514,5361.6587104467535]
[null,null,null,"Load group 5",4182.5200107722994,"$000's",null,3404.3116352025604,277.33299782174072,500.87537774799796]
[null,null,null,"Total",178157.962,null,null,91393.145971753285,54178.654967920826,32586.16106032587]
[]
[]
[null,null,"Error check"]
[null,null,0]

{"sheet":"Pricing Methodology Tables","index":16,"n_rows":47,"n_cols":32,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,6,11,6],[10,7,10,10],[10,29,11,29],[10,23,10,28]]}
[]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Pricing Methodology Tables"}]
[null,"Description"]
[]
[null,"This sheet links the model information in a format to be included in our annual Pricing Methodology document."]
[]
[]
[]
[]
[null,null,"Table 2: Components of forecast allowable revenue ($m)",null,null,null,"Table 4: Pricing area allocation percentages",null,null,null,null,null,null,null,"Table 5: Total forecast allowable revenue by pricing area",null,null,null,null,null,null,null,"Table 8: Load group allocation percentages"]
[null,null,null,{"$f":"'Name labels'!$E$10","v":"RY26"},{"$f":"'Name labels'!$D$10","v":"RY25"},null,"Cost Allocators","Pricing Area",null,null,null,null,null,null,"Components ($m)","Dunedin","Central","Queenstown","Total",null,null,null,null,"Load Group",null,null,null,null,null,"Total"]
[null,null,{"$f":"'Name labels'!C70","v":"Capital related costs"},null,null,null,null,"Dunedin","Central","Queenstown","Total",null,null,null,{"$f":"'Name labels'!C70","v":"Capital related costs"},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O12,'Pricing Area Allocations'!H$31:H$58))/1000","v":32.01486332105307},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O12,'Pricing Area Allocations'!I$31:I$58))/1000","v":22.712173333137958},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O12,'Pricing Area Allocations'!J$31:J$58))/1000","v":12.583716486248006},{"$f":"SUM(P12:R12)","v":67.310753140439033},null,null,null,"Cost Allocators "," SL ","L1 ","L2 ","L3 ","L4 ","L5 "]
[null,null,{"$f":"'Name labels'!B25","v":"Asset revaluations and other regulatory revenue"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C13,'Target Revenue'!$J$17:$J$47)/1000","v":-16.167272790798499},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C13,'Target Revenue'!$I$17:$I$47)/1000","v":-14.969489381004101},null,{"$f":"'Pricing Area Allocations'!B14","v":"ICP Count"},{"$f":"'Pricing Area Allocations'!H14","v":0.59971238990027631},{"$f":"'Pricing Area Allocations'!I14","v":0.2443634366709711},{"$f":"'Pricing Area Allocations'!J14","v":0.15592417342875256},{"$f":"SUM(H13:J13)","v":0.99999999999999989},null,{"$f":"IF(K13=1,0,1)","v":0},null,{"$f":"'Name labels'!C71","v":"Operational costs"},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O13,'Pricing Area Allocations'!H$31:H$58))/1000","v":26.494261248138748},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O13,'Pricing Area Allocations'!I$31:I$58))/1000","v":15.705250647360041},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O13,'Pricing Area Allocations'!J$31:J$58))/1000","v":7.6616100568706118},{"$f":"SUM(P13:R13)","v":49.861121952369402},null,null,null,"Dunedin"]
[null,null,{"$f":"'Name labels'!B24","v":"Depreciation"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C14,'Target Revenue'!$J$17:$J$47)/1000","v":24.5516844866479},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C14,'Target Revenue'!$I$17:$I$47)/1000","v":23.086187750556199},null,{"$f":"'Pricing Area Allocations'!B15","v":"Total Circuit Length"},{"$f":"'Pricing Area Allocations'!H15","v":0.3799057877478465},{"$f":"'Pricing Area Allocations'!I15","v":0.45619627463265422},{"$f":"'Pricing Area Allocations'!J15","v":0.16389793761949936},1,null,0,null,{"$f":"'Name labels'!C72","v":"Passthrough and recoverable costs"},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O14,'Pricing Area Allocations'!H$31:H$58))/1000","v":32.884021402561494},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O14,'Pricing Area Allocations'!I$31:I$58))/1000","v":15.761230987422826},{"$f":"(SUMIF('Pricing Area Allocations'!$C$31:$J$58,$O14,'Pricing Area Allocations'!J$31:J$58))/1000","v":12.340834517207254},{"$f":"SUM(P14:R14)","v":60.986086907191577},null,null,null,{"$f":"'Load Group Allocations'!B16","v":"ICP Count"},{"$f":"'Allocator Data'!$I$26","v":3.5405011314271118E-5},{"$f":"'Allocator Data'!$I$27","v":0.93865133786767341},{"$f":"'Allocator Data'!$I$28","v":5.6236894337572438E-2},{"$f":"'Allocator Data'!$I$29","v":3.64289513272809E-3},{"$f":"'Allocator Data'!$I$30","v":1.3272526167690082E-3},{"$f":"'Allocator Data'!$I$31","v":1.0621503394281335E-4},{"$f":"SUM(X14:AC14)","v":1},null,{"$f":"IF(AD14=1,0,1)","v":0}]
[null,null,{"$f":"'Name labels'!B27","v":"Return on capital"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C15,'Target Revenue'!$J$17:$J$47)/1000","v":49.796286798448889},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C15,'Target Revenue'!$I$17:$I$47)/1000","v":30.078693430175953},null,{"$f":"'Pricing Area Allocations'!B16","v":"Overhead Circuit Length"},{"$f":"'Pricing Area Allocations'!H16","v":0.43839361120610987},{"$f":"'Pricing Area Allocations'!I16","v":0.45844133745203358},{"$f":"'Pricing Area Allocations'!J16","v":0.10316505134185656},1,null,0,null,"Total forecast allowable revenue",{"$f":"SUM(P12:P14)","v":91.393145971753313},{"$f":"SUM(Q12:Q14)","v":54.178654967920828},{"$f":"SUM(R12:R14)","v":32.586161060325871},{"$f":"SUM(S12:S14)","v":178.157962},null,null,null,{"$f":"'Load Group Allocations'!B17","v":"CPD"},{"$f":"'Allocator Data'!$I$66","v":8.2925396514587392E-3},{"$f":"'Allocator Data'!$I$67","v":0.6597116158649361},{"$f":"'Allocator Data'!$I$68","v":0.1367480364641121},{"$f":"'Allocator Data'!$I$69","v":8.0275438940016541E-2},{"$f":"'Allocator Data'!$I$70","v":8.1914801035615173E-2},{"$f":"'Allocator Data'!$I$71","v":3.3057568043861195E-2},{"$f":"SUM(X15:AC15)","v":0.99999999999999989},null,{"$f":"IF(AD15=1,0,1)","v":0}]
[null,null,{"$f":"'Name labels'!B26","v":"Tax"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C16,'Target Revenue'!$J$17:$J$47)/1000","v":7.2194668265752995},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C16,'Target Revenue'!$I$17:$I$47)/1000","v":6.8009859366589795},null,{"$f":"'Pricing Area Allocations'!B22","v":"Prior year distribution revenue"},{"$f":"'Pricing Area Allocations'!H22","v":0.52451434108599393},{"$f":"'Pricing Area Allocations'!I22","v":0.30532875914528951},{"$f":"'Pricing Area Allocations'!J22","v":0.17015689976871662},1,null,{"$f":"IF(K16=1,0,1)","v":0},null,"% of forecast allowable revenue",{"$f":"P15/$S$15","v":0.51298939966406509},{"$f":"Q15/$S$15","v":0.30410459549330066},{"$f":"R15/$S$15","v":0.18290600484263439},{"$f":"SUM(P16:R16)","v":1},null,null,null,{"$f":"'Load Group Allocations'!B18","v":"Prior year distribution revenue"},{"$f":"'Allocator Data'!$I$122","v":8.575461056060607E-3},{"$f":"'Allocator Data'!$I$123","v":0.67934027544201525},{"$f":"'Allocator Data'!$I$124","v":0.15785501061560001},{"$f":"'Allocator Data'!$I$125","v":8.0565084785142155E-2},{"$f":"'Allocator Data'!$I$126","v":5.8312919611181006E-2},{"$f":"'Allocator Data'!$I$127","v":1.5351248490001025E-2},1.0000000000000002,null,0]
[null,null,{"$f":"'Name labels'!C71","v":"Operational costs"},null,null,null,{"$f":"'Name labels'!B43","v":"Transmission Costs"},{"$f":"SUM('Pricing Area Allocations'!H48:H54)/SUM('Pricing Area Allocations'!$E48:$E54)","v":0.5574068032445948},{"$f":"SUM('Pricing Area Allocations'!I48:I54)/SUM('Pricing Area Allocations'!$E48:$E54)","v":0.2089392193259148},{"$f":"SUM('Pricing Area Allocations'!J48:J54)/SUM('Pricing Area Allocations'!$E48:$E54)","v":0.23365397742949043},1,null,0,null,null,null,null,null,null,null,null,null,{"$f":"'Load Group Allocations'!B19","v":"MWh"},{"$f":"'Allocator Data'!$I$146","v":5.4591004347696506E-3},{"$f":"'Allocator Data'!$I$147","v":0.55374077794964371},{"$f":"'Allocator Data'!$I$148","v":0.1603564130612509},{"$f":"'Allocator Data'!$I$149","v":0.10226784885416415},{"$f":"'Allocator Data'!$I$150","v":0.12127328330889786},{"$f":"'Allocator Data'!$I$151","v":5.6902576391273794E-2},1,null,0]
[null,null,{"$f":"'Name labels'!B23","v":"Business support"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C18,'Target Revenue'!$J$17:$J$47)/1000","v":15.402917218007879},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C18,'Target Revenue'!$I$17:$I$47)/1000","v":15.270333012204491},null,{"$f":"'Pricing Area Allocations'!B23","v":"MWh"},{"$f":"'Pricing Area Allocations'!H23","v":0.57149703763448501},{"$f":"'Pricing Area Allocations'!I23","v":0.23112373857176341},{"$f":"'Pricing Area Allocations'!J23","v":0.19737922379375161},1,null,0,null,null,null,null,null,null,null,null,null,{"$f":"'Load Group Allocations'!B20","v":"Regulated Asset Base"},{"$f":"'RAB Allocations'!$I$27","v":6.36195756558429E-3},{"$f":"'RAB Allocations'!$I$28","v":0.50612447839395758},{"$f":"'RAB Allocations'!$I$29","v":0.10491179321748738},{"$f":"'RAB Allocations'!$I$30","v":0.15730535161232259},{"$f":"'RAB Allocations'!$I$31","v":0.16051779659267021},{"$f":"'RAB Allocations'!$I$32","v":6.4778622617977968E-2},1,null,0]
[null,null,{"$f":"'Name labels'!B21","v":"Routine and corrective maintenance and inspection"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C19,'Target Revenue'!$J$17:$J$47)/1000","v":9.7578686518572386},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C19,'Target Revenue'!$I$17:$I$47)/1000","v":9.5698618079384303},null,{"$f":"'Pricing Area Allocations'!B24","v":"Regulated Asset Base"},{"$f":"'Pricing Area Allocations'!H24","v":0.46619917222400725},{"$f":"'Pricing Area Allocations'!I24","v":0.34457813000638982},{"$f":"'Pricing Area Allocations'!J24","v":0.1892226977696029},0.99999999999999989,null,0,null,null,null,null,null,null,null,null,null,{"$f":"'Load Group Allocations'!B21","v":"Regulated Asset Base (Depreciation)"},{"$f":"'RAB - Depreciation Allocations'!$I$27","v":7.0413064489541878E-3},{"$f":"'RAB - Depreciation Allocations'!$I$28","v":0.56016996607578717},{"$f":"'RAB - Depreciation Allocations'!$I$29","v":0.1161145887155564},{"$f":"'RAB - Depreciation Allocations'!$I$30","v":0.13019944114993004},{"$f":"'RAB - Depreciation Allocations'!$I$31","v":0.13285833696548341},{"$f":"'RAB - Depreciation Allocations'!$I$32","v":5.3616360644288825E-2},{"$f":"SUM(X19:AC19)","v":1},null,0]
[null,null,{"$f":"'Name labels'!B19","v":"Service interruptions and emergencies"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C20,'Target Revenue'!$J$17:$J$47)/1000","v":4.85727897736093},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C20,'Target Revenue'!$I$17:$I$47)/1000","v":4.8571197303863904},null,{"$f":"'Pricing Area Allocations'!B25","v":"Regulated Asset Base (Depreciation)"},{"$f":"'Pricing Area Allocations'!H25","v":0.49131483237720824},{"$f":"'Pricing Area Allocations'!I25","v":0.32551756580553121},{"$f":"'Pricing Area Allocations'!J25","v":0.18316760181726055},1,null,0,null,null,null,null,null,null,null,null,null,"Central Otago & Wanaka"]
[null,null,{"$f":"'Name labels'!B22","v":"System operations and network support"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C21,'Target Revenue'!$J$17:$J$47)/1000","v":14.505971470039453},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C21,'Target Revenue'!$I$17:$I$47)/1000","v":15.090427082432431},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W14","v":"ICP Count"},{"$f":"'Allocator Data'!$J$26","v":3.0411621655211256E-4},{"$f":"'Allocator Data'!$J$27","v":0.89608614774374151},{"$f":"'Allocator Data'!$J$28","v":9.4925330684839507E-2},{"$f":"'Allocator Data'!$J$29","v":6.7071751366356638E-3},{"$f":"'Allocator Data'!$J$30","v":1.9312922885647427E-3},{"$f":"'Allocator Data'!$J$31","v":4.5937929666537001E-5},{"$f":"SUM(X21:AC21)","v":1}]
[null,null,{"$f":"'Name labels'!B20","v":"Vegetation management"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C22,'Target Revenue'!$J$17:$J$47)/1000","v":3.9217983618609003},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C22,'Target Revenue'!$I$17:$I$47)/1000","v":3.9378806306512302},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W15","v":"CPD"},{"$f":"'Allocator Data'!$J$66","v":4.1415867710826292E-3},{"$f":"'Allocator Data'!$J$67","v":0.66424779414365154},{"$f":"'Allocator Data'!$J$68","v":0.17492235008785118},{"$f":"'Allocator Data'!$J$69","v":6.6215054312992933E-2},{"$f":"'Allocator Data'!$J$70","v":8.9473309931883113E-2},{"$f":"'Allocator Data'!$J$71","v":9.9990475253856881E-4},{"$f":"SUM(X22:AC22)","v":0.99999999999999989}]
[null,null,{"$f":"'Name labels'!C72","v":"Passthrough and recoverable costs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior year distribution revenue",{"$f":"'Allocator Data'!$J$122","v":2.93332049744528E-3},{"$f":"'Allocator Data'!$J$123","v":0.67012091686930553},{"$f":"'Allocator Data'!$J$124","v":0.15154101415086341},{"$f":"'Allocator Data'!$J$125","v":8.1185010096931617E-2},{"$f":"'Allocator Data'!$J$126","v":8.9481851483331792E-2},{"$f":"'Allocator Data'!$J$127","v":4.7378869021224351E-3},1]
[null,null,{"$f":"'Name labels'!B33","v":"Capex Incentive Amount"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C24,'Target Revenue'!$J$17:$J$47)/1000","v":0},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C24,'Target Revenue'!$I$17:$I$47)/1000","v":-1.58140721004899},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWh",{"$f":"'Allocator Data'!$J$146","v":2.849693569326807E-3},{"$f":"'Allocator Data'!$J$147","v":0.45430581406221221},{"$f":"'Allocator Data'!$J$148","v":0.25409966062004646},{"$f":"'Allocator Data'!$J$149","v":0.12999539252961032},{"$f":"'Allocator Data'!$J$150","v":0.1344172087290674},{"$f":"'Allocator Data'!$J$151","v":2.4332230489736786E-2},1]
[null,null,{"$f":"'Name labels'!B40","v":"Capex Wash-up Adjustment"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C25,'Target Revenue'!$J$17:$J$47)/1000","v":-0.85576353657879101},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C25,'Target Revenue'!$I$17:$I$47)/1000","v":-0.83148419799727091},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base",{"$f":"'RAB Allocations'!$J$27","v":2.455288777981496E-3},{"$f":"'RAB Allocations'!$J$28","v":0.3937911348730575},{"$f":"'RAB Allocations'!$J$29","v":0.10370056380023211},{"$f":"'RAB Allocations'!$J$30","v":0.21131790910164536},{"$f":"'RAB Allocations'!$J$31","v":0.28554401973055493},{"$f":"'RAB Allocations'!$J$32","v":3.1910837165285981E-3},1]
[null,null,{"$f":"'Name labels'!B29","v":"Commerce Act levies"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C26,'Target Revenue'!$J$17:$J$47)/1000","v":0.44439200000000001},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C26,'Target Revenue'!$I$17:$I$47)/1000","v":0.45029000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base (Depreciation)",{"$f":"'RAB - Depreciation Allocations'!$J$27","v":2.70452659322365E-3},{"$f":"'RAB - Depreciation Allocations'!$J$28","v":0.43376510575487648},{"$f":"'RAB - Depreciation Allocations'!$J$29","v":0.1142272693318713},{"$f":"'RAB - Depreciation Allocations'!$J$30","v":0.1898714514406154},{"$f":"'RAB - Depreciation Allocations'!$J$31","v":0.25656442327540541},{"$f":"'RAB - Depreciation Allocations'!$J$32","v":2.8672236040077335E-3},{"$f":"SUM(X26:AC26)","v":1}]
[null,null,{"$f":"'Name labels'!B30","v":"Electricity Authority levies"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C27,'Target Revenue'!$J$17:$J$47)/1000","v":0.38693299999999997},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C27,'Target Revenue'!$I$17:$I$47)/1000","v":0.29513799999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown"]
[null,null,{"$f":"'Name labels'!B41","v":"Fire and Emergency Management New Zealand (FENZ) levies"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C28,'Target Revenue'!$J$17:$J$47)/1000","v":7.918E-2},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C28,'Target Revenue'!$I$17:$I$47)/1000","v":4.8644E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W21","v":"ICP Count"},{"$f":"'Allocator Data'!$K$26","v":2.0426105346099435E-4},{"$f":"'Allocator Data'!$K$27","v":0.86161061799321592},{"$f":"'Allocator Data'!$K$28","v":0.13047226088259098},{"$f":"'Allocator Data'!$K$29","v":5.1846865021870983E-3},{"$f":"'Allocator Data'!$K$30","v":2.3916264533547127E-3},{"$f":"'Allocator Data'!$K$31","v":1.3654711519036372E-4},{"$f":"SUM(X28:AC28)","v":1}]
[null,null,{"$f":"'Name labels'!B28","v":"Local Authority rates"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C29,'Target Revenue'!$J$17:$J$47)/1000","v":1.8333620000000002},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C29,'Target Revenue'!$I$17:$I$47)/1000","v":1.641464},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W22","v":"CPD"},{"$f":"'Allocator Data'!$K$66","v":3.4653106569393216E-3},{"$f":"'Allocator Data'!$K$67","v":0.60701528705613861},{"$f":"'Allocator Data'!$K$68","v":0.21142349981449213},{"$f":"'Allocator Data'!$K$69","v":6.822867451100062E-2},{"$f":"'Allocator Data'!$K$70","v":0.10269386749525306},{"$f":"'Allocator Data'!$K$71","v":7.173360466176326E-3},{"$f":"SUM(X29:AC29)","v":1.0000000000000002}]
[null,null,{"$f":"'Name labels'!B32","v":"Opex Incentive Amount"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C30,'Target Revenue'!$J$17:$J$47)/1000","v":29.264873218837202},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C30,'Target Revenue'!$I$17:$I$47)/1000","v":28.4345833840237},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior year distribution revenue",{"$f":"'Allocator Data'!$K$122","v":3.1046598562999325E-3},{"$f":"'Allocator Data'!$K$123","v":0.61474222236701648},{"$f":"'Allocator Data'!$K$124","v":0.20616041254750239},{"$f":"'Allocator Data'!$K$125","v":0.10683590645587002},{"$f":"'Allocator Data'!$K$126","v":6.6786677352765902E-2},{"$f":"'Allocator Data'!$K$127","v":2.370121420545203E-3},0.99999999999999989]
[null,null,{"$f":"'Name labels'!B39","v":"Quality Incentive Adjustments"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C31,'Target Revenue'!$J$17:$J$47)/1000","v":-0.50002599999999997},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C31,'Target Revenue'!$I$17:$I$47)/1000","v":-0.58166399999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWh",{"$f":"'Allocator Data'!$K$146","v":2.5951655305951533E-3},{"$f":"'Allocator Data'!$K$147","v":0.44294425992974462},{"$f":"'Allocator Data'!$K$148","v":0.25365414904320183},{"$f":"'Allocator Data'!$K$149","v":8.6553537307239331E-2},{"$f":"'Allocator Data'!$K$150","v":0.18218613011620696},{"$f":"'Allocator Data'!$K$151","v":3.2066758073011972E-2},0.99999999999999989]
[null,null,{"$f":"'Name labels'!B43","v":"Transmission Costs"},{"$f":"(SUMIF('Target Revenue'!$B$17:$J$47,$C32,'Target Revenue'!$J$17:$J$47)/1000)-D34","v":30.262412224933144},{"$f":"(SUMIF('Target Revenue'!$B$17:$J$47,$C32,'Target Revenue'!$I$17:$I$47)/1000)-E34","v":26.197973692660838},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base",{"$f":"'RAB Allocations'!$K$27","v":2.1118763277330195E-3},{"$f":"'RAB Allocations'!$K$28","v":0.36993543789178651},{"$f":"'RAB Allocations'!$K$29","v":0.12884855892806343},{"$f":"'RAB Allocations'!$K$30","v":0.19120716729225312},{"$f":"'RAB Allocations'!$K$31","v":0.28779400512738107},{"$f":"'RAB Allocations'!$K$32","v":2.0102954432782757E-2},0.99999999999999989]
[null,null,"CPP recoverable costs",{"$f":"'Target Revenue'!J41/1000","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W26","v":"Regulated Asset Base (Depreciation)"},{"$f":"'RAB - Depreciation Allocations'!$K$27","v":2.4905300345318868E-3},{"$f":"'RAB - Depreciation Allocations'!$K$28","v":0.43626386015520219},{"$f":"'RAB - Depreciation Allocations'!$K$29","v":0.15195075663401322},{"$f":"'RAB - Depreciation Allocations'!$K$30","v":0.15680116683601603},{"$f":"'RAB - Depreciation Allocations'!$K$31","v":0.23600807674437033},{"$f":"'RAB - Depreciation Allocations'!$K$32","v":1.6485609595866382E-2},{"$f":"SUM(X33:AC33)","v":1}]
[null,null,"Avoided Cost Of Transmission (ACOT)",{"$f":"'Target Revenue'!J40/1000","v":0},{"$f":"'Target Revenue'!I40/1000","v":0}]
[null,null,{"$f":"'Name labels'!B31","v":"Utilities Disputes levies"},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C35,'Target Revenue'!$J$17:$J$47)/1000","v":7.0724000000000009E-2},{"$f":"SUMIF('Target Revenue'!$B$17:$J$47,$C35,'Target Revenue'!$I$17:$I$47)/1000","v":6.7266999999999993E-2}]
[null,null,"Opening Wash-up Account Balance",{"$f":"'Target Revenue'!J45/1000","v":28.075412845305141},{"$f":"'Target Revenue'!I45/1000","v":25.479254278368497}]
[null,null,"Target Revenue (before revenue limit applied)",{"$f":"SUM(D13:D36)","v":202.90749975249668},{"$f":"SUM(E13:E36)","v":173.34205894700673}]
[null,null,"Revenue deferred to future periods",{"$f":"D39-D37","v":-24.749537752496678},{"$f":"E39-E37","v":-15.240251947006726}]
[null,null,"Target Revenue",{"$f":"'Target Revenue'!J47/1000","v":178.157962},{"$f":"'Target Revenue'!I47/1000","v":158.10180700000001}]
[]
[null,null,null,{"$f":"IF((D37*1000)=('Target Revenue'!J46),0,1)","v":0}]
[null,null,null,{"$f":"IF((D39*1000)='Target Revenue'!J47,0,1)","v":0}]
[]
[]
[]
[null,null,"Error check"]
[null,null,{"$f":"IF(SUM(D41:D42,M13:M20,S18:S19,AF14:AF19,U15)>0.0001,1,0)","v":0}]