{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["паспорт"," розрахунок","додаток","variablesList"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"паспорт","index":0,"n_rows":51,"n_cols":31,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,6,0,24],[1,6,1,24],[0,25,0,27],[4,23,4,24],[8,12,9,12],[4,21,4,22],[8,14,8,16],[8,17,8,19],[8,20,8,22],[7,14,7,22],[2,6,2,24],[4,26,4,27],[8,7,9,7],[6,1,7,12],[7,13,9,13],[6,13,6,22],[47,1,47,26],[43,20,43,27],[42,20,42,27],[41,20,41,27],[6,27,9,27],[8,8,9,8],[6,26,9,26],[6,24,9,24],[6,23,9,23],[8,1,9,1],[8,2,9,2],[8,5,9,5],[8,6,9,6],[8,4,9,4],[6,0,9,0],[49,1,49,26],[8,11,9,11],[41,18,42,18],[41,19,42,19],[41,14,42,14],[42,7,42,13],[41,15,42,15],[41,16,42,16],[41,17,42,17],[8,9,9,9],[8,10,9,10],[6,25,9,25],[45,1,45,26],[41,0,41,13],[8,3,9,3]]}
["ПАТ \"УКРТРАНСГАЗ\"",null,null,null,null,null,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 191"]
["Філія \"УМГ \"Київтрансгаз\"",null,null,null,null,null,"переданого Мринським ВУПЗГ та прийнятого  ПАТ \"НГВУ Чернігівнафтогаз\", ПАТ \"Чернігівгаз\", ТОВ \"ГАЗ\""]
["Мринське ВУПЗГ",null,null,null,null,null,"Маршрут № 191"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № 98/20 чинно до 05.11.2020 р.",null,null,null,null,null,null,null,null,null,"по газопроводу  \"Київ-Брянськ\"",null,null,null,null,null,null,null,null,null,null,"за період з",null,"2017-05-01",null," по","2017-05-31"]
[]
["Число місяця","Компонентний склад, % мол. ",null,null,null,null,null,null,null,null,null,null,null,"Фізико-хімічні показники газу обчислені на основі компонентного складу, 101,325 кПа",null,null,null,null,null,null,null,null,null,"Температура точки роси за вологою (Р = 3.92 МПа), °С","Температура точки роси за вуглеводнями, °С","Вміст сірководню, г/м3","Вміст меркаптанової сірки, г/м3","Вміст механічних домішок, г/м3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Густина абсолютна, кг/м3,при 20 °С, ","Температура вимірювання/згоряння при  20/25°С"]
[null,"метан, С1","етан, С2","пропан, С3","ізо-бутан, і-С4","н-бутан, н-С4","нео-пентан, нео-С5","ізо-пентан, і-С5","н-пентан, н-С5","гексани та вищі, С6+","кисень, О2","азот, N2","діоксид вуглецю, CО2",null,"Теплота згоряння нижча",null,null,"Теплота згоряння вища",null,null,"Число Воббе вище"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," ккал/м³"," МДж/м³","кВт⋅год/м³"," ккал/м³"," МДж/м³","кВт⋅год/м³"," ккал/м³"," МДж/м³","кВт⋅год/м³",null,null,null,null,null,null,null,"  "]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,8254.5143000000007,34.56,9.6,9138.2440999999999,38.26,10.627800000000001,null,null,null,null,null,null,null,null,{"$f":"SUM(B11:M11)+$K$42+$N$42","v":0}]
[2,89.362300000000005,5.5335999999999999,1.1358999999999999,0.11990000000000001,0.1875,4.5999999999999999E-3,5.1499999999999997E-2,4.2500000000000003E-2,6.7400000000000002E-2,6.3E-3,1.7027000000000001,1.7858000000000001,0.75309999999999999,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,11610,48.61,13.502800000000001,-8.1,-12.6,null,null,null,100.00000000000003]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":" "}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0,{"$f":"IF(AC14=100,\"ОК\",\" \")","v":" "}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8292.7296000000006,34.72,9.6443999999999992,9181.2363999999998,38.44,10.6778,null,null,null,null,null,null,null,null,0," "]
[9,89.324299999999994,5.5312000000000001,1.0786,0.11990000000000001,0.18679999999999999,3.3E-3,5.1999999999999998E-2,4.24E-2,9.5399999999999999E-2,7.7000000000000002E-3,1.7984,1.76,0.75339999999999996,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,11603,48.58,13.494400000000001,-10.3,-14.7,null,null,null,100,"ОК"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,null,0," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,0,0," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,null,0," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,null,0," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8290.3412000000008,34.71,9.6417000000000002,9176.4595000000008,38.42,10.6722,null,null,null,null,null,null,null,null,0," "]
[16,89.139399999999995,5.6525999999999996,1.0807,0.1188,0.18360000000000001,6.8999999999999999E-3,5.04E-2,4.1599999999999998E-2,5.6899999999999999E-2,5.7000000000000002E-3,1.8736999999999999,1.7897000000000001,0.75360000000000005,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,11582,48.49,13.4694,-14.3,-17.600000000000001,null,null,null,99.999999999999986,"ОК"]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,null,null,null,null,null,1.9910000000000001E-3,1.9499999999999999E-3,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,null,null,null,null,null,null,null,null,0," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,null,null,null,null,null,null,null,null,0,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":" "}]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,8276.0103999999992,34.65,9.625,9162.1286999999993,38.36,10.6556,null,null,null,null,null,null,null,null,0," "]
[22,89.264399999999995,5.6496000000000004,1.0685,0.11700000000000001,0.18210000000000001,7.6E-3,5.0599999999999999E-2,4.1399999999999999E-2,9.1800000000000007E-2,6.3E-3,1.7294,1.7912999999999999,0.75380000000000003,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,11610,48.61,13.502800000000001,-9,-12.7,null,null,null,100.00000000000001,"ОК"]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8297.5066000000006,34.74,9.65,9183.6249000000007,38.450000000000003,10.6806,null,null,null,null,null,null,null,null,0," "]
[29,88.967100000000002,5.5477999999999996,1.3045,0.1399,0.2326,6.8999999999999999E-3,6.2399999999999997E-2,5.4800000000000001E-2,7.3099999999999998E-2,6.1999999999999998E-3,1.8072999999999999,1.7974000000000001,0.75770000000000004,8328.5565000000006,34.869999999999997,9.6860999999999997,9217.0632999999998,38.590000000000003,10.7194,11620,48.65,13.5139,-8.6999999999999993,-11.6,null,null,null,100,"ОК"]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8328.5565000000006,34.869999999999997,9.6860999999999997,9217.0632999999998,38.590000000000003,10.7194,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8328.5565000000006,34.869999999999997,9.6860999999999997,9217.0632999999998,38.590000000000003,10.7194,null,null,null,null,null,null,null,null,0," "]
["Вміст одоранта при одоризації становить 16 г на 1 000 м³ газу",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":8291.1433228553851},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":34.713358410265435},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":9.6426008786325692},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":9177.833164551852},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":38.425751299930347},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":10.673831461125058}]
[null,null,null,null,null,null,null,"Середньозважене значення теплоти згоряння:"]
[]
[]
[null,"Начальник  Мринського ВУПЗГ                                                                                                                            Гладких В.М.                                                       01.06.2017р.                                                                        "]
[null,null,"Підрозділу підприємства, якому підпорядкована лабораторія",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Завідувач ВХАЛ                                                                                                                                                      Блуд Т.В.                                                            01.06.2017р.                                                                                                   "]
[null,null,"Лабораторія, де здійснювалось вимірювання газу",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Начальник служби ГВ та М                                                                                                                                     Шкура Ю. Г.                                                       01.06.2017р."]
[null,null,"Підрозділу, відповідального за облік газу за маршрутом",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]

{"sheet":" розрахунок","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,6,5,6],[1,0,1,5],[0,0,0,1],[3,0,5,0],[3,1,5,1],[3,2,3,5],[4,2,4,5]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 191"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Чернігівська область",null,null,null,"Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ПВВГ 124 км \"Талалаївка-Мрин\"","ГРС Ніжин","ГРС Дорогинка","ГРС Коломійцівка"]
[1,38.26,63996.55,28540.19,2501.58,2001.95,{"$f":"SUM(C7:F7)","v":97040.27}]
[2,38.44,70578.36,33570.11,2671.33,1912.56,{"$f":"SUM(C8:F8)","v":108732.36}]
[3,38.44,62215.97,31479.56,2540.2600000000002,1904.36,{"$f":"SUM(C9:F9)","v":98140.15}]
[4,38.44,66151.69,32741.08,2278.37,1769.91,102941.05]
[5,38.44,68995.7,31856.59,2373.0100000000002,1760.99,104986.29]
[6,38.44,66578.91,29494.880000000001,2232.12,1736.31,100042.22]
[7,38.44,59806.97,27372.23,1975.09,1565.36,90719.65]
[8,38.44,65957.5,29968.36,2503.91,1676.92,100106.69]
[9,38.42,78263.95,41003.910000000003,3712.41,2582.98,125563.25]
[10,38.42,103542.88,53883.97,5518.04,3990.49,166935.38]
[11,38.42,118274.16,53022.75,5240.51,3974.17,180511.59000000003]
[12,38.42,126964.9,53828.59,5323.15,3685.79,189802.43]
[13,38.42,135746.45000000001,62450.96,6238.18,4417.33,208852.91999999998]
[14,38.42,120479.73,47347.94,4376.95,3405.7,175610.32]
[15,38.42,85536.639999999999,34252.92,2631.73,2073.06,124494.34999999999]
[16,38.36,73520.75,34386.54,2595.9499999999998,1840.1,112343.34000000001]
[17,38.36,79557.259999999995,40464.730000000003,2778.6,2031.81,124832.4]
[18,38.36,83093.52,39305.629999999997,2854.1,2064.63,127317.88]
[19,38.36,79259.86,34352.54,2610.56,1820.25,118043.20999999999]
[20,38.36,79702.899999999994,34697.07,2555.31,1889.28,118844.56]
[21,38.36,72097.86,33322.5,2430.09,1749.31,109599.76]
[22,38.450000000000003,67913.73,28812.91,2026.5,1424.5,100177.64]
[23,38.450000000000003,59894.82,33366.19,1850.17,1355.06,96466.240000000005]
[24,38.450000000000003,64172.15,29332.69,2127.67,1401.19,97033.7]
[25,38.450000000000003,60841.72,31535.79,1850.15,1386.54,95614.2]
[26,38.450000000000003,69215.210000000006,32361.51,2337.6999999999998,1667.88,105582.3]
[27,38.450000000000003,61722.59,29262.52,2112.85,1679.56,94777.52]
[28,38.450000000000003,61317.06,32941.949999999997,2004.77,1456.01,97719.79]
[29,38.590000000000003,58374.720000000001,30008.02,1706.24,1243.49,91332.470000000016]
[30,38.590000000000003,56892.54,26360.35,1670.06,1182.25,86105.2]
[31,38.590000000000003,54382.66,26179.93,1720.6,1157.72,83440.91]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":2375049.7100000004},{"$f":"SUM(D7:D37)","v":1107504.9100000001},87347.96,{"$f":"SUM(F7:F37)","v":63807.459999999985},{"$f":"SUM(G7:G37)","v":3633710.040000001}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":91262534.988000005},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":42557671.745200008},{"$f":"SUMPRODUCT(B7:B37,E7:E37)","v":3356186.1428999999},{"$f":"SUMPRODUCT(B7:B37,F7:F37)","v":2451645.4169999999},{"$f":"SUMPRODUCT(B7:B37,G7:G37)","v":139628038.2931}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.425526254774681},{"$f":"D39/D38","v":38.426621282609034},{"$f":"E39/E38","v":38.423177174372469},{"$f":"F39/F38","v":38.422551485359243},38.425751299930347]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9177.7794012952872},{"$f":"D40*238.8459","v":9178.040944203909},9177.2183330724492,9177.0688898169647,9177.8331524080331]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.673757292992967},{"$f":"D40/3.6","v":10.674061467391398},10.67310477065902,10.672930968155345,10.673819805536207]

{"sheet":"додаток","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,0,9,1],[3,2,3,4],[3,1,4,1],[3,0,4,0],[5,0,8,0]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу № 191"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Чернігівська область","ПВВГ 124 км \"Талалаївка-Мрин\"",{"$f":"' розрахунок'!C40","v":38.425526254774681},{"$f":"' розрахунок'!C41","v":9177.7794012952872},{"$f":"' розрахунок'!C42","v":10.673757292992967}]
[null,"ГРС Ніжин",{"$f":"' розрахунок'!D40","v":38.426621282609034},{"$f":"' розрахунок'!D41","v":9178.040944203909},{"$f":"' розрахунок'!D42","v":10.674061467391398}]
[null,"ГРС Дорогинка",{"$f":"' розрахунок'!E40","v":38.423177174372469},{"$f":"' розрахунок'!E41","v":9177.2183330724492},{"$f":"' розрахунок'!E42","v":10.67310477065902}]
[null,"ГРС Коломійцівка",{"$f":"' розрахунок'!F40","v":38.422551485359243},{"$f":"' розрахунок'!F41","v":9177.0688898169647},{"$f":"' розрахунок'!F42","v":10.672930968155345}]
["Середньозважене значення вищої теплоти згоряння по маршруту № 191",null,{"$f":"' розрахунок'!G40","v":38.425751299930347},{"$f":"' розрахунок'!G41","v":9177.8331524080331},{"$f":"' розрахунок'!G42","v":10.673819805536207}]
[]
[]
[]
[" Начальник  Мринського ВУПЗГ                                                                          Гладких В.М.                                                                                       ",null,null,null,null,"01.06.2017р."]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
["Завідувач ВХАЛ                                                                                                        Блуд Т.В.                                                                                                       ",null,null,null,null,"01.06.2017р."]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
["Начальник служби ГВ та М                                                                                    Шкура Ю.Г.",null,null,null,null,"01.06.2017р."]
["Підрозділу, відповідального за облік газу за маршрутом",null,null,"прізвище","підпис","дата"]

{"sheet":"variablesList","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[3,"x:\\gaysin","10, 11, 24, 25, 127, 128, 132, 180, 207, 215","x:\\"]
[null,"x:\\Illinci"]
[null,"x:\\Talne"]