{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Title","Model_Lw"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,8,9,14]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"GAZ-SYSTEM \nthe system that connects"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Simplified tariff model for low-methane gas (Lw)"]
["Publication in fulfilment of Article 30 of TAR NC"]
["Tariff for year 2019"]
[]
["December, 2018"]

{"sheet":"Model_Lw","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,7,6,9],[33,1,35,9]]}
[]
[]
[]
[]
[null,"Simplified Tariff Model for Low-methane gas (gas Lw)"]
[null,"Please fill in the orange fields only "]
[null,null,null,"Tariff year 2019",null,null,null,"Tariff year 2020"]
[]
[]
[null,"Allowed revenue (Projection) in PLN ","PLN",null,48396861.204922259,null,null,null,50749492]
[]
[null,"Entry/Exit split"]
[null,"Entry","%",null,0.45,null,null,null,0.5]
[]
[null,"Exit","%",null,{"$f":"1-$E$13","v":0.55000000000000004},null,null,null,{"$f":"1-$I$13","v":0.5}]
[]
[null,"Capacity/commodity split "]
[null,"Capacity","%",null,1,null,null,null,1]
[]
[null,"Commodity","%",null,{"$f":"1-$E$18","v":0},null,null,null,{"$f":"1-$I$18","v":0}]
[]
[null,"Forecast of capacity sales"]
[null,"Entry Points","[kWh/h]",null,1375942,null,null,null,1375942]
[]
[null,"Exit Points","[kWh/h]",null,1869883.8259703196,null,null,null,1869884]
[]
[null,"Reserve prices"]
[null,"Entry Points - Low-methane gas","[PLN/MWh/h]",null,{"$f":"10*0.180686404687831","v":1.8068640468783101},null,null,null,{"$f":"($I$10*$I$18*$I$13)/($I$23*8760)*100*10","v":2.1052199164522234}]
[]
[null,"Exit Points - Low-methane gas","[PLN/MWh/h]",null,{"$f":"10*0.162502914497596","v":1.62502914497596},null,null,null,{"$f":"10*($I$10*$I$18*$I$15)/($I$25*8760)*100","v":1.5491124060546562}]
[]
[]
[]
[null,"Gas transmission simplified tariff model allows for estimation of reserve prices for firm yearly contracts only. \n\nWe hereby inform that all data calculated above has been given for information only and it does not constitute an offer within the meaning of Article 66 and subsequent articles of Polish Civil Code. \n\nThe above calculated reserve prices are net prices. Above prices shall be increased by the value-added tax (VAT), at the applicable under the relevant tax regulations. \n\nSimplified tariff model for gas transmission can only be used for estimating reserve prices for standard product for an exemplary client. Due to variety of products including interruptible products and short-term products the applicable tariff may vary. from calculated. \n\nCalculated reserve prices for tariff year 2019 are to be considered indicative ones. In particular, reserve prices were not subject to approval of the relevant body in Poland, i.e. President of Energy Regulatory Office.\n\nAll the inconsistencies between the model and Publication Document might arise from the fact that the reserve prices are rounded to the fourth decimal place.\n\nThe default assumptions for tariff year 2020 are equal with the assumptions for calculating the indicative tariffs in the consultation of the proposed reference price methodology. \n\n\n"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]