{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Contribution model","Outputs>>","Validation","Tables","Historical outputs","Inputs>>","General","Financial","Energy","Exemptions","Calculations>>","Net costs","Adjustments","Apportionment","Lookups","Glossary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":"Contribution model","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,8,35,9],[14,8,14,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[13,8,13,9],[12,8,12,9]]}
[]
[null,null,null,null,null,null,"AER contribution determination model"]
[null,null,null,null,null,null,{"$f":"forecastyear","v":"2024–25"}]
[]
[]
[]
[null,"Legend"]
[]
[null,null,"Key:",null,null,null,"Version Record","Date","Description"]
[null,null,null,"Annual SFV input",null,null,"0","2022-05-31","Draft contribution determination model for public consultation"]
[null,null,null,"Calculation",null,null,0.1,"2022-06-16","Draft contribution determination model for public consultation revised"]
[null,null,null,"N/A",null,null,1,"2022-10-18","Contribution determination model for AER use after minor revisions"]
[null,null,null,null,null,null,1.1000000000000001,"2023-06-01","Draft contribution determination model for public consultation"]
[]
[null,null,"Each worksheet includes space for commentary and notes (in column W) "]
[]
[null,"Contents"]
[]
[null,null,"Outputs"]
[null,null,"Validation",null,"Validation checks"]
[null,null,"Tables",null,"Tables of outputs"]
[null,null,"Historical outputs",null,"Historical contribution determination (requires manual update every year)"]
[null,null,"Inputs"]
[null,null,"General",null,"General inputs including target year"]
[null,null,"Financial",null,"Financial inputs including costs and revenues"]
[null,null,"Energy",null,"Annual volumetric energy and annual peak demand for DNSPs"]
[null,null,"Exemptions",null,"Exemptions for emissions intensive trade exposed and green hydrogen"]
[null,null,"Calculations"]
[null,null,"Net costs",null,"Calculates 3-year rolling average of net costs and volumetric component "]
[null,null,"Adjustments",null,"Calculates contribution determination amount including true-up and minimum prudent balance allowance"]
[null,null,"Apportionment",null,"Calculates amounts apportioned to DNSPs"]
[null,null,{"$f":"Lookups!B2","v":"Lookups"},null,"Lookup tables"]
[null,null,"Glossary",null,"Glossary "]
[]
[null,"Link to Guideline"]
[]
[null,null,"https://www.aer.gov.au/networks-pipelines/guidelines-schemes-models-reviews/nsw-contribution-determination-guideline"]
[]
[null,"End"]

{"sheet":"Outputs>>","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Contribution model'!G2&\" - \"&'Contribution model'!G3","v":"AER contribution determination model - 2024–25"},null,null,null,"Back to Index"]
[]
[null,"Output sheets"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Validation","Validation checks"]
[null,null,"Tables","Tables of outputs"]
[null,null,"Historical outputs","Historical contribution determination (requires manual update every year)"]
[]
[null,"End"]

{"sheet":"Validation","index":2,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Outputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(T4:T98,\"NOT VALID\")>0,\"NOT VALID\",\"VALID\")","v":"VALID"}]
[]
[null,"Validation check",null,null,null,"Unit",null,null,null,"2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,"Compliance",null,null,"Notes"]
[]
[]
[null,{"$f":"Tables!C5","v":"Ausgrid"},null,null,null,"$millions",null,null,null,{"$f":"IF(J$4<forecastyear,'Historical outputs'!K5,Apportionment!L202)","v":0},{"$f":"IF(K$4<forecastyear,'Historical outputs'!L5,Apportionment!M202)","v":""},{"$f":"IF(L$4<forecastyear,'Historical outputs'!M5,Apportionment!N202)","v":""},{"$f":"IF(M$4<forecastyear,'Historical outputs'!N5,Apportionment!O202)","v":""},{"$f":"IF(N$4<forecastyear,'Historical outputs'!O5,Apportionment!P202)","v":""},{"$f":"IF(O$4<forecastyear,'Historical outputs'!P5,Apportionment!Q202)","v":""},{"$f":"IF(P$4<forecastyear,'Historical outputs'!Q5,Apportionment!R202)","v":""},{"$f":"IF(Q$4<forecastyear,'Historical outputs'!R5,Apportionment!S202)","v":""},{"$f":"IF(R$4<forecastyear,'Historical outputs'!S5,Apportionment!T202)","v":""}]
[null,{"$f":"Tables!C6","v":"Endeavour Energy"},null,null,null,"$millions",null,null,null,{"$f":"IF(J$4<forecastyear,'Historical outputs'!K6,Apportionment!L203)","v":0},{"$f":"IF(K$4<forecastyear,'Historical outputs'!L6,Apportionment!M203)","v":""},{"$f":"IF(L$4<forecastyear,'Historical outputs'!M6,Apportionment!N203)","v":""},{"$f":"IF(M$4<forecastyear,'Historical outputs'!N6,Apportionment!O203)","v":""},{"$f":"IF(N$4<forecastyear,'Historical outputs'!O6,Apportionment!P203)","v":""},{"$f":"IF(O$4<forecastyear,'Historical outputs'!P6,Apportionment!Q203)","v":""},{"$f":"IF(P$4<forecastyear,'Historical outputs'!Q6,Apportionment!R203)","v":""},{"$f":"IF(Q$4<forecastyear,'Historical outputs'!R6,Apportionment!S203)","v":""},{"$f":"IF(R$4<forecastyear,'Historical outputs'!S6,Apportionment!T203)","v":""}]
[null,{"$f":"Tables!C7","v":"Essential Energy"},null,null,null,"$millions",null,null,null,{"$f":"IF(J$4<forecastyear,'Historical outputs'!K7,Apportionment!L204)","v":0},{"$f":"IF(K$4<forecastyear,'Historical outputs'!L7,Apportionment!M204)","v":""},{"$f":"IF(L$4<forecastyear,'Historical outputs'!M7,Apportionment!N204)","v":""},{"$f":"IF(M$4<forecastyear,'Historical outputs'!N7,Apportionment!O204)","v":""},{"$f":"IF(N$4<forecastyear,'Historical outputs'!O7,Apportionment!P204)","v":""},{"$f":"IF(O$4<forecastyear,'Historical outputs'!P7,Apportionment!Q204)","v":""},{"$f":"IF(P$4<forecastyear,'Historical outputs'!Q7,Apportionment!R204)","v":""},{"$f":"IF(Q$4<forecastyear,'Historical outputs'!R7,Apportionment!S204)","v":""},{"$f":"IF(R$4<forecastyear,'Historical outputs'!S7,Apportionment!T204)","v":""}]
[null,{"$f":"Adjustments!C24","v":"Contribution determination amount"},null,null,null,"$millions",null,null,null,{"$f":"IF(J$4<forecastyear,'Historical outputs'!K8,Adjustments!L24)","v":0},{"$f":"IF(K$4<forecastyear,'Historical outputs'!L8,Adjustments!M24)","v":0},{"$f":"IF(L$4<forecastyear,'Historical outputs'!M8,Adjustments!N24)","v":0},{"$f":"IF(M$4<forecastyear,'Historical outputs'!N8,Adjustments!O24)","v":0},{"$f":"IF(N$4<forecastyear,'Historical outputs'!O8,Adjustments!P24)","v":0},{"$f":"IF(O$4<forecastyear,'Historical outputs'!P8,Adjustments!Q24)","v":0},{"$f":"IF(P$4<forecastyear,'Historical outputs'!Q8,Adjustments!R24)","v":0},{"$f":"IF(Q$4<forecastyear,'Historical outputs'!R8,Adjustments!S24)","v":0},{"$f":"IF(R$4<forecastyear,'Historical outputs'!S8,Adjustments!T24)","v":0}]
[null,"Check",null,null,null,null,null,null,null,{"$f":"IFERROR(J7+J8+J9=J10,\"\")","v":true},{"$f":"IFERROR(K7+K8+K9=K10,\"\")","v":""},"","","","","","","",null,{"$f":"IFERROR(IF(AND(J11:R11),\"VALID\",\"NOT VALID\"),\"\")","v":"VALID"}]
[]
[null,"End"]

{"sheet":"Tables","index":3,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | Contribution determination for target year (t)",null,null,null,"Unit",null,null,null,{"$f":"forecastyear","v":"2024–25"},null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,"Ausgrid",null,null,"$millions",null,null,null,{"$f":"INDEX(Apportionment!J202:T202,1,MATCH($J$3,Apportionment!$J$187:$T$187,0))","v":""}]
[null,null,"Endeavour Energy",null,null,"$millions",null,null,null,{"$f":"INDEX(Apportionment!J203:T203,1,MATCH($J$3,Apportionment!$J$187:$T$187,0))","v":""}]
[null,null,"Essential Energy",null,null,"$millions",null,null,null,{"$f":"INDEX(Apportionment!J204:T204,1,MATCH($J$3,Apportionment!$J$187:$T$187,0))","v":""}]
[null,null,"Contribution determination amount",null,null,"$millions",null,null,null,{"$f":"SUM(J5:J7)","v":0}]
[null,null,"Minimum prudent balance allowance",null,null,"$millions",null,null,null,{"$f":"INDEX(Financial!$K$65:$T$65,0,MATCH(Tables!J3,Financial!$K$62:$T$62,0))","v":0}]
[]
[null,"Table 2 | Proportion of amount for each DNSP linked to LTESAs (generation)",null,null,null,"Unit",null,null,null,{"$f":"forecastyear","v":"2024–25"},null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,{"$f":"INDEX(Apportionment!J215:T215,1,MATCH($J$11,Apportionment!$J$207:$T$207,0))","v":""}]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,{"$f":"INDEX(Apportionment!J216:T216,1,MATCH($J$11,Apportionment!$J$207:$T$207,0))","v":""}]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,{"$f":"INDEX(Apportionment!J217:T217,1,MATCH($J$11,Apportionment!$J$207:$T$207,0))","v":""}]
[]
[null,"Table 3 | Energy data",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Annual Volumetric Energy by DNSP"]
[null,null,{"$f":"Energy!C7","v":"Ausgrid"},null,null,"GWh",null,null,null,{"$f":"Energy!J7","v":0},{"$f":"Energy!K7","v":0},{"$f":"Energy!L7","v":0},{"$f":"Energy!M7","v":0},{"$f":"Energy!N7","v":0},{"$f":"Energy!O7","v":0},{"$f":"Energy!P7","v":0},{"$f":"Energy!Q7","v":0},{"$f":"Energy!R7","v":0},{"$f":"Energy!S7","v":0},{"$f":"Energy!T7","v":0}]
[null,null,{"$f":"Energy!C8","v":"Endeavour Energy"},null,null,"GWh",null,null,null,{"$f":"Energy!J8","v":0},{"$f":"Energy!K8","v":0},{"$f":"Energy!L8","v":0},{"$f":"Energy!M8","v":0},{"$f":"Energy!N8","v":0},{"$f":"Energy!O8","v":0},{"$f":"Energy!P8","v":0},{"$f":"Energy!Q8","v":0},{"$f":"Energy!R8","v":0},{"$f":"Energy!S8","v":0},{"$f":"Energy!T8","v":0}]
[null,null,{"$f":"Energy!C9","v":"Essential Energy"},null,null,"GWh",null,null,null,{"$f":"Energy!J9","v":0},{"$f":"Energy!K9","v":0},{"$f":"Energy!L9","v":0},{"$f":"Energy!M9","v":0},{"$f":"Energy!N9","v":0},{"$f":"Energy!O9","v":0},{"$f":"Energy!P9","v":0},{"$f":"Energy!Q9","v":0},{"$f":"Energy!R9","v":0},{"$f":"Energy!S9","v":0},{"$f":"Energy!T9","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,{"$f":"Energy!J10","v":0},{"$f":"Energy!K10","v":0},{"$f":"Energy!L10","v":0},{"$f":"Energy!M10","v":0},{"$f":"Energy!N10","v":0},{"$f":"Energy!O10","v":0},{"$f":"Energy!P10","v":0},{"$f":"Energy!Q10","v":0},{"$f":"Energy!R10","v":0},{"$f":"Energy!S10","v":0},{"$f":"Energy!T10","v":0}]
[]
[null,null,"Annual Peak Demand by DNSP"]
[null,null,{"$f":"Energy!C14","v":"Ausgrid"},null,null,"MVA",null,null,null,{"$f":"Energy!J14","v":0},{"$f":"Energy!K14","v":0},{"$f":"Energy!L14","v":0},{"$f":"Energy!M14","v":0},{"$f":"Energy!N14","v":0},{"$f":"Energy!O14","v":0},{"$f":"Energy!P14","v":0},{"$f":"Energy!Q14","v":0},{"$f":"Energy!R14","v":0},{"$f":"Energy!S14","v":0},{"$f":"Energy!T14","v":0}]
[null,null,{"$f":"Energy!C15","v":"Endeavour Energy"},null,null,"MVA",null,null,null,{"$f":"Energy!J15","v":0},{"$f":"Energy!K15","v":0},{"$f":"Energy!L15","v":0},{"$f":"Energy!M15","v":0},{"$f":"Energy!N15","v":0},{"$f":"Energy!O15","v":0},{"$f":"Energy!P15","v":0},{"$f":"Energy!Q15","v":0},{"$f":"Energy!R15","v":0},{"$f":"Energy!S15","v":0},{"$f":"Energy!T15","v":0}]
[null,null,{"$f":"Energy!C16","v":"Essential Energy"},null,null,"MVA",null,null,null,{"$f":"Energy!J16","v":0},{"$f":"Energy!K16","v":0},{"$f":"Energy!L16","v":0},{"$f":"Energy!M16","v":0},{"$f":"Energy!N16","v":0},{"$f":"Energy!O16","v":0},{"$f":"Energy!P16","v":0},{"$f":"Energy!Q16","v":0},{"$f":"Energy!R16","v":0},{"$f":"Energy!S16","v":0},{"$f":"Energy!T16","v":0}]
[null,null,"Total",null,null,"MVA",null,null,null,{"$f":"Energy!J17","v":0},{"$f":"Energy!K17","v":0},{"$f":"Energy!L17","v":0},{"$f":"Energy!M17","v":0},{"$f":"Energy!N17","v":0},{"$f":"Energy!O17","v":0},{"$f":"Energy!P17","v":0},{"$f":"Energy!Q17","v":0},{"$f":"Energy!R17","v":0},{"$f":"Energy!S17","v":0},{"$f":"Energy!T17","v":0}]
[]
[null,"Table 4 | Energy data on exemptions",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Total Volumetric Energy Exempted by DNSP"]
[null,null,{"$f":"Apportionment!C74","v":"Ausgrid"},null,null,"GWh",null,null,null,{"$f":"Apportionment!L74","v":0},{"$f":"Apportionment!M74","v":0},{"$f":"Apportionment!N74","v":0},{"$f":"Apportionment!O74","v":0},{"$f":"Apportionment!P74","v":0},{"$f":"Apportionment!Q74","v":0},{"$f":"Apportionment!R74","v":0},{"$f":"Apportionment!S74","v":0},{"$f":"Apportionment!T74","v":0},{"$f":"Apportionment!U74","v":0},{"$f":"Apportionment!V74","v":0}]
[null,null,{"$f":"Apportionment!C75","v":"Endeavour Energy"},null,null,"GWh",null,null,null,{"$f":"Apportionment!L75","v":0},{"$f":"Apportionment!M75","v":0},{"$f":"Apportionment!N75","v":0},{"$f":"Apportionment!O75","v":0},{"$f":"Apportionment!P75","v":0},{"$f":"Apportionment!Q75","v":0},{"$f":"Apportionment!R75","v":0},{"$f":"Apportionment!S75","v":0},{"$f":"Apportionment!T75","v":0},{"$f":"Apportionment!U75","v":0},{"$f":"Apportionment!V75","v":0}]
[null,null,{"$f":"Apportionment!C76","v":"Essential Energy"},null,null,"GWh",null,null,null,{"$f":"Apportionment!L76","v":0},{"$f":"Apportionment!M76","v":0},{"$f":"Apportionment!N76","v":0},{"$f":"Apportionment!O76","v":0},{"$f":"Apportionment!P76","v":0},{"$f":"Apportionment!Q76","v":0},{"$f":"Apportionment!R76","v":0},{"$f":"Apportionment!S76","v":0},{"$f":"Apportionment!T76","v":0},{"$f":"Apportionment!U76","v":0},{"$f":"Apportionment!V76","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,{"$f":"Apportionment!L77","v":0},{"$f":"Apportionment!M77","v":0},{"$f":"Apportionment!N77","v":0},{"$f":"Apportionment!O77","v":0},{"$f":"Apportionment!P77","v":0},{"$f":"Apportionment!Q77","v":0},{"$f":"Apportionment!R77","v":0},{"$f":"Apportionment!S77","v":0},{"$f":"Apportionment!T77","v":0},{"$f":"Apportionment!U77","v":0},{"$f":"Apportionment!V77","v":0}]
[]
[null,null,"Total Peak Demand Exempted by DNSP"]
[null,null,{"$f":"Apportionment!C155","v":"Ausgrid"},null,null,"MVA",null,null,null,{"$f":"Apportionment!L149","v":0},{"$f":"Apportionment!M149","v":0},{"$f":"Apportionment!N149","v":0},{"$f":"Apportionment!O149","v":0},{"$f":"Apportionment!P149","v":0},{"$f":"Apportionment!Q149","v":0},{"$f":"Apportionment!R149","v":0},{"$f":"Apportionment!S149","v":0},{"$f":"Apportionment!T149","v":0},{"$f":"Apportionment!U149","v":0},{"$f":"Apportionment!V149","v":0}]
[null,null,{"$f":"Apportionment!C156","v":"Endeavour Energy"},null,null,"MVA",null,null,null,{"$f":"Apportionment!L150","v":0},{"$f":"Apportionment!M150","v":0},{"$f":"Apportionment!N150","v":0},{"$f":"Apportionment!O150","v":0},{"$f":"Apportionment!P150","v":0},{"$f":"Apportionment!Q150","v":0},{"$f":"Apportionment!R150","v":0},{"$f":"Apportionment!S150","v":0},{"$f":"Apportionment!T150","v":0},{"$f":"Apportionment!U150","v":0},{"$f":"Apportionment!V150","v":0}]
[null,null,{"$f":"Apportionment!C157","v":"Essential Energy"},null,null,"MVA",null,null,null,{"$f":"Apportionment!L151","v":0},{"$f":"Apportionment!M151","v":0},{"$f":"Apportionment!N151","v":0},{"$f":"Apportionment!O151","v":0},{"$f":"Apportionment!P151","v":0},{"$f":"Apportionment!Q151","v":0},{"$f":"Apportionment!R151","v":0},{"$f":"Apportionment!S151","v":0},{"$f":"Apportionment!T151","v":0},{"$f":"Apportionment!U151","v":0},{"$f":"Apportionment!V151","v":0}]
[null,null,"Total",null,null,"MVA",null,null,null,{"$f":"Apportionment!L152","v":0},{"$f":"Apportionment!M152","v":0},{"$f":"Apportionment!N152","v":0},{"$f":"Apportionment!O152","v":0},{"$f":"Apportionment!P152","v":0},{"$f":"Apportionment!Q152","v":0},{"$f":"Apportionment!R152","v":0},{"$f":"Apportionment!S152","v":0},{"$f":"Apportionment!T152","v":0},{"$f":"Apportionment!U152","v":0},{"$f":"Apportionment!V152","v":0}]
[]
[null,"End"]

{"sheet":"Historical outputs","index":4,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | Historical gazetted numbers ",null,null,"Source","Unit",null,null,null,{"$f":"Financial!K7","v":"2022–23"},{"$f":"Financial!L7","v":"2023–24"},{"$f":"Financial!M7","v":"2024–25"},{"$f":"Financial!N7","v":"2025–26"},{"$f":"Financial!O7","v":"2026–27"},{"$f":"Financial!P7","v":"2027–28"},{"$f":"Financial!Q7","v":"2028–29"},{"$f":"Financial!R7","v":"2029–30"},{"$f":"Financial!S7","v":"2030–31"},{"$f":"Financial!T7","v":"2031–32"},null,null,null,"Notes"]
[]
[null,null,"Ausgrid",null,"Previous contribution determinations","$millions"]
[null,null,"Endeavour Energy",null,"Previous contribution determinations","$millions"]
[null,null,"Essential Energy",null,"Previous contribution determinations","$millions"]
[null,null,"Contribution determination amount",null,"Previous contribution determinations","$millions"]
[null,null,"Minimum prudent balance allowance",null,"Previous contribution determinations","$millions"]
[]
[null,"End"]

{"sheet":"Inputs>>","index":5,"n_rows":11,"n_cols":16384,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Contribution model'!G2&\" - \"&'Contribution model'!G3","v":"AER contribution determination model - 2024–25"},null,null,null,"Back to Index"]
[]
[null,"Input sheets"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"General","General inputs including target year"]
[null,null,"Financial","Financial inputs including costs and revenues"]
[null,null,"Energy","Annual volumetric energy and annual peak demand for DNSPs"]
[null,null,"Exemptions","Exemptions for emissions intensive trade exposed and green hydrogen"]
[]
[null,"End",null,null,null,null,null,null,null,null,"End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End","End"]

{"sheet":"General","index":6,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,"Back to Index"]
[]
[1,"Table 1 | General inputs"]
[]
[null,null,"Inputs",null,"Source",null,"Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[null,null,"Target year (t)",null,"SFV",null,"2024–25"]
[null,null,"Energy data year to underpin apportionment for target year",null,"Calculated",null,{"$f":"INDEX(Lookups!I39:I65,MATCH(forecastyear,Lookups!I39:I65,0)-2)","v":"2022–23"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed at t-2"]
[]
[null,null,"Unit for inputs and revenues",null,"AER",null,"$millions"]
[null,null,"Unit for output tables (from revenues)",null,"AER",null,"$millions"]
[null,null,"Unit for consumption totals and outputs",null,"AER",null,"GWh"]
[]
[1,"Input years summary"]
[]
[null,null,"Financials",null,"Actuals","Estimate","Forecast","Forecast","Forecast"]
[null,null,"Year ",null,"t-2","t-1","t","t+1"," t+2"]
[null,null,"Year ending",null,{"$f":"INDEX(Lookups!I39:I65,MATCH(forecastyear,Lookups!I39:I65,0)-2)","v":"2022–23"},{"$f":"INDEX(Lookups!I39:I65,MATCH(forecastyear,Lookups!I39:I65,0)-1)","v":"2023–24"},{"$f":"forecastyear","v":"2024–25"},{"$f":"INDEX(Lookups!I39:I65,MATCH(forecastyear,Lookups!I39:I65,0)+1)","v":"2025–26"},{"$f":"INDEX(Lookups!I39:I65,MATCH(forecastyear,Lookups!I39:I65,0)+2)","v":"2026–27"}]
[]
[]
[null,null,"Energy Data",null,"Actuals"]
[null,null,"Year ",null,"t-2"]
[null,null,"Year ending",null,{"$f":"energy_forecastyear","v":"2022–23"}]
[]
[null,"End"]

{"sheet":"Financial","index":7,"n_rows":67,"n_cols":23,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[null,"Financial"]
[null,"Table 1 | Interest rate ",null,null,"Source","Unit",{"$f":"\"Confidentiality claimed re actuals data (\" &General!$E$17 & \")\"","v":"Confidentiality claimed re actuals data (2022–23)"},{"$f":"\"Confidentiality claimed re forecast data (\" & General!$F$17 & \" and beyond)\"","v":"Confidentiality claimed re forecast data (2023–24 and beyond)"},null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Interest rate",null,"SFV","Per cent","No","No"]
[]
[null,"Table 2 | Revenues",null,null,{"$f":"E3","v":"Source"},"Unit",{"$f":"\"Confidentiality claimed re actuals data (\" &General!$E$17 & \")\"","v":"Confidentiality claimed re actuals data (2022–23)"},{"$f":"\"Confidentiality claimed re forecast data (\" & General!$F$17 & \" and beyond)\"","v":"Confidentiality claimed re forecast data (2023–24 and beyond)"},null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Contribution determinations"]
[null,null,"Contribution determination actual revenue ",null,"SFV","$millions","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Historical amounts prior to forecast year only"]
[]
[null,null,"Revenue (excluding contribution determinations)"]
[null,null,"LTESA - Generation",null,"SFV","$millions","No","No"]
[null,null,"LTESA - LDS & Firming",null,"SFV","$millions","No","No"]
[null,null,"Risk management contracts ",null,"SFV","$millions","No","No"]
[null,null,"Access fees",null,"SFV","$millions","No","No"]
[null,null,"Revenues from investment activities ",null,"SFV","$millions","No","No"]
[null,null,"Other revenue",null,"SFV","$millions","No","No"]
[null,null,"Total ",null,"Calculation","$millions","No","No",null,{"$f":"SUM(J13:J18)","v":0},0,0,{"$f":"SUM(M13:M18)","v":0},{"$f":"SUM(N13:N18)","v":0},0,0,0,0,0,0]
[]
[null,"Table 3 | Expenditure",null,null,{"$f":"E7","v":"Source"},"Unit",{"$f":"\"Confidentiality claimed re actuals data (\" &General!$E$17 & \")\"","v":"Confidentiality claimed re actuals data (2022–23)"},{"$f":"\"Confidentiality claimed re forecast data (\" & General!$F$17 & \" and beyond)\"","v":"Confidentiality claimed re forecast data (2023–24 and beyond)"},null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"LTESA expenditure"]
[null,null,"LTESA - Generation ",null,"SFV","$millions","No","No"]
[null,null,"LTESA - LDS & Firming ",null,"SFV","$millions","No","No"]
[null,null,"Risk management contracts ",null,"SFV","$millions","No","No"]
[null,null,"Total ",null,"Calculation","$millions","No","No",null,{"$f":"SUM(J24:J26)","v":0},{"$f":"SUM(K24:K26)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,"Payments to network operators "]
[null,null,"Payments to network operators",null,"NSW EnCo","$millions","No","No"]
[null,null,"Total",null,"Calculation","$millions","No","No",null,{"$f":"J30","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Administration expenditure"]
[null,null,"AER administration costs",null,"AER","$millions","No","No"]
[null,null,"Consumer Trustee administration costs",null,"Consumer Trustee","$millions","No","No"]
[null,null,"Financial Trustee administration costs",null,"Financial Trustee","$millions","No","No"]
[null,null,"SFV administration costs",null,"SFV","$millions","No","No"]
[null,null,"IPART administration costs",null,"IPART","$millions","No","No"]
[null,null,"EPA administration costs",null,"EPA","$millions","No","No"]
[null,null,"EnCo administration costs",null,"SFV/NSW EnCo","$millions","No","No"]
[null,null,"Total",null,"Calculation","$millions","No","No",null,{"$f":"SUM(J34:J38)","v":0},{"$f":"SUM(K34:K40)","v":0},{"$f":"SUM(L34:L40)","v":0},{"$f":"SUM(M34:M40)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Other costs"]
[null,null,"Access scheme costs (excluding administration costs and community payments)",null,"SFV","$millions","No","No"]
[null,null,"Community payments",null,"SFV","$millions","No","No"]
[null,null,"Interest and finance cost of loans (including additional loans and liquidity facilities)",null,"SFV","$millions","No","No"]
[null,null,"Other costs ",null,"SFV","$millions","No","No"]
[null,null,"Total",null,"Calculation","$millions","No","No",null,{"$f":"SUM(J44:J47)","v":0},0,0,{"$f":"SUM(M44:M47)","v":0},{"$f":"SUM(N44:N47)","v":0},{"$f":"SUM(O44:O47)","v":0},{"$f":"SUM(P44:P47)","v":0},0,{"$f":"SUM(R44:R47)","v":0},{"$f":"SUM(S44:S47)","v":0},{"$f":"SUM(T44:T47)","v":0}]
[]
[null,null,"Total",null,"Calculation","$millions","No","No",null,{"$f":"J48+J41+J31+J27","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Table 4 | Repayable grant and other loans ",null,null,{"$f":"E21","v":"Source"},"Unit",{"$f":"\"Confidentiality claimed re actuals data (\" &General!$E$17 & \")\"","v":"Confidentiality claimed re actuals data (2022–23)"},{"$f":"\"Confidentiality claimed re forecast data (\" & General!$F$17 & \" and beyond)\"","v":"Confidentiality claimed re forecast data (2023–24 and beyond)"},null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Establishment of NSW grant",null,"SFV","$millions","No","No"]
[null,null,"Repayment of grant",null,"SFV","$millions","No","No"]
[null,null,"Need to use grant money (to cover negative liquidity or grant repayments)",null,"Calculation","$millions","No","No",null,{"$f":"IF(J52<forecastyear,MAX(SUM($J$55:J55)-SUM($J$54:J54),SUM(Adjustments!J20:J22)-J10),0)","v":0},{"$f":"IF(K52<forecastyear,MAX(SUM($J$55:K55)-SUM($J$54:K54),SUM(Adjustments!K20:K22)-K10),0)","v":0},{"$f":"IF(L52<forecastyear,MAX(SUM($J$55:L55)-SUM($J$54:L54),SUM(Adjustments!L20:L22)-L10),0)","v":0},{"$f":"IF(M52<forecastyear,MAX(SUM($J$55:M55)-SUM($J$54:M54),SUM(Adjustments!M20:M22)-M10),0)","v":0},{"$f":"IF(N52<forecastyear,MAX(SUM($J$55:N55)-SUM($J$54:N54),SUM(Adjustments!N20:N22)-N10),0)","v":0},{"$f":"IF(O52<forecastyear,MAX(SUM($J$55:O55)-SUM($J$54:O54),SUM(Adjustments!O20:O22)-O10),0)","v":0},{"$f":"IF(P52<forecastyear,MAX(SUM($J$55:P55)-SUM($J$54:P54),SUM(Adjustments!P20:P22)-P10),0)","v":0},{"$f":"IF(Q52<forecastyear,MAX(SUM($J$55:Q55)-SUM($J$54:Q54),SUM(Adjustments!Q20:Q22)-Q10),0)","v":0},{"$f":"IF(R52<forecastyear,MAX(SUM($J$55:R55)-SUM($J$54:R54),SUM(Adjustments!R20:R22)-R10),0)","v":0},{"$f":"IF(S52<forecastyear,MAX(SUM($J$55:S55)-SUM($J$54:S54),SUM(Adjustments!S20:S22)-S10),0)","v":0},{"$f":"IF(T52<forecastyear,MAX(SUM($J$55:T55)-SUM($J$54:T54),SUM(Adjustments!T20:T22)-T10),0)","v":0}]
[]
[null,null,"Use of grant to cover under-recovery (and subsequent recovery of funds)",null,"Calculation","$millions","No","No",null,{"$f":"IF(SUM($J$55:J55)-SUM($J$56:J56)>0,MIN(0,SUM(I$55:$J55)-SUM($J$56:J56)),-(J55-J56))","v":0},{"$f":"IF(SUM($J$55:K55)-SUM($J$56:K56)>0,MIN(0,SUM($J$55:J55)-SUM($J$56:K56)),-(K55-K56))","v":0},{"$f":"IF(SUM($J$55:L55)-SUM($J$56:L56)>0,MIN(0,SUM($J$55:K55)-SUM($J$56:L56)),-(L55-L56))","v":0},{"$f":"IF(SUM($J$55:M55)-SUM($J$56:M56)>0,MIN(0,SUM($J$55:L55)-SUM($J$56:M56)),-(M55-M56))","v":0},{"$f":"IF(SUM($J$55:N55)-SUM($J$56:N56)>0,MIN(0,SUM($J$55:M55)-SUM($J$56:N56)),-(N55-N56))","v":0},{"$f":"IF(SUM($J$55:O55)-SUM($J$56:O56)>0,MIN(0,SUM($J$55:N55)-SUM($J$56:O56)),-(O55-O56))","v":0},{"$f":"IF(SUM($J$55:P55)-SUM($J$56:P56)>0,MIN(0,SUM($J$55:O55)-SUM($J$56:P56)),-(P55-P56))","v":0},{"$f":"IF(SUM($J$55:Q55)-SUM($J$56:Q56)>0,MIN(0,SUM($J$55:P55)-SUM($J$56:Q56)),-(Q55-Q56))","v":0},{"$f":"IF(SUM($J$55:R55)-SUM($J$56:R56)>0,MIN(0,SUM($J$55:Q55)-SUM($J$56:R56)),-(R55-R56))","v":0},{"$f":"IF(SUM($J$55:S55)-SUM($J$56:S56)>0,MIN(0,SUM($J$55:R55)-SUM($J$56:S56)),-(S55-S56))","v":0},{"$f":"IF(SUM($J$55:T55)-SUM($J$56:T56)>0,MIN(0,SUM($J$55:S55)-SUM($J$56:T56)),-(T55-T56))","v":0}]
[null,null,"Use of an additional loan (and subsequent recovery of funds)",null,"SFV","$millions","No","No"]
[null,null,"Total",null,"Calculation","$millions","No","No",null,{"$f":"SUM(J58:J59)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Table 5 | Minimum prudent balance",null,null,{"$f":"E52","v":"Source"},"Unit",{"$f":"\"Confidentiality claimed re actuals data (\" &General!$E$17 & \")\"","v":"Confidentiality claimed re actuals data (2022–23)"},{"$f":"\"Confidentiality claimed re forecast data (\" & General!$F$17 & \" and beyond)\"","v":"Confidentiality claimed re forecast data (2023–24 and beyond)"},null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Adjustment to reach updated minimum prudent balance",null,"SFV","$millions","No","No"]
[null,null,"Minimum prudent balance",null,"Calculation","$millions","No","No",null,{"$f":"J64","v":0},{"$f":"J65+K64","v":0},{"$f":"K65+L64","v":0},0,0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Energy","index":8,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[null,"Energy"]
[null,{"$f":" \"RIN Year \"&energy_forecastyear","v":"RIN Year 2022–23"}]
[]
[null,"Table 1 | Volumetric energy delivered by DNSP - DOPED01",null,null,"Source","Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Ausgrid",null,"DNSPs","GWh"]
[null,null,"Endeavour Energy",null,"DNSPs","GWh"]
[null,null,"Essential Energy",null,"DNSPs","GWh"]
[null,null,"Total ",null,"Calculation","GWh",null,null,null,{"$f":"SUM(J7:J9)","v":0},{"$f":"SUM(K7:K9)","v":0},{"$f":"SUM(L7:L9)","v":0},{"$f":"SUM(M7:M9)","v":0},0,0,0,0,0,0,0]
[]
[null,"Table 2 |  Peak demand by DNSP - DOPSD0201",null,null,{"$f":"E5","v":"Source"},{"$f":"F5","v":"Unit"},null,null,null,{"$f":"J5","v":"2021–22"},"2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,{"$f":"W5","v":"Notes"}]
[]
[null,null,"Ausgrid",null,"DNSPs","MVA"]
[null,null,"Endeavour Energy",null,"DNSPs","MVA"]
[null,null,"Essential Energy",null,"DNSPs","MVA"]
[null,null,"Total ",null,"Calculation","MVA",null,null,null,{"$f":"SUM(J14:J16)","v":0},{"$f":"SUM(K14:K16)","v":0},{"$f":"SUM(L14:L16)","v":0},{"$f":"SUM(M14:M16)","v":0},0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Exemptions","index":9,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Inputs>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | Exemption rates for emissions intensive trade exposed ",null,null,"Source","Unit",null,null,null,"Value",null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,"Per cent of volumetric energy exempted",null,"Regulation","Per cent",null,null,null,0.9]
[]
[null,"Table 2 | Volume of energy delivered to emissions intensive trade exposed entities",null,null,{"$f":"E3","v":"Source"},{"$f":"F3","v":"Unit"},null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide full annual consumption of entities "]
[null,null,"DNSP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eligible for exemptions"]
[null,null,"Ausgrid",null,"SFV","GWh"]
[null,null,"Endeavour Energy",null,"SFV","GWh"]
[null,null,"Essential Energy",null,"SFV","GWh"]
[]
[null,"Table 3 | Exemption rates for green hydrogen producers",null,null,"Source","Unit",null,null,null,"Value",null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,"Reference year"]
[null,null,"2028 or earlier","Percent of volumetric energy exempted","SFV","Per cent",null,null,null,0.9]
[null,null,"2029","Percent of volumetric energy exempted","SFV","Per cent",null,null,null,0.6]
[null,null,"2030","Percent of volumetric energy exempted","SFV","Per cent",null,null,null,0.3]
[null,null,"2031 onwards","Percent of volumetric energy exempted","SFV","Per cent",null,null,null,0]
[null,null,"2028 or earlier","Percent of peak demand exempted","SFV","Per cent",null,null,null,0.9]
[null,null,"2029","Percent of peak demand exempted","SFV","Per cent",null,null,null,0.6]
[null,null,"2030","Percent of peak demand exempted","SFV","Per cent",null,null,null,0.3]
[null,null,"2031 onwards","Percent of peak demand exempted","SFV","Per cent",null,null,null,0]
[]
[]
[null,"Table 4 | Volume of energy delivered to green hydrogen producers",null,null,{"$f":"E14","v":"Source"},{"$f":"F14","v":"Unit"},null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide full annual consumption of entities "]
[null,null,"DNSP","Reference year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eligible for exemptions"]
[null,null,"Ausgrid",2022,"SFV","GWh"]
[null,null,"Ausgrid",2023,"SFV","GWh"]
[null,null,"Ausgrid",2024,"SFV","GWh"]
[null,null,"Ausgrid",2025,"SFV","GWh"]
[null,null,"Ausgrid",2026,"SFV","GWh"]
[null,null,"Ausgrid",2027,"SFV","GWh"]
[null,null,"Ausgrid",2028,"SFV","GWh"]
[null,null,"Ausgrid",2029,"SFV","GWh"]
[null,null,"Ausgrid",2030,"SFV","GWh"]
[null,null,"Endeavour Energy",2022,"SFV","GWh"]
[null,null,"Endeavour Energy",2023,"SFV","GWh"]
[null,null,"Endeavour Energy",2024,"SFV","GWh"]
[null,null,"Endeavour Energy",2025,"SFV","GWh"]
[null,null,"Endeavour Energy",2026,"SFV","GWh"]
[null,null,"Endeavour Energy",2027,"SFV","GWh"]
[null,null,"Endeavour Energy",2028,"SFV","GWh"]
[null,null,"Endeavour Energy",2029,"SFV","GWh"]
[null,null,"Endeavour Energy",2030,"SFV","GWh"]
[null,null,"Essential Energy",2022,"SFV","GWh"]
[null,null,"Essential Energy",2023,"SFV","GWh"]
[null,null,"Essential Energy",2024,"SFV","GWh"]
[null,null,"Essential Energy",2025,"SFV","GWh"]
[null,null,"Essential Energy",2026,"SFV","GWh"]
[null,null,"Essential Energy",2027,"SFV","GWh"]
[null,null,"Essential Energy",2028,"SFV","GWh"]
[null,null,"Essential Energy",2029,"SFV","GWh"]
[null,null,"Essential Energy",2030,"SFV","GWh"]
[]
[null,"Table 5 | Amount of peak demand for green hydrogen producers",null,null,{"$f":"E27","v":"Source"},{"$f":"F27","v":"Unit"},null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide peak demand of eligible entities"]
[null,null,"DNSP","Reference year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(mandatory)"]
[null,null,"Ausgrid",2022,"SFV","MVA"]
[null,null,"Ausgrid",2023,"SFV","MVA"]
[null,null,"Ausgrid",2024,"SFV","MVA"]
[null,null,"Ausgrid",2025,"SFV","MVA"]
[null,null,"Ausgrid",2026,"SFV","MVA"]
[null,null,"Ausgrid",2027,"SFV","MVA"]
[null,null,"Ausgrid",2028,"SFV","MVA"]
[null,null,"Ausgrid",2029,"SFV","MVA"]
[null,null,"Ausgrid",2030,"SFV","MVA"]
[null,null,"Endeavour Energy",2022,"SFV","MVA"]
[null,null,"Endeavour Energy",2023,"SFV","MVA"]
[null,null,"Endeavour Energy",2024,"SFV","MVA"]
[null,null,"Endeavour Energy",2025,"SFV","MVA"]
[null,null,"Endeavour Energy",2026,"SFV","MVA"]
[null,null,"Endeavour Energy",2027,"SFV","MVA"]
[null,null,"Endeavour Energy",2028,"SFV","MVA"]
[null,null,"Endeavour Energy",2029,"SFV","MVA"]
[null,null,"Endeavour Energy",2030,"SFV","MVA"]
[null,null,"Essential Energy",2022,"SFV","MVA"]
[null,null,"Essential Energy",2023,"SFV","MVA"]
[null,null,"Essential Energy",2024,"SFV","MVA"]
[null,null,"Essential Energy",2025,"SFV","MVA"]
[null,null,"Essential Energy",2026,"SFV","MVA"]
[null,null,"Essential Energy",2027,"SFV","MVA"]
[null,null,"Essential Energy",2028,"SFV","MVA"]
[null,null,"Essential Energy",2029,"SFV","MVA"]
[null,null,"Essential Energy",2030,"SFV","MVA"]
[]
[null,"End"]

{"sheet":"Calculations>>","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Contribution model'!G2&\" - \"&'Contribution model'!G3","v":"AER contribution determination model - 2024–25"},null,null,"Back to Index"]
[]
[null,"Calculation sheets"]
[]
[null,null,"Net costs","Calculates target costs and volumetric component "]
[null,null,"Adjustments","Calculates contribution determination amount including true-up and minimum prudent balance allowance"]
[null,null,"Apportionment","Calculates amounts apportioned to DNSPs"]
[]
[null,"End"]

{"sheet":"Net costs","index":11,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Calculations>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | Summary of revenues and expenditure",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Revenue (excluding contribution determinations)"]
[null,null,"LTESA - Generation",null,null,"$millions",null,null,null,null,{"$f":"Financial!K13","v":0},{"$f":"Financial!L13","v":0},{"$f":"Financial!M13","v":0},{"$f":"Financial!N13","v":0},{"$f":"Financial!O13","v":0},{"$f":"Financial!P13","v":0},{"$f":"Financial!Q13","v":0},{"$f":"Financial!R13","v":0},{"$f":"Financial!S13","v":0},{"$f":"Financial!T13","v":0}]
[null,null,"LTESA - LDS & Firming",null,null,"$millions",null,null,null,null,{"$f":"Financial!K14","v":0},{"$f":"Financial!L14","v":0},{"$f":"Financial!M14","v":0},{"$f":"Financial!N14","v":0},{"$f":"Financial!O14","v":0},{"$f":"Financial!P14","v":0},{"$f":"Financial!Q14","v":0},{"$f":"Financial!R14","v":0},{"$f":"Financial!S14","v":0},{"$f":"Financial!T14","v":0}]
[null,null,"Risk management contracts ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K15","v":0},{"$f":"Financial!L15","v":0},{"$f":"Financial!M15","v":0},{"$f":"Financial!N15","v":0},{"$f":"Financial!O15","v":0},{"$f":"Financial!P15","v":0},{"$f":"Financial!Q15","v":0},{"$f":"Financial!R15","v":0},{"$f":"Financial!S15","v":0},{"$f":"Financial!T15","v":0}]
[null,null,"Access fees",null,null,"$millions",null,null,null,null,{"$f":"Financial!K16","v":0},{"$f":"Financial!L16","v":0},{"$f":"Financial!M16","v":0},{"$f":"Financial!N16","v":0},{"$f":"Financial!O16","v":0},{"$f":"Financial!P16","v":0},{"$f":"Financial!Q16","v":0},{"$f":"Financial!R16","v":0},{"$f":"Financial!S16","v":0},{"$f":"Financial!T16","v":0}]
[null,null,"Revenues from investment activities ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K17","v":0},{"$f":"Financial!L17","v":0},{"$f":"Financial!M17","v":0},{"$f":"Financial!N17","v":0},{"$f":"Financial!O17","v":0},{"$f":"Financial!P17","v":0},{"$f":"Financial!Q17","v":0},{"$f":"Financial!R17","v":0},{"$f":"Financial!S17","v":0},{"$f":"Financial!T17","v":0}]
[null,null,"Other revenue",null,null,"$millions",null,null,null,null,{"$f":"Financial!K18","v":0},{"$f":"Financial!L18","v":0},{"$f":"Financial!M18","v":0},{"$f":"Financial!N18","v":0},{"$f":"Financial!O18","v":0},{"$f":"Financial!P18","v":0},{"$f":"Financial!Q18","v":0},{"$f":"Financial!R18","v":0},{"$f":"Financial!S18","v":0},{"$f":"Financial!T18","v":0}]
[null,null,"Total ",null,null,"$millions",null,null,null,null,{"$f":"SUM(K6:K11)","v":0},{"$f":"SUM(L6:L11)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Expenditure (and loan repayments)"]
[null,null,"LTESA - Generation ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K24","v":0},{"$f":"Financial!L24","v":0},{"$f":"Financial!M24","v":0},{"$f":"Financial!N24","v":0},{"$f":"Financial!O24","v":0},{"$f":"Financial!P24","v":0},{"$f":"Financial!Q24","v":0},{"$f":"Financial!R24","v":0},{"$f":"Financial!S24","v":0},{"$f":"Financial!T24","v":0}]
[null,null,"LTESA - LDS & Firming ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K25","v":0},{"$f":"Financial!L25","v":0},{"$f":"Financial!M25","v":0},{"$f":"Financial!N25","v":0},{"$f":"Financial!O25","v":0},{"$f":"Financial!P25","v":0},{"$f":"Financial!Q25","v":0},{"$f":"Financial!R25","v":0},{"$f":"Financial!S25","v":0},{"$f":"Financial!T25","v":0}]
[null,null,"Risk management contracts ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K26","v":0},{"$f":"Financial!L26","v":0},{"$f":"Financial!M26","v":0},{"$f":"Financial!N26","v":0},{"$f":"Financial!O26","v":0},{"$f":"Financial!P26","v":0},{"$f":"Financial!Q26","v":0},{"$f":"Financial!R26","v":0},{"$f":"Financial!S26","v":0},{"$f":"Financial!T26","v":0}]
[null,null,"Payments to network operators",null,null,"$millions",null,null,null,null,{"$f":"Financial!K30","v":0},{"$f":"Financial!L30","v":0},{"$f":"Financial!M30","v":0},{"$f":"Financial!N30","v":0},{"$f":"Financial!O30","v":0},{"$f":"Financial!P30","v":0},{"$f":"Financial!Q30","v":0},{"$f":"Financial!R30","v":0},{"$f":"Financial!S30","v":0},{"$f":"Financial!T30","v":0}]
[null,null,"AER administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K34","v":0},{"$f":"Financial!L34","v":0},{"$f":"Financial!M34","v":0},{"$f":"Financial!N34","v":0},{"$f":"Financial!O34","v":0},{"$f":"Financial!P34","v":0},{"$f":"Financial!Q34","v":0},{"$f":"Financial!R34","v":0},{"$f":"Financial!S34","v":0},{"$f":"Financial!T34","v":0}]
[null,null,"Consumer Trustee administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K35","v":0},{"$f":"Financial!L35","v":0},{"$f":"Financial!M35","v":0},{"$f":"Financial!N35","v":0},{"$f":"Financial!O35","v":0},{"$f":"Financial!P35","v":0},{"$f":"Financial!Q35","v":0},{"$f":"Financial!R35","v":0},{"$f":"Financial!S35","v":0},{"$f":"Financial!T35","v":0}]
[null,null,"Financial Trustee administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K36","v":0},{"$f":"Financial!L36","v":0},{"$f":"Financial!M36","v":0},{"$f":"Financial!N36","v":0},{"$f":"Financial!O36","v":0},{"$f":"Financial!P36","v":0},{"$f":"Financial!Q36","v":0},{"$f":"Financial!R36","v":0},{"$f":"Financial!S36","v":0},{"$f":"Financial!T36","v":0}]
[null,null,"SFV administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K37","v":0},{"$f":"Financial!L37","v":0},{"$f":"Financial!M37","v":0},{"$f":"Financial!N37","v":0},{"$f":"Financial!O37","v":0},{"$f":"Financial!P37","v":0},{"$f":"Financial!Q37","v":0},{"$f":"Financial!R37","v":0},{"$f":"Financial!S37","v":0},{"$f":"Financial!T37","v":0}]
[null,null,"IPART administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K38","v":0},{"$f":"Financial!L38","v":0},{"$f":"Financial!M38","v":0},{"$f":"Financial!N38","v":0},{"$f":"Financial!O38","v":0},{"$f":"Financial!P38","v":0},{"$f":"Financial!Q38","v":0},{"$f":"Financial!R38","v":0},{"$f":"Financial!S38","v":0},{"$f":"Financial!T38","v":0}]
[null,null,"EPA administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K39","v":0},{"$f":"Financial!L39","v":0},{"$f":"Financial!M39","v":0},{"$f":"Financial!N39","v":0},{"$f":"Financial!O39","v":0},{"$f":"Financial!P39","v":0},{"$f":"Financial!Q39","v":0},{"$f":"Financial!R39","v":0},{"$f":"Financial!S39","v":0},{"$f":"Financial!T39","v":0}]
[null,null,"EnCo administration costs",null,null,"$millions",null,null,null,null,{"$f":"Financial!K40","v":0},{"$f":"Financial!L40","v":0},{"$f":"Financial!M40","v":0},{"$f":"Financial!N40","v":0},{"$f":"Financial!O40","v":0},{"$f":"Financial!P40","v":0},{"$f":"Financial!Q40","v":0},{"$f":"Financial!R40","v":0},{"$f":"Financial!S40","v":0},{"$f":"Financial!T40","v":0}]
[null,null,"Access scheme costs (excluding administration costs and community payments)",null,null,"$millions",null,null,null,null,{"$f":"Financial!K44","v":0},{"$f":"Financial!L44","v":0},{"$f":"Financial!M44","v":0},{"$f":"Financial!N44","v":0},{"$f":"Financial!O44","v":0},{"$f":"Financial!P44","v":0},{"$f":"Financial!Q44","v":0},{"$f":"Financial!R44","v":0},{"$f":"Financial!S44","v":0},{"$f":"Financial!T44","v":0}]
[null,null,"Community payments",null,null,"$millions",null,null,null,null,{"$f":"Financial!K45","v":0},{"$f":"Financial!L45","v":0},{"$f":"Financial!M45","v":0},{"$f":"Financial!N45","v":0},{"$f":"Financial!O45","v":0},{"$f":"Financial!P45","v":0},{"$f":"Financial!Q45","v":0},{"$f":"Financial!R45","v":0},{"$f":"Financial!S45","v":0},{"$f":"Financial!T45","v":0}]
[null,null,"Interest and finance cost of loans (including additional loans and liquidity facilities)",null,null,"$millions",null,null,null,null,{"$f":"Financial!K46","v":0},{"$f":"Financial!L46","v":0},{"$f":"Financial!M46","v":0},{"$f":"Financial!N46","v":0},{"$f":"Financial!O46","v":0},{"$f":"Financial!P46","v":0},{"$f":"Financial!Q46","v":0},{"$f":"Financial!R46","v":0},{"$f":"Financial!S46","v":0},{"$f":"Financial!T46","v":0}]
[null,null,"Other costs ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K47","v":0},{"$f":"Financial!L47","v":0},{"$f":"Financial!M47","v":0},{"$f":"Financial!N47","v":0},{"$f":"Financial!O47","v":0},{"$f":"Financial!P47","v":0},{"$f":"Financial!Q47","v":0},{"$f":"Financial!R47","v":0},{"$f":"Financial!S47","v":0},{"$f":"Financial!T47","v":0}]
[null,null,"Total",null,null,"$millions",null,null,null,null,{"$f":"SUM(K15:K29)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Table 2 | Calculation of 3-year rolling average of net costs",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Total revenue (excluding contribution determinations)",null,null,"$millions",null,null,null,null,{"$f":"K12","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Total expenditure (and loan repayments)",null,null,"$millions",null,null,null,null,{"$f":"K30","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Net costs",null,null,"$millions",null,null,null,{"$f":"J35-J34","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"3-year rolling average of net costs",null,null,"$millions",null,null,null,null,{"$f":"AVERAGE(J36:L36)","v":0},0,0,0,0,0,0,0,0,{"$f":"AVERAGE(S36:W36)","v":0}]
[]
[null,"End"]

{"sheet":"Adjustments","index":12,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Calculations>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | True up ",null,null,null,"Unit",null,null,null,{"$f":"Financial!J7","v":"2021–22"},{"$f":"Financial!K7","v":"2022–23"},{"$f":"Financial!L7","v":"2023–24"},{"$f":"Financial!M7","v":"2024–25"},{"$f":"Financial!N7","v":"2025–26"},{"$f":"Financial!O7","v":"2026–27"},{"$f":"Financial!P7","v":"2027–28"},{"$f":"Financial!Q7","v":"2028–29"},{"$f":"Financial!R7","v":"2029–30"},{"$f":"Financial!S7","v":"2030–31"},{"$f":"Financial!T7","v":"2031–32"},null,null,"Notes"]
[]
[null,null,"Contribution determination actual revenue ",null,null,"$millions",null,null,null,null,{"$f":"Financial!K10","v":0},{"$f":"Financial!L10","v":0},{"$f":"Financial!M10","v":0},{"$f":"Financial!N10","v":0},{"$f":"Financial!O10","v":0},{"$f":"Financial!P10","v":0},{"$f":"Financial!Q10","v":0},{"$f":"Financial!R10","v":0},{"$f":"Financial!S10","v":0},{"$f":"Financial!T10","v":0}]
[null,null,"Contribution determination amount (recalculated)",null,null,"$millions",null,null,null,null,{"$f":"SUM(K20:K23)","v":0},{"$f":"SUM(L20:L23)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Net under/over-recovery ",null,null,"$millions",null,null,null,null,{"$f":"IF(K3<forecastyear,K5-K6,K24-K6)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,"Interest rate applicable to balance",null,null,"Per cent",null,null,null,null,{"$f":"Financial!K5","v":0},{"$f":"Financial!L5","v":0},{"$f":"Financial!M5","v":0},{"$f":"Financial!N5","v":0},{"$f":"Financial!O5","v":0},{"$f":"Financial!P5","v":0},{"$f":"Financial!Q5","v":0},{"$f":"Financial!R5","v":0},{"$f":"Financial!S5","v":0},{"$f":"Financial!T5","v":0}]
[]
[null,null,"Opening balance ",null,null,"$millions",null,null,null,null,{"$f":"J16","v":0},0,0,0,0,0,0,0,0,0,null,null,"Balance at start of financial year"]
[null,null,"Interest on opening balance ",null,null,"$millions",null,null,null,null,{"$f":"K11*K9","v":0},0,0,0,0,0,0,0,0,0,null,null,"Opening balance attracts a full year of interest as one input to reach closing balance"]
[null,null,"Net under/over-recovery of revenue excluding true up adjustment (to avoid double counting)",null,null,"$millions",null,null,null,null,{"$f":"K7+K21","v":0},{"$f":"L7+L21","v":0},0,0,0,0,0,0,0,0,null,null,"Under/over recovery during the financial year as a separate input reach closing balance"]
[null,null,"Interest on under/over-recovery ",null,null,"$millions",null,null,null,null,{"$f":"K13*((1+K9)^0.5-1)","v":0},{"$f":"L13*((1+L9)^0.5-1)","v":0},0,0,0,0,0,0,0,0,null,null,"Under/over recovery attracts a half year of interest (as an assumption)"]
[null,null,"Interest on under/over-recovery where grant was used",null,null,"$millions",null,null,null,null,{"$f":"K23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:J23)*(0%)","v":0},{"$f":"L23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:K23)*(0%)","v":0},{"$f":"M23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:L23)*(0%)","v":0},{"$f":"N23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:M23)*(0%)","v":0},{"$f":"O23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:N23)*(0%)","v":0},{"$f":"P23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:O23)*(0%)","v":0},{"$f":"Q23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:P23)*(0%)","v":0},{"$f":"R23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:Q23)*(0%)","v":0},{"$f":"S23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:R23)*(0%)","v":0},{"$f":"T23*((1+0%)^0.5-1)+SUM(Adjustments!$J$23:S23)*(0%)","v":0}]
[null,null,"Closing balance ",null,null,"$millions",null,null,null,null,{"$f":"SUM(K11:K15)","v":0},{"$f":"SUM(L11:L15)","v":0},0,0,0,0,0,0,0,0,null,null,"Balance at end of financial year"]
[]
[null,"Table 2 | Contribution determination calculation",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"3-year rolling average of net costs",null,null,"$millions",null,null,null,null,{"$f":"'Net costs'!K37","v":0},{"$f":"'Net costs'!L37","v":0},{"$f":"'Net costs'!M37","v":0},{"$f":"'Net costs'!N37","v":0},{"$f":"'Net costs'!O37","v":0},{"$f":"'Net costs'!P37","v":0},{"$f":"'Net costs'!Q37","v":0},{"$f":"'Net costs'!R37","v":0},{"$f":"'Net costs'!S37","v":0},{"$f":"'Net costs'!T37","v":0}]
[null,null,"True up adjustment ",null,null,"$millions",null,null,null,null,{"$f":"-K11*(1+K9)^0.5","v":0},0,0,0,0,0,0,0,0,0,null,null,"Adjustment to make closing balance zero with half year of interest because contribution payments are spaced quarterly over the year"]
[null,null,"Minimum prudent balance adjustment",null,null,"$millions",null,null,null,null,{"$f":"Financial!K64","v":0},{"$f":"Financial!L64","v":0},{"$f":"Financial!M64","v":0},{"$f":"Financial!N64","v":0},{"$f":"Financial!O64","v":0},{"$f":"Financial!P64","v":0},{"$f":"Financial!Q64","v":0},{"$f":"Financial!R64","v":0},{"$f":"Financial!S64","v":0},{"$f":"Financial!T64","v":0}]
[null,null,"Adjustment for grants and loans",null,null,"$millions",null,null,null,null,{"$f":"-Financial!K60","v":0},{"$f":"-Financial!L60","v":0},{"$f":"-Financial!M60","v":0},{"$f":"-Financial!N60","v":0},{"$f":"-Financial!O60","v":0},{"$f":"-Financial!P60","v":0},{"$f":"-Financial!Q60","v":0},{"$f":"-Financial!R60","v":0},{"$f":"-Financial!S60","v":0},{"$f":"-Financial!T60","v":0}]
[null,null,"Contribution determination amount",null,null,"$millions",null,null,null,null,{"$f":"IF(K3<forecastyear,'Historical outputs'!J8,SUM(K20:K23))","v":0},{"$f":"IF(L3<forecastyear,'Historical outputs'!K8,SUM(L20:L23))","v":0},{"$f":"IF(M3<forecastyear,'Historical outputs'!L8,SUM(M20:M23))","v":0},{"$f":"IF(N3<forecastyear,'Historical outputs'!M8,SUM(N20:N23))","v":0},{"$f":"IF(O3<forecastyear,'Historical outputs'!N8,SUM(O20:O23))","v":0},{"$f":"IF(P3<forecastyear,'Historical outputs'!O8,SUM(P20:P23))","v":0},{"$f":"IF(Q3<forecastyear,'Historical outputs'!P8,SUM(Q20:Q23))","v":0},{"$f":"IF(R3<forecastyear,'Historical outputs'!Q8,SUM(R20:R23))","v":0},{"$f":"IF(S3<forecastyear,'Historical outputs'!R8,SUM(S20:S23))","v":0},{"$f":"IF(T3<forecastyear,'Historical outputs'!S8,SUM(T20:T23))","v":0}]
[]
[null,"End"]

{"sheet":"Apportionment","index":13,"n_rows":219,"n_cols":23,"rows_kept":219,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Calculations>>'!B1","v":"AER contribution determination model - 2024–25"},null,null,null,null,null,null,null,"Back to Index"]
[]
[null,"Table 1 | Exemptions and apportionment rates for volumetric energy component",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,"Table 1.1 | Overall volumetric energy delivered",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,{"$f":"Energy!J7","v":0},null,{"$f":"Energy!L7","v":0},{"$f":"Energy!M7","v":0},{"$f":"Energy!N7","v":0},{"$f":"Energy!O7","v":0},{"$f":"Energy!P7","v":0},{"$f":"Energy!Q7","v":0},{"$f":"Energy!R7","v":0},{"$f":"Energy!S7","v":0},{"$f":"Energy!T7","v":0}]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,{"$f":"Energy!J8","v":0},{"$f":"Energy!K8","v":0},{"$f":"Energy!L8","v":0},{"$f":"Energy!M8","v":0},{"$f":"Energy!N8","v":0},{"$f":"Energy!O8","v":0},{"$f":"Energy!P8","v":0},{"$f":"Energy!Q8","v":0},{"$f":"Energy!R8","v":0},{"$f":"Energy!S8","v":0},{"$f":"Energy!T8","v":0}]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,{"$f":"Energy!J9","v":0},{"$f":"Energy!K9","v":0},{"$f":"Energy!L9","v":0},{"$f":"Energy!M9","v":0},{"$f":"Energy!N9","v":0},{"$f":"Energy!O9","v":0},{"$f":"Energy!P9","v":0},{"$f":"Energy!Q9","v":0},{"$f":"Energy!R9","v":0},{"$f":"Energy!S9","v":0},{"$f":"Energy!T9","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,{"$f":"Energy!J10","v":0},{"$f":"Energy!K10","v":0},{"$f":"Energy!L10","v":0},{"$f":"Energy!M10","v":0},{"$f":"Energy!N10","v":0},{"$f":"Energy!O10","v":0},{"$f":"Energy!P10","v":0},{"$f":"Energy!Q10","v":0},{"$f":"Energy!R10","v":0},{"$f":"Energy!S10","v":0},{"$f":"Energy!T10","v":0}]
[]
[null,"Table 1.2 | Exempt volumetric energy for emissions intensive trade exposed entities ",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Exemption rate",null,null,null,null,null,"Value"]
[null,null,"Per cent of volumetric energy exempted",null,null,"Per cent",null,null,{"$f":"Exemptions!J5","v":0.9}]
[]
[null,null,"Volumetric energy delivered to exempt entities (actuals data)"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,{"$f":"Exemptions!J10","v":0},{"$f":"Exemptions!K10","v":0},{"$f":"Exemptions!L10","v":0},{"$f":"Exemptions!M10","v":0},{"$f":"Exemptions!N10","v":0},{"$f":"Exemptions!O10","v":0},{"$f":"Exemptions!P10","v":0},{"$f":"Exemptions!Q10","v":0},{"$f":"Exemptions!R10","v":0},{"$f":"Exemptions!S10","v":0},{"$f":"Exemptions!T10","v":0}]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,{"$f":"Exemptions!J11","v":0},{"$f":"Exemptions!K11","v":0},{"$f":"Exemptions!L11","v":0},{"$f":"Exemptions!M11","v":0},{"$f":"Exemptions!N11","v":0},{"$f":"Exemptions!O11","v":0},{"$f":"Exemptions!P11","v":0},{"$f":"Exemptions!Q11","v":0},{"$f":"Exemptions!R11","v":0},{"$f":"Exemptions!S11","v":0},{"$f":"Exemptions!T11","v":0}]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,{"$f":"Exemptions!J12","v":0},{"$f":"Exemptions!K12","v":0},{"$f":"Exemptions!L12","v":0},{"$f":"Exemptions!M12","v":0},{"$f":"Exemptions!N12","v":0},{"$f":"Exemptions!O12","v":0},{"$f":"Exemptions!P12","v":0},{"$f":"Exemptions!Q12","v":0},{"$f":"Exemptions!R12","v":0},{"$f":"Exemptions!S12","v":0},{"$f":"Exemptions!T12","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,{"$f":"SUM(J18:J20)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Amount of volumetric energy exempted (brought forward to current year)"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(M$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(M$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(N$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(N$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(O$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(O$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(P$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(P$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(Q$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(Q$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(R$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(R$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(S$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(S$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(T$3>=forecastyear,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J18:$V18,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(T$3,$J$3:$V$3,0)))*$I$15)","v":0}]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(M$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(M$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(N$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(N$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(O$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(O$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(P$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(P$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(Q$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(Q$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(R$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(R$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(S$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(S$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(T$3>=forecastyear,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J19:$V19,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(T$3,$J$3:$V$3,0)))*$I$15)","v":0}]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(M$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(M$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(N$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(N$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(O$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(O$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(P$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(P$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(Q$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(Q$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(R$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(R$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(S$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(S$3,$J$3:$V$3,0)))*$I$15)","v":0},{"$f":"IF(T$3>=forecastyear,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0))*$I$15,INDEX($J20:$V20,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(T$3,$J$3:$V$3,0)))*$I$15)","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L24:L26)","v":0},{"$f":"SUM(M24:M26)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"Table 1.3 | Exempt volumetric energy for green hydrogen producers",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Exemption rate by reference year",null,null,null,null,null,"Value"]
[null,null,"2028 or earlier","Percent of volumetric energy exempted",null,"Per cent",null,null,{"$f":"Exemptions!J17","v":0.9}]
[null,null,"2029","Percent of volumetric energy exempted",null,"Per cent",null,null,{"$f":"Exemptions!J18","v":0.6}]
[null,null,"2030","Percent of volumetric energy exempted",null,"Per cent",null,null,{"$f":"Exemptions!J19","v":0.3}]
[null,null,"2031 onwards","Percent of volumetric energy exempted",null,"Per cent",null,null,{"$f":"Exemptions!J20","v":0}]
[]
[null,null,"Volumetric energy delivered to exempt entities by reference year"]
[null,null,"Ausgrid","2028 or earlier",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C39,Exemptions!$D$30:$D$56,\"<=2028\")","v":0}]
[null,null,"Ausgrid","2029",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C40,Exemptions!$D$30:$D$56,$D40)","v":0}]
[null,null,"Ausgrid","2030",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C41,Exemptions!$D$30:$D$56,$D41)","v":0}]
[null,null,"Ausgrid","2031 onwards",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C42,Exemptions!$D$30:$D$56,\">=2031\")","v":0}]
[null,null,"Endeavour Energy","2028 or earlier",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C43,Exemptions!$D$30:$D$56,\"<=2028\")","v":0}]
[null,null,"Endeavour Energy","2029",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C44,Exemptions!$D$30:$D$56,$D44)","v":0}]
[null,null,"Endeavour Energy","2030",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C45,Exemptions!$D$30:$D$56,$D45)","v":0}]
[null,null,"Endeavour Energy","2031 onwards",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C46,Exemptions!$D$30:$D$56,\">=2031\")","v":0}]
[null,null,"Essential Energy","2028 or earlier",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C47,Exemptions!$D$30:$D$56,\"<=2028\")","v":0}]
[null,null,"Essential Energy","2029",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C48,Exemptions!$D$30:$D$56,$D48)","v":0}]
[null,null,"Essential Energy","2030",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C49,Exemptions!$D$30:$D$56,$D49)","v":0}]
[null,null,"Essential Energy","2031 onwards",null,"GWh",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$30:J$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$30:K$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$30:L$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$30:M$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$30:N$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$30:O$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$30:P$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$30:Q$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$30:R$56,Exemptions!$C$30:$C$56,\"=\"&$C50,Exemptions!$D$30:$D$56,\">=2031\")","v":0}]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L39:L50)","v":0},{"$f":"SUM(M39:M50)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Volumetric energy delivered to exempt entities"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L39:L42)","v":0},{"$f":"SUM(M39:M42)","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L43:L46)","v":0},{"$f":"SUM(M43:M46)","v":0},0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L47:L50)","v":0},{"$f":"SUM(M47:M50)","v":0},0,0,0,0,0,0,0]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L54:L56)","v":0},{"$f":"SUM(M54:M56)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Amount of volumetric energy exempted"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"SUMPRODUCT(L39:L42,$I$33:$I$36)","v":0},{"$f":"SUMPRODUCT(M39:M42,$I$33:$I$36)","v":0},{"$f":"SUMPRODUCT(N39:N42,$I$33:$I$36)","v":0},0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"SUMPRODUCT(L43:L46,$I$33:$I$36)","v":0},{"$f":"SUMPRODUCT(M43:M46,$I$33:$I$36)","v":0},0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"SUMPRODUCT(L47:L50,$I$33:$I$36)","v":0},{"$f":"SUMPRODUCT(M47:M50,$I$33:$I$36)","v":0},0,0,0,0,0,0,0]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L60:L62)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Table 1.4 | Proportion of exempted volumetric energy attributable to each DNSP",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Amount of volumetric energy delivered (brought forward to current year)"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J7:$V7,0,MATCH(energy_forecastyear,$J$3:$V$3,0)),INDEX($J7:$V7,0,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0))))","v":0},{"$f":"IF(M$3>=forecastyear,INDEX($J7:$V7,0,MATCH(energy_forecastyear,$J$3:$V$3,0)),INDEX($J7:$V7,0,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(M$3,$J$3:$V$3,0))))","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J8:$V8,0,MATCH(energy_forecastyear,$J$3:$V$3,0)),INDEX($J8:$V8,0,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0))))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"IF(L$3>=forecastyear,INDEX($J9:$V9,0,MATCH(energy_forecastyear,$J$3:$V$3,0)),INDEX($J9:$V9,0,MATCH(energy_forecastyear,$J$3:$V$3,0)-(MATCH(forecastyear,$J$3:$V$3,0)-MATCH(L$3,$J$3:$V$3,0))))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"SUM(L68:L70)","v":0},{"$f":"SUM(M68:M70)","v":0},{"$f":"SUM(N68:N70)","v":0},0,0,0,0,0,0]
[]
[null,null,"Amount of volumetric energy exempted (all exemptions)"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"L60+L24","v":0},{"$f":"M60+M24","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"L61+L25","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"L62+L26","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"L63+L27","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Amount of volumetric energy delivered after exemptions"]
[null,null,"Ausgrid",null,null,"GWh",null,null,null,null,null,{"$f":"L68-L74","v":0},{"$f":"M68-M74","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"GWh",null,null,null,null,null,{"$f":"L69-L75","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"GWh",null,null,null,null,null,{"$f":"L70-L76","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"GWh",null,null,null,null,null,{"$f":"L71-L77","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Proportion of total volumetric energy attributable to each DNSP"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L68/L$71,\"\")","v":""},"",{"$f":"IFERROR(N68/N$71,\"\")","v":""},"","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L69/L$71,\"\")","v":""},"","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L70/L$71,\"\")","v":""},"","","","","","","",""]
[null,null,"Total",null,null,"Per cent",null,null,null,null,null,{"$f":"SUM(L86:L88)","v":0},0,{"$f":"SUM(N86:N88)","v":0},0,0,0,0,0,0]
[]
[null,null,"Proportion of volumetric energy attributable to each DNSP after exemptions"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L80/L$83,\"\")","v":""},{"$f":"IFERROR(M80/M$83,\"\")","v":""},"","","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L81/L$83,\"\")","v":""},"","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L82/L$83,\"\")","v":""},"","","","","","","",""]
[null,null,"Total",null,null,"Per cent",null,null,null,null,null,{"$f":"SUM(L92:L94)","v":0},{"$f":"SUM(M92:M94)","v":0},0,0,0,0,0,0,0]
[]
[null,"Table 2 | Exemptions and apportionment rates for peak demand component",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,"Table 2.1 | Overall peak demand",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,{"$f":"Energy!J14","v":0},{"$f":"Energy!K14","v":0},{"$f":"Energy!L14","v":0},{"$f":"Energy!M14","v":0},{"$f":"Energy!N14","v":0},{"$f":"Energy!O14","v":0},{"$f":"Energy!P14","v":0},{"$f":"Energy!Q14","v":0},{"$f":"Energy!R14","v":0},{"$f":"Energy!S14","v":0},{"$f":"Energy!T14","v":0}]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,{"$f":"Energy!J15","v":0},{"$f":"Energy!K15","v":0},{"$f":"Energy!L15","v":0},{"$f":"Energy!M15","v":0},{"$f":"Energy!N15","v":0},{"$f":"Energy!O15","v":0},{"$f":"Energy!P15","v":0},{"$f":"Energy!Q15","v":0},{"$f":"Energy!R15","v":0},{"$f":"Energy!S15","v":0},{"$f":"Energy!T15","v":0}]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,{"$f":"Energy!J16","v":0},{"$f":"Energy!K16","v":0},{"$f":"Energy!L16","v":0},{"$f":"Energy!M16","v":0},{"$f":"Energy!N16","v":0},{"$f":"Energy!O16","v":0},{"$f":"Energy!P16","v":0},{"$f":"Energy!Q16","v":0},{"$f":"Energy!R16","v":0},{"$f":"Energy!S16","v":0},{"$f":"Energy!T16","v":0}]
[null,null,"Total",null,null,"MVA",null,null,null,{"$f":"Energy!J17","v":0},{"$f":"Energy!K17","v":0},{"$f":"Energy!L17","v":0},{"$f":"Energy!M17","v":0},{"$f":"Energy!N17","v":0},{"$f":"Energy!O17","v":0},{"$f":"Energy!P17","v":0},{"$f":"Energy!Q17","v":0},{"$f":"Energy!R17","v":0},{"$f":"Energy!S17","v":0},{"$f":"Energy!T17","v":0}]
[]
[null,"Table 2.2 | Exempt peak demand for green hydrogen producers",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Exemption rate by reference year",null,null,"Unit",null,null,"Value"]
[null,null,"2028 or earlier","Percent of peak demand exempted",null,"Per cent",null,null,{"$f":"Exemptions!J21","v":0.9}]
[null,null,"2029","Percent of peak demand exempted",null,"Per cent",null,null,{"$f":"Exemptions!J22","v":0.6}]
[null,null,"2030","Percent of peak demand exempted",null,"Per cent",null,null,{"$f":"Exemptions!J23","v":0.3}]
[null,null,"2031 onwards","Percent of peak demand exempted",null,"Per cent",null,null,{"$f":"Exemptions!J24","v":0}]
[]
[null,null,"Peak demand for exempt entities by reference year"]
[null,null,"Ausgrid","2028 or earlier",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C115,Exemptions!$D$61:$D$87,\"<=2028\")","v":0}]
[null,null,"Ausgrid","2029",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C116,Exemptions!$D$61:$D$87,$D116)","v":0}]
[null,null,"Ausgrid","2030",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C117,Exemptions!$D$61:$D$87,$D117)","v":0}]
[null,null,"Ausgrid","2031 onwards",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C118,Exemptions!$D$61:$D$87,\">=2031\")","v":0}]
[null,null,"Endeavour Energy","2028 or earlier",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C119,Exemptions!$D$61:$D$87,\"<=2028\")","v":0}]
[null,null,"Endeavour Energy","2029",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C120,Exemptions!$D$61:$D$87,$D120)","v":0}]
[null,null,"Endeavour Energy","2030",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C121,Exemptions!$D$61:$D$87,$D121)","v":0}]
[null,null,"Endeavour Energy","2031 onwards",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C122,Exemptions!$D$61:$D$87,\">=2031\")","v":0}]
[null,null,"Essential Energy","2028 or earlier",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C123,Exemptions!$D$61:$D$87,\"<=2028\")","v":0}]
[null,null,"Essential Energy","2029",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C124,Exemptions!$D$61:$D$87,$D124)","v":0}]
[null,null,"Essential Energy","2030",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C125,Exemptions!$D$61:$D$87,$D125)","v":0}]
[null,null,"Essential Energy","2031 onwards",null,"MVA",null,null,null,null,null,{"$f":"SUMIFS(Exemptions!J$61:J$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!K$61:K$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!L$61:L$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!M$61:M$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!N$61:N$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!O$61:O$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!P$61:P$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!Q$61:Q$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0},{"$f":"SUMIFS(Exemptions!R$61:R$87,Exemptions!$C$61:$C$87,\"=\"&$C126,Exemptions!$D$61:$D$87,\">=2031\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L115:L126)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Peak demand for exempt entities"]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L115:L118)","v":0},{"$f":"SUM(M115:M118)","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L119:L122)","v":0},{"$f":"SUM(M119:M122)","v":0},0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L123:L126)","v":0},{"$f":"SUM(M123:M126)","v":0},0,0,0,0,0,0,0]
[null,null,"Total",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L129:L131)","v":0},{"$f":"SUM(M129:M131)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Amount of peak demand exempted"]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,null,null,{"$f":"SUMPRODUCT(L115:L118,I$109:I$112)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,null,null,{"$f":"SUMPRODUCT(L119:L122,I$109:I$112)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,null,null,{"$f":"SUMPRODUCT(L123:L126,I$109:I$112)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L135:L137)","v":0},{"$f":"SUM(M135:M137)","v":0},{"$f":"SUM(N135:N137)","v":0},0,0,0,0,0,0]
[]
[null,"Table 2.3 | Proportion of exempted peak demand attributable to each DNSP",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Amount of peak demand (brought forward to current year)"]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,null,null,{"$f":"IF(L$97>=forecastyear,INDEX($J101:$V101,0,MATCH(energy_forecastyear,$J$97:$V$97,0)),INDEX($J101:$V101,0,MATCH(energy_forecastyear,$J$97:$V$97,0)-(MATCH(forecastyear,$J$97:$V$97,0)-MATCH(L$97,$J$97:$V$97,0))))","v":0},{"$f":"IF(M$97>=forecastyear,INDEX($J101:$V101,0,MATCH(energy_forecastyear,$J$97:$V$97,0)),INDEX($J101:$V101,0,MATCH(energy_forecastyear,$J$97:$V$97,0)-(MATCH(forecastyear,$J$97:$V$97,0)-MATCH(M$97,$J$97:$V$97,0))))","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,null,null,{"$f":"IF(L$97>=forecastyear,INDEX($J102:$V102,0,MATCH(energy_forecastyear,$J$97:$V$97,0)),INDEX($J102:$V102,0,MATCH(energy_forecastyear,$J$97:$V$97,0)-(MATCH(forecastyear,$J$97:$V$97,0)-MATCH(L$97,$J$97:$V$97,0))))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,null,null,{"$f":"IF(L$97>=forecastyear,INDEX($J103:$V103,0,MATCH(energy_forecastyear,$J$97:$V$97,0)),INDEX($J103:$V103,0,MATCH(energy_forecastyear,$J$97:$V$97,0)-(MATCH(forecastyear,$J$97:$V$97,0)-MATCH(L$97,$J$97:$V$97,0))))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"MVA",null,null,null,null,null,{"$f":"SUM(L143:L145)","v":0},{"$f":"SUM(M143:M145)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"Amount of peak demand exempted"]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,null,null,{"$f":"L135","v":0},{"$f":"M135","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,null,null,{"$f":"L136","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,null,null,{"$f":"L137","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"MVA",null,null,null,null,null,{"$f":"L138","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Amount of peak demand after exemptions"]
[null,null,"Ausgrid",null,null,"MVA",null,null,null,null,null,{"$f":"L143-L149","v":0},{"$f":"M143-M149","v":0},0,0,0,0,0,0,0]
[null,null,"Endeavour Energy",null,null,"MVA",null,null,null,null,null,{"$f":"L144-L150","v":0},0,0,0,0,0,0,0,0]
[null,null,"Essential Energy",null,null,"MVA",null,null,null,null,null,{"$f":"L145-L151","v":0},0,0,0,0,0,0,0,0]
[null,null,"Total",null,null,"MVA",null,null,null,null,null,{"$f":"L146-L152","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Proportion of total peak demand attributable to each DNSP"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L143/L$146,\"\")","v":""},"",{"$f":"IFERROR(N143/N$146,\"\")","v":""},"","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L144/L$146,\"\")","v":""},"","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L145/L$146,\"\")","v":""},"","","","","","","",""]
[null,null,"Total",null,null,"Per cent",null,null,null,null,null,{"$f":"SUM(L161:L163)","v":0},0,{"$f":"SUM(N161:N163)","v":0},0,0,0,0,0,0]
[]
[null,null,"Proportion of peak demand attributable to each DNSP after exemptions"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L155/L$158,\"\")","v":""},{"$f":"IFERROR(M155/M$158,\"\")","v":""},"","","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L156/L$158,\"\")","v":""},"","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,null,{"$f":"IFERROR(L157/L$158,\"\")","v":""},"","","","","","","",""]
[null,null,"Total",null,null,"Per cent",null,null,null,null,null,{"$f":"SUM(L167:L169)","v":0},{"$f":"SUM(M167:M169)","v":0},0,0,0,0,0,0,0]
[]
[null,"Table 3 | Apportionment of contribution determination to DNSPs",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,"Table 3.1 | Split between LTESA (Generation) and other cost categories",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Net costs in current year",null,null,"$millions",null,null,null,null,{"$f":"'Net costs'!K36","v":0},{"$f":"'Net costs'!L36","v":0},{"$f":"'Net costs'!M36","v":0},{"$f":"'Net costs'!N36","v":0},{"$f":"'Net costs'!O36","v":0},{"$f":"'Net costs'!P36","v":0},{"$f":"'Net costs'!Q36","v":0},{"$f":"'Net costs'!R36","v":0},{"$f":"'Net costs'!S36","v":0},{"$f":"'Net costs'!T36","v":0}]
[null,null,"Amount of net costs attributable to LTESAs (Generation)",null,null,"$millions",null,null,null,null,{"$f":"'Net costs'!K15","v":0},{"$f":"'Net costs'!L15","v":0},{"$f":"'Net costs'!M15","v":0},{"$f":"'Net costs'!N15","v":0},{"$f":"'Net costs'!O15","v":0},{"$f":"'Net costs'!P15","v":0},{"$f":"'Net costs'!Q15","v":0},{"$f":"'Net costs'!R15","v":0},{"$f":"'Net costs'!S15","v":0},{"$f":"'Net costs'!T15","v":0}]
[null,null,"Amount of net costs attributable to all other cost categories",null,null,"$millions",null,null,null,null,{"$f":"K176-K177","v":0},{"$f":"L176-L177","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Three year rolling average of proportion attributable to LTESAs (Generation)",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(AVERAGE(J177:L177)/AVERAGE(J176:L176),\"\")","v":""},{"$f":"IFERROR(AVERAGE(K177:M177)/AVERAGE(K176:M176),\"\")","v":""},"","","","","","","",{"$f":"IFERROR(AVERAGE(S177:W177)/AVERAGE(S176:W176),\"\")","v":""}]
[null,null,"Three year rolling average of proportion attributable to all other cost categories",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(AVERAGE(J178:L178)/AVERAGE(J176:L176),\"\")","v":""},{"$f":"IFERROR(AVERAGE(K178:M178)/AVERAGE(K176:M176),\"\")","v":""},"","","","","","","",{"$f":"IFERROR(AVERAGE(S178:W178)/AVERAGE(S176:W176),\"\")","v":""}]
[]
[null,null,"Contribution determination amount",null,null,"$millions",null,null,null,null,{"$f":"Adjustments!K24","v":0},{"$f":"Adjustments!L24","v":0},{"$f":"Adjustments!M24","v":0},{"$f":"Adjustments!N24","v":0},{"$f":"Adjustments!O24","v":0},{"$f":"Adjustments!P24","v":0},{"$f":"Adjustments!Q24","v":0},{"$f":"Adjustments!R24","v":0},{"$f":"Adjustments!S24","v":0},{"$f":"Adjustments!T24","v":0}]
[null,null,"Amount of contribution determination attributable to LTESAs (Generation)",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K183*K180),\"\")","v":""},"","","","","","","","",""]
[null,null,"Amount of contribution determination attributable to all other cost categories",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K181*K183),\"\")","v":""},"","","","","","","","",""]
[]
[null,"Table 3.2 | Apportionment of amounts",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Apportioned amount for LTESAs (generation)"]
[null,null,"Ausgrid",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$184*K92),\"\")","v":""},"","","","","","","","",""]
[null,null,"Endeavour Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$184*K93),\"\")","v":""},"","","","","","","","",""]
[null,null,"Essential Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$184*K94),\"\")","v":""},"","","","","","","","",""]
[null,null,"Total",null,null,"$millions",null,null,null,null,{"$f":"SUM(K190:K192)","v":0},0,0,{"$f":"SUM(N190:N192)","v":0},0,0,0,0,0,0]
[]
[null,null,"Apportioned amount for all other cost categories"]
[null,null,"Ausgrid",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$185*K167),\"\")","v":""},"","","","","","","","",""]
[null,null,"Endeavour Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$185*K168),\"\")","v":""},"","","","","","","","",""]
[null,null,"Essential Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K$185*K169),\"\")","v":""},"","","","","","","","",""]
[null,null,"Total",null,null,"$millions",null,null,null,null,{"$f":"SUM(K196:K198)","v":0},0,0,{"$f":"SUM(N196:N198)","v":0},0,0,0,0,0,0]
[]
[null,null,"Apportioned contribution determination amounts"]
[null,null,"Ausgrid",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K190+K196),\"\")","v":""},"","","","","","","","",""]
[null,null,"Endeavour Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K191+K197),\"\")","v":""},"","","","","","","","",""]
[null,null,"Essential Energy",null,null,"$millions",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K192+K198),\"\")","v":""},"","","","","","","","",""]
[null,null,"Total",null,null,"$millions",null,null,null,null,{"$f":"SUM(K202:K204)","v":0},0,0,{"$f":"SUM(N202:N204)","v":0},0,0,0,0,0,0]
[]
[null,"Table 3.3 | Proportion of amount for each DNSP linked to LTESAs (generation)",null,null,null,"Unit",null,null,null,"2021–22","2022–23","2023–24","2024–25","2025–26","2026–27","2027–28","2028–29","2029–30","2030–31","2031–32",null,null,"Notes"]
[]
[null,null,"Before exemptions"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",(K86*K$184)/(K86*K$184+K161*K$185)),\"\")","v":""},"","","","","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",(K87*K$184)/(K87*K$184+K162*K$185)),\"\")","v":""},"","","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",(K88*K$184)/(K88*K$184+K163*K$185)),\"\")","v":""},"","","","","","","","",""]
[]
[null,null,"After exemptions"]
[null,null,"Ausgrid",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K190/K202),\"\")","v":""},"","","","","","","","",""]
[null,null,"Endeavour Energy",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K191/K203),\"\")","v":""},"","","","","","","","",""]
[null,null,"Essential Energy",null,null,"Per cent",null,null,null,null,{"$f":"IFERROR(IF(K$172<forecastyear,\"\",K192/K204),\"\")","v":""},"","","","","","","","",""]
[]
[null,"End"]

{"sheet":"Lookups","index":14,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Contribution model'!G2&\" - \"&'Contribution model'!G3","v":"AER contribution determination model - 2024–25"},null,null,null,null,"Back to Index"]
[null,"Lookups"]
[null,0]
[]
[null,"Unit Denominations"]
[]
[null,null,{"$f":"B5","v":"Unit Denominations"},"Source",null,null,"Ref"]
[null,null,"Cents","AER",null,null,"cents"]
[null,null,"Dollars","AER",null,null,"$dollars"]
[null,null,"Thousands","AER",null,null,"$000"]
[null,null,"Millions","AER",null,null,"$millions"]
[]
[null,null,"Percent","AER",null,null,"Per cent"]
[null,null,"Unit","AER",null,null,"unit"]
[null,null,"Number","AER",null,null,"number"]
[null,null,"Factor","AER",null,null,"factor"]
[]
[null,null,"Kilowatt hours","AER",null,null,"kWh"]
[null,null,"Megawatt hours","AER",null,null,"MWh"]
[null,null,"Gigawatt hours","AER",null,null,"GWh"]
[null,null,"Kilowatts","AER",null,null,"kW"]
[null,null,"Kilovolt-amperes","AER",null,null,"kVA"]
[null,null,"Megavolt-amperes","AER",null,null,"MVA"]
[null,null,"Lamp Watts","AER",null,null,"LmpWtts"]
[null,null,"Daily charges","AER",null,null,"day"]
[null,null,"Monthly charges","AER",null,null,"month"]
[null,null,"Low season charges","AER",null,null,"lowsn"]
[null,null,"High season charges","AER",null,null,"highsn"]
[null,null,"Season charges",null,null,null,"season"]
[null,null,"Annual charges","AER",null,null,"year"]
[null,null,"Dollars per Kilowatt hours","AER",null,null,"$/kWh"]
[]
[null,null,"Actual","AER",null,null,"Actual"]
[null,null,"Estimate","AER",null,null,"Estimate"]
[]
[null,"Years"]
[]
[null,null,{"$f":"B36","v":"Years"},"Source",null,null,"Calendar Year",null,"Financial Year"]
[null,null,"2016-06-01","AER",null,null,2016,null,{"$f":"G39-1&\"–\"&RIGHT(G39,2)","v":"2015–16"}]
[null,null,"2017-06-01","AER",null,null,2017,null,{"$f":"G40-1&\"–\"&RIGHT(G40,2)","v":"2016–17"}]
[null,null,"2018-06-01","AER",null,null,2018,null,{"$f":"G41-1&\"–\"&RIGHT(G41,2)","v":"2017–18"}]
[null,null,"2019-06-01","AER",null,null,2019,null,{"$f":"G42-1&\"–\"&RIGHT(G42,2)","v":"2018–19"}]
[null,null,"2020-06-01","AER",null,null,2020,null,{"$f":"G43-1&\"–\"&RIGHT(G43,2)","v":"2019–20"}]
[null,null,"2021-06-01","AER",null,null,2021,null,"2020–21"]
[null,null,"2022-06-01","AER",null,null,2022,null,"2021–22"]
[null,null,"2023-06-01","AER",null,null,2023,null,"2022–23"]
[null,null,"2024-06-01","AER",null,null,2024,null,"2023–24"]
[null,null,"2025-06-01","AER",null,null,2025,null,"2024–25"]
[null,null,"2026-06-01","AER",null,null,2026,null,"2025–26"]
[null,null,"2027-06-01","AER",null,null,2027,null,"2026–27"]
[null,null,"2028-06-01","AER",null,null,2028,null,"2027–28"]
[null,null,"2029-06-01","AER",null,null,2029,null,"2028–29"]
[null,null,"2030-06-01","AER",null,null,2030,null,"2029–30"]
[null,null,"2031-06-01","AER",null,null,2031,null,"2030–31"]
[null,null,"2032-06-01","AER",null,null,2032,null,"2031–32"]
[null,null,"2033-06-01","AER",null,null,2033,null,"2032–33"]
[null,null,"2034-06-01","AER",null,null,2034,null,"2033–34"]
[null,null,"2035-06-01","AER",null,null,2035,null,"2034–35"]
[null,null,"2036-06-01","AER",null,null,2036,null,"2035–36"]
[null,null,"2037-06-01","AER",null,null,2037,null,"2036–37"]
[null,null,"2038-06-01","AER",null,null,2038,null,"2037–38"]
[null,null,"2039-06-01","AER",null,null,2039,null,"2038–39"]
[null,null,"2040-06-01","AER",null,null,2040,null,{"$f":"G63-1&\"–\"&RIGHT(G63,2)","v":"2039–40"}]
[null,null,"2041-06-01","AER",null,null,2041,null,{"$f":"G64-1&\"–\"&RIGHT(G64,2)","v":"2040–41"}]
[null,null,"2042-06-01","AER",null,null,2042,null,{"$f":"G65-1&\"–\"&RIGHT(G65,2)","v":"2041–42"}]
[]
[]
[null,"End"]

{"sheet":"Glossary","index":15,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[16,3,16,8],[7,3,7,8],[14,3,14,8],[10,3,10,8],[6,3,6,8],[8,3,8,8],[9,3,9,8],[12,3,12,8],[13,3,13,8],[11,3,11,8],[15,3,15,8],[22,3,22,8],[29,3,29,8],[30,3,30,8],[23,3,23,8],[24,3,24,8],[25,3,25,8],[26,3,26,8],[27,3,27,8],[28,3,28,8],[17,3,17,8],[18,3,18,8],[19,3,19,8],[20,3,20,8],[21,3,21,8]]}
[null,{"$f":"'Contribution model'!G2&\" - \"&'Contribution model'!G3","v":"AER contribution determination model - 2024–25"},null,null,null,null,"Back to Index"]
[null,"Glossary"]
[null,0]
[]
[null,"Glossary"]
[]
[null,null,"Term","Definition or extended form"]
[null,null,"Administration Expenditure","The costs of administering the fund."]
[null,null,"AER","Australian Energy Regulator"]
[null,null,"Consumer Trustee","A person or body authorised under section 60 of the EII Act to exercise the functions of the Consumer Trustee. The Consumer Trustee is required to act independently and in the long-term financial interests of NSW electricity consumers. AEMO Services Ltd has been appointed to undertake this role."]
[null,null,"Contribution Determination","The annual contribution determination to be made by the AER as Regulator under section 56 of the EII Act. "]
[null,null,"DNSP","Distribution Network Service Provider"]
[null,null,"Financial Trustee","A person or body authorised under section 61 of the EII Act to exercise the functions of the Financial Trustee. "]
[null,null,"IPART","NSW Independent Pricing and Regulatory Tribunal"]
[null,null,"LTESA","Long-term Energy Service Agreements"]
[null,null,"Payments to Network Operators ","Costs associated from operating the REZ network infrastructure"]
[null,null,"NSW EnCo","Energy Corporation of NSW"]
[null,null,"SFV","Scheme Financial Vehicle - A person or body authorised under section 62 of the EII Act to exercise the functions of the Scheme Financial Vehicle."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"End"]