{"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,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 169"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Чернігівським ЛВУМГ та прийнятого  ПАТ \"Київоблгаз\", ІП \"КОКА-КОЛА БЕВЕРІДЖИЗ УКРАЇНА ЛІМІТЕД\""]
["Чернігівське ЛВУМГ",null,null,null,null,null,"Маршрут № 169"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № 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,8210,34.369999999999997,9.5500000000000007,9090,38.06,10.57,null,null,null,null,null,null,null,null,{"$f":"SUM(B11:M11)+$K$42+$N$42","v":0}]
[2,89.767700000000005,4.9664000000000001,1.1068,0.1172,0.20949999999999999,4.1000000000000003E-3,5.16E-2,3.6400000000000002E-2,2.7199999999999998E-2,3.7000000000000002E-3,1.7516,1.958,0.75060000000000004,8228,34.450000000000003,9.57,9109,38.14,10.59,11539,48.31,13.42,-10,-9.8000000000000007,1E-4,4.0000000000000002E-4,"відс.",100.00019999999999]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8228,34.450000000000003,9.57,9109,38.14,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,8228,34.450000000000003,9.57,9109,38.14,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,8228,34.450000000000003,9.57,9109,38.14,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,8228,34.450000000000003,9.57,9109,38.14,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,8228,34.450000000000003,9.57,9109,38.14,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,8228,34.450000000000003,9.57,9109,38.14,10.59,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)+$K$42+$N$42","v":0}," "]
[9,89.753900000000002,4.9573999999999998,1.1163000000000001,0.1152,0.20469999999999999,3.8999999999999998E-3,4.9099999999999998E-2,3.5200000000000002E-2,3.2199999999999999E-2,5.7000000000000002E-3,1.7210000000000001,2.0053999999999998,0.75109999999999999,8226,34.44,9.57,9107,38.130000000000003,10.59,11534,48.29,13.41,-9.8000000000000007,-10,1E-4,4.0000000000000002E-4,"відс.",100,"ОК"]
[10,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," "]
[11,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," "]
[12,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," "]
[13,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," "]
[14,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," "]
[15,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," "]
[16,89.622600000000006,5.0217000000000001,1.0925,0.1154,0.1966,4.4000000000000003E-3,5.0099999999999999E-2,3.5900000000000001E-2,2.6100000000000002E-2,4.3E-3,1.7543,2.0762,0.75190000000000001,8216,34.4,9.56,9096,38.090000000000003,10.58,11512,48.2,13.39,-9.8000000000000007,-10,1E-4,4.0000000000000002E-4,"відс.",100.0001," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8216,34.4,9.56,9096,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8216,34.4,9.56,9096,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8216,34.4,9.56,9096,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8216,34.4,9.56,9096,38.090000000000003,10.58,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,8216,34.4,9.56,9096,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8216,34.4,9.56,9096,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[23,89.866299999999995,4.883,1.0677000000000001,0.1149,0.20930000000000001,3.7000000000000002E-3,5.21E-2,3.7499999999999999E-2,3.0800000000000001E-2,4.1000000000000003E-3,1.7123999999999999,2.0182000000000002,0.75029999999999997,8217,34.4,9.56,9098,38.090000000000003,10.58,11527,48.26,13.41,-8.8000000000000007,-9.1999999999999993,1E-4,4.0000000000000002E-4,"відс.",99.999999999999972,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":"ОК"}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8217,34.4,9.56,9098,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8217,34.4,9.56,9098,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8217,34.4,9.56,9098,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8217,34.4,9.56,9098,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8217,34.4,9.56,9098,38.090000000000003,10.58,null,null,null,null,null,null,null,null,0," "]
[29,89.935900000000004,4.8369999999999997,1.1117999999999999,0.11749999999999999,0.21249999999999999,3.2000000000000002E-3,5.0999999999999997E-2,3.7499999999999999E-2,2.4199999999999999E-2,3.0999999999999999E-3,1.6644000000000001,2.0017,0.75,8223,34.43,9.56,9105,38.119999999999997,10.59,11539,48.31,13.42,-9,-9.6,1E-4,4.0000000000000002E-4,"відс.",99.999800000000022," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8223,34.43,9.56,9105,38.119999999999997,10.59,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8223,34.43,9.56,9105,38.119999999999997,10.59,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,' розрахунок'!H7:H37)/' розрахунок'!H38","v":8221.8900232713131},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!H7:H37)/' розрахунок'!H38","v":34.42316974740752},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!H7:H37)/' розрахунок'!H38","v":9.5645914032163262},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!H7:H37)/' розрахунок'!H38","v":9102.7343962975337},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!H7:H37)/' розрахунок'!H38","v":38.113169747407518},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!H7:H37)/' розрахунок'!H38","v":10.58538829058579}]
[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":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,7,5,7],[1,0,1,6],[0,0,0,1],[3,0,5,0],[3,1,5,1],[4,2,4,6],[3,2,3,6]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 169"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Київська область",null,null,null,null,"Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ГРС В.Димерка","ГРС Семиполки","ГРС Залісся","ГРС Калита","ІП \"Кока-кола\""]
[1,38.06,15115,9501,2606,4419,25024,{"$f":"SUM(C7:G7)","v":56665}]
[2,38.14,15667,10250,2627,4632,27663,60839]
[3,38.14,14164,8932,2265,3991,26776,56128]
[4,38.14,12512,7620,2008,3597,26265,52002]
[5,38.14,12064,7820,1953,3621,26120,51578]
[6,38.14,12576,6904,1941,3608,23886,48915]
[7,38.14,10962,5464,1742,3355,22756,44279]
[8,38.14,12197,7974,2060,3623,27811,53665]
[9,38.130000000000003,17850,11610,2912,4975,29098,66445]
[10,38.130000000000003,26319,17348,4331,6654,28702,83354]
[11,38.130000000000003,22612,14713,4237,6721,26491,74774]
[12,38.130000000000003,19439,12235,3523,6294,24720,66211]
[13,38.130000000000003,27022,15147,4934,7744,22983,77830]
[14,38.130000000000003,22919,14118,3987,6540,23237,70801]
[15,38.130000000000003,15223,8874,2252,4138,26112,56599]
[16,38.090000000000003,15430,7799,2073,3658,24336,53296]
[17,38.090000000000003,16009,8963,2250,4078,27044,58344]
[18,38.090000000000003,14231,7939,2128,3719,25940,53957]
[19,38.090000000000003,13421,6370,1935,3596,23614,48936]
[20,38.090000000000003,13369,7459,2125,3668,21244,47865]
[21,38.090000000000003,12886,7069,2111,3752,21223,47041]
[22,38.090000000000003,10668,6229,1755,3187,25530,47369]
[23,38.090000000000003,10958,5133,1528,2970,26221,46810]
[24,38.090000000000003,9454,5190,1502,2886,30181,49213]
[25,38.090000000000003,9452,5464,1506,2949,36447,55818]
[26,38.090000000000003,11515,6957,1693,3320,40300,63785]
[27,38.090000000000003,13123,7406,1913,3392,38476,64310]
[28,38.090000000000003,11629,6418,1754,3248,37200,60249]
[29,38.119999999999997,10405,4989,1436,2833,40657,60320]
[30,38.119999999999997,9896,5824,1354,2749,39964,59787]
[31,38.119999999999997,8271,5473,1372,2688,2110,19914]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":447358},{"$f":"SUM(D7:D37)","v":263192},{"$f":"SUM(E7:E37)","v":71813},{"$f":"SUM(F7:F37)","v":126605},{"$f":"SUM(G7:G37)","v":848131},{"$f":"SUM(H7:H37)","v":1757099}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":17050832.390000001},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":10031696.83},{"$f":"SUMPRODUCT(B7:B37,E7:E37)","v":2737180.6900000004},{"$f":"SUMPRODUCT(B7:B37,F7:F37)","v":4825543.9700000016},{"$f":"SUMPRODUCT(B7:B37,G7:G37)","v":32323358.570000004},{"$f":"SUMPRODUCT(B7:B37,H7:H37)","v":66968612.450000003}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.114513186307164},{"$f":"D39/D38","v":38.115508184139337},{"$f":"E39/E38","v":38.115392616935658},{"$f":"F39/F38","v":38.114955728446759},{"$f":"G39/G38","v":38.111280651220156},{"$f":"H39/H38","v":38.113169747407518}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9103.4952050454031},{"$f":"D40*238.8459","v":9103.7328561981249},{"$f":"E40*238.8459","v":9103.7052534453524},{"$f":"F40*238.8459","v":9103.6009044210223},{"$f":"G40*238.8459","v":9102.723127293264},{"$f":"H40*238.8459","v":9103.1743301723218}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.587364773974212},{"$f":"D40/3.6","v":10.587641162260926},{"$f":"E40/3.6","v":10.587609060259904},{"$f":"F40/3.6","v":10.587487702346321},{"$f":"G40/3.6","v":10.586466847561153},{"$f":"H40/3.6","v":10.586991596502088}]

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