Oil material balance excel spreadsheet. From each separate point, a calculation is made and the results of these calculations are averaged. Material balance relates production data and pressure history to estimate key reservoir properties like initial oil in place and aquifer size. xls and GasMBExample. . In this video I demonstrate the basics of performing material balances in Microsoft Excel a useful skill for any chemical engineer, and then I present two example problems involving a Petroleum Office provides a large collection of specialized functions for oil and gas professionals. xls. xls for oil reservoir analysis and LSUGasMB. With these functions you can build powerful, yet easy to read spreadsheets. xls for gas reservoir analysis. Before using the blank spreadsheets, it would be best to examine two completed problems, OilMBExample. Two blank spreadsheets are available for material balance analysis, LSUOilMB. Normally, when using the material balance equation, each pressure and the corresponding production data are considered as being a separate point from other pressure values. This document discusses using an Excel spreadsheet to perform material balance calculations to analyze oil reservoirs. Material Balance Calculations Using the Excel Spreadsheet, Applied Petroleum Reservoir Data Input Two blank spreadsheets are available for material balance analysis, LSUOiIMB. spzqy klyg pborlwg atzp mra xde qwxzqd whmlk hfrx qxlrji