{"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":[[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],[6,25,9,25],[6,27,9,27],[8,8,9,8],[6,26,9,26],[6,24,9,24],[6,23,9,23],[3,12,3,16],[6,0,9,0],[8,11,9,11],[8,9,9,9],[8,10,9,10],[8,1,9,1],[8,2,9,2],[8,5,9,5],[8,6,9,6],[8,4,9,4],[47,1,47,26],[49,1,49,26],[41,20,41,27],[42,7,42,13],[42,20,42,27],[43,20,43,27],[45,1,45,26],[41,15,42,15],[41,16,42,16],[41,17,42,17],[41,18,42,18],[41,19,42,19],[41,0,41,13],[41,14,42,14]]}
["ПАТ \"УКРТРАНСГАЗ\"",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.05.2017р.   по   31.05.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","Вміст меркаптанової сірки, г/м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,8242,34.51,9.59,9136,38.25,10.63,11897,49.81,13.84]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,8242,34.51,9.59,9136,38.25,10.63,11897,49.81,13.84]
[3,95.343500000000006,2.5108999999999999,0.8085,0.1235,0.13100000000000001,1.9E-3,2.7300000000000001E-2,0.02,2.29E-2,7.4999999999999997E-3,0.78369999999999995,0.21940000000000001,0.70520000000000005,8227.7157940199995,34.447800000000001,9.568833333333334,9121.6682285400002,38.190600000000003,10.608500000000001,11920.703330639999,49.909599999999998,13.863777777777777,-21.5,-16.3,null,null,null,null,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":" "}]
[4,95.380600000000001,2.4967000000000001,0.80059999999999998,0.1225,0.12939999999999999,1.8E-3,2.6700000000000002E-2,1.9699999999999999E-2,2.0299999999999999E-2,7.6E-3,0.77639999999999998,0.2175,0.70489999999999997,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,-18.2,-13.6,null,null,null,null,{"$f":"IF(AC14=100,\"ОК\",\" \")","v":" "}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,null,null,null,null,null,null," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,null,null,null,null,"відсутні",null," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,null,null,null,null,null,null," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,null,null,null,null,null,null," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8225.1123737100006,34.436900000000001,9.5658055555555563,9118.9215006899994,38.179099999999998,10.605305555555555,11920.24952343,49.907699999999998,13.863249999999999,null,null,null,null,null,null," "]
[10,95.051699999999997,2.6631999999999998,0.85860000000000003,0.1303,0.14169999999999999,2E-3,2.9700000000000001E-2,2.2100000000000002E-2,2.5600000000000001E-2,1.21E-2,0.82599999999999996,0.23699999999999999,0.7077,8243.5273926000009,34.514000000000003,9.5872222222222234,9138.4352107200011,38.260800000000003,10.628,11922.112521450001,49.915500000000002,13.865416666666667,null,null,"< 0,0001",1E-3,null,null," "]
[11,94.879400000000004,2.7738,0.89829999999999999,0.13489999999999999,0.14990000000000001,2.2000000000000001E-3,3.1899999999999998E-2,2.3800000000000002E-2,2.75E-2,4.4000000000000003E-3,0.82410000000000005,0.24979999999999999,0.70920000000000005,8259.1240298700013,34.579300000000003,9.6053611111111117,9155.1305391299993,38.3307,10.647416666666667,11930.54378172,49.950800000000001,13.875222222222222,-12.8,-8.4,null,null,null,null," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8259.1240298700013,34.579300000000003,9.6053611111111117,9155.1305391299993,38.3307,10.647416666666667,11930.54378172,49.950800000000001,13.875222222222222,null,null,null,null,null,null," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8259.1240298700013,34.579300000000003,9.6053611111111117,9155.1305391299993,38.3307,10.647416666666667,11930.54378172,49.950800000000001,13.875222222222222,null,null,null,null,null,null," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8259.1240298700013,34.579300000000003,9.6053611111111117,9155.1305391299993,38.3307,10.647416666666667,11930.54378172,49.950800000000001,13.875222222222222,null,null,null,null,null,null," "]
[15,93.266900000000007,3.5402,1.3467,0.1951,0.2792,2.8999999999999998E-3,6.6199999999999995E-2,5.3900000000000003E-2,5.5100000000000003E-2,9.9000000000000008E-3,0.879,0.30480000000000002,0.72560000000000002,8413.2751737300005,35.224699999999999,9.7846388888888889,9319.934210129999,39.020699999999998,10.839083333333333,12007.284969390001,50.272100000000002,13.964472222222222,null,null,null,null,null,null," "]
[16,93.407300000000006,3.4678,1.3051999999999999,0.1908,0.2712,2.8999999999999998E-3,6.5799999999999997E-2,5.3100000000000001E-2,5.4699999999999999E-2,6.3E-3,0.87070000000000003,0.30420000000000003,0.72440000000000004,8401.858339710001,35.176900000000003,9.7713611111111121,9307.7530692300006,38.969700000000003,10.824916666666667,12001.86316746,50.249400000000001,13.958166666666667,null,null,null,null,null,null," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8401.858339710001,35.176900000000003,9.7713611111111121,9307.7530692300006,38.969700000000003,10.824916666666667,12001.86316746,50.249400000000001,13.958166666666667,null,null,null,null,null,null," "]
[18,93.640699999999995,3.3658999999999999,1.2511000000000001,0.18479999999999999,0.2555,2.8E-3,6.1100000000000002E-2,4.9399999999999999E-2,5.2900000000000003E-2,3.3E-3,0.83819999999999995,0.2944,0.72219999999999995,8385.712356869999,35.109299999999998,9.752583333333332,9290.5800490199999,38.897799999999997,10.804944444444443,11997.683364210001,50.231900000000003,13.953305555555556,null,null,null,null,null,null," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8385.712356869999,35.109299999999998,9.752583333333332,9290.5800490199999,38.897799999999997,10.804944444444443,11997.683364210001,50.231900000000003,13.953305555555556,null,null,null,null,null,null," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8385.712356869999,35.109299999999998,9.752583333333332,9290.5800490199999,38.897799999999997,10.804944444444443,11997.683364210001,50.231900000000003,13.953305555555556,-17.3,-12.1,null,null,"відсутні",null,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":" "}]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,8385.712356869999,35.109299999999998,9.752583333333332,9290.5800490199999,38.897799999999997,10.804944444444443,11997.683364210001,50.231900000000003,13.953305555555556,null,null,null,null,null,null," "]
[22,93.921700000000001,3.0994999999999999,1.1639999999999999,0.1686,0.2477,2.5999999999999999E-3,6.3899999999999998E-2,5.2400000000000002E-2,5.96E-2,7.4999999999999997E-3,0.94989999999999997,0.26269999999999999,0.7198,8350.482586619999,34.961799999999997,9.7116111111111092,9252.5796663300007,38.738700000000001,10.76075,11969.093509980001,50.112200000000001,13.920055555555555,null,null,null,null,null,null," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8350.482586619999,34.961799999999997,9.7116111111111092,9252.5796663300007,38.738700000000001,10.76075,11969.093509980001,50.112200000000001,13.920055555555555,null,null,null,null,null,null,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8350.482586619999,34.961799999999997,9.7116111111111092,9252.5796663300007,38.738700000000001,10.76075,11969.093509980001,50.112200000000001,13.920055555555555,null,null,"< 0,0001",2E-3,null,null," "]
[25,93.946600000000004,3.1907999999999999,1.1596,0.17030000000000001,0.23280000000000001,2.5000000000000001E-3,5.8400000000000001E-2,4.6800000000000001E-2,5.0900000000000001E-2,7.1999999999999998E-3,0.85529999999999995,0.27900000000000003,0.71919999999999995,8354.0413905300011,34.976700000000001,9.7157499999999999,9256.6400466300001,38.755699999999997,10.765472222222222,11978.91007647,50.153300000000002,13.931472222222222,-13.9,-9,null,null,null,null," "]
[26,94.0197,3.2004999999999999,1.1526000000000001,0.17119999999999999,0.22720000000000001,2.5999999999999999E-3,5.6099999999999997E-2,4.53E-2,4.9799999999999997E-2,6.4000000000000003E-3,0.79659999999999997,0.27210000000000001,0.71860000000000002,8356.9791950999988,34.988999999999997,9.7191666666666663,9259.9838892299995,38.7697,10.769361111111111,11988.27283575,50.192500000000003,13.942361111111111,null,null,null,null,null,null," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8356.9791950999988,34.988999999999997,9.7191666666666663,9259.9838892299995,38.7697,10.769361111111111,11988.27283575,50.192500000000003,13.942361111111111,null,null,null,null,null,null," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8356.9791950999988,34.988999999999997,9.7191666666666663,9259.9838892299995,38.7697,10.769361111111111,11988.27283575,50.192500000000003,13.942361111111111,null,null,null,null,null,null," "]
[29,94.0471,3.1701999999999999,1.1435999999999999,0.1696,0.22520000000000001,2.5999999999999999E-3,5.4899999999999997E-2,4.4499999999999998E-2,4.9700000000000001E-2,1.0500000000000001E-2,0.81530000000000002,0.26690000000000003,0.71830000000000005,8351.3663164499994,34.965499999999999,9.7126388888888879,9253.9172033700015,38.744300000000003,10.762305555555557,11983.233187259999,50.171399999999998,13.936499999999999]
[30,93.983000000000004,3.2197,1.1594,0.1716,0.2296,2.5999999999999999E-3,5.6300000000000003E-2,4.53E-2,5.0999999999999997E-2,3.5000000000000001E-3,0.80610000000000004,0.27200000000000002,0.71889999999999998,8359.4393078699995,34.999299999999998,9.722027777777777,9262.5873095400002,38.7806,10.772388888888889,11989.08491181,50.195900000000002,13.943305555555556]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8359.4393078699995,34.999299999999998,9.722027777777777,9262.5873095400002,38.7806,10.772388888888889,11989.08491181,50.195900000000002,13.943305555555556]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":8311.5483941220537},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":34.798938853456498},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":9.6666130884017942},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":9211.1794290799808},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":38.565328013586495},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!D6:D36)/' розрахунок'!D37","v":10.712901209452983}]
[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,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,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,null,null,"дата"]

{"sheet":" розрахунок","index":1,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"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.25,1365,{"$f":"SUM(C6:C6)","v":1365}]
[2,38.25,1173,1173]
[3,38.190600000000003,1041,1041]
[4,38.179099999999998,1014.9999999999999,1014.9999999999999]
[5,38.179099999999998,1104,1104]
[6,38.179099999999998,1035,1035]
[7,38.179099999999998,1051,1051]
[8,38.179099999999998,1261,1261]
[9,38.179099999999998,1171,1171]
[10,38.260800000000003,1532,1532]
[11,38.3307,2065,2065]
[12,38.3307,1711,1711]
[13,38.3307,1435,1435]
[14,38.3307,2294,2294]
[15,39.020699999999998,1649,1649]
[16,38.969700000000003,1209,1209]
[17,38.969700000000003,1290,1290]
[18,38.897799999999997,1474,1474]
[19,38.897799999999997,1493,1493]
[20,38.897799999999997,1723,1723]
[21,38.897799999999997,1526,1526]
[22,38.738700000000001,1836,1836]
[23,38.738700000000001,1376,1376]
[24,38.738700000000001,1228,1228]
[25,38.755699999999997,1157,1157]
[26,38.7697,1000,1000]
[27,38.7697,1034,1034]
[28,38.7697,1037,1037]
[29,38.744300000000003,893,893]
[30,38.7806,860,860]
[31,38.7806,885,885]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C6:C36)","v":40923},{"$f":"SUM(D6:D36)","v":40923}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B6:B36,C6:C36)","v":1578208.9183},{"$f":"SUMPRODUCT(B6:B36,D6:D36)","v":1578208.9183}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C38/C37","v":38.565328013586495},{"$f":"D38/D37","v":38.565328013586495}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C39*238.8459","v":9211.170478200278},{"$f":"D39*238.8459","v":9211.170478200278}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C39/3.6","v":10.712591114885138},10.712591114885138]

{"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," МДж/м³","ккал/м³","кВт*год./м³"]
["Херсонська  область","ГРСм. Верхній Рогачик",38.57,9211,1.071]
["Середньозважене значення вищої теплоти згоряння по маршруту № 687",null,38.57,9211,10.71]
[]
[]
[]
["Начальника  управління  Херсонського ЛВУМГ                                                           Доскоч М.В.                                                                   ",null,null,null,null,"2017-06-01"]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
[]
["Завідувач лабораторії                                                                                                 Камишанова О.С.                                                                                               ",null,null,null,null,"2017-06-01"]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
[]
["Начальник служби ГВ та М                                                                                       Скавронський Є.К.",null,null,null,null,"2017-06-01"]
["Підрозділу, відповідального за облік газу за маршрутом",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"]