{"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":48,"n_cols":31,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,12,3,16],[6,0,9,0],[46,1,46,26],[8,11,9,11],[38,18,39,18],[38,19,39,19],[38,14,39,14],[39,7,39,13],[38,15,39,15],[38,16,39,16],[38,17,39,17],[8,9,9,9],[8,10,9,10],[6,25,9,25],[42,1,42,26],[38,0,38,13],[44,1,44,26],[40,20,40,27],[39,20,39,27],[38,20,38,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],[4,21,4,27],[0,6,0,24],[1,6,1,24],[0,25,0,27],[8,12,9,12],[8,14,8,16],[8,17,8,19],[8,20,8,22],[7,14,7,22],[2,6,2,24],[8,7,9,7],[6,1,7,12],[7,13,9,13],[6,13,6,22],[8,3,9,3],[4,10,4,19]]}
["ПАТ \"УКРТРАНСГАЗ\"",null,null,null,null,null,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 687"]
["Філія \"УМГ \"ХАРКІВТРАНСГАЗ\"",null,null,null,null,null,"переданого Херсонським ЛВУМГ  та прийнятого ПАТ \" Херсонгаз\"  точка відбору  ГРС Верхній Рогачик"]
["Херсонське ЛВУМГ"]
["Вимірювальна хіміко-аналітична лабораторія",null,null,null,null,null,null,null,null,null,null,null,"Маршрут № 687"]
["Свідоцтво про атестацію РЧ 161/2015   дійсне до  01.01.2019 р.",null,null,null,null,null,null,null,null,null," по газопроводу     ШДКРІ - Запорізька ГРЕС - Мелітополь",null,null,null,null,null,null,null,null,null,null,"за період   з   01.02.2017р.   по   28.02.2017р."]
[]
["Число місяця","Компонентний склад, % мол. ",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\n","Вміст меркаптанової сірки, г/м3\n","Вміст механічних домішок, г/м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," ккал/м3"," МДж/м3","кВт⋅год/м3"," ккал/м3"," МДж/м3","кВт⋅год/м3"," ккал/м3"," МДж/м3","кВт⋅год/м3",null,null,null,null,null,null,null,"  "]
[1,95.691400000000002,2.2706,0.7107,0.1076,0.1178,1.4E-3,2.5899999999999999E-2,2.0400000000000001E-2,1.4999999999999999E-2,8.3999999999999995E-3,0.85089999999999999,0.18,0.70179999999999998,8189,34.286999999999999,{"$f":"P11/3.6","v":9.524166666666666},9077,38,{"$f":"S11/3.6","v":10.555555555555555},{"$f":"V11/0.0041868","v":11890.919079010222},49.7849,{"$f":"V11/3.6","v":13.829138888888888},-24,-18.5,null,null,null,{"$f":"SUM(B11:M11)+$K$39+$N$39","v":100.0001}]
[2,95.725300000000004,2.2450000000000001,0.70209999999999995,0.10630000000000001,0.1153,1.4E-3,2.6200000000000001E-2,2.0299999999999999E-2,1.38E-2,7.4000000000000003E-3,0.85829999999999995,0.1787,0.70140000000000002,8185,34.270000000000003,9.5194444444444457,9072,37.979999999999997,10.549999999999999,11887.981274481703,49.772599999999997,13.825722222222222,-24.1,-18.5,null,null,null,100.00010000000005]
[3,95.952100000000002,2.1234000000000002,0.66349999999999998,0.10150000000000001,0.1079,1E-3,2.41E-2,1.8800000000000001E-2,8.3000000000000001E-3,8.2000000000000007E-3,0.82530000000000003,0.1658,0.69950000000000001,8172,34.21,9.5027777777777782,9058,37.92,10.533333333333333,11885.42562338779,49.761899999999997,13.822749999999999,-24,-18.7,null,null,null,99.999900000000025,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":" "}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,8172,34.21,9.5027777777777782,9058,37.92,10.533333333333333,11884.971816184197,49.76,13.822222222222221,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,8172,34.21,9.5027777777777782,9058,37.92,10.533333333333333,11884.971816184197,49.76,13.822222222222221,null,null,null,null,null,0," "]
[6,96.338200000000001,1.9053,0.5948,9.3600000000000003E-2,9.4399999999999998E-2,8.0000000000000004E-4,1.9599999999999999E-2,1.54E-2,5.3E-3,1.01E-2,0.77370000000000005,0.1489,0.69630000000000003,8148,34.11,9.4749999999999996,9032,37.816000000000003,10.504444444444445,11879.382822203115,49.736600000000003,13.815722222222222,-23.2,-17.3,null,null,"відсутні",100.00009999999999," "]
[7,96.246700000000004,1.9533,0.60489999999999999,9.3799999999999994E-2,9.5100000000000004E-2,1.2999999999999999E-3,1.95E-2,1.43E-2,1.2200000000000001E-2,1.3599999999999999E-2,0.79049999999999998,0.15490000000000001,0.69710000000000005,8152.77,34.130000000000003,9.4805555555555561,9041.5400000000009,37.86,10.516666666666666,11884.78,49.76,13.822222222222221,-25.1,-18.8,null,null,null,100.0001," "]
[8,96.382199999999997,1.8823000000000001,0.57350000000000001,8.9700000000000002E-2,8.9399999999999993E-2,1.1999999999999999E-3,1.78E-2,1.3100000000000001E-2,1.1900000000000001E-2,1.1299999999999999E-2,0.78759999999999997,0.1399,0.69589999999999996,8143.36,34.0946,9.4707222222222214,9031.5499999999993,37.81,10.502777777777778,11882.2,49.75,13.819444444444445,-24.7,-18.7,"< 0,0001",1.6999999999999999E-3,null,99.999899999999968," "]
[9,95.623000000000005,2.2736000000000001,0.68289999999999995,9.64E-2,0.109,1.5E-3,2.3800000000000002E-2,1.89E-2,2.0199999999999999E-2,1.0200000000000001E-2,0.97270000000000001,0.16789999999999999,0.70169999999999999,8174.91,34.229999999999997,9.5083333333333329,9064.66,37.950000000000003,10.541666666666668,11876.3,49.72,13.81111111111111,-24.8,-19.5,null,null,null,100.0001," "]
[10,93.710899999999995,3.5377000000000001,0.94430000000000003,0.1087,0.129,1.5E-3,2.6700000000000002E-2,2.18E-2,2.8899999999999999E-2,3.3E-3,1.2948999999999999,0.1923,0.71499999999999997,8269.42,34.619999999999997,9.6166666666666654,9164.85,38.369999999999997,10.658333333333333,11895.39,49.8,13.833333333333332,-23.6,-18.8,null,null,null,99.999999999999986,"ОК"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8269.42,34.619999999999997,{"$f":"P21/3.6","v":9.6166666666666654},9164.85,38.369999999999997,10.658333333333333,11895.39,49.8,13.833333333333332,null,null,null,null,null,0," "]
[12,94.555300000000003,2.6917,0.74819999999999998,9.3700000000000006E-2,0.11360000000000001,1.2999999999999999E-3,2.6700000000000002E-2,2.1899999999999999E-2,3.1800000000000002E-2,1.3599999999999999E-2,1.4377,0.26450000000000001,0.70889999999999997,8169.34,34.200000000000003,9.5,9056.94,37.918999999999997,10.533055555555555,11805.84,49.429000000000002,13.730277777777777,null,null,null,null,null,100.00000000000001,"ОК"]
[13,94.915899999999993,2.5238,0.71599999999999997,9.3799999999999994E-2,0.1087,1.2999999999999999E-3,2.4299999999999999E-2,1.9699999999999999E-2,2.8500000000000001E-2,1.3599999999999999E-2,1.2989999999999999,0.25540000000000002,0.70640000000000003,8163.63,34.179000000000002,{"$f":"P23/3.6","v":9.4941666666666666},9051.2999999999993,37.896000000000001,10.526666666666667,11818.91,49.48,13.744444444444444,-20.7,-15,null,null,null,99.999999999999972,"ОК"]
[14,95.838099999999997,2.1061999999999999,0.6169,8.8200000000000001E-2,9.3299999999999994E-2,1.1000000000000001E-3,0.02,1.5100000000000001E-2,1.78E-2,1.5100000000000001E-2,1.0005999999999999,0.18759999999999999,0.6996,8144.88,34.1,{"$f":"P24/3.6","v":9.4722222222222232},9032.34,37.82,10.505555555555555,11851.15,49.62,13.783333333333331,-20.8,-15.3,null,null,null,100,"ОК"]
[15,95.923400000000001,2.0636999999999999,0.60009999999999997,8.6499999999999994E-2,9.11E-2,1.1000000000000001E-3,1.9400000000000001E-2,1.4800000000000001E-2,1.52E-2,1.37E-2,0.98799999999999999,0.183,0.69889999999999997,8139.92,34.08,{"$f":"P25/3.6","v":9.4666666666666668},9027.09,37.794600000000003,10.4985,11850.48,49.615600000000001,13.78211111111111,-20.9,-15.5,null,null,null,99.999999999999986,"ОК"]
[16,95.662400000000005,2.1863999999999999,0.627,8.6999999999999994E-2,9.3700000000000006E-2,1.1999999999999999E-3,0.02,1.55E-2,1.6799999999999999E-2,1.34E-2,1.0778000000000001,0.19869999999999999,0.70069999999999999,8143.88,34.095999999999997,9.4711111111111101,9031,37.81,10.502777777777778,11840.43,49.57,13.769444444444444,-21.7,-16.3,null,null,"відсутні",99.999900000000011," "]
[17,94.806600000000003,2.8170999999999999,0.79390000000000005,9.98E-2,0.1137,1.5E-3,2.4E-2,1.8499999999999999E-2,2.63E-2,8.8999999999999999E-3,1.0972999999999999,0.19239999999999999,0.70740000000000003,8214.24,34.39,9.5527777777777771,9106.36,38.1265,10.590694444444445,11882.66,49.75,13.819444444444445,-22.3,-16.8,null,null,null,100,"ОК"]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8214.24,34.39,9.5527777777777771,9106.36,38.1265,10.590694444444445,11882.66,49.75,13.819444444444445,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8214.24,34.39,9.5527777777777771,9106.36,38.1265,10.590694444444445,11882.66,49.75,13.819444444444445,null,null,null,null,null,0," "]
[20,95.034199999999998,2.7046999999999999,0.76180000000000003,9.74E-2,0.10680000000000001,1.5E-3,2.2200000000000001E-2,1.67E-2,2.1999999999999999E-2,8.8000000000000005E-3,1.0481,0.17580000000000001,0.70550000000000002,8204.52,34.35,9.5416666666666661,9096.14,38.08,10.577777777777778,11884.9,49.759,13.821944444444444,-21.3,-15.5,null,null,null,99.999999999999986,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":"ОК"}]
[21,95.391400000000004,2.5131000000000001,0.72970000000000002,9.8699999999999996E-2,0.106,1.5E-3,2.1700000000000001E-2,1.6E-2,1.7899999999999999E-2,8.3000000000000001E-3,0.92010000000000003,0.17560000000000001,0.70320000000000005,8197.41,34.32,9.5333333333333332,9088.92,38.049999999999997,10.569444444444443,11894.72,49.8,13.833333333333332,-21.1,-15,null,null,null,99.999999999999986,"ОК"]
[22,96.123199999999997,2.0701999999999998,0.63019999999999998,9.6100000000000005E-2,9.9199999999999997E-2,1.6000000000000001E-3,2.0199999999999999E-2,1.46E-2,1.4800000000000001E-2,7.4999999999999997E-3,0.76080000000000003,0.1618,0.69820000000000004,8167.79,34.196899999999999,9.4991388888888881,9057.75,37.923000000000002,10.534166666666668,11896.75,49.8093,13.835916666666666,-21.3,-15.2,null,null,null,100.00019999999999," "]
[23,96.382000000000005,1.9017999999999999,0.57369999999999999,8.5800000000000001E-2,8.6800000000000002E-2,1.1999999999999999E-3,1.66E-2,1.1900000000000001E-2,1.09E-2,9.1000000000000004E-3,0.77170000000000005,0.14849999999999999,0.69579999999999997,8143.28,34.094000000000001,9.4705555555555563,9031.48,37.81,10.502777777777778,11882.8,49.750999999999998,13.819722222222222,-19.600000000000001,-14.1,"< 0,0001",8.9999999999999998E-4,null,100,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":"ОК"}]
[24,96.3078,1.9690000000000001,0.58689999999999998,8.6699999999999999E-2,8.9899999999999994E-2,1.5E-3,1.7999999999999999E-2,1.2999999999999999E-2,1.34E-2,2.2000000000000001E-3,0.75739999999999996,0.15429999999999999,0.69650000000000001,8152.55,34.133000000000003,9.4813888888888886,9041.44,37.854700000000001,10.515194444444445,11889.87,49.78,{"$f":"V34/3.6","v":13.827777777777778},-19.5,-14,null,null,null,100.0001," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8152.55,34.133000000000003,9.4813888888888886,9041.44,37.854700000000001,10.515194444444445,11889.87,49.78,{"$f":"V35/3.6","v":13.827777777777778},null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8152.55,34.133000000000003,9.4813888888888886,9041.44,37.854700000000001,10.515194444444445,11889.87,49.78,13.827777777777778,null,null,null,null,null,0," "]
[27,96.095799999999997,2.0895999999999999,0.63419999999999999,9.6299999999999997E-2,9.9599999999999994E-2,1.6999999999999999E-3,2.0400000000000001E-2,1.4500000000000001E-2,1.5599999999999999E-2,8.3999999999999995E-3,0.75849999999999995,0.1653,0.69840000000000002,8169.77,34.204999999999998,9.5013888888888882,9059.85,37.931800000000003,10.536611111111112,11897.49,49.811999999999998,13.836666666666666,-21.7,-16,null,null,null,99.999899999999997," "]
[28,96.062200000000004,2.0954999999999999,0.64870000000000005,9.8400000000000001E-2,0.1027,1.6000000000000001E-3,2.0799999999999999E-2,1.5299999999999999E-2,1.72E-2,9.1000000000000004E-3,0.75749999999999995,0.1709,0.69889999999999997,8173.26,34.219799999999999,9.5054999999999996,9063.58,37.947400000000002,10.540944444444445,11898.68,49.817399999999999,13.838166666666666,-23,-17.2,null,null,null,99.999899999999997," "]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":8178.7671888025316},{"$f":"SUMPRODUCT(P11:P38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":34.241661716402568},{"$f":"SUMPRODUCT(Q11:Q38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":9.5115726990007126},{"$f":"SUMPRODUCT(R11:R38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":9067.9233846510469},{"$f":"SUMPRODUCT(S11:S38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":37.964523480259452},{"$f":"SUMPRODUCT(T11:T38,' розрахунок'!D6:D33)/' розрахунок'!D34","v":10.545700966738732}]
[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,"підпис",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,"Начальник служби ГВ та М                                                                                                                                                                                             Скавронський Є.К."]
[null,null,"Підрозділу, відповідального за облік газу за маршрутом",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,null,null,null,"підпис",null,null,null,"дата"]

{"sheet":" розрахунок","index":1,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[[2,3,4,3],[0,0,0,1],[2,0,4,0],[2,1,4,1]]}
[]
[null,null," Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 687"]
["Число місяця","Теплота згоряння вища, МДж/м3","ХЕРСОНСЬКА   область ","Загальний обсяг газу, м3"]
[]
[null,null,"ГРС Верхній Рогачик"]
[1,38,20.047999999999998,{"$f":"SUM(C6:C6)","v":20.047999999999998}]
[2,37.979999999999997,18.905000000000001,18.905000000000001]
[3,37.92,17.803999999999998,17.803999999999998]
[4,37.92,15.984999999999999,15.984999999999999]
[5,37.92,15.457000000000001,15.457000000000001]
[6,37.816000000000003,15.834,15.834]
[7,37.86,18.05,18.05]
[8,37.81,19.547000000000001,19.547000000000001]
[9,37.950000000000003,20.029,20.029]
[10,38.369999999999997,20.216999999999999,20.216999999999999]
[11,38.369999999999997,19.542999999999999,19.542999999999999]
[12,37.918999999999997,18.445,18.445]
[13,37.896000000000001,18.254000000000001,18.254000000000001]
[14,37.82,18.289000000000001,18.289000000000001]
[15,37.794600000000003,17.209,17.209]
[16,37.81,17.172000000000001,17.172000000000001]
[17,38.1265,16.965,16.965]
[18,38.1265,15.74,15.74]
[19,38.1265,14.865,14.865]
[20,38.08,13.928000000000001,13.928000000000001]
[21,38.049999999999997,13.811,13.811]
[22,37.923000000000002,13.676,13.676]
[23,37.81,13.427,13.427]
[24,37.854700000000001,12.438000000000001,12.438000000000001]
[25,37.854700000000001,13.268000000000001,13.268000000000001]
[26,37.854700000000001,13.461,13.461]
[27,37.931800000000003,12.512,12.512]
[28,37.947400000000002,12.403,12.403]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C6:C33)","v":457.2820000000001},457.2820000000001]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B6:B33,C6:C33)","v":17360.493226100007},{"$f":"SUMPRODUCT(B6:B33,D6:D33)","v":17360.493226100007}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C35/C34","v":37.964523480259452},{"$f":"D35/D34","v":37.964523480259452}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C36*238.8459","v":9067.6707787137002},{"$f":"D36*238.8459","v":9067.6707787137002}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C36/3.6","v":10.545700966738737},10.545700966738737]

{"sheet":"додаток","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1],[6,0,6,1],[3,2,3,4],[3,1,4,1],[3,0,4,0],[1,0,1,4]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу № 687"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Херсонська  область","ГРС Верхній Рогачик",37.96,9068,10.55]
["Середньозважене значення вищої теплоти згоряння по маршруту № 687",null,37.96,9068,10.55]
[]
[]
[]
["В.о.Начальника  управління  Херсонського ЛВУМГ                                                 Кузьмін Р.Ф.                                                                        "]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
[]
["Завідувач лабораторії                                                                                           Камишанова О.С.                                                                                               "]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
[]
["Начальник служби ГВ та М                                                                                     Скавронський Є.К."]
["Підрозділу, відповідального за облік газу за маршрутом",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"]