Average Permeability for Linear Flow Series Beds in Excel

Average permeability is a way of representing the overall permeability of a material that has different layers or regions with different permeabilities. Permeability is a property of a porous material that describes how easily fluids can flow through it.

Linear flow is a type of fluid flow that occurs when the pressure difference between the inlet and outlet of a material is constant. Linear flow is often assumed for convenience and approximation.

Series beds are a common structure of porous materials that consist of vertical layers with different permeabilities. Series beds are often found in natural reservoirs, such as oil and gas fields.

Average permeability for linear flow series beds is calculated by using the harmonic mean of the individual layer permeabilities. The harmonic mean is a type of average that gives more weight to smaller values. This means that the average permeability for linear flow series beds is lower than the simple average of the layer permeabilities.

Basic Theory:

Linear flow through series beds involves multiple rock formations with distinct permeabilities. The total flow across these beds is the sum of individual flows. The average permeability (k_{avg}) is calculated using Darcy’s law:

    \[Q = \frac{kA\Delta P}{\mu L}\]

Where:

  • Q is the total flow rate,
  • k is the permeability,
  • A is the cross-sectional area,
  • \Delta P is the pressure drop,
  • \mu is the fluid viscosity, and
  • L is the length of the flow path.

The average permeability for series beds can be expressed as:

    \[k_{avg} = \frac{\sum_{i=1}^{n}k_iL_i}{\sum_{i=1}^{n}L_i}\]

Procedures:

  1. Data Collection: Gather permeability (k) and length (L) data for each bed in the series.
  2. Excel Formulas:
    • Enter the data into an Excel table.
    • Use the SUM function to calculate the sum of k_iL_i and L_i.
    • Apply the average permeability formula.
  3. Scenario Example: Let’s consider a series of three beds with the following data:
    Bed Permeability (mD) Length (ft)
    1 100 500
    2 150 700
    3 80 600

Excel Calculation:

k_{avg} = \frac{(100 \times 500) + (150 \times 700) + (80 \times 600)}{500 + 700 + 600}

Result:

k_{avg} = \frac{50000 + 105000 + 48000}{1800} \approx 101.11 \, \text{mD}

MATLAB Comparison:

    1. MATLAB Code:


% Input data
permeability = [100, 150, 80]; % in mD
length = [500, 700, 600]; % in ft

% Calculate average permeability
k_avg_matlab = sum(permeability .* length) / sum(length);

disp([‘MATLAB Result: k_avg = ‘, num2str(k_avg_matlab), ‘ mD’]);

    1. MATLAB Result:

k_{avg} \approx 101.11 \, \text{mD}

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *