{"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":[[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,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 25"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Боярським ЛВУМГ та прийнятого  ПАТ \"Київоблгаз\""]
["Боярське ЛВУМГ",null,null,null,null,null,"Маршрут №25"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № 70А-43-14 чинно до 23.07.2019 р.  ",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":8199.5797469999998},34.33,{"$f":"P11/3.6","v":9.5361111111111097},{"$f":"S11*238.8459","v":9083.309577},38.03,{"$f":"S11/3.6","v":10.563888888888888},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,{"$f":"P12*238.8459","v":8199.5797469999998},34.33,9.5361111111111097,{"$f":"S12*238.8459","v":9083.309577},38.03,10.563888888888888,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8199.5797469999998,34.33,9.5361111111111097,9083.309577,38.03,10.563888888888888,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,8199.5797469999998,34.33,9.5361111111111097,9083.309577,38.03,10.563888888888888,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,8199.5797469999998,34.33,9.5361111111111097,9083.309577,38.03,10.563888888888888,null,null,null,null,null,null,null,null,0," "]
[6,89.6233,4.9678000000000004,1.0590999999999999,0.11,0.16919999999999999,3.5999999999999999E-3,4.41E-2,3.7499999999999999E-2,6.9900000000000004E-2,1.6299999999999999E-2,1.6929000000000001,2.2063999999999999,0.753,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,{"$f":"V16*238.8459","v":11500.430085},48.15,{"$f":"V16/3.6","v":13.375},-15.6,-14.8,null,null,null,100.0001," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8209.1335829999989,34.369999999999997,9.5472222222222207,9092.8634130000009,38.07,10.574999999999999,null,null,null,null,null,null,null,null,0," "]
[13,89.545299999999997,5.0662000000000003,1.0952,0.1118,0.16980000000000001,3.5999999999999999E-3,4.4499999999999998E-2,3.6299999999999999E-2,6.6400000000000001E-2,9.1999999999999998E-3,1.7153,2.1362999999999999,0.75319999999999998,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,{"$f":"V23*238.8459","v":11517.149298},48.22,{"$f":"V23/3.6","v":13.394444444444444},null,null,null,null,null,99.999900000000011," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[20,89.481899999999996,5.0678000000000001,1.0801000000000001,0.11269999999999999,0.1739,3.8999999999999998E-3,4.6399999999999997E-2,3.9100000000000003E-2,7.6899999999999996E-2,1.0699999999999999E-2,1.7512000000000001,2.1554000000000002,0.754,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,{"$f":"V30*238.8459","v":11509.983920999999},48.19,{"$f":"V30/3.6","v":13.386111111111109},-12.9,-11.9,null,null,null,100.00000000000001,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":"ОК"}]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31*238.8459","v":8223.4643369999994},34.43,{"$f":"P31/3.6","v":9.5638888888888882},{"$f":"S31*238.8459","v":9107.1941670000015},38.130000000000003,{"$f":"S31/3.6","v":10.591666666666667},null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,{"$f":"P33/3.6","v":9.5638888888888882},9107.1941670000015,38.130000000000003,{"$f":"S33/3.6","v":10.591666666666667},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,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,10.591666666666667,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8223.4643369999994,34.43,9.5638888888888882,9107.1941670000015,38.130000000000003,{"$f":"S36/3.6","v":10.591666666666667},null,null,null,null,null,null,null,null,0," "]
[27,89.766199999999998,4.8856999999999999,1.0467,0.1133,0.17369999999999999,4.1999999999999997E-3,4.7399999999999998E-2,3.95E-2,8.0100000000000005E-2,1.54E-2,1.7273000000000001,2.1006999999999998,0.75190000000000001,8213.9105010000003,34.39,9.5527777777777771,9097.6403310000005,38.090000000000003,10.580555555555556,{"$f":"V37*238.8459","v":11514.760839},48.21,{"$f":"V37/3.6","v":13.391666666666666},null,null,6.0000000000000001E-3,0.02,"відсут",100.00019999999999," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8213.9105010000003,34.39,9.5527777777777771,9097.6403310000005,38.090000000000003,10.580555555555556,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8213.9105010000003,34.39,9.5527777777777771,9097.6403310000005,38.090000000000003,10.580555555555556,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8213.9105010000003,34.39,9.5527777777777771,9097.6403310000005,38.090000000000003,10.580555555555556,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,8213.9105010000003,34.39,9.5527777777777771,9097.6403310000005,38.090000000000003,10.580555555555556,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,' розрахунок'!G7:G37)/' розрахунок'!G38","v":8214.5806799625825},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":34.392805905240927},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":9.5535571959002556},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":9098.3105099625864},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":38.092805905240944},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!G7:G37)/' розрахунок'!G38","v":10.581334973678036}]
[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":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[[3,6,5,6],[0,0,0,1],[3,0,5,0],[3,1,5,1],[3,2,3,5],[4,2,4,5]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 25"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Київська область",null,null,null,"Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ГРС Обухів (ДРЕС)","ГРС Обухів ","ГРС Бугаївка","ГРС Козин"]
[1,38.03,354.238,64.667000000000002,32.668999999999997,43.921999999999997,{"$f":"SUM(C7:F7)","v":495.49599999999998}]
[2,38.03,387.28500000000003,65.412999999999997,33.454999999999998,46.192,532.34500000000003]
[3,38.03,385.30500000000001,64.774000000000001,33.526000000000003,54.927,538.53200000000004,null,38.092301018639127,38.094204335282726,38.094095612217131,38.094719106011588,38.092910358076118]
[4,38.03,375.43799999999999,63.081000000000003,32.423999999999999,53.838000000000001,524.78099999999995,null,9098.1899198677784,9098.6445192445044,9098.6185511860513,9098.7674701225333,9098.3354580940122]
[5,38.03,383.66,61.41,30.105,50.557000000000002,525.73200000000008,null,10.581194727399756,10.581723426467423,10.58169322561587,10.581866418336553,10.581363988354477]
[6,38.07,380.93099999999998,58.085000000000001,28.271000000000001,47.176000000000002,514.46299999999997]
[7,38.07,341.72699999999998,55.000999999999998,27.311,46.125999999999998,470.16499999999991]
[8,38.07,314.15899999999999,60.317999999999998,29.661999999999999,50.018000000000001,454.15699999999993,null,38.092301018639127,9098.1899198677784,10.581194727399756]
[9,38.07,286.10500000000002,59.223999999999997,30.53,51.167000000000002,427.02600000000007,null,38.094204335282726,9098.6445192445044,10.581723426467423]
[10,38.07,301.88600000000002,57.19,28.92,48.622999999999998,436.61900000000003,null,38.094095612217131,9098.6185511860513,10.58169322561587]
[11,38.07,301.73899999999998,59.637999999999998,29.225999999999999,49.509,440.11199999999997,null,38.094719106011588,9098.7674701225333,10.581866418336553]
[12,38.07,311.24799999999999,60.9,30.484000000000002,51.274999999999999,453.90699999999993,null,38.092910358076118,9098.3354580940122,10.581363988354477]
[13,38.130000000000003,317.20699999999999,61.104999999999997,30.044,50.481000000000002,458.83699999999999]
[14,38.130000000000003,295.95600000000002,69.027000000000001,34.192999999999998,57.186999999999998,456.363]
[15,38.130000000000003,452.76799999999997,94.926000000000002,52.646999999999998,78.378,678.71900000000005]
[16,38.130000000000003,332.40699999999998,63.756999999999998,30.625,52.787999999999997,479.577]
[17,38.130000000000003,316.77499999999998,60.412999999999997,30.574999999999999,52.281999999999996,460.04499999999996]
[18,38.130000000000003,327.31200000000001,68.212000000000003,34.968000000000004,57.945,488.43700000000001]
[19,38.130000000000003,334.04700000000003,68.866,34.463000000000001,56.917000000000002,494.29300000000001]
[20,38.130000000000003,314.48700000000002,62.747,30.581,50.774999999999999,458.59000000000003]
[21,38.130000000000003,330.65699999999998,57.523000000000003,27.856000000000002,45.893999999999998,461.93]
[22,38.130000000000003,294.23,46.197000000000003,21.117000000000001,35.667999999999999,397.21200000000005]
[23,38.130000000000003,302.983,53.3,25.332000000000001,41.887,423.50200000000001]
[24,38.130000000000003,306.39299999999997,52.430999999999997,26.007000000000001,42.744999999999997,427.57599999999996]
[25,38.130000000000003,296.90699999999998,54.584000000000003,27.638999999999999,45.591999999999999,424.72199999999998]
[26,38.130000000000003,297.70499999999998,60.523000000000003,31.562999999999999,51.125999999999998,440.91699999999997]
[27,38.090000000000003,297.72399999999999,58.768999999999998,28.302,45.707000000000001,430.50200000000001]
[28,38.090000000000003,297.47899999999998,47.707999999999998,22.588999999999999,37.776000000000003,405.55200000000002]
[29,38.090000000000003,332.87200000000001,42.194000000000003,19.896000000000001,32.984000000000002,427.94600000000003]
[30,38.090000000000003,372.61799999999999,50.113999999999997,24.905000000000001,41.698,489.33499999999992]
[31,38.090000000000003,408.26299999999998,50.94,25.300999999999998,41.030999999999999,525.53499999999997]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":10352.510999999999},1853.0370000000003,925.18599999999981,1512.191,{"$f":"SUM(G7:G37)","v":14642.924999999997}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT($B$7:$B$37,C7:C37)","v":394350.02589000005},70589.755950000006,35244.020320000003,57606.297750000012,{"$f":"SUMPRODUCT(B7:B37,G7:G37)","v":557790.09991000011}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.092210275362191},{"$f":"D39/D38","v":38.094088758076602},{"$f":"E39/E38","v":38.093983609782263},{"$f":"F39/F38","v":38.094591060256285},{"$f":"G39/G38","v":38.092805905240944}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9098.1682462081299},{"$f":"D40*238.8459","v":9098.6169141026876},9098.5917998636942,9098.7368869188667,9098.3105099625882]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.581169520933942},{"$f":"D40/3.6","v":10.581691321687945},10.581662113828406,10.58183085007119,10.58133497367804]

{"sheet":"додаток","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,0,9,1],[3,2,3,4],[3,1,4,1],[3,0,4,0]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу №25"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Київська область","ГРС Обухів (ДРЕС)",38.092301018639127,9098.1899198677784,10.581194727399756]
[null,"ГРС Обухів (місто)",38.094204335282726,9098.6445192445044,10.581723426467423]
[null,"ГРС Бугаївка",38.094095612217131,9098.6185511860513,10.58169322561587]
[null,"ГРС Козин",38.094719106011588,9098.7674701225333,10.581866418336553]
["Середньозважене значення вищої теплоти згоряння по маршруту № 25",null,38.092910358076118,9098.3354580940122,10.581363988354477]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Головний інженер  Боярського ЛВУМГ                                                                Табак С.М.                                                        03.04.2017 р.                                                                                  "]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
["Завідувач вимірювальної хіміко-аналітичної лабораторії                                 Клименко І.А.                                                      03.04.2017 р.                                                       "]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
["Начальник служби газовимірювань та метрології                                               Прима Ю.І.                                                         03.04.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"]