Posted inLearn
What is the Best Way to Return Values from the Next Row in an Array in Excel?
Sometimes, you may want to reference the next row in an array when a logical…
Posted inAccess
How to Remove Consecutive Duplicates in MS Access
Sometimes, you may have a table in MS Access that contains duplicate records that are…
Posted inAccess
How to Add and Edit Multivalued Fields in Microsoft Access VBA with DAO
A multivalued field is a field that can store more than one value in a…
Posted inAccess
Excel VBA and ADODB: Inserting Two Records with Foreign Key into Access Database for Enhanced Data Integrity
First, let me explain the basic theory of inserting two records with Excel VBA into…
Posted inChemical
Heat Capacity of Real Gases Analysis with Excel
Heat capacity is a measure of how much the energy of a gas changes when…
Posted inPetroleum Engineering
Determining Hydrocarbon Pore Volume Occupied by Evolved Solution Gas in Petroleum Engineering using Excel
Hydrocarbon pore volume is the amount of space in a reservoir that is filled with…
Posted inPetroleum Engineering
Horizontal Well Critical Rate Correlation – Joshi Method for Gas Coning in Excel
Gas coning is a problem that occurs when gas from a gas cap migrates into…
Posted inPetroleum Engineering
Horizontal Well Critical Rate Correlation – Giger and Karcher in Excel Formula
Horizontal well critical rate is the maximum oil production rate that can be achieved from…
Posted inPetroleum Engineering
Horizontal Well Critical Rate Correlation (Efros) in Excel
The critical rate of a horizontal well is the maximum flow rate that can be…
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…
