{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["model taryfy","Arkusz1 (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"model taryfy","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,7,4,8]]}
[]
[]
[]
[null,null,null,null,"Uproszczony model taryfy EuRoPol GAZ s.a. *)"]
[null,null,null,null,null,null,null,"Proszę nacisnąć przycisk (< lub >)"]
[null,null,null,null,"Przychód regulowany","PLN",{"$f":"H6*100000","v":931943614.19244504},9319.4361419244506,null,{"$f":"G6/'Arkusz1 (2)'!F47","v":0.97145117085568955},"**)"]
[null,null,null,null,"Podział przychodu między punkty Entry/Exit","%",{"$f":"H7/1000","v":0.515069374337772},515.06937433777205]
[null,null,null,null,"Wykorzystanie zdolności technicznych SGT","%",{"$f":"H8/100","v":0.91607978845651605},91.607978845651601]
[]
[null,null,null,null,"Ceny referencyjne (stawki opłat przesyłowych):"]
[null,null,null,null,"Kondratki ENTRY","PLN/MWh/d",{"$f":"'Arkusz1 (2)'!M44","v":1.3884820892509955},"gr/kWh/h",{"$f":"G11/10","v":0.13884820892509955},{"$f":"G11/'Arkusz1 (2)'!F44","v":0.97145117085568933},"**)"]
[null,null,null,null,"PWP EXIT","PLN/MWh/d",{"$f":"'Arkusz1 (2)'!M45","v":0.45969509606057279},"gr/kWh/h",{"$f":"G12/10","v":4.5969509606057279E-2},{"$f":"G12/'Arkusz1 (2)'!F45","v":0.97145117085568833},"**)"]
[null,null,null,null,"Mallnow ENTRY/EXIT","PLN/MWh/d",{"$f":"'Arkusz1 (2)'!M46","v":1.3884786160676093},"gr/kWh/h",0.13884786160676094,{"$f":"G13/'Arkusz1 (2)'!F46","v":0.97145117085568933},"**)"]
[]
[null,null,null,null,"*) dane różne od danych indykatywnych mają charakter hipotetyczny (do symulacji zmian taryfy w stosunku założeń Dokumentu publikacyjnego)"]
[null,null,null,null,"**) dane indykatywne zgodne z Dokumentem konsultacyjnym = 100%"]

{"sheet":"Arkusz1 (2)","index":1,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":true,"merged":[[24,2,27,2],[36,2,38,2],[43,2,45,2],[7,4,7,6],[6,4,6,6]]}
[null,null,null,null,null,"cieplo spal",10.5]
[]
[]
[]
[null,null,null,null,"Dystanse/moce/punkt fizyczny"]
[]
[null,null,null,null,"punkty wejścia do SGT"]
[null,null,null,null,"Kondratki"]
[null,null,null,null,"km","mld m3","MWh"]
[null,null,"punkty ","Lwówek",581.6,1.18,{"$f":"J10","v":12389999.999999994},{"$f":"G10/$G$14","v":3.2706109254352807E-2},3.2706109254352807E-2,{"$f":"$J$27*$J$29*I10","v":12389999.999999994},null,12389999.999999994]
[null,null,"wyjścia","Włocławek",367.4,1.7,{"$f":"J11","v":17849999.999999989},{"$f":"G11/$G$14","v":4.7118970959660812E-2},4.7118970959660812E-2,{"$f":"$J$27*$J$29*I11","v":17849999.999999989},null,17849999.999999989]
[null,null,"z SGT","Mallnov",683.9,{"$f":"28.76+1.285","v":30.045000000000002},315472499.99999988,0.83275851910765264,0.83275851910765264,315472499.99999988,null,315472499.99999988]
[null,null,null,null,null,"razem",{"$f":"SUM(G10:G12)","v":345712499.99999988},{"$f":"(G14-G13)/G14","v":8.7416400678333658E-2},8.7416400678333658E-2,33115807.080000103]
[null,null,null,null,null,"wykorz z rewersem",378828307.07999998,1,null,{"$f":"SUM(J10:J13)","v":378828307.07999998}]
[null,null,null,null,"Dystanse ważone mocami/punkt wyjścia"]
[]
[null,null,null,null,"dystans x moc","waga %"]
[null,null,"punkty ","Lwówek",{"$f":"E10*G10","v":7206023999.9999971},{"$f":"E18/$E$21","v":3.1396641790694832E-2}]
[null,null,"wyjścia","Włocławek",{"$f":"E11*G11","v":6558089999.9999952},{"$f":"E19/$E$21","v":2.8573593782249104E-2}]
[null,null,"z SGT","Mallnov",{"$f":"E12*G12","v":215751642749.99991},{"$f":"E20/$E$21","v":0.94002976442705599}]
[null,null,null,null,{"$f":"SUM(E18:E20)","v":229515756749.99991},{"$f":"SUM(F18:F20)","v":0.99999999999999989}]
[]
[null,null,null,null,"moce / punkt ",null,null,null,"inne",{"$f":"J24-G13","v":33115807.080000103}]
[null,null,null,null,"MWh","dystanse ważone mocami","waga dla punktu",null,null,378828307.07999998]
[null,null,"punkty \nSGT","Kondratki",{"$f":"G12+G11+G10","v":345712499.99999988},{"$f":"(G10*E10+G11*E11+G12*E12)/(G10+G11+G12)","v":663.89198177676531},{"$f":"(E25*F25)/(E25*F25)","v":1}]
[null,null,null,"PWP",{"$f":"G10+G11","v":30239999.999999985},{"$f":"(E10*G10+E11*G11)/(G10+G11)","v":455.16249999999997},{"$f":"(E26*F26)/(E28*F28+E26*F26+E27*F31)","v":5.9970235572943939E-2}]
[null,null,null,"PWP",null,null,null,null,"zdolnośc techn",413532000]
[null,null,null,"Mallnow",{"$f":"G12","v":315472499.99999988},{"$f":"E12*G12/E28","v":683.9},{"$f":"(E28*F28)/(E28*F28+E26*F26+E27*F31)","v":0.94002976442705599},null,"wykorz obecne",0.91607978845651605]
[null,null,null,null,null,null,null,null,"wykorz progn",{"$f":"'model taryfy'!G8","v":0.91607978845651605}]
[null,null,null,null,null,"punkty wejścia","punkty wyjścia"]
[null,null,null,"podział we/wy",1,{"$f":"'model taryfy'!G7","v":0.515069374337772},{"$f":"1-F31","v":0.484930625662228}]
[null,null,null,"przychód regulowany",{"$f":"'model taryfy'!G6","v":931943614.19244504},{"$f":"E32*F31","v":480015614.28018463},{"$f":"E32*G31","v":451927999.91226041}]
[]
[]
[null,null,null,null,"przychód / punkt"]
[null,null,null,null,"PLN"]
[null,null,"punkty \nSGT","Kondratki",{"$f":"G25*$F$32","v":480015614.28018463},{"$f":"E37/$E$40","v":0.515069374337772}]
[null,null,null,"PWP",{"$f":"G26*$G$32","v":27102228.616747644},{"$f":"E38/$E$40","v":2.9081403857498907E-2}]
[null,null,null,"Mallnow",{"$f":"G28*$G$32","v":424825771.29551274},0.45584922180472909]
[null,null,null,null,{"$f":"SUM(E37:E39)","v":931943614.19244504},{"$f":"SUM(F37:F39)","v":1}]
[]
[null,null,null,null,"Stawki taryfowe / punkt"]
[null,null,null,null,"PLN/MWh","obecne (2018)","nowe","stare"]
[null,null,"punkty \nSGT","Kondratki",{"$f":"E37/E25","v":1.3884820892509955},1.4292865466701432,{"$f":"E44*E25","v":480015614.28018463},{"$f":"F44*E25","v":494122225.26570171},null,{"$f":"H44/$E$40","v":0.53020613880580347},{"$f":"E32*F31/E25","v":1.3884820892509955},{"$f":"K44*E25","v":480015614.28018463},{"$f":"E32*F31/E25","v":1.3884820892509955},{"$f":"M44*E25","v":480015614.28018463},{"$f":"'model taryfy'!G6*'model taryfy'!G7/'Arkusz1 (2)'!E25","v":1.3884820892509955}]
[null,null,null,"PWP",{"$f":"E38/E26","v":0.8962377188077929},0.47320453137717378,{"$f":"E45*E26","v":27102228.616747644},{"$f":"F45*E26","v":14309705.028845727},{"$f":"H45/($H$45+$H$46)","v":3.0759722140629865E-2},{"$f":"H45/$E$40","v":1.535468971612138E-2},{"$f":"L45/E26","v":0.45965886279847595},{"$f":"G31*E32-L46","v":13900084.011025906},{"$f":"(E40-N44-N46)/E26","v":0.45969509606057279},{"$f":"M45*E26","v":13901179.704871714},{"$f":"('model taryfy'!G6*(1-'model taryfy'!G7)-O46*'Arkusz1 (2)'!E28)/'Arkusz1 (2)'!E26","v":0.45965886279847595}]
[null,null,null,"Mallnow",{"$f":"E39/E28","v":1.3466332922695732},1.4292829714174795,{"$f":"E46*E28","v":424825771.29551274},{"$f":"F46*E28","v":450899472.20050061},{"$f":"H46/($H$45+$H$46)","v":0.96924027785937017},0.48382698838622068,{"$f":"K44","v":1.3884820892509955},{"$f":"K46*E28","v":438027915.90123451},{"$f":"(G28*E32)/E28-M44","v":1.3884786160676093},{"$f":"M46*E28","v":438026820.2073887},{"$f":"O44","v":1.3884820892509955}]
[null,null,null,null,null,959331402.49504793,null,{"$f":"SUM(H44:H46)","v":959331402.49504805}]
[]
[]
[null,null,null,null,null,null,null,null,null,"staw jedn"]
[null,null,null,"pgnig",{"$f":"E26*E45+E26*E44","v":69089926.995697722},57531330.20015084,{"$f":"(M44+M45)*E26","v":55888878.083821796},{"$f":"F51/$F$53","v":5.997023557294405E-2},{"$f":"G51/$G$53","v":5.9970235572944036E-2},{"$f":"G51/(E18+E19)","v":4.060477709195218E-3}]
[null,null,null,"gex",{"$f":"E28*(E44+E46)","v":862853687.19674718},901800072.2948972,{"$f":"(M44+M46)*E28","v":876054736.10862315},{"$f":"F52/$F$53","v":0.94002976442705599},{"$f":"G52/$G$53","v":0.94002976442705599},{"$f":"G52/E20","v":4.0604777091952111E-3}]
[null,null,null,null,{"$f":"SUM(E51:E52)","v":931943614.19244492},959331402.49504805,{"$f":"SUM(G51:G52)","v":931943614.19244492},1,1]
[]
[]
[]
[]
[]
[null,{"$f":"B51*$F$32/2","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B59/E27","v":{"$error":"#DIV/0!"}}]