Apparel Sourcing, Textile Engineering & Commodity Trade
Textile Yarn Tex, Denier, Ne & Moisture Regain Formula
Convert Direct Linear Density Tex (g/1,000 m) into Synthetic Filament Denier (9 * Tex) and Indirect English Cotton Count Ne (590.5 / Tex), and calculate ASTM/BISFA Commercial Moisture Regain Invoice Weight.
Never mix up direct filament Denier/Tex with inverse spun English Cotton Count Ne!
Apparel sourcing teams routinely misorder knitting and weaving yarns because synthetic filaments use DIRECT mass-per-length systems—Tex (grams per 1,000 m) and Denier = 9 * Tex (grams per 9,000 m, where a HIGHER number means a THICKER yarn!)—whereas spun staple cotton uses INDIRECT length-per-mass English Cotton Count Ne = 590.5 / Tex (number of 840-yard hanks per pound, where a HIGHER number means a FINER yarn!). Simultaneously, hygroscopic fibers like cotton and wool absorb ambient warehouse humidity: to prevent mills in humid monsoon ports from billing buyers for excess absorbed water, ASTM D1909 / BISFA contracts invoice shipments at Commercial Conditioned Mass = Oven_Dry_Mass * (1 + Official_Regain), flagging Excess Scale Water = Oven_Dry_Mass * (Actual_Regain - Official_Regain)!
Verify on a Combed Cotton Yarn Shipment—Linear_Density = 25.0 Tex (B2), Oven_Dry_Lot_Mass = 1,000 kg (B3), Official_Cotton_Regain = 0.085 (8.5% ASTM standard, B4), and Actual_Warehouse_Regain = 0.105 (10.5% humid port reading, B5): Equivalent Denier is 9 * 25 = 225.00 Denier (E2); Indirect English Cotton Count is 590.5 / 25 = 23.62 Ne (~24s cotton, E3); Commercial Conditioned Invoice Weight is 1,000 * 1.085 = 1,085.00 kg (E4); and Unbillable Excess Water on the warehouse scale is 1,000 * (0.105 - 0.085) = 20.00 kg (E5)!
| Textile Sourcing Metric (25 Tex, 1,000 kg Dry, 8.5% Std Regain, 10.5% Actual) | Formula | Verified Output |
|---|---|---|
| Direct Filament Denier (g/9,000m) | 9 * Tex | 225.00 Denier (112.50 @ 12.5 Tex) |
| Indirect English Cotton Count Ne | 590.5 / Tex (Inverse!) | 23.62 Ne (47.24 Ne @ 12.5 Tex!) |
| Commercial Invoice Weight (kg) | Oven_Dry_kg * (1 + Official_Regain) | 1,085.00 kg |
| Excess Humid Scale Water (kg) | Oven_Dry_kg * (Actual - Official) | +20.00 kg Unbillable Water |
Textile Yarn Count Conversion & Commercial Invoice Mass Formula
Validate Tex > 0, Oven_Dry_Mass > 0, and non-negative regain fractions 0 <= Regain <= 0.50!
=LET(tx_y, B2, dr_m, B3, rg_s, B4, rg_a, B5, IF(OR(tx_y <= 0, dr_m <= 0, rg_s < 0, rg_s > 0.5, rg_a < 0, rg_a > 0.5), "Invalid Yarn Specification", ROUND(dr_m * (1 + rg_s), 2)))Finer-Yarn Inverse Direction Check (Halve Tex to 12.5)
Halve Linear_Density_Tex B2 from 25 to 12.5: direct Denier E2 halves to 112.50, while inverse Cotton Count Ne E3 DOUBLES from 23.62 to 47.24!
=IF(ISTEXT(E4), E4, ROUND(590.5 / B2, 2))Try the example
Use the original values or change them to test your understanding.