{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Instructions","VerCon","Assumptions","Calculations","Fee Schedule - Annual","Fee Schedule - QTR","Table"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1937,"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":"Cover","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]

{"sheet":"Instructions","index":1,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,0,6,2],[58,1,58,13],[52,1,52,13],[53,1,53,13]]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":2},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Instructions"}]
[null,"Instructions sheet"]
[]
[]
[{"$f":"Table!B25","v":"All Checks are OK"}]
[]
[]
[{"$f":"ROUNDDOWN(MAX($A$7:OFFSET(A9,-One,0),$A$2*Sht)+Sxn,0)","v":201},"Model Diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"ROUNDDOWN(MAX($A$7:OFFSET(A27,-One,0),$A$2*Sht)+Sxn,0)","v":202},"Key to model colour scheme"]
[]
[{"$f":"MAX(A$2:OFFSET($A29,-One,0))+Sbsxn","v":202.01},"Cell Formatting"]
[]
[]
[null,null,null,"Project Inputs that can be adjusted by the Proponents."]
[null,null,null,"Project Inputs that can be adjusted by the Proponents to estimate adjustments to the Access Fee (Variation Events under the Access Fee Determination)."]
[null,null,null,"Fixed Technical Inputs - should not be adjusted."]
[null,null,null,"Model Inputs - should not be adjusted. "]
[null,null,null,"Cells with formulas that simply 'call-up' data from the same sheet of the model, and that don't perform operations on that data. "]
[null,null,null,"Cells with formulas that simply 'call-up' data from other parts of the model, and that don't perform operations on that data. "]
[null,null,null,"Cells surrounded by formula or inputs that have been deliberately left blank and where no assumptions should be added."]
[]
[{"$f":"MAX(A$2:OFFSET($A40,-One,0))+Sbsxn","v":202.01999999999998},"Sheet Tab Formatting"]
[]
[null,null,null,"Tabs in dark grey are for information purposes only."]
[null,null,null,"Worksheets containing inputs."]
[null,null,null,"Calculation Sheets."]
[null,null,null,"Output Sheets."]
[null,null,null,"Static table sheets. "]
[]
[{"$f":"ROUNDDOWN(MAX($A$9:OFFSET(A48,-One,0),$A$2*Sht)+Sxn,0)","v":203},"General Guide to the Model"]
[]
[{"$f":"MAX(A$2:OFFSET($A50,-One,0))+Sbsxn","v":203.01},"General Points"]
[]
["►","All figures within the model are in AUD$m unless otherwise stated."]
["►","All inputs should be entered as positive numbers, unless otherwise indicated.  For example, costs should be entered as 100 rather than -100, and the model will do the conversion automatically."]
["►","The model will also clearly indicate whether the inputs should be entered in REAL terms (ie excluding inflation) or NOMINAL terms (ie including inflation). Where inputs are entered in real terms, the model will also include appropriate inflation assumptions so that they can be converted into Real terms."]
[]
[{"$f":"MAX(A$2:OFFSET($A56,-One,0))+Sbsxn","v":203.01999999999998},"Checks"]
[]
["►","The check sheets contains all built-in tolerance and logical checks for the model."]
["►","The status of the checks in the model is displayed at the top of the worksheets. Ideally, the model should always say \"All checks are OK\".  If not, you should navigate to the Table sheet using the button at the top of each worksheet, and scroll through the sheet to identify which parts of the model is causing the error. "]
["►","Wherever possible, the check error message will be tailored to inform you of the nature of the problem.  "]
[]
["END"]

{"sheet":"VerCon","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,0,6,2]]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":3},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"VerCon"}]
[]
[]
[]
[{"$f":"Table!B25","v":"All Checks are OK"}]
[]
[]
[null,null,"Version no","Date","Change Made","Source of Change","Output 1","Output 2","Output 3","Output 4"]
[null,{"$f":"MAX(OFFSET(B10,1,0,100000,1))+1","v":1},"[DRAFT VERSION]",{"$f":"NOW()","v":"2024-05-22T09:45:24.280"},null,null,"Use these cells to link to key model outputs"]
[null,null,"<< insert row above for new file versions to be logged"]
[]
["END"]

{"sheet":"Assumptions","index":3,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[[6,0,6,2]]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":4},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Assumptions"}]
[null,"Key assumptions and outputs"]
[]
[]
[{"$f":"Table!B25","v":"All Checks are OK"}]
[]
[]
[{"$f":"ROUNDDOWN(MAX($A$8:OFFSET(A9,-One,0),$A$2*Sht)+Sxn,0)","v":401},"Assumptions"]
[]
[{"$f":"MAX(A$2:OFFSET($A11,-One,0))+Sbsxn","v":401.01},"Model"]
[]
[null,"Model name","text","SW REZ - DRAFT - Access Fee Calculator",null,null,null,null,null,null,null,null,null,"[MdlTtl]"]
[null,"File name","text",{"$f":"IF(ISERROR(LEFT(RIGHT(CELL(\"filename\",$A$7),LEN(CELL(\"filename\",$A$7))-FIND(\"[\",CELL(\"filename\",$A$7))),FIND(\"]\",RIGHT(CELL(\"filename\",$A$7),LEN(CELL(\"filename\",$A$7))-FIND(\"[\",CELL(\"filename\",$A$7))))-1)),\"Please save the model\",LEFT(RIGHT(CELL(\"filename\",$A$7),LEN(CELL(\"filename\",$A$7))-FIND(\"[\",CELL(\"filename\",$A$7))),FIND(\"]\",RIGHT(CELL(\"filename\",$A$7),LEN(CELL(\"filename\",$A$7))-FIND(\"[\",CELL(\"filename\",$A$7))))-1))","v":"SW REZ - DRAFT - Access Fee Calculator.xlsm"},null,null,null,null,null,null,null,null,null,"[MdlFileName]"]
[null,"Model start date","date","2026-01-01",null,null,null,null,null,null,null,null,null,"[Start]"]
[null,"Escalation Base date","date","2024-07-01",null,null,null,null,null,null,null,null,null,"Implicit Model assumption; do not change"]
[null,"Financial year end (month number)","#",6,null,null,null,null,null,null,null,null,null,"Implicit Model assumption; do not change"]
[]
[null,"Scenario number","#",1,1,2,null,null,null,null,null,null,null,"◀  Adjust between base case and variation case"]
[null,"Scenario name","text",{"$f":"+IF(ISBLANK(INDEX(E20:F20,,$D$19)),E20,INDEX(E20:F20,,$D$19))","v":"Base Case"},"Base Case","Variation Case",null,null,null,null,null,null,null,"Implicit Model assumption; do not change"]
[]
[{"$f":"MAX(A$2:OFFSET($A22,-One,0))+Sbsxn","v":401.02},"Project"]
[]
[null,"Project name","text",{"$f":"+IF(ISBLANK(INDEX(E24:F24,,$D$19)),E24,INDEX(E24:F24,,$D$19))","v":"[Insert Project Name]"},"[Insert Project Name]","[Insert Project Name]",null,null,null,null,null,null,null,"◀  Populate with Project Name."]
[null,"Project type","text",{"$f":"+IF(ISBLANK(INDEX(E25:F25,,$D$19)),E25,INDEX(E25:F25,,$D$19))","v":"[Spare]"},"[Spare]","[Spare]",null,null,null,null,null,null,null,"◀  Select project type e.g. Wind Farm, Solar Farm, Storage etc., select from dropdown."]
[]
[null,"Maximum Capacity: BID VARIABLE","MW",{"$f":"+IF(ISBLANK(INDEX(E27:F27,,$D$19)),E27,INDEX(E27:F27,,$D$19))","v":500},500,{"$f":"F63","v":500},null,null,null,null,null,null,null,"◀  REZ project specific input provided by Proponent. The Access Right Maximum Capacity is per connection point."]
[null,"First Commissioning Date: BID VARIABLE","date",{"$f":"+IF(ISBLANK(INDEX(E28:F28,,$D$19)),E28,INDEX(E28:F28,,$D$19))","v":"2027-05-01"},"2027-05-01","2026-05-01",null,null,null,null,null,null,null,"As defined in the Access PDA. Projects bid a Target First Commissioning Date, which is a milestone in the Access PDA"]
[]
[null,"Connection Term","years",{"$f":"+IF(ISBLANK(INDEX(E30:F30,,$D$19)),E30,INDEX(E30:F30,,$D$19))","v":15},15,15,null,null,null,null,null,null,null,"◀  Placeholder assumption of 15 years. Note, this should be the expected term of connection into the REZ"]
[]
[{"$f":"MAX(A$2:OFFSET($A32,-One,0))+Sbsxn","v":401.03},"Dates and General"]
[]
[null,"Electrification of Dinawan substation date","date",{"$f":"+IF(ISBLANK(INDEX(E34:F34,,$D$19)),E34,INDEX(E34:F34,,$D$19))","v":"2026-05-01"},"2026-05-01","2026-05-01",null,null,null,null,null,null,null,"Current estimate for the date of the electrification of the Dinawan substation, this is anticipated to be 1 May 2026 (as at the commencement of the Tender, see the SW REZ Access Rights Supplement for more information)"]
[null,"Years between Dinawan electrification and Scheme End","years",{"$f":"+IF(ISBLANK(INDEX(E35:F35,,$D$19)),E35,INDEX(E35:F35,,$D$19))","v":15},15,{"$f":"IF(ISBLANK(F73),E35,(F73-F34)/DiY)","v":15.008219178082191},null,null,null,null,null,null,null,"Implicit Model assumption; do not change"]
[null,"Scheme End date","date",{"$f":"+IF(ISBLANK(INDEX(E36:F36,,$D$19)),E36,INDEX(E36:F36,,$D$19))","v":"2041-04-30"},{"$f":"EOMONTH(E34,E35*MiY-1)","v":"2041-04-30"},{"$f":"F73","v":"2041-04-30"},null,null,null,null,null,null,null,"The Access Scheme ends 15 years after the date of the electrification of the Dinawan substation, as notified by the Infrastructure Planner"]
[]
[null,"Network Readiness Date","date",{"$f":"+IF(ISBLANK(INDEX(E38:F38,,$D$19)),E38,INDEX(E38:F38,,$D$19))","v":"2027-05-01"},"2027-05-01","2027-05-01",null,null,null,null,null,null,null,"As defined in the Access Payment Deed"]
[]
[null,"Access Fee Payment Start Date","date",{"$f":"MIN(D28,D38)","v":"2027-05-01"},null,null,null,null,null,null,null,null,null,"Note, payment start date is the earlier of the Project's First Commissioning OR the Network Readiness Date. Access Fees become payable from this point onward. "]
[null,"Access Fee Payment End Date","date",{"$f":"IF(OR(D40=0,D30=0),0,MIN((EOMONTH(D40,D30*MiY-1)),D36))","v":"2041-04-30"},null,null,null,null,null,null,null,null,null,"Earlier of a) the Access Fee Payment Date + Payment Term, and b) Scheme End Date"]
[]
[null,"Fixed indexation","% p.a.",{"$f":"+IF(ISBLANK(INDEX(E43:F43,,$D$19)),E43,INDEX(E43:F43,,$D$19))","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,null,null,null,null,null,null,null,"SW REZ Access Fee Guidelines (May 2024), SW REZ draft Access Fee Calculator Assumptions (Appendix)"]
[null,"GST Applicable","text",{"$f":"+IF(ISBLANK(INDEX(E44:F44,,$D$19)),E44,INDEX(E44:F44,,$D$19))","v":1},1,1,null,null,null,null,null,null,null,"Access Fees set out in the draft Determination Access Fee Schedule are exclusive of GST.  If GST is payable, or notionally payable, on a supply made in connection with the draft Determination, then the payment, or notional payment, of GST will be in accordance with the Access Payment Deed. The draft Access Payment Deed currently assumes GST is payable."]
[null,"GST","% p.a.",{"$f":"IF($D$44=Table!$K$72,Assumptions!E45, 0)","v":0.1},0.1,0.1,null,null,null,null,null,null,null,"Access Fees set out in the draft Determination Access Fee Schedule are exclusive of GST.  If GST is payable, or notionally payable, on a supply made in connection with the draft Determination, then the payment, or notional payment, of GST will be in accordance with the Access Payment Deed. The draft Access Payment Deed currently assumes GST is payable."]
[]
[{"$f":"MAX(A$2:OFFSET($A47,-One,0))+Sbsxn","v":401.03999999999996},"SW Access Fee"]
[null,{"$f":"\"Note: Access Fee in nominal AUD$m excl GST as at \"&TEXT($D$16, \"d mmm yyyy\")&\", unless noted otherwise\"","v":"Note: Access Fee in nominal AUD$m excl GST as at 1 Jul 2024, unless noted otherwise"}]
[]
[null,{"$f":"\"Access Fee components (in real \"&Units&\")\"","v":"Access Fee components (in real AUD$m)"}]
[null,"Community and Employment Fee (C&E Fee)","AUD$'000/MW p.a.",{"$f":"+IF(ISBLANK(INDEX(E51:F51,,$D$19)),E51,INDEX(E51:F51,,$D$19))","v":2.2999999999999998},2.2999999999999998,{"$f":"F66","v":2.2999999999999998},null,null,null,null,null,null,null,"SW REZ Access Fee Guidelines (May 2024), SW REZ draft Access Fee Calculator Assumptions (Appendix)"]
[null,"SW REZ Administration Fee","AUD$'000/MW p.a.",{"$f":"+IF(ISBLANK(INDEX(E52:F52,,$D$19)),E52,INDEX(E52:F52,,$D$19))","v":0.69099999999999995},0.69099999999999995,{"$f":"F67","v":0.69099999999999995},null,null,null,null,null,null,null,"SW REZ Access Fee Guidelines (May 2024), SW REZ draft Access Fee Calculator Assumptions (Appendix)"]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$'000/MW p.a.",{"$f":"+IF(ISBLANK(INDEX(E53:F53,,$D$19)),E53,INDEX(E53:F53,,$D$19))","v":1.0090000000000003},1.0090000000000003,{"$f":"F68","v":1.0090000000000003},null,null,null,null,null,null,null,"SW REZ Access Fee Guidelines (May 2024), SW REZ draft Access Fee Calculator Assumptions (Appendix)"]
[null,"Access Fee - Annual cost per MW","AUD$'000/MW p.a.",{"$f":"SUM(D51:D53)","v":4},{"$f":"SUM(E51:E53)","v":4},{"$f":"SUM(F51:F53)","v":4}]
[]
[{"$f":"ROUNDDOWN(MAX($A$8:OFFSET(A56,-One,0),$A$2*Sht)+Sxn,0)","v":402},"Variation Sensitivity Assumptions"]
[null,{"$f":"\"Note: Access Fee in nominal AUD$m excl GST as at \"&TEXT($D$16, \"d mmm yyyy\")&\", unless noted otherwise\"","v":"Note: Access Fee in nominal AUD$m excl GST as at 1 Jul 2024, unless noted otherwise"}]
[null,"Note: Threshold Change per the Draft Access Fee Determination (April 2024)"]
[]
[{"$f":"MAX(A$2:OFFSET($A60,-One,0))+Sbsxn","v":402.01},"Approved Maximum Capacity Change"]
[]
[null,"Maximum Capacity Change",null,"Sensitivity\n(+/-) %","Access Fee","Applicable Variation Figure",null,"Test Variation Case",null,"Threshold Change",null,"Calculated Change"]
[null,"Maximum Capacity","MW",0,{"$f":"E27","v":500},{"$f":"H63","v":500},null,{"$f":"E63*(1+D63)","v":500},null,null,null,null,null,"◀  Placeholder assumption of 0%. Input alternative Project Maximum Capacity for the variation case"]
[]
[null,"Access Fee","AUD$'000/MW p.a.",null,{"$f":"E54","v":4},{"$f":"(1+MAX(L65,J65))*(E65)","v":4},null,{"$f":"$E65*(1+$D$63)","v":4},null,-0.05,null,{"$f":"IF(E65<=0,0,H65/E65-1)","v":0}]
[null,"Community and Employment Fee (C&E Fee)","AUD$'000/MW p.a.",null,{"$f":"E51","v":2.2999999999999998},{"$f":"(1+MAX(L66,J66))*(E66)","v":2.2999999999999998},null,{"$f":"$E66*(1+$D$63)","v":2.2999999999999998},null,{"$f":"J65","v":-0.05},null,{"$f":"IF(E66<=0,0,H66/E66-1)","v":0}]
[null,"SW REZ Administration Fee","AUD$'000/MW p.a.",null,{"$f":"E52","v":0.69099999999999995},{"$f":"(1+MAX(L67,J67))*(E67)","v":0.69099999999999995},null,{"$f":"$E67*(1+$D$63)","v":0.69099999999999995},null,{"$f":"J65","v":-0.05},null,{"$f":"IF(E67<=0,0,H67/E67-1)","v":0}]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$'000/MW p.a.",null,{"$f":"E53","v":1.0090000000000003},{"$f":"(1+MAX(L68,J68))*(E68)","v":1.0090000000000003},null,{"$f":"$E68*(1+$D$63)","v":1.0090000000000003},null,{"$f":"J65","v":-0.05},null,{"$f":"IF(E68<=0,0,H68/E68-1)","v":0}]
[]
[{"$f":"MAX(A$2:OFFSET($A70,-One,0))+Sbsxn","v":402.02},"Scheme Term Extension"]
[]
[null,"Scheme Term Extension",null,"Sensitivity\n(+/-) %","Base Case","Applicable Variation Figure"]
[null,"Scheme, end date","date",null,{"$f":"E36","v":"2041-04-30"},"2041-04-30",null,null,null,null,null,null,null,"◀  Placeholder assumption of 30 April 2041. In the event of a Scheme Term Extension, if a Project wishes to continue it's Access Right, the Payment Term will need to be extended to match the term of the Scheme Term Extension."]
[]
["END"]

{"sheet":"Calculations","index":4,"n_rows":91,"n_cols":110,"rows_kept":91,"cut":false,"hidden":false,"merged":[[5,0,5,2],[4,3,4,5]]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"},null,null,null,null,null,null,null,null,"Period Start",{"$f":"Start","v":"2026-01-01"},{"$f":"K2+1","v":"2026-04-01"},"2026-07-01","2026-10-01","2027-01-01","2027-04-01","2027-07-01","2027-10-01","2028-01-01","2028-04-01","2028-07-01","2028-10-01","2029-01-01","2029-04-01","2029-07-01","2029-10-01","2030-01-01","2030-04-01","2030-07-01","2030-10-01","2031-01-01","2031-04-01","2031-07-01","2031-10-01","2032-01-01","2032-04-01","2032-07-01","2032-10-01","2033-01-01","2033-04-01","2033-07-01","2033-10-01","2034-01-01","2034-04-01","2034-07-01","2034-10-01","2035-01-01","2035-04-01","2035-07-01","2035-10-01","2036-01-01","2036-04-01","2036-07-01","2036-10-01","2037-01-01","2037-04-01","2037-07-01","2037-10-01","2038-01-01","2038-04-01","2038-07-01","2038-10-01","2039-01-01","2039-04-01","2039-07-01","2039-10-01","2040-01-01","2040-04-01","2040-07-01","2040-10-01","2041-01-01","2041-04-01","2041-07-01","2041-10-01","2042-01-01",{"$f":"BW2+1","v":"2042-04-01"},"2042-07-01","2042-10-01","2043-01-01","2043-04-01","2043-07-01","2043-10-01","2044-01-01","2044-04-01","2044-07-01","2044-10-01","2045-01-01","2045-04-01","2045-07-01","2045-10-01","2046-01-01","2046-04-01","2046-07-01","2046-10-01","2047-01-01","2047-04-01","2047-07-01","2047-10-01","2048-01-01","2048-04-01","2048-07-01","2048-10-01","2049-01-01","2049-04-01","2049-07-01","2049-10-01","2050-01-01","2050-04-01","2050-07-01","2050-10-01"]
[{"$f":"_xlfn.SHEET()","v":5},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Calculations"},null,null,null,null,null,null,null,"Period End",{"$f":"EOMONTH(K1,MiP-1)","v":"2026-03-31"},{"$f":"EOMONTH(L1,MiP-1)","v":"2026-06-30"},{"$f":"EOMONTH(M1,MiP-1)","v":"2026-09-30"},"2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31","2028-03-31","2028-06-30","2028-09-30","2028-12-31","2029-03-31","2029-06-30","2029-09-30","2029-12-31","2030-03-31","2030-06-30","2030-09-30","2030-12-31","2031-03-31","2031-06-30","2031-09-30","2031-12-31","2032-03-31","2032-06-30","2032-09-30","2032-12-31","2033-03-31","2033-06-30","2033-09-30","2033-12-31","2034-03-31","2034-06-30","2034-09-30","2034-12-31","2035-03-31","2035-06-30","2035-09-30","2035-12-31","2036-03-31","2036-06-30","2036-09-30","2036-12-31","2037-03-31","2037-06-30","2037-09-30","2037-12-31","2038-03-31","2038-06-30","2038-09-30","2038-12-31","2039-03-31","2039-06-30","2039-09-30","2039-12-31","2040-03-31","2040-06-30","2040-09-30","2040-12-31","2041-03-31","2041-06-30","2041-09-30","2041-12-31","2042-03-31","2042-06-30",{"$f":"EOMONTH(BY1,MiP-1)","v":"2042-09-30"},"2042-12-31","2043-03-31","2043-06-30","2043-09-30","2043-12-31","2044-03-31","2044-06-30","2044-09-30","2044-12-31","2045-03-31","2045-06-30","2045-09-30","2045-12-31","2046-03-31","2046-06-30","2046-09-30","2046-12-31","2047-03-31","2047-06-30","2047-09-30","2047-12-31","2048-03-31","2048-06-30","2048-09-30","2048-12-31","2049-03-31","2049-06-30","2049-09-30","2049-12-31","2050-03-31","2050-06-30","2050-09-30","2050-12-31"]
[null,"Main calculation engine for the model",null,null,null,null,"Sum Chks"]
[null,null,null,null,null,null,{"$f":"SUM(G7:G206)","v":0}]
[{"$f":"Table!B25","v":"All Checks are OK"},null,"Units","Assumptions",null,null,"Checks","Alerts","Total","Seed"]
[]
[]
[{"$f":"ROUNDDOWN(MAX($A$7:OFFSET(A8,-One,0),$A$2*Sht)+Sxn,0)","v":501},"Assumptions"]
[]
[{"$f":"MAX(A$2:OFFSET($A10,-One,0))+Sbsxn","v":501.01},"General Flags & Counters"]
[]
[null,"Period start month number","#",null,null,null,null,null,null,null,{"$f":"MONTH(K1)","v":1},4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,{"$f":"MONTH(AQ1)","v":1},4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,{"$f":"MONTH(BW1)","v":1},4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10,1,4,7,10]
[null,"Period end month number","#",null,null,null,null,null,null,null,{"$f":"MONTH(K2)","v":3},6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,{"$f":"MONTH(AQ2)","v":3},6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,{"$f":"MONTH(BW2)","v":3},6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12,3,6,9,12]
[]
[null,"Calendar year","year",null,null,null,null,null,null,null,{"$f":"YEAR(K2)","v":2026},2026,2026,2026,2027,2027,2027,2027,2028,2028,2028,2028,2029,2029,2029,2029,2030,2030,2030,2030,2031,2031,2031,2031,2032,2032,2032,2032,2033,2033,2033,2033,{"$f":"YEAR(AQ2)","v":2034},2034,2034,2034,2035,2035,2035,2035,2036,2036,2036,2036,2037,2037,2037,2037,2038,2038,2038,2038,2039,2039,2039,2039,2040,2040,2040,2040,2041,2041,2041,2041,{"$f":"YEAR(BW2)","v":2042},2042,2042,2042,2043,2043,2043,2043,2044,2044,2044,2044,2045,2045,2045,2045,2046,2046,2046,2046,2047,2047,2047,2047,2048,2048,2048,2048,2049,2049,2049,2049,2050,2050,2050,2050]
[null,"Financial year","year",{"$f":"Assumptions!D17","v":6},null,null,null,null,null,null,{"$f":"YEAR(K1)+IF(MONTH(K1)>Assumptions!$D$17,1,0)","v":2026},{"$f":"YEAR(L1)+IF(MONTH(L1)>Assumptions!$D$17,1,0)","v":2026},{"$f":"YEAR(M1)+IF(MONTH(M1)>Assumptions!$D$17,1,0)","v":2027},{"$f":"YEAR(N1)+IF(MONTH(N1)>Assumptions!$D$17,1,0)","v":2027},{"$f":"YEAR(O1)+IF(MONTH(O1)>Assumptions!$D$17,1,0)","v":2027},{"$f":"YEAR(P1)+IF(MONTH(P1)>Assumptions!$D$17,1,0)","v":2027},{"$f":"YEAR(Q1)+IF(MONTH(Q1)>Assumptions!$D$17,1,0)","v":2028},{"$f":"YEAR(R1)+IF(MONTH(R1)>Assumptions!$D$17,1,0)","v":2028},{"$f":"YEAR(S1)+IF(MONTH(S1)>Assumptions!$D$17,1,0)","v":2028},{"$f":"YEAR(T1)+IF(MONTH(T1)>Assumptions!$D$17,1,0)","v":2028},{"$f":"YEAR(U1)+IF(MONTH(U1)>Assumptions!$D$17,1,0)","v":2029},{"$f":"YEAR(V1)+IF(MONTH(V1)>Assumptions!$D$17,1,0)","v":2029},{"$f":"YEAR(W1)+IF(MONTH(W1)>Assumptions!$D$17,1,0)","v":2029},{"$f":"YEAR(X1)+IF(MONTH(X1)>Assumptions!$D$17,1,0)","v":2029},{"$f":"YEAR(Y1)+IF(MONTH(Y1)>Assumptions!$D$17,1,0)","v":2030},{"$f":"YEAR(Z1)+IF(MONTH(Z1)>Assumptions!$D$17,1,0)","v":2030},{"$f":"YEAR(AA1)+IF(MONTH(AA1)>Assumptions!$D$17,1,0)","v":2030},{"$f":"YEAR(AB1)+IF(MONTH(AB1)>Assumptions!$D$17,1,0)","v":2030},{"$f":"YEAR(AC1)+IF(MONTH(AC1)>Assumptions!$D$17,1,0)","v":2031},{"$f":"YEAR(AD1)+IF(MONTH(AD1)>Assumptions!$D$17,1,0)","v":2031},{"$f":"YEAR(AE1)+IF(MONTH(AE1)>Assumptions!$D$17,1,0)","v":2031},{"$f":"YEAR(AF1)+IF(MONTH(AF1)>Assumptions!$D$17,1,0)","v":2031},{"$f":"YEAR(AG1)+IF(MONTH(AG1)>Assumptions!$D$17,1,0)","v":2032},{"$f":"YEAR(AH1)+IF(MONTH(AH1)>Assumptions!$D$17,1,0)","v":2032},{"$f":"YEAR(AI1)+IF(MONTH(AI1)>Assumptions!$D$17,1,0)","v":2032},{"$f":"YEAR(AJ1)+IF(MONTH(AJ1)>Assumptions!$D$17,1,0)","v":2032},{"$f":"YEAR(AK1)+IF(MONTH(AK1)>Assumptions!$D$17,1,0)","v":2033},{"$f":"YEAR(AL1)+IF(MONTH(AL1)>Assumptions!$D$17,1,0)","v":2033},{"$f":"YEAR(AM1)+IF(MONTH(AM1)>Assumptions!$D$17,1,0)","v":2033},{"$f":"YEAR(AN1)+IF(MONTH(AN1)>Assumptions!$D$17,1,0)","v":2033},{"$f":"YEAR(AO1)+IF(MONTH(AO1)>Assumptions!$D$17,1,0)","v":2034},{"$f":"YEAR(AP1)+IF(MONTH(AP1)>Assumptions!$D$17,1,0)","v":2034},{"$f":"YEAR(AQ1)+IF(MONTH(AQ1)>Assumptions!$D$17,1,0)","v":2034},{"$f":"YEAR(AR1)+IF(MONTH(AR1)>Assumptions!$D$17,1,0)","v":2034},{"$f":"YEAR(AS1)+IF(MONTH(AS1)>Assumptions!$D$17,1,0)","v":2035},{"$f":"YEAR(AT1)+IF(MONTH(AT1)>Assumptions!$D$17,1,0)","v":2035},{"$f":"YEAR(AU1)+IF(MONTH(AU1)>Assumptions!$D$17,1,0)","v":2035},{"$f":"YEAR(AV1)+IF(MONTH(AV1)>Assumptions!$D$17,1,0)","v":2035},{"$f":"YEAR(AW1)+IF(MONTH(AW1)>Assumptions!$D$17,1,0)","v":2036},{"$f":"YEAR(AX1)+IF(MONTH(AX1)>Assumptions!$D$17,1,0)","v":2036},{"$f":"YEAR(AY1)+IF(MONTH(AY1)>Assumptions!$D$17,1,0)","v":2036},{"$f":"YEAR(AZ1)+IF(MONTH(AZ1)>Assumptions!$D$17,1,0)","v":2036},{"$f":"YEAR(BA1)+IF(MONTH(BA1)>Assumptions!$D$17,1,0)","v":2037},{"$f":"YEAR(BB1)+IF(MONTH(BB1)>Assumptions!$D$17,1,0)","v":2037},{"$f":"YEAR(BC1)+IF(MONTH(BC1)>Assumptions!$D$17,1,0)","v":2037},{"$f":"YEAR(BD1)+IF(MONTH(BD1)>Assumptions!$D$17,1,0)","v":2037},{"$f":"YEAR(BE1)+IF(MONTH(BE1)>Assumptions!$D$17,1,0)","v":2038},{"$f":"YEAR(BF1)+IF(MONTH(BF1)>Assumptions!$D$17,1,0)","v":2038},{"$f":"YEAR(BG1)+IF(MONTH(BG1)>Assumptions!$D$17,1,0)","v":2038},{"$f":"YEAR(BH1)+IF(MONTH(BH1)>Assumptions!$D$17,1,0)","v":2038},{"$f":"YEAR(BI1)+IF(MONTH(BI1)>Assumptions!$D$17,1,0)","v":2039},{"$f":"YEAR(BJ1)+IF(MONTH(BJ1)>Assumptions!$D$17,1,0)","v":2039},{"$f":"YEAR(BK1)+IF(MONTH(BK1)>Assumptions!$D$17,1,0)","v":2039},{"$f":"YEAR(BL1)+IF(MONTH(BL1)>Assumptions!$D$17,1,0)","v":2039},{"$f":"YEAR(BM1)+IF(MONTH(BM1)>Assumptions!$D$17,1,0)","v":2040},{"$f":"YEAR(BN1)+IF(MONTH(BN1)>Assumptions!$D$17,1,0)","v":2040},{"$f":"YEAR(BO1)+IF(MONTH(BO1)>Assumptions!$D$17,1,0)","v":2040},{"$f":"YEAR(BP1)+IF(MONTH(BP1)>Assumptions!$D$17,1,0)","v":2040},{"$f":"YEAR(BQ1)+IF(MONTH(BQ1)>Assumptions!$D$17,1,0)","v":2041},{"$f":"YEAR(BR1)+IF(MONTH(BR1)>Assumptions!$D$17,1,0)","v":2041},{"$f":"YEAR(BS1)+IF(MONTH(BS1)>Assumptions!$D$17,1,0)","v":2041},{"$f":"YEAR(BT1)+IF(MONTH(BT1)>Assumptions!$D$17,1,0)","v":2041},{"$f":"YEAR(BU1)+IF(MONTH(BU1)>Assumptions!$D$17,1,0)","v":2042},{"$f":"YEAR(BV1)+IF(MONTH(BV1)>Assumptions!$D$17,1,0)","v":2042},{"$f":"YEAR(BW1)+IF(MONTH(BW1)>Assumptions!$D$17,1,0)","v":2042},{"$f":"YEAR(BX1)+IF(MONTH(BX1)>Assumptions!$D$17,1,0)","v":2042},{"$f":"YEAR(BY1)+IF(MONTH(BY1)>Assumptions!$D$17,1,0)","v":2043},{"$f":"YEAR(BZ1)+IF(MONTH(BZ1)>Assumptions!$D$17,1,0)","v":2043},{"$f":"YEAR(CA1)+IF(MONTH(CA1)>Assumptions!$D$17,1,0)","v":2043},{"$f":"YEAR(CB1)+IF(MONTH(CB1)>Assumptions!$D$17,1,0)","v":2043},{"$f":"YEAR(CC1)+IF(MONTH(CC1)>Assumptions!$D$17,1,0)","v":2044},{"$f":"YEAR(CD1)+IF(MONTH(CD1)>Assumptions!$D$17,1,0)","v":2044},{"$f":"YEAR(CE1)+IF(MONTH(CE1)>Assumptions!$D$17,1,0)","v":2044},{"$f":"YEAR(CF1)+IF(MONTH(CF1)>Assumptions!$D$17,1,0)","v":2044},{"$f":"YEAR(CG1)+IF(MONTH(CG1)>Assumptions!$D$17,1,0)","v":2045},{"$f":"YEAR(CH1)+IF(MONTH(CH1)>Assumptions!$D$17,1,0)","v":2045},{"$f":"YEAR(CI1)+IF(MONTH(CI1)>Assumptions!$D$17,1,0)","v":2045},{"$f":"YEAR(CJ1)+IF(MONTH(CJ1)>Assumptions!$D$17,1,0)","v":2045},{"$f":"YEAR(CK1)+IF(MONTH(CK1)>Assumptions!$D$17,1,0)","v":2046},{"$f":"YEAR(CL1)+IF(MONTH(CL1)>Assumptions!$D$17,1,0)","v":2046},{"$f":"YEAR(CM1)+IF(MONTH(CM1)>Assumptions!$D$17,1,0)","v":2046},{"$f":"YEAR(CN1)+IF(MONTH(CN1)>Assumptions!$D$17,1,0)","v":2046},{"$f":"YEAR(CO1)+IF(MONTH(CO1)>Assumptions!$D$17,1,0)","v":2047},{"$f":"YEAR(CP1)+IF(MONTH(CP1)>Assumptions!$D$17,1,0)","v":2047},{"$f":"YEAR(CQ1)+IF(MONTH(CQ1)>Assumptions!$D$17,1,0)","v":2047},{"$f":"YEAR(CR1)+IF(MONTH(CR1)>Assumptions!$D$17,1,0)","v":2047},{"$f":"YEAR(CS1)+IF(MONTH(CS1)>Assumptions!$D$17,1,0)","v":2048},{"$f":"YEAR(CT1)+IF(MONTH(CT1)>Assumptions!$D$17,1,0)","v":2048},{"$f":"YEAR(CU1)+IF(MONTH(CU1)>Assumptions!$D$17,1,0)","v":2048},{"$f":"YEAR(CV1)+IF(MONTH(CV1)>Assumptions!$D$17,1,0)","v":2048},{"$f":"YEAR(CW1)+IF(MONTH(CW1)>Assumptions!$D$17,1,0)","v":2049},{"$f":"YEAR(CX1)+IF(MONTH(CX1)>Assumptions!$D$17,1,0)","v":2049},{"$f":"YEAR(CY1)+IF(MONTH(CY1)>Assumptions!$D$17,1,0)","v":2049},{"$f":"YEAR(CZ1)+IF(MONTH(CZ1)>Assumptions!$D$17,1,0)","v":2049},{"$f":"YEAR(DA1)+IF(MONTH(DA1)>Assumptions!$D$17,1,0)","v":2050},{"$f":"YEAR(DB1)+IF(MONTH(DB1)>Assumptions!$D$17,1,0)","v":2050},{"$f":"YEAR(DC1)+IF(MONTH(DC1)>Assumptions!$D$17,1,0)","v":2050},{"$f":"YEAR(DD1)+IF(MONTH(DD1)>Assumptions!$D$17,1,0)","v":2050},{"$f":"YEAR(DE1)+IF(MONTH(DE1)>Assumptions!$D$17,1,0)","v":2051},{"$f":"YEAR(DF1)+IF(MONTH(DF1)>Assumptions!$D$17,1,0)","v":2051}]
[]
[{"$f":"MAX(A$2:OFFSET($A18,-One,0))+Sbsxn","v":501.02},"Project Flags & Counters"]
[]
[null,"Flags"]
[null,"Payment Term start","#",{"$f":"Assumptions!D40","v":"2027-05-01"},null,null,{"$f":"N(AND(I21<>One,D21<>Zero))","v":0},null,{"$f":"SUM(K21:DF21)","v":1},null,{"$f":"IF(AND($D21<=K$2,$D21>=K$1),One,Zero)","v":0},0,0,0,0,1,0,0,0,0,{"$f":"IF(AND($D21<=U$2,$D21>=U$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=AE$2,$D21>=AE$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=AO$2,$D21>=AO$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=AY$2,$D21>=AY$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=BI$2,$D21>=BI$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=BS$2,$D21>=BS$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=CC$2,$D21>=CC$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=CM$2,$D21>=CM$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($D21<=CW$2,$D21>=CW$1),One,Zero)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Payment Term end","#",{"$f":"Assumptions!D41","v":"2041-04-30"},null,null,{"$f":"N(AND(I22<>One,D22<>Zero))","v":0},null,{"$f":"SUM(K22:DF22)","v":1},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Scheme Term start","#",{"$f":"Assumptions!D34","v":"2026-05-01"},null,null,{"$f":"N(AND(I23<>One,D23<>Zero))","v":0},null,{"$f":"SUM(K23:DF23)","v":1},null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Scheme Term end","#",{"$f":"Assumptions!D36","v":"2041-04-30"},null,null,{"$f":"N(AND(I24<>One,D24<>Zero))","v":0},null,{"$f":"SUM(K24:DF24)","v":1},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Payment Term flag","#",{"$f":"D21","v":"2027-05-01"},{"$f":"D22","v":"2041-04-30"},null,null,null,{"$f":"SUM(K26:DF26)","v":57},null,{"$f":"IF(AND(K$2>=$D26,K$1<=$E26),One,Zero)","v":0},0,0,0,0,1,1,1,1,1,{"$f":"IF(AND(U$2>=$D26,U$1<=$E26),One,Zero)","v":1},1,1,1,1,1,1,1,1,1,{"$f":"IF(AND(AE$2>=$D26,AE$1<=$E26),One,Zero)","v":1},1,1,1,1,1,1,1,1,1,{"$f":"IF(AND(AO$2>=$D26,AO$1<=$E26),One,Zero)","v":1},1,1,1,1,1,1,1,1,1,{"$f":"IF(AND(AY$2>=$D26,AY$1<=$E26),One,Zero)","v":1},1,1,1,1,1,1,1,1,1,{"$f":"IF(AND(BI$2>=$D26,BI$1<=$E26),One,Zero)","v":1},1,1,1,1,1,1,1,1,1,{"$f":"IF(AND(BS$2>=$D26,BS$1<=$E26),One,Zero)","v":1},1,0,0,0,0,0,0,0,0,{"$f":"IF(AND(CC$2>=$D26,CC$1<=$E26),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(CM$2>=$D26,CM$1<=$E26),One,Zero)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(CW$2>=$D26,CW$1<=$E26),One,Zero)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Scheme Term flag","#",{"$f":"D23","v":"2026-05-01"},{"$f":"D24","v":"2041-04-30"},null,null,null,{"$f":"SUM(K27:DF27)","v":61},null,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Payment Term cumulative flag","#",null,null,null,{"$f":"N(ABS(I26-I29)>=Tolerance1)","v":0},null,{"$f":"MAX(K29:DF29)","v":57},null,{"$f":"N(K26>0)*SUM(K$26:$K26)","v":0},{"$f":"N(L26>0)*SUM($K$26:L26)","v":0},{"$f":"N(M26>0)*SUM($K$26:M26)","v":0},{"$f":"N(N26>0)*SUM($K$26:N26)","v":0},{"$f":"N(O26>0)*SUM($K$26:O26)","v":0},{"$f":"N(P26>0)*SUM($K$26:P26)","v":1},{"$f":"N(Q26>0)*SUM($K$26:Q26)","v":2},{"$f":"N(R26>0)*SUM($K$26:R26)","v":3},{"$f":"N(S26>0)*SUM($K$26:S26)","v":4},{"$f":"N(T26>0)*SUM($K$26:T26)","v":5},{"$f":"N(U26>0)*SUM($K$26:U26)","v":6},{"$f":"N(V26>0)*SUM($K$26:V26)","v":7},{"$f":"N(W26>0)*SUM($K$26:W26)","v":8},{"$f":"N(X26>0)*SUM($K$26:X26)","v":9},{"$f":"N(Y26>0)*SUM($K$26:Y26)","v":10},{"$f":"N(Z26>0)*SUM($K$26:Z26)","v":11},{"$f":"N(AA26>0)*SUM($K$26:AA26)","v":12},{"$f":"N(AB26>0)*SUM($K$26:AB26)","v":13},{"$f":"N(AC26>0)*SUM($K$26:AC26)","v":14},{"$f":"N(AD26>0)*SUM($K$26:AD26)","v":15},{"$f":"N(AE26>0)*SUM($K$26:AE26)","v":16},{"$f":"N(AF26>0)*SUM($K$26:AF26)","v":17},{"$f":"N(AG26>0)*SUM($K$26:AG26)","v":18},{"$f":"N(AH26>0)*SUM($K$26:AH26)","v":19},{"$f":"N(AI26>0)*SUM($K$26:AI26)","v":20},{"$f":"N(AJ26>0)*SUM($K$26:AJ26)","v":21},{"$f":"N(AK26>0)*SUM($K$26:AK26)","v":22},{"$f":"N(AL26>0)*SUM($K$26:AL26)","v":23},{"$f":"N(AM26>0)*SUM($K$26:AM26)","v":24},{"$f":"N(AN26>0)*SUM($K$26:AN26)","v":25},{"$f":"N(AO26>0)*SUM($K$26:AO26)","v":26},{"$f":"N(AP26>0)*SUM($K$26:AP26)","v":27},{"$f":"N(AQ26>0)*SUM($K$26:AQ26)","v":28},{"$f":"N(AR26>0)*SUM($K$26:AR26)","v":29},{"$f":"N(AS26>0)*SUM($K$26:AS26)","v":30},{"$f":"N(AT26>0)*SUM($K$26:AT26)","v":31},{"$f":"N(AU26>0)*SUM($K$26:AU26)","v":32},{"$f":"N(AV26>0)*SUM($K$26:AV26)","v":33},{"$f":"N(AW26>0)*SUM($K$26:AW26)","v":34},{"$f":"N(AX26>0)*SUM($K$26:AX26)","v":35},{"$f":"N(AY26>0)*SUM($K$26:AY26)","v":36},{"$f":"N(AZ26>0)*SUM($K$26:AZ26)","v":37},{"$f":"N(BA26>0)*SUM($K$26:BA26)","v":38},{"$f":"N(BB26>0)*SUM($K$26:BB26)","v":39},{"$f":"N(BC26>0)*SUM($K$26:BC26)","v":40},{"$f":"N(BD26>0)*SUM($K$26:BD26)","v":41},{"$f":"N(BE26>0)*SUM($K$26:BE26)","v":42},{"$f":"N(BF26>0)*SUM($K$26:BF26)","v":43},{"$f":"N(BG26>0)*SUM($K$26:BG26)","v":44},{"$f":"N(BH26>0)*SUM($K$26:BH26)","v":45},{"$f":"N(BI26>0)*SUM($K$26:BI26)","v":46},{"$f":"N(BJ26>0)*SUM($K$26:BJ26)","v":47},{"$f":"N(BK26>0)*SUM($K$26:BK26)","v":48},{"$f":"N(BL26>0)*SUM($K$26:BL26)","v":49},{"$f":"N(BM26>0)*SUM($K$26:BM26)","v":50},{"$f":"N(BN26>0)*SUM($K$26:BN26)","v":51},{"$f":"N(BO26>0)*SUM($K$26:BO26)","v":52},{"$f":"N(BP26>0)*SUM($K$26:BP26)","v":53},{"$f":"N(BQ26>0)*SUM($K$26:BQ26)","v":54},{"$f":"N(BR26>0)*SUM($K$26:BR26)","v":55},{"$f":"N(BS26>0)*SUM($K$26:BS26)","v":56},{"$f":"N(BT26>0)*SUM($K$26:BT26)","v":57},{"$f":"N(BU26>0)*SUM($K$26:BU26)","v":0},{"$f":"N(BV26>0)*SUM($K$26:BV26)","v":0},{"$f":"N(BW26>0)*SUM($K$26:BW26)","v":0},{"$f":"N(BX26>0)*SUM($K$26:BX26)","v":0},{"$f":"N(BY26>0)*SUM($K$26:BY26)","v":0},{"$f":"N(BZ26>0)*SUM($K$26:BZ26)","v":0},{"$f":"N(CA26>0)*SUM($K$26:CA26)","v":0},{"$f":"N(CB26>0)*SUM($K$26:CB26)","v":0},{"$f":"N(CC26>0)*SUM($K$26:CC26)","v":0},{"$f":"N(CD26>0)*SUM($K$26:CD26)","v":0},{"$f":"N(CE26>0)*SUM($K$26:CE26)","v":0},{"$f":"N(CF26>0)*SUM($K$26:CF26)","v":0},{"$f":"N(CG26>0)*SUM($K$26:CG26)","v":0},{"$f":"N(CH26>0)*SUM($K$26:CH26)","v":0},{"$f":"N(CI26>0)*SUM($K$26:CI26)","v":0},{"$f":"N(CJ26>0)*SUM($K$26:CJ26)","v":0},{"$f":"N(CK26>0)*SUM($K$26:CK26)","v":0},{"$f":"N(CL26>0)*SUM($K$26:CL26)","v":0},{"$f":"N(CM26>0)*SUM($K$26:CM26)","v":0},{"$f":"N(CN26>0)*SUM($K$26:CN26)","v":0},{"$f":"N(CO26>0)*SUM($K$26:CO26)","v":0},{"$f":"N(CP26>0)*SUM($K$26:CP26)","v":0},{"$f":"N(CQ26>0)*SUM($K$26:CQ26)","v":0},{"$f":"N(CR26>0)*SUM($K$26:CR26)","v":0},{"$f":"N(CS26>0)*SUM($K$26:CS26)","v":0},{"$f":"N(CT26>0)*SUM($K$26:CT26)","v":0},{"$f":"N(CU26>0)*SUM($K$26:CU26)","v":0},{"$f":"N(CV26>0)*SUM($K$26:CV26)","v":0},{"$f":"N(CW26>0)*SUM($K$26:CW26)","v":0},{"$f":"N(CX26>0)*SUM($K$26:CX26)","v":0},{"$f":"N(CY26>0)*SUM($K$26:CY26)","v":0},{"$f":"N(CZ26>0)*SUM($K$26:CZ26)","v":0},{"$f":"N(DA26>0)*SUM($K$26:DA26)","v":0},{"$f":"N(DB26>0)*SUM($K$26:DB26)","v":0},{"$f":"N(DC26>0)*SUM($K$26:DC26)","v":0},{"$f":"N(DD26>0)*SUM($K$26:DD26)","v":0},{"$f":"N(DE26>0)*SUM($K$26:DE26)","v":0},{"$f":"N(DF26>0)*SUM($K$26:DF26)","v":0}]
[null,"Scheme Term cumulative flag","#",null,null,null,{"$f":"N(ABS(I27-I30)>=Tolerance1)","v":0},null,{"$f":"MAX(K30:DF30)","v":61},null,{"$f":"N(K27>0)*SUM(K$27:$K27)","v":0},{"$f":"N(L27>0)*SUM($K$27:L27)","v":1},{"$f":"N(M27>0)*SUM($K$27:M27)","v":2},{"$f":"N(N27>0)*SUM($K$27:N27)","v":3},{"$f":"N(O27>0)*SUM($K$27:O27)","v":4},{"$f":"N(P27>0)*SUM($K$27:P27)","v":5},{"$f":"N(Q27>0)*SUM($K$27:Q27)","v":6},{"$f":"N(R27>0)*SUM($K$27:R27)","v":7},{"$f":"N(S27>0)*SUM($K$27:S27)","v":8},{"$f":"N(T27>0)*SUM($K$27:T27)","v":9},{"$f":"N(U27>0)*SUM($K$27:U27)","v":10},{"$f":"N(V27>0)*SUM($K$27:V27)","v":11},{"$f":"N(W27>0)*SUM($K$27:W27)","v":12},{"$f":"N(X27>0)*SUM($K$27:X27)","v":13},{"$f":"N(Y27>0)*SUM($K$27:Y27)","v":14},{"$f":"N(Z27>0)*SUM($K$27:Z27)","v":15},{"$f":"N(AA27>0)*SUM($K$27:AA27)","v":16},{"$f":"N(AB27>0)*SUM($K$27:AB27)","v":17},{"$f":"N(AC27>0)*SUM($K$27:AC27)","v":18},{"$f":"N(AD27>0)*SUM($K$27:AD27)","v":19},{"$f":"N(AE27>0)*SUM($K$27:AE27)","v":20},{"$f":"N(AF27>0)*SUM($K$27:AF27)","v":21},{"$f":"N(AG27>0)*SUM($K$27:AG27)","v":22},{"$f":"N(AH27>0)*SUM($K$27:AH27)","v":23},{"$f":"N(AI27>0)*SUM($K$27:AI27)","v":24},{"$f":"N(AJ27>0)*SUM($K$27:AJ27)","v":25},{"$f":"N(AK27>0)*SUM($K$27:AK27)","v":26},{"$f":"N(AL27>0)*SUM($K$27:AL27)","v":27},{"$f":"N(AM27>0)*SUM($K$27:AM27)","v":28},{"$f":"N(AN27>0)*SUM($K$27:AN27)","v":29},{"$f":"N(AO27>0)*SUM($K$27:AO27)","v":30},{"$f":"N(AP27>0)*SUM($K$27:AP27)","v":31},{"$f":"N(AQ27>0)*SUM($K$27:AQ27)","v":32},{"$f":"N(AR27>0)*SUM($K$27:AR27)","v":33},{"$f":"N(AS27>0)*SUM($K$27:AS27)","v":34},{"$f":"N(AT27>0)*SUM($K$27:AT27)","v":35},{"$f":"N(AU27>0)*SUM($K$27:AU27)","v":36},{"$f":"N(AV27>0)*SUM($K$27:AV27)","v":37},{"$f":"N(AW27>0)*SUM($K$27:AW27)","v":38},{"$f":"N(AX27>0)*SUM($K$27:AX27)","v":39},{"$f":"N(AY27>0)*SUM($K$27:AY27)","v":40},{"$f":"N(AZ27>0)*SUM($K$27:AZ27)","v":41},{"$f":"N(BA27>0)*SUM($K$27:BA27)","v":42},{"$f":"N(BB27>0)*SUM($K$27:BB27)","v":43},{"$f":"N(BC27>0)*SUM($K$27:BC27)","v":44},{"$f":"N(BD27>0)*SUM($K$27:BD27)","v":45},{"$f":"N(BE27>0)*SUM($K$27:BE27)","v":46},{"$f":"N(BF27>0)*SUM($K$27:BF27)","v":47},{"$f":"N(BG27>0)*SUM($K$27:BG27)","v":48},{"$f":"N(BH27>0)*SUM($K$27:BH27)","v":49},{"$f":"N(BI27>0)*SUM($K$27:BI27)","v":50},{"$f":"N(BJ27>0)*SUM($K$27:BJ27)","v":51},{"$f":"N(BK27>0)*SUM($K$27:BK27)","v":52},{"$f":"N(BL27>0)*SUM($K$27:BL27)","v":53},{"$f":"N(BM27>0)*SUM($K$27:BM27)","v":54},{"$f":"N(BN27>0)*SUM($K$27:BN27)","v":55},{"$f":"N(BO27>0)*SUM($K$27:BO27)","v":56},{"$f":"N(BP27>0)*SUM($K$27:BP27)","v":57},{"$f":"N(BQ27>0)*SUM($K$27:BQ27)","v":58},{"$f":"N(BR27>0)*SUM($K$27:BR27)","v":59},{"$f":"N(BS27>0)*SUM($K$27:BS27)","v":60},{"$f":"N(BT27>0)*SUM($K$27:BT27)","v":61},{"$f":"N(BU27>0)*SUM($K$27:BU27)","v":0},{"$f":"N(BV27>0)*SUM($K$27:BV27)","v":0},{"$f":"N(BW27>0)*SUM($K$27:BW27)","v":0},{"$f":"N(BX27>0)*SUM($K$27:BX27)","v":0},{"$f":"N(BY27>0)*SUM($K$27:BY27)","v":0},{"$f":"N(BZ27>0)*SUM($K$27:BZ27)","v":0},{"$f":"N(CA27>0)*SUM($K$27:CA27)","v":0},{"$f":"N(CB27>0)*SUM($K$27:CB27)","v":0},{"$f":"N(CC27>0)*SUM($K$27:CC27)","v":0},{"$f":"N(CD27>0)*SUM($K$27:CD27)","v":0},{"$f":"N(CE27>0)*SUM($K$27:CE27)","v":0},{"$f":"N(CF27>0)*SUM($K$27:CF27)","v":0},{"$f":"N(CG27>0)*SUM($K$27:CG27)","v":0},{"$f":"N(CH27>0)*SUM($K$27:CH27)","v":0},{"$f":"N(CI27>0)*SUM($K$27:CI27)","v":0},{"$f":"N(CJ27>0)*SUM($K$27:CJ27)","v":0},{"$f":"N(CK27>0)*SUM($K$27:CK27)","v":0},{"$f":"N(CL27>0)*SUM($K$27:CL27)","v":0},{"$f":"N(CM27>0)*SUM($K$27:CM27)","v":0},{"$f":"N(CN27>0)*SUM($K$27:CN27)","v":0},{"$f":"N(CO27>0)*SUM($K$27:CO27)","v":0},{"$f":"N(CP27>0)*SUM($K$27:CP27)","v":0},{"$f":"N(CQ27>0)*SUM($K$27:CQ27)","v":0},{"$f":"N(CR27>0)*SUM($K$27:CR27)","v":0},{"$f":"N(CS27>0)*SUM($K$27:CS27)","v":0},{"$f":"N(CT27>0)*SUM($K$27:CT27)","v":0},{"$f":"N(CU27>0)*SUM($K$27:CU27)","v":0},{"$f":"N(CV27>0)*SUM($K$27:CV27)","v":0},{"$f":"N(CW27>0)*SUM($K$27:CW27)","v":0},{"$f":"N(CX27>0)*SUM($K$27:CX27)","v":0},{"$f":"N(CY27>0)*SUM($K$27:CY27)","v":0},{"$f":"N(CZ27>0)*SUM($K$27:CZ27)","v":0},{"$f":"N(DA27>0)*SUM($K$27:DA27)","v":0},{"$f":"N(DB27>0)*SUM($K$27:DB27)","v":0},{"$f":"N(DC27>0)*SUM($K$27:DC27)","v":0},{"$f":"N(DD27>0)*SUM($K$27:DD27)","v":0},{"$f":"N(DE27>0)*SUM($K$27:DE27)","v":0},{"$f":"N(DF27>0)*SUM($K$27:DF27)","v":0}]
[]
[null,"Days in Period","#",null,null,null,null,null,null,null,{"$f":"_xlfn.DAYS(K$2,K$1-1)*K$27","v":0},91,92,92,90,91,92,92,91,91,92,92,90,91,92,92,90,91,92,92,90,91,92,92,91,91,92,92,90,91,92,92,{"$f":"_xlfn.DAYS(AQ$2,AQ$1-1)*AQ$27","v":90},91,92,92,90,91,92,92,91,91,92,92,90,91,92,92,90,91,92,92,90,91,92,92,91,91,92,92,90,91,0,0,{"$f":"_xlfn.DAYS(BW$2,BW$1-1)*BW$27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Portion of Period","%",null,null,null,null,null,null,null,{"$f":"IF(OR(K21,K22),K21*_xlfn.DAYS(K$2,$D$21-1)/K$32+K22*_xlfn.DAYS($D$22,K$1-1)/K$32,K$26)","v":0},{"$f":"IF(OR(L21,L22),L21*_xlfn.DAYS(L$2,$D$21-1)/L$32+L22*_xlfn.DAYS($D$22,L$1-1)/L$32,L$26)","v":0},{"$f":"IF(OR(M21,M22),M21*_xlfn.DAYS(M$2,$D$21-1)/M$32+M22*_xlfn.DAYS($D$22,M$1-1)/M$32,M$26)","v":0},0,0,0.67032967032967028,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0.32967032967032966,0,0,0,0,{"$f":"IF(OR(BY21,BY22),BY21*_xlfn.DAYS(BY$2,$D$21-1)/BY$32+BY22*_xlfn.DAYS($D$22,BY$1-1)/BY$32,BY$26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"MAX(A$2:OFFSET($A35,-One,0))+Sbsxn","v":501.03},"Indexation"]
[]
[null,"Escalation Base Date",null,{"$f":"Assumptions!D16","v":"2024-07-01"}]
[]
[null,"Escalation Rates"]
[null,"Fixed Indexation per annum","% p.a. ",{"$f":"Assumptions!D43","v":2.5000000000000001E-2}]
[null,"Fixed Indexation per quarter","% p.q.",{"$f":"(1+D40)^(1/QiY)-1","v":6.192246325636086E-3}]
[null,"Fixed Indexation factor","#",null,null,null,null,null,null,null,{"$f":"IF(K$1<=$D$37,1,(1+$D40)^YEARFRAC(K$1,$D$37))","v":1.0377334074799749},1.0441593083594325,1.0506249999999999,1.0571307287958711,1.0636767426669742,1.0702632910684182,1.0768906249999999,1.0835589970157677,1.0902686612336485,1.0970198733451286,1.1038128906249998,1.1106479719411619,1.1175253777644896,1.1244453701787567,1.1314082128906247,1.1384141712396909,1.1454635122086017,1.1525565044332255,1.1596934182128902,1.1668745255206829,1.1741001000138167,1.181370417044056,1.1886857536682125,1.1960463886587001,1.2034526025141621,1.2109046774701573,1.2184028975099177,1.2259475483751674,1.2335389175770159,1.2411772944069113,1.2488629699476654,1.2565962370845465,{"$f":"IF(AQ$1<=$D$37,1,(1+$D40)^YEARFRAC(AQ$1,$D$37))","v":1.2643773905164413},1.2722067267670838,1.2800845441963571,1.2880111430116599,1.2959868252793521,1.3040118949362609,1.312086657801266,1.3202114215869514,1.3283864959113358,1.3366121923096672,1.3448888242462975,1.353216707126625,1.3615961583091192,1.3700274971174089,1.3785110448524549,1.3870471248047906,1.3956360622668469,1.404278184545344,1.4129738209737661,1.4217233029249101,1.4305269638235181,1.4393851391589774,1.4482981664981105,1.4572663854980328,1.4662901379191058,1.4753697676379516,1.4845056206605631,1.4936980451354835,1.5029473913670832,1.5122540118289003,1.521618261177077,1.5310404962638706,{"$f":"IF(BW$1<=$D$37,1,(1+$D40)^YEARFRAC(BW$1,$D$37))","v":1.5405210761512602},1.5500603621246227,1.559658717706504,1.569316508670467,1.5790341030550417,1.5888118711777381,1.5986501856491666,1.6085494213872287,1.6185099556314175,1.6285321679571816,1.6386164402903955,1.6487631569219092,1.6589727045222027,1.669245472156111,1.6795818512976552,1.6899822358449568,1.7004470221352579,1.7109766089600134,1.7215713975800966,1.7322317917410806,1.742958197688639,1.7537510241840137,1.7646106825195991,1.7755375865346072,1.7865321526308549,1.7975947997886139,1.8087259495825889,1.8199260261979724,1.8311954564466262,1.8425346697833291,1.8539440983221533,1.8654241768529216,1.8769753428577918,1.888598036527912,1.9002927007802071,1.9120597812742446]
[]
[null,"Escalation Factors"]
[null,"Escalation rate - Fixed","% p.q.",null,null,null,null,null,null,null,{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,{"$f":"(1+$D40)^(1/QiY)-1","v":6.192246325636086E-3},6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3,6.192246325636086E-3]
[null,"Rebased escalation factor - Fixed","#",{"$f":"SUMPRODUCT($K$21:$CE$21,$K42:$CE42)","v":1.0702632910684182},null,null,null,null,null,null,{"$f":"K42*K$27","v":0},{"$f":"L$42*L$27","v":1.0441593083594325},{"$f":"M$42*M$27","v":1.0506249999999999},{"$f":"N$42*N$27","v":1.0571307287958711},{"$f":"O$42*O$27","v":1.0636767426669742},{"$f":"P$42*P$27","v":1.0702632910684182},1.0768906249999999,1.0835589970157677,1.0902686612336485,1.0970198733451286,1.1038128906249998,1.1106479719411619,1.1175253777644896,1.1244453701787567,1.1314082128906247,1.1384141712396909,1.1454635122086017,1.1525565044332255,1.1596934182128902,1.1668745255206829,1.1741001000138167,1.181370417044056,1.1886857536682125,1.1960463886587001,1.2034526025141621,1.2109046774701573,1.2184028975099177,1.2259475483751674,1.2335389175770159,1.2411772944069113,1.2488629699476654,1.2565962370845465,1.2643773905164413,1.2722067267670838,1.2800845441963571,1.2880111430116599,{"$f":"AU$42*AU$27","v":1.2959868252793521},1.3040118949362609,1.312086657801266,1.3202114215869514,1.3283864959113358,1.3366121923096672,1.3448888242462975,1.353216707126625,1.3615961583091192,1.3700274971174089,1.3785110448524549,1.3870471248047906,1.3956360622668469,1.404278184545344,1.4129738209737661,1.4217233029249101,1.4305269638235181,1.4393851391589774,1.4482981664981105,1.4572663854980328,1.4662901379191058,1.4753697676379516,1.4845056206605631,1.4936980451354835,1.5029473913670832,1.5122540118289003,0,0,0,0,0,0,{"$f":"CA$42*CA$27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"MAX(A$2:OFFSET($A48,-One,0))+Sbsxn","v":501.03999999999996},"Annual Access Fee Calculation"]
[]
[null,{"$f":"\"Summary Access Fee (in real \"&Units&\")\"","v":"Summary Access Fee (in real AUD$m)"}]
[null,"Annual Access Fee",null,"Subtotal"]
[null,"C&E Fee","AUD$m p.a.",{"$f":"Assumptions!D51*Assumptions!$D$27/Thousand","v":1.1499999999999999}]
[null,"SW REZ Administration Fee","AUD$m p.a.",{"$f":"Assumptions!D52*Assumptions!$D$27/Thousand","v":0.34549999999999997}]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$m p.a.",{"$f":"Assumptions!D53*Assumptions!$D$27/Thousand","v":0.50450000000000017}]
[null,"Total","AUD$m p.a.",{"$f":"SUM(D52:D54)","v":2}]
[]
[null,"Annual Access Fee per MW",null,"Subtotal"]
[null,"C&E Fee","AUD$'000/MW",{"$f":"Assumptions!D51","v":2.2999999999999998}]
[null,"SW REZ Administration Fee","AUD$'000/MW",{"$f":"Assumptions!D52","v":0.69099999999999995}]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$'000/MW",{"$f":"Assumptions!D53","v":1.0090000000000003}]
[null,"Total Indicative Access Fee","AUD$'000/MW",{"$f":"SUM(D58:D60)","v":4}]
[]
[{"$f":"MAX(A$2:OFFSET($A63,-One,0))+Sbsxn","v":501.04999999999995},"Quarterly Access Fee Calculation"]
[]
[null,{"$f":"\"Summary Access Fee (in real \"&Units&\")\"","v":"Summary Access Fee (in real AUD$m)"}]
[null,"Quarterly Access Fee",null,"Subtotal"]
[null,"C&E Fee","AUD$m p.q.",{"$f":"(Assumptions!D51/QiY)*Assumptions!$D$27/Thousand","v":0.28749999999999998}]
[null,"SW REZ Administration Fee","AUD$m p.q.",{"$f":"(Assumptions!D52/QiY)*Assumptions!$D$27/Thousand","v":8.6374999999999993E-2}]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$m p.q.",{"$f":"(Assumptions!D53/QiY)*Assumptions!$D$27/Thousand","v":0.12612500000000004}]
[null,"Total","AUD$m p.q.",{"$f":"SUM(D67:D69)","v":0.5}]
[]
[null,{"$f":"\"Summary Access Fee (in nominal \"&Units&\")\"","v":"Summary Access Fee (in nominal AUD$m)"}]
[null,"Quarterly Access Fee"]
[null,"C&E Fee",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K74:DF74)","v":20.563093095342204},null,{"$f":"($D67*K$46)*K$26*K$33","v":0},{"$f":"($D67*L$46)*L$26*L$33","v":0},{"$f":"($D67*M$46)*M$26*M$33","v":0},{"$f":"($D67*N$46)*N$26*N$33","v":0},{"$f":"($D67*O$46)*O$26*O$33","v":0},{"$f":"($D67*P$46)*P$26*P$33","v":0.20626090623200419},0.30960605468749997,0.31152321164203323,0.31345224010467393,0.31539321358672445,0.31734620605468739,0.31931129193308405,0.32128854610729074,0.32327804392639253,0.32527986120605457,0.3272940742314111,0.32932075975997294,0.33135999502455232,0.33341185773620591,0.3354764260871963,0.3375537787539723,0.33964399490016606,0.34174715417961105,0.34386333673937625,0.34599262322282159,0.34813509477267018,0.3502908330341013,0.3524599201578606,0.35464243880339208,0.35683847214198694,0.35904810385995378,0.36127141816180708,0.36350849977347682,0.36575943394553656,0.36802430645645262,0.37030320361585217,0.3725962122678137,0.37490341979417496,0.37722491411786396,0.37956078370624852,0.38191111757450902,0.38427600528902928,0.38665553697081051,0.38904980329890465,0.39145889551387175,0.39388290542125504,0.39632192539508077,0.39877604838137726,0.40124536790171844,0.4037299780567864,0.40622997352995771,0.40874544959091164,0.41127650209926142,0.41382322750820594,0.41638572286820674,0.4189640858306844,0.42155841465174287,0.42416880819591107,0.42679536593991185,0.4294381879764515,0.43209737501803641,0.14333176760466224,0,0,0,0,0,0,0,{"$f":"($D67*CB$46)*CB$26*CB$33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SW REZ Administration Fee",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K75:DF75)","v":6.1778684038615044},null,{"$f":"($D68*K$46)*K$26*K$33","v":0},0,0,0,{"$f":"($D68*O$46)*O$26*O$33","v":0},6.1967950524484734E-2,9.3016427734374976E-2,9.3592408367236937E-2,9.4171955614056377E-2,9.4755091560185481E-2,9.5341838427734346E-2,9.5932218576417858E-2,9.6526254504407785E-2,9.7123968849190098E-2,9.7725384388427691E-2,9.8330524040828302E-2,9.8939410867017963E-2,9.9552068070419844E-2,0.10016851899813838,0.10078878714184898,0.10141289613869341,0.10204086977218033,0.10267273197309185,0.1033085068203952,0.10394821854216074,0.10459189151648483,0.10523955027241913,0.10589121949090508,0.10654692400571475,0.10720668880439695,0.10787053902922959,0.10853849997817769,0.10921059710585761,0.10988685602450686,0.11056730250496033,0.11125196247763211,0.11194086203350402,0.11263402742511952,0.11333148506758434,0.11403326153957291,0.11473938358434163,0.1154498781107475,0.11616477219427394,0.11688409307806223,0.11760786817395016,0.11833612506351618,0.11906889149913079,0.11980619540501378,0.12054806487829889,0.12129452819010408,0.12204561378660904,0.1228013502901391,0.12356176650025637,0.12432689139485666,0.12509675413127427,0.12587138404739256,0.12665081066276276,0.12743506367972807,0.12822417298455613,0.12901816864857737,0.12981708092933181,4.3061848441226784E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K76:DF76)","v":9.0209395361740423},null,0,0,0,0,0,{"$f":"($D69*P$46)*P$26*P$33","v":9.0485762777431436E-2},0.13582283007812504,0.13666387849861375,0.13751013489809397,0.13836163152565439,0.13921840083007814,0.1400804754610791,0.1409478882705463,0.14182067231379572,0.14269886085083008,0.14358248734760606,0.14447158547730993,0.14536618912164062,0.14626633237210082,0.14717204953129617,0.14808337511424269,0.14900034384968161,0.14992299068140336,0.15085135076957859,0.15178545949209873,0.15272535244592364,0.15367106544843842,0.15462263453881803,0.1555800959794012,0.15654348625707173,0.15751284208464936,0.15848820040228848,0.15946959837888622,0.16045707341349849,0.16145066313676559,0.16245040541234565,0.16345633833835832,0.16446850024883597,0.16548692971518472,0.16651166554765429,0.1675427467968173,0.16858021275505683,0.16962410295806432,0.17067445718634564,0.17173131546673773,0.17279471807393326,0.17386470553201594,0.17494131861600429,0.17602459835340611,0.17711458602578159,0.17821132317031632,0.17931485158140434,0.18042521331224129,0.18154245067642608,0.18266660624957426,0.18379772287093946,0.18493584364504728,0.1860810119433367,0.18723327140581358,0.18839266594271292,0.18955923973617345,6.2879023266567066E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Indicative Access Fee",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K77:DF77)","v":35.761901035377768},null,{"$f":"SUM(K74:K76)","v":0},{"$f":"SUM(L74:L76)","v":0},{"$f":"SUM(M74:M76)","v":0},{"$f":"SUM(N74:N76)","v":0},{"$f":"SUM(O74:O76)","v":0},{"$f":"SUM(P74:P76)","v":0.35871461953392036},0.53844531249999994,0.54177949850788387,0.54513433061682426,0.54850993667256431,0.55190644531249988,0.55532398597058097,0.55876268888224478,0.56222268508937834,0.56570410644531233,0.56920708561984545,0.57273175610430083,0.57627825221661277,0.57984670910644509,0.58343726276034147,0.58705005000690846,0.59068520852202799,0.59434287683410625,0.59802319432935003,0.60172630125708104,0.60545233873507864,0.60920144875495885,0.6129737741875837,0.61676945878850797,0.62058864720345563,0.62443148497383272,0.62829811854227324,0.63218869525822063,0.6361033633835419,0.64004227209817854,0.64400557150582993,0.64799341263967603,0.65200594746813045,0.65604332890063299,0.66010571079347569,0.66419324795566803,0.66830609615483361,0.67244441212314876,0.6766083535633125,0.68079807915455959,0.68501374855870445,0.68925552242622745,0.69352356240239532,0.69781803113342344,0.70213909227267202,0.70648691048688306,0.71086165146245506,0.71526348191175904,0.71969256957948868,0.72414908324905536,0.72863319274901639,0.73314506895955289,0.73768488381897579,0.74225281033028156,0.74684902256774177,0.75147369568354172,0.24927263931245608,0,0,0,0,0,0,0,{"$f":"SUM(CB74:CB76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"GST",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K79:DF79)","v":3.5761901035377757},null,{"$f":"K77*Assumptions!$D$45","v":0},{"$f":"L77*Assumptions!$D$45","v":0},{"$f":"M77*Assumptions!$D$45","v":0},{"$f":"N77*Assumptions!$D$45","v":0},{"$f":"O77*Assumptions!$D$45","v":0},{"$f":"P77*Assumptions!$D$45","v":3.5871461953392039E-2},{"$f":"Q77*Assumptions!$D$45","v":5.3844531249999994E-2},{"$f":"R77*Assumptions!$D$45","v":5.4177949850788387E-2},{"$f":"S77*Assumptions!$D$45","v":5.451343306168243E-2},{"$f":"T77*Assumptions!$D$45","v":5.4850993667256431E-2},{"$f":"U77*Assumptions!$D$45","v":5.5190644531249992E-2},{"$f":"V77*Assumptions!$D$45","v":5.5532398597058101E-2},{"$f":"W77*Assumptions!$D$45","v":5.587626888822448E-2},{"$f":"X77*Assumptions!$D$45","v":5.6222268508937835E-2},{"$f":"Y77*Assumptions!$D$45","v":5.6570410644531235E-2},{"$f":"Z77*Assumptions!$D$45","v":5.692070856198455E-2},{"$f":"AA77*Assumptions!$D$45","v":5.7273175610430084E-2},{"$f":"AB77*Assumptions!$D$45","v":5.762782522166128E-2},{"$f":"AC77*Assumptions!$D$45","v":5.7984670910644513E-2},{"$f":"AD77*Assumptions!$D$45","v":5.8343726276034152E-2},{"$f":"AE77*Assumptions!$D$45","v":5.8705005000690848E-2},{"$f":"AF77*Assumptions!$D$45","v":5.9068520852202801E-2},{"$f":"AG77*Assumptions!$D$45","v":5.9434287683410629E-2},{"$f":"AH77*Assumptions!$D$45","v":5.9802319432935007E-2},{"$f":"AI77*Assumptions!$D$45","v":6.0172630125708108E-2},{"$f":"AJ77*Assumptions!$D$45","v":6.0545233873507867E-2},{"$f":"AK77*Assumptions!$D$45","v":6.0920144875495887E-2},{"$f":"AL77*Assumptions!$D$45","v":6.1297377418758375E-2},{"$f":"AM77*Assumptions!$D$45","v":6.1676945878850802E-2},{"$f":"AN77*Assumptions!$D$45","v":6.2058864720345566E-2},{"$f":"AO77*Assumptions!$D$45","v":6.2443148497383277E-2},{"$f":"AP77*Assumptions!$D$45","v":6.2829811854227327E-2},{"$f":"AQ77*Assumptions!$D$45","v":6.3218869525822063E-2},{"$f":"AR77*Assumptions!$D$45","v":6.3610336338354195E-2},{"$f":"AS77*Assumptions!$D$45","v":6.4004227209817854E-2},{"$f":"AT77*Assumptions!$D$45","v":6.4400557150583002E-2},{"$f":"AU77*Assumptions!$D$45","v":6.4799341263967608E-2},{"$f":"AV77*Assumptions!$D$45","v":6.5200594746813043E-2},{"$f":"AW77*Assumptions!$D$45","v":6.5604332890063302E-2},{"$f":"AX77*Assumptions!$D$45","v":6.6010571079347574E-2},{"$f":"AY77*Assumptions!$D$45","v":6.6419324795566809E-2},{"$f":"AZ77*Assumptions!$D$45","v":6.6830609615483358E-2},{"$f":"BA77*Assumptions!$D$45","v":6.7244441212314876E-2},{"$f":"BB77*Assumptions!$D$45","v":6.7660835356331259E-2},{"$f":"BC77*Assumptions!$D$45","v":6.8079807915455967E-2},{"$f":"BD77*Assumptions!$D$45","v":6.8501374855870448E-2},{"$f":"BE77*Assumptions!$D$45","v":6.8925552242622742E-2},{"$f":"BF77*Assumptions!$D$45","v":6.935235624023954E-2},{"$f":"BG77*Assumptions!$D$45","v":6.9781803113342353E-2},{"$f":"BH77*Assumptions!$D$45","v":7.021390922726721E-2},{"$f":"BI77*Assumptions!$D$45","v":7.0648691048688303E-2},{"$f":"BJ77*Assumptions!$D$45","v":7.1086165146245509E-2},{"$f":"BK77*Assumptions!$D$45","v":7.1526348191175912E-2},{"$f":"BL77*Assumptions!$D$45","v":7.1969256957948868E-2},{"$f":"BM77*Assumptions!$D$45","v":7.2414908324905533E-2},{"$f":"BN77*Assumptions!$D$45","v":7.2863319274901639E-2},{"$f":"BO77*Assumptions!$D$45","v":7.3314506895955298E-2},{"$f":"BP77*Assumptions!$D$45","v":7.3768488381897576E-2},{"$f":"BQ77*Assumptions!$D$45","v":7.4225281033028154E-2},{"$f":"BR77*Assumptions!$D$45","v":7.4684902256774183E-2},{"$f":"BS77*Assumptions!$D$45","v":7.5147369568354175E-2},{"$f":"BT77*Assumptions!$D$45","v":2.492726393124561E-2},{"$f":"BU77*Assumptions!$D$45","v":0},{"$f":"BV77*Assumptions!$D$45","v":0},{"$f":"BW77*Assumptions!$D$45","v":0},{"$f":"BX77*Assumptions!$D$45","v":0},{"$f":"BY77*Assumptions!$D$45","v":0},{"$f":"BZ77*Assumptions!$D$45","v":0},{"$f":"CA77*Assumptions!$D$45","v":0},{"$f":"CB77*Assumptions!$D$45","v":0},{"$f":"CC77*Assumptions!$D$45","v":0},{"$f":"CD77*Assumptions!$D$45","v":0},{"$f":"CE77*Assumptions!$D$45","v":0},{"$f":"CF77*Assumptions!$D$45","v":0},{"$f":"CG77*Assumptions!$D$45","v":0},{"$f":"CH77*Assumptions!$D$45","v":0},{"$f":"CI77*Assumptions!$D$45","v":0},{"$f":"CJ77*Assumptions!$D$45","v":0},{"$f":"CK77*Assumptions!$D$45","v":0},{"$f":"CL77*Assumptions!$D$45","v":0},{"$f":"CM77*Assumptions!$D$45","v":0},{"$f":"CN77*Assumptions!$D$45","v":0},{"$f":"CO77*Assumptions!$D$45","v":0},{"$f":"CP77*Assumptions!$D$45","v":0},{"$f":"CQ77*Assumptions!$D$45","v":0},{"$f":"CR77*Assumptions!$D$45","v":0},{"$f":"CS77*Assumptions!$D$45","v":0},{"$f":"CT77*Assumptions!$D$45","v":0},{"$f":"CU77*Assumptions!$D$45","v":0},{"$f":"CV77*Assumptions!$D$45","v":0},{"$f":"CW77*Assumptions!$D$45","v":0},{"$f":"CX77*Assumptions!$D$45","v":0},{"$f":"CY77*Assumptions!$D$45","v":0},{"$f":"CZ77*Assumptions!$D$45","v":0},{"$f":"DA77*Assumptions!$D$45","v":0},{"$f":"DB77*Assumptions!$D$45","v":0},{"$f":"DC77*Assumptions!$D$45","v":0},{"$f":"DD77*Assumptions!$D$45","v":0},{"$f":"DE77*Assumptions!$D$45","v":0},{"$f":"DF77*Assumptions!$D$45","v":0}]
[null,"Total incl GST",{"$f":"Units","v":"AUD$m"},null,null,null,null,null,{"$f":"SUM(K80:DF80)","v":39.33809113891553},null,{"$f":"SUM(K77,K79)","v":0},{"$f":"SUM(L77,L79)","v":0},{"$f":"SUM(M77,M79)","v":0},{"$f":"SUM(N77,N79)","v":0},{"$f":"SUM(O77,O79)","v":0},0.39458608148731239,0.59228984374999993,0.59595744835867226,0.5996477636785067,0.60336093033982074,0.60709708984374988,0.61085638456763902,0.61463895777046929,0.61844495359831619,0.6222745170898436,0.62612779418182996,0.63000493171473093,0.6339060774382741,0.63783138001708961,0.64178098903637559,0.64575505500759933,0.64975372937423082,0.65377716451751688,0.65782551376228504,0.6618989313827891,0.6659975726085865,0.67012159363045476,0.6742711516063421,0.67844640466735873,0.68264751192380124,0.68687463347121602,0.69112793039650056,0.69540756478404275,0.69971369972189612,0.70404649930799645,0.70840612865641295,{"$f":"SUM(AU77,AU79)","v":0.71279275390364361},0.71720654221494351,0.72164766179069628,0.72611628187282329,0.73061257275123481,0.73513670577031698,0.73968885333546364,0.74426918891964378,0.74887788707001557,0.75351512341457494,0.75818107466885021,0.76287591864263482,0.76759983424676581,0.77235300149993924,0.77713560153557137,0.78194781660870061,0.78678983010293491,0.79166182653743755,0.79656399157396085,0.80149651202391803,0.8064595758555082,0.81145337220087332,0.81647809136330973,0.82153392482451593,0.82662106525189594,0.27419990324370169,0,0,0,0,0,0,{"$f":"SUM(CA77,CA79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Quarterly Access Fee per MW"]
[null,"C&E Fee","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K83:DF83)","v":41.126186190684408},null,{"$f":"IF(Assumptions!$D$27<>0,K74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,L74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,M74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,N74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,O74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,P74/Assumptions!$D$27*Thousand,0)","v":0.41252181246400837},{"$f":"IF(Assumptions!$D$27<>0,Q74/Assumptions!$D$27*Thousand,0)","v":0.61921210937499993},{"$f":"IF(Assumptions!$D$27<>0,R74/Assumptions!$D$27*Thousand,0)","v":0.62304642328406645},{"$f":"IF(Assumptions!$D$27<>0,S74/Assumptions!$D$27*Thousand,0)","v":0.62690448020934786},{"$f":"IF(Assumptions!$D$27<>0,T74/Assumptions!$D$27*Thousand,0)","v":0.6307864271734489},{"$f":"IF(Assumptions!$D$27<>0,U74/Assumptions!$D$27*Thousand,0)","v":0.63469241210937477},{"$f":"IF(Assumptions!$D$27<>0,V74/Assumptions!$D$27*Thousand,0)","v":0.6386225838661681},{"$f":"IF(Assumptions!$D$27<>0,W74/Assumptions!$D$27*Thousand,0)","v":0.64257709221458148},{"$f":"IF(Assumptions!$D$27<>0,X74/Assumptions!$D$27*Thousand,0)","v":0.64655608785278507},{"$f":"IF(Assumptions!$D$27<>0,Y74/Assumptions!$D$27*Thousand,0)","v":0.65055972241210913},{"$f":"IF(Assumptions!$D$27<>0,Z74/Assumptions!$D$27*Thousand,0)","v":0.65458814846282221},{"$f":"IF(Assumptions!$D$27<>0,AA74/Assumptions!$D$27*Thousand,0)","v":0.65864151951994587},{"$f":"IF(Assumptions!$D$27<>0,AB74/Assumptions!$D$27*Thousand,0)","v":0.66271999004910465},{"$f":"IF(Assumptions!$D$27<>0,AC74/Assumptions!$D$27*Thousand,0)","v":0.66682371547241182},{"$f":"IF(Assumptions!$D$27<>0,AD74/Assumptions!$D$27*Thousand,0)","v":0.6709528521743926},{"$f":"IF(Assumptions!$D$27<>0,AE74/Assumptions!$D$27*Thousand,0)","v":0.6751075575079446},{"$f":"IF(Assumptions!$D$27<>0,AF74/Assumptions!$D$27*Thousand,0)","v":0.67928798980033211},{"$f":"IF(Assumptions!$D$27<>0,AG74/Assumptions!$D$27*Thousand,0)","v":0.68349430835922209},{"$f":"IF(Assumptions!$D$27<>0,AH74/Assumptions!$D$27*Thousand,0)","v":0.68772667347875249},{"$f":"IF(Assumptions!$D$27<>0,AI74/Assumptions!$D$27*Thousand,0)","v":0.69198524644564319},{"$f":"IF(Assumptions!$D$27<>0,AJ74/Assumptions!$D$27*Thousand,0)","v":0.69627018954534037},{"$f":"IF(Assumptions!$D$27<>0,AK74/Assumptions!$D$27*Thousand,0)","v":0.7005816660682026},{"$f":"IF(Assumptions!$D$27<>0,AL74/Assumptions!$D$27*Thousand,0)","v":0.70491984031572119},{"$f":"IF(Assumptions!$D$27<>0,AM74/Assumptions!$D$27*Thousand,0)","v":0.70928487760678416},{"$f":"IF(Assumptions!$D$27<>0,AN74/Assumptions!$D$27*Thousand,0)","v":0.71367694428397388},{"$f":"IF(Assumptions!$D$27<>0,AO74/Assumptions!$D$27*Thousand,0)","v":0.71809620771990756},{"$f":"IF(Assumptions!$D$27<>0,AP74/Assumptions!$D$27*Thousand,0)","v":0.72254283632361416},{"$f":"IF(Assumptions!$D$27<>0,AQ74/Assumptions!$D$27*Thousand,0)","v":0.72701699954695365},{"$f":"IF(Assumptions!$D$27<>0,AR74/Assumptions!$D$27*Thousand,0)","v":0.73151886789107312},{"$f":"IF(Assumptions!$D$27<>0,AS74/Assumptions!$D$27*Thousand,0)","v":0.73604861291290524},{"$f":"IF(Assumptions!$D$27<>0,AT74/Assumptions!$D$27*Thousand,0)","v":0.74060640723170434},{"$f":"IF(Assumptions!$D$27<>0,AU74/Assumptions!$D$27*Thousand,0)","v":0.7451924245356274},{"$f":"IF(Assumptions!$D$27<>0,AV74/Assumptions!$D$27*Thousand,0)","v":0.74980683958834993},{"$f":"IF(Assumptions!$D$27<>0,AW74/Assumptions!$D$27*Thousand,0)","v":0.75444982823572793},{"$f":"IF(Assumptions!$D$27<>0,AX74/Assumptions!$D$27*Thousand,0)","v":0.75912156741249703},{"$f":"IF(Assumptions!$D$27<>0,AY74/Assumptions!$D$27*Thousand,0)","v":0.76382223514901804},{"$f":"IF(Assumptions!$D$27<>0,AZ74/Assumptions!$D$27*Thousand,0)","v":0.76855201057805855},{"$f":"IF(Assumptions!$D$27<>0,BA74/Assumptions!$D$27*Thousand,0)","v":0.77331107394162102},{"$f":"IF(Assumptions!$D$27<>0,BB74/Assumptions!$D$27*Thousand,0)","v":0.7780996065978093},{"$f":"IF(Assumptions!$D$27<>0,BC74/Assumptions!$D$27*Thousand,0)","v":0.7829177910277435},{"$f":"IF(Assumptions!$D$27<>0,BD74/Assumptions!$D$27*Thousand,0)","v":0.78776581084251007},{"$f":"IF(Assumptions!$D$27<>0,BE74/Assumptions!$D$27*Thousand,0)","v":0.79264385079016153},{"$f":"IF(Assumptions!$D$27<>0,BF74/Assumptions!$D$27*Thousand,0)","v":0.79755209676275451},{"$f":"IF(Assumptions!$D$27<>0,BG74/Assumptions!$D$27*Thousand,0)","v":0.80249073580343688},{"$f":"IF(Assumptions!$D$27<>0,BH74/Assumptions!$D$27*Thousand,0)","v":0.8074599561135728},{"$f":"IF(Assumptions!$D$27<>0,BI74/Assumptions!$D$27*Thousand,0)","v":0.81245994705991542},{"$f":"IF(Assumptions!$D$27<>0,BJ74/Assumptions!$D$27*Thousand,0)","v":0.81749089918182327},{"$f":"IF(Assumptions!$D$27<>0,BK74/Assumptions!$D$27*Thousand,0)","v":0.82255300419852284},{"$f":"IF(Assumptions!$D$27<>0,BL74/Assumptions!$D$27*Thousand,0)","v":0.82764645501641187},{"$f":"IF(Assumptions!$D$27<>0,BM74/Assumptions!$D$27*Thousand,0)","v":0.83277144573641348},{"$f":"IF(Assumptions!$D$27<>0,BN74/Assumptions!$D$27*Thousand,0)","v":0.83792817166136879},{"$f":"IF(Assumptions!$D$27<>0,BO74/Assumptions!$D$27*Thousand,0)","v":0.84311682930348575},{"$f":"IF(Assumptions!$D$27<>0,BP74/Assumptions!$D$27*Thousand,0)","v":0.84833761639182215},{"$f":"IF(Assumptions!$D$27<>0,BQ74/Assumptions!$D$27*Thousand,0)","v":0.85359073187982371},{"$f":"IF(Assumptions!$D$27<>0,BR74/Assumptions!$D$27*Thousand,0)","v":0.858876375952903},{"$f":"IF(Assumptions!$D$27<>0,BS74/Assumptions!$D$27*Thousand,0)","v":0.86419475003607282},{"$f":"IF(Assumptions!$D$27<>0,BT74/Assumptions!$D$27*Thousand,0)","v":0.28666353520932447},{"$f":"IF(Assumptions!$D$27<>0,BU74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BV74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BW74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BX74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BY74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BZ74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CA74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CB74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CC74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CD74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CE74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CF74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CG74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CH74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CI74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CJ74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CK74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CL74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CM74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CN74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CO74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CP74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CQ74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CR74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CS74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CT74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CU74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CV74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CW74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CX74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CY74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CZ74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DA74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DB74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DC74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DD74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DE74/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DF74/Assumptions!$D$27*Thousand,0)","v":0}]
[null,"SW REZ Administration Fee","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K84:DF84)","v":12.355736807723009},null,{"$f":"IF(Assumptions!$D$27<>0,K75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,L75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,M75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,N75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,O75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,P75/Assumptions!$D$27*Thousand,0)","v":0.12393590104896947},{"$f":"IF(Assumptions!$D$27<>0,Q75/Assumptions!$D$27*Thousand,0)","v":0.18603285546874995},{"$f":"IF(Assumptions!$D$27<>0,R75/Assumptions!$D$27*Thousand,0)","v":0.18718481673447387},{"$f":"IF(Assumptions!$D$27<>0,S75/Assumptions!$D$27*Thousand,0)","v":0.18834391122811275},{"$f":"IF(Assumptions!$D$27<>0,T75/Assumptions!$D$27*Thousand,0)","v":0.18951018312037096},{"$f":"IF(Assumptions!$D$27<>0,U75/Assumptions!$D$27*Thousand,0)","v":0.19068367685546869},{"$f":"IF(Assumptions!$D$27<>0,V75/Assumptions!$D$27*Thousand,0)","v":0.19186443715283572},{"$f":"IF(Assumptions!$D$27<>0,W75/Assumptions!$D$27*Thousand,0)","v":0.19305250900881557},{"$f":"IF(Assumptions!$D$27<>0,X75/Assumptions!$D$27*Thousand,0)","v":0.1942479376983802},{"$f":"IF(Assumptions!$D$27<>0,Y75/Assumptions!$D$27*Thousand,0)","v":0.19545076877685538},{"$f":"IF(Assumptions!$D$27<>0,Z75/Assumptions!$D$27*Thousand,0)","v":0.1966610480816566},{"$f":"IF(Assumptions!$D$27<>0,AA75/Assumptions!$D$27*Thousand,0)","v":0.19787882173403593},{"$f":"IF(Assumptions!$D$27<>0,AB75/Assumptions!$D$27*Thousand,0)","v":0.19910413614083969},{"$f":"IF(Assumptions!$D$27<>0,AC75/Assumptions!$D$27*Thousand,0)","v":0.20033703799627675},{"$f":"IF(Assumptions!$D$27<>0,AD75/Assumptions!$D$27*Thousand,0)","v":0.20157757428369796},{"$f":"IF(Assumptions!$D$27<>0,AE75/Assumptions!$D$27*Thousand,0)","v":0.20282579227738681},{"$f":"IF(Assumptions!$D$27<>0,AF75/Assumptions!$D$27*Thousand,0)","v":0.20408173954436065},{"$f":"IF(Assumptions!$D$27<>0,AG75/Assumptions!$D$27*Thousand,0)","v":0.20534546394618369},{"$f":"IF(Assumptions!$D$27<>0,AH75/Assumptions!$D$27*Thousand,0)","v":0.20661701364079041},{"$f":"IF(Assumptions!$D$27<>0,AI75/Assumptions!$D$27*Thousand,0)","v":0.20789643708432148},{"$f":"IF(Assumptions!$D$27<>0,AJ75/Assumptions!$D$27*Thousand,0)","v":0.20918378303296967},{"$f":"IF(Assumptions!$D$27<>0,AK75/Assumptions!$D$27*Thousand,0)","v":0.21047910054483826},{"$f":"IF(Assumptions!$D$27<>0,AL75/Assumptions!$D$27*Thousand,0)","v":0.21178243898181015},{"$f":"IF(Assumptions!$D$27<>0,AM75/Assumptions!$D$27*Thousand,0)","v":0.2130938480114295},{"$f":"IF(Assumptions!$D$27<>0,AN75/Assumptions!$D$27*Thousand,0)","v":0.21441337760879389},{"$f":"IF(Assumptions!$D$27<>0,AO75/Assumptions!$D$27*Thousand,0)","v":0.21574107805845918},{"$f":"IF(Assumptions!$D$27<>0,AP75/Assumptions!$D$27*Thousand,0)","v":0.21707699995635538},{"$f":"IF(Assumptions!$D$27<>0,AQ75/Assumptions!$D$27*Thousand,0)","v":0.21842119421171521},{"$f":"IF(Assumptions!$D$27<>0,AR75/Assumptions!$D$27*Thousand,0)","v":0.21977371204901372},{"$f":"IF(Assumptions!$D$27<>0,AS75/Assumptions!$D$27*Thousand,0)","v":0.22113460500992066},{"$f":"IF(Assumptions!$D$27<>0,AT75/Assumptions!$D$27*Thousand,0)","v":0.22250392495526422},{"$f":"IF(Assumptions!$D$27<>0,AU75/Assumptions!$D$27*Thousand,0)","v":0.22388172406700804},{"$f":"IF(Assumptions!$D$27<>0,AV75/Assumptions!$D$27*Thousand,0)","v":0.22526805485023904},{"$f":"IF(Assumptions!$D$27<>0,AW75/Assumptions!$D$27*Thousand,0)","v":0.22666297013516867},{"$f":"IF(Assumptions!$D$27<>0,AX75/Assumptions!$D$27*Thousand,0)","v":0.22806652307914582},{"$f":"IF(Assumptions!$D$27<>0,AY75/Assumptions!$D$27*Thousand,0)","v":0.22947876716868326},{"$f":"IF(Assumptions!$D$27<>0,AZ75/Assumptions!$D$27*Thousand,0)","v":0.230899756221495},{"$f":"IF(Assumptions!$D$27<>0,BA75/Assumptions!$D$27*Thousand,0)","v":0.23232954438854789},{"$f":"IF(Assumptions!$D$27<>0,BB75/Assumptions!$D$27*Thousand,0)","v":0.23376818615612446},{"$f":"IF(Assumptions!$D$27<>0,BC75/Assumptions!$D$27*Thousand,0)","v":0.23521573634790033},{"$f":"IF(Assumptions!$D$27<>0,BD75/Assumptions!$D$27*Thousand,0)","v":0.23667225012703236},{"$f":"IF(Assumptions!$D$27<>0,BE75/Assumptions!$D$27*Thousand,0)","v":0.23813778299826158},{"$f":"IF(Assumptions!$D$27<>0,BF75/Assumptions!$D$27*Thousand,0)","v":0.23961239081002755},{"$f":"IF(Assumptions!$D$27<>0,BG75/Assumptions!$D$27*Thousand,0)","v":0.24109612975659778},{"$f":"IF(Assumptions!$D$27<>0,BH75/Assumptions!$D$27*Thousand,0)","v":0.24258905638020817},{"$f":"IF(Assumptions!$D$27<>0,BI75/Assumptions!$D$27*Thousand,0)","v":0.24409122757321808},{"$f":"IF(Assumptions!$D$27<>0,BJ75/Assumptions!$D$27*Thousand,0)","v":0.24560270058027819},{"$f":"IF(Assumptions!$D$27<>0,BK75/Assumptions!$D$27*Thousand,0)","v":0.24712353300051274},{"$f":"IF(Assumptions!$D$27<>0,BL75/Assumptions!$D$27*Thousand,0)","v":0.24865378278971331},{"$f":"IF(Assumptions!$D$27<>0,BM75/Assumptions!$D$27*Thousand,0)","v":0.25019350826254855},{"$f":"IF(Assumptions!$D$27<>0,BN75/Assumptions!$D$27*Thousand,0)","v":0.25174276809478513},{"$f":"IF(Assumptions!$D$27<>0,BO75/Assumptions!$D$27*Thousand,0)","v":0.25330162132552553},{"$f":"IF(Assumptions!$D$27<>0,BP75/Assumptions!$D$27*Thousand,0)","v":0.25487012735945613},{"$f":"IF(Assumptions!$D$27<>0,BQ75/Assumptions!$D$27*Thousand,0)","v":0.25644834596911226},{"$f":"IF(Assumptions!$D$27<>0,BR75/Assumptions!$D$27*Thousand,0)","v":0.25803633729715475},{"$f":"IF(Assumptions!$D$27<>0,BS75/Assumptions!$D$27*Thousand,0)","v":0.25963416185866361},{"$f":"IF(Assumptions!$D$27<>0,BT75/Assumptions!$D$27*Thousand,0)","v":8.6123696882453568E-2},{"$f":"IF(Assumptions!$D$27<>0,BU75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BV75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BW75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BX75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BY75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BZ75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CA75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CB75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CC75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CD75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CE75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CF75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CG75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CH75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CI75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CJ75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CK75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CL75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CM75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CN75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CO75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CP75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CQ75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CR75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CS75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CT75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CU75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CV75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CW75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CX75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CY75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CZ75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DA75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DB75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DC75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DD75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DE75/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DF75/Assumptions!$D$27*Thousand,0)","v":0}]
[null,"Contribution to the NSW Electricity Infrastructure Roadmap","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K85:DF85)","v":18.041879072348085},null,{"$f":"IF(Assumptions!$D$27<>0,K76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,L76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,M76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,N76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,O76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,P76/Assumptions!$D$27*Thousand,0)","v":0.18097152555486287},{"$f":"IF(Assumptions!$D$27<>0,Q76/Assumptions!$D$27*Thousand,0)","v":0.27164566015625008},{"$f":"IF(Assumptions!$D$27<>0,R76/Assumptions!$D$27*Thousand,0)","v":0.2733277569972275},{"$f":"IF(Assumptions!$D$27<>0,S76/Assumptions!$D$27*Thousand,0)","v":0.27502026979618793},{"$f":"IF(Assumptions!$D$27<>0,T76/Assumptions!$D$27*Thousand,0)","v":0.27672326305130879},{"$f":"IF(Assumptions!$D$27<>0,U76/Assumptions!$D$27*Thousand,0)","v":0.27843680166015627},{"$f":"IF(Assumptions!$D$27<>0,V76/Assumptions!$D$27*Thousand,0)","v":0.2801609509221582},{"$f":"IF(Assumptions!$D$27<>0,W76/Assumptions!$D$27*Thousand,0)","v":0.2818957765410926},{"$f":"IF(Assumptions!$D$27<>0,X76/Assumptions!$D$27*Thousand,0)","v":0.28364134462759144},{"$f":"IF(Assumptions!$D$27<>0,Y76/Assumptions!$D$27*Thousand,0)","v":0.28539772170166017},{"$f":"IF(Assumptions!$D$27<>0,Z76/Assumptions!$D$27*Thousand,0)","v":0.28716497469521213},{"$f":"IF(Assumptions!$D$27<>0,AA76/Assumptions!$D$27*Thousand,0)","v":0.28894317095461985},{"$f":"IF(Assumptions!$D$27<>0,AB76/Assumptions!$D$27*Thousand,0)","v":0.29073237824328124},{"$f":"IF(Assumptions!$D$27<>0,AC76/Assumptions!$D$27*Thousand,0)","v":0.29253266474420164},{"$f":"IF(Assumptions!$D$27<>0,AD76/Assumptions!$D$27*Thousand,0)","v":0.29434409906259235},{"$f":"IF(Assumptions!$D$27<>0,AE76/Assumptions!$D$27*Thousand,0)","v":0.29616675022848538},{"$f":"IF(Assumptions!$D$27<>0,AF76/Assumptions!$D$27*Thousand,0)","v":0.29800068769936322},{"$f":"IF(Assumptions!$D$27<>0,AG76/Assumptions!$D$27*Thousand,0)","v":0.29984598136280671},{"$f":"IF(Assumptions!$D$27<>0,AH76/Assumptions!$D$27*Thousand,0)","v":0.30170270153915718},{"$f":"IF(Assumptions!$D$27<>0,AI76/Assumptions!$D$27*Thousand,0)","v":0.30357091898419747},{"$f":"IF(Assumptions!$D$27<>0,AJ76/Assumptions!$D$27*Thousand,0)","v":0.30545070489184728},{"$f":"IF(Assumptions!$D$27<>0,AK76/Assumptions!$D$27*Thousand,0)","v":0.30734213089687684},{"$f":"IF(Assumptions!$D$27<>0,AL76/Assumptions!$D$27*Thousand,0)","v":0.30924526907763605},{"$f":"IF(Assumptions!$D$27<>0,AM76/Assumptions!$D$27*Thousand,0)","v":0.3111601919588024},{"$f":"IF(Assumptions!$D$27<>0,AN76/Assumptions!$D$27*Thousand,0)","v":0.31308697251414347},{"$f":"IF(Assumptions!$D$27<>0,AO76/Assumptions!$D$27*Thousand,0)","v":0.31502568416929871},{"$f":"IF(Assumptions!$D$27<>0,AP76/Assumptions!$D$27*Thousand,0)","v":0.31697640080457695},{"$f":"IF(Assumptions!$D$27<>0,AQ76/Assumptions!$D$27*Thousand,0)","v":0.31893919675777244},{"$f":"IF(Assumptions!$D$27<>0,AR76/Assumptions!$D$27*Thousand,0)","v":0.32091414682699698},{"$f":"IF(Assumptions!$D$27<>0,AS76/Assumptions!$D$27*Thousand,0)","v":0.32290132627353119},{"$f":"IF(Assumptions!$D$27<>0,AT76/Assumptions!$D$27*Thousand,0)","v":0.3249008108246913},{"$f":"IF(Assumptions!$D$27<>0,AU76/Assumptions!$D$27*Thousand,0)","v":0.32691267667671664},{"$f":"IF(Assumptions!$D$27<>0,AV76/Assumptions!$D$27*Thousand,0)","v":0.32893700049767194},{"$f":"IF(Assumptions!$D$27<>0,AW76/Assumptions!$D$27*Thousand,0)","v":0.33097385943036944},{"$f":"IF(Assumptions!$D$27<>0,AX76/Assumptions!$D$27*Thousand,0)","v":0.33302333109530857},{"$f":"IF(Assumptions!$D$27<>0,AY76/Assumptions!$D$27*Thousand,0)","v":0.3350854935936346},{"$f":"IF(Assumptions!$D$27<>0,AZ76/Assumptions!$D$27*Thousand,0)","v":0.33716042551011366},{"$f":"IF(Assumptions!$D$27<>0,BA76/Assumptions!$D$27*Thousand,0)","v":0.33924820591612864},{"$f":"IF(Assumptions!$D$27<>0,BB76/Assumptions!$D$27*Thousand,0)","v":0.34134891437269127},{"$f":"IF(Assumptions!$D$27<>0,BC76/Assumptions!$D$27*Thousand,0)","v":0.34346263093347545},{"$f":"IF(Assumptions!$D$27<>0,BD76/Assumptions!$D$27*Thousand,0)","v":0.34558943614786652},{"$f":"IF(Assumptions!$D$27<>0,BE76/Assumptions!$D$27*Thousand,0)","v":0.34772941106403188},{"$f":"IF(Assumptions!$D$27<>0,BF76/Assumptions!$D$27*Thousand,0)","v":0.34988263723200858},{"$f":"IF(Assumptions!$D$27<>0,BG76/Assumptions!$D$27*Thousand,0)","v":0.35204919670681223},{"$f":"IF(Assumptions!$D$27<>0,BH76/Assumptions!$D$27*Thousand,0)","v":0.35422917205156318},{"$f":"IF(Assumptions!$D$27<>0,BI76/Assumptions!$D$27*Thousand,0)","v":0.35642264634063264},{"$f":"IF(Assumptions!$D$27<>0,BJ76/Assumptions!$D$27*Thousand,0)","v":0.35862970316280868},{"$f":"IF(Assumptions!$D$27<>0,BK76/Assumptions!$D$27*Thousand,0)","v":0.36085042662448258},{"$f":"IF(Assumptions!$D$27<>0,BL76/Assumptions!$D$27*Thousand,0)","v":0.36308490135285215},{"$f":"IF(Assumptions!$D$27<>0,BM76/Assumptions!$D$27*Thousand,0)","v":0.36533321249914852},{"$f":"IF(Assumptions!$D$27<>0,BN76/Assumptions!$D$27*Thousand,0)","v":0.36759544574187891},{"$f":"IF(Assumptions!$D$27<>0,BO76/Assumptions!$D$27*Thousand,0)","v":0.36987168729009456},{"$f":"IF(Assumptions!$D$27<>0,BP76/Assumptions!$D$27*Thousand,0)","v":0.37216202388667341},{"$f":"IF(Assumptions!$D$27<>0,BQ76/Assumptions!$D$27*Thousand,0)","v":0.37446654281162717},{"$f":"IF(Assumptions!$D$27<>0,BR76/Assumptions!$D$27*Thousand,0)","v":0.37678533188542584},{"$f":"IF(Assumptions!$D$27<>0,BS76/Assumptions!$D$27*Thousand,0)","v":0.37911847947234689},{"$f":"IF(Assumptions!$D$27<>0,BT76/Assumptions!$D$27*Thousand,0)","v":0.12575804653313413},{"$f":"IF(Assumptions!$D$27<>0,BU76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BV76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BW76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BX76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BY76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,BZ76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CA76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CB76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CC76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CD76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CE76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CF76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CG76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CH76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CI76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CJ76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CK76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CL76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CM76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CN76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CO76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CP76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CQ76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CR76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CS76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CT76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CU76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CV76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CW76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CX76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CY76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,CZ76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DA76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DB76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DC76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DD76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DE76/Assumptions!$D$27*Thousand,0)","v":0},{"$f":"IF(Assumptions!$D$27<>0,DF76/Assumptions!$D$27*Thousand,0)","v":0}]
[null,"Total Indicative Access Fee","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K86:DF86)","v":71.523802070755536},null,{"$f":"SUM(K83:K85)","v":0},{"$f":"SUM(L83:L85)","v":0},{"$f":"SUM(M83:M85)","v":0},{"$f":"SUM(N83:N85)","v":0},{"$f":"SUM(O83:O85)","v":0},{"$f":"SUM(P83:P85)","v":0.71742923906784073},1.0768906249999999,1.0835589970157677,1.0902686612336485,1.0970198733451286,1.1038128906249998,1.1106479719411619,1.1175253777644896,1.1244453701787567,1.1314082128906247,1.1384141712396909,1.1454635122086017,1.1525565044332255,1.1596934182128902,1.1668745255206829,1.1741001000138169,1.181370417044056,1.1886857536682125,1.1960463886587001,1.2034526025141621,1.2109046774701573,1.2184028975099177,1.2259475483751674,1.2335389175770159,1.2411772944069113,1.2488629699476654,1.2565962370845465,1.2643773905164413,1.2722067267670838,1.2800845441963571,1.2880111430116599,1.2959868252793521,1.3040118949362609,1.312086657801266,1.3202114215869514,1.3283864959113361,1.3366121923096672,1.3448888242462975,1.353216707126625,1.3615961583091192,1.3700274971174089,1.3785110448524549,1.3870471248047906,1.3956360622668469,1.404278184545344,1.4129738209737661,1.4217233029249101,1.4305269638235181,1.4393851391589774,1.4482981664981107,1.4572663854980328,1.4662901379191058,1.4753697676379516,1.4845056206605631,1.4936980451354835,1.5029473913670834,0.49854527862491216,0,0,0,0,0,0,0,{"$f":"SUM(CB83:CB85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"GST","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K88:DF88)","v":7.1523802070755513},null,{"$f":"K86*Assumptions!$D$45","v":0},{"$f":"L86*Assumptions!$D$45","v":0},{"$f":"M86*Assumptions!$D$45","v":0},{"$f":"N86*Assumptions!$D$45","v":0},{"$f":"O86*Assumptions!$D$45","v":0},{"$f":"P86*Assumptions!$D$45","v":7.1742923906784078E-2},{"$f":"Q86*Assumptions!$D$45","v":0.10768906249999999},{"$f":"R86*Assumptions!$D$45","v":0.10835589970157677},{"$f":"S86*Assumptions!$D$45","v":0.10902686612336486},{"$f":"T86*Assumptions!$D$45","v":0.10970198733451286},{"$f":"U86*Assumptions!$D$45","v":0.11038128906249998},{"$f":"V86*Assumptions!$D$45","v":0.1110647971941162},{"$f":"W86*Assumptions!$D$45","v":0.11175253777644896},{"$f":"X86*Assumptions!$D$45","v":0.11244453701787567},{"$f":"Y86*Assumptions!$D$45","v":0.11314082128906247},{"$f":"Z86*Assumptions!$D$45","v":0.1138414171239691},{"$f":"AA86*Assumptions!$D$45","v":0.11454635122086017},{"$f":"AB86*Assumptions!$D$45","v":0.11525565044332256},{"$f":"AC86*Assumptions!$D$45","v":0.11596934182128903},{"$f":"AD86*Assumptions!$D$45","v":0.1166874525520683},{"$f":"AE86*Assumptions!$D$45","v":0.1174100100013817},{"$f":"AF86*Assumptions!$D$45","v":0.1181370417044056},{"$f":"AG86*Assumptions!$D$45","v":0.11886857536682126},{"$f":"AH86*Assumptions!$D$45","v":0.11960463886587001},{"$f":"AI86*Assumptions!$D$45","v":0.12034526025141622},{"$f":"AJ86*Assumptions!$D$45","v":0.12109046774701573},{"$f":"AK86*Assumptions!$D$45","v":0.12184028975099177},{"$f":"AL86*Assumptions!$D$45","v":0.12259475483751675},{"$f":"AM86*Assumptions!$D$45","v":0.1233538917577016},{"$f":"AN86*Assumptions!$D$45","v":0.12411772944069113},{"$f":"AO86*Assumptions!$D$45","v":0.12488629699476655},{"$f":"AP86*Assumptions!$D$45","v":0.12565962370845465},{"$f":"AQ86*Assumptions!$D$45","v":0.12643773905164413},{"$f":"AR86*Assumptions!$D$45","v":0.12722067267670839},{"$f":"AS86*Assumptions!$D$45","v":0.12800845441963571},{"$f":"AT86*Assumptions!$D$45","v":0.128801114301166},{"$f":"AU86*Assumptions!$D$45","v":0.12959868252793522},{"$f":"AV86*Assumptions!$D$45","v":0.13040118949362609},{"$f":"AW86*Assumptions!$D$45","v":0.1312086657801266},{"$f":"AX86*Assumptions!$D$45","v":0.13202114215869515},{"$f":"AY86*Assumptions!$D$45","v":0.13283864959113362},{"$f":"AZ86*Assumptions!$D$45","v":0.13366121923096672},{"$f":"BA86*Assumptions!$D$45","v":0.13448888242462975},{"$f":"BB86*Assumptions!$D$45","v":0.13532167071266252},{"$f":"BC86*Assumptions!$D$45","v":0.13615961583091193},{"$f":"BD86*Assumptions!$D$45","v":0.1370027497117409},{"$f":"BE86*Assumptions!$D$45","v":0.13785110448524548},{"$f":"BF86*Assumptions!$D$45","v":0.13870471248047908},{"$f":"BG86*Assumptions!$D$45","v":0.13956360622668471},{"$f":"BH86*Assumptions!$D$45","v":0.14042781845453442},{"$f":"BI86*Assumptions!$D$45","v":0.14129738209737661},{"$f":"BJ86*Assumptions!$D$45","v":0.14217233029249102},{"$f":"BK86*Assumptions!$D$45","v":0.14305269638235182},{"$f":"BL86*Assumptions!$D$45","v":0.14393851391589774},{"$f":"BM86*Assumptions!$D$45","v":0.14482981664981107},{"$f":"BN86*Assumptions!$D$45","v":0.14572663854980328},{"$f":"BO86*Assumptions!$D$45","v":0.1466290137919106},{"$f":"BP86*Assumptions!$D$45","v":0.14753697676379515},{"$f":"BQ86*Assumptions!$D$45","v":0.14845056206605631},{"$f":"BR86*Assumptions!$D$45","v":0.14936980451354837},{"$f":"BS86*Assumptions!$D$45","v":0.15029473913670835},{"$f":"BT86*Assumptions!$D$45","v":4.985452786249122E-2},{"$f":"BU86*Assumptions!$D$45","v":0},{"$f":"BV86*Assumptions!$D$45","v":0},{"$f":"BW86*Assumptions!$D$45","v":0},{"$f":"BX86*Assumptions!$D$45","v":0},{"$f":"BY86*Assumptions!$D$45","v":0},{"$f":"BZ86*Assumptions!$D$45","v":0},{"$f":"CA86*Assumptions!$D$45","v":0},{"$f":"CB86*Assumptions!$D$45","v":0},{"$f":"CC86*Assumptions!$D$45","v":0},{"$f":"CD86*Assumptions!$D$45","v":0},{"$f":"CE86*Assumptions!$D$45","v":0},{"$f":"CF86*Assumptions!$D$45","v":0},{"$f":"CG86*Assumptions!$D$45","v":0},{"$f":"CH86*Assumptions!$D$45","v":0},{"$f":"CI86*Assumptions!$D$45","v":0},{"$f":"CJ86*Assumptions!$D$45","v":0},{"$f":"CK86*Assumptions!$D$45","v":0},{"$f":"CL86*Assumptions!$D$45","v":0},{"$f":"CM86*Assumptions!$D$45","v":0},{"$f":"CN86*Assumptions!$D$45","v":0},{"$f":"CO86*Assumptions!$D$45","v":0},{"$f":"CP86*Assumptions!$D$45","v":0},{"$f":"CQ86*Assumptions!$D$45","v":0},{"$f":"CR86*Assumptions!$D$45","v":0},{"$f":"CS86*Assumptions!$D$45","v":0},{"$f":"CT86*Assumptions!$D$45","v":0},{"$f":"CU86*Assumptions!$D$45","v":0},{"$f":"CV86*Assumptions!$D$45","v":0},{"$f":"CW86*Assumptions!$D$45","v":0},{"$f":"CX86*Assumptions!$D$45","v":0},{"$f":"CY86*Assumptions!$D$45","v":0},{"$f":"CZ86*Assumptions!$D$45","v":0},{"$f":"DA86*Assumptions!$D$45","v":0},{"$f":"DB86*Assumptions!$D$45","v":0},{"$f":"DC86*Assumptions!$D$45","v":0},{"$f":"DD86*Assumptions!$D$45","v":0},{"$f":"DE86*Assumptions!$D$45","v":0},{"$f":"DF86*Assumptions!$D$45","v":0}]
[null,"Total incl GST","AUD$'000/MW",null,null,null,null,null,{"$f":"SUM(K89:DF89)","v":78.67618227783106},null,{"$f":"SUM(K86,K88)","v":0},{"$f":"SUM(L86,L88)","v":0},{"$f":"SUM(M86,M88)","v":0},{"$f":"SUM(N86,N88)","v":0},{"$f":"SUM(O86,O88)","v":0},0.78917216297462478,1.1845796874999999,1.1919148967173445,1.1992955273570134,1.2067218606796415,1.2141941796874998,1.221712769135278,1.2292779155409386,1.2368899071966324,1.2445490341796872,1.2522555883636599,1.2600098634294619,1.2678121548765482,1.2756627600341792,1.2835619780727512,1.2915101100151987,1.2995074587484616,1.3075543290350338,1.3156510275245701,1.3237978627655782,1.331995145217173,1.3402431872609095,1.3485423032126842,1.3568928093347175,1.3652950238476025,1.373749266942432,1.3822558607930011,1.3908151295680855,1.3994273994437922,1.4080929986159929,1.4168122573128259,{"$f":"SUM(AU86,AU88)","v":1.4255855078072872},1.434413084429887,1.4432953235813926,1.4522325637456466,1.4612251455024696,1.470273411540634,1.4793777066709273,1.4885383778392876,1.4977557741400311,1.5070302468291499,1.5163621493377004,1.5257518372852696,1.5351996684935316,1.5447060029998785,1.5542712030711427,1.5638956332174012,1.5735796602058698,1.5833236530748751,1.5931279831479217,1.6029930240478361,1.6129191517110164,1.6229067444017466,1.6329561827266195,1.6430678496490319,1.6532421305037919,0.54839980648740339,0,0,0,0,0,0,{"$f":"SUM(CA86,CA88)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["END"]

{"sheet":"Fee Schedule - Annual","index":5,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":6},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Fee Schedule - Annual"}]
[null,"Initial Access Fee Schedule",null,null,null,"Sum Chks"]
[null,null,null,null,null,{"$f":"SUM(F63)","v":0}]
[]
["All Checks are OK"]
[]
[null,"Annexure A  Initial Access Fee Schedule"]
[null,"Annual fees in AUD$m nominal (including GST)"]
[null,"GST Included:",{"$f":"Assumptions!D44","v":1}]
[null,"Project:",{"$f":"Assumptions!D24","v":"[Insert Project Name]"}]
[null,"Date \n(annual)","C&E Fee \n($m)\n\n\n\n\n","SW REZ Administration  Fee\n($m) \n\n\n","Contribution to the NSW Electricity Infrastructure Roadmap \n($m)\n\n\n","Total Access Fee ($m)\n\n\n\n\n"]
[null,{"$f":"Calculations!$K$16","v":2026},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B13, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B13,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B13, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C13:E13)","v":0}]
[null,{"$f":"B13+1","v":2027},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B14, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.22688699685520464},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B14,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":6.8164745576933208E-2},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B14, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":9.9534339055174587E-2},{"$f":"SUM(C14:E14)","v":0.39458608148731245}]
[null,{"$f":"B14+1","v":2028},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B15, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.3749721920230249},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B15,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.41308947160343917},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B15, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.60319432250053595},2.3912559861270002]
[null,{"$f":"B15+1","v":2029},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B16, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.4093464968236002},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B16,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.42341670839352519},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B16, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.61827418056304917},2.4510373857801744]
[null,2030,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B17, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.44458015924419},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B17,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.43400212610336325},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B17, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.63373103507712547},2.5123133204246786]
[null,2031,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B18, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.4806946632252949},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B18,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.44485217925594728},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B18, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.64957431095405349},2.5751211534352958]
[null,2032,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B19, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.5177120298059272},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B19,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.45597348373734597},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B19, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.66581366872790482},2.639499182271178]
[null,2033,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B20, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.5556548305510753},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B20,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.46737282083077952},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B20, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.68245901044610235},2.7054866618279574]
[null,2034,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B21, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.5945462013148517},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B21,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.47905714135154898},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B21, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.69952048570725478},2.773123828373655]
[null,2035,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B22, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.634409856347723},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B22,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.49103356988533764},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B22, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.71700849784993614},2.8424519240829969]
[null,2036,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B23, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.6752701027564159},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B23,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.50330940913247102},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B23, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.73493371029618448},2.9135132221850712]
[null,2037,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B24, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.7171518553253262},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B24,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.51589214436078279},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B24, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.75330705305358914},2.9863510527396979]
[null,2038,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B25, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.7600806517084595},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B25,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.52878944796980232},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B25, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.7721397293799287},3.0610098290581904]
[null,2039,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B26, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.8040826680011703},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B26,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.54200918416904731},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B26, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.79144322261442679},3.137535074784644]
[null,2040,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B27, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.8491847347011998},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B27,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.55555941377327334},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B27, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.81122930317978759},3.2159734516542606]
[null,{"$f":"B27+1","v":2041},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B28, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":1.5748289661929682},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B28,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.47313339810406135},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B28, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.69087062038639369},2.7388329846834232]
[null,{"$f":"B28+1","v":2042},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B29, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B29,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B29, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2043,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B30, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B30,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B30, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2044,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B31, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B31,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B31, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2045,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B32, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B32,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B32, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2046,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B33, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B33,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B33, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2047,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B34, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B34,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B34, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2048,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B35, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B35,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B35, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,2049,{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B36, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B36,Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$16:$DF$16,$B36, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"Total Amount over the Payment Term",{"$f":"SUM(C13:C36)","v":22.619402404876432},{"$f":"SUM(D13:D36)","v":6.7956552442476585},{"$f":"SUM(E13:E36)","v":9.9230334897914485},{"$f":"SUM(F13:F36)","v":39.338091138915544}]
[]
[null,"Access Fee Profile over Payment Term (AUD$m p.a. nominal excl. GST)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Checks",null,null,null,{"$f":"N(ABS(F37-Calculations!$I$80)>=Tolerance1)","v":0}]
[]
["END"]

{"sheet":"Fee Schedule - QTR","index":6,"n_rows":117,"n_cols":6,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":7},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Fee Schedule - QTR"}]
[null,"Initial Access Fee Schedule",null,null,null,"Sum Chks"]
[null,null,null,null,null,{"$f":"SUM(F115)","v":0}]
[]
["All Checks are OK"]
[]
[null,"Annexure A  Initial Access Fee Schedule"]
[null,"Quarterly fees in AUD$M nominal (including GST)"]
[null,"GST Included:",{"$f":"Assumptions!D44","v":1}]
[null,"Project:",{"$f":"Assumptions!D24","v":"[Insert Project Name]"}]
[null,"Date \n(quarterly)","C&E Fee \n($m)\n\n\n\n\n","SW REZ Administration  Fee\n($m) \n\n\n","Contribution to the NSW Electricity Infrastructure Roadmap \n($m)\n\n\n","Total Access Fee ($m)\n\n\n\n\n"]
[null,{"$f":"Calculations!$K$2","v":"2026-03-31"},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B13, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B13, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B13, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C13:E13)","v":0}]
[null,{"$f":"EOMONTH(B13,MiP)","v":"2026-06-30"},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B14, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B14, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B14, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C14:E14)","v":0}]
[null,"2026-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B15, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B15, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B15, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C15:E15)","v":0}]
[null,"2026-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B16, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B16, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B16, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C16:E16)","v":0}]
[null,"2027-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B17, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B17, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B17, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C17:E17)","v":0}]
[null,"2027-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B18, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.22688699685520464},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B18, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":6.8164745576933208E-2},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B18, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":9.9534339055174587E-2},{"$f":"SUM(C18:E18)","v":0.39458608148731245}]
[null,"2027-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B19, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.34056666015624998},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B19, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10231807050781248},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B19, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.14940511308593757},0.59228984375000004]
[null,"2027-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B20, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.34267553280623658},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B20, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10295164920396063},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B20, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15033026634847513},0.59595744835867237]
[null,"2028-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B21, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.34479746411514134},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B21, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10358915117546202},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B21, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15126114838790339},0.5996477636785067]
[null,"2028-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B22, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.34693253494539694},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B22, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10423060071620403},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B22, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15219779467821984},0.60336093033982086]
[null,"2028-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B23, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.34908082666015616},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B23, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.1048760222705078},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B23, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15314024091308595},0.60709708984374988]
[null,"2028-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B24, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.35124242112639248},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B24, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10552544043405965},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B24, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15408852300718703},0.61085638456763913]
[null,"2029-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B25, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.35341740071801986},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B25, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10617887995484858},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B25, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15504267709760094},0.6146389577704694]
[null,"2029-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B26, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.3556058483190318},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B26, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10683636573410912},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B26, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1560027395451753},0.61844495359831619]
[null,"2029-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B27, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.35780784732666004},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B27, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10749792282727047},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B27, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15696874693591312},0.6222745170898436]
[null,"2029-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B28, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.36002348165455222},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B28, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10816357644491115},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B28, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1579407360823667},0.62612779418183007]
[null,"2030-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B29, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.36225283573597028},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B29, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10883335195371976},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B29, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15891874402504094},0.63000493171473093]
[null,"2030-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B30, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.36449599452700759},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B30, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.10950727487746184},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B30, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.15990280803380469},0.6339060774382741]
[null,"2030-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B31, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.36675304350982652},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B31, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11018537089795222},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B31, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16089296560931091},0.63783138001708961]
[null,"2030-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B32, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.36902406869591597},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B32, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11086766585603389},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B32, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16188925448442582},0.6417809890363757]
[null,"2031-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B33, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.37130915662936959},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B33, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11155418575256276},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B33, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16289171262566696},0.64575505500759933]
[null,"2031-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B34, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.37360839439018267},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B34, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11224495674939837},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B34, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16390037823464979},0.64975372937423082]
[null,"2031-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B35, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.37592186959757218},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B35, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11294000517040104},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B35, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1649152897495437},0.65377716451751688]
[null,"2031-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B36, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.37824967041331392},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B36, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11363935750243473},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B36, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16593648584653647},0.65782551376228504]
[null,"2032-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B37, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.38059188554510376},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B37, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11434304039637683},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B37, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16696400544130863},0.66189893138278921]
[null,"2032-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B38, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.38294860424993721},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B38, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11505108066813333},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B38, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16799788769051602},0.66599757260858661]
[null,"2032-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B39, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.38531991633751145},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B39, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11576350529966105},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B39, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.16903817199328228},0.67012159363045476]
[null,"2032-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B40, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.38770591217364669},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B40, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.1164803414399956},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B40, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17008489799269985},0.67427115160634221]
[null,"2033-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B41, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.39010668268373133},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B41, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11720161640628624},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B41, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17113810557734133},0.67844640466735884]
[null,"2033-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B42, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.39252231935618564},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B42, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11792735768483666},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B42, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17219783488277893},0.68264751192380124]
[null,"2033-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B43, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.39495291424594919},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B43, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11865759293215256},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B43, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1732641262931143},0.68687463347121602]
[null,"2033-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B44, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.39739855997798784},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B44, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.11939234997599546},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B44, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17433702044251734},0.69112793039650067]
[null,"2034-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B45, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.39985934975082454},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B45, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12013165681644337},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B45, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17541655821677485},0.69540756478404275]
[null,{"$f":"EOMONTH(B45,MiP)","v":"2034-06-30"},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B46, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.40233537734009023},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B46, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12087554162695756},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B46, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17650278075484835},0.69971369972189612]
[null,"2034-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B47, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.40482673710209793},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B47, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12162403275545637},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B47, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17759572945044216},0.70404649930799645]
[null,"2034-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B48, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.40733352397743744},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B48, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12237715872539533},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B48, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17869544595358022},0.70840612865641295]
[null,"2035-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B49, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.40985583349459509},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B49, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12313494823685443},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B49, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.17980197217219418},0.71279275390364372]
[null,"2035-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B50, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.41239376177359249},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B50, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12389743016763148},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B50, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18091535027371958},0.71720654221494362]
[null,"2035-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B51, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.41494740552965037},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B51, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12466463357434278},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B51, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1820356226867032},0.72164766179069639]
[null,"2035-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B52, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.41751686207687339},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B52, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12543658769353022},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B52, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18316283210241974},0.72611628187282329]
[null,"2036-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B53, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.42010222933195995},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B53, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12621332194277579},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B53, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18429702147649904},0.73061257275123481]
[null,"2036-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B54, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.42270360581793226},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B54, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12699486592182227},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B54, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18543823403056253},0.73513670577031709]
[null,"2036-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B55, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.42532109066789159},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B55, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12778124941370134},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B55, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18658651325387077},0.73968885333546364]
[null,"2036-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B56, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.42795478362879513},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B56, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.12857250238586845},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B56, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18774190290498022},0.74426918891964378]
[null,"2037-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B57, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.43060478506525895},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B57, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.1293686549913452},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B57, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.18890444701341153},0.74887788707001568]
[null,"2037-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B58, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.4332711959633806},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B58, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.1301697375698678},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B58, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1900741898813266},0.75351512341457505]
[null,"2037-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B59, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.43595411793458888},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B59, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13097578064904389},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B59, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19125117608521755},0.75818107466885032]
[null,"2037-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B60, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.43865365321951499},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B60, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13178681494551517},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B60, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19243545047760474},0.76287591864263482]
[null,"2038-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B61, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.4413699046918903},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B61, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13260287136612878},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B61, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19362705818874673},0.76759983424676581]
[null,"2038-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B62, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.44410297586246505},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B62, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13342398100911451},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B62, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19482604462835976},0.77235300149993924]
[null,"2038-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B63, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.4468529708829535},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B63, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13425017516526996},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B63, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19603245548734796},0.77713560153557137]
[null,"2038-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B64, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.44961999455000284},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B64, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13508148531915301},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B64, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19724633673954478},0.78194781660870061]
[null,"2039-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B65, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.45240415230918762},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B65, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13591794315028202},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B65, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.19846773464346543},0.78678983010293513]
[null,"2039-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B66, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.45520555025902659},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B66, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13675958053434234},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B66, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.1996966957440687},0.79166182653743755]
[null,"2039-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B67, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.45802429515502746},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B67, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13760642954440172},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B67, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.2009332668745317},0.79656399157396096]
[null,"2039-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B68, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.46086049441375287},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B68, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13845852245213183},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B68, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.2021774951580334},0.80149651202391814]
[null,"2040-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B69, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.46371425611691719},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B69, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.13931589172903905},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B69, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.20342942800955202},0.8064595758555082]
[null,"2040-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B70, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.46658568901550224},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B70, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.14017857004770087},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B70, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.20468911313767038},0.81145337220087344]
[null,"2040-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B71, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.46947490253390306},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B71, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.14104659028301175},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B71, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.20595659854639495},0.81647809136330973]
[null,"2040-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B72, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.4723820067740967},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B72, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.14191998551343513},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B72, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.20723193253698424},0.82153392482451604]
[null,"2041-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B73, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.47530711251984009},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B73, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0.142798789022265},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B73, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0.20851516370979081},0.82662106525189594]
[null,"2041-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B74, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0.15766494436512848},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B74, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":4.7368033285349463E-2},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B74, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":6.916692559322378E-2},0.27419990324370175]
[null,"2041-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B75, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B75, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B75, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2041-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B76, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B76, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B76, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2042-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B77, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B77, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B77, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,{"$f":"EOMONTH(B77,MiP)","v":"2042-06-30"},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B78, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B78, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B78, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2042-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B79, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B79, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B79, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2042-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B80, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B80, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B80, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2043-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B81, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B81, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B81, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2043-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B82, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B82, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B82, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C82:E82)","v":0}]
[null,"2043-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B83, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B83, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B83, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2043-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B84, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B84, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B84, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2044-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B85, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B85, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B85, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2044-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B86, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B86, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B86, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2044-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B87, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B87, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B87, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2044-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B88, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B88, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B88, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2045-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B89, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B89, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B89, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2045-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B90, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B90, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B90, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2045-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B91, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B91, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B91, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2045-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B92, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B92, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B92, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2046-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B93, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B93, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B93, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2046-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B94, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B94, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B94, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2046-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B95, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B95, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B95, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2046-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B96, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B96, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B96, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2047-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B97, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B97, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B97, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2047-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B98, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B98, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B98, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2047-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B99, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B99, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B99, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2047-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B100, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B100, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B100, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2048-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B101, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B101, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B101, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2048-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B102, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B102, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B102, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2048-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B103, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B103, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B103, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2048-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B104, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B104, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B104, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2049-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B105, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B105, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B105, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2049-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B106, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B106, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B106, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2049-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B107, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B107, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B107, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2049-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B108, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B108, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B108, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2050-03-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B109, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B109, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B109, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},0]
[null,"2050-06-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B110, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B110, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B110, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C110:E110)","v":0}]
[null,"2050-09-30",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B111, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B111, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B111, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C111:E111)","v":0}]
[null,"2050-12-31",{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B112, Calculations!$K$74:$DF$74)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B112, Calculations!$K$75:$DF$75)*(1+Assumptions!$D$45)","v":0},{"$f":"SUMIF(Calculations!$K$2:$DF$2,$B112, Calculations!$K$76:$DF$76)*(1+Assumptions!$D$45)","v":0},{"$f":"SUM(C112:E112)","v":0}]
[null,"Total Amount over the Payment Term",{"$f":"SUM(C13:C112)","v":22.619402404876432},{"$f":"SUM(D13:D112)","v":6.7956552442476577},{"$f":"SUM(E13:E112)","v":9.9230334897914485},{"$f":"SUM(F13:F112)","v":39.33809113891553}]
[]
[null,"Checks",null,null,null,{"$f":"N(ABS(F113-Calculations!$I$80)>=Tolerance1)","v":0}]
[]
["END"]

{"sheet":"Table","index":7,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[6,0,6,2]]}
[{"$f":"MdlTtl","v":"SW REZ - DRAFT - Access Fee Calculator"}]
[{"$f":"_xlfn.SHEET()","v":8},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"Table"}]
[null,"Lists of commonly used constants / technical inputs"]
[]
[]
[{"$f":"B25","v":"All Checks are OK"}]
[]
[]
[{"$f":"ROUNDDOWN(MAX($A$8:OFFSET(A9,-One,0),$A$2*Sht)+Sxn,0)","v":801},"Checks"]
[]
[{"$f":"MAX(A$2:OFFSET($A11,-One,0))+Sbsxn","v":801.01},"Model Checks"]
[]
[null,"Master Check ",null,null,null,null,null,null,null,null,{"$f":"SUM(K15:K16)","v":0}]
[]
[null,"Fee Schedule",null,null,null,null,null,null,null,null,{"$f":"SUM('Fee Schedule - Annual'!F4,'Fee Schedule - QTR'!F4)","v":0}]
[null,"Calculations",null,null,null,null,null,null,null,null,{"$f":"Calculations!G4","v":0}]
[]
[{"$f":"MAX(A$2:OFFSET($A18,-One,0))+Sbsxn","v":801.02},"Check Messages"]
[]
[null,"Sheet","Order",null,null,null,null,null,null,null,"Check Error"]
[null,"Fee Schedule",1,null,null,null,null,null,null,null,{"$f":"IF(K15<>0,\"OK\",)","v":0}]
[null,"Calculations",2,null,null,null,null,null,null,null,{"$f":"IF(K16<>0,\"OK\",)","v":0}]
[null,"All Checks are OK",3,null,null,null,null,null,null,null,{"$f":"COUNTIF(K21:K22,TRUE)=0","v":true}]
[]
[null,{"$f":"INDEX(B21:B23,MATCH(SUMPRODUCT((K21:K23)*(C21:C23)),C21:C23,0))","v":"All Checks are OK"}]
[]
[{"$f":"ROUNDDOWN(MAX($A$8:OFFSET(A27,-One,0),$A$2*Sht)+Sxn,0)","v":802},"Constants"]
[]
[{"$f":"MAX(A$2:OFFSET($A29,-One,0))+Sbsxn","v":802.01},"Numbers"]
[]
[null,"One",null,null,null,null,null,null,null,null,1,"[One]"]
[null,"Zero",null,null,null,null,null,null,null,null,0,"[Zero]"]
[null,"Thousand",null,null,null,null,null,null,null,null,1000,"[Thousand]"]
[null,"Million",null,null,null,null,null,null,null,null,1000000,"[Million]"]
[null,"Sheet units",null,null,null,null,null,null,null,null,100,"[Sht]"]
[null,"Section units",null,null,null,null,null,null,null,null,1,"[Sxn]"]
[null,"Sub-section units",null,null,null,null,null,null,null,null,0.01,"[Sbsxn]"]
[]
[{"$f":"MAX(A$2:OFFSET($A39,-One,0))+Sbsxn","v":802.02},"Time"]
[]
[null,"Number of days in a year",null,null,null,null,null,null,null,null,365,"[DiY]"]
[null,"Number of days in a week",null,null,null,null,null,null,null,null,7,"[DiW]"]
[null,"Number of months in a year",null,null,null,null,null,null,null,null,12,"[MiY]"]
[null,"Number of months in a quarter year",null,null,null,null,null,null,null,null,3,"[MiQ]"]
[null,"Number of weeks in a year",null,null,null,null,null,null,null,null,52,"[WiY]"]
[null,"Number of quarters on a year",null,null,null,null,null,null,null,null,4,"[QiY]"]
[null,"Months in a period",null,null,null,null,null,null,null,null,3,"[MiP]"]
[null,"Number of hours in a day",null,null,null,null,null,null,null,null,24,"[HiD]"]
[]
[{"$f":"MAX(A$2:OFFSET($A50,-One,0))+Sbsxn","v":802.03},"Project Types"]
[]
[null,"Usage note: insert additional project types as required, by inserting entire rows about the grey row"]
[]
[null,"Wind Farm",null,null,null,null,null,null,null,null,"Wind Farm"]
[null,"Solar Farm",null,null,null,null,null,null,null,null,"Solar Farm"]
[null,"Storage Project",null,null,null,null,null,null,null,null,"Storage Project"]
[null,"[Spare]",null,null,null,null,null,null,null,null,"[Spare]"]
[null,"[Spare]",null,null,null,null,null,null,null,null,"[Spare]"]
[null,"[Spare]",null,null,null,null,null,null,null,null,"[Spare]","[list_project_type]"]
[]
[]
[{"$f":"MAX(A$2:OFFSET($A62,-One,0))+Sbsxn","v":802.04},"Others"]
[]
[null,"Not applicable",null,null,null,null,null,null,null,null,"n.a.","[NA]"]
[null,"Tolerance 1",null,null,null,null,null,null,null,null,9.9999999999999995E-7,"[Tolerance1]"]
[]
[null,"Financial units",null,null,null,null,null,null,null,null,"AUD$m","[Units]"]
[]
[null,"On",null,null,null,null,null,null,null,null,1,"[On]"]
[null,"Off",null,null,null,null,null,null,null,null,0,"[Off]"]
[]
[null,"Yes",null,null,null,null,null,null,null,null,1,"[YesNo]"]
[null,"No",null,null,null,null,null,null,null,null,0]
[]
["END"]