{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Guidelines","Reporting - Entity Details","Reporting - Clause 12","Definitions","Submission Due Dates","Filename Convention","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[10,0,10,4]]}
["General Exemption Order 2022"]
["Essential Services Commission Embedded Networks Reporting Obligations Template for Exemptions (excluding VD8 exemptions and VR2* exemptions for new embedded networks). "]
["For VD8 and VR2* exemptions for new embedded networks please use the relevant reporting template available on our website."]
["How to complete your annual reporting:\nData is to be supplied to the Commission on the correct reporting template. \nData is to be provided in the relevant tabs within the reporting template. \nDefinitions and descriptions of reporting requirements are found in the Definitions tab.\nData is to be supplied on an annual basis for the period '1 January to 31 December' on or before 31 March for the previous calendar year.\nThe filename convention for the submission files is shown on the Filename Convention tab. Please note the submission files are required in excel .xlsx format. \nSend submissions to exemptionregister@esc.vic.gov.au"]
["Template Navigation"]
["Go to the Reporting - Enity Details tab"]
["Go to the Reporting - Clause 12 tab"]
["Go to the Definitions tab"]
["Go to the Subission Due Dates tab"]
["Go to the Filename Convention tab"]
["*A new embedded network means any embedded network other than an embedded network in respect of which immediately before the commencement date**:\n     (a) a licensed retailer was selling the electricity supplied to all of the customers’ premises connected to that embedded network; \n     (b) a person was selling electricity supplied to customers’ premises connected to that embedded network under the exemption in the General Exemption 2017 identified in item 9 of column 1 of the table in the Schedule to this Order; or\n     (c) each of the following conditions was satisfied:\n          (i) electricity had not yet been supplied from that embedded network;\n          (ii) a person intended to carry out the VR2 retail activity in respect of that embedded network after the commencement date; and\n          (iii) the commitment date for that embedded network had occurred\"\n**Commencement date for new embedded networks means on or after 1 January 2023."]
["Note:"]
["Click on the links in the worksheet column headings to navigate to the definitions worksheet."]
["Select the relevant provision from the dropdown menu in the worksheet."]

{"sheet":"Guidelines","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}

{"sheet":"Reporting - Entity Details","index":2,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["1. Exempt person's entity name* \n(input: text)","2. Exempt person's Australian Company Number (ACN)*\n(input: number)","3. Exempt person's trading name (if applicable)\n(input: text)","4. Third-party service provider name (if applicable)\n(input: text)","5. Embedded network site address*\n(input: alpha-numeric)","6. Embedded network site name*\n(input: text)","7. Exemption type*\n(input: select from drop down)"]

{"sheet":"Reporting - Clause 12","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Embedded network site address*","Embedded network site name*","8. Reporting period end date*\n(input: date)","9. Supply facility entity name*\n(input: select from drop down)","10. Type(s) of meters installed at the new embedded network excluding the parent meter*\n(input: select from drop down)","11. Total number of residential customers whose premises are connected to the new embedded network*\n(input: number)","12. Total number of small commercial/retail customers whose premises are connected to the embedded network*\n(input: number)","13. Total number of large customers whose premises are connected to the embedded network*\n(input: number)","14. Total number of meters installed at the embedded network excluding the parent meter*\n(input: number)","15. Meter owner entity name excluding the parent meter*\n(input: text)"]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[{"$f":"IF(Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]]=\"\",\"\",Table2[[#This Row],[5. Embedded network site address*\n(input: alpha-numeric)]])","v":""},{"$f":"IF(Table2[[#This Row],[6. Embedded network site name*\n(input: text)]]=\"\",\"\",Table2[[#This Row],[6. Embedded network site name*\n(input: text)]])","v":""}]
[]
[]
[]
[null,null,null,"Ausnet"]
[null,null,null,"Citipower"]

{"sheet":"Definitions","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Item No.","GEO Relevant Section (if applicable)","Description of Condition (if applicable)","Tab Name","Data Item\n*Indicates a required field","Definition of Data Item","Possible Data Input"]
[1,null,null,"Reporting - Entity Details","Exempt person's entity name*","The legal name of the exempt entity who is selling electricity supplied to customers’ premises connected to that embedded network.","Text"]
[2,null,null,"Reporting - Entity Details","Exempt person's Australian Company Number (ACN)*","The ACN of the exempt person who is selling electricity supplied to customers’ premises connected to that embedded network.","Number"]
[3,null,null,"Reporting - Entity Details","Exempt person's trading name (if applicable)","The trading name of the exempt entity who is selling electricity supplied to customers’ premises connected to that embedded network.","Text"]
[4,null,null,"Reporting - Entity Details","Third-party service provider name (if applicable)","If you have a third-party service provider or agent as the contact for your customers, include their details.","Text"]
[5,null,null,"Reporting - Entity Details","Embedded network site address*","The site address for the embedded network for which you are selling electricity.","Alpha-numeric\nFormat:  Road number name & type, locality, state postcode \nE.g. 1 James Street, Melbourne, Victoria 3000 "]
[6,null,null,"Reporting - Entity Details","New embedded network site name*","The site name for the embedded network for which you are selling electricity.","Text"]
[7,null,null,"Reporting - Entity Details","Exemption type*","The registered exemption activity as outlined in Division 1 of the GEO. ","Select from drop down (multiple options available if applicable)\nVR1, VR2 for an existing network, VR3, VR4, VR5, VNR1, VNR2, VNR3, VNR4, VNR5"]
[8,"12(1)(b)","It is a condition of an exemption under this Part that the exempt person must provide to the Commission (whether or not through an agent) any information requested by the Commission, that the Minister or the Commission (as the case requires) requests for the administration of this Part.","Reporting - Clause 12","Reporting period end date*","The reporting period end date for the calendar year for which you are doing your reporting.","Date\ndd/mm/yyyy"]
[9,"12(2)(c) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the supply facility from which the electricity is supplied to that embedded network.","Reporting - Clause 12","Supply facility entity name* ","The name of the entity that operates the supply facility from which the electricity is supplied to that embedded network (E.g. licenced distribution company).","Select from drop down\nAusnet, Citipower Jemena, Powercor, United Energy"]
[10,"12(2)(e) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number and types of meters installed at the relevant embedded network including the owners of those meters.","Reporting - Clause 12","Type(s) of meters installed at the embedded network excluding the parent meter*","Consult AEMO for meter type classifications. \nUse the input cell drop down menu to select the types of meters installed at the new emebedded network excluding the parent meter. \n","Select from drop down\nType 1-4, Type 5, Type 6, Type 7"]
[11,"12(2)(d)(i) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number of residential customers, small commercial/retail customers and large customers whose premises are connected to the relevant embedded network and to whom the exempt person was selling electricity on 1 January in that year.","Reporting - Clause 12","Total number of residential customers whose premises are connected to the embedded network*","Residential customer means a person who buys electricity principally for personal, household or domestic use at premises.","Number"]
[12,"12(2)(d)(i) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number of residential customers, small commercial/retail customers and large customers whose premises are connected to the relevant embedded network and to whom the exempt person was selling electricity on 1 January in that year.","Reporting - Clause 12","Total number of small commercial/retail customers whose premises are connected to the embedded network*","Small commercial/retail customer means a business customer to whom peak demand of less than 500 kVa, and consumption of less than 160 MWh per annum, is distributed, supplied or sold for commercial or industrial purposes.","Number"]
[13,"12(2)(d)(i) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number of residential customers, small commercial/retail customers and large customers whose premises are connected to the relevant embedded network and to whom the exempt person was selling electricity on 1 January in that year.","Reporting - Clause 12","Total number of large customers whose premises are connected to the embedded network*","Large customer means a business customer to whom peak demand of not less than 500 kVa, or consumption of not less than 160 MWh per annum is distributed, supplied or sold for commercial or industrial purposes.","Number"]
[14,"12(2)(e) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number and types of meters installed at the relevant embedded network including the owners of those meters.","Reporting - Clause 12","Total number of meters installed at the embedded network excluding the parent meter*","Meter means any device that measures the quantity of electricity passing through it or that records the consumption of electricity at the customer’s premises.","Number"]
[15,"12(2)(e) ","Without limiting subclause (1), it is a condition of an exemption under Division 1 under which electricity is supplied from an embedded network to customers whose premises are connected to that embedded network; that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) in the form required by the Commission details of the number and types of meters installed at the relevant embedded network including the owners of those meters.","Reporting - Clause 12","Meter owner entity name excluding the parent meter*","The name of the entity that owns the meters installed at the embedded network excluding the parent meter.","Text"]

{"sheet":"Submission Due Dates","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[16,1,16,2],[17,1,17,2],[1,1,3,3],[12,1,12,2],[15,1,15,2],[14,1,14,2],[13,1,13,2]]}
[]
[null," It is a condition of an exemption that, on or before 31 March in each year, the exempt person must provide to the Commission (whether or not through an agent) any information requested by the Commission in the form required by the Commission."]
[]
[]
[]
[null,"Year","Reporting Period End Date","Submission Due Dates"]
[null,2023,"2023-12-31","2024-03-31"]
[null,2024,"2024-12-31","2025-03-31"]
[null,2025,"2025-12-31","2026-03-31"]
[null,2026,"2026-12-31","2027-03-31"]
[null,2027,"2027-12-31","2028-03-31"]

{"sheet":"Filename Convention","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[8,1,8,4],[9,1,9,4],[16,1,16,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2]]}
[]
[null,"The filename convention for the submission files is to follow the below format."]
[null,"Files are required in excel .xlsx format."]
[null,"Below is an example of a filename for Melbourne Apartments Pty Ltd yearly embedded network data for 2023."]
[]
[null,"Exempt Person","Activity","Year","File Type"]
[null,"Melbourne Apartments","ENReporting",2023,".xlsx"]
[]
[null,"Sample filename"]
[null,"MelbourneApartments_ENReporting_2023.xlsx"]

{"sheet":"Sheet1","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["2023-12-31","Yes","VR1","Type 1-4 (interval meter with communications)",null,null,"Ausnet"]
["2024-12-31","No","VR2","Type 5 (interval meter - manually read)",null,null,"Citipower",null,"VR1"]
["2025-12-31",null,"VR3","Type 6 (accumulation meter)",null,null,"Jemena",null,"VR2 for an existing network"]
["2026-12-31",null,"VR4","Type 7 (unmetered supply)",null,null,"Powercor",null,"VR3"]
["2027-12-31",null,"VR5",null,null,null,"United Energy",null,"VR4"]
[null,null,null,null,null,null,null,null,"VR5"]
[null,null,null,null,null,null,null,null,"VNR1"]
[null,null,null,null,null,null,null,null,"VNR2"]
[null,null,null,null,null,null,null,null,"VNR3"]
[null,null,null,null,null,null,null,null,"VNR4"]
[null,null,null,null,null,null,null,null,"VNR5"]