Data Analysis Tool
Manual inspection and analysis of data can be time-consuming and prone to human error, whereas automated systems can improve efficiency, accuracy, and consistency. However, many commercially available systems are cost-prohibitive and overly complex for specific measurement applications. I set out to develop a purpose-built automated measurement system that would streamline inspections, improve measurement resolution, and eliminate misinterpretation while remaining cost-effective and accessible.
Project Definition
The system needed to be fully automated to reduce operator workload while incorporating error-proofing measures to ensure reliable data collection. Additionally, it had to maintain or improve precision and accuracy over existing manual inspection methods. The output had to clearly indicate a pass/fail status while also preserving raw and analyzed data for future review.
Project Design
The system was built using an ESP32 microcontroller for motor control and data acquisition, interfacing with digital indicators via SPC data ports. The control logic was programmed using the Arduino IDE, while a Python script handled data processing and UI development. A prototype inspection stand was assembled using salvaged materials, and custom PCB interfaces were designed to facilitate reliable communication between components. The measurement process incorporated SVD-based analysis, which normalized and best-fit the collected data, compensating for misalignment while minimizing false rejections due to taper or tilt.
Project Delivery
The prototype successfully automated the inspection process, improving measurement reliability while simplifying data interpretation. The green/red indicator system provided an intuitive visual status, reducing ambiguity. Additionally, the backend preserved both raw and processed data for traceability and additional analysis.
