Report this item to Etsy

SPC Control Chart Excel Template | X-bar - R - I-MR | Auto Control Limits & Out-of-Control Rules | IATF 16949 iso 9001 Quality Tool

Price:$14.99

You can only make an offer when buying a single item

Highlights

  • Designed by ShopFloorOps
  • Digital download
  • Digital file type(s): 1 File

Stop eyeballing your process. Let the chart tell you when to act.

This is a complete Statistical Process Control workbook in Excel — two chart types, automatic control limits, and built-in out-of-control detection. Enter your measurements and the chart does the math: center lines, ±3σ limits, and an instant OK / OOC verdict on every point. No add-ins, no stats degree.

— — — — — — — — — — — — — — —

WHAT'S INSIDE (6 tabs)

⬢ X-bar & R Chart — for subgroup data (n = 2–5). Auto X-bar, Range, center lines, and control limits using the correct A2 / D3 / D4 constants for your subgroup size. Live Excel charts included.

⬢ I-MR Chart — for individual readings (low-volume, one-piece flow, destructive or batch tests). Auto moving range, control limits, and live charts.

⬢ SPC Dashboard — rolls up both charts: subgroups entered, center lines, limits, out-of-control count, and an at-a-glance IN CONTROL / OUT OF CONTROL state.

⬢ Worked Example — a real 22-subgroup shaft-diameter study with two special-cause points flagged, so you can see exactly what good looks like before you touch your own data.

⬢ Settings — name the process, set subgroup size and (optional) spec limits in one place.

⬢ Instructions — which chart to use, step-by-step, and what each signal means.

— — — — — — — — — — — — — — —

THREE DETECTION RULES BUILT IN

✓ Rule 1 — any point beyond the control limits (3σ)
✓ Rule 2 — 8 points in a row on one side of center (a sustained shift)
✓ Rule 3 — 6 points steadily rising or falling (drift / tool wear)

Each point is flagged automatically with color-coded OK or OOC status — you act on signals, not noise.

— — — — — — — — — — — — — — —

WHY THIS ONE


Built by a shop-floor quality engineer, not a template farm
Correct SPC math (AIAG-aligned X-bar & R and I-MR methods)
Live control charts that update as you type
Robust formulas — add rows at the bottom and everything recalculates
Supports IATF 16949 (9.1.1.1 / 10.2) and ISO 9001 (9.1) monitoring requirements


Note: This is a process stability tool. For Cp/Cpk/Pp/Ppk capability against spec, pair it with QA-F-250 Process Capability Study.

— — — — — — — — — — — — — — —

INSTANT DOWNLOAD — one .xlsx file. Works in Microsoft Excel (desktop) and LibreOffice. Digital product; no physical item shipped. Personal/professional single-shop use.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Be the first to review this item

No reviews yet. See what customers say about other items from this shop.

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 17, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates