{"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":[[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],[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],[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]]}
["ПАТ \"УКРТРАНСГАЗ\"",null,null,null,null,null,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 163"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Чернігівським ЛВУМГ та прийнятого  ПАТ \"Чернігівгаз\", ПАТ \"Київоблгаз\""]
["Чернігівське ЛВУМГ",null,null,null,null,null,"Маршрут № 163"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № 74/2014 чинно до 01.07.2019 р.",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," ккал/м3"," МДж/м3","кВт⋅год/м3"," ккал/м3"," МДж/м3","кВт⋅год/м3"," ккал/м3"," МДж/м3","кВт⋅год/м3",null,null,null,null,null,null,null,"  "]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,8201,34.340000000000003,9.5399999999999991,9081,38.020000000000003,10.56,null,null,null,null,null,null,null,null,{"$f":"SUM(B11:M11)+$K$42+$N$42","v":0}]
[2,89.736500000000007,4.95,1.1059000000000001,0.12089999999999999,0.20519999999999999,3.7000000000000002E-3,5.2400000000000002E-2,3.8100000000000002E-2,3.0599999999999999E-2,3.8999999999999998E-3,1.7661,1.9865999999999999,0.75109999999999999,8225,34.43,9.56,9106,38.119999999999997,10.59,11531,48.28,13.41,-10.199999999999999,-9.6,1E-4,4.0000000000000002E-4,"відс.",99.999900000000025]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.43,9.56,9106,38.119999999999997,10.59,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,8225,34.43,9.56,9106,38.119999999999997,10.59,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,8225,34.43,9.56,9106,38.119999999999997,10.59,null,null,null,null,null,null,null,null,0," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.43,9.56,9106,38.119999999999997,10.59,null,null,null,null,null,null,null,null,0," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.43,9.56,9106,38.119999999999997,10.59,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.43,9.56,9106,38.119999999999997,10.59,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)+$K$42+$N$42","v":0}," "]
[9,89.878200000000007,4.9029999999999996,1.0987,0.115,0.17929999999999999,3.5999999999999999E-3,4.9399999999999999E-2,3.78E-2,0.04,3.5999999999999999E-3,1.6869000000000001,2.0045999999999999,0.75019999999999998,8222,34.42,9.56,9103,38.11,10.59,11534,48.29,13.41,-10,-10.199999999999999,1E-4,4.0000000000000002E-4,"відс.",100.00010000000002," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8222,34.42,9.56,9103,38.11,10.59,null,null,null,null,null,null,null,null,0," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8222,34.42,9.56,9103,38.11,10.59,null,null,null,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8222,34.42,9.56,9103,38.11,10.59,null,null,null,null,null,null,null,null,0," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8222,34.42,9.56,9103,38.11,10.59,null,null,null,null,null,null,null,null,0," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8222,34.42,9.56,9103,38.11,10.59,null,null,null,null,null,null,null,null,0," "]
[15,89.647999999999996,4.9968000000000004,1.1002000000000001,0.11890000000000001,0.2087,4.4999999999999997E-3,5.3400000000000003E-2,3.8899999999999997E-2,3.2500000000000001E-2,4.1999999999999997E-3,1.7324999999999999,2.0613999999999999,0.75209999999999999,8225,34.44,9.57,9106,38.130000000000003,10.59,11524,48.25,13.4,-10.8,-10.199999999999999,1E-4,4.0000000000000002E-4,"відс.",99.999999999999986,"ОК"]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,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,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8225,34.44,9.57,9106,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[23,89.912400000000005,4.8376000000000001,1.0823,0.12039999999999999,0.22739999999999999,3.5999999999999999E-3,5.5399999999999998E-2,4.1599999999999998E-2,3.15E-2,3.3E-3,1.7101,1.9745999999999999,0.75029999999999997,8226,34.44,9.57,9107,38.130000000000003,10.59,11539,48.31,13.42,-8.6,-9,1E-4,4.0000000000000002E-4,"відс.",100.00020000000001,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8226,34.44,9.57,9107,38.130000000000003,10.59,null,null,null,null,null,null,null,null,0," "]
[30,90.161199999999994,4.6783999999999999,1.0827,0.1154,0.20849999999999999,3.0999999999999999E-3,5.0900000000000001E-2,3.6600000000000001E-2,2.0299999999999999E-2,5.0000000000000001E-3,1.6979,1.94,0.74790000000000001,8209,34.369999999999997,9.5500000000000007,9090,38.06,10.57,11534,48.29,13.41,-8.8000000000000007,-9.6,1E-4,4.0000000000000002E-4,"відс.",100]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8209,34.369999999999997,9.5500000000000007,9090,38.06,10.57,null,null,null,null,null,null,null,null,0," "]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":8222.881759266118},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":34.425935994896037},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":9.5631606607658757},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":9103.8515812746973},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":38.115634214981824},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!L7:L37)/' розрахунок'!L38","v":10.588272566924468}]
[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":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,11,5,11],[1,0,1,10],[0,0,0,1],[3,0,5,0],[3,1,5,1],[4,2,4,10],[3,2,3,8],[3,9,3,10]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 163"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Чернігівська область",null,null,null,null,null,null,"Київська область",null,"Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ГРС Остер","ГРС Козелець","ГРС Чемер","ГРС Десна","ГРС Булахів","ГРС Мостище","ГРС Бобровиця","ГРС В. Дубечня","ГРС Жукин"]
[1,38.020000000000003,3255,7366,1526,1867,2251,2171,11909,11714,3161,{"$f":"SUM(C7:K7)","v":45220}]
[2,38.119999999999997,3605,8581,1683,1988,2428,2090,24630,10735,2798,58538]
[3,38.119999999999997,2868,7570,1345,1739,1847,2021,19183,9164,1649,47386]
[4,38.119999999999997,2493,7299,1299,1563,1733,1497,23603,7431,1225,48143]
[5,38.119999999999997,2495,6247,1324,1598,1647,1223,9880,7797,1778,33989]
[6,38.119999999999997,2324,6138,1278,1671,2030,1538,18678,7611,1560,42828]
[7,38.119999999999997,2082,5328,1104,1545,1754,1109,18148,6638,1155,38863]
[8,38.119999999999997,2452,6455,1282,1544,1401,1567,13997,7866,1609,38173]
[9,38.11,3637,10248,1658,1961,2157,2556,23384,11630,2971,60202]
[10,38.11,5644,18301,2711,2365,3138,4235,33823,14975,3633,88825]
[11,38.11,5642,17916,2517,2404,2847,3801,21791,13841,3158,73917]
[12,38.11,5394,16858,2405,2172,3127,3517,29441,12314,2832,78060]
[13,38.11,6276,19726,3056,2573,3840,4113,23721,15385,3082,81772]
[14,38.11,4544,13719,1986,2344,2842,3402,29577,14069,2811,75294]
[15,38.130000000000003,2800,8472,1336,1727,1925,2091,17526,9455,2165,47497]
[16,38.130000000000003,2658,7912,1318,1605,1690,2018,24177,7741,1370,50489]
[17,38.130000000000003,2940,8731,1458,1736,1737,2214,12474,9487,1972,42749]
[18,38.130000000000003,2706,7905,1282,1609,1825,2043,23816,8542,1670,51398]
[19,38.130000000000003,2482,7024,1203,1516,1768,1893,10183,7313,1133,34515]
[20,38.130000000000003,2517,7293,1286,1637,1930,1917,23566,8852,1545,50543]
[21,38.130000000000003,2412,6759,1135,1625,1812,1874,10241,7422,1139,34419]
[22,38.130000000000003,2128,5862,1023,1013,1364,1595,22581,6612,937,43115]
[23,38.130000000000003,1864,5491,922,1305,1465,1351,18311,5311,712,36732]
[24,38.130000000000003,1796,5674,996,1363,1198,1431,22177,5005,723,40363]
[25,38.130000000000003,1835,5826,996,1345,1143,1425,15899,5163,633,34265]
[26,38.130000000000003,2081,6693,1136,1427,1506,1633,18237,5841,943,39497]
[27,38.130000000000003,2181,6520,1133,1563,1758,1690,21787,6332,1402,44366]
[28,38.130000000000003,2134,5604,1083,1490,1685,1547,17418,5957,1002,37920]
[29,38.130000000000003,1776,4856,890,1230,1199,1275,21216,4734,596,37772]
[30,38.06,1528,4738,860,1247,1123,1190,14674,4667,583,30610]
[31,38.06,1649,4681,862,1144,1124,1206,15135,4561,621,30983]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":90198},261793,44093,{"$f":"SUM(F7:F37)","v":51916},59294,63233,611183,264165,52568,{"$f":"SUM(L7:L37)","v":1498443}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":3437863.3699999996},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":9978285.9599999972},{"$f":"SUMPRODUCT(B7:B37,E7:E37)","v":1680597.88},{"$f":"SUMPRODUCT(B7:B37,F7:F37)","v":1978791.4799999997},{"$f":"SUMPRODUCT(B7:B37,G7:G37)","v":2259987.9000000004},{"$f":"SUMPRODUCT(B7:B37,H7:H37)","v":2410124.83},{"$f":"SUMPRODUCT(B7:B37,I7:I37)","v":23296495.240000006},{"$f":"SUMPRODUCT(B7:B37,J7:J37)","v":10068460.25},{"$f":"SUMPRODUCT(B7:B37,K7:K37)","v":2003498.3700000006},{"$f":"SUMPRODUCT(B7:B37,L7:L37)","v":57114105.280000009}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.114629703541091},38.115174813688668,38.114845440319321,38.115253101163411,38.114950922521679,38.114984738981228,38.117053713863122,38.114285579088829,38.112508940800495,{"$f":"L39/L38","v":38.115634214981824}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9103.5230347090055},9103.6532320328024,9103.5745625539639,9103.6719306751656,9103.59975654552,9103.607833468237,9104.1019996359792,9103.4408419944921,9103.0164992235404,{"$f":"L40*238.8459","v":9103.7629581481269}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.587397139872525},10.587548559357963,10.587457066755366,10.587570305878724,{"$f":"G40/3.6","v":10.587486367367132},10.587495760828119,10.588070476073089,10.587301549746897,10.586808039111249,{"$f":"L40/3.6","v":10.587676170828285}]

{"sheet":"додаток","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1],[14,0,14,1],[3,2,3,4],[3,1,4,1],[3,0,4,0],[5,0,11,0],[12,0,13,0]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу № 163"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Чернігівська область","ГРС Остер",38.11,9104,10.59]
[null,"ГРС Козелець",38.119999999999997,9104,10.59]
[null,"ГРС Чемер",38.11,9104,10.59]
[null,"ГРС Десна",38.119999999999997,9104,10.59]
[null,"ГРС Булахів",38.11,9104,10.59]
[null,"ГРС Мостище",38.11,9104,10.59]
[null,"ГРС Бобровиця",38.119999999999997,9104,10.59]
["Київська область","ГРС В.Дубечня",38.11,9103,10.59]
[null,"ГРС Жукин",38.11,9103,10.59]
["Середньозважене значення вищої теплоти згоряння по маршруту № 163",null,38.119999999999997,9104,10.59]
[]
[]
[]
["Начальник управління Чернігівського ЛВУМГ                                                                                                                           ",null,null,"Шутішин В.О.",null,"01.06.2017 р."]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
["Завідувач лабораторією                                                                                                                                                                        ",null,null,"Лапа І.О.",null,"01.06.2017 р."]
["Лабораторія, де здійснювалось вимірювання газу",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"]