Posted inPetroleum Engineering
Gas Drive Index Calculation in Gas Reservoirs using Excel
Gas drive index (GDI) is a dimensionless parameter that measures the relative contribution of gas…
Posted inPetroleum Engineering
Gas Cap Shrinkage Analysis in Petroleum Engineering using Microsoft Excel
Gas cap shrinkage is the reduction in volume of the gas cap in a reservoir…
Posted inPetroleum Engineering
Understanding Gas Cap Ratio in Petroleum Engineering Using Excel and MATLAB
Gas cap ratio is a term used to describe the relative size of the gas…
Posted inPetroleum Engineering
Gas Bubble Radius Calculation in Excel
Gas bubble radius is a measure of how big a gas bubble is when it…
Posted inLearn
Using structured references to link two Excel tables with different starting rows
What are structured references? A structured reference is a way of using a table name…
Posted inLearn
Count values in range of columns if appear in array in Excel formula
The basic idea of counting values in a range of columns if they appear in…
Posted inLearn
How to Record a Value When Date Condition is Met in Excel Formula
Sometimes, you may want to record a value in a cell when a date condition…
Posted inLearn
How to Get Unique Data from Specific Columns to Another Column in Excel
Introduction Sometimes, you may have a dataset that contains duplicate values in one or more…
Posted inLearn
A Guide to Excel Formulas for Determining the Most Common 3 Digits in a Numeric Data Set
Sometimes, you may have a column of numeric data and need to determine the most…
Posted inLearn
How to Take Cell Reference Location and Obtain Value from Another Sheet in Excel Formula
In Excel, you can use formulas to perform calculations or manipulate data from different worksheets…
