Cement Calculator (Metric Unit) Excel Spreadsheet

Jonathan Lukye who is a supervisor from Sanjel in Estevan, Saskatchewan, Canada shares his cement Excel spreadsheet. He has been working on a Metric Cement Calculator in Excel. In the Excel spreadsheet, it contains; Surface Cement, Intermediate / Production, Liner, Retainer, Plugs, Deviated Hole and Squeeze.

This is the latest version as of 14 September 2016.

Updated features of this version

• Remove the code has made the calculator’s footprint smaller and faster on Smart Devices.
• Make the file smaller
• Fix some calculation errors
• Fix cement plug calculation

The Surface, Intermediate and Liner Worksheets are “automatic” where there is no need for a handbook for factors as the sheet calculates them.  They also print out the job procedure for that sheet.

There’s also a page for Dimensions and Strengths as a reference.  And a Technical Data page for figuring out quick calculations.

Just a couple of quick tips, even though it’s evident what’s needed; The Surface, Intermediate and Liner worksheets require three worksheets to work, Main and the associated “Cap” page.  The rest of the Workbook relies on just input from the single worksheet.  The left side of the sheets are the “engineered” side, it will build what is required for that job and the top of the sheet compares the engineered side with what cement is on location and it will use the actual cement on location to build the job.  The Intermediate page has a weighted preflush calculator if needed.  If you print the surface, intermediate or liner sheets it will print the job procedure according to the input from the engineered and available parts of the sheet.  The charts, used as the well diagram, are dynamically sized using VBA so, these won’t resize on mobile devices as they don’t support VBA.

Every worksheet is protected but the Main and Dimensions and Strengths sheets are password protected as the sheets use those as reference and should not be altered.

Download the spreadsheet here ->Cement Calculator (Metric Unit) Excel Spreadsheet by Jonathan Lukye

Once you open the file, you need to enable macro in order to allow this spreadsheet work properly.

Enable Macro

Some screenshots are shown below.

Balanced Cement Plug

Cement Squeeze

Liner Cement job

Retainer Cement Job

Download the spreadsheet here ->Cement Calculator (Metric Unit) Excel Spreadsheet by Jonathan Lukye