PO.RP.Rod.TaperStress


Description

The fatigue check of one section (taper) of a steel sucker-rod string by the API RP 11BR modified Goodman diagram. The allowable peak stress at the top of the taper rises with the minimum stress the rod sees on the downstroke: Sa = (T/4 + 0.5625·Smin)·SF, where T is the grade's minimum tensile strength and SF the service factor for the produced fluid. The function returns that allowable stress, the taper's loading, which is the stress range it carries over the range it may carry, (Smax − Smin)/(Sa − Smin), or the margin Sa − Smax. A loading above 1 (100 %) is outside the diagram: the rods are expected to fail in fatigue.

Formula

=LAMBDA(t_min, s_max, s_min, sf, output, IF(OR(t_min<=0, sf<=0, s_min<0, s_max<s_min), NA(), LET( sa, (t_min/4+0.5625*s_min)*sf, IF(output="Sa", sa, IF(output="Loading", IF(sa<=s_min, NA(), (s_max-s_min)/(sa-s_min)), IF(output="Margin", sa-s_max, NA()))))))

Parameters

Parameter Unit Description
t_min psi Minimum tensile strength of the rod grade: 90,000 for grade C, 115,000 for grade D (API Spec 11B)
s_max psi Peak stress at the top of the taper, the peak load there over the rod area
s_min psi Minimum stress at the top of the taper, the minimum load there over the rod area; 0 or more
sf fraction Service factor for the fluid: 1.0 non-corrosive, 0.9 salt water, 0.7 H₂S, as API RP 11BR tabulates for grade D
output text "Sa" (allowable stress, psi), "Loading" (fraction of the allowable stress range) or "Margin" (Sa − Smax, psi)

Examples

Invocation Expected
=PO.RP.Rod.TaperStress(115000, 25000, 10000, 0.9, "Sa") 30937.5
=PO.RP.Rod.TaperStress(115000, 25000, 10000, 0.9, "Loading") 0.71641791
=PO.RP.Rod.TaperStress(115000, 25000, 10000, 0.9, "Margin") 5937.5
=PO.RP.Rod.TaperStress(90000, 20000, 8000, 1, "Sa") 27000
=PO.RP.Rod.TaperStress(115000, 29768, 15141, 0.8, "Sa") 29813.45
=PO.RP.Rod.TaperStress(115000, 29768, 15141, 0.8, "Loading") 0.996902
=IF(ISNA(PO.RP.Rod.TaperStress(115000, 8000, 10000, 0.9, "Sa")), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda