PO.FRAC.Proppant.Crushing


Description

The fraction of a proppant that crushes to fines at the stress it carries in the well. The crush test (ISO 13503-2, formerly API RP 56 and 60) loads a pack in a cell and weighs the fines made at each stress, and the proppant's K-value is the highest stress, in thousands of psi, at which no more than 10 % crushes. The function takes two points of that test and the well's closure stress and flowing bottomhole pressure, and returns the fines fraction at the effective stress between them, interpolated log-linearly, since crushing grows close to exponentially with stress. Compare it with the 10 % the K-value is defined at.

Formula

=LAMBDA(sigma_c, pwf, sigma_lo, fines_lo, sigma_hi, fines_hi, IF(OR(fines_lo<=0, fines_hi<=0, sigma_hi=sigma_lo), NA(), MIN(1, fines_lo*EXP(LN(fines_hi/fines_lo)*(MAX(0, sigma_c-pwf)-sigma_lo)/(sigma_hi-sigma_lo)))))

Parameters

Parameter Unit Description
sigma_c psi Closure stress (the minimum horizontal stress) at the fracture
pwf psi Flowing bottomhole pressure, which carries part of the closure stress
sigma_lo psi The lower crush-test stress
fines_lo fraction Fines made at the lower test stress
sigma_hi psi The higher crush-test stress
fines_hi fraction Fines made at the higher test stress

Examples

Invocation Expected
=PO.FRAC.Proppant.Crushing(7000, 2000, 4000, 0.04, 6000, 0.16) 0.08
=PO.FRAC.Proppant.Crushing(8000, 2000, 4000, 0.04, 6000, 0.16) 0.16
=PO.FRAC.Proppant.Crushing(5000, 2000, 4000, 0.04, 6000, 0.16) 0.02
=PO.FRAC.Proppant.Crushing(12000, 2000, 4000, 0.04, 6000, 0.16) 1
=IF(ISNA(PO.FRAC.Proppant.Crushing(7000, 2000, 4000, 0, 6000, 0.16)), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda