{"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":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,0,9,0],[8,11,9,11],[42,7,42,13],[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],[8,6,9,6],[8,4,9,4],[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],[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,"ПАСПОРТ ФІЗИКО-ХІМІЧНИХ ПОКАЗНИКІВ ПРИРОДНОГО ГАЗУ  № 642"]
["Філія УМГ \"ХАРКІВТРАНСГАЗ\"",null,null,null,null,null,"переданого Пролетарським ВУПЗГ та прийнятого  ПАТ \"ДНІПРОПЕТРОВСЬКГАЗ\""]
["Пролетарське ВУПЗГ",null,null,null,null,null,"Маршрут № 642"]
["Вимірювальна хіміко-аналітична лабораторія"]
["Свідоцтво № ПЧ-07-0/1158-2014 чинно до 22.10.2017 р.",null,null,null,null,null,null,null,null,null,"по газопроводу  -відгалудженню Пролетарська СПЗГ-ШДКРІ",null,null,null,null,null,null,null,null,null,null,"за період з",null,"01.04.2017 р.",null," по","30.04.2017 р."]
[]
["Число місяця","Компонентний склад, мол. % ",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," ккал/м³"," МДж/м³","кВт⋅год/м³"," ккал/м³"," МДж/м³","кВт⋅год/м³"," ккал/м³"," МДж/м³","кВт⋅год/м³",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":8246.2502358599995},34.525399999999998,{"$f":"P11/3.6","v":9.5903888888888886},{"$f":"S11*238.8459","v":9134.6136763199993},38.244799999999998,{"$f":"S11/3.6","v":10.623555555555555},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":8246.2502358599995},34.525399999999998,{"$f":"P12/3.6","v":9.5903888888888886},{"$f":"S12*238.8459","v":9134.6136763199993},38.244799999999998,{"$f":"S12/3.6","v":10.623555555555555},null,null,null,null,null,null,null,null,0]
[3,93.433300000000003,3.1974,0.90510000000000002,0.12870000000000001,0.15759999999999999,4.0000000000000002E-4,4.41E-2,3.1800000000000002E-2,0.1981,4.4999999999999997E-3,1.6074999999999999,0.29160000000000003,0.72170000000000001,8277.4196258100001,34.655900000000003,9.6266388888888894,9168.0521023199999,38.384799999999998,10.662444444444445,{"$f":"V13*238.8459","v":11844.153219690001},49.589100000000002,{"$f":"V13/3.6","v":13.774750000000001},null,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,8277.4196258100001,34.655900000000003,9.6266388888888894,9168.0521023199999,38.384799999999998,10.662444444444445,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,8277.4196258100001,34.655900000000003,9.6266388888888894,9168.0521023199999,38.384799999999998,10.662444444444445,null,null,null,null,null,null,null,null,0," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8277.4196258100001,34.655900000000003,9.6266388888888894,9168.0521023199999,38.384799999999998,10.662444444444445,null,null,null,null,null,null,null,null,0," "]
[7,93.534800000000004,3.2097000000000002,0.92010000000000003,0.12939999999999999,0.16350000000000001,8.0000000000000004E-4,4.2999999999999997E-2,3.2599999999999997E-2,0.1555,5.1000000000000004E-3,1.5103,0.29520000000000002,0.72030000000000005,8275.5805123800001,34.648200000000003,9.6245000000000012,9166.3801810200002,38.377800000000001,10.660500000000001,11852.823325859999,49.625399999999999,13.784833333333333,-9.6,-2,1E-4,1E-3,null,100.00000000000001,"ОК"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8275.5805123800001,34.648200000000003,9.6245000000000012,9166.3801810200002,38.377800000000001,10.660500000000001,null,null,null,null,null,null,null,null,0," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,8275.5805123800001,34.648200000000003,9.6245000000000012,9166.3801810200002,38.377800000000001,10.660500000000001,null,null,null,null,null,null,null,null,0," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,8275.5805123800001,34.648200000000003,{"$f":"P20/3.6","v":9.6245000000000012},9166.3801810200002,38.377800000000001,{"$f":"S20/3.6","v":10.660500000000001},null,null,null,null,null,null,null,null,0," "]
[11,93.662999999999997,3.2063000000000001,0.92030000000000001,0.1295,0.1636,2.7000000000000001E-3,4.2700000000000002E-2,3.27E-2,9.7500000000000003E-2,5.1999999999999998E-3,1.4365000000000001,0.3,0.71840000000000004,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,11852.70390291,49.624899999999997,13.784694444444444,-9,-1.9,null,null,"відсутні",99.999999999999986,"ОК"]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,{"$f":"P26/3.6","v":9.6104166666666657},9153.62580996,38.324399999999997,{"$f":"S26/3.6","v":10.645666666666665},null,null,null,null,null,null,null,null,0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8263.471025249999,34.597499999999997,9.6104166666666657,9153.62580996,38.324399999999997,10.645666666666665,null,null,null,null,null,null,null,null,0," "]
[19,93.320099999999996,3.2404999999999999,0.93700000000000006,0.13339999999999999,0.1709,5.0000000000000001E-4,4.6300000000000001E-2,3.5999999999999997E-2,0.22700000000000001,4.8999999999999998E-3,1.5833999999999999,0.2999,0.72360000000000002,8299.20237189,34.747100000000003,9.6519722222222235,9191.4351159300004,38.482700000000001,10.689638888888888,11858.53174287,49.649299999999997,13.791472222222222,-11.8,-2.4,2.0000000000000001E-4,2E-3,null,99.999899999999997," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8299.20237189,34.747100000000003,9.6519722222222235,9191.4351159300004,38.482700000000001,10.689638888888888,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,8299.20237189,34.747100000000003,9.6519722222222235,9191.4351159300004,38.482700000000001,10.689638888888888,null,null,null,null,null,null,null,null,0," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,8299.20237189,34.747100000000003,9.6519722222222235,9191.4351159300004,38.482700000000001,10.689638888888888,null,null,null,null,null,null,null,null,0," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,8299.20237189,34.747100000000003,{"$f":"P33/3.6","v":9.6519722222222235},9191.4351159300004,38.482700000000001,{"$f":"S33/3.6","v":10.689638888888888},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,8299.20237189,34.747100000000003,9.6519722222222235,9191.4351159300004,38.482700000000001,10.689638888888888,null,null,null,null,null,null,null,null,0," "]
[25,93.642700000000005,3.18,0.90610000000000002,0.1268,0.16159999999999999,1.6000000000000001E-3,4.2999999999999997E-2,3.2300000000000002E-2,0.11169999999999999,3.3E-3,1.4827999999999999,0.30809999999999998,0.71870000000000001,8259.1001452799992,34.5792,9.6053333333333324,9148.7772381899995,38.304099999999998,10.640027777777776,11843.96214297,49.588299999999997,13.774527777777777,null,null,null,null,"відсутні",100.00000000000001,"ОК"]
[26,93.564599999999999,3.1629999999999998,0.90200000000000002,0.12570000000000001,0.16020000000000001,2.5999999999999999E-3,4.2000000000000003E-2,3.1600000000000003E-2,0.17,7.4000000000000003E-3,1.5255000000000001,0.3054,0.72040000000000004,8271.3529399500003,34.630499999999998,9.6195833333333329,9161.7465705600007,38.358400000000003,{"$f":"S36/3.6","v":10.655111111111111},11846.684986230001,49.599699999999999,13.777694444444444,null,null,null,null,null,100,"ОК"]
[27,93.540800000000004,3.0383,0.86350000000000005,0.122,0.152,1E-3,4.4600000000000001E-2,3.3700000000000001E-2,0.12640000000000001,7.7000000000000002E-3,1.7749999999999999,0.29480000000000001,0.71889999999999998,8224.7063356800008,34.435200000000002,9.5653333333333332,9111.03958599,38.146099999999997,10.596138888888888,11793.255158399999,49.375999999999998,13.715555555555554,null,null,null,null,null,99.999800000000022," "]
[28,93.5916,3.0695999999999999,0.87270000000000003,0.1241,0.15570000000000001,4.1000000000000003E-3,4.2599999999999999E-2,3.1800000000000002E-2,0.1857,3.5000000000000001E-3,1.6185,0.3,0.72030000000000005,8259.4584141300002,34.5807,9.6057500000000005,9148.753353600001,38.304000000000002,10.64,11830.77784929,49.533099999999997,13.759194444444443,null,null,null,null,null,99.999899999999968," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8259.4584141300002,34.5807,9.6057500000000005,9148.753353600001,38.304000000000002,10.64,null,null,null,null,null,null,null,null,0," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,8259.4584141300002,34.5807,9.6057500000000005,9148.753353600001,38.304000000000002,10.64,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,0,0,null,0,null,null,null,null,null,0," "]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,8275.2457051914116,34.646798229282609,9.6241106192451742,9165.9117682732558,38.375838849539612,10.659955235983224]
[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,"03.05.2017 р."]
[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,"03.05.2017 р."]
[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,"03.05.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":true,"merged":[[3,3,5,3],[0,0,0,1],[3,0,5,0],[3,1,5,1],[1,0,1,3]]}
[]
["Додаток до Паспорту фізико-хімічних показників природного газу по маршруту № 642"]
[]
["Число місяця","Теплота згоряння вища, МДж/м3","Дніпропетровська область","Загальний обсяг газу, м3"]
[null,null,"Обсяг газу переданого за добу,  м3 "]
[null,null,"АГРС-1/3"]
[1,{"$f":"паспорт!S11","v":38.244799999999998},108.2,{"$f":"SUM(C7:C7)","v":108.2}]
[2,{"$f":"паспорт!S12","v":38.244799999999998},81.7,81.7]
[3,{"$f":"паспорт!S13","v":38.384799999999998},31.7,31.7]
[4,{"$f":"паспорт!S14","v":38.384799999999998},71.7,71.7]
[5,{"$f":"паспорт!S15","v":38.384799999999998},19.100000000000001,19.100000000000001]
[6,{"$f":"паспорт!S16","v":38.384799999999998},0,0]
[7,{"$f":"паспорт!S17","v":38.377800000000001},21.2,21.2]
[8,{"$f":"паспорт!S18","v":38.377800000000001},39.1,39.1]
[9,{"$f":"паспорт!S19","v":38.377800000000001},55.4,55.4]
[10,{"$f":"паспорт!S20","v":38.377800000000001},57,57]
[11,{"$f":"паспорт!S21","v":38.324399999999997},56.9,56.9]
[12,{"$f":"паспорт!S22","v":38.324399999999997},70.900000000000006,70.900000000000006]
[13,{"$f":"паспорт!S23","v":38.324399999999997},29.4,29.4]
[14,{"$f":"паспорт!S24","v":38.324399999999997},69.900000000000006,69.900000000000006]
[15,{"$f":"паспорт!S25","v":38.324399999999997},72.2,72.2]
[16,{"$f":"паспорт!S26","v":38.324399999999997},66.099999999999994,66.099999999999994]
[17,{"$f":"паспорт!S27","v":38.324399999999997},70.3,70.3]
[18,{"$f":"паспорт!S28","v":38.324399999999997},106.1,106.1]
[19,{"$f":"паспорт!S29","v":38.482700000000001},91.8,91.8]
[20,{"$f":"паспорт!S30","v":38.482700000000001},141.9,141.9]
[21,{"$f":"паспорт!S31","v":38.482700000000001},132.80000000000001,132.80000000000001]
[22,{"$f":"паспорт!S32","v":38.482700000000001},158.80000000000001,158.80000000000001]
[23,{"$f":"паспорт!S33","v":38.482700000000001},73.400000000000006,73.400000000000006]
[24,{"$f":"паспорт!S34","v":38.482700000000001},83.4,83.4]
[25,{"$f":"паспорт!S35","v":38.304099999999998},88.5,88.5]
[26,{"$f":"паспорт!S36","v":38.358400000000003},51,51]
[27,{"$f":"паспорт!S37","v":38.146099999999997},32.5,32.5]
[28,{"$f":"паспорт!S38","v":38.304000000000002},29.7,29.7]
[29,{"$f":"паспорт!S39","v":38.304000000000002},36.1,36.1]
[30,{"$f":"паспорт!S40","v":38.304000000000002},29.8,29.8]
[31,{"$f":"паспорт!S41","v":0},null,0]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":1976.6},{"$f":"SUM(D7:D37)","v":1976.6}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":75853.683069999999},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":75853.683069999999}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.375838849539612},38.375838849539612]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9165.911768273254},9165.911768273254]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.659955235983226},10.659955235983226]

{"sheet":"додаток","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,1,5,2],[2,3,2,5],[2,2,3,2],[2,1,3,1]]}
[null,"Додаток до Паспорту фізико-хімічних показників природного газу № 642"]
[]
[null,"Область","ГРС, прямий споживач","Cередньозважене значення вищої теплоти згоряння"]
[null,null,null," МДж/м³","ккал/м³","кВт*год./м³"]
[null,"Дніпропетровська область","АГРС-1/3 Пролетарська",{"$f":"' розрахунок'!C40","v":38.375838849539612},{"$f":"' розрахунок'!C41","v":9165.911768273254},{"$f":"' розрахунок'!C42","v":10.659955235983226}]
[null,"Середньозважене значення вищої теплоти згоряння по маршруту № 642",null,{"$f":"' розрахунок'!C40","v":38.375838849539612},{"$f":"' розрахунок'!C41","v":9165.911768273254},{"$f":"' розрахунок'!C42","v":10.659955235983226}]
[]
[]
[]
[null,"Начальник управління Пролетарського ВУПЗГ                                                                                                              ",null,null,"Андрусів В.М.",null,"03.05.2017 р"]
[null,"Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
[null,"Завідувач лабораторії                                                                                                                                                                  ",null,null,"Рекунович В.В.",null,"03.05.2017 р."]
[null,"Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
[null,"Інженер з метрології ІІ кат",null,null,"Поліщук О.С.",null,"03.05.2017 р."]
[null,"Підрозділу, відповідального за облік газу за маршрутом",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"]