SQLite

Project Overview Problem Statement: In high-precision manufacturing, Quality Control (QC) relied on manual data recording from Linear Scales. This led to human errors (typos), lack of traceability, and slow reporting. Furthermore, the client used a massive Excel template filled with complex statistical formulas (CPK, Histogram) to generate reports. The Challenge: The critical technical bottleneck was the Excel Report Generation. Standard libraries (like Interop or standard OpenXML wrappers) failed or crashed because the client’s template file was too large and complex. Opening the file to write data programmatically caused memory overflows and corrupted the complex formulas embedded in the file. ...

Rubber Compounding & Precision Weighing Control System Problem Statement: In the Master Batch (MB) and Carbon Master Batch (CMB) production lines of a leading automotive rubber manufacturer, manual chemical weighing processes were prone to human error. Deviations from the specific rubber formula resulted in quality issues, waste, and a lack of digital traceability. The Challenge: Precision Requirement: The system must interface directly with high-precision scales to ensure chemical weights fall within strict tolerance levels. Network Instability: Production cannot stop even if the factory network/server goes down. Inventory Control: Need real-time stock deduction and validation to prevent incorrect material usage (wrong lot/wrong type). Our Solution: Smart Weighing & Interlock System We developed a robust Windows Forms Application (C# .NET) that acts as the “Process Controller” for the mixing line. The system integrates IT and OT layers to enforce strict process control. ...