An Interactive 5-Day Training Course
Cementing Calculations Using MS Excel
Cement Job Design in Excel
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
21 Feb 2027
Cementing Calculations Using MS Excel
Have Questions ?
Cementing Calculations Using MS Excel - DC-CEM-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| DC-CEM-EXCEL-PEA27 | 21 - 25 Feb 2027 | 10 AM CST | 4 Hours / Day |
Online |
USD |
2000 |
Need this for a group? We deliver the same course in-house — face-to-face at your location or online — tailored to your assets and team level. Contact info@peassociations.com
Boost your team's skills and your budget! Enjoy group discounts for collaborative learning. Send an inquiry to info@peassociations.com.
Cementing Calculations Using MS Excel
This course builds cementing calculation workbooks in Microsoft Excel. Participants build volume and excess calculations, slurry and additive design sheets, displacement and strokes, hydrostatic and lift pressure, equivalent circulating density during cementing, centraliser spacing and standoff, job timing, remedial squeeze calculations and job summary reporting, using live formulas with no macros, add-ins or coding.
Description
Cement job design is arithmetic-heavy: volumes, excess, slurry quantities, displacement, pressures and timing, all of which must be right before the job starts because there is no opportunity to correct them afterwards. Most of this is done in service company software, and the operator engineer checking it often has no independent tool.
This course builds that tool. It starts with volume calculations: annular and casing capacities, open hole excess from caliper data, slurry and spacer volumes. It builds slurry design sheets covering yield, mix water, additive quantities and density, then displacement calculations with strokes, pressures and the point of balance. It builds hydrostatic and lift pressure calculations, equivalent circulating density during the job against the fracture gradient, centraliser spacing and standoff calculation, and job timing against thickening time. It closes with remedial and squeeze calculations and the job summary reporting an operator needs. All with live formulas and no macros, add-ins or coding.
Excess is where volumes go wrong. Open hole volume from a caliper is reliable; volume estimated from bit size plus a percentage is a guess, and in washed-out hole it can be badly short. Building both and comparing them makes the uncertainty explicit before the job rather than after short returns.
Pressures during the job can break the formation. As heavier slurry replaces lighter mud in the annulus, hydrostatic rises, and adding friction pressure during displacement can exceed the fracture gradient at the weak point. A sheet that profiles equivalent circulating density through the job shows whether the design is within limits.
Standoff drives displacement efficiency. Centraliser spacing determines how centred the casing is between centralisers, and poorly centralised casing leaves mud channels that no slurry design will correct. The spacing calculation is straightforward and is often the highest-value sheet in the workbook.
By the end of this training, participants will be able to:
- Calculate annular and casing capacities and volumes.
- Calculate open hole volumes and excess from caliper and estimated data.
- Build slurry design sheets covering yield, mix water, additives and density.
- Calculate spacer and wash volumes and their compatibility requirements.
- Build displacement calculations with strokes, volumes and balance points.
- Calculate hydrostatic and lift pressures through the job.
- Build equivalent circulating density profiles during cementing against the fracture gradient.
- Calculate centraliser spacing and standoff.
- Build job timing calculations against thickening time.
- Build remedial and squeeze calculations and job summary reports.
The course is instructor-led and entirely hands-on in Microsoft Excel. Participants build each calculation from blank sheets and apply the workbook to real cement job designs, comparing their results with service company proposals. All work uses live formulas with no macros, add-ins or coding, and participants keep every workbook they build.
Organisations sending participants to this training will:
- Check cement job designs independently of the service company.
- Reduce volume and displacement errors.
- Keep cementing pressures within the formation limits.
- Improve centralisation and displacement efficiency.
- Improve cement job records and post-job analysis.
Participants will:
- Be able to calculate cement volumes, slurries and displacement.
- Be able to check pressures and equivalent circulating density during the job.
- Be able to calculate centraliser spacing and standoff.
- Be able to review service company job proposals.
- Take away a working cementing calculation workbook.
- Drilling and well engineers
- Cementing engineers
- Rig site supervisors and company representatives
- Service company cementing personnel
- Well integrity engineers
- Graduate engineers in drilling roles
Module 1: Capacities and Volumes
- Casing and annular capacity calculation
- Open hole volume from caliper data
- Volume without caliper data
- Excess selection and justification
- Building the volume sheet
Module 2: Slurry Design Sheets
- Slurry yield and mix water
- Additive quantities and concentrations
- Density calculation and checks
- Blend requirements and bulk quantities
- Comparing design options
Module 3: Spacers and Washes
- Spacer volume and contact time
- Density hierarchy requirements
- Compatibility considerations
- Wash volumes
- Spacer design sheet
Module 4: Displacement
- Displacement volume and strokes
- Pump schedule construction
- Balance point calculation
- Plug bump prediction
- Under and over displacement risks
Module 5: Pressures
- Hydrostatic through the job
- Lift pressure calculation
- Pump pressure prediction
- Pressure at the plug bump
- Casing pressure limits
Module 6: ECD During Cementing
- Friction pressure during displacement
- Equivalent circulating density profile
- Comparison with fracture gradient
- Rate limits to stay within the window
- Managing losses during cementing
Module 7: Centralisation
- Standoff definition and calculation
- Centraliser spacing calculation
- Restoring force requirements
- Standoff along the interval
- Specifying the centraliser programme
Module 8: Job Timing
- Thickening time requirements
- Job duration calculation
- Safety margins
- Temperature effects on timing
- Contingency planning
Module 9: Remedial and Reporting
- Squeeze volume and pressure calculations
- Balanced plug calculations
- Job summary sheet
- Comparison of planned and actual
- Post-job analysis and records
Upon successful completion of this training course, delegates will be awarded an official Certificate of Completion issued by the Petroleum Engineers Association (PEA), an ISO 9001:2015 certified training organization. The certificate carries 10 Credits and formally records the total learning hours completed.
Each certificate is signed by the Course Facilitator and the CEO of the Petroleum Engineers Association, and serves as verifiable proof of professional training that delegates can present to employers and professional bodies worldwide.
Frequently Asked Questions
All course bookings made through PEA are strictly non-refundable. By registering for a course, you acknowledge and accept that all fees are payable in full and are not subject to refund under any circumstances, including changes in personal or professional commitments or partial attendance.
PEA reserves the right to make reasonable adjustments to course content, trainers, or schedules where necessary, without entitling delegates to a refund. Comprehensive details of each course — including objectives, target audience, and content — are clearly outlined before enrolment, and it is the responsibility of the delegate to ensure the course's suitability prior to booking.
For any inquiries related to cancellations or bookings, please contact our support team, who will be happy to assist you.
