{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["паспорт"," розрахунок","додаток","variablesList"],"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":[[6,0,9,0],[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],[41,0,41,13],[8,3,9,3],[8,1,9,1],[8,2,9,2],[8,5,9,5],[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],[6,25,9,25],[7,13,9,13],[6,13,6,22],[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]]}
["ПАТ \"УКРТРАНСГАЗ\"",null,null,null,null,null,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 131"]
["Філія \"УМГ \"КИЇВТРАНСГАЗ\"",null,null,null,null,null,"переданого Диканським ЛВУМГ та прийнятого  ПАТ \"Харківгаз\""]
["Решетилівський п/м Диканське ЛВУМГ",null,null,null,null,null,"Маршрут № 131"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № 123/15 чинно до 31.12.2018 р.",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-30"]
[]
["Число місяця","Компонентний склад, % мол. ",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,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,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,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,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,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,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,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,25,7.2,null,null,null,0," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8350,34.96,9.7111111111111104,9250,38.729999999999997,10.758333333333333,null,null,null,null,null,null,null,null,0," "]
[12,92.422600000000003,4.0590000000000002,1.0042,0.12670000000000001,0.20849999999999999,5.1000000000000004E-3,5.9400000000000001E-2,4.9200000000000001E-2,0.1331,4.7999999999999996E-3,1.4000999999999999,0.52739999999999998,0.72940000000000005,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,11873,49.71,13.808333333333334,null,null,null,null,null,100.00009999999999," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,null,null,null,null,null,null,null,null,0," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,null,null,null,null,null,null,null,null,0," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,null,null,null,null,null,null,null,null,0," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,null,null,null,27.4,12.2,null,null,"відсут.",0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8340,34.92,9.7000000000000011,9239,38.68,10.744444444444444,null,null,null,null,null,null,null,null,0," "]
[18,92.320300000000003,4.0869999999999997,0.98409999999999997,0.12820000000000001,0.2109,4.3E-3,5.9700000000000003E-2,5.0099999999999999E-2,0.15820000000000001,4.5999999999999999E-3,1.4218999999999999,0.57069999999999999,0.73080000000000001,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,11866,49.68,13.799999999999999,null,null,"<0,006","<0,02",null,100,"ОК"]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,null,null,null,null,null,null,null,null,0," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,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,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,null,null,null,null,null,null,null,null,0," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,null,null,null,32.200000000000003,13,null,null,null,0,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,8343,34.93,9.7027777777777775,9241,38.69,10.747222222222222,null,null,null,null,null,null,null,null,0," "]
[25,92.264099999999999,4.0682,0.99380000000000002,0.12720000000000001,0.2092,5.3E-3,5.8700000000000002E-2,4.8500000000000001E-2,0.16120000000000001,4.7999999999999996E-3,1.4505999999999999,0.60850000000000004,0.73140000000000005,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,11852,49.62,13.783333333333331,null,null,null,null,null,100.0001," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,null,null,null,null,null,null,null,null,0," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,null,null,null,null,null,null,null,null,0," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,null,null,null,null,null,null,null,null,0," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,null,null,null,32.4,13.1,null,null,null,0," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8338,34.909999999999997,9.6972222222222211,9236,38.67,10.741666666666667,null,null,null,null,null,null,null,null,0]
[31,92.284599999999998,4.0636999999999999,1.0063,0.12820000000000001,0.2104,4.5999999999999999E-3,5.8999999999999997E-2,4.8800000000000003E-2,0.1545,5.0000000000000001E-3,1.4349000000000001,0.6,0.73119999999999996,8338,34.909999999999997,9.6972222222222211,9239,38.68,10.744444444444444,11856,49.64,13.788888888888888,null,null,null,null,null,99.999999999999986,"ОК"]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":8343.3594879641078},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":34.932580997973929},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":9.7034947216594265},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":9242.2302537866763},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":38.695339082829797},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":10.748705300786057}]
[null,null,null,null,null,null,null,"Середньозважене значення теплоти згоряння:"]
[]
[]
[null,"Заступник начальника управління Диканського ЛВУМГ        ",null,null,null,null,null,null,null,null,null,null,null,null,"Герасименко І.М.",null,null,null,null,null,null,"01.06.17р."]
[null,null,"Підрозділу підприємства, якому підпорядкована лабораторія",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Завідувач лабораторією      ",null,null,null,null,null,null,null,null,null,null,null,null,"Славінська А.В.",null,null,null,null,null,null,{"$f":"V46","v":"01.06.17р."}]
[null,null,"Лабораторія, де здійснювалось вимірювання газу",null,null,null,null,null,null,null,null,null,null,null,"прізвище",null,null,"підпис",null,null,null,"дата"]
[null,"Начальник служби ГВ та М         ",null,null,null,null,null,null,null,null,null,null,null,null,"Левадний С.А.",null,null,null,null,null,null,{"$f":"V46","v":"01.06.17р."}]
[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]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 131"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Харківська область","Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"ГРС Киселі"]
[1,{"$f":"паспорт!S11","v":38.729999999999997},194.89,{"$f":"SUM(C7:C7)","v":194.89}]
[2,{"$f":"паспорт!S12","v":38.729999999999997},191.13,191.13]
[3,{"$f":"паспорт!S13","v":38.729999999999997},201.66,201.66]
[4,{"$f":"паспорт!S14","v":38.729999999999997},170.67,170.67]
[5,{"$f":"паспорт!S15","v":38.729999999999997},206.58,206.58]
[6,{"$f":"паспорт!S16","v":38.729999999999997},269.41000000000003,269.41000000000003]
[7,{"$f":"паспорт!S17","v":38.729999999999997},255.4,255.4]
[8,{"$f":"паспорт!S18","v":38.729999999999997},222.1,222.1]
[9,{"$f":"паспорт!S19","v":38.729999999999997},220.84,220.84]
[10,{"$f":"паспорт!S20","v":38.729999999999997},271.64999999999998,271.64999999999998]
[11,{"$f":"паспорт!S21","v":38.729999999999997},446.92,446.92]
[12,{"$f":"паспорт!S22","v":38.68},621.16999999999996,621.16999999999996]
[13,{"$f":"паспорт!S23","v":38.68},693.89,693.89]
[14,{"$f":"паспорт!S24","v":38.68},663.32,663.32]
[15,{"$f":"паспорт!S25","v":38.68},462.51,462.51]
[16,{"$f":"паспорт!S26","v":38.68},328.24,328.24]
[17,{"$f":"паспорт!S27","v":38.68},317.22000000000003,317.22000000000003]
[18,{"$f":"паспорт!S28","v":38.69},503.23,503.23]
[19,{"$f":"паспорт!S29","v":38.69},573.13,573.13]
[20,{"$f":"паспорт!S30","v":38.69},609.6,609.6]
[21,{"$f":"паспорт!S31","v":38.69},505.83,505.83]
[22,{"$f":"паспорт!S32","v":38.69},439.55,439.55]
[23,{"$f":"паспорт!S33","v":38.69},279.95999999999998,279.95999999999998]
[24,{"$f":"паспорт!S34","v":38.69},252.09,252.09]
[25,{"$f":"паспорт!S35","v":38.67},177.32,177.32]
[26,{"$f":"паспорт!S36","v":38.67},160.18,160.18]
[27,{"$f":"паспорт!S37","v":38.67},203.2,203.2]
[28,{"$f":"паспорт!S38","v":38.67},199.04,199.04]
[29,{"$f":"паспорт!S39","v":38.67},156.79,156.79]
[30,{"$f":"паспорт!S40","v":38.67},123.99,123.99]
[31,{"$f":"паспорт!S41","v":38.68},117.63,117.63]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":10039.140000000001},{"$f":"SUM(D7:D37)","v":10039.140000000001}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":388467.9264},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":388467.9264}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.695339082829797},{"$f":"D39/D38","v":38.695339082829797}]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9242.2230890436567},{"$f":"D40*238.8459","v":9242.2230890436567}]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.748705300786055},{"$f":"D40/3.6","v":10.748705300786055}]

{"sheet":"додаток","index":2,"n_rows":16,"n_cols":6,"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]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу №131"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Харківська область","ГРС Киселі",{"$f":"' розрахунок'!C40","v":38.695339082829797},{"$f":"' розрахунок'!C41","v":9242.2230890436567},{"$f":"' розрахунок'!C42","v":10.748705300786055}]
["Середньозважене значення вищої теплоти згоряння по маршруту № 131",null,{"$f":"' розрахунок'!D40","v":38.695339082829797},{"$f":"' розрахунок'!D41","v":9242.2230890436567},{"$f":"' розрахунок'!D42","v":10.748705300786055}]
[]
[]
[]
["Заступник начальника управління Диканського ЛВУМГ ",null,null,"Герасименко І.М.",null,{"$f":"паспорт!V46","v":"01.06.17р."}]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
["Завідувач лабораторією                    ",null,null,"Славінська А.В.",null,{"$f":"F11","v":"01.06.17р."}]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
["Начальник служби ГВ та М ",null,null,"Левадний С.А. ",null,{"$f":"F11","v":"01.06.17р."}]
["Підрозділу, відповідального за облік газу за маршрутом",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"]