{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["паспорт"," розрахунок","додаток","variablesList","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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,25,0,27],[4,23,4,24],[4,21,4,22],[8,14,8,16],[8,17,8,19],[8,20,8,22],[0,6,0,24],[1,6,1,24],[2,6,2,24],[4,26,4,27],[8,7,9,7],[6,1,7,12],[7,13,9,13],[6,13,6,22],[6,23,9,23],[7,14,7,22],[8,9,9,9],[8,12,9,12],[8,3,9,3],[8,1,9,1],[8,2,9,2],[47,1,47,26],[43,20,43,27],[42,20,42,27],[41,20,41,27],[6,27,9,27],[41,16,42,16],[41,17,42,17],[41,0,41,13],[8,10,9,10],[6,25,9,25],[45,1,45,26],[8,4,9,4],[8,8,9,8],[6,26,9,26],[6,24,9,24],[8,5,9,5],[8,6,9,6],[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]]}
["ПАТ \"УКРТРАНСГАЗ\"",null,null,null,null,null,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 173"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Сумським ЛВУМГ та прийнятого  ПАТ \"Сумигаз\""]
["Сумського ЛВУМГ",null,null,null,null,null,"Маршрут № 173"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № РУ-0053/17 чинне до  10 травня 2022 р.",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,8249.7373860000007,34.51,9.5944444444444432,9143.0210520000001,38.24,10.633333333333333,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,8249.7373860000007,34.51,9.5944444444444432,9143.0210520000001,38.24,10.633333333333333,null,null,null,null,null,null,null,null,0]
[3,95.363799999999998,2.6469999999999998,0.84099999999999997,0.127,0.124,1.6999999999999999E-3,2.3E-2,1.6799999999999999E-2,1.12E-2,4.4999999999999997E-3,0.629,0.21099999999999999,0.70499999999999996,{"$f":"P13*238.8459","v":8247.3489270000009},34.53,{"$f":"P13/3.6","v":9.5916666666666668},{"$f":"S13*238.8459","v":9138.2441339999987},38.26,{"$f":"S13/3.6","v":10.627777777777776},{"$f":"V13*238.8459","v":11944.683459},50.01,{"$f":"V13/3.6","v":13.891666666666666},-21.6,null,null,null,null,99.999999999999986,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":"ОК"}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,-23.2,null,null,null,null,0,{"$f":"IF(AC14=100,\"ОК\",\" \")","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,-22.7,null,null,null,null,0,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8247.3489270000009,34.53,9.5916666666666668,9138.2441339999987,38.26,10.627777777777776,null,null,null,null,null,null,null,null,0,""]
[10,95.308899999999994,2.698,0.85799999999999998,0.128,0.126,1.6000000000000001E-3,2.2200000000000001E-2,1.61E-2,1.18E-2,4.4000000000000003E-3,0.60699999999999998,0.218,0.70540000000000003,8254.5143040000003,34.56,9.6,9145.4095109999998,38.29,10.636111111111111,{"$f":"V20*238.8459","v":11951.848835999999},50.04,{"$f":"V20/3.6","v":13.899999999999999},-22.8,-19.600000000000001,1E-4,"<0,01",0,99.999999999999986,"ОК"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8254.5143040000003,34.56,9.6,9145.4095109999998,38.29,10.636111111111111,null,null,null,-22.3,-18.8,null,null,null,0,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8254.5143040000003,34.56,9.6,9145.4095109999998,38.29,10.636111111111111,null,null,null,-22.2,-20.100000000000001,null,null,null,0,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8254.5143040000003,34.56,9.6,9145.4095109999998,38.29,10.636111111111111,null,null,null,-21.2,-18.23,null,null,null,0,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8254.5143040000003,34.56,9.6,9145.4095109999998,38.29,10.636111111111111,null,null,null,null,null,null,null,null,0,""]
[15,95.196299999999994,2.7679999999999998,0.878,0.13300000000000001,0.13,1.6000000000000001E-3,2.4500000000000001E-2,1.7500000000000002E-2,1.2800000000000001E-2,4.3E-3,0.60199999999999998,0.23200000000000001,0.70650000000000002,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,{"$f":"V25*238.8459","v":11954.237294999999},50.05,{"$f":"V25/3.6","v":13.902777777777777},-22,-18.899999999999999,null,null,null,99.999999999999986,"ОК"]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,null,null,null,-22,-18.8,null,null,null,0,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,null,null,null,-22.7,-19.600000000000001,null,null,null,0,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,null,null,null,-22.6,-20.2,null,null,null,0,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,null,null,null,-23.3,-19.899999999999999,null,null,null,0,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,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,8261.6796810000014,34.590000000000003,9.6083333333333343,9154.963346999999,38.33,10.647222222222222,null,null,null,null,null,null,null,null,0,""]
[22,95.142700000000005,2.8090000000000002,0.89500000000000002,0.13300000000000001,0.129,1.6999999999999999E-3,2.3E-2,1.6400000000000001E-2,1.09E-2,4.3E-3,0.60299999999999998,0.23200000000000001,0.70679999999999998,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,{"$f":"V32*238.8459","v":11956.625754000001},50.06,{"$f":"V32/3.6","v":13.905555555555555},-23.1,-20.399999999999999,null,null,null,100,"ОК"]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,-22.3,-19.899999999999999,null,null,null,0,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":""}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,-23.2,-20.8,null,null,null,0,""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,-24.1,-21.1,null,null,null,0,""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,-23.5,-19.899999999999999,null,null,null,0,""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,null,null,null,null,null,0,""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.4565989999992,34.61,9.6138888888888889,9159.7402650000004,38.35,10.652777777777779,null,null,null,null,null,null,null,null,0]
[29,95.478999999999999,2.5379999999999998,0.84599999999999997,0.129,0.129,1.6999999999999999E-3,2.3199999999999998E-2,1.6500000000000001E-2,1.0999999999999999E-2,4.5999999999999999E-3,0.627,0.19500000000000001,0.70430000000000004,8242.5720089999995,34.51,9.5861111111111104,9135.8556750000007,38.25,10.625,{"$f":"V39*238.8459","v":11947.071918000001},50.02,{"$f":"V39/3.6","v":13.894444444444446},-21.4,-18.399999999999999,null,null,null,99.999999999999986]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P40*238.8459","v":8242.5720089999995},34.51,{"$f":"P40/3.6","v":9.5861111111111104},{"$f":"S40*238.8459","v":9135.8556750000007},38.25,{"$f":"S40/3.6","v":10.625},null,null,null,-22,-19.100000000000001,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8242.5720089999995,34.51,9.5861111111111104,9135.8556750000007,38.25,10.625,null,null,null,-22.9,-19.5,null,null,null,0]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,8256.2762606535762,34.566064552752117,9.6020491555591754,9148.4099403948494,38.300812321265077,10.639600610448051]
[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":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,3,5,3],[0,0,0,1],[3,0,5,0],[3,1,5,1]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 173"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Сумська область","Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ГРС Терешківка"]
[1,{"$f":"паспорт!S11","v":38.24},674.73659999999995,{"$f":"SUM(C7:C7)","v":674.73659999999995}]
[2,{"$f":"паспорт!S12","v":38.24},672.47900000000004,672.47900000000004]
[3,{"$f":"паспорт!S13","v":38.26},622.13810000000001,622.13810000000001]
[4,{"$f":"паспорт!S14","v":38.26},710.79660000000001,710.79660000000001]
[5,{"$f":"паспорт!S15","v":38.26},794.47879999999998,794.47879999999998]
[6,{"$f":"паспорт!S16","v":38.26},788.40509999999995,788.40509999999995]
[7,{"$f":"паспорт!S17","v":38.26},668.15139999999997,668.15139999999997]
[8,{"$f":"паспорт!S18","v":38.26},789.63959999999997,789.63959999999997]
[9,{"$f":"паспорт!S19","v":38.26},1024.203,1024.203]
[10,{"$f":"паспорт!S20","v":38.29},1521.6406999999999,1521.6406999999999]
[11,{"$f":"паспорт!S21","v":38.29},1607.7732000000001,1607.7732000000001]
[12,{"$f":"паспорт!S22","v":38.29},1918.9789000000001,1918.9789000000001]
[13,{"$f":"паспорт!S23","v":38.29},2468.7556,2468.7556]
[14,{"$f":"паспорт!S24","v":38.29},1912.425,1912.425]
[15,{"$f":"паспорт!S25","v":38.33},1105.4131,1105.4131]
[16,{"$f":"паспорт!S26","v":38.33},888.25980000000004,888.25980000000004]
[17,{"$f":"паспорт!S27","v":38.33},1380.1185,1380.1185]
[18,{"$f":"паспорт!S28","v":38.33},1450.1287,1450.1287]
[19,{"$f":"паспорт!S29","v":38.33},1739.2156,1739.2156]
[20,{"$f":"паспорт!S30","v":38.33},1310.6162999999999,1310.6162999999999]
[21,{"$f":"паспорт!S31","v":38.33},987.06219999999996,987.06219999999996]
[22,{"$f":"паспорт!S32","v":38.35},852.3723,852.3723]
[23,{"$f":"паспорт!S33","v":38.35},699.17349999999999,699.17349999999999]
[24,{"$f":"паспорт!S34","v":38.35},637.97050000000002,637.97050000000002]
[25,{"$f":"паспорт!S35","v":38.35},551.52380000000005,551.52380000000005]
[26,{"$f":"паспорт!S36","v":38.35},501.20389999999998,501.20389999999998]
[27,{"$f":"паспорт!S37","v":38.35},574.13819999999998,574.13819999999998]
[28,{"$f":"паспорт!S38","v":38.35},566.07489999999996,{"$f":"SUM(C34:C34)","v":566.07489999999996}]
[29,{"$f":"паспорт!S39","v":38.25},445.33589999999998,{"$f":"SUM(C35:C35)","v":445.33589999999998}]
[30,{"$f":"паспорт!S40","v":38.25},457.44959999999998,{"$f":"SUM(C36:C36)","v":457.44959999999998}]
[31,{"$f":"паспорт!S41","v":38.25},475.017,{"$f":"SUM(C37:C37)","v":475.017}]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":30795.6754},{"$f":"SUM(D7:D37)","v":30795.6754}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":1179499.3838019997},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":1179499.3838019997}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.300812321265077},{"$f":"D39/D38","v":38.300812321265077}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9147.9919896036463},{"$f":"D40*238.8459","v":9147.9919896036463}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.639114533684744},{"$f":"D40/3.6","v":10.639114533684744}]

{"sheet":"додаток","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"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]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу №173"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Сумська область","ГРС Терешківка",38.300812321265077,9147.9919896036463,10.639114533684744]
["Середньозважене значення вищої теплоти згоряння по маршруту № 173",null,38.300812321265077,9147.9919896036463,10.639114533684744]
[]
[]
[]
["Головний інженер Сумського ЛВУМГ                                                                                                                                      ",null,"Соловйов О.Б. ",null,"2017-06-01"]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,"прізвище","підпис","дата"]
["Завідувач ВХАЛ                                                                                                                                                                                                  ",null,"Журавльова В.В.  ",null,"2017-06-01"]
["Лабораторія, де здійснювалось вимірювання газу",null,"прізвище","підпис","дата"]
["Начальник служби МтаГВ                                                                                ",null,"Соловйов А.І.",null,"2017-06-01"]
["Підрозділу, відповідального за облік газу за маршрутом",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"]

{"sheet":"Лист1","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Данные по объекту Счетчик-ТЕРЕШКОВКА (осн.) за 5/17."]
["День"," V, м3"," Vру, м3"," Pабс, кгс/см2"," T, °C","ABC"]
[1,674.73659999999995,228,3.0030000000000001,15.494999999999999,"A"]
[2,672.47900000000004,226,3.004,14.465,"A"]
[3,622.13810000000001,207,3.01,12.22,"AB"]
[4,710.79660000000001,236,3.004,11.32,"A"]
[5,794.47879999999998,262.00009999999997,2.996,8.48,"A"]
[6,788.40509999999995,264.00009999999997,2.9980000000000002,13.045999999999999,"A"]
[7,668.15139999999997,227,2.9940000000000002,16.065000000000001,"A"]
[8,789.63959999999997,267.00009999999997,2.9689999999999999,12.269,"A"]
[9,1024.203,335.00009999999997,2.9590000000000001,2.6190000000000002,"A"]
[10,1521.6406999999999,487.00009999999997,2.96,-2.3450000000000002,"AB"]
[11,1607.7732000000001,517.00009999999997,2.9769999999999999,0.19400000000000001,"A"]
[12,1918.9789000000001,611.00009999999997,2.9590000000000001,-4.0949999999999998]
[13,2468.7556,782.00009999999997,2.9529999999999998,-6.0949999999999998]
[14,1912.425,612.00009999999997,2.97,-1.877]
[15,1105.4131,361.00009999999997,2.9929999999999999,5.944,"AB"]
[16,888.25980000000004,296.00009999999997,2.9830000000000001,10.565,"A"]
[17,1380.1185,445.00009999999997,2.9750000000000001,0.52600000000000002,"A"]
[18,1450.1287,462.00009999999997,2.9940000000000002,-1.081,"A"]
[19,1739.2156,557.00009999999997,2.9710000000000001,-1.873,"A"]
[20,1310.6162999999999,429.00009999999997,2.968,4.2699999999999996,"A"]
[21,987.06219999999996,330.00009999999997,2.9729999999999999,10.404999999999999,"A"]
[22,852.3723,283.00009999999997,2.9769999999999999,8.452,"AB"]
[23,699.17349999999999,236,2.9969999999999999,15.208,"A"]
[24,637.97050000000002,216,3.0019999999999998,15.898,"A"]
[25,551.52380000000005,187,3.0129999999999999,17.036999999999999,"A"]
[26,501.20389999999998,170,3.0049999999999999,16.405999999999999]
[27,574.13819999999998,194,2.9940000000000002,14.069000000000001,"A"]
[28,566.07489999999996,191,3.0129999999999999,15.272,"A"]
[29,445.33589999999998,153,3.0059999999999998,20.614999999999998,"AB"]
[30,457.44959999999998,156,3.004,17.216000000000001]
[31,475.017,164,3.0139999999999998,21.913,"A"]
["Итого",30795.675500000001,10091.0018,2.988,9.1159999999999997,"AB"]