{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["модель","шгн1","шгн2","эцн"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":0,"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":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"$D$39/6.7","v":373.13432835820896},100,0]
[null,null,{"$f":"$D$82/6.7","v":95.522388059701484},null,{"$f":"E1+$D$1","v":100}]
[null,null,null,null,{"$f":"E2+$D$1","v":200}]
[null,null,null,null,300]
[null,null,null,null,400]
[null,null,null,null,500]
[null,null,null,null,600]
[null,null,null,null,700]
[null,null,null,null,800]
[null,null,null,null,900]
[null,null,null,null,1000]
[null,null,null,null,1100]
[null,null,null,null,1200]
[null,null,null,null,1300]
[null,null,null,null,1400]
[null,null,null,null,1500]
[null,null,null,null,1600]
[null,null,null,null,1700]
[null,null,null,null,1800]
[null,null,null,null,1900]
[null,null,null,null,2000]
[null,null,null,null,2100]
[null,null,null,null,2200]
[null,null,null,null,2300]
[null,null,null,null,2400]
[null,null,null,null,2500]
[null,null,null,null,2600]
[null,null,null,null,2700]
[null,null,null,null,2800]
[null,null,null,null,2900]
[null,null,null,null,3000]
[]
[]
[]
[]
[]
[]
[null,"Параметры","Единицы измерения","Значение"]
[1,"Глубина скважины по вертикали (Н)","м",2500]
[2,"Пластовое давление (Pп л)","МПа;",{"$f":"ROUND(D39/100,3)","v":25}]
[3,"Забойное давление (Pзаб)","МПа;",20]
[4,"Давление насыщения (Рнас)","МПа;",5.8]
[5,"Газовый фактор (Го)","м3/т;",41.5]
[6,"Коэффициент продуктивности (Кпр)","т/ сут МПа",1]
[7,"Обводненность (nв)","%",0.28000000000000003]
[8,"Плотность воды (рв)","кг/м3",1120]
[9,"Плотность нефти ( рн)","кг/м3",828]
[10,"Плотность газа (рг)","кг/м3",1.2]
[11,"Допустимое газосодержание",null,0.15]
[12,"ускорение",null,9.8000000000000007]
[13,"Давление на устье (Pv)","МПа;",1.8]
[14,"Объемный коэффициент (в)",null,1.2]
[15,"Диаметр эксплуатационной колонны (D)","мм",146]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Определяем плотность газожидкостной смеси рcм, кг/ м3:"]
[null,"рcм=[ рн+ ргГо+ рвnв/(1-nв)] / [ в + nв/(1-nв)](4.2)",null,{"$f":"ROUND((D47+D48*D43+D46*D45/(1-D45))/((D48+D45/(1-D45))),1)","v":826.6},"(828+1,2*41,5+1120*0,28/(1-0,28))/((1,2+0,28/(1-0,28)))"]
[]
[null,"2. Определяем планируемый дебит Qж, т/сут., скважины по уравнению притока "]
[null,"Q=Кпр(Pп л- Рзаб)n(4.1)",null,{"$f":"ROUND(D44*(D40-D41)*10,1)","v":50},"1*(25-20)*10"]
[]
[null,"3.Определяем глубину расположения динамического уровня "]
[null,null,null,{"$f":"D39-D41/(D70*D50)*1000000","v":31.071465605356934},"2500-20/(826,5*9,8)*1000000"]
[]
[null,"4. Определяем оптимальное давление на приеме насоса Рпр.опт, МПа:"]
[null,null,null,{"$f":"(1-D49)*$D$42","v":4.93},"(1-0,15)*5,8"]
[]
[null,"5. Определяем глубину погружения насоса LH,м:"]
[null,null,null,{"$f":"ROUND(D76+D79/(D70*D50)*1000000,0)","v":640},"31+4,93/(826,6*9,8)*1000000"]

{"sheet":"шгн1","index":1,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"$D$39/6.7","v":417.91044776119401},100,0]
[null,null,{"$f":"$D$82/6.7","v":283.88059701492534},null,{"$f":"E1+$D$1","v":100}]
[null,null,null,null,{"$f":"E2+$D$1","v":200}]
[null,null,null,null,300]
[null,null,null,null,400]
[null,null,null,null,500]
[null,null,null,null,600]
[null,null,null,null,700]
[null,null,null,null,800]
[null,null,null,null,900]
[null,null,null,null,1000]
[null,null,null,null,1100]
[null,null,null,null,1200]
[null,null,null,null,1300]
[null,null,null,null,1400]
[null,null,null,null,1500]
[null,null,null,null,1600]
[null,null,null,null,1700]
[null,null,null,null,1800]
[null,null,null,null,1900]
[null,null,null,null,2000]
[null,null,null,null,2100]
[null,null,null,null,2200]
[null,null,null,null,2300]
[null,null,null,null,2400]
[null,null,null,null,2500]
[null,null,null,null,2600]
[null,null,null,null,2700]
[null,null,null,null,2800]
[null,null,null,null,2900]
[null,null,null,null,3000]
[]
[]
[]
[]
[]
[]
[null,"Параметры","Единицы измерения","Значение"]
[1,"Глубина скважины по вертикали (Н)","м",2800]
[2,"Пластовое давление (Pп л)","МПа;",{"$f":"ROUND(D39/100,3)","v":28}]
[3,"Забойное давление (Pзаб)","МПа;",15]
[4,"Давление насыщения (Рнас)","МПа;",8]
[5,"Газовый фактор (Го)","м3/т;",45.9]
[6,"Коэффициент продуктивности (Кпр)","т/ сут МПа",1.5]
[7,"Обводненность (nв)","%",0.48]
[8,"Плотность воды (рв)","кг/м3",1128]
[9,"Плотность нефти ( рн)","кг/м3",825]
[10,"Плотность газа (рг)","кг/м3",1.2]
[11,"допустимое газосодержание",null,0.12]
[12,"ускорение",null,9.8000000000000007]
[13,"Давление на устье (Pv)","МПа;",1.8]
[14,"Объемный коэффициент (в)",null,1.2]
[15,"Диаметр эксплуатационной колонны (D)","мм",146]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Определяем плотность газожидкостной смеси рcм, кг/ м3:"]
[null,"рcм=[ рн+ ргГо+ рвnв/(1-nв)] / [ в + nв/(1-nв)](4.2)",null,{"$f":"ROUND((D47+D48*D43+D46*D45/(1-D45))/((D48+D45/(1-D45))),1)","v":905}]
[]
[null,"2. Определяем планируемый дебит Qж, т/сут., скважины по уравнению притока "]
[null,"Q=Кпр(Pп л- Рзаб)n(4.1)",null,{"$f":"ROUND(D44*(D40-D41)*10,1)","v":195}]
[]
[null,"3.Определяем глубину расположения динамического уровня "]
[null,null,null,{"$f":"D39-D41/(D70*D50)*1000000","v":1108.7157514939677}]
[]
[null,"4. Определяем оптимальное давление на приеме насоса Рпр.опт, МПа:"]
[null,null,null,{"$f":"(1-D49)*$D$42","v":7.04}]
[]
[null,"5. Определяем глубину погружения насоса LH,м:"]
[null,null,null,{"$f":"ROUND(D76+D79/(D70*D50)*1000000,0)","v":1902}]

{"sheet":"шгн2","index":2,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"$D$39/6.7","v":268.65671641791045},100,0]
[null,null,{"$f":"$D$82/6.7","v":134.62686567164178},null,{"$f":"E1+$D$1","v":100}]
[null,null,null,null,{"$f":"E2+$D$1","v":200}]
[null,null,null,null,300]
[null,null,null,null,400]
[null,null,null,null,500]
[null,null,null,null,600]
[null,null,null,null,700]
[null,null,null,null,800]
[null,null,null,null,900]
[null,null,null,null,1000]
[null,null,null,null,1100]
[null,null,null,null,1200]
[null,null,null,null,1300]
[null,null,null,null,1400]
[null,null,null,null,1500]
[null,null,null,null,1600]
[null,null,null,null,1700]
[null,null,null,null,1800]
[null,null,null,null,1900]
[null,null,null,null,2000]
[null,null,null,null,2100]
[null,null,null,null,2200]
[null,null,null,null,2300]
[null,null,null,null,2400]
[null,null,null,null,2500]
[null,null,null,null,2600]
[null,null,null,null,2700]
[null,null,null,null,2800]
[null,null,null,null,2900]
[null,null,null,null,3000]
[]
[]
[]
[]
[]
[]
[null,"Параметры","Единицы измерения","Значение"]
[1,"Глубина скважины по вертикали (Н)","м",1800]
[2,"Пластовое давление (Pп л)","МПа;",{"$f":"ROUND(D39/100,3)","v":18}]
[3,"Забойное давление (Pзаб)","МПа;",15]
[4,"Давление насыщения (Рнас)","МПа;",8]
[5,"Газовый фактор (Го)","м3/т;",45.9]
[6,"Коэффициент продуктивности (Кпр)","т/ сут МПа",1.5]
[7,"Обводненность (nв)","%",0.48]
[8,"Плотность воды (рв)","кг/м3",1128]
[9,"Плотность нефти ( рн)","кг/м3",825]
[10,"Плотность газа (рг)","кг/м3",1.2]
[11,"допустимое газосодержание",null,0.12]
[12,"ускорение",null,9.8000000000000007]
[13,"Давление на устье (Pv)","МПа;",1.8]
[14,"Объемный коэффициент (в)",null,1.2]
[15,"Диаметр эксплуатационной колонны (D)","мм",146]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Определяем плотность газожидкостной смеси рcм, кг/ м3:"]
[null,"рcм=[ рн+ ргГо+ рвnв/(1-nв)] / [ в + nв/(1-nв)](4.2)",null,{"$f":"ROUND((D47+D48*D43+D46*D45/(1-D45))/((D48+D45/(1-D45))),1)","v":905}]
[]
[null,"2. Определяем планируемый дебит Qж, т/сут., скважины по уравнению притока "]
[null,"Q=Кпр(Pп л- Рзаб)n(4.1)",null,{"$f":"ROUND(D44*(D40-D41)*10,1)","v":45}]
[]
[null,"3.Определяем глубину расположения динамического уровня "]
[null,null,null,{"$f":"D39-D41/(D70*D50)*1000000","v":108.71575149396767}]
[]
[null,"4. Определяем оптимальное давление на приеме насоса Рпр.опт, МПа:"]
[null,null,null,{"$f":"(1-D49)*$D$42","v":7.04}]
[]
[null,"5. Определяем глубину погружения насоса LH,м:"]
[null,null,null,{"$f":"ROUND(D76+D79/(D70*D50)*1000000,0)","v":902}]

{"sheet":"эцн","index":3,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"$D$39/6.7","v":328.35820895522386},100,0]
[null,null,{"$f":"$D$82/6.7","v":194.32835820895522},null,{"$f":"E1+$D$1","v":100}]
[null,null,null,null,{"$f":"E2+$D$1","v":200}]
[null,null,null,null,300]
[null,null,null,null,400]
[null,null,null,null,500]
[null,null,null,null,600]
[null,null,null,null,700]
[null,null,null,null,800]
[null,null,null,null,900]
[null,null,null,null,1000]
[null,null,null,null,1100]
[null,null,null,null,1200]
[null,null,null,null,1300]
[null,null,null,null,1400]
[null,null,null,null,1500]
[null,null,null,null,1600]
[null,null,null,null,1700]
[null,null,null,null,1800]
[null,null,null,null,1900]
[null,null,null,null,2000]
[null,null,null,null,2100]
[null,null,null,null,2200]
[null,null,null,null,2300]
[null,null,null,null,2400]
[null,null,null,null,2500]
[null,null,null,null,2600]
[null,null,null,null,2700]
[null,null,null,null,2800]
[null,null,null,null,2900]
[null,null,null,null,3000]
[]
[]
[]
[]
[]
[]
[null,"Параметры","Единицы измерения","Значение"]
[1,"Глубина скважины по вертикали (Н)","м",2200]
[2,"Пластовое давление (Pп л)","МПа;",{"$f":"ROUND(D39/100,3)","v":22}]
[3,"Забойное давление (Pзаб)","МПа;",15]
[4,"Давление насыщения (Рнас)","МПа;",8]
[5,"Газовый фактор (Го)","м3/т;",45.9]
[6,"Коэффициент продуктивности (Кпр)","т/ сут МПа",1.5]
[7,"Обводненность (nв)","%",0.48]
[8,"Плотность воды (рв)","кг/м3",1128]
[9,"Плотность нефти ( рн)","кг/м3",825]
[10,"Плотность газа (рг)","кг/м3",1.2]
[11,"допустимое газосодержание",null,0.12]
[12,"ускорение",null,9.8000000000000007]
[13,"Давление на устье (Pv)","МПа;",1.8]
[14,"Объемный коэффициент (в)",null,1.2]
[15,"Диаметр эксплуатационной колонны (D)","мм",146]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Определяем плотность газожидкостной смеси рcм, кг/ м3:"]
[null,"рcм=[ рн+ ргГо+ рвnв/(1-nв)] / [ в + nв/(1-nв)](4.2)",null,{"$f":"ROUND((D47+D48*D43+D46*D45/(1-D45))/((D48+D45/(1-D45))),1)","v":905}]
[]
[null,"2. Определяем планируемый дебит Qж, т/сут., скважины по уравнению притока "]
[null,"Q=Кпр(Pп л- Рзаб)n(4.1)",null,{"$f":"ROUND(D44*(D40-D41)*10,1)","v":105}]
[]
[null,"3.Определяем глубину расположения динамического уровня "]
[null,null,null,{"$f":"D39-D41/(D70*D50)*1000000","v":508.71575149396767}]
[]
[null,"4. Определяем оптимальное давление на приеме насоса Рпр.опт, МПа:"]
[null,null,null,{"$f":"(1-D49)*$D$42","v":7.04}]
[]
[null,"5. Определяем глубину погружения насоса LH,м:"]
[null,null,null,{"$f":"ROUND(D76+D79/(D70*D50)*1000000,0)","v":1302}]