{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["паспорт","додаток","variablesList","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 174"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Сумським ЛВУМГ та прийнятого  ПАТ \"Сумигаз\",  ПАТ «Сумське НВО»\n"]
["Сумського ЛВУМГ",null,null,null,null,null,"Маршрут № 174"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № РУ-1071/12 чинне до  10 травня 2017 р.",null,null,null,null,null,null,null,null,"по газопроводу  Єлець-Курськ-Київ, Єлець-Курськ-Диканька, Більськ-Суми",null,null,null,null,null,null,null,null,null,null,null,"за період з",null,"2017-03-01",null," по","2017-03-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,{"$f":"P11*238.8459","v":8233.0181730000004},34.47,{"$f":"P11/3.6","v":9.5749999999999993},{"$f":"S11*238.8459","v":9116.7480030000006},38.17,{"$f":"S11/3.6","v":10.602777777777778},null,null,null,null,null,null,null,null,{"$f":"SUM(B11:M11)+$K$42+$N$42","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,8233.0181730000004,34.47,9.5749999999999993,9116.7480030000006,38.17,10.602777777777778,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8233.0181730000004,34.47,9.5749999999999993,9116.7480030000006,38.17,10.602777777777778,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,8233.0181730000004,34.47,9.5749999999999993,9116.7480030000006,38.17,10.602777777777778,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,8233.0181730000004,34.47,9.5749999999999993,9116.7480030000006,38.17,10.602777777777778,null,null,null,null,null,null,null,null,0," "]
[6,90.952500000000001,4.4059999999999997,1.02,0.115,0.17699999999999999,6.6E-3,4.7E-2,4.1000000000000002E-2,0.10299999999999999,8.8999999999999999E-3,2.0680000000000001,1.0549999999999999,0.73909999999999998,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,{"$f":"V16*238.8459","v":11655.679919999999},48.8,{"$f":"V16/3.6","v":13.555555555555554},-16.3,null,0,"≤0,01",0,100,"ОК"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9131.0787569999993,38.229999999999997,10.619444444444444,null,null,null,null,null,null,null,null,0," "]
[13,91.0167,4.4320000000000004,0.99399999999999999,0.112,0.17199999999999999,6.8999999999999999E-3,4.5999999999999999E-2,3.9E-2,9.9000000000000005E-2,8.3999999999999995E-3,2.0350000000000001,1.0389999999999999,0.73819999999999997,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,{"$f":"V23*238.8459","v":11660.456838},48.82,{"$f":"V23/3.6","v":13.56111111111111},-16.100000000000001,null,null,null,null,100,"ОК"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P24*238.8459","v":8244.9604680000011},34.520000000000003,{"$f":"P24/3.6","v":9.5888888888888903},9128.6902979999995,38.22,{"$f":"S24/3.6","v":10.616666666666665},null,null,null,null,null,null,null,null,0," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
[20,91.045199999999994,4.3929999999999998,0.96399999999999997,0.111,0.16900000000000001,6.8999999999999999E-3,4.5999999999999999E-2,0.04,0.14599999999999999,8.8999999999999999E-3,2.0430000000000001,1.0269999999999999,0.7389,{"$f":"P30*238.8459","v":8252.1258449999987},34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,{"$f":"V30*238.8459","v":11667.622215000001},48.85,{"$f":"V30/3.6","v":13.569444444444445},-17.2,null,null,null,null,100.00000000000001,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":"ОК"}]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,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,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8252.1258449999987,34.549999999999997,9.5972222222222214,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0," "]
[27,91.104100000000003,4.3949999999999996,0.98099999999999998,0.113,0.17399999999999999,7.0000000000000001E-3,4.5999999999999999E-2,3.9E-2,9.9000000000000005E-2,7.9000000000000008E-3,2.0249999999999999,1.0089999999999999,0.73750000000000004,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,{"$f":"V37*238.8459","v":11665.233756000001},48.84,{"$f":"V37/3.6","v":13.566666666666666},-9.8000000000000007,null,null,null,null,100.00000000000003,"ОК"]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8244.9604680000011,34.520000000000003,9.5888888888888903,9128.6902979999995,38.22,10.616666666666665,null,null,null,null,null,null,null,null,0," "]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,8244,34.517921495244636,9.5883115264568435,9129,38.222309740612722,10.617308261281314]
[null,null,null,null,null,null,null,"Середньозважене значення теплоти згоряння:"]
[]
[]
[null,"Головний інженер Сумського ЛВУМГ                                                                                                              Соловйов О.Б.                                                                        03.04.2017"]
[null,null,"Керівник підрозділу підприємства, якому підпорядкована лабораторія",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Завідувач ВХАЛ                                                                                                                                                Журавльова В.В.                                                                       03.04.2017      "]
[null,null,"Лабораторія, де здійснювалось вимірювання газу",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Начальник служби ГВ та М                                                                                                                               Соловйов А.І.                                                                            03.04.2017    "]
[null,null,"Метрологічна служба, яка вимірює обсяги газу",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]

{"sheet":"додаток","index":1,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,1],[35,0,35,1],[3,2,3,4],[3,1,4,1],[3,0,4,0],[5,0,34,0]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу №174"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Сумська область","ГРС Cуми-1",38.222111893208726,9129.1947150341421,10.61725330366909]
[null,"ГРС Cуми-2",38.222650721880818,9129.3234120532743,10.617402978300227]
[null,"ПАТ «Сумське НВО»",38.22,9128.6902979999995,10.616666666666665]
[null,"ГРС Низи",38.222353068243535,9129.2523187023889,10.617320296734315]
[null,"ГРС Бішкінь",38.222262535141731,9129.2306952422077,10.617295148650481]
[null,"ГРС Тростянець",38.222235727198957,9129.2242922749901,10.617287701999709]
[null,"ГРС Косівщина",38.22262457981558,9129.3171681281747,10.617395716615439]
[null,"ГРС Старе (Червоне) Село",38.222513171382609,9129.2905586807337,10.617364769828502]
[null,"ГРС Дослідна станція",38.222258636362128,9129.2297640346842,10.617294065656147]
[null,"ГРС Ворожба",38.222736254514771,9129.3438411722091,10.617426737365214]
[null,"ГРС Загорське",38.22253916802412,9129.2967678719724,10.61737199111781]
[null,"ГРС Хотінь",38.222081772085865,9129.1875207274425,10.617244936690518]
[null,"ГРС Юнаківка",38.222212300287445,9129.218696853226,10.61728119452429]
[null,"ГРС Краснопілля",38.22235285098678,9129.2522668115034,10.617320236385217]
[null,"ГРС Осоївка",38.222733520984015,9129.3431882795958,10.617425978051115]
[null,"ГРС Могриця",38.222221513939374,9129.2208974962123,10.617283753872048]
[null,"ГРС Угроїди",38.223819453953908,9129.6025589171295,10.617727626098308]
[null,"ГРС Калинівка",0,0,0]
[null,"ГРС Віри",38.222224764699334,9129.2216739269006,10.617284656860926]
[null,"ГРС Білопілля",38.222067662906277,9129.1841508077468,10.617241017473965]
[null,"ГРС Путивль",38.222192529341434,9129.2139746438315,10.617275702594842]
[null,"ГРС Буринь",38.221917655166614,9129.1483220741593,10.617199348657392]
[null,"ГРС Дубов'язівка",38.221462559378615,9129.0396243110881,10.617072933160726]
[null,"ГРС Конотоп",38.221868845308535,9129.1366640396773,10.617185790363482]
[null,"ГРС Головашівка",38.221983883631495,9129.1641404714592,10.617217745453193]
[null,"ГРС Мартинівка",38.222480013045455,9129.2826389478541,10.617355559179293]
[null,"ГРС Олешня",38.222352270452113,9129.252128153179,10.617320075125587]
[null,"ГРС Гринцеве",38.222332615051748,9129.2474335413881,10.617314615292152]
[null,"ГРС Колядинець",38.22260916038725,9129.3134852609364,10.617391433440902]
[null,"ГРС Липова Долина",38.222029990025888,9129.1751527947235,10.617230552784969]
["Середньозважене значення вищої теплоти згоряння по маршруту № 174",null,38.222309740612722,9129.2419700754126,10.617308261281311]
[]
[]
[]
["Головний інженер Сумського ЛВУМГ                                                                                                                                      ",null,"Соловйов О.Б. ",null," 03.04.2017"]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,"прізвище","підпис","дата"]
["Завідувач ВХАЛ                                                                                                                                                                                                  ",null,"Журавльова В.В.  ",null," 03.04.2017"]
["Лабораторія, де здійснювалось вимірювання газу",null,"прізвище","підпис","дата"]
["Начальник служби МтаГВ                                                                                ",null,"Соловйов А.І.",null," 03.04.2017"]
["Підрозділу, відповідального за облік газу за маршрутом",null,"прізвище","підпис","дата"]

{"sheet":"variablesList","index":2,"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"]

{"sheet":"Лист1","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Данные по объекту Стенд (осн.) за 3/17."]
["День"," V, м3"," dP, кгс/м2"," Pабс, кгс/см2"," T, °C","ABC",null,{"$f":"SUM(B3:B33)","v":3246.94}]
[1,0,0,1.01,4.22]
[2,0,0,1.01,2.4]
[3,0,0,1.02,2.3199999999999998]
[4,0,0,1.02,3.65]
[5,0,0,1.02,5.17]
[6,0,0,1.01,3.64," B"]
[7,0,0,1.02,5.35]
[8,0,0,1.03,4.91]
[9,0,0,1.02,5.21]
[10,0,0,1.02,4.37]
[11,0,0,1.02,4.13]
[12,0,0,1.02,2.42]
[13,0,0,1.02,1.72," B"]
[14,0,0,1.02,3.26,"A"]
[15,0,0,1.02,5.92]
[16,0,0,1.01,1.79]
[17,0,0,1.01,0.24,"A"]
[18,0,0,1,4.17]
[19,0,0,1,1.89]
[20,0,0,1.01,0.5," B"]
[21,0,0,1.02,4.2300000000000004]
[22,0,0,1.02,7.11,"A"]
[23,0,0,1.02,4.17,"A"]
[24,0,0,1.02,4.8099999999999996]
[25,0,0,1.02,2.71," B"]
[26,0,0,1.02,0.94,"A"]
[27,0,0,1.01,4.2,"AB"]
[28,0,0,1.01,5,"AB"]
[29,3246.94,44.128999999999998,18.77,5.87,"A"]
[30,0,0,23.38,-0.38,"A"]
[31,0,0,23.07,5.0199999999999996,"A"]
["Итого",3246.94,1.4239999999999999,3.02,3.58,"AB"]