{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Concepts","Definitions","Validations","Checks and Totals","Distribution Business","Standard Control","ACS","Negotiated Services","Provisions"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":5,"defined_names":4415,"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":"Concepts","index":0,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,1,2,2],[22,1,22,2],[15,1,15,2],[7,1,7,2],[5,1,5,2],[3,1,3,2],[4,1,4,2]]}
[null,"AER Network information requirements review 2022-23"]
[null,"Project Overview"]
[null,"The network information requirements review project is being undertaken to  streamline regulated electricity networks' annual reporting obligations, and facilitate improvements in the AER’s information management maturity. The project will allow for consolidation of existing information requests, ongoing integration of new information requirements, and clearer documentation of our underlying data structure.  In sum, this project will help drive improve data quality and deliver efficiencies to both the AER and the regulated businesses."]
[null,"Data category 09: Revenue and financial statements"]
[null,"This data is collected to reveal the financial performance of regulated Network Service Providers. It shows the originating statutory account amount, its translation into a regulatory accounting environment and its disaggregation between the difference categories of services provided."]
[null,"Income Statements show incomes and expenditures and this data is the foundation of the expenditure information used to report on NSP performance, and is a key component for the AER when making and monitoring regulatory decisions. "]
[]
[null,"Concepts "]
[]
[null,"Service classifications"]
[]
[null,"Where:"]
[]
[]
[null,"Where:"]
[null,"Standard Control Services = Standard control services excluding those provided using dual function assets + Standard control services provided using dual function assets"]
[null,"Alternative Control Services = Ancillary Network Services + Metering Services +  Connection services + Public Lighting"]
[null,"Where:"]
[null,"Ancillary Network Services = Fee based services + Quoted services"]
[null,"Metering Services = Smart meters + Legacy meters"]
[null,"Public Lighting Total = Energy efficient + Non-energy efficient"]
[]
[null,"Definitions of Concepts"]
[]
[null,"Audited Statutory Accounts","The audited set of accounts prepared in accordance with Australian Securities and Investments Commission (ASIC) requirements."]
[null,"Adjustments","The adjustments made to audited statutory accounts to arrive at the accounts for the distribution business. The adjustments should include non-distribution services and any other adjustments. "]
[null,"Distribution Business","Audited Statutory Accounts plus Adjustments."]
[null,"Direct Control Services","As defined in Chapter 6 of the National Electricity Rules."]
[null,"Standard Control Services","As defined in the National Electricity Rules. For clarity, Standard Control Services are intended to capture services only available through DNSP’s network typically provided to all customers or a broad class of customers recovered through general network tariffs."]
[null,"Alternative Control Services","A distribution service that is a direct control service but not a standard control service (as defined in the NER). \nBy way of context, Alternative Control Services are intended to capture distribution services provided at the request of, or for the benefit of, specific customers with regulatory oversight of prices. "]
[null,"Ancillary network services","Fee based and quoted services as defined in the framework and approach for the regulatory control period covering reporting period."]
[null,"Metering Services","Metering Services include: Meter purchase; Meter testing; Meter investigation; Scheduled meter reading; Special meter reading; New meter installation; Meter replacement; Meter maintenance; Other (all activities not captured by the defined meter service categories including those activities relating to type 7 meters).\n"]
[null,"Smart meters","Also known as Advanced meters. These meters record customer usages and demand in real time and can be remotely read in 30 minute intervals."]
[null,"Legacy meters","Meters that are not smart meters."]
[null,"Connection services","As defined in the National Electricity Rules."]
[null,"Public Lighting","Public lighting services are defined as the: operation, maintenance, repair and replacement of public lighting assets; alteration and relocation of public lighting assets; and provision of new public lights."]
[null,"Energy Efficient Public Lighting","Public lighting services provided using energy efficient lamps (such as fluorescent lamps; CFL lamps and LED lamps)."]
[null,"Non-energy efficient Public Lighting","Public lighting that does not use energy efficient lamps"]
[null,"Other Distribution Services","Distribution services that are not Direct control services."]
[null,"Negotiated Services","Negotiated distribution service, as defined in section 2C of NEL"]
[null,"Unregulated services","Unclassified or unregulated services must align with those unclassified or unregulated services set out in the DNSP's Revenue Determination."]

{"sheet":"Definitions","index":1,"n_rows":90,"n_cols":3,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[null,"Data category 09: Revenue and financial statements"]
[null,"Definitions have been provided for each service classification (column) as well as each row descriptor of the data tabs in this workbook. Row descriptor definitions have been consolidated for all service classifications. This means if you are seeking to find a disaggregated definition of a data cell, you will need to consider (together) the definition of both the row descriptor and the service classification. These are provided below:"]
[null,"Compounding Definitions"]
[null,"Where you are seeking to discern the meaning of a row or column descriptor with multiple terms, you may need to look up the terms individually in the 'Definitions' below and consider the definitions together to discern the full meaning of the row or column descriptor."]
[]
[null,"Term","Definition"]
[]
[null,"Income statement"]
[null,"Income statement","An income statement or profit and loss account is one of the financial statements of a company and shows the company's revenues and expenses during a particular period. It indicates how the revenues are transformed into the net income or net profit."]
[]
[null,"Total revenue"]
[null,"Total revenue","Total revenue earned from the provision of standard control services, alternative control services, negotiated services, and, unclassified or unregulated services, but excludes capital contributions."]
[null,"Distribution revenue (excluding DFA revenues)","Revenue earned from the provision of standard control services, alternative control services, negotiated services, and, unclassified or unregulated services, but excludes capital contributions. Excludes revenue from Dual Function Assets."]
[null,"Dual function asset revenue (Tx)","Revenue earned from the provision of standard control services, delivered using Dual Function Assets."]
[null,"TUOS revenue","Payments from customers in respect of TUOS charges."]
[null,"Cross boundary revenue","Inter-DNSP revenue which is revenue from another DNSP for using the DNSP’s distribution network. "]
[null,"Other TUOS Revenue","TUOS Revenue that is not cross boundary revenue"]
[null,"Jurisdictional scheme revenue","The amounts a DNSP recovers from any person in respect of a jurisdictional scheme."]
[null,"Other Revenue","Any revenues not reported under Distribution revenue, dual function asset revenue, Tuos revenue, or jurisdictional scheme revenue."]
[]
[null,"Expenditure"]
[null,"TUOS expenditure","Payment to TNSPs in respect of TUOS charges"]
[null,"Cross boundary expenditure","Inter-DNSP payments to another DNSP for using the DNSP’s distribution network. "]
[null,"Other TUOS expenditure","TUOS payments that are not cross boundary expenditure"]
[null,"Jurisdictional scheme payments","In respect of a jurisdictional scheme, the amounts a DNSP is required under the jurisdictional scheme obligations to:\n(a)  pay to a person;\n(b)  pay into a fund established under an Act of a participating jurisdiction;\n(c)   credit against charges payable by a person; and\n(d)  reimburse a person."]
[null,"Maintenance expenditure","Those expenditures which are directly and specifically attributable to maintenance that are not capital expenditure."]
[null,"Operating expenditure excluding maintenance expenditure","Operating expenditure excluding any maintenance expenditure."]
[null,"Other expenditure","Any expenditure not reported under TUOS expenditure; Jurisdictional scheme payments; maintenance expenditure or operating expenditure."]
[]
[null,"TUOS Charges "]
[null,"Locational and non-locational","As defined in the NER"]
[null,"TUoS Common Service Charge","As defined in the NER"]
[null,"Grid equalisation","As defined in the NER"]
[null,"Other","TUOS charges not included in location, non-locational, common service or grid equalisation charges."]
[]
[null,"Transmission connection fees"]
[null,"TNSP connection/augmentation fees","TBC"]
[null,"Other","Payments for TNSP connection services not included in in TNSP specific payments"]
[]
[null,"Payments to embedded generators"]
[null,"Avoided transmission costs","As defined in the NER"]
[null,"Avoided TuOS ","As defined in the NER"]
[]
[null,"Cross boundary network charges","Inter-DNSP payments which are the cost of using another DNSP's distribution network"]
[]
[null,"Profitability - tax data"]
[null,"Ownership Structure","As defined in the information request for financial performance data "]
[null,"Proportion of holding interest in flow-through vehicle attributable to a NTER or government owned non-NTER entity","As defined in the information request for financial performance data "]
[null,"Tax rate applicable to holding interest attributable to a NTER or government-owned non-NTER entity","As defined in the information request for financial performance data "]
[null,"Proportion of holding interest in flow-through vehicle not attributable to a NTER or government owned non-NTER entity","As defined in the information request for financial performance data "]
[null,"Tax rate applicable to holding interest not attributable to a NTER or government owned non-NTER entity","As defined in the information request for financial performance data "]
[null,"Flow-though blended tax rate","As defined in the information request for financial performance data "]
[]
[null,"Tax Related Information"]
[null,"Tax asset base depreciation","As defined in the information request for financial performance data "]
[null,"Tax rate","As defined in the information request for financial performance data "]
[null,"Tax loss carried forward","As defined in the information request for financial performance data "]
[null,"Adjustment to tax expense for value of gifted assets","As defined in the information request for financial performance data "]
[null,"Permanent differences due to disallowed interest expense","As defined in the information request for financial performance data "]
[null,"Permanent differences due to adjustments to prior year returns","As defined in the information request for financial performance data "]
[]
[null,"Interest Expense (Debt and Equity)"]
[null,"Interest bearing liabilities","As defined in the information request for financial performance data "]
[null,"Related party interest expense","As defined in the information request for financial performance data "]
[null,"Interest expense","As defined in the information request for financial performance data "]
[]
[null,"Revenue grouping by charging by chargeable quantity"]
[null,"Revenue from Energy Delivery charges where time of use is not a determinant","Revenue from supply availability charges independent of usage."]
[null,"Revenue from On–Peak Energy Delivery charges ","Revenue from metered supply charges which are not time dependent."]
[null,"Revenue from Shoulder period Energy Delivery Charges","Time of use charges for supplies at On-peak Charging Periods."]
[null,"Revenue from Off–Peak Energy Delivery charges ","Time of use charges for supplies at Off-peak Charging Periods."]
[null,"Revenue from controlled load customer charges","Charges for controlled load energy deliveries. Controlled load energy deliveries are energy deliveries where the supply of electricity is controlled by DNSP."]
[null,"Revenue from unmetered supplies","Revenue from customers for which energy delivered is for uses which are “calculated” rather than “metered”. This may include supplies for the purposes of traffic controls, the energy component of street lighting, phone of public transport cubicles and other services where consumption is calculated rather than metered"]
[null,"Revenue from Contracted Maximum Demand charges","Charges for contracted Maximum Demand that come into effect when a set level of demand is reached."]
[null,"Revenue from Measured Maximum Demand charges","Charges calculated based on measured Maximum Demands, whether reset on a monthly basis or ratcheted. These do not include Contracted Maximum Demand Charges."]
[null,"Revenue from metering charges","Charges for metering services"]
[null,"Revenue from connection charges","Charges for connection services"]
[null,"Revenue from public lighting charges","Charges for public lighting services"]
[null,"Revenue from other Sources","Revenue from sources excluding those listed in the table "]
[]
[null,"Revenue grouping by customer type or class","Customer types are defined in data category 4"]
[]
[null,"Revenue rewards and penalties - incentive schemes"]
[null,"EBSS","Efficiency benefit sharing scheme"]
[null,"CESS","Capital expenditure sharing scheme"]
[null,"STPIS","Service target performance  incentive scheme"]
[null,"CSIS","Customer service incentive scheme"]
[null,"F-Factor ","An incentive scheme that provides incentives for DNSPs to reduce the risk of fire starts and reduce the risk of loss or damage caused by fire starts as set out by the Victorian Order in Council."]
[null,"S-Factor True up","TBC"]
[null,"Other","Any other incentive scheme rewards or penalties"]

{"sheet":"Validations","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,12,3,13],[1,1,1,5],[2,1,2,5]]}
[null,"Data category 09: Revenue and financial statements"]
[null,"Data validation is a process to improve data quality by checking the accuracy and quality of source data before using, importing or otherwise processing the data. \nData validation rules provide the first level of data cleansing in the data quality process. They decrease the likelihood of errors at the point of data entry.  Data validation rules cannot, however, guarantee data entry is correct, only that it has passed a pre-specified set of rules."]
[null,"Validation Rules"]
[]
[null,"Worksheet","Tables","input cells",null,"Rules applying"]
[]
[null,"Standard control ","Jurisdictional Scheme Payments","Jurisdictional scheme name",null,"Free text - consistent with previous year reporting, where applicable"]
[null,null,null,"Description",null,"Free text - consistent with previous year reporting, where applicable"]
[null,null,null,"Date DNSP became subject to Scheme",null,"DD/MM/YYYY"]
[null,null,null,"Description of Cost Recovery Method",null,"Free text - consistent with previous year reporting, where applicable"]
[]
[null,"Standard Control","Cross boundary expenditures","HV crossings",null,"Crossing name/ID - Free text - consistent with previous year reporting, where applicable"]
[null,"Standard Control","Cross boundary expenditures","Subtransmission crossings",null,"Crossing name/ID - Free text - consistent with previous year reporting, where applicable"]
[null,"Standard Control","Cross boundary expenditures","TUOS Adjustment",null,"Crossing name/ID - Free text - consistent with previous year reporting, where applicable"]
[]
[null,"Standard Control","Payments to embedded generators","Avoided transmission costs",null,"Embedded generator name/id  - Free text - consistent with previous year reporting, where applicable"]
[null,"Standard Control","Payments to embedded generators","Avoided TUOS",null,"Embedded generator name/id  - Free text - consistent with previous year reporting, where applicable"]
[]
[null,"ACS","Public lighting revenue by tariff","Business defined tariff categories",null,"Free text - consistent with previous year reporting, where applicable. Must match tariff categories in data category 03 - Network Metrics"]
[]
[null,"Provisions","Total Provisions","Business specific provision",null,"Free text - consistent with previous year reporting, where applicable"]

{"sheet":"Checks and Totals","index":3,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,5,19,5],[17,11,19,11],[1,1,1,11],[9,7,11,7],[9,5,11,5],[9,1,11,1],[9,2,11,2],[9,11,11,11],[5,1,7,1],[5,2,7,2],[5,7,7,7],[5,11,7,11],[5,5,7,5]]}
[null,"Data category 09: Revenue and financial statements"]
[null,"Totals and Data Hierarchies"]
[]
[null,"Worksheet","Table","Sub table","Reference",null,"Worksheet","Table","Sub table","Reference",null,"Check"]
[]
[null,"Distribution business","Total revenue",null,null,"=","Standard control","Total Revenue",null,null,null,{"$f":"'Distribution Business'!L5='Standard Control'!K5+ACS!H7+'Negotiated Services'!K5","v":true}]
[null,null,null,null,null,null,"ACS "]
[null,null,null,null,null,null,"Negotiated"]
[]
[null,"Distribution business","Total expenditure",null,null,"=","Standard control","Total expenditure",null,null,null,{"$f":"'Distribution Business'!L14='Standard Control'!K14+ACS!H11+'Negotiated Services'!K14","v":true}]
[null,null,null,null,null,null,"ACS "]
[null,null,null,null,null,null,"Negotiated"]
[]
[null,"Standard Control","Disaggregated Revenue ","Revenue Grouping By Chargeable Quantity","Total","=","Standard Control","Income statement","Total revenue","Total",null,{"$f":"AND('Standard Control'!K5='Standard Control'!K60)","v":true}]
[]
[null,"Standard Control","Disaggregated Revenue ","Revenue Grouping By Customer Type Or Class","Total","=","Standard Control","Income statement","Total revenue","Total",null,{"$f":"'Standard Control'!K5='Standard Control'!K75","v":true}]
[]
[null,"Standard Control","Net Jurisdictional Scheme Payments",null,"Total","=",null,null,null,null,null,{"$f":"AND(SUM('Standard Control'!K93:K97)='Standard Control'!K11-'Standard Control'!K24)","v":true}]
[null,null,null,null,null,"less","Standard control","Income statement","Total revenue","Jurisdictional scheme revenue"]
[null,null,null,null,null,null,"Standard control","Income statement","Total expenditure","Jurisdictional scheme payments"]
[]
[null,"ACS","Disaggregated Revenue ","Revenue Grouping By Chargeable Quantity","Total","=","ACS","Income statement","Total revenue","Total",null,{"$f":"AND(ACS!H7=SUM(ACS!H26:H38))","v":true}]
[]
[null,"ACS","Disaggregated Revenue ","Revenue Grouping By Customer Type Or Class","Total","=","ACS","Income statement","Total revenue","Total",null,{"$f":"AND(ACS!H7=SUM(ACS!H41:H46))","v":true}]

{"sheet":"Distribution Business","index":4,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[64,1,68,1],[5,1,11,1],[14,1,20,1],[2,16,2,18],[53,1,55,1],[58,1,60,1],[23,1,26,1],[29,1,32,1],[48,1,50,1],[36,1,38,1]]}
[null,null,null,null,"Data category 09: Revenue and financial statements"]
[null,null,null,null,null,null,null,null,null,"SERVICE CLASSIFICATIONS"]
[null,"Stakeholder Comments",null,null,null,null,null,"Units",null,"Audited Statutory Accounts","Adjustments","Distribution Business",null,null,"Current RIN reference",null,"Validation rules"]
[null,null,null,null,"Income statement",null,null,null,null,null,null,null,null,null,null,null,"A","B","C"]
[null,null,null,null,"TOTAL REVENUE",null,null,null,null,{"$f":"J6+J7+J8+J11+J12","v":0},{"$f":"K6+K7+K8+K11+K12","v":0},{"$f":"J5+K5","v":0},null,null,"AR8.1.1"]
[null,null,null,null,"Distribution revenue (excluding DFA revenues)",null,null,"$",null,null,null,{"$f":"SUM(J6+K6)","v":0},null,null,"AR8.1.1"]
[null,null,null,null,"Dual function asset revenue (Tx)",null,null,"$",null,null,null,{"$f":"SUM(J7+K7)","v":0},null,null,"AR8.1.1"]
[null,null,null,null,"TUOS revenue",null,null,"$",null,{"$f":"SUM(J9:J10)","v":0},{"$f":"SUM(K9:K10)","v":0},0,null,null,"AR8.1.1"]
[null,null,null,null,"Cross boundary revenue",null,null,"$",null,null,null,0,null,null,"AR8.1.1"]
[null,null,null,null,"Other TUOS revenue",null,null,"$",null,null,null,0,null,null,"AR8.1.1"]
[null,null,null,null,"Jurisdictional scheme revenue",null,null,"$",null,null,null,0,null,null,"AR8.1.1"]
[null,null,null,null,"Other revenue",null,null,"$",null,null,null,0,null,null,"AR8.1.1"]
[]
[null,null,null,null,"EXPENDITURE",null,null,null,null,{"$f":"J15+J18+J19+J20+J21","v":0},{"$f":"K15+K18+K19+K20+K21","v":0},{"$f":"J14+K14","v":0},null,null,"AR8.1.1.2"]
[null,null,null,null,"TUOS expenditure",null,null,"$",null,{"$f":"SUM(J16:J17)","v":0},{"$f":"SUM(K16:K17)","v":0},{"$f":"J15+K15","v":0},null,null,"AR8.1.1.2"]
[null,null,null,null,"Cross boundary expenditure",null,null,"$",null,null,null,{"$f":"J16+K16","v":0},null,null,"AR8.1.1.2"]
[null,null,null,null,"Other TUOS expenditure",null,null,"$",null,null,null,{"$f":"J17+K17","v":0},null,null,"AR8.1.1.2"]
[null,null,null,null,"Jurisdictional scheme payments",null,null,"$",null,null,null,0,null,null,"AR8.1.1.2"]
[null,null,null,null,"Maintenance expenditure",null,null,"$",null,null,null,0,null,null,"AR8.1.1.2"]
[null,null,null,null,"Operating expenditure excluding maintenance expenditure",null,null,"$",null,null,null,0,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other expenditure",null,null,"$",null,null,null,0,null,null,"AR8.1.1.2"]
[]
[null,null,null,null,"TUOS CHARGES",null,null,null,null,null,null,{"$f":"SUM(L24:L27)","v":0},null,null,"AR9.5.1"]
[null,null,null,null,"Locational & Non-Locational",null,null,"$",null,null,null,null,null,null,"AR9.5.1"]
[null,null,null,null,"TUoS Common Service Charge",null,null,"$",null,null,null,null,null,null,"AR9.5.1"]
[null,null,null,null,"Grid equalisation",null,null,"$",null,null,null,null,null,null,"AR9.5.1"]
[null,null,null,null,"Other",null,null,"$",null,null,null,null,null,null,"AR9.5.1"]
[]
[null,null,null,null,"TRANSMISSION CONNECTION FEES",null,null,"$",null,null,null,{"$f":"SUM(L30:L33)","v":0},null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 1 connection/augmentation fees>",null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 2 connection/augmentation fees>",null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 3 connection/augmentation fees>",null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"PAYMENTS TO EMBEDDED GENERATORS",null,null,"$",null,{"$f":"SUM(J36,J41)","v":0},{"$f":"SUM(K36,K41)","v":0},{"$f":"J35+K35","v":0}]
[null,null,null,null,"Avoided transmission costs",null,null,"$",null,{"$f":"SUM(J37:J40)","v":0},{"$f":"SUM(K37:K40)","v":0}]
[null,null,null,null,"<Business specified avoided transmission cost 1>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<Business specified avoided transmission cost 2>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<Business specified avoided transmission cost 3>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"Avoided TuOS ",null,null,"$",null,{"$f":"SUM(J42:J45)","v":0},{"$f":"SUM(K42:K45)","v":0}]
[null,null,null,null,"<Business specified avoided TuOS 1>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<Business specified avoided TuOS 2>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<Business specified avoided TuOS 3>",null,null,"$",null,null,null,null,null,null,"AR9.5.4"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"CROSS BOUNDARY NETWORK CHARGES",null,null,null,null,{"$f":"J48+J53+J58","v":0},{"$f":"K48+K53+K58","v":0},{"$f":"J47+K47","v":0}]
[null,null,null,null,"HV Crossings",null,null,null,null,{"$f":"SUM(J49:J51)","v":0},{"$f":"SUM(K49:K51)","v":0}]
[null,null,null,null,"<Business defined charge 1>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"Subtransmission Crossings",null,null,null,null,{"$f":"SUM(J54:J56)","v":0},{"$f":"SUM(K54:K56)","v":0}]
[null,null,null,null,"<Business defined charge 1>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"TUOS Adjustment",null,null,null,null,{"$f":"SUM(J59:J61)","v":0},{"$f":"SUM(K59:K61)","v":0}]
[null,null,null,null,"<Business defined charge 1>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"Proportion of total fleet expenditure allocated as regulatory expenditure"]
[null,null,null,null,"Car ",null,null,"%",null,null,null,null,null,null,"CA RIN 2.6.3"]
[null,null,null,null,"Light Commercial Vehicle",null,null,"%",null,null,null,null,null,null,"CA RIN 2.6.3"]
[null,null,null,null,"Elevated Work Platform (LCV)",null,null,"%",null,null,null,null,null,null,"CA RIN 2.6.3"]
[null,null,null,null,"Elevated Work Platform (HCV)",null,null,"%",null,null,null,null,null,null,"CA RIN 2.6.3"]
[null,null,null,null,"Heavy Commercial Vehicle",null,null,"%",null,null,null,null,null,null,"CA RIN 2.6.3"]

{"sheet":"Standard Control","index":5,"n_rows":142,"n_cols":21,"rows_kept":142,"cut":false,"hidden":false,"merged":[[132,1,140,1],[123,1,129,1],[117,1,120,1],[92,1,96,1],[44,1,50,1],[53,1,56,1],[60,1,72,1],[75,1,80,1],[83,1,88,1],[100,1,113,1],[40,4,40,7],[5,1,11,1],[36,1,41,1],[14,1,16,1],[20,1,26,1],[29,1,31,1],[0,4,0,12],[2,17,2,20],[37,4,37,7],[38,4,38,7],[39,4,39,7]]}
[null,null,null,null,"Data category 09: Revenue and financial statements"]
[null,null,null,null,null,null,null,null,null,null,"SERVICE CLASSIFICATIONS"]
[null,"Stakeholder Comments",null,null,null,null,null,null,"Units",null,"Standard Control Services","SCS (excluding Dual Function Assets)","Dual Function Assets",null,null,"Current RIN reference",null,"Validation rules"]
[null,null,null,null,"Income statement",null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D"]
[null,null,null,null,"TOTAL REVENUE",null,null,null,null,null,{"$f":"K6+K7+K8+K11+K12","v":0},{"$f":"L6+L7+L8+L11+L12","v":0},0]
[null,null,null,null,"Distribution revenue (excluding DFA revenues)",null,null,null,"$",null,{"$f":"L6+M6","v":0},null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Dual function asset revenue (Tx)",null,null,null,"$",null,{"$f":"L7+M7","v":0},null,null,null,null,"AR8.1.1"]
[null,null,null,null,"TUOS revenue",null,null,null,"$",null,0,{"$f":"L9+L10","v":0},{"$f":"M9+M10","v":0},null,null,"AR8.1.1"]
[null,null,null,null,"Cross boundary revenue",null,null,null,"$",null,{"$f":"L9+M9","v":0},null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Other TUOS revenue",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Jurisdictional scheme revenue",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Other revenue",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1"]
[]
[null,null,null,null,"Other revenue",null,null,null,null,null,{"$f":"SUM(K15:K17)","v":0},{"$f":"SUM(L15:L17)","v":0},0]
[null,null,null,null,"<Business revenue descriptor 1>",null,null,null,"$",null,{"$f":"L15+M15","v":0},null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<Business revenue descriptor 2>",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<Business revenue descriptor 3>",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"EXPENDITURE",null,null,null,null,null,{"$f":"K21+K24+K25+K26+K27","v":0},{"$f":"L21+L24+L25+L26+L27","v":0},{"$f":"M21+M24+M25+M26+M27","v":0}]
[null,null,null,null,"TUOS expenditure",null,null,null,"$",null,{"$f":"L21+M21","v":0},{"$f":"L22+L23","v":0},{"$f":"M22+M23","v":0},null,null,"AR8.1.1.2"]
[null,null,null,null,"Cross boundary expenditure",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other TUOS expenditure",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Jurisdictional scheme payments",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Maintenance expenditure",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Operating expenditure excluding maintenance expenditure",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other expenditure",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[]
[null,null,null,null,"Other expenditure",null,null,null,null,null,{"$f":"SUM(K30:K32)","v":0},{"$f":"SUM(L30:L32)","v":0},{"$f":"SUM(M30:M32)","v":0}]
[null,null,null,null,"<Business expenditure descriptor 1>",null,null,null,"$",null,{"$f":"L30+M30","v":0},null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<Business expenditure descriptor 2>",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<Business expenditure descriptor 3>",null,null,null,"$",null,0,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"Profitability - Tax data"]
[null,null,null,null,"OWNERSHIP STRUCTURE"]
[null,null,null,null,"Ownership Structure",null,null,null,null,null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Proportion of holding interest in flow-through vehicle attributable to a NTER or government owned non-NTER entity",null,null,null,"%",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Tax rate applicable to holding interest attributable to a NTER or government-owned non-NTER entity",null,null,null,"%",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Proportion of holding interest in flow-through vehicle not attributable to a NTER or government owned non-NTER entity",null,null,null,"%",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Tax rate applicable to holding interest not attributable to a NTER or government owned non-NTER entity",null,null,null,"%",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Flow-though blended tax rate",null,null,null,"%",null,{"$f":"K38*K39+K40*K41","v":0},null,null,null,null,"NEW IR"]
[]
[null,null,null,null,"TAX RELATED INFORMATION"]
[null,null,null,null,"Tax asset base depreciation",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Tax rate",null,null,null,"%",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Taxable income adjustments"]
[null,null,null,null,"Tax loss carried forward",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Adjustment to tax expense for value of gifted assets",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Permanent differences due to disallowed interest expense",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Permanent differences due to adjustments to prior year returns",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[]
[null,null,null,null,"INTEREST EXPENSE"]
[null,null,null,null,"Debt and Equity"]
[null,null,null,null,"Interest bearing liabilities",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Related party interest expense",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[null,null,null,null,"Interest expense",null,null,null,"$",null,null,null,null,null,null,"NEW IR"]
[]
[null,null,null,null,"Disaggregated Revenue"]
[null,null,null,null,"REVENUE GROUPING BY CHARGEABLE QUANTITY",null,null,null,null,null,{"$f":"SUM(K61:K73)","v":0}]
[null,null,null,null,"Revenue from Fixed Customer Charges ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Energy Delivery charges where time of use is not a determinant",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from On–Peak Energy Delivery charges ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Shoulder period Energy Delivery Charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Off–Peak Energy Delivery charges ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from controlled load customer charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from unmetered supplies",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Contracted Maximum Demand charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Measured Maximum Demand charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from metering charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from connection charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from public lighting charges",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from other Sources",null,null,null,"$",null,null,null,null,null,null,"EB3.1.1"]
[]
[null,null,null,null,"REVENUE GROUPING BY CUSTOMER TYPE OR CLASS",null,null,null,null,null,{"$f":"SUM(K76:K81)","v":0}]
[null,null,null,null,"Revenue from residential Customers ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non residential customers not on demand tariffs ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non-residential low voltage demand tariff customers ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non-residential high voltage demand tariff customers ",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from unmetered supplies",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Other Customers",null,null,null,"$",null,null,null,null,null,null,"EB3.1.2"]
[]
[null,null,null,null,"REVENUE REWARDS AND PENALTIES - INCENTIVE SCHEMES",null,null,null,null,null,{"$f":"SUM(K84:K89)","v":0}]
[null,null,null,null,"EBSS",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[null,null,null,null,"CESS",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[null,null,null,null,"STPIS",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[null,null,null,null,"CSIS",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[null,null,null,null,"S-Factor True up",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[null,null,null,null,"Other",null,null,null,"$",null,null,null,null,null,null,"EB3.1.3"]
[]
[null,null,null,null,"Jurisdictional Scheme Payments"]
[null,null,null,null,"Jurisdictional Scheme Name","Description","Date DNSP became subject to Scheme","Description of Cost Recovery Method"]
[null,null,null,null,"<Scheme 1>","<Description 1>","<Date 1>","<Description recovery 1>","$",null,null,null,null,null,null,"AR7.10.1"]
[null,null,null,null,"<Scheme 2>","<Description 2>","<Date 2>","<Description recovery 2>","$",null,null,null,null,null,null,"AR7.10.1"]
[null,null,null,null,"<Scheme 3>","<Description 3>","<Date 3>","<Description recovery 3>","$",null,null,null,null,null,null,"AR7.10.1"]
[null,null,null,null,"<Scheme 4>","<Description 4>","<Date 4>","<Description recovery 4>","$",null,null,null,null,null,null,"AR7.10.1"]
[null,null,null,null,"<Scheme 5>","<Description 5>","<Date 5>","<Description recovery 5>","$",null,null,null,null,null,null,"AR7.10.1"]
[]
[null,null,null,null,"Cross boundary expenditures"]
[null,null,null,null,"HV CROSSINGS"]
[null,null,null,null,"<Business defined charge 1>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"SUBTRANSMISSION CROSSINGS"]
[null,null,null,null,"<Business defined charge 1>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"TUOS ADJUSTMENT"]
[null,null,null,null,"<Business defined charge 1>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 2>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<Business defined charge 3>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.3"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"TUOS expenditure "]
[null,null,null,null,"TUOS CHARGES (AEMO)"]
[null,null,null,null,"TNSP/AEMO (Locational & Non-Locational)",null,null,null,"$",null,null,null,null,null,null,"AR9.5.1"]
[null,null,null,null,"TNSP/AEMO (TUoS Common Service Charge)",null,null,null,"$"]
[null,null,null,null,"Grid equalisation",null,null,null,"$"]
[null,null,null,null,"Other",null,null,null,"$"]
[]
[null,null,null,null,"TRANSMISSION CONNECTION FEES"]
[null,null,null,null,"<TNSP 1 Connection>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 1 Augmentation>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 2 Connection>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 2 Augmentation>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 3 Connection>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<TNSP 3 Augmentation>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.2"]
[null,null,null,null,"<additional connection and augmentation rows allowed>"]
[]
[null,null,null,null,"PAYMENTS TO EMBEDDED GENERATORS"]
[null,null,null,null,"Avoided transmission costs"]
[null,null,null,null,"<Embedded Generator 1>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.1"]
[null,null,null,null,"<Embedded Generator 2>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.1"]
[null,null,null,null,"<Embedded Generator 3>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.1"]
[null,null,null,null,"<additional rows allowed>"]
[null,null,null,null,"Avoided TuOS "]
[null,null,null,null,"<Embedded Generator 1>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.2"]
[null,null,null,null,"<Embedded Generator 2>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.2"]
[null,null,null,null,"<Embedded Generator 3>",null,null,null,"$",null,null,null,null,null,null,"AR9.5.4.2"]
[null,null,null,null,"<additional rows allowed>"]

{"sheet":"ACS","index":6,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,7,2,17],[3,7,4,7],[3,8,3,10],[3,11,3,13],[3,14,3,17],[4,22,4,24],[25,1,37,1],[40,1,45,1],[7,1,8,1],[11,1,13,1],[16,1,21,1]]}
[null,null,null,null,"Data category 09: Revenue and financial statements"]
[null,null,null,null,null,null,null,"SERVICE CLASSIFICATIONS"]
[null,null,null,null,null,null,null,"Alternative Control Services "]
[null,null,null,null,null,null,null,"Total ACS","Public Lighting",null,null,"Metering services",null,null,"Ancillary network services"]
[null,"Stakeholder Comments",null,null,null,"Units",null,null,"Total","Energy Efficient","Non-energy efficient","Total","Smart meters","Legacy meters","Total","Connection services","Fee","Quoted",null,null,"Current RIN reference",null,"Validation rules"]
[null,null,null,null,"Income Statement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C"]
[null,null,null,null,"TOTAL REVENUE",null,null,{"$f":"H8+H9","v":0},{"$f":"SUM(I8:I9)","v":0},{"$f":"SUM(J8:J9)","v":0},{"$f":"SUM(K8:K9)","v":0},{"$f":"SUM(L8:L9)","v":0},{"$f":"SUM(M8:M9)","v":0},0,0,0,0,0,null,null,"AR8.1.1"]
[null,null,null,null,"ACS revenue","$",null,{"$f":"I8+L8+IF(O8<>\"\",O8,P8+Q8+R8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Other revenue","$",null,{"$f":"I9+L9+IF(O9<>\"\",O9,P9+Q9+R9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AR8.1.1"]
[]
[null,null,null,null,"EXPENDITURE",null,null,{"$f":"H12+H13+H14","v":0},{"$f":"SUM(I12:I14)","v":0},{"$f":"SUM(J12:J14)","v":0},{"$f":"SUM(K12:K14)","v":0},{"$f":"SUM(L12:L14)","v":0},{"$f":"SUM(M12:M14)","v":0},0,0,0,0,0,null,null,"AR8.1.1.2"]
[null,null,null,null,"Maintenance expenditure","$",null,{"$f":"I12+L12+IF(O12<>\"\",O12,P12+Q12+R12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Operating expenditure excluding maintenance expenditure","$",null,{"$f":"I13+L13+IF(O13<>\"\",O13,P13+Q13+R13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other expenditure","$",null,{"$f":"I14+L14+IF(O14<>\"\",O14,P14+Q14+R14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"AR8.1.1.2"]
[]
[null,null,null,null,"Public Lighting Revenue by Tariff"]
[null,null,null,null,"BUSINESS DEFINED TARIFF CATEGORIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<Business defined category 1>","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<Business defined category 2>","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<Business defined category 3>","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<Business defined category 4>","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<Business defined category 5>","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR4.1.4"]
[null,null,null,null,"<additional rows allowed>"]
[]
[null,null,null,null,"Revenue Grouping by Chargable Quantity"]
[null,null,null,null,"Revenue from Fixed Customer Charges ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Energy Delivery charges where time of use is not a determinant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from On–Peak Energy Delivery charges ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Shoulder period Energy Delivery Charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Off–Peak Energy Delivery charges ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from controlled load customer charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from unmetered supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Contracted Maximum Demand charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from Measured Maximum Demand charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from metering charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from connection charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from public lighting charges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[null,null,null,null,"Revenue from other Sources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.1"]
[]
[null,null,null,null,"Revenue Grouping by Customer Type or Class"]
[null,null,null,null,"Revenue from residential Customers ","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non residential customers not on demand tariffs ","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non-residential low voltage demand tariff customers ","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Non-residential high voltage demand tariff customers ","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from unmetered supplies","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]
[null,null,null,null,"Revenue from Other Customers","$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB3.1.2"]

{"sheet":"Negotiated Services","index":7,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,11,1],[14,1,20,1],[0,4,0,10],[2,15,2,17]]}
[null,null,null,null,"Data category 09: Revenue and financial statements"]
[null,null,null,null,null,null,null,null,null,null,"SERVICE CLASSIFICATIONS"]
[null,null,null,null,null,null,null,null,null,null,"Negotiated services",null,null,"Current RIN reference",null,"Validation rules"]
[null,"Stakeholder Comments",null,null,"Income statement",null,null,null,null,null,null,null,null,null,null,"A","B","C"]
[null,null,null,null,"TOTAL REVENUE",null,null,null,"Units",null,{"$f":"SUM(K6:K12)","v":0}]
[null,null,null,null,"Distribution revenue (excluding DFA revenues)",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Dual function asset revenue (Tx)",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"TUOS revenue",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Cross boundary revenue",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Other TUOS revenue",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Jurisdictional scheme amounts",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[null,null,null,null,"Other revenue",null,null,null,"$",null,null,null,null,"AR8.1.1"]
[]
[null,null,null,null,"EXPENDITURE",null,null,null,null,null,{"$f":"SUM(K15:K21)","v":0}]
[null,null,null,null,"TUOS expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Cross boundary expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other TUOS expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Jurisdictional scheme amounts",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Maintenance expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Operating expenditure excluding maintenance expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]
[null,null,null,null,"Other expenditure",null,null,null,"$",null,null,null,null,"AR8.1.1.2"]

{"sheet":"Provisions","index":8,"n_rows":144,"n_cols":15,"rows_kept":144,"cut":false,"hidden":false,"merged":[[126,1,143,1],[106,1,123,1],[86,1,103,1],[3,12,3,14],[6,1,23,1],[26,1,43,1],[46,1,63,1],[66,1,83,1]]}
[null,null,null,null,"Data category 09: Revenue and financial statements"]
[null,null,null,null,"Provisions "]
[]
[null,null,null,null,null,"Units",null,"Standard Control Services",null,null,"Current RIN reference",null,"Validation rules"]
[null,"Stakeholder Comments",null,null,null,null,null,null,null,null,null,null,"A","B","C"]
[null,null,null,null,"Total Provisions"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,{"$f":"SUM(H27,H47,H67,H87,H107,H127)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,null,null,null,"Opex component"," $",null,{"$f":"SUM(H29,H49,H69,H89,H109,H129)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,{"$f":"SUM(H30,H50,H70,H90,H110,H130)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,{"$f":"SUM(H31,H51,H71,H91,H111,H131)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,null,null,null,"Opex component"," $",null,{"$f":"SUM(H33,H53,H73,H93,H113,H133)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,{"$f":"SUM(H34,H54,H74,H94,H114,H134)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,{"$f":"SUM(H35,H55,H75,H95,H115,H135)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period"]
[null,null,null,null,"Opex component"," $",null,{"$f":"SUM(H37,H57,H77,H97,H117,H137)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,{"$f":"SUM(H38,H58,H78,H98,H118,H138)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,{"$f":"SUM(H39,H59,H79,H99,H119,H139)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,null,null,null,"Opex component"," $",null,{"$f":"SUM(H41,H61,H81,H101,H121,H141)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,{"$f":"SUM(H42,H62,H82,H102,H122,H142)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,{"$f":"SUM(H43,H63,H83,H103,H123,H143)","v":0},null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"SUM(H44,H64,H84,H104,H124,H144)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 1>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H27+SUM(H29:H31)-SUM(H33:H35)-SUM(H37:H39)+SUM(H41:H43)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 2>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H47+SUM(H49:H51)-SUM(H53:H55)-SUM(H57:H59)+SUM(H61:H63)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 3>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H67+SUM(H69:H71)-SUM(H73:H75)-SUM(H77:H79)+SUM(H81:H83)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 4>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H87+SUM(H89:H91)-SUM(H93:H95)-SUM(H97:H99)+SUM(H101:H103)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 5>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H107+SUM(H109:H111)-SUM(H113:H115)-SUM(H117:H119)+SUM(H121:H123)","v":0},null,null,"EB3.2.3"]
[]
[null,null,null,null,"<Business specific provision 6>"]
[null,null,null,null,"OPENING BALANCE (the carrying amount at the beginning of the period)"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Additional provisions made in the period, including increases to existing provisions",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Amounts used (that is, incurred and charged against the provision) during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Unused amounts reversed during the period",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"The increase during the period in the discounted amount arising from the passage of time and the effect of any change in the discount rate",null,null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Opex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Capex component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Other component"," $",null,null,null,null,"EB3.2.3"]
[null,null,null,null,"Closing balance (carrying amount at the end of the period)"," $",null,{"$f":"H127+SUM(H129:H131)-SUM(H133:H135)-SUM(H137:H139)+SUM(H141:H143)","v":0},null,null,"EB3.2.3"]