Petroleum Goodies: Calculate Daily Step Rate from Production Volume

---

Calculate Daily Step Rate from Production Volume Posted: 16 Nov 2012 09:00 PM PST Imagine you have producing gas wells with small amount of liquid production oil or water. Your liquid productions are not producing continuously (intermittent). Your liquid productions are not tied in directly to sales line. Or your wells are located far away from central facilities. Consequently, liquid productions need to be hauled by truck every certain day or every week. As a result, your production data is not in daily rate but in volume collected from certain days. As petroleum engineer, you want to have daily production data from this volume to do production analysis or put them into simulation for history matching. You can convert this volume into step daily rate by dividing the volume with number of elapsed days when you collect the liquid production. You can calculate daily rate manually in Excel sheet or use this Excel tool to get daily step rate. This Excel tool can calculate daily step rate from production volume automatically. Production volume can be collected in different time intervals of day, not necessary every 5 days, every week, etc. For example, you collect your liquid production every 3 days for the first month of production, every week for the second month of production then every month for the rest of your well life. This Excel tool can calculate daily step rate from production volume from different time intervals of day. How to use this tool? Input date in column B and your production volume in column C. Please remember, this should be production volume NOT rate. Daily step rate will be calculated in this Excel tool. Hit Calculate button to convert production volume to daily step rate. Check total cumulative volume from production volume and step rate for QC purposes. These two numbers should match. Using VBA macro? Yes Note: There is a file embedded within this post, please visit this post to download the file. Disclaimer: This work falls under the GNU General Public License. Any usage of these Excel sheets is undertaken at users own risk. There is no warranty, that they will not cause damage to your computer system, network, software or other technology. This Excel tool has VBA macro that is currently not working on Microsoft Excel for Mac OS X due to unresolved issue.Related Posts: Post Audit Production Template Calculate Best Initial Production Convert Hourly Production Data To Daily Data Convert Daily Production Data Automatically Production Plot Template

You are subscribed to email updates from Petroleum Goodies To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610