Learn Industrial Engineering the practical way
Free articles, Excel templates and calculators on IE, Excel and the garments industry - written from real factory experience.
OFFSET Function in Excel
OFFSET returns a reference shifted by rows and columns from a starting cell.
INDIRECT Function in Excel
INDIRECT converts a text string into a valid cell reference.
HLOOKUP Function in Excel
HLOOKUP searches the first row of a table and returns a value from a specified row.
XLOOKUP Function in Excel
XLOOKUP is the modern replacement for VLOOKUP with more flexibility.
QualityRoot cause analysis in garments: 5 Why, fishbone and CAPA
How to move from "rework it" to "stop it happening": a fishbone example for high DHU, a 5 Why chain, and a corrective and preventive action (CAPA) format that closes the loop.
QualityCommon sewing defects: causes and prevention
Skipped stitch, broken stitch, puckering, open seam, uneven stitch, raw edge, needle holes and stains - what causes each and how to stop it at the machine.
QualityGarment measurement checking: points of measure and tolerance
How to measure a garment correctly, read a measurement chart with tolerances, record results by size, and find the root cause when measurements go out.
QualityAQL sampling inspection explained with the table
How to read the AQL table (ISO 2859-1 / ANSI Z1.4): lot size, inspection level, code letter, sample size and accept/reject numbers - with worked examples.
QualityQuality checkpoints in a garment factory: from fabric to shipment
The seven quality checkpoints, what each one checks, who does it, and why catching a defect one stage earlier saves time and money.
Calculators for everyday IE work
Target, efficiency, line balancing, man machine ratio, machine requirement and time study.
Templates & guides
Excel, PDF and Word files, ready to use. Files marked 🔒 are for members.
Get one practical IE tip every week
Join IE and production professionals learning with in2eff.