Description
This project was done for the "Plansee AG" (located in Reutte/Austria). The goal of the application was to create an "easy to use" and "maintain measurement" application for a very specialized product.
The main focus was put on relating the application as close as possible onto the real work flow. Employees shall be able to enter data as easy as possible. The program was created with permanent feedback from its further users in order to keep it as close as possible to their needs.
The old version was implemented in MS-Access with heavy use of VBA. Some components were created in Excel with a connection to the main Access application.
The Access development started in Summer 2003 and finished in Summer 2006. Since this date the Java Version is under development and was successful introduced in February 2007.


CCFL in a Nutshell
- Measurement system for various measure points
- Checking of invalid entered data
- Logging of all relevant data during the lifetime of a piece
- Creating of various printouts for the product "Begleitbeleg"
- Creating of statistical sampling plans with all relevant process data.
- Monitoring of the production process via a Chart
- Easy editing of entered data
- Printing labels via a label printer (for shipping the product!)
- Creating of various controlling data.
- Creating of bar codes for combined using with SAP and Procella (Commercial Measurement system)


Technical Facts
- MS-Access used as Database (due a restriction from Plansee AG)
- Over 50 000 measurement entries
- Over 20 000 quality control entries
- Access Version
- Heavy integration of Excel (Printing handouts, Reports, creating charts)
- Modular


Programming Languages and Tools:
Java Version
User interface via SWT
Access as back end
JFreeChart for creating charts
POI for creating Excel Printouts


Development:
2006 - 2007