Calculate Best Initial Production Automatically

xiaobaiw

It’s not hard to calculate best 30, 60, 0r 90-day average of initial production manually. What if you have many wells, let say more than 100 wells? This Excel tool is useful to determine initial production based on certain number of days. In addition to that, this  tool has capability to exclude downtime, for example you don’t want to include production rates that are less than a specified cut off rate. For quality control purposes, this tool provides chart showing original production before and after applying cut off rates.

How to run this tool:

Select well by clicking scroll button, or alternatively you can type well number in yellow cell.
Update your well list by clicking “Update Well List” button if you have production data from new well that is not on the list. Please note that this button will erase the previous outputs that have been generated before. If you want to keep the previous results, do not use this update button, just add your well name manually into Main sheet after adding new well production data into Prod Data sheet.
How to update production data:

Put your production data with the same format with this template into sheet “Prod Data”. You do not need to worry about the order of the well or production data. This tool will sort them for you.
Run this tool using above procedure.
Using VBA macro? Yes