Take good data around the world
An
Adept Scientific product story
Edited by the Engineeringtalk editorial team
Nov 18, 2002
Lexmark International produced so much SPC data that its greatest challenge was to make it easy for people throughout its organisation to make proper use of it.
Finally, you've got it right.
It's taken months or even years to perfect your statistical process control (SPC) system.
But now how do you replicate your success at other facilities? The answer: use the Internet to share data with multiple locations.
Lexmark International, a laser-printer toner manufacturer, faced challenges common to global manufacturers: consistent product quality.
Said Mark Watkins, control engineer for the company's Boulder facility: "With our continuous processes, real-time detection of problems is important to prevent production of large amounts of scrap material".
The company wanted to achieve the same level of quality and yields in all facilities.
Watkins indicated Lexmark needed a way to compare and contrast process and quality data among plants.
Keeping yields as high as possible is another issue.
The company needed to meet tight price and product goals.
"With manufacturing today, you keep a lot less material on hand, so there's less room for mistakes", he remarked.
The Boulder plant starts collecting data for SPC/statistical quality control (SQC) analysis with its distributed control system (DCS).
The DCS controls the process and collects data such as temperature, speed, cycle time, and weight.
It tracks data continuously, in real time, for every process and product.
In addition to process data, large amounts of manually entered analytical test data, printer test results performed on the finished toner, yield and rates by shift, and tracking data for every bag of toner produced are collected.
A Sybase SQL server stores three years' worth of process and test data, with older data archived on another machine.
The company discovered that with so much data being collected and stored, its greatest challenge was to make it easy for people throughout the organisation to analyse and use the data for quality monitoring, research and development, and process improvement.
To serve these data sharing needs, Lexmark built an intranet-based solution.
The Windows NT system runs an Apache general web server and a NWA Quality Analyst web server for SPC/SQC charting.
Programs for accessing the database and SPC charts were written in Perl.
The system generates the data file from the Sybase database based on user requests.
It then builds the necessary Analyst Web server header and data files on the fly and asks that server to generate the SPC chart.
The Perl programs connect to the database using open database connectivity (ODBC) Perl libraries and NT Sybase ODBC drivers.
Lexmark chose the Analyst web server because of its connectivity options, based on an open architecture and ability to be connected to any ODBC database.
But the company had to work through a few minor problems with the Analyst web server.
One was system efficiency.
Originally, the company configured the server to access the database for every chart displayed, but the arrangement didn't give it the desired result.
Lexmark wanted to access data once for each user connection, building all the charts in one step.
To do this, the company used the same automation program (the Quality Analyst Run File Interpreter) that the Analyst web server uses - but that caused conflicts.
However, Lexmark, with NWA's assistance, distributed the different automation tasks and avoided the conflicts.
Having successfully implemented web-based SPC, the company's challenge in the immediate future is to use those capabilities globally to help facilities share problems encountered, lessons learned, and innovative solutions.
NWA Quality Analyst software is supplied and supported in the UK and Ireland by Adept Scientific.
Not what you're looking for? Search the site.
Contact Adept Scientific
Tel +44 1462 480055
Other Adept Scientific stories
-
SPC software aids process improvement
Adept Scientific has a new version of Quality Analyst, the comprehensive statistical process control charting and analysis tool from Northwest Analytical. -
Software powers up statistical process control
NWA Quality Analyst Web Server 2.1 is the latest part of NWA's comprehensive SPC software solution. -
Food quality in a pickle
Statistical quality control is a necessary part of modern food processing. -
The case for ISO9000
What role can statistical process control software play in helping organisations to meet ISO9000? -
Quality software aids manufacturing efficiency
When glass-container company Saint-Gobain Containers implemented a company-wide quality programme across its 18 plants, it standardised its quality data management with NWA Quality Analyst.
Browse by category
-
Capital Equipment (3,507)
- Capital Equipment (1)
- Compressors and Air Treatment (537)
- Electrical hardware (131)
- Electronics Manufacturing, Tools, Instruments (192)
- Machinery and Production Equipment (1,128)
- Manufacturing Machinery and Plant Equipment (474)
- Production line blowers and fans (73)
- Robotics, Handling and Storage (971)
- Consultancy and Services (920)
-
Control and Instrumentation (5,117)
- Cabling, Conduit, Signal Conditioning (814)
- CNC and Motion Controllers (189)
- Control and Instrumentation (2)
- HMIs/Operator Interfaces (296)
- Logic Controllers, Timers and Relays (96)
- Mid-range and Large PLCs (203)
- Plant- and Machine-Wide Communications (1,201)
- Plantwide control (1,350)
- Power Supplies, Uninterruptible Power (574)
- Smaller-Sized PLCs (392)
-
Drives, Motors and Controls (3,432)
- Drives, Motors and Controls (2)
- Industrial Drives/Controls (1,290)
- Industrial Motors (501)
- Linear Drives and Motors (120)
- Precision Motors and Gears (429)
- Stepper and Servo Drives, Motors, Controls (1,088)
-
Electrical and Electronic Equipment Design (4,296)
- Batteries, chargers and circuit protection (582)
- Connectors, Terminals, Busbars, Slip Rings (715)
- Electrical and Electronic Components (647)
- Electrical and Electronic Equipment Design (3)
- Electrical and Electronic Subassemblies (374)
- Enclosures and Equipment Cooling Fans (721)
- Knobs, Handles and Enclosure Hardware (430)
- PCs and Embedded Systems (824)
-
Engineering Design Software (6,348)
- 2D CAD software (203)
- 3D CAD software (1,187)
- CAM, CNC, production management software (581)
- Data, document management software (322)
- Electrical design software (166)
- Engineering Design Software (17)
- FEA and structural analysis software (376)
- File conversion software, data capture (358)
- Fluid, thermal, noise, vibration software (339)
- Materials design and moulding design software (152)
- Maths, charting, statistics, QA software (325)
- PLM and collaboration software (663)
- Process, instrumentation, automation software (269)
- Publishing and documentation software (234)
- Rendering, visualisation, styling software (206)
- Simulation, modelling, validation software (950)
-
Engineering Industry News, Resources (6,205)
- Electronic Resources for Engineers (278)
- Engineering Business News, Views (388)
- Engineering Conferences (438)
- Engineering Education, Resources, Standards (850)
- Engineering Exhibitions, Events (575)
- Engineering Guides, Newsletters (365)
- Engineering Industry Developments, Awards (636)
- Engineering Industry News, Resources (4)
- Engineering Industry Reports, Surveys (597)
- Engineering Recruitment, Employment (219)
- Engineering Seminars (415)
- Engineering Training Courses (457)
- Health and Safety Consultancy, Software (180)
- Health and Safety Events, Training, News (285)
- Health and Safety Legislation (403)
- Health and Safety Strategy, Risk Assessment (115)
- Machine Building (4,612)
-
Materials and Processing (3,025)
- Materials and components (2,263)
- Materials and Processing (5)
- Materials processing and testing (291)
- Rapid Prototyping (466)
-
Monitoring, Measurement and Quality (5,639)
- Data Acquisition Hardware and PC I/O Boards (488)
- Data acquisition Software and Communications (505)
- Data loggers (425)
- Electrical and Electronic Testing, PAT Equipment (642)
- Form/co-ordinate, optical, vision instruments (759)
- Gauges, Indicators and Instruments (448)
- Materials testing equipment (431)
- Monitoring, Measurement and Quality (1)
- Telecomms/network test equipment, software etc (158)
- Testing and Calibration Services and Information (518)
- Testing, analysing and monitoring equipment (1,264)
-
Powertrain Design (3,704)
- Bearings (977)
- Chains and belts (333)
- Gears, brakes, couplings and engines (1,474)
- Hydraulic Components (475)
- Lubricants (441)
- Powertrain Design (3)
-
Sensors (7,266)
- Accelerometers and Vibration Sensors (448)
- Barcode Sensors (103)
- Flowmeters and Flow Sensors (641)
- Gas, Chemical, Radiation, Magnetic Sensors (290)
- Humidity and Environmental Sensors (158)
- Level Sensors and Leak Detectors (537)
- Linear Position Sensors (413)
- Loadcells, Force Sensors, Torque Sensors (727)
- Pressure sensors (639)
- Proximity Sensors (712)
- Rotary Position, Tilt and Angular Sensors (560)
- Sensors (10)
- Temperature sensors (621)
- Vision and Colour Sensors (1,407)
- Small Mechanical Components, Joining, Tools (2,037)
- Valves, Pumps, Process Hardware (3,719)
