Petroleum Goodies: Petroleum Engineering Calculations

Posted: 29 Mar 2011 02:35 AM PDT

Excel Petroleum Engineering Calculations

This is very useful Excel functions for petroleum engineering calculation that build in Excel add-ins. It consists of formulas and calculations that commonly used in petroleum engineering including PVT correlations, pipe flow, and table lookup/interpolation.

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

This Excel petroleum engineering calculation add-ins is written in VBA code. Unfortunately, it’s password protected so we can’t see the macro or calculation to check if the formula is correct. But it’s good to try the tool though.

How to use this tool?

Download zipped file from the following link and extract the file to your local hard drive.
Open Microsoft Excel (minimum version 7.0), click Tool | Add-Ins and then browse the extracted file named Epecvb.mod.xla.

Use VBA macro? Yes

Note: There is a file embedded within this post, please visit this post to download the file.

Similar Posts:

Petroleum Goodies

Tuesday, March 29, 2011