Posted inPetroleum Engineering
Understanding Horizontal Well Critical Rate Correlation: Chaperon Formula in Excel
The critical rate is the maximum production rate that does not allow water to breakthrough…
Posted inPetroleum Engineering
Hammerlindl Method for Gas in Place Calculation using Excel
The Hammerlindl method is used to estimate the original gas in place (OGIP) of abnormally…
Posted inPetroleum Engineering
Gas Flow Analysis in Tight Reservoirs using Hagoort and Hoogstra Models in Excel
Jacques Hagoort is a renowned petroleum engineer who has authored a book titled “Fundamentals of…
Posted inLearn
Using openpyxl to insert formula with intermediate arrays in excel formula
Openpyxl is a Python library that allows you to read and write Excel files. One…
Posted inLearn
How to Use an Array Formula to Filter Data by Keyword in Excel
In this article, we will learn how to use an array formula in Excel to…
Posted inLearn
How to loop through a range of cells in Excel VBA
The basic theory behind running a code on a range of cells and looping back…
Posted inLearn
How to Use VBA Code to Drag INDIRECT Formula Over Columns in Excel
The INDIRECT function in excel returns a reference to a range based on a text…
Posted inLearn
How to Create an Array of Every Occurrence Based on a Condition in Excel
In Excel, an array is a collection of values that are stored in a single…
Posted inLearn
How to Use Excel Formulas to Get the Group Header Value in a Pivot Table
A Pivot Table is a powerful tool that allows you to summarize and analyze data…
Posted inLearn
Export Excel Charts as Images and Save Them to Sharepoint in Minutes with VBA
VBA stands for Visual Basic for Applications, which is a programming language that allows you…