Trip Sheet Excel File

Monitoring the well while tripping is one of the most critical in well control because it will tell you about the well condition very quickly. Therefore, we create an electronic version (Excel sheet) of trip sheet from drilling formulas blog. The trip sheet can be used for both trip in hole and trip out of hole.


*** This is updated version 1.1. We unlock all cells so you can modify to suit with your operation if required. ***

Please check out this link to download.

>>>Trip Sheet

1. When you open the file, you will see the screen like this.

33-1 trip sheet


2. First of all, you need to input pipe displacement. This file allow you to input 5 types of pipe displacement and the displacement can be in bbl/single, bbl/ft or bbl/stand.

33-2 trip sheet

3. On the right side of the file, you will see three shaded cells like this. The yellow mean you must manually input data. The blue one is an automatically calculated cells which you cannot change it. The last one is green showing you that you need to select value from the list which comes from pipe displacement values that you input as per step no 2.

33-3 trip sheet

4. The file will show you how much you need each ft/stand/single and show total cumulative required. Once you input the real figure, the file will show accumulative volume and tell you that you may gain/loss how many barrels. There are two columns that you can input the trip tank volume. One is from the rig sensor and another one is volume from mud logger trip tank. Therefore, you can compare the different between two separate sensors which help you cross check each other figures.

Please try to put the number and play with the file for more understand and I wish this file would be advantageous for your job.


Related Post

5 Largest Offshore Structures (Rig and Production ... Offshore structures (rig and production platform) are complex facilities to drill wells (options) and produce gas from wells from offshore locations. ...
Successful Topside Installation of the Ivar Aasen ... The heavy lift crane vessel ‘Saipem 7000’ has completed the installation of all ‘Ivar Aasen’ topside modules at the Ivar Aasen oil field in the Norweg...
Annular Velocity (AV) Calculation Annular Velocity (AV) is how fast of fluid in annulus while pumping. Three main factors affecting annular velocity are size of hole (bigger ID)...
Increase oil/water ratio The concept of increase oil water ratio is to increase oil volume in the system without any changes in water to meet new oil water ratio. How can ...
Share the joy
  • 397
Tagged . Bookmark the permalink.

About DrillingFormulas.Com

Working in the oil field and loving to share knowledge.

4 Responses to Trip Sheet Excel File

  1. Shiwei Yang says:

    Dear sir,
    I like it very much, would you please send me a coppy?

  2. I need it very much



  3. Eduard says:

    Thank you very much for this useful spreadsheet.

    Best regards,

  4. Charlie Lindsey says:

    Very good!!!! Simple and easy to use for drillers

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.