{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["паспорт","variablesList","додаток"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":49,"n_cols":31,"rows_kept":49,"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],[8,3,9,3],[41,1,41,13],[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,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 806"]
["Філія \"УМГ \"Черкаситрансгаз\"",null,null,null,null,null,"переданого Барським ЛВУМГ та прийнятого  ПАТ \"Вінницягаз\" та ДП \"Монтажник\" ТОВ \"Валінор\""]
["Барський п/м Барське ЛВУМГ",null,null,null,null,null,"Маршрут №806"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № ПУ-0124/15 чинно до 20.10.2018 р.",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,96.285600000000002,2.0373000000000001,0.62649999999999995,9.7000000000000003E-2,9.4399999999999998E-2,1.2999999999999999E-3,1.7899999999999999E-2,1.2E-2,1.14E-2,6.4000000000000003E-3,0.65990000000000004,0.15029999999999999,0.69699999999999995,8171,34.21,{"$f":"P11/3.6","v":9.5027777777777782},9062,37.94,{"$f":"S11/3.6","v":10.538888888888888},11912,49.87,{"$f":"V11/3.6","v":13.852777777777776},-20.2,null,null,null,null,{"$f":"SUM(B11:M11)+$K$42+$N$42","v":99.999999999999972}]
[2,96.292599999999993,2.0276000000000001,0.622,9.5600000000000004E-2,9.3100000000000002E-2,1.2999999999999999E-3,1.7399999999999999E-2,1.1599999999999999E-2,1.0699999999999999E-2,7.1999999999999998E-3,0.67379999999999995,0.1472,0.69689999999999996,8168,34.200000000000003,9.5,9059,37.93,{"$f":"S12/3.6","v":10.536111111111111},11909,49.86,{"$f":"V12/3.6","v":13.85},-20.8,null,null,null,null,100.0001]
[3,96.193700000000007,2.0878000000000001,0.64119999999999999,9.8599999999999993E-2,9.5699999999999993E-2,1.1999999999999999E-3,1.8100000000000002E-2,1.21E-2,1.17E-2,7.6E-3,0.6784,0.154,0.69769999999999999,8175,34.229999999999997,9.5083333333333329,9066,37.96,10.544444444444444,11912,49.87,{"$f":"V13/3.6","v":13.852777777777776},-20.3,null,null,null,null,100.0001,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":" "}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,8175,34.229999999999997,9.5083333333333329,9066,37.96,10.544444444444444,null,null,{"$f":"V14/3.6","v":0},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,8175,34.229999999999997,9.5083333333333329,9066,37.96,10.544444444444444,null,null,{"$f":"V15/3.6","v":0},null,null,null,null,null,0," "]
[6,96.092299999999994,2.1648999999999998,0.66410000000000002,0.10199999999999999,9.9400000000000002E-2,1.2999999999999999E-3,1.8800000000000001E-2,1.2500000000000001E-2,1.21E-2,7.4000000000000003E-3,0.66439999999999999,0.16070000000000001,0.6986,8185,34.270000000000003,9.5194444444444457,9077,38.020000000000003,10.561111111111112,11918,49.9,{"$f":"V16/3.6","v":13.861111111111111},-21,null,null,null,null,99.999900000000025," "]
[7,96.040999999999997,2.1918000000000002,0.67749999999999999,0.1043,0.1014,1.2999999999999999E-3,1.89E-2,1.2699999999999999E-2,1.1599999999999999E-2,7.6E-3,0.67220000000000002,0.15959999999999999,0.69899999999999995,8189,34.28,9.5222222222222221,9080,38.020000000000003,10.561111111111112,11920,49.9,{"$f":"V17/3.6","v":13.861111111111111},null,null,null,null,null,99.999899999999982," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8189,34.28,9.5222222222222221,9080,38.020000000000003,10.561111111111112,null,null,0,null,null,null,null,null,0," "]
[9,95.881799999999998,2.3003,0.70909999999999995,0.1094,0.1069,1.4E-3,2.0299999999999999E-2,1.35E-2,1.24E-2,1.03E-2,0.66439999999999999,0.17030000000000001,0.70040000000000002,8202,34.340000000000003,9.5388888888888896,9094,38.08,10.577777777777778,11926,49.93,{"$f":"V19/3.6","v":13.869444444444444},-21.4,null,0,0,0,100.00009999999999," "]
[10,95.809700000000007,2.3469000000000002,0.73129999999999995,0.1128,0.11020000000000001,1.2999999999999999E-3,2.0799999999999999E-2,1.38E-2,1.2E-2,1.01E-2,0.65600000000000003,0.1749,0.70099999999999996,8209,34.369999999999997,{"$f":"P20/3.6","v":9.5472222222222207},9102,38.11,{"$f":"S20/3.6","v":10.58611111111111},11931,49.95,13.875,-20.9,null,null,null,null,99.999800000000008," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8209,34.369999999999997,9.5472222222222207,9102,38.11,10.58611111111111,null,null,0,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8209,34.369999999999997,9.5472222222222207,9102,38.11,10.58611111111111,null,null,0,null,null,null,null,null,0," "]
[13,95.901700000000005,2.2629999999999999,0.70250000000000001,0.1105,0.1071,1.2999999999999999E-3,2.06E-2,1.37E-2,1.1900000000000001E-2,1.3100000000000001E-2,0.68789999999999996,0.16669999999999999,0.70020000000000004,8197,34.32,9.5333333333333332,9089,38.049999999999997,10.569444444444443,11921,49.91,13.863888888888887,-20.5,null,null,null,null,100.00000000000001,"ОК"]
[14,95.935000000000002,2.2463000000000002,0.70140000000000002,0.1111,0.10730000000000001,1.2999999999999999E-3,2.1299999999999999E-2,1.41E-2,1.52E-2,9.7999999999999997E-3,0.67459999999999998,0.16250000000000001,0.70009999999999994,8199,34.33,9.5361111111111097,9091,38.06,10.572222222222223,11925,49.93,13.869444444444444,-20.5,null,null,null,null,99.999899999999982," "]
[15,95.899799999999999,2.2904,0.71120000000000005,0.1119,0.10829999999999999,1.2999999999999999E-3,2.1000000000000001E-2,1.4E-2,1.32E-2,5.8999999999999999E-3,0.65459999999999996,0.16850000000000001,0.70040000000000002,8204,34.35,9.5416666666666661,9097,38.090000000000003,10.580555555555556,11929,49.95,13.875,-20.8,null,null,null,null,100.0001," "]
[16,95.8934,2.2827000000000002,0.70489999999999997,0.1101,0.1067,1.2999999999999999E-3,2.06E-2,1.37E-2,1.3899999999999999E-2,9.7000000000000003E-3,0.67359999999999998,0.16930000000000001,0.70030000000000003,8200,34.33,{"$f":"P26/3.6","v":9.5361111111111097},9093,38.07,{"$f":"S26/3.6","v":10.574999999999999},11924,49.92,13.866666666666667,-20.7,null,null,null,null,99.999900000000011," "]
[17,95.864999999999995,2.3008000000000002,0.7097,0.111,0.1076,1.2999999999999999E-3,2.0899999999999998E-2,1.41E-2,1.46E-2,8.8000000000000005E-3,0.67549999999999999,0.17080000000000001,0.7006,8202,34.340000000000003,9.5388888888888896,9095,38.08,10.577777777777778,11925,49.93,13.869444444444444,-20.8,null,null,null,null,100.00009999999999," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8202,34.340000000000003,9.5388888888888896,9095,38.08,10.577777777777778,null,null,{"$f":"V28/3.6","v":0},null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8202,34.340000000000003,9.5388888888888896,9095,38.08,10.577777777777778,null,null,0,null,null,null,null,null,0," "]
[20,95.711799999999997,2.427,0.75919999999999999,0.1188,0.1152,1.4E-3,2.1700000000000001E-2,1.44E-2,1.2500000000000001E-2,8.9999999999999993E-3,0.63490000000000002,0.17399999999999999,0.70199999999999996,8222,34.42,9.5611111111111118,9116,38.17,10.602777777777778,11941,49.99,13.886111111111111,-21,null,null,null,null,99.999900000000011,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":" "}]
[21,95.684700000000007,2.4283999999999999,0.7651,0.121,0.1172,1.4E-3,2.23E-2,1.4999999999999999E-2,1.32E-2,1.0500000000000001E-2,0.64770000000000005,0.17369999999999999,0.70220000000000005,8223,34.43,9.5638888888888882,9117,38.17,10.602777777777778,11940,49.99,13.886111111111111,-20.3,null,null,null,null,100.00019999999999," "]
[22,95.587400000000002,2.4908000000000001,0.78569999999999995,0.12470000000000001,0.1207,1.5E-3,2.3E-2,1.54E-2,1.49E-2,8.9999999999999993E-3,0.64459999999999995,0.1822,0.70309999999999995,8231,34.46,9.5722222222222229,9126,38.21,10.613888888888889,11944,50.01,13.891666666666666,-20.9,null,null,null,null,99.999899999999997," "]
[23,95.763300000000001,2.3698999999999999,0.74870000000000003,0.1198,0.1153,1.4E-3,2.24E-2,1.5100000000000001E-2,1.4500000000000001E-2,1.11E-2,0.65210000000000001,0.1663,0.7016,8217,34.4,{"$f":"P33/3.6","v":9.5555555555555554},9111,38.15,{"$f":"S33/3.6","v":10.597222222222221},11937,49.98,13.883333333333333,-20.9,null,null,null,null,99.999900000000025,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,95.515699999999995,2.5529000000000002,0.80789999999999995,0.12790000000000001,0.1236,1.5E-3,2.35E-2,1.5699999999999999E-2,1.55E-2,6.4999999999999997E-3,0.61780000000000002,0.1915,0.70389999999999997,8241,34.5,9.5833333333333339,9136,38.25,10.625,11952,50.04,13.899999999999999,-21.2,null,null,null,null,99.999999999999986,"ОК"]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8241,34.5,9.5833333333333339,9136,38.25,10.625,null,null,{"$f":"V35/3.6","v":0},null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8241,34.5,9.5833333333333339,9136,38.25,{"$f":"S36/3.6","v":10.625},null,null,0,null,null,null,null,null,0," "]
[27,95.355599999999995,2.6598000000000002,0.84409999999999996,0.1356,0.13059999999999999,1.6000000000000001E-3,2.4899999999999999E-2,1.6500000000000001E-2,1.52E-2,7.7999999999999996E-3,0.6119,0.19639999999999999,0.70520000000000005,8255,34.56,9.6,9151,38.32,10.644444444444444,11960,50.07,13.908333333333333,-21,null,null,null,null,99.999999999999986,"ОК"]
[28,95.5428,2.5242,0.80020000000000002,0.1288,0.1237,1.5E-3,2.3599999999999999E-2,1.5800000000000002E-2,1.55E-2,8.8999999999999999E-3,0.63300000000000001,0.18190000000000001,0.7036,8238,34.49,9.5805555555555557,9133,38.24,10.622222222222222,11949,50.03,13.897222222222222,-20.7,null,null,null,null,99.999899999999982," "]
[29,95.421099999999996,2.6166,0.82679999999999998,0.1303,0.1265,1.5E-3,2.3900000000000001E-2,1.5699999999999999E-2,1.4E-2,9.4000000000000004E-3,0.62260000000000004,0.19159999999999999,0.7046,8247,34.53,9.5916666666666668,9143,38.28,{"$f":"S39/3.6","v":10.633333333333333},11955,50.05,13.902777777777777,-21.4,null,null,null,null,99.999999999999986,"ОК"]
[30,95.405799999999999,2.6223999999999998,0.83099999999999996,0.13200000000000001,0.12759999999999999,1.5E-3,2.4199999999999999E-2,1.61E-2,1.54E-2,8.6999999999999994E-3,0.62150000000000005,0.1938,0.70479999999999998,8249,34.54,9.5944444444444432,9145,38.29,{"$f":"S40/3.6","v":10.636111111111111},11956,50.06,13.905555555555555,-20.8,null,null,null,null,99.999999999999986]
[31,95.254300000000001,2.7132000000000001,0.85650000000000004,0.1341,0.1303,1.5E-3,2.4400000000000002E-2,1.6199999999999999E-2,1.4800000000000001E-2,1.2699999999999999E-2,0.63790000000000002,0.20399999999999999,0.70589999999999997,8256,34.57,9.6027777777777779,9153,38.32,10.644444444444444,11956,50.06,13.905555555555555,-21.7,null,null,null,null,99.999899999999982," "]
[null,"Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,8210,34.380000000000003,9.5500000000000007,9102,38.11,10.59]
[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,"прізвище",null,null,"підпис"]

{"sheet":"variablesList","index":1,"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":"додаток","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,4,1],[3,2,3,4],[5,0,9,0],[10,0,10,1]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу №806"]
[]
["Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null," МДж/м³","ккал/м³","кВт*год./м³"]
["Вінницька область","ГРС Мартинівка",{"$f":"'[1]розрахунок №806'!$C40","v":38.107174693082698},{"$f":"'[1]розрахунок №806'!$C41","v":9101.7424360265613},{"$f":"'[1]розрахунок №806'!$C42","v":10.585326303634082}]
[null,"ГРС Мурафа",{"$f":"'[1]розрахунок №806'!$D40","v":38.106274984360525},{"$f":"'[1]розрахунок №806'!$D41","v":9101.5275442870752},{"$f":"'[1]розрахунок №806'!$D42","v":10.585076384544591}]
[null,"ГРС Літин",{"$f":"'[1]розрахунок №806'!$E40","v":38.106827129408323},{"$f":"'[1]розрахунок №806'!$E41","v":9101.6594218679475},{"$f":"'[1]розрахунок №806'!$E42","v":10.585229758168978}]
[null,"ГРС Пасинки",{"$f":"'[1]розрахунок №806'!$F40","v":38.105497297700495},{"$f":"'[1]розрахунок №806'!$F41","v":9101.341797016843},{"$f":"'[1]розрахунок №806'!$F42","v":10.58486036047236}]
[null,"ГРС Сьомаки",{"$f":"'[1]розрахунок №806'!$G40","v":38.109051384606666},{"$f":"'[1]розрахунок №806'!$G41","v":9102.1906761026257},{"$f":"'[1]розрахунок №806'!$G42","v":10.585847606835184}]
["Середньозважене значення вищої теплоти згоряння по маршруту № 806",null,{"$f":"AVERAGEIF(C6:C10,\">0\",C6:C10)","v":38.10696509783174},{"$f":"AVERAGEIF(D6:D10,\">0\",D6:D10)","v":9101.6923750602109},10.585268082731039]
[]
[]
[]
["Начальник управління Барського ЛВУМГ                                  Мандра В,В.                                                                                      "]
["Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
["Начальник лабораторії                                                                  Ільницька Г.І.                                                                                                       "]
["Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]