• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Primary Cementing
  • Remedial Cementing
  • Plug Cementing
  • Job Execution
  • Post-job results interpretation
  • Equipment
  • Laboratory
  • Mission
  • About
  • Contact and Questions?
  • My Cementing Challenges

Better Well Cementing for ALL

The Leading Online Support Hub for Better Oil Well Cementing.

Where is your TOC now? Cementing Calculations Sheet in Excel

May 2, 2020 By Lenin Diaz 40 Comments

Where is your TOC now? Cementing Calculations Sheet in Excel

Before we get into the cementing calculations sheet available below, first some background. For some time already, I have been receiving requests from friends and readers, mostly drilling engineers and well-site people, to provide a quick and fact-based tool to estimate the top of cement (and all cementing fluids) after a job. A tool that can also help during the design phase to identify where the cement (lead, tail or single slurry) top should be to cover a permeable formation or to reach a certain depth inside the previous casing.

Well, I did some additional work on an old Excel sheet I developed a few years ago. I completed the first version ready for distribution, here in my blog, of a TOC calculator. This calculator has the following features.

Besides well and fluids details, It accepts input of:

a) Two-diameters caliper,
b) Excess %,
c) Losses (lead and tail),

Well schematic/chart to visualize:

a) Position of fluids (lead, tail or spacer),
b) Caliper,
c) Casing details,
d) Top of formations (up to 7 formations)
e) Estimation of the final circulating pressure (FCP or pressure just before bumping the plug).

This free online version of the calculator only works with vertical wells, it cannot be saved and does not allow customization of the well schematic chart.

For the complete version of my cementing calculations sheet, I appreciate your kind donation very much (see donation link, via PayPal, at the bottom of this page).

Free version (Donate to get the full version as an Excel file – Donation link in the right pane to the bottom)

Free cementing calculations sheet
Free Online Version

Fill only the green cells, paste your Caliper (4-arm) or input manually your hole details and you are good to go!

Scroll to the right to see the chart and if you need to start over just reload the page. The page will return to the example case.


This excel sheet has been tested and it is working great for me, but I am sharing it with the objective to help people. I would like you to try it and give me your opinion or what improvements or changes it needs.

Take a look at the full version with all capabilities.

Cement plug calculation Excel
Full version – Thanks for your Donation

Cheers,

L. Diaz

Related posts:

  1. Balanced-plug method. Basic calculations
  2. All you need to know about Bentonite in Cement Slurries
  3. Primary Cementing Checklist (Customer)
  4. Workover Cementing Techniques 2: Squeeze Cementing

Filed Under: General, Primary Cementing Tagged With: primary cementing, top of cement

Article Posted By:

Lenin Diaz is an oil industry specialist with 26 years of technical and operational expertise in fluids, cementing, water control and shut-off. A distinguished track record spanning BP, Schlumberger, and NAPESCO. Lenin lives in Tenerife, Spain and is the creator of this website. Read More…

Reader Interactions

Comments

  1. Mohammed says

    May 7, 2020 at 8:57 pm

    Great ??

    Reply
    • Lenin Diaz says

      May 8, 2020 at 1:59 pm

      Thanks Mohammed

      Reply
  2. Hussain says

    May 8, 2020 at 12:46 am

    Please send to me

    Reply
    • Lenin Diaz says

      May 8, 2020 at 2:00 pm

      Hi Hussain, please send me an email. Thanks

      Reply
      • joe says

        August 13, 2022 at 3:59 am

        could send the exel sheet to me please

        Reply
        • Lenin Diaz says

          September 23, 2022 at 11:41 am

          Hi Joe,
          Certainly, please send me an email

          Reply
  3. Kharchi sofiane says

    May 8, 2020 at 3:53 am

    Amazing, would you please send to me
    Mr.kharchi.sofiane@gmail.com

    Reply
    • Lenin Diaz says

      May 8, 2020 at 2:00 pm

      Sure Kharchi, please send me an email. Thanks for your support

      Reply
  4. Seif Eddine Zaigouche says

    May 9, 2020 at 11:20 pm

    Omg I was looking to have such asset on the field. Please let know how I can have it or download it.
    Amazing job.
    Thanks.
    zaigouche@yahoo.com

    Reply
    • Lenin Diaz says

      May 9, 2020 at 11:49 pm

      Hi Seif,
      Thanks for your interest in my website. I am giving the full version only to those donating to help me maintain my website and also to keep track and send them future / improved versions. Please find the donation link on the right bottom side of this page.
      Cheers,
      L. Diaz

      Reply
  5. juel haterman says

    July 31, 2020 at 10:25 pm

    could you please to share excel sheet calculation for TOC, thanks. juelhaterman@gmail.com

    Reply
    • Lenin Diaz says

      August 4, 2020 at 11:05 am

      Thanks for you message Juel, please see in this post the process to get the full version.

      Cheers
      L. Diaz

      Reply
  6. david liem says

    August 13, 2020 at 8:09 am

    Dear,

    Could you share the excell calculator file to me as well at coemy_2000@yahoo.com

    many thanks

    Reply
    • Lenin Diaz says

      August 14, 2020 at 10:52 pm

      Thanks for you message David, please see in this post the process to get the full version.

      Cheers
      L. Diaz

      Reply
  7. Abath Vera Palenque says

    September 9, 2020 at 9:46 pm

    Podria compartirme la planilla de excell por favor, es muy interesante

    Reply
    • Lenin Diaz says

      September 14, 2020 at 7:11 am

      Hola Abath, gracias por tu comentario e interés. Por favor escribeme a mi correo o WhatsApp para mas información.
      Saludos
      L. Diaz

      Reply
  8. ali says

    April 7, 2021 at 8:55 am

    could you please to share excel sheet calculation for TOC, thanks lot : alimi_06@yahoo.fr

    Reply
    • Lenin Diaz says

      May 3, 2021 at 7:02 am

      Hi ALi, thanks for your interest. Please send me an email to dlenin@hotmail.com

      Reply
  9. abdulkadir alrawi says

    September 9, 2021 at 11:01 am

    That is amazing,I’m student of petroleum and gas engineering and recently explored your web site unfortunately.could you please share excell sheet with me,thank a lot.

    Reply
  10. abdulkadir alrawi says

    September 9, 2021 at 11:02 am

    here it is my e-mail:abdulkadir_elravi@hotmail.com

    Reply
  11. abdulkadir alrawi says

    September 9, 2021 at 11:05 am

    that is amazing could you share your excel sheet with me.

    abdulkadir_elravi@hotmail.com

    Reply
  12. salem says

    March 18, 2022 at 11:32 am

    that is gret could you share your excel sheet with me.

    Reply
  13. chris rayner says

    June 14, 2022 at 2:33 am

    Hi Lenin, I made a donation through paypal, how do I make contact to receive a copy of the spreadsheet?

    Reply
    • Lenin Diaz says

      July 31, 2022 at 6:38 am

      Hi Chris
      Already shared by email, thanks for your donation
      Cheers
      L. Diaz

      Reply
  14. AlmuntasirBellah says

    July 8, 2022 at 6:44 am

    Hi,
    Great job
    please send it to me

    Reply
  15. Daniel Ryan Mauldin says

    July 31, 2022 at 3:18 am

    Please email me a copy of the excel sheet. drmauldin79@gmail.com

    Reply
    • Lenin Diaz says

      July 31, 2022 at 7:19 am

      Hi Daniel
      Already shared, thanks for your donation
      Cheers
      L. Diaz

      Reply
  16. Ryan says

    August 20, 2022 at 1:56 pm

    Great article. Could you please send.

    Reply
    • Johnny vendetto says

      October 5, 2022 at 5:27 pm

      Please send TOC. Calculation excel sheet

      Reply
      • Lenin Diaz says

        December 12, 2022 at 12:18 pm

        Please send me an email

        Reply
  17. Arrowin says

    November 10, 2022 at 1:54 am

    Hello please send me a copy of this excel sheet.

    Reply
    • Lenin Diaz says

      December 12, 2022 at 12:22 pm

      Please send me an email

      Reply
  18. Bhushan Salve says

    November 16, 2022 at 10:32 am

    This is very nice. Appreciate if you send me full version excel sheet.

    thanks

    Email Address as
    salve.bhushan@gmail.com

    Reply
    • Lenin Diaz says

      December 12, 2022 at 12:22 pm

      Glad you find this useful. Please send me an email

      Reply
  19. tang says

    December 4, 2022 at 11:19 am

    Great article. Could you please send.

    Reply
    • Lenin Diaz says

      December 12, 2022 at 12:24 pm

      Glad you find this useful. Please send me an email

      Reply
  20. tang says

    December 4, 2022 at 11:20 am

    Please email me a copy of the excel sheet. tanghui1999@163.com

    Reply
    • Lenin Diaz says

      December 12, 2022 at 12:24 pm

      Glad you find this useful. Please send me an email

      Reply
  21. Lenin Diaz says

    December 12, 2022 at 12:22 pm

    Glad you find this useful. Please send me an email

    Reply
  22. Aderito says

    December 15, 2022 at 8:36 am

    Great explanation and tool. Very helpful.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Trango DEPM is a team of Oil&Gas professionals with broad experience in the O&G industry. Working on onshore and offshore projects around the world, including most vivid and challenging areas as Saudi Arabia, US Marcellus shale and North Sea, but also small on small projects, requiring individual approach, we are well equipped to help you plan, budget, implement and execute your drilling project successfully. We also cooperate with number of other professionals with experience in such areas as drilling, geology, geophysics, procurement or logistics. This allows us to fully run your project or just support you in desired areas of expertise, depends on you needs.

How I survived the 2016 Downturn and the current difficult times?

Find the content you need

Archives

24 Page Free Primary Cementing Guide

Click this image to take a look. It is comprehensive and easy to follow too!

In 2016, I launched Better Cementing for All. Now, I want to keep it alive.

For more than 26 years, I have worked in oil well cementing, offering my services to some of the largest oil corporations in the world and committing myself to excellence. I have mastered my role, and in doing so, I have accrued a skill set that is extremely valuable to my fellow professionals. Eager to do whatever I can to help them, I have owned and operated Better Cementing for All since 2016.
Let me tell you what Better Cementing for All does and what it means. A resource for all oil industry professionals and for cementers both established and prospective, this is a non-profit resource that I established in order to do nothing but serve and make an impact on people who are looking to build careers for themselves in cementing.
From primary cementing to remedial cementing to plug cementing to post-job results, I do it all, and I am comfortable answering in-depth questions about each and every one of these topics. I also offer tools and tips for jobseekers, general self-development advice, and guidance for equipment choices. TO put it simply, this is the go-to spot for anyone who wants to know anything about oil well cementing.
The problem, however, is that covid-19 has made the structure of the website seem untenable. I am trying to juggle the work that I do and my non-profit initiatives and finding it all unhealthy and unsustainable. I want to keep Better Cementing for All up and running, but to do that, I need your help.


My NEW introductory VIDEO

Recent Posts

Max Out Your Cement Coverage

If we consider the main variables to ensure proper mud in hole replacement with cement: stand-off, … [Read More...] about Max Out Your Cement Coverage

Cementing Flowchart

In recent weeks, I received some reader requests to include cement job processes or procedures as … [Read More...] about Cementing Flowchart

Cementing. Challenges across permeable zones

This article will provide you with some actionable suggestions for cementing across permeable zones. … [Read More...] about Cementing. Challenges across permeable zones

Forensic Cementing

Forensic is a term usually associated with crimes. Criminal forensics is the use of science to … [Read More...] about Forensic Cementing

Cement Slurry design Basics

First, here is a handy table to simplify the process of cement slurry design: Additive … [Read More...] about Cement Slurry design Basics

well cementing pre-job cement challenge question

Remedial Cementing with Coiled Tubing (animation)

Though I am far from being an animation expert, during my training courses I have always wanted to … [Read More...] about Remedial Cementing with Coiled Tubing (animation)

Need urgent help?

WhatsApp me at this number: +34 657 07 01 78

Footer

Recent activity

Visit our latest posts and help others by adding a comment.

Make your contribution and help keep Better Cementing for All alive!

Now more than ever, we are facing a loss of expertise in our industry, and Better Cementing for All is a unifying force, featuring interactions among industry professionals, knowledge sharing through posts, and other valuable pieces of content that we need to preserve.

Recent Comments

  • Merit on Cementing Equipment from Serva SJS Limited
  • Lenin Diaz on Cementing Equipment from Serva SJS Limited
  • Lenin Diaz on All you need to know about Bentonite in Cement Slurries
  • Lenin Diaz on Cementing Equipment from Serva SJS Limited
  • Lenin Diaz on Cementing Equipment from Serva SJS Limited
  • Lenin Diaz on Suicide Squeeze Cementing: risky but valid
  • Samuel Bekele Bedjiga on All you need to know about Bentonite in Cement Slurries

Recent Posts

  • Max Out Your Cement Coverage
  • Cementing Flowchart
  • Cementing. Challenges across permeable zones
  • Forensic Cementing
  • Cement Slurry design Basics
  • Remedial Cementing with Coiled Tubing (animation)
  • Plug and Abandonment Webinar (Español)
  • Webinar series (II). Quality Assurance in Cementing Operations (Spanish)
  • Webinar series (I). Log interpretation (Spanish)

Submit your email

&middot Better Well Cementing For All is owned by L. Diaz © 2023 &middot TOS & Privacy Policy &middot Web Design &middot