{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ref.Tariff"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"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":"Ref.Tariff","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,10,18,11]]}
["Monthly detail","Annualised","2018-07-31",{"$f":"EOMONTH(C1,1)","v":"2018-08-31"},"2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","Total FY19",null,"ART changes","Mtpa","Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial ART",{"$f":"B20","v":76300000}]
["ARR/ Revenue Cap",{"$f":"B19","v":199563464.41605127},{"$f":"$B$3/12","v":16630288.701337606},16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,16630288.701337606,{"$f":"SUM(C3:N3)","v":199563464.41605127},null,"Change in ART",600000,"Previously approved "]
["ART:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amended ART: Aug-18 to Oct-18",{"$f":"SUM(R2:R3)","v":76900000},"Previously approved by QCA"]
[{"$f":"Q2","v":"Initial ART"},{"$f":"R2","v":76300000},{"$f":"$B5/12","v":6358333.333333333},6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,{"$f":"SUM(C5:N5)","v":76300000},null,"Change in reference tonnage 1",4319999.9999999991,"Multiple users contracted from 1 Jul-18"]
[{"$f":"Q3","v":"Change in ART"},{"$f":"R3","v":600000},0,{"$f":"$B$6/11","v":54545.454545454544},{"$f":"$B$6/11","v":54545.454545454544},{"$f":"$B$6/11","v":54545.454545454544},0,0,0,0,0,0,0,0,163636.36363636365,null,"Amended ART: Nov-18 to Dec-18",{"$f":"R2+R5","v":80620000}]
[{"$f":"Q4","v":"Amended ART: Aug-18 to Oct-18"},{"$f":"SUM(B5:B6)","v":76900000},6358333.333333333,6412878.7878787871,6412878.7878787871,6412878.7878787871,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,6358333.333333333,76463636.36363636,null,"Change in reference tonnage 2",500000,"User agreement start 1 Jan-19"]
["Change in reference tonnage 1",{"$f":"R5","v":4319999.9999999991},0,0,0,0,{"$f":"$B8/COUNT($G$1:$N$1)","v":539999.99999999988},{"$f":"$B8/COUNT($G$1:$N$1)","v":539999.99999999988},539999.99999999988,539999.99999999988,539999.99999999988,539999.99999999988,539999.99999999988,539999.99999999988,4319999.9999999991,{"$f":"O8-B8","v":0},"Change in reference tonnage 3",-2700000,"User agreement reducing from 1 Jan-19"]
["Amended ART: Nov-18 to Dec-18",{"$f":"B5+B8","v":80620000},{"$f":"SUM(C7:C8)","v":6358333.333333333},6412878.7878787871,6412878.7878787871,6412878.7878787871,6898333.333333333,6898333.333333333,6898333.333333333,6898333.333333333,6898333.333333333,6898333.333333333,6898333.333333333,6898333.333333333,80783636.36363636,null,"Amended ART: Jan-19 to Jun-19",{"$f":"SUM(R6:R8)","v":78420000}]
["Change in reference tonnage 2",{"$f":"R7","v":500000},0,0,0,0,0,0,{"$f":"$B$10/12","v":41666.666666666664},41666.666666666664,41666.666666666664,41666.666666666664,41666.666666666664,41666.666666666664,249999.99999999997,null,null,{"$f":"R5+(SUM(R7:R8)*6/12)+D21","v":3383636.3636363628}]
["Change in reference tonnage 3",{"$f":"R8","v":-2700000},0,0,0,0,0,0,{"$f":"$B$11/12","v":-225000},-225000,-225000,-225000,-225000,-225000,-1350000,null,null,{"$f":"R10-SUM(O6,O8,O10:O11)","v":0}]
["Amended ART: Jan-19 to Jun-19",{"$f":"SUM(B9:B11)","v":78420000},6358333.333333333,6412878.7878787871,6412878.7878787871,6412878.7878787871,6898333.333333333,6898333.333333333,6715000,6715000,6715000,6715000,6715000,6715000,79683636.36363636]
["Reference Tariff",null,{"$f":"C3/C12","v":2.6155106738669893},{"$f":"D3/D12","v":2.5932641566173231},2.5932641566173231,2.5932641566173231,2.4107690796817018,2.4107690796817018,2.4765880418968886,2.4765880418968886,2.4765880418968886,2.4765880418968886,2.4765880418968886,2.4765880418968886,2.5044472557118653,"Effective rate"]
["Annualised Reference Tonnes",null,{"$f":"C12*12","v":76300000},{"$f":"D12*12","v":76954545.454545438},76954545.454545438,76954545.454545438,82780000,82780000,80580000,80580000,80580000,80580000,80580000,80580000]
[null,null,null,null,null,null,null,null,null,null,"Legend:"]
[null,null,null,null,null,null,null,null,null,null,null,": Change in reference tonnage"]
[null,null,"Approved","Approved","Proposed","Proposed",null,null,null,null,null,": Actuals"]
["Reference Tariff Component","Approved","Jul-18\nonly","Aug-18\nto Oct-18","Nov-18\nto Dec-18","Jan-19\nto Jun-19","Effective\n2018-19"]
["ARR/Revenue Cap ($)",199563464.41605127,{"$f":"B19/12","v":16630288.701337606},{"$f":"(B19-C19)/11*3","v":49890866.104012817},{"$f":"(B19-C19-D19)/8*2","v":33260577.402675211},{"$f":"B19-SUM(C19:E19)","v":99781732.208025634},{"$f":"SUM(C19:F19)","v":199563464.41605127}]
["ART (t)",76300000,{"$f":"B20/12","v":6358333.333333333},{"$f":"(B20-C20)/11*3","v":19075000},{"$f":"(B20-C20-D20)/8*2","v":12716666.666666668},{"$f":"B20-SUM(C20:E20)","v":38150000},{"$f":"SUM(C20:F20)","v":76300000}]
["Change in ART (t)","No change",0,{"$f":"O6","v":163636.36363636365},{"$f":"$R$5/8*2","v":1079999.9999999998},{"$f":"($R$5/8*6)+(SUM($R$7:$R$8)/12*6)","v":2139999.9999999991},{"$f":"SUM(C21:F21)","v":3383636.3636363624},{"$f":"G21-R10","v":0}]
["Amended ART (t)","No change",{"$f":"C20+C21","v":6358333.333333333},19238636.363636363,13796666.666666668,40290000,{"$f":"G20+G21","v":79683636.36363636}]
["Reference Tariff ($/t)",{"$f":"B19/B20","v":2.6155106738669893},{"$f":"C19/C22","v":2.6155106738669893},{"$f":"D19/D22","v":2.5932641566173231},{"$f":"E19/E22","v":2.4107690796817014},2.4765880418968886,{"$f":"G19/G22","v":2.5044472557118653}]
[]
["Check to monthly detail",null,{"$f":"C23-C13","v":0},{"$f":"D23-AVERAGE(D13:E13)","v":0},{"$f":"E23-AVERAGE(G13:H13)","v":0},{"$f":"F23-AVERAGE(I13:N13)","v":0},{"$f":"G23-O13","v":0}]