{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1","Лист1"],"not_rendered":{"charts":0,"images":3,"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":"1","index":0,"n_rows":93,"n_cols":15,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,11,2,15]]}
[null,"Расчет ГРП"]
[null,"1. Рассчитываем по формуле вертикальную составляющую горного давления: "]
[null,"Рг.в.=ρп*g*Нскв.*10-6",null,null,null,null,null,null,null,null,null,"http://www.neftvnb.ru/text/biblioteka/grp_02.pdf"]
[null,"Рг.в.=2310*9,81*2850*10^-6 =64,58МПа",null,null,null,null,null,null,null,{"$f":"$O$15*$O$30*$O$5*10^-6","v":64.584135000000003},null,"Исходные данные"]
[null,null,null,null,null,null,null,null,null,null,null,"глубина пласта","Н","м",2850]
[null,"2. Рассчитываем по формуле горизонтальную составляющую горного давления: ",null,null,null,null,null,null,null,null,null,"Диаметр по долоту"]
[null,"Рг.г=Рг.в. * н / ( 1- н )",null,null,null,null,null,null,null,null,null,"радиус скважины","rс","м",7.4999999999999997E-2]
[null,"Рг.г.=64,58*(0,2729/(1-0,2729))= 24,240 МПа",null,null,null,null,null,null,null,{"$f":"$J$4*$O$13/(1-$O$13)","v":24.240146391830557},null,"радиус контура питания","Rк","м",1500]
[null,"3.Рассчитываем по формуле давление разрыва:",null,null,null,null,null,null,null,null,null,"внутренний  диаметр  (нкт)","DВ2","мкм2",7.5999999999999998E-2]
[null,"Рраз= Рг.в. – Рпл+ Рs",null,null,null,null,null,null,null,null,null,"толщна пласта","h","м",12.9]
[null,"3.1 Рраз. = 64,58 - 28,5 + 1,5=37,6 МПа",null,null,null,null,null,null,null,{"$f":"$J$4-$O$24+$O$22","v":37.584135000000003},null,"средняя проницаемость",null,"мкм2",4.7000000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,"модуль упругости пород","Е",null,"1,265*10^11"]
[null,null,null,null,null,null,null,null,null,null,null,"коэффициент пуассона","v",null,0.27289999999999998]
[null,"Рзаб/Рг*(Рзаб/Рг-1)^3=5,25*(Е^2)*Q*μ/((1-v^2)^2)*Рг^2*Vж)=0,00217",null,null,null,null,null,null,null,null,null,"Дебит до ГРП"]
[null,"3.2   Рзаб/Рг*(Рзаб/Рг-1)^3 =",null,"5,25*(1,265*10^11)^2*0,012*0,2/((1-0,2729^2)^2*(24,24*10^6)^3*7,6) =",null,null,null,null,null,{"$f":"5.25*(1.265*10^11)^2*$O$19*0.2/((1-$O$13^2)^2*($J$8*10^6)^3*$O$21)","v":2.1744800457032497E-3},null,"средняя плотность вышележащих горных пород","ρп","кг/м3 ",2310]
[null,null,null,null,null,null,null,null,{"$f":"J17/J18*(J17/J18-1)^3","v":2.8124867179989744E-3},2.1744800457032497E-3,null,"плотность жидкости песконосителя","ρж.п.","кг/м3 ",930]
[null,null,null,null,null,null,null,null,"Рзаб",27.520047513445419,null,"Вязкость жидкости песконосителя","wж","Па*с",0.2]
[null,null,null,null,null,null,null,null,"Рг",{"$f":"J8","v":24.240146391830557},null,"концентрация песка в 1 м3 жид. (кг/м3)(Сп = 250…300 кг/м3)","Сп","кг/м3",275]
[null,"4.По формуле рассчитываем объемную концентрацию песка:",null,null,null,null,null,null,null,{"$f":"22/$J$8*(22/$J$8-1)^3","v":-7.1632635143168083E-4},null,"темп закачки жидкости гидроразрыва","Q","м3/с",1.2E-2]
[null,"Вп =(Сп/ρпс)/(Сп/ρпс +1)",null,null,null,null,null,null,null,null,null,"Проницаемость породы"]
[null,"Вп =(275/2310)/275/2310+1)=0,106",null,null,null,null,null,null,null,{"$f":"$O$18/$O$15/($O$18/$O$15+1)","v":0.10638297872340424},null,"Объем песка (жидкости)","Qп","тонн",7.6]
[null,null,null,null,null,null,null,null,null,null,null,"давление расслоения пород","Рs","МПа",1.5]
[null,"5. Плотность жидкости- песконосителя рассчитывается по формуле:",null,null,null,null,null,null,null,null,null,"плотность песка","ρпс","кг/м3 ",2500]
[null,"ρж.п. = ρп `ж.п.*(1-Вп) + сп.*Вп",null,null,null,null,null,null,null,null,null,"пластовое давление","Рпл","МПа",28.5]
[null,"ρж.п. = 930*(1-0,106)+2310*0,106 = 1076,8кг/м3",null,null,null,null,null,null,null,{"$f":"$O$16*(1-$J$21)+$O$15*$J$21","v":1076.8085106382978},null,"число е","e",null,2.718]
[null,null,null,null,null,null,null,null,null,null,null,"коэффициент технического состояния агрегата ","Кт.с. ",null,0.8]
[null,"6. Вязкость жидкости разрыва с песком рассчитываем по формуле",null,null,null,null,null,null,null,null,null,"рабочее давление агрегата","Pp","МПа",29]
[null,"μж.п. = μ'ж.п. *ехр(3,18*Вп) ",null,null,null,null,null,null,null,null,null,"подача агрегата при данном Рр","Qp","м3/с",1.46E-2]
[null,"μж.п. = 0,2*ехр(3,18*0,106) = 0,280 Па*с",null,null,null,null,null,null,null,{"$f":"$O$17*$O$25^(3.18*$J$21)","v":0.28050180579676909},null,"Коэффициент разрыва",null,null,1.6]
[null,null,null,null,null,null,null,null,null,null,null,"ускорение","g","м/с2",9.81]
[null,"7. Число Рейнольдса определяется по формуле"]
[null,"Re = 4*Q*ρж.п/(π*dнкт*μж.п.) "]
[null,"Rе=(4*0,012*1076,8)/(3,14*0,076*0,281)= 772,1",null,null,null,null,null,null,null,{"$f":"4*$O$19*J25/(3.14*$O$9*$J$29)","v":772.14846943993291}]
[null,{"$f":"(4*0.012*1076.8)/(3.14*0.076*0.281)","v":770.77340993983694}]
[null,"8. Коэффициент гидравлического сопротивления определим по формуле "]
[null,"λ = 64/Re "]
[null,"λ=64/772,1=0,083",null,null,null,null,null,null,null,{"$f":"64/$J$33","v":8.288561401464864E-2}]
[]
[null,"9. Потери на трение рассчитываются по формуле"]
[null,"Ртр'=8* λ* Q2* Нскв.* ρж.п./(π2* dвн5)"]
[null,"Ртр'=8*0,083*0,012^2*2850*1076,8/(3,14^2*0,076^5)*10^-6 = 11,7 мПа",null,null,null,null,null,null,null,{"$f":"8*$J$37*$O$19^2*$O$5*$J$25/(3.14^2*$O$9^5)*10^-6","v":11.72162221271843}]
[]
[null,"10. Если число Rе больше 200, то потери давления на трение увеличиваются в 1,52 раза"]
[]
[null,"Ртр.=1,52*11,7= 17,8 мПа",null,null,null,null,null,null,null,{"$f":"$J$41*1.52","v":17.816865763332014}]
[]
[null,"11.Давление на устье скважины рассчитываются по формуле "]
[null,"Ру=Рраз-ρж.п.*g*Нскв*10-6+Ртр'"]
[null,"Ру=27,52 - (1076,8*9,81*2850)*10^-6+17,8= 15,2 мПа",null,null,null,null,null,null,null,{"$f":"$J$17-($J$25*$O$30*$O$5)*10^-6+$J$45","v":15.230962532096584}]
[]
[null,"12. Для определения необходимого числа насосных агрегатов используем формулу"]
[null,"N = (Ру*Q)/(Pp*Qp*Кт.с.) + 1 "]
[null,"N=(15,2*0,012)/(29*0,0146*0,6)+1=1,7 = 2 агрегата",null,null,null,null,null,null,null,{"$f":"$J$49*$O$19/(29*0.0146*0.6)+1","v":1.7194597322671981}]
[null,"Рр=29МПа -рабочее давление агрегата 4АН-700 на 4 скорости"]
[null,"Qр=0,0146м3/с – подача агрегата;"]
[null,"Ктс=0,5-0,8 – коэффициент технического состояния агрегата (0,6)"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J53,1)","v":1.7}]
[null,"13. Необходимый объем продавки рассчитывается по формуле"]
[null,"Vп=0,785*d2вн.* Нскв. "]
[null,"Vп.=0,785*0,076^2*2850=12,92м3",null,null,null,null,null,null,null,{"$f":"0.785*$O$9^2*$O$5","v":12.922355999999999}]
[]
[null,"14. Объем жидкости песконосителя при концентрации в ней песка рассчитывается по формуле "]
[null,"Vж.=Vп/Cп"]
[null,"Vж.=7,6*10^3/275=27,6м3",null,null,null,null,null,null,null,{"$f":"(O$21*10^3)/$O$18","v":27.636363636363637}]
[]
[null,"15. Определяем время проведения ГРП по"]
[null,"Т=(Vж. + Vп.)/Qр       "]
[null,"Т=(7,6+12,92)/(0,0146*60)=23,4мин.",null,null,null,null,null,null,null,{"$f":"((O21+$J$60)/(0.0146*60))","v":23.427347031963468}]
[]
[null,"16. Для определения длины трещины используем формулу"]
[]
[null,"L=(7,6*1,265*10^11/(5,6*(1-0,2729^2)*12,9*(27,52-24,24)*10^6))^0,5= 66,2 м",null,null,null,null,null,null,null,{"$f":"($O$21*1.265*10^11/(5.6*(1-$O$13^2)*$O$10*($J$17-$J$8)*10^6))^0.5","v":66.212288548445187}]
[]
[null,"17. Для определения ширины трещины используем формулу"]
[null,"Wo=(4*(1-н2)*L*(Рзаб.р.-Рг.г.)) / Е "]
[null,"Wo=(4*(1-0,2729^2)*66,2*(27,26-24,24)*10^6)/(1,265*10^11)= 0,006м",null,null,null,null,null,null,null,{"$f":"(4*(1-$O$13^2)*$J$72*((J17-$J$8)*10^6))/(1.265*10^11)","v":6.3556101112414139E-3}]
[]
[null,"Проницаемость трещины"]
[null,"kт=ω^2/12"]
[null,"kт=0,006^2/12=0,0000034мкм2",null,null,null,null,null,null,null,{"$f":"$J$76^2/12","v":3.3661483238428417E-6}]
[]
[null,"Эффект от ГРП"]
[null,"Q2/Q1=lg(Rk/rc)/lg(Rk/l/2)"]
[null,"Q2/Q1=LN(1500/0,075)/LN(1500/(66,2/2))",null,null,null,null,null,null,null,{"$f":"LN($O$8/0.075)/LN($O$8/($J$72/2))","v":2.5969538932402569}]
[null,"Увеличение дебита в 2,6 раза"]
[]
[null,"Вывод: основные характеристики ГРП"]
[null,"забойное давление разрыва: Рзаб = ",null,null,null,null,null,{"$f":"$J$17","v":27.520047513445419},"МПа"]
[null,"давление на устье скважины: Ру=",null,null,null,null,null,{"$f":"J49","v":15.230962532096584},"МПа"]
[null,"объём продавочной жидкости: Vп=",null,null,null,null,null,{"$f":"J60","v":12.922355999999999}," м3"]
[null,"объём жидкости для  ГРП: Vж=",null,null,null,null,null,{"$f":"J64","v":27.636363636363637}," м3"]
[null,"время работы",null,null,null,null,null,{"$f":"J68","v":23.427347031963468},"мин"]
[null,"Для  ГРП необходимо   агрегат: 4АН-70",null,null,null,null,null,{"$f":"J57","v":1.7},"шт"]

{"sheet":"Лист1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}