petroleum engineering calculations

excel petroleum engineering calculations

Petroleum Goodies

Helpful Tools & Tips in Petroleum Engineering

Petroleum Engineering Calculations

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading ... Loading ...

Excel Petroleum Engineering Calculations

This is very useful Excel functions that are commonly being used in petroleum engineering calculations. These functions are built in an Excel add-in. This tool consists of formulas and calculations on PVT correlations, pipe flow, and table lookup/interpolation.

There is a help file that explains formula calculation such as description of the function and syntax how to use it. It doesn’t have equations written in the help file. But you still can look for it in the reference.

This Excel add-in is written in Visual Basic for Application. Unfortunately, it’s password protected so you can’t see the equations to ensure if the calculation works properly. But it is a good idea to try using this tool as it could save you a lot of hassles and time

How To Use This Excel Add-in

  1. Download zipped file from the following download link and extract the file to your local drive.
  2. From Microsoft Excel menu, click Tool, Add-Ins and then browse the extracted file. The file name is Epecvb.mod.xla. We’ve tested this add-in using Microsoft Excel 2003 for Windows.
  3. Since this is an Excel add-in, there is no user interface. To use this tool, go to Insert then Functions from your Excel menu.

Use VBA macro? Yes

Download Excel Add-in for PE Calculations


Please sign in to download this tool. If you haven't signed up yet, please register here.
Download Excel Petroleum Engineering Calculations [Downloads: 3,201 - File size: 171.7 KiB - Type: File in zipped folder]

We advise you to read our Disclaimer before utilizing this tool. If you find our tool useful or easy to use, please consider donating a few bucks through Paypal or please take the time to share this site to your colleagues.

Recommended Petroleum Engineering Books

Comments

10 Responses to “Petroleum Engineering Calculations”

  1. Abed Mazeel 208 days ago

    hello,
    which is for the oil shrinkage factor calculator?

    Thank you
    Abed

  2. admin 204 days ago

    Hi Abed, have you tried this tool?

    http://petrogoodies.com/shrinkage-factor-calculation/

  3. jorge bracamontes 157 days ago

    Very good site

  4. TEXWS6 149 days ago

    Have added this in Excel as an “Add On” but cannot find the buttons or options to run this in Excel 2007.

  5. admin 147 days ago

    Hi TEXW56, this is an Excel add-in, no user interface. To use this tool, go to Insert then Functions from your Excel menu.

  6. chriscais 142 days ago

    hi,

    i have a vba code which references functions in this add-in. however, when i try to add the epecvb.mod.xla as a reference to the modules, i get a 400 error (excel 2010, windows 7). Can you help?

    thanks

  7. admin 142 days ago

    Hi chriscais, can you send a screenshot of the 400 error to petrogoodies[at]gmail.com?

  8. chriscais 142 days ago

    thanks for getting back to me – problem solved, i managed to get it working in a new sheet, the error was ocurring in an old version.

  9. jituparekh 110 days ago

    excellent

  10. MOHA 84 days ago

    i can see the file on add in menu. but nothing came out!! please help. m.alajeel at me.com

What do you think of this tool? Say something here!

You must be logged in to post a comment.