I will build automated excel spc cp cpk gage rr doe and 8d quality tools

South Korea

I speak Korean, English

Excel automation for quality, ops and Korea local guides

Hi! I build clean, macro-free Excel and Google Sheets systems for manufacturing quality (SPC, Cp/Cpk, Gage R&R, DOE, 8D), OEE and BOM cost tracking, and operational KPIs. Every formula stays unlocked ...
About this Gig

Automated Excel tools for SPC, capability, MSA and 8D, built around your own measurements instead of a template.

WHAT I BUILD

  • Xbar-R or Xbar-S chart with the correct A2, D3, D4 and d2 constants, plus Cp/Cpk against Pp/Ppk and the drift ratio between them
  • AIAG MSA 4th Ed. Gage R&R: EV, AV, GRR, PV, TV, %GRR, %contribution, ndc and the verdict
  • 2^3 full factorial DOE: effects, sums of squares, % contribution and the optimum recipe
  • 8D/FACA tracker with three-legged 5-Why, poka-yoke evidence and Cpk before and after
  • A one-page dashboard so the weekly quality review reads itself

WHY ME

Formulas are native and unlocked, so your customer or auditor can trace every number back to a measurement. No macros, no protected sheets, no add-ins.

WHAT YOU SEND ME

Your characteristic, USL/LSL, subgroup size, and for Standard or Premium your measurement file (CSV or Excel). I return the workbook, a formula guide and a handover note.

Message me before ordering if you need more than three characteristics or a non-standard design.

Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Formulas

•

Dashboard

•

Charts