{"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":[[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],[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],[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]]}
["ПАТ \"УКРТРАНСГАЗ\"",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.03.2017 р.",null," по","31.03.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":8284.6566565800003},34.686199999999999,{"$f":"P11/3.6","v":9.6350555555555548},{"$f":"S11*238.8459","v":9176.4594780000007},38.42,{"$f":"S11/3.6","v":10.672222222222222},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":8284.6566565800003},34.686199999999999,{"$f":"P12/3.6","v":9.6350555555555548},{"$f":"S12*238.8459","v":9176.4594780000007},38.42,{"$f":"S12/3.6","v":10.672222222222222},null,null,null,null,null,null,null,null,0]
[3,93.511799999999994,3.2738,0.9456,0.1318,0.16750000000000001,2.8999999999999998E-3,4.2999999999999997E-2,3.3000000000000002E-2,0.1038,6.8999999999999999E-3,1.4925999999999999,0.28739999999999999,0.71950000000000003,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,{"$f":"V13*238.8459","v":11852.775556680001},49.6252,{"$f":"V13/3.6","v":13.784777777777776},null,null,5.0000000000000001E-4,2E-3,null,100.0001,{"$f":"IF(AC13=100,\"ОК\",\" \")","v":" "}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,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,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,null,null,null,null,null,null,null,null,0," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,null,null,null,null,null,null,null,null,0," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,null,null,null,null,null,null,null,null,0," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,8270.4930947100002,34.626899999999999,9.6185833333333335,9160.98226368,38.355200000000004,10.654222222222224,null,null,null,null,null,null,null,null,0," "]
[9,93.574200000000005,3.2477999999999998,0.94799999999999995,0.13200000000000001,0.1673,5.0000000000000001E-4,4.1599999999999998E-2,3.1800000000000002E-2,0.13439999999999999,6.1999999999999998E-3,1.4325000000000001,0.28360000000000002,0.7198,8282.5786972500009,34.677500000000002,9.6326388888888896,9174.14267277,38.410299999999999,10.669527777777777,11867.225733629999,49.685699999999997,13.801583333333332,null,null,null,null,null,99.999900000000025," "]
[10,93.593100000000007,3.2296,0.94230000000000003,0.13170000000000001,0.16589999999999999,4.0000000000000002E-4,4.07E-2,3.1E-2,0.1002,7.0000000000000001E-3,1.4775,0.28050000000000003,0.71879999999999999,8266.0027917900006,34.6081,{"$f":"P20/3.6","v":9.6133611111111108},9156.2531148599992,38.3354,{"$f":"S20/3.6","v":10.648722222222222},11852.775556680001,49.6252,13.784777777777776,null,null,null,null,null,99.999900000000025," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.0027917900006,34.6081,9.6133611111111108,9156.2531148599992,38.3354,10.648722222222222,null,null,null,null,null,null,null,null,0," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.0027917900006,34.6081,9.6133611111111108,9156.2531148599992,38.3354,10.648722222222222,null,null,null,null,null,null,null,null,0," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,8266.0027917900006,34.6081,9.6133611111111108,9156.2531148599992,38.3354,10.648722222222222,null,null,null,null,null,null,null,null,0," "]
[14,93.537199999999999,3.2843,0.95940000000000003,0.13539999999999999,0.1716,2.5999999999999999E-3,4.4400000000000002E-2,3.4099999999999998E-2,0.1115,5.0000000000000001E-3,1.4294,0.28520000000000001,0.7198,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,11867.488464119999,49.686799999999998,13.801888888888888,-8.6,-1.5,null,null,"відсутні",100.0001," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,null,null,null,null,null,null,null,null,0," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,{"$f":"P26/3.6","v":9.6326666666666654},9174.1665573600003,38.410400000000003,{"$f":"S26/3.6","v":10.669555555555556},null,null,null,null,null,null,null,null,0," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,null,null,null,null,null,null,null,null,0," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,null,null,null,null,null,null,null,null,0," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,null,null,null,null,null,null,null,null,0," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,8282.6025818399994,34.677599999999998,9.6326666666666654,9174.1665573600003,38.410400000000003,10.669555555555556,null,null,null,null,null,null,null,null,0,{"$f":"IF(AC30=100,\"ОК\",\" \")","v":" "}]
[21,93.553700000000006,3.2166999999999999,0.9365,0.13489999999999999,0.1691,5.0000000000000001E-4,4.48E-2,3.39E-2,0.1757,5.1999999999999998E-3,1.4411,0.28770000000000001,0.72099999999999997,8293.2312243899996,34.722099999999998,9.6450277777777771,9185.5117376100006,38.457900000000002,10.68275,11872.12207458,49.706200000000003,13.807277777777777,-8.9,-1.6,1E-4,2E-3,null,99.999800000000022," "]
[22,93.649900000000002,3.1831999999999998,0.9234,0.12790000000000001,0.16350000000000001,8.0000000000000004E-4,4.1000000000000002E-2,3.15E-2,0.13159999999999999,4.3E-3,1.4522999999999999,0.29070000000000001,0.71909999999999996,8270.9946710999993,34.628999999999998,9.6191666666666666,9161.6510321999995,38.357999999999997,10.654999999999999,11857.14643665,49.643500000000003,13.789861111111112,null,null,null,null,null,100.00009999999999," "]
[23,93.643100000000004,3.1758000000000002,0.92190000000000005,0.13109999999999999,0.16589999999999999,5.9999999999999995E-4,4.1000000000000002E-2,3.1300000000000001E-2,0.13950000000000001,4.8999999999999998E-3,1.4552,0.28960000000000002,0.71930000000000005,8273.5264376400009,34.639600000000002,{"$f":"P33/3.6","v":9.6221111111111117},9164.3738754599999,38.369399999999999,{"$f":"S33/3.6","v":10.658166666666666},11858.460089100001,49.649000000000001,13.791388888888889,null,null,null,null,null,99.999899999999997,{"$f":"IF(AC33=100,\"ОК\",\" \")","v":" "}]
[24,93.544700000000006,3.2281,0.94069999999999998,0.1346,0.17150000000000001,5.9999999999999995E-4,4.3200000000000002E-2,3.32E-2,0.14580000000000001,9.1000000000000004E-3,1.4585999999999999,0.2898,0.72040000000000004,8283.151927410001,34.679900000000004,9.6333055555555571,9174.6442491599992,38.412399999999998,10.67011111111111,11863.35643005,49.669499999999999,13.797083333333333,null,null,null,null,null,99.999900000000011," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,8283.151927410001,34.679900000000004,9.6333055555555571,9174.6442491599992,38.412399999999998,10.67011111111111,null,null,null,null,null,null,null,null,0," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,8283.151927410001,34.679900000000004,9.6333055555555571,9174.6442491599992,38.412399999999998,{"$f":"S36/3.6","v":10.67011111111111},null,null,null,null,null,null,null,null,0," "]
[27,93.699700000000007,3.1806999999999999,0.92230000000000001,0.13020000000000001,0.16539999999999999,3.8E-3,4.2500000000000003E-2,3.27E-2,0.1096,4.7000000000000002E-3,1.4181999999999999,0.2903,0.71840000000000004,8268.845057999999,34.619999999999997,9.6166666666666654,9159.4536499199985,38.348799999999997,10.652444444444443,11859.53489565,49.653500000000001,13.792638888888888,null,null,null,null,"відсутні",100.00010000000003," "]
[28,93.759100000000004,3.1638999999999999,0.91059999999999997,0.12709999999999999,0.16039999999999999,2.5000000000000001E-3,3.9899999999999998E-2,3.04E-2,0.13170000000000001,3.5000000000000001E-3,1.383,0.28810000000000002,0.71840000000000004,8273.16816879,34.638100000000001,9.6216944444444454,9164.2066833299996,38.368699999999997,10.657972222222222,11866.413657569999,49.682299999999998,13.800638888888887,-8.6999999999999993,-1.8,null,null,null,100.00019999999999," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,8273.16816879,34.638100000000001,9.6216944444444454,9164.2066833299996,38.368699999999997,10.657972222222222,null,null,null,null,null,null,null,null,0," "]
[30,93.567999999999998,3.1404999999999998,0.88519999999999999,0.12659999999999999,0.15609999999999999,2.8999999999999998E-3,4.3400000000000001E-2,3.1399999999999997E-2,0.17760000000000001,6.1000000000000004E-3,1.5742,0.28799999999999998,0.72030000000000005,8267.5552901400006,34.614600000000003,9.6151666666666671,9157.6145364899985,38.341099999999997,10.650305555555555,11842.12302954,49.580599999999997,13.772388888888887,null,null,null,null,null,100]
[31,93.587400000000002,3.1168,0.88119999999999998,0.12559999999999999,0.15690000000000001,2.5999999999999999E-3,4.5400000000000003E-2,3.3599999999999998E-2,0.1265,8.3000000000000001E-3,1.6312,0.28449999999999998,0.71889999999999998,8246.2502358599995,34.525399999999998,9.5903888888888886,9134.6136763199993,38.244799999999998,10.623555555555555,11823.397510980001,49.502200000000002,13.750611111111111,null,null,null,null,null,100.00000000000001,"ОК"]
["Рівень одоризації відповідає чинним нормативним документам",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(O11:O41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":8275.7015272642693},{"$f":"SUMPRODUCT(P11:P41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":34.648706665110304},{"$f":"SUMPRODUCT(Q11:Q41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":9.6246407403084167},{"$f":"SUMPRODUCT(R11:R41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":9166.6985093264775},{"$f":"SUMPRODUCT(S11:S41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":38.379132776934753},{"$f":"SUMPRODUCT(T11:T41,' розрахунок'!D7:D37)/' розрахунок'!D38","v":10.660870215815207}]
[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.04.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.04.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.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":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.42},419,{"$f":"SUM(C7:C7)","v":419}]
[2,{"$f":"паспорт!S12","v":38.42},324,324]
[3,{"$f":"паспорт!S13","v":38.355200000000004},329,329]
[4,{"$f":"паспорт!S14","v":38.355200000000004},339,339]
[5,{"$f":"паспорт!S15","v":38.355200000000004},332,332]
[6,{"$f":"паспорт!S16","v":38.355200000000004},332,332]
[7,{"$f":"паспорт!S17","v":38.355200000000004},309,309]
[8,{"$f":"паспорт!S18","v":38.355200000000004},326,326]
[9,{"$f":"паспорт!S19","v":38.410299999999999},282,282]
[10,{"$f":"паспорт!S20","v":38.3354},279,279]
[11,{"$f":"паспорт!S21","v":38.3354},217,217]
[12,{"$f":"паспорт!S22","v":38.3354},405,405]
[13,{"$f":"паспорт!S23","v":38.3354},364,364]
[14,{"$f":"паспорт!S24","v":38.410400000000003},391,391]
[15,{"$f":"паспорт!S25","v":38.410400000000003},267,267]
[16,{"$f":"паспорт!S26","v":38.410400000000003},386,386]
[17,{"$f":"паспорт!S27","v":38.410400000000003},208,208]
[18,{"$f":"паспорт!S28","v":38.410400000000003},281,281]
[19,{"$f":"паспорт!S29","v":38.410400000000003},245,245]
[20,{"$f":"паспорт!S30","v":38.410400000000003},396,396]
[21,{"$f":"паспорт!S31","v":38.457900000000002},257,257]
[22,{"$f":"паспорт!S32","v":38.357999999999997},164,164]
[23,{"$f":"паспорт!S33","v":38.369399999999999},198,198]
[24,{"$f":"паспорт!S34","v":38.412399999999998},142,142]
[25,{"$f":"паспорт!S35","v":38.412399999999998},134,134]
[26,{"$f":"паспорт!S36","v":38.412399999999998},200,200]
[27,{"$f":"паспорт!S37","v":38.348799999999997},382,382]
[28,{"$f":"паспорт!S38","v":38.368699999999997},281,281]
[29,{"$f":"паспорт!S39","v":38.368699999999997},158,158]
[30,{"$f":"паспорт!S40","v":38.341099999999997},107,107]
[31,{"$f":"паспорт!S41","v":38.244799999999998},113,113]
["Загальний обсяг газу, м3",null,{"$f":"SUM(C7:C37)","v":8567},{"$f":"SUM(D7:D37)","v":8567}]
["Енергія, МДж",null,{"$f":"SUMPRODUCT(B7:B37,C7:C37)","v":328794.03050000005},{"$f":"SUMPRODUCT(B7:B37,D7:D37)","v":328794.03050000005}]
["Теплота згоряння (середньозважене значення за місяць), МДж/м³",null,{"$f":"C39/C38","v":38.379132776934753},38.379132776934753]
["Теплота згоряння (середньозважене значення за місяць), ккал/м³",null,{"$f":"C40*238.8459","v":9166.6985093264811},9166.6985093264811]
["Теплота згоряння (середньозважене значення за місяць), кВт*год./м³",null,{"$f":"C40/3.6","v":10.660870215815208},10.660870215815208]

{"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.379132776934753},{"$f":"' розрахунок'!C41","v":9166.6985093264811},{"$f":"' розрахунок'!C42","v":10.660870215815208}]
[null,"Середньозважене значення вищої теплоти згоряння по маршруту № 642",null,{"$f":"' розрахунок'!C40","v":38.379132776934753},{"$f":"' розрахунок'!C41","v":9166.6985093264811},{"$f":"' розрахунок'!C42","v":10.660870215815208}]
[]
[]
[]
[null,"Начальник управління Пролетарського ВУПЗГ                                                                                                              ",null,null,"Андрусів В.М.",null,"03.04.2017 р"]
[null,"Підрозділу підприємства, якому підпорядкована лабораторія",null,null,"прізвище","підпис","дата"]
[null,"Завідувач лабораторії                                                                                                                                                                  ",null,null,"Рекунович В.В.",null,"03.04.2017 р."]
[null,"Лабораторія, де здійснювалось вимірювання газу",null,null,"прізвище","підпис","дата"]
[null,"Інженер з метрології ІІ кат",null,null,"Поліщук О.С.",null,"03.04.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"]