{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["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":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Model Guide","index":0,"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,"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",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":1,"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":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"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",0]
[]
[null,"Target Revenue"]
[null,"Scaled revenue is equal to limit on forecast revenue from prices","Ok / Error",0]
[]
[null,"Asset Mapping"]
[null,"Network types are fully allocated","Ok / Error",0]
[]
[null,"Pricing Area Allocations"]
[null,"Target revenue is fully allocated to pricing areas","Ok / Error",0]
[]
[null,"RAB Allocations"]
[null,"RAB is fully allocated to pricing areas and load groups","Ok / Error",0]
[]
[null,"RAB - Depreciation Allocations"]
[null,"RAB is fully allocated to pricing areas and load groups","Ok / Error",0]
[]
[null,"Price Allocations"]
[null,"Pricing area load group totals match pricing area allocations","Ok / Error",0]
[]
[null,"Revenue by Pricing Area and Load Group"]
[null,"Distribution and passthrough by load group matches target revenue","Ok / Error",0]
[]
[null,"Pricing Methodology Tables"]
[null,"Table updates match model inputs","Ok / Error",0]

{"sheet":"Name labels","index":3,"n_rows":93,"n_cols":5,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,"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","RY24","RY25"]
[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":4,"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":5,"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,"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,"Target Revenue Components",null,"Pricing Area Allocators","Load Group Allocators","Tariff Type","Distribution / Passthrough","Cost type","RY24 inputs ($000's)","RY25 inputs ($000's)","Scaled target revenue","Source & comments"]
[]
[null,"Service interruptions and emergencies","(50% allocated by Total Circuit Length)","Total Circuit Length","CPD","Capacity","Distribution","Operational costs",2411.0110231724452,2428.559865193195,2693.8767611361395,"Aurora CPP Expenditure Model With ComCom Adjustments - Final Decision - 31 March 2021 (published on Commerce Commission website). Sheet CPP model output"]
[null,"Service interruptions and emergencies","(50% allocated by ICP Count)","ICP Count","ICP Count","Daily Fixed","Distribution","Operational costs",2411.0110231724452,2428.559865193195,2693.8767611361395]
[null,"Vegetation management",null,"Overhead Circuit Length","CPD","Distance","Distribution","Operational costs",3927.0945124520099,3937.8806306512301,4368.0887883715322]
[null,"Routine and corrective maintenance and inspection",null,"Total Circuit Length","CPD","Capacity","Distribution","Operational costs",10394.2282825647,9569.8618079384305,10615.356327499378]
[null,"System operations and network support",null,"ICP Count","ICP Count","Daily Fixed","Distribution","Operational costs",15385.3000464578,15090.42708243243,16739.035926442051]
[null,"Business support",null,"ICP Count","ICP Count","Daily Fixed","Distribution","Operational costs",15675.299000000001,15270.33301220449,16938.596336852188]
[null,"Depreciation",null,"Regulated Asset Base (Depreciation)","Regulated Asset Base (Depreciation)","Capacity","Distribution","Capital related costs",21466.138091127999,23086.187750556201,25608.322683658349,"Aurora CPP Financial Model With ComCom Adjustments - Final Decision - 31 March 2021 (published on Commerce Commission website). \nSheet RABx\nSheet TAXx"]
[null,"Asset revaluations and other regulatory revenue",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Distribution","Capital related costs",-13617.875084424601,-14969.489381004101,-16604.885943939116]
[null,"Tax",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Distribution","Capital related costs",6247.9560000000001,6800.9859366589799,7543.9844947457641]
[null,"Return on capital",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Distribution","Capital related costs",32295.837105477214,30078.693430175954,33364.750195459303,"Amount required to balance to Forecast net allowable revenue "]
[null,"Local Authority rates",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Passthrough","Passthrough and recoverable costs",1189.0889999999999,1641.4639999999999,1641.4639999999999,"Annual Price-Setting Compliance Statement - Table 6"]
[null,"Commerce Act levies",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Passthrough","Passthrough and recoverable costs",325.04500000000002,450.29,450.29]
[null,"Electricity Authority levies","(80% allocated by MWh)","MWh","MWh","Capacity","Passthrough","Passthrough and recoverable costs",222.06399999999999,236.1104,236.1104]
[null,"Electricity Authority levies","(20% allocated by ICP Count)","ICP Count","ICP Count","Daily Fixed","Passthrough","Passthrough and recoverable costs",55.515999999999991,59.0276,59.0276]
[null,"Utilities Disputes levies",null,"ICP Count","ICP Count","Daily Fixed","Passthrough","Passthrough and recoverable costs",67.387,67.266999999999996,67.266999999999996]
[null,"Opex Incentive Amount",null,"Prior year distribution revenue","Prior year distribution revenue","Daily Fixed","Passthrough","Passthrough and recoverable costs",20937.447,28434.583384023699,28434.583384023699]
[null,"Capex Incentive Amount",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Passthrough","Passthrough and recoverable costs",-1536.54,-1581.40721004899,-1581.40721004899]
[null,"Transmission Costs","Transpower  - Connection charge","Transpower connection charge and NIC","MWh","Capacity","Passthrough","Passthrough and recoverable costs",5212.652,5381.7443300000004,5381.7443300000004]
[null,"Transmission Costs","Transpower - Benefit-based Charge","Transpower benefit based charge","MWh","Capacity","Passthrough","Passthrough and recoverable costs",2782.6689999999999,2713.7791426608401,2713.7791426608401]
[null,"Transmission Costs","Transpower - Residual Charge","Transpower residual charge","MWh","Capacity","Passthrough","Passthrough and recoverable costs",16817.116999999998,17310.83239,17310.83239]
[null,"Transmission Costs","Transpower - Transitional Price Cap ","Transpower transitional price cap","MWh","Capacity","Passthrough","Passthrough and recoverable costs",76.978999999999999,16.746749999999999,16.746749999999999]
[null,"Transmission Costs","Transpower - Interconnection costs","Transpower connection charge and NIC","MWh","Capacity","Passthrough","Passthrough and recoverable costs",null,null,0]
[null,"Transmission Costs","Transpower - New investment contract","Transpower connection charge and NIC","MWh","Capacity","Passthrough","Passthrough and recoverable costs",null,774.87108000000001,774.87108000000001]
[null,"Transmission Costs","Distributed Generation Allowance","Distributed Generation Allowance","MWh","Capacity","Passthrough","Passthrough and recoverable costs",null,null,0]
[null,"CPP recoverable costs",null,"ICP Count","ICP Count","Daily Fixed","Passthrough","Passthrough and recoverable costs",0,0,0]
[null,"Quality Incentive Adjustments",null,"ICP Count","ICP Count","Daily Fixed","Passthrough","Passthrough and recoverable costs",-566.82000000000005,-581.66399999999999,-581.66399999999999]
[null,"Capex Wash-up Adjustment",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Passthrough","Passthrough and recoverable costs",-807.89400000000001,-831.48419799727094,-831.48419799727094]
[null,"Fire and Emergency Management New Zealand (FENZ) levies",null,"Regulated Asset Base","Regulated Asset Base","Capacity","Passthrough","Passthrough and recoverable costs",29.084,48.643999999999998,48.643999999999998]
[null,"Opening wash-up Account Balance",null,null,null,null,null,null,14575.718000000001,25479.254278368498,null,"Annual Price-Setting Compliance Statement - Table 5"]
[null,"Forecast Allowable Revenue",null,null,null,null,null,null,155975.51299999998,173342.05894700679]
[null,"Forecast Revenue From Prices",null,null,null,null,null,null,141029.49600000001,158101.807]
[null,"Revenue Deferred to Future Periods",null,null,null,null,null,null,14946.016999999963,15240.251947006793]
[null,null,null,null,null,null,null,null,null,0]
[null,"Forecast net allowable revenue",93722000,"Aurora Energy Limited Electricity Distribution Customised Price-Quality Path Determination 2021 (Schedule 1.3)"]
[null,"Limit on Forecast Revenue From Prices",158101807,"Annual Price-Setting Compliance Statement (Table 10)"]
[]
[null,null,null,"Scaling"]
[null,"Capital related costs",44996.377736387032,1.1092486537991264]
[null,"Operational costs",48725.622263612968,1.1092486537991264]
[null,"Passthrough and recoverable costs",54140.804668638273,1]
[null,"Revenue deferrred & Wash-ups",64379.807000000001,0]
[null,"Forecast Revenue From Prices",158101.807]

{"sheet":"Allocator Data","index":6,"n_rows":210,"n_cols":11,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Allocator Data"]
[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 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,"ICP Count","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2023 - Schedule 8 (excluding Load group 0, Load Group 0A, and Distributed Generation)"]
[null,"Load group Streetlighting","#",4.9801369863013694,null,null,null,null,2,0.23013698630136986,2.75]
[null,"Load group 1 (incl residential)","#",85427.493150684953,null,null,null,null,52766.8082191781,20176.835616438399,12483.849315068455]
[null,"Load group 2","#",7100.6082191780861,null,null,null,null,3158.0027397260274,2097.3890410958943,1845.2164383561644]
[null,"Load group 3","#",413.42191780821912,null,null,null,null,199.14246575342452,140.79726027397257,73.482191780822006]
[null,"Load group 4","#",148.09041095890416,null,null,null,null,74.372602739726034,41.389041095890398,32.328767123287705]
[null,"Load group 5","#",9,null,null,null,null,6,1,2]
[null,"Total",null,93103.593835616455,null,null,null,null,56206.326027397277,22457.64109589046,14439.626712328731]
[null,null,null,null,null,null,null,null,0.60369663201868518,0.24121132354505706,0.15509204443625785]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,5.3490276595490941E-5,null,null,null,null,3.5583183270600493E-5,1.0247602823409748E-5,1.904481365610384E-4]
[null,"Load group 1 (incl residential)",null,0.91755312154239277,null,null,null,null,0.93880550373382143,0.89843966827533694,0.8645548506049392]
[null,"Load group 2",null,7.6265672748518254E-2,null,null,null,null,5.6185895128364853E-2,9.3393114269677099E-2,0.12778837535881007]
[null,"Load group 3",null,4.4404506934303326E-3,null,null,null,null,3.5430614279316937E-3,6.2694590083077406E-3,5.088925998210328E-3]
[null,"Load group 4",null,1.5905982235269278E-3,null,null,null,null,1.3232069767996179E-3,1.8429825696815597E-3,2.2388921657985109E-3]
[null,"Load group 5",null,9.6666515536343147E-5,null,null,null,null,1.0674954981180149E-4,4.45282741731495E-5,1.385077356807552E-4]
[null,"Total",null,1,null,null,null,null,1,0.99999999999999989,0.99999999999999989]
[]
[]
[]
[2,"Total Circuit Length","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2023 - Schedule 9c"]
[null,"Total","km",6254,null,null,null,null,2391,2847,1016]
[null,null,null,null,null,null,null,null,0.38231531819635434,0.45522865366165655,0.16245602814198912]
[]
[]
[3,"Overhead Circuit Length","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2023 - Schedule 9c"]
[null,"Total","km",3835,null,null,null,null,1683,1754,398]
[null,null,null,null,null,null,null,null,0.43885267275097783,0.45736636245110823,0.10378096479791395]
[]
[]
[4,"CPD","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual CPD assessments"]
[null,"Load group Streetlighting","kW",1719.9,null,null,null,null,1154,318.90000000000003,247]
[null,"Load group 1 (incl residential)","kW",203606.73000000097,null,null,null,null,111990.03000000052,49532.200000000259,42084.500000000182]
[null,"Load group 2","kW",50863.100000000049,null,null,null,null,24297.900000000016,12517.400000000045,14047.799999999992]
[null,"Load group 3","kW",23628.9,null,null,null,null,14046.9,4950.5,4631.5]
[null,"Load group 4","kW",27701.1,null,null,null,null,14271.000000000002,6195,7235.1]
[null,"Load group 5","kW",6554.8,null,null,null,null,5936.8,92.7,525.29999999999995]
[null,"Total",null,314074.53000000102,null,null,null,null,171696.63000000053,73606.700000000303,68771.200000000186]
[null,null,null,null,null,null,null,null,0.54667479722090162,0.23436061497887162,0.21896458780022679]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,5.4760887487437923E-3,null,null,null,null,6.721156961554787E-3,4.3324860372764805E-3,3.5916197478013953E-3]
[null,"Load group 1 (incl residential)",null,0.64827520397785932,null,null,null,null,0.65225525975670096,0.67293058919908177,0.61194947885161333]
[null,"Load group 2",null,0.16194595594873576,null,null,null,null,0.14151646424277484,0.17005788875197494,0.20426864734074662]
[null,"Load group 3",null,7.5233416730735608E-2,null,null,null,null,8.1812322117213107E-2,6.7256105762111051E-2,6.7346505513935881E-2]
[null,"Load group 4",null,8.8199129041122523E-2,null,null,null,null,8.311753119440933E-2,8.4163534026114123E-2,0.10520537666930314]
[null,"Load group 5",null,2.0870205552802956E-2,null,null,null,null,3.4577265727347019E-2,1.259396223441611E-3,7.6383718765994854E-3]
[null,"Total",null,1,null,null,null,null,1.0000000000000002,0.99999999999999989,0.99999999999999989]
[]
[]
[]
[5,"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","$",6156651.4100000001,null,null,null,null,2628167.23,1319841.6099292093,2208642.5700707911]
[null,null,null,null,null,null,null,null,0.42688257869061325,0.21437653718471764,0.35874088412466915]
[]
[]
[6,"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","$",2713779.1426608362,null,null,null,null,1522107.9042045409,425365.82216686459,766305.41628943093]
[null,null,null,null,null,null,null,null,0.56088127448430736,0.15674297715686517,0.28237574835882751]
[]
[]
[7,"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","$",17310832.390000001,null,null,null,null,10483440.09,3595459.89,3231932.41]
[null,null,null,null,null,null,null,null,0.60559999968898082,0.20770000015002166,0.18670000016099747]
[]
[]
[8,"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","$",16746.75,null,null,null,null,10040.340135638535,3362.6501510605322,3343.7597133009317]
[null,null,null,null,null,null,null,null,0.5995396202629486,0.20079419296642825,0.19966618677062306]
[]
[]
[9,"Prior year distribution revenue","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Annual Compliance Statement 2023 - Table 19"]
[null,"Load group Streetlighting","$",508942.55,null,null,null,null,374546.49,87959.56,46436.5]
[null,"Load group 1 (incl residential)","$",53495815.300000004,null,null,null,null,27888818.82,16714194.960000001,8892801.5200000033]
[null,"Load group 2","$",14071206.599999998,null,null,null,null,6516582.4399999995,4452207.21,3102416.95]
[null,"Load group 3","$",7112368.9299999997,null,null,null,null,3293917.41,2263223.5499999998,1555227.9699999997]
[null,"Load group 4","$",5810896.3100000005,null,null,null,null,2486003.83,2358595.4500000002,966297.03000000014]
[null,"Load group 5","$",826529.59000000008,null,null,null,null,657749.26,128212.55,40567.78]
[null,"Total",null,81825759.280000001,null,null,null,null,41217618.249999993,26004393.280000001,14603747.75]
[null,null,null,null,null,null,null,null,0.50372423809667566,0.31780204068764495,0.17847372121567925]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,6.219832904433514E-3,null,null,null,null,9.0870483521934223E-3,3.3824884531203333E-3,3.1797659611040598E-3]
[null,"Load group 1 (incl residential)",null,0.65377719401224732,null,null,null,null,0.67662373528824671,0.6427450461939791,0.60893968262359255]
[null,"Load group 2",null,0.17196548768768111,null,null,null,null,0.15810186800398154,0.17120980912960565,0.21243977937101799]
[null,"Load group 3",null,8.6920903546548786E-2,null,null,null,null,7.9915277734418838E-2,8.7032353557760053E-2,0.10649512691014536]
[null,"Load group 4",null,7.1015489023641853E-2,null,null,null,null,6.0314106820085381E-2,9.0699883846703619E-2,6.6167743139770419E-2]
[null,"Load group 5",null,1.0101092825447473E-2,null,null,null,null,1.5957963801074317E-2,4.9304188188312153E-3,2.7779019943699038E-3]
[null,"Total",null,1,null,null,null,null,1.0000000000000002,0.99999999999999989,1.0000000000000002]
[]
[]
[]
[10,"MWh","Units","Total"]
[]
[null,"Allocation to pricing categories"]
[null,null,null,null,null,null,null,null,"Information Disclosure 2023 - Schedule 8 (excluding Load group 0, Load Group 0A, and Distributed Generation)"]
[null,"Load group Streetlighting","MWh",5890.7499999999991,null,null,null,null,4287.0339999999997,913.60500000000002,690.11099999999999]
[null,"Load group 1 (incl residential)","MWh",675640.18726000004,null,null,null,null,420420.36789999995,142216.26022,113003.55914]
[null,"Load group 2","MWh",275743.15995999996,null,null,null,null,130566.74191,79604.848939999996,65571.569109999997]
[null,"Load group 3","MWh",144055.43849,null,null,null,null,81119.883480000004,39569.399669999999,23366.155339999998]
[null,"Load group 4","MWh",189399.80950999999,null,null,null,null,100820.79651999999,40987.177029999999,47591.835960000004]
[null,"Load group 5","MWh",61848.52562,null,null,null,null,44842.801299999999,8348.49424,8657.2300800000012]
[null,"Total",null,1352577.87084,null,null,null,null,782057.62510999991,311639.78509999998,258880.46062999999]
[null,null,null,null,null,null,null,null,0.57819785608669894,0.23040432038597553,0.19139782352732551]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,4.3552021122019611E-3,null,null,null,null,5.4817367190774582E-3,2.93160579515494E-3,2.6657515917600598E-3]
[null,"Load group 1 (incl residential)",null,0.49952036169304098,null,null,null,null,0.5375823397168028,0.45634821681822552,0.43650864520636112]
[null,"Load group 2",null,0.20386490560336717,null,null,null,null,0.16695284045294642,0.25543865945888822,0.25328898500268404]
[null,"Load group 3",null,0.10650435852579515,null,null,null,null,0.10372622281969328,0.12697159208123199,9.0258474058401941E-2]
[null,"Load group 4",null,0.14002876551009652,null,null,null,null,0.12891734992778708,0.13152100273990339,0.18383711093599966]
[null,"Load group 5",null,4.5726406555498221E-2,null,null,null,null,5.733951036369303E-2,2.6788923106595995E-2,3.3441033204793247E-2]
[null,"Total",null,1,null,null,null,null,1.0000000000000002,1.0000000000000002,1]
[]
[]
[]
[11,"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,"33KV Lines","$",40216185.594129227,null,null,null,null,13364408.326330191,19439074.579053007,7412702.6887460249]
[null,"33KV Cables","$",27906961.34928643,null,null,null,null,22113457.904805176,2897551.0990958703,2895952.3453853838]
[null,"Zone Subs","$",119362258.93128149,null,null,null,null,57103388.334335752,42928833.38157323,19330037.215372514]
[null,"HV lines","$",135643026.14438313,null,null,null,null,54780638.252173483,59307761.223940864,21554626.668268774]
[null,"LV lines","$",89978521.967770979,null,null,null,null,76059844.987428516,9797041.5692712404,4121635.411071226]
[null,"HV cables","$",114388973.8812162,null,null,null,null,40601427.698046766,43588678.989883251,30198867.193286173]
[null,"LV cables","$",61942605.179358013,null,null,null,null,19342974.165557235,23322690.734982252,19276940.278818525]
[null,"Dist Subs","$",118284470.61702219,null,null,null,null,43792577.3149729,46296892.372578397,28195000.929470897]
[null,"Other Network Assets","$",22145116.371548206,null,null,null,null,15640905.707156789,3181939.8984970464,3322270.7658943725]
[null,"Non-Network Assets","$",6263359.6113976426,null,null,null,null,5759911.9983585887,440622.66277958441,62824.9502594695]
[null,"Total",null,736131479.64739347,null,null,null,null,348559534.68916535,251201086.51165473,136370858.44657338]
[null,"Total Check",null,null,null,null,null,null,0.47350173756476921,0.34124486380066221,0.18525339863456855]
[]
[]
[12,"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,"33KV Lines","$",1149981.8717403342,null,null,null,null,369883.09548462764,584400.54794384574,195698.22831186088]
[null,"33KV Cables","$",780820.3179319452,null,null,null,null,592392.29768425238,80949.267591905547,107478.75265578728]
[null,"Zone Subs","$",4164130.1971811503,null,null,null,null,2127394.2543490259,1268472.9988761113,768262.94395601307]
[null,"HV lines","$",3443973.5928069917,null,null,null,null,1319485.9442366124,1574891.7838464375,549595.86472394166]
[null,"LV lines","$",2197281.1259156475,null,null,null,null,1832032.2578159375,260156.17442020256,105092.69367950731]
[null,"HV cables","$",3404687.3945908598,null,null,null,null,1168450.7378063484,1272117.9436932919,964118.71309121919]
[null,"LV cables","$",1852755.2882392304,null,null,null,null,556662.9972522317,680663.28383262793,615429.00715437077]
[null,"Dist Subs","$",4338396.673573642,null,null,null,null,1708791.2312636031,1602973.5853869151,1026631.8569231241]
[null,"Other Network Assets","$",2268026.3058371716,null,null,null,null,1367246.2300807876,593547.64651768794,307232.42923869629]
[null,"Non-Network Assets","$",2135660.0275326525,null,null,null,null,1430362.8381137655,500320.8031141528,204976.38630473433]
[null,"Total",null,25735712.795349628,null,null,null,null,12472701.884087192,8418494.0352231804,4844516.8760392554]
[null,null,null,null,null,null,null,null,0.4846456744085586,0.32711330368686659,0.18824102190457481]
[]
[]
[13,"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 2023 - Schedule 9c"]
[null,"Distribution lines(HV)","km",null,null,"2004 ODV RC ($000/km Medium):",28,null,874,1580,353]
[null,"LV lines","km",null,null,"2004 ODV RC ($000/km Medium):",42,null,809,174,45]
[null,"Total",null,null,null,null,null,null,1683,1754,398]
[]
[null,"Distribution lines(HV)",null,null,null,null,null,null,0.41868263473053891,0.8582292232482347,0.83947681331747914]
[null,"LV lines",null,null,null,null,null,null,0.58131736526946109,0.1417707767517653,0.16052318668252086]
[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,398,583,298]
[null,"LV cables","km",null,null,"2004 ODV RC ($000/km Medium):",63,null,310,510,311]
[null,"Total",null,null,null,null,null,null,708,1093,609]
[]
[null,"Distribution cables(HV)",null,null,null,null,null,null,0.67731808869208909,0.65143904793933538,0.6103764392387695]
[null,"LV cables",null,null,null,null,null,null,0.32268191130791091,0.34856095206066462,0.3896235607612305]
[null,null,null,null,null,null,null,null,1,1,1]

{"sheet":"Asset Mapping","index":7,"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",1719.9,null,null,1154,318.90000000000003,247]
[null,"Load group 1 (incl residential)","kW",203606.73000000097,null,null,111990.03000000052,49532.200000000259,42084.500000000182]
[null,"Load group 2","kW",50863.100000000049,null,null,24297.900000000016,12517.400000000045,14047.799999999992]
[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,256189.73000000103,null,null,137441.93000000055,62368.500000000306,56379.300000000178]
[null,null,null,null,null,null,0.53648493247563045,0.24344652691581375,0.22006854060855582]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,6.7133838659340214E-3,null,null,8.3962732479091022E-3,5.1131580846099948E-3,4.3810405592123215E-3]
[null,"Load group 1 (incl residential)",null,0.79474977392731616,null,null,0.81481706492334671,0.79418616769683437,0.74645304216263864]
[null,"Load group 2",null,0.19853684220674983,null,null,0.17678666182874411,0.20070067421855559,0.24916591727814905]
[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,1]
[]
[]
[]
[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",23628.9,null,null,14046.9,4950.5,4631.5]
[null,"Load group 4","kW",27701.1,null,null,14271.000000000002,6195,7235.1]
[null,"Load group 5","kW",6554.8,null,null,5936.8,92.7,525.29999999999995]
[null,"Total",null,57884.80000000001,null,null,34254.700000000004,11238.2,12391.9]
[null,null,null,null,null,null,0.59177366078832438,0.19414768643927247,0.21407865277240307]
[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.40820560838078385,null,null,0.41007219447258325,0.44050648680393656,0.37375220910433432]
[null,"Load group 4",null,0.47855568301177498,null,null,0.41661436240866218,0.5512448612767169,0.58385719704000194]
[null,"Load group 5",null,0.11323870860744097,null,null,0.17331344311875449,8.2486519193465148E-3,4.239059385566378E-2]
[null,"Total",null,1,null,null,0.99999999999999989,1,1]
[]
[]
[]
[3,"Shared - CPD","Units","Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Allocation to pricing categories"]
[]
[null,"Load group Streetlighting","kW",1719.9,null,null,1154,318.90000000000003,247]
[null,"Load group 1 (incl residential)","kW",203606.73000000097,null,null,111990.03000000052,49532.200000000259,42084.500000000182]
[null,"Load group 2","kW",50863.100000000049,null,null,24297.900000000016,12517.400000000045,14047.799999999992]
[null,"Load group 3","kW",23628.9,null,null,14046.9,4950.5,4631.5]
[null,"Load group 4","kW",27701.1,null,null,14271.000000000002,6195,7235.1]
[null,"Load group 5","kW",6554.8,null,null,5936.8,92.7,525.29999999999995]
[null,"Total",null,314074.53000000102,null,null,171696.63000000053,73606.700000000303,68771.200000000186]
[null,null,null,null,null,null,0.54667479722090162,0.23436061497887162,0.21896458780022679]
[null,"Allocation percentages"]
[]
[null,"Load group Streetlighting",null,5.4760887487437923E-3,null,null,6.721156961554787E-3,4.3324860372764805E-3,3.5916197478013953E-3]
[null,"Load group 1 (incl residential)",null,0.64827520397785932,null,null,0.65225525975670096,0.67293058919908177,0.61194947885161333]
[null,"Load group 2",null,0.16194595594873576,null,null,0.14151646424277484,0.17005788875197494,0.20426864734074662]
[null,"Load group 3",null,7.5233416730735608E-2,null,null,8.1812322117213107E-2,6.7256105762111051E-2,6.7346505513935881E-2]
[null,"Load group 4",null,8.8199129041122523E-2,null,null,8.311753119440933E-2,8.4163534026114123E-2,0.10520537666930314]
[null,"Load group 5",null,2.0870205552802956E-2,null,null,3.4577265727347019E-2,1.259396223441611E-3,7.6383718765994854E-3]
[null,"Total",null,1,null,null,1.0000000000000002,0.99999999999999989,0.99999999999999989]
[]
[4,"Load Group Summary",null,null,null,null,"Dunedin","Central Otago","Queenstown"]
[null,"Load group Streetlighting"]
[null,"LV - CPD",null,null,null,null,8.3962732479091022E-3,5.1131580846099948E-3,4.3810405592123215E-3]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,6.721156961554787E-3,4.3324860372764805E-3,3.5916197478013953E-3]
[null,"Load group 1 (incl residential)"]
[null,"LV - CPD",null,null,null,null,0.81481706492334671,0.79418616769683437,0.74645304216263864]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,0.65225525975670096,0.67293058919908177,0.61194947885161333]
[null,"Load group 2"]
[null,"LV - CPD",null,null,null,null,0.17678666182874411,0.20070067421855559,0.24916591727814905]
[null,"HV - CPD",null,null,null,null,0,0,0]
[null,"Shared - CPD",null,null,null,null,0.14151646424277484,0.17005788875197494,0.20426864734074662]
[null,"Load group 3"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.41007219447258325,0.44050648680393656,0.37375220910433432]
[null,"Shared - CPD",null,null,null,null,8.1812322117213107E-2,6.7256105762111051E-2,6.7346505513935881E-2]
[null,"Load group 4"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.41661436240866218,0.5512448612767169,0.58385719704000194]
[null,"Shared - CPD",null,null,null,null,8.311753119440933E-2,8.4163534026114123E-2,0.10520537666930314]
[null,"Load group 5"]
[null,"LV - CPD",null,null,null,null,0,0,0]
[null,"HV - CPD",null,null,null,null,0.17331344311875449,8.2486519193465148E-3,4.239059385566378E-2]
[null,"Shared - CPD",null,null,null,null,3.4577265727347019E-2,1.259396223441611E-3,7.6383718765994854E-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":8,"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":9,"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.60369663201868518,0.24121132354505706,0.15509204443625785,null,0]
[2,"Total Circuit Length",null,null,null,null,null,0.38231531819635434,0.45522865366165655,0.16245602814198912,null,0]
[3,"Overhead Circuit Length",null,null,null,null,null,0.43885267275097783,0.45736636245110823,0.10378096479791395,null,0]
[4,"CPD",null,null,null,null,null,0.54667479722090162,0.23436061497887162,0.21896458780022679,null,0]
[5,"Transpower connection charge and NIC",null,null,null,null,null,0.42688257869061325,0.21437653718471764,0.35874088412466915,null,0]
[6,"Transpower benefit based charge",null,null,null,null,null,0.56088127448430736,0.15674297715686517,0.28237574835882751,null,0]
[7,"Transpower residual charge",null,null,null,null,null,0.60559999968898082,0.20770000015002166,0.18670000016099747,null,0]
[8,"Transpower transitional price cap",null,null,null,null,null,0.5995396202629486,0.20079419296642825,0.19966618677062306,null,0]
[9,"Prior year distribution revenue",null,null,null,null,null,0.50372423809667566,0.31780204068764495,0.17847372121567925,null,0]
[10,"MWh",null,null,null,null,null,0.57819785608669894,0.23040432038597553,0.19139782352732551,null,0]
[11,"Regulated Asset Base",null,null,null,null,null,0.47350173756476921,0.34124486380066221,0.18525339863456855,null,0]
[12,"Regulated Asset Base (Depreciation)",null,null,null,null,null,0.4846456744085586,0.32711330368686659,0.18824102190457481,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",2693.8767611361395,null,null,1029.9103511155276,1226.3298911024287,437.63651891818319]
[null,"Service interruptions and emergencies","Operational costs","ICP Count",2693.8767611361395,null,null,1626.2843277712914,649.79357902091976,417.7988543439285]
[null,"Vegetation management","Operational costs","Overhead Circuit Length",4368.0887883715322,null,null,1916.9474395904274,1997.8168800009564,453.32446878014855]
[null,"Routine and corrective maintenance and inspection","Operational costs","Total Circuit Length",10615.356327499378,null,null,4058.4133321156078,4832.4143691062882,1724.5286262774812]
[null,"System operations and network support","Operational costs","ICP Count",16739.035926442051,null,null,10105.299612032837,4037.6450106853476,2596.091303723867]
[null,"Business support","Operational costs","ICP Count",16938.596336852188,null,null,10225.773559681704,4085.7812414075715,2627.041535762914]
[null,"Depreciation","Capital related costs","Regulated Asset Base (Depreciation)",25608.322683658349,null,null,12410.96281749359,8376.8230349308087,4820.5368312339515]
[null,"Asset revaluations and other regulatory revenue","Capital related costs","Regulated Asset Base",-16604.885943939116,null,null,-7862.4423465199843,-5666.3320423650339,-3076.1115550540972]
[null,"Tax","Capital related costs","Regulated Asset Base",7543.9844947457641,null,null,3572.0897664237968,2574.3459614238259,1397.5487668981411]
[null,"Return on capital","Capital related costs","Regulated Asset Base",33364.750195459303,null,null,15798.267190964452,11385.549636192627,6180.9333683022214]
[null,"Local Authority rates","Passthrough and recoverable costs","Regulated Asset Base",1641.4639999999999,null,null,777.23605615001634,560.14115911369015,304.0867847362934]
[null,"Commerce Act levies","Passthrough and recoverable costs","Regulated Asset Base",450.29,null,null,213.21309740803994,153.6591497208002,83.417752871159877]
[null,"Electricity Authority levies","Passthrough and recoverable costs","MWh",236.1104,null,null,136.51852707977292,54.400856248060833,45.191016672166235]
[null,"Electricity Authority levies","Passthrough and recoverable costs","ICP Count",59.0276,null,null,35.634763316146142,14.238125521688209,9.1547111621656541]
[null,"Utilities Disputes levies","Passthrough and recoverable costs","ICP Count",67.266999999999996,null,null,40.608861346000893,16.225562100905353,10.432576553093757]
[null,"Opex Incentive Amount","Passthrough and recoverable costs","Prior year distribution revenue",28434.583384023699,null,null,14323.188850713732,9036.5686255457331,5074.8259077642315]
[null,"Capex Incentive Amount","Passthrough and recoverable costs","Regulated Asset Base",-1581.40721004899,null,null,-748.79906175565077,-539.64708800655285,-292.96106028678645]
[null,"Transpower  - Connection charge","Passthrough and recoverable costs","Transpower connection charge and NIC",5381.7443300000004,null,null,2297.3728974439869,1153.7197134788885,1930.6517190771253]
[null,"Transpower - Benefit-based Charge","Passthrough and recoverable costs","Transpower benefit based charge",2713.7791426608401,null,null,1522.107904204543,425.3658221668652,766.30541628943206]
[null,"Transpower - Residual Charge","Passthrough and recoverable costs","Transpower residual charge",17310.83239,null,null,10483.440089999998,3595.4598899999996,3231.9324100000003]
[null,"Transpower - Transitional Price Cap ","Passthrough and recoverable costs","Transpower transitional price cap",16.746749999999999,null,null,10.040340135638534,3.362650151060532,3.3437597133009316]
[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",774.87108000000001,null,null,330.77896478318047,166.1141788949823,277.97793632183726]
[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",-581.66399999999999,null,null,-351.1485977665165,-140.30394329851205,-90.211458934971489]
[null,"Capex Wash-up Adjustment","Passthrough and recoverable costs","Regulated Asset Base",-831.48419799727094,null,null,-393.70921250935641,-283.73971189798158,-154.03527358993296]
[null,"Fire and Emergency Management New Zealand (FENZ) levies","Passthrough and recoverable costs","Regulated Asset Base",48.643999999999998,null,null,23.033018522100633,16.599515154719413,9.0114663231799526]
[null,"Total",null,null,158101.807,null,null,81581.022549740897,47732.332066400086,28788.452383859036]
[null,null,null,null,0,null,null,0.51600310014003126,0.3019088331254815,0.18208806673448732]
[null,"Error check"]
[null,0]

{"sheet":"RAB Allocations","index":10,"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,2756160.065477713,null,null,1792016.4903369599,641266.36970253882,322877.20543821412]
[null,"Load group 1 (incl residential)","$",null,null,328521854.08889884,null,null,173906395.59214193,99602803.629288957,55012654.867467947]
[null,"Load group 2","$",null,null,81265652.421638131,null,null,37731574.939825341,25170861.260942571,18363216.220870212]
[null,"Load group 3","$",null,null,134246327.10718533,null,null,55412870.1498373,55409617.338509992,23423839.618838053]
[null,"Load group 4","$",null,null,162227444.61246091,null,null,56296910.343800284,69338971.702266335,36591562.566394299]
[null,"Load group 5","$",null,null,27114041.351732526,null,null,23419767.173223563,1037566.2109443245,2656707.9675646401]
[null,"Total",null,null,null,736131479.64739347,null,null,348559534.68916541,251201086.5116547,136370858.44657335]
[null,"Error check",0]
[]
[null,"RAB Allocation"]
[]
[null,"Load group Streetlighting ","$",null,null,3.7441138460725955E-3,null,null,5.1412063420816327E-3,2.5528009397076659E-3,2.3676407783610838E-3]
[null,"Load group 1 (incl residential) ","$",null,null,0.44628149070090117,null,null,0.49892881497912905,0.39650626122856275,0.40340477059488861]
[null,"Load group 2 ","$",null,null,0.11039556746107955,null,null,0.10825001523333221,0.10020203977013749,0.13465645395247297]
[null,"Load group 3 ","$",null,null,0.18236732271181941,null,null,0.15897677336312943,0.22057873279118645,0.17176572682509675]
[null,"Load group 4 ","$",null,null,0.22037835508701212,null,null,0.16151304078944254,0.27602974439781847,0.26832391453141691]
[null,"Load group 5 ","$",null,null,3.6833150193115144E-2,null,null,6.7190149292885026E-2,4.1304208725872118E-3,1.9481493317763863E-2]
[null,null,null,null,null,1,null,null,0.99999999999999989,1,1.0000000000000002]
[]
[]
[]
[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,783643.24035604519,null,null,479455.651836548,219501.91146786659,84685.677051630584]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,706770.1159194276,null,null,638619.24170805933,50093.822305179434,18057.05190618879]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,366114.5584267159,null,null,162408.89652126509,119252.60468643313,84453.057219017632]
[null,"Dist Subs","LV - CPD",null,null,727941.21753290715,null,null,367694.44536669797,236723.32952716804,123523.4426390411]
[null,"Other Network Assets","Shared - CPD",null,null,130843.02575069973,null,null,105124.98227867884,13785.710181691395,11932.333290329494]
[null,"Non-Network Assets","Shared - CPD",null,null,40847.907491917453,null,null,38713.272625710772,1908.9915342001327,225.64333200655105]
[null,null,null,null,null,2756160.065477713,null,null,1792016.4903369599,641266.36970253882,322877.20543821412]
[]
[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,95051266.031300947,null,null,46528815.27976153,34093485.66700758,14428965.084531832]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,72832141.84112671,null,null,61974859.651181228,7780674.8986661071,3076607.2912793742]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,48672874.526373081,null,null,15760985.436467469,18522558.375194021,14389330.714711592]
[null,"Dist Subs","LV - CPD",null,null,93497535.060447767,null,null,35682939.31321495,36768351.529650837,21046244.217581976]
[null,"Other Network Assets","Shared - CPD",null,null,14376149.569336312,null,null,10201863.014851617,2141224.6906916839,2033061.8637930115]
[null,"Non-Network Assets","Shared - CPD",null,null,4091887.0603140146,null,null,3756932.8966651196,296508.46807873406,38445.695570160889]
[null,null,null,null,null,328521854.08889878,null,null,173906395.59214193,99602803.629288957,55012654.867467947]
[]
[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,23527349.659624498,null,null,10095117.402737666,8615845.8030977827,4816386.4537890507]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,16439610.010724841,null,null,13446366.094539223,1966272.8482999539,1026971.0678856629]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,12903616.094558215,null,null,3419579.8325685007,4680879.7551017981,4803156.5068879165]
[null,"Dist Subs","LV - CPD",null,null,24058994.339041509,null,null,7741943.5563912448,9291817.513400387,7025233.2692498807]
[null,"Other Network Assets","Shared - CPD",null,null,3433195.4099544976,null,null,2213445.6732314667,541113.98127408116,678635.75544894976]
[null,"Non-Network Assets","Shared - CPD",null,null,902886.90773456416,null,null,815122.380357243,74931.359768569542,12833.167608751524]
[null,null,null,null,null,81265652.421638131,null,null,37731574.939825341,25170861.260942571,18363216.220870212]
[]
[null,"Load group 3","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,16813924.705096699,null,null,5480372.2502058847,8563038.449538352,2770514.0053524654]
[null,"33KV Cables","HV - CPD",null,null,11426872.851946823,null,null,9068114.2104005516,1276390.0549976069,1082368.5865486653]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,56645559.413327098,null,null,22464016.542677518,26125453.536964927,8056089.3336846521]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,47137505.727055117,null,null,16649516.554857962,19201095.846258033,11286893.325939115]
[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,1717367.0287149595,null,null,1279618.8159188679,214004.88634199827,223743.32645409333]
[null,"Non-Network Assets","Shared - CPD",null,null,505097.38104466232,null,null,471231.7757765135,29634.564409086721,4231.04085906211]
[null,null,null,null,null,134246327.10718536,null,null,55412870.1498373,55409617.338509992,23423839.618838053]
[]
[null,"Load group 4","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,20611454.237863038,null,null,5567804.4538430683,10715689.969677828,4327959.8143421402]
[null,"33KV Cables","HV - CPD",null,null,12500866.93846263,null,null,9212784.165661199,1597260.1536633016,1690822.6191381298]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,68100323.196071848,null,null,22822400.677768826,32693098.608523931,12584823.909779081]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,58574999.169572026,null,null,16915137.913303152,24028035.303013537,17631825.953255337]
[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,1917357.5222629572,null,null,1300033.4680234194,267803.30691620626,349520.74732333171]
[null,"Non-Network Assets","Shared - CPD",null,null,522443.54822842689,null,null,478749.66520062258,37084.360471526561,6609.5225562777232]
[null,null,null,null,null,162227444.61246091,null,null,56296910.343800284,69338971.702266335,36591562.566394299]
[]
[null,"Load group 5","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,2790806.6511694817,null,null,2316231.6222812366,160346.15983682562,314228.86905141961]
[null,"33KV Cables","HV - CPD",null,null,3979221.558876974,null,null,3832559.5287434235,23900.890434961755,122761.13969858877]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,10897143.534984181,null,null,9494221.0317271352,489209.07845200464,913713.42480504094]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,8676468.9845890552,null,null,7036773.2298856517,359547.8406116796,1280147.9140917233]
[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,570203.81552878045,null,null,540819.75285273883,4007.3230913853631,25376.739584656207]
[null,"Non-Network Assets","Shared - CPD",null,null,200196.8065840574,null,null,199162.00773337932,554.91851746739508,479.88033321069338]
[null,null,null,null,null,27114041.351732526,null,null,23419767.173223563,1037566.2109443245,2656707.9675646401]

{"sheet":"RAB - Depreciation Allocations","index":11,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[]
[null,"RAB - Depreciation 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 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,"Load group Streetlighting","$",null,null,108160.65903364916,null,null,71068.969298807409,24231.888720621326,12859.801014220437]
[null,"Load group 1 (incl residential)","$",null,null,12851727.00070061,null,null,6896894.2840923369,3763746.4988634866,2191086.2177447868]
[null,"Load group 2","$",null,null,3178913.216134618,null,null,1496383.6300914155,951145.32415022398,731384.26189297868]
[null,"Load group 3","$",null,null,3978064.1337922039,null,null,1643714.9313230941,1620786.4948507354,713562.70761837449]
[null,"Load group 4","$",null,null,4812864.5806509051,null,null,1669938.2628844716,2028233.9835572783,1114692.3342091551]
[null,"Load group 5","$",null,null,805983.20503763808,null,null,694701.80639706599,30349.845080832885,80931.553559739201]
[null,"Total",null,null,null,25735712.79534962,null,null,12472701.88408719,8418494.0352231786,4844516.8760392545]
[null,"Error check",0]
[]
[null,"RAB Allocation"]
[]
[null,"Load group Streetlighting ","$",null,null,4.2027458067216824E-3,null,null,5.6979610319619666E-3,2.8784113428404808E-3,2.6545063921284678E-3]
[null,"Load group 1 (incl residential) ","$",null,null,0.49937326791363962,null,null,0.55295912210420661,0.44708073476275945,0.45228167716409307]
[null,"Load group 2 ","$",null,null,0.12352147544594295,null,null,0.11997269268501624,0.11298283519244766,0.15097155828073791]
[null,"Load group 3 ","$",null,null,0.15457369164109688,null,null,0.1317849930671528,0.19252689234788625,0.14729285207935203]
[null,"Load group 4 ","$",null,null,0.1870111241496516,null,null,0.13388745104338598,0.2409259868892345,0.2300936012262377]
[null,"Load group 5 ","$",null,null,3.1317695042947374E-2,null,null,5.5697780068276477E-2,3.6051394648316448E-3,1.6705804857450851E-2]
[null,null,null,null,null,1,null,null,1,1,1]
[]
[]
[]
[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,27713.877552470287,null,null,17862.183465546259,6485.9029693128732,3365.7911176111561]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,17172.878435591134,null,null,15382.243435606468,1330.2196464978667,460.41535348679793]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,10850.453046214869,null,null,4673.8946319298111,3480.3389726259893,2696.2194416590683]
[null,"Dist Subs","LV - CPD",null,null,27041.45125341729,null,null,14347.478101320246,8196.2573475373756,4497.715804559667]
[null,"Other Network Assets","Shared - CPD",null,null,12864.47546848192,null,null,9189.4765174670229,2571.536890996199,1103.4620600186963]
[null,"Non-Network Assets","Shared - CPD",null,null,12517.523277473671,null,null,9613.6931469375977,2167.6328936510222,736.19723688505132]
[null,null,null,null,null,108160.65903364916,null,null,71068.969298807409,24231.888720621326,12859.801014220437]
[]
[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,3314313.0637645852,null,null,1733437.1422634651,1007403.7098043298,573472.21169679076]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,1777830.3432300587,null,null,1492771.1471584742,206612.43516544989,78446.760906134543]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,1453540.7290769862,null,null,453578.50957249646,540573.36487897742,459388.85462551238]
[null,"Dist Subs","LV - CPD",null,null,3431744.1771039939,null,null,1392352.2556249609,1273059.4486976885,766332.47278134467]
[null,"Other Network Assets","Shared - CPD",null,null,1479220.6374005256,null,null,891793.54495271423,399416.36748887604,188010.72495893537]
[null,"Non-Network Assets","Shared - CPD",null,null,1395078.0501244599,null,null,932961.68452022609,336681.17282816465,125435.19277606915]
[null,null,null,null,null,12851727.000700608,null,null,6896894.2840923369,3763746.4988634866,2191086.2177447868]
[]
[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,822103.25586409424,null,null,376094.92862001446,254583.38610246865,191424.9411416112]
[null,"HV lines","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV lines","LV - CPD",null,null,402277.9042499974,null,null,323878.86722185666,52213.519608254799,26185.517419885975]
[null,"HV cables","HV - CPD",null,null,0,null,null,0,0,0]
[null,"LV cables","LV - CPD",null,null,388364.1061160292,null,null,98410.593047805392,136609.57998102449,153343.93308719934]
[null,"Dist Subs","LV - CPD",null,null,879611.04521623068,null,null,302091.49753732188,321717.87934168923,255801.66833721969]
[null,"Other Network Assets","Shared - CPD",null,null,357183.26461059815,null,null,193487.85223029647,100937.45964050152,62757.952739800145]
[null,"Non-Network Assets","Shared - CPD",null,null,329373.64007766842,null,null,202419.89143412063,85083.49947628536,41870.249167262424]
[null,null,null,null,null,3178913.216134618,null,null,1496383.6300914155,951145.32415022398,731384.26189297868]
[]
[null,"Load group 3","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,482253.65007409465,null,null,151678.77266369329,257432.23226103897,73142.64514936239]
[null,"33KV Cables","HV - CPD",null,null,318752.70821317809,null,null,242923.60950003716,35658.67747626207,40170.421236878836]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,1440247.2120825951,null,null,541084.49672883621,693750.04679857881,205412.66855518008]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,1399866.8632186092,null,null,479149.15818535828,560376.20617657993,360341.49885667104]
[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,172468.32276774413,null,null,111857.58898891465,39919.703289045727,20691.030489783774]
[null,"Non-Network Assets","Shared - CPD",null,null,164475.37743598278,null,null,117021.30525625452,33649.628849229804,13804.443330498441]
[null,null,null,null,null,3978064.1337922039,null,null,1643714.9313230941,1620786.4948507354,713562.70761837449]
[]
[null,"Load group 4","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,590506.22802027047,null,null,154098.60999107047,322147.79898134258,114259.81904785744]
[null,"33KV Cables","HV - CPD",null,null,354174.25044664263,null,null,246799.13939552722,44622.867784151807,62752.243266963626]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,1738753.2993600951,null,null,549716.79536532785,868151.0029122706,320885.50108249666]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,1750949.4879752067,null,null,486793.35913712275,701248.47939883103,562907.64943925303]
[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,195919.70216607186,null,null,113642.13117917841,49955.06754381139,32322.503443082067]
[null,"Non-Network Assets","Shared - CPD",null,null,182561.61268261768,null,null,118888.22781624476,42108.766936870743,21564.617929502165]
[null,null,null,null,null,4812864.5806509042,null,null,1669938.2628844716,2028233.9835572783,1114692.3342091551]
[]
[null,"Load group 5","Allocator",null,null,"Total",null,null,"Dunedin","Central Otago","Queenstown"]
[]
[null,"Asset Categories"]
[null,"33KV Lines","HV - CPD",null,null,77221.993645969065,null,null,64105.712829863849,4820.5167014641584,8295.7641146410569]
[null,"33KV Cables","HV - CPD",null,null,107893.35927212445,null,null,102669.54878868796,667.7223314916663,4556.088151944823]
[null,"Zone Subs","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV lines","HV - CPD",null,null,264973.08136430109,null,null,228684.65214244818,12990.734135587973,23297.695086264943]
[null,"LV lines","LV - CPD",null,null,0,null,null,0,0,0]
[null,"HV cables","HV - CPD",null,null,253871.04339704319,null,null,202508.22048386728,10493.258117880814,40869.564795295104]
[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,50369.903423750067,null,null,47275.636212216836,747.51166445703245,2346.755547076199]
[null,"Non-Network Assets","Shared - CPD",null,null,51653.823934450222,null,null,49458.035939981914,630.10212995123788,1565.6858645170746]
[null,null,null,null,null,805983.20503763808,null,null,694701.80639706599,30349.845080832885,80931.553559739201]

{"sheet":"Load Group Allocations","index":12,"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.5583183270600493E-5,1.0247602823409748E-5,1.904481365610384E-4]
[null,"CPD","%",null,null,null,6.721156961554787E-3,4.3324860372764805E-3,3.5916197478013953E-3]
[null,"Prior year distribution revenue","%",null,null,null,9.0870483521934223E-3,3.3824884531203333E-3,3.1797659611040598E-3]
[null,"MWh","%",null,null,null,5.4817367190774582E-3,2.93160579515494E-3,2.6657515917600598E-3]
[null,"Regulated Asset Base","%",null,null,null,5.1412063420816327E-3,2.5528009397076659E-3,2.3676407783610838E-3]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,5.6979610319619666E-3,2.8784113428404808E-3,2.6545063921284678E-3]
[]
[null,"Load group Streetlighting Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",6.9221891261774635,5.313057130296059,1.5718239637056057]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",5.7868373285191184E-2,6.6588265150083021E-3,7.9569013267137889E-2]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",12.884104628537825,8.6555137376394065,1.6281691142323587]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",27.277233020015576,20.936367780487227,6.1938510697870139]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",0.35957872809929248,4.1376182411425447E-2,0.49442075113652723]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",0.36386557465781483,4.1869463385282815E-2,0.50031516515449548]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",70.717182503207368,24.111942440712262,12.796145832001233]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-40.422438456179741,-14.465017762445116,-7.2831271565338067]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",18.364850561622923,6.5717927894553769,3.3088934502562877]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",81.222151476086623,29.06504181036081,14.634229891125067]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",3.99593094117298,1.4299288773543695,0.719968271702357]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",1.096172528609084,0.39226122180193967,0.19750327333700551]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",0.7483586227275616,0.15948186543820597,0.12046802462708255]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",1.2679983138828995E-3,1.4590665529611447E-4,1.743497681588987E-3]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",1.4449925556851539E-3,1.662731159966479E-4,1.986864764067087E-3]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",130.15550964403343,30.566089031737924,16.136758680037715]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-3.8497304852429277,-1.3776115933736335,-0.69362655280689545]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",12.593593369332075,3.3822513980192066,5.1466378932641428]
[null,"Transpower - Benefit-based Charge",null,"MWh","Passthrough","Capacity",8.3437947888760782,1.2470049093252278,2.0427798832479089]
[null,"Transpower - Residual Charge",null,"MWh","Passthrough","Capacity",57.467458483601682,10.540471049771142,8.6155289664184274]
[null,"Transpower - Transitional Price Cap ",null,"MWh","Passthrough","Capacity",5.5038501193556896E-2,9.85796466992769E-3,8.9136327781951189E-3]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",1.8132431971503897,0.48698128950593456,0.74102012622411428]
["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.2494984909540331E-2,-1.4377790854813533E-3,-1.7180604250617959E-2]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-2.0241403002890683,-0.72433100316554977,-0.36470019505753137]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",0.11841750090310749,4.2375257885659358E-2,2.1335915139588477E-2]
[null,"Total",null,null,null,null,388.25045033353837,126.43223706847395,66.603428771239052]
[]
[null,null,null,null,"Distribution",null,177.74658553551032,80.278602398817753,33.924291094131917]
[null,null,null,null,"Passthrough",null,210.50386479802796,46.153634669656164,32.679137677107143]
[]
[null,"Load group 1 (incl residential)","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,0.93880550373382143,0.89843966827533694,0.8645548506049392]
[null,"CPD","%",null,null,null,0.65225525975670096,0.67293058919908177,0.61194947885161333]
[null,"Prior year distribution revenue","%",null,null,null,0.67662373528824671,0.6427450461939791,0.60893968262359255]
[null,"MWh","%",null,null,null,0.5375823397168028,0.45634821681822552,0.43650864520636112]
[null,"Regulated Asset Base","%",null,null,null,0.49892881497912905,0.39650626122856275,0.40340477059488861]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.55295912210420661,0.44708073476275945,0.45228167716409307]
[]
[null,"Load group 1 (incl residential) Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",671.76444359297352,825.23489617200312,267.81143967841643]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",1526.7646775477463,583.8003275829991,361.21002610022987]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",1250.3390501499971,1344.3920901709148,277.41167242069633]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",2647.1214421391242,3251.8794486568036,1055.3243941151932]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",9486.9108926556783,3627.5804440137131,2244.4633292477697]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",9600.0124977649739,3670.8279431758128,2271.2215024844763]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",6862.7551040292055,3745.1161974344745,2180.2404828617741]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-3922.7990427909385,-2246.7361329977657,-1240.9180761908842]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",1782.2185141608988,1020.7442922730111,563.77783970571409]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",7882.2107283115483,4514.4417182789612,2493.4180075022496]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",387.78546445397944,222.09947676040275,122.67005963748171]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",106.37815802782298,60.926814959354438,33.651119460531362]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",73.389949202236025,24.825733742187182,19.726269463065361]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",33.454111925450079,12.792096770568163,7.9147499411374964]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",38.123822531989276,14.577688631518285,9.0195346632845634]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",9691.4095414088952,5808.2097186614546,3090.262877643936]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-373.59742853923052,-213.97344924835943,-118.18188931822642]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",1235.0270974099089,526.49793395412485,842.74616625968804]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",818.25832844371735,194.11493444126737,334.49893907879658]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",5635.7122518631286,1640.7817094429531,1410.7664376876298]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",5.3975095416690841,1.5345394002200103,1.4595800223486002]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",177.82092981724406,75.805909326948878,121.33977238110531]
["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",-329.66023621161958,-126.05462827483686,-77.992754402377884]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-196.43287084365929,-112.50457232673821,-62.138564206067805]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",11.491836636623999,6.5818116922046617,3.635268504825973]
[null,"Total",null,null,null,null,55101.856773229374,28473.496942694197,16213.33818474279]
[]
[null,null,null,null,"Distribution",null,37787.298307561206,20337.281224760929,10473.960617925633]
[null,null,null,null,"Passthrough",null,17314.558465668153,8136.2157179332698,5739.3775668171593]
[]
[null,"Load group 2","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,5.6185895128364853E-2,9.3393114269677099E-2,0.12778837535881007]
[null,"CPD","%",null,null,null,0.14151646424277484,0.17005788875197494,0.20426864734074662]
[null,"Prior year distribution revenue","%",null,null,null,0.15810186800398154,0.17120980912960565,0.21243977937101799]
[null,"MWh","%",null,null,null,0.16695284045294642,0.25543865945888822,0.25328898500268404]
[null,"Regulated Asset Base","%",null,null,null,0.10825001523333221,0.10020203977013749,0.13465645395247297]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.11997269268501624,0.11298283519244766,0.15097155828073791]
[]
[null,"Load group 2 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",145.74927137690423,208.54707219431839,89.395419746330347]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",91.374240689061111,60.686245977203214,53.389836823382751]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",271.27962379007749,339.74452072602031,92.599976044183464]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",574.33230519673907,821.79018518492239,352.26712979009704]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",567.77530424238307,377.08824186332828,331.75028998600811]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",574.54424083068238,381.58383435968051,335.70536985525615]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1488.9766280283218,946.43721639188675,727.76395716108016]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-851.10950378198447,-567.77802865986553,-414.21827396581205]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",386.67877163020609,257.95471640868305,188.18896117615492]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",1710.1626640821544,1140.8552974506481,832.30256949209172]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",84.135814918134315,56.127286702400895,40.94724812639825]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",23.080321042366268,15.396960231369132,11.232738798314109]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",22.792155870420576,13.896081793420343,11.446386744132358]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",2.0021710746050903,1.3297428838330327,1.169865666292313]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",2.2816452248687153,1.5153557753795956,1.3331620085262659]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",2264.5229130716425,1547.1491895662678,1078.0948961917595]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-81.057509841754054,-54.073738974271492,-39.449097524375318]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",383.5529308078892,294.70461700233989,489.01281431873218]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",254.12023808282973,108.65487539393189,194.0967210940095]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1750.240100743792,918.4194544398016,818.61287972617856]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",1.6762633047585747,0.85895084681613021,0.84693750387485878]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",55.224487732637115,42.43198317404822,70.408749344098894]
["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",-19.729598288581869,-13.103422208964233,-11.527975776048018]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-42.619028251641055,-28.431297895968903,-20.741843725219383]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",2.4933246058870164,1.6633052776981945,1.2134520999915421]
[null,"Total",null,null,null,null,9662.4797761823975,6873.4486459049267,5235.8421707054395]
[]
[null,null,null,null,"Distribution",null,4959.7635460845449,3966.9093018968251,2589.1452361087727]
[null,null,null,null,"Passthrough",null,4702.7162300978553,2906.539344008102,2646.6969345966654]
[]
[null,"Load group 3","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,3.5430614279316937E-3,6.2694590083077406E-3,5.088925998210328E-3]
[null,"CPD","%",null,null,null,8.1812322117213107E-2,6.7256105762111051E-2,6.7346505513935881E-2]
[null,"Prior year distribution revenue","%",null,null,null,7.9915277734418838E-2,8.7032353557760053E-2,0.10649512691014536]
[null,"MWh","%",null,null,null,0.10372622281969328,0.12697159208123199,9.0258474058401941E-2]
[null,"Regulated Asset Base","%",null,null,null,0.15897677336312943,0.22057873279118645,0.17176572682509675]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.1317849930671528,0.19252689234788625,0.14729285207935203]
[]
[null,"Load group 3 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",84.259357397315597,82.478172855223079,29.473290234423128]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",5.7620252725762864,4.0738542075332331,2.1261474518933077]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",156.82992140953897,134.36538337467505,30.529818836304329]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",332.02821881183428,325.00937189495767,116.14097663853666]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",35.803697273086655,25.313849884590056,13.211316529248132]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",36.230543870072019,25.615638009917483,13.36881996972228]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1635.5786488600838,1612.7637066634177,710.03061842601073]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-1249.9457150033791,-1249.8723414789745,-528.37053704894561]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",567.8793052295099,567.84596993697608,240.05097971977693]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",2511.557542748119,2511.4101108825234,1061.6725124639245]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",123.56248034821368,123.55522706148412,52.231687598136169]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",33.895930264688808,33.8939405271853,14.328310952031078]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",14.160551158892856,6.907363328398521,4.0788722059775253]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",0.12625615539891269,8.9265344313364497E-2,4.6587647639251085E-2]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",0.14387969026724209,0.10172549647837774,5.3090610049358306E-2]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",1144.6416150473192,786.47383556745808,540.44422909424543]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-119.04165873525206,-119.0346708269393,-50.320669451610861]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",238.29781306019933,146.48962883591727,174.25767810213182]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",157.88250362713677,54.009375657469079,69.165557536972599]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1087.4076426922452,456.52126649751119,291.70928758649347]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",1.0414465580947521,0.42696104329235102,0.30180264934050166]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",34.310452605167654,21.091781761562487,25.089864354312656]
["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.2441410522188459,-0.87962982121395483,-0.45907943871065982]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-62.590620248076114,-62.586946092993102,-26.457980724877462]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",3.6617149654567549,3.6615000177761035,1.5478610627608866]
[null,"Total",null,null,null,null,6772.2394120062909,5489.7243406285388,2784.2510430057869]
[]
[null,null,null,null,"Distribution",null,4115.9835458687576,4039.0037162308395,1688.2339432208944]
[null,null,null,null,"Passthrough",null,2656.2558661375342,1450.7206243976998,1096.0170997848916]
[]
[null,"Load group 4","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,1.3232069767996179E-3,1.8429825696815597E-3,2.2388921657985109E-3]
[null,"CPD","%",null,null,null,8.311753119440933E-2,8.4163534026114123E-2,0.10520537666930314]
[null,"Prior year distribution revenue","%",null,null,null,6.0314106820085381E-2,9.0699883846703619E-2,6.6167743139770419E-2]
[null,"MWh","%",null,null,null,0.12891734992778708,0.13152100273990339,0.18383711093599966]
[null,"Regulated Asset Base","%",null,null,null,0.16151304078944254,0.27602974439781847,0.26832391453141691]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,0.13388745104338598,0.2409259868892345,0.2300936012262377]
[]
[null,"Load group 4 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",85.603605736289936,103.21225751704009,46.041714817030076]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",2.1519107687668493,1.1975582400265523,0.93540658187021464]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",159.33193860820043,168.14332895790565,47.692171491427281]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",337.32529673192573,406.71307118255987,181.42968370451831]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",13.371402949292323,7.4413093772548109,5.8123684816050085]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",13.530814917343895,7.5300236114460395,5.8816627136468771]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",1661.6721766284568,2018.1943566871776,1109.1746793423363]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-1269.8869714181226,-1564.076185327189,-825.39429398743948]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",576.93908014795693,710.59605772337488,374.9957558826639]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",2551.6261732167532,3142.750355906926,1658.4922368407081]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",125.53375883998304,154.61562097684967,81.593756437714561]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",34.436695698508139,42.414495821818598,22.382977991803958]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",17.599606727169164,7.1548551636542994,8.3077859452716343]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",4.7152167436527663E-2,2.6240617161409532E-2,2.0496411101120864E-2]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",5.3733928652916707E-2,2.9903428135254276E-2,2.3357413913814844E-2]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",863.89034234620397,819.61572470976421,335.78977714399593]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-120.94081340443672,-148.95864776747584,-78.608458501424963]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",296.17122573440054,151.73837359753745,354.92543425875994]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",196.22611731418769,55.944539462669532,140.87537382525773]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",1351.4973145295214,472.87849004390267,594.14911699482286]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",1.294374042660118,0.44225911973096876,0.61470712535742977]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",42.643147551704438,21.84750337758377,51.10266071735785]
["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.46464227445805739,-0.25857772195674761,-0.20197372867476174]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-63.589172099202983,-78.320600150710504,-41.331347585568594]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",3.7201328600640249,4.5819599252849139,2.4179919195036792]
[null,"Total",null,null,null,null,6879.7844022492582,6505.4542744804712,4077.1230422375588]
[]
[null,null,null,null,"Distribution",null,4131.665428286864,5001.7021338765226,2605.0613858683664]
[null,null,null,null,"Passthrough",null,2748.1189739623937,1503.7521406039498,1472.0616563691922]
[]
[null,"Load group 5","Units","Allocator","Distribution / Passthrough"]
[]
[null,"Price category allocators"]
[]
[null,"ICP Count","%",null,null,null,1.0674954981180149E-4,4.45282741731495E-5,1.385077356807552E-4]
[null,"CPD","%",null,null,null,3.4577265727347019E-2,1.259396223441611E-3,7.6383718765994854E-3]
[null,"Prior year distribution revenue","%",null,null,null,1.5957963801074317E-2,4.9304188188312153E-3,2.7779019943699038E-3]
[null,"MWh","%",null,null,null,5.733951036369303E-2,2.6788923106595995E-2,3.3441033204793247E-2]
[null,"Regulated Asset Base","%",null,null,null,6.7190149292885026E-2,4.1304208725872118E-3,1.9481493317763863E-2]
[null,"Regulated Asset Base (Depreciation)",null,null,null,null,5.5697780068276477E-2,3.6051394648316448E-3,1.6705804857450851E-2]
[]
[null,"Load group 5 Allocation"]
[]
["Load group Streetlighting","Service interruptions and emergencies","$","CPD","Distribution","Capacity",35.611483885866868,1.5444352335479608,3.3428304782775493]
["Load group Streetlighting","Service interruptions and emergencies","$","ICP Count","Distribution","Daily Fixed",0.17360511985557359,2.8934186642595599E-2,5.7868373285191191E-2]
["Load group Streetlighting","Vegetation management","$","CPD","Distribution","Distance",66.282801004075708,2.5160430338011066,3.4626608733046882]
[null,"Routine and corrective maintenance and inspection","$","CPD","Distribution","Capacity",140.32883621596923,6.0859244065574343,13.172590959348657]
[null,"System operations and network support","$","ICP Count","Distribution","Daily Fixed",1.0787361842978775,0.17978936404964629,0.35957872809929253]
[null,"Business support","$","ICP Count","Distribution","Daily Fixed",1.0915967239734448,0.18193278732890747,0.36386557465781488]
[null,"Depreciation","$","Regulated Asset Base (Depreciation)","Distribution","Capacity",691.26307744431494,30.199615313139851,80.530947610748882]
[null,"Asset revaluations and other regulatory revenue","$","Regulated Asset Base","Distribution","Capacity",-528.27867506937901,-23.40433613879426,-59.927246704482599]
[null,"Tax","$","Regulated Asset Base","Distribution","Capacity",240.00924469360172,10.633132292325563,27.226336963575264]
[null,"Return on capital","$","Regulated Asset Base","Distribution","Capacity",1061.4879311297889,47.027111863207764,120.41381211212341]
[null,"Local Authority rates","$","Regulated Asset Base","Passthrough","Capacity",52.222606648532768,2.3136187351983803,5.9240646648603983]
[null,"Commerce Act levies","$","Regulated Asset Base","Passthrough","Capacity",14.325819846044642,0.63467695927079659,1.6251023951423784]
[null,"Electricity Authority levies","$","MWh","Passthrough","Capacity",7.8279054983267473,1.4573403549622839,1.5112342890922763]
[null,"Electricity Authority levies","$","ICP Count","Passthrough","Daily Fixed",3.8039949416486989E-3,6.3399915694144985E-4,1.2679983138828997E-3]
[null,"Utilities Disputes levies","$","ICP Count","Passthrough","Daily Fixed",4.3349776670554624E-3,7.2249627784257717E-4,1.4449925556851541E-3]
[null,"Opex Incentive Amount","$","Prior year distribution revenue","Passthrough","Daily Fixed",228.56892919564098,44.554068009050411,14.097369010258316]
[null,"Capex Incentive Amount","$","Regulated Asset Base","Passthrough","Capacity",-50.311920749734412,-2.2289695961331737,-5.7073189383420466]
[null,"Transpower  - Connection charge","$","MWh","Passthrough","Capacity",131.73023706225698,30.906908690949905,64.562988244549317]
[null,"Transpower - Benefit-based Charge","$","MWh","Passthrough","Capacity",87.276921947795472,11.395092302202139,25.626044871147808]
[null,"Transpower - Residual Charge","$","MWh","Passthrough","Capacity",601.11532168770987,96.318498526060083,108.07915903845748]
[null,"Transpower - Transitional Price Cap ","$","MWh","Passthrough","Capacity",0.57570818726244877,9.0081776331144003E-2,0.1118187796013464]
[null,"Transpower - Interconnection costs","$","MWh","Passthrough","Capacity",0,0,0]
[null,"Transpower - New investment contract","$","MWh","Passthrough","Capacity",18.966703879276828,4.4500199653330119,9.2958693987384624]
["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.7484954728620998E-2,-6.2474924547701663E-3,-1.2494984909540333E-2]
["Load group Streetlighting","Capex Wash-up Adjustment","$","Regulated Asset Base","Passthrough","Capacity",-26.453380766487854,-1.1719644284053052,-3.0008371531422071]
["Load group Streetlighting","Fire and Emergency Management New Zealand (FENZ) levies","$","Regulated Asset Base","Passthrough","Capacity",1.5475919531657276,6.85629838698808E-2,0.17555682095828434]
[null,"Total",null,null,null,null,2776.4117357400355,263.77562562347612,411.29451439621999]
[]
[null,null,null,null,"Distribution",null,1709.0486373323652,74.992582341806568,189.00324496893813]
[null,null,null,null,"Passthrough",null,1067.3630984076701,188.78304328166953,222.29126942728183]
[]
[]
[null,"Distribution"]
[]
[null,null,null,"Load group Streetlighting",291.94947902846002,null,177.74658553551032,80.278602398817753,33.924291094131917]
[null,null,null,"Load group 1 (incl residential)",68598.540150247776,null,37787.298307561206,20337.281224760929,10473.960617925633]
[null,null,null,"Load group 2",11515.818084090142,null,4959.7635460845449,3966.9093018968251,2589.1452361087727]
[null,null,null,"Load group 3",9843.2212053204912,null,4115.9835458687576,4039.0037162308395,1688.2339432208944]
[null,null,null,"Load group 4",11738.428948031753,null,4131.665428286864,5001.7021338765226,2605.0613858683664]
[null,null,null,"Load group 5",1973.0444646431099,null,1709.0486373323652,74.992582341806568,189.00324496893813]
[null,null,null,"Total",103961.00233136174,null,52881.506050669246,33500.167561505747,17579.328719186735]
[null,null,null,null,0]
[]
[null,"Passthrough"]
[]
[null,null,null,"Load group Streetlighting",289.33663714479127,null,210.50386479802796,46.153634669656164,32.679137677107143]
[null,null,null,"Load group 1 (incl residential)",31190.151750418583,null,17314.558465668153,8136.2157179332698,5739.3775668171593]
[null,null,null,"Load group 2",10255.952508702623,null,4702.7162300978553,2906.539344008102,2646.6969345966654]
[null,null,null,"Load group 3",5202.9935903201258,null,2656.2558661375342,1450.7206243976998,1096.0170997848916]
[null,null,null,"Load group 4",5723.9327709355357,null,2748.1189739623937,1503.7521406039498,1472.0616563691922]
[null,null,null,"Load group 5",1478.4374111166214,null,1067.3630984076701,188.78304328166953,222.29126942728183]
[null,null,null,"Total",54140.804668638273,null,28699.516499071637,14232.164504894348,11209.123664672297]
[null,null,null,null,0]
[]
[null,"Total"]
[]
[null,null,null,"Load group Streetlighting",581.28611617325123,null,388.25045033353831,126.43223706847391,66.603428771239066]
[null,null,null,"Load group 1 (incl residential)",99788.691900666352,null,55101.85677322936,28473.496942694197,16213.338184742792]
[null,null,null,"Load group 2",21771.770592792767,null,9662.4797761824011,6873.4486459049276,5235.8421707054385]
[null,null,null,"Load group 3",15046.214795640617,null,6772.2394120062918,5489.7243406285397,2784.251043005786]
[null,null,null,"Load group 4",17462.361718967288,null,6879.7844022492573,6505.4542744804721,4077.1230422375584]
[null,null,null,"Load group 5",3451.4818757597313,null,2776.4117357400355,263.77562562347612,411.29451439621994]
[null,null,null,"Total",158101.807,null,81581.022549740897,47732.332066400093,28788.452383859036]
[null,null,null,null,null,null,0,0,0]
[]
[null,"Error check"]
[null,0]

{"sheet":"Outputs >","index":13,"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":14,"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",291.94947902846002,"$000's",null,177.74658553551032,80.278602398817753,33.924291094131917]
[null,null,null,"Load group 1 (incl residential)",68598.540150247776,"$000's",null,37787.298307561206,20337.281224760929,10473.960617925633]
[null,null,null,"Load group 2",11515.818084090142,"$000's",null,4959.7635460845449,3966.9093018968251,2589.1452361087727]
[null,null,null,"Load group 3",9843.2212053204912,"$000's",null,4115.9835458687576,4039.0037162308395,1688.2339432208944]
[null,null,null,"Load group 4",11738.428948031753,"$000's",null,4131.665428286864,5001.7021338765226,2605.0613858683664]
[null,null,null,"Load group 5",1973.0444646431099,"$000's",null,1709.0486373323652,74.992582341806568,189.00324496893813]
[null,null,null,"Total",103961.00233136174,null,null,52881.506050669246,33500.167561505747,17579.328719186735]
[]
[]
[null,"Passthrough",null,null,null,"Units",null,"Dunedin","Central Otago","Queenstown"]
[]
[null,null,null,"Load group Streetlighting",289.33663714479127,"$000's",null,210.50386479802796,46.153634669656164,32.679137677107143]
[null,null,null,"Load group 1 (incl residential)",31190.151750418583,"$000's",null,17314.558465668153,8136.2157179332698,5739.3775668171593]
[null,null,null,"Load group 2",10255.952508702623,"$000's",null,4702.7162300978553,2906.539344008102,2646.6969345966654]
[null,null,null,"Load group 3",5202.9935903201258,"$000's",null,2656.2558661375342,1450.7206243976998,1096.0170997848916]
[null,null,null,"Load group 4",5723.9327709355357,"$000's",null,2748.1189739623937,1503.7521406039498,1472.0616563691922]
[null,null,null,"Load group 5",1478.4374111166214,"$000's",null,1067.3630984076701,188.78304328166953,222.29126942728183]
[null,null,null,"Total",54140.804668638273,null,null,28699.516499071637,14232.164504894348,11209.123664672297]
[]
[]
[null,"Total",null,null,null,"Units",null,"Dunedin","Central Otago","Queenstown"]
[]
[null,null,null,"Load group Streetlighting",581.28611617325123,"$000's",null,388.25045033353831,126.43223706847391,66.603428771239066]
[null,null,null,"Load group 1 (incl residential)",99788.691900666352,"$000's",null,55101.85677322936,28473.496942694197,16213.338184742792]
[null,null,null,"Load group 2",21771.770592792767,"$000's",null,9662.4797761824011,6873.4486459049276,5235.8421707054385]
[null,null,null,"Load group 3",15046.214795640617,"$000's",null,6772.2394120062918,5489.7243406285397,2784.251043005786]
[null,null,null,"Load group 4",17462.361718967288,"$000's",null,6879.7844022492573,6505.4542744804721,4077.1230422375584]
[null,null,null,"Load group 5",3451.4818757597313,"$000's",null,2776.4117357400355,263.77562562347612,411.29451439621994]
[null,null,null,"Total",158101.807,null,null,81581.022549740897,47732.332066400093,28788.452383859036]
[]
[]
[null,null,"Error check"]
[null,null,0]

{"sheet":"Pricing Methodology Tables","index":15,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,6,11,6],[10,7,10,10],[10,29,11,29],[10,23,10,28]]}
[]
[null,"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,"RY25","RY24",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,"Capital related costs",null,null,null,null,"Dunedin","Central","Queenstown","Total",null,null,null,"Capital related costs",23.918877428361856,16.670386590182229,9.3229074113802159,49.9121714299243,null,null,null,"Cost Allocators "," SL ","L1 ","L2 ","L3 ","L4 ","L5 "]
[null,null,"Asset revaluations and other regulatory revenue",-14.969489381004101,-13.6178750844246,null,"ICP Count",0.60369663201868518,0.24121132354505706,0.15509204443625785,1,null,0,null,"Operational costs",28.962628622307395,16.829780971323512,8.2564213078065229,54.048830901437427,null,null,null,"Dunedin"]
[null,null,"Depreciation",23.086187750556199,21.466138091127998,null,"Total Circuit Length",0.38231531819635434,0.45522865366165655,0.16245602814198912,1,null,0,null,"Passthrough and recoverable costs",28.699516499071628,14.232164504894344,11.209123664672298,54.140804668638268,null,null,null,"ICP Count",3.5583183270600493E-5,0.93880550373382143,5.6185895128364853E-2,3.5430614279316937E-3,1.3232069767996179E-3,1.0674954981180149E-4,1,null,0]
[null,null,"Return on capital",30.078693430175953,32.295837105477212,null,"Overhead Circuit Length",0.43885267275097783,0.45736636245110823,0.10378096479791395,1,null,0,null,"Total forecast allowable revenue",81.581022549740879,47.732332066400083,28.788452383859038,158.10180700000001,null,null,null,"CPD",6.721156961554787E-3,0.65225525975670096,0.14151646424277484,8.1812322117213107E-2,8.311753119440933E-2,3.4577265727347019E-2,1.0000000000000002,null,0]
[null,null,"Tax",6.8009859366589795,6.2479560000000003,null,"Prior year distribution revenue",0.50372423809667566,0.31780204068764495,0.17847372121567925,0.99999999999999989,null,0,null,"% of forecast allowable revenue",0.51600310014003115,0.3019088331254815,0.18208806673448732,1,null,null,null,"Prior year distribution revenue",9.0870483521934223E-3,0.67662373528824671,0.15810186800398154,7.9915277734418838E-2,6.0314106820085381E-2,1.5957963801074317E-2,1.0000000000000002,null,0]
[null,null,"Operational costs",null,null,null,"Transmission Costs",0.55896461185735435,0.2039860913437318,0.23704929679891382,1,null,0,null,null,null,null,null,null,null,null,null,"MWh",5.4817367190774582E-3,0.5375823397168028,0.16695284045294642,0.10372622281969328,0.12891734992778708,5.733951036369303E-2,1.0000000000000002,null,0]
[null,null,"Business support",15.270333012204491,15.675299000000001,null,"MWh",0.57819785608669894,0.23040432038597553,0.19139782352732551,1,null,0,null,null,null,null,null,null,null,null,null,"Regulated Asset Base",5.1412063420816327E-3,0.49892881497912905,0.10825001523333221,0.15897677336312943,0.16151304078944254,6.7190149292885026E-2,0.99999999999999989,null,0]
[null,null,"Routine and corrective maintenance and inspection",9.5698618079384303,10.394228282564701,null,"Regulated Asset Base",0.47350173756476921,0.34124486380066221,0.18525339863456855,1,null,0,null,null,null,null,null,null,null,null,null,"Regulated Asset Base (Depreciation)",5.6979610319619666E-3,0.55295912210420661,0.11997269268501624,0.1317849930671528,0.13388745104338598,5.5697780068276477E-2,1,null,0]
[null,null,"Service interruptions and emergencies",4.8571197303863904,4.8220220463448902,null,"Regulated Asset Base (Depreciation)",0.4846456744085586,0.32711330368686659,0.18824102190457481,1,null,0,null,null,null,null,null,null,null,null,null,"Central Otago & Wanaka"]
[null,null,"System operations and network support",15.090427082432431,15.3853000464578,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICP Count",1.0247602823409748E-5,0.89843966827533694,9.3393114269677099E-2,6.2694590083077406E-3,1.8429825696815597E-3,4.45282741731495E-5,0.99999999999999989]
[null,null,"Vegetation management",3.9378806306512302,3.92709451245201,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPD",4.3324860372764805E-3,0.67293058919908177,0.17005788875197494,6.7256105762111051E-2,8.4163534026114123E-2,1.259396223441611E-3,0.99999999999999989]
[null,null,"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",3.3824884531203333E-3,0.6427450461939791,0.17120980912960565,8.7032353557760053E-2,9.0699883846703619E-2,4.9304188188312153E-3,0.99999999999999989]
[null,null,"Capex Incentive Amount",-1.58140721004899,-1.53654,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWh",2.93160579515494E-3,0.45634821681822552,0.25543865945888822,0.12697159208123199,0.13152100273990339,2.6788923106595995E-2,1.0000000000000002]
[null,null,"Capex Wash-up Adjustment",-0.83148419799727091,-0.807894,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base",2.5528009397076659E-3,0.39650626122856275,0.10020203977013749,0.22057873279118645,0.27602974439781847,4.1304208725872118E-3,1]
[null,null,"Commerce Act levies",0.45029000000000002,0.32504500000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base (Depreciation)",2.8784113428404808E-3,0.44708073476275945,0.11298283519244766,0.19252689234788625,0.2409259868892345,3.6051394648316448E-3,1]
[null,null,"Electricity Authority levies",0.29513799999999996,0.27757999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown"]
[null,null,"Fire and Emergency Management New Zealand (FENZ) levies",4.8644E-2,2.9083999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICP Count",1.904481365610384E-4,0.8645548506049392,0.12778837535881007,5.088925998210328E-3,2.2388921657985109E-3,1.385077356807552E-4,0.99999999999999989]
[null,null,"Local Authority rates",1.641464,1.1890889999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPD",3.5916197478013953E-3,0.61194947885161333,0.20426864734074662,6.7346505513935881E-2,0.10520537666930314,7.6383718765994854E-3,0.99999999999999989]
[null,null,"Opex Incentive Amount",28.4345833840237,20.937446999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior year distribution revenue",3.1797659611040598E-3,0.60893968262359255,0.21243977937101799,0.10649512691014536,6.6167743139770419E-2,2.7779019943699038E-3,1.0000000000000002]
[null,null,"Quality Incentive Adjustments",-0.58166399999999996,-0.5668200000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWh",2.6657515917600598E-3,0.43650864520636112,0.25328898500268404,9.0258474058401941E-2,0.18383711093599966,3.3441033204793247E-2,1]
[null,null,"Transmission Costs",26.197973692660838,24.889416999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base",2.3676407783610838E-3,0.40340477059488861,0.13465645395247297,0.17176572682509675,0.26832391453141691,1.9481493317763863E-2,1.0000000000000002]
[null,null,"Avoided Cost Of Transmission (ACOT)",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Asset Base (Depreciation)",2.6545063921284678E-3,0.45228167716409307,0.15097155828073791,0.14729285207935203,0.2300936012262377,1.6705804857450851E-2,1]
[null,null,"Utilities Disputes levies",6.7266999999999993E-2,6.7387000000000002E-2]
[null,null,"Opening Wash-up Account Balance",25.479254278368497,14.575718]
[null,null,"Target Revenue (before revenue limit applied)",173.34205894700673,155.97551300000001]
[null,null,"Revenue deferred to future periods",-15.240251947006726,-14.946016999999983]
[null,null,"Target Revenue",158.10180700000001,141.02949600000002]
[]
[null,null,null,0]
[null,null,null,0]
[]
[]
[]
[null,null,"Error check"]
[null,null,0]