{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Help sheet","Tariff kWh-d-T"],"not_rendered":{"charts":0,"images":1,"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":"Calculator","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,0,5,4]]}
[]
[]
[]
[]
[]
["TARIFF CALCULATOR ICGB"]
[]
[]
["Entry point",null,"Komotini"]
[]
["Exit point",null,"Stara Zagora"]
[]
["Product",null,"Daily"]
[]
["Flow type",null,"FFF"]
[]
["Period",null,3]
[{"$f":"IF($C$13=\"monthly\",VLOOKUP($C$17,'Help sheet'!I:J,2,0),IF($C$13=\"daily\",\"daily\",IF($C$13=\"within day\",\"within day\",IF($C$13=\"quarterly\",IFERROR(VLOOKUP($C$17,'Help sheet'!L:M,2,0),\"not allowed start of quarterly period\"),IF($C$13=\"annual\",IFERROR(VLOOKUP($C$17,'Help sheet'!O:P,2,0),\"not allowed start of annual period\"))))))","v":"daily"}]
[]
[]
[]
[]
[]
[]
[]
["Reserved capacity ",null,0,{"$f":"IF($C$13=\"Annual\",\"kWh/D/year\",IF($C$13=\"Quarterly\",\"kWh/D/quarter\",IF($C$13=\"Monthly\",\"kWh/D/month\",IF($C$13=\"Daily\",\"kWh/day\",IF($C$13=\"Within day\",\"kWh/Within day\")))))","v":"kWh/day"}]
["* Please insert the quantity for one Gas day within the relevant period"]
[]
["ENT",null,{"$f":"IF($C$9=$C$11,\"Error\",IF(AND($C$15=\"FFF\",$C$9=\"Stara Zagora\"),\"Error\",IF(AND($C$15=\"IFF\",$C$9=\"Stara Zagora\"),\"Error\",IF(AND($C$15=\"IRF\",$C$9=\"Komotini\"),\"Error\",IF($A$18=\"not allowed start of annual period\",\"Error\",INDEX('Tariff kWh-d-T'!$D$19:$I$22,MATCH(Calculator!$C$15,'Tariff kWh-d-T'!$D$19:$D$22,0),MATCH(Calculator!$C$13,'Tariff kWh-d-T'!$D$19:$I$19,0)))))))","v":3.6699999999999998E-4},"ЕUR/kWh/Gas day/Duration"]
["EXT",null,{"$f":"IF($C$9=$C$11,\"Error\",IF(AND($C$15=\"FFF\",$C$9=\"Stara Zagora\"),\"Error\",IF(AND($C$15=\"IFF\",$C$9=\"Stara Zagora\"),\"Error\",IF(AND($C$15=\"IRF\",$C$9=\"Komotini\"),\"Error\",IF($A$18=\"not allowed start of annual period\",\"Error\",INDEX('Tariff kWh-d-T'!$D$27:$I$30,MATCH(Calculator!$C$15,'Tariff kWh-d-T'!$D$27:$D$30,0),MATCH(Calculator!$C$13,'Tariff kWh-d-T'!$D$27:$I$27,0)))))))","v":1.7899999999999999E-3},"ЕUR/kWh/Gas day/Duration"]
["Total",null,{"$f":"IFERROR(C29+C30,\"Error\")","v":2.1570000000000001E-3},"ЕUR/kWh/Gas day/Duration"]
[]
[]
["ENT fee",null,{"$f":"IFERROR($C$26*C29,\"Error\")","v":0},{"$f":"IF($C$13=\"Annual\",\"EUR/year\",IF($C$13=\"Quarterly\",\"EUR/quarter\",IF($C$13=\"Monthly\",\"EUR/month\",IF($C$13=\"Daily\",\"EUR/day\",IF($C$13=\"Within day\",\"EUR/Within day\")))))","v":"EUR/day"}]
["EXT fee",null,{"$f":"IFERROR($C$26*C30,\"Error\")","v":0},{"$f":"IF($C$13=\"Annual\",\"EUR/year\",IF($C$13=\"Quarterly\",\"EUR/quarter\",IF($C$13=\"Monthly\",\"EUR/month\",IF($C$13=\"Daily\",\"EUR/day\",IF($C$13=\"Within day\",\"EUR/Within day\")))))","v":"EUR/day"}]
["Total fee",null,{"$f":"IFERROR($C$26*C31,\"Error\")","v":0},"EUR/day"]

{"sheet":"Help sheet","index":1,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,30,0,31]]}
["Entry point",null,"Exit point",null,"Product",null,"Period",null,"Id","Period duration - monthly",null,"Id","Period duration - quarterly",null,"Id","Period duration - quarterly",null,"Tariff coefficients ",null,null,"ENT/EXT coefficients"]
["Komotini",null,"Komotini",null,"Annual",null,"October 2023",null,1,"01.10.2023 - 31.10.2023",null,1,"01.10.2023 - 31.12.2023",null,1,"01.10.2023 - 30.09.2024",null,"FFF",1,null,"ENT Forward Flow",0.17]
["Stara Zagora",null,"Stara Zagora",null,"Quarterly",null,"November 2023",null,2,"01.11.2023 - 30.11.2023",null,2,"01.11.2023 - 31.01.2024",null,null,null,null,"IFF",0.9,null,"EXT Forward Flow",0.83]
[null,null,null,null,"Monthly",null,"December 2023",null,3,"01.12.2023 - 31.12.2023",null,3,"01.12.2023 - 28.02.2024",null,null,null,null,"IRF",0.15,null,"ENT Reverse Flow",0.83]
[null,null,null,null,"Daily",null,"January 2024",null,4,"01.01.2024 - 31.01.2024",null,4,"01.01.2024 - 31.03.2024",null,null,null,null,"FRF",0.25,null,"EXT Reverse Flow",0.17]
[null,null,null,null,"Within day",null,"February 2024",null,5,"01.02.2024 - 28.02.2024",null,5,"01.02.2024 - 30.04.2024"]
[null,null,null,null,null,null,"March 2024",null,6,"01.03.2024 - 31.03.2024",null,6,"01.03.2024 - 31.05.2024"]
[null,null,null,null,null,null,"April 2024",null,7,"01.04.2024 - 30.04.2024",null,7,"01.04.2024 - 30.06.2024"]
[null,null,null,null,null,null,"May 2024",null,8,"01.05.2024 - 31.05.2024",null,8,"01.05.2024 - 31.07.2024"]
[null,null,null,null,null,null,"June 2024",null,9,"01.06.2024 - 30.06.2024",null,9,"01.06.2024 - 31.08.2024"]
[null,null,null,null,null,null,"July 2024",null,10,"01.07.2024 - 31.07.2024",null,10,"01.07.2024 - 30.09.2024"]
[null,null,null,null,null,null,"August 2024",null,11,"01.08.2024 - 31.08.2024"]
[null,null,null,null,null,null,"September 2024",null,12,"01.09.2024 - 30.09.2024"]

{"sheet":"Tariff kWh-d-T","index":2,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":true,"merged":[[24,5,24,8],[6,1,6,2],[16,5,16,8]]}
[null,"Tariff coefficients ",null,null,"ENT/EXT coefficients"]
[null,"FFF",1,null,"ENT Forward Flow",0.17,null,"Hours per year",{"$f":"8760","v":8760}]
[null,"IFF",0.9,null,"EXT Forward Flow",0.83,null,"H/day",24]
[null,"IRF",0.15,null,"ENT Reverse Flow",0.83]
[null,"FRF",0.25,null,"EXT Reverse Flow",0.17]
[]
[null,"NRT(COD)"]
[null,"€/kNcm/y",16.989999999999998]
[null,"€/kWh",{"$f":"C8*9.764*10^-5","v":1.6589036E-3},"*Tariff Code, 2.5 Conversion Values"]
[]
[null,null,null,null,null,"Yearly Capacity","Quarterly capacity","Monthly capacity","Daily capacity"]
[null,null,null,null,"Days in period",365,{"$f":"F12/4","v":91.25},{"$f":"F12/12","v":30.416666666666668},1]
[]
[]
[]
[]
[null,null,null,null,null,"Coefficient"]
[null,null,null,null,null,1,1.1000000000000001,1.2,1.3]
[null,null,null,"Type of product","IP","ANNUAL","QUARTERLY","MONTHLY","DAILY"]
[null,null,null,"FFF","ENT",{"$f":"ROUND($F$2*$C$9*$I$2/$I$3,6)","v":0.102935},{"$f":"ROUND($F$2*$C$9*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":2.8306999999999999E-2},{"$f":"ROUND($F$2*$C$9*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":1.0293E-2},{"$f":"ROUND($F$2*$C$9*$I$2/$I$3*1.3/$F$12,6)","v":3.6699999999999998E-4}]
[null,null,null,"IFF","ENT",{"$f":"ROUND($F$2*$C$9*$C$3*$I$2/$I$3,6)","v":9.2641000000000001E-2},{"$f":"ROUND($F$2*$C$9*$C$3*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":2.5475999999999999E-2},{"$f":"ROUND($F$2*$C$9*$C$3*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":9.2639999999999997E-3},{"$f":"ROUND($F$2*$C$9*$C$3*$I$2/$I$3*1.3/$F$12,6)","v":3.3E-4}]
[null,null,null,"IRF","ENT",{"$f":"ROUND($F$4*$C$9*$C$4*$I$2/$I$3,6)","v":7.5384999999999994E-2},{"$f":"ROUND($F$4*$C$9*$C$4*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":2.0730999999999999E-2},{"$f":"ROUND($F$4*$C$9*$C$4*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":7.5380000000000004E-3},{"$f":"ROUND($F$4*$C$9*$C$4*$I$2/$I$3*1.3/$F$12,6)","v":2.6800000000000001E-4}]
[]
[]
[null,null,null,null,null,"Coefficient"]
[null,null,null,null,null,1,1.1000000000000001,1.2,1.3]
[null,null,null,"Type of product","IP","ANNUAL","QUARTERLY","MONTHLY","DAILY"]
[null,null,null,"FFF","EXT",{"$f":"ROUND($F$3*$C$9*$I$2/$I$3,6)","v":0.50256500000000004},{"$f":"ROUND($F$3*$C$9*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":0.13820499999999999},{"$f":"ROUND($F$3*$C$9*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":5.0256000000000002E-2},{"$f":"ROUND($F$3*$C$9*$I$2/$I$3/$F$12*1.3,6)","v":1.7899999999999999E-3}]
[null,null,null,"IFF","EXT",{"$f":"ROUND($F$3*$C$9*$C$3*$I$2/$I$3,6)","v":0.45230799999999999},{"$f":"ROUND($F$3*$C$9*$C$3*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":0.124385},{"$f":"ROUND($F$3*$C$9*$C$3*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":4.5231E-2},{"$f":"ROUND($F$3*$C$9*$C$3*$I$2/$I$3*1.3/$F$12,6)","v":1.611E-3}]
[null,null,null,"IRF","EXT",{"$f":"ROUND($F$5*$C$9*$C$4*$I$2/$I$3,6)","v":1.5440000000000001E-2},{"$f":"ROUND($F$5*$C$9*$C$4*$I$2/$I$3*1.1*$G$12/$F$12,6)","v":4.2459999999999998E-3},{"$f":"ROUND($F$5*$C$9*$C$4*$I$2/$I$3*1.2*$H$12/$F$12,6)","v":1.544E-3},{"$f":"ROUND($F$5*$C$9*$C$4*$I$2/$I$3*1.3/$F$12,6)","v":5.5000000000000002E-5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Tariffs are per Capacity products in ЕUR/kWh/Gas day/ for calendar 2022"]
[]
[null,null,null,null,"check FFF",{"$f":"(F20+F28)-ROUND($C$9*I2/I3,6)","v":0},{"$f":"(G20+G28)-ROUND($C$9*1.1*I2/I3*G12/F12,6)","v":0},{"$f":"(H20+H28)-ROUND($C$9*1.2*$H$12/$F$12*I2/I3,6)","v":-9.9999999999406119E-7},{"$f":"(I20+I28)-ROUND($C$9*1.3,6)","v":0}]
[null,null,null,null,"check IFF",{"$f":"(F21+F29)-ROUND($C$9*$C$3*I2/I3,6)","v":-1.0000000000287557E-6},{"$f":"(G21+G29)-ROUND($C$9*$C$3*1.1*I2/I3*G12/F12,6)","v":0},{"$f":"(H21+H29)-ROUND($C$9*$C$3*1.2*$H$12/$F$12*I2/I3,6)","v":0},{"$f":"(I21+I29)-ROUND($C$9*$C$3*1.3,6)","v":0}]
[null,null,null,null,"check IRF",{"$f":"(F22+F30)-ROUND($C$9*$C$4*I2/I3,6)","v":0},{"$f":"(G22+G30)-ROUND($C$9*$C$4*1.1*I2/I3*G12/F12,6)","v":0},{"$f":"(H22+H30)-ROUND($C$9*$C$4*1.2*$H$12/$F$12*I2/I3,6)","v":0},{"$f":"(I22+I30)-ROUND($C$9*$C$4*1.3,6)","v":0}]