{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["2020 simplified model","2021 2023 Tariff evolution"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"2020 simplified model","index":0,"n_rows":95,"n_cols":15,"rows_kept":95,"cut":false,"hidden":false,"merged":[[24,4,31,7],[51,5,61,11],[85,17,88,17],[90,14,90,16],[69,1,69,8],[70,1,70,9],[81,2,81,5],[85,14,88,16],[49,5,50,11]]}
[]
[null,"DISCLAIMER - NON BINDING MODEL : This simplified model aims at presenting the spirit of the French Tariff Calculation. It is not the detailled model that CRE uses (the detailled model contains several confidential parameters that can not be shown here)"]
[]
[null,"1.  Costs to recover an entry/exit split"]
[]
[]
[null,"Allowed Revenue M€",2020]
[null,"GRTgaz",1795.9]
[null,"Teréga ",280.13]
[]
[]
[null,"Allowed Revenue Transport Services M€",2020]
[null,"GRTgaz",{"$f":"770","v":770}]
[null,"Teréga ",{"$f":"175","v":175}]
[null,"-"]
[null,"Estimated other revenues (interruptible, backhaul, intra-annual, PEG, UIOLI) M€",2020]
[null,null,41.911070000000002]
[]
[null,"="]
[null,"Total",903.08893]
[]
[null,"Entry (34%)",306.00851408835575]
[null,"Exit (66%)",597.0804159116442]
[]
[null,"2.  Firm capacities booking 2020",null,null,"DISCLAIMER : A change in the subscribed capacities presented in this file, does not make it possible to calculate properly the tariff terms using this simplified model. In fact, a significant change in subscriptions would imply a change in the flow scenarios considered by CRE in its Reference price methodology and consequently a change in distances for transit and domestic consumption. "]
[]
[null,"MWh/d/y"]
[null,"Entry Point"]
[null,"PIR",1805400]
[null,"PITTM",994000]
[null,"PITS",2401400]
[null,"Exit Point"]
[null,"PIR Oltingue",229500]
[null,"PIR Pirineos",148300]
[null,"PITS",1088400]
[null,"Exit to RN",4209500]
[]
[]
[null,"3. Distance flow scenarios 2020"]
[]
[]
[null,null,"km"]
[null,"Exit at Oltingue",762]
[null,"Exit at Pirineos",1071.9580000000001]
[null,"Exit to RN",253.09182096898999]
[]
[]
[null,"4. simplified entry tariff calculation model"]
[]
[null,null,"PIR/PITTM distance spread",0.1,null,"This spread stand for the difference of distance traveled by gas when coming from PITTM and PIR"]
[]
[null,null,"€/MWh/d per y","M€",null,"A dedicated CWD approach is applied to calculate the terms at the transport storage interface points (PITS) in the absence of flow scenarios that start and end at storage facilities. This approach includes a 80% rebate on distrances taken into account.\nFor the sake of simplicity, this calculation is not reproduce in this simplified model\n"]
[null,"PITS",9.1698934430600136,{"$f":"C31*C53/1000000","v":22.020582114164316}]
[null,"PIR",{"$f":"(C22-D53)*1000000/(C29+C30*(1-D50))","v":105.18071554599682},{"$f":"C54*C29/1000000","v":189.89326384674266}]
[null,"PITTM",{"$f":"C54*(1-D50)","v":94.662643991397132},{"$f":"C55*C30/1000000","v":94.094668127448756}]
[null,null,null,{"$f":"SUM(D53:D55)","v":306.0085140883557}]
[]
[]
[null,"5.  simplified exit tariff calculation model"]
[]
[null,null,"€/MWh/d per y","M€"]
[null,"PITS",{"$f":"C23/27.8658","v":21.426997104394786},{"$f":"C62*C35/1000000","v":23.321143648423284}]
[null,"PIR Oltingue",{"$f":"H94","v":384.94634548101021},{"$f":"C63*C33/1000000","v":88.345186287891849}]
[null,"PIR PIRINEOS",{"$f":"H93","v":584.31485411855476},{"$f":"C64*C34/1000000","v":86.653892865781671}]
[null,"Exit to RN",{"$f":"H95","v":94.728635968534832},{"$f":"C65*C36/1000000","v":398.7601931095474}]
[null,null,null,{"$f":"SUM(D62:D65)","v":597.0804159116442}]
[]
[]
[]
[null,"CRE has determined the exit tariff terms so that the unit costs for domestic and transit usage are identical. "]
[null,"To calculate the capacity weighted exit terms and the unit costs, a Matrix of 4 equations with 4 unknonws is solved . These equations are given bellow : "]
[]
[null,"Equations"]
[]
[null,"eq1 (FR-ES unit cost)  : ","Unit Cost  = (PIR Dunkerque entry tariff term + Pirineos exit tariff term)/distance at Pirineos"]
[null,"eq2 (FR-CH+ unit cost) :","Unit Cost  = (PIR Dunkerque entry tariff term + Oltingue exit tariff term)/distance at Oltingue"]
[null,"eq3 (domestic unit cost):","Unit Cost  = (average entry term to supply domestic*PIR/PITTM ratio + Entry PITS term * PITS entry ratio + Exit PITS term * PITS exit ratio + domestic exit tariff term )/domestic distance"]
[null,"eq4 (exit revenues):","Pirineos exit tariff term* pirineos capacity + Oltingue exit tariff term * Oltingue capacity + Domestic exit term * domestic capacity = Total exist revenue - other revenues (i.e PITS exit revenues)"]
[]
[]
[]
[null,"A*X=B","Input ",null,null,null,null,null,null,"Inputs "]
[null,null,"A",null,null,null,null,"X",null,"B"]
[null,null,{"$f":"C44","v":1071.9580000000001},-1,0,0,null,"Unit cost",null,{"$f":"C54","v":105.18071554599682}]
[null,null,{"$f":"C43","v":762},0,-1,0,null,"Pirineos exit term",null,{"$f":"C54","v":105.18071554599682}]
[null,null,{"$f":"C45","v":253.09182096898999},0,0,-1,null,"Oltingue exit term",null,{"$f":"N91*N87+C53*N88+C62*N89","v":68.062899965198099},null,null,"PIR vs. Transit Exit",1,"Those ratios have to be used in order to represent, for example, that you need 0,57 GWh/d annual entry capcity to supply 1 GWh/d domestic when considering unit costs"]
[null,null,0,{"$f":"C34","v":148300},{"$f":"C33","v":229500},{"$f":"C36","v":4209500},null,"Domestic exit term",null,{"$f":"(C23-D62)*1000000","v":573759272.26322091},null,null,"PIR/PITTM vs. Exit RR",{"$f":"((C29+C30)-(C33+C34))/C36","v":0.57527022211664092}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PITS Entry vs Exit RR.",{"$f":"C31/C36","v":0.57047155244090753}]
[null,null,null,null,null,null,null,"Results",null,null,null,null,"PITS Exit vs Exit RR.",{"$f":"C35/C36","v":0.25855802351823259}]
[null,"X= A-1*B","A-1",null,null,null,null,"X",null,"A*X"]
[null,null,null,null,null,null,null,null,null,null,null,null,"average entry tariff term to supply domestic (€/MWh/d/year)",{"$f":"(C54*(C29-C33-C34)+(C55*C30)-3081606)/(C29-C33-C34+C30)","v":99.590787760535918},"average tariff terms at PIR and PITTM weighted by entry capacities for domestic use (total capacities minus Dunkerque capacities used to transit) "]
[null,null,{"$f":"MINVERSE(C84:F87)","v":1.0598607706894057E-4},1.6401756363669488E-4,3.0084180136325384E-3,7.14673479898453E-10,null,{"$f":"MMULT(C92:F95,J84:J87)","v":0.64321136617717445},null,{"$f":"MMULT(C84:F87,H92:H95)","v":105.1807155459968}]
[null,null,-0.88638737679733259,0.17581993948086419,3.224897757057509,7.6609995416498593E-7,null,584.31485411855476,null,105.18071554599669]
[null,null,8.0761390726532795E-2,-0.87501861650883839,2.2924145263879945,5.4458119168262142E-7,null,384.94634548101021,null,68.062899965198056]
[null,null,2.682420924273789E-2,4.1511503851708334E-2,-0.23859400669382905,1.8087801242574439E-7,null,94.728635968534832,null,573759272.26322091]

{"sheet":"2021 2023 Tariff evolution","index":1,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[16,8,16,10],[16,12,16,14],[1,0,4,7],[5,0,9,7],[12,0,12,7],[13,0,13,7],[14,0,14,7],[16,0,16,2],[16,4,16,6]]}
["Tariff terms' evolution "]
["The tariff terms of each TSO are automatically adjusted on 1st April of every year, commencing 1st April 2021, by applying the following percentage change to all tariff terms in force on 31 March of year N: \nZ = CPI + X + k\n"]
[]
[]
[]
["Tariffs will chaqnge ; \n   • PIR :  on 1st October of each year, with an initial movement of these terms as from 1st October 2020 ;\n   •other tariffs :   on 1st April of each year;\n"]
[]
[]
[]
[]
[]
["Tariff terms' evolution"]
["CPI is the measure of inflation used for revising the schedule of tariffs on 1st April in year N, equating to the annual average change over the calendar year N-1 in the consumer price index excluding tobacco as calculated by the French national statistics office, INSEE, for all households in the whole of France"]
["X is the annual rate of change on the tariff structure set by CRE in its tariff deliberation, which incorporates the annual efficiency target that it has set for the operator"]
["k is the change in the tariff structure, expressed as a percentage, resulting from the clearing of the clawback account (CCN, subscription revenues, energy costs, etc.); k is between +2% and -2%. The references for the clawback account and the K estimation is annexed to CRE's Decision."]
[]
[2020,null,null,null,2021,null,null,null,2022,null,null,null,2023]
[]
[null,null,null,null,null,"CPI",1.6E-2,null,null,"CPI",1.7000000000000001E-2,null,null,"CPI",1.7999999999999999E-2]
[null,null,null,null,null,"X",-3.5675715344387401E-3,null,null,"X",-3.5675715344387401E-3,null,null,"X",-3.5675715344387401E-3]
[null,null,null,null,null,"K (+/- 2%)",0,null,null,"K (+/- 2%)",0,null,null,"K (+/- 2%)",0]
[null,null,null,null,null,"Total",{"$f":"SUM(G19:G21)","v":1.243242846556126E-2},null,null,"Total",{"$f":"SUM(K19:K21)","v":1.3432428465561261E-2},null,null,"Total",{"$f":"SUM(O19:O21)","v":1.4432428465561259E-2}]
[]
["€/MWh/d/y","Entry","Exit",null,"€/MWh/d/y","Entry","Exit",null,"€/MWh/d/y","Entry","Exit",null,"€/MWh/d/y","Entry","Exit"]
["PIR Dunkerque",105.18,null,null,"PIR Dunkerque",{"$f":"B25*(1+$G$22)","v":106.48764282600774},null,null,"PIR Dunkerque",{"$f":"F25*(1+$K$22)","v":107.91803047073434},null,null,"PIR Dunkerque",{"$f":"J25*(1+$O$22)","v":109.47554972564747}]
["PIR Virtualys",105.18,41.85,null,"PIR Virtualys",{"$f":"B26*(1+$G$22)","v":106.48764282600774},{"$f":"C26*(1+$G$22)","v":42.370297131283742},null,"PIR Virtualys",{"$f":"F26*(1+$K$22)","v":107.91803047073434},{"$f":"G26*(1+$K$22)","v":42.939433116564288},null,"PIR Virtualys",{"$f":"J26*(1+$O$22)","v":109.47554972564747},{"$f":"K26*(1+$O$22)","v":43.559153413370851}]
["PIR Taisnières B",81.59,null,null,"PIR Taisnières B",{"$f":"B27*(1+$G$22)","v":82.604361838505142},null,null,"PIR Taisnières B",83.713939019844204,null,null,"PIR Taisnières B",84.92213445631846]
["PIR Obergailbach",105.18,null,null,"PIR Obergailbach",106.48764282600774,null,null,"PIR Obergailbach",107.91803047073434,null,null,"PIR Obergailbach",109.47554972564747]
["PIR Oltingue",105.18,384.95,null,"PIR Oltingue",106.48764282600774,{"$f":"C29*(1+$G$22)","v":389.73586333781782},null,"PIR Oltingue",107.91803047073434,{"$f":"G29*(1+$K$22)","v":394.97096244256687},null,"PIR Oltingue",109.47554972564747,{"$f":"K29*(1+$O$22)","v":400.67135260399311}]
["PIR Pirineos",105.18,584.30999999999995,null,"PIR Pirineos",106.48764282600774,{"$f":"C30*(1+$G$22)","v":591.57439227671205},null,"PIR Pirineos",107.91803047073434,599.52067298302688,null,"PIR Pirineos",109.47554972564747,608.17321220947952]
["PITTM Dunkerque",94.66,null,null,"PITTM Dunkerque",95.836853678550028,null,null,"PITTM Dunkerque",97.124175359951622,null,null,"PITTM Dunkerque",98.525913073110743]
["PITTM Montoir",94.66,null,null,"PITTM Montoir",95.836853678550028,null,null,"PITTM Montoir",97.124175359951622,null,null,"PITTM Montoir",98.525913073110743]
["PITTM Fos",94.66,null,null,"PITTM Fos",95.836853678550028,null,null,"PITTM Fos",97.124175359951622,null,null,"PITTM Fos",98.525913073110743]
["Exit to reg. Network",null,94.73,null,"Exit to reg. Network",null,95.907723948542625,null,"Exit to reg. Network",null,97.195997589776226,null,"Exit to reg. Network",null,98.598771872129532]
["PITS Nord-Ouest",9.17,21.43,null,"PITS Nord-Ouest",9.284005369029197,21.696426942016977,null,"PITS Nord-Ouest",9.4087121070225699,21.9878626448739,null,"PITS Nord-Ouest",9.5445026714602328,22.305200899606628]
["PITS Atlantique",9.17,21.43,null,"PITS Atlantique",9.284005369029197,21.696426942016977,null,"PITS Atlantique",9.4087121070225699,21.9878626448739,null,"PITS Atlantique",9.5445026714602328,22.305200899606628]
["PITS Sud-Est",9.17,21.43,null,"PITS Sud-Est",9.284005369029197,21.696426942016977,null,"PITS Sud-Est",9.4087121070225699,21.9878626448739,null,"PITS Sud-Est",9.5445026714602328,22.305200899606628]
["PITS Nord B",9.17,21.43,null,"PITS Nord B",9.284005369029197,21.696426942016977,null,"PITS Nord B",9.4087121070225699,21.9878626448739,null,"PITS Nord B",9.5445026714602328,22.305200899606628]
["PITS Nord-Est",9.17,21.43,null,"PITS Nord-Est",9.284005369029197,21.696426942016977,null,"PITS Nord-Est",9.4087121070225699,21.9878626448739,null,"PITS Nord-Est",9.5445026714602328,22.305200899606628]
["PITS Terega",9.17,21.43,null,"PITS Terega",9.284005369029197,21.696426942016977,null,"PITS Terega",9.4087121070225699,21.9878626448739,null,"PITS Terega",9.5445026714602328,22.305200899606628]