Does the minimum result equal the design resistance of the complete joint?

No. It is only the minimum of three entered arithmetic screening modes. A complete joint check may require additional connected components, fastener load distribution, edge and block-shear paths, bypass load, eccentricity, fatigue, installation and the governing design code.

Does this worksheet provide ISO material strengths or design coefficients?

No. ISO 14589:2000 and ISO 17057:1999 cover rivet test methods, while ISO 13469:2014 covers qualification of testing procedures for a defined class of joints. The worksheet supplies no ISO design resistance, material allowable, safety factor or acceptance decision.

Why is effective shear area entered directly?

The governing area depends on the specified rivet, shear-plane location and controlled method. Direct entry prevents the worksheet from silently assuming that every plane crosses a full nominal circular shank.

May yield strength be used as net-section tensile stress?

Only if the selected design method explicitly defines that value for that limit state. The former calculator mixed material yield values with an ultimate-capacity label; this worksheet requires the already selected controlled stress or resistance basis.

Controlled component arithmetic

Documented Rivet-Joint Component Resistance Worksheet

Screen three explicitly documented component resistances: fastener shear, bearing of one identified connected component, and tension of one identified net section. The worksheet supplies no material strengths, design factors, hole deductions or claim of complete-joint capacity.

R_s = n z A_s τ_dR_b = n d_b t_b σ_b,dR_n = A_net σ_t,dNon-normative arithmetic screen

Working units

Effective fasteners n (positive integer)

Resistance/stress basis

Fastener shear screen

Effective shear planes per fastener z (positive integer)

Effective shear area per plane A_s (mm²)

Controlled shear stress τ_d (MPa)

Bearing screen for one identified connected component

Controlled projected diameter d_b (mm)

Component thickness t_b (mm)

Controlled bearing stress σ_b,d (MPa)

Net-tension screen for one identified section

Controlled net area A_net (mm²)

Controlled net-tension stress σ_t,d (MPa)

Components, geometry and load distribution

Governing method, edition, clause/table and source revision

I confirm that every area, dimension and stress/resistance value comes from one compatible controlled method and basis; n and z are effective for the documented load path; the bearing values describe one identified connected component; A_net was determined externally from the actual critical section; and I will not treat the minimum as a complete-joint design or apply an additional site-generated safety factor.

Component resistance record

—

Fastener shear screen R_s

—

One-component bearing screen R_b

—

One-section net-tension screen R_n

—

Minimum of entered screens

—

Minimum arithmetic mode

—

Normalized SI inputs

—

Not complete-joint resistance: the minimum covers only the three entered screens. It does not check every connected plate, rivet type or hole condition; edge tear-out, block shear, gross-section yielding, bypass load, group distribution, eccentricity, prying, bending, slip, fatigue, fracture, corrosion, temperature, installation, inspection or code interaction equations.

Arithmetic implemented

R_s = n z A_s τ_d
R_b = n d_b t_b σ_b,d
R_n = A_net σ_t,d
R_screen,min = min(R_s, R_b, R_n)

n is the number of effective fasteners sharing the documented action; z is the effective shear planes per fastener; A_s is the controlled effective shear area per plane; τ_d is the selected shear stress; d_b, t_b and σ_b,d describe projected bearing for one identified connected component; A_net and σ_t,d describe one externally established critical net section.

Dimensional checks in SI: (dimensionless)(dimensionless)(mm²)(N/mm²) = N; (dimensionless)(mm)(mm)(N/mm²) = N; and (mm²)(N/mm²) = N. The worksheet does not derive A_s from nominal diameter, A_net from plate width, or any stress from a generic material name.

Compatibility rule: do not mix characteristic, nominal, allowable and factored design values. If a code defines resistance directly rather than a stress-times-area model, use that code calculation outside this worksheet. Do not add a blanket “factor of safety 2–3”; use the factors and combinations required by the selected method.

Why the result is only a screen

Equal multiplication by n is valid only when n effective fasteners actually share the action as documented. NASA RP-1228 explains that hole clearance and position tolerance can make individual fastener loads unequal before bearing deformation redistributes load. The FAA accident lessons linked below show why row count, edge margin, hole quality, fatigue and the actual load path cannot be replaced by a minimum of three nominal products.

Input/display	Exact or stated conversion	Internal route
Μήκος	1 in = 25.4 mm exactly	All lengths become mm
Area	1 in² = 645.16 mm² exactly	All areas become mm²
Stress	1 ksi = 6.894757293168361 MPa	All stresses become N/mm²
Δύναμη	1 lbf = 4.4482216152605 N	Results are calculated in N and displayed as N, kN and lbf

The inch and pound-force conversions follow NIST SP 811 Appendix B. Inputs are normalized before the three products are evaluated; changing units must not change the physical result.

ISO documents do not create a universal joint formula here

ISO 14589:2000, Edition 1, Blind rivets — Mechanical testing is Published and was confirmed in 2026. ISO 17057:1999, Edition 1, Aerospace — Rivets, solid — Test method is Published and was confirmed in 2021; its scope is a test device and method used with the relevant procurement specification.

ISO 13469:2014, Edition 1 is Published and was confirmed in 2025. It specifies requirements for qualification of testing procedures for form-fit blind-rivet and lock-bolt joints; the tests depend on component performance requirements established beforehand, and its public scope explicitly excludes civil-engineering metal-building and steel-construction applications. The licensed details of these standards remain NEEDS_LICENSED_SOURCE. This page makes no ISO design-resistance or compliance claim.

Public engineering evidence

NASA Reference Publication 1228, Fastener Design Manual (1990, with 2008 errata) describes rivet selection as requiring temperature, corrosion, vibration, fatigue and other considerations. Its fastener-group guidance discusses load redistribution from hole clearance and tolerance; its shear/bearing ratios are explicitly approximations in the absence of specific allowables, not universal current code values. They are therefore not embedded here.

FAA AC 43.13-1B with Change 1 is Active but narrowly scoped to specified aircraft inspection and repair circumstances when manufacturer instructions are absent and the data is directly applicable. Its application-specific rivet tables and reductions are not generalized by this worksheet. The FAA Grumman Turbo Mallard lesson documents deficient edge distances, spacing, hole quality and installation in a catastrophic structural context; the FAA Boeing 747-SR100 lesson documents an incorrect load path that left one row transferring load and led to fatigue failure.

Published numerical arithmetic check

NASA/TM-20230000313, Multirotor Test Bed Load and Stress Analysis (2023), page 56, cites NASA RP-1228 and reports that a 3/8 in fastener with 91 ksi ultimate shear strength carries about 10,050 lbf. The direct circular area π(0.375 in)²/4 is 0.1104466 in²; one plane times 91 ksi gives 10.0506 kip, or 10,050.6 lbf. The independent test artifact reproduces that published arithmetic through this worksheet’s area/stress input path. It validates arithmetic and units only—not a rivet material value or approval for a different joint.

NIST SP 811 Appendix B.8 supplies the unit conversion basis.

Former content or behavior	Problem and correction
“Mild steel,” S355, 6061-T6 and 304 presets	One entered “tensile strength” was used to manufacture shear and bearing values, while several preset values appeared to be yield strengths. Product condition, rivet material, plate material, limit state and design basis were undefined. All material presets were removed.
τ = 0.6σ and bearing = 2σ presented as typical	NASA RP-1228 labels related ratios approximate and material-dependent; the former 2.0 bearing multiplier did not even match its 1.5 approximation. No ratio is now generated. Controlled values must come from the selected code, procurement data or test basis.
Single-shear area multiplied only by rivet count	The former code had no shear-plane input and silently assumed every plane crossed a full nominal shank. The replacement requires z and an effective area per plane.
“Plate tear-out” = (w − n_rowd)tσ	That expression was a simplified straight net-section product, not an edge tear-out or block-shear check. It also used nominal rivet diameter instead of a controlled hole deduction. The replacement accepts externally established A_net and does not claim to calculate tear-out or block shear.
Minimum labelled joint capacity and 50–85% efficiency	Three nominal products cannot establish complete-joint strength or a universal efficiency range. The output is explicitly the minimum of entered screens and never a normative capacity or efficiency rating.
Apply a typical factor of safety 2–3	A blanket factor can conflict with allowable-stress or limit-state methods and load combinations. The replacement records the basis and applies no site-generated factor.
Defaults, quick presets, auto-calculation and partial numeric parsing	These produced plausible-looking results without provenance. The replacement starts blank, requires a controlled source, component/load-path record and confirmation, accepts decimal point/comma, rejects partial/non-finite input, and writes results with textContent.

No. It is only the minimum of three entered arithmetic screens. Check all components, paths, load effects and limit states required by the governing method.

Use the projected diameter defined for that bearing limit state by the controlled method. The worksheet deliberately does not decide whether nominal shank, hole diameter or another effective dimension applies.

No. Enter two only when the actual load path, member arrangement, plane locations and controlled method support two effective planes and the documented distribution.

The public ISO record identifies it as a mechanical-testing standard for blind rivets. This worksheet does not reproduce licensed acceptance details or infer a design allowable from the title. Use the applicable procurement/design documents and verified product data.