PO.PTA.Design.GaugeRes


Description

Whether a pressure gauge resolves the radial-flow derivative a test needs. In radial flow the Bourdet derivative is flat at m/ln(10), where m is the semilog slope; a gauge that can only tell pressures apart to its resolution δ puts an error of up to δ/L into a derivative taken over a smoothing window of L natural-log cycles. The function returns that error as a fraction of the flat derivative. The PO sheets call it good below 2 %, a fifth of the ±10 % band that identifies the radial-flow window, and unusable above 10 %, where the noise fills that band.

Formula

=LAMBDA(m, resolution, L, IF(OR(m<=0, L<=0), NA(), LN(10)*resolution/(L*m)))

Parameters

Parameter Unit Description
m psi/cycle Expected semilog slope, 162.6·q·B·μ/(k·h)
resolution psi Gauge resolution
L ln cycles Bourdet smoothing window

Examples

Invocation Expected
=PO.PTA.Design.GaugeRes(33.875, 0.01, 0.2) 0.00339865
=PO.PTA.Design.GaugeRes(33.875, 1, 0.2) 0.339864958
=IF(ISNA(PO.PTA.Design.GaugeRes(33.875, 1, 0)), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda