Description
What mud weight does each hole section need, will the pumps clean the hole without breaking the shoe down, and how fast can the string be tripped? You enter a shale sonic log and its normal trend, the casing seats and leak-off tests, the hole and string geometry, the Fann readings, flow, nozzles, ROP and stand times. You read off pore and fracture pressure and the mud program by depth, and for the selected section the pump pressure, shoe ECD, cuttings transport and the surge and swab trip-speed limits. Field units; no add-in needed.
How to use it: The log and geometry are synthetic. Replace the log, the seats and the leak-off tests on the Pore Pressure sheet, and the geometry and mud on the Sections sheet, with the planned case. Pick Intermediate or Production on the Sections sheet (default Production); the Hydraulics, Hole Cleaning, Surge Swab and Summary sheets show only that section. Set the section's flow and Fann readings on Sections, the nozzles and pump ratings on Hydraulics, the ROP and cleaning limits on Hole Cleaning and the stand times on Surge Swab. Review every verdict on the Summary, which combines all named checks in a fail-closed verdict. For resistivity Eaton, use the pore-pressure blueprint po.bp.de.pore.pressure.eaton.
Method: The sonic log gives the normal and measured transit times; the pore pressure follows Eaton's compaction method against the normal trend, and the fracture pressure the Eaton and Matthews-Kelly relations on the same log. Mud weights follow the maximum pore gradient over the open interval plus the trip margin, and the leak-off tests calibrate the model against a misfit tolerance. Hydraulics fits a power law to the 600/300-rpm readings and sums pipe, collar, nozzle and annular losses; the shoe ECD uses the losses above the previous shoe. Hole cleaning uses the flow, mud and rheology, with its static cuttings-density estimate kept separate from the ECD. Surge and swab use the same rheology and geometry with Burkhardt displacement over a five-point sweep from 20 to 180 ft/min: shoe surge is checked against the previous shoe's fracture pressure, and the minimum swab mud weight at the shoe, the bit and the drill-pipe/collar boundary against the maximum open-interval pore gradient. Segment geometry is constant and friction varies linearly with depth, so those boundaries hold the equivalent-mud-weight extrema. The sweep interpolates the speed limit, returns zero if no sample is safe and caps the limit at the highest sample if all are safe. Surface has pore and mud results only: the reference well has no surface-hole diameter or string, so surface hydraulics are not modelled.
Example: The 12.25-in intermediate hole spans 4,000–10,000 ft below 12.347-in ID surface casing; the 8.5-in production hole spans 10,000–13,000 ft below 9.625-in casing, 8.681-in ID to 8,000 ft and 8.535-in ID to the shoe. Each assumes 5-in drill pipe, 600 ft of collars and the bit at section TD; these are not measured operational data. The program gives 9.3 ppg surface mud, 10.5 ppg intermediate mud and 13.9 ppg production mud, with the pore limit at the maximum Eaton gradient over each open interval.
Validity
The log and geometry are synthetic, not independent field validation. Surface-hole hydraulics are not modelled; the reference well gives no surface hole or string. Eaton's compaction method can under-read unloading; Gardner is unreliable in gas sands, salt and anhydrite. Replace and calibrate the log and fracture model to local data. The well is vertical; ECD excludes cuttings loading, gels, acceleration, temperature and transients. The steady-state tripping model is not a transient surge simulation. Cuttings transport and the density-limited ROP are screening estimates, not a coupled multiphase model. Validate a real program with the operator's approved methods.
Named alternatives, which the workbook does not compute and the add-in has no functions for: Herschel-Bulkley pipe and annulus losses, pump optimisation (nozzles and flow rate for maximum bit hydraulic horsepower or impact force), cuttings bed height in deviated hole, a dynamic surge model, Bowers's unloading pore pressure and the HPHT equivalent static density of the mud column.
References
- Eaton, B.A. (1975). “The Equation for Geopressure Prediction from Well Logs.” SPE-5544.
- Eaton, B.A. (1969). “Fracture Gradient Prediction and Its Application in Oilfield Operations.” Journal of Petroleum Technology.
- Matthews, W.R. and Kelly, J. (1967). “How to Predict Formation Pressure and Fracture Gradient.” Oil and Gas Journal.
- Bourgoyne, A.T. et al. (1986). Applied Drilling Engineering. SPE Textbook Series Vol. 2, chapters 6 and 7.
Inputs
| Input | Unit | Default | Name |
|---|---|---|---|
| Surface sonic trend, sonic trend decay | µs/ft, 1/ft | 170, 0.00006 | DPW_Dt0, DPW_DtC |
| Surface shoe TVD, intermediate shoe TVD, production TD TVD | ft | 4000, 10000, 13000 | DPW_Shoe1, DPW_Shoe2, DPW_TD |
| Trip margin, kick margin | ppg | 0.3, 0.5 | DPW_Trip, DPW_Kick |
| Poisson ratio, first and second test equivalent weight | —, ppg, ppg | 0.4, 14.5, 15.3 | DPW_Nu, DPW_Lot1, DPW_Lot2 |
| Open-hole diameter, intermediate and production | in | 12.25, 8.5 | DSI_Hole, DSP_Hole |
| Section to evaluate: Intermediate or Production | — | Production | DP_Section |
| Flow rate, intermediate and production | gpm | 500 each | DSI_Q, DSP_Q |
| Fann 600 rpm and Fann 300 rpm, per section (fit n and K) | lb/100 ft² | 58, 36 each section | DSI_R600, DSI_R300, DSP_R600, DSP_R300 |
| Planned ROP | ft/h | 90 | DC_ROP |
| Run time per stand, pull time per stand | s | 45, 75 | DT_TimeIn, DT_TimeOut |
DH_Q, DH_R600, and DH_R300 are calculated projections of the selected section, not editable inputs.
Sheets
Guide— what the workbook answers and the order to work through its sheets.Pore Pressure— the sonic log, Eaton's pore pressure, Gardner's overburden, Eaton's and Matthews-Kelly's fracture pressure calibrated to two leak-off tests, and the mud program, charted against depth.Sections— the section picker, and for the intermediate and production holes the previous casing, the open hole, the string, the section mud weight, the pressure limits and each section's flow and Fann readings.Hydraulics— for the selected section, the power-law fit, pipe, collar, nozzle and annular losses, pump pressure and power against the pump ratings, and the shoe ECD.Hole Cleaning— for the selected section, annular velocity, cuttings transport ratio and concentration, solids content, and the highest ROP the density limit allows.Surge Swab— for the selected section, Burkhardt surge and swab over a sweep of trip speeds, the shoe surge against fracture and the swab against pore pressure, and the trip-speed limits.Summary— the selected section's answers and every check under one fail-closed verdict.Test Cases— the worked example and other cases, with expected and computed results.
One chart: pore, fracture and mud weight against depth.
Functions used
None: the workbook calculates with Excel's own functions.
Names (250)
| Name | Refers to | Comment |
|---|---|---|
PO.DE.AnnularVelocityLAMBDA |
=LAMBDA(Q_gpm, Dh_in, Dp_in, 24.5 * Q_gpm / (Dh_in^2 - Dp_in^2)) |
Average annular velocity, ft/min, from flow rate and the hole and pipe diameters. |
PO.DE.Bit.HydraulicHPLAMBDA |
=LAMBDA(dP_bit_psi, Q_gpm, dP_bit_psi * Q_gpm / 1714) |
Hydraulic horsepower expended at the bit, hp, from the bit pressure drop and flow rate. |
PO.DE.Bit.NozzleAreaLAMBDA |
=LAMBDA(Size_32nds, PI() / 4 * (Size_32nds / 32)^2) |
Flow area, in2, of one bit nozzle given its size in 32nds of an inch (0 for an empty slot). |
PO.DE.Bit.NozzlePressureLossLAMBDA |
=LAMBDA(MW_ppg, Q_gpm, A_nozzle_in2, MW_ppg * Q_gpm^2 / (10858 * A_nozzle_in2^2)) |
Pressure loss across the bit nozzles, psi, from mud weight, flow rate and total nozzle flow area. Nozzle discharge coefficient of 0.95 is embedded in the constant. |
PO.DE.Cuttings.ConcentrationLAMBDA |
=LAMBDA(ROP_fthr, V_cuttings_bblft, Q_gpm, LET(cuttings_bblmin, ROP_fthr * V_cuttings_bblft / 60, 100 * cuttings_bblmin / (Q_gpm / 42 + cuttings_bblmin))) |
Volume percent of drilled cuttings in the returns, from ROP, cuttings volume per foot and flow rate (no slip between cuttings and mud). |
PO.DE.Cuttings.VolumeLAMBDA |
=LAMBDA(Dh_in, Porosity, LET(gross_bblft, Dh_in^2 / 1029.4, gross_bblft * (1 - Porosity))) |
Solid cuttings volume generated per foot of hole drilled, bbl/ft, from hole diameter and formation porosity. |
PO.DE.ECDLAMBDA |
=LAMBDA(MW_ppg, P_ann_psi, TVD_ft, MW_ppg + P_ann_psi / (0.052 * TVD_ft)) |
Equivalent circulating density, ppg: static mud weight plus annular pressure loss converted to an equivalent density over the true vertical depth. |
PO.DE.FG.EatonLAMBDA |
=LAMBDA(Sv, Pp, Nu, Nu/(1-Nu)*(Sv-Pp)+Pp) |
Eaton fracture gradient from Poisson's ratio: FG = nu/(1 - nu) (Sv - Pp) + Pp, in the unit of Sv and Pp. |
PO.DE.FG.MatthewsKellyLAMBDA |
=LAMBDA(Sv, Pp, Ki, Ki*(Sv-Pp)+Pp) |
Matthews-Kelly fracture gradient from the matrix-stress coefficient: FG = Ki (Sv - Pp) + Pp, in the unit of Sv and Pp. |
PO.DE.HC.SlipVelocityLAMBDA |
=LAMBDA(Dc_in, RhoC_ppg, MW_ppg, n, K_eqcp, Dh_in, Dp_in, Va_ftmin, LET(vMud, Va_ftmin / 60, muApp, K_eqcp / 144 * ((Dh_in - Dp_in) / vMud) ^ (1 - n) * ((2 + 1 / n) / 0.0208) ^ n, dRho, RhoC_ppg - MW_ppg, vsMid, 2.9 * Dc_in * dRho ^ 0.667 / (MW_ppg ^ 0.333 * muApp ^ 0.333), reMid, 928 * MW_ppg * vsMid * Dc_in / muApp, vsTurb, 1.54 * SQRT(Dc_in * dRho / MW_ppg), vsLam, 82.87 * Dc_in ^ 2 * dRho / muApp, 60 * IF(reMid > 300, vsTurb, IF(reMid < 3, vsLam, vsMid)))) |
Cuttings slip velocity, ft/min, by Moore's correlation in a power-law mud: apparent viscosity in the annulus, then the laminar, intermediate or turbulent drag regime by particle Reynolds number. |
PO.DE.HC.TransportRatioLAMBDA |
=LAMBDA(Vslip_ftmin, Va_ftmin, 1 - Vslip_ftmin / Va_ftmin) |
Cuttings transport ratio, the net rise velocity of the cuttings over the annular velocity: 1 - slip velocity / annular velocity (1 carries everything, 0 or less the cuttings settle). |
PO.DE.Hyd.AnnulusLossLAMBDA |
=LAMBDA(Q_gpm, Dh_in, Dp_in, L_ft, MW_ppg, n, K_cp, LET(v, Q_gpm / (2.448 * (Dh_in^2 - Dp_in^2)), gap, Dh_in - Dp_in, re, 109000 * MW_ppg * v^(2 - n) / K_cp * (0.0208 * (Dh_in - Dp_in) / (2 + 1 / n))^n, L_ft * IF(re < 3470 - 1370 * n, K_cp * v^n * ((2 + 1 / n) / 0.0208)^n / (144000 * gap^(1 + n)), 0.0791 / re^0.25 * MW_ppg * v^2 / (21.1 * gap)))) |
Frictional pressure loss, psi, in an annulus for a power-law mud: laminar below the API RP 13D limit 3470 - 1370n, Blasius turbulent above (Bourgoyne et al.). |
PO.DE.Hyd.AnnulusReynoldsLAMBDA |
=LAMBDA(Q_gpm, Dh_in, Dp_in, MW_ppg, n, K_cp, LET(v, Q_gpm / (2.448 * (Dh_in^2 - Dp_in^2)), 109000 * MW_ppg * v^(2 - n) / K_cp * (0.0208 * (Dh_in - Dp_in) / (2 + 1 / n))^n)) |
Power-law Reynolds number in an annulus, slot approximation (Bourgoyne et al.), from flow rate, hole and pipe diameters, mud weight, n and K (eq cp). |
PO.DE.Hyd.PipeLossLAMBDA |
=LAMBDA(Q_gpm, ID_in, L_ft, MW_ppg, n, K_cp, LET(v, Q_gpm / (2.448 * ID_in^2), re, 89100 * MW_ppg * v^(2 - n) / K_cp * (0.0416 * ID_in / (3 + 1 / n))^n, L_ft * IF(re < 3470 - 1370 * n, K_cp * v^n * ((3 + 1 / n) / 0.0416)^n / (144000 * ID_in^(1 + n)), 0.0791 / re^0.25 * MW_ppg * v^2 / (25.8 * ID_in)))) |
Frictional pressure loss, psi, inside a pipe for a power-law mud: laminar below the API RP 13D limit 3470 - 1370n, Blasius turbulent above (Bourgoyne et al.). |
PO.DE.PP.EatonLAMBDA |
=LAMBDA(Sv, Pn, Observed, Normal, Mode, LET(ratio, IF(Mode=1, Normal/Observed, Observed/Normal), expo, IF(Mode=1, 3, 1.2), IF(OR(Mode=1, Mode=2), Sv-(Sv-Pn)*ratio^expo, NA()))) |
Eaton pore pressure from the ratio of a log to its normal-compaction trend. Mode 1 sonic (exponent 3), Mode 2 resistivity (exponent 1.2). Same unit as Sv and Pn. |
PO.DE.Rheo.PowerLawIndexLAMBDA |
=LAMBDA(Theta600, Theta300, 3.32 * LOG10(Theta600 / Theta300)) |
Power-law flow behavior index n from the 600 and 300 rpm viscometer dial readings. |
PO.DE.Rheo.PowerLawKLAMBDA |
=LAMBDA(Theta300, FlowIdx, 510 * Theta300 / 511^FlowIdx) |
Power-law consistency index, eq cp, from the 300 rpm dial reading and the flow behavior index (Bourgoyne et al.). |
PO.DE.Solids.FractionLAMBDA |
=LAMBDA(MW_ppg, MW_base_ppg, Rho_solids_ppg, 100 * (MW_ppg - MW_base_ppg) / (Rho_solids_ppg - MW_base_ppg)) |
Volume percent solids in a two-component mud, from the mud weight, the base fluid weight and the solids density. |
PO.DE.Surge.BurkhardtLAMBDA |
=LAMBDA(Vp_ftmin, Dh_in, Dp_in, Di_in, Kc, Mode, Vp_ftmin*(IF(Mode=1, Dp_in^2 - Di_in^2, Dp_in^2)/(Dh_in^2 - Dp_in^2) + Kc)) |
Burkhardt effective annular velocity, ft/min, of the mud a moving pipe displaces, with the clinging constant; closed-end (Mode 0) or open-end (Mode 1) pipe. |
PO.GM.Density.GardnerLAMBDA |
=LAMBDA(Vp, A, B, A*Vp^B) |
Bulk density from P-wave velocity by Gardner's power law, rho = A Vp^B (g/cc; A 0.23 and B 0.25 with Vp in ft/s). |
PO.GM.Stress.OverburdenLAMBDA |
=LAMBDA(Z_ft, TVD_ft, Rho_gcc, Sv0_psi, LET(n, ROWS(TVD_ft), i, SEQUENCE(n), shift, --(i=TRANSPOSE(i)+1), d_prev, MMULT(shift, TVD_ft), r_prev, MMULT(shift, Rho_gcc), d_end, IF(TVD_ft<Z_ft, TVD_ft, Z_ft), width, IF(i>1, IF(d_end>d_prev, d_end-d_prev, 0), 0), r_end, r_prev+(Rho_gcc-r_prev)*IF(TVD_ft>d_prev, (d_end-d_prev)/(TVD_ft-d_prev), 0), d_last, INDEX(TVD_ft, n), tail, IF(Z_ft>d_last, (Z_ft-d_last)*INDEX(Rho_gcc, n), 0), sv, Sv0_psi+0.433528*(SUM(width*(r_prev+r_end)/2)+tail), IF(Z_ft<INDEX(TVD_ft, 1), NA(), HSTACK(sv, sv/Z_ft, sv/Z_ft/0.052)))) |
Overburden stress at a depth by integrating a bulk-density log (trapezoids) below the stress at its first depth: {Sv psi, psi/ft, ppg}. |
_PO.DE.ControlDrilling.MaxRateLAMBDA |
=LAMBDA(MW_in_ppg, MW_max_ppg, Q_gpm, Dh_in, 67 * (MW_max_ppg - MW_in_ppg) * Q_gpm / Dh_in^2) |
Maximum drilling rate, ft/hr, that keeps the mud weight increase across the annulus within the allowed limit. |
_PO.DE.Solids.DensityLAMBDA |
=LAMBDA(SG, 8.34 * SG) |
Density of solids, ppg, from their specific gravity: fresh water is 8.34 ppg. |
DC_AVdp |
'Hole Cleaning'!$B$18 |
Velocity past drill pipe, ft/min |
DC_AVmin |
'Hole Cleaning'!$B$9 |
Min annular velocity, ft/min |
DC_Conc |
'Hole Cleaning'!$B$17 |
Concentration, no slip, % vol |
DC_ConcAnn |
'Hole Cleaning'!$B$24 |
Concentration with slip, % vol |
DC_ConcMax |
'Hole Cleaning'!$B$11 |
Max cuttings concentration, % vol |
DC_ConcentrationCheck |
'Hole Cleaning'!$B$31 |
Annular concentration verdict |
DC_ConcentrationCheckNote |
'Hole Cleaning'!$C$31 |
Annular concentration comment |
DC_Dc |
'Hole Cleaning'!$B$7 |
Cutting diameter, in |
DC_FT |
'Hole Cleaning'!$B$23 |
Transport ratio |
DC_FTmin |
'Hole Cleaning'!$B$10 |
Min transport ratio |
DC_Inputs |
'Hole Cleaning'!$B$5:$B$14 |
ROP, cuttings and cleaning limits |
DC_MWbase |
'Hole Cleaning'!$B$12 |
Base fluid density, ppg |
DC_MWmax |
'Hole Cleaning'!$B$15 |
Density limit at shoe, ppg |
DC_Por |
'Hole Cleaning'!$B$6 |
Formation porosity, % |
DC_ROP |
'Hole Cleaning'!$B$5 |
Planned ROP, ft/hr |
DC_ROPmax |
'Hole Cleaning'!$B$20 |
Max ROP for density limit, ft/hr |
DC_Results |
'Hole Cleaning'!$B$15:$B$32 |
Cuttings load, transport, solids and ... |
DC_RopCheck |
'Hole Cleaning'!$B$28 |
Control drilling verdict |
DC_RopCheckNote |
'Hole Cleaning'!$C$28 |
Control drilling comment |
DC_SGc |
'Hole Cleaning'!$B$8 |
Cutting specific gravity, water = 1 |
DC_SGs |
'Hole Cleaning'!$B$13 |
avg. solids specific gravity, water = 1 |
DC_Solids |
'Hole Cleaning'!$B$26 |
Mud solids content, % vol |
DC_SolidsCheck |
'Hole Cleaning'!$B$32 |
Solids content verdict |
DC_SolidsCheckNote |
'Hole Cleaning'!$C$32 |
Solids content comment |
DC_SolidsMax |
'Hole Cleaning'!$B$14 |
Max solids content, % vol |
DC_TransportCheck |
'Hole Cleaning'!$B$30 |
Cuttings transport verdict |
DC_TransportCheckNote |
'Hole Cleaning'!$C$30 |
Cuttings transport comment |
DC_VelocityCheck |
'Hole Cleaning'!$B$29 |
Annular velocity verdict |
DC_VelocityCheckNote |
'Hole Cleaning'!$C$29 |
Annular velocity comment |
DC_Vslip |
'Hole Cleaning'!$B$22 |
Moore slip velocity, ft/min |
DH_AnnShoe |
Hydraulics!$B$35 |
Loss above previous shoe, psi |
DH_AnnTotal |
Hydraulics!$B$36 |
Loss bit to surface, psi |
DH_EcdShoe |
Hydraulics!$B$38 |
ECD at shoe, ppg |
DH_Gel |
Hydraulics!$B$13 |
Gel, 10 min, lb/100ft² |
DH_HHPUse |
Hydraulics!$B$41 |
HHP utilisation |
DH_HHPmax |
Hydraulics!$B$21 |
Pump power rating, hp |
DH_Inputs |
Hydraulics!$B$5:$B$22 |
Flow, Fann readings, nozzles and pump... |
DH_K |
Hydraulics!$B$24 |
Consistency index, eq cp |
DH_MW |
Hydraulics!$F$23 |
Mud weight, ppg |
DH_Margin |
Hydraulics!$B$22 |
Warning margin |
DH_Noz1 |
Hydraulics!$B$14 |
Nozzle 1 (0 empty), 1/32 in |
DH_Noz2 |
Hydraulics!$B$15 |
Nozzle 2 (0 empty), 1/32 in |
DH_Noz3 |
Hydraulics!$B$16 |
Nozzle 3 (0 empty), 1/32 in |
DH_Noz4 |
Hydraulics!$B$17 |
Nozzle 4 (0 empty), 1/32 in |
DH_Noz5 |
Hydraulics!$B$18 |
Nozzle 5 (0 empty), 1/32 in |
DH_Noz6 |
Hydraulics!$B$19 |
Nozzle 6 (0 empty), 1/32 in |
DH_PowerCheck |
Hydraulics!$B$45 |
Pump power verdict |
DH_PowerCheckNote |
Hydraulics!$C$45 |
Pump power comment |
DH_PumpCheck |
Hydraulics!$B$44 |
Pump pressure verdict |
DH_PumpCheckNote |
Hydraulics!$C$44 |
Pump pressure comment |
DH_PumpHHP |
Hydraulics!$B$39 |
Pump power, hp |
DH_Q |
Hydraulics!$B$5 |
Selected flow rate, gpm |
DH_R100 |
Hydraulics!$B$10 |
Fann 100 rpm, lb/100ft² |
DH_R200 |
Hydraulics!$B$9 |
Fann 200 rpm, lb/100ft² |
DH_R3 |
Hydraulics!$B$12 |
Fann 3 rpm, lb/100ft² |
DH_R300 |
Hydraulics!$B$8 |
Selected Fann 300 rpm, lb/100ft² |
DH_R6 |
Hydraulics!$B$11 |
Fann 6 rpm, lb/100ft² |
DH_R600 |
Hydraulics!$B$7 |
Selected Fann 600 rpm, lb/100ft² |
DH_Results |
Hydraulics!$B$23:$B$45 |
Rheology, losses, ECD and pump checks |
DH_SPP |
Hydraulics!$B$37 |
Standpipe pressure, psi |
DH_SPPUse |
Hydraulics!$B$40 |
SPP utilisation |
DH_SPPmax |
Hydraulics!$B$20 |
Pump pressure rating, psi |
DH_Surf |
Hydraulics!$B$6 |
Surface loss, psi |
DH_TFA |
Hydraulics!$B$25 |
Nozzle flow area, in² |
DH_WindowCheck |
Hydraulics!$B$43 |
Shoe fracture and pore verdict |
DH_WindowCheckNote |
Hydraulics!$C$43 |
Shoe fracture and pore comment |
DH_dPbit |
Hydraulics!$B$26 |
Bit pressure drop, psi |
DH_n |
Hydraulics!$B$23 |
Power-law index |
DPM_Checks |
Summary!$B$11:$B$26 |
Every sheet verdict; invalid and erro... |
DPM_IntermediateMW |
Summary!$B$5 |
Intermediate mud, ppg |
DPM_Overall |
Summary!$B$27 |
Overall verdict |
DPM_OverallNote |
Summary!$C$27 |
Overall comment |
DPM_ProductionMW |
Summary!$B$6 |
Production mud, ppg |
DPM_Section |
Summary!$B$7 |
Selected section |
DPM_ShoeEcd |
Summary!$B$8 |
Selected ECD at shoe, ppg |
DPM_SurfaceMW |
Summary!$B$4 |
Surface mud, ppg |
DPM_Verdict |
Summary!$B$27 |
Overall verdict over every named check |
DPM_VerdictNote |
Summary!$C$27 |
Overall verdict over every named chec... |
DPW_CalCheck |
'Pore Pressure'!$B$55 |
Calibration verdict |
DPW_CalCheckNote |
'Pore Pressure'!$C$55 |
Calibration comment |
DPW_Curve |
'Pore Pressure'!$A$63:$K$87 |
Synthetic log and calculated pressures |
DPW_Dt0 |
'Pore Pressure'!$B$6 |
Surface sonic trend, µs/ft |
DPW_DtC |
'Pore Pressure'!$B$7 |
Sonic trend decay, 1/ft |
DPW_Fg |
'Pore Pressure'!$H$63:$H$87 |
Eaton fracture pressure, ppg |
DPW_Fg1 |
'Pore Pressure'!$B$51 |
Fracture at test 1, ppg |
DPW_Fg2 |
'Pore Pressure'!$B$53 |
Fracture at test 2, ppg |
DPW_FgShoe |
'Pore Pressure'!$B$40 |
Eaton fracture at shoe, ppg |
DPW_FgShoe1 |
'Pore Pressure'!$B$39 |
Eaton fracture at surface shoe, ppg |
DPW_GA |
'Pore Pressure'!$B$9 |
Gardner coefficient |
DPW_GB |
'Pore Pressure'!$B$10 |
Gardner exponent |
DPW_Inputs |
'Pore Pressure'!$B$5:$B$18 |
Sonic trend, seats and margins |
DPW_Ki0 |
'Pore Pressure'!$B$12 |
Matthews-Kelly initial Ki |
DPW_KiSlope |
'Pore Pressure'!$B$13 |
Matthews-Kelly Ki slope, 1/ft |
DPW_Kick |
'Pore Pressure'!$B$18 |
Kick margin, ppg |
DPW_Lot1 |
'Pore Pressure'!$B$20 |
First test equivalent weight, ppg |
DPW_Lot1Z |
'Pore Pressure'!$B$19 |
First test depth, ft |
DPW_Lot2 |
'Pore Pressure'!$B$22 |
Second test equivalent weight, ppg |
DPW_Lot2Z |
'Pore Pressure'!$B$21 |
Second test depth, ft |
DPW_LotTol |
'Pore Pressure'!$B$23 |
Accepted test misfit, ppg |
DPW_Lot_Inputs |
'Pore Pressure'!$B$19:$B$23 |
Leak-off tests and tolerance |
DPW_Lot_Results |
'Pore Pressure'!$B$51:$B$55 |
Test predictions, misfits and calibra... |
DPW_MW1 |
'Pore Pressure'!$B$42 |
Surface mud, ppg |
DPW_MW2 |
'Pore Pressure'!$B$43 |
Intermediate mud, ppg |
DPW_MW3 |
'Pore Pressure'!$B$44 |
Production mud, ppg |
DPW_Miss1 |
'Pore Pressure'!$B$52 |
Misfit at test 1, ppg |
DPW_Miss2 |
'Pore Pressure'!$B$54 |
Misfit at test 2, ppg |
DPW_Nu |
'Pore Pressure'!$B$11 |
Poisson ratio |
DPW_Pn |
'Pore Pressure'!$B$5 |
Normal pressure gradient, psi/ft |
DPW_PnEmw |
'Pore Pressure'!$B$33 |
Normal pore pressure, ppg |
DPW_PoreMaxIntermediate |
'Pore Pressure'!$B$35 |
Intermediate maximum pore, ppg |
DPW_PoreMaxProduction |
'Pore Pressure'!$B$36 |
Production maximum pore, ppg |
DPW_Pp |
'Pore Pressure'!$G$63:$G$87 |
Eaton pore pressure, ppg |
DPW_PpShoe |
'Pore Pressure'!$B$37 |
Pore pressure at shoe, ppg |
DPW_PpShoe1 |
'Pore Pressure'!$B$41 |
Pore pressure at surface shoe, ppg |
DPW_PpTD |
'Pore Pressure'!$B$38 |
Pore pressure at TD, ppg |
DPW_Results |
'Pore Pressure'!$B$33:$B$48 |
Pressure, mud weights and seat checks |
DPW_RhoTop |
'Pore Pressure'!$B$8 |
Bulk density above first point, g/cm³ |
DPW_Seat1Check |
'Pore Pressure'!$B$46 |
Surface seat verdict |
DPW_Seat1CheckNote |
'Pore Pressure'!$C$46 |
Surface seat comment |
DPW_Seat2Check |
'Pore Pressure'!$B$47 |
Intermediate seat verdict |
DPW_Seat2CheckNote |
'Pore Pressure'!$C$47 |
Intermediate seat comment |
DPW_Shoe1 |
'Pore Pressure'!$B$14 |
Surface shoe TVD, ft |
DPW_Shoe2 |
'Pore Pressure'!$B$15 |
Intermediate shoe TVD, ft |
DPW_Sv0 |
'Pore Pressure'!$B$34 |
Overburden at first point, psi |
DPW_TD |
'Pore Pressure'!$B$16 |
Production TD TVD, ft |
DPW_Trip |
'Pore Pressure'!$B$17 |
Trip margin, ppg |
DPW_Window |
'Pore Pressure'!$B$45 |
Narrowest window, ppg |
DPW_WindowCheck |
'Pore Pressure'!$B$48 |
Window verdict |
DPW_WindowCheckNote |
'Pore Pressure'!$C$48 |
Window comment |
DPW_Z |
'Pore Pressure'!$A$63:$A$87 |
Log depth, ft TVD |
DP_Col |
Sections!$G$28 |
Column of the selected section |
DP_Section |
Sections!$G$3 |
Section to evaluate |
DSI_BhaID |
Sections!$B$14 |
Collar ID, in |
DSI_BhaL |
Sections!$B$15 |
Collar length, ft |
DSI_BhaOD |
Sections!$B$13 |
Collar OD, in |
DSI_Bit |
Sections!$B$6 |
Bit at section TD, ft |
DSI_DpID |
Sections!$B$12 |
Drill pipe ID, in |
DSI_DpOD |
Sections!$B$11 |
Drill pipe OD, in |
DSI_Frac |
Sections!$B$18 |
Eaton fracture at shoe, ppg |
DSI_GeometryCheck |
Sections!$B$26 |
Geometry verdict |
DSI_GeometryCheckNote |
Sections!$F$26 |
Geometry comment |
DSI_Hole |
Sections!$B$7 |
Open-hole diameter, in |
DSI_IdBot |
Sections!$B$9 |
Casing lower ID, in |
DSI_IdTop |
Sections!$B$8 |
Casing upper ID, in |
DSI_MW |
Sections!$B$16 |
Section mud weight, ppg |
DSI_Pore |
Sections!$B$17 |
Max pore, open interval, ppg |
DSI_Q |
Sections!$B$35 |
Flow rate, gpm |
DSI_R300 |
Sections!$B$37 |
Fann 300 rpm, lb/100ft² |
DSI_R600 |
Sections!$B$36 |
Fann 600 rpm, lb/100ft² |
DSI_Results |
Sections!$B$5:$B$26 |
Section geometry, press. limits and c... |
DSI_Shoe |
Sections!$B$5 |
Previous shoe, ft |
DSI_Xover |
Sections!$B$10 |
Crossover depth, ft |
DSP_BhaID |
Sections!$C$14 |
Collar ID, in |
DSP_BhaL |
Sections!$C$15 |
Collar length, ft |
DSP_BhaOD |
Sections!$C$13 |
Collar OD, in |
DSP_Bit |
Sections!$C$6 |
Bit at section TD, ft |
DSP_DpID |
Sections!$C$12 |
Drill pipe ID, in |
DSP_DpOD |
Sections!$C$11 |
Drill pipe OD, in |
DSP_Frac |
Sections!$C$18 |
Eaton fracture at shoe, ppg |
DSP_GeometryCheck |
Sections!$C$26 |
Geometry verdict |
DSP_GeometryCheckNote |
Sections!$D$26 |
Geometry comment |
DSP_Hole |
Sections!$C$7 |
Open-hole diameter, in |
DSP_IdBot |
Sections!$C$9 |
Casing lower ID, in |
DSP_IdTop |
Sections!$C$8 |
Casing upper ID, in |
DSP_MW |
Sections!$C$16 |
Section mud weight, ppg |
DSP_Pore |
Sections!$C$17 |
Max pore, open interval, ppg |
DSP_Q |
Sections!$C$35 |
Flow rate, gpm |
DSP_R300 |
Sections!$C$37 |
Fann 300 rpm, lb/100ft² |
DSP_R600 |
Sections!$C$36 |
Fann 600 rpm, lb/100ft² |
DSP_Results |
Sections!$C$5:$C$26 |
Section geometry, press. limits and c... |
DSP_Shoe |
Sections!$C$5 |
Previous shoe, ft |
DSP_Xover |
Sections!$C$10 |
Crossover depth, ft |
DS_BhaID |
Sections!$G$14 |
Selected section BhaID |
DS_BhaL |
Sections!$G$15 |
Selected section BhaL |
DS_BhaOD |
Sections!$G$13 |
Selected section BhaOD |
DS_Bit |
Sections!$G$6 |
Selected section Bit |
DS_DPL |
Sections!$G$19 |
Selected section DPL |
DS_DpID |
Sections!$G$12 |
Selected section DpID |
DS_DpOD |
Sections!$G$11 |
Selected section DpOD |
DS_Frac |
Sections!$G$18 |
Selected section Frac |
DS_GeometryCheck |
Sections!$G$26 |
Selected section geometry check |
DS_Hole |
Sections!$G$7 |
Selected section Hole |
DS_IdBot |
Sections!$G$9 |
Selected section IdBot |
DS_IdTop |
Sections!$G$8 |
Selected section IdTop |
DS_Len1 |
Sections!$G$20 |
Selected section Len1 |
DS_Len2 |
Sections!$G$21 |
Selected section Len2 |
DS_Len3 |
Sections!$G$22 |
Selected section Len3 |
DS_Len4 |
Sections!$G$23 |
Selected section Len4 |
DS_Len5 |
Sections!$G$24 |
Selected section Len5 |
DS_Len6 |
Sections!$G$25 |
Selected section Len6 |
DS_MW |
Sections!$G$16 |
Selected section MW |
DS_Pore |
Sections!$G$17 |
Selected section Pore |
DS_Shoe |
Sections!$G$5 |
Selected section Shoe |
DS_Xover |
Sections!$G$10 |
Selected section Xover |
DT_EmwSurgeShoe |
'Surge Swab'!$B$36 |
Surge EMW at shoe, ppg |
DT_EmwSwabBit |
'Surge Swab'!$B$38 |
Swab EMW at bit, ppg |
DT_EmwSwabMin |
'Surge Swab'!$B$17 |
Min swab EMW in open hole, ppg |
DT_EmwSwabShoe |
'Surge Swab'!$B$37 |
Swab EMW at shoe, ppg |
DT_Hydro |
'Surge Swab'!$B$19 |
press. gradient of 1 ppg of mud, psi/... |
DT_Inputs |
'Surge Swab'!$B$5:$B$12 |
Trip timings, end mode and speed sweep |
DT_Kc |
'Surge Swab'!$B$5 |
Clinging constant |
DT_Mode |
'Surge Swab'!$B$6 |
Pipe end: 0 closed, 1 open |
DT_Peak |
'Surge Swab'!$B$10 |
Peak / average speed |
DT_Results |
'Surge Swab'!$B$13:$B$43 |
Planned trip pressures, speed limits ... |
DT_SafeIn |
'Surge Swab'!$B$39 |
Safe run speed, ft/min |
DT_SafeOut |
'Surge Swab'!$B$40 |
Safe pull speed, ft/min |
DT_SecMin |
'Surge Swab'!$B$18 |
Seconds in a minute, s/min |
DT_SpeedCheck |
'Surge Swab'!$B$43 |
Sweep-safe trip speeds verdict |
DT_SpeedCheckNote |
'Surge Swab'!$C$43 |
Sweep-safe trip speeds comment |
DT_Stand |
'Surge Swab'!$B$7 |
Stand length, ft |
DT_Start |
'Surge Swab'!$B$11 |
Lowest sweep speed, ft/min |
DT_Step |
'Surge Swab'!$B$12 |
Sweep speed step, ft/min |
DT_SurgeBit |
'Surge Swab'!$B$33 |
Surge pressure at bit, psi |
DT_SurgeCheck |
'Surge Swab'!$B$41 |
Surge at previous shoe verdict |
DT_SurgeCheckNote |
'Surge Swab'!$C$41 |
Surge at previous shoe comment |
DT_SurgeShoe |
'Surge Swab'!$B$32 |
Surge pressure at shoe, psi |
DT_SwabBit |
'Surge Swab'!$B$35 |
Swab pressure at bit, psi |
DT_SwabCheck |
'Surge Swab'!$B$42 |
Swab against interval pore max. verdict |
DT_SwabCheckNote |
'Surge Swab'!$C$42 |
Swab against interval pore max. comment |
DT_SwabShoe |
'Surge Swab'!$B$34 |
Swab pressure at shoe, psi |
DT_Sweep |
'Surge Swab'!$F$71:$N$75 |
Shared five-speed Burkhardt sweep |
DT_TimeIn |
'Surge Swab'!$B$8 |
Run time per stand, s |
DT_TimeOut |
'Surge Swab'!$B$9 |
Pull time per stand, s |
DT_VavgIn |
'Surge Swab'!$B$13 |
Avg run-in speed, ft/min |
DT_VavgOut |
'Surge Swab'!$B$15 |
Avg pull-out speed, ft/min |
DT_VpIn |
'Surge Swab'!$B$14 |
Peak run-in speed, ft/min |
DT_VpOut |
'Surge Swab'!$B$16 |
Peak pull-out speed, ft/min |
Details
| Opens in | Needs Microsoft 365 or Excel 2024: it uses functions Excel 2016 doesn't have, such as named LAMBDAs, which show #NAME? there. |
| File | DrillingProgram.xlsx, 59 KB |
| Category | Drilling |
| For agents and tools | Descriptor (.md) |
More Drilling Workbooks
AFE and Time-Depth
Microsoft 365How many days and dollars a well takes to drill by hole section, its AFE with contingency, the actuals against plan and its NPV at that cost.
Casing Design
Microsoft 365Where a well's casing seats go and whether each string holds its burst, collapse and tension loads, from pore and fracture pressure off a shale log.
Cementing Program
Microsoft 365How much cement and displacement each casing string takes, whether the placed column breaks the formation down and how long the job runs.
Completion Schematic
Microsoft 365Where each casing string, completion component and perforation sits in MD and TVD, and whether the well's two barriers hold, on a live schematic.
Fracture Treatment Design
PO Add-in + Microsoft 365How long a fracture a proppant mass buys and how to pump it, from unified fracture design through geometry and pump schedule to proppant and uplift.
Well Control Pack
Microsoft 365How to kill a kick and how big a kick the shoe takes: kill sheet, kick tolerance, MAASP, bullheading limits and BOP accumulator sizing.
Well Integrity Review
Microsoft 365Whether one well's casing, annuli, completion and abandonment barriers hold, from casing ratings and annulus pressure limits to tubing loads and plug cost.
Well Planning
Microsoft 365Where a directional well goes and whether the drill string can trip and rotate it, from a minimum-curvature survey to soft-string torque and drag.
Need a workbook we don't have? Suggest a Workbook








