Posted inPetroleum Engineering
Modeling High-Pressure Region Gas Flow Rate in Excel
In the context of petroleum engineering, high-pressure region gas flow rate is an important concept.…
Posted inPetroleum Engineering
Analyzing Fluid Flow with Hagen-Poiseuille Equation in Excel
The Hagen-Poiseuille equation is a physical law that describes the pressure drop in an incompressible…
Posted inPetroleum Engineering
Understanding Geothermal Gradient and Calculation in Excel
The geothermal gradient is the rate of change in temperature with respect to increasing depth…
Posted inPetroleum Engineering
Geertsma’s Model for Porosity/Transit-Time Relationship in Excel Formulas
Geertsma’s model is a porosity-transit time relationship that is used to estimate the porosity of…
Posted inLearn
How to Dynamically Change the Column Reference in Excel Lookup Functions
In Excel, you can use lookup functions to search for a value in a range…
Posted inLearn
How to Use VLOOKUP, INDEX, and MATCH Functions in Excel to Lookup Data
Sometimes, you may need to look up a value in a column and return the…
Posted inBusiness
How to Use Excel to Account for Cash Receipts and Progress Payments
Cash receipts to billed sales and progress payments are two methods of accounting for revenue…
Posted inBusiness
How to Calculate Sales per Person and Product in Excel
Sales per person is a metric that measures how much revenue each salesperson generates for…
Posted inLearn
How to Identify Opposite Value Pairs in Excel
In this article, we will learn how to find duplicates in two lists that are…
Posted inLearn
How to Perform Complex Lookups in Excel and Display the Result in Another Cell
Sometimes, we may need to look up a value from a table or a range…